Re: Using Calc unit conversion functions in an Org Spreadsheet

[Simon Pugnet]

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

signature.asc
Description: PGP signature