{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Total Cost of Program","Cost to Asha Stanford 2011"],"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":"1904"}

{"sheet":"Total Cost of Program","index":0,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6],[6,0,6,1],[6,2,6,6],[7,5,7,6],[0,0,0,1],[0,2,0,6],[2,0,2,1],[2,2,2,6],[3,0,3,1],[3,2,3,6]]}
["Organization Name",null,"The Teacher Foundation (Shraddha Trust)"]
["Project Name",null,"Turning Schools Around/ Whole School Transformation"]
["Donor Details",null,"Asha for Education (Stanford Chapter)"]
["Duration of the grant",null,"2 years "]
["Grade",null,"1st - 10th (mostly 1-7)"]
["Budget ( INR) ",null,{"$f":"C34","v":525714.80000000005}]
["No. of Schools",null,"3 schools"]
["Sr. No.","Line Items","Total per school","Remarks"]
[null,null," "]
[null,null,"INR"]
[1," TRAINING COST "]
["a","Teacher Training ( including Material, Conveyance etc)"]
["I","Material Cost",33138,"Materials for  over 15 days of workshops subject tutorials, co planning sessions et( - worksheets , lesson plans, etc (assuming 25-30 tecahers per school)"]
["ii","Conveyance Cost",19341,"Conveyance to the school and back, assuming auto fares Rs  50 per trip, Rs 100 per day  x approx 100 visits per year "]
["B","Heads Training ( including Material, Conveyance, professional fee etc)"]
["I","Material Cost",2268,"Materials for HeadLAMP programme and school improvement framework - folders, handouts, etc (2-4 Heads, middlelevel leaders per school)"]
["ii","Conveyance Cost",2142,"Visits for HeadLAMP programme and headship support"]
["iii","Professional fee",11340,"10 workshop sessions   plus  school visits to  assist Head in   development of school audit and implementation plan"]
["c","Mentors/Coaches Training  ( including Material, Conveyance etc)"]
["I","Material Cost",604.79999999999995,"Handouts, folders etc for  3days of workshops- 4 mentors per school"]
["ii","Conveyance Cost",126,"10 visits per  school @  4 mentors per school, Rs 100 per visit"]
["d","SALARIES FOR TRAINERS &  PROJECT HEAD "]
["I","TRAINERS ( 2.5 Trainers – 1 Trainer per 2 Schools & Specific Consultant when necessary)",{"$f":"28000*12*2/3","v":224000},"Initially computed as 1 trainer per 3 schools @ approx Rs 28,000 per month per trainer. That was found untenable, and was later revised to 1 trainer per 2 schools. This will one big revision in the budget in 2012"]
["ii","PROJECT HEAD  (Part Salary)",66000,"Project Head shared across  20 schools @ Rs 55,000 per mth "]
[null,"TOTAL TRAINING COST (1)",{"$f":"SUM(C13:C24)","v":358959.8}]
[2,"SCHOOL INFRASTRUCTURE INITIATIVE",50000,"1  significant, visible  but low cost intervention in the school  eg developing a vibrant library or resource center, depending upon the needs of the school"]
[3,"MEASUREMENT & EVALUATION",25000,"1. Baseline and endline assessment of students ( 2 classes eg class 3 and 5 in 2 subjects  eg English and Maths) with comparisons with   averages for all affordable schools studied; 2 rounds of  teacher observations (pre and post)"]
[4,"TRAIN THE TRAINER",{"$f":"31500/5","v":6300},"spend onTTF  train-the-trainer workshops spread across each trainer"]
[5,"MONITORING",{"$f":"35280/5","v":7056},"Supervision costs to monitor progress of the programme"]
[6,"YEAR END EVENT/RECOGNITION/AWARDS",{"$f":"0/5","v":0}]
[7,"MANAGEMENT & CO ORDINATION EXPENSES",{"$f":"232177/5","v":46435.4},"costs of recruitment of 10 Affordable private schools, planning, hiring of staff, school relationships, management of the team"]
[8,"SUPPORT AND OTHER SERVICES",{"$f":"114818/5","v":22963.599999999999},"rent, utilities,  finance and admin, communication, audit, photocopying, stationery, etc"]
[9,"Contingency/ Misc.",{"$f":"45000/5","v":9000}]
[null," TOTAL -  1 School for 2 years :",{"$f":"+C25+C26+C27+C28+C29+C30+C31+C32+C33","v":525714.80000000005}]
[]
[null,"Total for 3 schools for 2 years (if funding 100%)",{"$f":"C34*3","v":1577144.4000000001}]
[null,"Total for 3 schools per year (if funding 100%)",{"$f":"C36/2","v":788572.20000000007}]

{"sheet":"Cost to Asha Stanford 2011","index":1,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":7},"1USD = x INR","1USD = x INR"]
[null,"Cost per school (over 2 years) (INR)","Contribution BY the school over 2 years (INR)","Remainder per school over 2 years (INR)",null,"Remainder over 2 years for 3 schools (INR)","Remainder per year for 3 schools (assuming 50:50 split) (INR)",55,44,"Asha Stanford commitment met by private donation (in USD)"]
["Revised Budget",637715,150000,{"$f":"B3-C3","v":487715},null,{"$f":"D3*3","v":1463145},{"$f":"F3/2","v":731572.5},{"$f":"G3/$H$2","v":13301.318181818182},{"$f":"G3/$I$2","v":16626.647727272728},6000]
["Budget (2011)",525715,150000,{"$f":"B4-C4","v":375715},null,{"$f":"D4*3","v":1127145},{"$f":"F4/2","v":563572.5},{"$f":"G4/$H$2","v":10246.772727272728},{"$f":"G4/$I$2","v":12808.46590909091},6000]