Supporting Files History: RACC-FSC_v3

File Start Date End Date Date posted Notes
20211121_RACC_Addendum_v1.pdf 2021 Nov 21 2021 Nov 21

Note: While the version of the calculator (titled 2021 ACC Refrigerant Calculator v1b.xlsx) that is referenced in footnote 1 on page 1 of this addendum is the official calculator referenced in the Decision, the one that must be submitted with relevant deemed measure package submissions and custom measure applications is available at Deemed Measure RACC Workbook v1.3-Rev4.

2021_ACC_Refrigerant_Calculator_v1b.xlsx 2021 Jan 1 2021 Dec 31 2020 Dec 31

This is the version of the 2021 ACC Refrigerant Calculator v1b.xlsx that was referenced in the Decision and available here; it is quite different from--and should not be confused with--the calculator that must be submitted with deemed measure package submittals and custom measure applications.

Deemed_Measure_RACC_Workbook_v2.2.xlsx 2023 Aug 25 2023 Aug 25 Per Section 1.1.2 (B.2) Refrigerant Impacts (RACC) of Resolution E-5221, the CPUC's Refrigerant Avoided Cost Calculator (RACC) methodology is to be used to calculate the refrigerant emissions and their costs for measure packages where the retrofit involves adding (not replacing) equipment that uses refrigerant--these include fuel substitution and electric resistance to heat pump measures--or where low-GWP measure benefits will be claimed. Since the RACC was updated September 15, 2022, the Deemed Measure RACC Workbook had to be updated to be consistent with the revised methodology to handle the end-of-life emissions for accelerated replacement MAT, etc. This workbook incorporates these updates.
Deemed_Measure_RACC_workbook_v1.3-Rev4.xlsx 2021 Nov 17 2023 Aug 24 2021 Nov 22

This is the refrigerant leakage avoided cost calculator that must be submitted with all deemed measure package submissions and custom measure applications involving equipment that contains refrigerant.

RACC-FSC_v3.0.xlsx 2024 Apr 22 2024 Apr 19

The RACC-FSC_v3.0 shall be used to calculate refrigerant leakage emissions and avoided costs of net refrigerant leakage emissions and perform fuel substitution tests for all measures that involve adding or replacing equipment that uses refrigerant and involves a change to the refrigerant type or to the refrigerant charge —these include most fuel substitution and electric resistance to heat pump measures. The completed RACC-FSC_v3.0—containing the relevant parameters associated with a given measure package—shall be provided as an addendum to each affected measure package in the eTRM. Guidance for how to do so is described in the “RACC-FSC Technical Guidance Document” that was issued along with the RACC-FSC_v3.0 workbook. 

Measure Package Update Type

ACC Version

New offering(s) added to existing approved measure package for PY2024-2025

ACC2022 values shall be used in RACC-FSC for new offering permutations, only

Mid-cycle updates to existing approved measure packages for PY2025

ACC2022 values shall be used for all permutations

Measure package updates for PY2026

ACC2024* values shall be used for all permutations

New measure packages for PY2026

*As of the issuance of the RACC-FSC_v3, the 2024 ACCs have not been finalized.

See Appendix C of the Technical Guidance document for instructions on how to connect the RACC-FSC_v3 to the DEER database when opening the RACC-FSC_v3 for the first time and prompted with the ODBC driver login credential prompt. NOTE: The link provided in the RACC-FSC_v3 to download the PostgreSQL driver for ODBC connections to the DEER database from within Excel no longer works. For users who have already installed the driver, this does not matter. For users needing to install the driver, download and install the version 10.23 file that is most appropriate for your computer from: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.

RACC-FSC_v3.1.xlsx 2025 Jan 1 2024 Nov 1

Modifications were made to enable distinguishing between updated EUL values and those previously in use.

No.

Modification

1

Eliminated the word "Viable" from two fieldnames in DEER's TechType table.

2

In TechType table, updated fieldname "HasElecAlt" to "HasElectricAlt" to align with DEER database.

3

Corrected formulas that were not working as intended on Intro worksheet in DEER Status Table.

4

Provided conditional formatting on 1 Device Builder worksheet to make it evident when formulas are replaced with values.

5

Synchronized workbook with DEER tables in DEER database.

6

Added "StartDate" and "ExpiryDate" fields on 1 Device Builder worksheet to manage updated EUL values at Device_Builds table and EUL_Basis pivot table (aligns with EUL_basis table in DEER).

7

Replicated rows involving technology types with revised EUL values on 1 Device Builder worksheet to enable selecting "TechType (NormUnit)" appropriate to measure installation year.

The RACC-FSC_v3 shall be used to calculate refrigerant leakage emissions and avoided costs of net refrigerant leakage emissions and perform fuel substitution tests for all measures that involve adding or replacing equipment that uses refrigerant and involves a change to the refrigerant type or to the refrigerant charge —these include most fuel substitution and electric resistance to heat pump measures. The completed RACC-FSC_v3.0—containing the relevant parameters associated with a given measure package—shall be provided as an addendum to each affected measure package in the eTRM. Guidance for how to do so is described in the “RACC-FSC Technical Guidance Document” that was issued along with the RACC-FSC_v3.0 workbook. 

Measure Package Update Type

ACC Version

New offering(s) added to existing approved measure package for PY2024-2025

ACC2022 values shall be used in RACC-FSC for new offering permutations, only

Mid-cycle updates to existing approved measure packages for PY2025

ACC2022 values shall be used for all permutations

Measure package updates for PY2026

ACC2024* values shall be used for all permutations

New measure packages for PY2026

*As of the issuance of the RACC-FSC_v3.1, the 2024 ACCs have not been finalized.

NOTE: For users without the PostgreSQL driver to enable ODBC connections to the DEER database from within Excel, download and install the version 10.23 file that is most appropriate for your computer from: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.