[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Calc: Multiply time (hours) with a float
From: |
Karl Voit |
Subject: |
[O] Calc: Multiply time (hours) with a float |
Date: |
Thu, 8 Sep 2016 10:33:37 +0200 |
User-agent: |
slrn/pre1.0.0-18 (Linux) |
Hi!
I do have following situation: I'd like to multiply a float with hours
which results in an error, obviously. However, I was not able to find
out how to do it.
Minimal example with expected product:
| time [h:m:s] | value | product |
|--------------+---------+-----------|
| 09:15:00 | 2.54321 | 23.524693 |
#+TBLFM: @2$3=$2*$1
In case you have time and energy to go deeper in my rabbit hole:
My real world example which is a bit more complex in case you want to
find a totally different way (workaround?) of calculating the stuff I
need:
First table determines the reference hours per day of my lawn mowing
robot with the current program:
#+NAME: robot-program
| Status As Of | Start | End | Start | End | Hours/Day |
|------------------+-------+-------+-------+-------+-----------|
| <2016-06-30 Thu> | 11:30 | 19:30 | 20:30 | 21:45 | 09:15:00 |
#+TBLFM: $6=($3-$2)+($5-$4);T
Second table holds the logged number of hours of work for certain time
stamps (first three columns). The thing I want to calculate is the
number of hours the robot was *supposed* to work. Unfortunately, the
robot gets stuck from time to time and therefore the logged working
hours differ from the theoretical working hours (reference).
For a better understanding, I split the calculation of $6 (my desired
comparison value) and added $4 (the daily hour reference value) and $5
(difference between the current row and the previous one in time).
Current situation with the ERROR:
| Date | Hours | Difference [h] | Daily Reference |
Difference [Days] | Reference Comparison [h] |
|------------------------+-------+----------------+-----------------+-------------------+--------------------------|
| <2016-08-13 Sat> | 100 | 100 | |
| |
| <2016-08-20 Sat 14:40> | 217 | 117 | 09:15:00 |
7.611111 | #ERROR |
| <2016-08-27 Sat 19:08> | 245 | 28 | 09:15:00 |
7.186111 | #ERROR |
#+TBLFM: $3=$2-subscr(@<$2..@>$2, @# - 1);N ::
@3$4..@>$4=remote(robot-program,@>$6);T :: @3$5..@>$5=($1 - subscr(@<$1..@>$1,
@# - 1)) :: @3$6..@>$6= $5 * $4
Desired output:
| Date | Hours | Difference [h] | Daily Reference |
Difference [Days] | Reference Comparison [h] |
|------------------------+-------+----------------+-----------------+-------------------+--------------------------|
| <2016-08-13 Sat> | 100 | 100 | |
| |
| <2016-08-20 Sat 14:40> | 217 | 117 | 09:15:00 |
7.611111 | 70.402777 |
| <2016-08-27 Sat 19:08> | 245 | 28 | 09:15:00 |
7.186111 | 66.471527 |
Nitpicking: yes, comparing reference*hours (of whole days) to log
values which were logged in-between working hours is not exact even
with zero percent stuck time. I'd like to have just a rough
comparison.
So if my desired output can be derived without multiplying hours to
floats: I'm open ;-)
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
- [O] Calc: Multiply time (hours) with a float,
Karl Voit <=
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/11
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/11
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/18
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Karl Voit, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Michael Welle, 2016/09/19
- Re: [O] Calc: Multiply time (hours) with a float, Nick Dokos, 2016/09/19