{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Vijnana Vahini"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["Swami Vivekananda Youth Movement"]
["Vijnana Vahini Budget 2013 2014"]
["SNo","Activities","Rate","Unit","No. of Units","Amount","Remarks"]
["A","Personnel Cost",{"$f":"SUM(F5:F8)","v":278100},"per year",1,{"$f":"C4*E4","v":278100}]
["A.1","Program Manager",7500,"per month",12,{"$f":"C5*E5","v":90000},"Same as last year"]
["A.2","Project Coordinator",8000,"per month",12,{"$f":"C6*E6","v":96000},"Decrease from Rs.10000 pm"]
["A.3","Facilitator",7000,"per month",12,84000,"Decrease from Rs.7500 pm"]
["A.4","Staff Benefit",{"$f":"SUM(F5:F7)*0.03","v":8100},"per year",1,8100,"Staff benefit at 3%"]
["B","Recurring Cost",{"$f":"SUM(F10,F16,F19,F26,F29)","v":373200},"per year",1,373200]
["B.1","Operational Expenses",{"$f":"SUM(F11:F15)","v":50200},"per year",1,{"$f":"C10*E10","v":50200}]
["B.1.1","Office rent",1700,"per month",12,{"$f":"C11*E11","v":20400},"Actual Cost"]
["B.1.2","Stationery & other expenses",750,"per month",12,{"$f":"C12*E12","v":9000},"Based on last year"]
["B.1.3","Phone calls",400,"per month",12,4800,"Based on last year","`"]
["B.1.4","Teachers' meeting",1000,"per meeting",4,4000,"Based on last year"]
["B.1.5","Mentoring & Monitoring",12000,"per year",1,12000,"Decreased from Rs.2500 pm"]
["B.2","Travel & Conveyance",{"$f":"SUM(F17:F18)","v":120000},"per year",1,{"$f":"C16*E16","v":120000}]
["B.2.1","Vehicle travel",{"$f":"17","v":17},"per km",6000,{"$f":"C17*E17","v":102000},"Actual Cost"]
["B.2.2","Staff travel & food",1500,"per month",12,{"$f":"C18*E18","v":18000},"Based on last year"]
["B.3","Technical & resource support",{"$f":"SUM(F20:F25)","v":123000},"per year",1,{"$f":"C19*E19","v":123000}]
["B.3.1","Equipment & chemicals",50000,"per year",1,{"$f":"C20*E20","v":50000},"Estimated - taking into consideration last year's cost"]
["B.3.2","Books, CDs & DVDs",15000,"per year",1,{"$f":"C21*E21","v":15000},"Based on last year"]
["B.3.3","Other materials",10000,"per year",1,10000,"Based on last year"]
["B.3.4","Question Box",400,"per box",35,14000,"New plan to setup question boxes in schools"]
["B.3.5","Newsletter",2000,"per month",12,24000,"New plan to publish newsletters"]
["B.3.6","Workbook",10000,"one time",1,10000,"Transport & Distribution"]
["B.4","Capacity building",{"$f":"SUM(F27:F28)","v":20000},"per year",1,{"$f":"C26*E26","v":20000}]
["B.4.1","Training Programs",7500,"per program",2,15000,"Based on last year, additional funding from KSTA"]
["B.4.2","Staff training & exposure",5000,"per year",1,5000,"Estimated - additional funding from KSTePS"]
["B.5","Events",{"$f":"SUM(F30:F31)","v":60000},"per year",1,60000]
["B.5.1","School based events",500,"per program",20,10000,"Based on last year"]
["B.5.2","Science calendar",50000,"per year",1,50000,"Based on last year, additional funding from KSTePS"]
["C","Capital cost",{"$f":"F33","v":30000},"one time",1,30000]
["C.1","LCD Projector",30000,"one time",1,30000,"Need to replace the old one as it was damaged because of a power fluctuation and is beyond repair"]
[null,"Budget",null,null,null,{"$f":"F4+F9+F32","v":681300}]
[null,"Overheads",null,0.04,null,{"$f":"F34*0.04","v":27252},"Organizational overheads at 4%"]
[null,"Total Budget",null,null,null,{"$f":"F34+F35","v":708552},"Last year Rs.723,000"]
[null,"Science kits (incl of overheads)",15000,"per kit",6,{"$f":"(C37*E37)*1.04","v":93600},"These kits will be having equipment which will be used in schools with huge class strength"]
[null,"Assembling 'Lab in a Box'",10000,"per kit",17,{"$f":"(C38*E38)*1.04","v":176800}]
[null,"Fund Balance with SVYM",null,null,null,190990.59999999998,"As on 31st May 2013"]
[null,"Additional Funds Request",null,null,null,{"$f":"F36+F37+F38-F39","v":787961.4}]