PScribo

0.10.0

Src/Plugins/Word/Out-WordTable.ps1

                                function Out-WordTable

{

<#

    .SYNOPSIS

        Output one (or more listed) formatted Word tables.

    .NOTES

        Specifies that the current row should be repeated at the top each new page on which the table is displayed. E.g, <w:tblHeader />.

#>

    [CmdletBinding()]

    param

    (

        [Parameter(Mandatory, ValueFromPipeline)]

        [ValidateNotNull()]

        [System.Management.Automation.PSObject] $Table,

        ## Root element to append the table(s) to. List view will create multiple tables

        [Parameter(Mandatory)]

        [ValidateNotNull()]

        [System.Xml.XmlElement] $Element,

        [Parameter(Mandatory)]

        [System.Xml.XmlDocument] $XmlDocument

    )

    begin

    {

        $formattedTables = @(ConvertTo-PScriboPreformattedTable -Table $Table)

    }

    process

    {

        $xmlns = 'http://schemas.openxmlformats.org/wordprocessingml/2006/main'

        $tableStyle = Get-PScriboDocumentStyle -TableStyle $Table.Style

        for ($tableNumber = 0; $tableNumber -lt $formattedTables.Count; $tableNumber++)

        {

            $formattedTable = $formattedTables[$tableNumber]

            if ($Table.HasCaption -and ($tableStyle.CaptionLocation -eq 'Above'))

            {

                $tableCaption = (Get-WordTableCaption -Table $Table -XmlDocument $XmlDocument)

                [ref] $null = $Element.AppendChild($tableCaption)

            }

            $tbl = $Element.AppendChild($XmlDocument.CreateElement('w', 'tbl', $xmlns))

            [ref] $null = $tbl.AppendChild((Get-WordTablePr -Table $Table -XmlDocument $XmlDocument))

            ## LibreOffice requires column widths to be specified so we must calculate rough approximations (#99).

            $getWordTableRenderWidthMmParams = @{

                TableWidth  = $Table.Width

                Tabs        = $Table.Tabs

                Orientation = $Table.Orientation

            }

            $tableRenderWidthMm = Get-WordTableRenderWidthMm @getWordTableRenderWidthMmParams

            $tableRenderWidthTwips = ConvertTo-Twips -Millimeter $tableRenderWidthMm

            $tblGrid = $tbl.AppendChild($XmlDocument.CreateElement('w', 'tblGrid', $xmlns))

            $tableColumnCount = $Table.Columns.Count

            if ($Table.IsList -and (-not $Table.IsKeyedList))

            {

                $tableColumnCount = 2

            }

            for ($i = 0; $i -lt $tableColumnCount; $i++)

            {

                $gridCol = $tblGrid.AppendChild($XmlDocument.CreateElement('w', 'gridCol', $xmlns))

                $gridColPct = (100 / $Table.Columns.Count) -as [System.Int32]

                if (($null -ne $Table.ColumnWidths) -and ($null -ne $Table.ColumnWidths[$i]))

                {

                    $gridColPct = $Table.ColumnWidths[$i]

                }

                $gridColWidthTwips = (($tableRenderWidthTwips/100) * $gridColPct) -as [System.Int32]

                [ref] $null = $gridCol.SetAttribute('w', $xmlns, $gridColWidthTwips)

            }

            for ($r = 0; $r -lt $formattedTable.Rows.Count; $r++)

            {

                $row = $formattedTable.Rows[$r]

                $isRowStyleInherited = $row.IsStyleInherited

                $rowStyle = $null

                if (-not $isRowStyleInherited) {

                    $rowStyle = Get-PScriboDocumentStyle -Style $row.Style

                }

                $tr = $tbl.AppendChild($XmlDocument.CreateElement('w', 'tr', $xmlns))

                if (($r -eq 0) -and ($formattedTable.HasHeaderRow))

                {

                    $trPr = $tr.AppendChild($XmlDocument.CreateElement('w', 'trPr', $xmlns))

                    [ref] $null = $trPr.AppendChild($XmlDocument.CreateElement('w', 'tblHeader', $xmlns))

                    $cnfStyle = $trPr.AppendChild($XmlDocument.CreateElement('w', 'cnfStyle', $xmlns))

                    # [ref] $null = $cnfStyle.SetAttribute('val', $xmlns, '100000000000')

                    [ref] $null = $cnfStyle.SetAttribute('firstRow', $xmlns, '1')

                }

                for ($c = 0; $c -lt $row.Cells.Count; $c++)

                {

                    $cell = $row.Cells[$c]

                    $isCellStyleInherited = $cell.IsStyleInherited

                    $cellStyle = $null

                    if (-not $isCellStyleInherited)

                    {

                        $cellStyle = Get-PScriboDocumentStyle -Style $cell.Style

                    }

                    $tc = $tr.AppendChild($XmlDocument.CreateElement('w', 'tc', $xmlns))

                    $tcPr = $tc.AppendChild($XmlDocument.CreateElement('w', 'tcPr', $xmlns))

                    if ((-not $isCellStyleInherited) -and (-not [System.String]::IsNullOrEmpty($cellStyle.BackgroundColor)))

                    {

                        $shd = $tcPr.AppendChild($XmlDocument.CreateElement('w', 'shd', $xmlns))

                        [ref] $null = $shd.SetAttribute('val', $xmlns, 'clear')

                        [ref] $null = $shd.SetAttribute('color', $xmlns, 'auto')

                        $backgroundColor = ConvertTo-WordColor -Color (Resolve-PScriboStyleColor -Color $cellStyle.BackgroundColor)

                        [ref] $null = $shd.SetAttribute('fill', $xmlns, $backgroundColor)

                    }

                    elseif ((-not $isRowStyleInherited) -and (-not [System.String]::IsNullOrEmpty($rowStyle.BackgroundColor)))

                    {

                        $shd = $tcPr.AppendChild($XmlDocument.CreateElement('w', 'shd', $xmlns))

                        [ref] $null = $shd.SetAttribute('val', $xmlns, 'clear')

                        [ref] $null = $shd.SetAttribute('color', $xmlns, 'auto')

                        $backgroundColor = ConvertTo-WordColor -Color (Resolve-PScriboStyleColor -Color $rowStyle.BackgroundColor)

                        [ref] $null = $shd.SetAttribute('fill', $xmlns, $backgroundColor)

                    }

                    if (($Table.IsList) -and ($c -eq 0) -and ($r -ne 0))

                    {

                        $cnfStyle = $tcPr.AppendChild($XmlDocument.CreateElement('w', 'cnfStyle', $xmlns))

                        [ref] $null = $cnfStyle.SetAttribute('firstColumn', $xmlns, '1')

                    }

                    $tcW = $tcPr.AppendChild($XmlDocument.CreateElement('w', 'tcW', $xmlns))

                    if (($null -ne $Table.ColumnWidths) -and ($null -ne $Table.ColumnWidths[$c]))

                    {

                        [ref] $null = $tcW.SetAttribute('w', $xmlns, ($Table.ColumnWidths[$c] * 50))

                        [ref] $null = $tcW.SetAttribute('type', $xmlns, 'pct')

                    }

                    else

                    {

                        [ref] $null = $tcW.SetAttribute('w', $xmlns, 0)

                        [ref] $null = $tcW.SetAttribute('type', $xmlns, 'auto')

                    }

                    ## Scaffold paragraph and paragraph run for cell content

                    $newPScriboParagraphParams = @{

                        NoIncrementCounter = $true

                    }

                    if (-not $isCellStyleInherited)

                    {

                        $newPScriboParagraphParams['Style'] = $cellStyle.Id

                    }

                    elseif (-not $isRowStyleInherited)

                    {

                        $newPScriboParagraphParams['Style'] = $rowStyle.Id

                    }

                    $paragraph = New-PScriboParagraph @newPScriboParagraphParams

                    if (-not [System.String]::IsNullOrEmpty($cell.Content))

                    {

                        $paragraphRun = New-PScriboParagraphRun -Text $cell.Content

                    }

                    else

                    {

                        $paragraphRun = New-PScriboParagraphRun -Text ''

                    }

                    $paragraphRun.IsParagraphRunEnd = $true

                    [ref] $null = $paragraph.Sections.Add($paragraphRun)

                    $p = Out-WordParagraph -Paragraph $paragraph -XmlDocument $XmlDocument

                    [ref] $null = $tc.AppendChild($p)

                }

            }

            if ($Table.HasCaption -and ($tableStyle.CaptionLocation -eq 'Below'))

            {

                $tableCaption = Get-WordTableCaption -Table $Table -XmlDocument $XmlDocument

                [ref] $null = $Element.AppendChild($tableCaption)

            }

            ## Output empty line after (each) table

            $p = $Element.AppendChild($XmlDocument.CreateElement('w', 'p', $xmlns))

            ## Only apply section break to the last table

            if (($tableNumber -eq ($formattedTables.Count -1)) -and ($Table.IsSectionBreakEnd))

            #if ($Table.IsSectionBreakEnd)

            {

                $pPr = $p.AppendChild($XmlDocument.CreateElement('w', 'pPr', $xmlns));

                $spacing = $pPr.AppendChild($XmlDocument.CreateElement('w', 'spacing', $xmlns))

                [ref] $null = $spacing.SetAttribute('before', $xmlns, 0)

                [ref] $null = $spacing.SetAttribute('after', $xmlns, 0)

                $paragraphPrParams = @{

                    PageHeight       = $Document.Options['PageHeight']

                    PageWidth        = $Document.Options['PageWidth']

                    PageMarginTop    = $Document.Options['MarginTop']

                    PageMarginBottom = $Document.Options['MarginBottom']

                    PageMarginLeft   = $Document.Options['MarginLeft']

                    PageMarginRight  = $Document.Options['MarginRight']

                    Orientation      = $Table.Orientation

                }

                $sectPr = Get-WordSectionPr @paragraphPrParams -XmlDocument $xmlDocument

                [ref] $null = $pPr.AppendChild($sectPr)

            }

        }

    }

}

# SIG # Begin signature block

# MIIhZwYJKoZIhvcNAQcCoIIhWDCCIVQCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUvom9WNH72rJ58DW4dEEjbcee

# cbKgghsPMIIGrjCCBJagAwIBAgIQBzY3tyRUfNhHrP0oZipeWzANBgkqhkiG9w0B

# AQsFADBiMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYD

# VQQLExB3d3cuZGlnaWNlcnQuY29tMSEwHwYDVQQDExhEaWdpQ2VydCBUcnVzdGVk

# IFJvb3QgRzQwHhcNMjIwMzIzMDAwMDAwWhcNMzcwMzIyMjM1OTU5WjBjMQswCQYD

# VQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xOzA5BgNVBAMTMkRpZ2lD

# ZXJ0IFRydXN0ZWQgRzQgUlNBNDA5NiBTSEEyNTYgVGltZVN0YW1waW5nIENBMIIC

# IjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAxoY1BkmzwT1ySVFVxyUDxPKR

# N6mXUaHW0oPRnkyibaCwzIP5WvYRoUQVQl+kiPNo+n3znIkLf50fng8zH1ATCyZz

# lm34V6gCff1DtITaEfFzsbPuK4CEiiIY3+vaPcQXf6sZKz5C3GeO6lE98NZW1Oco

# LevTsbV15x8GZY2UKdPZ7Gnf2ZCHRgB720RBidx8ald68Dd5n12sy+iEZLRS8nZH

# 92GDGd1ftFQLIWhuNyG7QKxfst5Kfc71ORJn7w6lY2zkpsUdzTYNXNXmG6jBZHRA

# p8ByxbpOH7G1WE15/tePc5OsLDnipUjW8LAxE6lXKZYnLvWHpo9OdhVVJnCYJn+g

# GkcgQ+NDY4B7dW4nJZCYOjgRs/b2nuY7W+yB3iIU2YIqx5K/oN7jPqJz+ucfWmyU

# 8lKVEStYdEAoq3NDzt9KoRxrOMUp88qqlnNCaJ+2RrOdOqPVA+C/8KI8ykLcGEh/

# FDTP0kyr75s9/g64ZCr6dSgkQe1CvwWcZklSUPRR8zZJTYsg0ixXNXkrqPNFYLwj

# jVj33GHek/45wPmyMKVM1+mYSlg+0wOI/rOP015LdhJRk8mMDDtbiiKowSYI+RQQ

# EgN9XyO7ZONj4KbhPvbCdLI/Hgl27KtdRnXiYKNYCQEoAA6EVO7O6V3IXjASvUae

# tdN2udIOa5kM0jO0zbECAwEAAaOCAV0wggFZMBIGA1UdEwEB/wQIMAYBAf8CAQAw

# HQYDVR0OBBYEFLoW2W1NhS9zKXaaL3WMaiCPnshvMB8GA1UdIwQYMBaAFOzX44LS

# cV1kTN8uZz/nupiuHA9PMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAKBggrBgEF

# BQcDCDB3BggrBgEFBQcBAQRrMGkwJAYIKwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmRp

# Z2ljZXJ0LmNvbTBBBggrBgEFBQcwAoY1aHR0cDovL2NhY2VydHMuZGlnaWNlcnQu

# Y29tL0RpZ2lDZXJ0VHJ1c3RlZFJvb3RHNC5jcnQwQwYDVR0fBDwwOjA4oDagNIYy

# aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3RlZFJvb3RHNC5j

# cmwwIAYDVR0gBBkwFzAIBgZngQwBBAIwCwYJYIZIAYb9bAcBMA0GCSqGSIb3DQEB

# CwUAA4ICAQB9WY7Ak7ZvmKlEIgF+ZtbYIULhsBguEE0TzzBTzr8Y+8dQXeJLKftw

# ig2qKWn8acHPHQfpPmDI2AvlXFvXbYf6hCAlNDFnzbYSlm/EUExiHQwIgqgWvalW

# zxVzjQEiJc6VaT9Hd/tydBTX/6tPiix6q4XNQ1/tYLaqT5Fmniye4Iqs5f2MvGQm

# h2ySvZ180HAKfO+ovHVPulr3qRCyXen/KFSJ8NWKcXZl2szwcqMj+sAngkSumScb

# qyQeJsG33irr9p6xeZmBo1aGqwpFyd/EjaDnmPv7pp1yr8THwcFqcdnGE4AJxLaf

# zYeHJLtPo0m5d2aR8XKc6UsCUqc3fpNTrDsdCEkPlM05et3/JWOZJyw9P2un8WbD

# Qc1PtkCbISFA0LcTJM3cHXg65J6t5TRxktcma+Q4c6umAU+9Pzt4rUyt+8SVe+0K

# XzM5h0F4ejjpnOHdI/0dKNPH+ejxmF/7K9h+8kaddSweJywm228Vex4Ziza4k9Tm

# 8heZWcpw8De/mADfIBZPJ/tgZxahZrrdVcA6KYawmKAr7ZVBtzrVFZgxtGIJDwq9

# gdkT/r+k0fNX2bwE+oLeMt8EifAAzV3C+dAjfwAL5HYCJtnwZXZCpimHCUcr5n8a

# pIUP/JiW9lVUKx+A+sDyDivl1vupL0QVSucTDh3bNzgaoSv27dZ8/DCCBrAwggSY

# oAMCAQICEAitQLJg0pxMn17Nqb2TrtkwDQYJKoZIhvcNAQEMBQAwYjELMAkGA1UE

# BhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2lj

# ZXJ0LmNvbTEhMB8GA1UEAxMYRGlnaUNlcnQgVHJ1c3RlZCBSb290IEc0MB4XDTIx

# MDQyOTAwMDAwMFoXDTM2MDQyODIzNTk1OVowaTELMAkGA1UEBhMCVVMxFzAVBgNV

# BAoTDkRpZ2lDZXJ0LCBJbmMuMUEwPwYDVQQDEzhEaWdpQ2VydCBUcnVzdGVkIEc0

# IENvZGUgU2lnbmluZyBSU0E0MDk2IFNIQTM4NCAyMDIxIENBMTCCAiIwDQYJKoZI

# hvcNAQEBBQADggIPADCCAgoCggIBANW0L0LQKK14t13VOVkbsYhC9TOM6z2Bl3DF

# u8SFJjCfpI5o2Fz16zQkB+FLT9N4Q/QX1x7a+dLVZxpSTw6hV/yImcGRzIEDPk1w

# JGSzjeIIfTR9TIBXEmtDmpnyxTsf8u/LR1oTpkyzASAl8xDTi7L7CPCK4J0JwGWn

# +piASTWHPVEZ6JAheEUuoZ8s4RjCGszF7pNJcEIyj/vG6hzzZWiRok1MghFIUmje

# EL0UV13oGBNlxX+yT4UsSKRWhDXW+S6cqgAV0Tf+GgaUwnzI6hsy5srC9KejAw50

# pa85tqtgEuPo1rn3MeHcreQYoNjBI0dHs6EPbqOrbZgGgxu3amct0r1EGpIQgY+w

# OwnXx5syWsL/amBUi0nBk+3htFzgb+sm+YzVsvk4EObqzpH1vtP7b5NhNFy8k0Uo

# gzYqZihfsHPOiyYlBrKD1Fz2FRlM7WLgXjPy6OjsCqewAyuRsjZ5vvetCB51pmXM

# u+NIUPN3kRr+21CiRshhWJj1fAIWPIMorTmG7NS3DVPQ+EfmdTCN7DCTdhSmW0td

# dGFNPxKRdt6/WMtyEClB8NXFbSZ2aBFBE1ia3CYrAfSJTVnbeM+BSj5AR1/JgVBz

# hRAjIVlgimRUwcwhGug4GXxmHM14OEUwmU//Y09Mu6oNCFNBfFg9R7P6tuyMMgkC

# zGw8DFYRAgMBAAGjggFZMIIBVTASBgNVHRMBAf8ECDAGAQH/AgEAMB0GA1UdDgQW

# BBRoN+Drtjv4XxGG+/5hewiIZfROQjAfBgNVHSMEGDAWgBTs1+OC0nFdZEzfLmc/

# 57qYrhwPTzAOBgNVHQ8BAf8EBAMCAYYwEwYDVR0lBAwwCgYIKwYBBQUHAwMwdwYI

# KwYBBQUHAQEEazBpMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5j

# b20wQQYIKwYBBQUHMAKGNWh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdp

# Q2VydFRydXN0ZWRSb290RzQuY3J0MEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j

# cmwzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRSb290RzQuY3JsMBwGA1Ud

# IAQVMBMwBwYFZ4EMAQMwCAYGZ4EMAQQBMA0GCSqGSIb3DQEBDAUAA4ICAQA6I0Q9

# jQh27o+8OpnTVuACGqX4SDTzLLbmdGb3lHKxAMqvbDAnExKekESfS/2eo3wm1Te8

# Ol1IbZXVP0n0J7sWgUVQ/Zy9toXgdn43ccsi91qqkM/1k2rj6yDR1VB5iJqKisG2

# vaFIGH7c2IAaERkYzWGZgVb2yeN258TkG19D+D6U/3Y5PZ7Umc9K3SjrXyahlVhI

# 1Rr+1yc//ZDRdobdHLBgXPMNqO7giaG9OeE4Ttpuuzad++UhU1rDyulq8aI+20O4

# M8hPOBSSmfXdzlRt2V0CFB9AM3wD4pWywiF1c1LLRtjENByipUuNzW92NyyFPxrO

# JukYvpAHsEN/lYgggnDwzMrv/Sk1XB+JOFX3N4qLCaHLC+kxGv8uGVw5ceG+nKcK

# BtYmZ7eS5k5f3nqsSc8upHSSrds8pJyGH+PBVhsrI/+PteqIe3Br5qC6/To/RabE

# 6BaRUotBwEiES5ZNq0RA443wFSjO7fEYVgcqLxDEDAhkPDOPriiMPMuPiAsNvzv0

# zh57ju+168u38HcT5ucoP6wSrqUvImxB+YJcFWbMbA7KxYbD9iYzDAdLoNMHAmpq

# QDBISzSoUSC7rRuFCOJZDW3KBVAr6kocnqX9oKcfBnTn8tZSkP2vhUgh+Vc7tJwD

# 7YZF9LRhbr9o4iZghurIr6n+lB3nYxs6hlZ4TjCCBsYwggSuoAMCAQICEAp6Soie

# yZlCkAZjOE2Gl50wDQYJKoZIhvcNAQELBQAwYzELMAkGA1UEBhMCVVMxFzAVBgNV

# BAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBUcnVzdGVkIEc0

# IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQTAeFw0yMjAzMjkwMDAwMDBa

# Fw0zMzAzMTQyMzU5NTlaMEwxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2Vy

# dCwgSW5jLjEkMCIGA1UEAxMbRGlnaUNlcnQgVGltZXN0YW1wIDIwMjIgLSAyMIIC

# IjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAuSqWI6ZcvF/WSfAVghj0M+7M

# XGzj4CUu0jHkPECu+6vE43hdflw26vUljUOjges4Y/k8iGnePNIwUQ0xB7pGbumj

# S0joiUF/DbLW+YTxmD4LvwqEEnFsoWImAdPOw2z9rDt+3Cocqb0wxhbY2rzrsvGD

# 0Z/NCcW5QWpFQiNBWvhg02UsPn5evZan8Pyx9PQoz0J5HzvHkwdoaOVENFJfD1De

# 1FksRHTAMkcZW+KYLo/Qyj//xmfPPJOVToTpdhiYmREUxSsMoDPbTSSF6IKU4S8D

# 7n+FAsmG4dUYFLcERfPgOL2ivXpxmOwV5/0u7NKbAIqsHY07gGj+0FmYJs7g7a5/

# KC7CnuALS8gI0TK7g/ojPNn/0oy790Mj3+fDWgVifnAs5SuyPWPqyK6BIGtDich+

# X7Aa3Rm9n3RBCq+5jgnTdKEvsFR2wZBPlOyGYf/bES+SAzDOMLeLD11Es0MdI1DN

# kdcvnfv8zbHBp8QOxO9APhk6AtQxqWmgSfl14ZvoaORqDI/r5LEhe4ZnWH5/H+gr

# 5BSyFtaBocraMJBr7m91wLA2JrIIO/+9vn9sExjfxm2keUmti39hhwVo99Rw40KV

# 6J67m0uy4rZBPeevpxooya1hsKBBGBlO7UebYZXtPgthWuo+epiSUc0/yUTngIsp

# QnL3ebLdhOon7v59emsCAwEAAaOCAYswggGHMA4GA1UdDwEB/wQEAwIHgDAMBgNV

# HRMBAf8EAjAAMBYGA1UdJQEB/wQMMAoGCCsGAQUFBwMIMCAGA1UdIAQZMBcwCAYG

# Z4EMAQQCMAsGCWCGSAGG/WwHATAfBgNVHSMEGDAWgBS6FtltTYUvcyl2mi91jGog

# j57IbzAdBgNVHQ4EFgQUjWS3iSH+VlhEhGGn6m8cNo/drw0wWgYDVR0fBFMwUTBP

# oE2gS4ZJaHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3RlZEc0

# UlNBNDA5NlNIQTI1NlRpbWVTdGFtcGluZ0NBLmNybDCBkAYIKwYBBQUHAQEEgYMw

# gYAwJAYIKwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBYBggrBgEF

# BQcwAoZMaHR0cDovL2NhY2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3Rl

# ZEc0UlNBNDA5NlNIQTI1NlRpbWVTdGFtcGluZ0NBLmNydDANBgkqhkiG9w0BAQsF

# AAOCAgEADS0jdKbR9fjqS5k/AeT2DOSvFp3Zs4yXgimcQ28BLas4tXARv4QZiz9d

# 5YZPvpM63io5WjlO2IRZpbwbmKrobO/RSGkZOFvPiTkdcHDZTt8jImzV3/ZZy6HC

# 6kx2yqHcoSuWuJtVqRprfdH1AglPgtalc4jEmIDf7kmVt7PMxafuDuHvHjiKn+8R

# yTFKWLbfOHzL+lz35FO/bgp8ftfemNUpZYkPopzAZfQBImXH6l50pls1klB89Bem

# h2RPPkaJFmMga8vye9A140pwSKm25x1gvQQiFSVwBnKpRDtpRxHT7unHoD5PELkw

# NuTzqmkJqIt+ZKJllBH7bjLx9bs4rc3AkxHVMnhKSzcqTPNc3LaFwLtwMFV41pj+

# VG1/calIGnjdRncuG3rAM4r4SiiMEqhzzy350yPynhngDZQooOvbGlGglYKOKGuk

# zp123qlzqkhqWUOuX+r4DwZCnd8GaJb+KqB0W2Nm3mssuHiqTXBt8CzxBxV+NbTm

# tQyimaXXFWs1DoXW4CzM4AwkuHxSCx6ZfO/IyMWMWGmvqz3hz8x9Fa4Uv4px38qX

# sdhH6hyF4EVOEhwUKVjMb9N/y77BDkpvIJyu2XMyWQjnLZKhGhH+MpimXSuX4IvT

# nMxttQ2uR2M4RxdbbxPaahBuH0m3RFu0CAqHWlkEdhGhp3cCExwwggbbMIIEw6AD

# AgECAhAEyswKPFRr9qgYCxGuzc8mMA0GCSqGSIb3DQEBCwUAMGkxCzAJBgNVBAYT

# AlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQg

# VHJ1c3RlZCBHNCBDb2RlIFNpZ25pbmcgUlNBNDA5NiBTSEEzODQgMjAyMSBDQTEw

# HhcNMjExMDE5MDAwMDAwWhcNMjMxMTA0MjM1OTU5WjBgMQswCQYDVQQGEwJHQjEP

# MA0GA1UEBxMGTG9uZG9uMR8wHQYDVQQKExZWaXJ0dWFsIEVuZ2luZSBMaW1pdGVk

# MR8wHQYDVQQDExZWaXJ0dWFsIEVuZ2luZSBMaW1pdGVkMIIBojANBgkqhkiG9w0B

# AQEFAAOCAY8AMIIBigKCAYEAtbm3o57mQYxu0idSifhlyZaDVO0Zu0BnGTFZOtZL

# ibBotgpKp7Be3k9WDyIbOiUHVaFY7DG8aL8krpArj+3KJR49U5pLXcevNUQFLL18

# pi9lZ+e2w+dcBAfuJ30J760VtPDwAA7nmAff3f9o+tEB1ZnIeXzlPRyMz7YZS43s

# DeAft8p8jFzmM0jRtt9SXNxKcC0gnX6Cx0vw4AkxmMtreX/Igvj5VVq4M81E84Ce

# fWsU/IpqIL24xpxl3OOwZ53wzn+rPA3T9bj0PUyI/6VvONUIRD/EfODxurVdSDdu

# LHsRag4+Q3xFvZm/WNqsr2qGv7LHT3uKPsjuPBo1Mz9fM/AfPwdEfM3xJ+Y1rBqU

# xnDhwYS97Fw3LM63lTKl3bN4TOFEJX8YPgC02J4vzYSIP0fwBBPyd7MtbiXzFvSo

# Xnl0EQmjH+k4fjOCwn1tgWnI77NET05Jd06F3Od52In9qIJ5Bhu4zlMFEQgE7JON

# OI4/Hl/dBzfNkyItMMRcNiPJAgMBAAGjggIGMIICAjAfBgNVHSMEGDAWgBRoN+Dr

# tjv4XxGG+/5hewiIZfROQjAdBgNVHQ4EFgQUEr+p1bWwrT+zl6+TXhHWz9ewYuAw

# DgYDVR0PAQH/BAQDAgeAMBMGA1UdJQQMMAoGCCsGAQUFBwMDMIG1BgNVHR8Ega0w

# gaowU6BRoE+GTWh0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0

# ZWRHNENvZGVTaWduaW5nUlNBNDA5NlNIQTM4NDIwMjFDQTEuY3JsMFOgUaBPhk1o

# dHRwOi8vY3JsNC5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkRzRDb2RlU2ln

# bmluZ1JTQTQwOTZTSEEzODQyMDIxQ0ExLmNybDA+BgNVHSAENzA1MDMGBmeBDAEE

# ATApMCcGCCsGAQUFBwIBFhtodHRwOi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwgZQG

# CCsGAQUFBwEBBIGHMIGEMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2Vy

# dC5jb20wXAYIKwYBBQUHMAKGUGh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9E

# aWdpQ2VydFRydXN0ZWRHNENvZGVTaWduaW5nUlNBNDA5NlNIQTM4NDIwMjFDQTEu

# Y3J0MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIBAB35Ee2voPHjrdDl

# B80kocW2ZrVcKO5/POchPOvxL1evXPdoaexNDCwXzM/6GXa4U1VhV+GqbeQ+JCZF

# XWbiycxqXEfi5fxj2sRzdF3CDootFiqxK1eqz2W82KR5FX45LTsQMrg6O8kA2nb2

# eBxk6TWYUtS+3jtdS/nwDp/B/A+ol0CaD51hlzq9QY0NNkwsbZ+fKmIxinqEFF6n

# taOmQNWS0EOtNQBYdlf0pNThBuPxENsDtWRS56pg3qfl3+khteed8sFoyY/9g1So

# fbc7DAQiYtTikmekA+s5WkHY1ewiSF/NcXSNNMNgbuAsizoMQ9NkJ/vMhs89+hNU

# e6Tlk9bFffOP9oh5z6Df/XHJslhNY3DxWYQQxtqzZpAk/4GCJ8L9qdeEDvtulPp3

# p6VqNBxQPu98C46pfXgCX0vIieVy3RZOhHD2JCytWNFWXJFvoo03akcyTumiq2+m

# ew6ALwXKKtFeoDHfnzDkVsZRPqY49gECVKifY7Z7Usuf3SBOB6txOlzK15eMR2EI

# RsBSCPVZCevU9z51DP/GLZ6/kCDG6hcu6isenIWAxWw1wiGv6HJpca73ummRYoUe

# KtNV8hg7ItlPimtrjjoT+0ciE8Ohuv5GDBqK0GE4ikCIUZyFg74ppkHV4q+YghXv

# ubkwMSV7ymFRKhgcGQLlDXP+OaVQMYIFwjCCBb4CAQEwfTBpMQswCQYDVQQGEwJV

# UzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xQTA/BgNVBAMTOERpZ2lDZXJ0IFRy

# dXN0ZWQgRzQgQ29kZSBTaWduaW5nIFJTQTQwOTYgU0hBMzg0IDIwMjEgQ0ExAhAE

# yswKPFRr9qgYCxGuzc8mMAkGBSsOAwIaBQCgeDAYBgorBgEEAYI3AgEMMQowCKAC

# gAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEEMBwGCisGAQQBgjcCAQsx

# DjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBQxn3zeVRd28xGcVOQH0iRw

# eggK2DANBgkqhkiG9w0BAQEFAASCAYAewZiw8QLUmbnHuLIykqe/ntmXuMPmgh50

# STDOukFKV4nPG/CHOSQKkDQoR/Ez4mEsYif5yTxvEk0WaLKpdYh8orbxo5bL0Z57

# 7g7K+SYI+jsIBmawZmQV1F6G4lWdQteBdGxRTQ05m/Ek7KkMnki+CUpwMTK2q04v

# iBNhDeitXzm81ovNPP1fkdCvHGY21y4jJkReAUOlN75bQDxojYcEbb4lXq1GxiKc

# pOU/jhGL3XyGCl0pz4SSr1ynzXtnkapve1lCptqTvAD2+ZRO9lFU41NCwdzev6q0

# aDBPE5VjOsDvF2Nr6EEe6j96WK6AmqtnSQvtylIbyCaFtggWss0nSoaFefTxSv54

# Te+QUAowbYOla/hUeb/wjLl/89LJKbDe5H1StkrlcNGhxce9yY9sjCZ4zZjEY4XT

# L367iTKFNlct8I6p+cF+/8DMzg1MD7XhQir2PMTNjaE1v3pD96JPhpnEauNuwVs2

# ZgsUJIQ0l7BUGH12jAC6yyOa9OuLGR2hggMgMIIDHAYJKoZIhvcNAQkGMYIDDTCC

# AwkCAQEwdzBjMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4x

# OzA5BgNVBAMTMkRpZ2lDZXJ0IFRydXN0ZWQgRzQgUlNBNDA5NiBTSEEyNTYgVGlt

# ZVN0YW1waW5nIENBAhAKekqInsmZQpAGYzhNhpedMA0GCWCGSAFlAwQCAQUAoGkw

# GAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMjIwNDIw

# MTUwNDM4WjAvBgkqhkiG9w0BCQQxIgQggmQAZpZGq6bNu0KepR37tKGa2ywrIETc

# W7E2wOlk8ugwDQYJKoZIhvcNAQEBBQAEggIAA+cGHWEfmbnKmKiFPNqevzvXxKer

# /43ILJzas+4EgTSwszbTyLq0t7ee2g4X0SeGvOqPrEghk46HXm6OI4RzSyELcPHV

# aka0OXHvDiVgPItgh443T+4Py6e1zB1NWS/NRmTSRfLumYM897AHnohnYosC3y2a

# LDRE8DDMdtYLVj3cwKa5UJSf6VQ+jWNEEiQnvx3RXEA8Z/aam+491CgXgio4DE8d

# b1AX4fnTA6CYJF4hbOq+CLFwCdoBmuxa1nDMXnowH+tL+DsyCQABSp9iBStohokR

# nnDsEK+zBZI/4NrxageU2b+dbFmifOKzwJSV3otW6T0Pbtkm0o1qQq/7QJvakwKD

# vdLyVFolgeOCkSuk65GBsXo3Kdq6qi7e5b7EDT11s6LLXa/D1hSEScfDtH/VnHHi

# wqtQeelvO7vvq2R+gkYZILOBFqKx1oFNgKk8xw2VjqkzD5XuiFgQHK3hsuQ89UtO

# +HoL4h1NPz2kM08+6D1uITj4MLrWYC9LZdbVNSr5qJqXPwfvb+JgrFwVT9n00ZvQ

# 6yzy94PoptJlHsKRIHejGCRmC+eMJmOHW2hoM+5GqwaoDrGn0PL1wQrFGvSxWT6V

# Wx2w+swgfQbwIINapjVMOWkbdN9jF/DnbQzJGAajzt0Oo+6c26DdF8rQ4NLGXRSx

# YMgDqP7+ROoL7YM=

# SIG # End signature block