Texas LoanSTAR Program Savings Calculation Workbook

Abstract

This is the report and manual for the Texas LoanSTAR Program Savings Calculation Workbook. The purpose of this report is to document the Texas LoanSTAR Program Savings Calculation Workbook to be used by the State Energy Conservation Office (SECO). The workbook may be used to track the historical energy and dollar savings as of August 2002, and to project the future LoanSTAR program savings including: measured retrofit savings, Continuous Commissioning (CC) savings, estimated retrofit savings, emission reductions, and state agencies savings. In addition, an example of how to use this worksheet also is presented. The workbook includes twelve worksheets that have been developed to preserve the program savings data from 1990 to August 2002, and to forecast the LoanSTAR program savings beginning on September 2002. The workbook comprises: a) three output worksheets, b) four information worksheets, and c) five supporting worksheets. Three graphs are provided in the workbook: cumulative savings, measured retrofit savings and yearly savings graphs. All the spreadsheets and graphs are updated automatically through built-in programs. This workbook was developed by the Energy Systems Laboratory of Texas A&M University Systems in MS Excel.