all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
From: Simon Pugnet <simon@polaris64.net>
To: Eric S Fraga <e.fraga@ucl.ac.uk>
Cc: help-gnu-emacs@gnu.org
Subject: Re: Using Calc unit conversion functions in an Org Spreadsheet
Date: Fri, 17 Nov 2023 07:32:07 +0000	[thread overview]
Message-ID: <87msvcal8o.fsf@polaris64.net> (raw)
In-Reply-To: <878r6zngoc.fsf@ucl.ac.uk> (Eric S. Fraga's message of "Wed, 15 Nov 2023 16:07:47 +0000")

[-- Attachment #1: Type: text/plain, Size: 714 bytes --]

Eric S Fraga <e.fraga@ucl.ac.uk> writes:

> How about the following:
>
>
> | Task    | Time estimate | alternative | Rounded hours | CPH         | Cost          |
> |---------+---------------+-------------+---------------+-------------+---------------|
> | Task #1 | 1 hr + 35 min | 1.5 hr      | 1.75 hr       | 50 GBP / hr | 87.5 GBP      |
> | Task #2 | 0 hr + 20 min | 0.25 hr     | 20. min       | 50 GBP / hr | 16.666667 GBP |
> #+TBLFM: $3=round($-1/(15 min))*hr/4;u::$4=usimplify(ceil($2*4)/4)::$6=usimplify($5*$4)
>
> (see new column "alternative")

Thanks Eric, that works nicely. Thanks too for reminding me about the
units simplification mode (;u), that saves calls to usimplify.

Kind regards,

Simon

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 861 bytes --]

  reply	other threads:[~2023-11-17  7:32 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2023-11-15 10:52 Using Calc unit conversion functions in an Org Spreadsheet Simon Pugnet
2023-11-15 16:07 ` Eric S Fraga
2023-11-17  7:32   ` Simon Pugnet [this message]
2023-11-16  7:28 ` Michael Heerdegen
2023-11-17  7:36   ` Simon Pugnet

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87msvcal8o.fsf@polaris64.net \
    --to=simon@polaris64.net \
    --cc=e.fraga@ucl.ac.uk \
    --cc=help-gnu-emacs@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body. 
Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.