Spreadsheet: 188657d1350946304-excel-removes-all-data-validation-lists-at-the-opening-of-the-workbook-quotation_parkregis_hotel-master
Sheet: Model_OT_BO

Site Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Business Details |  |  |  |  |  |  |  | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details | Area Details |  |  |  |  | Area 01
 |  | Business Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supply&Install Cost (Before and After Discont) | [NAME] | PV of Investment (Over 5 Years)
 |  | Installation Address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #VEECS CREATED
 |  | Post Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supply & Install Cost (Before VEEC Rebate) |  | 0 | 0
 |  | Suburb |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue generated from certificates |  |  | 0
 | Contact Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supply & Install Cost (After [NAME]) |  | 0
 |  | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Present Value of Investment over 5 years
 |  | Phone |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Back Period (Months) |  |  | 0
Job Details
 |  | Incumbent Lamp Type
 |  | Upgrade Lamp Type
 |  | Quantity
Energy Savings
 |  | Baseline Details
 |  |  | Lamp Circuit Power
 |  |  |  | NLP
 |  |  |  | Multiplier
 |  |  |  | Add
 |  |  |  | LCP (Watts)
 |  |  | Asset Lifetime (Years)
 |  |  | Control Multiplier |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  | Air Conditioning Multiplier
 |  |  | Energy Consumption One Lamp
 |  | Total Baseline Energy Consumption
 |  | Upgrade Details
 |  |  | Lamp Circuit Power
 |  |  |  | LCP (Watts)
 |  |  | Asset Lifetime (Years)
 |  |  | Control Multiplier
 |  |  | Air Conditioning Multiplier
 |  |  | Energy Consumption One Lamp
 |  | Total Upgrade Energy Consumption
 | Total Energy Savings
 |  | Regional Factor
 |  | Abbatement Factor
#VEECS CREATED
Supply & Install Cost (Before VEEC Rebate)
 |  | Unit Supply & Install Price
Revenue generated from certificates
 |  | $Savings per Lamp
Supply & Install Cost (After [NAME])
 |  | Per Unit
 |  | Savings (%)
Real Energy Savings (Daily)
 |  | Real Energy Savings (Daily)* - Per Light
 |  |  | Real Historical Energy Consumption (W)
 |  |  | Real Upgrade Energy Consumption (W)
 |  |  | Daily Energy Saving (Consumption) (kwh)*
 | Present Value of Investment over 5 years
 |  |  |  | Total Annual Savings
 |  |  |  |  | Discount Factor (Over 5 years)
Pay Back Period (Months)