Menu | <<<< | >>>> | Create new data, equation workbooks
from {Variables} sheet
|
When the [3. Create Equation Workbook] button has been clicked to create the new expanded equation workbook, this message appears. The new data and equation workbooks are empty but buttons on the Model Manager control screen can be used to fill then with data and equations from your old model. To do this, you must have backed up your original data workbook and you must have put all of your old model equations in the bank with the button on the Model Manager control screen (note that backups are also required if you expand the model manually in Excel – Model Manager programs will place old data and equations in the correct position in the re-built expanded model). In the case of equations, matrix rows will have to be expanded for any new categories and the equation bank must be used to copy existing equation matrices into new sheets. Equations for new variables must be created. |