{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Site informations","Turbine informations","Plant informations","Economic analysis","Simulation"],"not_rendered":{"charts":18,"images":11,"macros":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Site informations","index":0,"n_rows":110,"n_cols":13,"rows_kept":110}
["INPUT DATA"]
[]
["Site location",null,"Hydraulic measures"]
["Site name","makete","Gross project head [m]",{"v":18,"d":"18.00"}]
["Latitude",-9.444678,"Project head loss %",{"v":0.05,"d":"5%"}]
["Longitude",34.273215,"Minimum flow  [m^3/s]",{"v":2.8,"d":"2.80"}]
["Weir altitude above mean sea level [m]",1850,"Minimum gauge period","October"]
[null,null,"Maximum flow [m^3/s]",{"v":4,"d":"4.00"}]
[null,null,"Maximum gauge period","March"]
[null,null,"Residual flow %",{"v":0.1,"d":"10%"}]
[]
[]
["Hydrograph data"]
["Hydrograph input type","Computed_hydrograph_[m^3/s]"]
["Month","January","February","March","April","May","June","July","August","September","October","November ","December"]
["Hydrograph_data_[m^3/s]"]
["Rainfall data [l/m^2]",220,219,227,208,40,8,1,1,1,34,116,263]
[]
[]
["COMPUTATIONS"]
[]
["Net project head [m]",{"$f":"$D$4*(1-$D$5)","v":{"v":17.099999999999998,"d":"17.10"}}]
[]
["Rainfall to hydrograph"]
["Data counter",{"$f":"COLUMNS($B$17:$M$17)","v":{"v":12,"d":"12.00"}}]
["Rainfall annual average [l/m^2]",{"$f":"SUM($B$17:$M$17)/$B$25","v":{"v":111.5,"d":"111.50"}}]
["Month","January","February","March","April","May","June","July","August","September","October","November ","December"]
["Previous month rainfall Rate",{"$f":"M17/$B$26","v":{"v":2.3587443946188342,"d":"2.36"}},{"$f":"B17/$B$26","v":{"v":1.9730941704035874,"d":"1.97"}},{"$f":"C17/$B$26","v":{"v":1.9641255605381165,"d":"1.96"}},{"v":2.0358744394618835,"d":"2.04"},{"v":1.8654708520179373,"d":"1.87"},{"v":0.35874439461883406,"d":"0.36"},{"v":0.07174887892376682,"d":"0.07"},{"v":0.008968609865470852,"d":"0.01"},{"v":0.008968609865470852,"d":"0.01"},{"v":0.008968609865470852,"d":"0.01"},{"v":0.30493273542600896,"d":"0.30"},{"$f":"L17/$B$26","v":{"v":1.0403587443946187,"d":"1.04"}}]
["Computed_hydrograph_[m^3/s]",{"$f":"$B$30*B28^$B$31","v":{"v":4.048769235273436,"d":"4.05"}},{"$f":"$B$30*C28^$B$31","v":{"v":4.00121134124162,"d":"4.00"}},{"v":4.000005049323775,"d":"4.00"},{"v":4.009514778811374,"d":"4.01"},{"v":3.9863852348394038,"d":"3.99"},{"v":3.5742960293354016,"d":"3.57"},{"v":3.213136124952202,"d":"3.21"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":3.536055752083861,"d":"3.54"},{"v":3.8352561281016233,"d":"3.84"}]
["Estimated annual average flow [m^3/s]",{"$f":"$D$6/(HLOOKUP($D$7,$A$27:$M$29,2,FALSE))^$B$31","v":{"v":3.8252260619767724,"d":"3.83"}}]
["Corrective factor (rainfall to hydrograph)",{"v":0.06618509163562838,"d":"0.07"}]
["Goal seek cell",{"$f":"$D$8-HLOOKUP($D$9,$B$27:$M$29,3,FALSE)","v":{"v":-5.0493237750970366E-6,"d":"-0.00"}}]
[]
[]
["Hydrograph"]
["Month","January","February","March","April","May","June","July","August","September","October","November ","December"]
["Hydrograph [m^3/s]",{"$f":"IF($B$14=$A$16,B$16,B$29)","v":{"v":4.048769235273436,"d":"4.05"}},{"v":4.00121134124162,"d":"4.00"},{"v":4.000005049323775,"d":"4.00"},{"v":4.009514778811374,"d":"4.01"},{"v":3.9863852348394038,"d":"3.99"},{"v":3.5742960293354016,"d":"3.57"},{"v":3.213136124952202,"d":"3.21"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":3.536055752083861,"d":"3.54"},{"v":3.8352561281016233,"d":"3.84"}]
["Annual average flow [m^3/s]",{"$f":"SUM($B$37:$M$37)/$B$25","v":{"v":3.550385806163558,"d":"3.55"}}]
["Theoretical hydropower potential [kW]",{"$f":"B37*9.81*$D$4","v":{"v":714.9316715645834,"d":"714.93"}},{"$f":"C37*9.81*$D$4","v":{"v":706.5338986364453,"d":"706.53"}},{"v":706.3208916095922,"d":"706.32"},{"v":708.0001196425123,"d":"708.00"},{"v":703.9159047679419,"d":"703.92"},{"v":631.1491928600453,"d":"631.15"},{"v":567.3755769440598,"d":"567.38"},{"v":494.424,"d":"494.42"},{"v":494.424,"d":"494.42"},{"v":494.424,"d":"494.42"},{"v":624.3967247029683,"d":"624.40"},{"$f":"M37*9.81*$D$4","v":{"v":677.2295271001847,"d":"677.23"}}]
["Hydropower potential range (Max, Min, Min adjusted) [kW]",{"$f":"MAX($B$39:$M$39)","v":{"v":714.9316715645834,"d":"714.93"}},{"$f":"MIN($B$39:$M$39)","v":{"v":494.424,"d":"494.42"}},{"$f":"$C$40*0.7","v":{"v":346.0968,"d":"346.10"}}]
["Mean theoretical hydropower potential [kW]",{"$f":"$B$38*9.81*$D$4","v":{"v":626.927125652361,"d":"626.93"}}]
["Residual flow [m^3/s]",{"$f":"MIN($B$38*$D$10,B37)","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"MIN($B$38*$D$10,C37)","v":{"v":0.35503858061635585,"d":"0.36"}},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"}]
[]
[]
["SHEET OUTPUT"]
[]
[]
[]
[]
[]
[]
["Net project head [m]",{"$f":"$B$22","v":{"v":17.099999999999998,"d":"17.10"}}]
["Hydrograph [m^3/s]",{"$f":"B$37","v":{"v":4.048769235273436,"d":"4.05"}},{"$f":"C$37","v":{"v":4.00121134124162,"d":"4.00"}},{"v":4.000005049323775,"d":"4.00"},{"v":4.009514778811374,"d":"4.01"},{"v":3.9863852348394038,"d":"3.99"},{"v":3.5742960293354016,"d":"3.57"},{"v":3.213136124952202,"d":"3.21"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":3.536055752083861,"d":"3.54"},{"v":3.8352561281016233,"d":"3.84"}]
["Residual flow [m^3/s]",{"$f":"B42","v":{"v":0.35503858061635585,"d":"0.36"}},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"},{"v":0.35503858061635585,"d":"0.36"}]
["Flow Duration Curve [m^3/s]",{"v":4.048769235273436,"d":"4.05"},{"v":4.009514778811374,"d":"4.01"},{"v":4.00121134124162,"d":"4.00"},{"v":4.000005049323775,"d":"4.00"},{"v":3.9863852348394038,"d":"3.99"},{"v":3.8352561281016233,"d":"3.84"},{"v":3.5742960293354016,"d":"3.57"},{"v":3.536055752083861,"d":"3.54"},{"v":3.213136124952202,"d":"3.21"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"},{"v":2.8,"d":"2.80"}]
["Cumulative time percentage %",{"$f":"1/$B$25","v":{"v":0.08333333333333333,"d":"8.33%"}},{"$f":"1/$B$25+B56","v":{"v":0.16666666666666666,"d":"16.67%"}},{"v":0.25,"d":"25.00%"},{"v":0.3333333333333333,"d":"33.33%"},{"v":0.41666666666666663,"d":"41.67%"},{"v":0.49999999999999994,"d":"50.00%"},{"v":0.5833333333333333,"d":"58.33%"},{"v":0.6666666666666666,"d":"66.67%"},{"v":0.75,"d":"75.00%"},{"v":0.8333333333333334,"d":"83.33%"},{"v":0.9166666666666667,"d":"91.67%"},{"v":1,"d":"100.00%"}]
["Hydropower potential range (Max, Min, Min adjusted) [kW]",{"$f":"B40","v":{"v":714.9316715645834,"d":"714.93"}},{"$f":"C40","v":{"v":494.424,"d":"494.42"}},{"$f":"D40","v":{"v":346.0968,"d":"346.10"}}]
{"$rows_empty":52}
["END SHEET"]

{"sheet":"Turbine informations","index":1,"n_rows":255,"n_cols":102,"rows_kept":255}
["INPUT DATA"]
[]
["Power group and electrical equipment"]
["Turbine type","Standard_Francis"]
["Turbine transport cost coefficient",{"v":1.2,"d":"1.20"}]
["Electrical equipment transport cost coefficient",{"v":1.1,"d":"1.10"}]
["Number of parallel turbines",2]
["Utilities grid acces points",11]
["Grid total length [km]",{"v":13.5,"d":"13.50"}]
["Annual maintenance hours (up to 650) [h] ",400]
["Maintenance period","October"]
["Nominal power group electrical power [kW]",{"v":340,"d":"340.00"}]
[]
[]
["DATA FROM OTHER SHEETS"]
[]
[]
["Gross project head [m]",{"$f":"'Site informations'!$D$4","v":{"v":18,"d":"18.00"}}]
["Net project head [m]",{"$f":"'Site informations'!$B$52","v":{"v":17.099999999999998,"d":"17.10"}}]
["Month","January","February","March","April","May","June","July","August","September","October","November ","December"]
["Hydrograph [m^3/s]",{"$f":"'Site informations'!B$53","v":{"v":4.048769235273436,"d":"4.05"}},{"$f":"'Site informations'!C$53","v":{"v":4.00121134124162,"d":"4.00"}},{"$f":"'Site informations'!D$53","v":{"v":4.000005049323775,"d":"4.00"}},{"$f":"'Site informations'!E$53","v":{"v":4.009514778811374,"d":"4.01"}},{"$f":"'Site informations'!F$53","v":{"v":3.9863852348394038,"d":"3.99"}},{"$f":"'Site informations'!G$53","v":{"v":3.5742960293354016,"d":"3.57"}},{"$f":"'Site informations'!H$53","v":{"v":3.213136124952202,"d":"3.21"}},{"$f":"'Site informations'!I$53","v":{"v":2.8,"d":"2.80"}},{"$f":"'Site informations'!J$53","v":{"v":2.8,"d":"2.80"}},{"$f":"'Site informations'!K$53","v":{"v":2.8,"d":"2.80"}},{"$f":"'Site informations'!L$53","v":{"v":3.536055752083861,"d":"3.54"}},{"$f":"'Site informations'!M$53","v":{"v":3.8352561281016233,"d":"3.84"}}]
["Residual flow [m^3/s]",{"$f":"'Site informations'!B$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!C$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!D$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!E$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!F$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!G$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!H$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!I$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!J$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!K$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!L$54","v":{"v":0.35503858061635585,"d":"0.36"}},{"$f":"'Site informations'!M$54","v":{"v":0.35503858061635585,"d":"0.36"}}]
["Weir length [m]",{"$f":"'Plant informations'!$B$255","v":{"v":10,"d":"10.00"}}]
["Utilities minimum power [kW]",{"$f":"Simulation!$B$5","v":{"v":275,"d":"275.00"}}]
["Utilities peak power [kW]",{"$f":"Simulation!$B$6","v":{"v":566,"d":"566.00"}}]
["Utilities load factor ",{"$f":"Simulation!$B$4","v":{"v":0.6,"d":"0.60"}}]
["Weir altitude on sea level [m]",{"$f":"'Site informations'!$B$7","v":{"v":1850,"d":"1850.00"}}]
[]
[]
["DATA FROM THEORY"]
[]
["Power factor [kW/kVA]",0.9]
["USD/€ ratio:",{"v":1.35,"d":"1.350"}]
[]
["Turbine group"]
["Turbine type","Standard_Kaplan","Standard_Francis","Standard_Pelton_2_nozzles","Table counter"]
["Max turbine efficiency",0.92,0.94,{"v":0.9,"d":"0.90"},2]
["Generator organic and electrical efficiency",0.95,null,null,3]
["Flow rate inferior limit %",{"v":0.1,"d":"10%"},{"v":0.3,"d":"30%"},{"v":0.1,"d":"10%"},4]
["Efficiency ratio at 10% flow rate (Eta/EtaMax)",{"v":0.41304347826086957,"d":"0.41"},{"v":0,"d":"0.00"},{"v":0.5444444444444444,"d":"0.54"},5]
["Efficiency ratio at 20% flow rate",{"v":0.8152173913043478,"d":"0.82"},{"v":0,"d":"0.00"},{"v":0.8666666666666667,"d":"0.87"},6]
["Efficiency ratio at 30% flow rate",{"v":0.9239130434782608,"d":"0.92"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.9666666666666667,"d":"0.97"},7]
["Efficiency ratio at 40% flow rate",{"v":0.9565217391304347,"d":"0.96"},{"v":0.6276595744680851,"d":"0.63"},{"v":0.9888888888888889,"d":"0.99"},8]
["Efficiency ratio at 50% flow rate",{"v":0.9891304347826086,"d":"0.99"},{"v":0.7765957446808511,"d":"0.78"},{"v":1,"d":"1.00"},9]
["Efficiency ratio at 60% flow rate",{"v":1,"d":"1.00"},{"v":0.8829787234042553,"d":"0.88"},{"v":1,"d":"1.00"},10]
["Efficiency ratio at 70% flow rate",{"v":1,"d":"1.00"},{"v":0.9361702127659575,"d":"0.94"},{"v":1,"d":"1.00"},11]
["Efficiency ratio at 80% flow rate",{"v":1,"d":"1.00"},{"v":0.9893617021276597,"d":"0.99"},{"v":1,"d":"1.00"},12]
["Efficiency ratio at 90% flow rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},13]
["Efficiency ratio at 100% flow rate",{"v":0.9891304347826086,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9777777777777777,"d":"0.98"},14]
["Bar spacing [m]",{"v":0.09,"d":"0.090"},0.045,0.025,15]
["1 turbine specific speed coefficient c1/H",2.294,1.924,{"v":0.12148,"d":"0.121"},16]
["2 turbine specific speed coefficient H^c2",0.486,0.512,0.243,17]
["1 turbine specific cost coefficient [€] c1*  ",{"v":33236,"d":"33236.000"},{"v":25698,"d":"25698.000"},{"v":17693,"d":"17693.000"},18]
["2 turbine specific cost coefficient H^c2",{"v":-0.113901,"d":"-0.114"},{"v":-0.127243,"d":"-0.127"},{"v":-0.281735,"d":"-0.282"},19]
["3 turbine specific cost coefficient P^c3",{"v":-0.58338,"d":"-0.583"},{"v":-0.560135,"d":"-0.560"},{"v":-0.3644725,"d":"-0.364"},20]
[]
[]
[]
[]
["Grid transformer (0,4/11 kV)"]
["1 transformer cost coefficient [USD] c1*",{"v":2034,"d":"2,034"}]
["2 transformer cost coefficient [kVA] P^c2 ",0.48]
[]
[]
["Transmission grid (11 kV, 100 mm^2)"]
["Grid line voltage [kV]",{"v":11,"d":"11.00"}]
["Electrical resistance, single fase [Ohm/km]",{"v":0.2733,"d":"0.27"}]
["Grid cost  [USD/km]",{"v":16594,"d":"16,594"}]
[]
[]
[]
[]
[]
[]
["COMPUTATIONS"]
[]
["Single turbine electrical power [kW]",{"$f":"$B$12/$B$7","v":{"v":170,"d":"170.00"}}]
[]
[]
["Turbine technical parameters"]
["Input",null,"Efficiency",null,"Speed and discharge",null,"Turbine sizing by type",{"$f":"B$36","v":"Standard_Kaplan"},{"$f":"C$36","v":"Standard_Francis"},"Standard_Pelton_2_nozzles","Turbine sizing (effective type)",null,"Kaplan and Francis cavitation check",null,"Pelton D1/B2 ratio check"]
["Turbine type",{"$f":"$B$4","v":"Standard_Francis"},"Turbine efficiency at max flow rate",{"$f":"B89*B88","v":0.93},"Power group discharge (nom) [m^3/s]",{"$f":"B86/(9.81*B85*D84)","v":{"v":2.294073062860163,"d":"2.29"}},"1st turbine dimension","Kaplan Di : runner hub diameter [m]","Francis D1 : inlet min diameter [m]","Pelton D1 : jets tangent circle [m]",{"$f":"HLOOKUP($B$82,$H$81:$J$87,2,FALSE)","v":"Francis D1 : inlet min diameter [m]"},{"$f":"HLOOKUP($B$82,$H$81:$J$87,3,FALSE)","v":{"v":0.25988729865755633,"d":"0.26"}},"Powerhouse altitude over sea level [m]",{"$f":"B93-B84","v":{"v":1832,"d":"1832.00"}},{"$f":"J83/J85","v":{"v":0.22964226096056176,"d":"0.2296"}}]
["Number of parallel turbines",{"$f":"$B$7","v":2},"Max global efficiency",{"$f":"B88*B90","v":{"v":0.8929999999999999,"d":"0.89"}},"Single turbine discharge (nom) [m^3/s]",{"$f":"F82/B83","v":{"v":1.1470365314300814,"d":"1.15"}},null,{"$f":"(0.25+0.0951/F84)*H85","v":{"v":0.20740876713866016,"d":"0.21"}},{"$f":"(0.4+0.095/F84)*I87","v":{"v":0.25988729865755633,"d":"0.26"}},{"$f":"0.68*(B85)^0.5/F85","v":{"v":0.1436764852311098,"d":"0.14"}},{"$f":"HLOOKUP($B$82,$H$81:$J$87,4,FALSE)","v":"Francis D2 : inlet max diameter [m]"},{"$f":"HLOOKUP($B$82,$H$81:$J$87,5,FALSE)","v":{"v":0.3762460207842826,"d":"0.38"}},"Atmospheric pressure [Pa]",{"$f":"(8416-N82)/8333*10^5","v":{"v":79011.16044641787,"d":"79011.16"}},{"$f":"IF(O82>2.7,\"True\",\"False\")","v":"False"}]
["Gross project head [m]",{"$f":"$B$18","v":{"v":18,"d":"18.00"}},"Global efficiency at max flow rate",{"$f":"D82*B90","v":{"v":0.8835,"d":"0.88"}},"Mean specific speed (nQE) [-]",{"$f":"B91/B85^B92","v":{"v":0.44968775219721163,"d":"0.45"}},"2nd turbine dimension","Kaplan De : runner outer diameter [m]","Francis D2 : inlet max diameter [m]","Pelton B2 : bucket width [m]",{"$f":"HLOOKUP($B$82,$H$81:$J$87,6,FALSE)","v":"Francis D3 : outlet diameter [m]"},{"$f":"HLOOKUP($B$82,$H$81:$J$87,7,FALSE)","v":{"v":0.4251681392175871,"d":"0.43"}},"Thoma's sigma",{"$f":"HLOOKUP($B$82,$H$81:$J$89,9,FALSE)","v":{"v":0.42394495640235935,"d":"0.4239"}}]
["Net project head [m]",{"$f":"$B$19","v":{"v":17.099999999999998,"d":"17.10"}},null,null,"Theoretical turbine speed [Hz]",{"$f":"F84*(9.81*B85)^(3/4)/F83^(0.5)","v":{"v":19.571372036998746,"d":"19.57"}},null,{"$f":"84.5*(0.79+1.602*F84)*B85^0.5/F86","v":{"v":0.44944251753479747,"d":"0.45"}},{"$f":"I87/(0.96+0.3781*F84)","v":{"v":0.3762460207842826,"d":"0.38"}},{"$f":"1.68*(F83/(2*B85^0.5))^0.5","v":{"v":0.6256535039767113,"d":"0.63"}},"Main turbine dimension [m]",{"$f":"MAX(L82:L84)","v":{"v":0.4251681392175871,"d":"0.43"}},"Suction head [m]",{"$f":"(N83-B94)/(1000*9.81)+2^2/(2*9.81)-N84*B85","v":{"v":0.7702314031565436,"d":"0.77"}}]
["Power group electrical power [kW]",{"$f":"$B$12","v":{"v":340,"d":"340.00"}},null,null,"Theoretical turbine speed [rpm]",{"$f":"F85*60","v":{"v":1174.2823222199247,"d":"1174.28"}},"3rd turbine dimension","None","Francis D3 : outlet diameter [m]","Pelton De : nozzle diameter [m]"]
["Single turbine electrical power [kW]",{"$f":"$B$77","v":{"v":170,"d":"170.00"}},{"$nulls":6},{"$f":"84.5*(0.31+2.488*F84)*B85^0.5/F86","v":{"v":0.4251681392175871,"d":"0.43"}},{"$f":"1.178*(F83/(2*(9.81*B85)^0.5))^0.5","v":{"v":0.24788636444025594,"d":"0.25"}}]
["Max turbine efficiency",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E37,FALSE)","v":0.94},{"$nulls":4},"Cavitation check","Thoma's sigma","Thoma's sigma"]
["Turbine efficiency rate at max flow rate",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E49,FALSE)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$nulls":5},{"$f":"1.5241*F84^1.46+4/(2*9.81*B85)","v":{"v":0.4864523622458137,"d":"0.4865"}},{"$f":"1.2715*F84^1.41+(4/(2*9.81*B85))","v":{"v":0.42394495640235935,"d":"0.4239"}}]
["Organic and electric efficiency",{"$f":"$B$38","v":0.95}]
["1 turbine specific speed coefficient c1/H",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E51,FALSE)","v":1.924}]
["2 turbine specific speed coefficient H^c2",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E52,FALSE)","v":0.512}]
["Weir altitude on sea level [m]",{"$f":"B27","v":{"v":1850,"d":"1850.00"}}]
["Water vapour pressure (20°C) [Pa]",{"v":2338,"d":"2338.00"}]
[]
[]
[]
["Cost analysis"]
["Input",null,"Power group costs",null,"Electrical equipment costs"]
["USD/€ ratio:",{"$f":"$B$33","v":1.35},"Turbine group specific cost (from cost function) [€/kW]",{"$f":"B110*B104^B111*B108^B112","v":{"v":1008.4553960195148,"d":"1008.46"}},"Transmission grid specific cost  [USD/km]",{"$f":"B115","v":{"v":16594,"d":"16,594"}}]
["Turbine transport cost coefficient",{"$f":"$B$5","v":{"v":1.2,"d":"1.20"}},"Turbine group cost [USD]",{"$f":"B100*B108*D100","v":{"v":231440.51338647868,"d":"231,441"}},"Transmission grid cost [USD]",{"$f":"F100*B106","v":{"v":224019,"d":"224,019"}}]
["Electrical equipment transport cost coefficient",{"$f":"$B$6","v":{"v":1.1,"d":"1.10"}},"Power group final cost [USD]",{"$f":"B101*B103*D101","v":{"v":555457.2321275488,"d":"555,457"}},"Step up transformer cost (from cost function) [USD]",{"$f":"B113*(B107/B109)^B114","v":{"v":35109.48218098808,"d":"35,109"}}]
["Number of parallel turbines",{"$f":"$B$7","v":2},null,null,"Step down transformer(s) cost (from cost function) [USD]",{"$f":"IF(B105=0,0,B105*B113*((B107/B105)/B109)^B114)","v":{"v":122165.51229382536,"d":"122,166"}}]
["Net project head [m]",{"$f":"$B$19","v":{"v":17.099999999999998,"d":"17.10"}},null,null,"Transmission grid final cost [USD]",{"$f":"F101*B102","v":{"v":246420.90000000002,"d":"246,421"}}]
["Utilities grid acces points",{"$f":"$B$8","v":{"v":11,"d":"11.00"}},null,null,"Step up transformer final cost [USD]",{"$f":"F102*B102","v":{"v":38620.430399086894,"d":"38,620"}}]
["Grid total length [km]",{"$f":"$B$9","v":{"v":13.5,"d":"13.50"}},null,null,"Step down transformer(s) final cost [USD]",{"$f":"F103*B102","v":{"v":134382.0635232079,"d":"134,382"}}]
["Power group electrical power [kW]",{"$f":"$B$12","v":{"v":340,"d":"340.00"}}]
["Single turbine electrical power [kW]",{"$f":"$B$77","v":{"v":170,"d":"170.00"}}]
["Power factor [kW/kVA]",{"$f":"$B$32","v":{"v":0.9,"d":"0.90"}}]
["1 turbine specific cost coefficient [€] c1*",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E53,FALSE)","v":{"v":25698,"d":"25698.000"}}]
["2 turbine specific cost coefficient H^c2",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E54,FALSE)","v":{"v":-0.127243,"d":"-0.127"}}]
["3 turbine specific cost coefficient P^c3",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E55,FALSE)","v":{"v":-0.560135,"d":"-0.560"}}]
["1 transformer cost coefficient [USD] c1*",{"$f":"$B$61","v":{"v":2034,"d":"2,034"}}]
["2 transformer cost coefficient P^c2 [kVA]",{"$f":"$B$62","v":0.48}]
["Grid specific cost  [USD/km]",{"$f":"$B$68","v":{"v":16594,"d":"16,594"}}]
[]
[]
[]
["Efficiency ratio"]
["Number of parallel turbines",1,2,3,4,5,6]
["Flow rate inferior limit %",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E39,FALSE)","v":{"v":0.3,"d":"30%"}}]
["Flow rate % ",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.3,"d":"30%"},{"v":0.4,"d":"40%"},{"v":0.5,"d":"50%"},{"v":0.6,"d":"60%"},{"v":0.7,"d":"70%"},{"v":0.8,"d":"80%"},{"v":0.9,"d":"90%"},{"v":1,"d":"100%"}]
["Efficiency ratio",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E40,FALSE)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E41,FALSE)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E42,FALSE)","v":{"v":0.4042553191489362,"d":"0.40"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E43,FALSE)","v":{"v":0.6276595744680851,"d":"0.63"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E44,FALSE)","v":{"v":0.7765957446808511,"d":"0.78"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E45,FALSE)","v":{"v":0.8829787234042553,"d":"0.88"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E46,FALSE)","v":{"v":0.9361702127659575,"d":"0.94"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E47,FALSE)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E48,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E49,FALSE)","v":{"v":0.9893617021276597,"d":"0.99"}}]
[]
["Number of parallel turbines",{"v":1,"d":"1.00"}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Linearized ratio",{"v":0,"d":"0.00"},{"$f":"0.1*($L$127-$B$127)+B127","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"0.1*($L$127-$B$127)+D127","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"B123","v":{"v":0,"d":"0.00"}},{"$f":"0.1*($V$127-$L$127)+L127","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C123","v":{"v":0,"d":"0.00"}},{"$f":"0.1*($AF$127-$V$127)+V127","v":{"v":0.04042553191489362,"d":"0.04"}},{"v":0.08085106382978724,"d":"0.08"},{"v":0.12127659574468086,"d":"0.12"},{"v":0.16170212765957448,"d":"0.16"},{"v":0.2021276595744681,"d":"0.20"},{"v":0.24255319148936172,"d":"0.24"},{"v":0.28297872340425534,"d":"0.28"},{"v":0.32340425531914896,"d":"0.32"},{"v":0.3638297872340426,"d":"0.36"},{"$f":"D123","v":{"v":0.4042553191489362,"d":"0.40"}},{"$f":"0.1*($AP$127-$AF$127)+AF127","v":{"v":0.4265957446808511,"d":"0.43"}},{"v":0.448936170212766,"d":"0.45"},{"v":0.4712765957446809,"d":"0.47"},{"v":0.4936170212765958,"d":"0.49"},{"v":0.5159574468085106,"d":"0.52"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.5606382978723403,"d":"0.56"},{"v":0.5829787234042552,"d":"0.58"},{"v":0.60531914893617,"d":"0.61"},{"$f":"E123","v":{"v":0.6276595744680851,"d":"0.63"}},{"$f":"0.1*($AZ$127-$AP$127)+AP127","v":{"v":0.6425531914893616,"d":"0.64"}},{"v":0.6574468085106382,"d":"0.66"},{"v":0.6723404255319148,"d":"0.67"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7021276595744679,"d":"0.70"},{"v":0.7170212765957444,"d":"0.72"},{"v":0.731914893617021,"d":"0.73"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.7617021276595741,"d":"0.76"},{"$f":"F123","v":{"v":0.7765957446808511,"d":"0.78"}},{"$f":"0.1*($BJ$127-$AZ$127)+AZ127","v":{"v":0.7872340425531915,"d":"0.79"}},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8085106382978723,"d":"0.81"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8297872340425531,"d":"0.83"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8723404255319146,"d":"0.87"},{"$f":"G123","v":{"v":0.8829787234042553,"d":"0.88"}},{"$f":"0.1*($BT$127-$BJ$127)+BJ127","v":{"v":0.8882978723404256,"d":"0.89"}},{"v":0.8936170212765958,"d":"0.89"},{"v":0.8989361702127661,"d":"0.90"},{"v":0.9042553191489363,"d":"0.90"},{"v":0.9095744680851066,"d":"0.91"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.920212765957447,"d":"0.92"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9308510638297876,"d":"0.93"},{"$f":"H123","v":{"v":0.9361702127659575,"d":"0.94"}},{"$f":"0.1*($CD$127-$BT$127)+BT127","v":{"v":0.9414893617021277,"d":"0.94"}},{"v":0.946808510638298,"d":"0.95"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"$f":"I123","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"0.1*($CN$127-$CD$127)+CD127","v":{"v":0.9904255319148938,"d":"0.99"}},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"$f":"J123","v":{"v":1,"d":"1.00"}},{"$f":"0.1*($CX$127-$CN$127)+CN127","v":{"v":0.9989361702127659,"d":"1.00"}},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"$f":"K123","v":{"v":0.9893617021276597,"d":"0.99"}}]
["Efficiency ratio",{"$f":"IF(B126>=$B$121,B127,0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(AF126>=$B$121,AF127,0)","v":{"v":0.4042553191489362,"d":"0.40"}},{"v":0.4265957446808511,"d":"0.43"},{"$f":"IF(AH126>=$B$121,AH127,0)","v":{"v":0.448936170212766,"d":"0.45"}},{"v":0.4712765957446809,"d":"0.47"},{"v":0.4936170212765958,"d":"0.49"},{"v":0.5159574468085106,"d":"0.52"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.5606382978723403,"d":"0.56"},{"v":0.5829787234042552,"d":"0.58"},{"v":0.60531914893617,"d":"0.61"},{"v":0.6276595744680851,"d":"0.63"},{"v":0.6425531914893616,"d":"0.64"},{"v":0.6574468085106382,"d":"0.66"},{"v":0.6723404255319148,"d":"0.67"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7021276595744679,"d":"0.70"},{"v":0.7170212765957444,"d":"0.72"},{"v":0.731914893617021,"d":"0.73"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.7617021276595741,"d":"0.76"},{"v":0.7765957446808511,"d":"0.78"},{"v":0.7872340425531915,"d":"0.79"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8085106382978723,"d":"0.81"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8297872340425531,"d":"0.83"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8723404255319146,"d":"0.87"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8882978723404256,"d":"0.89"},{"v":0.8936170212765958,"d":"0.89"},{"v":0.8989361702127661,"d":"0.90"},{"$f":"IF(BN126>=$B$121,BN127,0)","v":{"v":0.9042553191489363,"d":"0.90"}},{"v":0.9095744680851066,"d":"0.91"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.920212765957447,"d":"0.92"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.9414893617021277,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"$f":"IF(CT126>=$B$121,CT127,0)","v":{"v":0.9936170212765956,"d":"0.99"}},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Number of parallel turbines",{"v":2,"d":"2.00"}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio",{"v":0,"d":"0.00"},{"$f":"HLOOKUP((C131*$B130)/(CEILING(C131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((D131*$B130)/(CEILING(D131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.448936170212766,"d":"0.45"},{"v":0.4936170212765958,"d":"0.49"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.5829787234042552,"d":"0.58"},{"$f":"HLOOKUP((V131*$B130)/(CEILING(V131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.6276595744680851,"d":"0.63"}},{"$f":"HLOOKUP((W131*$B130)/(CEILING(W131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.6574468085106382,"d":"0.66"}},{"$f":"HLOOKUP((X131*$B130)/(CEILING(X131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.6872340425531913,"d":"0.69"}},{"$f":"HLOOKUP((Y131*$B130)/(CEILING(Y131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.7170212765957444,"d":"0.72"}},{"$f":"HLOOKUP((Z131*$B130)/(CEILING(Z131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.7468085106382976,"d":"0.75"}},{"$f":"HLOOKUP((AA131*$B130)/(CEILING(AA131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.7765957446808511,"d":"0.78"}},{"$f":"HLOOKUP((AB131*$B130)/(CEILING(AB131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.7978723404255319,"d":"0.80"}},{"$f":"HLOOKUP((AC131*$B130)/(CEILING(AC131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8191489361702127,"d":"0.82"}},{"$f":"HLOOKUP((AD131*$B130)/(CEILING(AD131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8404255319148934,"d":"0.84"}},{"$f":"HLOOKUP((AE131*$B130)/(CEILING(AE131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8617021276595742,"d":"0.86"}},{"$f":"HLOOKUP((AF131*$B130)/(CEILING(AF131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8829787234042553,"d":"0.88"}},{"$f":"HLOOKUP((AG131*$B130)/(CEILING(AG131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8936170212765958,"d":"0.89"}},{"$f":"HLOOKUP((AH131*$B130)/(CEILING(AH131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9042553191489363,"d":"0.90"}},{"$f":"HLOOKUP((AI131*$B130)/(CEILING(AI131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9148936170212768,"d":"0.91"}},{"$f":"HLOOKUP((AJ131*$B130)/(CEILING(AJ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9255319148936173,"d":"0.93"}},{"$f":"HLOOKUP((AK131*$B130)/(CEILING(AK131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9361702127659575,"d":"0.94"}},{"$f":"HLOOKUP((AL131*$B130)/(CEILING(AL131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.946808510638298,"d":"0.95"}},{"$f":"HLOOKUP((AM131*$B130)/(CEILING(AM131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9574468085106385,"d":"0.96"}},{"$f":"HLOOKUP((AN131*$B130)/(CEILING(AN131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.968085106382979,"d":"0.97"}},{"$f":"HLOOKUP((AO131*$B130)/(CEILING(AO131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9787234042553195,"d":"0.98"}},{"$f":"HLOOKUP((AP131*$B130)/(CEILING(AP131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"HLOOKUP((AQ131*$B130)/(CEILING(AQ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021279,"d":"0.99"}},{"$f":"HLOOKUP((AR131*$B130)/(CEILING(AR131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.993617021276596,"d":"0.99"}},{"$f":"HLOOKUP((AS131*$B130)/(CEILING(AS131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510642,"d":"1.00"}},{"$f":"HLOOKUP((AT131*$B130)/(CEILING(AT131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255323,"d":"1.00"}},{"$f":"HLOOKUP((AU131*$B130)/(CEILING(AU131*$B130,1)),$B$126:$CX$128,3)","v":{"v":1,"d":"1.00"}},{"$f":"HLOOKUP((AV131*$B130)/(CEILING(AV131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255319,"d":"1.00"}},{"$f":"HLOOKUP((AW131*$B130)/(CEILING(AW131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510637,"d":"1.00"}},{"$f":"HLOOKUP((AX131*$B130)/(CEILING(AX131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9936170212765956,"d":"0.99"}},{"$f":"HLOOKUP((AY131*$B130)/(CEILING(AY131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021274,"d":"0.99"}},{"$f":"HLOOKUP((AZ131*$B130)/(CEILING(AZ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"HLOOKUP((BA131*$B130)/(CEILING(BA131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.7872340425531915,"d":"0.79"}},{"$f":"HLOOKUP((BB131*$B130)/(CEILING(BB131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.7978723404255319,"d":"0.80"}},{"$f":"HLOOKUP((BC131*$B130)/(CEILING(BC131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8085106382978723,"d":"0.81"}},{"$f":"HLOOKUP((BD131*$B130)/(CEILING(BD131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8191489361702127,"d":"0.82"}},{"$f":"HLOOKUP((BE131*$B130)/(CEILING(BE131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8297872340425531,"d":"0.83"}},{"$f":"HLOOKUP((BF131*$B130)/(CEILING(BF131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8404255319148934,"d":"0.84"}},{"$f":"HLOOKUP((BG131*$B130)/(CEILING(BG131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8510638297872338,"d":"0.85"}},{"$f":"HLOOKUP((BH131*$B130)/(CEILING(BH131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8617021276595742,"d":"0.86"}},{"$f":"HLOOKUP((BI131*$B130)/(CEILING(BI131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8723404255319146,"d":"0.87"}},{"$f":"HLOOKUP((BJ131*$B130)/(CEILING(BJ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8829787234042553,"d":"0.88"}},{"$f":"HLOOKUP((BK131*$B130)/(CEILING(BK131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8882978723404256,"d":"0.89"}},{"$f":"HLOOKUP((BL131*$B130)/(CEILING(BL131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8936170212765958,"d":"0.89"}},{"$f":"HLOOKUP((BM131*$B130)/(CEILING(BM131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.8989361702127661,"d":"0.90"}},{"$f":"HLOOKUP((BN131*$B130)/(CEILING(BN131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9042553191489363,"d":"0.90"}},{"$f":"HLOOKUP((BO131*$B130)/(CEILING(BO131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9095744680851066,"d":"0.91"}},{"$f":"HLOOKUP((BP131*$B130)/(CEILING(BP131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9148936170212768,"d":"0.91"}},{"$f":"HLOOKUP((BQ131*$B130)/(CEILING(BQ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.920212765957447,"d":"0.92"}},{"$f":"HLOOKUP((BR131*$B130)/(CEILING(BR131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9255319148936173,"d":"0.93"}},{"$f":"HLOOKUP((BS131*$B130)/(CEILING(BS131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9308510638297876,"d":"0.93"}},{"$f":"HLOOKUP((BT131*$B130)/(CEILING(BT131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9361702127659575,"d":"0.94"}},{"$f":"HLOOKUP((BU131*$B130)/(CEILING(BU131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9414893617021277,"d":"0.94"}},{"$f":"HLOOKUP((BV131*$B130)/(CEILING(BV131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.946808510638298,"d":"0.95"}},{"$f":"HLOOKUP((BW131*$B130)/(CEILING(BW131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9521276595744682,"d":"0.95"}},{"$f":"HLOOKUP((BX131*$B130)/(CEILING(BX131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9574468085106385,"d":"0.96"}},{"$f":"HLOOKUP((BY131*$B130)/(CEILING(BY131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9627659574468087,"d":"0.96"}},{"$f":"HLOOKUP((BZ131*$B130)/(CEILING(BZ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.968085106382979,"d":"0.97"}},{"$f":"HLOOKUP((CA131*$B130)/(CEILING(CA131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9734042553191492,"d":"0.97"}},{"$f":"HLOOKUP((CB131*$B130)/(CEILING(CB131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9787234042553195,"d":"0.98"}},{"$f":"HLOOKUP((CC131*$B130)/(CEILING(CC131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9840425531914897,"d":"0.98"}},{"$f":"HLOOKUP((CD131*$B130)/(CEILING(CD131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"HLOOKUP((CE131*$B130)/(CEILING(CE131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148938,"d":"0.99"}},{"$f":"HLOOKUP((CF131*$B130)/(CEILING(CF131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021279,"d":"0.99"}},{"$f":"HLOOKUP((CG131*$B130)/(CEILING(CG131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9925531914893619,"d":"0.99"}},{"$f":"HLOOKUP((CH131*$B130)/(CEILING(CH131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.993617021276596,"d":"0.99"}},{"$f":"HLOOKUP((CI131*$B130)/(CEILING(CI131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9946808510638301,"d":"0.99"}},{"$f":"HLOOKUP((CJ131*$B130)/(CEILING(CJ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510642,"d":"1.00"}},{"$f":"HLOOKUP((CK131*$B130)/(CEILING(CK131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9968085106382982,"d":"1.00"}},{"$f":"HLOOKUP((CL131*$B130)/(CEILING(CL131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255323,"d":"1.00"}},{"$f":"HLOOKUP((CM131*$B130)/(CEILING(CM131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127664,"d":"1.00"}},{"$f":"HLOOKUP((CN131*$B130)/(CEILING(CN131*$B130,1)),$B$126:$CX$128,3)","v":{"v":1,"d":"1.00"}},{"$f":"HLOOKUP((CO131*$B130)/(CEILING(CO131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127659,"d":"1.00"}},{"$f":"HLOOKUP((CP131*$B130)/(CEILING(CP131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255319,"d":"1.00"}},{"$f":"HLOOKUP((CQ131*$B130)/(CEILING(CQ131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9968085106382978,"d":"1.00"}},{"$f":"HLOOKUP((CR131*$B130)/(CEILING(CR131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510637,"d":"1.00"}},{"$f":"HLOOKUP((CS131*$B130)/(CEILING(CS131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9946808510638296,"d":"0.99"}},{"$f":"HLOOKUP((CT131*$B130)/(CEILING(CT131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9936170212765956,"d":"0.99"}},{"$f":"HLOOKUP((CU131*$B130)/(CEILING(CU131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9925531914893615,"d":"0.99"}},{"$f":"HLOOKUP((CV131*$B130)/(CEILING(CV131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021274,"d":"0.99"}},{"$f":"HLOOKUP((CW131*$B130)/(CEILING(CW131*$B130,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148934,"d":"0.99"}},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Number of parallel turbines",{"v":3,"d":"3.00"}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio",{"v":0,"d":"0.00"},{"$f":"HLOOKUP((C135*$B134)/(CEILING(C135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((D135*$B134)/(CEILING(D135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((E135*$B134)/(CEILING(E135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((F135*$B134)/(CEILING(F135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.4712765957446809,"d":"0.47"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.60531914893617,"d":"0.61"},{"v":0.6574468085106382,"d":"0.66"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.7872340425531915,"d":"0.79"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8989361702127661,"d":"0.90"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9904255319148938,"d":"0.99"},{"$f":"HLOOKUP((AD135*$B134)/(CEILING(AD135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.993617021276596,"d":"0.99"}},{"$f":"HLOOKUP((AE135*$B134)/(CEILING(AE135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510642,"d":"1.00"}},{"$f":"HLOOKUP((AF135*$B134)/(CEILING(AF135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127664,"d":"1.00"}},{"$f":"HLOOKUP((AG135*$B134)/(CEILING(AG135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255319,"d":"1.00"}},{"$f":"HLOOKUP((AH135*$B134)/(CEILING(AH135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9936170212765956,"d":"0.99"}},{"$f":"HLOOKUP((AI135*$B134)/(CEILING(AI135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148934,"d":"0.99"}},{"$f":"HLOOKUP((AJ135*$B134)/(CEILING(AJ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.7872340425531915,"d":"0.79"}},{"$f":"HLOOKUP((AK135*$B134)/(CEILING(AK135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.7978723404255319,"d":"0.80"}},{"$f":"HLOOKUP((AL135*$B134)/(CEILING(AL135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8191489361702127,"d":"0.82"}},{"$f":"HLOOKUP((AM135*$B134)/(CEILING(AM135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8297872340425531,"d":"0.83"}},{"$f":"HLOOKUP((AN135*$B134)/(CEILING(AN135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8510638297872338,"d":"0.85"}},{"$f":"HLOOKUP((AO135*$B134)/(CEILING(AO135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8617021276595742,"d":"0.86"}},{"$f":"HLOOKUP((AP135*$B134)/(CEILING(AP135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8829787234042553,"d":"0.88"}},{"$f":"HLOOKUP((AQ135*$B134)/(CEILING(AQ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8882978723404256,"d":"0.89"}},{"$f":"HLOOKUP((AR135*$B134)/(CEILING(AR135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.8989361702127661,"d":"0.90"}},{"$f":"HLOOKUP((AS135*$B134)/(CEILING(AS135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9042553191489363,"d":"0.90"}},{"$f":"HLOOKUP((AT135*$B134)/(CEILING(AT135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9148936170212768,"d":"0.91"}},{"$f":"HLOOKUP((AU135*$B134)/(CEILING(AU135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.920212765957447,"d":"0.92"}},{"$f":"HLOOKUP((AV135*$B134)/(CEILING(AV135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9308510638297876,"d":"0.93"}},{"$f":"HLOOKUP((AW135*$B134)/(CEILING(AW135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9361702127659575,"d":"0.94"}},{"$f":"HLOOKUP((AX135*$B134)/(CEILING(AX135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.946808510638298,"d":"0.95"}},{"$f":"HLOOKUP((AY135*$B134)/(CEILING(AY135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9521276595744682,"d":"0.95"}},{"$f":"HLOOKUP((AZ135*$B134)/(CEILING(AZ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9627659574468087,"d":"0.96"}},{"$f":"HLOOKUP((BA135*$B134)/(CEILING(BA135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.968085106382979,"d":"0.97"}},{"$f":"HLOOKUP((BB135*$B134)/(CEILING(BB135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9787234042553195,"d":"0.98"}},{"v":0.9840425531914897,"d":"0.98"},{"$f":"HLOOKUP((BD135*$B134)/(CEILING(BD135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148938,"d":"0.99"}},{"$f":"HLOOKUP((BE135*$B134)/(CEILING(BE135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021279,"d":"0.99"}},{"$f":"HLOOKUP((BF135*$B134)/(CEILING(BF135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.993617021276596,"d":"0.99"}},{"$f":"HLOOKUP((BG135*$B134)/(CEILING(BG135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9946808510638301,"d":"0.99"}},{"$f":"HLOOKUP((BH135*$B134)/(CEILING(BH135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510642,"d":"1.00"}},{"$f":"HLOOKUP((BI135*$B134)/(CEILING(BI135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255323,"d":"1.00"}},{"$f":"HLOOKUP((BJ135*$B134)/(CEILING(BJ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127664,"d":"1.00"}},{"$f":"HLOOKUP((BK135*$B134)/(CEILING(BK135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127659,"d":"1.00"}},{"$f":"HLOOKUP((BL135*$B134)/(CEILING(BL135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255319,"d":"1.00"}},{"$f":"HLOOKUP((BM135*$B134)/(CEILING(BM135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510637,"d":"1.00"}},{"$f":"HLOOKUP((BN135*$B134)/(CEILING(BN135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9936170212765956,"d":"0.99"}},{"$f":"HLOOKUP((BO135*$B134)/(CEILING(BO135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9925531914893615,"d":"0.99"}},{"$f":"HLOOKUP((BP135*$B134)/(CEILING(BP135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148934,"d":"0.99"}},{"$f":"HLOOKUP((BQ135*$B134)/(CEILING(BQ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.920212765957447,"d":"0.92"}},{"$f":"HLOOKUP((BR135*$B134)/(CEILING(BR135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9255319148936173,"d":"0.93"}},{"$f":"HLOOKUP((BS135*$B134)/(CEILING(BS135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9308510638297876,"d":"0.93"}},{"$f":"HLOOKUP((BT135*$B134)/(CEILING(BT135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9308510638297876,"d":"0.93"}},{"$f":"HLOOKUP((BU135*$B134)/(CEILING(BU135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9414893617021277,"d":"0.94"}},{"$f":"HLOOKUP((BV135*$B134)/(CEILING(BV135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.946808510638298,"d":"0.95"}},{"$f":"HLOOKUP((BW135*$B134)/(CEILING(BW135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9521276595744682,"d":"0.95"}},{"$f":"HLOOKUP((BX135*$B134)/(CEILING(BX135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9521276595744682,"d":"0.95"}},{"$f":"HLOOKUP((BY135*$B134)/(CEILING(BY135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9627659574468087,"d":"0.96"}},{"$f":"HLOOKUP((BZ135*$B134)/(CEILING(BZ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.968085106382979,"d":"0.97"}},{"$f":"HLOOKUP((CA135*$B134)/(CEILING(CA135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9734042553191492,"d":"0.97"}},{"$f":"HLOOKUP((CB135*$B134)/(CEILING(CB135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9734042553191492,"d":"0.97"}},{"v":0.9840425531914897,"d":"0.98"},{"$f":"HLOOKUP((CD135*$B134)/(CEILING(CD135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"HLOOKUP((CE135*$B134)/(CEILING(CE135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148938,"d":"0.99"}},{"$f":"HLOOKUP((CF135*$B134)/(CEILING(CF135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021279,"d":"0.99"}},{"$f":"HLOOKUP((CG135*$B134)/(CEILING(CG135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9925531914893619,"d":"0.99"}},{"$f":"HLOOKUP((CH135*$B134)/(CEILING(CH135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.993617021276596,"d":"0.99"}},{"$f":"HLOOKUP((CI135*$B134)/(CEILING(CI135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9946808510638301,"d":"0.99"}},{"$f":"HLOOKUP((CJ135*$B134)/(CEILING(CJ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510642,"d":"1.00"}},{"$f":"HLOOKUP((CK135*$B134)/(CEILING(CK135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9968085106382982,"d":"1.00"}},{"$f":"HLOOKUP((CL135*$B134)/(CEILING(CL135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255323,"d":"1.00"}},{"$f":"HLOOKUP((CM135*$B134)/(CEILING(CM135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127664,"d":"1.00"}},{"$f":"HLOOKUP((CN135*$B134)/(CEILING(CN135*$B134,1)),$B$126:$CX$128,3)","v":{"v":1,"d":"1.00"}},{"$f":"HLOOKUP((CO135*$B134)/(CEILING(CO135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9989361702127659,"d":"1.00"}},{"$f":"HLOOKUP((CP135*$B134)/(CEILING(CP135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255319,"d":"1.00"}},{"$f":"HLOOKUP((CQ135*$B134)/(CEILING(CQ135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9968085106382978,"d":"1.00"}},{"$f":"HLOOKUP((CR135*$B134)/(CEILING(CR135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510637,"d":"1.00"}},{"$f":"HLOOKUP((CS135*$B134)/(CEILING(CS135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9957446808510637,"d":"1.00"}},{"$f":"HLOOKUP((CT135*$B134)/(CEILING(CT135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9936170212765956,"d":"0.99"}},{"$f":"HLOOKUP((CU135*$B134)/(CEILING(CU135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9925531914893615,"d":"0.99"}},{"$f":"HLOOKUP((CV135*$B134)/(CEILING(CV135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021274,"d":"0.99"}},{"$f":"HLOOKUP((CW135*$B134)/(CEILING(CW135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021274,"d":"0.99"}},{"$f":"HLOOKUP((CX135*$B134)/(CEILING(CX135*$B134,1)),$B$126:$CX$128,3)","v":{"v":0.9893617021276597,"d":"0.99"}}]
[]
["Number of parallel turbines",{"v":4,"d":"4.00"}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio",{"v":0,"d":"0.00"},{"$f":"HLOOKUP((C139*$B138)/(CEILING(C139*$B138,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((D139*$B138)/(CEILING(D139*$B138,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((E139*$B138)/(CEILING(E139*$B138,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.448936170212766,"d":"0.45"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.6276595744680851,"d":"0.63"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.9042553191489363,"d":"0.90"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.946808510638298,"d":"0.95"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8936170212765958,"d":"0.89"},{"v":0.9042553191489363,"d":"0.90"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"$f":"HLOOKUP((BP139*$B138)/(CEILING(BP139*$B138,1)),$B$126:$CX$128,3)","v":{"v":0.9978723404255323,"d":"1.00"}},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Number of parallel turbines",{"v":5,"d":"5.00"}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio",{"v":0,"d":"0.00"},{"$f":"HLOOKUP((C143*$B142)/(CEILING(C143*$B142,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((D143*$B142)/(CEILING(D143*$B142,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((E143*$B142)/(CEILING(E143*$B142,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.5159574468085106,"d":"0.52"},{"v":0.6276595744680851,"d":"0.63"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7765957446808511,"d":"0.78"},{"v":0.8297872340425531,"d":"0.83"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.9095744680851066,"d":"0.91"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9989361702127664,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8297872340425531,"d":"0.83"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8936170212765958,"d":"0.89"},{"v":0.9095744680851066,"d":"0.91"},{"v":0.920212765957447,"d":"0.92"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.9414893617021277,"d":"0.94"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"$f":"HLOOKUP((BP143*$B142)/(CEILING(BP143*$B142,1)),$B$126:$CX$128,3)","v":{"v":0.9914893617021279,"d":"0.99"}},{"v":0.9925531914893619,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Number of parallel turbines",{"v":6,"d":"6.00"}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio",{"v":0,"d":"0.00"},{"$f":"HLOOKUP((C147*$B146)/(CEILING(C147*$B146,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"$f":"HLOOKUP((D147*$B146)/(CEILING(D147*$B146,1)),$B$126:$CX$128,3)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.6574468085106382,"d":"0.66"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9989361702127664,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.7872340425531915,"d":"0.79"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8989361702127661,"d":"0.90"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"$f":"HLOOKUP((BP147*$B146)/(CEILING(BP147*$B146,1)),$B$126:$CX$128,3)","v":{"v":0.9904255319148934,"d":"0.99"}},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Equivalent efficiency ratio"]
["Number of parallel turbines",{"$f":"$B$7","v":{"v":2,"d":"2.00"}}]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio (Eta/EtaMax)",{"$f":"IF($B$151=$B$125,B128,0)+IF($B$151=$B$130,B132,0)+IF($B$151=$B$134,B136,0)+IF($B$151=$B$138,B140,0)+IF($B$151=$B$142,B144,0)+IF($B$151=$B$146,B148,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($B$151=$B$125,C128,0)+IF($B$151=$B$130,C132,0)+IF($B$151=$B$134,C136,0)+IF($B$151=$B$138,C140,0)+IF($B$151=$B$142,C144,0)+IF($B$151=$B$146,C148,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($B$151=$B$125,D128,0)+IF($B$151=$B$130,D132,0)+IF($B$151=$B$134,D136,0)+IF($B$151=$B$138,D140,0)+IF($B$151=$B$142,D144,0)+IF($B$151=$B$146,D148,0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.448936170212766,"d":"0.45"},{"v":0.4936170212765958,"d":"0.49"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.5829787234042552,"d":"0.58"},{"v":0.6276595744680851,"d":"0.63"},{"v":0.6574468085106382,"d":"0.66"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7170212765957444,"d":"0.72"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.7765957446808511,"d":"0.78"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8936170212765958,"d":"0.89"},{"$f":"IF($B$151=$B$125,AH128,0)+IF($B$151=$B$130,AH132,0)+IF($B$151=$B$134,AH136,0)+IF($B$151=$B$138,AH140,0)+IF($B$151=$B$142,AH144,0)+IF($B$151=$B$146,AH148,0)","v":{"v":0.9042553191489363,"d":"0.90"}},{"v":0.9148936170212768,"d":"0.91"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.7872340425531915,"d":"0.79"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8085106382978723,"d":"0.81"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8297872340425531,"d":"0.83"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8723404255319146,"d":"0.87"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8882978723404256,"d":"0.89"},{"v":0.8936170212765958,"d":"0.89"},{"v":0.8989361702127661,"d":"0.90"},{"$f":"IF($B$151=$B$125,BN128,0)+IF($B$151=$B$130,BN132,0)+IF($B$151=$B$134,BN136,0)+IF($B$151=$B$138,BN140,0)+IF($B$151=$B$142,BN144,0)+IF($B$151=$B$146,BN148,0)","v":{"v":0.9042553191489363,"d":"0.90"}},{"v":0.9095744680851066,"d":"0.91"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.920212765957447,"d":"0.92"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.9414893617021277,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9989361702127659,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Productivity"]
["Input"]
["Net project head [m]",{"$f":"$B$19","v":{"v":17.099999999999998,"d":"17.10"}}]
["Weir length [m]",{"$f":"$B$23","v":{"v":10,"d":"10.00"}}]
["Power group electrical power [kW]",{"$f":"$B$12","v":{"v":340,"d":"340.00"}}]
["Max global efficiency",{"$f":"$D$83","v":{"v":0.8929999999999999,"d":"0.89"}}]
["Power group discharge (nom) [m^3/s]",{"$f":"$F$82","v":{"v":2.294073062860163,"d":"2.29"}}]
["Utilities minimum power [kW]",{"$f":"$B$24","v":{"v":275,"d":"275.00"}}]
["Utilities peak power [kW]",{"$f":"$B$25","v":{"v":566,"d":"566.00"}}]
["Utilities load factor ",{"$f":"$B$26","v":{"v":0.6,"d":"0.60"}}]
["Grid line voltage [kV]",{"$f":"B66","v":{"v":11,"d":"11.00"}}]
["Electrical resistance, single fase [Ohm/km]",{"$f":"B$67","v":{"v":0.2733,"d":"0.27"}}]
["Grid total length [km]",{"$f":"B9","v":{"v":13.5,"d":"13.50"}}]
["Power factor [kW/kVA]",{"$f":"$B$32","v":{"v":0.9,"d":"0.90"}}]
[]
["Month","January","February","March","April","May","June","July","August","September","October","November ","December"]
["Monthly hours [h]",{"$f":"31*24","v":744},{"$f":"28*24","v":672},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744},{"$f":"30*24","v":720},{"$f":"31*24","v":744}]
["Effective hours (except manteinance) [h]",{"$f":"B171-IF($B$11=B170,$B$10,0)","v":744},{"$f":"C171-IF($B$11=C170,$B$10,0)","v":672},744,720,744,720,744,744,720,344,720,744]
[]
["Available flow rate (t) [m^3/s]",{"$f":"B$21-B$22","v":{"v":3.6937306546570805,"d":"3.69"}},{"$f":"C$21-C$22","v":{"v":3.6461727606252645,"d":"3.65"}},{"$f":"D$21-D$22","v":{"v":3.6449664687074192,"d":"3.64"}},{"v":3.654476198195018,"d":"3.65"},{"v":3.631346654223048,"d":"3.63"},{"v":3.2192574487190457,"d":"3.22"},{"v":2.858097544335846,"d":"2.86"},{"$f":"I$21-I$22","v":{"v":2.444961419383644,"d":"2.44"}},{"$f":"J$21-J$22","v":{"v":2.444961419383644,"d":"2.44"}},{"v":2.444961419383644,"d":"2.44"},{"v":3.1810171714675053,"d":"3.18"},{"v":3.4802175474852675,"d":"3.48"}]
["Average power group discharge (t) [m^3/s]",{"$f":"MIN($B$161,B174)","v":{"v":2.294073062860163,"d":"2.29"}},{"$f":"MIN($B$161,C174)","v":{"v":2.294073062860163,"d":"2.29"}},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"},{"$f":"MIN($B$161,J174)","v":{"v":2.294073062860163,"d":"2.29"}},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"},{"v":2.294073062860163,"d":"2.29"}]
[]
["Over flow [m^3/s]",{"$f":"B21-B175","v":{"v":1.7546961724132735,"d":"1.75"}},{"$f":"C21-C175","v":{"v":1.7071382783814575,"d":"1.71"}},{"v":1.7059319864636122,"d":"1.71"},{"v":1.715441715951211,"d":"1.72"},{"v":1.6923121719792409,"d":"1.69"},{"v":1.2802229664752387,"d":"1.28"},{"v":0.919063062092039,"d":"0.92"},{"$f":"I21-I175","v":{"v":0.5059269371398369,"d":"0.51"}},{"$f":"J21-J175","v":{"v":0.5059269371398369,"d":"0.51"}},{"v":0.5059269371398369,"d":"0.51"},{"v":1.2419826892236983,"d":"1.24"},{"v":1.5411830652414604,"d":"1.54"}]
["Extra head due to over flow [m]",{"$f":"(B177/($B$158*1.6))^(2/3)","v":{"v":0.22911558434623006,"d":"0.23"}},{"$f":"(C177/($B$158*1.6))^(2/3)","v":{"v":0.22495681016464247,"d":"0.22"}},{"v":0.22485082556504676,"d":"0.22"},{"v":0.22568567275913443,"d":"0.23"},{"v":0.22365245187155,"d":"0.22"},{"v":0.18568511352489048,"d":"0.19"},{"v":0.14887332428027686,"d":"0.15"},{"v":0.0999950603971136,"d":"0.10"},{"$f":"(J177/($B$158*1.6))^(2/3)","v":{"v":0.0999950603971136,"d":"0.10"}},{"v":0.0999950603971136,"d":"0.10"},{"v":0.18196884562683294,"d":"0.18"},{"v":0.2101306950691919,"d":"0.21"}]
["Available head (t) [m]",{"$f":"$B$157+B178","v":{"v":17.329115584346226,"d":"17.33"}},{"$f":"$B$157+C178","v":{"v":17.32495681016464,"d":"17.32"}},{"v":17.324850825565044,"d":"17.32"},{"v":17.325685672759132,"d":"17.33"},{"v":17.32365245187155,"d":"17.32"},{"v":17.285685113524888,"d":"17.29"},{"v":17.248873324280275,"d":"17.25"},{"v":17.19999506039711,"d":"17.20"},{"v":17.19999506039711,"d":"17.20"},{"v":17.19999506039711,"d":"17.20"},{"v":17.28196884562683,"d":"17.28"},{"v":17.31013069506919,"d":"17.31"}]
[]
["Flow rate % ",{"$f":"B175/$B$161","v":{"v":1,"d":"100%"}},{"$f":"C175/$B$161","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
["Flow rate (discretized) % ",{"$f":"ROUND(B181,2)","v":{"v":1,"d":"100%"}},{"$f":"ROUND(C181,2)","v":{"v":1,"d":"100%"}},{"$f":"ROUND(D181,2)","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio (t)",{"$f":"HLOOKUP(B$182,$B$152:$CX$153,2,FALSE)","v":{"v":0.9893617021276597,"d":"0.99"}},{"$f":"HLOOKUP(C$182,$B$152:$CX$153,2,FALSE)","v":{"v":0.9893617021276597,"d":"0.99"}},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
[]
["Average power group electrical power (t) [kW]",{"$f":"B175*9.81*B179*B183*$B$160","v":{"v":344.5555145425566,"d":"344.56"}},{"$f":"C175*9.81*C179*C183*$B$160","v":{"v":344.4728254652619,"d":"344.47"}},{"v":344.47071816912955,"d":"344.47"},{"v":344.48731747006474,"d":"344.49"},{"v":344.44689085592563,"d":"344.45"},{"v":343.69198471336045,"d":"343.69"},{"v":342.9600544008945,"d":"342.96"},{"v":341.9882058792409,"d":"341.99"},{"v":341.9882058792409,"d":"341.99"},{"v":341.9882058792409,"d":"341.99"},{"v":343.6180940066155,"d":"343.62"},{"v":344.1780372119021,"d":"344.18"}]
["Power dissipated on grid [kW]",{"$f":"($B$167*$B$166*(B185/($B$165*$B$168))^2)/1000","v":{"v":4.469113878931235,"d":"4.47"}},{"$f":"($B$167*$B$166*(C185/($B$165*$B$168))^2)/1000","v":{"v":4.466969071815824,"d":"4.47"}},{"v":4.466914419041148,"d":"4.47"},{"v":4.467344931356363,"d":"4.47"},{"v":4.466296480376281,"d":"4.47"},{"v":4.446740839029181,"d":"4.45"},{"v":4.4278213475727,"d":"4.43"},{"v":4.402762600289974,"d":"4.40"},{"v":4.402762600289974,"d":"4.40"},{"v":4.402762600289974,"d":"4.40"},{"v":4.444829025441381,"d":"4.44"},{"v":4.459326979480296,"d":"4.46"}]
["Net power [kW]",{"$f":"B185-B186","v":{"v":340.08640066362534,"d":"340.09"}},{"$f":"C185-C186","v":{"v":340.0058563934461,"d":"340.01"}},{"v":340.0038037500884,"d":"340.00"},{"v":340.0199725387084,"d":"340.02"},{"v":339.98059437554934,"d":"339.98"},{"v":339.24524387433127,"d":"339.25"},{"v":338.53223305332176,"d":"338.53"},{"v":337.58544327895095,"d":"337.59"},{"v":337.58544327895095,"d":"337.59"},{"v":337.58544327895095,"d":"337.59"},{"v":339.1732649811741,"d":"339.17"},{"v":339.7187102324218,"d":"339.72"}]
["Minimum power guaranteed (t)",{"$f":"IF(B187>$B$162,1,0)","v":{"v":1,"d":"1.00"}},{"$f":"IF(C187>$B$162,1,0)","v":{"v":1,"d":"1.00"}},{"$f":"IF(D187>$B$162,1,0)","v":{"v":1,"d":"1.00"}},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Operative hours (including manteinance) (t)  [h]",{"$f":"B171*B188","v":{"v":744,"d":"744.00"}},{"v":672,"d":"672.00"},{"v":744,"d":"744.00"},{"v":720,"d":"720.00"},{"v":744,"d":"744.00"},{"v":720,"d":"720.00"},{"v":744,"d":"744.00"},{"v":744,"d":"744.00"},{"v":720,"d":"720.00"},{"v":744,"d":"744.00"},{"v":720,"d":"720.00"},{"v":744,"d":"744.00"}]
[]
["Monthly productivity (t) [MWh]",{"$f":"B187*B172/1000","v":{"v":253.02428209373724,"d":"253.02"}},{"$f":"C187*C172/1000","v":{"v":228.4839354963958,"d":"228.48"}},{"v":252.96282999006579,"d":"252.96"},{"v":244.81438022787,"d":"244.81"},{"v":252.94556221540873,"d":"252.95"},{"v":244.2565755895185,"d":"244.26"},{"v":251.8679813916714,"d":"251.87"},{"v":251.16356979953952,"d":"251.16"},{"v":243.06151916084468,"d":"243.06"},{"v":116.12939248795912,"d":"116.13"},{"v":244.20475078644537,"d":"244.20"},{"v":252.75072041292182,"d":"252.75"}]
["Monthly utilities energy request (t) [MWh]",{"$f":"$B$163*$B$164*B172/1000","v":{"v":252.66239999999996,"d":"252.66"}},{"$f":"$B$163*$B$164*C172/1000","v":{"v":228.2112,"d":"228.21"}},{"$f":"$B$163*$B$164*D172/1000","v":{"v":252.66239999999996,"d":"252.66"}},{"v":244.51199999999997,"d":"244.51"},{"v":252.66239999999996,"d":"252.66"},{"v":244.51199999999997,"d":"244.51"},{"v":252.66239999999996,"d":"252.66"},{"v":252.66239999999996,"d":"252.66"},{"v":244.51199999999997,"d":"244.51"},{"v":116.82239999999999,"d":"116.82"},{"v":244.51199999999997,"d":"244.51"},{"v":252.66239999999996,"d":"252.66"}]
["Monthly sold energy (t) [MWh]",{"$f":"MIN(B191:B192)","v":{"v":252.66239999999996,"d":"252.66"}},{"$f":"MIN(C191:C192)","v":{"v":228.2112,"d":"228.21"}},{"$f":"MIN(D191:D192)","v":{"v":252.66239999999996,"d":"252.66"}},{"v":244.51199999999997,"d":"244.51"},{"v":252.66239999999996,"d":"252.66"},{"v":244.2565755895185,"d":"244.26"},{"v":251.8679813916714,"d":"251.87"},{"v":251.16356979953952,"d":"251.16"},{"v":243.06151916084468,"d":"243.06"},{"v":116.12939248795912,"d":"116.13"},{"v":244.20475078644537,"d":"244.20"},{"v":252.66239999999996,"d":"252.66"}]
[]
["Equivalent hours [h]",{"$f":"B198*1000/B159","v":{"v":8335.460556517584,"d":"8335"}}]
["Operative hours [h]",{"$f":"SUM(B189:M189)","v":8760},null,"  "]
["Power plant load factor",{"$f":"B196/8760","v":{"v":1,"d":"1.00"}}]
["Annual productivity [MWh]",{"$f":"SUM($B$193:$M$193)","v":{"v":2834.056589215979,"d":"2834.06"}}]
[]
["SHEET OUTPUT"]
[]
["Power group electrical power [kW]",{"$f":"$B$12","v":{"v":340,"d":"340.00"}}]
["Number of parallel turbines",{"$f":"$B$7","v":2}]
["Bar spacing [m]",{"$f":"HLOOKUP($B$4,$A$36:$D$55,$E50,FALSE)","v":0.045}]
["Power group discharge (nom) [m^3/s]",{"$f":"$F$82","v":{"v":2.294073062860163,"d":"2.29"}}]
["Single turbine discharge (nom) [m^3/s]",{"$f":"$F$83","v":{"v":1.1470365314300814,"d":"1.15"}}]
["Main turbine dimension [m]",{"$f":"$L$85","v":{"v":0.4251681392175871,"d":"0.43"}}]
["Suction head [m]",{"$f":"$N$85","v":{"v":0.7702314031565436,"d":"0.77"}}]
[]
["Power group cost [USD]",{"$f":"$D$102","v":{"v":555457.2321275488,"d":"555,457"}}]
["Transmission grid cost [USD]",{"$f":"$F$104","v":{"v":246420.90000000002,"d":"246,421"}}]
["Step up transformer cost [USD]",{"$f":"$F$105","v":{"v":38620.430399086894,"d":"38,620"}}]
["Step down transformer(s) cost [USD]",{"$f":"$F$106","v":{"v":134382.0635232079,"d":"134,382"}}]
["Electrical equipment cost [USD]",{"$f":"SUM(B211:B213)","v":{"v":419423.39392229484,"d":"419,423"}}]
[]
["Flow rate % ",{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.04,"d":"4%"},{"v":0.05,"d":"5%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},{"v":0.1,"d":"10%"},{"v":0.11,"d":"11%"},{"v":0.12,"d":"12%"},{"v":0.13,"d":"13%"},{"v":0.14,"d":"14%"},{"v":0.15,"d":"15%"},{"v":0.16,"d":"16%"},{"v":0.17,"d":"17%"},{"v":0.18,"d":"18%"},{"v":0.19,"d":"19%"},{"v":0.2,"d":"20%"},{"v":0.21,"d":"21%"},{"v":0.22,"d":"22%"},{"v":0.23,"d":"23%"},{"v":0.24,"d":"24%"},{"v":0.25,"d":"25%"},{"v":0.26,"d":"26%"},{"v":0.27,"d":"27%"},{"v":0.28,"d":"28%"},{"v":0.29,"d":"29%"},{"v":0.3,"d":"30%"},{"v":0.31,"d":"31%"},{"v":0.32,"d":"32%"},{"v":0.33,"d":"33%"},{"v":0.34,"d":"34%"},{"v":0.35,"d":"35%"},{"v":0.36,"d":"36%"},{"v":0.37,"d":"37%"},{"v":0.38,"d":"38%"},{"v":0.39,"d":"39%"},{"v":0.4,"d":"40%"},{"v":0.41,"d":"41%"},{"v":0.42,"d":"42%"},{"v":0.43,"d":"43%"},{"v":0.44,"d":"44%"},{"v":0.45,"d":"45%"},{"v":0.46,"d":"46%"},{"v":0.47,"d":"47%"},{"v":0.48,"d":"48%"},{"v":0.49,"d":"49%"},{"v":0.5,"d":"50%"},{"v":0.51,"d":"51%"},{"v":0.52,"d":"52%"},{"v":0.53,"d":"53%"},{"v":0.54,"d":"54%"},{"v":0.55,"d":"55%"},{"v":0.56,"d":"56%"},{"v":0.57,"d":"57%"},{"v":0.58,"d":"58%"},{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.61,"d":"61%"},{"v":0.62,"d":"62%"},{"v":0.63,"d":"63%"},{"v":0.64,"d":"64%"},{"v":0.65,"d":"65%"},{"v":0.66,"d":"66%"},{"v":0.67,"d":"67%"},{"v":0.68,"d":"68%"},{"v":0.69,"d":"69%"},{"v":0.7,"d":"70%"},{"v":0.71,"d":"71%"},{"v":0.72,"d":"72%"},{"v":0.73,"d":"73%"},{"v":0.74,"d":"74%"},{"v":0.75,"d":"75%"},{"v":0.76,"d":"76%"},{"v":0.77,"d":"77%"},{"v":0.78,"d":"78%"},{"v":0.79,"d":"79%"},{"v":0.8,"d":"80%"},{"v":0.81,"d":"81%"},{"v":0.82,"d":"82%"},{"v":0.83,"d":"83%"},{"v":0.84,"d":"84%"},{"v":0.85,"d":"85%"},{"v":0.86,"d":"86%"},{"v":0.87,"d":"87%"},{"v":0.88,"d":"88%"},{"v":0.89,"d":"89%"},{"v":0.9,"d":"90%"},{"v":0.91,"d":"91%"},{"v":0.92,"d":"92%"},{"v":0.93,"d":"93%"},{"v":0.94,"d":"94%"},{"v":0.95,"d":"95%"},{"v":0.96,"d":"96%"},{"v":0.97,"d":"97%"},{"v":0.98,"d":"98%"},{"v":0.99,"d":"99%"},{"v":1,"d":"100%"}]
["Equivalent efficiency ratio (Eta/EtaMax)",{"$f":"B$153","v":{"v":0,"d":"0.00"}},{"$f":"C$153","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.4042553191489362,"d":"0.40"},{"v":0.448936170212766,"d":"0.45"},{"v":0.4936170212765958,"d":"0.49"},{"v":0.5382978723404255,"d":"0.54"},{"v":0.5829787234042552,"d":"0.58"},{"v":0.6276595744680851,"d":"0.63"},{"v":0.6574468085106382,"d":"0.66"},{"v":0.6872340425531913,"d":"0.69"},{"v":0.7170212765957444,"d":"0.72"},{"v":0.7468085106382976,"d":"0.75"},{"v":0.7765957446808511,"d":"0.78"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8936170212765958,"d":"0.89"},{"v":0.9042553191489363,"d":"0.90"},{"v":0.9148936170212768,"d":"0.91"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":1,"d":"1.00"},{"v":0.9978723404255319,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.7872340425531915,"d":"0.79"},{"v":0.7978723404255319,"d":"0.80"},{"v":0.8085106382978723,"d":"0.81"},{"v":0.8191489361702127,"d":"0.82"},{"v":0.8297872340425531,"d":"0.83"},{"v":0.8404255319148934,"d":"0.84"},{"v":0.8510638297872338,"d":"0.85"},{"v":0.8617021276595742,"d":"0.86"},{"v":0.8723404255319146,"d":"0.87"},{"v":0.8829787234042553,"d":"0.88"},{"v":0.8882978723404256,"d":"0.89"},{"v":0.8936170212765958,"d":"0.89"},{"v":0.8989361702127661,"d":"0.90"},{"v":0.9042553191489363,"d":"0.90"},{"$f":"BO$153","v":{"v":0.9095744680851066,"d":"0.91"}},{"v":0.9148936170212768,"d":"0.91"},{"v":0.920212765957447,"d":"0.92"},{"v":0.9255319148936173,"d":"0.93"},{"v":0.9308510638297876,"d":"0.93"},{"v":0.9361702127659575,"d":"0.94"},{"v":0.9414893617021277,"d":"0.94"},{"v":0.946808510638298,"d":"0.95"},{"v":0.9521276595744682,"d":"0.95"},{"v":0.9574468085106385,"d":"0.96"},{"v":0.9627659574468087,"d":"0.96"},{"v":0.968085106382979,"d":"0.97"},{"v":0.9734042553191492,"d":"0.97"},{"v":0.9787234042553195,"d":"0.98"},{"v":0.9840425531914897,"d":"0.98"},{"v":0.9893617021276597,"d":"0.99"},{"v":0.9904255319148938,"d":"0.99"},{"v":0.9914893617021279,"d":"0.99"},{"v":0.9925531914893619,"d":"0.99"},{"v":0.993617021276596,"d":"0.99"},{"v":0.9946808510638301,"d":"0.99"},{"v":0.9957446808510642,"d":"1.00"},{"v":0.9968085106382982,"d":"1.00"},{"v":0.9978723404255323,"d":"1.00"},{"v":0.9989361702127664,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"CO$153","v":{"v":0.9989361702127659,"d":"1.00"}},{"$f":"CP$153","v":{"v":0.9978723404255319,"d":"1.00"}},{"v":0.9968085106382978,"d":"1.00"},{"v":0.9957446808510637,"d":"1.00"},{"v":0.9946808510638296,"d":"0.99"},{"v":0.9936170212765956,"d":"0.99"},{"v":0.9925531914893615,"d":"0.99"},{"v":0.9914893617021274,"d":"0.99"},{"v":0.9904255319148934,"d":"0.99"},{"v":0.9893617021276597,"d":"0.99"}]
["Monthly sold energy (t) [MWh]",{"$f":"B$193","v":{"v":252.66239999999996,"d":"253"}},{"v":228.2112,"d":"228"},{"v":252.66239999999996,"d":"253"},{"v":244.51199999999997,"d":"245"},{"v":252.66239999999996,"d":"253"},{"v":244.2565755895185,"d":"244"},{"v":251.8679813916714,"d":"252"},{"v":251.16356979953952,"d":"251"},{"v":243.06151916084468,"d":"243"},{"v":116.12939248795912,"d":"116"},{"v":244.20475078644537,"d":"244"},{"v":252.66239999999996,"d":"253"}]
[]
["Equivalent hours [h]",{"$f":"$B$195","v":{"v":8335.460556517584,"d":"8335"}}]
["Operative hours [h]",{"$f":"$B$196","v":{"v":8760,"d":"8760.000"}}]
["Power plant load factor",{"$f":"$B$197","v":{"v":1,"d":"1.00"}}]
["Annual productivity [MWh]",{"$f":"$B$198","v":{"v":2834.056589215979,"d":"2834.06"}}]
{"$rows_empty":31}
["END SHEET"]

{"sheet":"Plant informations","index":2,"n_rows":350,"n_cols":12,"rows_kept":350}
["INPUT DATA"]
[]
["Weir and intake",null,"Channel and penstock"]
["Building materials transport cost coefficient",{"v":1.1,"d":"1.10"},"Channel lining","artificially_concreteC15"]
["Ground type","hard_ground","Channel shape","trapezoid_(half_hexagon)"]
["Weir length [m]",{"v":10,"d":"10.00"},"Channel length [m]",{"v":141,"d":"141.00"}]
["Weir height [m]",{"v":5,"d":"5.00"},"Channel hydraulic gradient [m/m]",{"v":2E-3,"d":"0.0020"}]
["Weir material","Armed_concrete","Penstock material","welded_steel"]
["Trashrack bars shape","stainless_circular_[12mm]","Penstock length [m]",{"v":36,"d":"36.00"}]
[null,null,"Penstock deposition type","External"]
[]
["DATA FROM OTHER SHEETS"]
[]
["Gross project head [m]",{"$f":"'Site informations'!$D$4","v":{"v":18,"d":"18.00"}}]
["Net project head [m]",{"$f":"'Site informations'!$B$52","v":{"v":17.099999999999998,"d":"17.10"}}]
["Number of parallel turbines",{"$f":"'Turbine informations'!$B$203","v":2}]
["Bar spacing [m]",{"$f":"'Turbine informations'!$B$204","v":0.045}]
["Power group discharge (nom) [m^3/s]",{"$f":"'Turbine informations'!$B205","v":{"v":2.294073062860163,"d":"2.29"}}]
["Single turbine discharge (nom) [m^3/s]",{"$f":"'Turbine informations'!$B206","v":{"v":1.1470365314300814,"d":"1.15"}}]
["Maximum flow [m^3/s]",{"$f":"'Site informations'!$D$8","v":{"v":4,"d":"4.00"}}]
["Main turbine dimension [m]",{"$f":"'Turbine informations'!$B$207","v":{"v":0.4251681392175871,"d":"0.43"}}]
["Suction head [m]",{"$f":"'Turbine informations'!$B$208","v":{"v":0.7702314031565436,"d":"0.77"}}]
[]
[]
["DATA FROM THEORY"]
[]
[]
["Digging"]
["Ground type","soft_ground","medium_ground","hard_ground"]
["Basic cost [USD/m^3]",{"v":7.1,"d":"7.10"},{"v":9.5,"d":"9.50"},{"v":11.8,"d":"11.80"}]
[]
["Weir"]
["Material","Armed_concrete","rock"]
["Density [kg/m^3]",{"v":2700,"d":"2700.00"},{"v":2700,"d":"2700.00"}]
["Size coefficient",{"v":1.5,"d":"1.50"},{"v":2.1,"d":"2.10"}]
["Basic cost [USD/m^3]",{"v":235.3,"d":"235.30"},{"v":58.9,"d":"58.90"}]
["Final cost [USD/m^3]",{"$f":"B36*$B$4","v":{"v":258.83000000000004,"d":"258.83"}},{"$f":"C36","v":{"v":58.9,"d":"58.90"}}]
[]
[]
["Pillar"]
["Material","Armed_concrete"]
["Density [kg/m^3]",{"v":2700,"d":"2700.00"}]
["Basic cost [USD/m^3]",{"v":235.3,"d":"235.30"}]
["Final cost [USD/m^3]",{"$f":"B43*$B$4","v":{"v":258.83000000000004,"d":"258.83"}}]
[]
["Gate"]
["Metal sheet tensile strenght [N/m^2]",{"$f":"200*10^6","v":{"v":200000000,"d":"200,000,000"}}]
["1 gate cost coefficient c1* [USD]",{"v":14400,"d":"14,400.00"}]
["2 gate cost coefficient t^c2",1.06]
[]
["Trashrack"]
["Material","stainless_circular_[12mm]","stainless_drop_[12mm]"]
["Bar shape factor (K)",{"v":1.79,"d":"1.790"},{"v":0.92,"d":"0.920"}]
["Bar thikness (t) [m]",0.012,0.012]
["Basic cost [USD/m]",{"v":1.5,"d":"1.50"},{"v":2.5,"d":"2.50"}]
["Final cost [USD/m]",{"$f":"B55*$B$4","v":{"v":1.6500000000000001,"d":"1.65"}},{"$f":"C55*$B$4","v":2.75}]
[]
[]
["Channel layer"]
["Material","excavated_rock","artificially_concreteC15"]
["Manning roughness coefficient [s/m^(1/3)]",0.035,0.014]
["Basic cost [USD/m^3]",{"v":58.9,"d":"58.90"},{"v":176.5,"d":"176.50"}]
["Thickness [m]",{"v":0.35,"d":"0.350"},{"v":0.25,"d":"0.250"}]
["Layer basic cost [USD/m^2]",{"$f":"B62*B63","v":{"v":20.615,"d":"20.62"}},{"$f":"C62*C63","v":{"v":44.125,"d":"44.13"}}]
["Layer final cost [USD/m^2]",{"$f":"B64","v":{"v":20.615,"d":"20.62"}},{"$f":"C64*$B$4","v":{"v":48.5375,"d":"48.54"}}]
[]
[]
["Penstock material"]
["Material","welded_steel","polyethylene"]
["Manning roughness coefficient [s/m^(1/3)]",0.012,0.009]
["Tensile strenght [N/m^2]",{"v":400000000,"d":"400,000,000"},{"v":5000000,"d":"5,000,000"}]
["1 penstock cost coefficient c1* [USD]",{"v":550,"d":"550.00"},{"v":55,"d":"55.00"}]
["2 penstock cost coefficient H^c2",{"v":0,"d":"0.000"},0.931]
["3 penstock cost coefficient d^c3",{"v":1.1,"d":"1.100"},2.035]
[]
[]
["Penstock valve"]
["1 valve cost coefficient c1* [USD]",{"v":22000,"d":"22,000.00"}]
["2 valve cost coefficient d^c2",{"v":2.6,"d":"2.60"}]
[]
["Penstock deposition type"]
["Type","Buried","External"]
["Cost coefficient",1,0.5]
[]
[]
["COMPUTATIONS"]
[]
["Flood coefficient",{"v":40,"d":"40.00"}]
["Max flow during flood [m^3/s]",{"$f":"$B$88*$B$20","v":{"v":160,"d":"160.00"}}]
["Max extra head during flood [m]",{"$f":"($B$89/($B$6*1.6))^(2/3)","v":{"v":4.641588833612779,"d":"4.64"}}]
[]
["Weir structure"]
["Input",null,"Weir turning sizing",null,"Protection wall sizing",null,"Costs"]
["Weir length [m]",{"$f":"$B$6","v":{"v":10,"d":"10.00"}},"Upstream angle [rad]",{"$f":"B98/180*PI()","v":{"v":1.3962634015954636,"d":"1.40"}},"Wall height [m]",{"$f":"B95+B96","v":{"v":9.64158883361278,"d":"9.64"}},"Weir cost [USD]",{"$f":"B100*B106*D106","v":{"v":79772.78458556981,"d":"79,773"}}]
["Weir height [m]",{"$f":"$B$7","v":{"v":5,"d":"5.00"}},"Downstream stream angle [rad]",{"$f":"B99/180*PI()","v":{"v":1.3962634015954636,"d":"1.40"}},"Wall length [m]",{"$f":"2*B94","v":{"v":20,"d":"20.00"}},"Wall cost [USD]",{"$f":"B105*B100*F106","v":{"v":189329.63604391075,"d":"189,330"}}]
["Max extra head during flood [m]",{"$f":"$B$90","v":{"v":4.641588833612779,"d":"4.64"}},"h",{"$f":"B96/B95","v":{"v":0.9283177667225558,"d":"0.93"}},"Inner angle [rad]",{"$f":"B101/180*PI()","v":{"v":1.3962634015954636,"d":"1.40"}},"Weir structure cost [USD]",{"$f":"SUM(H94:H95)","v":{"v":269102.42062948056,"d":"269,102"}}]
["Weir and wall density [kg/m^3]",{"$f":"HLOOKUP($B$8,$A$33:$C$37,2,FALSE)","v":{"v":2700,"d":"2700.00"}},"a",{"$f":"1/TAN(D94)","v":{"v":0.17632698070846506,"d":"0.18"}},"Outer angle [rad]",{"$f":"B102/180*PI()","v":{"v":1.5707963267948966,"d":"1.57"}}]
["Upstream angle [°]",{"v":80,"d":"80.00"},"c",{"$f":"1/TAN(D95)","v":{"v":0.17632698070846506,"d":"0.18"}},"a",{"$f":"1/TAN(F96)","v":{"v":0.17632698070846506,"d":"0.18"}}]
["Downstream stream angle [°]",{"v":80,"d":"80.00"},"A",{"$f":"1/2*B97*B95^3","v":{"v":168750,"d":"168750.00"}},"c",{"$f":"1/TAN(F97)","v":{"v":6.1257422745431e-17,"d":"0.00"}}]
["Weir and wall final cost [USD/m^3]",{"$f":"HLOOKUP($B$8,$A$33:$C$37,5,FALSE)","v":{"v":258.83000000000004,"d":"258.83"}},"B",{"$f":"1000*B95^2*(D97*D96*B95+SIN(D94))+B97*B95^3*(5/4*D98+1/4*D97)","v":{"v":134346.6614269923,"d":"134346.66"}},"A",{"$f":"1/2*B97*F94^3","v":{"v":1209983.8941347504,"d":"1209983.89"}}]
["Wall inner angle [°]",{"v":80,"d":"80.00"},"C",{"$f":"1000*B95^2*(-1/6*(1+D96)^3*B95+D96*D97*D98*B95+1/2*D96*D97^2*B95+SIN(D94)*D98*D97+1/2*D97*SIN(D94))+1/2*B97*D98*B95^3*(D97+D98)","v":{"v":-130539.65061482223,"d":"-130539.65"}},"B",{"$f":"1000*F94^2*(SIN(F96))+B97*F94^3*(5/4*F99+1/4*F98)","v":{"v":198224.36376201725,"d":"198224.36"}}]
["Wall outer angle [°]",{"v":90,"d":"90.00"},"b",{"$f":"MAX(0,(-D100+(D100^2-4*D99*D101)^0.5)/(2*D99))","v":{"v":0.5673494044614286,"d":"0.57"}},"C",{"$f":"1000*F94^2*(-1/6*F94+SIN(F96)*F99*F98+1/2*F98*SIN(F96))+1/2*B97*F99*F94^3*(F98+F99)","v":{"v":-141309.53994880777,"d":"-141309.54"}}]
["Weir size coefficient",{"$f":"HLOOKUP($B$8,$A$33:$C$37,3,FALSE)","v":{"v":1.5,"d":"1.50"}},"Corrected b",{"$f":"D102*B103","v":{"v":0.8510241066921429,"d":"0.85"}},"b",{"$f":"MAX(0,(-F101+(F101^2-4*F100*F102)^0.5)/(2*F100))","v":{"v":0.26950780934829904,"d":"0.27"}}]
["Wall size coefficient",{"v":0.5,"d":"0.50"},"Main base",{"$f":"(D103+D97+D98)*B95","v":{"v":6.018390340545365,"d":"6.02"}},"Main base",{"$f":"(F103+F98+F99)*F94*B104","v":{"v":2.1492778667236974,"d":"2.15"}}]
["Wall cost corrective factor",{"v":1.1,"d":"1.10"},"Secondary base",{"$f":"D103*B95","v":{"v":4.2551205334607145,"d":"4.26"}},"Secondary base",{"$f":"F103*F94*B104","v":{"v":1.2992417425920009,"d":"1.30"}}]
["Weir cost corrective factor",{"v":1.2,"d":"1.20"},"Weir volume [m^3]",{"$f":"(D104+D105)*B95/2*B94","v":{"v":256.83777185015197,"d":"256.84"}},"Wall volume [m^3]",{"$f":"((F104+F105)*F94/2)*F95*2","v":{"v":664.9841631534588,"d":"664.98"}}]
[]
[]
["Conveyance intake structure"]
["Input",null,"Digging sizing",null,"Trashrack sizing",null,"Gate pressure sizing",null,"Pillar turning sizing",null,"Costs"]
["Building materials transport cost coefficient",{"$f":"$B$4","v":{"v":1.1,"d":"1.10"}},"Conveyance channel depth [m]",{"$f":"(B112*B114*1.26*B113^-0.5)^(3/8)","v":{"v":0.9632112816765318,"d":"0.96"}},"Trashrack height [m]",{"$f":"(D116+B115)/(SIN(B121/180*PI()))","v":{"v":6.017286647459367,"d":"6.02"}},"Gate height [m]",{"$f":"(D111+B115)","v":{"v":5.604800115289311,"d":"5.60"}},"Pillar height [m]",{"$f":"2.2*H111","v":{"v":12.330560253636486,"d":"12.33"}},"Digging cost [USD]",{"$f":"B125*B131*D120","v":{"v":193.04084941808992,"d":"193"}}]
["Power group discharge (nom) [m^3/s]",{"$f":"$B$18","v":{"v":2.294073062860163,"d":"2.29"}},"Wetted perimeter [m]",{"$f":"4*D111","v":{"v":3.852845126706127,"d":"3.85"}},"Trashrack width [m]",{"$f":"D114","v":{"v":1.9264225633530636,"d":"1.93"}},"Gate surface [m^2]",{"$f":"D114*H111","v":{"v":10.797213405177182,"d":"10.80"}},"Mean static force over the gate [N]",{"$f":"9.81*1000*D114*H111^2/2","v":{"v":296832.0735115785,"d":"296832.07"}},"Trashrack cost [USD]",{"$f":"B134*B127*F111*F115","v":{"v":1687.8489046123525,"d":"1,688"}}]
["Channel hydraulic gradient [m/m]",{"$f":"$D$7","v":{"v":2E-3,"d":"0.00"}},"Cross section area [m^2]",{"$f":"2*D111^2","v":{"v":1.8555519462978942,"d":"1.86"}},"Trashrack project surface [m^2]",{"$f":"F111*F112","v":{"v":11.591836767828838,"d":"11.59"}},"Local static pressure over the gate [Pa]",{"$f":"9.81*1000*H111","v":{"v":54983.08913098815,"d":"54983.09"}},"Mean dinamic force over the gate [N]",{"$f":"1/2*D117^2*1000*H112","v":{"v":8251.823809895033,"d":"8251.82"}},"Gate cost [USD]",{"$f":"B132*H117*H112","v":{"v":7223.602464259049,"d":"7,224"}}]
["Manning roughness coefficient [s/m^(1/3)]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,2,FALSE)","v":{"v":0.014,"d":"0.01"}},"Conveyance channel top width [m]",{"$f":"2*D111","v":{"v":1.9264225633530636,"d":"1.93"}},"Trashrack approach velocity [m/s]",{"$f":"B112/D113*(SIN(B121/180*PI()))","v":{"v":1.2175465864960757,"d":"1.22"}},"Local dinamic pressure over the gate [Pa]",{"$f":"1/2*D117^2*1000","v":{"v":764.2549517395245,"d":"764.25"}},"Mean force over the gate [N]",{"$f":"J113+J112","v":{"v":305083.8973214735,"d":"305083.90"}},"Pillars cost [USD]",{"$f":"2*B133*B126*J116","v":{"v":11102.915881736808,"d":"11,103"}}]
["Max extra head during flood [m]",{"$f":"$B$90","v":{"v":4.641588833612779,"d":"4.64"}},"Conveyance freeboard depth [m]",{"$f":"1/3*D111","v":{"v":0.3210704272255106,"d":"0.32"}},"Number of bars",{"$f":"CEILING(F112/(B119+B120),1)","v":{"v":34,"d":"34.00"}},"Critical pressure over the gate [Pa]",{"$f":"H114+H113","v":{"v":55747.34408272767,"d":"55747.34"}},"Pillar width [m]",{"$f":"((J114*H111)/(3*B117*9.81*J111))^(1/3)*B130","v":{"v":1.2039659175248123,"d":"1.20"}},"Layer cost [USD]",{"$f":"D118*B135*B128","v":{"v":504.3575745232306,"d":"504"}}]
["Metal sheet tensile strenght [N/m^2]",{"$f":"$B$47","v":{"v":200000000,"d":"200000000.00"}},"Total depth [m]",{"$f":"D111+D115","v":{"v":1.2842817089020424,"d":"1.28"}},"Trashrack project head loss [m]",{"$f":"B118*(B119/B120)^(4/3)*SIN(B121*PI()/180)*F114^2/(2*9.81)","v":{"v":0.022861337657712956,"d":"0.02"}},"Computed gate thickness [m]",{"$f":"1/2*B129*(H115*D114)/(0.8*B116)+0.001","v":{"v":0.011068088264497514,"d":"0.0111"}},"Pillar volume [m^3]",{"$f":"J115^2*J111","v":{"v":17.873565470477413,"d":"17.87"}},"Conveyence intake structure cost [USD]",{"$f":"SUM(L111:L115)","v":{"v":20711.76567454953,"d":"20,712"}}]
["Pillar density [kg/m^3]",{"$f":"$B$42","v":{"v":2700,"d":"2700.00"}},"Mean velocity [m/s]",{"$f":"B112/D113","v":{"v":1.2363292051387644,"d":"1.24"}},null,null,"Metal sheet final cost [USD/m^2]",{"$f":"B111*B123*H116^B124","v":{"v":133.80494009306858,"d":"133.80"}}]
["Bar shape factor (K)",{"$f":"HLOOKUP($B$9,$A$52:$C$56,2,FALSE)","v":1.79},"Layer surface [m^2]",{"$f":"D114*(D112+2*D115)","v":{"v":8.65924241605684,"d":"8.66"}},null,null,"Gate weight [kg]",{"$f":"8000*H116*H112","v":{"v":956.0360878329345,"d":"956.04"}}]
["Bar thikness (t) [m]",{"$f":"HLOOKUP($B$9,$A$52:$C$56,3,FALSE)","v":{"v":0.012,"d":"0.01"}},"Digging for layer [m^3]",{"$f":"D118*B122","v":{"v":2.16481060401421,"d":"2.16"}}]
["Bar spacing (b) [m]",{"$f":"$B$17","v":{"v":0.045,"d":"0.05"}},"Digging volume [m^3]",{"$f":"D116*D114^2+(2*J115+D114)*J115*D116+D119","v":{"v":13.632828348735163,"d":"13.63"}}]
["Trashrack angle of slope [°]",{"v":80,"d":"80.00"}]
["Layer thickness [m]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,4,FALSE)","v":0.25}]
["1 gate cost coefficient c1* [USD]",{"$f":"$B$48","v":{"v":14400,"d":"14400.00"}}]
["2 gate cost coefficient t^c2",{"$f":"$B$49","v":1.06}]
["Digging cost [USD/m^3]",{"$f":"HLOOKUP($B$5,$A$29:$D$30,2,FALSE)","v":{"v":11.8,"d":"11.80"}}]
["Pillar final cost [USD/m^3]",{"$f":"$B$44","v":{"v":258.83000000000004,"d":"258.83"}}]
["Bars final cost [USD/m]",{"$f":"HLOOKUP($B$9,$A$52:$C$56,5,FALSE)","v":{"v":1.6500000000000001,"d":"1.65"}}]
["Layer final cost [USD/m^2]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,6,FALSE)","v":{"v":48.5375,"d":"48.54"}}]
["Gate size coefficient",{"v":30,"d":"30.00"}]
["Pillar size coefficient",{"v":1,"d":"1.00"}]
["Digging cost corrective factor",{"v":1.2,"d":"1.20"}]
["Gate cost corrective factor",{"v":5,"d":"5.00"}]
["Pillar cost corrective factor",{"v":1.2,"d":"1.20"}]
["Trashrack cost corrective factor",{"v":5,"d":"5.00"}]
["Layer cost corrective factor",{"v":1.2,"d":"1.20"}]
[]
[]
["Sediment trap"]
["Input",null,"Digging sizing",null,"Costs"]
["Power group discharge (nom) [m^3/s]",{"$f":"$B$18","v":{"v":2.294073062860163,"d":"2.29"}},"Deposition velocity [m/s]",{"$f":"0.1/(9*B145)*((1+157*B145^3)^0.5-1)","v":{"v":0.047736525630210046,"d":"0.05"}},"Digging cost [USD]",{"$f":"B150*B147*D147","v":{"v":3180.511007099986,"d":"3,181"}}]
["Conveyance channel depth [m]",{"$f":"$D$111","v":{"v":0.9632112816765318,"d":"0.96"}},"Trap depth [m]",{"$f":"(B141+B142)*1.5","v":{"v":1.9264225633530636,"d":"1.93"}},"Layer cost [USD]",{"$f":"B148*D145*B151","v":{"v":12162.91302485868,"d":"12,163"}}]
["Conveyance freeboard depth [m]",{"$f":"D115","v":{"v":0.3210704272255106,"d":"0.32"}},"Trap width [m]",{"$f":"D141*1.5","v":{"v":2.8896338450295955,"d":"2.89"}},"Sediment trap cost [USD]",{"$f":"SUM(F140:F141)","v":{"v":15343.424031958666,"d":"15,343"}}]
["Conveyance channel top width [m]",{"$f":"$D$114","v":{"v":1.9264225633530636,"d":"1.93"}},"Trap main length [m]",{"$f":"B140/(D140*D142)*B149","v":{"v":33.26163694109067,"d":"33.26"}}]
["Channel top width [m]",{"$f":"$G$161","v":{"v":1.9774933029475155,"d":"1.98"}},"Trap total length [m]",{"$f":"D143+(B144+B143)","v":{"v":37.16555280739125,"d":"37.17"}}]
["Grain size limit [mm]",{"v":0.3,"d":"0.30"},"Layer surface [m^2]",{"$f":"(2*D141+D142)*D144","v":{"v":250.5879582767691,"d":"250.59"}}]
["Layer thickness [m]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,4,FALSE)","v":0.25},"Digging for layer [m^3]",{"$f":"D145*B146","v":{"v":62.64698956919227,"d":"62.65"}}]
["Digging cost [USD/m^3]",{"$f":"HLOOKUP($B$5,$A$29:$D$30,2,FALSE)","v":{"v":11.8,"d":"11.80"}},"Digging volume [m^3]",{"$f":"D141*D142*D144+D146","v":{"v":269.5348311101683,"d":"269.53"}}]
["Layer final cost [USD/m^2]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,6,FALSE)","v":{"v":48.5375,"d":"48.54"}}]
["Digging size coefficient",{"v":2,"d":"2.00"}]
["Digging cost corrective factor",{"v":1,"d":"1.00"}]
["Layer cost corrective factor",{"v":1,"d":"1.00"}]
[]
[]
[]
[]
["Channel"]
["Input",null,"Digging sizing by shape","trapezoid_(half_hexagon)","rectangle_(half_square)","Digging sizing (effective shape)",null,"Costs"]
["Channel shape",{"$f":"$D$5","v":"trapezoid_(half_hexagon)"},"Channel depth [m]",{"$f":"(B159*B162*0.92*B161^-0.5)^(3/8)","v":{"v":0.8560577069036863,"d":"0.86"}},{"$f":"(B159*B162*1.26*B161^-0.5)^(3/8)","v":{"v":0.9632112816765318,"d":"0.96"}},"Channel depth [m]",{"$f":"HLOOKUP(B158,$D$157:$E$165,2,FALSE)","v":{"v":0.8560577069036863,"d":"0.86"}},"Digging cost [USD]",{"$f":"G167*B166*B164","v":{"v":5421.16591866705,"d":"5,421"}}]
["Power group discharge (nom) [m^3/s]",{"$f":"$B$18","v":{"v":2.294073062860163,"d":"2.29"}},"Wetted perimeter [m]",{"$f":"3.46*D158","v":{"v":2.961959665886755,"d":"2.96"}},{"$f":"4*E158","v":{"v":3.852845126706127,"d":"3.85"}},"Wetted perimeter [m]",{"$f":"HLOOKUP(B158,$D$157:$E$165,3,FALSE)","v":{"v":2.961959665886755,"d":"2.96"}},"Layer cost [USD]",{"$f":"G165*B167*B165","v":{"v":29012.168671308835,"d":"29,012"}}]
["Channel length [m]",{"$f":"$D$6","v":{"v":141,"d":"141.00"}},"Cross section area [m^2]",{"$f":"1.73*D158^2","v":{"v":1.267804199760112,"d":"1.27"}},{"$f":"2*E158^2","v":{"v":1.8555519462978942,"d":"1.86"}},"Cross section area [m^2]",{"$f":"HLOOKUP(B158,$D$157:$E$165,4,FALSE)","v":{"v":1.267804199760112,"d":"1.27"}},"Channel cost [USD]",{"$f":"SUM(I158:I159)","v":{"v":34433.334589975886,"d":"34,433"}}]
["Channel hydraulic gradient (S) [m/m]",{"$f":"$D$7","v":{"v":2E-3,"d":"0.0020"}},"Channel top width [m]",{"$f":"2.31*D158","v":{"v":1.9774933029475155,"d":"1.98"}},{"$f":"2*E158","v":{"v":1.9264225633530636,"d":"1.93"}},"Channel top width [m]",{"$f":"HLOOKUP(B158,$D$157:$E$165,5,FALSE)","v":{"v":1.9774933029475155,"d":"1.98"}}]
["Manning roughness coefficient [s/m^(1/3)]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,2,FALSE)","v":{"v":0.014,"d":"0.01"}},"Freeboard depth [m]",{"$f":"1/3*D158","v":{"v":0.2853525689678954,"d":"0.29"}},{"$f":"1/3*E158","v":{"v":0.3210704272255106,"d":"0.32"}},"Freeboard depth [m]",{"$f":"HLOOKUP(B158,$D$157:$E$165,6,FALSE)","v":{"v":0.2853525689678954,"d":"0.29"}}]
["Layer thickness [m]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,4,FALSE)","v":0.25},"Shape cost coefficient",{"v":1.3,"d":"1.30"},{"v":1,"d":"1.00"},"Shape cost coefficient",{"$f":"HLOOKUP(B158,$D$157:$E$165,7,FALSE)","v":{"v":1.3,"d":"1.30"}}]
["Digging cost [USD/m^3]",{"$f":"HLOOKUP($B$5,$A$29:$D$30,2,FALSE)","v":{"v":11.8,"d":"11.80"}},"Mean velocity [m/s]",{"$f":"B159/D160","v":{"v":1.8094853000914786,"d":"1.81"}},{"$f":"B159/E160","v":{"v":1.2363292051387644,"d":"1.24"}},"Mean velocity [m/s]",{"$f":"HLOOKUP(B158,$D$157:$E$165,8,FALSE)","v":{"v":1.8094853000914786,"d":"1.81"}}]
["Layer final cost [USD/m^2]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,6,FALSE)","v":{"v":48.5375,"d":"48.54"}},"Digging volume [m^3]",{"$f":"B160*(D160+D162*D161)","v":{"v":258.32426613609215,"d":"258.32"}},{"$f":"B160*(E160+E162*E161)","v":{"v":348.84376590400416,"d":"348.84"}},"Layer surface [m^2]",{"$f":"B160*(G159+2*G162)","v":{"v":498.105737338979,"d":"498.11"}}]
["Digging cost corrective factor",{"v":1.2,"d":"1.20"},"Total depth [m]",{"$f":"D158+D162","v":{"v":1.1414102758715816,"d":"1.14"}},{"$f":"E158+E162","v":{"v":1.2842817089020424,"d":"1.28"}},"Digging for layer [m^3]",{"$f":"G165*B163","v":{"v":124.52643433474475,"d":"124.53"}}]
["Layer cost corrective factor",{"v":1.2,"d":"1.20"},{"$nulls":3},"Digging volume [m^3]",{"$f":"HLOOKUP(B158,$D$157:$E$165,9,FALSE)+G166","v":{"v":382.8507004708369,"d":"382.85"}}]
[{"$nulls":5},"Channel head loss [m]",{"$f":"B160*B161","v":{"v":0.28200000000000003,"d":"0.28"}}]
[]
["Forebay"]
["Input",null,"Digging sizing",null,"Costs"]
["Number of parallel turbines",{"$f":"$B$16","v":{"v":2,"d":"2.00"}},"Forebay depth [m]",{"$f":"3*(B174+B177)","v":{"v":3.424230827614745,"d":"3.42"}},"Digging cost [USD]",{"$f":"B179*B182*D179","v":{"v":2983.5336021332582,"d":"2,984"}}]
["Power group discharge (nom) [m^3/s]",{"$f":"$B$18","v":{"v":2.294073062860163,"d":"2.29"}},"Forebay width [m]",{"$f":"3*B175*B172^0.5","v":{"v":8.389793545591033,"d":"8.39"}},"Layer cost [USD]",{"$f":"B180*B183*D177","v":{"v":5747.363541876625,"d":"5,747"}}]
["Channel depth [m]",{"$f":"$G$158","v":{"v":0.8560577069036863,"d":"0.86"}},"Filling time [s]",{"$f":"MAX(5,2*B176/(9.81*B174)^0.5)","v":{"v":97.31125730862904,"d":"97.31"}},"Forebay cost [USD]",{"$f":"SUM(F172:F173)","v":{"v":8730.897144009883,"d":"8,731"}}]
["Channel top width [m]",{"$f":"$G$161","v":{"v":1.9774933029475155,"d":"1.98"}},"Forebay volume [m^3]",{"$f":"B173*D174","v":{"v":223.23913410478002,"d":"223.24"}}]
["Channel length [m]",{"$f":"$D$6","v":{"v":141,"d":"141.00"}},"Forebay length [m]",{"$f":"D175/(D172*D173)","v":{"v":7.770626280857968,"d":"7.77"}}]
["Freeboard depth [m]",{"$f":"$G$162","v":{"v":0.2853525689678954,"d":"0.29"}},"Forebay surface [m^2]",{"$f":"(2*D172+D173)*D176","v":{"v":118.41078633791656,"d":"118.41"}}]
["Layer thickness [m]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,4,FALSE)","v":0.25},"Digging for layer [m^3]",{"$f":"D177*B178","v":{"v":29.60269658447914,"d":"29.60"}}]
["Digging cost [USD/m^3]",{"$f":"HLOOKUP($B$5,$A$29:$D$30,2,FALSE)","v":{"v":11.8,"d":"11.80"}},"Digging volume [m^3]",{"$f":"D175+D178","v":{"v":252.84183068925915,"d":"252.84"}}]
["Layer final cost [USD/m^2]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,6,FALSE)","v":{"v":48.5375,"d":"48.54"}}]
["Digging size coefficient",{"v":1,"d":"1.00"}]
["Digging cost corrective factor",{"v":1,"d":"1.00"}]
["Layer cost corrective factor",{"v":1,"d":"1.00"}]
[]
[]
["Power intake structure"]
["Input",null,"Digging sizing",null,"Trashrack sizing",null,"Costs"]
["Number of parallel turbines",{"$f":"$B$16","v":{"v":2,"d":"2.00"}},"Intake depth [m]",{"$f":"0.8*B190","v":{"v":2.739384662091796,"d":"2.74"}},"Trashrack height [m]",{"$f":"(2*B197+D188)/(SIN(B195/180*PI()))","v":{"v":3.2893573920225214,"d":"3.29"}},"Digging cost [USD]",{"$f":"B202*B198*D195","v":{"v":2825.121378281086,"d":"2,825"}}]
["Power group discharge (nom) [m^3/s]",{"$f":"$B$18","v":{"v":2.294073062860163,"d":"2.29"}},"Intake width [m]",{"$f":"0.8*B191","v":{"v":6.711834836472827,"d":"6.71"}},"Trashrack width [m]",{"$f":"D189","v":{"v":6.711834836472827,"d":"6.71"}},"Trashrack cost [USD]",{"$f":"B201*B199*F188*F192","v":{"v":3202.1894211339245,"d":"3,202"}}]
["Forebay depth [m]",{"$f":"$D$172","v":{"v":3.424230827614745,"d":"3.42"}},"Intake length [m]",{"$f":"5/3*D189","v":{"v":11.186391394121378,"d":"11.19"}},"Trashrack project surface [m^2]",{"$f":"F188*F189","v":{"v":22.077623533386163,"d":"22.08"}},"Layer cost [USD]",{"$f":"B203*B200*D193","v":{"v":9037.411098532242,"d":"9,037"}}]
["Forebay width [m]",{"$f":"$D$173","v":{"v":8.389793545591033,"d":"8.39"}},"Intake final depth [m]",{"$f":"1.2*B196","v":{"v":0.8400000000000001,"d":"0.84"}},"Trashrack approach velocity [m/s]",{"$f":"B189/(D188/(SIN(B195/180*PI()))*D189)","v":{"v":0.12287525261078461,"d":"0.12"}},"Power intake structure cost [USD]",{"$f":"SUM(H188:H190)","v":{"v":15064.721897947253,"d":"15,065"}}]
["Bar shape factor (K)",{"$f":"HLOOKUP($B$9,$A$52:$C$56,2,FALSE)","v":1.79},"Intake final width [m]",{"$f":"1.2*B196*B188","v":{"v":1.6800000000000002,"d":"1.68"}},"Number of bars",{"$f":"CEILING(F189/(B193+B194),1)","v":{"v":118,"d":"118.00"}}]
["Bar thikness (t) [m]",{"$f":"HLOOKUP($B$9,$A$52:$C$56,3,FALSE)","v":{"v":0.012,"d":"0.01"}},"Intake surface [m^2]",{"$f":"(D189+D192)*D190+2*(D190*D188)","v":{"v":155.16200701403113,"d":"155.16"}},"Trashrack project head loss [m]",{"$f":"B192*(B193/B194)^(4/3)*SIN(B195*PI()/180)*F191^2/(2*9.81)","v":{"v":2.328409221578693E-4,"d":"0.00"}}]
["Bar spacing (b) [m]",{"$f":"$B$17","v":{"v":0.045,"d":"0.05"}},"Digging for layer [m^3]",{"$f":"D193*B197","v":{"v":38.79050175350778,"d":"38.79"}}]
["Angle of slope [°]",{"v":80,"d":"80.00"},"Digging volume [m^3]",{"$f":"(D189+D192)*D190/2*B190+D194","v":{"v":199.5142216300202,"d":"199.51"}}]
["Penstock commercial diameter [m]",{"$f":"D210","v":{"v":0.7000000000000001,"d":"0.70"}},"Total depth [m]",{"$f":"D188+2*B197","v":{"v":3.239384662091796,"d":"3.24"}}]
["Layer thickness [m]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,4,FALSE)","v":0.25}]
["Digging cost [USD/m^3]",{"$f":"HLOOKUP($B$5,$A$29:$D$30,2,FALSE)","v":{"v":11.8,"d":"11.80"}}]
["Bars final cost [USD/m]",{"$f":"HLOOKUP($B$9,$A$52:$C$56,5,FALSE)","v":{"v":1.6500000000000001,"d":"1.65"}}]
["Layer final cost [USD/m^2]",{"$f":"HLOOKUP($D$4,$A$60:$C$65,6,FALSE)","v":{"v":48.5375,"d":"48.54"}}]
["Trashrack cost corrective factor",{"v":5,"d":"5.00"}]
["Digging cost corrective factor",{"v":1.2,"d":"1.20"}]
["Layer cost corrective factor",{"v":1.2,"d":"1.20"}]
[]
[]
["Penstock group"]
["Input",null,"Diameter sizing",null,"Costs"]
["Building materials transport cost coefficient",{"$f":"$B$4","v":{"v":1.1,"d":"1.10"}},"Power intake & penstock project head loss [m]",{"$f":"B209-B210-B213-B214","v":{"v":0.5949058214201313,"d":"0.59"}},"Valve cost (from cost function) [USD]",{"$f":"B225*B221*D210^B222","v":{"v":8703.172367321866,"d":"8,703"}}]
["Gross project head [m]",{"$f":"$B$14","v":{"v":18,"d":"18.00"}},"Computed diameter [m]",{"$f":"(B212^2/D208*(0.0157+B215*10.3*B216^2))^(0.19827)","v":{"v":0.6890365268591978,"d":"0.69"}},"Penstock cost [USD]",{"$f":"B215*D214*B224","v":{"v":6687.1803891803365,"d":"6,687"}}]
["Net project head [m]",{"$f":"$B$15","v":{"v":17.099999999999998,"d":"17.10"}},"Commercial diameter [m]",{"$f":"CEILING(D209,0.05)","v":{"v":0.7000000000000001,"d":"0.70"}},"Penstock group final cost [USD]",{"$f":"B208*B211*SUM(F208:F209)","v":{"v":33858.776064304846,"d":"33,859"}}]
["Number of parallel turbines",{"$f":"$B$16","v":{"v":2,"d":"2.00"}},"Cross section area [m^2]",{"$f":"PI()*D210^2/4","v":{"v":0.38484510006474976,"d":"0.38"}}]
["Single turbine discharge (nom) [m^3/s]",{"$f":"$B$19","v":{"v":1.1470365314300814,"d":"1.15"}},"Wetted perimeter [m]",{"$f":"PI()*D210","v":{"v":2.199114857512855,"d":"2.20"}}]
["Trashracks project head loss [m]",{"$f":"$F$116+$F$193","v":{"v":0.023094178579870825,"d":"0.02"}},"Estimated thickness [m]",{"$f":"B223*(1000*9.81*B210*D210)/(2*B217)","v":{"v":0.00029356425,"d":"0.00"}}]
["Channel head loss [m]",{"$f":"$G$168","v":{"v":0.28200000000000003,"d":"0.28"}},"Penstock specific cost (from cost function) [USD/m]",{"$f":"B218*B209^B219*D210^B220","v":{"v":371.5100216211298,"d":"371.51"}}]
["Penstock length [m]",{"$f":"$D$9","v":{"v":36,"d":"36.00"}}]
["Manning roughness coefficient [s/m^(1/3)]",{"$f":"HLOOKUP($D$8,$A$69:$E$74,2,FALSE)","v":{"v":0.012,"d":"0.0120"}}]
["Penstock tensile strenght [N/m^2]",{"$f":"HLOOKUP($D$8,$A$69:$E$74,3,FALSE)","v":{"v":400000000,"d":"400000000.00"}}]
["1 penstock cost coefficient c1* [USD]",{"$f":"HLOOKUP($D$8,$A$69:$E$74,4,FALSE)","v":{"v":550,"d":"550.00"}}]
["2 penstock cost coefficient H^c2",{"$f":"HLOOKUP($D$8,$A$69:$E$74,5,FALSE)","v":{"v":0,"d":"0.00"}}]
["3 penstock cost coefficient d^c3",{"$f":"HLOOKUP($D$8,$A$69:$E$74,6,FALSE)","v":{"v":1.1,"d":"1.10"}}]
["1 valve cost coefficient c1* [USD]",{"$f":"$B$78","v":{"v":22000,"d":"22000.00"}}]
["2 valve cost coefficient d^c2",{"$f":"$B$79","v":{"v":2.6,"d":"2.60"}}]
["Penstock thickness corrective factor",{"v":2,"d":"2.00"}]
["Penstock cost corrective factor",{"$f":"HLOOKUP($D$10,$A$82:$C$83,2,FALSE)","v":{"v":0.5,"d":"0.50"}}]
["Valve cost corrective factor",{"v":1,"d":"1.00"}]
[]
["Powerhouse building"]
["Input",null,"Digging sizing",null,"Building sizing",null,"Costs"]
["Net project head [m]",{"$f":"$B$15","v":{"v":17.099999999999998,"d":"17.10"}},"Machinery length [m]",{"$f":"6*B231","v":{"v":2.551008835305523,"d":"2.55"}},"Fundation volume [m^3]",{"$f":"D231*D236","v":{"v":51.513017969907004,"d":"51.51"}},"Digging cost [USD]",{"$f":"B238*B235*D237","v":{"v":875.3092013446598,"d":"875"}}]
["Number of parallel turbines",{"$f":"$B$16","v":{"v":2,"d":"2.00"}},"Machinery width [m]",{"$f":"3*B231","v":{"v":1.2755044176527615,"d":"1.28"}},"Wall surface [m^2]",{"$f":"(2*D233+D234*3)*D235","v":{"v":137.26513252958284,"d":"137.27"}},"Fundation cost [USD]",{"$f":"B239*B236*F229","v":{"v":26666.228882302064,"d":"26,666"}}]
["Main turbine dimension [m]",{"$f":"$B$21","v":{"v":0.4251681392175871,"d":"0.43"}},"Fundation thickness [m]",{"$f":"MAX(D230/2,0.4)","v":{"v":0.6377522088263807,"d":"0.64"}},"Wall and roof volume [m^3]",{"$f":"(F230+D236)*B233","v":{"v":43.60758222739451,"d":"43.61"}},"Wall and roof cost [USD]",{"$f":"B239*B236*F231","v":{"v":22573.901015833046,"d":"22,574"}}]
["Suction head [m]",{"$f":"B22","v":{"v":0.7702314031565436,"d":"0.77"}},"Digging depth [m]",{"$f":"IF(B232<0,-B232,0)+D231","v":{"v":0.6377522088263807,"d":"0.64"}},null,null,"Powerhouse building cost [USD]",{"$f":"SUM(H229:H231)","v":{"v":50115.43909947977,"d":"50,115"}}]
["Wall and roof thickness [m]",{"v":0.2,"d":"0.20"},"House width [m]",{"$f":"B230*(B234+D230)+B234*2","v":{"v":14.551008835305524,"d":"14.55"}}]
["Machinery spacing [m]",{"v":3,"d":"3.00"},"House length [m]",{"$f":"D229+B234","v":{"v":5.551008835305523,"d":"5.55"}}]
["Digging cost [USD/m^3]",{"$f":"HLOOKUP($B$5,$A$29:$D$30,2,FALSE)","v":{"v":11.8,"d":"11.80"}},"House height [m]",{"$f":"MAX(3,1.5*D230)","v":{"v":3,"d":"3.00"}}]
["Material final cost (Armed_concrete) [USD/m^3]",{"$f":"$B$37","v":{"v":258.83000000000004,"d":"258.83"}},"Floor and roof surface [m^2]",{"$f":"D233*D234","v":{"v":80.77277860738968,"d":"80.77"}}]
["Digging size coefficient",{"v":1.2,"d":"1.20"},"Digging volume [m^3]",{"$f":"B237*D232*D236","v":{"v":61.8156215638884,"d":"61.82"}}]
["Digging cost corrective factor",{"v":1.2,"d":"1.20"}]
["Building cost corrective factor",{"v":2,"d":"2.00"}]
[]
[]
["SHEET OUTPUT"]
[]
[]
[]
["Weir structure cost [USD]",{"$f":"$H$94","v":{"v":79772.78458556981,"d":"79,773"}}]
["Conveyance intake structure cost [USD]",{"$f":"$L$116","v":{"v":20711.76567454953,"d":"20,712"}}]
["Sediment trap cost [USD]",{"$f":"$F$142","v":{"v":15343.424031958666,"d":"15,343"}}]
["Channel cost [USD]",{"$f":"$I$160","v":{"v":34433.334589975886,"d":"34,433"}}]
["Forebay cost [USD]",{"$f":"$F$174","v":{"v":8730.897144009883,"d":"8,731"}}]
["Power intake structure cost [USD]",{"$f":"$H$191","v":{"v":15064.721897947253,"d":"15,065"}}]
["Penstock group cost [USD]",{"$f":"$F$210","v":{"v":33858.776064304846,"d":"33,859"}}]
["Powerhouse building cost [USD]",{"$f":"$H$232","v":{"v":50115.43909947977,"d":"50,115"}}]
[]
["Weir length [m]",{"$f":"$B$6","v":{"v":10,"d":"10.00"}}]
["Weir and intake cost [USD]",{"$f":"SUM($B$246:$B$248)","v":{"v":115827.97429207801,"d":"115,828"}}]
["Channel and penstock cost [USD]",{"$f":"SUM($B$249:$B$253)","v":{"v":142203.16879571765,"d":"142,203"}}]
{"$rows_empty":92}
["END SHEET"]

{"sheet":"Economic analysis","index":3,"n_rows":110,"n_cols":52,"rows_kept":110}
["INPUT DATA"]
[]
["Economic parameters",null,"Contract type","Power_contract"]
["Discount rate %",{"v":0.08,"d":"8%"},"Energy contract",null,"Power contract"]
["Estimated service life [y] ",30,"Energy price valuation [USD/kWh]",{"v":0.092,"d":"0.0920"},"Connection price for preferential loads (yearly) [USD/kW]",320]
["Engineering, consultation and commissioning cost %",{"v":0.1,"d":"10%"},null,null,"Connection price for standard loads (yearly) [USD/kW]",200]
[]
["DATA FROM OTHER SHEETS"]
[]
["Starting IRR ratio",{"v":0,"d":"0.00"}]
["Weir and intake cost [USD]",{"$f":"'Plant informations'!$B$256","v":{"v":115827.97429207801,"d":"115,828"}}]
["Channel and penstock cost [USD]",{"$f":"'Plant informations'!$B$257","v":{"v":142203.16879571765,"d":"142,203"}}]
["Power group cost [USD]",{"$f":"'Turbine informations'!$B$210","v":{"v":555457.2321275488,"d":"555,457"}}]
["Electrical equipment cost [USD]",{"$f":"'Turbine informations'!$B$214","v":{"v":419423.39392229484,"d":"419,423"}}]
["Engineering, consultation and commissioning cost [USD]",{"$f":"B6*SUM(B11:B14)","v":{"v":123291.17691376392,"d":"123,291"}}]
[]
["Net project head [m]",{"$f":"'Site informations'!$B$52","v":{"v":17.099999999999998,"d":"17.10"}}]
["Annual productivity [MWh]",{"$f":"'Turbine informations'!$B$223","v":{"v":2834.056589215979,"d":"2834.06"}}]
["Power group electrical power [kW]",{"$f":"'Turbine informations'!$B$202","v":{"v":340,"d":"340.00"}}]
["Power plant load factor",{"$f":"'Turbine informations'!$B$222","v":{"v":1,"d":"1.00"}}]
["Utilities minimum power [kW]",{"$f":"Simulation!$B$5","v":{"v":275,"d":"275.00"}}]
["Utilities peak power [kW]",{"$f":"Simulation!$B$6","v":{"v":566,"d":"566.00"}}]
["Utilities load factor ",{"$f":"Simulation!$B$4","v":{"v":0.6,"d":"0.60"}}]
[]
["DATA FROM THEORY"]
[]
["Operation and maintenance"]
["1 maintenance cost coefficient % c1*",{"v":0.4,"d":"0.400"}]
["2 maintenance cost coefficient H^c2",{"v":0.01401,"d":"0.014"}]
["3 maintenance cost coefficient P^c3",-0.342]
["Annual operation and maintenance (O&M) cost coefficient %",{"$f":"B28*B17^B29*B19^B30","v":{"v":0.05669809629687592,"d":"6%"}}]
[]
["COMPUTATIONS"]
[]
["Revenues","Energy_contract","Power_contract"]
["First year revenues [USD]",{"$f":"B18*D5*1000","v":{"v":260733.20620787007,"d":"260,733"}},{"$f":"(F5*B21+F6*(B19-B21)/B23)*B20","v":{"v":109666.66666666667,"d":"109,667"}}]
["First year revenues (effective contract) [USD]",{"$f":"HLOOKUP($D$3,$B$35:$C$36,2,FALSE)","v":{"v":109666.66666666667,"d":"109,667"}}]
[]
["Investment cost"]
["1st year carrying charged cost [USD]",{"$f":"SUM(B11:B12)","v":{"v":258031.14308779564,"d":"258,031"}}]
["2nd year carrying charged cost [USD]",{"$f":"SUM(B13:B15)","v":{"v":1098171.8029636075,"d":"1,098,172"}}]
["Investment cost [USD]",{"$f":"SUM($B$11:$B$15)","v":{"v":1356202.946051403,"d":"1,356,203"}}]
["Specific plant cost [USD/kW]",{"$f":"$B$42/$B$19","v":{"v":3988.832194268832,"d":"3,989"}}]
[]
["Net Present Value (NPV) method"]
["Years scenario",0,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,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["Revenues [USD]",0,0,{"$f":"$B$37","v":{"v":109666.66666666667,"d":"109,667"}},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"$f":"$B$37","v":{"v":109666.66666666667,"d":"109,667"}},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"}]
["O&M costs [USD]",0,0,{"$f":"$B$31*$B$42","v":{"v":76894.12523332927,"d":"76,894"}},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"$f":"$B$31*$B$42","v":{"v":76894.12523332927,"d":"76,894"}},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"}]
["Investment cost [USD]",{"$f":"$B$40","v":{"v":258031.14308779564,"d":"258,031"}},{"$f":"$B$41","v":{"v":1098171.8029636075,"d":"1,098,172"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cash flow [USD]",{"$f":"B47-B48-B49","v":{"v":-258031.14308779564,"d":"-258,031"}},{"$f":"C47-C48-C49","v":{"v":-1098171.8029636075,"d":"-1,098,172"}},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"$f":"AH47-AH48-AH49","v":{"v":32772.54143333741,"d":"32,773"}},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"}]
["Actualized cash flow [USD]",{"$f":"B50/(1+$B$4)^B46","v":{"v":-258031.14308779564,"d":"-258,031"}},{"$f":"C50/(1+$B$4)^C46","v":{"v":-1016825.7434848216,"d":"-1,016,826"}},{"$f":"D50/(1+$B$4)^D46","v":{"v":28097.172010748804,"d":"28,097"}},{"v":26015.900009952595,"d":"26,016"},{"v":24088.79630551166,"d":"24,089"},{"v":22304.44102362191,"d":"22,304"},{"v":20652.26020705732,"d":"20,652"},{"v":19122.4631546827,"d":"19,122"},{"v":17705.984402483984,"d":"17,706"},{"v":16394.43000229998,"d":"16,394"},{"v":15180.02777990739,"d":"15,180"},{"v":14055.581277692028,"d":"14,056"},{"v":13014.4271089741,"d":"13,014"},{"v":12050.395471272315,"d":"12,050"},{"v":11157.7735845114,"d":"11,158"},{"v":10331.271837510554,"d":"10,331"},{"v":9565.992442139403,"d":"9,566"},{"v":8857.400409388336,"d":"8,857"},{"v":8201.29667535957,"d":"8,201"},{"v":7593.793217925527,"d":"7,594"},{"v":7031.29001659771,"d":"7,031"},{"v":6510.453719071954,"d":"6,510"},{"v":6028.197888029586,"d":"6,028"},{"v":5581.6647111385055,"d":"5,582"},{"v":5168.2080658689865,"d":"5,168"},{"v":4785.377838767579,"d":"4,785"},{"v":4430.905406266277,"d":"4,431"},{"v":4102.690190987294,"d":"4,103"},{"v":3798.787213877124,"d":"3,799"},{"v":3517.395568404744,"d":"3,517"},{"v":3256.847748522911,"d":"3,257"},{"v":3015.599767150843,"d":"3,016"},{"v":2792.2220066211507,"d":"2,792"},{"v":2585.390746871436,"d":"2,585"},{"v":2393.8803211772556,"d":"2,394"},{"v":2216.555852941903,"d":"2,217"},{"v":2052.3665305017616,"d":"2,052"},{"v":1900.3393800942238,"d":"1,900"},{"v":1759.5735000872442,"d":"1,760"},{"v":1629.2347223030038,"d":"1,629"},{"v":1508.5506687990776,"d":"1,509"},{"v":1396.8061748139605,"d":"1,397"},{"v":1293.3390507536674,"d":"1,293"},{"v":1197.5361581052475,"d":"1,198"},{"v":1108.829776023377,"d":"1,109"},{"v":1026.6942370586826,"d":"1,027"},{"v":950.6428120913725,"d":"951"},{"v":880.22482601053,"d":"880"},{"v":815.0229870467872,"d":"815"},{"v":754.6509139322103,"d":"755"},{"v":698.750846233528,"d":"699"}]
["NPV(t) [USD]",{"$f":"B51","v":{"v":-258031.14308779564,"d":"-258,031"}},{"$f":"C51+B52","v":{"v":-1274856.8865726173,"d":"-1,274,857"}},{"$f":"D51+C52","v":{"v":-1246759.7145618685,"d":"-1,246,760"}},{"$f":"E51+D52","v":{"v":-1220743.814551916,"d":"-1,220,744"}},{"v":-1196655.0182464044,"d":"-1,196,655"},{"v":-1174350.5772227824,"d":"-1,174,351"},{"v":-1153698.3170157252,"d":"-1,153,698"},{"v":-1134575.8538610425,"d":"-1,134,576"},{"v":-1116869.8694585585,"d":"-1,116,870"},{"v":-1100475.4394562584,"d":"-1,100,475"},{"v":-1085295.411676351,"d":"-1,085,295"},{"v":-1071239.830398659,"d":"-1,071,240"},{"v":-1058225.4032896848,"d":"-1,058,225"},{"v":-1046175.0078184125,"d":"-1,046,175"},{"v":-1035017.2342339011,"d":"-1,035,017"},{"v":-1024685.9623963906,"d":"-1,024,686"},{"v":-1015119.9699542512,"d":"-1,015,120"},{"v":-1006262.5695448628,"d":"-1,006,263"},{"v":-998061.2728695032,"d":"-998,061"},{"v":-990467.4796515778,"d":"-990,467"},{"v":-983436.18963498,"d":"-983,436"},{"v":-976925.7359159081,"d":"-976,926"},{"v":-970897.5380278785,"d":"-970,898"},{"v":-965315.87331674,"d":"-965,316"},{"v":-960147.6652508711,"d":"-960,148"},{"v":-955362.2874121035,"d":"-955,362"},{"v":-950931.3820058372,"d":"-950,931"},{"v":-946828.6918148499,"d":"-946,829"},{"v":-943029.9046009728,"d":"-943,030"},{"v":-939512.5090325681,"d":"-939,513"},{"v":-936255.6612840452,"d":"-936,256"},{"v":-933240.0615168944,"d":"-933,240"},{"v":-930447.8395102732,"d":"-930,448"},{"$f":"AI51+AH52","v":{"v":-927862.4487634017,"d":"-927,862"}},{"v":-925468.5684422244,"d":"-925,469"},{"v":-923252.0125892825,"d":"-923,252"},{"v":-921199.6460587807,"d":"-921,200"},{"v":-919299.3066786865,"d":"-919,299"},{"v":-917539.7331785993,"d":"-917,540"},{"v":-915910.4984562963,"d":"-915,910"},{"v":-914401.9477874972,"d":"-914,402"},{"v":-913005.1416126832,"d":"-913,005"},{"v":-911711.8025619296,"d":"-911,712"},{"v":-910514.2664038243,"d":"-910,514"},{"v":-909405.4366278009,"d":"-909,405"},{"v":-908378.7423907423,"d":"-908,379"},{"v":-907428.0995786509,"d":"-907,428"},{"v":-906547.8747526404,"d":"-906,548"},{"v":-905732.8517655936,"d":"-905,733"},{"v":-904978.2008516614,"d":"-904,978"},{"v":-904279.4500054278,"d":"-904,279"}]
["Net Present Value(SL) [USD]",{"$f":"HLOOKUP($B$5,$B$46:$AZ$52,7,FALSE)","v":{"v":-936255.6612840452,"d":"-936,256"}}]
[]
["Pay Back Time (PBT) method"]
["Pay Back Time [y]",{"$f":"$B$42/$B$37","v":{"v":12.366592213234677,"d":"12.37"}}]
[]
["Levelized energy cost (LEC) [USD/kWh] method"]
["Years scenario",0,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,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["O&M costs [USD]",0,0,{"$f":"$B$31*$B$42","v":{"v":76894.12523332927,"d":"76,894"}},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"$f":"$B$31*$B$42","v":{"v":76894.12523332927,"d":"76,894"}},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"}]
["Investment cost [USD]",{"$f":"$B$40","v":{"v":258031.14308779564,"d":"258,031"}},{"$f":"$B$41","v":{"v":1098171.8029636075,"d":"1,098,172"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LEC(t) numerator [USD]",{"$f":"(B60+B61)/(1+$B$4)^B$59","v":{"v":258031.14308779564,"d":"258,031"}},{"$f":"((C60+C61)/(1+$B$4)^C$59)+B62","v":{"v":1274856.8865726173,"d":"1,274,857"}},{"$f":"((D60+D61)/(1+$B$4)^D$59)+C62","v":{"v":1340781.2051882974,"d":"1,340,781"}},{"v":1401822.240943557,"d":"1,401,822"},{"v":1458341.7184947229,"d":"1,458,342"},{"v":1510674.5680791358,"d":"1,510,675"},{"v":1559130.9102869257,"d":"1,559,131"},{"v":1603997.893812657,"d":"1,603,998"},{"v":1645541.397077223,"d":"1,645,541"},{"v":1684007.603803673,"d":"1,684,008"},{"v":1719624.4618837193,"d":"1,719,624"},{"v":1752603.0341800584,"d":"1,752,603"},{"v":1783138.7492692613,"d":"1,783,139"},{"v":1811412.5595370417,"d":"1,811,413"},{"v":1837592.0134886904,"d":"1,837,592"},{"v":1861832.2486291057,"d":"1,861,832"},{"v":1884276.910796157,"d":"1,884,277"},{"v":1905059.0053952786,"d":"1,905,059"},{"v":1924301.6855796503,"d":"1,924,302"},{"v":1942118.9820466612,"d":"1,942,119"},{"v":1958616.478775375,"d":"1,958,616"},{"v":1973891.9387093694,"d":"1,973,892"},{"v":1988035.8830926975,"d":"1,988,036"},{"v":2001132.1278920753,"d":"2,001,132"},{"v":2013258.2804840917,"d":"2,013,258"},{"v":2024486.1995507737,"d":"2,024,486"},{"v":2034882.4209088124,"d":"2,034,882"},{"v":2044508.5517958854,"d":"2,044,509"},{"v":2053421.6359505826,"d":"2,053,422"},{"v":2061674.4916493762,"d":"2,061,674"},{"v":2069316.0247038149,"d":"2,069,316"},{"v":2076391.5182727396,"d":"2,076,392"},{"v":2082942.901206929,"d":"2,082,943"},{"v":2089008.9965163637,"d":"2,089,009"},{"v":2094625.7514325068,"d":"2,094,626"},{"v":2099826.4504289357,"d":"2,099,826"},{"v":2104641.912462666,"d":"2,104,642"},{"v":2109100.6736050094,"d":"2,109,101"},{"v":2113229.156144216,"d":"2,113,229"},{"v":2117051.825162,"d":"2,117,052"},{"v":2120591.3335118,"d":"2,120,591"},{"v":2123868.656057911,"d":"2,123,869"},{"v":2126903.213970977,"d":"2,126,903"},{"v":2129712.989816408,"d":"2,129,713"},{"v":2132314.634117733,"d":"2,132,315"},{"v":2134723.564026368,"d":"2,134,724"},{"v":2136954.054682511,"d":"2,136,954"},{"v":2139019.3238085695,"d":"2,139,019"},{"v":2140931.610036401,"d":"2,140,932"},{"v":2142702.2454325417,"d":"2,142,702"},{"v":2144341.72265119,"d":"2,144,342"}]
["LEC(t) denominator [kWh]",{"$f":"$B$18*1000/(1+$B$4)^B$59","v":{"v":2834056.589215979,"d":"2,834,057"}},{"$f":"($B$18*1000/(1+$B$4)^C$59)+B63","v":{"v":5458183.060712256,"d":"5,458,183"}},{"$f":"($B$18*1000/(1+$B$4)^D$59)+C63","v":{"v":7887929.793579178,"d":"7,887,930"}},{"v":10137695.286974477,"d":"10,137,695"},{"v":12220811.484562716,"d":"12,220,811"},{"v":14149622.7786259,"d":"14,149,623"},{"v":15935559.162017737,"d":"15,935,559"},{"v":17589203.961454622,"d":"17,589,204"},{"v":19120356.553525813,"d":"19,120,357"},{"v":20538090.43507321,"d":"20,538,090"},{"v":21850806.992061544,"d":"21,850,807"},{"v":23066285.285569258,"d":"23,066,285"},{"v":24191728.149928253,"d":"24,191,728"},{"v":25233804.876186583,"d":"25,233,805"},{"v":26198690.733833183,"d":"26,198,691"},{"v":27092103.564987443,"d":"27,092,104"},{"v":27919337.667908054,"d":"27,919,338"},{"v":28685295.170612324,"d":"28,685,295"},{"v":29394515.080523685,"d":"29,394,515"},{"v":30051200.182293463,"d":"30,051,200"},{"v":30659241.943191405,"d":"30,659,242"},{"v":31222243.573652465,"d":"31,222,244"},{"v":31743541.379634928,"d":"31,743,541"},{"v":32226224.533322394,"d":"32,226,225"},{"v":32673153.379329305,"d":"32,673,153"},{"v":33086976.38489126,"d":"33,086,976"},{"v":33470145.83448566,"d":"33,470,146"},{"v":33824932.36188789,"d":"33,824,932"},{"v":34153438.40577883,"d":"34,153,438"},{"v":34457610.66864082,"d":"34,457,611"},{"v":34739251.65277229,"d":"34,739,252"},{"v":35000030.34178291,"d":"35,000,030"},{"v":35241492.09086682,"d":"35,241,492"},{"v":35465067.78446303,"d":"35,465,068"},{"v":35672082.31557064,"d":"35,672,082"},{"v":35863762.43696657,"d":"35,863,762"},{"v":36041244.030851685,"d":"36,041,244"},{"v":36205578.84000457,"d":"36,205,579"},{"v":36357740.70033132,"d":"36,357,741"},{"v":36498631.31174498,"d":"36,498,631"},{"v":36629085.58157244,"d":"36,629,086"},{"v":36749876.57215343,"d":"36,749,877"},{"v":36861720.081950635,"d":"36,861,720"},{"v":36965278.88731842,"d":"36,965,279"},{"v":37061166.670066364,"d":"37,061,167"},{"v":37149951.65409224,"d":"37,149,952"},{"v":37232159.97263472,"d":"37,232,160"},{"v":37308278.78609998,"d":"37,308,279"},{"v":37378759.16893818,"d":"37,378,759"},{"v":37444018.782677256,"d":"37,444,019"},{"v":37504444.350954175,"d":"37,504,444"}]
["Levelized Energy Cost [USD/kWh]",{"$f":"HLOOKUP($B$5,$B$59:$AZ$63,4,FALSE)/HLOOKUP($B$5,$B$59:$AZ$63,5,FALSE)","v":{"v":0.0595670869766326,"d":"0.0596"}}]
[]
["Internal Rate of Return (IRR) method"]
["Years scenario",0,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,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["Revenues [USD]",0,0,{"$f":"$B$37","v":{"v":109666.66666666667,"d":"109,667"}},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"$f":"$B$37","v":{"v":109666.66666666667,"d":"109,667"}},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"},{"v":109666.66666666667,"d":"109,667"}]
["O&M costs [USD]",0,0,{"$f":"$B$31*$B$42","v":{"v":76894.12523332927,"d":"76,894"}},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"$f":"$B$31*$B$42","v":{"v":76894.12523332927,"d":"76,894"}},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"},{"v":76894.12523332927,"d":"76,894"}]
["Investment cost [USD]",{"$f":"$B$40","v":{"v":258031.14308779564,"d":"258,031"}},{"$f":"$B$41","v":{"v":1098171.8029636075,"d":"1,098,172"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cash flow [USD]",{"$f":"B68-B69-B70","v":{"v":-258031.14308779564,"d":"-258,031"}},{"v":-1098171.8029636075,"d":"-1,098,172"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"$f":"AH68-AH69-AH70","v":{"v":32772.54143333741,"d":"32,773"}},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"},{"v":32772.54143333741,"d":"32,773"}]
["Internal Rate of Return %",{"$f":"IRR($B$71:INDEX($B$67:$AZ$71,5,$B$5),$B$10)","v":{"v":-0.024877357007197426,"d":"-2.49%"}}]
[]
[]
["SHEET OUTPUT"]
[]
["First year revenues [USD]",{"$f":"$B$37","v":{"v":109666.66666666667,"d":"109,667"}}]
["Specific plant cost [USD/kW]",{"$f":"$B$43","v":{"v":3988.832194268832,"d":"3,989"}}]
[]
["Investment cost [USD]",{"$f":"$B$42","v":{"v":1356202.946051403,"d":"1,356,203"}}]
["Net Present Value(SL) [USD]",{"$f":"$B$53","v":{"v":-936255.6612840452,"d":"-936,256"}}]
["Pay Back Time [y]",{"$f":"$B$56","v":{"v":12.366592213234677,"d":"12.37"}}]
["Levelized Energy Cost [USD/kWh]",{"$f":"$B$64","v":{"v":0.0595670869766326,"d":"0.0596"}}]
["Internal Rate of Return %",{"$f":"$B$72","v":{"v":-0.024877357007197426,"d":"-2.49%"}}]
{"$rows_empty":25}
["END SHEET"]

{"sheet":"Simulation","index":4,"n_rows":180,"n_cols":12,"rows_kept":180}
["INPUT DATA"]
[]
["Utilities data"]
["Utilities load factor ",{"v":0.6,"d":"0.60"}]
["Utilities minimum power (preferential loads) [kW]",{"v":275,"d":"275.00"}]
["Utilities peak power (total loads) [kW]",{"v":566,"d":"566.00"}]
[]
["SHEET OUTPUT"]
{"$rows_empty":37}
["Maximize annual productivity",null,"Maximize Net Present Value",null,"Minimize Levelized Energy Cost",null,"Maximize Internal Rate of Return"]
["Max annual productivity power [kW]",{"v":342.60606060606057,"d":"342.61"},"Max Net Present Value power [kW]",{"v":342.60606060606057,"d":"342.61"},"Min Levelized Energy Cost power [kW]",{"v":342.60606060606057,"d":"342.61"},"Max Internal Rate of Return power [kW]",{"v":342.60606060606057,"d":"342.61"}]
["Equivalent hours [h]",{"v":8286.648505218469,"d":"8287"},"Equivalent hours [h]",{"v":8286.648505218469,"d":"8287"},"Equivalent hours [h]",{"v":8286.648505218469,"d":"8287"},"Equivalent hours [h]",{"v":8286.648505218469,"d":"8287"}]
["Operative hours [h]",8760,"Operative hours [h]",8760,"Operative hours [h]",8760,"Operative hours [h]",8760]
["Power plant load factor",{"v":1,"d":"1.00"},"Power plant load factor",{"v":1,"d":"1.00"},"Power plant load factor",{"v":1,"d":"1.00"},"Power plant load factor",{"v":1,"d":"1.00"}]
["Annual productivity [MWh]",{"v":2839.056,"d":"2839.06"},"Annual productivity [MWh]",{"v":2839.056,"d":"2839.06"},"Annual productivity [MWh]",{"v":2839.056,"d":"2839.06"},"Annual productivity [MWh]",{"v":2839.056,"d":"2839.06"}]
["Investment cost [USD]",{"v":1359692.8576723353,"d":"1,359,693"},"Investment cost [USD]",{"v":1359692.8576723353,"d":"1,359,693"},"Investment cost [USD]",{"v":1359692.8576723353,"d":"1,359,693"},"Investment cost [USD]",{"v":1359692.8576723353,"d":"1,359,693"}]
["NPV [USD]",{"v":626046.3418704635,"d":"626,046"},"NPV [USD]",{"v":626046.3418704635,"d":"626,046"},"NPV [USD]",{"v":626046.3418704635,"d":"626,046"},"NPV [USD]",{"v":626046.3418704635,"d":"626,046"}]
["PBT [y]",{"v":5.205698722424144,"d":"5.21"},"PBT [y]",{"v":5.205698722424144,"d":"5.21"},"PBT [y]",{"v":5.205698722424144,"d":"5.21"},"PBT [y]",{"v":5.205698722424144,"d":"5.21"}]
["LEC [USD/kWh]",{"v":0.059555525838551275,"d":"0.0596"},"LEC [USD/kWh]",{"v":0.059555525838551275,"d":"0.0596"},"LEC [USD/kWh]",{"v":0.059555525838551275,"d":"0.0596"},"LEC [USD/kWh]",{"v":0.059555525838551275,"d":"0.0596"}]
["IRR %",{"v":0.1277640238690675,"d":"12.78%"},"IRR %",{"v":0.1277640238690675,"d":"12.78%"},"IRR %",{"v":0.1277640238690675,"d":"12.78%"},"IRR %",{"v":0.1277640238690675,"d":"12.78%"}]
{"$rows_empty":8}
["COMPUTATIONS"]
[]
["Simulation power step [kW]",{"$f":"($B$6-$B$5)/99","v":{"v":2.9393939393939394,"d":"2.94"}}]
[]
["Table Simulation"]
["Power group electrical power [kW]","Equivalent hours [h]","Operative hours [h]","Power plant load factor","Annual productivity [MWh]","Investment cost [USD]","NPV [USD]","PBT [y]","LEC [USD/kWh]","IRR %","Power group electrical power [kW]","Row counter"]
[{"$f":"$B$5","v":{"v":275,"d":"275.00"}},{"v":8380.954304691131,"d":"8380.95"},{"v":6552,"d":"6552.00"},{"v":0.7479452054794521,"d":"0.75"},{"v":2304.762433790061,"d":"2304.76"},{"v":1259896.0282220745,"d":"1,259,896"},{"v":213053.3377156577,"d":"213,053"},{"v":5.941836713891674,"d":"5.94"},{"v":0.0700037177858071,"d":"0.0700"},{"v":0.09763692073579743,"d":"0.10"},{"$f":"$B$5","v":{"v":275,"d":"275.00"}},{"v":1,"d":"1.00"}]
[{"$f":"A71+$B$67","v":{"v":277.93939393939394,"d":"277.94"}},{"v":8379.154239870468,"d":"8379.15"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2328.897051154301,"d":"2328.90"},{"v":1264243.9749708865,"d":"1,264,244"},{"v":232061.86781547248,"d":"232,062"},{"v":5.900553796411505,"d":"5.90"},{"v":0.06941600465660602,"d":"0.0694"},{"v":0.09918565431036447,"d":"0.10"},{"$f":"K71+$B$67","v":{"v":277.93939393939394,"d":"277.94"}},{"v":2,"d":"2.00"}]
[{"$f":"A72+$B$67","v":{"v":280.8787878787879,"d":"280.88"}},{"v":8377.350737072024,"d":"8377.35"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2353.0201206642605,"d":"2353.02"},{"v":1268541.7764681934,"d":"1,268,542"},{"v":251118.23262297173,"d":"251,118"},{"v":5.859914859722466,"d":"5.86"},{"v":0.06883864647841846,"d":"0.0688"},{"v":0.10072227552087731,"d":"0.10"},{"$f":"K72+$B$67","v":{"v":280.8787878787879,"d":"280.88"}},{"v":3,"d":"3.00"}]
[{"v":283.8181818181818,"d":"283.82"},{"v":8375.543719098141,"d":"8375.54"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2377.1315900931268,"d":"2377.13"},{"v":1272845.912967023,"d":"1,272,846"},{"v":270131.3541314497,"d":"270,131"},{"v":5.82015809320132,"d":"5.82"},{"v":0.06827444509557654,"d":"0.0683"},{"v":0.10223856486294246,"d":"0.10"},{"v":283.8181818181818,"d":"283.82"},{"v":4,"d":"4.00"}]
[{"v":286.75757575757575,"d":"286.76"},{"v":8373.733105478186,"d":"8373.73"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2401.231405367881,"d":"2401.23"},{"v":1277100.432817505,"d":"1,277,100"},{"v":289192.1227407999,"d":"289,192"},{"v":5.781003202205666,"d":"5.78"},{"v":0.06771990781360186,"d":"0.0677"},{"v":0.10374368445244844,"d":"0.10"},{"v":286.75757575757575,"d":"286.76"},{"v":5,"d":"5.00"}]
[{"v":289.6969696969697,"d":"289.70"},{"v":8371.918812248208,"d":"8371.92"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2425.3195104573597,"d":"2425.32"},{"v":1281333.7853609005,"d":"1,281,334"},{"v":308254.86417925876,"d":"308,255"},{"v":5.742559314422356,"d":"5.74"},{"v":0.06717627466140472,"d":"0.0672"},{"v":0.10523370789956428,"d":"0.11"},{"v":289.6969696969697,"d":"289.70"},{"v":6,"d":"6.00"}]
[{"v":292.6363636363636,"d":"292.64"},{"v":8370.100751709822,"d":"8370.10"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2449.395847250356,"d":"2449.40"},{"v":1285574.7752075836,"d":"1,285,575"},{"v":327273.5620246592,"d":"327,274"},{"v":5.70493286197024,"d":"5.70"},{"v":0.06664474852592833,"d":"0.0666"},{"v":0.10670462488807346,"d":"0.11"},{"v":292.6363636363636,"d":"292.64"},{"v":7,"d":"7.00"}]
[{"v":295.57575757575756,"d":"295.58"},{"v":8368.278832165583,"d":"8368.28"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2473.4603554225178,"d":"2473.46"},{"v":1294897.7106294194,"d":"1,294,898"},{"v":338090.2782907623,"d":"338,090"},{"v":5.690398507775102,"d":"5.69"},{"v":0.06639403689859502,"d":"0.0664"},{"v":0.10737235558393227,"d":"0.11"},{"v":295.57575757575756,"d":"295.58"},{"v":8,"d":"8.00"}]
[{"v":298.5151515151515,"d":"298.52"},{"v":8366.452957628031,"d":"8366.45"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2497.512972290719,"d":"2497.51"},{"v":1299098.8761189494,"d":"1,299,099"},{"v":357121.43810108013,"d":"357,121"},{"v":5.653880526139256,"d":"5.65"},{"v":0.06587977904978962,"d":"0.0659"},{"v":0.10881440164835791,"d":"0.11"},{"v":298.5151515151515,"d":"298.52"},{"v":9,"d":"9.00"}]
[{"v":301.45454545454544,"d":"301.45"},{"v":8364.62302749887,"d":"8364.62"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2521.5536326532956,"d":"2521.55"},{"v":1303251.5988468064,"d":"1,303,252"},{"v":376199.6218452264,"d":"376,200"},{"v":5.617877036162409,"d":"5.62"},{"v":0.06537375287913585,"d":"0.0654"},{"v":0.11024722753222123,"d":"0.11"},{"v":301.45454545454544,"d":"301.45"},{"v":10,"d":"10.00"}]
[{"v":304.3939393939394,"d":"304.39"},{"v":8362.788936214345,"d":"8362.79"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2545.5822686143365,"d":"2545.58"},{"v":1307384.740595258,"d":"1,307,385"},{"v":395278.7280325693,"d":"395,279"},{"v":5.582496341733961,"d":"5.58"},{"v":0.06487719515723565,"d":"0.0649"},{"v":0.1116667742376538,"d":"0.11"},{"v":304.3939393939394,"d":"304.39"},{"v":11,"d":"11.00"}]
[{"v":307.3333333333333,"d":"307.33"},{"v":8360.950572852173,"d":"8360.95"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2569.598809389901,"d":"2569.60"},{"v":1311527.5086571053,"d":"1,311,528"},{"v":414312.3216951718,"d":"414,312"},{"v":5.54784417616378,"d":"5.55"},{"v":0.06439130716787414,"d":"0.0644"},{"v":0.11306890126853424,"d":"0.11"},{"v":307.3333333333333,"d":"307.33"},{"v":12,"d":"12.00"}]
[{"v":310.27272727272725,"d":"310.27"},{"v":8359.107820694562,"d":"8359.11"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2593.603181093685,"d":"2593.60"},{"v":1315622.452292078,"d":"1,315,622"},{"v":433392.63467957673,"d":"433,393"},{"v":5.5136592023390465,"d":"5.51"},{"v":0.06391288420436393,"d":"0.0639"},{"v":0.11446283629408972,"d":"0.11"},{"v":310.27272727272725,"d":"310.27"},{"v":13,"d":"13.00"}]
[{"v":313.2121212121212,"d":"313.21"},{"v":8357.260556740963,"d":"8357.26"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2617.5953064992295,"d":"2617.60"},{"v":1319727.7631437068,"d":"1,319,728"},{"v":452426.89734643913,"d":"452,427"},{"v":5.48016989298368,"d":"5.48"},{"v":0.06344460509498419,"d":"0.0634"},{"v":0.1158399285308156,"d":"0.12"},{"v":313.2121212121212,"d":"313.21"},{"v":14,"d":"14.00"}]
[{"v":316.1515151515151,"d":"316.15"},{"v":8355.408651162988,"d":"8355.41"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2641.575104775256,"d":"2641.58"},{"v":1323785.6291849203,"d":"1,323,786"},{"v":471507.6650244076,"d":"471,508"},{"v":5.447119108693705,"d":"5.45"},{"v":0.0629833280633847,"d":"0.0630"},{"v":0.11720944831896322,"d":"0.12"},{"v":316.1515151515151,"d":"316.15"},{"v":15,"d":"15.00"}]
[{"v":319.09090909090907,"d":"319.09"},{"v":8353.55196669257,"d":"8353.55"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2665.5424911900836,"d":"2665.54"},{"v":1327879.6458378057,"d":"1,327,880"},{"v":490501.92625024286,"d":"490,502"},{"v":5.414835613757704,"d":"5.41"},{"v":0.06253292816609085,"d":"0.0625"},{"v":0.11855876633571671,"d":"0.12"},{"v":319.09090909090907,"d":"319.09"},{"v":16,"d":"16.00"}]
[{"v":322.030303030303,"d":"322.03"},{"v":8351.690357932614,"d":"8351.69"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2689.497376780299,"d":"2689.50"},{"v":1331930.7990765302,"d":"1,331,931"},{"v":509535.841737715,"d":"509,536"},{"v":5.3829792921925215,"d":"5.38"},{"v":0.06208928101562886,"d":"0.0621"},{"v":0.1199004221811411,"d":"0.12"},{"v":322.030303030303,"d":"322.03"},{"v":17,"d":"17.00"}]
[{"v":324.96969696969694,"d":"324.97"},{"v":8349.823670577478,"d":"8349.82"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2713.439667977966,"d":"2713.44"},{"v":1335935.0326665405,"d":"1,335,935"},{"v":528615.9175809331,"d":"528,616"},{"v":5.3515223261211124,"d":"5.35"},{"v":0.06165200547906186,"d":"0.0617"},{"v":0.12123534883307208,"d":"0.12"},{"v":324.96969696969694,"d":"324.97"},{"v":18,"d":"18.00"}]
[{"v":327.9090909090909,"d":"327.91"},{"v":8347.951740527767,"d":"8347.95"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2737.3692661894233,"d":"2737.37"},{"v":1339951.3634430212,"d":"1,339,951"},{"v":547648.5622488988,"d":"547,649"},{"v":5.320688338607384,"d":"5.32"},{"v":0.061223717019929694,"d":"0.0612"},{"v":0.12255466764175249,"d":"0.12"},{"v":327.9090909090909,"d":"327.91"},{"v":19,"d":"19.00"}]
[{"v":330.8484848484848,"d":"330.85"},{"v":8346.074392880755,"d":"8346.07"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2761.286067317336,"d":"2761.29"},{"v":1343921.097430324,"d":"1,343,921"},{"v":566727.1192171718,"d":"566,727"},{"v":5.290229863702209,"d":"5.29"},{"v":0.06080141766560511,"d":"0.0608"},{"v":0.12386776895657474,"d":"0.12"},{"v":330.8484848484848,"d":"330.85"},{"v":20,"d":"20.00"}]
[{"v":333.78787878787875,"d":"333.79"},{"v":8344.19144077368,"d":"8344.19"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2785.189961215821,"d":"2785.19"},{"v":1347873.89912489,"d":"1,347,874"},{"v":585804.6429200765,"d":"585,805"},{"v":5.260252785401387,"d":"5.26"},{"v":0.06038632170823309,"d":"0.0604"},{"v":0.12517030768912946,"d":"0.13"},{"v":333.78787878787875,"d":"333.79"},{"v":21,"d":"21.00"}]
[{"v":336.7272727272727,"d":"336.73"},{"v":8342.302684051865,"d":"8342.30"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2809.080831066191,"d":"2809.08"},{"v":1351839.7606839668,"d":"1,351,840"},{"v":604833.8677596598,"d":"604,834"},{"v":5.230860671474496,"d":"5.23"},{"v":0.05997961148229791,"d":"0.0600"},{"v":0.12645785911909396,"d":"0.13"},{"v":336.7272727272727,"d":"336.73"},{"v":22,"d":"22.00"}]
[{"v":339.66666666666663,"d":"339.67"},{"v":8339.400428639363,"d":"8339.40"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2832.6163455945034,"d":"2832.62"},{"v":1355759.4726290915,"d":"1,355,759"},{"v":623583.315985926,"d":"623,583"},{"v":5.202439797312221,"d":"5.20"},{"v":0.05958556488986702,"d":"0.0596"},{"v":0.12771584837656902,"d":"0.13"},{"v":339.66666666666663,"d":"339.67"},{"v":23,"d":"23.00"}]
[{"v":342.60606060606057,"d":"342.61"},{"v":8286.648505218469,"d":"8286.65"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1359692.8576723353,"d":"1,359,693"},{"v":626046.3418704635,"d":"626,046"},{"v":5.205698722424144,"d":"5.21"},{"v":0.059555525838551275,"d":"0.0596"},{"v":0.12776402386907196,"d":"0.13"},{"v":342.60606060606057,"d":"342.61"},{"v":24,"d":"24.00"}]
[{"v":345.5454545454545,"d":"345.55"},{"v":8216.157853196528,"d":"8216.16"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1363635.0469146157,"d":"1,363,635"},{"v":622360.0656323326,"d":"622,360"},{"v":5.220791726249453,"d":"5.22"},{"v":0.059661451693232094,"d":"0.0597"},{"v":0.12735941630318456,"d":"0.13"},{"v":345.5454545454545,"d":"345.55"},{"v":25,"d":"25.00"}]
[{"v":348.48484848484844,"d":"348.48"},{"v":8146.856347826088,"d":"8146.86"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1367506.7749501795,"d":"1,367,507"},{"v":618770.7122090199,"d":"618,771"},{"v":5.235614963405241,"d":"5.24"},{"v":0.05976459245224068,"d":"0.0598"},{"v":0.12696656884620414,"d":"0.13"},{"v":348.48484848484844,"d":"348.48"},{"v":26,"d":"26.00"}]
[{"v":351.4242424242424,"d":"351.42"},{"v":8078.714150211263,"d":"8078.71"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1371393.0565963038,"d":"1,371,393"},{"v":615144.5505100301,"d":"615,145"},{"v":5.250493920285873,"d":"5.25"},{"v":0.059868790904110146,"d":"0.0599"},{"v":0.12657231208987257,"d":"0.13"},{"v":351.4242424242424,"d":"351.42"},{"v":27,"d":"27.00"}]
[{"v":354.3636363636363,"d":"354.36"},{"v":8011.702411493075,"d":"8011.70"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1380777.5325855375,"d":"1,380,778"},{"v":602868.0784898943,"d":"602,868"},{"v":5.2864231776855215,"d":"5.29"},{"v":0.0602215576820708,"d":"0.0602"},{"v":0.12534446804159896,"d":"0.13"},{"v":354.3636363636363,"d":"354.36"},{"v":28,"d":"28.00"}]
[{"v":357.30303030303025,"d":"357.30"},{"v":7945.793232126199,"d":"7945.79"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1384603.628069889,"d":"1,384,604"},{"v":599318.4610116275,"d":"599,318"},{"v":5.301071706772347,"d":"5.30"},{"v":0.06032355662107765,"d":"0.0603"},{"v":0.12496522458128304,"d":"0.12"},{"v":357.30303030303025,"d":"357.30"},{"v":29,"d":"29.00"}]
[{"v":360.2424242424242,"d":"360.24"},{"v":7880.959623149395,"d":"7880.96"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1388445.1121949153,"d":"1,388,445"},{"v":595731.4267659426,"d":"595,731"},{"v":5.315779152567198,"d":"5.32"},{"v":0.06042663073807227,"d":"0.0604"},{"v":0.1245844440302716,"d":"0.12"},{"v":360.2424242424242,"d":"360.24"},{"v":30,"d":"30.00"}]
[{"v":363.18181818181813,"d":"363.18"},{"v":7817.175469336672,"d":"7817.18"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1392241.4463186855,"d":"1,392,241"},{"v":592202.1323235282,"d":"592,202"},{"v":5.330313737776271,"d":"5.33"},{"v":0.06052804569074622,"d":"0.0605"},{"v":0.12421119271485258,"d":"0.12"},{"v":363.18181818181813,"d":"363.18"},{"v":31,"d":"31.00"}]
[{"v":366.12121212121207,"d":"366.12"},{"v":7754.415494123491,"d":"7754.42"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1396053.704447955,"d":"1,396,054"},{"v":588635.0898271459,"d":"588,635"},{"v":5.344909289382728,"d":"5.34"},{"v":0.060630545340990466,"d":"0.0606"},{"v":0.12383633464905626,"d":"0.12"},{"v":366.12121212121207,"d":"366.12"},{"v":32,"d":"32.00"}]
[{"v":369.060606060606,"d":"369.06"},{"v":7692.65522620905,"d":"7692.66"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1399821.025234951,"d":"1,399,821"},{"v":585125.7574134788,"d":"585,126"},{"v":5.3593327945862494,"d":"5.36"},{"v":0.06073138668093992,"d":"0.0607"},{"v":0.12346889561792368,"d":"0.12"},{"v":369.060606060606,"d":"369.06"},{"v":33,"d":"33.00"}]
[{"v":371.99999999999994,"d":"372.00"},{"v":7631.8709677419365,"d":"7631.87"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1403574.0715799048,"d":"1,403,574"},{"v":581626.3103087104,"d":"581,626"},{"v":5.373701648885131,"d":"5.37"},{"v":0.06083194396464227,"d":"0.0608"},{"v":0.1231042926190202,"d":"0.12"},{"v":371.99999999999994,"d":"372.00"},{"v":34,"d":"34.00"}]
[{"v":374.9393939393939,"d":"374.94"},{"v":7572.039764002264,"d":"7572.04"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1407398.8628263976,"d":"1,407,399"},{"v":578002.763981269,"d":"578,003"},{"v":5.388345184587372,"d":"5.39"},{"v":0.06093606726330872,"d":"0.0609"},{"v":0.12272994353239412,"d":"0.12"},{"v":374.9393939393939,"d":"374.94"},{"v":35,"d":"35.00"}]
[{"v":377.8787878787878,"d":"377.88"},{"v":7513.139374498798,"d":"7513.14"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1411123.998154603,"d":"1,411,124"},{"v":574522.7806503306,"d":"574,523"},{"v":5.402607179205843,"d":"5.40"},{"v":0.06103606525173719,"d":"0.0610"},{"v":0.12237093047810951,"d":"0.12"},{"v":377.8787878787878,"d":"377.88"},{"v":36,"d":"36.00"}]
[{"v":380.81818181818176,"d":"380.82"},{"v":7455.148245404633,"d":"7455.15"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1414835.3766115983,"d":"1,414,835"},{"v":571052.4238439075,"d":"571,052"},{"v":5.4168165044832355,"d":"5.42"},{"v":0.06113578662013744,"d":"0.0611"},{"v":0.12201462981541393,"d":"0.12"},{"v":380.81818181818176,"d":"380.82"},{"v":37,"d":"37.00"}]
[{"v":383.7575757575757,"d":"383.76"},{"v":7398.045483259635,"d":"7398.05"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1418564.1874917503,"d":"1,418,564"},{"v":567543.3587357247,"d":"567,543"},{"v":5.431092571262168,"d":"5.43"},{"v":0.061236620279012534,"d":"0.0612"},{"v":0.12165653416520501,"d":"0.12"},{"v":383.7575757575757,"d":"383.76"},{"v":38,"d":"38.00"}]
[{"v":386.69696969696963,"d":"386.70"},{"v":7341.810829872268,"d":"7341.81"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1422248.6224295157,"d":"1,422,249"},{"v":564091.9316277846,"d":"564,092"},{"v":5.445198741004955,"d":"5.45"},{"v":0.061335797698896445,"d":"0.0613"},{"v":0.12130555105075917,"d":"0.12"},{"v":386.69696969696963,"d":"386.70"},{"v":39,"d":"39.00"}]
[{"v":389.63636363636357,"d":"389.64"},{"v":7286.424638357444,"d":"7286.42"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1425919.788271623,"d":"1,425,920"},{"v":560649.8822577755,"d":"560,650"},{"v":5.459254108896481,"d":"5.46"},{"v":0.06143470564768238,"d":"0.0614"},{"v":0.12095716481572925,"d":"0.12"},{"v":389.63636363636357,"d":"389.64"},{"v":40,"d":"40.00"}]
[{"v":392.5757575757575,"d":"392.58"},{"v":7231.86785025087,"d":"7231.87"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1429609.0908620171,"d":"1,429,609"},{"v":557168.663308471,"d":"557,169"},{"v":5.473378914857681,"d":"5.47"},{"v":0.0615347391418416,"d":"0.0615"},{"v":0.12060689999225958,"d":"0.12"},{"v":392.5757575757575,"d":"392.58"},{"v":41,"d":"41.00"}]
[{"v":395.51515151515144,"d":"395.52"},{"v":7178.121973643887,"d":"7178.12"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1433254.259545744,"d":"1,433,254"},{"v":553745.0562283841,"d":"553,745"},{"v":5.4873347504368875,"d":"5.49"},{"v":0.06163311714788963,"d":"0.0616"},{"v":0.12026360728453513,"d":"0.12"},{"v":395.51515151515144,"d":"395.52"},{"v":42,"d":"42.00"}]
[{"v":398.4545454545454,"d":"398.45"},{"v":7125.169062286107,"d":"7125.17"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1436886.6192929856,"d":"1,436,887"},{"v":550330.5872420799,"d":"550,331"},{"v":5.501241545923017,"d":"5.50"},{"v":0.06173123256906026,"d":"0.0617"},{"v":0.11992280305929878,"d":"0.12"},{"v":398.4545454545454,"d":"398.45"},{"v":43,"d":"43.00"}]
[{"v":401.3939393939393,"d":"401.39"},{"v":7072.9916956062225,"d":"7072.99"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1440537.790079972,"d":"1,440,538"},{"v":546876.499200441,"d":"546,876"},{"v":5.515220361060507,"d":"5.52"},{"v":0.06183048645138434,"d":"0.0618"},{"v":0.11958004284853983,"d":"0.12"},{"v":401.3939393939393,"d":"401.39"},{"v":44,"d":"44.00"}]
[{"v":404.33333333333326,"d":"404.33"},{"v":7021.572959604288,"d":"7021.57"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1444200.447505295,"d":"1,444,200"},{"v":543394.3881245292,"d":"543,394"},{"v":5.529243153761149,"d":"5.53"},{"v":0.06193054558097271,"d":"0.0619"},{"v":0.11923639403464407,"d":"0.12"},{"v":404.33333333333326,"d":"404.33"},{"v":45,"d":"45.00"}]
[{"v":407.2727272727272,"d":"407.27"},{"v":6970.89642857143,"d":"6970.90"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1447795.3635219585,"d":"1,447,795"},{"v":540006.8218144841,"d":"540,007"},{"v":5.543006592768399,"d":"5.54"},{"v":0.06202788794858146,"d":"0.0620"},{"v":0.11890288903035809,"d":"0.12"},{"v":407.2727272727272,"d":"407.27"},{"v":46,"d":"46.00"}]
[{"v":410.21212121212113,"d":"410.21"},{"v":6920.94614759548,"d":"6920.95"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1451409.7368493,"d":"1,451,410"},{"v":536579.1979403758,"d":"536,579"},{"v":5.556844525729756,"d":"5.56"},{"v":0.06212638137797606,"d":"0.0621"},{"v":0.11856735634804103,"d":"0.12"},{"v":410.21212121212113,"d":"410.21"},{"v":47,"d":"47.00"}]
[{"v":413.15151515151507,"d":"413.15"},{"v":6871.706615813409,"d":"6871.71"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1454980.3931089945,"d":"1,454,980"},{"v":533209.1513531123,"d":"533,209"},{"v":5.570515084212447,"d":"5.57"},{"v":0.06222322031299065,"d":"0.0622"},{"v":0.11823853612336516,"d":"0.12"},{"v":413.15151515151507,"d":"413.15"},{"v":48,"d":"48.00"}]
[{"v":416.090909090909,"d":"416.09"},{"v":6823.1627703736085,"d":"6823.16"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1458570.923022481,"d":"1,458,571"},{"v":529798.7613392938,"d":"529,799"},{"v":5.584261730653953,"d":"5.58"},{"v":0.062321218524104605,"d":"0.0623"},{"v":0.11790764338158204,"d":"0.12"},{"v":416.090909090909,"d":"416.09"},{"v":49,"d":"49.00"}]
[{"v":419.03030303030295,"d":"419.03"},{"v":6775.2999710731865,"d":"6775.30"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1462117.8568395977,"d":"1,462,118"},{"v":526445.9424025076,"d":"526,446"},{"v":5.5978414657655255,"d":"5.60"},{"v":0.062417562419278705,"d":"0.0624"},{"v":0.11758338255535748,"d":"0.12"},{"v":419.03030303030295,"d":"419.03"},{"v":50,"d":"50.00"}]
[{"v":421.9696969696969,"d":"421.97"},{"v":6728.1039856373445,"d":"6728.10"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1471682.630384833,"d":"1,471,683"},{"v":513832.14507089613,"d":"513,832"},{"v":5.634461007556711,"d":"5.63"},{"v":0.06278002230475906,"d":"0.0628"},{"v":0.11644537722794833,"d":"0.12"},{"v":421.9696969696969,"d":"421.97"},{"v":51,"d":"51.00"}]
[{"v":424.9090909090908,"d":"424.91"},{"v":6681.560975609757,"d":"6681.56"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1475238.8181317768,"d":"1,475,239"},{"v":510454.1489585173,"d":"510,454"},{"v":5.648076172118696,"d":"5.65"},{"v":0.06287708967090244,"d":"0.0629"},{"v":0.1161246472267008,"d":"0.12"},{"v":424.9090909090908,"d":"424.91"},{"v":52,"d":"52.00"}]
[{"v":427.84848484848476,"d":"427.85"},{"v":6635.657482824564,"d":"6635.66"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1478751.5747311532,"d":"1,478,752"},{"v":507133.6505926571,"d":"507,134"},{"v":5.6615250568711435,"d":"5.66"},{"v":0.06297250482827234,"d":"0.0630"},{"v":0.11581036442729822,"d":"0.12"},{"v":427.84848484848476,"d":"427.85"},{"v":53,"d":"53.00"}]
[{"v":430.7878787878787,"d":"430.79"},{"v":6590.38041643219,"d":"6590.38"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1482253.0038994737,"d":"1,482,253"},{"v":503821.41676018864,"d":"503,821"},{"v":5.674930573598934,"d":"5.67"},{"v":0.06306768250269014,"d":"0.0631"},{"v":0.11549819024566547,"d":"0.12"},{"v":430.7878787878787,"d":"430.79"},{"v":54,"d":"54.00"}]
[{"v":433.72727272727263,"d":"433.73"},{"v":6545.717040452737,"d":"6545.72"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1485831.2290321619,"d":"1,485,831"},{"v":500382.5378023397,"d":"500,383"},{"v":5.688630110149909,"d":"5.69"},{"v":0.0631664993490746,"d":"0.0632"},{"v":0.11517643402201996,"d":"0.12"},{"v":433.72727272727263,"d":"433.73"},{"v":55,"d":"55.00"}]
[{"v":436.6666666666666,"d":"436.67"},{"v":6501.654961832062,"d":"6501.65"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1489310.4671748008,"d":"1,489,310"},{"v":497086.5845732126,"d":"497,087"},{"v":5.701950666665261,"d":"5.70"},{"v":0.06326120919723305,"d":"0.0633"},{"v":0.11486843053735134,"d":"0.11"},{"v":436.6666666666666,"d":"436.67"},{"v":56,"d":"56.00"}]
[{"v":439.6060606060605,"d":"439.61"},{"v":6458.182118977047,"d":"6458.18"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1492778.7341361505,"d":"1,492,779"},{"v":493798.6972307561,"d":"493,799"},{"v":5.715229219088219,"d":"5.72"},{"v":0.06335568727059109,"d":"0.0634"},{"v":0.11456245520011224,"d":"0.11"},{"v":439.6060606060605,"d":"439.61"},{"v":57,"d":"57.00"}]
[{"v":442.54545454545445,"d":"442.55"},{"v":6415.286770747742,"d":"6415.29"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1496236.1447631202,"d":"1,496,236"},{"v":490518.81116643787,"d":"490,519"},{"v":5.728466207119856,"d":"5.73"},{"v":0.06344993542568723,"d":"0.0634"},{"v":0.11425848229496569,"d":"0.11"},{"v":442.54545454545445,"d":"442.55"},{"v":58,"d":"58.00"}]
[{"v":445.4848484848484,"d":"445.48"},{"v":6372.957485885316,"d":"6372.96"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1499715.3549224222,"d":"1,499,715"},{"v":487197.1579548455,"d":"487,197"},{"v":5.741786656498644,"d":"5.74"},{"v":0.06354538376777073,"d":"0.0635"},{"v":0.11395224410303037,"d":"0.11"},{"v":445.4848484848484,"d":"445.48"},{"v":59,"d":"59.00"}]
[{"v":448.4242424242423,"d":"448.42"},{"v":6331.183132855793,"d":"6331.18"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1503151.4586602324,"d":"1,503,151"},{"v":483933.01747407793,"d":"483,933"},{"v":5.754942069309046,"d":"5.75"},{"v":0.06363917947050378,"d":"0.0636"},{"v":0.11365220899896827,"d":"0.11"},{"v":448.4242424242423,"d":"448.42"},{"v":60,"d":"60.00"}]
[{"v":451.36363636363626,"d":"451.36"},{"v":6289.952870090636,"d":"6289.95"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1506577.0388242735,"d":"1,506,577"},{"v":480676.68928729923,"d":"480,677"},{"v":5.768057191730178,"d":"5.77"},{"v":0.06373275068547075,"d":"0.0637"},{"v":0.11335410194684273,"d":"0.11"},{"v":451.36363636363626,"d":"451.36"},{"v":61,"d":"61.00"}]
[{"v":454.3030303030302,"d":"454.30"},{"v":6249.256136606192,"d":"6249.26"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1510024.9518076102,"d":"1,510,025"},{"v":477378.2092985078,"d":"477,378"},{"v":5.781257817232552,"d":"5.78"},{"v":0.06382753314055276,"d":"0.0638"},{"v":0.11305368113222179,"d":"0.11"},{"v":454.3030303030302,"d":"454.30"},{"v":62,"d":"62.00"}]
[{"v":457.24242424242414,"d":"457.24"},{"v":6209.082642984958,"d":"6209.08"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1513429.8731897373,"d":"1,513,430"},{"v":474137.2561921006,"d":"474,137"},{"v":5.7942938457656705,"d":"5.79"},{"v":0.06392066254963653,"d":"0.0639"},{"v":0.11275936701463986,"d":"0.11"},{"v":457.24242424242414,"d":"457.24"},{"v":63,"d":"63.00"}]
[{"v":460.1818181818181,"d":"460.18"},{"v":6169.42236270249,"d":"6169.42"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1516824.587444308,"d":"1,516,825"},{"v":470903.93304112495,"d":"470,904"},{"v":5.807290795450518,"d":"5.81"},{"v":0.06401357271048767,"d":"0.0640"},{"v":0.11246691057584446,"d":"0.11"},{"v":460.1818181818181,"d":"460.18"},{"v":64,"d":"64.00"}]
[{"v":463.121212121212,"d":"463.12"},{"v":6130.265523784598,"d":"6130.27"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1520242.1493801328,"d":"1,520,242"},{"v":467628.0822103223,"d":"467,628"},{"v":5.8203752194090175,"d":"5.82"},{"v":0.06410770491237484,"d":"0.0641"},{"v":0.11217209528593045,"d":"0.11"},{"v":463.121212121212,"d":"463.12"},{"v":65,"d":"65.00"}]
[{"v":466.06060606060595,"d":"466.06"},{"v":6091.602600780236,"d":"6091.60"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1523672.9140802207,"d":"1,523,673"},{"v":464324.5624902895,"d":"464,325"},{"v":5.83351019126344,"d":"5.83"},{"v":0.06420263218510061,"d":"0.0642"},{"v":0.11187618392340193,"d":"0.11"},{"v":466.06060606060595,"d":"466.06"},{"v":66,"d":"66.00"}]
[{"$f":"A136+$B$67","v":{"v":468.9999999999999,"d":"469.00"}},{"v":6053.424307036249,"d":"6053.42"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1527037.7117079587,"d":"1,527,038"},{"v":461113.7265197181,"d":"461,114"},{"v":5.846392602620603,"d":"5.85"},{"v":0.06429489617251008,"d":"0.0643"},{"v":0.11158919794837667,"d":"0.11"},{"$f":"K136+$B$67","v":{"v":468.9999999999999,"d":"469.00"}},{"v":67,"d":"67.00"}]
[{"v":471.9393939393938,"d":"471.94"},{"v":6015.72158726082,"d":"6015.72"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1530425.8544670045,"d":"1,530,426"},{"v":457859.9951556046,"d":"457,860"},{"v":5.859364392780882,"d":"5.86"},{"v":0.06438839276727976,"d":"0.0644"},{"v":0.111299811242889,"d":"0.11"},{"v":471.9393939393938,"d":"471.94"},{"v":68,"d":"68.00"}]
[{"v":474.87878787878776,"d":"474.88"},{"v":5978.485610363093,"d":"5978.49"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1533771.196901028,"d":"1,533,771"},{"v":454663.8311360256,"d":"454,664"},{"v":5.872172318288912,"d":"5.87"},{"v":0.0644802351533636,"d":"0.0645"},{"v":0.1110163507104602,"d":"0.11"},{"v":474.87878787878776,"d":"474.88"},{"v":69,"d":"69.00"}]
[{"v":477.8181818181817,"d":"477.82"},{"v":5941.707762557079,"d":"5941.71"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1537106.9203095697,"d":"1,537,107"},{"v":451474.9509632799,"d":"451,475"},{"v":5.884943416547038,"d":"5.88"},{"v":0.06457186823671175,"d":"0.0646"},{"v":0.11073461782562657,"d":"0.11"},{"v":477.8181818181817,"d":"477.82"},{"v":70,"d":"70.00"}]
[{"v":480.75757575757564,"d":"480.76"},{"v":5905.379640718565,"d":"5905.38"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1540466.4701807846,"d":"1,540,466"},{"v":448242.8160823591,"d":"448,243"},{"v":5.897805736425986,"d":"5.90"},{"v":0.06466474425239496,"d":"0.0647"},{"v":0.11045044516422203,"d":"0.11"},{"v":480.75757575757564,"d":"480.76"},{"v":71,"d":"71.00"}]
[{"v":483.6969696969696,"d":"483.70"},{"v":5869.493045984214,"d":"5869.49"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1543783.2981289793,"d":"1,543,783"},{"v":445068.274732759,"d":"445,068"},{"v":5.91050449182136,"d":"5.91"},{"v":0.06475596530691,"d":"0.0648"},{"v":0.11017211451071765,"d":"0.11"},{"v":483.6969696969696,"d":"483.70"},{"v":72,"d":"72.00"}]
[{"v":486.6363636363635,"d":"486.64"},{"v":5834.039977582665,"d":"5834.04"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1547090.7807479738,"d":"1,547,091"},{"v":441900.85321130755,"d":"441,901"},{"v":5.923167467836116,"d":"5.92"},{"v":0.06484698177179772,"d":"0.0648"},{"v":0.10989545157093339,"d":"0.11"},{"v":486.6363636363635,"d":"486.64"},{"v":73,"d":"73.00"}]
[{"v":489.57575757575745,"d":"489.58"},{"v":5799.012626887845,"d":"5799.01"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1550422.5558760734,"d":"1,550,423"},{"v":438689.82546542987,"d":"438,690"},{"v":5.935923449769745,"d":"5.94"},{"v":0.06493925126990739,"d":"0.0649"},{"v":0.10961631250015663,"d":"0.11"},{"v":489.57575757575745,"d":"489.58"},{"v":74,"d":"74.00"}]
[{"v":492.5151515151514,"d":"492.52"},{"v":5764.403371685229,"d":"5764.40"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1553711.6770352768,"d":"1,553,712"},{"v":435536.4210506791,"d":"435,536"},{"v":5.948516127387891,"d":"5.95"},{"v":0.06502986495054579,"d":"0.0650"},{"v":0.10934293483452004,"d":"0.11"},{"v":492.5151515151514,"d":"492.52"},{"v":75,"d":"75.00"}]
[{"v":495.4545454545453,"d":"495.45"},{"v":5730.204770642204,"d":"5730.20"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1563525.112853278,"d":"1,563,525"},{"v":422535.76534962986,"d":"422,536"},{"v":5.986087693651624,"d":"5.99"},{"v":0.06540344128546616,"d":"0.0654"},{"v":0.1082770242156847,"d":"0.11"},{"v":495.4545454545453,"d":"495.45"},{"v":76,"d":"76.00"}]
[{"v":498.39393939393926,"d":"498.39"},{"v":5696.4095579741,"d":"5696.41"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1566853.0266743156,"d":"1,566,853"},{"v":419317.3057814083,"d":"419,317"},{"v":5.9988288922456725,"d":"6.00"},{"v":0.06549592433841622,"d":"0.0655"},{"v":0.10800289958026046,"d":"0.11"},{"v":498.39393939393926,"d":"498.39"},{"v":77,"d":"77.00"}]
[{"v":501.3333333333332,"d":"501.33"},{"v":5663.010638297874,"d":"5663.01"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1570149.429299041,"d":"1,570,149"},{"v":416139.80130635086,"d":"416,140"},{"v":6.011449447568369,"d":"6.01"},{"v":0.0655872305389096,"d":"0.0656"},{"v":0.10773308940668119,"d":"0.11"},{"v":501.3333333333332,"d":"501.33"},{"v":78,"d":"78.00"}]
[{"v":504.27272727272714,"d":"504.27"},{"v":5630.001081665767,"d":"5630.00"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1573403.2523702164,"d":"1,573,403"},{"v":413019.9146724036,"d":"413,020"},{"v":6.023906983481008,"d":"6.02"},{"v":0.06567688107968832,"d":"0.0657"},{"v":0.10746888112682061,"d":"0.11"},{"v":504.27272727272714,"d":"504.27"},{"v":79,"d":"79.00"}]
[{"v":507.2121212121211,"d":"507.21"},{"v":5597.374118771659,"d":"5597.37"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1576648.320415495,"d":"1,576,648"},{"v":409906.736664738,"d":"409,907"},{"v":6.036331000038986,"d":"6.04"},{"v":0.0657663388468042,"d":"0.0658"},{"v":0.10720618736569926,"d":"0.11"},{"v":507.2121212121211,"d":"507.21"},{"v":80,"d":"80.00"}]
[{"v":510.151515151515,"d":"510.15"},{"v":5565.123136323138,"d":"5565.12"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1579918.712647282,"d":"1,579,919"},{"v":406749.11174296343,"d":"406,749"},{"v":6.048851972379743,"d":"6.05"},{"v":0.06585707380452137,"d":"0.0659"},{"v":0.10694094917685713,"d":"0.11"},{"v":510.151515151515,"d":"510.15"},{"v":81,"d":"81.00"}]
[{"v":513.090909090909,"d":"513.09"},{"v":5533.241672572644,"d":"5533.24"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1583146.571669162,"d":"1,583,147"},{"v":403649.1442320712,"d":"403,649"},{"v":6.061210102740986,"d":"6.06"},{"v":0.0659461519654789,"d":"0.0659"},{"v":0.10668124124570191,"d":"0.11"},{"v":513.090909090909,"d":"513.09"},{"v":82,"d":"82.00"}]
[{"v":516.030303030303,"d":"516.03"},{"v":5501.723413001351,"d":"5501.72"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1586365.9107558595,"d":"1,586,366"},{"v":400555.74106905464,"d":"400,556"},{"v":6.073535613812186,"d":"6.07"},{"v":0.06603504149864123,"d":"0.0660"},{"v":0.10642299823921521,"d":"0.11"},{"v":516.030303030303,"d":"516.03"},{"v":83,"d":"83.00"}]
[{"v":518.969696969697,"d":"518.97"},{"v":5470.562186149714,"d":"5470.56"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2839.056,"d":"2839.06"},{"v":1589576.8060693983,"d":"1,589,577"},{"v":397468.8551542104,"d":"397,469"},{"v":6.085828797186069,"d":"6.09"},{"v":0.06612374375742741,"d":"0.0661"},{"v":0.10616620417268767,"d":"0.11"},{"v":518.969696969697,"d":"518.97"},{"v":84,"d":"84.00"}]
[{"v":521.909090909091,"d":"521.91"},{"v":5434.524634756556,"d":"5434.52"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2836.327811648854,"d":"2836.33"},{"v":1592813.5845009584,"d":"1,592,814"},{"v":391743.86222785135,"d":"391,744"},{"v":6.104086793061919,"d":"6.10"},{"v":0.066277424876677,"d":"0.0663"},{"v":0.10573619046475446,"d":"0.11"},{"v":521.909090909091,"d":"521.91"},{"v":85,"d":"85.00"}]
[{"v":524.848484848485,"d":"524.85"},{"v":5404.088786628878,"d":"5404.09"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2836.327811648854,"d":"2836.33"},{"v":1596007.8788694588,"d":"1,596,008"},{"v":388669.8111952989,"d":"388,670"},{"v":6.116328181669879,"d":"6.12"},{"v":0.06636584328825339,"d":"0.0664"},{"v":0.10548248821582734,"d":"0.11"},{"v":524.848484848485,"d":"524.85"},{"v":86,"d":"86.00"}]
[{"v":527.787878787879,"d":"527.79"},{"v":5373.991949498315,"d":"5373.99"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2836.327811648854,"d":"2836.33"},{"v":1599193.951211269,"d":"1,599,194"},{"v":385602.13939715776,"d":"385,602"},{"v":6.128538061277025,"d":"6.13"},{"v":0.06645407821498586,"d":"0.0665"},{"v":0.10523018679084807,"d":"0.11"},{"v":527.787878787879,"d":"527.79"},{"v":87,"d":"87.00"}]
[{"v":530.727272727273,"d":"530.73"},{"v":5337.732500289541,"d":"5337.73"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2832.880212426396,"d":"2832.88"},{"v":1602406.3120889277,"d":"1,602,406"},{"v":379212.2212752998,"d":"379,212"},{"v":6.148322063745794,"d":"6.15"},{"v":0.06662459633088177,"d":"0.0666"},{"v":0.10476042486655054,"d":"0.10"},{"v":530.727272727273,"d":"530.73"},{"v":88,"d":"88.00"}]
[{"v":533.666666666667,"d":"533.67"},{"v":5308.33269036801,"d":"5308.33"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2832.880212426396,"d":"2832.88"},{"v":1605633.0035849055,"d":"1,605,633"},{"v":376072.1967819013,"d":"376,072"},{"v":6.160702655589419,"d":"6.16"},{"v":0.06671502224004565,"d":"0.0667"},{"v":0.10450462226681614,"d":"0.10"},{"v":533.666666666667,"d":"533.67"},{"v":89,"d":"89.00"}]
[{"v":536.606060606061,"d":"536.61"},{"v":5279.254970074035,"d":"5279.25"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2832.880212426396,"d":"2832.88"},{"v":1608794.9276620906,"d":"1,608,795"},{"v":373023.3449659296,"d":"373,023"},{"v":6.172834739331839,"d":"6.17"},{"v":0.0668028225734331,"d":"0.0668"},{"v":0.1042567477384334,"d":"0.10"},{"v":536.606060606061,"d":"536.61"},{"v":90,"d":"90.00"}]
[{"v":539.545454545455,"d":"539.55"},{"v":5244.103287199775,"d":"5244.10"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2829.432091775517,"d":"2829.43"},{"v":1611983.5345221583,"d":"1,611,984"},{"v":366651.4401047063,"d":"366,651"},{"v":6.19260671029375,"d":"6.19"},{"v":0.06697345207561933,"d":"0.0670"},{"v":0.10379211194876549,"d":"0.10"},{"v":539.545454545455,"d":"539.55"},{"v":91,"d":"91.00"}]
[{"v":542.484848484849,"d":"542.48"},{"v":5215.688695597809,"d":"5215.69"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2829.432091775517,"d":"2829.43"},{"v":1615129.7061481578,"d":"1,615,130"},{"v":363614.88969581976,"d":"363,615"},{"v":6.204693064220854,"d":"6.20"},{"v":0.06706100472229967,"d":"0.0671"},{"v":0.10354719386833344,"d":"0.10"},{"v":542.484848484849,"d":"542.48"},{"v":92,"d":"92.00"}]
[{"v":545.424242424243,"d":"545.42"},{"v":5181.257505415581,"d":"5181.26"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2825.983449696216,"d":"2825.98"},{"v":1618268.0717044815,"d":"1,618,268"},{"v":357306.41473947035,"d":"357,306"},{"v":6.224335937460915,"d":"6.22"},{"v":0.06723032443373478,"d":"0.0672"},{"v":0.10308986881487359,"d":"0.10"},{"v":545.424242424243,"d":"545.42"},{"v":93,"d":"93.00"}]
[{"v":548.3636363636369,"d":"548.36"},{"v":5153.484407602511,"d":"5153.48"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2825.983449696216,"d":"2825.98"},{"v":1621398.697271893,"d":"1,621,399"},{"v":354282.05461009,"d":"354,282"},{"v":6.236377246046735,"d":"6.24"},{"v":0.06731763201343133,"d":"0.0673"},{"v":0.10284783768687018,"d":"0.10"},{"v":548.3636363636369,"d":"548.36"},{"v":94,"d":"94.00"}]
[{"v":551.3030303030309,"d":"551.30"},{"v":5126.007466606664,"d":"5126.01"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2825.983449696216,"d":"2825.98"},{"v":1624556.5152508956,"d":"1,624,557"},{"v":351211.78122120054,"d":"351,212"},{"v":6.248523144661644,"d":"6.25"},{"v":0.0674062650224393,"d":"0.0674"},{"v":0.10260315105749049,"d":"0.10"},{"v":551.3030303030309,"d":"551.30"},{"v":95,"d":"95.00"}]
[{"v":554.2424242424249,"d":"554.24"},{"v":5092.598766769829,"d":"5092.60"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2822.5342861884933,"d":"2822.53"},{"v":1627671.9158819776,"d":"1,627,672"},{"v":344920.8493726577,"d":"344,921"},{"v":6.268156290879474,"d":"6.27"},{"v":0.06757570456334962,"d":"0.0676"},{"v":0.10215064477533968,"d":"0.10"},{"v":554.2424242424249,"d":"554.24"},{"v":96,"d":"96.00"}]
[{"v":557.1818181818189,"d":"557.18"},{"v":5065.732933280044,"d":"5065.73"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2822.5342861884933,"d":"2822.53"},{"v":1630779.7692067917,"d":"1,630,780"},{"v":341914.4041821708,"d":"341,914"},{"v":6.2801246182671875,"d":"6.28"},{"v":0.06766260103120642,"d":"0.0677"},{"v":0.10191269934845895,"d":"0.10"},{"v":557.1818181818189,"d":"557.18"},{"v":97,"d":"97.00"}]
[{"v":560.1212121212129,"d":"560.12"},{"v":5039.149071857832,"d":"5039.15"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2822.5342861884933,"d":"2822.53"},{"v":1633880.1377903377,"d":"1,633,880"},{"v":338913.8687613666,"d":"338,914"},{"v":6.292064121954249,"d":"6.29"},{"v":0.06774932668666557,"d":"0.0677"},{"v":0.1016759947093375,"d":"0.10"},{"v":560.1212121212129,"d":"560.12"},{"v":98,"d":"98.00"}]
[{"v":563.0606060606069,"d":"563.06"},{"v":5006.716099312599,"d":"5006.72"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2819.08460125235,"d":"2819.08"},{"v":1637008.1909935123,"d":"1,637,008"},{"v":332587.9926925423,"d":"332,588"},{"v":6.311824514065003,"d":"6.31"},{"v":0.06792040273721198,"d":"0.0679"},{"v":0.10122424670159075,"d":"0.10"},{"v":563.0606060606069,"d":"563.06"},{"v":99,"d":"99.00"}]
[{"v":566.0000000000009,"d":"566.00"},{"v":4980.714843202023,"d":"4980.71"},{"v":8760,"d":"8760.00"},{"v":1,"d":"1.00"},{"v":2819.08460125235,"d":"2819.08"},{"v":1640093.8340619423,"d":"1,640,094"},{"v":329599.09939313197,"d":"329,599"},{"v":6.323721850723502,"d":"6.32"},{"v":0.06800689760938544,"d":"0.0680"},{"v":0.10099026105181054,"d":"0.10"},{"v":566.0000000000009,"d":"566.00"},{"v":100,"d":"100.00"}]
["Power group electrical power [kW]","Equivalent hours [h]","Operative hours [h]","Power plant load factor","Annual productivity [MWh]","Investment cost [USD]","NPV [USD]","PBT [y]","LEC [USD/kWh]","IRR %","Power group electrical power [kW]"]
["OPTIMIZING","Max Eh","Max Oh","Max LF","Max AP","Min IC","Max NPV","Min PBT","Min LEC","Max IRR"]
[null,{"$f":"MAX(B$71:B$170)","v":{"v":8380.954304691131,"d":"8380.95"}},{"$f":"MAX(C$71:C$170)","v":{"v":8760,"d":"8760.00"}},{"$f":"MAX(D$71:D$170)","v":{"v":1,"d":"1.00"}},{"$f":"MAX(E$71:E$170)","v":{"v":2839.056,"d":"2839.06"}},{"$f":"MIN(F$71:F$170)","v":{"v":1259896.0282220745,"d":"1,259,896"}},{"$f":"MAX($G$71:$G$170)","v":{"v":626046.3418704635,"d":"626,046"}},{"$f":"MIN(H$71:H$170)","v":{"v":5.202439797312221,"d":"5.20"}},{"$f":"MIN(I$71:I$170)","v":{"v":0.059555525838551275,"d":"0.0596"}},{"$f":"MAX(J$71:J$170)","v":{"v":0.12776402386907196,"d":"0.13"}}]
[null,"Max Eh power [kW]","Max Oh power [kW]","Max LF power [kW]","Max AP power [kW]","Min IC power [kW]","Max NPV power [kW]","Min PBT power [kW]","Min LEC power [kW]","Max IRR power [kW]"]
[null,{"$f":"VLOOKUP(B$173,B71:$K$170,10,FALSE)","v":{"v":275,"d":"275.00"}},{"$f":"VLOOKUP(C$173,C71:$K$170,9,FALSE)","v":{"v":277.93939393939394,"d":"277.94"}},{"$f":"VLOOKUP(D$173,D71:$K$170,8,FALSE)","v":{"v":277.93939393939394,"d":"277.94"}},{"$f":"VLOOKUP(E$173,E71:$K$170,7,FALSE)","v":{"v":342.60606060606057,"d":"342.61"}},{"$f":"VLOOKUP(F$173,F71:$K$170,6,FALSE)","v":{"v":275,"d":"275.00"}},{"$f":"VLOOKUP(G$173,G71:$K$170,5,FALSE)","v":{"v":342.60606060606057,"d":"342.61"}},{"$f":"VLOOKUP(H$173,H71:$K$170,4,FALSE)","v":{"v":339.66666666666663,"d":"339.67"}},{"$f":"VLOOKUP(I$173,I71:$K$170,3,FALSE)","v":{"v":342.60606060606057,"d":"342.61"}},{"$f":"VLOOKUP(J$173,J71:$K$170,2,FALSE)","v":{"v":342.60606060606057,"d":"342.61"}}]
[]
[]
[]
[]
["END SHEET"]