48.2 Examine the Excel Model

The exported Excel workbook contains model results under all data scenarios representing every combination of input parameter values. The results are pre-run in TreeAge Pro. If the TreeAge Pro model changes, you can repeat the export process to reflect those changes in a new exported workbook.

The workbook is split into three different sheets described in the following subsections.

48.2.1  Overview sheet

This sheet contains information about the model and its strategies since the receiver of this workbook may not have the original TreeAge Pro model. It also includes instructions on how to use the workbook to generate and save results using different scenarios.

On the Overview Sheet you will find:

  • Model description: This contains the text entered in the wizard to describe the model.

  • Strategies: This contains the node label from the strategy nodes as well as the text interested in the wizard to describe each strategy.

  • Instructions: These instructions tell the recipient of the model workbook how to use it.

  • Model Diagram: This section will include a picture of the original TreeAge Pro model if the exporter chose to include a picture in the workbook.

After export workbook is created, you can add/edit text as desired.

48.2.2  Run model sheet

This sheet includes all editable inputs and action buttons described below.

The sheet is split into four main sections:

  • Editable Model Inputs and WTP: These are the parameters selected in the wizard as editable inputs.

  • Additional Inputs: These are the other parameters not selected as editable inputs. They are presented here for information purposes only.

  • Action Buttons:

    • Run Model: Show results for the current selection of input values. Both Rankings and CE analyses will be presented to the right of the buttons.

    • Save Results on New Sheet: Save the current results generated via "Run Model" on a separate sheet for comparison to results for other data scenarios.

    • Restore Base Case Inputs: Set all inputs back to the original base case values.

  • Model results: Initially there are no model results on this tab, but once you click Run Model, results will appear to the right of these buttons.

When you first open the Run Model tab, all inputs will be set to their base case values. Model results using those base case inputs will be presented in the third sheet "Base Case Results".

To generate a new set of results:

  • For each of the editable model inputs, click on the green cell to choose from among the three values presented to the right - Low, Base and High.

  • Edit the WIllingness To Pay (WTP) if desired.

  • Click the Run Model button.

The figure below shows the sheet with results.

The Results are presented as a Rankings Report and a Cost-Effectivenss Analysis Graph (for CE models only) based on the selected inputs. Each time you change the Editable Model Inputs and Run Model, the results on the right in the rankings and the graph will change.

To save a set of results:

  • When a set of editable model inputs generates results you want to save, select the Save Results to New Sheet.

  • A new tab will open, called Saved scenario 1. Every subsequent set of results will have a sequential number.

To restore the base case inputs:

  • If you want to set all the editable model inputs back to their Base case values, select the Restore Base Case Inputs button.

  • Once you reset any values, you will need to select Run Model to regenerate the model results.

48.2.3  Base Case and additional sheets

The last sheet generated when the Excel workbook is created has the Base Case results. This and the additional sheets (generated from the Save Results on New Sheet button) are not editable.

The sheet is split into the model inputs on the left hand side and the model outputs - Rankings report and Cost Effectiveness Graph (for CE models only) - on the right hand side.

An additional sheet generated from running the model with all low inputs - Saved Scenario 1 (below).