{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Projections"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Projections","index":0,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Year Round Population Projection (Compound Method)"]
["Plan year (End at 2059)",2023,{"$f":"IF(B2=2019,2020,IF(AND(B2<2030,B2>2019),2030,IF(AND(B2>=2030,B2<2040),2040,IF(AND(B2>=2040,B2<2050),2050,IF(AND(B2>=2050,B2<2060),2060,\"ERROR\")))))","v":2030},{"$f":"IFERROR(C2+10,\"ERROR\")","v":2040},{"$f":"IFERROR(D2+10,\"ERROR\")","v":2050},2060,2070]
["Population"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C3/B3)^(1/(C2-B2))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D3/C3)^(1/(D2-C2))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E3/D3)^(1/(E2-D2))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F3/E3)^(1/(F2-E2))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((G3/F3)^(1/(G2-F2))-1,\"ERROR\")","v":"ERROR"}]
["Annual Growth Rate",0.01]
["Projected Population",25000,{"$f":"IFERROR((B6*(1+B5)^(C2-B2)),\"ERROR\")","v":26803.383802675246},{"$f":"IFERROR((C6*(1+C5)^(D2-C2)),\"ERROR\")","v":26803.383802675246},{"$f":"IFERROR((D6*(1+D5)^(E2-D2)),\"ERROR\")","v":26803.383802675246},{"$f":"IFERROR((E6*(1+E5)^(F2-E2)),\"ERROR\")","v":26803.383802675246},{"$f":"IFERROR((F6*(1+F5)^(G2-F2)),\"ERROR\")","v":26803.383802675246}]
[]
[]
["Residential Water Demand Projection (Compound Method)"]
["Plan year (End at 2059)",null,{"$f":"IF(B10=2019,2020,IF(AND(B10<2030,B10>2019),2030,IF(AND(B10>=2030,B10<2040),2040,IF(AND(B10>=2040,B10<2050),2050,IF(AND(B10>=2050,B10<2060),2060,\"ERROR\")))))","v":"ERROR"},{"$f":"IFERROR(C10+10,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR(D10+10,\"ERROR\")","v":"ERROR"},"ERROR","ERROR"]
["Residential Demand"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C11/B11)^(1/(C10-B10))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D11/C11)^(1/(D10-C10))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E11/D11)^(1/(E10-D10))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F11/E11)^(1/(F10-E10))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((G11/F11)^(1/(G10-F10))-1,\"ERROR\")","v":"ERROR"}]
["Annual Growth Rate"]
["Projected Residential Demand",null,{"$f":"IFERROR((B14*(1+B13)^(C10-B10)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((C14*(1+C13)^(D10-C10)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D14*(1+D13)^(E10-D10)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E14*(1+E13)^(F10-E10)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F14*(1+F13)^(G10-F10)),\"ERROR\")","v":"ERROR"}]
[]
[]
["Commercial Water Demand Projection (Compound Method)"]
["Plan year (End at 2059)",null,{"$f":"IF(B18=2019,2020,IF(AND(B18<2030,B18>2019),2030,IF(AND(B18>=2030,B18<2040),2040,IF(AND(B18>=2040,B18<2050),2050,IF(AND(B18>=2050,B18<2060),2060,\"ERROR\")))))","v":"ERROR"},{"$f":"IFERROR(C18+10,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR(D18+10,\"ERROR\")","v":"ERROR"},"ERROR","ERROR"]
["Commercial Demand"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C19/B19)^(1/(C18-B18))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D19/C19)^(1/(D18-C18))-1,\"ERROR\")","v":"ERROR"},"ERROR","ERROR","ERROR"]
["Annual Growth Rate"]
["Projected Commercial Demand",null,{"$f":"IFERROR((B22*(1+B21)^(C18-B18)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((C22*(1+C21)^(D18-C18)),\"ERROR\")","v":"ERROR"},"ERROR","ERROR","ERROR"]
[]
[]
["Industrial Water Demand Projection (Compound Method)"]
["Plan year (End at 2059)",null,{"$f":"IF(B26=2019,2020,IF(AND(B26<2030,B26>2019),2030,IF(AND(B26>=2030,B26<2040),2040,IF(AND(B26>=2040,B26<2050),2050,IF(AND(B26>=2050,B26<2060),2060,\"ERROR\")))))","v":"ERROR"},{"$f":"IFERROR(C26+10,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR(D26+10,\"ERROR\")","v":"ERROR"},"ERROR","ERROR"]
["Industrial Demand"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C27/B27)^(1/(C26-B26))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D27/C27)^(1/(D26-C26))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E27/D27)^(1/(E26-D26))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F27/E27)^(1/(F26-E26))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((G27/F27)^(1/(G26-F26))-1,\"ERROR\")","v":"ERROR"}]
["Annual Growth Rate"]
["Projected Industrial Demand",null,{"$f":"IFERROR((B30*(1+B29)^(C26-B26)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((C30*(1+C29)^(D26-C26)),\"ERROR\")","v":"ERROR"},"ERROR","ERROR","ERROR"]
[]
[]
["Institutional Water Demand Projection (Compound Method)"]
["Plan year (End at 2059)",null,{"$f":"IF(B34=2019,2020,IF(AND(B34<2030,B34>2019),2030,IF(AND(B34>=2030,B34<2040),2040,IF(AND(B34>=2040,B34<2050),2050,IF(AND(B34>=2050,B34<2060),2060,\"ERROR\")))))","v":"ERROR"},{"$f":"IFERROR(C34+10,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR(D34+10,\"ERROR\")","v":"ERROR"},"ERROR","ERROR"]
["Institutional Demand"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C35/B35)^(1/(C34-B34))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D35/C35)^(1/(D34-C34))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E35/D35)^(1/(E34-D34))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F35/E35)^(1/(F34-E34))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((G35/F35)^(1/(G34-F34))-1,\"ERROR\")","v":"ERROR"}]
["Annual Growth Rate"]
["Projected Institutional Demand",null,{"$f":"IFERROR((B38*(1+B37)^(C34-B34)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((C38*(1+C37)^(D34-C34)),\"ERROR\")","v":"ERROR"},"ERROR","ERROR","ERROR"]
[]
[]
["Process Water Demand Projection (Compound Method)"]
["Plan year (End at 2059)",null,{"$f":"IF(B42=2019,2020,IF(AND(B42<2030,B42>2019),2030,IF(AND(B42>=2030,B42<2040),2040,IF(AND(B42>=2040,B42<2050),2050,IF(AND(B42>=2050,B42<2060),2060,\"ERROR\")))))","v":"ERROR"},{"$f":"IFERROR(C42+10,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR(D42+10,\"ERROR\")","v":"ERROR"},"ERROR","ERROR"]
["Process Demand"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C43/B43)^(1/(C42-B42))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D43/C43)^(1/(D42-C42))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E43/D43)^(1/(E42-D42))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F43/E43)^(1/(F42-E42))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((G43/F43)^(1/(G42-F42))-1,\"ERROR\")","v":"ERROR"}]
["Annual Growth Rate"]
["Projected Process Demand",null,{"$f":"IFERROR((B46*(1+B45)^(C42-B42)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((C46*(1+C45)^(D42-C42)),\"ERROR\")","v":"ERROR"},"ERROR","ERROR","ERROR"]
[]
[]
["Unaccounted-for Water Demand Projection (Compound Method)"]
["Plan year (End at 2059)",null,{"$f":"IF(B50=2019,2020,IF(AND(B50<2030,B50>2019),2030,IF(AND(B50>=2030,B50<2040),2040,IF(AND(B50>=2040,B50<2050),2050,IF(AND(B50>=2050,B50<2060),2060,\"ERROR\")))))","v":"ERROR"},{"$f":"IFERROR(C50+10,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR(D50+10,\"ERROR\")","v":"ERROR"},"ERROR","ERROR"]
["Unaccounted-for Demand"]
["Projected Annual Growth Rate",null,{"$f":"IFERROR((C51/B51)^(1/(C50-B50))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((D51/C51)^(1/(D50-C50))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((E51/D51)^(1/(E50-D50))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((F51/E51)^(1/(F50-E50))-1,\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((G51/F51)^(1/(G50-F50))-1,\"ERROR\")","v":"ERROR"}]
["Annual Growth Rate"]
["Projected Unaccounted-for Demand",null,{"$f":"IFERROR((B54*(1+B53)^(C50-B50)),\"ERROR\")","v":"ERROR"},{"$f":"IFERROR((C54*(1+C53)^(D50-C50)),\"ERROR\")","v":"ERROR"},"ERROR","ERROR","ERROR"]