{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Index","Participant Information","Control","SCR Summary","MCR Summary","Regulatory Balance Sheet","Own Funds","Operational Risk","Market Risk","Counterparty Default Risk","Life Underwriting Risk","Health Underwriting Risk","Data","Raw Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":396,"comments":1,"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":"Index","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,3,54,5],[3,0,3,16383],[5,0,5,16383],[44,3,44,5],[46,3,46,5],[48,3,48,5],[50,3,50,5],[52,3,52,5],[36,3,36,5],[38,3,38,5],[40,3,40,5],[42,3,42,5],[13,0,13,16383],[15,0,15,16383],[32,3,32,5],[34,3,34,5],[7,0,7,16383],[9,0,9,16383],[11,0,11,16383]]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Index"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
["Throughout this RER form, 'Regulation' refers to the Insurance (Long-Term Business Valuation and Solvency) Regulations 2018 unless stated otherwise. "]
[]
["Where applicable, the terms used in this form should be taken to have the same meaning as defined in the Regulations."]
[]
["This Regulatory Electronic Return (\"RER\"), \"RER_LT1_SCR_Form_6_Total_Insurer Shortname\" should be completed by the insurer for assets and liabilities relating to all its lines of business."]
[]
["In accordance with Regulation 14 of the Insurance Regulations 2018, all of the following should be submitted to the Authority:                                                                                                                                                                                     a) this RER form;                                                                                                                                                                                     b) where applicable to the insurer, the RER 'RER_LT1_SCR_Form_X_Insurer Shortname' forms for the 5 lines of business.                                                                                                                                                                                                                                                                                                                                                                                         "]
[]
["This RER form must be completed in the reporting currency of the insurer. "]
[]
["When expressing the value of any asset or liability denominated in a currency other than the reporting currency, the value shall be converted into the reporting currency as if the conversion had taken place at the closing exchange rate on the last day for which the appropriate rate is available in the reporting period to which the asset or liability relates. "]
[]
["The conversion into the reporting currency shall be calculated by applying the exchange rate from the same source as that used for the insurer's financial statements."]
[]
[null,null,null,null,null,"Key"]
[]
[null,null,null,null,null,"Input Cell"]
[]
[null,null,null,null,null,"Formula Cell"]
[]
[null,null,null,null,null,"Fixed value cell"]
[]
[null,null,null,null,null,"Fixed value cell"]
[]
[null,null,null,null,null,"           *          \nClick on cell for info"]
[]
[]
[null,"Tab",null,"Content"]
[]
[null,"Macro",null,"File locations of returns to be input and macro to be run to amalgamate SCR results by line of business."]
[]
[null,"Participant Information",null,"Information regarding the insurer submitting the RER form."]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'SCR Summary'!$A$1),LEN(CELL(\"filename\",'SCR Summary'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"SCR Summary"},null,"Calculation of the insurer's solvency capital requirement; summary of capital resources and the related SCR coverage ratio in accordance with Part 3 of the Regulations. "]
[]
[null,"Operational Risk",null,"Calculation of the operational risk capital requirement calculation in accordance with Regulation 57."]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'Regulatory Balance Sheet'!$A$1),LEN(CELL(\"filename\",'Regulatory Balance Sheet'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Regulatory Balance Sheet"},null,"Information on the economic balance sheet for both the insurer's accounting basis and the regulatory basis determined in accordance with Part 1 of the Regulations."]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'Own Funds'!$A$1),LEN(CELL(\"filename\",'Own Funds'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Own Funds"},null,"Breakdown of capital section from the economic balance sheet, determines eligible own funds to cover the SCR in accordance with Part 5 of the Regulations."]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'Market Risk'!$A$1),LEN(CELL(\"filename\",'Market Risk'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Market Risk"},null,"Calculation of the market risk capital requirement calcuation in accordance with Regulation 59."]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'Counterparty Default Risk'!$A$1),LEN(CELL(\"filename\",'Counterparty Default Risk'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Counterparty Default Risk"},null,"Calculation of the counterparty default risk capital requirement in accordance with Regulation 79."]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'Life Underwriting Risk'!$A$1),LEN(CELL(\"filename\",'Life Underwriting Risk'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Life Underwriting Risk"},null,"Calculation of the life underwriting risk capital requirement in accordance with Regulation 87. "]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",'Health Underwriting Risk'!$A$1),LEN(CELL(\"filename\",'Health Underwriting Risk'!$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Health Underwriting Risk"},null,"Calculation of the health underwriting risk capital requirement in accordance with Regulation 95."]
[]
[null,"Data",null,"Information only."]
[]
[null,"Raw Data",null,"Information only, amalgamation of all LoB results from other templates. Used in the rest of the tabs in this worksheet."]

{"sheet":"Participant Information","index":1,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,3,9,5],[30,3,30,6],[14,3,14,6],[25,3,25,4],[21,3,21,5],[23,3,23,6]]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Participant Information"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null," Information"]
[]
[null,"Date of submission"]
[]
[null,"Financial year end used"]
[]
[null,"Reporting currency",null,null,null,null,{"$f":"OFFSET(Data!C5,MATCH(D10,Data!B5:B76,0)-1,)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Insurer Information"]
[]
[null,"Insurer Name"]
[]
[null,"Insurer Shortname"]
[]
[]
[null,"Contact Information"]
[]
[null,"Contact Name"]
[]
[null,"Email Address"]
[]
[null,"Phone Number"]
[]
[]
[null,"Comments"]
[]
[null,"Comments"]

{"sheet":"Control","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6]]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Control"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[]
[null,null,"File Name",null,"Folder Location",null,"Applicable?*"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"File path for RER Form"]
[]
[null,null,{"$f":"IF(G7=\"Yes\",IF(RIGHT(E7,1)=\"\\\",E7&C7&\".xlsx\",E7&\"\\\"&C7&\".xlsx\"),\"\")","v":""}]
[null,null,{"$f":"IF(G8=\"Yes\",IF(RIGHT(E8,1)=\"\\\",E8&C8&\".xlsx\",E8&\"\\\"&C8&\".xlsx\"),\"\")","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"SCR Summary","index":3,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"SCR Summary"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For info"]
[null,"Solvency Capital Requirement",null,null,null,"Capital",null,"nCapital",null,null,null,null,null,"Solvency Capital Requirement (25% Op Risk)",null,null,null,"Capital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCRmarket",null,null,null,{"$f":"SCR_Market","v":0},null,{"$f":"nSCR_Market","v":0},null,null,null,null,null,"SCRmarket",null,null,null,{"$f":"SCR_Market","v":0}]
[null,"SCRdefault",null,null,null,{"$f":"SCR_Default","v":0},null,{"$f":"nSCR_Default","v":0},null,null,null,null,null,"SCRdefault",null,null,null,{"$f":"SCR_Default","v":0}]
[null,"SCRlife",null,null,null,{"$f":"SCR_Life","v":0},null,{"$f":"nSCR_Life","v":0},null,null,null,null,null,"SCRlife",null,null,null,{"$f":"SCR_Life","v":0}]
[null,"SCRhealth",null,null,null,{"$f":"'Health Underwriting Risk'!SCR_Health","v":0},null,{"$f":"'Health Underwriting Risk'!nSCR_Health","v":0},null,null,null,null,null,"SCRhealth",null,null,null,{"$f":"'Health Underwriting Risk'!SCR_Health","v":0}]
[null,"SCRintangibles",null,null,null,{"$f":"0.8*'Regulatory Balance Sheet'!$F$10","v":0},null,{"$f":"0.8*'Regulatory Balance Sheet'!$F$10","v":0},null,null,null,null,null,"SCRintangibles",null,null,"*",{"$f":"0.8*'Regulatory Balance Sheet'!$F$10","v":0}]
[]
[null,"BSCR (before diversification effects)",null,null,null,{"$f":"SUM(F7:F11)","v":0},null,{"$f":"SUM(H7:H11)","v":0},null,null,null,null,null,"BSCR (before diversification effects)",null,null,null,{"$f":"SUM(R7:R11)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F10),Corr),F7:F10))-SUM(F7:F10)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H10),Corr),H7:H10))-SUM(H7:H10)","v":0},null,null,null,null,null,"Diversification",null,null,"*",{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(R7:R10),Corr),R7:R10))-SUM(R7:R10)","v":0}]
[]
[null,"BSCR",null,null,null,{"$f":"SUM(F13,F15)","v":0},null,{"$f":"SUM(H13,H15)","v":0},null,null,null,null,null,"BSCR",null,null,null,{"$f":"SUM(R13,R15)","v":0}]
[]
[null,"SCROp_UL",null,null,null,{"$f":"EXPul","v":0},null,{"$f":"SCR_Op_UL","v":0},null,null,null,null,null,"SCROp_risk",null,null,"*",{"$f":"SCR_Op_UL*1/3","v":0}]
[]
[null,"SCROp_nonUL",null,null,null,{"$f":"+MAX(Op_premiums,Op_provisions)","v":0},null,{"$f":"SCRop_nonUL","v":0}]
[]
[null,"Adjustment for loss absorbing capacity of TPs",null,null,null,{"$f":"-MAX(0,MIN(BSCR-nBSCR,'Regulatory Balance Sheet'!F88+'Regulatory Balance Sheet'!F97))","v":0},null,null,null,null,null,null,null,"Adjustment for loss absorbing capacity of TPs",null,null,null,{"$f":"-MAX(0,MIN(BSCR-nBSCR,'Regulatory Balance Sheet'!R88+'Regulatory Balance Sheet'!R97))","v":0}]
[]
[null,"Adjustment for loss absorbing capacity of deferred taxes",null,null,null,null,null,null,null,null,null,null,null,"Adjustment for loss absorbing capacity of deferred tax"]
[]
[null,"Regulatory Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Regulatory Adjustment"]
[]
[null,"SCR",null,null,null,{"$f":"(BSCR^2+2*0.5*BSCR*SCR_Op_UL+SCR_Op_UL^2)^0.5+SUM(Adj_TP,Adj_DT,Adj_Reg,SCRop_nonUL)","v":0},null,null,null,null,null,null,null,"SCR",null,null,"*",{"$f":"SUM(R17,R19,R23,R25,R27)","v":0}]
[]
[]
[null,"Solvency Capital Requirement without Management Actions",null,null,null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCRnoMA",null,null,"*"]
[]
[]
[null,"Eligible Capital Resources",null,null,null,{"$f":"\"'000\"","v":"'000"},null,null,null,null,null,null,null,"Capital Resources"]
[]
[null,"Tier 1 Capital",null,null,null,{"$f":"EOF_Tier_1","v":0},null,null,null,null,null,null,null,"Tier 1 Capital",null,null,null,{"$f":"EOF_Tier_1","v":0}]
[null,"Tier 2 Capital",null,null,null,{"$f":"EOF_Tier_2","v":0},null,null,null,null,null,null,null,"Tier 2 Capital",null,null,null,{"$f":"EOF_Tier_2","v":0}]
[null,"Tier 3 Capital",null,null,null,{"$f":"EOF_Tier_3","v":0},null,null,null,null,null,null,null,"Tier 3 Capital",null,null,null,{"$f":"EOF_Tier_3","v":0}]
[]
[null,"Tier 1 Regulatory Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Regulatory Adjustment"]
[null,"Tier 2 Regulatory Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Regulatory Adjustment"]
[null,"Tier 3 Regulatory Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Tier 3 Regulatory Adjustment"]
[]
[null,"Regulatory capital resources to meet SCR",null,null,null,{"$f":"SUM(F39:F41,F43:F45)","v":0},null,null,null,null,null,null,null,"Regulatory capital resources to meet SCR",null,null,null,{"$f":"SUM(R39:R41,R43:R45)","v":0}]
[]
[null,"SCR Ratio",null,null,null,{"$f":"Cap_Res/SCR","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"SCR Ratio",null,null,null,{"$f":"R47/R29","v":{"$error":"#DIV/0!"}}]
[]
[null,"SCRnoMA Ratio",null,null,null,{"$f":"Cap_Res/F34","v":{"$error":"#DIV/0!"}}]

{"sheet":"MCR Summary","index":4,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"MCR Summary"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Minimum Capital Requirement",null,null,null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCR",null,null,null,{"$f":"SCR","v":0}]
[null,"SCRnoMA",null,null,null,{"$f":"'SCR Summary'!F34","v":0}]
[]
[null,"MCRSCR",null,null,null,{"$f":"MAX(0.35*F6,0.25*F7)","v":0}]
[null,"FMCR",null,null,null,3000]
[]
[null,"MCR",null,null,null,{"$f":"MAX(F9,F10)","v":3000}]
[]
[null,"Regulatory Adjustment"]
[]
[null,"MCR",null,null,"*",{"$f":"F12+F14","v":3000}]
[]
[]
[null,"Eligible Capital Resources",null,null,null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Tier 1 Capital",null,null,null,{"$f":"EOF_Tier_1","v":0}]
[null,"Tier 2 Capital",null,null,null,{"$f":"EOF_Tier_2","v":0}]
[null,"Tier 3 Capital",null,null,null,{"$f":"EOF_Tier_3","v":0}]
[]
[null,"Tier 1 Regulatory Adjustment",null,null,null,{"$f":"Tier_1_Adj","v":0}]
[null,"Tier 2 Regulatory Adjustment",null,null,null,{"$f":"Tier_2_Adj","v":0}]
[null,"Tier 3 Regulatory Adjustment",null,null,null,{"$f":"Tier_3_Adj","v":0}]
[]
[null,"Regulatory capital resources to meet MCR",null,null,null,{"$f":"SUM(F21:F23,F25:F27)","v":0}]
[]
[null,"MCR Ratio",null,null,null,{"$f":"F29/MCR_SII","v":0}]

{"sheet":"Regulatory Balance Sheet","index":5,"n_rows":164,"n_cols":9,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Regulatory Balance Sheet"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Balance Sheet - Assets",null,"Accounting basis        *",null,"Regulatory basis        *"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Fixed Assets"]
[]
[null,"Goodwill",null,{"$f":"'Raw Data'!$I$11","v":0},null,0]
[null,"Other intangible assets",null,{"$f":"'Raw Data'!$I$12","v":0},null,{"$f":"'Raw Data'!$I$13","v":0}]
[null,"Property, plant & equipment held for own use",null,{"$f":"'Raw Data'!$I$14","v":0},null,{"$f":"'Raw Data'!$I$15","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D9:D11)","v":0},null,{"$f":"SUM(F9:F11)","v":0}]
[]
[null,"Investments (other than assets held for unit-linked funds)"]
[]
[null,"Property (other than for own use)",null,{"$f":"'Raw Data'!$I$16","v":0},null,{"$f":"'Raw Data'!$I$17","v":0}]
[null,"Participations",null,{"$f":"'Raw Data'!$I$18","v":0},null,{"$f":"'Raw Data'!$I$19","v":0}]
[null,"Listed equities/other shares (other than participations)",null,{"$f":"'Raw Data'!$I$20","v":0},null,{"$f":"'Raw Data'!$I$21","v":0}]
[null,"Unlisted equities/other shares (other than participations)",null,{"$f":"'Raw Data'!$I$22","v":0},null,{"$f":"'Raw Data'!$I$23","v":0}]
[null,"Bonds - Government and multilateral banks",null,{"$f":"'Raw Data'!$I$24","v":0},null,{"$f":"'Raw Data'!$I$25","v":0}]
[null,"Bonds - Corporate (asset backed securities)",null,{"$f":"'Raw Data'!$I$26","v":0},null,{"$f":"'Raw Data'!$I$27","v":0}]
[null,"Bonds - Corporate (other)",null,{"$f":"'Raw Data'!$I$28","v":0},null,{"$f":"'Raw Data'!$I$29","v":0}]
[null,"Structured notes",null,{"$f":"'Raw Data'!$I$30","v":0},null,{"$f":"'Raw Data'!$I$31","v":0}]
[null,"Investment funds",null,{"$f":"'Raw Data'!$I$32","v":0},null,{"$f":"'Raw Data'!$I$33","v":0}]
[null,"Derivatives",null,{"$f":"SUM(D27:D31)","v":0},null,{"$f":"SUM(F27:F31)","v":0}]
[null,"Futures",null,{"$f":"'Raw Data'!$I$34","v":0},null,{"$f":"'Raw Data'!$I$35","v":0}]
[null,"Call Options",null,{"$f":"'Raw Data'!$I$36","v":0},null,{"$f":"'Raw Data'!$I$37","v":0}]
[null,"Put Options",null,{"$f":"'Raw Data'!$I$38","v":0},null,{"$f":"'Raw Data'!$I$39","v":0}]
[null,"Swaps",null,{"$f":"'Raw Data'!$I$40","v":0},null,{"$f":"'Raw Data'!$I$41","v":0}]
[null,"Forwards",null,{"$f":"'Raw Data'!$I$42","v":0},null,{"$f":"'Raw Data'!$I$43","v":0}]
[null,"Long term bank deposits",null,{"$f":"'Raw Data'!$I$44","v":0},null,{"$f":"'Raw Data'!$I$45","v":0}]
[null,"Other investments",null,{"$f":"'Raw Data'!$I$46","v":0},null,{"$f":"'Raw Data'!$I$47","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D17:D26,D32:D33)","v":0},null,{"$f":"SUM(F17:F26,F32:F33)","v":0}]
[]
[null,"Assets held for unit-linked funds"]
[]
[null,"Assets held for unit-linked funds",null,{"$f":"'Raw Data'!$I$48","v":0},null,{"$f":"'Raw Data'!$I$49","v":0}]
[null,"Cash deposits to cedants",null,{"$f":"'Raw Data'!$I$50","v":0},null,{"$f":"'Raw Data'!$I$51","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D39:D40)","v":0},null,{"$f":"SUM(F39:F40)","v":0}]
[]
[null,"Mortgages and loans made"]
[]
[null,"Uncollateralised loans made",null,{"$f":"'Raw Data'!$I$52","v":0},null,{"$f":"'Raw Data'!$I$53","v":0}]
[null,"Collateralised loans made (other than loans on policies)",null,{"$f":"'Raw Data'!$I$54","v":0},null,{"$f":"'Raw Data'!$I$55","v":0}]
[null,"Loans on policies",null,{"$f":"'Raw Data'!$I$56","v":0},null,{"$f":"'Raw Data'!$I$57","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D46:D48)","v":0},null,{"$f":"SUM(F46:F48)","v":0}]
[]
[null,"Reinsurance recoverables"]
[]
[null,"Reinsurance share of Technical Provisions",null,{"$f":"SUM(D55:D56)","v":0},null,{"$f":"SUM(F55:F56)","v":0}]
[null,"Life excluding unit-linked",null,{"$f":"'Raw Data'!$I$58","v":0},null,{"$f":"'Raw Data'!$I$59","v":0}]
[null,"Life unit-linked",null,{"$f":"'Raw Data'!$I$60","v":0},null,{"$f":"'Raw Data'!$I$61","v":0}]
[null,"Other reinsurance recoverables",null,{"$f":"'Raw Data'!$I$62","v":0},null,{"$f":"'Raw Data'!$I$63","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D55:D57)","v":0},null,{"$f":"SUM(F55:F57)","v":0}]
[]
[null,"Other Assets"]
[]
[null,"SPV recoverables",null,{"$f":"'Raw Data'!$I$64","v":0},null,{"$f":"'Raw Data'!$I$65","v":0}]
[null,"Intermediaries recoverables",null,{"$f":"'Raw Data'!$I$66","v":0},null,{"$f":"'Raw Data'!$I$67","v":0}]
[null,"Insurance recoverables (Excluding intermediaries)",null,{"$f":"'Raw Data'!$I$68","v":0},null,{"$f":"'Raw Data'!$I$69","v":0}]
[null,"Deferred acquisition costs",null,{"$f":"'Raw Data'!$I$70","v":0},null,0]
[null,"Receivables (trade, not insurance)",null,{"$f":"'Raw Data'!$I$71","v":0},null,{"$f":"'Raw Data'!$I$72","v":0}]
[null,"Pension benefit surplus",null,{"$f":"'Raw Data'!$I$73","v":0},null,{"$f":"'Raw Data'!$I$74","v":0}]
[null,"Cash and cash equivalents",null,{"$f":"'Raw Data'!$I$75","v":0},null,{"$f":"'Raw Data'!$I$76","v":0}]
[null,"Short term bank deposits",null,{"$f":"'Raw Data'!$I$77","v":0},null,{"$f":"'Raw Data'!$I$78","v":0}]
[null,"Amounts due in respect of called but unpaid capital",null,{"$f":"'Raw Data'!$I$79","v":0},null,{"$f":"'Raw Data'!$I$80","v":0}]
[null,"Other assets, not shown elsewhere",null,{"$f":"'Raw Data'!$I$81","v":0},null,{"$f":"'Raw Data'!$I$82","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D63:D72)","v":0},null,{"$f":"SUM(F63:F72)","v":0}]
[]
[null,"Total Assets"]
[]
[null,"TOTAL",null,{"$f":"SUM(D13,D35,D42,D50,D59,D74)","v":0},null,{"$f":"SUM(F13,F35,F42,F50,F59,F74)","v":0}]
[]
[]
[null,"Balance Sheet - Liabilities","*","Accounting basis",null,"Regulatory basis"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Technical Provisions - Life excluding unit-linked"]
[]
[null,"Technical provisions calculated as a whole (BEP+RM)",null,{"$f":"'Raw Data'!$I$83","v":0},null,0]
[null,"Best Estimate Provision - Value of Guaranteed Benefits",null,0,null,{"$f":"'Raw Data'!$I$84","v":0}]
[null,"Best Estimate Provision - Value of Discretionary Benefits",null,0,null,{"$f":"'Raw Data'!$I$85","v":0}]
[null,"Risk Margin",null,0,null,{"$f":"'Raw Data'!$I$86","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D86:D89)","v":0},null,{"$f":"SUM(F86:F89)","v":0}]
[]
[null,"Technical Provisions - Life unit-linked funds"]
[]
[null,"Technical provisions calculated as a whole (BEP+RM)",null,{"$f":"'Raw Data'!$I$87","v":0},null,0]
[null,"Best Estimate Provision - Value of Guaranteed Benefits",null,0,null,{"$f":"'Raw Data'!$I$88","v":0}]
[null,"Best Estimate Provision - Value of Discretionary Benefits",null,0,null,{"$f":"'Raw Data'!$I$89","v":0}]
[null,"Risk Margin",null,0,null,{"$f":"'Raw Data'!$I$90","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D95:D98)","v":0},null,{"$f":"SUM(F95:F98)","v":0}]
[]
[null,"Other Liabilities"]
[]
[null,"Cash deposits from reinsurers",null,{"$f":"'Raw Data'!$I$91","v":0},null,{"$f":"'Raw Data'!$I$92","v":0}]
[null,"Insurance accounts payable",null,{"$f":"'Raw Data'!$I$93","v":0},null,{"$f":"'Raw Data'!$I$94","v":0}]
[null,"Derivatives",null,{"$f":"'Raw Data'!$I$95","v":0},null,{"$f":"'Raw Data'!$I$96","v":0}]
[null,"Provisions other than technical provisions",null,{"$f":"'Raw Data'!$I$97","v":0},null,{"$f":"'Raw Data'!$I$98","v":0}]
[null,"Amounts owed to credit institutions",null,{"$f":"'Raw Data'!$I$99","v":0},null,{"$f":"'Raw Data'!$I$100","v":0}]
[null,"Financial liabs (other than owed to credit institutions)",null,{"$f":"'Raw Data'!$I$101","v":0},null,{"$f":"'Raw Data'!$I$102","v":0}]
[null,"Payables (trade, not insurance)",null,{"$f":"'Raw Data'!$I$103","v":0},null,{"$f":"'Raw Data'!$I$104","v":0}]
[null,"Pensions benefit obligations",null,{"$f":"'Raw Data'!$I$105","v":0},null,{"$f":"'Raw Data'!$I$106","v":0}]
[null,"Uncalled investments",null,{"$f":"'Raw Data'!$I$107","v":0},null,{"$f":"'Raw Data'!$I$108","v":0}]
[null,"Contingent liabilities",null,{"$f":"'Raw Data'!$I$109","v":0},null,{"$f":"'Raw Data'!$I$110","v":0}]
[null,"Any other liabilities not shown elsewhere",null,{"$f":"'Raw Data'!$I$111","v":0},null,{"$f":"'Raw Data'!$I$112","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D104:D114)","v":0},null,{"$f":"SUM(F104:F114)","v":0}]
[]
[null,"Total Liabilities"]
[]
[null,"TOTAL",null,{"$f":"SUM(D91,D100,D116)","v":0},null,{"$f":"SUM(F91,F100,F116)","v":0}]
[]
[]
[null,"Net Assets",null,"Accounting basis",null,"Regulatory basis"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"TOTAL",null,{"$f":"Acc_Total_Assets-Acc_Total_Liabs","v":0},null,{"$f":"Reg_Total_Assets-Reg_Total_Liabs","v":0}]
[]
[]
[null,"Capital","*","Accounting basis",null,"Regulatory basis"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Capital and Reserves"]
[]
[null,"Share Capital",null,null,null,{"$f":"'Own Funds'!J12","v":0}]
[null,"Initial fund",null,null,null,{"$f":"'Own Funds'!J20","v":0}]
[null,"Share premium",null,null,null,{"$f":"'Own Funds'!J24","v":0}]
[null,"Retained earnings",null,null,null,{"$f":"'Own Funds'!J28","v":0}]
[null,"Other reserves from accounting balance sheet",null,null,null,{"$f":"'Own Funds'!J32","v":0}]
[null,"Surplus funds",null,null,null,{"$f":"'Own Funds'!J46","v":0}]
[null,"Expected profit in future premiums ('EPIFP') ",null,0,null,{"$f":"'Own Funds'!J50","v":0}]
[null,"Preference Shares",null,null,null,{"$f":"'Own Funds'!J58","v":0}]
[null,"Subordinated liabilities",null,null,null,{"$f":"'Own Funds'!J66","v":0}]
[null,"Approved ancillary own funds","*",null,null,{"$f":"AOF_Total","v":0}]
[null,"Other items not specified above",null,null,null,{"$f":"'Own Funds'!J74","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D134:D144)","v":0},null,{"$f":"SUM(F134:F144)","v":0}]
[]
[null,"Reconciliation reserve"]
[]
[null,"Adjustment to assets",null,0,null,{"$f":"'Own Funds'!J36","v":0}]
[null,"Adjustment to technical provisions",null,0,null,{"$f":"'Own Funds'!J37","v":0}]
[null,"less EPIFP",null,0,null,{"$f":"'Own Funds'!J38","v":0}]
[null,"Adjustments to other liabilities",null,0,null,{"$f":"'Own Funds'!J39","v":0}]
[null,"Others",null,0,null,{"$f":"'Own Funds'!J40","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D150:D154)","v":0},null,{"$f":"SUM(F150:F154)","v":0}]
[]
[null,"Total Capital and Reserves"]
[]
[null,"TOTAL",null,{"$f":"D146","v":0},null,{"$f":"SUM(F156,F146)","v":0}]
[]
[]
[]
[null,"Check balance sheet is balanced",null,{"$f":"IF(AND(ABS(Acc_NAV-Acc_Cap)<0.001,I78<>\"ERROR\",I120<>\"ERROR\",I160<>\"ERROR\"),\"OK\",\"ERROR\")","v":"OK"},null,{"$f":"IF(AND(ABS(Reg_NAV-Reg_Cap)<0.001,I78<>\"ERROR\",I120<>\"ERROR\",I160<>\"ERROR\"),\"OK\",\"ERROR\")","v":"OK"}]

{"sheet":"Own Funds","index":6,"n_rows":128,"n_cols":13,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Own Funds"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Basic Own Funds *",null,"Tier 1",null,"Tier 2",null,"Tier 3",null,"Total"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Ordinary Share Capital (net of own shares)"]
[]
[null,"Paid up",null,null,null,null,null,0,null,{"$f":"SUM(D9,F9,H9)","v":0}]
[null,"Called up",null,0,null,null,null,0,null,{"$f":"SUM(D10,F10,H10)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D9:D10)","v":0},null,{"$f":"SUM(F9:F10)","v":0},null,{"$f":"SUM(H9:H10)","v":0},null,{"$f":"SUM(J9:J10)","v":0}]
[]
[null,"Initial Fund (less item of the same type held)"]
[]
[null,"Paid up",null,null,null,null,null,null,null,{"$f":"SUM(D16,F16,H16)","v":0}]
[null,"Called up",null,0,null,null,null,null,null,{"$f":"SUM(D17,F17,H17)","v":0}]
[null,"Callable",null,0,null,null,null,null,null,{"$f":"SUM(D18,F18,H18)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D16:D18)","v":0},null,{"$f":"SUM(F16:F18)","v":0},null,{"$f":"SUM(H16:H18)","v":0},null,{"$f":"SUM(J16:J18)","v":0}]
[]
[null,"Share Premium Account"]
[]
[null,"Share Premium Account",null,null,null,null,null,0,null,{"$f":"SUM(D24,F24,H24)","v":0}]
[]
[null,"Retained earnings including profits from the year net of foreseeable dividends"]
[]
[null,"Retained earnings",null,null,null,0,null,0,null,{"$f":"SUM(D28,F28,H28)","v":0}]
[]
[null,"Other reserves from accounting balance sheet"]
[]
[null,"Other reserves",null,null,null,null,null,0,null,{"$f":"SUM(D32,F32,H32)","v":0}]
[]
[null,"Reconciliation reserve"]
[]
[null,"Adjustment to assets",null,{"$f":"Reg_Total_Assets-Acc_Total_Assets","v":0},null,0,null,0,null,{"$f":"SUM(D36,F36,H36)","v":0}]
[null,"Adjustments to technical provisions",null,{"$f":"SUM('Regulatory Balance Sheet'!D91,'Regulatory Balance Sheet'!D100)-SUM('Regulatory Balance Sheet'!F91,'Regulatory Balance Sheet'!F100)","v":0},null,0,null,0,null,{"$f":"SUM(D37,F37,H37)","v":0}]
[null,"less expected profit in future premiums(EPIFP)",null,{"$f":"-D50","v":0},null,0,null,0,null,0]
[null,"Adjustments to other liabilities",null,{"$f":"'Regulatory Balance Sheet'!D116-'Regulatory Balance Sheet'!F116","v":0},null,0,null,0,null,{"$f":"SUM(D39,F39,H39)","v":0}]
[null,"Others",null,null,null,null,null,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D36:D40)","v":0},null,{"$f":"SUM(F36:F40)","v":0},null,{"$f":"SUM(H36:H40)","v":0},null,{"$f":"SUM(J36:J40)","v":0}]
[]
[null,"Surplus funds"]
[]
[null,"Surplus funds",null,null,null,0,null,0,null,{"$f":"SUM(D46,F46,H46)","v":0}]
[]
[null,"Expected profit in future premiums (EPIFP)"]
[]
[null,"EPIFP",null,null,null,0,null,0,null,{"$f":"SUM(D50,F50,H50)","v":0}]
[]
[null,"Preference shares"]
[]
[null,"Dated",null,null,null,null,null,null,null,{"$f":"SUM(D54,F54,H54)","v":0}]
[null,"Undated with a call option",null,null,null,null,null,null,null,{"$f":"SUM(D55,F55,H55)","v":0}]
[null,"Undated with no contractual opportunity to redeem",null,null,null,null,null,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D54:D56)","v":0},null,{"$f":"SUM(F54:F56)","v":0},null,{"$f":"SUM(H54:H56)","v":0},null,{"$f":"SUM(J54:J56)","v":0}]
[]
[null,"Subordinated liabilities"]
[]
[null,"Dated",null,null,null,null,null,null,null,{"$f":"SUM(D62,F62,H62)","v":0}]
[null,"Undated with a call option",null,null,null,null,null,null,null,{"$f":"SUM(D63,F63,H63)","v":0}]
[null,"Undated with no contractual opportunity to redeem",null,null,null,null,null,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D62:D64)","v":0},null,{"$f":"SUM(F62:F64)","v":0},null,{"$f":"SUM(H62:H64)","v":0},null,{"$f":"SUM(J62:J64)","v":0}]
[]
[null,"Subordinated mutual member accounts"]
[]
[null,"Subordinated mutual member accounts",null,null,null,null,null,null,null,{"$f":"SUM(D70,F70,H70)","v":0}]
[]
[null,"Other items not specified elsewhere"]
[]
[null,"Other items",null,null,null,null,null,null,null,{"$f":"SUM(D74,F74,H74)","v":0}]
[]
[null,"Total Basic Own Funds"]
[]
[null,"TOTAL",null,{"$f":"SUM(D12,D20,D24,D28,D32,D42,D46,D50,D58,D66,D70,D74)","v":0},null,{"$f":"SUM(F12,F20,F24,F28,F32,F42,F46,F50,F58,F66,F70,F74)","v":0},null,{"$f":"SUM(H12,H20,H24,H28,H32,H42,H46,H50,H58,H66,H70,H74)","v":0},null,{"$f":"SUM(D78,F78,H78)","v":0}]
[]
[]
[null,"Adjustments to BOF",null,"Tier 1",null,"Tier 2",null,"Tier 3",null,"Total"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Deductions"]
[]
[null,"Restricted reserves",null,null,null,0,null,0,null,{"$f":"SUM(D86,F86,H86)","v":0}]
[null,"Ring fenced funds (excess OF over notional SCR)",null,null,null,0,null,0,null,{"$f":"SUM(D87,F87,H87)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D86:D87)","v":0},null,{"$f":"SUM(F86:F87)","v":0},null,{"$f":"SUM(H86:H87)","v":0},null,{"$f":"SUM(J86:J87)","v":0}]
[]
[null,"Change of tier"]
[]
[null,"Restricted reserves",null,null,null,{"$f":"-D93","v":0},null,0,null,{"$f":"SUM(D93,F93,H93)","v":0}]
[null,"Other adjustments",null,null,null,null,null,null,null,{"$f":"SUM(D94,F94,H94)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D93:D94)","v":0},null,{"$f":"SUM(F93:F94)","v":0},null,{"$f":"SUM(H93:H94)","v":0},null,{"$f":"SUM(J93:J94)","v":0}]
[]
[null,"Total Adjustments"]
[]
[null,"TOTAL",null,{"$f":"D96-D89","v":0},null,{"$f":"F96-F89","v":0},null,{"$f":"H96-H89","v":0},null,{"$f":"SUM(D100,F100,H100)","v":0}]
[]
[]
[null,"Total Eligible Own Funds to meet SCR"]
[]
[null,"Eligible Own Funds",null,{"$f":"SUM(BOF_Tier_1,BOF_Adj_Tier_1)","v":0},null,{"$f":"SUM(BOF_Tier_2,BOF_Adj_Tier_2)","v":0},null,{"$f":"SUM(BOF_Tier_3,BOF_Adj_Tier_3)","v":0},null,{"$f":"SUM(BOF_Total,BOF_Adj_Total)","v":0}]
[]
[]
[null,"Approved Ancillary own fund items ","*","Tier 1",null,"Tier 2",null,"Tier 3",null,"Total"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Unpaid share capital or initial fund that has not been paid up"]
[]
[null,"Total",null,0,null,null,null,null,null,{"$f":"SUM(D113,F113,H113)","v":0}]
[]
[null,"Letters of credit and guarantees held in trust"]
[]
[null,"Letter of credit",null,0,null,null,null,null,null,{"$f":"SUM(D117,F117,H117)","v":0}]
[null,"Guarantees held in trust",null,0,null,null,null,null,null,{"$f":"SUM(D118,F118,H118)","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D116:D118)","v":0},null,{"$f":"SUM(F117:F118)","v":0},null,{"$f":"SUM(H117:H118)","v":0},null,{"$f":"SUM(J117:J118)","v":0}]
[]
[null,"Other items approved by the Authority as eligible to meet requirements under current solvency regime"]
[]
[null,"Other items",null,0,null,null,null,null,null,{"$f":"SUM(D124,F124,H124)","v":0}]
[]
[null,"Total  Approved Ancillary Own Funds"]
[]
[null,"TOTAL",null,{"$f":"SUM(D113,D120,D124,)","v":0},null,{"$f":"SUM(F113,F120,F124,)","v":0},null,{"$f":"SUM(H113,H120,H124,)","v":0},null,{"$f":"SUM(J113,J120,J124,)","v":0}]

{"sheet":"Operational Risk","index":7,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Operational Risk"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Operational Risk",null,null,"Current Valuation Date",null,"Previous Valuation Date",null,null,"EXPUL",null,null,"OpPremiums",null,"OpProvisions"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,null,{"$f":"\"'000\"","v":"'000"},null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,null,"Total expenses allocated to Unit Linked business",null,{"$f":"'Raw Data'!I6","v":0},null,null,null,null,{"$f":"E7","v":0}]
[]
[null,null,"Earned Premiums ",null,{"$f":"'Raw Data'!I7","v":0},null,{"$f":"'Raw Data'!I8","v":0},null,null,null,null,null,{"$f":"(0.04*E9)+MAX(0,0.04*(E9-1.2*G9))","v":0}]
[]
[null,null,"Technical Provisions ",null,{"$f":"'Raw Data'!I9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"0.0045*MAX(E11,0)","v":0}]

{"sheet":"Market Risk","index":8,"n_rows":159,"n_cols":19,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Market Risk"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Market Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketinterest",null,null,null,{"$f":"Mkt_Int","v":0},null,{"$f":"nMkt_Int","v":0}]
[null,"Marketequity",null,null,null,{"$f":"Mkt_Eq","v":0},null,{"$f":"nMkt_Eq","v":0}]
[null,"Marketproperty",null,null,null,{"$f":"Mkt_Prop","v":0},null,{"$f":"nMkt_Prop","v":0}]
[null,"Marketfx",null,null,null,{"$f":"IF(Curr_Simp=\"N\",Mkt_Curr,IF(Curr_Simp=\"Y\",Mkt_Curr_Simp,0))","v":0},null,{"$f":"IF(Curr_Simp=\"N\",nMkt_Curr,IF(Curr_Simp=\"Y\",nMkt_Curr_Simp,0))","v":0}]
[null,"Marketspread",null,null,null,{"$f":"Mkt_Sp","v":0},null,{"$f":"nMkt_Sp","v":0}]
[null,"Marketconc",null,null,null,{"$f":"Mkt_Conc","v":0},null,{"$f":"nMkt_Conc","v":0}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(F7:F12)","v":0},null,{"$f":"SUM(H7:H12)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"F18-F14","v":0},null,{"$f":"H18-H14","v":0}]
[]
[null,"SCRmarket",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F12),MarketCorr),F7:F12))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H12),MarketCorr),H7:H12))","v":0}]
[]
[]
[null,"Simplification to be used?"]
[]
[null,"Currency","*","N"]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"Reg_Total_Assets","v":0},null,{"$f":"SUM('Regulatory Balance Sheet'!$F$87,'Regulatory Balance Sheet'!$F$96)","v":0},null,{"$f":"SUM('Regulatory Balance Sheet'!$F$88,'Regulatory Balance Sheet'!$F$97)","v":0},null,{"$f":"$D29-$F29-$H29","v":0},null,{"$f":"$D29-$F29-$H29","v":0}]
[]
[]
[null,"Interest Rate Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"MarketinterestUp",null,{"$f":"'Raw Data'!$I$114","v":0},null,{"$f":"'Raw Data'!$I$115","v":0},null,{"$f":"'Raw Data'!$I$116","v":0},null,{"$f":"$D35-$F35-BE_Liabs_VDB","v":0},null,{"$f":"$D35-$F35-$H35","v":0},null,{"$f":"-($J35-$J$29)","v":0},null,{"$f":"-($L35-$L$29)","v":0}]
[null,"MarketinterestDown",null,{"$f":"'Raw Data'!$I$117","v":0},null,{"$f":"'Raw Data'!$I$118","v":0},null,{"$f":"'Raw Data'!$I$119","v":0},null,{"$f":"$D36-$F36-BE_Liabs_VDB","v":0},null,{"$f":"$D36-$F36-$H36","v":0},null,{"$f":"-($J36-$J$29)","v":0},null,{"$f":"-($L36-$L$29)","v":0}]
[]
[null,"Marketinterest",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_Int_Up>nMkt_Int_Down,Mkt_Int_Up,Mkt_Int_Down))","v":0},null,{"$f":"MAX(0,nMkt_Int_Up,nMkt_Int_Down)","v":0}]
[]
[]
[null,"Equity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketequity,1VolUp",null,{"$f":"'Raw Data'!$I$120","v":0},null,{"$f":"'Raw Data'!$I$121","v":0},null,{"$f":"'Raw Data'!$I$122","v":0},null,{"$f":"$D44-$F44-BE_Liabs_VDB","v":0},null,{"$f":"$D44-$F44-$H44","v":0},null,{"$f":"MAX(0,-($J44-$J$29))","v":0},null,{"$f":"MAX(0,-($L44-$L$29))","v":0}]
[null,"Marketequity,1Level",null,{"$f":"'Raw Data'!$I$123","v":0},null,{"$f":"'Raw Data'!$I$124","v":0},null,{"$f":"'Raw Data'!$I$125","v":0},null,{"$f":"$D45-$F45-BE_Liabs_VDB","v":0},null,{"$f":"$D45-$F45-$H45","v":0},null,{"$f":"MAX(0,-($J45-$J$29))","v":0},null,{"$f":"MAX(0,-($L45-$L$29))","v":0}]
[null,"Marketequity,1VolDown",null,{"$f":"'Raw Data'!$I$126","v":0},null,{"$f":"'Raw Data'!$I$127","v":0},null,{"$f":"'Raw Data'!$I$128","v":0},null,{"$f":"$D46-$F46-BE_Liabs_VDB","v":0},null,{"$f":"$D46-$F46-$H46","v":0},null,{"$f":"MAX(0,-($J46-$J$29))","v":0},null,{"$f":"MAX(0,-($L46-$L$29))","v":0}]
[]
[null,"Marketequity,2VolUp",null,{"$f":"'Raw Data'!$I$129","v":0},null,{"$f":"'Raw Data'!$I$130","v":0},null,{"$f":"'Raw Data'!$I$131","v":0},null,{"$f":"$D48-$F48-BE_Liabs_VDB","v":0},null,{"$f":"$D48-$F48-$H48","v":0},null,{"$f":"MAX(0,-($J48-$J$29))","v":0},null,{"$f":"MAX(0,-($L48-$L$29))","v":0}]
[null,"Marketequity,2Level",null,{"$f":"'Raw Data'!$I$132","v":0},null,{"$f":"'Raw Data'!$I$133","v":0},null,{"$f":"'Raw Data'!$I$134","v":0},null,{"$f":"$D49-$F49-BE_Liabs_VDB","v":0},null,{"$f":"$D49-$F49-$H49","v":0},null,{"$f":"MAX(0,-($J49-$J$29))","v":0},null,{"$f":"MAX(0,-($L49-$L$29))","v":0}]
[null,"Marketequity,2VolDown",null,{"$f":"'Raw Data'!$I$135","v":0},null,{"$f":"'Raw Data'!$I$136","v":0},null,{"$f":"'Raw Data'!$I$137","v":0},null,{"$f":"$D50-$F50-BE_Liabs_VDB","v":0},null,{"$f":"$D50-$F50-$H50","v":0},null,{"$f":"MAX(0,-($J50-$J$29))","v":0},null,{"$f":"MAX(0,-($L50-$L$29))","v":0}]
[]
[null,"Marketequity,1Level & VolUp",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N44:N45),EqVolUpCorr),N44:N45))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P44:P45),EqVolUpCorr),P44:P45))","v":0}]
[null,"Marketequity,1Level & VolDown",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N45:N46),EqVolDownCorr),N45:N46))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P45:P46),EqVolDownCorr),P45:P46))","v":0}]
[]
[null,"Marketequity,2Level & VolUp",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N48:N49),EqVolUpCorr),N48:N49))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P48:P49),EqVolUpCorr),P48:P49))","v":0}]
[null,"Marketequity,2Level & VolDown",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N49:N50),EqVolDownCorr),N49:N50))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P49:P50),EqVolDownCorr),P49:P50))","v":0}]
[]
[null,"Marketequity,1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nEq_1_vol_Up>nEq_1_vol_Down,Eq_1_vol_Up,Eq_1_vol_Down)","v":0},null,{"$f":"MAX(nEq_1_vol_Up,nEq_1_vol_Down)","v":0}]
[null,"Marketequity,2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nEq_2_vol_Up>nEq_2_vol_Down,Eq_2_vol_Up,Eq_2_vol_Down)","v":0},null,{"$f":"MAX(nEq_2_vol_Up,nEq_2_vol_Down)","v":0}]
[]
[null,"Marketequity",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N58:N59),EqCorr),N58:N59))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P58:P59),EqCorr),P58:P59))","v":0}]
[]
[]
[null,"Property Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketproperty",null,{"$f":"'Raw Data'!$I$138","v":0},null,{"$f":"'Raw Data'!$I$139","v":0},null,{"$f":"'Raw Data'!$I$140","v":0},null,{"$f":"$D67-$F67-BE_Liabs_VDB","v":0},null,{"$f":"$D67-$F67-$H67","v":0},null,{"$f":"MAX(0,-($J67-$J$29))","v":0},null,{"$f":"MAX(0,-($L67-$L$29))","v":0}]
[]
[]
[null,"Currency Risk                        ",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketfx,CurrGroup1Up",null,{"$f":"'Raw Data'!$I$141","v":0},null,{"$f":"'Raw Data'!$I$142","v":0},null,{"$f":"'Raw Data'!$I$143","v":0},null,{"$f":"$D73-$F73-H73","v":0},null,{"$f":"$D73-$F73-$H73","v":0},null,{"$f":"-($J73-$J$29)","v":0},null,{"$f":"-($L73-$L$29)","v":0}]
[null,"Marketfx,CurrGroup1Down",null,{"$f":"'Raw Data'!$I$144","v":0},null,{"$f":"'Raw Data'!$I$145","v":0},null,{"$f":"'Raw Data'!$I$146","v":0},null,{"$f":"$D74-$F74-H74","v":0},null,{"$f":"$D74-$F74-$H74","v":0},null,{"$f":"-($J74-$J$29)","v":0},null,{"$f":"-($L74-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup2Up",null,{"$f":"'Raw Data'!$I$147","v":0},null,{"$f":"'Raw Data'!$I$148","v":0},null,{"$f":"'Raw Data'!$I$149","v":0},null,{"$f":"$D76-$F76-H76","v":0},null,{"$f":"$D76-$F76-$H76","v":0},null,{"$f":"-($J76-$J$29)","v":0},null,{"$f":"-($L76-$L$29)","v":0}]
[null,"Marketfx,CurrGroup2Down",null,{"$f":"'Raw Data'!$I$150","v":0},null,{"$f":"'Raw Data'!$I$151","v":0},null,{"$f":"'Raw Data'!$I$152","v":0},null,{"$f":"$D77-$F77-H77","v":0},null,{"$f":"$D77-$F77-$H77","v":0},null,{"$f":"-($J77-$J$29)","v":0},null,{"$f":"-($L77-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup3Up",null,{"$f":"'Raw Data'!$I$153","v":0},null,{"$f":"'Raw Data'!$I$154","v":0},null,{"$f":"'Raw Data'!$I$155","v":0},null,{"$f":"$D79-$F79-H79","v":0},null,{"$f":"$D79-$F79-$H79","v":0},null,{"$f":"-($J79-$J$29)","v":0},null,{"$f":"-($L79-$L$29)","v":0}]
[null,"Marketfx,CurrGroup3Down",null,{"$f":"'Raw Data'!$I$156","v":0},null,{"$f":"'Raw Data'!$I$157","v":0},null,{"$f":"'Raw Data'!$I$158","v":0},null,{"$f":"$D80-$F80-H80","v":0},null,{"$f":"$D80-$F80-$H80","v":0},null,{"$f":"-($J80-$J$29)","v":0},null,{"$f":"-($L80-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup4Up",null,{"$f":"'Raw Data'!$I$159","v":0},null,{"$f":"'Raw Data'!$I$160","v":0},null,{"$f":"'Raw Data'!$I$161","v":0},null,{"$f":"$D82-$F82-H82","v":0},null,{"$f":"$D82-$F82-$H82","v":0},null,{"$f":"-($J82-$J$29)","v":0},null,{"$f":"-($L82-$L$29)","v":0}]
[null,"Marketfx,CurrGroup4Down",null,{"$f":"'Raw Data'!$I$162","v":0},null,{"$f":"'Raw Data'!$I$163","v":0},null,{"$f":"'Raw Data'!$I$164","v":0},null,{"$f":"$D83-$F83-H83","v":0},null,{"$f":"$D83-$F83-$H83","v":0},null,{"$f":"-($J83-$J$29)","v":0},null,{"$f":"-($L83-$L$29)","v":0}]
[null,null,null,null,null,null,null,null,null,"."]
[null,"Marketfx,CurrGroup5Up",null,{"$f":"'Raw Data'!$I$165","v":0},null,{"$f":"'Raw Data'!$I$166","v":0},null,{"$f":"'Raw Data'!$I$167","v":0},null,{"$f":"$D85-$F85-H85","v":0},null,{"$f":"$D85-$F85-$H85","v":0},null,{"$f":"-($J85-$J$29)","v":0},null,{"$f":"-($L85-$L$29)","v":0}]
[null,"Marketfx,CurrGroup5Down",null,{"$f":"'Raw Data'!$I$168","v":0},null,{"$f":"'Raw Data'!$I$169","v":0},null,{"$f":"'Raw Data'!$I$170","v":0},null,{"$f":"$D86-$F86-H86","v":0},null,{"$f":"$D86-$F86-$H86","v":0},null,{"$f":"-($J86-$J$29)","v":0},null,{"$f":"-($L86-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup6Up",null,{"$f":"'Raw Data'!$I$171","v":0},null,{"$f":"'Raw Data'!$I$172","v":0},null,{"$f":"'Raw Data'!$I$173","v":0},null,{"$f":"$D88-$F88-H88","v":0},null,{"$f":"$D88-$F88-$H88","v":0},null,{"$f":"-($J88-$J$29)","v":0},null,{"$f":"-($L88-$L$29)","v":0}]
[null,"Marketfx,CurrGroup6Down",null,{"$f":"'Raw Data'!$I$174","v":0},null,{"$f":"'Raw Data'!$I$175","v":0},null,{"$f":"'Raw Data'!$I$176","v":0},null,{"$f":"$D89-$F89-H89","v":0},null,{"$f":"$D89-$F89-$H89","v":0},null,{"$f":"-($J89-$J$29)","v":0},null,{"$f":"-($L89-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup7Up",null,{"$f":"'Raw Data'!$I$177","v":0},null,{"$f":"'Raw Data'!$I$178","v":0},null,{"$f":"'Raw Data'!$I$179","v":0},null,{"$f":"$D91-$F91-H91","v":0},null,{"$f":"$D91-$F91-$H91","v":0},null,{"$f":"-($J91-$J$29)","v":0},null,{"$f":"-($L91-$L$29)","v":0}]
[null,"Marketfx,CurrGroup7Down",null,{"$f":"'Raw Data'!$I$180","v":0},null,{"$f":"'Raw Data'!$I$181","v":0},null,{"$f":"'Raw Data'!$I$182","v":0},null,{"$f":"$D92-$F92-H92","v":0},null,{"$f":"$D92-$F92-$H92","v":0},null,{"$f":"-($J92-$J$29)","v":0},null,{"$f":"-($L92-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup8Up",null,{"$f":"'Raw Data'!$I$183","v":0},null,{"$f":"'Raw Data'!$I$184","v":0},null,{"$f":"'Raw Data'!$I$185","v":0},null,{"$f":"$D94-$F94-H94","v":0},null,{"$f":"$D94-$F94-$H94","v":0},null,{"$f":"-($J94-$J$29)","v":0},null,{"$f":"-($L94-$L$29)","v":0}]
[null,"Marketfx,CurrGroup8Down",null,{"$f":"'Raw Data'!$I$186","v":0},null,{"$f":"'Raw Data'!$I$187","v":0},null,{"$f":"'Raw Data'!$I$188","v":0},null,{"$f":"$D95-$F95-H95","v":0},null,{"$f":"$D95-$F95-$H95","v":0},null,{"$f":"-($J95-$J$29)","v":0},null,{"$f":"-($L95-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup9Up",null,{"$f":"'Raw Data'!$I$189","v":0},null,{"$f":"'Raw Data'!$I$190","v":0},null,{"$f":"'Raw Data'!$I$191","v":0},null,{"$f":"$D97-$F97-H97","v":0},null,{"$f":"$D97-$F97-$H97","v":0},null,{"$f":"-($J97-$J$29)","v":0},null,{"$f":"-($L97-$L$29)","v":0}]
[null,"Marketfx,CurrGroup9Down",null,{"$f":"'Raw Data'!$I$192","v":0},null,{"$f":"'Raw Data'!$I$193","v":0},null,{"$f":"'Raw Data'!$I$194","v":0},null,{"$f":"$D98-$F98-H98","v":0},null,{"$f":"$D98-$F98-$H98","v":0},null,{"$f":"-($J98-$J$29)","v":0},null,{"$f":"-($L98-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup10Up",null,{"$f":"'Raw Data'!$I$195","v":0},null,{"$f":"'Raw Data'!$I$196","v":0},null,{"$f":"'Raw Data'!$I$197","v":0},null,{"$f":"$D100-$F100-H100","v":0},null,{"$f":"$D100-$F100-$H100","v":0},null,{"$f":"-($J100-$J$29)","v":0},null,{"$f":"-($L100-$L$29)","v":0}]
[null,"Marketfx,CurrGroup10Down",null,{"$f":"'Raw Data'!$I$198","v":0},null,{"$f":"'Raw Data'!$I$199","v":0},null,{"$f":"'Raw Data'!$I$200","v":0},null,{"$f":"$D101-$F101-H101","v":0},null,{"$f":"$D101-$F101-$H101","v":0},null,{"$f":"-($J101-$J$29)","v":0},null,{"$f":"-($L101-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup11Up",null,{"$f":"'Raw Data'!$I$201","v":0},null,{"$f":"'Raw Data'!$I$202","v":0},null,{"$f":"'Raw Data'!$I$203","v":0},null,{"$f":"$D103-$F103-H103","v":0},null,{"$f":"$D103-$F103-$H103","v":0},null,{"$f":"-($J103-$J$29)","v":0},null,{"$f":"-($L103-$L$29)","v":0}]
[null,"Marketfx,CurrGroup11Down",null,{"$f":"'Raw Data'!$I$204","v":0},null,{"$f":"'Raw Data'!$I$205","v":0},null,{"$f":"'Raw Data'!$I$206","v":0},null,{"$f":"$D104-$F104-H104","v":0},null,{"$f":"$D104-$F104-$H104","v":0},null,{"$f":"-($J104-$J$29)","v":0},null,{"$f":"-($L104-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup12Up",null,{"$f":"'Raw Data'!$I$207","v":0},null,{"$f":"'Raw Data'!$I$208","v":0},null,{"$f":"'Raw Data'!$I$209","v":0},null,{"$f":"$D106-$F106-H106","v":0},null,{"$f":"$D106-$F106-$H106","v":0},null,{"$f":"-($J106-$J$29)","v":0},null,{"$f":"-($L106-$L$29)","v":0}]
[null,"Marketfx,CurrGroup12Down",null,{"$f":"'Raw Data'!$I$210","v":0},null,{"$f":"'Raw Data'!$I$211","v":0},null,{"$f":"'Raw Data'!$I$212","v":0},null,{"$f":"$D107-$F107-H107","v":0},null,{"$f":"$D107-$F107-$H107","v":0},null,{"$f":"-($J107-$J$29)","v":0},null,{"$f":"-($L107-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup13Up",null,{"$f":"'Raw Data'!$I$213","v":0},null,{"$f":"'Raw Data'!$I$214","v":0},null,{"$f":"'Raw Data'!$I$215","v":0},null,{"$f":"$D109-$F109-H109","v":0},null,{"$f":"$D109-$F109-$H109","v":0},null,{"$f":"-($J109-$J$29)","v":0},null,{"$f":"-($L109-$L$29)","v":0}]
[null,"Marketfx,CurrGroup13Down",null,{"$f":"'Raw Data'!$I$216","v":0},null,{"$f":"'Raw Data'!$I$217","v":0},null,{"$f":"'Raw Data'!$I$218","v":0},null,{"$f":"$D110-$F110-H110","v":0},null,{"$f":"$D110-$F110-$H110","v":0},null,{"$f":"-($J110-$J$29)","v":0},null,{"$f":"-($L110-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup14Up",null,{"$f":"'Raw Data'!$I$219","v":0},null,{"$f":"'Raw Data'!$I$220","v":0},null,{"$f":"'Raw Data'!$I$221","v":0},null,{"$f":"$D112-$F112-H112","v":0},null,{"$f":"$D112-$F112-$H112","v":0},null,{"$f":"-($J112-$J$29)","v":0},null,{"$f":"-($L112-$L$29)","v":0}]
[null,"Marketfx,CurrGroup14Down",null,{"$f":"'Raw Data'!$I$222","v":0},null,{"$f":"'Raw Data'!$I$223","v":0},null,{"$f":"'Raw Data'!$I$224","v":0},null,{"$f":"$D113-$F113-H113","v":0},null,{"$f":"$D113-$F113-$H113","v":0},null,{"$f":"-($J113-$J$29)","v":0},null,{"$f":"-($L113-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup15Up",null,{"$f":"'Raw Data'!$I$225","v":0},null,{"$f":"'Raw Data'!$I$226","v":0},null,{"$f":"'Raw Data'!$I$227","v":0},null,{"$f":"$D115-$F115-H115","v":0},null,{"$f":"$D115-$F115-$H115","v":0},null,{"$f":"-($J115-$J$29)","v":0},null,{"$f":"-($L115-$L$29)","v":0}]
[null,"Marketfx,CurrGroup15Down",null,{"$f":"'Raw Data'!$I$228","v":0},null,{"$f":"'Raw Data'!$I$229","v":0},null,{"$f":"'Raw Data'!$I$230","v":0},null,{"$f":"$D116-$F116-H116","v":0},null,{"$f":"$D116-$F116-$H116","v":0},null,{"$f":"-($J116-$J$29)","v":0},null,{"$f":"-($L116-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_1_Up>nMkt_fx_1_Down,Mkt_fx_1_Up,Mkt_fx_1_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_1_Up,nMkt_fx_1_Down)","v":0}]
[null,"Marketfx,CurrGroup2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_2_Up>nMkt_fx_2_Down,Mkt_fx_2_Up,Mkt_fx_2_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_2_Up,nMkt_fx_2_Down)","v":0}]
[null,"Marketfx,CurrGroup3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_3_Up>nMkt_fx_3_Down,Mkt_fx_3_Up,Mkt_fx_3_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_3_Up,nMkt_fx_3_Down)","v":0}]
[null,"Marketfx,CurrGroup4",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_4_Up>nMkt_fx_4_Down,Mkt_fx_4_Up,Mkt_fx_4_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_4_Up,nMkt_fx_4_Down)","v":0}]
[null,"Marketfx,CurrGroup5",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_5_Up>nMkt_fx_5_Down,Mkt_fx_5_Up,Mkt_fx_5_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_5_Up,nMkt_fx_5_Down)","v":0}]
[null,"Marketfx,CurrGroup6",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_6_Up>nMkt_fx_6_Down,Mkt_fx_6_Up,Mkt_fx_6_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_6_Up,nMkt_fx_6_Down)","v":0}]
[null,"Marketfx,CurrGroup7",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_7_Up>nMkt_fx_7_Down,Mkt_fx_7_Up,Mkt_fx_7_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_7_Up,nMkt_fx_7_Down)","v":0}]
[null,"Marketfx,CurrGroup8",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_8_Up>nMkt_fx_8_Down,Mkt_fx_8_Up,Mkt_fx_8_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_8_Up,nMkt_fx_8_Down)","v":0}]
[null,"Marketfx,CurrGroup9",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_9_Up>nMkt_fx_9_Down,Mkt_fx_9_Up,Mkt_fx_9_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_9_Up,nMkt_fx_9_Down)","v":0}]
[null,"Marketfx,CurrGroup10",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_10_Up>nMkt_fx_10_Down,Mkt_fx_10_Up,Mkt_fx_10_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_10_Up,nMkt_fx_10_Down)","v":0}]
[null,"Marketfx,CurrGroup11",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_11_Up>nMkt_fx_11_Down,Mkt_fx_11_Up,Mkt_fx_11_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_11_Up,nMkt_fx_11_Down)","v":0}]
[null,"Marketfx,CurrGroup12",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_12_Up>nMkt_fx_12_Down,Mkt_fx_12_Up,Mkt_fx_12_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_12_Up,nMkt_fx_12_Down)","v":0}]
[null,"Marketfx,CurrGroup13",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_13_Up>nMkt_fx_13_Down,Mkt_fx_13_Up,Mkt_fx_13_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_13_Up,nMkt_fx_13_Down)","v":0}]
[null,"Marketfx,CurrGroup14",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_14_Up>nMkt_fx_14_Down,Mkt_fx_14_Up,Mkt_fx_14_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_14_Up,nMkt_fx_14_Down)","v":0}]
[null,"Marketfx,CurrGroup15",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_15_Up>nMkt_fx_15_Down,Mkt_fx_15_Up,Mkt_fx_15_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_15_Up,nMkt_fx_15_Down)","v":0}]
[]
[null,"Marketfx",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N118:N132),CurrencyCorr),N118:N132))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P118:P132),CurrencyCorr),P118:P132))","v":0}]
[]
[null,"Currency Simplification"]
[]
[null,"Marketfx",null,{"$f":"'Raw Data'!$I$231","v":0},null,{"$f":"'Raw Data'!$I$232","v":0},null,{"$f":"'Raw Data'!$I$233","v":0},null,{"$f":"$D138-$F138-BE_Liabs_VDB","v":0},null,{"$f":"$D138-$F138-$H138","v":0},null,{"$f":"MAX(0,-($J138-$J$29))","v":0},null,{"$f":"MAX(0,-($L138-$L$29))","v":0}]
[]
[]
[null,"Spread Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketspbonds",null,{"$f":"'Raw Data'!$I$234","v":0},null,{"$f":"'Raw Data'!$I$235","v":0},null,{"$f":"'Raw Data'!$I$236","v":0},null,{"$f":"$D144-$F144-BE_Liabs_VDB","v":0},null,{"$f":"$D144-$F144-$H144","v":0},null,{"$f":"-($J144-$J$29)","v":0},null,{"$f":"-($L144-$L$29)","v":0}]
[]
[null,"Marketspsecuritisations",null,{"$f":"'Raw Data'!$I$237","v":0},null,{"$f":"'Raw Data'!$I$238","v":0},null,{"$f":"'Raw Data'!$I$239","v":0},null,{"$f":"$D146-$F146-BE_Liabs_VDB","v":0},null,{"$f":"$D146-$F146-$H146","v":0},null,{"$f":"-($J146-$J$29)","v":0},null,{"$f":"-($L146-$L$29)","v":0}]
[]
[null,"Marketspcdupward",null,{"$f":"'Raw Data'!$I$240","v":0},null,{"$f":"'Raw Data'!$I$241","v":0},null,{"$f":"'Raw Data'!$I$242","v":0},null,{"$f":"$D148-$F148-BE_Liabs_VDB","v":0},null,{"$f":"$D148-$F148-$H148","v":0},null,{"$f":"MAX(0,-($J148-$J$29))","v":0},null,{"$f":"MAX(0,-($L148-$L$29))","v":0}]
[null,"Marketspcddownward",null,{"$f":"'Raw Data'!$I$243","v":0},null,{"$f":"'Raw Data'!$I$244","v":0},null,{"$f":"'Raw Data'!$I$245","v":0},null,{"$f":"$D149-$F149-BE_Liabs_VDB","v":0},null,{"$f":"$D149-$F149-$H149","v":0},null,{"$f":"MAX(0,-($J149-$J$29))","v":0},null,{"$f":"MAX(0,-($L149-$L$29))","v":0}]
[]
[null,"Marketspcd",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_sp_cd_Up>nMkt_sp_cd_Down,Mkt_sp_cd_Up,Mkt_sp_cd_Down))","v":0},null,{"$f":"MAX(0,nMkt_sp_cd_Up,nMkt_sp_cd_Down)","v":0}]
[]
[null,"Marketspread",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Mkt_sp_Bonds,Mkt_sp_Sec,Mkt_sp_cd)","v":0},null,{"$f":"SUM(nMkt_sp_Bonds,nMkt_sp_Sec,nMkt_sp_cd)","v":0}]
[]
[]
[null,"Concentration Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketconc",null,{"$f":"'Raw Data'!$I$246","v":0},null,{"$f":"'Raw Data'!$I$247","v":0},null,{"$f":"'Raw Data'!$I$248","v":0},null,{"$f":"$D159-$F159-BE_Liabs_VDB","v":0},null,{"$f":"$D159-$F159-$H159","v":0},null,{"$f":"-($J159-$J$29)","v":0},null,{"$f":"-($L159-$L$29)","v":0}]

{"sheet":"Counterparty Default Risk","index":9,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Counterparty Default Risk"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Counterparty Default Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(D23:D24)","v":0},null,{"$f":"SUM(F23:F24)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"D26-F7","v":0},null,{"$f":"F26-H7","v":0}]
[]
[null,"SCRdefault",null,null,null,{"$f":"SUM(F7,F9)","v":0},null,{"$f":"SUM(H7,H9)","v":0}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"BE_Assets","v":0},null,{"$f":"BE_Liabs_VGB","v":0},null,{"$f":"BE_Liabs_VDB","v":0},null,{"$f":"$D17-$F17-$H17","v":0},null,{"$f":"$D17-$F17-$H17","v":0}]
[]
[]
[null,"Counterparty Default Risk",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCRdefault,1",null,0,null,0]
[null,"SCRdefault,2",null,0,null,0]
[]
[null,"SCRdefault",null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(D23:D24),DefaultCorr),D23:D24))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F23:F24),DefaultCorr),F23:F24))","v":0}]

{"sheet":"Life Underwriting Risk","index":10,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Life Underwriting Risk"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Life Underwriting Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifemortality",null,null,null,{"$f":"Life_Mort","v":0},null,{"$f":"nLife_Mort","v":0}]
[null,"Lifelongevity",null,null,null,{"$f":"Life_Long","v":0},null,{"$f":"nLife_Long","v":0}]
[null,"Lifedis+morb",null,null,null,{"$f":"Life_Dis_Morb","v":0},null,{"$f":"nLife_Dis_Morb","v":0}]
[null,"Lifelapse",null,null,null,{"$f":"Life_Lapse","v":0},null,{"$f":"nLife_Lapse","v":0}]
[null,"Lifeexpense",null,null,null,{"$f":"Life_Exp","v":0},null,{"$f":"nLife_Exp","v":0}]
[null,"Liferevision",null,null,null,{"$f":"Life_Rev","v":0},null,{"$f":"nLife_Rev","v":0}]
[null,"LifeCAT",null,null,null,{"$f":"Life_CAT","v":0},null,{"$f":"nLife_CAT","v":0}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(F7:F13)","v":0},null,{"$f":"SUM(H7:H13)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"F19-F15","v":0},null,{"$f":"H19-H15","v":0}]
[]
[null,"SCRlife",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F13),LifeCorr),F7:F13))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H13),LifeCorr),H7:H13))","v":0}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"BE_Assets","v":0},null,{"$f":"BE_Liabs_VGB","v":0},null,{"$f":"BE_Liabs_VDB","v":0},null,{"$f":"$D25-$F25-$H25","v":0},null,{"$f":"$D25-$F25-$H25","v":0}]
[]
[]
[null,"Mortality Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifemortality",null,{"$f":"'Raw Data'!$I$250","v":0},null,{"$f":"'Raw Data'!$I$251","v":0},null,{"$f":"'Raw Data'!$I$252","v":0},null,{"$f":"$D31-$F31-BE_Liabs_VDB","v":0},null,{"$f":"$D31-$F31-$H31","v":0},null,{"$f":"-($J31-$J$25)","v":0},null,{"$f":"-($L31-$L$25)","v":0}]
[]
[]
[null,"Longevity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifelongevity",null,{"$f":"'Raw Data'!$I$253","v":0},null,{"$f":"'Raw Data'!$I$254","v":0},null,{"$f":"'Raw Data'!$I$255","v":0},null,{"$f":"$D37-$F37-BE_Liabs_VDB","v":0},null,{"$f":"$D37-$F37-$H37","v":0},null,{"$f":"-($J37-$J$25)","v":0},null,{"$f":"-($L37-$L$25)","v":0}]
[]
[]
[null,"Disability & Morbidity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifedisability",null,{"$f":"'Raw Data'!$I$256","v":0},null,{"$f":"'Raw Data'!$I$257","v":0},null,{"$f":"'Raw Data'!$I$258","v":0},null,{"$f":"$D43-$F43-BE_Liabs_VDB","v":0},null,{"$f":"$D43-$F43-$H43","v":0},null,{"$f":"MAX(0,-($J43-$J$25))","v":0},null,{"$f":"MAX(0,-($L43-$L$25))","v":0}]
[]
[null,"Lifemorbidity",null,{"$f":"'Raw Data'!$I$259","v":0},null,{"$f":"'Raw Data'!$I$260","v":0},null,{"$f":"'Raw Data'!$I$261","v":0},null,{"$f":"$D45-$F45-BE_Liabs_VDB","v":0},null,{"$f":"$D45-$F45-$H45","v":0},null,{"$f":"MAX(0,-($J45-$J$25))","v":0},null,{"$f":"MAX(0,-($L45-$L$25))","v":0}]
[]
[null,"Lifedis+morb",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Life_Dis,Life_Morb)","v":0},null,{"$f":"SUM(nLife_Dis,nLife_Morb)","v":0}]
[]
[]
[null,"Lapse Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lapsedown",null,{"$f":"'Raw Data'!$I$262","v":0},null,{"$f":"'Raw Data'!$I$263","v":0},null,{"$f":"'Raw Data'!$I$264","v":0},null,{"$f":"$D53-$F53-BE_Liabs_VDB","v":0},null,{"$f":"$D53-$F53-$H53","v":0},null,{"$f":"-($J53-$J$25)","v":0},null,{"$f":"-($L53-$L$25)","v":0}]
[null,"Lapseup",null,{"$f":"'Raw Data'!$I$265","v":0},null,{"$f":"'Raw Data'!$I$266","v":0},null,{"$f":"'Raw Data'!$I$267","v":0},null,{"$f":"$D54-$F54-BE_Liabs_VDB","v":0},null,{"$f":"$D54-$F54-$H54","v":0},null,{"$f":"-($J54-$J$25)","v":0},null,{"$f":"-($L54-$L$25)","v":0}]
[null,"Lapsemass",null,{"$f":"'Raw Data'!$I$268","v":0},null,{"$f":"'Raw Data'!$I$269","v":0},null,{"$f":"'Raw Data'!$I$270","v":0},null,{"$f":"$D55-$F55-BE_Liabs_VDB","v":0},null,{"$f":"$D55-$F55-$H55","v":0},null,{"$f":"-($J55-$J$25)","v":0},null,{"$f":"-($L55-$L$25)","v":0}]
[]
[null,"Lifelapse",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MAX(0,P53:P55)=n_Lapse_Down,Lapse_Down,IF(MAX(0,P53:P55)=nLapse_Up,Lapse_Up,IF(MAX(0,P53:P55)=nLapse_Mass,Lapse_Mass,0)))","v":0},null,{"$f":"MAX(0,n_Lapse_Down,nLapse_Up,nLapse_Mass)","v":0}]
[]
[]
[null,"Expense Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifeexpense",null,{"$f":"'Raw Data'!$I$271","v":0},null,{"$f":"'Raw Data'!$I$272","v":0},null,{"$f":"'Raw Data'!$I$273","v":0},null,{"$f":"$D63-$F63-BE_Liabs_VDB","v":0},null,{"$f":"$D63-$F63-$H63","v":0},null,{"$f":"-($J63-$J$25)","v":0},null,{"$f":"-($L63-$L$25)","v":0}]
[]
[]
[null,"Revision Risk                        ",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Liferevision",null,{"$f":"'Raw Data'!$I$274","v":0},null,{"$f":"'Raw Data'!$I$275","v":0},null,{"$f":"'Raw Data'!$I$276","v":0},null,{"$f":"$D69-$F69-BE_Liabs_VDB","v":0},null,{"$f":"$D69-$F69-$H69","v":0},null,{"$f":"-($J69-$J$25)","v":0},null,{"$f":"-($L69-$L$25)","v":0}]
[]
[]
[null,"Life Catastrophe Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"LifeCAT",null,{"$f":"'Raw Data'!$I$277","v":0},null,{"$f":"'Raw Data'!$I$278","v":0},null,{"$f":"'Raw Data'!$I$279","v":0},null,{"$f":"$D75-$F75-BE_Liabs_VDB","v":0},null,{"$f":"$D75-$F75-$H75","v":0},null,{"$f":"MAX(0,-($J75-$J$25))","v":0},null,{"$f":"MAX(0,-($L75-$L$25))","v":0}]

{"sheet":"Health Underwriting Risk","index":11,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Health Underwriting Risk"}]
[{"$f":"Insurer_Name & \" (\" & Insurer_Shortname & \")\"","v":" ()"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[null,"Health Underwriting Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthmortality",null,null,null,{"$f":"Health_Mort","v":0},null,{"$f":"nHealth_Mort","v":0}]
[null,"Healthlongevity",null,null,null,{"$f":"Health_Long","v":0},null,{"$f":"nHealth_Long","v":0}]
[null,"Healthdis+morb",null,null,null,{"$f":"Health_Dis_Morb","v":0},null,{"$f":"nHealth_Dis_Morb","v":0}]
[null,"Healthlapse",null,null,null,{"$f":"Health_Lapse","v":0},null,{"$f":"nHealth_Lapse","v":0}]
[null,"Healthexpense",null,null,null,{"$f":"Health_Exp","v":0},null,{"$f":"nHealth_Exp","v":0}]
[null,"Healthrevision",null,null,null,{"$f":"Health_Rev","v":0},null,{"$f":"nHealth_Rev","v":0}]
[]
[null,"HealthSLT",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F12),HealthCorr_SLT),F7:F12))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H12),HealthCorr_SLT),H7:H12))","v":0}]
[null,"HealthCAT",null,null,null,{"$f":"'Raw Data'!I311","v":0},null,{"$f":"'Raw Data'!I312","v":0}]
[null,"HealthNSLT",null,null,null,{"$f":"'Raw Data'!I313","v":0},null,{"$f":"'Raw Data'!I314","v":0}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(F14:F16)","v":0},null,{"$f":"SUM(H14:H16)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"F22-F18","v":0},null,{"$f":"H22-H18","v":0}]
[]
[null,"SCRHealth",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F14:F16),HealthCorr),F14:F16))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H14:H16),HealthCorr),H14:H16))","v":0}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"BE_Assets","v":0},null,{"$f":"BE_Liabs_VGB","v":0},null,{"$f":"BE_Liabs_VDB","v":0},null,{"$f":"$D28-$F28-$H28","v":0},null,{"$f":"$D28-$F28-$H28","v":0}]
[]
[]
[null,"Mortality Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthmortality",null,{"$f":"'Raw Data'!$I$281","v":0},null,{"$f":"'Raw Data'!$I$282","v":0},null,{"$f":"'Raw Data'!$I$283","v":0},null,{"$f":"$D34-$F34-BE_Liabs_VDB","v":0},null,{"$f":"$D34-$F34-$H34","v":0},null,{"$f":"-($J34-$J$28)","v":0},null,{"$f":"-($L34-$L$28)","v":0}]
[]
[]
[null,"Longevity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthlongevity",null,{"$f":"'Raw Data'!$I$284","v":0},null,{"$f":"'Raw Data'!$I$285","v":0},null,{"$f":"'Raw Data'!$I$286","v":0},null,{"$f":"$D40-$F40-BE_Liabs_VDB","v":0},null,{"$f":"$D40-$F40-$H40","v":0},null,{"$f":"-($J40-$J$28)","v":0},null,{"$f":"-($L40-$L$28)","v":0}]
[]
[]
[null,"Disability & Morbidity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthmedical_up",null,{"$f":"'Raw Data'!I287","v":0},null,{"$f":"'Raw Data'!I288","v":0},null,{"$f":"'Raw Data'!I289","v":0},null,{"$f":"$D46-$F46-BE_Liabs_VDB","v":0},null,{"$f":"$D46-$F46-$H46","v":0},null,{"$f":"MAX(0,-($J46-$J$28))","v":0},null,{"$f":"MAX(0,-($L46-$L$28))","v":0}]
[null,"Healthmedical_down",null,{"$f":"'Raw Data'!I290","v":0},null,{"$f":"'Raw Data'!I291","v":0},null,{"$f":"'Raw Data'!I292","v":0},null,{"$f":"$D47-$F47-BE_Liabs_VDB","v":0},null,0,null,0,null,0]
[]
[null,"Healthmedical",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nHealth_medical_up>nHealth_medical_down,Health_medical_up,IF(nHealth_medical_down>Health_medical_up,Health_medical_down,MAX(Health_medical_down,Health_medical_up)))","v":0},null,{"$f":"MAX(0,nHealth_medical_up,nHealth_medical_down)","v":0}]
[]
[null,"Healthincome",null,{"$f":"'Raw Data'!$I$293","v":0},null,{"$f":"'Raw Data'!$I$294","v":0},null,{"$f":"'Raw Data'!$I$295","v":0},null,{"$f":"$D51-$F51-BE_Liabs_VDB","v":0},null,{"$f":"$D51-$F51-$H51","v":0},null,{"$f":"MAX(0,-($J51-$J$28))","v":0},null,{"$f":"MAX(0,-($L51-$L$28))","v":0}]
[]
[null,"Healthdis+morb",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Health_medical,Health_income)","v":0},null,{"$f":"SUM(nHealth_medical,nHealth_income)","v":0}]
[]
[]
[null,"Lapse Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"HLapsedown",null,{"$f":"'Raw Data'!$I$296","v":0},null,{"$f":"'Raw Data'!$I$297","v":0},null,{"$f":"'Raw Data'!$I$298","v":0},null,{"$f":"$D59-$F59-BE_Liabs_VDB","v":0},null,{"$f":"$D59-$F59-$H59","v":0},null,{"$f":"-($J59-$J$28)","v":0},null,{"$f":"-($L59-$L$28)","v":0}]
[null,"HLapseup",null,{"$f":"'Raw Data'!$I$299","v":0},null,{"$f":"'Raw Data'!$I$300","v":0},null,{"$f":"'Raw Data'!$I$301","v":0},null,{"$f":"$D60-$F60-BE_Liabs_VDB","v":0},null,{"$f":"$D60-$F60-$H60","v":0},null,{"$f":"-($J60-$J$28)","v":0},null,{"$f":"-($L60-$L$28)","v":0}]
[null,"HLapsemass",null,{"$f":"'Raw Data'!$I$302","v":0},null,{"$f":"'Raw Data'!$I$303","v":0},null,{"$f":"'Raw Data'!$I$304","v":0},null,{"$f":"$D61-$F61-BE_Liabs_VDB","v":0},null,{"$f":"$D61-$F61-$H61","v":0},null,{"$f":"-($J61-$J$28)","v":0},null,{"$f":"-($L61-$L$28)","v":0}]
[]
[null,"Healthlapse",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MAX(0,P59:P61)=n_HLapse_Down,HLapse_Down,IF(MAX(0,P59:P61)=nHLapse_Up,HLapse_Up,IF(MAX(0,P59:P61)=nHLapse_Mass,HLapse_Mass,0)))","v":0},null,{"$f":"MAX(0,n_HLapse_Down,nHLapse_Up,nHLapse_Mass)","v":0}]
[]
[]
[null,"Expense Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthexpense",null,{"$f":"'Raw Data'!$I$305","v":0},null,{"$f":"'Raw Data'!$I$306","v":0},null,{"$f":"'Raw Data'!$I$307","v":0},null,{"$f":"$D69-$F69-BE_Liabs_VDB","v":0},null,{"$f":"$D69-$F69-$H69","v":0},null,{"$f":"-($J69-$J$28)","v":0},null,{"$f":"-($L69-$L$28)","v":0}]
[]
[]
[null,"Revision Risk                         ",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthrevision",null,{"$f":"'Raw Data'!$I$308","v":0},null,{"$f":"'Raw Data'!$I$309","v":0},null,{"$f":"'Raw Data'!$I$310","v":0},null,{"$f":"$D75-$F75-BE_Liabs_VDB","v":0},null,{"$f":"$D75-$F75-$H75","v":0},null,{"$f":"-($J75-$J$28)","v":0},null,{"$f":"-($L75-$L$28)","v":0}]

{"sheet":"Data","index":12,"n_rows":161,"n_cols":17,"rows_kept":161,"cut":false,"hidden":false,"merged":[[94,1,94,2],[95,1,95,2],[96,1,96,2]]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Data"}]
[]
[]
[null,"Currency","Currency Code"]
[null,"United Kingdom Pound","GBP"]
[null,"United States Dollar","USD"]
[null,"Euro","EUR"]
[null,"Sweden Krona","SEK"]
[null,"Afghanistan Afghani","AFN"]
[null,"Albania Lek","ALL"]
[null,"Algeria Dinar","DZD"]
[null,"Argentina Peso","ARS"]
[null,"Australia Dollar","AUD"]
[null,"Bahamas Dollar","BSD"]
[null,"Bahrain Dinar","BHD"]
[null,"Bangladesh Taka","BDT"]
[null,"Barbados Dollar","BBD"]
[null,"Bermuda Dollar","BMD"]
[null,"Brazil Real","BRL"]
[null,"Bulgaria Lev","BGN"]
[null,"Canada Dollar","CAD"]
[null,"Chile Peso","CLP"]
[null,"China Yuan Renminbi","CNY"]
[null,"Colombia Peso","COP"]
[null,"Costa Rica Colon","CRC"]
[null,"Croatia Kuna","HRK"]
[null,"Czech Republic Koruna","CZK"]
[null,"Denmark Krone","DKK"]
[null,"Dominican Republic Peso","DOP"]
[null,"Egypt Pound","EGP"]
[null,"Fiji Dollar","FJD"]
[null,"Hong Kong Dollar","HKD"]
[null,"Hungary Forint","HUF"]
[null,"Iceland Krona","ISK"]
[null,"India Rupee","INR"]
[null,"Indonesia Rupiah","IDR"]
[null,"Iran Rial","IRR"]
[null,"Iraq Dinar","IQD"]
[null,"Israel Shekel","ILS"]
[null,"Jamaica Dollar","JMD"]
[null,"Japan Yen","JPY"]
[null,"Jordan Dinar","JOD"]
[null,"Kenya Shilling","KES"]
[null,"Kuwait Dinar","KWD"]
[null,"Lebanon Pounds","LBP"]
[null,"Lituania Lita","LTL"]
[null,"Malaysia Ringgit","MYR"]
[null,"Mauritius Rupee","MUR"]
[null,"Mexico Peso","MXN"]
[null,"Morocco Dirham","MAD"]
[null,"New Zealand Dollar","NZD"]
[null,"Norway Krone","NOK"]
[null,"Oman Rial","OMR"]
[null,"Pakistan Rupee","PKR"]
[null,"Peru Nuevo Sol","PEN"]
[null,"Philippines Peso","PHP"]
[null,"Poland Zloty","PLN"]
[null,"Qatar Riyal","QAR"]
[null,"Romania New Leu","RON"]
[null,"Russia Ruble","RUB"]
[null,"Saudi Arabia Riyal","SAR"]
[null,"Singapore Dollar","SGD"]
[null,"South Africa Rand","ZAR"]
[null,"South Korea Won","KRW"]
[null,"Sri Lanka Rupee","LKR"]
[null,"Sudan Pound","SDG"]
[null,"Switzerland Franc","CHF"]
[null,"Taiwan New Dollar","TWD"]
[null,"Thailand Baht","THB"]
[null,"Trinidad and Tobago Dollar","TTD"]
[null,"Tunisia Dinar","TND"]
[null,"Turkey Lira","TRY"]
[null,"United Arab Emirates Dirham","AED"]
[null,"Venezuela Bolivares Fuertes","VEF"]
[null,"Vietnam Dong","VND"]
[null,"Zambia Kwacha","ZMK"]
[]
[]
[]
[null,"Corr                                    * ","Market","Default","Life","Health"]
[null,"Market",1,{"$f":"TRANSPOSE(C82:C84)","v":0.25},0.25,0.25]
[null,"Default",0.25,1,{"$f":"TRANSPOSE(D83:D$84)","v":0.25},0.25]
[null,"Life",0.25,0.25,1,{"$f":"TRANSPOSE(E84:$E$84)","v":0.25}]
[null,"Health",0.25,0.25,0.25,1]
[]
[]
[null,"MarketCorr                       * ","Interest","Equity","Property","Currency","Spread","Concentration"]
[null,"Interest",1,{"$f":"TRANSPOSE(C89:C$93)","v":0},0,0.25,0,0]
[null,"Equity",{"$f":"A","v":0},1,{"$f":"TRANSPOSE(D90:D$93)","v":0.75},0.25,0.75,0]
[null,"Property",{"$f":"A","v":0},0.75,1,{"$f":"TRANSPOSE(E91:E$93)","v":0.25},0.5,0]
[null,"Currency",0.25,0.25,0.25,1,{"$f":"TRANSPOSE(F92:F$93)","v":0.25},0]
[null,"Spread",{"$f":"A","v":0},0.75,0.5,0.25,1,{"$f":"TRANSPOSE(G93:G$93)","v":0}]
[null,"Concentration",0,0,0,0,0,1]
[]
[null,"Selection of A in MarketCorr             *   ",null,"A"]
[null,"Marketinterest = MarketinterestUp",null,0]
[null,"Marketinterest = MarketinterestDown",null,0.5]
[null,null,"Selected:",{"$f":"IF(nMkt_Int=nMkt_Int_Up,$D$96,$D$97)","v":0}]
[]
[]
[null,"EqVolUpCorr                      *","VolatilityUp","Level"]
[null,"VolatilityUp",1,{"$f":"$C$103","v":0.75}]
[null,"Level",0.75,1]
[]
[]
[null,"EqVolDownCorr                *","Level","VolatilityDown"]
[null,"Level",1,{"$f":"$C$108","v":0}]
[null,"VolatilityDown",0,1]
[]
[]
[null,"EqCorr                                *","Type 1","Type 2"]
[null,"Type 1",1,{"$f":"$C$113","v":0.75}]
[null,"Type 2",0.75,1]
[]
[]
[null,"CurrencyCorr                    *",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"CurrGroup1",1,{"$f":"TRANSPOSE(C118:C$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup2",0.5,1,{"$f":"TRANSPOSE(D119:D$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup3",0.5,0.5,1,{"$f":"TRANSPOSE(E120:E$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup4",0.5,0.5,0.5,1,{"$f":"TRANSPOSE(F121:F$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup5",0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(G122:G$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup6",0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(H123:H$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup7",0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(I124:I$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup8",0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(J125:J$131)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup9",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(K126:K$131)","v":0.5},0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup10",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(L127:L$131)","v":0.5},0.5,0.5,0.5,0.5]
[null,"CurrGroup11",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(M128:M$131)","v":0.5},0.5,0.5,0.5]
[null,"CurrGroup12",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(N129:N$131)","v":0.5},0.5,0.5]
[null,"CurrGroup13",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(O130:O$131)","v":0.5},0.5]
[null,"CurrGroup14",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(P131:P$131)","v":0.5}]
[null,"CurrGroup15",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1]
[]
[]
[null,"DefaultCorr                       *","Type 1","Type 2"]
[null,"Type 1",1,{"$f":"$C$136","v":0.75}]
[null,"Type 2",0.75,1]
[]
[]
[null,"LifeCorr                              *","Mortality","Longevity","Disability","Lapse","Expenses","Revision","CAT"]
[null,"Mortality",1,{"$f":"TRANSPOSE(C141:C$146)","v":-0.25},0.25,0,0.25,0,0.25]
[null,"Longevity",-0.25,1,{"$f":"TRANSPOSE(D142:D$146)","v":0},0.25,0.25,0.25,0]
[null,"Disability",0.25,0,1,{"$f":"TRANSPOSE(E143:E$146)","v":0},0.5,0,0.25]
[null,"Lapse",0,0.25,0,1,{"$f":"TRANSPOSE(F144:F$146)","v":0.5},0,0.25]
[null,"Expenses",0.25,0.25,0.5,0.5,1,{"$f":"TRANSPOSE(G145:G$146)","v":0.5},0.25]
[null,"Revision",0,0.25,0,0,0.5,1,{"$f":"TRANSPOSE(H146:H$146)","v":0}]
[null,"CAT",0.25,0,0.25,0.25,0.25,0,1]
[]
[]
[null,"HealthCorr                         ","Mortality","Longevity","Disability","Lapse","Expenses","Revision"]
[null,"Mortality",1,{"$f":"TRANSPOSE($C$151:$C$155)","v":-0.25},0.25,0,0.25,0]
[null,"Longevity",-0.25,1,{"$f":"TRANSPOSE($D$152:$D$155)","v":0},0.25,0.25,0.25]
[null,"Disability",0.25,0,1,{"$f":"TRANSPOSE($E$153:$E$155)","v":0},0.5,0]
[null,"Lapse",0,0.25,0,1,{"$f":"TRANSPOSE($F$154:$F$155)","v":0.5},0]
[null,"Expenses",0.25,0.25,0.5,0.5,1,{"$f":"TRANSPOSE(G155:G155)","v":0.5}]
[null,"Revision",0,0.25,0,0,0.5,1]
[]
[]
[null,"HealthCorr                        ","HealthSLT","HealthNSLT","HealthCAT"]
[null,"HealthSLT",1,{"$f":"TRANSPOSE(C160:C161)","v":0.5},0.25]
[null,"HealthNSLT",0.5,1,{"$f":"TRANSPOSE(D161)","v":0.25}]
[null,"HealthCAT",0.25,0.25,1]

{"sheet":"Raw Data","index":13,"n_rows":314,"n_cols":9,"rows_kept":314,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\",$A$1),LEN(CELL(\"filename\",$A$1))-FIND(\"]\",CELL(\"filename\",$A$1)))","v":"Raw Data"}]
[]
[]
[null,"Sheet","Result",1,2,3,4,5,"Total"]
[]
[null,"Operational Risk Sheet","Current valuation date - Total  expenses for UL business",null,null,null,null,null,{"$f":"SUM(D6:H6)","v":0}]
[null,"Operational Risk Sheet","Current valuation date - Earned premiums ",null,null,null,null,null,{"$f":"SUM(D7:H7)","v":0}]
[null,"Operational Risk Sheet","Previous valuation date - Earned premiums ",null,null,null,null,null,0]
[null,"Operational Risk Sheet","Technical Provisions",null,null,null,null,null,0]
[]
[null,"Economic Balance Sheet","Goodwill - Acc.",null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"Economic Balance Sheet","Other Intangible assets - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other Intangible assets - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (own use) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (own use) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (not own use) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (not own use) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Participations - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Participations - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Listed equities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Listed equities - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Unlisted equities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Unlisted equities - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Govt. & multilaterals - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Govt. & multilaterals - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (ABS) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (ABS) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (other) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (other) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Structured Notes - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Structured Notes - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Investment funds - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Investment funds - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Futures - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Futures - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Call Options - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Call Options - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Put Options - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Put Options - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Swaps - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Swaps - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Forwards - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Forwards - Reg.",null,null,null,null,null,{"$f":"SUM(D43:H43)","v":0}]
[null,"Economic Balance Sheet","Long term bank deposits - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Long term bank deposits - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other investments - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other investments - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Assets held for UL funds - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Assets held for UL funds - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits to cedants - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits to cedants - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Uncollateralised loans made - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Uncollateralised loans made - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Collateralised loans made - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Collateralised loans made - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Loans on policies - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Loans on policies - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Reins. recoverables - Life excl. UL - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Reins. recoverables - Life excl. UL - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other reinsurance recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other reinsurance recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","SPV recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","SPV recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Intermediaries recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Intermediaries recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Deferred acquisition costs - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Receivables (trade) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Receivables (trade) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pension benefit surplus - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pension benefit surplus - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash - Acc.",null,null,null,null,null,{"$f":"SUM(D75:H75)","v":0}]
[null,"Economic Balance Sheet","Cash - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Short term bank deposits - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Short term bank deposits - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Called but unpaid capital - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Called but unpaid capital - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other assets - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other assets - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - Whole TP - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - BEP VGB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - BEP VDB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - RM - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - Whole TP - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - BEP VGB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - BEP VDB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - RM - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits from reinsurers - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits from reinsurers - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance accounts payable - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance accounts payable - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Derivatives - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Derivatives - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Provisions other than TPs  - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Provisions other than TPs  - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Owed to credit institutions - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Owed to credit institutions - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Financial liabs - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Financial liabs - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Payables (trade, not insurance) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Payables (trade, not insurance) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pensions benefit obligations - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pensions benefit obligations - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Uncalled investments - Acc.",null,null,null,null,null,{"$f":"SUM(D107:H107)","v":0}]
[null,"Economic Balance Sheet","Uncalled investments - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Contingent liabilities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Contingent liabilities - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Any other liabilities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Any other liabilities - Reg.",null,null,null,null,null,0]
[]
[null,"Market Risk","Interest Rate Risk - Up - Assets",null,null,null,null,null,{"$f":"SUM(D114:H114)","v":0}]
[null,"Market Risk","Interest Rate Risk - Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Down - Assets",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolUp - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolUp - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolUp - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - Level - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - Level - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - Level - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolDown - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolDown - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolDown - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolUp - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolUp - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolUp - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - Level - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - Level - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - Level - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolDown - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolDown - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolDown - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Property Risk - Assets",null,null,null,null,null,0]
[null,"Market Risk","Property Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Property Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 1 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 1 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 1 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 1 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 1 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 1 - Liabilities - VDB",null,null,null,null,null,{"$f":"SUM(D146:H146)","v":0}]
[null,"Market Risk","Currency Risk - Up - Group 2 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 2 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 2 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 2 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 2 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 2 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 3 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 3 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 3 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 3 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 3 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 3 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 4 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 4 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 4 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 4 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 4 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 4 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 5 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 5 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 5 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 5 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 5 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 5 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 6 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 6 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 6 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 6 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 6 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 6 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 7 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 7 - Liabilities - VGB",null,null,null,null,null,{"$f":"SUM(D178:H178)","v":0}]
[null,"Market Risk","Currency Risk - Up - Group 7 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 7 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 7 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 7 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 8 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 8 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 8 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 8 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 8 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 8 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 9 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 9 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 9 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 9 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 9 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 9 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 10 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 10 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 10 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 10 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 10 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 10 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 11 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 11 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 11 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 11 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 11 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 11 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 12 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 12 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 12 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 12 - Assets",null,null,null,null,null,{"$f":"SUM(D210:H210)","v":0}]
[null,"Market Risk","Currency Risk - Down - Group 12 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 12 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 13 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 13 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 13 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 13 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 13 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 13 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 14 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 14 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 14 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 14 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 14 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 14 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 15 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 15 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 15 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 15 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 15 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 15 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Simplification - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Simplification - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Simplification - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Bonds - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Bonds - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Bonds - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Securitisations - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Securitisations - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Securitisations - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Up - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Up - Liabilities - VDB",null,null,null,null,null,{"$f":"SUM(D242:H242)","v":0}]
[null,"Market Risk","Spread Risk - Credit Derivatives - Down - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Concentration Risk - Assets",null,null,null,null,null,0]
[null,"Market Risk","Concentration Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Concentration Risk - Liabilities - VDB",null,null,null,null,null,0]
[]
[null,"Life Underwriting Risk","Mortality Risk - Assets",null,null,null,null,null,{"$f":"SUM(D250:H250)","v":0}]
[null,"Life Underwriting Risk","Mortality Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mortality Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Longevity Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Longevity Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Longevity Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Disability Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Disability Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Disability Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Morbidity Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Morbidity Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Morbidity Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Down - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Up - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mass Lapse Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mass Lapse Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mass Lapse Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Expense Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Expense Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Expense Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Revision Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Revision Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Revision Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Catastrophe Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Catastrophe Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Catastrophe Risk - Liabilities - VDB",null,null,null,null,null,0]
[]
[null,"Health Underwriting Risk","Mortality Risk - Assets",null,null,null,null,null,{"$f":"SUM(D281:H281)","v":0}]
[null,"Health Underwriting Risk","Mortality Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mortality Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Longevity Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Longevity Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Longevity Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Up - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Down - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Income Protection Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Income Protection Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Income Protection Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Down - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Up - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mass Lapse Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mass Lapse Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mass Lapse Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Expense Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Expense Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Expense Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Revision Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Revision Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Revision Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health Catastrophe Risk - Capital",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health Catastrophe Risk - nCapital",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health NSLT Risk - Capital",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health NSLT Risk - nCapital",null,null,null,null,null,0]