{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Overview","Global Inputs","Pipelines","Well Fields","Reservoirs","Treatment","Water Rights","Ditches & Diversions","Streams & Habitat","User-Specified Project","Costing Module","Cost Summary Sheet","Module References","HW C Factor","Table B-1","Table B-2","Change Log"],"not_rendered":{"charts":2,"images":26,"macros":1,"external_links":2,"defined_names":280,"comments":0,"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":"Overview","index":0,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,46,23],[4,24,30,28],[0,0,1,26]]}
["Colorado Water Project Cost Estimating Tool"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Introduction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Colorado Water Project Cost Estimating Tool is intended to provide a common technical framework for BRTs to utilize when developing their Basin Implementation Plans. This tool builds on previous SWSI cost estimation methods as well as other tools developed for planning-level cost estimation to provide an accessible and user-friendly tool for basin roundtables to use in developing high-level cost estimates of projects and methods. \n\nIn addition, the use of this tool provides costs presented in a manner that enables easy comparison by CWCB. As this tool is used, it may be adjusted over time to improve the function and costs databases as more project information and costs are collected.  Each project module varies in complexity and level of detail based on the amount of data available to support development of cost curves and the required input information to define specific project-type characteristics.\n\nUser Note: For the tool to function properly, User must enable Macros in Excel. \n\nFor help navigating the tool, user should refer to the Quick Reference Guide. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Disclaimer"]
["This tool was developed for the purpose of preparing regional water planning-level cost estimates only. It is not intended to be used in lieu of professional engineering design or cost estimation. Results of this tool should be carefully reviewed by construction professionals, professional engineers or other knowledgeable professionals prior to implementation of a project. \n\nAny use of the Colorado Water Project Cost Estimating Tool and results will be at the User's own risk and without liability of legal exposure to the Colorado Water Conservation Board and CDM Smith, Inc."]

{"sheet":"Global Inputs","index":1,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,0,1,17],[23,4,23,10],[21,4,21,10],[13,4,13,10],[17,4,17,10],[18,4,18,10],[19,4,19,10],[20,4,20,10],[14,4,14,10]]}
[]
["  G l o b a l   I n p u t s"]
[]
[null,null,"CWCB Colorado Water Project Cost Estimating Tool"]
[null,null,"Input Key"]
[null,null,0,"User Input"]
[null,null,0,"Informational Data*"]
[null,null,0,"Default Value, Adjustable by User"]
[null,null,0,"Calculated Values, Not to be Adjusted"]
[null,null,"*This tool provides a means of collecting cost data for various projects throughout the state of Colorado. Some information may not currently factor into costing of a project, but is useful for understanding the components of the project."]
[null,null,"User to please provide as much information as possible regarding their proposed project."]
[]
[null,null,"Project Information"]
[null,null,null,"Project Name: "]
[null,null,null,"Project ID:"]
[null,null,null,"Project Need Addressed (check all that apply):"]
[null,null,null,"Basin:"]
[null,null,null,"Location:"]
[]
[null,null,null,"Cost Estimator:"]
[null,null,null,"Checked By:"]
[null,null,null,"Calculation Date:",{"$f":"TODAY()","v":"2018-12-17"}]
[]
[null,null,null,null,"Modules Utilized"]
[null,null,null,null,"Pipelines","Well Fields","Reservoirs","Treatment","Water Rights","Streams & Habitats","Ditches and Diversions"]
[]
[null,null,"Project Start (MONTH-YY)"]
[null,null,"Project Completion (MONTH-YY)"]
[null,null,"Construction Period",null,null,{"$f":"IF(AND(ISBLANK(F27),ISBLANK(F28)),\"-\",YEARFRAC(F27,F28,1))","v":"-"},"years"]
[null,null,"Base Construction Cost Time Period",null,null,2017]
[null,null,"Project Construction Start Time Period",null,null,2017]
[null,null,"Estimated Project Useful Life",null,null,50,"years"]
[null,null,"Annual-Average Water Supply Yield",null,null,null,"ac-ft/yr"]
[]
[null,null,"Project Development Costs"]
[null,null,"Engineering Services",null,null,null,0.2,"% of Capital Costs"]
[null,null,"Surveying",null,null,null,0.01,"% of Capital Costs"]
[null,null,"Legal Service",null,null,null,0.1,"% of Capital Costs"]
[null,null,"Financing and Bond Assistance",null,null,null,0.01,"% of Capital Costs"]
[null,null,"Environmental and Cultural Studies",null,null,null,0.01,"% of Capital Costs"]
[null,null,"Required Land Acquisition",null,null,null,null,"acres"]
[null,null,"Land Acquisition Cost",null,null,null,null,"$ per acre"]
[null,null,"Permitting",null,null,null,0.01,"% of Capital Costs"]
[null,null,"Interest During Construction",null,null,null,0.04]
[]
[null,null,"Annual Costs"]
[null,null,"Debt Service ",null,null,null,5.5E-2,"% of Capital Costs"]
[null,null,"Debt Service (Non-Reservoirs) Period",null,null,null,20,"Years"]
[null,null,"Debt Service (Reservoirs) Period",null,null,null,40,"Years"]
[null,null,"Operations & Maintenance (Pipelines & Well Fields)",null,null,null,0.01,"% of Capital Costs"]
[null,null,"Operations & Maintenance (Pump Stations)",null,null,null,2.5000000000000001E-2,"% of Capital Costs"]
[null,null,"Operations & Maintenance (Reservoirs)",null,null,null,1.4999999999999999E-2,"% of Capital Costs"]
[null,null,"Operations & Maintenance (Ditches and Diversions & Streams and Habitat)",null,null,null,0.01,"% of Capital Costs"]
[null,null,"Rate of Return on Investments",null,null,null,0.01]
[null,null,"Annual Interest Rate (Non-Reservoirs)",null,null,null,5.5E-2]
[null,null,"Annual Interest Rate (Reservoirs)",null,null,null,5.5E-2]
[null,null,"Power Costs",null,null,null,0.11,"$ per kilowatt-hour"]
[]
[null,null,"Pumps"]
[null,null,"Power Connection Costs - Pump Stations",null,null,null,150,"$ per horsepower"]

{"sheet":"Pipelines","index":2,"n_rows":139,"n_cols":12,"rows_kept":139,"cut":false,"hidden":false,"merged":[[2,0,3,22],[124,11,124,14],[6,2,6,12],[76,7,77,7],[110,7,111,7],[42,7,43,7],[56,11,56,14],[90,11,90,14],[21,2,21,17]]}
[]
[]
["  P i p e l i n e s"]
[]
[]
[null,null,"Pipeline and Pump Station Parameters"]
[null,null,"Pipeline Module may be used for all projects with a pipeline component. The main elements of a pipeline project include the pipeline, pump stations and storage at the pump station.  Three segments are available to cost out different pipe/pump parameters."]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- Based on typical water composition, terrain and use in Colorado, Ductile Iron Pipe is assumed for all pipeline calculations and costing."]
[null,null,"- Calculations and costs assume an average of 6ft of cover over the length of the pipeline."]
[null,null,"- Calculations and costs assume an average of 2500ft between valves in the pipeline. Bends are not considered."]
[null,null,"- The number of pump stations needed is estimated based on the total dynamic head over the entire pipeline divided by the maximum allowable head, and the power required is evenly divided over the number of pump stations."]
[null,null,"- If user selects \"Intake\" as pump type, first pump is assumed intake and any additional required pumps for the segment are assumed to be booster pumps"]
[null,null,"- Storage requirements are provided by the user, but a recommended value is 10% of the average daily flow"]
[null,null,"-Use of multiple segments is not required and only necessary if there is a change in project yield, peaking factor or diameter along the pipeline length. Multiple segments may also be used if the user wants to control the number and distribution    of pump stations along the project. Inputs or calculations do not transfer from one segment to another. They can, however, be used as independent calculations that combine into a single, total cost estimate."]
[]
[null,null,"Abbreviations"]
[null,null,"ac-ft/yr","-","acre feet per year"]
[null,null,"cfs","-","cubic feet per year"]
[null,null,"ft","-","feet"]
[null,null,"ft-msl","-","feet - mean sea level"]
[null,null,"fps","-","feet per second"]
[null,null,"HP","-","horsepower"]
[null,null,"HGL","-","Hydraulic Grade Line"]
[null,null,"in","-","inches"]
[null,null,"kW-hr","-","kilowatt-hour"]
[null,null,"MG","-","million gallons"]
[null,null,"mgd","-","million gallons per day"]
[null,null,"psi","-","pounds per square inch"]
[null,null,"TDH","-","Total Dynamic Head"]
[]
[null,null,"Pipe Segment 1"]
[]
[null,null,null,null,"Pipeline Information"]
[null,null,null,null,null,null,"Ground Elevation \n(ft-msl)","Environment",null,"Water Delivered","Desired Head at End of Pipe\n (psi)","Maximum Pipeline Pressure \n(psi)"]
[null,null,null,null,"Pipeline Start",null,null,null,null,"Raw"]
[null,null,null,null,"Pipeline End"]
[]
[null,null,null,null,"Pipeline Diameter"]
[null,null,null,null,"If desired discharge and velocity are known and required diameter is unknown"]
[null,null,null,null,"Total Project Yield",null,null,null,"ac-ft/yr"]
[null,null,null,null,"Peaking Factor, PF"]
[null,null,null,null,"Peak Flow through Pipeline, q",null,null,{"$f":"G62*MGD_CFS","v":0},"cfs"]
[null,null,null,null,"Velocity of Flow, V",null,null,5,"fps",{"$f":"IF(H51<>5,\"Default Value = 5\",\"\")","v":""}]
[null,null,null,null,"Required Diameter",null,null,{"$f":"IFERROR(((4*H50/(H51*PI()))^0.5)*FT_IN,\"-\")","v":0},"in"]
[]
[null,null,null,null,"Pipe Hydraulics"]
[null,null,null,null,"Nominal Pipe Size, d",null,null,null,"in","If pipe diameter was determined using the Pipeline Diameter calculator, round up to the nearest pipe size"]
[null,null,null,null,"Pipeline Length, L",null,null,null,"ft"]
[null,null,null,null,"Hazen-Williams C Factor",null,null,140,{"$f":"IF(H57<>140,\"Default Value = 140 or Link to reference table ---->\",\"\")","v":""},null,null,"Click Here for C Factor Roughness Reference Table "]
[null,null,null,null,"Maintenance Downtime",null,null,0.05,"for Uniform Delivery, PF = 1",null,{"$f":"IF(H58<>0.05,\"Default Value = 5%\",\"\")","v":""}]
[]
[null,null,null,null,"Flow"]
[null,null,null,null,"Average Flow\n(mgd)","Average Flow\n(cfs)","Peak Flow (mgd)","Peak Flow (cfs)","Velocity \n(fps)"]
[null,null,null,null,{"$f":"$H$48/MG_ACFT/YR_DAY","v":0},{"$f":"E62*MGD_CFS","v":0},{"$f":"IF(Pipe_PF1>1,E62*Pipe_PF1,E62/(1-Pipe_DT1))","v":0},{"$f":"G62*MGD_CFS","v":0},{"$f":"IFERROR($H$62*4/PI()/(Pipe_d1/FT_IN)^2,\"-\")","v":"-"}]
[]
[null,null,null,null,"Pump Station Hydraulics"]
[null,null,null,null,"Pump Type"]
[null,null,null,null,"Pump Efficiency ",null,null,0.7,"(Mechanical & Electrical)",null,{"$f":"IF(H66<>0.7,\"Default Value = 0.7\",\"\")","v":""}]
[]
[null,null,null,null,"Pump Requirements"]
[null,null,null,null,"Static Head (ft)","Total Dynamic Head (ft)","Total Power Needs \n(HP)","Number of Pump Stations Needed in Series","HP per Pump Station","HP Needed for Average Flow","Total Pumping Energy \n(kW-hr)","Storage Volume Requirement (MG)"]
[null,null,null,null,{"$f":"(G44-G43)+(K44/FTH20_PSI)","v":0},{"$f":"IFERROR(E70+(10.4*Pipe_L1*(G62*MG_GAL/DAY_MIN)^1.852)/(Pipe_C1^1.852*Pipe_d1^4.8655),\"-\")","v":"-"},{"$f":"IFERROR((F70*G62*MG_GAL/DAY_MIN)/(gpmft_HP*$H66),\"-\")","v":"-"},{"$f":"IFERROR(IF(F70<0,0,ROUNDUP(F70/(L43/FTH20_PSI),0)),\"-\")","v":"-"},{"$f":"IFERROR(G70/H70,\"-\")","v":"-"},{"$f":"IF(F70<0,0,IFERROR((F70*E62*MG_GAL/DAY_MIN)/(gpmft_HP*$H66),\"-\"))","v":"-"},{"$f":"IFERROR(IF(ISERR(J70),0,(J70*HP_kW*(YR_DAY-(YR_DAY*Pipe_DT1)) *DAY_HR)),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,{"$f":"IF(E70<0,\"Gravity System\",\"\")","v":""}]
[]
[null,null,"Pipe Segment 2"]
[]
[null,null,null,null,"Pipeline Information"]
[null,null,null,null,null,null,"Ground Elevation \n[ft-msl]","Environment",null,"Water Delivered","Residual Head at End of Pipe\n (psi)","Maximum Pipeline Pressure \n(psi)"]
[null,null,null,null,"Pipeline Start",null,null,null,null,"Raw"]
[null,null,null,null,"Pipeline End"]
[]
[null,null,null,null,"Pipeline Diameter"]
[null,null,null,null,"If desired discharge and velocity are known and required diameter is unknown"]
[null,null,null,null,"Total Project Yield",null,null,null,"ac-ft/yr"]
[null,null,null,null,"Peaking Factor, PF"]
[null,null,null,null,"Peak Flow through Pipeline, q",null,null,{"$f":"G96*MGD_CFS","v":0},"cfs"]
[null,null,null,null,"Velocity of Flow, V",null,null,5,"fps",{"$f":"IF(H85<>5,\"Default Value = 5\",\"\")","v":""}]
[null,null,null,null,"Required Diameter",null,null,{"$f":"IFERROR(((4*H84/(H85*PI()))^0.5)*FT_IN,\"-\")","v":0},"in"]
[]
[null,null,null,null,"Pipe Hydraulics"]
[null,null,null,null,"Nominal Pipe Size, d",null,null,null,"in","If pipe diameter was determined using the Pipeline Diameter calculator, round up to the nearest pipe size"]
[null,null,null,null,"Pipeline Length, L",null,null,null,"ft"]
[null,null,null,null,"Hazen-Williams C Factor",null,null,140,{"$f":"IF(H91<>140,\"Default Value = 140 or Link to reference table ---->\",\"\")","v":""},null,null,"Click Here for C Factor Roughness Reference Table "]
[null,null,null,null,"Maintenance Downtime",null,null,0.05,"for Uniform Delivery, PF = 1",null,{"$f":"IF(H92<>0.05,\"Default Value = 5%\",\"\")","v":""}]
[]
[null,null,null,null,"Flow"]
[null,null,null,null,"Average Flow\n(mgd)","Average Flow\n(cfs)","Peak Flow (mgd)","Peak Flow (cfs)","Velocity \n(fps)"]
[null,null,null,null,{"$f":"H82/MG_ACFT/YR_DAY","v":0},{"$f":"E96*MGD_CFS","v":0},{"$f":"IF(Pipe_PF2>1,E96*Pipe_PF2,E96/(1-Pipe_DT2))","v":0},{"$f":"G96*MGD_CFS","v":0},{"$f":"IFERROR(H96*4/PI()/(Pipe_d2/FT_IN)^2,\"-\")","v":"-"}]
[]
[null,null,null,null,"Pump Station Hydraulics"]
[null,null,null,null,"Pump Type",null,null,null,{"$f":"IF(AND($H$65=\"intake\",H99=\"intake\"),\"Intake pump already selected for Segment 1, confirm this is another intake or switch to booster pump\",\"\")","v":""}]
[null,null,null,null,"Pump Efficiency ",null,null,0.7,"(Mechanical & Electrical)",null,{"$f":"IF(H100<>0.7,\"Default Value = 0.7\",\"\")","v":""}]
[]
[null,null,null,null,"Pump Requirements"]
[null,null,null,null,"Static Head (ft)","Total Dynamic Head (ft)","Total Power Needs \n(HP)","Number of Pump Stations Needed in Series","HP per Pump Station","HP Needed for Average Flow","Total Pumping Energy \n(kW-hr)","Storage Volume Requirement (MG)"]
[null,null,null,null,{"$f":"(Grnd_Elev_End2-Grnd_Elev_Start2)+(K78/FTH20_PSI)","v":0},{"$f":"IFERROR(E104+(10.4*Pipe_L2*(G96*MG_GAL/DAY_MIN)^1.852)/(Pipe_C2^1.852*Pipe_d2^4.8655),\"-\")","v":"-"},{"$f":"IFERROR((F104*G96*MG_GAL/DAY_MIN)/(gpmft_HP*$H100),\"-\")","v":"-"},{"$f":"IFERROR(IF(F104<0,0,ROUNDUP(F104/(L77/FTH20_PSI),0)),\"-\")","v":"-"},{"$f":"IFERROR(G104/H104,\"-\")","v":"-"},{"$f":"IF(F104<0,0,IFERROR((F104*E96*MG_GAL/DAY_MIN)/(gpmft_HP*$H100),\"-\"))","v":"-"},{"$f":"IFERROR(IF(ISERR(J104),0,(J104*HP_kW*(YR_DAY-(YR_DAY*Pipe_DT2)) *DAY_HR)),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,{"$f":"IF(E104<0,\"Gravity System\",\"\")","v":""}]
[]
[null,null,"Pipe Segment 3"]
[]
[null,null,null,null,"Pipeline Information"]
[null,null,null,null,null,null,"Ground Elevation \n[ft-msl]","Environment",null,"Water Delivered","Residual Head at End of Pipe\n (psi)","Maximum Pipeline Pressure \n(psi)"]
[null,null,null,null,"Pipeline Start"]
[null,null,null,null,"Pipeline End"]
[]
[null,null,null,null,"Pipeline Diameter"]
[null,null,null,null,"If desired discharge and velocity are known and required diameter is unknown"]
[null,null,null,null,"Total Project Yield",null,null,null,"ac-ft/yr"]
[null,null,null,null,"Peaking Factor, PF"]
[null,null,null,null,"Peak Flow through Pipeline, q",null,null,{"$f":"G130*MGD_CFS","v":0},"cfs"]
[null,null,null,null,"Velocity of Flow, V",null,null,5,"fps",{"$f":"IF(H119<>5,\"Default Value = 5\",\"\")","v":""}]
[null,null,null,null,"Required Diameter",null,null,{"$f":"IFERROR(((4*H118/(H119*PI()))^0.5)*FT_IN,\"-\")","v":0},"in"]
[]
[null,null,null,null,"Pipe Hydraulics"]
[null,null,null,null,"Nominal Pipe Size, d",null,null,null,"in","If pipe diameter was determined using the Pipeline Diameter calculator, round up to the nearest pipe size"]
[null,null,null,null,"Pipeline Length, L",null,null,null,"ft"]
[null,null,null,null,"Hazen-Williams C Factor",null,null,140,{"$f":"IF(H125<>140,\"Default Value = 140 or Link to reference table ---->\",\"\")","v":""},null,null,"Click Here for C Factor Roughness Reference Table "]
[null,null,null,null,"Maintenance Downtime",null,null,0.05,"for Uniform Delivery, PF = 1",null,{"$f":"IF(H126<>0.05,\"Default Value = 5%\",\"\")","v":""}]
[]
[null,null,null,null,"Flow"]
[null,null,null,null,"Average Flow\n(mgd)","Average Flow\n(cfs)","Peak Flow (mgd)","Peak Flow (cfs)","Velocity \n(fps)"]
[null,null,null,null,{"$f":"H116/MG_ACFT/YR_DAY","v":0},{"$f":"E130*MGD_CFS","v":0},{"$f":"IF(Pipe_PF3>1,E130*Pipe_PF3,E130/(1-Pipe_DT3))","v":0},{"$f":"G130*MGD_CFS","v":0},{"$f":"IFERROR(H130*4/PI()/(Pipe_d3/FT_IN)^2,\"-\")","v":"-"}]
[]
[null,null,null,null,"Pump Station Hydraulics"]
[null,null,null,null,"Pump Type",null,null,null,{"$f":"IF(AND($H$65=\"intake\",H133=\"intake\"),\"Intake pump already selected for Segment 1, confirm this is another intake or switch to booster pump\",\"\")","v":""}]
[null,null,null,null,"Pump Efficiency ",null,null,0.7,"(Mechanical & Electrical)",null,{"$f":"IF(H134<>0.7,\"Default Value = 0.7\",\"\")","v":""}]
[]
[null,null,null,null,"Pump Requirements"]
[null,null,null,null,"Static Head (ft)","Total Dynamic Head (ft)","Total Power Needs \n(HP)","Number of Pump Stations Needed in Series","HP per Pump Station","HP Needed for Average Flow","Total Pumping Energy \n(kW-hr)","Storage Volume Requirement (MG)"]
[null,null,null,null,{"$f":"(G112-G111)+(K112/FTH20_PSI)","v":0},{"$f":"IFERROR(E138+(10.4*Pipe_L3*(G130*MG_GAL/DAY_MIN)^1.852)/(Pipe_C3^1.852*Pipe_d3^4.8655),\"-\")","v":"-"},{"$f":"IFERROR((F138*G130*MG_GAL/DAY_MIN)/(gpmft_HP*$H134),\"-\")","v":"-"},{"$f":"IFERROR(IF(F138<0,0,ROUNDUP(F138/(L111/FTH20_PSI),0)),\"-\")","v":"-"},{"$f":"IFERROR(G138/H138,\"-\")","v":"-"},{"$f":"IF(F138<0,0,IFERROR((F138*E130*MG_GAL/DAY_MIN)/(gpmft_HP*$H134),\"-\"))","v":"-"},{"$f":"IFERROR(IF(ISERR(J138),0,(J138*HP_kW *(YR_DAY-(YR_DAY*Pipe_DT3)) *DAY_HR)),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,{"$f":"IF(E138<0,\"Gravity System\",\"\")","v":""}]

{"sheet":"Well Fields","index":3,"n_rows":93,"n_cols":18,"rows_kept":93,"cut":false,"hidden":false,"merged":[[21,2,21,8],[14,13,17,13],[18,13,20,13],[52,2,52,3],[2,0,3,22],[76,13,76,17],[90,14,91,14],[90,15,91,15],[75,13,75,17],[10,13,11,13],[21,13,24,13],[53,14,53,15],[58,2,58,8],[40,14,40,17],[58,10,58,12],[12,13,13,13],[16,2,16,8],[20,2,20,8]]}
[]
[]
["  W e l l   F i e l d s"]
[]
[]
[null,null,"Well Fields Parameters",null,null,null,null,null,null,"Well Field Reference Schematic"]
[null,null,"Module may be used for public water supply, irrigation or ASR well fields. Use schematic to the right and user guide to understand the various inputs.",null,null,null,null,null,null,null,null,null,"Legend"]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"},null,null,null,null,null,null,null,null,null,"Symbol","Description","Relevant Calculations"]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"},null,null,null,null,null,null,null,null,null,null,"Main Transmission Pipe","Calculated Well Parameters"]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"},null,null,null,null,null,null,null,null,null,null,null,"Well Field Piping Parameters"]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"},null,null,null,null,null,null,null,null,null,null,"Well Collector Pipe"]
[]
[null,null,"Assumptions",null,null,null,null,null,null,null,null,null,null,"Well","Well Hydraulics"]
[null,null,"- Operational parameters are not considered",null,null,null,null,null,null,null,null,null,null,null,"Well Parameters"]
[null,null,"- Well Field consists of a main transmission line with wells connecting individually to that line; the pipelines from the well to the main transmission line are short enough to be negligible in the costs. If the user requires costs for these lines, the Pipelines Module may be used, or additional external costs may be added in the Costing Module."]
[null,null,"- There is a booster pump at each Transmission Line node unless the power needed is zero",null,null,null,null,null,null,null,null,null,null,null,"Well Field Pump Parameters"]
[null,null,"- Calculated well depth assumes an additional 50 feet below the drawdown level; this value is hard-coded and not adjustable by the user.",null,null,null,null,null,null,null,null,null,null,"Node","Calculated Well Parameters"]
[null,null,"- Calculations regarding capacity and depth per well assume uniformity across the well field, but the user may input more detailed information if available."]
[null,null,"- ASR well fields are included and assumed to be constructed similar to other well fields. Greater cost curves are used to differentiate the cost of an ASR project. Additional assumptions for ASR well fields include the following:",null,null,null,null,null,null,null,null,null,null,null,"Booster Pump Parameters"]
[null,null,"  1. Transmission of the water to be injected from the source to the well field is not included. This may be costed separately using the Pipelines Module.\n  2. The tool only includes the costs for new wells. Retro-fitting existing wells to be used for ASR has a lower cost and should be considered on a case-by-case basis.\n  3. Pre- or post-treatment costs are not included. User may consider using the Treatment Module for additional treatment costs.\n  4. Recharge is assumed as a gravity feed into the well. Additional cost of pumps and operations would need to be added if recharge water must be pumped into the well under pressure.",null,null,null,null,null,null,null,null,null,null,"Final Delivery Point (at node n)","Calculated Well Parameters"]
[]
[null,null,"Abbreviations"]
[null,null,"ac-ft/yr","-","acre feet per year"]
[null,null,"cfs","-","cubic feet per year"]
[null,null,"ft","-","feet"]
[null,null,"ft-msl","-","feet - mean sea level"]
[null,null,"fps","-","feet per second"]
[null,null,"gpm","-","gallons per minute"]
[null,null,"HP","-","horsepower"]
[null,null,"in","-","inches"]
[null,null,"kW-hr","-","kilowatt-hour"]
[null,null,"psi","-","pounds per square inch"]
[null,null,"TDH","-","Total Dynamic Head"]
[]
[]
[]
["Well and Pump Calculator and Cost Inputs"]
[]
[null,null,"Well Field Information",null,null,"Well and Pump Hydraulics",null,null,null,"Calculated Well Parameters",null,null,null,null,"Well Parameter Cost Inputs\nUser inputs can use calculated parameters or be user defined, but should match or exceed the calculated capacity requirements"]
[null,null,"Well Type: ",null,null,null,"Average Flow Per Well (gpm): ",null,null,"Required Wells","Well Head Elevation (ft-msl)","Calculated Depth (ft)*","Calculated Peak Capacity (gpm)",null,"Well Number","Calculated Depth (ft)*","Calculated Peak Capacity (gpm)","Quantity"]
[null,null,"Average Static water elevation (ft-msl): ",null,null,null," Peak Flow Per Well (gpm): ",{"$f":"IF(ISBLANK(H42),\"-\",(D47*H42))","v":"-"},null,{"$f":"IF($H$46>0,1,\"\")","v":""},null,{"$f":"IF(OR(J43=\"\",K43=\"\"),\"\",(K43-($D$43-$D$44))+50)","v":""},{"$f":"IF(J43=\"\",\"\",$H$43)","v":""},null,{"$f":"IF(P43=\"\",\"\",1)","v":""},null,null,1]
[null,null,"Drawdown (ft): ",null,null,null,"Average Flow Per Well (cfs): ",{"$f":"IF(ISBLANK(H42),\"-\",(H42/CFS_GPM))","v":"-"},null,{"$f":"IF($H$46>1,2,\"\")","v":""},null,{"$f":"IF(OR(J44=\"\",K44=\"\"),\"\",(K44-($D$43-$D$44))+50)","v":""},"",null,{"$f":"IF(P44=\"\",\"\",2)","v":""},null,null,1]
[null,null,"Total Project Yield (ac-ft/yr): ",null,null,null," Peak Flow Per Well (cfs): ",{"$f":"IFERROR(H43/CFS_GPM,\"-\")","v":"-"},null,{"$f":"IF($H$46>2,3,\"\")","v":""},null,"","",null,{"$f":"IF(P45=\"\",\"\",3)","v":""},null,null,1]
[null,null,"Average Daily Well Field Yield (mgd): ",{"$f":"D45*AC_SQFT*CF_GAL/YR_DAY/MG_GAL","v":0},null,null," Number of Required Active Wells: ",{"$f":"IFERROR(ROUNDUP((D46*D47*MG_GAL/DAY_MIN)/H43,0),0)","v":0},null,{"$f":"IF($H$46>3,4,\"\")","v":""},null,"","",null,{"$f":"IF(P46=\"\",\"\",4)","v":""},null,null,1]
[null,null,"Peaking Factor: ",null,null,null,"% Operating Time: ",{"$f":"IFERROR(D46/(H46*H43*DAY_MIN/MG_GAL),\"-\")","v":"-"},null,{"$f":"IF($H$46>4,5,\"\")","v":""},null,"","",null,{"$f":"IF(P47=\"\",\"\",5)","v":""},null,null,1]
[null,null,"Well Column Velocity (fps):",8,{"$f":"IF(D48<>8,\"Default Value = 8\",\"\")","v":""},null,"Average Well Head Elevation (ft-msl): ",{"$f":"IFERROR(AVERAGEIF(K43:K52,\">0\"),\"-\")","v":"-"},null,{"$f":"IF($H$46>5,6,\"\")","v":""},null,"","",null,{"$f":"IF(P48=\"\",\"\",6)","v":""},null,null,1]
[null,null,"Elevation of Delivery Point (ft-msl): ",null,null,null,"Average Depth to GW (ft): ",{"$f":"IFERROR(H48-D43,\"-\")","v":"-"},null,{"$f":"IF($H$46>6,7,\"\")","v":""},null,"","",null,{"$f":"IF(P49=\"\",\"\",7)","v":""},null,null,1]
[null,null,"Residual Head at Delivery Point (psi):",null,null,null,"Well Column Losses (ft): ",{"$f":"IFERROR((10.4*AVERAGE(P43:P52)*H43^1.852)/(D52^1.852*(24*(H45/(D48*PI()))^0.5)^4.8655),\"-\")","v":"-"},null,{"$f":"IF($H$46>7,8,\"\")","v":""},null,"","",null,{"$f":"IF(P50=\"\",\"\",8)","v":""},null,null,1]
[null,null,"Efficiency (Mechanical & Electrical): ",0.7,{"$f":"IF(D51<>0.7,\"Default Value = 0.7\",\"\")","v":""},null,"Average TDH (ft): ",{"$f":"IFERROR(H49+D44+H50,\"-\")","v":"-"},null,{"$f":"IF($H$46>8,9,\"\")","v":""},null,"","",null,{"$f":"IF(P51=\"\",\"\",9)","v":""},null,null,1]
[null,null,"Hazen Williams C Factor: ",140,{"$f":"IF(D52<>140,\"Default Value = 140\",\"\")","v":""},null,"Average Well Pump Requirement (HP): ",{"$f":"IFERROR((H51*H42)/(gpmft_HP*$D$51),\"-\")","v":"-"},null,{"$f":"IF($H$46>9,10,\"\")","v":""},null,"","",null,{"$f":"IF(P52=\"\",\"\",10)","v":""},null,null,1]
[null,null,"Click Here for C Factor Roughness Reference Table",null,null,null,"Total Well Pump Requirement (HP): ",{"$f":"IFERROR(H52*H46,\"-\")","v":"-"},null,"*Assumes 50 feet below the drawdown level",null,null,null,null,"Total Well Field Capacity (gpm)",null,{"$f":"IF(SUM(Q43:Q52)=0,\"-\",SUMPRODUCT(Q43:Q52,R43:R52))","v":"-"},{"$f":"IF(Q53<Q54,\"INCREASE WELL FIELD CAPACITY\",\"\")","v":""}]
[null,null,null,null,null,null,"Average Energy Usage per Well (kW-hr): ",{"$f":"IFERROR(ROUND(H52*HP_kW*YR_HR*H47,-2),\"-\")","v":"-"},null,null,null,null,null,null,"Total Required Well Field Capacity (gpm)",null,{"$f":"IFERROR(H43*H46,\"-\")","v":"-"}]
[null,null,null,null,null,null,"Total Energy Usage for All Wells (kW-hr): ",{"$f":"IFERROR(ROUND(H54*H46,-2),\"-\")","v":"-"}]
[]
["Pipeline Calculator and Cost Inputs"]
[]
[null,null,"Well Field Piping Parameters\nCalculates required pipe diameter and booster pump capacity for conveying water along main well field transmission line to delivery point",null,null,null,null,null,null,null,"Well Field Piping Parameter Cost Inputs \nPull from user inputs in Well Field Piping Parameters table"]
[null,null,"US Node/ Pipe Number","Flow (gpm)","Peak Flow \n(cfs)","Computed Diameter for 5 fps\n (in)","Selected Diameter (in)","Velocity \n(fps)","Length (ft)",null,"Pipe Size (in)","Environment","Pipe Length (ft)"]
[null,null,{"$f":"IF(O43=\"\",\"\",O43)","v":""},{"$f":"IF(Q43=\"\",\"\",Q43)","v":""},{"$f":"IF(D61=\"\",\"\",D61/CFS_GPM)","v":""},{"$f":"IF(E61=\"\",\"\",((4*E61/(5*PI()))^0.5)*FT_IN)","v":""},null,{"$f":"IFERROR(IF(C61=\"\",\"\",E61*4/PI()/(G61/FT_IN)^2),\"-\")","v":""},null,null,{"$f":"IF(ISBLANK(G61),\"\",G61)","v":""},null,{"$f":"IF(ISBLANK(I61),\"\",I61)","v":""}]
[null,null,{"$f":"IF(O44=\"\",\"\",O44)","v":""},{"$f":"IF(Q44=\"\",\"\",Q44+D61)","v":""},"","",null,"",null,{"$f":"IF(AND(ISNUMBER(G62),G62<G61),\"CHECK DIAMETER\",\"\")","v":""},"",{"$f":"IF(OR(K62=\"\",ISBLANK(L61)),\"\",L61)","v":""},""]
[null,null,{"$f":"IF(O45=\"\",\"\",O45)","v":""},{"$f":"IF(Q45=\"\",\"\",Q45+D62)","v":""},"","",null,"",null,{"$f":"IF(AND(ISNUMBER(G63),G63<G62),\"CHECK DIAMETER\",\"\")","v":""},"",{"$f":"IF(K63=\"\",\"\",L62)","v":""},""]
[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,null,"","","","",null,"",null,"","","",""]
[]
[null,null,"Totals",null,{"$f":"LOOKUP(2,1/(($E$61:$E$70)<>0),$E$61:$E$70)","v":""},null,null,null,{"$f":"SUM(I61:I70)","v":0}]
[]
["Booster Pump Calculator and Cost Inputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H75),\"\",K90*0.746*8760*$J$13)","v":""}]
[null,null,"Well Field Pipeline Booster Pump Requirements",null,null,null,null,null,null,null,null,null,null,"Booster Pump Parameters"]
[null,null,"Calculates required booster pump capacity for conveying water along main well field transmission line to delivery point",null,null,null,null,null,null,null,null,null,null,"User inputs can use Calculated Booster Pump Inputs or be User-defined, but should match or exceed the Total Required Capacity and TDH requirements"]
[null,null,"US Node/ Pipe Number","Capacity (gpm)","Well Head Elevation (ft-msl)","DS Well/ Pipe Node","DS Elevation Well/Pipe (ft)","Elevation Delta \n(ft)","Segment Pipe Head Loss (ft)","TDH \n(ft)","Power\n(HP)","Energy\n(kW-hr)",null,"Pump Number","Pump Capacity\n(gpm)","Pump TDH\n(ft)","Power\n(HP)","Energy\n(kW-hr)"]
[null,null,{"$f":"IF(C61=\"\",\"\",C61)","v":""},{"$f":"IF(D61=\"\",\"\",D61)","v":""},null,{"$f":"IF(C61=\"\",\"\",C62)","v":""},{"$f":"IF(E80=\"\",IF(E79=\"\",\"\",$D$49),E80)","v":""},{"$f":"IF(E79=\"\",\"\",G79-E79)","v":""},{"$f":"IFERROR(IF(C61=\"\",\"\",(10.4*I61*(D61)^1.852)/(WellHazenWill^1.852*G61^4.8655)),\"\")","v":""},{"$f":"IFERROR(IF(C79=\"\",\"\",IF(I79+H79<0,0,I79+H79)),\"\")","v":""},{"$f":"IFERROR(IF(C79=\"\",\"\",(D79*J79)/(gpmft_HP*$D$51)),\"\")","v":""},{"$f":"IFERROR(IF(C79=\"\",\"\",K79*HP_kW*YR_HR*$H$47),\"\")","v":""},null,1,null,null,{"$f":"IF(O79=\"\",\"\",(O79*P79)/(gpmft_HP*$D$51))","v":""},{"$f":"IFERROR(Q79*0.746*8760*$H$47,\"-\")","v":"-"}]
[null,null,"","",null,"",{"$f":"IF(E81=\"\",IF(E80=\"\",\"\",$D$49),E81)","v":""},{"$f":"IF(E80=\"\",\"\",G80-E80)","v":""},{"$f":"IFERROR(IF(C62=\"\",\"\",(10.4*I62*(D62)^1.852)/(WellHazenWill^1.852*G62^4.8655)),\"\")","v":""},{"$f":"IFERROR(IF(C80=\"\",\"\",IF(I80+H80<0,0,I80+H80)),\"\")","v":""},"","",null,2,null,null,"","-"]
[null,null,"","",null,"","","","","","","",null,3,null,null,"","-"]
[null,null,"","",null,"",{"$f":"IF(E83=\"\",IF(E82=\"\",\"\",$D$49),E83)","v":""},"","","","","",null,4,null,null,"","-"]
[null,null,"","",null,"",{"$f":"IF(E84=\"\",IF(E83=\"\",\"\",$D$49),E84)","v":""},"","","",{"$f":"IFERROR(IF(C83=\"\",\"\",(D83*J83)/(gpmft_HP*$D$51)),\"\")","v":""},"",null,5,null,null,"","-"]
[null,null,"","",null,"","","","","","","",null,6,null,null,"","-"]
[null,null,"","",null,"",{"$f":"IF(E86=\"\",IF(E85=\"\",\"\",$D$49),E86)","v":""},"","","","","",null,7,null,null,"",{"$f":"IFERROR(Q85*0.746*8760*$H$47,\"-\")","v":"-"}]
[null,null,"","",null,"","","","","","","",null,8,null,null,"","-"]
[null,null,"","",null,"","","","","","","",null,9,null,null,"","-"]
[null,null,"","",null,{"$f":"IF(C70=\"\",\"\",\"Delivery Point\")","v":""},"","","","","","",null,10,null,null,"","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(SUM(O79:O88)=0,\"-\",SUM(O79:O88))","v":"-"},{"$f":"IF(SUM(P79:P88)=0,\"-\",SUM(P79:P88))","v":"-"},{"$f":"IFERROR(IF(O89=\"\",\"\",(O89*0.0023)*P89/8.8/0.8),\"-\")","v":"-"},{"$f":"IFERROR(Q89*0.746*8760*$H$47,\"-\")","v":"-"}]
[null,null,"Totals",null,null,null,null,{"$f":"_xlfn.IFNA(LOOKUP(2,1/(($H$79:$H$88)<\"\"),$H$79:$H$88),\"-\")","v":"-"},null,{"$f":"IF(SUM(J79:J88)=0,\"-\",SUM(J79:J88))","v":"-"},{"$f":"IF(SUM(K79:K88)=0,\"-\",SUM(K79:K88))","v":"-"},{"$f":"IF(SUM(L79:L88)=0,\"-\",SUM(L79:L88))","v":"-"},null,"Total Required",{"$f":"Q54","v":"-"},{"$f":"J90","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O90=\"-\",\"\",IF(O89<O90,\"INCREASE PUMP CAPACITY\",\"\"))","v":""},{"$f":"IF(P90=\"-\",\"\",IF(P89<P90,\"INSUFFICIENT TDH\",\"\"))","v":""}]
[null,null,"Maximum Pipeline Pressure (psi)",{"$f":"IFERROR((J90)*FTH20_PSI+D50,\"-\")","v":"-"}]
[null,null,"Calculated Number of Booster Pumps",{"$f":"IFERROR(ROUNDUP((J90*FTH20_PSI/D92),0),0)","v":0}]

{"sheet":"Reservoirs","index":4,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,5,35,12],[34,2,34,12],[36,6,36,8],[2,0,3,22]]}
[]
[]
["  R e s e r v o i r s"]
[]
[]
[null,null,"Reservoir Parameters"]
[null,null,"Module may be used for new reservoir, reservoir expansion, or reservoir rehabilitation projects."]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- Only in-line reservoir options (new and expansion) are included. "]
[null,null,"- Transmission of water from a natural source to the basin is not included. Users may cost out a project requiring reservoir transmission by combining costs from the Pipelines Module with the cost of reservoir construction."]
[null,null,"- Land acquisition is estimated by the user in the Global Inputs Module. Most reservoir projects will require land acquisition. The user should include an estimate of land area required in the Global Inputs Module."]
[null,null,"- Only New Storage Volume is used for Cost Estimation"]
[null,null,"- Hydropower does not affect total project cost"]
[]
[null,null,"Abbreviations"]
[null,null,"ac-ft","-","acre-Feet"]
[null,null,"gpm","-","gallons per minute"]
[null,null,"HP","-","horsepower"]
[null,null,"kW-hrs","-","Kilowatt-Hours"]
[]
[]
[null,null,"Reservoir Project Parameters"]
[null,null,"Project Type"]
[null,null,"New Storage Volume",null,null,null,"ac-ft"]
[null,null,"Existing Storage (enter 0 if New Reservoir project)",null,null,null,"ac-ft",{"$f":"IF(AND(F30=\"Reservoir Expansion\",OR(F32=\"\",F32=0)),\"EXISTING STORAGE EXPECTED\",\"\")","v":""}]
[null,null,"Total Storage (informational)",null,null,{"$f":"F31+F32","v":0},"ac-ft"]
[]
[null,null,"Reservoir Rehabilitation Project Parameters"]
[null,null,"Reservoir Rehabilitation Project Description"]
[null,null,"User-Defined Reservoir Rehabiliation Cost",null,null,null,"Click Here for Reservoir Rehab Cost Data Table "]
[]
[null,null,"Hydropower Option"]
[null,null,"Not factored into cost estimation"]
[null,null,"Height of Falling Water",null,null,null,"ft"]
[null,null,"Discharge",null,null,null,"gpm"]
[null,null,"Turbine Efficiency",null,null,0.9,{"$f":"IF(F43<>0.9,\"Default Value = 0.9\",\"\")","v":""},"Encompasses mechanical and electrical efficiency used in calculating power and energy production"]
[null,null,"Power",null,null,{"$f":"IFERROR((F41*F42)/(3960*F43),\"-\")","v":0},"HP"]
[null,null,"Annual Turbine Use Percentage",null,null,0.6,{"$f":"IF(F45<>0.6,\"Default Value = 0.6\",\"\")","v":""},"Percent of time over the year that a hydropower generation station will be utilized"]
[null,null,"Estimated Annual Energy Production",null,null,{"$f":"IFERROR(F44*0.7355*F45*365*24,\"-\")","v":0},"kW-hrs"]

{"sheet":"Treatment","index":5,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,0,3,22],[15,2,15,12],[16,2,16,12],[39,17,40,17],[38,2,38,17],[39,2,40,2],[39,3,39,9],[39,10,39,16]]}
[]
[]
["  T r e a t m e n t"]
[]
[]
[null,null,"Treatment Project Parameters"]
[null,null,"Module may be used for water treatment projects.  Users may leverage reference table at bottom of module to select treatment type based on project goals."]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- There are eight water treatment technologies provided in the tool. While the tool provides references to aid the user in determining the appropriate technology, it is assumed the user will be able to identify the appropriate technology for their community. The reference table is not intended for final treatment technology decision-making, but as a guiding tool for planning-level cost estimating.  "]
[null,null,"- Reference Table treatment thresholds were developed assuming end use of treated water is for potable uses. The tool may be used for the purposes of planning a non-potable reuse project; however, the water quality requirements for non-potable uses vary significantly depending on the industry. The most typical use of water treatment facilities is to meet municipal water need, and therefore was assumed to be the end-use for the purposes of this tool. "]
[null,null,"- Operations and Maintenance Costs are calculated for each type of treatment and include and estimation of energy requirements, therefore energy for treatment is not calculated separately"]
[null,null,"- Treatment costs were created assuming a range of accuracy of +50% and -30"]
[]
[]
[null,null,"Abbreviations"]
[null,null,"gpd","-","gallons per day"]
[null,null,"MCL","-","Maximum Contaminant Levels"]
[null,null,"mgd","-","million gallons per day"]
[null,null,"mg/L",null,"milligrams per liter"]
[null,null,"NTU",null,"Nephelometric Turbidity Unit"]
[null,null,"oocysts/L","-","bacteria indicating oocysts per Liter"]
[null,null,"TOC","-","Total Organic Carbon"]
[]
[null,null,"Treatment Type"]
[]
[null,null,"Treatment Capacity"]
[null,null,"Average Day Demand",null,null,null,"mgd"]
[null,null,"Peaking Factor"]
[null,null,"Required Capacity",null,null,{"$f":"F34*F35","v":0},"mgd"]
[]
[]
[null,null,"Reference Table"]
[null,null,"Treatment Type","Drivers/Thresholds for Treatment ",null,null,null,null,null,null,"Drivers/Approximate Numeric Thresholds for Treatment ",null,null,null,null,null,null,"Source Water Characteristics"]
[null,null,null,"Pathogens","TOC","Suspended Solids & Turbidity","Salinity","Hardness","Nutrients/Taste & Odor","Emerging Contaminants","Cryptosporidium (oocysts/L) ","TOC (mg/L)","Turbidity (NTU)","Chloride (mg/L)","Hardness as CaCO3 (mg/L)","Threshold Odor Number","Emerging Contaminants"]
[null,null,"Direct Filtration1","LOW","LOW","LOW","LOW","LOW","LOW","LOW","< 0.075 (Bin 1)","< 3","< 10","< 250","< 150","< 3","Not Detected or < Action Levels/MCLs","Pristine water quality, consistent with few excursions."]
[null,null,"Conventional1","MED","MED","MED","LOW","LOW","LOW","LOW","< 0.075  to < 1.0 (Bins 1 or 2)","> 3","> 10","< 250","< 150","< 3","Not Detected or < Action Levels/MCLs","Moderate-high quality water, moderate to high frequency of excursions."]
[null,null,"Conventional + Enhanced Coagulation","MED","MED-HIGH","MED-HIGH","LOW","LOW","LOW","LOW","<0.075  to < 1.0 (Bins 1 or 2)","> 3","> 10","< 250","< 150","< 3","Not Detected or < Action Levels/MCLs","High natural organic matter (NOM is precursor material to disinfection by-products, aka DBPs)."]
[null,null,"Conventional + Lime Softening","MED","MED-HIGH","MED-HIGH","LOW","HIGH","LOW","LOW","<0.075  to < 1.0 (Bins 1 or 2)","> 3","> 10","> 250","> 150","< 3","Not Detected or < Action Levels/MCLs","High hardness in source water, often accompanied by high NOM, turbidity, and other treatment challenges."]
[null,null,"Conventional + Ozone/UV","MED-HIGH","MED-HIGH","MED-HIGH","LOW","LOW","MED-HIGH","MED-HIGH","< 0.075  to > 3.0 (Bins 1 thru 4)","> 3","> 10","< 250","< 150","> 3","Detected > MCLs or Action Levels","High natural organic matter (precursors to DBPs), high NOM and/or increased levels of pathogens, increased levels of bromide, moderate to severe taste and odor, potential for contaminants of emerging concern (CECs)."]
[null,null,"Conventional + GAC","MED","MED-HIGH","MED-HIGH","LOW","LOW","MED-HIGH","MED-HIGH","< 0.075  to < 1.0 (Bins 1 or 2)","> 3","> 10","< 250","< 150","< 3","Detected > MCLs or Action Levels","Similar to Conventional + Ozone, but with lower risk of pathogens in source water."]
[null,null,"Conventional + Membranes","MED-HIGH","MED-HIGH","MED-HIGH","LOW","LOW","LOW","LOW","< 0.075  to > 3.0 (Bins 1 thru 4)","> 3","> 10","< 250","< 150","< 3","Not Detected or < Action Levels/MCLs","High pathogens and/or NOM."]
[null,null,"Conventional + Nanofiltration/Reverse Osmosis ","MED-HIGH","MED-HIGH","MED-HIGH","MED-HIGH","MED-HIGH","MED-HIGH","MED-HIGH","< 0.075  to > 3.0 (Bins 1 thru 4)","> 3","> 10","> 250","> 150","> 3","Detected > MCLs or Action Levels","Treats all of the challenging characteristics listed above for NOM removal, disinfection, softening, CECs, and salinity removal. Not always effective for taste and odor issues."]
[null,null,"1 Direct filtration and conventional treatment can include granular media and MF/UF. MF/UF would add approximately $0.50-1.00 per gpd"]
[null,null,"2 Operational costs include: power, labor, chemicals, residuals handling/disposal, consumables such as GAC/membrane replacement"]
[null,null,"3 Emerging contaminants include: arsenic, radiologicals, pharmaceuticals, etc."]

{"sheet":"Water Rights","index":6,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,3,22]]}
[]
[]
["  W a t e r   R i g h t s"]
[]
[]
[null,null,"Water Rights Parameters"]
[null,null,"Module does not perform any calculations for water rights - depends on user developed cost data."]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- Water right cost is all-inclusive"]
[]
[]
[null,null,"Water Rights Inputs"]
[null,null,"User Unit Cost Input",null,null,null,"$ / ac-ft"]
[null,null,"Total Required Annual Project Yield (Consumptive)",null,null,null,"ac-ft / year"]
[null,null,"Total Calculated Cost",null,null,{"$f":"F20*F21","v":0},"Total cost of water right"]

{"sheet":"Ditches & Diversions","index":7,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,16,24,19],[2,0,3,22]]}
[]
[]
["  D i t c h e s   &   D i v e r s i o n s"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disclaimer"]
[null,null,"Ditch and Diversion Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost data is currently limited for Ditches and Diversions projects. For the purposes of tool improvement, the User should provide all known information. Recommended Diversion Structure Cost is based on limited data points, varying diversion structure types and geometries, and diversion structure capacities estimated based on peak diversion structure capacity from the Colorado Decision Support System (CDSS) website. Therefore, these costs are recommendations and the user should use discretion before selecting these costs. The user should review the Reference Table for actual project costs used to develop the curve to determine if the cost is appropriate for their proposed project. "]
[null,null,"Module may be used for any project with diversion, headgate, or ditch components."]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- Ditch Rehabilitation projects are characterized by installation of upgraded or improved lining material and do not incorporate changes to ditch capacity"]
[null,null,"- A tool developed by the Natural Resources Conservation Service (NRCS) was used to develop costing curves for discharge versus cost of material per linear foot. The use of this tool required the following assumptions:"]
[null,null,"  1. For ditches with trapezoidal geometry the following is assumed: 1) Ditch side slopes are consistently 2 ft/ft, 2) Trapezoidal itches include a 0.5ft freeboard, 3) The average slope over the length of the ditch is 0.15%"]
[null,null,"  2. For closed conduit ditches the following is assumed: 1) Conduits have 4 feet of soil cover, 2) The average slope over the length of the conduit is 0.15%"]
[null,null,"  3. Manning’s roughness values are assumed as follows: Concrete: 0.013; Synthetic: 0.022; DIP: 0.013; PVC: 0.009\n"]
[]
[null,null,"Abbreviations"]
[null,null,"cfs","-","cubic feet per second"]
[null,null,"lf","-","linear feet"]
[]
[null,null,"Project Options"]
[null,null,"Project Components"]
[null,null,"Maximum Diversion Capacity",null,null,null,"cfs"]
[]
[null,null,"Diversion and Headgate Structure"]
[null,null,"Type of Diversion Structure (informational)"]
[null,null,"Maximum Diversion Capacity",null,null,{"$f":"IF(F28=\"\",\"\",F28)","v":""},"cfs"]
[null,null,"Recommended Cost of Diversion Structure",null,null,{"$f":"IFERROR(ROUND(interp(F32,Table7[Discharge (cfs)],Table7[Cost of Diversion]),-3),\"\")","v":""},null,"Click Here for Diversion Cost Data Table"]
[null,null,"Selected Diversion Structure Cost ",null,null,null,{"$f":"IF(AND(F33<>\"\",F34=\"\"),\"User must enter cost here\",\"\")","v":""}]
[]
[null,null,"Ditch Structure (Conveyance)"]
[null,null,"Type of Project"]
[null,null,"Type of Ditch"]
[null,null,"Required Ditch Capacity",null,null,{"$f":"IF(DD_MaxDivCap=\"\",\"\",IF(OR($F$27=\"Ditch\",$F$27=\"Ditch and Diversion Structure\"),$F$28,\"\"))","v":""},"cfs"]
[null,null,"Length",null,null,null,"lf"]

{"sheet":"Streams & Habitat","index":8,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[31,2,31,4],[2,0,3,22]]}
[]
[]
["  S t r e a m s   &   H a b i t a t"]
[]
[]
[null,null,"Streams and Habitat Parameters"]
[null,null,"Module may be used for improvement and/or restoration projects.  "]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- For the purposes of this tool, urban environments are considered those where the stream restoration takes part within an incorporated area and commercial or residential development has occurred adjacent to the riparian buffer."]
[null,null,"- Streams and Habitat costs compound with Level of Restoration. For example, Level 3 costs include Level 1 and Level 2 costs. "]
[null,null,"- Restoration level categorized based on typical components of a restoration project. Users may perform multiple cost analysis to remove restoration components from projects."]
[]
[null,null,"Abbreviations"]
[null,null,"ft","-","feet"]
[null,null,"lf","-","linear feet"]
[]
[]
[null,null,"Stream and Habitat Inputs"]
[null,null,"Stream Width Range",null,null,"ft"]
[null,null,"Stream Environment"]
[null,null,"Length of Restoration",null,null,"lf"]
[null,null,"Level of Restoration"]
[]
[]
[null,null,"Reference Table"]
[null,null,"Level of Restoration","General Description","Typical Components"]
[null,null,"Level 1","Riparian restoration","Grading; revegetation"]
[null,null,"Level 2","Level 1 + bank stabilization","Riprap; root wads; log jams"]
[null,null,"Level 3","Level 2 + in-channel structures","Riffles; rock vanes; boulder weirs"]
[null,null,"Level 4","Level 3 + channel realignment","Channel realignment"]

{"sheet":"User-Specified Project","index":9,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,2,26,11],[2,0,3,22]]}
[]
[]
["  U s e r - S p e c i f i e d   P r o j e c t"]
[]
[]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[null,null,"Assumptions"]
[null,null,"- Users with projects that do not fit into the category of the provided modules may submit their project through the User-Specified Project module."]
[null,null,"- The user is assumed to either have procured a professional to develop a project cost or has used a different costing mechanism to develop planning-level, or better, costs."]
[null,null,"- In the Project Description field, the User should provide a description of the project, what needs are met by the project, total yield and any major project components that contribute to cost. "]
[]
[]
[null,null,"User-Specified Project Input"]
[null,null,"Project Description"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Project Yield",null,null,"ac-ft/yr"]
[null,null,"User Cost Input ",null,null,"Total Capital Cost of Project Construction"]
[null,null,"User Cost Input ",null,null,"Annual Project Operations & Maintenance Costs"]

{"sheet":"Costing Module","index":10,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":false,"merged":[[125,3,125,9],[119,5,119,9],[120,5,120,9],[121,5,121,9],[122,5,122,9],[123,5,123,9],[124,5,124,9],[76,2,82,2],[84,3,84,10],[84,2,90,2],[2,0,3,22],[117,3,117,10],[112,2,115,2],[112,3,112,10],[113,3,113,9],[115,3,115,9],[50,3,50,10],[74,3,74,9],[38,2,74,2],[90,3,90,9],[21,3,21,10],[36,3,36,9],[62,3,62,10],[87,3,87,10],[76,3,76,10],[79,3,79,10],[82,3,82,9],[15,2,36,2],[38,3,38,10],[15,3,15,10],[31,3,31,10],[26,3,26,10],[94,3,94,9],[92,2,94,2],[104,3,104,10],[110,3,110,9],[104,2,110,2],[96,3,96,10],[102,3,102,9],[96,2,102,2],[99,3,99,10],[92,3,92,10],[93,3,93,9]]}
[]
[]
["  C o s t i n g   M o d u l e"]
[]
[]
[null,null,"Costing Data and Summary"]
[null,null,"To link back to an individual module, click the Module Title on the left"]
[]
[null,null,"Project Information"]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Cost_Estimator),\"Enter Cost Estimator in Global Inputs\",Cost_Estimator)","v":"Enter Cost Estimator in Global Inputs"}]
[]
[]
[null,null,"Pipelines Project","Pipes"]
[null,null,null,"Segment","Pipe Size (in)","Environment","Unit Cost","Pipe Length (ft)",null,"External Cost Est.","Cost"]
[null,null,null,1,{"$f":"IF(ISBLANK(Pipe_d1),\"-\",Pipe_d1)","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H43),\"-\",Pipelines!H43)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E18,'Module References'!$G$45:$G$68,0),MATCH($F18,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF(ISBLANK(Pipe_L1),\"-\",Pipe_L1)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK(J18),G18*H18,J18),\"-\")","v":"-"}]
[null,null,null,2,{"$f":"IF(ISBLANK(Pipe_d2),\"-\",Pipe_d2)","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H77),\"-\",Pipelines!H77)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E19,'Module References'!$G$45:$G$68,0),MATCH($F19,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF(ISBLANK(Pipe_L2),\"-\",Pipe_L2)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK(J19),G19*H19,J19),\"-\")","v":"-"}]
[null,null,null,3,{"$f":"IF(ISBLANK(Pipe_d3),\"-\",Pipe_d3)","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H111),\"-\",Pipelines!H111)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E20,'Module References'!$G$45:$G$68,0),MATCH($F20,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF(ISBLANK(Pipe_L3),\"-\",Pipe_L3)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK(J20),G20*H20,J20),\"-\")","v":"-"}]
[]
[null,null,null,"Intake Pumps"]
[null,null,null,"Segment","Facility Size (HP)","Intake Pump Required?","Unit Cost","Quantity","Energy (kW-hr)","External Cost Est.","Cost"]
[null,null,null,1,{"$f":"IF(PumpType1=\"Intake\",Pipelines!I70,\"-\")","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H65),\"-\",IF(Pipelines!H65=\"Intake\",\"Yes\",\"No\"))","v":"-"},{"$f":"IFERROR(IF(F24=\"Yes\",interp(E24,'Module References'!$M$45:$M$73,'Module References'!$P$45:$P$73)*1000000,\"-\"),\"-\")","v":"-"},{"$f":"IF(Pipelines!H70=0,\"Gravity System\",IF(Pipelines!H70=\"-\",\"-\",IF(F24=\"No\",0,1)))","v":"-"},{"$f":"IF(H24=\"Gravity System\",\"-\",IF(F24=\"Yes\",(H24/Pipelines!H70)*Pipelines!K70,\"-\"))","v":"-"},null,{"$f":"IF(I24<0,\"-\",IFERROR(IF(ISBLANK(J24),G24*H24,J24),\"-\"))","v":"-"}]
[null,null,null,2,{"$f":"IF(PumpType2=\"Intake\",Pipelines!I104,\"-\")","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H99),\"-\",IF(Pipelines!H99=\"Intake\",\"Yes\",\"No\"))","v":"-"},{"$f":"IFERROR(IF(F25=\"Yes\",interp(E25,'Module References'!$M$45:$M$73,'Module References'!$P$45:$P$73)*1000000,\"-\"),\"-\")","v":"-"},{"$f":"IF(Pipelines!H104=0,\"Gravity System\",IF(Pipelines!H104=\"-\",\"-\",IF(F25=\"No\",0,1)))","v":"-"},{"$f":"IF(H25=\"Gravity System\",\"-\",IF(F25=\"Yes\",(H25/Pipelines!H104)*Pipelines!K104,\"-\"))","v":"-"},null,{"$f":"IF(I25<0,\"-\",IFERROR(IF(ISBLANK(J25),G25*H25,J25),\"-\"))","v":"-"}]
[null,null,null,3,{"$f":"IF(PumpType3=\"Intake\",Pipelines!I138,\"-\")","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H133),\"-\",IF(Pipelines!H133=\"Intake\",\"Yes\",\"No\"))","v":"-"},{"$f":"IFERROR(IF(F26=\"Yes\",interp(E26,'Module References'!$M$45:$M$73,'Module References'!$P$45:$P$73)*1000000,\"-\"),\"-\")","v":"-"},{"$f":"IF(Pipelines!H138=0,\"Gravity System\",IF(Pipelines!H138=\"-\",\"-\",IF(F26=\"No\",0,1)))","v":"-"},{"$f":"IF(H26=\"Gravity System\",\"-\",IF(F26=\"Yes\",(H26/Pipelines!H138)*Pipelines!K138,\"-\"))","v":"-"},null,"-"]
[null,null,null,"Booster Pumps"]
[null,null,null,"Segment","Facility Size (HP)","Booster Pump Required?","Unit Cost","Quantity","Energy (kW-hr)","External Cost Est.","Cost"]
[null,null,null,1,{"$f":"IF(ISBLANK(Pipelines!H65),\"-\",IF(OR(Pipelines!H65=\"Booster\",Pipelines!H70>1),Pipelines!I70,\"-\"))","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H65),\"-\",IF(OR(Pipelines!H65=\"Booster\",Pipelines!H70>1),\"Yes\",\"No\"))","v":"-"},{"$f":"IFERROR(interp(E29,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*1000000,\"-\")","v":"-"},{"$f":"IFERROR(IF(Pipelines!H70=0,\"Gravity System\",IF(Pipelines!H70-H24>0,Pipelines!H70-H24,\"-\")),\"-\")","v":"-"},{"$f":"IF(H29=\"Gravity System\",\"-\",IF(F29=\"Yes\",(H29/Pipelines!H70)*Pipelines!K70,\"-\"))","v":"-"},null,{"$f":"IF(I29<0,\"-\",IFERROR(IF(ISBLANK(J29),G29*H29,J29),\"-\"))","v":"-"}]
[null,null,null,2,{"$f":"IF(ISBLANK(Pipelines!H99),\"-\",IF(OR(Pipelines!H99=\"Booster\",Pipelines!H104>1),Pipelines!I104,\"-\"))","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H99),\"-\",IF(OR(Pipelines!H99=\"Booster\",Pipelines!H104>1),\"Yes\",\"No\"))","v":"-"},{"$f":"IFERROR(interp(E30,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*1000000,\"-\")","v":"-"},{"$f":"IFERROR(IF(Pipelines!H104=0,\"Gravity System\",IF(Pipelines!H104-H25>0,Pipelines!H104-H25,\"-\")),\"-\")","v":"-"},{"$f":"IF(H30=\"Gravity System\",\"-\",IF(F30=\"Yes\",(H30/Pipelines!H104)*Pipelines!K104,\"-\"))","v":"-"},null,{"$f":"IF(I30<0,\"-\",IFERROR(IF(ISBLANK(J30),G30*H30,J30),\"-\"))","v":"-"}]
[null,null,null,3,{"$f":"IF(ISBLANK(Pipelines!H133),\"-\",IF(OR(Pipelines!H133=\"Booster\",Pipelines!H138>1),Pipelines!I138,\"-\"))","v":"-"},{"$f":"IF(ISBLANK(Pipelines!H133),\"-\",IF(OR(Pipelines!H133=\"Booster\",Pipelines!H138>1),\"Yes\",\"No\"))","v":"-"},{"$f":"IFERROR(interp(E31,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*1000000,\"-\")","v":"-"},{"$f":"IFERROR(IF(Pipelines!H138=0,\"Gravity System\",IF(Pipelines!H138-H26>0,Pipelines!H138-H26,\"-\")),\"-\")","v":"-"},{"$f":"IF(H31=\"Gravity System\",\"-\",IF(F31=\"Yes\",(H31/Pipelines!H138)*Pipelines!K138,\"-\"))","v":"-"},null,"-"]
[null,null,null,"Associated Storage"]
[null,null,null,"Segment","Storage (MG)",null,null,null,null,"External Cost Est.","Cost"]
[null,null,null,1,{"$f":"IF(Pipelines!L70=0,\"-\",Pipelines!L70)","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J34),interp(E34,'Module References'!$S$45:$S$62,'Module References'!$U$45:$U$62),J34),\"-\")","v":"-"}]
[null,null,null,2,{"$f":"IF(Pipelines!L104=0,\"-\",Pipelines!L104)","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J35),interp(E35,'Module References'!$S$45:$S$62,'Module References'!$U$45:$U$62),J35),\"-\")","v":"-"}]
[null,null,null,3,{"$f":"IF(Pipelines!L138=0,\"-\",Pipelines!L138)","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J36),interp(E36,'Module References'!$S$45:$S$62,'Module References'!$U$45:$U$62),J36),\"-\")","v":"-"}]
[null,null,null,"Total Pipelines Project Cost",null,null,null,null,null,null,{"$f":"IFERROR(SUM(K18:K20,K24:K26,K29:K31,K34:K36),0)","v":0}]
[]
[null,null,"Well Field Project","Well Field Piping"]
[null,null,null,"Segment","Pipe Size (in)","Environment","Unit Cost","Pipe Length (ft)",null,"External Cost Est.","Cost"]
[null,null,null,1,{"$f":"IF('Well Fields'!K61=\"\",\"-\",'Well Fields'!K61)","v":"-"},{"$f":"IF(ISBLANK('Well Fields'!L61),\"-\",'Well Fields'!L61)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E41,'Module References'!$G$45:$G$68,0),MATCH($F41,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M61=\"\",\"-\",'Well Fields'!M61)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M61),\"-\",IF(ISBLANK(J41),G41*H41,J41)),\"-\")","v":"-"}]
[null,null,null,2,{"$f":"IF('Well Fields'!K62=\"\",\"-\",'Well Fields'!K62)","v":"-"},{"$f":"IF('Well Fields'!L62=\"\",\"-\",'Well Fields'!L62)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E42,'Module References'!$G$45:$G$68,0),MATCH($F42,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M62=\"\",\"-\",'Well Fields'!M62)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M62),\"-\",IF(ISBLANK(J42),G42*H42,J42)),\"-\")","v":"-"}]
[null,null,null,3,{"$f":"IF('Well Fields'!K63=\"\",\"-\",'Well Fields'!K63)","v":"-"},{"$f":"IF('Well Fields'!L63=\"\",\"-\",'Well Fields'!L63)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E43,'Module References'!$G$45:$G$68,0),MATCH($F43,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M63=\"\",\"-\",'Well Fields'!M63)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M63),\"-\",IF(ISBLANK(J43),G43*H43,J43)),\"-\")","v":"-"}]
[null,null,null,4,{"$f":"IF('Well Fields'!K64=\"\",\"-\",'Well Fields'!K64)","v":"-"},{"$f":"IF('Well Fields'!L64=\"\",\"-\",'Well Fields'!L64)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E44,'Module References'!$G$45:$G$68,0),MATCH($F44,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M64=\"\",\"-\",'Well Fields'!M64)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M64),\"-\",IF(ISBLANK(J44),G44*H44,J44)),\"-\")","v":"-"}]
[null,null,null,5,{"$f":"IF('Well Fields'!K65=\"\",\"-\",'Well Fields'!K65)","v":"-"},{"$f":"IF('Well Fields'!L65=\"\",\"-\",'Well Fields'!L65)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E45,'Module References'!$G$45:$G$68,0),MATCH($F45,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M65=\"\",\"-\",'Well Fields'!M65)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M65),\"-\",IF(ISBLANK(J45),G45*H45,J45)),\"-\")","v":"-"}]
[null,null,null,6,{"$f":"IF('Well Fields'!K66=\"\",\"-\",'Well Fields'!K66)","v":"-"},{"$f":"IF('Well Fields'!L66=\"\",\"-\",'Well Fields'!L66)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E46,'Module References'!$G$45:$G$68,0),MATCH($F46,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M66=\"\",\"-\",'Well Fields'!M66)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M66),\"-\",IF(ISBLANK(J46),G46*H46,J46)),\"-\")","v":"-"}]
[null,null,null,7,{"$f":"IF('Well Fields'!K67=\"\",\"-\",'Well Fields'!K67)","v":"-"},{"$f":"IF('Well Fields'!L67=\"\",\"-\",'Well Fields'!L67)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E47,'Module References'!$G$45:$G$68,0),MATCH($F47,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M67=\"\",\"-\",'Well Fields'!M67)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M67),\"-\",IF(ISBLANK(J47),G47*H47,J47)),\"-\")","v":"-"}]
[null,null,null,8,{"$f":"IF('Well Fields'!K68=\"\",\"-\",'Well Fields'!K68)","v":"-"},{"$f":"IF('Well Fields'!L68=\"\",\"-\",'Well Fields'!L68)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E48,'Module References'!$G$45:$G$68,0),MATCH($F48,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M68=\"\",\"-\",'Well Fields'!M68)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M68),\"-\",IF(ISBLANK(J48),G48*H48,J48)),\"-\")","v":"-"}]
[null,null,null,9,{"$f":"IF('Well Fields'!K69=\"\",\"-\",'Well Fields'!K69)","v":"-"},{"$f":"IF('Well Fields'!L69=\"\",\"-\",'Well Fields'!L69)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E49,'Module References'!$G$45:$G$68,0),MATCH($F49,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M69=\"\",\"-\",'Well Fields'!M69)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M69),\"-\",IF(ISBLANK(J49),G49*H49,J49)),\"-\")","v":"-"}]
[null,null,null,10,{"$f":"IF('Well Fields'!K70=\"\",\"-\",'Well Fields'!K70)","v":"-"},{"$f":"IF('Well Fields'!L70=\"\",\"-\",'Well Fields'!L70)","v":"-"},{"$f":"_xlfn.IFNA(INDEX('Module References'!$J$45:$K$68,MATCH($E50,'Module References'!$G$45:$G$68,0),MATCH($F50,'Module References'!$J$44:$K$44,0)),\"-\")","v":"-"},{"$f":"IF('Well Fields'!M70=\"\",\"-\",'Well Fields'!M70)","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!M70),\"-\",IF(ISBLANK(J50),G50*H50,J50)),\"-\")","v":"-"}]
[null,null,null,"Wells"]
[null,null,null,"Well Type","Depth","Capacity (gpm)","Well Cost",null,"Energy, Total Well Field (kW-hr)","External Cost Est.","Cost"]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P43=0,\"-\",'Well Fields'!P43)","v":"-"},{"$f":"IF('Well Fields'!Q43=0,\"-\",'Well Fields'!Q43)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O43),0,IF(D53=\"Public Supply Wells\",interp('Costing Module'!E53,'Module References'!$C$87:$C$93,'Module References'!$P$87:$P$93),IF(D53=\"ASR Wells\",interp('Costing Module'!E53,'Module References'!$C$94:$C$100,'Module References'!$P$94:$P$100),interp('Costing Module'!E53,'Module References'!$C$101:$C$107,'Module References'!$P$101:$P$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F54),\"-\",IF(ISNUMBER(F53),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K43),\"-\",IF(ISBLANK(J53),G53,J53)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P44=0,\"-\",'Well Fields'!P44)","v":"-"},{"$f":"IF('Well Fields'!Q44=0,\"-\",'Well Fields'!Q44)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O44),0,IF(D54=\"Public Supply Wells\",interp('Costing Module'!E54,'Module References'!$C$87:$C$93,'Module References'!$Q$87:$Q$93),IF(D54=\"ASR Wells\",interp('Costing Module'!E54,'Module References'!$C$94:$C$100,'Module References'!$Q$94:$Q$100),interp('Costing Module'!E54,'Module References'!$C$101:$C$107,'Module References'!$Q$101:$Q$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F55),\"-\",IF(ISNUMBER(F54),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K44),\"-\",IF(ISBLANK(J54),G54,J54)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P45=0,\"-\",'Well Fields'!P45)","v":"-"},{"$f":"IF('Well Fields'!Q45=0,\"-\",'Well Fields'!Q45)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O45),0,IF(D55=\"Public Supply Wells\",interp('Costing Module'!E55,'Module References'!$C$87:$C$93,'Module References'!$R$87:$R$93),IF(D55=\"ASR Wells\",interp('Costing Module'!E55,'Module References'!$C$94:$C$100,'Module References'!$R$94:$R$100),interp('Costing Module'!E55,'Module References'!$C$101:$C$107,'Module References'!$R$101:$R$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F56),\"-\",IF(ISNUMBER(F55),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K45),\"-\",IF(ISBLANK(J55),G55,J55)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P46=0,\"-\",'Well Fields'!P46)","v":"-"},{"$f":"IF('Well Fields'!Q46=0,\"-\",'Well Fields'!Q46)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O46),0,IF(D56=\"Public Supply Wells\",interp('Costing Module'!E56,'Module References'!$C$87:$C$93,'Module References'!$S$87:$S$93),IF(D56=\"ASR Wells\",interp('Costing Module'!E56,'Module References'!$C$94:$C$100,'Module References'!$S$94:$S$100),interp('Costing Module'!E56,'Module References'!$C$101:$C$107,'Module References'!$S$101:$S$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F57),\"-\",IF(ISNUMBER(F56),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K46),\"-\",IF(ISBLANK(J56),G56,J56)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P47=0,\"-\",'Well Fields'!P47)","v":"-"},{"$f":"IF('Well Fields'!Q47=0,\"-\",'Well Fields'!Q47)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O47),0,IF(D57=\"Public Supply Wells\",interp('Costing Module'!E57,'Module References'!$C$87:$C$93,'Module References'!$T$87:$T$93),IF(D57=\"ASR Wells\",interp('Costing Module'!E57,'Module References'!$C$94:$C$100,'Module References'!$T$94:$T$100),interp('Costing Module'!E57,'Module References'!$C$101:$C$107,'Module References'!$T$101:$T$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F58),\"-\",IF(ISNUMBER(F57),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K47),\"-\",IF(ISBLANK(J57),G57,J57)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P48=0,\"-\",'Well Fields'!P48)","v":"-"},{"$f":"IF('Well Fields'!Q48=0,\"-\",'Well Fields'!Q48)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O48),0,IF(D58=\"Public Supply Wells\",interp('Costing Module'!E58,'Module References'!$C$87:$C$93,'Module References'!$U$87:$U$93),IF(D58=\"ASR Wells\",interp('Costing Module'!E58,'Module References'!$C$94:$C$100,'Module References'!$U$94:$U$100),interp('Costing Module'!E58,'Module References'!$C$101:$C$107,'Module References'!$U$101:$U$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F59),\"-\",IF(ISNUMBER(F58),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K48),\"-\",IF(ISBLANK(J58),G58,J58)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P49=0,\"-\",'Well Fields'!P49)","v":"-"},{"$f":"IF('Well Fields'!Q49=0,\"-\",'Well Fields'!Q49)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O43),0,IF(D59=\"Public Supply Wells\",interp('Costing Module'!E59,'Module References'!$C$87:$C$93,'Module References'!$V$87:$V$93),IF(D59=\"ASR Wells\",interp('Costing Module'!E59,'Module References'!$C$94:$C$100,'Module References'!$V$94:$V$100),interp('Costing Module'!E59,'Module References'!$C$101:$C$107,'Module References'!$V$101:$V$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F60),\"-\",IF(ISNUMBER(F59),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K49),\"-\",IF(ISBLANK(J59),G59,J59)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P50=0,\"-\",'Well Fields'!P50)","v":"-"},{"$f":"IF('Well Fields'!Q50=0,\"-\",'Well Fields'!Q50)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O43),0,IF(D60=\"Public Supply Wells\",interp('Costing Module'!E60,'Module References'!$C$87:$C$93,'Module References'!$W$87:$W$93),IF(D60=\"ASR Wells\",interp('Costing Module'!E60,'Module References'!$C$94:$C$100,'Module References'!$W$94:$W$100),interp('Costing Module'!E60,'Module References'!$C$101:$C$107,'Module References'!$W$101:$W$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F61),\"-\",IF(ISNUMBER(F60),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K50),\"-\",IF(ISBLANK(J60),G60,J60)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P51=0,\"-\",'Well Fields'!P51)","v":"-"},{"$f":"IF('Well Fields'!Q51=0,\"-\",'Well Fields'!Q51)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O43),0,IF(D61=\"Public Supply Wells\",interp('Costing Module'!E61,'Module References'!$C$87:$C$93,'Module References'!$X$87:$X$93),IF(D61=\"ASR Wells\",interp('Costing Module'!E61,'Module References'!$C$94:$C$100,'Module References'!$X$94:$X$100),interp('Costing Module'!E61,'Module References'!$C$101:$C$107,'Module References'!$X$101:$X$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F62),\"-\",IF(ISNUMBER(F61),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K51),\"-\",IF(ISBLANK(J61),G61,J61)),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF(ISBLANK('Well Fields'!$D$42),\"-\",'Well Fields'!$D$42)","v":"-"},{"$f":"IF('Well Fields'!P52=0,\"-\",'Well Fields'!P52)","v":"-"},{"$f":"IF('Well Fields'!Q52=0,\"-\",'Well Fields'!Q52)","v":"-"},{"$f":"IFERROR(IF(ISBLANK('Well Fields'!O43),0,IF(D62=\"Public Supply Wells\",interp('Costing Module'!E62,'Module References'!$C$87:$C$93,'Module References'!$Y$87:$Y$93),IF(D62=\"ASR Wells\",interp('Costing Module'!E62,'Module References'!$C$94:$C$100,'Module References'!$Y$94:$Y$100),interp('Costing Module'!E62,'Module References'!$C$101:$C$107,'Module References'!$Y$101:$Y$107)))),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(F63),\"-\",IF(ISNUMBER(F62),'Well Fields'!$H$55,\"-\"))","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK('Well Fields'!K52),\"-\",IF(ISBLANK(J62),G62,J62)),\"-\")","v":"-"}]
[null,null,null,"Booster Pumps"]
[null,null,null,"Pump Number","Facility Size (HP)","Pump Type ","Unit Cost","Quantity","Energy (kW-hr)","External Cost Est.","Cost"]
[null,null,null,{"$f":"'Well Fields'!N79","v":1},{"$f":"IF('Well Fields'!Q79=\"\",\"-\",'Well Fields'!Q79)","v":"-"},{"$f":"IF(ISNUMBER(E65),\"Booster\",\"-\")","v":"-"},{"$f":"IFERROR(interp(E65,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},{"$f":"IF(ISNUMBER(E65),1,\"-\")","v":"-"},{"$f":"IF('Well Fields'!R79<>0,'Well Fields'!R79,\"-\")","v":"-"},null,{"$f":"IF(I65<0,\"-\",IFERROR(IF('Well Fields'!Q79=0,\"-\",IF(ISBLANK(J65),G65*H65,J65)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N80","v":2},{"$f":"IF('Well Fields'!Q80=\"\",\"-\",'Well Fields'!Q80)","v":"-"},{"$f":"IF(ISNUMBER(E66),\"Booster\",\"-\")","v":"-"},{"$f":"IFERROR(interp(E66,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},{"$f":"IF(ISNUMBER(E66),1,\"-\")","v":"-"},{"$f":"IF('Well Fields'!R80<>0,'Well Fields'!R80,\"-\")","v":"-"},null,{"$f":"IF(I66<0,\"-\",IFERROR(IF('Well Fields'!Q80=0,\"-\",IF(ISBLANK(J66),G66*H66,J66)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N81","v":3},{"$f":"IF('Well Fields'!Q81=\"\",\"-\",'Well Fields'!Q81)","v":"-"},"-",{"$f":"IFERROR(interp(E67,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R81<>0,'Well Fields'!R81,\"-\")","v":"-"},null,{"$f":"IF(I67<0,\"-\",IFERROR(IF('Well Fields'!Q81=0,\"-\",IF(ISBLANK(J67),G67*H67,J67)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N82","v":4},{"$f":"IF('Well Fields'!Q82=\"\",\"-\",'Well Fields'!Q82)","v":"-"},"-",{"$f":"IFERROR(interp(E68,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R82<>0,'Well Fields'!R82,\"-\")","v":"-"},null,{"$f":"IF(I68<0,\"-\",IFERROR(IF('Well Fields'!Q82=0,\"-\",IF(ISBLANK(J68),G68*H68,J68)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N83","v":5},{"$f":"IF('Well Fields'!Q83=\"\",\"-\",'Well Fields'!Q83)","v":"-"},"-",{"$f":"IFERROR(interp(E69,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R83<>0,'Well Fields'!R83,\"-\")","v":"-"},null,{"$f":"IF(I69<0,\"-\",IFERROR(IF('Well Fields'!Q83=0,\"-\",IF(ISBLANK(J69),G69*H69,J69)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N84","v":6},{"$f":"IF('Well Fields'!Q84=\"\",\"-\",'Well Fields'!Q84)","v":"-"},"-",{"$f":"IFERROR(interp(E70,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R84<>0,'Well Fields'!R84,\"-\")","v":"-"},null,{"$f":"IF(I70<0,\"-\",IFERROR(IF('Well Fields'!Q84=0,\"-\",IF(ISBLANK(J70),G70*H70,J70)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N85","v":7},{"$f":"IF('Well Fields'!Q85=\"\",\"-\",'Well Fields'!Q85)","v":"-"},"-",{"$f":"IFERROR(interp(E71,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R85<>0,'Well Fields'!R85,\"-\")","v":"-"},null,{"$f":"IF(I71<0,\"-\",IFERROR(IF('Well Fields'!Q85=0,\"-\",IF(ISBLANK(J71),G71*H71,J71)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N86","v":8},{"$f":"IF('Well Fields'!Q86=\"\",\"-\",'Well Fields'!Q86)","v":"-"},"-",{"$f":"IFERROR(interp(E72,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R86<>0,'Well Fields'!R86,\"-\")","v":"-"},null,{"$f":"IF(I72<0,\"-\",IFERROR(IF('Well Fields'!Q86=0,\"-\",IF(ISBLANK(J72),G72*H72,J72)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N87","v":9},{"$f":"IF('Well Fields'!Q87=\"\",\"-\",'Well Fields'!Q87)","v":"-"},"-",{"$f":"IFERROR(interp(E73,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R87<>0,'Well Fields'!R87,\"-\")","v":"-"},null,{"$f":"IF(I73<0,\"-\",IFERROR(IF('Well Fields'!Q87=0,\"-\",IF(ISBLANK(J73),G73*H73,J73)),\"-\"))","v":"-"}]
[null,null,null,{"$f":"'Well Fields'!N88","v":10},{"$f":"IF('Well Fields'!Q88=\"\",\"-\",'Well Fields'!Q88)","v":"-"},"-",{"$f":"IFERROR(interp(E74,'Module References'!$M$45:$M$73,'Module References'!$Q$45:$Q$73)*MG_GAL,\"-\")","v":"-"},"-",{"$f":"IF('Well Fields'!R88<>0,'Well Fields'!R88,\"-\")","v":"-"},null,{"$f":"IF(I74<0,\"-\",IFERROR(IF('Well Fields'!Q88=0,\"-\",IF(ISBLANK(J74),G74*H74,J74)),\"-\"))","v":"-"}]
[null,null,null,"Total Well Field Project Cost",null,null,null,null,null,null,{"$f":"IFERROR(SUM(K41:K50,K53:K62,K65:K74),0)","v":0}]
[]
[null,null,"Treatment Project","Treatment Project Capital Costs"]
[null,null,null,"Treatment Type",null,"Capacity (MGD)","Capital Cost",null,null,"External Cost Est.","Cost"]
[null,null,null,{"$f":"IF(ISBLANK(Treatment!F31),\"-\",Treatment!F31)","v":"-"},null,{"$f":"IF(Treatment!F36=0,\"-\",Treatment!F36)","v":"-"},{"$f":"IF(F79=\"-\",\"-\",IF(D79='Module References'!S167,interp('Costing Module'!F79,'Module References'!$B$119:$B$135,'Module References'!$K$119:$K$135),IF('Costing Module'!D79='Module References'!S168,interp('Costing Module'!F79,'Module References'!$B$119:$B$135,'Module References'!$L$119:$L$135),IF(D79='Module References'!S169,interp(F79,'Module References'!$B$119:$B$135,'Module References'!$M$119:$M$135),IF(D79='Module References'!S170,interp(F79,'Module References'!$B$119:$B$135,'Module References'!$N$119:$N$135),IF(D79='Module References'!S171,interp(F79,'Module References'!$B$119:$B$135,'Module References'!$O$119:$O$135),IF(D79='Module References'!S172,interp('Costing Module'!F79,'Module References'!$B$119:$B$135,'Module References'!$P$119:$P$135),IF(D79='Module References'!S173,interp('Costing Module'!F79,'Module References'!$B$119:$B$135,'Module References'!$Q$119:$Q$135),IF(D79='Module References'!S174,interp('Costing Module'!F79,'Module References'!$B$119:$B$135,'Module References'!$R$119:$R$135),0))))))))*1000)","v":"-"},null,null,null,{"$f":"IF(G79=0,\"-\",IFERROR(IF(ISBLANK(J79),G79,J79),\"-\"))","v":"-"}]
[null,null,null,"Treatment Project Annual O&M Costs"]
[null,null,null,"Treatment Type",null,"Capacity (MGD)","Annual Cost",null,null,"External Cost Est.","Cost"]
[null,null,null,{"$f":"IF(ISBLANK(Treatment!F31),\"-\",Treatment!F31)","v":"-"},null,{"$f":"IF(Treatment!F36=0,\"-\",Treatment!F36)","v":"-"},{"$f":"IF(F82=\"-\",\"-\",IF(D82='Module References'!S167,interp('Costing Module'!F82,'Module References'!$B$119:$B$135,'Module References'!$AC$119:$AC$135),IF('Costing Module'!D82='Module References'!S168,interp('Costing Module'!F82,'Module References'!$B$119:$B$135,'Module References'!$AD$119:$AD$135),IF(D82='Module References'!S169,interp(F82,'Module References'!$B$119:$B$135,'Module References'!$AE$119:$AE$135),IF(D82='Module References'!S170,interp(F82,'Module References'!$B$119:$B$135,'Module References'!$AF$119:$AF$135),IF(D82='Module References'!S171,interp(F82,'Module References'!$B$119:$B$135,'Module References'!$AG$119:$AG$135),IF(D82='Module References'!S172,interp('Costing Module'!F82,'Module References'!$B$119:$B$135,'Module References'!$AH$119:$AH$135),IF(D82='Module References'!S173,interp('Costing Module'!F82,'Module References'!$B$119:$B$135,'Module References'!$AI$119:$AI$135),IF(D82='Module References'!S174,interp('Costing Module'!F82,'Module References'!$B$119:$B$135,'Module References'!AJ119:AJ135),0))))))))*1000)","v":"-"},null,null,null,{"$f":"IF(G82=0,\"-\",IFERROR(IF(ISBLANK(J82),G82,J82),\"-\"))","v":"-"}]
[null,null,null,"Total Treatment Capital Project Cost",null,null,null,null,null,null,{"$f":"IF(K79=\"-\",0,K79)","v":0}]
[]
[null,null,"Reservoir Project","Reservoir Project Costs"]
[null,null,null,"Reservoir Project Type",null,"New Capacity (ac-ft)",null,null,null,"External Cost Est.","Cost"]
[null,null,null,{"$f":"IF(ISBLANK(Reservoirs!F30),\"-\",Reservoirs!F30)","v":"-"},null,{"$f":"IF(ISBLANK(Reservoirs!F31),\"-\",Reservoirs!F31)","v":"-"},null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J87),IF('Costing Module'!D87='Module References'!B182,interp(F87,'Module References'!E181:E204,'Module References'!H181:H204),interp(F87,'Module References'!E181:E204,'Module References'!I181:I204))*1000000,J87),\"-\")","v":"-"}]
[null,null,null,"Reservoir Rehabilitation Project Costs"]
[null,null,null,"Reservoir Rehab Project",null,null,"User-Specified Cost",null,null,"External Cost Est.","Cost"]
[null,null,null,{"$f":"IFERROR(IF(Rehab_Cost=\"\",\"-\",\"Yes\"),\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF(Rehab_Cost=\"\",\"-\",Rehab_Cost),\"-\")","v":"-"},null,null,null,{"$f":"IF(G90=0,\"-\",IFERROR(IF(ISBLANK(J90),G90,J90),\"-\"))","v":"-"}]
[null,null,null,"Total Reservoir Project Cost",null,null,null,null,null,null,{"$f":"IF(SUM(K87,K90)=\"-\",0,SUM(K87,K90))","v":0}]
[]
[null,null,"Water Rights Project","Water Rights Project Costs"]
[null,null,null,"External Cost Estimate",null,null,null,null,null,null,{"$f":"IF('Water Rights'!F22<>0,'Water Rights'!F22,\"-\")","v":"-"}]
[null,null,null,"Total Water Rights Project Cost",null,null,null,null,null,null,{"$f":"IF(K94=\"-\",0,K94)","v":0}]
[]
[null,null,"Ditches and Diversions Project","Ditch Project Costs"]
[null,null,null,"Type of Ditch Project","Type of Ditch",null,"Maximum Discharge (cfs)","Unit Cost","Length (lf)","External Cost Est.","Cost"]
[null,null,null,{"$f":"IF(ISBLANK('Ditches & Diversions'!$F$37),\"-\",'Ditches & Diversions'!$F$37)","v":"-"},{"$f":"IF(ISBLANK('Ditches & Diversions'!$F$38),\"-\",'Ditches & Diversions'!$F$38)","v":"-"},null,{"$f":"IF(ISBLANK('Ditches & Diversions'!$F$39),\"-\",'Ditches & Diversions'!$F$39)","v":""},{"$f":"IFERROR(IF(D99='Module References'!F218,IF(E99='Module References'!D218,interp('Costing Module'!G99,'Module References'!H217:H238,'Module References'!N217:N238),IF(E99='Module References'!D219,interp('Costing Module'!G99,'Module References'!H217:H238,'Module References'!O217:O238),IF(E99='Module References'!D220,interp('Costing Module'!G99,'Module References'!H217:H238,'Module References'!P217:P238),IF(E99='Module References'!D221,interp('Costing Module'!G99,'Module References'!H217:H238,'Module References'!Q217:Q238),IF(E99='Module References'!D222,interp('Costing Module'!G99,'Module References'!H217:H238,'Module References'!R217:R238)))))),IF(E99='Module References'!D218,interp('Costing Module'!G99,'Module References'!T217:T238,'Module References'!Z217:Z238),IF(E99='Module References'!D219,interp('Costing Module'!G99,'Module References'!T217:T238,'Module References'!AA217:AA238),IF(E99='Module References'!D220,interp('Costing Module'!G99,'Module References'!T217:T238,'Module References'!AB217:AB238),IF(E99='Module References'!D221,interp('Costing Module'!G99,'Module References'!T217:T238,'Module References'!AC217:AC238),IF(E99='Module References'!D222,interp('Costing Module'!G99,'Module References'!T217:T238,'Module References'!AD217:AD238),\"-\")))))),\"-\")","v":"-"},{"$f":"IF(ISBLANK('Ditches & Diversions'!$F$40),\"-\",'Ditches & Diversions'!$F$40)","v":"-"},null,{"$f":"IFERROR(IF(ISBLANK(J99),H99*I99,'Costing Module'!J99),\"-\")","v":"-"}]
[null,null,null,"Diversion Project Costs"]
[null,null,null,"Type of Diversion",null,null,"Maximum Discharge (cfs)",null,null,"External Cost Est."]
[null,null,null,{"$f":"IF(DD_DivType=\"\",\"-\",DD_DivType)","v":"-"},null,null,{"$f":"IF(ISBLANK('Ditches & Diversions'!$F$39),\"-\",'Ditches & Diversions'!$F$39)","v":""},null,null,null,{"$f":"IFERROR(IF(ISBLANK(J102),'Ditches & Diversions'!F34,J102),\"-\")","v":0}]
[null,null,null,"Total Ditches & Diversions Project Cost",null,null,null,null,null,null,{"$f":"IFERROR(SUM(K99,K102),0)","v":0}]
[]
[null,null,"Streams and Habitat Project","Streams and Habitat Project Costs"]
[null,null,null,"Stream Width (ft)","Environment","Level of Restoration","Unit Cost","Quantity (lf)",null,"External Cost Est.","Cost"]
[null,null,null,{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F107,'Streams & Habitat'!E26,\"-\")","v":"-"},{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F107,'Streams & Habitat'!E27,\"-\")","v":"-"},"Level 1",{"$f":"IF(D107=\"-\",\"-\",INDEX(Table416[[Rural]:[Urban]],MATCH(1,(D107=Table416[Width Range])*(F107=Table416[Restoration Level]),0),MATCH(E107,Table416[[#Headers],[Rural]:[Urban]],0)))","v":"-"},{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F107,'Streams & Habitat'!E28,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK(J107),G107*H107,J107),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F108,'Streams & Habitat'!E26,\"-\")","v":"-"},{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F108,'Streams & Habitat'!E27,\"-\")","v":"-"},"Level 2",{"$f":"IF(D108=\"-\",\"-\",INDEX(Table416[[Rural]:[Urban]],MATCH(1,(D108=Table416[Width Range])*(F108=Table416[Restoration Level]),0),MATCH(E108,Table416[[#Headers],[Rural]:[Urban]],0)))","v":"-"},{"$f":"IF(F108='Streams & Habitat'!E29,'Streams & Habitat'!E28,\"-\")","v":"-"},null,null,{"$f":"IFERROR(IF(ISBLANK(J108),G108*H108,J108),\"-\")","v":"-"}]
[null,null,null,{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F109,'Streams & Habitat'!E26,\"-\")","v":"-"},{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F109,'Streams & Habitat'!E27,\"-\")","v":"-"},"Level 3",{"$f":"IF(D109=\"-\",\"-\",INDEX(Table416[[Rural]:[Urban]],MATCH(1,(D109=Table416[Width Range])*(F109=Table416[Restoration Level]),0),MATCH(E109,Table416[[#Headers],[Rural]:[Urban]],0)))","v":"-"},{"$f":"IF(F109='Streams & Habitat'!E29,'Streams & Habitat'!E28,\"-\")","v":"-"},null,null,"-"]
[null,null,null,{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F110,'Streams & Habitat'!E26,\"-\")","v":"-"},{"$f":"IF('Streams & Habitat'!E29='Costing Module'!F110,'Streams & Habitat'!E27,\"-\")","v":"-"},"Level 4",{"$f":"IF(D110=\"-\",\"-\",INDEX(Table416[[Rural]:[Urban]],MATCH(1,(D110=Table416[Width Range])*(F110=Table416[Restoration Level]),0),MATCH(E110,Table416[[#Headers],[Rural]:[Urban]],0)))","v":"-"},{"$f":"IF(F110='Streams & Habitat'!E29,'Streams & Habitat'!E28,\"-\")","v":"-"},null,null,"-"]
[null,null,null,"Total Streams and Habitat Project Cost",null,null,null,null,null,null,{"$f":"IFERROR(SUM(K107:K110),0)","v":0}]
[]
[null,null,"User-specified Project","User-Specified Project Costs"]
[null,null,null,"External Capital Cost Estimate",null,null,null,null,null,null,{"$f":"IF('User-Specified Project'!E29<>0,'User-Specified Project'!E29,\"-\")","v":"-"}]
[null,null,null,"External O&M Cost Estimate",null,null,null,null,null,null,{"$f":"IF('User-Specified Project'!E30<>0,'User-Specified Project'!E30,\"-\")","v":"-"}]
[null,null,null,"Total User-Specified Capital Project Cost",null,null,null,null,null,null,{"$f":"IF(K114=\"-\",0,K114)","v":0}]
[]
[null,null,null,"Additional External Costs"]
[null,null,null,"Additional Line Item","Related Module","Line Item Description",null,null,null,null,"Item Cost"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Additional Project Costs",null,null,null,null,null,null,{"$f":"IFERROR(SUM(K120:K125),0)","v":0}]

{"sheet":"Cost Summary Sheet","index":11,"n_rows":76,"n_cols":8,"rows_kept":76,"cut":false,"hidden":false,"merged":[[8,2,8,8],[1,0,1,15],[4,2,4,8],[5,2,5,8],[6,2,6,8],[7,2,7,8]]}
[]
["  C o s t   S u m m a r y   S h e e t"]
[]
[]
[null,null,{"$f":"IF(ISBLANK(Project_Name),\"Enter Project Name in Global Inputs\",Project_Name)","v":"Enter Project Name in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Project_ID),\"Enter Project ID in Global Inputs\",Project_ID)","v":"Enter Project ID in Global Inputs"}]
[null,null,{"$f":"IF(ISBLANK(Basin_Name),\"Enter Basin Name in Global Inputs\",Basin_Name)","v":"Enter Basin Name in Global Inputs"}]
[null,null,{"$f":"\"Cost Analysis Computed by \" & Cost_Estimator","v":"Cost Analysis Computed by "}]
[null,null,{"$f":"TODAY()","v":"2018-12-17"}]
[null,null,"Capital Construction Costs"]
[]
[null,null,null,{"$f":"'Costing Module'!D37:J37","v":"Total Pipelines Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K37,-3),0)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D75:J75","v":"Total Well Field Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K75,-3),0)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D83:J83","v":"Total Treatment Capital Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K83,-3),0)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D103:J103","v":"Total Ditches & Diversions Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K103,-3),0)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D111:J111","v":"Total Streams and Habitat Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K111,-3),0)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D116:J116","v":"Total User-Specified Capital Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K116,-3),0)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D126:J126","v":"Total Additional Project Costs"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K126,-3),0)","v":0}]
[]
[null,null,null,null,"Construction Project Costs Subtotal (Non-Reservoir)",null,null,{"$f":"ROUND(SUM(H12:H18),-3)","v":0}]
[]
[null,null,null,{"$f":"'Costing Module'!D91:J91","v":"Total Reservoir Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K91,-3),0)","v":0}]
[]
[null,null,null,null,"Construction Reservoir Project Cost Subtotal",null,null,{"$f":"ROUND(SUM(H22),-3)","v":0}]
[null,null,"Project Development Costs"]
[]
[null,null,null,"Land Acquisition",null,null,null,{"$f":"ROUND(IF('Global Inputs'!$H$42='Module References'!$H$4,'Global Inputs'!$G$41*'Global Inputs'!$G$42,'Global Inputs'!$G$42),-3)","v":0}]
[null,null,null,{"$f":"'Costing Module'!D95:J95","v":"Total Water Rights Project Cost"},null,null,null,{"$f":"IFERROR(ROUND('Costing Module'!K95,-3),0)","v":0}]
[]
[null,null,"Non-Reservoir Project Development Costs"]
[]
[null,null,null,{"$f":"'Global Inputs'!$C$36","v":"Engineering Services"},null,null,null,{"$f":"ROUND('Global Inputs'!G36*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$37","v":"Surveying"},null,null,null,{"$f":"ROUND('Global Inputs'!G37*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$38","v":"Legal Service"},null,null,null,{"$f":"ROUND('Global Inputs'!G38*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$39","v":"Financing and Bond Assistance"},null,null,null,{"$f":"ROUND('Global Inputs'!G39*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$40","v":"Environmental and Cultural Studies"},null,null,null,{"$f":"ROUND('Global Inputs'!G40*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$43","v":"Permitting"},null,null,null,{"$f":"ROUND('Global Inputs'!G43*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$44","v":"Interest During Construction"},null,null,null,{"$f":"ROUND('Global Inputs'!G44*$H$20,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!C60","v":"Power Connection Costs - Pump Stations"},null,null,null,{"$f":"ROUND('Global Inputs'!$G$60*SUM(SUM('Costing Module'!$E$24:$E$26),SUM('Costing Module'!$E$65:$E$74)),-3)","v":0}]
[]
[null,null,null,null,"Project Development Costs Subtotal (Non-Reservoir)",null,null,{"$f":"ROUND(SUM(H32:H39),-3)","v":0}]
[]
[null,null,null,null,"Total Project Cost (Non-Reservoir)",null,null,{"$f":"ROUND(H41+H20,-3)","v":0}]
[]
[null,null,"Reservoir Project Development Costs"]
[]
[null,null,null,{"$f":"'Global Inputs'!$C$36","v":"Engineering Services"},null,null,null,{"$f":"ROUND('Global Inputs'!G36*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$37","v":"Surveying"},null,null,null,{"$f":"ROUND('Global Inputs'!G37*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$38","v":"Legal Service"},null,null,null,{"$f":"ROUND('Global Inputs'!G38*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$39","v":"Financing and Bond Assistance"},null,null,null,{"$f":"ROUND('Global Inputs'!G39*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$40","v":"Environmental and Cultural Studies"},null,null,null,{"$f":"ROUND('Global Inputs'!G40*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$43","v":"Permitting"},null,null,null,{"$f":"ROUND('Global Inputs'!G43*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!$C$44","v":"Interest During Construction"},null,null,null,{"$f":"ROUND('Global Inputs'!G44*'Cost Summary Sheet'!$H$24,-3)","v":0}]
[]
[null,null,null,null,"Reservoir Project Development Costs Subtotal",null,null,{"$f":"ROUND(SUM(H47:H53),-3)","v":0}]
[]
[null,null,null,null,"Total Reservoir Project Cost",null,null,{"$f":"ROUND(H55+H24,-3)","v":0}]
[]
[null,null,null,null,"Total Project Cost",null,null,{"$f":"ROUND(SUM(H43,H57),-3)","v":0}]
[null,null,null,null,"Normalized Project Cost (per ac-ft per year)",null,null,{"$f":"IFERROR(H59/'Global Inputs'!$F$33,\"-\")","v":"-"}]
[]
[null,null,"Annual Costs"]
[]
[null,null,null,{"$f":"'Global Inputs'!C48","v":"Debt Service (Non-Reservoirs) Period"},null,null,null,{"$f":"ROUND((('Global Inputs'!G47*(1+'Global Inputs'!G47)^'Global Inputs'!G48)/((1+'Global Inputs'!G47)^'Global Inputs'!G48-1))*H43,-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!C49","v":"Debt Service (Reservoirs) Period"},null,null,null,{"$f":"ROUND((('Global Inputs'!G47*(1+'Global Inputs'!G47)^'Global Inputs'!G49)/((1+'Global Inputs'!G47)^'Global Inputs'!G49-1))*H57,-3)","v":0}]
[null,null,null,"Operations & Maintenance (Pipelines Project)",null,null,null,{"$f":"ROUND('Global Inputs'!G50*SUM('Costing Module'!K18:K20)+'Global Inputs'!G51*SUM('Costing Module'!K24:K26,'Costing Module'!K29:K31),-3)","v":0}]
[null,null,null,"Operations & Maintenance (Well Fields Project)",null,null,null,{"$f":"ROUND('Global Inputs'!G50*SUM('Costing Module'!K41:K50,'Costing Module'!K53:K62)+'Global Inputs'!G51*SUM('Costing Module'!K65:K74),-3)","v":0}]
[null,null,null,{"$f":"'Global Inputs'!C52","v":"Operations & Maintenance (Reservoirs)"},null,null,null,{"$f":"ROUND('Global Inputs'!G52*'Cost Summary Sheet'!H24,-3)","v":0}]
[null,null,null,"Operations & Maintenance (Ditches & Diversions)",null,null,null,{"$f":"ROUND('Global Inputs'!G53*'Costing Module'!K103,-3)","v":0}]
[null,null,null,"Operations & Maintenance (Streams & Habitat)",null,null,null,{"$f":"ROUND('Global Inputs'!G53*'Costing Module'!K111,-3)","v":0}]
[null,null,null,"Operations & Mainteance (Treatment)",null,null,null,{"$f":"IF('Costing Module'!K82=\"-\",0,ROUND('Costing Module'!K82,-3))","v":0}]
[null,null,null,"Operations & Maintenance (User-Specified)",null,null,null,{"$f":"IF('Costing Module'!K115=\"-\",0,ROUND('Costing Module'!K115,-3))","v":0}]
[null,null,null,{"$f":"'Global Inputs'!C57","v":"Power Costs"},null,null,null,{"$f":"ROUND('Global Inputs'!$G$57*SUM('Costing Module'!I24:I26,'Costing Module'!I29:I31,'Costing Module'!I53:I62,'Costing Module'!I65:I74),-3)","v":0}]
[]
[]
[null,null,null,null,"Total Annual Costs",null,null,{"$f":"ROUND(SUM(H64:H73),-3)","v":0}]

{"sheet":"Module References","index":12,"n_rows":260,"n_cols":36,"rows_kept":260,"cut":false,"hidden":false,"merged":[[41,15,41,16],[177,5,177,6],[177,7,177,8],[83,3,83,8],[83,9,83,14],[73,12,75,14],[41,13,41,14]]}
[]
["Global Inputs Tab"]
[null,"Basins",null,"Supply Needs",null,"Modules",null,"Land Acquisition Costs",null,"CONVERSIONS",null,null,null,null,"INFLATION ADJUSTMENT"]
[null,"Arkansas Basin",null,"Municipal & Industrial",null,"Pipelines",null,"$ per acre",null,"FROM","TO ","Conversion Factor","DEFINED NAME"]
[null,"Colorado Basin",null,"Self Supplied Industrial",null,"Well Fields",null,"Total Cost ($)",null,"Feet ","Inches",12,"FT_IN"]
[null,"Gunnison Basin",null,"Agricultural",null,"Reservoirs",null,null,null,"Yards","Feet",3,"YD_FT"]
[null,"Metro and South Platte Basin",null,"Environmental & Recreation",null,"Treatment",null,null,null,"Acres","Sq Ft",43560,"AC_SQFT"]
[null,"North Platte Basin",null,null,null,"Water Rights",null,null,null,"Sq Mi","Acres",640,"SQMI_AC"]
[null,"Rio Grande Basin",null,null,null,"Ditches & Diversions",null,null,null,"Sq Mi","Sq Ft",{"$f":"5280^2","v":27878400},"SQMI_SQFT"]
[null,"San Juan/Dolores (Southwest) Basin",null,null,null,"Streams & Habitats",null,null,null,"MG","gal",{"$f":"10^6","v":1000000},"MG_GAL"]
[null,"Yampa-White Basin",null,null,null,"Other Costs",null,null,null,"CF ","gal",7.4805200000000003,"CF_GAL"]
[null,null,null,null,null,null,null,null,null,"MG","AC-FT",{"$f":"10^6/7.48052/43560","v":3.0688830640997313},"MG_ACFT",null,null,"Compounding Interest:","A=P(1+r/n)^nt"]
[null,null,null,null,null,null,null,null,null,"AC-FT","CF",{"$f":"43560","v":43560},"ACFT_CF",null,null,"Escalation Rate (r): ",3.5000000000000003E-2]
["Assumptions",null,null,null,null,null,null,null,null,"Year","Seconds",{"$f":"365.25*24*3600","v":31557600},"YR_SEC",null,null,"Compounding/yr (n):",1]
[null,null,null,null,null,null,null,null,null,"Year","Minutes",525960,"YR_MIN"]
[null,null,null,null,null,null,null,null,null,"Year","Hours",8766,"YR_HR"]
["1)","All unit costs in 2017 dollars and geographically adjusted to best represent Colorado prices",null,null,null,null,null,null,null,"Year","Days",365.25,"YR_DAY",null,"Baseline CCI Time Period",{"$f":"'Global Inputs'!$F$30","v":2017}]
[null,null,null,null,null,null,null,null,null,"Year","Month",12,"YR_MO",null,"Project CCI Time Period",{"$f":"'Global Inputs'!$F$31","v":2017}]
[null,null,null,null,null,null,null,null,null,"Days","Seconds",{"$f":"86400","v":86400},"DAY_SEC",null,"Time in years (t)",{"$f":"$P$18-$P$17","v":0}]
[null,null,null,null,null,null,null,null,null,"Days","Minutes",{"$f":"DAY_SEC/60","v":1440},"DAY_MIN"]
[null,null,null,null,null,null,null,null,null,"Days","Hours",24,"DAY_HR"]
[null,null,null,null,null,null,null,null,null,"Hours","Minutes",60,"HR_MIN"]
[null,null,null,null,null,null,null,null,null,"Hours","Seconds",3600,"HR_SEC"]
[null,null,null,null,null,null,null,null,null,"Minutes","Seconds",60,"MIN_SEC"]
[null,null,null,null,null,null,null,null,null,"MGD","CFY",{"$f":"L10/L11*L17","v":48826819.52591531},"MGD_CFY"]
[null,null,null,null,null,null,null,null,null,"MGD","CFS",{"$f":"10^6/7.48052/86400","v":1.5472285448169478},"MGD_CFS"]
[null,null,null,null,null,null,null,null,null,"CFS","GPM",{"$f":"60*7.48052","v":448.83120000000002},"CFS_GPM"]
[null,null,null,null,null,null,null,null,null,"FT of Water","PSI",0.433,"FTH20_PSI"]
[null,null,null,null,null,null,null,null,null,"HP","KW",0.74570000000000003,"HP_kW"]
[null,null,null,null,null,null,null,null,null,"gpm/ft","HP",3960,"gpmft_HP"]
[null,null,null,null,null,null,null,null,null,"Hazen-Williams k Conversion","US customary units",1.3180000000000001,"HazWil_k"]
[]
[]
[]
[]
[]
[]
[]
[]
["Pipelines Module"]
["SHEET PASSWORD: SWSI2017"]
["Environment","Water Delivered","Pressure Classes","Nominal Pipe Diameter","Pump Type",null,"Pipelines",{"$f":"$P$17","v":2017},null,{"$f":"$P$18","v":2017},null,null,"Pump Stations",{"$f":"$P$17","v":2017},null,{"$f":"$P$18","v":2017},null,null,"Booster Storage",2017,{"$f":"$P$18","v":2017}]
[null,null,null,null,null,null,"Pipe Size","Undeveloped Costs","Developed Costs","Undeveloped Costs","Developed Costs",null,"Pump Station","Intake Pump Station Cost","Booster Pump Station Cost","Intake Pump Station Cost","Booster Pump Station Cost",null,"Tank Volume","Associated Boost Pump Storage (MG)","Associated Boost Pump Storage (MG)"]
["Urban","Raw",100,4,"Booster",null,"IN","Urban","Rural","Urban","Rural",null,"(HP)","($-millions)","($-millions)","($-millions)","($-millions)",null,"(MG)","($)","($)"]
["Rural","Treated",150,6,"Intake",null,4,102.12954705562497,152.62055908312496,{"$f":"H45*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":102.12954705562497},{"$f":"I45*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":152.62055908312496},null,0,0,0,{"$f":"N45*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"O45*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},null,0,0,{"$f":"T45*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0}]
[null,null,200,8,null,null,6,107.86716205874997,158.35817408624996,107.86716205874997,158.35817408624996,null,5,0.76874631056112408,0.71156385542917955,{"$f":"N46*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0.76874631056112408},{"$f":"O46*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0.71156385542917955},null,0.05,204604.78727242225,{"$f":"T46*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":204604.78727242225}]
[null,null,250,10,null,null,8,113.60477706187497,164.09578908937496,113.60477706187497,164.09578908937496,null,10,0.82788064214274892,0.78272024097209758,0.82788064214274892,0.78272024097209758,null,0.1,221162.40011527724,{"$f":"T47*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":221162.40011527724}]
[null,null,300,12,null,null,10,119.34239206499997,169.83340409249996,119.34239206499997,169.83340409249996,null,20,0.88701497372437388,0.82185625302070231,0.88701497372437388,0.82185625302070231,null,0.5,473074.65265299939,473074.65265299939]
[null,null,350,14,null,null,12,125.08000706812497,175.57101909562496,125.08000706812497,175.57101909562496,null,25,0.94614930530599883,0.86294906567173746,0.94614930530599883,0.86294906567173746,null,1,801861.53624683409,801861.53624683409]
[null,null,null,16,null,null,14,137.70276007499996,194.50514860593745,137.70276007499996,194.50514860593745,null,50,1.1826866316324984,0.90609651895532428,1.1826866316324984,0.90609651895532428,null,1.5,1110542.747102916,1110542.747102916]
[null,null,null,18,null,null,16,150.32551308187496,213.43927811624994,150.32551308187496,213.43927811624994,null,100,1.7740299474487478,0.95140134490309047,1.7740299474487478,0.95140134490309047,null,2,1419223.9579589982,1419223.9579589982]
[null,null,null,20,null,null,18,162.94826608874996,244.42239913312494,162.94826608874996,244.42239913312494,null,200,2.3653732632649969,1.9116710176381377,2.3653732632649969,1.9116710176381377,null,2.5,1537492.6211222482,1537492.6211222482]
[null,null,null,24,null,null,20,175.57101909562496,275.40552014999992,175.57101909562496,275.40552014999992,null,300,2.9567165790812466,2.1028381194019516,2.9567165790812466,2.1028381194019516,null,3,1655761.2842854981,1655761.2842854981]
[null,null,null,30,null,null,24,200.81652510937494,300.65102616374992,200.81652510937494,300.65102616374992,null,400,3.5480598948974955,2.6658608211371293,3.5480598948974955,2.6658608211371293,null,3.5,1892298.6106119975,1892298.6106119975]
[null,null,null,36,null,null,30,226.06203112312494,351.14203819124992,226.06203112312494,351.14203819124992,null,500,4.1394032107137448,2.7409827106051621,4.1394032107137448,2.7409827106051621,null,4,2128835.9369384972,2128835.9369384972]
[null,null,null,42,null,null,36,251.30753713687494,401.63305021874987,251.30753713687494,401.63305021874987,null,600,4.7307465265299937,2.8161046000731949,4.7307465265299937,2.8161046000731949,null,5,2365373.2632649969,2365373.2632649969]
[null,null,null,48,null,null,42,288.02827315687495,463.59929225249988,288.02827315687495,463.59929225249988,null,700,5.3220898423462435,2.8912264895412285,5.3220898423462435,2.8912264895412285,null,6,2720179.2527547465,2720179.2527547465]
[null,null,null,54,null,null,48,338.51928518437489,539.33581029374989,338.51928518437489,539.33581029374989,null,800,5.9134331581624933,3.406374036427922,5.9134331581624933,3.406374036427922,null,7,3193253.9054077459,3193253.9054077459]
[null,null,null,60,null,null,54,376.38754420499987,626.54755834124978,376.38754420499987,626.54755834124978,null,900,6.5047764739787413,3.536499133073288,6.5047764739787413,3.536499133073288,null,8,3666328.5580607457,3666328.5580607457]
[null,null,null,64,null,null,60,438.35378623874988,727.52958239624979,438.35378623874988,727.52958239624979,null,1000,7.096119789794991,3.6666242297186535,7.096119789794991,3.6666242297186535,null,10,4587641.4441024614,4587641.4441024614]
[null,null,null,66,null,null,66,501.46755127312485,827.36408345062478,501.46755127312485,827.36408345062478,null,2000,9.934567705712988,4.9678751961723098,9.934567705712988,4.9678751961723098,null,12,5734551.805128077,5734551.805128077]
[null,null,null,72,null,null,72,577.20406931437481,952.4440905187497,577.20406931437481,952.4440905187497,null,3000,11.472060326835233,6.269126162625966,11.472060326835233,6.269126162625966,null,14,6909255.3019970562,{"$f":"T62*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":6909255.3019970562}]
[null,null,null,78,null,null,78,651.79306435499984,1102.7696036006246,651.79306435499984,1102.7696036006246,null,4000,13.009552947957483,7.5703771290796231,13.009552947957483,7.5703771290796231]
[null,null,null,84,null,null,84,752.77508840999974,1303.5861287099997,752.77508840999974,1303.5861287099997,null,5000,14.192239579589982,8.8716280955332802,14.192239579589982,8.8716280955332802]
[null,null,null,90,null,null,90,877.85509547812478,1504.4026538193746,877.85509547812478,1504.4026538193746,null,6000,15.374926211222482,10.172879061986935,15.374926211222482,10.172879061986935]
[null,null,null,96,null,null,96,1002.9351025462497,1755.7101909562496,1002.9351025462497,1755.7101909562496,null,7000,16.557612842854979,11.474130028440593,16.557612842854979,11.474130028440593]
[null,null,null,102,null,null,102,1128.0151096143748,2005.8702050924994,1128.0151096143748,2005.8702050924994,null,8000,17.740299474487475,12.775380994894247,17.740299474487475,12.775380994894247]
[null,null,null,108,null,null,108,1328.8316347237496,2257.1777422293744,1328.8316347237496,2257.1777422293744,null,9000,18.922986106119975,14.076631961347907,18.922986106119975,14.076631961347907]
[null,null,null,null,null,null,"Italics indicates interpolated value",null,null,null,null,null,30000,43.75940537040244,34.068471110805753,43.75940537040244,34.068471110805753]
[null,null,null,null,null,null,null,null,null,null,null,null,40000,55.586271686727436,42.585588888507189,55.586271686727436,42.585588888507189]
[null,null,null,null,null,null,null,null,null,null,null,null,50000,66.230451371419917,53.23198611063399,66.230451371419917,53.23198611063399]
[null,null,null,null,null,null,null,null,null,null,null,null,60000,76.874631056112392,63.878383332760777,76.874631056112392,63.878383332760777]
[null,null,null,null,null,null,null,null,null,null,null,null,70000,88.701497372437387,76.654059999312949,88.701497372437387,76.654059999312949]
[null,null,null,null,null,null,null,null,null,null,null,null,"*Costs were pulled from Texas UCM tool then excalated from 2013 to 2017 dollars with a 3.5% interest rate. This method was chosen because it resulted in the most conservative cost estimates."]
[]
[]
[]
[]
["Well Field"]
[]
[null,"PSW","Public Supply Wells"]
[null,"ASR","ASR Wells"]
[null,"IRG","Irrigation Wells"]
[null,null,null,{"$f":"$P$17","v":2017},null,null,null,null,null,{"$f":"$P$18","v":2017},null,null,null,null,null,"ADD TITLES"]
[null,null,null,"Well Capacity",null,null,null,null,null,"Well Capacity"]
[null,"Well Type","Well Depth",100,175,350,700,1000,1800,100,175,350,700,1000,1800,{"$f":"'Costing Module'!F53","v":"-"},{"$f":"'Costing Module'!F54","v":"-"},{"$f":"'Costing Module'!F55","v":"-"},{"$f":"'Costing Module'!F56","v":"-"},{"$f":"'Costing Module'!F57","v":"-"},{"$f":"'Costing Module'!F58","v":"-"},{"$f":"'Costing Module'!F59","v":"-"},{"$f":"'Costing Module'!F60","v":"-"},{"$f":"'Costing Module'!F61","v":"-"},{"$f":"'Costing Module'!F62","v":"-"}]
[null,"PSW",150,142451.05672023955,216250.70253410743,368998.22906933952,417054.33497246285,520030.8599887045,760309.02413105778,{"$f":"D87*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":142451.05672023955},{"$f":"E87*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":216250.70253410743},{"$f":"F87*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":368998.22906933952},{"$f":"G87*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":417054.33497246285},{"$f":"H87*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":520030.8599887045},{"$f":"I87*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":760309.02413105778},{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J87:$O87),0)","v":{"$error":"#VALUE!"}}]
[null,"PSW",300,192222.05823922998,274603.27825222327,439365.71827820991,502867.71159045369,621291.30670244736,880447.51485891861,192222.05823922998,274603.27825222327,439365.71827820991,502867.71159045369,621291.30670244736,880447.51485891861,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J88:$O88),0)","v":{"$error":"#VALUE!"}}]
[null,"PSW",500,248859.73834147872,343254.68915859493,521746.93829120323,600696.00169919909,739713.71912780951,1024614.6498816569,248859.73834147872,343254.68915859493,521746.93829120323,600696.00169919909,739713.71912780951,1024614.6498816569,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J89:$O89),0)","v":{"$error":"#VALUE!"}}]
[null,"PSW",700,300348.00084959954,405040.60416833992,595546.58410507115,689941.53492218733,846122.40074904868,1151618.6365061444,300348.00084959954,405040.60416833992,595546.58410507115,689941.53492218733,846122.40074904868,1151618.6365061444,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J90:$O90),0)","v":{"$error":"#VALUE!"}}]
[null,"PSW",1000,394742.95166671573,518314.78168620577,732848.22323118278,852987.8966456753,1043493.8765824065,1388464.6440435001,394742.95166671573,518314.78168620577,732848.22323118278,852987.8966456753,1043493.8765824065,1388464.6440435001,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J91:$O91),0)","v":{"$error":"#VALUE!"}}]
[null,"PSW",1500,552639.8957960757,708820.76162293693,959396.57826691447,1125875.0965953998,1369585.4173427506,1779775.4391052183,552639.8957960757,708820.76162293693,959396.57826691447,1125875.0965953998,1369585.4173427506,1779775.4391052183,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J92:$O92),0)","v":{"$error":"#VALUE!"}}]
[null,"PSW",2000,710536.83992543572,897610.66325716942,1185944.933302646,1398762.2965451244,1697394.2190922252,2172801.1297828038,710536.83992543572,897610.66325716942,1185944.933302646,1398762.2965451244,1697394.2190922252,2172801.1297828038,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J93:$O93),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",150,157896.94412936,243710.32074735078,423919.83086908952,478840.24998220784,597262.66240756994,880447.51485891861,157896.94412936,243710.32074735078,423919.83086908952,478840.24998220784,597262.66240756994,880447.51485891861,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J94:$O94),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",300,207669.12833498203,302064.07915209827,494286.13739132823,564653.62660019868,698523.10912131285,1002303.2665759099,207669.12833498203,302064.07915209827,494286.13739132823,564653.62660019868,698523.10912131285,1002303.2665759099,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J95:$O95),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",500,264305.62575059914,372431.56836096867,576667.35740432155,662481.91670894402,818662.78253580525,1144754.3232961493,264305.62575059914,372431.56836096867,576667.35740432155,662481.91670894402,818662.78253580525,1144754.3232961493,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J96:$O96),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",700,317509.96656121872,434217.48337071366,652184.26420731994,751727.44993193238,923355.38585454563,1273474.3882231356,317509.96656121872,434217.48337071366,652184.26420731994,751727.44993193238,923355.38585454563,1273474.3882231356,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J97:$O97),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",1000,410188.83907583624,547491.66088857944,787769.82503093279,914773.81165542034,1120726.8616879035,1508604.3174579928,410188.83907583624,547491.66088857944,787769.82503093279,914773.81165542034,1120726.8616879035,1508604.3174579928,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J98:$O98),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",1500,569803.0441943265,736281.56252281193,1014316.9973800328,1187661.0116051447,1446818.4024482477,1899913.9298330792,569803.0441943265,736281.56252281193,1014316.9973800328,1187661.0116051447,1446818.4024482477,1899913.9298330792,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J99:$O99),0)","v":{"$error":"#VALUE!"}}]
[null,"ASR",2000,725983.91002118774,925071.46415704442,1240865.3524157645,1460548.2115548693,1774626.0215110907,2292940.8031972963,725983.91002118774,925071.46415704442,1240865.3524157645,1460548.2115548693,1774626.0215110907,2292940.8031972963,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J100:$O100),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",150,78949.063407995811,121855.75171699122,207669.12833498203,238562.08583985455,302064.07915209827,435933.56167321239,78949.063407995811,121855.75171699122,207669.12833498203,238562.08583985455,302064.07915209827,435933.56167321239,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J101:$O101),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",300,104692.6033187404,156180.86582686123,254007.97324897497,300348.00084959954,381013.14256009413,532044.59079282742,104692.6033187404,156180.86582686123,254007.97324897497,300348.00084959954,381013.14256009413,532044.59079282742,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J102:$O102),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",500,130437.32591611662,195655.39753085913,303780.15745459701,367282.15076684073,466826.51917808491,643602.69000819442,{"$f":"D103*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":130437.32591611662},195655.39753085913,{"$f":"F103*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":303780.15745459701},367282.15076684073,466826.51917808491,643602.69000819442,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J103:$O103),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",700,151031.4482327333,224832.27673323284,346686.84576359246,423919.83086908952,542342.2432944515,739713.71912780951,151031.4482327333,224832.27673323284,346686.84576359246,423919.83086908952,542342.2432944515,739713.71912780951,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J104:$O104),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",1000,197371.47583335786,290050.34834797535,435933.56167321239,540626.16499195283,691657.61322468612,928503.620762042,197371.47583335786,290050.34834797535,435933.56167321239,540626.16499195283,691657.61322468612,928503.620762042,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J105:$O105),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",1500,276320.53924135369,401608.4475633424,583532.85330094828,734564.30153368146,938801.27326366608,1240865.3524157645,276320.53924135369,401608.4475633424,583532.85330094828,734564.30153368146,938801.27326366608,1240865.3524157645,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J106:$O106),0)","v":{"$error":"#VALUE!"}}]
[null,"IRG",2000,353552.34166021913,509733.2074870803,731132.14492868399,926787.54245954321,1187661.0116051447,1554943.1623719856,353552.34166021913,509733.2074870803,731132.14492868399,926787.54245954321,1187661.0116051447,1554943.1623719856,{"$f":"IF(P$86>0,interp(P$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q$86>0,interp(Q$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(R$86>0,interp(R$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(S$86>0,interp(S$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(T$86>0,interp(T$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(U$86>0,interp(U$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(V$86>0,interp(V$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(W$86>0,interp(W$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(X$86>0,interp(X$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}},{"$f":"IF(Y$86>0,interp(Y$86,$J$86:$O$86,$J107:$O107),0)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
["Treatment Module"]
[]
[null,null,{"$f":"$P$17","v":2017},null,null,null,null,null,null,null,{"$f":"$P$18","v":2017},null,null,null,null,null,null,null,null,null,{"$f":"$P$17","v":2017},null,null,null,null,null,null,null,{"$f":"$P$18","v":2017}]
[null,"Capital Costs\n$1000/MGD",null,null,null,null,"Treatment Types",null,null,null,null,null,null,"Treatment Types",null,null,null,null,null,"O&M Cost\n$1000/MGD",null,null,null,null,"Treatment Types",null,null,null,null,null,null,null,"Treatment Types"]
[null,"MGD","Direct Filtration","Conventional","Conventional + Enhanced Coagulation","Conventional + Lime Softening","Conventional + Ozone/UV","Conventional + GAC","Conventional + Membranes","Conventional + Nanofiltration/Reverse Osmosis ","Direct Filtration","Conventional","Conventional + Enhanced Coagulation","Conventional + Lime Softening","Conventional + Ozone/UV","Conventional + GAC","Conventional + Membranes","Conventional + Nanofiltration/Reverse Osmosis ",null,"MGD","Direct Filtration","Conventional","Conventional + Enhanced Coagulation","Conventional + Lime Softening","Conventional + Ozone/UV","Conventional + GAC","Conventional + Membranes","Conventional + Nanofiltration/Reverse Osmosis ","Direct Filtration","Conventional","Conventional + Enhanced Coagulation","Conventional + Lime Softening","Conventional + Ozone/UV","Conventional + GAC","Conventional + Membranes","Conventional + Nanofiltration/Reverse Osmosis "]
[null,0.5,4353.3336801781406,5857.6770166730639,6178.4329972768846,6499.1889778807063,5939.5236309779621,7697.0788871824907,4034.4995142859716,9667.9176813733193,{"$f":"C119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":4353.3336801781406},{"$f":"D119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":5857.6770166730639},{"$f":"E119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":6178.4329972768846},{"$f":"F119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":6499.1889778807063},{"$f":"G119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":5939.5236309779621},{"$f":"H119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":7697.0788871824907},{"$f":"I119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":4034.4995142859716},{"$f":"J119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":9667.9176813733193},null,0.5,483.99294217595246,487.13603498610541,457.78869997012708,428.44136495414875,649.69840473374222,673.55972428904533,448.54772074054216,2109.8799973363439,{"$f":"U119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":483.99294217595246},{"$f":"V119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":487.13603498610541},{"$f":"W119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":457.78869997012708},{"$f":"X119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":428.44136495414875},{"$f":"Y119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":649.69840473374222},{"$f":"Z119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":673.55972428904533},{"$f":"AA119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":448.54772074054216},{"$f":"AB119*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":2109.8799973363439}]
[null,1,6730.5322893249695,8852.1545991403309,9224.4981560501765,9596.8417129600239,8855.9509211043242,11476.501668456678,7173.0650599275577,15974.25411254284,6730.5322893249695,8852.1545991403309,9224.4981560501765,9596.8417129600239,8855.9509211043242,11476.501668456678,7173.0650599275577,15974.25411254284,null,1,567.91932710224262,597.4941996679222,568.94150011718557,540.38880056644882,806.66528063917531,836.29148549862532,605.26271458148778,3304.7194297440378,{"$f":"U120*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":567.91932710224262},597.4941996679222,568.94150011718557,540.38880056644882,806.66528063917531,836.29148549862532,605.26271458148778,3304.7194297440378]
[null,1.5,8684.4111753743691,11270.587450166182,11662.477740280345,12054.368030394508,11187.076132808061,14497.426538054222,10043.746278438313,21428.679174229663,8684.4111753743691,11270.587450166182,11662.477740280345,12054.368030394508,11187.076132808061,14497.426538054222,10043.746278438313,21428.679174229663,null,1.5,623.60688591735129,673.30242481838604,646.14312637908097,618.98382793977601,915.52257184108021,949.1467526727165,721.22068262498738,4296.661803107002,623.60688591735129,673.30242481838604,646.14312637908097,618.98382793977601,915.52257184108021,949.1467526727165,721.22068262498738,4296.661803107002]
[null,2,10405.833374066635,13377.426038349102,13774.164079072933,14170.902119796765,13204.40351612763,17111.698148945597,12753.220609337388,26394.409002860262,10405.833374066635,13377.426038349102,13774.164079072933,14170.902119796765,13204.40351612763,17111.698148945597,12753.220609337388,26394.409002860262,null,2,666.39889550085536,732.85343928004329,707.22020932664054,681.5869793732378,1001.5552912668015,1038.3391754245838,816.73127902138833,5176.2285793882947,666.39889550085536,732.85343928004329,707.22020932664054,681.5869793732378,1001.5552912668015,1038.3391754245838,816.73127902138833,5176.2285793882947]
[null,2.5,11972.766192041427,15279.243538898301,15672.293201511799,16065.342864125296,15016.476059871185,19459.978277969192,15348.804876890403,31025.762482658851,11972.766192041427,15279.243538898301,15672.293201511799,16065.342864125296,15016.476059871185,19459.978277969192,15348.804876890403,31025.762482658851,null,2.5,701.60295351054322,782.64861343163614,758.5613254001895,734.47403736874287,1073.8169025695897,1113.254721824509,899.44246330126657,5980.6839201158409,701.60295351054322,782.64861343163614,758.5613254001895,734.47403736874287,1073.8169025695897,1113.254721824509,899.44246330126657,5980.6839201158409]
[null,3,13426.655093261765,17032.1754251768,17415.956783266251,17799.738141355698,16680.158769987622,21615.958767081123,17857.09608974728,35406.982844478538,13426.655093261765,17032.1754251768,17415.956783266251,17799.738141355698,16680.158769987622,21615.958767081123,17857.09608974728,35406.982844478538,null,3,731.74290813884488,825.8356281583799,803.27686401149697,780.71809986461403,1136.7124606814191,1178.4602302144688,973.20300158301029,6729.9400549604834,731.74290813884488,825.8356281583799,803.27686401149697,780.71809986461403,1136.7124606814191,1178.4602302144688,973.20300158301029,6729.9400549604834]
[null,3.5,14792.80678455787,18670.258202245277,19040.849977599897,19411.441752954517,18229.787868998043,23624.136217331092,20295.046949921489,39590.571250898931,14792.80678455787,18670.258202245277,19040.849977599897,19411.441752954517,18229.787868998043,23624.136217331092,20295.046949921489,39590.571250898931,null,3.5,758.23381088898611,864.20373604034194,843.14247872678754,822.08122141323315,1192.7554468642879,1236.5614938879389,1040.2663176679293,7436.2042166117972,758.23381088898611,864.20373604034194,843.14247872678754,822.08122141323315,1192.7554468642879,1236.5614938879389,1040.2663176679293,7436.2042166117972]
[null,4,16088.083906911759,20216.041801719057,20570.549766875476,20925.057732031899,19688.035059139838,25513.891079319154,22674.35671524085,43612.09941852362,16088.083906911759,20216.041801719057,20570.549766875476,20925.057732031899,19688.035059139838,25513.891079319154,22674.35671524085,43612.09941852362,null,4,781.95522978708368,898.8776188339325,879.27822315404819,859.67882747416377,1243.5306508663591,1289.201506791112,1102.0833863740445,8107.6370858355149,781.95522978708368,898.8776188339325,879.27822315404819,859.67882747416377,1243.5306508663591,1289.201506791112,1102.0833863740445,8107.6370858355149]
[null,4.5,17324.423764337094,21685.41234183469,22021.623194774984,22357.834047715278,21070.826580857851,27305.862302681089,25003.557181861939,47497.107452295735,17324.423764337094,21685.41234183469,22021.623194774984,22357.834047715278,21070.826580857851,27305.862302681089,25003.557181861939,47497.107452295735,null,4.5,803.49425430703832,930.61511099101676,912.44106149110871,894.26701199120055,1290.1087234376196,1337.4902412106928,1159.6520258475095,8750.03173517703,803.49425430703832,930.61511099101676,912.44106149110871,894.26701199120055,1290.1087234376196,1337.4902412106928,1159.6520258475095,8750.03173517703]
[null,5,18510.662257522075,23090.079152411683,23406.254341322354,23722.429530233025,22389.872194558615,29015.224664924117,27289.128573250917,51264.733363224863,18510.662257522075,23090.079152411683,23406.254341322354,23722.429530233025,22389.872194558615,29015.224664924117,27289.128573250917,51264.733363224863,null,5,823.26381756574983,959.95363372550037,943.16918875635577,926.38474378721116,1333.2506386888488,1382.2166193735395,1213.69246074597,9367.6864696372486,823.26381756574983,959.95363372550037,943.16918875635577,926.38474378721116,1333.2506386888488,1382.2166193735395,1213.69246074597,9367.6864696372486]
[null,6,20758.467483046221,25739.119721724797,26011.297241949462,26283.47476217413,24870.457060361237,32229.835563827139,31748.699331744683,58504.07672465311,20758.467483046221,25739.119721724797,26011.297241949462,26283.47476217413,24870.457060361237,32229.835563827139,31748.699331744683,58504.07672465311,null,6,858.63016541876118,1012.9244446426985,998.8181805415669,984.71191644043529,1411.3417385985506,1463.1757526288579,1313.2236846605465,10541.276758852226,858.63016541876118,1012.9244446426985,998.8181805415669,984.71191644043529,1411.3417385985506,1463.1757526288579,1313.2236846605465,10541.276758852226]
[null,7,22870.625370747606,28214.599668387185,28438.975259962928,28663.350851538675,27180.985664907217,35224.069116081533,36083.209739048791,65416.875505837997,22870.625370747606,28214.599668387185,28438.975259962928,28663.350851538675,27180.985664907217,35224.069116081533,36083.209739048791,65416.875505837997,null,7,889.71470065299945,1059.9846501402433,1048.433728662467,1036.8828071846908,1480.9246879296152,1535.3142584727473,1403.7177901157697,11647.528186150728,889.71470065299945,1059.9846501402433,1048.433728662467,1036.8828071846908,1480.9246879296152,1535.3142584727473,1403.7177901157697,11647.528186150728]
[null,8,24873.206642043591,30550.596576446344,30724.492608646142,30898.388640845944,29355.261978815528,38041.732172997268,40313.460277913298,72061.903850836461,24873.206642043591,30550.596576446344,30724.492608646142,30898.388640845944,29355.261978815528,38041.732172997268,40313.460277913298,72061.903850836461,null,8,917.54951204084909,1102.5137228452154,1093.4090069103001,1084.3042909753849,1543.9671610023752,1600.6720775346389,1487.1326980117706,12699.222870263491,917.54951204084909,1102.5137228452154,1093.4090069103001,1084.3042909753849,1543.9671610023752,1600.6720775346389,1487.1326980117706,12699.222870263491]
[null,9,26784.667132395934,32771.1176375262,32892.587244217371,33014.056850908535,31417.032351541122,40713.597829588922,44454.619900197591,78481.361031759297,26784.667132395934,32771.1176375262,32892.587244217371,33014.056850908535,31417.032351541122,40713.597829588922,44454.619900197591,78481.361031759297,null,9,942.82349280762742,1141.4411807090232,1134.6856011183345,1127.930021527646,1601.7984773617336,1660.6273509637708,1564.8148472933356,13705.434541251849,942.82349280762742,1141.4411807090232,1134.6856011183345,1127.930021527646,1601.7984773617336,1660.6273509637708,1564.8148472933356,13705.434541251849]
[null,10,28618.667709373301,34893.85805699903,34961.452919350573,35029.047781702109,33383.756274770727,43262.291988738987,48518.210001396015,84706.868352285281,28618.667709373301,34893.85805699903,34961.452919350573,35029.047781702109,33383.756274770727,43262.291988738987,48518.210001396015,84706.868352285281,null,10,966.02118038653214,1177.4261949590561,1172.93299488813,1168.4397948172036,1655.3634621606523,1716.1596042828971,1637.7360969427709,14672.895670093141,966.02118038653214,1177.4261949590561,1172.93299488813,1168.4397948172036,1655.3634621606523,1716.1596042828971,1637.7360969427709,14672.895670093141]
[null,15,36926.689746931399,44426.955528237813,44213.06087408524,43999.166219932667,42171.261603875064,54650.094435871564,67935.336856254726,113631.98826568719,36926.689746931399,44426.955528237813,44213.06087408524,43999.166219932667,42171.261603875064,54650.094435871564,67935.336856254726,113631.98826568719,null,15,1060.7447770880242,1326.8144068197209,1332.596994311333,1338.379581802945,1878.7502705065281,1947.7506870729508,1951.498278914097,19077.272152655903,1060.7447770880242,1326.8144068197209,1332.596994311333,1338.379581802945,1878.7502705065281,1947.7506870729508,1951.498278914097,19077.272152655903]
[null,20,44246.29060079695,52731.795420234543,52228.218998267308,51724.642576300073,49775.861752535711,64504.960059174606,86262.069359261062,139965.89386012044,{"$f":"C135*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":44246.29060079695},52731.795420234543,52228.218998267308,51724.642576300073,49775.861752535711,64504.960059174606,86262.069359261062,139965.89386012044,null,20,1133.5332624172556,1444.1660470574182,1458.9537261544335,1473.7414052514489,2055.2986155336162,2130.7830813865353,2209.9334139233238,22982.712662099646,1133.5332624172556,1444.1660470574182,1458.9537261544335,1473.7414052514489,2055.2986155336162,2130.7830813865353,2209.9334139233238,22982.712662099646]
[]
[]
[]
[null,"Direct Filtration"]
[null,"Conventional"]
[null,"Conventional + Enhanced Coagulation"]
[null,"Conventional + Lime Softening"]
[null,"Conventional + Ozone/UV"]
[null,"Conventional + GAC"]
[null,"Conventional + Membranes"]
[null,"Conventional + Nanofiltration/Reverse Osmosis "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O&M Cost Curve Equations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Filtration","y = 319.55x^0.2307"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional","y = 336.19x^0.2946"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional + Enhanced Coagulation","y = 320.09x^0.3142"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional + Lime Softening","y = 304.06x^0.3349"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional + Ozone/UV","y = 453.89x^0.3122"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional + GAC","y = 470.56x^0.3122"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional + Membranes","y = 340.56x^0.4323"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conventional + Nanofiltration/Reverse Osmosis ","y = 1859.5x^0.6474"]
[]
["Reservoir Module"]
[]
[null,null,null,null,null,2017,null,{"$f":"$P$18","v":2017}]
[null,null,null,null,null,1,2,1,2]
[null,"Project Type","Reference ",null,"Storage (AF)","New Reservoir\nCost in Millions ($)","Reservoir Expansion\nCost in Millions ($)","New Reservoir\nCost in Millions ($)","Reservoir Expansion\nCost in Millions ($)",null,"Reservoir Rehab",null,"Level of Rehab"]
[null,null,0,null,0,0,0,{"$f":"F181*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"G181*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},null,"Dam Crest Raise",null,1]
[null,"New Reservoir",1,null,500,150.438355,1.234005,{"$f":"F182*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":150.438355},{"$f":"G182*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":1.234005},null,"Spillway Improvements",null,2]
[null,"Reservoir Expansion",2,null,1000,150.87671,2.46801,150.87671,2.46801,null,"Outlet Works Improvements",null,3]
[null,null,null,null,2000,151.75342000000001,4.9360200000000001,151.75342000000001,4.9360200000000001,null,"Seepage Control",null,4]
[null,null,null,null,5000,154.38355000000001,12.340050000000002,154.38355000000001,12.340050000000002,null,"Sediment Removal"]
[null,null,null,null,10000,158.7671,24.680100000000003,158.7671,24.680100000000003]
[null,null,null,null,15000,163.15065000000001,37.020150000000001,163.15065000000001,37.020150000000001]
[null,null,null,null,20000,167.5342,49.360200000000006,167.5342,49.360200000000006]
[null,null,null,null,25000,171.91775000000001,61.700250000000004,171.91775000000001,61.700250000000004]
[null,null,null,null,30000,176.3013,74.040300000000002,176.3013,74.040300000000002]
[null,null,null,null,35000,180.68485000000001,86.380350000000021,180.68485000000001,86.380350000000021]
[null,null,null,null,40000,185.0684,98.720400000000012,185.0684,98.720400000000012]
[null,null,null,null,45000,189.45195000000001,111.06045000000002,189.45195000000001,111.06045000000002]
[null,null,null,null,50000,193.8355,123.40050000000001,193.8355,123.40050000000001]
[null,null,null,null,55000,198.21905000000001,135.74055000000001,198.21905000000001,135.74055000000001]
[null,null,null,null,60000,202.6026,148.0806,202.6026,148.0806]
[null,null,null,null,65000,206.98615000000001,160.42064999999999,206.98615000000001,160.42064999999999]
[null,null,null,null,70000,211.36969999999999,172.76070000000004,211.36969999999999,172.76070000000004]
[null,null,null,null,75000,215.75325000000001,185.10075000000003,215.75325000000001,185.10075000000003]
[null,null,null,null,80000,220.13679999999999,197.44080000000002,220.13679999999999,197.44080000000002]
[null,null,null,null,85000,224.52035000000001,209.78085000000004,224.52035000000001,209.78085000000004]
[null,null,null,null,90000,228.90389999999999,222.12090000000003,228.90389999999999,222.12090000000003]
[null,null,null,null,95000,233.28745000000001,234.46095000000003,233.28745000000001,234.46095000000003]
[null,null,null,null,100000,237.67099999999999,246.80100000000002,237.67099999999999,246.80100000000002]
[]
["Water Rights Module"]
[]
[null,"Water Rights Type"]
[]
[null,"Leased Right"]
[null,"Permanent Purchase"]
[]
["Ditches and Diversions Module"]
[null,null,null,null,null,null,null,"New Ditch",null,null,null,null,null,null,null,null,null,null,null,"Ditch Rehabilitation","Ditch Rehabilitation Projects account for only MATERIAL costs"]
[null,null,null,null,null,null,null,"Ditch cost per linear foot",2017,null,null,null,null,{"$f":"$P$18","v":2017},null,null,null,null,null,"Ditch cost per linear foot",2017,null,null,null,null,{"$f":"$P$18","v":2017},null,null,null,null,null,"DIVERSION STRUCTURE","y = 3,641.6x + 391,631"]
[null,"Diversion Structures",null,"Ditch Type",null,"Type of Project",null,"Discharge (cfs)","Non-Reinforced Concreted Lined","Reinforced Concreted Lined","Synthetic Lining","Closed Conduit (PVC)","Closed Conduit (DIP)","Non-Reinforced Concreted Lined2","Reinforced Concreted Lined3","Synthetic Lining4","Closed Conduit (PVC)5","Closed Conduit (DIP)6",null,"Discharge (cfs)","Non-Reinforced Concreted Lined","Reinforced Concreted Lined","Synthetic Lining","Closed Conduit (PVC)","Closed Conduit (DIP)","Non-Reinforced Concreted Lined2","Reinforced Concreted Lined3","Synthetic Lining4","Closed Conduit (PVC)5","Closed Conduit (DIP)6",null,"Discharge (cfs)","Cost of Diversion"]
[null,"None",null,null,null,null,null,0,{"$f":"13.974*H217^0.1644","v":0},{"$f":"19.368*H217^0.1379","v":0},{"$f":"7.0901*H217^0.1786","v":0},{"$f":"35.518*H217^0.7899","v":0},{"$f":"126.5*H217^0.3836","v":0},{"$f":"I217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"J217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"K217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"L217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"M217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},null,0,{"$f":"3.8528*T217^0.3295","v":0},{"$f":"8.1268*T217^0.2258","v":0},{"$f":"4.3749*T217^0.2307","v":0},{"$f":"33.52*T217^0.7918","v":0},{"$f":"120.35*T217^0.3838","v":0},{"$f":"U217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"V217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"W217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"X217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},{"$f":"Y217*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":0},null,0,0]
[null,"Concrete Check Dam",null,"Non-Reinforced Concreted Lined",null,"New Ditch",null,1,{"$f":"13.974*H218^0.1644","v":13.974},{"$f":"19.368*H218^0.1379","v":19.367999999999999},{"$f":"7.0901*H218^0.1786","v":7.0900999999999996},{"$f":"35.518*H218^0.7899","v":35.518000000000001},{"$f":"126.5*H218^0.3836","v":126.5},{"$f":"I218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":13.974},{"$f":"J218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":19.367999999999999},{"$f":"K218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":7.0900999999999996},{"$f":"L218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":35.518000000000001},{"$f":"M218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":126.5},null,1,{"$f":"3.8528*T218^0.3295","v":3.8527999999999998},{"$f":"8.1268*T218^0.2258","v":8.1267999999999994},{"$f":"4.3749*T218^0.2307","v":4.3749000000000002},{"$f":"33.52*T218^0.7918","v":33.520000000000003},{"$f":"120.35*T218^0.3838","v":120.35},{"$f":"U218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":3.8527999999999998},{"$f":"V218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":8.1267999999999994},{"$f":"W218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":4.3749000000000002},{"$f":"X218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":33.520000000000003},{"$f":"Y218*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":120.35},null,1,{"$f":"3641.6*AF218 + 391631","v":395272.6}]
[null,"Bladder Dam",null,"Reinforced Concreted Lined",null,"Ditch Rehabilitation",null,5,18.206707186685762,24.180915534365969,9.4512315520032271,126.63825259424729,234.53918904285226,18.206707186685762,24.180915534365969,9.4512315520032271,126.63825259424729,234.53918904285226,null,5,6.5476745026262506,11.688182899001497,6.3419163666180083,119.88047619196693,223.20852741044615,6.5476745026262506,11.688182899001497,6.3419163666180083,119.88047619196693,223.20852741044615,null,5,{"$f":"3641.6*AF219 + 391631","v":409839}]
[null,"Concrete Dam with Gates",null,"Synthetic Lining",null,null,null,10,20.404254834447908,26.606317935562529,10.696762680078137,218.95179144330919,305.97822822820228,20.404254834447908,26.606317935562529,10.696762680078137,218.95179144330919,305.97822822820228,null,10,8.2276624371235716,13.668459551667791,7.4416309859308374,207.54105016946761,291.23669543312479,8.2276624371235716,13.668459551667791,7.4416309859308374,207.54105016946761,291.23669543312479,null,10,428047]
[null,"Rock Weir or Vane",null,"Closed Conduit (PVC)",null,null,null,15,21.810727004365077,28.136350216488246,11.500117017287971,301.60809141802793,357.46961492687018,21.810727004365077,28.136350216488246,11.500117017287971,301.60809141802793,357.46961492687018,null,15,9.4036950076250569,14.978936449684406,8.1713231154870343,286.11002076806227,340.27490376819236,9.4036950076250569,14.978936449684406,8.1713231154870343,286.11002076806227,340.27490376819236,null,15,446255]
[null,null,null,"Closed Conduit (DIP)",null,null,null,20,22.86704625279787,29.274993872013361,12.106436204037394,378.55771059819625,399.1771120712973,22.86704625279787,29.274993872013361,12.106436204037394,378.55771059819625,399.1771120712973,null,20,10.338697983857042,15.984245637663557,8.7320406844623264,359.30193867824937,379.99808408232491,10.338697983857042,15.984245637663557,8.7320406844623264,359.30193867824937,379.99808408232491,null,20,464463]
[null,null,null,null,null,null,null,30,24.443279466101554,30.958491970343367,13.015660641705912,521.46670201902646,466.35242437355402,24.443279466101554,30.958491970343367,13.015660641705912,521.46670201902646,466.35242437355402,null,30,11.816474406809641,17.516750786557605,9.5882644577807064,495.32314235327323,443.98186602450994,11.816474406809641,17.516750786557605,9.5882644577807064,495.32314235327323,443.98186602450994,null,30,500879]
[null,null,null,null,null,null,null,40,25.627096337024639,32.211344248461494,13.701883639560819,654.50910133545244,520.76374101604893,25.627096337024639,32.211344248461494,13.701883639560819,654.50910133545244,520.76374101604893,null,40,12.991378391889697,18.692385022567624,10.246212780405392,622.03541435553916,495.81164108282934,12.991378391889697,18.692385022567624,10.246212780405392,622.03541435553916,495.81164108282934,null,40,537295]
[null,"Diversion Structure",null,"Project Options",null,null,null,50,26.584678197603434,33.217943343676367,14.258978145053677,780.66536040207018,567.3034427937655,26.584678197603434,33.217943343676367,14.258978145053677,780.66536040207018,567.3034427937655,null,50,13.982572559117983,19.658347096950475,10.787492592746457,742.24701443009167,540.14552484846195,13.982572559117983,19.658347096950475,10.787492592746457,742.24701443009167,540.14552484846195,null,50,573711]
[null,"Yes",null,null,null,null,null,60,27.393580733845624,34.063701144726437,14.730930275351495,901.59226178620429,608.40019581407932,27.393580733845624,34.063701144726437,14.730930275351495,901.59226178620429,608.40019581407932,null,60,14.848319441833022,20.484535677753765,11.250909309668289,857.51982643632073,579.29601970555882,14.848319441833022,20.484535677753765,11.250909309668289,857.51982643632073,579.29601970555882,null,60,610127]
[null,"No",null,"Diversion Structure",null,null,null,70,28.096670391776158,34.795557253956929,15.142126517477895,1018.3368150103677,645.46118901467912,28.096670391776158,34.795557253956929,15.142126517477895,1018.3368150103677,645.46118901467912,null,70,15.621986905011905,21.210099670679202,11.658220048259729,968.84128728930011,614.60306589748757,15.621986905011905,21.210099670679202,11.658220048259729,968.84128728930011,614.60306589748757,null,70,646543]
[null,null,null,"Ditch",null,null,null,80,28.720284176920568,35.44221743748345,15.507587212944976,1131.6165322693143,679.38482882904407,28.720284176920568,35.44221743748345,15.507587212944976,1131.6165322693143,679.38482882904407,null,80,16.324677709396976,21.859352374353506,12.022948602169413,1076.8883077443029,646.92216548120928,16.324677709396976,21.859352374353506,12.022948602169413,1076.8883077443029,646.92216548120928,null,80,682959]
[null,null,null,"Ditch and Diversion Structure",null,null,null,90,29.281829496132541,36.022580328439979,15.837260955182268,1241.9515708096289,710.78450574231306,29.281829496132541,36.022580328439979,15.837260955182268,1241.9515708096289,710.78450574231306,null,90,16.97068498784963,22.448510525893692,12.354121762575021,1182.1517485354564,676.83743309012232,16.97068498784963,22.448510525893692,12.354121762575021,1182.1517485354564,676.83743309012232,null,90,719375]
[null,null,null,null,null,null,null,100,29.793446067632086,36.549780776963885,16.138098451913571,1349.7349787779256,740.10020671675773,29.793446067632086,36.549780776963885,16.138098451913571,1349.7349787779256,740.10020671675773,null,100,17.570190297771543,22.988973090955668,12.658088580485487,1285.002610544316,704.76786677861799,17.570190297771543,22.988973090955668,12.658088580485487,1285.002610544316,704.76786677861799,null,100,755791]
[null,null,null,null,null,null,null,120,30.699983055154284,37.480370064174274,16.672246822565121,1558.8121031802816,793.7147507356259,30.699983055154284,37.480370064174274,16.672246822565121,1558.8121031802816,793.7147507356259,null,120,18.658068613059559,23.955139114908302,13.201863679475458,1484.5667198947879,755.8504167108872,18.658068613059559,23.955139114908302,13.201863679475458,1484.5667198947879,755.8504167108872,null,120,828623]
[null,null,null,null,null,null,null,140,31.487935561051131,38.285633053393873,17.13763258660703,1760.6581374238112,842.06426998728932,31.487935561051131,38.285633053393873,17.13763258660703,1760.6581374238112,842.06426998728932,null,140,19.630241973703608,24.803632176245927,13.67980379063161,1677.2901192816071,801.9181345428932,19.630241973703608,24.803632176245927,13.67980379063161,1677.2901192816071,801.9181345428932,null,140,901455]
[null,null,null,null,null,null,null,160,32.186819464652686,38.997154766239021,17.551255542176154,1956.5136275300031,886.32081938447607,32.186819464652686,38.997154766239021,17.551255542176154,1956.5136275300031,886.32081938447607,null,160,20.513227640421203,25.562884867247313,14.107777789550088,1864.3446990198875,844.08725716260869,20.513227640421203,25.562884867247313,14.107777789550088,1864.3446990198875,844.08725716260869,null,160,974287]
[null,null,null,null,null,null,null,180,32.816143244994002,39.635729412961823,17.924375358695528,2147.2779017716221,927.28462397537817,32.816143244994002,39.635729412961823,17.924375358695528,2147.2779017716221,927.28462397537817,null,180,21.324986046692231,26.251861454407866,14.496377750463365,2046.5802534671711,883.11992218887178,21.324986046692231,26.251861454407866,14.496377750463365,2046.5802534671711,883.11992218887178,null,180,1047119]
[null,null,null,null,null,null,null,200,33.389511883010933,40.215809299898403,18.264858743331409,2333.6305225562469,965.52968775356567,33.389511883010933,40.215809299898403,18.264858743331409,2333.6305225562469,965.52968775356567,null,200,22.078311111541158,26.883892179249724,14.853053676176266,2224.6390716351284,919.56282741217285,22.078311111541158,26.883892179249724,14.853053676176266,2224.6390716351284,919.56282741217285,null,200,1119951]
[null,null,null,null,null,null,null,300,35.691062202373246,42.52847377986965,19.63659652314659,3214.5973474041352,1128.0133481402902,35.691062202373246,42.52847377986965,19.63659652314659,3214.5973474041352,1128.0133481402902,null,300,25.23410574546816,29.46141157684545,16.309475848664022,3066.8223489629772,1074.3981013145872,25.23410574546816,29.46141157684545,16.309475848664022,3066.8223489629772,1074.3981013145872,null,300,1484111]
[null,null,null,null,null,null,null,400,37.419622465120732,44.249549060637136,20.671894269816693,4034.7412650866513,1259.6234529769251,37.419622465120732,44.249549060637136,20.671894269816693,4034.7412650866513,1259.6234529769251,null,400,27.743115656512064,31.438710021800272,17.428634829391594,3851.3688286977463,1199.8217192043016,27.743115656512064,31.438710021800272,17.428634829391594,3851.3688286977463,1199.8217192043016,null,400,1848271]
[null,null,null,null,null,null,null,500,38.817843755237703,45.632340033424036,21.512377156607094,4812.4353617256002,1372.1936940220996,38.817843755237703,45.632340033424036,21.512377156607094,4812.4353617256002,1372.1936940220996,null,500,29.859812868306122,33.063360996617803,18.349342645244782,4595.6660161089821,1307.1059219763758,29.859812868306122,33.063360996617803,18.349342645244782,4595.6660161089821,1307.1059219763758,null,500,2212431]
[]
[]
["Stream Restoration"]
[]
[null,null,null,null,null,null,null,2017,null,null,null,{"$f":"$P$18","v":2017}]
[null,"Level of Restoration",null,"Stream Environment",null,"Width Range",null,"Restoration Level","Width Range","Rural","Urban","Restoration Level","Width Range","Rural","Urban"]
[null,null,null,null,null,null,null,"Level 1","5 to 20",289.55770453339949,304.94580476190475,"Level 1","5 to 20",{"$f":"J245*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":289.55770453339949},{"$f":"K245*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":304.94580476190475}]
[null,"Level 1",null,"Urban",null,"5 to 20",null,null,"20 to 50",490.56099119615311,500.88604100463522,"Level 1","20 to 50",{"$f":"J246*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":490.56099119615311},{"$f":"K246*(1+($Q$13/$Q$14))^($Q$14*$P$19)","v":500.88604100463522}]
[null,"Level 2",null,"Rural",null,"20 to 50",null,null,"50 to 100",490.56099119615311,500.88604100463522,"Level 1","50 to 100",490.56099119615311,500.88604100463522]
[null,"Level 3",null,null,null,"50 to 100",null,null,">100",624.11264150969373,623.79580601140128,"Level 1",">100",624.11264150969373,623.79580601140128]
[null,"Level 4",null,null,null,">100",null,"Level 2","5 to 20",409.35631646451986,374.10056666666662,"Level 2","5 to 20",409.35631646451986,374.10056666666662]
[null,null,null,null,null,null,null,null,"20 to 50",693.52062546855063,614.47558500291871,"Level 2","20 to 50",693.52062546855063,614.47558500291871]
[null,null,null,null,null,null,null,null,"50 to 100",693.52062546855063,614.47558500291871,"Level 2","50 to 100",693.52062546855063,614.47558500291871]
[null,null,null,null,null,null,null,null,">100",882.32655525102905,765.25848484900348,"Level 2",">100",882.32655525102905,765.25848484900348]
[null,null,null,null,null,null,null,"Level 3","5 to 20",449.87070219911618,443.25532857142855,"Level 3","5 to 20",449.87070219911618,443.25532857142855]
[null,null,null,null,null,null,null,null,"20 to 50",762.15902435243993,728.06512900120219,"Level 3","20 to 50",762.15902435243993,728.06512900120219]
[null,null,null,null,null,null,null,null,"50 to 100",762.15902435243993,728.06512900120219,"Level 3","50 to 100",762.15902435243993,728.06512900120219]
[null,null,null,null,null,null,null,null,">100",969.65125738840538,906.72116368660591,"Level 3",">100",969.65125738840538,906.72116368660591]
[null,null,null,null,null,null,null,"Level 4","5 to 20",659.68828001639758,512.41009047619048,"Level 4","5 to 20",659.68828001639758,512.41009047619048]
[null,null,null,null,null,null,null,null,"20 to 50",1117.626405578862,841.6546729994858,"Level 4","20 to 50",1117.626405578862,841.6546729994858]
[null,null,null,null,null,null,null,null,"50 to 100",1117.626405578862,841.6546729994858,"Level 4","50 to 100",1117.626405578862,841.6546729994858]
[null,null,null,null,null,null,null,null,">100",1421.8920393690646,1048.1838425242083,"Level 4",">100",1421.8920393690646,1048.1838425242083]

{"sheet":"HW C Factor","index":13,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,1,33,4],[34,1,34,4],[35,1,36,4],[3,6,3,10],[2,6,2,10]]}
[]
[null,"Table A-4. Hazen-Williams Constants for Various Water Pipe Materials"]
[null,"Type of Pipe or Surface","range","clean","designb",null,"Click Here to Return to Pipelines Module"]
[null,null,null,null,null,null,"Click Here to Return to Well Fields Module"]
[null,"steel"]
[null," welded and seamless","150–80 ",140,100]
[null," interior riveted, no projecting rivets",null,139,100]
[null," projecting girth rivets",null,130,100]
[null," projecting girth and horizontal rivets",null,115,100]
[null," vitrified, spiral-riveted, flow with lap",null,110,100]
[null," vitrified, spiral-riveted, flow against lap",null,100,90]
[null," corrugated","80–40 "," 80",60]
[null,"mineral"]
[null," concrete","150–60 ",120,100]
[null," cement-asbestos","160–140",150,140]
[null," vitrified clays",null,null,110]
[null," brick sewer",null,null,100]
[null,"iron"]
[null," cast, plain","150–80 ",130,100]
[null," cast, tar (asphalt) coated","145–50 ",130,100]
[null," cast, cement lined",null,150,140]
[null," cast, bituminous lined","160–130",148,140]
[null," ductile iron","150–100",150,140]
[null,"  cement lined","150–120",150,140]
[null,"  asphalt coated","145–50",130,160]
[null," wrought, plain","150–80 ",130,100]
[null,"miscellaneous"]
[null," aluminum, irrigation pipe","135–100",135,130]
[null," copper and brass","150–120",140,130]
[null," wood stave","145–110",120,110]
[null," transite"]
[null," lead, tin, glass","150–120",140,130]
[null," plastic (PVC, ABS, and HDPE)","150–120",155,150]
[null,"aC values for sludge pipes are 20% to 40% less than the corresponding water pipe values."]
[null,"bThe following guidelines are provided for selecting Hazen-Williams coefficients for cast-iron pipes of different ages. Values for welded steel pipe are similar to those of cast-iron pipe five years older. New pipe, all sizes: C = 130.5 yr old pipe: C = 120 (d < 24 in); C = 115 (d ≥ 24 in). 10 yr old pipe: C = 105 (d = 4 in); C = 110 (d = 12 in); C = 85 (d ≥ 30 in). 40 yr old pipe: C = 65 (d = 4 in); C = 80 (d = 16 in)."]
[null,"Table Referenced From PE Civil Reference Manual, Sixteenth Edition, Appendix 17.A Specific Roughness and Hazen-Williams Constants for Various Water Pipe Materials"]

{"sheet":"Table B-1","index":14,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,9,2,14]]}
[]
[null,"Table B-1 Estimated Reservoir Rehabilitation Costs from 2015 Basin Implementation Plans"]
[null,"Basin","Project Name","BIP Project Description","Estimated BIP Cost",null,"Notes",null,null,"Click Here to Return to Reservoirs Module"]
[null,"Gunnison","Paonia Reservoir Sediment Removal and Outlet Modification Project (Part 2)","Paonia Reservoir was designed to store 21,000 AF of water which is used for irrigation, flat-water recreation, fishing, augmentation, and improved late season flows to the North Fork of the Gunnison. Over the last fifty years, the reservoir has lost 24% of its total capacity due to sedimentation build up. The goal of this project is so investigate long-term sediment management options with the intent of minimizing future losses and possibly restoring current capacity losses. ",8000000]
[null,"Gunnision","West Reservoir #1 Outlet Pipe Replacement","West Reservoir is currently under a no-fill restriction from the State Engineers Office because of concerns about a deteriorating outlet pipe. The owners propose to replace the existing pipe and restore the reservoir to use, thus helping preserve a pre-1922 water right. ",426317]
[null,"Gunnison","Lake San cristobal Controlled Outlet Structure (Part 1)","Hinsdale County and the Upper Gunnison River Water Conservancy District (UGRWCD) explored the feasibility of constructing a new permanent control structure at the outlet of Lake San Cristobal. The new structure allows for more controlled  releases to regulate the lake level and prevent failure of the structure during flood events. The additional stored water res ulting from the project will be  used primarily as augmentation water within the Lake Fork of the Gunnison\nRiver other beneficial uses include agriculture, recreation and releases for instream flows.",40000,"*"]
[null,"Gunnison","Lake San Cristobal Outlet\nStructure Modification (Part 2)","No detailed rehabilitation activities",120960,"*"]
[null,"Gunnison","Engineering for Lake San Cristobal Outlet Modification (Part 3)","No detailed rehabilitation activities",75265,"*"]
[null,"Gunnison","Juniata Reservoir Spillway\nModification","No detailed rehabilitation activities",97000,"*"]
[null,"Gunnison","Hanson Reservoir Outlet\nRehabilitation","No detailed rehabilitation activities",50000,"*"]
[null,"Gunnison","Lake San CristobaI Outlet\nStructure (Part 4)","No detailed rehabilitation activities",150000,"*"]
[null,"Gunnison","Hartland Dam Improvements","No detailed rehabilitation activities",2200000,"*"]
[null,"Gunnison","Lining Outlet Pipe for Grand\nMesa Reservoir #6","No detailed rehabilitation activities",19840,"*"]
[null,"Gunnison","Relief Ditch Diversion Dam Design","No detailed rehabilitation activities",800000,"*"]
[null,"Gunnison","Tunnel Reconstruction Project","No detailed rehabilitation activities",730110,"*"]
[null,"Gunnison","Dam Outlet Structure Repair","No detailed rehabilitation activities",31372,"*"]
[null,"Rio Grande","Mountain Home Reservoir Dam Repair","Rehabilitation of the Mountain Home Reservoir dam outlet works will improve dam safety and reliable water level management of the reservoir. The State is now requiring TIC to repair or upgrade the gates and to restore full operating capability at Mountain Home Reservoir. The Project will also provide improved water storage management and reduced storage loss (which currently amounts to 1,350 to 2,250 AF annually). Finally, improved outlet works will provide protection of the CPW conservation pool and enhancement of environmental, recreational, and wildlife habitat assets.",500000,null,"Preliminary Design: $20,000\nFinal Design: $20,000\nConstruction: $350,000\nAdmin, etc.: $100,00\nContingency: $10,000"]
[null,"Projects listed are not inclusive of all Reservoir Rehabilitation projects provided in the 2015 BIPs, but only represent those projects with an estimated cost for Reservoir Rehabilitation."]
[null,"*Estimated cost reflects only WSRA requested funds in 2015 dollars. This may or may not represent the actual total cost of the rehabilitation"]

{"sheet":"Table B-2","index":15,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,9,3,14]]}
[]
[null,"Table B-2 Diversion Structure Costs from Various CO DNR Projects"]
[null,"Project ID","Project Stream","Project County","Diversion Structure Type","Maximum Diversion Capacity (CFS)","Approximate Diversion Structure Cost"," Description of Project Costs"]
[null,1,"Saint Vrain ","Boulder","Grouted Boulder Dam",92.2,324210,null,null,"Click Here to Return to Ditches and Diversions"]
[null,2,"Arkansas","Chaffee","Earthen Dike",28.95,205000]
[null,3,"South Platte","--","Adjustable-Height Check Dam",295.43,2020000,"Demolition of existing structures and reconstruction of headworks; Channel stabilization"]
[null,4,"--","--","--",0,519140,"Diversion dam and headgate repair, Parshall flume, ditch embankment rebuild"]
[null,5,"South Platte","Logan/ Sedgwick ","Parshall Flume",210.8740510752688,224000,"Bypass of residual flows, dewatering, excavation, constructing new weir, riprap, removal of old structure"]
[null,6,"Conejos River","--","Automated Headgate",146.30000000000001,213000,"Remove and replace diversion and headgate structures"]
[null,7,"Little Thompson ","Larimer","--",95,808000,"Headgate rehabilitation, siphon construction, flood clean up"]
[null,8,"Conejos ","--","Automated Headgate",47.097461021505374,101000,"Diversion dam, headgate, sluice gates, 5 flumes, 5 stilling wells, telemetry"]
[null,9,"South Platte","Logan","--",167.35731182795701,2067470,"Replacement of river diversion structure, replacement of ditch headgate structure, installation of hydraulic bladders and controls"]
[null,10,"South Platte","Adams","--",159.66193951612902,2027070,"Construction and installation of gantry crane grate cleaning system, rehabilitate trash rack, replace diversion gates and operators"]
[null,11,"Saint Vrain ","Boulder","--",333.230747311828,750000,"Diversion dam and trash rack construction"]
[null,12,"Rio Grande","South Fork/ Alamosa","Radial Gates with Automation",21.871237903225801,826000,"88 ft diversion dam with fish and boat passage; 2 radial gates with automation; 1,054 LF of 36\" HDPE pipe"]
[null,13,"Saint Vrain ","Boulder","--",237.51000000000002,1262500,"Diversion structure, sluice and flume gates, headgates, and fish ladder"]
[null,14,"Rio Grande","Rio Grande","--",276.77822983870971,975000,"120 LF grouted boulder diversion dam, trash rack structure, 4 slide headgates and structure, 1 radial sluice gate, structure and channel, headgate automation"]
[null,15,"Saint Vrain ","Boulder","--",81.420477150537636,1843250,"Diversion dam with fish ladder, headgates, conveyance ditch, river turnout structure"]
[null,16,"Clear Creek","Adams/ Jefferson","Slide Gate",339.43525000000005,2209597,"Diversion dam and headgate rehabilitation including SCADA installation, rehabilitation of two siphon structures, and replacement of a storm drain pipe"]
[null,17,"Little Thompson ","Boulder/ Larimer","--",66.72,160000,"Removing debris from the dam and diversion structure; forming and pouring new wing wall; rechanneling river"]
[null,18,"Clear Creek","Denver","--",35.452186827956986,110781,"Repair Fisher Ditch headgate, install sand-out gate and pipeline, replace 650 LF of damaged CMP with RCP"]

{"sheet":"Change Log","index":16,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Change Log"]
[]
["Item","Staff","Date","Change","Other Notes"]
[1,"D. Schultze","2018-09-29","There are a lot of conversion factors hard-coded in. For consistency across the tool, these have all be changed to refrence the Conversion table in the Module References."]
[2,"D. Schultze","2018-09-29","In Well Fields, the HP calculation in the Booster Pump Parmeters table was different than the well field pipeline booster pump requirements table. I couldn't figure out why. These how match."]
[3,"D. Schultze","2018-09-29","General Formatting. All rows are now uniform heights for the costing module (Titles=24; inputs=18; total costs =20)"]
[4,"D. Schultze","2018-09-29","Normalized Cost was added to the Project Summary Sheet"]
[5,"D. Schultze","2018-09-29","Project useful life was added to Global Inputs. Currently does not attribute to any other modules, but could be used to estimate mainteance costs over the life of the project"]
[6,"D. Schultze","2018-09-29","Total project yield (Project yeilds from all modules combined) is now in Global Inputs. This is used to estimate the normalized cost. "]
[7,"E. Gruber","2018-11-21","Adjusted pipelines pumpstation functionality - if multiple pumps required and user selects \"intake\", first pump is set as intake and remaining pumps are assumed to be booster pumps.  Cost moidule sheet updated to separately account for intake and booster pumps"]
[8,"E. Gruber","2018-11-21","Updated diversion structure to reference a simple cost curve to produce a recommended value for the user.  The user must input their own cost but can simply copy the recommended cost using a button if they don't have any better cost data.  There is also a link to the reference table with project cost data used to develop the cost curve"]
[9,"E. Gruber","2018-11-21","Reservoir Rehab project option added.  Requires a user-specified cost - reference table provided with all available cost information available to help guide user in determining a cost.  New cost line added to the costing module"]