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

General Parameters
 | Revenues generated per certificate ($) |  |  |  |  | 20
 | Energy Prices ($ / W) |  |  |  |  | 0.3
 | Daily light-on usage (Hours) |  |  |  |  | 10
 | Total Number of days in a year (Business Days) |  |  |  |  | 250
 | Discount Rate for PV |  |  |  |  | 0.06
Marginal Greenhouse Gaz Intensity Factor |  |  |  |  |  | 0.963
Regional Factor
 |  |  |  |  | Area | Multiplier
 |  |  |  |  | Regional | 1.04
 |  |  |  |  | Metro | 0.98
Applications
 |  |  |  |  | Area | Min [NAME]
 |  |  |  |  | Surgery / Detailed Work | 500
 |  |  |  |  | Office | 360
 |  |  |  |  | Retail | 300
 |  |  |  |  | Hotel, Bar, Coffee Shop | 200
 |  |  |  |  | Hall Way,Toilets | 160
 |  |  |  |  | Warehouse
[NAME] |  |  |  |  | Height
 |  |  |  |  | <3
 |  |  |  |  | 3-4
 |  |  |  |  | >4
Lamp Categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upgrade Control Device Table
 |  |  |  |  | Existing Lamp Type | NLP | T8 |  |  | Halogen | High Bay | Emerging Technology | Control_Device_List | Multiplier |  | Product List | Type of Device | Multiplier
 |  |  |  |  | T8_Fluro | 36 | T8 or T12 linear fluorescent or circular fluorescent with an associated magnetic ballast |  |  | Tungsten incandescent or halogen (mains voltage) | Metal halide with magnetic ballast (reactor type) | Refer to Approved ESC product list | No Controller | 1 |  | No Controller | No Controller
 |  |  |  |  | Halogen | 37 | T8 or T12 linear fluorescent or circular fluorescent with an associated electronic ballast |  |  | Tungsten incandescent or halogen (extra low voltage) with magnetic transformer | Metal halide with magnetic ballast (constant wattage type) |  | Occupancy sensor | 0.7 |  | Leading Edge Dimmer | Manual dimmer
 |  |  |  |  | High_Bay | 400 | T8 or T12 linear fluorescent or circular fluorescent (Unknown Ballast) |  |  | Tungsten incandescent or halogen (extra low voltage) with electronic transformer | Metal halide with electronic ballast |  | Daylight-linked control | 0.7 |  | Trailing Edge Dimmer | Manual dimmer
 |  |  |  |  |  |  |  |  |  |  | [NAME] (unknown ballast) |  | Programmable Dimmer | 0.85 |  | Universal Dimmer | Manual dimmer
 |  |  |  |  |  |  |  |  |  |  | Mercury vapour with magnetic ballast |  | Manual dimmer | 0.9 |  | Sensor | Occupancy sensor
 |  |  |  |  |  |  |  |  |  |  | High pressure sodium (HPS) with magnetic ballast |  | Voltage Reduction Unit | Manual |  | CBUS | Occupancy sensor
 |  |  |  |  |  |  |  |  |  |  |  |  | Not Known* | 0.6 |  | Dynalite | Occupancy sensor
 |  |  |  |  |  |  |  |  |  |  |  |  | * Take worst case scenario |  |  | Not Known | Not Known*
Upgrade Product Parameters
 |  |  |  |  |  |  | Lamp_Offer | Lamp_Type
 |  |  |  |  |  |  | Ecobulb 15W [NAME] (Non Dimmable) | CFL
 |  |  |  |  |  |  | Ecobulb 15W [NAME] (Dimmable) | CFL
 |  |  |  |  |  |  | EP 6W LED GU10 -Downlight (Non Dimmable) | CFL
 |  |  |  |  |  |  | LED4Life 6W GU10 - Downlight (Dimmable) | CFL
 |  |  |  |  |  |  | LED4Life 9W GU10 - Downlight (Dimmable) | CFL
 |  |  |  |  |  |  | Philips LED 10W MR16 - Downlight (Dimmable) | CFL
 |  |  |  |  |  |  | Centraurus 6W LED MR16 - (Dimmable) | CFL
 |  |  |  |  |  |  | [NAME] LED MR16 - (Dimmable) | CFL
 |  |  |  |  |  |  | ALPHA 12W Fuxture Downlight -  (Dimmable) | CFL
 |  |  |  |  |  |  | [NAME] 25W T5 Adaptor & Tube | T5_Fluro
 |  |  |  |  |  |  | CER 28W T5 Adaptor & Tube
 |  |  |  |  |  |  | SS 14W LED Tube | Emerging Tech
 |  |  |  |  |  |  | SS 20W LED Tube | Emerging Tech
 |  |  |  |  |  |  | LED4Life 20W LED Tube
 |  |  |  |  |  |  | Voxon 150W LED High Bay | Emerging Tech
 |  |  |  |  |  |  | Upgrade Lookup Table
 |  |  |  |  |  |  | T8_Fluro | T5_Fluro
 |  |  |  |  |  |  | T5_Fluro | No Upgrade
 |  |  |  |  |  |  | CFL | No Upgrade
 |  |  |  |  |  |  | Halogen | CFL
 |  |  |  |  |  |  | High_Bay | Emerging Tech
 |  |  |  |  |  |  | Emerging Tech | No Upgrade
Lamp Circuit Power Parameters - Incumbent & Upgrade Lamps
 |  |  |  |  |  |  |  | Incumbent Lamps |  | [NAME]
 |  |  |  |  |  | Lamp Type | Lamp Description | Multiply | Add | Multiply | Add | Real Energy Consumption (W)
 |  |  |  |  |  | T8_Fluro | T8 or T12 linear fluorescent or circular fluorescent with an associated magnetic ballast | 1 | 10 | 1 | 10 | 36
 |  |  |  |  |  | T8_Fluro | T8 or T12 linear fluorescent or circular fluorescent with an associated electronic ballast | 1 | 2 | 1 | 2 | 36
 |  |  |  |  |  | T8_Fluro | T8 or T12 linear fluorescent or circular fluorescent (Unknown Ballast) | 1 | 5.777777777777778 | 1 | 5.777777777777778 | 36
 |  |  |  |  |  | Halogen | Tungsten incandescent or halogen (mains voltage) | 0.7 | 0 | 1 | 1 | 50
 |  |  |  |  |  | Halogen | Tungsten incandescent or halogen (extra low voltage) with magnetic transformer |  | 0 |  | 0 | 60
 |  |  |  |  |  | Halogen | Tungsten incandescent or halogen (extra low voltage) with electronic transformer |  | 0 |  | 0 | 60
 |  |  |  |  |  | High_Bay | Metal halide with magnetic ballast (reactor type) | 1.0456 | 14 | 1.0456 | 14 | 400
 |  |  |  |  |  | High_Bay | Metal halide with magnetic ballast (constant wattage type) | 1.071 | 22 | 1.071 | 22 | 400
 |  |  |  |  |  | High_Bay | Metal halide with electronic ballast | 1.096 | 0.9 | 1.096 | 0.9 | 400
 |  |  |  |  |  | High_Bay | [NAME] (unknown ballast) |  |  | 1.070866666666667 | 12.3 | 400
 |  |  |  |  |  | High_Bay | Mercury vapour with magnetic ballast | 1.033 | 11 | 1.033 | 11 | 400
 |  |  |  |  |  | High_Bay | High pressure sodium (HPS) with magnetic ballast | 1.051 | 13 | 1.051 | 13 | 400
 |  |  |  |  |  | Emerging Tech | Refer to Approved ESC product list
 |  |  |  |  |  | Product_Description | Product | LCP (Watts) | Lume (ns) | Lifetime (MRL) | Supply&Install Price | Real Consumption Usage
 |  |  |  |  |  | Ecobulb 15W [NAME] (Non Dimmable) | CFL | 16.43 | 400 | 10000 | 36.8 | 15
 |  |  |  |  |  | Ecobulb 15W [NAME] (Dimmable) | CFL | 14.75 | 600 | 30000 | 36.8 | 15
 |  |  |  |  |  | EP 6W LED GU10 -Downlight (Non Dimmable) | LED | 6.11 | 360 | 30000 | 53.9 | 6.11
 |  |  |  |  |  | LED4Life 6W GU10 - Downlight (Dimmable) | LED | 4.45 | 260 | 50000 | 54.25 | 4.45
 |  |  |  |  |  | LED4Life 9W GU10 - Downlight (Dimmable) | LED | 5.89 | 300 | 50000 | 59.5 | 5.6
 |  |  |  |  |  | Philips LED 10W MR16 - Downlight (Dimmable) | LED | 11.7 | 410 | 30000 | 48 | 11.7
 |  |  |  |  |  | Centraurus 6W LED MR16 - (Dimmable) | LED | 5.25 | 2700 | 30000 | 37.1 | 5.25
 |  |  |  |  |  | [NAME] LED MR16 - (Dimmable) | LED | 7 | 350 | 30000 | 57.4 | 7.4
 |  |  |  |  |  | ALPHA 12W Fuxture Downlight -  (Dimmable) | LED | 12.3 | 3000 | 30000 | 58.6 | 12
 |  |  |  |  |  | [NAME] 25W T5 Adaptor & Tube | LED | 24.9 | 1549 | 30000 | 32.4 | 24.9
 |  |  |  |  |  | SS 14W LED Tube | LED | 14 | 1300 | 30000 | 54.6 | 14
 |  |  |  |  |  | SS 20W LED Tube | LED | 19.9 | 1600 | 30000 | 68.6 | 19.9
 |  |  |  |  |  | Voxon 150W LED High Bay | LED | 143 | 9760 | 50000 | 738 | 143
Asset Lifetime
 | Baseline Asset Lifetime Reference
 |  |  |  |  |  | Case | Description | Calculation (years)
 |  |  |  |  |  |  | Delamping: During the upgrade, you removed no more than half the lamps from a multiple lamp fitting. | MRL/AOH
 |  |  |  |  |  |  | During the upgrade, you removed (but did not replace) the lamp(s) and either you have replaced the associated ballast or transformer, or you removed the associated light fitting. | 10
 |  |  |  |  |  |  | During the upgrade, you replaced the lamp(s) and any associated ballast and transformer. | 10
 |  |  |  |  |  |  | During the upgrade, you replaced the lamp(s) but did not replace any associated ballast or transformer (or none was present). | MRL/AOH
 |  |  |  |  |  |  | [NAME],B,C, nor D describes the work undertaken. | MRL/AOH
 |  |  |  |  |  |  | Most Likely Value | 10
 | Upgrade Asset Lifetime Reference
 |  |  |  |  |  | Case | Description | Calculation (Years)
 |  |  |  |  |  |  | During the upgrade, your replaced the ballast or transformer associated with the lamp(s). | 10
 |  |  |  |  |  |  | During the upgrade, your installed the lighting fitting that the lamp(s) is installed in. | 10
 |  |  |  |  |  |  | Neither U-A or U-B describes the work undertaken. | MRL/AOH
 |  |  |  |  |  |  | Most likely value | 10
 | Default Asset Lifetime Parameter (years) |  |  |  |  | 10
Annual Operating Hours |  |  |  |  |  | 3000
Air Conditioning Multiplier
 |  |  |  |  |  | AC | Multiplier
 |  |  |  |  |  | Yes | 1.05
 |  |  |  |  |  | No | 1
Asset Liftetime Drop Down List Values
 |  |  |  |  |  | Default
 |  |  |  |  |  | Delamping