{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Dashboard","Historical Protection gap","Exposure_Hazard","Vulnerability","Insurance coverage","GDP","Country area"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,7]]}
["INTRODUCTION"]
[]
[]
[null,"Pilot dashboard on protection gap for natural catatrophes*"]
[]
[null,"Measure of the protection gap in Europe:"]
[null,"- historical protection gap: based on differences observed between economic and insured historical losses"]
[null,"- estimate of today's protection gap: derived by combining the hazard, vulnerability, exposure and insurance coverage"]
[]
[null,"2 views:"]
[]
[null,"-Dashboard "]
[null,"Tab \"Dashboard\""]
[]
[null,"2. Statistics"]
[null,"Tab \"Summary statistics\""]
[]
[null,"3. Map view"]
[null,"Tab \"Map view\""]
[]
[null,"-Underlying data","Overview of sources"]
[null,"Tab \"Historical protection gap\"","MunichRe and Swiss Re"]
[null,"Tab \"Exposure_Hazard\"","Risk Data Hub, ESPON and WISC data"]
[null,"Tab \"Vulnerability\"","Academic data"]
[null,"Tab \"Insurance coverage\"","Expert judgement and EIOPA data"]
[null,"GDP"]
[null,"Country area"]
[]
[null,"Additional documentation available:"]
[null,"Pilot dashboard on the insurance protection gap for natural catastrophes: Technical description"]
[null,"Pilot dashboard on insurance protection gap for natural catastrophes in a nutshell"]
[]
[null,"*EIOPA acknowledges the limitations of the pilot version of the dashboard, which was developed, based on publicly available data and expert judgement. The main goal of the pilot dashboard is to establish a framework for identifying key risk drivers for the protection gap for natural catastrophes and for collecting relevant evidence and data. The methodology for deriving the relevant scoring, as well as the existence of data gaps will be subject to review and will be updated based on further evidence and discussion in the future. Views from stakeholders on the methodology, data used in the dashboard are welcome until 31st of March 2020 using the EU survey. Questions on the dashboard are also welcome to be sent to protection_gap_dashboard@eiopa.europa.eu.\n"]

{"sheet":"Dashboard","index":1,"n_rows":37,"n_cols":34,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,4,3,9],[3,11,3,16],[3,18,3,23],[3,25,3,30],[3,1,3,2]]}
["DASHBOARD"]
[]
[null,"Historical Protection gap","Estimate of protection gap today",null,"Historical Protection gap",null,"Estimate of protection gap today","Exposure to hazard","Vulnerability","Insurance coverage",null,"Historical Protection gap",null,"Estimate of protection gap today","Exposure to hazard","Vulnerability","Insurance coverage",null,"Historical Protection gap",null,"Estimate of protection gap today","Exposure to hazard","Vulnerability","Insurance coverage",null,"Historical Protection gap",null,"Estimate of protection gap today","Exposure to hazard","Vulnerability","Insurance coverage"]
["COUNTRY","All Peril",null,null,"Earthquake",null,null,null,null,null,null," Flood",null,null,null,null,null,null,"Wildfire",null,null,null,null,null,null,"Windstorm"]
["EU",{"$f":"MROUND((Z5+S5+L5+E5)/4,0.1)","v":1.4000000000000001},{"$f":"MROUND((AB5+U5+N5+G5)/4,1)","v":1},null,{"$f":"MROUND(AVERAGE(E6:E35),0.1)","v":0.9},null,{"$f":"MROUND(AVERAGE(G6:G35),1)","v":1},{"$f":"MROUND(AVERAGE(H6:H35),1)","v":1},{"$f":"MROUND(AVERAGE(I6:I35),1)","v":4},{"$f":"MROUND(AVERAGE(J6:J35),1)","v":3},null,{"$f":"MROUND(AVERAGE(L6:L35),0.1)","v":1.5},null,{"$f":"MROUND(AVERAGE(N6:N35),1)","v":1},{"$f":"MROUND(AVERAGE(O6:O35),1)","v":2},"n/a",{"$f":"MROUND(AVERAGE(Q6:Q35),1)","v":2},null,{"$f":"MROUND(AVERAGE(S6:S35),0.1)","v":1.7000000000000002},null,{"$f":"MROUND(AVERAGE(U6:U35),0.1)","v":1.6},{"$f":"MROUND(AVERAGE(V6:V35),1)","v":2},"n/a",{"$f":"MROUND(AVERAGE(X6:X35),1)","v":3},null,{"$f":"MROUND(AVERAGE(Z6:Z35),0.1)","v":1.4000000000000001},null,{"$f":"MROUND(AVERAGE(AB6:AB35),1)","v":1},{"$f":"MROUND(AVERAGE(AC6:AC35),1)","v":2},{"$f":"MROUND(AVERAGE(AD6:AD35),1)","v":2},{"$f":"MROUND(AVERAGE(AE6:AE35),1)","v":1}]
["Austria",{"$f":"MROUND((Z6+S6+L6+E6)/4,0.1)","v":1.5},{"$f":"MROUND((AB6+U6+N6+G6)/4,0.1)","v":2},null,{"$f":"VLOOKUP(A6,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,{"$f":"IF((AND(ISNUMBER(I6),ISNUMBER(J6))),MROUND((H6)^(1.5/3)*I6^(0.5/3)*J6^(1/3),0.1),IF(ISNUMBER(I6),MROUND((H6)^(1.5/2)*I6^(0.5/2),0.1),MROUND((H6)^(1.5/2.5)*J6^(1/2.5),0.1)))","v":1.8},{"$f":"IFERROR(VLOOKUP(A6,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A6,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A6,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A6,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,{"$f":"IF((AND(ISNUMBER(P6),ISNUMBER(Q6))),MROUND((O6)^(1.5/3)*P6^(0.5/3)*Q6^(1/3),0.1),IF(ISNUMBER(P6),MROUND((O6)^(1.5/2)*P6^(0.5/2),0.1),MROUND((O6)^(1.5/2.5)*Q6^(1/2.5),0.1)))","v":3.4000000000000004},{"$f":"IFERROR(VLOOKUP(A6,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A6,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A6,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,{"$f":"IF((AND(ISNUMBER(W6),ISNUMBER(X6))),MROUND((V6)^(1.5/3)*W6^(0.5/3)*X6^(1/3),0.1),IF(ISNUMBER(W6),MROUND((V6)^(1.5/2)*W6^(0.5/2),0.1),MROUND((V6)^(1.5/2.5)*X6^(1/2.5),0.1)))","v":2.6},{"$f":"IFERROR(VLOOKUP(A6,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A6,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A6,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,{"$f":"IF((AND(ISNUMBER(AD6),ISNUMBER(AE6))),MROUND((AC6)^(1.5/3)*AD6^(0.5/3)*AE6^(1/3),0.1),IF(ISNUMBER(AD6),MROUND((AC6)^(1.5/2)*AD6^(0.5/2),0.1),MROUND((AC6)^(1.5/2.5)*AE6^(1/2.5),0.1)))","v":0},{"$f":"IFERROR(VLOOKUP(A6,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A6,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A6,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":0},null,0,"no risk"]
["Belgium",{"$f":"MROUND((Z7+S7+L7+E7)/4,0.1)","v":1},{"$f":"MROUND((AB7+U7+N7+G7)/4,0.1)","v":1.7000000000000002},null,{"$f":"VLOOKUP(A7,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,{"$f":"IF((AND(ISNUMBER(I7),ISNUMBER(J7))),MROUND((H7)^(1.5/3)*I7^(0.5/3)*J7^(1/3),0.1),IF(ISNUMBER(I7),MROUND((H7)^(1.5/2)*I7^(0.5/2),0.1),MROUND((H7)^(1.5/2.5)*J7^(1/2.5),0.1)))","v":1.3},{"$f":"IFERROR(VLOOKUP(A7,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A7,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A7,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A7,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,{"$f":"IF((AND(ISNUMBER(P7),ISNUMBER(Q7))),MROUND((O7)^(1.5/3)*P7^(0.5/3)*Q7^(1/3),0.1),IF(ISNUMBER(P7),MROUND((O7)^(1.5/2)*P7^(0.5/2),0.1),MROUND((O7)^(1.5/2.5)*Q7^(1/2.5),0.1)))","v":1.9000000000000001},{"$f":"IFERROR(VLOOKUP(A7,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A7,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A7,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A7,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A7,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A7,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,{"$f":"IF((AND(ISNUMBER(AD7),ISNUMBER(AE7))),MROUND((AC7)^(1.5/3)*AD7^(0.5/3)*AE7^(1/3),0.1),IF(ISNUMBER(AD7),MROUND((AC7)^(1.5/2)*AD7^(0.5/2),0.1),MROUND((AC7)^(1.5/2.5)*AE7^(1/2.5),0.1)))","v":1.6},{"$f":"IFERROR(VLOOKUP(A7,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A7,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A7,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1},null,1,"low risk"]
["Bulgaria",1.8,2,null,{"$f":"VLOOKUP(A8,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,3.2,{"$f":"IFERROR(VLOOKUP(A8,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A8,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A8,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A8,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":3},null,1.7000000000000002,{"$f":"IFERROR(VLOOKUP(A8,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A8,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A8,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,{"$f":"IF((AND(ISNUMBER(W8),ISNUMBER(X8))),MROUND((V8)^(1.5/3)*W8^(0.5/3)*X8^(1/3),1),IF(ISNUMBER(W8),MROUND((V8)^(1.5/2)*W8^(0.5/2),1),MROUND((V8)^(1.5/2.5)*X8^(1/2.5),1)))","v":2},{"$f":"IFERROR(VLOOKUP(A8,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A8,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A8,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.2000000000000002,{"$f":"IFERROR(VLOOKUP(A8,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A8,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A8,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"},null,2,"low/medium risk"]
["Croatia",2.3000000000000003,2.4000000000000004,null,{"$f":"VLOOKUP(A9,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":2},null,2.8000000000000003,{"$f":"IFERROR(VLOOKUP(A9,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A9,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A9,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A9,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":3},null,2,{"$f":"IFERROR(VLOOKUP(A9,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A9,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":2},null,{"$f":"VLOOKUP(A9,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":3},null,3,{"$f":"IFERROR(VLOOKUP(A9,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A9,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A9,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.6,{"$f":"IFERROR(VLOOKUP(A9,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A9,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A9,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":3},null,3,"medium/high risk"]
["Cyprus",1.3,1.9000000000000001,null,{"$f":"VLOOKUP(A10,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,2.5,{"$f":"IFERROR(VLOOKUP(A10,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A10,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A10,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A10,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A10,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A10,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A10,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,3,{"$f":"IFERROR(VLOOKUP(A10,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A10,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A10,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A10,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A10,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A10,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"},null,4,"high risk"]
["Czech Republic",1.8,1.9000000000000001,null,{"$f":"VLOOKUP(A11,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,1.8,{"$f":"IFERROR(VLOOKUP(A11,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A11,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A11,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A11,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":3},null,2,{"$f":"IFERROR(VLOOKUP(A11,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A11,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":2},null,{"$f":"VLOOKUP(A11,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,2,{"$f":"IFERROR(VLOOKUP(A11,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A11,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A11,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.6,{"$f":"IFERROR(VLOOKUP(A11,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A11,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A11,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1},null,"n/a","not available"]
["Denmark",1.5,0,null,{"$f":"VLOOKUP(A12,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A12,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A12,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A12,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A12,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A12,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A12,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A12,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,0,{"$f":"IFERROR(VLOOKUP(A12,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A12,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A12,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,0,{"$f":"IFERROR(VLOOKUP(A12,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A12,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A12,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":0}]
["Estonia",0.5,1.1000000000000001,null,{"$f":"VLOOKUP(A13,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A13,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A13,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A13,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A13,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A13,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A13,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A13,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,3,{"$f":"IFERROR(VLOOKUP(A13,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A13,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A13,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.5,{"$f":"IFERROR(VLOOKUP(A13,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A13,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A13,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Finland",1,0.70000000000000007,null,{"$f":"VLOOKUP(A14,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A14,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A14,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A14,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A14,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A14,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A14,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A14,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,0,{"$f":"IFERROR(VLOOKUP(A14,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A14,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A14,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.8,{"$f":"IFERROR(VLOOKUP(A14,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A14,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A14,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["France",1.3,0.5,null,{"$f":"VLOOKUP(A15,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A15,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A15,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A15,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A15,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A15,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A15,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A15,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A15,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A15,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A15,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,0,{"$f":"IFERROR(VLOOKUP(A15,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A15,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A15,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":0}]
["Germany",1.5,1.6,null,{"$f":"VLOOKUP(A16,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,1.6,{"$f":"IFERROR(VLOOKUP(A16,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A16,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A16,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":2},null,{"$f":"VLOOKUP(A16,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,2.6,{"$f":"IFERROR(VLOOKUP(A16,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A16,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":2},null,{"$f":"VLOOKUP(A16,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A16,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A16,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":2},null,{"$f":"VLOOKUP(A16,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.1000000000000001,{"$f":"IFERROR(VLOOKUP(A16,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A16,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A16,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Greece",2.8000000000000003,2.2000000000000002,null,{"$f":"VLOOKUP(A17,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":4},null,3.5,{"$f":"IFERROR(VLOOKUP(A17,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A17,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A17,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A17,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,1.7000000000000002,{"$f":"IFERROR(VLOOKUP(A17,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A17,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A17,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":3},null,2,{"$f":"IFERROR(VLOOKUP(A17,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A17,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A17,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.6,{"$f":"IFERROR(VLOOKUP(A17,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A17,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A17,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":4}]
["Hungary",1.8,1.3,null,{"$f":"VLOOKUP(A18,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,1.3,{"$f":"IFERROR(VLOOKUP(A18,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A18,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A18,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A18,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,1.9000000000000001,{"$f":"IFERROR(VLOOKUP(A18,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A18,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A18,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":3},null,1,{"$f":"IFERROR(VLOOKUP(A18,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A18,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A18,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.1000000000000001,{"$f":"IFERROR(VLOOKUP(A18,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A18,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A18,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Iceland",1,1,null,{"$f":"VLOOKUP(A19,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":2},null,1,{"$f":"IFERROR(VLOOKUP(A19,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A19,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A19,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A19,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A19,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A19,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A19,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":0},null,"n/a",{"$f":"IFERROR(VLOOKUP(A19,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":"n/a"},"n/a",{"$f":"IFERROR(VLOOKUP(A19,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A19,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A19,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A19,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A19,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Ireland",0.8,0.70000000000000007,null,{"$f":"VLOOKUP(A20,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A20,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A20,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A20,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A20,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A20,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A20,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A20,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A20,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A20,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A20,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.9000000000000001,{"$f":"IFERROR(VLOOKUP(A20,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A20,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A20,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Italy",2,2.4000000000000004,null,{"$f":"VLOOKUP(A21,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":3},null,3.5,{"$f":"IFERROR(VLOOKUP(A21,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A21,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A21,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A21,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,1.7000000000000002,{"$f":"IFERROR(VLOOKUP(A21,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A21,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A21,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,2,{"$f":"IFERROR(VLOOKUP(A21,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A21,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A21,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,2.5,{"$f":"IFERROR(VLOOKUP(A21,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A21,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A21,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":4}]
["Latvia",1.3,{"$f":"MROUND((AB22+U22+N22+G22)/4,0.1)","v":0.9},null,{"$f":"VLOOKUP(A22,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A22,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A22,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A22,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A22,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A22,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A22,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A22,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,1,{"$f":"IFERROR(VLOOKUP(A22,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A22,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A22,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.7000000000000002,{"$f":"IFERROR(VLOOKUP(A22,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A22,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A22,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Lithuania",1,1.3,null,{"$f":"VLOOKUP(A23,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A23,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A23,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A23,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A23,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1,{"$f":"IFERROR(VLOOKUP(A23,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A23,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A23,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,2,{"$f":"IFERROR(VLOOKUP(A23,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A23,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A23,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A23,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A23,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A23,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Liechtenstein","n/a","n/a",null,{"$f":"VLOOKUP(A24,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":"n/a"},null,"n/a",{"$f":"IFERROR(VLOOKUP(A24,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A24,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A24,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A24,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":"n/a"},null,"n/a",{"$f":"IFERROR(VLOOKUP(A24,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":"n/a"},"n/a",{"$f":"IFERROR(VLOOKUP(A24,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A24,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":"n/a"},null,"n/a",{"$f":"IFERROR(VLOOKUP(A24,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":"n/a"},"n/a",{"$f":"IFERROR(VLOOKUP(A24,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A24,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":"n/a"},null,"n/a",{"$f":"IFERROR(VLOOKUP(A24,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A24,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP(A24,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Luxembourg",1,1.6,null,{"$f":"VLOOKUP(A25,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,{"$f":"IF((AND(ISNUMBER(I25),ISNUMBER(J25))),MROUND((H25)^(1.5/3)*I25^(0.5/3)*J25^(1/3),0.1),IF(ISNUMBER(I25),MROUND((H25)^(1.5/2)*I25^(0.5/2),0.1),MROUND((H25)^(1.5/2.5)*J25^(1/2.5),0.1)))","v":1.3},{"$f":"IFERROR(VLOOKUP(A25,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A25,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A25,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A25,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A25,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A25,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A25,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A25,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A25,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A25,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.1000000000000001,{"$f":"IFERROR(VLOOKUP(A25,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A25,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A25,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Malta",0.5,2.3000000000000003,null,{"$f":"VLOOKUP(A26,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,2.8000000000000003,{"$f":"IFERROR(VLOOKUP(A26,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A26,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A26,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A26,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1.7000000000000002,{"$f":"IFERROR(VLOOKUP(A26,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A26,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A26,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":0},null,3,{"$f":"IFERROR(VLOOKUP(A26,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A26,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A26,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.6,{"$f":"IFERROR(VLOOKUP(A26,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A26,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A26,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":4}]
["Netherlands",1,1.9000000000000001,null,{"$f":"VLOOKUP(A27,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A27,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A27,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A27,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A27,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,4,{"$f":"IFERROR(VLOOKUP(A27,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":4},"n/a",{"$f":"IFERROR(VLOOKUP(A27,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A27,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A27,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A27,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A27,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.6,{"$f":"IFERROR(VLOOKUP(A27,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A27,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A27,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Norway",1,0,null,{"$f":"VLOOKUP(A28,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A28,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A28,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A28,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A28,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A28,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A28,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A28,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A28,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A28,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A28,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A28,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A28,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A28,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":0}]
["Poland",1.5,1.6,null,{"$f":"VLOOKUP(A29,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,2,{"$f":"IFERROR(VLOOKUP(A29,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A29,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A29,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A29,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,1,{"$f":"IFERROR(VLOOKUP(A29,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A29,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":1},null,{"$f":"VLOOKUP(A29,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,1,{"$f":"IFERROR(VLOOKUP(A29,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A29,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A29,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,2.3000000000000003,{"$f":"IFERROR(VLOOKUP(A29,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A29,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A29,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Portugal",1.5,2,null,{"$f":"VLOOKUP(A30,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,1.8,{"$f":"IFERROR(VLOOKUP(A30,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A30,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A30,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A30,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,1.6,{"$f":"IFERROR(VLOOKUP(A30,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A30,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A30,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":3},null,3,{"$f":"IFERROR(VLOOKUP(A30,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A30,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A30,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.7000000000000002,{"$f":"IFERROR(VLOOKUP(A30,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A30,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A30,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Romania",1.8,1.7000000000000002,null,{"$f":"VLOOKUP(A31,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,3.1,{"$f":"IFERROR(VLOOKUP(A31,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A31,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A31,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A31,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,1.6,{"$f":"IFERROR(VLOOKUP(A31,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A31,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A31,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":3},null,1,{"$f":"IFERROR(VLOOKUP(A31,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A31,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A31,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.2000000000000002,{"$f":"IFERROR(VLOOKUP(A31,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A31,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A31,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Slovakia",1.3,2.4000000000000004,null,{"$f":"VLOOKUP(A32,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,1.9000000000000001,{"$f":"IFERROR(VLOOKUP(A32,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A32,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A32,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A32,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,3,{"$f":"IFERROR(VLOOKUP(A32,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":3},"n/a",{"$f":"IFERROR(VLOOKUP(A32,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":3},null,{"$f":"VLOOKUP(A32,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,3,{"$f":"IFERROR(VLOOKUP(A32,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A32,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":4},null,{"$f":"VLOOKUP(A32,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.6,{"$f":"IFERROR(VLOOKUP(A32,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A32,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A32,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":3}]
["Slovenia",1.8,1.5,null,{"$f":"VLOOKUP(A33,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,2.4000000000000004,{"$f":"IFERROR(VLOOKUP(A33,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A33,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A33,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A33,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":2},null,1.3,{"$f":"IFERROR(VLOOKUP(A33,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A33,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":2},null,{"$f":"VLOOKUP(A33,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,1,{"$f":"IFERROR(VLOOKUP(A33,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A33,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A33,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.2000000000000002,{"$f":"IFERROR(VLOOKUP(A33,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A33,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A33,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":"n/a"}]
["Spain",1.3,0.9,null,{"$f":"VLOOKUP(A34,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A34,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A34,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":4},{"$f":"IFERROR(VLOOKUP(A34,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A34,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A34,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A34,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A34,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":2},null,2,{"$f":"IFERROR(VLOOKUP(A34,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":2},"n/a",{"$f":"IFERROR(VLOOKUP(A34,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":"n/a"},null,{"$f":"VLOOKUP(A34,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":1},null,1.4000000000000001,{"$f":"IFERROR(VLOOKUP(A34,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A34,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":1},{"$f":"IFERROR(VLOOKUP(A34,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
["Sweden",1,0.4,null,{"$f":"VLOOKUP(A35,'Historical Protection gap'!$A$17:$AC$47,8,FALSE)","v":0},null,0,{"$f":"IFERROR(VLOOKUP(A35,Exposure_Hazard!B$17:Q$47,7,FALSE),\"n/a\")","v":0},{"$f":"IFERROR(VLOOKUP(A35,Vulnerability!A$17:F$47,6,FALSE),\"n/a\")","v":3},{"$f":"IFERROR(VLOOKUP(A35,'Insurance coverage'!B$18:AD$47,7,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A35,'Historical Protection gap'!$A$17:$AC$47,15,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A35,Exposure_Hazard!B$17:Q$47,11,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A35,'Insurance coverage'!B$18:AD$47,14,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A35,'Historical Protection gap'!$A$17:$AC$47,22,FALSE)","v":1},null,0,{"$f":"IFERROR(VLOOKUP(A35,Exposure_Hazard!B$17:T$47,15,FALSE),\"n/a\")","v":1},"n/a",{"$f":"IFERROR(VLOOKUP(A35,'Insurance coverage'!B$18:AD$47,17,FALSE),\"n/a\")","v":0},null,{"$f":"VLOOKUP(A35,'Historical Protection gap'!$A$17:$AC$47,29,FALSE)","v":2},null,1.6,{"$f":"IFERROR(VLOOKUP(A35,Exposure_Hazard!B$17:T$47,19,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A35,Vulnerability!$A$17:$M$47,13,FALSE),\"n/a\")","v":2},{"$f":"IFERROR(VLOOKUP(A35,'Insurance coverage'!B$18:AD$47,28,FALSE),\"n/a\")","v":1}]
[]
["A protection gap below 3 is not expected to be material."]

{"sheet":"Historical Protection gap","index":2,"n_rows":49,"n_cols":29,"rows_kept":49,"cut":false,"hidden":false,"merged":[[15,1,15,7],[15,8,15,14],[15,22,15,28],[15,15,15,21]]}
["HISTORICAL PROTECTION GAP",null,null,null,null,null,null,"Return to Intro tab"]
[]
["Source link","https://www.munichre.com/en/solutions/for-industry-clients/natcatservice.html "]
[null,"https://www.sigma-explorer.com/"]
[null,"https://www.consorseguros.es/web/documents/10184/44193/Estadistica_Riesgos_Extraordinarios_1971_2014/14ca6778-2081-4060-a86d-728d9a17c522"]
["Data ","NATCAT Service MunichRe* (2018 USD values - millions) & Swiss Re Sigma data and Consorcio de Compensación de Seguros CCS for Spain"]
["Time serie","1980-2018 & 1970-2019"]
["Legend"]
[0,"no risk"]
[1,"low risk"]
[2,"low/medium risk"]
[3,"medium/high risk"]
[4,"high risk"]
["n/a","not available"]
[]
[null,"Geophysical",null,null,null,null,null,null,"Hydrological",null,null,null,null,null,null,"Climatological",null,null,null,null,null,null,"Meteorological"]
["Country","Economic losses Geo (MunichRe)","Insured losses Geo (MunichRe)","Annual uninsured normalized by GDP Geo","Economic losses earthquake (SwissRe)","Insured losses earthquake (SwissRe)","Annual uninsured normalized by GDP earthquake","Score Annual uninsured normalized by GDP Geo","economic losses hydro (MunichRe)","insured losses hydro (MunichRe)","Annual uninsured normalized by GDP hydro","Economic losses flood (SwissRe)","Insured losses flood (SwissRe)","Annual uninsured normalized by GDP flood","Score Annual uninsured normalized by GDP hydro","Economic losses clima (MunichRe)","Insured losses clima (MunichRe)","Annual uninsured normalized by GDP clima",null,null,null,"Score uninsured clima","economic losses met (MunichRe)","insured losses met (MunichRe)","Annual uninsured normalized by GDP met","Economic losses windstorm (SwissRe)","Insured losses windstorm (SwissRe)","Annual uninsured normalized by GDP windstorm","Score uninsured met"]
["Austria",0,0,{"$f":"(B18-C18)/(VLOOKUP(A18,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,{"$f":"MROUND((IF(D18=0,0,IF(D18<0.0001,1,IF(D18<0.0005,2,IF(D18<0.001,3,4))))+IF(G18=0,0,IF(G18<0.0001,1,IF(G18<0.0005,2,IF(G18<0.001,3,4)))))/(COUNTIF(D18,\"<>\")+COUNTIF(G18,\"<>\")),1)","v":0},7900,1300,{"$f":"(I18-J18)/(VLOOKUP(A18,GDP!A$5:F$41,6,FALSE)*39)","v":3.8530706287099036E-4},null,null,null,{"$f":"MROUND((IF(K18=0,0,IF(K18<0.0001,1,IF(K18<0.0005,2,IF(K18<0.001,3,4))))+IF(N18=0,0,IF(N18<0.0001,1,IF(N18<0.0005,2,IF(N18<0.001,3,4)))))/(COUNTIF(K18,\"<>\")+COUNTIF(N18,\"<>\")),1)","v":2},3400,1100,{"$f":"(P18-Q18)/(VLOOKUP(A18,GDP!A$5:F$41,6,FALSE)*39)","v":1.3427367342473906E-4},null,null,null,{"$f":"IF(R18=0,0,IF(R18<0.0001,1,IF(R18<0.0005,2,IF(R18<0.001,3,4))))","v":2},4600,2600,{"$f":"(W18-X18)/(VLOOKUP(A18,GDP!A$5:F$41,6,FALSE)*39)","v":1.1675971602151222E-4},null,null,null,{"$f":"MROUND((IF(Y18=0,0,IF(Y18<0.0001,1,IF(Y18<0.0005,2,IF(Y18<0.001,3,4))))+IF(AB18=0,0,IF(AB18<0.0001,1,IF(AB18<0.0005,2,IF(AB18<0.001,3,4)))))/(COUNTIF(Y18,\"<>\")+COUNTIF(AB18,\"<>\")),1)","v":2}]
["Belgium",160,0,{"$f":"(B19-C19)/(VLOOKUP(A19,GDP!A$5:F$41,6,FALSE)*39)","v":7.8402637659944039E-6},null,null,null,{"$f":"MROUND((IF(D19=0,0,IF(D19<0.0001,1,IF(D19<0.0005,2,IF(D19<0.001,3,4))))+IF(G19=0,0,IF(G19<0.0001,1,IF(G19<0.0005,2,IF(G19<0.001,3,4)))))/(COUNTIF(D19,\"<>\")+COUNTIF(G19,\"<>\")),1)","v":1},660,370,{"$f":"(I19-J19)/(VLOOKUP(A19,GDP!A$5:F$41,6,FALSE)*39)","v":1.4210478075864857E-5},null,null,null,{"$f":"MROUND((IF(K19=0,0,IF(K19<0.0001,1,IF(K19<0.0005,2,IF(K19<0.001,3,4))))+IF(N19=0,0,IF(N19<0.0001,1,IF(N19<0.0005,2,IF(N19<0.001,3,4)))))/(COUNTIF(K19,\"<>\")+COUNTIF(N19,\"<>\")),1)","v":1},110,1,{"$f":"(P19-Q19)/(VLOOKUP(A19,GDP!A$5:F$41,6,FALSE)*39)","v":5.3411796905836875E-6},null,null,null,{"$f":"IF(R19=0,0,IF(R19<0.0001,1,IF(R19<0.0005,2,IF(R19<0.001,3,4))))","v":1},4600,2800,{"$f":"(W19-X19)/(VLOOKUP(A19,GDP!A$5:F$41,6,FALSE)*39)","v":8.8202967367437043E-5},4470,2980,{"$f":"(Z19-AA19)/(VLOOKUP(A19,GDP!A$5:F$41,6,FALSE)*50)","v":5.6949715930241848E-5},{"$f":"MROUND((IF(Y19=0,0,IF(Y19<0.0001,1,IF(Y19<0.0005,2,IF(Y19<0.001,3,4))))+IF(AB19=0,0,IF(AB19<0.0001,1,IF(AB19<0.0005,2,IF(AB19<0.001,3,4)))))/(COUNTIF(Y19,\"<>\")+COUNTIF(AB19,\"<>\")),1)","v":1}]
["Bulgaria",17,0,{"$f":"(B20-C20)/(VLOOKUP(A20,GDP!A$5:F$41,6,FALSE)*39)","v":6.8251713187215254E-6},null,null,null,1,1500,15,{"$f":"(I20-J20)/(VLOOKUP(A20,GDP!A$5:F$41,6,FALSE)*39)","v":5.9619878872361565E-4},null,null,null,3,130,0,{"$f":"(P20-Q20)/(VLOOKUP(A20,GDP!A$5:F$41,6,FALSE)*39)","v":5.2192486554929313E-5},null,null,null,1,680,120,{"$f":"(W20-X20)/(VLOOKUP(A20,GDP!A$5:F$41,6,FALSE)*39)","v":2.248291728520032E-4},null,null,null,2]
["Croatia",680,0,{"$f":"(B21-C21)/(VLOOKUP(A21,GDP!A$5:F$41,6,FALSE)*39)","v":2.9660200269713947E-4},null,null,null,2,2100,95,{"$f":"(I21-J21)/(VLOOKUP(A21,GDP!A$5:F$41,6,FALSE)*39)","v":8.7453972854083044E-4},null,null,null,3,1400,0,{"$f":"(P21-Q21)/(VLOOKUP(A21,GDP!A$5:F$41,6,FALSE)*39)","v":6.1065118202352248E-4},null,null,null,3,14,0,{"$f":"(W21-X21)/(VLOOKUP(A21,GDP!A$5:F$41,6,FALSE)*39)","v":6.1065118202352244E-6},null,null,null,1]
["Cyprus",33,0,{"$f":"(B22-C22)/(VLOOKUP(A22,GDP!A$5:F$41,6,FALSE)*39)","v":3.5154277223231529E-5},null,null,null,1,6.1,1.2,{"$f":"(I22-J22)/(VLOOKUP(A22,GDP!A$5:F$41,6,FALSE)*39)","v":5.2198775270858935E-6},null,null,null,1,410,0,{"$f":"(P22-Q22)/(VLOOKUP(A22,GDP!A$5:F$41,6,FALSE)*39)","v":4.3676526247045231E-4},null,null,null,2,22,7.8,{"$f":"(W22-X22)/(VLOOKUP(A22,GDP!A$5:F$41,6,FALSE)*39)","v":1.5126992017269324E-5},null,null,null,1]
["Czech Republic",0.3,0,{"$f":"(B23-C23)/(VLOOKUP(A23,GDP!A$5:F$41,6,FALSE)*39)","v":3.2032127174234521E-8},null,null,null,1,10000,3600,{"$f":"(I23-J23)/(VLOOKUP(A23,GDP!A$5:F$41,6,FALSE)*39)","v":6.8335204638366983E-4},null,null,null,3,1500,190,{"$f":"(P23-Q23)/(VLOOKUP(A23,GDP!A$5:F$41,6,FALSE)*39)","v":1.398736219941574E-4},null,null,null,2,1000,410,{"$f":"(W23-X23)/(VLOOKUP(A23,GDP!A$5:F$41,6,FALSE)*39)","v":6.299651677599456E-5},null,null,null,1]
["Denmark",1.5,0,{"$f":"(B24-C24)/(VLOOKUP(A24,GDP!A$5:F$41,6,FALSE)*39)","v":1.1208803362765706E-7},null,null,null,1,1900,1300,{"$f":"(I24-J24)/(VLOOKUP(A24,GDP!A$5:F$41,6,FALSE)*39)","v":4.4835213451062821E-5},1590,1230,{"$f":"(L24-M24)/(VLOOKUP(A24,GDP!A$5:F$41,6,FALSE)*50)","v":2.0982879895097403E-5},1,1700,0,{"$f":"(P24-Q24)/(VLOOKUP(A24,GDP!A$5:F$41,6,FALSE)*39)","v":1.2703310477801133E-4},null,null,null,2,8300,5600,{"$f":"(W24-X24)/(VLOOKUP(A24,GDP!A$5:F$41,6,FALSE)*39)","v":2.017584605297827E-4},10540,5640.0000000000009,{"$f":"(Z24-AA24)/(VLOOKUP(A24,GDP!A$5:F$41,6,FALSE)*50)","v":2.8560030968327013E-4},2]
["Estonia",0,0,{"$f":"(B25-C25)/(VLOOKUP(A25,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,0,0,{"$f":"(I25-J25)/(VLOOKUP(A25,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,29,0,{"$f":"(P25-Q25)/(VLOOKUP(A25,GDP!A$5:F$41,6,FALSE)*39)","v":2.508138273294604E-5},null,null,null,1,93,35,{"$f":"(W25-X25)/(VLOOKUP(A25,GDP!A$5:F$41,6,FALSE)*39)","v":5.016276546589208E-5},null,null,null,1]
["Finland",0,0,{"$f":"(B26-C26)/(VLOOKUP(A26,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,93,5.5,{"$f":"(I26-J26)/(VLOOKUP(A26,GDP!A$5:F$41,6,FALSE)*39)","v":8.4322997366608996E-6},null,null,null,1,1200,0,{"$f":"(P26-Q26)/(VLOOKUP(A26,GDP!A$5:F$41,6,FALSE)*39)","v":1.1564296781706376E-4},null,null,null,2,760,420,{"$f":"(W26-X26)/(VLOOKUP(A26,GDP!A$5:F$41,6,FALSE)*39)","v":3.2765507548168067E-5},null,null,null,1]
["France",150,110,{"$f":"(B27-C27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*39)","v":3.8154665917267235E-7},1270,120,{"$f":"(E27-F27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*50)","v":8.5561838319471783E-6},1,20000,11000,{"$f":"(I27-J27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*39)","v":8.5847998313851284E-5},16380.000000000002,9969.9999999999982,{"$f":"(L27-M27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*50)","v":4.7691424663288212E-5},1,12000,2200,{"$f":"(P27-Q27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*39)","v":9.3478931497304734E-5},null,null,null,1,39000,23000,{"$f":"(W27-X27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*39)","v":1.5261866366906896E-4},44439.999999999993,25330,{"$f":"(Z27-AA27)/(VLOOKUP(A27,GDP!A$5:F$41,6,FALSE)*50)","v":1.4218145480740047E-4},2]
["Germany",95,8.6,{"$f":"(B28-C28)/(VLOOKUP(A28,GDP!A$5:F$41,6,FALSE)*39)","v":5.796486229385249E-7},null,null,null,1,37000,8000,{"$f":"(I28-J28)/(VLOOKUP(A28,GDP!A$5:F$41,6,FALSE)*39)","v":1.9455798686594006E-4},43030,10250,{"$f":"(L28-M28)/(VLOOKUP(A28,GDP!A$5:F$41,6,FALSE)*50)","v":1.7153573901321041E-4},2,8000,1600,{"$f":"(P28-Q28)/(VLOOKUP(A28,GDP!A$5:F$41,6,FALSE)*39)","v":4.2936935032483322E-5},null,null,null,1,69000,44000,{"$f":"(W28-X28)/(VLOOKUP(A28,GDP!A$5:F$41,6,FALSE)*39)","v":1.6772240247063798E-4},16160.000000000004,11400.000000000002,{"$f":"(Z28-AA28)/(VLOOKUP(A28,GDP!A$5:F$41,6,FALSE)*50)","v":2.4908789435719397E-5},2]
["Greece",12400,210,{"$f":"(B29-C29)/(VLOOKUP(A29,GDP!A$5:F$41,6,FALSE)*39)","v":1.4860413883556421E-3},null,null,null,4,1100,110,{"$f":"(I29-J29)/(VLOOKUP(A29,GDP!A$5:F$41,6,FALSE)*39)","v":1.206875286687519E-4},null,null,null,2,6600,46,{"$f":"(P29-Q29)/(VLOOKUP(A29,GDP!A$5:F$41,6,FALSE)*39)","v":7.9897582110606059E-4},null,null,null,3,1100,16,{"$f":"(W29-X29)/(VLOOKUP(A29,GDP!A$5:F$41,6,FALSE)*39)","v":1.3214674856255258E-4},null,null,null,2]
["Hungary",120,73,{"$f":"(B30-C30)/(VLOOKUP(A30,GDP!A$5:F$41,6,FALSE)*39)","v":7.9108945725796942E-6},null,null,null,1,1400,59,{"$f":"(I30-J30)/(VLOOKUP(A30,GDP!A$5:F$41,6,FALSE)*39)","v":2.2571297067722061E-4},null,null,null,2,3800,0,{"$f":"(P30-Q30)/(VLOOKUP(A30,GDP!A$5:F$41,6,FALSE)*39)","v":6.3960424203835821E-4},null,null,null,3,250,84,{"$f":"(W30-X30)/(VLOOKUP(A30,GDP!A$5:F$41,6,FALSE)*39)","v":2.7940606362728278E-5},null,null,null,1]
["Iceland",280,140,{"$f":"(B31-C31)/(VLOOKUP(A31,GDP!A$5:F$41,6,FALSE)*39)","v":1.4464161070824102E-4},null,null,null,2,41,24,{"$f":"(I31-J31)/(VLOOKUP(A31,GDP!A$5:F$41,6,FALSE)*39)","v":1.7563624157429267E-5},null,null,null,1,0,0,{"$f":"(P31-Q31)/(VLOOKUP(A31,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,55,24,{"$f":"(W31-X31)/(VLOOKUP(A31,GDP!A$5:F$41,6,FALSE)*39)","v":3.2027785228253367E-5},null,null,null,1]
["Ireland",0,0,{"$f":"(B32-C32)/(VLOOKUP(A32,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,2000,900,{"$f":"(I32-J32)/(VLOOKUP(A32,GDP!A$5:F$41,6,FALSE)*39)","v":7.5751191107404451E-5},1370,810,{"$f":"(L32-M32)/(VLOOKUP(A32,GDP!A$5:F$41,6,FALSE)*50)","v":3.0080109341558418E-5},1,960,760,{"$f":"(P32-Q32)/(VLOOKUP(A32,GDP!A$5:F$41,6,FALSE)*39)","v":1.3772943837709899E-5},null,null,null,1,1600,710,{"$f":"(W32-X32)/(VLOOKUP(A32,GDP!A$5:F$41,6,FALSE)*39)","v":6.1289600077809046E-5},null,null,null,1]
["Italy",76000,2300,{"$f":"(B33-C33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*39)","v":9.3964000647721183E-4},27150,2700,{"$f":"(E33-F33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*50)","v":2.431461948918169E-4},3,39000,1800,{"$f":"(I33-J33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*39)","v":4.7428233705498345E-4},12530.000000000002,1340,{"$f":"(L33-M33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*50)","v":1.1128040576030394E-4},2,25700,260,{"$f":"(P33-Q33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*39)","v":3.2434792082469834E-4},null,null,null,2,8300,1700,{"$f":"(W33-X33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*39)","v":8.4146866251690608E-5},8130.0000000000009,2150,{"$f":"(Z33-AA33)/(VLOOKUP(A33,GDP!A$5:F$41,6,FALSE)*50)","v":5.9468885294603895E-5},1]
["Latvia",0,0,{"$f":"(B34-C34)/(VLOOKUP(A34,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,63,0,{"$f":"(I34-J34)/(VLOOKUP(A34,GDP!A$5:F$41,6,FALSE)*39)","v":4.8823543943224132E-5},null,null,null,1,290,0,{"$f":"(P34-Q34)/(VLOOKUP(A34,GDP!A$5:F$41,6,FALSE)*39)","v":2.2474329751642855E-4},null,null,null,2,340,54,{"$f":"(W34-X34)/(VLOOKUP(A34,GDP!A$5:F$41,6,FALSE)*39)","v":2.216433899644778E-4},null,null,null,2]
["Lithuania",0,0,{"$f":"(B35-C35)/(VLOOKUP(A35,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,0.1,0,{"$f":"(I35-J35)/(VLOOKUP(A35,GDP!A$5:F$41,6,FALSE)*39)","v":4.9747275905698436E-8},null,null,null,1,840,0,{"$f":"(P35-Q35)/(VLOOKUP(A35,GDP!A$5:F$41,6,FALSE)*39)","v":4.1787711760786684E-4},null,null,null,2,72,7.6,{"$f":"(W35-X35)/(VLOOKUP(A35,GDP!A$5:F$41,6,FALSE)*39)","v":3.2037245683269795E-5},null,null,null,1]
["Liechtenstein",null,null,{"$f":"(B36-C36)/(VLOOKUP(A36,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,"n/a",null,null,{"$f":"(I36-J36)/(VLOOKUP(A36,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,"n/a",null,null,{"$f":"(P36-Q36)/(VLOOKUP(A36,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,"n/a",null,null,{"$f":"(W36-X36)/(VLOOKUP(A36,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,"n/a"]
["Luxembourg",0,0,{"$f":"(B37-C37)/(VLOOKUP(A37,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,80,13,{"$f":"(I37-J37)/(VLOOKUP(A37,GDP!A$5:F$41,6,FALSE)*39)","v":2.5122649771434785E-5},null,null,null,1,6.6,0,{"$f":"(P37-Q37)/(VLOOKUP(A37,GDP!A$5:F$41,6,FALSE)*39)","v":2.4747684849473073E-6},null,null,null,1,710,430,{"$f":"(W37-X37)/(VLOOKUP(A37,GDP!A$5:F$41,6,FALSE)*39)","v":1.0499017814927971E-4},null,null,null,{"$f":"MROUND((IF(Y37=0,0,IF(Y37<0.0001,1,IF(Y37<0.0005,2,IF(Y37<0.001,3,4))))+IF(AB37=0,0,IF(AB37<0.0001,1,IF(AB37<0.0005,2,IF(AB37<0.001,3,4)))))/(COUNTIF(Y37,\"<>\")+COUNTIF(AB37,\"<>\")),1)","v":2}]
["Malta",0,0,{"$f":"(B38-C38)/(VLOOKUP(A38,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,46,20,{"$f":"(I38-J38)/(VLOOKUP(A38,GDP!A$5:F$41,6,FALSE)*39)","v":4.7204095432606598E-5},null,null,null,1,0,0,{"$f":"(P38-Q38)/(VLOOKUP(A38,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,19,7.2,{"$f":"(W38-X38)/(VLOOKUP(A38,GDP!A$5:F$41,6,FALSE)*39)","v":2.1423397157875304E-5},null,null,null,1]
["Netherlands",150,43,{"$f":"(B39-C39)/(VLOOKUP(A39,GDP!A$5:F$41,6,FALSE)*39)","v":3.1129789482139994E-6},null,null,null,1,2400,230,{"$f":"(I39-J39)/(VLOOKUP(A39,GDP!A$5:F$41,6,FALSE)*39)","v":6.3132376800227838E-5},null,null,null,1,200,65,{"$f":"(P39-Q39)/(VLOOKUP(A39,GDP!A$5:F$41,6,FALSE)*39)","v":3.9275902617653269E-6},null,null,null,1,7300,4500,{"$f":"(W39-X39)/(VLOOKUP(A39,GDP!A$5:F$41,6,FALSE)*39)","v":8.1461131355132702E-5},950,840,{"$f":"(Z39-AA39)/(VLOOKUP(A39,GDP!A$5:F$41,6,FALSE)*50)","v":2.4962018108108523E-6},1]
["Norway",4.0999999999999996,0,{"$f":"(B40-C40)/(VLOOKUP(A40,GDP!A$5:F$41,6,FALSE)*39)","v":2.5095021854340462E-7},null,null,null,1,730,450,{"$f":"(I40-J40)/(VLOOKUP(A40,GDP!A$5:F$41,6,FALSE)*39)","v":1.7138063705403245E-5},480,240,{"$f":"(L40-M40)/(VLOOKUP(A40,GDP!A$5:F$41,6,FALSE)*50)","v":1.1458019734469597E-5},1,130,0,{"$f":"(P40-Q40)/(VLOOKUP(A40,GDP!A$5:F$41,6,FALSE)*39)","v":7.9569581489372204E-6},null,null,null,1,2800,1500,{"$f":"(W40-X40)/(VLOOKUP(A40,GDP!A$5:F$41,6,FALSE)*39)","v":7.9569581489372194E-5},530,320,{"$f":"(Z40-AA40)/(VLOOKUP(A40,GDP!A$5:F$41,6,FALSE)*50)","v":1.0025767267660898E-5},1]
["Poland",1.5,0,{"$f":"(B41-C41)/(VLOOKUP(A41,GDP!A$5:F$41,6,FALSE)*39)","v":6.7880588726721948E-8},null,null,null,1,11000,920,{"$f":"(I41-J41)/(VLOOKUP(A41,GDP!A$5:F$41,6,FALSE)*39)","v":4.561575562435715E-4},11030,3150,{"$f":"(L41-M41)/(VLOOKUP(A41,GDP!A$5:F$41,6,FALSE)*50)","v":2.7814750036661584E-4},2,2600,2,{"$f":"(P41-Q41)/(VLOOKUP(A41,GDP!A$5:F$41,6,FALSE)*39)","v":1.1756917967468241E-4},null,null,null,2,1000,190,{"$f":"(W41-X41)/(VLOOKUP(A41,GDP!A$5:F$41,6,FALSE)*39)","v":3.6655517912429849E-5},null,null,null,1]
["Portugal",230,0,{"$f":"(B42-C42)/(VLOOKUP(A42,GDP!A$5:F$41,6,FALSE)*39)","v":2.5349846746936741E-5},null,null,null,1,920,170,{"$f":"(I42-J42)/(VLOOKUP(A42,GDP!A$5:F$41,6,FALSE)*39)","v":8.2662543740011108E-5},null,null,null,1,6100,290,{"$f":"(P42-Q42)/(VLOOKUP(A42,GDP!A$5:F$41,6,FALSE)*39)","v":6.4035917217261944E-4},null,null,null,3,880,260,{"$f":"(W42-X42)/(VLOOKUP(A42,GDP!A$5:F$41,6,FALSE)*39)","v":6.8334369491742514E-5},null,null,null,1]
["Romania",170,45,{"$f":"(B43-C43)/(VLOOKUP(A43,GDP!A$5:F$41,6,FALSE)*39)","v":1.3754490163884325E-5},null,null,null,1,4400,16,{"$f":"(I43-J43)/(VLOOKUP(A43,GDP!A$5:F$41,6,FALSE)*39)","v":4.8239747902775103E-4},null,null,null,2,4800,0,{"$f":"(P43-Q43)/(VLOOKUP(A43,GDP!A$5:F$41,6,FALSE)*39)","v":5.2817242229315805E-4},null,null,null,3,310,32,{"$f":"(W43-X43)/(VLOOKUP(A43,GDP!A$5:F$41,6,FALSE)*39)","v":3.0589986124478741E-5},null,null,null,1]
["Slovakia",0,0,{"$f":"(B44-C44)/(VLOOKUP(A44,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,650,31,{"$f":"(I44-J44)/(VLOOKUP(A44,GDP!A$5:F$41,6,FALSE)*39)","v":1.5555361740891502E-4},null,null,null,2,380,0,{"$f":"(P44-Q44)/(VLOOKUP(A44,GDP!A$5:F$41,6,FALSE)*39)","v":9.5493335404503571E-5},null,null,null,1,480,17,{"$f":"(W44-X44)/(VLOOKUP(A44,GDP!A$5:F$41,6,FALSE)*39)","v":1.1635109024285567E-4},null,null,null,2]
["Slovenia",26,1.1000000000000001,{"$f":"(B45-C45)/(VLOOKUP(A45,GDP!A$5:F$41,6,FALSE)*39)","v":1.2254307051521765E-5},null,null,null,1,650,31,{"$f":"(I45-J45)/(VLOOKUP(A45,GDP!A$5:F$41,6,FALSE)*39)","v":3.0463518332899487E-4},null,null,null,2,800,25,{"$f":"(P45-Q45)/(VLOOKUP(A45,GDP!A$5:F$41,6,FALSE)*39)","v":3.8140915521804689E-4},null,null,null,2,430,180,{"$f":"(W45-X45)/(VLOOKUP(A45,GDP!A$5:F$41,6,FALSE)*39)","v":1.230352113606603E-4},null,null,null,2]
["Spain",1200,626,{"$f":"(B46-C46)/(VLOOKUP(A46,GDP!A$5:F$41,6,FALSE)*39)","v":1.0751369054888728E-5},null,null,null,1,12000,7060,{"$f":"(I46-J46)/(VLOOKUP(A46,GDP!A$5:F$41,6,FALSE)*39)","v":9.2529204061237479E-5},2230,879.99999999999989,{"$f":"(L46-M46)/(VLOOKUP(A46,GDP!A$5:F$41,6,FALSE)*50)","v":1.9723330339369043E-5},1,23900,440,{"$f":"(P46-Q46)/(VLOOKUP(A46,GDP!A$5:F$41,6,FALSE)*39)","v":4.3942006625033019E-4},null,null,null,2,7000,2222,{"$f":"(W46-X46)/(VLOOKUP(A46,GDP!A$5:F$41,6,FALSE)*39)","v":8.9494845547488398E-5},280,140,{"$f":"(Z46-AA46)/(VLOOKUP(A46,GDP!A$5:F$41,6,FALSE)*50)","v":2.0453824055641972E-6},1]
["Sweden",0,0,{"$f":"(B47-C47)/(VLOOKUP(A47,GDP!A$5:F$41,6,FALSE)*39)","v":0},null,null,null,0,150,79,{"$f":"(I47-J47)/(VLOOKUP(A47,GDP!A$5:F$41,6,FALSE)*39)","v":3.3967614100087433E-6},null,null,null,1,390,120,{"$f":"(P47-Q47)/(VLOOKUP(A47,GDP!A$5:F$41,6,FALSE)*39)","v":1.2917261700033248E-5},null,null,null,1,4100,1100,{"$f":"(W47-X47)/(VLOOKUP(A47,GDP!A$5:F$41,6,FALSE)*39)","v":1.4352513000036944E-4},null,null,null,2]
[]
["*NatCatService data from MunichRe were taken from MunichRe's website in April 2020. "]

{"sheet":"Exposure_Hazard","index":3,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":false,"merged":[[15,16,15,19],[15,12,15,15],[53,0,56,4],[58,0,61,7],[48,0,51,8],[15,2,15,7],[15,8,15,11]]}
["HAZARD&EXPOSURE EARTHQUAKE",null,null,null,null,null,null,null,"Return to Intro tab"]
[]
["Source link","https://drmkc.jrc.ec.europa.eu/risk-data-hub/ "]
["Data","RISK DATA HUB"]
[null,"See source below for Earthquake*"]
[null,"See source below for Flood**"]
[null,"See source below for Wildfire***"]
[null,"WISC and ESPON for windstorm"]
["Legend"]
[0,"no risk"]
[1,"low risk"]
[2,"low/medium risk"]
[3,"medium/high risk"]
[4,"high risk"]
["n/a","not available"]
[null,null,"Earthquake",null,null,null,null,null,"Flood",null,null,null,"Wildfire",null,null,null,"Windstorm"]
["ISO Code","Country","Intensity scale VI (Light potential damage zones)  (Residential and commercial km2)","Intensity scale VII (Moderate potential damage zones) (Residential and commercial km2)","Intensity scale VIII (Heavy potential damage zones) (Residential and commercial km2)","Economic value of residential and commercial square kilometres impacted by earthquake hazard normalised by GDP","Score based on ESPON maps","Final Score Earthquake","200 return period (Residential and commercial km2)","Economic value of residential and commercial square kilometres impacted by flood hazard normalised by GDP","Score based on ESPON maps","Final Score Flood","(Residential and commercial km2)","Economic value of residential and commercial square kilometres impacted by wildfire hazard normalised by GDP","Score based on ESPON maps","Final Score Wildfire","Storm Severity Index (SSI)",null,"Score based on ESPON maps","Final Score Windstorm"]
["AT","Austria",182.04084400000022,9.6731879999999997,0,{"$f":"(0.1*C18+0.3*D18+0.6*E18)/(VLOOKUP(B18,'Country area'!A$7:B$36,2,FALSE))","v":2.5162485008166553E-4},null,{"$f":"IF(F18=0,0,IF(F18<0.0005,1,IF(F18<0.001,2,IF(F18<0.005,3,4))))","v":1},97.952300999999963,{"$f":"I18/VLOOKUP(B18,'Country area'!A$6:B$36,2,FALSE)","v":1.1677809821290187E-3},null,{"$f":"IF(J18=0,0,IF(J18<0.0005,1,IF(J18<0.001,2,IF(J18<0.005,3,4))))","v":3},"n/a","n/a",2,2,"n/a",null,2,2]
["BE","Belgium",98.567733000000004,17.431908999999997,0,{"$f":"(0.1*C19+0.3*D19+0.6*E19)/(VLOOKUP(B19,'Country area'!A$7:B$36,2,FALSE))","v":4.9414824762528662E-4},null,{"$f":"IF(F19=0,0,IF(F19<0.0005,1,IF(F19<0.001,2,IF(F19<0.005,3,4))))","v":1},66.093671000000001,{"$f":"I19/VLOOKUP(B19,'Country area'!A$6:B$36,2,FALSE)","v":2.1648762201113658E-3},null,{"$f":"IF(J19=0,0,IF(J19<0.0005,1,IF(J19<0.001,2,IF(J19<0.005,3,4))))","v":3},18.700067013000002,{"$f":"M19/VLOOKUP(B19,'Country area'!A$6:B$36,2,FALSE)","v":6.1251447798886343E-4},null,{"$f":"IF(N19=0,0,IF(N19<0.0005,1,IF(N19<0.001,2,IF(N19<0.005,3,4))))","v":2},148493210.53241301,{"$f":"Q19*('Country area'!B8/('Country area'!B8+'Country area'!B26+'Country area'!B13+'Country area'!B28))/VLOOKUP(B19,GDP!A$5:F$41,6,FALSE)","v":73.68434776526064},null,{"$f":"IF(R19=0,0,IF(R19<50,1,IF(R19<100,2,IF(R19<150,3,4))))","v":2}]
["BG","Bulgaria",319.10596499999963,280.2330990000001,0,{"$f":"(0.1*C20+0.3*D20+0.6*E20)/(VLOOKUP(B20,'Country area'!A$7:B$36,2,FALSE))","v":1.0448696054054054E-3},null,3,26.187169999999998,{"$f":"I20/VLOOKUP(B20,'Country area'!A$6:B$36,2,FALSE)","v":2.3592045045045044E-4},null,1,54.051073019,{"$f":"M20/VLOOKUP(B20,'Country area'!A$6:B$36,2,FALSE)","v":4.8694660377477479E-4},null,{"$f":"IF(N20=0,0,IF(N20<0.0005,1,IF(N20<0.001,2,IF(N20<0.005,3,4))))","v":1},"n/a",null,1,1]
["HR","Croatia",106.16915099999997,66.066435000000013,0,{"$f":"(0.1*C21+0.3*D21+0.6*E21)/(VLOOKUP(B21,'Country area'!A$7:B$36,2,FALSE))","v":5.3784848206396888E-4},null,2,34.726936000000023,{"$f":"I21/VLOOKUP(B21,'Country area'!A$6:B$36,2,FALSE)","v":6.1365852624138586E-4},null,2,48.615794022999999,{"$f":"M21/VLOOKUP(B21,'Country area'!A$6:B$36,2,FALSE)","v":8.5908807250397595E-4},null,2,"n/a",null,1,1]
["CY","Cyprus",0,39.632686000000028,22.766713000000006,{"$f":"(0.1*C22+0.3*D22+0.6*E22)/(VLOOKUP(B22,'Country area'!A$7:B$36,2,FALSE))","v":2.7621441729729743E-3},null,3,"n/a","n/a",1,1,12.430193032,{"$f":"M22/VLOOKUP(B22,'Country area'!A$6:B$36,2,FALSE)","v":1.3438046521081081E-3},null,3,"n/a",null,1,1]
["CZ","Czech Republic",1.5151999999999999,0,0,{"$f":"(0.1*C23+0.3*D23+0.6*E23)/(VLOOKUP(B23,'Country area'!A$7:B$36,2,FALSE))","v":1.9211360466590592E-6},null,1,62.660479000000009,{"$f":"I23/VLOOKUP(B23,'Country area'!A$6:B$36,2,FALSE)","v":7.9447798909598082E-4},null,2,0.25972899999999999,{"$f":"M23/VLOOKUP(B23,'Country area'!A$6:B$36,2,FALSE)","v":3.2931279320400659E-6},null,1,"n/a",null,2,2]
["DK","Denmark","n/a","n/a","n/a","n/a",0,0,1.0933220000000001,{"$f":"I24/VLOOKUP(B24,'Country area'!A$6:B$36,2,FALSE)","v":2.5473485554520041E-5},null,1,0.76916000000000007,{"$f":"M24/VLOOKUP(B24,'Country area'!A$6:B$36,2,FALSE)","v":1.7920782851817335E-5},null,1,148493210.53241304,{"$f":"Q24*('Country area'!B13/('Country area'!B13+'Country area'!B26+'Country area'!B8+'Country area'!B28))/VLOOKUP(B24,GDP!A$5:F$41,6,FALSE)","v":157.96666626851152},null,{"$f":"IF(R24=0,0,IF(R24<50,1,IF(R24<100,2,IF(R24<150,3,4))))","v":4}]
["EE","Estonia","n/a","n/a","n/a","n/a",0,0,2.23,{"$f":"I25/VLOOKUP(B25,'Country area'!A$6:B$36,2,FALSE)","v":4.9183943537715041E-5},null,1,"n/a","n/a",2,2,"n/a",null,2,2]
["FI","Finland","n/a","n/a","n/a","n/a",0,0,25.985873000000005,{"$f":"I26/VLOOKUP(B26,'Country area'!A$6:B$36,2,FALSE)","v":7.6779060422514422E-5},null,1,2.6786710009999997,{"$f":"M26/VLOOKUP(B26,'Country area'!A$6:B$36,2,FALSE)","v":7.9145250435810295E-6},null,1,94237094.942731991,{"$f":"Q26*('Country area'!B15/('Country area'!B15+'Country area'!B36+'Country area'!B29))/VLOOKUP(B26,GDP!A$5:F$41,6,FALSE)","v":84.949748686673431},null,{"$f":"IF(R26=0,0,IF(R26<50,1,IF(R26<100,2,IF(R26<150,3,4))))","v":2}]
["FR","France",380.75234800000032,56.720330999999995,0,{"$f":"(0.1*C27+0.3*D27+0.6*E27)/(VLOOKUP(B27,'Country area'!A$7:B$36,2,FALSE))","v":1.0033261413947156E-4},null,1,389.16031700000065,{"$f":"I27/VLOOKUP(B27,'Country area'!A$6:B$36,2,FALSE)","v":7.0874072232633559E-4},null,2,312.93392118999998,{"$f":"M27/VLOOKUP(B27,'Country area'!A$6:B$36,2,FALSE)","v":5.6991682773403849E-4},null,2,123456657.06031765,{"$f":"Q27/VLOOKUP(B27,GDP!A$5:F$41,6,FALSE)","v":45.926863177640755},null,{"$f":"IF(R27=0,0,IF(R27<50,1,IF(R27<100,2,IF(R27<150,3,4))))","v":1}]
["DE","Germany",329.10171999999994,63.112007999999989,4.4145469999999998,{"$f":"(0.1*C28+0.3*D28+0.6*E28)/(VLOOKUP(B28,'Country area'!A$7:B$36,2,FALSE))","v":1.5239247888584369E-4},null,1,451.93453899999997,{"$f":"I28/VLOOKUP(B28,'Country area'!A$6:B$36,2,FALSE)","v":1.2638697326472397E-3},null,3,4.3550880029999997,{"$f":"M28/VLOOKUP(B28,'Country area'!A$6:B$36,2,FALSE)","v":1.217933889758935E-5},null,1,86508074.248353854,{"$f":"Q28/VLOOKUP(B28,GDP!A$5:F$41,6,FALSE)","v":22.634573591825891},null,1]
["EL","Greece",6.8796299999999997,211.56808099999995,116.24897099999998,{"$f":"(0.1*C29+0.3*D29+0.6*E29)/(VLOOKUP(B29,'Country area'!A$7:B$36,2,FALSE))","v":1.0147603053955742E-3},null,3,8.4437029999999993,{"$f":"I29/VLOOKUP(B29,'Country area'!A$6:B$36,2,FALSE)","v":6.3986836920278868E-5},null,1,65.029116020000004,{"$f":"M29/VLOOKUP(B29,'Country area'!A$6:B$36,2,FALSE)","v":4.9279414989390725E-4},null,1,"n/a",null,1,1]
["HU","Hungary",102.73117299999996,3.9425610000000004,0,{"$f":"(0.1*C30+0.3*D30+0.6*E30)/(VLOOKUP(B30,'Country area'!A$7:B$36,2,FALSE))","v":1.2314184241642476E-4},null,1,107.98872799999999,{"$f":"I30/VLOOKUP(B30,'Country area'!A$6:B$36,2,FALSE)","v":1.160794668386542E-3},null,3,2.9630430019999996,{"$f":"M30/VLOOKUP(B30,'Country area'!A$6:B$36,2,FALSE)","v":3.1850403117273992E-5},null,1,"n/a",null,1,1]
["IS","Iceland",0.88284600000000024,2.391051,10.602589,{"$f":"(0.1*C31+0.3*D31+0.6*E31)/(VLOOKUP(B31,'Country area'!A$7:B$36,2,FALSE))","v":6.9584012621359215E-5},null,1,"n/a","n/a",1,1,"n/a","n/a","n/a","n/a","n/a",null,"n/a","n/a"]
["IE","Ireland","n/a","n/a","n/a","n/a",0,0,7.0423660000000012,{"$f":"I32/VLOOKUP(B32,'Country area'!A$6:B$36,2,FALSE)","v":1.0020441092771772E-4},null,1,1.865438003,{"$f":"M32/VLOOKUP(B32,'Country area'!A$6:B$36,2,FALSE)","v":2.6542942558338075E-5},null,1,"n/a",null,3,3]
["IT","Italy",493.32163500000013,729.73449999999934,70.252921999999927,{"$f":"(0.1*C33+0.3*D33+0.6*E33)/(VLOOKUP(B33,'Country area'!A$7:B$36,2,FALSE))","v":1.0300798656003177E-3},null,3,145.40274000000016,{"$f":"I33/VLOOKUP(B33,'Country area'!A$6:B$36,2,FALSE)","v":4.8252054158093901E-4},null,1,268.19857420699998,{"$f":"M33/VLOOKUP(B33,'Country area'!A$6:B$36,2,FALSE)","v":8.9001982546956914E-4},null,2,"n/a",null,2,2]
["LV","Latvia","n/a","n/a","n/a","n/a",0,0,14.080103000000001,{"$f":"I34/VLOOKUP(B34,'Country area'!A$6:B$36,2,FALSE)","v":2.1833002015816407E-4},null,1,0.66616899900000004,{"$f":"M34/VLOOKUP(B34,'Country area'!A$6:B$36,2,FALSE)","v":1.0329803054737169E-5},null,1,"n/a",null,2,2]
["LT","Lithuania","n/a","n/a","n/a","n/a",0,0,7.0346699999999993,{"$f":"I35/VLOOKUP(B35,'Country area'!A$6:B$36,2,FALSE)","v":1.0775158533223049E-4},null,1,"n/a","n/a",2,2,"n/a",null,2,2]
["LI","Liechstenstein",0.95866499999999988,0,0,"n/a",null,"n/a",0.886154,"n/a",null,"n/a","n/a","n/a","n/a","n/a","n/a",null,"n/a","n/a"]
["LU","Luxembourg",7.3261999999999994E-2,0,0,{"$f":"(0.1*C37+0.3*D37+0.6*E37)/(VLOOKUP(B37,'Country area'!A$7:B$36,2,FALSE))","v":2.8286486486486487E-6},null,1,2.1067580000000001,{"$f":"I37/VLOOKUP(B37,'Country area'!A$6:B$36,2,FALSE)","v":8.1342007722007726E-4},null,2,"n/a","n/a",2,2,148493210.53241304,{"$f":"Q37*('Country area'!B26/('Country area'!B26+'Country area'!B13+'Country area'!B28+'Country area'!B8))/VLOOKUP(B37,GDP!A$5:F$41,6,FALSE)","v":47.833058789446952},null,{"$f":"IF(R37=0,0,IF(R37<50,1,IF(R37<100,2,IF(R37<150,3,4))))","v":1}]
["MT","Malta","n/a","n/a","n/a","n/a",2,2,"n/a","n/a",1,1,"n/a","n/a",3,3,"n/a",null,1,1]
["NL","Netherlands",58.911941000000006,0,0,{"$f":"(0.1*C39+0.3*D39+0.6*E39)/(VLOOKUP(B39,'Country area'!A$7:B$36,2,FALSE))","v":1.4181979056331249E-4},null,1,266.43782800000002,{"$f":"I39/VLOOKUP(B39,'Country area'!A$6:B$36,2,FALSE)","v":6.4140064516129041E-3},null,4,5.0267940009999998,{"$f":"M39/VLOOKUP(B39,'Country area'!A$6:B$36,2,FALSE)","v":1.210109292489167E-4},null,1,148493210.53241304,{"$f":"Q39*('Country area'!B28/('Country area'!B28+'Country area'!B8+'Country area'!B26+'Country area'!B13))/VLOOKUP(B39,GDP!A$5:F$41,6,FALSE)","v":59.5246220497542},null,{"$f":"IF(R39=0,0,IF(R39<50,1,IF(R39<100,2,IF(R39<150,3,4))))","v":2}]
["NO","Norway",1.3161700000000001,0,0,{"$f":"(0.1*C40+0.3*D40+0.6*E40)/(VLOOKUP(B40,'Country area'!A$7:B$36,2,FALSE))","v":2.105140758306195E-7},null,1,9.5594360000000016,{"$f":"I40/VLOOKUP(B40,'Country area'!A$6:B$36,2,FALSE)","v":1.5289786539747557E-5},null,1,1.1804159999999999,{"$f":"M40/VLOOKUP(B40,'Country area'!A$6:B$36,2,FALSE)","v":1.8880097809224988E-6},null,1,94237094.942731991,{"$f":"Q40*('Country area'!B29/('Country area'!B29+'Country area'!B36+'Country area'!B15))/VLOOKUP(B40,GDP!A$5:F$41,6,FALSE)","v":99.669933040224251},null,{"$f":"IF(R40=0,0,IF(R40<50,1,IF(R40<100,2,IF(R40<150,3,4))))","v":2}]
["PL","Poland",7.5060360000000008,0,0,{"$f":"(0.1*C41+0.3*D41+0.6*E41)/(VLOOKUP(B41,'Country area'!A$7:B$36,2,FALSE))","v":2.4005488038889605E-6},null,1,132.39977499999992,{"$f":"I41/VLOOKUP(B41,'Country area'!A$6:B$36,2,FALSE)","v":4.2343538122041678E-4},null,1,2.1283350030000001,{"$f":"M41/VLOOKUP(B41,'Country area'!A$6:B$36,2,FALSE)","v":6.8067513208391973E-6},null,1,"n/a",null,3,3]
["PT","Portugal",55.998307000000025,74.848753000000002,0,{"$f":"(0.1*C42+0.3*D42+0.6*E42)/(VLOOKUP(B42,'Country area'!A$7:B$36,2,FALSE))","v":3.0419384251160662E-4},null,1,2.615265,{"$f":"I42/VLOOKUP(B42,'Country area'!A$6:B$36,2,FALSE)","v":2.8357259628265863E-5},null,1,263.08910321000002,{"$f":"M42/VLOOKUP(B42,'Country area'!A$6:B$36,2,FALSE)","v":2.8526692343198894E-3},null,3,108372744.40805,{"$f":"Q42*('Country area'!B31/('Country area'!B31+'Country area'!B35))/VLOOKUP(B42,GDP!A$5:F$41,6,FALSE)","v":71.823377974601328},null,{"$f":"IF(R42=0,0,IF(R42<50,1,IF(R42<100,2,IF(R42<150,3,4))))","v":2}]
["RO","Romania",519.8397250000005,627.98841999999945,0,{"$f":"(0.1*C43+0.3*D43+0.6*E43)/(VLOOKUP(B43,'Country area'!A$7:B$36,2,FALSE))","v":1.0083074601510062E-3},null,3,92.45580799999999,{"$f":"I43/VLOOKUP(B43,'Country area'!A$6:B$36,2,FALSE)","v":3.8781798657718116E-4},null,1,13.779295008999998,{"$f":"M43/VLOOKUP(B43,'Country area'!A$6:B$36,2,FALSE)","v":5.7799056245805363E-5},null,1,"n/a",null,1,1]
["SK","Slovakia",220.01777100000012,4.4339259999999996,0,{"$f":"(0.1*C44+0.3*D44+0.6*E44)/(VLOOKUP(B44,'Country area'!A$7:B$36,2,FALSE))","v":4.7587099530899476E-4},null,1,62.718549000000003,{"$f":"I44/VLOOKUP(B44,'Country area'!A$6:B$36,2,FALSE)","v":1.2791872119110748E-3},null,3,"n/a","n/a",2,2,"n/a",null,1,1]
["SI","Slovenia",12.404551,42.634437000000013,0,{"$f":"(0.1*C45+0.3*D45+0.6*E45)/(VLOOKUP(B45,'Country area'!A$7:B$36,2,FALSE))","v":6.7863536638452257E-4},null,2,10.245836000000001,{"$f":"I45/VLOOKUP(B45,'Country area'!A$6:B$36,2,FALSE)","v":4.955664328899638E-4},null,1,3.7695109980000003,{"$f":"M45/VLOOKUP(B45,'Country area'!A$6:B$36,2,FALSE)","v":1.8232217644498187E-4},null,1,"n/a",null,1,1]
["ES","Spain",149.41155900000001,0.38385899999999995,0,{"$f":"(0.1*C46+0.3*D46+0.6*E46)/(VLOOKUP(B46,'Country area'!A$7:B$36,2,FALSE))","v":2.9759383319991702E-5},null,1,48.308422000000007,{"$f":"I46/VLOOKUP(B46,'Country area'!A$6:B$36,2,FALSE)","v":9.5483455384584988E-5},null,1,284.23153122000002,{"$f":"M46/VLOOKUP(B46,'Country area'!A$6:B$36,2,FALSE)","v":5.6179456100091912E-4},null,2,108372744.40805,{"$f":"Q46*('Country area'!B35/('Country area'!B35+'Country area'!B31))/VLOOKUP(B46,GDP!A$5:F$41,6,FALSE)","v":66.959697714163909},null,{"$f":"IF(R46=0,0,IF(R46<50,1,IF(R46<100,2,IF(R46<150,3,4))))","v":2}]
["SE","Sweden","n/a","n/a","n/a","n/a",0,0,34.663836000000018,{"$f":"I47/VLOOKUP(B47,'Country area'!A$6:B$36,2,FALSE)","v":7.7473204747111323E-5},null,1,9.9944730120000003,{"$f":"M47/VLOOKUP(B47,'Country area'!A$6:B$36,2,FALSE)","v":2.2337512039872159E-5},null,1,94237094.942731991,{"$f":"Q47*('Country area'!B36/('Country area'!B36+'Country area'!B29+'Country area'!B15))/VLOOKUP(B47,GDP!A$5:F$41,6,FALSE)","v":55.752120669996927},null,{"$f":"IF(R47=0,0,IF(R47<50,1,IF(R47<100,2,IF(R47<150,3,4))))","v":2}]
[]
["*Earthquake data sources: The pan-European seismic hazard map (Giardini, D., et.al., 2013) produced in the context of SHARE project is available at http://www.efehr.org/en/home/. The GHSL settlement model grid (model that classify the human settlements on the base of the built-up and population density) was used to assess the \"degree of urbanisation\" and it is available at: http://data.jrc.ec.europa.eu/collection/GHSL .Corine Land Cover (g100_clc12_V18_5a), EEA 2016. "]
[]
[]
[]
[]
["**Flood data sources: The flood inundation maps are available at http://data.jrc.ec.europa.eu/collection/floods . The GHSL settlement model grid (model that classify the human settlements on the base of the built-up and population density) was used to assess the \"degree of urbanisation\" is available at: http://data.jrc.ec.europa.eu/collection/GHSL. Corine Land Cover (g100_clc12_V18_5a), EEA 2016. "]
[]
[]
[]
[]
["***Wildfire data sources: Forest Fires Information system (EFFIS, 2014). The GHSL settlement model grid (model that classify the human settlements on the base of the built-up and population density) was used to assess the \"degree of urbanisation\" and it is available at: http://data.jrc.ec.europa.eu/collection/GHSL. Corine Land Cover (g100_clc12_V18_5a), EEA 2016."]

{"sheet":"Vulnerability","index":4,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[15,2,15,5],[15,6,15,12]]}
["VULNERABILITY",null,"Return to Intro tab"]
[]
["Source link","https://ec.europa.eu/jrc/en/publication/building-stock-inventory-assess-seismic-vulnerability-across-europe-0"]
[null,"https://wisc.climate.copernicus.eu/wisc/#/help/products "]
["Data","Palermo et al. "]
[null,"WISC Copernicus data"]
[]
[]
["Legend"]
[0,"no risk"]
[1,"low risk"]
[2,"low/medium risk"]
[3,"medium/high risk"]
[4,"high risk"]
["n/a","not available"]
[null,null,"Earthquake",null,null,null,"Windstorm"]
["COUNTRY","CNTR_CODE","Building designed with no code","Building designed with moderate-level code","Building designed with high-level code","Score","Weakest outbuildings","Outbuildings","Strong outbuilding","Weak brick structure","Strong brick structure","Concrete building","Score"]
["AUSTRIA","AT",0.83199999999999996,7.5399999999999995E-2,9.2600000000000002E-2,{"$f":"MROUND(C18*4+D18*2+E18*1,1)","v":4},0,0,0,8.6999999999999883E-2,0.49399999999999999,0.41900000000000004,{"$f":"MROUND(G18*4+H18*4+I18*3+J18*3+K18*2+L18*1,1)","v":2}]
["BELGIUM","BE",0.89800000000000002,4.7699999999999999E-2,5.4399999999999997E-2,{"$f":"MROUND(C19*4+D19*2+E19*1,1)","v":4},0,0.05,0,0,0.83000000000000007,0.12,{"$f":"MROUND(G19*4+H19*4+I19*3+J19*3+K19*2+L19*1,1)","v":2}]
["BULGARIA","BG",0.94040000000000001,1.7899999999999999E-2,4.1799999999999997E-2,4,6.6800000000000002E-3,6.6600000000000001E-3,0,6.6600000000000001E-3,0.67000000000000015,0.31,2]
["CROATIA","HR",0.87519999999999998,4.5199999999999997E-2,7.9600000000000004E-2,4,9.5000000000000001E-2,0.01,5.5E-2,0.01,0.63,0.2,2]
["CYPRUS","CY",0.15659999999999999,0,0.84340000000000004,1,7.0000000000000007E-2,0,0,0,0.05,0.88,1]
["CZECH REPUBLIC","CZ",0.79720000000000002,0.1462,5.6599999999999998E-2,4,0.01,0.01,0,0.05,0.56699999999999995,0.36299999999999999,2]
["DENMARK","DK",1,0,0,4,0,0.19,0,0.02,0.59,0.2,2]
["ESTONIA","EE",1,0,0,4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["FINLAND","FI",1,0,0,4,0,0.84,0,0.04,0.05,7.0000000000000007E-2,4]
["FRANCE","FR",0.86919999999999997,4.6300000000000001E-2,8.4500000000000006E-2,4,0,0,0,8.6999999999999883E-2,0.49399999999999999,0.41900000000000004,2]
["GERMANY","DE",0.91920000000000002,1.47E-2,6.6100000000000006E-2,4,0,0,0,0.48499999999999999,0.26,0.255,2]
["GREECE","GR",0.87880000000000003,1.8200000000000001E-2,0.10299999999999999,4,0,0,1E-3,2.5000000000000001E-2,2.3E-2,0.95099999999999996,1]
["HUNGARY","HU",0.89690000000000003,4.65E-2,5.6599999999999998E-2,4,9.5000000000000001E-2,0.01,5.5E-2,0.01,0.63,0.2,2]
["ITALY","IT",0.92390000000000005,5.3699999999999998E-2,2.2499999999999999E-2,4,0,0,0,8.6999999999999883E-2,0.49399999999999999,0.41900000000000004,2]
["LATVIA","LV",0.92900000000000005,0,7.0999999999999994E-2,4,4.7107298075294922E-2,0.02,0.02,0,0,0.91289270192470506,1]
["LITHUANIA","LT",0.94540000000000002,0,5.4600000000000003E-2,4,0,0.11,0,0.1,7.0000000000000007E-2,0.72000000000000008,2]
["LUXEMBOURG","LU",0.50270000000000004,0,0.49730000000000002,3,0,0,0,0,0.98,0.02,2]
["MALTA","MT",1,0,0,4,0,0,0.01,0.01,0.3,0.68,1]
["NETHERLANDS","NL",0.9335,0,6.6500000000000004E-2,4,0,0,0,0,0.98,0.02,2]
["NORWAY","NO",0.91190000000000004,0,8.8099999999999998E-2,4,4.7107298075294922E-2,0.02,0.02,0,0,0.91289270192470506,1]
["POLAND","PL",1,0,0,4,4.7107298075294922E-2,0.02,0.02,0,0,0.91289270192470506,1]
["PORTUGAL","PT",0.8538,1.78E-2,0.1285,4,0,0.01,0,0,0.45999999999999996,0.53,1]
["IRELAND","IE",0.9597,0,4.0300000000000002E-2,4,0,0,0,0,0.99,0.01,2]
["ROMANIA","RO",0.94220000000000004,3.61E-2,2.1700000000000001E-2,4,0,0.02,0.08,0.04,0.42,0.44,2]
["SLOVAKIA","SK",0.67810000000000004,8.9800000000000005E-2,0.2321,3,9.5000000000000001E-2,0.01,5.5E-2,0.01,0.63,0.2,2]
["SLOVENIA","SI",0.89380000000000004,4.0399999999999998E-2,6.5799999999999997E-2,4,0,1.9762845849802375E-3,0,0,0.50395256916996056,0.49407114624505932,2]
["SPAIN","ES",0.80869999999999997,0.10680000000000001,8.4500000000000006E-2,4,0,0.01,0,0,0.45999999999999996,0.53,1]
["SWEDEN","SE",0.63119999999999998,0,0.36880000000000002,3,0,0,0,0,0.98,0.02,2]
["SWITZERLAND","CH",0.88600000000000001,6.1899999999999997E-2,5.2200000000000003E-2,4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["UNITED KINGDOM","UK",0.93589999999999995,0,6.4100000000000004E-2,4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Insurance coverage","index":5,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[[15,2,15,8],[15,9,15,15],[15,16,15,22],[15,23,15,29]]}
["INSURANCE COVERAGE",null,"Return to Intro tab"]
[]
["Source link"]
["Data","NCA’s expert estimations"]
[null,"Hudson et al. 2019; OECD 2016&2018; Insurance Europe; EC 2017; Tesselaar et al. 2020."]
[null,"Policy conditions: Data collected by EIOPA"]
[]
[]
["Legend"]
[0,"no risk"]
[1,"low risk"]
[2,"low/medium risk"]
[3,"medium/high risk"]
[4,"high risk"]
["n/a","not available"]
[null,null,"Earthquake",null,null,null,null,null,null,"Flood",null,null,null,null,null,null,"Wildfire",null,null,null,null,null,null,"Windstorm"]
[null,"Country","Insurance penetration","Score insurance penetration","Deductible","Limit","Score policy conditions","Total score","Insurance scheme","Insurance penetration","Score insurance penetration","Deductible","Limit","Score policy conditions","Total score","Insurance scheme","Insurance penetration","Score insurance penetration","Deductible","Limit","Score policy conditions","Total score","Insurance scheme","Insurance penetration","Score insurance penetration","Deductible","Limit","Score policy conditions","Total score","Insurance scheme"]
["AT","Austria","low",{"$f":"IF(C18=\"very high\",0,IF(C18=\"high\",1,IF(C18=\"medium\",2,IF(C18=\"low\",3,IF(C18=\"very low\",4,IF(C18=\"n/a\",\"n/a\",IF(C18=\"non-existent\",4)))))))","v":3},2.7032317334568499E-3,9.7085453564468502E-2,{"$f":"MROUND((IF(E18=0,0,IF(E18<0.01,1,IF(E18<0.05,2,IF(E18<0.1,3,4))))+IF(F18=1,0,IF(F18<0.5,4,IF(F18<0.7,3,IF(F18<0.9,2,1)))))/2,1)","v":3},{"$f":"MROUND(IF(ISERROR(D18),G18,IF(ISERROR(G18),D18,(2*D18+G18)/3)),1)","v":3},"voluntary","very low",{"$f":"IF(J18=\"very high\",0,IF(J18=\"high\",1,IF(J18=\"medium\",2,IF(J18=\"low\",3,IF(J18=\"very low\",4,IF(J18=\"n/a\",\"n/a\",IF(J18=\"non-existent\",4)))))))","v":4},2.4078859042112499E-3,0.10421493580052101,{"$f":"MROUND((IF(L18=0,0,IF(L18<0.01,1,IF(L18<0.05,2,IF(L18<0.1,3,4))))+IF(M18=1,0,IF(M18<0.5,4,IF(M18<0.7,3,IF(M18<0.9,2,1)))))/2,1)","v":3},{"$f":"MROUND(IF(ISERROR(K18),N18,IF(ISERROR(N18),K18,(2*K18+N18)/3)),1)","v":4},"voluntary","very low",{"$f":"IF(Q18=\"very high\",0,IF(Q18=\"high\",1,IF(Q18=\"medium\",2,IF(Q18=\"low\",3,IF(Q18=\"very low\",4,IF(Q18=\"n/a\",\"n/a\",IF(Q18=\"non-existent\",4)))))))","v":4},null,null,null,null,"voluntary","very high",{"$f":"IF(X18=\"very high\",0,IF(X18=\"high\",1,IF(X18=\"medium\",2,IF(X18=\"low\",3,IF(X18=\"very low\",4,IF(X18=\"n/a\",\"n/a\",IF(X18=\"non-existent\",4)))))))","v":0},2.5911552589174998E-3,0.93631149508035005,{"$f":"MROUND((IF(Z18=0,0,IF(Z18<0.01,1,IF(Z18<0.05,2,IF(Z18<0.1,3,4))))+IF(AA18=1,0,IF(AA18<0.5,4,IF(AA18<0.7,3,IF(AA18<0.9,2,1)))))/2,1)","v":1},{"$f":"MROUND(IF(ISERROR(Y18),AB18,IF(ISERROR(AB18),Y18,(2*Y18+AB18)/3)),1)","v":0},"voluntary"]
["BE","Belgium","very high",{"$f":"IF(C19=\"very high\",0,IF(C19=\"high\",1,IF(C19=\"medium\",2,IF(C19=\"low\",3,IF(C19=\"very low\",4,IF(C19=\"n/a\",\"n/a\",IF(C19=\"non-existent\",4)))))))","v":0},6.5515468943904099E-3,0.65176319765212998,{"$f":"MROUND((IF(E19=0,0,IF(E19<0.01,1,IF(E19<0.05,2,IF(E19<0.1,3,4))))+IF(F19=1,0,IF(F19<0.5,4,IF(F19<0.7,3,IF(F19<0.9,2,1)))))/2,1)","v":2},{"$f":"MROUND(IF(ISERROR(D19),G19,IF(ISERROR(G19),D19,(2*D19+G19)/3)),1)","v":1},"compulsory by law","very high",{"$f":"IF(J19=\"very high\",0,IF(J19=\"high\",1,IF(J19=\"medium\",2,IF(J19=\"low\",3,IF(J19=\"very low\",4,IF(J19=\"n/a\",\"n/a\",IF(J19=\"non-existent\",4)))))))","v":0},4.5907491495669698E-3,0.65071085822444097,{"$f":"MROUND((IF(L19=0,0,IF(L19<0.01,1,IF(L19<0.05,2,IF(L19<0.1,3,4))))+IF(M19=1,0,IF(M19<0.5,4,IF(M19<0.7,3,IF(M19<0.9,2,1)))))/2,1)","v":2},{"$f":"MROUND(IF(ISERROR(K19),N19,IF(ISERROR(N19),K19,(2*K19+N19)/3)),1)","v":1},"compulsory by law","n/a",{"$f":"IF(Q19=\"very high\",0,IF(Q19=\"high\",1,IF(Q19=\"medium\",2,IF(Q19=\"low\",3,IF(Q19=\"very low\",4,IF(Q19=\"n/a\",\"n/a\",IF(Q19=\"non-existent\",4)))))))","v":"n/a"},null,null,null,null,"voluntary","very high",{"$f":"IF(X19=\"very high\",0,IF(X19=\"high\",1,IF(X19=\"medium\",2,IF(X19=\"low\",3,IF(X19=\"very low\",4,IF(X19=\"n/a\",\"n/a\",IF(X19=\"non-existent\",4)))))))","v":0},3.7526140513473001E-3,0.65880117441946695,{"$f":"MROUND((IF(Z19=0,0,IF(Z19<0.01,1,IF(Z19<0.05,2,IF(Z19<0.1,3,4))))+IF(AA19=1,0,IF(AA19<0.5,4,IF(AA19<0.7,3,IF(AA19<0.9,2,1)))))/2,1)","v":2},{"$f":"MROUND(IF(ISERROR(Y19),AB19,IF(ISERROR(AB19),Y19,(2*Y19+AB19)/3)),1)","v":1},"compulsory by law"]
["BG","Bulgaria","n/a","n/a",1.7544631310885499E-2,0.39317600535049502,3,{"$error":"#VALUE!"},"voluntary","very low",4,8.6703312752859397E-3,0.35587071475682103,3,4,"voluntary","very low",4,null,null,null,null,"non-existent","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary"]
["HR","Croatia","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary","medium",2,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2,"voluntary","very low",4,null,null,null,null,"voluntary","low",3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3,"voluntary"]
["CY","Cyprus","low",3,1.2232367991569499E-2,0.78579138014197702,2,3,"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","non-existent",4,null,null,null,null,"non-existent","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary"]
["CZ","Czech Republic","very low",4,5.6212409128309397E-3,0.70267328531013296,2,3,"voluntary","high",1,1.0609492334756001E-2,0.57997909783808699,3,2,"voluntary","very low",4,null,null,null,null,"voluntary","high",1,6.8403195983447801E-3,0.68793742526902502,2,1,"voluntary"]
["DK","Denmark","non-existent",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"non-existent","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"voluntary","very high",0,null,null,null,null,"voluntary","very high",0,5.4004442414974001E-3,0.944610842008058,1,0,"voluntary"]
["EE","Estonia","non-existent",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"non-existent","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"voluntary","non-existent",4,null,null,null,null,"non-existent","very high",0,1.81065429012398E-3,0.85948986315792497,2,1,"voluntary"]
["FI","Finland","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},null,"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"semi-voluntary","very high",0,null,null,null,null,null,"very high",0,1.6216156833618801E-2,0.941788142298568,2,1]
["FR","France","very high",0,5.7185262136175098E-3,0.91849578654644604,1,{"$f":"MROUND(IF(ISERROR(D27),G27,IF(ISERROR(G27),D27,(2*D27+G27)/3)),1)","v":0},"solidarity","very high",0,5.6224136534431804E-3,0.91407922671485997,1,0,"solidarity","n/a","n/a",null,null,null,null,null,"very high",0,6.2593720696247999E-3,0.90848255947747003,1,0,"solidarity"]
["DE","Germany","medium",2,5.15460381488586E-3,0.68840905097280802,2,2,"voluntary","medium",2,2.6637953258561E-3,0.69233877015987699,2,2,"voluntary","medium",2,null,null,null,null,"voluntary","high",1,1.0808941395564001E-3,0.83586492703491599,2,1,"voluntary"]
["EL","Greece","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary","very low",4,null,null,null,null,"voluntary","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary"]
["HU","Hungary","high",1,1.3247914587996099E-2,0.77052767331926297,2,1,"semi-voluntary","high",1,1.3515070523494301E-2,0.82770771188231396,2,1,"semi-voluntary","n/a","n/a",null,null,null,null,null,"high",1,1.46974780840713E-2,0.79174256661473896,2,1,"voluntary"]
["IS","Iceland","high",1,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1,null,"high",1,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1,null,"n/a","n/a",null,null,null,null,null,"high",1,3.6881204865446501E-3,0.54450835642513995,2,1]
["IE","Ireland","non-existent",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"non-existent","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"semi-voluntary","n/a","n/a",null,null,null,null,"voluntary","very high",0,9.0491245071828794E-3,0.63184756310537504,2,1,"voluntary"]
["IT","Italy","very low",4,4.0707088043665102E-2,0.507822413665035,3,4,"voluntary","very low",4,4.1195085494358602E-2,0.40885575344751202,3,4,"voluntary","n/a","n/a",null,null,null,null,null,"very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary"]
["LV","Latvia","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","n/a","n/a",null,null,null,null,null,"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"}]
["LT","Lithuania","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},null,"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","n/a","n/a",null,null,null,null,null,"n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"}]
["LI","Liechtenstein","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","n/a","n/a",null,null,null,null,"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary"]
["LU","Luxembourg","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary","n/a","n/a",null,null,null,null,"voluntary","very high",0,7.0739823681902597E-2,0.27909407922696799,4,1,"voluntary"]
["MT","Malta","very low",4,4.8690509145838399E-3,0.42160348412632598,3,4,"voluntary","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary","non-existent",4,null,null,null,null,"non-existent","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary"]
["NL","Netherlands","non-existent",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"non-existent","very low",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"voluntary","very high",0,null,null,null,null,"voluntary","very high",0,6.3609826330090604E-3,0.67600182324438696,2,1,"voluntary"]
["NO","Norway","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"compulsory by law","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"compulsory by law","very high",0,null,null,null,null,"voluntary","very high",0,4.07151830855902E-3,0.92684031537245604,1,0,"compulsory by law"]
["PL","Poland","non-existent",4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,"non-existent","high",1,5.7813733054032403E-3,0.84879987124720802,2,1,"voluntary","n/a","n/a",null,null,null,null,"voluntary","n/a","n/a",6.8569145685996999E-3,0.88446778148870897,2,{"$error":"#VALUE!"},"voluntary"]
["PT","Portugal","low",3,4.9546587025463299E-3,0.111030938406351,3,3,"voluntary","low",3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3,"voluntary","n/a","n/a",null,null,null,null,"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},"voluntary"]
["RO","Romania","low",3,0.14379213040737501,0.89241268022301501,3,3,"solidarity","low",3,8.8542461295735495E-2,0.91023787422294899,2,3,"solidarity","n/a","n/a",null,null,null,null,"voluntary","n/a","n/a",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"}]
["SK","Slovakia","very low",4,1.26160866501664E-2,0.64603201547092803,3,4,"voluntary","low",3,1.1985576694796499E-2,0.64254876682409801,3,3,"voluntary","very low",4,null,null,null,null,"voluntary","low",3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},3,"voluntary"]
["SI","Slovenia","n/a","n/a",2.4923699368385399E-2,0.95710939033066,2,{"$error":"#VALUE!"},"voluntary","medium",2,1.1426792431619901E-3,0.27035453465883402,3,2,"voluntary","n/a","n/a",null,null,null,null,"voluntary","n/a","n/a",4.3165687351242601E-4,0.98282754835717301,1,{"$error":"#VALUE!"},"voluntary"]
["ES","Spain","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"solidarity","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"solidarity","n/a","n/a",null,null,null,null,"voluntary","very high",0,1.81065429012398E-3,0.85948986315792497,2,1,"solidarity"]
["SE","Sweden","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"semi-voluntary","very high",0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,"semi-voluntary","very high",0,null,null,null,null,"voluntary","very high",0,1.29130765978993E-2,0.812542912479569,2,1,"semi-voluntary"]

{"sheet":"GDP","index":6,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,4]]}
["GDP"]
[]
["Data source: EUROSTAT","https://ec.europa.eu/eurostat/databrowser/view/tec00001/default/table?lang=en "]
["Conversion rate: InforEuro (31.12.2018)",1.1387,"https://ec.europa.eu/info/funding-tenders/how-eu-funding-works/information-contractors-and-beneficiaries/exchange-rate-inforeuro_en "]
["TIME","2018","","2019","","2018 USD"]
["GEO (Labels)","","","",""]
["European Union - 27 countries (from 2020)",13498257.5,null,13939074.5,"",{"$f":"B7*$B$4","v":15370465.81525}]
["European Union - 28 countries (2013-2020)",15921994.1,null,16464167.6,"",{"$f":"B8*$B$4","v":18130374.681669999}]
["Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015)",11571626,null,11920174,"",13176610.5262]
["Euro area - 19 countries  (from 2015)",11571626,null,11920174,"",13176610.5262]
["Belgium",459531.6,null,473085.1,"",523268.63292]
["Bulgaria",56086.9,null,60675.3,"p",63866.153030000001]
["Czech Republic",210892.7,null,223945,"",240143.51749000003]
["Denmark",301340.90000000002,null,310002.3,"",{"$f":"B14*$B$4","v":343136.88283000002}]
["Germany",3356410,null,3449050,"",3821944.0670000003]
["Estonia",26035.9,null,28037.200000000001,"",29647.079330000004]
["Ireland",326986.09999999998,null,356051.20000000001,"",372339.07206999999]
["Greece",184713.60000000001,null,187456.5,"p",210333.37632000001]
["Spain",1202193,null,1245331,"p",1368937.1691000001]
["France",2360687,null,2425708,"p",2688114.2869000002]
["Croatia",51625.1,null,53936.7,"e",58785.501369999998]
["Italy",1766168.2,null,1787664.1,"",2011135.7293400001]
["Cyprus",21137.9,null,21943.599999999999,"p",24069.726730000002]
["Latvia",29056.1,null,30476.1,"",33086.181069999999]
["Lithuania",45264.4,null,48432.800000000003,"",51542.57228]
["Luxembourg",60053.1,null,63516.3,"",68382.464970000001]
["Hungary",133782.20000000001,null,143826.4,"p",152337.79114000002]
["Malta",12402.8,null,13277.3,"",14123.068359999999]
["Netherlands",773987,null,810247,"p",881338.99690000003]
["Austria",385711.9,null,398682.4,"",439210.14053000003]
["Poland",497590.1,null,529029.19999999995,"",566605.84687000001]
["Portugal",204304.8,null,212320.6,"e",232641.87576]
["Romania",204640.5,null,223337.4,"p",233024.13735]
["Slovenia",45754.8,null,48006.6,"",52100.990760000008]
["Slovakia",89605.9,null,94171.199999999997,"",102034.23832999999]
["Finland",233662,null,240557,"",266070.91940000001]
["Sweden",470673.1,null,474148.2,"",535955.45897000004]
["United Kingdom",2423736.6,null,2525093.1,"",2759908.8664200003]
["Iceland",21795.200000000001,null,21602.7,"e",24818.194240000001]
["Liechtenstein",5822.5,null,":","",6630.0807500000001]
["Norway",367893.7,null,360300.9,"",418920.55619000003]

{"sheet":"Country area","index":7,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["COUNTRY AREA"]
[]
["Datasource","Worldmeter","How many countries in Europe? - Worldometer (worldometers.info)"]
[]
[]
["Country","Area (km2)"]
["Austria",83879]
["Belgium",30530]
["Bulgaria",111000]
["Croatia",56590]
["Cyprus",9250]
["Czech Republic",78870]
["Denmark",42920]
["Estonia",45340]
["Finland",338450]
["France",549087]
["Germany",357580]
["Greece",131960]
["Hungary",93030]
["Iceland",103000]
["Ireland",70280]
["Italy",301340]
["Latvia",64490]
["Liechtenstein",160]
["Lithuania",65286]
["Luxembourg",2590]
["Malta",320]
["Netherlands",41540]
["Norway",625217.1]
["Poland",312680]
["Portugal",92225.59]
["Romania",238400]
["Slovakia",49030]
["Slovenia",20675]
["Spain",505935]
["Sweden",447430]