{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","0 EXAMPLE","1 Reference Cost for Generators","2 Generator Fuel Consumption","3 Generator System","4 Solar System","5 Graph"],"not_rendered":{"charts":2,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"Instructions","index":0,"n_rows":42,"n_cols":1,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["How to use this tool"]
[]
[]
[]
["Introduction: This tool is intended to be used in order to compare the costs of buying, running and servicing a water scheme with a diesel generator vs an equivalent stand alone solar pumping solution."]
["Costs are estimated for a period of 25 years (lifespan of solar panels, the longest of all components)."]
["Costs that are common for both systems (e.g. salary of a guard for the water scheme) have been taken out, since they would have no impact in the cost comparision analysis."]
["Costs are calculated including pumping equipement (pump, genertor, solar panels, invertor and accessories). By adding additional columns, other costs could be included in the analysis if necessary."]
["Before proceeding to use the tool, read the Word document 'Technical Briefing - Ecoonomic Assessment', where principles of Net Present Value analysis are explained."]
[]
["Tab 0: 'EXAMPLE'"]
["An example of a real field case with costs for solar and generator system components is given an worked out through Tabs 3 to 5"]
[]
[]
["Tab 1: 'Reference Costs for Generators'"]
["Costs of Generators are given on table on the left. Get prices of generators for your particular country/ location"]
[]
["Cost of Generator servicing is given on table on the right. Different servicing costs are given depending on the working hours of the generator and the quality of brand (high or low). "]
["Thee prices are used in the cost calculation under tab 'Generator System'. Use these prices as a reference, unless you have a more accurate information on the costs for mainting a generator in your location."]
[]
[]
["Tab 2: 'Generator Fuel Consumption'"]
["This table is a refernce for fuel consumption. Iedally your generator should be sized to work at 75% of its load and so you should use fuel consumption data from the 75% column."]
["If this is not the case or you have real data from the field, feel free to use the consumption you believe is closer to reality. This data will be used in tab 'Generator System'."]
[]
[]
["Tab 3: 'Generator System'"]
["In this tab total costs for buying, operating, maintaing and replacing the generator will be estimated for a period of 25 years."]
["Fill only the cells in yellow."]
["Get discount factor for your country at http://data.worldbank.org/indicator/FR.INR.RINR?year_high_desc=false or in the Annex a of the Word document 'Technical Briefing - Economic Assessment'."]
["The cost of 1L of fuel should compromise costs to buy, store and transport fuel to the water scheme site."]
[]
[]
["Tab 4: 'Solar System'"]
["In this tab total costs for buying, operating, maintaing and replacing the solar pumping system will be estimated for a period of 25 years."]
["Fill only the cells in yellow."]
["Cost of Solar Pumpin gsolution should include all costs involved to buy and install the solar system (including invertor)."]
["Preventive and minor service (like cleaning and 1 or 2 visits of contractor technician to the field for preventive maintenance) is estimated at a flat rate of 1,500USD. Feel free to change I ncase rea ldata are avaible."]
[]
[]
["Tab 5: 'Graph'"]
["A comparative graph is automatically generated. Get the Return on Investment (point were both lines cross) and the costs saving (difference between the 2 lines after 25 years) as main information."]

{"sheet":"0 EXAMPLE","index":1,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,14,10,20],[5,8,5,9],[5,14,5,20],[6,8,6,9],[6,14,6,20],[7,8,7,9],[7,14,7,20],[13,14,13,20],[14,8,14,12],[3,8,3,13],[3,0,3,4],[5,0,5,2],[6,0,6,2],[8,0,8,2],[9,0,9,2],[11,8,11,9],[11,14,11,20],[12,8,12,9],[12,14,12,20],[8,8,8,9],[8,14,8,20],[9,8,9,9],[9,14,9,20],[7,0,7,2],[10,0,10,2],[11,0,11,2],[12,0,12,4],[13,8,13,9],[10,8,10,9]]}
[]
[]
[]
["DIESEL GENERATOR STAND ALONE SYSTEM",{"$nulls":7},"EQUIVALENT SOLAR STAND ALONE SYSTEM"]
[]
["Component",null,null,"Unit","Qty","Total Price (USD)",null,null,"Component",null,"Unit","Qty","Unit Price","Total Price (USD)"]
["Pump",null,null,"Watt",7500,{"$f":"N7","v":4878.5714285714284},null,null,"Pump",null,"Watt",7500,0.65047619047619043,{"$f":"M7*L7","v":4878.5714285714284}]
["Generator",null,null,"kVA",20,{"$f":"9500","v":9500},null,null,"Inverter",null,"Watt",{"$f":"L7","v":7500},0.27,{"$f":"M8*L8","v":2025.0000000000002}]
["Electrical Connection Board",null,null,"Unit",1,1850,null,null,"Solar Modules ",null,"Watt",14580,0.99206349206349198,14464.285714285714]
["Cables & Low level",null,null,"m",150,{"$f":"1400","v":1400},null,null,"DC Accessories ",null,"Watt",{"$f":"L9","v":14580},0.16352380952380954,2384.1771428571433]
["Transport",null,null,"km",{"$f":"785*2","v":1570},2700,null,null,"Cables & Low level",null,"m",150,11.773809523809524,1766.0714285714287]
["Installation",null,null,"Day",2,{"$f":"(5600/14)*2","v":800},null,null,"Support Structure ",null,"Watt",{"$f":"L9","v":14580},0.2469047619047619,3599.8714285714286]
["Total Price",{"$nulls":4},{"$f":"SUM(F7:F12)","v":21128.571428571428},null,null,"Transport",null,"km",{"$f":"785*2","v":1570},2.2799999999999998,3579.6]
[{"$nulls":8},"Installation",null,"Day",14,400,5600]
[{"$nulls":8},"Total Price",{"$nulls":4},{"$f":"SUM(N7:N14)","v":38297.577142857139}]
["Discount factor in country A = 12%"]
["Cost of 1 liter of diesel in USD:",null,null,1.1000000000000001,{"$nulls":4},"Discount factor in country A = 12%"]
["Consumption of diesel (l/h)",null,null,4.2,{"$nulls":4},"Consumption of diesel (l/h)",null,0]
["Running time of generator (hours/day): ",null,null,6.5,{"$nulls":4},"Running time of generator (hours/day): ",null,0]
["Safe Yield (m3/h):",null,null,20,{"$nulls":4},"Running time of solar (hours/day): ",null,"8h to 17h"]
["Daily water provided (m3/d):",null,null,130,{"$nulls":4},"Safe Yield (m3/h):",null,20]
[{"$nulls":8},"Daily water provided with solar (m3/h):",null,130]
[{"$nulls":8},"Daily water provided with generator (m3/h):",null,0]

{"sheet":"1 Reference Cost for Generators","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,4,0,8],[2,5,2,6],[2,7,2,8]]}
["Diesel Genset (Indicate Brand)",null,"Prices in SS  (USD)",null,"General Reference for Maintenance of Gensets"]
[12.5,"kVA",4500]
[15,"kVA",7000,null,"Genset Maintenance","Good Quality Engine",null,"Low Quality Engine"]
[20,"kVA",10000,null,"Maintenance and Replacement","Frequency of change (h)","Price (USD)","Frequency (hours)","Price (USD)"]
[30,"kVA",12000,null,"Minor Service",250,20,250,20]
[45,"kVA",15000,null,"Major Service",1000,180,1000,125]
[65,"kVA",20000,null,"Overhaul",10000,"30% of new",5000,"60% of new"]
[80,"kVA",30000,null,"Replacement",35000,"See 'Cost of New Gensets'",10000,"See 'Cost of New Gensets'"]
[100,"kVA",40000]

{"sheet":"2 Generator Fuel Consumption","index":3,"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]

{"sheet":"3 Generator System","index":4,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Discount factor (d)",0.12]
["Capital Cost of Generator (USD)",9500]
["Cost of total Generator System (including capita cost of generator, transport, installation and others)",21129]
["Cost of 1 L of fuel (USD)",1.1000000000000001]
["Year","Cost of total generator system","Generator Working time (hours/year)","Cumulative hours for overhaul","Cumulative hours for replacement","Minor Service","Major Service","Fuel Consumption (l/h)","Cost of fuel","Overhaul","Replacement","Pr Factor","Total Costs in Present Worth (USD)"]
[{"$nulls":5},"20 USD every 250h","180 USD  every 1000h",null,null,"30% genset cost every 10,000h","New genset every 35,000h","Pr = 1/(1+d)N","PW = Cr*Pr"]
[0,{"$f":"B3","v":21129},{"$f":"6.5*365","v":2372.5},{"$f":"C7","v":2372.5},{"$f":"C7","v":2372.5},{"$f":"(C7/250)*20","v":189.8},{"$f":"(C7/1000)*180","v":427.05},4.2,{"$f":"C7*H7*B4","v":10960.95},null,null,{"$f":"1/(1+$B$1)^A7","v":1},{"$f":"L7*(B7+F7+G7+I7+J7+K7)","v":32706.799999999999}]
[1,null,{"$f":"C7","v":2372.5},{"$f":"IF(K8=0,IF(D7+C8>10000,D7+C8-10000,D7+C8),E8)","v":4745},{"$f":"IF(E7+C8>35000,E7+C8-35000,E7+C8)","v":4745},189.8,427.05,null,{"$f":"I7","v":10960.95},{"$f":"IF($D7+$C8>10000,$B$2*0.3,0)","v":0},{"$f":"IF($E7+$C8>35000,$B$2,0)","v":0},0.89285714285714279,{"$f":"L8*(F8+G8+I8+J8+K8)","v":10337.321428571429}]
[2,null,{"$f":"C8","v":2372.5},7117.5,7117.5,189.8,427.05,null,{"$f":"I8","v":10960.95},{"$f":"IF($D8+$C9>10000,$B$2*0.3,0)","v":0},{"$f":"IF($E8+$C9>35000,$B$2,0)","v":0},0.79719387755102034,9229.7512755102034]
[3,null,2372.5,9490,9490,189.8,427.05,null,10960.95,0,0,0.71178024781341087,8240.8493531341101]
[4,null,2372.5,1862.5,11862.5,189.8,427.05,null,10960.95,2850,0,0.63551807840483121,9169.1277316092237]
[5,null,2372.5,4235,14235,189.8,427.05,null,10960.95,0,0,0.56742685571859919,6569.554650138798]
[6,null,2372.5,6607.5,16607.5,189.8,427.05,null,10960.95,0,0,0.50663112117732068,5865.6737947667834]
[7,null,2372.5,8980,18980,189.8,427.05,null,10960.95,0,0,0.45234921533689343,5237.2087453274853]
[8,null,2372.5,1352.5,21352.5,189.8,427.05,null,10960.95,2850,0,0.4038832279793691,5827.1464366407417]
[9,null,2372.5,3725,23725,189.8,427.05,null,10960.95,0,0,0.36061002498157957,4175.0707472317326]
[10,null,2372.5,{"$f":"IF(K17=0,IF(D16+C17>10000,D16+C17-10000,D16+C17),E17)","v":6097.5},26097.5,189.8,427.05,null,10960.95,0,0,0.32197323659069599,3727.7417385997605]
[11,null,2372.5,8470,28470,189.8,427.05,null,10960.95,0,0,0.28747610409883567,3328.3408380354999]
[12,null,2372.5,842.5,30842.5,189.8,427.05,null,10960.95,2850,0,0.25667509294538904,3703.2569059974844]
[13,null,2372.5,3215,33215,189.8,427.05,null,10960.95,0,0,0.22917419012981158,2653.3329384849326]
[14,null,2372.5,587.5,587.5,189.8,427.05,null,10960.95,0,9500,0.20461981261590317,4312.9354863554845]
[15,null,2372.5,2960,2960,189.8,427.05,null,10960.95,0,0,0.18269626126419927,2115.2207736646465]
[16,null,2372.5,5332.5,5332.5,189.8,427.05,null,10960.95,0,0,0.16312166184303503,1888.5899764862911]
[17,null,2372.5,7705,7705,189.8,427.05,null,10960.95,0,0,0.14564434093128129,1686.2410504341885]
[18,null,2372.5,77.5,10077.5,189.8,427.05,null,10960.95,2850,0,0.13003959011721541,1876.1851982931607]
[19,null,2372.5,2450,12450,189.8,427.05,null,10960.95,0,0,0.1161067768903709,1344.2610414813364]
[20,null,2372.5,4822.5,14822.5,189.8,427.05,null,10960.95,0,0,0.1036667650806883,1200.233072751193]
[21,null,2372.5,7195,17195,189.8,427.05,null,10960.95,0,0,9.2559611679185971E-2,1071.6366720992794]
[22,null,2372.5,9567.5,19567.5,189.8,427.05,null,10960.95,0,0,8.2642510427844609E-2,956.81845723149945]
[23,null,2372.5,1940,21940,189.8,427.05,null,10960.95,2850,0,7.3787955739146982E-2,1064.5978678132649]
[24,null,2372.5,4312.5,24312.5,189.8,427.05,null,10960.95,0,0,6.5882103338524081E-2,762.7698160327642]
[]
[{"$nulls":11},"TOTAL COST",{"$f":"SUM(M7:M32)","v":129050.66599669128}]

{"sheet":"4 Solar System","index":5,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Discount factor (d)",0.12]
["Cost of solar pumping solution (USD)",38298]
["Cost of Invertor (USD)",2025]
["Year","Capital Cost","Preventive and Minor Service and ","Major Service","Fuel Consumption (l/h)","Cost of fuel","Overhaul","Replacement of Invertor","Pr Factor","Total Costs in Present Worth (USD)"]
[null,null,"Cleaning","_",null,null,"_","Every 7 years","Pr = 1/(1+d)^N","PW = Cr*Pr"]
[0,{"$f":"B2","v":38298},1500,0,0,0,null,null,{"$f":"1/(1+$B$1)^A6","v":1},{"$f":"I6*(B6+C6+D6+F6+G6+H6)","v":39798}]
[1,null,{"$f":"C6","v":1500},{"$f":"D6","v":0},null,{"$f":"F6","v":0},null,null,{"$f":"1/(1+$B$1)^A7","v":0.89285714285714279},{"$f":"I7*(C7+D7+F7+G7+H7)","v":1339.2857142857142}]
[2,null,{"$f":"C7","v":1500},{"$f":"D7","v":0},null,{"$f":"F7","v":0},null,null,0.79719387755102034,1195.7908163265306]
[3,null,1500,0,null,0,null,null,0.71178024781341087,1067.6703717201162]
[4,null,1500,0,null,0,null,null,0.63551807840483121,953.27711760724685]
[5,null,1500,0,null,0,null,null,0.56742685571859919,851.1402835778988]
[6,null,1500,0,null,0,null,{"$f":"B3","v":2025},0.50663112117732068,1785.8747021500553]
[7,null,1500,0,null,0,null,null,0.45234921533689343,678.52382300534009]
[8,null,1500,0,null,0,null,null,0.4038832279793691,605.82484196905364]
[9,null,1500,0,null,0,null,null,0.36061002498157957,540.91503747236936]
[10,null,1500,0,null,0,null,null,0.32197323659069599,482.95985488604396]
[11,null,1500,0,null,0,null,null,0.28747610409883567,431.21415614825349]
[12,null,1500,0,null,0,null,null,0.25667509294538904,385.01263941808355]
[13,null,1500,0,null,0,null,{"$f":"B3","v":2025},0.22917419012981158,807.8390202075858]
[14,null,1500,0,null,0,null,null,0.20461981261590317,306.92971892385475]
[15,null,1500,0,null,0,null,null,0.18269626126419927,274.04439189629892]
[16,null,1500,0,null,0,null,null,0.16312166184303503,244.68249276455253]
[17,null,1500,0,null,0,null,null,0.14564434093128129,218.46651139692193]
[18,null,1500,0,null,0,null,null,0.13003959011721541,195.05938517582311]
[19,null,1500,0,null,0,null,null,0.1161067768903709,174.16016533555634]
[20,null,1500,0,null,0,null,null,0.1036667650806883,155.50014762103245]
[21,null,1500,0,null,0,null,{"$f":"B3","v":2025},9.2559611679185971E-2,326.27263116913053]
[22,null,1500,0,null,0,null,null,8.2642510427844609E-2,123.96376564176691]
[23,null,1500,0,null,0,null,null,7.3787955739146982E-2,110.68193360872047]
[24,null,1500,0,null,0,null,null,6.5882103338524081E-2,98.823155007786127]
[]
[{"$nulls":8},"TOTAL COST",{"$f":"SUM(J6:J31)","v":53151.91267731574}]

{"sheet":"5 Graph","index":6,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Cumulative Cost"]
[]
["Year","Generator","Solar"]
[0,{"$f":"'3 Generator System'!B7","v":21129},{"$f":"'4 Solar System'!B6","v":38298}]
[1,{"$f":"'3 Generator System'!M7","v":32706.799999999999},{"$f":"'4 Solar System'!J6","v":39798}]
[2,{"$f":"B5+'3 Generator System'!M8","v":43044.12142857143},{"$f":"C5+'4 Solar System'!J7","v":41137.285714285717}]
[3,{"$f":"B6+'3 Generator System'!M9","v":52273.87270408163},{"$f":"C6+'4 Solar System'!J8","v":42333.076530612248},{"$nulls":9},"Costs saved with solar after 5 years:",null,null,{"$f":"B9-C9","v":25329.825768885356}]
[4,{"$f":"B7+'3 Generator System'!M10","v":60514.722057215738},{"$f":"C7+'4 Solar System'!J9","v":43400.746902332365}]
[5,{"$f":"B8+'3 Generator System'!M11","v":69683.849788824969},{"$f":"C8+'4 Solar System'!J10","v":44354.024019939614},{"$nulls":9},"Costs saved with solar after 10 years:",null,null,{"$f":"B14-C14","v":48542.20145481619}]
[6,{"$f":"B9+'3 Generator System'!M12","v":76253.404438963771},{"$f":"C9+'4 Solar System'!J11","v":45205.164303517515}]
[7,{"$f":"B10+'3 Generator System'!M13","v":82119.078233730557},{"$f":"C10+'4 Solar System'!J12","v":46991.039005667568},{"$nulls":9},"Costs saved with solar after 25 years:",null,null,{"$f":"B29-C29","v":75898.753319375537}]
[8,{"$f":"B11+'3 Generator System'!M14","v":87356.286979058044},{"$f":"C11+'4 Solar System'!J13","v":47669.562828672904}]
[9,{"$f":"B12+'3 Generator System'!M15","v":93183.43341569879},{"$f":"C12+'4 Solar System'!J14","v":48275.387670641961}]
[10,{"$f":"B13+'3 Generator System'!M16","v":97358.50416293052},{"$f":"C13+'4 Solar System'!J15","v":48816.30270811433}]
[11,{"$f":"B14+'3 Generator System'!M17","v":101086.24590153027},{"$f":"C14+'4 Solar System'!J16","v":49299.262563000375}]
[12,{"$f":"B15+'3 Generator System'!M18","v":104414.58673956577},{"$f":"C15+'4 Solar System'!J17","v":49730.476719148632}]
[13,{"$f":"B16+'3 Generator System'!M19","v":108117.84364556325},{"$f":"C16+'4 Solar System'!J18","v":50115.489358566716}]
[14,{"$f":"B17+'3 Generator System'!M20","v":110771.17658404818},{"$f":"C17+'4 Solar System'!J19","v":50923.328378774298}]
[15,{"$f":"B18+'3 Generator System'!M21","v":115084.11207040367},{"$f":"C18+'4 Solar System'!J20","v":51230.258097698155}]
[16,{"$f":"B19+'3 Generator System'!M22","v":117199.33284406833},{"$f":"C19+'4 Solar System'!J21","v":51504.302489594455}]
[17,{"$f":"B20+'3 Generator System'!M23","v":119087.92282055461},{"$f":"C20+'4 Solar System'!J22","v":51748.984982359005}]
[18,{"$f":"B21+'3 Generator System'!M24","v":120774.16387098879},{"$f":"C21+'4 Solar System'!J23","v":51967.451493755929}]
[19,{"$f":"B22+'3 Generator System'!M25","v":122650.34906928195},{"$f":"C22+'4 Solar System'!J24","v":52162.510878931753}]
[20,{"$f":"B23+'3 Generator System'!M26","v":123994.61011076329},{"$f":"C23+'4 Solar System'!J25","v":52336.671044267307}]
[21,{"$f":"B24+'3 Generator System'!M27","v":125194.84318351447},{"$f":"C24+'4 Solar System'!J26","v":52492.171191888337}]
[22,{"$f":"B25+'3 Generator System'!M28","v":126266.47985561375},{"$f":"C25+'4 Solar System'!J27","v":52818.443823057467}]
[23,{"$f":"B26+'3 Generator System'!M29","v":127223.29831284525},{"$f":"C26+'4 Solar System'!J28","v":52942.407588699236}]
[24,{"$f":"B27+'3 Generator System'!M30","v":128287.89618065851},{"$f":"C27+'4 Solar System'!J29","v":53053.089522307957}]
[25,{"$f":"B28+'3 Generator System'!M31","v":129050.66599669128},{"$f":"C28+'4 Solar System'!J30","v":53151.91267731574}]