{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Main BookBank Budget","Alia Affected BookBank Budget","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 2016"]
["Budget details"]
[{"$nulls":7},"(@55 Rs)"]
[null,"USD Conversion Rate",60,2016,null,null,2015,null,"Increase from 2015"]
[null,null,null,"INR","USD$",null,"INR","USD$","In INR","In USD"]
[null,"Main Book Bank",null,{"$f":"'Main BookBank Budget'!I12","v":798750},{"$f":"D6/C$4","v":13312.5},null,669600,11160,{"$f":"(D6-G6)/G6","v":0.1928763440860215},{"$f":"(E6-H6)/H6","v":0.1928763440860215}]
[null,"Alia Book Bank",null,{"$f":"'Alia Affected BookBank Budget'!I11","v":702450},{"$f":"D7/C$4","v":11707.5},null,733120,12218.67,{"$f":"(D7-G7)/G7","v":-4.1834897424705371E-2},{"$f":"(E7-H7)/H7","v":-4.1835158818431147E-2}]
[null,"Previous Year Balance",null,{"$f":"C4*800","v":48000},-800,null,60000,-1000]
[]
[null,"Total Requested:",null,{"$f":"D6+D7-D8","v":1453200},{"$f":"SUM(E6:E8)","v":24220},null,{"$f":"G7+G6-G8","v":1342720},{"$f":"(H6+H7+H8)","v":22378.67},{"$f":"(D10-G10)/G10","v":8.2280743565300282E-2},{"$f":"(E10-H10)/H10","v":8.2280582358111629E-2}]
[]
[]
[null,"Extra Capital Expenses",null,"INR","USD$",null,"INR","USD$"]
[null,"Library Building Maintenace",null,60000,{"$f":"D14/C$4","v":1000},null,0,{"$f":"G14/C4","v":0}]
[null,"Digital Education",null,0,{"$f":"D15/C$4","v":0},null,0]
[null,"Administrative cost and communication",null,{"$f":"0.06*1400000","v":84000},{"$f":"D16/C$4","v":1400},null,84000,{"$f":"G16/C4","v":1400}]
[null,"Total Requested:",null,{"$f":"SUM(D14:D16)","v":144000},{"$f":"SUM(E14:E16)","v":2400},null,{"$f":"SUM(G14:G16)","v":84000},{"$f":"H14+H16","v":1400}]
[]
[]
[]
[null,"Total Fund required",null,{"$f":"D10+D17","v":1597200},{"$f":"E10+E17","v":26620},null,{"$f":"G10+G17","v":1426720},{"$f":"H17+H10","v":23778.67},{"$f":"(D21-G21)/G21","v":0.11949086015476057},{"$f":"(E21-H21)/H21","v":0.11949070322267823}]
[]
[]
[null," Increase in Budget from 2015",{"$f":"I21","v":0.11949086015476057},null,null,null,{"$f":"D21","v":1597200},{"$f":"G24/C4","v":26620}]

{"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'!J14","v":2250},260,{"$nulls":4},{"$f":"C7*D7","v":585000},{"$f":"I7/$C3","v":9750}]
[2,"One Librarian salary ",{"$nulls":4},4000,12,{"$f":"G8*H8","v":48000},{"$f":"I8/$C3","v":800}]
[3,"One full time volunteer for book bank help",{"$nulls":4},3500,12,{"$f":"G9*H9","v":42000},{"$f":"I9/$C3","v":700}]
[4,"Stationery",{"$f":"C7","v":2250},55,{"$nulls":4},{"$f":"C10*D10","v":123750},{"$f":"I10/$C3","v":2062.5}]
[]
[null,"Total funds needed to support the program",{"$nulls":6},{"$f":"SUM(I7:I10)","v":798750},{"$f":"SUM(J7:J10)","v":13312.5}]
[]
[]
[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":2230},260,{"$nulls":4},{"$f":"C7*D7","v":579800},{"$f":"I7/$C3","v":9663.3333333333339}]
[2,"Stationery",{"$f":"C7","v":2230},55,{"$nulls":4},{"$f":"C8*D8","v":122650},{"$f":"I8/$C3","v":2044.1666666666667}]
[]
[]
[null,"Total funds needed to support the program",{"$nulls":6},{"$f":"SUM(I7:I10)","v":702450},{"$f":"SUM(J7:J9)","v":11707.5}]
[]
[null,"* Administrative and communication expense is necessary as the schools are spread over a larger region"]

{"sheet":"Main School List","index":3,"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},150,null,{"$f":"H2","v":150}]
[2,"Nagendrapur Hemanta Kumari High School","Nagendrapur","Raidighi, West Bengal",820,752,{"$f":"E3+F3","v":1572},400,null,400]
[3,"Jota Nagendrapur Higher Secondary School","Nagendrapur","Raidighi, West Bengal",750,710,1460,320,null,320]
[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,180,null,180]
[8,"Raidighi Shrifaltala Chandrakanta Higher Secondary School ","Madhusudanchak","Raidighi, West Bengal",624,375,999,210,null,210]
[9,"Jota Jogendrapur Higher Secondary School","Jogendrapur","Raidighi, West Bengal",785,725,1510,230,null,230]
[10,"Baikunthapur High School","Baikunthapur","Raidighi, West Bengal",675,595,1270,220,null,220]
[]
[]
[null,"Total",null,null,{"$f":"SUM(E2:E13)","v":5934},{"$f":"SUM(F2:F13)","v":5870},{"$f":"SUM(G2:G13)","v":11804},{"$f":"SUM(H2:H13)","v":2250},null,{"$f":"SUM(J2:J13)","v":2250}]

{"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,150,null,150]
[4,"Gadamathura Adarsha Binoy Higher Secondary School","Kuyemuri","Raidighi, West Bengal",707,603,1310,150,null,150]
[5,"Madhusudanchak M.S.K ","Gurguriya","Raidighi, West Bengal",805,635,1340,150,null,150]
[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,200,null,200]
[8,"Debnagar High school","Namkhana","Namkhana, West Bengal",850,760,{"$f":"E11+F11","v":1610},200,null,200]
[9,"Kedarpur Higher Secondary School","pathar","Numkhana, West Benga",715,608,1323,210,null,210]
[10,"Gathiharania High School","pathar","Numkhana, West Benga",695,375,978,200,null,200]
[11,"Krishna Chandrapur Higher Secondary School","Narendrapur","Raidighi, West Bengal",670,680,978,150,null,150]
[12,"Khagendranath Smriti Vidyamandir","Basanti","Basanti, West Bengal",720,630,978,150,null,150]
[]
[null,"Total Students to be covered under MERP project",null,null,{"$f":"SUM(E4:E15)","v":8605},{"$f":"SUM(F4:F15)","v":7142},{"$f":"SUM(G4:G15)","v":14811},{"$f":"SUM(H4:H15)","v":2230},null,{"$f":"SUM(J4:J15)","v":2230}]