From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id QPYfIqWnImWpJwEA9RJhRA:P1 (envelope-from ) for ; Sun, 08 Oct 2023 14:59:17 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:478a::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id QPYfIqWnImWpJwEA9RJhRA (envelope-from ) for ; Sun, 08 Oct 2023 14:59:17 +0200 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id E5ECE766AB for ; Sun, 8 Oct 2023 14:59:16 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=mat.ucm.es header.s=google header.b=TIe90qwJ; dmarc=pass (policy=none) header.from=mat.ucm.es; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1696769957; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=2Gm40XC1tmTXRNCw/Auj+IBSqz4fJal2m9cM00qGhH4=; b=VnnIVSEpmSQMKZu5z4Oz3rvPS1RvoW3nF93AHAo0lIeFw4l8pXTHkA/AB7wYZuDWeSELjB OWrRNfkn2R0knClfuGJ5KzCAjdAsTedsEOQhTkUauMT0lieaYIrCu046JuK4u9oLnx70MW S7SY8XzAsZ+sJRm8uNnoBD2X6CkCBvJ/fF8b4i4q5mHXkplOIptg/+gfrAC69uQpHJPlES Uk5vPyNrqMnXRRxTgcGDEiHwBLZ3bRSil8iJsvge5xerJm1/8nxk2fFcVU3uDTJ5qif1o8 kKxtaxWXlMteLre3Qtms9wkD5hJxKtIuI+drts8a9QwRLSUpSIgtgdKGvsxIEg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1696769957; a=rsa-sha256; cv=none; b=D8j1WehMF42UVsLVjbx2aGjdoaSSpWEa4c8mP2wd42pzTbSXu2YWYmlRuWB2Jrsiz6DDcJ PmPq8PVOksjA4vAOrpKba+ruFo6dQ/Tp260XxyajIv7uDWB55xzbRpIt/+MLaS10NSGF4g lDo1Hd31rzzPOxmiy317wyTJuZtjszmep3QxyFo/ZppU+fS2n0O6zPHFCXoK0Qxmmt4IO9 T7fLZU7r4+rADDTU6A0JpGZ3oFF0Uiz4Q2qVyWRXS1Y9hkc+rJlyz8D1gmyHM/OrpZyq6p rBaQrMeZYE81PxLxT8R9IaCDoMmONrBfsUYKZ90UBK6lKKQBlqAj6mNVS0nHVQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=mat.ucm.es header.s=google header.b=TIe90qwJ; dmarc=pass (policy=none) header.from=mat.ucm.es; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qpTMa-0001st-Kg; Sun, 08 Oct 2023 08:58:31 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qpTMT-0001sT-HW for emacs-orgmode@gnu.org; Sun, 08 Oct 2023 08:58:22 -0400 Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1qpTMR-0006dv-Hg for emacs-orgmode@gnu.org; Sun, 08 Oct 2023 08:58:21 -0400 Received: by mail-wm1-x32e.google.com with SMTP id 5b1f17b1804b1-4054f790190so35516195e9.2 for ; Sun, 08 Oct 2023 05:58:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mat.ucm.es; s=google; t=1696769897; x=1697374697; darn=gnu.org; h=mime-version:user-agent:message-id:date:subject:to:from:from:to:cc :subject:date:message-id:reply-to; bh=2Gm40XC1tmTXRNCw/Auj+IBSqz4fJal2m9cM00qGhH4=; b=TIe90qwJ2so0eFf/oc2oIe5dUf2HScYXQ5w6RugrndxnchNOOT5tFVu9rIKNzGGBXZ Rp5r4pvNjP1TgiPlZI3WEgGlLQ+nasLvnyBeqRmgPcZhoS4glltN6fImqR5+9/sEg0BV /3btGkfFjbJm6AXiZsE6n29T53wCB3oQyoC+o= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696769897; x=1697374697; h=mime-version:user-agent:message-id:date:subject:to:from :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=2Gm40XC1tmTXRNCw/Auj+IBSqz4fJal2m9cM00qGhH4=; b=oX83mSzUFDYbC/KllwYIN3gvXKXeZdFe9D2CWGVj0IugHE02f6LtpmAIgdYj788CwU bsidfg3y5huAiMOfepwyx8MVeTyeSBtHCxQGumYtjw7UT1YHxJVH22fT6v34NNIsoQ93 FWHf9IVDDX0Sq50D8My13JlS53zrEpeMRVVfRtHgI4cq+zaUrrveRLLHKystheCReiym uJmZMWyUPCKCMk83rgNZHZYiJYNAhatDVhyJE5f334cwlmn5YFuh7U/0/xH9UHfzALN3 KMPoe5XTMS0/k6CRYr5Ky2g9m2e9IKjRbqk546Vb4mXDzhf2uhR6A++Ue51+aF8tVNF8 aS8w== X-Gm-Message-State: AOJu0Yy1gyP6C//MmHiOVFbzyktNLzzv0OJ8osIOZcPzpNpY0Ygy4TTj 8oKm+Aq4Yytgd/FIiD3TV72gSu6VTBtL06PMXVVrNIDWctkN070EiVBbWSmtQXusub+ePmJgaeY cZ3YH5heBURy1rUKwW/ez1YfngOQKsat04It55nU0m532v4My0lFVBt6adyfHAXj+oQ== X-Google-Smtp-Source: AGHT+IENx6vnwUkfA59Cyk1rBD8/QPcFv9Is4Es3JgTGqQcT6kJgZ7OJiwtrw3rD/j1vH8BmdBSZ4w== X-Received: by 2002:a5d:674a:0:b0:317:e68f:e1b2 with SMTP id l10-20020a5d674a000000b00317e68fe1b2mr10675769wrw.28.1696769897464; Sun, 08 Oct 2023 05:58:17 -0700 (PDT) Received: from Utnapischtim (p200300fb0f377d2438e4db5afc8c3f06.dip0.t-ipconnect.de. [2003:fb:f37:7d24:38e4:db5a:fc8c:3f06]) by smtp.gmail.com with ESMTPSA id z9-20020adff749000000b00318147fd2d3sm6781799wrp.41.2023.10.08.05.58.16 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 08 Oct 2023 05:58:16 -0700 (PDT) X-Mailer: emacs 29.0.50 (via feedmail 11-beta-1 I) From: Uwe Brauer To: emacs-orgmode@gnu.org Subject: equivalent of VLOOKUP (in ods) to org-table Date: Sun, 08 Oct 2023 14:58:10 +0200 Message-ID: <87h6n1i84d.fsf@mat.ucm.es> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=sha256; protocol="application/pkcs7-signature" Received-SPF: pass client-ip=2a00:1450:4864:20::32e; envelope-from=oub@ucm.es; helo=mail-wm1-x32e.google.com X-Spam_score_int: -19 X-Spam_score: -2.0 X-Spam_bar: -- X-Spam_report: (-2.0 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Scanner: mx0.migadu.com X-Migadu-Spam-Score: -9.52 X-Spam-Score: -9.52 X-Migadu-Queue-Id: E5ECE766AB X-TUID: NRYj4U6kuBYR --=-=-= Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi I have regularly to deal with large tables, that I split in smaller ones an= d then try to connect them. I have to export the resulting big table to ods, and in the ods case, I hav= e several sheets and use the=20 VLOOKUP command, like this #+begin_src=20 #+Name: table1 | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 | |--------+-----+-----+-----+-----+-----+--------| | Smith | 2 | 3 | 4 | 6 | 7 | 22 | | Miller | 2 | 10 | 1 | 1 | 5 | 19 | | Wick | 1 | 2 | 3 | 10 | 2 | 18 | #+TBLFM: $7=3Dvsum($2..$6);f2 #+Name: table2=20=20=20 | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2 | |--------+-----+-----+-----+-----+-----+--------| | Smith | 8 | 3 | 5 | 8 | 9 | 33 | | Miller | 2 | 1 | 6 | 9 | 3 | 21 | | Wick | 1 | 5 | 9 | 1 | 2 | 18 | #+TBLFM: $7=3Dvsum($2..$6);f2 | Name | | ResSh1 | ResSh2 = | Total | |--------+---+-------------------------------------------------+-----------= --------------------------------------+-------------| | Smith | 3 | /=3DVLOOKUP(final.A2,table1.$A$1:$G$3,7,FALSE())/ | /=3DVLOO= KUP(final.A2,table2.$A$1:$G$3,7,FALSE())/ | =3DSUM(C2:D2) | | Miller | 3 | /=3DVLOOKUP(final.A3,table1.$A$1:$G$3,7,FALSE())/ | /=3DVLOO= KUP(final.A3,table2.$A$1:$G$3,5,FALSE())/ | =3DSUM(C3:D3) | | Wick | 4 | /=3DVLOOKUP(final.A4,table1.$A$1:$G$4,7,FALSE())/ | /=3DVLOO= KUP(final.A4,table2.$A$1:$G$4,7,FALSE())/ | =3DSUM(C4:D4) | #+TBLFM: $5=3DSUM(@4$3:@4$4) #+end_src Maybe there are other solution in ods I don't know, so the question is wha= t is equivalent of VLOOKUP in org. I came up with the remote command that results in a similar result, (I did = not want to use third party packages like=20 orgtbl-aggregate.=20 #+begin_src=20 #+Name: table1 | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 | |--------+-----+-----+-----+-----+-----+--------| | Smith | 2 | 3 | 4 | 6 | 7 | 22 | | Miller | 2 | 10 | 1 | 1 | 5 | 19 | | Wick | 1 | 2 | 3 | 10 | 2 | 18 | #+TBLFM: $7=3Dvsum($2..$6);f2 #+Name: table2=20=20=20 | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2 | |--------+-----+-----+-----+-----+-----+--------| | Smith | 8 | 3 | 5 | 8 | 9 | 33 | | Miller | 9 | 4 | 6 | 9 | 3 | 31 | | Wick | 1 | 5 | 9 | 1 | 2 | 18 | |--------+-----+-----+-----+-----+-----+--------| #+TBLFM: $7=3Dvsum($2..$6);f2 #+Name: final | Name | Some | ResSh1 | ResSh2 | Final | |--------+------+--------+--------+-------| | Smith | 4 | 22 | 33 | 59 | | Miller | 4 | 19 | 31 | 54 | | Wick | 4 | 18 | 18 | 40 | |--------+------+--------+--------+-------| #+TBLFM: $3=3Dremote(table1,@@#$7)::$4=3Dremote(table2,@@#$7)::$5=3Dvsum($2= ..$4);f2 #+end_src The syntax with @@#$7 look cryptic to me, but I found it somewhere and it w= orks if somebody can suggest a simpler command that is closer to VLOOKUP I would= be grateful Thanks and regards Uwe Brauer=20 =2D-=20 Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against Ukraine. I support to deliver weapons to Ukraine's military.=20 I support the NATO membership of Ukraine. I support the EU membership of Ukraine.=20 https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-v= iew/ --=-=-= Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExDzANBglghkgBZQMEAgEFADCABgkqhkiG9w0BBwEAAKCCE8cw ggWDMIIDa6ADAgECAg9dk40wZzbIBh0ax1SEaQcwDQYJKoZIhvcNAQELBQAwOzELMAkGA1UEBhMC RVMxETAPBgNVBAoMCEZOTVQtUkNNMRkwFwYDVQQLDBBBQyBSQUlaIEZOTVQtUkNNMB4XDTA4MTAy OTE1NTk1NloXDTMwMDEwMTAwMDAwMFowOzELMAkGA1UEBhMCRVMxETAPBgNVBAoMCEZOTVQtUkNN MRkwFwYDVQQLDBBBQyBSQUlaIEZOTVQtUkNNMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKC AgEAunGAekyGbn/IE23Axn0cAJePLAwjuxCaQKkat4eI+JtWavvme46Lko6nJV1ZEds2LrdRFx+p CB8EFyRYqjdKGN/lOdRX/dfBLJEBkeIi1APAWPx3R+yPPnRDuqw0jU04dmeOsMhvMDNYcVy09Wtu 1AFQuBN+bEqjSdEgGe68wCkYZafe/u/dCpAh5xpnkkIQmF9PMLw+HEW0ENdoQBTAQPrndxd65guP ZVs82ZpS27W9nkbPPeuRBQLAlrJ2TE0QljuS+px/D5nfviM1RR4CXP61qJuZJdpe8yLDOfXkKi7T xh/EbKrFHGoBBUov0sXBqDQmXWal0gIh+Ri3BvVOmW+oq0xR6M9QGMV3yDkJLEmSMpmouxcXebBa xeajxFllRzWDXqnoNQuZu+TNIMabSgY5tWj8IrruVYwrTurzseP8tpma1UL6cU0Iz4ceanF9+dO0 6aVxgXvCTkeWpfZ2haMoj+mAboFTpW1fuEj5wvk2pi5J/7iWwowHs5uIWPzrGxzeLXDil5IwoYnj vFWoJ9ZL7ZCti/pjJVktqDXdypczvOXNx53R7O9eDkqQBiZjrbnZNS0HunZlLKxXj330B5TXgQKW XaMHSdV60Ff5G+dTRnWqsHlCy2hxCOlgvTlpzvSvw1ZAx61Sognkb4ZHih/rKCddgyCvBMlsVpqL RvUCAwEAAaOBgzCBgDAPBgNVHRMBAf8EBTADAQH/MA4GA1UdDwEB/wQEAwIBBjAdBgNVHQ4EFgQU 933F/cTomht3ZKf1HaDMv4dgmm0wPgYDVR0gBDcwNTAzBgRVHSAAMCswKQYIKwYBBQUHAgEWHWh0 dHA6Ly93d3cuY2VydC5mbm10LmVzL2RwY3MvMA0GCSqGSIb3DQEBCwUAA4ICAQAHkErf8yNO8MOc UWWbnCKiigyF83Mpa03+AeKpDGMBvwRnpZ2YX/0BE/rsmmLphv62YtJuTJT7wHVFfGUM+LI3z6wP z41v+Rn3j+we8nCe8Mq477f/djd2W/ZuiPOvYjIikw06ao4UZgwtU3RXZR7Vst0jgTulZiMnZwmP 4XeqQ81lUQjtUVj+5jn5y0eEpBXxdruk7qQ7xF/vsjOWERi3yWW+GOGjpNz6GPnTvBObOXo0utNB +/oyiiq3K4YLaYM4vs2KLgtwrY0mku4e9QErCtnWl5tu4KgZHDohiwweQK0D591mfvW5IA0D6Jb5 gkXUOeCgAF3XmOZ9nmdzw5oq96uLoToU7zS8Ug6JmJoEQIQdfkVpk1fO6874UHxPHG4EQ5v51jsj GOnqjtFNRo3xO+Rqyrr7I7eb+pkBKVpYWi3j+dRtDiatwW40vDL4DAX6ZaPbOzeDIunW3HIz/V3y IL12PCPaKPf5G+tZZNXcX3J+IPzNibWQZ01iej9OrR3DOf569CgW30H2SIAF1w9ReawQq9TsA2bm arC6MZJCQGq+OtNy4Wo3VbysHZW3aWHyQ5F05qDTCiRGoQiv1tpFGZbUUx1bhHnwwPdH74uPxQau nUxinf9GBPjTybYQJUB1/haqyUpghi+67zB35FTiuISZWICqE4tROk9I9ou2szCCBtowggTCoAMC AQICEEVfOuFcIc26VE+CqkdR69swDQYJKoZIhvcNAQELBQAwOzELMAkGA1UEBhMCRVMxETAPBgNV BAoMCEZOTVQtUkNNMRkwFwYDVQQLDBBBQyBSQUlaIEZOTVQtUkNNMB4XDTE0MTAyODExNDg1OFoX DTI5MTAyODExNDg1OFowSzELMAkGA1UEBhMCRVMxETAPBgNVBAoMCEZOTVQtUkNNMQ4wDAYDVQQL DAVDZXJlczEZMBcGA1UEAwwQQUMgRk5NVCBVc3VhcmlvczCCASIwDQYJKoZIhvcNAQEBBQADggEP ADCCAQoCggEBAJ0gBCYt+y1pMMvZk3+l5a7UcHLvlL5Fa+WPsgv5ujOGJa+G8cDY27Y/vvG+iQWm /cMh4ZLVUiAWvnYmIX7B7FlVoJDpUszSD6kzyjpo2LS91CbqFtwG6QzWSRFRYBKJZAoOdcFyjIzu zuQnycCAN4ldn23nkeGADprP9ZqptC0pK1osMJWBfVZ/Gqq/3gJ0/3fCnWAuWf/THNWs1h1je8ye jE3bmfT3FYzJu9Ir4h2qIYBFLve/W8tt2nMevau6iz4x5GKBoX9n7dbUKmJo7PYnIMD4a8y8stc8 12MtB6HhZ7OG4tjfjAU5qX/4vB2TiugctzEtlJQrI14R4c2psEcCAwEAAaOCAsgwggLEMBIGA1Ud EwEB/wQIMAYBAf8CAQAwDgYDVR0PAQH/BAQDAgEGMB0GA1UdDgQWBBSx1E/EI3n6RAUJxus5z+g1 sLggZDCBmAYIKwYBBQUHAQEEgYswgYgwSQYIKwYBBQUHMAGGPWh0dHA6Ly9vY3NwZm5tdHJjbWNh LmNlcnQuZm5tdC5lcy9vY3NwZm5tdHJjbWNhL09jc3BSZXNwb25kZXIwOwYIKwYBBQUHMAKGL2h0 dHA6Ly93d3cuY2VydC5mbm10LmVzL2NlcnRzL0FDUkFJWkZOTVRSQ00uY3J0MB8GA1UdIwQYMBaA FPd9xf3E6Jobd2Sn9R2gzL+HYJptMIHrBgNVHSAEgeMwgeAwgd0GBFUdIAAwgdQwKQYIKwYBBQUH AgEWHWh0dHA6Ly93d3cuY2VydC5mbm10LmVzL2RwY3MvMIGmBggrBgEFBQcCAjCBmQyBllN1amV0 byBhIGxhcyBjb25kaWNpb25lcyBkZSB1c28gZXhwdWVzdGFzIGVuIGxhIERlY2xhcmFjacOzbiBk ZSBQcsOhY3RpY2FzIGRlIENlcnRpZmljYWNpw7NuIGRlIGxhIEZOTVQtUkNNICggQy8gSm9yZ2Ug SnVhbiwgMTA2LTI4MDA5LU1hZHJpZC1Fc3Bhw7FhKTCB1AYDVR0fBIHMMIHJMIHGoIHDoIHAhoGQ bGRhcDovL2xkYXBmbm10LmNlcnQuZm5tdC5lcy9DTj1DUkwsT1U9QUMlMjBSQUlaJTIwRk5NVC1S Q00sTz1GTk1ULVJDTSxDPUVTP2F1dGhvcml0eVJldm9jYXRpb25MaXN0O2JpbmFyeT9iYXNlP29i amVjdGNsYXNzPWNSTERpc3RyaWJ1dGlvblBvaW50hitodHRwOi8vd3d3LmNlcnQuZm5tdC5lcy9j cmxzL0FSTEZOTVRSQ00uY3JsMA0GCSqGSIb3DQEBCwUAA4ICAQCMPSi04H4N825c2lx3PYBkHk7p ErjJ5rL/K4CgeD2ETCxliy/c8WMr591SQduv/BcLjJqE8gnUXVainvmCZsCFXpxe6oPnfEaOfl/m Y+2rYu9GTidhlYG9TQI9qTQPmfnma1aVA599S/t84k4S76QLRLU8egExWyZhIJKUdQJ21s77rMMF CDFAbKUdNp4giM6giVZtrtlMvZB8PnYgSUbsFWKaQWWr4J+xAjTvryniACmZnvljHdGUE4ZA0WCM RRcGIVhaHNUxPi39J1WxGuY/7+qFXGrj/tnci4x/603VYYeC5yPwyjxih3bkPKl7oW8YGyIrvIwU /9J93VkDxQd6LvfrB5ZU/bklFRq7Sviso4Bix+aHvIuBjmx+xiVLYZFMBGMxoo4P1pir5vo4NIJ5 Vk+x4lNCuHxFpXSAZfZzWoddskj1Tet6v/JAl0tyUfHDPNmXrMy1Z7T7OuIrVdliq5KzQPi7buGf 1E2OJbh/iEXr6Pa3k+u/dDEL2KwsI0rLjQ+H1yPOv5hhEhr4W8BApqYXvC/41dLmdNciOZpoIXnQ a+Vqir+uBJiFzRVWdt/pofERQoKj2bGrVWlaAUKtRXrzoTzIxL8YjIMz173tgN4Epp4P1Cg3Chsx W8i/r3kmYXT/OeJj5NyDxAmGRDagGFl4wZbZvFA0ZlAbdcKYETCCB14wggZGoAMCAQICEE7jGLDR L7reYiUcckKTal4wDQYJKoZIhvcNAQELBQAwSzELMAkGA1UEBhMCRVMxETAPBgNVBAoMCEZOTVQt UkNNMQ4wDAYDVQQLDAVDZXJlczEZMBcGA1UEAwwQQUMgRk5NVCBVc3VhcmlvczAeFw0yMjAzMDYy MDQxMjJaFw0yNjAzMDYyMDQxMjJaMIGBMQswCQYDVQQGEwJFUzEYMBYGA1UEBRMPSURDRVMtWDIw NjQxMjNCMRkwFwYDVQQqDBBVV0UgUklDSEFSRCBPVFRPMQ8wDQYDVQQEDAZCUkFVRVIxLDAqBgNV BAMMI0JSQVVFUiBVV0UgUklDSEFSRCBPVFRPIC0gWDIwNjQxMjNCMIIBIjANBgkqhkiG9w0BAQEF AAOCAQ8AMIIBCgKCAQEAoJVE/sbo1m+uKynMrhlC2uwucKui15DqfQf8185jc8VjjJyuMoV+JG0T cb9HhpVodL2WCW83Gb2OKq1pr90ZCscCYR0XOOy6ZclnNhMaPvf9dZrogt9SR7XUI03UJsaWg7xK upApj+zaAMFGmzYNzPH1h/rWVxvK12NoURkmSF31t+sdnJXsCiciUL1qdl5X0AtL85WjAnR2bMmf Jw17jPkq+sXSBGL73Y2GwoZyrP8jM5acfjyDW6vYc4Ia9f0znfOD9yuneJi0UeDBHgJ42oYT83DP gGiTow6uxUNj0t2lJGsEKnBrBTYlkDq49XUOTOcdv5TDUpDk1Awacl/6gQIDAQABo4IEBTCCBAEw bwYDVR0RBGgwZoEOT1VCQE1BVC5VQ00uRVOkVDBSMRgwFgYJKwYBBAGsZgEEDAlYMjA2NDEyM0Ix FTATBgkrBgEEAaxmAQIMBkJSQVVFUjEfMB0GCSsGAQQBrGYBAQwQVVdFIFJJQ0hBUkQgT1RUTzAM BgNVHRMBAf8EAjAAMA4GA1UdDwEB/wQEAwIF4DAdBgNVHSUEFjAUBggrBgEFBQcDBAYIKwYBBQUH AwIwHQYDVR0OBBYEFGVctturectaj2GUB3MWVsUmJHlRMB8GA1UdIwQYMBaAFLHUT8QjefpEBQnG 6znP6DWwuCBkMIGCBggrBgEFBQcBAQR2MHQwPQYIKwYBBQUHMAGGMWh0dHA6Ly9vY3NwdXN1LmNl cnQuZm5tdC5lcy9vY3NwdXN1L09jc3BSZXNwb25kZXIwMwYIKwYBBQUHMAKGJ2h0dHA6Ly93d3cu Y2VydC5mbm10LmVzL2NlcnRzL0FDVVNVLmNydDCCARUGA1UdIASCAQwwggEIMIH6BgorBgEEAaxm AwoBMIHrMCkGCCsGAQUFBwIBFh1odHRwOi8vd3d3LmNlcnQuZm5tdC5lcy9kcGNzLzCBvQYIKwYB BQUHAgIwgbAMga1DZXJ0aWZpY2FkbyBjdWFsaWZpY2FkbyBkZSBmaXJtYSBlbGVjdHLDs25pY2Eu IFN1amV0byBhIGxhcyBjb25kaWNpb25lcyBkZSB1c28gZXhwdWVzdGFzIGVuIGxhIERQQyBkZSBs YSBGTk1ULVJDTSBjb24gTklGOiBRMjgyNjAwNC1KIChDL0pvcmdlIEp1YW4gMTA2LTI4MDA5LU1h ZHJpZC1Fc3Bhw7FhKTAJBgcEAIvsQAEAMIG6BggrBgEFBQcBAwSBrTCBqjAIBgYEAI5GAQEwCwYG BACORgEDAgEPMBMGBgQAjkYBBjAJBgcEAI5GAQYBMHwGBgQAjkYBBTByMDcWMWh0dHBzOi8vd3d3 LmNlcnQuZm5tdC5lcy9wZHMvUERTQUNVc3Vhcmlvc19lcy5wZGYTAmVzMDcWMWh0dHBzOi8vd3d3 LmNlcnQuZm5tdC5lcy9wZHMvUERTQUNVc3Vhcmlvc19lbi5wZGYTAmVuMIG1BgNVHR8Ega0wgaow gaeggaSggaGGgZ5sZGFwOi8vbGRhcHVzdS5jZXJ0LmZubXQuZXMvY249Q1JMNTQxOSxjbj1BQyUy MEZOTVQlMjBVc3VhcmlvcyxvdT1DRVJFUyxvPUZOTVQtUkNNLGM9RVM/Y2VydGlmaWNhdGVSZXZv Y2F0aW9uTGlzdDtiaW5hcnk/YmFzZT9vYmplY3RjbGFzcz1jUkxEaXN0cmlidXRpb25Qb2ludDAN BgkqhkiG9w0BAQsFAAOCAQEAQfp9/80Z3s4+aMrO9sGDDmjPpZF5P9neOg6DiWyamKRhTiNwU1Ho VXIXEU3lzb5tHmqwb/TmZmCJINYDGflzeNxR4OIEDbqUKrdLJ8nRQ2G6X8w7LmvImUGI+WRxizPZ nTBxh+12akO7XEiq2JNW5JOV2z5e3jO0C4Y9fXj0E30O5N3JpDbWfH8JcpTSJdNAetfON1pa7ZLK N0NAMuJc5OUAKzlJsvE6D8L8eRooM/unrqygLOmu3e0f37Gtf7fE0IDIJwh101twvs3ArNMmRFhn 5GBChF6+ubXqyQyZrY6DDV8X9rGkki1n8JIOxpNOexgYgbmav0oekc+3LTUHATGCAiAwggIcAgEB MF8wSzELMAkGA1UEBhMCRVMxETAPBgNVBAoMCEZOTVQtUkNNMQ4wDAYDVQQLDAVDZXJlczEZMBcG A1UEAwwQQUMgRk5NVCBVc3VhcmlvcwIQTuMYsNEvut5iJRxyQpNqXjANBglghkgBZQMEAgEFAKCB kzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0yMzEwMDgxMjU4MTFa MCgGCSqGSIb3DQEJDzEbMBkwCwYJYIZIAWUDBAECMAoGCCqGSIb3DQMHMC8GCSqGSIb3DQEJBDEi BCDot5C3VR1SgG4QMPqYkWRabJ/7X0q3v5XMn5W7wzWxFTANBgkqhkiG9w0BAQEFAASCAQCS8c/v jucV0cibTTDIwChbUT/eR6z3iHQ4dwRdqIkEorntcb03VQ6joRUAlP11EvdINg1WcSjTmJNbOGUC /5wTpnsLQuFZVAsGJJ5mGnjFWngIyBWCf/64cY3UO0Esaneoh70N04nqq5HQlaBjrYoMf0gk2MkE qlWqJIhKvVM3XoZzfN4ZOt5KVTC0JO7vKbZYJehe0OEQcENpPeUN8PKQVtB4YDuNZ5/D86tXxGQo ptbZJxo2p0uNgUdCiPEkM78EdzGHDTlWQv7JquWdzrgq7NTlQwWXVI5KQxJzMOoUwJdfAQT1xt4j oG1RmaDaBk9UkpBsHszDORouZ26QbLr9AAAAAAAA --=-=-=--