{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Front Sheet","Instructions","Inputs","Analysis of Change","Risk vs exp Calc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Front Sheet","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,2,11,2],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4]]}
[]
[null,"syndicate scr for 2016 yoa  – Analysis of Change"]
[null," Agent Name"]
[null," Syndicate Number"]
[null," Completed By / Contact Name"]
[null," Contact Telephone Number"]
[null," Date of Completion"]
[]
[]
[null,null,"Links to worksheets:",null,"Inputs"]
[null,null,null,null,"Instructions"]
[null,null,null,null,"Analysis of Change"]

{"sheet":"Instructions","index":1,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,11,41,11],[1,2,1,12]]}
[]
[null,null,{"$f":"AgentName&\" - s\"&TEXT(Synd,\"0000\")","v":" - s0000"}]
[]
[null,null,"Step 1: Create a folder on your network or hard drive for the csv downloads of the LCR. Use this folder for all downloads.  "]
[null,null,"Step 2: Save 2016_SCR_Analysis of Change_SYND.xlsm (this workbook) in the folder. Replace \"SYND\" with the number of your syndicate (including any leading zeros)."]
[null,null,"Step 3: Complete the \"Front Sheet\" for your syndicate."]
[null,null,"Step 4: Open Core market Returns (\"CMR\")."]
[null,null,"Step 5: Go to the LCR homepage."]
[null,null,"Step 6. Go to Step 7 for the July (draft) submission OR Step 8 for September and subsequent submissions."]
[]
[null,null,"Step 7. Download the files for the Analysis of Change (\"AOC\") for the July submission. "]
[null,null,null,"a. Download the csv file for the July submission for the prospective YOA "]
[null,null,null,null,"i. Go to the Controls page"]
[null,null,null,null,"ii. Click \"Extract\""]
[null,null,null,null,"iii. Click \"Select All\""]
[null,null,null,null,"iv. Uncheck the \"Exclude base elements with '_LCALC' and '_LTOTAL' \" box"]
[null,null,null,null,"v. Click \"Generate csv\""]
[null,null,null,null,"vi. Save the csv file in the folder you created in Step 1"]
[null,null,null,null,"vii. Enter the information of the csv download in the \"Inputs\" sheet in the row for File 1. The file name must include the .csv extension."]
[null,null,null,"b. Download the csv file for the final submission for the current YOA "]
[null,null,null,null,"i. Go to \"Archives\""]
[null,null,null,null,"ii. Click on \"CSV\" for the latest submission for the current YOA (from March of the current year if submitted; otherwise the final submission made last year)"]
[null,null,null,null,"iii. Save the csv file in the folder you created in Step 1"]
[null,null,null,null,"iv. Enter the information of the csv download file in the \"Inputs\" sheet in the row for File 2. The file name must include the .csv extension."]
[null,null,"Step 8. Download the files for the AOC for the September or subsequent submissions. "]
[null,null,null,"a. Repeat Step 7.a for the latest submission for the prospective YOA (from September, or later if a re-submission is being made) "]
[null,null,null,"b. Repeat Step 7.a i-vi. For step vii, enter the information in the row for File 2"]
[null,null,null,"c. Repeat Step 7.b i-iii. For step iv, enter the information in the row for File 3"]
[]
[null,null,"Step 9: In 2016_SCR_Analysis of Change_SYND.xlsm, select the Excel options \"Enable content\" and \"Enable Macros\". "]
[null,null,"Step 10:  Populate the Analysis of Change exhibit."]
[null,null,null,"i. Go to the \"Analysis of Change\" sheet"]
[null,null,null,"ii. Click on the \"Calculate Analysis of Change\" button in column O"]
[null,null,null,"iii. Click on the \"Delete\" button in column O, if you want to clear the AOC exhibit"]
[null,null,"Step 11: Identify significant movements in column L. "]
[null,null,null,{"$f":"\"i. Movements relating to changes in the mean or 1:200 vs. exposure exceeding \"&ROUND('Analysis of Change'!AB15*100,2)& \"%, and/or counter-directional movements in the mean and 1:200 are flagged automatically\"","v":"i. Movements relating to changes in the mean or 1:200 vs. exposure exceeding 5%, and/or counter-directional movements in the mean and 1:200 are flagged automatically"}]
[null,null,null,"ii. Identify any other movements which you consider significant"]
[null,null,"Step 12: Comment on the significant movements identified in Step 11 in column L. You may also use column L to refer to more detailed explanations in your SCR methodology and assumptions document."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Links to worksheets:","Front Sheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Analysis of Change"]

{"sheet":"Inputs","index":2,"n_rows":19,"n_cols":69,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,8,18,8],[1,2,1,9]]}
[]
[null,null,{"$f":"AgentName&\" - s\"&TEXT(Synd,\"0000\")","v":" - s0000"}]
[]
[null,null,null,"See the \"Instructions\" sheet for details on how to complete the table."]
[null,null,null,null,null,"LCR Submission"]
[null,null,null,"File","SCR YOA","Month","Year","Edition","File Name"]
[null,null,null,1,2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,"January",null,2013]
[null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,"February",null,2014]
[null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March",null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October"]
[null,null,null,null,null,null,null,null,"Links to worksheets:","Front Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November"]
[null,null,null,null,null,null,null,null,null,"Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[null,null,null,null,null,null,null,null,null,"Analysis of Change"]

{"sheet":"Analysis of Change","index":3,"n_rows":101,"n_cols":29,"rows_kept":101,"cut":false,"hidden":false,"merged":[[63,2,63,8],[0,1,0,11],[2,5,2,6],[2,7,2,8],[4,2,4,8],[15,2,15,8]]}
[null,{"$f":"AgentName&\" s\"&TEXT(Synd,\"0000\")&\": LCR Analysis of Change 2016 YOA\"","v":" s0000: LCR Analysis of Change 2016 YOA"}]
[null,null,null,null,null,null,null,null,null,"(All figures are in £m)"]
[null,null,{"$f":"CONCATENATE(Inputs!$G$7,\" \",,LEFT(Inputs!$F$7,3))","v":" "},{"$f":"CONCATENATE(Inputs!$G$8,\" \",,LEFT(Inputs!$F$8,3))","v":" "},{"$f":"CONCATENATE(Inputs!$G$9,\" \",,LEFT(Inputs!$F$9,3))","v":" "},{"$f":"C3&\" vs. \"&D3","v":"  vs.  "},null,{"$f":"D3&\" vs. \"&E3","v":"  vs.  "},null,{"$f":"\"Significant movements between \"&D3&\" and \"&C3","v":"Significant movements between   and  "},{"$f":"\"Significant movements between \"&E3&\" and \"&D3","v":"Significant movements between   and  "},"Comments"]
[null,"LCR edition",{"$f":"Inputs!$H$7","v":0},{"$f":"Inputs!$H$8","v":0},{"$f":"Inputs!$H$9","v":0},"£ change","% change","£ change","% change"]
[null,null,"A. EXPOSURE & RISK MARGIN"]
[null,"Exposure and Risk Margin"]
[null,"Premium 1  [Note 1]",{"$f":"'Risk vs exp Calc'!C632","v":""},{"$f":"'Risk vs exp Calc'!D632","v":""},{"$f":"'Risk vs exp Calc'!E632","v":""},{"$f":"IFERROR(C7-D7,\"\")","v":""},{"$f":"IFERROR((C7-D7)/D7,\"\")","v":""},{"$f":"IFERROR(D7-E7,\"\")","v":""},{"$f":"IFERROR((D7-E7)/E7,\"\")","v":""}]
[null,"Premium 2  [Note 2]",{"$f":"IFERROR('Risk vs exp Calc'!C632+IF(Inputs!$E$7=2016,('Risk vs exp Calc'!C582-'Risk vs exp Calc'!C583),('Risk vs exp Calc'!C565-'Risk vs exp Calc'!C566)),\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!D632+IF(Inputs!$E$8=2016,('Risk vs exp Calc'!D582-'Risk vs exp Calc'!D583),('Risk vs exp Calc'!D565-'Risk vs exp Calc'!D566)),\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!E632+IF(Inputs!$E$9=2016,('Risk vs exp Calc'!E582-'Risk vs exp Calc'!E583),('Risk vs exp Calc'!E565-'Risk vs exp Calc'!E566)),\"\")","v":""},"","","",""]
[null,"Reserves 1  [Note 3]",{"$f":"IFERROR(('Risk vs exp Calc'!C616+'Risk vs exp Calc'!C617-'Risk vs exp Calc'!C618)-('Risk vs exp Calc'!C598+'Risk vs exp Calc'!C599-'Risk vs exp Calc'!C600),\"\")","v":""},{"$f":"IFERROR(('Risk vs exp Calc'!D616+'Risk vs exp Calc'!D617-'Risk vs exp Calc'!D618)-('Risk vs exp Calc'!D598+'Risk vs exp Calc'!D599-'Risk vs exp Calc'!D600),\"\")","v":""},{"$f":"IFERROR(('Risk vs exp Calc'!E616+'Risk vs exp Calc'!E617-'Risk vs exp Calc'!E618)-('Risk vs exp Calc'!E598+'Risk vs exp Calc'!E599-'Risk vs exp Calc'!E600),\"\")","v":""},"","","",""]
[null,"Reserves 2  [Note 4]",{"$f":"IFERROR(C9-(('Risk vs exp Calc'!C619-'Risk vs exp Calc'!C620-'Risk vs exp Calc'!C621)-('Risk vs exp Calc'!C601-'Risk vs exp Calc'!C602-'Risk vs exp Calc'!C603)),\"\")","v":""},{"$f":"IFERROR(D9-(('Risk vs exp Calc'!D619-'Risk vs exp Calc'!D620-'Risk vs exp Calc'!D621)-('Risk vs exp Calc'!D601-'Risk vs exp Calc'!D602-'Risk vs exp Calc'!D603)),\"\")","v":""},{"$f":"IFERROR(E9-(('Risk vs exp Calc'!E619-'Risk vs exp Calc'!E620-'Risk vs exp Calc'!E621)-('Risk vs exp Calc'!E601-'Risk vs exp Calc'!E602-'Risk vs exp Calc'!E603)),\"\")","v":""},"","","",""]
[null,"Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C7+0.5*C9,\"\")","v":""},"","","","","",""]
[null,"Premium 2 + 1/2 * Reserves 2","","","","","","",""]
[null,"Risk margin (RM)",{"$f":"'Risk vs exp Calc'!C624","v":""},{"$f":"'Risk vs exp Calc'!D624","v":""},{"$f":"'Risk vs exp Calc'!E624","v":""},"","","",""]
[null,"1:200 gross claims less 1:200 net claims [Note 5]",{"$f":"IFERROR('Risk vs exp Calc'!C88-'Risk vs exp Calc'!C85,\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!D88-'Risk vs exp Calc'!D85,\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!E88-'Risk vs exp Calc'!E85,\"\")","v":""},"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1:200 and mean","Simulation error"]
[null,"Available assets [Note 6]",{"$f":"IFERROR('Risk vs exp Calc'!C625-'Risk vs exp Calc'!C607+'Risk vs exp Calc'!C632,\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!D625-'Risk vs exp Calc'!D607+'Risk vs exp Calc'!D632,\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!E625-'Risk vs exp Calc'!E607+'Risk vs exp Calc'!E632,\"\")","v":""},"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold",0.05,0.01]
[null,null,"B. ULTIMATE RISK"]
[null,"SCR "]
[null,"Mean",{"$f":"'Risk vs exp Calc'!C58","v":""},{"$f":"'Risk vs exp Calc'!D58","v":""},{"$f":"'Risk vs exp Calc'!E58","v":""},{"$f":"IFERROR(C18-D18,\"\")","v":""},{"$f":"IFERROR((C18-D18)/D18,\"\")","v":""},{"$f":"IFERROR(D18-E18,\"\")","v":""},{"$f":"IFERROR((D18-E18)/E18,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(OR(C18=\"\",D18=\"\"),\"\",IF(C18>0,IF(D18>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(G27=\"\",G26=\"\"), \"\", IF(AND($G27<-$AC$15,($G26)>=$AC$15),$AB$21,IF(AND($G27<=$AC$15,$G26>$AC$15),$AB$22,\"\")))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(OR(D18=\"\",E18=\"\"),\"\",IF(D18>0,IF(E18>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(I27=\"\",I26=\"\"), \"\", IF(AND($I27<-$AC$15,($I26)>=$AC$15),$AB$21,IF(AND($I27<=$AC$15,$I26>$AC$15),$AB$22,\"\")))),\"\")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID","Conditions"]
[null,"SCR (submitted)",{"$f":"'Risk vs exp Calc'!C47","v":""},{"$f":"'Risk vs exp Calc'!D47","v":""},{"$f":"'Risk vs exp Calc'!E47","v":""},"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Mean value is a loss"]
[null,"Undiversified",{"$f":"'Risk vs exp Calc'!C40","v":""},{"$f":"'Risk vs exp Calc'!D40","v":""},{"$f":"'Risk vs exp Calc'!E40","v":""},"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Mean value was a loss in both the submission"]
[null,"Diversification credit (£)",{"$f":"IFERROR(C20-C19,\"\")","v":""},{"$f":"IFERROR(D20-D19,\"\")","v":""},"","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"The 1:200 has decreased but the mean profit has not"]
[null,"Diversification credit (%)",{"$f":"IFERROR(C21/C20,\"\")","v":""},{"$f":"IFERROR(D21/D20,\"\")","v":""},"","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"The 1:200 has not increased but the mean profit has"]
[null,"Loading [Note 7]",0,0,0,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"\"1:200 has decreased by more than \"&TEXT($AB$15,\"0%\")","v":"1:200 has decreased by more than 5%"}]
[null,"SCR (agreed)",{"$f":"IFERROR(C19+C23,\"\")","v":""},{"$f":"IFERROR(D19+D23,\"\")","v":""},"","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"\"1:200 has increased by more than \"&TEXT($AB$15,\"0%\")","v":"1:200 has increased by more than 5%"}]
[null,"SCR (agreed) + RM",{"$f":"IFERROR(C13+C24,\"\")","v":""},{"$f":"IFERROR(D13+D24,\"\")","v":""},{"$f":"IFERROR(E13+E24,\"\")","v":""},"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"One year mean>ultimate mean"]
[null,"Mean vs. Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C18/C11,\"\")","v":""},{"$f":"IFERROR(D18/D11,\"\")","v":""},"",null,{"$f":"IFERROR((C26-D26)/D26,\"\")","v":""},null,"",{"$f":"IFERROR(IF(ABS($G26)>$AB$15,IF($G26>0,$AB$29,$AB$28),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I26)>$AB$15,IF($I26>0,$AB$29,$AB$28),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"One year SCR has decreased compared to ultimate SCR"]
[null,"SCR (agreed) + RM vs. Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C25/(C11),\"\")","v":""},{"$f":"IFERROR(D25/(D11),\"\")","v":""},{"$f":"IFERROR(E25/(E11),\"\")","v":""},null,"",null,"",{"$f":"IFERROR(IF(ABS($G27)>$AB$15,IF($G27>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I27)>$AB$15,IF($I27>0,$AB$24,$AB$23),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"One year SCR compared to ultimate SCR + risk margin is greater than 100%"]
[null,"SCR (agreed) + RM vs. Premium 2 + 1/2 * Reserves 2",{"$f":"IFERROR(C25/(C12),\"\")","v":""},{"$f":"IFERROR(D25/(D12),\"\")","v":""},{"$f":"IFERROR(E25/(E12),\"\")","v":""},null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"\"Mean vs. exposure has decreased by more than \"&TEXT($AB$15,\"0%\")","v":"Mean vs. exposure has decreased by more than 5%"}]
[null,"Insurance risk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"\"Mean vs. exposure has increased by more than \"&TEXT($AB$15,\"0%\")","v":"Mean vs. exposure has increased by more than 5%"}]
[null,"Mean",{"$f":"'Risk vs exp Calc'!C676","v":""},{"$f":"'Risk vs exp Calc'!D676","v":""},{"$f":"'Risk vs exp Calc'!E676","v":""},{"$f":"IFERROR(C30-D30,\"\")","v":""},{"$f":"IFERROR((C30-D30)/D30,\"\")","v":""},{"$f":"IFERROR(D30-E30,\"\")","v":""},{"$f":"IFERROR((D30-E30)/E30,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(OR(C30=\"\",D30=\"\"),\"\",IF(C30>0,IF(D30>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(G37=\"\",G36=\"\"),\"\",IF(AND($G37<-$AC$15,($G36)>=$AC$15),$AB$21,IF(AND($G37<=$AC$15,$G36>$AC$15),$AB$22,\"\")))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(OR(D30=\"\",E30=\"\"),\"\",IF(D30>0,IF(E30>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(I37=\"\",I36=\"\"),\"\",IF(AND($I37<-$AC$15,($I36)>=$AC$15),$AB$21,IF(AND($I37<=$AC$15,$I36>$AC$15),$AB$22,\"\")))),\"\")","v":" "}]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C32","v":""},{"$f":"'Risk vs exp Calc'!D32","v":""},{"$f":"'Risk vs exp Calc'!E32","v":""},{"$f":"IFERROR(C31-D31,\"\")","v":""},"",{"$f":"IFERROR(D31-E31,\"\")","v":""},""]
[null,"1:200 undiversified",{"$f":"IFERROR('Risk vs exp Calc'!C34+'Risk vs exp Calc'!C33,\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!D34+'Risk vs exp Calc'!D33,\"\")","v":""},{"$f":"IFERROR('Risk vs exp Calc'!E34+'Risk vs exp Calc'!E33,\"\")","v":""},{"$f":"IFERROR(C32-D32,\"\")","v":""},"",{"$f":"IFERROR(D32-E32,\"\")","v":""},""]
[null,"Diversification credit (£)",{"$f":"IFERROR(C32-C31,\"\")","v":""},{"$f":"IFERROR(D32-D31,\"\")","v":""},"",{"$f":"IFERROR(C33-D33,\"\")","v":""},"",{"$f":"IFERROR(D33-E33,\"\")","v":""},""]
[null,"Diversification credit (%)",{"$f":"IFERROR(C33/C32,\"\")","v":""},{"$f":"IFERROR(D33/D32,\"\")","v":""},"",null,"",null,"",{"$f":"IFERROR(CONCATENATE(IF((C31+C13)<C41,\"Premium risk exceeds Insurance risk + RM\",\"\"),\"   \",IF((C31<C47),\"Reserve risk exceeds Insurance risk\",\"\")),\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF((D31+D13)<D41,\"Premium risk exceeds Insurance risk + RM\",\"\"),\"   \",IF((D31<D47),\"Reserve risk exceeds Insurance risk\",\"\")),\"\")","v":""}]
[null,"1:200 + RM",{"$f":"IFERROR(C31+C13,\"\")","v":""},{"$f":"IFERROR(D31+D13,\"\")","v":""},"",{"$f":"IFERROR(C35-D35,\"\")","v":""},"",{"$f":"IFERROR(D35-E35,\"\")","v":""},""]
[null,"Mean vs. Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C30/C11,\"\")","v":""},{"$f":"IFERROR(D30/D11,\"\")","v":""},{"$f":"IFERROR(E30/E11,\"\")","v":""},null,"",null,"",{"$f":"IFERROR(IF(ABS($G36)>$AB$15,IF($G36>0,$AB$29,$AB$28),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I36)>$AB$15,IF($I36>0,$AB$29,$AB$28),\"\"),\"\")","v":""}]
[null,"1:200 + RM vs. Premium 1 + 1/2 Reserves 1",{"$f":"IFERROR(C35/C11,\"\")","v":""},{"$f":"IFERROR(D35/D11,\"\")","v":""},"",null,"",null,"",{"$f":"IFERROR(IF(ABS($G37)>$AB$15,IF($G37>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I37)>$AB$15,IF($I37>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"1:200 + RM vs. Premium 2 + 1/2 Reserves 2",{"$f":"IFERROR(C35/C12,\"\")","v":""},{"$f":"IFERROR(D35/D12,\"\")","v":""},"",null,"",null,""]
[null,"Premium risk"]
[null,"Mean",{"$f":"'Risk vs exp Calc'!C679","v":""},{"$f":"'Risk vs exp Calc'!D679","v":""},{"$f":"'Risk vs exp Calc'!E679","v":""},{"$f":"IFERROR(C40-D40,\"\")","v":""},{"$f":"IFERROR((C40-D40)/D40,\"\")","v":""},{"$f":"IFERROR(D40-E40,\"\")","v":""},{"$f":"IFERROR((D40-E40)/E40,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(OR(C40=\"\",D40=\"\"),\"\",IF(C40>0,IF(D40>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(G43=\"\",G42=\"\"),\"\",IF(AND($G43<-$AC$15,($G42)>=$AC$15),$AB$21,IF(AND($G43<=$AC$15,$G42>$AC$15),$AB$22,\"\")))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(OR(D40=\"\",E40=\"\"),\"\",IF(D40>0,IF(E40>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(I43=\"\",I42=\"\"),\"\",IF(AND($I43<-$AC$15,($I42)>=$AC$15),$AB$21,IF(AND($I43<=$AC$15,$I42>$AC$15),$AB$22,\"\")))),\"\")","v":" "}]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C33","v":""},{"$f":"'Risk vs exp Calc'!D33","v":""},{"$f":"'Risk vs exp Calc'!E33","v":""},{"$f":"IFERROR(C41-D41,\"\")","v":""},{"$f":"IFERROR((C41-D41)/D41,\"\")","v":""},{"$f":"IFERROR(D41-E41,\"\")","v":""},{"$f":"IFERROR((D41-E41)/E41,\"\")","v":""}]
[null,"Mean vs. Premium 1",{"$f":"IFERROR(C40/C7,\"\")","v":""},{"$f":"IFERROR(D40/D7,\"\")","v":""},{"$f":"IFERROR(E40/E7,\"\")","v":""},null,{"$f":"IFERROR((C42-D42)/D42,\"\")","v":""},null,{"$f":"IFERROR((D42-E42)/E42,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G42)>$AB$15,IF($G42>0,$AB$29,$AB$28),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I42)>$AB$15,IF($I42>0,$AB$29,$AB$28),\"\"),\"\")","v":""}]
[null,"1:200 vs. Premium 1",{"$f":"IFERROR(C$41/C7,\"\")","v":""},"","",null,{"$f":"IFERROR((C43-D43)/D43,\"\")","v":""},null,{"$f":"IFERROR((D43-E43)/E43,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G43)>$AB$15,IF($G43>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I43)>$AB$15,IF($I43>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"1:200 vs. Premium 2","","","",null,{"$f":"IFERROR((C44-D44)/D44,\"\")","v":""},null,{"$f":"IFERROR((D44-E44)/E44,\"\")","v":""}]
[null,"Reserve risk"]
[null,"Mean",{"$f":"+'Risk vs exp Calc'!C682","v":""},{"$f":"+'Risk vs exp Calc'!D682","v":""},{"$f":"+'Risk vs exp Calc'!E682","v":""},{"$f":"IFERROR(C46-D46,\"\")","v":""},{"$f":"IFERROR((C46-D46)/D46,\"\")","v":""},{"$f":"IFERROR(D46-E46,\"\")","v":""},{"$f":"IFERROR((D46-E46)/E46,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(OR(C46=\"\",D46=\"\"),\"\",IF(C46>0,IF(D46>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(G51=\"\",G49=\"\"),\"\",IF(AND($G51<-$AC$15,($G49)>=$AC$15),$AB$21,IF(AND($G51<=$AC$15,$G49>$AC$15),$AB$22,\"\")))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(OR(D46=\"\",E46=\"\"),\"\",IF(D46>0,IF(E46>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(I51=\"\",I49=\"\"),\"\",IF(AND($I51<-$AC$15,($I49)>=$AC$15),$AB$21,IF(AND($I51<=$AC$15,$I49>$AC$15),$AB$22,\"\")))),\"\")","v":" "}]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C34","v":""},{"$f":"'Risk vs exp Calc'!D34","v":""},{"$f":"'Risk vs exp Calc'!E34","v":""},{"$f":"IFERROR(C47-D47,\"\")","v":""},"",{"$f":"IFERROR(D47-E47,\"\")","v":""},""]
[null,"1:200 + Risk margin",{"$f":"IFERROR(C47+C13,\"\")","v":""},{"$f":"IFERROR(D47+D13,\"\")","v":""},{"$f":"IFERROR(E47+E13,\"\")","v":""},{"$f":"IFERROR(C48-D48,\"\")","v":""},"",{"$f":"IFERROR(D48-E48,\"\")","v":""},""]
[null,"Mean vs. Reserves 1",{"$f":"IFERROR(C46/C9,\"\")","v":""},{"$f":"IFERROR(D46/D9,\"\")","v":""},{"$f":"IFERROR(E46/E9,\"\")","v":""},null,"",null,"",{"$f":"IFERROR(IF(ABS($G49)>$AB$15,IF($G49>0,$AB$29,$AB$28),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I49)>$AB$15,IF($I49>0,$AB$29,$AB$28),\"\"),\"\")","v":""}]
[null,"1:200 vs. Reserves 1",{"$f":"IFERROR(C$47/C9,\"\")","v":""},{"$f":"IFERROR(D$47/D9,\"\")","v":""},{"$f":"IFERROR(E$47/E9,\"\")","v":""},null,"",null,""]
[null,"1:200 + RM vs. Reserves 1",{"$f":"IFERROR(C$48/C9,\"\")","v":""},"","",null,"",null,"",{"$f":"IFERROR(IF(ABS($G51)>$AB$15,IF($G51>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I51)>$AB$15,IF($I51>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"1:200 + RM vs. Reserves 2","","","",null,"",null,""]
[null,"RI credit risk"]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C36","v":""},{"$f":"'Risk vs exp Calc'!D36","v":""},{"$f":"'Risk vs exp Calc'!E36","v":""},{"$f":"IFERROR(C54-D54,\"\")","v":""},{"$f":"IFERROR((C54-D54)/D54,\"\")","v":""},{"$f":"IFERROR(D54-E54,\"\")","v":""},{"$f":"IFERROR((D54-E54)/E54,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G55)>$AB$15,IF($G55>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I55)>$AB$15,IF($I55>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"1:200 vs. 1:200 gross claims less 1:200 net claims ",{"$f":"IFERROR(C54/C14,\"\")","v":""},{"$f":"IFERROR(D54/D14,\"\")","v":""},{"$f":"IFERROR(E54/E14,\"\")","v":""},null,{"$f":"IFERROR((C55-D55)/D55,\"\")","v":""},null,{"$f":"IFERROR((D55-E55)/E55,\"\")","v":""}]
[null,"Market risk "]
[null,"Mean",{"$f":"+'Risk vs exp Calc'!C712","v":""},{"$f":"+'Risk vs exp Calc'!D712","v":""},{"$f":"+'Risk vs exp Calc'!E712","v":""},{"$f":"IFERROR(C57-D57,\"\")","v":""},{"$f":"IFERROR((C57-D57)/D57,\"\")","v":""},{"$f":"IFERROR(D57-E57,\"\")","v":""},{"$f":"IFERROR((D57-E57)/E57,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(OR(C57=\"\",D57=\"\"),\"\",IF(C57>0,IF(D57>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(G60=\"\",G59=\"\"),\"\",IF(AND($G60<-$AC$15,($G59)>=$AC$15),$AB$21,IF(AND($G60<=$AC$15,$G59>$AC$15),$AB$22,\"\")))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(OR(D57=\"\",E57=\"\"),\"\",IF(D57>0,IF(E57>0,$AB$20,$AB$19),\"\")),\" \",IF(OR(I60=\"\",I59=\"\"),\"\",IF(AND($I60<-$AC$15,($I59)>=$AC$15),$AB$21,IF(AND($I60<=$AC$15,$I59>$AC$15),$AB$22,\"\")))),\"\")","v":" "}]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C38","v":""},{"$f":"'Risk vs exp Calc'!D38","v":""},{"$f":"'Risk vs exp Calc'!E38","v":""},{"$f":"IFERROR(C58-D58,\"\")","v":""},{"$f":"IFERROR((C58-D58)/D58,\"\")","v":""},{"$f":"IFERROR(D58-E58,\"\")","v":""},{"$f":"IFERROR((D58-E58)/E58,\"\")","v":""}]
[null,"Mean vs. Available assets",{"$f":"IFERROR(C57/C15,\"\")","v":""},{"$f":"IFERROR(D57/D15,\"\")","v":""},{"$f":"IFERROR(E57/E15,\"\")","v":""},null,{"$f":"IFERROR((C59-D59)/D59,\"\")","v":""},null,{"$f":"IFERROR((D59-E59)/E59,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G59)>$AB$15,IF($G59>0,$AB$29,$AB$28),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I59)>$AB$15,IF($I59>0,$AB$29,$AB$28),\"\"),\"\")","v":""}]
[null,"1:200 vs. Available assets",{"$f":"IFERROR(C58/C15,\"\")","v":""},{"$f":"IFERROR(D58/D15,\"\")","v":""},{"$f":"IFERROR(E58/E15,\"\")","v":""},null,{"$f":"IFERROR((C60-D60)/D60,\"\")","v":""},null,{"$f":"IFERROR((D60-E60)/E60,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G60)>$AB$15,IF($G60>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($G60)>$AB$15,IF($G60>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"Operational risk"]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C39","v":""},{"$f":"'Risk vs exp Calc'!D39","v":""},{"$f":"'Risk vs exp Calc'!E39","v":""},{"$f":"IFERROR(C62-D62,\"\")","v":""},{"$f":"IFERROR((C62-D62)/D62,\"\")","v":""},{"$f":"IFERROR(D62-E62,\"\")","v":""},{"$f":"IFERROR((D62-E62)/E62,\"\")","v":""}]
[null,"1:200 vs. Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C62/(C11),\"\")","v":""},{"$f":"IFERROR(D62/(D11),\"\")","v":""},{"$f":"IFERROR(E62/(E11),\"\")","v":""},null,{"$f":"IFERROR((C63-D63)/D63,\"\")","v":""},null,{"$f":"IFERROR((D63-E63)/E63,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G63)>$AB$15,IF($G63>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I63)>$AB$15,IF($I63>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,null,"C. ONE YEAR RISK"]
[null,"SCR"]
[null,"Mean",{"$f":"'Risk vs exp Calc'!C51","v":""},{"$f":"'Risk vs exp Calc'!D51","v":""},{"$f":"'Risk vs exp Calc'!E51","v":""},{"$f":"IFERROR(C66-D66,\"\")","v":""},{"$f":"IFERROR((C66-D66)/D66,\"\")","v":""},{"$f":"IFERROR(D66-E66,\"\")","v":""},{"$f":"IFERROR((D66-E66)/E66,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(C66=\"\",\"\",IF(C66>0,$AB$19,\"\")),\" \",IF(C66<C18,$AB$25,\"\"),\" \",IF(AND($G74<-$AC$15,($G73)>=$AC$15),$AB$21,IF(AND($G74<=$AC$15,$G73>$AC$15),$AB$22,\"\"))),\"\")","v":"  "},{"$f":"IFERROR(CONCATENATE(IF(D66=\"\",\"\",IF(D66>0,$AB$19,\"\")),\" \",IF(D66<D18,$AB$25,\"\"),\" \",IF(AND($I74<-$AC$15,($I73)>=$AC$15),$AB$21,IF(AND($I74<=$AC$15,$I73>$AC$15),$AB$22,\"\"))),\"\")","v":"  "}]
[null,"SCR(1) (submitted)",{"$f":"'Risk vs exp Calc'!C10","v":""},{"$f":"'Risk vs exp Calc'!D10","v":""},{"$f":"'Risk vs exp Calc'!E10","v":""},{"$f":"IFERROR(C67-D67,\"\")","v":""},"",{"$f":"IFERROR(D67-E67,\"\")","v":""},""]
[null,"Loading [Note 7]",0,0,0,null,"",null,""]
[null,"SCR(1) (agreed)",{"$f":"IFERROR(C67+C68,\"\")","v":""},{"$f":"IFERROR(D67+D68,\"\")","v":""},"",{"$f":"IFERROR(C69-D69,\"\")","v":""},"",{"$f":"IFERROR(D69-E69,\"\")","v":""},""]
[null,"Mean vs. SCR mean",{"$f":"IFERROR(+C66/C18,\"\")","v":""},{"$f":"IFERROR(+D66/D18,\"\")","v":""},{"$f":"IFERROR(+E66/E18,\"\")","v":""},null,"",null,""]
[null,"SCR(1) (agreed) vs. SCR (agreed)",{"$f":"IFERROR(C69/C24,\"\")","v":""},{"$f":"IFERROR(D69/D24,\"\")","v":""},{"$f":"IFERROR(E69/E24,\"\")","v":""},null,"",null,""]
[null,"SCR(1) (agreed) vs. SCR (agreed) + RM",{"$f":"IFERROR(C69/C25,\"\")","v":""},{"$f":"IFERROR(D69/D25,\"\")","v":""},"",null,"",null,"",{"$f":"IFERROR(IF((C72)<0%,$AB$26,IF(C72=\"\",\"\",IF(C72>100%,$AB$27,\"\"))),\"\")","v":""}]
[null,"Mean(1) vs. Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C66/C11,\"\")","v":""},{"$f":"IFERROR(D66/D11,\"\")","v":""},{"$f":"IFERROR(E66/E11,\"\")","v":""},null,{"$f":"IFERROR((C73-D73)/D73,\"\")","v":""},null,"",{"$f":"IFERROR(IF(ABS($G73)>$AB$15,IF($G73>0,$AB$29,$AB$28),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I73)>$AB$15,IF($I73>0,$AB$29,$AB$28),\"\"),\"\")","v":""}]
[null,"SCR(1) (agreed) vs. Premium 1 + 1/2 * Reserves 1",{"$f":"IFERROR(C69/C11,\"\")","v":""},{"$f":"IFERROR(D69/D11,\"\")","v":""},{"$f":"IFERROR(E69/E11,\"\")","v":""},null,"",null,"",{"$f":"IFERROR(IF(ABS($G74)>$AB$15,IF($G74>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I74)>$AB$15,IF($I74>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"SCR(1) (agreed) vs. Premium 2 + 1/2 * Reserves 2",{"$f":"IFERROR(C69/C12,\"\")","v":""},{"$f":"IFERROR(D69/D12,\"\")","v":""},{"$f":"IFERROR(E69/E12,\"\")","v":""},null,"",null,""]
[null,"Risk margin"]
[null,"RM vs. Reserves 1",{"$f":"IFERROR(C13/C9,\"\")","v":""},{"$f":"IFERROR(D13/D9,\"\")","v":""},{"$f":"IFERROR(E13/E9,\"\")","v":""},null,{"$f":"IFERROR((C77-D77)/D77,\"\")","v":""},null,{"$f":"IFERROR((D77-E77)/E77,\"\")","v":""}]
[null,"Premium risk"]
[null,"Mean [Note 7]",0,0,0,null,{"$f":"IFERROR((C79-D79)/D79,\"\")","v":""},null,{"$f":"IFERROR((D79-E79)/E79,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(C79>0,$AB$19,\"\"),\" \",IF(C40=\"\",\"\",IF(C79<C40,$AB$25,\"\"))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(D79>0,$AB$19,\"\"),\" \",IF(D40=\"\",\"\",IF(D79<D40,$AB$25,\"\"))),\"\")","v":" "}]
[null,"1:200 ",{"$f":"'Risk vs exp Calc'!C15","v":""},{"$f":"'Risk vs exp Calc'!D15","v":""},{"$f":"'Risk vs exp Calc'!E15","v":""},{"$f":"IFERROR(C80-D80,\"\")","v":""},{"$f":"IFERROR((C80-D80)/D80,\"\")","v":""},{"$f":"IFERROR(D80-E80,\"\")","v":""},{"$f":"IFERROR((D80-E80)/E80,\"\")","v":""}]
[null,"Allocated risk margin [Note 8]",0,0,0,null,{"$f":"IFERROR((C81-D81)/D81,\"\")","v":""},null,{"$f":"IFERROR((D81-E81)/E81,\"\")","v":""}]
[null,"1:200 vs. Ultimate 1:200 + allocated RM",{"$f":"IFERROR(C80/(C41+C81),\"\")","v":""},{"$f":"IFERROR(D80/(D41+D81),\"\")","v":""},{"$f":"IFERROR(E80/(E41+E81),\"\")","v":""},null,{"$f":"IFERROR((C82-D82)/D82,\"\")","v":""},null,{"$f":"IFERROR((D82-E82)/E82,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G82)>$AB$15,IF($G82>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I82)>$AB$15,IF($I82>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[null,"1:200 vs. Premium 1",{"$f":"IFERROR(C80/C7,\"\")","v":""},{"$f":"IFERROR(D80/D7,\"\")","v":""},{"$f":"IFERROR(E80/E7,\"\")","v":""},null,{"$f":"IFERROR((C83-D83)/D83,\"\")","v":""},null,{"$f":"IFERROR((D83-E83)/E83,\"\")","v":""}]
[null,"Reserve risk"]
[null,"Mean [Note 7]",0,0,0,null,{"$f":"IFERROR((C85-D85)/D85,\"\")","v":""},null,{"$f":"IFERROR((D85-E85)/E85,\"\")","v":""},{"$f":"IFERROR(CONCATENATE(IF(C85>0,$AB$19,\"\"),\" \",IF(C46=\"\",\"\",IF(C85<C46,$AB$25,\"\"))),\"\")","v":" "},{"$f":"IFERROR(CONCATENATE(IF(D85>0,$AB$19,\"\"),\" \",IF(D46=\"\",\"\",IF(D85<D46,$AB$25,\"\"))),\"\")","v":" "}]
[null,"1:200",{"$f":"'Risk vs exp Calc'!C16","v":""},{"$f":"'Risk vs exp Calc'!D16","v":""},{"$f":"'Risk vs exp Calc'!E16","v":""},{"$f":"IFERROR(C86-D86,\"\")","v":""},{"$f":"IFERROR((C86-D86)/D86,\"\")","v":""},{"$f":"IFERROR(D86-E86,\"\")","v":""},{"$f":"IFERROR((D86-E86)/E86,\"\")","v":""}]
[null,"Allocated risk margin [Note 8]",0,0,0,null,{"$f":"IFERROR((C87-D87)/D87,\"\")","v":""},null,{"$f":"IFERROR((D87-E87)/E87,\"\")","v":""}]
[null,"1:200 vs. Ultimate 1:200 + allocated RM",{"$f":"IFERROR(C86/(C47+C87),\"\")","v":""},{"$f":"IFERROR(D86/(D47+D87),\"\")","v":""},{"$f":"IFERROR(E86/(E47+E87),\"\")","v":""},null,{"$f":"IFERROR((C88-D88)/D88,\"\")","v":""},null,{"$f":"IFERROR((D88-E88)/E88,\"\")","v":""}]
[null,"1:200 vs. Reserves 1",{"$f":"IFERROR(C86/C9,\"\")","v":""},{"$f":"IFERROR(D86/D9,\"\")","v":""},{"$f":"IFERROR(E86/E9,\"\")","v":""},null,{"$f":"IFERROR((C89-D89)/D89,\"\")","v":""},null,{"$f":"IFERROR((D89-E89)/E89,\"\")","v":""},{"$f":"IFERROR(IF(ABS($G89)>$AB$15,IF($G89>0,$AB$24,$AB$23),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ABS($I89)>$AB$15,IF($I89>0,$AB$24,$AB$23),\"\"),\"\")","v":""}]
[]
[]
[null,"Notes"]
[null,"[1] Proposed YOA planned premium. Source: F313 Table 1 Row 1 col. D."]
[null,"[2] Premium 1 plus an approximate adjustment for unearned premium on the current YOA. Source: Premium 1 plus F312 Current YOA K less Current YOA L."]
[null,"[3] Claims plus ULAE less discount for all years combined less the proposed YOA. Source: F312 H+I-J Total less Proposed YOA."]
[null,"[4] Reserves 1 reduced by premiums less acquisition costs and the discount benefit for all years combined less the proposed YOA. The reduction is an approximation for claims on unearned exposure (assumes 100% loss ratio). "]
[null,"       Source: Reserves 1 less F312 K-L-M for Total less Proposed YOA."]
[null,"[5] Approximation for RI recoveries. Source: F 311 column table 1, column G, row 4 less row 3."]
[null,"[6] Technical provisions plus Proposed YOA planned premium. Source: F312 Q Total less Proposed YOA + F313 1D."]
[null,"[7] Manual input"]
[null,"[8] Manual input - as reported in the Supplementary Questionnaire PartII_Dependencies_Inputs, question 4."]

{"sheet":"Risk vs exp Calc","index":4,"n_rows":1000,"n_cols":29,"rows_kept":1000,"cut":false,"hidden":true,"merged":[]}
[null,"This sheet collects raw CSV data for the four relevant reporting periods"]
[null,"The CSVs must be saved in the same folder as this file and must be named LCRs sXXX period A.xlsx, LCRs sXXX period B.xlsx, etc…"]
[null,"The links to CSVs are updated by a macro from a different sheet"]
[null,"All periods - summarised and v-lookupped",null,null,null,null,null,"CVS file A - straight dump",null,null,null,null,null,null,"CVS file B  - straight dump",null,null,null,null,null,null,"CVS file C - straight dump",null,null,null,null,null,null,"CVS file D - straight dump"]
[]
[null,{"$f":"Synd","v":0},"Reporting period A","Reporting period B","Reporting period C","Reporting period D",null,{"$f":"I6&K6&L6","v":""},null,null,null,null,null,null,{"$f":"P6&R6&S6","v":""},null,null,null,null,null,null,{"$f":"W6&Y6&Z6","v":""}]
[null,null,{"$f":"\"s\"&Synd&\" FORM 309\"","v":"s FORM 309"},null,null,null,null,{"$f":"I7&K7&L7","v":""},null,null,null,null,null,null,{"$f":"P7&R7&S7","v":""},null,null,null,null,null,null,{"$f":"W7&Y7&Z7","v":""}]
[null,null,null,null,null,null,null,{"$f":"I8&K8&L8","v":""},null,null,null,null,null,null,{"$f":"P8&R8&S8","v":""},null,null,null,null,null,null,""]
[null,null,"Headline",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotal_OneYrPostDiversification","One-Year Syndicate SCR Post Diversification ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A10,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A10,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A10,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A10,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotal_UltPostDiversification","Ultimate Syndicate SCR Post Diversification ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A11,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A11,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A11,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A11,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"One-Year",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumReserveRisk_OneYrPreDiversification","One-Year total: After diversification between Premium and Reserve risk Pre Diversification ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A14,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A14,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A14,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A14,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumRisk_OneYrPreDiversification","One-Year split: Premium Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReserveRisk_OneYrPreDiversification","One-Year split: Reserve Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRiskTotal_OneYrPreDiversification","One-Year total: After diversification between Reinsurance Credit Risk and Other Credit Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReinsuranceCreditRisk_OneYrPreDiversification","One-Year split: Reinsurance Credit Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OtherCreditRisk_OneYrPreDiversification","One-Year split: Other Credit Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["MarketRisk_OneYrPreDiversification","One-Year Market Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OperationalRisk_OneYrPreDiversification","One-Year Operational Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_OneYrPreDiversification_LCALC","One-Year TOTAL Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumReserveRisk_OneYrPostDiversification","One-Year total: After diversification between Premium and Reserve risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRiskTotal_OneYrPostDiversification","One-Year total: After diversification between Reinsurance Credit Risk and Other Credit Risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["MarketRisk_OneYrPostDiversification","One-Year Market Risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OperationalRisk_OneYrPostDiversification","One-Year Operational Risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_OneYrPostDiversification_LCALC","One-Year TOTAL Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversificationCredit_OneYrPreDiversification","One-Year Diversification credit between risk categories ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotal_OneYrPostDiversification_LCALC","One-Year DIVERSIFIED TOTAL ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Ultimate",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumReserveRisk_UltPreDiversification","Ultimate total: After diversification between Premium and Reserve risk Pre Diversification ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A32,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A32,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A32,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A32,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumRisk_UltPreDiversification","Ultimate split: Premium Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReserveRisk_UltPreDiversification","Ultimate split: Reserve Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRiskTotal_UltPreDiversification","Ultimate total: After diversification between Reinsurance Credit Risk and Other Credit Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReinsuranceCreditRisk_UltPreDiversification","Ultimate split: Reinsurance Credit Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OtherCreditRisk_UltPreDiversification","Ultimate split: Other Credit Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["MarketRisk_UltPreDiversification","Ultimate Market Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OperationalRisk_UltPreDiversification","Ultimate Operational Risk Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_UltPreDiversification_LCALC","Ultimate TOTAL Pre Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumReserveRisk_UltPostDiversification","Ultimate total: After diversification between Premium and Reserve risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRiskTotal_UltPostDiversification","Ultimate total: After diversification between Reinsurance Credit Risk and Other Credit Risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["MarketRisk_UltPostDiversification","Ultimate Market Risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OperationalRisk_UltPostDiversification","Ultimate Operational Risk Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_UltPostDiversification_LCALC","Ultimate TOTAL Post Diversification ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversificationCredit_UltPreDiversification","Ultimate Diversification credit between risk categories ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotal_UltPostDiversification_LCALC","Ultimate DIVERSIFIED TOTAL ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Notes990","Notes990","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,{"$f":"\"s\"&Synd&\" FORM 310\"","v":"s FORM 310"},null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYrMean","Distribution of balance sheet position on One-Year basis Mean ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A51,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A51,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A51,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A51,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYr50th","Distribution of balance sheet position on One-Year basis 50th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYr75th","Distribution of balance sheet position on One-Year basis 75th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYr90th","Distribution of balance sheet position on One-Year basis 90th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYr95th","Distribution of balance sheet position on One-Year basis 95th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYr99th","Distribution of balance sheet position on One-Year basis 99th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_OneYr99Pt8th","Distribution of balance sheet position on One-Year basis 99.8th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_UltMean","Distribution of balance sheet position on Ultimate basis Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_Ult50th","Distribution of balance sheet position on Ultimate basis 50th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_Ult75th","Distribution of balance sheet position on Ultimate basis 75th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_Ult90th","Distribution of balance sheet position on Ultimate basis 90th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_Ult95th","Distribution of balance sheet position on Ultimate basis 95th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_Ult99th","Distribution of balance sheet position on Ultimate basis 99th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DistributionBalSheet_Ult99Pt8th","Distribution of balance sheet position on Ultimate basis 99.8th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,{"$f":"\"s\"&Synd&\" FORM 311\"","v":"s FORM 311"},null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 1",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean","One-Year Net of reinsurance Mean ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A69,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A69,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A69,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A69,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYr50th","One-Year Net of reinsurance 50th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYr75th","One-Year Net of reinsurance 75th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W71&Y71&Z71","v":""}]
["NetOfRI_OneYr90th","One-Year Net of reinsurance 90th ","","","","",null,{"$f":"I72&K72&L72","v":""},null,null,null,null,null,null,{"$f":"P72&R72&S72","v":""},null,null,null,null,null,null,""]
["NetOfRI_OneYr95th","One-Year Net of reinsurance 95th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYr99th","One-Year Net of reinsurance 99th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYr99Pt5th","One-Year Net of reinsurance 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYr99Pt8th","One-Year Net of reinsurance 99.8th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrossOfRI_OneYrMean","One-Year Gross of reinsurance Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrossOfRI_OneYr99Pt5th","One-Year Gross of reinsurance 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_UltMean","Ultimate Net of reinsurance Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult50th","Ultimate Net of reinsurance 50th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult75th","Ultimate Net of reinsurance 75th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult90th","Ultimate Net of reinsurance 90th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult95th","Ultimate Net of reinsurance 95th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult99th","Ultimate Net of reinsurance 99th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult99Pt5th","Ultimate Net of reinsurance 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_Ult99Pt8th","Ultimate Net of reinsurance 99.8th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrossOfRI_UltMean","Ultimate Gross of reinsurance Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrossOfRI_Ult99Pt5th","Ultimate Gross of reinsurance 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 2",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1993","One-Year Net Insurance Claims brought forward  1993",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A91,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A91,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A91,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A91,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1993","One-Year Adjustments  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1993","One-Year New Business  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1993","One-Year Total Claims  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1994","One-Year Net Insurance Claims brought forward  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1994","One-Year Adjustments  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1994","One-Year New Business  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1994","One-Year Total Claims  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1995","One-Year Net Insurance Claims brought forward  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1995","One-Year Adjustments  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1995","One-Year New Business  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1995","One-Year Total Claims  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1996","One-Year Net Insurance Claims brought forward  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1996","One-Year Adjustments  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1996","One-Year New Business  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1996","One-Year Total Claims  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1997","One-Year Net Insurance Claims brought forward  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1997","One-Year Adjustments  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1997","One-Year New Business  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1997","One-Year Total Claims  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1998","One-Year Net Insurance Claims brought forward  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1998","One-Year Adjustments  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1998","One-Year New Business  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1998","One-Year Total Claims  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC1999","One-Year Net Insurance Claims brought forward  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR1999","One-Year Adjustments  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR1999","One-Year New Business  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC1999","One-Year Total Claims  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2000","One-Year Net Insurance Claims brought forward  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2000","One-Year Adjustments  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2000","One-Year New Business  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2000","One-Year Total Claims  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2001","One-Year Net Insurance Claims brought forward  2001",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A123,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A123,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A123,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A123,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2001","One-Year Adjustments  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2001","One-Year New Business  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2001","One-Year Total Claims  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2002","One-Year Net Insurance Claims brought forward  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2002","One-Year Adjustments  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2002","One-Year New Business  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2002","One-Year Total Claims  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2003","One-Year Net Insurance Claims brought forward  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2003","One-Year Adjustments  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2003","One-Year New Business  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2003","One-Year Total Claims  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2004","One-Year Net Insurance Claims brought forward  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W135&Y135&Z135","v":""}]
["Adjustments_OneYrMean_PYR2004","One-Year Adjustments  2004","","","","",null,{"$f":"I136&K136&L136","v":""},null,null,null,null,null,null,{"$f":"P136&R136&S136","v":""},null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2004","One-Year New Business  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2004","One-Year Total Claims  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2005","One-Year Net Insurance Claims brought forward  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2005","One-Year Adjustments  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2005","One-Year New Business  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2005","One-Year Total Claims  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2006","One-Year Net Insurance Claims brought forward  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2006","One-Year Adjustments  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2006","One-Year New Business  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2006","One-Year Total Claims  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2007","One-Year Net Insurance Claims brought forward  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2007","One-Year Adjustments  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2007","One-Year New Business  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2007","One-Year Total Claims  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2008","One-Year Net Insurance Claims brought forward  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2008","One-Year Adjustments  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2008","One-Year New Business  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2008","One-Year Total Claims  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2009","One-Year Net Insurance Claims brought forward  2009",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A155,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A155,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A155,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A155,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2009","One-Year Adjustments  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2009","One-Year New Business  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2009","One-Year Total Claims  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2010","One-Year Net Insurance Claims brought forward  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2010","One-Year Adjustments  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2010","One-Year New Business  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2010","One-Year Total Claims  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2011","One-Year Net Insurance Claims brought forward  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2011","One-Year Adjustments  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2011","One-Year New Business  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2011","One-Year Total Claims  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2012","One-Year Net Insurance Claims brought forward  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2012","One-Year Adjustments  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2012","One-Year New Business  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2012","One-Year Total Claims  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2013","One-Year Net Insurance Claims brought forward  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2013","One-Year Adjustments  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2013","One-Year New Business  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2013","One-Year Total Claims  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2014","One-Year Net Insurance Claims brought forward  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2014","One-Year Adjustments  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2014","One-Year New Business  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2014","One-Year Total Claims  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC2015","One-Year Net Insurance Claims brought forward  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Adjustments_OneYrMean_PYR2015","One-Year Adjustments  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusiness_OneYrMean_PYR2015","One-Year New Business  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_PYR_LCALC2015","One-Year Total Claims  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 2 - ULO",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["RetYrForRetYrPlusOneYoa_LCALC","Unincepted Legal Obligations as at December 2015; for the 2016 YoA Net Insurance Claims brought forward ",null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AdjustmentsUninceptedLglOblig_OneYrMean_ForRetYrPlusOneYoa","One-Year Unincepted Legal Obligations as at December 2015; for the 2016 YoA Adjustments ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A186,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A186,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A186,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A186,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NewBusinessUninceptedLglOblig_OneYrMean_ForRetYrPlusOneYoa_LCALC","One-Year Unincepted Legal Obligations as at December 2015; for the 2016 YoA New Business ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A187,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A187,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A187,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A187,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaimsUninceptedLglOblig_OneYrMean_ForRetYrPlusOneYoa_LCALC","One-Year Unincepted Legal Obligations as at December 2015; for the 2016 YoA Total Claims ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A188,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A188,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A188,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A188,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 2 - Totals",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetOfRI_OneYrMean_PYR_LCALC_LTOTAL","One-Year Net Insurance Claims brought forward ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A191,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A191,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A191,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A191,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalAdjustments_OneYrMean_LCALC","One-Year Adjustments ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A192,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A192,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A192,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A192,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNewBusiness_OneYrMean_LCALC","One-Year New Business ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A193,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A193,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A193,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A193,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalClaims_OneYrMean_LCALC","One-Year Total Claims ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A194,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A194,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A194,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A194,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,{"$f":"\"s\"&Synd&\" FORM 312\"","v":"s FORM 312"},null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 1",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1993","Gross Claims  1993",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A198,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A198,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A198,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A198,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1993","Gross Expenses  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W199&Y199&Z199","v":""}]
["GrInsLossDiscBenefit_PYR1993","Gross Discount Benefit  1993","","","","",null,{"$f":"I200&K200&L200","v":""},null,null,null,null,null,null,{"$f":"P200&R200&S200","v":""},null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1993","Gross Premium  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1993","Gross Acquisition Cost  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1993","Gross Discount Benefit  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1993","Gross Best Estimate Liabilities  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1993","Net Claims  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1993","Net Expenses  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1993","Net Discount Benefit  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1993","Net Premium  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1993","Net Acquisition Cost  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1993","Net Discount Benefit  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1993","Net Discounted Bad Debt Provision  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1993","Net Best Estimate Liabilities  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR1993","Net Risk Margin  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1993","Net Technical Provisions  1993","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1994","Gross Claims  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1994","Gross Expenses  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR1994","Gross Discount Benefit  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1994","Gross Premium  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1994","Gross Acquisition Cost  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1994","Gross Discount Benefit  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1994","Gross Best Estimate Liabilities  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1994","Net Claims  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1994","Net Expenses  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1994","Net Discount Benefit  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1994","Net Premium  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1994","Net Acquisition Cost  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1994","Net Discount Benefit  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1994","Net Discounted Bad Debt Provision  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1994","Net Best Estimate Liabilities  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR1994","Net Risk Margin  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1994","Net Technical Provisions  1994","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1995","Gross Claims  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1995","Gross Expenses  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR1995","Gross Discount Benefit  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1995","Gross Premium  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1995","Gross Acquisition Cost  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1995","Gross Discount Benefit  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1995","Gross Best Estimate Liabilities  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1995","Net Claims  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1995","Net Expenses  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1995","Net Discount Benefit  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1995","Net Premium  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1995","Net Acquisition Cost  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1995","Net Discount Benefit  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1995","Net Discounted Bad Debt Provision  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1995","Net Best Estimate Liabilities  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR1995","Net Risk Margin  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1995","Net Technical Provisions  1995","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1996","Gross Claims  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1996","Gross Expenses  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR1996","Gross Discount Benefit  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1996","Gross Premium  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1996","Gross Acquisition Cost  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1996","Gross Discount Benefit  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1996","Gross Best Estimate Liabilities  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1996","Net Claims  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1996","Net Expenses  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1996","Net Discount Benefit  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1996","Net Premium  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1996","Net Acquisition Cost  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1996","Net Discount Benefit  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1996","Net Discounted Bad Debt Provision  1996",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A262,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A262,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A262,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A262,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1996","Net Best Estimate Liabilities  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W263&Y263&Z263","v":""}]
["NetRiskMargin_PYR1996","Net Risk Margin  1996","","","","",null,{"$f":"I264&K264&L264","v":""},null,null,null,null,null,null,{"$f":"P264&R264&S264","v":""},null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1996","Net Technical Provisions  1996","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1997","Gross Claims  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1997","Gross Expenses  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR1997","Gross Discount Benefit  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1997","Gross Premium  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1997","Gross Acquisition Cost  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1997","Gross Discount Benefit  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1997","Gross Best Estimate Liabilities  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1997","Net Claims  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1997","Net Expenses  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1997","Net Discount Benefit  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1997","Net Premium  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1997","Net Acquisition Cost  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1997","Net Discount Benefit  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1997","Net Discounted Bad Debt Provision  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1997","Net Best Estimate Liabilities  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR1997","Net Risk Margin  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1997","Net Technical Provisions  1997","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1998","Gross Claims  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1998","Gross Expenses  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR1998","Gross Discount Benefit  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1998","Gross Premium  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1998","Gross Acquisition Cost  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1998","Gross Discount Benefit  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1998","Gross Best Estimate Liabilities  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1998","Net Claims  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1998","Net Expenses  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1998","Net Discount Benefit  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1998","Net Premium  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1998","Net Acquisition Cost  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1998","Net Discount Benefit  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1998","Net Discounted Bad Debt Provision  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1998","Net Best Estimate Liabilities  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR1998","Net Risk Margin  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1998","Net Technical Provisions  1998","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR1999","Gross Claims  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR1999","Gross Expenses  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR1999","Gross Discount Benefit  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR1999","Gross Premium  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR1999","Gross Acquisition Cost  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR1999","Gross Discount Benefit  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC1999","Gross Best Estimate Liabilities  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR1999","Net Claims  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR1999","Net Expenses  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR1999","Net Discount Benefit  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR1999","Net Premium  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR1999","Net Acquisition Cost  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR1999","Net Discount Benefit  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR1999","Net Discounted Bad Debt Provision  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC1999","Net Best Estimate Liabilities  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR1999","Net Risk Margin  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC1999","Net Technical Provisions  1999","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2000","Gross Claims  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2000","Gross Expenses  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2000","Gross Discount Benefit  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2000","Gross Premium  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2000","Gross Acquisition Cost  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2000","Gross Discount Benefit  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2000","Gross Best Estimate Liabilities  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2000","Net Claims  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2000","Net Expenses  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2000","Net Discount Benefit  2000",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A326,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A326,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A326,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A326,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2000","Net Premium  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W327&Y327&Z327","v":""}]
["NetFuturePremAcqCost_PYR2000","Net Acquisition Cost  2000","","","","",null,{"$f":"I328&K328&L328","v":""},null,null,null,null,null,null,{"$f":"P328&R328&S328","v":""},null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2000","Net Discount Benefit  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2000","Net Discounted Bad Debt Provision  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2000","Net Best Estimate Liabilities  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2000","Net Risk Margin  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2000","Net Technical Provisions  2000","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2001","Gross Claims  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2001","Gross Expenses  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2001","Gross Discount Benefit  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2001","Gross Premium  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2001","Gross Acquisition Cost  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2001","Gross Discount Benefit  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2001","Gross Best Estimate Liabilities  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2001","Net Claims  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2001","Net Expenses  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2001","Net Discount Benefit  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2001","Net Premium  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2001","Net Acquisition Cost  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2001","Net Discount Benefit  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2001","Net Discounted Bad Debt Provision  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2001","Net Best Estimate Liabilities  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2001","Net Risk Margin  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2001","Net Technical Provisions  2001","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2002","Gross Claims  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2002","Gross Expenses  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2002","Gross Discount Benefit  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2002","Gross Premium  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2002","Gross Acquisition Cost  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2002","Gross Discount Benefit  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2002","Gross Best Estimate Liabilities  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2002","Net Claims  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2002","Net Expenses  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2002","Net Discount Benefit  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2002","Net Premium  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2002","Net Acquisition Cost  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2002","Net Discount Benefit  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2002","Net Discounted Bad Debt Provision  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2002","Net Best Estimate Liabilities  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2002","Net Risk Margin  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2002","Net Technical Provisions  2002","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2003","Gross Claims  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2003","Gross Expenses  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2003","Gross Discount Benefit  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2003","Gross Premium  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2003","Gross Acquisition Cost  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2003","Gross Discount Benefit  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2003","Gross Best Estimate Liabilities  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2003","Net Claims  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2003","Net Expenses  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2003","Net Discount Benefit  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2003","Net Premium  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2003","Net Acquisition Cost  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2003","Net Discount Benefit  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2003","Net Discounted Bad Debt Provision  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2003","Net Best Estimate Liabilities  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2003","Net Risk Margin  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2003","Net Technical Provisions  2003","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2004","Gross Claims  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2004","Gross Expenses  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2004","Gross Discount Benefit  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2004","Gross Premium  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2004","Gross Acquisition Cost  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2004","Gross Discount Benefit  2004",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A390,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A390,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A390,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A390,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2004","Gross Best Estimate Liabilities  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W391&Y391&Z391","v":""}]
["NetInsLossClaim_PYR2004","Net Claims  2004","","","","",null,{"$f":"I392&K392&L392","v":""},null,null,null,null,null,null,{"$f":"P392&R392&S392","v":""},null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2004","Net Expenses  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2004","Net Discount Benefit  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2004","Net Premium  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2004","Net Acquisition Cost  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2004","Net Discount Benefit  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2004","Net Discounted Bad Debt Provision  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2004","Net Best Estimate Liabilities  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2004","Net Risk Margin  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2004","Net Technical Provisions  2004","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2005","Gross Claims  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2005","Gross Expenses  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2005","Gross Discount Benefit  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2005","Gross Premium  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2005","Gross Acquisition Cost  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2005","Gross Discount Benefit  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2005","Gross Best Estimate Liabilities  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2005","Net Claims  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2005","Net Expenses  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2005","Net Discount Benefit  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2005","Net Premium  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2005","Net Acquisition Cost  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2005","Net Discount Benefit  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2005","Net Discounted Bad Debt Provision  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2005","Net Best Estimate Liabilities  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2005","Net Risk Margin  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2005","Net Technical Provisions  2005","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2006","Gross Claims  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2006","Gross Expenses  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2006","Gross Discount Benefit  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2006","Gross Premium  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2006","Gross Acquisition Cost  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2006","Gross Discount Benefit  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2006","Gross Best Estimate Liabilities  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2006","Net Claims  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2006","Net Expenses  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2006","Net Discount Benefit  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2006","Net Premium  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2006","Net Acquisition Cost  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2006","Net Discount Benefit  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2006","Net Discounted Bad Debt Provision  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2006","Net Best Estimate Liabilities  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2006","Net Risk Margin  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2006","Net Technical Provisions  2006","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2007","Gross Claims  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2007","Gross Expenses  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2007","Gross Discount Benefit  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2007","Gross Premium  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2007","Gross Acquisition Cost  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2007","Gross Discount Benefit  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2007","Gross Best Estimate Liabilities  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2007","Net Claims  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2007","Net Expenses  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2007","Net Discount Benefit  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2007","Net Premium  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2007","Net Acquisition Cost  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2007","Net Discount Benefit  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2007","Net Discounted Bad Debt Provision  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2007","Net Best Estimate Liabilities  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2007","Net Risk Margin  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2007","Net Technical Provisions  2007","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2008","Gross Claims  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2008","Gross Expenses  2008",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A454,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A454,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A454,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A454,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2008","Gross Discount Benefit  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W455&Y455&Z455","v":""}]
["GrFuturePremPrem_PYR2008","Gross Premium  2008","","","","",null,{"$f":"I456&K456&L456","v":""},null,null,null,null,null,null,{"$f":"P456&R456&S456","v":""},null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2008","Gross Acquisition Cost  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2008","Gross Discount Benefit  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2008","Gross Best Estimate Liabilities  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2008","Net Claims  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2008","Net Expenses  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2008","Net Discount Benefit  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2008","Net Premium  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2008","Net Acquisition Cost  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2008","Net Discount Benefit  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2008","Net Discounted Bad Debt Provision  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2008","Net Best Estimate Liabilities  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2008","Net Risk Margin  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2008","Net Technical Provisions  2008","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2009","Gross Claims  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2009","Gross Expenses  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2009","Gross Discount Benefit  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2009","Gross Premium  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2009","Gross Acquisition Cost  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2009","Gross Discount Benefit  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2009","Gross Best Estimate Liabilities  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2009","Net Claims  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2009","Net Expenses  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2009","Net Discount Benefit  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2009","Net Premium  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2009","Net Acquisition Cost  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2009","Net Discount Benefit  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2009","Net Discounted Bad Debt Provision  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2009","Net Best Estimate Liabilities  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2009","Net Risk Margin  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2009","Net Technical Provisions  2009","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2010","Gross Claims  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2010","Gross Expenses  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2010","Gross Discount Benefit  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2010","Gross Premium  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2010","Gross Acquisition Cost  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2010","Gross Discount Benefit  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2010","Gross Best Estimate Liabilities  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2010","Net Claims  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2010","Net Expenses  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2010","Net Discount Benefit  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2010","Net Premium  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2010","Net Acquisition Cost  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2010","Net Discount Benefit  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2010","Net Discounted Bad Debt Provision  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2010","Net Best Estimate Liabilities  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2010","Net Risk Margin  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2010","Net Technical Provisions  2010","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2011","Gross Claims  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2011","Gross Expenses  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2011","Gross Discount Benefit  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2011","Gross Premium  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2011","Gross Acquisition Cost  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2011","Gross Discount Benefit  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2011","Gross Best Estimate Liabilities  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2011","Net Claims  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2011","Net Expenses  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2011","Net Discount Benefit  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2011","Net Premium  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2011","Net Acquisition Cost  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2011","Net Discount Benefit  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2011","Net Discounted Bad Debt Provision  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2011","Net Best Estimate Liabilities  2011",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A518,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A518,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A518,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A518,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2011","Net Risk Margin  2011","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W519&Y519&Z519","v":""}]
["NetTechProv_PYR_LCALC2011","Net Technical Provisions  2011","","","","",null,{"$f":"I520&K520&L520","v":""},null,null,null,null,null,null,{"$f":"P520&R520&S520","v":""},null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2012","Gross Claims  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2012","Gross Expenses  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2012","Gross Discount Benefit  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2012","Gross Premium  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2012","Gross Acquisition Cost  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2012","Gross Discount Benefit  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2012","Gross Best Estimate Liabilities  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2012","Net Claims  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2012","Net Expenses  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2012","Net Discount Benefit  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2012","Net Premium  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2012","Net Acquisition Cost  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2012","Net Discount Benefit  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2012","Net Discounted Bad Debt Provision  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2012","Net Best Estimate Liabilities  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2012","Net Risk Margin  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2012","Net Technical Provisions  2012","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2013","Gross Claims  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2013","Gross Expenses  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2013","Gross Discount Benefit  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2013","Gross Premium  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2013","Gross Acquisition Cost  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2013","Gross Discount Benefit  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2013","Gross Best Estimate Liabilities  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2013","Net Claims  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2013","Net Expenses  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2013","Net Discount Benefit  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2013","Net Premium  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2013","Net Acquisition Cost  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2013","Net Discount Benefit  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2013","Net Discounted Bad Debt Provision  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2013","Net Best Estimate Liabilities  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2013","Net Risk Margin  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2013","Net Technical Provisions  2013","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2014","Gross Claims  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossExpense_PYR2014","Gross Expenses  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2014","Gross Discount Benefit  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2014","Gross Premium  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2014","Gross Acquisition Cost  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2014","Gross Discount Benefit  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2014","Gross Best Estimate Liabilities  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2014","Net Claims  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2014","Net Expenses  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2014","Net Discount Benefit  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2014","Net Premium  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2014","Net Acquisition Cost  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremDiscBenefit_PYR2014","Net Discount Benefit  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2014","Net Discounted Bad Debt Provision  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2014","Net Best Estimate Liabilities  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2014","Net Risk Margin  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2014","Net Technical Provisions  2014","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossClaim_PYR2015","Gross Claims  2015","","","","",null,{"$f":"I572&K572&L572","v":""},null,null,null,null,null,null,{"$f":"P572&R572&S572","v":""},null,null,null,null,null,null,{"$f":"W572&Y572&Z572","v":""}]
["GrInsLossExpense_PYR2015","Gross Expenses  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrInsLossDiscBenefit_PYR2015","Gross Discount Benefit  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremPrem_PYR2015","Gross Premium  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremAcqCost_PYR2015","Gross Acquisition Cost  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrFuturePremDiscBenefit_PYR2015","Gross Discount Benefit  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["GrBestEstLiabilities_PYR_LCALC2015","Gross Best Estimate Liabilities  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossClaim_PYR2015","Net Claims  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossExpense_PYR2015","Net Expenses  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetInsLossDiscBenefit_PYR2015","Net Discount Benefit  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremPrem_PYR2015","Net Premium  2015",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A582,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A582,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A582,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A582,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetFuturePremAcqCost_PYR2015","Net Acquisition Cost  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W583&Y583&Z583","v":""}]
["NetFuturePremDiscBenefit_PYR2015","Net Discount Benefit  2015","","","","",null,{"$f":"I584&K584&L584","v":""},null,null,null,null,null,null,{"$f":"P584&R584&S584","v":""},null,null,null,null,null,null,""]
["NetDiscBadDebtProv_PYR2015","Net Discounted Bad Debt Provision  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetBestEstLiabilities_PYR_LCALC2015","Net Best Estimate Liabilities  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetRiskMargin_PYR2015","Net Risk Margin  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["NetTechProv_PYR_LCALC2015","Net Technical Provisions  2015","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 2 - ULO & Totals",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrInsLossClaim","Gross  Claims ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A591,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A591,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A591,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A591,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrInsLossExpense","Gross  Expenses ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrInsLossDiscBenefit","Gross  Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrFutPremPrem","Gross  Premium ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrFutPremAcqCost","Gross  Acquisition Cost ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrFutPremDiscBenefit","Gross  Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrGrBestEstLiab_LCALC"," Gross Best Estimate Liabilities ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetInsLossClaim","Net  Claims ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetInsLossExpense","Net  Expenses ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetInsLossDiscBenefit","Net  Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetFutPremPrem","Net  Premium ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetFutPremAcqCost","Net  Acquisition Cost ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetFutPremDiscBenefit","Net  Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetDiscBadDebtProv"," Net Discounted Bad Debt Provision ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetBestEstLiab_LCALC"," Net Best Estimate Liabilities ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetRiskMargin"," Net Risk Margin ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UninceptedLglObligPropYrNetTechProv_LCALC"," Net Technical Provisions ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrInsLossClaim_LCALC","Gross Total Claims ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrInsLossExpense_LCALC","Gross Total Expenses ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrInsLossDiscBenefit_LCALC","Gross Total Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrFuturePremPrem_LCALC","Gross Total Premium ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrFuturePremAcqCost_LCALC","Gross Total Acquisition Cost ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrFuturePremDiscBenefit_LCALC","Gross Total Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalGrBestEstLiabilities_LCALC","Total Gross Best Estimate Liabilities ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetInsLossClaim_LCALC","Net Total Claims ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetInsLossExpense_LCALC","Net Total Expenses ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetInsLossDiscBenefit_LCALC","Net Total Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetFuturePremPrem_LCALC","Net Total Premium ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetFuturePremAcqCost_LCALC","Net Total Acquisition Cost ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetFuturePremDiscBenefit_LCALC","Net Total Discount Benefit ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetDiscBadDebtProv_LCALC","Total Net Discounted Bad Debt Provision ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetBestEstLiabilities_LCALC","Total Net Best Estimate Liabilities ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetRiskMargin_LCALC","Total Net Risk Margin ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalNetTechProv_LCALC","Total Net Technical Provisions ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,{"$f":"\"s\"&Synd&\" FORM 313\"","v":"s FORM 313"},null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 1",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ProposedYoaPlanPremGross","Proposed YOA planned premium Gross ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A629,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A629,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A629,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A629,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ProposedYoaPlanPremAcqCost","Proposed YOA planned premium Acquisition Costs ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ProposedYoaPlanPremRiShare","Proposed YOA planned premium RI Share ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ProposedYoaPlanPremNet_LCALC","Proposed YOA planned premium Net ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CurrentYoaPlanPremGross","Current YOA planned premium Gross ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CurrentYoaPlanPremAcqCost","Current YOA planned premium Acquisition Costs ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CurrentYoaPlanPremRiShare","Current YOA planned premium RI Share ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CurrentYoaPlanPremNet_LCALC","Current YOA planned premium Net ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 2",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AvgClaimsDisc","Average claims tail used for discounting ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A639,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A639,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A639,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A639,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AssmUsdXrate","Assumed USD exchange rate ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A640,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A640,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A640,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A640,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 3",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossTotal_OneYr_NetMean_LCALC","One-Year total: Net Mean ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A643,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A643,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A643,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A643,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversificationCredit_OneYr_NetMean","One-Year Diversification Credit - Between Risk Categories Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_OneYr_NetMean_LCALC","One-Year TOTAL Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossTotal_OneYr_Net99Pt5th","One-Year total: Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversificationCredit_OneYr_Net99Pt5th","One-Year Diversification Credit - Between Risk Categories Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W647&Y647&Z647","v":""}]
["Total_OneYr_Net99Pt5th_LCALC","One-Year TOTAL Net 99.5th ","","","","",null,{"$f":"I648&K648&L648","v":""},null,null,null,null,null,null,{"$f":"P648&R648&S648","v":""},null,null,null,null,null,null,""]
["CatLossTotal_Ult_NetMean_LCALC","Ultimate total: Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversificationCredit_Ult_NetMean","Ultimate Diversification Credit - Between Risk Categories Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_Ult_NetMean_LCALC","Ultimate TOTAL Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossTotal_Ult_Net99Pt5th","Ultimate total: Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversificationCredit_Ult_Net99Pt5th","Ultimate Diversification Credit - Between Risk Categories Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["Total_Ult_Net99Pt5th_LCALC","Ultimate TOTAL Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossLcm_OneYr_NetMean","One-Year split: Catastrophe Losses - LCM Region-Perils & Classes Only Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossLcm_OneYr_Net99Pt5th","One-Year split: Catastrophe Losses - LCM Region-Perils & Classes Only Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossLcm_Ult_NetMean","Ultimate split: Catastrophe Losses - LCM Region-Perils & Classes Only Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossLcm_Ult_Net99Pt5th","Ultimate split: Catastrophe Losses - LCM Region-Perils & Classes Only Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossNonLcm_OneYr_NetMean","One-Year split: Catastrophe Losses - All Non-LCM Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossNonLcm_OneYr_Net99Pt5th","One-Year split: Catastrophe Losses - All Non-LCM Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossNonLcm_Ult_NetMean","Ultimate split: Catastrophe Losses - All Non-LCM Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CatLossNonLcm_Ult_Net99Pt5th","Ultimate split: Catastrophe Losses - All Non-LCM Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumRiskClaimExclCat_OneYr_NetMean","One-Year Premium Risk Claims - Excluding Catastrophe Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumRiskClaimExclCat_OneYr_Net99Pt5th","One-Year Premium Risk Claims - Excluding Catastrophe Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumRiskClaimExclCat_Ult_NetMean","Ultimate Premium Risk Claims - Excluding Catastrophe Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["PremiumRiskClaimExclCat_Ult_Net99Pt5th","Ultimate Premium Risk Claims - Excluding Catastrophe Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReservingRiskClaim_OneYr_NetMean","One-Year Reserving Risk Claims Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReservingRiskClaim_OneYr_Net99Pt5th","One-Year Reserving Risk Claims Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReservingRiskClaim_Ult_NetMean","Ultimate Reserving Risk Claims Net Mean ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ReservingRiskClaim_Ult_Net99Pt5th","Ultimate Reserving Risk Claims Net 99.5th ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["LcmVsScr","LcmVsScr","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["LcrDocAttached","LcrDocAttached","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,{"$f":"\"s\"&Synd&\" FORM 314\"","v":"s FORM 314"},null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 1",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRisk_MeanOut_LCALC","total: Mean Outcome ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A676,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A676,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A676,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A676,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRisk_Stress_LCALC","total: Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRisk_1200Con_LCALC","total: 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRiskPremRisk_MeanOut","split: Premium Risk Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRiskPremRisk_Stress_LCALC","split: Premium Risk Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRiskPremRisk_1200Con_LCALC","split: Premium Risk 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRiskResRisk_MeanOut","split: Reserve Risk Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRiskResRisk_Stress_LCALC","split: Reserve Risk Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InsuranceRiskResRisk_1200Con_LCALC","split: Reserve Risk 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InvestmentRetRisk_MeanOut","Investment Return & Risk Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InvestmentRetRisk_Stress_LCALC","Investment Return & Risk Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["InvestmentRetRisk_1200Con","Investment Return & Risk 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AllOther_MeanOut","All Other Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AllOther_Stress_LCALC","All Other Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AllOther_1200Con_LCALC","All Other 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotExpectRet_MeanOut_LCALC","TOTAL EXPECTED RETURN Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 2",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["IntRateRisk_MeanOut","Interest Rate Risk (including interest rate risk on liabilities) Mean Outcome ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A694,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A694,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A694,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A694,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["IntRateRisk_Stress_LCALC","Interest Rate Risk (including interest rate risk on liabilities) Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["IntRateRisk_1200Con","Interest Rate Risk (including interest rate risk on liabilities) 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRisk_MeanOut","Credit Risk (on assets only) Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRisk_Stress_LCALC","Credit Risk (on assets only) Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["CreditRisk_1200Con","Credit Risk (on assets only) 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["EquityOthAssetRisk_MeanOut","Equity and Other Asset Risk (on assets only) Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["EquityOthAssetRisk_Stress_LCALC","Equity and Other Asset Risk (on assets only) Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["EquityOthAssetRisk_1200Con","Equity and Other Asset Risk (on assets only) 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["LiquidityRisk_MeanOut","Liquidity Risk Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["LiquidityRisk_Stress_LCALC","Liquidity Risk Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["LiquidityRisk_1200Con","Liquidity Risk 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ForeignExchRisk_MeanOut","Foreign Exchange Risk (including fx risk on liabilities) Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ForeignExchRisk_Stress_LCALC","Foreign Exchange Risk (including fx risk on liabilities) Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ForeignExchRisk_1200Con","Foreign Exchange Risk (including fx risk on liabilities) 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OtherRisks_MeanOut","Other Risks Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OtherRisks_Stress_LCALC","Other Risks Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OtherRisks_1200Con","Other Risks 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W711&Y711&Z711","v":""}]
["TotalMarketRisk_MeanOut_LCALC","TOTAL Mean Outcome ","","","","",null,{"$f":"I712&K712&L712","v":""},null,null,null,null,null,null,{"$f":"P712&R712&S712","v":""},null,null,null,null,null,null,""]
["TotalMarketRisk_Stress_LCALC","TOTAL Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["TotalMarketRisk_1200Con_LCALC","TOTAL 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedCredit_Stress_LCALC","Diversification Credit Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedCredit_1200Con","Diversification Credit 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotalMarketRisk_MeanOut_LCALC","DIVERSIFIED TOTAL Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotalMarketRisk_Stress_LCALC","DIVERSIFIED TOTAL Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotalMarketRisk_1200Con_LCALC","DIVERSIFIED TOTAL 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,"Table 3",null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OneYrSCR_MeanOut","One-Year SCR Mean Outcome ",{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($L$6,\"0000\"),IFERROR(VLOOKUP($A722,file_1,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($S$6,\"0000\"),IFERROR(VLOOKUP($A722,file_2,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($Z$6,\"0000\"),IFERROR(VLOOKUP($A722,file_3,3,0),\"\"),\"\")","v":""},{"$f":"IF(TEXT($B$6,\"0000\")=TEXT($AG$6,\"0000\"),IFERROR(VLOOKUP($A722,file_4,3,0),\"\"),\"\")","v":""},null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OneYrSCR_Stress_LCALC","One-Year SCR Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OneYrSCR_1200Con","One-Year SCR 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["RemovalPY1UninceptContracts_MeanOut","Removal of PY+1 Unincepted Contracts Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["RemovalPY1UninceptContracts_1200Con_LCALC","Removal of PY+1 Unincepted Contracts 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AddPYPriorYrBinderBus_MeanOut","Additional PY & Prior Years Binder Business Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AddPYPriorYrBinderBus_Stress_LCALC","Additional PY & Prior Years Binder Business Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["AddPYPriorYrBinderBus_1200Con","Additional PY & Prior Years Binder Business 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ChangeRiskMarginT0toT1_MeanOut","Change in Risk Margin from T0 to T1 Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["ChangeRiskMarginT0toT1_1200Con","Change in Risk Margin from T0 to T1 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["RunDownOpenRiskMargin_MeanOut","Run Down Opening Risk Margin from B/S at T0 to Nil at Ultimate Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["RunDownOpenRiskMargin_1200Con_LCALC","Run Down Opening Risk Margin from B/S at T0 to Nil at Ultimate 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UnexpBusPYPriorYr_Stress_LCALC","Unexpired Business on PY & Prior Years Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UnexpBusPYPriorYr_1200Con","Unexpired Business on PY & Prior Years 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UltVolLessOneYrVol_Stress_LCALC","Ultimate Volatilities Less One-Year Volatilities Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["UltVolLessOneYrVol_1200Con","Ultimate Volatilities Less One-Year Volatilities 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["SCRReconciliationOther_MeanOut","Other Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["SCRReconciliationOther_Stress_LCALC","Other Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["SCRReconciliationOther_1200Con","Other 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["SCRReconciliationTotal_MeanOut_LCALC","TOTAL Mean Outcome ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["SCRReconciliationTotal_Stress_LCALC","TOTAL Stress ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["SCRReconciliationTotal_1200Con_LCALC","TOTAL 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["OneYrDivCreditUltDivCredit_1200Con","One-Year Diversification Credit less Ultimate Diversification Credit 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
["DiversifiedTotalSCRReconciliation_1200Con_LCALC","DIVERSIFIED TOTAL 1:200 Confidence ","","","","",null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W775&Y775&Z775","v":""}]
[null,null,null,null,null,null,null,{"$f":"I776&K776&L776","v":""},null,null,null,null,null,null,{"$f":"P776&R776&S776","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W839&Y839&Z839","v":""}]
[null,null,null,null,null,null,null,{"$f":"I840&K840&L840","v":""},null,null,null,null,null,null,{"$f":"P840&R840&S840","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W903&Y903&Z903","v":""}]
[null,null,null,null,null,null,null,{"$f":"I904&K904&L904","v":""},null,null,null,null,null,null,{"$f":"P904&R904&S904","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"W967&Y967&Z967","v":""}]
[null,null,null,null,null,null,null,{"$f":"I968&K968&L968","v":""},null,null,null,null,null,null,{"$f":"P968&R968&S968","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,null,null,null,""]