{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["RunMultiple","RunControl","Hierarchy","User EntryPoints","EntryPoints","User Variable Library","Variable Library","User VariableSet Inheritance","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":"RunMultiple","index":0,"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","","vba","%temp%\\autory\\example1","2018/12/31",3,"ExampleHoldings","Summary"]
[null,false,0,1,"Example 2","","pyxl","%temp%\\autory\\example2","2019/12/31",3,"ExampleHoldings","Summary"]

{"sheet":"RunControl","index":1,"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","2021-01-31"]
[]
[null,null,"RunHierarchyLevel",2]
[null,null,"RunHierarchyPath","NodeA|NodeB|NodeD"]
[null,null,"RunStartValnType","Examples"]
[]
[null,null,"Run settings"]
[]
[null,null,"Results output folder","%temp%\\Autory\\projection-results-to-table-examples"]
[]
[]
[null,null,"Run filters"]
[]
[null,null,"RunProjectionNodesFilter","AND(hLevel>=1,hLevel<=3)"]
[]
[]
[null,null,"Database output settings"]
[]
[null,null,"OutputProjectionNodeFilter","AND(hLevel>=2,hLevel<=2,valnType=\"Summary\")"]
[null,null,"OutputTimeStepFilter","AND(t>(24253-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate))),MOD(t-1-(24253-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate))),12)=0,t<=480+MAX(0,(24253-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate)))))"]
[]
[]
[null,null,"Loop filters"]
[]
[null,null,"Write iterations to workbook",true]
[null,null,"Iteration filter",true]
[null,null,"Time step filter","t=1"]
[]
[]
[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","Warning"]
[null,null,"AutoryAppDir"]

{"sheet":"Hierarchy","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,4,3,2,1]
[null,"HierarchyTreeStart","LevelA","LevelB","LevelC","LevelD",null,"HierarchyProperties→","PropA","PropB"]
[null,null,"NodeA","NodeB","NodeD","NodeF",null,null,1,true]
[null,null,"NodeA","NodeB","NodeE","NodeF",null,null,2,false]
[null,null,"NodeA","NodeC","NodeD","NodeF",null,null,3,false]
[null,null,"NodeA","NodeC","NodeE","NodeF",null,null,4,true]

{"sheet":"User EntryPoints","index":3,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"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,null,null,null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"outputUniqueVarDefnSets\"\")\",\"Refresh VariableSet lookup list\")","v":"Refresh VariableSet lookup list"}]
[null,null,"MatchType","Path","Level","Name","ValnType","VariableSet","Comment"]

{"sheet":"EntryPoints","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"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,null,null,null,null,{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"outputUniqueVarDefnSets\"\")\",\"Refresh VariableSet lookup list\")","v":"Refresh VariableSet lookup list"}]
[null,null,"MatchType","Level","Path","Name","ValnType","VariableSet","Comment"]
[null,null,"Level",2,null,null,"Examples",{"$f":"masterHierarchyEntryPoints[[#This Row],[ValnType]]&masterHierarchyEntryPoints[[#This Row],[Level]]","v":"Examples2"}]
[null,null,"Level",4,null,null,"Data",{"$f":"masterHierarchyEntryPoints[[#This Row],[ValnType]]&masterHierarchyEntryPoints[[#This Row],[Level]]","v":"Data4"}]
[null,null,"Level",3,null,null,"Data",{"$f":"masterHierarchyEntryPoints[[#This Row],[ValnType]]&masterHierarchyEntryPoints[[#This Row],[Level]]","v":"Data3"}]
[null,null,"Level",2,null,null,"Data",{"$f":"masterHierarchyEntryPoints[[#This Row],[ValnType]]&masterHierarchyEntryPoints[[#This Row],[Level]]","v":"Data2"}]
[null,null,"Level",1,null,null,"Data",{"$f":"masterHierarchyEntryPoints[[#This Row],[ValnType]]&masterHierarchyEntryPoints[[#This Row],[Level]]","v":"Data1"}]

{"sheet":"User Variable Library","index":5,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"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,"VarName","VariableSetName","Formula","Comment"]

{"sheet":"Variable Library","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Return to Index"]
[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,"VarName","VariableSetName","Formula","Comment"]
[null,null,"VarA","DataAll","100*hLevel + 10*propA + t","Example data for all levels"]
[null,null,"VarB","Data4","hLevel * t * t + propA * t + 10","Example data for level 4"]
[null,null,"VarC","Data3","hLevel * t * t + propA * t + 20","Example data for level 3"]
[null,null,"VarD","Data2","hLevel * t * t + propA * t + 30","Example data for level 2"]
[null,null,"VarE","Data1","hLevel * t * t + propA * t + 40","Example data for level 1"]
[null,null,"Table1","Examples2","projectionResultsToTable(\n  createProjectionNodes(\n    \"Data\",\n    DATE(2024,1,1),\n    \"hLevel=1\",\n    TRUE\n  ),\n)","This will create a single projection node:\n- NodeA > NodeB > NodeD > NodeF.\n\nAll results are included in the table.\nAll hierarchy properties are included in the table.\nNo SQL query is performed.\nNo data type transformation is done."]
[null,null,"Table2","Examples2","projectionResultsToTable(\n  createProjectionNodes(\n    \"Data\",\n    DATE(2024,1,1),\n    \"hLevel=2\",\n    FALSE\n  ),\n  array(\"LevelB\", \"LevelC\"),\n  array(\"t\", \"VarD\"),\n)","This will create a projection node on every hierarchy node on level 2:\n- NodeA > NodeB > NodeD\n- NodeA > NodeB > NodeE\n- NodeA > NodeC > NodeD\n- NodeA > NodeC > NodeE\n\nOnly variables `t` and `VarD` are included.\nOnly hierarchy properties `LevelB` and `LevelC` are included.\nNo SQL query is performed.\nNo data type transformation is done."]
[null,null,"Table3","Examples2","projectionResultsToTable(\n  createProjectionNodes(\n    \"Data\",\n    DATE(2024,1,1),\n    \"AND(hLevel=1, LevelC='NodeE')\",\n    FALSE\n  ),\n  FALSE,\n  TRUE,\n  \"WHERE t=1\"\n)","This will create a projection node on every hierarchy node on level 1 that is also a child of NodeE:\n- NodeA > NodeB > NodeE > NodeF\n- NodeA > NodeC > NodeE > NodeF\n\nAll results are included in the table.\nNo properties are included in the table.\nSQL is used to keep only the first time step of each projection node.\nNo data type transformation is done."]
[null,null,"Table4","Examples2","projectionResultsToTable(\n  createProjectionNodes(\n    \"Data\",\n    DATE(2024,1,1),\n    \"AND(hLevel=1, PropA=2)\",\n    FALSE\n  ),\n)","This will create a projection node on every hierarchy node on level 1 where PropA is 2:\n- NodeA > NodeB > NodeE > NodeF\n\nAll results are included in the table.\nAll hierarchy properties are included in the table.\nNo SQL query is performed.\nNo data type transformation is done."]
[null,null,"Table5","Examples2","projectionResultsToTable(array())","No projection nodes will result in an empty table."]
[]
[]
[null,null,null,null,"`"]

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

{"sheet":"VariableSet Inheritance","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"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"]
[null,null,"Data4","DataAll"]
[null,null,"Data3","DataAll"]
[null,null,"Data2","DataAll"]
[null,null,"Data1","DataAll"]

{"sheet":"Tables","index":9,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,"Return to Index"]
[]
[{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"refreshTablesSheet\"\")\",\"Refresh tables list\")","v":"Refresh tables list"}]
[]
["List of tables:"]

{"sheet":"VersionControl","index":10,"n_rows":6,"n_cols":4,"rows_kept":6,"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."]

{"sheet":"Globals","index":11,"n_rows":14,"n_cols":32,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Runtime accessible variables",null,null,null,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,null,null,"SQL Connections table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ForceUpdate:",false]
[null,null,"Variable","Description","DataType",null,null,null,"Variable","Value","Formula","Description","DataType",null,null,null,"Name","DataType","ResolveMulti",null,null,null,"VarName","Formula",null,null,null,"Name","Server","DataBase","User","Password"]
[null,null,"RunDate","Run date chosen in the run control","Date",null,null,null,null,null,null,null,null,null,null,null,"PropA","NotDate","FirstOccurrence",null,null,null,"t","SequenceFrom1",null,null,null,"Enter your sql connection here…"]
[null,null,"ProjectionStartDate","Projection start date for a given projection (can be different to the valuation date)","Date",null,null,null,null,null,null,null,null,null,null,null,"PropB","NotDate","FirstOccurrence",null,null,null,"Date","IF(t=1,ProjectionStartDate,EOMONTH(INDEX(Date,t-1),1))"]
[null,null,"ValnDate","Valuation date of a projection","Date"]
[null,null,"hLevel","Hierarchy level a projection","NotDate"]
[null,null,"ValnType","Valuation type of a projection","NotDate"]
[null,null,"VarName","Variable name in which a formula is defined","NotDate"]
[null,null,"ProjMonths","Number of projection months in a projection","Date"]
[null,null,"ProjYear","Projection year: YEAR(Date)","NotDate"]
[null,null,"ProjDateYYYYMM","Projection date in YYYYMM format: TEXT(Date,\"YYYYMM\")","NotDate"]

{"sheet":"Variables","index":12,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Return to Index"]
[null,null,{"$f":"COUNTA(Variables[VarName])","v":10}]
[null,null,"VarName","Description","VarType","Group","SubGroup","Format","ResolveAggregation","LoopFilter"]
[null,null,"VarA",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"VarB",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"VarC",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"VarD",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"VarE",null,"Proj","Main","Main","Default","Sum",true]
[null,null,"Table1",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"Table2",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"Table3",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"Table4",null,"Constant","Main","Main","Default","Sum",true]
[null,null,"Table5",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,"Return to Index"]
[]
[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,"Data",1,"EarliestPrecedent",null,"Periods",4,null,null,null,"Default","General",1,{"$f":"TEXT(N6,M6)","v":"1"},null,null,null,"Main",9,null,null,null,"Main",0.4]
[null,null,"Examples",1,"EarliestPrecedent",null,"Periods",4]
[null,"."]

{"sheet":"Lists","index":14,"n_rows":34,"n_cols":45,"rows_kept":34,"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",1,2,2,1,null,null,null,"HierarchyUniquePathsCountStart",1,2,4,4,null,null,null,"hPropertiesListCountStart",4,2]
[null,"↓ProjectionSettings↓",null,null,null,null,"DataAll",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HierarchyUniqueNamesStart","h4","h3","h2","h1",null,null,null,"HierarchyUniquePathsStart","h4","h3","h2","h1",null,null,null,"hPropertiesListStart","PropA","PropB"]
[null,"valnType","ValnTypes",null,null,null,"Data4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NodeA","NodeB","NodeD","NodeF",null,null,null,null,"NodeA","NodeA|NodeB","NodeA|NodeB|NodeD","NodeA|NodeB|NodeD|NodeF",null,null,null,null,1,true]
[null,"varName","VarNames",null,null,null,"Data3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NodeC","NodeE",null,null,null,null,null,null,"NodeA|NodeC","NodeA|NodeB|NodeE","NodeA|NodeB|NodeE|NodeF",null,null,null,null,2,false]
[null,"↑ProjectionSettings↑",null,null,null,null,"Data2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NodeA|NodeC|NodeD","NodeA|NodeC|NodeD|NodeF",null,null,null,null,3]
[null,null,null,null,null,null,"Data1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NodeA|NodeC|NodeE","NodeA|NodeC|NodeE|NodeF",null,null,null,null,4]
[null,"↓HierarchyNames↓",null,null,null,null,"Examples2"]
[null,"LevelA","UniqueHNamesLookup"]
[null,"LevelB","UniqueHNamesLookup"]
[null,"LevelC","UniqueHNamesLookup"]
[null,"LevelD"]
[null,"↑HierarchyNames↑"]
[]
[null,"↓HierarchyProperties↓","\"Override validation and enter appropriate value\""]
[null,"PropA","\"Override validation and enter appropriate value\""]
[null,"PropB","\"Override validation and enter appropriate value\""]
[null,"↑HierarchyProperties↑","\"Override validation and enter appropriate value\""]
[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"]
[null,"ProjMonths"]
[null,"Date"]
[null,"DateM"]
[null,"ProjDateYYYYMM"]
[null,"↑Non-ListLookups (override validation and enter appropriate value)↑"]

{"sheet":"VCS","index":15,"n_rows":70,"n_cols":49,"rows_kept":70,"cut":false,"hidden":true,"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&\"\\dist\\vcs-v0.0.1.zip\"","v":"..\\VersionControl\\dist\\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,"userHierarchyEntryPoints","ListObject",null,null,null,null,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-12T22:33:13"]
[null,null,"masterHierarchyEntryPoints","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-12T22:33:13"]
[null,null,"userVarLib","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-12T22:33:13"]
[null,null,"masterVarLib","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-12T22:33:13"]
[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,104,"varlibsbuttons","2020-10-12T22:33:13"]
[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,105,"remove_master_varlib_scope_names","2020-10-12T22:33:13"]
[null,null,"GlobalVariables","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,106,"hLevel_DropDown","2020-10-12T22:33:13"]
[null,null,"HierarchyPropertiesSettings","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,107,"master_varlib_hLevelsList","2020-10-12T22:33:13"]
[null,null,"hLevelNames","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,108,"remove_map_to_set_conditional_formatting","2020-10-12T22:33:13"]
[null,null,"RunTimeVariables","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,109,"remove_GenerichLevelNameInd","2020-10-12T22:33:13"]
[null,null,"GlobalProjectionVariables","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-12T22:33:13"]
[null,null,"sqlConnections","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-12T22:33:13"]
[null,null,"Variables","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-12T22:33:13"]
[null,null,"ValuationTypes","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-12T22:33:13"]
[null,null,"t_VarFormatGroup","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-12T22:33:13"]
[null,null,"t_VarGroup","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-12T22:33:13"]
[null,null,"t_VarSubGroup","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-12T22:33:13"]
[null,null,"CustomFunctionsTable","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,117,"rename_userVarLib","2020-10-12T22:33:13"]
[null,null,"t_MyFirstValues","Range",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-12T22:33:13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-12-29T20:31:15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-12-29T20:31:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-29T20:31:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-29T20:31:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-29T20:31:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-29T20:31:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-29T20:31:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-29T20:31:17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-04T11:05: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,128,"Sort links and variableSet unique list updates","2021-03-09T14:01:24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-03-09T14:01:24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-09T14:01:24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-09T14:01:24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-06-15T15:52:05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:52:06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","2022-03-02T12:04: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,135,"Use old automatic formula expansion option","2022-03-02T12:04:02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-03-02T12:04:02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-03-02T12:04:02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","2024-02-06T09:20: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,139,"Remove jsonOutputIndicator_deprecated","2024-02-06T09:20: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,140,"Remove csvOutputIndicator","2024-02-06T09:20: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,141,"Create the `RunMultiple` sheet","2024-02-06T09:20: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,142,"Re-assign the macro for the 'Save & Run' button.","2024-02-06T09:20: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,143,"Add AutoryEngine, ExcelVisible and DebugLevel options in Run Control.","2024-02-06T09:20:31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-05-14T12:12:32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-08-06T11:22:41"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-08-06T12:21: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,147,"Add pre-run scripts and post-run scripts to RunControl","2024-09-17T17:46: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,148,"Add AutoryAppDir to RunControl","2024-10-02T15:27:16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:44: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,150,"Update the 'UpdateWorkbookVBA' button.","2024-10-03T10:40:25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-03T13:15:08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:45:14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:55:14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-28T23:09:36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:39:04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:27:15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:27:15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-10-31T08:50:31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-10-31T08:50:31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:50:32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:55:31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:35: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,163,"Remove the `default` and `default chosen` columns from the `RunControl` sheet.","2025-11-26T08:35: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,164,"Remove buttons from the `Variables` and `... Variable Library` sheets.","2026-01-05T14:54:21"]