Energy Systems Laboratory (http://esl.tamu.edu), Texas A&M University
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); to track the historical savings data 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 agency savings. This report presents the description of the Texas LoanSTAR Program Savings Calculation Workbook. In addition, examples of how to use it are also presented. In Section 2, an overview of the LoanSTAR Savings Calculation Workbook is presented. Next, a description of each worksheet is presented. Section 3 discusses the procedures for using the worksheets to update savings and adding new loan sites savings. An example of how to use the spreadsheet is given and some sample reports are provided in the attachment.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
