{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Read_Me","Param","Workflow","TempMove","Temp","TempPrv","DeletedRecords","NewRecords","NumStats","NumStatsMove","TextStats","TextStatsMove","LimitsMoveIn","LimitsMoveOut","LimitsIn","LimitsOut","FileSpecs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Read_Me","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["1. Update values in sheet \"Param\""]
["2. [If applicable]  For non-Algo files put sort column information into file FileSpecs.csv in subfolder Config"]
["3. Put your input files into subfolder Data_Files (previous period's files into Data_Files_Prev)"]
["4. [If applicable] For Algo files put your header file(s) into subfolder Header_Files"]
["5. [If applicable] Put your preferred constraints into files Limits_Input.csv and Limits_Move_Input.csv in subfolder Config"]
["6. Press the button in sheet Workflow"]
["7. Wait until application prints \"Reading Input finished\""]
["8. Look into Output Dir, file NumStats for outlier statistics on numerical fields and dates"]
["9. Look into Output Dir, file TextStats for distribution info on string fields"]
["10. Look into subfolder Logs for important logging information"]
[]
["Bernd 10/05/2026"]

{"sheet":"Param","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Production","Test Bernd","Comment"]
["Log Level",1,1,"1 = Info, 2 = Warning, 3 = Error, 4 = no logging at all"]
["Warning threshold (# of Stdevs)",3,3,"Create a warning message when min/max is off by more than this vs. mean"]
["Keep stats in tabs",false,true,"TRUE is easier for frequent runs, FALSE strictly separates the program from the data"]
["Max number of string attributes per field",100,50,"Used for Limits files"]
["No single character check",true,true,"True = we do not check whether single characters are valid"]
["Input File Delimiter",";",",","CSV if empty or \",\""]

{"sheet":"Workflow","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Message"]
[]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - Logging started with Datastats_Version_40"]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - Microsoft Windows 11 Home 10.0.22000 (64-Bit) and Excel 2024 (64-Bit)"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - Application ThousandsSeparator '.', DecimalSeparator ',', use system separators"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - App.Internl ThousandsSeparator '.', DecimalSeparator ',', ListSeparator ';'"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - App.Internl xlCountryCode '49', xlCountrySetting '49'"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 10.05.2026 17:09:28 [Start_Log] - VBAProject References: Visual Basic For Applications, Microsoft Excel 16.0 Object Library, OLE Automation, Microsoft Office 16.0 Object Library, Microsoft VBScript Regular Expressions 5.5"]
[null,null,null,null,"#WARN: BERND-CAPTIVA\\earso 10.05.2026 17:09:36 [Read_Input] - Filename C:\\Users\\earso\\Dropbox\\CD30_Excel\\Excel_VBA_Eine_Sammlung\\VBA_Programme_für_Fortgeschrittene\\sbDatastats\\Data_Files_Prev\\Sulprobil-1000 not found in Data_Files_Prev. No movement check."]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 10.05.2026 17:09:36 [End_Log] - Logging finished with Datastats_Version_40"]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 10.05.2026 17:09:36 [End_Log] - <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<"]

{"sheet":"TempMove","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Temp","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TempPrv","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DeletedRecords","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NewRecords","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NumStats","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NumStatsMove","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TextStats","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TextStatsMove","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LimitsMoveIn","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LimitsMoveOut","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LimitsIn","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LimitsOut","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FileSpecs","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}