Visit the Energy Systems Laboratory Homepage.
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.
Description
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.Subject
Texas LoanSTAR Program Savings Calculation WorkbookState Energy Conservation Office
SECO
measured retrofit savings
Continuous Commissioning
CC
estimated retrofit savings
emission reductions
state agencies savings
MS Excel
Collections
Citation
Liu, Z.; Baltazar-Cervantes, J. C.; Haberl, J. S. (2003). Texas LoanSTAR Program Savings Calculation Workbook. Energy Systems Laboratory (http://esl.tamu.edu), Texas A&M University. Available electronically from https : / /hdl .handle .net /1969 .1 /2040.