{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Main BookBank Budget","Main School List","Alia Affected BookBank Budget","Alia Schools List"],"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":"Summary","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"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 2014"]
["Budget details"]
[{"$nulls":7},"(@52 Rs)"]
[null,"USD Conversion Rate",58,2014,null,null,2013,null,"Increase from 2013"]
[null,null,null,"INR","USD$",null,"INR","USD$","In INR","In USD"]
[null,"Main Book Bank",null,{"$f":"'Main BookBank Budget'!I12","v":605400},{"$f":"D6/C$4","v":10437.931034482759},null,539000,10365.379999999999,{"$f":"(D6-G6)/G6","v":0.12319109461966604},{"$f":"(E6-H6)/H6","v":6.9993608032469495E-3}]
[null,"Alia Book Bank",null,{"$f":"'Alia Affected BookBank Budget'!I11","v":657280},{"$f":"D7/C$4","v":11332.413793103447},null,598530,11510.19,{"$f":"(D7-G7)/G7","v":9.815715168830301E-2},{"$f":"(E7-H7)/H7","v":-1.5445114884858811E-2}]
[null,"Previous Year Balance",null,45000,{"$f":"-(D8/C4)","v":-775.86206896551721},null,null,-1200]
[]
[null,"Total Requested:",null,{"$f":"D6+D7-D8","v":1217680},{"$f":"SUM(E6:E8)","v":20994.482758620688},null,{"$f":"G7+G6","v":1137530},{"$f":"(H6+H7+H8)","v":20675.57},{"$f":"(D10-G10)/G10","v":7.0459680184258883E-2},{"$f":"(E10-H10)/H10","v":1.5424617489176293E-2}]
[]
[]
[null,"Extra Capital Expenses",null,"INR","USD$"]
[null,"Library Building Maintenace",null,55000,{"$f":"D14/C$4","v":948.27586206896547},null,55000,{"$f":"G14/52","v":1057.6923076923076},0]
[null,"Administrative cost and communication (1 Librarian and 1 assistant)",null,55000,{"$f":"D15/C$4","v":948.27586206896547},null,55000,{"$f":"G15/52","v":1057.6923076923076},0]
[null,"Total Requested:",null,{"$f":"SUM(D14:D15)","v":110000},{"$f":"SUM(E14:E15)","v":1896.5517241379309}]
[]
[null,"Total Disbursed 2013",{"$nulls":4},1102000,19867,null,"(Actual disbursed in 2013)"]
[]
[null,"Total Fund Required",null,{"$f":"D10+D16","v":1327680},{"$f":"E10+E16","v":22891.03448275862},null,{"$f":"G10","v":1137530},{"$f":"H10","v":20675.57},{"$f":"(D20-G20)/G20","v":0.16716042653820118},"(From requested amount)"]
[{"$nulls":8},{"$f":"(D20-G18)/G18","v":0.20479128856624321},"(From actual amount)"]
[]
[null," Increase in Budget from 2013 (Requested)",{"$f":"I20","v":0.16716042653820118},{"$f":"D20-G18","v":225680},null,null,{"$f":"D20","v":1327680},{"$f":"G23/C4","v":22891.03448275862}]

{"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",58]
[]
["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},220,{"$nulls":4},{"$f":"C7*D7","v":448800},{"$f":"I7/$C3","v":7737.9310344827591}]
[2,"One Librarian salary ",{"$nulls":4},3000,12,{"$f":"G8*H8","v":36000},{"$f":"I8/$C3","v":620.68965517241384}]
[3,"One full time volunteer for book bank help",{"$nulls":4},3250,12,{"$f":"G9*H9","v":39000},{"$f":"I9/$C3","v":672.41379310344826}]
[4,"Stationery",{"$f":"C7","v":2040},40,{"$nulls":4},{"$f":"C10*D10","v":81600},{"$f":"I10/$C3","v":1406.8965517241379}]
[]
[null,"Total funds needed to support the program",{"$nulls":6},{"$f":"SUM(I7:I10)","v":605400},{"$f":"SUM(J7:J10)","v":10437.931034482757}]
[]
[]
[6]

{"sheet":"Main School List","index":2,"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 Affected BookBank Budget","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Budget details (Alia Affected Regions)"]
[]
[null,"USD Conversion Rate",58]
[]
["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},220,{"$nulls":4},{"$f":"C7*D7","v":556160},{"$f":"I7/$C3","v":9588.9655172413786}]
[2,"Stationery",{"$f":"C7","v":2528},40,{"$nulls":4},{"$f":"C8*D8","v":101120},{"$f":"I8/$C3","v":1743.4482758620691}]
[]
[]
[null,"Total funds needed to support the program",{"$nulls":6},{"$f":"SUM(I7:I10)","v":657280},{"$f":"SUM(J7:J9)","v":11332.413793103447}]
[]
[null,"* Administrative and communication expense is necessary as the schools are spread over a larger region"]
[null,"* For 2014, cost is the replacement of booksets, no new booksets will be procurred"]

{"sheet":"Alia Schools List","index":4,"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}]