{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Edu Expenses","Food","BuildingAdministration"],"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":"Summary","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,2]]}
[null,"Seva Chakkara:"]
[null,"Consolidated Budget"]
[]
[null,null,"Monthly Expense",null,"Yearly Expense ","Yearly Expense "]
[null,"Items","Indian Rupee","# of Months","Indian Rupee","USD"]
[]
[null,"All Food Items",{"$f":"E7/D7","v":92827.61},12,1113931.32,{"$f":"E7/$C$17","v":24754.029333333336}]
[]
[null,"Education",{"$f":"E9/D9","v":98774.545454545456},11,1086520,{"$f":"E9/$C$17","v":24754.029333333336},"(Request for Funding from NYCNJ Chapter)"]
[]
[null,"Administration & Maintenance",{"$f":"E11/D11","v":62335},12,748020,{"$f":"E11/$C$17","v":16622.666666666668}]
[]
[null,"Totals",{"$f":"SUM(C7:C12)","v":253937.15545454546},null,{"$f":"SUM(E7:E12)","v":2948471.3200000003},{"$f":"E13/$C$17","v":65521.584888888894}]
[null,null," ",null,null," "]
[]
[]
[null,"USD / INR Exchange Rate",45]
[]
[null,"Guide:  Input cells in Blue; output cells in Black"]

{"sheet":"Edu Expenses","index":1,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[[41,6,41,7],[42,6,42,7],[43,6,43,7]]}
[null,"            Seva Chakkara:  Educational Expenses 2011-2012",{"$nulls":7},"USD Conversion",45]
[]
[null,null,"Nursery and Primary:  Teacher/Staff Salaries"]
[]
[null,null,"Item",{"$nulls":4},"Monthly ","# of Months","Yearly"]
[null,1,"4 Teachers + Head Master (H.M.)",{"$nulls":4},15500,11,{"$f":"I6*#REF!","v":170500}]
[null,2,"Driver & School Van Driver",{"$nulls":4},9000,11,{"$f":"I7*#REF!","v":99000}]
[null,3,"Watchman",{"$nulls":4},4000,11,{"$f":"I8*#REF!","v":44000}]
[null,4,"Graft Teacher",{"$nulls":4},2500,11,{"$f":"I9*#REF!","v":27500}]
[null,5,"Dance Master",{"$nulls":4},2500,11,{"$f":"I10*#REF!","v":27500}]
[null,4,"Sweeper",{"$nulls":4},1500,11,{"$f":"I11*#REF!","v":16500}]
[null,5,"Scavenger",{"$nulls":4},1000,11,{"$f":"I12*#REF!","v":11000}]
[]
[null,null,"Total",{"$nulls":4},{"$f":"SUM(E7:E13)","v":36000},11,{"$f":"I14*#REF!","v":396000},{"$f":"J14/$K$1","v":8800}]
[]
[]
[]
[null,null,"Primary and Secondary: Recurring Education Expenses"]
[]
[]
["I",null,"Recurring Expenses",null,null,null,"Student Names","                   ","Monthly Fees","# of Months","Yearly Fees","Uniform","TextBooks","Teachers/Staff Salary","Total","Total Annual Per Child"]
[null,1,"Seva Chakkara Nursery & Primary School ",{"$nulls":4},41,{"$f":"J22/#REF!","v":0},11,0,34500,25000,{"$f":"P17","v":396000},"Rs 4,55,500",{"$f":"IF(ISERROR(O22/#REF!),\"NA\",(O22/#REF!))","v":11109.756097560976}]
[null,{"$f":"+B22+1","v":2},"High School Students",{"$nulls":4},53,{"$f":"J23/#REF!","v":3975},11,43725,39400,30700,"NA","Rs 1,17,800",2222]
[null,{"$f":"+B23+1","v":3},"Higher Secondary School  Students ",{"$nulls":4},4,{"$f":"J24/#REF!","v":3000},10,30000,6000,1500,"NA",{"$f":"SUM(#REF!)","v":37500},{"$f":"IF(ISERROR(O24/#REF!),\"NA\",(O24/#REF!))","v":9375}]
[null,{"$f":"+B24+1","v":4},"I.T.I Technical Education",{"$nulls":4},2,{"$f":"J25/#REF!","v":3000},10,30000,17800,8000,"NA",58800,29400]
[null,{"$f":"+B25+1","v":5},"Diffrently abled ",{"$nulls":4},6,{"$f":"J26/#REF!","v":1200},10,12000,2400,4000,"NA",19600,3266]
[null,11,"Engineering",{"$nulls":4},2,12000,10,{"$f":"60000*2","v":120000},"NA",{"$f":"10000","v":10000},"NA",142000,71000]
[null,12,"College",{"$nulls":4},2,{"$f":"J28/#REF!","v":1300},10,13000,1000,1500,"NA",16800,8400]
[null,null,"Sub Total",{"$nulls":4},{"$f":"SUM(H22:H28)","v":110},{"$f":"SUM(I23:I28)","v":24475},null,{"$f":"SUM(K22:K28)","v":248725},{"$f":"SUM(L22:L28)","v":101100},{"$f":"SUM(M22:M28)","v":80700},{"$f":"SUM(N22:N28)","v":396000}," Rs 8,48,000 ","Rs 1,34,773"]
[]
[]
[]
[]
["II",null,"Non- Recurring Expenses"]
[null,null,"Charts         ",{"$nulls":11},1500]
[null,null,"4 Block Board ",{"$nulls":11},5000]
[null,null,"Amenities",{"$nulls":11},7500]
[null,null,"Sub Total ",{"$nulls":11},{"$f":"SUM(O35:O37)","v":14000}]
[]
["I & II",null,"Total",{"$nulls":11},"Rs 8,62,000",{"$f":"862000/$K$1","v":19155.555555555555}]
[]
["lll",null,"Misc Educational Related Expenses",null,null,null,"Description",null,"Monthly Expenses","# of Months",{"$nulls":4},"Yearly Total"]
[null,1,"Conveyance",null,null,null,"Transport from Seva Chakkara to their colleges",null,4500,10,{"$nulls":4},{"$f":"R41*#REF!","v":45000}," "]
[null,2,"Food",null,null,null,"Lunch food, evening tea & biscuits",null,3500,10,{"$nulls":4},{"$f":"R42*#REF!","v":35000},"  "]
[null,3,"Notebook & Stationary",{"$nulls":5},2500,10,{"$nulls":4},25000]
[null,4,"Private Tuition",{"$nulls":5},7000,10,{"$nulls":4},70000]
[null,5,"Unit Test Examination",{"$nulls":5},1800,10,{"$nulls":4},18000]
[null,6,"News paper & Magazine",{"$nulls":5},1800,12,{"$nulls":4},{"$f":"R47*#REF!","v":21600}]
[null,7,"Photo copy charges for Programs",{"$nulls":5},1235,10,{"$nulls":4},{"$f":"R48*#REF!","v":12350}]
[null,8,"College Students books/periodicals",{"$nulls":5},568,10,{"$nulls":4},{"$f":"R49*#REF!","v":5680}]
[null,9,"Training expenses I.T.I. Students",{"$nulls":5},200,10,{"$nulls":4},{"$f":"R50*#REF!","v":2000}]
[null,10,"Additional outside tuition",{"$nulls":5},5500,10,{"$nulls":4},5500]
[]
[null,null,"Sub Total",{"$nulls":5},28603,{"$nulls":5},"Rs 2,40,130",{"$f":"240130/$K$1","v":5002.708333333333}]
[]
[]
["I & II & III",null,"Total",{"$nulls":11},"Rs 11,02,130",{"$f":"1102130/$K$1","v":24491.777777777777}]
[{"$nulls":14},"Rs 11,02,130",{"$f":"1102130/$K$1","v":24491.777777777777}]

{"sheet":"Food","index":2,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Section   Project"]
[]
[]
[null,"I","Orphanage Staff Salary","Description","Monthly Expenses","# of Months","Yearly Expense"]
[null,1,"Administrative Officer",null,3000,12,{"$f":"E6*F6","v":36000}]
[null,2,"Cook (2)",null,5000,{"$f":"F6","v":12},60000]
[null,3,"Asst. Cook 1",null,2000,12,24000]
[null,4,"Store Keeper",null,2000,12,24000]
[null,5,"Medical Asst.",null,2000,12,24000]
[null,6,"Boys & Girls Warden (2)",null,6000,12,72000]
[null,7,"Office Asst.",null,3000,12,36000]
[null,null,"Sub Total",null,23000,null,{"$f":"SUM(G7:G12)","v":276000}]
[]
[]
[null,"II","Administration & Maintenance","Description","Monthly Expenses","# of Months","Yearly Expense"]
[null,null,"Computer maintenance",null,500,{"$f":"#REF!","v":12},{"$f":"E17*F17","v":6000}]
[null,null,"Computer Sheet",null,500,{"$f":"F17","v":12},6000,null," "]
[null,null,"Courier charges",null,140,12,1680]
[null,null,"Photo expenses",null,500,12,6000]
[null,null,"Binding charges",null,248,12,2976]
[null,null,"Sanitation",null,700,12,8400]
[null,null,"Orphanage cleaning charges",null,300,12,3600]
[null,null,"Electricity",null,7000,12,84000]
[null,null,"Telephones ","(2) approximately",3000,12,36000]
[null,null,"Transportation",null,985,12,11820]
[null,null,"Conveyance for own Auto",null,9000,12,108000]
[null,null,"Vehicle repair (1 Auto, 4 Cycles)",null,450,12,5400]
[null,null,"Building maintenance",null,250,12,3000]
[null,null,"Furniture & Fitting Maintenance",null,300,12,3600," "]
[null,null,"Primary & Nursery School maintenance",null,100,12,1200]
[null,null,"Sundry",null,4000,12,48000]
[null,null,"Sub Total",null,{"$f":"SUM(E23:E32)","v":25385},null,{"$f":"SUM(G23:G31)","v":256620}]
[]
[null,"III","Children Health, Food & Recreation","Description","Monthly Expenses","# of Months","Yearly Expense"]
[null,null,"Pooja expenses",null,600,{"$f":"F32","v":12},{"$f":"E36*F36","v":7200}]
[null,null,"Kids, children, excursion",null,500,{"$f":"F36","v":12},6000]
[null,null,"Dress Materials inner garments",null,300,12,3600]
[null,null,"Bed Materials                                                                                                ",null,150,12,1800]
[null,null,"Mosquito mats",null,400,12,4800]
[null,null,"Broom ( 2 Buildings)",null,150,12,1800]
[null,null,"Spindle Broom",null,100,12,1200]
[null,null,"Litmus perfume for toilet ",null,50,12,600]
[null,null,"Gas repair",null,110,12,1320]
[null,null,"Napkins expense (??)",null,90,12,1080]
[null,null,"Honorarium  ",null,4500,12,54000]
[null,null,"Medical","average expenditure",8000,12,96000]
[null,null,"Sub Total",null,{"$f":"SUM(E36:E47)","v":14950},null,{"$f":"SUM(G36:G47)","v":179400}]
[]
[]
[null,"I & II & III","Total",null,"Rs 63,335",null,"Rs 7,12,020"]

{"sheet":"BuildingAdministration","index":3,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":false,"merged":[[60,0,60,1]]}
[null,"Seva Chakkara:"]
[null,"Food Items"]
[]
[null,"Daily Essential Items"]
[]
[null,"Food Item",null,"Qty Per Child",null,"# of Children","Total Qty","Total Qty","Cost per Item ","Total Monthly "]
[null,null,"Morning","Evening","Total",null,"Per Day","Per Month",null,"Expense"]
[]
[null,"Milk",150,170,"320ml",112,35840,"1075.2 L",22,"Rs 23,654"]
[null,"Rice Govt.",100,400,"500g",112,56000,"840.0kg",1,"Rs 840"]
[null,"Out side Rice","NA","NA","NA",112,"NA","300kg",30,"Rs 9000"]
[null,"Sugar",20,20,"40g",112,4480,"134.4kg",18,"Rs 2420"]
[null,"Wheat",10,10,"20g",112,2240,"67.2kg",7.5,"Rs 504"]
[null,"Gas Cylinder","NA","NA","NA",112,"NA","20Nos",370,"Rs 7400"]
[null,"Total Daily Essential Items",{"$nulls":7},"Rs 43,818  "]
[]
[]
[null,"Monthly Food Expenses"]
[]
["Sl.No.","List of Provision & Groceries","Qty Required","Unit price","Monthly Expenses","# of Months","Yearly Expense"]
[1,"Essential Food Items (from above)",null,null,43818,12,"Rs 5,25,816"]
[2,"Toor Dhal ","120Kg",79,9480,12,"Rs 1,13,760"]
[3,"Ured Dhal","45Kg",71,3195,12,"Rs 38,340"]
[4,"Moon Dhal","60Kg",78,4710,12,"Rs 56,520"]
[5,"Garam Dhal","40Kg",38,1520,12,"Rs 18,240"]
[6,"Mustard","6Kg",47,282,12,"Rs 3,384"]
[7,"Pepper","6Kg",305,1830,12,"Rs 21,960"]
[8,"Jeera","6Kg",195,1170,12,"Rs 14,040"]
[9,"Methi","2Kg",46.5,93,12,"Rs 1,116"]
[10,"L.G. Asafoetida","25 Boxes",64.5,1612,12,"Rs 19,344"]
[11,"Turmeric Powder","3Kg",120,720,12,"Rs 8,640"]
[12,"Tamarind","20Kg",108,2160,12,"Rs 25,920"]
[13,"Gundu Chillies","15Kg",127,1905,12,"Rs 22,860"]
[14,"Dhaniya Local","25Kg",76,1900,12,"Rs 22,800"]
[15,"Cooking Oil","130Kg",75,9750,12,"Rs 1,17,000"]
[16,"Coconut Oil","6Kg",224,1344,12,"Rs 16,128"]
[17,"Gingely Oil","20Kg",139,2795,12,"Rs 33,540"]
[18,"Bengal gram","15Kg",40,600,12,"Rs 7,200"]
[19,"Salt","60Kg",13,810,12,"Rs 9,720"]
[20,"Jaggery","30Kg",41,1230,12,"Rs 14,760"]
[21,"Tea Powder","10Kg",255,2550,12,"Rs 30,600"]
[22,"Vermicelli","35Kg",42,1470,12,"Rs 17,640"]
[23,"Sooji","35Kg",12,437,12,"Rs 5,244"]
[24,"Chashew","1.5Kg",590,885,12,"Rs 10,620"]
[25,"Cardamon","0.3gm",820,820,12,"Rs 9,840"]
[26,"Drygrapes","2Kg",180,360,12,"Rs 4,320"]
[27,"Spices","2Kg",250,500,12,"Rs 6,000"]
[28,"Applam","15kg",250,3750,12,"Rs 45,000"]
[29,"Match Box","6 Bandals",5,30,12,"Rs 360"]
[30,"Soap (Washing)","272 Nos",15,4080,12,"Rs 48,960"]
[31,"Soap(Bathing)","272 Nos",13,3536,12,"Rs 42,432"]
[32,"Sabena","25 Packets",12,300,12,"Rs 3,600"]
[33,"Vim Dish was bar","20 Nos",17,340,12,"Rs 4,080"]
[34,"Phenyle","25 Prattle",30,750,12,"Rs 9,000"]
[35,"Blecing Poder","20 Packets",30,750,12,"Rs 9,000"]
[36,"Water Tax & Charges",0,"  ",700,12,"Rs 8,400"]
[37,"Vegetables ( from Below)",869,515,16691,12,"Rs 2,00,280"]
[null,"Total",null,null,128873,null,"Rs15,46,464  "]
[]
[]
["                                             Monthly Vegetables  Expenses Average"]
[]
["Sl.No.","List of Provision & Groceries","Qty Required","Unit price","Monthly Expenses","# of Months","Yearly Expense"]
[1,"Tomato","150kg",6,900,12,"Rs 10,800"]
[2,"Carrot","20kg",64," Rs 1,280",12,"Rs 15,360"]
[3,"Beetroot","20kg",30,"Rs 600",12,"Rs 7,200"]
[4,"Raddish","15kg",20,"Rs 300",12,"Rs 3,600"]
[5,"Brinjal","20kg",25,"Rs 500",12,"Rs 6,000"]
[6,"Turnip","14kg",20,"Rs 280",12,"Rs 3,360"]
[7,"Lady'sfinger","25kg",19,"Rs 475",12,"Rs 5,700"]
[8,"Cabbage","15kg",20,"Rs 300",12,"Rs 3,600"]
[9,"Beans","20kg",35,"Rs  700",12,"Rs 8,400"]
[10,"Potato","25kg",15,"Rs 375",12,"Rs 4,500"]
[11,"Greens","60kg",15,"Rs 900",12,"Rs 10,800"]
[12,"Bottle guard","10kg",14,"Rs 140",12,"Rs 1,680"]
[13,"Rawplantain","15kg",50,"Rs 750",12,"Rs 9,000"]
[14,"Corn","15kg",30,"Rs 450",12,"Rs 5,400"]
[15,"Bittergourd","10kg",25,"Rs 250",12,"Rs 3,000"]
[16,"Peas","8kg",40,"Rs 320",12,"Rs 3,840"]
[17,"Cauliflower","15kg",25,"Rs 375",12,"Rs 4,500"]
[18,"Onion","150kg",30,"Rs 4,500",12,"Rs 54,000"]
[19,"Drumstick","15kg",35,"Rs 525",12,"Rs 6,300"]
[20,"Pumpkin","10kg",20,"Rs 200",12,"Rs 2,400"]
[21,"Capsicum","10kg",30,"Rs 300",12,"Rs 3,600"]
[22,"Cucumber","15kg",25,"Rs 375",12,"Rs 4,500"]
[23,"Ginger","20kg",16,"Rs 320",12,"Rs 3,840"]
[24,"Mushroom","10kg",35,"Rs 350",12,"Rs 4,200"]
[25,"spinach","12kg",70,"Rs 840",12,"Rs 10,800"]
[26,"garlic","100kg",40,"Rs 4,000",12,"Rs 48,000"]
[27,"Sweet Potatoes","20kg",17,"Rs 340",12,"Rs 4,080"]
[28,"Pudina","25kg",15,"Rs 375",12,"Rs 4,500"]
[29,"Curry leaves","25kg",15,"Rs 375",12,"Rs 4,500"]
[]
[null,"Total",null,{"$f":"SUM(D64:D93)","v":801},"Rs 17,815",null,"Rs 2,57,460"]