{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Finance report","Receipts"],"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":"Finance report","index":0,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,1,47,2],[47,3,47,12],[48,1,48,2],[48,3,48,12],[34,1,34,4],[44,1,44,2],[45,1,45,2],[45,3,45,12],[46,1,46,2],[46,3,46,12],[37,1,37,4],[38,1,38,4],[39,1,39,4],[35,1,35,4],[36,1,36,4]]}
[]
[null,"Door Step School"]
[null,"Cost Centre: Asha Silicon Valley"]
[null,"Period: April 2013 to March 2014"]
[null,"Amount Received from Asha Silicon Valley : ",null,"INR 2035000"]
[]
[]
[null,"Particulars","Estimated Budget ","April","May","June","July","Aug.","Sept.","Oct.","Nov.","Dec.","Jan.","Feb.","Mar.","Total"]
[null,null,"(INR)"]
[null,"Management Cost"]
[null,"Management Salary",83496,7775,7775,8533,8979,4363,4343,8532,8532,8532,6044,6044,6044,{"$f":"SUM(D11:O11)","v":85496}]
[]
[null,"Administration"]
[null,"Other Expenses",237187,4325,9740,14304,9868,4262,10709,20813,23393,21730,25139,27142,65762,{"$f":"SUM(D14:O14)","v":237187}]
[]
[null,"Programme Expenses"]
[null,"Teaching and Educational",120000,810,1537,4390,672,4242,12542,2473,14816,10096,36267,5051,4396,{"$f":"SUM(D17:O17)","v":97292}]
[null,"Transport",275000,null,7000,21000,33000,25500,28875,31080,31260,37080,36645,31920,26880,310240]
[null,"Picnic & Events",25000,0,0,0,0,2448,0,0,9264,630,2359,500,0,15201]
[null,"Miscellaneous",10000,0,600,2337,800,698,{"$f":"122+1070","v":1192},210,3106,584,1755,63,20,11365]
[null,"Teachers Salaries",1456128,107827,118256,120634,136620,124711,{"$f":"622+127358+833","v":128813},{"$f":"124127+500","v":124627},126490,{"$f":"124507+488","v":124995},{"$f":"133769+777+1707","v":136253},{"$f":"130294+517","v":130811},{"$f":"122815+1467","v":124282},1504319]
[null,"Coordinator",159528,13154,13122,12873,14530,13987,14849,14830,15676,12873,14152,15899,14095,170040]
[null,"Supervisor",216768,16902,14589,15787,19142,17778,18335,18519,18823,16386,18277,18669,18628,211835]
[]
[null,"Staff Welfare"]
[null,"Mediclaim of Staff"]
[null,"Coordinators",450,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D27:O27)","v":0}]
[null,"Supervisors",900,0,0,0,0,0,0,0,0,0,0,0,1579,{"$f":"SUM(D28:O28)","v":1579}]
[null,"Teachers",16200,0,0,0,0,0,0,0,0,0,0,0,19719,{"$f":"SUM(D29:O29)","v":19719}]
[null,"Staff Events",8400,0,3056,170,0,624,80,70,0,1006,0,380,70,{"$f":"SUM(D30:O30)","v":5456}]
[null,"Total",{"$f":"SUM(C11:C30)","v":2609057},150793,175675,200028,223611,198613,219738,{"$f":"SUM(J11:J30)","v":221154},251360,233912,276891,236479,281475,{"$f":"SUM(P11:P30)","v":2669729}]
[]
[]
[]
[null,"A. Amount Received from Asha Silicon Valley",null,null,null,{"$f":"Receipts!F8","v":2035000}]
[null,"B. Amount may Received from Builders",null,null,null,1305979]
[null,"C. Funds received from Education Board for transport",null,null,null,89710]
[null,"D. Available Funds",null,null,null,{"$f":"F35+F36+F37","v":3430689}]
[null,"E. Total Expenses ",null,null,null,{"$f":"P31","v":2669729}]
[null,"F. A+B+C-D  Balance Amount",null,null,null,{"$f":"F38-F39","v":760960}]
[]
[]
[]
[]
[null,"Notes:"]
[null,"Teaching and educatinal material",null,"Teaching and educational material supported by other donors. Hence the funds are partially utilised."]
[null,"Transport",null,"This year we incurred Rs. 420 per child per month  for school transport. The budgeted amount was Rs.275 per child per month. The acutal expenses is more than the budgeted expenses to the tune of Rs. 145 per child per month. Hence actual expense incurred for transport is in excess of the budgeted amount."]
[null,"Picnic and Events",null,"During the picnics the tasnport was provided by Door Step Schools vehicles instead of the private vehicles.  Hence the cost is less than the budgeted amount."]
[null,"Surplus amount",null,"We will like to draw your attention to the balance amount of Rs. 760960/- with us. The reason for this is at the time of submitting the budget we were discussing with the education board for giving us full or partial the transport expense. There was no commitment from their part at that time. Through our efforts we are succeeded and received the amount of Rs. 89710/- towards the school transport cost. Beside this we have garnered from the builders amount of Rs. 1305979/- which is in excess of our estimated amount of Rs. 574002/-Presently we have 760960/- amount with us."]

{"sheet":"Receipts","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,9]]}
[]
[]
[]
[]
[]
[null,"Receipt Details"]
[null,"Receipt no","Day","Month","Year","Amount Received in Rs.","Title","Name","Type of Organization","Program"]
[null,319,19,"Nov.",2013,2035000,"M/s.","Asha for Education (Asha Silicon)","Grant","EAC"]