{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Food And Rent 2013-14","Food and Rent 2012-13","Donations-2012-13","Expenses 2013-14","Budget 2014-15","Donation 2013-14"],"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":"Food And Rent 2013-14","index":0,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"SRI SAI SEVA SADAN "]
[null,null,"2013-14 (up to 02/14)"]
["FOOD EXPENSES"]
[]
["DATE","AMOUNT","PARTICULARS"]
[null,"A)Paid From Foreign Funds",null,"FOOD PROVISIONS","MILK"]
["02.04.2013",{"$f":"SUM(D8:E8)","v":420},"Gas",420,0]
["27.04.2013",2307,"Food Provisions & Vegtables",{"$f":"1637+670","v":2307},0]
["18.06.2013",5987,"Food Provisions & Vegtables",5987,0]
["25.06.2013",830,"Gas",830,0]
["04.07.2013",18008,"Food Provisions & Vegtables, Milk",17742,266]
["05.07.2013",3348,"Milk",0,{"$f":"1116+2232","v":3348}]
["11.07.2013",2199,"Vegtables",2199,0]
["26.07.2013",1176,"Vegtables",1176,0]
["01.08.2013",3216,"Food Provisions & Vegtables, Milk, Gas",{"$f":"144+840","v":984},2232]
["28.08.2013",20153,"Food Provisions & Vegtables, Gas",{"$f":"16748+2775+630","v":20153},0]
["05.10.2013",300,"Vegtables",300,0]
["17.10.2013",9394,"Food Provisions & Vegtables, Milk",{"$f":"8032+30","v":8062},1332]
["18.10.2013",2200,"Gas",2200,0]
["24.10.2013",618,"Vegtables ",618,0]
["06.11.2013",18050,"Food Provisions & Milk",15890,2160]
["19.11.2013",5218,"Food Provisions & Vegtables, Gas",{"$f":"1928+3150+140","v":5218},0]
["21.11.2013",700,"Vegtables ",700,0]
["30.11.2013",592,"Vegtables ",{"$f":"527+65","v":592},0]
["06.12.2013",18280,"Food Provisions & Milk",{"$f":"16048","v":16048},2232]
["16.12.2013",1271,"Food Provisions & Vegtables",{"$f":"772+499","v":1271},0]
["31.12.2013",3158,"Food Provisions & Vegtables, Gas",{"$f":"477+451+2230","v":3158},0]
["06.02.2014",18431,"Food Provisions & Vegtables, Milk",16415,2016]
["20.02.2014",3805,"Vegtables & Gas",{"$f":"1350+2455","v":3805},0]
[null,{"$f":"SUM(B8:B30)","v":139661}]
[null,"B)Paid From Indian Funds"]
["02.09.2013",{"$f":"SUM(D33:E33)","v":2060},"Gas",2060,0]
["06.09.2013",2160,"Milk",0,2160]
["08.09.2013",14731,"Food Provisions & Vegtables",{"$f":"14065+666","v":14731},0]
["29.09.2013",1581,"Food Provisions & Vegtables",{"$f":"1091+180+310","v":1581},0]
["06.01.2013",1823,"Milk",0,1823]
["21.01.2014",10335,"Food Provisions & Vegtables",{"$f":"10153+182","v":10335},0]
["27.01.2013",3586,"Vegtables & Gas",{"$f":"911+2675","v":3586},0]
[null,{"$f":"SUM(B33:B39)","v":36276}]
["TOTAL",{"$f":"B31+B40","v":175937},null,{"$f":"SUM(D8:D39)","v":158368},{"$f":"SUM(E8:E39)","v":17569}]
[]
["RENT"]
["05.05.2013",null,35000]
["10.07.2013",null,70000]
["01.08.2013",null,35000]
["05.09.2013",null,35000]
["04.10.2013",null,35000]
["06.11.2013",null,35000]
["06.12.2013",null,35000]
["04.01.2013",null,35000]
["06.02.2013",null,35000]
["TOTAL",null,{"$f":"SUM(C44:C52)","v":350000}]

{"sheet":"Food and Rent 2012-13","index":1,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"SRI SAI SEVA SADAN "]
[null,"2012-13"]
[]
["FOOD EXPENSES"]
[]
["DATE","AMOUNT","PARTICULARS"]
[null,"A)Paid From Foreign Funds",null,"FOOD PROVISIONS","MILK"]
[]
["8.10.2012",{"$f":"SUM(D12:E12)","v":10060},"Vegtables & Food Provisions, Milk",{"$f":"500+8750+522","v":9772},288]
["15.10.2012",{"$f":"SUM(D13:E13)","v":2607},"Vegtables & Gas,milk",{"$f":"1230+501+60","v":1791},816]
["31.10.2012",1384,"Vegtables & Gas,milk",{"$f":"420+562+62","v":1044},340]
["12.11.2012",17409,"Food Provisions & Vegtables, Milk",{"$f":"115+14303+531+420","v":15369},2040]
["15.11.2012",521,"Vegtables ",521,0]
["20.11.2012",23776,"Food Provisions & Vegtables, Milk",{"$f":"1663+1970+17750+285","v":21668},2108]
["31.12.2012",3271,"Food Provisions & Vegtables, Gas",{"$f":"1737+980+554","v":3271},0]
["05.01.2013",13077,"Food Provisions",13077,0]
["29.01.2013",3402,"Vegtables & Gas,milk",{"$f":"910+980","v":1890},1512]
["23.02.2013",{"$f":"SUM(D21:E21)","v":18943},"Food Provisions & Vegtables, Milk",{"$f":"2670+12270+1469+518","v":16927},2016]
["18.03.2013",{"$f":"SUM(D22:E22)","v":16904},"Food Provisions & Vegtables, Milk",{"$f":"12964+1191+420+97","v":14672},2232]
["21.03.2013",1000,"Gas",1000,0]
["26.03.2013",469,"Vegtables ",469,0]
["30.03.2013",12247,"Food Provisions & Milk",10447,1800]
[null,{"$f":"SUM(B12:B25)","v":125070}]
[null,"B)Paid From Indian Funds"]
["30.04.2012",{"$f":"SUM(D28:E28)","v":13467},"Food Provisions & Vegtables, Gas,Milk",{"$f":"9716+1120+1167","v":12003},{"$f":"1280+184","v":1464}]
["28.06.2012",6005,"Food Provisions & Vegtables, Gas,Milk",{"$f":"4756+789+410","v":5955},50]
["27.07.2012",5241,"Vegtables & Milk",2373,{"$f":"2780+88","v":2868}]
["30.07.2012",14479,"Food Provisions & Gas",{"$f":"13669+810","v":14479},0]
["09.08.2012",18412,"Food Provisions & Vegtables,Milk",{"$f":"15803+501","v":16304},2108]
["27.08.2012",2709,"Vegtables & Gas",{"$f":"1230+1479","v":2709},0]
["07.09.2012",19680,"Food Provisions & Vegtables,Milk",{"$f":"16893+503+244","v":17640},2040]
["25.09.2012",2023,"Vegtables & Gas",{"$f":"1513+410+100","v":2023},0]
[null,{"$f":"SUM(B28:B35)","v":82016}]
["TOTAL",{"$f":"B26+B36","v":207086},null,{"$f":"SUM(D12:D36)","v":185404},{"$f":"SUM(E12:E36)","v":21682}]
[]
["RENT"]
["04.04.2012",null,30000]
["05.05.2012",null,30000]
["09.08.2012",null,60000]
["05.09.2012",null,60000]
["4.10.2012",null,30000]
["5.11.2012",null,30000]
["5.12.2012",null,35000]
["5.01.2013",null,35000]
["5.02.2013",null,35000]
["6.03.2013",null,35000]
["30.03.2013",null,35000]
[null,null,"               "]
["TOTAL",null,{"$f":"SUM(C40:C51)","v":415000}]

{"sheet":"Donations-2012-13","index":2,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":true,"merged":[[38,3,38,4]]}
[]
[]
[null,null,null,"Donations Received for the Year 2012-13"]
[]
[]
[null,null,"a)","Asha:"]
[{"$nulls":4},"Date","Amount"]
[{"$nulls":4},"10.9.2012",500044.91]
[{"$nulls":4},"23.01.2013",799630]
[{"$nulls":4},"Total",{"$f":"SUM(F8:F9)","v":1299674.9099999999}]
[]
[null,null,"b)","Non Asha: (Indian Donations)"]
[]
[null,null,null,"Donations Received in Cash"]
[null,null,null,"i) Spandana Educational Trust ","Date","Amount"]
[{"$nulls":4},"28.08.2012",200000]
[{"$nulls":4},"15.01.2013",42000]
[{"$nulls":4},"16.01.2013",42000]
[{"$nulls":4},"15.02.2013",42000]
[{"$nulls":4},"15.03.2013",42000]
[{"$nulls":4},"Total",{"$f":"SUM(F16:F20)","v":368000}]
[]
[null,null,null,"ii)M S Raju","5.12.2012",500]
[{"$nulls":4},"18.12.2012",1000]
[{"$nulls":4},"28.12.2012",1000]
[{"$nulls":4},"07.11.2012",1500]
[{"$nulls":4},"07.02.2013",1000]
[{"$nulls":4},"31.03.2013",1000]
[{"$nulls":4},"Total",{"$f":"SUM(F23:F28)","v":6000}]
[]
[null,null,null,"iii) Others","Up to 31.03.2013",{"$f":"700+10000+3500+3500+3500+3500+3500+10000+261+551+3500+5001+1000+3500+3500+5000+6000+3500+3000+3500+5000","v":81513}]
[{"$nulls":4},"Hundi Collection",1375]
[{"$nulls":4},"Total (Non Asha Cash)",{"$f":"F21+F29+F31","v":455513}]
[]
[null,null,null,"Donations Received in Kind",null,7500]
[]
[{"$nulls":4},"Total Donations",{"$f":"F33+F35+F32","v":464388}]
[]
[null,null,null,"SUMMARY"]
[null,null,null,"Asha",{"$f":"F10","v":1299674.9099999999}]
[null,null,null,"Non Asha (Indian Donations)",{"$f":"F37","v":464388},"  "]
[{"$nulls":4},{"$f":"SUM(E40:E41)","v":1764062.91}]

{"sheet":"Expenses 2013-14","index":3,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2]]}
[]
[null,"SRI SAI SEVA SADAN"]
[null,"SUMMARY OF EXPENSES (2013-14)"]
[null,null,"(Audited)"]
[null,"Particulars","Amount (`)"]
[]
[null,"Admistration Expenses"]
[null,"Raw Materials Purchases",34770]
[null,"Advertisement",4000.11]
[null,"Bank Charges",112]
[null,"Conveyance",2788]
[null,"Electricity Charges",22909]
[null,"Medical Expenses",6814]
[null,"Misc. Expenses",4499]
[null,"Postage & Telegram",684]
[null,"Printing & Stationary",4365]
[null,"Repairs & Maintenance",8547]
[null,"Telephone Expenses",10138]
[null,"Travelling Expenses",1643.6]
[null,"Transportation Expenses",1700]
[null,"Interest paid on T.D.S.",35002]
[null,"Total",{"$f":"SUM(C8:C21)","v":137971.71000000002}]
[]
[null,"Salaries & Wages",637990.40000000002]
[null,"Rent",385000]
[null,"Food Expenses",196851.4]
[null,"Total",{"$f":"SUM(C24:C26)","v":1219841.8}]
[]
[null,"Grand Total",{"$f":"+C27+C22","v":1357813.51}]
[]
[]
[null,"Caluclation of Expenditure per Student :"]
[]
[null,"Particulars","Amount (`)"]
[null,"Number of Students (19 Residential+10Day care)",29]
[null,"Expenditure/Student/Year",{"$f":"C29/C35","v":46821.155517241379}]
[null,"Expenditure/Student/Month",{"$f":"C36/12","v":3901.7629597701148}]

{"sheet":"Budget 2014-15","index":4,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[46,2,46,8],[0,1,0,8],[1,1,1,8],[2,1,2,8],[3,1,3,9],[5,2,5,5]]}
[null,"SRI SAI SEVA SADAN"]
[null,"HYDERABAD"]
[null,"Budget Estimation for the Year 2014-15"]
[null,"A scheme showing the financial commitment for 25 moderate and mild learning disability children/ adolescent in Fostercare home (Residential Special school/  Day care school) of Residential and 20 Day care Students."]
[]
[null,null,"Particulars",null,null,null,"No.of posts","Salary for each post","Expenditure per month"]
[null,"A","Full Time Staff"]
[null,null,"Warden",null,null,null,1,11000,{"$f":"G8*H8","v":11000}]
[null,null,"Foster Care Father",null,null,null,1,5500,{"$f":"G9*H9","v":5500}]
[null,null,"Special Educator"]
[null,null,"1 Teacher for Every 6 Students",null,null,null,4,10000,40000]
[null,null,"Sr.Splecial Educator",null,null,null,1,13000,13000]
[null,null,"Resident Administrator cum Accounts",null,null,null,1,10000,10000]
[null,null,"Cook",null,null,null,1,6500,6500]
[null,null,"Helpers",null,null,null,2,4000,8000]
[null,null,"Driver",null,null,null,1,11000,11000]
[{"$nulls":5},"Sub Total",null,null,{"$f":"SUM(I8:I16)","v":105000}]
[null,"B","Part Time Staff"]
[null,null,"Psychiatric Doctor",null,null,null,1,10000,{"$f":"G19*H19","v":10000}]
[null,null,"Speech Therapyst",null,null,null,1,10000,10000]
[null,null,"Tabala/ Key Board Master",null,null,null,1,3000,3000]
[null,null,"Yoga Master",null,null,null,1,3000,3000]
[{"$nulls":5},"Sub Total",null,null,{"$f":"SUM(I19:I22)","v":26000}]
[]
[null,"C","Other Recurring Expenditure"]
[null,null,"Boarding Expenses at Rs.40/-   Student/ Day"]
[null,null,"For 30 days for 25 students",{"$nulls":5},{"$f":"30*25*40","v":30000}]
[null,null,"Rent for 2 Floors (4,000 sq.ft.)",{"$nulls":5},40000]
[null,null,"Transportation & Conveyance",{"$nulls":5},1000]
[null,null,"Water & Electricity Expenses",{"$nulls":5},3000]
[null,null,"Telephone Expenses",{"$nulls":5},4000]
[null,null,"Medical Expenses",{"$nulls":5},1000]
[null,null,"Miscellaneous Expenses",{"$nulls":5},2000]
[null,null,"Printing and Stationery",{"$nulls":5},2000]
[null,null,"Diesel Expenses for School Bus",{"$nulls":5},7000]
[null,null,"Vehicle Maintenance for School Bus",{"$nulls":5},500]
[null,null,"Road Tax for School Bus",{"$nulls":5},2000]
[null,null,"Insurance",{"$nulls":5},1000]
[{"$nulls":8},{"$f":"SUM(I27:I38)","v":93500}]
[null,"D","Non - Recurring Expenditure"]
[null,null,"Student Desk, Benches & Other Equipments",{"$nulls":5},6000]
[{"$nulls":8},{"$f":"SUM(I41)","v":6000}]
[]
[]
[]
[]
[null,null,"SUMMARY"]
[]
[null,null,"Particulars",{"$nulls":4},"Per Month","Per Annuam"]
[]
[null,"A","Full Time Staff",{"$nulls":4},{"$f":"I17","v":105000},{"$f":"H51*12","v":1260000}]
[null,"B","Part Time Staff",{"$nulls":4},{"$f":"I23","v":26000},{"$f":"H52*12","v":312000}]
[null,"C","Other Recurring Expenditure",{"$nulls":4},{"$f":"I39","v":93500},1122000]
[{"$nulls":7},{"$f":"SUM(H51:H53)","v":224500},{"$f":"SUM(I51:I53)","v":2694000}]
[null,"D","Non - Recurring Expenditure",{"$nulls":5},{"$f":"I42","v":6000}]
[]
[null,null,"Total Funds required for the Year",{"$nulls":5},{"$f":"SUM(I54:I56)","v":2700000}]
[]
[null,"a)","80% of the funds from Asha for Educaion, USA",{"$nulls":5},{"$f":"I57*80%","v":2160000}]
[null,"b)","20% of  the funds to be organised by Sri Sai Seva Sadan",{"$nulls":5},{"$f":"I57*20%","v":540000}]
[{"$nulls":8},{"$f":"SUM(I59:I60)","v":2700000}]

{"sheet":"Donation 2013-14","index":5,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,3,0,5],[1,3,1,5]]}
[null,null,null,"SRI SAI SEVA SADAN"]
[null,null,null,"Donations Received for the Year 2013-14 "]
[]
[null,null,"a)","Asha for Education:"]
[{"$nulls":4},"Date","Amount"]
[{"$nulls":4},"11.06.2013",806000]
[{"$nulls":4},"Total",{"$f":"SUM(F6:F6)","v":806000}]
[null,null,"b)","Otherthan Asha for Education (Indian Donations):"]
[]
[null,null,null,"Donations Received in Cash:"]
[null,null,null,"i) Spandana Educational Trust "]
[{"$nulls":4},"Date","Amount"]
[{"$nulls":4},"26.04.2013",42000]
[{"$nulls":4},"15.05.2013",42000]
[{"$nulls":4},"15.06.2013",42000]
[{"$nulls":4},"15.07.2013",42000]
[{"$nulls":4},"30.08.2013",42000]
[{"$nulls":4},"16.09.2013",42000]
[{"$nulls":4},"15.10.2013",42000]
[{"$nulls":4},"19.12.2013",42000]
[{"$nulls":4},"15.01.2014",42000]
[{"$nulls":4},"15.02.2014",42000]
[{"$nulls":4},"15.03.2014",42000]
[{"$nulls":4},"Total",{"$f":"SUM(F13:F23)","v":462000}]
[]
[null,null,null,"ii)M S Raju","30.04.2013",2000]
[{"$nulls":4},"10.07.2013",2000]
[{"$nulls":4},"06.08.2013",2000]
[{"$nulls":4},"23.09.2013",1500]
[{"$nulls":4},"14.10.2013",1500]
[{"$nulls":4},"01.11.2013",1500]
[{"$nulls":4},"15.01.2014",1500]
[{"$nulls":4},"05.02.2014",1500]
[{"$nulls":4},"07.03.2014",1500]
[{"$nulls":5},{"$f":"SUM(F26:F34)","v":15000}]
[]
[null,null,null,"iv) Corpus Fund Donations",null,68002]
[]
[null,null,null,"iii) Others Donations",null,{"$f":"3500+5000+3100+2500+2500+10001+1000+4000+500+6000+10000","v":48101}]
[]
[null,null,null,"iv) Hundi Collection",null,6044]
[{"$nulls":4},"Total",{"$f":"+F41+F39+F35+F24+F37","v":599147}]
[]
[{"$nulls":4},"Grand Total",{"$f":"+F42+F7","v":1405147}]
[]
[{"$nulls":4},"Summary"]
[null,null,null,"Donations from Asha for Education",null,null,null,{"$f":"F7","v":806000}]
[null,null,null,"Donations from Otherthan Asha for Education(Indian Donations):",null,null,null,{"$f":"+F42","v":599147}]
[{"$nulls":7},{"$f":"SUM(H47:H48)","v":1405147}]