{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Hierarchy","User EntryPoints","EntryPoints","User Variable Library","Variable Library","User VariableSet Inheritance","RunMultiple","RunControl","VariableSet Inheritance","Tables","VersionControl","Globals","Variables","Settings","Lists","VCS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":64,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hierarchy","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,1]
[null,"HierarchyTreeStart","Group",null,null,"HierarchyProperties→","property1"]
[null,null,"ExampleHoldings",null,null,null,123]

{"sheet":"User EntryPoints","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Hierarchy entry points (user)",null,null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"sortUserEntryPoints\"\")\",\"Sort entry points\")","v":"Sort entry points"},null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"UpdateDropDownLists\"\")\",\"Update drop-down lists\")","v":"Update drop-down lists"}]
[]
[null,null,"MatchType","Level","Path","Name","ValnType","VariableSet","Comment"]

{"sheet":"EntryPoints","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Hierarchy entry points",null,null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"sortMasterEntryPoints\"\")\",\"Sort entry points\")","v":"Sort entry points"},null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"UpdateDropDownLists\"\")\",\"Update drop-down lists\")","v":"Update drop-down lists"}]
[]
[null,null,"MatchType","Level","Path","Name","ValnType","VariableSet","Comment"]
[null,null,"Level",1,null,null,"Summary","VarSetOne"]

{"sheet":"User Variable Library","index":3,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Return to Index"]
[null,null,null,null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"UpdateDropDownLists\"\")\",\"Update drop-down lists\")","v":"Update drop-down lists"}]
[null,null,{"$f":"COUNTA(userVarLib[VarName])","v":0}]
[null,null,"VariableSetName","VarName","Formula","Comment"]

{"sheet":"Variable Library","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"openDocs\"\")\",\"Documentation\")","v":"Documentation"},null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"UpdateDropDownLists\"\")\",\"Update drop-down lists\")","v":"Update drop-down lists"}]
[null,null,{"$f":"COUNTA(masterVarLib[VarName])","v":8}]
[null,null,"VariableSetName","VarName","Formula","Comment"]
[null,null,"VarSetOne","VectorA","t*t + 2*t + 1","4, 9, 16, …, 81, 100, 121"]
[null,null,"VarSetOne","VectorB","t*t - 2*t + 1","0, 1, 4, …, 49, 64, 81"]
[null,null,"VarSetOne","ScalarA","sum(VectorA)","Sum VectorA over all time steps (no slicing):\n= 4 + 9 + 16 + … + 81 + 100 + 121"]
[null,null,"VarSetOne","ScalarB","sum(slice(VectorA, 2, 5))","Sum VectorA over time steps t=2 to t=5\n= 9 + 16 + 25 + 36"]
[null,null,"VarSetOne","ScalarC","sum(VectorA[2]:VectorA[5])","Same as ScalarB, using alternative (error-prone) slice syntax"]
[null,null,"VarSetOne","ScalarD","sum(VectorA[2:5])","Same as ScalarB, using alternative (better) slice syntax"]
[null,null,"VarSetOne","VectorC","sum(slice(VectorA, 1, t))","Sum VectorA over different time ranges at each time step:\n@t=1: 4\n@t=2: 4 + 9\n@t=3: 4 + 9 + 16\netc."]
[null,null,"VarSetOne","ScalarE","sumOverIndex(6, 8, VectorA, VectorB)","This is shorthand for:\n= sum(slice(VectorA, 6, 8)) + sum(slice(VectorB, 6, 8))\n= (49 + 64 + 81) + (25 + 36 + 49)"]

{"sheet":"User VariableSet Inheritance","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"VariableSet inheritance (user)",{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"UpdateDropDownLists\"\")\",\"Update drop-down lists\")","v":"Update drop-down lists"}]
[]
[null,null,"VariableSet","InheritFrom"]

{"sheet":"RunMultiple","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Options"]
[null,null,"Name","Value","Description"]
[null,null,"parallel",1,"The number of simultaneous runs to do. This makes better use of multi-core CPUs when there are multiple runs."]
[null,null,"PreRunScripts",null,"Run these commands before any of the models. Separate multiple command by newlines. If one fails, the subsequent scripts are not executed. The working directory is the folder in which this workbook resides."]
[null,null,"PostRunScripts",null,"Run these commands after all of the models. Separate multiple command by newlines. If one fails, the subsequent scripts are not executed. The working directory is the folder in which this workbook resides."]
[]
[null,null,"Runs"]
[null,null,"General",null,null,null,"RunControl overrides"]
[null,"Active","Group","Weight","Description","RunControl →","AutoryEngine","OutputFolder","RunDate","RunHierarchyLevel","RunHierarchyPath","RunStartValnType"]
[null,false,0,0,"Example 1",null,"Python-Excel","%temp%\\autory\\example1","2025-12-31",1,"ExampleHoldings","Summary"]
[null,false,0,1,"Example 2",null,"Python-Excel","%temp%\\autory\\example2","2026-12-31",1,"ExampleHoldings","Summary"]

{"sheet":"RunControl","index":7,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Value"]
[]
[null,null,"Core run parameters"]
[]
[null,null,"RunDate","2025-12-31"]
[]
[null,null,"RunHierarchyLevel",1]
[null,null,"RunHierarchyPath","ExampleHoldings"]
[null,null,"RunStartValnType","Summary"]
[]
[null,null,"Run settings"]
[]
[null,null,"Results output folder","%temp%\\autory"]
[]
[]
[null,null,"Run filters"]
[]
[null,null,"RunProjectionNodesFilter",true]
[]
[]
[null,null,"Database output settings"]
[]
[null,null,"OutputProjectionNodeFilter",true]
[null,null,"OutputTimeStepFilter",true]
[]
[]
[null,null,"Loop filters"]
[]
[null,null,"Write iterations to workbook",true]
[null,null,"Iteration filter",true]
[null,null,"Time step filter",true]
[]
[]
[null,null,"Scripts"]
[]
[null,null,"Pre-run scripts"]
[null,null,"Post-run scripts"]
[]
[]
[null,null,"Advanced settings"]
[]
[null,null,"Run children of RunHierarchyPath",false]
[null,null,"AutoryEngine","Python-Excel"]
[null,null,"ExcelVisible",false]
[null,null,"LogLevel","Info"]
[null,null,"AutoryAppDir"]

{"sheet":"VariableSet Inheritance","index":8,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"VariableSet inheritance",{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"UpdateDropDownLists\"\")\",\"Update drop-down lists\")","v":"Update drop-down lists"}]
[]
[null,null,"VariableSet","InheritFrom"]

{"sheet":"Tables","index":9,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"refreshTablesSheet\"\")\",\"Refresh tables list\")","v":"Refresh tables list"},null,null,"ExampleTable"]
[]
["List of tables:",null,null,"A","B","C"]
["ExampleTable",null,null,1,2,3]
[null,null,null,4,5,6]
[null,null,"."]

{"sheet":"VersionControl","index":10,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Version control"]
[]
[]
[null,null,null,"This ensures compatibility to the latest installed runner module by running patches.\r\nPlease contact your administrator if you experience any issues during or after this process."]
[]
[null,null,null,".\\VersionControl\\deployed\\vcs-v0.0.1.zip"]

{"sheet":"Globals","index":11,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Global variables (accessible from variable library)",null,null,null,null,null,null,null,"Hierarchy Properties",null,null,null,null,null,"Global projection variables (these are present in all Projections)"]
[]
[null,null,"Variable","Value","Formula","Description","DataType",null,null,null,"Name","DataType","ResolveMulti",null,null,null,"VarName","Formula"]
[null,null,null,null,null,null,null,null,null,null,"property1","NotDate","Error",null,null,null,"t","SequenceFrom1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","EOMONTH(ProjectionStartDate,t-1)"]

{"sheet":"Variables","index":12,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"COUNTA(Variables[VarName])","v":8}]
[null,null,"VarName","Description","VarType","Group","SubGroup","Format","ResolveAggregation","LoopFilter"]
[null,null,"VectorA",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"VectorB",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"VectorC",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"ScalarA",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"ScalarB",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"ScalarC",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"ScalarD",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"ScalarE",null,"Constant","Main","Main","Default","Sum",true]

{"sheet":"Settings","index":13,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Valuation Types",null,null,null,null,null,null,null,null,"t_VarFormatGroup",null,null,null,null,null,null,"t_VarGroup",null,null,null,null,"t_VarSubGroup"]
[]
[null,null,"ValnType","OutputIncrementMonths","ProjectionStartType","ProjectionStartFormula","ProjectionEndType","ProjectionEndFormula",null,null,null,"VarFormatGroup","VarFormatString","TestValue","TestFormat",null,null,null,"VarGroup","Color",null,null,null,"VarSubGroup","VarSubGroupShading"]
[null,null,"Summary",12,"EarliestPrecedent",null,"Periods",10,null,null,null,"Default","General","-1.300",{"$f":"TEXT(N6,M6)","v":"-1.3"},null,null,null,"Main",5,null,null,null,"Main",0.4]
[]
[null,"."]

{"sheet":"Lists","index":14,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"TableLookups","ListForLookup",null,null,null,"UniqueVariableSetNames",null,null,null,"ValnTypesStart",null,null,null,"VarGroupStart",null,null,null,"VarSubGroupStart",null,null,null,"VarFormatGroupStart",null,null,null,"HierarchyUniqueNamesCountStart"]
[null,"↓ProjectionSettings↓",null,null,null,null,"VarSetOne",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HierarchyUniqueNamesStart"]
[null,"valnType","ValnTypes"]
[null,"varName","VarNames"]
[null,"↑ProjectionSettings↑"]
[]
[null,"↓HierarchyNames↓"]
[null,"Group","UniqueHNamesLookup"]
[null,"↑HierarchyNames↑","UniqueHNamesLookup"]
[null,null,"UniqueHNamesLookup"]
[null,"↓HierarchyProperties↓"]
[null,"property1"]
[null,"↑HierarchyProperties↑"]
[null,null,"\"Override validation and enter appropriate value\""]
[null,"↓Non-ListLookups (override validation and enter appropriate value)↓","\"Override validation and enter appropriate value\""]
[null,"RunDate","\"Override validation and enter appropriate value\""]
[null,"RunDateM","\"Override validation and enter appropriate value\""]
[null,"RunDateYYYYMM","\"Override validation and enter appropriate value\""]
[null,"ValnDate","\"Override validation and enter appropriate value\""]
[null,"ValnDateM","\"Override validation and enter appropriate value\""]
[null,"ValnDateYYYYMM","\"Override validation and enter appropriate value\""]
[null,"ProjYear","\"Override validation and enter appropriate value\""]
[null,"ProjMonths","\"Override validation and enter appropriate value\""]
[null,"Date","\"Override validation and enter appropriate value\""]
[null,"DateM","\"Override validation and enter appropriate value\""]
[null,"ProjDateYYYYMM"]
[null,"↑Non-ListLookups (override validation and enter appropriate value)↑"]

{"sheet":"VCS","index":15,"n_rows":72,"n_cols":49,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"List of workbook tables",null,null,null,null,null,null,null,null,"Version control system metadata",null,null,null,null,null,null,null,"Version control system table import log",null,null,null,null,null,null,null,null,null,null,null,"VCS Workbook Table Metadata",null,null,null,null,null,"VCS Workbook Table Metadata import log",null,null,null,null,null,null,null,null,"Patches ran on this workbook"]
[null,null,null,"Main output directory:",".\\VersionControl",null,"Deployment path:",{"$f":"vcsOutputDirectory&\"\\deployed\\vcs-v0.0.1.zip\"","v":".\\VersionControl\\deployed\\vcs-v0.0.1.zip"}]
[null,null,"Table","Type","Output directory","Include data","Include headers","Deploy",null,null,null,"Table","Column","OldNames","Ignored","Deleted",null,null,null,"Table","Timestamp","Commit","Tag","Repo","Path","FileHash","Headers","Data",null,null,null,"Table","OldNames","Deleted",null,null,null,"Timestamp","Commit","Tag","Repo","Path","FileHash",null,null,null,"PatchNr","PatchName","Timestamp"]
[null,null,"masterVarLib","ListObject",".\\varlibs",true,true,true,null,null,null,"masterVarLib","VariableSetName",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"chooseHierarchyButtons","2020-10-12T21:59:30"]
[null,null,"userVarLib","ListObject",null,null,null,null,null,null,null,"masterVarLib","VarName",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,"SaveAndRunButton","2020-10-12T21:59:30"]
[null,null,"GlobalVariables","ListObject",null,null,null,null,null,null,null,"masterVarLib","Formula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,"ValnTypesValidationLists","2020-10-12T21:59:30"]
[null,null,"HierarchyPropertiesSettings","ListObject",null,null,null,null,null,null,null,"masterVarLib","Comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,"varnames_validation","2020-10-12T21:59:30"]
[null,null,"GlobalProjectionVariables","ListObject",null,null,null,null,null,null,null,"Variables","VarName",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,"varlibsbuttons","2020-10-12T21:59:30"]
[null,null,"Variables","ListObject",".\\varlibs",true,true,true,null,null,null,"Variables","Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,"remove_master_varlib_scope_names","2020-10-12T21:59:30"]
[null,null,"ValuationTypes","ListObject",null,null,null,null,null,null,null,"Variables","VarType",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,"hLevel_DropDown","2020-10-12T21:59:30"]
[null,null,"t_VarFormatGroup","ListObject",null,null,null,null,null,null,null,"Variables","Group",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,"master_varlib_hLevelsList","2020-10-12T21:59:30"]
[null,null,"t_VarGroup","ListObject",null,null,null,null,null,null,null,"Variables","SubGroup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"remove_map_to_set_conditional_formatting","2020-10-12T21:59:30"]
[null,null,"t_VarSubGroup","ListObject",null,null,null,null,null,null,null,"Variables","Format",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"remove_GenerichLevelNameInd","2020-10-12T21:59:30"]
[null,null,"userHierarchyEntryPoints","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"valnTypes_deprecate_genericValnTypes","2020-10-12T21:59:30"]
[null,null,"masterHierarchyEntryPoints","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,"master_varlib_versioncontrol_buttons","2020-10-12T21:59:30"]
[null,null,"userVariableSetInheritance","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,"run_control_cleanup","2020-10-12T21:59:30"]
[null,null,"RunMultipleOptions","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,"settings_updates","2020-10-12T21:59:30"]
[null,null,"RunMultipleRuns","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,"globals_cleanup","2020-10-12T21:59:30"]
[null,null,"masterVariableSetInheritance","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,"varLibs_Checks","2020-10-12T21:59:30"]
[null,null,"ExampleTable","ListObject",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,"updateVBA_button","2020-10-12T21:59:30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,"rename_userVarLib","2020-10-12T21:59:30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,"Add version control system and patches sheets","2020-10-12T21:59:47"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,"global runtime split between values and formulae","2020-11-02T19:15:42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"VCS tables updates","2020-11-10T10:24:27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,"VCS workbook tables","2020-12-27T23:10:52"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,"VCS import all tables button","2020-12-27T23:10:52"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"Hierarchy entry points","2020-12-27T23:10:53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,"move hierarchy lookups to lists sheet","2020-12-27T23:10:53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,"remove varNumber from varlibs","2020-12-28T08:52:09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,"variable Set Inheritance moved from variable libraries","2020-12-29T17:54:22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,"variable Set Inheritance moved from variable libraries","2020-12-29T17:58:12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,"hierarchy tree restructure","2021-01-04T12:12:39"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,"Sort links and variableSet unique list updates","2021-02-10T16:17:50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,"Update hyperlink to update tables lookup list","2021-02-10T16:17:50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"vcs workbook table history input name","2021-03-09T13:55:37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,"description for log table","2021-03-09T13:55:37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,"vcs updated udfs","2021-04-03T09:23:23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,"description for log table","2021-06-15T15:50:33"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,"Remove functions sheet","2021-06-18T23:25:45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,"Remove functions sheet","2021-06-18T23:26:21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,"Use old automatic formula expansion option","2021-11-09T18:06:20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,"Lookup lists","2022-01-05T12:40:01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,"Add Run child nodes","2022-01-23T16:19:42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,"Add out of tree dependencies","2023-03-08T09:28:54"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,"Remove jsonOutputIndicator_deprecated","2023-09-06T17:19:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"Remove csvOutputIndicator","2023-09-06T17:19:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,"Create the `RunMultiple` sheet","2023-11-29T14:00:39"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,"Re-assign the macro for the 'Save & Run' button.","2023-12-11T13:37:11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,"Add AutoryEngine, ExcelVisible and DebugLevel options in Run Control.","2023-12-11T14:31:10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,"Add the new `RunProjectionNodesFilter` option to RunControl and remove the options which it replaces.","2024-10-02T15:15:34"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,"Add the new `OutputProjectionNodeFilter` and `OutputTimeStepFilter` options to RunControl and remove the options which they replace.","2024-10-02T15:15:37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,"Add the `ResolveAggregation` column to all `Variables*` tables. Add the `LoopFilter` column to all `Variables*` tables. Add the `Loop*` options to RunControl.","2024-10-02T15:15:38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,"Add pre-run scripts and post-run scripts to RunControl","2024-10-02T15:15:38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148,"Add AutoryAppDir to RunControl","2024-10-02T15:15:38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,"Remove runner_dependency from RunControl","2024-10-02T23:31:45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"Update the 'UpdateWorkbookVBA' button.","2024-10-03T10:27:22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,"Remove 'runLogOutputFolder', 'jsonOutputFolder', 'preRunValidationsInd', and 'runCreateNodeFiles' from RunControl.","2024-10-03T11:22:10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,"Remove 'LoopWriteIterationsToSqlite' from RunControl.","2024-11-25T09:16:34"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153,"Remove 'jsonOutputIndicator' from RunControl.","2024-11-25T16:45:19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154,"Rename `output_folder` to `OutputFolder`.","2024-11-28T22:59:19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,"Remove 'IgnoreOutOfTreeDependencies' from RunControl.","2025-01-09T09:26:43"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156,"Remove the `Output` sheet if it still exists.","2025-03-19T14:17:26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157,"Update the `RunMultiple` sheet.","2025-03-19T14:17:26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158,"`RunMultiple` data validations","2025-03-20T15:28:45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159,"Remove UseOldAutomaticFormulaExpansion from RunControl.","2025-04-16T15:29:37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,"For each `ValuationTypes` table, add columns `ProjectionStartType` and `ProjectionStartFormula` and combine the `EndDate` and `NrOfPeriods` columns into a single column named `ProjectionEndFormula`.","2025-10-31T08:31:10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161,"Delete the \"Index\" sheet.","2025-11-11T08:39:20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,"Add conditional formatting to the `ProjectionStartFormula` column of each `ValuationTypes` table.","2025-11-26T08:28:37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,163,"Remove the `default` and `default chosen` columns from the `RunControl` sheet.","2025-11-26T08:28:38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,164,"Remove buttons from the `Variables` and `... Variable Library` sheets.","2026-01-05T14:45:31"]