Computation Section
Investment Economics

This add-in performs operations relevant to the economic analysis of investments. When installed, the menu items on the left appear under the OM_IE menu.

A number of user-defined functions to perform time value of money computations are also installed.

For a one-page summary of the steps for a evaluating a single project click here.

 

 

 

The Links command is very important when an economic model is constructed in one computer and opened in another computer. The forms created by the add-in use user-defined functions. These are linked to the computer where they are created. When opened in a second computer the links are no longer valid and an error message will appear.

 

 

When a workbook containing economic analyses is to be moved to a different computer choose the Links command from the menu. The selection opens the dialog below.

When the OK button is selected with the Freeze Solutions option chosen, all the user-defined functions are replaced with their numeric values. The workbook then opens in another computer with no errors.

This option also replaces the functions from the Random Variables add-in when the model includes uncertainty.

After opening the workbook in the second computer, choose the Links command and choose the Make Links option.

When the OK button is clicked, all the user-defined functions are replaced in their original positions, thus making the forms in the workbook exactly the same as in the original. The command also can be used to correct the links, even when they were not originally frozen with the Freeze Solutions option.

This option also places the required functions from the Random Variables add-in when the model includes uncertainty.

 
 

  
Return to Top

tree roots

Operations Management / Industrial Engineering
Internet
by Paul A. Jensen
Copyright 2004 - All rights reserved

Next Page