Canyonsanscost.xls

Canyon WC IMPORTANT NOTE: All project information should be input on this page. Input/select information into cells that have a blue color font.

Leave cells with black or red color fonts alone. See Example "Site Audit" Sheet for examples. Use the View menu and Zoom feature to magnify this page.

To Add Rows: 1) move the curser to the number box on the left hand side of the row you want to add and left-click to highlight the row, 2) right-click in the highlighted area and choose "copy", 3) right-click again on the row number and choose "insert copied cells".

To Delete Rows: 1) move the curser to the number box on the left hand side of the row you want to add and left-click to highlight the row, 2) right-click in the highlighted area and choose "delete".

P.S. The print area on this worksheet is set so the note box does not print. The print area is set on the other worksheets as well.

&L&P&R&D, &T Add A Row Automatically copies the Existing Lamp/Ballast Combination Quantity unless user types in a changed value. For instance, type in a different value if one or more fixtures are removed or added.

Mean lamp(s) light output per existing luminaire. Does not include luminaire efficiency. Automatically draws from the Data Existing tab column D of this workbook.

Quantity of existing luminaires. User input value.

Existing watts per luminaire. Automatically draws from the Data Existing tab column C of this workbook.

These are drop-down boxes. Make a selection and it will automatically draw from the Data Existing tab column B of this workbook and populate column F, G, H, I, and J of this spreadsheet.

Estimated annual operating hours of each lighting measure (not the building). This value is user calculated and input.

Area of building, room number, location, office name, etc.. Be specific enough that someone unfamiliar with the building can easily find the room or area. You can group exact same rooms together if they have the same hours of operation and are closely located.

Must be 25% or greater in order to receive a reimbursement or credit. Font turns red if less than 25%.

Proposed watts per luminaire. Automatically drawn from the Data Proposed tab column C of this workbook.

Mean lamp(s) light output per proposed luminaire. Does not include luminaire efficiency. Automatically drawn from the Data Proposed tab column D of this workbook.

Spreadsheet automatically calculates this value. It is a per room per measure calculation.

These are drop-down boxes. Make a selection and it will automatically draw from the Data Proposed tab column B of this workbook and populate column N, O, P, and Q of this spreadsheet.

Weighted average of existing lighting system hours of operation per year.

Calculated from column Q of this worksheet. Column Q is a hidden column.

Calculated from column I of this worksheet. Column I is a hidden column.

Automatically copies the Existing Annual Operating Hours of the measure unless user types in a changed value. For instance, type in a different value if an occupancy sensor is installed.

Total Project Estimated Annual kWh savings at the site. This value is unadjusted for interactions and busbar savings. This cell sums up values in column R.

OPTIONAL: This value should be the most representative utility demand rate in dollars per kilowatt per month. You may have to average seasonal demand rates.

This cell automatically calculates the estimated dollar savings per year (12 months) associated with kW or Demand savings. This number is added to the energy savings value and put into the estimated dollar savings cell in the letter tab of this workbook.

REQUIRED: This value should be the most representative energy rate in dollars per kilowatt-hour. Usually the highest block rate in the utilities rate structure. May have to average seasonal energy rates.

This is the Reimbursement or Credit amount. Based on the total rebate amounts or 70% of project cost whichever is less. Only gives a Credit if the kWh Reduction is at least 25%.

This value is taken from the Data Proposed tab column F.

This value is the multiplication of column M and column X of this spreadsheet. It is the total reimbursement or credit per measure.

Font is RED if Wattage Reduction is NOT between 20 and 50%. The value(s) below are only related to each measure.

Font is RED if Change in Light Level is NOT between -10% and +10%. Calculates total change in light output of lamp(s) only. Ignores luminaire efficiency. Use the below value(s) to determine how close you are to the existing light level.

Per measure summary info. Use this info to check yourself.

This value is only related to the lighting kilowatt-hour reduction affected by the installation. Does not depict total building kilowatt-hour reduction percentage.

Input the project cost into the cell to the right or use the contractor bid info form to the right of this page. Includes labor and materials from the installation contractors' invoices. Also, can include in-house labor costs. Direct installation labor costs only.

This value is taken from the Data Proposed tab column E.

CAA or CRC Reimbursement or Credit per unit and total per measure Charlie Grist:

Electric Savings including estimated interactive effects of lighting and HVAC Charlie Grist:

Select building type from list. If multiple building types are present consider separate audit sheets for separate buildings. Or select the type that most closely matches the primary areas of the building where proposed lighting measures occur.

This value is used to estimate interactive effects of lighting energy savings on HVAC.

Charlie Grist:

Select dominant space heat type from list. If multiple space heat types are present, consider separate audit sheets for separate buildings. Or select the type that most closely matches the primary areas of the building where proposed lighting measures occur.

This value is used to estimate interactive effects of lighting energy savings on HVAC.

Input building for this project This value takes into account the energy interaction between the lighting system and the HVAC system.

Input street address, city, and stare. Enter enough info to locate the facility.

CAA or CRC Reimbursement or Credit per unit and total per measure This value is the multiplication of column M and column X of this spreadsheet. It is the total reimbursement or credit per measure.

Automatically pulls from cell AC35 (the contractor bid worksheet), unless user manually enters a different number.

COTR

CS#1a Lamp

CS#1b Lamp

CS#2 Ballast

CS#3a Refl Kit

CS#3b Refl Kit

CS#4 New Wrap

CS#5a CFL

CS#5b CFL

CS#6a Wallpack

CS#6b Wallpack

CS#6c Wallpack

CS#6d Spot

CS#6e Spot

CS#7 Exterior Pole

CS#8a_Occ Sen

CS#8b_Occ Sen

CS#8c_Occ Sen

CS#8d_Occ Sen

CS#8e_Occ Sen

CS#9 High Bay

CS#10a_Small Lamp fix

CS#10b_Small Lamp

CS#11_Exit

Data Existing

Data Proposed