{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["ASV Report April to March 13","Receipt Details"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"ASV Report April to March 13","index":0,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,2,39,9],[38,2,38,9],[36,2,36,9],[37,2,37,9],[31,1,31,4],[32,1,32,4],[33,1,33,4]]}
[]
[]
[null,"Door Step School"]
[null,"Cost Centre: Asha Silicon Valley"]
[null,"1st April 2012 to 31st March 2013"]
[null,"Estimated Budget (INR)",2348000]
[null,"Amount Received (INR) : ",{"$f":"'Receipt Details'!G8+'Receipt Details'!G9","v":1911715}]
[]
[null,"Particulars","Annual Estimated Budget","April","May","June","July","August","September","October","November","December","January","February","March","Total"]
[null,null,"(INR)"]
[null,"Management Cost"]
[null,"Management Salary (part cost)",75900,6325,6325,6325,6325,6325,6325,6325,6325,6325,6325,6325,6325,{"$f":"SUM(D12:O12)","v":75900}]
[null,"STAFF WELFARE"]
[null,"Mediclaim"]
[null,"Supervisors and Coordinators",450,0,0,0,0,0,0,{"$nulls":6},{"$f":"SUM(D15:O15)","v":0}]
[null,"Teachers",16200,0,0,0,0,0,0,0,0,0,0,0,16024,{"$f":"SUM(D16:O16)","v":16024}]
[null,"Staff Event",8400,{"$f":"SUM(D15:D16)","v":0},736,0,0,{"$f":"SUM(H15:H16)","v":0},110,247,440,110,110,0,0,{"$f":"SUM(D17:O17)","v":1753}]
[null,"PROGRAM EXPENSES"]
[null,"Teachers Salaries",1339200,120240,100571,102577,102732,108794,114761,120366,133918,131335,100405,95724,95713,{"$f":"SUM(D19:O19)","v":1327136}]
[null,"Coordinator Salaries",138919,9607,10091,10028,10741,12482,11322,11402,10023,12182,13724,13988,13915,{"$f":"SUM(D20:O20)","v":139505}]
[null,"Supervisors Salaries",188487,14036,14210,14150,14779,17095,16082,16063,16039,15627,16086,16635,16118,{"$f":"SUM(D21:O21)","v":186920}]
[null,"Teaching & Educational Material",84480,2120,10,11376,6085.45,19414,4219,214,2708,121,18434,357,494,{"$f":"SUM(D22:O22)","v":65552.45}]
[null,"Picnic/Events",22000,0,0,0,0,2302,0,200,9447,1175,1700,590,0,{"$f":"SUM(D23:O23)","v":15414}]
[null,"Miscellaneous",8800,0,{"$f":"2932.5+600","v":3532.5},{"$f":"966+600","v":1566},{"$f":"530+600","v":1130},{"$f":"969+600","v":1569},{"$f":"916+600","v":1516},1772,620,1300,697,7016,1200,{"$f":"SUM(D24:O24)","v":21918.5}]
[null,"Transport ",250000,25800,0,20100,{"$f":"20100+90","v":20190},25200,25200,{"$f":"3000+5000+3000+6000","v":17000},{"$f":"3000+5000+3000+5100","v":16100},{"$f":"4433+3333+1000+4500","v":13266},{"$f":"2000+7000+2000+5700","v":16700},{"$f":"10000+7000+3000+6600","v":26600},{"$f":"20000+7000+3000+11400","v":41400},{"$f":"SUM(D25:O25)","v":247556}]
[null,"ADMINISTRATIVE EXPENSES"]
[null,"Telephone, stationary, postage, admin staff and other organizational costs @ approx 10% of Total of I+ II+III",213373.56900000002,{"$f":"C27/12","v":17781.13075},17781.13075,17781.13075,17781.13075,17781.13075,17781.13075,2670,2670,2670,2670,2670,2671,{"$f":"SUM(D27:O27)","v":122707.78449999999}]
[null,"Grand Total I+ II+III+IV( Rounded)",{"$f":"SUM(C12:C27)","v":2346209.5690000001},{"$f":"SUM(D12:D27)","v":195909.13075000001},{"$f":"SUM(E12:E27)","v":153256.63075000001},{"$f":"SUM(F12:F27)","v":183903.13075000001},{"$f":"SUM(G12:G27)","v":179763.58075000002},{"$f":"SUM(H12:H27)","v":210962.13075000001},{"$f":"SUM(I12:I27)","v":197316.13075000001},{"$f":"SUM(J12:J27)","v":176259},{"$f":"SUM(K12:K27)","v":198290},{"$f":"SUM(L12:L27)","v":184111},{"$f":"SUM(M12:M27)","v":176851},{"$f":"SUM(N12:N27)","v":169905},{"$f":"SUM(O12:O27)","v":193860},{"$f":"SUM(P12:P27)","v":2220386.7345000003}]
[]
[]
[]
[null,"A. Funds Received from by Asha Silicon Valley",null,null,null,{"$f":"'Receipt Details'!G8+'Receipt Details'!G9","v":1911715}]
[null,"B. Total Expenses ",null,null,null,{"$f":"P28","v":2220386.7345000003}]
[null,"C. Balance collected with the help of builders and other individual donors ( B -A)",null,null,null,{"$f":"F33-F32","v":308671.73450000025}]
[]
[]
[null,"Notes:"]
[null,"1. Staff welfare:","Staff event program has been supported by other donors. Hence the funds are unutilized."]
[null,"2. Mediclaim:","Part of the mediclaim cost is recovered from the salary of the employees and remaining cost is borne by our Funding Partners."]
[null,"3. Administrative Expenses:","The actual administrative expenditure is less than the budgeted amount. Hence the funds are partially utilized."]

{"sheet":"Receipt Details","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,2,5,10]]}
[]
[]
[]
[]
[]
[null,null,"Receipt Details"]
[null,null,"Receipt no","Day","Month","Year","Amount Received in Rs.","Title","Name","Type of Organization","Program"]
[null,null,237,30,"May",2012,958034,"M/s.","Asha Silicon Valley","Grant","EAC"]
[null,null,267,3,"Jan.",2013,953681,"M/s.","Asha Silicon Valley","Grant","EAC"]