{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","0 EXAMPLE","1 Reference Cost for Generators","2 Generator Fuel Consumption","3 Generator System","4 Solar (Hybrid)","5 Generator (Hybrid)","6 Hybrid (Solar & Generator)","7 Graph"],"not_rendered":{"charts":2,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":52,"n_cols":1,"rows_kept":52,"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 equipemnt (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 generator and hybrid system components is given an worked out through Tabs 3 to 5"]
[]
[]
["Tab 1: 'Reference Costs for Generators'"]
["Costs of Generators for Juba (South Sudan) 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 (Hybrid)'"]
["In this tab total costs for buying, operating, maintaing and replacing the solar pumping part of the hybrid system will be estimated for a period of 25 years."]
["Fill only the cells in yellow."]
["Cost of Solar Pumping solution 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: 'Generator (Hybrid)'"]
["In this tab total costs for buying, operating, maintaing and replacing the generator pumping part of the hybrid system will be estimated for a period of 25 years."]
["Normally, the only difference with Tab 3 should be the annual working hours of the generator, that will be less than in Tab 3 since the solar part of the hybrid system will take over the generator during the solar day."]
["Fill only the cells in yellow."]
[]
[]
["Tab 6: 'Hybrid (Solar & Generator)'"]
["In this Tab costs for solar and generator parts of the hybrid systems are add up."]
[]
[]
["Tab 7: '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":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,0,6,2],[6,8,6,9],[6,14,6,20],[3,0,3,4],[3,8,3,13],[5,0,5,2],[5,8,5,9],[5,14,5,20],[7,0,7,2],[7,8,7,9],[7,14,7,20],[8,0,8,2],[8,8,8,9],[8,14,8,20],[9,0,9,2],[9,8,9,9],[9,14,9,20],[10,0,10,2],[10,8,10,9],[10,14,10,20],[13,8,13,9],[13,14,13,20],[14,8,14,12],[28,8,28,9],[11,0,11,2],[11,8,11,9],[11,14,11,20],[12,0,12,4],[12,8,12,9],[12,14,12,20]]}
[]
[]
[]
["DIESEL GENERATOR STAND ALONE SYSTEM",{"$nulls":7},"EQUIVALENT HYBRID (SOLAR+GENERATOR) 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]
["Running time of generator (hours/day): ",null,null,11,{"$nulls":4},"Solar Pumping"]
["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,{"$f":"D19*D20","v":220},{"$nulls":4},"Safe Yield (m3/h):",null,20]
[{"$nulls":8},"Daily water provided with solar (m3/h):",null,130]
[]
[{"$nulls":8},"Generator Pumping"]
[{"$nulls":8},"Consumption of diesel (l/h)",null,4.2]
[{"$nulls":8},"Running time of generator (hours/day): ",null,{"$f":"(D21-K22)/K21","v":4.5}]
[{"$nulls":8},"Daily water provided with generator (m3/h):",null,{"$f":"K21*K26","v":90}]
[]
[{"$nulls":8},"Total Daily water provided by Hybrid system (Solar + Generator) in m3/d:",null,{"$f":"K22+K27","v":220}]

{"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 Juba (USD)",null,"General Reference for Maintenance of Gensets"]
[12.5,"kVA",4500]
[15,"kVA",6000,null,"Genset Maintenance","Good Quality Engine",null,"Low Quality Engine"]
[20,"kVA",12000,null,"Maintenance and Replacement","Frequency of change (h)","Price (USD)","Frequency (hours)","Price (USD)"]
[30,"kVA",18500,null,"Minor Service",250,20,250,20]
[45,"kVA",22500,null,"Major Service",1000,180,1000,125]
[60,"kVA",30000,null,"Overhaul",10000,"30% of new",5000,"60% of new"]
[80,"kVA",34000,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":"11*365","v":4015},{"$f":"C7","v":4015},{"$f":"C7","v":4015},{"$f":"(C7/250)*20","v":321.2},{"$f":"(C7/1000)*180","v":722.69999999999993},4.2,{"$f":"C7*H7*B4","v":18549.300000000003},null,null,{"$f":"1/(1+$B$1)^A7","v":1},{"$f":"L7*(B7+F7+G7+I7+J7+K7)","v":40722.200000000004}]
[1,null,{"$f":"C7","v":4015},{"$f":"IF(K8=0,IF(D7+C8>10000,D7+C8-10000,D7+C8),E8)","v":8030},{"$f":"IF(E7+C8>35000,E7+C8-35000,E7+C8)","v":8030},321.2,722.69999999999993,null,{"$f":"I7","v":18549.300000000003},{"$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":17493.928571428572}]
[2,null,{"$f":"C8","v":4015},2045,12045,321.2,722.69999999999993,null,{"$f":"I8","v":18549.300000000003},{"$f":"IF($D8+$C9>10000,$B$2*0.3,0)","v":2850},{"$f":"IF($E8+$C9>35000,$B$2,0)","v":0},0.79719387755102034,17891.581632653062]
[3,null,4015,6060,16060,321.2,722.69999999999993,null,18549.300000000003,0,0,0.71178024781341087,13946.052751457724]
[4,null,4015,75,20075,321.2,722.69999999999993,null,18549.300000000003,2850,0,0.63551807840483121,14263.05933725531]
[5,null,4015,4090,24090,321.2,722.69999999999993,null,18549.300000000003,0,0,0.56742685571859919,11117.707869465659]
[6,null,4015,8105,28105,321.2,722.69999999999993,null,18549.300000000003,0,0,0.50663112117732068,9926.5248834514823]
[7,null,4015,2120,32120,321.2,722.69999999999993,null,18549.300000000003,2850,0,0.45234921533689343,10152.163909648969]
[8,null,4015,1135,1135,321.2,722.69999999999993,null,18549.300000000003,0,9500,0.4038832279793691,11750.255528249383]
[9,null,4015,5150,5150,321.2,722.69999999999993,null,18549.300000000003,0,0,0.36061002498157957,7065.5043414690863]
[10,null,4015,{"$f":"IF(K17=0,IF(D16+C17>10000,D16+C17-10000,D16+C17),E17)","v":9165},9165,321.2,722.69999999999993,null,18549.300000000003,0,0,0.32197323659069599,6308.4860191688258]
[11,null,4015,3180,13180,321.2,722.69999999999993,null,18549.300000000003,2850,0,0.28747610409883567,6451.8836995109896]
[12,null,4015,7195,17195,321.2,722.69999999999993,null,18549.300000000003,0,0,0.25667509294538904,5029.0864310975976]
[13,null,4015,1210,21210,321.2,722.69999999999993,null,18549.300000000003,2850,0,0.22917419012981158,5143.4021839213883]
[14,null,4015,5225,25225,321.2,722.69999999999993,null,18549.300000000003,0,0,0.20461981261590317,4009.156912545915]
[15,null,4015,9240,29240,321.2,722.69999999999993,null,18549.300000000003,0,0,0.18269626126419927,3579.60438620171]
[16,null,4015,3255,33255,321.2,722.69999999999993,null,18549.300000000003,2850,0,0.16312166184303503,3660.9720810756044]
[17,null,4015,2270,2270,321.2,722.69999999999993,null,18549.300000000003,0,9500,0.14564434093128129,4237.2599395819534]
[18,null,4015,6285,6285,321.2,722.69999999999993,null,18549.300000000003,0,0,0.13003959011721541,2547.8916970846258]
[19,null,4015,300,10300,321.2,722.69999999999993,null,18549.300000000003,2850,0,0.1161067768903709,2605.8076151059727]
[20,null,4015,4315,14315,321.2,722.69999999999993,null,18549.300000000003,0,0,0.1036667650806883,2031.1636615789423]
[21,null,4015,8330,18330,321.2,722.69999999999993,null,18549.300000000003,0,0,9.2559611679185971E-2,1813.5389835526271]
[22,null,4015,2345,22345,321.2,722.69999999999993,null,18549.300000000003,2850,0,8.2642510427844609E-2,1854.7623900342026]
[23,null,4015,6360,26360,321.2,722.69999999999993,null,18549.300000000003,0,0,7.3787955739146982E-2,1445.7421743882551]
[24,null,4015,375,30375,321.2,722.69999999999993,null,18549.300000000003,2850,0,6.5882103338524081E-2,1478.6052216471639]
[]
[{"$nulls":11},"TOTAL COST",{"$f":"SUM(M7:M32)","v":206526.342221575}]

{"sheet":"4 Solar (Hybrid)","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},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,{"$f":"C23","v":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 Generator (Hybrid)","index":6,"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":"4.5*365","v":1642.5},{"$f":"C7","v":1642.5},{"$f":"C7","v":1642.5},{"$f":"(C7/250)*20","v":131.4},{"$f":"(C7/1000)*180","v":295.65000000000003},4.2,{"$f":"C7*H7*B4","v":7588.35},null,null,{"$f":"1/(1+$B$1)^A7","v":1},{"$f":"L7*(B7+F7+G7+I7+J7+K7)","v":29144.400000000001}]
[1,null,{"$f":"C7","v":1642.5},{"$f":"IF(K8=0,IF(D7+C8>10000,D7+C8-10000,D7+C8),E8)","v":3285},{"$f":"IF(E7+C8>35000,E7+C8-35000,E7+C8)","v":3285},131.4,295.65000000000003,null,{"$f":"I7","v":7588.35},{"$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":7156.6071428571431}]
[2,null,{"$f":"C8","v":1642.5},4927.5,4927.5,131.4,295.65000000000003,null,{"$f":"I8","v":7588.35},{"$f":"IF($D8+$C9>10000,$B$2*0.3,0)","v":0},{"$f":"IF($E8+$C9>35000,$B$2,0)","v":0},0.79719387755102034,6389.8278061224491]
[3,null,1642.5,6570,6570,131.4,295.65000000000003,null,7588.35,0,0,0.71178024781341087,5705.2033983236142]
[4,null,1642.5,8212.5,8212.5,131.4,295.65000000000003,null,7588.35,0,0,0.63551807840483121,5093.9316056460848]
[5,null,1642.5,9855,9855,131.4,295.65000000000003,null,7588.35,0,0,0.56742685571859919,4548.1532193268604]
[6,null,1642.5,1497.5,11497.5,131.4,295.65000000000003,null,7588.35,2850,0,0.50663112117732068,5504.7497840400611]
[7,null,1642.5,3140,13140,131.4,295.65000000000003,null,7588.35,0,0,0.45234921533689343,3625.759900611336]
[8,null,1642.5,4782.5,14782.5,131.4,295.65000000000003,null,7588.35,0,0,0.4038832279793691,3237.2856255458355]
[9,null,1642.5,6425,16425,131.4,295.65000000000003,null,7588.35,0,0,0.36061002498157957,2890.4335942373532]
[10,null,1642.5,{"$f":"IF(K17=0,IF(D16+C17>10000,D16+C17-10000,D16+C17),E17)","v":8067.5},18067.5,131.4,295.65000000000003,null,7588.35,0,0,0.32197323659069599,2580.7442805690648]
[11,null,1642.5,9710,19710,131.4,295.65000000000003,null,7588.35,0,0,0.28747610409883567,2304.2359647938074]
[12,null,1642.5,1352.5,21352.5,131.4,295.65000000000003,null,7588.35,2850,0,0.25667509294538904,2788.8775548888302]
[13,null,1642.5,2995,22995,131.4,295.65000000000003,null,7588.35,0,0,0.22917419012981158,1836.9228035664919]
[14,null,1642.5,4637.5,24637.5,131.4,295.65000000000003,null,7588.35,0,0,0.20461981261590317,1640.1096460415104]
[15,null,1642.5,6280,26280,131.4,295.65000000000003,null,7588.35,0,0,0.18269626126419927,1464.3836125370628]
[16,null,1642.5,7922.5,27922.5,131.4,295.65000000000003,null,7588.35,0,0,0.16312166184303503,1307.485368336663]
[17,null,1642.5,9565,29565,131.4,295.65000000000003,null,7588.35,0,0,0.14564434093128129,1167.3976503005922]
[18,null,1642.5,1207.5,31207.5,131.4,295.65000000000003,null,7588.35,2850,0,0.13003959011721541,1412.9321624595925]
[19,null,1642.5,2850,32850,131.4,295.65000000000003,null,7588.35,0,0,0.1161067768903709,930.64225948707895]
[20,null,1642.5,4492.5,34492.5,131.4,295.65000000000003,null,7588.35,0,0,0.1036667650806883,830.93058882774903]
[21,null,1642.5,1135,1135,131.4,295.65000000000003,null,7588.35,0,9500,9.2559611679185971E-2,1621.218622405614]
[22,null,1642.5,2777.5,2777.5,131.4,295.65000000000003,null,7588.35,0,0,8.2642510427844609E-2,662.41277808334576]
[23,null,1642.5,4420,4420,131.4,295.65000000000003,null,7588.35,0,0,7.3787955739146982E-2,591.43998043155875]
[24,null,1642.5,6062.5,6062.5,131.4,295.65000000000003,null,7588.35,0,0,6.5882103338524081E-2,528.07141109960594]
[]
[{"$nulls":11},"TOTAL COST",{"$f":"SUM(M7:M32)","v":94964.156760539336}]

{"sheet":"6 Hybrid (Solar & Generator)","index":7,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Year","Hybrid (Solar + Generator) Present Worth (USD)"]
[]
[0,{"$f":"'5 Generator (Hybrid)'!M7+'4 Solar (Hybrid)'!J6","v":68942.399999999994}]
[1,{"$f":"'5 Generator (Hybrid)'!M8+'4 Solar (Hybrid)'!J7","v":8495.8928571428569}]
[2,{"$f":"'5 Generator (Hybrid)'!M9+'4 Solar (Hybrid)'!J8","v":7585.6186224489793}]
[3,{"$f":"'5 Generator (Hybrid)'!M10+'4 Solar (Hybrid)'!J9","v":6772.8737700437305}]
[4,{"$f":"'5 Generator (Hybrid)'!M11+'4 Solar (Hybrid)'!J10","v":6047.2087232533313}]
[5,{"$f":"'5 Generator (Hybrid)'!M12+'4 Solar (Hybrid)'!J11","v":5399.2935029047594}]
[6,{"$f":"'5 Generator (Hybrid)'!M13+'4 Solar (Hybrid)'!J12","v":7290.6244861901159}]
[7,{"$f":"'5 Generator (Hybrid)'!M14+'4 Solar (Hybrid)'!J13","v":4304.2837236166761}]
[8,{"$f":"'5 Generator (Hybrid)'!M15+'4 Solar (Hybrid)'!J14","v":3843.110467514889}]
[9,{"$f":"'5 Generator (Hybrid)'!M16+'4 Solar (Hybrid)'!J15","v":3431.3486317097227}]
[10,{"$f":"'5 Generator (Hybrid)'!M17+'4 Solar (Hybrid)'!J16","v":3063.7041354551088}]
[11,{"$f":"'5 Generator (Hybrid)'!M18+'4 Solar (Hybrid)'!J17","v":2735.4501209420609}]
[12,{"$f":"'5 Generator (Hybrid)'!M19+'4 Solar (Hybrid)'!J18","v":3173.8901943069136}]
[13,{"$f":"'5 Generator (Hybrid)'!M20+'4 Solar (Hybrid)'!J19","v":2644.7618237740776}]
[14,{"$f":"'5 Generator (Hybrid)'!M21+'4 Solar (Hybrid)'!J20","v":1947.0393649653652}]
[15,{"$f":"'5 Generator (Hybrid)'!M22+'4 Solar (Hybrid)'!J21","v":1738.4280044333618}]
[16,{"$f":"'5 Generator (Hybrid)'!M23+'4 Solar (Hybrid)'!J22","v":1552.1678611012155}]
[17,{"$f":"'5 Generator (Hybrid)'!M24+'4 Solar (Hybrid)'!J23","v":1385.8641616975142}]
[18,{"$f":"'5 Generator (Hybrid)'!M25+'4 Solar (Hybrid)'!J24","v":1607.9915476354156}]
[19,{"$f":"'5 Generator (Hybrid)'!M26+'4 Solar (Hybrid)'!J25","v":1104.8024248226352}]
[20,{"$f":"'5 Generator (Hybrid)'!M27+'4 Solar (Hybrid)'!J26","v":986.43073644878154}]
[21,{"$f":"'5 Generator (Hybrid)'!M28+'4 Solar (Hybrid)'!J27","v":1947.4912535747446}]
[22,{"$f":"'5 Generator (Hybrid)'!M29+'4 Solar (Hybrid)'!J28","v":786.3765437251127}]
[23,{"$f":"'5 Generator (Hybrid)'!M30+'4 Solar (Hybrid)'!J29","v":702.12191404027919}]
[24,{"$f":"'5 Generator (Hybrid)'!M31+'4 Solar (Hybrid)'!J30","v":626.89456610739205}]
[]
["Total Cost for Hybrid ",{"$f":"SUM(B3:B28)","v":148116.06943785507}]

{"sheet":"7 Graph","index":8,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Cumulative Cost"]
[]
["Year","Generator","Hybrid (Solar+Generator)"]
["0 (Capital costs)",{"$f":"'3 Generator System'!B3","v":21129},{"$f":"'4 Solar (Hybrid)'!B2+'5 Generator (Hybrid)'!B3","v":59427}]
[1,{"$f":"'3 Generator System'!M7","v":40722.200000000004},{"$f":"'4 Solar (Hybrid)'!J6+'5 Generator (Hybrid)'!M7","v":68942.399999999994}]
[2,{"$f":"B5+'3 Generator System'!M8","v":58216.128571428577},{"$f":"C5+'4 Solar (Hybrid)'!J7+'5 Generator (Hybrid)'!M8","v":77438.292857142849}]
[3,{"$f":"B6+'3 Generator System'!M9","v":76107.710204081639},{"$f":"C6+'4 Solar (Hybrid)'!J8+'5 Generator (Hybrid)'!M9","v":85023.911479591829}]
[4,{"$f":"B7+'3 Generator System'!M10","v":90053.762955539365},{"$f":"C7+'4 Solar (Hybrid)'!J9+'5 Generator (Hybrid)'!M10","v":91796.785249635563}]
[5,{"$f":"B8+'3 Generator System'!M11","v":104316.82229279468},{"$f":"C8+'4 Solar (Hybrid)'!J10+'5 Generator (Hybrid)'!M11","v":97843.993972888886},{"$nulls":10},"Costs saved with solar after 5 years:",null,null,{"$f":"B9-C9","v":6472.8283199057914}]
[6,{"$f":"B9+'3 Generator System'!M12","v":115434.53016226034},{"$f":"C9+'4 Solar (Hybrid)'!J11+'5 Generator (Hybrid)'!M12","v":103243.28747579365}]
[7,{"$f":"B10+'3 Generator System'!M13","v":125361.05504571182},{"$f":"C10+'4 Solar (Hybrid)'!J12+'5 Generator (Hybrid)'!M13","v":110533.91196198377},{"$nulls":10},"Costs saved with solar after 10 years:",null,null,{"$f":"B14-C14","v":32216.3240402542}]
[8,{"$f":"B11+'3 Generator System'!M14","v":135513.21895536079},{"$f":"C11+'4 Solar (Hybrid)'!J13+'5 Generator (Hybrid)'!M14","v":114838.19568560044}]
[9,{"$f":"B12+'3 Generator System'!M15","v":147263.47448361016},{"$f":"C12+'4 Solar (Hybrid)'!J14+'5 Generator (Hybrid)'!M15","v":118681.30615311532},{"$nulls":10},"Costs saved with solar after 25 years:",null,null,{"$f":"B29-C29","v":58410.272783720051}]
[10,{"$f":"B13+'3 Generator System'!M16","v":154328.97882507925},{"$f":"C13+'4 Solar (Hybrid)'!J15+'5 Generator (Hybrid)'!M16","v":122112.65478482505}]
[11,{"$f":"B14+'3 Generator System'!M17","v":160637.46484424808},{"$f":"C14+'4 Solar (Hybrid)'!J16+'5 Generator (Hybrid)'!M17","v":125176.35892028015}]
[12,{"$f":"B15+'3 Generator System'!M18","v":167089.34854375909},{"$f":"C15+'4 Solar (Hybrid)'!J17+'5 Generator (Hybrid)'!M18","v":127911.80904122222}]
[13,{"$f":"B16+'3 Generator System'!M19","v":172118.43497485667},{"$f":"C16+'4 Solar (Hybrid)'!J18+'5 Generator (Hybrid)'!M19","v":131085.69923552914}]
[14,{"$f":"B17+'3 Generator System'!M20","v":177261.83715877807},{"$f":"C17+'4 Solar (Hybrid)'!J19+'5 Generator (Hybrid)'!M20","v":133730.46105930323}]
[15,{"$f":"B18+'3 Generator System'!M21","v":181270.99407132398},{"$f":"C18+'4 Solar (Hybrid)'!J20+'5 Generator (Hybrid)'!M21","v":135677.50042426857}]
[16,{"$f":"B19+'3 Generator System'!M22","v":184850.59845752569},{"$f":"C19+'4 Solar (Hybrid)'!J21+'5 Generator (Hybrid)'!M22","v":137415.92842870191}]
[17,{"$f":"B20+'3 Generator System'!M23","v":188511.57053860129},{"$f":"C20+'4 Solar (Hybrid)'!J22+'5 Generator (Hybrid)'!M23","v":138968.09628980313}]
[18,{"$f":"B21+'3 Generator System'!M24","v":192748.83047818323},{"$f":"C21+'4 Solar (Hybrid)'!J23+'5 Generator (Hybrid)'!M24","v":140353.96045150064}]
[19,{"$f":"B22+'3 Generator System'!M25","v":195296.72217526785},{"$f":"C22+'4 Solar (Hybrid)'!J24+'5 Generator (Hybrid)'!M25","v":141961.95199913604}]
[20,{"$f":"B23+'3 Generator System'!M26","v":197902.52979037381},{"$f":"C23+'4 Solar (Hybrid)'!J25+'5 Generator (Hybrid)'!M26","v":143066.75442395866}]
[21,{"$f":"B24+'3 Generator System'!M27","v":199933.69345195274},{"$f":"C24+'4 Solar (Hybrid)'!J26+'5 Generator (Hybrid)'!M27","v":144053.18516040745}]
[22,{"$f":"B25+'3 Generator System'!M28","v":201747.23243550537},{"$f":"C25+'4 Solar (Hybrid)'!J27+'5 Generator (Hybrid)'!M28","v":146000.67641398218}]
[23,{"$f":"B26+'3 Generator System'!M29","v":203601.99482553959},{"$f":"C26+'4 Solar (Hybrid)'!J28+'5 Generator (Hybrid)'!M29","v":146787.05295770729}]
[24,{"$f":"B27+'3 Generator System'!M30","v":205047.73699992785},{"$f":"C27+'4 Solar (Hybrid)'!J29+'5 Generator (Hybrid)'!M30","v":147489.17487174756}]
[25,{"$f":"B28+'3 Generator System'!M31","v":206526.342221575},{"$f":"C28+'4 Solar (Hybrid)'!J30+'5 Generator (Hybrid)'!M31","v":148116.06943785495}]