{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["other","Sheet1"],"not_rendered":{"charts":0,"images":1,"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":"other","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["                      BUDGET FOR VOCATIONAL TRAINING PROJECT FOR 80 DRUG USING STREET YOUTH IN A RESIDENTIAL SET UP"]
[null,"                                                                                                  (One Year- 2011-2012)"]
[]
["No.","Heads","Details","Total","Other","Grant "]
[null,null,"in Rupees","in Rupees","Sources","Requested"]
[1,"Vocational Training Activities"]
[null,"Equipments & Raw Material",null,190000,145000,45000]
[null,"Stipend"]
[null,"Carpentry : 15 boys in 2 batches","Rs.400*4months*15 youth",{"$f":"400*4*15","v":24000}]
[null,"Welding :  15 boys in 2 batches","Rs.400*4months*15 youth",{"$f":"400*4*15","v":24000}]
[null,"Screen printing : 15 boys in 2 batches","Rs.400*4months*15 youth",{"$f":"400*4*15","v":24000}]
[null,"Catering : 15 boys in 2 batches","Rs.400*4months*15 youth",{"$f":"400*4*15","v":24000}]
[null,"Housekeeping : 15 boys in 2 batches","Rs.400*4months*15 youth",{"$f":"400*4*15","v":24000},60000,60000]
[null,"Project conveyance","Rs. 2500*12",{"$f":"2500*12","v":30000},30000]
[2,"Recreation"]
[null,"Events & festival exps.",null,30000,{"$f":"D19","v":30000}]
[null,"Camps & Picnics",null,15000,null,{"$f":"D20","v":15000}]
[3,"Repatriation of the boys",null,5000,5000]
[4,"Maintenance of Youth"]
[null,"Clothing  / Footwear",null,75000,8000,{"$f":"D23-E23","v":67000}]
[null,"Hygiene exps.","Rs. 3,500*12",{"$f":"3500*12","v":42000},{"$f":"D24","v":42000}]
[5,"Food & Nutrition  ",null,570000,{"$f":"200000+100000","v":300000},{"$f":"D25-E25","v":270000}]
[6,"Medical & Detox expenses",null,35000,35000]
[7,"Rent","Rs. 80,000* 12",{"$f":"80000*12","v":960000},{"$f":"D27","v":960000}]
[8,"Utilities (electricity, water bills etc)","Rs. 9,750 * 12",{"$f":"9750*12","v":117000},50000,{"$f":"D28-E28","v":67000}]
[9,"Communication","Rs. 3750 * 12",{"$f":"3750*12","v":45000},{"$f":"24000","v":24000},{"$f":"D29-E29","v":21000}]
[10,"Repair & Maintenance"]
[null,"Centre /Vehicle / Computer Repair",null,125000,{"$f":"25000","v":25000},{"$f":"D31-E31","v":100000}]
[null,"Housekeeping","Rs. 2,000 * 12",24000,{"$f":"18000","v":18000},{"$f":"D32-E32","v":6000}]
[11,"Administrative exps (Proportionate)",null,185000,{"$f":"D33","v":185000}]
[null,"(Mediclaim for staff, audit fees, insurance premium, office stationery etc)"]
[12,"Travelling & Conveyance"]
[null,"Fuel for vehicle","Rs. 3,500 * 12",{"$f":"3500*12","v":42000},null,{"$f":"D36","v":42000}]
[13,"Salary / Honorarium"]
[null,"Director (Proportionate)",null,{"$f":"120000*12*37%","v":532800},{"$f":"D38","v":532800},{"$f":"D38-E38","v":0}]
[null,"Co-ordinators - 2","Rs. 15,600 *2 *  12",{"$f":"15600*2 *12","v":374400},{"$f":"D39","v":374400}]
[null,"Social Workers - 2","Rs. 4,800 * 2 * 12",{"$f":"4800*2*12","v":115200},{"$f":"D40","v":115200}]
[null,"Trainer - 5","Rs. 5,880 * 5*12",{"$f":"5880*5*12","v":352800},null,{"$f":"D41","v":352800}]
[null,"Doctor/Medical Staff (Proportionate)",null,{"$f":"662400*40%","v":264960},{"$f":"D42","v":264960}]
[null,"Office Staff (Proportionate)",null,{"$f":"1375200*40%","v":550080},{"$f":"236360+76800+100000","v":413160},{"$f":"D43-E43","v":136920}]
[14,"Fringe Benefit(10% of total salary)",null,{"$f":"SUM(D38:D43)*10%","v":219024},154288,{"$f":"D44-E44","v":64736}]
[15,"Telephone & conveyance allowance ",null,{"$f":"(((((4900+10650)+(15550*20%))*12)*40%)+(((12500+(12500*20%))*12)))","v":269568},{"$f":"D45/2","v":134784},{"$f":"D45-E45","v":134784}]
[null,null,"Total",{"$f":"SUM(D9:D45)","v":5288832},{"$f":"SUM(E9:E45)","v":3906592},{"$f":"SUM(F9:F45)","v":1382240}]

{"sheet":"Sheet1","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[11,"Medical staff","Per month"]
[null,"Doctor",17000]
[null,"Co-ordinator",12500]
[null,"Nurse-2",12000]
[null,"Assistant",4500,{"$f":"SUM(C2:C5)*12*20%+552000","v":662400},{"$f":"D5*18%","v":119232},{"$f":"D5*32%","v":211968},{"$f":"D5*40%","v":264960},{"$f":"D5*10%","v":66240}]
[12,"Office Staff"]
[null,"Assistant Director",23500]
[null,"Accountant-2",16000]
[null,"Store keeper",6250]
[null,"Office Assistant",5000]
[null,"Driver",7500]
[null,"Consultant",25000]
[null,"CA",13250,{"$f":"SUM(C7:C13)*12*20%+1158000","v":1389600},{"$f":"D13*18%","v":250128},{"$f":"D13*32%","v":444672},{"$f":"D13*40%","v":555840},{"$f":"D13*10%","v":138960}]
[13,"Director",120000,{"$f":"C14*12*20%+1440000","v":1728000},{"$f":"D14*18%","v":311040},{"$f":"D14*32%","v":552960},{"$f":"D14*40%","v":691200},{"$f":"D14*10%","v":172800}]
[14,"Tel & Conveyance allowance",60117,{"$f":"C15*12*9%+721404","v":786330.36},{"$f":"D15*18%","v":141539.46479999999},{"$f":"D15*32%","v":251625.71520000001},{"$f":"D15*40%","v":314532.14400000003},{"$f":"D15*10%","v":78633.036000000007}]