ModelStats

A free GitHub account is required to access the program code in this repository; send us your GitHub username.

Module to support uncertainty calculations. If you make improvements, please share them here. The repository is not yet public, so the code should not be shared outside this repository and your own dynamic models.

ModelStats.bas: For use when looking for asymptotic estimates of confidence (CB) bands for model response end-points. Other options are possible.

• Run a fit in the Fitting window and generate a Fitting Report that indicates the parameter estimates and fitting statistics. Include this in your Excel file as ‘Fitting Report’.
• Insert the code in a VBA Module inside the target model that contains the scenarios and data.
• Insert a reference in your VBA project to ModelAutomation.
• Use your existing scenarios or generate a new list of scenarios (e.g. using a Full Factorial run) and place all intended scenarios on your model scenarios tab.

• Then invoke the code from your own code or by pressing a macro button. The main module to invoke is:

  • RunCB - generates end-point results on a new Results worksheet including confidence bands in the rightmost columns.