Glossary¶

The glossary explains terminology that may not be familiar to a new user to Autory.

Variable¶

A variable is simply a name associated with a formula. See https://en.wikipedia.org/wiki/Variable_(computer_science) .

Time Vector¶

A variable that directly or indirectly depends on t. Such a variable may have a different value at each time step of a projection node.

Formerly called a "Proj Variable" or "Projection Variable".

Scalar¶

A variable that does not depend on t. Such a variable may only have a single value in a given projection node.

Also known as a "Constant".

Valuation type¶

Note

Coming soon

Projection node¶

Note

Coming soon

Hierarchy node¶

Note

Coming soon

Calculation tree¶

Note

Coming soon

Autory inputs workbook¶

The Autory inputs workbook is the starting point for configuring an Autory model. It contains all the required components in order to build and execute the model:

Hierarchy of the calculations to be performed
Configuration tables that points to the sources of input files
Variable library that contains all variables and their formulae

Autory model¶

An Autory model may be specified as a JSON file, or as an Autory inputs workbook.

With the VBA-Python engine or VBA-only calculation engines, only Excel workbooks are supported. With the Python-Excel or Python-Julia engine, both Excel workbooks and JSON files are supported.

Calculation engines¶

The same Autory model can be executed by various calculation engines, as detailed below.

Python-based calculation engines¶

Python-Julia¶

The Python-Julia engine is in the pre-alpha phase. Calculations are offloaded to a Julia model, which is much faster than Excel. It can optionally output Excel workbooks for a transparent calculation audit trail.

Python-Excel¶

The Python engine is in the alpha-testing phase. It uses 100% Python (no VBA) for implementation. Calculations are performed in Excel and is therefore transparent to the user.

VBA-based calculation engines¶

VBA-Python¶

The VBA-Python engine is currently the most commonly used. It uses the same code base as the VBA-only engine, but some work is offloaded to Python, for example importing data from CSV files.

VBA-only¶

For ease of deployment, the model can be run using VBA and Excel only, although some functionality is not available in this version.