{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Budget 2015","Info on kids","Budget 14","Sheet3"],"not_rendered":{"charts":0,"images":2,"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":"Budget 2015","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,2,48,5],[44,9,44,10],[1,0,1,1],[3,0,3,1],[4,0,4,1],[44,6,44,7]]}
[]
["POPULAR EDUCATION AND ACTION CENTRE"]
[]
["BUDGET FOR NAVJAGRITI  COLLECTIVE EDUCATIONAL PROGRAMME"]
["April 1, 2015 to March 31, 2016"]
[]
[{"$nulls":6},"US $ 1 = INR 60"]
[]
["S.No.","BUDGET  ITEMS","Physical","Unit","No. of","Unit ","Total","Total","Remarks"]
[null,null,"Requirement","Defination","Unit","Cost","(in INR)","(in US $)",null,2014,"Increase","% Increase"]
["A","PROGRAMME COSTS"]
[1,"Educational Material",55,"month",12,50,{"$f":"+C12*E12*F12","v":33000},{"$f":"+G12/60","v":550},"out of the 63 children; 55 are going to school and 08 are non-schooling",30600,{"$f":"G12-J12","v":2400},{"$f":"((G12-J12)/J12)*100","v":7.8431372549019605},"increase of 4 children"]
[null,"(paper, pen, pencil, sharpner, eraser etc. for 63 children)",8,"month",12,30,{"$f":"+C13*E13*F13","v":2880},{"$f":"+G13/60","v":48},null,4320,{"$f":"G13-J13","v":-1440},{"$f":"((G13-J13)/J13)*100","v":-33.333333333333329}]
[2,"Educational Trip",63,"Trip",1,650,{"$f":"C14*E14*F14","v":40950},{"$f":"+G14/60","v":682.5},"the cost is more then estimated which will be either raise during the trip",66300,-25350,-38.235294117647058]
[null,"(travel, food, venue, stationery, etc. for 63 children & fee for resource person)",{"$nulls":6},"or approach the concern institute to provide the staying & venue free of cost during the trip",null,{"$f":"G15-J15","v":0}]
[3,"Educational Workshop",63,"workshop",2,350,{"$f":"+C16*E16*F16","v":44100},{"$f":"+G16/60","v":735},"the cost is more then estimated which will be either raise during the trip",44100,0,0]
[null,"(travel, food, venue, stationery, etc. for 63 children & fee for resource person)",{"$nulls":6},"or approach the concern institute to provide the staying & venue free of cost during the trip",null,0]
[4,"Child Care Expenses",63,"days",313,17,{"$f":"+C18*E18*F18","v":335223},{"$f":"+G18/60","v":5587.05},"out of 365 days; we have excluded the Sunday during the year",335223,0,0]
[null,"(food, medician,hair cutting,cloths,",{"$nulls":8},0]
[null,"Shoses stching,washing,grocery etc.)",{"$nulls":8},0]
[5,"Transportation (School Van)",2,"month",12,6000,{"$f":"+C21*E21*F21","v":144000},{"$f":"+G21/60","v":2400},"Charges for one school van from Smart Cube",72000,72000,100,"two buses"]
[6,"Education Expenses (51 children)",{"$nulls":8},0]
[null,"- School Fees",55,"month",12,275,{"$f":"+C23*E23*F23","v":181500},{"$f":"+G23/60","v":3025},"local contribution from Smart Cube & Gigraj Kishory Lal Chaaritable Trust",168300,13200,7.8431372549019605,"increase of 4 children"]
[null,"- School Uniform",55,"year",1,550,{"$f":"+C24*E24*F24","v":30250},{"$f":"+G24/60","v":504.16666666666669},null,28050,2200,7.8431372549019605,"increase of 4 children"]
[7,"Staff Salaries & Honorarium",{"$nulls":8},0]
[null,"- Coordinator",1,"month",12,7000,{"$f":"+C26*E26*F26","v":84000},{"$f":"+G26/60","v":1400},null,78000,6000,7.6923076923076925]
[null,"- Teacher (Full Time)",1,"month",12,9000,108000,1800,null,102000,6000,5.8823529411764701]
[null,"- Teacher ( Part Time) ",2,"month",12,4000,96000,1600,null,84000,12000,14.285714285714285]
[null,"- Teacher (Coaching Centre)",1,"month",12,3900,46800,780,"local contribution from friend",46800,0,0]
[null,"- Field Teacher (Activities)",1,"month",12,2500,30000,500,null,30000,0,0]
[null,"- Care-taker",1,"month",12,3500,42000,700,null,42000,0,0]
["B","ADMINISTRATIVE COSTS",{"$nulls":8},0]
[1,"Office Coordinator/Accounts",1,"lumpsum",1,20000,{"$f":"+C33*E33*F33","v":20000},{"$f":"+G33/60","v":333.33333333333331},null,20000,0,0]
[2,"Office Rent & Electricity",1,"month",12,16500,{"$f":"+C34*E34*F34","v":198000},{"$f":"+G34/60","v":3300},null,198000,0,0]
[3,"Local Travel",1,"month",12,3000,{"$f":"+C35*E35*F35","v":36000},{"$f":"+G35/60","v":600},null,30000,6000,20]
[4,"Communication & Postage",1,"month",12,2500,{"$f":"+C36*E36*F36","v":30000},{"$f":"+G36/60","v":500},"local contribution from Smart Cube & Gigraj Kishory Lal Chaaritable Trust",30000,0,0]
[null,"(phone, internet, fax, mobile, postal)",{"$nulls":8},0]
[5,"Printing & Stationery",1,"month",12,2000,{"$f":"+C38*E38*F38","v":24000},{"$f":"+G38/60","v":400},"local contribution from Smart Cube & Gigraj Kishory Lal Chaaritable Trust",24000,0,0]
[null,"(pen, pencil, writing pad, stapler, pin paper etc.)",{"$nulls":8},0]
[6,"Maintenance",1,"month",12,1000,12000,200,null,null,{"$f":"G40-J40","v":12000}]
[null,"Repairing,painting,electrical "]
[null,"replacement etc."]
[null,"G. TOTAL",{"$nulls":4},{"$f":"SUM(G12:G42)","v":1538703},{"$f":"SUM(H11:H42)","v":25645.05},null,1433693,null,7.324441146047306]
[null,"Local Contribution From:"]
[null,"- Smart Cube and Gigraj Kishory Lal Charitable Trust, New Delhi",{"$nulls":4},2015,null,2014,"Increase"]
[null,"  ( item no. A5(50%) A6  and B4, B5)",{"$nulls":4},{"$f":"G23+G24+G36+G38+72000","v":337750},null,null,"USD","%"]
[null,"- From Friend { item no. A7-teacher (coaching centre)}",{"$nulls":4},{"$f":"+G29","v":46800}]
[null,null,null,"Total Contribution from other sponsors",null,null,{"$f":"SUM(G46:G47)","v":384550},{"$f":"+G48/60","v":6409.166666666667}]
[null,null,"Net amount requested from Asha ",null,null,null,{"$f":"G43-G48","v":1154153},{"$f":"+H43-H48","v":19235.883333333331},1136543,{"$f":"I49/60","v":18942.383333333335},{"$f":"((G49-I49)/I49)*100","v":1.5494354371106065}]

{"sheet":"Info on kids","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["List of students(2-6 years)",{"$nulls":4},"List of students(7- 12years)"]
["1.Jahid","2 years","M","no school",null,"1.Dolly","7 years","F","c-3"]
["2.Sahid","3 years","M","no school",null,"2.Abdul Rahman","7 years","M","c-3"]
["3.Faisal","3 years","M","no school",null,"3.Arman","7 years","M","c-3"]
["4.Khushi","3 years","F","no school",null,"4.Sahbaz","7 years","M","c -3"]
["5.Alkama","3 years","M","no school",null,"5.Priyanka","7 years","F","c-3"]
["6.Nayan","4 years","M","no school",null,"6.Rituparna","8 years","F","c-4"]
["7.Rehan","4 years","M","no school",null,"7.Rani-2","8 years","F","c-3"]
["8.Aanu","4 years","F","no school",null,"8.Monu","8 years","M","c-3"]
["9.Anjali","4 years","F","c - 1",null,"9.Prince","8 years","M","no school"]
["10.Palak","5 years","F","c - kg",null,"10.Saddam","8 years","M","c-3"]
["11.Arman","5 years","M","no school",null,"11.Dilip","8 years","M","c-3"]
["12.Rehan","5 years","M","C-kg",null,"12.Naaz","9 years","F","c-4"]
["13.Khusbu","5 years","F","C-kg",null,"13.Shabnam","9 years","F","no school"]
["14.Omi","5 years","M","c - kg",null,"14.Ruksar","9 years","F","c-5"]
["15.Barun","5 years","M","c - kg",null,"15.Aadil","9 years","M","c-3"]
["16.Nitish","6 years ","M","c - 1",null,"16.Ladli","9 years","F","c-3"]
["17.Manish(New)","6 years","M","no school",null,"17.Kusum","10 years","F","c-6"]
["18.Sarfaraz","6 years","M","c-2",null,"18.Aasmen","10 years","F","c-5"]
["19.Juni","6 years","F","c-2",null,"19.Kiswari","10 years","F","c-5"]
["20.Khushboo(s)","6 years","F","c - kg",null,"20.Aaisha","11 years","F","c-5"]
["21.Mantajir","6 years","M","c-2",null,"21.Pamina","11 years","F","c-4"]
["22.Khushbu(New)","6 years","F","no school",null,"22.Ekra","11 years ","F","c-4"]
[{"$nulls":5},"23.sonam","11 years","F","c-4"]
["List of students(13-20 years)",{"$nulls":4},"24.Rosy","11 years","F","c-6"]
["1.Sarmeen","13 years","F","c-7",null,"25.Musarat","11 years","F","c-5"]
["2.Jubda","13 years","F","c-4",null,"26.Mahzabi","11 years","F","c-6"]
["3.Padma","13 years","F","c-6",null,"27.Afjal","12 years","M","c-6"]
["4.Abdulla","13 years","M","c-5",null,"28.Bushra","12 years","F","c-5"]
["5.Pradeep","13 years","M","c-9"]
["6.Gajanand","13 years","M","c-6"]
["7.Sabiha","13 years","F","c-6"]
["8.Pooja","13 years","F","c-7"]
["9.Ashutosh","13 years","M","no school"]
["10.Pinki","14 years","F","c-7"]
["11. Vishal","14 years","M","c - 8(open school)"]
["12.Aashish","15 years","M","c-9"]
["13.Bhalu","18 years","M","c-11"]
[]
["Total no. of children:",63]
["No.of girls:                  ",33]
["No.of boys:                ",30]

{"sheet":"Budget 14","index":2,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[36,5,36,6],[38,1,38,4],[39,1,39,4],[41,1,41,4]]}
[]
[null,"POPULAR EDUCATION AND ACTION CENTRE"]
[null,"BUDGET FOR NAVJAGRITI  COLLECTIVE EDUCATIONAL PROGRAMME- April 1, 2014 to March 31, 2015"]
[{"$nulls":11},"1 USD = INR 60"]
["S.No.","BUDGET  ITEMS","Physical","Unit","No. of","Unit ","Total","Total",2013,"% increase ",2013,"% increase ","Remarks"]
[null,null,"Requirement","Defination","Unit","Cost","(in INR)","(in US $)"," (14 mnths)","(14 mnths)","(12 mnths)","(12 mnths)"]
["A","PROGRAMME COSTS"]
[1,"Educational Material",51,"month",12,50,{"$f":"+C8*E8*F8","v":30600},{"$f":"+G8/60","v":510},29400,{"$f":"((G8-I8)/I8)*100","v":4.0816326530612246},{"$f":"(I8/14)*12","v":25200},{"$f":"((G8-K8)/K8)*100","v":21.428571428571427},"out of the 63 children; 51 are going to school and 12 are non-schooling. 42 school children last year"]
[null,"(paper, pen, pencil, sharpner, eraser etc. for 63 children)",12,"month",12,30,{"$f":"+C9*E9*F9","v":4320},{"$f":"+G9/60","v":72},6300,{"$f":"((G9-I9)/I9)*100","v":-31.428571428571427},{"$f":"(I9/14)*12","v":5400},{"$f":"((G9-K9)/K9)*100","v":-20},"18 last year"]
[2,"Educational Trip (travel, food, venue, stationery, etc. for 51 children & fee for resource person)",51,"Trip",2,650,66300,{"$f":"+G10/60","v":1105},50000,{"$f":"((G10-I10)/I10)*100","v":32.6},50000,{"$f":"((G10-K10)/K10)*100","v":32.6}]
[]
[3,"Educational Workshop (travel, food, venue, stationery, etc. for 63 children & fee for resource person)",63,"workshop",2,350,44100,{"$f":"+G12/60","v":735},20000,{"$f":"((G12-I12)/I12)*100","v":120.5},20000,{"$f":"((G12-K12)/K12)*100","v":120.5},"Project completes 5 years this year and the staff plans some celebrations"]
[]
[4,"Child Care Expenses (food, medician etc. for 63 children)",63,"days",313,17,335223,{"$f":"+G14/60","v":5587.05},332100,{"$f":"((G14-I14)/I14)*100","v":0.94037940379403806},281700,{"$f":"((G14-K14)/K14)*100","v":19},"Sundays has been excluded.Unit cost was 15 last year"]
[]
[5,"Transportation (School Van)",1,"month",12,6000,72000,{"$f":"+G16/60","v":1200},70000,{"$f":"((G16-I16)/I16)*100","v":2.8571428571428572},{"$f":"(I16/14)*12","v":60000},{"$f":"((G16-K16)/K16)*100","v":20}]
[6,"Education Expenses (51 children)",{"$nulls":10},"Local contribution from Smart Cube & Gigraj Kishory Lal Chaaritable Trust"]
[null,"- School Fees",51,"month",12,275,168300,{"$f":"+G18/60","v":2805},147000,{"$f":"((G18-I18)/I18)*100","v":14.489795918367346},{"$f":"(I18/14)*12","v":126000},{"$f":"((G18-K18)/K18)*100","v":33.571428571428569},"42 children last year"]
[null,"- School Uniform",51,"year",1,550,28050,{"$f":"+G19/60","v":467.5},21000,{"$f":"((G19-I19)/I19)*100","v":33.571428571428569},21000,{"$f":"((G19-K19)/K19)*100","v":33.571428571428569}]
[7,"Staff Salaries & Honorarium"]
[null,"- Coordinator",1,"month",12,6500,78000,{"$f":"+G21/60","v":1300},84000,{"$f":"((G21-I21)/I21)*100","v":-7.1428571428571423},{"$f":"(I21/14)*12","v":72000},{"$f":"((G21-K21)/K21)*100","v":8.3333333333333321}]
[null,"- Teacher (Full Time)",1,"month",12,8500,102000,1700,112000,{"$f":"((G22-I22)/I22)*100","v":-8.9285714285714288},{"$f":"(I22/14)*12","v":96000},{"$f":"((G22-K22)/K22)*100","v":6.25}]
[null,"- Teacher ( Part Time) ",2,"month",12,3500,84000,1400,84000,{"$f":"((G23-I23)/I23)*100","v":0},{"$f":"(I23/14)*12","v":72000}]
[null,"- Teacher (Coaching Centre)",1,"month",12,3900,46800,780,"NA","NA","NA","NA","Local contribution from Round Table"]
[null,"- Field Teacher (Activities)",1,"month",12,2500,30000,500,28000,{"$f":"((G25-I25)/I25)*100","v":7.1428571428571423},{"$f":"(I25/14)*12","v":24000},{"$f":"((G25-K25)/K25)*100","v":25}]
[null,"- Care-taker",1,"month",12,3500,42000,700,49000,{"$f":"((G26-I26)/I26)*100","v":-14.285714285714285},{"$f":"(I26/14)*12","v":42000},{"$f":"((G26-K26)/K26)*100","v":0}]
["B","ADMINISTRATIVE COSTS"]
[1,"Office Coordinator/Accounts",1,"lumpsum",1,20000,20000,{"$f":"+G28/60","v":333.33333333333331},84000,{"$f":"((G28-I28)/I28)*100","v":-76.19047619047619},{"$f":"(I28/14)*12","v":72000},{"$f":"((G28-K28)/K28)*100","v":-72.222222222222214}]
[2,"Office Rent & Electricity",1,"month",12,16500,198000,{"$f":"+G29/60","v":3300},231000,{"$f":"((G29-I29)/I29)*100","v":-14.285714285714285},{"$f":"(I29/14)*12","v":198000},{"$f":"((G29-K29)/K29)*100","v":0}]
[3,"Local Travel",1,"month",12,2500,30000,{"$f":"+G30/60","v":500},35000,{"$f":"((G30-I30)/I30)*100","v":-14.285714285714285},{"$f":"(I30/14)*12","v":30000},{"$f":"((G30-K30)/K30)*100","v":0}]
[4,"Communication & Postage (phone, internet, fax, mobile, postal)",1,"month",12,2500,30000,{"$f":"+G31/60","v":500},35000,{"$f":"((G31-I31)/I31)*100","v":-14.285714285714285},{"$f":"(I31/14)*12","v":30000},{"$f":"((G31-K31)/K31)*100","v":0},"Local contribution from Smart Cube & Gigraj Kishory Lal Chaaritable Trust"]
[]
[5,"Printing & Stationery (pen, pencil, writing pad, stapler, pin paper etc.)",1,"month",12,2000,24000,{"$f":"+G33/60","v":400},28000,{"$f":"((G33-I33)/I33)*100","v":-14.285714285714285},{"$f":"(I33/14)*12","v":24000},{"$f":"((G33-K33)/K33)*100","v":0},"Local contribution from Smart Cube & Gigraj Kishory Lal Chaaritable Trust"]
[]
[null,"G. TOTAL",{"$nulls":4},{"$f":"SUM(G8:G34)","v":1433693},{"$f":"SUM(H8:H34)","v":23894.883333333331},1445800,{"$f":"((G35-I35)/I35)*100","v":-0.83739106377092276},{"$f":"SUM(K8:K34)","v":1249300},{"$f":"((G35-K35)/K35)*100","v":14.759705435043625},"Addition of 3 children, inflation rate around 6-7%"]
[]
[null,"Local Contribution From",null,null,null,2014,null,2013]
[{"$nulls":5},"INR","USD","INR"]
[null,"- Smart Cube and Gigraj Kishory Lal Charitable Trust, New Delhi",null,null,null,{"$f":"+G18+G19+G31+G33","v":250350},{"$f":"F39/60","v":4172.5},231000]
[null,"- Round Table, New Delhi { item no. A7-teacher (coaching centre)}",null,null,null,{"$f":"G24","v":46800},{"$f":"F40/60","v":780},"NA"]
[null,"Total Contribution",null,null,null,{"$f":"F39+F40","v":297150},{"$f":"F41/60","v":4952.5},{"$f":"H39","v":231000}]
[null,"Net amount requested from Asha for Education",null,null,null,{"$f":"+G35-F41","v":1136543},{"$f":"F42/60","v":18942.383333333335},1214800]
[]
[null,null,2014,2013]
[null,"Yearly budget per child",{"$f":"G35/63","v":22757.031746031746},{"$f":"I35/60","v":24096.666666666668}]
[null,"Monthly budget per child",{"$f":"C45/12","v":1896.4193121693122},{"$f":"D45/14","v":1721.1904761904764}]

{"sheet":"Sheet3","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":7}
[null,"Fellowship"]
[null,"Vocational courses"]