423870 2020-07-04 13:15:14 +0000 Report 'Transactions by Category' converts all records to base currency even if this option is not selected 2024-10-30 14:21:37 +0000 1 1 2 Applications kmymoney reports 5.1.0 PCLinuxOS Linux RESOLVED FIXED NOR normal --- 1 danieljbridges kmymoney-devel danieljbridges KMyMoney ralf.habacker https://invent.kde.org/office/kmymoney/commit/1159cad3b33ab6cdd50985db7899228715b8fba1 5.1.1 0 oldest_to_newest 1941729 0 danieljbridges 2020-07-04 13:15:14 +0000 SUMMARY STEPS TO REPRODUCE 1. Enter transactions in a ZMK denominated account 2. Configure 'Transactions by Payee Report' and deselect the 'Convert to Base Currency' option 3. Open report OBSERVED RESULT Currencies are always translated to the base currency whether or not this is selected. If base currency is not selected then value is prefixed with ZMK, but the value is the same. EXPECTED RESULT Value entered into the ledger with the currency prefix to be shown in the report. SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: (available in About System) KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION 1941767 1 danieljbridges 2020-07-04 17:25:16 +0000 I can confirm that this appears to be generic and not related to the currency. My base currency is GBP and the following currencies (AUD, USD, EUR, MWK, ZMW) and are all converted to GBP in the report, whether convert to base currency is selected. 1943502 2 danieljbridges 2020-07-13 17:32:09 +0000 This seems like a major flaw in the report generation - it essentially can not deal with any currencies other than the base one. This holds for all reports that report by category or payee. 1950912 3 tbaumgart 2020-08-15 09:35:48 +0000 Can you supply a (small) demo file that shows the problem and attach it here at change the status to reported again? Many thanks in advance. 1950950 4 130888 danieljbridges 2020-08-15 14:31:48 +0000 Created attachment 130888 Test File showing issue with report by category or payee Have created a dummy file with two accounts in USD and GBP. Both have a single transaction worth 50 USD or 50 GBP. There are 4 favourite reports for Payee (base converted and unconverted) or for category (base converted and unconverted). Whether base converted or not the values are always converted to the base currency of the file (USD). 1951340 5 tbaumgart 2020-08-17 18:43:07 +0000 Thanks for the file showing the problem. I did analyze it and in fact, the numbers are correct but the currency shown is wrong. For the reports you mention no GBP values should be shown as the categories are denominated in USD. In order for this report to show foreign currencies and their values, the categories must be denominated in the foreign currency. So the fix will be to present the correct currency. If you want to see that it works, take a look at the transactions by account report. 1951441 6 thb 2020-08-18 07:15:48 +0000 Git commit 49dcabca8bd912554185e49faff43c685b77764d by Thomas Baumgart. Committed on 18/08/2020 at 06:25. Pushed by tbaumgart into branch 'master'. Show correct currency in report In multi-currency transactions the transaction commodity was used as currency instead of the categories currency. The value shown is correct. This change fixes the problem by overriding the currency in this case with the one of the category. M +11 -3 kmymoney/plugins/views/reports/core/querytable.cpp https://invent.kde.org/office/kmymoney/commit/49dcabca8bd912554185e49faff43c685b77764d 1951445 7 thb 2020-08-18 07:23:04 +0000 Git commit 1159cad3b33ab6cdd50985db7899228715b8fba1 by Thomas Baumgart. Committed on 18/08/2020 at 07:21. Pushed by tbaumgart into branch '5.1'. Show correct currency in report In multi-currency transactions the transaction commodity was used as currency instead of the categories currency. The value shown is correct. This change fixes the problem by overriding the currency in this case with the one of the category. FIXED-IN: 5.1.1 (cherry picked from commit 49dcabca8bd912554185e49faff43c685b77764d) M +11 -3 kmymoney/plugins/views/reports/core/querytable.cpp https://invent.kde.org/office/kmymoney/commit/1159cad3b33ab6cdd50985db7899228715b8fba1 1959554 8 ostroffjh 2020-09-22 20:39:34 +0000 *** Bug 426796 has been marked as a duplicate of this bug. *** 2352654 9 173507 ralf.habacker 2024-09-09 21:03:37 +0000 Created attachment 173507 Test file to reproduce the error that has occurred again - The date range in the test file reports has been updated to match the transactions included. - Category reports with converted and non-converted base have been added 2370464 10 ralf.habacker 2024-10-30 14:21:37 +0000 Git commit d0594c9ba43286d4acf3302fb4c03ce7bfb438cd by Ralf Habacker. Committed on 30/10/2024 at 14:15. Pushed by habacker into branch 'master'. Correction of expected test report values for “test-423870.xml” After the problem reported in error 382245 has been fixed, the expected values in reports of the mentioned test have changed and need to be adjusted. As the target accounts are managed in the US currency, the corresponding splits must also be splits must also be issued in this currency, as mentioned in the ticket. M +5 -7 kmymoney/plugins/views/reports/core/tests/data/test-423870-report-querytable-Transactions-by-Category-_Base-unconverted_.csv M +3 -5 kmymoney/plugins/views/reports/core/tests/data/test-423870-report-querytable-Transactions-by-Payee-_Base-unconverted_.csv https://invent.kde.org/office/kmymoney/-/commit/d0594c9ba43286d4acf3302fb4c03ce7bfb438cd 130888 2020-08-15 14:31:48 +0000 2024-09-09 21:03:37 +0000 Test File showing issue with report by category or payee Test KMM File.kmy application/x-kmymoney 1716 danieljbridges H4sICMbwN18AAwDlWltz2kYUfu+v2Gr6kM6ECMmAIYOb4SInaggwSGTqvmQWsRiNdSHS4ph0+mv6 T/rLevYiIS4GcYnjTP0SaXc55zvfuezZVepvHnwP3ZModsPgStFeFRVEAiccu8HtlTKnk0JVefPb T/Wf272WfdM30PsPNx96XeOmcG12DJhYe0d19q/Zve7BM6q3BkbDNnvdT+2GbaAxpuRK0Yt6sVCs FrSyovJFnYZlf/rQa5vXptHeufKjMbBAGnLHAFWOXZt/ZIfF0rqagVEfWsYAER+73pWioAD7IFvh P2602wPDspATzgO6YLNf3RlYzxYgxxVDlHhkNg0DPhjTiBAKT0INE80ezK5lm/aQ2SqlAXyhIzPF EZpF9qcpyMcBviURlxpGNFEr8DVxcIca6MXQav/K5SzBAsR88NhvWq3esGubbYu/ZwY4lobEIler a8vr742bj43O0Og3zEEigT2je+zNucI7AiBGriNFbJ2eR16qYUNiXc0QtIMwPQ9hTfTibbP/zQmr PifCVt7ZCpB4YxhpGGoiDPkgUEidKeQ2CfDII2AQ5Duzq58EZUQmJIIKwMGs5UzDx1/DYI3cWRin nogpz9tcVNdVjogbIACzx1bPsltG14aMTvAXRarZjbfrQ5L8paUVmdViHHk4pj6UsonLLBWGNiw6 fv26EceEKmhMYidyZ5TXPoWvj4gTBo7riV8484iRAbZAHipohuGNYkfqA4lBTF06TwQEc38k4jOc kUCIoIsZWF9LOeSaBYXWsJmYIGNhObIlPR+ZXgbjmrw0OnOS0nHxyPXAc09JjFZMmFmqV3MCNh5A WEyeFO5FAjdRfpArL3a7srR7urJzWivuntbOFScm9Af+07KuJ6xL3bkj5PP8qeO5kgaI0H1QfOi7 A6B2igsz3dRKcTmVnJWKusJT2uls0iXAaAU2K4lLK6QQLFufXZ7ebpF+JouS2Nnr+i22pEHQgzWw 3aIm9jBsqrGSr024gZWiFZAC5O8lN7uag9y5LAvSmchKSvFetrRacZ2ttKa+g9xGAzLDbpQnxWXN fE4WmEE8j5inDsv78hlqsxR0MhsJq6d7cklGXmdWnpUzbfyQZmxOR16ey5GXZ3Jk5UQO+hGsiugC ARlHFOPqQWbA2e3g7UV/vCSXCiwfHtteMgfFnKc2d4SD00rvdpJqZyLpwB1rhZ5Hd6yDiPqm+9ZW 8tj54RmVjGYY3sWH54l2rjbsPFa0vJBOSSzvuDJlrG4PGl2r0Vq55yqJU3dmihtmF9f/NHa3SKPF xu0eSPIZQzSxzSd+yMCyy4Xsag5XFuR+x1zWYvbCtVpCj4xHrVhU+aVGwqO8n4inQF68OT/x8C2/ E0kArFVTjY1scjrDC8LlQoG4c7mzZpHL7lA0NXN6XwGppyAL+1BuLNgHUz8eJmxcKbF1NePTnD7W 8/iYl7DHfMzL0nf0cfXH8HHt+/n44uQ8rhT0y0N8XCjvYa98zjzuJ2uOcvUeqIchZdvbiUhP9Xbp 5Iz+3t7endHf1Nta5aKi6uUDHH5saFb0slrVqjmcvvLOd/XNdizb1PFM5k3dne8XRjgmLdmJyEYn u/gvbeSUS3p5VBhXa5eF0pjgAi5VawV9PCrj0bh2eVGp/p2R545lm7EOom613hntYcdYv/a3jNZw YNrmxgQMD4xuKzMhP8HJiRvuPx6q8cIfhd6V8u8/8OxM+C4BToJfsS+fBZ/QaQhr4RQ2m7EOB8U4 WSQbvcilbjxFffaTpIOS17ur+jh9ib5fjlQ3tFA79Dwcraqqq0ub+ZefgdnasJ4Pch9NotCXBNBQ IBPRwpegOJxHLJSGMQE9GxmcRBpEmQrRln7GScRvVcatZ8qY1nzKxLlEKruslCANWdBv0yffuO0D o98b2OtdqRhFn+ckWjihN/cDyEqRVi95Tr2k+PalzMH04B/hIBZZGKPRArUA3W0YLdCLJkQ/mgeQ y/dwKibjX8FVd+7sTxKFPKkn+D6EyBAHThcWQesP1TPmkxQ/pB/cBkkiS1HL5h4W3EJkzFZhsGj5 IlzvSDRJKHDbKPueh7RXrC7H0/CLsJWGFHsxBzMmlH/Mw57HkDneHA4clGmYkEjgY/WcMO5a85iG PruJCyMqnOOFzt2VsiA4oiF7V9DUBZEZhFyEF2LxpO5lPzGDOeAx4vvMQ5L1c3Gub+Fc28c5D5Uf nPBjw/1cxF8cQ/z/NNjPV2JKx5SYHyPc66qs+ey5OWy/Nez1lqDX7Zhd4/dec3UCuo3V/7f0H26H buoIJQAA 173507 2024-09-09 21:03:37 +0000 2024-09-09 21:03:37 +0000 Test file to reproduce the error that has occurred again bug-423870.xml text/xml 11790 ralf.habacker PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCFET0NUWVBFIEtNWU1PTkVZ LUZJTEU+CjxLTVlNT05FWS1GSUxFPgogIDxGSUxFSU5GTz4KICAgIDxDUkVBVElPTl9EQVRFIGRh dGU9IiIvPgogICAgPExBU1RfTU9ESUZJRURfREFURSBkYXRlPSIyMDI0LTA5LTA5VDIyOjU4OjU0 KzAyOjAwIi8+CiAgICA8VkVSU0lPTiBpZD0iMSIvPgogICAgPEZJWFZFUlNJT04gZGF0ZT0iIi8+ CiAgICA8QVBQVkVSU0lPTiBpZD0iNS4xLjgwLWE4MmYyNGI1NyIvPgogIDwvRklMRUlORk8+CiAg PFVTRVIgbmFtZT0iIiBlbWFpbD0iIj4KICAgIDxBRERSRVNTIHN0cmVldD0iIiBjaXR5PSIiIHN0 YXRlPSIiIHppcD0iIiB0ZWxlcGhvbmU9IiIgY291bnRyeT0iIiBjb3VudHk9IiIgemlwY29kZT0i IiBwb3N0Y29kZT0iIi8+CiAgPC9VU0VSPgogIDxJTlNUSVRVVElPTlM+CiAgICA8SU5TVElUVVRJ T04gaWQ9IkkwMDAwMDEiIG5hbWU9IkJhbmsgQSAoVVNEKSIgbWFuYWdlcj0iIiBzb3J0Y29kZT0i Ij4KICAgICAgPEFERFJFU1Mgc3RyZWV0PSIiIGNpdHk9IiIgc3RhdGU9IiIgemlwPSIiIHRlbGVw aG9uZT0iIiBjb3VudHJ5PSIiIGNvdW50eT0iIiB6aXBjb2RlPSIiIHBvc3Rjb2RlPSIiLz4KICAg ICAgPEFDQ09VTlRJRFM+CiAgICAgICAgPEFDQ09VTlRJRCBpZD0iQTAwMDAwMSIvPgogICAgICA8 L0FDQ09VTlRJRFM+CiAgICA8L0lOU1RJVFVUSU9OPgogICAgPElOU1RJVFVUSU9OIGlkPSJJMDAw MDAyIiBuYW1lPSJCYW5rIEIgKEdCUCkiIG1hbmFnZXI9IiIgc29ydGNvZGU9IiI+CiAgICAgIDxB RERSRVNTIHN0cmVldD0iIiBjaXR5PSIiIHN0YXRlPSIiIHppcD0iIiB0ZWxlcGhvbmU9IiIgY291 bnRyeT0iIiBjb3VudHk9IiIgemlwY29kZT0iIiBwb3N0Y29kZT0iIi8+CiAgICAgIDxBQ0NPVU5U SURTPgogICAgICAgIDxBQ0NPVU5USUQgaWQ9IkEwMDAwMDgiLz4KICAgICAgPC9BQ0NPVU5USURT PgogICAgPC9JTlNUSVRVVElPTj4KICA8L0lOU1RJVFVUSU9OUz4KICA8UEFZRUVTPgogICAgPFBB WUVFIGlkPSJQMDAwMDAxIiBuYW1lPSJBbWF6b24iIHJlZmVyZW5jZT0iIiBlbWFpbD0iIiBtYXRj aGluZ2VuYWJsZWQ9IjAiPgogICAgICA8QUREUkVTUyBzdHJlZXQ9IiIgY2l0eT0iIiBzdGF0ZT0i IiB6aXA9IiIgdGVsZXBob25lPSIiIGNvdW50cnk9IiIgY291bnR5PSIiIHppcGNvZGU9IiIgcG9z dGNvZGU9IiIvPgogICAgPC9QQVlFRT4KICA8L1BBWUVFUz4KICA8Q09TVENFTlRFUlMvPgogIDxU QUdTLz4KICA8QUNDT1VOVFM+CiAgICA8QUNDT1VOVCBpZD0iQVN0ZDo6QXNzZXQiIHBhcmVudGFj Y291bnQ9IiIgbGFzdHJlY29uY2lsZWQ9IiIgbGFzdG1vZGlmaWVkPSIiIGluc3RpdHV0aW9uPSIi IG9wZW5lZD0iIiBudW1iZXI9IiIgdHlwZT0iOSIgbmFtZT0iQXNzZXQiIGRlc2NyaXB0aW9uPSIi IGN1cnJlbmN5PSJVU0QiPgogICAgICA8U1VCQUNDT1VOVFM+CiAgICAgICAgPFNVQkFDQ09VTlQg aWQ9IkEwMDAwMDEiLz4KICAgICAgICA8U1VCQUNDT1VOVCBpZD0iQTAwMDAwOCIvPgogICAgICA8 L1NVQkFDQ09VTlRTPgogICAgPC9BQ0NPVU5UPgogICAgPEFDQ09VTlQgaWQ9IkFTdGQ6OkxpYWJp bGl0eSIgcGFyZW50YWNjb3VudD0iIiBsYXN0cmVjb25jaWxlZD0iIiBsYXN0bW9kaWZpZWQ9IiIg aW5zdGl0dXRpb249IiIgb3BlbmVkPSIiIG51bWJlcj0iIiB0eXBlPSIxMCIgbmFtZT0iTGlhYmls aXR5IiBkZXNjcmlwdGlvbj0iIiBjdXJyZW5jeT0iVVNEIi8+CiAgICA8QUNDT1VOVCBpZD0iQVN0 ZDo6RXhwZW5zZSIgcGFyZW50YWNjb3VudD0iIiBsYXN0cmVjb25jaWxlZD0iIiBsYXN0bW9kaWZp ZWQ9IiIgaW5zdGl0dXRpb249IiIgb3BlbmVkPSIiIG51bWJlcj0iIiB0eXBlPSIxMyIgbmFtZT0i RXhwZW5zZSIgZGVzY3JpcHRpb249IiIgY3VycmVuY3k9IlVTRCI+CiAgICAgIDxTVUJBQ0NPVU5U Uz4KICAgICAgICA8U1VCQUNDT1VOVCBpZD0iQTAwMDAwMyIvPgogICAgICAgIDxTVUJBQ0NPVU5U IGlkPSJBMDAwMDA0Ii8+CiAgICAgICAgPFNVQkFDQ09VTlQgaWQ9IkEwMDAwMDYiLz4KICAgICAg ICA8U1VCQUNDT1VOVCBpZD0iQTAwMDAxMCIvPgogICAgICAgIDxTVUJBQ0NPVU5UIGlkPSJBMDAw MDExIi8+CiAgICAgIDwvU1VCQUNDT1VOVFM+CiAgICA8L0FDQ09VTlQ+CiAgICA8QUNDT1VOVCBp ZD0iQVN0ZDo6SW5jb21lIiBwYXJlbnRhY2NvdW50PSIiIGxhc3RyZWNvbmNpbGVkPSIiIGxhc3Rt b2RpZmllZD0iIiBpbnN0aXR1dGlvbj0iIiBvcGVuZWQ9IiIgbnVtYmVyPSIiIHR5cGU9IjEyIiBu YW1lPSJJbmNvbWUiIGRlc2NyaXB0aW9uPSIiIGN1cnJlbmN5PSJVU0QiLz4KICAgIDxBQ0NPVU5U IGlkPSJBU3RkOjpFcXVpdHkiIHBhcmVudGFjY291bnQ9IiIgbGFzdHJlY29uY2lsZWQ9IiIgbGFz dG1vZGlmaWVkPSIiIGluc3RpdHV0aW9uPSIiIG9wZW5lZD0iIiBudW1iZXI9IiIgdHlwZT0iMTYi IG5hbWU9IkVxdWl0eSIgZGVzY3JpcHRpb249IiIgY3VycmVuY3k9IlVTRCI+CiAgICAgIDxTVUJB Q0NPVU5UUz4KICAgICAgICA8U1VCQUNDT1VOVCBpZD0iQTAwMDAwMiIvPgogICAgICAgIDxTVUJB Q0NPVU5UIGlkPSJBMDAwMDA5Ii8+CiAgICAgIDwvU1VCQUNDT1VOVFM+CiAgICA8L0FDQ09VTlQ+ CiAgICA8QUNDT1VOVCBpZD0iQTAwMDAwMSIgcGFyZW50YWNjb3VudD0iQVN0ZDo6QXNzZXQiIGxh c3RyZWNvbmNpbGVkPSIiIGxhc3Rtb2RpZmllZD0iMjAyMC0wOC0xNSIgaW5zdGl0dXRpb249Ikkw MDAwMDEiIG9wZW5lZD0iMjAyMC0wMS0wMSIgbnVtYmVyPSIiIHR5cGU9IjEiIG5hbWU9IkFjY291 bnQgKFVTRCkiIGRlc2NyaXB0aW9uPSIiIGN1cnJlbmN5PSJVU0QiLz4KICAgIDxBQ0NPVU5UIGlk PSJBMDAwMDAyIiBwYXJlbnRhY2NvdW50PSJBU3RkOjpFcXVpdHkiIGxhc3RyZWNvbmNpbGVkPSIi IGxhc3Rtb2RpZmllZD0iMjAyMC0wOC0xNSIgaW5zdGl0dXRpb249IiIgb3BlbmVkPSIyMDIwLTAx LTAxIiBudW1iZXI9IiIgdHlwZT0iMTYiIG5hbWU9Ik9wZW5pbmcgQmFsYW5jZXMiIGRlc2NyaXB0 aW9uPSIiIGN1cnJlbmN5PSJVU0QiPgogICAgICA8S0VZVkFMVUVQQUlSUz4KICAgICAgICA8UEFJ UiBrZXk9Ik9wZW5pbmdCYWxhbmNlQWNjb3VudCIgdmFsdWU9IlllcyIvPgogICAgICA8L0tFWVZB TFVFUEFJUlM+CiAgICA8L0FDQ09VTlQ+CiAgICA8QUNDT1VOVCBpZD0iQTAwMDAwMyIgcGFyZW50 YWNjb3VudD0iQVN0ZDo6RXhwZW5zZSIgbGFzdHJlY29uY2lsZWQ9IiIgbGFzdG1vZGlmaWVkPSIi IGluc3RpdHV0aW9uPSIiIG9wZW5lZD0iMTkwMC0wMS0wMSIgbnVtYmVyPSIiIHR5cGU9IjEzIiBu YW1lPSJIb21lIFJlcGFpciIgZGVzY3JpcHRpb249IiIgY3VycmVuY3k9IlVTRCIvPgogICAgPEFD Q09VTlQgaWQ9IkEwMDAwMDQiIHBhcmVudGFjY291bnQ9IkFTdGQ6OkV4cGVuc2UiIGxhc3RyZWNv bmNpbGVkPSIiIGxhc3Rtb2RpZmllZD0iIiBpbnN0aXR1dGlvbj0iIiBvcGVuZWQ9IjE5MDAtMDEt MDEiIG51bWJlcj0iIiB0eXBlPSIxMyIgbmFtZT0iSW5zdXJhbmNlIiBkZXNjcmlwdGlvbj0iIiBj dXJyZW5jeT0iVVNEIj4KICAgICAgPFNVQkFDQ09VTlRTPgogICAgICAgIDxTVUJBQ0NPVU5UIGlk PSJBMDAwMDA1Ii8+CiAgICAgIDwvU1VCQUNDT1VOVFM+CiAgICA8L0FDQ09VTlQ+CiAgICA8QUND T1VOVCBpZD0iQTAwMDAwNSIgcGFyZW50YWNjb3VudD0iQTAwMDAwNCIgbGFzdHJlY29uY2lsZWQ9 IiIgbGFzdG1vZGlmaWVkPSIiIGluc3RpdHV0aW9uPSIiIG9wZW5lZD0iMTkwMC0wMS0wMSIgbnVt YmVyPSIiIHR5cGU9IjEzIiBuYW1lPSJIb21lIEluc3VyYW5jZSIgZGVzY3JpcHRpb249IiIgY3Vy cmVuY3k9IlVTRCIvPgogICAgPEFDQ09VTlQgaWQ9IkEwMDAwMDYiIHBhcmVudGFjY291bnQ9IkFT dGQ6OkV4cGVuc2UiIGxhc3RyZWNvbmNpbGVkPSIiIGxhc3Rtb2RpZmllZD0iIiBpbnN0aXR1dGlv bj0iIiBvcGVuZWQ9IjE5MDAtMDEtMDEiIG51bWJlcj0iIiB0eXBlPSIxMyIgbmFtZT0iVGF4ZXMi IGRlc2NyaXB0aW9uPSIiIGN1cnJlbmN5PSJVU0QiPgogICAgICA8U1VCQUNDT1VOVFM+CiAgICAg ICAgPFNVQkFDQ09VTlQgaWQ9IkEwMDAwMDciLz4KICAgICAgPC9TVUJBQ0NPVU5UUz4KICAgIDwv QUNDT1VOVD4KICAgIDxBQ0NPVU5UIGlkPSJBMDAwMDA3IiBwYXJlbnRhY2NvdW50PSJBMDAwMDA2 IiBsYXN0cmVjb25jaWxlZD0iIiBsYXN0bW9kaWZpZWQ9IiIgaW5zdGl0dXRpb249IiIgb3BlbmVk PSIxOTAwLTAxLTAxIiBudW1iZXI9IiIgdHlwZT0iMTMiIG5hbWU9IlByb3BlcnR5IFRheCIgZGVz Y3JpcHRpb249IiIgY3VycmVuY3k9IlVTRCIvPgogICAgPEFDQ09VTlQgaWQ9IkEwMDAwMDgiIHBh cmVudGFjY291bnQ9IkFTdGQ6OkFzc2V0IiBsYXN0cmVjb25jaWxlZD0iIiBsYXN0bW9kaWZpZWQ9 IjIwMjAtMDgtMTUiIGluc3RpdHV0aW9uPSJJMDAwMDAyIiBvcGVuZWQ9IjIwMjAtMDQtMDUiIG51 bWJlcj0iIiB0eXBlPSIxIiBuYW1lPSJBY2NvdW50IChHQlApIiBkZXNjcmlwdGlvbj0iIiBjdXJy ZW5jeT0iR0JQIi8+CiAgICA8QUNDT1VOVCBpZD0iQTAwMDAwOSIgcGFyZW50YWNjb3VudD0iQVN0 ZDo6RXF1aXR5IiBsYXN0cmVjb25jaWxlZD0iIiBsYXN0bW9kaWZpZWQ9IjIwMjAtMDgtMTUiIGlu c3RpdHV0aW9uPSIiIG9wZW5lZD0iMjAyMC0wNC0wNSIgbnVtYmVyPSIiIHR5cGU9IjE2IiBuYW1l PSJPcGVuaW5nIEJhbGFuY2VzIChHQlApIiBkZXNjcmlwdGlvbj0iIiBjdXJyZW5jeT0iR0JQIj4K ICAgICAgPEtFWVZBTFVFUEFJUlM+CiAgICAgICAgPFBBSVIga2V5PSJPcGVuaW5nQmFsYW5jZUFj Y291bnQiIHZhbHVlPSJZZXMiLz4KICAgICAgPC9LRVlWQUxVRVBBSVJTPgogICAgPC9BQ0NPVU5U PgogICAgPEFDQ09VTlQgaWQ9IkEwMDAwMTAiIHBhcmVudGFjY291bnQ9IkFTdGQ6OkV4cGVuc2Ui IGxhc3RyZWNvbmNpbGVkPSIiIGxhc3Rtb2RpZmllZD0iMjAyMC0wOC0xNSIgaW5zdGl0dXRpb249 IiIgb3BlbmVkPSIxOTAwLTAxLTAxIiBudW1iZXI9IiIgdHlwZT0iMTMiIG5hbWU9IkJvb2tzIiBk ZXNjcmlwdGlvbj0iIiBjdXJyZW5jeT0iVVNEIi8+CiAgICA8QUNDT1VOVCBpZD0iQTAwMDAxMSIg cGFyZW50YWNjb3VudD0iQVN0ZDo6RXhwZW5zZSIgbGFzdHJlY29uY2lsZWQ9IiIgbGFzdG1vZGlm aWVkPSIyMDIwLTA4LTE1IiBpbnN0aXR1dGlvbj0iIiBvcGVuZWQ9IjE5MDAtMDEtMDEiIG51bWJl cj0iIiB0eXBlPSIxMyIgbmFtZT0iQ2xvdGhlcyIgZGVzY3JpcHRpb249IiIgY3VycmVuY3k9IlVT RCIvPgogIDwvQUNDT1VOVFM+CiAgPFRSQU5TQUNUSU9OUz4KICAgIDxUUkFOU0FDVElPTiBpZD0i VDAwMDAwMDAwMDAwMDAwMDAwMSIgcG9zdGRhdGU9IjIwMjAtMDEtMDEiIG1lbW89IiIgZW50cnlk YXRlPSIyMDIwLTA4LTE1IiBjb21tb2RpdHk9IlVTRCI+CiAgICAgIDxTUExJVFM+CiAgICAgICAg PFNQTElUIGlkPSJTMDAwMSIgcGF5ZWU9IiIgcmVjb25jaWxlZGF0ZT0iIiBhY3Rpb249IiIgcmVj b25jaWxlZmxhZz0iMCIgdmFsdWU9IjEwMC8xIiBzaGFyZXM9IjEwMC8xIiBwcmljZT0iMS8xIiBt ZW1vPSIiIGFjY291bnQ9IkEwMDAwMDEiIG51bWJlcj0iIiBiYW5raWQ9IiIvPgogICAgICAgIDxT UExJVCBpZD0iUzAwMDIiIHBheWVlPSIiIHJlY29uY2lsZWRhdGU9IiIgYWN0aW9uPSIiIHJlY29u Y2lsZWZsYWc9IjAiIHZhbHVlPSItMTAwLzEiIHNoYXJlcz0iLTEwMC8xIiBwcmljZT0iMS8xIiBt ZW1vPSIiIGFjY291bnQ9IkEwMDAwMDIiIG51bWJlcj0iIiBiYW5raWQ9IiIvPgogICAgICA8L1NQ TElUUz4KICAgIDwvVFJBTlNBQ1RJT04+CiAgICA8VFJBTlNBQ1RJT04gaWQ9IlQwMDAwMDAwMDAw MDAwMDAwMDIiIHBvc3RkYXRlPSIyMDIwLTA0LTA1IiBtZW1vPSIiIGVudHJ5ZGF0ZT0iMjAyMC0w OC0xNSIgY29tbW9kaXR5PSJHQlAiPgogICAgICA8U1BMSVRTPgogICAgICAgIDxTUExJVCBpZD0i UzAwMDEiIHBheWVlPSIiIHJlY29uY2lsZWRhdGU9IiIgYWN0aW9uPSIiIHJlY29uY2lsZWZsYWc9 IjAiIHZhbHVlPSIxMDAvMSIgc2hhcmVzPSIxMDAvMSIgcHJpY2U9IjEvMSIgbWVtbz0iIiBhY2Nv dW50PSJBMDAwMDA4IiBudW1iZXI9IiIgYmFua2lkPSIiLz4KICAgICAgICA8U1BMSVQgaWQ9IlMw MDAyIiBwYXllZT0iIiByZWNvbmNpbGVkYXRlPSIiIGFjdGlvbj0iIiByZWNvbmNpbGVmbGFnPSIw IiB2YWx1ZT0iLTEwMC8xIiBzaGFyZXM9Ii0xMDAvMSIgcHJpY2U9IjEvMSIgbWVtbz0iIiBhY2Nv dW50PSJBMDAwMDA5IiBudW1iZXI9IiIgYmFua2lkPSIiLz4KICAgICAgPC9TUExJVFM+CiAgICA8 L1RSQU5TQUNUSU9OPgogICAgPFRSQU5TQUNUSU9OIGlkPSJUMDAwMDAwMDAwMDAwMDAwMDAzIiBw b3N0ZGF0ZT0iMjAyMC0wNi0yNyIgbWVtbz0iIiBlbnRyeWRhdGU9IjIwMjAtMDgtMTUiIGNvbW1v ZGl0eT0iVVNEIj4KICAgICAgPFNQTElUUz4KICAgICAgICA8U1BMSVQgaWQ9IlMwMDAxIiBwYXll ZT0iUDAwMDAwMSIgcmVjb25jaWxlZGF0ZT0iIiBhY3Rpb249IiIgcmVjb25jaWxlZmxhZz0iMCIg dmFsdWU9Ii01MC8xIiBzaGFyZXM9Ii01MC8xIiBwcmljZT0iMS8xIiBtZW1vPSIiIGFjY291bnQ9 IkEwMDAwMDEiIG51bWJlcj0iIiBiYW5raWQ9IiIvPgogICAgICAgIDxTUExJVCBpZD0iUzAwMDIi IHBheWVlPSJQMDAwMDAxIiByZWNvbmNpbGVkYXRlPSIiIGFjdGlvbj0iIiByZWNvbmNpbGVmbGFn PSIwIiB2YWx1ZT0iNTAvMSIgc2hhcmVzPSI1MC8xIiBwcmljZT0iMS8xIiBtZW1vPSIiIGFjY291 bnQ9IkEwMDAwMTAiIG51bWJlcj0iIiBiYW5raWQ9IiIvPgogICAgICA8L1NQTElUUz4KICAgIDwv VFJBTlNBQ1RJT04+CiAgICA8VFJBTlNBQ1RJT04gaWQ9IlQwMDAwMDAwMDAwMDAwMDAwMDQiIHBv c3RkYXRlPSIyMDIwLTA2LTI3IiBtZW1vPSIiIGVudHJ5ZGF0ZT0iMjAyMC0wOC0xNSIgY29tbW9k aXR5PSJHQlAiPgogICAgICA8U1BMSVRTPgogICAgICAgIDxTUExJVCBpZD0iUzAwMDEiIHBheWVl PSJQMDAwMDAxIiByZWNvbmNpbGVkYXRlPSIiIGFjdGlvbj0iIiByZWNvbmNpbGVmbGFnPSIwIiB2 YWx1ZT0iLTUwLzEiIHNoYXJlcz0iLTUwLzEiIHByaWNlPSIxLzEiIG1lbW89IiIgYWNjb3VudD0i QTAwMDAwOCIgbnVtYmVyPSIiIGJhbmtpZD0iIi8+CiAgICAgICAgPFNQTElUIGlkPSJTMDAwMiIg cGF5ZWU9IlAwMDAwMDEiIHJlY29uY2lsZWRhdGU9IiIgYWN0aW9uPSIiIHJlY29uY2lsZWZsYWc9 IjAiIHZhbHVlPSI1MC8xIiBzaGFyZXM9IjE2MzYvMjUiIHByaWNlPSI2MjUvODE4IiBtZW1vPSIi IGFjY291bnQ9IkEwMDAwMTEiIG51bWJlcj0iIiBiYW5raWQ9IiIvPgogICAgICA8L1NQTElUUz4K ICAgIDwvVFJBTlNBQ1RJT04+CiAgPC9UUkFOU0FDVElPTlM+CiAgPEtFWVZBTFVFUEFJUlM+CiAg ICA8UEFJUiBrZXk9Ikxhc3RNb2RpZmljYXRpb25EYXRlIiB2YWx1ZT0iMjAyNC0wOS0wOVQyMjo1 ODo1NCswMjowMCIvPgogICAgPFBBSVIga2V5PSJrbW0tYmFzZUN1cnJlbmN5IiB2YWx1ZT0iVVNE Ii8+CiAgICA8UEFJUiBrZXk9ImttbS1pZCIgdmFsdWU9InsxYmM1NDI1Yi1kODk3LTRkZWEtYTQ4 OS0yZGI1YWJkOTczNjh9Ii8+CiAgPC9LRVlWQUxVRVBBSVJTPgogIDxTQ0hFRFVMRVMvPgogIDxT RUNVUklUSUVTLz4KICA8Q1VSUkVOQ0lFUz4KICAgIDxDVVJSRU5DWSBpZD0iR0JQIiBuYW1lPSJC cml0aXNoIFBvdW5kIiBzeW1ib2w9IsKjIiB0eXBlPSIzIiByb3VuZGluZy1tZXRob2Q9IjciIHNh Zj0iMTAwIiBwcD0iNCIgc2NmPSIxMDAiLz4KICAgIDxDVVJSRU5DWSBpZD0iVVNEIiBuYW1lPSJV UyBEb2xsYXIiIHN5bWJvbD0iJCIgdHlwZT0iMyIgcm91bmRpbmctbWV0aG9kPSI3IiBzYWY9IjEw MCIgcHA9IjQiIHNjZj0iMTAwIi8+CiAgPC9DVVJSRU5DSUVTPgogIDxQUklDRVM+CiAgICA8UFJJ Q0VQQUlSIGZyb209IkdCUCIgdG89IlVTRCI+CiAgICAgIDxQUklDRSBkYXRlPSIyMDIwLTA2LTI3 IiBwcmljZT0iODE4LzYyNSIgc291cmNlPSJVc2VyIi8+CiAgICA8L1BSSUNFUEFJUj4KICAgIDxQ UklDRVBBSVIgZnJvbT0iVVNEIiB0bz0iR0JQIj4KICAgICAgPFBSSUNFIGRhdGU9IjIwMjAtMDQt MDUiIHByaWNlPSI3NjQxLzEwMDAwIiBzb3VyY2U9IlVzZXIiLz4KICAgIDwvUFJJQ0VQQUlSPgog IDwvUFJJQ0VTPgogIDxSRVBPUlRTPgogICAgPFJFUE9SVCBpZD0iUjAwMDAwMSIgdHlwZT0icXVl cnl0YWJsZSAxLjE1IiBncm91cD0iVHJhbnNhY3Rpb25zIiBuYW1lPSJUcmFuc2FjdGlvbnMgYnkg Q2F0ZWdvcnkgKEJhc2UgdW5jb252ZXJ0ZWQpIiBjb21tZW50PSJDdXN0b20gUmVwb3J0IiBjb252 ZXJ0Y3VycmVuY3k9IjAiIGZhdm9yaXRlPSIxIiBza2lwWmVybz0iMCIgZGF0ZWxvY2s9InVzZXJk ZWZpbmVkIiByb3d0eXBlPSJjYXRlZ29yeSIgcXVlcnljb2x1bW5zPSJudW1iZXIscGF5ZWUsdGFn LGFjY291bnQiIHRheD0iMCIgcHJvcEJ1ZGdldERpZmY9IjAiIGludmVzdG1lbnRzPSIwIiBsb2Fu cz0iMCIgaGlkZXRyYW5zYWN0aW9ucz0iMCIgc2hvd2NvbHVtbnRvdGFscz0iMSIgZGV0YWlsPSJh bGwiIGluY2x1ZGVzdHJhbnNmZXJzPSIwIj4KICAgICAgPERBVEVTIGZyb209IjIwMjAtMDEtMDEi IHRvPSIyMDIwLTEyLTMxIi8+CiAgICA8L1JFUE9SVD4KICAgIDxSRVBPUlQgaWQ9IlIwMDAwMDIi IHR5cGU9InF1ZXJ5dGFibGUgMS4xNSIgZ3JvdXA9IlRyYW5zYWN0aW9ucyIgbmFtZT0iVHJhbnNh Y3Rpb25zIGJ5IFBheWVlIChCYXNlIGNvbnZlcnRlZCkiIGNvbW1lbnQ9IkN1c3RvbSBSZXBvcnQi IGNvbnZlcnRjdXJyZW5jeT0iMSIgZmF2b3JpdGU9IjEiIHNraXBaZXJvPSIwIiBkYXRlbG9jaz0i dXNlcmRlZmluZWQiIHJvd3R5cGU9InBheWVlIiBxdWVyeWNvbHVtbnM9Im51bWJlcixjYXRlZ29y eSx0YWciIHRheD0iMCIgcHJvcEJ1ZGdldERpZmY9IjAiIGludmVzdG1lbnRzPSIwIiBsb2Fucz0i MCIgaGlkZXRyYW5zYWN0aW9ucz0iMCIgc2hvd2NvbHVtbnRvdGFscz0iMSIgZGV0YWlsPSJhbGwi IGluY2x1ZGVzdHJhbnNmZXJzPSIwIj4KICAgICAgPERBVEVTIGZyb209IjIwMjAtMDEtMDEiIHRv PSIyMDIwLTEyLTMxIi8+CiAgICA8L1JFUE9SVD4KICAgIDxSRVBPUlQgaWQ9IlIwMDAwMDMiIHR5 cGU9InF1ZXJ5dGFibGUgMS4xNSIgZ3JvdXA9IlRyYW5zYWN0aW9ucyIgbmFtZT0iVHJhbnNhY3Rp b25zIGJ5IENhdGVnb3J5IChCYXNlIGNvbnZlcnRlZCkiIGNvbW1lbnQ9IkN1c3RvbSBSZXBvcnQi IGNvbnZlcnRjdXJyZW5jeT0iMSIgZmF2b3JpdGU9IjEiIHNraXBaZXJvPSIwIiBkYXRlbG9jaz0i dXNlcmRlZmluZWQiIHJvd3R5cGU9ImNhdGVnb3J5IiBxdWVyeWNvbHVtbnM9Im51bWJlcixwYXll ZSx0YWcsYWNjb3VudCIgdGF4PSIwIiBwcm9wQnVkZ2V0RGlmZj0iMCIgaW52ZXN0bWVudHM9IjAi IGxvYW5zPSIwIiBoaWRldHJhbnNhY3Rpb25zPSIwIiBzaG93Y29sdW1udG90YWxzPSIxIiBkZXRh aWw9ImFsbCIgaW5jbHVkZXN0cmFuc2ZlcnM9IjAiPgogICAgICA8REFURVMgZnJvbT0iMjAyMC0w MS0wMSIgdG89IjIwMjAtMTItMzEiLz4KICAgIDwvUkVQT1JUPgogICAgPFJFUE9SVCBpZD0iUjAw MDAwNCIgdHlwZT0icXVlcnl0YWJsZSAxLjE1IiBncm91cD0iVHJhbnNhY3Rpb25zIiBuYW1lPSJU cmFuc2FjdGlvbnMgYnkgUGF5ZWUgKEJhc2UgdW5jb252ZXJ0ZWQpIiBjb21tZW50PSJDdXN0b20g UmVwb3J0IiBjb252ZXJ0Y3VycmVuY3k9IjAiIGZhdm9yaXRlPSIxIiBza2lwWmVybz0iMCIgZGF0 ZWxvY2s9InVzZXJkZWZpbmVkIiByb3d0eXBlPSJwYXllZSIgcXVlcnljb2x1bW5zPSJudW1iZXIs Y2F0ZWdvcnksdGFnIiB0YXg9IjAiIHByb3BCdWRnZXREaWZmPSIwIiBpbnZlc3RtZW50cz0iMCIg bG9hbnM9IjAiIGhpZGV0cmFuc2FjdGlvbnM9IjAiIHNob3djb2x1bW50b3RhbHM9IjEiIGRldGFp bD0iYWxsIiBpbmNsdWRlc3RyYW5zZmVycz0iMCI+CiAgICAgIDxEQVRFUyBmcm9tPSIyMDIwLTAx LTAxIiB0bz0iMjAyMC0xMi0zMSIvPgogICAgPC9SRVBPUlQ+CiAgICA8UkVQT1JUIGlkPSJSMDAw MDA1IiB0eXBlPSJxdWVyeXRhYmxlIDEuMTUiIGdyb3VwPSJUcmFuc2FjdGlvbnMiIG5hbWU9IlRy YW5zYWN0aW9ucyBieSBhY2NvdW50IChCYXNlIGNvbnZlcnRlZCkiIGNvbW1lbnQ9IkN1c3RvbSBy ZXBvcnQiIGNvbnZlcnRjdXJyZW5jeT0iMSIgZmF2b3JpdGU9IjAiIHNraXBaZXJvPSIwIiBkYXRl bG9jaz0idXNlcmRlZmluZWQiIHJvd3R5cGU9ImFjY291bnQiIHF1ZXJ5Y29sdW1ucz0ibnVtYmVy LHBheWVlLGNhdGVnb3J5LHRhZyxiYWxhbmNlIiB0YXg9IjAiIHByb3BCdWRnZXREaWZmPSIwIiBp bnZlc3RtZW50cz0iMCIgbG9hbnM9IjAiIGhpZGV0cmFuc2FjdGlvbnM9IjAiIHNob3djb2x1bW50 b3RhbHM9IjEiIGRldGFpbD0iYWxsIiBpbmNsdWRlc3RyYW5zZmVycz0iMCI+CiAgICAgIDxBQ0NP VU5UR1JPVVAgZ3JvdXA9ImFzc2V0Ii8+CiAgICAgIDxBQ0NPVU5UR1JPVVAgZ3JvdXA9ImFzc2V0 bG9hbiIvPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJjYXNoIi8+CiAgICAgIDxBQ0NPVU5U R1JPVVAgZ3JvdXA9ImNoZWNraW5ncyIvPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJjcmVk aXRjYXJkIi8+CiAgICAgIDxBQ0NPVU5UR1JPVVAgZ3JvdXA9ImV4cGVuc2UiLz4KICAgICAgPEFD Q09VTlRHUk9VUCBncm91cD0iaW5jb21lIi8+CiAgICAgIDxBQ0NPVU5UR1JPVVAgZ3JvdXA9Imxp YWJpbGl0eSIvPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJsb2FuIi8+CiAgICAgIDxBQ0NP VU5UR1JPVVAgZ3JvdXA9InNhdmluZ3MiLz4KICAgICAgPEFDQ09VTlRHUk9VUCBncm91cD0ic3Rv Y2siLz4KICAgICAgPERBVEVTIGZyb209IjIwMjAtMDEtMDEiIHRvPSIyMDIwLTEyLTMxIi8+CiAg ICA8L1JFUE9SVD4KICAgIDxSRVBPUlQgaWQ9IlIwMDAwMDYiIHR5cGU9InF1ZXJ5dGFibGUgMS4x NSIgZ3JvdXA9IlRyYW5zYWN0aW9ucyIgbmFtZT0iVHJhbnNhY3Rpb25zIGJ5IGFjY291bnQgKEJh c2UgdW5jb252ZXJ0ZWQpIiBjb21tZW50PSJDdXN0b20gcmVwb3J0IiBjb252ZXJ0Y3VycmVuY3k9 IjAiIGZhdm9yaXRlPSIwIiBza2lwWmVybz0iMCIgZGF0ZWxvY2s9InVzZXJkZWZpbmVkIiByb3d0 eXBlPSJhY2NvdW50IiBxdWVyeWNvbHVtbnM9Im51bWJlcixwYXllZSxjYXRlZ29yeSx0YWcsYmFs YW5jZSIgdGF4PSIwIiBwcm9wQnVkZ2V0RGlmZj0iMCIgaW52ZXN0bWVudHM9IjAiIGxvYW5zPSIw IiBoaWRldHJhbnNhY3Rpb25zPSIwIiBzaG93Y29sdW1udG90YWxzPSIxIiBkZXRhaWw9ImFsbCIg aW5jbHVkZXN0cmFuc2ZlcnM9IjAiPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJhc3NldCIv PgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJhc3NldGxvYW4iLz4KICAgICAgPEFDQ09VTlRH Uk9VUCBncm91cD0iY2FzaCIvPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJjaGVja2luZ3Mi Lz4KICAgICAgPEFDQ09VTlRHUk9VUCBncm91cD0iY3JlZGl0Y2FyZCIvPgogICAgICA8QUNDT1VO VEdST1VQIGdyb3VwPSJleHBlbnNlIi8+CiAgICAgIDxBQ0NPVU5UR1JPVVAgZ3JvdXA9ImluY29t ZSIvPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJsaWFiaWxpdHkiLz4KICAgICAgPEFDQ09V TlRHUk9VUCBncm91cD0ibG9hbiIvPgogICAgICA8QUNDT1VOVEdST1VQIGdyb3VwPSJzYXZpbmdz Ii8+CiAgICAgIDxBQ0NPVU5UR1JPVVAgZ3JvdXA9InN0b2NrIi8+CiAgICAgIDxEQVRFUyBmcm9t PSIyMDIwLTAxLTAxIiB0bz0iMjAyMC0xMi0zMSIvPgogICAgPC9SRVBPUlQ+CiAgPC9SRVBPUlRT PgogIDxCVURHRVRTLz4KICA8T05MSU5FSk9CUy8+CjwvS01ZTU9ORVktRklMRT4K