{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Hierarchy","User EntryPoints","EntryPoints","User Variable Library","Variable Library","User VariableSet Inheritance","RunMultiple","RunControl","VariableSet Inheritance","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":"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,null,"HierarchyProperties→"]
[null,null,"Main"]

{"sheet":"User EntryPoints","index":1,"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,"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 and name",1,null,"Main","Summary","Summary"]

{"sheet":"User Variable Library","index":3,"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,"VariableSetName","VarName","Formula","Comment"]

{"sheet":"Variable Library","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"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":16}]
[null,null,"VariableSetName","VarName","Formula","Comment"]
[null,null,"Summary","CsvToTable1","csvToTable(\"data1.csv\")","Baseline"]
[null,null,"Summary","CsvToTable2","csvToTable(\"data1.csv\", \"WHERE b > 300\")","Short-hand query"]
[null,null,"Summary","CsvToTable3","csvToTable(\"data1.csv\", \"SELECT a FROM df WHERE b > 300\")","Full query. The table name is always \"df\"."]
[null,null,"Summary","CsvToTable4","csvToTable(\n    \"data1.csv\",\n    ,\n    ,\n    ,\n    dict(\"a\", \"int\", \"b\", \"float\", \"c\", \"bool\", \"d\", \"string\", \"e\", \"date\", \"f\", \"time\", \"g\", \"datetime\", \"h\", \"datetime:%d %b %Y %H:%M\")\n)","Specify data types explicitly. Column h needs an explicit format specifier because it's not in ISO 8601 format."]
[null,null,"Summary","CsvToTable5","csvToTable(\"data1.csv\", , , , dict(\"a\", \"string\", \"b\", \"string\"))","Don't allow columns a and b to be detected as numeric"]
[null,null,"Summary","CsvToTable6","csvToTable(\n    \"data1.csv\",\n    \"SELECT e AS date1, h AS date2 FROM df WHERE date2 > '2024-02-29 16:00'\",\n    ,\n    ,\n    dict(\"e\", \"date\",  \"h\", \"datetime:%d %b %Y %H:%M\", \"date1\", \"date\", \"date2\", \"datetime\")\n)","When renaming columns in the SQL query, specify the data types of the original columns (because CSV is string-only by definition) AND the new columns (because we use SQLite to perform the query, and SQLite does not have explicit types for date/time or boolean)."]
[null,null,"Summary","ExcelTable1","excelTable(\"data.xlsx\", \"Table1\")","Number formats from the original table are preserved. Data is copied verbatim."]
[null,null,"Summary","ExcelTable2","excelTable(\"data.xlsx\", \"Table2\", \"WHERE b > 300\")","Short-hand query"]
[null,null,"Summary","ExcelTable3","excelTable(\"data.xlsx\", \"Table2\", \"SELECT a FROM df WHERE b > 300\")","Full query. The table name is always \"df\"."]
[null,null,"Summary","ExcelTable4","excelTable(\n    \"data.xlsx\",\n    \"Table2\",\n    ,\n    dict(\"a\", \"string\", \"b\", \"string\", \"c\", \"string\", \"d\", \"string\", \"e\", \"string\", \"f\", \"string\", \"g\", \"string\", \"h\", \"string\")\n)","Force all columns to be strings. They will use the \"@\" number format."]
[null,null,"Summary","ExcelTable5","excelTable(\n    \"data.xlsx\",\n    \"Table2\",\n    \"SELECT e AS date1, h AS date2 FROM df WHERE date2 > '2024-02-29 16:00'\",\n    dict(\"date1\", \"date\", \"date2\", \"datetime\")\n)","When renaming columns in the SQL query, it becomes necessary to explicitly specify the data types for the new columns (because we use SQLite to perform the query, and SQLite does not have explicit types for date/time or boolean)."]
[null,null,"Summary","SqlToTable1","sqlToTable(\"sqlite:///data.sqlite\", \"SELECT a FROM table1 WHERE b > 300\")","Full query. Short-hand query is not possible."]
[null,null,"Summary","SqlToTable2","sqlToTable(\n    \"sqlite:///data.sqlite\",\n    \"SELECT a FROM table1 WHERE b > 300\",\n    dict(\"c\", \"bool\", \"e\", \"date\", \"f\", \"time\", \"g\", \"datetime\", \"h\", \"datetime:%d %b %Y %H:%M\")\n)","Explicitly specify the data types for the columns where SQLite is storing boolean as integer and date/time as string, because SQLite does not have explicit types for date/time or boolean."]
[null,null,"Summary","ResultsJsonToTable1","resultsJsonToTable(\"data1.json\")","Baseline. Get everything from the JSON file. No data type conversion."]
[null,null,"Summary","ResultsJsonToTable2","resultsJsonToTable(\"data1.json\", , dict(\"date\", \"date\", \"valuationDate\", \"date\", \"runTimeStamp\", \"datetime\"))","Interpret date and time columns as such."]
[null,null,"Summary","ResultsJsonToTable3","resultsJsonToTable(\"data1.json\", \"SELECT VarTwo FROM df WHERE VarOne > 5\")","Only get the rows and columns we need"]

{"sheet":"User VariableSet Inheritance","index":5,"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":"RunMultiple","index":6,"n_rows":13,"n_cols":12,"rows_kept":13,"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,null,0]

{"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","2018-12-31"]
[]
[null,null,"RunHierarchyLevel",1]
[null,null,"RunHierarchyPath","Main"]
[null,null,"RunStartValnType","Summary"]
[]
[null,null,"Run settings"]
[]
[null,null,"Results output folder","%temp%\\autory\\table-create-load-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<=3,valnType=\"Summary\")"]
[null,null,"OutputTimeStepFilter","AND(t>(2018*12+12-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate))),MOD(t-1-(2018*12+12-(YEAR(ProjectionStartDate)*12+MONTH(ProjectionStartDate))),12)=0,t<=480+MAX(0,(2018*12+12-(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","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":"VersionControl","index":9,"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":10,"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,null,null,null,null,null,null,"t","SequenceFrom1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date","IF(t=1,ProjectionStartDate,EOMONTH(INDEX(Date,t-1),1))"]

{"sheet":"Variables","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Return to Index"]
[null,null,{"$f":"COUNTA(Variables[VarName])","v":16}]
[null,null,"VarName","Description","VarType","Group","SubGroup","Format","ResolveAggregation","LoopFilter"]
[null,null,"CsvToTable1",null,"Constant","Main","Main","String","Sum",true]
[null,null,"CsvToTable2",null,"Constant","Main","Main","String","Sum",true]
[null,null,"CsvToTable3",null,"Constant","Main","Main","String","Sum",true]
[null,null,"CsvToTable4",null,"Constant","Main","Main","String","Sum",true]
[null,null,"CsvToTable5",null,"Constant","Main","Main","String","Sum",true]
[null,null,"CsvToTable6",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ExcelTable1",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ExcelTable2",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ExcelTable3",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ExcelTable4",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ExcelTable5",null,"Constant","Main","Main","String","Sum",true]
[null,null,"SqlToTable1",null,"Constant","Main","Main","String","Sum",true]
[null,null,"SqlToTable2",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ResultsJsonToTable1",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ResultsJsonToTable2",null,"Constant","Main","Main","String","Sum",true]
[null,null,"ResultsJsonToTable3",null,"Constant","Main","Main","String","Sum",true]

{"sheet":"Settings","index":12,"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,"Summary",1,"EarliestPrecedent",null,"Periods",1,null,null,null,"Default","#",-10000000,{"$f":"TEXT(N6,M6)","v":"-10000000"},null,null,null,"Main",5,null,null,null,"Main",0.4]
[null,null,null,null,null,null,null,null,null,null,null,"Date","yyyy-mm-dd",43465,{"$f":"TEXT(N7,M7)","v":"2018-12-31"}]
[null,".",null,null,null,null,null,null,null,null,null,"String","@","Hello world","Hello world"]

{"sheet":"Lists","index":13,"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,"Summary",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,"↑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":14,"n_rows":75,"n_cols":49,"rows_kept":75,"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,"userVarLib","ListObject",null,null,null,null,null,null,null,"masterVarLib","VariableSetName",null,null,null,null,null,null,"masterVarLib",1605383758.7719631,null,null,null,null,"eca4d75d0a1f9e5f217eb6d5e544fcc9ee431472",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,"masterVarLib","ListObject",".\\varlibs",true,true,true,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,"hLevelNames","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,"RunTimeVariables","ListObject",null,null,null,null,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,"GlobalProjectionVariables","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,"sqlConnections","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,"Variables","ListObject",".\\varlibs",true,true,true,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,"ValuationTypes","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,"t_GenerichLevelNames","ListObject",null,null,null,null,null,null,null,"t_Inputs","Country|ProjectTypes",null,null,null,null,null,null,null,null,null,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,"t_VarFormatGroup","ListObject",null,null,null,null,null,null,null,"t_Inputs","Country",null,null,null,null,null,null,null,null,null,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,"t_VarGroup","ListObject",null,null,null,null,null,null,null,"t_Inputs","ProjectTypes",null,null,null,null,null,null,null,null,null,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,"t_VarSubGroup","ListObject",null,null,null,null,null,null,null,"t_Inputs","NrOfSales",null,null,null,null,null,null,null,null,null,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,"CustomFunctionsTable","ListObject",null,null,null,null,null,null,null,"t_Inputs","ExpensesPerSale",null,null,null,null,null,null,null,null,null,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,"t_ConfigFormulae","Range",null,null,null,null,null,null,null,"t_Inputs","RevenuePerSale",null,null,null,null,null,null,null,null,null,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,"t_Inputs","Range",".\\inputs",null,true,null,null,null,null,"t_Inputs","GrowthRate",null,null,null,null,null,null,null,null,null,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,"t_ProjConfigTable","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,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-11T13:51: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,0,"Add AutoryEngine, ExcelVisible and DebugLevel options in Run Control.","2023-12-11T13:53: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,0,"Add AutoryEngine, ExcelVisible and DebugLevel options in Run Control.","2023-12-11T13:57: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,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-03T13:15: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,145,"Add the new `OutputProjectionNodeFilter` and `OutputTimeStepFilter` options to RunControl and remove the options which they replace.","2024-10-03T13:15: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,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-03T13:15: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,147,"Add pre-run scripts and post-run scripts to RunControl","2024-10-03T13:15: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,148,"Add AutoryAppDir to RunControl","2024-10-03T13:15: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,149,"Remove runner_dependency from RunControl","2024-10-03T13:15: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,150,"Update the 'UpdateWorkbookVBA' button.","2024-10-03T13:15: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,151,"Remove 'runLogOutputFolder', 'jsonOutputFolder', 'preRunValidationsInd', and 'runCreateNodeFiles' from RunControl.","2024-10-03T13:15: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,152,"Remove 'LoopWriteIterationsToSqlite' from RunControl.","2024-11-25T09:46: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,153,"Remove 'jsonOutputIndicator' from RunControl.","2024-11-25T16:55: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,154,"Rename `output_folder` to `OutputFolder`.","2024-11-28T23:10: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,155,"Remove 'IgnoreOutOfTreeDependencies' from RunControl.","2025-01-09T09:39:48"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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: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,157,"Update the `RunMultiple` sheet.","2025-03-19T14:28: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,158,"`RunMultiple` data validations","2025-10-31T08:51: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,159,"Remove UseOldAutomaticFormulaExpansion from RunControl.","2025-10-31T08:51: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,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: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,161,"Delete the \"Index\" sheet.","2025-11-11T08:56: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,162,"Add conditional formatting to the `ProjectionStartFormula` column of each `ValuationTypes` table.","2025-11-26T08:36:28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:01"]