{"text_format":"2","workbook":"xlsx","n_sheets":19,"sheets":["One Tribe Summary","Assumptions","Summary Breakout","Analysis","Operations Numbers","Marketing","Marketing Assumptions","Recruitment","Recruitment Assumptions","Maintenence & Repairs","Office Supplies","Salaries","Professional Services","Rent","Telephone & Internet","Travel","Travel Assumptions","Furniture & Equipment","Other"],"not_rendered":{"charts":2,"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":"One Tribe Summary","index":0,"n_rows":47,"n_cols":45,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,17,3,18]]}
[]
[]
[]
[null,null,"Marketing Assumptions",{"$nulls":4},"Maintenance & Repairs",{"$nulls":4},"Item","Item Price","# of Items","Monthly Cost",null,"Assumptions",null,null,null,"Item","Item Cost","Monthly Cost Per Facility",null,"Item","Item Cost","# of People","# of Items","Monthly Cost Per Facility",null,null,"Item","Cost","Cost Per Facility per month",null,null,"Item","Cost","# Per Facility","Cost Per Facility",null,null,"HR Per Block Cost Total"]
[null,null,"Item","Cost","Cost Per Facility per month",null,null,"Item","Cost","Cost Per Facility per month",null,null,"Print Materials",10,200,{"$f":"N5*O5","v":2000},null,"Position","Salary","Per Facility",null,"Rent",5000,{"$f":"W5","v":5000},null,"Phone Credit",100,7,1,{"$f":"AC5*AB5*AA5","v":700},null,null,"Project Leader Fuel",398.76923076923077,398.76923076923077,null,null,"Inverter",12500,1,{"$f":"AN5*AM5","v":12500},null,null,"BPO Recruitment",2937.5]
[null,null,"Block Level Mktg",16113,16113,null,null,"Bike Maintenance",100,700,null,null,"Stationaries ",10,200,{"$f":"N6*O6","v":2000},null,"Core Team",25000,{"$f":"S6","v":25000},null,"Electricity",1000,{"$f":"W6","v":1000},null,"Data Credit ",450,7,1,{"$f":"AC6*AB6*AA6","v":3150},null,null,"Village Visonary Fuel",265.84615384615387,1595.0769230769233,null,null,"Battery",12500,1,{"$f":"AN6*AM6","v":12500},null,null,"BPO Field Assignment",8760.75]
[null,"Excluded","Overhead Mktg",7200,7200,null,null,"Facility Maintence",1000,{"$f":"I7","v":1000},null,null,"Gas",80,4,{"$f":"O7*N7","v":320},null,"Project Leader",17500,{"$f":"S7","v":17500},{"$nulls":5},"Internet",1200,1,null,{"$f":"AA7","v":1200},null,null,"Field Visits*",1250,1250,null,null,"Filter",14000,1,14000,null,null,"BPO Training",4180]
[null,null,null,"Total:",{"$f":"E6","v":16113},{"$nulls":7},"Milk",40,3,{"$f":"O8*N8","v":120},null,"Media Analyst",8000,{"$f":"S8","v":8000},null,null,"Total:",{"$f":"SUM(X5:X7)","v":6000},{"$nulls":4},"Total:",{"$f":"SUM(AD5:AD7)","v":5050},null,null,"Training Travel*",2951.666666666667,2951.666666666667,null,null,"Mats",650,4,2600,null,null,"VV Recruitment",14740]
[{"$nulls":8},"Total:",{"$f":"SUM(J6:J7)","v":1700},null,null,"Toiletries ",10,10,{"$f":"O9*N9","v":100},null,"Village Visionary",{"$f":"7750","v":7750},{"$f":"S9*Assumptions!G3","v":46500},{"$nulls":12},"Tribe Trips",22925,11462.5,null,null,"Plastic Chairs",300,10,3000,null,null,"VV Field Assignment",33750]
[{"$nulls":14},"Total:",{"$f":"SUM(P5:P9)","v":4540},null,null,"Total:",{"$f":"T7+T9","v":64000},{"$nulls":17},"Office table",4000,2,8000,null,null,null,64368.25]
[{"$nulls":32},"Conference Travel*",9825,4912.5,null,null,"Fans",2000,3,6000]
[{"$nulls":37},"Pillows",150,7,1050]
[{"$nulls":32},"Total:",null,{"$f":"SUM(AI5:AI9)","v":17658.01282051282},null,null,"Blanket",1000,4,4000]
[{"$nulls":37},"Phone",6000,7,42000]
[{"$nulls":37},"Motorcycle",30000,7,210000,{"$f":"AO15/Assumptions!B$11","v":3500}]
[null,null,"Month",1,{"$f":"D16+1","v":2},{"$f":"E16+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$nulls":10},"Computer",20000,3,{"$f":"AN16*AM16","v":60000},{"$f":"AO16/Assumptions!B$11","v":1000}]
[{"$nulls":39},"Total:",{"$f":"SUM(AO5:AO16)","v":375650}]
[]
[]
[]
[null,null,"Expense"]
[null,null,"Program Operating Expense",{"$nulls":25},"Program Operating Expense",null,"1 Year",null,"Year 2"]
[null,null,"Marketing",{"$f":"$E8","v":16113},{"$f":"$E8","v":16113},16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,16113,null,"Marketing",null,{"$f":"SUM(D23:O23)","v":193356},{"$f":"AE23/$AE$41","v":0.10619577488026628},{"$f":"SUM(P23:AA23)","v":193356},{"$f":"AG23/$AG$41","v":0.14003874644433353}]
[null,null,"Depreciation",{"$nulls":25},"Depreciation",null,0,{"$f":"AE24/$AE$41","v":0},0,{"$f":"AG24/$AG$41","v":0}]
[null,null,"Maintenance and Repairs",{"$f":"$J9","v":1700},{"$f":"$J9","v":1700},1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,1700,null,"Maintenance and Repairs",null,20400,{"$f":"AE25/$AE$41","v":1.1204171618969323E-2},20400,{"$f":"AG25/$AG$41","v":1.4774769996609385E-2}]
[null,null,"Facility Supplies",{"$f":"$P10","v":4540},{"$f":"$P10","v":4540},4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,4540,null,"Facility Supplies",null,54480,{"$f":"AE26/$AE$41","v":2.992172891183572E-2},54480,{"$f":"AG26/$AG$41","v":3.9457326932121534E-2}]
[null,null,"Salaries",{"$f":"$T10","v":64000},{"$f":"$T10","v":64000},64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,64000,null,"Salaries",null,768000,{"$f":"AE27/$AE$41","v":0.42180410800825685},{"$f":"SUM(P27:AA27)","v":768000},{"$f":"AG27/$AG$41","v":0.55622663516647097}]
[null,null,"HR",{"$f":"AS10","v":64368.25},{"$nulls":24},"HR",null,64368.25,{"$f":"AE28/$AE$41","v":3.5352594108466771E-2},{"$f":"SUM(P28:AA28)","v":0},{"$f":"AG28/$AG$41","v":0}]
[null,null,"Rent",{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},{"$f":"$X8","v":6000},null,"Rent",null,72000,{"$f":"AE29/$AE$41","v":3.954413512577408E-2},72000,{"$f":"AG29/$AG$41","v":5.2146247046856657E-2}]
[null,null,"Telephone and Internet",{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},{"$f":"$AD8","v":5050},null,"Telephone and Internet",null,60600,{"$f":"AE30/$AE$41","v":3.3282980397526515E-2},60600,{"$f":"AG30/$AG$41","v":4.3889757931104355E-2}]
[null,null,"Travel",{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},{"$f":"$AI13","v":17658.01282051282},null,"Travel",null,211896.15384615379,{"$f":"AE31/$AE$41","v":0.11637847417116831},211896.15384615379,{"$f":"AG31/$AG$41","v":0.1534665164825039}]
[null,null,"Professional Services",null,null,{"$f":"'Professional Services'!J49","v":0},{"$f":"'Professional Services'!K49","v":0},{"$f":"'Professional Services'!L49","v":0},{"$f":"'Professional Services'!M49","v":0},{"$f":"'Professional Services'!N49","v":0},{"$f":"'Professional Services'!O49","v":0},{"$f":"'Professional Services'!P49","v":0},{"$f":"'Professional Services'!Q49","v":0},{"$f":"'Professional Services'!R49","v":0},{"$f":"'Professional Services'!S49","v":0},{"$f":"'Professional Services'!T49","v":0},{"$f":"'Professional Services'!U49","v":0},{"$f":"'Professional Services'!V49","v":0},{"$f":"'Professional Services'!W49","v":0},{"$f":"'Professional Services'!X49","v":0},{"$f":"'Professional Services'!Y49","v":0},{"$f":"'Professional Services'!Z49","v":0},{"$f":"'Professional Services'!AA49","v":0},{"$f":"'Professional Services'!AB49","v":0},{"$f":"'Professional Services'!AC49","v":0},{"$f":"'Professional Services'!AD49","v":0},{"$f":"'Professional Services'!AE49","v":0},null,"Professional Services",null,0,{"$f":"AE32/$AE$41","v":0},0]
[null,null,"Other",{"$nulls":25},"Other",null,0,{"$f":"AE33/$AE$41","v":0},0]
[null,null,"Total Operating Expenses",{"$f":"SUM(D23:D33)","v":179429.26282051281},{"$f":"SUM(E23:E33)","v":115061.01282051281},{"$f":"SUM(F23:F33)","v":115061.01282051281},{"$f":"SUM(G23:G33)","v":115061.01282051281},{"$f":"SUM(H23:H33)","v":115061.01282051281},{"$f":"SUM(I23:I33)","v":115061.01282051281},{"$f":"SUM(J23:J33)","v":115061.01282051281},{"$f":"SUM(K23:K33)","v":115061.01282051281},{"$f":"SUM(L23:L33)","v":115061.01282051281},{"$f":"SUM(M23:M33)","v":115061.01282051281},{"$f":"SUM(N23:N33)","v":115061.01282051281},{"$f":"SUM(O23:O33)","v":115061.01282051281},{"$f":"SUM(P23:P33)","v":115061.01282051281},{"$f":"SUM(Q23:Q33)","v":115061.01282051281},{"$f":"SUM(R23:R33)","v":115061.01282051281},{"$f":"SUM(S23:S33)","v":115061.01282051281},{"$f":"SUM(T23:T33)","v":115061.01282051281},{"$f":"SUM(U23:U33)","v":115061.01282051281},{"$f":"SUM(V23:V33)","v":115061.01282051281},{"$f":"SUM(W23:W33)","v":115061.01282051281},{"$f":"SUM(X23:X33)","v":115061.01282051281},{"$f":"SUM(Y23:Y33)","v":115061.01282051281},{"$f":"SUM(Z23:Z33)","v":115061.01282051281},{"$f":"SUM(AA23:AA33)","v":115061.01282051281},null,"Total Operating Expenses",null,{"$f":"SUM(D34:O34)","v":1445100.4038461533},{"$f":"AE34/$AE$41","v":0.79368396722226353},1380732.1538461533,{"$f":"AG34/$AG$41","v":1}]
[{"$nulls":30},0,{"$f":"AE35/$AE$41","v":0}]
[null,null,"Non-Operating Expenses",{"$nulls":25},"Non-Operating Expenses",null,{"$f":"SUM(D36:O36)","v":0},{"$f":"AE36/$AE$41","v":0}]
[null,null,"Furniture/Equipment",{"$f":"AO17","v":375650},{"$nulls":24},"Furniture/Equipment",null,375650,{"$f":"AE37/$AE$41","v":0.20631603277773655},{"$f":"SUM(P37:AA37)","v":0},{"$f":"AG37/$AG$41","v":0}]
[null,null,"Other",{"$nulls":25},"Other",null,0,{"$f":"AE38/$AE$41","v":0}]
[null,null,"Total Non-Recurring Expense",{"$f":"SUM(D37:D38)","v":375650},{"$f":"SUM(E37:E38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"Total Non-Recurring Expense",null,375650,{"$f":"AE39/$AE$41","v":0.20631603277773655},{"$f":"SUM(P39:AA39)","v":0},{"$f":"AG39/$AG$41","v":0}]
[{"$nulls":30},0,{"$f":"AE40/$AE$41","v":0}]
[null,null,"Total Expenses (Rupees)",{"$f":"SUM(D39+D34)","v":555079.26282051275},{"$f":"SUM(E39+E34)","v":115061.01282051281},{"$f":"SUM(F39+F34)","v":115061.01282051281},115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,115061.01282051281,null,"Total Expenses (Rupees)",null,1820750.4038461531,{"$f":"AE41/$AE$41","v":1},{"$f":"SUM(P41:AA41)","v":1380732.1538461533},{"$f":"AG41/$AG$41","v":1}]
[null,null,"Dollars",{"$f":"D41/Assumptions!$B11","v":9251.3210470085451},{"$f":"E41/Assumptions!$B11","v":1917.6835470085468},{"$f":"F41/Assumptions!$B11","v":1917.6835470085468},{"$f":"G41/Assumptions!$B11","v":1917.6835470085468},{"$f":"H41/Assumptions!$B11","v":1917.6835470085468},{"$f":"I41/Assumptions!$B11","v":1917.6835470085468},{"$f":"J41/Assumptions!$B11","v":1917.6835470085468},{"$f":"K41/Assumptions!$B11","v":1917.6835470085468},{"$f":"L41/Assumptions!$B11","v":1917.6835470085468},{"$f":"M41/Assumptions!$B11","v":1917.6835470085468},{"$f":"N41/Assumptions!$B11","v":1917.6835470085468},{"$f":"O41/Assumptions!$B11","v":1917.6835470085468},{"$f":"P41/Assumptions!$B11","v":1917.6835470085468},{"$f":"Q41/Assumptions!$B11","v":1917.6835470085468},{"$f":"R41/Assumptions!$B11","v":1917.6835470085468},{"$f":"S41/Assumptions!$B11","v":1917.6835470085468},{"$f":"T41/Assumptions!$B11","v":1917.6835470085468},{"$f":"U41/Assumptions!$B11","v":1917.6835470085468},{"$f":"V41/Assumptions!$B11","v":1917.6835470085468},{"$f":"W41/Assumptions!$B11","v":1917.6835470085468},{"$f":"X41/Assumptions!$B11","v":1917.6835470085468},{"$f":"Y41/Assumptions!$B11","v":1917.6835470085468},{"$f":"Z41/Assumptions!$B11","v":1917.6835470085468},{"$f":"AA41/Assumptions!$B11","v":1917.6835470085468},null,"Dollars",null,{"$f":"AE41/Assumptions!B11","v":30345.840064102551},null,{"$f":"AG41/Assumptions!B11","v":23012.202564102554}]
[{"$nulls":14},{"$f":"SUM(D42:O42)","v":30345.840064102555}]
[]
[]
[{"$nulls":30},"Total",{"$f":"AE42+AG42","v":53358.042628205105}]
[{"$nulls":31},{"$f":"AF46/6","v":8893.0071047008514},"Per Villisionary"]

{"sheet":"Assumptions","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Facility Start Dates","#",null,null,"# of VV per Tribe",6]
[null,"2015-01-01",4,null,null,"Population per Panch",10000]
[null,"2015-08-01",8]
[null,"2016-08-01",10]
[]
[]
[]
[null,"Exchange Rate"]
[null,60]

{"sheet":"Summary Breakout","index":2,"n_rows":46,"n_cols":39,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":7}
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,null,"Total"]
[null,null,"Income","2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[]
[]
[]
[]
[null,null,"Expense"]
[null,null,"Operating Expense",{"$nulls":30},2014,null,2015,null,2016]
[null,null,"Marketing",{"$f":"Marketing!H59","v":0},{"$f":"Marketing!I59","v":0},{"$f":"Marketing!J59","v":0},{"$f":"Marketing!K59","v":0},{"$f":"Marketing!L59","v":71650},{"$f":"Marketing!M59","v":71650},{"$f":"Marketing!N59","v":71650},{"$f":"Marketing!O59","v":71650},{"$f":"Marketing!P59","v":71650},{"$f":"Marketing!Q59","v":71650},{"$f":"Marketing!R59","v":71650},{"$f":"Marketing!S59","v":200550},{"$f":"Marketing!T59","v":200550},{"$f":"Marketing!U59","v":200550},{"$f":"Marketing!V59","v":200550},{"$f":"Marketing!W59","v":200550},{"$f":"Marketing!X59","v":200550},{"$f":"Marketing!Y59","v":200550},{"$f":"Marketing!Z59","v":200550},{"$f":"Marketing!AA59","v":200550},{"$f":"Marketing!AB59","v":200550},{"$f":"Marketing!AC59","v":200550},{"$f":"Marketing!AD59","v":200550},{"$f":"Marketing!AE59","v":361675},{"$f":"Marketing!AF59","v":361675},{"$f":"Marketing!AG59","v":361675},{"$f":"Marketing!AH59","v":361675},{"$f":"Marketing!AI59","v":290025},{"$f":"Marketing!AJ59","v":290025},null,{"$f":"SUM(D16:G16)","v":0},{"$f":"AH16/AH$34","v":0},{"$f":"SUM(H16:S16)","v":1504300},{"$f":"AJ16/AJ$34","v":9.2368607184664692E-2},{"$f":"SUM(T16:AF16)","v":3430600},{"$f":"AL16/AL$34","v":0.11880694362274716}]
[null,null,"Depreciation",{"$nulls":30},{"$f":"SUM(D17:G17)","v":0},{"$f":"AH17/AH$34","v":0},{"$f":"SUM(H17:S17)","v":0},{"$f":"AJ17/AJ$34","v":0},0,{"$f":"AL17/AL$34","v":0}]
[null,null,"Maintenance and Repairs",{"$f":"'Maintenence & Repairs'!H59","v":0},{"$f":"'Maintenence & Repairs'!I59","v":0},{"$f":"'Maintenence & Repairs'!J59","v":0},{"$f":"'Maintenence & Repairs'!K59","v":0},{"$f":"'Maintenence & Repairs'!L59","v":6800},{"$f":"'Maintenence & Repairs'!M59","v":6800},{"$f":"'Maintenence & Repairs'!N59","v":6800},{"$f":"'Maintenence & Repairs'!O59","v":6800},{"$f":"'Maintenence & Repairs'!P59","v":6800},{"$f":"'Maintenence & Repairs'!Q59","v":6800},{"$f":"'Maintenence & Repairs'!R59","v":6800},{"$f":"'Maintenence & Repairs'!S59","v":20400},{"$f":"'Maintenence & Repairs'!T59","v":20400},{"$f":"'Maintenence & Repairs'!U59","v":20400},{"$f":"'Maintenence & Repairs'!V59","v":20400},{"$f":"'Maintenence & Repairs'!W59","v":20400},{"$f":"'Maintenence & Repairs'!X59","v":20400},{"$f":"'Maintenence & Repairs'!Y59","v":20400},{"$f":"'Maintenence & Repairs'!Z59","v":20400},{"$f":"'Maintenence & Repairs'!AA59","v":20400},{"$f":"'Maintenence & Repairs'!AB59","v":20400},{"$f":"'Maintenence & Repairs'!AC59","v":20400},{"$f":"'Maintenence & Repairs'!AD59","v":20400},{"$f":"'Maintenence & Repairs'!AE59","v":37400},{"$f":"'Maintenence & Repairs'!AF59","v":37400},{"$f":"'Maintenence & Repairs'!AG59","v":37400},{"$f":"'Maintenence & Repairs'!AH59","v":30600},{"$f":"'Maintenence & Repairs'!AI59","v":30600},{"$f":"'Maintenence & Repairs'!AJ59","v":30600},null,0,{"$f":"AH18/AH$34","v":0},149600,{"$f":"AJ18/AJ$34","v":9.1858961874797824E-3},346800,{"$f":"AL18/AL$34","v":1.2010216302795055E-2}]
[null,null,"Facility Supplies",{"$f":"'Office Supplies'!H49","v":0},{"$f":"'Office Supplies'!I49","v":0},{"$f":"'Office Supplies'!J49","v":0},{"$f":"'Office Supplies'!K49","v":0},{"$f":"'Office Supplies'!L49","v":18160},{"$f":"'Office Supplies'!M49","v":18160},{"$f":"'Office Supplies'!N49","v":18160},{"$f":"'Office Supplies'!O49","v":18160},{"$f":"'Office Supplies'!P49","v":18160},{"$f":"'Office Supplies'!Q49","v":18160},{"$f":"'Office Supplies'!R49","v":18160},{"$f":"'Office Supplies'!S49","v":54480},{"$f":"'Office Supplies'!T49","v":54480},{"$f":"'Office Supplies'!U49","v":54480},{"$f":"'Office Supplies'!V49","v":54480},{"$f":"'Office Supplies'!W49","v":54480},{"$f":"'Office Supplies'!X49","v":54480},{"$f":"'Office Supplies'!Y49","v":54480},{"$f":"'Office Supplies'!Z49","v":54480},{"$f":"'Office Supplies'!AA49","v":54480},{"$f":"'Office Supplies'!AB49","v":54480},{"$f":"'Office Supplies'!AC49","v":54480},{"$f":"'Office Supplies'!AD49","v":54480},{"$f":"'Office Supplies'!AE49","v":99880},{"$f":"'Office Supplies'!AF49","v":99880},{"$f":"'Office Supplies'!AG49","v":99880},{"$f":"'Office Supplies'!AH49","v":99880},{"$f":"'Office Supplies'!AI49","v":81720},{"$f":"'Office Supplies'!AJ49","v":81720},null,0,{"$f":"AH19/AH$34","v":0},399520,{"$f":"AJ19/AJ$34","v":2.4531746288916599E-2},944320,{"$f":"AL19/AL$34","v":3.2703251035338596E-2}]
[null,null,"Salaries",{"$f":"Salaries!H49","v":0},{"$f":"Salaries!I49","v":0},{"$f":"Salaries!J49","v":0},{"$f":"Salaries!K49","v":184000},{"$f":"Salaries!L49","v":184000},{"$f":"Salaries!M49","v":370000},{"$f":"Salaries!N49","v":370000},{"$f":"Salaries!O49","v":370000},{"$f":"Salaries!P49","v":370000},{"$f":"Salaries!Q49","v":506000},{"$f":"Salaries!R49","v":506000},{"$f":"Salaries!S49","v":878000},{"$f":"Salaries!T49","v":878000},{"$f":"Salaries!U49","v":878000},{"$f":"Salaries!V49","v":878000},{"$f":"Salaries!W49","v":878000},{"$f":"Salaries!X49","v":878000},{"$f":"Salaries!Y49","v":878000},{"$f":"Salaries!Z49","v":878000},{"$f":"Salaries!AA49","v":878000},{"$f":"Salaries!AB49","v":878000},{"$f":"Salaries!AC49","v":1048000},{"$f":"Salaries!AD49","v":1048000},{"$f":"Salaries!AE49","v":1513000},{"$f":"Salaries!AF49","v":1513000},{"$f":"Salaries!AG49","v":1513000},{"$f":"Salaries!AH49","v":1513000},{"$f":"Salaries!AI49","v":1513000},{"$f":"Salaries!AJ49","v":1513000},null,184000,{"$f":"AH20/AH$34","v":0.35367407780445281},7066000,{"$f":"AJ20/AJ$34","v":0.43387394693002773},15564000,{"$f":"AL20/AL$34","v":0.53900520916004102}]
[null,null,"HR",{"$f":"Recruitment!H59","v":0},{"$f":"Recruitment!I59","v":0},{"$f":"Recruitment!J59","v":0},{"$f":"Recruitment!K59","v":78253},{"$f":"Recruitment!L59","v":135000},{"$f":"Recruitment!M59","v":0},{"$f":"Recruitment!N59","v":0},{"$f":"Recruitment!O59","v":0},{"$f":"Recruitment!P59","v":0},{"$f":"Recruitment!Q59","v":0},{"$f":"Recruitment!R59","v":0},{"$f":"Recruitment!S59","v":455986},{"$f":"Recruitment!T59","v":0},{"$f":"Recruitment!U59","v":0},{"$f":"Recruitment!V59","v":0},{"$f":"Recruitment!W59","v":0},{"$f":"Recruitment!X59","v":0},{"$f":"Recruitment!Y59","v":0},{"$f":"Recruitment!Z59","v":0},{"$f":"Recruitment!AA59","v":0},{"$f":"Recruitment!AB59","v":0},{"$f":"Recruitment!AC59","v":0},{"$f":"Recruitment!AD59","v":0},{"$f":"Recruitment!AE59","v":546792.5},{"$f":"Recruitment!AF59","v":0},{"$f":"Recruitment!AG59","v":0},{"$f":"Recruitment!AH59","v":0},{"$f":"Recruitment!AI59","v":0},{"$f":"Recruitment!AJ59","v":0},null,78253,{"$f":"AH21/AH$34","v":0.15041335657843397},{"$f":"SUM(H21:S21)","v":590986},{"$f":"AJ21/AJ$34","v":3.6288342541804325E-2},{"$f":"SUM(T21:AF21)","v":546792.5},{"$f":"AL21/AL$34","v":1.8936263545980579E-2}]
[null,null,"Rent",{"$f":"Rent!H49","v":0},{"$f":"Rent!I49","v":0},{"$f":"Rent!J49","v":0},{"$f":"Rent!K49","v":0},{"$f":"Rent!L49","v":24000},{"$f":"Rent!M49","v":24000},{"$f":"Rent!N49","v":24000},{"$f":"Rent!O49","v":24000},{"$f":"Rent!P49","v":24000},{"$f":"Rent!Q49","v":24000},{"$f":"Rent!R49","v":24000},{"$f":"Rent!S49","v":72000},{"$f":"Rent!T49","v":72000},{"$f":"Rent!U49","v":72000},{"$f":"Rent!V49","v":72000},{"$f":"Rent!W49","v":72000},{"$f":"Rent!X49","v":72000},{"$f":"Rent!Y49","v":72000},{"$f":"Rent!Z49","v":72000},{"$f":"Rent!AA49","v":72000},{"$f":"Rent!AB49","v":72000},{"$f":"Rent!AC49","v":72000},{"$f":"Rent!AD49","v":72000},{"$f":"Rent!AE49","v":132000},{"$f":"Rent!AF49","v":132000},{"$f":"Rent!AG49","v":132000},{"$f":"Rent!AH49","v":132000},{"$f":"Rent!AI49","v":108000},{"$f":"Rent!AJ49","v":108000},null,0,{"$f":"AH22/AH$34","v":0},528000,{"$f":"AJ22/AJ$34","v":3.242081007345806E-2},1248000,{"$f":"AL22/AL$34","v":4.3220155553310921E-2}]
[null,null,"Telephone and Internet",{"$f":"'Telephone & Internet'!H49","v":0},{"$f":"'Telephone & Internet'!I49","v":0},{"$f":"'Telephone & Internet'!J49","v":0},{"$f":"'Telephone & Internet'!K49","v":0},{"$f":"'Telephone & Internet'!L49","v":20200},{"$f":"'Telephone & Internet'!M49","v":20200},{"$f":"'Telephone & Internet'!N49","v":20200},{"$f":"'Telephone & Internet'!O49","v":20200},{"$f":"'Telephone & Internet'!P49","v":20200},{"$f":"'Telephone & Internet'!Q49","v":20200},{"$f":"'Telephone & Internet'!R49","v":20200},{"$f":"'Telephone & Internet'!S49","v":60600},{"$f":"'Telephone & Internet'!T49","v":60600},{"$f":"'Telephone & Internet'!U49","v":60600},{"$f":"'Telephone & Internet'!V49","v":60600},{"$f":"'Telephone & Internet'!W49","v":60600},{"$f":"'Telephone & Internet'!X49","v":60600},{"$f":"'Telephone & Internet'!Y49","v":60600},{"$f":"'Telephone & Internet'!Z49","v":60600},{"$f":"'Telephone & Internet'!AA49","v":60600},{"$f":"'Telephone & Internet'!AB49","v":60600},{"$f":"'Telephone & Internet'!AC49","v":60600},{"$f":"'Telephone & Internet'!AD49","v":60600},{"$f":"'Telephone & Internet'!AE49","v":111100},{"$f":"'Telephone & Internet'!AF49","v":111100},{"$f":"'Telephone & Internet'!AG49","v":111100},{"$f":"'Telephone & Internet'!AH49","v":111100},{"$f":"'Telephone & Internet'!AI49","v":90900},{"$f":"'Telephone & Internet'!AJ49","v":90900},null,0,{"$f":"AH23/AH$34","v":0},444400,{"$f":"AJ23/AJ$34","v":2.7287515145160531E-2},1050400,{"$f":"AL23/AL$34","v":3.6376964257370026E-2}]
[null,null,"Travel",{"$f":"Travel!N64+Travel!H59","v":0},{"$f":"Travel!O64+Travel!I59","v":0},{"$f":"Travel!P64+Travel!J59","v":0},{"$f":"Travel!Q64+Travel!K59","v":0},{"$f":"Travel!R64+Travel!L59","v":75544.551282051281},{"$f":"Travel!S64+Travel!M59","v":75544.551282051281},{"$f":"Travel!T64+Travel!N59","v":75544.551282051281},{"$f":"Travel!U64+Travel!O59","v":75544.551282051281},{"$f":"Travel!V64+Travel!P59","v":75544.551282051281},{"$f":"Travel!W64+Travel!Q59","v":75544.551282051281},{"$f":"Travel!X64+Travel!R59","v":75544.551282051281},{"$f":"Travel!Y64+Travel!S59","v":141483.65384615384},{"$f":"Travel!Z64+Travel!T59","v":141483.65384615384},{"$f":"Travel!AA64+Travel!U59","v":141483.65384615384},{"$f":"Travel!AB64+Travel!V59","v":141483.65384615384},{"$f":"Travel!AC64+Travel!W59","v":141483.65384615384},{"$f":"Travel!AD64+Travel!X59","v":141483.65384615384},{"$f":"Travel!AE64+Travel!Y59","v":141483.65384615384},{"$f":"Travel!AF64+Travel!Z59","v":141483.65384615384},{"$f":"Travel!AG64+Travel!AA59","v":141483.65384615384},{"$f":"Travel!AH64+Travel!AB59","v":141483.65384615384},{"$f":"Travel!AI64+Travel!AC59","v":141483.65384615384},{"$f":"Travel!AJ64+Travel!AD59","v":141483.65384615384},{"$f":"Travel!AK64+Travel!AE59","v":219813.78205128206},{"$f":"Travel!AL64+Travel!AF59","v":219813.78205128206},{"$f":"Travel!AM64+Travel!AG59","v":219813.78205128206},{"$f":"Travel!AN64+Travel!AH59","v":219813.78205128206},{"$f":"Travel!AO64+Travel!AI59","v":149181.73076923078},{"$f":"Travel!AP64+Travel!AJ59","v":149181.73076923078},null,0,{"$f":"AH24/AH$34","v":0},1236230.128205128,{"$f":"AJ24/AJ$34","v":7.5908299609138558E-2},2168004.1666666665,{"$f":"AL24/AL$34","v":7.5081311957980401E-2}]
[null,null,"Professional Services",{"$f":"'Professional Services'!H49","v":81000},{"$f":"'Professional Services'!I49","v":113000},{"$f":"'Professional Services'!J49","v":0},{"$f":"'Professional Services'!K49","v":0},{"$f":"'Professional Services'!L49","v":0},{"$f":"'Professional Services'!M49","v":0},{"$f":"'Professional Services'!N49","v":0},{"$f":"'Professional Services'!O49","v":0},{"$f":"'Professional Services'!P49","v":0},{"$f":"'Professional Services'!Q49","v":0},{"$f":"'Professional Services'!R49","v":0},{"$f":"'Professional Services'!S49","v":0},{"$f":"'Professional Services'!T49","v":0},{"$f":"'Professional Services'!U49","v":0},{"$f":"'Professional Services'!V49","v":0},{"$f":"'Professional Services'!W49","v":0},{"$f":"'Professional Services'!X49","v":0},{"$f":"'Professional Services'!Y49","v":0},{"$f":"'Professional Services'!Z49","v":0},{"$f":"'Professional Services'!AA49","v":0},{"$f":"'Professional Services'!AB49","v":0},{"$f":"'Professional Services'!AC49","v":0},{"$f":"'Professional Services'!AD49","v":0},{"$f":"'Professional Services'!AE49","v":0},{"$f":"'Professional Services'!AF49","v":0},{"$f":"'Professional Services'!AG49","v":0},{"$f":"'Professional Services'!AH49","v":0},{"$f":"'Professional Services'!AI49","v":0},{"$f":"'Professional Services'!AJ49","v":0},null,194000,{"$f":"AH25/AH$34","v":0.37289549507643399},0,{"$f":"AJ25/AJ$34","v":0},0,{"$f":"AL25/AL$34","v":0}]
[null,null,"Other",{"$nulls":33},{"$f":"AJ26/AJ$34","v":0}]
[null,null,"Total Operating Expenses",{"$f":"SUM(D16:D26)","v":81000},{"$f":"SUM(E16:E26)","v":113000},{"$f":"SUM(F16:F26)","v":0},262253,{"$f":"SUM(H16:H26)","v":535354.55128205125},586354.55128205125,586354.55128205125,586354.55128205125,586354.55128205125,722354.55128205125,722354.55128205125,1883499.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1597513.6538461538,1597513.6538461538,3021661.282051282,2474868.782051282,2474868.782051282,2468068.782051282,2263426.730769231,2263426.730769231,null,456253,{"$f":"AH27/AH$34","v":0.87698292945932077},{"$f":"SUM(H27:S27)","v":11919036.128205128},{"$f":"AJ27/AJ$34","v":0.73186516396065027},{"$f":"SUM(T27:AF27)","v":25298916.666666664},{"$f":"AL27/AL$34","v":0.8761403154355637}]
[{"$nulls":36},{"$f":"AJ28/AJ$34","v":0}]
[null,null,"Non-Operating Expenses",{"$nulls":33},{"$f":"AJ29/AJ$34","v":0},null,{"$f":"AL29/AL$34","v":0}]
[null,null,"Furniture/Equipment",{"$f":"'Furniture & Equipment'!H59","v":0},{"$f":"'Furniture & Equipment'!I59","v":0},{"$f":"'Furniture & Equipment'!J59","v":0},{"$f":"'Furniture & Equipment'!K59","v":0},{"$f":"'Furniture & Equipment'!L59","v":1502600},{"$f":"'Furniture & Equipment'!M59","v":0},{"$f":"'Furniture & Equipment'!N59","v":0},{"$f":"'Furniture & Equipment'!O59","v":0},{"$f":"'Furniture & Equipment'!P59","v":0},{"$f":"'Furniture & Equipment'!Q59","v":0},{"$f":"'Furniture & Equipment'!R59","v":0},{"$f":"'Furniture & Equipment'!S59","v":2861200},{"$f":"'Furniture & Equipment'!T59","v":0},{"$f":"'Furniture & Equipment'!U59","v":0},{"$f":"'Furniture & Equipment'!V59","v":0},{"$f":"'Furniture & Equipment'!W59","v":0},{"$f":"'Furniture & Equipment'!X59","v":0},{"$f":"'Furniture & Equipment'!Y59","v":0},{"$f":"'Furniture & Equipment'!Z59","v":0},{"$f":"'Furniture & Equipment'!AA59","v":0},{"$f":"'Furniture & Equipment'!AB59","v":0},{"$f":"'Furniture & Equipment'!AC59","v":0},{"$f":"'Furniture & Equipment'!AD59","v":0},{"$f":"'Furniture & Equipment'!AE59","v":3576500},{"$f":"'Furniture & Equipment'!AF59","v":0},{"$f":"'Furniture & Equipment'!AG59","v":0},{"$f":"'Furniture & Equipment'!AH59","v":0},{"$f":"'Furniture & Equipment'!AI59","v":0},{"$f":"'Furniture & Equipment'!AJ59","v":0},null,{"$f":"SUM(D30:G30)","v":0},null,{"$f":"SUM(H30:S30)","v":4363800},{"$f":"AJ30/AJ$34","v":0.26795062689120508},{"$f":"SUM(T30:AF30)","v":3576500},{"$f":"AL30/AL$34","v":0.12385968456443631}]
[null,null,"Other",{"$f":"Other!H49","v":0},{"$f":"Other!I49","v":58000},{"$f":"Other!J49","v":3000},{"$f":"Other!K49","v":3000},{"$f":"Other!L49","v":3000},{"$f":"Other!M49","v":0},{"$f":"Other!N49","v":0},{"$f":"Other!O49","v":0},{"$f":"Other!P49","v":0},{"$f":"Other!Q49","v":0},{"$f":"Other!R49","v":0},{"$f":"Other!S49","v":0},{"$f":"Other!T49","v":0},{"$f":"Other!U49","v":0},{"$f":"Other!V49","v":0},{"$f":"Other!W49","v":0},{"$f":"Other!X49","v":0},{"$f":"Other!Y49","v":0},{"$f":"Other!Z49","v":0},{"$f":"Other!AA49","v":0},{"$f":"Other!AB49","v":0},{"$f":"Other!AC49","v":0},{"$f":"Other!AD49","v":0},{"$f":"Other!AE49","v":0},{"$f":"Other!AF49","v":0},{"$f":"Other!AG49","v":0},{"$f":"Other!AH49","v":0},{"$f":"Other!AI49","v":0},{"$f":"Other!AJ49","v":0},null,64000,{"$f":"AH31/AH$34","v":0.12301707054067924},3000,{"$f":"AJ31/AJ$34","v":1.8420914814464806E-4},{"$f":"SUM(T31:AF31)","v":0},{"$f":"AL31/AL$34","v":0}]
[null,null,"Total Non-Recurring Expense",{"$f":"SUM(D30:D31)","v":0},{"$f":"SUM(E30:E31)","v":58000},3000,3000,1505600,0,0,0,0,0,0,2861200,0,0,0,0,0,0,0,0,0,0,0,3576500,0,0,0,0,0,null,64000,0.12301707054067924,4366800,{"$f":"AJ32/AJ$34","v":0.26813483603934973},{"$f":"SUM(T32:AF32)","v":3576500},{"$f":"AL32/AL$34","v":0.12385968456443631}]
[{"$nulls":36},{"$f":"AJ33/AJ$34","v":0}]
[null,null,"Total Expenses (Rupees)",{"$f":"SUM(D32+D27)","v":81000},{"$f":"SUM(E32+E27)","v":171000},{"$f":"SUM(F32+F27)","v":3000},265253,2040954.5512820513,586354.55128205125,586354.55128205125,586354.55128205125,586354.55128205125,722354.55128205125,722354.55128205125,4744699.653846154,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1427513.6538461538,1597513.6538461538,1597513.6538461538,6598161.282051282,2474868.782051282,2474868.782051282,2468068.782051282,2263426.730769231,2263426.730769231,null,{"$f":"SUM(D34:G34)","v":520253},{"$f":"AH34/AH$34","v":1},{"$f":"SUM(H34:S34)","v":16285836.128205128},{"$f":"AJ34/AJ$34","v":1},{"$f":"SUM(T34:AF34)","v":28875416.666666664},{"$f":"AL34/AL$34","v":1}]
[null,null,"Dollars",{"$f":"D34/$D$37","v":1350},2850,50,4420.8833333333332,34015.909188034188,9772.5758547008536,9772.5758547008536,9772.5758547008536,9772.5758547008536,12039.242521367521,12039.242521367521,79078.327564102568,23791.89423076923,23791.89423076923,23791.89423076923,23791.89423076923,23791.89423076923,23791.89423076923,23791.89423076923,23791.89423076923,23791.89423076923,26625.227564102563,26625.227564102563,109969.3547008547,41247.813034188031,41247.813034188031,41134.479700854703,37723.778846153851,37723.778846153851]
[{"$nulls":6},{"$f":"SUM(D35:G35)","v":8670.8833333333332},{"$nulls":11},{"$f":"SUM(H35:S35)","v":271430.6021367521},{"$nulls":11},{"$f":"SUM(T35:AE35)","v":443533.16559829056}]
[null,null,"Exchange Rate",60]
[]
[null,null,"Expense Cumulative"]
[null,null,"Rupees",{"$f":"D34","v":81000},{"$f":"E34+D40","v":252000},{"$f":"F34+E40","v":255000},520253,2561207.551282051,3147562.102564102,3733916.6538461531,4320271.2051282041,4906625.7564102551,5628980.3076923061,6351334.8589743571,11096034.512820512,12523548.166666666,13951061.82051282,15378575.474358974,16806089.128205128,18233602.78205128,19661116.435897432,21088630.089743584,22516143.743589737,23943657.397435889,25541171.051282041,27138684.705128193,33736845.987179473,36211714.769230753,38686583.551282033,41154652.333333313,43418079.064102545,45681505.794871777]
[null,null,"Dollars",{"$f":"D35","v":1350},{"$f":"E35+D41","v":4200},{"$f":"F35+E41","v":4250},8670.8833333333332,42686.792521367519,52459.368376068371,62231.944230769222,72004.520085470082,81777.095940170941,93816.338461538457,105855.58098290597,184933.90854700853,208725.80277777775,232517.69700854697,256309.59123931619,280101.4854700854,303893.37970085465,327685.2739316239,351477.16816239315,375269.0623931624,399060.95662393165,425686.18418803421,452311.41175213677,562280.76645299152,603528.57948717952,644776.39252136752,685910.87222222227,723634.65106837614,761358.42991453002]
[]
[]
[]
[]
[null,null,{"$f":"81000/60","v":1350}]

{"sheet":"Analysis","index":3,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"PER BLOCK"]
[null,null,"Year 1","% of Total Expense",null,"Year 2","% of Total Expense"]
[null,"Program Operating Expense",null,null,null,"Rs",null,"Dollars",null,null,"# of Blocks",{"$f":"'Operations Numbers'!AK19","v":22}]
[null,"Marketing",{"$f":"'One Tribe Summary'!AE23","v":193356},{"$f":"C7/$C$25","v":0.10619577488026628},{"$f":"C7/Assumptions!$B$11","v":3222.6},{"$f":"'One Tribe Summary'!AG23","v":193356},{"$f":"F7/$F$25","v":0.14003874644433353},{"$f":"F7/Assumptions!$B$11","v":3222.6},null,null,"# of Village Visionaries",{"$f":"'Operations Numbers'!AK20","v":132}]
[null,"Depreciation",{"$f":"'One Tribe Summary'!AE24","v":0},{"$f":"C8/$C$25","v":0},{"$f":"C8/Assumptions!$B$11","v":0},{"$f":"'One Tribe Summary'!AG24","v":0},{"$f":"F8/$F$25","v":0},{"$f":"F8/Assumptions!$B$11","v":0},null,null,"# of Panchayats",{"$f":"'Operations Numbers'!AK21","v":132}]
[null,"Maintenance and Repairs",{"$f":"'One Tribe Summary'!AE25","v":20400},{"$f":"C9/$C$25","v":1.1204171618969323E-2},{"$f":"C9/Assumptions!$B$11","v":340},{"$f":"'One Tribe Summary'!AG25","v":20400},{"$f":"F9/$F$25","v":1.4774769996609385E-2},{"$f":"F9/Assumptions!$B$11","v":340},null,null,"Population Served",{"$f":"'Operations Numbers'!AK22","v":1320000}]
[null,"Facility Supplies",{"$f":"'One Tribe Summary'!AE26","v":54480},{"$f":"C10/$C$25","v":2.992172891183572E-2},{"$f":"C10/Assumptions!$B$11","v":908},{"$f":"'One Tribe Summary'!AG26","v":54480},{"$f":"F10/$F$25","v":3.9457326932121534E-2},{"$f":"F10/Assumptions!$B$11","v":908},null,null,"Monthly Cashflow",{"$f":"'Operations Numbers'!AK23","v":37723.778846153851}]
[null,"Salaries",{"$f":"'One Tribe Summary'!AE27","v":768000},{"$f":"C11/$C$25","v":0.42180410800825685},{"$f":"C11/Assumptions!$B$11","v":12800},{"$f":"'One Tribe Summary'!AG27","v":768000},{"$f":"F11/$F$25","v":0.55622663516647097},{"$f":"F11/Assumptions!$B$11","v":12800},null,null,"Moneys Spent",{"$f":"'Operations Numbers'!AK24","v":761358.42991453002}]
[null,"HR"]
[null,"Rent",{"$f":"'One Tribe Summary'!AE29","v":72000},{"$f":"C13/$C$25","v":3.954413512577408E-2},{"$f":"C13/Assumptions!$B$11","v":1200},{"$f":"'One Tribe Summary'!AG29","v":72000},{"$f":"F13/$F$25","v":5.2146247046856657E-2},{"$f":"F13/Assumptions!$B$11","v":1200},null,null,"Avg. Operating Efficiency",{"$f":"'Operations Numbers'!AL25","v":4.4810056918544436E-2},"$ per Person"]
[null,"Telephone and Internet",{"$f":"'One Tribe Summary'!AE30","v":60600},{"$f":"C14/$C$25","v":3.3282980397526515E-2},{"$f":"C14/Assumptions!$B$11","v":1010},{"$f":"'One Tribe Summary'!AG30","v":60600},{"$f":"F14/$F$25","v":4.3889757931104355E-2},{"$f":"F14/Assumptions!$B$11","v":1010}]
[null,"Travel",{"$f":"'One Tribe Summary'!AE31","v":211896.15384615379},{"$f":"C15/$C$25","v":0.11637847417116831},{"$f":"C15/Assumptions!$B$11","v":3531.6025641025631},{"$f":"'One Tribe Summary'!AG31","v":211896.15384615379},{"$f":"F15/$F$25","v":0.1534665164825039},{"$f":"F15/Assumptions!$B$11","v":3531.6025641025631}]
[null,"Professional Services",{"$f":"'One Tribe Summary'!AE32","v":0},{"$f":"C16/$C$25","v":0},{"$f":"C16/Assumptions!$B$11","v":0},{"$f":"'One Tribe Summary'!AG32","v":0},null,{"$f":"F16/Assumptions!$B$11","v":0}]
[null,"Other",{"$f":"'One Tribe Summary'!AE33","v":0},{"$f":"C17/$C$25","v":0},{"$f":"C17/Assumptions!$B$11","v":0},{"$f":"'One Tribe Summary'!AG33","v":0},null,{"$f":"F17/Assumptions!$B$11","v":0}]
[null,"Total Operating Expenses",{"$f":"'One Tribe Summary'!AE34","v":1445100.4038461533},{"$f":"C18/$C$25","v":0.79368396722226353},{"$f":"C18/Assumptions!$B$11","v":24085.006730769222},{"$f":"'One Tribe Summary'!AG34","v":1380732.1538461533},{"$f":"F18/$F$25","v":1},{"$f":"F18/Assumptions!$B$11","v":23012.202564102554}]
[]
[null,"Non-Operating Expenses"]
[null,"Furniture/Equipment",{"$f":"'One Tribe Summary'!AE37","v":375650},{"$f":"C21/$C$25","v":0.20631603277773655},{"$f":"C21/Assumptions!$B$11","v":6260.833333333333},{"$f":"'One Tribe Summary'!AG37","v":0},{"$f":"F21/$F$25","v":0},{"$f":"F21/Assumptions!$B$11","v":0}]
[null,"Other",{"$f":"'One Tribe Summary'!AE38","v":0}]
[null,"Total Non-Recurring Expense",{"$f":"'One Tribe Summary'!AE39","v":375650},{"$f":"C23/$C$25","v":0.20631603277773655},{"$f":"C23/Assumptions!$B$11","v":6260.833333333333},{"$f":"'One Tribe Summary'!AG39","v":0},{"$f":"F23/$F$25","v":0},{"$f":"F23/Assumptions!$B$11","v":0}]
[{"$nulls":8},"Total"]
[null,"Total Expenses (Rupees)",{"$f":"'One Tribe Summary'!AE41","v":1820750.4038461531},{"$f":"C25/$C$25","v":1},{"$f":"C25/Assumptions!$B$11","v":30345.840064102551},{"$f":"'One Tribe Summary'!AG41","v":1380732.1538461533},{"$f":"F25/$F$25","v":1},{"$f":"F25/Assumptions!$B$11","v":23012.202564102554},{"$f":"H25+E25","v":53358.042628205105}]
[null,"Dollars"]
[]
[null,"Total Projected Budget"]
[]
[null,"Expense",2014,null,null,2015,null,null,2016]
[null,"Operating Expense","Rs","%","Dolalrs","Rs","%","Dolalrs","Rs",null,"Dollars"]
[null,"Marketing",{"$f":"'Summary Breakout'!AH16","v":0},{"$f":"'Summary Breakout'!AI16","v":0},{"$f":"C32/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ16","v":1504300},{"$f":"'Summary Breakout'!AK16","v":9.2368607184664692E-2},{"$f":"F32/Assumptions!$B$11","v":25071.666666666668},{"$f":"'Summary Breakout'!AL16","v":3430600},{"$f":"'Summary Breakout'!AM16","v":0.11880694362274716},{"$f":"I32/Assumptions!$B$11","v":57176.666666666664}]
[null,"Depreciation",{"$f":"'Summary Breakout'!AH17","v":0},{"$f":"'Summary Breakout'!AI17","v":0},{"$f":"C33/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ17","v":0},{"$f":"'Summary Breakout'!AK17","v":0},{"$f":"F33/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AL17","v":0},{"$f":"'Summary Breakout'!AM17","v":0},{"$f":"I33/Assumptions!$B$11","v":0}]
[null,"Maintenance and Repairs",{"$f":"'Summary Breakout'!AH18","v":0},{"$f":"'Summary Breakout'!AI18","v":0},{"$f":"C34/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ18","v":149600},{"$f":"'Summary Breakout'!AK18","v":9.1858961874797824E-3},{"$f":"F34/Assumptions!$B$11","v":2493.3333333333335},{"$f":"'Summary Breakout'!AL18","v":346800},{"$f":"'Summary Breakout'!AM18","v":1.2010216302795055E-2},{"$f":"I34/Assumptions!$B$11","v":5780}]
[null,"Facility Supplies",{"$f":"'Summary Breakout'!AH19","v":0},{"$f":"'Summary Breakout'!AI19","v":0},{"$f":"C35/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ19","v":399520},{"$f":"'Summary Breakout'!AK19","v":2.4531746288916599E-2},{"$f":"F35/Assumptions!$B$11","v":6658.666666666667},{"$f":"'Summary Breakout'!AL19","v":944320},{"$f":"'Summary Breakout'!AM19","v":3.2703251035338596E-2},{"$f":"I35/Assumptions!$B$11","v":15738.666666666666}]
[null,"Salaries",{"$f":"'Summary Breakout'!AH20","v":184000},{"$f":"'Summary Breakout'!AI20","v":0.35367407780445281},{"$f":"C36/Assumptions!$B$11","v":3066.6666666666665},{"$f":"'Summary Breakout'!AJ20","v":7066000},{"$f":"'Summary Breakout'!AK20","v":0.43387394693002773},{"$f":"F36/Assumptions!$B$11","v":117766.66666666667},{"$f":"'Summary Breakout'!AL20","v":15564000},{"$f":"'Summary Breakout'!AM20","v":0.53900520916004102},{"$f":"I36/Assumptions!$B$11","v":259400}]
[null,"HR",{"$f":"'Summary Breakout'!AH21","v":78253},{"$f":"'Summary Breakout'!AI21","v":0.15041335657843397},{"$f":"C37/Assumptions!$B$11","v":1304.2166666666667},{"$f":"'Summary Breakout'!AJ21","v":590986},{"$f":"'Summary Breakout'!AK21","v":3.6288342541804325E-2},{"$f":"F37/Assumptions!$B$11","v":9849.7666666666664},{"$f":"'Summary Breakout'!AL21","v":546792.5},{"$f":"'Summary Breakout'!AM21","v":1.8936263545980579E-2},{"$f":"I37/Assumptions!$B$11","v":9113.2083333333339}]
[null,"Rent",{"$f":"'Summary Breakout'!AH22","v":0},{"$f":"'Summary Breakout'!AI22","v":0},{"$f":"C38/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ22","v":528000},{"$f":"'Summary Breakout'!AK22","v":3.242081007345806E-2},{"$f":"F38/Assumptions!$B$11","v":8800},{"$f":"'Summary Breakout'!AL22","v":1248000},{"$f":"'Summary Breakout'!AM22","v":4.3220155553310921E-2},{"$f":"I38/Assumptions!$B$11","v":20800}]
[null,"Telephone and Internet",{"$f":"'Summary Breakout'!AH23","v":0},{"$f":"'Summary Breakout'!AI23","v":0},{"$f":"C39/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ23","v":444400},{"$f":"'Summary Breakout'!AK23","v":2.7287515145160531E-2},{"$f":"F39/Assumptions!$B$11","v":7406.666666666667},{"$f":"'Summary Breakout'!AL23","v":1050400},{"$f":"'Summary Breakout'!AM23","v":3.6376964257370026E-2},{"$f":"I39/Assumptions!$B$11","v":17506.666666666668}]
[null,"Travel",{"$f":"'Summary Breakout'!AH24","v":0},{"$f":"'Summary Breakout'!AI24","v":0},{"$f":"C40/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ24","v":1236230.128205128},{"$f":"'Summary Breakout'!AK24","v":7.5908299609138558E-2},{"$f":"F40/Assumptions!$B$11","v":20603.835470085465},{"$f":"'Summary Breakout'!AL24","v":2168004.1666666665},{"$f":"'Summary Breakout'!AM24","v":7.5081311957980401E-2},{"$f":"I40/Assumptions!$B$11","v":36133.402777777774}]
[null,"Professional Services",{"$f":"'Summary Breakout'!AH25","v":194000},{"$f":"'Summary Breakout'!AI25","v":0.37289549507643399},{"$f":"C41/Assumptions!$B$11","v":3233.3333333333335},{"$f":"'Summary Breakout'!AJ25","v":0},{"$f":"'Summary Breakout'!AK25","v":0},{"$f":"F41/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AL25","v":0},{"$f":"'Summary Breakout'!AM25","v":0},{"$f":"I41/Assumptions!$B$11","v":0}]
[null,"Other",{"$f":"'Summary Breakout'!AH26","v":0},{"$f":"'Summary Breakout'!AI26","v":0},{"$f":"C42/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ26","v":0},{"$f":"'Summary Breakout'!AK26","v":0},{"$f":"F42/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AL26","v":0},{"$f":"'Summary Breakout'!AM26","v":0},{"$f":"I42/Assumptions!$B$11","v":0}]
[null,"Total Operating Expenses",{"$f":"'Summary Breakout'!AH27","v":456253},{"$f":"'Summary Breakout'!AI27","v":0.87698292945932077},{"$f":"C43/Assumptions!$B$11","v":7604.2166666666662},{"$f":"'Summary Breakout'!AJ27","v":11919036.128205128},{"$f":"'Summary Breakout'!AK27","v":0.73186516396065027},{"$f":"F43/Assumptions!$B$11","v":198650.60213675213},{"$f":"'Summary Breakout'!AL27","v":25298916.666666664},{"$f":"'Summary Breakout'!AM27","v":0.8761403154355637},{"$f":"I43/Assumptions!$B$11","v":421648.61111111107}]
[]
[null,"Non-Operating Expenses"]
[null,"Furniture/Equipment",{"$f":"'Summary Breakout'!AH30","v":0},{"$f":"'Summary Breakout'!AI30","v":0},{"$f":"C46/Assumptions!$B$11","v":0},{"$f":"'Summary Breakout'!AJ30","v":4363800},{"$f":"'Summary Breakout'!AK30","v":0.26795062689120508},{"$f":"F46/Assumptions!$B$11","v":72730},{"$f":"'Summary Breakout'!AL30","v":3576500},{"$f":"'Summary Breakout'!AM30","v":0.12385968456443631},{"$f":"I46/Assumptions!$B$11","v":59608.333333333336}]
[null,"Other",{"$f":"'Summary Breakout'!AH31","v":64000},{"$f":"'Summary Breakout'!AI31","v":0.12301707054067924},{"$f":"C47/Assumptions!$B$11","v":1066.6666666666667},{"$f":"'Summary Breakout'!AJ31","v":3000},{"$f":"'Summary Breakout'!AK31","v":1.8420914814464806E-4},{"$f":"F47/Assumptions!$B$11","v":50},{"$f":"'Summary Breakout'!AL31","v":0},{"$f":"'Summary Breakout'!AM31","v":0},{"$f":"I47/Assumptions!$B$11","v":0}]
[null,"Total Non-Recurring Expense",{"$f":"'Summary Breakout'!AH32","v":64000},{"$f":"'Summary Breakout'!AI32","v":0.12301707054067924},{"$f":"C48/Assumptions!$B$11","v":1066.6666666666667},{"$f":"'Summary Breakout'!AJ32","v":4366800},{"$f":"'Summary Breakout'!AK32","v":0.26813483603934973},{"$f":"F48/Assumptions!$B$11","v":72780},{"$f":"'Summary Breakout'!AL32","v":3576500},{"$f":"'Summary Breakout'!AM32","v":0.12385968456443631},{"$f":"I48/Assumptions!$B$11","v":59608.333333333336}]
[]
[null,"Total Expenses (Rupees)",{"$f":"'Summary Breakout'!AH34","v":520253},{"$f":"'Summary Breakout'!AI34","v":1},{"$f":"C50/Assumptions!$B$11","v":8670.8833333333332},{"$f":"'Summary Breakout'!AJ34","v":16285836.128205128},{"$f":"'Summary Breakout'!AK34","v":1},{"$f":"F50/Assumptions!$B$11","v":271430.60213675216},{"$f":"'Summary Breakout'!AL34","v":28875416.666666664},{"$f":"'Summary Breakout'!AM34","v":1},{"$f":"I50/Assumptions!$B$11","v":481256.94444444438}]
[null,"Dollars"]

{"sheet":"Operations Numbers","index":4,"n_rows":25,"n_cols":38,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$nulls":4},"Facility Start Dates","# of Blocks Starting","Total Batches"]
[{"$nulls":4},{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4},{"$f":"F4","v":4},{"$f":"IF(E4>0,(HLOOKUP(E4,$I$17:$AK$18,2)),0)","v":5}]
[{"$nulls":4},{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8},{"$f":"G4+F5","v":12},{"$f":"IF(E5>0,(HLOOKUP(E5,$I$17:$AK$18,2)),0)","v":12}]
[{"$nulls":4},{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10},{"$f":"G5+F6","v":22},24]
[]
[]
[]
[]
[{"$nulls":5},"# of VV per Tribe",{"$f":"Assumptions!G3","v":6}]
[{"$nulls":5},{"$f":"Assumptions!F4","v":"Population per Panch"},{"$f":"Assumptions!G4","v":10000}]
[]
[]
[]
[{"$nulls":8},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[{"$nulls":8},"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":8},{"$f":"I16","v":1},{"$f":"J16","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[{"$nulls":7},"# of Blocks",{"$f":"IF(I$16>($H6-1),$G$6,IF(I$16>($H5-1),$G$5,IF(I$16>($H$4-1),$G$4,0)))","v":0},{"$f":"IF(J$16>($H6-1),$G$6,IF(J$16>($H5-1),$G$5,IF(J$16>($H$4-1),$G$4,0)))","v":0},0,0,{"$f":"IF(M$16>($H6-1),$G$6,IF(M$16>($H5-1),$G$5,IF(M$16>($H$4-1),$G$4,0)))","v":4},4,4,4,4,4,4,12,12,12,12,12,12,12,12,12,12,12,12,22,22,22,22,22,22]
[{"$nulls":7},"# of Village Visionaries",{"$f":"I19*$G11","v":0},0,0,0,24,24,24,24,24,24,24,72,72,72,72,72,72,72,72,72,72,72,72,132,132,132,132,132,132]
[{"$nulls":7},"# of Panchayats",{"$f":"I20","v":0},{"$f":"J20","v":0},0,0,24,24,24,24,24,24,24,72,72,72,72,72,72,72,72,72,72,72,72,132,132,132,132,132,132]
[{"$nulls":7},"Population Served",{"$f":"I21*$G12","v":0},{"$f":"J21*$G12","v":0},0,0,240000,240000,240000,240000,240000,240000,240000,720000,720000,720000,720000,720000,720000,720000,720000,720000,720000,720000,720000,1320000,1320000,1320000,1320000,1320000,1320000]
[{"$nulls":7},"Monthly Cashflow",{"$f":"'Summary Breakout'!D35","v":1350},{"$f":"'Summary Breakout'!E35","v":2850},{"$f":"'Summary Breakout'!F35","v":50},{"$f":"'Summary Breakout'!G35","v":4420.8833333333332},{"$f":"'Summary Breakout'!H35","v":34015.909188034188},{"$f":"'Summary Breakout'!I35","v":9772.5758547008536},{"$f":"'Summary Breakout'!J35","v":9772.5758547008536},{"$f":"'Summary Breakout'!K35","v":9772.5758547008536},{"$f":"'Summary Breakout'!L35","v":9772.5758547008536},{"$f":"'Summary Breakout'!M35","v":12039.242521367521},{"$f":"'Summary Breakout'!N35","v":12039.242521367521},{"$f":"'Summary Breakout'!O35","v":79078.327564102568},{"$f":"'Summary Breakout'!P35","v":23791.89423076923},{"$f":"'Summary Breakout'!Q35","v":23791.89423076923},{"$f":"'Summary Breakout'!R35","v":23791.89423076923},{"$f":"'Summary Breakout'!S35","v":23791.89423076923},{"$f":"'Summary Breakout'!T35","v":23791.89423076923},{"$f":"'Summary Breakout'!U35","v":23791.89423076923},{"$f":"'Summary Breakout'!V35","v":23791.89423076923},{"$f":"'Summary Breakout'!W35","v":23791.89423076923},{"$f":"'Summary Breakout'!X35","v":23791.89423076923},{"$f":"'Summary Breakout'!Y35","v":26625.227564102563},{"$f":"'Summary Breakout'!Z35","v":26625.227564102563},{"$f":"'Summary Breakout'!AA35","v":109969.3547008547},{"$f":"'Summary Breakout'!AB35","v":41247.813034188031},{"$f":"'Summary Breakout'!AC35","v":41247.813034188031},{"$f":"'Summary Breakout'!AD35","v":41134.479700854703},{"$f":"'Summary Breakout'!AE35","v":37723.778846153851},{"$f":"'Summary Breakout'!AF35","v":37723.778846153851}]
[{"$nulls":7},"Moneys Spent",{"$f":"'Summary Breakout'!D41","v":1350},{"$f":"'Summary Breakout'!E41","v":4200},{"$f":"'Summary Breakout'!F41","v":4250},{"$f":"'Summary Breakout'!G41","v":8670.8833333333332},{"$f":"'Summary Breakout'!H41","v":42686.792521367519},{"$f":"'Summary Breakout'!I41","v":52459.368376068371},{"$f":"'Summary Breakout'!J41","v":62231.944230769222},{"$f":"'Summary Breakout'!K41","v":72004.520085470082},{"$f":"'Summary Breakout'!L41","v":81777.095940170941},{"$f":"'Summary Breakout'!M41","v":93816.338461538457},{"$f":"'Summary Breakout'!N41","v":105855.58098290597},{"$f":"'Summary Breakout'!O41","v":184933.90854700853},{"$f":"'Summary Breakout'!P41","v":208725.80277777775},{"$f":"'Summary Breakout'!Q41","v":232517.69700854697},{"$f":"'Summary Breakout'!R41","v":256309.59123931619},{"$f":"'Summary Breakout'!S41","v":280101.4854700854},{"$f":"'Summary Breakout'!T41","v":303893.37970085465},{"$f":"'Summary Breakout'!U41","v":327685.2739316239},{"$f":"'Summary Breakout'!V41","v":351477.16816239315},{"$f":"'Summary Breakout'!W41","v":375269.0623931624},{"$f":"'Summary Breakout'!X41","v":399060.95662393165},{"$f":"'Summary Breakout'!Y41","v":425686.18418803421},{"$f":"'Summary Breakout'!Z41","v":452311.41175213677},{"$f":"'Summary Breakout'!AA41","v":562280.76645299152},{"$f":"'Summary Breakout'!AB41","v":603528.57948717952},{"$f":"'Summary Breakout'!AC41","v":644776.39252136752},{"$f":"'Summary Breakout'!AD41","v":685910.87222222227},{"$f":"'Summary Breakout'!AE41","v":723634.65106837614},{"$f":"'Summary Breakout'!AF41","v":761358.42991453002}]
[{"$nulls":7},"Operating Efficiency",{"$nulls":4},{"$f":"M23/M22","v":0.14173295495014246},{"$f":"N23/N22","v":4.0719066061253556E-2},4.0719066061253556E-2,4.0719066061253556E-2,4.0719066061253556E-2,5.0163510505698006E-2,5.0163510505698006E-2,0.10983101050569802,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.3044297542735045E-2,3.6979482727920225E-2,3.6979482727920225E-2,8.3310117197617203E-2,3.1248343207718205E-2,3.1248343207718205E-2,3.1162484621859624E-2,2.8578620337995343E-2,2.8578620337995343E-2,{"$f":"AVERAGE(M25:AK25)","v":4.4810056918544436E-2}]

{"sheet":"Marketing","index":5,"n_rows":59,"n_cols":36,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
["Item","Cost","Cost Per Facility per month",null,"Facility Start Dates","#"]
["Block Level Mktg",{"$f":"'Marketing Assumptions'!E11","v":16112.5},{"$f":"B4","v":16112.5},null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
["Overhead Mktg",{"$f":"'Marketing Assumptions'!E21","v":7200},{"$f":"B5","v":7200},null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
[{"$nulls":4},{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
{"$rows_empty":9}
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
["Batch 1",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Block Level Mktg",{"$f":"VLOOKUP(A19,$A$4:$C$10,3,FALSE)","v":16112.5},{"$f":"F4","v":4},{"$f":"B19*C19","v":64450},{"$f":"E4","v":"2015-01-01"},{"$f":"IF(E19>0,(HLOOKUP(E19,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(H$16>($F19+22),0,IF(H$16<$F19,0,IF(H$16=$F19,$D19,IF(H$16>$F19,G19))))","v":0},{"$f":"IF(I$16>($F19+22),0,IF(I$16<$F19,0,IF(I$16=$F19,$D19,IF(I$16>$F19,H19))))","v":0},{"$f":"IF(J$16>($F19+22),0,IF(J$16<$F19,0,IF(J$16=$F19,$D19,IF(J$16>$F19,I19))))","v":0},0,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,64450,0,0]
["Overhead Mktg",{"$f":"VLOOKUP(A20,$A$4:$C$10,3,FALSE)","v":7200},1,7200,{"$f":"E19","v":"2015-01-01"},{"$f":"IF(E20>0,(HLOOKUP(E20,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(H$16>($F20+22),0,IF(H$16<$F20,0,IF(H$16=$F20,$D20,IF(H$16>$F20,G20))))","v":0},0,0,0,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,7200,0,0]
[null,{"$error":"#N/A"},{"$f":"C20","v":1},{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F21+22),0,IF(H$16<$F21,0,IF(H$16=$F21,$D21,IF(H$16>$F21,G21))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F22+22),0,IF(H$16<$F22,0,IF(H$16=$F22,$D22,IF(H$16>$F22,G22))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F23+22),0,IF(H$16<$F23,0,IF(H$16=$F23,$D23,IF(H$16>$F23,G23))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,0,null,0,null,{"$f":"IF(H$16>($F24+22),0,IF(H$16<$F24,0,IF(H$16=$F24,$D24,IF(H$16>$F24,G24))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A25,$A$4:$C$10,3,FALSE)","v":{"$error":"#N/A"}},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F25+22),0,IF(H$16<$F25,0,IF(H$16=$F25,$D25,IF(H$16>$F25,G25))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,{"$f":"B26*C26","v":0},null,0,null,{"$f":"IF(H$16>($F26+22),0,IF(H$16<$F26,0,IF(H$16=$F26,$D26,IF(H$16>$F26,G26))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F27+22),0,IF(H$16<$F27,0,IF(H$16=$F27,$D27,IF(H$16>$F27,G27))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B28*C28","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16>($F28+22),0,IF(H$16<$F28,0,IF(H$16=$F28,$D28,IF(H$16>$F28,G28))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B29*C29","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16>($F29+22),0,IF(H$16<$F29,0,IF(H$16=$F29,$D29,IF(H$16>$F29,G29))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16>($F30+22),0,IF(H$16<$F30,0,IF(H$16=$F30,$D30,IF(H$16>$F30,G30))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 2",{"$error":"#N/A"},null,{"$f":"B31*C31","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16>($F31+22),0,IF(H$16<$F31,0,IF(H$16=$F31,$D31,IF(H$16>$F31,G31))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Block Level Mktg",16112.5,{"$f":"F5","v":8},128900,{"$f":"E5","v":"2015-08-01"},12,null,{"$f":"IF(H$16>($F32+22),0,IF(H$16<$F32,0,IF(H$16=$F32,$D32,IF(H$16>$F32,G32))))","v":0},0,0,0,0,0,0,0,0,0,0,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900,128900]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F33+22),0,IF(H$16<$F33,0,IF(H$16=$F33,$D33,IF(H$16>$F33,G33))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C33","v":1},{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F34+22),0,IF(H$16<$F34,0,IF(H$16=$F34,$D34,IF(H$16>$F34,G34))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F35+22),0,IF(H$16<$F35,0,IF(H$16=$F35,$D35,IF(H$16>$F35,G35))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F36+22),0,IF(H$16<$F36,0,IF(H$16=$F36,$D36,IF(H$16>$F36,G36))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,0,null,0,null,{"$f":"IF(H$16>($F37+22),0,IF(H$16<$F37,0,IF(H$16=$F37,$D37,IF(H$16>$F37,G37))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F38+22),0,IF(H$16<$F38,0,IF(H$16=$F38,$D38,IF(H$16>$F38,G38))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(H$16>($F39+22),0,IF(H$16<$F39,0,IF(H$16=$F39,$D39,IF(H$16>$F39,G39))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,{"$f":"E39","v":"00:00:00"},0,null,{"$f":"IF(H$16>($F40+22),0,IF(H$16<$F40,0,IF(H$16=$F40,$D40,IF(H$16>$F40,G40))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,"00:00:00",0,null,{"$f":"IF(H$16>($F41+22),0,IF(H$16<$F41,0,IF(H$16=$F41,$D41,IF(H$16>$F41,G41))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F42+22),0,IF(H$16<$F42,0,IF(H$16=$F42,$D42,IF(H$16>$F42,G42))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F43+22),0,IF(H$16<$F43,0,IF(H$16=$F43,$D43,IF(H$16>$F43,G43))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 3",{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F44+22),0,IF(H$16<$F44,0,IF(H$16=$F44,$D44,IF(H$16>$F44,G44))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Block Level Mktg",16112.5,{"$f":"F6","v":10},161125,{"$f":"E6","v":"2016-08-01"},24,null,{"$f":"IF(H$16>($F45+22),0,IF(H$16<$F45,0,IF(H$16=$F45,$D45,IF(H$16>$F45,G45))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,161125,161125,161125,161125,161125,161125]
[null,{"$error":"#N/A"},1,{"$f":"B46*C46","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16>($F46+22),0,IF(H$16<$F46,0,IF(H$16=$F46,$D46,IF(H$16>$F46,G46))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F47+22),0,IF(H$16<$F47,0,IF(H$16=$F47,$D47,IF(H$16>$F47,G47))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F48+22),0,IF(H$16<$F48,0,IF(H$16=$F48,$D48,IF(H$16>$F48,G48))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F49+22),0,IF(H$16<$F49,0,IF(H$16=$F49,$D49,IF(H$16>$F49,G49))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(H$16>($F50+22),0,IF(H$16<$F50,0,IF(H$16=$F50,$D50,IF(H$16>$F50,G50))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16>($F51+22),0,IF(H$16<$F51,0,IF(H$16=$F51,$D51,IF(H$16>$F51,G51))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(H$16>($F52+22),0,IF(H$16<$F52,0,IF(H$16=$F52,$D52,IF(H$16>$F52,G52))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(H$16>($F53+22),0,IF(H$16<$F53,0,IF(H$16=$F53,$D53,IF(H$16>$F53,G53))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"B54*C54","v":0},null,0,null,{"$f":"IF(H$16>($F54+22),0,IF(H$16<$F54,0,IF(H$16=$F54,$D54,IF(H$16>$F54,G54))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B55*C55","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16>($F55+22),0,IF(H$16<$F55,0,IF(H$16=$F55,$D55,IF(H$16>$F55,G55))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16>($F56+22),0,IF(H$16<$F56,0,IF(H$16=$F56,$D56,IF(H$16>$F56,G56))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16>($F57+22),0,IF(H$16<$F57,0,IF(H$16=$F57,$D57,IF(H$16>$F57,G57))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16>($F58+22),0,IF(H$16<$F58,0,IF(H$16=$F58,$D58,IF(H$16>$F58,G58))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H19:H58)","v":0},{"$f":"SUM(I19:I58)","v":0},0,0,{"$f":"SUM(L19:L58)","v":71650},71650,71650,71650,71650,71650,71650,200550,200550,200550,200550,200550,200550,200550,200550,200550,200550,200550,200550,361675,361675,361675,361675,290025,290025]

{"sheet":"Marketing Assumptions","index":6,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Marketing "]
[]
[null,"Per Block",{"$nulls":5},"*Panchayat Gatherings"]
[null,"Item","Item Cost","# of Items","Total Cost",null,null,"Item","Item Cost","# of Items","Total Cost"]
[null,"Flyers",2,2000,{"$f":"PRODUCT(D5,C5)","v":4000},null,null,"Renting Chairs",10,75,{"$f":"PRODUCT(J5,I5)","v":750}]
[null,"District/  Block Newspaper Ad",500,1,{"$f":"PRODUCT(D6,C6)","v":500},null,null,"Snacks",15,75,{"$f":"PRODUCT(J6,I6)","v":1125}]
[null,"Banners",300,1,{"$f":"PRODUCT(D7,C7)","v":300},null,null,"Speaker System",5000,1,{"$f":"PRODUCT(J7,I7)","v":5000}]
[null,"Local Print",500,2,{"$f":"PRODUCT(D8,C8)","v":1000}]
[null,"Panchayat gatherings*","See Key","See Key",{"$f":"(K13)","v":10312.5},{"$nulls":4},"Total",{"$f":"SUM(K7,K6,K5)","v":6875}]
[{"$nulls":11},{"$f":"K9*18","v":123750}]
[null,null,null,"Total ",{"$f":"SUM(E9,E8,E7,E6,E5)","v":16112.5},{"$nulls":4},"Gatherings per Block every three months",6,{"$f":"L10/12","v":10312.5}]
[]
[{"$nulls":9},"Block Cost",{"$f":"PRODUCT(K11,K9/4)","v":10312.5}]
[null,"Core Team"]
[null,"Item","Item Cost","# of Items","Total Cost"]
[null,"Large scale publications ",1000,3,{"$f":"PRODUCT(D16,C16)","v":3000}]
[null,"Social Media Sponsor/ Boost",300,14,{"$f":"PRODUCT(D17*C17)","v":4200}]
[null,"Conference Fees"]
[null,"Merchandise: Shirts "]
[null,"Merchandise: Flags"]
[null,null,null,"Total:",{"$f":"SUM(E16:E20)","v":7200}]

{"sheet":"Recruitment","index":7,"n_rows":59,"n_cols":36,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
["Item","Cost",null,null,"Facility Start Dates","#"]
["BPO Recruitment (8 BPOs)",{"$f":"'Recruitment Assumptions'!E11","v":23500},null,null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4},{"$nulls":4},{"$f":"8*1.25","v":10}]
["BPO Field Assignment (8 BPOs)",{"$f":"'Recruitment Assumptions'!E27","v":70086},null,null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
["BPO Training (4 BPOs)",{"$f":"'Recruitment Assumptions'!E44","v":16720},null,null,{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
["VV Recruitment (1 block)",{"$f":"'Recruitment Assumptions'!E58","v":14740}]
["VV Field Assignment (4 blocks)",{"$f":"'Recruitment Assumptions'!E74","v":135000}]
{"$rows_empty":7}
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,"Cost",null,"Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
["Batch 1",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["BPO Recruitment (Above/2)",{"$f":"B4/2","v":11750},1,{"$f":"B19*C19","v":11750},{"$f":"E4-1","v":"2014-12-31"},{"$f":"IF(E19>0,(HLOOKUP(E19,$H$17:$AJ$18,2)),0)","v":4},null,{"$f":"IF(H$16=($F19),$D19,0)","v":0},{"$f":"IF(I$16=($F19),$D19,0)","v":0},0,11750,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Y$16=($F19),$D19,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["BPO Field Assignment (Above/2)",{"$f":"B5/2","v":35043},1,35043,{"$f":"E19","v":"2014-12-31"},{"$f":"IF(E20>0,(HLOOKUP(E20,$H$17:$AJ$18,2)),0)","v":4},null,{"$f":"IF(H$16=($F20),$D20,0)","v":0},0,0,35043,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["BPO Training",{"$f":"B6","v":16720},{"$f":"C20","v":1},16720,{"$f":"E20","v":"2014-12-31"},4,null,0,0,0,16720,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["VV Recruitment (1 block)",{"$f":"B7","v":14740},1,14740,{"$f":"E21","v":"2014-12-31"},4,null,0,0,0,14740,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["VV Field Assignment",{"$f":"B8","v":135000},1,135000,{"$f":"E4","v":"2015-01-01"},5,null,0,0,0,0,135000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A25,$A$4:$C$10,3,FALSE)","v":{"$error":"#N/A"}},1,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A27,$A$4:$C$10,3,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B28*C28","v":{"$error":"#N/A"}},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B29*C29","v":{"$error":"#N/A"}},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 2",{"$error":"#N/A"},null,{"$f":"B31*C31","v":{"$error":"#N/A"}},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["BPO Recruitment",{"$f":"B4","v":23500},1,23500,{"$f":"E5","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,23500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["BPO Field Assignment",{"$f":"B5","v":70086},1,70086,{"$f":"E32","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,70086,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["BPO Training (Above *2)",{"$f":"B6*2","v":33440},{"$f":"C33","v":1},33440,{"$f":"E33","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,33440,0,0,0,0,{"$f":"IF(X$16=($F34),$D34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["VV Recruitment x4",{"$f":"B7*4","v":58960},1,58960,{"$f":"E34","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,58960,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["VV Field Assignment x2",{"$f":"B8*2","v":270000},1,270000,{"$f":"E35","v":"2015-08-01"},12,null,{"$f":"IF(H$16=($F36),$D36,0)","v":0},0,0,0,0,0,0,0,0,0,0,270000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,{"$f":"E39","v":"00:00:00"},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,"00:00:00",0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 3",{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["BPO Recruitment (above*1.25)",{"$f":"B4*1.25","v":29375},1,29375,{"$f":"E6","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29375,0,0,0,0,0]
["BPO Field Assignment (Above*1.25)",{"$f":"B5*1.25","v":87607.5},1,87607.5,{"$f":"E45","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,87607.5,0,0,0,0,0]
["BPO Training (Above *2.25)",{"$f":"B6*2.25","v":37620},1,37620,{"$f":"E46","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,37620,0,0,0,0,0]
["VV Recruitment x6",{"$f":"B7*6","v":88440},1,88440,{"$f":"E47","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,88440,0,0,0,0,0]
["VV Field Assignment x2.25",{"$f":"B8*2.25","v":303750},1,303750,{"$f":"E48","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,303750,0,0,0,0,0]
[null,null,1,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(X$16=($F50),$D50,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(W$16=($F51),$D51,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(H$16=($F52),$D52,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"B54*C54","v":0},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B55*C55","v":{"$error":"#N/A"}},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H19:H58)","v":0},{"$f":"SUM(I19:I58)","v":0},0,78253,{"$f":"SUM(L19:L58)","v":135000},0,0,0,0,0,0,455986,0,0,0,0,0,0,0,0,0,0,0,546792.5,0,0,0,0,0]

{"sheet":"Recruitment Assumptions","index":8,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Marketing "]
[]
[null,"BPO Recruitment and Interviews for 8 BPOs"]
[null,"Item","Item Cost","# of Items","Total Cost"]
[null,"Facebook, Linkedin Promotion",1,2500,{"$f":"PRODUCT(D5,C5)","v":2500}]
[null,"Phone Interviews",10,50,{"$f":"PRODUCT(D6,C6)","v":500}]
[null,"In person Interview Travel",600,25,{"$f":"PRODUCT(D7,C7)","v":15000}]
[null,"Food",100,25,{"$f":"PRODUCT(D8,C8)","v":2500}]
[null,"Core Team Travel",1000,3,{"$f":"PRODUCT(D9,C9)","v":3000},null,null,"HR Per Block Cost Total"]
[{"$nulls":7},"BPO Recruitment",{"$f":"E11/8","v":2937.5}]
[null,null,null,"Total ",{"$f":"SUM(E5:E9)","v":23500},null,null,"BPO Field Assignment",{"$f":"E27/8","v":8760.75}]
[{"$nulls":7},"BPO Training",{"$f":"E44/4","v":4180}]
[null,"BPO Field Assignment for 8 BPOs","Includes 3 field assignments",{"$nulls":4},"VV Recruitment",{"$f":"E58","v":14740}]
[null,"Item","Item Cost","# of Items","Total Cost",null,null,"VV Field Assignment",{"$f":"E74/4","v":33750}]
[null,"Core Team Travel",600,8,{"$f":"PRODUCT(D15,C15)","v":4800},null,null,null,{"$f":"SUM(I10:I14)","v":64368.25}]
[null,"BPO Travel",600,15,{"$f":"PRODUCT(D16*C16)","v":9000}]
[null,"Travel In Block (BPOs)",50,{"$f":"7*15","v":105},{"$f":"PRODUCT(D17*C17)","v":5250}]
[null,"Travel in Block (PP Team)",50,{"$f":"8*21","v":168},8400]
[null,"Food  (BPOs)",100,{"$f":"15*7","v":105},10500]
[null,"Food (PP Team)",100,{"$f":"8*21","v":168},{"$f":"PRODUCT(D20*C20)","v":16800}]
[null,"Food (VV Candidates)",90,{"$f":"20*6","v":120},10800]
[null,"Printed Materials (test)",2,{"$f":"25*15","v":375},{"$f":"PRODUCT(D22*C22)","v":750}]
[null,"Printed Materials (Scorecard)",2,{"$f":"15*15","v":225},450]
[null,"PP Team Scoring Sheets",2,{"$f":"21*8","v":168},336]
[null,"Misc Office Supplies",1000,3,{"$f":"PRODUCT(D25*C25)","v":3000}]
[]
[null,null,null,"Total ",{"$f":"SUM(E15:E25)","v":70086}]
[]
[]
[]
[]
[null,"Training of BPOs for 4 BPOs"]
[null,"Item","Item Cost","# of Items","Total Cost"]
[null,"Core Team Travel",600,4,{"$f":"PRODUCT(D34,C34)","v":2400}]
[null,"BPO Travel",600,4,{"$f":"PRODUCT(D35*C35)","v":2400}]
[null,"Travel In Block (BPOs)",50,{"$f":"4*7","v":28},{"$f":"PRODUCT(D36*C36)","v":1400}]
[null,"Food  (BPOs)",100,{"$f":"4*7","v":28},2800]
[null,"Food (PP Team)",100,{"$f":"4*7","v":28},2800]
[null,"Food (VV Candidates)",90,{"$f":"20*2","v":40},3600]
[null,"Printed Materials (test)",2,{"$f":"25*4","v":100},200]
[null,"Printed Materials (Intvw Scoreard)",2,{"$f":"4*15","v":60},120]
[null,"Misc Office Supplies",1000,1,1000]
[]
[null,null,null,"Total ",{"$f":"SUM(E34:E42)","v":16720}]
[]
[]
[]
[null,"Recruitment of VVs 1 block"]
[null,"Item","Item Cost","# of Items","Total Cost"]
[null,"Field Manager Travel",600,2,{"$f":"PRODUCT(D50,C50)","v":1200}]
[null,"BPO Travel",600,8,{"$f":"PRODUCT(D51*C51)","v":4800}]
[null,"Travel In Block (BPOs)",50,{"$f":"10*7","v":70},{"$f":"PRODUCT(D52*C52)","v":3500}]
[null,"Food (VV Candidates)",90,{"$f":"20*2","v":40},3600]
[null,"Printed Materials (test)",2,{"$f":"25*8","v":200},400]
[null,"Printed Materials (Intvw Scoreard)",2,{"$f":"15*8","v":120},240]
[null,"Misc Office Supplies",1000,1,1000]
[]
[null,null,null,"Total ",{"$f":"SUM(E50:E56)","v":14740}]
[]
[]
[null,"VV Field Assignment -To Select 24 VVs "]
[null,"Item","Item Cost","# of Items","Total Cost"]
[null,"Field Manager Travel",600,12,{"$f":"PRODUCT(D63,C63)","v":7200}]
[null,"BPO Travel",600,8,{"$f":"PRODUCT(D64*C64)","v":4800}]
[null,"VV Travel",600,40,{"$f":"PRODUCT(D65*C65)","v":24000}]
[null,"VV Accommodation",200,{"$f":"40*7","v":280},{"$f":"PRODUCT(D66*C66)","v":56000}]
[null,"Travel In Block (BPOs)",50,{"$f":"10*7","v":70},{"$f":"PRODUCT(D67*C67)","v":3500}]
[null,"Bed Transportation",3000,1,3000]
[null,"Food ",100,{"$f":"20*2","v":40},4000]
[null,"Training Facility Rent",2000,7,14000]
[null,"Travel in Block ",50,{"$f":"50*7","v":350},17500]
[null,"Misc Office Supplies",1000,1,1000]
[]
[null,null,null,"Total ",{"$f":"SUM(E63:E72)","v":135000}]

{"sheet":"Maintenence & Repairs","index":9,"n_rows":59,"n_cols":36,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
["Item","Cost","Cost Per Facility per month",null,"Facility Start Dates","#"]
["Bike Maintenance",100,700,null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
["Facility Maintence",1000,{"$f":"B5","v":1000},null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
[{"$nulls":4},{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
{"$rows_empty":9}
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
["Batch 1",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Bike Maintenance",{"$f":"VLOOKUP(A19,$A$4:$C$10,3,FALSE)","v":700},{"$f":"F4","v":4},{"$f":"B19*C19","v":2800},{"$f":"E4","v":"2015-01-01"},{"$f":"IF(E19>0,(HLOOKUP(E19,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(I$16>($F19+22),0,IF(H$16<$F19,0,IF(H$16=$F19,$D19,IF(H$16>$F19,G19))))","v":0},{"$f":"IF(J$16>($F19+22),0,IF(I$16<$F19,0,IF(I$16=$F19,$D19,IF(I$16>$F19,H19))))","v":0},0,0,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,0,0,0]
["Facility Maintence",{"$f":"VLOOKUP(A20,$A$4:$C$10,3,FALSE)","v":1000},{"$f":"C19","v":4},4000,{"$f":"E19","v":"2015-01-01"},{"$f":"IF(E20>0,(HLOOKUP(E20,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(I$16>($F20+22),0,IF(H$16<$F20,0,IF(H$16=$F20,$D20,IF(H$16>$F20,G20))))","v":0},{"$f":"IF(J$16>($F20+22),0,IF(I$16<$F20,0,IF(I$16=$F20,$D20,IF(I$16>$F20,H20))))","v":0},0,0,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C20","v":4},{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F21+22),0,IF(H$16<$F21,0,IF(H$16=$F21,$D21,IF(H$16>$F21,G21))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},4,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F22+22),0,IF(H$16<$F22,0,IF(H$16=$F22,$D22,IF(H$16>$F22,G22))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},4,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F23+22),0,IF(H$16<$F23,0,IF(H$16=$F23,$D23,IF(H$16>$F23,G23))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,4,0,null,0,null,{"$f":"IF(I$16>($F24+22),0,IF(H$16<$F24,0,IF(H$16=$F24,$D24,IF(H$16>$F24,G24))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A25,$A$4:$C$10,3,FALSE)","v":{"$error":"#N/A"}},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F25+22),0,IF(H$16<$F25,0,IF(H$16=$F25,$D25,IF(H$16>$F25,G25))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,{"$f":"B26*C26","v":0},null,0,null,{"$f":"IF(I$16>($F26+22),0,IF(H$16<$F26,0,IF(H$16=$F26,$D26,IF(H$16>$F26,G26))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F27+22),0,IF(H$16<$F27,0,IF(H$16=$F27,$D27,IF(H$16>$F27,G27))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B28*C28","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(I$16>($F28+22),0,IF(H$16<$F28,0,IF(H$16=$F28,$D28,IF(H$16>$F28,G28))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B29*C29","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(I$16>($F29+22),0,IF(H$16<$F29,0,IF(H$16=$F29,$D29,IF(H$16>$F29,G29))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(I$16>($F30+22),0,IF(H$16<$F30,0,IF(H$16=$F30,$D30,IF(H$16>$F30,G30))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 2",{"$error":"#N/A"},null,{"$f":"B31*C31","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(I$16>($F31+22),0,IF(H$16<$F31,0,IF(H$16=$F31,$D31,IF(H$16>$F31,G31))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bike Maintenance",700,{"$f":"F5","v":8},5600,{"$f":"E5","v":"2015-08-01"},12,null,{"$f":"IF(I$16>($F32+22),0,IF(H$16<$F32,0,IF(H$16=$F32,$D32,IF(H$16>$F32,G32))))","v":0},0,0,0,0,0,0,0,0,0,0,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600]
["Facility Maintence",1000,{"$f":"C32","v":8},8000,{"$f":"E32","v":"2015-08-01"},12,null,{"$f":"IF(I$16>($F33+22),0,IF(H$16<$F33,0,IF(H$16=$F33,$D33,IF(H$16>$F33,G33))))","v":0},0,0,0,0,0,0,0,0,0,0,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000]
[null,{"$error":"#N/A"},{"$f":"C33","v":8},{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F34+22),0,IF(H$16<$F34,0,IF(H$16=$F34,$D34,IF(H$16>$F34,G34))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},8,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F35+22),0,IF(H$16<$F35,0,IF(H$16=$F35,$D35,IF(H$16>$F35,G35))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F36+22),0,IF(H$16<$F36,0,IF(H$16=$F36,$D36,IF(H$16>$F36,G36))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,1,0,null,0,null,{"$f":"IF(I$16>($F37+22),0,IF(H$16<$F37,0,IF(H$16=$F37,$D37,IF(H$16>$F37,G37))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F38+22),0,IF(H$16<$F38,0,IF(H$16=$F38,$D38,IF(H$16>$F38,G38))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(I$16>($F39+22),0,IF(H$16<$F39,0,IF(H$16=$F39,$D39,IF(H$16>$F39,G39))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(I$16>($F40+22),0,IF(H$16<$F40,0,IF(H$16=$F40,$D40,IF(H$16>$F40,G40))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(I$16>($F41+22),0,IF(H$16<$F41,0,IF(H$16=$F41,$D41,IF(H$16>$F41,G41))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F42+22),0,IF(H$16<$F42,0,IF(H$16=$F42,$D42,IF(H$16>$F42,G42))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F43+22),0,IF(H$16<$F43,0,IF(H$16=$F43,$D43,IF(H$16>$F43,G43))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 3",{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F44+22),0,IF(H$16<$F44,0,IF(H$16=$F44,$D44,IF(H$16>$F44,G44))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bike Maintenance",700,{"$f":"F6","v":10},7000,{"$f":"E6","v":"2016-08-01"},24,null,{"$f":"IF(I$16>($F45+22),0,IF(H$16<$F45,0,IF(H$16=$F45,$D45,IF(H$16>$F45,G45))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7000,7000,7000,7000,7000,7000]
["Facility Maintence",1000,{"$f":"C45","v":10},{"$f":"B46*C46","v":10000},{"$f":"E45","v":"2016-08-01"},24,null,{"$f":"IF(I$16>($F46+22),0,IF(H$16<$F46,0,IF(H$16=$F46,$D46,IF(H$16>$F46,G46))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10000,10000,10000,10000,10000,10000]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F47+22),0,IF(H$16<$F47,0,IF(H$16=$F47,$D47,IF(H$16>$F47,G47))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F48+22),0,IF(H$16<$F48,0,IF(H$16=$F48,$D48,IF(H$16>$F48,G48))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F49+22),0,IF(H$16<$F49,0,IF(H$16=$F49,$D49,IF(H$16>$F49,G49))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(I$16>($F50+22),0,IF(H$16<$F50,0,IF(H$16=$F50,$D50,IF(H$16>$F50,G50))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(I$16>($F51+22),0,IF(H$16<$F51,0,IF(H$16=$F51,$D51,IF(H$16>$F51,G51))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(I$16>($F52+22),0,IF(H$16<$F52,0,IF(H$16=$F52,$D52,IF(H$16>$F52,G52))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,null,0,null,{"$f":"IF(I$16>($F53+22),0,IF(H$16<$F53,0,IF(H$16=$F53,$D53,IF(H$16>$F53,G53))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"B54*C54","v":0},null,0,null,{"$f":"IF(I$16>($F54+22),0,IF(H$16<$F54,0,IF(H$16=$F54,$D54,IF(H$16>$F54,G54))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B55*C55","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(I$16>($F55+22),0,IF(H$16<$F55,0,IF(H$16=$F55,$D55,IF(H$16>$F55,G55))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(I$16>($F56+22),0,IF(H$16<$F56,0,IF(H$16=$F56,$D56,IF(H$16>$F56,G56))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(I$16>($F57+22),0,IF(H$16<$F57,0,IF(H$16=$F57,$D57,IF(H$16>$F57,G57))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(I$16>($F58+22),0,IF(H$16<$F58,0,IF(H$16=$F58,$D58,IF(H$16>$F58,G58))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H19:H58)","v":0},{"$f":"SUM(I19:I58)","v":0},0,0,{"$f":"SUM(L19:L58)","v":6800},6800,6800,6800,6800,6800,6800,20400,20400,20400,20400,20400,20400,20400,20400,20400,20400,20400,20400,37400,37400,37400,30600,30600,30600]

{"sheet":"Office Supplies","index":10,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Item","Item Price","# of people","# of Items","Monthly Cost"]
["Print Materials",10,1,200,{"$f":"B3*D3","v":2000},null,null,"Facility Start Dates","#"]
["Stationaries ",10,1,200,{"$f":"B4*D4","v":2000},null,null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
["Gas",80,1,4,{"$f":"D5*B5","v":320},null,null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
["Milk",40,1,3,{"$f":"D6*B6","v":120},null,null,{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
["Toiletries ",10,1,10,{"$f":"D7*B7","v":100}]
[]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Monthly Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Print Materials",{"$f":"VLOOKUP(A15,$A$3:$E$7,5,FALSE)","v":2000},{"$f":"I4","v":4},{"$f":"B15*C15","v":8000},{"$f":"H4","v":"2015-01-01"},{"$f":"IF(E15>0,(HLOOKUP(E15,$H$13:$AJ$14,2)),0)","v":5},null,{"$f":"IF(H$12>($F15+22),0,IF(H$12<$F15,0,IF(H$12=$F15,$D15,IF(H$12>$F15,G15))))","v":0},{"$f":"IF(I$12>($F15+22),0,IF(I$12<$F15,0,IF(I$12=$F15,$D15,IF(I$12>$F15,H15))))","v":0},0,0,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,0,0]
["Stationaries ",{"$f":"VLOOKUP(A16,$A$3:$E$7,5,FALSE)","v":2000},{"$f":"C15","v":4},{"$f":"B16*C16","v":8000},{"$f":"E15","v":"2015-01-01"},{"$f":"IF(E16>0,(HLOOKUP(E16,$H$13:$AJ$14,2)),0)","v":5},null,{"$f":"IF(H$12>($F16+22),0,IF(H$12<$F16,0,IF(H$12=$F16,$D16,IF(H$12>$F16,G16))))","v":0},0,0,0,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,0,0]
["Gas",320,{"$f":"C16","v":4},{"$f":"B17*C17","v":1280},{"$f":"E16","v":"2015-01-01"},5,null,{"$f":"IF(H$12>($F17+22),0,IF(H$12<$F17,0,IF(H$12=$F17,$D17,IF(H$12>$F17,G17))))","v":0},0,0,0,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,1280,0,0]
["Milk",120,4,480,"2015-01-01",5,null,{"$f":"IF(H$12>($F18+22),0,IF(H$12<$F18,0,IF(H$12=$F18,$D18,IF(H$12>$F18,G18))))","v":0},0,0,0,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,0,0]
["Toiletries ",100,4,400,"2015-01-01",5,null,{"$f":"IF(H$12>($F19+22),0,IF(H$12<$F19,0,IF(H$12=$F19,$D19,IF(H$12>$F19,G19))))","v":0},0,0,0,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F20+22),0,IF(H$12<$F20,0,IF(H$12=$F20,$D20,IF(H$12>$F20,G20))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B21*C21","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$12>($F21+22),0,IF(H$12<$F21,0,IF(H$12=$F21,$D21,IF(H$12>$F21,G21))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(E22>0,(HLOOKUP(E22,$H$13:$AJ$14,2)),0)","v":0},null,{"$f":"IF(H$12>($F22+22),0,IF(H$12<$F22,0,IF(H$12=$F22,$D22,IF(H$12>$F22,G22))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F23+22),0,IF(H$12<$F23,0,IF(H$12=$F23,$D23,IF(H$12>$F23,G23))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F24+22),0,IF(H$12<$F24,0,IF(H$12=$F24,$D24,IF(H$12>$F24,G24))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F25+22),0,IF(H$12<$F25,0,IF(H$12=$F25,$D25,IF(H$12>$F25,G25))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Print Materials",2000,{"$f":"I5","v":8},16000,{"$f":"H5","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F26+22),0,IF(H$12<$F26,0,IF(H$12=$F26,$D26,IF(H$12>$F26,G26))))","v":0},0,0,0,0,0,0,0,0,0,0,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000]
["Stationaries ",2000,{"$f":"C26","v":8},16000,{"$f":"E26","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F27+22),0,IF(H$12<$F27,0,IF(H$12=$F27,$D27,IF(H$12>$F27,G27))))","v":0},0,0,0,0,0,0,0,0,0,0,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000]
["Gas",320,{"$f":"C27","v":8},2560,{"$f":"E27","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F28+22),0,IF(H$12<$F28,0,IF(H$12=$F28,$D28,IF(H$12>$F28,G28))))","v":0},0,0,0,0,0,0,0,0,0,0,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560,2560]
["Milk",120,{"$f":"C28","v":8},960,{"$f":"E28","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F29+22),0,IF(H$12<$F29,0,IF(H$12=$F29,$D29,IF(H$12>$F29,G29))))","v":0},0,0,0,0,0,0,0,0,0,0,960,960,960,960,960,960,960,960,960,960,960,960,960,960,960,960,960,960]
["Toiletries ",100,{"$f":"C29","v":8},800,{"$f":"E29","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F30+22),0,IF(H$12<$F30,0,IF(H$12=$F30,$D30,IF(H$12>$F30,G30))))","v":0},0,0,0,0,0,0,0,0,0,0,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F31+22),0,IF(H$12<$F31,0,IF(H$12=$F31,$D31,IF(H$12>$F31,G31))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F32+22),0,IF(H$12<$F32,0,IF(H$12=$F32,$D32,IF(H$12>$F32,G32))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F33+22),0,IF(H$12<$F33,0,IF(H$12=$F33,$D33,IF(H$12>$F33,G33))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F34+22),0,IF(H$12<$F34,0,IF(H$12=$F34,$D34,IF(H$12>$F34,G34))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F35+22),0,IF(H$12<$F35,0,IF(H$12=$F35,$D35,IF(H$12>$F35,G35))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F36+22),0,IF(H$12<$F36,0,IF(H$12=$F36,$D36,IF(H$12>$F36,G36))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Print Materials",2000,{"$f":"I6","v":10},20000,{"$f":"H6","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F37+22),0,IF(H$12<$F37,0,IF(H$12=$F37,$D37,IF(H$12>$F37,G37))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20000,20000,20000,20000,20000,20000]
["Stationaries ",2000,{"$f":"C37","v":10},20000,{"$f":"E37","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F38+22),0,IF(H$12<$F38,0,IF(H$12=$F38,$D38,IF(H$12>$F38,G38))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20000,20000,20000,20000,20000,20000]
["Gas",320,{"$f":"C38","v":10},3200,{"$f":"E38","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F39+22),0,IF(H$12<$F39,0,IF(H$12=$F39,$D39,IF(H$12>$F39,G39))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3200,3200,3200,3200,3200,3200]
["Milk",120,10,1200,{"$f":"E39","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F40+22),0,IF(H$12<$F40,0,IF(H$12=$F40,$D40,IF(H$12>$F40,G40))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1200,1200,1200,1200,1200,1200]
["Toiletries ",100,10,1000,"2016-08-01",24,null,{"$f":"IF(H$12>($F41+22),0,IF(H$12<$F41,0,IF(H$12=$F41,$D41,IF(H$12>$F41,G41))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,1000,1000,1000,1000,1000]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F42+22),0,IF(H$12<$F42,0,IF(H$12=$F42,$D42,IF(H$12>$F42,G42))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F43+22),0,IF(H$12<$F43,0,IF(H$12=$F43,$D43,IF(H$12>$F43,G43))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F44+22),0,IF(H$12<$F44,0,IF(H$12=$F44,$D44,IF(H$12>$F44,G44))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F45+22),0,IF(H$12<$F45,0,IF(H$12=$F45,$D45,IF(H$12>$F45,G45))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F46+22),0,IF(H$12<$F46,0,IF(H$12=$F46,$D46,IF(H$12>$F46,G46))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F47+22),0,IF(H$12<$F47,0,IF(H$12=$F47,$D47,IF(H$12>$F47,G47))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F48+22),0,IF(H$12<$F48,0,IF(H$12=$F48,$D48,IF(H$12>$F48,G48))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H15:H48)","v":0},{"$f":"SUM(I15:I48)","v":0},0,0,{"$f":"SUM(L15:L48)","v":18160},18160,18160,18160,18160,18160,18160,54480,54480,54480,54480,54480,54480,54480,54480,54480,54480,54480,54480,99880,99880,99880,99880,81720,81720]

{"sheet":"Salaries","index":11,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Assumptions"]
[null,"Position","Salary"]
[null,"Core Team",25000]
[null,"BPO",17000,null,null,{"$f":"30000/24","v":1250}]
[null,"Media Analyst",8000]
[null,"Village Visionary",{"$f":"9000-F5","v":7750}]
[null,"Division Coord",25000]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Salary","# in Role","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Core Team",{"$f":"VLOOKUP(A15,$B$4:$C$8,2,FALSE)","v":25000},4,{"$f":"B15*C15","v":100000},"2014-12-01",{"$f":"IF(E15>0,(HLOOKUP(E15,$H$13:$AJ$14,2)),0)","v":4},null,{"$f":"IF(H$12<$F15,0,IF(H$12=$F15,$D15,IF(H$12>$F15,G15)))","v":0},0,0,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000]
["BPO",{"$f":"VLOOKUP(A16,$B$4:$C$8,2,FALSE)","v":17000},4,{"$f":"B16*C16","v":68000},"2014-12-01",{"$f":"IF(E16>0,(HLOOKUP(E16,$H$13:$AJ$14,2)),0)","v":4},null,{"$f":"IF(H$12<$F16,0,IF(H$12=$F16,$D16,IF(H$12>$F16,G16)))","v":0},0,0,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000,68000]
["Media Analyst",{"$f":"VLOOKUP(A17,$B$4:$C$8,2,FALSE)","v":8000},2,16000,"2014-12-01",4,null,{"$f":"IF(H$12<$F17,0,IF(H$12=$F17,$D17,IF(H$12>$F17,G17)))","v":0},0,0,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000,16000]
["Village Visionary",{"$f":"VLOOKUP(A18,$B$4:$C$8,2,FALSE)","v":7750},24,186000,"2015-02-01",6,null,{"$f":"IF(H$12<$F18,0,IF(H$12=$F18,$D18,IF(H$12>$F18,G18)))","v":0},0,0,0,0,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000,186000]
["BPO",{"$f":"VLOOKUP(A19,$B$4:$C$8,2,FALSE)","v":17000},8,136000,"2015-06-01",10,null,{"$f":"IF(H$12<$F19,0,IF(H$12=$F19,$D19,IF(H$12>$F19,G19)))","v":0},0,0,0,0,0,0,0,0,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000,136000]
["Village Visionary",{"$f":"VLOOKUP(A20,$B$4:$C$8,2,FALSE)","v":7750},48,372000,"2015-08-01",12,null,{"$f":"IF(H$12<$F20,0,IF(H$12=$F20,$D20,IF(H$12>$F20,G20)))","v":0},0,0,0,0,0,0,0,0,0,0,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000,372000]
["BPO",17000,10,170000,"2016-06-01",22,null,{"$f":"IF(H$12<$F21,0,IF(H$12=$F21,$D21,IF(H$12>$F21,G21)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,170000,170000,170000,170000,170000,170000,170000,170000]
["Village Visionary",7750,60,465000,"2016-08-01",24,null,{"$f":"IF(H$12<$F22,0,IF(H$12=$F22,$D22,IF(H$12>$F22,G22)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,465000,465000,465000,465000,465000,465000]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F23,0,IF(H$12=$F23,$D23,IF(H$12>$F23,G23)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F24,0,IF(H$12=$F24,$D24,IF(H$12>$F24,G24)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F25,0,IF(H$12=$F25,$D25,IF(H$12>$F25,G25)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F26,0,IF(H$12=$F26,$D26,IF(H$12>$F26,G26)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F27,0,IF(H$12=$F27,$D27,IF(H$12>$F27,G27)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F28,0,IF(H$12=$F28,$D28,IF(H$12>$F28,G28)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F29,0,IF(H$12=$F29,$D29,IF(H$12>$F29,G29)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F30,0,IF(H$12=$F30,$D30,IF(H$12>$F30,G30)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F31,0,IF(H$12=$F31,$D31,IF(H$12>$F31,G31)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F32,0,IF(H$12=$F32,$D32,IF(H$12>$F32,G32)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F33,0,IF(H$12=$F33,$D33,IF(H$12>$F33,G33)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F34,0,IF(H$12=$F34,$D34,IF(H$12>$F34,G34)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F35,0,IF(H$12=$F35,$D35,IF(H$12>$F35,G35)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F36,0,IF(H$12=$F36,$D36,IF(H$12>$F36,G36)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F37,0,IF(H$12=$F37,$D37,IF(H$12>$F37,G37)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F38,0,IF(H$12=$F38,$D38,IF(H$12>$F38,G38)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F39,0,IF(H$12=$F39,$D39,IF(H$12>$F39,G39)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F40,0,IF(H$12=$F40,$D40,IF(H$12>$F40,G40)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F41,0,IF(H$12=$F41,$D41,IF(H$12>$F41,G41)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F42,0,IF(H$12=$F42,$D42,IF(H$12>$F42,G42)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F43,0,IF(H$12=$F43,$D43,IF(H$12>$F43,G43)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F44,0,IF(H$12=$F44,$D44,IF(H$12>$F44,G44)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F45,0,IF(H$12=$F45,$D45,IF(H$12>$F45,G45)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F46,0,IF(H$12=$F46,$D46,IF(H$12>$F46,G46)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F47,0,IF(H$12=$F47,$D47,IF(H$12>$F47,G47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F48,0,IF(H$12=$F48,$D48,IF(H$12>$F48,G48)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H15:H48)","v":0},{"$f":"SUM(I15:I48)","v":0},0,184000,184000,370000,370000,370000,370000,506000,506000,878000,878000,878000,878000,878000,878000,878000,878000,878000,878000,1048000,1048000,1513000,1513000,1513000,1513000,1513000,1513000]

{"sheet":"Professional Services","index":12,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Service","Cost"]
["Legal",81000,{"$nulls":5},"Facility Start Dates","#"]
["Design",113000,{"$nulls":5},{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
[{"$nulls":7},{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
[{"$nulls":7},{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
[]
[]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Monthly Cost","Frequency","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Design",{"$f":"VLOOKUP(A15,$A$3:$B$4,2,FALSE)","v":113000},1,{"$f":"B15*C15","v":113000},"2014-10-01",{"$f":"IF(E15>0,(HLOOKUP(E15,$H$13:$AJ$14,2)),0)","v":2},null,{"$f":"IF(H$12<$F15,0,IF(H$12=$F15,$D15,0))","v":0},{"$f":"IF(I$12<$F15,0,IF(I$12=$F15,$D15,0))","v":113000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Y$12<$F15,0,IF(Y$12=$F15,$D15,0))","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Legal",{"$f":"VLOOKUP(A16,$A$3:$B$4,2,FALSE)","v":81000},{"$f":"C15","v":1},{"$f":"B16*C16","v":81000},"2014-09-01",{"$f":"IF(E16>0,(HLOOKUP(E16,$H$13:$AJ$14,2)),0)","v":1},null,{"$f":"IF(H$12<$F16,0,IF(H$12=$F16,$D16,0))","v":81000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C16","v":1},{"$f":"B17*C17","v":{"$error":"#N/A"}},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},1,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B21*C21","v":{"$error":"#N/A"}},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(E22>0,(HLOOKUP(E22,$H$13:$AJ$14,2)),0)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"I5","v":8},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C26","v":8},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C27","v":8},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C28","v":8},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C29","v":8},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(X$12<$F30,0,IF(X$12=$F30,$D30,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12<$F32,0,IF(H$12=$F32,$D32,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"I6","v":10},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C37","v":10},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C38","v":10},{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},10,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},10,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(X$12<$F46,0,IF(X$12=$F46,$D46,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(W$12<$F47,0,IF(W$12=$F47,$D47,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F48,0,IF(H$12=$F48,$D48,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H15:H48)","v":81000},{"$f":"SUM(I15:I48)","v":113000},0,0,{"$f":"SUM(L15:L48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Rent","index":13,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Item","Item Cost","Monthly Cost Per Facility"]
["Rent",5000,{"$f":"B3","v":5000},{"$nulls":4},"Facility Start Dates","#"]
["Electricity",1000,{"$f":"B4","v":1000},{"$nulls":4},{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
[{"$nulls":7},{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
[{"$nulls":7},{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
[]
[]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Monthly Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Rent",{"$f":"VLOOKUP(A15,$A$3:$C$4,3,FALSE)","v":5000},{"$f":"I4","v":4},{"$f":"B15*C15","v":20000},{"$f":"H4","v":"2015-01-01"},{"$f":"IF(E15>0,(HLOOKUP(E15,$H$13:$AJ$14,2)),0)","v":5},null,{"$f":"IF(H$12>($F15+22),0,IF(H$12<$F15,0,IF(H$12=$F15,$D15,IF(H$12>$F15,G15))))","v":0},{"$f":"IF(I$12>($F15+22),0,IF(I$12<$F15,0,IF(I$12=$F15,$D15,IF(I$12>$F15,H15))))","v":0},0,0,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,0,0]
["Electricity",{"$f":"VLOOKUP(A16,$A$3:$C$4,3,FALSE)","v":1000},{"$f":"C15","v":4},{"$f":"B16*C16","v":4000},{"$f":"E15","v":"2015-01-01"},{"$f":"IF(E16>0,(HLOOKUP(E16,$H$13:$AJ$14,2)),0)","v":5},null,{"$f":"IF(H$12>($F16+22),0,IF(H$12<$F16,0,IF(H$12=$F16,$D16,IF(H$12>$F16,G16))))","v":0},0,0,0,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,0,0]
[null,{"$error":"#N/A"},{"$f":"C16","v":4},{"$f":"B17*C17","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(H$12>($F17+22),0,IF(H$12<$F17,0,IF(H$12=$F17,$D17,IF(H$12>$F17,G17))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$f":"IF(H$12>($F18+22),0,IF(H$12<$F18,0,IF(H$12=$F18,$D18,IF(H$12>$F18,G18))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},0,{"$error":"#N/A"},null,{"$f":"IF(E19>0,(HLOOKUP(E19,$H$13:$AJ$14,2)),0)","v":0},null,{"$f":"IF(H$12>($F19+22),0,IF(H$12<$F19,0,IF(H$12=$F19,$D19,IF(H$12>$F19,G19))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F20+22),0,IF(H$12<$F20,0,IF(H$12=$F20,$D20,IF(H$12>$F20,G20))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B21*C21","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$12>($F21+22),0,IF(H$12<$F21,0,IF(H$12=$F21,$D21,IF(H$12>$F21,G21))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(E22>0,(HLOOKUP(E22,$H$13:$AJ$14,2)),0)","v":0},null,{"$f":"IF(H$12>($F22+22),0,IF(H$12<$F22,0,IF(H$12=$F22,$D22,IF(H$12>$F22,G22))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F23+22),0,IF(H$12<$F23,0,IF(H$12=$F23,$D23,IF(H$12>$F23,G23))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F24+22),0,IF(H$12<$F24,0,IF(H$12=$F24,$D24,IF(H$12>$F24,G24))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F25+22),0,IF(H$12<$F25,0,IF(H$12=$F25,$D25,IF(H$12>$F25,G25))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rent",5000,{"$f":"I5","v":8},40000,{"$f":"H5","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F26+22),0,IF(H$12<$F26,0,IF(H$12=$F26,$D26,IF(H$12>$F26,G26))))","v":0},0,0,0,0,0,0,0,0,0,0,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000]
["Electricity",1000,{"$f":"C26","v":8},8000,{"$f":"E26","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F27+22),0,IF(H$12<$F27,0,IF(H$12=$F27,$D27,IF(H$12>$F27,G27))))","v":0},0,0,0,0,0,0,0,0,0,0,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000]
[null,{"$error":"#N/A"},{"$f":"C27","v":8},{"$error":"#N/A"},null,null,null,{"$f":"IF(H$12>($F28+22),0,IF(H$12<$F28,0,IF(H$12=$F28,$D28,IF(H$12>$F28,G28))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C28","v":8},{"$error":"#N/A"},null,{"$f":"IF(E29>0,(HLOOKUP(E29,$H$13:$AJ$14,2)),0)","v":0},null,{"$f":"IF(H$12>($F29+22),0,IF(H$12<$F29,0,IF(H$12=$F29,$D29,IF(H$12>$F29,G29))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C29","v":8},{"$error":"#N/A"},null,{"$f":"IF(E30>0,(HLOOKUP(E30,$H$13:$AJ$14,2)),0)","v":0},null,{"$f":"IF(H$12>($F30+22),0,IF(H$12<$F30,0,IF(H$12=$F30,$D30,IF(H$12>$F30,G30))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F31+22),0,IF(H$12<$F31,0,IF(H$12=$F31,$D31,IF(H$12>$F31,G31))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F32+22),0,IF(H$12<$F32,0,IF(H$12=$F32,$D32,IF(H$12>$F32,G32))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F33+22),0,IF(H$12<$F33,0,IF(H$12=$F33,$D33,IF(H$12>$F33,G33))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F34+22),0,IF(H$12<$F34,0,IF(H$12=$F34,$D34,IF(H$12>$F34,G34))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F35+22),0,IF(H$12<$F35,0,IF(H$12=$F35,$D35,IF(H$12>$F35,G35))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F36+22),0,IF(H$12<$F36,0,IF(H$12=$F36,$D36,IF(H$12>$F36,G36))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rent",5000,{"$f":"I6","v":10},50000,{"$f":"H6","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F37+22),0,IF(H$12<$F37,0,IF(H$12=$F37,$D37,IF(H$12>$F37,G37))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50000,50000,50000,50000,50000,50000]
["Electricity",1000,{"$f":"C37","v":10},10000,{"$f":"E37","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F38+22),0,IF(H$12<$F38,0,IF(H$12=$F38,$D38,IF(H$12>$F38,G38))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10000,10000,10000,10000,10000,10000]
[null,{"$error":"#N/A"},{"$f":"C38","v":10},{"$error":"#N/A"},null,null,null,{"$f":"IF(H$12>($F39+22),0,IF(H$12<$F39,0,IF(H$12=$F39,$D39,IF(H$12>$F39,G39))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},10,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F40+22),0,IF(H$12<$F40,0,IF(H$12=$F40,$D40,IF(H$12>$F40,G40))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},10,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F41+22),0,IF(H$12<$F41,0,IF(H$12=$F41,$D41,IF(H$12>$F41,G41))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F42+22),0,IF(H$12<$F42,0,IF(H$12=$F42,$D42,IF(H$12>$F42,G42))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F43+22),0,IF(H$12<$F43,0,IF(H$12=$F43,$D43,IF(H$12>$F43,G43))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F44+22),0,IF(H$12<$F44,0,IF(H$12=$F44,$D44,IF(H$12>$F44,G44))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F45+22),0,IF(H$12<$F45,0,IF(H$12=$F45,$D45,IF(H$12>$F45,G45))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F46+22),0,IF(H$12<$F46,0,IF(H$12=$F46,$D46,IF(H$12>$F46,G46))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F47+22),0,IF(H$12<$F47,0,IF(H$12=$F47,$D47,IF(H$12>$F47,G47))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F48+22),0,IF(H$12<$F48,0,IF(H$12=$F48,$D48,IF(H$12>$F48,G48))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H15:H48)","v":0},{"$f":"SUM(I15:I48)","v":0},0,0,24000,24000,24000,24000,24000,24000,24000,72000,72000,72000,72000,72000,72000,72000,72000,72000,72000,72000,72000,{"$f":"SUM(AE15:AE48)","v":132000},132000,132000,132000,108000,108000]

{"sheet":"Telephone & Internet","index":14,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Item","Item Cost","# of People","# of Items","Monthly Cost Per Facility"]
["Phone Credit",100,7,1,{"$f":"D3*C3*B3","v":700},null,null,"Facility Start Dates","#"]
["Data Credit ",450,7,1,{"$f":"D4*C4*B4","v":3150},null,null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
["Internet",1200,1,null,{"$f":"B5","v":1200},null,null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
[{"$nulls":7},{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
[]
[]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Monthly Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Phone Credit",{"$f":"VLOOKUP(A15,$A$3:$E$7,5,FALSE)","v":700},{"$f":"I4","v":4},{"$f":"B15*C15","v":2800},{"$f":"H4","v":"2015-01-01"},{"$f":"IF(E15>0,(HLOOKUP(E15,$H$13:$AJ$14,2)),0)","v":5},null,{"$f":"IF(H$12>($F15+22),0,IF(H$12<$F15,0,IF(H$12=$F15,$D15,IF(H$12>$F15,G15))))","v":0},{"$f":"IF(I$12>($F15+22),0,IF(I$12<$F15,0,IF(I$12=$F15,$D15,IF(I$12>$F15,H15))))","v":0},0,0,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,2800,0,0]
["Data Credit ",{"$f":"VLOOKUP(A16,$A$3:$E$7,5,FALSE)","v":3150},{"$f":"C15","v":4},{"$f":"B16*C16","v":12600},{"$f":"E15","v":"2015-01-01"},{"$f":"IF(E16>0,(HLOOKUP(E16,$H$13:$AJ$14,2)),0)","v":5},null,{"$f":"IF(H$12>($F16+22),0,IF(H$12<$F16,0,IF(H$12=$F16,$D16,IF(H$12>$F16,G16))))","v":0},0,0,0,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,0,0]
["Internet",1200,{"$f":"C16","v":4},{"$f":"B17*C17","v":4800},{"$f":"E16","v":"2015-01-01"},5,null,{"$f":"IF(H$12>($F17+22),0,IF(H$12<$F17,0,IF(H$12=$F17,$D17,IF(H$12>$F17,G17))))","v":0},0,0,0,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,4800,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,null,null,{"$f":"IF(H$12>($F18+22),0,IF(H$12<$F18,0,IF(H$12=$F18,$D18,IF(H$12>$F18,G18))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},0,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F19+22),0,IF(H$12<$F19,0,IF(H$12=$F19,$D19,IF(H$12>$F19,G19))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F20+22),0,IF(H$12<$F20,0,IF(H$12=$F20,$D20,IF(H$12>$F20,G20))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B21*C21","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$12>($F21+22),0,IF(H$12<$F21,0,IF(H$12=$F21,$D21,IF(H$12>$F21,G21))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$f":"IF(E22>0,(HLOOKUP(E22,$H$13:$AJ$14,2)),0)","v":0},null,{"$f":"IF(H$12>($F22+22),0,IF(H$12<$F22,0,IF(H$12=$F22,$D22,IF(H$12>$F22,G22))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F23+22),0,IF(H$12<$F23,0,IF(H$12=$F23,$D23,IF(H$12>$F23,G23))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F24+22),0,IF(H$12<$F24,0,IF(H$12=$F24,$D24,IF(H$12>$F24,G24))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F25+22),0,IF(H$12<$F25,0,IF(H$12=$F25,$D25,IF(H$12>$F25,G25))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Phone Credit",700,{"$f":"I5","v":8},5600,{"$f":"H5","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F26+22),0,IF(H$12<$F26,0,IF(H$12=$F26,$D26,IF(H$12>$F26,G26))))","v":0},0,0,0,0,0,0,0,0,0,0,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600,5600]
["Data Credit ",3150,{"$f":"C26","v":8},25200,{"$f":"E26","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F27+22),0,IF(H$12<$F27,0,IF(H$12=$F27,$D27,IF(H$12>$F27,G27))))","v":0},0,0,0,0,0,0,0,0,0,0,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200,25200]
["Internet",1200,{"$f":"C27","v":8},9600,{"$f":"E27","v":"2015-08-01"},12,null,{"$f":"IF(H$12>($F28+22),0,IF(H$12<$F28,0,IF(H$12=$F28,$D28,IF(H$12>$F28,G28))))","v":0},0,0,0,0,0,0,0,0,0,0,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600,9600]
[null,{"$error":"#N/A"},{"$f":"C28","v":8},{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F29+22),0,IF(H$12<$F29,0,IF(H$12=$F29,$D29,IF(H$12>$F29,G29))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"C29","v":8},{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F30+22),0,IF(H$12<$F30,0,IF(H$12=$F30,$D30,IF(H$12>$F30,G30))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F31+22),0,IF(H$12<$F31,0,IF(H$12=$F31,$D31,IF(H$12>$F31,G31))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F32+22),0,IF(H$12<$F32,0,IF(H$12=$F32,$D32,IF(H$12>$F32,G32))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F33+22),0,IF(H$12<$F33,0,IF(H$12=$F33,$D33,IF(H$12>$F33,G33))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F34+22),0,IF(H$12<$F34,0,IF(H$12=$F34,$D34,IF(H$12>$F34,G34))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F35+22),0,IF(H$12<$F35,0,IF(H$12=$F35,$D35,IF(H$12>$F35,G35))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F36+22),0,IF(H$12<$F36,0,IF(H$12=$F36,$D36,IF(H$12>$F36,G36))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Phone Credit",700,{"$f":"I6","v":10},7000,{"$f":"H6","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F37+22),0,IF(H$12<$F37,0,IF(H$12=$F37,$D37,IF(H$12>$F37,G37))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7000,7000,7000,7000,7000,7000]
["Data Credit ",3150,{"$f":"C37","v":10},31500,{"$f":"E37","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F38+22),0,IF(H$12<$F38,0,IF(H$12=$F38,$D38,IF(H$12>$F38,G38))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31500,31500,31500,31500,31500,31500]
["Internet",1200,{"$f":"C38","v":10},12000,{"$f":"E38","v":"2016-08-01"},24,null,{"$f":"IF(H$12>($F39+22),0,IF(H$12<$F39,0,IF(H$12=$F39,$D39,IF(H$12>$F39,G39))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12000,12000,12000,12000,12000,12000]
[null,{"$error":"#N/A"},10,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F40+22),0,IF(H$12<$F40,0,IF(H$12=$F40,$D40,IF(H$12>$F40,G40))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},10,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F41+22),0,IF(H$12<$F41,0,IF(H$12=$F41,$D41,IF(H$12>$F41,G41))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F42+22),0,IF(H$12<$F42,0,IF(H$12=$F42,$D42,IF(H$12>$F42,G42))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F43+22),0,IF(H$12<$F43,0,IF(H$12=$F43,$D43,IF(H$12>$F43,G43))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F44+22),0,IF(H$12<$F44,0,IF(H$12=$F44,$D44,IF(H$12>$F44,G44))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$12>($F45+22),0,IF(H$12<$F45,0,IF(H$12=$F45,$D45,IF(H$12>$F45,G45))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F46+22),0,IF(H$12<$F46,0,IF(H$12=$F46,$D46,IF(H$12>$F46,G46))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F47+22),0,IF(H$12<$F47,0,IF(H$12=$F47,$D47,IF(H$12>$F47,G47))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12>($F48+22),0,IF(H$12<$F48,0,IF(H$12=$F48,$D48,IF(H$12>$F48,G48))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H15:H48)","v":0},{"$f":"SUM(I15:I48)","v":0},0,0,20200,20200,20200,20200,20200,20200,20200,60600,60600,60600,60600,60600,60600,60600,60600,60600,60600,60600,60600,{"$f":"SUM(AE15:AE48)","v":111100},111100,111100,111100,90900,90900]

{"sheet":"Travel","index":15,"n_rows":59,"n_cols":36,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
["Item","Cost","Cost Per Facility per month",null,"Facility Start Dates","#"]
["Project Leader Fuel",{"$f":"'Travel Assumptions'!I8","v":398.76923076923077},{"$f":"'Travel Assumptions'!K8","v":398.76923076923077},null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
["Village Visonary Fuel",{"$f":"'Travel Assumptions'!I9","v":265.84615384615387},{"$f":"'Travel Assumptions'!K9","v":1595.0769230769233},null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
["Field Visits*",{"$f":"'Travel Assumptions'!G20","v":1250},{"$f":"B6","v":1250},null,{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
["Training Travel*",{"$f":"'Travel Assumptions'!J42","v":2951.666666666667},{"$f":"B7","v":2951.666666666667}]
["Tribe Trips",{"$f":"'Travel Assumptions'!F52","v":22925},{"$f":"'Travel Assumptions'!G52","v":11462.5}]
[]
["Conference Travel*",{"$f":"'Travel Assumptions'!F31","v":9825},{"$f":"'Travel Assumptions'!G31","v":4912.5}]
[]
[]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
["Batch 1",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Project Leader Fuel",{"$f":"VLOOKUP(A19,$A$4:$C$10,3,FALSE)","v":398.76923076923077},{"$f":"F4","v":4},{"$f":"B19*C19","v":1595.0769230769231},{"$f":"E4","v":"2015-01-01"},{"$f":"IF(E19>0,(HLOOKUP(E19,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(H$16>($F19+22),0,IF(H$16<$F19,0,IF(H$16=$F19,$D19,IF(H$16>$F19,G19))))","v":0},{"$f":"IF(I$16>($F19+22),0,IF(I$16<$F19,0,IF(I$16=$F19,$D19,IF(I$16>$F19,H19))))","v":0},0,0,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,1595.0769230769231,0,0]
["Village Visonary Fuel",{"$f":"VLOOKUP(A20,$A$4:$C$10,3,FALSE)","v":1595.0769230769233},{"$f":"C19","v":4},6380.3076923076933,{"$f":"E19","v":"2015-01-01"},{"$f":"IF(E20>0,(HLOOKUP(E20,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(H$16>($F20+22),0,IF(H$16<$F20,0,IF(H$16=$F20,$D20,IF(H$16>$F20,G20))))","v":0},0,0,0,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,6380.3076923076933,0,0]
["Field Visits*",1250,{"$f":"C20","v":4},5000,{"$f":"E20","v":"2015-01-01"},5,null,{"$f":"IF(H$16>($F21+22),0,IF(H$16<$F21,0,IF(H$16=$F21,$D21,IF(H$16>$F21,G21))))","v":0},0,0,0,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,0,0]
["Training Travel*",2951.666666666667,4,11806.666666666668,"2015-01-01",5,null,{"$f":"IF(H$16>($F22+22),0,IF(H$16<$F22,0,IF(H$16=$F22,$D22,IF(H$16>$F22,G22))))","v":0},0,0,0,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,11806.666666666668,0,0]
["Tribe Trips",11462.5,4,45850,"2015-01-01",5,null,{"$f":"IF(H$16>($F23+22),0,IF(H$16<$F23,0,IF(H$16=$F23,$D23,IF(H$16>$F23,G23))))","v":0},0,0,0,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,45850,0,0]
[null,null,4,0,"2015-01-01",5,null,{"$f":"IF(H$16>($F24+22),0,IF(H$16<$F24,0,IF(H$16=$F24,$D24,IF(H$16>$F24,G24))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Conference Travel*",{"$f":"VLOOKUP(A25,$A$4:$C$10,3,FALSE)","v":4912.5},1,4912.5,"2015-01-01",5,null,{"$f":"IF(H$16<$F25,0,IF(H$16=$F25,$D25,IF(H$16>$F25,G25)))","v":0},0,0,0,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5]
[null,null,1,{"$f":"B26*C26","v":0},"2015-01-01",5,null,{"$f":"IF(H$16<$F26,0,IF(H$16=$F26,$D26,IF(H$16>$F26,G26)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16<$F27,0,IF(H$16=$F27,$D27,IF(H$16>$F27,G27)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B28*C28","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16<$F28,0,IF(H$16=$F28,$D28,IF(H$16>$F28,G28)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B29*C29","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16<$F29,0,IF(H$16=$F29,$D29,IF(H$16>$F29,G29)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"}]
["Batch 2",{"$error":"#N/A"},null,{"$f":"B31*C31","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16<$F31,0,IF(H$16=$F31,$D31,IF(H$16>$F31,G31)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Project Leader Fuel",398.76923076923077,{"$f":"F5","v":8},3190.1538461538462,{"$f":"E5","v":"2015-08-01"},12,null,{"$f":"IF(H$16<$F32,0,IF(H$16=$F32,$D32,IF(H$16>$F32,G32)))","v":0},0,0,0,0,0,0,0,0,0,0,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462,3190.1538461538462]
["Village Visonary Fuel",1595.0769230769233,{"$f":"C32","v":8},12760.615384615387,{"$f":"E32","v":"2015-08-01"},12,null,{"$f":"IF(H$16<$F33,0,IF(H$16=$F33,$D33,IF(H$16>$F33,G33)))","v":0},0,0,0,0,0,0,0,0,0,0,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387,12760.615384615387]
["Field Visits*",1250,{"$f":"C33","v":8},10000,{"$f":"E33","v":"2015-08-01"},12,null,{"$f":"IF(H$16<$F34,0,IF(H$16=$F34,$D34,IF(H$16>$F34,G34)))","v":0},0,0,0,0,0,0,0,0,0,0,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
["Training Travel*",2951.666666666667,8,23613.333333333336,"2015-08-01",12,null,{"$f":"IF(H$16<$F35,0,IF(H$16=$F35,$D35,IF(H$16>$F35,G35)))","v":0},0,0,0,0,0,0,0,0,0,0,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336,23613.333333333336]
["Tribe Trips",11462.5,1,11462.5,"2015-08-01",12,null,{"$f":"IF(H$16<$F36,0,IF(H$16=$F36,$D36,IF(H$16>$F36,G36)))","v":0},0,0,0,0,0,0,0,0,0,0,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5]
[null,null,1,0,"2015-08-01",12,null,{"$f":"IF(H$16<$F37,0,IF(H$16=$F37,$D37,IF(H$16>$F37,G37)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Conference Travel*",4912.5,1,4912.5,"2015-08-01",12,null,{"$f":"IF(H$16<$F38,0,IF(H$16=$F38,$D38,IF(H$16>$F38,G38)))","v":0},0,0,0,0,0,0,0,0,0,0,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5]
[null,null,null,0,"2015-08-01",12,null,{"$f":"IF(H$16<$F39,0,IF(H$16=$F39,$D39,IF(H$16>$F39,G39)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,"2015-08-01",12,null,{"$f":"IF(H$16<$F40,0,IF(H$16=$F40,$D40,IF(H$16>$F40,G40)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,"2015-08-01",12,null,{"$f":"IF(H$16<$F41,0,IF(H$16=$F41,$D41,IF(H$16>$F41,G41)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16<$F42,0,IF(H$16=$F42,$D42,IF(H$16>$F42,G42)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16<$F43,0,IF(H$16=$F43,$D43,IF(H$16>$F43,G43)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 3",{"$error":"#N/A"},null,{"$error":"#N/A"},null,0,null,{"$f":"IF(H$16<$F44,0,IF(H$16=$F44,$D44,IF(H$16>$F44,G44)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Project Leader Fuel",398.76923076923077,{"$f":"F6","v":10},3987.6923076923076,{"$f":"E6","v":"2016-08-01"},24,null,{"$f":"IF(H$16<$F45,0,IF(H$16=$F45,$D45,IF(H$16>$F45,G45)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3987.6923076923076,3987.6923076923076,3987.6923076923076,3987.6923076923076,3987.6923076923076,3987.6923076923076]
["Village Visonary Fuel",1595.0769230769233,{"$f":"C45","v":10},{"$f":"B46*C46","v":15950.769230769234},{"$f":"E45","v":"2016-08-01"},24,null,{"$f":"IF(H$16<$F46,0,IF(H$16=$F46,$D46,IF(H$16>$F46,G46)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15950.769230769234,15950.769230769234,15950.769230769234,15950.769230769234,15950.769230769234,15950.769230769234]
["Field Visits*",1250,{"$f":"C46","v":10},12500,{"$f":"E46","v":"2016-08-01"},24,null,{"$f":"IF(H$16<$F47,0,IF(H$16=$F47,$D47,IF(H$16>$F47,G47)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12500,12500,12500,12500,12500,12500]
["Training Travel*",2951.666666666667,10,29516.666666666672,{"$f":"E47","v":"2016-08-01"},24,null,{"$f":"IF(H$16<$F48,0,IF(H$16=$F48,$D48,IF(H$16>$F48,G48)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29516.666666666672,29516.666666666672,29516.666666666672,29516.666666666672,29516.666666666672,29516.666666666672]
["Tribe Trips",11462.5,1,11462.5,"2016-08-01",24,null,{"$f":"IF(H$16<$F49,0,IF(H$16=$F49,$D49,IF(H$16>$F49,G49)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11462.5,11462.5,11462.5,11462.5,11462.5,11462.5]
[null,null,null,0,"2016-08-01",24,null,{"$f":"IF(H$16<$F50,0,IF(H$16=$F50,$D50,IF(H$16>$F50,G50)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Conference Travel*",4912.5,{"$f":"C49","v":1},4912.5,"2016-08-01",24,null,{"$f":"IF(H$16<$F51,0,IF(H$16=$F51,$D51,IF(H$16>$F51,G51)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4912.5,4912.5,4912.5,4912.5,4912.5,4912.5]
[null,null,null,0,"2016-08-01",24,null,{"$f":"IF(H$16<$F52,0,IF(H$16=$F52,$D52,IF(H$16>$F52,G52)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,"2016-08-01",24,null,{"$f":"IF(H$16<$F53,0,IF(H$16=$F53,$D53,IF(H$16>$F53,G53)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"B54*C54","v":0},"2016-08-01",24,null,{"$f":"IF(H$16<$F54,0,IF(H$16=$F54,$D54,IF(H$16>$F54,G54)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},null,{"$f":"B55*C55","v":{"$error":"#N/A"}},null,0,null,{"$f":"IF(H$16<$F55,0,IF(H$16=$F55,$D55,IF(H$16>$F55,G55)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16<$F56,0,IF(H$16=$F56,$D56,IF(H$16>$F56,G56)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16<$F57,0,IF(H$16=$F57,$D57,IF(H$16>$F57,G57)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$nulls":5},{"$f":"IF(H$16<$F58,0,IF(H$16=$F58,$D58,IF(H$16>$F58,G58)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H19:H58)","v":0},{"$f":"SUM(I19:I58)","v":0},0,0,{"$f":"SUM(L19:L58)","v":75544.551282051281},75544.551282051281,75544.551282051281,75544.551282051281,75544.551282051281,75544.551282051281,75544.551282051281,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,141483.65384615384,219813.78205128206,219813.78205128206,219813.78205128206,219813.78205128206,149181.73076923078,149181.73076923078]

{"sheet":"Travel Assumptions","index":16,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Fuel Key*"]
[{"$nulls":5},"Fuel Efficiency (km/L)"]
[null,null,"Fuel Costs/Liter",null,"Distance Travelled Per Month",65,"# of Liters used Per Month","Months","Per Month Fuel Cost","Per Facility"]
[null,"PL",72,null,360,{"$f":"1/F7","v":1.5384615384615385E-2},{"$f":"E8*F8","v":5.5384615384615383},12,{"$f":"G8*C8","v":398.76923076923077},1,{"$f":"J8*I8","v":398.76923076923077}]
[null,"Village Visionary",72,null,240,{"$f":"1/F7","v":1.5384615384615385E-2},{"$f":"E9*F9","v":3.6923076923076925},12,{"$f":"G9*C9","v":265.84615384615387},6,{"$f":"J9*I9","v":1595.0769230769233}]
[]
[]
[]
[]
[null,"Field Visits Key*"]
[{"$nulls":4},"  "]
[null,"Item","Item Cost","# of People","# of Items","Monthly Cost (4 blocks)","Per 1 block"]
[null,"Inter District Travel",100,10,1,{"$f":"E17*D17*C17","v":1000}]
[null,"Bus to Field (Kishanganj",250,10,1,{"$f":"E18*D18*C18","v":2500},{"$nulls":4},9308256312]
[null,"Return Travel",150,10,1,{"$f":"E19*D19*C19","v":1500}]
[{"$nulls":4},"Total",{"$f":"F19+F18+F17","v":5000},{"$f":"F20/4","v":1250}]
[]
[]
[null,"Conference Trip Key*","3 days 2 nights"]
[]
[null,"Item","Item Cost","# of People","# of Items","Per Trip",".5 Trips/Month"]
[null,"Travel: 1 way^",1000,3,2,{"$f":"E26*D26*C26","v":6000},{"$f":"F26/2","v":3000}]
[null,"Accomodation: Hotel* ",300,3,2,{"$f":"E27*D27*C27","v":1800},{"$f":"F27/2","v":900}]
[null,"Food: Per meal per person'",75,3,9,{"$f":"E28*D28*C28","v":2025},1012.5]
[]
[]
[{"$nulls":4},"Total ",{"$f":"F28+F27+F26","v":9825},4912.5]
[]
[]
[]
[]
[null,"Training Travel*","4 days 3 nights"]
[null,"Item","Item Cost","# of People","# of Items","Per TrainingCost","Per Block","Trips per year","Per Year","Per Month"]
[null,"Travel: To and from Kishanganj to Patna",240,14,2,{"$f":"E38*D38*C38","v":6720},{"$f":"F38/2","v":3360},2,{"$f":"G38*H38","v":6720},{"$f":"I38/12","v":560}]
[null,"Travel: To and from place x to Patna",200,14,2,{"$f":"E39*D39*C39","v":5600},{"$f":"F39/2","v":2800},2,{"$f":"G39*H39","v":5600},{"$f":"I39/12","v":466.66666666666669}]
[null,"Food: Per meal per person",75,28,12,{"$f":"E40*D40*C40","v":25200},{"$f":"F40/4","v":6300},2,12600,1050]
[null,"Accomodation ",250,28,3,{"$f":"E41*D41*C41","v":21000},{"$f":"F41/4","v":5250},2,10500,875]
[{"$nulls":8},"Total",{"$f":"SUM(J38:J41)","v":2951.666666666667}]
[]
[]
[]
[null,"Item","Item Cost","# of People","# of Items","Per Trip",".5 Trips/Month"]
[null,"Travel: 1 way^",1000,7,2,{"$f":"E47*D47*C47","v":14000},{"$f":"F47/2","v":7000}]
[null,"Accomodation: Hotel* ",300,7,2,{"$f":"E48*D48*C48","v":4200},{"$f":"F48/2","v":2100}]
[null,"Food: Per meal per person'",75,7,9,{"$f":"E49*D49*C49","v":4725},2362.5]
[]
[]
[{"$nulls":4},"Total ",{"$f":"F49+F48+F47","v":22925},11462.5]

{"sheet":"Furniture & Equipment","index":17,"n_rows":59,"n_cols":36,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions"]
["Item","Cost","# Per Facility","Cost Per Facility",null,"Facility Start Dates","#"]
["Inverter",12500,1,{"$f":"C4*B4","v":12500},null,{"$f":"Assumptions!B4","v":"2015-01-01"},{"$f":"Assumptions!C4","v":4}]
["Battery",12500,1,{"$f":"C5*B5","v":12500},null,{"$f":"Assumptions!B5","v":"2015-08-01"},{"$f":"Assumptions!C5","v":8}]
["Filter",14000,1,14000,null,{"$f":"Assumptions!B6","v":"2016-08-01"},{"$f":"Assumptions!C6","v":10}]
["Mats",650,4,2600]
["Plastic Chairs",300,10,3000]
["Office table",4000,2,8000]
["Fans",2000,3,6000]
["Pillows",150,7,1050]
["Blanket",1000,4,4000]
["Phone",6000,7,42000]
["Motorcycle",30000,7,210000]
["Computer",20000,3,60000]
["T",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Cost","# of Facilities","Total","Start Date",null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
["Batch 1",{"$nulls":6},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Inverter",{"$f":"VLOOKUP(A19,$A$4:$D$14,4,FALSE)","v":12500},{"$f":"G4","v":4},{"$f":"B19*C19","v":50000},{"$f":"F4","v":"2015-01-01"},{"$f":"IF(E19>0,(HLOOKUP(E19,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(H$16<$F19,0,IF(H$16=$F19,$D19,0))","v":0},{"$f":"IF(I$16<$F19,0,IF(I$16=$F19,$D19,0))","v":0},0,0,50000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Battery",12500,{"$f":"C19","v":4},50000,{"$f":"E19","v":"2015-01-01"},{"$f":"IF(E20>0,(HLOOKUP(E20,$H$17:$AJ$18,2)),0)","v":5},null,{"$f":"IF(H$16<$F20,0,IF(H$16=$F20,$D20,0))","v":0},0,0,0,50000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Filter",14000,{"$f":"C20","v":4},56000,{"$f":"E20","v":"2015-01-01"},5,null,0,0,0,0,56000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Mats",2600,4,10400,"2015-01-01",5,null,0,0,0,0,10400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Plastic Chairs",3000,4,12000,"2015-01-01",5,null,0,0,0,0,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Office table",8000,4,32000,"2015-01-01",5,null,0,0,0,0,32000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fans",6000,4,24000,"2015-01-01",5,null,0,0,0,0,24000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Pillows",1050,4,4200,"2015-01-01",5,null,0,0,0,0,4200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Blanket",4000,4,16000,"2015-01-01",5,null,0,0,0,0,16000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Phone",42000,{"$f":"C27","v":4},168000,{"$f":"E27","v":"2015-01-01"},5,null,0,0,0,0,{"$f":"IF(L$16<$F28,0,IF(L$16=$F28,$D28,0))","v":168000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AB$16<$F28,0,IF(AB$16=$F28,$D28,0))","v":0},0,0,0,0,0,0,0,0]
["Motorcycle",210000,4,840000,"2015-01-01",5,null,0,0,0,0,840000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A15","v":"Computer"},{"$f":"VLOOKUP(A30,$A$4:$D$15,4,FALSE)","v":60000},4,240000,"2015-01-01",5,null,0,0,0,0,240000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 2",{"$f":"VLOOKUP(A31,$A$4:$D$14,4,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Inverter",12500,{"$f":"G5","v":8},100000,{"$f":"F5","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Battery",12500,{"$f":"C32","v":8},100000,{"$f":"E32","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Filter",14000,{"$f":"C33","v":8},112000,{"$f":"E33","v":"2015-08-01"},12,null,0,0,0,0,0,0,0,0,0,0,0,112000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Mats",2600,8,20800,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,20800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Plastic Chairs",3000,8,24000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,24000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Office table",8000,8,64000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,64000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Fans",6000,8,48000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,48000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Pillows",1050,8,8400,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,8400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Blanket",4000,8,32000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,32000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Phone",42000,8,336000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,336000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Motorcycle",210000,8,1680000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,1680000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A28","v":"Phone"},{"$f":"VLOOKUP(A43,$A$4:$D$15,4,FALSE)","v":42000},8,336000,"2015-08-01",12,null,0,0,0,0,0,0,0,0,0,0,0,336000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Batch 3",{"$f":"VLOOKUP(A44,$A$4:$D$14,4,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,0,null,0,0,0,0,0,0,{"$f":"IF(N$16<$F44,0,IF(N$16=$F44,$D44,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Inverter",12500,{"$f":"G6","v":10},125000,{"$f":"F6","v":"2016-08-01"},24,null,{"$f":"IF(H$16<$F45,0,IF(H$16=$F45,$D45,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,125000,0,0,0,0,0]
["Battery",12500,{"$f":"C45","v":10},{"$f":"B46*C46","v":125000},{"$f":"E45","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,125000,0,0,0,0,0]
["Filter",14000,{"$f":"C46","v":10},140000,{"$f":"E46","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,140000,0,0,0,0,0]
["Mats",2600,10,26000,{"$f":"E47","v":"2016-08-01"},24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,26000,0,0,0,0,0]
["Plastic Chairs",3000,10,30000,"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30000,0,0,0,0,0]
["Office table",8000,10,80000,"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,80000,0,0,0,0,0]
["Fans",6000,10,60000,"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,60000,0,0,0,0,0]
["Pillows",1050,10,10500,"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10500,0,0,0,0,0]
["Blanket",4000,10,40000,"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,40000,0,0,0,0,0]
["Phone",42000,10,{"$f":"B54*C54","v":420000},"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,420000,0,0,0,0,0]
["Motorcycle",210000,10,{"$f":"B55*C55","v":2100000},"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2100000,0,0,0,0,0]
[{"$f":"A41","v":"Phone"},{"$f":"VLOOKUP(A56,$A$4:$D$15,4,FALSE)","v":42000},10,{"$f":"B56*C56","v":420000},"2016-08-01",24,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,420000,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A57,$A$4:$D$14,4,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A58,$A$4:$D$14,4,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H19:H58)","v":0},{"$f":"SUM(I19:I58)","v":0},0,0,{"$f":"SUM(L19:L58)","v":1502600},0,0,0,0,0,0,2861200,0,0,0,0,0,0,0,0,0,0,0,3576500,0,0,0,0,0]

{"sheet":"Other","index":18,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Assumptions"]
[null,"Position","Salary"]
[null,"Hindi",3000]
[null,"Vipassana",25000]
[null,"Team Building",30000]
[]
[]
[]
[]
[]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Position","Salary","Total","Start Date",null,null,null,"2014-09-01","2014-10-01","2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01"]
[{"$nulls":7},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
["Hindi",{"$f":"VLOOKUP(A15,$B$4:$C$8,2,FALSE)","v":3000},{"$f":"B15","v":3000},"2014-10-01",{"$f":"IF(D15>0,(HLOOKUP(D15,$H$13:$AJ$14,2)),0)","v":2},null,null,{"$f":"IF(H$12<$E15,0,IF(H$12=$E15,$C15,IF(H$12>$E15,0)))","v":0},3000,0,0,0,0,0,0,0,0,{"$f":"IF(R$12<$E15,0,IF(R$12=$E15,$C15,IF(R$12>$E15,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AB$12<$E15,0,IF(AB$12=$E15,$C15,IF(AB$12>$E15,0)))","v":0},0,0,0,0,0,0,0,0]
["Hindi",3000,{"$f":"B16","v":3000},"2014-11-01",{"$f":"IF(D16>0,(HLOOKUP(D16,$H$13:$AJ$14,2)),0)","v":3},null,null,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hindi",3000,3000,"2014-12-01",4,null,null,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hindi",3000,3000,"2015-01-01",5,null,null,0,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"B5","v":"Vipassana"},25000,{"$f":"B19","v":25000},"2014-10-01",2,null,null,{"$f":"IF(H$12<$E19,0,IF(H$12=$E19,#REF!,IF(H$12>$E19,0)))","v":0},{"$f":"IF(I$12<$E19,0,IF(I$12=$E19,C19,IF(I$12>$E19,0)))","v":25000},{"$f":"IF(J$12<$E19,0,IF(J$12=$E19,#REF!,IF(J$12>$E19,0)))","v":0},{"$f":"IF(K$12<$E19,0,IF(K$12=$E19,#REF!,IF(K$12>$E19,0)))","v":0},{"$f":"IF(L$12<$E19,0,IF(L$12=$E19,#REF!,IF(L$12>$E19,0)))","v":0},{"$f":"IF(M$12<$E19,0,IF(M$12=$E19,#REF!,IF(M$12>$E19,0)))","v":0},{"$f":"IF(N$12<$E19,0,IF(N$12=$E19,#REF!,IF(N$12>$E19,0)))","v":0},{"$f":"IF(O$12<$E19,0,IF(O$12=$E19,#REF!,IF(O$12>$E19,0)))","v":0},{"$f":"IF(P$12<$E19,0,IF(P$12=$E19,#REF!,IF(P$12>$E19,0)))","v":0},{"$f":"IF(Q$12<$E19,0,IF(Q$12=$E19,#REF!,IF(Q$12>$E19,0)))","v":0},{"$f":"IF(R$12<$E19,0,IF(R$12=$E19,#REF!,IF(R$12>$E19,0)))","v":0},{"$f":"IF(S$12<$E19,0,IF(S$12=$E19,#REF!,IF(S$12>$E19,0)))","v":0},{"$f":"IF(T$12<$E19,0,IF(T$12=$E19,#REF!,IF(T$12>$E19,0)))","v":0},{"$f":"IF(U$12<$E19,0,IF(U$12=$E19,#REF!,IF(U$12>$E19,0)))","v":0},{"$f":"IF(V$12<$E19,0,IF(V$12=$E19,#REF!,IF(V$12>$E19,0)))","v":0},{"$f":"IF(W$12<$E19,0,IF(W$12=$E19,#REF!,IF(W$12>$E19,0)))","v":0},{"$f":"IF(X$12<$E19,0,IF(X$12=$E19,#REF!,IF(X$12>$E19,0)))","v":0},{"$f":"IF(Y$12<$E19,0,IF(Y$12=$E19,#REF!,IF(Y$12>$E19,0)))","v":0},{"$f":"IF(Z$12<$E19,0,IF(Z$12=$E19,#REF!,IF(Z$12>$E19,0)))","v":0},{"$f":"IF(AA$12<$E19,0,IF(AA$12=$E19,#REF!,IF(AA$12>$E19,0)))","v":0},{"$f":"IF(AB$12<$E19,0,IF(AB$12=$E19,#REF!,IF(AB$12>$E19,0)))","v":0},{"$f":"IF(AC$12<$E19,0,IF(AC$12=$E19,#REF!,IF(AC$12>$E19,0)))","v":0},{"$f":"IF(AD$12<$E19,0,IF(AD$12=$E19,#REF!,IF(AD$12>$E19,0)))","v":0},{"$f":"IF(AE$12<$E19,0,IF(AE$12=$E19,#REF!,IF(AE$12>$E19,0)))","v":0},{"$f":"IF(AF$12<$E19,0,IF(AF$12=$E19,#REF!,IF(AF$12>$E19,0)))","v":0},{"$f":"IF(AG$12<$E19,0,IF(AG$12=$E19,#REF!,IF(AG$12>$E19,0)))","v":0},{"$f":"IF(AH$12<$E19,0,IF(AH$12=$E19,#REF!,IF(AH$12>$E19,0)))","v":0},{"$f":"IF(AI$12<$E19,0,IF(AI$12=$E19,#REF!,IF(AI$12>$E19,0)))","v":0},{"$f":"IF(AJ$12<$E19,0,IF(AJ$12=$E19,#REF!,IF(AJ$12>$E19,0)))","v":0}]
[{"$f":"B6","v":"Team Building"},30000,{"$f":"B20","v":30000},"2014-10-01",2,null,null,{"$f":"IF(H$12<$E20,0,IF(H$12=$E20,$C19,IF(H$12>$E20,0)))","v":0},{"$f":"IF(I$12<$E20,0,IF(I$12=$E20,$C20,IF(I$12>$E20,0)))","v":30000},{"$f":"IF(J$12<$E20,0,IF(J$12=$E20,$C19,IF(J$12>$E20,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(T$12<$E20,0,IF(T$12=$E20,$C19,IF(T$12>$E20,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AD$12<$E20,0,IF(AD$12=$E20,$C19,IF(AD$12>$E20,0)))","v":0},0,0,0,0,0,0]
[{"$nulls":4},0,null,null,{"$f":"IF(H$12<$E21,0,IF(H$12=$E21,$C20,IF(H$12>$E21,0)))","v":0},{"$f":"IF(I$12<$E21,0,IF(I$12=$E21,$C20,IF(I$12>$E21,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(A22,$B$4:$C$8,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,0,null,null,{"$f":"IF(H$12<$E22,0,IF(H$12=$E22,$C22,IF(H$12>$E22,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(R$12<$E22,0,IF(R$12=$E22,$C22,IF(R$12>$E22,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AB$12<$E22,0,IF(AB$12=$E22,$C22,IF(AB$12>$E22,0)))","v":0},0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B23*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B24*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B25*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B26*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B27*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B28*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B29*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B30*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B31*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B32*#REF!","v":{"$error":"#N/A"}},null,0,null,null,{"$f":"IF(H$12<$E32,0,IF(H$12=$E32,$C32,IF(H$12>$E32,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(R$12<$E32,0,IF(R$12=$E32,$C32,IF(R$12>$E32,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AB$12<$E32,0,IF(AB$12=$E32,$C32,IF(AB$12>$E32,0)))","v":0},0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B33*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B34*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B35*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B36*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$error":"#N/A"},{"$f":"B37*#REF!","v":{"$error":"#N/A"}},null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F38,0,IF(H$12=$F38,$D38,IF(H$12>$F38,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(X$12<$F38,0,IF(X$12=$F38,$D38,IF(X$12>$F38,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(X$12<$F46,0,IF(X$12=$F46,$D46,IF(X$12>$F46,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(W$12<$F47,0,IF(W$12=$F47,$D47,IF(W$12>$F47,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":7},{"$f":"IF(H$12<$F48,0,IF(H$12=$F48,$D48,IF(H$12>$F48,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"Total",{"$f":"SUM(H15:H48)","v":0},{"$f":"SUM(I15:I48)","v":58000},3000,3000,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]