{"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":62,"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",null,"vba","%temp%\\autory\\example1","2018/12/31",3,"ExampleHoldings","Summary"]
[null,false,0,1,"Example 2",null,"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","2020-12-31"]
[]
[null,null,"RunHierarchyLevel",2]
[null,null,"RunHierarchyPath","Galaxy Holdings"]
[null,null,"RunStartValnType","Summary"]
[]
[null,null,"Run settings"]
[]
[null,null,"Results output folder","%temp%\\Autory\\MyFirstRunOutput"]
[]
[]
[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>(24252-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate))),MOD(t-1-(24252-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate))),12)=0,t<=480+MAX(0,(24252-(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",true]
[null,null,"AutoryEngine","Python-Excel"]
[null,null,"ExcelVisible",false]
[null,null,"LogLevel","Warning"]
[null,null,"AutoryAppDir"]

{"sheet":"Hierarchy","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,2,1]
[null,"HierarchyTreeStart","GroupCompany","Subsidiaries",null,null,null,"HierarchyProperties→"]
[null,null,"Galaxy Holdings","Planet earth"]

{"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":8,"n_cols":9,"rows_kept":8,"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 and name",2,null,"Galaxy Holdings","Summary","Summary.h2.Generic"]
[null,null,"Level and name",1,null,"Planet earth","HelloValuationType","Hello.h1.Generic"]
[null,null,"Level and name",1,null,"Planet earth","WorldValuationType","World.h1.Generic"]

{"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":12,"n_cols":6,"rows_kept":12,"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,{"$f":"COUNTA(masterVarLib[VarName])","v":8}]
[null,null,"VarName","VariableSetName","Formula","Comment"]
[null,null,"HelloWorldVariable","Summary.h2.Generic","HelloVariable & \" \" & WorldVariable"]
[null,null,"HelloVariable","Summary.h2.Generic","mapProjectionValues(,\"HelloValuationType\",1)"]
[null,null,"WorldVariable","Summary.h2.Generic","mapProjectionValues(,\"WorldValuationType\",1)"]
[null,null,"MyFirstValue","Summary.h2.Generic","mapProjectionValues(,\"HelloValuationType\",1) + mapProjectionValues(,\"WorldValuationType\",1)"]
[null,null,"HelloVariable","Hello.h1.Generic","\"Hello\""]
[null,null,"MyFirstValue","Hello.h1.Generic","TableLookup(\"t_MyFirstValues\",,\"MyFirstValue\")"]
[null,null,"WorldVariable","World.h1.Generic","\"World\""]
[null,null,"MyFirstValue","World.h1.Generic","TableLookup(\"t_MyFirstValues\",,\"MyFirstValue\")"]

{"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":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":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,"Return to Index"]
[]
[{"$f":"HYPERLINK(\"#runFromHyperlink(\"\"refreshTablesSheet\"\")\",\"Refresh tables list\")","v":"Refresh tables list"},null,null,"t_MyFirstValues"]
[]
["List of tables:",null,null,{"$f":"E5&\"|\"&F5","v":"valnType|Subsidiaries"},"valnType","Subsidiaries","MyFirstValue"]
[null,null,null,{"$f":"E6&\"|\"&F6","v":"HelloValuationType|Planet earth"},"HelloValuationType","Planet earth",1]
[null,null,null,{"$f":"E7&\"|\"&F7","v":"WorldValuationType|Planet earth"},"WorldValuationType","Planet earth",2]

{"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":26,"rows_kept":14,"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,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,"ForceUpdate:",false]
[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,"RunDateM",null,"YEAR(RunDate)*12+MONTH(RunDate)","Months index of the RunDate (defined in RunControl)","NotDate",null,null,null,"group_id","Date","Min",null,null,null,"t","SequenceFrom1",null,null,null,"Enter your sql connection here…"]
[null,null,"RunDateT",null,"YEAR(RunDate)*12+MONTH(RunDate)-YEAR(ProjectionStartDate)*12-MONTH(ProjectionStartDate)+1","t-index that relates to the RunDate","NotDate",null,null,null,null,null,null,null,null,null,"Date","IF(t=1,ProjectionStartDate,EOMONTH(INDEX(Date,t-1),1))"]
[null,null,"RunDateYYYYMM",null,"TEXT(RunDate,\"YYYYMM\")","RunDate in YYYYMM format","NotDate",null,null,null,null,null,null,null,null,null,"ProjInd","IF(t=ProjMonths,0,1)"]
[null,null,"ProjectionStartDateM",null,"YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate)","Months index of the ProjectionStartDate","NotDate",null,null,null,null,null,null,null,null,null,"DateM","YEAR(Date)*12+MONTH(Date)"]
[null,null,"ProjectionStartDateYYYYMM",null,"TEXT(ProjectionStartDate,\"YYYYMM\")","ProjectionStartDate in YYYYMM format","NotDate",null,null,null,null,null,null,null,null,null,"EndOfIVP","IF(AND(MOD(MONTH(Date),IVP)=0,Date>ProjectionStartDate),1,0)"]
[null,null,"ValnDateM",null,"YEAR(ValnDate)*12+MONTH(ValnDate)","Months index of the valuation date","NotDate"]
[null,null,"ValnDateYYYYMM",null,"TEXT(ValnDate,\"YYYYMM\")","Valuation date in YYYYMM format","NotDate"]
[null,null,"ValnDateT",null,"YEAR(ValnDate)*12+MONTH(ValnDate)-YEAR(ProjectionStartDate)*12-MONTH(ProjectionStartDate)+1","t-index that relates to the ValuationDate","NotDate"]
[null,null,"IVP",12,null,null,"NotDate"]

{"sheet":"Variables","index":12,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Return to Index"]
[null,null,{"$f":"COUNTA(Variables[VarName])","v":4}]
[null,null,"VarName","Description","VarType","Group","SubGroup","Format","ResolveAggregation","LoopFilter"]
[null,null,"HelloWorldVariable","Concatenates the HelloVariable with the WorldVariable","Proj","Hello World","Main","String","Sum",true]
[null,null,"HelloVariable","Types in the world \"Hello\"","Proj","Hello World","Calculation","String","Sum",true]
[null,null,"WorldVariable","Types in the world \"World\"","Proj","Hello World","Calculation","String","Sum",true]
[null,null,"MyFirstValue","Read in your first values","Proj","My First values","Main","Integer","Sum",true]

{"sheet":"Settings","index":13,"n_rows":14,"n_cols":25,"rows_kept":14,"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,"Summary",1,"EarliestPrecedent",null,"Date","2030-12-31",null,null,null,"Default","#,##0.0,, \"m\";-#,##0.0,, \"m\";\"-\"",-10000000,{"$f":"TEXT(N6,M6)","v":"-10000,000.0,, m"},null,null,null,"Hello World",9,null,null,null,"Main",0.4]
[null,null,"HelloValuationType",1,"EarliestPrecedent",null,"Date","2030-12-31",null,null,null,"Millions","#,##0.0,, \"m\";-#,##0.0,, \"m\";\"-\"",-10000000,"-10000,000.0,, m",null,null,null,"My First values",10,null,null,null,"Calculation",0.6]
[null,".","WorldValuationType",1,"EarliestPrecedent",null,"Periods","IVP*10+1",null,null,null,"Thousands","#,##0.0, \"k\";-#,##0.0, \"k\";\"-\"",-10000000,"-10000,000.0, k"]
[null,null,null,null,null,null,null,null,null,null,null,"OneDecimal","0.0",-10000,"-10000.0"]
[null,null,null,null,null,null,null,null,null,null,null,"Percent","0.00%;-0.00%;0.00%",-0.05,"-5.00%"]
[null,null,null,null,null,null,null,null,null,null,null,"Integer",0,-5,"-5"]
[null,null,null,null,null,null,null,null,null,null,null,"SmallNumber","0.000000;-0.000000;\"-\"",3.1415926535897931,"3.141593"]
[null,null,null,null,null,null,null,null,null,null,null,"Date","yyyy-mm-dd",43465,"2018-12-31"]
[null,null,null,null,null,null,null,null,null,null,null,"String",null,"Hello world","Hello world"]

{"sheet":"Lists","index":14,"n_rows":31,"n_cols":40,"rows_kept":31,"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,1,null,null,null,"HierarchyUniquePathsCountStart",1,1,null,null,null,"hPropertiesListCountStart",1]
[null,"↓ProjectionSettings↓",null,null,null,null,"Summary.h2.Generic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HierarchyUniqueNamesStart","h2","h1",null,null,null,"HierarchyUniquePathsStart","h2","h1",null,null,null,"hPropertiesListStart"]
[null,"valnType","ValnTypes",null,null,null,"Hello.h1.Generic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galaxy Holdings","Planet earth",null,null,null,null,"Galaxy Holdings","Galaxy Holdings|Planet earth"]
[null,"varName","VarNames",null,null,null,"World.h1.Generic"]
[null,"↑ProjectionSettings↑"]
[]
[null,"↓HierarchyNames↓"]
[null,"GroupCompany","UniqueHNamesLookup"]
[null,"Subsidiaries","UniqueHNamesLookup"]
[null,"↑HierarchyNames↑","UniqueHNamesLookup"]
[]
[null,"↓HierarchyProperties↓"]
[]
[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","\"Override validation and enter appropriate value\""]
[null,"ProjMonths","\"Override validation and enter appropriate value\""]
[null,"Date","\"Override validation and enter appropriate value\""]
[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","2023-03-08T09:37: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,139,"Remove jsonOutputIndicator_deprecated","2023-09-06T17:29: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,140,"Remove csvOutputIndicator","2023-09-06T17:29: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,141,"Create the `RunMultiple` sheet","2023-11-29T14:07: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,142,"Re-assign the macro for the 'Save & Run' button.","2023-11-30T10:21:35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:45: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,144,"Add the new `RunProjectionNodesFilter` option to RunControl and remove the options which it replaces.","2024-05-14T12:11: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,145,"Add the new `OutputProjectionNodeFilter` and `OutputTimeStepFilter` options to RunControl and remove the options which they replace.","2024-08-06T11:21: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,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:20: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,147,"Add pre-run scripts and post-run scripts to RunControl","2024-09-17T17:45: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,148,"Add AutoryAppDir to RunControl","2024-10-02T15:26: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,149,"Remove runner_dependency from RunControl","2024-10-02T23:42:44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:38: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,151,"Remove 'runLogOutputFolder', 'jsonOutputFolder', 'preRunValidationsInd', and 'runCreateNodeFiles' from RunControl.","2024-10-03T13:13:56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:46: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,153,"Remove 'jsonOutputIndicator' from RunControl.","2024-11-25T16:55:59"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:10:35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:58"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:28:18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:28: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,158,"`RunMultiple` data validations","2025-10-31T08:51:29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:51:29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:51: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,161,"Delete the \"Index\" sheet.","2025-11-11T08:56:40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:36: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,163,"Remove the `default` and `default chosen` columns from the `RunControl` sheet.","2025-11-26T08:36: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:55:10"]