File: Formatting.html

package info (click to toggle)
r-cran-openxlsx 4.2.8-1
links: PTS, VCS
area: main
in suites: forky, sid, trixie
size: 3,328 kB
sloc: cpp: 1,867; makefile: 2
file content (653 lines) | stat: -rw-r--r-- 106,855 bytes
<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8" />
<meta name="generator" content="pandoc" />
<meta http-equiv="X-UA-Compatible" content="IE=EDGE" />

<meta name="viewport" content="width=device-width, initial-scale=1" />

<meta name="author" content="Alexander Walker, Philipp Schauberger" />

<meta name="date" content="2025-01-25" />

<title>Formating with xlsx</title>

<script>// Pandoc 2.9 adds attributes on both header and div. We remove the former (to
// be compatible with the behavior of Pandoc < 2.8).
document.addEventListener('DOMContentLoaded', function(e) {
  var hs = document.querySelectorAll("div.section[class*='level'] > :first-child");
  var i, h, a;
  for (i = 0; i < hs.length; i++) {
    h = hs[i];
    if (!/^h[1-6]$/i.test(h.tagName)) continue;  // it should be a header h1-h6
    a = h.attributes;
    while (a.length > 0) h.removeAttribute(a[0].name);
  }
});
</script>

<style type="text/css">
code{white-space: pre-wrap;}
span.smallcaps{font-variant: small-caps;}
span.underline{text-decoration: underline;}
div.column{display: inline-block; vertical-align: top; width: 50%;}
div.hanging-indent{margin-left: 1.5em; text-indent: -1.5em;}
ul.task-list{list-style: none;}
</style>



<style type="text/css">
code {
white-space: pre;
}
.sourceCode {
overflow: visible;
}
</style>
<style type="text/css" data-origin="pandoc">
html { -webkit-text-size-adjust: 100%; }
pre > code.sourceCode { white-space: pre; position: relative; }
pre > code.sourceCode > span { display: inline-block; line-height: 1.25; }
pre > code.sourceCode > span:empty { height: 1.2em; }
.sourceCode { overflow: visible; }
code.sourceCode > span { color: inherit; text-decoration: inherit; }
div.sourceCode { margin: 1em 0; }
pre.sourceCode { margin: 0; }
@media screen {
div.sourceCode { overflow: auto; }
}
@media print {
pre > code.sourceCode { white-space: pre-wrap; }
pre > code.sourceCode > span { text-indent: -5em; padding-left: 5em; }
}
pre.numberSource code
{ counter-reset: source-line 0; }
pre.numberSource code > span
{ position: relative; left: -4em; counter-increment: source-line; }
pre.numberSource code > span > a:first-child::before
{ content: counter(source-line);
position: relative; left: -1em; text-align: right; vertical-align: baseline;
border: none; display: inline-block;
-webkit-touch-callout: none; -webkit-user-select: none;
-khtml-user-select: none; -moz-user-select: none;
-ms-user-select: none; user-select: none;
padding: 0 4px; width: 4em;
color: #aaaaaa;
}
pre.numberSource { margin-left: 3em; border-left: 1px solid #aaaaaa; padding-left: 4px; }
div.sourceCode
{ }
@media screen {
pre > code.sourceCode > span > a:first-child::before { text-decoration: underline; }
}
code span.al { color: #ff0000; font-weight: bold; } 
code span.an { color: #60a0b0; font-weight: bold; font-style: italic; } 
code span.at { color: #7d9029; } 
code span.bn { color: #40a070; } 
code span.bu { color: #008000; } 
code span.cf { color: #007020; font-weight: bold; } 
code span.ch { color: #4070a0; } 
code span.cn { color: #880000; } 
code span.co { color: #60a0b0; font-style: italic; } 
code span.cv { color: #60a0b0; font-weight: bold; font-style: italic; } 
code span.do { color: #ba2121; font-style: italic; } 
code span.dt { color: #902000; } 
code span.dv { color: #40a070; } 
code span.er { color: #ff0000; font-weight: bold; } 
code span.ex { } 
code span.fl { color: #40a070; } 
code span.fu { color: #06287e; } 
code span.im { color: #008000; font-weight: bold; } 
code span.in { color: #60a0b0; font-weight: bold; font-style: italic; } 
code span.kw { color: #007020; font-weight: bold; } 
code span.op { color: #666666; } 
code span.ot { color: #007020; } 
code span.pp { color: #bc7a00; } 
code span.sc { color: #4070a0; } 
code span.ss { color: #bb6688; } 
code span.st { color: #4070a0; } 
code span.va { color: #19177c; } 
code span.vs { color: #4070a0; } 
code span.wa { color: #60a0b0; font-weight: bold; font-style: italic; } 
</style>
<script>
// apply pandoc div.sourceCode style to pre.sourceCode instead
(function() {
  var sheets = document.styleSheets;
  for (var i = 0; i < sheets.length; i++) {
    if (sheets[i].ownerNode.dataset["origin"] !== "pandoc") continue;
    try { var rules = sheets[i].cssRules; } catch (e) { continue; }
    var j = 0;
    while (j < rules.length) {
      var rule = rules[j];
      // check if there is a div.sourceCode rule
      if (rule.type !== rule.STYLE_RULE || rule.selectorText !== "div.sourceCode") {
        j++;
        continue;
      }
      var style = rule.style.cssText;
      // check if color or background-color is set
      if (rule.style.color === '' && rule.style.backgroundColor === '') {
        j++;
        continue;
      }
      // replace div.sourceCode by a pre.sourceCode rule
      sheets[i].deleteRule(j);
      sheets[i].insertRule('pre.sourceCode{' + style + '}', j);
    }
  }
})();
</script>




<style type="text/css">body {
background-color: #fff;
margin: 1em auto;
max-width: 700px;
overflow: visible;
padding-left: 2em;
padding-right: 2em;
font-family: "Open Sans", "Helvetica Neue", Helvetica, Arial, sans-serif;
font-size: 14px;
line-height: 1.35;
}
#TOC {
clear: both;
margin: 0 0 10px 10px;
padding: 4px;
width: 400px;
border: 1px solid #CCCCCC;
border-radius: 5px;
background-color: #f6f6f6;
font-size: 13px;
line-height: 1.3;
}
#TOC .toctitle {
font-weight: bold;
font-size: 15px;
margin-left: 5px;
}
#TOC ul {
padding-left: 40px;
margin-left: -1.5em;
margin-top: 5px;
margin-bottom: 5px;
}
#TOC ul ul {
margin-left: -2em;
}
#TOC li {
line-height: 16px;
}
table {
margin: 1em auto;
border-width: 1px;
border-color: #DDDDDD;
border-style: outset;
border-collapse: collapse;
}
table th {
border-width: 2px;
padding: 5px;
border-style: inset;
}
table td {
border-width: 1px;
border-style: inset;
line-height: 18px;
padding: 5px 5px;
}
table, table th, table td {
border-left-style: none;
border-right-style: none;
}
table thead, table tr.even {
background-color: #f7f7f7;
}
p {
margin: 0.5em 0;
}
blockquote {
background-color: #f6f6f6;
padding: 0.25em 0.75em;
}
hr {
border-style: solid;
border: none;
border-top: 1px solid #777;
margin: 28px 0;
}
dl {
margin-left: 0;
}
dl dd {
margin-bottom: 13px;
margin-left: 13px;
}
dl dt {
font-weight: bold;
}
ul {
margin-top: 0;
}
ul li {
list-style: circle outside;
}
ul ul {
margin-bottom: 0;
}
pre, code {
background-color: #f7f7f7;
border-radius: 3px;
color: #333;
white-space: pre-wrap; 
}
pre {
border-radius: 3px;
margin: 5px 0px 10px 0px;
padding: 10px;
}
pre:not([class]) {
background-color: #f7f7f7;
}
code {
font-family: Consolas, Monaco, 'Courier New', monospace;
font-size: 85%;
}
p > code, li > code {
padding: 2px 0px;
}
div.figure {
text-align: center;
}
img {
background-color: #FFFFFF;
padding: 2px;
border: 1px solid #DDDDDD;
border-radius: 3px;
border: 1px solid #CCCCCC;
margin: 0 5px;
}
h1 {
margin-top: 0;
font-size: 35px;
line-height: 40px;
}
h2 {
border-bottom: 4px solid #f7f7f7;
padding-top: 10px;
padding-bottom: 2px;
font-size: 145%;
}
h3 {
border-bottom: 2px solid #f7f7f7;
padding-top: 10px;
font-size: 120%;
}
h4 {
border-bottom: 1px solid #f7f7f7;
margin-left: 8px;
font-size: 105%;
}
h5, h6 {
border-bottom: 1px solid #ccc;
font-size: 105%;
}
a {
color: #0033dd;
text-decoration: none;
}
a:hover {
color: #6666ff; }
a:visited {
color: #800080; }
a:visited:hover {
color: #BB00BB; }
a[href^="http:"] {
text-decoration: underline; }
a[href^="https:"] {
text-decoration: underline; }

code > span.kw { color: #555; font-weight: bold; } 
code > span.dt { color: #902000; } 
code > span.dv { color: #40a070; } 
code > span.bn { color: #d14; } 
code > span.fl { color: #d14; } 
code > span.ch { color: #d14; } 
code > span.st { color: #d14; } 
code > span.co { color: #888888; font-style: italic; } 
code > span.ot { color: #007020; } 
code > span.al { color: #ff0000; font-weight: bold; } 
code > span.fu { color: #900; font-weight: bold; } 
code > span.er { color: #a61717; background-color: #e3d2d2; } 
</style>




</head>

<body>




<h1 class="title toc-ignore">Formating with xlsx</h1>
<h4 class="author">Alexander Walker, Philipp Schauberger</h4>
<h4 class="date">2025-01-25</h4>



<div id="formatting-with-writedata-and-writedatatable" class="section level2">
<h2>Formatting with writeData and writeDataTable</h2>
<div class="sourceCode" id="cb1"><pre class="sourceCode r"><code class="sourceCode r"><span id="cb1-1"><a href="#cb1-1" tabindex="-1"></a><span class="do">## data.frame to write</span></span>
<span id="cb1-2"><a href="#cb1-2" tabindex="-1"></a>df <span class="ot">&lt;-</span> <span class="fu">data.frame</span>(<span class="st">&quot;Date&quot;</span> <span class="ot">=</span> <span class="fu">Sys.Date</span>()<span class="sc">-</span><span class="dv">0</span><span class="sc">:</span><span class="dv">4</span>,</span>
<span id="cb1-3"><a href="#cb1-3" tabindex="-1"></a>                 <span class="st">&quot;Logical&quot;</span> <span class="ot">=</span> <span class="fu">c</span>(<span class="cn">TRUE</span>, <span class="cn">FALSE</span>, <span class="cn">TRUE</span>, <span class="cn">TRUE</span>, <span class="cn">FALSE</span>),</span>
<span id="cb1-4"><a href="#cb1-4" tabindex="-1"></a>                 <span class="st">&quot;Currency&quot;</span> <span class="ot">=</span> <span class="fu">paste</span>(<span class="st">&quot;$&quot;</span>,<span class="sc">-</span><span class="dv">2</span><span class="sc">:</span><span class="dv">2</span>),</span>
<span id="cb1-5"><a href="#cb1-5" tabindex="-1"></a>                 <span class="st">&quot;Accounting&quot;</span> <span class="ot">=</span> <span class="sc">-</span><span class="dv">2</span><span class="sc">:</span><span class="dv">2</span>,</span>
<span id="cb1-6"><a href="#cb1-6" tabindex="-1"></a>                 <span class="st">&quot;hLink&quot;</span> <span class="ot">=</span> <span class="st">&quot;https://CRAN.R-project.org/&quot;</span>, </span>
<span id="cb1-7"><a href="#cb1-7" tabindex="-1"></a>                 <span class="st">&quot;Percentage&quot;</span> <span class="ot">=</span> <span class="fu">seq</span>(<span class="sc">-</span><span class="dv">1</span>, <span class="dv">1</span>, <span class="at">length.out=</span><span class="dv">5</span>),</span>
<span id="cb1-8"><a href="#cb1-8" tabindex="-1"></a>                 <span class="st">&quot;TinyNumber&quot;</span> <span class="ot">=</span> <span class="fu">runif</span>(<span class="dv">5</span>) <span class="sc">/</span> <span class="fl">1E9</span>, <span class="at">stringsAsFactors =</span> <span class="cn">FALSE</span>)</span>
<span id="cb1-9"><a href="#cb1-9" tabindex="-1"></a></span>
<span id="cb1-10"><a href="#cb1-10" tabindex="-1"></a><span class="fu">class</span>(df<span class="sc">$</span>Currency) <span class="ot">&lt;-</span> <span class="st">&quot;currency&quot;</span></span>
<span id="cb1-11"><a href="#cb1-11" tabindex="-1"></a><span class="fu">class</span>(df<span class="sc">$</span>Accounting) <span class="ot">&lt;-</span> <span class="st">&quot;accounting&quot;</span></span>
<span id="cb1-12"><a href="#cb1-12" tabindex="-1"></a><span class="fu">class</span>(df<span class="sc">$</span>hLink) <span class="ot">&lt;-</span> <span class="st">&quot;hyperlink&quot;</span></span>
<span id="cb1-13"><a href="#cb1-13" tabindex="-1"></a><span class="fu">class</span>(df<span class="sc">$</span>Percentage) <span class="ot">&lt;-</span> <span class="st">&quot;percentage&quot;</span></span>
<span id="cb1-14"><a href="#cb1-14" tabindex="-1"></a><span class="fu">class</span>(df<span class="sc">$</span>TinyNumber) <span class="ot">&lt;-</span> <span class="st">&quot;scientific&quot;</span></span>
<span id="cb1-15"><a href="#cb1-15" tabindex="-1"></a></span>
<span id="cb1-16"><a href="#cb1-16" tabindex="-1"></a><span class="do">## Formatting can be applied simply through the write functions</span></span>
<span id="cb1-17"><a href="#cb1-17" tabindex="-1"></a><span class="do">## global options can be set to further simplify things</span></span>
<span id="cb1-18"><a href="#cb1-18" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.borderStyle&quot;</span> <span class="ot">=</span> <span class="st">&quot;thin&quot;</span>)</span>
<span id="cb1-19"><a href="#cb1-19" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.borderColour&quot;</span> <span class="ot">=</span> <span class="st">&quot;#4F81BD&quot;</span>)</span>
<span id="cb1-20"><a href="#cb1-20" tabindex="-1"></a></span>
<span id="cb1-21"><a href="#cb1-21" tabindex="-1"></a><span class="do">## create a workbook and add a worksheet</span></span>
<span id="cb1-22"><a href="#cb1-22" tabindex="-1"></a>wb <span class="ot">&lt;-</span> <span class="fu">createWorkbook</span>()</span>
<span id="cb1-23"><a href="#cb1-23" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;writeData auto-formatting&quot;</span>)</span>
<span id="cb1-24"><a href="#cb1-24" tabindex="-1"></a></span>
<span id="cb1-25"><a href="#cb1-25" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df, <span class="at">startRow =</span> <span class="dv">2</span>, <span class="at">startCol =</span> <span class="dv">2</span>)</span>
<span id="cb1-26"><a href="#cb1-26" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df, <span class="at">startRow =</span> <span class="dv">9</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">borders =</span> <span class="st">&quot;surrounding&quot;</span>)</span>
<span id="cb1-27"><a href="#cb1-27" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df, <span class="at">startRow =</span> <span class="dv">16</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">borders =</span> <span class="st">&quot;rows&quot;</span>)</span>
<span id="cb1-28"><a href="#cb1-28" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df, <span class="at">startRow =</span> <span class="dv">23</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">borders =</span><span class="st">&quot;columns&quot;</span>)</span>
<span id="cb1-29"><a href="#cb1-29" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df, <span class="at">startRow =</span> <span class="dv">30</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">borders =</span><span class="st">&quot;all&quot;</span>)</span>
<span id="cb1-30"><a href="#cb1-30" tabindex="-1"></a></span>
<span id="cb1-31"><a href="#cb1-31" tabindex="-1"></a><span class="do">## headerStyles</span></span>
<span id="cb1-32"><a href="#cb1-32" tabindex="-1"></a>hs1 <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">fgFill =</span> <span class="st">&quot;#4F81BD&quot;</span>, <span class="at">halign =</span> <span class="st">&quot;CENTER&quot;</span>, <span class="at">textDecoration =</span> <span class="st">&quot;Bold&quot;</span>,</span>
<span id="cb1-33"><a href="#cb1-33" tabindex="-1"></a>                   <span class="at">border =</span> <span class="st">&quot;Bottom&quot;</span>, <span class="at">fontColour =</span> <span class="st">&quot;white&quot;</span>)</span>
<span id="cb1-34"><a href="#cb1-34" tabindex="-1"></a></span>
<span id="cb1-35"><a href="#cb1-35" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df, <span class="at">startRow =</span> <span class="dv">16</span>, <span class="at">startCol =</span> <span class="dv">10</span>, <span class="at">headerStyle =</span> hs1,</span>
<span id="cb1-36"><a href="#cb1-36" tabindex="-1"></a>          <span class="at">borders =</span> <span class="st">&quot;rows&quot;</span>, <span class="at">borderStyle =</span> <span class="st">&quot;medium&quot;</span>)</span>
<span id="cb1-37"><a href="#cb1-37" tabindex="-1"></a></span>
<span id="cb1-38"><a href="#cb1-38" tabindex="-1"></a><span class="do">## to change the display text for a hyperlink column just write over those cells</span></span>
<span id="cb1-39"><a href="#cb1-39" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="at">sheet =</span> <span class="dv">1</span>, <span class="at">x =</span> <span class="fu">paste</span>(<span class="st">&quot;Hyperlink&quot;</span>, <span class="dv">1</span><span class="sc">:</span><span class="dv">5</span>), <span class="at">startRow =</span> <span class="dv">17</span>, <span class="at">startCol =</span> <span class="dv">14</span>)</span>
<span id="cb1-40"><a href="#cb1-40" tabindex="-1"></a></span>
<span id="cb1-41"><a href="#cb1-41" tabindex="-1"></a></span>
<span id="cb1-42"><a href="#cb1-42" tabindex="-1"></a><span class="do">## writing as an Excel Table</span></span>
<span id="cb1-43"><a href="#cb1-43" tabindex="-1"></a></span>
<span id="cb1-44"><a href="#cb1-44" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;writeDataTable&quot;</span>)</span>
<span id="cb1-45"><a href="#cb1-45" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="dv">2</span>, df, <span class="at">startRow =</span> <span class="dv">2</span>, <span class="at">startCol =</span> <span class="dv">2</span>)</span>
<span id="cb1-46"><a href="#cb1-46" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="dv">2</span>, df, <span class="at">startRow =</span> <span class="dv">9</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">tableStyle =</span> <span class="st">&quot;TableStyleLight9&quot;</span>)</span>
<span id="cb1-47"><a href="#cb1-47" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="dv">2</span>, df, <span class="at">startRow =</span> <span class="dv">16</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">tableStyle =</span> <span class="st">&quot;TableStyleLight2&quot;</span>)</span>
<span id="cb1-48"><a href="#cb1-48" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="dv">2</span>, df, <span class="at">startRow =</span> <span class="dv">23</span>, <span class="at">startCol =</span> <span class="dv">2</span>, <span class="at">tableStyle =</span> <span class="st">&quot;TableStyleMedium21&quot;</span>)</span>
<span id="cb1-49"><a href="#cb1-49" tabindex="-1"></a></span>
<span id="cb1-50"><a href="#cb1-50" tabindex="-1"></a><span class="fu">openXL</span>(wb) <span class="do">## opens a temp version</span></span></code></pre></div>
</div>
<div id="use-of-pre-defined-table-styles" class="section level2">
<h2>Use of pre-defined table styles</h2>
<p>The ‘tableStyle’ argument in writeDataTable can be any of the
predefined tableStyles in Excel.</p>
<p><img role="img" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgQAAAKhCAYAAAAv07bLAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAH8OSURBVHhe7b1rsFzVmaZ5JqJnIqbnT8fETERP9ESMf/SPmYjuiqqeGs8MdJfdNVWu6vaNdnd12S4by2WMMdgFbRuML4BMlTHYbSwwYGMuJWMhYwM22BgDQiAhClsyQlj4yOggIXExV0noArohsWZ/O3Ods3Ltd+9v7aM8qbW//T4Rj0/mzm/tzNSx/b65MpWacoQQQgjpPSwEhBBCCKkvBJvv+lv3wFd/34TyXAghhBBSDywEm+/+O/fA1/7Aud+dbUJ5LvKcCCGEEIKBheCB//qvnHvm06YsnxMhhBBCILgQfP3/dG77p0xZPqeCh9atp5RSSmkkLgSX/qFz2/6LKcvnVCBPmhBCCCGj4ELwjTc7t/XMJH+yaqO7/f6N7idDb1/1a3fb/b8ujhU/73u09MfiSnFD6Y/ufcTdOvSWFeL60pvvebj0h3f/yv3wroE/uGtd6U0/X+e+f+fa0gObznBHZj4JH0+d5XMq8IXA0ocmrckPgRJCyOTBhWDJ/+3clr9J8vaiELxRrCl94w139OjA1wu/9O1V7vCRN9zh14+6w4ePukOFBw8fcQcOHXGLv3W/23/wdbf/wOvu1f0D9xbue/VwedvufYdLXynctfeQ27XnkNtZ+OUrb3Qvrj3FHZg+HT6eOsvnVCCFwNqHJq3JD4ESQsjkwYXg8v/XOXkFnqDsChQ9wB0NysARKQRFEfjSt4pCEJaBoggcPHR0rhAcOFIWgX3eV4tSUBgWgl17C4dlQPzsxVe7p1cvcq/9+jT4eOosn1OBFAKLH5q0Jj8ESgghkwUXgm+e4NzmTyQpbxeEOwO+DIiLpRDM7gwMisCBg0fc/kIJ/XJn4EBRBF4buPfVQQnwhSDcGdi5+5B7ufD0L3zdPb3qQ+61Rz8GH0+d5XMqKAtB+KFJkhfRh0Bn+cUjNCdreOiVR2hG1vLytTQna7jgggsmKi4EV/xr5x4vgjRB+axA0QHKIjBbBl4fvE0ghWBQBAa7A1IIpAyEhUB2BmRXQNwTFIJXZGegKARSBHaUHnQ7XjnoTjn7Yvf0/UUh2FAUAvB46iyfU0FZCMIPTZK8iD4EOgsKJXr8rAGFEj1+1oJCiR4/a5CQ3rt378Q89kJw36/dkaIEiH5nQMqA7ApIsM/tDBwt3yJ4rSgDUgTktrIMvPb67NsDonxmQG4rdwZ8ESgdXD9r8WXHXgjCD02SvIg+BDoLCiV6/KwBhRI9ftaCQokeP2voXCGQv0Ww+NurihAv9D+9V93vLvjWfe4C+XnVfe78oeddeZ/7YuF5V6x0Xyy9133hm+JK9/nL7531c5cVP4vj5xezX/37Ne6amx9yV159/bEXgvBDkyQvog+BzoJCiR4/a0ChRI+ftaBQosfPGrpXCO5/1L1+5Kh7XT48+Pob5c7AofItgqNlCVh6/6GB9x1yf1/8/Pvi5/WFX7ziPnfdyoOl1947dMVBd03h5y5b4b6z4oC7+p4DxbEDbvkDB93P1u1xN/zgTnf7nfe6p1d/1L36yDEUgvBDkyQvog+BzoJCiR4/a0ChRI+ftaBQosfPGjq5Q1D+TYLh3yYo3yIo3yY4Wu4GSBmQEuC9/r6Dg0JQvPIvC4EvA4XXFEoROLcoBFIGrrn3gLth1UH301/tdzfffo+75cc/dU/97nk3s/ZKt3f9qe7opjPgY0KOFILwQ5Md5s5Tp9zUqXcOrxkh+hDoLCiUxumlf+Gu/Zdnu1fQbbRqDSiUjosP/Ec39YXPuB+i23pkLSiUOuS2K6bctVecCW/rpDWMtxBscPsvm3KHz/uwexXePoZC8OP7Ngx2BopC4D9AWHrwSLnVP1sIZncHBrsC8vZAuDswKAMDz12ywn2nKAR/X9x+6y8OuR/f/bD79re/43bv3u1e3rHDrXvgB27nL09xhx/7OHxMyJFCED4/QBm0U1PuhCVPDI8MeGLJCVkFsMlCEP2+ZqmE0u1uw7/879y1U6F/4bZV5hJlIWhnDSiUSjd/xv2LDxf/fQ086QEwNy5ZCEprAaFUhuxHp9ytN3955PgrN//zsYbvOM7X+0Lw8IeLYJdwH3rZxW4fmhtxUoVA3iaQ3YFhGSj/JsGBI+VnBeZ2Bub0hSAsA9esOFCWANkZkB2C6+494L6/5qD7+S9fdJcuudxt2bLF7du3z61du879YNm33PNrPuwObly4QnDCCUX4T53qwrhlIZgA0e9rlkooDQrBrWfdPnL92pO+Gcy0kIWgnTWgUCrDuVIALncnffg/uq+Hc+OUhaC0FhBKErK3nl+E9Uf/yG0LjrMQTMAaUCHYd/ebByVg+S0jxw7evWFkruoECsGPVm4odwbCMiB/k+C1shCsLMqAvEVQuFKKQFEIhrsCn7t8xaAMDHcFSoeFQD5I+L1VB93PfvWqu+Lq77oVK1a4A/v3u02bNrkf/OAH7rwvnuueXb3I7X/0NPiYkK0LwZI73ZITRgO3WgieGMxMecMCcac7deoEt2TJqcFtMl8ce0JuC9eE55Hbh6cQnljiTpidnXLh3bMQhIXgEffKWX8wGuo/PNvdGuwg3HepXxvf9gduw1ksBK2soRpKEvwpuwG3uzO/UPz3eXYHIS4Lyu0jOxC/5868mYVArAWEUlkIbj7TbTh/NGyrAf7lwcxHvWGBGNx232p/vXD1H7lrz3+ve6Wyzu9GnOnu++g/dxtuLubC802/190azIbn7G8huMUdKHcF6kM93j2YKwqgEGy72B0MZo99h2DlI41/y+CL31zpvlD+LYLip//bA8O/QSA/5e2Bz5beU3puURS+9K373ZU3rXXfu/kut/S7N7gDBw64p595xt1yyy3ukksuce/9i7e7Z1YtavU3DdoXgiKVyzCeC+jRQjAM8bgwzJYCH/phSfDB74/NFQF/mvIcJywpbhGKc8xejm9jIUA7BHPXv+nuCwJ+tCyAWSkGLATp1lAJpXJ3QNsJGIb9Ny+fPfbDm38vWJd2+7+4+fbh7YMSwkJQ/3tCoTQoBEVAl0FcBPT04HhcCOIwLm8vA1+uNxWCYH4kzKUQBEXAH4vXBNd7Wwh82Ae7AyNKwM++fRAXgPj6sFzMzt9y7IXg1ns3uMEXDg13B4bfPijfNSBlQHYErpe3CsodgoPuWr9DcNmKkd0B2RmQHQJ5q+DrN/yDu2PNdnflt77tduzY4V7Ztcvdcccd7sorr3Qf+MAH3A8uO8k998CH3QH5+mLwmJDzKgTDyz6ERwpBWRbCsBeGuwLl0kEhGM3rQQEIj42WjII7ZUchPu+Q6D5ZCOZe/c++0v9hPDe03BEYfsYgvOzlWwbtrKESSlEhGAR58d/b8FV++eo+Lg0S6sUr/c3zvJ1vGZTWAkJpthAML/sAHgnwqCwMHL7CL4/NvxCMrIkt73euMPS1EKC3C5p8dbkUgDe7/dvkelQIhuUifKvh2N8yuPeRkbcJyq8iLsqAfBWx7ApIERh8kHBYCIZvE8huQFgGvn2PfJbggFu2+qD77m1r3dcvu8p9/6ab3LO/e9Y98MADbunSpe60005zX1j8ZffkvSe7XWtPca//5nT4mJAjheCqf1Mck7+hUAgIC4EPdrk+Et4wuMPAH08hKG8vdxq81gvB4PdS/o5CKqFUfcugDPWgFJS7AiOFYVgCyjkWgmOyhkoo1e0QhMfhzOBVf/lWw3xul2MsBMPfCgCEUlgIfEjL9WohkFfzseMvBOXcyH2wEKg7BIWDEhCKC4EvFwcenlt7zIXglqIQSBF4rdwVODL77YPyVcTy9kBZCMIyMLQsBOVnBopCcPeBohgM/4rhuoPu1p+uLF5J3OJ+9rOfuauuusotW7bMnX322e6cL37Ffe3by9xT933I7TuWv3bYqhAUDEN6yaR3COLS0YsdgmMoBMOt//KzAnHoc4dgvNZQDaWazxCEIc4dggWzFhBKo4WgUIK8COENlUIQbu3HjqkQDO979n64QzBw9j3/4HMAgXHIN+0Q+Nmx7hDcsmL9oAwM3yYo/5Gi1w6X/y7B5y9fMVIG/BcPDXYI7h6+TSDHD7il9w3+iuEd9z/mLr30UvfII+vd5s2by52BxYsXu1NOPd3dvOp5d/bfXXns31TYthAMg7x8hT4bwMNjQSCX4R6+/z/mQlAWABaCocoOQVQItp0U7BAMi8PsWv8BQxaCdGtAoeTfJhgpBSOv6ms+IzAb6Nrtg9Ix+xmCsiAU8ywEw98KAIRSpRCEHwKcDd/BsdG5UUfC2u8oxIUguJ5SCMpzshCUzu4AhLsED3+4DPZByPsC4D+AWPOWgS8X4/wMgRSC8F8s3CMO/5Ei+ZsEgzJwaFAIZHdA3iYoSoDsEMh1+YzBjQ8cdD/65UG34lcvuiWXXuzWPfxoWQS+/a1vucsuu8x95JRT3Y13/tYtW3XAfexzXzv2QvCttxTH2hSCgvLVeRzAg9Cf3c4PPvDnbzumQlBenTv/CUuWFOfsSSGQ31FIJZTQZwhG/ybBoAQMvPWss4sSEO8Y+NuL43KdhSDdGlAolfqQDpz7EKA4CPXZ2ythrtw+cv6iaMh1FoLhbwUAQqlaCAp9oI+Eb1AUvCDgZ7f5ox2C8G2Hwf3htwwGJcDPvbeYYSHwzn6WwBuE+qAEDDywXN5iqCkE4sjfMnjzGArBPetd+e8QXD749wjm/hbBilL5WwTnXjb4GwTiOd+4u/wps3/3ndXum9//hVt20+1u6XVXu+Xf/JT7yXc+7bbP/NqtXLnSff2/ft2ddtrH3VevWO4uveEfynP/9We+cuyF4Op/WxyrLwTkOOILgfyOQlAo0eNnDSiU6PGzFhRK9PhZQ10hWCiPuRDcfM/Dg7cIxOBfLJR/uvjc4S7A7M7AigPFzwPuupUH3EXXrnY/XfOsu23ZN911n3+b+86Ff+ku+9Qfuy++//9wV5//Lvf9pZe7T5z5aXfh165zNz9UrLtnv/vmz/a7D3/6y8deCL7zxya+utgk/quL5XcUgkKJHj9rQKFEj5+1oFCix88aOlcIfnh3UQiGbxH4MvBKUQakEMhOwOy3EEoZuHfw1wpvXHPIXXfbI+62m653V37mLe6uaz/p7r/+NHfTV9/n/u4j/8pd8ok3uy+c8W537vlfcbes2emuLwrElXe+5i6/4zW36FNjKATX/sngH9F5gv/aYXbI70T+cSP5HYWgUKLHzxpQKNHjZy0olOjxs4buFYK7Hp79zMArewdKGdi1pygE3xgWAvnwYFEIri3/WuEhd+evXnV/f+tD7nMXFa/+r73QrfjOR9wPzzvBfe3j/5f78kf/0H3uA//CfeG0P3U3/WxDMX/Afevn+93lP9vvLhtXIbjuTwf/zK782/skL+R3Iv/8sfyOQlAo0eNnDSiU6PGzFhRK9PhZQ+cKwQ/u+lWlDOzcPfAcKQTlhwgHbxV8d9VBd/u6Q+7uh3e5Uxb/2P2ns3/k3v+ZZe5vzzvLXbX4Q+7qC//KffWsP3Nf/NDvu0vO+c/u5pVPlSXiip+9VpaBy346pkKw9M+c21YEz7azymMkI+R3Uvxuyt9RCAolevysAYUSPX7WgkKJHj9r6F4h+Pmv3Cv7DrlX9gx2BXwZ2FF49qV3D3YGilIg/6aB/LXC+ze+5j5z8Y/cO/7mB+5DX7jZffKSO91nvvYz9/Hzv+cuu/A0d8kn3lruEFz65c+7mx541X3rrv3lWwVLijIwth2C7/65c09/aiDJi2cGv5fydxSCQokeP2tAoUSPn7WgUKLHzxo6WAjWuUuvu9X93RU3us9+5Wp3+he+Xoa298Ofvsid9rmvuc9fcrW74cer3LW3/NL9+Zm3ufd/9hZ35sU/d+//wu3unWfe4j564R3uk+df575wxnvcFz72DnfJ15e4z/zdFe6Ucy4eOZ94zIXghn/v3O8+M5DkxXOD38uaG94+PDAEhRI9ftaAQokeP2tBoUSPnzVIIZikx1wI5N8TePEf/roM6SafvP8T7qd3rXD/+dwfufd86RH3Vxdtcu8552funZ/+ifvYV3/pPv6Ve91HzvyK+y9nfMxddcGfu60rPui2rzwZnkvur82/YyCOFILvFWHz4tmF5zj30med2/E553Z93rlXvujcnvMG7j2fLqT+z3l38Wcuf/byO5DfhfxOCtd87x3l74sQQshkOOZCcGT69DKc5RV7nXse+YS7/76fuL/49HL3rgt+4/7kvO3uj8951P27c3/l3vPpoiCc+T130ieXuo+cca678bL3l0Xg5V98xO1dfyo8n9yf3C96PHWGhWDzL65wa2585yCEdkoR+EIRTMMSsO+Cga8upgup/3OWP3P5s5ffgfwuit/Jgze+q/wdEUIImRzHXAhSvO3uu92/+dQD7o/OvN/98Sd+7v70jB+5t52+3P37j3/Pffjsq9w3vnG+W/n9j7ttKz/kfvfAh8t/uOjgxo+3+rcKNMNCIEjgPLDsnTRDWQYIIWTyTL3xxhsuduS7/mP9F/q08PXi1fye4tX+8w9+2D296kMVpQS89IuPuN0Pf9TtL179H/5NUQZ+O7/7cpujxztUnpM8N18ICCGEEDLHRAqBhPvBxz7uXnv0Y1ApAYeK249sOh2ubyd4zIUsBIQQQkg9EykEkxU85kIWAkIIIaSe3heCt7zlLTQjSbdBf5WJHj9Jt/nJT34yUVkIihC68cYbaQayEHSfMoQevppmIAtB95GQLn6ZE5OFYFgI/CtUenxkIbABC0E+shB0HxaCYxY85sKUQuBfqdLJykJgBxaCfGQh6D4TLwRHjx51sVYLgTw3FoL8ZCGwAwtBPrIQdJ+OFIIPuAtPPNGdGLjoG6cEobzQyv3/iVu2Gt0GHnPh+ArBg+4pWbjnMXcHvH2e3vGY27MQ5614h3usvKOn3IPw+uTNsRBsuvkCd+Xql4fXSCosBPl4fArBE+7IFVPuyPTw6rEyfao7fMUS98bw6jg5+sMpd/iHdw6vVa/nQIcKQV0gT8IJFIIHy9ifYzaoMykEtY9P01YhkOCW/+Mb8eZNw1vny8tu9ZUXuGM+TSLlc5jUnS0wZQhFwfTgp85xb/nUpZXjC+VTX/3iRO8vV8vfRTL1QV4GZXIoT7gQvLTEvX5e8fi8LcpDVwvBnadOuampKXfCkh+PHH9iye+5qVMvGznWJJpfgEIQ7h6EM4M1F37mT9yJ7/sL91R4fbjDsOYzw3Wf+cBwzSlu2fv8ufwuRHh+tDMBHnNhm0JwxyAhi4x8cOTYnsfuKC4f/0LQ/Piq86NaKgQLFdyb3M0XXOkms0EweA5WdiNYCPJxXIWgHRMsBHLbeSe4Iy8Nrxe8sfoE9/rqJ4bXmulyITjhhCLMp97j7gyOj6kQHCmCctS0QjAXyuKFNw0CWUJ9NqRvescw/OfWzAV4cH31X7hF/hzl5Xe4NeVMqMz743J5PjsERxIKwTDwawNyrhA8FrxIf+rBcMaHrGePe+yO4HYf/kPKtVEh8BsA1ZDXHp/YdP+WCkF9cFdedW+6ufg/yOHsy6vdlVeudptWX1n+n2ZpOCu3X3BzcXZ/NZgbrpsNcHCuONxr15f3MzxeGjyX8vHO3TZyzug+r1y9uvhziIpR9BwmhTyeOJhGC8E33fL3n+O+vPRS9+W3FMdLv+iW3+nn5Xa53nS7rPfXC5d+yb3l/Re7p4a3DdYMPOWr35yb65nl7yIZZYdgNij93J3uyOwr8zCUo/NUQntw++wr+vNOdUeHt5SMvOIv1q2uKwSD+28uHs331elCsOQyt+SEqZFArwb8jwczU15fIOLjc7sNU0ePFCUgcv47BPHx8HrqbdGclIph6ZjbcYjPFQoec2FZCIrnphYCn8TBq+9RfSAPg7wS0NWAHZzSX58rFIOdgOK6XA4LwVwbqO4WqI9Pu39DhUBCswjG0fgdUgbiMGDDMlDeNAxon6DDYJ67Wtw+PO9gtloORmbDc5X3Fc/Xry8OVII7XjOYqd7nXEmo7jIcr7ch5HHFwYQKQRjy2u3lK/63fMk9GNyOC0Ewzx2Cwe8imXaFIAx5XBiKi+AVfBy68op+LvAHa+de4Q9LByoEZXGIykRE831Vb4+v50B9ISgC/IlPuxOmfs8teWJwfLQQDEM/LgzBrgLcIThShGRsNoWgssNQd65Q8JgL5TnJc9MKAdqOHzUOdB+4w1fhPtjD9cMQLwvE8HLllf9sIdgz+FkT0Orj0+7fUCGYDePAMAPLULyyeDUe7SIMjodFQnYa5tbK7YNwBW9JhEWjoHKukZKirx+dF0Yfy4DRwK8+/uGx2UWTfMtjlDKEomDCOwTBzEigg9sflt0CXxBYCFItfxfJtCsEI3Mj2/rD21dLYI+WgUGIR8fK0B8eQyFf95ZBWTYaCoF2XwWdLwTDy1MnfLr4U48CviwLo28pOHeZO7W2QBQWa8ZcCLS3DMI1dQEfXJb1/vME5U4Bmo8Fj7kwtRAk7xDUFQK/HiCB7AN9EM6BPshnqQlo7fEp92+pEMwFdw3lq/V4BoT0SIAGt8fhLSiBX5YUf0BdP3gOI6/ky8c8umMweHz+ftDjH97v8Lwjj2HCLFwh8MdYCFI9noVgdsu/Ugj8baHDORTyx1QIGu6rwEIhGIT84PpIwN/5npHdgIGDXYNT7xxcTy8E3yr+jzkOVR+4M+IHB4H8wCeLk8TKbcEW/+xMvCa83nR5eK6z3zGyfs3Zg+OLlny0vO5mRF8KCqPHL89JnptaCGaDuS4g0wpB3Qf8fCGo3yF4zD04nIGhrz0+5f7tFAIcjLOUwXqlu/lm2UUIA7b66jkM05HbK+E8uM+mV+IjJUVdD54DKgQjx6r3WTI7U3P7hOAOQT4e1x2C4vZ4ix7uAIS02SEoX+3jx1ui3VeBjUJQOAz/JePZIXi9CMpR9UIwCOWsTCoEryd8qNAHfEG07T4IWaUQ+NvrAjYI/sH6Yl4ujxz35wg/DDhn0uOru38rhQC9+vaM3CYBGYRuGZxBaJezwe3l9WH4jpxnGOaVtWF4R/elrY/nhfLxBc9r+Pjq73PI8L6uLO5j7vwRI48n4fo8GFchqHyGIAj8kfPdebE7RT5AGBeC4HpfPd6FwF+O19b/LYBByM/e7l/lw0IwLBzRLsTc3zLQ7stQIQg/JDgb8DWfIRi+vYCuy5qpI68XJSDSbCEonltKIRBn36v3hAE+cj0uBMHMCEHgzr7KF4br4qLgUz+4n9D6xyc23b+RQjAM9lGLoCxDbTRkq9vpq2fDWaybLa5Fc6Ov6EdnCyqB2rxeKN8ykNuD88wem103vKGgcp+zDMpF41sFIzsNBdr1eSCPNw6m+e0QhH/LwH+g0BvdFu0QzJaEQv4tg1SG4T27tS4Ownb+hUCIQh7dT2UXwd9WvMKX6zWFQBiUgppzKfdlpxAUljsCowXAv50w+7cJRsI/WFPozzf1ehGSsVYLgTy31EJAJ+e8CsE8UT930FXKMnJsYT4OUCFoJygMdF62KwQkR1AhWEhZCFgIjruTKwTVV+g2AG89HCdYCPKRhaD7sBDMVxaCzjq5QiDBefxfRY+b8i0G+DbC5GEhyEcWgu4z+UJw+LCLPbZCEPzNgFnDv10QG/6tgja3RaYUguK5sRDk5+QKAVlojr0Q0HHJQtB9Jl4IDhchGTueHYLUMJ9cIZDn1lQI6PGThcAGLAT52FgIFv83NCdrmHgh+PRnznGnnX7GaCG4+t8Og/Qjo/+4UPl3/v/GuS1/4566bPCPEp144jvdmq1nOlfx5EGYP+ivf8wte39wrss+Njp32Ttnb7vw5rpzyPXhOc45eXhsaPGY/vaLHyk97+wPuM984j+6j//1n80VguI5NRUCevxlIeg+LAT5yB2C7jPxQvDXp5zqDh06POID3/njYEdg+Ap8i4RxEf5PnuXctkXF5Xe5Nds/5VytMvOnbtkv6m7z6+VyEfCfXTS47dZ3FYEf3jZ3jjWfLcrCrXL540W5iM697b84Vzy2cz/1Xvc3p73LfeQD/9/gsQ+fhzwneW6oENB8JN1GQojmYy3oVSo9ftYghWCSTh06dKgIylEfuPZPhkXgb5z7QfiPCxUh/MtPO/fMGW7ZXxXXP/fXzj37mRr/ehDm64Jjt0nYB+cqb4vnwuvxZb924IW3+TWFzxQ+XTy2ohyc/Jd/NNg1kMcvFs9FnpM8t7gQEEIIIcS5qYMHD7nYB67703IL3t38Tnfi+//SPbW9ePX99PDV+q/Oce75zzr3wmfdU996WxHMJ7k1xWW5Puopxfzb3LJHhtd/epI78QPvd09Vbovmam+L5yLlMf2ueGxSDspiMNgx8G8nyHOS58ZCQAghhFSZOnDwoIt9YOmfObetCNJbikIgW/lPf8q52+XVfRHIG4rgfelzzr0snumWfaA49qi/HvrRQYD72372H9yJX/jo3OXZ22TuRLfo6uL+itueurooGR/4K/dU5RxyX3NzFeUxvXhuUQyKUvC7YSl4qigF2+QtjjPL5yTPjYWAEEIIqTJ14EBRAiIf+O6fD0pAuSsw3KL//EmDcP71553beerc8fNOdW7XF4AyU8w/Fl73a94T3DaYu/A82W2Q2+M1wfXHPuAW+XOc+B63Zva+CncW7ige20tFKZAdg+fOdu5ZeXtDnsenyuckz42FgBBCCKkytf/AARf7wA3/fvAqW3y+CNYXi4CVV+E7i8CV8H3li4XnZWbxmMpiUDxGeazymOWxPzd4HmtueHv53KQQUEoppXTUqdf2H3CxD3zv7UWgShE4p3jFXQTrjiJgdxVBK6G7pwhfce/5eekf124pBsVjlccsj12eQ+Ga772j8jwppZRSOnDq1df2u9jpNUvcmhvfOQhVecX9SvHKe/ewBOy7YOCri/PSPy55jPJY5THLYy+ew4M3vqt8Tui5UkoppXQ/LgSiBOgDy95pQpYBSimltNmpfa/ud8h7Vq52t/30Lvf9m2+jlFJKaUeVLJdMR1kfWhSC14oLo8rCx6Z/O/zcISGEEEK6jGT6oBRUM987tbf4j1hpE57de1+jlFJK6XHy5Z2vuOlNj7uVqx50d95zf7L33r/GPT6zZZjmrsx2lPneqb37iguRssUgoAdGKaWU0skphWDFfQ+4p5/9ndu7d6/bs2eP2y3u3u1eeeUVt2vXK27nzl1ux46d7uWXd7gXX3rJPf/Ci27rtu1lKZD1gmQ7ynzv1J7iP2JZCCillNI8lECXV/x79+1rVQiee/6Fcl1YCHbs3ON27trjdu3eV5zj1ZHsLwqBHBiVhYBSSinNw3EWgmeffcm98PwO9/KOYt3u4lxB9k/t2VtciGQhoJRSSvNwnIXgic3Puu1PPudeeG5HsWbPSPZP7S7+I5aFgFJKKc3DcRcC8ZmnX3Iv7dhdnH8u+6fkPYTYtEJwrztP/pGh8+8dOT593cnlPz70wes2jxyvOH29+2Dt3GZ37cnVc1NKKaV9UysEVy9/KL0QPF4UgsKnt73gXnqpKARB9k+9smefiz2WQpBsYyE4xnNTSimlRmwqBFIGvCmFYObxZ0q3b3vevfDirpHsH38huPuCcofgvLsH1/2OQWh5my8EJwe3l+ca7g74Yyde4O4Oz08ppZT2yLpCEJYB7zEVAvmrB7FjKwTDy34X4O7zByEfFoITT77eTc/edrK7dlrOwx0CSimlVESFAJUBb1Mh2FyUAXHbk88XM7tGsr8oBHuLC6OOqxAMdgd8yI/eFr9l4HcSyttYCCillNLSuBCgEhBbXwieLt325HPFzM6R7J/a+cpeF7tQhWAk9FkIKKWUUlW0QzDfv2Xw+G+fLn1y63PF7TtHsn/qpZ17XOy4CsHoWwZznw1ILgTDtxNGzk8ppZT2yHEWgk3TT5VueeI59+zvdoxk/7EXgsCwBAyCfe5zA+LgA4TDHYPGQjB3nR8qpJRS2mcnVgh+9+IuF5tWCNpblgO+6qeUUkqTHWch2LhxW+nj8sHCp18cyf6pry35losdWyHwf5PAyzJAKaWUtlIC/Z6Vq93vnnu+VSF4Yuu28p9MDgvBN75xfeml37jW/ddvXD2S/VMPrV3vYhdqh4BSSiml7ZRA3/ibTeU/gSyv+FOVMjCz5cmRQrDinodK77vvl+6BB381kv1Tv3l8i4tlIaCUUkrzUAJddgJeffVV99prr7kDBw64gwcPukOHDrnDhw+7119/3R05cqTWsBA89NDG0nXrfuM2bNw8kv1T25553sX6QkAIIYSQ48s4C8Ejj8yUPvbYVrd5yzMj2T/1naXLXSwLASGEEJIH4ywE37nmBwOvvcl95/rvj2T/VDkVwUJACCGE5ME4C8Fzz+wo3fnSHndg/6HyuIeFgBBCCMmYLAvB1NRU79R495dW9k6NVSe9s3dqXLPifb1TY/EpN/ROjbff8lDv1Dhw1dt6Zwx3CAghhBDCQkAIIYQQFgJCCCGEFGRfCND77V4EmvMi0JwXgea8CDTnnS9vXnR5rQg050WgOS8CzXkRaM47X6568x/WikBzXgSa8yLQnBeB5rzz5Zxv/utaEWjOi0BzXgSa8yLQnHe+LPp3n68Vgea8CDTnRaA5LwLNeefLH1x0Ta0INOdFoDkvAs15EWjOO1+ePuMf14pAc14EmvMi0JwXgea8TXCHgBBCCCEsBIQQQghhISCEEEJIAQsBIYQQQvIsBOgDeNbVQF/cY10N9MU91tVAX9xjXQ30xT3W1UBf3GNdDfTFPdaNybIQbN68uXdqbHluT+/U2Lvlid6p8fKeJ3unxrPbdvROjZld+3qnxtEXN/fOGBaCTNRAgWldDRSY1tVAgWldDRSY1tVAgWldDRSY1o1hIchEDRSY1tVAgWldDRSY1tVAgWldDRSY1tVAgWndmOwLAXq/3RvOdX1eIwxK9IU+3nCu6/MaYVCiL/TxhnNdn9cIgxJ9oY83nOv6vEYYlOgLfbzhXNfnNcKgRF/o4w3nuj6vEQYl+kIfbzjX9fkY7hBkokYYlH1RIwzKvqgRBmVf1AiDsi9qhEHZFzXCoOyLMSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRvDQpCJGigwrauBAtO6GigwrauBAtO6GigwrauBAtO6MSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRszsULwnaXLXSwLwZwaKDCtq4EC07oaKDCtq4EC07oaKDCtq4EC07ox4ywE37nmBwOvvcl95/rvj2R/qx0CQgghhEyWie0QbHtmt4tlISCEEELyYJyF4JFHnip97LHfuc1bXh7JfhYCQgghJGMmVgguuugiF5tSCNAX+ngRaM6LQHNeBJrzItCcd76gL/TxItCcF4HmvAg050WgOe98QV/o40WgOS8CzXkRaM6LQHPe+YK+0MeLQHNeBJrzItCcF4HmvPMFfaGPF4HmvAg050WgOS8CzXnnC/pCHy8CzXkRaM6LQHNeBJrzzhf0hT5eBJrzItCcF4HmvAg0521inIXgaxdfVvrVr1zqvnLRJSPZP7XtmReKZjAqdwgIIYSQPBjvDsETpY899qTbvOXZkexnISCEEEIyhoWAEEIIISwEhBBCCMm0EKAv7rGuBvriHutqoC/usa4G+uIe62qgL+6xrgb64h7raqAv7rFuDAtBJmqgwLSuBgpM62qgwLSuBgpM62qgwLSuBgpM68awEGSiBgpM62qgwLSuBgpM62qgwLSuBgpM62qgwLRuzDgLwT0sBPNXAwWmdTVQYFpXAwWmdTVQYFpXAwWmdTVQYFo3JvtCgL7QxxvOdX1eIwxK9IU+3nCu6/MaYVCiL/TxhnNdn9cIgxJ9oY83nOv6vEYYlOgLfbzhXNfnNcKgRF/o4w3nuj6vEQYl+kIfbzjX9fkY7hBkokYYlH1RIwzKvqgRBmVf1AiDsi9qhEHZFzXCoOyLMSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRvDQpCJGigwrauBAtO6GigwrauBAtO6GigwrauBAtO6MSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRvDQpCJGigwrauBAtO6GigwrauBAtO6GigwrauBAtO6MeMsBFIGxlIICCGEEDJZWAgIIYQQwkJACCGEkA4UAvSFPl4EmvMi0JwXgea8CDTnnS/oC328CDTnRaA5LwLNeRFozjtf0Bf6eBFozotAc14EmvMi0Jx3vqAv9PEi0JwXgea8CDTnRaA573xBX+jjRaA5LwLNeRFozotAc975gr7Qx4tAc14EmvMi0JwXgea88wV9oY8Xgea8CDTnRaA5LwLNeZvgDgEhhBBCJlcIbv/ZPS6WhYAQQgjJg3EWgptvvqv01lvvcj/+yd0j2Q/3x1kICCGEkDwYZyF47pkdpTtf2uMO7D9UHvewEBBCCCEZk2UhQB/As67Gu7+0sndqrDrpnb1T45oV7+udGotPuaF3arz9lod6p8aBq97WO2O4Q0AIIYQQFgJCCCGEsBAQQgghpICFgBBCCCEsBIQQQghhISCEEEJIAQsBIYQQQlgICCGEEJJpIUBf3GNdDfTFPdbVQF/cY10N9MU91tVAX9xjXQ30xT3W1UBf3GPdGBaCTNRAgWldDRSY1tVAgWldDRSY1tVAgWldDRSY1o1hIchEDRSY1tVAgWldDRSY1tVAgWldDRSY1tVAgWndGBaCTNRAgWldDRSY1tVAgWldDRSY1tVAgWldDRSY1o3JvhA0Ec51fV4jNSjDua7Pa6QGZTjX9XmN1KAM57o+r5EalOFc1+c1UoMynOv6vEZTUIaEc12fj+EOQSZqhEHZFzXCoOyLGmFQ9kWNMCj7okYYlH1RIwzKvhjDQpCJGigwrauBAtO6GigwrauBAtO6GigwrauBAtO6MSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRszsUIws2Wri2UhmFMDBaZ1NVBgWlcDBaZ1NVBgWlcDBaZ1NVBgWjdmnIVg3dqNpRvWT7vpTTMj2c8dAkUNFJjW1UCBaV0NFJjW1UCBaV0NFJjW1UCBad2Yie0QDH+O0FQI+kRqIegTqYWgT6QWgj6RWgj6RGoh6BOphaBPsBBkCgtBFRaCKiwEVVgIqrAQVGEhqMJCkCksBFVYCKqwEFRhIajCQlCFhaBKJwuBXK4Tgea8CDTnRaA5LwLNeT3h5TrCgIzPE4pAc14EmvMi0JwXgea8nraFAJ3Li0BzXgSa8yLQnBeB5ryetoUAncuLQHNeBJrzItCcF4HmvJ62hQCdy4tAc14EmvMi0JwXgea8nraFAJ3Li0BzXgSa8yLQnBeB5ryetoUAncuLQHNeBJrzItCcF4HmvB7uEGRKyvPlDkEV7hBU4Q5BFe4QVOEOQRXuELAQZAELQRUWgiosBFVYCKqwEFRhIajCQpApLARVWAiqsBBUYSGowkJQhYWgCgtBprAQVGEhqMJCUIWFoAoLQRUWgiqdKgR9U0MCsm9qSED2TQ0JyL6pIQHZNzUkIPumhgRk34zhDkEGpBaCPpFaCPpEaiHoE6mFoE+kFoI+kVoI+gQLQaawEFRhIajCQlCFhaAKC0EVFoIqLASZwkJQhYWgCgtBFRaCKiwEVVgIqnSyEMjlOhFozotAc14EmvMi0JzXE16uIwzI+DyhCDTnRaA5LwLNeRFozutpWwjQubwINOdFoDkvAs15EWjO62lbCNC5vAg050WgOS8CzXkRaM7raVsI0Lm8CDTnRaA5LwLNeRFozutpWwjQubwINOdFoDkvAs15EWjO62lbCNC5vAg050WgOS8CzXkRaM7r4Q5BpqQ8X+4QVOEOQRXuEFThDkEV7hBU4Q4BC0EWsBBUYSGowkJQhYWgCgtBFRaCKiwEmcJCUIWFoAoLQRUWgiosBFVYCKqwEGQKC0EVFoIqLARVWAiqsBBUYSGo0qlC0Dc1JCD7poYEZN/UkIDsmxoSkH1TQwKyb2pIQPbNmIkVgpktW10sdwgGpBaCPpFaCPpEaiHoE6mFoE+kFoI+kVoI+sRCF4J1azeWblg/7aY3zYxkf+sdgj7BQlCFhaAKC0EVFoIqLARVWAiqHNcdguHPEVgIBrAQVGEhqMJCUIWFoAoLQRUWgiqdLARyuU4EmvMi0JwXgea8CDTn9YSX6wgDMj5PKALNeRFozotAc14EmvN62hYCdC4vAs15EWjOi0BzXgSa83raFgJ0Li8CzXkRaM6LQHNeBJrzetoWAnQuLwLNeRFozotAc14EmvN62hYCdC4vAs15EWjOi0BzXgSa83raFgJ0Li8CzXkRaM6LQHNeBJrzerhDkCkpz5c7BFW4Q1CFOwRVuENQhTsEVbhDwEKQBSwEVVgIqrAQVGEhqMJCUIWFoAoLQaawEFRhIajCQlCFhaAKC0EVFoIqLASZwkJQhYWgCgtBFRaCKiwEVVgIqnSqEPRNDQnIvqkhAdk3NSQg+6aGBGTf1JCA7JsaEpB9M4Y7BBmQWgj6RGoh6BOphaBPpBaCPpFaCPpEaiHoEywEmcJCUIWFoAoLQRUWgiosBFVYCKqwEGQKC0EVFoIqLARVWAiqsBBUYSGo0slCIJfrRKA5LwLNeRFozotAc15PeLmOMCDj84Qi0JwXgea8CDTnRaA5r6dtIUDn8iLQnBeB5rwINOdFoDmvp20hQOfyItCcF4HmvAg050WgOa+nbSFA5/Ii0JwXgea8CDTnRaA5r6dtIUDn8iLQnBeB5rwINOdFoDmvp20hQOfyItCcF4HmvAg050WgOa+HOwSZkvJ8uUNQhTsEVbhDUIU7BFW4Q1CFOwQsBFnAQlCFhaAKC0EVFoIqLARVWAiqsBBkCgtBFRaCKiwEVVgIqrAQVGEhqMJCkCksBFVYCKqwEFRhIajCQlCFhaBKpwpB39SQgOybGhKQfVNDArJvakhA9k0NCci+qSEB2TdjsiwEhBBCCJksLASEEEIImVwhmNmy1cWyEBBCCCF5MM5CsG7txtIN66fd9KaZkeznDgEhhBCSMRPbIRj+HIGFgBBCCMkDFgJCCCGEsBAQQgghhIWAEEIIIQVZFgL0xT3W1UBf3GNdDfTFPdbVQF/cY10N9MU91tVAX9xjXQ30xT3Wjcm2ELShD/MpARnSh/mUgAzpw3xKQIb0YT4lIEP6MJ8SkCF9mEcB2YTFeRaCBHKY70PAh6TM9yHgQ1Lm+xDwISnzfQj4kJT5PgR8SMq8xYBvAs2zECSQw3wfAj4kZb4PAR+SMt+HgA9Jme9DwIekzPch4ENS5i0GfBNoPvtCIJfr9MSX6/TEl+v0xJfr9MSX6/SEl+sIAzI+T6jH0nwdYUCic3k9lubrCAMSncvrsTRfRxiQ6Fxej6X5OsKAROfyeizN1xEGJDqX12Np3sMdggRymE8JyJA+zKcEZEgf5lMCMqQP8ykBGdKH+ZSADOnDPArIJizOsxAkkMN8HwI+JGW+DwEfkjLfh4APSZnvQ8CHpMz3IeBDUuYtBnwTaJ6FIIEc5vsQ8CEp830I+JCU+T4EfEjKfB8CPiRlvg8BH5IybzHgm0DzLAQJ5DDfh4APSZnvQ8CHpMz3IeBDUub7EPAhKfN9CPiQlHmLAd8Ems+2EPRNDQnIvqkhAdk3NSQg+6aGBGTf1JCA7JsaEpB9MybbQrB58+ZkLcxrSEBueW5PshbmNSQg9255IlkL8xoSkC/veTJZC/MaEpDPbtuRrIV5DQnImV37krUwryEBefTFzclamI9hIUhwEvMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpnXsBDw6HidMq9hIeDR8TplXsNCwKPjdcp8DAtBgpOY17AQ8Oh4nTKvYSHg0fE6ZV7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5mOyLwRyuc5wpuvzGmGgxucJDQO16/MaYaCic3nDQO36vEYYqOhc3jBQuz6vEQYqOpc3DNSuz2uEgYrO5Q0DtevzGmGgonN5w0Dt+nzMxArBzJatLpY7BANlXiMM1BQtzGuEgZqihXmNMFBTtDCvEQZqihbmNcJATdHCvEYYqClamI8ZZyFYt3Zj6Yb1025608xI9vMtgwZlXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8xoWAh4dr1PmNSwEPDpep8xrWAh4dLxOmY+Z2A7B8OcILAQDZV7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPYSFIcBLzGhYCHh2vU+Y1LAQ8Ol6nzGtYCHh0vE6Z17AQ8Oh4nTKvYSHg0fE6ZV7DQsCj43XKfEy2haBvakhA9k0NCci+qSEB2Tc1JCD7poYEZN/UkIDsmzHZFoI29GE+JSBD+jCfEpAhfZhPCciQPsynBGRIH+ZTAjKkD/MoIJuwOM9CkEAO830I+JCU+T4EfEjKfB8CPiRlvg8BH5Iy34eAD0mZtxjwTaB5FoIEcpjvQ8CHpMz3IeBDUub7EPAhKfN9CPiQlPk+BHxIyrzFgG8CzWdfCORynZ74cp2e+HKdnvhynZ74cp2e8HIdYUDG5wn1WJqvIwxIdC6vx9J8HWFAonN5PZbm6wgDEp3L67E0X0cYkOhcXo+l+TrCgETn8noszXu4Q5BADvMpARnSh/mUgAzpw3xKQIb0YT4lIEP6MJ8SkCF9mEcB2YTFeRaCBHKY70PAh6TM9yHgQ1Lm+xDwISnzfQj4kJT5PgR8SMq8xYBvAs2zECSQw3wfAj4kZb4PAR+SMt+HgA9Jme9DwIekzPch4ENS5i0GfBNonoUggRzm+xDwISnzfQj4kJT5PgR8SMp8HwI+JGW+DwEfkjJvMeCbQPPZFoK+qSEB2Tc1JCD7poYEZN/UkIDsmxoSkH1TQwKyb8ZkWwjQV/zWaWFeQwISfcVvnRbmNSQg0Vf81mlhXkMCEn3Fb50W5jUkINFX/NZpYV5DAhJ9xW+dFuY1JCDRV/zWaWE+hoUgwUnMa1gIeHS8TpnXsBDw6HidMq9hIeDR8TplXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8zEsBAlOYl7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPyb4QyOU6w5muz2uEgRqfJzQM1K7Pa4SBis7lDQO16/MaYaCic3nDQO36vEYYqOhc3jBQuz6vEQYqOpc3DNSuz2uEgYrO5Q0DtevzMdwhSHAS8xphoKZoYV4jDNQULcxrhIGaooV5jTBQU7QwrxEGaooW5jXCQE3RwnwMC0GCk5jXsBDw6HidMq9hIeDR8TplXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8xoWAh4dr1PmYyZWCGa2bHWxLAQDZV7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPGWchWLd2Y+mG9dNuetPMSPZzh6BBmdewEPDoeJ0yr2Eh4NHxOmVew0LAo+N1yryGhYBHx+uUeQ0LAY+O1ynzGhYCHh2vU+ZjJrZDMPw5QlMh6JsaEpB9U0MCsm9qSED2TQ0JyL6pIQHZNzUkIPtmTLaFoA19mE8JyJA+zKcEZEgf5lMCMqQP8ykBGdKH+ZSADOnDPArIJizOsxAkkMN8HwI+JGW+DwEfkjLfh4APSZnvQ8CHpMz3IeBDUuYtBnwTaJ6FIIEc5vsQ8CEp830I+JCU+T4EfEjKfB8CPiRlvg8BH5IybzHgm0Dz2RcCuVynJ75cpye+XKcnvlynJ75cpye8XEcYkPF5Qj2W5usIAxKdy+uxNF9HGJDoXF6Ppfk6woBE5/J6LM3XEQYkOpfXY2m+jjAg0bm8HkvzHu4QJJDDfEpAhvRhPiUgQ/ownxKQIX2YTwnIkD7MpwRkSB/mUUA2YXGehSCBHOb7EPAhKfN9CPiQlPk+BHxIynwfAj4kZb4PAR+SMm8x4JtA8ywECeQw34eAD0mZ70PAh6TM9yHgQ1Lm+xDwISnzfQj4kJR5iwHfBJpnIUggh/k+BHxIynwfAj4kZb4PAR+SMt+HgA9Jme9DwIekzFsM+CbQfLaFoG9qSED2TQ0JyL6pIQHZNzUkIPumhgRk39SQgOybMVkWAkIIIYRMFhYCQgghhLAQEEIIIYSFgBBCCCEFWRSC3Xtfo5RSSulxlIWAUkoppSwElFJKKWUhoJRSSmnhxArBzJatLpaFgFJKKc3DcRaCdWs3lm5YP+2mN82MZD93CCillNKMndgOwfDnCGmF4F533oknuhPFk69308Ft09edPDh+4gXu7uC45mDdye7a6blzfPC6zXCWUkop7YPdKgTDEK8en38hQLdTSimlfbM7heDkk90Hi5+zr+TvvqAM9Q+eHBWC8ni1KMztJniHhWA4f97d0eXZNaNzHywehz/HB6+7fq6UnH/v4P4ppZTSDtqdQnD+9e5aCf/h2wZ3nz+4fK389ME/Euh+XRHUPszLMrF5cJ55FoJB8PvdicH9cseBUkpp1+1QIbg3CN7BMQn4shiMBLNcDyxKw91RYKOgT94hCEvFsJz4+/XrKKWU0q7ZqUKwe/r6wdsG5bb9IKjDQjC4PBf83pFgj6+zEFBKKaUdKwSz2/1zYRwWgtHQLq4XBeLaStA3vGXgC8dw/UjBYCGglFJq2I4VguJ6FPojhaDQh7PXh/RgbmC4wzBaFvQ5FgJKKaUW7UAhoJRSSulCy0JAKaWUUhYCSimllLIQUEoppbQwi0JAMPu3Xev2rHtv75U/B0IIIQsLC0Gm+DJw9NALvZelgBBCFh4WgkzZ86u/dEcP/m7grp/21+Gfgfx5EEIIWThYCDKlLAQHnnZHd/yw8Ac9tnj+xZ8DCwEhhCwsWRaCqamp3hmz91f/uQjCbe7oS98rvMFd+dPf9k553uXzL/4c5M8jZuaqK3qnxoO/vaZ3aty+9Be9U+Py9Vt6p8bh+7/RO2NYCDIxZu/Df+GO7n/SHX3hWnf0xWvKgHz3l1b2xrIQFM+7fP7Fn4P8ecRIQK466Z29MbUQXLPifb0xtRAsPuWG3phaCN5+y0O9MbUQHLjqbb3xuBaCmS1bXSwLwZwxe9dLIdhSBOJV7ujzV/azEBTPu3z+xZ+D/HnEsBBUYSGowkJQhYWgCgvBeAvBurUbSzesn3bTm2ZGsp87BIox+x75T+7oazNFKF7ujj63pJ+FoHje5fMv/hzkzyOGhaAKC0EVFoIqLARVWAg68JZBE+Fc1+dj9m34j0UQbnZHf/d1d/TZr40UgibCUO3yfFkIiuddPv/iz0H+PGLCQtBEGKpdnm9bCJoIQ7XL820LQRNhqHZ5vm0haCIM1S7Pty0ETYSh2uX5ThaCvhjz6qNFIXj18SIUv+qOPnNxP3cIiuddPv/iz0H+PGK4Q1CFOwRVuENQhTsEVbhDwEKQjTEsBCwEsSwEVVkIqrIQVGUhqMpCkLExLAQsBLEsBFVZCKqyEFRlIajKQpCxMSwELASxLARVWQiqshBUZSGoykKQsTGoEPTNlELQNzUkIPumhgRk39SQgOybGhKQfTMm20KwefPm3phaCLY8t6c3phaCvVue6I2pheDlPU/2xtRC8Oy2Hb0xtRDM7NrXG1MLwdEXN/dGFoJMZSGoykJQlYWgKgtBVRaCqiwEVVkIMpWFoCoLQVUWgqosBFVZCKqyEFTtZCGQy3WGodrlebkc01QI4vOEhqHa5fm2hQCdyxuGapfn2xYCdC5vGKpdnm9bCNC5vGGodnm+bSFA5/KGodrl+baFAJ3LG4Zql+e5Q5Cp8nxjuEPAHYJY7hBU5Q5BVe4QVOUOQVUWgkxlIajKQlCVhaAqC0FVFoKqLARVWQgylYWgKgtBVRaCqiwEVVkIqrIQVGUhyFQWgqosBFVZCKqyEFRlIajKQlC1U4Wgb8agQtA3UwpB39SQgOybGhKQfVNDArJvakhA9s2YbAtBn0gtBH0itRD0idRC0CdSC0GfSC0EfSK1EPQJFoJMYSGowkJQhYWgCgtBFRaCKiwEVVgIMoWFoAoLQRUWgiosBFVYCKqwEFQ5roVgZstWF5tSCORynQg050WgOS8CzXkRaM7rCS97mgpBfJ5QBJrzItCcF4HmvAg05/W0LQToXF4EmvMi0JwXgea8CDTn9bQtBOhcXgSa8yLQnBeB5rwINOf1tC0E6FxeBJrzItCcF4HmvAg05/W0LQToXF4EmvMi0JwXgea8CDTn9bQtBOhcXgSa8yLQnBeB5rwINOf1LHQhWLd2Y+mG9dNuetPMSPbDR80dggHo+b766/cUQViE4rNFKD7zlZ7uEHxl8PyLPwf584jhDkEV7hBU4Q5BFe4QVOEOAd8yyAIWgiosBFVYCKqwEFRhIajCQlCFhSBTWAiqsBBUYSGowkJQhYWgCgtBFRaCTGEhqMJCUIWFoAoLQRUWgiosBFU6VQj6ZgwqBH0zpRD0TQ0JyL6pIQHZNzUkIPumhgRk34zJthCgr/i1amohQF/xa9XUQoC+4teqqYUAfcWvVVMLAfqKX6umFgL0Fb9WTS0E6Ct+rcpCkKksBFVZCKqyEFRlIajKQlCVhaAqC0GmshBUZSGoykJQlYWgKgtBVRaCqp0sBHK5zjBUuzwvl2OaCkF8ntAwVLs837YQoHN5w1Dt8nzbQoDO5Q1DtcvzbQsBOpc3DNUuz7ctBOhc3jBUuzzfthCgc3nDUO3yPHcIMlWebwx3CLhDEMsdgqrcIajKHYKq3CGoykKQqSwEVVkIqrIQVGUhqMpCUJWFoCoLQabiQvAfhoXgkp4XguL5l4XgPwz/ZOZgIajCQlCFhaAKC0EVFgIWgixkIajKQlCVhaAqC0FVFoKqLARVO1UI+mbMq6AQ9M2UQtA3NSQg+6aGBGTf1JCA7JsaEpB9MybbQtAnUgtBn0gtBH0itRD0idRC0CdSC0GfSC0EfYKFIFNYCKqwEFRhIajCQlCFhaAKC0EVFoJMYSGowkJQhYWgCgtBFRaCKiwEVTpZCORynQg050WgOS8CzXkRaM7rCS97XtvoC8FXi2C8ZKQQxOcJRaA5LwLNeRFozotAc17PoBAUZUCef/HnIH8eMWFAonN5EWjOi0BzXgSa8yLQnNfTthCgc3kRaM6LQHNeBJrzItCc19O2EKBzeRFozotAc14EmvMi0JzX07YQoHN5EWjOi0BzXgSa8yLQnNfTthCgc3kRaM6LQHNeBJrzItCc18MdgkxBz/e1x05yR1/b7I4+d1nhkn7uEBTPu3z+xZ+D/HnEcIegCncIqnCHoAp3CKpwh2CChWBmy1YXy0IwABaC37zbHd2/xR194duFVy9YIbjiiivc3/7t37pzzjmHdlj5HcrvkoWgCgtBFRaCKiwE4y0E69ZuLN2wftpNb5oZyX7uEDQAC8G0FIJt7uhL33NHX162IIVAAuSee+4ZXiNdR36X8jvtEywEVVgIqrAQVDmuOwTDnyOwEAyAhWBTUQgOPOOO7vxx4e0LUgjkVaXnjTfeoB3WE/5O+wALQRUWgiosBFU6VQj6Zsz+Te9yRw++4I7uvs8d3XN/WQjGrWw1HznyBjWk/E4lJPukhgRk39SQgOybGhKQfTMmy0JAikLw26IQHN7ljr76iDv62qPu6P6N7uiB3xQlYVPhbws3u6OHjk0Jj9dfP0oNKb/TQwcPu8OH5H+4R90bR+d2DwghpAkWgkzZ//g73dHX9w48+GQR4IXlz20DD28/ZiU8Dh8+Qg0pv9Pdu/a5V/fudwcPHCr+R3p0+N8oQghphoUgUw69cKXbv/kkd/TIa4X7CoticHR34a7CnYU7Cl8+JstXk8UrSWpH+Z3K/whffqH4H3VRCmSngBBCUmAhyJjDz1/hDjz+9gVTwuPAgdepIX0hEHfv3Ff8j/nw8L9NhBDSDAtBj5Hw2L//cOCD7pJ3vMO9Y8RPuuVPhDOhMl93e9NtNa7+GrjflPO0va/h87zkwcptTyz/pPKckeH9y+WvudVw7thcfYn/s8GPXQwLwa6X97iDB1gICCFpsBD0GAmP1147BFxThNonioBDt4U2zaWeY+gTN7lPwPmU87S8r3JegrUI7pHj29zyT8jxNucS297/PCz+fJav9tfr7y8sBOh/iIQQUgcLQY+R8Hj11UPAQeDcWATO4Po2d+MZc69Oz7hx2+jcjXOv7C9ZVXcOuT48xyVrhscCi8A7owjoVSPHgzWFZ9y4pnwcs/exqrjfM25yT7S9r+H8JZd8InguhcX5zrjxpsRzhce/FqwJH0t4Gd8mj2Hw3La5VX4HAD7mUPl9hOedk4WAEDJfWAh6jITH3r0HgWvcxUVYLXu87ravuvtmLxcBdvGawW33fbUItPC2uXPcd/E73MX3yeUn3bIizNC5H182CMfBnHf0POXM8P7k8hnLnqzM6Pfl54ufRaF4fHj8vouHxxLOJccH911cL5+3vy1cP3qu6m3DczwuZWh4P+Vl/2dYo9xf8LhDWQgIIfMly0KAvrinybZrcpsXNd79pZWtTFkj4bFnzwHgaveVIri+99vgWBl6w1ews7fFc+H1+LJfO/Ar9/k1scPZM77vfjt7PbiP337fnVHetsV9rwjo+d3X3Px9XxneLuf9yuqR2+rPFc7E1+sup87Fa2Kbb5ff6TW3nTnwJx933/n5h9w1K95Xq4CO15nbvKix+JQbWtl2TW7zosbbb3molW3X5DYvahy46m2tbLsmt3kxhoUgwYWeFzVQoDeZskbCY/fu/cBh6GwaXl95SRHQy92mym3RXO1t8ZzmE0XYF+G7Ui7Ha+W24vrK5UUxSHlMyGBmU3Geoghs+t4nwP3VnSs+XrdmPnPxmtCm2wayEFRBgdlk2zW5zYsaKDCbbLsmt3lRAwVmk23X5DYvxrAQJLjQ86IGCvQmU9ZIeOzatR+42l1UBM8N08Pr9xaF4KLVc5dnb5O5d7jTb3iivG36hk+4d5y+3E1XzvGEu+H0uTndwfxF98rl6LEUyv1cdNElwfna3lc8/wl3+kVtHnd0vPJnMrp+8Dya5uouh9YdH5WFoAoKzCbbrsltXtRAgdlk2zW5zYsaKDCbbLsmt3kxhoUgwYWeFzVQoDeZskbCY+fO14CD8PnudHh9uG1eBPHcbYO5iy4avPcvYTe6Jrg+vdyd7s/xjkvcitn7QrcXFgXE37biosGx07/7xODYikGwzvu+4vnifLPnTj1XeBz8mYTnHqxtmqu7POf0d/2fsbc6I7IQVEGB2WTbNbnNixooMJtsuya3eVEDBWaTbdfkNi/GZF8ImghnujyvzQlhkDcRzmjzEh47drzaOR9beoZ7x+k3usfAbX03LATof4ieMExTgjXXeW1OSA3KcKbL89qckBqU4UyX57U5oSkoQ8KZLs+jOe4QJLjQ86KGD/dUU9ZIeLz00qsd8gn39x+XV8dnuL/fiG6n3CGoEgZlim3X5DYvaoRBmWLbNbnNixphUKbYdk1u82IMC0GCCz0vaqBAbzJljYTHiy/uo4ZkIaiCArPJtmtymxc1UGA22XZNbvOiBgrMJtuuyW1ejGEhSHCh50UNFOhNpqyR8Hjhhb3UkCwEVVBgNtl2TW7zogYKzCbbrsltXtRAgdlk2zW5zYsxEysEM1u2ulgWgjk1UKA3mbJm8eIL3bPP7i59/vk9tMP636P8TlkIRkGB2WTbNbnNixooMJtsuya3eVEDBWaTbdfkNi/GjLMQrFu7sXTD+mk3vWlmJPth4tUVAjIZLr30MnfrrT+dDRPabeV3Kb/TpmZOCCF1TGyHYPhzhLpCsHz58la2XZPbvKhx18PPtjJ1jQSIvKqUrWbaXeV3KL/LtRvumfWR6Xvcb5681z3+bL0COl5nbvOixsOrZlrZdk1u86LGz598oZVt1+Q2L2ocmb6jlW3X5DYvxrAQJLjQ86IGCvMm264R7vzlU+6ONVvc7SsfV5VfNDpeZ9t50f8Xqs7HfnRnK9uuyW1elDVNhoVgw2+LQrBtBQxRr4CO15nbvKiBArPJtmtymxc1UGA22XZNbvOiBgrMJtuuyW1ejGEhSHCh50UNFOJNtl0jSCH42T886X5y/2YY0KHyi0bH62w7L/r/QtWJArPJtmtymxdlTZO+DDy88W7365kVbpqFAAZmk23X5DYvaqDAbLLtmtzmRQ0UmE22XZPbvBiTfSFAH8DzhmHa5Xm/pokwvNG5vGHAt53/+bpn3J2/2O7+x3/yP7l/+j//M/fP/un/5v7X/+VNI/501ROl8kv2l+OZ0PnO+zVNbr7tzlnRubx+JlyD5ry5zvs1Ta7/zT1uw6Z7yjLwj//7/8H9o3/038Lfexim/jKa8+Y679c0EQYlOpc3DNMuz/s1TYRBic7lDcO0y/N+TRNhUKJzecMw7fK8XxPCHYIEF3pe1PDBnWrbNeX8r54ZlIJfPjXrz4qCgJRfMDpeZ9t5UdY0uf2OO1vZdk1u86KsaVI+MyBvE8jOwKan73W/LQzDM1ZAx+vMbV7UCIMyxbZrcpsXNcKgTLHtmtzmRY0wKFNsuya3eTGGhSDBhZ4XNVCIN9l2TW7zosZzd/28lW3X5DYvaqDAbLLtmtzmRQ0UmE22XZPbvKiBArPJtmtymxc1UGA22XZNbvNiDAtBggs9L2qgwGyy7Zrc5kUNFJhNtl2T27yogQKzybZrcpsXNVBgNtl2TW7zogYKzCbbrsltXtRAgdlk2zW5zYsxLAQJLvS8qIECs8m2a3KbFzVQYDbZdk1u86IGCswm267JbV7UQIHZZNs1uc2LGigwm2y7Jrd5UQMFZpNt1+Q2L8ZkWQgIIYQQMlmyLASbN29uZds1uc2LGlue29PKtmtymxc19m55opVt1+Q2L2q8vOfJVrZdk9u8qPHsth2tbLsmt3lRY2bXvla2XZPbvKhx9MXNrWy7Jrd5MYaFIMGFnhc1UGA22XZNbvOiBgrMJtuuyW1e1ECB2WTbNbnNixooMJtsuya3eVEDBWaTbdfkNi9qoMBssu2a3ObFGBaCBBd6XtRAgdlk2zW5zYsaKDCbbLsmt3lRAwVmk23X5DYvaqDAbLLtmtzmRQ0UmE22XZPbvKiBArPJtmtymxdjsi8E6IsVvGGYdnner2kiDEp0Lm8Ypl2e92uaCIMSncsbhmmX5/2aJsKgROfyhmHa5Xm/pokwKNG5vGGYdnner2kiDEp0Lm8Ypl2e92uaCIMSncsbhmmX5/2aEO4QJLjQ86JGGJQptl2T27yoEQZlim3X5DYvaoRBmWLbNbnNixphUKbYdk1u86JGGJQptl2T27yoEQZlim3X5DYvxrAQJLjQ86IGCswm267JbV7UQIHZZNs1uc2LGigwm2y7Jrd5UQMFZpNt1+Q2L2qgwGyy7Zrc5kUNFJhNtl2T27wYw0KQ4ELPixooMJtsuya3eVEDBWaTbdfkNi9qoMBssu2a3OZFDRSYTbZdk9u8qIECs8m2a3KbFzVQYDbZdk1u82IMC0GCCz0vaqDAbLLtmtzmRQ0UmE22XZPbvKiBArPJtmtymxc1UGA22XZNbvOiBgrMJtuuyW1e1ECB2WTbNbnNizFZFgJCCCGETJaJFYKZLVtdbF0hQF/t22TbNbnNixroq32bbLsmt3lRA321b5Nt1+Q2L2qgr/Ztsu2a3OZFDfTVvk22XZPbvKiBvtq3ybZrcpsXNdBX+zbZdk1u82LMOAvBurUbSzesn3bTm2ZGsr/VDgEKzCbbrsltXtRAgdlk2zW5zYsaKDCbbLsmt3lRAwVmk23X5DYvaqDAbLLtmtzmRQ0UmE22XZPbvKiBArPJtmtymxdjJrZDMPw5AgvBnBooMJtsuya3eVEDBWaTbdfkNi9qoMBssu2a3OZFDRSYTbZdk9u8qIECs8m2a3KbFzVQYDbZdk1u82JM9oUAfbGCNwzTLs/7NU2EQYnO5Q3DtMvzfk0TYVCic3nDMO3yvF/TRBiU6FzeMEy7PO/XNBEGJTqXNwzTLs/7NU2EQYnO5Q3DtMvzfk0TYVCic3nDMO3yvF8Twh2CBBd6XtQIgzLFtmtymxc1wqBMse2a3OZFjTAoU2y7Jrd5USMMyhTbrsltXtQIgzLFtmtymxc1wqBMse2a3ObFGBaCBBd6XtRAgdlk2zW5zYsaKDCbbLsmt3lRAwVmk23X5DYvaqDAbLLtmtzmRQ0UmE22XZPbvKiBArPJtmtymxdjWAgSXOh5UQMFZpNt1+Q2L2qgwGyy7Zrc5kUNFJhNtl2T27yogQKzybZrcpsXNVBgNtl2TW7zogYKzCbbrsltXoxhIUhwoedFDRSYTbZdk9u8qIECs8m2a3KbFzVQYDbZdk1u86IGCswm267JbV7UQIHZZNs1uc2LGigwm2y7Jrd5MSbLQkAIIYSQyZJlIUBf7dtk2zW5zYsa6Kt9m2y7Jrd5UQN9tW+TbdfkNi9qoK/2bbLtmtzmRQ301b5Ntl2T27yogb7at8m2a3KbFzXQV/s22XZNbvNiDAtBggs9L2qgwGyy7Zrc5kUNFJhNtl2T27yogQKzybZrcpsXNVBgNtl2TW7zogYKzCbbrsltXtRAgdlk2zW5zYsxLAQJLvS8qIECs8m2a3KbFzVQYDbZdk1u86IGCswm267JbV7UQIHZZNs1uc2LGigwm2y7Jrd5UQMFZpNt1+Q2L8ZkXwjQFyt4wzDt8rxf00QYlOhc3jBMuzzv1zQRBiU6lzcM0y7P+zVNhEGJzuUNw7TL835NE2FQonN5wzDt8rxf00QYlOhc3jBMuzzv1zQRBiU6lzcM0y7P+zUh3CFIcKHnRY0wKFNsuya3eVEjDMoU267JbV7UCIMyxbZrcpsXNcKgTLHtmtzmRY0wKFNsuya3eVEjDMoU267JbV6MYSFIcKHnRQ0UmE22XZPbvKiBArPJtmtymxc1UGA22XZNbvOiBgrMJtuuyW1e1ECB2WTbNbnNixooMJtsuya3eTGGhSDBhZ4XNVBgNtl2TW7zogYKzCbbrsltXtRAgdlk2zW5zYsaKDCbbLsmt3lRAwVmk23X5DYvaqDAbLLtmtzmxRgWggQXel7UQIHZZNs1uc2LGigwm2y7Jrd5UQMFZpNt1+Q2L2qgwGyy7Zrc5kUNFJhNtl2T27yogQKzybZrcpsXY1gIElzoeVEDBWaTbdfkNi9qoMBssu2a3OZFDRSYTbZdk9u8qIECs8m2a3KbFzVQYDbZdk1u86IGCswm267JbV6MybIQEEIIIWSysBAQQgghZHKFYGbLVhfLQkAIIYTkwTgLwbq1G0s3rJ9205tmRrKfOwSEEEJIxkxsh2D4cwQWAkIIISQPWAgIIYQQwkJACCGEEBYCQgghhBRkWQjQv9BkXQ20xroaaI11NdAa62qgNdbVQGusq4HWWDeGhSATNd79pZW9U2PVSe/snRrXrHhf79RYfMoNvVPj7bc81Ds1Dlz1tt4Zw0KQiRooMK2rgQLTuhooMK2rgQLTuhooMK2rgQLTujEsBJmogQLTuhooMK2rgQLTuhooMK2rgQLTuhooMK0bk30haCKc6/q8RmpQhnNdn9dIDcpwruvzGqlBGc51fV4jNSjDua7Pa6QGZTjX9XmNpqAMCee6Ph/DHYJM1AiDsi9qhEHZFzXCoOyLGmFQ9kWNMCj7okYYlH0xhoUgEzVQYFpXAwWmdTVQYFpXAwWmdTVQYFpXAwWmdWNYCDJRAwWmdTVQYFpXAwWmdTVQYFpXAwWmdTVQYFo3hoUgEzVQYFpXAwWmdTVQYFpXAwWmdTVQYFpXAwWmdWNYCDJRA62xrgZaY10NtMa6GmiNdTXQGutqoDXWjcm2EGzevDlZC/MaaJ11NdAa62qgNdbVQGusq4HWWFcDrbFuDAtBgpOY10DrrKuB1lhXA62xrgZaY10NtMa6GmiNdWNYCBKcxLwGWmddDbTGuhpojXU10BrraqA11tVAa6wbk30hkMt1hjNdn9fws6nntDCvEc6ic3nDua7Pa4Sz6FzecK7r8xrhLDqXN5zr+rxGOIvO5Q3nuj6vEc6ic3nDua7Px0ysEMxs2epiuUMwUOY10DrraqA11tVAa6yrgdZYVwOtsa4GWmPdmHEWgnVrN5ZuWD/tpjfNjGQ/3zJoUOY10DrraqA11tVAa6yrgdZYVwOtsa4GWmPdmIntEAx/jsBCMFDmNdA662qgNdbVQGusq4HWWFcDrbGuBlpj3RgWggQnMa+B1llXA62xrgZaY10NtMa6GmiNdTXQGuvGZFsI+qYG+mVaVwOtsa4GWmNdDbTGuhpojXU10BrrxmRbCNrQt3lCCCFk3LAQJJDbPCGEEDJuWAgSyG2eEEIIGTfZFwK5XKcnvlynJ75cpye+XKcnvlynJ7ycQnyeUASa8yLQnBeB5rwINOedL+hcXgSa8yLQnBeB5rwINOedL+hcXgSa8yLQnBeB5rwINOedL+hcXgSa8yLQnBeB5rwINOedL+hcXgSa8yLQnBeB5rwINOedL+hcXgSa8yLQnBeB5rwINOdtgjsECeQ2TwghhIwbFoIEcpsnhBBCxg0LQQK5zRNCCCHjhoUggdzmCSGEkHGTbSHomxroSyWsq4HWWFcDrbGuBlpjXQ20xroaaI11Y7ItBOjB12lhXgOts64GWmNdDbTGuhpojXU10BrraqA11o1hIUhwEvMaaJ11NdAa62qgNdbVQGusq4HWWFcDrbFuDAtBgpOY10DrrKuB1lhXA62xrgZaY10NtMa6GmiNdWOyLwRyuc5wpuvzGn429ZwW5jXCWXQubzjX9XmNcBadyxvOdX1eI5xF5/KGc12f1whn0bm84VzX5zXCWXQubzjX9fkY7hAkOIl5DbTOuhpojXU10BrraqA11tVAa6yrgdZYN4aFIMFJzGugddbVQGusq4HWWFcDrbGuBlpjXQ20xroxEysEM1u2ulgWgoEyr4HWWVcDrbGuBlpjXQ20xroaaI11NdAa68aMsxCsW7uxdMP6aTe9aWYk+7lD0KDMa6B11tVAa6yrgdZYVwOtsa4GWmNdDbTGujET2yEY/hyhqRD0TQ30y7SuBlpjXQ20xroaaI11NdAa62qgNdaNybYQtKFv84QQQsi4YSFIILd5QgghZNywECSQ2zwhhBAybrIvBHK5Tk98uU5PfLlOT3y5Tk98uU5PeDmF+DyhCDTnRaA5LwLNeRFozjtf0Lm8CDTnRaA5LwLNeRFozjtf0Lm8CDTnRaA5LwLNeRFozjtf0Lm8CDTnRaA5LwLNeRFozjtf0Lm8CDTnRaA5LwLNeRFozjtf0Lm8CDTnRaA5LwLNeRFoztsEdwgSyG2eEEIIGTcsBAnkNk8IIYSMGxaCBHKbJ4QQQsYNC0ECuc0TQggh4ybbQtA3NdAa62qgNdbVQGusq4HWWFcDrbGuBlpj3ZgsCwEhhBBCJgsLASGEEEJYCAghhBDCQkAIIYSQAhYCQgghhLAQEEIIIYSFgBBCCCEFLASEEEIImVwhmNmy1cXWFQL0BQrW1bjyp7/tnRozV13ROzUe/O01vVPj9qW/6J0al6/f0js1Dt//jd4ZM85CsG7txtIN66fd9KaZkexvtUMgAbl58+ZkLcxrSEBueW5PshbmNSQg9255IlkL8xoSkC/veTJZC/MaEpDPbtuRrIV5DQnImV37krUwryEBefTFzclamI+Z2A7B8OcILAQDZV7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPYSFIcBLzGhYCHh2vU+Y1LAQ8Ol6nzGtYCHh0vE6Z17AQ8Oh4nTKvYSHg0fE6ZV7DQsCj43XKfEz2hUAu1xnOdH1eIwzU+DyhYaB2fV4jDFR0Lm8YqF2f1wgDFZ3LGwZq1+c1wkBF5/KGgdr1eY0wUNG5vGGgdn1eIwxUdC5vGKhdn4/hDkGCk5jXCAM1RQvzGmGgpmhhXiMM1BQtzGuEgZqihXmNMFBTtDCvEQZqihbmY1gIEpzEvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpnXsBDw6HidMh/DQpDgJOY1LAQ8Ol6nzGtYCHh0vE6Z17AQ8Oh4nTKvYSHg0fE6ZV7DQsCj43XKvIaFgEfH65T5GBaCBCcxr2Eh4NHxOmVew0LAo+N1yryGhYBHx+uUeQ0LAY+O1ynzGhYCHh2vU+Y1LAQ8Ol6nzMdkWwj6poYEZN/UkIDsmxoSkH1TQwKyb2pIQPZNDQnIvhmTbSFYvnx5shbmNSQg73r42WQtzGtIQD5318+TtTCvIQH5+LP3JmthXkMC8uFVM8lamNeQgPz5ky8ka2FeQwLyyPQdyVqYj2EhSHAS8xoWAh4dr1PmNSwEPDpep8xrWAh4dLxOmdewEPDoeJ0yr2Eh4NHxOmVew0LAo+N1ynwMC0GCk5jXsBDw6HidMq9hIeDR8TplXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8xoWAh4dr1PmY7IvBHK5znCm6/MaYaDG5wkNA7Xr8xphoKJzecNA7fq8Rhio6FzeMFC7Pq8RBio6lzcM1K7Pa4SBis7lDQO16/MaYaCic3nDQO36fAx3CBKcxLxGGKgpWpjXCAM1RQvzGmGgpmhhXiMM1BQtzGuEgZqihXmNMFBTtDAfw0KQ4CTmNSwEPDpep8xrWAh4dLxOmdewEPDoeJ0yr2Eh4NHxOmVew0LAo+N1yryGhYBHx+uU+RgWggQnMa9hIeDR8TplXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8xoWAh4dr1PmNSwEPDpep8zHsBAkOIl5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpnXsBDw6HidMq9hIeDR8TplPibbQtA3NSQg+6aGBGTf1JCA7JsaEpB9U0MCsm9qSED2zZhsCwH6it86LcxrSECir/it08K8hgQk+orfOi3Ma0hAoq/4rdPCvIYEJPqK3zotzGtIQKKv+K3TwryGBCT6it86LczHTKwQzGzZ6mJZCAbKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpnXsBDw6HidMh8zzkKwbu3G0g3rp930ppmR7OcOQYMyr2Eh4NHxOmVew0LAo+N1yryGhYBHx+uUeQ0LAY+O1ynzGhYCHh2vU+Y1LAQ8Ol6nzMdMbIdg+HOElEIgl+sMZ7o+rxEGanye0DBQuz6vEQYqOpc3DNSuz2uEgYrO5Q0DtevzGmGgonN5w0Dt+rxGGKjoXN4wULs+rxEGKjqXNwzUrs/HZF8IUrQwrxEGaooW5jXCQE3RwrxGGKgpWpjXCAM1RQvzGmGgpmhhXiMM1BQtzMewECQ4iXkNCwGPjtcp8xoWAh4dr1PmNSwEPDpep8xrWAh4dLxOmdewEPDoeJ0yr2Eh4NHxOmU+hoUgwUnMa1gIeHS8TpnXsBDw6HidMq9hIeDR8TplXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8zEsBAlOYl7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPybYQ9E0NCci+qSEB2Tc1JCD7poYEZN/UkIDsmxoSkH0zJttCgL7it04L8xoSkOgrfuu0MK8hAYm+4rdOC/MaEpDoK37rtDCvIQGJvuK3TgvzGhKQ6Ct+67QwryEBib7it04L8zEsBAlOYl7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPYSFIcBLzGhYCHh2vU+Y1LAQ8Ol6nzGtYCHh0vE6Z17AQ8Oh4nTKvYSHg0fE6ZV7DQsCj43XKfEz2hUAu1xnOdH1eIwzU+DyhYaB2fV4jDFR0Lm8YqF2f1wgDFZ3LGwZq1+c1wkBF5/KGgdr1eY0wUNG5vGGgdn1eIwxUdC5vGKhdn4/hDkGCk5jXCAM1RQvzGmGgpmhhXiMM1BQtzGuEgZqihXmNMFBTtDCvEQZqihbmY1gIEpzEvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpnXsBDw6HidMh/DQpDgJOY1LAQ8Ol6nzGtYCHh0vE6Z17AQ8Oh4nTKvYSHg0fE6ZV7DQsCj43XKvIaFgEfH65T5GBaCBCcxr2Eh4NHxOmVew0LAo+N1yryGhYBHx+uUeQ0LAY+O1ynzGhYCHh2vU+Y1LAQ8Ol6nzMdkWwj6poYEZN/UkIDsmxoSkH1TQwKyb2pIQPZNDQnIvhmTbSFAX/Fbp4V5DQlI9BW/dVqY15CARF/xW6eFeQ0JSPQVv3VamNeQgERf8VunhXkNCUj0Fb91WpjXkIBEX/Fbp4X5GBaCBCcxr2Eh4NHxOmVew0LAo+N1yryGhYBHx+uUeQ0LAY+O1ynzGhYCHh2vU+Y1LAQ8Ol6nzMewECQ4iXkNCwGPjtcp8xoWAh4dr1PmNSwEPDpep8xrWAh4dLxOmdewEPDoeJ0yr2Eh4NHxOmU+ZmKFYGbLVhebUgjkcp3hTNfnNcJAjc8TGgZq1+c1wkBF5/KGgdr1eY0wUNG5vGGgdn1eIwxUdC5vGKhdn9cIAxWdyxsGatfnNcJARefyhoHa9fmYcRaCdWs3lm5YP+2mN82MZD93CBqUeY0wUFO0MK8RBmqKFuY1wkBN0cK8RhioKVqY1wgDNUUL8xphoKZoYT5mYjsEw58jsBAMlHkNCwGPjtcp8xoWAh4dr1PmNSwEPDpep8xrWAh4dLxOmdewEPDoeJ0yr2Eh4NHxOmU+hoUgwUnMa1gIeHS8TpnXsBDw6HidMq9hIeDR8TplXsNCwKPjdcq8hoWAR8frlHkNCwGPjtcp8zEsBAlOYl7DQsCj43XKvIaFgEfH65R5DQsBj47XKfMaFgIeHa9T5jUsBDw6XqfMa1gIeHS8TpmPybYQ9E0NCci+qSEB2Tc1JCD7poYEZN/UkIDsmxoSkH0zJstCQAghhJDJwkJACCGEEBYCQgghhLAQEEIIIaQgi0Kwe+9rlFJKKT2OshBQSimllIWAUkoppSwElFJKKS1kIaCUUkopCwGllFJKu1AIpq93HzzxRHdi6MnXu2k02+TdF5Rrz7sb3EYppZT23M4Ugg9et3nkeutSwEJAKaWU1tq9QlA4fd3Jc+Ee7yCcf+9gblgABl7g7g4Lgb9tPjsNlFJKqUE7WQjgMRGE/uzM7G33uvOKn2VJCNdSSimlPXZihWBmy1YXO75C4EN+YHk8LAcy4wvCycHugj8fpZRS2nPHWQjWrd1YumH9tJveNDOS/QvwlsHJ7trpubcPwhLQVAi84fkopZTSvjuxHYLhzxHmVQiG1/1nBe4+XwJ+sP2PykFcCM67e7O79mRZMygUs/dDKaWU9tjOFAL/yr7Uf3Awut2/HdBcCMI1/BwBpZRSKuZfCCillFK64LIQUEoppZSFgFJKKaUsBJRSSiktzKIQEEIIIeT4wkJACCGEEBYCQgghhLAQEEIIIaQgy0IwNTXVOzXQGutqoDXW1UBrrKuB1lhXA62xrgZaY90YFoJM1EBrrKuB1lhXA62xrgZaY10NtMa6GmiNdWNYCDJRA62xrgZaY10NtMa6GmiNdTXQGutqoDXWjWEhyEQNtMa6GmiNdTXQGutqoDXW1UBrrKuB1lg3JvtC0EQ41/V5jdTZcK7r8xqps+Fc1+c1UmfDua7Pa6TOhnNdn9dInQ3nuj6vkTobznV9PoY7BJmogdZYVwOtsa4GWmNdDbTGuhpojXU10BrrxrAQZKIGWmNdDbTGuhpojXU10BrraqA11tVAa6wbw0KQiRpojXU10BrraqA11tVAa6yrgdZYVwOtsW7MxArBzJatLpaFYE4NtMa6GmiNdTXQGutqoDXW1UBrrKuB1lg3ZpyFYN3ajaUb1k+76U0zI9kPfxt1hYAQQgghk2ViOwTDnyPUFYK3vvWtvVPjzYsu750aV735D3unxjnf/Ne9U2PRv/t879T4g4uu6Z0aT5/xj3tnDAtBJmqgwLSuBgpM62qgwLSuBgpM62qgwLSuBgpM68awEGSiBgpM62qgwLSuBgpM62qgwLSuBgpM62qgwLRuTPaFoIlwruvzGqlBGc51fV4jNSjDua7Pa6QGZTjX9XmN1KAM57o+r5EalOFc1+c1moIyJJzr+nwMdwgyUSMMyr6oEQZlX9QIg7IvaoRB2Rc1wqDsixphUPbFGBaCTNRAgWldDRSY1tVAgWldDRSY1tVAgWldDRSY1o1hIchEDRSY1tVAgWldDRSY1tVAgWldDRSY1tVAgWndGBaCTNRAgWldDRSY1tVAgWldDRSY1tVAgWldDRSY1o1hIchEDRSY1tVAgWldDRSY1tVAgWldDRSY1tVAgWndmCwLwac//eneqfHuL63snRqrTnpn79S4ZsX7eqfG4lNu6J0ab7/lod6pceCqt/XOGBaCTNRAgWldDRSY1tVAgWldDRSY1tVAgWldDRSY1o1hIchEDRSY1tVAgWldDRSY1tVAgWldDRSY1tVAgWndmOwLQRPhXNfnNVKDMpzr+rxGalCGc12f10gNynCu6/MaqUEZznV9XiM1KMO5rs9rNAVlSDjX9fkY7hBkokYYlH1RIwzKvqgRBmVf1AiDsi9qhEHZFzXCoOyLMSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRvDQpCJGigwrauBAtO6GigwrauBAtO6GigwrauBAtO6MSwEmaiBAtO6GigwrauBAtO6GigwrauBAtO6GigwrRuTZSFAX9xjXQ30xT3W1UBf3GNdDfTFPdbVQF/cY10N9MU91tVAX9xj3ZiJFYKZLVtdLAvBnBooMK2rgQLTuhooMK2rgQLTuhooMK2rgQLTujHjLATr1m4s3bB+2k1vmhnJfu4QKGqgwLSuBgpM62qgwLSuBgpM62qgwLSuBgpM68ZMbIdg+HMEFoI5NVBgWlcDBaZ1NVBgWlcDBaZ1NVBgWlcDBaZ1Y7IvBE2Ec12f10gNynCu6/MaqUEZznV9XiM1KMO5rs9rpAZlONf1eY3UoAznuj6v0RSUIeFc1+djuEOQiRphUPZFjTAo+6JGGJR9USMMyr6oEQZlX9QIg7IvxrAQZKIGCkzraqDAtK4GCkzraqDAtK4GCkzraqDAtG4MC0EmaqDAtK4GCkzraqDAtK4GCkzraqDAtK4GCkzrxrAQZKIGCkzraqDAtK4GCkzraqDAtK4GCkzraqDAtG4MC0EmaqDAtK4GCkzraqDAtK4GCkzraqDAtK4GCkzrxmRZCNBX+1pXA321r3U10Ff7WlcDfbWvdTXQV/taVwN9ta91NdBX+1o3hoUgEzVQYFpXAwWmdTVQYFpXAwWmdTVQYFpXAwWmdWNYCDJRAwWmdTVQYFpXAwWmdTVQYFpXAwWmdTVQYFo3JvtC0EQ41/V5jdSgDOe6Pq+RGpThXNfnNVKDMpzr+rxGalCGc12f10gNynCu6/MaTUEZEs51fT6GOwSZqBEGZV/UCIOyL2qEQdkXNcKg7IsaYVD2RY0wKPtiDAtBJmqgwLSuBgpM62qgwLSuBgpM62qgwLSuBgpM68awEGSiBgpM62qgwLSuBgpM62qgwLSuBgpM62qgwLRuDAtBJmqgwLSuBgpM62qgwLSuBgpM62qgwLSuBgpM68awEGSiBgpM62qgwLSuBgpM62qgwLSuBgpM62qgwLRuTJaFgBBCCCGThYWAEEIIIZMrBDNbtrpYFgJCCCEkD8ZZCNat3Vi6Yf20m940M5L93CEghBBCMmZiOwTDnyOwEBBCCCF5wEJACCGEEBYCQgghhLAQEEIIIaQgy0IwNTXVOzXQl9RYVwN9IYt1NdCXj1iXEDIeWAgyUQMFpnU1UGBaVwMFpnUJIeOBhSATNVBgWlcDBaZ1NVBgWpcQMh5YCDJRAwWmdTVQYFpXAwWmdQkh4yH7QtBEONf1eY3UoAznuj6vkRqU4VzX5zVSgzKc6/o8IWQ8cIcgEzXCoOyLGmFQ9kWNMCj7IiFkPLAQZKIGCkzraqDAtK4GCkzrEkLGAwtBJmqgwLSuBgpM62qgwLQuIWQ8sBBkogYKTOtqoMC0rgYKTOsSQsYDC0EmaqDAtK4GCkzraqDAtC4hZDxkWQiWL1/eOzXuevjZ3qnx+LP39k6Nnz/5Qu8khIwHFoJM1ECBaV0NFJjW1UCBaV1CyHhgIchEDRSY1tVAgWldDRSY1iWEjIfsCwF6v90bznV9XiMMSnQubzjX9XmNMCjRubzhXNfnNcKgROfyhnNdnyeEjIeJFYKZLVtdLHcI5tQIg7IvaoRB2Rc1wqDsi4SQ8TDOQrBu7cbSDeun3fSmmZHs51sGihooMK2rgQLTuhooMK1LCBkPE9shGP4cgYVgTg0UmNbVQIFpXQ0UmNYlhIwHFoJM1ECBaV0NFJjW1UCBaV1CyHhgIchEDRSY1tVAgWldDRSY1iWEjIcsC8HmzZt7p8aW5/b0To2X9zzZOzVmdu3rnYSQ8cBCkIkaKDCtq4EC07oaKDCtSwgZDywEmaiBAtO6GigwrauBAtO6hJDxkH0hQF9K4g3nuj6vEQYlOpc3nOv6vEYYlOhc3nCu6/MaYVCic3nDua7PE0LGA3cIMlEjDMq+qBEGZV/UCIOyLxJCxgMLQSZqoMC0rgYKTOtqoMC0LiFkPLAQZKIGCkzraqDAtK4GCkzrEkLGAwtBJmqgwLSuBgpM62qgwLQuIWQ8ZFkI0Bf3WFcDfXGPdTXQF/dYVwN9cY91CSHjgYUgEzVQYFpXAwWmdTVQYFqXEDIeWAgyUQMFpnU1UGBaVwMFpnUJIeOBhSATNVBgWlcDBaZ1NVBgWpcQMh6yLwToS0m84VzX5zXCoETn8oZzXZ/XCIMSncsbznV9XiMMSnQubzjX9XlCyHjgDkEmaoRB2Rc1wqDsixphUPZFQsh4YCHIRA0UmNbVQIFpXQ0UmNYlhIwHCfTpTY+7lasedHfec3+y996/xj0+syW9EMxs2epiWQjm1ECBaV0NFJjW1UCBaV1CyHiQQF9x3wPu6Wd/5/bu3ev27Nnjdou7d5c7B7t2veJ27tzlduzY6V5+eYd78aWX3PMvvOi2btteloKwEKxbu7F0w/rpomTMjGQ/dwgUNVBgWlcDBaZ1NVBgWpcQMh4k0OUV/959+1oVgueef6Fcl7xDMPw5AgvBnBooMK2rgQLTuhooMK1LCBkPWRYC9NW+1tVAX+1rXQ301b7W1UBf7WtdQsh4YCHIRA0UmNbVQIFpXQ0UmNYlhIwHFoJM1ECBaV0NFJjW1UCBaV1CyHiIC8HVyx9SnWghQF9K4g3nuj6vEQYlOpc3nOv6vEYYlOhc3nCu6/MaYVCic3nDua7PE0LGA9ohQCXAyx2CBVIjDMq+qBEGZV/UCIOyLxJCxgMqBPKWASoDfMtgAdVAgWldDRSY1tVAgWldQsh4qCsE8hmCsAzwMwQLrAYKTOtqoMC0rgYKTOsSQsZDUyGQDxVKGeCHCiegBgpM62qgwLSuBgpM6xJCxoNWCPi3DCakBgpM62qgwLSuBgpM6xJCxkOWhYAQQgghk4WFgBBCCCEsBIQQQggZFIJ7Vq52v3vu+VaF4Imt28p/MpmFgBBCCDGABPrG32wq/wlkecWfqpSBmS1PjqcQPP3s85RSSintuAJ3CAghhBCSdyHwrYUQQgghCwsLASGEEEL0QjCzZauLZSEghBBCbCHZvm7txtIN66fd9KaZkexvtUPw8sNfdPu3Xe7e2Hm9237bm4qfl7v9Ly13uzZdNZxoBwsBIYQQMhnUHYLhzxHqCsEbRfhvv+v3ndu9xG1ftWjws7i+/7nlw4l2sBAQQgghk2G8hWDn9WUJcAdXud0vFDPFz7IUPF4cmwcsBIQQQshkGGsh2H7Tm9z2VScNyoDbXf6U67JLsPS2VXPeNHCJd+nAGBYCQgghZDJMZIfA7V46nHDupLPmLof8/p8vGl6aI60QrHEXnniiO/HCNcPrghxb5JY9Nbx6zAzvY8Sm8zfd/zwe25oLwf2mnGfcfw6EEEKsMt5C4D9D8MJit/2Xc58hcC8sdYvOXVqWgZNOW+reukhc4n7/vYUnLXFv+vPi5zEVgkVu0aIw+BYqCFPP2zTX8rE9tcwtgvMp51moPwdCCCHWGGsh2PHrS9xu+byAFIFVbx3sDBRlQI4tXrLK3faoc7f9cqCUA3mXQFx80/ZjLgTL1hTBuWiZG2RfHIRyffgKe7iTsObCE92i2YFoXl6Rj+w4eOLzPuWWLfKv3MH5ls29sp87nf7YRigLwYXFVEiwpnDRsjXl45hdLo+//LNoeV+EEEJ6y1gLgSCfERDOWnzboAAMPevi4vqwDEgJkF2CpXc5t6Rw8dIxFIIi9CTkBzk3GoRzxyXAB8efWrZoLhSLAJUdBh/oo2UhJA7YELnNB/cweIPznzhyW/Njiykfa3E+f7oBo+cJn49cHjz+9vdFCCGkn4y/ENw0KASLzr3NLf72qnJnQMrAoqIg+LcNRt8yWOze9NazxlIIysuVV8Zyee7V9GywBq+811xYzM7uMDSF5WjAliS9vx8/nvAyeGyQ4WzdLog8n8rjn+99EUII6RsLWAiWzu4IiHK9fItguCsgZWBJcZrFNzl31pJHx1QI/KvjZVEQBsE5iw/O4vbZIC0KwmywIqJzzW7Nl1ca7rPutnhOQx6jD/J47fD51L510va+CCGE9ImxFwL5a4TlhwcL/dsDolyXIlBaLJedgbIMfHu3W7R41dgKgb8+9yHDQYiitwDK8lDM+dvk+oUXXljzdoEQ3ZcUAv8yu9wpCMN37j7L7XwY0vWPDdNUCNDjT7kvmQnfzkCXCSGEWGf8hWDp4La3nra0+W2CPx+8VfCm/+cs90/+95PGWAgKRsK5oHx7wG+VByE33O6f3TqPr1eI70uuD89bBPHcbYO5Cy8cvPc/+lcUo3PUPTbPyO2FwYOTzwTIsdmQj5930n3JjHaZEEKIdRauEBThLzsDfldArhf9YOBNriwDZy3Z7hZd/GhRGG47hkJAPKM7EYQQQkg6C1YIys8IFEVA/gZB+bcITlrszvr29oFLHnX/5PcXuUXnytsLt5XfTTDfQjD7yrnGfjB4O2B0d4AQQghJZ0EKgYT7fIzhDgEhhBAyGcZeCMYJCwEhhBAyGVgICCGEEMJCQAghhBAWAkIIIYQUqIVgZstWF8tCQAghhNhCsn3d2o2lG9ZPu+lNMyPZzx0CQgghpAeoOwTDnyOwEBBCCCG2GGshePnhL7r92y53b+y83m2/7U3Fz8vd/peWu12brhpOtIOFgBBCCJkMYy0EbxThv/2u33du9xK3fdWiwc/i+qOrFrult60aeNNA+UeQSpeK+HwsBIQQQshkGG8h2Hl9WQLcwVVu9wvFTPFTru9+YelwYpTdBwt3O/gthQILASGEEDIZxloItt/0Jrd91UmDMuB2lz/luuwSzO4QRLsE27fvZiEghBBCjjMT2SFwu5eWRSBEdgfe+t4lYygE8s/0njjyzwJX/tnfsTC8n1n9+Y/lnwkOH2d8/vA+EE3Psem2Gob/9HP1uWnnmcd9EUIIyY7xFgL/GYIXFrvtv5z7DIF7YVAIFp17mzvprKXlv24o/xyyFIJHHx9HIVjkFi0KQ2khQio6Zxmg8y0CHvQ4Ux9701zL5//UMrcIzqecp+V9EUIIyZKxFoIdv77EPbrqLLd7u3yo8K3lzoCUgd2PLxlODHYG5HMDu4v/2P7Cbrfq0e1jKQTL1hShtmiZG+RSHFJyffjqd7iTsObCE92i2YFoXsJ+ZMdBQOeUQuCPD/4J4tllco6Rx4NefftjDY9l9p82rplbNvfKfu4hx+cI7qvyvArKQhCXm/jxral5fi3vixBCSJaMtRAI8tmA8mfwmYESKQLDMvDo9t3upNMWu1W/3F46lkJQBJKE/CCDRkNq7riE6+D4U8sWzQVWEW6yw+DDdrQseEbPWa6PAjE8Z3iOkfNVisLcOQegYx65zQe3XA5CV847ctvcOdDzjykfe3E+f7oBo+cJn59cHjyn9vdFCCEkP8ZeCOSDgoIvAosWD2bDnYGTFi0uXVSUgttWja8QlJcrr1rl8twr3dnQC14Vr7mwmJ3dYagLsvg8IHzlnJVzhI9FiB9bfF/gWBn2/n7bnlcuh487Dv2Q4WxdYVGfX5v7IoQQkhPjLwTD7xSYLQTnLoVvE0ghkJ9Lb3t0jIXAv3JdFoVUEGqz+FArbp8NuSLkZ0Mvpu484fHhOdW3L/x1dM7oWO2OQup54zkNeQ4+yOO12vNre1+EEEJyYeEKwXCnQD5EWL5N8Pj2ckdAPkS4eMltg7cMikKw5KbxFgJ/fe5DhoOAq74FUNwi5aGY87fJ9QsvvBDO1ofd6PFyyzw6xzG9ZSDz/mV2uVPgb5O5ufOW2/nwvPXPH9NUCNCfUcp9yUy4o4IuE0IIOZ4sWCGQtw7Kv1q4SArB4DMDsivwVvG9g7cK5PMDS5aOuxAUjARnQfn2gN/GDgKonAu2tePrI4D7KYmOx/ddIjP+/kdvk7Igx3HACsHaIojnbhvMXXjh4L3/0fNG56h7/p6R2wuDP4DK46s8v5T7khntMiGEkOPJghYC+WuF5XcNvLDbPTp8m0B2CFY9WliUgdsKF3/7WAsBmSSjOxGEEEKssCCFQHYGBsE/2AWQ3QBx6V2DzwwsvenR8q2CxUsLO1IIZl89R/aHwdsB1d0PQgghFliQQiAB31YEdwgIIYSQyTD2QjBOWAgIIYSQycBCQAghhBC9EMxs2epiWQgIIYQQW0i2r1u7sXTD+mk3vWlmJPu5Q0AIIYT0AHWHYPhzBF8Itj6/i1JKKaUdVzimQkAIIYQQG7AQEEIIIYSFgJC+8rP7flEacizHCCHd5pgKweHDr1NKO2oY6uM4RintrsIxFYK9r75GKe2wnnEdo5R2U+GYCsFLO3ZRSimltOMK8yoEt/30ruEl57Zuf4ZSSimlHdUj2d66ENyzcrV7bPq3w2uEEEII6TKS6ZLtrQuBIAulTcgWA6WUUkq7qWR5WAbEXS/vcQcPHB4m/oDaQhBy6OBht3vXvpGTtVG+Nxkd74t8/nz+6Hhf5PPn80fH+2Kuz18yXbI9JKkQHD70unt173738guvwBNr8r8QfP7oeF/k8+fzR8f7Ip9/fs9fslwyXbI9JKkQHDly1B08cKg8we6d+8r3Htoo/6oSOt4X+fz5/NHxvsjnz+ePjvfF3J6/ZLhkuWS6ZHtIUiF44+gb5UJpE7LFIO87yIcRUpV/YhEd74t8/nz+6Hhf5PPn80fH+2JOz1+yWzJcslwyXbI9JKkQHCvy7yz3GT5/Pv8+w+fP599nuvT8WQgmAJ8/n3+f4fPn8+8zXXr+LAQTgM+fz7/P8Pnz+feZ7jx/5/5/znWC9dWVZSkAAAAASUVORK5CYII=" /></p>
</div>
<div id="date-formatting" class="section level2">
<h2>Date Formatting</h2>
<div class="sourceCode" id="cb2"><pre class="sourceCode r"><code class="sourceCode r"><span id="cb2-1"><a href="#cb2-1" tabindex="-1"></a><span class="co"># data.frame of dates</span></span>
<span id="cb2-2"><a href="#cb2-2" tabindex="-1"></a>dates <span class="ot">&lt;-</span> <span class="fu">data.frame</span>(<span class="st">&quot;d1&quot;</span> <span class="ot">=</span> <span class="fu">Sys.Date</span>() <span class="sc">-</span> <span class="dv">0</span><span class="sc">:</span><span class="dv">4</span>)</span>
<span id="cb2-3"><a href="#cb2-3" tabindex="-1"></a><span class="cf">for</span>(i <span class="cf">in</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">3</span>) dates <span class="ot">&lt;-</span> <span class="fu">cbind</span>(dates, dates)</span>
<span id="cb2-4"><a href="#cb2-4" tabindex="-1"></a><span class="fu">names</span>(dates) <span class="ot">&lt;-</span> <span class="fu">paste0</span>(<span class="st">&quot;d&quot;</span>, <span class="dv">1</span><span class="sc">:</span><span class="dv">8</span>)</span>
<span id="cb2-5"><a href="#cb2-5" tabindex="-1"></a></span>
<span id="cb2-6"><a href="#cb2-6" tabindex="-1"></a><span class="do">## Date Formatting</span></span>
<span id="cb2-7"><a href="#cb2-7" tabindex="-1"></a>wb <span class="ot">&lt;-</span> <span class="fu">createWorkbook</span>()</span>
<span id="cb2-8"><a href="#cb2-8" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Date Formatting&quot;</span>, <span class="at">gridLines =</span> <span class="cn">FALSE</span>)</span>
<span id="cb2-9"><a href="#cb2-9" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, dates) <span class="do">## write without styling</span></span>
<span id="cb2-10"><a href="#cb2-10" tabindex="-1"></a></span>
<span id="cb2-11"><a href="#cb2-11" tabindex="-1"></a><span class="do">## openxlsx converts columns of class &quot;Date&quot; to Excel dates with the format given by</span></span>
<span id="cb2-12"><a href="#cb2-12" tabindex="-1"></a><span class="fu">getOption</span>(<span class="st">&quot;openxlsx.dateFormat&quot;</span>, <span class="st">&quot;mm/dd/yyyy&quot;</span>)</span>
<span id="cb2-13"><a href="#cb2-13" tabindex="-1"></a></span>
<span id="cb2-14"><a href="#cb2-14" tabindex="-1"></a><span class="do">## this can be set via (for example)</span></span>
<span id="cb2-15"><a href="#cb2-15" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.dateFormat&quot;</span> <span class="ot">=</span> <span class="st">&quot;yyyy/mm/dd&quot;</span>)</span>
<span id="cb2-16"><a href="#cb2-16" tabindex="-1"></a><span class="do">## custom date formats can be made up of any combination of:</span></span>
<span id="cb2-17"><a href="#cb2-17" tabindex="-1"></a><span class="do">##   d, dd, ddd, dddd, m, mm, mmm, mmmm, mmmmm, yy, yyyy</span></span>
<span id="cb2-18"><a href="#cb2-18" tabindex="-1"></a></span>
<span id="cb2-19"><a href="#cb2-19" tabindex="-1"></a><span class="do">## numFmt == &quot;DATE&quot; will use the date format specified by the above</span></span>
<span id="cb2-20"><a href="#cb2-20" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;DATE&quot;</span>), <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">1</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>) </span>
<span id="cb2-21"><a href="#cb2-21" tabindex="-1"></a></span>
<span id="cb2-22"><a href="#cb2-22" tabindex="-1"></a><span class="do">## some custom date format examples</span></span>
<span id="cb2-23"><a href="#cb2-23" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;yyyy/mm/dd&quot;</span>)</span>
<span id="cb2-24"><a href="#cb2-24" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">2</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-25"><a href="#cb2-25" tabindex="-1"></a></span>
<span id="cb2-26"><a href="#cb2-26" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;yyyy/mmm/dd&quot;</span>)</span>
<span id="cb2-27"><a href="#cb2-27" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">3</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-28"><a href="#cb2-28" tabindex="-1"></a></span>
<span id="cb2-29"><a href="#cb2-29" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;yy / mmmm / dd&quot;</span>)</span>
<span id="cb2-30"><a href="#cb2-30" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">4</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-31"><a href="#cb2-31" tabindex="-1"></a></span>
<span id="cb2-32"><a href="#cb2-32" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;ddddd&quot;</span>)</span>
<span id="cb2-33"><a href="#cb2-33" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">5</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-34"><a href="#cb2-34" tabindex="-1"></a></span>
<span id="cb2-35"><a href="#cb2-35" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;yyyy-mmm-dd&quot;</span>)</span>
<span id="cb2-36"><a href="#cb2-36" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">6</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-37"><a href="#cb2-37" tabindex="-1"></a></span>
<span id="cb2-38"><a href="#cb2-38" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;mm/ dd yyyy&quot;</span>)</span>
<span id="cb2-39"><a href="#cb2-39" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">7</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-40"><a href="#cb2-40" tabindex="-1"></a></span>
<span id="cb2-41"><a href="#cb2-41" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;mm/dd/yy&quot;</span>)</span>
<span id="cb2-42"><a href="#cb2-42" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">8</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb2-43"><a href="#cb2-43" tabindex="-1"></a></span>
<span id="cb2-44"><a href="#cb2-44" tabindex="-1"></a><span class="fu">setColWidths</span>(wb, <span class="dv">1</span>, <span class="at">cols =</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">10</span>, <span class="at">widths =</span> <span class="dv">23</span>)</span>
<span id="cb2-45"><a href="#cb2-45" tabindex="-1"></a></span>
<span id="cb2-46"><a href="#cb2-46" tabindex="-1"></a><span class="do">## The default date format used in writeData and writeDataTable can be set with:</span></span>
<span id="cb2-47"><a href="#cb2-47" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.dateFormat&quot;</span> <span class="ot">=</span> <span class="st">&quot;dd/mm/yyyy&quot;</span>)</span>
<span id="cb2-48"><a href="#cb2-48" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Date Formatting&quot;</span>, dates, <span class="at">startRow  =</span> <span class="dv">8</span>, <span class="at">borders =</span> <span class="st">&quot;rows&quot;</span>)</span>
<span id="cb2-49"><a href="#cb2-49" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.dateFormat&quot;</span> <span class="ot">=</span> <span class="st">&quot;yyyy-mm-dd&quot;</span>)</span>
<span id="cb2-50"><a href="#cb2-50" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Date Formatting&quot;</span>, dates, <span class="at">startRow  =</span> <span class="dv">15</span>)</span>
<span id="cb2-51"><a href="#cb2-51" tabindex="-1"></a></span>
<span id="cb2-52"><a href="#cb2-52" tabindex="-1"></a><span class="fu">saveWorkbook</span>(wb, <span class="st">&quot;Date Formatting.xlsx&quot;</span>, <span class="at">overwrite =</span> <span class="cn">TRUE</span>)</span></code></pre></div>
</div>
<div id="datetime-formatting" class="section level2">
<h2>DateTime Formatting</h2>
<p>The conversion from POSIX to Excel datetimes is dependent on the
timezone you are in. If POSIX values are being written incorrectly, try
setting the timezone with (for example)</p>
<div class="sourceCode" id="cb3"><pre class="sourceCode r"><code class="sourceCode r"><span id="cb3-1"><a href="#cb3-1" tabindex="-1"></a><span class="fu">Sys.setenv</span>(<span class="at">TZ =</span> <span class="st">&quot;Australia/Sydney&quot;</span>)</span>
<span id="cb3-2"><a href="#cb3-2" tabindex="-1"></a></span>
<span id="cb3-3"><a href="#cb3-3" tabindex="-1"></a>dateTimes <span class="ot">&lt;-</span> <span class="fu">data.frame</span>(<span class="st">&quot;d1&quot;</span> <span class="ot">=</span> <span class="fu">Sys.time</span>() <span class="sc">-</span> <span class="dv">0</span><span class="sc">:</span><span class="dv">4</span><span class="sc">*</span><span class="dv">10000</span>)</span>
<span id="cb3-4"><a href="#cb3-4" tabindex="-1"></a><span class="cf">for</span>(i <span class="cf">in</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>) dateTimes <span class="ot">&lt;-</span> <span class="fu">cbind</span>(dateTimes, dateTimes)</span>
<span id="cb3-5"><a href="#cb3-5" tabindex="-1"></a><span class="fu">names</span>(dateTimes) <span class="ot">&lt;-</span> <span class="fu">paste0</span>(<span class="st">&quot;d&quot;</span>, <span class="dv">1</span><span class="sc">:</span><span class="dv">4</span>)</span>
<span id="cb3-6"><a href="#cb3-6" tabindex="-1"></a></span>
<span id="cb3-7"><a href="#cb3-7" tabindex="-1"></a><span class="do">## POSIX Formatting</span></span>
<span id="cb3-8"><a href="#cb3-8" tabindex="-1"></a>wb <span class="ot">&lt;-</span> <span class="fu">createWorkbook</span>()</span>
<span id="cb3-9"><a href="#cb3-9" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;DateTime Formatting&quot;</span>, <span class="at">gridLines =</span> <span class="cn">FALSE</span>)</span>
<span id="cb3-10"><a href="#cb3-10" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, dateTimes) <span class="do">## write without styling</span></span>
<span id="cb3-11"><a href="#cb3-11" tabindex="-1"></a></span>
<span id="cb3-12"><a href="#cb3-12" tabindex="-1"></a><span class="do">## openxlsx converts columns of class &quot;POSIxt&quot; to Excel datetimes with the format given by</span></span>
<span id="cb3-13"><a href="#cb3-13" tabindex="-1"></a><span class="fu">getOption</span>(<span class="st">&quot;openxlsx.datetimeFormat&quot;</span>, <span class="st">&quot;yyyy/mm/dd hh:mm:ss&quot;</span>)</span>
<span id="cb3-14"><a href="#cb3-14" tabindex="-1"></a></span>
<span id="cb3-15"><a href="#cb3-15" tabindex="-1"></a><span class="do">## this can be set via (for example)</span></span>
<span id="cb3-16"><a href="#cb3-16" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.datetimeFormat&quot;</span> <span class="ot">=</span> <span class="st">&quot;yyyy-mm-dd hh:mm:ss&quot;</span>)</span>
<span id="cb3-17"><a href="#cb3-17" tabindex="-1"></a><span class="do">## custom datetime formats can be made up of any combination of:</span></span>
<span id="cb3-18"><a href="#cb3-18" tabindex="-1"></a><span class="do">## d, dd, ddd, dddd, m, mm, mmm, mmmm, mmmmm, yy, yyyy, h, hh, m, mm, s, ss, AM/PM</span></span>
<span id="cb3-19"><a href="#cb3-19" tabindex="-1"></a></span>
<span id="cb3-20"><a href="#cb3-20" tabindex="-1"></a><span class="do">## numFmt == &quot;LONGDATE&quot; will use the date format specified by the above</span></span>
<span id="cb3-21"><a href="#cb3-21" tabindex="-1"></a>long_date_style <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;LONGDATE&quot;</span>)</span>
<span id="cb3-22"><a href="#cb3-22" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> long_date_style, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">1</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>) </span>
<span id="cb3-23"><a href="#cb3-23" tabindex="-1"></a></span>
<span id="cb3-24"><a href="#cb3-24" tabindex="-1"></a><span class="do">## some custom date format examples</span></span>
<span id="cb3-25"><a href="#cb3-25" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;yyyy/mm/dd hh:mm:ss AM/PM&quot;</span>)</span>
<span id="cb3-26"><a href="#cb3-26" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">2</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb3-27"><a href="#cb3-27" tabindex="-1"></a></span>
<span id="cb3-28"><a href="#cb3-28" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;hh:mm:ss AM/PM&quot;</span>)</span>
<span id="cb3-29"><a href="#cb3-29" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">3</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb3-30"><a href="#cb3-30" tabindex="-1"></a></span>
<span id="cb3-31"><a href="#cb3-31" tabindex="-1"></a>sty <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;hh:mm:ss&quot;</span>)</span>
<span id="cb3-32"><a href="#cb3-32" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> sty, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">cols =</span> <span class="dv">4</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb3-33"><a href="#cb3-33" tabindex="-1"></a></span>
<span id="cb3-34"><a href="#cb3-34" tabindex="-1"></a><span class="fu">setColWidths</span>(wb, <span class="dv">1</span>, <span class="at">cols =</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">4</span>, <span class="at">widths =</span> <span class="dv">30</span>)</span>
<span id="cb3-35"><a href="#cb3-35" tabindex="-1"></a></span>
<span id="cb3-36"><a href="#cb3-36" tabindex="-1"></a><span class="do">## The default date format used in writeData and writeDataTable can be set with:</span></span>
<span id="cb3-37"><a href="#cb3-37" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.datetimeFormat&quot;</span> <span class="ot">=</span> <span class="st">&quot;yyyy/mm/dd hh:mm:ss&quot;</span>)</span>
<span id="cb3-38"><a href="#cb3-38" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;DateTime Formatting&quot;</span>, dateTimes, <span class="at">startRow  =</span> <span class="dv">8</span>, <span class="at">borders =</span> <span class="st">&quot;rows&quot;</span>)</span>
<span id="cb3-39"><a href="#cb3-39" tabindex="-1"></a></span>
<span id="cb3-40"><a href="#cb3-40" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.datetimeFormat&quot;</span> <span class="ot">=</span> <span class="st">&quot;hh:mm:ss AM/PM&quot;</span>)</span>
<span id="cb3-41"><a href="#cb3-41" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="st">&quot;DateTime Formatting&quot;</span>, dateTimes, <span class="at">startRow  =</span> <span class="dv">15</span>)</span>
<span id="cb3-42"><a href="#cb3-42" tabindex="-1"></a></span>
<span id="cb3-43"><a href="#cb3-43" tabindex="-1"></a><span class="fu">saveWorkbook</span>(wb, <span class="st">&quot;DateTime Formatting.xlsx&quot;</span>, <span class="at">overwrite =</span> <span class="cn">TRUE</span>)</span>
<span id="cb3-44"><a href="#cb3-44" tabindex="-1"></a><span class="fu">openXL</span>(<span class="st">&quot;DateTime Formatting.xlsx&quot;</span>)</span></code></pre></div>
</div>
<div id="conditional-formatting" class="section level2">
<h2>Conditional Formatting</h2>
<div class="sourceCode" id="cb4"><pre class="sourceCode r"><code class="sourceCode r"><span id="cb4-1"><a href="#cb4-1" tabindex="-1"></a>wb <span class="ot">&lt;-</span> <span class="fu">createWorkbook</span>()</span>
<span id="cb4-2"><a href="#cb4-2" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;cellIs&quot;</span>)</span>
<span id="cb4-3"><a href="#cb4-3" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Moving Row&quot;</span>)</span>
<span id="cb4-4"><a href="#cb4-4" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Moving Col&quot;</span>)</span>
<span id="cb4-5"><a href="#cb4-5" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Dependent on 1&quot;</span>)</span>
<span id="cb4-6"><a href="#cb4-6" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Duplicates&quot;</span>)</span>
<span id="cb4-7"><a href="#cb4-7" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;containsText&quot;</span>)</span>
<span id="cb4-8"><a href="#cb4-8" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;colourScale&quot;</span>, <span class="at">zoom =</span> <span class="dv">30</span>)</span>
<span id="cb4-9"><a href="#cb4-9" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;databar&quot;</span>)</span>
<span id="cb4-10"><a href="#cb4-10" tabindex="-1"></a></span>
<span id="cb4-11"><a href="#cb4-11" tabindex="-1"></a>negStyle <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">fontColour =</span> <span class="st">&quot;#9C0006&quot;</span>, <span class="at">bgFill =</span> <span class="st">&quot;#FFC7CE&quot;</span>)</span>
<span id="cb4-12"><a href="#cb4-12" tabindex="-1"></a>posStyle <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">fontColour =</span> <span class="st">&quot;#006100&quot;</span>, <span class="at">bgFill =</span> <span class="st">&quot;#C6EFCE&quot;</span>)</span>
<span id="cb4-13"><a href="#cb4-13" tabindex="-1"></a></span>
<span id="cb4-14"><a href="#cb4-14" tabindex="-1"></a><span class="do">## rule applies to all each cell in range</span></span>
<span id="cb4-15"><a href="#cb4-15" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;cellIs&quot;</span>, <span class="sc">-</span><span class="dv">5</span><span class="sc">:</span><span class="dv">5</span>)</span>
<span id="cb4-16"><a href="#cb4-16" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;cellIs&quot;</span>, LETTERS[<span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>], <span class="at">startCol=</span><span class="dv">2</span>)</span>
<span id="cb4-17"><a href="#cb4-17" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;cellIs&quot;</span>, <span class="at">cols=</span><span class="dv">1</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;!=0&quot;</span>, <span class="at">style =</span> negStyle)</span>
<span id="cb4-18"><a href="#cb4-18" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;cellIs&quot;</span>, <span class="at">cols=</span><span class="dv">1</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;==0&quot;</span>, <span class="at">style =</span> posStyle)</span>
<span id="cb4-19"><a href="#cb4-19" tabindex="-1"></a></span>
<span id="cb4-20"><a href="#cb4-20" tabindex="-1"></a><span class="do">## highlight row dependent on first cell in row</span></span>
<span id="cb4-21"><a href="#cb4-21" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Moving Row&quot;</span>, <span class="sc">-</span><span class="dv">5</span><span class="sc">:</span><span class="dv">5</span>)</span>
<span id="cb4-22"><a href="#cb4-22" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Moving Row&quot;</span>, LETTERS[<span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>], <span class="at">startCol=</span><span class="dv">2</span>)</span>
<span id="cb4-23"><a href="#cb4-23" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Moving Row&quot;</span>, <span class="at">cols=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;$A1&lt;0&quot;</span>, <span class="at">style =</span> negStyle)</span>
<span id="cb4-24"><a href="#cb4-24" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Moving Row&quot;</span>, <span class="at">cols=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;$A1&gt;0&quot;</span>, <span class="at">style =</span> posStyle)</span>
<span id="cb4-25"><a href="#cb4-25" tabindex="-1"></a></span>
<span id="cb4-26"><a href="#cb4-26" tabindex="-1"></a><span class="do">## highlight column dependent on first cell in column</span></span>
<span id="cb4-27"><a href="#cb4-27" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Moving Col&quot;</span>, <span class="sc">-</span><span class="dv">5</span><span class="sc">:</span><span class="dv">5</span>)</span>
<span id="cb4-28"><a href="#cb4-28" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Moving Col&quot;</span>, LETTERS[<span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>], <span class="at">startCol=</span><span class="dv">2</span>)</span>
<span id="cb4-29"><a href="#cb4-29" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Moving Col&quot;</span>, <span class="at">cols=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;A$1&lt;0&quot;</span>, <span class="at">style =</span> negStyle)</span>
<span id="cb4-30"><a href="#cb4-30" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Moving Col&quot;</span>, <span class="at">cols=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;A$1&gt;0&quot;</span>, <span class="at">style =</span> posStyle)</span>
<span id="cb4-31"><a href="#cb4-31" tabindex="-1"></a></span>
<span id="cb4-32"><a href="#cb4-32" tabindex="-1"></a><span class="do">## highlight entire range cols X rows dependent only on cell A1</span></span>
<span id="cb4-33"><a href="#cb4-33" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Dependent on 1&quot;</span>, <span class="sc">-</span><span class="dv">5</span><span class="sc">:</span><span class="dv">5</span>)</span>
<span id="cb4-34"><a href="#cb4-34" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Dependent on 1&quot;</span>, LETTERS[<span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>], <span class="at">startCol=</span><span class="dv">2</span>)</span>
<span id="cb4-35"><a href="#cb4-35" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Dependent on 1&quot;</span>, <span class="at">cols=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;$A$1&lt;0&quot;</span>, <span class="at">style =</span> negStyle)</span>
<span id="cb4-36"><a href="#cb4-36" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Dependent on 1&quot;</span>, <span class="at">cols=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">2</span>, <span class="at">rows=</span><span class="dv">1</span><span class="sc">:</span><span class="dv">11</span>, <span class="at">rule=</span><span class="st">&quot;$A$1&gt;0&quot;</span>, <span class="at">style =</span> posStyle)</span>
<span id="cb4-37"><a href="#cb4-37" tabindex="-1"></a></span>
<span id="cb4-38"><a href="#cb4-38" tabindex="-1"></a><span class="do">## highlight duplicates using default style</span></span>
<span id="cb4-39"><a href="#cb4-39" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;Duplicates&quot;</span>, <span class="fu">sample</span>(LETTERS[<span class="dv">1</span><span class="sc">:</span><span class="dv">15</span>], <span class="at">size =</span> <span class="dv">10</span>, <span class="at">replace =</span> <span class="cn">TRUE</span>))</span>
<span id="cb4-40"><a href="#cb4-40" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;Duplicates&quot;</span>, <span class="at">cols =</span> <span class="dv">1</span>, <span class="at">rows =</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">10</span>, <span class="at">type =</span> <span class="st">&quot;duplicates&quot;</span>)</span>
<span id="cb4-41"><a href="#cb4-41" tabindex="-1"></a></span>
<span id="cb4-42"><a href="#cb4-42" tabindex="-1"></a><span class="do">## cells containing text</span></span>
<span id="cb4-43"><a href="#cb4-43" tabindex="-1"></a>fn <span class="ot">&lt;-</span> <span class="cf">function</span>(x) <span class="fu">paste</span>(<span class="fu">sample</span>(LETTERS, <span class="dv">10</span>), <span class="at">collapse =</span> <span class="st">&quot;-&quot;</span>)</span>
<span id="cb4-44"><a href="#cb4-44" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;containsText&quot;</span>, <span class="fu">sapply</span>(<span class="dv">1</span><span class="sc">:</span><span class="dv">10</span>, fn))</span>
<span id="cb4-45"><a href="#cb4-45" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;containsText&quot;</span>, <span class="at">cols =</span> <span class="dv">1</span>, <span class="at">rows =</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">10</span>, <span class="at">type =</span> <span class="st">&quot;contains&quot;</span>, <span class="at">rule =</span> <span class="st">&quot;A&quot;</span>)</span>
<span id="cb4-46"><a href="#cb4-46" tabindex="-1"></a></span>
<span id="cb4-47"><a href="#cb4-47" tabindex="-1"></a><span class="do">## colourscale colours cells based on cell value</span></span>
<span id="cb4-48"><a href="#cb4-48" tabindex="-1"></a>df <span class="ot">&lt;-</span> <span class="fu">read.xlsx</span>(<span class="fu">system.file</span>(<span class="st">&quot;extdata&quot;</span>, <span class="st">&quot;readTest.xlsx&quot;</span>, <span class="at">package =</span> <span class="st">&quot;openxlsx&quot;</span>), <span class="at">sheet =</span> <span class="dv">5</span>)</span>
<span id="cb4-49"><a href="#cb4-49" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;colourScale&quot;</span>, df, <span class="at">colNames=</span><span class="cn">FALSE</span>)  <span class="do">## write data.frame</span></span>
<span id="cb4-50"><a href="#cb4-50" tabindex="-1"></a></span>
<span id="cb4-51"><a href="#cb4-51" tabindex="-1"></a><span class="do">## rule is a vector or colours of length 2 or 3 (any hex colour or any of colours())</span></span>
<span id="cb4-52"><a href="#cb4-52" tabindex="-1"></a><span class="do">## If rule is NULL, min and max of cells is used. Rule must be the same length as style or NULL.</span></span>
<span id="cb4-53"><a href="#cb4-53" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;colourScale&quot;</span>, <span class="at">cols=</span><span class="fu">seq_len</span>(<span class="fu">ncol</span>(df)), <span class="at">rows=</span><span class="fu">seq_len</span>(<span class="fu">nrow</span>(df)),</span>
<span id="cb4-54"><a href="#cb4-54" tabindex="-1"></a>   <span class="at">style =</span> <span class="fu">c</span>(<span class="st">&quot;black&quot;</span>, <span class="st">&quot;white&quot;</span>), </span>
<span id="cb4-55"><a href="#cb4-55" tabindex="-1"></a>   <span class="at">rule =</span> <span class="fu">c</span>(<span class="dv">0</span>, <span class="dv">255</span>), </span>
<span id="cb4-56"><a href="#cb4-56" tabindex="-1"></a>   <span class="at">type =</span> <span class="st">&quot;colourScale&quot;</span>)</span>
<span id="cb4-57"><a href="#cb4-57" tabindex="-1"></a></span>
<span id="cb4-58"><a href="#cb4-58" tabindex="-1"></a><span class="fu">setColWidths</span>(wb, <span class="st">&quot;colourScale&quot;</span>, <span class="at">cols =</span> <span class="fu">seq_len</span>(<span class="fu">ncol</span>(df)), <span class="at">widths =</span> <span class="fl">1.07</span>)</span>
<span id="cb4-59"><a href="#cb4-59" tabindex="-1"></a><span class="fu">setRowHeights</span>(wb, <span class="st">&quot;colourScale&quot;</span>, <span class="at">rows =</span> <span class="fu">seq_len</span>(<span class="fu">nrow</span>(df)), <span class="at">heights =</span> <span class="fl">7.5</span>) </span>
<span id="cb4-60"><a href="#cb4-60" tabindex="-1"></a></span>
<span id="cb4-61"><a href="#cb4-61" tabindex="-1"></a><span class="do">## Databars</span></span>
<span id="cb4-62"><a href="#cb4-62" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="st">&quot;databar&quot;</span>, <span class="sc">-</span><span class="dv">5</span><span class="sc">:</span><span class="dv">5</span>)</span>
<span id="cb4-63"><a href="#cb4-63" tabindex="-1"></a><span class="fu">conditionalFormatting</span>(wb, <span class="st">&quot;databar&quot;</span>, <span class="at">cols =</span> <span class="dv">1</span>, <span class="at">rows =</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">12</span>, <span class="at">type =</span> <span class="st">&quot;databar&quot;</span>) <span class="do">## Default colours</span></span>
<span id="cb4-64"><a href="#cb4-64" tabindex="-1"></a></span>
<span id="cb4-65"><a href="#cb4-65" tabindex="-1"></a><span class="fu">saveWorkbook</span>(wb, <span class="st">&quot;conditionalFormattingExample.xlsx&quot;</span>, <span class="cn">TRUE</span>)</span>
<span id="cb4-66"><a href="#cb4-66" tabindex="-1"></a></span>
<span id="cb4-67"><a href="#cb4-67" tabindex="-1"></a><span class="fu">openXL</span>(wb)</span></code></pre></div>
</div>
<div id="numeric-formatting" class="section level2">
<h2>Numeric Formatting</h2>
<p>numeric columns styling can be set using the numFmt parameter in
createStyle or a default can be set with, for example,
options(“openxlsx.numFmt” = “#,#0.00”)</p>
<div class="sourceCode" id="cb5"><pre class="sourceCode r"><code class="sourceCode r"><span id="cb5-1"><a href="#cb5-1" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.numFmt&quot;</span> <span class="ot">=</span> <span class="cn">NULL</span>)</span>
<span id="cb5-2"><a href="#cb5-2" tabindex="-1"></a>wb <span class="ot">&lt;-</span> <span class="fu">createWorkbook</span>()</span>
<span id="cb5-3"><a href="#cb5-3" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Sheet 1&quot;</span>)</span>
<span id="cb5-4"><a href="#cb5-4" tabindex="-1"></a>df <span class="ot">&lt;-</span> <span class="fu">data.frame</span>(<span class="fu">matrix</span>(<span class="fl">12.987654321</span>, <span class="at">ncol =</span> <span class="dv">7</span>, <span class="at">nrow =</span> <span class="dv">5</span>)) <span class="do">## data.frame to write</span></span>
<span id="cb5-5"><a href="#cb5-5" tabindex="-1"></a>df[ ,<span class="dv">6</span><span class="sc">:</span><span class="dv">7</span>] <span class="ot">&lt;-</span> df[ ,<span class="dv">6</span><span class="sc">:</span><span class="dv">7</span>]<span class="sc">*</span><span class="fl">1E6</span></span>
<span id="cb5-6"><a href="#cb5-6" tabindex="-1"></a></span>
<span id="cb5-7"><a href="#cb5-7" tabindex="-1"></a><span class="do">## Set column 1 class to &quot;comma&quot; to get comma separated thousands</span></span>
<span id="cb5-8"><a href="#cb5-8" tabindex="-1"></a><span class="fu">class</span>(df<span class="sc">$</span>X1) <span class="ot">&lt;-</span> <span class="st">&quot;comma&quot;</span></span>
<span id="cb5-9"><a href="#cb5-9" tabindex="-1"></a></span>
<span id="cb5-10"><a href="#cb5-10" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, df)</span>
<span id="cb5-11"><a href="#cb5-11" tabindex="-1"></a>s <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;0.0&quot;</span>)</span>
<span id="cb5-12"><a href="#cb5-12" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> s, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">6</span>, <span class="at">cols =</span> <span class="dv">2</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb5-13"><a href="#cb5-13" tabindex="-1"></a></span>
<span id="cb5-14"><a href="#cb5-14" tabindex="-1"></a>s <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;0.00&quot;</span>)</span>
<span id="cb5-15"><a href="#cb5-15" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> s, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">6</span>, <span class="at">cols =</span> <span class="dv">3</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb5-16"><a href="#cb5-16" tabindex="-1"></a></span>
<span id="cb5-17"><a href="#cb5-17" tabindex="-1"></a>s <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;0.000&quot;</span>)</span>
<span id="cb5-18"><a href="#cb5-18" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> s, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">6</span>, <span class="at">cols =</span> <span class="dv">4</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb5-19"><a href="#cb5-19" tabindex="-1"></a></span>
<span id="cb5-20"><a href="#cb5-20" tabindex="-1"></a>s <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;#,##0&quot;</span>)</span>
<span id="cb5-21"><a href="#cb5-21" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> s, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">6</span>, <span class="at">cols =</span> <span class="dv">5</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb5-22"><a href="#cb5-22" tabindex="-1"></a></span>
<span id="cb5-23"><a href="#cb5-23" tabindex="-1"></a>s <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;#,##0.00&quot;</span>)</span>
<span id="cb5-24"><a href="#cb5-24" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> s, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">6</span>, <span class="at">cols =</span> <span class="dv">6</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb5-25"><a href="#cb5-25" tabindex="-1"></a></span>
<span id="cb5-26"><a href="#cb5-26" tabindex="-1"></a>s <span class="ot">&lt;-</span> <span class="fu">createStyle</span>(<span class="at">numFmt =</span> <span class="st">&quot;$ #,##0.00&quot;</span>)</span>
<span id="cb5-27"><a href="#cb5-27" tabindex="-1"></a><span class="fu">addStyle</span>(wb, <span class="dv">1</span>, <span class="at">style =</span> s, <span class="at">rows =</span> <span class="dv">2</span><span class="sc">:</span><span class="dv">6</span>, <span class="at">cols =</span> <span class="dv">7</span>, <span class="at">gridExpand =</span> <span class="cn">TRUE</span>)</span>
<span id="cb5-28"><a href="#cb5-28" tabindex="-1"></a></span>
<span id="cb5-29"><a href="#cb5-29" tabindex="-1"></a><span class="do">## set a default number format for numeric columns of data.frames</span></span>
<span id="cb5-30"><a href="#cb5-30" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.numFmt&quot;</span> <span class="ot">=</span> <span class="st">&quot;$* #,#0.00&quot;</span>)</span>
<span id="cb5-31"><a href="#cb5-31" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="dv">1</span>, <span class="at">x =</span> <span class="fu">data.frame</span>(<span class="st">&quot;Using Default Options&quot;</span> <span class="ot">=</span> <span class="fu">rep</span>(<span class="fl">2345.1235</span>, <span class="dv">5</span>)), <span class="at">startCol =</span> <span class="dv">9</span>)</span>
<span id="cb5-32"><a href="#cb5-32" tabindex="-1"></a></span>
<span id="cb5-33"><a href="#cb5-33" tabindex="-1"></a><span class="fu">setColWidths</span>(wb, <span class="dv">1</span>, <span class="at">cols =</span> <span class="dv">1</span><span class="sc">:</span><span class="dv">10</span>, <span class="at">widths =</span> <span class="dv">15</span>)</span>
<span id="cb5-34"><a href="#cb5-34" tabindex="-1"></a></span>
<span id="cb5-35"><a href="#cb5-35" tabindex="-1"></a><span class="do">## Using default numFmt to round to 2 dp (Any numeric column will be affected)</span></span>
<span id="cb5-36"><a href="#cb5-36" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Sheet 2&quot;</span>)</span>
<span id="cb5-37"><a href="#cb5-37" tabindex="-1"></a>df <span class="ot">&lt;-</span> iris</span>
<span id="cb5-38"><a href="#cb5-38" tabindex="-1"></a>df[, <span class="dv">1</span><span class="sc">:</span><span class="dv">4</span>] <span class="ot">&lt;-</span> df[<span class="dv">1</span><span class="sc">:</span><span class="dv">4</span>] <span class="sc">+</span> <span class="fu">runif</span>(<span class="dv">1</span>)</span>
<span id="cb5-39"><a href="#cb5-39" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="at">sheet =</span> <span class="dv">2</span>, <span class="at">x =</span> df)</span>
<span id="cb5-40"><a href="#cb5-40" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="at">sheet =</span> <span class="dv">2</span>, <span class="at">x =</span> df, <span class="at">startCol =</span> <span class="dv">7</span>)</span>
<span id="cb5-41"><a href="#cb5-41" tabindex="-1"></a><span class="fu">writeData</span>(wb, <span class="at">sheet =</span> <span class="dv">2</span>, <span class="at">x =</span> df, <span class="at">startCol =</span> <span class="dv">13</span>, <span class="at">borders =</span> <span class="st">&quot;rows&quot;</span>)</span>
<span id="cb5-42"><a href="#cb5-42" tabindex="-1"></a></span>
<span id="cb5-43"><a href="#cb5-43" tabindex="-1"></a><span class="do">## To stop auto-formatting numerics set</span></span>
<span id="cb5-44"><a href="#cb5-44" tabindex="-1"></a><span class="fu">options</span>(<span class="st">&quot;openxlsx.numFmt&quot;</span> <span class="ot">=</span> <span class="cn">NULL</span>)</span>
<span id="cb5-45"><a href="#cb5-45" tabindex="-1"></a><span class="fu">addWorksheet</span>(wb, <span class="st">&quot;Sheet 3&quot;</span>)</span>
<span id="cb5-46"><a href="#cb5-46" tabindex="-1"></a><span class="fu">writeDataTable</span>(wb, <span class="at">sheet =</span> <span class="dv">3</span>, <span class="at">x =</span> df)</span>
<span id="cb5-47"><a href="#cb5-47" tabindex="-1"></a></span>
<span id="cb5-48"><a href="#cb5-48" tabindex="-1"></a><span class="fu">openXL</span>(wb)</span></code></pre></div>
</div>



<!-- code folding -->


<!-- dynamically load mathjax for compatibility with self-contained -->
<script>
  (function () {
    var script = document.createElement("script");
    script.type = "text/javascript";
    script.src  = "https://mathjax.rstudio.com/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML";
    document.getElementsByTagName("head")[0].appendChild(script);
  })();
</script>

</body>
</html>