Using R as a BI tool

class: center, middle, inverse, title-slide

# Using R as a BI tool
### david.gohel @ ardata.fr
### 2017-11-15

---

# About me

&gt; 15 years of experience with data :

* statistical software edition
* CRM software edition
* retails
* climate business intelligence
* web analytics
* ... to be continued

Favorite tools:
<img src="img/Rlogo.svg" height="18px">&nbsp;
&nbsp;
&nbsp;
 
R packages: [officer](http://cran.r-project.org/package=officer) 
[flextable](http://cran.r-project.org/package=flextable) 
[mschart](http://cran.r-project.org/package=mschart) 
[rvg](http://cran.r-project.org/package=rvg) 
[ggiraph](http://cran.r-project.org/package=ggiraph) 
[gdtools](http://cran.r-project.org/package=gdtools)

---
class: middle, inverse, center

# Business intelligence

> Using internal and external data to provide 
insights to help decision

---
class: middle

BI is consummed by people who are deciding, evaluating or communicating...

---
class: middle

BI is been used on demand and daily/weekly/monthly

---
class: middle

BI is ubiquitous

---
class: middle

Technically speaking, it is always about:

* Structuring data
* Aggregations
* Transformations
* KPI calculation and optimization
* Reporting

---
class: middle, inverse, center

# BI can be made with R

---
class: middle

## Does R fit to BI?

.left-column[
  ## IO
]

.right-column[

R can now read and write all data format I may need:

<div id="htmlwidget-0a8ec6867160dc67e517" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-0a8ec6867160dc67e517">{"x":{"html":"<table><thead><tr><td style=\"height:27px;width:67px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">Format<\/span><\/p><\/td><td style=\"height:27px;width:77px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">Package<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:26px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">CSV, TEXT<\/span><\/p><\/td><td style=\"height:26px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">readr<\/span><\/p><\/td><\/tr><tr><td style=\"height:24px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">EXCEL<\/span><\/p><\/td><td style=\"height:24px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">readxl<\/span><\/p><\/td><\/tr><tr><td style=\"height:24px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SAS<\/span><\/p><\/td><td style=\"height:24px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">haven<\/span><\/p><\/td><\/tr><tr><td style=\"height:24px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SPSS<\/span><\/p><\/td><td style=\"height:24px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">haven<\/span><\/p><\/td><\/tr><tr><td style=\"height:24px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">STATA<\/span><\/p><\/td><td style=\"height:24px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">haven<\/span><\/p><\/td><\/tr><tr><td style=\"height:27px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">JSON<\/span><\/p><\/td><td style=\"height:27px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">jsonlite<\/span><\/p><\/td><\/tr><tr><td style=\"height:24px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">HTML<\/span><\/p><\/td><td style=\"height:24px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">rvest<\/span><\/p><\/td><\/tr><tr><td style=\"height:24px;width:95px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">XML<\/span><\/p><\/td><td style=\"height:24px;width:62px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">xml2<\/span><\/p><\/td><\/tr><tr><td style=\"height:27px;width:95px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">YAML<\/span><\/p><\/td><td style=\"height:27px;width:62px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">yaml<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

]

---
class: middle

## Does R fit to BI?

.left-column[
  ## IO
]
.right-column[

R can now connect to any database (SGBD, big data systems, ...) I may need to access...

The [R consortium](https://www.r-consortium.org), [RStudio team](https://www.rstudio.com) cleaned and improved databases support.

```r
library(DBI)
con <- dbConnect(RPostgres::Postgres(), dbname = 'db_name', host = 'host', 
 port = 5432, user = 'username', password = 'pwd')
con <- dbConnect(odbc::odbc(), driver = "PostgreSQL Driver", database = "db_name",
 uid = "username", pwd = "pwd", host = "host", port = 5432)

res <- dbGetQuery(con, "SELECT * FROM studies limit 5")
```

See [Databases using R](http://db.rstudio.com/)

]

---
class: middle

## Does R fit to BI?

.left-column[
  ## IO
  ## data processing
]
.right-column[

[tidyverse](https://www.tidyverse.org/) and [data.table](https://CRAN.R-project.org/package=data.table) packages are covering 99% of necessary operations (join, aggregation, filtering, sorting, etc.).

[fuzzyjoin](https://cran.r-project.org/package=fuzzyjoin) and [tidytext](https://cran.r-project.org/package=tidytext) are easy enough to work with difficult textual data.

]

---
class: middle

## Does R fit to BI?

.left-column[
  ## IO
  ## data processing
  ## checking
]
.right-column[

[lumberjack](http://cran.r-project.org/package=lumberjack/) is providing a logger system to monitor changes in data.

[validate](http://cran.r-project.org/package=validate/) is offering a set of function that will check if data are valid.

Of course, [tidyverse](https://www.tidyverse.org/) and [data.table](https://CRAN.R-project.org/package=data.table) are ubiquitous in this area also.

]

---
class: middle

## Does R fit to BI?

.left-column[
  ## IO
  ## data processing
  ## checking
  ## exploration
]
.right-column[

[ggplot2](http://cran.r-project.org/package=ggplot2/) is providing an easy API to plot everything.

[tidyverse](https://www.tidyverse.org/) and [data.table](https://CRAN.R-project.org/package=data.table)...

[htmlwidgets for R - gallery](http://gallery.htmlwidgets.org): interactive visualisations

]

---
class: middle

## Does R fit to BI?

.left-column[
  ## IO
  ## data processing
  ## checking
  ## exploration
  ## reporting
]
.right-column[

### Static reporting

[rmarkdown](http://rmarkdown.rstudio.com/) is allowing the production of HTML, PDF, MS Word, HTML dashboard, HTML static web sites. Package [officer](http://cran.r-project.org/package=officer) is offering several options to produce Word and PowerPoint files and package  [openxlsx](http://cran.r-project.org/package=openxlsx) brings a rich API to produce Excel files.

### Interactive reporting

[shiny](https://www.rstudio.com/products/shiny-server-pro/) fits very well for small and medium audiences.

[ShinyProxy](https://www.shinyproxy.io/) is also a serious candidate for shiny application.

[RStudio Connect](https://www.rstudio.com/products/connect/) is more than decent enterprise solution (shiny + static pages + scheduler + easy user managment).

]

---
# Successful architectures

> those I has experienced...

.left-column[
  ## R client
]
.right-column[

R fits on an USB key.

Perfect for simple projects.

]

---
# Successful architectures

> those I has experienced...

.left-column[
  ## R client
  ## opencpu
]
.right-column[

R as a service; an HTTP based server that can be called 
from any application able to manage HTTP protocol.

Highly secure

Pleases the IT

Requires experienced R coders to develop packages

]

---
# Successful architectures

> those I has experienced...

.left-column[
  ## R client
  ## opencpu
  ## RStudio Connect
]
.right-column[

Easy and reliable.

User management, content management, scheduler, etc.

It is not open source

]

---
# Successful architectures

> those I has experienced...

.left-column[
  ## R client
  ## opencpu
  ## RStudio Connect
  ## Rscript
]
.right-column[

Good old `crontab` or `Luigi` (build complex pipelines of batch jobs).

See also [littler](https://CRAN.R-project.org/package=littler).

Pleases the IT

For simple jobs

]

---
class: middle, inverse, center

# BI with R - pros and cons

---
# BI with R - The good

Thanks to its package ecosystem, R has no functional limit.

By allowing pretty and innovative outputs, R value our work.

It cost only an R coder to try and test.

**Self BI is now possible and will be required more and more.**

**R community will help!**

---

# BI with R - Cons

Resistance from IT teams. *R is a live ecosystem, not a finite solution ready to be installed*.

Can be unoptimized. A newbie script is often just a proof it can be done, not a complete and robust analytic.

R is a glue system made of many packages and structured by its history, IT IS NOT a database system, it does not come with a visual GUI.

13 000 packages! Choice issue... Again, need for a someone experimented with R.

---
class: middle, inverse, center

# Stories

---

## Reporting with packages `officer` and `mschart`

Story: a [yougov](http://www.yougov.com/) service whole role is to *do some BI* was spending too much time preparing PowerPoint documents for business analysts.

Solution: [mschart](http://cran.r-project.org/package=mschart) to be able to deliver pre-formatted PowerPoints charts from an R analytic. (founder: yougov)

> business analysts still can annotate graphical reports and adapt content without leaving their favorite tool and without vampiring other services precious time.

```r
library(officer)
library(mschart)
my_barchart <- ms_barchart(data = browser_data, x = "browser", y = "value", group = "serie")
doc <- read_pptx()
doc <- add_slide(doc, layout = "Title and Content", master = "Office Theme")
doc <- ph_with_chart(doc, chart = my_barchart)
print(doc, target = "samples/barchart_example.pptx")
```

[barchart_example.pptx](samples/barchart_example.pptx)

---
## Clinical reporting

Story: reduce time to update clinical reporting (Word format):

* minimum 80 pages of clinical tables and graphics
* CDISC model
* This has to be made several times per study, there are several studies... There is a limited amount of time in a team of 6.

Solution: Developped packages for clinical studies treatment and reporting. When clinical database is updated, reports are generated.

---
## Web analytics stories

Story: a department is not willing to share its data internally, BI coders are stucked.

Solution: use packages [charlatan](https://cran.r-project.org/package=wakefield) or [wakefield](https://cran.r-project.org/package=charlatan) to simulate data according to 
the *signed contract*.

> we were no more stuck while arguing with the other department.

---
class: middle, inverse, center

# Use case: RTE

---
# Antares

> a Monte-Carlo software for power systems analysis: 
A New Tool for Adequacy Reports and Economic Simulations.

* Generation / Load balance studies
* Economic assessment of Generation projects
* Economic assessment of Transmission projects

.left-column[
  ## The need
]

.right-column[

A tool to generate validated datasets based on data provided by ENTSOE (*european network of transmission system operators for electricity*).

This datasets will be used to play various Monte-carlo scenarii with `antares`.

]

---
# Antares

> a Monte-Carlo software for power systems analysis: 
A New Tool for Adequacy Reports and Economic Simulations.

* Generation / Load balance studies
* Economic assessment of Generation projects
* Economic assessment of Transmission projects

.left-column[
  ## The need
  ## Difficulties
]

.right-column[

* Each country is sending *highly staked* information. Treatments must be specific for each country.
* Aggregation instructions differ for each country.
* Some measures are wrong and must be corrected

]

---
# Antares

> a Monte-Carlo software for power systems analysis: 
A New Tool for Adequacy Reports and Economic Simulations.

* Generation / Load balance studies
* Economic assessment of Generation projects
* Economic assessment of Transmission projects

.left-column[
  ## The need
  ## Difficulties
  ## Open source
]

.right-column[

* Project is beeing hosted on github: https://github.com/rte-antares-rpackage/antaDraft
* Later on CRAN
* roughly 50% complete
* Datasets will be open-sourced also!

]

---

## read raw datasets

```r
load_data <- anta_load_read(data_dir = load_path) 
```

```r
sample_n(load_data, size = 3) %>% regulartable() %>% theme_vanilla() %>% autofit()
```

<div id="htmlwidget-e70b199a0213785832a5" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-e70b199a0213785832a5">{"x":{"html":"<table><thead><tr><td style=\"height:22px;width:58px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">DateTime<\/span><\/p><\/td><td style=\"height:22px;width:49px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">country<\/span><\/p><\/td><td style=\"height:22px;width:83px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">AreaTypeCode<\/span><\/p><\/td><td style=\"height:22px;width:62px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">AreaName<\/span><\/p><\/td><td style=\"height:22px;width:58px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">MapCode<\/span><\/p><\/td><td style=\"height:22px;width:87px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TotalLoadValue<\/span><\/p><\/td><td style=\"height:22px;width:57px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">observed<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2015-01-20 14:00:00<\/span><\/p><\/td><td style=\"height:20px;width:87px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">PORTUGAL<\/span><\/p><\/td><td style=\"height:20px;width:33px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BZN<\/span><\/p><\/td><td style=\"height:20px;width:66px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">REN BZ<\/span><\/p><\/td><td style=\"height:20px;width:26px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">PT<\/span><\/p><\/td><td style=\"height:20px;width:54px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">7571.50<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><\/tr><tr><td style=\"height:22px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2016-05-08 11:00:00<\/span><\/p><\/td><td style=\"height:22px;width:87px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BELGIUM<\/span><\/p><\/td><td style=\"height:22px;width:33px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">CTY<\/span><\/p><\/td><td style=\"height:22px;width:66px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">Belgium<\/span><\/p><\/td><td style=\"height:22px;width:26px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BE<\/span><\/p><\/td><td style=\"height:22px;width:54px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">8541.29<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2016-11-19 23:00:00<\/span><\/p><\/td><td style=\"height:20px;width:87px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">NETHERLANDS<\/span><\/p><\/td><td style=\"height:20px;width:33px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">CTY<\/span><\/p><\/td><td style=\"height:20px;width:66px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">Netherlands<\/span><\/p><\/td><td style=\"height:20px;width:26px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">NL<\/span><\/p><\/td><td style=\"height:20px;width:54px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">10960.00<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

> Which countries did not send data from 2015 to 2016?

```r
load_data %>% filter(observed) %>% select(DateTime, country) %>% group_by(country) %>% 
    summarise(start = min(DateTime, na.rm = TRUE), end = max(DateTime, na.rm = TRUE) ) %>% 
    filter( year(start) >= 2015 ) %>% 
  regulartable() %>% theme_vanilla() %>% autofit()
```

<div id="htmlwidget-f3a4f5fdcafd62f2d44d" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-f3a4f5fdcafd62f2d44d">{"x":{"html":"<table><thead><tr><td style=\"height:22px;width:49px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">country<\/span><\/p><\/td><td style=\"height:22px;width:34px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">start<\/span><\/p><\/td><td style=\"height:22px;width:30px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">end<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IRELAND<\/span><\/p><\/td><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2015-01-01 00:00:00<\/span><\/p><\/td><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2017-06-11 07:00:00<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">ITALY<\/span><\/p><\/td><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2015-01-03 23:00:00<\/span><\/p><\/td><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2017-06-11 07:00:00<\/span><\/p><\/td><\/tr><tr><td style=\"height:22px;width:97px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">NORTH_IRELAND<\/span><\/p><\/td><td style=\"height:22px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2015-01-01 00:00:00<\/span><\/p><\/td><td style=\"height:22px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2017-06-11 07:00:00<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

---
## Raw validations

```
rules:

- expr: observed==TRUE
  name: IS_OBS
- expr: is.finite(TotalLoadValue)
  name: IS_FINITE
- expr: sign(TotalLoadValue)>0
  name: IS_POS
```

```r
load_data_v <- antaDraft::augment_validation(load_data)
```

<div id="htmlwidget-dae1d5ff25b4505de70b" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-dae1d5ff25b4505de70b">{"x":{"html":"<table><thead><tr><td style=\"height:22px;width:58px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">DateTime<\/span><\/p><\/td><td style=\"height:22px;width:49px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">country<\/span><\/p><\/td><td style=\"height:22px;width:83px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">AreaTypeCode<\/span><\/p><\/td><td style=\"height:22px;width:62px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">AreaName<\/span><\/p><\/td><td style=\"height:22px;width:58px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">MapCode<\/span><\/p><\/td><td style=\"height:22px;width:87px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TotalLoadValue<\/span><\/p><\/td><td style=\"height:22px;width:57px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">observed<\/span><\/p><\/td><td style=\"height:22px;width:49px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IS_OBS<\/span><\/p><\/td><td style=\"height:22px;width:59px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IS_FINITE<\/span><\/p><\/td><td style=\"height:22px;width:49px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IS_POS<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:22px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2016-04-07 20:00:00<\/span><\/p><\/td><td style=\"height:22px;width:43px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">ITALY<\/span><\/p><\/td><td style=\"height:22px;width:33px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BZN<\/span><\/p><\/td><td style=\"height:22px;width:98px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IT-Centre-North BZ<\/span><\/p><\/td><td style=\"height:22px;width:56px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IT_CNOR<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">3612<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><\/tr><tr><td style=\"height:22px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2016-01-23 16:00:00<\/span><\/p><\/td><td style=\"height:22px;width:43px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">ITALY<\/span><\/p><\/td><td style=\"height:22px;width:33px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BZN<\/span><\/p><\/td><td style=\"height:22px;width:98px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IT-South BZ<\/span><\/p><\/td><td style=\"height:22px;width:56px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IT_SUD<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">3614<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:105px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2015-11-24 05:00:00<\/span><\/p><\/td><td style=\"height:20px;width:43px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SPAIN<\/span><\/p><\/td><td style=\"height:20px;width:33px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BZN<\/span><\/p><\/td><td style=\"height:20px;width:98px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">REE BZ<\/span><\/p><\/td><td style=\"height:20px;width:56px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">ES<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">26434<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(51,51,51,1.00);border-top: 1.00pt solid rgba(51,51,51,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">TRUE<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

---
## Raw validations

> Quality control summary to be sent to data provider

```r
qc <- load_data_v %>% qualcon()
dir.create(path = "qc/qc_raw", recursive = TRUE)
render_quality(qc, dir = "qc/qc_raw")
```

---
## Datasets creation (aggregate messy data...)

```r
aggregated_db <- aggregate_with_rules(load_data_v)
head(sample_n(aggregated_db, size = 10))
```

```
##            country            DateTime      BZN      CTA      CTY
## 52571  SWITZERLAND 2015-05-18 11:00:00  6853.79  6853.79  6853.79
## 76849        ITALY 2015-08-04 07:00:00 41414.00 41414.00 41414.00
## 194063 SWITZERLAND 2016-08-13 23:00:00  5047.89  5047.89  5047.89
## 50390      BELGIUM 2015-05-11 12:00:00 10928.13 10928.13 10928.13
## 216839 SWITZERLAND 2016-10-25 23:00:00  6804.77  6804.77  6804.77
## 164828     AUSTRIA 2016-05-12 07:00:00 72585.00  8772.40  8772.40
```

---
## Datasets creation - How?

```
ITALY:
  CTY:
    - IT
  CTA:
    - IT
  BZN:
    - IT_CNOR
    - IT_CSUD
    - IT_NORD
    - IT_SARD
    - IT_SICI
    - IT_SUD

GERMANY:
  CTY:
    - DE
  CTA:
    - DE_TenneT_GER
    - DE_TransnetBW
    - DE_Amprion
    - DE_50HzT
  BZN:
    - DE_AT_LU
    - "!CTY|AUSTRIA"
    - "!CTY|LUXEMBOURG"

```

---
## Datasets validations

.left-column[
  ## yaml files
]

.right-column[

Simple rules to run row by row:

```
rules:

- expr: is.finite(CTY)
  name: CTY_NA
- expr: is.finite(CTA)
  name: CTA_NA
- expr: is.finite(BZN)
  name: BZN_NA

- expr: ((CTY - lag(CTY)) / CTY) < .5 & ((lag(CTY) - CTY) / lag(CTY)) < .5
 name: CTY_LAG_LT_50
- expr: ((CTA - lag(CTA)) / CTA) < .5 & ((lag(CTA) - CTA) / lag(CTA)) < .5
 name: CTA_LAG_LT_50
- expr: ((BZN - lag(BZN)) / BZN) < .5 & ((lag(BZN) - BZN) / lag(BZN)) < .5
 name: BZN_LAG_LT_50
```

]

---
## Datasets validations

.left-column[
  ## yaml files
]

.right-column[

Some rules need to be filtered (false positives)

```
- drop:
    - CTY_IS_POS
    - CTY_CTA_EQUAL
    - CTY_BZN_EQUAL
    - CTY_CTA_DIFF_LT_05
    - CTY_BZN_DIFF_LT_05
    - CTY_CTA_DIFF_LT_10
    - CTY_BZN_DIFF_LT_10
    - CTY_LAG_LT_50
  when_not:
    - CTY_NA

- drop:
    - CTA_BZN_DIFF_LT_05
    - CTA_BZN_EQUAL
  when_not:
    - CTA_BZN_DIFF_LT_10
```

]

---
## Datasets validations

.left-column[
  ## yaml files
  ## Validations
]

.right-column[

```r
aggregated_db <- augment_validation(aggregated_db)
head(sample_n(aggregated_db, size = 10))
```

```
##              country            DateTime      BZN      CTA      CTY CTY_NA
## 39488     LUXEMBOURG 2015-04-06 13:00:00   398.60   398.60   398.60   TRUE
## 142290       IRELAND 2016-03-01 01:00:00  2894.07  2894.07  2894.07   TRUE
## 161866        FRANCE 2016-05-02 19:00:00 52105.00 52105.00 52105.00   TRUE
## 113993 NORTH_IRELAND 2015-12-01 08:00:00  1019.00  1019.00       NA  FALSE
## 110617            UK 2015-11-20 12:00:00 46367.00 46367.00 48911.00   TRUE
## 99693  NORTH_IRELAND 2015-10-16 12:00:00  1133.00  1133.00       NA  FALSE
##        CTA_NA BZN_NA CTY_IS_POS CTA_IS_POS BZN_IS_POS CTY_CTA_EQUAL
## 39488    TRUE   TRUE       TRUE       TRUE       TRUE          TRUE
## 142290   TRUE   TRUE       TRUE       TRUE       TRUE          TRUE
## 161866   TRUE   TRUE       TRUE       TRUE       TRUE          TRUE
## 113993   TRUE   TRUE       TRUE       TRUE       TRUE          TRUE
## 110617   TRUE   TRUE       TRUE       TRUE       TRUE         FALSE
## 99693    TRUE   TRUE       TRUE       TRUE       TRUE          TRUE
##        CTY_BZN_EQUAL CTA_BZN_EQUAL CTY_CTA_DIFF_LT_05 CTY_BZN_DIFF_LT_05
## 39488           TRUE          TRUE               TRUE               TRUE
## 142290          TRUE          TRUE               TRUE               TRUE
## 161866          TRUE          TRUE               TRUE               TRUE
## 113993          TRUE          TRUE               TRUE               TRUE
## 110617         FALSE          TRUE              FALSE              FALSE
## 99693           TRUE          TRUE               TRUE               TRUE
##        CTA_BZN_DIFF_LT_05 CTY_CTA_DIFF_LT_10 CTY_BZN_DIFF_LT_10
## 39488                TRUE               TRUE               TRUE
## 142290               TRUE               TRUE               TRUE
## 161866               TRUE               TRUE               TRUE
## 113993               TRUE               TRUE               TRUE
## 110617               TRUE               TRUE               TRUE
## 99693                TRUE               TRUE               TRUE
##        CTA_BZN_DIFF_LT_10 CTY_LAG_LT_50 CTA_LAG_LT_50 BZN_LAG_LT_50
## 39488                TRUE          TRUE          TRUE          TRUE
## 142290               TRUE          TRUE          TRUE          TRUE
## 161866               TRUE          TRUE          TRUE          TRUE
## 113993               TRUE          TRUE          TRUE          TRUE
## 110617               TRUE          TRUE          TRUE          TRUE
## 99693                TRUE          TRUE          TRUE          TRUE
```

]

---
## Datasets validations

.left-column[
  ## yaml files
  ## Validations
]

.right-column[

> made with package `UpSetR`

![](slides_files/figure-html/unnamed-chunk-14-1.svg)

]

---
## Datasets validations

.left-column[
  ## yaml files
  ## Validations
]

.right-column[

> This country is not playing the game ;)

![](slides_files/figure-html/unnamed-chunk-15-1.svg)

]

---
## Datasets corrections

.left-column[
  ## yaml file
]

.right-column[

> Corrections expressed by an expert

```
-
  replace: CTA
  use: CTY
  when_false:
    - CTA_NA
  when_true:
    - BZN_NA
    - CTY_NA
    - CTY_BZN_EQUAL

-
  replace: CTY
  use: CTA
  country:
  when_false:
    - CTY_NA
  when_true:
    - BZN_NA
    - CTA_NA
    - CTA_BZN_EQUAL
```

]

---
## Datasets corrections

.left-column[
  ## yaml file
  ## corrections
]

.right-column[

```r
corrected_db <- aggregated_db %>% 
 data_correct_with_rules() %>% 
 augment_process_summary() 
```

]

---
## Datasets corrections

.left-column[
  ## yaml file
  ## corrections
]

.right-column[

<div id="htmlwidget-68fe5cc7b9893808fa31" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-68fe5cc7b9893808fa31">{"x":{"html":"<table><thead><tr><td style=\"height:25px;width:68px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">country<\/span><\/p><\/td><td style=\"height:25px;width:80px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">corrected<\/span><\/p><\/td><td style=\"height:25px;width:62px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">invalid<\/span><\/p><\/td><td style=\"height:25px;width:67px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">original<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">AUSTRIA<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">5924<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">16238<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">BELGIUM<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 26<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 498<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">21638<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">FRANCE<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 1<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 406<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">21755<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">GERMANY<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 25<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">6366<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">15771<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">IRELAND<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">2752<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">1737<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">17673<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">ITALY<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">1287<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">20875<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">LUXEMBOURG<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">6575<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">15587<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">NETHERLANDS<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 3<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 889<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">21270<\/span><\/p><\/td><\/tr><tr><td style=\"height:22px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">NORTH_IRELAND<\/span><\/p><\/td><td style=\"height:22px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">18120<\/span><\/p><\/td><td style=\"height:22px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">4042<\/span><\/p><\/td><td style=\"height:22px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 0<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">PORTUGAL<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">1218<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">20944<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">SPAIN<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">1283<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">20879<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">SWITZERLAND<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 25<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 903<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">21234<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:106px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">UK<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 2<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\">21530<\/span><\/p><\/td><td style=\"height:20px;width:48px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:5pt;padding-right:5pt;background-color:transparent;\"> 630<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

]

---
## More corrections

Here we are trying to complete invalid data with predictions from a model (random forest)

```r
rt_by_country <- readRDS("rf/rt_by_country.RDS")
```

<div id="htmlwidget-a428dff81293b300f9b6" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-a428dff81293b300f9b6">{"x":{"html":"<table><thead><tr><td style=\"height:18px;width:54px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">country<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">rsq<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">AUSTRIA<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9764149<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BELGIUM<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9819185<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">FRANCE<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9878172<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">GERMANY<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9890159<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IRELAND<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9905824<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">ITALY<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9903253<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">LUXEMBOURG<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9562870<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">NETHERLANDS<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9882977<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">PORTUGAL<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9875154<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SPAIN<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9854585<\/span><\/p><\/td><\/tr><tr><td style=\"height:18px;width:54px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SWITZERLAND<\/span><\/p><\/td><td style=\"height:18px;width:54px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">0.9680463<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

---
## More corrections

```r
corrected_db = complete_with_model(corrected_db, rt_by_country)
```

<div id="htmlwidget-089de96b3565c396d007" style="width:960px;height:500px;" class="tabwid html-widget"></div>
<script type="application/json" data-for="htmlwidget-089de96b3565c396d007">{"x":{"html":"<table><thead><tr><td style=\"height:22px;width:49px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">country<\/span><\/p><\/td><td style=\"height:22px;width:58px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">corrected<\/span><\/p><\/td><td style=\"height:22px;width:44px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">invalid<\/span><\/p><\/td><td style=\"height:22px;width:46px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">mod_rf<\/span><\/p><\/td><td style=\"height:22px;width:49px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 2.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">original<\/span><\/p><\/td><\/tr><\/thead><tbody><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">AUSTRIA<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 26<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">5898<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">16238<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">BELGIUM<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 26<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 207<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">291<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">21638<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">FRANCE<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 1<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 367<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 39<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">21755<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">GERMANY<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 25<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 2<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">6364<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">15771<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">IRELAND<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">2752<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 946<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">791<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">17673<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">ITALY<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">1210<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 77<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">20875<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">LUXEMBOURG<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">1675<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">4900<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">15587<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">NETHERLANDS<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 3<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 2<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">887<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">21270<\/span><\/p><\/td><\/tr><tr><td style=\"height:22px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">NORTH_IRELAND<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">18120<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">4042<\/span><\/p><\/td><td style=\"height:22px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:22px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">PORTUGAL<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 218<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">1000<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">20944<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SPAIN<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 506<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">777<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">20879<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">SWITZERLAND<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 25<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 837<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 66<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 1.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">21234<\/span><\/p><\/td><\/tr><tr><td style=\"height:20px;width:97px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">UK<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 2<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\">21530<\/span><\/p><\/td><td style=\"height:20px;width:35px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 0<\/span><\/p><\/td><td style=\"height:20px;width:40px;border-bottom: 2.00pt solid rgba(0,0,0,1.00);border-top: 1.00pt solid rgba(0,0,0,1.00);border-left: 1.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);background-color:transparent;margin-top:0pt;margin-bottom:0pt;margin-left:0pt;margin-right:0pt;vertical-align:middle;\"><p style=\"margin:0pt;text-align:right;border-bottom: 0.00pt solid rgba(0,0,0,1.00);border-top: 0.00pt solid rgba(0,0,0,1.00);border-left: 0.00pt solid rgba(0,0,0,1.00);border-right: 0.00pt solid rgba(0,0,0,1.00);padding-top:2pt;padding-bottom:2pt;padding-left:2pt;padding-right:2pt;background-color:transparent;\"> 630<\/span><\/p><\/td><\/tr><\/tbody><\/table>","css":""},"evals":[],"jsHooks":[]}</script>

---

Thank you

Any questions?