Using PTR: Lighting

Utility Brown Bag SessionSeptember 15, 2006

2

Steps to report each lighting projectUsing the PTR system

Go to PTR web site and download calculator Save calculator to your computer. Take care naming each project

as a separate file. For example: LC-JonsPetShop-06-v1.xls Perform calculations & fill out site audit page Don’t forget, save calculator as a separate file (as named above) After final inspection of project:

go into calculator for true-up, re-save final version of file, then upload calculator into project shopping cart

Finally, create invoice to claim funds

3

PTR Web Site – Step 1 of 4

Click on the “Commercial”

link at left

4

PTR Web Site – Step 2 of 4

Select “Retrofit” from the New and Retrofit

Lighting Projects drop-down box

5

PTR Web Site – Step 3 of 4

Click on the “Lamp & Ballast”

link

6

PTR Web Site – Step 4 of 4

Click on the “Standard Offer Lighting

Spreadsheet Tool” link

7

Version 1.4 9/7/2006

Main Warehouse

97058

NW Public Power A-12456Line No.

1 20,864 sf

2 -$1,274.37

3 Other Commercial

4 Heat Pump

5 57,678 Watts

6 29,789 Watts

7 307,282 kWh

8 $39,000.00

9 -$12,743.72

10 4,000 hours

11

12 12 years

13 11,018 hours

14 102%

15 313,428 kWh

16 337,326 kWh

17 48%

18 $0.063 /kWh

19 $19,589

20 2.0 years

21 15 kWh

22 1.34 Watts/sf

23 $0.462

24 $155,926

25 $52,393

26 $0.0000

27 -$11,960

28 $0

29 -$12,744

30 -$24,704

31 $66,690

32 4.6

33 $13,472

Oregon

Building>123 West Main StreetFacility Street Address>

Facility City, State, Zip> LaGrande

Total BPA Credit/ Reimbursement

Note: All user supplied input assumptions must be documented through a measurement and verification plan. If the project results in an projected BPA credit/reimbursement of $30,000 or larger, then BPA must accept this measurement and verification plan prior to

project implementation.

Total Proposed Watts of Area Affected by Retrofit

Simple Payback

Unit Value of Gas Heat Interaction (NPV/kWh saved)

Project Life Cycle Cost

Project Benefit/Cost Ratio

Present Value Project/Measure Change in O&M Cost (Savings -$ or Increases +$)

Present Value of Energy Costs

Present Value Life Cycle Lamp Replacement Cost (Savings -$ or Increases +$)

Project-Level Commercial Lighting Retrofit Calculator

This worksheet calculates the annual energy savings and Conservation Rate Credit or Conservation Acquisition Agreement reimbursement resulting from the installation of an energy efficient retrofit lighting, and the project-level economics including savings after HVAC interaction, busbar savings, O&M costs or savings, and periodic lamp replacement costs or savings, PV Life Cycle Cost and TRC B/C ratio.

No data on this sheet may be edited. Enter all data on the Site Audit tab. Inputs here reflect data entered on that tab. Results are shown on lines 12 - 33. Enter data shown below in red into related fields on the Commercial Lighting Retrofits Add-to-Cart page on the PTR site.

INPUTS FROM SITE AUDIT TAB

Total Estimated Annual kWh Site Savings (unadjusted)

Dominant Building Type

Primary Space Heat Fuel Source

Total Floor Area Affected by Project (# of fixtures x 64 sqft/fixture)

Utility Invoice # & Name 20051103 Account #

Present Value of Change in Gas Heating Cost (Savings -$ or Increases +$)

Unit Value of Electric Savings (NPV/kWh)

Annual Energy Cost Savings

Site Lighting Power Density (lpd) Reduction (W/sf)

Present Value of Change in Cleaning/Other O&M Cost (Savings -$ or Increases +$)

Site Unit Energy Savings (kWh/sf)

Present Value Energy Savings

Total Existing Watts of Area Affected by Retrofit

Customer Retail Rate

Measure Life

Default Hours of Lighting Operation for Building Type

Wattage Reduction (%)

RESULTS FOR ADDING PROJECT TO CART

Lighting Savings Yield (HVAC Interaction Adjustment for Building & Space Heat Type)

Annual Site Energy Savings Adjusted for HVAC Interaction (kWh)

Annual Busbar Energy Savings Adjusted for HVAC Interaction (kWh)

Calculator Last Revised> 6/2/2006

Project & Facility Name>

Inferred Weighted Average Hours of Operation (kWh saved/ kW saved)

Todays Date>>>

Project-Level Net PV of Periodic Lamp Replacement Cost (Savings -$ or Increases +$)

Lighting Measure Examples Warehouser, Inc.

Project Cost

Project/Measure Change in Cleaning/Other O&M Cost (Savings -$ or Increases +$)

8