{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Vibha - Budget ","Asha Silicon Budget 15 - 16"],"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":"Vibha - Budget ","index":0,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":true,"merged":[[35,2,35,3],[32,2,32,3],[29,2,29,3],[30,2,30,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[48,2,48,3],[49,1,49,3],[47,2,47,3],[38,2,38,3],[37,2,37,3],[7,1,7,2],[9,1,10,1],[2,1,2,2],[3,1,3,2],[5,1,5,2],[9,2,10,3],[26,2,26,3],[28,2,28,3],[27,2,27,3],[16,2,16,3],[17,2,17,3],[36,2,36,3],[42,2,42,3],[39,2,39,3],[20,2,20,3],[31,2,31,3],[9,8,9,11],[10,12,11,12],[7,3,7,11],[3,3,3,11],[5,3,5,11],[9,4,10,4],[9,7,10,7],[9,5,10,5],[9,6,10,6],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[40,2,40,3],[41,2,41,3],[34,2,34,3],[33,2,33,3],[18,2,18,3],[19,2,19,3],[23,2,23,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[25,2,25,3]]}
[]
[{"$nulls":4},"              Annual Budget"]
[null,"Summary of Budget"]
[null,"Project Number and Title: ",null,"Educational Activity Centers "]
[]
[null,"Name of the Partner:",null,"Door Step School"]
[]
[null,"Project Period:",null,"April 2015 -March 2016"]
[]
[null,"Budget Code","Particulars /Budget Head",null,"Unit /              No. of Persons ","Unit Cost/ Per Center","No. of Unit/ Center ","Total Budget","Proposed Budget from April 2015 To March 2016"]
[{"$nulls":8},"Qtr - 1","Qtr - 2","Qtr - 3","Qtr - 4","Proposed budget for Vibha (100%)"]
[]
[null,1.0,"PROGRAMME EXPENSES"]
[null,1.1,"Programme Cost"]
[null,"1.1.1","Teaching & Educational Material",null,2000.0,24395.0,40.0,{"$f":"F15*G15","v":"975800"},null,487900.0,487900.0,null,{"$f":"SUM(I15:L15)","v":"975800"}]
[null,"1.1.2","Transport of Children",null,400.0,58080.0,40.0,"2323200",580800.0,580800.0,580800.0,580800.0,"2323200"]
[null,"1.1.3","Picnic/Events",null,2000.0,3250.0,40.0,"130000",null,32500.0,97500.0,null,"130000"]
[null,"1.1.4","Miscellaneous/ Support Activites",null,2000.0,3670.7880000000005,40.0,"146832",36707.880000000005,36707.880000000005,36707.880000000005,36707.880000000005,"146832"]
[null,1.2,"Programme Personnel Cost",{"$nulls":9},"0"]
[null,"1.2.1","Reporting and Communication",null,1.0,11616.0,40.0,{"$f":"F20*G20","v":"464,640"},116160.0,116160.0,116160.0,116160.0,"464640"]
[null,"1.2.2","Quality Assurace staff",null,4.0,21000.0,40.0,"840,000",210000.0,210000.0,210000.0,210000.0,"840000"]
[null,"1.2.3","Supervisor",null,8.0,32520.0,40.0,"1,300,800",325200.0,325200.0,325200.0,325200.0,"1300800"]
[null,"1.2.4","Teacher",null,90.0,195942.0,40.0,"7,837,680",1959420.0,1959420.0,1959420.0,1959420.0,"7837680"]
[null,"1.2.5","Facilitator for site mobilization",null,2.0,8010.0,40.0,"320,400",80100.0,80100.0,80100.0,80100.0,"320400"]
[null,1.3,"STAFF WELFARE",{"$nulls":9},"0"]
[null,"1.2.6","Picnic and events",null,null,1116.0,40.0,{"$f":"F26*G26","v":"44,640"},null,null,44640.0,null,"44640"]
[null,"1.2.7","Mediclaim",null,null,2528.1,40.0,"101,124",null,null,null,101124.0,"101124"]
[null,null,"PROGRAM STAFF SALARIES",{"$nulls":9},"0"]
[null,null,"Sub-total - 1",null,null,{"$f":"SUM(F15:F28)","v":"362,128"},null,{"$f":"SUM(H15:H28)","v":"14,485,116"},"3,308,388","3,828,788","3,938,428","3,409,512","14485116"]
[null,2.0,"ADMINISTRATIVE & MANAGEMENT",{"$nulls":9},"0"]
[null,2.1,"Personnel Cost",{"$nulls":9},"0"]
[null,"2.1.1","Data Management Personnel",null,1.0,6000.0,40.0,{"$f":"F32*G32","v":"240,000"},60000.0,60000.0,60000.0,60000.0,"240000"]
[null,"2.1.2","Accountant",null,0.4,2400.0,40.0,"96,000",24000.0,24000.0,24000.0,24000.0,"96000"]
[null,"2.1.3","Commercial officer (Part Salary)",null,0.2,1200.0,40.0,"48,000",12000.0,12000.0,12000.0,12000.0,"48000"]
[null,"2.1.4","MIS manager (Part Salary)",null,0.2,1800.0,40.0,"72,000",18000.0,18000.0,18000.0,18000.0,"72000"]
[null,"2.1.5","HR personnel",null,0.4,3600.0,40.0,"144,000",36000.0,36000.0,36000.0,36000.0,"144000"]
[null,"2.1.6","Office Supervisor",null,0.4,3000.0,40.0,"120,000",30000.0,30000.0,30000.0,30000.0,"120000"]
[null,2.2," Office and other Administrave Exp.",{"$nulls":9},"0"]
[null,"2.2.1","Consumables & Utilities",null,null,940.0,40.0,{"$f":"F39*G39","v":"37,600"},9400.0,9400.0,9400.0,9400.0,"37600"]
[null,"2.2.2"," Printing & Stationery",null,null,1200.0,40.0,"48,000",12000.0,12000.0,12000.0,12000.0,"48000"]
[null,"2.2.3"," Postage and communication",null,null,1200.0,40.0,"48,000",12000.0,12000.0,12000.0,12000.0,"48000"]
[null,"2.2.4","Office Rent (Part Payment)",null,null,1800.0,40.0,"72,000",18000.0,18000.0,18000.0,18000.0,"72000"]
[null,null,"Sub-total - 2",null,null,{"$f":"SUM(F32:F42)","v":"23,140"},40.0,{"$f":"SUM(H32:H42)","v":"925,600"},"231,400","231,400","231,400","231,400","925600"]
[null,3.0,"CAPITAL / ASSETS",{"$nulls":9},"0"]
[null,"3.1.1",null,null,{"$f":"D45*C45","v":"0"},"0","0","0","0","0","0","0","0"]
[null,"3.1.2",null,null,{"$f":"D46*C46","v":"0"},"0","0","0","0","0","0","0","0"]
[null,"3.1.3",null,null,{"$f":"D47*C47","v":"0"},"0","0","0","0","0","0","0","0"]
[{"$nulls":4},{"$f":"D48*C48","v":"0"},"0","0","0","0","0","0","0","0"]
[null,null,"Sub-total - 3",null,null,{"$f":"SUM(F45:F48)","v":"0"},null,{"$f":"SUM(H45:H48)","v":"0"},"0","0","0","0","0"]
[null,"Total Budget (1+2+3)",null,null,null,{"$f":"F49+F43+F29","v":"385,268"},40.0,{"$f":"H49+H43+H29","v":"15,410,716"},"3,539,788","4,060,188","4,169,828","3,640,912","15410716"]
[null,null,"`"]

{"sheet":"Asha Silicon Budget 15 - 16","index":1,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[16,2,16,3],[15,2,15,3],[9,4,10,4],[9,1,10,1],[9,2,10,3],[7,1,7,2],[7,3,7,9],[9,6,10,6],[9,5,10,5],[22,2,22,3],[23,2,23,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[9,7,10,7],[12,2,12,3],[9,9,11,9],[9,8,11,8],[14,2,14,3],[13,2,13,3],[5,1,5,2],[5,3,5,9],[1,1,1,9],[2,1,2,2],[3,1,3,2],[40,2,40,3],[41,2,41,3],[31,2,31,3],[30,2,30,3],[36,2,36,3],[37,2,37,3],[28,2,28,3],[29,2,29,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[32,2,32,3],[27,2,27,3],[26,2,26,3],[25,2,25,3],[24,2,24,3],[18,2,18,3],[17,2,17,3],[48,2,48,3],[49,2,49,3],[50,1,50,3],[44,2,44,3],[43,2,43,3],[39,2,39,3],[47,2,47,3],[46,2,46,3],[45,2,45,3],[38,2,38,3]]}
[]
[null,"Annual Budget"]
[null,"Summary of Budget"]
[null,"Project Number and Title: ",null,"Educational Activity Centers - Project Foundation"]
[]
[null,"Name of the Partner:",null,"Door Step School,  Pune , India"]
[]
[null,"Project Period:",null,"April 2015 -March 2016"]
[]
[null,"Budget Code","Particulars /Budget Head",null,"   No. of Persons for 10 centers","Unit Cost/ Per Center","No. of Unit/ Center ","Total Budget","Proposed budget for Asha Silicon Valley (100%)","Proposed budget for Asha Silicon Valley (63%)"]
[]
[]
[null,1.0,"PROGRAMME EXPENSES"]
[null,1.1,"Programme Cost"]
[null,"1.1.1","Teaching & Educational Material",null,null,24395.0,10.0,{"$f":"F15*G15","v":"  243,950 "},243950.0,{"$f":"I15*0.63","v":"  153,689 "}]
[null,"1.1.2","Transport of Children",null,70.0,35000.0,10.0,"  350,000 ",350000.0,"  220,500 "]
[null,"1.1.3","Picnic/Events",null,null,3250.0,10.0,"  32,500 ",32500.0,"  20,475 "]
[null,"1.1.4","Miscellaneous/ Support Activites",null,null,3670.7880000000005,10.0,"  36,708 ",36707.880000000005,"  23,126 "]
[null,1.2,"Programme Personnel Cost",{"$nulls":5},0.0,"  -   "]
[null,"1.2.1","Reporting and Communication",null,{"$f":"10*1/40","v":"0.25"},11616.0,10.0,null,null,"  -   "]
[null,"1.2.2","Quality Assurace staff",null,{"$f":"10*4/40","v":"1.00"},21000.0,10.0,{"$f":"F21*G21","v":"  210,000 "},210000.0,"  132,300 "]
[null,"1.2.3","Supervisor",null,{"$f":"10*8/40","v":"2.00"},32520.0,10.0,"  325,200 ",325200.0,"  204,876 "]
[null,"1.2.4","Teacher",null,23.0,195942.0,10.0,"  1,959,420 ",1959420.0,"  1,234,435 "]
[null,"1.2.5","Facilitator for site mobilization",null,{"$f":"10*2/40","v":"0.50"},8010.0,10.0,"  80,100 ",80100.0,"  50,463 "]
[null,1.3,"STAFF WELFARE",{"$nulls":5},0.0,"  -   "]
[null,"1.2.6","Picnic and events",null,null,1116.0,10.0,{"$f":"F26*G26","v":"  11,160 "},11160.0,"  7,031 "]
[null,"1.2.7","Mediclaim",null,null,2528.1,10.0,"  25,281 ",25281.0,"  15,927 "]
[null,null,"PROGRAM STAFF SALARIES"]
[null,null,"Sub-total - 1",null,null,{"$f":"SUM(F15:F28)","v":"339,048"},null,{"$f":"SUM(H15:H28)","v":"  3,274,319 "},"  3,274,319 ","  2,062,821 "]
[null,2.0,"ADMINISTRATIVE & MANAGEMENT"]
[null,2.1,"Personnel Cost",{"$nulls":5},0.0,{"$f":"I31*0.63","v":"  -   "}]
[null,"2.1.1","Data Management Personnel",null,0.25,{"$f":"1800*2","v":"3,600"},10.0,{"$f":"F32*G32","v":"  36,000 "},36000.0,"  22,680 "]
[null,"2.1.2","Accountant (Part Salary)",null,0.1,2400.0,10.0,"  24,000 ",24000.0,"  15,120 "]
[null,"2.1.3","Commercial officer (Part Salary)",null,0.05,1200.0,10.0,"  12,000 ",12000.0,"  7,560 "]
[null,"2.1.4","MIS manager (Part Salary)",null,0.05,1800.0,10.0,"  18,000 ",18000.0,"  11,340 "]
[null,"2.1.5","HR personnel (Part Salary)",null,0.1,3600.0,10.0,"  36,000 ",36000.0,"  22,680 "]
[null,"2.1.6","Office Supervisor (Part Salary)",null,0.1,3000.0,10.0,"  30,000 ",30000.0,"  18,900 "]
[null,2.2," Office and other Administrave Exp.",{"$nulls":5},0.0,"  -   "]
[null,"2.2.1","Consumables & Utilities",null,null,940.0,10.0,{"$f":"F39*G39","v":"  9,400 "},9400.0,"  5,922 "]
[null,"2.2.2"," Printing & Stationery",null,null,1200.0,10.0,"  12,000 ",12000.0,"  7,560 "]
[null,"2.2.3"," Postage and communication",null,null,1200.0,10.0,"  12,000 ",12000.0,"  7,560 "]
[null,"2.2.4","Office Rent (Part Payment)",null,null,1800.0,10.0,"  18,000 ",18000.0,"  11,340 "]
[null,"2.2.5","Head office expenses",null,null,13000.0,10.0,"  130,000 ",42250.0,"  26,618 "]
[null,null,"Sub-total - 2",null,null,{"$f":"SUM(F32:F42)","v":"20,740"},10.0,{"$f":"SUM(H32:H42)","v":"  207,400 "},"  207,400 ","  130,662 "]
[null,3.0,"CAPITAL / ASSETS",{"$nulls":5},0.0,0.0]
[null,"3.1.1",null,null,{"$f":"D46*C46","v":"  -   "},"  -   ","  -   ","  -   ",0.0,0.0]
[null,"3.1.2",null,null,{"$f":"D47*C47","v":"  -   "},"  -   ","  -   ","  -   ",0.0,0.0]
[null,"3.1.3",null,null,{"$f":"D48*C48","v":"  -   "},"  -   ","  -   ","  -   ",0.0,0.0]
[{"$nulls":4},{"$f":"D49*C49","v":"  -   "},"  -   ","  -   ","  -   ",0.0,0.0]
[null,null,"Sub-total - 3",null,null,{"$f":"SUM(F46:F49)","v":"0"},null,{"$f":"SUM(H46:H49)","v":"  -   "}]
[null,"Total Budget (1+2+3)",null,null,null,{"$f":"F50+F44+F29","v":"359,788"},10.0,{"$f":"H50+H44+H29","v":"  3,481,719 "},{"$f":"I29+I44","v":"  3,481,719 "},{"$f":"I51*0.63","v":"  2,193,483 "}]
[null,null,"`",{"$nulls":6},{"$f":"176191+J51","v":"  2,369,674 "}]