{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Main BookBank Budget","Alia Affected BookBank Budget","Digital Education","Main School List","Alia Schools List"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,6,3,7],[3,8,3,9],[3,3,3,4]]}
["Mukti Book Bank  budget for 2015"]
["Budget details"]
[{"$nulls":7},"(@55 Rs)"]
[null,"USD Conversion Rate",60,2015,null,null,2014,null,"Increase from 2014"]
[null,null,null,"INR","USD$",null,"INR","USD$","In INR","In USD"]
[null,"Main Book Bank",null,{"$f":"'Main BookBank Budget'!I12","v":669600},{"$f":"D6/C$4","v":11160},null,605400,11007.27,{"$f":"(D6-G6)/G6","v":0.10604558969276512},{"$f":"(E6-H6)/H6","v":1.3875375093006672E-2}]
[null,"Alia Book Bank",null,{"$f":"'Alia Affected BookBank Budget'!I11","v":733120},{"$f":"D7/C$4","v":12218.666666666666},null,657280,11950.55,{"$f":"(D7-G7)/G7","v":0.11538461538461539},{"$f":"(E7-H7)/H7","v":2.2435508547026438E-2}]
[null,"Previous Year Balance",null,{"$f":"C4*1000","v":60000},-1000,null,null,-1300]
[]
[null,"Total Requested:",null,{"$f":"D6+D7-D8","v":1342720},{"$f":"SUM(E6:E8)","v":22378.666666666664},null,{"$f":"G7+G6","v":1262680},{"$f":"(H6+H7+H8)","v":21657.82},{"$f":"(D10-G10)/G10","v":6.3388982164919061E-2},{"$f":"(E10-H10)/H10","v":3.3283436036806315E-2}]
[]
[]
[null,"Extra Capital Expenses",null,"INR","USD$",null,"INR","USD$"]
[null,"Library Building Maintenace",null,0,{"$f":"D14/C$4","v":0},null,55000,{"$f":"G14/C4","v":916.66666666666663}]
[null,"Digital Education",null,69000,{"$f":"D15/C$4","v":1150},null,0]
[null,"Administrative cost and communication",null,{"$f":"0.06*1400000","v":84000},{"$f":"D16/C$4","v":1400},null,55000,{"$f":"G16/C4","v":916.66666666666663}]
[null,"Total Requested:",null,{"$f":"SUM(D14:D16)","v":153000},{"$f":"SUM(E14:E16)","v":2550},null,{"$f":"SUM(G14:G16)","v":110000},{"$f":"H14+H16","v":1833.3333333333333}]
[]
[]
[]
[null,"Total Fund required",null,{"$f":"D10+D17","v":1495720},{"$f":"E10+E17","v":24928.666666666664},null,{"$f":"G10+G17","v":1372680},{"$f":"H17+H10","v":23491.153333333332},{"$f":"(D21-G21)/G21","v":8.9634874843372084E-2},{"$f":"(E21-H21)/H21","v":6.1193816792874903E-2}]
[]
[]
[null," Increase in Budget from 2014",{"$f":"I21","v":8.9634874843372084E-2},null,null,null,{"$f":"D21","v":1495720},{"$f":"G24/C4","v":24928.666666666668}]

{"sheet":"Main BookBank Budget","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Budget details (Main Areas)"]
[]
[null,"USD Conversion Rate",60]
[]
["No","Particulars","No of book sets","Price per set","# New Books","Price Per set","Per month","No of Months","Total expenses (in Rupees)","Total expenses ( in dollars)"]
[]
[1,"Book bank depreciation ",{"$f":"'Main School List'!H14","v":2040},240,{"$nulls":4},{"$f":"C7*D7","v":489600},{"$f":"I7/$C3","v":8160}]
[2,"One Librarian salary ",{"$nulls":4},3500,12,{"$f":"G8*H8","v":42000},{"$f":"I8/$C3","v":700}]
[3,"One full time volunteer for book bank help",{"$nulls":4},3000,12,{"$f":"G9*H9","v":36000},{"$f":"I9/$C3","v":600}]
[4,"Stationery",{"$f":"C7","v":2040},50,{"$nulls":4},{"$f":"C10*D10","v":102000},{"$f":"I10/$C3","v":1700}]
[]
[null,"Total funds needed to support the program",{"$nulls":6},{"$f":"SUM(I7:I10)","v":669600},{"$f":"SUM(J7:J10)","v":11160}]
[]
[]
[6]

{"sheet":"Alia Affected BookBank Budget","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Budget details (Alia Affected Regions)"]
[]
[null,"USD Conversion Rate",60]
[]
["No","Particulars","# BookSets (Existing)","Price Per set","# New Books","Price Per set","Per month","No of Months","Total expenses (INR)","Total expenses ( USD)"]
[]
[1,"Book bank depreciation ",{"$f":"'Alia Schools List'!J17","v":2528},240,{"$nulls":4},{"$f":"C7*D7","v":606720},{"$f":"I7/$C3","v":10112}]
[2,"Stationery",{"$f":"C7","v":2528},50,{"$nulls":4},{"$f":"C8*D8","v":126400},{"$f":"I8/$C3","v":2106.6666666666665}]
[]
[]
[null,"Total funds needed to support the program",{"$nulls":6},{"$f":"SUM(I7:I10)","v":733120},{"$f":"SUM(J7:J9)","v":12218.666666666666}]
[]
[null,"* Administrative and communication expense is necessary as the schools are spread over a larger region"]

{"sheet":"Digital Education","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Digital Education"]
[]
[]
["Items","Qty","Rate","Total"]
["Projector",1,34000,{"$f":"C5*B5","v":34000}]
["Projector Screen",1,4000,{"$f":"C6*B6","v":4000}]
["Educational CD/DVD",100,200,{"$f":"C7*B7","v":20000}]
["Almirah",1,6000,{"$f":"C8*B8","v":6000}]
["Miscelenious",null,5000,5000]
[]
["Total fund Needed for this Program",null,null,{"$f":"SUM(D5:D10)","v":69000}]

{"sheet":"Main School List","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Sl. No.","Name of the School","Panchyat","Town","Boys","Girls","Total","Existing Book Set","New Book Sets Required","Total Book Set"]
[1,"AAL Ameen High Madrasa","Jaynagar","Jaynagar, West Bengal",320,295,{"$f":"E2+F2","v":615},200,null,{"$f":"H2","v":200}]
[2,"Nagendrapur Hemanta Kumari High School","Nagendrapur","Raidighi, West Bengal",820,752,{"$f":"E3+F3","v":1572},250,null,250]
[3,"Jota Nagendrapur Higher Secondary School","Nagendrapur","Raidighi, West Bengal",750,710,1460,210,null,210]
[4,"Santoshghorai Balika Vidyamandir","Kankandighi","Raidighi, West Bengal",0,720,720,170,null,170]
[5,"Babujan Shephai Higher Secondary School","Kankandighi","Raidighi, West Bengal",850,778,1628,220,null,220]
[6,"Damkal J. H School","Nagendrapur","Raidighi, West Bengal",350,270,620,150,null,150]
[7,"Gilarchat High School","Gilarchat","Raidighi, West Bengal",760,650,1410,210,null,210]
[8,"Madhusudanchak M.S.K ","Madhusudanchak","Raidighi, West Bengal",465,375,840,210,null,210]
[9,"Jota Jogendrapur Higher Secondary School","Jogendrapur","Raidighi, West Bengal",785,725,1510,200,null,200]
[10,"Baikunthapur High School","Baikunthapur","Raidighi, West Bengal",675,595,1270,220,null,220]
[]
[]
[null,"Total",null,null,{"$f":"SUM(E2:E13)","v":5775},{"$f":"SUM(F2:F13)","v":5870},{"$f":"SUM(G2:G13)","v":11645},{"$f":"SUM(H2:H13)","v":2040},null,{"$f":"SUM(J2:J13)","v":2040}]

{"sheet":"Alia Schools List","index":5,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sl. No.","Name of the School","Panchyat","Town","Boys","Girls","Total","Existing Book Set","New Book Sets Required","Total Book Set"]
[1,"Shibnagar Mokshoda sundari vidyamandir","Banashyamnagar,","Raidighi, West Bengal",758,859,1617,250,null,{"$f":"H4","v":250}]
[2,"Ambikanagar High School","Ambikanagar, ","Maipith, West Bengal",710,520,1230,200,null,{"$f":"H5","v":200}]
[3,"Dakshin Kashinagar High School","Kuyemuri","Raidighi, West Bengal",718,517,1235,220,null,220]
[4,"Kuyemuri Higher secondary School","Kuyemuri","Raidighi, West Bengal",707,603,1310,200,null,200]
[5,"Ambikanagar High School","Gurguriya","Raidighi, West Bengal",805,635,1340,278,null,278]
[6,"Purba Gurguriya High School","Gurguriya","Raidighi, West Bengal",740,525,1265,220,null,220]
[7,"Bhubaneswari Jaykrishna High School","Bhubaneswari","Raidighi, West Bengal",517,430,947,220,null,220]
[8,"Debnagar High school","Namkhana","Namkhana, West Bengal",850,760,{"$f":"E11+F11","v":1610},180,null,180]
[9,"Kedarpur Higher Secondary School","pathar","Numkhana, West Benga",715,608,1323,210,null,210]
[10,"Darakapur Pragati Siksha Sadan","pathar","Numkhana, West Benga",595,383,978,200,null,200]
[11,"Narendrapur Milan Bidyamandir","Narendrapur","Raidighi, West Bengal",670,580,978,150,null,150]
[12,"Khagendranath Smriti Vidyamandir","Basanti","Basanti, West Bengal",720,630,978,200,null,200]
[]
[null,"Total Students to be covered under MERP project",null,null,{"$f":"SUM(E4:E15)","v":8505},{"$f":"SUM(F4:F15)","v":7050},{"$f":"SUM(G4:G15)","v":14811},{"$f":"SUM(H4:H15)","v":2528},null,{"$f":"SUM(J4:J15)","v":2528}]