From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:403:4789::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id QLHDEwu5JmWEYQEAauVa8A:P1 (envelope-from ) for ; Wed, 11 Oct 2023 17:02:35 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:4789::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id QLHDEwu5JmWEYQEAauVa8A (envelope-from ) for ; Wed, 11 Oct 2023 17:02:35 +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 D4CAD66149 for ; Wed, 11 Oct 2023 17:02:34 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=mat.ucm.es (policy=none); 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-Seal: i=1; s=key1; d=yhetil.org; t=1697036555; a=rsa-sha256; cv=none; b=TDETCQmHZOsi7QXl0wjMdjLuhu2rWLXOrsGw+6vAqxkZFvfr2GUdNNhr0rBbbQkuFjOCfo wyefK7JYbHjx8EmbzRJVFha5YWZ6dfbTnuUvvdk40W5RGVYGBFkUADM7xdAUnFIlr1DI3j FjAVacroIglGfmi4pQ0KdQLqVXQhl0v/742K5Zjs246GEyvPcCjLzFTulM1tTsuTW8j3NV spZ9fWrjnQz2584zfIkhbqBjwAO0mzFlbv+Wlssd95F4G2kc4TIAODoeIzlj0QAL31h4Oq btXKnDHclpwDBE2Bb9SgwJqmlgLNNoiVqcyyG03EZoMF3w4CvdpdqKdZkwcerg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=mat.ucm.es (policy=none); 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=1697036555; 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:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=3XZp3l2Oo7u0YMDVcdNGscyEd/SCtLwxicmYoQIzm1A=; b=VAWJiNx9rmUrDcDCHjUusMxkYOunos9sg08g6F1mmmri+IiJMDFwzZW7/ix5tMWwJB5CY2 YL8K3v9Io6ONMn6pL7LFSo+EwWfbu7w/HdoOQQqZMQJFzBwtRBwr2151YPRUACZO23aSI7 hhyljQn1xKCXk39MC8d3ey2uVsomuMLympdJ7B58ojtPZQ0k/F7arUX6yd8PN1ntfbNQUP zB7ZSxtilDiDN12Cta0aTQJcbTO5qhOF9q2abYdKULc00RcjM0DYJLay16usnkqsogBW4B cc2xXBxjRJmvV9uwjJdxvTP8IzoskQR7puRurSovx0dZ8oxldRyhi7moIfwTEA== Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qqaiO-0000pD-6w; Wed, 11 Oct 2023 11:01:36 -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 1qqaiL-0000or-Qr for emacs-orgmode@gnu.org; Wed, 11 Oct 2023 11:01:34 -0400 Received: from ciao.gmane.io ([116.202.254.214]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qqaiJ-0002po-Op for emacs-orgmode@gnu.org; Wed, 11 Oct 2023 11:01:33 -0400 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1qqaiG-0001eC-LB for emacs-orgmode@gnu.org; Wed, 11 Oct 2023 17:01:28 +0200 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: emacs-orgmode@gnu.org To: emacs-orgmode@gnu.org From: Uwe Brauer Subject: Re: [the cryptic @@#$7] Date: Wed, 11 Oct 2023 17:01:19 +0200 Message-ID: <87v8bd5hkw.fsf@mat.ucm.es> References: <87h6n1i84d.fsf@mat.ucm.es> <6522dbff.df0a0220.53465.d25c@mx.google.com> <871qe5hxed.fsf@mat.ucm.es> <87v8bhgidc.fsf_-_@mat.ucm.es> <6522e73e.1c0a0220.17022.1dfd@mx.google.com> Mime-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=sha256; protocol="application/pkcs7-signature" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cancel-Lock: sha1:HpD1Ko2M82dcljz+oM8V+WESzrw= Mail-Copies-To: never Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -15 X-Spam_score: -1.6 X-Spam_bar: - X-Spam_report: (-1.6 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.25, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no 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-Country: US X-Migadu-Flow: FLOW_IN X-Migadu-Scanner: mx1.migadu.com X-Migadu-Spam-Score: -1.82 X-Spam-Score: -1.82 X-Migadu-Queue-Id: D4CAD66149 X-TUID: k86vo2x342Z/ --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > Uwe Brauer writes: > The ref "remote(table1,@2$7..@>$7)" targets a range, containing all field= s of > colum 7. So, for each field, you get the same value: an array > containing all the field values: [22, 19, 19]. > See (info "(org) References"), in the section: > "Field coordinates in formulas" > "=E2=80=98@#=E2=80=99 is substituted with the row number of the field whe= re the > current result will go to". > With this formula, your remote reference targets the field, that is in > the same row number as the computed field in final. > Here is the same table, with some extra columns that show the > intermediate steps: > #+Name: final2 > | Name | Some | ResSh1 | What is '@#'? | Which ref? | > |--------+------+--------+---------------+------------| > | Smith | 4 | 22 | 2 | @2$7 | > | Miller | 4 | 19 | 3 | @3$7 | > | Wick | 4 | 18 | 4 | @4$7 | > |--------+------+--------+---------------+------------| > #+TBLFM: @2$3..@>$3=3Dremote(table1,@@#$7) > #+TBLFM: @2$4..@>$4=3D@# > #+TBLFM: @2$5..@>$5=3D'(concat "@" (format "%d" @#) "$" "7") Here is an example where the org-lookup-first method seems to fail #+begin_src=20 #+Name: Table1A | / | <> | <> | <> | <> | <> | <> | <> | | | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | E1Tot | |---+----------+-----+-----+-----+-----+-----+-------| | | Smith | 2 | 3 | 4 | 6 | 7 | 22 | | | Brown | 7 | 10 | 3 | 4 | 12 | 36 | | | Graham | 4 | 5 | 1 | 10 | 7 | 27 | | | Jones | 14 | 9 | 1 | 8 | 13 | 45 | | | Thompson | 14 | 4 | 11 | 9 | 11 | 49 | | | Walker | 3 | 11 | 5 | 3 | 6 | 28 | #+TBLFM: $8=3Dvsum($3..$7);f2 #+Name: Table2A | / | <> | <> | <> | <> | <> | <> | <> | | | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | E2Tot | |---+----------+-----+-----+-----+-----+-----+-------| | | Smith | 1 | 3 | 5 | 8 | 9 | 26 | | | Brown | 14 | 9 | 10 | 3 | 8 | 44 | | | Graham | 5 | 14 | 1 | 5 | 6 | 31 | | | Jones | 11 | 11 | 3 | 1 | 9 | 35 | | | Thompson | 7 | 10 | 3 | 9 | 5 | 34 | | | Walker | 2 | 3 | 3 | 10 | 2 | 20 | #+TBLFM: $8=3Dvsum($3..$7);f2 #+Name: Final1A | / | <> | <> | <> | <> | | | Name | E1Tot | E2Tot | Total | |---+----------+-------+-------+-------| | | Smith | nil | nil | 2 nil | | | Brown | nil | nil | 2 nil | | | Graham | nil | nil | 2 nil | | | Jones | nil | nil | 2 nil | | | Thompson | nil | nil | 2 nil | | | Walker | nil | nil | 2 nil | #+TBLFM: $3=3D'(org-lookup-first $2 '(remote(Table1A, @I$1..@II$1)) '(remot= e(Table1A, @I$7..@II$7)))::$4=3D'(org-lookup-first $2 '(remote(Table2A, @I$= 1..@II$1)) '(remote(Table2A, @I$7..@II$7)))::$5=3Dvsum($3..$4);f2 #+Name: Final2A | / | <> | <> | <> | <> | | | Name | E1Tot | E2Tot | Total | |---+----------+-------+-------+-------| | | Smith | 22 | 26 | 48 | | | Brown | 36 | 44 | 80 | | | Graham | 27 | 31 | 58 | | | Jones | 45 | 35 | 80 | | | Thompson | 49 | 34 | 83 | | | Walker | 28 | 20 | 48 | #+TBLFM: $5=3Dvsum($3..$4);f2::@3$3..@>$3=3Dremote(Table1A,@@#$8)::@3$4..@>= $4=3Dremote(Table2A,@@#$8) #+Name: Final3 | / | <> | <> | <> | <> | | | Name | E1Tot | E2Tot | Total | |---+----------+-------+-------+-------| | | Smith | 22 | 26 | 48 | | | Brown | 36 | 44 | 80 | | | Graham | 27 | 31 | 58 | | | Jones | 45 | 35 | 80 | | | Thompson | 49 | 34 | 83 | | | Walker | 28 | 20 | 48 | #+TBLFM: $3=3Dremote(Table1A,@@#$8)::$4=3Dremote(Table2A,@@#$8)::$5=3Dvsum(= $3..$4);f2 #+end_src > Bruno =2D-=20 Warning: Content may be disturbing to some audiences I strongly condemn Hamas terroristic attack on Israel. 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 kzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0yMzEwMTExNTAxMTla MCgGCSqGSIb3DQEJDzEbMBkwCwYJYIZIAWUDBAECMAoGCCqGSIb3DQMHMC8GCSqGSIb3DQEJBDEi BCBJLCNmcie++iVepSDMsHT7XHIer0SwWRefucQYtvYsbTANBgkqhkiG9w0BAQEFAASCAQAbd2yH Bv+pz3kT2+6QfSeAPAURotL4rTx4C0jM3EgBwE9HO64vlyKqubXwAvREFCMfZvneuhpKGfDfZWBh XoGwe8hYQqwPPSHiqneu/PnSIlbcJocmfdV/NUQQRPpiGf5chvMXAhR9nSWUal6ixDU7odHomaBU 4+wghnJFG/jZjv9XtHwyOMJv6KFvYsqvIcbs1n2fRFJTQBzalspdu1Ywbj+70XZE2PaoGmaos+yj FEq1nXwhj9e4UNFgDn6XFw3T0h0klqW75MBES+Ie/+KmQ3Mw0liZ2cmUrNjOyESPSnsGkWFud4oI WRfZje5UPKKKpR5N0l8SXxy7zToFogRzAAAAAAAA --=-=-=--