First run¶
In this tutorial, you will download an Autory configuration file, perform your first run, and look at the results.
-
Download this example Autory model and open it in Excel. Depending on your Windows settings, you might have to unblock the file.
-
Look at the
Hierarchysheet. This model has a simple hierarchy tree, with only two hierarchy nodes:
The
Hierarchytable has one column per level, from the highest level on the left to the lowest on the right. Here,GroupCompanyis level 2 andSubsidiariesis level 1. TheProperties →column marks where optional hierarchy node properties can be added.flowchart TB o1["Galaxy Holdings<br/>hLevel = 2<br/>hLevelName = #quot;GroupCompany#quot;"] o2["Planet Earth<br/>hLevel = 1<br/>hLevelName = #quot;Subsidiaries#quot;"] o1 --> o2Read more about hierarchies here.
-
Look at the
EntryPointssheet.
This table defines which variable sets will be used for each combination of hierarchy node and valuation type.
flowchart LR subgraph group1["Hierarchy nodes"] n1["Galaxy Holdings"] n2["Planet Earth"] end subgraph group2["Variable sets"] v1["Summary.h2.Generic"] v2["Hello.h1.Generic"] v3["World.h1.Generic"] end n1 -->|"Valuation type = Summary"| v1 n2 -->|"Valuation type = HelloValuationType"| v2 n2 -->|"Valuation type = WorldValuationType"| v3- The
Hello.h1.Genericvariable set is used for thePlanet Earthnode when theHelloValuationTypevaluation type is selected. - The
World.h1.Genericvariable set is used for thePlanet Earthnode when theWorldValuationTypevaluation type is selected. - The
Summary.h2.Genericvariable set is used for theGalaxy Holdingsnode when theSummaryvaluation type is selected.
- The
-
Look at the
Variable Librarysheet.
This table defines the variables and variable sets that will be used in the calculations.
- The
Hello.h1.Genericvariable set contains two variables,HelloVariableandMyFirstValue. - The
World.h1.Genericvariable set contains two variables,WorldVariableandMyFirstValue. - The
Summary.h2.Genericvariable set contains four variables. - The
mapProjectionValuesfunction creates new precedent projection nodes and reads their results. Read more about mapping data between projection nodes here. - The
TableLookupfunction reads specific cells from a table. Read more about table lookups here.
- The
-
Look at the
RunControlsheet.
- The
RunHierarchyLevelandRunHierarchyPathdetermine which hierarchy node on the hierarchy tree will be the starting point for the run. In this case, we have selected theGalaxy Holdingsnode. - The
RunStartValnTypedetermines which valuation type will be the starting point for the run. In this case, we have selected theSummaryvaluation type. - Therefore, the projection node tree for this run will look like this:
flowchart TB pn1["Projection node 1<br/>Hierarchy node: Galaxy Holdings<br/>Valuation type: Summary<br/>Variable set: Summary.h2.Generic<br/>.<br/>HelloWorldVariable = HelloVariable #38; #quot; #quot; #38; WorldVariable<br/>HelloVariable = mapProjectionValues(,#quot;HelloValuationType#quot;,1)<br/>WorldVariable = mapProjectionValues(,#quot;WorldValuationType#quot;,1)<br/>MyFirstValue = mapProjectionValues(,#quot;HelloValuationType#quot;,1) + mapProjectionValues(,#quot;WorldValuationType#quot;,1)"] pn2["Projection node 2<br/>Hierarchy node: Planet Earth<br/>Valuation type: HelloValuationType<br/>Variable set: Hello.h1.Generic<br/>.<br/>HelloVariable = #quot;Hello#quot;<br/>MyFirstValue = TableLookup(#quot;t_MyFirstValues#quot;,,#quot;MyFirstValue#quot;)"] pn3["Projection node 3<br/>Hierarchy node: Planet Earth<br/>Valuation type: WorldValuationType<br/>Variable set: World.h1.Generic<br/>.<br/>WorldVariable = #quot;World#quot;<br/>MyFirstValue = TableLookup(#quot;t_MyFirstValues#quot;,,#quot;MyFirstValue#quot;)"] pn1 --> pn2 pn1 --> pn3- Projection node 1 …
- is the initial projection node as selected on the
RunControlsheet. - uses the
Summary.h2.Genericvariable set. - reads the value of
HelloVariablefrom projection node 2 into its ownHelloVariablevariable. - reads the value of
WorldVariablefrom projection node 3 into its ownWorldVariablevariable. - concatenates the
HelloVariableandWorldVariablevariables into theHelloWorldVariablevariable. - reads the values of
MyFirstValuefrom projection nodes 2 and 3 and sums them into its ownMyFirstValuevariable.
- is the initial projection node as selected on the
- Projection node 2 …
- is a precedent created by the
HelloVariablevariable from theSummary.h2.Genericvariable set. - uses the
Hello.h1.Genericvariable set. - contains the string
"Hello"in theHelloVariablevariable. - looks up the value
1from tablet_MyFirstValuesand stores it in theMyFirstValuevariable.
- is a precedent created by the
- Projection node 3 …
- is a precedent created by the
WorldVariablevariable from theSummary.h2.Genericvariable set. - uses the
World.h1.Genericvariable set. - contains the string
"World"in theWorldVariablevariable. - looks up the value
2from tablet_MyFirstValuesand stores it in theMyFirstValuevariable.
- is a precedent created by the
- Projection node 1 …
- The
-
In the Autory Excel ribbon, click Save & run.
- If this is the first time starting a run, you will be prompted to enter a license key.
- If you need to stop the run before it finishes, see how to stop a run.
-
In the
RunControlsheet, look for theResults output foldersetting. The example uses%temp%\Autory\MyFirstRunOutput. Open that folder (CTRL+C,Win+R,CTRL+V,ENTER). After the run finishes, this folder contains:logs: run logs and a saved copy of the model.results: machine-readable results.runs: run summary workbooks.workbooks: calculation workbooks for reviewing results in Excel.
Here is the complete output from one example run. Timestamps and run IDs will differ each time you run the model.
MyFirstRunOutput/ ├── logs/ │ ├── run--20261015-200126--14763b1--model.xlsx │ └── run--20261015-200126--14763b1.AutoryLog ├── results/ │ └── Galaxy Holdingsǀh2/ │ └── Summaryǀ2020-12-31/ │ ├── properties.feather │ ├── scalars.feather │ └── time_vectors.feather ├── runs/ │ └── run--20261015-200126--14763b1.xlsx └── workbooks/ ├── HelloValuationTypeǀh1ǀGalaxy Holdings→Planet earthǀ2020-12-31.xlsx ├── Summaryǀh2ǀGalaxy Holdingsǀ2020-12-31.xlsx └── WorldValuationTypeǀh1ǀGalaxy Holdings→Planet earthǀ2020-12-31.xlsx -
Open the
runssubfolder, then open the newest file with a name likerun--YYYYMMDD-HHMMSS--abcdefg.xlsx. This is the summary of the run. Every time you use Save & run, a new run summary is created.
-
Find the row whose
Hierarchy pathisGalaxy Holdingsand whoseVariable set nameisSummary.h2.Generic. Click its link in theLink to results workbookcolumn. This opens the calculation workbook for the summary node. -
Look at the
pn_asheet.
Here you will see the results of the calculations for projection node 1 as described above.
-
Look at the
MappedVariablessheet. Here you will see the results from other projection nodes that were copied into this projection node. Click on any of the "Source" links above these tables to jump to the precedent projection node's workbook. -
To recap:
1. Run control sets where in the hierarchy the run should start.
2. Run control sets which valuation type to start with.
3. Each hierarchy node can have one entry point per valuation type.
4. Each entry point is mapped to a variable set in the variable library.