{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","files","Check list","ErrorLog","FilingIndicators","parameters","Comments"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":48,"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":"Start","index":0,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[8,1,8,3],[9,1,9,3]]}
[]
[null,"DISCLAIMER: This tool has been developed for the purpose of the 2024 DRY RUN exercise only."]
[]
[]
[]
[]
[]
[]
[null,"2024 DORA dry run exercise"]
[null,"CSVs reporting package generator"]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Follow Instructions to fill the XLS Reporting templates."]
[]
[null,2,"Insert the full path(1) of the folder where the XLS templates completed as per point 1 and to be converted are stored."]
[]
[null,null,"Input path:","C:\\Your Input folder path"]
[]
[null,3,"Create an empty folder where the output files of the macro will be stored. Insert the full path (1):"]
[]
[null,null,"Output","C:\\Your output folder path"]
[]
[]
[null,5,"Enter a specific submission date  [Optional - if empty the submission date will be the date of creation of CSV]"]
[]
[null,null,"Submission date (Optional):"]
[]
[null,6,"Select the consolidation scope of the report:"]
[]
[]
[]
[]
[]
[null,7,"Select the templates to be submitted:"]
[]
[]
[]
[]
[]
[null,8,"Close all other Excel workbooks before running the macro"]
[]
[null,9,"Press the Start button to launch the macro"]
[]
[]
[]
[]
[]
[]
["(1)","Eg: C:\\DORA Working folder\\Input"]

{"sheet":"files","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Check list","index":2,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Rule ID","Rule type","Sheet","Column","Colexcel",null,"Check type","Check if","LIST REF"]
["DOR_0001","Error",null,null,null,null,"Version","Correct / official Version of the template in use"]
["DOR_0002","Error",null,null,null,null,"Protection","Workbook is protected"]
["DOR_0003","Error","all"," ",null,null,"Protection","All the sheets are protected"]
["DOR_0004","Error","b_01.01","C0010 to C0050",null,null,"Missing","Mandatory Master data information as required"]
["DOR_0005","Error","b_01.01","C0030",null,null,"List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0006","Error","b_01.01","C0040",null,null,"List","Value entered as per closed set of option - DPM codes","LIST0101040"]
["DOR_0007","Warning","b_01.01","C0060",7,null,"Missing","Reference date set to 31/12/2023 when missing / uncorrect"]
["DOR_0008","Warning","b_01.02","C0010",2,"LEI","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0009","Warning","b_01.02","C0030",4,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0010","Warning","b_01.02","C0040",5,"List","List","Value entered as per closed set of option - DPM codes","LIST0101040"]
["DOR_0011","Warning","b_01.02","C0050",6,"List","List","Value entered as per closed set of option - DPM codes","LIST0102050"]
["DOR_0012","Warning","b_01.02","C0060",7,"LEI","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0013","Warning","b_01.02","C0070",8,"date","Format","Value entered is a date"]
["DOR_0014","Warning","b_01.02","C0080",9,"date","Format","Value entered is a date"]
["DOR_0015","Warning","b_01.02","C0090",10,"date","Format","Value entered is a date"]
["DOR_0016","Warning","b_01.02","C0100",11,"List","List","Value entered as per closed set of option - DPM codes","LISTCURRENCY"]
["DOR_0017","Warning","b_01.03","C0020",3,"lei","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0018","Warning","b_01.03","C0040",5,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0019","Warning","b_02.01","C0020",3,"List","List","Value entered as per closed set of option - DPM codes","LIST0201020"]
["DOR_0020","Warning","b_02.01","C0040",5,"List","List","Value entered as per closed set of option - DPM codes","LISTCURRENCY"]
["DOR_0021","Warning","b_02.02","C0020",3,"lei","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0022","Warning","b_02.02","C0060",7,"List","List","Value entered as per closed set of option - DPM codes","LISTANNEXIII"]
["DOR_0023","Warning","b_02.02","C0070",8,"date","Format","Value entered is a date"]
["DOR_0024","Warning","b_02.02","C0080",9,"date","Format","Value entered is a date"]
["DOR_0025","Warning","b_02.02","C0090",10,"List","List","Value entered as per closed set of option - DPM codes","LIST0202090"]
["DOR_0026","Warning","b_02.02","C0120",13,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0027","Warning","b_02.02","C0130",14,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0028","Warning","b_02.02","C0140",15,"List","List","Value entered as per closed set of option - DPM codes","LISTBINARY"]
["DOR_0029","Warning","b_02.02","C0150",16,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0030","Warning","b_02.02","C0160",17,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0031","Warning","b_02.02","C0170",18,"List","List","Value entered as per closed set of option - DPM codes","LIST0202170"]
["DOR_0032","Warning","b_02.02","C0180",19,"List","List","Value entered as per closed set of option - DPM codes","LIST0202180"]
["DOR_0033","Warning","b_03.01","C0020",3,"LEI","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0034","Warning","b_03.03","C0020",3,"LEI","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0035","Warning","b_04.01","C0020",3,"LEI","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0036","Warning","b_04.01","C0030",4,"List","List","Value entered as per closed set of option - DPM codes","LIST0401030"]
["DOR_0037","Warning","b_05.01","C0040",5,"List","List","Value entered as per closed set of option - DPM codes","LIST0501040"]
["DOR_0038","Warning","b_05.01","C0050",6,"List","List","Value entered as per closed set of option - DPM codes","LISTCOUNTRY"]
["DOR_0039","Warning","b_05.01","C0060",7,"List","List","Value entered as per closed set of option - DPM codes","LISTCURRENCY"]
["DOR_0040","Warning","b_05.02","C0020",3,"List","List","Value entered as per closed set of option - DPM codes","LISTANNEXIII"]
["DOR_0041","Warning","b_06.01","C0020",3,"List","List","Value entered as per closed set of option - DPM codes","LIST0601020"]
["DOR_0042","Warning","b_06.01","C0040",5,"LEI","Format","If LEI is 20 digits - numerical allowed"]
["DOR_0043","Warning","b_06.01","C0050",6,"List","List","Value entered as per closed set of option - DPM codes","LIST0601050"]
["DOR_0044","Warning","b_06.01","C0070",8,"date","Format","Value entered is a date"]
["DOR_0045","Warning","b_06.01","C0100",11,"List","List","Value entered as per closed set of option - DPM codes","LIST0601100"]
["DOR_0046","Warning","b_07.01","C0040",5,"List","List","Value entered as per closed set of option - DPM codes","LISTANNEXIII"]
["DOR_0047","Warning","b_07.01","C0050",6,"List","List","Value entered as per closed set of option - DPM codes","LIST0701050"]
["DOR_0048","Warning","b_07.01","C0060",7,"List","List","Value entered as per closed set of option - DPM codes","LIST0701060"]
["DOR_0049","Warning","b_07.01","C0070",8,"date","Format","Value entered is a date"]
["DOR_0050","Warning","b_07.01","C0080",9,"List","List","Value entered as per closed set of option - DPM codes","LISTBINARY"]
["DOR_0051","Warning","b_07.01","C0040",5,"List","List","Value entered as per closed set of option - DPM codes","LISTANNEXIII"]
["DOR_0052","Warning","b_07.01","C0050",6,"List","List","Value entered as per closed set of option - DPM codes","LIST0701050"]
["DOR_0053","Warning","b_07.01","C0060",7,"List","List","Value entered as per closed set of option - DPM codes","LIST0701060"]
["DOR_0054","Warning","b_07.01","C0090",10,"List","List","Value entered as per closed set of option - DPM codes","LIST0701090"]
["DOR_0055","Warning","b_07.01","C0100",11,"List","List","Value entered as per closed set of option - DPM codes","LIST0601100"]
["DOR_0056","Warning","b_07.01","C0110",12,"List","List","Value entered as per closed set of option - DPM codes","LIST0601050"]
["DOR_0057","Warning","b_01.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0058","Warning","b_01.02","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0059","Warning","b_01.03","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0060","Warning","b_01.03","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0061","Warning","b_02.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0062","Warning","b_02.02","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0063","Warning","b_02.02","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0064","Warning","b_02.02","C0030",4,"key","Mandatory","Key Value is mandatory"]
["DOR_0065","Warning","b_02.02","C0040",5,"key","Mandatory","Key Value is mandatory"]
["DOR_0066","Warning","b_02.02","C0050",6,"key","Mandatory","Key Value is mandatory"]
["DOR_0067","Warning","b_02.02","C0060",7,"key","Mandatory","Key Value is mandatory"]
["DOR_0068","Warning","b_02.03","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0069","Warning","b_02.03","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0070","Warning","b_03.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0071","Warning","b_03.01","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0072","Warning","b_03.02","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0073","Warning","b_03.02","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0074","Warning","b_03.02","C0030",4,"key","Mandatory","Key Value is mandatory"]
["DOR_0075","Warning","b_03.03","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0076","Warning","b_03.03","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0077","Warning","b_04.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0078","Warning","b_04.01","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0079","Warning","b_05.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0080","Warning","b_05.01","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0081","Warning","b_05.02","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0082","Warning","b_05.02","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0083","Warning","b_05.02","C0030",4,"key","Mandatory","Key Value is mandatory"]
["DOR_0084","Warning","b_05.02","C0040",5,"key","Mandatory","Key Value is mandatory"]
["DOR_0085","Warning","b_06.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0086","Warning","b_06.01","C0040",5,"key","Mandatory","Key Value is mandatory"]
["DOR_0087","Warning","b_07.01","C0010",2,"key","Mandatory","Key Value is mandatory"]
["DOR_0088","Warning","b_07.01","C0020",3,"key","Mandatory","Key Value is mandatory"]
["DOR_0089","Warning","b_07.01","C0030",4,"key","Mandatory","Key Value is mandatory"]
["DOR_0090","Warning","b_07.01","C0040",5,"key","Mandatory","Key Value is mandatory"]

{"sheet":"ErrorLog","index":3,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ID","TEMPLATE","CELL","VALUE","Error Description"]

{"sheet":"FilingIndicators","index":4,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["templateID","reported"]
["B_01.01",true]
["B_01.02",false]
["B_01.03",false]
["B_02.01",false]
["B_02.02",false]
["B_02.03",false]
["B_03.01",false]
["B_03.02",false]
["B_03.03",false]
["B_04.01",false]
["B_05.01",false]
["B_05.02",false]
["B_06.01",false]
["B_07.01",false]
["B_99.01",false]

{"sheet":"parameters","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["name","value"]
["entityID","rs:19bignumbersindatess.IND"]
["refPeriod","2023-02-20"]
["baseCurrency","iso4217:EUR"]
["decimalsInteger",0]
["decimalsMonetary",-3]

{"sheet":"Comments","index":6,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["do we accept lei as numeric? Do we risk that we lose the full code when number is stored in a rounded format eg scientific?"]
["at the moment the check store the number as string and then count the digit must be 20"]
[]
["Add empty cell to all lists as we need to accept empties"]
[]
["Add protection"]
[]
["add version flag"]
[]
["Id to be reported inVBA"]