{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Totals","Education","Edu Comparison","Food","Administration"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"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":"Totals","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,5,4,6]]}
[]
[null,"Seva Chakkara:",null,null,"Exch Rate",51]
[null,"Consolidated Budget"]
[{"$nulls":7},"INR Rate",63]
[null,null,"Monthly Expense",null,null,"Yearly Expense"]
[null,"Items","Indian Rupee","US Dollar","# of Months","Indian Rupee","US Dollar"]
[]
[null,"All Food Items",197648,3137.26,12,2371776,{"$f":"F8/$I$4","v":37647.238095238092}]
[]
[null,"Education",199378,3164.73,11,2193160,{"$f":"F10/$I$4","v":34812.063492063491}]
[]
[null,"Administration & Maintenance",127730,2027.46,12,1532760,{"$f":"F12/$I$4","v":24329.523809523809}]
[]
[null,"Totals",{"$f":"SUM(C8:C13)","v":524756},{"$f":"SUM(D8:D13)","v":8329.4500000000007},null,{"$f":"SUM(F8:F13)","v":6097696},{"$f":"SUM(G8:G13)","v":96788.825396825385}]
[null,null," ",null,null," "]
[]
[]
[null,"2014 Budget Requested",1969996]
[null,"2015 Budget Increase (From 2014 Requested)",{"$f":"(F10-C18)/C18","v":0.11328144828720464}]
[]
[null,"2014 Budget Approved (10% Incr. from 2013)",1512016]
[null,"2015 Proposed (10% incr. from 2014)",{"$f":"C21*1.1","v":1663217.6},null,null,null,{"$f":"C22/I4","v":26400.279365079368},"USD Amount"]
[]
[null,"Shortfall in 2015 Budget Request",{"$f":"F10-C22","v":529942.39999999991}]
[null,"Shortfall in 2015 Budget Request %",{"$f":"C24/F10","v":0.24163417169745932}]

{"sheet":"Education","index":1,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[45,3,45,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[2,14,2,16],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4]]}
[]
[{"$nulls":10}," "]
[null,"Seva Chakkara:  Educational Expenses"]
[]
[]
[null,null,"Nursery and Primary:  Teacher/Staff Salaries"]
[]
[null,null,"Item","Monthly ","# of Months","Yearly"]
[null,1,"3 Teachers + H.M",16000,11,{"$f":"E9*D9","v":176000}]
[null,2,"Driver (Van)",8000,11,{"$f":"E10*D10","v":88000}]
[null,3,"Watchman",4000,11,{"$f":"E11*D11","v":44000}]
[null,4,"Sweeper",2500,11,{"$f":"E12*D12","v":27500}]
[null,5,"Scavenger",2500,11,{"$f":"E13*D13","v":27500}]
[null,null,"Total",{"$f":"SUM(D9:D13)","v":33000}," ",{"$f":"SUM(F9:F13)","v":363000}]
[null,null,null," ",null," "]
[]
[null,null,"Primary and Secondary: Recurring Education Expenses",null," ",null," "," "," "]
[null,"I","Recurring Expenses","# of Students","Monthly Fees","# of Months","Yearly Fees","Uniform","TextBooks ","Teachers/Staff Salary","Total","Total Annual Per Child"]
[null,1,"Seva Chakkara Nursery & Primary School ",20,35000,11,0,30000,20000,363000,448000,22400]
[null,2,"Sivakasi Matriculation Hr.Sec.Sc",6,8159,11,89750,12000,18000,null,{"$f":"SUM(G20:J20)","v":119750},19958]
[null,3,"High School Students",55,28301,11,311320,123750,46750,null,481820,8760]
[null,4,"Higher Secondary School  Students ",14,9986,10,109850,31500,14000,null,{"$f":"SUM(G22:I22)","v":155350},11096]
[null,5,"I.T.I Technical Education",2,3333,6,20000,2000," Nil",null,{"$f":"SUM(G23:I23)","v":22000},11000]
[null,6,"Diffrently abled ","Nil"]
[null,7,"Arts & Science College",12,20203,11,222240,14000,21000,null,{"$f":"SUM(G25:I25)","v":257240},21436]
[null,8,"P.G Course  College",1,5000,11,55000,2000,10000,null,{"$f":"SUM(G26:I26)","v":67000},67000]
[null,null,"Sub Total",{"$f":"SUM(D19:D26)","v":110},109982,null,{"$f":"SUM(G20:G26)","v":808160},{"$f":"SUM(H19:H26)","v":215250},{"$f":"SUM(I19:I26)","v":129750},{"$f":"SUM(J19:J26)","v":363000},1551160,{"$f":"SUM(L19:L26)","v":161650},1551160]
[null,null,null," "," "," "," "," "," "," "," "]
[null,"II","Non- Recurring Expenses"]
[null,null,"Charts         ",{"$nulls":7},2500]
[null,null,"4 Block Board ",{"$nulls":7},6500]
[null,null,"Amenities",{"$nulls":7},10000]
[null,null,"Sub Total ",{"$nulls":7},{"$f":"SUM(K30:K32)","v":19000},null,19000]
[]
[null,"I & II","Total",{"$nulls":7},{"$f":"SUM(K27,K33)","v":1570160}]
[]
[null,"III","Misc Educational Related Expenses","Description",null,"Monthly Expenses","# of Months",null,null,null,"Yearly Total"]
[null,1,"Conveyance","Transport from Seva Chakkara to their colleges/ Lab Technician ",null,4500,10,null,null,null,{"$f":"G38*F38","v":45000}]
[null,2,"Food","Lunch food, evening tea & biscuits",null,4500,10,null,null,null,45000]
[null,3,"Notebook & Stationary",null,null,8000,10,null,null,null,80000]
[null,4,"Private Tuition",null,null,15000,10,null,null,null,150000]
[null,5,"Unit Test Examination",null,null,7000,10,null,null,null,70000]
[null,6,"News paper & Magazine",null,null,3000,12,null,null,null,36000," "]
[null,7,"Photo copy charges for Programs",null,null,2700,10,null,null,null,27000]
[null,8,"College Students books/periodicals",null,null,7000,10,null,null,null,70000]
[null,9,"Training expenses I.T.I. Students",null,null,3000,10,null,null,null,30000]
[null,10,"Additional outside tuition",null,null,7000,10,null,null,null,70000]
[null,null,"Sub Total",null,null,61700,{"$nulls":4},{"$f":"SUM(K38:K47)","v":623000},null,623000]
[{"$nulls":10}," "]
[]
[null,"I & II & III","Total",{"$nulls":7},2193160,null,{"$f":"SUM(M27:M50)","v":2193160}]

{"sheet":"Edu Comparison","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,2015,{"$nulls":6},2014]
[]
[null,"I","Recurring Expenses","# of Students",{"$nulls":4},"I","Recurring Expenses","# of Students"]
[null,1,"Seva Chakkara Nursery & Primary School ",20,{"$nulls":4},1,"Seva Chakkara Nursery & Primary School ",22]
[null,2,"Sivakasi Matriculation Hr.Sec.Sc",6,{"$nulls":4},2,"Alagappa School Matriculation",7]
[null,3,"High School Students",55,{"$nulls":4},3,"High School Students",57]
[null,4,"Higher Secondary School  Students ",14,{"$nulls":4},4,"Higher Secondary School  Students ",10]
[null,5,"I.T.I Technical Education",2,{"$nulls":4},5,"I.T.I Technical Education",1]
[null,6,"Diffrently abled ","Nil",{"$nulls":4},6,"Diffrently abled ",2]
[null,7,"Arts & Science College",12,{"$nulls":4},7,"Arts & Science College",7]
[null,8,"P.G Course  College",1,{"$nulls":4},8,"Teachers Traning College",1]
[{"$nulls":8},9,"Lap Technician ",1]
[null,null,"Sub Total",{"$f":"SUM(D6:D13)","v":110},{"$nulls":5},"Sub Total",{"$f":"SUM(K6:K14)","v":108}]

{"sheet":"Food","index":3,"n_rows":110,"n_cols":12,"rows_kept":110,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[4,1,4,2],[20,1,20,2],[63,1,63,2]]}
[]
[null,"Seva Chakkara:"]
[null,"Food Items"]
[]
[null,"Daily Essential Items",null,null," ",null," "]
[null,null,null," "]
[null,null,"Food Item",null,"# of Children","Total Quantity\nPer Day","Total Quantity\nPer Month",null,"Cost per Item ","Total Monthly Expense"]
[null,null,null,"Total"]
[]
[null,null,"Milk",null,108,25,750,"L",44,{"$f":"I10*G10","v":33000}]
[null,null,"Rice Govt.",null,108,20,300,"kg",1,{"$f":"I11*G11","v":300}]
[null,null,"Out side Rice",null,108,15,450,"kg",40,18000]
[null,null,"Sugar Govt.",null,108,5,61,"kg",13.5,824]
[null,null,"Out Side Sugar",null,108,5,89,"kg",32,2848]
[null,null,"Wheat Govt.",null,108,5,50,"kg",7.5,375]
[null,null,"Out side Wheat",null,108,5,25,"kg",20,500]
[null,null,"Gas Cylinder",null,null,null,25,"Nos",614,15350]
[null,null,"Total Daily Essential Items",null,null," ",null,null,null,{"$f":"SUM(J10:J17)","v":71197}]
[]
[]
[null,"Monthly Food Expenses"]
[null,"Sl.No.","List of Provision & Groceries","Quantity \nRequired","Unit \nPrice","Monthly \nExpenses","# of Months",null,"Yearly Expense"]
[]
[null,1,"Essential Food Items (from above)",null,null,71197,12,null,{"$f":"G24*F24","v":854364}]
[null,2,"Toor Dhal ",125,115,{"$f":"E25*D25","v":14375},{"$f":"G24","v":12},null,{"$f":"G25*F25","v":172500}," "]
[null,3,"Ured Dhal",95,115,10925,{"$f":"G25","v":12},null,131100," "]
[null,4,"Moon Dhal",65,105,6825,12,null,81900," "]
[null,5,"Garam Dhal",65,68,{"$f":"E28*D28","v":4420},12,null,53040]
[null,6,"Mustard",8,80,640,12,null,7680]
[null,7,"Pepper",5,700,3500,12,null,42000]
[null,8,"Jeera",7,260,1820,12,null,21840]
[null,9,"Methi",3,110,330,12,null,3960," "]
[null,10,"L.G. Asafoetida",2,1150,2300,12,null,27600]
[null,11,"Turmeric Powder",4,130,520,12,null,6240,null,null," "]
[null,12,"Tamarind",33,70,2310,12,null,27720,null,null," "]
[null,13,"Gundu Chillies",15,90,1350,12,null,16200]
[null,14,"Dhaniya Local",30,140,4200,12,null,50400]
[null,15,"Cooking Oil",155,75,11625,12,null,139500,null," "]
[null,16,"Coconut Oil",7,180,1260,12,null,15120]
[null,17,"Gingely Oil",16,170,2720,12,null,32640]
[null,18,"Bengal gram",12,60,720,12,null,8640]
[null,19,"Salt",55,10,550,12,null,6600]
[null,20,"Jaggery",20,44,880,12,null,10560]
[null,21,"Tea Powder",7,200,1400,12,null,16800]
[null,22,"Vermicelli",25,46,1150,12,null,13800]
[null,23,"Sooji",36,33,1188,12,null,14256]
[null,24,"Chashew",2,600,1200,12,null,14400]
[null,25,"Cardamon",0.5,1000,500,12,null,6000," "]
[null,26,"Drygrapes",2,300,600,12,null,7200]
[null,27,"Spoces",1,675,675,12,null,8100]
[null,28,"Applam",15,170,2550,12,null,30600]
[null,29,"Match Box",7,8,56,12,null,672]
[null,30,"Soap (Washing)",350,9,3150,12,null,37800]
[null,31,"Soap(Bathing)",220,22,4840,12,null,58080]
[null,32,"Sabena",10,45,450,12,null,5400]
[null,33,"Vim Dish was bar",20,10,200,12,null,2400]
[null,34,"Phenyle",50,50,2500,12,null,30000]
[null,35,"Blecing Powder",20,35,700,12,null,8400]
[null,36,"Water Tax & Charges 2 Building",0,0,2791,12,null,{"$f":"G59*F59","v":33492},166417,1997004]
[null,37,"Vegetables ( from Below)",null,1041,31231,12,null,{"$f":"G60*F60","v":374772},31231,374772]
[null,null,"Total",null,null,{"$f":"SUM(F24:F60)","v":197648},null,null,{"$f":"SUM(I24:I60)","v":2371776},{"$f":"SUM(J59:J60)","v":197648},{"$f":"SUM(K59:K60)","v":2371776}]
[]
[]
[null,"Monthly Vegetables  Expenses Average",null," "]
[null,"Sl.No.","List of Provision & Groceries","Quantity \nRequired","Unit \nPrice","Monthly \nExpenses","# of Months",null,"Yearly Expense"]
[]
[null,1,"Tomato",150,25,{"$f":"E67*D67","v":3750},12,null,{"$f":"G67*F67","v":45000}]
[null,2,"Carrot",28,30,840,12,null,10080]
[null,3,"Beetroot",28,25,700,12,null,8400]
[null,4,"Raddish",20,18,360,12,null,4320]
[null,5,"Brinjal",72,25,1800,12,null,21600]
[null,6,"Turnip",15,15,225,12,null,2700]
[null,7,"Lady'sfinger",32,30,960,12,null,11520]
[null,8,"Cabbage",25,10,250,12,null,3000]
[null,9,"Beans",28,80,2240,12,null,26880]
[null,10,"Potato",72,20,1440,12,null,17280]
[null,11,"Greens",68,15,1020,12,null,12240]
[null,12,"Bottle guard",20,20,{"$f":"E78*D78","v":400},12,null,4800]
[null,13,"Rawplantain",30,30,900,12,null,10800]
[null,14,"Corn",25,30,750,12,null,9000]
[null,15,"Bittergourd",20,30,600,12,null,7200]
[null,16,"Peas",15,30,450,12,null,5400]
[null,17,"Cauliflower",28,32,896,12,null,10752]
[null,18,"Onion",150,40,6000,12,null,72000]
[null,19,"Drumstick",40,50,2000,12,null,24000]
[null,20,"Pumpkin",15,15,225,12,null,2700]
[null,21,"Capsicum",15,35,525,12,null,6300]
[null,22,"Cucumber",15,35,525,12,null,6300]
[null,23,"Ginger",15,50,750,12,null,9000]
[null,24,"Mushroom",15,40,600,12,null,7200]
[null,25,"spinach",5,40,200,12,null,2400]
[null,26,"garlic",25,80,2000,12,null,24000]
[null,27,"Sweet Potatoes",15,30,450,12,null,5400]
[null,28,"Pudina",15,15,225,12,null,2700]
[null,29,"Curry leaves",15,10,150,12,null,{"$f":"G95*F95","v":1800}]
[]
[null,null,"Total",null,null,{"$f":"SUM(F67:F96)","v":31231},null,null,{"$f":"SUM(I67:I96)","v":374772}]
[]
[]
[null,"I & II","Total",{"$nulls":5},2371776]
[]
[]
[]
[]
[null,null,null," "," "]
[{"$nulls":4}," "]
[]
[]
[]
[{"$nulls":4}," "]

{"sheet":"Administration","index":4,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[39,2,39,3]]}
[]
[]
[null,"Section","Project"]
[]
[null,"I","Orphanage Staff Salary","Description","Monthly Expenses","# of Months","Yearly Expense"]
[null,1,"Administrative Officer",null,4500,12,{"$f":"E6*F6","v":54000}]
[null,2,"Cook (2)",null,7000,{"$f":"F6","v":12},84000]
[null,3,"Asst. Cook 1",null,3000,12,36000]
[null,4,"Store Keeper",null,3500,12,42000]
[null,5,"Medical Asst.",null,3000,12,36000]
[null,6,"Boys & Girls Warden (2)",null,10000,12,120000]
[null,7,"Office Asst.",null,4000,12,48000]
[null,8,"Driver (Auto)",null,5000,12,60000]
[null,null,"Sub Total",null,{"$f":"SUM(E6:E13)","v":40000},null,{"$f":"SUM(G6:G13)","v":480000},null,40000,480000]
[]
[]
[null,"II","Administration & Maintenance","Description","Monthly Expenses","# of Months","Yearly Expense"]
[null,null,"Computer maintenance",null,700,{"$f":"F13","v":12},{"$f":"E18*F18","v":8400}]
[null,null,"Computer Sheet",null,800,{"$f":"F18","v":12},9600]
[null,null,"Courier charges",null,400,12,4800]
[null,null,"Photo expenses",null,2000,12,24000]
[null,null,"Binding charges",null,1000,12,12000]
[null,null,"Sanitation",null,1500,12,18000]
[null,null,"Orphanage cleaning charges",null,600,12,7200]
[null,null,"Electricity",null,30000,12,360000]
[null,null,"Telephones ","(2) approximately",4500,12,54000]
[null,null,"Transportation",null,1500,12,18000]
[null,null,"Conveyance for own Auto",null,15500,12,186000]
[null,null,"Vehicle repair (1 Auto, 1 Van 2 Cycles)",null,1500,12,18000]
[null,null,"Building maintenance",null,500,12,6000," "]
[null,null,"Furniture & Fitting Maintenance",null,500,12,6000]
[null,null,"Primary & Nursery School maintenance",null,500,12,6000]
[null,null,"Sundry",null,4680,12,56160]
[null,null,"Sub Total",null,{"$f":"SUM(E18:E33)","v":66180},null,{"$f":"SUM(G18:G33)","v":794160},null,66180,794160]
[]
[null,"III","Children Health, Food & Recreation","Description","Monthly Expenses","# of Months","Yearly Expense"]
[null,null,"Pooja expenses",null,800,{"$f":"F33","v":12},{"$f":"E37*F37","v":9600}]
[null,null,"Kids, children, excursion",null,1000,{"$f":"F37","v":12},12000]
[null,null,"Dress Materials inner garments",null,1500,12,18000]
[null,null,"Bed Materials                                                                                                ",null,500,12,6000]
[null,null,"Mosquito mats",null,500,12,6000]
[null,null,"Broom ( 2 Buildings)",null,400,12,4800]
[null,null,"Spindle Broom",null,200,12,2400]
[null,null,"Litmus perfume for toilet ",null,250,12,3000]
[null,null,"Gas repair",null,200,12,2400]
[null,null,"Napkins expense (??)",null,1200,12,14400]
[null,null,"Honorarium  ",null,5000,12,60000]
[null,null,"Medical","average expenditure",10000,12,120000]
[null,null,"Sub Total",null,{"$f":"SUM(E37:E48)","v":21550},null,{"$f":"SUM(G37:G48)","v":258600},null,21550,258600]
[]
[]
[null,"I & II &   ","III  Total",null,127730,null,1532760,null,{"$f":"SUM(I14:I51)","v":127730},{"$f":"SUM(J14:J51)","v":1532760}]