Because Excel 2000 treats the VBA code in RealCost much like a macro, Excel must be set to allow macros to run before RealCost can be used. As shown in Figure 3, before starting the software, open Excel 2000, check the macro security settings, and ensure that they are adjusted to allow macros to run. The security settings are accessed from the Excel 2000 menu bar.
On the Excel 2000 Menu bar:
Tools >> Macro >> Security...
Figure 3. Excel 2000 macro security form.
... choose Medium Security and exit from Excel 2000.
RealCost is initiated from the Windows Start Menu (see Figure 4).
Start >> Programs >> RealCost >> RealCost 2.1
Figure 4. RealCost on the Windows Start menu.
This command opens Excel 2000 as well as the file "RealCost.xls." Alternatively, a Windows desktop shortcut link to RealCost.xls can be created to open the software.
If the security setting for Excel 2000 is "medium," Excel presents the option to enable macros, as shown in Figure 5, each time RealCost is opened. To run RealCost, choose "Enable Macros." If the macro options form does not appear, check that the Excel macro setting is "medium" (see "Before First Use," above).
Figure 5. Excel 2000 macro options form shown at each RealCost startup.
RealCost opens to the main menu form, called the "Switchboard," a form superimposed on an Excel worksheet. The Switchboard buttons, shown in Figure 6, provide access to almost all of the functionality of the software-data entry, analysis, reports, and utilities. These capabilities are discussed in more detail in "RealCost Switchboard Functions" (page 18). Basic navigation and the Administrative Functions are described here.
Figure 6. The RealCost Switchboard.
When the Switchboard is active, the underlying Excel 2000 worksheets, which capture the data entered through the Switchboard forms, and the Excel menu bar are not accessible. If you want to minimize RealCost, you will need to switch to worksheet mode using either of two options:
To reopen the Switchboard from a worksheet, use the drop-down RealCost menu in the Excel 2000 menu bar, as shown in Figure 7.
Figure 7. Opening the Switchboard from the RealCost menu.
Some users may prefer to work in worksheet mode, and others via the Switchboard forms. Most functions can be performed in either mode, with these exceptions: Creating a new probabilistic input or an LCCA output requires working in worksheet mode and using the respective options on the RealCost drop-down menu. Saving alternative data input files requires using the Switchboard.
Should the RealCost menu disappear from the Excel 2000 menu bar (this may occur if you open another application or file while RealCost is running), you can retrieve the menu through the Excel 2000 drop-down Tools menu:
On the Excel 2000 menu bar:
Tools >> Macro >> Macros >> AddLCCAMenu
(i.e., run that specific macro)
Commands in the Administrative Functions section of the Switchboard execute important housekeeping tasks: moving to the worksheets, clearing data, saving the entire Excel 2000 file (the "workbook"), and exiting the software (see Figure 8). These functions are similar to ordinary Windows functions, such as file saving and file opening, but are performed within RealCost.
Figure 8. Administrative Functions in RealCost.
RealCost can be closed by using the Exit LCCA button in the Administrative Functions section of the Switchboard. When exiting, however, it is necessary to save the entire workbook to retain analysis results. The Exit LCCA button prompts you to save the workbook. The Save LCCA Workbook As... button can be used to save the workbook at any time. Both Exit and Save buttons prompt for a file name and location.
To save a workbook and exit while in worksheet mode, it is advisable to use the "save as" option on the Excel 2000 menu before closing. Saving under an appropriate name will preserve the analysis results. If you save your work in the RealCost workbook, it will be necessary to clear the data when you begin to analyze another project.