October 31, 2024 (Final DWR Data) The 2018 Legislation required DWR to provide or otherwise identify data regarding the unique local conditions to support the calculation of an urban water use objective (CWC 10609. (b)(2) (C)). The urban water use objective (UWUO) is an estimate of aggregate efficient water use for the previous year based on adopted water use efficiency standards and local service area characteristics for that year. UWUO is calculated as the sum of efficient indoor residential water use, efficient outdoor residential water use, efficient outdoor irrigation of landscape areas with dedicated irrigation meter for Commercial, Industrial, and Institutional (CII) water use, efficient water losses, and an estimated water use in accordance with variances, as appropriate. Details of urban water use objective calculations can be obtained from DWR’s Recommendations for Guidelines and Methodologies document (Recommendations for Guidelines and Methodologies for Calculating Urban Water Use Objective - https://water.ca.gov/-/media/DWR-Website/Web-Pages/Programs/Water-Use-And-Efficiency/2018-Water-Conservation-Legislation/Performance-Measures/UWUO_GM_WUES-DWR-2021-01B_COMPLETE.pdf). The datasets provided in the links below enable urban retail water suppliers calculate efficient outdoor water uses (both residential and CII), agricultural variances, variances for significant uses of water for dust control for horse corals, and temporary provisions for water use for existing pools (as stated in Water Boards’ draft regulation). DWR will provide technical assistance for estimating the remaining UWUO components, as needed. Data for calculating outdoor water uses include: • Reference evapotranspiration (ETo) – ETo is evaporation plant and soil surface plus transpiration through the leaves of standardized grass surfaces over which weather stations stand. Standardization of the surfaces is required because evapotranspiration (ET) depends on combinations of several factors, making it impractical to take measurements under all sets of conditions. Plant factors, known as crop coefficients (Kc) or landscape coefficients (KL), are used to convert ETo to actual water use by specific crop/plant. The ETo data that DWR provides to urban retail water suppliers for urban water use objective calculation purposes is derived from the California Irrigation Management Information System (CIMIS) program (https://cimis.water.ca.gov/). CIMIS is a network of over 150 automated weather stations throughout the state that measure weather data that are used to estimate ETo. CIMIS also provides daily maps of ETo at 2-km grid using the Spatial CIMIS modeling approach that couples satellite data with point measurements. The ETo data provided below for each urban retail water supplier is an area weighted average value from the Spatial CIMIS ETo. • Effective precipitation (Peff) - Peff is the portion of total precipitation which becomes available for plant growth. Peff is affected by soil type, slope, land cover type, and intensity and duration of rainfall. DWR is using a soil water balance model, known as Cal-SIMETAW, to estimate daily Peff at 4-km grid and an area weighted average value is calculated at the service area level. Cal-SIMETAW is a model that was developed by UC Davis and DWR and it is widely used to quantify agricultural, and to some extent urban, water uses for the publication of DWR’s Water Plan Update. Peff from Cal-SIMETAW is capped at 25% of total precipitation to account for potential uncertainties in its estimation. Daily Peff at each grid point is aggregated to produce weighted average annual or seasonal Peff at the service area level. The total precipitation that Cal-SIMETAW uses to estimate Peff comes from the Parameter-elevation Relationships on Independent Slopes Model (PRISM), which is a climate mapping model developed by the PRISM Climate Group at Oregon State University. • Residential Landscape Area Measurement (LAM) – The 2018

Excel Application Tool for Agricultural Water Use Data 2011 - 2015 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2011 – 2015 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using Cal_simetaw model for updating the information in the California Water Plan Updates-2018. Therefore, this current Excel application tool just covers agricultural water use data from the period of 2011-2015 water years. It should also be mentioned that there are 2 other similar Excel applications that cover 1998 - 2005 and 2006 - 2010 agricultural water use data for the California Water plan Updates 2003/2009 and 2013, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2011 – 2015 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), the next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the DAU or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation, maximum and minimum air

Excel Application Tool for Agricultural Water Use Data 2006 - 2010 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2006 – 2010 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using California Ag Water Use model for updating the information in the California Water Plan Updates-2013. Therefore, this current Excel application just covers agricultural water use data from the period of 2006 -2010 water years. It should also be mentioned that there are 2 other similar Excel application tools that cover 1998 - 2005 and 2011 - 2015 agricultural water use data for the California Water plan Updates - 2003/2009 and 2018, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2006 – 2010 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), The next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation, maximum and

Excel Application Tool for Agricultural Water Use Data 1998 - 2005 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 1998 – 2005 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using California Ag Water Use model for updating the information in the California Water Plan Updates-2003 & 2009. Therefore, this current Excel application tool just covers agricultural water use data from the period of 1998 - 2005 water years. It should also be mentioned that there are 2 other similar Excel application tools that cover 2006 - 2010 and 2011 - 2015 agricultural water use data for the California Water plan Updates - 2013 and 2018, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 1998 – 2005 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets were included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), The next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation,

Excel Application Tool for Agricultural Water Use Data 2011 - 2015 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2011 – 2015 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using Cal_simetaw model for updating the information in the California Water Plan Updates-2018. Therefore, this current Excel application tool just covers agricultural water use data from the period of 2011-2015 water years. It should also be mentioned that there are 2 other similar Excel applications that cover 1998 - 2005 and 2006 - 2010 agricultural water use data for the California Water plan Updates 2003/2009 and 2013, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2011 – 2015 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), the next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the DAU or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation, maximum and minimum air

Excel Application Tool for Agricultural Water Use Data 2011 - 2015 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2011 – 2015 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using Cal_simetaw model for updating the information in the California Water Plan Updates-2018. Therefore, this current Excel application tool just covers agricultural water use data from the period of 2011-2015 water years. It should also be mentioned that there are 2 other similar Excel applications that cover 1998 - 2005 and 2006 - 2010 agricultural water use data for the California Water plan Updates 2003/2009 and 2013, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2011 – 2015 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), the next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the DAU or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation, maximum and minimum air

Descriptions Excel Application Tool for Statewide Agricultural Water Use Data 2016 - 2020 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2016 – 2020 statewide agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using Cal_simetaw model for updating the information in the California Water Plan Updates-2023. Therefore, this current Excel application tool just covers agricultural water use data from the period of 2016 - 2020 water years. It should also be mentioned that there are 3 other similar Excel applications that cover 1998 - 2005 and 2006 – 2010, & 2011 - 2015 agricultural water use data for the California Water plan Updates 2005/2009, 2013, and 2018 respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2016 – 2020 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), The next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3- Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. Please note that there are no double cropping acreages for 2017. Because on a normal year when Regional Offices (RO) receive data from Land IQ, they were able to provide double cropping acreages. Since the 2017 land use data was derived from average crop acres between water years 2016 and 2018,2019, & 2020, they lost spatial and temporal data necessary to calculate double cropping. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the

Excel Application Tool for Agricultural Water Use Data 2006 - 2010 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2006 – 2010 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using California Ag Water Use model for updating the information in the California Water Plan Updates-2013. Therefore, this current Excel application just covers agricultural water use data from the period of 2006 -2010 water years. It should also be mentioned that there are 2 other similar Excel application tools that cover 1998 - 2005 and 2011 - 2015 agricultural water use data for the California Water plan Updates - 2003/2009 and 2018, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2006 – 2010 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), The next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation, maximum and

Excel Application Tool for Agricultural Water Use Data 2006 - 2010 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2006 – 2010 agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using California Ag Water Use model for updating the information in the California Water Plan Updates-2013. Therefore, this current Excel application just covers agricultural water use data from the period of 2006 -2010 water years. It should also be mentioned that there are 2 other similar Excel application tools that cover 1998 - 2005 and 2011 - 2015 agricultural water use data for the California Water plan Updates - 2003/2009 and 2018, respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2006 – 2010 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), The next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3. Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the evapotranspiration of a 10-15 cm tall cool season grass and not lacking for water. The daily Standardized Reference Evapotranspiration for short canopies is calculated using the Penman-Monteith (PM) equation (Monteith, 1965) as presented in the United Nations FAO Irrigation and Drainage Paper (FAO 56) by Allen et al. (1988). 6. Penman-Monteith Equation (PM) Equation is used to estimate ETo when daily solar radiation, maximum and

Descriptions Excel Application Tool for Statewide Agricultural Water Use Data 2016 - 2020 Department of water resources, Water Use Efficiency Branch, Water Use Unit program, has developed an Excel application tool, which calculates annual estimates of irrigated crop area (ICA), crop evapotranspiration (ETc), effective precipitation (Ep), evapotranspiration of applied water (ETaw), consumed fraction (CF), and applied water (AW) for 20 crop categories by combinations of detailed analysis unit and county (DAUCo) over California. The 2016 – 2020 statewide agricultural water use data were developed by all 4 DWR’s Regional Offices (Northern Region Office, North Central Region Office, South Central Region Office, and Southern Region Office) using Cal_simetaw model for updating the information in the California Water Plan Updates-2023. Therefore, this current Excel application tool just covers agricultural water use data from the period of 2016 - 2020 water years. It should also be mentioned that there are 3 other similar Excel applications that cover 1998 - 2005 and 2006 – 2010, & 2011 - 2015 agricultural water use data for the California Water plan Updates 2005/2009, 2013, and 2018 respectively. Outputs data provided from this Excel application include ICA in acres, EP, both in unit values (Acre feet per acre) & volume (acre feet), ETc both in unit values (acre feet per acre), & volume (acre feet), ETaw, both in unit value (acre feet per acre), & volume (acre feet), AW, both in unit value (acre feet per acre) & volume (acre feet), CF (in percentage %) for WYs 2016 – 2020 at Detailed Analysis Unit by County (DAUCO), Detailed Analysis Unit (DAU), County, Planning Area (PA), Hydrological Region (HR), and Statewide spatial scales using the dropdown menu. Furthermore, throughout the whole process numerous computations and aggregation equations in various worksheets are included in this Excel application. And for obvious reasons all worksheets in this Excel application are hidden and password protected. So, accidentally they won’t be tampered with or changed/revised. Following are definitions of terminology and listing of 20 crop categories used in this Excel application. 1. Study Area Maps The California Department of Water Resources (DWR) subdivided California into study areas for planning purposes. The largest study areas are the ten hydrologic regions (HR), The next level of delineation is the planning area (PAS), which are composed of multiple detailed analysis units (DAU). The DAUs are often split by county boundaries, so the smallest study areas used by DWR is DAU/County. Many planning studies begin at the Dau or PA level, and the results are aggregated into hydrologic regions for presentation. 2. Irrigated Crop Area (ICA) in acres The total amount of land irrigated for the purpose of growing a crop (includes multi-cropping acres) 3- Multi-cropping (MC) in acres A section of land that has more than one crop grown on it in a year, this included one crop being planted more than once in a season in the same field. Please note that there are no double cropping acreages for 2017. Because on a normal year when Regional Offices (RO) receive data from Land IQ, they were able to provide double cropping acreages. Since the 2017 land use data was derived from average crop acres between water years 2016 and 2018,2019, & 2020, they lost spatial and temporal data necessary to calculate double cropping. 4. Evapotranspiration (ET) Combination of soil evaporation and transpiration is referred to as evapotranspiration or ET. The rate of evapotranspiration from the plant-soil environment is primarily dependent on the energy available from solar radiation but is also dependent on relative humidity, temperature, cloud cover, and wind speed. It is an indication for how much your crops, lawn, garden, and trees need for healthy growth and productivity. 5. Reference Evapotranspiration (ETo) Reference evapotranspiration (ETo) is an estimate of the