49. Markov to Excel

This feature allows the conversion of a TreeAge Pro Markov cohort model to a working stand-alone Excel model with a single mouse click. The Excel model contains editable model inputs for Markov cohort analysis with full transparency. You can then share the Excel model with a person who does not have a TreeAge Pro license and/or is not familiar with the software.

Overview

You can convert a TreeAge Pro Markov cohort model to a working stand-alone Excel model with a single mouse click. The Excel model contains editable model inputs which immediately change the model analysis calculations within Excel.

The Markov cohort output within the Excel model provide full transparency, including cohort flow through all states and events, and the impact of each state and event on your model outcomes. The results from each strategy are then summarized to compare treatment strategies within the Excel workbook.

Note that this is not a standard software feature included with all licenses. Click here to review eligibility requirements.

The Excel workbook provides you with:

  • The ability to share a model with another person who has Excel and/or is not familiar with the software.

  • An easy way to share and receive feedback using the converted Excel model, but then having the flexibility and convenience in making those changes quickly and efficiently in TreeAge Pro, rather than having to make the changes directly in Excel.

  • The ability to quickly and easily validate an Excel model that is received as part of a submission or otherwise. Rebuild the model using TreeAge Pro, and then convert it to Excel to compare the models like-for-like in Excel.

There will be advanced features and analyses available in TreeAge Pro that cannot be converted to the Excel model. The conversion is only for cohort models, not microsimulation models. Click TreeAge Pro features supported by the conversion process for a summary of features supported by the conversion tool.

The model types which can be converted include:

  • A single Markov model within a larger TreeAge Pro model; and

  • A decision tree with two or more strategies that are each a single Markov model.

Converting a supported model will create a stand-alone Excel workbook with a number of worksheets. The model outputs are calculated based on formulas which are embedded in the workbook. These formulas can be reviewed and edited directly in each cell. The TreeAge Pro parameters are converted directly to an Inputs worksheet within Excel. When model inputs are updated the Excel model will recalculate the model outputs and summary sheets.

More details about Markov models can be found in the following sections: