Skip to content

First run

In this tutorial, you will download an Autory configuration file, perform your first run, and look at the results.

  1. Download this example Autory model and open it in Excel. Depending on your Windows settings, you might have to unblock the file.

  2. Look at the Hierarchy sheet. This model has a simple hierarchy tree, with only two hierarchy nodes:

    The hierarchy

    The Hierarchy table has one column per level, from the highest level on the left to the lowest on the right. Here, GroupCompany is level 2 and Subsidiaries is level 1. The Properties → 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 --> o2

    Read more about hierarchies here.

  3. Look at the EntryPoints sheet.

    The entry points

    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
  4. Look at the Variable Library sheet.

    The variable library

    This table defines the variables and variable sets that will be used in the calculations.

    • The Hello.h1.Generic variable set contains two variables, HelloVariable and MyFirstValue.
    • The World.h1.Generic variable set contains two variables, WorldVariable and MyFirstValue.
    • The Summary.h2.Generic variable set contains four variables.
    • The mapProjectionValues function creates new precedent projection nodes and reads their results. Read more about mapping data between projection nodes here.
    • The TableLookup function reads specific cells from a table. Read more about table lookups here.
  5. Look at the RunControl sheet.

    The Run Control sheet

    • The RunHierarchyLevel and RunHierarchyPath determine which hierarchy node on the hierarchy tree will be the starting point for the run. In this case, we have selected the Galaxy Holdings node.
    • The RunStartValnType determines which valuation type will be the starting point for the run. In this case, we have selected the Summary valuation 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 RunControl sheet.
        • uses the Summary.h2.Generic variable set.
        • reads the value of HelloVariable from projection node 2 into its own HelloVariable variable.
        • reads the value of WorldVariable from projection node 3 into its own WorldVariable variable.
        • concatenates the HelloVariable and WorldVariable variables into the HelloWorldVariable variable.
        • reads the values of MyFirstValue from projection nodes 2 and 3 and sums them into its own MyFirstValue variable.
      • Projection node 2 …
        • is a precedent created by the HelloVariable variable from the Summary.h2.Generic variable set.
        • uses the Hello.h1.Generic variable set.
        • contains the string "Hello" in the HelloVariable variable.
        • looks up the value 1 from table t_MyFirstValues and stores it in the MyFirstValue variable.
      • Projection node 3 …
        • is a precedent created by the WorldVariable variable from the Summary.h2.Generic variable set.
        • uses the World.h1.Generic variable set.
        • contains the string "World" in the WorldVariable variable.
        • looks up the value 2 from table t_MyFirstValues and stores it in the MyFirstValue variable.
  6. 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.
  7. In the RunControl sheet, look for the Results output folder setting. 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
    
  8. Open the runs subfolder, then open the newest file with a name like run--YYYYMMDD-HHMMSS--abcdefg.xlsx. This is the summary of the run. Every time you use Save & run, a new run summary is created.

    The summary file

  9. Find the row whose Hierarchy path is Galaxy Holdings and whose Variable set name is Summary.h2.Generic. Click its link in the Link to results workbook column. This opens the calculation workbook for the summary node.

  10. Look at the pn_a sheet.

    The results workbook

    Here you will see the results of the calculations for projection node 1 as described above.

  11. Look at the MappedVariables sheet. 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.

  12. 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.

    View the workbook recap diagram.