# 6V K to -f° 

# NES Spreadsheet Documentation

What does the t

Naional Energy Savi ngs sp readsheet do?
The NES spreadsheet (currently NES_v2

.xls) performs calculations of national energy savings based on user inputs similar to those for the LCC spreadsheet

. These are used along with forecasts of magnetic ballast shipments and a social discount rate , to perform projections for converting from magnetic ballasts to electronic ballasts , and to cathode cutout ballasts. The national energy savings , energy cost savings, equipment costs, and net present value for the four major ballast classes are forecast from the start year through 2030. The NES spreadsheet operates in Excel 97 or Excel 7 (Windows 95).



### What are the worksheets in the workbook? The workbook NES

v2

.XLS includes the following worksheets: RESULTS contains the summary table of energy savings, benefits (energy

cost savings), equipment costs, and NPV. Engineering contains the calculations of the energy savings and the

change in equipment costs for each ballast class. Com Elec Price contains the various projections of commercial sector electricity

prices. Ind Elec Price contains the various projections of industrial sector electricity

prices. T12 Shipments contains the summary of the shipments forecasts for magnetic

ballasts and the electronic ballasts that replace them under a standard. 2F40T12 through 2F96T12HO

contain the forecast calculations for each separate ballast class. Lifetime 2F40 through Lifetime 2F96HO

contain the annual values for retired and surviving ballasts. Setup is used as an interface between user inputs and the rest of the

worksheets. (See LCC Setup for discussion on confirmed and temporary choices.) Default Engr contains the default engineering and price data.
How does the user operate the spreadsheet? 

# NES Spreadsheet Documentation

What does the National Energy Savings (NES) spreadsheet do?

The NES spreadsheet (currently NES_v2.xls) performs calculations of national energy savings based on user inputs similar to those for the LCC spreadsheet. These are used along with forecasts of magnetic ballast shipments and a social discount rate, to perform projections for converting from magnetic ballasts to electronic ballasts, and to cathode cutout ballasts. The national energy savings, energy cost savings, equipment costs, and net present value for the four major ballast classes are forecast from the start year through 2030. The NES spreadsheet operates in Excel 97 or Excel 7 (Windows 95).



### What are the worksheets in the workbook? The workbook NES_v2.XLS includes the following worksheets: RESULTS contains the summary table of energy savings, benefits (energy cost savings), equipment costs, and NPV. Engineering contains the calculations ofthe energy savings and the change in equipment costs for each ballast class. Com Elec Price contains the various projections of commercial sector electricity prices. Ind Elec Price contains the various projections of industrial sector electricity prices. T12 Shipments contains the summary ofthe shipments forecasts for magnetic ballasts and the electronic ballasts that replace them under a standard. 2F40T12 through 2F96T12HO contain the forecast calculations for each separate ballast class. Lifetime 2F40 through Lifetime 2F96HO contain the annual values for retired and surviving ballasts. Setup is used as an interface between user inputs and the rest ofthe worksheets. (See LCC Setup for discussion on confirmed and temporary choices.) Default Engr contains the default engineering and price data.

How does the user operate the spreadsheet?

### The user interacts with the spreadsheet by clicking choices or entering data,using the graphical

interface that comes with the spreadsheet. The entry point to the user interface is the LIST INPUTS menu. The LIST INPUTS menu can be invoked by clicking the [LIST I NPUTS] button on the RESULTS worksheet or by hitting <CRTL>L from any worksheet. From the LIST INPUTS menu, the user can then enter the input screens for selecting (1) Electricity Price Projection, (2) Effective Date of Ballast Standards, (3) Discount Rate and Discount Year (4) Shipments Forecast and (5) Ballast Assumptions by clicking the corresponding button. When inside any one of the five input screens, the user can switch over to any other one or back to the LIST INPUTS menu by clicking the corresponding button at the bottom. 

### After making the selections, the user can start the calculation by clicking the [CALCULATE] button or by hitting <ALT>C. In case the user wants to disregard the selections that have been made, the setup session can be canceled by clicking the [CANCEL] button in the LIST INPUTS menu, or the X at the top right of any screen. Note that the RESULTS screen will still reflect any changes made prior to the last calculation. In the Ballast Assumptions screen, to return to the default input values, click on the [Load Defaults] button. If new results were previously calculated, another calculation must be done (using [CALCULATE] or <ALT>C in order to produce the default results. This button resets only the ballast inputs; it does not affect changed inputs from other menus in LIST I NPUTS. NOTE: Input changes should always be made in the LIST I NPUTS menu. The user may view the impacts on the other worksheets, but editing those sheets could cause calculation errors, especially if formulae are overwritten. The exception is the Default Engr worksheet; here the user may change the default engineering values. These values will then load when the workbook is opened, or when Load Defaults is selected. (Results will then be different than those from the original LBNL model.) 

# How i

# s the Sh i 

# pments menu used ?. The Shipments menu allows the user to select Decreasing Shipment or Constant Shipment. In the decreasing shipments scenario, magnetic ballasts shipments decrease to a selected value by a certain year, and remain constant at that value through 2030. The user selects these shipment values in the "Reduce Shipment to" and "by year" boxes. This scenario uses a magnetic ballast shipments forecast for the start year based on a linear regression through actual 1993 - 1997 shipments for that ballast class and assumes that a small number of magnetic ballasts will continue to be sold in the future. The constant shipments scenario assumes that magnetic ballast shipments remain constant at 1997 levels through 2030. This is considered a "low efficiency case" or an upper bound to potential savings from an efficiency standard. The user interacts with the spreadsheet by clicking choices or entering data>,using the graphical interface that comes with the spreadsheet. The entry point to the user interface is the LIST INPUTS menu. The LIST INPUTS menu can be invoked by clicking the [LIST INPUTS] button on the RESUL TS worksheet or by hitting <CRTL>L from anyworksheet. From the LIST INPUTS menu, the user can then enterthe input screens for selecting (1) 

### ElectricityPrice Projection, 

### (2) Effective Date 

### ofBallast Standards, 

### (3) Discount Rate and Discount Year(4) 

### Shipments Forecastand (5) 

### BallastAssumptions by clicking the corresponding button.
When inside anyone ofthe five input screens, the user can switch overto any other one or back to the LIST INPUTS menu by clicking the corresponding button at the bottom. 

### After making the selections, the user can start the calculation by clicking the [CALCULATE] button or by hitting <Al T>C. In case the user wants to disregard the selections that have been made, the setup session can be canceled by clicking the [CANCEL] button in the LIST INPUTS menu, orthe X at the top right of any screen. Note that the RESULTS screen will still reflect any changes made prior to the last calculation.
In the 

### BallastAssumptions screen, to return to the default input values, click on the 

### [Load Defaults] button. If new results were previously calculated, another calculation must be done (using [CALCULATE] or <AL T>C in order to produce the default results. This button resets only the ballast inputs; it does not affect changed inputs from other menus in LIST INPUTS. NOTE: Input changes should always be made in the LIST INPUTS menu. The user may view the impacts on the otherworksheets, but editing those sheets could cause calculation errors, especially ifformulae are overwritten.
The exception is the 

### Default Engrworksheet; here the user may change the default engineering values. These values will then load when the workbook is opened, or when 

### Load Defaults is selected. (Results will then be different than those from the original LBNL model.) 

# How is the Shipments menu used?
The 

### Shipments menu allows the userto select 

### Decreasing Shipment or 

### Constant Shipment. In the decreasing shipments scenariO, magnetic ballasts shipments decrease to a selected value by a certain year, and remain constant at that value through 2030. The user selects these shipment values in the "Reduce Shipment to" and "by year" boxes. This scenario uses a magnetic ballast shipments forecast for the start year based on a linear regression through actual 1993

- 1997 shipments for that ballast class and assumes that a small number of magnetic ballasts will continue to be sold in the future. The constant shipments scenario assumes that magnetic ballast shipments remain constant at 1997 levels through 2030. This is considered a "low efficiency case" or an upper bound to potential savings from an efficiency standard.