6V K

to -f°

NES Spreadsheet Documentation

What does the National Energy Savings 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 NESv2.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?

EE-RM-97-500 COMMENT 67K

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 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? 
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

I NPUTS menu. The LIST I NPUTS 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 I NPUTS 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 is the Shipments 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.

EE-RM-97-500 COMMENT 67K

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 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 anyone 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 <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, 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 <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 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 is the Shipments 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.