{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Validation flags"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Validation flags","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,4,2,5],[3,0,3,1],[3,2,3,3],[2,0,2,3]]}
["Technical Annex C – List of data plausibility tests"]
[]
["Template codes/names for group",null,null,null,"Validation"]
["Group reference template #1",null,"Group reference template #2"]
["Code","Name","Code","Name","Validation code","Explanation"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0010/R0200}<={C0010/R0110}+{C0010/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0020/R0200}<={C0020/R0110}+{C0020/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0030/R0200}<={C0030/R0110}+{C0030/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0040/R0200}<={C0040/R0110}+{C0040/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0050/R0200}<={C0050/R0110}+{C0050/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0060/R0200}<={C0060/R0110}+{C0060/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0070/R0200}<={C0070/R0110}+{C0070/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0080/R0200}<={C0080/R0110}+{C0080/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0090/R0200}<={C0090/R0110}+{C0090/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C00100/R0200}<={C00100/R0110}+{C00100/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C00110/R0200}<={C00110/R0110}+{C00110/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C00120/R0200}<={C00120/R0110}+{C00120/R0120}","Net written premiums should be less or equal to gross (direct + reinsurance accepted), non-life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0200/R1200}={C0010/R0500}+{C0020/R0500}+{C0030/R0500}+{C0040/R0500}+{C0050/R0500}+{C0060/R0500}+{C0070/R0500}+{C0080/R0500}+{C0090/R0500}+{C0100/R0500}+{C0110/R0500}+{C0120/R0500}+{C0130/R0500}+{C0140/R0500}+{C0150/R0500}+{C0160/R0500}+{C0200/R1100}","Total expenses should be equal to net expenses all business lines plus other expenses"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0210/R1500}<={C0210/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0220/R1500}<={C0220/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0230/R1500}<={C0230/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0240/R1500}<={C0240/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0250/R1500}<={C0250/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0260/R1500}<={C0260/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,null,"{C0270/R1500}<={C0270/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,null,"{C0280/R1500}<={C0280/R1410}","Net written premiums should be less or equal to gross (direct + reinsurance accepted),life, by LOB"]
["S.05.01.13","Premiums, claims & expenses - quarterly data",null,"","{C0300/R2600}={C0210/R1900}+{C0220/R1900}+{C0230/R1900}+{C0240/R1900}+{C0250/R1900}+{C0260/R1900}+{C0270/R1900}+{C0280/R1900}+{C0300/R2500}","Total expenses should be equal to net expenses all business lines plus other expenses"]
["S.23.01.13","OF-B1 for group entities (quarterly)","S.02.01.02","Balance sheet","{S.23.01.13!C0010/R0140} < {S.02.01.02!C0010/R0500}","Subordinated debt reported in own funds should be smaller than total balance sheet assets"]
["S.23.01.13","OF-B1 for group entities (quarterly)",null,"","{C0010/R0290}>{C0010/R0140}","Total basic own funds after adjustments (group) should be larger than subordinated liabilities"]
["S.23.01.13","OF-B1 for group entities (quarterly)",null,"","{C0010/R0570}={C0020/R0570}+{C0030/R0570}+{C0040/R0570}","Total eligible own funds to meet the minimum group SCR (group) should equal sum of tiers"]