{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"Sheet1","index":0,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,2,9,3],[9,4,9,5],[9,6,9,7],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7],[5,0,5,1],[5,2,5,7],[6,0,6,1],[6,2,6,7],[7,0,7,1],[7,2,7,7],[8,6,8,7],[0,0,0,1],[0,2,0,7],[1,0,1,1],[1,2,1,7],[2,0,2,1],[2,2,2,7]]}
["Organization Name",null,"The Teacher Foundation (Shraddha Trust)"]
["Donor Details",null,"Asha for Education (Stanford Chapter)"]
["Duration of the grant",null,"2 years "]
["Grade",null,"1st - 5th"]
["Budget ( INR) ",null,{"$f":"C35","v":525714.80000000005}]
["Budget (USD)",null,{"$f":"+D35+F35","v":11948.063636363635}]
["No. of Schools",null,"1 school"]
["$ to Rupee exchange rate",null,44]
["Sr. No.","Line Items","Total per school",null,"Remarks"]
[null,null," "]
[null,null,"INR","USD"]
[1," TRAINING COST "]
["a","Teacher Training ( including Material, Conveyance etc)"]
["I","Material Cost",{"$f":"165690/5","v":33138},{"$f":"C14/C$8","v":753.13636363636363},"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",{"$f":"96705/5","v":19341},{"$f":"C15/C$8","v":439.56818181818181},"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",{"$f":"11340/5","v":2268},{"$f":"C17/C$8","v":51.545454545454547},"Materials for HeadLAMP programme and school improvement framework - folders, handouts, etc (2-4 Heads, middlelevel leaders per school)"]
["ii","Conveyance Cost",{"$f":"10710/5","v":2142},{"$f":"C18/C$8","v":48.68181818181818},"Visits for HeadLAMP programme and headship support"]
["iii","Professional fee",{"$f":"56700/5","v":11340},{"$f":"C19/C$8","v":257.72727272727275},"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",{"$f":"3024/5","v":604.79999999999995},{"$f":"C21/C$8","v":13.745454545454544},"Handouts, folders etc for  3days of workshops- 4 mentors per school"]
["ii","Conveyance Cost",{"$f":"630/5","v":126},{"$f":"C22/C$8","v":2.8636363636363638},"10 visits per  school @  4 mentors per school, Rs 100 per visit"]
["d","SALARIES FOR TRAINERS &  PROJECT HEAD ",{"$f":"[1]Caterpillar!C23/8*5*1.2","v":0}]
["I","TRAINERS ( 2.5 Trainers – 1 Trainer per 2 Schools & Specific Consultant when necessary)",{"$f":"28000*12*2/3","v":224000},{"$f":"C24/C$8","v":5090.909090909091},"1 trainer per 2-3 schools @ approx Rs 28,000 per month per trainer"]
["ii","PROJECT HEAD  (Part Salary)",{"$f":"55000*12*2/20","v":66000},{"$f":"C25/C$8","v":1500},"Project Head shared across  20 schools @ Rs 55,000 per mth "]
[null,"TOTAL TRAINING COST (1)",{"$f":"SUM(C14:C25)","v":358959.8},{"$f":"SUM(D14:D25)","v":8158.1772727272728}]
[2,"SCHOOL INFRASTRUCTURE INITIATIVE",50000,{"$f":"C27/C$8","v":1136.3636363636363},"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,568.18181818181813,"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},143.18181818181819,"spend onTTF  train-the-trainer workshops spread across each trainer"]
[5,"MONITORING",{"$f":"35280/5","v":7056},160.36363636363637,"Supervision costs to monitor progress of the programme"]
[6,"YEAR END EVENT/RECOGNITION/AWARDS",{"$f":"0/5","v":0},0]
[7,"MANAGEMENT & CO ORDINATION EXPENSES",{"$f":"232177/5","v":46435.4},1055.3500000000001,"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},521.9,"rent, utilities,  finance and admin, communication, audit, photocopying, stationery, etc"]
[9,"Contingency/ Misc.",{"$f":"45000/5","v":9000},{"$f":"C34/C$8","v":204.54545454545453}]
[null," TOTAL -  1 School :",{"$f":"+C26+C27+C28+C29+C30+C31+C32+C33+C34","v":525714.80000000005},{"$f":"+D26+D27+D28+D29+D30+D31+D32+D33+D34","v":11948.063636363635}]
[null,"Total for 3 schools for 2 years (if funding 100%)",{"$f":"C35*3","v":1577144.4000000001},{"$f":"D35*3","v":35844.190909090903}]
[null,"Total for 3 schools per year (if funding 100%)",{"$f":"C36/2","v":788572.20000000007},{"$f":"D36/2","v":17922.095454545452}]