{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Formulas","Example 1&2","Discount Rates","Sheet3","Cost-New Gensets","Fuel Consumption"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Formulas","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Present Worth, PW=","Cr*Pr"]
[null,null,"Pr=1/(1+d)N"]
["formula 1.1","PW=","Cr*(1/(1+d)N)"]
[null,"Cr=",100]
[null,"N=","Time for payment"]
[null,"Discount Rate, d=","Discount Rate"]
[null,"=","Real Interest Rate"]
[null,"=","Nominal interest rate - Real inflation rate"]
[null,"=","http://data.worldbank.org/indicator/FR.INR.RINR?year_high_desc=false"]
[null,"Note:","use average of real interest rate for the last 5 years"]
[]
["formula 1.2","Total PW = ","I + ∑Nn=1Cr*[(1/(1+d)N] "]
[null,"I= ","capital investment (initial or capital costs )"]
[null,"Cr=","O&M costs + Overhaul costs + Replacement costs –Salvage value"]
{"$rows_empty":11}
[null,"Cost of water=","Total cost over 25 years"]
[null,null,"Total water pumped in 25 years"]

{"sheet":"Example 1&2","index":1,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":true,"merged":[[45,3,45,4]]}
["Example 1:"]
["PW=","Cr*(1/(1+d)N)"]
["Cr=",2000,"$","Pr=",{"$f":"1/(POWER((1+B5),B4))","v":0.38554328942953148}]
["N=",10,"years","PW=",{"$f":"E3*B3","v":771.08657885906291}]
["Discount Rate, d=",0.1]
["=",{"$f":"B3*(1/(POWER((1+B5),B4)))","v":771.08657885906291},"$"]
[]
["Example 2:"]
["Total PW = ","I + ∑Nn=1Cr*[(1/(1+d)N] "]
["Q=",70,"m3/day"]
["t=",6,"hrs/day"]
["N=",25,"yrs"]
["PW (genset)=",50000]
["d=",0.1]
["PW (solar)=",4500]
["O&M (solar)=",150,"per year"]
["Replacement Cost=",1500,"every 6 years"]
[]
["Year (N)","Capital Cost $","O&M Cost $","Replacement Cost $","Discount Factor, Pr","Present Worth $"]
[0,{"$f":"B15","v":4500},0,null,{"$f":"1/(POWER((1+$B$14),A20))","v":1},{"$f":"(B20+C20+D20)*E20","v":4500}]
[1,null,150,null,0.90909090909090906,136.36363636363635]
[2,null,150,null,0.82644628099173545,123.96694214876032]
[3,null,150,null,0.75131480090157754,112.69722013523663]
[4,null,150,null,0.68301345536507052,102.45201830476057]
[5,null,150,null,0.62092132305915493,93.138198458873234]
[6,null,150,{"$f":"B17","v":1500},0.56447393005377722,931.38198458873239]
[7,null,150,null,0.51315811823070645,76.97371773460597]
[8,null,150,null,0.46650738020973315,69.976107031459975]
[9,null,150,null,0.42409761837248466,63.614642755872701]
[10,null,150,null,0.38554328942953148,57.831493414429723]
[11,null,150,null,0.3504938994813922,52.574084922208833]
[12,null,150,{"$f":"B17","v":1500},0.31863081771035656,525.74084922208829]
[13,null,150,null,0.28966437973668779,43.44965696050317]
[14,null,150,null,0.26333125430607973,39.499688145911961]
[15,null,150,null,0.23939204936916339,35.90880740537451]
[16,null,150,null,0.21762913579014853,32.644370368522281]
[17,null,150,null,0.19784466890013502,29.676700335020254]
[18,null,150,{"$f":"B17","v":1500},0.17985878990921364,296.76700335020251]
[19,null,150,null,0.16350799082655781,24.526198623983671]
[20,null,150,null,0.14864362802414349,22.296544203621522]
[21,null,150,null,0.13513057093103953,20.269585639655929]
[22,null,150,null,0.12284597357367227,18.426896036050842]
[23,null,150,null,0.11167815779424752,16.751723669137128]
[24,null,150,{"$f":"B17","v":1500},0.10152559799477048,167.51723669137129]
[25,null,150,null,9.2295998177064048E-2,13.844399726559606]
[null,null,null,"Solar System, Total PW",null,{"$f":"SUM(F20:F45)","v":7608.2897062365801}]
[]
["Cost of water=","Total cost over 25 years"]
[null,"Total water pumped in 25 years"]
["Total water pumped in 25 years=",{"$f":"B10*365*B12","v":638750},"m3"]
["Solar=",{"$f":"F46/B50","v":1.1911216761231436E-2},"$/m3"]
["Genset=",{"$f":"B13/B50","v":7.8277886497064575E-2},"$/m3"]

{"sheet":"Discount Rates","index":2,"n_rows":150,"n_cols":10,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["Data Source","World Bank: World Development Indicators"]
["Last Updated Date","2016-10-04"]
[]
["Country Name","Country Code","Indicator Name","2010","2011","2012","2013","2014","2015","Average last 5 years"]
["Afghanistan","AFG","Real interest rate (%)",5.7130219412727046,4.1467500027960451,6.1818511863330601,9.8948431702252737,14.721135221903227,13.929185480028428]
["Angola","AGO","Real interest rate (%)",0.12227722625145945,-4.3569502145115147,8.9531736885729849,12.978823305575586,18.000130869879566,21.742500504426044]
["Albania","ALB","Real interest rate (%)",7.9743036957568743,9.8933414522671956,9.7391030904008815,9.5867443201683358,6.8755211805505407,8.2091907117046325]
["Argentina","ARG","Real interest rate (%)",-5.6761709562954845,-3.1496255360487924,-3.8811430961721034,-2.141217799717495,-4.122577454173701]
["Armenia","ARM","Real interest rate (%)",10.607635788735154,12.919757893239732,11.281193293088798,12.216843045589981,13.330483389809915,16.21489088541091]
["Antigua and Barbuda","ATG","Real interest rate (%)",9.5035270624749799,9.4671111912089234,7.4709887243456912,9.9481546191261963,13.452814484528465,7.1610290719139789]
["Australia","AUS","Real interest rate (%)",6.2086884258248576,1.4603110260258689,4.8199908396566595,6.3912803713043429,4.4731455523269972,6.2545522741728057]
["Azerbaijan","AZE","Real interest rate (%)",6.1037776063881566,-2.9190402307357428,16.664299148030732,17.015196791373636,17.626820009054249,28.939959029301608]
["Burundi","BDI","Real interest rate (%)",0.10391860790681236,-0.92903849463990684,-0.95003846425472116,1.7533233447024654,6.8002767038087253,11.175921744969354]
["Bangladesh","BGD","Real interest rate (%)",4.7361375460785178,5.064202378701073,5.3433092171745926,5.9886843193596286,6.8859002317331051,5.5126447786655177]
["Bulgaria","BGR","Real interest rate (%)",9.7937044748183144,3.5149736285262607,8.0271913690747212,9.8723136424763069,7.7966285891771481,7.1371274541576293]
["Bahrain","BHR","Real interest rate (%)",-0.18011263034374905,-3.4704302792535038,3.7248267441181744,4.4011966345255846,7.4966933830339393,13.712502802360479]
["Bahamas, The","BHS","Real interest rate (%)",5.9158730616385604,5.9721120245013255,2.5902486393449231,2.3216718148475661,4.8421741829729212,1.5657750180602983]
["Bosnia and Herzegovina","BIH","Real interest rate (%)",6.2860060246208329,4.8373374954043546,6.3946124800415181,7.3445597381913208,5.5793725926281921,5.6337817662084131]
["Belarus","BLR","Real interest rate (%)",-1.6699327035894851,-33.651529004143789,-31.8897438407474,-1.6171633586204697,0.76483044708210057]
["Belize","BLZ","Real interest rate (%)",12.599062141611013,8.7708507186232616,10.204964471407765,9.4045048220511198,9.1658573665414682,9.5580302427362547]
["Bolivia","BOL","Real interest rate (%)",1.0410413368842035,-3.2171779542165986,3.7671903246021832,4.7700294890444797,7.4911990437215739,11.675783510403006]
["Brazil","BRA","Real interest rate (%)",29.116483576150621,32.834195855360328,26.729093304258953,18.630333360107915,23.527966807735854,33.33192301850427]
["Barbados","BRB","Real interest rate (%)",12.834982212272546,11.690367420927195,10.132051969549135,9.5125204391497444,6.7460833972422076,6.7622611783757645]
["Brunei Darussalam","BRN","Real interest rate (%)",0.18161817162018498,-12.339822618442412,5.551287131950402,8.9346125976760327,-4.1660957423551981,6.8038512206572914]
["Bhutan","BTN","Real interest rate (%)",7.5618726797707279,4.9654508105355211,4.4140210523060546,7.6849306591024558,6.1148317817415121,11.541399091696153]
["Botswana","BWA","Real interest rate (%)",2.3303510948988007,-4.6512819244749126,11.125263520638054,8.9644709959765834,-1.8430624914179663,5.266100145736381]
["Canada","CAN","Real interest rate (%)",-0.26235529791101964,-0.23444874723293879,1.7572867181965166,1.4239191297608003,1.2220437386835046,3.3465650199280637]
["Switzerland","CHE","Real interest rate (%)",2.437693853731508,2.5121992348581137,2.908144239450023,2.7094648972066779,3.4244616339774723,4.0238058871746656]
["Chile","CHL","Real interest rate (%)",-3.7444492684672213,5.58020639406441,9.1296272590322598,6.8166592077967199,2.4110158104306829,1.1408394804048043]
["China","CHN","Real interest rate (%)",-1.0544055744867731,-1.4603516195756723,3.5235596325068133,3.6827268498054599,4.7445818211979152,4.8249749693000394]
["Colombia","COL","Real interest rate (%)",5.3200751696673985,4.2114760493726404,9.3175528112235479,8.8171784667245188,8.5477518100072949,8.6670795864440002]
["Comoros","COM","Real interest rate (%)",7.2129969969279486,8.6833663247613373,8.1673136462451623,8.6238726166072155,8.2073833701269354]
["Cabo Verde","CPV","Real interest rate (%)",10.482003761478159,6.948319046115695,9.2959565693101798,10.000847290273617,11.886306586141773,8.6379180032873144]
["Costa Rica","CRI","Real interest rate (%)",8.4566898855715369,11.114974667337034,13.791590600606188,10.310441672072772,9.7067152531272587,14.584713145457666]
["Czech Republic","CZE","Real interest rate (%)",7.4461729328155517,5.9515551781793326,3.9641147930333784,3.5063370859802148,2.1122025115647043,3.5232312451286498]
["Germany","DEU","Real interest rate (%)"]
["Djibouti","DJI","Real interest rate (%)",6.2430201709285127,6.0803398675572353,7.4811503917792344,9.3134035587694655,9.4078917826020074]
["Dominica","DMA","Real interest rate (%)",9.201339795558356,7.1523087740189277,11.289596068524821,5.0696203565159959,9.2923778943638595,8.9311897379244485]
["Dominican Republic","DOM","Real interest rate (%)",6.1412215134171131,5.9788187855010921,10.589200935767698,10.595060759954659,12.274579280766567,13.236949050029622]
["Algeria","DZA","Real interest rate (%)",-6.9927472290415524,-8.6510905641711311,0.50964575519513655,8.1213964528942775,8.4468929956217362,14.92319748623949]
["Egypt, Arab Rep.","EGY","Real interest rate (%)",0.81094657934554881,-0.5129948665712023,-5.268507905341683,3.0162458871172175,0.17527826019828327,0.61684919540702099]
["Estonia","EST","Real interest rate (%)",6.1184980010789598,0.81335527750346015,2.9598872115874806,1.3387012803772256,2.6898428333896649,3.0255072869286628]
["Ethiopia","ETH","Real interest rate (%)"]
["Fiji","FJI","Real interest rate (%)",3.1275734791150476,-7.2653559806801207,3.3556398110268639,2.9998485216583779,2.1799019303204843,2.508232422317489]
["Micronesia, Fed. Sts.","FSM","Real interest rate (%)",11.378544149845705,10.613398068522347,9.4792510204723186,14.281239442930422,11.066237910488798]
["United Kingdom","GBR","Real interest rate (%)",-2.5325564082404224,-1.5634182310371254,-1.107699075602355,-1.4561292551545781,-1.3133917544051037]
["Georgia","GEO","Real interest rate (%)",6.7267270520504212,5.0628199739500062,13.591641795826995,14.46746476417794,7.8330994564148622,6.3398617275383407]
["Gambia, The","GMB","Real interest rate (%)",21.684168437664471,22.637126344562027,23.320828961207223,20.809243183104055,18.629039930165213]
["Grenada","GRD","Real interest rate (%)",10.047094394440014,10.439225132201791,5.5791352511643924,6.1741274132375645,6.6313196449813496,5.0353542723572122]
["Greenland","GRL","Real interest rate (%)"]
["Guatemala","GTM","Real interest rate (%)",7.7987682575849497,6.0757342601581348,9.8373132915503501,9.8978704817760388,10.442147023471538,9.646905835854767]
["Guyana","GUY","Real interest rate (%)",7.3462891263998316,5.6150083428939963,7.672991070334481,13.306160999510153,13.269598531839488,12.932013597054016]
["Hong Kong SAR, China","HKG","Real interest rate (%)",4.7165198739347085,1.0607495161652087,1.4053703421403132,3.084316706949437,2.0403923435441595,1.0240188521884304]
["Honduras","HND","Real interest rate (%)",13.554792887701447,9.971806992330766,14.356962984823213,18.453282416028514,14.294612393423874,15.012954778816804]
["Croatia","HRV","Real interest rate (%)",9.4663991213288252,7.8805028048182209,7.7765846545023205,8.3744829835613928]
["Haiti","HTI","Real interest rate (%)",11.408714871178175,3.813334041598317,3.4654360712343135,2.0030095539315615,5.9889005474611681,4.2888583336254671]
["Hungary","HUN","Real interest rate (%)",5.209260336441063,5.984487094438621,5.3112339116384648,3.1354258299097899,1.1673418003727163,1.1124308725410361]
["Indonesia","IDN","Real interest rate (%)",-1.7460975355976769,4.5943767488372984,7.7501885648907152,6.374931242121253,6.8489357256686052,8.0893839081886956]
["Iran, Islamic Rep.","IRN","Real interest rate (%)",-2.0630529973489278,-12.110129957446631,-8.8680040253683536,-17.374282457849187,1.5679594655199438]
["Iraq","IRQ","Real interest rate (%)",-2.7969796530110127,-8.8882995912877067,10.09488707942687,13.059825252321337]
["Iceland","ISL","Real interest rate (%)",4.415101367572082,4.5164674476469786,4.976840681523754,6.1922238608370526,3.6130444261158918,1.6303290643174924]
["Israel","ISR","Real interest rate (%)",3.7133026786501824,4.0648743992786125,1.2688518746659174,2.1007532004605305,2.6017870196076096,0.76067721905818819]
["Italy","ITA","Real interest rate (%)",3.7003971176326145,3.0854695119419571,3.7900380735487937,3.8718128178169677,4.0266267306580135,3.3500575552272913]
["Jamaica","JAM","Real interest rate (%)",9.6638896454091547,13.064603825759756,10.413885200055416,8.643204711464632,9.2132001958032443,11.381840222349837]
["Jordan","JOR","Real interest rate (%)",0.56449679976306844,2.161264310770826,4.0958831713319972,3.2298365607482573,5.3610311154597952,6.0570503265061104]
["Japan","JPN","Real interest rate (%)",3.8419313089116773,3.4177013286106876,2.3596057981146945,1.8740187208306809,-0.44495929329978517]
["Kenya","KEN","Real interest rate (%)",12.025898002272436,3.8406757019898001,9.4535880774346612,11.338859648395648,7.8895819875737914,6.3622466452609263]
["Kyrgyz Republic","KGZ","Real interest rate (%)",11.882444600202353,2.2801457917462891,14.028000125625613,17.981012960048741,12.863696957882439,21.593981925998751]
["St. Kitts and Nevis","KNA","Real interest rate (%)",7.6063197121154165,5.8590162708458093,6.8334678726488702,7.0117143023041484,6.358704286725021,7.2591136701744858]
["Korea, Rep.","KOR","Real interest rate (%)",2.2781903614354602,4.1078200718085434,4.3073753160862456,3.7579396346721174,3.6410328686975055,1.2949413160729617]
["Kosovo","KSV","Real interest rate (%)",8.8609886357971988,8.3660483220343309,9.8132803780144062,8.940296008436686,5.8796684354624889,7.8683546533285744]
["Kuwait","KWT","Real interest rate (%)",-5.6259003502887479,-10.266073365642164,-2.3285775946298011,4.3280976871908461,8.8072706530409341,42.469242456660446]
["Lebanon","LBN","Real interest rate (%)",8.1641727319065875,4.0208352077348692,1.6777813495600313,5.5125557498094535,5.9236027407079224,5.5401653880958257]
["Liberia","LBR","Real interest rate (%)",8.3137236048874126,2.952691976756471,9.1650802162970084,9.9943832495601512,10.521626106908963,11.724760710588345]
["Libya","LBY","Real interest rate (%)",-7.1487311619433358,-10.359951286304355,-10.900155177134662,13.676812864126893,28.191196179560688]
["St. Lucia","LCA","Real interest rate (%)",3.2623319073045156,7.2939109877089585,6.5994789414978428,7.323025407006317,4.0339057171258084,8.3076959656419973]
["Sri Lanka","LKA","Real interest rate (%)",-10.830082008411607,4.4963496167461097,-0.29633938835420071,2.7326148494378772,3.9853991903569952,5.733644259306212]
["Latvia","LVA","Real interest rate (%)",10.634090985761427,3.0894080018807481E-2,1.8634298095339776,4.5583211781307353]
["Macao SAR, China","MAC","Real interest rate (%)",0.44943633963093688,-2.0878983736296619,-1.5709470031394193,-2.2986689063068981,-3.0893500811896959,0.82567593143606977]
["Moldova","MDA","Real interest rate (%)",4.7560661512282687,6.3053207836295426,5.1195195779252849,7.8345142198743778,4.3591607407407498,4.442936297218826]
["Madagascar","MDG","Real interest rate (%)",36.955546574341135,40.903730192608144,51.673072989274168,52.099438356729358,45.351450645178538,49.692120655175515]
["Maldives","MDV","Real interest rate (%)",9.0506081510195511,-0.39791491585784483,4.6825996675202859,4.8254265401868031,8.1371669059826477,10.052221229156018]
["Mexico","MEX","Real interest rate (%)",0.76710275232633274,-0.35335057134163222,1.4318100388245953,2.4437012022894429,-1.0871218441912949,0.88640248475257222]
["Macedonia, FYR","MKD","Real interest rate (%)",7.2931855562144214,4.961615665997356,7.4177249686633004,3.4071199898690447,6.2385949003326981,4.1614648034192765]
["Mali","MLI","Real interest rate (%)"]
["Myanmar","MMR","Real interest rate (%)",null,null,null,7.1615813449068089,6.0149052347118674,1.5169044716295521]
["Montenegro","MNE","Real interest rate (%)",7.0527676545635254,8.3831388098213395,9.368891693229271,7.1747301858358679,8.2903795762310288,8.165240762827187]
["Mongolia","MNG","Real interest rate (%)",-13.730174652507824,1.2944589484676738,4.7253308171300787,15.134097464219458,10.774052884427341,17.346007228455179]
["Mozambique","MOZ","Real interest rate (%)",8.007123422355285,15.259030254631764,10.352816058882896,10.973210483493459,11.942232150404321,10.427875543883927]
["Mauritania","MRT","Real interest rate (%)",-1.579411472509302,0.94583842807057739,15.855632084106322]
["Mauritius","MUS","Real interest rate (%)",6.9684351780066436,4.8017001815557956,5.341740748358438,5.1193207114627546,6.6379717043278443,7.4812542454665403]
["Malawi","MWI","Real interest rate (%)",11.146111581801552,8.4805382929974211,12.47173730679749,14.698129973222484,19.362312122424438,19.42664913180931]
["Malaysia","MYS","Real interest rate (%)",-2.1123919448463919,-0.47186862820582187,3.7485261928056057,4.4286480752799902,2.0629109876422507,4.992483786703021]
["Namibia","NAM","Real interest rate (%)",5.9440064390141636,4.7444078070964775,-3.7465677390827055,-0.45020937003297051,1.8814448529870402,9.2548571713981289]
["Niger","NER","Real interest rate (%)"]
["Nigeria","NGA","Real interest rate (%)",-42.31018290760106,5.9415255528288622,6.8831057552937374,10.247347363596239,11.356212150627874,13.595829361061678]
["Nicaragua","NIC","Real interest rate (%)",6.7743685908571631,0.20643693550777076,5.2476562502884132,9.890491956368697,4.2884762355712196,4.0160658956690796]
["Netherlands","NLD","Real interest rate (%)",0.89444618777616836,1.8554708218170195,0.20245414174930912]
["New Zealand","NZL","Real interest rate (%)",2.85043915842851,3.9522783744187833,6.3478857568016203,0.49915238918755606,5.2111594858227388,5.8843330257983215]
["Oman","OMN","Real interest rate (%)",-7.6104160721008824,-9.3413749942577216,0.67789687795736076,6.9540637316304164,3.3470292845600516,26.241750802798649]
["Pakistan","PAK","Real interest rate (%)"]
["Panama","PAN","Real interest rate (%)",4.7918962317065663,0.5548386350771034,0.46605264409970748,1.236056314396059,3.3658451451853448,7.196086427409754]
["Peru","PER","Real interest rate (%)",12.233459276783474,12.840744807826303,16.763646726117578,16.432158060186538,12.342349265428643,12.832508832450149]
["Philippines","PHL","Real interest rate (%)",3.3104957968579112,2.5394026814286934,3.639468291101732,3.6035014057813854,2.2486652518115582,6.3053927507223859]
["Papua New Guinea","PNG","Real interest rate (%)",0.51258481412796808,6.15390192904648,13.995635552215612,7.7451436190484024,-1.4407317137561004]
["Paraguay","PRY","Real interest rate (%)",18.789286974925229,10.539039904007883,11.848627410681148,18.275649796583728,15.262682831930187,18.218367920772355]
["Qatar","QAT","Real interest rate (%)",0.2730603009779643,-11.874397155686918,-1.3748094202910985,3.6146739108823103,5.0750912372359069,36.177894314132025]
["Romania","ROU","Real interest rate (%)",8.2106349635970854,7.0525212021734438,6.3461890093955589,6.8706384005931174,6.6365433312527733,3.7255362533535052]
["Russian Federation","RUS","Real interest rate (%)",-2.9516238937480881,-12.280023102890466,0.73967455496811974,4.4823791078821635,1.9778502666599933,7.4622739293697169]
["Rwanda","RWA","Real interest rate (%)",13.935498270337705,8.7756001121705136,9.8972175873731771,11.611370825654737,13.514621219546276,15.636181282350892]
["Sudan","SDN","Real interest rate (%)"]
["Senegal","SEN","Real interest rate (%)"]
["Singapore","SGP","Real interest rate (%)",5.4284840379610042,4.2227691645506749,4.6159623433752399,6.1231422250083583,5.304279563131149,3.6503187579874692]
["Solomon Islands","SLB","Real interest rate (%)",8.7504522920841659,2.1827068878749682,4.6332872182036047,11.193176014473648,1.9852800542951086,6.4234611706704943]
["Sierra Leone","SLE","Real interest rate (%)",3.4675554016890215,3.0796640284415426,7.9809009825749593,13.181449654987153,18.481957661725364,-5.7414986100187821]
["Somalia","SOM","Real interest rate (%)"]
["Serbia","SRB","Real interest rate (%)",10.786495299776917,6.9449502908706151,11.232839477564356,11.03014928731994,11.78279884224763]
["South Sudan","SSD","Real interest rate (%)",null,null,7.7390051504195991,0.95443069442630168,16.297636946080207,12.02173408442186]
["Sao Tome and Principe","STP","Real interest rate (%)",16.396546034360416,13.608985061004775,10.1971762052572,15.355369932965122,9.5859674310840024]
["Suriname","SUR","Real interest rate (%)",4.0875562416263715,-2.3699093525131838,1.2830764053463297,11.774039281264423,12.61012257651301,17.924501663240065]
["Swaziland","SWZ","Real interest rate (%)",15.135300332042833,-20.843940940925823,0.10602930548003243,2.2758450076223995,2.3612156752219291,2.481503587827008]
["Seychelles","SYC","Real interest rate (%)",17.659311596757153,6.4056840249242049,1.5400080514068777,8.7851505041148332,8.2394605171220281,10.006041555701302]
["Syrian Arab Republic","SYR","Real interest rate (%)"]
["Chad","TCD","Real interest rate (%)"]
["Togo","TGO","Real interest rate (%)"]
["Thailand","THA","Real interest rate (%)",1.780065136556517,3.05382954131835,5.0906073777564176,5.1445071365696879,5.7533286440306677,6.2881094429886062]
["Tajikistan","TJK","Real interest rate (%)",9.7259426863462384,8.0629708098450283,8.2461248050365015,19.154544124315169,18.079666802556389,23.545851790129998]
["Timor-Leste","TLS","Real interest rate (%)",6.3485032973641351,-0.17842353560133176,4.8717130983741113,13.410620667665036,14.543396802122986,14.870609466388535]
["Tonga","TON","Real interest rate (%)",7.7463472805436915,4.9791865921255152,7.3434230965789151,9.2880599115872062,6.5148933848243376]
["Trinidad and Tobago","TTO","Real interest rate (%)",-1.2743687919385014,-7.4310151406664247,8.0777917352552695,-1.5684881672143056,2.8442299646658351,14.033643136527344]
["Tunisia","TUN","Real interest rate (%)"]
["Turkey","TUR","Real interest rate (%)"]
["Tuvalu","TUV","Real interest rate (%)"]
["Tanzania","TZA","Real interest rate (%)",4.8509885717100776,3.0619806335019648,4.2608315245784532,7.5790449994767259,11.072682025838544,10.356098956750243]
["Uganda","UGA","Real interest rate (%)",6.5017741054486091,16.216333616986688,4.4892875091513451,18.350662928123739,18.794223904556549,18.348580276869825]
["Ukraine","UKR","Real interest rate (%)",1.8619455047471094,1.576054562342208,9.7885934447646203,13.048735216219621,1.7153132393896477,-13.123709491665165]
["Uruguay","URY","Real interest rate (%)",5.1657140169571569,0.70832721950335686,2.4334009331955273,3.957639862865455,5.6338734209591301,6.5716731189109163]
["United States","USA","Real interest rate (%)",2.0041726519164125,1.161394072406972,1.3824824779155451,1.5939235375093643,1.5813657681461573,2.2354812978600802]
["Uzbekistan","UZB","Real interest rate (%)"]
["St. Vincent and the Grenadines","VCT","Real interest rate (%)",4.521889117382158,9.4931957265306366,8.2348300017982172,6.9901311007565825,8.492306694602604,7.6985371539848364]
["Venezuela, RB","VEN","Real interest rate (%)",-18.908558746605635,-8.583113846523883,2.0345270306944863,-14.470322956852554]
["Vietnam","VNM","Real interest rate (%)",0.94659685656524695,-3.5517438690720953,2.2949289621964684,5.3584161299057786,4.8258741553370426,7.322258131668538]
["Vanuatu","VUT","Real interest rate (%)",2.8091249487460725,2.3289071389285891,5.6130647963951219,2.2822381578900091,2.6281973885238816]
["West Bank and Gaza","PSE","Real interest rate (%)",-6.3543203162554507,2.2371489158887643,5.4849584975886154,-0.64159392511449953,4.2150135092526462,10.829180834199823]
["Samoa","WSM","Real interest rate (%)",9.1197118971120155,7.4759612684086969,5.6750929978962521,8.3389818839871506,9.6559165359991876,6.4697942983340377]
["Yemen, Rep.","YEM","Real interest rate (%)",8.8279684284287754,8.4102276349868568,23.296188693994257,13.151063606884355]
["South Africa","ZAF","Real interest rate (%)",3.2743515957473033,2.201760863007836,3.0686240224989731,2.3723638122811517,3.1470812046904904,5.436978495695028]
["Congo, Dem. Rep.","COD","Real interest rate (%)",33.312969639029689,30.246995061390056,19.492606855130838,18.501158049252904,17.752676796463813,18.60764647052892]
["Zambia","ZMB","Real interest rate (%)",6.1126569661196513,7.0036024599700628,4.7963038475857989,-0.12073401670074044,6.2139478577250999,6.1900061235183941]
["Zimbabwe","ZWE","Real interest rate (%)"]

{"sheet":"Sheet3","index":3,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,"Values"]
["Row Labels"," 2 Solar BHs"," Hybrid"," Diesel "]
[0,185500,100160,14910]
[1,186000,119783.42857142857,63611.428571428572]
[2,186476.19047619047,138472.4081632653,114050.88435374151]
[3,186929.7052154195,156271.43634596694,158224.51571104635]
[4,187361.62401468522,173222.89175806375,200294.64081324142]
[5,187772.97525208117,189367.13500767975,243866.1391674692]
[6,188164.7383353154,208080.42623837444,282024.98279757809]
[7,201330.10997597591,229119.86274434463,318366.73863577703]
[8,201685.45064104098,243065.86706320092,356005.43713851133]
[9,202023.87032205533,256347.77593830213,399060.47817498853]
[10,202346.17478016423,268997.21296220808,430453.85326467559]
[11,202653.13140693461,281044.2958421185,462967.57619112782]
[12,202945.47105147783,292517.70810869982,491442.29282576463]
[13,203223.88976056661,305816.89481164224,518561.07057303772]
[14,212580.27358980861,320769.2295328934,546647.646905142]
[15,212832.80756630638,330680.39443221863,571245.17774167086]
[16,213073.31611535186,340119.59909824264,594671.39758598409]
[17,213302.37187634755,349109.31782778929,618933.63823568006]
[18,213520.52022015298,357670.95471307181,640181.91020331113]
[19,213728.28054758671,365824.89460381708,666613.97052734578]
[20,213926.14752609504,375276.37829951302,685886.77956828102]
[21,220575.5548310687,385902.72342776257,704241.83579774317]
[22,220755.02601338917,392946.403281554,721722.84173056425]
[23,220925.95094893247,404751.8141725288,739827.69926027046]
[24,221088.73660183087,411140.63943673868,755683.4869544392]
[25,221243.77055697219,417225.23492646241,770784.23713936179]
["Grand Total",5321966.0876257494,7413684.9273078861,12070280.659868181]

{"sheet":"Cost-New Gensets","index":4,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,2,0,3],[2,2,3,3]]}
[null,null,"Prices 2016 - Kenya"]
[null,null,"Genset Model (Perkins)","Genset Only Price (KES)"]
[null,null,"Note: Number Denotes KVA e.g. JP12.5 is a 12.5kVA generator"]
[]
[null,null,"5kVA",5800]
[null,null,"6.5kVA",7010]
[null,null,"10 kVA",7000]
[null,null,"JP12.5 (DSE)",902500]
[null,null,"JP15 (DSE)",956100]
[null,null,"JP20 (DSE)",993300]
[null,null,"JP30 (DSE)",1183100]
[null,null,"JP45 (DSE)",1364200]
[null,null,"JP60 (DSE)",1498300]
[null,null,"JP80 (DSE)",1657000]
[null,null,"JP100 (DSE)",2063900]
[null,null,"JP135 (DSE)",2418400]
[null,null,"JP150 (DSE)",2647700]
[null,null,"JP200 (DSE)",3969800]
[null,null,"JP250 (DSE)",4373500]
[null,null,"JP300 (DSE)",5256800]
[null,null,"JP350 (DSE)",5724800]
[null,null,"JP400 (DSE)",6333200]
[null,null,"JP450 (DSE)",6917000]
[null,null,"JP500 (DSE)",7357000]
[null,null,"JP600 (DSE)",10010100]

{"sheet":"Fuel Consumption","index":5,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,1],[1,2,1,5]]}
["Genset Fuel Consumption chart"]
["Generator",null,"Liter/hour"]
["kVA","kW","Load 25%","Load 50%","Load 75%","Load 100%"]
[25,{"$f":"A4*0.8","v":20},2.2999999999999998,3.4,4.9000000000000004,6]
[38,30.400000000000002,4.2,6.8,9.1,11]
[50,40,6,8.6999999999999993,12.1,15.1]
[75,60,6.8,11,14.4,18.100000000000001]
[94,75.2,9.1,12.9,17.399999999999999,23.1]
[125,100,9.8000000000000007,15.5,21.9,28]
[156,124.80000000000001,11.7,18.899999999999999,26.8,34.4]
[169,135.20000000000002,12.5,20.399999999999999,28.7,37]
[188,150.4,13.6,22.3,31.8,41.2]
[219,175.20000000000002,15.5,25.7,36.700000000000003,48]
[250,200,17.100000000000001,29.1,41.6,54.4]
[288,230.4,20,33.299999999999997,47.3,62.7]
[313,250.4,21.6,35.9,51.4,68]
[375,300,25.7,42.7,60.9,81.3]
[438,350.40000000000003,29.9,49.5,70.7,94.9]
[500,400,33.6,56.3,80.5,108.1]
[625,500,41.6,69.900000000000006,99.8,134.9]
[750,600,49.9,83.2,119.1,161.80000000000001]
[938,750.40000000000009,61.6,103.6,148.6,201.9]
[1250,1000,81.599999999999994,137.6,196.9,268.8]
[1563,1250.4000000000001,101.7,171.2,245.7,335.7]
[1875,1500,121.7,205.3,294.10000000000002,402.6]
[2188,1750.4,141.80000000000001,238.9,342.8,469.5]
[2500,2000,161.80000000000001,272.89999999999998,391.5,536.4]
[2813,2250.4,181.8,306.60000000000002,440,603.29999999999995]