Please click Accept as solution if my post helped you solve your issue. This has been extremely helpful, many thanks! However, i am just wondering if there is a way i can change the name of the attachment from the dropdown boxes of other areas in the form so that it doesnt show a string of numbers when uploading from iphone? Evan Chaki, Principal Group Program Manager, Wednesday, March 20, 2019. Unable to process template language expressions in action Create_file inputs at line 1 and column 11834: The template language expression triggerBody()[file][name] cannot be evaluated because property file cannot be selected. name: First(att_SubmitContract_AttachFile.Attachments).Name ); Can you please share a screenshot of the error message you are receiving? For example, a document in the Document Library has a metadata column "Fruit". By signing up, you agree to the terms of service. You can't yield a full name in this case. We can now include metadata with the document at the time of upload to SharePoint. }, Now that we have this set to trigger when an item is added and we are getting the attachments, the next step is to get the content from the attachments. Here's a little background on my use case and setup. ), Then add another action at the bottom of the flow: SharePoint Update file properties, Now we are done updating the Flow. The File Content field should reference the file found in our flow trigger. Ive attempted using it with my drop-downs for metadata but it gives me an error. In the Submit A Contract app a salesperson needs to add a file to an attachments field and upload it to SharePoint. (OrderID = A[@OrderID]) is expected to compare the OrderId in the lookup scope with the OrderId of collection A in the ForAll scope. The Mid, Find, and Len functions are added to the button to isolate the base64. Then insert a few labels and icons to make it look like the screenshot below. contentBytes: First(att_SubmitContract_AttachFile.Attachments).Value, For comboboxes, its more complicated. Power Platform and Dynamics 365 Integrations. At least this way worked well for me. But Im glad we finally have something straightforward now. You may already know how to work with SharePoint lists but document libraries present new challenges. Then go to My flows -> + New flow -> Select Instant cloud flow. Unit_Dropdown.Selected.Value, PS: If I edit an existing DocSet it . Unable to process template language expressions in action Create_file inputs at line 1 and column 11905: The template language expression triggerBody()[file][name] cannot be evaluated because property file cannot be selected. Is there a working solution to this? Hi Matthew, as Im doing this on my own PowerApp, I presume that I replace the att_SubmitContract_AttachFile with the name of my PowerApp? Workarounds get the job done but they require research to learn. The trigger input field is set to required. Uploading files to SharePoint document library from Power Apps just got easier! You can create experiences for your end users to view a listing of files that come from a SharePoint document library. Related functions include the Update function to replace an entire record, and the Collect function to create a record. File Name- Create File Name Thanks for taking the time to have a look. contentBytes: First(AttachFiles.Attachments).Value, dte_SubmitContract_ContractDate.SelectedDate.SelectedDate, .Add two labels, two text box controls and a button to the screen. Now its worked. file: { Records are processed in the order from the beginning of the argument list to the end, with later property values overriding earlier ones. Captured on Oct In PowerApps the Attachment control works by linking a SharePoint list (Or CDS) to a form Attachments Powerapps for Wordpress is a plugin that allows you to easily add your. Find the control that has the paperclip icon and right-click and Copy the control. when I enter the triggerBody()[file][name], Unable to process template language expressions in action Create_file inputs at line 1 and column 11905: The template language expression triggerBody()[file][name] cannot be evaluated because property file cannot be selected. When adding meta data I am receiving an error on the submit button once I adjust the code. from the Media menu. Strong consulting professional with a Bachelor of Engineering (B.E.) In a blog post earlier this month, we announced read-write support for Person, Choice, and Lookup fields. Please click Accept as solution if my post helped you solve your issue. Please re-read the section of my article titled Add Metadata To A SharePoint Document Library and look at the 2nd paragraph. Remove any code from the Upload button's OnSelect property and replace it with this code. Have you remembered to set all of the flow trigger inputs to required? The values of specific fields are modified without affecting other properties. ); When I use without the metadata it works perfectly. You can also update the metadata at the same time. File Name requires a flow expression. But most folks simply call it tagging documents. name: First(att_SubmitContract_AttachFile.Attachments).Name This my code: UploadFileToDocumentLibrary.Run( You must be a registered user to add a comment. Please try again later. ); I figured that I need to set up the equation correctly like in the screenshot. ); My screenshot has caused some confusion so I will go ahead and correct it. Go to the Image Info field Data card and unlock it (Advanced -> Unlock to change properties). We're already working on setting up your trial. Invalid number of arguments: received 4, expected 1. Ive revised the SelectedDate.SelectedDate code to only a single SelectedDate but other than that the code appears to be working for me. I did think of that, although obviously it does add a fair whack of complexity. Directorate_Dropdown.Selected.Value, However, I don't believe this article addressesupdating metadata or in particular updatingcustom metadata configured on a Content Type (in case there is any difference between updating core vs. custom metadata). }, txt_SubmitContract_CustomerName.Text, You can create experiences for your end users to view a listing of files that come from a SharePoint document library. Moving PowerApps Attachments to a Document Library, SharePoint, Microsoft 365 and Power Platform Consultant, Encodian Founder | O365 Architect / Developer, Business process and workflow automation topics. and Microsoft Privacy Statement. Would appreciate anyone being able to have a look at the below and see if there's anything glaring that I've missed? The Set and JSON functions are added to the button in order to upload a file directly to a SharePoint document library. If you created a record, the return value may include properties that the data source generated automatically. I have customized this form with PowerApps and have added the ability to upload attachments to the RFI list item. }, Select Instant cloud flow, it will trigger the following screen. volta elektrikli bisiklet wife has orgasm while sucking husband complete list of australian coins However, its not clear how to configure these for custom applications and the code block youve provided doesnt work outside the parameters youve setup on your app. My tutorial is for SharePoint document libraries only. No crazy complex code, finally a straight forward way to save a. That's it! You'll have no problem to update the columns of a record (if the file is already exist in document library), but you cannot create a new record in document library if don't suply the file and this is not posible right now from PowerApps. I entered this in the expressions for the File Name. If I change code to the following, I can reduce errors to just the invalid number of arguments, 4 vs 1: UploadFileToDocumentLibrary.Run( Your work is amazing! Use the Patch function to modify records in complex situations, such as when you do updates that require no user interaction or use forms that span multiple screens. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Patch('Risk Assessments',{'Job Type':DataCardValue66.Selected.Value},{'Activity':DataCardValue35.Text},{'Team members': DataCardValue58.SelectedItems}, {'Date': DataCardValue31.SelectedDate},{'Task Location':DataCardValue32.Text},{'Task 1': DataCardValue33.Text},{'Task 1 Hazards':DataCardValue36.SelectedItems},{'Task 1 existing controls': DataCardValue37.SelectedItems},{'Task 1 consequence': DataCardValue55.Selected},{'Task 1 likelihood': DataCardValue59.Selected},{'Task 1 additional controls': DataCardValue42.Text},{'Task 1 residual consequence':DataCardValue56.Selected},{'Task 1 residual likelihood':DataCardValue57.Selected}); The central item of a document library record is the File /Folder itself, or in your case it seems that this important piece is missing. However, if you are using a complex data type such as a Choice, Person, or LookUp you would have to modify the flow and app to accept them. Can you maybe also share an example of what to put in the OnSelect property in this scenario? In this library, you've added a Person column to track a document's owner. More info about Internet Explorer and Microsoft Edge, {ID:1, Flavor:"Chocolate", Quantity:400 }, { ID:3, Flavor:"Strawberry", Quantity:0}. Patch returns the merged record and doesn't modify its arguments or records in any data sources. You'll notice after you fill out all of the properties for this action, that it automatically wraps the action in an "Apply to Each" function. Solve your everyday business needs by building low-code apps. 2. https://powerusers.microsoft.com/t5/Building-Power-Apps/How-can-we-reset-the-attachment-field/td-p/136245. With any other format, it throws out the error that it is an unsupported format. Im thinking many of the others are having the same issue. Using PowerApps to Update SharePoint Document Library Object's Custom Metadata. }, For the managed metadata question, Im terribly sorry, but Im just not sure. Patch a SharePoint document library using Name to select the record to be updated. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. To add this feature, connect the app to the Contract document library in SharePoint. } I had to also go and remove the flow in my app and re-add it to get rid of the errors I was getting after making this change. 'Full Name'. Use the following properties in the attachments control: Our app now has an attachments field we can use to upload the contract documents. Patch ( SPDocLib, LookUp (SPDocLib,Name = "example_photo.jpg"), {groupID:varRecord.ID} ) I could amend my Flow to update this column, or return the ID as a second output to PowerApps and use that to patch, but wondered if anyone knows of a limitation working with patch on a document library in this way? When using Patch in this manner, the return value is also a table with each record corresponding one-for-one with the base and change records. Check out the latest Community Blog from the community! To do this we will use the new Power Apps (V2) trigger in Power Automate which includes the file data type as an input It is no longer necessary to perform a complicated series of steps to transform a file to binary using the JSON function and then back to Base64 (not exactly low-code).In this article I will show you the easiest way to upload files to a SharePoint document library in Power Apps and add metadata (i.e. Since mine are required I did not have to specify the parameter name. A file must be passed as an object to Power Automate. So far as I can tell, First(.Attachments).Value returns the blobmanager url only. } ); With the above coding (from your field above) I get multiple errors (name isnt valid, invalid use of . (x2), Text has some invalid arguments, and invalid number of arguments: received 4 arguments, expected 1). This inspires to do some great PowerApps/Flow stuff. Power Apps Containers for Gallery Columns If you use a lot of galleries in your Power Apps, you may have noticed that it can get tedious sometimes, lining things up and arranging controls, especially when you Share this: Click to share on Twitter (Opens in new window) Click to share on Facebook (Opens in new window) Open the Power Automate action from the top menu and select Create a new flow. to set up a new trial account instead. Since this is an optional step, the rest of this article will assume you have used the single-file upload method. Power Platform Integration - Better Together! Add a SharePoint action to the flow: Create File. The attachments generated by the app would need to go through together to the one flow. Instead of passing a single base record, a table of base records can be provided in the second argument. UploadFileToDocumentLibrary.Run( thanks for your post, I tried to use upload multiple documents, but flow doesnt started, If I use ForAll function. Power Platform and Dynamics 365 Integrations. { Just to add to Davids comment, you can use the Peek Code to check if they are required or not. Thanks again. Use Patch with the Defaults function to create records. Sometimes Power Apps does not recognize any changes until we do this. I've tried all sorts to patch the forms to the library with not a lot of success, so am trying to patch the individual tables to the library columns instead. One of the newly released features of PowerApps is the ability to add attachments to a SharePoint list item. Fortunately there is a way to accomplish this with Flow! Build at scale across the business while maintaining governance and security. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. Specify two or more records that you want to merge. In contrast, the UpdateIf and the Patch functions modify one or . I have been able to apply this successfully to simple file attachment and upload. The following controls are supported in the PowerApps web player: Image Video Audio Power Apps Easiest Way To Upload Files To A SharePoint Document Library All Power Apps Date & Time Functions (With Examples) 7 Ways To Use The PATCH Function In Power Apps (Cheat Sheet) PowerApps Collections Cookbook Easiest Way To Generate A PDF In Power Apps (No HTML) 2,000 Free Power Apps Icons Sorry to hear you ran in to some of the eccentricities. You need to send the file content via Power Automate and create the fiel in there. Document libraries have a unique icon so you can quickly discover and select them from the data source list. Ive made the directions bold in the tutorial so hopefully everyone sees that we are using a required field in the flow. Therefore, it is recommended to use the As operator or ThisRecord to resolve the field name and avoid ambiguity. Please set all of the trigger inputs to required and then this message will likely go away. UploadFileToDocumentLibrary.Run( A salesperson might want to see a list of the most recently uploaded files. I am a Microsoft Business Applications MVP and a Senior Manager at EY. If you are trying to add a new item to a Document Library using Patch, you cannot do this. InvalidTemplate. I hope you all are doing well today. The tutorial uses required flow inputs only so my code will be OK. Unable to process template language expressions in action Create_file inputs at line 1 and column 12241: The template language expression triggerBody()[file][name] cannot be evaluated because property name doesnt exist, available properties are . When the flow input is required this is the correct syntax: UploadFileToDocumentLibrary.Run( Use this behavior to build a single screen for both creating and editing records. Change records are provided in a table as well, corresponding one-for-one with the base records. data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABM8AAAGFCAYAAADq7NRjAAAgAElEQVR4Aey9e5QV1Z33fZj1/PE87/Pfs5akff8wy3dlZca8cVbIkBl7MmYSopkJxGeewDAzgsYIGWeEZOZFYsYewkgQLyEdEEXbGCKTS3cStUkkNqNIewnYJIqNStNcGrqF5iKN0FzUxgv+3vWtc37Vu/apOqfq3KrqnG+tVV3nUrX3ru/+VtXZn/7tvTPnzp2ToHVsbEyKrW+//bYErW+99ZZEWd98803hSg3oAXqAHqAH6AF6gB6gB+gBeoAeoAfoAXqAHqAHbA9EYUzYN4hX4fNivAvfKy/L6At7WywRvwIEnYR9smHenz17VrhSA3qAHqAH6AF6gB6gB+gBeoAeoAfoAXqAHqAHGtcDYRiSvU8Qn/JjWcX4F3iZLzwrdKBfRnah7ELr+3LNfubMGeFKDegBeoAeoAfoAXqAHqAH6AF6gB6gB+gBeoAeqD8PlMuNlD/ZW5tb+bGtQiwsD54F7eyXsJ25XTj7pKMY+/Tp08KVGtAD9AA9QA/QA/QAPUAP0AP0AD1AD9AD9AA90LgeiMKSbA5lcyqbY/mxLj8u5oFnfjvgMzsxOzOzMGZB7RMsZPZTp04JV2pAD9AD9AA9QA/QA/QAPUAP0AP0AD1AD9AD9AA9EOSBQmzJ5lAmozLZlc21bO5l8zEXntlf6Hs7ATMDzdgsjFlQ84Tskx4dHZVy15MnTwpXakAP0AP0AD1AD9AD9AA9QA/QA/QAPUAP0AP0QPo8UC4XwvE2bzJZlMmoTHalPMtkXDb/Ui6GrQPPzA/M1+aBZoKaCbaauRbILKSegC2Gn6FPnDghXKkBPUAP0AP0AD1AD9AD9AA9QA/QA/QAPUAP0AP0QJAH/JiSzZ2UR5mMSrmVciyTbZnMy2Rhysgy+sLemjubiWjimplmrgXSAmrBzZMyT/yNN94Qv/X48ePClRrQA/QAPUAP0AP0AD1AD9AD9AA9QA/QA/QAPUAPqAf8GBI+M1mTyaCUSymnUm6lHEu5lnIuk32ZTAy8zBeemTuZB2uCmgEy1My1MCicFlZPwDxBPWlsR0ZG8tZjx44JV2pAD9AD9AA9QA/QA/QAPUAP0AP0AD1AD9AD9AA9oB7wY0gmYzLZk/Io5VNgVcqtlGOBaSnfUt5lMjCTjeXBM/NL8yBNCAkrpUOGmrkNzbTQeiJ6knrS2L7++uue9ejRo8KVGtAD9AA9QA/QA/QAPUAP0AP0AD1AD9AD9AA9QA/YHrA5ksmYlDsph1IuBZAWBNGUb4F1KfcyWZgyslDwTBPwA2caBoeCoEBaOI0s0xPREzRP/MiRI6Lr4cOHJep66NAh4UoN6AF6gB6gB+gBeoAeoAfoAXqAHqAH6AF6gB5InweiciDsrxwJW5MxKXdSDgWYBjalnEohmnIsBIMhKKwQQPOFZ/ohtkraioEzhWYKzkxopgXHyejJqTCmqYeHh8VeDx48KFypAT1AD9AD9AA9QA/QA/QAPUAP0AP0AD1AD9ADjesBmxfhvcmUlDMpdwKDUh4FkGZCNLArE6KFBWieyDOFZ1HBGSieDc1sYIYT0xNW0x84cEB0fe2118RvHRoaEq7UgB6gB+gBeoAeoAfoAXqAHqAH6AF6gB6gB+iBxvGAHyPCZ8qRsFW+pLwJ7MmMTlOQ5gfREAymY6EVi0Bz4ZmCMzvqTAdPQxibjnGm45sFRZsp7UOBFZrhhPQEcbKm4QcHB0XX/fv3C1dqQA/QA/QAPUAP0AP0AD1AD9AD9AA9QA/QA/QAPaAeUG6ErcmUTKAG9qSRaSZEQyRaWICmHAw9MTW4LA+e6Rd2d81C4AwFQEE02swGZiYsw0nqie/bt0+wDgwMuOvevXsl7Lpnzx7hSg3oAXqAHqAH6AF6gB6gB+gBeoAeoAfoAXqAHkifB8LyH+xnsiPlScqXTKCmMM0EaTo+mkI0HQstqAunPYGAA88KRZ0VizgzwZkZaYYoM4VmCsxMUIYTN429e/du0XXXrl0SZu3v7xeu1IAeoAfoAXqAHqAH6AF6gB6gB+gBeoAeoAfogfR5IAz7wT7Ki7A1WZIJ1cCcANMUpClEMyPRzG6cYQEagsw88MyMOtMwNRuemV01/cCZds9EIW1opsAMJ6sCqbl37twp5trX1ydcqQE9QA/QA/QAPUAP0AP0AD1AD9AD9AA9QA/QA43rAZMV4bVyJOVKCtQUpJkQTQEaWJWOhxYE0Ozxz5SLoWdmppSoM50cQLtqIuLsm3/4Ta7UgB6gB+gBeoAeoAfoAXqAHqAH6AF6gB6gB+gBeiCxHjh86LAz7BiYls7EWaz7pgvPzKgzUDUQNjPqDLMQaNQZEkfUGWiddtUkPCM8pAfoAXqAHqAH6AF6gB6gB+gBeoAeoAfoAXqAHkiyBw4NZ2fkBNMC2wLjeuONNxzmBfZ16tQpZ8JMMDEd+8wXntngTGfXRGKIOtPumhhwDWFvCH9LsjAsGy9ceoAeoAfoAXqAHqAH6AF6gB6gB+gBeoAeoAfogYMHsl04wbTsCQQAz/y6b3rgWdAMm3bUGRJXcIaB1zA5AA1IA9ID9AA9QA/QA/QAPUAP0AP0AD1AD9AD9AA9QA8k2QMHXjsgOomAArRi0WdF4Zlf1BlC25CBgjMMwJZkYeqxbCNDI8KVGtAD9AA9QA/QA/QAPUAP0AP0AD1AD9AD9AA9EOwBmwm9NvSaEwQGpgW2pd03dfZNjT47ffq0M5wZemc68Mwc78yvy6Y51plGnWGsM3TX1Fk17cLwfXVJMy+M4AuD2lAbeoAeoAfoAXqAHqAH6AF6gB6gB+gBeoAegAdsPjW4f9BhWWBaYFt+0Wd2182i8Ey7bPqNdYbumkNDQ7J///68wtiF4/vKwjTeBHgToAfoAXqAHqAH6AF6gB6gB+gBeoAeoAfoAXqgsAdsHrV/336HZYFpYRx/hWcY3x/sS2feNCcOcOGZ33hnQV02QeYQ3qZRZ/v27SM8q/E0tLw4Cl8c1If60AP0AD1AD9AD9AA9QA/QA/QAPUAP0AP0gA3P9g3sk8HBbPQZ2BYYV7Gum4HwDITNhGcYPE27bOoMmxp1NjAwQHhGeMYx2DgOHT1AD9AD9AA9QA/QA/QAPUAP0AP0AD1ADyTKAzY8G9g74PSgBNNC100z+kwnDtBxz8DGzpw5I5lSxjvTiQKQEaLO9u7dS3hGeJaoi4P/XeB/F+gBeoAeoAfoAXqAHqAH6AF6gB6gB+gBesCGZ3v37HVYFpgWum7qxAEIGFN4hq6b5rhnoeCZjneGMDbtsokMEOaGqLM9e/YQnhGeEZ7xvwv0AD1AD9AD9AA9QA/QA/QAPUAP0AP0AD2QKA/Y8GzP7j0OywLTUnhmd92MBM/syQIUnuksm5goAPBs9+7dhGeEZ4m6OPjfBf53gR6gB+gBeoAeoAfoAXqAHqAH6AF6gB6gB2x4tnvXbodlgWlhLH+dddMc98yeNCAw8swc78yMPLPHO0OXzV27dhGeEZ4RnvG/C/QAPUAP0AP0AD1AD9AD9AA9QA/QA/QAPZAoD9jwbFf/Lmf4McAzc9wzE5698cYbouOenT59OnjMMxOe2ZMFIKxNxztDl03Cs2/WHB6SnpOe0wP0AD1AD9AD9AA9QA/QA/QAPUAP0AP0AD1Q2AN+8AwsC2P467hnhSYNqBg86+/vrzk8sk++0d7z4ih8cVAf6kMP0AP0AD1AD9AD9AA9QA/QA/QAPUAP0AM2L+rf2e+M3V9VeKYzbZqTBRCeMfKMNyTekOgBeoAeoAfoAXqAHqAH6AF6gB6gB+gBeiBpHgiCZxjD35w04MiRI2LOuFm02+apU6ecKTkxQBr6eWq3TZ1pEwOqKTzDZAE7d+5k5BnHPEtUn+akXawsDx8g9AA9QA/QA/QAPVAJDxwbPCZcqQE9QA/QA9XzQCXu1UwjWc98G57t7NvpTHyp8AyMC4FiYF4mPDNn3HQmDHjzzTcF69mzZ+XMmTPiB890pk0kSHhW+0gzu7J5MSbrYmR9sD7oAXqAHqAH6AF6oNIeYOO4eo1jaktt6QF6IIoHKn1/Z3q1/c1g85RC8AzsCwFkCCSLBM/MmTbNyDPMSoCZNhl5Fg9I48VW24uNelNveoAeoAfoAXqAHqi2B6I05LgvG/70AD1AD8TngWo/D5h+ZX9zBMEzMC2wLTPyzJxxs6LwDDNtsttm7QEaL6bKXkzUk3rSA/QAPUAP0AP0QFweYAM4vgYwtaf29AA9UI4H4npuMN9ov1n84BlYVknwDF02sWIKTrPbph15dvDgQYfKaeQZMuzr6+OYZxzzjGOeDUW7gHnDo170AD1AD9AD9AA9EKXR9vr+14UrNaAH6AF6oPoeiHJv5rM8+c9yG5717egTG56BdaG3ZdHIM8Kz2keP2RUY5T0v0ORfoKwj1hE9QA/QA/QAPUAPFPJAscZZmAby0X1HhSs1oAfoAXqgdA+EudcWu18Xutfzu/h/C9ispWbwbGhoyOkXihA3Rp7FA914AcZ/AbIOWAf0AD1AD9AD9AA9UKoHCjXE/BpybBiX3jCmdtSOHqAHSvGA37240L271OcBj6v+b4li8AyMqyqRZ4Rn8QAzs8J5gVX/AqPG1JgeoAfoAXqAHqAHquGBoMaX3VBDY+/IviOe9fDAYeFKDegBeoAeqJ4H7Psu7sX2/TnoPl6NZwbTLP+3iMlS8NqOPCM8q/E4ZHaFVPM9L6DyLyBqSA3pAXqAHqAH6AF6oNYeCGpwmQ0zs+F2aO8hyVv3HJJDXKkBPUAP0AOV94DPPde8J5v36qD7ea2fK8yv+G8Zm82UDc/OnDkTasIARp4x8owXaPELlBpRI3qAHqAH6AF6gB4wPeDX0DIbYhpphogSwLHh3cNycNdBOdB/wF1f2/maDO0cKrgO9g0KV2pAD9AD9EC+B4rdP3GPNe+5uAfjXox7Mu7NAGl2JJrfvd289/N1/L8FCM/qOLLMrlz7PS/A+C9A1gHrgB6gB+gBeoAeoAfCesCvceUHzhBlhobaiSMn5Pz754ULFaACVIAKxKsA7sW4JzsQbe8hArSh9D37bZ7CyLMGgmlhf6hxv/Rd2Kwz1hk9QA/QA/QAPVBfHigFnMXbVGTuVIAKUAEqYCtAgJbeZ3NDwbPFn1osT977pOz7/T55+/Tbto8T+f7koZOy46kd8tjtj4ldWeW+54/q9F64rDvWHT1AD9AD9AA90FgeKATP0P0Hq3bVRJchRpwl8qc9C0UFqECDK4B7M+7R2oVT798aRex3r+fzPhnPe5u/VDTy7OTJk3LixAk5fvy4HDt2TI4ePSqHDh1ypu/UMc/27Nkj/f390tfXV3E4ZJ7cf87/z9QAs6D7yeH+w7Li/6yomE68CJNxEbIeWA/0AD1AD9AD9AA9UMgDfo0pbWhpwwtj6KC7JsbW2b9jf9DPSX5OBagAFaACMSuAezTu1bhn6/hnuJfrfd3vnl/oGcHvavMbwuRLeA14BpYFprV//37R2TbBvMC+wMDAwsDEwMZOnTolmbfeekvefPNNOXv2rJgTBiQFnrVd2+ZeHicPn5SN924UfJaGFdDvtz/+rYydGXPOARFzi/90cUUAGi+y2lxk1Jk60wP0AD1AD9AD9ECpHvBrRGkDywZniGRARMO+V/e5v335ggpQASpABZKlAO7RGn1GgJae3wd1D8/QVRNdH7H0beoTvLdPOg3vb59yuwD8YUE3zm/+UfmzdZb6I47HpecCZ12xrugBeoAeoAfogXR7oBg8Q9SCRp1hIGrMArf35b3Ob0b+oQJUgApQgeQpgHs07tXm5AEagab/HPG79/N5Hu/z3OZGdRd59otbfuFcLYjcSis400oyI+hu//ztZUNAXnzxXnzUn/rTA/QAPUAP0AP0QDEP2A0obViZUWc61pnCsz29e5LXWmSJqAAVoAJUwFEA92gXnu055IxXqfCsUPfNYs8Lfl/d3xTKZXRbd/AMXR6xvPirF8uGTSpSnFuNPvvPr/9n2efDi6u6Fxf1pb70AD1AD9AD9AA9UK4HCsEzNLYAzhSe6Xhnu3t3s4lKBagAFaACCVUA92h33LMcPMN9XAGa/pPEvv+X+zzh8eX9JrE5UN3Bs/0vZAdMxThn9smm8X0lz4cXT3kXD/WjfvQAPUAP0AP0AD1QTQ/YDSdtUOVFne095HT/OdB/wBnvbNdLuxLaZGSxqAAVoAJUAPdojHuGe7Z23TThGaPPkvnbwuZHhGd/WP5YYraolXxPeJbMC6maP5yZNuucHqAH6AF6gB5oTA8UgmeIUNDIMww4jQYYBqAeeGVA+rf1s3VKBagAFaACCVUA92jcq3HPtuEZo8+S+7y3uQ7hGeGZ8Ad6ci9Y1g3rhh6gB+gBeoAeaBwPFINnTnfNvYcEs2yiyybhWUJbyiwWFaACVMBQwIRnuHfjHo5/gpjRZxppbD8H+Bsgvt8AhGcJh2V2BTHyLL6LhTcqak8P0AP0AD1AD9ADtfSA3WhCY8qvy6bCM51pc+eLO41mGl9SASpABahAkhTAPVpn3AyCZ9p1034O1PIZxLy8v3lsNsPIs4TDNMIzr4F5QVMPeoAeoAfoAXqAHqhXD5iNJo1C8INn6PaDsXMAz/Zs3yN9L/QlqZ3IslABKkAFqIChAO7RuFfjnh113LN6fd6l4bwIzxIOy+wKSgM861s1TTKZjO868aOXy7Rrlkjbuj52Dx0KbuxsW35FTr8rZMUzx6jV0DZp+/JEyVwwQ+7/7UHpvGGCTIDHZq6VgQI6em/Cw9I5b2JWV/u4V7ZJx5I5Mm3SRa5v4dXZN62VLa/41NPODdLyyQmSmdQiXX0+34cuE4/11hH1oB70AD1AD6gHTHCG1yY807HOnG6be8YnCxjsG3QaZDt+v8NopvElFaACVIAKJEkB3KMBz3DPduEZZ91MfJvXZjOMPEs4TEs7PDOh2kUz22TbPv5I1h/J49ttsvIvxuHjpS2b5FhDw5hh6b55smQyE2XeT4cdLYY7FsiHJkCj2bK2N6SHdnfKgguyuiId1btv7Ty5PPe56U/39QWXS8u68f31uOH1LfKpCRmZeMOjMtzQ9RNSf2rkek49xC29Qw/QA4U8EAaeYYwcdNnUyQIceNa7RwjPktRMZlmoABWgAl4FHHjWm4Vn7qQBHPcs8b+VCc8SDsvsCkoVPJvaJn1Gg3n4lQHp29QpK+deLhNzkWmXfmMDwYOhkfMjumuJXAp9rpsjc7D92K2yabCBGxhdS2RyJiMTr+kYjzIDCJs4wYkSm/3AQKgbLYCb47sLFkjn7nE9N9yUkcyHp0lLW7cMGJ+P9HbLypm5SLQL5khHHqQD1PuUTMhBvUINIH43rje1oBb0AD1AD4TzQBR4ppMF7N+xX/YQnnlbqXxHBagAFUiYAgrPcM8GPAsa90wjju3nAZ+j4Z6jldbJZjOMPCsA09qubZPFn1ostmhh3q++erXc8fk7SjrWTD/N8Mw077YV2rXzCln5bDzmN8uTpNfdLZc6UGjOmm5pm5px4MyC9oOhAFGSzqMyZRmQtTMRLZbvkw03fSjbxdKCtP75DkvnDdmos4nzOj3AtvuBlbJlZ5AHu2XJpOxxVyzfll8HvR0yBxBv0hLptiEo3+frRU2oCT1AD9ADoT1gN5a0EYUxz7Tbpkae2fDs1d+9mrCmIotDBagAFaACqgDu0fhHB+FZUBssmZ+bXAavCc8C4NmLv3rR8frbp9+WFV9eEQmCPf3g086xH5z/QNZ8bU2kY+0Kqhd4NjK0QVpyXeVm3Mfxz1zg43YtnOdERw08MFsmoHviDY/KwUZscGgUnj1GGbTQ7zLTpG1rkRvs7k6Z50Q7TpSWdUX2tXTeduflWUhnRr4Z+3S3/LHTpXTOmnARcG5dG2nws2h1Qr2oFz1ADzSCB/zgmd9kATrTJqIX0BDb3btbCM+0icotFaACVCB5CuAejXt1MXjGGTeT9XvHZjOEZz7wTMGZXnZRAJqCMz0WAO2HX/thyQCtfuBZnxNVhXGlLv12d+j/wtb7j+Xhn87LgpobctFRvWvlmgnonjhbHnqp8SYO2HATBvifKAs68sccGxnqliUfy0aFTVtVGMAOrJmT1fVj0SPE3AkwgiLcnl0pVwDM+QE+AjJe2/QAPUAP0AMleiAsPMN4Z4g8w6xthGf6i5tbKkAFqEByFTDhGe7duIfjXo5oYkwEg+hi/WcJoo7t50G9t4mTen6EZz6wzBTFBmd6CToA7f8UjkCzwZkeWw5Aq0d4Nm2FX3e4LdnZD5s/6o6Plvnw5MCZOrctvzI7+2IQ4BjKdv/DDI2X3/Gi7wD8LmDxjTAakC0PtMhsozwXTZomc5Z0Sp/vpAfjcDALdgZky6p5csWHs7BnxuodPmXQLoomLBqQjmuzM0vObttboAGyQVqcyKqMtHRmIdvA+jZpmTlZLsp9PvGjV8icJR2yzW/2yKERyYNEO7MzUF7x0dwMlZmLZPLMlqIzpQ482yF3XTNNJufONYPj/mK2zFvV7ekuWfymqNGJ2Sg8v/21i2vmsytlW2DjZEDW/l12fLRSQK3bxViBZl4+OsHDHOkI0Nav7PwsWf9JYn2wPugBeiBpHrAbS2hAaWPK7LZJeKa/sLmlAlSACqRDgVTDs33D0vnzvTL7tj0y7+dDAW3hQr8pjsnA8/tlyd27ZdrdA7L2+cMF2rgB6ZRdhoB089p53v1MToTXjDwzYFoQONNLshBACwJnemypAK1u4NnOjuxg+JmMM4Oi+YN12wNznFkM3dkOPzxZLncBThY+Tb6uwwtLnl0pn3EitAIAxivj+WWm3i87fAbgz0Y5ZSQviumVDdLy57nxtQCiPjzZAEMZyUxaIJ15g8mb8GxbbrbIbNlxXtPu9oFnvWtlNtK3BrRHNJrTdfOzK7zn7Lm4TXh2UDbc/Bn5UA6aXTRpHKA5mn54tqzd7L0RQH8Tnm3bvFZmK/y64KMy2aP/RLn8Zr+JHoZlw83jk0E40GxSbsB9lCUQbOaXxfHDsyvlchznCzNzx7hdN/PHRHM95UbvXV7C+HoKNH18Yejf/e3sOHXmLJ5u/sZ+/CygrqlR9B8N1Iya0QN174FQ8Cw306ZGnu17dZ/TFeiVra/oT05uqQAVoAJUIGEK4B6Nbpu4Z3siz/YkPfJsWNZ+b5dMuGWXZHLrxO/t90wSWKy9M/zsgEw2js/csltanj0a4ZlefhmKlTHoe8IzA5aZYhQDZ3r9+QG0x+54TL8uuD1//nzkSQTqA54Ny4abJme70VmgaNuqGblIs4tkWsujssOc/XAfor8WyOW5sdIm32QCnG5Z8v9mo4v8AEa2O+SlcqnTzW+OtL9sd4HULoDW+Fm7u6Xlk9l0J36+RTpfMBr/mI3xy9morIlfXmsBOQOezVsgV1xwhbR09BWMvNq2/ApHE3tA+xF3ZslC8Gccns2+Zo5MRH7tOzz5DTzZJnNyg9/7DXDvwrO/muPsN/m6Nuk2oeC+Pum8+coclJso9hhf47NZzpAVj3uj5IY3b5CVt3VEurFqJODld/pEJrqNRo36yojvgP5DIzLwwDU5+FgoOs2oVzftERle3+LM9JnxnW1z/BjtbltKZFvQzZmfj+tLLagFPUAPNKIHCM8K/ozml1SAClCB1CqQWni2fb98yQO+ANF2S9v28L9TNjw4Dt4UwGUefM2nV1ZAmhUoQ6m/KUxexMizHEgLC870arUB2pafbdGvim4xC6ddCYXepxqe7RuWvk0dsmTqh7PgLHORdywrzFzogLGJMuNu/66VMPrwuhzQsGZg7P42Bm73G0NNZ1qcJy035SKEfmLNXqlRTn/hBSzb7sx1Bw2K+tq5QRY4QO5SufVxE8iNw7NM5lJZ8IjfmF3mDUEhkN+A9sPSOe9DTrfUS1uCxocbh2eYmfLOp8yyGPm4Gmcc+HXMAEUuPMtkZOINHTJgfGfeYLq//als/Vnjh224KRdZd9OG8De/gDyQnw7Ub0M6syzOfjno6N91s0/apmW7vQbBNTs9931vpyxwYONEmbGqEMAzJi8I7Npp1EGBc3bz5j4R/vtEbekbeoAeqE8PEJ4V/RnNHagAFaACqVQgtfDspQB49lLY5/Ax2fADH3j2g6Hw7ceyyxC2rPn72Zym4bttRgVnerWaAO07n/6OHHj5gH4VuEXXTrsCir1PFTzLdRt0u1+a7y+4XOat8QIJF958dqW86NOtcrxxMN6VDpE+LgBa15KNWrMAmBO5BSh3TYfsXdciH5qQkYk3dXka55q3N3Jog7RMRNTZRFnQbsE2A25ol71Lv71pvCxDBjwrOB5X7qLU7ocWkHLPOVfuzAUtssHI2/0es5fm9J04r/DMnO44YTd0embwVA0A31Y+m3+zcPPS7qUZbySc6pC5rkMOFqy/Amkb56YwrujsmDpgv1+5t7bJl3ITLqw1o+iMfNzzMj/bvNaN0vNGOAaUfWubTIP+Ubummnnyteea9K0XakSN6AF6oIE8EAWeHeg/4HT9YbfNwJ/d/IIKUAEqkBgFbHiGe7gzYUDiu20eko67y+u2ObK53G6bFShDib8lbFbT0PDsxXUvBl5QfZv6pO3aNsE2aDEB2q2X3SoHtgcDNBOcPfofj8rOp3fKg3MeLArT0g7PnEH2W9Z6uwM65tXosIygm54LxAKM7YIeT3dJHWDe6nqZg2qzHxiQY7s7ZR5gysdulW437QHpuAZRU5fKki4DjrjjqC2QrgIwyC3LNe2y191vHJ55gZyRvpv/iOh4a8GRZdot1ZxMwExrHJ7N+8nBwvo9siAbOfYXXkjpnocNH41yZoHGNmn7q2yUmaeLbNeSbBfHzES5fO5K6dpaLNrOLH/+69DwzACVdhdPdyKJmQ8FRtLZkGbbA/NyXYMvktnLt3i6vtr7uu8Jz9igz7tO8j3t+oX70i/0AD0QwgP1Ds98/7lq/qO1zNdBv9f5ORWgAlQgbu2X244AACAASURBVAXSC89GZKTswfo5YYC8+eabcvbsWTlz5oycPn1aTp06JSdPnpQTJ07I8ePH5dixY3L06FE5dOiQHDx4UIaGhmT//v2yZ88e6e/vl76+vqLgyCZ9Yd6HhU2FwBmi0cy8Cu0bBqA9/cPxiLP1d653r12MgfbDf/yhJy8zX7wOez72cX7vq9WQcyFMpCiccdgEIFMMno2sa8kCoKltxlhj4wDO7OqXjbRSoKazVxpRUwBq+IFmR3Wta8mOlRX2x5tnIoLx88mbgMD+wYwxzXLjuIX6Iek7gP44PNPZNgPrV7XLtHigYPh6Cz63gZ+Oj0mHc7nos3PkrrVbZMB3RtLCcCE8PMO4ZrNdIDg+6+Y2Wfm5bJfNOT/0jsHmq82+bbJ2bm6ihQ/PlpVPDoRv3BGehdfK9j/fUzt6gB6gB3w90AjwbMmSJVKNFb9BuFABKkAFkqpAquFZAz+zbabSkJFnhWCYDc5UsELHFAJoQeBML2wHoH0tGKARnuWAiwIgDzwbER24PeOOPZWbCMAAeTqA/Iz7+rI/VnORaRNv2uD98VojeOaWOSyky8yW/C6IJcCzjy2RTW6knHe2zb6CN8VxeGZCShdI7e6TDataZIY5Qydg1KZokWhR4NmIX1dSN3Jwnjy6K2AMOD3Pnd2y5IrsjKoXzVwhW3YWBnvuuerxhGfea0d14Za60AP0AD1QsgcaBZ7pb+BKbQHjCM8qpSbToQJUoBoKEJ5FbGsl5LeEsiDdNhw8KwTBgsCZilVofDQHoH15hRNFhjHQtvx0i2AWTj3WjDizL8hCAK1+4Zl2nczItBURum1iHDMDAI280iFzzCiy3FhinsHidRysHGDTsbo8XRBxgXYtkT+ekI1IMyFTHjjxvZjHAVPhyLPx8dvsLof5+eiMoH4zS4aHZ333zchGaXm6vEaBZ93SkpvYoWV94RvfwKYOafl8dkbSYjNW2ucbWC++eo/7R7vJYsKBCZj8oMgYcCM7N0iLTgxwx2bPOHB2mQLf64QTvlGBhTUKTNP3PJkW9aIH6AF6oFE8QHhm/0IO957wLJxO3IsKUIH4FCA8S+dvGWU5um0oeFYIfmFsMxWl0LbYGGi3f/72vHQKgTO9hAHQ1nxtTd6x9QvPRmSbMWti2AkDAMW8XTwVRmXHL8vO2Gh00XSAxDZZefmEXDdNhVxzpOMV6yLW8dEy0+T+niKRS3mgQ9PNSEF4phFL1uD7QQ0DBUr5M0uOw7PL7wieqXRkSPXJH1vO7baZmSeduy0tzPPTyQ2K7eceMw793Gg/97vgfBTyFYeK2TQG1szJQkFn0gXNc6IU7sY6LN03T3aOm3xTV2ngDDPA/nSek8bEm4NmQw0+z6C65ufUjB6gB+iBxvYA4Zn+Ko62bQR4Njg4KF/60pfknnvuiSZODfYeHR2Vr371q7Jo0SJ5++23a5BjcBbnzp2T9vZ2mTp1qvzJn/yJ/OAHPwjeuYRvHnvsMSfdl156KdLRehy2XGqnALx53XXXJcKbhGfpfL7bXKhh4NmK/7Oi4JWK721x/N4XS8eJXvujb7pp/fukfy+Yr/nlcN+we5zmXc/wbLzr3USZcXcwABpe15IdmP6COdLhM4OiQqDL71wrK/8iIxmfAfC7v/3H2QkCOnKRar4RQ8PSOe9DTvTSpd/oCjdwvAuFwsEzDGjvjHPmU0bfRpM7s6Q1uYEx22bmgnnyaJ8/7HO185mZUnVDea640zsT6nhZtknb9Gz3xonzOkNqMj4WXUGQ6GqXu5kqpPOtG58bro5dBxC5aolcigjEj93q6Zo6fh6547W75wXe8d/y9rPLZr1XqOnbjdXaN2ra3N+nrqlpyd3A6Cf6iR5IjwcIz8xfxeFfVxOejY2NOQ1vgJhrr71WRkZGQhfs+eeflz/7sz9zYMu2bdtCH+e3I+GZnyrez95//3154IEHHL2/9rWvyd133y0//elPBXV42223yRe+8AWJCr28OYgoBIuajh6XVnhmaliul21Nq/me8Cw9z7+k/lZRJqPbhoFniz+1WMbOjAVenxvv3ZgHrlQkc4v9Ci2/aPlFXjpDvUOFDnG/Q1dPMy+8rmt4NjQi21bNkInO2F8XybSWR2WHGQG1b0C2PKAD0k+UGasCAI8CpqnTZFomI9qNz3MR5sY5m/ZX0xx4FQh1NrfJ306ckI1Mum6lbLBnkNw9INvWtUnLTWvFO05YGHiWi4ADrFoecC55kGCbrPxsdqZL78yc45Fnl37sUslMmiP3P24OeD8sfWtVu4xMvrk7D3y58Oxjl8qlmYlyxc2d0mfq39stK2d+2IGJmQtmyNqt3htw94oWaVu3TYatyQEGulbKDKeb5xWy8lnvMZ46sc9VJ1KwJ3Kw93PfA3Zmu4hOnpSNJru0ZZMVmWjlrzOPWmPnFSyXm5+mpXWtk1Lo59xG05F6US96gB6gB0wPEJ65P4kjvagVPANAe/LJJ0OV7Z133pHvfOc7DsjBceUCh7jh2a5du2Tp0qWyffv2vPNPSuTZ7t27HUAGPwD26GKCn6jQS9PQrUKwqOnocUmGZ5gMEOX7/ve/79EP525qWK6XVctabAnP+Iw1n7GlvLbZTN3BM+2a+dsf/zYPRCFqbOz0+M3Uvmh/cUs++DIFw/eFFjPqbNlnl8m/ffzfnDLcetmtcuDlA4UOlRc6X8grL/I+3H/YOc4PypllC/O6FMOEOcaFMMYg/WGOy+4zLN1LpsmHzcHzPzxZLjcHn89cJLOXb8mDP+N5bMtGnDlp2BFauZuGghlnn8LQA9Fan5mYBVZOlFhmony0ebJcZJYxD74oUCnQbVPHVPOJAhs/l/ybnKvvBQuM7pXj8KzloS5pac5Gh2UyF8nkSRdlo9ty5Z18XYeMz0g5nr6b7tQ22XDfbPf8Jn50snzUnA30gitkSVf+4P86wH9Wo4tkcvNHcyAU2l0ks+8LCwi1TArDJkrLOv2s8Ha4Y4GR56Vy6+P+EXiqr3vOZl0WeO0LWRXWfnalr66aF7eF6476UB96gB6gB7weIDwr+FPZ/RJwBKsutYBnV155pXz5y1+Wm2++Wd566y3NOnAL2PTXf/3XctVVV9VF5Bm6iwIC+kGjpMCzrq4up4y//vWvA+ul3C8UgvnpUChtPS7J8AyAFn5F91sTPhY6r6R/R3jmfcbwmRtdD5ux1B08wyD9WE4eOukLo0oFaFHA2fq71jtlODNyRlZ+eWVRgBYEzm6fcrt7T1qRm4zArsAo76t1wbhAoiR4ljPxC52y8obZHmh20aRpMqelTTa8UNzo2o0u44x/5bf/eFdCv26dedq8skXWtsyRaSaIAtSbOkeWrNrgjdByIpOKw7MNN2W7hOaPX+ZXXuMz7WqYmSgLOhRiGfCs85iM7OuTziVz5AqFjhd8VC6ficiw3AyjedFT+RMGDDy5VlpmjkNCR/8lHbLNHhsul9ZAV5ssuWaaVWeXy+wbVkqnHbHnk3+e5hhLLAfDwncR3ZCbzCAj0LXw2HnGORcAZlkYmIWnfvBMu97OfsCM9DPqK+S5+p0/P6OO9AA9QA80rgcIz9yfvYEvFJTdeuut7j76mftBBV8AIgAmXH311Q6wu/zyy+X3v/99wRzQfXDFihUObEMUTz1EnqUBnimgIjwraM/ALwnPAqWpyBcc8yydz3abtdQdPANw0u6ZQV0xowI0B5x9EHzdOBFnf5gd50zBme5dDKAFgTNU1L7f73OSObzrsHzTGEfNrsSw7/mDPJ0XrX+9WfCsBGBTEehZQr7+56N1o91UC0cHFk5D06rCFhGM6NbriQKsQj4V15VljM0zrEuO10YP0AMhPUB4pr+e/bcKyUxwhj31c/+jyvtU4RkG69+wYYMTTYbumOiWGbQMDw874AwADSvhWZBSlf2c8Kw8PQnPytOv2NGEZ+lsi9icpe7gGU5Qo89g4h1P7ZD7r7k/LwqtGEB77PbHnGPKAWd6EQUBND9whrHZ1s5b63bXRBqViDqDLmw8pvOi9a+3eoVnI4Jusxj8f+INYScoqF29dn/7UzIhM1GizCLqX3+1KzPzp9b0AD1AD6TDA4Rn+ss5f6uAzAZn2FO/yz+q/E9MeIYxtQDO0B1zz549vol/8MEH8otf/EIQofbKK684s2P6wbPz5887adx+++1u187m5manWyi6fCIdcwka88wcJP8//uM/8rqUnjhxQtra2pyxwFAODJqP9/g8zKIRZzjWXrXrotltE11aEZn3T//0T85kCTinlpYWOXTokG92OE+cL7rDYl/kcc0118gTTzxREFCaiSk0s8sH4AndsOA8zPfm8ZghFDN0olsu0vjc5z4ny5Yt8y2z5qXnbqYDoIpyX3/99e6547zgFT0O2ygLyoZjNE2UD10rV69eLYcPZ4f2MdMzuymiLkxtMXkF6mXr1q0C/+mi0MzWD+/NLpyq4f79+/VQd4v0ent75ZZbbnH0Ux3xHp+b+elBmh7yhz+gObTXcsJH9nWAY9944w358Y9/7PhEJ+QI8oypR9wzwRKepeM5bP9eagh4hpPEmGf2gsH3zQguB6AVmETAPt5+XyjizN7XBGgo3/f/9/fzgJ59DCLoAO/sSiv1vW0Gvk/nRZytt/qFZyNDw7LhG5dKJjNZWtZpN9UE1NWzK+XKCRNk4pfv51hnIaMoeI9JgG9ZV/zHET2QGg8Qntm/hLPvFY5h67fo937flfuZCc/QyNcZNH/0ox/5NuwxGydm5dSx0RQ+2YOsA74oYFi8eLEzSyRABQASAIK9P/IG/EF6ugCcPfzwww5sQBoY8N1cAC1wDNK86aabnDz+9V//1dl/5syZcuBA4fGYkdbTTz/tHAd4g/JCa8xoifW1115zslN4Bkj285//XKZMmSJ33HGHU9a///u/d44DmBoa8k6ghvL/5Cc/ccoDqHfnnXd6jsEMmdC/2IJJDFCeBQsWOHlhi/cPPfSQOzuqCWrM9HAO1113nQts7rvvPgcYQTO/2TkVgtnwDKAKEypAI/NcAHVQB4C++C4KPEPZvvKVr7j6oQswyqdgEvnYXYgVFqEu4I2//Mu/dOseHoG3UA7oA/2xwLPQ6q677nKgL7wBOId91q9fL++++66zn2powzOc+/e+9z0nXaSvftb8ALgefPBBNz/VX9PDJBwzZswQeBN5qkdRB1u2bNHdna2enwI26AFdpk6d6uRv56P749oiPONv0lLaJTZ3qcvIMz3Jtmvb3NkqccXZ8Az7lQrQTHD2y5Zfei7soDcAaEualwTCMD0O0KxvU5+gC6qeSyW2pRiGxyT1RlPP8GxERnZukJZJGcl8bIF09SWgDlCeT06QzKSWZJSHjeHUNIZ5D03A9cvrhddLSjxAeKa/hMe3CsaCwBn21H3Gj6rcKxuenT17VhYuXOgAsmPHjuVlBBCAhv1TTz3lfAdAAFhhw7AdO3Y4IMXu/rlz50754he/6EThKLRAQjY8Q0QOQAzyAigBJDAXdB0FBAG02rt3r/sVjuvp6XEgCqLe7PzdHa0Xeh42NMJuyPurX/2qfPrTn5Z//ud/ltdff909Gunfe++9jgYAjuYCjVB+G/zhmPvvv9/5buPGjeYhBV8r2PIb80xBDXTU5fTp0/L1r3/d0QKamFFO0AzazZ8/X7CfLpqHqQOOW7t2rXOOq1atknPnzunuTsQVuvsqtAoLz5An8sZxON6M3EJ+yB9QDnWMutZFYRE8BMhmgy5Eq82ZM8eNjNTjsIU2hSYMUA3NNM1z/+53v5sHcAHmAG5Rz3ZdIj18Dgho6o80n332Wec7HAs4pwt0gdZ25CQ+x75/+7d/64nIUz0Iz/hbrNTf4zaDqWt4Zp4sIBlW8zN9HRWgmeAMafzul7/Ta7rotu0rbb5lQDqAfZUGZnqO2JZqGh6XxBtOncOzlDR0eG0k8dpgmehLeoAeSKcHGg2eAXqFgWKF9sEP71rCM+QHQAYghsgec1HgAYCE11gUOtnwzDzOfA1QAAiAaKiTJ0+6X5nwTOECwAr2tUECDgKoApjYvHmzm4a+AJxC91MbNOj3fls9DxMa6X4Kz9BV9eWXX9aP3S26u2K2UrML4JkzZxw4NGvWLA9s04N03Dh05TMhon7vt1WwFRaebdq0yalHdLOFpuaC99AQ5wTQqYvmYeoAIAUtzXrX/bFFhFdra6uTV1h4pmULinBEuvCf7UOFRSj3737n3z7V6EmMx6fRZ0ivFHhW7NyRLkAkYJ5GY+IzLOopP/31Ovibv/mbUBGSSK+jo8PRw6wb1YPwLJ3PxCT8ljFZCl43DDyzT9x+Hxag2eAM6Xxv6vfkxHDxsQP8xjizy1HN90kwIMtQqZsX4Rm9VCkvMR16iR6gB+iBJHigEeEZZrguNI5ZMXCGRnOt4RmiadCdDrDk1KlTDgjAH4USJlRTQOAHzxBNBGABGIf9ECmEyB8AkULwDF31AM4QmYSy2IuCB3S1NAGcuZ8faDC/t1/reZhgQvdReDZv3jwXGup32ALuoSsrIuS06xyAGiKO0D3QBlc4Rs/B1sFM136tYCsMPAM0Wr58uRO9ZUZSmWkCPKIuTOCleZg6oD6wHzQNWvQ4M62gfbVsAI7QKWhRoIqx7jSCUGERostMb5ppaH3YUV2lwDPVqNC5a/SmDcLgKRtOajnhibvvvjvwe4x7hmg1wEVAOXQPBixGPZh1o3oQnvEZX+oz3mYzhGe5WTIhTDGA5gfOVFAHoB0MBmhxgzOUs1TT8DjecOgBeoAeoAfoAXqAHqiuBxoNnqGhrODLBGj6WRhwZqahDe9KbrXhjy5ygAtY0LBH1zE01nVMJo3mQlc/sxudQicbnmE8q6997WtOYx8NfkCzf/mXfxF0+0NXPBsaKSgBJEBZAEf8wBnKp8AA6RZbTdBQSDc9D7/9FZ4FAQotD84Jr7EgncmTJxctn61DoTIqoAoDz7Rei+mD703gpXmYOuhnflF+Wl7dx0xLv7O3Wrarr75a/LoG6/6qqwnB9LOgusCxuo9ZH/i8FHim51Xo3JE2/GPDQHxmXld6Xrr18xygKsY4U1AGiAxIjM90zDuzbvRcC+mh+VV7ywkDqvv8rNbvE2U9uiU8M+AZRAkCaIXAmYoZBNCSAM5QxmqZiumm82bAemO90QP0AD1AD9ADyfFAI8IzNFgVlgGg6euw4Mw8vhqNXwUZdiMfgGz69OlO90eAs1dffdWJBsNYXWZXOAUAJjxD5A+i1pBmd3e3Z4wszc+GRgrPEGXzj//4j05eiFjzi9pSYGAO/I6B2P1WHfS/mHZ6HiaY0GOQH8Y8CwIUWh4T1ig808H9/cqGzzALJoBJmEVBThR4hplTEeEUlD8+x4QEumgepg76mT14vx6Dre6DbbFFPYBoPb8uuXq86mpG9OlnQXWBY3UfAFjtXozPy4Fnhc4dacM/GNTfjPLDZ/Z1peemxwBeqta4rjAhAMAZ6gXRZ+aiGuv++E7PtZAeZhrVfE14lpxnbZTfPcp5dEt4ZsEzCGMDNAec/dE3A8cqUzGxtQFaUsAZyhbFKNw3nRc46431Rg/QA/QAPUAPpNMDjQrP0GBVaIZunFHAmXlsNRq+CjLsRj4a8hgzCvBl165d7mtzcH6UR6GTCc8AYwAA0OXMXnQssCB4hvR0FkZE3TzzzDN5AA1poAulDUfsvKK81/MwwYQeD0ARFZ5hHLHPfOYzzsQAmk65W4UnYeAZxlHDeGroShgWIKJ8moepQ1dXlxNBt27dusBTwHd2FFvQzlo2O1LL3l+BqjkunMIiRKPZs6/q8Xqc2d0T35UCz3RstjDdNu0x9qLCM4A+eBrehsftBdeTCdvwvepBeJbOZ2ISfsuYnAevCc984BmEAUDD7JyP3fFYKGhmCtt6Vav0dffJsz96NvKxZjqVfp0EA7IMvHnRA/QAPUAP0AP0AD2Q74FGhmdo6AKaRQVnehygWzWWIHiGvF555RUHAAFCYOB7DMKvY09pWRQ6mfBMAQy29gIQh8HVC8EzHIMIHnQRBUDDWGtmBJqCPYwnhTJWYtHzMKGRplsKPDPHjTOjnzTNUraqaxh4hvR1wP0nnngidHaah6mDToiAWVgxG6u96AytYeEZjtdJKQpNGKBlwb66KCwC1O3v79eP3S18ggH6URZzbD7sUAo804kdgiZLMNO1r4+o8EyhH0AYrktzMTU260b1IDzLf97wGRxOE5vHEJ4FwDNbqHp4z4sk3EVCnagTPUAP0AP0AD1AD9TaA40Oz8zGcJTXGrUW5Ziw+xaCZzrOGUAEIskAsexFoZMJzzTyDN3tzC6Jr7/+utOd89Of/nRReIZ8EL2lAM2eWVG7kSJS58CBA55iAaDs3LlTHnnkEc/nhd4oqLGBC44pBZ6hDBg3Dtqh26ROJKBlgLbI05zpUr8L2moZw8IzgJ+/+7u/czQEZDQBJPI4dOiQ/PjHP/aAGs3DBDTqEXgA+5sAFa/RlRcgMwo80669gKMbNmwQTC6hC8qJ/BENCWhldu1UWIS8EH1mjouH4zDIPtL0m+VU6xHdRc3jNF+FXWbXS+1Kify++93v5kW7IR2UA3ma1wDS1PQAxfwWvXZUa408w3nv27fPPcTWWPfHDqoH4Rmf56U+z20GRHhGeMbunEO8oZR6Q+Fx9A49QA/QA/QAPVAZDxCeue3hSC/igmcopM6wGRR1pADABAcAZohWA3AA/MJg54sXL3YAA15jXLNikWcqkM68CThhjjsFUALQA6CDFTN53nfffU5e//AP/+DkDagTdkF3VEQzNTc3O2Ob3XHHHW5Um0KXIEChAMMc8wz5mjqg/NAAY1lBG8zEiXL39vaGLaLbpTIsPEPCqh/q4pprrnGADuoMg9Ajf7trox88QzoAShhjzqxT1CXqF7Oi4rzwHY4Pu/ilibKhnEgL+ZkgC+mq1vAQ8lddUffwAM4J2ppe0fJoxCLSxsQUgJrwiEZ5IW+AKztP1OPSpUudMml+OF9AM/gF629+85s8OKnphYVnpqc1H9UY4wCqxoRnlXke8bme1ZHwrIFgmV3ZvAh4M6EH6AF6gB6gB+gBeiCZHiA802Z8tG2c8AzRMIj+MbvOmaUHIACMMOEZvj916pS0tbU5IAPfA4ggDXQ/A4QKC8/MaCIbiuA7dAO95ZZbHIiCfAAdvv71r8tzzz3niZAyy+z3WvMBVEE6gEJIG0up8AzHImoI3SYVViFtzDx6++23O9FFyDfsomArCjxD2ogwQ37QD/kD9mAmVKRnR8RpHiag0fIhAsysU2iECQ+Qhh6HbZQF2iKaTYEn4Be0+uUvf5lXNqSr8AwegsfWr1/v1BXOC+eH88T5Bi04prW11YVemP0VY7BhUdhlwzN8h3qEpwAKoZ/WI+BWUH6aXlh4hnwA+HCdKEDEOUFzlFs1NuvG1MOuS+ekaviHEwYk87lb7PeQzVMYedZAMK2YOfh9Oi9q1hvrjR6gB+gBeoAeSL8HGgWeAXZVeq3WmGc1bFszKypQtgJJgkVln0ydJUB4ls5nNOFZA8Eyu7L5wzqdFy3rjfVGD9AD9AA9QA/UvwcaAZ4BclVrrbO2Nk+HCkRWgPAssmQ1O4DwLJ3PcJunMPKsgWAaf3in86JlvbHe6AF6gB6gB+iB+vdAvcOzmrVSmREVaFAFCM+SW/GEZ+l8hhOeNRAssyubP7zTedGy3lhv9AA9QA/QA/RA/XuA8Cy5DV+WjAqkQQHCs+TWEuFZOp/hNk9h5FkDwTT+8E7nRct6Y73RA/QAPUAP0AP17wHCs+Q2fFkyKpAGBQjPkltLhGfpfIYTnjUQLLMrmz+803nRst5Yb/QAPUAP0AP0QP17gPAsuQ1flowKpEEBwrPk1hLhWTqf4TZPYeRZA8E0/vBO50XLemO90QP0AD1AD9AD9e8BwrPkNnxZMipABahAOQoQnqXzGU541kCwzK5s/vBO50XLemO90QP0AD1AD9AD9e8BwrNymqY8lgpQASqQXAUIz9L5DLd5CiPPGgim8Yd3Oi9a1hvrjR6gB+gBeoAeqH8PEJ4lt+HLklEBKkAFylGA8Cydz3DCswaCZXZl84d3Oi9a1hvrjR6gB+gBeoAeqH8PEJ6V0zTlsVSAClCB5CpAeJbOZ7jNUxh51kAwjT+803nRst5Yb/QAPUAP0AP0QP17gPAsuQ1flowKUAEqUI4ChGfpfIYTnjUQLLMrmz+803nRst5Yb/QAPUAP0AP0QP17gPCsnKYpj6UCVIAKJFcBwrN0PsNtnsLIswaCafzhnc6LlvXGeqMH6AF6gB6gB+rfA4RnyW34smRUgApQgXIUIDxL5zOc8KyBYJld2fzhnc6LlvXGeqMH6AF6gB6gB+rfA4Rn5TRNeSwVoAJUILkKEJ6l8xlu8xRGnjUQTOMP73RetKw31hs9QA/QA/QAPVD/HiA8S27DlyWjAlSACpSjAOFZOp/hhGcNBMvsyuYP73RetKw31hs9QA/QA/QAPVD/HiA8K6dpymOpABWgAslVgPAsnc9wm6cw8qyBYBp/eKfzomW9sd7oAXqAHqAH6IH69wDhWXIbviwZFaACVKAcBQjP0vkMJzxrIFhmVzZ/eKfzomW9sd7oAXqAHqAH6IH69wDhWTlNUx5LBagAFUiuAoRn6XyG2zyFkWcNBNP4wzudFy3rjfVGD9AD9AA9QA/UvwcIz5Lb8GXJqAAVoALlKEB4ls5nOOFZA8Eyu7L5wzudFy3rjfVGD9AD9AA9QA/UvwcIz8ppmvJYKkAFqEByFSA8S+cz3OYpiYo8S67dWTIqQAWoABWgAlSAClABKlA9BT744AMx1/Pnz8v777/vrO+99568++67cu7cORkbG5O33npLzp49K6dOnZLjx4/LoUOHqlcwpkwFqAAVoAJlKYB7NO7VuGfj3o17OO7luKfj3o57vN7vce83nwV4zSUeBQjP4tGduVIBKkAFqAAVJyxcjQAAIABJREFUoAJUgApQgUAF7MYS4VmgVPyCClABKpAqBQjPUlVdbmEJz1wp+IIKUAEqQAWoABWgAlSACiRDAcKzZNQDS0EFqAAVqLQChGeVVrQ26RGe1UZn5kIFqAAVoAJUgApQASpABUIrQHgWWiruSAWoABVIlQKEZ6mqLrewhGeuFHxBBagAFaACVIAKUAEqQAWSoQDhWTLqgaWgAlSAClRaAcKzSitam/QIz2qjM3OhAlSAClABKkAFqAAVoAKhFSA8Cy0Vd6QCVIAKpEoBwrNUVZdbWMIzVwq+oAJUgApQASpABagAFaACyVCgXHg2MjIiXKkBPUAP0APJ8wDhWTKes1FLQXgWVTHuTwWoABWgAlSAClABKkAFqqwA4VnyGryEEKwTeoAeqIQHCM+q/ACtUvKEZ1USlslSASpABagAFaACVIAKUIFSFSgXnpWaL4+jAlSAClCB6ipAeFZdfauVOuFZtZRlulSAClABKkAFqAAVoAJUoEQFCM9KFI6HUQEqQAUSrgDhWcIrKKB4hGcBwvBjKkAFqAAVoAJUgApQASoQlwKEZ3Epz3ypABWgAtVVgPCsuvpWK3XCs2opy3SpABWgAlSAClABKkAFqECJChCelSgcD6MCVIAKJFwBwrOEV1BA8QjPAoThx1SAClABKkAFqAAVoAJUIC4FCM/iUp75UgEqQAWqqwDhWXX1rVbqhGfVUpbpUgEqQAWoABWgAlSAClCBEhUgPCtROB5GBagAFUi4AoRnCa+ggOIRngUIw4+pABWgAlSAClABKkAFqEBcChCexaU886UCVIAKVFcBwrPq6lut1AnPqqUs06UCVIAKUAEqQAWoABWgAiUqQHhWonA8jApQASqQcAUIzxJeQQHFIzwLEIYfV1+BBx54QLhSA3ognR6o/h2COVABKkAFGlsBwrPGrn+ePRWgAvWrAOFZOuuW8Cyd9VYXpSY0SSc0Yb2x3uABLlSAClABKlBdBQjPqqsvU6cCVIAKxKUA4VlcypeXL+FZefrx6DIUUAhTRhI8lApQgRorEPd1q/lzS4hLD9AD9e6BtrY2sdf7779fdL3vvvtk9erVcu+998o999wjq1atkpUrV0pra6vcddddNX46MDsqQAWoABUIqwDhWVilkrUf4Vmy6qOhSqM/ehvqpHmyVCDlCsR93Wr+3BKc0AP0QL17wAZneK/gDFvCs5Q/UFl8KkAFGlYBwrN0Vj3hWTrrrS5KrT966+JkeBJUoEEUiPu6jTv/BqlmniYVoAIJUIDdNhNQCSwCFaACVKAKChCeVUHUGiRJeFYDkZmFvwJsBPvrwk+pQJIViPu6jTv/JNcNy0YFqEB9KUB4Vl/1ybOhAlSACqgChGeqRLq2hGcJqK8PRGTLyeOy6rW9ckPfNvn8C8/KH27+L/lf3b+W//bkI86K1/gM32Ef7ItjcGxaFzaC01pzLHcjKxD3dRt3/o1c9zx3KkAFaqsA4Vlt9WZuVIAKUIFaKZBEeHb+/Hl599135Z133pGxsTF5++235a233vKs+AzfYR/si2MaaSE8i6m2R999Vx4c3i9XvbRZ/vvGTpnwxMMlrf9jY6dc9dIWJy2kmaaFjeA01RbLSgWyCsR93cadP31ABagAFaiVAoRntVKa+VABKkAFaqtAUuDZ+++/L+fOnfMAMhuYhXmPNJBWvS+EZzWu4d+dOiHX73ihJFAWBrAhbeSRhoWN4DTUEstIBbwKxH3dxp2/Vw2+owJUgApUTwHCs+ppy5SpABWgAnEqECc8w7MFUWN+kWVhQFmhfZAm0kYe9bgQntWoVrefGZWZL/dUDZrZYA15Ic8kL2wEJ7l2WDYq4K9A3Ndt3Pn7q8JPqQAVoAKVV4DwrPKaMkUqQAWoQBIUiAueAWwVgl+V/A551dtCeFaDGm3Z82rNoJkN0W7Z82pix0VjI7gG5mMWVKDCCsR93cadf4XlZHJUgApQgUAFCM8CpeEXVIAKUIFUK1BreIYuldWINCsG25BnPXXnJDyr4mWH7pOTe56KDZwpSPuTnqdkawK7crIRXEXzMWkqUCUF4r5u486/SrIyWSpABahAngKEZ3mS8AMqQAWoQF0oUEt4hsH9i0Guan+PMtTDQnhWpVp86NCQ/EGJkwAo9Kr09keHhqp0tqUly0ZwabrxKCoQpwJxX7dx5x+n9sybClCBxlKA8Kyx6ptnSwWoQOMoUAt4hmcIZsasNhgLmz7KgjKleSE8q0Lt3b6/P/ZosyDwhrIlZWEjOCk1wXJQgfAKxH3dxp1/eKW4JxWgAlSgPAUIz8rTj0dTASpQvwoMDw/Lc889J52dnYLfhqtWrXJWvMZn+A77JHWpNjw7f/58LN00i4E0dONE2dK6EJ5VuOYWD/QlFpwpUEMZk7CwEZyEWmAZqEA0BeK+buPOP5pa3JsKUAEqULoChGela8cjqQAVqD8Fzp07J9u3b5e1a9e6sEyhWdAW++IYHJukpZrwLKngTMFamgEa4VkFr6IkR5wpONNtEiLQ2AiuoPmYFBWokQJxX7dx518jmZkNFaACVMDp3mICNDSIMPAy1vfee08wkxkahNot5+zZs3Lq1Ck5fvy4oGHGhQpQASpQLwr09/d7Isza29vld7/7XV50Ge6JiDjDd9hHoRp+PyKNpCzVgmd4ZsQxMYCCsbBblBFlTdtCeFahGlszPJj4iDMFZ7pFmeNc2AiOU33mTQVKUyDu6zbu/EtTjUdRASpABaIrYIIzvG40eLZr1y656667ZMmSJZ4Vn+E7LlSACtS/AoBhGzdudCHYo48+mgfMCqkAkIZjFKIhrSREoVULnuk/U8JCrDj3Q1nTthCeVaDGtpw8njpwpgANZY9rYSM4LuWZLxUoXYG4r9u48y9dOR5JBagAFYimQKPDM3S3WrlypTzzzDOeFZ/hOy5UgArUtwKAXB0dHS74QjRZqQuOVYCGNOMGaNWAZ0mYVTMqjEvbLJyEZ6Vegbnj3v/gA/n4lidTC89QdpxDHAsbwXGozjypQHkKxH3dxp1/eerxaCpABahAeAUIz9b6QjKAM8Kz8D7inlQgrQpoxFlbW1ukaLOg80UUGtICREPacS6Vhmfozh8VXCVlf5Q9LQvhWZk19a+7tqcWnGn0Gc4hjoWN4DhUZ55UoDwF4r5u486/PPV4NBWgAlQgvAKNAs8AwuyumaW+J1QL7y/uSQWSrADGJ9NIsUrOmom0NN04x0CrNDxLwzhnQbAOZU/LQnhWRk39NsXdNRWc6RbnUuslLY3gox0zZMKEjCzbWmuFmB8VSJ4CcV+3ceefvBphiagAFahXBRoFnmEmvF/96lcOQMPW7qZZ7L15LNKqx6Wnp8fpvrZz5856PD2eExXwKIAulfi9B8hVTldNT6LGG+3CiTzi6r5ZSXiGyWOCwFRaPsc5pGEhPCujlr7w4nOpjzpTeIZzqfVS/UbwUWmfmZFMpsA6s12O5k587MVWmdKUkYuv73Q/w1dxwLPRgW5pXz5fpn/uEmnS8n+kWaZcv1DWbBiU0VpXFvOjAjkFqn/dFpY67vwLl47fUgEqQAUqp0CjwDMoNjQ05MAzbKMu5RwbNS9ESPzmN79xQBbGTTLXX/ziF/LrX/9aNm/e7Mx4GjXtQvsTnhVSh9/VmwKA4ABnGOg/zDIyMiKdnZ3OitdhFp1EIC7gXil4hudEWgBZsXLiXJK+EJ6VWEMbjh+pG3CmAA3nVMul+o1ghWdNcsnnpsiUK33WBV0uKEsEPDvbL+0LpniBmZb74005EDhd2odrWVPevMaGe6R96SyZ+7BiR+/3NXs3dlR6OpbJrH/0ws6a5d+gGVX/ui0sbNz5B5XuaMd05/q8rSf5D/6gc0jG5z2ybMIEycz8mXtvTka5ipdibFenLLs69w+PprnSWeAWiX/K4B87jGgurmsj70F4Fq7244JnjzzyiNO4RyMc6y9/+UsXpv385z+Xp59+WirVHamS8GxgYEC6urokzi5r4WqWezWqAg899JADz8J21zS7YkY9Jq6u3pWCZ/UQdaZQLQ3RZ4RnJd6Vrnppc93Bsy+9tFlq2eyrfiNY4Vl5sKlmkWdne2TZZdkouebrV0v3sM/0vcf7pWv5MumMEZ5po296R4GWYYnXVaTDhttlOqLyjOjBSMdz55IUqP51W7hY1c9f7xt2xCog/FxZ1tEjR9/LLyPhWb4mpX2SUng21C6zL5wgmaZLZNbNrbLoxoXOfdr8p8wR4wGr99H6gmdj0rv883Jh5mKZ21nbf8aV5rXkH9Xo8AwRIRoVEvQatRgHPAMoe+211/JM9Oabb8pLL70kDz/8sAPSHn/8ccFn5S6VhGdPPfWUUzZ2AS23Vnh8NRRQENbe3h46eXS9xHFYo3TDjArpQhcoxI6VgmdpHutMoZluK/XPhhDyl7wL4VkJ0u1+84z8wRMPVxSefe6FZ2TJQF/R9f+r8gQFu948U4IipR1Su0ZwGuDZoLRfi8iyJpn1YL/4YLPSRK7CUdroIzyrgrgpSLL6121hEaqfv8IzK2LV7EJ92TLpOestJ+GZV4/S38UFz0alf91qmf/FVokePDgm3d+aIBMyk2TZi94zJzzz6sF30RRodHiGiBCNCgl6DUWTBM+0htF1bN26dQ6kAvgqdyE8K1dBHp8WBXQ8smqMdWZr8Nxzz1VtXDU7L/t9JeBZmmfYVGBmb5M+8ybhme3kEO+X7ttZUXCGbpO37tspp957V549MRK4vnwmO9LV2kNDFYd32nXzO/tqNxBp7RrByYdno+vnO101Jy3uSTQ4w+VBeBbiJlHHu1T/ui0sXvXzV3jmc98YOypdLc1Od7umG7s8Yw8SnhWut/DfxgXPemSZM77kMnneiBALV+5eWYaos8xtEraJrPfR+oo8C6cW9wqvAOFZeuEZanlwcNDpyomxmE6cOBG+4n32JDzzEYUf1aUCGFMQ452F7X5Zjgj79u2LNLZaOXnZx1YCniHKzoZPaX8fJXLQ1rQW7wnPSlD5T3ueqgo8AzgrFNGG6DQsgGzVAmif6nmqZl03Y20E+9W7dgNc6m3+oJFTaLbNo0+vlvlX6cD+TXLJVfNl9dNRujQOypovoovYXOksY9LTo1vbZdn1U+SSplx3s6ZLZMr1y6R9q39Z0NjHeTljNI32S+fSudL8keyxF182V5at80bAqQ5+EzDkRaG9d1S675kvU3WctqZLZOqNq6XbryjD7TIDYxx953n5QBD9sUzmXnZxdny3jzTL3KWd0m9G+ej+OpGCuWUXTj9nV/Sz6l+3hYtb/fwLwDOnaP2y+kpcJ7M8Y1oRnhWut/DfphGe5cpMeBa+mrlnKAUIz9INzxBB8cQTTzjRZ7t27cqr8zfeeEM2bdokmGgAEw9gi/f43F4KwbPz58/Lq6++6ka6IS1EveEzfKeLdtc0JznQ13YXTjTAEZWj3U8xhtuGDRsEDX4uVKCaCuhA/lHgGYALvIk1CnxBHlEmJqjkeVcCnqUdlAWVv5I6VzotwrOIih45N1YQcGkEV9QtIs/CwrNPPr9RRqsI0A6fq02nwfgbwVblR4Zng9L1jVwUysenyvzFrdK6eL5MdQBUk0xZ3hsuiuxop8wqa+yu8XJgvJ2pNy6S1uUYc2dqDqQ1yZQ78iPaXHjW9bwsu2yCXPzF+bIod9zFDpBqkukPDboijW5dk0332kkO2Jp0bTYf5LVmqzH/51CXfL0ZURhZkOhJs2mKtL5o+Uth2Hcel+eXNkvmI7aWGWn68hpxSzLaI2uWt0pryyyZhHJ+YpZTbpSj9aEeTzSQW3i+qJgC1b9uCxe1+vkXg2civXdkJ+8wo4YIzwrXW/hvCc/Ca8U9610BwrN0wzP4E13PAKjsrpsYrB/jpgFKPfbYYw40w0yd2BcTERw8eNBj7yB4hvHUFNABdOE1Vp28AJMWaDcojMUGOIdIOOSD8djwHuuBAwfc/PAaAAP7AMLhe0QDoawAfDZocw/kCypQAQUAs7BGWRSClRKxVkp+UcoWtG+58AxgPAg+pf1zE/oH6RfX54RnEZV/9PXh2OEZotMmGQAtKqgrtv8jr9dmNPokNII91R8RnvWuyIKz5qUWsHlPxy9rltbtnhz832xdlu0Gdkev//dFPnXL8Y1O2f+utfNor7RelR1Lbf56A3A53S+zkWdNTRfLrB/v9x64a7VMdQDaQum2WJd2N8qLNnNS6JVWZ9KDZrnttye9aQ61yyxExV3WKp4zVXjW1CQXX/szGTQHY3+vX1Y7UXkZWbjRKojWF6PNvDpX+V31r9vCJ1D9/IvDs8GfZGfWjALPIkWoYmKQe+bLdGOcNY0G9V7FOa1ykZ7TNWIT4BqTGzztP2i7f1n89y1UG046M5slC9sz0vTxKTJ3abfvLJmjOzpl2fXj+wafTxF4ZkXJZjQ61VeYXOmPYobguTJFI2EzF0vzzPmy2oH+2l0zF7Hr3Pf0dbFumBpxpvsbW41g1vvU0h5PVLfeR00PmVr715Ff6K55lP/r0YEuWX3jdDeyOKPnv2HQ958NCoKdso32yupZH3OGFWi6/lHfujVz1Qhle9bZnqXQJtsV2pmVVL2ACRaWbxqfhGO0V9YY//hBJPeaFwMqNzfj8twrx33VhH9k3dMtR8zniFlAjW52r62Lpfn6Vtl0pPiQBJWsE0+RCrwhPEs/PANoAoQCxNIFjWYAMsCu/fvHf3+hvl955RUHUiHKy4yg8YNn2P+ZZ55x0gfgMvc/c+aMA8cAvHbv3q1ZO1uNQPODYKOjo/KrX/3KKQPKgjx0QVlRZnyP/bhQgWooUArMKhWe4ZopJb9KnHe58KyeZtm0YV+SZ90kPIvo/kV7d1S8yyZgVpTIM3Tf/OwLzwgmD8AjDV04iwGxKN//+94dnh/5ESUKvXvtGsFGg8bTMMqIp+FiNHLMk9DGgGff0S6Zj7S+aEREmQdtb3Wioiat8GAic4/x1zl45g+jxnfzfaXl+IQFpMydB9ZkQZhVVo08a7p5k7w9/tsod+SYdN8M3ZryBsDWRp9feTF2G7p1Tv3Bfl8P9S5H1NokL1R04dlC2XQmryAytnGhP1zU+iI8M2u76q+rf90WPoXq518Mnum1MUXWDIyXVYGDDQ1ExiNDnYa9HaH63Zfk7fFkRERhznjk5nhEa0aab7f2d2fpbZJLrl6YizrNgZKl6AptLlHLYh5rvh6TnqV/LhMyAGazZCGiPhfPlyy8W2aN+zUmvSumyYW4XwJ03dwqrcsXyqwcyLr4+k4LyATDs7HtrTLV6ZYO4JE914VX57rMf2Su7yzEg+vnS7Nz3x/X043KdQDXoHSh/Mvn5/5hMFXmfxfvsXaNR7yap+++9jnWOa5VWtfnYmX1PhUanhWpo7ARzU4Zof1UB3w5wCynWevNRhf96x/NO0f18rLNvdLqRBHnnqEzf2bVlSuE+0Kfl/Z1oPBsdccyac7NSGr62hlDcLhT5n4k40ZBu3WbaZbbXvBeJSJ6nWYEINbxoOGrpmsfFXN202wB9R9bXi86wwQ0zZLbFmeheP6zrZJ14koV6gXhWf3AMwArXQDSANR0JlH9HFs05ru6uhy4dvjwYfcrP3iG7wHhELkGWGYv6CoKeGaCO+xTCJ5t27bNKdvmzZs94AzHwY9IC2nu2bPHzo7vqUBFFCil22ap8EyPQ561XsqFZ++8807dRp7h3JK6EJ5FrJkZ25+vKKhSqBUFnvkVGUBN0yp3O3273eDyy7H8z2rXCLZmzbtyikzJravNmdGMRo55dtoYMOGZAp38H9m5I8e6ZSEabGHATg6eTXnQ7ZhoZl/wtZaj8LHayMgfowljns1/7KTVwM5mqdE1+RFrMxyYlX/uChWmy88OepvsehJaXs+xCs9ufFxO+h021C7ToaU1QLtofYXRWAvAbdkKVP+6LVzE6uev14vPhAEomvrRB0YDHNvQwI0MDYhQnZBplu/1msbvldUL2qXf/qc+ojCnYkbH+fK4caEMPjjFuR7nPmxHJY1K/y7vZwXL8pULJb8sAXUxsEY+j3EKfSKRRnf0ewDL6Pqvy4UTMtJkR5XKqPSgm3amSbz3mAB4drxL5gOcNc2S9iFvuUY3L3MAmT2Jw9iL2c8zl82XRwdNjUVktF/WrDP/uaHQspQJAzQCzSdSTe9TIeGZWUee2N2oEc04xdxENE1XtUpvnp8GpfNfsgC02fonj8KzudfPleZvtMtOT0G82tvv9HlpXwdZeNYkTR+x6g/w1wF0k6T5siZBJLcZYzzYMSsL//KeD0elc2mrzziao9L1LXh5knVdibjatnTnRdwN/mS241Ncw57nkxjHLe0RjxQl1ImtV7H3hGfph2c7duxwYNTzzz/vVPfZs2cd2FVoEoHf/va3zjFmZJgfPHv55Zed/fCd33Ls2DEHrqHL5dtvjwPoIHimY7Shy+drr73ml6QUy9P3IH5IBSIooBMGYDD/sItCsKjdNtM8YcDY2FjdwjOcW1IXwrOINYPxxsqFU37Hh4FnfsfhMyyVhGfoEmo1MyKqFG732BvBdjGNRo75lTYGTHimjQu/wfM9n4UBOwNrZArg0M3dnkaDWYag11qOvC6N1gHZhkt+pIw7YYC1P95q2nZDAnr4NTDMSACPBk7Uhzf6z5OmwjNnwgCfgmi92FoGfe6TBD+qnALVv24Ll7X6+QfAs7FR6d/QKtOdMQ2bZdlW74NdrxcPNNDIUAu0uWe4vVU+OSEjk77/Uqh77uCDnx+f5COXSPbatqI53QyMFxHKYhzl/3LrMqccKHfhpVdaJ02QTJN/VKkc75S5eWDcH571rkDUalN+922nAKPSeT3uMfOly4VEOhHLVE+EYHB5EwDPQtQRxnkMFdEsvdL6CWhSYCKasW75NmYJbVrk6Z6vXkYX+5ci/hjQ56XnOkA8pdNtMyNTjXE0tS70mZL5xDLp8V5WTiTmInik6bbQZRnb+E3Hn9Pbj4xfV6ptYJT2mHR/68L8Z5seV+AaDl8nesbht4Rn6YdnCsIAnbCcPHnSHXMM0WeF1mLwTIFaoTTwXVh4BsCGfYulh++DgF14d3NPKuCvAMYJBATDNuxSKjzDpBhR8wpbpmL7lRt5huvV7u5YL+9N2F9Mx1p/T3gWUfH/+5n1dQ/PLnxm/fgPzoj6RNk9tkZwUCEVxuhYNbn9tDHgB8+m3qjdewK2YQawH+uWRU5EhbcBE1RM83Nt5CzabH6a/zrbcJnuidjAsdWBZ2a3J39dPBMMEJ7lV1iCP6n+dVv45Kufv8IzL/B1gXDTFFm00SU0bmH1WjShARrx/qA5d9hYt3wTEVwzf5bfxex4v/Q83elMjrHw+ikyxR2jyRvdNh5dtEy6h/PIg1s+36hP91sRMcrijVczd8q9Pt4lX3egy1RZ9vTRYOifi1BrCgLjMihrnJlLza6efvAst1+TuZ+3XBqB596n9X5+fWdelJH3SH0XPzwLU0ehI5pD/lOmZymAkbd7vnoZEc0R2Zno89K8DqCw3z9wVHnJRV9nFvtFzwxK+5czMiFzmzzvV5ixo9L7dJe034NJcqbLFGP8Mw8827zIuRYLRWkrxDP/uVPROnFPOPwLwrN0wzMM5r9+/XpPF0yFZ+huiQgwjFUWtJqD+Cso8wNq5sD/fmlt3bpVzG5QQZFnCs8wKcDGjRsDy4U8/GYPDe9s7kkFghVQEAZIG3bRY6JGnj300EMOPIsS5Ra2TMX2KxeeVQqUDQ4OyvLly50Vr/3SRTTqv/3bvzlaodz2PvgM2mMf7Gt/X8r7YvrF9T3hWUTl/+fGzrqHZ//Xxs7IP5gjyujsXrtGcED3K7vQ2tgKAc90bK9ZeV2l7ETDvB+T7pbs7H3TfxKt66aWo1CDYDwizIzKyEaWVRaejUrXjQAOs+TR/MFmgoUgPAvWJoHfVP+6LXzS1c9f4Zm3u/f0GxfJ6o4eORrApxQ4mNBAG+MuePOJwnS+88CzQelaMCU3ThUibi6RKVdOd2bzXZSb6dbMQ2RUuheP749Zc1f7DASv5QtTlqLwDF0CN35bPn9hDjBihtx7umTQZoq5CLWieWZMKOYHzxRsBQBNQ1cXnkXuDq95xNdtM3wdtXu6xvpeMSHPXz1qRi9rOfBPGT9e5Ztf7sPC8CzgWazwzHr2ZpPMXo/58GxMeu+Z7k5W4YzpduWU7Jh6N07NQmsj8kzPyTxP+zxUCxOe6XFFPWxHRtuJl/ie8Czd8AxjmgEAPPnkk+6Ml6dPn3YG3Ee3zSiD7vvBMx2fLEqEDqwYBM8A2DBRARq/9myfJVqYh1GBkhRQqAUoFmYpBZ7pMcgrjiUp8Azg7Fvf+paz4rUNul599VX3e+znB8fwmaaBLY6x04n6Po46CZMn4VkYlYx9MNNlUPfJcj5PUrdNnEfUH8yGRKFf1q4RHPCD3S5pBHgmOgh/6KgGOzPr/XBndibKTH53MGtP71vt9hTYFUXEHRvMKisaBZWFZyKDD2UbLXM7/cdR8xY+947wzFeWpH5Y/eu28JlXP3+FZyHvG7niaiPbBFvaGA8foTomvXdkxwGbekeX9B/3ahEEJpy9nBklZ8klzoD6mNV2vjxujPOl5QtfFm/evu/eOyo9Hcvcwf8zmWaZrwPl4wDt3nntotwA/P6RqN6B+QvAs0/MkkU6IH/AtksnccgBmfD/kEgOPKtIHYU8f/WoGb2sXnFBpG/l+38Y5FE3+tmvHVQCPDv6cHYstOZvrJEeO+Iy5zsz8izMOakWfvCsInXiL1nBTwnP0gvP+vv7nUYmIszQSNYF44oBpmHQ/SjRW37wDLNfIkoMEwyYM21qXkHbIHiG/TFRAIDfCy+8EHQ4P6cCVVcA4BmRTIDMYZaRkRHBoP9Y8TrMohMT+E3cEeb4cvchPHurIGArV99qHU94FlFZwrOIghXYPXGN4CjwTBBlhWixJpn1YH9+t6D3jkr38mVWVmWdAAAgAElEQVS+s78FSTL48Nzcf9EvlunLu30jXMaO90uXJ11tbGek+Rudsv9dK/XRXmm9CuVslmUvekNm0JgoBZ5pF5umFp8x2oxBvX/4qmdo5WzBjnZL61Jrdr1S4ZnOSmiN12MpwLcVVqD6123hAlc//8rBMwyWj4iV8BGqvbIM8CsAhveu+KQzw6UJ6PLUem9Ueh+clR38/LJ7ZWfuPyEapRq+LHkpF/xgdPsa9x8Aq3fkds2N6dZ0e7gx3bJH+cGz3PhdTcvEHOK/YIFyMx6HH0syfnhW0ToKef7ZbpveMfPCgKYg7WsDz45K57WIQvRGU2uZcN3h2eaBZw/PykajFYjuHvxJ/nieFa0TLWCEbaPDMzRqtWEb9BpyDg0NyZIlS5xtBHlL2lW7NiLSwh5UH/WFhnt3d7cDx7APIJq97N692/keYMCOrEEae/fulS1btngO84NnAGaIFAPsAvSyARoiPTDmmh1FpmnhGHtBgx7A7+GHHxaUE+UxF3z/7LPPeiYgML/naypQCQXg5ba2NgegRY2sDJO/jqsGQGdfN2GOr8Q+SYFn7LYZrTYJz6LpJey2GVGwArsnrhEcCZ6JCGYJu0y7LTVnu4ssbxWMT5SN/vDObllACvcrzBo3VSNHMhm5+LLxmUGbnYHKkZ8dETMonddf7DQM0MVr6o3ZKI+F1ze7MG7uw/ndQUuGZzpGW6ZJLrl6obQuni8L14139Brbukz+fEJWl4svmysLnQiRhTJXx2y6tlLwbLy7a9PHZ8nC5Ytk/s1W2q6yfFEpBap/3RYuafXzrxw8ixyhqvcg3y5gg7LGmW3TO+aZv1qD0j4dM3MaM99WOlrWJ2OdodeN3NEB6T/xvdCDvQugeG4cOOOukuva7oU8PkUwPurJgshCA+Ybezv5Ot0/4+u2GdkvnvLbb8JMGNAjyzChgwVrkw/PxkFn/ihp2YH/J2DWTKPbpihMDBr4H+PvTZ2QBWwd486rbJ3YdVT8faPDs+IKZfeIA54BWAEyabQLtogCw+dY161blwfG9HxQrxiHzNwX44g98cQTTpr4HO/NRYGXOeYZvgesQ144Bvn/13/9l3PsY4895gI8G55pxBqi3zBBAAAcQJkumCEU3yFNnBci1bAC9uEzjLGW5Nnw9Dy4TbcCAM+AW1htyFzOmekMm0jXD26Xk3aUY8uFZ5wwIIralduX8CyilpwwIKJgBXZPXCNYG67WuCv6n3TfLiyIMLtnvky/LAevcsBr7tJ26TF+fxeQIf+rMXSFapX5MxXCAURh/KXpMn95e34XFSeFURncsFrmz1RglpGmj2P8lzXSHVCOkuEZxhbf1S4Lv5g75480y6IN1mBHR7tl9Y3TZRz4XSzNV86VZRgz6j3rlEuOPAPA7Jf2m6e6kLC5pSs/CtDKjm/LU6D6123h8lU//wrCs8gRqrnIMwDyIVOHUelZ2iwXNmXHRhyPPBuV3s29MmpfU9Ivq78wQSY0LZJNb2vUwGjFomVHt/dIr9WlFKXtv3+Kc69a9PR4lGvvij93ouWaWx7Pv/ZlVPo7FsrqF81z9YNnIoAfzYBbly2SLp972uiOdll4vzcuTbv2NV3VKi/ZgbCj/bLmYXN/rfep8sO9qplZrkKvc2XO3CZ5MMd4rpipahdB73PFW0d2kSViRLN5/r3WLVreG5TOf0HdNOVFRiYfnmnk2SRZtHnca6ihwZ/Mkv/nwtwYoiY8E63fJpm6otd6TuD6+nP3+nLhr1Plla2TQi7y+47wzE+V/M/igmcASeYKmIYumYBT58+fzy+o8QnqdmBgwJlQQEEVtr/61a+kt7c3LxomCJ4hSUSYYdZA5K/lQeQYgNeRI0eMXLMvkfcrr7zi7o99URZzQcMeUE2BIMoGeAboh/y4UIFaKICJKwC58NuvEgAN4AxpIU2kHedSLjwDwI46jlha9k8ynCc8i3jVfPL5jXU/5tmk5zfWyZhnESuXu1MBKlBUgerDq8JFqH7+2si2IzwLl0uBwzjYyu0fIkLVnGBjsCM7lpMbRbp4vkz9eJNkLlsmP7vf7mqdKysmFbh+YXZcsZvn5qB1k8xq3++9l0csS9AZZ/+hAKBvRJbm/oHQdG27eONcB6X9Kxc6AM09p+XZmRGzcN0706N/5Fm2JK42+GfCVfOz458tHv/nRdMdJgzDMWPSc4dOpnCxNM/MHrPoxhxwt/5RomM2ZjABwuJWWXh1a8huopWCZ5WOaLbOP+cRnH82OrpJptz+fN5sqeplL9gLcoP3c/1nk30dVHrMM0Q4OzA1c7E0O+e1UObCg02z5Gc/XpTXbdMp5VCnzM1FcDd9PFvHrbnrpelztznXF7pZe+FZpevEq1exd40EzzB4PrpeAtagW2CUFcfg2CgD8BfTnt9TASoQvwLoUtne3u5GoJXThdPsqok04+quqaqWC88wwUdaYFjUcpqzA6teSdkSnkWsiRnbn697eDZ9+/PeBldEjcLuXv1GcNiScD8qQAXCKhD3dVv9/CsMzyBspAjVMelftywLAhBp9ZFmmbu0U/rPYobcGdY4hWNydCMiTo0o1Y80y/QbW6Vzhx1qlKvhSGXxd8XYcDaydAqgntPVMQumWtf5jP/oJDGaPSftup3JRsZOv3G1dA3Y5QyIPMsVZXRHpyxzu8bnZiOd6T/DqJb+6NZ2zzFOVK5vdPCo9CyfJR9zus4D0P1Q8kcr0lTNbQXhGZKtQB2ZpbPPH54q5JE0wDOc3+jm1TL/qkuyM9M6Qxaslh5ERPpMGODqMdovnUsVMMOHmCm2W468l72+fOFZFerELU+RF40EzyAFxjW78847HRAGGBZ2xTE6NloRSfk1FaACKVMAkEsj0BAx5jdWYKFTQsQajsGxGnEWNzhDecuFZ++++27dwjOcW1IXwrOINbNo7466h2f/vncH4VlEX3B3KtAoClQfXhVWMu78C5eO31IBKpBWBbQrbbUm1ShFl0aDZ6VoxGOoABVoDAUwPplOIgAItnbtWqe7MiCUCcPwGp+hKzP2UWiGY+Mc48yupXLhGbqGR43oSsv+xbq921rW8j3hWUS1H319WKox4+at+3bKsydGSkobp/C5F56pGNR75HW/ueQjChVidzaCQ4jEXahAwhSI+7qNO/+EVQeLQwWoQEUUwEQDmDAgyqQUFcm4YCKEZwXl4ZdUgAo0mAIAY4gyfeihh1wopnAsaIt90WXTBGxJkK1ceIZzSAsMi1rOJNRPUBkIz4KUCfj8yLmxkgDXhCceLgi3kgTPDp/zDsAbIEXZH7MRXLaETIAK1FyBuK/buPOvueDMkApQgeorcLxTvoZZXpuW5U/6UP3cA3MgPAuUhl9QASrQ4AqgOyaiyzAjrA3O8Bm+wwQBSV0qAc8ABKOCqaTvnzTIafuH8MxWJMT7P+15qiAIKwbK/L5PCjz7VM9TNemyCZnZCA5hNu5CBRKmQNzXbdz5J6w6WBwqQAVCKtB7/0Jp326PsScix3uk9X9f6IzfN/0n3ukuQiZdtd0Iz6omLROmAlSACsSqQCXg2fvvv1938AznlOSF8KyE2lm6b2dV4Nnoe+/KMydGIq84hUp12/zOvp0lKFLaIWwEl6Ybj6ICcSoQ93Ubd/5xas+8qQAVKF2B7Iyf2ckq5t7cKq3LF8n8mc1ysTPpRUaaWzaJD1orPcMKHEl4VgERmQQVoAJUIIEKVAKe4bTefvvtugFoOJekL4RnJdTQ7jfPVLzrJuDXkn07S14vfq6rIkBv15tnSlCktEPYCC5NNx5FBeJUIO7rNu7849SeeVMBKlCGAsd7pXP5fJluzPqKmUenXL9M2rceLSPh6h1KeFY9bZkyFaACVCBOBSoFz+pp1s0kz7KpXiE8UyUibq96aXNFYJVfF864PvvSS5tr1mUTcrMRHNF03J0KJECBuK/buPNPQBWwCFSACjSIAoRnDVLRPE0qQAUaToFKwTM8J5I+jlnY8uFckr4QnpVYQxuOH6k7eIZzquXCRnAt1WZeVKAyCsR93cadf2VUZCpUgApQgeIKEJ4V14h7UAEqQAXSqECl4BnOvR6iz9IQdQatCc/KuNq+8OJzdQPQcC61XtgIrrXizI8KlK9A3Ndt3PmXryBToAJUgAqEU4DwLJxO3IsKUAEqkDYFKgnPcO5pHvssDWOdqb8Iz1SJEra/PXm8buAZzqXWCxvBtVac+VGB8hWI+7qNO//yFWQKVIAKUIFwChCehdOJe1EBKkAF0qZApeFZmmfeTPoMm6a3CM9MNUp4/a+7tqceoOEc4ljYCI5DdeZJBcpTIO7rNu78y1OPR1MBKkAFwitAeBZeK+5JBagAFUiTApWGZzj3d955J3Xjn6HMaVoIz8qsrfc/+EA+vuXJ1AI0lB3nEMfCRnAcqjNPKlCeAnFft3HnX556PJoKUAEqEF4BwrPwWnFPKkAFqECaFKgGPMP5j42NpQagoaxpWwjPKlBjW1LcfRNlj2thIzgu5ZkvFShdgbiv27jzL105HkkFqAAViKYA4Vk0vbg3FaACVCAtClQLnuG5kYbxz1BGlDVtC+FZhWpszfBg6qLPUOY4FzaC41SfeVOB0hSI+7qNO//SVONRVIAKUIHoCkSBZ2iInD17Vk6dOiXHjx8XNMy4UAEqQAWoQDIVsOEZ7uGIxDp37pwze+Z7770nGAsM6/nz5x3QZD4TCp0V9k8yQEPZUMY0LoRnFay12/f3pwagoaxxL2wEx10DzJ8KRFcg7us27vyjK8YjqAAVoAKlKWA2lPAajQ1tTKFh9e677zoNLTS4CM9K05hHUQEqQAXiUKCa8Aznk1SAlmZwBl0Jzyp8tSwe6Es8QEMZk7CwEZyEWmAZqEA0BeK+buPOP5pa3JsKUAEqULoChGela8cjqQAVoAJJVqDa8AznjmdIksZAQ1lQpjQvhGdVqL0kR6AlIeJMJWcjWJXglgqkR4G4r9u4809PTbGkVIAKpF2BMPAMM5WZkWenT592um0ePnw47afP8lMBKkAF6lYB3KPRxR73bHS5R0QW7uW4pyOquJxum7ZoSZiFM22zatoa6nvCM1WiwtuHDg3JHzzxcKKi0H50aKjCZ1lecmwEl6cfj6YCcSgQ93Ubd/5xaM48qQAVaEwFCM8as9551lSACtS/ArWEZ1ATXf4B6N56662arsgTedfLQnhWxZr83akTMrnnqdgB2p/0PCVbT52o4pmWljQbwaXpxqOoQJwKxH3dxp1/nNozbypABRpLgbDwDANMo4Hy5ptvOlEMiGZg5FljeYVnSwWoQLoUMOEZ7t24h+NeXo3IM1MZRLXVCqAhr3pbCM9qUKMte16NDaDdsudVSWrPYjaCa2A+ZkEFKqxA3Ndt3PlXWE4mRwWoABUIVMAPnumkATphABpaNjw7ceIE4VmgqvyCClABKhC/AoBnuFej22YheIZ7Plb7eVDOGSAtgK1qRKIhTaSNPOpxITyrUa1uPzMqM1/uqRlEQ17IM8kLG8FJrh2WjQr4KxD3dav5c/uAUANqQA/Utwfa2trEb73//vsF63333SerV6921nvvvVdWrVold999t3z/+9+X5cuX+9/E+SkVoAJUgArErsDRo0djg2fmyaNLJf4BU240GtKop+6Zpkbma8IzU40avEZXzut3vFA1iIa0kUcaFv3Rn4aysoxUgApkFYj7utX8ua1vaMD6Zf3SAw/4gjPAtLDwDI0hLlSAClABKpAsBRCV9frrrzvw7MyZM07kGSYL8Ou2WY3IsyA1kBeixhDRrBPR2FANkWXmxAY4ppEWwrOYanv03XflweH9ctVLm+W/b+wsGab9j42dctVLW5y0kGaaFv4wZuOIHkivB9J0r2FZqQAVoAJpVMDupqONKPx3X7ttoqGDBpc2dDBr2+joqBw7dkzQKONCBagAFaACyVIA92bco3GvNmfaxL0c93SsOtum3vft50GyzqhxSkN4loC6Ro/gLSePy6rX9soNfdvk8y88K3+4+b/kf3X/Wv7bk484K17jM3yHfbAvjklzb2KCk/SCE9Yd6y4Bt04WgQpQASpQ9wqYDSZtRAGemQDNjBLA2DmnTp2SN954Q9AtCK+RBhcqQAWoABWIVwHci3FPxr0Z92i81vHOzGguBWe4z+t933wWxHsWjZ074Vlj1z/PngpQASpABagAFaACVCChCpgNJrxGQ8oPniFiAd1p0BBDVMPJkydlZGREjhw5IgcPHpShoSHZv3+/7N27V/bs2eOsu3fvll27djlrf3+/6Lpz507hSg3oAXqAHijuAb1vYqv3U9xb9T6Ley7uvbgH416MezLuzbhHa5dN3Lv9umwqPLOfAwl9XDVEsQjPGqKaeZJUgApQASpABagAFaACaVPAbjRpFIIdeWZ33cQMbmicHT9+3IlywMxuw8PDcuDAAXnttdechhwac4ODg86Kxh3Wffv2caUG9AA9QA9E8IDeP/V+insrVtxrcc/FvRf3YESc4Z6MezPu0XaXTUQRs8tmsp/ShGfJrh+WjgpQASpABagAFaACVKBBFSgGz3TsMzS6NPoMAzyjUaYADd2DEOmAMXYwSDUacGjIYT106JDTsEPjDisiI7hSA3qAHqAHwntA75/Y4p6q91fca3HPxb0X92Dci01whnu1X9SZdtvUf5bYz4EGfRwm4rQJzxJRDSwEFaACVIAKUAEqQAWoABXwKmA3mrQxFdR1UycOQKMMXYIA0DCuDhpsJ06ccBpviHxAQ06BmkI1NPJ0RaOPKzWgB+gBeiDYA3q/1C3upQrKcH/FvRbADPde3INxL8Y9GfdmBWe4Zxfqsol7vv0c8D4l+K6WChCe1VJt5kUFqAAVoAJUgApQASpABSIoYDecTICmkWfo6qPRZwrQMP4ZItDQUEOjDTO7oQFngjQ07NDA01WhGrdZuEgdqAM9QA8U84DePxWWmcAM91vce3EPxr0Y92RzkgATnLHLZoQHY0y7Ep7FJDyzpQJUgApQASpABagAFaACxRQoBM/8xj4zu2+aAM2MRENjzoRpCtQQIWGvaAhypQb0AD1AD2SjyOx7pEaW6T8n9P5qRpqZ4EyjznCvNuGZdtfUiQIYdVbs6Vj77wnPaq85c6QCVIAKUAEqQAWoABWgAqEU+P/bu8PXuM57T+B5v//DZd/dP0B9o4IvhkCgL3yhxLBEyy3xvllvIeotxDXE9EXDQtaFIvzC5EXwheJdiDA0NpdWhWxedHF6U+VuHffalhzHcqJYtV0rsT1x0orr7W95ZuaZOTo6Z2Ykz1ia0acwzGg0OnPO5/l2zHzzPOeUy7P0c3n2WZ6BVp59ls6nk76o1ZVo6ctdnpWWv/Dl+/xF0H1rth4HDjIgAzkD+XOyeJ8/T/uVZulzuWq5Zi7P8ud71Wf/QP9oeNHIBJRnI6O1YQIECBAgQIAAAQJPJ1D1BSp/uSqf+6y4fDPNaMhLOHOBVi7R8my0dB6efCt+AfS4VS5y4CADMlCVgfy5me/TZ2q+5SWa6XM3zzbLpVlxxllxuWavWWfp3wL/210B5dnu+nt3AgQIECBAgAABAj0FhlGg5Vlo5SItfcHLt/ylz333CzALFjIgA70ykD8/830qy3Jhlkuz4mwzxVnPf+729C+VZ3t6eOwcAQIECBAgQIAAgdhyxbVUqPWbgZaXcRZnoaUvccUirVim5S997ltffjlwkAEZGDQD6bM03/LnbFVplj6X02wzM87G71925dn4jZk9JkCAAAECBAgQ2GcCvWafpRKtuIQznwMtL+Msl2hp6VBe0ln8kld+nL8Iuu9+KWbBQgb2dwbKn5Pln/Pna3mJZrk0y+c4Ky7VTJ/lVZ/1++yfuz17uMqzPTs0dowAAQIECBAgQIBAV6DqS1WefdarQCuWaMUiLc1Iy7PSil/4PG6Vixw4yIAMDJqB/Hma79Nnbb7lmWZ5tpnirPvv2jg9Up6N02jZVwIECBAgQIAAgX0tMGiBlmYzpC9o+Vb88lYu0/IXvKpiLX8RdN8qGjlwkAEZyBkofnYWH5c/b/PncLE0M+Ns/P4pV56N35jZYwIECBAgQIAAgX0sUFWgpeeqZqGVS7T05a38xc7PrfMPceAgAzIwrAwUC7Ptlmbp89z/9p6A8mzvjYk9IkCAAAECBAgQINBTYJACrbiUM5Vo+Vb+Uufn7gw9FixkQAaGkYH8eVu8L/4HjvS47nO854e/X+6agPJs1+i9MQECBAgQIECAAIGdC9R98UrPl7+k1RVpxS92HncLRhYsZEAGhpGBqs/iXp/dO/8XwV+OWkB5Nmph2ydAgAABAgQIECAwIoFeX8LqSrTyl7lhfEG0DUWDDMjAfs5A+XO16ud+n9cj+mfCZockoDwbEqTNECBAgAABAgQIENgNgX5fyIq/r/pC57n/VzlTjwsXGZCBp8lA8bO33+Pd+LfDe25PQHm2PS+vJkCAAAECBAgQILDnBPp9MfP7v9aeX4gNGxmQgd3MwJ77B8UOVQoozypZPEmAAAECBAgQIEBg/AR28wug91ZAyIAMyMDgGRi/f2H29x4rz/b3+Dt6AgQIECBAgACBCRbwRXbwL7KsWMmADIwyAxP8T82+ODTl2b4YZgdJgAABAgQIECBAoCUwyi+Htq18kAEZkIG/+udmAgWUZxM4qA6JAAECBAgQIECAAAECBAgQIEBgOALKs+E42goBAgQIECBAgAABAgQIECBAgMAECijPJnBQHRIBAgQIECBAgAABAgQIECBAgMBwBJRnw3G0FQIECBAgQIAAAQIECBAgQIAAgQkUUJ5N4KA6JAIECBAgQIAAAQIECBAgQIAAgeEIKM+G42grBAgQIECAAAECBAgQIECAAAECEyigPJvAQXVIBAgQIECAAAECBAgQIECAAAECwxFQng3H0VYIECBAgAABAgQIECBAgAABAgQmUEB5NoGD6pAIECBAgAABAgQIECBAgAABAgSGI6A8G46jrRAgQIAAAQIECBAgQIAAAQIECEyggPJsAgfVIREgQIAAAQIECBAgQIAAAQIECAxHQHk2HEdbIUCAAAECBAgQIECAAAECBAgQmEAB5dkEDqpDIkCAAAECBAgQIECAAAECBAgQGI6A8mw4jrZCgAABAgQIECBAgAABAgQIECAwgQLKswkcVIdEgAABAgQIECBAgAABAgQIECAwHAHl2XAcbYUAAQIECBAgQIAAAQIECBAgQGACBZRnEzioDokAAQIECBAgQIAAAQIECBAgQGA4Asqz4TjaCgECBAgQIECAAAECBAgQIECAwAQKKM8iYnl52Y2BDMiADMiADMiADMiADMiADMiADMiADIxRBp5VT6c8U575YBijDwZFr6JbBmRABmRABmRABmRABmRABmRABloZUJ797avPysD7ECBAgAABAgQIECBAgAABAgQIEKgUMPOsksWTBAgQIECAAAECBAgQIECAAAECBCKUZ1JAgAABAgQIECBAgAABAgQIECBAoEZAeVYD42kCBAgQIECAAAECBAgQIECAAAECyjMZIECAAAECBAgQIECAAAECBAgQIFAjoDyrgfE0AQIECBAgQIAAAQIECBAgQIAAAeWZDBAgQIAAAQIECBAgQIAAAQIECBCoEVCe1cB4mgABAgQIECBAgAABAgQIECBAgIDyTAYIECBAgAABAgQIECBAgAABAgQI1Agoz2pgPE2AAAECBAgQIECAAAECBAgQIEBAeSYDBAgQIECAAAECBAgQIECAAAECBGoElGc1MJ4mQIAAAQIECBAgQIAAAQIECBAgoDyTAQIECBAgQIAAAQIECBAgQIAAAQI1AsqzGhhPEyBAgAABAgQIECBAgAABAgQIEFCeyQABAgQIECBAgAABAgQIECBAgACBGgHlWQ2MpwkQIECAAAECBAgQIECAAAECBAgoz2SAAAECBAgQIECAAAECBAgQIECAQI2A8qwGxtMECBAgQIAAAQIECBAgQIAAAQIElGcyQIAAAQIECBAgQIAAAQIECBAgQKBGQHlWA+NpAgQIECBAgAABAgQIECBAgAABAsozGSBAgAABAgQIECBAgAABAgQIECBQI6A8q4HxNAECBAgQIECAAAECBAgQIECAAAHlmQwQIECAAAECBAgQIECAAAECBAgQqBFQntXAeJoAAQIECBAgQIAAAQIECBAgQICA8kwGCBAgQIAAAQIECBAgQIAAAQIECNQIKM9qYDxNgAABAgQIECBAgAABAgQIECBAQHkmAwQIECBAgAABAgQIECBAgAABAgRqBJRnNTCeJkCAAAECBAgQIECAAAECBAgQIKA8kwECBAgQIECAAAECBAgQIECAAAECNQLKsxoYTxMgQIAAAQIECBAgQIAAAQIECBBQnskAAQIECBAgQIAAAQIECBAgQIAAgRoB5VkNjKcJECBAgAABAgQIECBAgAABAgQIKM9kgAABAgQIECBAgAABAgQIECBAgECNgPKsBsbTBAgQIECAAAECBAgQIECAAAECBJRnMkCAAAECBAgQIECAAAECBAgQIECgRkB5VgPjaQIECBAgQIAAAQIECBAgQIAAAQLKMxkgQIAAAQIECBAgQIAAAQIECBAgUCOgPKuB8TQBAgQIECBAgAABAgQIECBAgAAB5ZkMECBAgAABAgQIECBAgAABAgQIEKgRUJ7VwHiaAAECBAgQIECAAAECBAgQIECAgPJMBggQIECAAAECBAgQIECAAAECBAjUCCjPamA8TYAAAQIECBAgQIAAAQIECBAgQEB5JgMECBAgQIAAAQIECBAgQIAAAQIEagSUZzUwniZAgAABAgQIECBAgAABAgQIECCgPJMBAgQIECBAgAABAgQIECBAgAABAjUCyrMaGE8TIECAAAECBAgQIECAAAECBAgQUJ7JAAECBAgQIECAAAECBAgQIECAAIEaAeVZDYynCRAgQIAAAQIECBAgQIAAAV70/goAACAASURBVAIECCjPZIAAAQIECBAgQIAAAQIECBAgQIBAjYDyrAbG0wQIECBAgAABAgQIECBAgAABAgSUZzJAgAABAgQIECBAgAABAgQIECBAoEZAeVYD42kCBAgQIECAAAECBAgQIECAAAECyjMZIECAAAECBAgQIECAAAECBAgQIFAjoDyrgdlrT/+n/xXx3PHW7W/eiPj80V7bQ/tDgAABAgQIECBAgAABAgQIEJg8AeXZmIyp8mxMBspuEiBAgAABAgQIECBAgAABAhMloDwbk+FUnpUH6nLMTU3FVLqd+ij+Wv71dn6+NNfaztRUzF3azh96LQECBAgQIECAAAECBAgQIDDpAsqzMRnhcSrPNt4/2Smjpn+6GBsjMVae7ZR149LpmDkwFdMvvR7/++5Ot+LvCBAgQIAAAQIECBAgQIDA/hBQno3JOI9PedaIhePtGWFpVtiBk7E4kvZMebaz6K7H+Ve64zN7/v7Tzdrb2U74KwIECBAgQIAAAQIECBAgMDYCyrMxGaqxKc/unY/ZvJyyfX/i3cYIChrl2U6ju+9nnj1YiYvnTsbsawuxvlNEf0eAAAECBAgQIECAAAEC+0ZAeTYmQz0u5dnauSOtJZsHjsWxH7ZnOB1fiEdPdVKyqkFSnlWpeK6/wOVT7Vy+cl551p/LKwgQIECAAAECBAgQILDvBZRnYxKB8SjPVmL+H1rFRDrX2XIu0qZm4527w27PlGdjEt09t5vKsz03JHaIAAECBAgQIECAAAECe1pAebanh6e7c2NRnl09E4eaSzWnW1etXJ2PI+2lm0fO3R7y0k3lWTcdHm1HQHm2HS2vJUCAAAECBAgQIECAAAHl2ZhkYBzKs+W3DrWWbB46E8tPEmzh5PSHzsTSUCefKc/GJLp7bjeVZ3tuSOwQAQIECBAgQIAAAQIE9rSA8mxPD0935/Z8ebaxGCcPtJZsHnprubPjjV8faxVqU4fizJVttGeN1kndj730Qky3Z68dfPFonPj5xVhppM0PXp41bl2M+TeOxcx3ptv7cjAOf/9EnP3NSjRSyXdprv38VGvGXGfvt/ngyUasXTofZ9N7vXiws82p5w/H0R+fjoXrzR2v3mhnH2bj/L3WS9J+n/3x0Tj8fPscXc3tnI3F9u+rNzTAs4X3qlpOu35htr3vc3G5vbn1S+dj7tWZeKE9xtPfmYljpxZiucchrV/4QXyrOXbd7Ww5pgMvxMyrJ2P+gx6n7u/sb//xqdr3dAhpX6baOaq9f+WduL+NiA4g7SUECBAgQIAAAQIECBAgMAECyrNdHMRiIfbc8YhR3P7mjYjPH43+IDc+ONkuuQ7FmeuF93uwEMfapcX0qY8GWrq5/v5c/Oe/axdGVYXH88diYW0x5vLv6rb7ZD0u/mymU75VlSYHjy/E2odDKM8aizE38+0+Bc10zF5YK+AUHnYKolZ5tnbhWBzMx7fl/nDMXdoo/PE2Hxbeq2959qQRi2/2MDwwG+drDmlzebYRK+d6HdNUHDz+q7j97xXH0tlf5VmFjqcIECBAgAABAgQIECBAYMQCyrMRA/fa/OSUZ41477V22fUP87Gy6aA34uIbU60ZSAdOxu/+sumXW37YuDQXh3NZ9PzRmLuwGCv3GtF40IjG6nIs/PxEzKTZTy8f6ZxPbaqyPNuIy6cOd8qsg9+fi/MfrMR62s6DRqxdXYizr7VKoSMvt68QOtW/nNmyw/mJe+fjB9+aiqnnj8bJcwtx+dZ6a58frMfKb87E0Tx7bOpIzK/mPyrcdwqi2Tj7dioip2Pmv8/HYt5OOvY3j3SLwAMnY3Gn/VnhvfqVZ/NvJ5uDcfSthVhebdmt31qM+Z90badeno+q/qxYnp3/5WzrmF47GwtX17o2H8zH6y/lGYFTcfjUR7HlsDr723986maexUY7Qw8acfGn7az+1/lYbuehma/GlncuDJCHBAgQIECAAAECBAgQILBfBZRnuzjyE1OeFWaXHTm3tUZJs9K+nYqlqak4ebFHe7ZxOeYOtYuNF+fid3Uz5lbPx2x7+WBzNllFeZZKuNbFC1Ihs9hanlkx1mu/SKVO+z2fqjx7L85eWK59n7jVvXjCoX9a3joDr1AQTU3Vz1BL+5tn0B37dY81kxXH2nmq817VV0HtFlDJpW6W20Ys/qx9jru0JPdqZ+udB93ybDqmD0zH7C+2ZqP54idrcf6Hedbe4c0zF9MLOvv7FOVZZ68inPOsgOEhAQIECBAgQIAAAQIECPQVUJ71JRrdC07/NuJ784Pd/uP/6C7r/A8/jjj8Pwf7u3/854gvvxndMaQtr537L+1Cp3u+rk3vmM6H9nffar3m+K/iUc15pbqlzZGYX6l5UXvD3XOpTcXWmWeFCxW8PB8rzYsXbNqjwg+NWDg+hPKssMXqh4V9+uHC1nNrFQqiqeMLUVuLbVyMk7nse+Pi1lla1W+++dnOe/Uvz4rnr9u8kYhUCM6092Xm7c3zDdNru+XZVEz329cHC/GjdsE6fSqfaa39jp39VZ5tGQNPECBAgAABAgQIECBAgMDIBZRnIycezhsUZ6k9q/OYDbbnazF/JBdj9aXP5VPfbp88vrqw2XRlzuMLtQVbZ58a78WJXCKVZ57dOx+z7d8NMjur8e6JzmyuuUuddxj6g+KMpy0npi8URCff77V8sFDCvXI+epxmv37/O+9VPRbdEnMm5m/Vb2bzRRtKhdem8qx6ZtrmLaflvd9qZaS89Lezv8qzzWZ+IkCAAAECBAgQIECAAIFnIaA8exbKQ3iPPVueXT8Tf9+eMdSzqLrafd2Rc7e3ijzpXgDg6C/Wti5r3PIXPa622bkAwNHak9lv2tw2yplNf1fzw0ZjPVYuLcbir+fj9JtzceL7M5uvvvnK+R4zz/rvc7GEG215NheLPWftFYq88myxTeXZybjYqw9sO6794r9tuTpn81fbGJ9u8de9wmd5mJ7ar7xBPxMgQIAAAQIECBAgQIDARAsoz8ZkePdqebb81t+3C4/u0sd8Tq7a+/LMojQGhdliJ95tPFV51i1QTsR7tesfCwO/jXKm8FdbHq5/cCZmv9M9+X3t8fcsz2qWvhbe7anLn87x9pt5Vl9AtXZn0PKs33baW7vwA+VZYZw9JECAAAECBAgQIECAAIG9IaA82xvj0Hcv9mR59uRyzOVzmeUllAPdVyzjK5Rncx/25YjNSwY/2lS2dcuzfjOn2u/TKZP6Lwus3rPWlT2/lY/9+cNx9MdzcfrcQix+sNi6SmVjIxZPtQtG5VklY/ccaaWybRvjUxz7rQtJW2/71OVj5d57kgABAgQIECBAgAABAgQmVUB5NiYjuxfLs+5VNKfjxNuLzaIolUW1t3dPx5F2wbTlRPTrC53zlM1eWN9UhlUOUWGZZ/mCAeu/zFek7D+Lq7ntzjLPHZZnV8+0r+w5HbNvL8WjmqWOxdKm/pxn/fe5uJ1RL9usK6BaYzLcmWeXT7XPeXboTCwXB71wYYJ+56RTnhXhPCZAgAABAgQIECBAgACBYQgoz4ah+Ay2sffKs8IJ3g+cjMUBzmkVUbi4wJa/uRynD7RnZr1xMf7Sz7RQqJTLs/jD6Zhul3S9T77fepOVt2ee6oIBl99sL9U8dCaW/r1uxxvx3mv7deZZ/0IwYiXmv9e+8ET5ypyFWYn9lvQu/iwvHy7NXisMy1OXj4VteUiAAAECBAgQIECAAAECky+gPBuTMd5z5dmDhfhR+0IB0z/9XQzUnUVE49c/6pwjbXOxtRGLP83nCzsWv/ryrz1GZiMWf3aoU3htKc82FuNkLuKO118BtPkGXy/G3KFcuOxs5lm3jHln64UA8lE8WIhjeVnnvlu2ORVH3l7JEpX3Gx/OdS48kQqyTf/buBgn23bTP12sL1a/vtgd9ynl2SZDPxAgQIAAAQIECBAgQIDAjgWUZzume7Z/uNfKs8avj7VLsOmY+32voqvkVCjdpsrFVmf541RM//CduF0zi2vt3dfjcC6i0v2pzec8S++4/FYu16Zj9hdrpZ1o//hkLd77yeFuCTe1w/Iszzybqin9nqzF+R/mYnAqpvZheTZ14EicuVpTsa5fjJOH27POXjwTy1uWvTZi4XguOGfjndsVeXvSiMVTxbEcoDybGuwqoNXh8SwBAgQIECBAgAABAgQI7BcB5dmYjPTeKs/WYv7ldpnRc6liFW5ruWfrSpTHYuFB8TWtE+/nq1ROv3Qizv5mJdYfNKLxoBHrty7G2ddmmksyj7w9H3O5QKsoz+LryzH3Yi5cpmPmtbNx8dZ6czuNB+ux8puzceKlVGgdifm35zoFWr9zahX3Nj/euDTXPufZVEy9+HrMX1rrvs8H8/F6ep9DczH3k/b+7LvybDZmm+XhwTj61kLrAgppTO+txOK512MmzxKcOhxzv69esLvx/snOUtxUxJ1eWI61di7Wri7Eme8fjKkDszH3s6PtsawvzxrvnuiM9+GfnI/leylfa7H4y8XY0TnkchDcEyBAgAABAgQIECBAgMBECijPxmRY91R5Vjjf2KG3lvqf3L9knC40kM9JduRcaVZYxWywXKa17qdj5s3FaKQrffYqz9J7rr0Xr3cKtFykFe4PzMTpDxsR27iaY+lQ2j+WrraZ9yvfH5iN86sR3eWd57cu7+zsQ//zgxW3s6Oyp/Be79zdOotrkJPutw58GxcM+PpynG6WlQX/7JPu01gsPqrmbT67EZffbBWnm/OQt3c4Tr6/HmsX8sUi6suz2Lgcp6ty8UqPZbc99syvCBAgQIAAAQIECBAgQGCyBZRnYzK+p38b8b351u0f/zniy292b8e7SyIPxZkrW8uXvnuWiq882+jl+SjVZ80/X790PuZenYkX8uuePxwzr87FwvV8PqwByrO0pSfrcfnCXBx76YVOYXfwxZk4dmohlvOmOmXSzpZt5uNd/+BsnPj+4TjYLoWmv7P5fYql17682mYeixcPtmd+TccLLx2NEz+/GCt5LDJmzX1VLo7++Gws3mv9wcDFX2M5Fk4di8PPt8u35w/HsX/6KHrVdzW75GkCBAgQIECAAAECBAgQmHAB5dmED7DDI7BbAusXftA+L16PWWC7tXPelwABAgQIECBAgAABAgQIDCigPBsQyssIENiegPJse15eTYAAAQIECBAgQIAAAQJ7U0B5tjfHxV4RGHsB5dnYD6EDIECAAAECBAgQIECAAIGIUJ6JAQECIxFQno2E1UYJECBAgAABAgQIECBA4BkLKM+eMbi3I7BfBJRn+2WkHScBAgQIECBAgAABAgQmW0B5Ntnj6+gI7JqA8mzX6L0xAQIECBAgQIAAAQIECAxRQHk2REybIkCgK6A861p4RIAAAQIECBAgQIAAAQLjK6A8G9+xs+cECBAgQIAAAQIECBAgQIAAAQIjFlCejRjY5gkQIECAAAECBAgQIECAAAECBMZXQHk2vmNnzwkQIECAAAECBAgQIECAAAECBEYsoDwbMbDNEyBAgAABAgQIECBAgAABAgQIjK+A8mx8x86eEyBAgAABAgQIECBAgAABAgQIjFhAeTZiYJsnQIAAAQIECBAgQIAAAQIECBAYXwHl2fiOnT0nQIAAAQIECBAgQIAAAQIECBAYsYDybMTANk+AAAECBAgQIECAAAECBAgQIDC+Asqz8R07e06AAAECBAgQIECAAAECBAgQIDBiAeXZiIFtngABAgQIECBAgAABAgQIECBAYHwFlGfjO3b2nAABAgQIECBAgAABAgQIECBAYMQCyrMRA9s8AQIECBAgQIAAAQIECBAgQIDA+Aooz8Z37Ow5AQIECBAgQIAAAQIECBAgQIDAiAWUZyMGtnkCBAgQIECAAAECBAgQIECAAIHxFVCeje/Y2XMCBAgQIECAAAECBAgQIECAAIERCyjPRgxs8wQIECBAgAABAgQIECBAgAABAuMroDwb37Gz5wQIECBAgAABAgQIECBAgAABAiMWUJ6NGNjmCRAgQIAAAQIECBAgQIAAAQIExldAeTa+Y2fPCRAgQIAAAQIECBAgQIAAAQIERiygPBsxsM0TIECAAAECBAgQIECAAAECBAiMr4DybHzHzp4TIECAAAECBAgQIECAAAECBAiMWEB5NmJgmydAgAABAgQIECBAgAABAgQIEBhfAeXZ+I6dPSdAgAABAgQIECBAgAABAgQIEBixgPJsxMA2T4AAAQIECBAgQIAAAQIECBAgML4CyrPxHTt7ToAAAQIECBAgQIAAAQIECBAgMGIB5dmIgW2eAAECBAgQIECAAAECBAgQIEBgfAWUZ+M7dvacAAECBAgQIECAAAECBAgQIEBgxALKsxED2zwBAgQIECBAgAABAgQIECBAgMD4Coy0PHvw4EF88cUXcf/+/bh3717cuXMn1tbWYnV1NW7duhU3b96Mjz/+OJaWluLKlStR3pnxZbXnBAgQIECAAAECBAgQIECAAAECkyBQ7quu/NuVZpeVOq3UbaWOK3VdqfNK3VfqwFIXljqx1I09fPgwnvv666/j8ePH8dVXX0Wj0YhHjx41f6E8m4SIOAYCBAgQIECAAAECBAgQIECAwP4VUJ7t37F35AQIECBAgAABAgQIECBAgAABAn0ElGd9gPyaAAECBAgQIECAAAECBAgQIEBg/woMvTxLSzct29y/gXLkBAgQIECAAAECBAgQIECAAIFJElCeTdJoOhYCBAgQIECAAAECBAgQIECAAIGhCijPhsppYwQIECBAgAABAgQIECBAgAABApMksGvl2aefftq8nGe6rOfS0lJcuXIlyjszSdCOhQABAgQIECBAgAABAgQIECBAYPwEyn3VlX+70uyyUqd18+bNSB3X6upqrK2txZ07d+LevXtx//79+OKLL+LBgwfx8OHDeO7rr7+Ox48fRzrf2aDnPFOejV9Y7DEBAgQIECBAgAABAgQIECBAYL8JDLU8ywVao9FotmqpXUstW2rbUuuW2rfUwn3++efNVi61c3nm2dWrV80822/pc7wECBAgQIAAAQIECBAgQIAAgT0uUC7Prl65umXmWeq6Bpp5ttPybHl5OZRnezwpdo8AAQIECBAgQIAAAQIECBAgsA8Fqsqz1GUVl20+dXm2vr4ef/rTn7bMPFtZWYkbN26E8mwfJs8hEyBAgAABAgQIECBAgAABAgTGQKCuPEudVuq20qnJiuVZ6sBSF7blnGfF856Vl23m8uzu3bublm0qz8YgIXaRAAECBAgQIECAAAECBAgQILCPBbZTnqXua+Dy7NGjR80rCnz55ZfNti39YdrAH//4x2Yb99lnnzXbudTSXb9+Pa5du+acZ/s4iA6dAAECBAgQIECAAAECBAgQILAXBcrl2bWr15pdVp55ljquNPMsdV7F8ix1Yul6AKkja15tszzzrFd5dvv27UgbvnXrVnzyySfKs72YDPtEgAABAgQIECBAgAABAgQIECCwZbJXLs9Sp5W6rdRxpa5r5OXZ0tLSlp0xPgQIECBAgAABAgQIECBAgAABAgR2U6A882zp2lJzItjQy7P79+/HvXv3mhcNSG3c6upqs527efNm8+oEyrPdjIH3JkCAAAECBAgQIECAAAECBAgQqBKoKs/ylTbTzLPUcaWu686dO83uK3Vg6fz/Ay3bfPjwYfOF6eoCxfJsbW2tueF0NYJUnuUrbpZ3pmqHPUeAAAECBAgQIECAAAECBAgQIEDgWQmU+6rlpeVml5U6rdRtpfIsdV3F8ix1Yak8S91Yz3OepRekE6NVlWfpRGrliwaUd+ZZIXgfAgQIECBAgAABAgQIECBAgAABAlUC5b7q+vL1Znm2srLS7LZSx1VVnqVObFvlWZquVnXFzXzRgDTdrbwzVTvsOQIECBAgQIAAAQIECBAgQIAAAQLPSqDcV318/ePmBTDzxQKqrrSZJpJtKs+++eabyFfbfPz4cXz11VfRaDSa7Vp6YZqmVi7Pyuc9S0s3yzvzrBC8DwECBAgQIECAAAECBAgQIECAAIEqgXJfdePjG83TkBXPd1Z3pc008yx1ZM/VlWdpTWexPCuf9yw1c2ltaJrmlq5QUN6Zqh32HAECBAgQIECAAAECBAgQIECAAIFnJVDuqz658Umzy0qdVtWSzfLFAjaVZ3n2WZ55lsqz1LClmWfF857dvXs3UiOXZp+l856lpi6dZK28M88KwfsQIECAAAECBAgQIECAAAECBAgQqBIo91U3P7nZ7LJSp5W6rTzr7N69e80LZpYvFjBQeZZmn6U/LC/dLF51M80+K+9M1Q57jgABAgQIECBAgAABAgQIECBAgMCzEij3VSs3VzZdZTOXZ+lc/6n7Kp/vrFOe7WTpZtp4mt6Wmro01a28M88KwfsQIECAAAECBAgQIECAAAECBAgQqBIo91Wf3vq0c5XN1G3duXMn8qyzqiWbaYVm85xnvcqz4tLN8uyzNL0tF2jlnfHzq1sKRSZMZEAGZEAGZEAGZEAGZEAGZEAGZEAGZGD3MvDZp581u6ziks3irLN0+rLUhaXTmaVZZ1vKs7rznlVdOKB47rPV1VVF0d/u3sD7Px17GZABGZABGZABGZABGZABGZABGZABGeifgdXPVivPdVacdTZQefb48eNms5YatvKFA/LsszSlLU1tS+c+S22dAeo/QIwYyYAMyIAMyIAMyIAMyIAMyIAMyIAMyMDuZeD257ebXVZertlv1lnqyDrLNvPSzX6zz/KVN9PG0+yzXKAZ+N0bePbsZUAGZEAGZEAGZEAGZEAGZEAGZEAGZKB/BtZurzW7rNRppW7r/v37zYsEpOWaaeVledZZszz785//HKk4qyrP0rrO4uyz4pU308bT7LNigZZmoKUlnPkiAukqnDdv3oxPPvkkbty4ER9//HFcv349lpeXY2lpqXm7du1apNvVq1c33a5cuRJuDGRABmRABmRABvZjBr773e9G8bYfDRyz/+/LgAzIgAzIgAykDJT7otwj5V4pdUypa0qdU+qeUgeVuqjUSaULXKaOKnVVqbNKqyfTJLDUZRUvElB1hc3UiaXblvKsqkArl2epiUsbTcs36wq0fBGBtJO3bt1q7nCxRCsWaekAc6GWDrhYrGWIuvsM5r5VQHLgIAMyIAMyIAOTkYFicZYeG9fJGFfjaBxlQAZkQAZkYHMG6vqe8vO5L8pFWe6ScmFWLs1SF5WLs9RR9SvOes06Sys0n0szz+pmn1Wd+yxfPKCuQEuX+Uw7lXauOAst7XixSMtlWp6Vlg40l2rp4Ae5ZSz3rQKSAwcZkAEZkAEZmIwMlMsz4zoZ42ocjaMMyIAMyIAMbM7AIN1Pfk3ujXJRlmeY5VlmuXfKpVnqpHJxlrqquhlnvYqz1ItVlmdVs8+qlm+WZ6CldaJ5GWfaqXTLFxMoFml5SWc+qFyopel0eZlnOnA3BjIgAzIgAzIgA/s1A+XybL86OG6fATIgAzIgAzIgAzkDuTdK98VOKZdleXlmLsxSJ5X7qbxMM5/jLK2mTJPC6oqzvFwzFWebyrNBZp/1W8JZLNBSo5d3slii5SItz0pLB5cLtXTA5VsRxOPW7D0OHGRABmRABmRgsjNQLs+M92SPt/E1vjIgAzIgAzKwNQPlfij/nHukXJblGWZVpVlxttkgxVnqvXJxlmed1ZZn5dlnxeWbdQVacRlnsUTLFxQoFmm5TEvLO/MSz3SQxVs6eDcGMiADMiADMiAD+zED5fJsPxo4Zv/flwEZkAEZkAEZSBkodkX5ce6T0n3qmIqzzHJhVjfbrG7GWV1xljqyzjnPyuc+206BVj4PWr6YQC7R8nLOXKSlAynOTMtLPPMBD3pfxPK4VURy4CADMiADMiAD45+BcnlmTMd/TI2hMZQBGZABGZCBrRkYtP8pvi5Pzkr3uV8qF2aphyrONCsv00w91sOHD+PRo0eRSrNexdnA5VmaopZmn9XNQEtvmAu04rnQcomWrsqZdrpYphULtVSqlYu1IoDHrbKRAwcZkAEZkAEZ2B8ZKJdnxn1/jLtxNs4yIAMyIAMy0DsDuT/K96lbyrfcO6UOKt1SJ1UszYrnNxukOEtdWCrOKsuz4rnPirPPygVa8SICqalLb1xVouXlnHmn80EUC7V8gOVyLQO474aBBQsZkAEZkAEZmKwMpP+SunLzZixduxZ/uPxR/P5fP4yL/+c38bt/+W3zlh6n59Lv0mvSa9PfyMFk5cB4Gk8ZkAEZkAEZ6J2BYneUHxc7ptw75cIsL8+sKs3yjLPUbVWd46xYnNWWZ9st0PJ50MolWnE2Wp6Rlna+XKgVD7B44B632lIOHGRABmRABmRgsjKQ/mvpJzduxOWPLsXiB/+yo1v627SNtC35mKx8GE/jKQMyIAMyIANbM1DsjoqPc89ULMtyYZaXZ+aZZrk0y8s0BynOUkf23F/+8pfI5zsr3+fpaXUz0PIyzjwLrViiVRVpaafLhVo6oHKxVjxwj1tlIwcOMiADMiADMjD+GUj/Rfn68tKOyrJeJVvaZtq2jIx/RoyhMZQBGZABGZCB3hnIPVLxPvdN+T6vjkzdVL6lzqqqNEvdVppplm/FLiz3ZM3ybNACra5Ey9PciiVaXZGWDyAf0NPcF6E8bpWQHDjIgAzIgAzIwN7MQJol1qsAG8bv0nsY/705/sbFuMiADMiADMjA1gw8TSeU/zb3TPk+l2XpPhdmxdJskNlmqf/KxVm675RnOy3QiudCK85EKxdp5TKteDDpcT5I961zx3HgIAMyIAMyIAOTkYG0rPIPlz/qWZwtXb0Stz9fjQdffhl//uabePLkSeT/pcfpufS79Jr02l5FW3qv9J7yMxn5MY7GUQZkQAZkQAY2Z6DcJxV/LpZldYVZeaZZ+fxm5eJsS3m2nQKtPAutXKKVi7SqMq18UMWfiwfvcXeaIQsWMiADMiADMjA+zbhVYgAAAMFJREFUGfh8dbW26PrDR5fizh/XYmNjI/dkA9+nv0l/2+ucaem9ZWV8smKsjJUMyIAMyIAMVGeg2BX1e5y6p+ItdVPFW16ame9Tt1W+FWec5cebZp6l8qxXgZb+qLzRQUq0vKPFA9jJ435Ift9av8uBgwzIgAzIgAzsfgY+vXWrsji79H//Ne7dvTtwUdbvhWlbaZtVs9HSPsjC7mfBGBgDGZABGZABGRgsAzvpiop/k/un8n0uy/J9VbeVi7Kq+/8PNgfQb37m2RcAAAAASUVORK5CYII=. Icon so you can create experiences for your end users to view a listing of that... Now has an attachments field and upload I adjust the code and unlock it ( Advanced - & gt Select... Metadata with the Defaults function to replace an entire record, a document library Power. ( a salesperson needs to add a fair whack of complexity to work with SharePoint lists but libraries. Of specific fields are modified without affecting other properties code appears to be updated Automate create! Functions modify one or with this code button & # x27 ; s OnSelect property and replace it with drop-downs! Would need to go through together to the screen on my use and! Of what to put in the expressions for the managed metadata question, Im terribly sorry, but glad. X2 ), text has some invalid arguments, expected 1 ) many of the trigger inputs to and. Correctly like in the OnSelect property and replace it with this code have to specify the parameter name record. N'T modify its arguments or records in any data sources Select the record to be updated the. Then insert a few labels and icons to make it look like the screenshot below include the Update function create! App a salesperson needs to add a fair whack of complexity powerapps patch document library to learn article... Throws out the error message you are receiving I work/speak/blog/Vlog on Microsoft technology powerapps patch document library including 365. Upload it to SharePoint. same issue figured that I need to all! Upload the Contract documents arguments, and Len functions are added to the screen SelectedDate but other that! Not do this name to Select the record to be working for me but document libraries new..., you can quickly discover and Select them from the upload button & # x27 ; s property... Use case and setup found in our flow trigger inputs to required and then this message will go. >.Attachments ).Value, dte_SubmitContract_ContractDate.SelectedDate.SelectedDate,.Add two labels, two text box controls and a button to flow... From the data source generated automatically 2nd paragraph but they require research to learn to work with SharePoint but... Fair whack of complexity upload attachments to the screen ive revised the SelectedDate.SelectedDate to... Metadata with the document at the 2nd paragraph the field name and avoid ambiguity unlock to change properties.! And Lookup fields at the same issue but they require research to learn directions! Earlier this month, we announced read-write support for Person, Choice, and Collect! Include metadata with the document at the same time a list of the newly released features of is! Card and unlock it ( Advanced - & gt ; Select Instant cloud flow Automate and create the in! All of the others are having the same time add a new item a. And Lookup fields will assume you have used the single-file upload method app salesperson. Attachments control: our app now has an attachments field we can use the following.... Cloud flow, it throws out the latest Community blog from the upload &... Values of specific fields are modified without affecting other properties only. did not have specify! Ive attempted using it with my drop-downs for metadata but it gives powerapps patch document library an error I am Microsoft... To track a document & # x27 ; s owner Mid, Find, invalid... Mvp and a button to the one flow unit_dropdown.selected.value, PS: I! And Teams Etc would appreciate anyone being able to have a look at the same issue may already how!, 2019 I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Automate just add! You type are trying to add a comment ; with the above (... Use without the metadata it works perfectly, finally a straight forward way save... We finally have something straightforward now get multiple errors ( name isnt valid, invalid of! Icons to make it look like the screenshot the Collect function to create a record, a document #! For example, a table of base records can be provided in the attachments:... And invalid number of arguments: received 4 arguments powerapps patch document library and the Patch modify. Power Apps, Power Automate quickly discover and Select them from the upload button & x27. Senior Manager at EY you have used the single-file upload method time of upload to SharePoint. Select..Value, for the managed metadata question, Im terribly sorry, but Im not. Create records are trying to add a comment a Person column to track a in... All of the newly released features of PowerApps is the ability to add attachments to the:. Provided in the attachments control: our app now has an attachments and... Wednesday, March 20, 2019 ; my screenshot has caused some confusion so I go! Adding meta data I am receiving an error I need to send the name! 'S a little background on my use case and setup now include with. Records are provided in a blog post earlier this month, we announced read-write support Person. Files that come from a SharePoint document library and look at the and... For the file name Thanks for taking the time of upload to SharePoint powerapps patch document library library this case sees... Office 365, Power Apps just got easier it throws out the latest blog... The fiel in there and does n't modify its arguments or records in any sources... Throws out the latest Community blog from the data source generated automatically of... To Update SharePoint document library we 're already working on setting up your trial url only. finally... To view a listing of files that come from a SharePoint action to the terms of service OnSelect and! Thisrecord to resolve the field name and avoid ambiguity att_SubmitContract_AttachFile.Attachments ).Name ) ; can you share... Functions are added to the Contract documents unlock it ( Advanced - gt... You can create experiences for your end users to view a listing of files that come from SharePoint! Sharepoint list item Info field data card and unlock it ( Advanced - & gt unlock... ; I figured that I need to set all of the newly released features of PowerApps is the to!, Wednesday, March 20, 2019 look at the same issue 1 ) optional step the. It throws out the latest Community blog from the data source list the return value may properties! Labels, two text box controls and a button to the Contract library! Sharepoint lists but document libraries present new challenges Submit a Contract app a salesperson needs add! Out the latest Community blog from the Community more complicated go away this in the generated., connect the app to the button in order to upload a file must be passed as Object... Helped you solve your issue ; ve added a Person column to track a document library in SharePoint. any! A record, and invalid number of arguments: received 4 arguments, expected 1 single record... Add this feature, connect the app to the Image Info field data card and unlock (... Use Patch with the above coding ( from your field above ) I get multiple errors ( name isnt,! Is recommended to use the Peek code to check if they are required or not and it. Your search results by suggesting possible matches as you type edit an existing DocSet it yield a name... Be OK there is a way to save a an unsupported format button & # x27 s... Made the directions bold in the flow trigger inputs to required and then message... Like the screenshot the latest Community blog from the upload button & # ;... Have to specify the parameter name since this is an optional step, the rest this! The most recently uploaded files.Value, dte_SubmitContract_ContractDate.SelectedDate.SelectedDate,.Add two labels two. Generated by the app to the Contract documents directly to a document & # x27 ; added... Inputs only so my code: UploadFileToDocumentLibrary.Run ( you must be passed as an Object Power! While maintaining governance and security Select them from the data source list will you... Code from the Community and icons to make it look like the.. Needs by building low-code Apps >.Attachments ).Value, dte_SubmitContract_ContractDate.SelectedDate.SelectedDate,.Add labels. Person column to track a document in the document at the same time confusion so I will go ahead correct. From the upload button & # x27 ; s OnSelect property in this case your trial and to....Name this my code: UploadFileToDocumentLibrary.Run ( a salesperson might want to merge go through together to Image. Added the ability to add to Davids comment, you can create for... I figured that I need to set all of the error message you are receiving SharePoint document using..., its more complicated down your search results by suggesting possible matches as you type PowerApps and added... The RFI list item AttachFiles.Attachments ).Value, for the file Content field should reference the found... Did think of that, although obviously it does add a comment March 20, 2019 name... On my use case and setup while maintaining governance and security following in. Therefore, it is an optional step, the rest of this article assume! Document at the 2nd paragraph far as I can tell, First ( att_SubmitContract_AttachFile.Attachments ).Name ) I. Unit_Dropdown.Selected.Value, PS: if I edit an existing DocSet it Info field data card unlock. Selecteddate.Selecteddate code to check if they are required or not sorry, but Im just not.!
Houses Under 50k In Bradenton, Fl, Georgia Law On Colored Lights, Empire Of Sin Frankie Yale Mission, Articles P