Welcome to the State Water Resources Control Board Welcome to the California Environmental Protection Agency
Governor's Website Visit the Water Board Members Page
Agendas
My Water Quality
Performance Report
California Integrated Water Quality System Project (CIWQS)

California Integrated Water Quality System Project (CIWQS)

PET Tool / CIWQS Data Format

PET Tool

  • Introduction
    The PET Tool is a Microsoft Excel file that allows you to configure your data into a format that CIWQS will understand and interpret correctly, which is the CIWQS Data Format, or CDF. You can open the PET Tool in Excel, configure it on the basis of your permit requirements, and then use the configured file as a template for entering monitoring data on a monthly basis.
    Important Note:
    The Tools require that macros be enabled.

As demonstrated by the diagram above, work on the PET Tool happens outside of eSMR. When a file has been prepared for a report, use the button on the General Tab to automatically create a zip file. The zip file should then be uploaded to the EDF/CDF tab of an eSMR report.

To update your current template to the new version:

  1. Open the blank PET v3.x by clicking on the link above
  2. Open your existing template and click on the Data Entry tab
  3. Copy your existing template by highlighting cell A2 through the last cell of your data set
  4. While holding down the Control key on your keyboard press the “C” key
  5. Click cell A2 of the blank PET v3.x worksheet
  6. While holding down the Control key on your keyboard press the “V” key
  7. Click “ok” to the series of dialogue boxes that appear
  8. Save the updated template to your computer

If you need assistance with updating your template please email us your existing template.

Priority Pollutant Template

CIWQS Data Format (CDF)

If you are currently using a Laboratory Information Management System (LIMS) to manage your lab data you maybe able to set up your LIMS to export a file that CIWQS will understand and interpret correctly.

CDF setup guide