From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id wGK4OJzxlmNo1gAAbAwnHQ (envelope-from ) for ; Mon, 12 Dec 2022 10:17:16 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id kKvCOJzxlmMGwAAA9RJhRA (envelope-from ) for ; Mon, 12 Dec 2022 10:17:16 +0100 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 868409E29 for ; Mon, 12 Dec 2022 10:17:15 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1p4esa-0004ln-E4; Mon, 12 Dec 2022 04:13:44 -0500 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 1p4esW-0004iL-L6 for emacs-orgmode@gnu.org; Mon, 12 Dec 2022 04:13:40 -0500 Received: from mail-vi1eur05on20723.outbound.protection.outlook.com ([2a01:111:f400:7d00::723] helo=EUR05-VI1-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1p4esU-0003Pt-JI for emacs-orgmode@gnu.org; Mon, 12 Dec 2022 04:13:40 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=CVrjSm46bfdCFjvhXnjC0S9hMi1onQLYhQVPy1DHRXOaROqG2BS9l20LVG4GeqenvPpkHJqF0vW+nR5MS09hoJJJmlBLkdpG+XHx8esh+lgNxSUbSJ3AF43huw70uRjBryJy2io+tP891sOfL2VdNTZjosuxFrt+7BMOc90CnIkCyxxEetMeE6BlmKpg3TJsDwUQH3/y0B5WMBLsgT+/zWusC5RAm4XQ31h9v9Ra4761/dDJqwwOc0yxg5cR7YY1RfU6PefvAUYy0Xb5mT6lSuH/6bn1DbxeW1ak3K7GbN9/EH2kQoNY/gtXUHS5S/ROVNjapq3osnkUMoHdyuEBTA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=opWtjIMt3IjJ5Ht7pBNYkFJbReoCvgvQRDVZymxcoeY=; b=JcoWMQeGPDLpeWW0GwNdPd1rGYH3pR8nGRM0llg7jwb4oY3C0/kAhxcgKnRRq1QYldHyTd1F2lsZCpBekTjQAXV68Wd5Qw6P5HKDt6Nmu4TnTPpoO+w4i0DBNPPm67r+WpSuvdihdurf36Q933TNUkC6Uq6/VbPySNpMG4Lq4voVxMYuVkFaUKJwFv33MBbqcwQyFmgSnZuZwQoruQsc8KoxpPclusNUmqYbG5zW/BEW5FR7SJfOQc3FkNu275U6yp72BK9dvw3RcfgwV99jw+uvF6/Y0d5VOsfxLp/Y7vvA6KumDQ5fi1qUoBhXxTyfW4qQbXmDNAVFPDfIpTb/Jg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucl.ac.uk; dmarc=pass action=none header.from=ucl.ac.uk; dkim=pass header.d=ucl.ac.uk; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucl.ac.uk; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=opWtjIMt3IjJ5Ht7pBNYkFJbReoCvgvQRDVZymxcoeY=; b=ELsbP1TzTSeVgwHl/osOqPTueWE5Gnzd8Vw0O6iYtiNF4oKbDuljQpR7slZDrWgqe8kvehzFxc1rc8j5YWHrIuFMGOw7dBXE2n6ZzCJG+2r6Ct4YPh0ElyTN8EUSQc5vQrfHHY4iVM41SwbU6BJ7yB+2OYuPjqWA32sjLfZzL6Y= Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4fa::21) by AS4PR01MB9304.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4c8::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5880.19; Mon, 12 Dec 2022 09:08:32 +0000 Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::b0ca:c597:4dc2:a2a7]) by AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::b0ca:c597:4dc2:a2a7%6]) with mapi id 15.20.5880.019; Mon, 12 Dec 2022 09:08:32 +0000 From: "Fraga, Eric" To: Ypo CC: Org-mode Subject: Re: To convert and simplify units in tables Thread-Topic: To convert and simplify units in tables Thread-Index: AQHZDglOzyOV16AitU2fvE/CLXwRsg== Date: Mon, 12 Dec 2022 09:08:32 +0000 Message-ID: <87sfhlat0w.fsf@ucl.ac.uk> References: <2ff2b255-029d-c0f4-6102-0e4482b53b63@gmail.com> In-Reply-To: <2ff2b255-029d-c0f4-6102-0e4482b53b63@gmail.com> (Ypo's message of "Sun, 27 Nov 2022 20:19:42 +0100") Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Gnus/5.13 (Gnus v5.13) x-url: http://www.ucl.ac.uk/~ucecesf/ mail-followup-to: Org Mode List x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AS4PR01MB10249:EE_|AS4PR01MB9304:EE_ x-ms-office365-filtering-correlation-id: db568702-aff9-4a15-06c1-08dadc20713d x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: nLnh0NnCX3AqQslpaubDUL1hGBVuchK4VLBjAI8WiNW9H3VPGLz6dVr+F6iIoJfQz5pZwIVtTo12uNRlY3eL8pVcRzGO0meJV71s92mXDJukmofGL6S9aQbc9Bi12rAYjpFtiMIq1XxE9+weJu4pBIaqSk7YGewyRUP98P5opeF4HbX0MBefEO3cILp5g/sR0tBWduelQH6iIr7foK7FgCEuKJ7MMDoSp6YK6tnI0GAt3m00Z6k13wppwrBNEdYdRUD3gzm0GBFwlE8lxzkpZnAikM+AlEkFnGVU+CEZEZd6HWbF1AjVrk80ZiRZ8kY4BuyZGtLjUlAJ5TVHDx+hB2OaqI+nXurIPy4nkveCZKsur/GNMGwN4yZeeADV3bezaLf+6qwzzg931btJ1TR5O4Xcu1TbtH68NUlaPgZGYqG22BkWyhYnwG6tYwc0Oygk8Z7ZRgBusCNj8FtY6B26yuZV829+uCbqwvmO+uqnOA66+bENXQwdSi3UDa2jiIr7Kqg/ByguMVqvQoe4At7er8UPZTnkVQS9THxUYZ8f+1HT5Lz9qktia5CcGREOQ4H+DIQLKOfPOgM82qD3n9AuujgX6X5DoEPMmENNvYeZek4V6xtb7uaU4WRA+J46MmIl/y5LLexSefmcSrdwamJqopnHYK0Rr1dvBFigO76N/9/Uk7Kr37MXvlWor2dR8ykgzoxOUnIAyWhfeRak3SgpcA== x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:AS4PR01MB10249.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(13230022)(4636009)(366004)(346002)(39860400002)(136003)(396003)(376002)(451199015)(64756008)(66446008)(66556008)(36756003)(66476007)(8936002)(66946007)(26005)(76116006)(6512007)(2906002)(186003)(6486002)(122000001)(2616005)(38100700002)(91956017)(38070700005)(4744005)(6916009)(786003)(5660300002)(316002)(71200400001)(478600001)(8676002)(6506007)(4326008)(41300700001)(86362001); DIR:OUT; SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?bZ7wAS8awEzVCayfPyTcELExoh63NrolrOMunifB9j6cbEBAIy6j0F/Ppw?= =?iso-8859-1?Q?CubM4pZkr150AvYGLKCmbn3NADoEaJWOlD1zZmybQrw/XCHLL5M2wymajr?= =?iso-8859-1?Q?DZuxsoFTMr8zCFKPuWOwoqtO78wGDT+zJZnBJrOBUBywQmaBVPtdrhBiIT?= =?iso-8859-1?Q?Z3dZ85DT1XsoBUVKHi/14ioXJDYzBm4Apmr6nBKFzup8T4tVecpiZdNVVt?= =?iso-8859-1?Q?Q+7bDO5lH51BjOJiepnPjCUf3xS06vKddmaQ+ULDzMS5534xAqyxSkHELr?= =?iso-8859-1?Q?s8FE1/1NZhq5epdofoRMRebYIMkX2lAYGLil5T3501Adook+cLi56C+X8o?= =?iso-8859-1?Q?Z/AO71pF3DWbIHLpB7X8ZqcOHQV2D1mqLRm3/tUMkECWGGTLSrh2M1i5Rw?= =?iso-8859-1?Q?eZCOiQr+diiD4LCtjpHBG/USe1gtiE3/+zqUKystihPy5VbfpfOXDtljEL?= =?iso-8859-1?Q?24THy7I7E+RlWhpYwGRaOSyTY8B9QGXSv0kyopEv1IOMl9YgnN2j/DTCeE?= =?iso-8859-1?Q?E/ifSRUiNA8eb/XZkPRrfrQSzsTCDF87eQho/Pp8uJ3cy+BOULj2uIxvfg?= =?iso-8859-1?Q?bDMtbP05txGhmnsqnsSeHZ5wWhvQl11KarAdnWj7Td84AC22qFGaEv+WD+?= =?iso-8859-1?Q?H/gX1lCcli25j7doZjXuGQi7TYbxNIcp5Q3vsBkqt/hsu6RPb08PbLaXar?= =?iso-8859-1?Q?OK9G7DsFlXZwiyisuCcnrAn2SDsgoybUHOsyxE09P18DEnoq6o+/Y8qUW3?= =?iso-8859-1?Q?DpVwfjCpsIxTg2Wnxf8ppQsxJoOMEkKV1iB+6HfwQgN7/WyVfAHOqKjuoZ?= =?iso-8859-1?Q?uEsiIb45YF6PyRXjRIiuysqHP8ziWza8oX1pc/u+hU5d8+OpJH9MnHqvJH?= =?iso-8859-1?Q?6ZtgKBfzbAEi+590BWIfzg3wSkJlytmU4+/8xS2I5NnqzB+ddO9JK44A4W?= =?iso-8859-1?Q?mXoLk5SyfRndZeqrylzu7I5OxelpzhdGxGHB9OlJ5TcfhXwqqKTrSRLuz4?= =?iso-8859-1?Q?r9efoz9KoCKCpfOOl0WmGc+tmsZpg9eE9Bzq4IV/861y6Ncbk+GT+QO+s2?= =?iso-8859-1?Q?M26Hz2SVOpofw5WyDmhFqEGTWe9zWJpKZYIytBdJVAE3MDr+otbzNtI4tY?= =?iso-8859-1?Q?c1h9DX5SDOeJWZlGSOfFBWByIRV/SMId+SW3KdfsoZATyZQVRrNEtPwOpi?= =?iso-8859-1?Q?eEOj/dd4Hmu+hxai2jLSg0X7H5+iP5dwp3n0g4YPQATUa/LNPp2XCKaScg?= =?iso-8859-1?Q?59Yp4h3DYh3GjWKKj6sfjVBNOX+Z8mExjq174YRNOXCvCymLKKspkKbUjF?= =?iso-8859-1?Q?FGS96+0fLk+BNzuYCUqAdvEa/TgHbAYZ0IuWZql4e0esazusWR+Tt+U7qd?= =?iso-8859-1?Q?hWsp4Qs3TL3Pk/b9zsNWg8XgLLrlG/DyKMJap66EUxlj58pV7g0dpKG672?= =?iso-8859-1?Q?SOxoogsxTuBKOZlIiRml6geyIh6JBD4QFIi4QrOK5T8eGJn9qAGybeoWiB?= =?iso-8859-1?Q?glJmqoOhSxhs7HDo0nGZnhbQPsf+LWcbenjLZUywaEr8/i8idpHVg4fwgN?= =?iso-8859-1?Q?RmPeusKalqYwl3mRzcpaiunGwPDqAs9vWgLw8YfIx/SrHmIluWCZukYiv+?= =?iso-8859-1?Q?4hJBVBZdGBoVGS9dTYrLLJ6H8EpgCyndz2?= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS4PR01MB10249.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: db568702-aff9-4a15-06c1-08dadc20713d X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Dec 2022 09:08:32.3079 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 1faf88fe-a998-4c5b-93c9-210a11d9a5c2 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: K8s10m8yUVZWtKO2atlIHY2B4/GKr6p3/pZ0I892EgQehld7unR0vUcLaHasWYI1+ks/vTdplU5JF9afYxMnlg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS4PR01MB9304 Received-SPF: pass client-ip=2a01:111:f400:7d00::723; envelope-from=e.fraga@ucl.ac.uk; helo=EUR05-VI1-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-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-Country: US X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1670836636; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=opWtjIMt3IjJ5Ht7pBNYkFJbReoCvgvQRDVZymxcoeY=; b=iA0+iLJZyLWUtWubaBYmsyOBrDFiqMC3cKOY3Gj5s279uz6B3J7GPzGb9AQ5OeymAhG7Ui GrKpQwdSdPA0VseIgWdVuW5wyfU1lVJzkqK91ExIO25t/+w21xKGk47yTLWCAS5oCBvNzY mBs2GT/6TgrBFphkveZ65wWn8w3pbI6ypKGlsARp/humrRD7EeE7J8GJQxSpHslMfN9ryh vV0rF+7LU6/TzVUxOZdJbdBuKql9sA3tXIhyuArc+CSMIFtK0yNxr/GuUqBWSPyo5uxW0G 2qtNeEH37/LkosoALhI+wogP0Gm3m9UzLHgIWi9hdeJ5JDJz0AEcWXr+D6zH+g== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=ELsbP1Tz; arc=pass ("microsoft.com:s=arcselector9901:i=1"); 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"; dmarc=pass (policy=none) header.from=ucl.ac.uk ARC-Seal: i=2; s=key1; d=yhetil.org; t=1670836636; a=rsa-sha256; cv=pass; b=T0i9lS1VC19fejAarIBpSRQsqOE21lw00EkxF1DIZ5XQXeGqQdLIxxKASsudvDILtc1FcP gp0fHg94zklNRLTzvMzu9HvD/7PwT68lxxxTtZnsCrcCMud4kpy5BSw0oEK7Yc0vRC863W pbEsi0BheV1hsdko15W8IM2eg8Vuxx/uiEe+XbCl5w8v/d+OVK+jW7tUsIcGtIV25YMsRr x/NpwmM56dYv8esaMi3vE3SMyvRPprDFJmbfWw705BWN7EWvwiDu0l9qaCNlulGNFhmEab fq5mtAxdqhH28KhQ0nVAtwoI7CRyspP/it5ZDbOxElwnuRLkmhKu3PqoXJHL0w== X-Migadu-Spam-Score: -8.25 X-Spam-Score: -8.25 X-Migadu-Queue-Id: 868409E29 X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=ELsbP1Tz; arc=pass ("microsoft.com:s=arcselector9901:i=1"); 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"; dmarc=pass (policy=none) header.from=ucl.ac.uk X-TUID: Gjal9ztiKIEg On Sunday, 27 Nov 2022 at 20:19, Ypo wrote: > The alternative way I am trying is using an org-table. It is not > literate programming, but it is a spreadsheet with units ;D > [...] > Now, in a more practical case, I have some problems with units: > > | $ | E =3D 2141404.05 kg/cm^2 | > | $ | s_lim =3D 275 N/mm^2 | > | $ | s_lim =3D 2800 kg/cm^2 | > | $ | W =3D 10000 kg | > | $ | l =3D 65 cm | > | $ | I =3D 25166 cm^4 | > | $ | Z =3D 1680 cm^3 | > | _ | s | > | | 386.90476 kg cm / cm^3 | > | _ | cs | > | | 7.2369231 kg cm^3 / (cm^2 kg cm) | > > #+TBLFM: $s=3D$W*$l/$Z::$cs=3D$s_lim/$s org tables do have support for units, based on Emacs Calc. You need to add the "u" option to the formulas for this support. If I change your formulas to: #+TBLFM: $cs=3D$s_lim/$s;u::$s=3D$W*$l/$Z;u everything seems to work just fine. =20 --=20 : Eric S Fraga, with org release_9.6-14-g53814a in Emacs 30.0.50=