{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Vijnana Vahini"],"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":"Vijnana Vahini","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,6,1,8],[30,6,31,6],[30,7,31,7],[30,8,31,8]]}
["Vijnana Vahini Budget vs. Expenses"]
[{"$nulls":6},"June 2013 - March 2014"]
["SNo","Activities","Rate","Unit","No. of Units","Budget","Amount","%","Comments"]
["A","Personnel Cost",{"$f":"SUM(F5:F8)","v":278100},"per year",1,{"$f":"C4*E4","v":278100},{"$f":"SUM(G5:G8)","v":198613},{"$f":"G4/F4","v":0.71417835311039191},"On track"]
["A.1","Program Manager",7500,"per month",12,90000,80000,0.88888888888888884,"On track"]
["A.2","Project Coordinator",8000,"per month",12,96000,75583,0.78732291666666665,"On track"]
["A.3","Facilitator",7000,"per month",12,84000,35745,0.42553571428571429,"On track - on the lower side because a B.Ed candidate was appointed in October on the recommendations of the Govt. schools"]
["A.4","Staff Benefit",{"$f":"SUM(F5:F7)*0.03","v":8100},"per year",1,8100,7285,0.89938271604938269,"On track"]
["B","Recurring Cost",{"$f":"SUM(F10,F16,F19,F27,F30)","v":633200},"per year",1,633200,{"$f":"SUM(G10,G16,G19,G27,G30)","v":444790},0.70244788376500311,"Request for re-appropriation internally"]
["B.1","Operational Expenses",{"$f":"SUM(F11:F15)","v":50200},"per year",1,50200,{"$f":"SUM(G11:G15)","v":31933},0.63611553784860553]
["B.1.1","Office rent",1700,"per month",12,20400,16450,0.80637254901960786,"On track"]
["B.1.2","Stationery & other expenses",750,"per month",12,9000,8975,0.99722222222222223,"On track"]
["B.1.3","Phone calls",400,"per month",12,4800,5558,1.1579166666666667,"Crossed the limits because of the addition of a new internet connection"]
["B.1.4","Teachers' meeting",1000,"per meeting",4,4000,646,0.1615,"On the lower side because of the most of the expenses incurred were placed under the Science Park project"]
["B.1.5","Mentoring & Monitoring",12000,"per year",1,12000,304,2.5333333333333333E-2,"On the lower side because of the most of the expenses incurred were placed under the Science Park project"]
["B.2","Travel & Conveyance",{"$f":"SUM(F17:F18)","v":120000},"per year",1,120000,{"$f":"SUM(G17:G18)","v":99004},0.82503333333333329]
["B.2.1","Vehicle travel",{"$f":"17","v":17},"per km",6000,102000,89404,0.87650980392156863,"On track - the budget to be reviewed for next year"]
["B.2.2","Staff travel & food",1500,"per month",12,18000,9600,0.53333333333333333]
["B.3","Technical & resource support",{"$f":"SUM(F20:F26)","v":213000},"per year",1,213000,{"$f":"SUM(G20:G25)","v":81064},0.38058215962441316]
["B.3.1","Equipment & chemicals",50000,"per year",1,50000,46112,0.92223999999999995,"On track"]
["B.3.2","Books, CDs & DVDs",15000,"per year",1,15000,7908,0.5272,"On track"]
["B.3.3","Other materials",10000,"per year",1,10000,11953,1.1953,"On the higher side because of the addition of the new boards to the mobile science lab"]
["B.3.4","Question Box",400,"per box",35,14000,0,0,"Scheduled for May"]
["B.3.5","Newsletter & Calendar",2000,"per month",12,24000,12660,0.52749999999999997,"Calendar was published but the newsletter couldn't take off"]
["B.3.6","Workbook",10000,"one time",1,10000,2431,0.24310000000000001,"Funds raised from other donors"]
["B.3.7","Multiple Kits for Science Lab",15000,"per set",6,90000,0,0,"Scheduled for May"]
["B.4","Capacity building",{"$f":"SUM(F28:F29)","v":20000},"per year",1,20000,{"$f":"SUM(G28:G29)","v":4916},0.24579999999999999]
["B.4.1","Training Programs",7500,"per program",2,15000,2824,0.18826666666666667,"Funds raised from KSTA"]
["B.4.2","Staff training & exposure",5000,"per year",1,5000,2092,0.41839999999999999,"On track"]
["B.5","Events",{"$f":"SUM(F31:F35)","v":230000},"per year",1,230000,{"$f":"SUM(G31:G35)","v":227873},0.99075217391304349]
["B.5.1","School based events",500,"per program",20,10000,49272,{"$f":"G31/(F31+F32)","v":1.2318},"Higher costs were incurred to make arrangements for the Vijnana Mela to make it a big event and encourage the participation of the Govt. officials and the National Science Day program at Mysore"]
["B.5.2","Science calendar",30000,"per year",1,30000]
["B.5.3","OOSC Survey",20000,"per year",1,20000,12340,{"$f":"G33/F33","v":0.61699999999999999},"Survey took lesser time than the plan"]
["B.5.4","Community Radio Programs",0,null,null,0,null,{"$error":"#DIV/0!"},"Included in the earlier budgets but later removed because of the confusion with the FCRA. Has been clarified with the Government officials"]
["B.5.5","Lab in Box",10000,"per kit",17,170000,166261,0.97800588235294117,"On track"]
["C","Capital cost",{"$f":"F37","v":30000},"one time",1,30000,{"$f":"G37","v":0},0]
["C.1","LCD Projector",30000,"one time",1,30000,0,0,"Scheduled for May"]
[null,"Total",null,null,null,{"$f":"(F4+F9)+F36","v":941300},{"$f":"(G4+G9)+G36","v":643403},0.68352597471581855]
[null,"Overheads",null,0.04,null,{"$f":"F38*0.04","v":37652},{"$f":"G38*0.04","v":25736.12},0.68352597471581855]
[null,"Total + Overheads",null,null,null,{"$f":"F38+F39","v":978952},{"$f":"G38+G39","v":669139.12},0.68352597471581855]
[null,"Fund Balance with SVYM",null,null,null,190990.6]
[null,"Fund Received during the period",null,null,null,788000]
[null,"Unspent Amount",{"$nulls":4},{"$f":"(F41+F42)-G40","v":309851.48}]