APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA

SPREADSHEETS

TABLE O F CONTENTS

**10A.1 I**  **NTRODUCTION**

**................................................................................................ 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 I NTRODUCTION

**The r**  **esults obtained**  **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 a**  **re two**  **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 e**  **xecute the**  **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 G eneral Service Fluorescent Lamps

**The N**  **IA spreadsheet**  **that models**  **commercial sector**  **GSFL consists**  **of the**  **following**

**worksheets:**

Input a nd Summary **Contains u**  **ser input**  **selections under**  **“User Inputs”**  **and a** 

**summary t**  **able of**  **the cumulative**  **NES and**  **NPV for**  **4­foot**

**medium b**  **ipin sockets,**  **8­foot single**  **pin slimline**  **sockets,**

**and 8**  **­foot recessed**  **double contact**  **high output**  **sockets**

**under “**  **National Impacts**  **Summary” for**  **the selected**  **CSL.**

Graphs **Contains b**  **ase­case and**  **standards­case shipment**  **and NPV** 

**graphs.**

Data T ables **Contains d**  **ata tables**  **for NPV**  **calculations, shipments,** 

**energy c**  **onsumption, lamp**  **stock, and**  **lumen output.** 

Comm. M arket­Share Matrices **Contains t**  **he user**  **selected market­share**  **matrices**

**(technology m**  **ix of**  **shipments) of**  **4­foot medium**  **bipin and** 

**8­foot s**  **ingle pin**  **slimline lamp**  **and lamp­and­ballast** 

**shipments i**  **n the**  **commercial sector.** 

**10A­1**Ind. Market­Share Matrices **Contains t**  **he user­selected**  **(either shift,**  **roll­up, or**  **custom)**

**market­share m**  **atrices (technology**  **mix of**  **shipments) of**  **8­**

**foot r**  **ecessed double**  **contact high**  **output lamp**  **and lamp** 

**and­ballast s**  **hipments in**  **the industrial**  **sector.**

Comm. C ustom Inputs **Used t**  **o allow**  **the user**  **to input**  **custom market­share** 

**matrices f**  **or 4­foot**  **medium bipin**  **lamps and**  **8­foot single** 

**pin s**  **limline lamps.** 

Ind. C ustom Inputs **Used t**  **o allow**  **the user**  **to input**  **custom market­share** 

**matrices f**  **or 8­foot**  **recessed double**  **contact high**  **output**

**lamps.**

Assumptions **Documents v**  **arious assumptions**  **made in**  **the commercial** 

**and i**  **ndustrial sector**  **models.**

Average S ystem Characteristics **Calculates t**  **he average**  **shipped system**  **characteristics (e.g.** 

**lamp p**  **rice, input**  **power, lumen**  **output) from**  **the market** 

**share m**  **atrices.**

Initial S tock Calculation **Calculates t**  **he initial**  **stocks of**  **4­foot medium**  **bipin, 8­foot** 

**single p**  **in slimline,**  **and 8­foot**  **recessed double**  **contact high** 

**output l**  **amps from**  **historical shipments**  **and shipment** 

**projections. Th**  **e sheet**  **also calculates**  **the slope**  **of the**  **age**

**distribution f**  **or fluorescent**  **systems from**  **historical lamp** 

**shipments a**  **nd ballast**  **shipment census**  **data.**

4­foot M BP Initial Ballast Stock **Performs t**  **he calculations**  **of lamp**  **replacement shipments** 

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

**2011 f**  **or the**  **base case**  **and standards**  **case. The**  **sheet starts** 

**with t**  **he stock**  **accounting of**  **the lamp­and­ballast**  **systems**

**and u**  **ses the**  **ballast lifetime**  **and retrofit**  **rate to**  **calculate the** 

**surviving s**  **tock in**  **each year.**  **It then**  **performs calculations** 

**of l**  **amp replacements**  **based on**  **the lamp**  **replacement**

**schedule. F**  **inally, using**  **average system**  **properties as** 

**determined b**  **y the**  **market­share matrices,**  **the sheet**  **then**

**calculates e**  **nergy consumption,**  **equipment cost,**  **and**

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

**year.**

4­foot M BP New Ballast Stock **Mainly p**  **erforms the**  **calculations of**  **4­foot medium**  **bipin**

**lamp­and­ballast s**  **ystem shipments**  **after 2011**  **and all**  **lamp**

**replacements o**  **n this**  **installed ballast**  **base in**  **the base**  **case**

**and s**  **tandards case.**  **The sheet**  **starts by**  **calculating new** 

**lamp­and­ballast s**  **ystem 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 S P Initial 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 S P New 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 p**  **erforms the**  **calculations of**  **lamp replacement** 

**shipments o**  **n all**  **8­foot recessed**  **double contact**  **HO ballasts** 

**in t**  **he installed**  **base in**  **2011 for**  **the base**  **case and**  **standards**

**case. The**  **s heet**  **starts with**  **the stock**  **accounting of**  **the lamp** 

**and b**  **allast systems**  **and uses**  **the ballast**  **lifetime and**  **retrofit**

**rate t**  **o calculate**  **the surviving**  **stock in**  **each year.**  **It then** 

**performs c**  **alculations of**  **lamp replacements**  **based on**  **the**

**lamp r**  **eplacement schedule.**  **Finally, using**  **average system** 

**properties a**  **s determined**  **by the**  **market­share matrices,**  **the**

**sheet t**  **hen calculates**  **energy consumption,**  **equipment cost,** 

**and op**  **erating cost**  **due to**  **this installed**  **stock of**  **ballasts for** 

**each y**  **ear.**

8­foot H O New Ballast Stock **Mainly p**  **erforms the**  **calculations of**  **8­foot recessed**  **double**

**contact H**  **O lamp­and­ballast**  **system shipments**  **after 2011** 

**and a**  **ll lamp**  **replacements on**  **this installed**  **ballast base**  **in**

**the b**  **ase case**  **and standards**  **case. The**  **sheet calculates** 

**ballast r**  **eplacements due**  **to failure**  **of ballasts**  **tracked in**  **the**

**8­foot H**  **O Initial**  **Ballast Stock**  **and 8­foot**  **HO New**  **Ballast**

**Stock s**  **heets. The**  **sheet tracks**  **these shipments**  **and uses**  **the**

**ballast l**  **ifetime to**  **calculate the**  **surviving stock**  **in each**  **year.**

**It t**  **hen performs**  **calculations of**  **lamp replacements**  **on this** 

**ballast s**  **tock based**  **on the**  **lamp replacement**  **schedule.**

**Finally, u**  **sing average**  **system properties**  **as determined**  **by**

**the m**  **arket­share matrices,**  **the sheet**  **then calculates**  **energy**

**consumption, e**  **quipment cost,**  **and operating**  **cost due**  **to this** 

**installed s**  **tock of**  **ballasts for**  **each year.** 

Equipment P rices **Contains t**  **he end­user**  **product prices**  **and installation**  **labor**

**costs o**  **f lamps**  **and ballasts.**  **This worksheet**  **also contains** 

**price s**  **caling factors**  **for the**  **lifetimes used**  **in the**  **model.**

Electricity Pr ices **Contains p**  **rojected average**  **electricity for**  **the three** 

**economic s**  **cenarios.**

Heat R ates **Contains t**  **he site­to­source**  **conversion factors**  **that are**  **used**

**in t**  **he source**  **energy savings**  **calculations for**  **electricity.**

Lamp R eplacement Schedule **Contains t**  **he schedule**  **for lamp**  **replacement by**  **year of** 

**ballast l**  **ife. The**  **sheet also**  **tracks the**  **end of**  **life of**  **lamps**

**installed p**  **rior to**  **2012.**

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

**The N**  **IA spreadsheet**  **that models**  **residential and**  **commercial sector**  **IRL consists**  **of the** 

**following worksheets:** 

Input a nd Summary **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 P lots **Contains base­case**  **and standards­case**  **shipment, stock,** 

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

IRL D ata Tables **Contains data**  **tables for**  **NPV calculations,**  **shipments,**

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

Mrkt S hre Mtrx­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 S hre Mtrx­Main Scenario **Contains the**  **market­share matrices**  **(technology mix**  **of**

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

**Scenario.**

Mrkt S hre Mtrx­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 S hre Mtrx­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 S hre Mtrx­User Input **Used to**  **allow the**  **user to**  **input custom**  **market­share**

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

Assumptions **D ocuments**  **various assumptions**  **made in**  **the commericial** 

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

**10A­5**Base Case

Standards C ase IRL

Standards C ase CFL **Calculates I**  **RL lamp**  **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 I**  **RL lamp**  **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 a**  **dditional reflector**  **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 S hipments **Contains the**  **total historical**  **shipments of**  **IRL from**  **2001 to** 

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

**residential sector.** 

Electricity Pr ices **Contains projected**  **average electricity**  **for the**  **three**

**economic scenarios.** 

Heat R ates **Contains the**  **site­to­source conversion**  **factors that**  **are used** 

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

Retirement S chedules **Contains the**  **percentage of**  **lamps retiring**  **in each**  **year of** 

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

10A.2 B ASIC INSTRUCTIONS

10A.2.1 G eneral Service Fluorescent Lamps

**Basic i**  **nstructions for**  **operating the**  **NIA spreadsheets**  **for GSFL**  **are as**  **follows:**

**1. Once**  **y ou**  **have 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**  **Ex cel’s**  **View/Zoom commands**  **at the**  **top menu**  **bar to**  **change the**  **size of**  **the display** 

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

**3. The**  **u ser**  **can change**  **the model**  **parameters listed**  **in the**  **grey box**  **labelled “User**  **Inputs”.**

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

**a.** CSL: **To change**  **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 Pr ice Trend: **To change**  **the value,**  **use the**  **drop­down arrow**  **and**

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

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

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

**d.** Year t o Discount To: **To change**  **the value,**  **type in**  **the desired**  **year.**

**e.** Commercial S ector Lumen Growth: **To change**  **the value,**  **type in**  **the**

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

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

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

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

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

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

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

**i.** Shipment S cenario: **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**  **r esults**  **are 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 I ncandescent Reflector Lamps

**Basic i**  **nstructions for**  **operating the**  **NIA spreadsheet**  **for IRL**  **are as**  **follows:**

**1. Once**  **t he**  **NIA 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**  **Ex cel’s**  **View/Zoom commands**  **at the**  **top menu**  **bar to**  **change the**  **size of**  **the display** 

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

**3. The**  **u ser**  **can change**  **the model**  **parameters listed**  **in the**  **grey box**  **labelled “User**  **Inputs”.**

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

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

**for IRL.** 

**b.** Shipment S cenario: **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 Pr ice Trend: **To change**  **the value,**  **use the**  **drop­down arrow**  **and**

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

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

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

**e.** Year t o Discount To: **To change**  **the value,**  **type in**  **the desired**  **year.**

**f.** % G rowth Residential (lamp stock): **To change**  **the value,**  **type in**  **the desired** 

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

**g.** % G rowth Commercial (lamp stock): **To change**  **the value,**  **type in**  **the desired** 

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

**10A­8 h.**  IRL i nstalled stock adjustment (stnds case): **To change**  **the value,**  **type in**  **the**

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

**4. The**  **r esults**  **are 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**