{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Population","Water Use Per Capita","Water Supply","Potable Water Treatment ","Results","State Water Project Data","Colorado River Water Data","Potable Water Treatment Data","E for Treatment Data","Groundwater Data","E for Groundwater Data","Default Energy Data"],"not_rendered":{"charts":2,"images":4,"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":"Instructions","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,3,26,7],[11,1,12,1],[15,1,26,1],[10,3,10,7],[0,1,0,7],[1,1,1,7],[2,1,8,7]]}
[null,"Energy Related Emissions Associated With Water Supply, Delivery, and Treatment"]
[null,"Introduction"]
[null,"The consumption of water by a community's residents and businesses can have a significant Green House Gas (GHG) implications depending on the source, treatment, distance, and topography traversed.  Incorporating the relationship between water and energy consumption in a GHG inventory allows a community to use water conservation and policy measures as a GHG emissions reduction strategy.  This tool allows the user to estimate GHG emissions from 1990-2050 regardless of data availability.  The tool can be used with 3 levels of data: Required Data, Suggested Data, and Detailed Data or any combination of the 3.  Yellow cells in each worksheet can take user input, blue cells are calculated values, and tan cells provide detailed instructions."]
[]
[]
[]
[]
[]
[]
[]
[null,"Required Data",null,"Detailed Data"]
[null,"Population of the area being analyzed for 1990, 2000, 2010, and present.  ",null,"Detailed site specific data should be used when it is available, but default date will fill any data gaps.  The following detailed data can be entered on either a monthly or annual level under the blue tabs.\n• State Water Project data (ac-ft)\n• Colorado River Water data (ac-ft)\n• Potable water treatment flow (gal for monthly data, MG for annual) \n• Potable water treatment energy data (KWh)\n• Groundwater elevation data (ft)\n• Groundwater energy data (KWh)\n"]
[]
[]
[null,"Suggested Data"]
[null,"The more site specific data input into the tool, the more accurate the results.  The following list of data can be input into the model under the yellow tabs.                                                                                             • Projected population data for 2020, 2030, 2040, and 2050\n• Water use per capita for 1990, 2000, 2010, present, 2020, 2030, 2040, and 2050\n• Percentage each of groundwater, State Water Project, Colorado River Water, and self supplied water\n"]

{"sheet":"Population","index":1,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,11,0,16],[19,1,19,8],[18,12,22,16],[5,12,7,16],[1,12,4,16],[13,12,16,16],[9,12,11,16],[78,2,78,9],[0,1,0,4],[26,1,26,5],[2,1,2,4],[1,1,1,4],[24,2,24,8],[3,1,3,4],[5,1,5,8],[36,1,36,5],[10,2,10,8],[12,1,12,8]]}
[null,"1990 Population:",null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"2000 Population:",null,null,null,null,null,null,null,null,null,"Step 1:","Population data for 1990, 2000, 2010, and present must be entered.  This data can be found at: http://www.census.gov/main/www/cen2000.html"]
[null,"2010 Population:"]
[null,"Current Population:"]
[]
[null,"Known Population",null,null,null,null,null,null,null,null,null,"Step 2:","If know, please enter the projected population for 2020, 2030, 2040, and 2050.  If not know, please leave blank.  "]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Population",{"$f":"F1","v":0},2846289,{"$f":"F3","v":0}]
[null,"Decadal Growth Rate",null,{"$f":"((D8-C8)/C8)","v":{"$error":"#DIV/0!"}},{"$f":"((E8-D8)/D8)","v":-1},{"$f":"IF(ISNUMBER(F8),((F8-E8)/E8),0)","v":0},{"$f":"IF(ISNUMBER(G8),((G8-F8)/F8),0)","v":0},0,0]
[null,"Annual Growth Rate",null,{"$f":"((D8-C8)/C8)/10","v":{"$error":"#DIV/0!"}},{"$f":"((E8-D8)/D8)/10","v":-0.1},{"$f":"IF(ISNUMBER(F8),((F8-E8)/E8)/10,0)","v":0},{"$f":"IF(ISNUMBER(G8),((G8-F8)/F8)/10,0)","v":0},0,0,null,null,"Step 3:","If know, please enter the decadal growth rates (growth rate over full decade) for 2010-2020, 2020-2030, and 2040-2050.  If not know, please leave blank."]
[null,"Source:"]
[]
[null,"Known Decadal Growth Rate"]
[null,null,1990,2000,2010,2020,2030,2040,2050,null,null,"Step 4:","If know, please enter the average annual growth rates (average during each 10 year period) for 2010-2020, 2020-2030, and 2040-2050.  If not know, please leave blank."]
[null,"Population",{"$f":"F1","v":0},{"$f":"F2","v":0},{"$f":"F3","v":0},{"$f":"F16*E15+E15","v":0},{"$f":"G16*F15+F15","v":0},{"$f":"H16*G15+G15","v":0},{"$f":"I16*H15+H15","v":0}]
[null,"Decadal Growth Rate",null,{"$f":"((D15-C15)/C15)","v":{"$error":"#DIV/0!"}},{"$f":"((E15-D15)/D15)","v":{"$error":"#DIV/0!"}}]
[null,"Annual Growth Rate",null,{"$f":"((D15-C15)/C15)/10","v":{"$error":"#DIV/0!"}},{"$f":"((E15-D15)/D15)/10","v":{"$error":"#DIV/0!"}},{"$f":"((F15-E15)/E15)/10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Source:"]
[null,null,null,null,null,null,null,null,null,null,null,"Notes:","Please complete only one of steps 2-4, leaving the other two blank.  If the data is unknown for steps 2, 3, or 4 the default Southern California rate will be used.  Source data can be inserted at any step for future reference.  "]
[null,"Known Average Annual Growth Rate"]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Population",{"$f":"F1","v":0},{"$f":"F2","v":0},{"$f":"F3","v":0},{"$f":"10*F24*E22+E22","v":0},{"$f":"10*G24*F22+F22","v":0},{"$f":"10*H24*G22+G22","v":0},{"$f":"10*I24*H22+H22","v":0}]
[null,"Decadal Growth Rate",null,{"$f":"(D22-C22)/C22","v":{"$error":"#DIV/0!"}},{"$f":"(E22-D22)/D22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Growth Rate",null,{"$f":"((D22-C22)/C22)/10","v":{"$error":"#DIV/0!"}},{"$f":"((E22-D22)/D22)/10","v":{"$error":"#DIV/0!"}}]
[null,"Source:"]
[]
[null,"Default Projected Growth for So Cal from 1010-2050:",null,null,null,null,0.61699999999999999]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Population",{"$f":"F1","v":0},{"$f":"F2","v":0},{"$f":"F3","v":0},{"$f":"$E$29+($I$29-$E$29)*((F28-$E$28)/($I$28-$E$28))","v":0},{"$f":"$E$29+($I$29-$E$29)*((G28-$E$28)/($I$28-$E$28))","v":0},0,{"$f":"E29*G27+E29","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Actual Data Perpetuated"]
[null,null,1990,2000,2010,"Current",2020,2030,2040,2050]
[null,"Population",{"$f":"F1","v":0},{"$f":"F2","v":0},{"$f":"F3","v":0},{"$f":"F4","v":0},{"$f":"IF(ISBLANK(F8),IF(ISBLANK(F16),IF(ISBLANK(F24),F29,F22),F15),F8)","v":0},{"$f":"IF(ISBLANK(G8),IF(ISBLANK(G16),IF(ISBLANK(G24),G29,G22),G15),G8)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source","Orange County DOT Economic Forecast"]

{"sheet":"Water Use Per Capita","index":2,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,16],[2,1,2,4],[3,1,3,4],[6,1,6,8],[25,2,25,8],[27,1,27,5],[78,2,78,9],[2,12,4,16],[4,1,4,4],[6,12,8,16],[17,12,21,16],[9,12,11,16],[11,2,11,8],[13,1,13,8],[13,12,16,16],[20,1,20,8],[37,1,37,5]]}
[]
[null,"Current Per Capita Water Use (gpd):",null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"1990 Per Capita Water Use:",null,null,null,null,null,null,null,null,null,"Step 1:","If current, 1990, 2000, and 2010 per capita water use is know, enter here.  If only current per capita water use is know, enter it leaving the others blank.  If none are know the default value will be used. "]
[null,"2000 Per Capita Water Use:"]
[null,"2010 Per Capita Water Use:"]
[]
[null,"Projected Per Capita Water Use",null,null,null,null,null,null,null,null,null,"Step 2:","If projected per capita water  use data is known please enter it here, if not please leave blank.  "]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Per Capita Water Use (gpd)",{"$f":"IF(ISBLANK(F3),IF(ISBLANK(F2),G28,F2),F3)","v":209},{"$f":"IF(ISBLANK(F4),IF(ISBLANK(F2),G28,F2),F4)","v":209},{"$f":"IF(ISBLANK(F5),IF(ISBLANK(F2),G28,F2),F5)","v":209}]
[null,"Decadal Conservation Rate",null,{"$f":"((D9-C9)/C9)","v":0},{"$f":"((E9-D9)/D9)","v":0},{"$f":"IF(ISBLANK(F9),0,((F9-E9)/E9))","v":0},{"$f":"IF(ISBLANK(G9),0,((G9-F9)/F9))","v":0},{"$f":"IF(ISBLANK(H9),0,((H9-G9)/G9))","v":0},0,null,null,"Step 3:","If you would like to evaluate a reduction percentage over each 10 year period please enter them here."]
[null,"Annual Conservation Rate",null,{"$f":"((D9-C9)/C9)/10","v":0},{"$f":"((E9-D9)/D9)/10","v":0},{"$f":"IF(ISBLANK(F9),0,(((F9-E9)/E9)/10))","v":0},{"$f":"IF(ISBLANK(G9),0,(((G9-F9)/F9)/10))","v":0},0,0]
[null,"Source:"]
[]
[null,"Projected Annual Conservation Rate",null,null,null,null,null,null,null,null,null,"Step 4:","If you would like to evaluate a average annual reduction percentage over each 10 year period please enter them here."]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Per Capita Water Use (gpd)",{"$f":"C9","v":209},{"$f":"D9","v":209},209,{"$f":"F17*E16+E16","v":209},{"$f":"G17*F16+F16","v":209},{"$f":"H17*G16+G16","v":209},{"$f":"I17*H16+H16","v":209}]
[null,"Decadal Conservation Rate",null,{"$f":"((D16-C16)/C16)","v":0},{"$f":"((E16-D16)/D16)","v":0}]
[null,"Annual Conservation Rate",null,{"$f":"((D16-C16)/C16)/10","v":0},{"$f":"((E16-D16)/D16)/10","v":0},{"$f":"((F16-E16)/E16)/10","v":0},0,0,0,null,null,"Notes:","Please complete only one of steps 2-4 at a time, leaving the other two blank.  Source data can be inserted at any step for future reference.  "]
[null,"Source:"]
[]
[null,"Projected Annual Conservation Rate"]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Per Capita Water Use (gpd)",{"$f":"C9","v":209},{"$f":"D9","v":209},209,{"$f":"10*F25*E23+E23","v":209},{"$f":"10*G25*F23+F23","v":209},{"$f":"10*H25*G23+G23","v":209},{"$f":"10*I25*H23+H23","v":209}]
[null,"Decadal Conservation Rate",null,{"$f":"(D23-C23)/C23","v":0},{"$f":"(E23-D23)/D23","v":0},0,0,0,0]
[null,"Annual Conservation Rate",null,{"$f":"((D23-C23)/C23)/10","v":0},{"$f":"((E23-D23)/D23)/10","v":0}]
[null,"Source:"]
[]
[null,"Default per capita water use for So Cal:",null,null,null,null,209]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Actual Data Perpetuated"]
[null,null,1990,2000,2010,"Current",2020,2030,2040,2050]
[null,"Population",{"$f":"C9","v":209},{"$f":"D9","v":209},209,{"$f":"IF(ISBLANK(F2),IF(ISBLANK(F5),G28,F5),F2)","v":209},{"$f":"IF(ISBLANK(F9),IF(ISBLANK(F17),IF(ISBLANK(F25),IF(ISBLANK($F$2),IF(ISBLANK($F$5),$G$28,$F$5),$F$2),F23),F16),F9)","v":209},{"$f":"MIN((IF(ISBLANK(G9),IF(ISBLANK(G17),IF(ISBLANK(G25),IF(ISBLANK($F$2),IF(ISBLANK($F$5),$G$28,$F$5),$F$2),G23),G16),G9)),G40)","v":209},{"$f":"MIN((IF(ISBLANK(H9),IF(ISBLANK(H17),IF(ISBLANK(H25),IF(ISBLANK($F$2),IF(ISBLANK($F$5),$G$28,$F$5),$F$2),H23),H16),H9)),H40)","v":209},209]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source","Orange County DOT Economic Forecast"]

{"sheet":"Water Supply","index":3,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,2,77,8],[16,11,20,15],[18,1,18,8],[22,2,22,8],[26,1,26,5],[27,1,27,5],[28,1,28,5],[37,1,37,5],[12,11,15,15],[2,1,2,4],[1,10,1,15],[3,1,3,4],[2,11,4,15],[4,1,4,4],[1,1,1,4],[6,1,6,8],[6,11,8,15],[9,11,10,15],[10,2,10,8],[12,1,12,8]]}
[]
[null,"Percent Groundwater Use:",null,null,null,null,null,null,null,null,"Instructions"]
[null,"Percent State Water Project:",null,null,null,null,null,null,null,null,"Step 1:","If percentage of water use for the area is know for groundwater, State Water Project, and Colorado River Water, please enter here. "]
[null,"Percent Colorado River Water:"]
[null,"Percent Self-Supplied Water Use:",null,null,null,{"$f":"IF(ISBLANK(F2),G29,1-F2-F3-F4)","v":7.0000000000000007E-2}]
[]
[null,"Groundwater",null,null,null,null,null,null,null,null,"Step 2:","If annual groundwater use data is known please enter it here, if not please leave blank."]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Groundwater Production (ac-ft)",null,null,null,{"$f":"IF(ISBLANK(C11),IF(ISBLANK($F$2),$G$27*F25,$F$2*F25),F10*F25)","v":0},{"$f":"IF(ISBLANK(D11),IF(ISBLANK($F$2),$G$27*G25,$F$2*G25),G10*G25)","v":0},0,0]
[null,"Percentage of water supplied",{"$f":"IF(ISBLANK(C9),IF(ISBLANK($F$2),$G$27,$F$2),(C9/C25))","v":0.17},{"$f":"IF(ISBLANK(D9),IF(ISBLANK($F$2),$G$27,$F$2),(D9/D25))","v":0.17},0.17,null,null,null,null,null,"Step 3:","If annual State Water Project data is known please enter it here, if not please leave blank."]
[null,"Source:"]
[]
[null,"State Water Project",null,null,null,null,null,null,null,null,"Step 4:","If annual Colorado River Water use data is known please enter it here, if not please leave blank."]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Imported Water (ac-ft)",null,null,null,{"$f":"IF(ISBLANK(C11),IF(ISBLANK($F$3),$G$28*F25,$F$3*F25),F16*F25)","v":0},{"$f":"IF(ISBLANK(D11),IF(ISBLANK($F$3),$G$28*G25,$F$3*G25),G16*G25)","v":0},0,0]
[null,"Percentage of water supplied",{"$f":"IF(ISBLANK(C15),IF(ISBLANK($F$3),$G$28/2,$F$3),(C15/C25))","v":0.38},{"$f":"IF(ISBLANK(D15),IF(ISBLANK($F$3),$G$28/2,$F$3),(D15/D25))","v":0.38},0.38]
[null,"Source:",null,null,null,null,null,null,null,null,"Notes:","You can run future projection scenarios by entering projected percentages for years 2020, 2030,2040, and 2050.   Source data can be inserted at any step for future reference.  "]
[]
[null,"Colorado River Water"]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Imported Water (ac-ft)",null,null,null,{"$f":"F22*E21+E21","v":0},{"$f":"G22*F21+F21","v":0},0,0]
[null,"Percentage of water supplied",{"$f":"IF(ISBLANK(C21),IF(ISBLANK($F$4),$G$28/2,$F$4),(C21/C25))","v":0.38},{"$f":"IF(ISBLANK(D21),IF(ISBLANK($F$4),$G$28/2,$F$4),(D21/D25))","v":0.38},0.38]
[null,"Source:"]
[]
[null,"Total Water Use (ac-ft)",{"$f":"(Population!C39*'Water Use Per Capita'!C40*365)/325851.427","v":0},{"$f":"(Population!D39*'Water Use Per Capita'!D40*365)/325851.427","v":0},{"$f":"(Population!E39*'Water Use Per Capita'!E40*365)/325851.427","v":0},{"$f":"(Population!F39*'Water Use Per Capita'!F40*365)/325851.427","v":0},{"$f":"(Population!G39*'Water Use Per Capita'!G40*365)/325851.427","v":0},{"$f":"(Population!H39*'Water Use Per Capita'!H40*365)/325851.427","v":0},{"$f":"(Population!I39*'Water Use Per Capita'!I40*365)/325851.427","v":0}]
[]
[null,"Default groundwater use for So Cal:",null,null,null,null,0.17]
[null,"Default surface water use for So Cal:",null,null,null,null,0.76]
[null,"Default self-supplied water use for So Cal:",null,null,null,null,7.0000000000000007E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Actual Data Perpetuated"]
[null,null,1990,2000,2010,"Current",2020,2030,2040,2050]
[null,"Groundwater",{"$f":"IF(ISBLANK(C10),IF(ISBLANK($F$2),$G$27,$F$2),C10)","v":0.17},{"$f":"IF(ISBLANK(D10),IF(ISBLANK($F$2),$G$27,$F$2),D10)","v":0.17},0.17,{"$f":"IF(ISBLANK(F2),G27,F2)","v":0.17},{"$f":"IF(ISBLANK(F10),IF(ISBLANK($F$2),$G$27,$F$2),F10)","v":0.17},{"$f":"IF(ISBLANK(G10),IF(ISBLANK($F$2),$G$27,$F$2),G10)","v":0.17},{"$f":"IF(ISBLANK(H10),IF(ISBLANK($F$2),$G$27,$F$2),H10)","v":0.17},{"$f":"IF(ISBLANK(I10),IF(ISBLANK($F$2),$G$27,$F$2),I10)","v":0.17}]
[null,"Surface water ",{"$f":"IF(ISBLANK(C15),IF(ISBLANK($F$3),$G$28,$F$3+$F$4),C16+C22)","v":0.76},{"$f":"IF(ISBLANK(D15),IF(ISBLANK($F$3),$G$28,$F$3+$F$4),D16+D22)","v":0.76},0.76,{"$f":"IF(ISBLANK(F3),G28,F3+F4)","v":0.76},{"$f":"IF(ISBLANK(F16),IF(ISBLANK($F$3),$G$28,$F$3+$F$4),F16+F22)","v":0.76},{"$f":"IF(ISBLANK(G16),IF(ISBLANK($F$3),$G$28,$F$3+$F$4),G16+G22)","v":0.76},0.76,0.76]
[null,"Self-supplied water",{"$f":"$F$5","v":7.0000000000000007E-2},{"$f":"$F$5","v":7.0000000000000007E-2},7.0000000000000007E-2,{"$f":"F5","v":7.0000000000000007E-2},7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source","Orange County DOT Economic Forecast"]

{"sheet":"Potable Water Treatment ","index":4,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,15],[2,1,2,4],[2,11,4,15],[3,1,3,4],[4,1,4,4],[6,1,6,8],[6,11,8,15],[9,11,11,15],[11,2,11,8],[13,1,13,8],[13,11,16,15],[17,11,21,15],[20,1,20,8],[25,2,25,8],[27,1,27,5],[77,2,77,9],[37,1,37,5]]}
[]
[null,"Current Average Daily Flow to Treatment Plant (MGD):",null,null,null,null,null,null,null,null,"Instructions"]
[null,"1990 Average Daily Flow to Treatment Plant (MGD):",null,null,null,null,null,null,null,null,"Step 1:","If current, 1990, 2000, and 2010 flow to treatment plant is know enter here.  If only current is know, enter it leaving the other blank.  If none are know the default Southern California default will be used. "]
[null,"2000 Average Daily Flow to Treatment Plant (MGD):"]
[null,"2010 Average Daily Flow to Treatment Plant (MGD):"]
[]
[null,"Projected Per Capita Water Use",null,null,null,null,null,null,null,null,"Step 2:","If projected per capita water  use data is known please enter it here, if not please leave blank.  "]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Avg Daily Flow to Plant (MGD):",{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F3),F2,F3)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F4),F2,F4)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F5),F2,F5)))","v":20}]
[null,"Decadal Growth Rate",null,{"$f":"((D9-C9)/C9)","v":0},{"$f":"((E9-D9)/D9)","v":0},{"$f":"IF(ISBLANK(F9),0,((F9-E9)/E9))","v":0},{"$f":"IF(ISBLANK(G9),0,((G9-F9)/F9))","v":0},{"$f":"IF(ISBLANK(H9),0,((H9-G9)/G9))","v":0},0,null,"Step 3:","If you would like to evaluate a reduction percentage over each 10 year period please enter them here."]
[null,"Annual Growth Rate",null,{"$f":"((D9-C9)/C9)/10","v":0},{"$f":"((E9-D9)/D9)/10","v":0},{"$f":"IF(ISBLANK(F9),0,(((F9-E9)/E9)/10))","v":0},{"$f":"IF(ISBLANK(G9),0,(((G9-F9)/F9)/10))","v":0},0,0]
[null,"Source:"]
[]
[null,"Projected Annual Conservation Rate",null,null,null,null,null,null,null,null,"Step 4:","If you would like to evaluate a average annual reduction percentage over each 10 year period please enter them here."]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Avg Daily Flow to Plant (MGD):",{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F3),F2,F3)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F4),F2,F4)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F5),F2,F5)))","v":20},{"$f":"F17*E16+E16","v":20},{"$f":"G17*F16+F16","v":20},{"$f":"H17*G16+G16","v":20},{"$f":"I17*H16+H16","v":20}]
[null,"Decadal Growth Rate",null,{"$f":"((D16-C16)/C16)","v":0},{"$f":"((E16-D16)/D16)","v":0}]
[null,"Annual Growth Rate",null,{"$f":"((D16-C16)/C16)/10","v":0},{"$f":"((E16-D16)/D16)/10","v":0},{"$f":"((F16-E16)/E16)/10","v":0},0,0,0,null,"Notes:","Please complete only one of steps 2-4 at a time, leaving the other two blank.  Source data can be inserted at any step for future reference.  "]
[null,"Source:"]
[]
[null,"Projected Annual Conservation Rate"]
[null,null,1990,2000,2010,2020,2030,2040,2050]
[null,"Avg Daily Flow to Plant (MGD):",{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F3),F2,F3)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F4),F2,F4)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F5),F2,F5)))","v":20},{"$f":"10*F25*E23+E23","v":20},{"$f":"10*G25*F23+F23","v":20},{"$f":"10*H25*G23+G23","v":20},{"$f":"10*I25*H23+H23","v":20}]
[null,"Decadal Growth Rate",null,{"$f":"(D23-C23)/C23","v":0},{"$f":"(E23-D23)/D23","v":0},0,0,0,0]
[null,"Annual Growth Rate",null,{"$f":"((D23-C23)/C23)/10","v":0},{"$f":"((E23-D23)/D23)/10","v":0}]
[null,"Source:"]
[]
[null,"Default Average Daily Flow to Treatment Plant (MGD):",null,null,null,null,20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Acctual Data Perpetuated"]
[null,null,1990,2000,2010,"Current",2020,2030,2040,2050]
[null,"Population",{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F3),F2,F3)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F4),F2,F4)))","v":20},{"$f":"IF(ISBLANK(F2),G28,(IF(ISBLANK(F5),F2,F5)))","v":20},{"$f":"IF(ISBLANK(F2),G28,F2)","v":20},{"$f":"IF(ISBLANK(F9),IF(ISBLANK(F17),IF(ISBLANK(F25),IF(ISBLANK($F$2),$G$28,$F$2),F23),F16),F9)","v":20},{"$f":"IF(ISBLANK(G9),IF(ISBLANK(G17),IF(ISBLANK(G25),IF(ISBLANK($F$2),$G$28,$F$2),G23),G16),G9)","v":20},{"$f":"MIN((IF(ISBLANK(H9),IF(ISBLANK(H17),IF(ISBLANK(H25),IF(ISBLANK($F$2),$G$28,$F$2),H23),H16),H9)),H40)","v":20},20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source","Orange County DOT Economic Forecast"]

{"sheet":"Results","index":5,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[17,13,20,14],[22,13,25,14],[1,0,1,12],[14,12,14,13],[16,12,16,14]]}
[]
["Final Values for Computation of Total Annual Emissions"]
[null,"Groundwater (gpd)","Surface Water (gpd)","Groundwater Intensity (KWh/MG)","Supply & Conveyance Intensity (KWh/MG)","Treatment Intensity (KWh/MG)","Distribution Intensity (KWh/MG)","Electricity Emission Factors (kg CO2 eq./MWh)","Annual Groundwater Extraction Emissions (mtCO2e)","Annual Conveyance Emissions (mtCO2e)","Annual Treatment Emissions (mtCO2e)","Annual Distribution Emissions (mtCO2e)","Total Annual Emissions (mtCO2e)"]
[1990,{"$f":"Population!C39*'Water Use Per Capita'!C40*'Water Supply'!C40","v":0},{"$f":"Population!C39*'Water Use Per Capita'!C40*'Water Supply'!C41","v":0},{"$f":"IF('E for Groundwater Data'!Q3=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q3)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!Q3=0,IF('E for Treatment Data'!P29=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P29),'E for Treatment Data'!Q3)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F24/2.205","v":469.92743764172337},{"$f":"B4*365*0.000001*D4*H4*0.001*0.001","v":0},{"$f":"C4*365*0.000001*E4*H4*0.001*0.001","v":0},{"$f":"(B4+C4)*365*0.000001*F4*H4*0.001*0.001","v":0},{"$f":"(B4+C4)*365*0.000001*G4*H4*0.001*0.001","v":0},{"$f":"SUM(I4:L4)","v":0}]
[2000,{"$f":"Population!D39*'Water Use Per Capita'!D40*'Water Supply'!D40","v":0},{"$f":"Population!D39*'Water Use Per Capita'!D40*'Water Supply'!D41","v":0},{"$f":"IF('E for Groundwater Data'!Q4=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q4)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!Q13=0,IF('E for Treatment Data'!P30=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P30),'E for Treatment Data'!Q13)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F34/2.205","v":380.87074829931976},{"$f":"B5*365*0.000001*D5*H5*0.001*0.001","v":0},{"$f":"C5*365*0.000001*E5*H5*0.001*0.001","v":0},{"$f":"(B5+C5)*365*0.000001*F5*H5*0.001*0.001","v":0},{"$f":"(B5+C5)*365*0.000001*G5*H5*0.001*0.001","v":0},{"$f":"SUM(I5:L5)","v":0}]
[2010,{"$f":"Population!E39*'Water Use Per Capita'!E40*'Water Supply'!E40","v":0},{"$f":"Population!E39*'Water Use Per Capita'!E40*'Water Supply'!E41","v":0},{"$f":"IF('E for Groundwater Data'!Q5=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q5)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!Q23=0,IF('E for Treatment Data'!P31=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P31),'E for Treatment Data'!Q23)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F41/2.205","v":418.71201814058958},0,0,0,0,0]
["Current",{"$f":"Population!F39*'Water Use Per Capita'!F40*'Water Supply'!F40","v":0},{"$f":"Population!F39*'Water Use Per Capita'!F40*'Water Supply'!F41","v":0},{"$f":"IF('E for Groundwater Data'!Q6=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q6)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!Q25=0,IF('E for Treatment Data'!P31=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P31),'E for Treatment Data'!Q25)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F41/2.205","v":418.71201814058958},0,0,0,0,0]
[2020,{"$f":"Population!G39*'Water Use Per Capita'!G40*'Water Supply'!G40","v":0},{"$f":"Population!G39*'Water Use Per Capita'!G40*'Water Supply'!G41","v":0},{"$f":"IF('E for Groundwater Data'!Q7=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q7)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!P32=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P32)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F41/2.205","v":418.71201814058958},0,0,0,0,0]
[2030,{"$f":"Population!H39*'Water Use Per Capita'!H40*'Water Supply'!H40","v":0},{"$f":"Population!H39*'Water Use Per Capita'!H40*'Water Supply'!H41","v":0},{"$f":"IF('E for Groundwater Data'!Q8=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q8)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!P33=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P33)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F41/2.205","v":418.71201814058958},0,0,0,0,0]
[2040,{"$f":"Population!I39*'Water Use Per Capita'!I40*'Water Supply'!I40","v":0},{"$f":"Population!I39*'Water Use Per Capita'!I40*'Water Supply'!I41","v":0},{"$f":"IF('E for Groundwater Data'!Q9=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q9)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!P34=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P34)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F41/2.205","v":418.71201814058958},0,0,0,0,0]
[2050,{"$f":"Population!J39*'Water Use Per Capita'!J40*'Water Supply'!J40","v":0},{"$f":"Population!J39*'Water Use Per Capita'!J40*'Water Supply'!J41","v":0},{"$f":"IF('E for Groundwater Data'!Q10=0,'Default Energy Data'!$E$4,'E for Groundwater Data'!Q10)","v":540},{"$f":"'Default Energy Data'!$K$4","v":8900},{"$f":"IF('E for Treatment Data'!P35=0,'Default Energy Data'!$K$5,'E for Treatment Data'!P35)","v":496.3023483680999},{"$f":"'Default Energy Data'!$K$6","v":1200},{"$f":"'Default Energy Data'!F41/2.205","v":418.71201814058958},0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Scenario Name: "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Step 1:","After completing data entry according to instructions, name your scenario in yellow box above and hit enter."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Step 2:","Open GHG Scenario Manager, then return to this worksheet."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Step 2:","Click on the Compare button.","on export results."]

{"sheet":"State Water Project Data","index":6,"n_rows":267,"n_cols":11,"rows_kept":267,"cut":false,"hidden":false,"merged":[[1,0,1,6],[5,10,8,14],[1,9,1,15],[14,10,18,14],[4,9,4,14],[10,10,12,14]]}
[]
["Imported Water Delivered Via the Santa Ana River",null,null,null,null,null,null,null,"Source:"]
[null,"Date","Monthly (ac-ft)",null,"Year","Annual (ac-ft)"]
[null,"1990-01-01",0,null,1990,{"$f":"SUM(C4:C15)","v":0}]
[null,"1990-02-01",0,null,1991,{"$f":"SUM(C16:C27)","v":0},null,null,null,"Instructions"]
[null,"1990-03-01",0,null,1992,{"$f":"SUM(C40:C51)","v":0},null,null,null,"Step 1:","If available, please enter monthly State Water Project data in column C.  The data will automatically be aggregated to annual data.  If data is not available, please leave blank"]
[null,"1990-04-01",0,null,1993,{"$f":"SUM(C7:C18)","v":0}]
[null,"1990-05-01",0,null,1994,{"$f":"SUM(C52:C63)","v":3094}]
[null,"1990-06-01",0,null,1995,{"$f":"SUM(C64:C75)","v":0}]
[null,"1990-07-01",0,null,1996,{"$f":"SUM(C76:C87)","v":21233}]
[null,"1990-08-01",0,null,1997,{"$f":"SUM(C88:C99)","v":45031},null,null,null,"Step 2:","If monthly data is not available please enter annual State Water Project data in column F.  If data is not available, please leave blank"]
[null,"1990-09-01",0,null,1998,{"$f":"SUM(C100:C111)","v":760}]
[null,"1990-10-01",0,null,1999,{"$f":"SUM(C112:C123)","v":8899}]
[null,"1990-11-01",0,null,2000,{"$f":"SUM(C124:C135)","v":12288}]
[null,"1990-12-01",0,null,2001,{"$f":"SUM(C136:C147)","v":0},null,null,null,"Notes:","If you do not use any imported water from the State Water Project, please leave blank.  If no data is available for State Water Project, defaults will be used.  Source data can be inserted for future reference.  "]
[null,"1991-01-01",0,null,2002,{"$f":"SUM(C148:C159)","v":2945}]
[null,"1991-02-01",0,null,2003,{"$f":"SUM(C160:C171)","v":4639}]
[null,"1991-03-01",0,null,2004,{"$f":"SUM(C172:C183)","v":5139}]
[null,"1991-04-01",0,null,2005,{"$f":"SUM(C184:C195)","v":1377}]
[null,"1991-05-01",0,null,2006,{"$f":"SUM(C192:C203)","v":1377}]
[null,"1991-06-01",0,null,2007,{"$f":"SUM(C208:C219)","v":0}]
[null,"1991-07-01",0,null,2008,{"$f":"SUM(C220:C231)","v":0}]
[null,"1991-08-01",0,null,2009,{"$f":"SUM(C232:C243)","v":0}]
[null,"1991-09-01",0,null,2010,{"$f":"SUM(C244:C255)","v":0}]
[null,"1991-10-01",0,null,2011,{"$f":"SUM(C256:C267)","v":12272}]
[null,"1991-11-01",0,null,2012,0]
[null,"1991-12-01",0]
[null,"1992-01-01",0]
[null,"1992-02-01",0]
[null,"1992-03-01",0]
[null,"1992-04-01",0]
[null,"1992-05-01",0]
[null,"1992-06-01",0]
[null,"1992-07-01",0]
[null,"1992-08-01",0]
[null,"1992-09-01",0]
[null,"1992-10-01",0]
[null,"1992-11-01",0]
[null,"1992-12-01",0]
[null,"1993-01-01",0]
[null,"1993-02-01",0]
[null,"1993-03-01",0]
[null,"1993-04-01",0]
[null,"1993-05-01",0]
[null,"1993-06-01",0]
[null,"1993-07-01",0]
[null,"1993-08-01",0]
[null,"1993-09-01",0]
[null,"1993-10-01",0]
[null,"1993-11-01",0]
[null,"1993-12-01",0]
[null,"1994-01-01",0]
[null,"1994-02-01",0]
[null,"1994-03-01",0]
[null,"1994-04-01",0]
[null,"1994-05-01",0]
[null,"1994-06-01",0]
[null,"1994-07-01",0]
[null,"1994-08-01",0]
[null,"1994-09-01",0]
[null,"1994-10-01",292]
[null,"1994-11-01",2172]
[null,"1994-12-01",630]
[null,"1995-01-01",0]
[null,"1995-02-01",0]
[null,"1995-03-01",0]
[null,"1995-04-01",0]
[null,"1995-05-01",0]
[null,"1995-06-01",0]
[null,"1995-07-01",0]
[null,"1995-08-01",0]
[null,"1995-09-01",0]
[null,"1995-10-01",0]
[null,"1995-11-01",0]
[null,"1995-12-01",0]
[null,"1996-01-01",0]
[null,"1996-02-01",0]
[null,"1996-03-01",0]
[null,"1996-04-01",3538]
[null,"1996-05-01",6133]
[null,"1996-06-01",5608]
[null,"1996-07-01",5954]
[null,"1996-08-01",0]
[null,"1996-09-01",0]
[null,"1996-10-01",0]
[null,"1996-11-01",0]
[null,"1996-12-01",0]
[null,"1997-01-01",0]
[null,"1997-02-01",0]
[null,"1997-03-01",0]
[null,"1997-04-01",1428]
[null,"1997-05-01",6022]
[null,"1997-06-01",5973]
[null,"1997-07-01",6303]
[null,"1997-08-01",11571]
[null,"1997-09-01",11617]
[null,"1997-10-01",2117]
[null,"1997-11-01",0]
[null,"1997-12-01",0]
[null,"1998-01-01",0]
[null,"1998-02-01",0]
[null,"1998-03-01",0]
[null,"1998-04-01",0]
[null,"1998-05-01",0]
[null,"1998-06-01",0]
[null,"1998-07-01",544]
[null,"1998-08-01",216]
[null,"1998-09-01",0]
[null,"1998-10-01",0]
[null,"1998-11-01",0]
[null,"1998-12-01",0]
[null,"1999-01-01",0]
[null,"1999-02-01",0]
[null,"1999-03-01",0]
[null,"1999-04-01",0]
[null,"1999-05-01",0]
[null,"1999-06-01",0]
[null,"1999-07-01",0]
[null,"1999-08-01",0]
[null,"1999-09-01",0]
[null,"1999-10-01",5870]
[null,"1999-11-01",0]
[null,"1999-12-01",3029]
[null,"2000-01-01",3773]
[null,"2000-02-01",2038]
[null,"2000-03-01",0]
[null,"2000-04-01",0]
[null,"2000-05-01",0]
[null,"2000-06-01",0]
[null,"2000-07-01",0]
[null,"2000-08-01",0]
[null,"2000-09-01",0]
[null,"2000-10-01",2562]
[null,"2000-11-01",3915]
[null,"2000-12-01",0]
[null,"2001-01-01",0]
[null,"2001-02-01",0]
[null,"2001-03-01",0]
[null,"2001-04-01",0]
[null,"2001-05-01",0]
[null,"2001-06-01",0]
[null,"2001-07-01",0]
[null,"2001-08-01",0]
[null,"2001-09-01",0]
[null,"2001-10-01",0]
[null,"2001-11-01",0]
[null,"2001-12-01",0]
[null,"2002-01-01",0]
[null,"2002-02-01",0]
[null,"2002-03-01",0]
[null,"2002-04-01",0]
[null,"2002-05-01",0]
[null,"2002-06-01",0]
[null,"2002-07-01",517]
[null,"2002-08-01",2428]
[null,"2002-09-01",0]
[null,"2002-10-01",0]
[null,"2002-11-01",0]
[null,"2002-12-01",0]
[null,"2003-01-01",0]
[null,"2003-02-01",0]
[null,"2003-03-01",0]
[null,"2003-04-01",0]
[null,"2003-05-01",0]
[null,"2003-06-01",0]
[null,"2003-07-01",0]
[null,"2003-08-01",715]
[null,"2003-09-01",1051]
[null,"2003-10-01",2122]
[null,"2003-11-01",751]
[null,"2003-12-01",0]
[null,"2004-01-01",0]
[null,"2004-02-01",0]
[null,"2004-03-01",0]
[null,"2004-04-01",0]
[null,"2004-05-01",1723]
[null,"2004-06-01",740]
[null,"2004-07-01",1047]
[null,"2004-08-01",351]
[null,"2004-09-01",1278]
[null,"2004-10-01",0]
[null,"2004-11-01",0]
[null,"2004-12-01",0]
[null,"2005-01-01",0]
[null,"2005-02-01",0]
[null,"2005-03-01",0]
[null,"2005-04-01",0]
[null,"2005-05-01",0]
[null,"2005-06-01",0]
[null,"2005-07-01",0]
[null,"2005-08-01",0]
[null,"2005-09-01",662]
[null,"2005-10-01",715]
[null,"2005-11-01",0]
[null,"2005-12-01",0]
[null,"2006-01-01",0]
[null,"2006-02-01",0]
[null,"2006-03-01",0]
[null,"2006-04-01",0]
[null,"2006-05-01",0]
[null,"2006-06-01",0]
[null,"2006-07-01",0]
[null,"2006-08-01",0]
[null,"2006-09-01",0]
[null,"2006-10-01",0]
[null,"2006-11-01",0]
[null,"2006-12-01",0]
[null,"2007-01-01",0]
[null,"2007-02-01",0]
[null,"2007-03-01",0]
[null,"2007-04-01",0]
[null,"2007-05-01",0]
[null,"2007-06-01",0]
[null,"2007-07-01",0]
[null,"2007-08-01",0]
[null,"2007-09-01",0]
[null,"2007-10-01",0]
[null,"2007-11-01",0]
[null,"2007-12-01",0]
[null,"2008-01-01",0]
[null,"2008-02-01",0]
[null,"2008-03-01",0]
[null,"2008-04-01",0]
[null,"2008-05-01",0]
[null,"2008-06-01",0]
[null,"2008-07-01",0]
[null,"2008-08-01",0]
[null,"2008-09-01",0]
[null,"2008-10-01",0]
[null,"2008-11-01",0]
[null,"2008-12-01",0]
[null,"2009-01-01",0]
[null,"2009-02-01",0]
[null,"2009-03-01",0]
[null,"2009-04-01",0]
[null,"2009-05-01",0]
[null,"2009-06-01",0]
[null,"2009-07-01",0]
[null,"2009-08-01",0]
[null,"2009-09-01",0]
[null,"2009-10-01",0]
[null,"2009-11-01",0]
[null,"2009-12-01",0]
[null,"2010-01-01",0]
[null,"2010-02-01",0]
[null,"2010-03-01",0]
[null,"2010-04-01",0]
[null,"2010-05-01",0]
[null,"2010-06-01",0]
[null,"2010-07-01",0]
[null,"2010-08-01",0]
[null,"2010-09-01",0]
[null,"2010-10-01",0]
[null,"2010-11-01",0]
[null,"2010-12-01",0]
[null,"2011-01-01",0]
[null,"2011-02-01",0]
[null,"2011-03-01",0]
[null,"2011-04-01",0]
[null,"2011-05-01",0]
[null,"2011-06-01",50]
[null,"2011-07-01",4827]
[null,"2011-08-01",5493]
[null,"2011-09-01",1902]
[null,"2011-10-01",0]
[null,"2011-11-01",0]
[null,"2011-12-01",0]

{"sheet":"Colorado River Water Data","index":7,"n_rows":267,"n_cols":11,"rows_kept":267,"cut":false,"hidden":false,"merged":[[14,10,18,14],[1,0,1,6],[1,9,1,15],[4,9,4,14],[5,10,8,14],[10,10,12,14]]}
[]
["Imported Water Delivered Via the Santa Ana River",null,null,null,null,null,null,null,"Source:"]
[null,"Date","Monthly (ac-ft)",null,"Year","Annual (ac-ft)"]
[null,"1990-01-01",0,null,1990,{"$f":"SUM(C4:C15)","v":27097.999999999996}]
[null,"1990-02-01",0,null,1991,{"$f":"SUM(C16:C27)","v":53109.399999999994},null,null,null,"Instructions"]
[null,"1990-03-01",2605.8000000000002,null,1992,{"$f":"SUM(C40:C51)","v":22970.400000000001},null,null,null,"Step 1:","If available, please enter monthly State Water Project data in column C.  The data will automatically be aggregated to annual data.  If data is not available, please leave blank"]
[null,"1990-04-01",9900,null,1993,{"$f":"SUM(C7:C18)","v":27209.899999999998}]
[null,"1990-05-01",294.60000000000002,null,1994,{"$f":"SUM(C52:C63)","v":74107.399999999994}]
[null,"1990-06-01",1396.3,null,1995,{"$f":"SUM(C64:C75)","v":0}]
[null,"1990-07-01",45.4,null,1996,{"$f":"SUM(C76:C87)","v":6312.7}]
[null,"1990-08-01",31.9,null,1997,{"$f":"SUM(C88:C99)","v":8053.4},null,null,null,"Step 2:","If monthly data is not available please enter annual State Water Project data in column F.  If data is not available, please leave blank"]
[null,"1990-09-01",2437.1,null,1998,{"$f":"SUM(C100:C111)","v":9612}]
[null,"1990-10-01",7918.6,null,1999,{"$f":"SUM(C112:C123)","v":10001.5}]
[null,"1990-11-01",2468.3000000000002,null,2000,{"$f":"SUM(C124:C135)","v":59875.100000000006}]
[null,"1990-12-01",0,null,2001,{"$f":"SUM(C136:C147)","v":32150.7},null,null,null,"Notes:","If you do not use any imported water from the Colorado River, please leave blank.  If no data is available for State Water Project, defaults will be used.  Source data can be inserted for future reference.  "]
[null,"1991-01-01",2204.1,null,2002,{"$f":"SUM(C148:C159)","v":41027.700000000004}]
[null,"1991-02-01",513.6,null,2003,{"$f":"SUM(C160:C171)","v":13190.5}]
[null,"1991-03-01",0,null,2004,{"$f":"SUM(C172:C183)","v":0}]
[null,"1991-04-01",0,null,2005,{"$f":"SUM(C184:C195)","v":6880}]
[null,"1991-05-01",0,null,2006,{"$f":"SUM(C192:C203)","v":20177.699999999997}]
[null,"1991-06-01",0,null,2007,{"$f":"SUM(C208:C219)","v":7192.9}]
[null,"1991-07-01",0,null,2008,{"$f":"SUM(C220:C231)","v":0}]
[null,"1991-08-01",2083.3000000000002,null,2009,{"$f":"SUM(C232:C243)","v":24901.599999999999}]
[null,"1991-09-01",10478.4,null,2010,{"$f":"SUM(C244:C255)","v":30162.040000000005}]
[null,"1991-10-01",18069.7,null,2011,{"$f":"SUM(C256:C267)","v":40232.240000000005}]
[null,"1991-11-01",8657.1,null,2012,38890.500000000007]
[null,"1991-12-01",11103.2]
[null,"1992-01-01",0]
[null,"1992-02-01",0]
[null,"1992-03-01",0]
[null,"1992-04-01",4276.2]
[null,"1992-05-01",70.099999999999994]
[null,"1992-06-01",481.5]
[null,"1992-07-01",3603.4]
[null,"1992-08-01",8249.9000000000015]
[null,"1992-09-01",2399.3999999999996]
[null,"1992-10-01",49.7]
[null,"1992-11-01",1827]
[null,"1992-12-01",6463.3]
[null,"1993-01-01",1516.6999999999998]
[null,"1993-02-01",347.6]
[null,"1993-03-01",0]
[null,"1993-04-01",0]
[null,"1993-05-01",0]
[null,"1993-06-01",2023.8]
[null,"1993-07-01",818.90000000000009]
[null,"1993-08-01",11222.2]
[null,"1993-09-01",7041.2000000000007]
[null,"1993-10-01",0]
[null,"1993-11-01",0]
[null,"1993-12-01",0]
[null,"1994-01-01",3256]
[null,"1994-02-01",0]
[null,"1994-03-01",6662.4]
[null,"1994-04-01",13436.8]
[null,"1994-05-01",17905.099999999999]
[null,"1994-06-01",18178.7]
[null,"1994-07-01",0]
[null,"1994-08-01",0]
[null,"1994-09-01",0]
[null,"1994-10-01",5412.7]
[null,"1994-11-01",7477.7]
[null,"1994-12-01",1778]
[null,"1995-01-01",0]
[null,"1995-02-01",0]
[null,"1995-03-01",0]
[null,"1995-04-01",0]
[null,"1995-05-01",0]
[null,"1995-06-01",0]
[null,"1995-07-01",0]
[null,"1995-08-01",0]
[null,"1995-09-01",0]
[null,"1995-10-01",0]
[null,"1995-11-01",0]
[null,"1995-12-01",0]
[null,"1996-01-01",0]
[null,"1996-02-01",0]
[null,"1996-03-01",0]
[null,"1996-04-01",0]
[null,"1996-05-01",0]
[null,"1996-06-01",0]
[null,"1996-07-01",0]
[null,"1996-08-01",0]
[null,"1996-09-01",0]
[null,"1996-10-01",6312.5]
[null,"1996-11-01",0.2]
[null,"1996-12-01",0]
[null,"1997-01-01",0]
[null,"1997-02-01",0.1]
[null,"1997-03-01",0]
[null,"1997-04-01",2402.5]
[null,"1997-05-01",5299.2]
[null,"1997-06-01",351.6]
[null,"1997-07-01",0]
[null,"1997-08-01",0]
[null,"1997-09-01",0]
[null,"1997-10-01",0]
[null,"1997-11-01",0]
[null,"1997-12-01",0]
[null,"1998-01-01",0]
[null,"1998-02-01",0]
[null,"1998-03-01",0]
[null,"1998-04-01",0]
[null,"1998-05-01",0]
[null,"1998-06-01",0]
[null,"1998-07-01",0]
[null,"1998-08-01",0]
[null,"1998-09-01",0]
[null,"1998-10-01",9612]
[null,"1998-11-01",0]
[null,"1998-12-01",0]
[null,"1999-01-01",0]
[null,"1999-02-01",0]
[null,"1999-03-01",0]
[null,"1999-04-01",0]
[null,"1999-05-01",0]
[null,"1999-06-01",0]
[null,"1999-07-01",2582.9]
[null,"1999-08-01",3126.5]
[null,"1999-09-01",3034.6]
[null,"1999-10-01",1257.5]
[null,"1999-11-01",0]
[null,"1999-12-01",0]
[null,"2000-01-01",0]
[null,"2000-02-01",0]
[null,"2000-03-01",0]
[null,"2000-04-01",0]
[null,"2000-05-01",2350.4]
[null,"2000-06-01",4598.5]
[null,"2000-07-01",8198.7000000000007]
[null,"2000-08-01",11508.1]
[null,"2000-09-01",11535.7]
[null,"2000-10-01",10718.4]
[null,"2000-11-01",8986.4]
[null,"2000-12-01",1978.9]
[null,"2001-01-01",529.79999999999995]
[null,"2001-02-01",0]
[null,"2001-03-01",0]
[null,"2001-04-01",5751]
[null,"2001-05-01",518]
[null,"2001-06-01",763.9]
[null,"2001-07-01",46]
[null,"2001-08-01",0]
[null,"2001-09-01",0]
[null,"2001-10-01",10649.2]
[null,"2001-11-01",12048.5]
[null,"2001-12-01",1844.3]
[null,"2002-01-01",2147]
[null,"2002-02-01",0]
[null,"2002-03-01",0]
[null,"2002-04-01",0]
[null,"2002-05-01",525.9]
[null,"2002-06-01",5899]
[null,"2002-07-01",10802]
[null,"2002-08-01",9705.5]
[null,"2002-09-01",2812]
[null,"2002-10-01",4814.8]
[null,"2002-11-01",1678]
[null,"2002-12-01",2643.5]
[null,"2003-01-01",645.79999999999995]
[null,"2003-02-01",881.8]
[null,"2003-03-01",1116.4000000000001]
[null,"2003-04-01",0]
[null,"2003-05-01",0]
[null,"2003-06-01",354]
[null,"2003-07-01",5076.3999999999996]
[null,"2003-08-01",705.3]
[null,"2003-09-01",0]
[null,"2003-10-01",0]
[null,"2003-11-01",1733.7]
[null,"2003-12-01",2677.1]
[null,"2004-01-01",0]
[null,"2004-02-01",0]
[null,"2004-03-01",0]
[null,"2004-04-01",0]
[null,"2004-05-01",0]
[null,"2004-06-01",0]
[null,"2004-07-01",0]
[null,"2004-08-01",0]
[null,"2004-09-01",0]
[null,"2004-10-01",0]
[null,"2004-11-01",0]
[null,"2004-12-01",0]
[null,"2005-01-01",0]
[null,"2005-02-01",0]
[null,"2005-03-01",13.6]
[null,"2005-04-01",0]
[null,"2005-05-01",1121.5999999999999]
[null,"2005-06-01",0]
[null,"2005-07-01",1.9]
[null,"2005-08-01",467]
[null,"2005-09-01",3446.3]
[null,"2005-10-01",1824.2]
[null,"2005-11-01",1.1000000000000001]
[null,"2005-12-01",4.3]
[null,"2006-01-01",3.9]
[null,"2006-02-01",3]
[null,"2006-03-01",123.2]
[null,"2006-04-01",1.5]
[null,"2006-05-01",1.7]
[null,"2006-06-01",0.9]
[null,"2006-07-01",4014.3]
[null,"2006-08-01",10753.3]
[null,"2006-09-01",8776.2999999999993]
[null,"2006-10-01",7400.1]
[null,"2006-11-01",4037.3999999999996]
[null,"2006-12-01",0]
[null,"2007-01-01",0]
[null,"2007-02-01",0]
[null,"2007-03-01",1388]
[null,"2007-04-01",5803.5]
[null,"2007-05-01",1]
[null,"2007-06-01",0.4]
[null,"2007-07-01",0]
[null,"2007-08-01",0]
[null,"2007-09-01",0]
[null,"2007-10-01",0]
[null,"2007-11-01",0]
[null,"2007-12-01",0]
[null,"2008-01-01",0]
[null,"2008-02-01",0]
[null,"2008-03-01",0]
[null,"2008-04-01",0]
[null,"2008-05-01",0]
[null,"2008-06-01",0]
[null,"2008-07-01",0]
[null,"2008-08-01",0]
[null,"2008-09-01",0]
[null,"2008-10-01",0]
[null,"2008-11-01",0]
[null,"2008-12-01",0]
[null,"2009-01-01",0]
[null,"2009-02-01",0]
[null,"2009-03-01",0]
[null,"2009-04-01",0]
[null,"2009-05-01",9895.2999999999993]
[null,"2009-06-01",8204.7000000000007]
[null,"2009-07-01",1364.1]
[null,"2009-08-01",5437.5]
[null,"2009-09-01",0]
[null,"2009-10-01",0]
[null,"2009-11-01",0]
[null,"2009-12-01",0]
[null,"2010-01-01",8]
[null,"2010-02-01",0]
[null,"2010-03-01",1612.3]
[null,"2010-04-01",7770.3]
[null,"2010-05-01",4287.1000000000004]
[null,"2010-06-01",56.35]
[null,"2010-07-01",3247.9]
[null,"2010-08-01",3661.02]
[null,"2010-09-01",5299.2]
[null,"2010-10-01",2542.9]
[null,"2010-11-01",1676.97]
[null,"2010-12-01",0]
[null,"2011-01-01",0]
[null,"2011-02-01",5]
[null,"2011-03-01",72.300000000000011]
[null,"2011-04-01",0]
[null,"2011-05-01",1242.8200000000002]
[null,"2011-06-01",9740.42]
[null,"2011-07-01",11898.5]
[null,"2011-08-01",9831.5]
[null,"2011-09-01",7277.4]
[null,"2011-10-01",0]
[null,"2011-11-01",0]
[null,"2011-12-01",164.3]

{"sheet":"Potable Water Treatment Data","index":8,"n_rows":266,"n_cols":20,"rows_kept":266,"cut":false,"hidden":false,"merged":[[13,19,17,23],[0,0,0,16],[0,19,0,25],[3,18,3,23],[4,19,7,23],[9,19,11,23]]}
["Potable Water Treatment Flow Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source:"]
["Date","Flow per Month to Treatment Plant 1 (gal)","Flow per Month to Treatment Plant 2 (gal)","Flow per Month to Treatment Plant 3 (gal)","Flow per Month to Treatment Plant 4 (gal)","Flow per Month to Treatment Plant 5 (gal)","Flow per Month to Treatment Plant 6 (gal)","Flow per Month to Treatment Plant 7 (gal)","Flow per Month to Treatment Plant 8 (gal)","Flow per Month to Treatment Plant 9 (gal)","Flow per Month to Treatment Plant 10 (gal)","Flow per Month to Treatment Plant 11 (gal)","Total Monthly Flow to Treatment Plant (MG)",null,"Year","Total Annual Flow to Treatment Plant (MG)","Average Daily Flow per Year to Treatment Plant (MGD)"]
["1990-01-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:L3)*0.000001","v":0},null,1990,{"$f":"SUM(M3:M14)","v":0},{"$f":"SUM(M3:M14)/365","v":0}]
["1990-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:L4)*0.000001","v":0},null,1991,{"$f":"SUM(M15:M26)","v":0},{"$f":"SUM(M15:M26)/365","v":0},null,"Instructions"]
["1990-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1992,{"$f":"SUM(M39:M50)","v":0},{"$f":"SUM(M39:M50)/365","v":0},null,"Step 1:","If available, please enter monthly flow data for all drinking water treatment plants in columns B-L., if not available please leave blank.  The data will automatically be summed and converted to MGD."]
["1990-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1993,{"$f":"SUM(M6:M17)","v":0},{"$f":"SUM(M6:M17)/365","v":0}]
["1990-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1994,{"$f":"SUM(M51:M62)","v":0},{"$f":"SUM(M51:M62)/365","v":0}]
["1990-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1995,{"$f":"SUM(M63:M74)","v":0},{"$f":"SUM(M63:M74)/365","v":0}]
["1990-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1996,{"$f":"SUM(M75:M86)","v":0},{"$f":"SUM(M75:M86)/365","v":0}]
["1990-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1997,{"$f":"SUM(M87:M98)","v":0},{"$f":"SUM(M87:M98)/365","v":0},null,"Step 2:","If monthly data is not available please enter total annual flow data in column P, if not available please leave blank."]
["1990-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1998,{"$f":"SUM(M99:M110)","v":0},{"$f":"SUM(M99:M110)/365","v":0}]
["1990-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1999,{"$f":"SUM(M111:M122)","v":0},{"$f":"SUM(M111:M122)/365","v":0}]
["1990-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2000,{"$f":"SUM(M123:M134)","v":0},{"$f":"SUM(M123:M134)/365","v":0}]
["1990-12-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2001,{"$f":"SUM(M135:M146)","v":0},{"$f":"SUM(M135:M146)/365","v":0},null,"Notes:","If no water treatment flow data is available, defaults will be used.  Source data can be inserted for future reference.  "]
["1991-01-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2002,{"$f":"SUM(M147:M158)","v":0},{"$f":"SUM(M147:M158)/365","v":0}]
["1991-02-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2003,{"$f":"SUM(M159:M170)","v":0},{"$f":"SUM(M159:M170)/365","v":0}]
["1991-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2004,{"$f":"SUM(M171:M182)","v":0},{"$f":"SUM(M171:M182)/365","v":0}]
["1991-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2005,{"$f":"SUM(M183:M194)","v":0},{"$f":"SUM(M183:M194)/365","v":0}]
["1991-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2006,{"$f":"SUM(M191:M202)","v":0},{"$f":"SUM(M191:M202)/365","v":0}]
["1991-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2007,{"$f":"SUM(M207:M218)","v":0},{"$f":"SUM(M207:M218)/365","v":0}]
["1991-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2008,{"$f":"SUM(M219:M230)","v":0},{"$f":"SUM(M219:M230)/365","v":0}]
["1991-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2009,{"$f":"SUM(M231:M242)","v":0},{"$f":"SUM(M231:M242)/365","v":0}]
["1991-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2010,{"$f":"SUM(M243:M254)","v":0},{"$f":"SUM(M243:M254)/365","v":0}]
["1991-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2011,{"$f":"SUM(M255:M266)","v":4225.9945109999999},{"$f":"SUM(M255:M266)/365","v":11.578067153424657}]
["1991-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2012,0,{"$f":"SUM(M25:M36)/365","v":0}]
["1991-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-06-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B68:L68)*0.000001","v":0}]
["1995-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-10-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B132:L132)*0.000001","v":0}]
["2000-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B196:L196)*0.000001","v":0}]
["2006-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-01-01",25829100,20323245,192545356,19666416,14138696,37711168,0,26641200,null,null,null,336.85518099999996]
["2011-02-01",27506793,15555066,62400467,19047820,13659228,34692988,0,31648300,null,null,null,204.510662]
["2011-03-01",34231573,852042,194500462,8797976,13611356,50811640,0,26286000,null,null,null,329.091049]
["2011-04-01",32722008,0,230018221,12048036,14016772,53134180,7132928,31188000,null,null,null,380.26014499999997]
["2011-05-01",31722691,0,245593899,15623476,13241844,58770360,21906676,30228400,null,null,null,417.08734599999997]
["2011-06-01",31587147,0,237806060,4152148,9332796,16474700,16108180,44532900,null,null,null,{"$f":"SUM(B260:L260)*0.000001","v":359.99393099999998}]
["2011-07-01",32942594,7218411,219167383,17211480,13216412,0,28424,30745000,null,null,null,320.52970399999998]
["2011-08-01",22359349,21476027,239924091,24941312,588676,0,1861024,41809700,null,null,null,352.96017899999998]
["2011-09-01",16597393,20680353,348269549,11920876,360536,6408116,8533932,18416000,null,null,null,431.18675500000001]
["2011-10-01",15506844,19432429,349507783,11837848,551276,49027660,21158676,12676900,null,null,null,479.69941599999999]
["2011-11-01",16443276,15823875,179771997,8358900,1014288,53274804,8147216,19709300,null,null,null,302.543656]
["2011-12-01",15272899,16220735,185344049,4158880,708356,61843892,9321576,18406100,null,null,null,311.27648699999997]

{"sheet":"E for Treatment Data","index":9,"n_rows":266,"n_cols":20,"rows_kept":266,"cut":false,"hidden":false,"merged":[[13,19,17,23],[0,0,0,16],[0,19,0,25],[3,18,3,23],[4,19,7,23],[9,19,11,23]]}
["Potable Water Treatment Energy Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source:","OCWD"]
["Date","Energy per Month to Treatment Plant 1 (KWh)","Energy per Month to Treatment Plant 2 (KWh)","Energy per Month to Treatment Plant 3 (KWh)","Energy per Month to Treatment Plant 4 (KWh)","Energy per Month to Treatment Plant 5 (KWh)","Energy per Month to Treatment Plant 6 (KWh)","Energy per Month to Treatment Plant 7 (KWh)","Energy per Month to Treatment Plant 8 (KWh)","Energy per Month to Treatment Plant 9 (KWh)","Energy per Month to Treatment Plant 10 (KWh)","Energy per Month to Treatment Plant 11 (KWh)","Total Energy per Month to Treatment Plant (KWh)",null,"Year","Total Energy per Year to Treatment Plant (KWh)","Water Intensities (KWh/MG)"]
["1990-01-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:L3)","v":0},null,1990,{"$f":"SUM(M3:M14)","v":0},{"$f":"IF('Potable Water Treatment Data'!P3=0,0,P3/'Potable Water Treatment Data'!P3)","v":0}]
["1990-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:L4)","v":0},null,1991,{"$f":"SUM(M15:M26)","v":0},{"$f":"IF('Potable Water Treatment Data'!P4=0,0,P4/'Potable Water Treatment Data'!P4)","v":0},null,"Instructions"]
["1990-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1992,{"$f":"SUM(M39:M50)","v":0},{"$f":"IF('Potable Water Treatment Data'!P5=0,0,P5/'Potable Water Treatment Data'!P5)","v":0},null,"Step 1:","If available, please enter monthly energy data for all drinking water treatment plants in columns B-L., if not available please leave blank.  The data will automatically be summed and converted to intensities."]
["1990-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1993,{"$f":"SUM(M6:M17)","v":0},{"$f":"IF('Potable Water Treatment Data'!P6=0,0,P6/'Potable Water Treatment Data'!P6)","v":0}]
["1990-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1994,{"$f":"SUM(M51:M62)","v":0},{"$f":"IF('Potable Water Treatment Data'!P7=0,0,P7/'Potable Water Treatment Data'!P7)","v":0}]
["1990-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1995,{"$f":"SUM(M63:M74)","v":0},{"$f":"IF('Potable Water Treatment Data'!P8=0,0,P8/'Potable Water Treatment Data'!P8)","v":0}]
["1990-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1996,{"$f":"SUM(M75:M86)","v":0},{"$f":"IF('Potable Water Treatment Data'!P9=0,0,P9/'Potable Water Treatment Data'!P9)","v":0}]
["1990-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1997,{"$f":"SUM(M87:M98)","v":0},{"$f":"IF('Potable Water Treatment Data'!P10=0,0,P10/'Potable Water Treatment Data'!P10)","v":0},null,"Step 2:","If monthly data is not available please enter total annual energy data in column P, if not available please leave blank."]
["1990-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1998,{"$f":"SUM(M99:M110)","v":0},{"$f":"IF('Potable Water Treatment Data'!P11=0,0,P11/'Potable Water Treatment Data'!P11)","v":0}]
["1990-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1999,{"$f":"SUM(M111:M122)","v":0},{"$f":"IF('Potable Water Treatment Data'!P12=0,0,P12/'Potable Water Treatment Data'!P12)","v":0}]
["1990-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2000,{"$f":"SUM(M123:M134)","v":0},{"$f":"IF('Potable Water Treatment Data'!P13=0,0,P13/'Potable Water Treatment Data'!P13)","v":0}]
["1990-12-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2001,{"$f":"SUM(M135:M146)","v":0},{"$f":"IF('Potable Water Treatment Data'!P14=0,0,P14/'Potable Water Treatment Data'!P14)","v":0},null,"Notes:","If no water treatment flow data is available, defaults will be used.  Source data can be inserted for future reference.  "]
["1991-01-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2002,{"$f":"SUM(M147:M158)","v":0},{"$f":"IF('Potable Water Treatment Data'!P15=0,0,P15/'Potable Water Treatment Data'!P15)","v":0}]
["1991-02-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2003,{"$f":"SUM(M159:M170)","v":0},{"$f":"IF('Potable Water Treatment Data'!P16=0,0,P16/'Potable Water Treatment Data'!P16)","v":0}]
["1991-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2004,{"$f":"SUM(M171:M182)","v":0},{"$f":"IF('Potable Water Treatment Data'!P17=0,0,P17/'Potable Water Treatment Data'!P17)","v":0}]
["1991-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2005,{"$f":"SUM(M183:M194)","v":0},{"$f":"IF('Potable Water Treatment Data'!P18=0,0,P18/'Potable Water Treatment Data'!P18)","v":0}]
["1991-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2006,{"$f":"SUM(M191:M202)","v":0},{"$f":"IF('Potable Water Treatment Data'!P19=0,0,P19/'Potable Water Treatment Data'!P19)","v":0}]
["1991-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2007,{"$f":"SUM(M207:M218)","v":0},{"$f":"IF('Potable Water Treatment Data'!P20=0,0,P20/'Potable Water Treatment Data'!P20)","v":0}]
["1991-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2008,{"$f":"SUM(M219:M230)","v":0},{"$f":"IF('Potable Water Treatment Data'!P21=0,0,P21/'Potable Water Treatment Data'!P21)","v":0}]
["1991-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2009,{"$f":"SUM(M231:M242)","v":0},{"$f":"IF('Potable Water Treatment Data'!P22=0,0,P22/'Potable Water Treatment Data'!P22)","v":0}]
["1991-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2010,{"$f":"SUM(M243:M254)","v":0},{"$f":"IF('Potable Water Treatment Data'!P23=0,0,P23/'Potable Water Treatment Data'!P23)","v":0}]
["1991-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2011,{"$f":"SUM(M255:M266)","v":2097371},{"$f":"IF('Potable Water Treatment Data'!P24=0,0,P24/'Potable Water Treatment Data'!P24)","v":496.3023483680999}]
["1991-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2012,0,{"$f":"IF('Potable Water Treatment Data'!P25=0,0,P25/'Potable Water Treatment Data'!P25)","v":0}]
["1991-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-02-01",null,null,null,null,null,null,null,null,null,null,null,0,null,"Year","Water Intensities (KWh/MG)"]
["1992-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1990,{"$f":"IF((IFERROR((SUM(Q3:Q12)/(COUNTIF(Q3:Q12,\">0\"))),0))=0,(IFERROR((SUM(Q3:Q25)/(COUNTIF(Q3:Q25,\">0\"))),0)))","v":496.3023483680999}]
["1992-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2000,{"$f":"IF((IFERROR((SUM(Q13:Q22)/(COUNTIF(Q13:Q22,\">0\"))),0))=0,(IFERROR((SUM(Q3:Q25)/(COUNTIF(Q3:Q25,\">0\"))),0)))","v":496.3023483680999}]
["1992-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2010,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":496.3023483680999}]
["1992-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2020,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":496.3023483680999}]
["1992-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2030,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":496.3023483680999}]
["1992-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2040,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":496.3023483680999}]
["1992-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2050,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":496.3023483680999}]
["1992-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-06-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B68:L68)","v":0}]
["1995-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-10-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B132:L132)","v":0}]
["2000-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B196:L196)","v":0}]
["2006-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-01-01",2238,1156,66240,2466,13638,56183,562,18800,null,null,null,161283]
["2011-02-01",2296,898,52320,1980,13146,54940,418,21680,null,null,null,147678]
["2011-03-01",3170,220,84160,1800,12671,62302,10707,16320,null,null,null,191350]
["2011-04-01",3122,172,82720,2178,14017,62683,20860,21840,null,null,null,207592]
["2011-05-01",2900,214,90880,1998,9617,85868,43514,17520,null,null,null,252511]
["2011-06-01",2974,202,91040,1854,13010,5094,2281,25040,null,null,null,{"$f":"SUM(B260:L260)","v":141495}]
["2011-07-01",3132,610,83360,2610,6024,2933,1386,32560,null,null,null,132615]
["2011-08-01",1960,1178,97760,2160,570,3187,3229,27520,null,null,null,137564]
["2011-09-01",1636,1162,94400,1152,591,12989,14952,13680,null,null,null,140562]
["2011-10-01",1508,678,96800,1062,1504,75990,36112,10960,null,null,null,224614]
["2011-11-01",1576,936,76800,828,906,64911,18087,15440,null,null,null,179484]
["2011-12-01",1524,982,81120,1008,1022,73813,1634,19520,null,null,null,180623]

{"sheet":"Groundwater Data","index":10,"n_rows":266,"n_cols":19,"rows_kept":266,"cut":false,"hidden":false,"merged":[[13,18,17,22],[0,0,0,15],[0,19,0,25],[3,17,3,22],[4,18,7,22],[9,18,11,22]]}
["Groundwater Elevation Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source:"]
["Date","Flow per Month from site 1 (gal)","Flow per Month from site 2 (gal)","Flow per Month from site 3 (gal)","Flow per Month from site 4 (gal)","Flow per Month from site 5 (gal)","Flow per Month from site 6 (gal)","Flow per Month from site 7 (gal)","Flow per Month from site 8 (gal)","Flow per Month from site 9 (gal)","Flow per Month from site 10 (gal)","Flow per Month from site 11 (gal)","Total Monthly Flow (MG)",null,"Year","Total Annual Flow (MG)"]
["1990-01-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:L3)*0.000001","v":0},null,1990,{"$f":"SUM(M3:M14)","v":0}]
["1990-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:L4)*0.000001","v":0},null,1991,{"$f":"SUM(M15:M26)","v":0},null,"Instructions"]
["1990-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1992,{"$f":"SUM(M39:M50)","v":0},null,"Step 1:","If available, please enter monthly flow data for all ground water extraction points in columns B-L., if not available please leave blank.  The data will automatically be summed and converted to MG."]
["1990-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1993,{"$f":"SUM(M6:M17)","v":0}]
["1990-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1994,{"$f":"SUM(M51:M62)","v":0}]
["1990-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1995,{"$f":"SUM(M63:M74)","v":0}]
["1990-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1996,{"$f":"SUM(M75:M86)","v":0}]
["1990-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1997,{"$f":"SUM(M87:M98)","v":0},null,"Step 2:","If monthly data is not available please enter total annual flow data in column P, if not available please leave blank."]
["1990-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1998,{"$f":"SUM(M99:M110)","v":0}]
["1990-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1999,{"$f":"SUM(M111:M122)","v":0}]
["1990-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2000,{"$f":"SUM(M123:M134)","v":0}]
["1990-12-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2001,{"$f":"SUM(M135:M146)","v":0},null,"Notes:","If no groundwater extraction data is available, defaults will be used.  Source data can be inserted for future reference.  "]
["1991-01-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2002,{"$f":"SUM(M147:M158)","v":0}]
["1991-02-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2003,{"$f":"SUM(M159:M170)","v":0}]
["1991-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2004,{"$f":"SUM(M171:M182)","v":0}]
["1991-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2005,{"$f":"SUM(M183:M194)","v":0}]
["1991-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2006,{"$f":"SUM(M191:M202)","v":0}]
["1991-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2007,{"$f":"SUM(M207:M218)","v":0}]
["1991-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2008,{"$f":"SUM(M219:M230)","v":0}]
["1991-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2009,{"$f":"SUM(M231:M242)","v":0}]
["1991-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2010,{"$f":"SUM(M243:M254)","v":0}]
["1991-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2011,{"$f":"SUM(M255:M266)","v":0}]
["1991-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2012,0]
["1991-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-06-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B68:L68)*0.000001","v":0}]
["1995-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-10-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B132:L132)*0.000001","v":0}]
["2000-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B196:L196)*0.000001","v":0}]
["2006-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-06-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B260:L260)*0.000001","v":0}]
["2011-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-12-01",null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"E for Groundwater Data","index":11,"n_rows":266,"n_cols":20,"rows_kept":266,"cut":false,"hidden":false,"merged":[[13,19,17,23],[0,19,0,25],[0,0,0,16],[3,18,3,23],[4,19,7,23],[9,19,11,23]]}
["Groundwater Extraction Energy Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source:","OCWD"]
["Date","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)","Energy per Month for Groundwater Extraction (KWh)",null,"Year","Total Energy per Year for GW Extraction (KWh)","Water Intensities (KWh/MG)"]
["1990-01-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:L3)","v":0},null,1990,{"$f":"SUM(M3:M14)","v":0},{"$f":"IF('Groundwater Data'!P3=0,0,P3/'Groundwater Data'!P3)","v":0}]
["1990-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:L4)","v":0},null,1991,{"$f":"SUM(M15:M26)","v":0},{"$f":"IF('Groundwater Data'!P4=0,0,P4/'Groundwater Data'!P4)","v":0},null,"Instructions"]
["1990-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1992,{"$f":"SUM(M39:M50)","v":0},{"$f":"IF('Groundwater Data'!P5=0,0,P5/'Groundwater Data'!P5)","v":0},null,"Step 1:","If available, please enter monthly energy data for all groundwater extraction points in columns B-L., if not available please leave blank.  The data will automatically be summed and converted to intensities."]
["1990-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1993,{"$f":"SUM(M6:M17)","v":0},{"$f":"IF('Groundwater Data'!P6=0,0,P6/'Groundwater Data'!P6)","v":0}]
["1990-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1994,{"$f":"SUM(M51:M62)","v":0},{"$f":"IF('Groundwater Data'!P7=0,0,P7/'Groundwater Data'!P7)","v":0}]
["1990-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1995,{"$f":"SUM(M63:M74)","v":0},{"$f":"IF('Groundwater Data'!P8=0,0,P8/'Groundwater Data'!P8)","v":0}]
["1990-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1996,{"$f":"SUM(M75:M86)","v":0},{"$f":"IF('Groundwater Data'!P9=0,0,P9/'Groundwater Data'!P9)","v":0}]
["1990-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1997,{"$f":"SUM(M87:M98)","v":0},{"$f":"IF('Groundwater Data'!P10=0,0,P10/'Groundwater Data'!P10)","v":0},null,"Step 2:","If monthly data is not available please enter total annual energy data in column P, if not available please leave blank."]
["1990-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1998,{"$f":"SUM(M99:M110)","v":0},{"$f":"IF('Groundwater Data'!P11=0,0,P11/'Groundwater Data'!P11)","v":0}]
["1990-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1999,{"$f":"SUM(M111:M122)","v":0},{"$f":"IF('Groundwater Data'!P12=0,0,P12/'Groundwater Data'!P12)","v":0}]
["1990-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2000,{"$f":"SUM(M123:M134)","v":0},{"$f":"IF('Groundwater Data'!P13=0,0,P13/'Groundwater Data'!P13)","v":0}]
["1990-12-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2001,{"$f":"SUM(M135:M146)","v":0},{"$f":"IF('Groundwater Data'!P14=0,0,P14/'Groundwater Data'!P14)","v":0},null,"Notes:","If no groundwater extraction data is available, defaults will be used.  Source data can be inserted for future reference.  "]
["1991-01-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2002,{"$f":"SUM(M147:M158)","v":0},{"$f":"IF('Groundwater Data'!P15=0,0,P15/'Groundwater Data'!P15)","v":0}]
["1991-02-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2003,{"$f":"SUM(M159:M170)","v":0},{"$f":"IF('Groundwater Data'!P16=0,0,P16/'Groundwater Data'!P16)","v":0}]
["1991-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2004,{"$f":"SUM(M171:M182)","v":0},{"$f":"IF('Groundwater Data'!P17=0,0,P17/'Groundwater Data'!P17)","v":0}]
["1991-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2005,{"$f":"SUM(M183:M194)","v":0},{"$f":"IF('Groundwater Data'!P18=0,0,P18/'Groundwater Data'!P18)","v":0}]
["1991-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2006,{"$f":"SUM(M191:M202)","v":0},{"$f":"IF('Groundwater Data'!P19=0,0,P19/'Groundwater Data'!P19)","v":0}]
["1991-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2007,{"$f":"SUM(M207:M218)","v":0},{"$f":"IF('Groundwater Data'!P20=0,0,P20/'Groundwater Data'!P20)","v":0}]
["1991-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2008,{"$f":"SUM(M219:M230)","v":0},{"$f":"IF('Groundwater Data'!P21=0,0,P21/'Groundwater Data'!P21)","v":0}]
["1991-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2009,{"$f":"SUM(M231:M242)","v":0},{"$f":"IF('Groundwater Data'!P22=0,0,P22/'Groundwater Data'!P22)","v":0}]
["1991-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2010,{"$f":"SUM(M243:M254)","v":0},{"$f":"IF('Groundwater Data'!P23=0,0,P23/'Groundwater Data'!P23)","v":0}]
["1991-10-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2011,{"$f":"SUM(M255:M266)","v":14609927},{"$f":"IF('Groundwater Data'!P24=0,0,P24/'Groundwater Data'!P24)","v":0}]
["1991-11-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2012,0,{"$f":"IF('Groundwater Data'!P25=0,0,P25/'Groundwater Data'!P25)","v":0}]
["1991-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-02-01",null,null,null,null,null,null,null,null,null,null,null,0,null,"Year","Water Intensities (KWh/MG)"]
["1992-03-01",null,null,null,null,null,null,null,null,null,null,null,0,null,1990,{"$f":"IF((IFERROR((SUM(Q3:Q12)/(COUNTIF(Q3:Q12,\">0\"))),0))=0,(IFERROR((SUM(Q3:Q25)/(COUNTIF(Q3:Q25,\">0\"))),0)))","v":0}]
["1992-04-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2000,{"$f":"IF((IFERROR((SUM(Q13:Q22)/(COUNTIF(Q13:Q22,\">0\"))),0))=0,(IFERROR((SUM(Q3:Q25)/(COUNTIF(Q3:Q25,\">0\"))),0)))","v":0}]
["1992-05-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2010,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":0}]
["1992-06-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2020,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":0}]
["1992-07-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2030,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":0}]
["1992-08-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2040,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":0}]
["1992-09-01",null,null,null,null,null,null,null,null,null,null,null,0,null,2050,{"$f":"IFERROR((SUM(Q23:Q25)/(COUNTIF(Q23:Q25,\">0\"))),0)","v":0}]
["1992-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1992-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1993-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1994-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-06-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B68:L68)","v":0}]
["1995-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1995-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1996-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1997-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1998-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["1999-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-10-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B132:L132)","v":0}]
["2000-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2000-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2001-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2002-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2003-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2004-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2005-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-02-01",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B196:L196)","v":0}]
["2006-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2006-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2007-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2008-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2009-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-01-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-02-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-03-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-04-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-05-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-06-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-07-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-08-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-09-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-10-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-11-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2010-12-01",null,null,null,null,null,null,null,null,null,null,null,0]
["2011-01-01",2466,13638,56183,562,1373380,null,null,null,null,null,null,1446229]
["2011-02-01",1980,13146,54940,418,898540,null,null,null,null,null,null,969024]
["2011-03-01",1800,12671,62302,10707,781120,null,null,null,null,null,null,868600]
["2011-04-01",2178,14017,62683,20860,1123420,null,null,null,null,null,null,1223158]
["2011-05-01",1998,9617,85868,43514,1690520,null,null,null,null,null,null,1831517]
["2011-06-01",1854,13010,5094,2241,1194080,null,null,null,null,null,null,{"$f":"SUM(B260:L260)","v":1216279}]
["2011-07-01",2610,6024,2933,1386,1210680,null,null,null,null,null,null,1223633]
["2011-08-01",2160,570,3187,3229,1158540,null,null,null,null,null,null,1167686]
["2011-09-01",1152,591,12989,14952,897860,null,null,null,null,null,null,927544]
["2011-10-01",1062,1504,75990,36112,1635840,null,null,null,null,null,null,1750508]
["2011-11-01",828,906,64911,18087,902580,null,null,null,null,null,null,987312]
["2011-12-01",1008,1022,73813,1634,920960,null,null,null,null,null,null,998437]

{"sheet":"Default Energy Data","index":12,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,7,1,11],[2,7,2,9],[7,1,7,5],[1,1,1,5],[2,1,2,3],[5,2,5,5],[4,7,4,9],[5,7,5,9],[12,2,12,5],[15,8,15,9],[16,8,16,9],[6,8,6,11],[21,1,21,5],[8,8,8,11],[9,8,9,10],[41,2,41,5],[17,9,17,13],[13,9,13,11],[14,1,14,5],[19,2,19,6]]}
[]
[null,"Energy intensities for Groundwater Extraction",null,null,null,null,null,"California Specific Water Intensities"]
[null,null,null,null,"Groundwater Extraction (kWh/MG)","Water Table Depth (ft)",null,"Water use cycle segments",null,null,"So Cal (kWh/MG)","No Cal (kWh/MG)"]
[null,"Low Value (default)",null,null,540,120,null,"Supply and Conveyance",null,null,8900,150]
[null,"High Value",null,null,2270,500,null,"Treatment",null,null,100,100]
[null,"Source:","From Energy Down the Drain: The Hidden Costs of California's Water Supply, NRDC and The Pacific Institute, 2004 page 11",null,null,null,null,"Distribution",null,null,1200,1200]
[null,null,null,null,null,null,null,"Source:","http://www.energy.ca.gov/2005publications/CEC‐700‐2005‐011/CEC‐700‐2005‐011‐SF.PDF, Table 1‐3.Ibid. The distinction between Northern and Southern California is detailed on page 111 of the CEC report."]
[null,"Energy intensities for Water Conveyance"]
[null,null,null,null,"Local Water (kWh/MG)","Imported Water (kWh/MG)",null,null,"Energy intensities for Water Distribution "]
[null,"Low Value ",null,null,88,1900,null,null,null,null,null,"Distribution Intensity (kWh/MG)"]
[null,"Median Value",null,null,110,3000,null,null,"Low Value ",null,null,360]
[null,"High Value",null,null,330,5300,null,null,"Median Value",null,null,540]
[null,"Source:","Adapted from Implications of Future Water Supply Sources for Energy Demands, WateReuse ResearchFoundation, 2012. See: http://www.pacinst.org/resources/wesim/report.pdf, Table 4.2.",null,null,null,null,null,"High Value",null,null,860]
[null,null,null,null,null,null,null,null,"Source:","Adapted from Implications of Future Water Supply Sources for Energy Demands, WateReuse Research Foundation, 2012. See: http://www.pacinst.org/resources/wesim/report.pdf, Table 4.8."]
[null,"Energy intensities for Water Treatment"]
[null,null,null,"<1MGD         (kWh/MG)","1-5 MGD  (kWh/MG)","5-20 MGD (kWh/MG)",">20 MGD (kWh/MG)",null,"CO2 Emissions Factor (lbs CO2/MWh)",null,2004,2005,2006,2007]
[null,"Low Value ",null,620,300,180,120,null,"Southern California Edison ",null,678.88,665.72,641.26,630.89]
[null,"Median Value",null,1500,750,560,210,null,"Source:","Data from the California Climate Action Registry Power/Utility Protocol public reports, http://www.climateregistry.org/CARROT/public/reports.aspx"]
[null,"High Value",null,2000,1300,1100,2000]
[null,"Source:","Adapted from Implications of Future Water Supply Sources for Energy Demands, WateReuse Research Foundation, 2012. See: http://www.pacinst.org/resources/wesim/report.pdf, Table 4.3."]
[]
[null,"California Grid Average Electricity Emission Factors (lbs/MWh)"]
[null,"Year","CO2","CH4","N2O","CO2e"]
[null,1990,1031.1400000000001,0.04,1.4E-2,1036.19]
[null,1991,994.03,3.6999999999999998E-2,1.2999999999999999E-2,998.72]
[null,1992,984.42,0.04,1.2E-2,988.87]
[null,1993,1007.26,3.6999999999999998E-2,1.2999999999999999E-2,1011.91]
[null,1994,1071.19,0.04,1.2999999999999999E-2,1075.94]
[null,1995,929.77,3.1E-2,1.2E-2,934.03]
[null,1996,827.65,2.9000000000000001E-2,1.0999999999999999E-2,831.57]
[null,1997,874.96,2.9000000000000001E-2,1.0999999999999999E-2,878.88]
[null,1998,941.54,2.9000000000000001E-2,1.0999999999999999E-2,945.46]
[null,1999,917.6,3.1E-2,1.0999999999999999E-2,921.56]
[null,2000,829.5,2.9000000000000001E-2,8.9999999999999993E-3,839.82]
[null,2001,1009.75,3.3000000000000002E-2,1.0999999999999999E-2,1013.75]
[null,2002,865.28,3.1E-2,0.01,868.94]
[null,2003,888.41,3.1E-2,1.0999999999999999E-2,892.37]
[null,2004,958.49,2.9000000000000001E-2,1.0999999999999999E-2,962.41]
[null,2005,948.28,0.03,1.0999999999999999E-2,952.22]
[null,2006,889.75,3.1E-2,8.9999999999999993E-3,893.11]
[null,2007,919.64,2.9000000000000001E-2,0.01,923.26]
[null,"Source:","Sources: Calculated from total in‐state and imported electricity emissions divided by total use in MWh. Emissions from California Air Resources Board,\nGreenhouse Gas Inventory, 1990 – 2004 (November 17, 2007 version), available on line. CO2e calculated using current 100‐yearGlobal Warming\nPotentials (GWPs)from US EPA.(GWPCO2 = 1, GWCH4 = 21, GWPN2O = 310)."]