{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Key Terms","List of Reports","Water Reports","Wastewater Reports","End User Reports"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Introduction","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,3,41,5],[27,3,27,5],[29,3,29,5],[31,3,31,5],[40,3,40,5],[39,3,39,5],[37,3,37,5],[1,3,3,3],[4,3,5,3],[7,2,19,5],[23,3,23,5],[25,3,25,5]]}
[null,null,null,null,"Last updated: ","2020-04-06"]
[null,null,null,"Water-Data"]
[]
[]
[null,null,null,"MATRIX"]
[]
[]
[null,null,"Water-Energy Nexus (WEN) Registry participants may seek verification services for the water sector performance metrics they report alongside their annual emissions inventory. Water sector performance metrics communicate the emissions intensity of water and/or wastewater deliveries for a given Reporting Year (RY). Performance metrics can be used by other reporting entities to calculate the indirect supply chain emissions associated with their acquired and/or purchased water or wastewater services. \n\nVerifier review is required before performance metrics may be publicly disclosed in the WEN Registry. Guidance for reviewing the water-related data used to calculated performance metrics can be found in the Verifying Water-Related Data Guidance document. This matrix is an additional reference tool provided to verification bodies (VBs) to assist them in completing a check that water-related data both (1) adheres to the WEN Registry Protocol reporting standards and (2), where relevant, is consistent with data reported to other programs. The matrix outlines data sets commonly reported by members of the water sector in California. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Table of Contents"]
[]
[null,null,"Key Terms","Definitions and relevant data points associated with each common water management operation. "]
[]
[null,null,"List of Reports","Provides a masterlist of all of the reports covered in this workbook, along with descriptions and links to resources. "]
[]
[null,null,"Water Reports","Matrix of reports commonly submmited by water managers and their relevant water-related data."]
[]
[null,null,"Wastewater Reports","Matrix of reports commonly submmited by wastewater managers and their relevant water-related data."]
[]
[null,null,"End User Reports","Matrix of reports commonly submmited by water users and their relevant water-related data."]
[]
[null,null,"Notes","Key questions and exceptions"]
[]
[null,null,"Icon and Color Code Key"]
[]
[null,null,null,"Click this icon to jump to the key terms tab where the you can find definitions and more information."]
[null,null,null,"Click this icon to jump back to the previous page your were on."]
[null,null,"•","Green cells marked with a solid circle indicate that a report includes data that matches with WEN Registry Protocol criteria."]
[null,null,"-","Green cells marked with dashes indicate that the report may only provide partial information and/or supplemental data."]
[null,null,"x","Red cells marked with an \"X\" indicate that the report or data does not criteria outlined in the WEN Protocol."]

{"sheet":"Key Terms","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Term","Description","Relevant Data for Reporting Agency"]
["Total Water Delivered","Total water deliveries should include all water (e.g., raw, potable, or drinking water) moved to its final point of transport by the participant in the reporting year.","Volumes of water delivered to retail customers, sales or exports to other water suppliers, environmental or groundwater recharge, or placement of water into long-term storage."]
["Total Water Supplies","Total water volume moved into a water system in a year.","Volumes of water produced (e.g., via extraction, desalination or diversion), imported, exchanged, deployed from long-term storage."]
["Extraction","Removal of source water from its natural course, such as through groundwater well pumping, surface water diversions, or ocean water intake.","Volume of pumped groundwater, diverted surface water, or ocean water intake."]
["Conveyance","Movement of source water to point of treatment or out of a system’s control.","Volume of untreated, raw water moved to a storage site, treatment facility, or another agency; distance of water conveyance."]
["Water Treatment","Treatment of potable water to necessary quality standards prior to distribution to customers. ","Volume of water treated to potable (or drinking) water quality standards; quality of water source or supply before treatment. "]
["Water Distribution","Movement of treated water to its end point or point of use in the year being reported.","Volume of potable (or drinking) water delivered to end uses; types of deliveries (e.g., industrial, commercial, landscape irrigation, residential)."]
["Replenishment/Storage","Placing water into a storage reservoir or groundwater basin; ongoing management of storage sites.","Volume of water placed into long term storage or recharged to groundwater basin; volume of total storage capacity; percent of capacity filled in the year."]
["Total Wastewater Delivered","All wastewater and/or recycled volumes moved to its final point of delivery in the year being reported.","Volumes delivered to other agencies, end-users, environmental purposes, recharged, discharged as effluent, or placed into long-term storage."]
["Total Recycled Water and/or Wastewater Supplies","Total water volume moved into the wastewater system in a year.","Volumes produced, imported, exchanged, deployed from long-term storage, of wastewater collected."]
["Wastewater Collection","Movement of raw wastewater to a treatment site.","Volume of wastewater collected; type of waterwater collection system; type of wastewater collected (e.g., domestic, industrial, agricultural)."]
["Wastewater Treatment","Treatment of wastewater to water quality standards for discharge to the environment.","Volume of wastewater treated; description of wastewater treatment stream. "]
["Recycled Water Treatment","Advanced treatment of wastewater for beneficial reuse to recycled water quality standards defined by California’s Title 22 regulation.","Volume of water treated with advanced or tertiary treatment processes; description of treatment stream. "]
["Recycled Water Distribution","Movement of recycled water to its end point or point of use in the reporting year.","Volume of water distributed via purple pipe to end uses; types of deliveries (e.g., industrial, landscape irrigation, agricultural)"]
["Discharge","Return of treated wastewater effluent to the environment.","Volume of water delivered to natural surface waters (e.g., streams, rivers, lakes, ocean); quality of water discharged."]
["Co-Product Management","Biosolids generation, treatment, dewatering, storage or delivery; biogas generation, refinement, energy production, or delivery. ","Amount (dry weight, volume, or energy content) of biosolids or biogas produced; types of co-product deliveries or end uses (e.g., land applications, on-site energy generation and consumption, vehicle fueling)."]

{"sheet":"List of Reports","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Report\nName of reports and internal documentation that can be submitted to provie water-related data to VBs","Reporting Frequency\nThe frequency at which the reports and documentation are submitted","Relevant Water Sector Entity\nThe type of agencies mandated to submit this type of report","Governing Body\nThe governing body reports are submitted to and reviewed by","Access to Data\nLinks to additional information for verification bodies (as applicable)","Note\nComments relevant to a report"]
["Urban Water Management Plans (UWMP)","5 years","Urban water suppliers (public or private, retailer or wholesaler, agencies or local governments) with over 3,000 acre-feet of water annually, or more than 3,000 urban connections","California Dept of Water Resources",{"$f":"HYPERLINK(\"https://wuedata.water.ca.gov/\",\"Public Reports\")","v":"Public Reports"},"Relevant tables in the 2015 UWMPs: \nWater: 4.1,4.2, 6.1, and 6.8\nWastewater: 4.3, 6.1, 6.2, 6.3, 6.4, and 6.5"]
["Agricultural Water Management Plans (AWMPs)","5 years","All large agricultural water suppliers providing water to more than 25,000 irrigated acres (excluding recycled water) (SB X7-7)","California Dept of Water Resources",{"$f":"HYPERLINK(\"https://wuedata.water.ca.gov/\",\"Public Reports\")","v":"Public Reports"},"-"]
["Electronic Annual Reports (eARs)","Annually","Local Government, State or Federal government, and privately-owned","California State Water Resources Control Board - Division of Drinking Water",{"$f":"HYPERLINK(\"https://data.ca.gov/dataset/drinking-water-public-water-system-annually-reported-water-production-and-delivery-information\",\"Public Data (2013-2016)\")","v":"Public Data (2013-2016)"},"-"]
["Water Production Reports","Monthly","State’s larger urban water suppliers (more than 3,000 connections: public or private, retailer or wholesaler, agencies or local governments)","California State Water Resources Control Board",{"$f":"HYPERLINK(\"https://data.ca.gov/dataset/drinking-water-public-water-system-operations-monthly-water-production-and-conservation-information\",\"Public Data\")","v":"Public Data"},"-"]
["Groundwater Sustainability Plans (GSP)","Varies","Groundwater Sustainability Agencies","California Dept of Water Resources",{"$f":"HYPERLINK(\"https://sgma.water.ca.gov/\",\"Public Reports\")","v":"Public Reports"},"-"]
["Annual Report","Annually","All public utilities doing business in California","California Public Utilities Commission",{"$f":"HYPERLINK(\"ftp://ftp.cpuc.ca.gov/WaterAnnualReports/Water%20Division/Annual%20Reports/\",\"Public Reports\")","v":"Public Reports"},"-"]
["Use or Disposal of Sewage Sludge Annual reports or permitting materials","Varies","Publicly owned treatment works with design flow rate is equal to or greater than one million gallons per day, serves 10,000 people or more, or is required to have an approved pre-treatment program.","Compliance with the U.S. Environmental Protection Agency, submitted to regional office in California.","Not publicly available","-"]
["Recycling and Disposal Reporting to CalRecycle","Quarterly and Annually","Organizations disposing of waste in landfills","California's Department of Resources Recycling and Recovery, Assembly Bill 901","Not publicly available","-"]
["Sewer System Management Plan","Annual","All federal and state agencies, municipalities, counties, districts, and other public entities with sanitary sewer systems greater than one mile in length that collect/convey untreated or partially treated wastewater to a treatment facility","California State Water Resources Control Board, Waste Discharge Requirements","Not publicly available","-"]
["Water Questionnaire","Annual","Organizations, local and state govenments of any geographic region","Carbon Disclosure Project (CDP)",{"$f":"HYPERLINK(\"https://www.cdp.net/en/water#a8888e63070314c2285625253a462815\",\"Public Responses\")","v":"Public Responses"},"-"]
["GRI 303: Water & Effluents","Annual","Organization of any size, type, sector or geographic location","Global Reporting Standards (GRI)",{"$f":"HYPERLINK(\"https://database.globalreporting.org/search/\",\"Public Reports\")","v":"Public Reports"},"-"]
["Invoices","Varies","All","Internal Governing Body","-","-"]

{"sheet":"Water Reports","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Report","Total Water Delivered","Total Water Supplies","Extraction","Conveyance","Water Treatment","Water Distribution","Replenishment/ Storage"]
["Urban Water Management Plans (UWMP)","-\nselect cell for details","•","•","-\nselect cell for details","•","•","•"]
["Agricultural Water Management Plans (AWMPs)","-","•","•","-\nselect cell for details","x","•","•"]
["Electronic Annual Reports (eARs)","-\nselect cell for details","-\nselect cell for details","•","-\nselect cell for details","•","x","x"]
["Water Production Reports (monthly)","-\nselect cell for details","-\nselect cell for details","•","x","x","-\nselect cell for details","x"]
["Groundwater Sustainability Plans (GSP)","x","-\nselect cell for details","•","x","x","x","•"]
["Annual Report","-\nselect cell for details","x","x","x","x","x","x"]
["Annual reports, water master plans, or other documents signed, published, or approved by a General Manager, Executive Team, or governing board","-","-","-","-","-","-","-"]
["Invoices","-","-","-","-","-","-","-"]

{"sheet":"Wastewater Reports","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Report","Total Wastewater Delivered","Recycled Water and/or Wastewater Supplies","Wastewater Collection","Wastewater Treatment","Recycled Water Treatment","Recycled Water \nDistribution","Wastewater Discharge","Co-Product Management"]
["Urban Water Management Plans (UWMP)","-\nselect cell for details","•","•","•","•","•","•","x"]
["Electronic Annual Reports (eARs)","x","x","x","x","x","•","x","x"]
["Use or Disposal of Sewage Sludge Annual reports or permitting materials","x","x","x","x","x","x","x","•"]
["Agricultural Water Management Plans (AWMPs)","x","-\nselect cell for details","x","•","x","•","•","x"]
["Recycling and Disposal Reporting to CalRecycle","x","x","x","x","x","x","x","-\nselect cell for details"]
["Sewer System Management Plan","x","x","•","x","x","x","x","x"]
["Annual Report","x","x","x","x","x","x","x","x"]
["Annual reports, water master plans, or other documents signed, published, or approved by a General Manager, Executive Team, or governing board","-","-","-","-","-","-","-","-"]
["Invoices","-","-","-","-","-","-","-","-"]

{"sheet":"End User Reports","index":5,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Report","Annual Water Use","Total Water Consumption","Total Water Discharge","Total Water Recycled On-site"]
["Water Questionnaire","•","•","•","•"]
["GRI 303: Water & Effluents","•","•","•","x"]