{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Definitions","Cost Model L-PSH","Cost Curves L-PSH","Cost Model S-PSH","Cost Curves S-PSH","Market Adj Factors","Locational Adj Factors","Land Value Data","Sensitivity Analysis"],"not_rendered":{"charts":64,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Definitions","index":0,"n_rows":163,"n_cols":9,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
["Citation","Cohen, Stuart, Vignesh Ramasamy, and Danny Inman. 2023. A Component-Level Bottom-Up Cost Model for Pumped Storage Hydropower. Golden, CO: National Renewable Energy Laboratory. NREL/TP-6A40-84875. https://www.nrel.gov/docs/fy23osti/84875."]
[]
["Parameter","Parameter Type","Description/Instructions","Options/ Choices (if applicable)","Applicability for Small Scale PSH (<=100 MW) [n/a if blank]","Applicability for Large Scale PSH (>100 MW) [n/a if blank]","Equation/Cost Curve [n/a if blank]","Notes","Data Source"]
["Definitions","Worksheet","This sheet has definitions and descriptions of most terms and parameters within the workbook.","No"]
["Cost Model L-PSH","Worksheet","This sheet includes the core PSH cost model with all base case inputs, assumptions, output specifications, and cost components applicable for a large PSH system.","No"]
["Cost Model S-PSH","Worksheet","This sheet includes the core PSH cost model with all base case inputs, assumptions, output specifications, and cost components applicable for a small PSH system.","No"]
["Cost Curves L-PSH","Worksheet","This sheet includes all underlying cost curves using inputs of the large PSH system to estimate unit and total costs of different components for a large PSH system.","No",null,null,null,"Most of the cost curves are from EPRI GS-6999 report \"Pumped Storage Planning and Evaluation Guide\""]
["Cost Curves S-PSH","Worksheet","This sheet includes all underlying cost curves using inputs of the small PSH system to estimate unit and total costs of different components for a small PSH system.","No",null,null,null,"Most of the cost curves are from EPRI GS-6999 report \"Pumped Storage Planning and Evaluation Guide\""]
["Market Adj Factors","Worksheet","This sheet includes market adjustment factors and inflation factors used to adjust the estimated unit cost to current year values.","No",null,null,null,null,"Industry engagement and U.S. Bureau of Labor and Statistics"]
["Locational Adj Factors","Worksheet","This sheet includes locational cost adjustment factors used to adjust unit cost based on selected location.","No",null,null,null,null,"RSMeans. 2022. “RSMeans City Cost Index - 2022 - Quarter 2.” Gordian. https://www.rsmeans.com/media/wysiwyg/quarterly_updates/Q2-2022-ChangeNotice.pdf"]
["Land Value Data","Worksheet","This sheet has $/acre value of different types of land by location based on USDA data.","No",null,null,null,null,"USDA. 2022. “USDA Land Values: 2022 Summary.” 1949–1867. United States Department of Agriculture."]
["Sensitivity Analysis","Worksheet","This sheet has macros to calculate costs for multiple different configurations at the same time and plot the changes to the overall $/kWh."]
["Location","Inputs & Assumptions","Select United States or one of the states in the U.S. This input will adjust cost components based on a locational cost adjustment factor derived from the RSmeans construction cost guide.","Yes",null,null,null,null,"RSMeans. 2022. “RSMeans City Cost Index - 2022 - Quarter 2.” Gordian. https://www.rsmeans.com/media/wysiwyg/quarterly_updates/Q2-2022-ChangeNotice.pdf"]
["Avg. Max Upper Reservoir Depth","Inputs & Assumptions","Enter the average of the maximum upper reservoir depth in feet. This could also be calculated as the reservoir volume divided by the area.","No"]
["Upper Reservoir Area","Inputs & Assumptions","Enter upper reservoir area in acres, measured at the top of the water surface at maximum fill.","No"]
["Avg. Max Lower Reservoir Depth","Inputs & Assumptions","Enter the average of the maximum lower reservoir depth in feet. This could also be calculated as the reservoir volume divided by the area.","No"]
["Lower Reservoir Area","Inputs & Assumptions","Enter lower reservoir area in acres, measured at the top of the water surface at maximum fill.","No"]
["Nominal (Max) Head","Inputs & Assumptions","Enter maximum head height in feet, i.e., the upper reservoir max water surface elevation minus the lower reservoir min water surface elevation.","No"]
["Total Conveyance Length (vert+horiz)","Inputs & Assumptions","Enter total water conveyance length between upper and lower reservoir in feet. This could be the shortest distance between two reservoirs, including both the horizontal and vertical (head) distance.","No"]
["Avg. Upper Dam Height","Inputs & Assumptions","Enter average upper reservoir dam height in feet.","No"]
["Upper Dam Crest Length","Inputs & Assumptions","Enter upper reservoir dam crest length (length along the span of the dam at the top) in feet.","No"]
["Avg. Lower Dam Height","Inputs & Assumptions","Enter average lower reservoir dam height in feet.","No"]
["Lower Dam Crest Length","Inputs & Assumptions","Enter lower reservoir dam crest length (length along the span of the dam at the top) in feet.","No"]
["Acreage to be acquired","Inputs & Assumptions","Enter total land area to be acquired for the construction of the project in acres.","No",null,null,null,"Could be area of both rervoirs + 10%"]
["Generation Time","Inputs & Assumptions","Enter the maximum discharge time in hours based on the power output at mean generation discharge. In practice, power will fluctuate between min and max power based on head height throughout the discharge period.","No"]
["Meter to Feet","Inputs & Assumptions","Conversion factor from meter to feet used for maximum head height.","No"]
["Feet to Miles","Inputs & Assumptions","Conversion factor from feet to mile used for water conveyance length.","No"]
["Ac. Ft to Cu. Ft","Inputs & Assumptions","Conversion factor for acre-foot to cubic-foot.","No"]
["Cu. Ft to Cu. Yd","Inputs & Assumptions","Conversion factor for cubic-foot to cubic-yard.","No"]
["Hr to Sec","Inputs & Assumptions","Conversion factor for hours to seconds.","No"]
["MW to W","Inputs & Assumptions","Conversion factor from megawatts to watts","No"]
["acceleration of gravity (metric)","Inputs & Assumptions","Gravitational acceleration constant","No"]
["density of water (metric)","Inputs & Assumptions","Density of water constant","No"]
["Tunneling Condition","Inputs & Assumptions","Select an option between average and poor tunneling condition. Average tunneling condition will have lower cost compared to poor tunneling condition. Poor tunneling conditions could be attributed to tunnel size/length, excavation method, rock conditions, or water inflows.","Yes"]
["Access Road, Terrain","Inputs & Assumptions","Select a terrain grade type that impacts the cost of the access road. Flat is <10 degree slope, Mild is 10-20 degree slope, Steep is >20 degree slope.","Yes"]
["Access Road, Type","Inputs & Assumptions","Select whether a new access road must be built, or if an existing road can be rebuilt.","Yes"]
["Highway Realignment","Inputs & Assumptions","Select an option that will either include or exclude highway realignment cost.","Yes"]
["Access Road","Inputs & Assumptions","Enter a value in miles for the length of access road that needs to be built.","No",null,null,null,"Could be the distance between nearest road, lower reservoir and then to upper reservoir + 10%."]
["Access Tunnel, Length","Inputs & Assumptions","Enter a value in feet for the distance of the access tunnel built to access an underground powerhouse.","No",null,null,null,"Assume 26ft x 26ft tunnel section. If length is unknown can be approximated to tailrace tunnel length. Could be approximated as distance between lower edge of reservoir to half of the horizontal length assuming power station is in the center"]
["Water Supply","Inputs & Assumptions","Select an option that will either include or exclude water supply cost.","Yes"]
["Water Supply Cost","Inputs & Assumptions","Enter an assumed water supply cost per acre-foot of water volume. Alternatively, a water supply cost in dollars can be entered as an override quantity in the cost table.","No"]
["U. Reservoir Intake/Outlet","Inputs & Assumptions","Select an option between horizontal and vertical for the upper reservoir water intake/outlet. Choice depends on terrain, but typically choose horizontal if there is >1 head race tunnel (tunnel upstream of the powerhouse).","Yes",null,null,null,null,"EPRI GS6999 - P.NO. 6-10, 6-11"]
["L. Reservoir Intake/Outlet","Inputs & Assumptions","Select an option between horizontal and vertical for the lower reservoir water intake/outlet. Typically horizontal.","Yes",null,null,null,null,"EPRI GS6999 - P.NO. 6-10, 6-12"]
["Powerstation Structure Geology","Inputs & Assumptions","Select an option between average and adverse geology. Average tuneling condition will have lower cost compared to more conservatively assuming adverse geology.","Yes"]
["Power Station","Inputs & Assumptions","Select an option between surface and underground power station.","Yes",null,null,null,null,"EPRI GS6999 - P.NO. 6-9, 6-10"]
["Penstock","Inputs & Assumptions","Select an option between surface and underground penstock. Systems with total capacity < 100 MW are expected to use surface penstocks.","Yes",null,null,null,null,"EPRI GS6999 - P.NO. 6-10"]
["Reservoir Liner","Inputs & Assumptions","Select the liner type applicable to both upper and lower reservoirs. ","Yes"]
["Dam Type","Inputs & Assumptions","Select the dam type to estimate cost of both upper and lower reservoir dam and spillway. Dam and spillway costs are calculated by first calculating the equivalent earthen dam cost given the material-specific dam volume, then adjusting the total cost from the earthen dam-equivalent cost to the material-specific total cost. The unit cost will not change with dam material type. ","Yes",null,null,null,"The unit cost of dam construction remains unchanged across dam types, but the total cost and volume of both upper and lower reservoir/spillway component changes by dam type. More detail can be found in the Ring Dam Resource Cost Assessment paper."]
["Pump Type","Inputs & Assumptions","Select an option between fixed and variable pump types.","Yes"]
["Inflation Factor","Inputs & Assumptions","Enables or disables the inflation factor adjustment for all the system cost components except for indirect costs.","Yes"]
["Material/Equipment %","Inputs & Assumptions","Enter a percentage value that specifies the percent of total cost that is made up of material/equipment costs (i.e., not labor costs) on which to apply sales tax.","No"]
["Mobilization/Demobilization","Inputs & Assumptions","Enter a percentage value to estimate material and labor mobilization/demobilization as a percent of total cost.","No"]
["Sales Tax","Inputs & Assumptions","Enter a percentage value to estimate sales tax on a material percentage of components.","No"]
["Contingency","Inputs & Assumptions","Enter a percentage value to apply as a contingency cost on the total cost of components.","No"]
["EPC Cost","Inputs & Assumptions","Enter a percentage value to apply engineering-procurement-construction (EPC) contractor cost on a material percentage of components.","No"]
["Developer Cost","Inputs & Assumptions","Enter a percentage value to apply a developer cost on the total cost of components.","No"]
["EPC Overhead & Profit","Inputs & Assumptions","Enter a percentage value to estimate overhead and the installer's profit markup on a material percentage of components.","No"]
["Tranmsission Distance","Inputs & Assumptions","Enter the value for transmission interconnection distance in miles to estimate the cost of transmission.","No"]
["Transmission","Inputs & Assumptions","Enter the value for transmission line voltage to estimate the cost of transmission.","No"]
["Substation","Inputs & Assumptions","Enter the value for substation voltage to estimate the cost of a switchyard.","No"]
["Tranmission Terrain","Inputs & Assumptions","Select the type of terrain to estimate the cost of transmission.","Yes"]
["Transmission Type (# circuits)","Inputs & Assumptions","Select the type of transmission network (single or double circuit) to estimate the cost of transmission.","Yes"]
["Active Storage","Inputs & Assumptions","Enter a percentage value (less than or equal to 100%) to estimate the total usable storage out of the full reservoir volume.","No"]
["Hmin/Hmax","Inputs & Assumptions","Enter the assumed ratio of minimum to maximum gross head.","No"]
["Hazen Williams C","Inputs & Assumptions","Enter a value for the Hazen-Williams friction coefficient to estimate the head loss in conveyance structures.","No"]
["P-T Efficiency","Inputs & Assumptions","Enter a value for unit pump-turbine efficiency to estimate palnt generation power. This is the one-way component efficiency, not the overall round-trip efficiency of power generation.","No",null,null,null,"This is not same as round trip efficiency."]
["Max Tunnel Velocity","Inputs & Assumptions","Enter a maximum water velocity in the tunnel in foot per second to estimate tunnel diameter.","No",null,null,null,"Value usually in the range of 15 - 20."]
["Max Tunnel Dia","Inputs & Assumptions","Enter a maximum tunnel diameter value to estimate number of tunnels.","No"]
["Max Unit Capacity","Inputs & Assumptions","Enter a maximum capacity in megawatts per generating unit to determine the number of individual turbine/generator units.","No"]
["Min No. Units","Inputs & Assumptions","Enter a value to  set a lower limit for total no. of turbine/generator units at the plant.","No"]
["Pump Time","Inputs & Assumptions","Enter a factor value for the ratio of charging hours to discharging hours at mean discharge. This is the inverse of the overall round-trip efficiency.","No",null,null,null,"Could be inverse of round trip efficiency."]
["Conveyance Length","Output Specifications","Converts conveyance length value converted from feet to miles.","No"]
["Avg. Upper Reservoir Volume","Output Specifications","Estimates total upper reservoir volume by multiplying average reservoir depth and reservoir area.","No"]
["Avg. Lower Reservoir Volume","Output Specifications","Estimates total lower reservoir volume by multiplying average reservoir depth and reservoir area.","No"]
["Total Upper Dam Volume","Output Specifications","Estimates total dam volume in the upper reservoir by multiplying estimated unit volume using dam height in the EPRI curve and input dam crest length.","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-50"]
["Total Lower Dam Volume","Output Specifications","Estimates total dam volume in the lower reservoir by multiplying estimated unit volume using dam height in the EPRI curve and input dam crest length.","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-50"]
["Active Storage","Output Specifications","Estimates total usable or dispatchable storage volume by multiplying active storage percentage factor and upper reservoir volume.","No"]
["Energy Storage","Output Specifications","Total energy stored based on active storage.","No"]
["Mean Gen Discharge","Output Specifications","Estimates the mean water discharge in cubic feet per second by multiplying converted values of active storage in acre-foot to cubic-foot and generation time in hours to seconds. Assumes power output is maximized for the head and flow.","No"]
["Min Gross Head","Output Specifications","Estimates minimum gross head in feet by multiplying the Hmin/Hmax ratio and the nominal maximum head height value.","No"]
["Mean Gross Head","Output Specifications","The average of the maximum nominal head and minimum nominal head values.","No"]
["Min Gen Discharge","Output Specifications","Estimates the minimum water discharge in cubic feet per sectond from the mean discharge and the min/mean head ratio, based on the head being proportional to the flow squared","No"]
["Max Gen Discharge","Output Specifications","Estimates the minimum water discharge in cubic feet per sectond from the mean discharge and the max/mean head ratio, based on the head being proportional to the flow squared","No"]
["Nominal Tunnel Diameter","Output Specifications","Estimates the tunnel diameter in feet assuming 1 tunnel, estimated from the ratio of max flow to velocity (i.e., tunnel cross-sectional area)","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-12, 6-13"]
["No. Tunnels","Output Specifications","Determines the required number of tunnels to be 1 if the estimated tunnel diameter is less than maximum tunnel diameter, otherwise a value of 2 is assumed.","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-12, 6-13"]
["Adjusted Tunnel Diameter","Output Specifications","Estimates the tunnel diameter in feet based on the total number of tunnels and the ratio of max flow to velocity (i.e., tunnel cross-sectional area)","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-12, 6-13"]
["L/H","Output Specifications","Ratio of conveyance length to mean head height.","No"]
["Surge Chambers","Output Specifications","A flag for whether or not to include surge chamer cost. A surge chamber is assumed to be required if L/H ratio is greater than or equal to 7.","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-13, 6-14"]
["Min Gen Headloss","Output Specifications","Head loss in feet at minimum discharge conditions, using the Hazen-Williams equation","No"]
["Mean Gen Headloss","Output Specifications","Head loss in feet at mean discharge conditions, using the Hazen-Williams equation","No"]
["Max Gen Headloss","Output Specifications","Head loss in feet at maximum discharge conditions, using the Hazen-Williams equation","No"]
["Net Head @ Min Gen Discharge","Output Specifications","The difference between minimum head height and head loss at minimum discharge.","No"]
["Net Head @ Mean Gen Discharge","Output Specifications","The difference between mean head height and head loss at mean discharge.","No"]
["Net Head @ Max Gen Discharge","Output Specifications","The difference between maximum head height and head loss at maximum discharge.","No"]
["Min Plant Gen Power","Output Specifications","Calculation of hydropower output at minimum discharge based on head, flow rate, P-T efficiency, and physical properties. This would be considered the firm capacity for resource adequacy purposes.","No"]
["Mean Plant Gen Power","Output Specifications","Calculation of hydropower output at mean discharge based on head, flow rate, P-T efficiency, and physical properties","No"]
["Max Plant Gen Power","Output Specifications","Calculation of hydropower output at maximum discharge based on head, flow rate, P-T efficiency, and physical properties.  The maximum recommended plant gen power is 2100 MW to avoid extrapolating beyond the prescribed range of the cost functions.","No"]
["No. Units","Output Specifications","Calculates the required number of pump/generator units using plant's total generation capacity and the maximum generation capacity per unit. The maximum recommended number of units is 6 to avoid extrapolating beyond the prescribed range of the cost functions.","No"]
["Unit Rating","Output Specifications","The number of pump/generator units calculated from the max plant capacity divided by number of units.","No"]
["Max Penstock Velocity","Output Specifications","The maximum water velocity in the penstock in foot per second, estimated from the maximum head.","No",null,null,null,null,"EPRI GS6999 - P.NO. A-11, A-12"]
["Max Draft Tube Tunnel Velocity","Output Specifications","The maximum water velocity in the draft tube in foot per second, conservatively estimated from the maximum minus minimum head.","No",null,null,null,null,"EPRI GS6999 - P.NO. A-12"]
["Penstock Dia","Output Specifications","Estimates the penstock diameter in feet from the ratio of max flow to max penstock velocity (i.e., penstock cross-sectional area)","No"]
["Draft Tube Tunnel Dia","Output Specifications","Estimates the draft tube diameter in feet from the ratio of max flow to max penstock velocity (i.e., draft tube cross-sectional area)","No"]
["Pump Time","Output Specifications","The product of the pump time factor and total generation time.","No"]
["Mean Pump Discharge","Output Specifications","Estimates mean water discharge of the pump in cubic feet per second by converting active storage from acre-foot to cubic-food and pump time from hours to seconds.","No"]
["Mean Pump Headloss","Output Specifications","Head loss in feet from the pump at mean discharge conditions, using the Hazen-Williams equation","No"]
["Mean Pump Net Head","Output Specifications","Total head the pump must overcome as the sum of mean gross head height and mean pump headloss.","No"]
["Mean Pump Power","Output Specifications","Pump power requirements calculated based on mean pump discharge conditions of head, flow rate, P-T efficiency, and physical properties","No"]
["Tranmission Terrain Multiplier","Output Specifications","Transmission cost multiplification factor lookup for selected transmission terrain type.","No",null,null,null,null,"Andrade, Juan, and Ross Baldick. 2017. “The Full Cost of Electricity (FCe-): Estimation of Transmission Costs for New Generation.” UTEI/2016-09-2. Austin, TX: The University of Texas at Austin. https://energy.utexas.edu/sites/default/files/UTAustin_FCe_TransmissionCosts_2017.pdf"]
["Tranmission Type Multiplier","Output Specifications","Transmission cost multiplification factor lookup for selected transmission line type.","No",null,null,null,null,"Andrade, Juan, and Ross Baldick. 2017. “The Full Cost of Electricity (FCe-): Estimation of Transmission Costs for New Generation.” UTEI/2016-09-2. Austin, TX: The University of Texas at Austin. https://energy.utexas.edu/sites/default/files/UTAustin_FCe_TransmissionCosts_2017.pdf"]
["Include in Total?","Cost Component Column Header","If the value in this column is set to \"Yes\" it will include the cost component in the total cost estimation and vice versa.","No"]
["Unit","Cost Component Column Header","Values in this column define the intrinsic unit that is used to quantify the cost component.","No"]
["Qty","Cost Component Column Header","Values in this column estimate the total quantity of each cost component in the defined unit.","No"]
["Base Unit Cost","Cost Component Column Header","Values in this column estimate the unit cost of each cost component in the defined $/unit.","No"]
["Locational Factor","Cost Component Column Header","The Locational Factors are cost multipliers assigned for different locations in USA based on local markets, e.g., labor costs.","No",null,null,null,"Land and Land Rights cost doesn't have any locational factor included in its total cost as the unit cost is already derived based on selected location.","RSMeans. 2022. “RSMeans City Cost Index - 2022 - Quarter 2.” Gordian. https://www.rsmeans.com/media/wysiwyg/quarterly_updates/Q2-2022-ChangeNotice.pdf"]
["Inflation Factor (2022)","Cost Component Column Header","The Infation Factor is the cost multiplier based on the change in consumer price index due to inflation from the year $ year of cost curves (eg; 1988 is the $ year for EPRI cost curves) to the current dollar year of 2022.","No",null,null,null,null,"U.S. Bureau of Labor and Statistics"]
["Market Adjustment Factor (MAF)","Cost Component Column Header","The Market Adjustment Factor is a cost multiplier that accounts for changes to component-specific markets beyond CPI inflation from the base cost curve year (i.e., 1988 for EPRI cost curves). For example, this factor could accommodate change in commodity markets for raw materials used for the component and component-specific supply chains.","No",null,null,null,"Industry engagement."]
["Adjusted Unit Cost","Cost Component Column Header","This is the product of base unit cost and all the cost adjustment factors.","No"]
["Override Qty","Cost Component Column Header","Any values input under these cells can override the estimated quantity.","No",null,null,null,"Could be handy for atypical projects."]
["Override Unit Cost","Cost Component Column Header","Any values input under these cells can override the estimated unit cost.","No"]
["Total Component Cost","Cost Component Column Header","This is the product of adjusted unit cost and quantity.","No"]
["Cost per Capacity ($/MW)","Cost Component Column Header","This is a flag to denote if a cost component is dependent on power capacity of the technology.","No"]
["Cost per Energy ($/MWh)","Cost Component Column Header","This is a flag to denote if a cost component is dependent on enegy capacity of the technology.","No"]
["% of total cost (component)","Cost Component Column Header","Calculates the % of the total cost attributed to each cost component","No"]
["% of total cost (category)","Cost Component Column Header","Calculates the % of the total cost attributed to each cost category","No"]
["Land and Land Rights","Cost Component","Estimated for the selected project location using the total acreage required for project construction and the average cost per acre data sourced by state from the USDA cost of land and land rights. The United States average cost per acre value is used for any location that's not in the location input list.","No",null,null,null,"Land requirement and its cost vary considerably by location and type of land. Need to make sure correct acreage and cost per acre value is used.","USDA. 2022. “USDA Land Values: 2022 Summary.” 1949–1867. United States Department of Agriculture."]
["Powerplant Structure","Cost Component","Cost per kW of the structure constructed for the powerhouse equipment, estimated with EPRI cost curves based on the power station type, geology, and estimated generator unit rating. The total cost is then calculated by multiplying the estimate cost per kW and the max plant generation power in kW.","No",null,null,"cost per kW=a*dam_height^b for underground structure and a*dam_height^2 + b*dam_height + c for surface structure; a, b & c varies by geology type, powerstation type, and generator unit rating.",null,"EPRI GS6999 - P.NO. 6-42 to 6-49"]
["Reservoirs, Dams, and Waterways","Cost Component","Set of all cost components listed under \"Reservoirs, Dams, and Waterways\"","No"]
["Upper Reservoir Dam and Spillway","Cost Component","Calculates total cost by multiplying the upper reservoir volume in cubic yards and the cost per cubic yard estimated with an EPRI cost curve. Note that unit cost does not change with dam material type because material cost adjustments are made on total cost, not unit cost.","No",null,null,"cost per CY = (7.75 * dam_volume) / (dam_volume - 0.05)",null,"EPRI GS6999 - P.NO. 6-50"]
["Upper Reservoir Intake/Outlet","Cost Component","The cost per intake/outlet in millions of US dollars is estimated based on the upper reservoir intake type and the number of tunnels required.","No",null,null,"cost per intake/outlet = a*(conductor_diameter)^2 - b*(conductor_diameter) + c; a, b, and c varies by intake type.","Adjusted tunnel diameter to be used in the cost equation.","EPRI GS6999 - P.NO. 6-52"]
["Surge Facilities","Cost Component","This site-specific cost where the user determines if it is required. If a surge facility is required and enabled, the total cost of the surge facility is a specified % of the sum of the total water conductor cost, with the % specified in the Qty column.","No",null,null,"cost of surge facility = surge_facility_cost_factor*cost of concrete lined water conductors",null,"EPRI GS6999 - P.NO. 6-22"]
["Lower Reservoir Intake/Outlet","Cost Component","The cost per intake/outlet in millions of US dollars is estimated based on the lower reservoir intake type and the number of tunnels required.","No",null,null,"cost per intake/outlet = a*(conductor_diameter)^2 - b*(conductor_diameter) + c; a, b, and c varies by intake type.","Adjusted tunnel diameter to be used in the cost equation.","EPRI GS6999 - P.NO. 6-52"]
["Lower Reservoir Dam and Spillway","Cost Component","Calculates total cost by multiplying the lower reservoir volume in cubic yards and the cost per cubic yard estimated with an EPRI cost curve.  Note that unit cost does not change with dam material type because material cost adjustments are made on total cost, not unit cost.","No",null,null,"cost per CY = (7.75 * dam_volume) / (dam_volume - 0.05)",null,"EPRI GS6999 - P.NO. 6-50"]
["Upper & Lower Reservoir Liner","Cost Component","Estimates minimum reservoir area when assuming that the both reservoir surface and the dam are shaped like isosceles triangles, then multiplies by the unit cost of the chosen liner material.","No",null,null,"liner area = sqrt(a^2 * b^2 + a^2 * c^2 + b^2 * c^2) where a = maximum dam height, b = 0.5 * maximum dam crest length at the top, c = (2 * reservoir surface area at maximum fill)/maximum dam crest length at the top",null,"DeNeale, S., A. Chu, M. Altinakar, J. Hedien, and V. Koritarov (forthcoming). Cost Model for Pumped Storage Hydropower Geomembrane Lining Systems. Oak Ridge National Laboratory. Oak Ridge, TN."]
["Water Conductors","Cost Component","Set of all cost components listed under \"Concrete Lined Water Conductors\"","No"]
["Upper Low & High Pressure Tunnels","Cost Component","Estimated cost per linear foot of tunnel based on the tunneling condition, tunnel diameter, and conveyance length. Length of low/high pressure tunnels is half the remaining horizontal conveyance length after subtracting penstock, draft tube, and tailrace.","No","Disabled","Enabled","cost per LF = a*tunnel_diameter^2 + b*tunnel_diameter + c; a, b & c varies by tunnel length and diameter.","Adjusted tunnel diameter to be used in the cost equation.  Length is assumed to be half the horizontal conveyance length after subtracting penstock and draft tube length.","EPRI GS6999 - P.NO. 6-53"]
["Vertical Shafts","Cost Component","Cost of vertical shafts is equal to estimated shaft length times cost per foot of vertical shaft. Vertical shaft length is estimated as equal to the mean gross head.","No","Disabled","Enabled","cost per LF = 186.57*(tunnel_diameter) + 27.143","Length of vertical shaft is assumed to be equal to mean gross head height.","EPRI GS6999 - P.NO. 6-54"]
["Penstock Tunnels","Cost Component","Estimated cost per linear foot of tunnel based on the tunneling condition, tunnel diameter, and conveyance length. Length of penstock is estimated as equal to the mean gross head.","No","Disabled","Enabled","cost per LF = a*penstock_diameter^2 + b*penstock_diameter +c; a, b & c varies by penstock length and diameter.","Length of penstock is assumed to be equal to mean gross head height.","EPRI GS6999 - P.NO. 6-55"]
["Draft Tube Tunnels","Cost Component","Estimated cost per linear foot of tunnel based on the tunneling condition, tunnel diameter, and conveyance length. Length is assumed to be 200 ft based on EPRI guidance.","No","Disabled","Enabled","cost per LF = a*draft_tube_diameter^2 + b*draft_tube_diameter + c; a, b & c varies by draft tube length and diameter.","Only applicable if underground powerstaion is assumed. Length is assumed to be 200 ft based on EPRI guidance.","EPRI GS6999 - P.NO. 6-55"]
["Tailrace Tunnels","Cost Component","Estimated cost per linear foot of tunnel based on the tunneling condition, tunnel diameter, and conveyance length. Length of tailrace tunnels is half the remaining horizontal conveyance length after subtracting penstock, draft tube, and tailrace.","No","Disabled","Enabled","cost per LF = a*tunnel_diameter^2 + b*tunnel_diameter + c; a, b & c varies by tunnel length and diameter.","Only applicable if underground powerstaion is assumed. Length is assumed to be half the horizontal conveyance length after subtracting penstock and draft tube length.","EPRI GS6999 - P.NO. 6-53"]
["Surface Penstock","Cost Component","When a surface penstock is used, cost is based on estimated penstock length using no. of units, penstock diameter, and the cost per feet of penstock from EPRI cost curves that account for penstock diameter and head height.","No","Enabled","Enabled","cost per LF = a*tunnel_diameter^b; a & b varies by tunnel length and diameter.","Only applicable if surface penstock is used.","EPRI GS6999 - P.NO. 6-56"]
["Powerstation Equipment","Cost Component","Set of all cost components listed under \"Powerstation Equipment\".","No"]
["Pump/Motors","Cost Component","For small systems, the cost of pumps/motors is itemized and estimated based on the mean pump discharge.","No","Enabled","Disabled","cost of pump/motors =[ 0.7799*(mean_pump_discharge in gal/min)^0.7442]*1000",null,"EPRI 2011, ORNL 2015"]
["Generator/Turbines","Cost Component","For small systems, the cost of generator/turbine units is estimated based on the max plant generation capacity and head height.","No","Enabled","Disabled","cost per kW=a*max_plant_capacity^b; a & b varies by head height.",null,"EPRI 2011, ORNL 2015"]
["Total Powerstation","Cost Component","For large systems, the total cost of pumps/motors and generators/turbines is estimated with an EPRI cost curve based on the power station type, no.of turbine units, and estimated generator unit rating for different head height.","No","Disabled","Enabled","cost per kW = a*(mean_gross_head)^2 - b*(mean_gross_head) + c; a, b, and c varies by powerstation type, generator unit rating and no. of units.",null,"EPRI GS6999 - P.NO. 6-57 to 6-64"]
["Roads, Railroads, Bridges, and Access","Cost Component","Set of all cost components listed under \"Roads, Railroads, Bridges, and Access\".","No"]
["Access Roads","Cost Component","Cost to construct access roads is estimated using EPRI cost data based on the cost per mile value assigned for different terrain type and road type.","No",null,null,null,null,"EPRI GS6999 - P.NO. 6-22"]
["Access Tunnels","Cost Component","The access tunnel cost is the product of the cost per linear foot to construct access tunnels and the length of the access tunnels.","No",null,null,"cost per LF = 2489.4*(access_tunnel_length)^0.118","Cost included only for underground powerstaion.","EPRI GS6999 - P.NO. 6-65"]
["Highway Realignment","Cost Component","If any sort of highway realignment is required, an additional cost markup on the total cost of access roads is included.","No",null,null,"total_cost = realignment_cost_fraction*total_cost_of_access_roads"]
["Switchyard","Cost Component","Cost of on-site electrical interconnection equipment is estimated using an EPRI cost curve based on the substation voltage and the number of generator units.","No",null,null,"cost per switchyard = a*(number_of_units)^2 - b*(number_of_units) + c; a, b, and c varies by no. of generator units, and substation voltage.",null,"EPRI GS6999 - P.NO. 6-66"]
["Transmission Lines","Cost Component","Transmission cost per mile is estimated using an EPRI cost curve based on the transmisison voltage and maximum plant generation capacity. The cost also changes by selected transmission type and transmission terrain type.","No",null,null,"cost per transmission mile = ( a*(max_plant_gen_power)^2 - b*(max_plant_gen_power) + c)*transmission_terrain_multiplier*transmission_circuit_multiplier; a, b, and c varies by no. of generator units, and substation voltage.",null,"EPRI GS6999 - P.NO. 6-67"]
["Others","Cost Component","Set of all cost components listed under \"Others\".","No"]
["Water Supply","Cost Component","If water supply is required then we estimate cost of water supply by multiplying the total plant capacity by the $/kW water supply cost assumed in the inputs/assumptions section. Alternatively, an override qty cost in $ can be assumed.","No",null,null,null,"Highly variable and site-dependent."]
["Indirect Costs","Cost Component","Set of all cost components listed under \"Indirect Costs\".","No"]
["Mobilization/Demobilization","Cost Component","Total cost of mobilization/demobilization of equipment & labor in is equal to mobilization/dembilization rate times the total cost to install the PSH system. It includes all costs of establishing and dismantling the construction site, such as transporting and setting up equipment, creating temporary facilities, utilities, and access roads, site preparation and security, and eventual demobilization and site restoration at project completion.","No"]
["Sales Tax","Cost Component","Total sales tax is equal to sales tax rate times the total cost to install the PSH system times the material/equipment percentage factor input. It includes state and local taxes applied to construction materials and equipment purchases. ","No"]
["Contingency","Cost Component","Total contingency is equal to continengency markup factor times the total cost to install the PSH system. This allowance covers uncertain or unforeseen costs that may arise during design and construction, such as quantity variations, design modifications, site condition changes, or schedule delays. It does not represent an expected cost but rather a prudent reserve to account for the normal level of uncertainty inherent in project development.","No"]
["EPC Cost","Cost Component","Total engineering, procurement, construction services (EPC) cost is equal to EPC markup rate times the total cost to install the PSH system. It includes all professional services needed to design, procure, and manage construction. This covers detailed engineering and design work, purchasing and vendor coordination, construction management and supervision, quality assurance, scheduling, cost control, safety programs, and support for testing and commissioning.","No"]
["Developer Cost","Cost Component","Total developer cost is equal to developer markup rate times the total cost to install the PSH system. It includes the owner’s or developer’s indirect expenses that occur outside of direct construction. It covers project development, permitting, environmental studies, licensing, land acquisition, legal and financial services, project management, stakeholder coordination, and oversight of construction and commissioning.","No"]
["Overhead & Profit","Cost Component","Total overhead & installer profit is equal to the overhead and profit markup times the total cost to install the PSH system. It includes the contractor’s corporate and project-level overhead, insurance, bonding, and administrative expenses, along with their profit margin on the work. It covers the costs of managing the business, field supervision not tied to a specific activity, and the contractor’s return for assuming construction risk.","No"]
["Total Direct and Indirect Cost","Cost Component","Sum of total cost in $ across all cost components.","No"]
["$/kW (Max. Power Capacity)","Cost Component","Tht total cost divided by the max power generation capacity in kW.","No"]
["$/kWh (Max. Energy Capacity)","Cost Component","The total cost divided by the max energy storage capacity in kWh based on the max power generation capacity and the generation time.","No"]

{"sheet":"Cost Model L-PSH","index":1,"n_rows":312,"n_cols":26,"rows_kept":312,"cut":false,"hidden":false,"merged":[[5,1,5,3],[80,1,80,3]]}
[]
[]
[]
[]
[]
[null,"Inputs & Assumptions",null,null,null,"Cost Components","Include in Total? (Yes or No - User Option)","Unit","Qty","Base Unit Cost ($/unit) (Includes material, equipment rental, installation labor)","Locational Factor","CPI + MAF Composite Factor (2022)","USBR Adjustment Factor (2024)","Adjusted Unit Cost ($)","Override Qty","Override Unit Cost ($)","Total Component Cost ($)","% of total cost (component)","% of total cost (category)"]
[]
[null,"Site Related",null,null,null,"Land and Land Rights","Yes","Acres",{"$f":"IF(G8=\"Yes\",IF(O8,O8,C20),0)","v":2185},{"$f":"IFERROR(VLOOKUP(C9,'Land Value Data'!$A$3:$G$51,7,FALSE),'Land Value Data'!G51)","v":3093.3333333333335},1,{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!C48,1)","v":1.1576717200995823},1,{"$f":"IF(P8,P8,J8*K8*L8*M8)","v":3581.0645208413748},0,0,{"$f":"I8*N8","v":7824625.9780384041},{"$f":"Q8/$Q$53","v":2.7809969071505144E-3},{"$f":"R8","v":2.7809969071505144E-3}]
[null,"Location","United States","#"]
[null,"Avg. Max Upper Reservoir Depth",101,"feet",null,"Powerplant Structure","Yes","kW",{"$f":"IF(G10=\"Yes\",IF(O10,O10,C108*1000),0)","v":1283327.8591994315},{"$f":"VLOOKUP(C51,'Cost Curves L-PSH'!AO205:AQ206,3,FALSE)*IF(P10,P10,IF(AND(C46=\"Average\",C47=\"Underground\"),IF(C110<=80,IF(C109<=2,'Cost Curves L-PSH'!B11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!C11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!D11,IF(C109>4,'Cost Curves L-PSH'!E11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves L-PSH'!B53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!C53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!D53,IF(C109>4,'Cost Curves L-PSH'!E53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves L-PSH'!L53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!M53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!N53,IF(C109>4,'Cost Curves L-PSH'!O53)))),IF(C110>225,IF(C109<=2,'Cost Curves L-PSH'!L11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!M11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!N11,IF(C109>4,'Cost Curves L-PSH'!O11)))))))),IF(AND(C46=\"Adverse\",C47=\"Underground\"),IF(C110<=80,IF(C109<=2,'Cost Curves L-PSH'!F11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!G11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!H11,IF(C109>4,'Cost Curves L-PSH'!I11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves L-PSH'!F53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!G53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!H53,IF(C109>4,'Cost Curves L-PSH'!I53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves L-PSH'!P53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!Q53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!R53,IF(C109>4,'Cost Curves L-PSH'!S53)))),IF(C110>225,IF(C109<=2,'Cost Curves L-PSH'!P11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!Q11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!R11,IF(C109>4,'Cost Curves L-PSH'!S11)))))))),IF(AND(C46=\"Average\",C47=\"Surface\"),IF(C110<=80,IF(C109<=2,'Cost Curves L-PSH'!V11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!W11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!X11,IF(C109>4,'Cost Curves L-PSH'!Y11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves L-PSH'!V53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!W53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!X53,IF(C109>4,'Cost Curves L-PSH'!Y53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves L-PSH'!AF53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AG53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AH53,IF(C109>4,'Cost Curves L-PSH'!AI53)))),IF(C110>225,IF(C109<=2,'Cost Curves L-PSH'!AF11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AG11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AH11,IF(C109>4,'Cost Curves L-PSH'!AI11)))))))),IF(AND(C46=\"Adverse\",C47=\"Surface\"),IF(C110<=80,IF(C109<=2,'Cost Curves L-PSH'!Z11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AA11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AB11,IF(C109>4,'Cost Curves L-PSH'!AC11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves L-PSH'!Z53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AA53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AB53,IF(C109>4,'Cost Curves L-PSH'!AC53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves L-PSH'!AJ53,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AK53,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AL53,IF(C109>4,'Cost Curves L-PSH'!AM53)))),IF(C110>225,IF(C109<=2,'Cost Curves L-PSH'!AJ11,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AK11,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AL11,IF(C109>4,'Cost Curves L-PSH'!AM11)))))))))))))","v":39.0597787354559},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U61,1)","v":3.1330000000000005},{"$f":"'Market Adj Factors'!X61","v":1.0666666666666667},{"$f":"IF(P10,P10,J10*K10*L10*M10)","v":130.53257256339558},0,0,{"$f":"N10*I10","v":167516086.90357688},{"$f":"Q10/$Q$53","v":5.9537889847304029E-2},{"$f":"R10","v":5.9537889847304029E-2}]
[null,"Upper Reservoir Area",191,"acres"]
[null,"Avg. Max Lower Reservoir Depth",120,"feet",null,"Reservoirs, Dams, and Waterways"]
[null,"Lower Reservoir Area",163,"acres",null,"Upper Reservoir Dam and Spillway","Yes","CY",{"$f":"IF(G13=\"Yes\",IF(O13,O13,C86),0)","v":327938},{"$f":"'Cost Curves L-PSH'!J95","v":7.9166421358164936},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U62,1)","v":3.3740000000000001},{"$f":"'Market Adj Factors'!X62","v":1.0684326710816776},{"$f":"IF(P13,P13,J13*K13*L13*M13)","v":28.538638574089418},0,0,{"$f":"IF(C50=\"Earthfill\",N13*I13,IF(C50=\"Rockfill\",0.787*N13*I13+39700000,IF(C50=\"RCC\",11.389*(N13*I13))))","v":106588558.30186719},{"$f":"Q13/$Q$53","v":3.7883274140783484E-2},{"$f":"SUM(R13:R18)","v":0.13446524435522011}]
[null,"Nominal (Max) Head",1560,"feet",null,"Upper Reservoir Intake/Outlet","Yes","#",{"$f":"IF(G14=\"Yes\",IF(O14,O14,C96),0)","v":1},{"$f":"IF(C44=\"Horizontal\",'Cost Curves L-PSH'!P88,IF('Cost Model L-PSH'!C44=\"Vertical\",'Cost Curves L-PSH'!P91))*1000000","v":1483197.0222642012},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",IF(C44=\"Horizontal\",'Market Adj Factors'!U63,'Market Adj Factors'!U63),1)","v":4.82},{"$f":"'Market Adj Factors'!X63","v":1.0419161676646707},{"$f":"IF(P14,P14,J14*K14*L14*M14)","v":7448668.7343265889},0,0,{"$f":"N14*I14","v":7448668.7343265889},2.6473757046907515E-3]
[null,"Total Conveyance Length (vert+horiz)",14394,"feet",null,"Surge Facilities","Yes","LS",{"$f":"IF(G15=\"Yes\",IF(O15,O15,IF(C99=\"Yes\",40%,0%)),0)","v":0.4},"NA",null,null,null,"NA",0,"NA",{"$f":"I15*SUM(Q21:Q26)","v":109425125.13343202},3.8891435247480254E-2]
[null,"Avg. Upper Dam Height",120,"ft",null,"Lower Reservoir Intake/Outlet","Yes","#",{"$f":"IF(G16=\"Yes\",IF(C47=\"Underground\",IF(O16,O16,C96),0))","v":1},{"$f":"IF(C45=\"Horizontal\",'Cost Curves L-PSH'!P88,IF('Cost Model L-PSH'!C45=\"Vertical\",'Cost Curves L-PSH'!P91))*1000000","v":6772936.1118818102},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",IF(C45=\"Horizontal\",'Market Adj Factors'!U64,'Market Adj Factors'!U64),1)","v":3.1330000000000005},{"$f":"'Market Adj Factors'!X64","v":1.0419161676646707},{"$f":"IF(P16,P16,J16*K16*L16*M16)","v":22109053.520380087},0,0,{"$f":"N16*I16","v":22109053.520380087},7.857910350318912E-3]
[null,"Upper Dam Crest Length",1300,"ft",null,"Lower Reservoir Dam and Spillway","Yes","CY",{"$f":"IF(G17=\"Yes\",IF(O17,O17,C87),0)","v":184954},{"$f":"'Cost Curves L-PSH'!J96","v":8.3508624157488018},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U62,1)","v":3.3740000000000001},{"$f":"'Market Adj Factors'!X62","v":1.0684326710816776},{"$f":"IF(P17,P17,J17*K17*L17*M17)","v":30.103955714605839},0,0,{"$f":"IF(C50=\"Earthfill\",N17*I17,IF(C50=\"Rockfill\",0.787*N17*I17+39700000,IF(C50=\"RCC\",11.389*N17*I17)))","v":63412209.77044934},2.2537711034644126E-2]
[null,"Avg. Lower Dam Height",60,"ft",null,"Upper & Lower Reservoir Liner","Yes","Sq.Ft",{"$f":"IF(G18=\"Yes\",IF(O18,O18,(SQRT(((C16^2)*(C17/2)^2)+((C16^2)*((2*C11*C26)/C17)^2)+(((C17/2)^2)*((2*C11*C26)/C17)^2))+SQRT(((C18^2)*(C19/2)^2)+((C18^2)*((2*C13*C26)/C19)^2)+(((C19/2)^2)*((2*C13*C26)/C19)^2)))),0)","v":15603396.412109939},{"$f":"IFERROR(VLOOKUP(C49,'Cost Curves L-PSH'!AE241:AG243,3,FALSE),0)","v":4.4444444444444446},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},1,1,{"$f":"IF(P18,P18,J18*K18*L18*M18)","v":4.4444444444444446},0,0,{"$f":"N18*I18","v":69348428.498266399},2.4647537877302596E-2]
[null,"Lower Dam Crest Length",1100,"ft"]
[null,"Acreage to be acquired",2185,"acres",null,"Water Conductors"]
[null,"Generation Time",18.5,"hours",null,"Upper Low & High Pressure Tunnels","Yes","Ft",{"$f":"IF(G21=\"Yes\",IF(O21,O21,(C15-C92-I23/C109-I24/C109)*0.5),0)*$C$96","v":6268.25},{"$f":"IF(C34=\"Average\",IF(I21*C25<=0.5,'Cost Curves L-PSH'!V95,IF(AND(I21*C25>0.5,I21*C25<=1),'Cost Curves L-PSH'!W95,IF(AND(I21*C25>1,I21*C25<=2),'Cost Curves L-PSH'!X95,IF(I21*C25>2,'Cost Curves L-PSH'!Y95)))),IF(C34=\"Poor\",IF(I21*C25<=0.5,'Cost Curves L-PSH'!Z95,IF(AND(I21*C25>0.5,I21*C25<=1),'Cost Curves L-PSH'!AA95,IF(AND(I21*C25>1,I21*C25<=2),'Cost Curves L-PSH'!AB95,IF(I21*C25>2,'Cost Curves L-PSH'!AC95))))))","v":3667.2949095590852},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U67,1)","v":3.8560000000000003},{"$f":"'Market Adj Factors'!X67","v":1.0790513833992095},{"$f":"IF(P21,P21,J21*K21*L21*M21)","v":15258.961833019504},null,0,{"$f":"N21*I21","v":95646987.509824514},{"$f":"Q21/$Q$53","v":3.3994465318809945E-2},{"$f":"SUM(R21:R26)","v":9.7228588118700637E-2}]
[null,null,null,null,null,"Vertical Shafts","Yes","Ft",{"$f":"IF(G22=\"Yes\",IF(O22,O22,C92),0)*$C$96","v":1326},{"$f":"'Cost Curves L-PSH'!AI90","v":4761.6185244014168},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U66,1)","v":4.3380000000000001},{"$f":"'Market Adj Factors'!X66","v":1.0790513833992095},{"$f":"IF(P22,P22,J22*K22*L22*M22)","v":22288.778720818038},null,0,29554920.583804719,1.050429029647308E-2]
[null,"Unit Conversion Factors and Constants",null,null,null,"Penstock Tunnels","Yes","Ft",{"$f":"IF(G23=\"Yes\",IF(C48=\"Underground\",IF(O23,O23,C92*0.25),0))*$C$109","v":1326},{"$f":"IF(C14<=500,'Cost Curves L-PSH'!B131,IF(AND(C14>500,C14<=1000),'Cost Curves L-PSH'!C131,IF(AND(C14>1000,C14<=1500),'Cost Curves L-PSH'!D131,IF(C14>1500,'Cost Curves L-PSH'!E131))))","v":4825.8251785474667},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U67,1)","v":3.8560000000000003},{"$f":"'Market Adj Factors'!X67","v":1.0790513833992095},20079.400219584095,null,0,26625284.691168509,9.4630509606421134E-3]
[null,"Meter to Feet",3.28084,"feet",null,"Draft Tube Tunnels","Yes","Ft",{"$f":"IF(C47=\"Underground\",IF(G24=\"Yes\",IF(O24,O24,200),0),0)*$C$109","v":800},{"$f":"IF(C47=\"Underground\",IF(C14-C91<=500,'Cost Curves L-PSH'!B132,IF(AND(C14-C91>500,C14-C91<=1000),'Cost Curves L-PSH'!C132,IF(AND(C14-C91>1000,C14-C91<=1500),'Cost Curves L-PSH'!D132,IF(C14-C91>1500,'Cost Curves L-PSH'!E132)))),0)","v":6600.0702685899114},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U69,1)","v":4.5789999999999997},{"$f":"'Market Adj Factors'!X69","v":1.0790513833992095},32610.790673697171,null,0,{"$f":"N24*I24","v":26088632.538957737},9.2723162239655415E-3]
[null,"Feet to Miles",1.8939400000000001E-4,"miles",null,"Tailrace Tunnels","Yes","Ft",{"$f":"IF(G25=\"Yes\",IF(O25,O25,(C15-C92-I23/C109-I24/C109)*0.5),0)*$C$96","v":6268.25},{"$f":"IF(C34=\"Average\",IF(I25*C25<=0.5,'Cost Curves L-PSH'!V95,IF(AND(I25*C25>0.5,I25*C25<=1),'Cost Curves L-PSH'!W95,IF(AND(I25*C25>1,I25*C25<=2),'Cost Curves L-PSH'!X95,IF(I25*C25>2,'Cost Curves L-PSH'!Y95)))),IF(C34=\"Poor\",IF(I25*C25<=0.5,'Cost Curves L-PSH'!Z95,IF(AND(I25*C25>0.5,I25*C25<=1),'Cost Curves L-PSH'!AA95,IF(AND(I25*C25>1,I25*C25<=2),'Cost Curves L-PSH'!AB95,IF(I25*C25>2,'Cost Curves L-PSH'!AC95))))))","v":3667.2949095590852},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U67,1)","v":3.8560000000000003},{"$f":"'Market Adj Factors'!X67","v":1.0790513833992095},15258.961833019504,null,0,95646987.509824514,3.3994465318809945E-2]
[null,"Ac. Ft to Cu. Ft or Ac. to Sq. Ft.",43560,"cu.ft",null,"Surface Penstock","Yes","Ft",{"$f":"IF(G26=\"Yes\",IF(O26,O26,IF(C48=\"Surface\",C109*C92*0.25,0)),0)","v":0},{"$f":"IF(OR(C107<100, C48=\"Surface\"),IF(C14<=300,'Cost Curves L-PSH'!L131,IF(AND(C14>300,C14<=500),'Cost Curves L-PSH'!M131,IF(AND(C14>500,C14<=700),'Cost Curves L-PSH'!N131,IF(AND(C14>700,C14<=1000),'Cost Curves L-PSH'!O131,IF(C14>1000,'Cost Curves L-PSH'!P131))))),0)","v":0},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",IF(C48=\"Surface\",'Market Adj Factors'!U65,'Market Adj Factors'!U68),1)","v":4.5789999999999997},{"$f":"IF(C48=\"Surface\",'Market Adj Factors'!X65,'Market Adj Factors'!X68)","v":1.0790513833992095},0,0,0,0,0]
[null,"Cu. Ft to Cu. Yd",1613.33,"CY"]
[null,"Hr to Sec",3600,"s",null,"Powerstation Equipment"]
[null,"MW to W",1000000,"W",null,"Pump/Motors","Yes","LS",{"$f":"IF(G29=\"Yes\",1,0)","v":1},{"$f":"VLOOKUP(C51,'Cost Curves S-PSH'!$AO$205:$AQ$206,2,FALSE)*IF(C107>100,0,'Cost Curves L-PSH'!D365)","v":0},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U72,1)","v":4.0970000000000004},{"$f":"'Market Adj Factors'!X72","v":1.0900692840646651},{"$f":"IF(P29,P29,J29*K29*L29*M29)","v":0},0,0,{"$f":"N29*I29","v":0},{"$f":"Q29/$Q$53","v":0},{"$f":"IF(AND(R29=0%,R30=0%),R31,IF(R31=0%,SUM(R29:R30)))","v":0.21025019839202527}]
[null,"acceleration of gravity (metric)",9.81,"m/s^2",null,"Generator/Turbines","Yes","kW",{"$f":"IF(G30=\"Yes\",IF(C107<=100,IF(O30,O30,I10),0),0)","v":0},{"$f":"IF(C107>100,0,IF(C107<=100,'Cost Curves L-PSH'!E374,'Cost Curves L-PSH'!E378))","v":0},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U72,1)","v":4.0970000000000004},{"$f":"'Market Adj Factors'!X72","v":1.0900692840646651},0,0,0,{"$f":"N30*I30","v":0},{"$f":"Q30/$Q$53","v":0}]
[null,"density of water (metric)",1000,"kg/m^2",null,"Total Powerstation","Yes","kW",{"$f":"IF(G31=\"Yes\",IF(C107>100,IF(O31,O31,C108*1000),0),0)","v":1283327.8591994315},{"$f":"VLOOKUP(C51,'Cost Curves L-PSH'!$AO$205:$AQ$206,2,FALSE)*IF(C107<=100,0,IF(C47=\"Underground\", IF(C110<=80,IF(C109<=2,'Cost Curves L-PSH'!B171,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!C171,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!D171,IF(C109>4,'Cost Curves L-PSH'!E171)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves L-PSH'!L171,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!M171,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!N171,IF(C109>4,'Cost Curves L-PSH'!O171)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves L-PSH'!V171,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!W171,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!X171,IF(C109>4,'Cost Curves L-PSH'!Y171)))),IF(C110>225,IF(C109<=2,'Cost Curves L-PSH'!AF171,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AG171,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AH171,IF(C109>4,'Cost Curves L-PSH'!AI171)))))))),IF(C47=\"Surface\", IF(C110<=80,IF(C109<=2,'Cost Curves L-PSH'!B213,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!C213,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!D213,IF(C109>4,'Cost Curves L-PSH'!E213)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves L-PSH'!L213,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!M213,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!N213,IF(C109>4,'Cost Curves L-PSH'!O213)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves L-PSH'!V213,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!W213,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!X213,IF(C109>4,'Cost Curves L-PSH'!Y213)))),IF(C110>225,IF(C109<=2,'Cost Curves L-PSH'!AF213,IF(AND(C109>2,C109<=3),'Cost Curves L-PSH'!AG213,IF(AND(C109>3,C109<=4),'Cost Curves L-PSH'!AH213,IF(C109>4,'Cost Curves L-PSH'!AI213)))))))))))","v":103.21475999999998},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U72,1)","v":4.0970000000000004},{"$f":"'Market Adj Factors'!X72","v":1.0900692840646651},{"$f":"IF(P31,P31,J31*K31*L31*M31)","v":460.95854838762119},0,0,{"$f":"N31*I31","v":591560947.08196342},{"$f":"Q31/$Q$53","v":0.21025019839202527}]
[]
[null,"Condition Related",null,null,null,"Roads, Railroads, Bridges, and Access"]
[null,"Tunneling Condition","Average","#",null,"Access Roads","Yes","Miles",{"$f":"IF(G34=\"Yes\",IF(O34,O34,C38),0)","v":3.61},{"$f":"INDEX('Cost Curves L-PSH'!W241:X243,MATCH('Cost Model L-PSH'!C35,'Cost Curves L-PSH'!V241:V243,0),MATCH('Cost Model L-PSH'!C36,'Cost Curves L-PSH'!W240:X240,0))","v":189000},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U71,1)","v":2.41},{"$f":"'Market Adj Factors'!X71","v":1.0438311688311688},{"$f":"IF(P34,P34,J34*K34*L34*M34)","v":475454.65909090906},0,0,{"$f":"N34*I34","v":1716391.3193181816},{"$f":"Q34/$Q$53","v":6.1003285829650498E-4},{"$f":"SUM(R34:R36)","v":1.6353401707153006E-2}]
[null,"Access Road, Terrain","Flat","#",null,"Access Tunnels","Yes","Ft",{"$f":"IF(G35=\"Yes\",IF(C47=\"Surface\",0,IF(O35,O35,C39*5280)),0)","v":6600},{"$f":"IF(C47=\"Surface\",0,'Cost Curves L-PSH'!D242)","v":2555.8188374587603},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U70,1)","v":2.41},{"$f":"'Market Adj Factors'!X70","v":1.0790513833992095},{"$f":"IF(P35,P35,J35*K35*L35*M35)","v":6646.4422439890996},0,0,{"$f":"N35*I35","v":43866518.810328059},{"$f":"Q35/$Q$53","v":1.5590860634282376E-2}]
[null,"Access Road, Type","New","#",null,"Highway Realignment","Yes","%",{"$f":"IF(G36=\"Yes\",IF(C37=\"Yes\",25%,0%),0)","v":0.25},null,null,null,null,null,0,"NA",{"$f":"Q34*I36","v":429097.8298295454},{"$f":"Q36/$Q$53","v":1.5250821457412625E-4}]
[null,"Highway Realignment","Yes","#"]
[null,"Access Road",3.61,"miles",null,"Switchyard","Yes","LS",{"$f":"IF(G38=\"Yes\",1,0)","v":1},{"$f":"'Cost Curves L-PSH'!Q248*1000000","v":16726800},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U74,1)","v":2.41},{"$f":"'Market Adj Factors'!X74","v":1.0634249471458774},{"$f":"IF(P38,P38,J38*K38*L38*M38)","v":42868348.338266388},0,0,{"$f":"N38*I38","v":42868348.338266388},{"$f":"Q38/$Q$53","v":1.5236094923639632E-2},{"$f":"R38","v":1.5236094923639632E-2}]
[null,"Access Tunnel, Length",1.25,"miles"]
[null,"Water Supply =","No","#",null,"Transmission Lines","Yes","Miles",{"$f":"IF(G40=\"Yes\",C64,0)","v":13.5},{"$f":"'Cost Curves L-PSH'!G303*1000*C120*C121","v":1150309.4077795583},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U73,1)","v":3.1330000000000005},{"$f":"'Market Adj Factors'!X73","v":1.0504385964912282},{"$f":"IF(P40,P40,J40*K40*L40*M40)","v":3785696.0096943821},0,0,{"$f":"N40*I40","v":51106896.130874157},{"$f":"Q40/$Q$53","v":1.8164206247421738E-2},{"$f":"R40","v":1.8164206247421738E-2}]
[null,"Water Supply Cost = ",100,"$/ac-ft"]
[null,null,null,null,null,"Others"]
[null,"Technology Related",null,null,null,"Water Supply","Yes","ac-ft",{"$f":"IF(G43=\"Yes\",IF(C40=\"Yes\",C88,0),0)","v":0},{"$f":"C41","v":100},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},1,1,{"$f":"IF(P43,P43,J43*K43*L43*M43)","v":100},0,0,{"$f":"N43*I43","v":0},{"$f":"Q43/$Q$53","v":0},{"$f":"SUM(R43:R44)","v":0}]
[null,"U. Reservoir Intake/Outlet","Vertical","#"]
[null,"L. Reservoir Intake/Outlet","Horizontal","#",null,"Indirect Costs"]
[null,"Power Station Structure Geology","Adverse","#",null,"Mobilization/Demobilization","Yes","%",{"$f":"IF(G46=\"Yes\",IF(O46,O46,C55),0)","v":0.05},null,null,null,null,null,0,"NA",{"$f":"I46*SUM(Q8:Q43)","v":77939188.459224835},{"$f":"Q46/$Q$53","v":2.7700831024930747E-2},{"$f":"SUM(R46:R51)","v":0.44598337950138511}]
[null,"Power Station","Underground","#",null,"Sales Tax","Yes","%",{"$f":"IF(G47=\"Yes\",IF(O47,O47,C57),0)","v":0.06},null,null,null,null,null,0,"NA",{"$f":"I47*C56*SUM(Q8:Q43)","v":70145269.61330235},2.4930747922437674E-2]
[null,"Penstock","Underground","#",null,"Contingency","Yes","%",{"$f":"IF(G48=\"Yes\",IF(O48,O48,C58),0)","v":0.33},null,null,null,null,null,0,"NA",{"$f":"SUM(Q8:Q43)*I48","v":514398643.83088392},0.18282548476454294]
[null,"Reservoir Liner","Geomembrane Single Liner","#",null,"EPC Cost","Yes","%",{"$f":"IF(G49=\"Yes\",IF(O49,O49,C59),0)","v":0.28000000000000003},null,null,null,null,null,0,"NA",{"$f":"I49*SUM(Q8:Q43)","v":436459455.3716591},0.15512465373961221]
[null,"Dam Type","RCC","#",null,"Developer Cost","Yes","%",{"$f":"IF(G50=\"Yes\",IF(O50,O50,C60),0)","v":0.03},null,null,null,null,null,0,"NA",{"$f":"SUM(Q8:Q43)*I50","v":46763513.075534895},1.6620498614958446E-2]
[null,"Pump Type","Fixed","#",null,"Overhead & Profit","Yes","%",7.0000000000000007E-2,null,null,null,null,null,0,"NA",{"$f":"SUM(Q8:Q43)*I51","v":109114863.84291478},3.8781163434903052E-2]
[]
[null,"Project Related",null,null,null,"Total Direct and Indirect Cost",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q8:Q51)","v":2813604703.3780165},{"$f":"SUM(R8:R51)","v":1},{"$f":"SUM(S8:S51)","v":1}]
[null,"Inflation Factor","Yes","#"]
[null,"Mobilization/Demobilization =",0.05,"%",null,"System Cost"]
[null,"Material/Equipment % =",0.75,"%",null,"Total Direct and Indirect Cost $",{"$f":"Q53","v":2813604703.3780165}]
[null,"Sales Tax =",0.06,"%",null,"$/kW (Max. Power Capacity)",{"$f":"G56/(C108*1000)","v":2192.4286013187666}]
[null,"Contingency =",0.33,"%",null,"$/kWh (Max. Energy Capacity)",{"$f":"G56/(C108*C21*1000)","v":118.50965412533873}]
[null,"EPC Cost =",0.28000000000000003,"%"]
[null,"Developer Cost =",0.03,"%"]
[null,"Overhead & Profit =",7.0000000000000007E-2,"%"]
[]
[null,"Transmission Related"]
[null,"Transmission Distance =",13.5,"miles"]
[null,"Transmission =",500,"kV"]
[null,"Substation =",500,"kV"]
[null,"Transmission Terrain = ","Mountain","#"]
[null,"Transmission Type (# circuits) =","Double","#"]
[]
[null,"Project Related"]
[null,"Active Storage =",0.85,"x Gross Storage"]
[null,"Hmin/Hmax =",0.7,"#"]
[null,"Hazen Williams C =",90,"#"]
[null,"P-T Efficiency =",0.88,"%"]
[null,"Max Tunnel Velocity =",23,"fps"]
[null,"Max Tunnel Dia =",35,"feet"]
[null,"Max Unit Capacity =",350,"MW"]
[null,"Min No. Units =",2,"#"]
[null,"Pump Time =",{"$f":"12/10","v":1.2},"x gen time"]
[]
[null,"Output Specifications"]
[null,"Project Related"]
[null,"Conveyance Length",{"$f":"C15*C25","v":2.726137236},"miles"]
[null,"Avg. Upper Reservoir Volume =",{"$f":"C11*C10","v":19291},"ac-ft"]
[null,"Avg. Lower Reservoir Volume =",{"$f":"C13*C12","v":19560},"ac-ft"]
[null,"Total Upper Dam Volume =",{"$f":"IF(C50=\"Rockfill\",'Cost Curves L-PSH'!AA284,IF(C50=\"Earthfill\",'Cost Curves L-PSH'!S313,IF(C50=\"RCC\",'Cost Curves L-PSH'!AB284)))","v":327938},"CY"]
[null,"Total Lower Dam Volume =",{"$f":"IF(C50=\"Rockfill\",'Cost Curves L-PSH'!AA285,IF(C50=\"Earthfill\",'Cost Curves L-PSH'!V313,IF(C50=\"RCC\",'Cost Curves L-PSH'!AB285)))","v":184954},"CY"]
[null,"Active Storage =",{"$f":"C71*C84","v":16397.349999999999},"ac-ft"]
[null,"Energy Storage = ",{"$f":"C107*C21","v":18593.115464086866},"MWh"]
[null,"Mean Gen Discharge =",{"$f":"C88*C26/C21/C28","v":10724.753243243242},"cfs"]
[null,"Min Gross Head =",{"$f":"C72*C14","v":1092},"feet"]
[null,"Mean Gross Head =",{"$f":"(C91+C14)/2","v":1326},"feet"]
[null,"Min Gen Discharge =",{"$f":"(C91/C$92)^0.5*C$90","v":9732.554981027788},"cfs"]
[null,"Max Gen Discharge =",{"$f":"(C14/C$92)^0.5*C$90","v":11632.628155244369},"cfs"]
[null,"Nominal Tunnel Dia =",{"$f":"((C94/C75)*4/PI())^0.5","v":25.376403089464635},"feet"]
[null,"No. Tunnels =",{"$f":"IF(C95<C76,1,2)","v":1},"#"]
[null,"Adjusted Tunnel Dia =",{"$f":"((C94/C96/C75)*4/PI())^0.5","v":25.376403089464635},"feet"]
[null,"L/H =",{"$f":"C15/C92","v":10.855203619909503},"#"]
[null,"Surge Chambers",{"$f":"IF(C98>=7,\"Yes\",\"No\")","v":"Yes"},"#"]
[null,"Min Gen Headloss =",{"$f":"4.73*C93^1.85/C$73^1.85/C$97^4.87*C$15","v":57.060987811365827},"feet"]
[null,"Mean Gen Headloss =",{"$f":"4.73*C90^1.85/C$73^1.85/C$97^4.87*C$15","v":68.286696743817629},"feet"]
[null,"Max Gen Headloss =",{"$f":"4.73*C94^1.85/C$73^1.85/C$97^4.87*C$15","v":79.364009178258499},"feet"]
[null,"Net Head @ Min Gen Discharge =",{"$f":"C91-C100","v":1034.9390121886343},"feet"]
[null,"Net Head @ Mean Gen Discharge =",{"$f":"C92-C101","v":1257.7133032561824},"feet"]
[null,"Net Head @ Max Gen Discharge =",{"$f":"C$14-C102","v":1480.6359908217414},"feet"]
[null,"Min Plant Gen Power (Firm Capacity) =",{"$f":"C93*C103*C$74*$C$30*$C$31/$C$29*(1/C24)^4","v":750.50415069892881},"MW"]
[null,"Mean Plant Gen Power =",{"$f":"C90*C104*C$74*$C$30*$C$31/$C$29*(1/C24)^4","v":1005.0332683290197},"MW"]
[null,"Max Plant Gen Power =",{"$f":"C94*C105*C$74*$C$30*$C$31/$C$29*(1/C24)^4","v":1283.3278591994315},"MW"]
[null,"No. Units =",{"$f":"IF(C108/C77<=C78,C78,ROUNDUP(C108/C77,0))","v":4},"#"]
[null,"Unit Rating =",{"$f":"C108/C109","v":320.83196479985787},"MW"]
[null,"Max Penstock Velocity =",{"$f":"'Cost Curves L-PSH'!V130","v":28.056000000000001},"fps"]
[null,"Max Draft Tube Tunnel Velocity =",{"$f":"'Cost Curves L-PSH'!AA130","v":9.6688000000000009},"fps"]
[null,"Penstock Dia =",{"$f":"((C94/(C111*C109))*4/PI())^0.5","v":11.488176786506925},"feet"]
[null,"Draft Tube Tunnel Dia =",{"$f":"((C94/(C112*C109))*4/PI())^0.5","v":19.569408460355401},"feet"]
[null,"Pump Time =",{"$f":"C79*C21","v":22.2},"hrs"]
[null,"Mean Pump Discharge =",{"$f":"C88*C26/C115/3600","v":8937.2943693693687},"cfs"]
[null,"Mean Pump Headloss =",{"$f":"4.73*C116^1.85/C73^1.85/C97^4.87*C15","v":48.736103028638645},"feet"]
[null,"Mean Pump Net Head =",{"$f":"C92+C117","v":1374.7361030286386},"feet"]
[null,"Mean Pump Power =",{"$f":"C116*C118*C74*$C$30*$C$31/$C$29*(1/C24)^4","v":915.45473515288109},"MW"]
[null,"Tranmission Terrain Multiplier = ",{"$f":"VLOOKUP(C67,'Cost Curves L-PSH'!H276:I284,2,FALSE)","v":1.75},"#"]
[null,"Tranmission Type Multiplier =",{"$f":"IF(C68=\"Double\",'Cost Curves L-PSH'!I287,1)","v":1.6004696290247125},"#"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" (0.00006*('Cost Model L-PSH'!C16)^2 + 0.017*'Cost Model L-PSH'!C16 - 0.7412)*'Cost Model L-PSH'!C17*1000","v":2811640}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(0.0000905*('Cost Model L-PSH'!C16)^2 + 0.00386*('Cost Model L-PSH'!C16) + 0.0707)*1000","v":1837.1000000000001}]

{"sheet":"Cost Curves L-PSH","index":2,"n_rows":378,"n_cols":43,"rows_kept":378,"cut":false,"hidden":false,"merged":[[310,17,310,18],[310,20,310,21],[85,21,85,24],[85,25,85,28],[43,1,43,4],[43,5,43,8],[43,11,43,14],[43,15,43,18],[43,21,43,24],[43,25,43,28],[42,1,42,7],[42,11,42,17],[42,21,42,27],[42,31,42,37],[84,0,84,2],[84,21,84,27],[43,31,43,34],[43,35,43,38],[0,1,0,7],[0,11,0,17],[0,21,0,27],[0,31,0,37],[1,1,1,4],[1,5,1,8],[1,11,1,14],[1,15,1,18],[1,21,1,24],[1,25,1,28],[1,31,1,34],[1,35,1,38]]}
[null,"Underground Powestation Structure Cost 80MW units",null,null,null,null,null,null,null,null,null,"Underground Powestation Structure Cost 350MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 80MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 350MW units"]
[null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions"]
["Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units",null,"Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units",null,"Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units",null,"Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units"]
[350,135,116,104,92,174,145,132,118,null,500,78,70,62,58,98,84,78,70,null,350,84,77,72.5,67,112,95,87,78,null,350,38,35,32,30,58,48.5,45,39]
[500,113,96,86,78,150,124,113.5,102,null,1000,48,42,37,33,62,52,46,42.25,null,500,84,77.25,74,68,113.5,96,89,79.5,null,500,36,34,30,28,54,45,42,37]
[1000,91,76,68,60,116,98,86,76.5,null,1500,40.5,34,30,26,53,43,39,34.5,null,1000,87,80,76,74,118,102,93,85,null,1000,31,28,26,25,45,40,37,34]
[1500,81,69,59.5,54,103,88,77,68.5,null,2000,36,31,26,24,45,39,34.5,26,null,1500,92.5,86,84,80,125,108,100,91.5,null,1500,30,27,26,25.25,44.5,39,36,32]
[2000,78,63,58,50,98,82,72,62.5,null,2250,35,30,25,23,44,38,33.5,25,null,2000,102,95,92,87,134,116,106,98,null,2000,32,30,29,26,46,41,38,34]
[2250,77,62,57,49,97,81,71,62,null,null,null,null,null,null,null,null,null,null,null,2250,105.5,98,95,90,137,119,109.5,100,null,2250,33,31,30,28,48,42,39.5,35]
[null,"y = 740.12x-0.298","y = 760.42x-0.328","y = 645.72x-0.32","y = 640.28x-0.337","y = 1096.7x-0.319","y = 878.1x-0.313","y = 926.99x-0.337","y = 911.22x-0.352",null,null,"y = 2032.8x-0.532","y = 2231.2x-0.565","y = 2553x-0.604","y = 2504.2x-0.615","y = 2613x-0.533","y = 2154.7x-0.53","y = 2380.6x-0.559","y = 4996.8x-0.687",null,null,"y = 5E-06x2 - 0.0009x + 83.095","y = 4E-06x2 + 0.0004x + 75.715","y = 4E-06x2 + 0.0021x + 71.437","y = 6E-07x2 + 0.0109x + 62.383","y = 3E-06x2 + 0.0062x + 109.48","y = 1E-06x2 + 0.0099x + 90.767","y = 2E-06x2 + 0.0073x + 84.676","y = -1E-07x2 + 0.0123x + 73.167",null,null,"y = 6E-06x2 - 0.0183x + 43.547","y = 7E-06x2 - 0.0198x + 41.489","y = 6E-06x2 - 0.0162x + 36.672","y = 5E-06x2 - 0.0128x + 33.573","y = 1E-05x2 - 0.0308x + 67.023","y = 7E-06x2 - 0.0207x + 54.238","y = 7E-06x2 - 0.0205x + 50.886","y = 5E-06x2 - 0.0146x + 43.361"]
["Est. $/kW",{"$f":"740.12*('Cost Model L-PSH'!C14)^-0.298","v":82.746762311021598},{"$f":"760.42*('Cost Model L-PSH'!C14)^-0.328","v":68.188111490618297},{"$f":"645.72*('Cost Model L-PSH'!C14)^-0.32","v":61.410745084071252},{"$f":"640.28*('Cost Model L-PSH'!C14)^-0.337","v":53.738674073702647},{"$f":"1096.7*('Cost Model L-PSH'!C14)^-0.319","v":105.0705720118597},{"$f":"878.1*('Cost Model L-PSH'!C14)^-0.313","v":87.921679982121006},{"$f":"926.99*('Cost Model L-PSH'!C14)^-0.337","v":77.802232585090309},{"$f":"911.22*('Cost Model L-PSH'!C14)^-0.352","v":68.492557770829762},null,"Est. $/kW",{"$f":"2032.8*('Cost Model L-PSH'!C14)^-0.532","v":40.677323160852637},{"$f":"2231.2*('Cost Model L-PSH'!C14)^-0.565","v":35.028626061587921},{"$f":"2553*('Cost Model L-PSH'!C14)^-0.604","v":30.088709228442831},{"$f":"2504.2*('Cost Model L-PSH'!C14)^-0.615","v":27.220580536976755},{"$f":"2613*('Cost Model L-PSH'!C14)^-0.533","v":51.904378931613238},{"$f":"2154.7*('Cost Model L-PSH'!C14)^-0.53","v":43.755310950094469},{"$f":"2380.6*('Cost Model L-PSH'!C14)^-0.559","v":39.0597787354559},{"$f":"4996.8*('Cost Model L-PSH'!C14)^-0.687","v":31.990083068542301},null,"Est. $/kW",{"$f":"0.000005*('Cost Model L-PSH'!C14)^2 - 0.0009*('Cost Model L-PSH'!C14) + 83.095","v":93.858999999999995},{"$f":"0.000004*('Cost Model L-PSH'!C14)^2 + 0.0004*('Cost Model L-PSH'!C14) + 75.715","v":86.073400000000007},{"$f":"0.000004*('Cost Model L-PSH'!C14)^2 + 0.0021*('Cost Model L-PSH'!C14) + 71.437","v":84.447400000000002},{"$f":"0.0000006*('Cost Model L-PSH'!C14)^2 + 0.0109*('Cost Model L-PSH'!C14) + 62.383","v":80.847160000000002},{"$f":"0.000003*('Cost Model L-PSH'!C14)^2 + 0.0062*('Cost Model L-PSH'!C14) + 109.48","v":126.4528},{"$f":"0.000001*('Cost Model L-PSH'!C14)^2 + 0.0099*('Cost Model L-PSH'!C14) + 90.767","v":108.6446},{"$f":"0.000002*('Cost Model L-PSH'!C14)^2 + 0.0073*('Cost Model L-PSH'!C14) + 84.676","v":100.9312},{"$f":"-0.0000001*('Cost Model L-PSH'!C14)^2 + 0.0123*('Cost Model L-PSH'!C14) + 73.167","v":92.111639999999994},null,"Est. $/kW",{"$f":"0.000006*('Cost Model L-PSH'!C14)^2 - 0.0183*('Cost Model L-PSH'!C14) + 43.547","v":29.600599999999996},{"$f":"0.000007*('Cost Model L-PSH'!C14)^2 - 0.0198*('Cost Model L-PSH'!C14) + 41.489","v":27.636199999999995},{"$f":"0.000006*('Cost Model L-PSH'!C14)^2 - 0.0162*('Cost Model L-PSH'!C14) + 36.672","v":26.0016},{"$f":"0.000005*('Cost Model L-PSH'!C14)^2 - 0.0128*('Cost Model L-PSH'!C14) + 33.573","v":25.773000000000003},{"$f":"0.00001*('Cost Model L-PSH'!C14)^2 - 0.0308*('Cost Model L-PSH'!C14) + 67.023","v":43.310999999999993},{"$f":"0.000007*('Cost Model L-PSH'!C14)^2 - 0.0207*('Cost Model L-PSH'!C14) + 54.238","v":38.981200000000001},{"$f":"0.000007*('Cost Model L-PSH'!C14)^2 - 0.0205*('Cost Model L-PSH'!C14) + 50.886","v":35.941200000000002},{"$f":"0.000005*('Cost Model L-PSH'!C14)^2 - 0.0146*('Cost Model L-PSH'!C14) + 43.361","v":32.753}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"f"]
[]
[]
[]
[]
[]
[]
[]
[null,"Underground Powestation Structure Cost 125MW units",null,null,null,null,null,null,null,null,null,"Underground Powestation Structure Cost 225MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 125MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 225MW units"]
[null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions"]
["Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units",null,"Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units",null,"Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units",null,"Average Head, Ft","2 Units","3 Units","4 Units","6 Units","2 Units","3 Units","4 Units","6 Units"]
[350,123,108,97,90,158,134,122,112,null,350,116,100,92,83,148,126,116,104,null,350,63,56,52,48,92,75.5,70,64,null,350,50,44,41,38,73,61.5,56,50]
[500,95,83,75,68,120,103,96,86,null,500,95,80,73,64,116,100,94,83,null,500,62,55,52,48,90,76,71,64,null,500,46,41.5,38,36,70,59,55,48]
[1000,69,58,52,48,87,74,66,58,null,1000,59,52,44,40,74,64,55,52,null,1000,60,54,53,49,90,78,74,66,null,1000,42,37,36,34.5,64,55.5,51,46]
[1500,63,54,46,41,79,69,62,56,null,1500,46,41,36,32,60,50,44,40,null,1500,62,56,54.5,53,94,82,75.5,69,null,1500,44,40,37.5,36,62,55,50,47]
[2000,58,50,44,39,76,64,56,52,null,2000,45,38.75,34,30,56,48,43,38,null,2000,66,64,59,56,98,85,80,74,null,2000,45,43,40,38,64,56,53,49]
[2250,56,49,43,38,74,62,54,51,null,2250,45,38.5,33.75,29.5,57,48,43,38.5,null,2250,71,66,63,60,101,89,83,75,null,2250,46,44,41,38.5,66,58,55,50]
[null,"y = 1229.6x-0.405","y = 1113.2x-0.412","y = 1126.8x-0.431","y = 1195.5x-0.454","y = 1435.5x-0.392","y = 1258x-0.396","y = 1375x-0.424","y = 1131x-0.41",null,null,"y = 2163.3x-0.512","y = 1725.2x-0.501","y = 1735.2x-0.52","y = 1578.2x-0.524","y = 2315.8x-0.49","y = 2194.6x-0.505","y = 2353.1x-0.53","y = 2162.4x-0.533",null,null,"y = 7E-06x2 - 0.0146x + 67.574","y = 7E-06x2 - 0.0117x + 59.042","y = 5E-06x2 - 0.0065x + 54.377","y = 3E-06x2 - 0.0018x + 48.04","y = 4E-06x2 - 0.0039x + 90.761","y = 2E-06x2 + 0.0008x + 75.02","y = 2E-06x2 + 0.0002x + 70.655","y = 2E-06x2 + 0.002x + 62.446",null,null,"y = 6E-06x2 - 0.0159x + 53.593","y = 6E-06x2 - 0.0157x + 47.989","y = 5E-06x2 - 0.0116x + 43.522","y = 3E-06x2 - 0.0078x + 39.647","y = 8E-06x2 - 0.0241x + 80.261","y = 5E-06x2 - 0.0155x + 65.884","y = 6E-06x2 - 0.0165x + 61.35","y = 4E-06x2 - 0.0099x + 52.44"]
["Est. $/kW",{"$f":"1229.6*('Cost Model L-PSH'!C14)^-0.405","v":62.596260921003555},{"$f":"1113.2*('Cost Model L-PSH'!C14)^-0.412","v":53.827704941124054},{"$f":"1126.8*('Cost Model L-PSH'!C14)^-0.431","v":47.381645207458376},{"$f":"1195.5*('Cost Model L-PSH'!C14)^-0.454","v":42.449346896086169},{"$f":"1435.5*('Cost Model L-PSH'!C14)^-0.392","v":80.407832312764114},{"$f":"1258*('Cost Model L-PSH'!C14)^-0.396","v":68.423187215662807},{"$f":"1375*('Cost Model L-PSH'!C14)^-0.424","v":60.872041680483129},{"$f":"1131*('Cost Model L-PSH'!C14)^-0.41","v":55.498535055978614},null,"Est. $/kW",{"$f":"2163.3*('Cost Model L-PSH'!C14)^-0.512","v":50.146076159649688},{"$f":"1725.2*('Cost Model L-PSH'!C14)^-0.501","v":43.359476059148129},{"$f":"1735.2*('Cost Model L-PSH'!C14)^-0.52","v":37.924926507163271},{"$f":"1578.2*('Cost Model L-PSH'!C14)^-0.524","v":33.493825203543473},{"$f":"2315.8*('Cost Model L-PSH'!C14)^-0.49","v":63.105904575527866},{"$f":"2194.6*('Cost Model L-PSH'!C14)^-0.505","v":53.558382518354051},{"$f":"2353.1*('Cost Model L-PSH'!C14)^-0.53","v":47.784202996550476},{"$f":"2162.4*('Cost Model L-PSH'!C14)^-0.533","v":42.953704172108864},null,"Est. $/kW",{"$f":"0.000007*('Cost Model L-PSH'!C14)^2 - 0.0146*('Cost Model L-PSH'!C14) + 67.574","v":61.833199999999998},{"$f":"0.000007*('Cost Model L-PSH'!C14)^2 - 0.0117*('Cost Model L-PSH'!C14) + 59.042","v":57.825200000000002},{"$f":"0.000005*('Cost Model L-PSH'!C14)^2 - 0.0065*('Cost Model L-PSH'!C14) + 54.377","v":56.405000000000001},{"$f":"0.000003*('Cost Model L-PSH'!C14)^2 - 0.0018*('Cost Model L-PSH'!C14) + 48.04","v":52.532800000000002},{"$f":"0.000004*('Cost Model L-PSH'!C14)^2 - 0.0039*('Cost Model L-PSH'!C14) + 90.761","v":94.4114},{"$f":"0.000002*('Cost Model L-PSH'!C14)^2 + 0.0008*('Cost Model L-PSH'!C14) + 75.02","v":81.135199999999998},{"$f":"0.000002*('Cost Model L-PSH'!C14)^2 + 0.0002*('Cost Model L-PSH'!C14) + 70.655","v":75.834199999999996},{"$f":"0.000002*('Cost Model L-PSH'!C14)^2 + 0.002*('Cost Model L-PSH'!C14)+ 62.446","v":70.433199999999999},null,"Est. $/kW",{"$f":"0.000006*('Cost Model L-PSH'!C14)^2 - 0.0159*('Cost Model L-PSH'!C14) + 53.593","v":43.390600000000006},{"$f":"0.000006*('Cost Model L-PSH'!C14)^2 - 0.0157*('Cost Model L-PSH'!C14) + 47.989","v":38.098600000000005},{"$f":"0.000005*('Cost Model L-PSH'!C14)^2 - 0.0116*('Cost Model L-PSH'!C14)+ 43.522","v":37.594000000000001},{"$f":"0.000003*('Cost Model L-PSH'!C14)^2 - 0.0078*('Cost Model L-PSH'!C14) + 39.647","v":34.779800000000002},{"$f":"0.000008*('Cost Model L-PSH'!C14)^2 - 0.0241*('Cost Model L-PSH'!C14)+ 80.261","v":62.133799999999994},{"$f":"0.000005*('Cost Model L-PSH'!C14)^2 - 0.0155*('Cost Model L-PSH'!C14) + 65.884","v":53.872},{"$f":"0.000006*('Cost Model L-PSH'!C14)^2 - 0.0165*('Cost Model L-PSH'!C14) + 61.35","v":50.211600000000004},{"$f":"0.000004*('Cost Model L-PSH'!C14)^2 - 0.0099*('Cost Model L-PSH'!C14) + 52.44","v":46.730399999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Embankment Structure Cost $/CY",null,null,null,null,null,null,null,null,null,"Cost of Intakes/Outlets $M",null,null,null,null,null,null,null,null,null,null,"Cost of concrete lined water conductors",null,null,null,null,null,null,null,null,"Cost of Vertical Shafts $/LF"]
["Average Dam Height, Ft","Unit Volume CY/FT * 1000",null,"Total Dam Volume (CY x 10^6)","Unit Cost $/CY","1/x","1/y","hyperbolic fit",null,null,"Water Conductor Diameter, Ft","Horizontal Intake","Vertical Intake",null,null,null,null,null,null,null,null,"$/LF Average Tunneling Conditions",null,null,null,"$/LF Poor Tunneling Conditions",null,null,null,null,"Shaft Diameter, Ft","$/LF"]
[25,0.2,null,0.114,13.5,{"$f":"1/D87","v":8.7719298245614024},{"$f":"1/E87","v":7.407407407407407E-2},{"$f":"($H$98*D87)/($H$96+D87)","v":13.720565586723607},null,null,10,1.3,0.2,null,null,"0.0154x2 - 0.1968x + 1.85",null,null,null,null,"Inside Diameter, Ft","1/2 Mile","1 Mile","2 Mile","4 Mile","1/2 Mile","1 Mile","2 Mile","4 Mile",null,10,1950]
[50,0.5,null,1,9,{"$f":"1/D88","v":1},{"$f":"1/E88","v":0.1111111111111111},8.1565266080742109,null,null,15,2.5,0.45,null,"horizontal",{"$f":"0.0154*('Cost Model L-PSH'!C97)^2 - 0.1968*'Cost Model L-PSH'!C97 + 1.85","v":6.7729361118818101},null,null,null,null,10,1000,1200,1300,1400,1400,1500,1550,1600,null,15,2800]
[100,1.4,null,2,8,0.5,0.125,7.9491405953633016,null,null,20,4.2,0.9,null,null,null,null,null,null,null,15,1500,1700,1800,1900,2200,2400,2500,2600,null,20,3700,null,null,"186.57x + 27.143"]
[150,2.7,null,4,7.8,0.25,0.12820512820512822,7.8493526569366407,null,null,25,6.4,1.3,null,null,"0.0046x2 - 0.0819x + 0.5993",null,null,null,null,20,2200,2400,2500,2700,3200,3450,3600,3900,null,25,4700,null,"$/lf",{"$f":"186.57*'Cost Model L-PSH'!C97 + 27.143","v":4761.6185244014168}]
[200,4.4000000000000004,null,6,7.7,0.16666666666666666,0.12987012987012986,7.8166444321108628,null,null,30,9.6,2.2999999999999998,null,"vertical",{"$f":"0.0046*('Cost Model L-PSH'!C97)^2 - 0.0819*'Cost Model L-PSH'!C97 + 0.5993","v":1.4831970222642012},null,null,null,null,25,3200,3400,3550,3900,4600,4900,5200,5600,null,30,5600]
[250,6.7,null,8,7.6,0.125,0.13157894736842105,7.8003923284559873,null,null,35,13.9,3.4,null,null,null,null,null,null,null,30,4400,4550,4975,5450,6500,6700,7400,8100,null,35,6600]
[300,9.4,null,10,7.5,0.1,0.13333333333333333,7.7906734650387177,null,null,null,null,null,null,null,null,null,null,null,null,35,5600,5900,6450,7500,8450,8750,9350,11250]
[350,12.5,null,null,null,null,null,"y = (7.75204x)/(x - 0.049591)",null,null,null,null,null,null,null,null,null,null,null,null,null,"3.9286x2 + 10.071x + 481.43","4.3214x2 - 5.6071x + 815","5.5536x2 - 42.339x + 1165.4","7.6786x2 - 103.54x + 1690.7","6.6786x2 - 17.393x + 915","6.25x2 + 7.8929x + 819.29","6.7143x2 + 13.857x + 732.86","11.107x2 - 120.11x + 1777.9"]
[null,null,"Upper Dam",null,"Lower Dam",null,"slope->",{"$f":"SLOPE(G87:G93,F87:F93)","v":-6.3971129931087774E-3},"$/CY Upper",{"$f":" (7.75204*C98)/(C98 - 0.049591)","v":7.9166421358164936},null,null,null,null,null,null,null,null,null,null,null,{"$f":"3.9286*('Cost Model L-PSH'!C97)^2 + 10.071*('Cost Model L-PSH'!C97) + 481.43","v":3266.8642156195669},{"$f":"4.3214*('Cost Model L-PSH'!C97)^2 - 5.6071*('Cost Model L-PSH'!C97) + 815","v":3455.528638643163},{"$f":"5.5536*('Cost Model L-PSH'!C97)^2 - 42.339*'Cost Model L-PSH'!C97 + 1165.4","v":3667.2949095590852},{"$f":"7.6786*('Cost Model L-PSH'!C97)^2 - 103.54*'Cost Model L-PSH'!C97 + 1690.7","v":4007.9525608186141},{"$f":"6.6786*('Cost Model L-PSH'!C97)^2 - 17.393*'Cost Model L-PSH'!C97 + 915","v":4774.3917240077335},{"$f":"6.25*('Cost Model L-PSH'!C97)^2 + 7.8929*'Cost Model L-PSH'!C97 + 819.29","v":5044.3448729385245},{"$f":"6.7143*('Cost Model L-PSH'!C97)^2 + 13.857*'Cost Model L-PSH'!C97 + 732.86","v":5408.253758018699},{"$f":"11.107*('Cost Model L-PSH'!C97)^2 - 120.11*'Cost Model L-PSH'!C97 + 1777.9","v":5882.4243124855075}]
[null,"U.Unit Volume CY/Ft",{"$f":"(0.00009*('Cost Model L-PSH'!C16)^2 + 0.0039*'Cost Model L-PSH'!C16 + 0.0707)*1000","v":1834.7},"L.Unit Volume CY/Ft",{"$f":"(0.00009*('Cost Model L-PSH'!C18)^2 + 0.0039*'Cost Model L-PSH'!C18 + 0.0707)*1000","v":628.70000000000005},null,"hyper k->",{"$f":"H95*H98","v":-4.9590669370585025E-2},"$/CY Lower",{"$f":" (7.75204*E98)/(E98 - 0.049591)","v":8.3508624157488018}]
[null,"U.Total Volume CY",{"$f":"C96*'Cost Model L-PSH'!C17","v":2385110},"L.Total Volume CY",{"$f":"E96*'Cost Model L-PSH'!C19","v":691570},null,"intercept->",{"$f":"INTERCEPT(G87:G93,F87:F93)","v":0.128998319125397}]
[null,"U.Volume CY * 10^6",{"$f":"C97/(10^6)","v":2.3851100000000001},"L.Volume CY * 10^6",{"$f":"E97/(10^6)","v":0.69157000000000002},null,"hyper m->",{"$f":"1/H97","v":7.7520389938408236}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Penstock Tunnel Max Velocity",null,null,null,"Draft Tube Tunnel Max Velocity"]
["Cost of Pennstocks and Draft Tube Tunnels $/Ft",null,null,null,null,null,null,null,null,null,"Cost of Surface Pennstocks $/Ft",null,null,null,null,null,null,null,null,null,"Head (ft)","Velocity (Fps)",null,null,"Head (ft)","Velocity (Fps)"]
["Diameter, Ft","500 Ft","1000 Ft","1500 Ft","2000 Ft",null,null,null,null,null,"Diameter, Ft","300 Ft","500 Ft","700 Ft","1000 Ft","1500 Ft",null,null,null,null,300,18,null,null,300,8]
[5,null,null,null,null,null,null,null,null,null,10,1.55,2.2000000000000002,3.2,4.5,6.65,null,null,null,null,500,20,null,null,500,10]
[10,2200,2400,3000,3800,null,null,null,null,null,15,3.3,5,7,10,14.75,null,null,null,null,1000,25,null,null,1000,13]
[15,4100,4600,6000,7600,null,null,null,null,null,20,5.6,8.6999999999999993,12.3,null,null,null,null,null,null,1500,28,null,null,1500,15]
[20,6900,7800,10300,13250,null,null,null,null,null,25,8.6,13.7,null,null,null,null,null,null,null,2200,32,null,null,2200,17]
[25,10000,11700,15800,null,null,null,null,null,null,30,12.2]
[30,null,null,null,null,null,null,null,null,null,35,16.5,null,null,null,null,null,null,null,null,null,"0.0074x + 16.512",null,null,null,null,"0.0046x + 7.516"]
[null,"47.162x1.6615","43.711x1.7314","45.454x1.8126","60.182x1.7959",null,null,null,null,null,null,"0.02x1.885","0.0226x1.9901","0.0365x1.9417","0.0483x1.9694","0.0721x1.9647",null,null,null,null,null,{"$f":"0.0074*'Cost Model L-PSH'!C14 + 16.512","v":28.056000000000001},null,null,null,null,{"$f":"0.0046*('Cost Model L-PSH'!C14-'Cost Model L-PSH'!C91) + 7.516","v":9.6688000000000009}]
["Penstock",{"$f":"47.162*('Cost Model L-PSH'!C113)^1.6615","v":2723.9518933815143},{"$f":"43.711*('Cost Model L-PSH'!C113)^1.7314","v":2994.3979325136297},{"$f":"45.454*('Cost Model L-PSH'!C113)^1.8126","v":3796.4988250748174},{"$f":"60.182*('Cost Model L-PSH'!C113)^1.7959","v":4825.8251785474667},null,null,null,null,null,null,{"$f":"0.02*('Cost Model L-PSH'!C113)^1.885*1000","v":1993.4407791566994},{"$f":"0.0226*('Cost Model L-PSH'!C113)^1.9901*1000","v":2911.4824285724558},{"$f":"0.0365*('Cost Model L-PSH'!C113)^1.9417*1000","v":4178.1347746966358},{"$f":"0.0483*('Cost Model L-PSH'!C113)^1.9694*1000","v":5915.6935338640669},{"$f":"0.0721*('Cost Model L-PSH'!C113)^1.9647*1000","v":8729.9271735317598}]
["Draft Tube",{"$f":"47.162*('Cost Model L-PSH'!C114)^1.6615","v":6600.0702685899114},{"$f":"43.711*('Cost Model L-PSH'!C114)^1.7314","v":7530.5789966806788},{"$f":"45.454*('Cost Model L-PSH'!C114)^1.8126","v":9969.7861571797202},{"$f":"60.182*('Cost Model L-PSH'!C114)^1.7959","v":12560.617900036737}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Underground Powerstation Equipment Costs 80MW Units $/kW",null,null,null,null,null,null,null,null,null,"Underground Powerstation Equipment Costs 125MW Units $/kW",null,null,null,null,null,null,null,null,null,"Underground Powerstation Equipment Costs 225MW Units $/kW",null,null,null,null,null,null,null,null,null,"Underground Powerstation Equipment Costs 350MW Units $/kW"]
["Average Head, Ft","160 MW","240 MW","320 MW","480 MW",null,null,null,null,null,"Average Head, Ft","250 MW","375 MW","500 MW","750 MW",null,null,null,null,null,"Average Head, Ft","450 MW","675 MW","900 MW","1350 MW",null,null,null,null,null,"Average Head, Ft","700 MW","1050 MW","1400 MW","2100 MW"]
[350,242,229,223,216,null,null,null,null,null,350,203,194,188,184,null,null,null,null,null,350,163,155,151,146,null,null,null,null,null,350,130,124,121,117]
[500,235,224,217,210,null,null,null,null,null,500,194,185,180,176,null,null,null,null,null,500,153,145,142,137,null,null,null,null,null,500,124,116,114,111]
[1000,224,212,205,200,null,null,null,null,null,1000,183,174,169,165,null,null,null,null,null,1000,139,134,130,126,null,null,null,null,null,1000,112,107,105,102]
[1500,222,210,204,200,null,null,null,null,null,1500,180,173,168,164,null,null,null,null,null,1500,138.5,133.5,129,126,null,null,null,null,null,1500,114,107.5,105.5,103]
[2000,237,226,220,215,null,null,null,null,null,2000,185,176,173,168,null,null,null,null,null,2000,143,135.5,134,130,null,null,null,null,null,2000,115,110,107,104.5]
[2250,245,234,228,223,null,null,null,null,null,2250,187,179,175,171,null,null,null,null,null,2250,145,137,135,132,null,null,null,null,null,2250,115.5,110.5,107.5,105.5]
[]
[null,"2E-05x2 - 0.0609x + 259.97","2E-05x2 - 0.0609x + 247.79","2E-05x2 - 0.0617x + 241.53","2E-05x2 - 0.0555x + 232.3",null,null,null,null,null,null,"2E-05x2 - 0.0485x + 216.18","2E-05x2 - 0.0462x + 206.27","2E-05x2 - 0.0453x + 200.29","2E-05x2 - 0.0456x + 196.43",null,null,null,null,null,null,"2E-05x2 - 0.0544x + 177.56","1E-05x2 - 0.0448x + 166.28","2E-05x2 - 0.048x + 163.78","2E-05x2 - 0.0452x + 157.75",null,null,null,null,null,null,"1E-05x2 - 0.0365x + 139.89","1E-05x2 - 0.0355x + 132.8","1E-05x2 - 0.033x + 129.39","1E-05x2 - 0.0316x + 125.28"]
[null,{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0609*'Cost Model L-PSH'!C92 + 259.97","v":214.38212000000004},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0609*('Cost Model L-PSH'!C92) + 247.79","v":202.20211999999998},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0617*('Cost Model L-PSH'!C92) + 241.53","v":194.88132000000002},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0555*('Cost Model L-PSH'!C92) + 232.3","v":193.87252000000001},null,null,null,null,null,null,{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0485*('Cost Model L-PSH'!C92) + 216.18","v":187.03451999999999},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0462*('Cost Model L-PSH'!C92) + 206.27","v":180.17432000000002},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0453*('Cost Model L-PSH'!C92) + 200.29","v":175.38772},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0456*('Cost Model L-PSH'!C92) + 196.43","v":171.12992},null,null,null,null,null,null,{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0544*('Cost Model L-PSH'!C92) + 177.56","v":140.59111999999999},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0448*('Cost Model L-PSH'!C92) + 166.28","v":124.45796},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.048*('Cost Model L-PSH'!C92) + 163.78","v":135.29751999999999},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0452*('Cost Model L-PSH'!C92) + 157.75","v":132.98032000000001},null,null,null,null,null,null,{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0365*('Cost Model L-PSH'!C92) + 139.89","v":109.07375999999999},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0355*('Cost Model L-PSH'!C92) + 132.8","v":103.30976000000001},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.033*('Cost Model L-PSH'!C92) + 129.39","v":103.21475999999998},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0316*('Cost Model L-PSH'!C92) + 125.28","v":100.96116000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Surface Powerstation Equipment Costs 80MW Units $/kW",null,null,null,null,null,null,null,null,null,"Surface Powerstation Equipment Costs 125MW Units $/kW",null,null,null,null,null,null,null,null,null,"Surface Powerstation Equipment Costs 225MW Units $/kW",null,null,null,null,null,null,null,null,null,"Surface Powerstation Equipment Costs 350MW Units $/kW",null,null,null,null,null,null,null,null,null,"Pump Type Cost Multipliers"]
["Average Head, Ft","160 MW","240 MW","320 MW","480 MW",null,null,null,null,null,"Average Head, Ft","250 MW","375 MW","500 MW","750 MW",null,null,null,null,null,"Average Head, Ft","450 MW","675 MW","900 MW","1350 MW",null,null,null,null,null,"Average Head, Ft","700 MW","1050 MW","1400 MW","2100 MW",null,null,null,null,null,null,"Pump-Turbine","Powerhouse"]
[350,237,225,219,214,null,null,null,null,null,350,200,190,185,183,null,null,null,null,null,350,157,151,146,144,null,null,null,null,null,350,133,126,124,120,null,null,null,null,null,"Fixed",1,1]
[500,236.5,224,217,213,null,null,null,null,null,500,189,179.5,176,171.5,null,null,null,null,null,500,151,144.5,142,136,null,null,null,null,null,500,124,117,115,114,null,null,null,null,null,"Variable",1.2,1.05]
[1000,234,222,216,210,null,null,null,null,null,1000,180,170.5,167,162,null,null,null,null,null,1000,144,137,134,130.5,null,null,null,null,null,1000,111.5,105.5,104,101]
[1500,234.5,223,216.5,212,null,null,null,null,null,1500,181.5,174,168,164,null,null,null,null,null,1500,144,137.5,134,131,null,null,null,null,null,1500,110,105,104,100]
[2000,238.5,228,224,217,null,null,null,null,null,2000,187.5,180,176,173,null,null,null,null,null,2000,146,143,137,135,null,null,null,null,null,2000,110.5,105,104,100.5]
[2250,245,234,228,222,null,null,null,null,null,2250,194,185,180,176,null,null,null,null,null,2250,150,144.5,140.5,137,null,null,null,null,null,2250,111,105.3,104,101]
[]
[null,"8E-06x2 - 0.0174x + 242.74","8E-06x2 - 0.017x + 230.3","8E-06x2 - 0.0168x + 223.7","8E-06x2 - 0.0173x + 219.28",null,null,null,null,null,null,"2E-05x2 - 0.0499x + 212.36","2E-05x2 - 0.0457x + 200.9","2E-05x2 - 0.046x + 196.81","2E-05x2 - 0.0501x + 195",null,null,null,null,null,null,"1E-05x2 - 0.0319x + 165.52","1E-05x2 - 0.0338x + 159.73","1E-05x2 - 0.0313x + 155.12","1E-05x2 - 0.0309x + 151.13",null,null,null,null,null,null,"1E-05x2 - 0.0447x + 144.85","1E-05x2 - 0.041x + 136.46","1E-05x2 - 0.0391x + 133.75","1E-05x2 - 0.0406x + 131.67"]
[null,{"$f":"0.000008*('Cost Model L-PSH'!C92)^2 - 0.0174*('Cost Model L-PSH'!C92) + 242.74","v":233.73380800000001},{"$f":"0.000008*('Cost Model L-PSH'!C92)^2 - 0.017*('Cost Model L-PSH'!C92) + 230.3","v":221.824208},{"$f":"0.000008*('Cost Model L-PSH'!C92)^2 - 0.0168*('Cost Model L-PSH'!C92) + 223.7","v":215.489408},{"$f":"0.000008*('Cost Model L-PSH'!C92)^2 - 0.0173*('Cost Model L-PSH'!C92) + 219.28","v":210.406408},null,null,null,null,null,null,{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0499*('Cost Model L-PSH'!C92) + 212.36","v":181.35812000000001},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0457*('Cost Model L-PSH'!C92) + 200.9","v":175.46732},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.046*('Cost Model L-PSH'!C92) + 196.81","v":170.97952000000001},{"$f":"0.00002*('Cost Model L-PSH'!C92)^2 - 0.0501*('Cost Model L-PSH'!C92)+ 195","v":163.73292000000001},null,null,null,null,null,null,{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0319*('Cost Model L-PSH'!C92) + 165.52","v":140.80336},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0338*('Cost Model L-PSH'!C92)+ 159.73","v":132.49395999999999},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0313*('Cost Model L-PSH'!C92) + 155.12","v":131.19896},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0309*('Cost Model L-PSH'!C92) + 151.13","v":127.73936},null,null,null,null,null,null,{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0447*('Cost Model L-PSH'!C92) + 144.85","v":103.16056},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.041*('Cost Model L-PSH'!C92)+ 136.46","v":99.676760000000002},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0391*('Cost Model L-PSH'!C92) + 133.75","v":99.486159999999998},{"$f":"0.00001*('Cost Model L-PSH'!C92)^2 - 0.0406*('Cost Model L-PSH'!C92) + 131.67","v":95.417159999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Access Tunnel Costs, $/LF",null,null,null,null,null,null,null,null,null,"Switchyard Costs, $M",null,null,null,null,null,null,null,null,null,null,"Access Road, $/mile",null,null,null,null,null,null,null,null,"Liner Cost ($/sq.ft)"]
["Tunnel Length, Miles","$/LF",null,null,null,null,null,null,null,null,"No. of generating units","115 to 161 kV","230 kV","345 kV","500 kV",null,null,null,null,null,null,"Terrain","New","Rebuild",null,null,null,null,null,null,null,"$/Sq.yd","$/sq.ft"]
[0.25,2090,null,"2489.4x0.118",null,null,null,null,null,null,2,1.4,1.7,3.55,7.35,null,null,null,null,null,null,"Steep",439000,293000,null,null,null,null,null,null,"Geomembrane Single Liner",40,{"$f":"AF241/9","v":4.4444444444444446}]
[0.5,2330,null,{"$f":"2489.4*('Cost Model L-PSH'!C39)^0.118","v":2555.8188374587603},null,null,null,null,null,null,3,2.2000000000000002,2.8,6.15,13.5,null,null,null,null,null,null,"Mild",283000,186000,null,null,null,null,null,null,"Geomembrane Double Liner with Leak Detection",55,{"$f":"AF242/9","v":6.1111111111111107}]
[1,2500,null,null,null,null,null,null,null,null,4,2.75,3.7,7.9,16.5,null,null,null,null,null,null,"Flat",189000,123000,null,null,null,null,null,null,"Other (clay, asphalt, concrete)",60,{"$f":"AF243/9","v":6.666666666666667}]
[1.5,2600,null,null,null,null,null,null,null,null,5,3.3,4.4000000000000004,9.4,19]
[2,2690,null,null,null,null,null,null,null,null,6,3.65,4.9000000000000004,11,21]
[]
[null,null,null,null,null,null,null,null,null,null,null,"-0.0643x2 + 1.0743x - 0.48","-0.1x2 + 1.6x - 1.1","-0.1607x2 + 3.1007x - 1.91","-0.6286x2 + 8.3086x - 6.45"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"-0.0643*('Cost Model L-PSH'!C109)^2 + 1.0743*'Cost Model L-PSH'!C109 - 0.48","v":2.7884000000000002},{"$f":"-0.1*('Cost Model L-PSH'!C109)^2 + 1.6*('Cost Model L-PSH'!C109) - 1.1","v":3.7000000000000006},{"$f":"-0.1607*('Cost Model L-PSH'!C109)^2 + 3.1007*('Cost Model L-PSH'!C109) - 1.91","v":7.921599999999998},{"$f":"-0.6286*('Cost Model L-PSH'!C109)^2 + 8.3086*('Cost Model L-PSH'!C109) - 6.45","v":16.726800000000001},null,{"$f":"IF('Cost Model L-PSH'!C66<=160,'Cost Curves L-PSH'!L248,IF(AND('Cost Model L-PSH'!C66>160,'Cost Model L-PSH'!C66<=230),'Cost Curves L-PSH'!M248,IF(AND('Cost Model L-PSH'!C66>230,'Cost Model L-PSH'!C66<=345),'Cost Curves L-PSH'!N248,IF('Cost Model L-PSH'!C66>345,'Cost Curves L-PSH'!O248))))","v":16.726800000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transmission Line Costs Per Mile, $1000s"]
["Transmitted Power, MW","138 kV","230 kV","345 kV","500 kV",null,null,"Transmission Terrain Multiplier"]
[28.5,110,null,null,null,null,null,"Desert",1.05]
[30,112,null,null,null,null,null,"Flat",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dam Height (ft)","Earthfill Volume (x1000 cu. yd.)","Rockfill Volume (x1000 cu. yd.)","RCC Gravity Volume (x1000 cu. yd.)"]
[40,115,null,null,null,null,null,"Farmland",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.15,0.15,0.15]
[50,120,null,null,null,null,null,"Forested",2.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1.8,1,0.2]
[60,122,null,null,null,null,null,"Rolling Hill",1.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,5,3,0.65]
[70,128,null,null,null,null,null,"Mountain",1.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,10,5.95,1.1000000000000001]
[80,132,null,null,null,null,null,"Wetland",1.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,16,9.5,2.25]
[90,140,null,null,null,null,null,"Suburban",1.27]
[100,150,null,null,null,null,null,"Urban",1.59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper Dam Volume",null,{"$f":" (6.21*(10^-5)*('Cost Model L-PSH'!C16)^2 + 0.017*'Cost Model L-PSH'!C16 - 0.7412)*'Cost Model L-PSH'!C17*1000","v":2850952},{"$f":" (3.72*(10^-5)*('Cost Model L-PSH'!C16)^2 + 0.00993*'Cost Model L-PSH'!C16 - 0.4173)*'Cost Model L-PSH'!C17*1000","v":1702974},{"$f":" (0.0000164*('Cost Model L-PSH'!C16)^2 - 0.00155*'Cost Model L-PSH'!C16 + 0.2021)*'Cost Model L-PSH'!C17*1000","v":327938}]
[125,172,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower Dam Volume",null,{"$f":" (6.21*(10^-5)*('Cost Model L-PSH'!C18)^2 + 0.017*'Cost Model L-PSH'!C18 - 0.7412)*'Cost Model L-PSH'!C19*1000","v":552596},{"$f":" (3.72*(10^-5)*('Cost Model L-PSH'!C18)^2 + 0.00993*'Cost Model L-PSH'!C18 - 0.4173)*'Cost Model L-PSH'!C19*1000","v":343662.00000000006},{"$f":" (0.0000164*('Cost Model L-PSH'!C18)^2 - 0.00155*'Cost Model L-PSH'!C18 + 0.2021)*'Cost Model L-PSH'!C19*1000","v":184954}]
[102,null,175,null,null,null,null,"Tranmission Circuit Multiplier"]
[150,null,180,null,null,null,null,"Double",{"$f":"AVERAGE(K290:K292)","v":1.6004696290247125}]
[200,null,190]
[300,null,230,null,null,null,null,"Transmission kV","Single Circuit $/mile","Double Circuit $/mile"]
[340,null,240,null,null,null,null,230,959700,1536400,{"$f":"J290/I290","v":1.6009169532145462}]
[350,null,null,275,null,null,null,345,1343800,2150300,{"$f":"J291/I291","v":1.6001637148385177}]
[400,null,null,280,null,null,null,500,1919450,3071750,{"$f":"J292/I292","v":1.6003282190210737}]
[500,null,null,285]
[600,null,null,290]
[700,null,null,295]
[800,null,null,305]
[900,null,null,325,400]
[1000,null,null,370,402]
[2000,null,null,null,450]
[3000,null,null,null,575]
[]
[null,"0.0043x2 - 0.028x + 108.72","0.0007x2 - 0.0382x + 169.98","0.0003x2 - 0.2536x + 335.57","4E-05x2 - 0.0652x + 428.5"]
[null,{"$f":"0.0043*('Cost Model L-PSH'!C108)^2 - 0.028*'Cost Model L-PSH'!C108 + 108.72","v":7154.5875149912181},{"$f":"0.0007*('Cost Model L-PSH'!C108)^2 - 0.0382*('Cost Model L-PSH'!C108) + 169.98","v":1273.8081517167586},{"$f":"0.0003*('Cost Model L-PSH'!C108)^2 - 0.2536*('Cost Model L-PSH'!C108) + 335.57","v":504.19717316624286},{"$f":"0.00004*('Cost Model L-PSH'!C108)^2 - 0.0652*('Cost Model L-PSH'!C108)+ 428.5","v":410.70423934809293},null,{"$f":"IF('Cost Model L-PSH'!C65<=138,'Cost Curves L-PSH'!B303,IF(AND('Cost Model L-PSH'!C65>138,'Cost Model L-PSH'!C65<=230),'Cost Curves L-PSH'!C303,IF(AND('Cost Model L-PSH'!C65>230,'Cost Model L-PSH'!C65<=345),'Cost Curves L-PSH'!D303,IF('Cost Model L-PSH'!C65<=138>=345,'Cost Curves L-PSH'!E303))))","v":410.70423934809293}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper Dam",null,null,"Lower Dam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Volume",{"$f":"(0.0000905*('Cost Model L-PSH'!C16)^2 + 0.00386*('Cost Model L-PSH'!C16) + 0.0707)*1000","v":1837.1000000000001},null,"Unit Volume",{"$f":"(0.0000905*('Cost Model L-PSH'!C18)^2 + 0.00386*('Cost Model L-PSH'!C18) + 0.0707)*1000","v":628.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Volume",{"$f":"S312*'Cost Model L-PSH'!C17","v":2388230},null,"Total Volume",{"$f":"V312*'Cost Model L-PSH'!C19","v":690910}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Power Station",{"$f":"'Cost Model L-PSH'!C47","v":"Underground"}]
["UR Connection",{"$f":"IF('Cost Model L-PSH'!C44=\"Horizontal\",\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",IF('Cost Model L-PSH'!C44=\"Vertical\",\"Vertical Intake to Shaft to Upper Tunnel\"))","v":"Vertical Intake to Shaft to Upper Tunnel"}]
["Water Conductor","Penstock"]
["LR Connection","Direct Discharge"]
[]
["Configuration",{"$f":"IF(AND(B332=\"Underground\",B333=\"Vertical Intake to Shaft to Upper Tunnel\",B334=\"Tunnel\",B335=\"Tailrace tunnel\"),\"A\",IF(AND(B332=\"Underground\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Tunnel\",B335=\"Tailrace tunnel\"),\"B\",IF(AND(B332=\"Surface\",B333=\"Vertical Intake to Shaft to Upper Tunnel\",B334=\"Tunnel\",B335=\"Direct Discharge\"),\"C\",IF(AND(B332=\"Surface\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Tunnel\",B335=\"Tailrace tunnel\"),\"D\",IF(AND(B332=\"Surface\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Penstock\",B335=\"Tailrace tunnel\"),\"E\",IF(AND(B332=\"Surface\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Penstock\",B335=\"Direct Discharge\"),\"F\",\"Out of Bounds\"))))))","v":"Out of Bounds"}]
["Small System Powerstation Costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2008-2011 $",null,"1 cfs = 448.83 gal/min or 7.48 gal/sec"]
["gal/min","stand by power k$"]
[400,65,null,{"$f":"'Cost Model L-PSH'!C116*448.83","v":4011325.8318040534},"gal/min"]
[700,100,null,"stand by power k$"]
[1000,150,null,{"$f":"0.7799*(D363)^0.7442*1000","v":64003806.784460768},"$"]
[5000,400]
[10000,750]
[15000,1000]
[50000,2500]
[]
["2011-2015 $"]
["Low Head","200 ft or less"]
["Turbine generator and Control Cost in $/kW by capacity in MW"]
["y = 1051.9*x^-0.204",null,null,{"$f":"'Cost Model L-PSH'!I10/1000","v":1283.3278591994315},{"$f":"1051.9*(D374^-0.204)*'Market Adj Factors'!C47","v":293.33819961284178}]
[]
["High Head","200 ft or more"]
["Turbine generator and Control Cost in $/kW by capacity in MW"]
["y = 697.41*x^-0.329",null,null,{"$f":"D374","v":1283.3278591994315},{"$f":"697.41*D378^-0.329*'Market Adj Factors'!C47","v":79.495058738180006}]

{"sheet":"Cost Model S-PSH","index":3,"n_rows":121,"n_cols":21,"rows_kept":121,"cut":false,"hidden":false,"merged":[[5,1,6,3]]}
[]
[]
[]
[]
[]
[null,"Inputs & Assumptions",null,null,null,"Cost Components","Include in Total? (Yes or No - User Option)","Unit","Qty","Base Unit Cost ($/unit) (Includes material, equipment rental, installation labor)","Locational Factor","CPI + MAF Composite (2022)","USBR Adjustment Factor (2024)","Adjusted Unit Cost ($)","Override Qty","Override Unit Cost ($)","Total Component Cost ($)","% of total cost (component)","% of total cost (category)"]
[]
[null,"Site Related",null,null,null,"Land and Land Rights","Yes","Acres",{"$f":"IF(G8=\"Yes\",IF(O8,O8,C20),0)","v":2185},{"$f":"IFERROR(VLOOKUP(C9,'Land Value Data'!$A$3:$G$51,7,FALSE),'Land Value Data'!G51)","v":3093.3333333333335},1,{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!C48,1)","v":1.1576717200995823},1,{"$f":"IF(P8,P8,J8*K8*L8*M8)","v":3581.0645208413748},0,0,{"$f":"I8*N8","v":7824625.9780384041},{"$f":"Q8/$Q$53","v":2.8363941761976566E-3},{"$f":"R8","v":2.8363941761976566E-3},16264166.097278001]
[null,"Location","United States","#"]
[null,"Avg. Max Upper Reservoir Depth",101,"feet",null,"Powerplant Structure","Yes","kW",{"$f":"IF(G10=\"Yes\",IF(O10,O10,C108*1000),0)","v":1283324.8207034676},{"$f":"VLOOKUP(C51,'Cost Curves S-PSH'!AO205:AQ206,3,FALSE)*IF(P10,P10,IF(AND(C46=\"Average\",C47=\"Underground\"),IF(C110<=80,IF(C109<=2,'Cost Curves S-PSH'!B11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!C11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!D11,IF(C109>4,'Cost Curves S-PSH'!E11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves S-PSH'!B53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!C53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!D53,IF(C109>4,'Cost Curves S-PSH'!E53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves S-PSH'!L53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!M53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!N53,IF(C109>4,'Cost Curves S-PSH'!O53)))),IF(C110>225,IF(C109<=2,'Cost Curves S-PSH'!L11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!M11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!N11,IF(C109>4,'Cost Curves S-PSH'!O11)))))))),IF(AND(C46=\"Adverse\",C47=\"Underground\"),IF(C110<=80,IF(C109<=2,'Cost Curves S-PSH'!F11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!G11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!H11,IF(C109>4,'Cost Curves S-PSH'!I11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves S-PSH'!F53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!G53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!H53,IF(C109>4,'Cost Curves S-PSH'!I53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves S-PSH'!P53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!Q53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!R53,IF(C109>4,'Cost Curves S-PSH'!S53)))),IF(C110>225,IF(C109<=2,'Cost Curves S-PSH'!P11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!Q11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!R11,IF(C109>4,'Cost Curves S-PSH'!S11)))))))),IF(AND(C46=\"Average\",C47=\"Surface\"),IF(C110<=80,IF(C109<=2,'Cost Curves S-PSH'!V11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!W11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!X11,IF(C109>4,'Cost Curves S-PSH'!Y11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves S-PSH'!V53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!W53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!X53,IF(C109>4,'Cost Curves S-PSH'!Y53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves S-PSH'!AF53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AG53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AH53,IF(C109>4,'Cost Curves S-PSH'!AI53)))),IF(C110>225,IF(C109<=2,'Cost Curves S-PSH'!AF11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AG11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AH11,IF(C109>4,'Cost Curves S-PSH'!AI11)))))))),IF(AND(C46=\"Adverse\",C47=\"Surface\"),IF(C110<=80,IF(C109<=2,'Cost Curves S-PSH'!Z11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AA11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AB11,IF(C109>4,'Cost Curves S-PSH'!AC11)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves S-PSH'!Z53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AA53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AB53,IF(C109>4,'Cost Curves S-PSH'!AC53)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves S-PSH'!AJ53,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AK53,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AL53,IF(C109>4,'Cost Curves S-PSH'!AM53)))),IF(C110>225,IF(C109<=2,'Cost Curves S-PSH'!AJ11,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AK11,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AL11,IF(C109>4,'Cost Curves S-PSH'!AM11)))))))))))))","v":39.0597787354559},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U61,1)","v":3.1330000000000005},{"$f":"'Market Adj Factors'!X61","v":1.0666666666666667},{"$f":"IF(P10,P10,J10*K10*L10*M10)","v":130.53257256339558},0,0,{"$f":"N10*I10","v":167515690.280882},{"$f":"Q10/$Q$53","v":6.0723736785376611E-2},{"$f":"R10","v":6.0723736785376611E-2},156806247.94734025]
[null,"Upper Reservoir Area",191,"acres"]
[null,"Avg. Max Lower Reservoir Depth",120,"feet",null,"Reservoirs, Dams, and Waterways"]
[null,"Lower Reservoir Area",163,"acres",null,"Upper Reservoir Dam and Spillway","Yes","CY",{"$f":"IF(G13=\"Yes\",IF(O13,O13,C86),0)","v":327938},{"$f":"'Cost Curves S-PSH'!J95","v":7.9166421358164936},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U62,1)","v":3.3740000000000001},{"$f":"'Market Adj Factors'!X62","v":1.0684326710816776},{"$f":"IF(P13,P13,J13*K13*L13*M13)","v":28.538638574089418},0,0,{"$f":"IF(C50=\"Earthfill\",N13*I13,IF(C50=\"Rockfill\",0.787*N13*I13+4,IF(C50=\"RCC\",11.389*N13*I13)))","v":106588558.30186717},{"$f":"Q13/$Q$53","v":3.8637906382397127E-2},{"$f":"SUM(R13:R17)","v":0.10559027392849302},74986382.093034193]
[null,"Nominal (Max) Head",1560,"feet",null,"Upper Reservoir Intake/Outlet","Yes","#",{"$f":"IF(G14=\"Yes\",IF(O14,O14,C96),0)","v":1},{"$f":"IF(C44=\"Horizontal\",'Cost Curves S-PSH'!P88,IF('Cost Model S-PSH'!C44=\"Vertical\",'Cost Curves S-PSH'!P91))*1000000","v":265517.75449898775},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",IF(C44=\"Horizontal\",'Market Adj Factors'!U63,'Market Adj Factors'!U63),1)","v":4.82},{"$f":"'Market Adj Factors'!X63","v":1.0419161676646707},{"$f":"IF(P14,P14,J14*K14*L14*M14)","v":1333439.7026539585},0,0,{"$f":"N14*I14","v":1333439.7026539585},{"$f":"Q14/$Q$53","v":4.8336631265621108E-4},null,7138076.3009107886]
[null,"Total Conveyance Length (vert+horiz)",14394,"feet",null,"Surge Facilities","Yes","LS",{"$f":"IF(G15=\"Yes\",IF(O15,O15,IF(C99=\"Yes\",40%,0%)),0)","v":0.4},"NA",null,null,null,"NA",0,"NA",{"$f":"I15*SUM(Q21:Q26)","v":114659277.63614839},{"$f":"Q15/$Q$53","v":4.1563508370496237E-2},null,103101433.5510007]
[null,"Avg. Upper Dam Height",120,"ft",null,"Lower Reservoir Intake/Outlet","Yes","#",{"$f":"IF(G16=\"Yes\",IF(C47=\"Underground\",IF(O16,O16,C96),0))","v":1},{"$f":"IF(C45=\"Horizontal\",'Cost Curves S-PSH'!P88,IF('Cost Model S-PSH'!C45=\"Vertical\",'Cost Curves S-PSH'!P91))*1000000","v":1621589.1081678574},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",IF(C45=\"Horizontal\",'Market Adj Factors'!U64,'Market Adj Factors'!U64),1)","v":3.1330000000000005},{"$f":"'Market Adj Factors'!X64","v":1.0419161676646707},{"$f":"IF(P16,P16,J16*K16*L16*M16)","v":5293391.1952385763},0,0,{"$f":"N16*I16","v":5293391.1952385763},{"$f":"Q16/$Q$53","v":1.9188321589621365E-3},null,21187166.38252807]
[null,"Upper Dam Crest Length",1300,"ft",null,"Lower Reservoir Dam and Spillway","Yes","CY",{"$f":"IF(G17=\"Yes\",IF(O17,O17,C87),0)","v":184954},{"$f":"'Cost Curves S-PSH'!J96","v":8.3508624157488018},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U62,1)","v":3.3740000000000001},{"$f":"'Market Adj Factors'!X62","v":1.0684326710816776},{"$f":"IF(P17,P17,J17*K17*L17*M17)","v":30.103955714605839},0,0,{"$f":"IF(C50=\"Earthfill\",N17*I17,IF(C50=\"Rockfill\",0.787*N17*I17+4,IF(C50=\"RCC\",11.389*N17*I17)))","v":63412209.77044934},{"$f":"Q17/$Q$53","v":2.2986660703981303E-2},null,15312121.918802328]
[null,"Avg. Lower Dam Height",60,"ft",null,"Upper & Lower Reservoir Liner","Yes","Sq.Ft",{"$f":"IF(G18=\"Yes\",IF(O18,O18,(SQRT(((C16^2)*(C17/2)^2)+((C16^2)*((2*C11*C26)/C17)^2)+(((C17/2)^2)*((2*C11*C26)/C17)^2))+SQRT(((C18^2)*(C19/2)^2)+((C18^2)*((2*C13*C26)/C19)^2)+(((C19/2)^2)*((2*C13*C26)/C19)^2)))),0)","v":15603360.593641452},{"$f":"IFERROR(VLOOKUP(C49,'Cost Curves S-PSH'!AE241:AG243,3,FALSE),0)","v":4.4444444444444446},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},1,1,{"$f":"IF(P18,P18,J18*K18*L18*M18)","v":4.4444444444444446},0,0,{"$f":"N18*I18","v":69348269.305073127},{"$f":"Q18/$Q$53","v":2.5138457446832189E-2},null,46260613.800000004,"liner"]
[null,"Lower Dam Crest Length",1100,"ft"]
[null,"Acreage to be acquired",2185,"acres",null,"Water Conductors"]
[null,"Generation Time",18.5,"hours",null,"Upper Low & High Pressure Tunnels","Yes","Ft",{"$f":"IF(G21=\"Yes\",IF(O21,O21,(C15-C92-I23/C109-I24/C109)*0.5),0)*$C$96","v":6293.25},{"$f":"IF(C34=\"Average\",IF(I21*C25<=0.5,'Cost Curves S-PSH'!V95,IF(AND(I21*C25>0.5,I21*C25<=1),'Cost Curves S-PSH'!W95,IF(AND(I21*C25>1,I21*C25<=2),'Cost Curves S-PSH'!X95,IF(I21*C25>2,'Cost Curves S-PSH'!Y95)))),IF(C34=\"Poor\",IF(I21*C25<=0.5,'Cost Curves S-PSH'!Z95,IF(AND(I21*C25>0.5,I21*C25<=1),'Cost Curves S-PSH'!AA95,IF(AND(I21*C25>1,I21*C25<=2),'Cost Curves S-PSH'!AB95,IF(I21*C25>2,'Cost Curves S-PSH'!AC95))))))","v":3667.2879327446549},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U67,1)","v":3.8560000000000003},{"$f":"'Market Adj Factors'!X67","v":1.0790513833992095},{"$f":"IF(P21,P21,J21*K21*L21*M21)","v":15258.932803735595},0,0,{"$f":"N21*I21","v":96028278.86710903},{"$f":"Q21/$Q$53","v":3.4809849275023799E-2},{"$f":"SUM(R21:R26)","v":0.10390877092624057},88504415.747787535]
[null,null,null,null,null,"Vertical Shafts","Yes","Ft",{"$f":"IF(G22=\"Yes\",IF(O22,O22,C92),0)*C96","v":1326},{"$f":"'Cost Curves S-PSH'!AI90","v":4761.6130899681739},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF(C54=\"Yes\",'Market Adj Factors'!U66,1)","v":4.3380000000000001},{"$f":"'Market Adj Factors'!X66","v":1.0790513833992095},22288.753282644146,0,0,29554886.852786139,1.0713522816644444E-2,null,27347886.617206737]
[null,"Unit Conversion Factors and Constants",null,null,null,"Penstock Tunnels","Yes","Ft",{"$f":"IF(G23=\"Yes\",IF(C48=\"Underground\",IF(O23,O23,C92*0.25),0))*$C$109","v":1326},{"$f":"IF(C14<=500,'Cost Curves S-PSH'!B131,IF(AND(C14>500,C14<=1000),'Cost Curves S-PSH'!C131,IF(AND(C14>1000,C14<=1500),'Cost Curves S-PSH'!D131,IF(C14>1500,'Cost Curves S-PSH'!E131))))","v":4825.8152305441936},{"$f":"VLOOKUP(C9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U67,1)","v":3.8560000000000003},{"$f":"'Market Adj Factors'!X67","v":1.0790513833992095},20079.35882771188,0,0,26625229.805545952,9.6515343956807519E-3,null,29256438.24280015]
[null,"Meter to Feet",3.28084,"feet",null,"Draft Tube Tunnels","Yes","Ft",{"$f":"IF(G24=\"Yes\",IF(C47=\"Underground\",IF(O24,O24,150),0))*$C$109","v":600},{"$f":"IF(C47=\"Underground\",IF(C14-C91<=500,'Cost Curves S-PSH'!B131,IF(AND(C14-C91>500,C14-C91<=1000),'Cost Curves S-PSH'!C131,IF(AND(C14-C91>1000,C14-C91<=1500),'Cost Curves S-PSH'!D131,IF(C14-C91>1500,'Cost Curves S-PSH'!E131)))),0)","v":2723.946698424043},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U69,1)","v":4.5789999999999997},{"$f":"'Market Adj Factors'!X69","v":1.0790513833992095},13458.95603738675,0,0,{"$f":"N24*I24","v":8075373.6224320503},2.9272891480786917E-3,null,24140427.521919746]
[null,"Feet to Miles",1.8939400000000001E-4,"miles",null,"Tailrace Tunnels","Yes","Ft",{"$f":"IF(G25=\"Yes\",IF(O25,O25,(C15-C92-I23/C109-I24/C109)*0.5),0)*$C$96","v":6293.25},{"$f":"IF(C47=\"Underground\",IF(C14<=500,'Cost Curves S-PSH'!B131,IF(AND(C14>500,C14<=1000),'Cost Curves S-PSH'!C131,IF(AND(C14>1000,C14<=1500),'Cost Curves S-PSH'!D131,IF(C14>1500,'Cost Curves S-PSH'!E131)))),0)","v":4825.8152305441936},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U67,1)","v":3.8560000000000003},{"$f":"'Market Adj Factors'!X67","v":1.0790513833992095},20079.35882771188,0,0,126364424.94249779,4.580657529081289E-2,null,88504415.747787535]
[null,"Ac. Ft to Cu. Ft",43559.9,"cu.ft",null,"Surface Penstock","Yes","Ft",{"$f":"IF(G26=\"Yes\",IF(O26,O26,IF( C48=\"Surface\",C109*C92*0.25,0)),0)","v":0},{"$f":"IF(OR(C107<100, C48=\"Surface\"),IF(C14<=300,'Cost Curves S-PSH'!L131,IF(AND(C14>300,C14<=500),'Cost Curves S-PSH'!M131,IF(AND(C14>500,C14<=700),'Cost Curves S-PSH'!N131,IF(AND(C14>700,C14<=1000),'Cost Curves S-PSH'!O131,IF(C14>1000,'Cost Curves S-PSH'!P131))))),0)","v":0},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",IF(C48=\"Surface\",'Market Adj Factors'!U65,'Market Adj Factors'!U68),1)","v":4.5789999999999997},{"$f":"IF(C48=\"Surface\",'Market Adj Factors'!X65,'Market Adj Factors'!X68)","v":1.0790513833992095},0,0,0,0,0,null,0]
[null,"Cu. Ft to Cu. Yd",1613.33,"CY"]
[null,"Hr to Sec",3600,"s",null,"Powerstation Equipment"]
[null,"MW to W",1000000,"W",null,"Pump/Motors","Yes","LS",{"$f":"IF(G29=\"Yes\",1,0)","v":1},{"$f":"VLOOKUP(C51,'Cost Curves S-PSH'!$AO$205:$AQ$206,2,FALSE)*IF(C107>100,0,'Cost Curves S-PSH'!D365)","v":0},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U72,1)","v":4.0970000000000004},{"$f":"'Market Adj Factors'!X72","v":1.0900692840646651},{"$f":"IF(P29,P29,J29*K29*L29*M29)","v":0},0,0,{"$f":"N29*I29","v":0},{"$f":"Q29/$Q$53","v":0},{"$f":"IF(AND(R29=0%,R30=0%),R31,IF(R31=0%,SUM(R29:R30)))","v":0.21443786031003706},0]
[null,"acceleration of gravity (metric)",9.81,"m/s^2",null,"Generator/Turbines","Yes","kW",{"$f":"IF(G30=\"Yes\",IF(C107<=100,IF(O30,O30,I10),0),0)","v":0},{"$f":"IF(C107>100,0,IF(C107<=100,'Cost Curves S-PSH'!E374,'Cost Curves S-PSH'!E378))","v":0},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U72,1)","v":4.0970000000000004},{"$f":"'Market Adj Factors'!X72","v":1.0900692840646651},0,0,0,{"$f":"N30*I30","v":0},{"$f":"Q30/$Q$53","v":0},null,0]
[null,"density of water (metric)",1000,"kg/m^2",null,"Total Powerstation","Yes","kW",{"$f":"IF(G31=\"Yes\",IF(C107>100,IF(O31,O31,C108*1000),0),0)","v":1283324.8207034676},{"$f":"VLOOKUP(C51,'Cost Curves S-PSH'!$AO$205:$AQ$206,2,FALSE)*IF(C107<=100,0,IF(C47=\"Underground\", IF(C110<=80,IF(C109<=2,'Cost Curves S-PSH'!B171,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!C171,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!D171,IF(C109>4,'Cost Curves S-PSH'!E171)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves S-PSH'!L171,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!M171,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!N171,IF(C109>4,'Cost Curves S-PSH'!O171)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves S-PSH'!V171,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!W171,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!X171,IF(C109>4,'Cost Curves S-PSH'!Y171)))),IF(C110>225,IF(C109<=2,'Cost Curves S-PSH'!AF171,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AG171,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AH171,IF(C109>4,'Cost Curves S-PSH'!AI171)))))))),IF(C47=\"Surface\", IF(C110<=80,IF(C109<=2,'Cost Curves S-PSH'!B213,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!C213,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!D213,IF(C109>4,'Cost Curves S-PSH'!E213)))),IF(AND(C110>80,C110<=125),IF(C109<=2,'Cost Curves S-PSH'!L213,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!M213,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!N213,IF(C109>4,'Cost Curves S-PSH'!O213)))),IF(AND(C110>125,C110<=225),IF(C109<=2,'Cost Curves S-PSH'!V213,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!W213,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!X213,IF(C109>4,'Cost Curves S-PSH'!Y213)))),IF(C110>225,IF(C109<=2,'Cost Curves S-PSH'!AF213,IF(AND(C109>2,C109<=3),'Cost Curves S-PSH'!AG213,IF(AND(C109>3,C109<=4),'Cost Curves S-PSH'!AH213,IF(C109>4,'Cost Curves S-PSH'!AI213)))))))))))","v":103.21475999999998},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U72,1)","v":4.0970000000000004},{"$f":"'Market Adj Factors'!X72","v":1.0900692840646651},{"$f":"IF(P31,P31,J31*K31*L31*M31)","v":460.95854838762119},0,0,{"$f":"N31*I31","v":591559546.46127462},{"$f":"Q31/$Q$53","v":0.21443786031003706},null,541852349.10358322]
[]
[null,"Condition Related",null,null,null,"Roads, Railroads, Bridges, and Access"]
[null,"Tunneling Condition","Average","#",null,"Access Roads","Yes","Miles",{"$f":"IF(G34=\"Yes\",IF(O34,O34,C38),0)","v":3.61},{"$f":"INDEX('Cost Curves S-PSH'!W241:X243,MATCH('Cost Model S-PSH'!C35,'Cost Curves S-PSH'!V241:V243,0),MATCH('Cost Model S-PSH'!C36,'Cost Curves S-PSH'!W240:X240,0))","v":189000},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U71,1)","v":2.41},{"$f":"'Market Adj Factors'!X71","v":1.0438311688311688},{"$f":"IF(P34,P34,J34*K34*L34*M34)","v":475454.65909090906},0,0,{"$f":"N34*I34","v":1716391.3193181816},{"$f":"Q34/$Q$53","v":6.2218467129987692E-4},{"$f":"SUM(R34:R36)","v":1.6679160355743305E-2},1641809.0457831325]
[null,"Access Road, Terrain","Flat","#",null,"Access Tunnels","Yes","Ft",{"$f":"IF(G35=\"Yes\",IF(C47=\"Surface\",0,IF(O35,O35,C39*5280)),0)","v":6600},{"$f":"IF(C47=\"Surface\",0,'Cost Curves S-PSH'!D242)","v":2555.8188374587603},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U70,1)","v":2.41},{"$f":"'Market Adj Factors'!X70","v":1.0790513833992095},{"$f":"IF(P35,P35,J35*K35*L35*M35)","v":6646.4422439890996},0,0,{"$f":"N35*I35","v":43866518.810328059},{"$f":"Q35/$Q$53","v":1.5901429516618458E-2},null,40590802.755968824]
[null,"Access Road, Type","New","#",null,"Highway Realignment","Yes","%",{"$f":"IF(G36=\"Yes\",IF(C37=\"Yes\",25%,0%),0)","v":0.25},null,null,null,null,null,0,"NA",{"$f":"Q34*I36","v":429097.8298295454},{"$f":"Q36/$Q$53","v":1.5554616782496923E-4},null,410452.26144578314]
[null,"Highway Realignment","Yes","#"]
[null,"Access Road",3.61,"miles",null,"Switchyard","Yes","LS",{"$f":"IF(G38=\"Yes\",1,0)","v":1},{"$f":"'Cost Curves S-PSH'!Q248*1000000","v":16726800},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U74,1)","v":2.41},{"$f":"'Market Adj Factors'!X74","v":1.0634249471458774},{"$f":"IF(P38,P38,J38*K38*L38*M38)","v":42868348.338266388},0,0,{"$f":"N38*I38","v":42868348.338266388},{"$f":"Q38/$Q$53","v":1.5539596897173822E-2},{"$f":"R38","v":1.5539596897173822E-2},40250057.229338408]
[null,"Access Tunnel, Length",1.25,"miles"]
[null,"Water Supply =","No","#",null,"Transmission Lines","Yes","Miles",{"$f":"IF(G40=\"Yes\",C64,0)","v":13.5},{"$f":"'Cost Curves S-PSH'!G303*1000*C120*C121","v":1150309.0889322748},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},{"$f":"IF($C$54=\"Yes\",'Market Adj Factors'!U73,1)","v":3.1330000000000005},{"$f":"'Market Adj Factors'!X73","v":1.0504385964912282},{"$f":"IF(P40,P40,J40*K40*L40*M40)","v":3785694.9603602802},0,0,{"$f":"N40*I40","v":51106881.964863785},{"$f":"Q40/$Q$53","v":1.8526030864046653E-2},{"$f":"R40","v":1.8526030864046653E-2},48578635.297828086]
[null,"Water Supply Cost = ",100,"$/ac-ft"]
[null,null,null,null,null,"Others"]
[null,"Technology Related",null,null,null,"Water Supply","Yes","ac-ft",{"$f":"IF(G43=\"Yes\",IF(C40=\"Yes\",C88,0),0)","v":0},{"$f":"C41","v":100},{"$f":"VLOOKUP($C$9,'Locational Adj Factors'!$A$3:$B$55,2,FALSE)/100","v":1},1,1,{"$f":"IF(P43,P43,J43*K43*L43*M43)","v":100},0,0,{"$f":"N43*I43","v":0},{"$f":"Q43/$Q$53","v":0},{"$f":"SUM(R43:R44)","v":0},0]
[null,"U. Reservoir Intake/Outlet","Vertical","#"]
[null,"L. Reservoir Intake/Outlet","Horizontal","#",null,"Indirect Costs"]
[null,"Power Station Structure Geology","Adverse","#",null,"Mobilization/Demobilization","Yes","%",{"$f":"IF(G46=\"Yes\",IF(O46,O46,C55),0)","v":0.05},null,null,null,null,null,0,"NA",{"$f":"I46*SUM(Q8:Q43)","v":77708522.049230129},{"$f":"Q46/$Q$53","v":2.8169014084507046E-2},{"$f":"SUM(R46:R51)","v":0.43661971830985918},68606694.883117169]
[null,"Power Station","Underground","#",null,"Sales Tax","Yes","%",{"$f":"IF(G47=\"Yes\",IF(O47,O47,C57),0)","v":0.06},null,null,null,null,null,0,"NA",{"$f":"I47*C56*SUM(Q8:Q43)","v":69937669.84430711},2.5352112676056339E-2,null,82328033.8597406]
[null,"Penstock","Underground","#",null,"Contingency","Yes","%",{"$f":"IF(G48=\"Yes\",IF(O48,O48,C58),0)","v":0.33},null,null,null,null,null,0,"NA",{"$f":"SUM(Q8:Q43)*I48","v":512876245.52491885},0.18591549295774651,null,452804186.22857332]
[null,"Reservoir Liner","Geomembrane Single Liner","#",null,"EPC Cost","Yes","%",{"$f":"IF(G49=\"Yes\",IF(O49,O49,C59),0)","v":0.25},null,null,null,null,null,0,"NA",{"$f":"I49*SUM(Q8:Q43)","v":388542610.24615061},0.14084507042253522,null,343033474.41558582]
[null,"Dam Type","RCC","#",null,"Developer Cost","Yes","%",{"$f":"IF(G50=\"Yes\",IF(O50,O50,C60),0)","v":0.03},null,null,null,null,null,0,"NA",{"$f":"SUM(Q8:Q43)*I50","v":46625113.229538068},1.6901408450704224E-2,null,41164016.9298703]
[null,"Pump Type","Fixed","#",null,"Overhead & Profit","Yes","%",{"$f":"IF(G51=\"Yes\",IF(O51,O51,C61),0)","v":7.0000000000000007E-2},null,null,null,null,null,0,"NA",{"$f":"SUM(Q8:Q43)*I51","v":108791930.86892219},3.9436619718309869E-2,null,96049372.836364031]
[]
[null,"Project Related",null,null,null,"Total Direct and Indirect Cost",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q8:Q51)","v":2758652532.7476692},{"$f":"SUM(R8:R51)","v":1},{"$f":"SUM(S8:S51)","v":0.97486154255316793},2456119676.8155947]
[null,"Inflation Factor","Yes","#"]
[null,"Mobilization/Demobilization =",0.05,"%",null,"System Cost"]
[null,"Material/Equipment % =",0.75,"%",null,"Total Direct and Indirect Cost $",{"$f":"Q53","v":2758652532.7476692}]
[null,"Sales Tax =",0.06,"%",null,"$/kW (Max. Power Capacity)",{"$f":"G56/(C108*1000)","v":2149.6136350230377}]
[null,"Contingency =",0.33,"%",null,"$/kWh (Max. Energy Capacity)",{"$f":"G56/(C108*C21*1000)","v":116.1953316228669}]
[null,"EPC Cost =",0.25,"%"]
[null,"Developer Cost =",0.03,"%"]
[null,"Overhead & Profit =",7.0000000000000007E-2,"%"]
[]
[null,"Transmission Related"]
[null,"Transmission Distance =",13.5,"miles"]
[null,"Transmission =",500,"kV"]
[null,"Substation =",500,"kV"]
[null,"Transmission Terrain = ","Mountain","#"]
[null,"Transmission Type (# circuits) =","Double","#"]
[]
[null,"Project Related"]
[null,"Active Storage =",0.85,"x Gross Storage"]
[null,"Hmin/Hmax =",0.7,"#"]
[null,"Hazen Williams C =",90,"#"]
[null,"P-T Efficiency =",0.88,"%"]
[null,"Max Tunnel Velocity =",23,"fps"]
[null,"Max Tunnel Dia =",35,"feet"]
[null,"Max Unit Capacity =",350,"MW"]
[null,"Min No. Units =",2,"#"]
[null,"Pump Time =",{"$f":"12/10","v":1.2},"x gen time"]
[]
[null,"Output Specifications"]
[null,"Project Related"]
[null,"Conveyance Length",{"$f":"C15*C25","v":2.726137236},"miles"]
[null,"Avg. Upper Reservoir Volume =",{"$f":"C11*C10","v":19291},"ac-ft"]
[null,"Avg. Lower Reservoir Volume =",{"$f":"C13*C12","v":19560},"ac-ft"]
[null,"Avg. Upper Dam Volume =",{"$f":"IF(C50=\"Rockfill\",'Cost Curves S-PSH'!AA284,IF(C50=\"Earthfill\",'Cost Curves S-PSH'!Z293,IF(C50=\"RCC\",'Cost Curves S-PSH'!AB284)))","v":327938},"CY"]
[null,"Avg. Lower Dam Volume =",{"$f":"IF(C50=\"Rockfill\",'Cost Curves S-PSH'!AA285,IF(C50=\"Earthfill\",'Cost Curves S-PSH'!AB293,IF(C50=\"RCC\",'Cost Curves S-PSH'!AB285)))","v":184954},"CY"]
[null,"Active Storage =",{"$f":"C71*C84","v":16397.349999999999},"ac-ft"]
[null,"Energy Storage =",{"$f":"C107*C21","v":18593.071424433329},"MWh"]
[null,"Mean Gen Discharge =",{"$f":"C88*C26/C21/C28","v":10724.728622597597},"cfs"]
[null,"Min Gross Head =",{"$f":"C72*C14","v":1092},"feet"]
[null,"Mean Gross Head =",{"$f":"(C91+C14)/2","v":1326},"feet"]
[null,"Min Gen Discharge =",{"$f":"(C91/C$92)^0.5*C$90","v":9732.5326381559316},"cfs"]
[null,"Max Gen Discharge =",{"$f":"(C14/C$92)^0.5*C$90","v":11632.601450404713},"cfs"]
[null,"Nominal Tunnel Dia =",{"$f":"((C94/C75)*4/PI())^0.5","v":25.376373961345202},"feet"]
[null,"No. Tunnels =",{"$f":"IF(C95<C76,1,2)","v":1},"#"]
[null,"Adjusted Tunnel Dia =",{"$f":"((C94/C96/C75)*4/PI())^0.5","v":25.376373961345202},"feet"]
[null,"L/H =",{"$f":"C15/C92","v":10.855203619909503},"#"]
[null,"Surge Chambers",{"$f":"IF(C98>=7,\"Yes\",\"No\")","v":"Yes"},"#"]
[null,"Min Gen Headloss =",{"$f":"4.73*C93^1.85/C$73^1.85/C$97^4.87*C$15","v":57.061064442997058},"feet"]
[null,"Mean Gen Headloss =",{"$f":"4.73*C90^1.85/C$73^1.85/C$97^4.87*C$15","v":68.286788451324824},"feet"]
[null,"Max Gen Headloss =",{"$f":"4.73*C94^1.85/C$73^1.85/C$97^4.87*C$15","v":79.364115762348916},"feet"]
[null,"Net Head @ Min Gen Discharge =",{"$f":"C91-C100","v":1034.9389355570029},"feet"]
[null,"Net Head @ Mean Gen Discharge =",{"$f":"C92-C101","v":1257.7132115486752},"feet"]
[null,"Net Head @ Max Gen Discharge =",{"$f":"C$14-C102","v":1480.635884237651},"feet"]
[null,"Min Plant Gen Power (Firm Capacity) =",{"$f":"C93*C103*C$74*$C$30*$C$31/$C$29*(1/C24)^4","v":750.5023722078306},"MW"]
[null,"Mean Plant Gen Power =",{"$f":"C90*C104*C$74*$C$30*$C$31/$C$29*(1/C24)^4","v":1005.030887807207},"MW"]
[null,"Max Plant Gen Power =",{"$f":"C94*C105*C$74*$C$30*$C$31/$C$29*(1/C24)^4","v":1283.3248207034676},"MW"]
[null,"No. Units =",{"$f":"IF(C108/C77<=C78,C78,ROUNDUP(C108/C77,0))","v":4},"#"]
[null,"Unit Rating =",{"$f":"C108/C109","v":320.8312051758669},"MW"]
[null,"Max Penstock Velocity =",{"$f":"'Cost Curves S-PSH'!V130","v":28.056000000000001},"fps"]
[null,"Max DraftTube Velocity =",{"$f":"'Cost Curves S-PSH'!AA130","v":9.6688000000000009},"fps"]
[null,"Penstock Dia =",{"$f":"((C94/(C111*C109))*4/PI())^0.5","v":11.488163599886885},"feet"]
[null,"Draft Tube Tunnel Dia =",{"$f":"((C94/(C112*C109))*4/PI())^0.5","v":19.569385997752452},"feet"]
[null,"Pump Time =",{"$f":"C79*C21","v":22.2},"hrs"]
[null,"Mean Pump Discharge =",{"$f":"C88*C26/C115/3600","v":8937.2738521646643},"cfs"]
[null,"Mean Pump Headloss =",{"$f":"4.73*C116^1.85/C73^1.85/C97^4.87*C15","v":48.736168480135696},"feet"]
[null,"Mean Pump Net Head =",{"$f":"C92+C117","v":1374.7361684801358},"feet"]
[null,"Mean Pump Power =",{"$f":"C116*C118*C74*$C$30*$C$31/$C$29*(1/C24)^4","v":915.45267714289605},"MW"]
[null,"Tranmission Terrain Multiplier = ",{"$f":"VLOOKUP(C67,'Cost Curves S-PSH'!H276:I284,2,FALSE)","v":1.75},"#"]
[null,"Tranmission Type Multiplier =",{"$f":"IF(C68=\"Double\",'Cost Curves S-PSH'!I287,1)","v":1.6004696290247125},"#"]

{"sheet":"Cost Curves S-PSH","index":4,"n_rows":378,"n_cols":43,"rows_kept":378,"cut":false,"hidden":false,"merged":[[290,26,290,27],[290,24,290,25],[0,1,0,7],[0,11,0,17],[0,21,0,27],[42,1,42,7],[42,11,42,17],[42,21,42,27],[85,21,85,24],[85,25,85,28],[0,31,0,37],[1,1,1,4],[1,5,1,8],[1,11,1,14],[1,15,1,18],[1,21,1,24],[1,25,1,28],[1,31,1,34],[1,35,1,38],[42,31,42,37],[43,31,43,34],[43,35,43,38],[84,0,84,2],[84,21,84,27],[43,1,43,4],[43,5,43,8],[43,11,43,14],[43,15,43,18],[43,21,43,24],[43,25,43,28]]}
[null,"Underground Powestation Structure Cost 80MW units",null,null,null,null,null,null,null,null,null,"Underground Powestation Structure Cost 350MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 80MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 350MW units"]
[null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions"]
["Average Head, Ft","160 MW","240 MW","320 MW","480 MW","160 MW","240 MW","320 MW","480 MW",null,"Average Head, Ft","700 MW","1050 MW","1400 MW","2100 MW","700 MW","1050 MW","1400 MW","2100 MW",null,"Average Head, Ft","160 MW","240 MW","320 MW","480 MW","160 MW","240 MW","320 MW","480 MW",null,"Average Head, Ft","700 MW","1050 MW","1400 MW","2100 MW","700 MW","1050 MW","1400 MW","2100 MW"]
[350,135,116,104,92,174,145,132,118,null,500,78,70,62,58,98,84,78,70,null,350,84,77,72.5,67,112,95,87,78,null,350,38,35,32,30,58,48.5,45,39]
[500,113,96,86,78,150,124,113.5,102,null,1000,48,42,37,33,62,52,46,42.25,null,500,84,77.25,74,68,113.5,96,89,79.5,null,500,36,34,30,28,54,45,42,37]
[1000,91,76,68,60,116,98,86,76.5,null,1500,40.5,34,30,26,53,43,39,34.5,null,1000,87,80,76,74,118,102,93,85,null,1000,31,28,26,25,45,40,37,34]
[1500,81,69,59.5,54,103,88,77,68.5,null,2000,36,31,26,24,45,39,34.5,26,null,1500,92.5,86,84,80,125,108,100,91.5,null,1500,30,27,26,25.25,44.5,39,36,32]
[2000,78,63,58,50,98,82,72,62.5,null,2250,35,30,25,23,44,38,33.5,25,null,2000,102,95,92,87,134,116,106,98,null,2000,32,30,29,26,46,41,38,34]
[2250,77,62,57,49,97,81,71,62,null,null,null,null,null,null,null,null,null,null,null,2250,105.5,98,95,90,137,119,109.5,100,null,2250,33,31,30,28,48,42,39.5,35]
[null,"y = 740.12x-0.298","y = 760.42x-0.328","y = 645.72x-0.32","y = 640.28x-0.337","y = 1096.7x-0.319","y = 878.1x-0.313","y = 926.99x-0.337","y = 911.22x-0.352",null,null,"y = 2032.8x-0.532","y = 2231.2x-0.565","y = 2553x-0.604","y = 2504.2x-0.615","y = 2613x-0.533","y = 2154.7x-0.53","y = 2380.6x-0.559","y = 4996.8x-0.687",null,null,"y = 5E-06x2 - 0.0009x + 83.095","y = 4E-06x2 + 0.0004x + 75.715","y = 4E-06x2 + 0.0021x + 71.437","y = 6E-07x2 + 0.0109x + 62.383","y = 3E-06x2 + 0.0062x + 109.48","y = 1E-06x2 + 0.0099x + 90.767","y = 2E-06x2 + 0.0073x + 84.676","y = -1E-07x2 + 0.0123x + 73.167",null,null,"y = 6E-06x2 - 0.0183x + 43.547","y = 7E-06x2 - 0.0198x + 41.489","y = 6E-06x2 - 0.0162x + 36.672","y = 5E-06x2 - 0.0128x + 33.573","y = 1E-05x2 - 0.0308x + 67.023","y = 7E-06x2 - 0.0207x + 54.238","y = 7E-06x2 - 0.0205x + 50.886","y = 5E-06x2 - 0.0146x + 43.361"]
["Est. $/kW",{"$f":"740.12*('Cost Model S-PSH'!C14)^-0.298","v":82.746762311021598},{"$f":"760.42*('Cost Model S-PSH'!C14)^-0.328","v":68.188111490618297},{"$f":"645.72*('Cost Model S-PSH'!C14)^-0.32","v":61.410745084071252},{"$f":"640.28*('Cost Model S-PSH'!C14)^-0.337","v":53.738674073702647},{"$f":"1096.7*('Cost Model S-PSH'!C14)^-0.319","v":105.0705720118597},{"$f":"878.1*('Cost Model S-PSH'!C14)^-0.313","v":87.921679982121006},{"$f":"926.99*('Cost Model S-PSH'!C14)^-0.337","v":77.802232585090309},{"$f":"911.22*('Cost Model S-PSH'!C14)^-0.352","v":68.492557770829762},null,"Est. $/kW",{"$f":"2032.8*('Cost Model S-PSH'!C14)^-0.532","v":40.677323160852637},{"$f":"2231.2*('Cost Model S-PSH'!C14)^-0.565","v":35.028626061587921},{"$f":"2553*('Cost Model S-PSH'!C14)^-0.604","v":30.088709228442831},{"$f":"2504.2*('Cost Model S-PSH'!C14)^-0.615","v":27.220580536976755},{"$f":"2613*('Cost Model S-PSH'!C14)^-0.533","v":51.904378931613238},{"$f":"2154.7*('Cost Model S-PSH'!C14)^-0.53","v":43.755310950094469},{"$f":"2380.6*('Cost Model S-PSH'!C14)^-0.559","v":39.0597787354559},{"$f":"4996.8*('Cost Model S-PSH'!C14)^-0.687","v":31.990083068542301},null,"Est. $/kW",{"$f":"0.000005*('Cost Model S-PSH'!C14)^2 - 0.0009*('Cost Model S-PSH'!C14) + 83.095","v":93.858999999999995},{"$f":"0.000004*('Cost Model S-PSH'!C14)^2 + 0.0004*('Cost Model S-PSH'!C14) + 75.715","v":86.073400000000007},{"$f":"0.000004*('Cost Model S-PSH'!C14)^2 + 0.0021*('Cost Model S-PSH'!C14) + 71.437","v":84.447400000000002},{"$f":"0.0000006*('Cost Model S-PSH'!C14)^2 + 0.0109*('Cost Model S-PSH'!C14) + 62.383","v":80.847160000000002},{"$f":"0.000003*('Cost Model S-PSH'!C14)^2 + 0.0062*('Cost Model S-PSH'!C14) + 109.48","v":126.4528},{"$f":"0.000001*('Cost Model S-PSH'!C14)^2 + 0.0099*('Cost Model S-PSH'!C14) + 90.767","v":108.6446},{"$f":"0.000002*('Cost Model S-PSH'!C14)^2 + 0.0073*('Cost Model S-PSH'!C14) + 84.676","v":100.9312},{"$f":"-0.0000001*('Cost Model S-PSH'!C14)^2 + 0.0123*('Cost Model S-PSH'!C14) + 73.167","v":92.111639999999994},null,"Est. $/kW",{"$f":"0.000006*('Cost Model S-PSH'!C14)^2 - 0.0183*('Cost Model S-PSH'!C14) + 43.547","v":29.600599999999996},{"$f":"0.000007*('Cost Model S-PSH'!C14)^2 - 0.0198*('Cost Model S-PSH'!C14) + 41.489","v":27.636199999999995},{"$f":"0.000006*('Cost Model S-PSH'!C14)^2 - 0.0162*('Cost Model S-PSH'!C14) + 36.672","v":26.0016},{"$f":"0.000005*('Cost Model S-PSH'!C14)^2 - 0.0128*('Cost Model S-PSH'!C14) + 33.573","v":25.773000000000003},{"$f":"0.00001*('Cost Model S-PSH'!C14)^2 - 0.0308*('Cost Model S-PSH'!C14) + 67.023","v":43.310999999999993},{"$f":"0.000007*('Cost Model S-PSH'!C14)^2 - 0.0207*('Cost Model S-PSH'!C14) + 54.238","v":38.981200000000001},{"$f":"0.000007*('Cost Model S-PSH'!C14)^2 - 0.0205*('Cost Model S-PSH'!C14) + 50.886","v":35.941200000000002},{"$f":"0.000005*('Cost Model S-PSH'!C14)^2 - 0.0146*('Cost Model S-PSH'!C14) + 43.361","v":32.753}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Underground Powestation Structure Cost 125MW units",null,null,null,null,null,null,null,null,null,"Underground Powestation Structure Cost 225MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 125MW units",null,null,null,null,null,null,null,null,null,"Surface Powestation Structure Cost 225MW units"]
[null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions",null,null,null,null,null,"$/kW Average Conditions",null,null,null,"$/kW Adverse Conditions"]
["Average Head, Ft","250 MW","375 MW","500 MW","750 MW","250 MW","375 MW","500 MW","750 MW",null,"Average Head, Ft","450 MW","675 MW","900 MW","1350 MW","450 MW","675 MW","900 MW","1350 MW",null,"Average Head, Ft","250 MW","375 MW","500 MW","750 MW","250 MW","375 MW","500 MW","750 MW",null,"Average Head, Ft","450 MW","675 MW","900 MW","1350 MW","450 MW","675 MW","900 MW","1350 MW"]
[350,123,108,97,90,158,134,122,112,null,350,116,100,92,83,148,126,116,104,null,350,63,56,52,48,92,75.5,70,64,null,350,50,44,41,38,73,61.5,56,50]
[500,95,83,75,68,120,103,96,86,null,500,95,80,73,64,116,100,94,83,null,500,62,55,52,48,90,76,71,64,null,500,46,41.5,38,36,70,59,55,48]
[1000,69,58,52,48,87,74,66,58,null,1000,59,52,44,40,74,64,55,52,null,1000,60,54,53,49,90,78,74,66,null,1000,42,37,36,34.5,64,55.5,51,46]
[1500,63,54,46,41,79,69,62,56,null,1500,46,41,36,32,60,50,44,40,null,1500,62,56,54.5,53,94,82,75.5,69,null,1500,44,40,37.5,36,62,55,50,47]
[2000,58,50,44,39,76,64,56,52,null,2000,45,38.75,34,30,56,48,43,38,null,2000,66,64,59,56,98,85,80,74,null,2000,45,43,40,38,64,56,53,49]
[2250,56,49,43,38,74,62,54,51,null,2250,45,38.5,33.75,29.5,57,48,43,38.5,null,2250,71,66,63,60,101,89,83,75,null,2250,46,44,41,38.5,66,58,55,50]
[null,"y = 1229.6x-0.405","y = 1113.2x-0.412","y = 1126.8x-0.431","y = 1195.5x-0.454","y = 1435.5x-0.392","y = 1258x-0.396","y = 1375x-0.424","y = 1131x-0.41",null,null,"y = 2163.3x-0.512","y = 1725.2x-0.501","y = 1735.2x-0.52","y = 1578.2x-0.524","y = 2315.8x-0.49","y = 2194.6x-0.505","y = 2353.1x-0.53","y = 2162.4x-0.533",null,null,"y = 7E-06x2 - 0.0146x + 67.574","y = 7E-06x2 - 0.0117x + 59.042","y = 5E-06x2 - 0.0065x + 54.377","y = 3E-06x2 - 0.0018x + 48.04","y = 4E-06x2 - 0.0039x + 90.761","y = 2E-06x2 + 0.0008x + 75.02","y = 2E-06x2 + 0.0002x + 70.655","y = 2E-06x2 + 0.002x + 62.446",null,null,"y = 6E-06x2 - 0.0159x + 53.593","y = 6E-06x2 - 0.0157x + 47.989","y = 5E-06x2 - 0.0116x + 43.522","y = 3E-06x2 - 0.0078x + 39.647","y = 8E-06x2 - 0.0241x + 80.261","y = 5E-06x2 - 0.0155x + 65.884","y = 6E-06x2 - 0.0165x + 61.35","y = 4E-06x2 - 0.0099x + 52.44"]
["Est. $/kW",{"$f":"1229.6*('Cost Model S-PSH'!C14)^-0.405","v":62.596260921003555},{"$f":"1113.2*('Cost Model S-PSH'!C14)^-0.412","v":53.827704941124054},{"$f":"1126.8*('Cost Model S-PSH'!C14)^-0.431","v":47.381645207458376},{"$f":"1195.5*('Cost Model S-PSH'!C14)^-0.454","v":42.449346896086169},{"$f":"1435.5*('Cost Model S-PSH'!C14)^-0.392","v":80.407832312764114},{"$f":"1258*('Cost Model S-PSH'!C14)^-0.396","v":68.423187215662807},{"$f":"1375*('Cost Model S-PSH'!C14)^-0.424","v":60.872041680483129},{"$f":"1131*('Cost Model S-PSH'!C14)^-0.41","v":55.498535055978614},null,"Est. $/kW",{"$f":"2163.3*('Cost Model S-PSH'!C14)^-0.512","v":50.146076159649688},{"$f":"1725.2*('Cost Model S-PSH'!C14)^-0.501","v":43.359476059148129},{"$f":"1735.2*('Cost Model S-PSH'!C14)^-0.52","v":37.924926507163271},{"$f":"1578.2*('Cost Model S-PSH'!C14)^-0.524","v":33.493825203543473},{"$f":"2315.8*('Cost Model S-PSH'!C14)^-0.49","v":63.105904575527866},{"$f":"2194.6*('Cost Model S-PSH'!C14)^-0.505","v":53.558382518354051},{"$f":"2353.1*('Cost Model S-PSH'!C14)^-0.53","v":47.784202996550476},{"$f":"2162.4*('Cost Model S-PSH'!C14)^-0.533","v":42.953704172108864},null,"Est. $/kW",{"$f":"0.000007*('Cost Model S-PSH'!C14)^2 - 0.0146*('Cost Model S-PSH'!C14) + 67.574","v":61.833199999999998},{"$f":"0.000007*('Cost Model S-PSH'!C14)^2 - 0.0117*('Cost Model S-PSH'!C14) + 59.042","v":57.825200000000002},{"$f":"0.000005*('Cost Model S-PSH'!C14)^2 - 0.0065*('Cost Model S-PSH'!C14) + 54.377","v":56.405000000000001},{"$f":"0.000003*('Cost Model S-PSH'!C14)^2 - 0.0018*('Cost Model S-PSH'!C14) + 48.04","v":52.532800000000002},{"$f":"0.000004*('Cost Model S-PSH'!C14)^2 - 0.0039*('Cost Model S-PSH'!C14) + 90.761","v":94.4114},{"$f":"0.000002*('Cost Model S-PSH'!C14)^2 + 0.0008*('Cost Model S-PSH'!C14) + 75.02","v":81.135199999999998},{"$f":"0.000002*('Cost Model S-PSH'!C14)^2 + 0.0002*('Cost Model S-PSH'!C14) + 70.655","v":75.834199999999996},{"$f":"0.000002*('Cost Model S-PSH'!C14)^2 + 0.002*('Cost Model S-PSH'!C14)+ 62.446","v":70.433199999999999},null,"Est. $/kW",{"$f":"0.000006*('Cost Model S-PSH'!C14)^2 - 0.0159*('Cost Model S-PSH'!C14) + 53.593","v":43.390600000000006},{"$f":"0.000006*('Cost Model S-PSH'!C14)^2 - 0.0157*('Cost Model S-PSH'!C14) + 47.989","v":38.098600000000005},{"$f":"0.000005*('Cost Model S-PSH'!C14)^2 - 0.0116*('Cost Model S-PSH'!C14)+ 43.522","v":37.594000000000001},{"$f":"0.000003*('Cost Model S-PSH'!C14)^2 - 0.0078*('Cost Model S-PSH'!C14) + 39.647","v":34.779800000000002},{"$f":"0.000008*('Cost Model S-PSH'!C14)^2 - 0.0241*('Cost Model S-PSH'!C14)+ 80.261","v":62.133799999999994},{"$f":"0.000005*('Cost Model S-PSH'!C14)^2 - 0.0155*('Cost Model S-PSH'!C14) + 65.884","v":53.872},{"$f":"0.000006*('Cost Model S-PSH'!C14)^2 - 0.0165*('Cost Model S-PSH'!C14) + 61.35","v":50.211600000000004},{"$f":"0.000004*('Cost Model S-PSH'!C14)^2 - 0.0099*('Cost Model S-PSH'!C14) + 52.44","v":46.730399999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Embankment Structure Cost $/CY",null,null,null,null,null,null,null,null,null,"Cost of Intakes/Outlets $M",null,null,null,null,null,null,null,null,null,null,"Cost of concrete lined water conductors",null,null,null,null,null,null,null,null,"Cost of Vertical Shafts $/LF"]
["Average Dam Height, Ft","Unit Volume CY/FT * 1000",null,"Total Dam Volume (CY x 10^6)","Unit Cost $/CY","1/x","1/y","hyperbolic fit",null,null,"Water Conductor Diameter, Ft","Horizontal Intake","Vertical Intake",null,null,null,null,null,null,null,null,"$/LF Average Tunneling Conditions",null,null,null,"$/LF Poor Tunneling Conditions",null,null,null,null,"Shaft Diameter, Ft","$/LF"]
[25,0.2,null,0.114,13.5,{"$f":"1/D87","v":8.7719298245614024},{"$f":"1/E87","v":7.407407407407407E-2},{"$f":"($H$98*D87)/($H$96+D87)","v":13.720565586723607},null,null,10,1.3,0.2,null,null,"0.0154x2 - 0.1968x + 1.85",null,null,null,null,"Inside Diameter, Ft","1/2 Mile","1 Mile","2 Mile","4 Mile","1/2 Mile","1 Mile","2 Mile","4 Mile",null,10,1950]
[50,0.5,null,1,9,{"$f":"1/D88","v":1},0.1111111111111111,8.1565266080742109,null,null,15,2.5,0.45,null,"horizontal",{"$f":"0.0154*('Cost Model S-PSH'!C113)^2 - 0.1968*'Cost Model S-PSH'!C113 + 1.85","v":1.6215891081678575},null,null,null,null,10,1000,1200,1300,1400,1400,1500,1550,1600,null,15,2800]
[100,1.4,null,2,8,0.5,0.125,7.9491405953633016,null,null,20,4.2,0.9,null,null,null,null,null,null,null,15,1500,1700,1800,1900,2200,2400,2500,2600,null,20,3700,null,null,"186.57x + 27.143"]
[150,2.7,null,4,7.8,0.25,0.12820512820512822,7.8493526569366407,null,null,25,6.4,1.3,null,null,"0.0046x2 - 0.0819x + 0.5993",null,null,null,null,20,2200,2400,2500,2700,3200,3450,3600,3900,null,25,4700,null,"$/lf",{"$f":"186.57*'Cost Model S-PSH'!C97 + 27.143","v":4761.6130899681739}]
[200,4.4000000000000004,null,6,7.7,0.16666666666666666,0.12987012987012986,7.8166444321108628,null,null,30,9.6,2.2999999999999998,null,"vertical",{"$f":"0.0046*('Cost Model S-PSH'!C113)^2 - 0.0819*'Cost Model S-PSH'!C113 + 0.5993","v":0.26551775449898773},null,null,null,null,25,3200,3400,3550,3900,4600,4900,5200,5600,null,30,5600]
[250,6.7,null,8,7.6,0.125,0.13157894736842105,7.8003923284559873,null,null,35,13.9,3.4,null,null,null,null,null,null,null,30,4400,4550,4975,5450,6500,6700,7400,8100,null,35,6600]
[300,9.4,null,10,7.5,0.1,0.13333333333333333,7.7906734650387177,null,null,null,null,null,null,null,null,null,null,null,null,35,5600,5900,6450,7500,8450,8750,9350,11250]
[350,12.5,null,null,null,null,null,"y = (7.75204x)/(x - 0.049591)",null,null,null,null,null,null,null,null,null,null,null,null,null,"3.9286x2 + 10.071x + 481.43","4.3214x2 - 5.6071x + 815","5.5536x2 - 42.339x + 1165.4","7.6786x2 - 103.54x + 1690.7","6.6786x2 - 17.393x + 915","6.25x2 + 7.8929x + 819.29","6.7143x2 + 13.857x + 732.86","11.107x2 - 120.11x + 1777.9"]
[null,null,"Upper Dam",null,"Lower Dam",null,"slope->",{"$f":"SLOPE(G87:G93,F87:F93)","v":-6.3971129931087774E-3},"$/CY Upper",{"$f":" (7.75204*C98)/(C98 - 0.049591)","v":7.9166421358164936},null,null,null,null,null,null,null,null,null,null,null,{"$f":"3.9286*('Cost Model S-PSH'!C97)^2 + 10.071*('Cost Model S-PSH'!C97) + 481.43","v":3266.8581144914433},{"$f":"4.3214*('Cost Model S-PSH'!C97)^2 - 5.6071*('Cost Model S-PSH'!C97) + 815","v":3455.5224134994251},{"$f":"5.5536*('Cost Model S-PSH'!C97)^2 - 42.339*'Cost Model S-PSH'!C97 + 1165.4","v":3667.2879327446549},{"$f":"7.6786*('Cost Model S-PSH'!C97)^2 - 103.54*'Cost Model S-PSH'!C97 + 1690.7","v":4007.9442252166991},{"$f":"6.6786*('Cost Model S-PSH'!C97)^2 - 17.393*'Cost Model S-PSH'!C97 + 915","v":4774.3823574386661},{"$f":"6.25*('Cost Model S-PSH'!C97)^2 + 7.8929*'Cost Model S-PSH'!C97 + 819.29","v":5044.3354034522436},{"$f":"6.7143*('Cost Model S-PSH'!C97)^2 + 13.857*'Cost Model S-PSH'!C97 + 732.86","v":5408.2434284194123},{"$f":"11.107*('Cost Model S-PSH'!C97)^2 - 120.11*'Cost Model S-PSH'!C97 + 1777.9","v":5882.4113912198391}]
[null,"U.Unit Volume CY/Ft",{"$f":"(0.00009*('Cost Model S-PSH'!C16)^2 + 0.0039*'Cost Model S-PSH'!C16 + 0.0707)*1000","v":1834.7},"L.Unit Volume CY/Ft",{"$f":"(0.00009*('Cost Model S-PSH'!C18)^2 + 0.0039*'Cost Model S-PSH'!C18 + 0.0707)*1000","v":628.70000000000005},null,"hyper k->",{"$f":"H95*H98","v":-4.9590669370585025E-2},"$/CY Lower",{"$f":" (7.75204*E98)/(E98 - 0.049591)","v":8.3508624157488018}]
[null,"U.Total Volume CY",{"$f":"C96*'Cost Model S-PSH'!C17","v":2385110},"L.Total Volume CY",{"$f":"E96*'Cost Model S-PSH'!C19","v":691570},null,"intercept->",{"$f":"INTERCEPT(G87:G93,F87:F93)","v":0.128998319125397}]
[null,"U.Volume CY * 10^6",{"$f":"C97/(10^6)","v":2.3851100000000001},"L.Volume CY * 10^6",{"$f":"E97/(10^6)","v":0.69157000000000002},null,"hyper m->",{"$f":"1/H97","v":7.7520389938408236}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Penstock Tunnel Max Velocity",null,null,null,"Draft Tube Tunnel Max Velocity"]
["Cost of Pennstocks and Draft Tube Tunnels $/Ft",null,null,null,null,null,null,null,null,null,"Cost of Surface Pennstocks $/Ft",null,null,null,null,null,null,null,null,null,"Head (ft)","Velocity (Fps)",null,null,"Head (ft)","Velocity (Fps)"]
["Diameter, Ft","500 Ft","1000 Ft","1500 Ft","2000 Ft",null,null,null,null,null,"Diameter, Ft","300 Ft","500 Ft","700 Ft","1000 Ft","1500 Ft",null,null,null,null,300,18,null,null,300,8]
[5,null,null,null,null,null,null,null,null,null,10,1.55,2.2000000000000002,3.2,4.5,6.65,null,null,null,null,500,20,null,null,500,10]
[10,2200,2400,3000,3800,null,null,null,null,null,15,3.3,5,7,10,14.75,null,null,null,null,1000,25,null,null,1000,13]
[15,4100,4600,6000,7600,null,null,null,null,null,20,5.6,8.6999999999999993,12.3,null,null,null,null,null,null,1500,28,null,null,1500,15]
[20,6900,7800,10300,13250,null,null,null,null,null,25,8.6,13.7,null,null,null,null,null,null,null,2200,32,null,null,2200,17]
[25,10000,11700,15800,null,null,null,null,null,null,30,12.2]
[30,null,null,null,null,null,null,null,null,null,35,16.5,null,null,null,null,null,null,null,null,null,"0.0074x + 16.512",null,null,null,null,"0.0046x + 7.516"]
[null,"47.162x1.6615","43.711x1.7314","45.454x1.8126","60.182x1.7959",null,null,null,null,null,null,"0.02x1.885","0.0226x1.9901","0.0365x1.9417","0.0483x1.9694","0.0721x1.9647",null,null,null,null,null,{"$f":"0.0074*'Cost Model S-PSH'!C14 + 16.512","v":28.056000000000001},null,null,null,null,{"$f":"0.0046*('Cost Model S-PSH'!C14-'Cost Model S-PSH'!C91)+ 7.516","v":9.6688000000000009}]
[null,{"$f":"47.162*('Cost Model S-PSH'!C113)^1.6615","v":2723.946698424043},{"$f":"43.711*('Cost Model S-PSH'!C113)^1.7314","v":2994.3919815249051},{"$f":"45.454*('Cost Model S-PSH'!C113)^1.8126","v":3796.4909261600906},{"$f":"60.182*('Cost Model S-PSH'!C113)^1.7959","v":4825.8152305441936},null,null,null,null,null,null,{"$f":"0.02*('Cost Model S-PSH'!C113)^1.885*1000","v":1993.4364659839309},{"$f":"0.0226*('Cost Model S-PSH'!C113)^1.9901*1000","v":2911.4757778134895},{"$f":"0.0365*('Cost Model S-PSH'!C113)^1.9417*1000","v":4178.1254626161035},{"$f":"0.0483*('Cost Model S-PSH'!C113)^1.9694*1000","v":5915.6801610827888},{"$f":"0.0721*('Cost Model S-PSH'!C113)^1.9647*1000","v":8729.9074861026329}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Underground Powerstation Equipment Costs 80MW Units $/kW",null,null,null,null,null,null,null,null,null,"Underground Powerstation Equipment Costs 125MW Units $/kW",null,null,null,null,null,null,null,null,null,"Underground Powerstation Equipment Costs 225MW Units $/kW",null,null,null,null,null,null,null,null,null,"Underground Powerstation Equipment Costs 350MW Units $/kW"]
["Average Head, Ft","160 MW","240 MW","320 MW","480 MW",null,null,null,null,null,"Average Head, Ft","250 MW","375 MW","500 MW","750 MW",null,null,null,null,null,"Average Head, Ft","450 MW","675 MW","900 MW","1350 MW",null,null,null,null,null,"Average Head, Ft","700 MW","1050 MW","1400 MW","2100 MW"]
[350,242,229,223,216,null,null,null,null,null,350,203,194,188,184,null,null,null,null,null,350,163,155,151,146,null,null,null,null,null,350,130,124,121,117]
[500,235,224,217,210,null,null,null,null,null,500,194,185,180,176,null,null,null,null,null,500,153,145,142,137,null,null,null,null,null,500,124,116,114,111]
[1000,224,212,205,200,null,null,null,null,null,1000,183,174,169,165,null,null,null,null,null,1000,139,134,130,126,null,null,null,null,null,1000,112,107,105,102]
[1500,222,210,204,200,null,null,null,null,null,1500,180,173,168,164,null,null,null,null,null,1500,138.5,133.5,129,126,null,null,null,null,null,1500,114,107.5,105.5,103]
[2000,237,226,220,215,null,null,null,null,null,2000,185,176,173,168,null,null,null,null,null,2000,143,135.5,134,130,null,null,null,null,null,2000,115,110,107,104.5]
[2250,245,234,228,223,null,null,null,null,null,2250,187,179,175,171,null,null,null,null,null,2250,145,137,135,132,null,null,null,null,null,2250,115.5,110.5,107.5,105.5]
[]
[null,"2E-05x2 - 0.0609x + 259.97","2E-05x2 - 0.0609x + 247.79","2E-05x2 - 0.0617x + 241.53","2E-05x2 - 0.0555x + 232.3",null,null,null,null,null,null,"2E-05x2 - 0.0485x + 216.18","2E-05x2 - 0.0462x + 206.27","2E-05x2 - 0.0453x + 200.29","2E-05x2 - 0.0456x + 196.43",null,null,null,null,null,null,"2E-05x2 - 0.0544x + 177.56","1E-05x2 - 0.0448x + 166.28","2E-05x2 - 0.048x + 163.78","2E-05x2 - 0.0452x + 157.75",null,null,null,null,null,null,"1E-05x2 - 0.0365x + 139.89","1E-05x2 - 0.0355x + 132.8","1E-05x2 - 0.033x + 129.39","1E-05x2 - 0.0316x + 125.28"]
[null,{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0609*'Cost Model S-PSH'!C92 + 259.97","v":214.38212000000004},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0609*('Cost Model S-PSH'!C92) + 247.79","v":202.20211999999998},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0617*('Cost Model S-PSH'!C92) + 241.53","v":194.88132000000002},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0555*('Cost Model S-PSH'!C92) + 232.3","v":193.87252000000001},null,null,null,null,null,null,{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0485*('Cost Model S-PSH'!C92) + 216.18","v":187.03451999999999},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0462*('Cost Model S-PSH'!C92) + 206.27","v":180.17432000000002},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0453*('Cost Model S-PSH'!C92) + 200.29","v":175.38772},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0456*('Cost Model S-PSH'!C92) + 196.43","v":171.12992},null,null,null,null,null,null,{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0544*('Cost Model S-PSH'!C92) + 177.56","v":140.59111999999999},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0448*('Cost Model S-PSH'!C92) + 166.28","v":124.45796},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.048*('Cost Model S-PSH'!C92) + 163.78","v":135.29751999999999},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0452*('Cost Model S-PSH'!C92) + 157.75","v":132.98032000000001},null,null,null,null,null,null,{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0365*('Cost Model S-PSH'!C92) + 139.89","v":109.07375999999999},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0355*('Cost Model S-PSH'!C92) + 132.8","v":103.30976000000001},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.033*('Cost Model S-PSH'!C92) + 129.39","v":103.21475999999998},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0316*('Cost Model S-PSH'!C92) + 125.28","v":100.96116000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Surface Powerstation Equipment Costs 80MW Units $/kW",null,null,null,null,null,null,null,null,null,"Surface Powerstation Equipment Costs 125MW Units $/kW",null,null,null,null,null,null,null,null,null,"Surface Powerstation Equipment Costs 225MW Units $/kW",null,null,null,null,null,null,null,null,null,"Surface Powerstation Equipment Costs 350MW Units $/kW",null,null,null,null,null,null,null,null,null,"Pump Type Cost Multipliers"]
["Average Head, Ft","160 MW","240 MW","320 MW","480 MW",null,null,null,null,null,"Average Head, Ft","250 MW","375 MW","500 MW","750 MW",null,null,null,null,null,"Average Head, Ft","450 MW","675 MW","900 MW","1350 MW",null,null,null,null,null,"Average Head, Ft","700 MW","1050 MW","1400 MW","2100 MW",null,null,null,null,null,null,"Pump-Turbine","Powerhouse"]
[350,237,225,219,214,null,null,null,null,null,350,200,190,185,183,null,null,null,null,null,350,157,151,146,144,null,null,null,null,null,350,133,126,124,120,null,null,null,null,null,"Fixed",1,1]
[500,236.5,224,217,213,null,null,null,null,null,500,189,179.5,176,171.5,null,null,null,null,null,500,151,144.5,142,136,null,null,null,null,null,500,124,117,115,114,null,null,null,null,null,"Variable",1.2,1.05]
[1000,234,222,216,210,null,null,null,null,null,1000,180,170.5,167,162,null,null,null,null,null,1000,144,137,134,130.5,null,null,null,null,null,1000,111.5,105.5,104,101]
[1500,234.5,223,216.5,212,null,null,null,null,null,1500,181.5,174,168,164,null,null,null,null,null,1500,144,137.5,134,131,null,null,null,null,null,1500,110,105,104,100]
[2000,238.5,228,224,217,null,null,null,null,null,2000,187.5,180,176,173,null,null,null,null,null,2000,146,143,137,135,null,null,null,null,null,2000,110.5,105,104,100.5]
[2250,245,234,228,222,null,null,null,null,null,2250,194,185,180,176,null,null,null,null,null,2250,150,144.5,140.5,137,null,null,null,null,null,2250,111,105.3,104,101]
[]
[null,"8E-06x2 - 0.0174x + 242.74","8E-06x2 - 0.017x + 230.3","8E-06x2 - 0.0168x + 223.7","8E-06x2 - 0.0173x + 219.28",null,null,null,null,null,null,"2E-05x2 - 0.0499x + 212.36","2E-05x2 - 0.0457x + 200.9","2E-05x2 - 0.046x + 196.81","2E-05x2 - 0.0501x + 195",null,null,null,null,null,null,"1E-05x2 - 0.0319x + 165.52","1E-05x2 - 0.0338x + 159.73","1E-05x2 - 0.0313x + 155.12","1E-05x2 - 0.0309x + 151.13",null,null,null,null,null,null,"1E-05x2 - 0.0447x + 144.85","1E-05x2 - 0.041x + 136.46","1E-05x2 - 0.0391x + 133.75","1E-05x2 - 0.0406x + 131.67"]
[null,{"$f":"0.000008*('Cost Model S-PSH'!C92)^2 - 0.0174*('Cost Model S-PSH'!C92) + 242.74","v":233.73380800000001},{"$f":"0.000008*('Cost Model S-PSH'!C92)^2 - 0.017*('Cost Model S-PSH'!C92) + 230.3","v":221.824208},{"$f":"0.000008*('Cost Model S-PSH'!C92)^2 - 0.0168*('Cost Model S-PSH'!C92) + 223.7","v":215.489408},{"$f":"0.000008*('Cost Model S-PSH'!C92)^2 - 0.0173*('Cost Model S-PSH'!C92) + 219.28","v":210.406408},null,null,null,null,null,null,{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0499*('Cost Model S-PSH'!C92) + 212.36","v":181.35812000000001},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0457*('Cost Model S-PSH'!C92) + 200.9","v":175.46732},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.046*('Cost Model S-PSH'!C92) + 196.81","v":170.97952000000001},{"$f":"0.00002*('Cost Model S-PSH'!C92)^2 - 0.0501*('Cost Model S-PSH'!C92)+ 195","v":163.73292000000001},null,null,null,null,null,null,{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0319*('Cost Model S-PSH'!C92) + 165.52","v":140.80336},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0338*('Cost Model S-PSH'!C92)+ 159.73","v":132.49395999999999},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0313*('Cost Model S-PSH'!C92) + 155.12","v":131.19896},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0309*('Cost Model S-PSH'!C92) + 151.13","v":127.73936},null,null,null,null,null,null,{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0447*('Cost Model S-PSH'!C92) + 144.85","v":103.16056},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.041*('Cost Model S-PSH'!C92)+ 136.46","v":99.676760000000002},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0391*('Cost Model S-PSH'!C92) + 133.75","v":99.486159999999998},{"$f":"0.00001*('Cost Model S-PSH'!C92)^2 - 0.0406*('Cost Model S-PSH'!C92) + 131.67","v":95.417159999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Access Tunnel Costs, $/LF",null,null,null,null,null,null,null,null,null,"Switchyard Costs, $M",null,null,null,null,null,null,null,null,null,null,"Access Road, $/mile",null,null,null,null,null,null,null,null,"Liner Cost ($/sq.ft)"]
["Tunnel Length, Miles","$/LF",null,null,null,null,null,null,null,null,"No. of generating units","115 to 161 kV","230 kV","345 kV","500 kV",null,null,null,null,null,null,"Terrain","New","Rebuild",null,null,null,null,null,null,null,"$/Sq.yd","$/sq.ft"]
[0.25,2090,null,"2489.4x0.118",null,null,null,null,null,null,2,1.4,1.7,3.55,7.35,null,null,null,null,null,null,"Steep",439000,293000,null,null,null,null,null,null,"Geomembrane Single Liner",40,{"$f":"AF241/9","v":4.4444444444444446}]
[0.5,2330,null,{"$f":"2489.4*('Cost Model S-PSH'!C39)^0.118","v":2555.8188374587603},null,null,null,null,null,null,3,2.2000000000000002,2.8,6.15,13.5,null,null,null,null,null,null,"Mild",283000,186000,null,null,null,null,null,null,"Geomembrane Double Liner with Leak Detection",55,{"$f":"AF242/9","v":6.1111111111111107}]
[1,2500,null,null,null,null,null,null,null,null,4,2.75,3.7,7.9,16.5,null,null,null,null,null,null,"Flat",189000,123000,null,null,null,null,null,null,"Other (clay, asphalt, concrete)",60,{"$f":"AF243/9","v":6.666666666666667}]
[1.5,2600,null,null,null,null,null,null,null,null,5,3.3,4.4000000000000004,9.4,19]
[2,2690,null,null,null,null,null,null,null,null,6,3.65,4.9000000000000004,11,21]
[]
[null,null,null,null,null,null,null,null,null,null,null,"-0.0643x2 + 1.0743x - 0.48","-0.1x2 + 1.6x - 1.1","-0.1607x2 + 3.1007x - 1.91","-0.6286x2 + 8.3086x - 6.45"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"-0.0643*('Cost Model S-PSH'!C109)^2 + 1.0743*'Cost Model S-PSH'!C109 - 0.48","v":2.7884000000000002},{"$f":"-0.1*('Cost Model S-PSH'!C109)^2 + 1.6*('Cost Model S-PSH'!C109) - 1.1","v":3.7000000000000006},{"$f":"-0.1607*('Cost Model S-PSH'!C109)^2 + 3.1007*('Cost Model S-PSH'!C109) - 1.91","v":7.921599999999998},{"$f":"-0.6286*('Cost Model S-PSH'!C109)^2 + 8.3086*('Cost Model S-PSH'!C109) - 6.45","v":16.726800000000001},null,{"$f":"IF('Cost Model S-PSH'!C66<=160,'Cost Curves S-PSH'!L248,IF(AND('Cost Model S-PSH'!C66>160,'Cost Model S-PSH'!C66<=230),'Cost Curves S-PSH'!M248,IF(AND('Cost Model S-PSH'!C66>230,'Cost Model S-PSH'!C66<=345),'Cost Curves S-PSH'!N248,IF('Cost Model S-PSH'!C66>345,'Cost Curves S-PSH'!O248))))","v":16.726800000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transmission Line Costs Per Mile, $1000s"]
["Transmitted Power, MW","138 kV","230 kV","345 kV","500 kV",null,null,"Transmission Terrain Multiplier"]
[28.5,110,null,null,null,null,null,"Desert",1.05]
[30,112,null,null,null,null,null,"Flat",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dam Height (ft)","Earthfill Volume (x1000 cu. yd.)","Rockfill Volume (x1000 cu. yd.)","RCC Gravity Volume (x1000 cu. yd.)"]
[40,115,null,null,null,null,null,"Farmland",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.15,0.15,0.15]
[50,120,null,null,null,null,null,"Forested",2.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1.8,1,0.2]
[60,122,null,null,null,null,null,"Rolling Hill",1.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,5,3,0.65]
[70,128,null,null,null,null,null,"Mountain",1.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,10,5.95,1.1000000000000001]
[80,132,null,null,null,null,null,"Wetland",1.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,16,9.5,2.25]
[90,140,null,null,null,null,null,"Suburban",1.27]
[100,150,null,null,null,null,null,"Urban",1.59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper Dam Volume",null,{"$f":" (0.00006*('Cost Model L-PSH'!C16)^2 + 0.017*'Cost Model L-PSH'!C16 - 0.7412)*'Cost Model L-PSH'!C17*1000","v":2811640},{"$f":" (0.00004*('Cost Model L-PSH'!C16)^2 + 0.0099*'Cost Model L-PSH'!C16 - 0.4173)*'Cost Model L-PSH'!C17*1000","v":1750710.0000000002},{"$f":" (0.0000164*('Cost Model L-PSH'!C16)^2 - 0.00155*'Cost Model L-PSH'!C16 + 0.2021)*'Cost Model L-PSH'!C17*1000","v":327938}]
[125,172,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower Dam Volume",null,{"$f":" (0.00006*('Cost Model L-PSH'!C18)^2 + 0.017*'Cost Model L-PSH'!C18 - 0.7412)*'Cost Model L-PSH'!C19*1000","v":544280},{"$f":" (0.00004*('Cost Model L-PSH'!C18)^2 + 0.0099*'Cost Model L-PSH'!C18 - 0.4173)*'Cost Model L-PSH'!C19*1000","v":352770.00000000012},{"$f":" (0.0000164*('Cost Model L-PSH'!C18)^2 - 0.00155*'Cost Model L-PSH'!C18 + 0.2021)*'Cost Model L-PSH'!C19*1000","v":184954}]
[102,null,175,null,null,null,null,"Tranmission Circuit Multiplier"]
[150,null,180,null,null,null,null,"Double",{"$f":"AVERAGE(K290:K292)","v":1.6004696290247125}]
[200,null,190]
[300,null,230,null,null,null,null,"Transmission kV","Single Circuit $/mile","Double Circuit $/mile"]
[340,null,240,null,null,null,null,230,959700,1536400,{"$f":"J290/I290","v":1.6009169532145462}]
[350,null,null,275,null,null,null,345,1343800,2150300,{"$f":"J291/I291","v":1.6001637148385177},null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper Dam",null,"Lower Dam"]
[400,null,null,280,null,null,null,500,1919450,3071750,{"$f":"J292/I292","v":1.6003282190210737},null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Volume",{"$f":"(0.0000905*('Cost Model S-PSH'!C16)^2 + 0.00386*('Cost Model S-PSH'!C16) + 0.0707)*1000","v":1837.1000000000001},"Unit Volume",{"$f":"(0.0000905*('Cost Model S-PSH'!C18)^2 + 0.00386*('Cost Model S-PSH'!C18) + 0.0707)*1000","v":628.1}]
[500,null,null,285,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Volume",{"$f":"Z292*'Cost Model S-PSH'!C17","v":2388230},"Total Volume",{"$f":"AB292*'Cost Model S-PSH'!C19","v":690910}]
[600,null,null,290]
[700,null,null,295]
[800,null,null,305]
[900,null,null,325,400]
[1000,null,null,370,402]
[2000,null,null,null,450]
[3000,null,null,null,575]
[]
[null,"0.0043x2 - 0.028x + 108.72","0.0007x2 - 0.0382x + 169.98","0.0003x2 - 0.2536x + 335.57","4E-05x2 - 0.0652x + 428.5"]
[null,{"$f":"0.0043*('Cost Model S-PSH'!C108)^2 - 0.028*'Cost Model S-PSH'!C108 + 108.72","v":7154.5540653847283},{"$f":"0.0007*('Cost Model S-PSH'!C108)^2 - 0.0382*('Cost Model S-PSH'!C108) + 169.98","v":1273.8028086526385},{"$f":"0.0003*('Cost Model S-PSH'!C108)^2 - 0.2536*('Cost Model S-PSH'!C108) + 335.57","v":504.1956040996767},{"$f":"0.00004*('Cost Model S-PSH'!C108)^2 - 0.0652*('Cost Model S-PSH'!C108)+ 428.5","v":410.70412550747744},null,{"$f":"IF('Cost Model S-PSH'!C65<=138,'Cost Curves S-PSH'!B303,IF(AND('Cost Model S-PSH'!C65>138,'Cost Model S-PSH'!C65<=230),'Cost Curves S-PSH'!C303,IF(AND('Cost Model S-PSH'!C65>230,'Cost Model S-PSH'!C65<=345),'Cost Curves S-PSH'!D303,IF('Cost Model S-PSH'!C65<=138>=345,'Cost Curves S-PSH'!E303))))","v":410.70412550747744}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Power Station",{"$f":"'Cost Model S-PSH'!C47","v":"Underground"}]
["UR Connection",{"$f":"IF('Cost Model S-PSH'!C44=\"Horizontal\",\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",IF('Cost Model S-PSH'!C44=\"Vertical\",\"Vertical Intake to Shaft to Upper Tunnel\"))","v":"Vertical Intake to Shaft to Upper Tunnel"}]
["Water Conductor","Penstock"]
["LR Connection","Direct Discharge"]
[]
["Configuration",{"$f":"IF(AND(B332=\"Underground\",B333=\"Vertical Intake to Shaft to Upper Tunnel\",B334=\"Tunnel\",B335=\"Tailrace tunnel\"),\"A\",IF(AND(B332=\"Underground\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Tunnel\",B335=\"Tailrace tunnel\"),\"B\",IF(AND(B332=\"Surface\",B333=\"Vertical Intake to Shaft to Upper Tunnel\",B334=\"Tunnel\",B335=\"Direct Discharge\"),\"C\",IF(AND(B332=\"Surface\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Tunnel\",B335=\"Tailrace tunnel\"),\"D\",IF(AND(B332=\"Surface\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Penstock\",B335=\"Tailrace tunnel\"),\"E\",IF(AND(B332=\"Surface\",B333=\"Horizontal Intake to Upper low pressure tunnel to Shaft to Upper high pressure tunnel\",B334=\"Penstock\",B335=\"Direct Discharge\"),\"F\",\"Out of Bounds\"))))))","v":"Out of Bounds"}]
["Small System Powerstation Costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2008-2011 $",null,"1 cfs = 448.83 gal/min or 7.48 gal/sec"]
["gal/min","stand by power k$"]
[400,65,null,{"$f":"'Cost Model S-PSH'!C116*448.83","v":4011316.6230670661},"gal/min"]
[700,100,null,"stand by power k$"]
[1000,150,null,{"$f":"0.7799*(D363)^0.7442*1000","v":64003697.437245458},"$"]
[5000,400]
[10000,750]
[15000,1000]
[50000,2500]
[]
["2011-2015 $"]
["Low Head","200 ft or less"]
["Turbine generator and Control Cost in $/kW by capacity in MW"]
["y = 1051.9*x^-0.204",null,null,{"$f":"'Cost Model S-PSH'!I10/1000","v":1283.3248207034676},{"$f":"1051.9*(D374^-0.204)*'Market Adj Factors'!C47","v":293.33834129672459}]
[]
["High Head","200 ft or more"]
["Turbine generator and Control Cost in $/kW by capacity in MW"]
["y = 697.41*x^-0.329",null,null,{"$f":"D374","v":1283.3248207034676},{"$f":"697.41*D378^-0.329*'Market Adj Factors'!C47","v":79.495120662002549}]

{"sheet":"Market Adj Factors","index":5,"n_rows":74,"n_cols":37,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Category","Suggested","EPRI Fig",null,null,"Year","Avg. CPI","Inflation Adjustment to 1988$",null,null,null,null,null,null,null,"USBR Category","MAF Category",1988,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,null,null,"Incorporate fatcors"]
[null,"Power station",1.3,"6-8/6-9",null,null,1970,38.841666666666661,{"$f":"H6/$H$24","v":0.32840132459663202},null,null,null,null,null,null,null,"Power plant - structures and improvements","Power station",158.5,323.25,335.5,346.25,351.75,359.75,364,367,378,393,406,408,433,480,501,512,null,null,"Adjust liner sq.ft calculation"]
[null,"Dams, spillways, diversions, emb",1.4,"6-10",null,null,1971,40.483333333333334,0.34228140632706261,null,null,null,null,null,null,null,"Earth Dams","Dams, spillways, diversions, emb",144.5,301.25,317.75,329.75,334.25,339.5,333.5,333,346,360,372,374,400,453,475,484]
[null,"Upper intake/outlet (vertical)",2,"6-12",null,null,1972,41.80833333333333,0.35348411188614098,null,null,null,null,null,null,null,"Earth Dams - outlet works","Upper intake/outlet (vertical)",166.75,341.5,357,367.75,372.5,379.75,378.5,379,389,405,415,416,447,501,517,522]
[null,"Lower intake/outlet (horizontal)",1.3,"6-12",null,null,1973,44.425000000000004,0.37560769393362925,null,null,null,null,null,null,null,"Earth Dams - outlet works","Lower intake/outlet (horizontal)",166.75,341.5,357,367.75,372.5,379.75,378.5,379,389,405,415,416,447,501,517,522]
[null,"Surface penstocks",1.3,"6-16",null,null,1974,49.316666666666663,0.41696611005425199,null,null,null,null,null,null,null,"Steel pipelines","Surface penstocks",170.25,355.75,365.75,374.75,382.75,390.75,397.5,403,411,419,428,429,454,506,521,524]
[null,"Vertical shaft",1.8,"6-14",null,null,1975,53.824999999999996,0.4550834918621855,null,null,null,null,null,null,null,"Tunnels","Vertical shaft",175.75,350.5,360.5,374.25,381.75,389.5,396.25,402,410,421,434,439,459,506,532,546]
[null,"Concrete lined tunnels (e.g. tailrace & power tun)",1.6,"6-13",null,null,1976,56.933333333333337,0.48136405270203619,null,null,null,null,null,null,null,"Tunnels","Concrete lined tunnels (e.g. tailrace & power tun)",175.75,350.5,360.5,374.25,381.75,389.5,396.25,402,410,421,434,439,459,506,532,546]
[null,"Steel-Lined tunnels (underground penstocks)",1.9,"6-15",null,null,1977,60.616666666666667,0.51250616501092083,null,null,null,null,null,null,null,"Tunnels","Steel-Lined tunnels (underground penstocks)",175.75,350.5,360.5,374.25,381.75,389.5,396.25,402,410,421,434,439,459,506,532,546]
[null,"Draft tubes",1.9,"6-15",null,null,1978,65.24166666666666,0.5516099485661945,null,null,null,null,null,null,null,"Tunnels","Draft tubes",175.75,350.5,360.5,374.25,381.75,389.5,396.25,402,410,421,434,439,459,506,532,546]
[null,"Access and voltage tunnels",1,"6-19",null,null,1979,72.583333333333329,0.61368280138096232,null,null,null,null,null,null,null,"Tunnels","Access and voltage tunnels",175.75,350.5,360.5,374.25,381.75,389.5,396.25,402,410,421,434,439,459,506,532,546]
[null,"Roads","Allowance","N/A",null,null,1980,82.38333333333334,0.69654054815754241,null,null,null,null,null,null,null,"Secondary Roads","Roads",195.25,410,436,451.75,460.75,466.5,453.5,446,462,481,491,492,537,616,633,643]
[null,"Electro-Mechanical*",1.7,"6-17/6-18",null,null,1981,90.933333333333323,0.76882970478404822,null,null,null,null,null,null,null,"Power plant - turbines and generators","Electro-Mechanical*",180.75,337.75,345.5,353,359.25,367,372.75,377,380,387,396,400,412,433,456,472]
[null,"Transmission works",1.3,"6-21",null,null,1982,96.53333333333336,0.81617698865638,null,null,null,null,null,null,null,"Steel tower transmission lines","Transmission works",181.25,297,308,318,320.75,328,333.75,333,341,356,364,363,393,456,472,479]
[null,"Switchyard",1,"6-20",null,null,1983,99.583333333333329,0.8419643486225602,null,null,null,null,null,null,null,"Switchyards and substations","Switchyard",168,317.75,328.25,336.5,343.5,349.75,353.75,357,361,371,378,382,414,473,494,503]
[null,"EPC Contractor's Indirects",0.25,"N/A",null,null,1984,103.93333333333334,0.8787430423448177,null,null,null,null,null,null,null,null,"O&M",165.5,338,354.25,366.5,373,379.5,381,382,394,409,422,426,456,515,535,540]
[null,"Owner's Indirects",0.1,"N/A",null,null,1985,107.60000000000001,0.90974424011836807]
[null,"Contingency",0.33,"N/A",null,null,1986,109.69166666666668,0.92742901430282532]
[null,"O&M",1.3,"N/A",null,null,1987,113.61666666666666,0.96061438737405747,null,null,null,null,null,null,null,null,"USBR CCT Normalized to 1988",1988,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,null,null,null,null,null,1988,118.27500000000002,1,null,null,null,null,null,null,null,null,"Power station",1,2.0394321799999999,2.1167192400000001,2.18454259,2.2192428999999998,2.2697160900000002,2.2965299699999999,2.31,2.39,2.48,2.56,2.57,2.73,3.03,3.16,3.23]
[null,null,null,null,null,null,1989,123.94166666666668,1.0479109420136685,null,null,null,null,null,null,null,"Composite trend","Dams, spillways, diversions, emb",1,2.0847750899999999,2.1989619399999998,2.2820069200000002,2.3131487900000001,2.3494809700000001,2.3079584799999999,2.31,2.39,2.4900000000000002,2.57,2.59,2.77,3.14,3.29,3.35]
[null,null,null,null,null,null,1990,130.65833333333333,1.1046994997533994,null,null,null,null,null,null,null,null,"Upper intake/outlet (vertical)",1,2.0479760100000002,2.1409295400000001,2.2053973,2.2338830600000001,2.2773613199999998,2.2698650699999998,2.27,2.33,2.4300000000000002,2.4900000000000002,2.5,2.68,3,3.1,3.13]
[null,null,null,null,null,null,1991,136.16666666666666,1.1512717536813919,null,null,null,null,null,null,null,null,"Lower intake/outlet (horizontal)",1,2.0479760100000002,2.1409295400000001,2.2053973,2.2338830600000001,2.2773613199999998,2.2698650699999998,2.27,2.33,2.4300000000000002,2.4900000000000002,2.5,2.68,3,3.1,3.13]
[null,null,null,null,null,null,1992,140.30833333333331,1.1862890157119703,null,null,null,null,null,null,null,null,"Surface penstocks",1,2.0895741600000002,2.14831131,2.2011747399999999,2.2481644599999999,2.2951541899999999,2.3348017599999999,2.37,2.41,2.46,2.5099999999999998,2.52,2.66,2.97,3.06,3.08]
[null,"Category","Suggested","Inflation Factor",null,null,1993,144.47499999999999,1.2215176495455504,null,null,null,null,null,null,null,null,"Vertical shaft",1,1.9943101000000001,2.0512090999999999,2.12944523,2.17211949,2.2162162200000002,2.2546230399999998,2.29,2.33,2.4,2.4700000000000002,2.5,2.61,2.88,3.03,3.11]
[null,"Power station",1.3,{"$f":"$C$45","v":2.4063214260550976},null,null,1994,148.22499999999999,1.2532234199957724,null,null,null,null,null,null,null,null,"Concrete lined tunnels (e.g. tailrace & power tun)",1,1.9943101000000001,2.0512090999999999,2.12944523,2.17211949,2.2162162200000002,2.2546230399999998,2.29,2.33,2.4,2.4700000000000002,2.5,2.61,2.88,3.03,3.11]
[null,"Dams, spillways, diversions, emb",1.4,2.4063214260550976,null,null,1995,152.38333333333335,1.2883815965616854,null,null,null,null,null,null,null,null,"Steel-Lined tunnels (underground penstocks)",1,1.9943101000000001,2.0512090999999999,2.12944523,2.17211949,2.2162162200000002,2.2546230399999998,2.29,2.33,2.4,2.4700000000000002,2.5,2.61,2.88,3.03,3.11]
[null,"Upper intake/outlet (vertical)",2,2.4063214260550976,null,null,1996,156.85833333333332,1.3262171492989498,null,null,null,null,null,null,null,null,"Draft tubes",1,1.9943101000000001,2.0512090999999999,2.12944523,2.17211949,2.2162162200000002,2.2546230399999998,2.29,2.33,2.4,2.4700000000000002,2.5,2.61,2.88,3.03,3.11]
[null,"Lower intake/outlet (horizontal)",1.3,2.4063214260550976,null,null,1997,160.52500000000001,1.3572183470725003,null,null,null,null,null,null,null,null,"Access and voltage tunnels",1,1.9943101000000001,2.0512090999999999,2.12944523,2.17211949,2.2162162200000002,2.2546230399999998,2.29,2.33,2.4,2.4700000000000002,2.5,2.61,2.88,3.03,3.11]
[null,"Surface penstocks",1.3,{"$f":"$C$45","v":2.4063214260550976},null,null,1998,163.00833333333335,1.3782146128373141,null,null,null,null,null,null,null,null,"Roads",1,2.0998719600000002,2.2330345700000001,2.3137003799999998,2.3597951300000002,2.3892445599999999,2.3226632500000002,2.2799999999999998,2.36,2.46,2.52,2.52,2.75,3.15,3.24,3.29]
[null,"Vertical shaft",1.8,2.4063214260550976,null,null,1999,166.58333333333331,1.4084407806665253,null,null,null,null,null,null,null,null,"Electro-Mechanical*",1,1.86860304,1.91147994,1.9529737199999999,1.9875518700000001,2.0304287699999999,2.0622406600000001,2.09,2.1,2.14,2.19,2.21,2.2799999999999998,2.4,2.52,2.61]
[null,"Concrete lined tunnels (e.g. tailrace & power tun)",1.6,2.4063214260550976,null,null,2000,172.19166666666669,1.4558585218065243,null,null,null,null,null,null,null,null,"Transmission works",1,1.63862069,1.69931034,1.7544827599999999,1.7696551700000001,1.8096551700000001,1.84137931,1.84,1.88,1.96,2.0099999999999998,2,2.17,2.52,2.61,2.64]
[null,"Steel-Lined tunnels (underground penstocks)",1.9,2.4063214260550976,null,null,2001,177.04166666666666,1.4968646515888111,null,null,null,null,null,null,null,null,"Switchyard",1,1.89136905,1.95386905,2.00297619,2.0446428600000002,2.0818452399999998,2.1056547600000002,2.12,2.15,2.21,2.25,2.27,2.46,2.82,2.94,3]
[null,"Draft tubes",1.9,2.4063214260550976,null,null,2002,179.86666666666667,{"$f":"H38/$H$24","v":1.5207496653279784},null,null,null,null,null,null,null,null,"O&M",1,2.0422960699999999,2.14048338,2.2145015099999998,2.2537764400000002,2.2930513600000002,2.3021148,2.31,2.38,2.4700000000000002,2.5499999999999998,2.57,2.75,3.11,3.23,3.26]
[null,"Access and voltage tunnels",1,2.4063214260550976,null,null,2003,184,1.5556964700908895]
[null,"Roads",1,2.4063214260550976,null,null,2004,188.9083333333333,1.5971958007468465]
[null,"Electro-Mechanical*",1.7,2.4063214260550976,null,null,2005,195.26666666666665,1.6509546959768897,null,null,null,null,null,null,null,null,"USBR CCT Normalized to 2022",1988,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Transmission works",1.3,2.4063214260550976,null,null,2006,201.55833333333337,1.7041499330655958,null,null,null,null,null,null,null,null,"Power station",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.04,1.07]
[null,"Switchyard",1,2.4063214260550976,null,null,2007,207.34416666666667,1.7530684140069046,null,null,null,null,null,null,null,null,"Dams, spillways, diversions, emb",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.07]
[null,null,null,null,null,null,2008,215.25424999999998,1.8199471570492491,null,null,null,null,null,null,null,null,"Upper intake/outlet (vertical)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.03,1.04]
[null,"1988-2022 adjustment",{"$f":"H58/$H$24","v":2.4063214260550976},null,null,null,2009,214.56466666666668,1.814116818149792,null,null,null,null,null,null,null,null,"Lower intake/outlet (horizontal)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.03,1.04]
[null,"2011-2022 adjustment",{"$f":"H58/H47","v":1.2653559959037837},null,null,null,2010,218.07616666666672,1.8438061015993801,null,null,null,null,null,null,null,null,"Surface penstocks",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.03,1.04]
[null,"2015-2022 adjustment",{"$f":"H58/H51","v":1.2008673634969647},null,null,null,2011,224.923,1.9016952018600715,null,null,null,null,null,null,null,null,"Vertical shaft",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.08]
[null,"2021-2024 Adjustment",{"$f":"I60/I57","v":1.1576717200995823},null,null,null,2012,229.58608333333328,1.9411209751285836,null,null,null,null,null,null,null,null,"Concrete lined tunnels (e.g. tailrace & power tun)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.08]
[null,"1988-2024 adjustment",{"$f":"H60/H24","v":2.6522003804692451},null,null,null,2013,232.95174999999998,1.9695772563939966,null,null,null,null,null,null,null,null,"Steel-Lined tunnels (underground penstocks)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.08]
[null,null,null,null,null,null,2014,236.715,2.0013950538998095,null,null,null,null,null,null,null,null,"Draft tubes",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.08]
[null,null,null,null,null,null,2015,237.00174999999999,2.0038194884802363,null,null,null,null,null,null,null,null,"Access and voltage tunnels",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.08]
[null,null,null,null,null,null,2016,240.00541666666666,2.0292151060381873,null,null,null,null,null,null,null,null,"Roads",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.03,1.04]
[null,null,null,null,null,null,2017,245.12100000000001,2.0724667089410271,null,null,null,null,null,null,null,null,"Electro-Mechanical",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.05,1.0900000000000001]
[null,null,null,null,null,null,2018,251.0989166666667,2.1230092299020642,null,null,null,null,null,null,null,null,"Transmission works",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.04,1.05]
[null,null,null,null,null,null,2019,255.64649999999997,2.1614584654407096,null,null,null,null,null,null,null,null,"Switchyard",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.04,1.06]
[null,null,null,null,null,null,2020,258.83824999999996,2.1884443035299084,null,null,null,null,null,null,null,null,"O&M",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.04,1.05]
[null,null,null,null,null,null,2021,270.96541666666667,2.2909779468752198]
[null,null,null,null,null,null,2022,284.60766666666672,{"$f":"H58/$H$24","v":2.4063214260550976}]
[null,null,null,null,null,null,2023,304.702,{"$f":"H59/$H$24","v":2.5762164447262732},null,null,null,null,null,null,null,null,null,null,null,null,"Post-2022 Adjustments"]
[null,null,null,null,null,null,2024,313.68900000000002,{"$f":"H60/$H$24","v":2.6522003804692451},null,null,null,null,null,null,null,null,"Category","2022 MAF","2022 Inflation Factor","2022 Composite","2023 Adjustment","2023 Composite","2024 Adjustment","2024 Composite"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Powerplant Structure",null,"Power station",1.3,2.41,{"$f":"S61*T61","v":3.1330000000000005},{"$f":"AG6/AF6","v":1.04375},{"$f":"U61*V61","v":3.2700687500000005},{"$f":"AH6/AF6","v":1.0666666666666667},{"$f":"X61*U61","v":3.3418666666666672}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dams, spillways, diversions, emb",1.4,2.41,3.3740000000000001,1.0485651214128036,3.5378587196467994,1.0684326710816776,3.6048918322295802]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper intake/outlet (vertical)",2,2.41,4.82,1.0319361277445109,4.9739321357285426,1.0419161676646707,5.0220359281437128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower intake/outlet (horizontal)",1.3,2.41,3.1330000000000005,1.0319361277445109,3.2330558882235532,1.0419161676646707,3.2643233532934137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface penstocks",1.3,2.41,3.1330000000000005,1.0296442687747036,3.2258754940711469,1.0355731225296443,3.244450592885376]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertical shaft",1.8,2.41,4.3380000000000001,1.0513833992094861,4.5609011857707511,1.0790513833992095,4.6809249011857705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concrete lined tunnels (e.g. tailrace & power tun)",1.6,2.41,3.8560000000000003,1.0513833992094861,4.0541343873517786,1.0790513833992095,4.1608221343873524]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steel-Lined tunnels (underground penstocks)",1.9,2.41,4.5789999999999997,1.0513833992094861,4.8142845849802365,1.0790513833992095,4.9409762845849796]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft tubes",1.9,2.41,4.5789999999999997,1.0513833992094861,4.8142845849802365,1.0790513833992095,4.9409762845849796]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Access and voltage tunnels",1,2.41,2.41,1.0513833992094861,2.5338339920948618,1.0790513833992095,2.6005138339920948]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roads",1,2.41,2.41,1.0275974025974026,2.4765097402597402,1.0438311688311688,2.5156331168831167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electro-Mechanical*",1.7,2.41,4.0970000000000004,1.0531177829099307,4.3146235565819868,1.0900692840646651,4.4660138568129337]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission works",1.3,2.41,3.1330000000000005,1.0350877192982457,3.2429298245614042,1.0504385964912282,3.2910241228070185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Switchyard",1,2.41,2.41,1.0443974630021142,2.5169978858350954,1.0634249471458774,2.5628541226215646]

{"sheet":"Locational Adj Factors","index":6,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Location Factor"]
["State  ","Material Cost","Equipment Rental"]
["Alabama",96.8,59.3]
["Alaska",125.3,114.2]
["Arizona",97.5,68.8]
["Arkansas",95.3,57.3]
["California",98.2,118.8]
["Colorado",101.2,80.5]
["Connecticut",101.3,120.1]
["Delaware",99.3,107.9]
["DC",102.4,92.8]
["Florida",99.8,72.5]
["Georgia",97.2,63]
["Hawaii",111.8,121.2]
["Idaho",102.5,68.599999999999994]
["Illinois",96.9,114.6]
["Indiana",96,84.3]
["Iowa",99.1,72.8]
["Kansas",98.8,69.2]
["Kentucky",94.4,85.2]
["Louisiana",99.1,60.2]
["Maine",96.6,79.3]
["Maryland",97.8,80]
["Massachusetts",98.8,121.9]
["Michigan",95.5,92.2]
["Minnesota",98.8,107.5]
["Mississippi",97.7,59.5]
["Missouri",98,89.5]
["Montana",102.3,71.599999999999994]
["Nebraska",98.5,74.099999999999994]
["Nevada",98.4,96.3]
["New Hampshire",97.8,68.400000000000006]
["New Jersey",99.7,123.8]
["New Mexico",98.1,73]
["New York",99.7,125.2]
["North Carolina",98.2,44.8]
["North Dakota",102,59.3]
["Ohio",96.9,89.4]
["Oklahoma",95.6,55.7]
["Oregon",97.6,97.6]
["Pennsylvania",95.7,100.3]
["Rhode Island",99.7,111.1]
["South Carolina",97.1,52.1]
["South Dakota",100.2,53.1]
["Tennessee",97.5,64.3]
["Texas",97.5,54.7]
["Utah",99.5,68.5]
["Vermont",97.8,63.8]
["Virginia",99.8,64.7]
["Washington",101.9,91.8]
["West Virginia",99,86.8]
["Wisconsin",98.9,95]
["Wyoming",98.4,58.5]
["Puerto Rico",121.3,24.1]
["United States",100,100]

{"sheet":"Land Value Data","index":7,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
["State","Farm Real Estate $/Acre 2021","Cropland $/Acre 2021","Irrigated Cropland $/Acre 2021","Non-Irrigated Cropland $/Acre 2021","Pasture $/Acre 2021","Average $/Acre 2021"]
["Connecticut",12500,8770,null,null,6870,{"$f":"AVERAGE(B3:F3)","v":9380}]
["Delaware",9300,8600,null,null,6870,{"$f":"AVERAGE(B4:F4)","v":8256.6666666666661}]
["Maine",2600,8770,null,null,6870,6080]
["Maryland",8670,7960,null,null,null,8315]
["Massachusetts",13700,8770,null,null,6870,9780]
["New Hampshire",5050,8770,null,null,6870,6896.666666666667]
["New Jersey",14400,14800,null,null,13400,14200]
["New York",3270,2910,null,null,1580,2586.6666666666665]
["Pennsylvania",6800,7600,null,null,3440,5946.666666666667]
["Rhode Island",16400,8770,null,null,6870,10680]
["Vermont",3900,8770,null,null,6870,6513.333333333333]
["Michigan",5300,4700,null,null,2740,4246.666666666667]
["Minnesota",5240,5270,null,null,1830,4113.333333333333]
["Wisconsin",5190,5280,null,null,2520,4330]
["Illinois",7900,7900,null,null,3400,6400]
["Indiana",7100,6800,null,null,2490,5463.333333333333]
["Iowa",7740,7810,null,null,3020,6190]
["Missouri",3700,3810,4800,3700,2160,3634]
["Ohio",6600,6800,null,null,3440,5613.333333333333]
["Kansas",2100,2370,3700,2250,1500,2384]
["Nebraska",3100,4960,6530,3990,1080,3932]
["North Dakota",1820,2060,null,null,840,1573.3333333333333]
["South Dakota",2190,3390,null,3180,1060,2455]
["Kentucky",4000,4510,null,null,3080,3863.3333333333335]
["North Carolina",4750,4290,null,null,4850,4630]
["Tennessee",4260,4130,null,null,4000,4130]
["Virginia",4700,4790,null,null,4060,4516.666666666667]
["West Virginia",2770,3330,null,null,2200,2766.6666666666665]
["Alabama",3200,3550,null,null,2650,3133.3333333333335]
["Florida",6020,7300,8350,6320,5530,6704]
["Georgia",3670,3480,4350,3130,4060,3738]
["South Carolina",3600,2900,null,null,3350,3283.3333333333335]
["Arkansas",3390,2930,3420,2130,2700,2914]
["Louisiana",3220,2980,2880,3020,2950,3010]
["Mississippi",2860,3150,3700,2830,2480,3004]
["Oklahoma",2020,1810,null,1790,1600,1805]
["Texas",2380,2150,2540,2090,1800,2192]
["Arizona",3900,7700,7700,null,null,6433.333333333333]
["Colorado",1610,2240,5400,1400,875,2305]
["Idaho",3350,4450,6800,1890,1700,3638]
["Montana",930,1050,3050,835,700,1313]
["Nevada",1010,null,null,null,null,1010]
["New Mexico",600,1660,4550,485,440,1547]
["Utah",2620,4190,6650,1550,1370,3276]
["Wyoming",790,1600,2550,890,610,1288]
["California",10900,13860,16300,5900,3100,10012]
["Oregon",2790,3310,5800,2340,830,3014]
["Washington",2900,2700,7800,1310,750,3092]
["United States",3380,4420,null,null,1480,3093.3333333333335]

{"sheet":"Sensitivity Analysis","index":8,"n_rows":99,"n_cols":20,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["#","Duration (Hrs)","Nominal Head (Ft)","Conveyance Length (Ft)","Average U. Dam Height (ft)","Average L. Dam Height (ft)","Power Station Type","Transmission Miles","Average U. Crest Length (Ft)","Average L. Crest Length (Ft)","Power Station Structure Geology Type","Access Tunnel Length (Miles)","U. Reservoir Intake/Outlet Type","Tranmission Type","Penstock Type","L. Reservoir Intake/Outlet Type","$/kWh","$/kW"]
[1,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[2,24,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",17636.692200000001,17292971471.354801]
[3,10,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",14001.987499999999,33781464985.5117]
[4,18.5,2500,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",11907.936799999999,24983617807.690701]
[5,18.5,800,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",26109.4558,16308089591.5103]
[6,18.5,1560,5000,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",13251.6643,17601141505.456299]
[7,18.5,1560,25000,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",19726.200400000002,24315351846.477299]
[8,18.5,1560,14394,60,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",15794.116599999999,20269029829.169701,null,"*Any changes to current input cell reference need to be manually updated in the macro."]
[9,18.5,1560,14394,240,240,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",19949.6083,25601888102.149799,null,"Yellow highlighted cell inputs affect the sensitivity graphs"]
[10,18.5,1560,14394,120,60,"Surface",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",14811.1103,19007510472.897701]
[11,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[12,18.5,1560,14394,120,60,"Underground",5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",7206.4495999999999,9248237550.9563999]
[13,18.5,1560,14394,120,60,"Underground",25,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",28558.892899999999,36650422887.123596]
[14,18.5,1560,14394,120,60,"Underground",13.5,800,800,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",15938.409799999999,20454205329.893101]
[15,18.5,1560,14394,120,60,"Underground",13.5,1800,1800,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16702.165099999998,21434353729.452]
[16,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Average",1.25,"Vertical","Double","Underground","Horizontal",15853.270200000001,20344943367.0746]
[17,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[18,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",0.75,"Vertical","Double","Underground","Horizontal",16071.3696,20624836406.493999]
[19,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.75,"Vertical","Double","Underground","Horizontal",16501.527699999999,21176870193.411301]
[20,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Horizontal","Double","Underground","Horizontal",16583.7552,21282395100.3699]
[21,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[22,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Single","Underground","Horizontal",16281.237999999999,20894166318.827499]
[23,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[24,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Surface","Horizontal",16474.819599999999,21142594970.453899]
[24,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[24,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Vertical",16084.6018,20641817610.824902]
[24,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[25,18.5,1560,14394,120,60,"Underground",13.5,1300,1100,"Adverse",1.25,"Vertical","Double","Underground","Horizontal",16281.237999999999,20894166318.827499]
[]
[]
[]
[]
[]
["#","Duration (Hrs)","Nominal Head (Ft)","Conveyance Length (Ft)","Average U. Dam Height (ft)","Average L. Dam Height (ft)","Power Station Type","Transmission Miles","Average U. Crest Length (Ft)","Average L. Crest Length (Ft)","Power Station Structure Geology Type","Access Tunnel Length (Miles)","U. Reservoir Intake/Outlet Type","Tranmission Type","Penstock Type","Tunneling Condirion","$/kWh","$/kW"]
[1,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[2,6,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",584.1585,3504.951]
[3,14,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",392.18380000000002,5490.5726000000004]
[4,10,500,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",858.95180000000005,8589.5185000000001]
[5,10,1500,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",358.62650000000002,3586.2653]
[6,10,1004,5000,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",349.14069999999998,3491.4065999999998]
[7,10,1004,15000,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",472.58760000000001,4725.8762999999999,null,"*Any changes to current input cell reference need to be manually updated in the macro."]
[8,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003,null,"Yellow highlighted cell inputs affect the sensitivity graphs"]
[9,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[10,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[11,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[12,10,1004,11080,200,170,"Surface",20,30,30,"Average",0.75,"Vertical","Double","Surface","Average",369.97140000000002,3699.7136]
[13,10,1004,11080,200,170,"Surface",40,30,30,"Average",0.75,"Vertical","Double","Surface","Average",483.72300000000001,4837.2299999999996]
[14,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[15,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[16,10,1004,11080,200,170,"Surface",30,30,30,"Adverse",0.75,"Vertical","Double","Surface","Average",444.15289999999999,4441.5289000000002]
[17,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[18,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[19,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[20,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Horizontal","Double","Surface","Average",435.41919999999999,4354.192]
[21,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[22,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Single","Surface","Average",362.8306,3628.3058999999998]
[23,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[24,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[24,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[24,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Poor",442.44130000000001,4424.4132]
[24,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[25,10,1004,11080,200,170,"Surface",30,30,30,"Average",0.75,"Vertical","Double","Surface","Average",426.84719999999999,4268.4718000000003]
[]
[]
[]
[]
[]
[]
[]
[null,"L-PSH"]
[null,null,"Low $/kWh"," High $/kWh","Basecase $/kWh",null,null,"Change $/kWh"]
[null,"Nominal Head (Ft)",{"$f":"Q5","v":11907.936799999999},{"$f":"Q6","v":26109.4558},{"$f":"$Q$2","v":16281.237999999999},"2500 ft","800 ft",{"$f":"(D73-E73)+(E73-C73)","v":14201.519}]
[null,"Duration (Hrs)",{"$f":"Q3","v":17636.692200000001},{"$f":"Q4","v":14001.987499999999},16281.237999999999,"24 hours","10 hours",-3634.704700000002]
[null,"Conveyance Length (Ft)",{"$f":"Q7","v":13251.6643},{"$f":"Q8","v":19726.200400000002},16281.237999999999,"5000 ft","25000 ft",6474.5361000000012]
[null,"Average Dam Height (ft)",{"$f":"Q9","v":15794.116599999999},{"$f":"Q10","v":19949.6083},16281.237999999999,"60 ft","240 ft",4155.4917000000005]
[null,"Power Station Type",{"$f":"Q11","v":14811.1103},{"$f":"Q12","v":16281.237999999999},16281.237999999999,"Surface","Underground",1470.1276999999991]
[null,"Transmission Miles",{"$f":"Q13","v":7206.4495999999999},{"$f":"Q14","v":28558.892899999999},16281.237999999999,"5 miles","25 miles",21352.443299999999]
[null,"Power Station Structure Geology Type",{"$f":"Q17","v":15853.270200000001},{"$f":"Q18","v":16281.237999999999},16281.237999999999,"Average","Adverse",427.96779999999853]
[null,"Access Tunnel Length (Miles)",{"$f":"Q19","v":16071.3696},{"$f":"Q20","v":16501.527699999999},16281.237999999999,"0.75 miles","1.75 miles",430.15809999999874]
[null,"Average Crest Length (Ft)",{"$f":"Q15","v":15938.409799999999},{"$f":"Q18","v":16281.237999999999},16281.237999999999,"800 ft","1800 ft",342.82819999999992]
[null,"U. Reservoir Intake/Outlet Type",{"$f":"Q22","v":16281.237999999999},{"$f":"Q21","v":16583.7552},16281.237999999999,"Vertical","Horizontal",302.51720000000023]
[null,"Tranmission Type",{"$f":"Q23","v":16281.237999999999},{"$f":"Q24","v":16281.237999999999},16281.237999999999,"Single","Double",0]
[null,"L. Reservoir Intake/Outlet Type",{"$f":"Q27","v":16084.6018},{"$f":"Q28","v":16281.237999999999},16281.237999999999,"Vertical","Horizontal",196.63619999999901]
[null,"Penstock Type",{"$f":"Q26","v":16281.237999999999},{"$f":"Q25","v":16474.819599999999},16281.237999999999,"Underground","Surface",193.58159999999953]
[]
[]
[]
[]
[null,"S-PSH"]
[null,null,"Low $/kWh"," High $/kWh","Basecase $/kWh",null,null,"Change $/kWh"]
[null,"Nominal Head (Ft)",{"$f":"Q40","v":358.62650000000002},{"$f":"Q39","v":858.95180000000005},{"$f":"$Q$36","v":426.84719999999999},"1500 ft","500 ft",{"$f":"(D92-E92)+(E92-C92)","v":500.32530000000003}]
[null,"Duration (Hrs)",{"$f":"Q38","v":392.18380000000002},{"$f":"Q37","v":584.1585},{"$f":"$Q$36","v":426.84719999999999},"14 hours","6 hours",{"$f":"(D93-E93)+(E93-C93)","v":191.97469999999998}]
[null,"Conveyance Length (Ft)",{"$f":"Q41","v":349.14069999999998},{"$f":"Q42","v":472.58760000000001},426.84719999999999,"5000 ft","15000 ft",123.44690000000003]
[null,"Transmission Miles",{"$f":"Q47","v":369.97140000000002},{"$f":"Q48","v":483.72300000000001},426.84719999999999,"20 miles","40 miles",113.7516]
[null,"Tranmission Type",{"$f":"Q57","v":362.8306},{"$f":"Q58","v":426.84719999999999},426.84719999999999,"Single","Double",64.016599999999983]
[null,"Tunneling Condition",{"$f":"Q62","v":426.84719999999999},{"$f":"Q61","v":442.44130000000001},426.84719999999999,"Average","Poor",15.594100000000026]
[null,"Power Station Structure Geology Type",{"$f":"Q52","v":426.84719999999999},{"$f":"Q51","v":444.15289999999999},426.84719999999999,"Average","Adverse",17.305700000000002]
[null,"U. Reservoir Intake/Outlet Type",{"$f":"Q56","v":426.84719999999999},{"$f":"Q55","v":435.41919999999999},426.84719999999999,"Vertical","Horizontal",8.5720000000000027]