{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Expenses 2014-15& Budget -15-16","Salary of staff","Students Trained in 2014-15"],"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":"Expenses 2014-15& Budget -15-16","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,6],[23,4,23,6]]}
[]
[null,"DBRT  204-15 and 15-16 "]
[]
[null,"Head ","Actuals incomeDBRT 2014-15","Projected 2015-16","Head","Actuals expenses DBRT 2014-15","Projected expenses 2015-16"]
[]
[null,"Income",null,null,"Expenses"]
[null,null,null,-75602.16,"i) Salary of DBRT staff",1181868,1307017]
[1,"Asha",1045000,{"$f":"C8*1.1","v":1149500},"ii) Salary statutory (Gratuity and PF)",210834,0]
[2,"Fees from students",431500,{"$f":"C9*1.1","v":474650.00000000006},"iii) Material ",{"$f":"64737+403433","v":468170},{"$f":"F9*1.1","v":514987.00000000006}]
[3,"IBT fees",37000,null,"iv) Short term training program expenses (food and lodging)",null,{"$f":"F10*1.1","v":0}]
[4,"Individual DONATIONS",{"$f":"2000+1551+10000+6000+800+5000+5000+1000+9000+15000","v":55351},null,"iii) Travel",{"$f":"87356+36300+10265","v":133921},147313.1]
[5,"Tata foundation",180000,null,"iv) Internet / communication / stationary",{"$f":"7500+48400+8000","v":63900},70290]
[6,"SPA foundation",460000,null,"v) Electricity and water",43560,72000]
[7,"Eaton Foundation ",null,1620000,"vi) Maintainane and replacement",{"$f":"17191+24200+4449+3490+5433","v":54763},100000]
[8,"Income from projects",485926.8,null,"ix) DBRT Student Kitchen ",349283,{"$f":"F15*1.2","v":419139.6},"We expect cost of supplies will go up considerabley "]
[9,"Receivables from fees",75602.16,null,"vii) Capital Expenses Hostel",{"$f":"21000+21417+64850","v":107267},200000,"New computer purchase and CCTV expenses"]
[{"$nulls":4},"IX) Water Tanker cost (Rs.20000 * 9 month)",null,180000,"Due to deficient rainfall. We expect severe drought this year"]
[{"$nulls":4},"viii) Admin/account overhead (6%)",{"$f":"SUM(F7:F16)*0.06","v":156813.96},{"$f":"SUM(G7:G17)*0.06","v":180644.802}]
[{"$nulls":4},"ix) Contigencies",null,52758.5]
[null,"Total ",{"$f":"SUM(C8:C18)","v":2770379.96},{"$f":"SUM(D8:D18)","v":3244150},null,{"$f":"SUM(F7:F18)","v":2770379.96},{"$f":"SUM(G7:G19)","v":3244150.0020000003}]
[]
[]
[null,"Funds requested from Asha for education"]
[null,"Fees collection expected 10% more than previous years"]

{"sheet":"Salary of staff","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"List of DBRT staff and their salaries "]
[]
[null,"Sr.No","Name ",null,null,"Qualification",null,"Monthly Salary with all benefits","Annual Salary (Including PF+ Gratuity and statutary benefits)"]
[null,1,"Vishal Jagtap",null,null,"DBRT, BA",null,17282,207380]
[null,2,"Laxman Jadhav",null,null,"DBRT",null,15408,184897]
[null,3,"Suyog Wargade ",null,null,"Diploma in Electricals",null,10556,126676]
[null,4,"Anita Pansare",null,null,"B.Tech(Food)",null,10556,126676]
[null,5,"Ravi Ghuge",null,null,"Diploma in Agriculture",null,9380,112564]
[null,6,"Anita Jangam",null,null,"M.Com",null,9767,117202]
[null,7,"Pradnya Shndekar",null,null,"Diploma in Electricals",null,14580,174962]
[]
[null,"Kitchen Staff"]
[null,1,"Alka Jadhav",null,null,"Kitchen",null,5347,64165]
[null,2,"Kausa Aaji deshmukh",null,null,"Kitchen",null,5347,64165]
[null,3,"Archana Jadhav",null,null,"Kitchen",null,5347,64165]
[null,4,"Vaijanta narhe",null,null,"Kitchen",null,5347,64165]
[]
[{"$nulls":7},"TOTAL Annual",{"$f":"SUM(I6:I18)","v":1307017}]

{"sheet":"Students Trained in 2014-15","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"A]","DIRECT BENEFIFICARY FROM ASHA FOR EDUCATION FUNDS"]
[]
[null,null,"Diploma in Basic Rural Technology (DBRT) ",{"$nulls":4},39,null,"www.vigyanashramalumni.wordpress.com",{"$nulls":4},"(34 got internship)"]
[null,null,"Short Term courses ",{"$nulls":4},36]
[null,null,"Fab Academy ",{"$nulls":4},4,null,"www.fabacademy.org "]
[]
[null,null,"TOTAL",{"$nulls":4},{"$f":"SUM(H6:H8)","v":79}]
[]
[null,"B]","Indirect beneficiaries (DBRT staff acted as Trainer)"]
[null,null,"Tally course at Balarampur",{"$nulls":4},46]
[null,null,"IBT Instructors Training at Pabal ",{"$nulls":4},260]
[null,null,"Awareness training for SHG women @ Pabal",{"$nulls":4},130]
[null,null,"Fab Camp",{"$nulls":4},153]
[]
[null,null,"TOTAL",{"$nulls":4},{"$f":"SUM(H13:H16)","v":589}]
[]
[null,"C]","Other contribution by DBRT Staff "]
[null,null,"i) Technology Development : DBRT staff and students contributed in development of following technologies as part of their project. The projects were guided by DST core staff at VA."]
[null,null,"a) Hirada cutter  b) Mahua Colector  c) Aquaponics d) Hydroponics e) Rice Dehusking machine f) Gray water recycling "]
[null,null,"www.vigyanashram.wordpress.com "]
[]
[null,null,"ii) Content Development "]
[null,null,"DBRT staff supported by Asha for Education also helped in development of various content and Open Educational Resources. They are available on :- "]
[null,null,"www.learningwhiledoing.in "]