User selects which field to add a label to and what they want it to say
Macro Output
Remove Record Id
Attach last row to original table
If adding both Total Row and Column, select the Table Total for output
Build up last row
Attach Total Column to Original Table
If only adding Total Row detour the original data straight through
Create Row Total
(Cross Tab doesn't like support spaces in field names so replace them before and after)
Create Table Total
Create Total Column
Transpose Data
User selects which fields to sum
Select fields to be summed plus RecordID field
Add Record ID
Macro Input
Output
Output
Warn
Transpose (4)
Summarize (9)
Summarize (10)
Join (13)
Summarize (15)
Cross Tab (20)
Ignore
All
ByName
#1
#3
Union (24)
C:\Temp\Engine_8008_a43d740c46874f758c22f388b367d561_\Engine_3840_470f86390e38497c8b0cefe48b72e1d2_.yxdb
Single
Profile
Browse (25)
Detour End (71)
Detour (75)
Select (74)
NonRepeatableRecordID
1
Int32
6
0
Record ID (93)
Join (97)
Chaos
Reigns
Within
www.ChaosReignsWithin.com
Version: 3.0
Description:
Macro to add total row and columns to a data table
Add Total Row and Column
Add Total Row Only
Update Detour
Update Last Row Select
Version History:
1.0 - Initial release
2.0 - Updated to Alteryx 9.0 macro interface
2.1 - Fixed case where spaces in field names
3.0 - Added option for automatically summing all numeric fields or only those selected by user
3.0 - Added ability to include optional and dynamic label for totals row
Formula
replace([_CurrentField_], "__Space__", " ")
Warning
All
ByName
Input
A
1
2
4
5
4
B
2
2
5
54
54
C
34
2
4
43
3
D
3
3
6
1
3
E
3
45
8
2
4
Please Select Fields To Sum
Update Select
Update Select To Reselect record ID
Generate column for label
Label
This is the default option so there are no actions required
Delete Select
Add Total Column Only
Select all fields
FieldTypes
Byte,Int16,Int32,Int64,FixedDecimal,Float,Double
User selects fields
Select (29)
Horizontal
Question
Radio Button (166)
Question
Please Select Fields To Sum
Question
Radio Button (165)
Question
Add Total Row and Column
Question
Add Total Row Only
Question
Add Total Column Only
Question
Drop Down (231)
Question
Label
Macro to add total row and columns to a data table
Transform
Transform, Chaos, Chaos Reigns Within, Total
Adam Riley
ChaosReignsWithIn
ChaosReignsWithIn
NoCondition
(Always Run)
UpdateValueFormula
"True"
29/SelectFields/SelectField[@field='NonRepeatableRecordID']/@selected
Expression
Dynamic
{{INPUT}}
75/DetourRight/@value
Update Detour Direction from Question
Expression
UpdateValueFormula
[Add Total Row and Column]
74/SelectFields/SelectField[@field='Total']/@selected
Expression
Error
No fields selected
(FindString([Fields To Sum], "=True")==-1) && [#1]="TRUE"
UpdateValueFormula
![#1]
163/Disabled/@value
Expression
UpdateSelect
UpdateValueFormula
![#1]
164/Disabled/@value
Expression
UpdateValue
Simple
230/FormulaFields/FormulaField/@field
Condition
[Add Total Column Only]
DeleteTool
Tab
Questions
Tab (111)
LabelGroup
Fields to sum
LabelGroup (174)
RadioGroup
Automatically add all available fields
Radio Button (166)
RadioGroup
Choose specific fields
Radio Button (165)
ListBox
Fields To Sum
Please Select Fields To Sum
MacroField
Byte,Int16,Int32,Int64,FixedDecimal,Float,Double
LabelGroup
Where to add sums
LabelGroup (175)
RadioGroup
Add Total Row and Column
Add Total Row and Column
RadioGroup
Add Total Row Only
Add Total Row Only
RadioGroup
Add Total Column Only
Add Total Column Only
MacroOutput
Output
Output
LabelGroup
Row label configuration, if applicable
LabelGroup (208)
ListBox
Field to add a label to when summing rows
Drop Down (231)
MacroField
String,WString,V_String,V_WString
TextBox
Label for totals row.
Label
Total
MacroInput
Input
Macro Input (172)
Tab
Input
Tab (112)
Macro
iVBORw0KGgoAAAANSUhEUgAAAKsAAACrCAYAAAAZ6GwZAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADr8AAA6/ATgFUyQAACC6SURBVHhe7Z0JeBRF2scR5RLlRkFRIEFkXc8VMeEwK6Disat+3refn66rru66q66uYiD3SRLAcMolui5eCCF4sKCCKIKACnLfNwoEwpFkuur93re7JqmZqZnpzlxJqP/z/J+BTNXbVdW/rqk+qrqRlpaWlpaWlpaW1skiyLqytSv1dwNdyZcO5MmNtLVDdLOBPLPlQEhudJpALHwyxtxxH0uNA/ZaI2BDtbXD4BfQ6S0mC8TCJz7qtvas4LI9fDht4FRt7dCc1tjq+NLPmCUQC58OFdzahmWdu5O/Ths4LTZOwW0na1c7Fa1qp/rgNASWYM1pF35YSUZB/1ddmfHc3JCqAJE0HYkFnYFNuBLYuMuAjT+ZfTmwSVcDKzwHgcV2UbVXbUydwbAwm36J007x3VY1rB0iAyvJyL/8U6BCeG88osaKYU/CZz0KfOe3wLcuAL5l/snrrV8C37Mc+MwHgZm/dGHoPNLQI8/HjuBSYGN+Gx6PvRiNnzmtrM7GY3tRgNVVMHiikRaPGwzjER3MVDEckPOFKWCKM23mAv75P6wdHuovHYGU2hT4F6/jgfAF8I1zw+NNn5qfbCL+GtKwxWObUYCVFw1pZhQmbYRURdceKVPFsAfhXwlYfcRr6UBSpbdjf1KltWuFTFj/Hh5Y03FfprYAWDcTN4fbC6exnOydG6yzf3mb0YCVhGdwS8H7SImk/cFKPczhHcC3L0QvQn9t05T+K4DyPSKQJGYAP7QF+Db8qXUac8dCgOO/iECSuAvg4PpaxvwaYx4SgSSFHdbmFqw+QuBqZSFsT/Z2DGE1Jtz6BUvthBsNtZFs2h+sRhXAj9OBTRkAbCp6WpI9U/pJiQBrPxKBJFUdB7ZsDH6fgDGvUedXeUp/0zSe9lHFYeCLs/Hn8CpnMSf3BfbWIHN86qNIwCq3B7YtP7gRD5Zv8DxhCfo7m8Zzit1LASqPWHFYFcJ6fexg5W8/eoExduABSInSUMAfrK4KgK8RgtRmmMbBGJriDTsV4PsxIpCkynJg//0nfi/SqfKrnIpp8aeU//yeCCTp+AHgc57EOmB70YmMKr/KKVinrDbYI38hAkmKNKxU5oVpeMD0Q9ius+9p1wL79y0Av/xsxYk1rDD5keZGQdymqA0FAsKahTu1KTa22GkEbTATBMmNEdZiEUgSwTrvJfyetuuVL5DpwE0JBOsTuMMICkVepbEuwzF9ZmvzpMdHkYb16F7gH92P7YDxMzBNRhN7prbNbQOw61srTsxhHXdlE2PEJZ+x5FaeBYiUg8Gahj2rk6sTBMPwAD3rPNGzOhnmUM+adjrwNe+LQJJMWP8kelYHMWPZsxKsH95rxacDzI6pXYdhrKxWCOs3VpxYw0oqy09oZ4zss5xHYyhgC1YH5dCwetkPrNSzYrs7KzPGym5dd3pWt1yjB07iQ1vixkNtrCDWsIpAkjSszlRVfHuCMfYO4JG+5qphFYEkaVidyygasCjit181rCKQJA2rcxk5V5TwodiokRwKaFhFIEkaVucqy7+onSv74tURHQpoWEUgSRrW2snI6fVERK+5alhFIEka1trJyIl/Al7VsGpY0XUd1srRSZe7Ci47wOnCsFygcFnDKgJJ0rDWXqz42kKgijnZwXatYRWBJGlYay8+8YFnjbxEzs0pDKE2npc1rCKQJA1raDIm3reAD8cG1rB6SsNaB2HN7TEHzEKF2nhe1rCKQJI0rKHJldf7jyzrN1gQqVDhsIZVBJKkYQ1dRn6fv3B6vlQuWKjWsIpAkjSsocuV2+POsA8FNKwikCQNa+hyjbzmRp7WGQvTxLNwoVjDKgJJ0rCGLmjU6BRX8aAxPIUqiI0tF7C21rCKQJI0rOFR1bhbXubDacpLqI0oHAxWc8KgE1gxbaAJg9WwOjjYzKkdgeZgIaw0B0vDarmuwMqnPtTe9eYDi3ka7ryQGxJNMfzBuigTG0hMGKQnv+w66IRB3KYqnz/TTkppjrDOEIEkEawlT+DO8coTzPSccEbrGMJ6n3NYaZJjfYKVVDU2qTcf1gRhddA7+bM/WI1KgGWjgRWdh+4CbFRXe6b0IzoD/DhNBJJUeRTYonRgBZ3Uef2Ztl/UFfiGEhFI0olDwGl6d15Haz0pVX6VC88F9sYFwHcuFoEkRQPWD++x4jvpCOgAq2sTBoOpsvCKSwELE1FYaUWWvT8AX/kmehLwH9D0GdSYfvn4mrntsgyEYNdS83t1Xn/GmCsmAhzcLAJJcp0AoNVVlo9V5AvkCVinKQBHdotAkiIN67F9OHR5EnvJM/DAPds6eO04rx2w0d0A9iy14tQHWEmuov5TWBpWNtSxqz9YScxAGLCHpSGBU1NelRAEZXo7pgNIpZBiSsvxuBVpWKuOAd/4KfAlBcCXvQF8qU1/NxL492NrlmaqN7COTBjMU1piwULsXQPBerIq0rDSAUKdAEILruP2XSU+3QdtvYG1OGmweYNAwxp+RRrWcKm+wEort7CxNyxh6SEOBTSsvtKwhl/Gm3c8A8ObYuFC6F2DwiovtejEgaRKb8f+pEpr1wppWMOvqkkPXOUae/Mhln4mFrKWjeoPVhoXHdgAfN0sy+tn2zSmXTsT4NBWEUgSQfDLzxjvI0W+ADbL8DHw8l0ikCS6xEZXLdZ8qM7rzxRvfQnwY7+KQJI0rJGRa/KDQ4y0dgxq27v6g5XOlJcUAcvtaF3DzD/bnvM6AMtuD7Bysggkia6zfjkcv2+Hac/yzevPFDOvkwmtj04ctMDKbINpHMTMaQ+s4HygBYh9FGlY8QDj+36yrghs/q8Df26tUVtRZsWpb7Dy8YN68tcbu2q9tkAgWOU7WHQb1Y4prXkH6w0RSFL1HSzaroOY5h2sALdbSx7HnYNpqA1U+VWmN53QHaxYLHl5bD/wOX82b/eab8kpOMeezRsf8QC7l1lx6h2sE65vZ+ResclIo6GAVGC7DgSr+SALPT9LjUE7zYaph7f1IAv9Eijyq2wu+Yiw2nqQxabpAMii261fikCSIg2reQfrXgsyJx2BeQfrzPp1B8tbruI7B3KEtVZ3tILCqp+6Uua3bSyXClaPZwNsuj4+G+CtyuK7L2YFV2Ah6TKWVGg71rCKQJKiAutJ8NSVPxnFd97ryuxicKfPuWpYRSBJGtbIihf1aWWkdtjheOUWDasIJEnDGlntS77oDFdq13UsRSq0HWtYRSBJGtbIq2rEVb2NjC4ngM4c5cIHsoZVBJKkYY28+OhruxqpZx7ldDlELnwga1hFIEka1sjrWFFSFyOj42FzR8iFD2QNqwgkScMaHRmjb33UyO4O1iJuUgX8WcMqAkmyAyv9neoatB4aVr+qHH/X5UYm7gSqmFwBf6aKaVg9FQhWql9WS2D5HYFlYNuYQy6CVkrjYQ1rQLnG3T2FZfcAW9dcNawikKRgsGY0B/burcDp3bZjL7Ji+f0l07AGFL3/leX22mLr4RYNqwgkyQdW2j6mp4OfgKHetORJa1rK2pnA/30z/p1iqtqJ0mtY/Wp90ZBmLKX1Bm7nHVoaVhFIkgwrlZNutFBbkgkweiHJRw8AGNhG7lnApU8Byzwd6055CGz3tjSsQWWM6P+8kRnPeTAoNKwikCQZVko3sTfw/74M/LPngX/6N/Rfgf/0tpnOLY7lYPNeBDaquwVs9a+ahjWoICepk5EdfwBSvCribQ2rCCTJDStBkHwq8Pmv4B+51YtW23dKDD9RBmzFFGBTk3AbTS24NKzBBaMR1oz2B4IOBTSsIpAkN6zmK52aAF+UIb4ILm5UAd/5DbB3brROxKiH1bAGFsy461RW2H+ykX5e4DWxNKwikCQZ1lSE9atU/KOfyYUK8YMbgdEYNqc1bodiaFhtyUjvthzooV25MrI1rCKQJHkYMLSxGAbYEOXb9hWwD+8DlougmuNWtIbVnowR15ay9HOxEn4aRcMqAknyGLMirDMfsuY97foOYOcSy4c2eY5bKw4Dzexl4y/D8jbBslCbUXk0rLbFxz/QxRiZuN/vNVcNqwgkyQ0r7XCqTxbdsaKZsx1rZvvOfcaaBo7iZduBf5NvXQmgdqY81dvC/2tY7cvI6LKKD/MDXCBYaXnKYXhWS5diaOxlx5QW49FymT4iWD9/ARsXt6nK6890kji8KfDV/xGBJBGssx+zxpeqvP5svry5FfCt80UgSR6wYlnpOivBTab6kT9+zIJ1/yrzmqu5wp9569UbPg2rIxl5vWeyFGxMuUJyxfzBSusG5HUSvYpi7r3KNHc/uyPAykkikKTKo7idYdSImNZhzLxz1OsGHD9oXv9kme0xrYOYOdg7FnZzvm6AOdMW/zbrMeBb5gOb0hf/7r5MpQJPAWs5wvrB3VZ8ymdeMbBhOsAyW+IwpB7Pbg2m8tzEs4z8y/cphwL+YOWG2WvwH9926OnAf3gL4Nf1IpAkowpgz3Lze3Vef8aY+All20QgSXRQ7fwWY07zyhPEP2DMn941ezkfBYKVfuIzWwArvhDYBJqkieNTVbtWm0Dz7ln3W78GtJJOLi3ggabPQKY0WW2BFXSxxs6khggrZF7S1siP26W85uoPVhIBSz91BJkjYx7Kq1KtYlJ6islEEFl4koNw1S4mftZqfVYENAN7UzqJ8hifqqyA1XXMHH7wZWOBr5hk399PAL5yKsK+z4rTEGHl2X3PNAp+u44lY4/g/VMVCNaTVUFhFe3m7zsPK2A174bRAeZ9ANm0+wBriLCSTuRcG+8ambCf08mFd8U0rJ6yA6ttq2ANkxoqrCQj8+KPeXJzrJC0A/zCikdv5RHgR3Y482HLdObvK4x5osxKo8rrz+6YtPKzt2hoQIuzHd6mzhvIh3daY15vaVhjL2Pi3fcaowd5TnnxByuNAzfMBUav7SHTtUw7pkXSZv0vAK125y0Eg66VslmPqvP68+z/M+Ny94JksqrK8YRpGrCZD2FaB+WkE5zSp4D/ukYEkhRpWPEAo4deePlu4HQZy67L95if9CIRUw0ZVhIbc8MyoOuEcsVUsFKPszjHehgjE08mMunThunEI7UJwPJxIpAkus46/xUwH1RW5fVnOqHJbImgfyACSaLrrHOfAjYcT3Romokqv8p0Fp/dFmKyMBvd7Vo5GQ8aPLg+eQ79V3ue+zQwLBcc2mLFaeiwGnlXLuZDvSrmD1b3kpc0zpWv9wU0pg340rYXcXu4XUqnzK+weVMi0JKXuNPNJS8dxKQrIxmtIPgdrAjAimfz/ONH8O/4Pb1eKPtMe6aOI/8sgN1LrDgNHVY+YsDvWP7v9lYPBQLBWmdut9KF+Fjdbo0ErPiTXv3SNiq3TdMBllnPXtoWqowRlw8F9zXXegErpm1osNbmdmtDWPLSqXjB5a9oWOshrCfDswGyKvIG9XQVXL0d6OfHXTENq6c0rHVDRlHfL/nrOFCXK6Zh9ZSGtW6IFQ9aVj0EcFdMw+opDWvs5Zr8wM3G2Jvs3RTQsGpYYykjt8/HbFgr34ppWD2lYY2t+PghXYxRV2/zuHvlrpiG1VMa1tiJT7uupWtU75XWbAGvxtGwikCSNKyxU1lx/7ZGftdd3Jx3JFXKXTENq6c0rLETjEvqYIy4ci+YE9qkSrkrpmH1lIY1dnIVDHiLpZ2HFVE0jIZVBJKkYY2djMxutZuKrWF1FlNpDattweRH2rhGJu4CqqhcIbliGlZPaVhjo6o3bvrYyOyOlcCdI1dIrpiG1VMa1tjISO++jOuF2XytYa1bco0aMsrIuiDwq901rCKQJA1rdHV09E2dWEYHvZiwP2tY644IViO7+wGf26ve1rCKQJI0rNGVUTTwcSP7QiPou7ACweqeMGhOxHNgc8LgGyKQJBNWecKgTZsr/zUHvtrfhMHHcecQFF75Apl+cWI2YVDDWi3z1UKpZ4X+aqFv8oBlnok90OnYSF4zLf05qyXGbQGwYoIIJIlgXTDU/N7RrM5MjJnVGri8w92iVQQ/+QsCgb8Aqrz+nIF1yuuIsH4lAkmKBqwf3GNBRgdOmk3T/sT90aAmDMLkpOYsp9dmW6/E9Acr7jDY/BmwUgRh7rNgzW+3YUo7588A2xeKQJKMCuDrZuL3T6nz+vPcZ0zzPStEIEn04rRV/wZWgkMBJ+UsfRrYp88DV612GHFY9wGf+Qj2lPh9Fh20Np1OU7HPblhTsV3jHypiub0CXwVw2x+s5vJB5QDlu9F7HBrzEETeogXFKo4AHNmlyBPIVAaKeUIEkmQuH1RWy5j4Sb8g3oo0rLTIxfIJ5vLvNN7meKDZMq0Ji50HHNxkxanvsFaOefAyI7cT8BSbjUwVw8ryRWlWA2hZsM57IXKwcsN8yRsvozW3dtr3YfrEg5LebEiq77C6xt13B8uJA1vvbSVTxahnXfCauZOg6qhk7B1DshyrfsXkNFQIG6w4hl+vWLU7VOEvFXvnhvoJKx/1x3NcWZ0Ps1Q8g5cLH9BYseEIK1aaLx0N/Jvc6HtxFg5DhgH/UvJXw/Hv2er0EXUe8O+KgE1Lsk5onFxiU1r0rPQ+BOoR5YPEdRw/Hbg6vchPJ6zTB9dTWHMTu7KUM45yOsOUCx/UWDlarCy7FVpx5hxJZ6Hz21uvQh93cY3H9MKz9XbW96p8ETW2A7WHsq0cms4b0ppYY84VE7FDGGV1CqF6WTF6tNVu3ld96gOslYX9LzUyzz8O8uxVu6ZGNRcto89oGbdH1xon9MaThg3mJZ1q71mGwP7GeulDLMoVco/qZbr8l0OdQZhMsci0wqP3tuo6rDz3upau7It/pp+csDd0JE29wtRrzDNkD+HZOr2NOjw/xXXAdAC4X2sUNmNM1Zi6zsNa1KeVkdJ6B6eewbvwddZYVuo5J/cDOHFIUCp0eJv1NpSGAms0XddhdU2892Yjq0uFrWurMXcTNDYoja1pGDCprxpWerUkwWwu+aiKo610XYa1Ytx9vYxRAwx62ENZ+LpkakgavxWcC2xkdzy56gRsxm04DCgTlAod2QnsnSHW96O6ASs6H/O1tMBVxdWucV2GtWrs3dfw1GZQL4YA1PNnYM/6/l1A9+VN711pXeOVRbdm6QVv9D29ye/dP2BekV8VV7vGdRVWXjSklVHYd6WR3lpd8DpnbEjqHcf0Ar76XfNuTkBxDnxjKbBxl1gnFcqY2h6us7CO6t+Tv36aq36dWGFj0onTuEuBb/oMEEdBpkL0It/pg3B8S5CjlfG0PVxnYc27qqeR1s4F9e3n0X3S9N7/WO+jUqniCLCSJzE9jnHpYWlVHG1f10VYcQjQjOX3mc7S2wCvj5d36DphblvruQS6fSir8jAwevg7G4c3gSY8avu6LsJqFF//GE9pae9RwLpqAnFEZ2Ar3wRwiUcAjSpgq/8DrOAc87kFfZ3VoesarJCcdJox/pb5LI0eyq3POxPLTkDSK9HprYT09r29K4FNu9ZqdLIyn7Zf1zlYx90wGGiSXL06sfJjqgO9mfD9O61Xm9NL2GjaiZ2ZDtq+rmuwukYkDOYpuEPDNQSge9d0t4juKMXC1LipLcwrBGw4gkv/V6WLlt0P0Kjaqjamqx+q7YRi8+4eHehe26pzsBb9fhRLa4WFC8PPJFWuoBOwqQOAv319bPwOfV4HfPpgNH6a/4+dqS3YiLOttlG1mW1jfnpP7IQrlNsJxWzS1QgknoDSZT15m3UJVl6YeDGknw6QGWpDkjEGHvV8xu3AD27Es3Lfp+aj53Jr3hd9Kr+PnvmBjcD+88cwPEhDQ7UWAGtnKrcTivmOxcDGX2L1sPI2ow3rjLsanTrjooualiR2u2bO1XE3yt79XI+nDz7XDI4NbQqQ3Rh9quWs2jSqgJWudx7aap2NawEv24qw3ho+WMM+rYUD37nEGjbFCtYPr+rVfnZi98fmJMSXlCTGr5uTGA+BvHDIebD5ibbw6z9aIrzNgCOwZI/CB7SAlXpW7E20SAhCWHtWrwmDYRGWcfvX1m3oaMP6aZ/zu89OjPsrQrpVBaUdf/77brD9qdZwIrkpcBwiUE/LvQffPvYDK00XPrSpdj6IpmnOrEoEE6Kp2DSrk75X5bPjY7/4PvRCs1GP7Qsh7mbxiCKz4kUSVnM6Orbt4W3msEtdHm9vtkzTx6unjscI1pKEuCdLEuJPYE/KVRA69Sf942D/38+AytQmCC0WPiNQY/vCSnfq+Y9v4QlGd2CF6CKHHtEN2MwHgf+6xoxXrapjwBemA8tX5AlmKkcBxp33ojXfX9bhHcDmPo1x6VFCr3zBXIh5CnsAX1JkTcgzFQlYccxKqjwKbOUk6+SooKu6TN6mMo6MB/bRA8D3/WTFiTass/t1u2xOYtznKuDC4fmDusKRf+F4KeCwwA+sS0cBG4oNTQ1BO8yuKT3NtnxrIPC9P5jxqkWzMT97HtiruM3axp35MMLp9SwB9jr0jIG5g2oT93U8qL9IRljdt3wjCGsFtsG3I/CAPsuqj3d5VDbr1BjYtN8D37XMioOKGqwI6UAEqswbsHCbetlDL50OHE/APCpUbT+wfj/OenjE8XVcjEcX89+9Cfh+dy8gRLDWZhVBMpWDltspecJ8MNtDdDJEC50Np/I6jEvlSGsOfFF6lHpWbIPvsCOgB8rtPvJoXkttaj6Mzncvt+KgogLr3L4XDMCf/IiD6jYBe+DFluaVA58LyBpWzKNhVeqTxPi+OEZ1qaCKpEv7xuGQABstGxtPrpiGFfNoWH1UmtjzKgS1XAVTNDy3nwUsz5EBxIppWDWsshYkdW2OP/2lKoii6QWDu0LZKy2ka7H4qWHVsMoqSYybqoInFt7wWDuAPGxEs3JYMQ2rhtWtuYnxN6ig+THjFbFZS2VrfvJJ49TlmzeIaACsshJK+12gTvcqNmAuAYsV07BqWEmlQ3o0w151tQqYigO/is3W6PjuHT7p7PrIBq+L8KjyTeuVaRcNOc8av2ZhQ2hYNaykOQnd70c4mDcsZNdxr3lHJM7hi3sG+6QN5i/uGiQCeOro9i3K9OStf2oLkION6RdW2pEa1roD642Rg3VB0kVn4EnVjypQyDKsZatr7vbsnPOBMn0g7/1qnsht5XcrEKzf39EZIB8rpYJ1SSGwV/C7V9FUcSemfPRsLC1eIavyCLBPngX2Eja+Kl8gUzleRiOUdHvVQwc3I1h/APZPkU6V358p/b9OAz7/VYQ1SnewFucCy21jtZOqTN6mMtLdrsn9gO9casVBhRVWejgFYT2kAoUsw7oqL1n8i8aaFVDaVz3W9OdqYc+8fkKh+E9gWEv7xpuPGZqLCUuwkji9/OK9O8ypJuyDu+yb0lM+6qkObxPRhFwngP80HSHA7z+oRdwZ+LlsjPmGFg8d3Q9sSQF+X5u4VMe7ga/BA9yoFAEjCCu1AS3aUfoUttPt6jJ5m8r4wd3AvkozH2yxhGUMJ6wlCd2fV0Hitgzrwkf+AJWHanbC0n88rsyj8o/pL4tcAFtmTLUNK3ntwx0A0hBWbDgZ1pNbkYC1Dj8iCMmNGs9OiF+hAsRtb1g3TR8v/gdwbPdOZR6VXceOilwA825JcATr0ttwKJBJsN6GO6jmSsLJrZMM1gVJSafhEGCLChC3vWGlv8nyTq/y4ifvEanxV3ftKvNvTmCdP7ArVLx2CnD8+TTfBKJlih/ZbT3JFRZYWwBsnCsih0+0cF31sqDyNp3C+kmf+GtVcMhWwXp022bxF4B9ixb45PH2ge/FqxFRK17/m/k3J7CSNz6MjTljEMBmPEmj3lUbx+zzgL01yBzPhw5rM4Blxcrt1N7rga96F1hxL3FASdt0CuucxO63qMCQrYJ1/u3XiL/gkcOZTx7Znw/pDdywnpp3HSuv/rtTWNc+1B4gv7n5ekhzPdST3p2xLc4CltkCd7wEQSjObavYTijGMuZ2AJZBL4L22pZTWGcnxgd9qFoFa+mAC8E44b7ehwfkS0/65HN7dUGqSOV5ucsprGse7Gg9jUVL+WjXOJwLiNC1Z9U2QjHFVPX6TmEtSYxbrAJDtgpW8obJo8VfAcrEONTbdGnLOFHzekiC3P2dU1hX34+wejyJpV2vHU1Yv7z3ehoDiG8APr/xKo98ZHm4UFl20OM7p7Cuuk/D2qAcTVjJ5VtrrnmuG1/g8R35+N6aM/eFD93i8Z2G9SR3tGH9ubDmxb80hvV+esoto6LC5zs9DDjJHW1YybLoYr/777s+rVndY+OUYo88ZA3rSW7nsMZ/oQJDdjBY6flWt45u22T+rbRfz5qrBTiunX/7AJ98TmFd82AHDWtDslNYSxPibleBITsYrKX9e4pvLdHfViQ/L/4HcGjVSp88ZKewms8HaFgbjp3C+klC9z4qMGQHg9VMc7RcpADY8u4kEz63lr/2rDKPE1hpEmHZyy2slVtUFdeuf3YKK60COCchfo0KELftwPpD2j9FCvzVN2reGcWqKpXpyU5gXXRjF4ARdHFZUWnt+mmnsCY3atQYx62zVIC4bQfWebckAmfuBcNqtGPO+8r0ZCewLr+jkxgCYAW1G4ZpZgHBmnGGPVhJsxPiHlEB4rYdWMm/Sg+ruKVK57YTWPc/cypwehCCnkTXbjh+AV3c0z6snybGnVWSELdfBQnZLqzLhz4nUlk6tmOrMp3bdmGd2z+eG0VnrzQK0CO0G4xzzlppFMWtNIovvEugaE+zE+PeUoFCrjos3gTNuc9dKG8bbrAp7cP+wSavLc6lhGby8i0blGnIcxO7O6uMVsNWSd+ul89JjKtSwRJLlyTGHZjVL+58UUwtLUt4ovWhCphYmsbTonhaWjWyelc1NLEwHjzrFvW98ExRPC0tT81J6HF/SYJ6sYtompaDn92n22WiWFpavqLXBNEbWFQARdOlCXGviyJpaflXaZ8erRCYiL1DIJg1qFqOVNrDXKgt6BNZEfBwaNToFFEMLS17soYEcV8qgIqISxPjMsSmtbScq6T/+W3nJMbNR5jC8u4rv+4bnyU2qaVVe826svPppYk9ni5JjN+rBC0UJ8T/VNI37lGxKS2t8Ih6WQQ2G8eyFUrwHBhjbMDPybR8kQivpRV+0e1P/NkuKkmIP4TwHvMG0Z/NN8AkxG+l12quwvGwCKelFXnNTrjg3Ln94n+LAKYiuO9hb7lD4e34fRFC/cLcq7t2+yShSzuRXUsrNlqQ1Oi0jy7r2sbbn18Z11ok0dIKokaN/h/fraW2UfeVdAAAAABJRU5ErkJggg==