APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA

SPREADSHEETS

TABLE OF C ONTENTS

**10A.1 INTRODUCTION** 

**................................. ...............................................................**  **10A­1**

**10A.1.1 General**  **Service Fluorescent**  **Lamps**

**..................................................................... 10A­1** 

**10A.1.2 Incandescent**  **Reflector Lamps** 

**.............................................................................. 10A­5** 

**10A.2 BASIC**  **INSTRUCTIONS**

**..................................................................................... 10A­7** 

**10A.2.1 General**  **Service Fluorescent**  **Lamps**

**..................................................................... 10A­7** 

**10A.2.2 Incandescent**  **Reflector Lamps** 

**.............................................................................. 10A­8** 

**10A­i**APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA

SPREADSHEETS

10A.1 INTRODUCTION

**Th e**  **results ob**  **tained for**  **the shipments**  **analysis and**  **the national**  **impact analysis**  **(NIA)**

**can be**  **examined and**  **reproduced using**  **the Microsoft**  **Excel spreadsheet**  **available on**  **the U.S.** 

**Department of**  **Energy (DOE)**  **Building Technologies**  **website at:** 

**http://www.eere.energy.gov/buildings/appliance_standards/**

**.**

**There are**  **t wo**  **NIA spreadsheets:**  **one spreadsheet**  **for general**  **service fluorescent**  **lamps**

**(GSFL), one**  **incandescent reflector**  **lamps (IRL).**  **The two**  **spreadsheets posted**  **on the**  **DOE**

**website represent**  **the latest**  **versions and**  **have been**  **tested with**  **Microsoft Excel**  **2003.**

**To execute**  **t he**  **spreadsheet requires**  **Microsoft Excel**  **2003 or**  **a later**  **version. The**  **NIA**

**spreadsheet performs**  **calculations to**  **forecast the**  **national energy**  **savings (NES)**  **(i.e., the**  **change**

**in national**  **energy use**  **from the**  **base to**  **standards cases),**  **and the**  **net present**  **value (NPV)**  **due to** 

**an energy**  **conservation standard.**  **The energy**  **use and**  **associated costs**  **for a**  **given candidate** 

**standard level**  **(CSL) are**  **determined first**  **by calculating**  **the shipments**  **and then**  **calculating the** 

**energy use**  **and costs**  **for all**  **products shipped**  **under that**  **CSL. The**  **differences between**  **the**

**standards and**  **base cases**  **can then**  **be compared**  **and the**  **overall NES**  **and NPV**  **determined.**

10A.1.1 General S ervice Fluorescent Lamps

**The NIA**  **spreadsheet t**  **hat models**  **commercial sector**  **GSFL consists**  **of the**  **following**

**worksheets:**

Input and S ummary **Contains user**  **i nput**  **selections under**  **“User Inputs”**  **and a** 

**summary table**  **o f**  **the cumulative**  **NES and**  **NPV for**  **4­foot**

**medium bipin**  **s ockets,**  **8­foot single**  **pin slimline**  **sockets,**

**and 8­foot**  **r ecessed**  **double contact**  **high output**  **sockets**

**under “National**  **I mpacts**  **Summary” for**  **the selected**  **CSL.**

Graphs **Contains base­case**  **a nd**  **standards­case shipment**  **and NPV** 

**graphs.**

Data Tables **C ontains**  **data t**  **ables for**  **NPV calculations,**  **shipments,**

**energy consumption,**  **lamp s**  **tock, and**  **lumen output.** 

Comm. Market­Share M atrices **Contains the**  **u ser**  **selected market­share**  **matrices**

**(technology mi**  **x of**  **shipments) of**  **4­foot medium**  **bipin and** 

**8­foot single**  **p in**  **slimline lamp**  **and lamp­and­ballast** 

**shipments in**  **t he**  **commercial sector.** 

**10A­1**Ind. Market­Share Matrices **Contains the**  **u ser­selected**  **(either shift,**  **roll­up, or**  **custom)**

**market­share ma**  **trices (technology**  **mix of**  **shipments) of**  **8­**

**foot recessed**  **double c**  **ontact high**  **output lamp**  **and lamp** 

**and­ballast sh**  **ipments in**  **the industrial**  **sector.**

Comm. Custom I nputs **Used to**  **a llow**  **the user**  **to input**  **custom market­share** 

**matrices for**  **4 ­foot**  **medium bipin**  **lamps and**  **8­foot single** 

**pin slimline**  **l amps.** 

Ind. Custom I nputs **Used to**  **a llow**  **the user**  **to input**  **custom market­share** 

**matrices for**  **8 ­foot**  **recessed double**  **contact high**  **output**

**lamps.**

Assumptions **Documents va**  **rious assumptions**  **made in**  **the commercial** 

**and industrial**  **s ector**  **models.**

Average System C haracteristics **Calculates the**  **a verage**  **shipped system**  **characteristics (e.g.** 

**lamp price,**  **i nput**  **power, lumen**  **output) from**  **the market** 

**share matrices.** 

I nitial Stock C alculation **Calculates the**  **i nitial**  **stocks of**  **4­foot medium**  **bipin, 8­foot** 

**single pin**  **s limline,**  **and 8­foot**  **recessed double**  **contact high** 

**output lamps**  **f rom**  **historical shipments**  **and shipment** 

**projections. The**  **sheet also**  **calculates the**  **slope of**  **the age** 

**distribution fo**  **r fluorescent**  **systems from**  **historical lamp** 

**shipments and**  **b allast**  **shipment census**  **data.**

4­foot MBP I nitial Ballast Stock **Performs the**  **c alculations**  **of lamp**  **replacement shipments** 

**on all**  **4 ­foot**  **medium bipin**  **ballasts in**  **the installed**  **base in** 

**2011 for**  **t he**  **base case**  **and standards**  **case. The**  **sheet starts** 

**with the**  **s tock**  **accounting of**  **the lamp­and­ballast**  **systems**

**and uses**  **t he**  **ballast lifetime**  **and retrofit**  **rate to**  **calculate the** 

**surviving stock**  **i n**  **each year.**  **It then**  **performs calculations** 

**of lamp**  **r eplacements**  **based on**  **the lamp**  **replacement**

**schedule. Finally,**  **using a**  **verage system**  **properties as** 

**determined by**  **the market­share**  **matrices, the**  **sheet then** 

**calculates energy**  **c onsumption,**  **equipment cost,**  **and**

**operating cost**  **d ue**  **to this**  **installed stock**  **of ballasts**  **for each** 

**year.**

4­foot MBP N ew Ballast Stock **Mainly performs**  **t he**  **calculations of**  **4­foot medium**  **bipin**

**lamp­and­ballast sy**  **stem shipments**  **after 2011**  **and all**  **lamp**

**replacements on**  **this installed**  **ballast base**  **in the**  **base case** 

**and standards**  **c ase.**  **The sheet**  **starts by**  **calculating new** 

**lamp­and­ballast sy**  **stem shipments**  **due to**  **new construction** 

**10A­2 in**  **the commercial**  **sector. It**  **also calculates**  **ballast**

**replacements due**  **to failure**  **or retrofitting**  **of ballasts** 

**tracked in**  **the 4­foot**  **MBP Initial**  **Ballast Stock**  **and 4­foot** 

**MBP New**  **Ballast Stock**  **worksheets. The**  **sheet tracks** 

**these shipments**  **and uses**  **the ballast**  **lifetime to**  **calculate**

**the surviving**  **stock in**  **each year.**  **It then**  **performs**

**calculations of**  **lamp replacements**  **on this**  **ballast stock** 

**based on**  **the lamp**  **replacement schedule.**  **Finally, using** 

**average system**  **properties as**  **determined by**  **the market** 

**share matrices,**  **the sheet**  **then calculates**  **energy**

**consumption, equipment**  **cost, and**  **operating cost**  **due to**  **this**

**installed stock**  **of ballasts**  **for each**  **year.**

8­foot SP I nitial Ballast Stock **Mainly performs**  **the calculations**  **of lamp**  **replacement**

**shipments on**  **all 8­foot**  **single pin**  **slimline ballasts**  **in the** 

**installed base**  **in 2011**  **for the**  **base case**  **and standards**  **case.**

**The sheet**  **starts with**  **the stock**  **accounting of**  **the lamp**  **and**

**ballast systems**  **and uses**  **the ballast**  **lifetime and**  **retrofit rate** 

**to calculate**  **the surviving**  **stock in**  **each year.**  **It then** 

**performs calculations**  **of lamp**  **replacements based**  **on the** 

**lamp replacement**  **schedule. Finally,**  **using average**  **system**

**properties as**  **determined by**  **the market­share**  **matrices, the** 

**sheet then**  **calculates energy**  **consumption, equipment**  **cost,**

**and operating**  **cost due**  **to this**  **installed stock**  **of ballasts**  **for**

**each year.** 

8­foot SP N ew Ballast Stock **Mainly performs**  **the calculations**  **of 8­foot**  **single pin** 

**slimline lamp­and­ballast**  **system shipments**  **after 2011**  **and**

**all lamp**  **replacements on**  **this installed**  **ballast base**  **in the** 

**base case**  **and standards**  **case. In**  **addition this**  **sheet**

**performs calculations**  **of 4­foot**  **medium bipin**  **lamp­and**

**ballast system**  **shipments after**  **2011 to**  **replace some**  **retired**

**or retrofitted**  **8­foot T12**  **single pin**  **slimline ballasts.**  **The**

**sheet calculates**  **ballast replacements**  **due to**  **failure or** 

**retrofitting of**  **ballasts tracked**  **in the**  **8­foot SP**  **Initial**

**Ballast Stock**  **and 8­foot**  **SP New**  **Ballast Stock**  **sheets. The** 

**sheet tracks**  **these shipments**  **and uses**  **the ballast**  **lifetime to** 

**calculate the**  **surviving stock**  **in each**  **year. It**  **then performs** 

**calculations of**  **lamp replacements**  **on this**  **ballast stock** 

**based on**  **the lamp**  **replacement schedule.**  **Finally, using** 

**average system**  **properties as**  **determined by**  **the market** 

**share matrices,**  **the sheet**  **then calculates**  **energy**

**consumption, equipment**  **cost, and**  **operating cost**  **due to**  **this**

**installed stock**  **of ballasts**  **for each**  **year.**

**10A­3**8­foot HO Initial Ballast Stock **Mainly performs**  **t he**  **calculations of**  **lamp replacement** 

**shipments on**  **a ll**  **8­foot recessed**  **double contact**  **HO ballasts** 

**in the**  **i nstalled**  **base in**  **2011 for**  **the base**  **case and**  **standards**

**case. The**  **sheet s**  **tarts with**  **the stock**  **accounting of**  **the lamp** 

**and ballast**  **s ystems**  **and uses**  **the ballast**  **lifetime and**  **retrofit**

**rate to**  **c alculate**  **the surviving**  **stock in**  **each year.**  **It then** 

**performs calculations**  **o f**  **lamp replacements**  **based on**  **the**

**lamp replacement**  **s chedule.**  **Finally, using**  **average system** 

**properties as**  **d etermined**  **by the**  **market­share matrices,**  **the**

**sheet then**  **c alculates**  **energy consumption,**  **equipment cost,** 

**and operating**  **c ost**  **due to**  **this installed**  **stock of**  **ballasts for** 

**each year.** 

8 ­foot HO N ew Ballast Stock **Mainly performs**  **t he**  **calculations of**  **8­foot recessed**  **double**

**contact HO**  **lamp­and­ballast s**  **ystem shipments**  **after 2011** 

**and all**  **l amp**  **replacements on**  **this installed**  **ballast base**  **in**

**the base**  **c ase**  **and standards**  **case. The**  **sheet calculates** 

**ballast replacements**  **d ue**  **to failure**  **of ballasts**  **tracked in**  **the**

**8­foot HO**  **I nitial**  **Ballast Stock**  **and 8­foot**  **HO New**  **Ballast**

**Stock sheets.**  **Th e**  **sheet tracks**  **these shipments**  **and uses**  **the**

**ballast lifetime**  **t o**  **calculate the**  **surviving stock**  **in each**  **year.**

**It then**  **p erforms**  **calculations of**  **lamp replacements**  **on this** 

**ballast stock**  **based o**  **n the**  **lamp replacement**  **schedule.**

**Finally, using**  **a verage**  **system properties**  **as determined**  **by**

**the market­share**  **m atrices,**  **the sheet**  **then calculates**  **energy**

**consumption, eq**  **uipment cost,**  **and operating**  **cost due**  **to this** 

**installed stock**  **o f**  **ballasts for**  **each year.** 

Equipment Pr ices **Contains the**  **e nd­user**  **product prices**  **and installation**  **labor**

**costs of**  **l amps**  **and ballasts.**  **This worksheet**  **also contains** 

**price scaling**  **f actors**  **for the**  **lifetimes used**  **in the**  **model.**

Electricity Pri ces **Contains projected**  **a verage**  **electricity for**  **the three** 

**economic scenarios.** 

H eat Rates **C ontains**  **the s**  **ite­to­source conversion**  **factors that**  **are used** 

**in the**  **s ource**  **energy savings**  **calculations for**  **electricity.**

Lamp Replacement S chedule **Contains the**  **s chedule**  **for lamp**  **replacement by**  **year of** 

**ballast life.**  **The s**  **heet also**  **tracks the**  **end of**  **life of**  **lamps**

**installed prior**  **t o**  **2012.**

**10A­4**10A.1.2 Incandescent Reflector Lamps

**The NIA**  **spreadsheet t**  **hat models**  **residential and**  **commercial sector**  **IRL consists**  **of the** 

**following worksheets:** 

Input and S ummary **Contains user**  **input selections**  **under “User**  **Inputs” and**  **a**

**summary table**  **of the**  **cumulative NES**  **and NPV**  **for**

**commercial and**  **residential incandescent**  **reflector lamps** 

**(IRL) under**  **“National Impacts**  **Summary” for**  **the selected** 

**CSL.**

IRL Plots **C ontains**  **base­case and**  **standards­case shipment,**  **stock,**

**lumen output,**  **and NPV**  **graphs.**

IRL Data T ables **Contains data**  **tables for**  **NPV calculations,**  **shipments,**

**energy consumption,**  **lamp stock,**  **and lumen**  **output.**

Mrkt Shre M trx­Scen. Choice **Contains the**  **market­share matrices**  **(technology mix**  **of**

**stock) of**  **IRL and**  **CFL in**  **the commercial**  **and residential** 

**sector. These**  **market share**  **matrices reflect**  **the scenario** 

**chosen by**  **the user**  **(Main, 65W**  **BR Lamp**  **Substitution, 10** 

**percent Lumen**  **Increase, and**  **User Input).**  **This page**  **also**

**shows the**  **breakdown among**  **the baseline**  **models as**  **well as** 

**the percentage**  **of IRL**  **going to**  **CFLs or**  **other emerging** 

**technologies in**  **the base**  **and standards**  **case. Average**  **lamp**

**characteristics in**  **the base**  **and standards**  **case in**  **the**

**commercial and**  **residential sectors**  **is also**  **given.**

Mrkt Shre M trx­Main Scenario **Contains the**  **market­share matrices**  **(technology mix**  **of**

**stock) of**  **commercial and**  **residential IRL**  **under the**  **Main**

**Scenario.**

Mrkt Shre M trx­65W BR Lamp Sub **Contains the**  **market­share matrices**  **(technology mix** 

**of stock)**  **of commercial**  **and residential**  **IRL under**  **the 65W** 

**BR Lamp**  **Substitution Sensitivity.** 

Mrkt Shre M trx­10% Lumen Inc **Contains the**  **market­share matrices**  **(technology mix**  **of**

**stock) of**  **commercial and**  **residential IRL**  **under the**  **10**

**percent Lumen**  **Increase Sensitivity.** 

Mrkt Shre M trx­User Input **Used to**  **allow the**  **user to**  **input custom**  **market­share**

**matrices for**  **commercial and**  **residential IRL.** 

Assumptions **Do cuments**  **various assumptions**  **made in**  **the commericial** 

**and residential**  **sector IRL**  **model.**

**10A­5**Base Case

Standards Ca se IRL

Standards Ca se CFL **Calculates IRL**  **l amp**  **replacement shipments**  **in the** 

**commercial and**  **residential sector**  **in the**  **base case.**  **The**

**sheet starts**  **with the**  **stock of**  **covered commercial**  **and**

**residential IRL**  **in 2011**  **and grows**  **that stock**  **according to**  **a**

**specified growth**  **rate. It**  **then divides**  **that stock**  **among**

**different lamp**  **lifetimes as**  **determined by**  **the market­share** 

**matrices and**  **performs calculations**  **of lamp**  **replacements**

**based on**  **the retirement**  **schedule. Finally,**  **using average** 

**system properties**  **for each**  **lamp lifetime**  **as determined**  **by**

**the market­share**  **matrices, the**  **sheet calculates**  **energy**

**consumption, equipment**  **cost, and**  **operating costs**  **of IRL**  **in**

**the commercial**  **and residential**  **sectors.**

**Calculates IRL**  **l amp**  **replacement shipments**  **in the** 

**commercial and**  **residential sector**  **in the**  **standards case.** 

**The stock**  **of covered**  **IRL and**  **additional reflector**  **CFL in** 

**the standards**  **case is**  **equal to**  **the stock**  **of covered**  **IRL in** 

**the base**  **case multiplied**  **by 1**  **plus the**  **installed stock** 

**adjustment percentage**  **chosen by**  **the user.**  **Based on**  **the**

**user­selected market**  **share matrices,**  **this sheet**  **divides the** 

**stock among**  **different lamp**  **lifetimes and**  **performs**

**calculations of**  **lamp replacements**  **based on**  **the retirement** 

**schedule. Finally,**  **using average**  **system properties**  **for each** 

**lamp lifetime**  **as determined**  **by the**  **market­share matrices,** 

**the sheet**  **calculates energy**  **consumption, equipment**  **cost,**

**and operating**  **costs of**  **IRL in**  **the commercial**  **and**

**residential sectors**  **in the**  **standards case.** 

**Calculates additional**  **r eflector**  **CFL lamp**  **replacement**

**shipments in**  **the standards**  **case residential**  **sector. The** 

**stock of**  **covered IRL**  **and additional**  **reflector CFL**  **in the** 

**standards case**  **is equal**  **to the**  **stock of**  **covered IRL**  **in the** 

**base case**  **multiplied by**  **1 plus**  **the installed**  **stock**

**adjustment percentage**  **chosen by**  **the user.**  **Based on**  **the**

**residential user­selected**  **market share**  **matrices, this**  **sheet**

**divides the**  **stock among**  **IRL and**  **CFL and**  **performs**

**calculations of**  **lamp replacements**  **for reflector**  **CFLs based** 

**on the**  **retirement schedules**  **for reflector**  **CFLs at**  **five**

**different operating**  **hours. Finally,**  **using average**  **system**

**properties for**  **CFLs as**  **determined by**  **the market­share** 

**matrices, the**  **sheet calculates**  **energy consumption,** 

**equipment cost,**  **and operating**  **costs of**  **IRL in**  **the**

**commercial and**  **residential sectors**  **in the**  **standards case.** 

**10A­6**Intial Stock and Proj. Ship. **Projects shipments**  **of covered**  **IRL from**  **2006 to**  **2011 in** 

**order to**  **calculate the**  **initial (2011)**  **stock of**  **covered IRL**  **in**

**the commercial**  **and residential**  **sectors. The**  **affect of**  **EISA**

**2007 is**  **taken into**  **account in**  **these projections.** 

Historical Sh ipments **Contains the**  **total historical**  **shipments of**  **IRL from**  **2001 to** 

**2005 as**  **well as**  **shipments of**  **IRL in**  **the commercial**  **and**

**residential sector.** 

Electricity Pri ces **Contains projected**  **average electricity**  **for the**  **three**

**economic scenarios.** 

Heat Rates **C ontains**  **the site­to­source**  **conversion factors**  **that are**  **used**

**in the**  **source energy**  **savings calculations**  **for electricity.** 

Retirement Sc hedules **Contains the**  **percentage of**  **lamps retiring**  **in each**  **year of** 

**life for**  **each lamp**  **lifetime used**  **in the**  **model.**

10A.2 BASIC I NSTRUCTIONS

10A.2.1 General S ervice Fluorescent Lamps

**Basic instructions**  **f or**  **operating the**  **NIA spreadsheets**  **for GSFL**  **are as**  **follows:**

**1. Once**  **you h**  **ave downloaded**  **the NIA**  **spreadsheet file**  **from the**  **Web, open**  **the file**  **using**

**Excel. At**  **the bottom,**  **click on**  **the tab**  **for the**  **worksheet** Input and Summary

**.**

**2. Use**  **Excel’s V**  **iew/Zoom commands**  **at the**  **top menu**  **bar to**  **change the**  **size of**  **the display** 

**to make**  **it fit**  **your monitor.** 

**3. The**  **user c**  **an change**  **the model**  **parameters listed**  **in the**  **grey box**  **labelled “User**  **Inputs”.**

**The parameters**  **are:**

**a.** CSL: **To c**  **hange the**  **value, use**  **the drop­down**  **arrow and**  **select the**  **desired CSL** 

**for each**  **lamp type.**  **Though T12**  **and T8**  **lamps are**  **considered to**  **be in**  **the same** 

**product class,**  **this spreadsheet**  **allows separate**  **CSLs to**  **be set**  **for each.** 

**b.** Electricity Pri ce Trend: **To change**  **the value,**  **use the**  **drop­down arrow**  **and**

**select the**  **desired Growth**  **level (Reference,**  **Low, or**  **High).**

**c.** Discount Rate: **To change**  **the value,**  **use the**  **drop­down arrow**  **and select**  **the**

**desired Discount**  **Rate (3%**  **or 7%).** 

**d.** Year to D iscount To: **To change**  **the value,**  **type in**  **the desired**  **year.**

**e.** Commercial Se ctor Lumen Growth: **To change**  **the value,**  **type in**  **the**

**percentage annual**  **lumen growth.** 

**10A­7 f.**  Include 8­foot L umen Growth: **To change**  **the value,**  **use the**  **drop­down arrow** 

**and select**  **Yes or**  **No.**

**g.** Base­Case Re trofit Rate: **To change**  **the value,**  **type in**  **the desired**  **percentage**

**annual Base­Case**  **Retrofit Rate**  **for each**  **lamp type.** 

**h.** Standards­Case Re trofit Rate: **To change**  **the value,**  **type in**  **the desired** 

**percentage annual**  **Standards­Case Retrofit**  **Rate for**  **each lamp**  **type.**

**i.** Shipment Scenario: **To change**  **the value,**  **use the**  **drop­down arrow**  **and select**  **the**

**desired shipment**  **scenario (shift,**  **roll­up, or**  **custom). If**  **custom is**  **chosen then** 

**click the**  **hyperlinks to**  **the ""Comm.**  **Custom Inputs""**  **and ""Ind.**  **Custom Inputs""** 

**worksheets to**  **populate the**  **market­share matrices.** 

**4. The**  **results a**  **re automatically**  **updated and**  **are reported**  **for each**  **product class**  **in the** 

**“National Impact**  **Summary” table.**  **Results are**  **also updated**  **in the**  **"Graphs" and**  **"Data**

**Tables" worksheets.** 

10A.2.2 Incandescent R eflector Lamps

**Basic instructions**  **f or**  **operating the**  **NIA spreadsheet**  **for IRL**  **are as**  **follows:**

**1. Once**  **the N**  **IA spreadsheet**  **has been**  **downloaded from**  **the Web,**  **open the**  **file using**  **Excel.**

**At the**  **bottom, click**  **on the**  **tab for**  **the worksheet**  Input and Summary

**.**

**2. Use**  **Excel’s V**  **iew/Zoom commands**  **at the**  **top menu**  **bar to**  **change the**  **size of**  **the display** 

**to make**  **it fit**  **your monitor.** 

**3. The**  **user c**  **an change**  **the model**  **parameters listed**  **in the**  **grey box**  **labelled “User**  **Inputs”.**

**The parameters**  **are:**

**a.** CSL: **To c**  **hange the**  **value, use**  **the drop­down**  **arrow and**  **select the**  **desired CSL** 

**for IRL.** 

**b.** Shipment Scenario: **To change**  **the value,**  **use the**  **drop­down arrow**  **and select**  **the**

**desired shipment**  **scenario (Main**  **Scenario, 65W**  **BR Lamp**  **Substitution**

**Sensitivity, 10**  **percent lumen**  **increase sensitivity).**  **If user**  **input is**  **chosen, click** 

**the hyperlinks**  **to populate**  **custom market­share**  **matrices.**

**c.** Electricity Pri ce Trend: **To change**  **the value,**  **use the**  **drop­down arrow**  **and**

**select the**  **desired Growth**  **level (Reference,**  **Low, or**  **High).**

**d.** Discount Rate: **To change**  **the value,**  **use the**  **drop­down arrow**  **to select**  **the**

**desired discount**  **rate (3%**  **or 7%).** 

**e.** Year to D iscount To: **To change**  **the value,**  **type in**  **the desired**  **year.**

**f.** % Growth R esidential (lamp stock): **To change**  **the value,**  **type in**  **the desired** 

**percentage of**  **growth for**  **the residential**  **lamp stock.** 

**g.** % Growth C ommercial (lamp stock): **To change**  **the value,**  **type in**  **the desired** 

**percentage of**  **growth for**  **the commercial**  **lamp stock.** 

**10A­8 h.**  IRL installed s tock adjustment (stnds case): **To change**  **the value,**  **type in**  **the**

**desired percentage**  **stock adjustment**  **for the**  **standards case.** 

**4. The**  **results a**  **re automatically**  **updated and**  **are reported**  **for each**  **product class**  **in the** 

**“National Impact**  **Summary” table.**  **Results are**  **also updated**  **in the**  **"Graphs" and**  **"Data**

**Tables" worksheets.** 

**10A­9**