{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Summary","Actual 2012-2013","Budget 2013-2014"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":5,"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":"Summary","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["INR","Actual","%","Budget","%","Difference"," %"]
["Gross Costs","2012-2013",null,"2013-2014"]
["Program",{"$f":"'[1]School Report'!$H$5","v":2835015},{"$f":"B4/B$8","v":0.47448799501514088},{"$f":"'[2]NST-School-Budget 2013-14'!$F$7+'[2]NST-School-Budget 2013-14'!$F$12+'[2]NST-School-Budget 2013-14'!$F$16+'[2]NST-School-Budget 2013-14'!$F$42","v":1665540},{"$f":"D4/D$8","v":0.41959479528523319},{"$f":"B4-D4","v":1169475},{"$f":"F4/B4","v":0.41251104491510626}]
["Staff",{"$f":"SUM('[1]School Report'!$H$12)","v":2407407},{"$f":"B5/B$8","v":0.40292052091978886},{"$f":"'[2]NST-School-Budget 2013-14'!$F$25","v":1916561},{"$f":"D5/D$8","v":0.48283380792215247},{"$f":"B5-D5","v":490846},{"$f":"F5/B5","v":0.20388991142752347}]
["Administration",{"$f":"'[1]School Report'!$H$14","v":603201},{"$f":"B6/B$8","v":0.10095595017350102},{"$f":"'[2]NST-School-Budget 2013-14'!$F$39+'[2]NST-School-Budget 2013-14'!$F$45","v":387300},{"$f":"D6/D$8","v":9.7571396792614298E-2},{"$f":"B6-D6","v":215901},0.3579254676301929]
["Capital",{"$f":"'[1]School Report'!$H$27","v":129270},{"$f":"B7/B$8","v":2.1635533891569272E-2},null,{"$f":"D7/D$8","v":0},{"$f":"B7-D7","v":129270},1]
["Total Costs",{"$f":"SUM(B4:B7)","v":5974893},{"$f":"B8/B$8","v":1},{"$f":"SUM(D4:D7)","v":3969401},{"$f":"D8/D$8","v":1},{"$f":"B8-D8","v":2005492},0.33565320751350691]
[]
["Sources of Funds"]
["Tata Trust",{"$f":"'Actual 2012-2013'!L13","v":2272783},{"$f":"B11/B$15","v":0.38038890403560366},{"$f":"B11","v":2272783},{"$f":"D11/D$15","v":0.57257581181644279},{"$f":"B11-D11","v":0},{"$f":"-F11/B11","v":0}]
["Asha-Boston",{"$f":"'Actual 2012-2013'!M7","v":798641},{"$f":"B12/B$15","v":0.13366615937724743},0,0,{"$f":"B12-D12","v":798641},{"$f":"-F12/B12","v":-1}]
["Student contributions",{"$f":"'Actual 2012-2013'!J7","v":1127440},0.18869626619254939,{"$f":"750*10*117","v":877500},0.22106610040154673,{"$f":"B13-D13","v":249940},-0.22168807209252819]
["Own Funds",{"$f":"B15-SUM(B11:B13)","v":1776029},0.29724867039459951,{"$f":"D15-SUM(D11:D13)","v":819118},0.20635808778201042,{"$f":"B14-D14","v":956911},-0.5387924408891972]
["Total Sources",{"$f":"B8","v":5974893},1,{"$f":"D8","v":3969401},1,{"$f":"B15-D15","v":2005492},{"$f":"-F15/B15","v":-0.33565320751350691}]
[]
["Other Metrics"]
["Student count",322,null,117,null,{"$f":"D18-B18","v":-205},{"$f":"F18/B18","v":-0.63664596273291929}]
["Cost per student",{"$f":"B8/B18","v":18555.568322981366},null,{"$f":"D8/D18","v":33926.504273504273},null,{"$f":"B19-D19","v":-15370.935950522908},{"$f":"F19/B19","v":-0.82837322376624589}]

{"sheet":"Actual 2012-2013","index":1,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["NAVSARJAN VIDHYALAY ACTUAL EDUCATION RELATED EXPENDITURE REPORT FOR THE PERIOD 15-06-12 TO 15-06-13"]
[]
[]
["EXPENDITURE FOR 6 MONTHS","K","R","S","Indian","Asha","SDTT","AMOUNT","%","Students contri.","FUNDS","TSWT","ASHA"]
["Program Expenses",{"$f":"SUM(B6:B11)","v":614846},507952,{"$f":"SUM(D6:D11)","v":729561},114224,798641,69791,{"$f":"SUM(H6:H11)","v":2835015},{"$f":"H5/H32","v":0.47448799501514088},{"$f":"SUM(J6:J11)","v":1127440},839143,69791,798641]
["Teacher's training exp.",null,null,null,{"$f":"6010","v":6010},null,null,{"$f":"SUM(B6:G6)","v":6010},null,null,{"$f":"H6-J6-L6-M6","v":6010}]
["Lodging/food expenses",{"$f":"532525","v":532525},{"$f":"426340","v":426340},{"$f":"652138","v":652138},{"$f":"26700+25900+33025","v":85625},798641,null,{"$f":"SUM(B7:G7)","v":2495269},null,{"$f":"396200+278350+452890","v":1127440},{"$f":"H7-J7-L7-M7","v":569188},null,{"$f":"798641","v":798641}]
["Boarding/Hostel expenses",{"$f":"27493","v":27493},{"$f":"38337","v":38337},{"$f":"18157","v":18157},null,null,null,83987,null,null,{"$f":"H8-J8-L8-M8","v":83987}]
["Educational cultural/Sport programs",{"$f":"14199","v":14199},{"$f":"22895","v":22895},{"$f":"43462","v":43462},{"$f":"12630","v":12630},null,null,93186,null,null,93186]
["Science Lab Materials",{"$nulls":6},0,null,null,0]
["Travelling expenses",{"$f":"40629","v":40629},{"$f":"20380","v":20380},15804,{"$f":"9959","v":9959},null,69791,156563,null,null,86772,69791]
["Program Staff Expenses",{"$f":"SUM(B13)","v":57837},11375,56525,8887,0,2272783,{"$f":"SUM(H13)","v":2407407},{"$f":"H12/H32","v":0.40292052091978886},{"$f":"SUM(J13)","v":0},134624,2272783,0]
["Salaries to school staff",{"$f":"57837","v":57837},{"$f":"11375","v":11375},56525,{"$f":"8887","v":8887},null,{"$f":"2272783","v":2272783},{"$f":"SUM(B13:G13)","v":2407407},null,null,134624,2272783]
["Program Admin Expenses",{"$f":"SUM(B15:B26)","v":127308},104094,{"$f":"SUM(D15:D26)","v":130316},227426,844,13213,{"$f":"SUM(H15:H26)","v":603201},{"$f":"H14/H32","v":0.10095595017350102},{"$f":"SUM(J15:J26)","v":0},589144,13213,844]
["Bank charges",{"$f":"1524","v":1524},{"$f":"579","v":579},{"$f":"878","v":878},null,844,null,3825,null,null,2981,null,844]
["Electricity expenses",{"$f":"45024","v":45024},{"$f":"20368","v":20368},{"$f":"18735","v":18735},null,null,null,84127,null,null,84127]
["Gardening expenses",{"$f":"1655","v":1655},{"$f":"12065","v":12065},{"$f":"13030","v":13030},null,null,null,26750,null,null,26750]
["Gram Panchyata Tax",0,0,7280,null,null,null,7280,null,null,7280]
["Newspaper/Magazine",{"$f":"2708","v":2708},{"$f":"270","v":270},{"$f":"1700","v":1700},null,null,null,4678,null,null,4678]
["Other Misce.income",{"$f":"1140","v":1140},{"$f":"1460","v":1460},{"$f":"1625","v":1625},null,null,null,4225,null,null,4225]
["Photocopy expenses",{"$f":"822","v":822},{"$f":"515","v":515},{"$f":"1384","v":1384},null,null,null,2721,null,null,2721]
["Postage & Couriers",{"$f":"360","v":360},{"$f":"200","v":200},{"$f":"1520","v":1520},null,null,null,2080,null,null,2080]
["Repairing & Maintatnce",{"$f":"58256+5320","v":63576},{"$f":"52819+4630","v":57449},{"$f":"1700+73139","v":74839},{"$f":"208618","v":208618},null,null,404482,null,null,404482]
["Stationary & Printing expenses",{"$f":"452+3047","v":3499},{"$f":"2988","v":2988},{"$f":"2325","v":2325},null,null,null,8812,null,null,8812]
["Telephone expense",null,{"$f":"1200","v":1200},0,18808,null,{"$f":"9258+3955","v":13213},33221,null,null,20008,13213]
["Audit fees",{"$f":"7000","v":7000},7000,7000,null,null,null,21000,null,null,21000]
["CAPITAL EXPENDITURE",{"$f":"SUM(B28:B31)","v":48428},50517,30325,0,0,0,{"$f":"SUM(H28:H31)","v":129270},{"$f":"H27/H32","v":2.1635533891569272E-2},{"$f":"SUM(J28:J31)","v":0},129270,0,0]
["Katariya School construction & Land NA",{"$f":"48428","v":48428},{"$nulls":5},48428,null,null,48428]
["Rayka School construction & Land NA",null,50517,{"$nulls":4},50517,null,null,50517]
["Sami School construction & Land NA",null,null,{"$f":"19200+11000+125","v":30325},null,null,null,30325,null,null,30325]
["Computers purchase",{"$nulls":6},0,null,null,0,null,0]
["Total ",{"$f":"B5+B12+B14+B27","v":848419},{"$f":"C5+C12+C14+C27","v":673938},946727,350537,799485,2355787,{"$f":"H5+H12+H14+H27","v":5974893},{"$f":"SUM(I5:I31)","v":1},{"$f":"J5+J12+J14+J27","v":1127440},{"$f":"K5+K12+K14+K27","v":1692181},{"$f":"L5+L12+L14+L27","v":2355787},{"$f":"M5+M12+M14+M27","v":799485}]
[{"$nulls":9},{"$f":"J32/H32","v":0.18869626619254939},{"$f":"K32/H32","v":0.28321528101005322},{"$f":"L32/H32","v":0.39428103566038758},{"$f":"M32/H32","v":0.1338074171370098}]

{"sheet":"Budget 2013-2014","index":2,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["FINANCIAL REQUIREMENT : NAVSARJAN VIDHYALAY: FOR THE PERIOD 01/06/2013 TO 31/05/2014"]
[]
["SR.NO.","DESCRIPTION","QTY","RATE","MONTHS/DAYS","AMOUNT","%"]
["A","PROGRAMS EXPENDITURE"]
[1,"Educational material, Sport goods and cultural activities  cost for teaching Rs.1500 pm",3,1500,10,{"$f":"C5*D5*E5","v":45000}]
[2,"Up gradation of Science, Computers, Language, Social science labs.",3,100000,1,{"$f":"C6*D6*E6","v":300000}]
[null,"Sub Total [A]",null,null,null,{"$f":"SUM(F5:F6)","v":345000},{"$f":"F7/F47","v":8.6914877080949998E-2}]
["B","BOARDING & LODGING EXPENSES"]
[1,"Food exp.Rs.30 x 117 students x304 days",{"$f":"28+40+49","v":117},30,304,{"$f":"C9*D9*E9","v":1067040},null,null,{"$f":"20+31+31+30+31+9+31+31+29+31+30+0","v":304}]
[2,"Hostel maintenance",3,1500,12,{"$f":"C10*D10*E10","v":54000}]
[3,"Medical exp.Rs.500 pm",3,500,12,{"$f":"C11*D11*E11","v":18000}]
[null,"Sub Total [B]",null,null,null,{"$f":"SUM(F9:F11)","v":1139040},{"$f":"F12/F47","v":0.2869551350443052}]
["C","PROGRAM STAFF TRAVELLING"]
[1,"Public travel to Manager",3,2000,12,{"$f":"C14*D14*E14","v":72000}]
[2,"Transportation and other local travelling",3,2500,12,{"$f":"C15*D15*E15","v":90000}]
[null,"Sub Total [C]",null,null,null,{"$f":"SUM(F14:F15)","v":162000},{"$f":"F16/F47","v":4.0812203151054778E-2}]
["D","PROGRAM STAFF EXPENDITURE"]
["D1","Salary for staff (Annexure-1)","23 staff",121175,12,{"$f":"D18*E18","v":1454100}]
["D2","Staff welfare ",null,null,null,{"$f":"SUM(F20:F24)","v":462461}]
["D2.1","PF @12% of Salary scale","23 staff",13776,12,{"$f":"D20*E20","v":165312}]
["D2.2","Gratuity@4.17% of Salary scale","23 staff",4793,12,{"$f":"D21*E21","v":57516}]
["D2.3","PF admin charges on salary scale","23 staff",1844,12,{"$f":"D22*E22","v":22128}]
["D2.4","Food & House rent allowance","23 staff",15375,12,{"$f":"D23*E23","v":184500}]
["D2.5","Medi Claim Premium payments",23,1435,1,{"$f":"D24*E24*C24","v":33005}]
[null,"Sub Total [ D ]",null,null,null,{"$f":"F18+F19","v":1916561},{"$f":"F25/F47","v":0.48283380792215247}]
["E","PROGRAM ADMINISTRATION"]
[1,"Audit fees",3,7000,1,{"$f":"D27*E27*C27","v":21000}]
[2,"Electricity Rs.2750 pm",3,2750,12,99000]
[3,"Gardening expenses Rs.1000 pm",3,1000,12,36000]
[4,"Gram Panchayat taxes Rs.7500 pm",3,7500,1,22500]
[5,"News paper exp. Rs.100pm",3,100,12,3600]
[6,"Other Misce.exp.Rs.1000pm",3,1000,12,36000]
[7,"Photocopy expenses",3,250,12,9000]
[8,"Postage & Couriers",3,50,12,1800]
[9,"Repairing & maint. (Computers & other equip.)",3,1000,12,{"$f":"D35*E35*C35","v":36000}]
[10,"Stationary & Printing expenses",3,100,12,3600]
[11,"Telephone expenses at School office",3,500,12,{"$f":"D37*E37*C37","v":18000}]
[12,"Telephone expenses to Managers",3,300,12,{"$f":"D38*E38*C38","v":10800}]
[null,"Sub Total [ E ]",null,null,null,{"$f":"SUM(F27:F38)","v":297300},{"$f":"F39/F47","v":7.4897950597583862E-2}]
["F","INVENTORY ITEMS PURCHASE"]
[1,"Kitchen cutlery items",3,6500,1,{"$f":"D41*E41*C41","v":19500}]
[null,"Sub Total [ F ]",null,null,null,{"$f":"SUM(F41:F41)","v":19500},{"$f":"F42/F47","v":4.9125800089232603E-3}]
["G","SCHOOL CONSTRUCTION/REPAIRING WORK"]
[1,"School construction or repairing work",3,2500,12,{"$f":"D44*E44*C44","v":90000}]
[null,"Sub Total [ G ]",null,null,null,{"$f":"SUM(F44:F44)","v":90000},{"$f":"F45/F47","v":2.2673446195030433E-2}]
[]
[null,"Grand Total",null,null,null,{"$f":"SUM(F16+F25+F39+F7+F12+F42+F45)","v":3969401},{"$f":"SUM(G16+G25+G39+G7+G12+G42+G45)","v":1.0000000000000002}]
[]
[]
["-","SOURCE OF INCOME"]
[1,"Asha For Education",117,420,10,{"$f":"C51*D51*E51","v":491400}]
[2,"SDTT grants",null,null,null,{"$f":"F25+F14+F38-(68626+(300*3)+(2000*3))","v":1923835}]
[3,"Students contribution",117,750,10,{"$f":"C53*D53*E53","v":877500}]
[4,"Funds utilisation",null,null,null,{"$f":"239004+75526","v":314530}]
[]
[]
[null,"Sub Total [ D ]",null,null,null,{"$f":"SUM(F51:F56)","v":3607265}]
[]
[{"$nulls":5},{"$f":"F47-F57","v":362136}]