The RTF's Standard Information Workbook (SIW) houses assumptions and data that are used across multiple measures and standard protocols. The SIW serves as a common starting point for repeatedly accessed values. 

Standard Information Workbook Version History

Upload Date

Notes

RTFStandardInformationWorkbook_5_0 03/11/2025

Approved at December 2024 RTF meeting. QA complete.

The following tab has been renamed:
- Water Heater Marginal Efficiency (previously Water Heater Recovery Efficiency)
- Marginal Refrigeration Efficiency (previously EER Values)

The following tabs have been updated and approved:
- GDP Deflator
- Discount Rate
- Retail Electricity Rates
- Water Heater Marginal Efficiency
- Incoming Water Temps
- Weighting Factors
- Marginal Refrigeration Efficiency
 

RTFStandardInformationWorkbook_5_0

9/5/2024 Approved at August 2024 RTF meeting. 

Added Conversion Factors. Updated Discount Rate, Retail Electricity Rates, Weighting Factors, Water Heater Marginal Efficiency (previously Water Heater Recovery Efficiency), and Incoming Water Temperatures. Archived Equipment Mark-ups, SF Insulation, MF Insulation, MH Insulation, SF Window, MF Window, MH Window, PTSC HPC, Air Source Heat Pump, and Lifetime Reference Table.

RTFStandardInformationWorkbook_4_8

3/24/2023

Updated GDP deflators for 2019-2033 to most recent estimates and forecasts. Removed unused links to other files.

RTFStandardInformationWorkbook_4_7

7/13/2022

Weighting Factors tab has been updated to reflect the newly adopted representative weather cities and HZ/CZ weightings 

RTFStandardInformationWorkbook_4_6

3/21/2022

Corrected GDP deflator formulas for determining the multipliers for converting to different base years 

RTFStandardInformationWorkbook_4_5

11/2/2021

Updated Prototype City Heating and Cooling Zone weightings and measure lifetime sheet to reflect current UES measures.

RTFStandardInformationWorkbook_v4_4

09/16/2021

Updated Weighting Factors sheet with new Prototype City Heating and Cooling Zone Weightings. 

RTFStandardInformationWorkbook_v4_3

07/09/2021

Measure lifetime sheet updated to reflect current UES measures

RTFStandardInformationWorkbook_v4_2

03/10/2020

Updated the GDP deflator assumptions for consistency with Council Plan analysis. 

RTFStandardInformationWorkbook_v4_1

06/03/2019

Updates approved at the March 2019 RTF Meeting. QC complete. 

Methodology Documentation for SIW

06/03/2019

During the latest update (v4.1) of cost estimates for SIW, two measures, insulation and heat pumps, required more complicated statistical modeling than Excel could conduct. For transparency, this document explains the methodology from these alternative analyses.

RTFStandardInformationWorkbook_v4_0

03/28/2019

Updates approved at the March 2019 RTF Meeting. Most tabs updated, except ASHP costs. Currently undergoing QC.

RTFStandardInformationWorkbook_v3_2 (4.5 MB Excel)

02/21/2018

Measure lifetime sheet updated to reflect current UES measures. 

RTFStandardInformationWorkbook_v3_1.xlsx

08/09/2017

Updates approved at the May 2017 RTF Meeting. QC complete. 

RTFStandardInformationWorkbook_v3_0.xlsx

07/10/2017

Updates approved at the May 2017 RTF Meeting. Awaiting completion of QC. 

RTFStandardInformaitonWorkbook_v2_6.xlsx  (6 mb Excel)

07/14/2016

Approved updates at the May 2017 RTF Meeting.

RTFStandardInformationWorkbook_v2_6 PENDING QC.xlsx(6 mb Excel)

03/17/2015

QC Complete.

Standard Information Workbook_v2.2(6 mb Excel)

07/30/2015

Updated commercial HVAC interaction factors.

Standard Information Workbook_v2.0

05/20/14

Updated GDP Deflator & Res. lighting costs; Added Wood fuel credit, Res. HVAC interaction factors, EER values, & Res. water heater recovery efficiencies.

Standard Information Workbook_v1.5

08/14/13

Updated as per QC review. Added more recent AWWA water survey results, labor markups, minor cell reference fixes, and updated lifetime reference table.

Standard Information Workbook_v1.3

06/26/13

Adopted by the RTF on 06/18/13. Includes updates and tabs for HVAC interaction fators, weightings, and updated lifetime reference table.

Standard Information Workbook_v1.0

04/16/13

First adopted version. Includes Council deflator calculation.