{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Budget","Break-up","Sheet3"],"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":"Budget","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,1,13,1],[11,0,13,0],[11,6,13,6],[4,1,6,1],[14,1,16,1],[4,0,6,0],[4,6,6,6],[7,1,10,1],[7,0,10,0],[7,6,10,6],[17,1,22,1],[17,0,22,0],[17,6,22,6],[23,1,28,1],[23,0,28,0],[23,6,28,6],[36,0,36,5],[37,0,37,5],[35,0,35,5],[38,0,38,5],[0,0,0,7],[1,0,1,7],[2,0,2,7],[29,6,30,6],[29,0,30,0],[29,1,30,1],[31,0,31,5],[33,0,33,5],[34,0,34,5],[32,0,32,5],[14,0,16,0],[14,6,16,6]]}
["Swami Vivekananda Youth Movement"]
["Vignyana Vahini"]
["Budget for 2011 - 2012 (all figures in rupees)"]
["S.No","Sector","Activity","Amount","No.of units","Amount (activity wise)","Amount (Sector wise)","Remarks"]
[1,"Travel & Conveyance","Mobile science lab",8000,10,{"$f":"D5*E5","v":80000},{"$f":"SUM(F5:F7)","v":87320},"Rs 10 per km*800km per month"]
[null,null,"Staff travel (2 wheeler)",410,12,{"$f":"D6*E6","v":4920},null,"Rs2.05 per km*200km per month"]
[null,null,"Staff travel",200,12,2400,null,"Other travel"]
[2,"Technical & resource support","Chemicals, specimen & equipment",4000,8,32000,{"$f":"SUM(F8:F11)","v":160250},"Rs 4000 per month"]
[null,null,"Library",5500,5,27500,null,"4 libraries for teachers + upgrading mobile science lab library"]
[null,null,"Electronics Kit",3000,1,3000,null,"Introduction to electronics"]
[null,null,"Worksheets",97750,1,97750,null,"Students' contribution of Rs 26250"]
[3,"Capacity Building","Teacher training",5500,3,16500,{"$f":"SUM(F12:F14)","v":45500}]
[null,null,"Students' training",5550,4,22200]
[null,null,"Staff training & exposure visits",3400,2,6800]
[4,"Events (science calendar not incuded)","Awareness campaigns",1850,4,7400,{"$f":"SUM(F15:F17)","v":40200}]
[null,null,"Science & computer lab exposure visits",6020,5,30100]
[null,null,"Science club events",270,10,2700]
[5,"Science Calendar","World environment day",3600,1,{"$f":"D18*E18","v":3600},{"$f":"SUM(F18:F23)","v":88459.989999999991}]
[null,null,"Engineer's day",1170,5,5850,null,"Participation fee of Rs 500"]
[null,null,"Columbus day",703.33,3,2109.9900000000002,null,"Participation fee of Rs 500"]
[null,null,"World science day",3850,1,3850]
[null,null,"Young mathematician contest",1850,1,1850]
[null,null,"National science day (vignyana mela)",71200,1,71200,null,"Community contribution of Rs 10000"]
[6,"Operational cost","Office rent",1375,12,16500,{"$f":"SUM(F24:F29)","v":49400}]
[null,null,"Telephone",200,12,2400]
[null,null,"Teachers meeting",750,6,4500]
[null,null,"Stationery & other expenses",500,12,6000]
[null,null,"Annual report",2000,1,2000]
[null,null,"Prayoga",3000,6,18000,null,"Community contribution of Rs 7200"]
[7,"Personnel cost","Program manager",6413.2,12,76958.399999999994,{"$f":"F30+F31","v":175944.84}]
[null,null,"Program coordinator",8248.8700000000008,12,98986.44]
["Budget for 2011 - 2012",{"$nulls":5},{"$f":"SUM(G5:G30)","v":647074.82999999996}]
["Budget for 2010 - 2011",{"$nulls":5},550000]
["Opening balance in 2010 - 2011",{"$nulls":5},255726]
["Fund Transferred on 14th April 2011",{"$nulls":5},297245.7]
["Total fund received",{"$nulls":5},{"$f":"G34+G35","v":552971.69999999995}]
["Expenses 2010 - 2011",{"$nulls":5},535337]
["Unspent fund",{"$nulls":5},{"$f":"G36-G37","v":17634.699999999953},"Requested to be carried forward for the next year"]
["Amount requested for the year 2011 - 2012",{"$nulls":5},{"$f":"G32-G38","v":629440.13}]

{"sheet":"Break-up","index":1,"n_rows":113,"n_cols":8,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[]
["SNo ","Activities ","Unit cost","No","unit Amount","T U","Total Amount","Remarks "]
[1,"Travel & Conveyance"]
[null,"Vehicle Travel - Tata ACE",{"$f":"800*10","v":8000},1,{"$f":"+C4*D4","v":8000},10,{"$f":"F4*E4","v":80000},"Rs10 per km*800km per month"]
[null,"Staff Travel (2 wheeler)",{"$f":"2.05*200","v":409.99999999999994},1,{"$f":"+C5*D5","v":409.99999999999994},12,{"$f":"F5*E5","v":4919.9999999999991},"Rs2.05 per km*200km per month"]
[null,"Staff Travel",200,1,{"$f":"+C6*D6","v":200},12,{"$f":"F6*E6","v":2400},"Travel to Mysore, Bangalore, local"]
[null,"Total",{"$nulls":4},{"$f":"SUM(G4:G6)","v":87320}]
[2,"Capacity Building"]
[null,"Teacher Training",{"$f":"SUM(C10:C15)","v":6000},1,{"$f":"D9*C9","v":6000},3,{"$f":"SUM(G10:G15)","v":18000}]
[null,"Food",{"$f":"50*50","v":2500},1,2500,3,{"$f":"F10*E10","v":7500},"Rs.50 per head*50 teachers Tea and Snacks Rs.20 food 30"]
[null,"Resource person fee",1500,1,1500,3,4500,"Out Side"]
[null,"Resource person travel",1000,1,1000,3,3000,"Average"]
[null,"Coordination expenses",100,1,100,3,300,"Phone calls + Letters"]
[null,"Workshop Materials",400,1,400,3,1200,"Hand outs for teachers (xerox)"]
[null,"Stationery",{"$f":"10*50","v":500},1,500,3,1500,"Rs10 per teacher for pad & pen"]
[null,"Students' Training",{"$f":"SUM(C17:C21)","v":5550},1,5550,4,{"$f":"SUM(G17:G21)","v":22200}]
[null,"Food",{"$f":"40*50","v":2000},1,2000,4,8000,"Rs.30 Meals and Snacks 10 per head*50 students "]
[null,"Resource person fee",1500,1,1500,4,6000,"Out Side"]
[null,"Resource person travel",1000,1,1000,4,4000,"Average"]
[null,"Raw materials",1000,1,1000,4,4000,"Necessary materials for workshop"]
[null,"Coordination expenses",50,1,50,4,200,"Phone calls + Letters"]
[null,"Staff Training & Exposure visits",{"$f":"SUM(C23:C26)","v":3400},1,3400,2,{"$f":"SUM(G23:G26)","v":6800}]
[null,"Food",{"$f":"75*2*2","v":300},1,300,2,600,"Rs.75*2 days*2 persons"]
[null,"Travel",{"$f":"1000*2","v":2000},1,2000,2,4000,"Out Side area"]
[null,"Accomodation",700,1,700,2,1400,"Average"]
[null,"Registration fee",400,1,400,2,800,"Average"]
[null,"Total",{"$nulls":4},{"$f":"G9+G16+G22","v":47000}]
[3,"Technical & Resource Support"]
[null,"Chemicals, specimens & equipment",{"$f":"SUM(C30:C32)","v":4000},1,{"$f":"+C29*D29","v":4000},8,{"$f":"G30+G31+G32","v":32000},"Rs.4000 expenses per month"]
[null,"Chemicals",1500,1,1500,8,{"$f":"F30*E30","v":12000},"Average"]
[null,"Specimens & Slides",500,1,500,8,4000,"Average"]
[null,"Equipment - Maintenance & addition",2000,1,2000,8,16000,"Average"]
[null,"Libraries",{"$f":"SUM(C34:C35)","v":5500},1,5500,5,{"$f":"G34+G35","v":27500}]
[null,"Books & CDs",5000,1,5000,5,25000,"4 libraries for teachers + Mobile lab as per teachers request"]
[null,"Library set up & stationery",500,1,500,5,2500,"Average"]
[null,"Electronics kit",3000,1,3000,1,3000,"Average"]
[null,"Worksheets",{"$f":"C38+C39+C40","v":30500},1,30500,null,{"$f":"G38+G39+G40","v":124000}]
[null,"10th standard",{"$f":"2000*3*1.25","v":7500},1,{"$f":"C38*D38","v":7500},8,{"$f":"E38*F38","v":60000},"Rs.1.25 per worksheet per student 2000 Students monthly 3 worksheet"]
[null,"8th & 9th standard",{"$f":"1500*2*1","v":3000},1,{"$f":"C39*D39","v":3000},8,{"$f":"E39*F39","v":24000},"Rs.1 per worksheet per student 1500 students Monthly 2 worksheet"]
[null,"SSLC preparatory exams",20000,1,{"$f":"C40*D40","v":20000},2,{"$f":"E40*F40","v":40000},"Based on last year"]
[null,"Total",null,null,{"$f":"SUM(E29:E37)","v":52500},null,{"$f":"G29+G33+G36+G37","v":186500}]
[4,"Science Calendar"]
[null,"World Environment Day",{"$f":"SUM(C44:C48)","v":3600},1,{"$f":"+C43*D43","v":3600},1,{"$f":"SUM(G44:G48)","v":3600}]
[null,"Coordination expenses",400,1,400,1,{"$f":"F44*E44","v":400},"Posters+letters+phone calls"]
[null,"Prizes",750,1,750,1,{"$f":"F45*E45","v":750},"Based on last year"]
[null,"Resource person fee",750,1,750,1,{"$f":"F46*E46","v":750},"Outside"]
[null,"Resource person food & travel",500,1,500,1,{"$f":"F47*E47","v":500},"Average"]
[null,"Participation certificates",{"$f":"3*400","v":1200},1,1200,1,{"$f":"F48*E48","v":1200},"Rs.3 per certificate * 400 students"]
[null,"Engineer's Day",{"$f":"SUM(C50:C53)","v":1270},1,1270,5,{"$f":"SUM(G50:G53)","v":6350}]
[null,"Coordination expenses",20,1,20,5,{"$f":"F50*E50","v":100},"Posters+letters+phone calls"]
[null,"Prizes",400,1,400,5,2000,"Based on last year"]
[null,"Participation certificates",{"$f":"3*200","v":600},1,600,5,3000,"Rs.3 per certificate * 200 students"]
[null,"Raw materials",250,1,250,5,1250,"Charts+papers+other materials"]
[null,"Columbus Day",{"$f":"SUM(C55:C58)","v":870},1,870,3,{"$f":"SUM(G55:G58)","v":2610}]
[null,"Coordination expenses",20,1,20,3,60,"Posters+letters+phone calls"]
[null,"Prizes",400,1,400,3,1200,"Based on last year"]
[null,"Participation certificates",{"$f":"3*100","v":300},1,300,3,900,"Rs.3 * 100 students * 3 centres"]
[null,"Raw materials",150,1,150,3,450,"Question papers+Markers"]
[null,"World Science Day",{"$f":"SUM(C60:C65)","v":3850},1,3850,1,{"$f":"SUM(G60:G65)","v":3850}]
[null,"Coordination expenses",100,1,100,1,100,"Posters+letters+phone calls"]
[null,"Prizes",750,1,750,1,750,"Based on last year"]
[null,"Resource person fee",1500,1,1500,1,1500,"Outside"]
[null,"Resource person food & travel",500,1,500,1,500,"Average"]
[null,"Participation certificates",{"$f":"200*3","v":600},1,600,1,600,"Rs.3 per certificate * 200 students"]
[null,"Raw materials",400,1,400,1,400,"Question papers+Sheets"]
[null,"Young Mathematician Contest",{"$f":"SUM(C67:C70)","v":1850},1,1850,1,{"$f":"SUM(G67:G70)","v":1850},"Taluk level event"]
[null,"Coordination expenses",100,1,100,1,100,"Posters+letters+phone calls"]
[null,"Prizes",750,1,750,1,750,"Based on last year"]
[null,"Participation certificates",{"$f":"200*3","v":600},1,600,1,600,"Rs.3 per certificate * 200 students"]
[null,"Raw materials",{"$f":"200*2","v":400},1,400,1,400,"Question papers+Sheets"]
[null,"National Science Day (Vignyana mela)",{"$f":"SUM(C72+C73+C78+C79+C80+C81+C82+C83+C84+C85+C86)","v":72250},1,72250,1,{"$f":"G72+G73+G78+G79+G80+G81+G82+G83+G84+G85+G86","v":81200}]
[null,"Coordination expenses",400,1,400,1,{"$f":"F72*E72","v":400},"Posters+letters+phone calls"]
[null,"Prizes",{"$f":"SUM(C74:C77)","v":5150},null,0,null,{"$f":"SUM(G74:G77)","v":14100}]
[null,"Best perfoming schools",1000,1,1000,5,5000,"Rs.1000 per school * 5 schools"]
[null,"Best teachers",400,1,400,4,1600,"Based on last year"]
[null,"Science Exhibition",2250,1,2250,2,4500,"Based on last year"]
[null,"Science Quiz",1500,1,1500,2,3000,"Based on last year"]
[null,"Participation certificates",{"$f":"3*900","v":2700},1,2700,1,2700,"Rs.3 per certificate * 300 students"]
[null,"Raw materials",2000,1,2000,1,2000,"Average"]
[null,"Banners",1000,1,1000,1,1000,"Average"]
[null,"Food",{"$f":"1500*15","v":22500},1,22500,1,22500,"Rs.15 per head * 1500"]
[null,"Tent / Hall",25000,1,25000,1,25000,"Average"]
[null,"Sound system",6000,1,6000,1,6000,"Based on last year"]
[null,"Resource person fee",1500,1,1500,1,1500,"Outside"]
[null,"Resource person travel",1000,1,1000,1,1000,"Average"]
[null,"Miscellaneous expenses",5000,1,5000,1,5000,"tag,registration sheet, Rope ec.,"]
[null,"Total",{"$nulls":4},{"$f":"G43+G49+G54+G59+G66+G71","v":99460}]
[5,"Events","Unit cost","No","unit Amount","T U","Total Amount"]
[null,"Awareness campaigns",{"$f":"SUM(C90:C93)","v":1850},1,1850,4,{"$f":"SUM(G90:G93)","v":7400}]
[null,"Resource person fee",1000,1,1000,4,4000,"Outside"]
[null,"Resource person food & travel",500,1,500,4,2000,"Average"]
[null,"Coordination expenses",100,1,100,4,400,"Posters+letters+phone calls"]
[null,"Raw materials",250,1,250,4,1000,"Miscellaneous"]
[null,"Science & computer lab exposure visits",{"$f":"SUM(C95:C98)","v":6020},1,6020,5,{"$f":"SUM(G95:G98)","v":30100}]
[null,"Coordination expenses",20,1,20,5,100,"Posters+letters+phone calls"]
[null,"Vehicle Travel - School bus",{"$f":"150*20","v":3000},1,3000,5,15000,"Rs20 per km*150km per month"]
[null,"Food",{"$f":"15*100","v":1500},1,1500,5,7500,"Rs15 per head"]
[null,"Lab Usage fee",1500,1,1500,5,7500,"Lab fee"]
[null,"Science Club events",{"$f":"C100+C101","v":270},1,270,10,{"$f":"SUM(G100:G101)","v":2700}]
[null,"Coordination expenses",20,1,20,10,200,"Posters+letters+phone calls"]
[null,"Raw materials",250,1,250,10,2500,"Chemicals+Stationery+Others"]
[null,"Total",{"$nulls":4},{"$f":"G89+G94+G99","v":40200}]
[6,"Operational Costs","Unit cost","No","unit Amount","T U","Total Amount"]
[null,"Office rent",1375,1,{"$f":"+C104*D104","v":1375},12,{"$f":"F104*E104","v":16500},"Based on last year"]
[null,"Phone calls",200,1,200,12,2400,"Based on last year"]
[null,"Teachers' meetings",{"$f":"SUM(C107:C107)","v":750},1,750,6,4500,"Rs.30 per head*25 teachers"]
[null,"Food",{"$f":"30*25","v":750},1,750,6,4500,"Average"]
[null,"Documentation, Stationery & others",500,1,500,12,6000,"Average"]
[null,"Annual Report",2000,1,2000,1,2000]
[null,"Prayoga",{"$f":"SUM(C111:C112)","v":4200},1,4200,6,25200]
[null,"Newsletter",{"$f":"2*2000","v":4000},1,4000,6,24000,"2 monthly 2000 Students"]
[null,"Prizes & participation",200,1,200,6,1200,"Rs.200 per issue"]
[null,"Total",null,null,{"$f":"SUM(E104:E110)","v":9775},null,{"$f":"G104+G105+G106+G108+G109+G110","v":56600}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}