{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Details"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[22,0,28,6],[1,0,1,6],[2,1,2,2],[2,3,2,5],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,5],[13,1,13,3],[7,6,9,8],[5,1,5,2],[5,3,5,5],[6,1,6,2],[6,3,6,5],[7,1,7,2],[8,1,8,2],[7,3,7,5],[17,8,19,8],[17,6,19,6],[10,1,10,2],[10,3,10,5],[8,3,8,5],[9,1,9,2],[9,3,9,5],[17,7,19,7]]}
["","","","","","","","","","","","","",""]
[{"$f":"CONCATENATE(\"Hindu Swayamsevak Sangh USA\n\nShree Guru Dakshina Utsav \",B42)","v":"Hindu Swayamsevak Sangh USA\n\nShree Guru Dakshina Utsav 2017"},"","","","","","",null,"",null,"","","",""]
["","Shakha Name",null,null,null,null,"","Shakha Karyavha","Shakha Mukhya Sikshak",null,"","","",""]
["","Sambhag",null,null,null,null,"Name",null,null,"","","","",""]
["","Utsav Date",null,null,null,null,"Email",null,"","","","","",""]
["","Utsav Location & Address",null,null,null,null,"Phone Number",null,null,"","","","",""]
["","Speaker Name",null,null,null,null,"","","","","","","",""]
["","Speaker Address \n& Contact info",null,null,null,null,"Please fill out information about the ustav on this page and then enter details of the all pujak's on Detail sheet (irrespective of amount). After balancing your checks/cash with the Summary, please email the spreadsheet immediately to your Sambhag Vyavastha Pramukh and Sambhag Karyavaha at the email address shown below (will appear after you enter your Shambhag). They will advise you about deposting the check/cash.",null,null,null,"","","",""]
["","Chief Guest Name",null,null,null,null,null,null,null,"","","","",""]
["","Chief Guest Address \n& Contact info",null,"",null,null,null,null,null,"","","","",""]
["","",null,"",null,null,"","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","Summary",null,null,"","","Shambhag >>>","Vyavastha Pramukh","Karyavaha","","","","",""]
["","","Pujak Count","Amount","","","Name",{"$f":"IF($D$4>\" \",VLOOKUP($D$4,$B$47:$G$55,2,FALSE),\"\")","v":""},{"$f":"IF($D$4>\" \",VLOOKUP($D$4,$B$47:$G$55,6,FALSE),\"\")","v":""},"","","","",""]
["","Check",{"$f":"DCOUNTA(Details!$B$2:$D$177,Details!$B$2,B$43:B$44)","v":0},{"$f":"DSUM(Details!$C$2:$D$177,Details!$C$2,B$43:B$44)","v":0},"","","Email",{"$f":"IF($D$4>\" \",VLOOKUP($D$4,$B$47:$G$55,3,FALSE),\"\")","v":""},{"$f":"IF($D$4>\" \",VLOOKUP($D$4,$B$47:$H$55,7,FALSE),\"\")","v":""},"","","","",""]
["","Cash",{"$f":"DCOUNTA(Details!$B$2:$D$177,Details!$B$2,C$43:C$44)","v":0},{"$f":"DSUM(Details!$C$2:$D$177,Details!$C$2,C$43:C$44)","v":0},"","","Phone",{"$f":"IF($D$4>\" \",VLOOKUP($D$4,$B$47:$G$55,4,FALSE),\"\")","v":""},{"$f":"IF($D$4>\" \",VLOOKUP(D4,B47:I55,8,FALSE),\"\")","v":""},"","","","",""]
["","Pushp",{"$f":"DCOUNTA(Details!$B$2:$D$177,Details!$B$2,D$43:D$44)","v":0},{"$f":"DSUM(Details!$C$2:$D$177,Details!$C$2,D$43:D$44)","v":0},"","","Address",{"$f":"IF($D$4>\" \",VLOOKUP($D$4,$B$47:$G$55,5,FALSE),\"\")","v":""},"","","","","",""]
[null,"Gangajali",{"$f":"DCOUNTA(Details!$B$2:$D$177,Details!$B$2,E$43:E$44)","v":0},{"$f":"DSUM(Details!$C$2:$D$177,Details!$C$2,E$43:E$44)","v":0}]
["","Total",{"$f":"+C16+C17+C18+C19","v":0},{"$f":"+D16+D17+D18+D19","v":0},"","",null,null,null,"","","","",""]
["","","","","","","","","","","","","",""]
[null,"Notes/Comments",null,"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["Year",2017,"","","","","","","","","","","",""]
["","Check/Cash","Check/Cash","Check/Cash","Check/Cash","","","","","","","","",""]
["","Check","Cash","Pushp","Gangajali","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","Shambhag","Name","Email","Phone","Address","Karyavaha Name","Karyavaha Email","Karyavaha Phone","","","","",""]
[null,"Central Pacific","Kaushal Varshney","kaushalv@hotmail.com ","(408) 464-2125","3068 Mckinley Dr\nSanta Clara, CA 95051","Sanjay Tripathi","tripathisan@gmail.com ","(408) 507-7643"]
["","Mid West","Dharmendra Pokharna","dpokharna@yahoo.com ",6304087227,"6885 Sorrento St.\nOrlando FL 32819\n","Murli Reddy","m_mkreddy@yahoo.com","(309) 287-3307","","","","",""]
["","North East","Avinash Pethe","avinashpethe@gmail.com",5713589310,"7208 Sanford Ct\nAnnandale VA 22003","Dr. Sai Patil","SaiPatil.hss@gmail.com","(914) 310-7920","","","","",""]
[null,"North West","Jayant Pant","strategy.jp@gmail.com ","(425) 954-6406","3110 Eggers Drive\nFremont, CA, 94536","Krishnamurthy Woonnimani","wkmurthy@gmail.com ","(303) 547-2072"]
["","Pacific Southwest","Sanjiv Pimple","sanjivpimple@gmail.com ","(949) 245-9641","51 Appleglen Dr.\nIrvine, CA, 92602","Sabitha Hebbar","sabithahebbar@hotmail.com ","(562) 394-8918",null,"","","",""]
["","South East","Ravi Narumunchi","sevyavastha@gmail.com",6789357045,"4805 West Village Way Se, Apt 1201\nSmyrna, GA, 30080","Shekhar Joshi","shekhargj@yahoo.com","(919) 637-6682",null,"","","",""]
["","South West","Hemanta Vaidya","hemantavaidya@gmail.com ","(281) 495-2946","13411 Orchard Harvest Dr\nRichmod TX 77407","Arun Sharma","amanayush@gmail.com","(713) 254-5293","","","","",""]
["","National","Sanjeev Sharma","vyavastha@hssus.org","(925) 951-3460","121 Hawthorne Ct, \nRockaway NJ 07866","Yelloji Mirajkar","mirajkary@yahoo.com","(732) 319-1634",null,"","","",""]
["","","","","","","","","",null,"","","",""]
["","","","","","","","","","","","","",""]

{"sheet":"Details","index":1,"n_rows":177,"n_cols":13,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(\"Shree Guru Dakshina Utsav \",Summary!B42,\" - \",Summary!D3,\" (\",Summary!D4,\")\")","v":"Shree Guru Dakshina Utsav 2017 -  ()"}]
["Sno.","Name","Amount","Check/Cash","Check No.","Email Address","Address","City","State","Zip","Home Phone","Alt. Phone","Notes/Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]