Colorado Greenhouse Gas Reporting Program Workbooks

The Colorado Department of Public Health and Environment (CDPHE) is seeking a contractor to develop Excel workbooks that will support the Colorado Climate Change Program's (CCP) Greenhouse Gas Reporting Program (GHGRP). The contractor will be responsible for creating workbooks that can replace the EPA's electronic Greenhouse Gas Reporting Tool (e-GGRT) and provide calculation support and data reporting elements in line with 40 CFR Part 98. The workbooks will need to capture all data elements specified in each subpart's "Data reporting requirements" section and provide calculation support for all equations. The contractor will also need to incorporate standardized summary tabs to aid APCD in data processing efforts. Some key aspects of the project include: • Developing a plan for building out the Subpart C solution and obtaining APCD approval before commencing work on the workbooks • Creating draft Excel workbook solutions for each subpart and obtaining APCD approval before finalizing the solutions • Incorporating features to aid reporters in providing accurate and verifiable information, such as conditional formatting and lookups • Complying with obtaining APCD approval of the proposed plan and draft workbooks • Submitting all deliverables due under the agreement to the APCD Project Manager electronically