From mboxrd@z Thu Jan 1 00:00:00 1970 From: Daniel E. Doherty Subject: Re: CLOCKTABLE multiply time expended by hourly rate? Date: Thu, 21 Jul 2011 14:13:09 -0500 Message-ID: <878vrr30sa.wl%ded-law@ddoherty.net> References: <87y5zsws3j.wl%ded-law@ddoherty.net> <83sjpzc2of.fsf@yahoo.it> <87sjpzlt5x.wl%ded-law@ddoherty.net> <83hb6fbvpo.fsf@yahoo.it> <87oc0nwrv9.wl%ded-law@ddoherty.net> Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:38344) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qjygg-0000hb-VT for emacs-orgmode@gnu.org; Thu, 21 Jul 2011 15:13:40 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Qjygf-0000v8-0x for emacs-orgmode@gnu.org; Thu, 21 Jul 2011 15:13:34 -0400 Received: from mail-yw0-f41.google.com ([209.85.213.41]:51666) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qjyge-0000ux-TK for emacs-orgmode@gnu.org; Thu, 21 Jul 2011 15:13:32 -0400 Received: by ywm39 with SMTP id 39so905627ywm.0 for ; Thu, 21 Jul 2011 12:13:32 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Jonathan Leech-Pepin Cc: Org-mode List Thanks, Jonathan. That was it. I updated to 7.6 and now all is well. At Thu, 21 Jul 2011 12:34:15 -0400, Jonathan Leech-Pepin wrote: >=20 > Hi, >=20 > Which version of Org are you using? >=20 > 7.6 (archive from org) with very few org-related customizations (Emacs-St= arter-Kit > along with one or two small changes) behaved properly. >=20 > I took your original table and updated the formulas and the values behave= d as whole > numbers rather than fractions >=20 > | Headline                               Â=  Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  | Time    | >        |      |       | > | > -----------------------------------------------------------------------+-= --------+-------+------+------- > | > | *Total time*                             Â=  Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  | *28:09* | >        |      |     0 | > | > -----------------------------------------------------------------------+-= --------+-------+------+------- > | > | Lawsuit for Debt Against Rose Funding, LLC (1016-cv18431)       =       | 28:09   | >        |      |     0 | > | Activities                              Â=  Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  |        = | > 28:09 |      |     0 | > | DONE Activity Log                           =                           |         | >        | 0:05 |   250 | > | DONE Draft Complaint for Damages                   Â=  Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  |         | >        | 5:40 | 17000 | > | DONE Meet with Kevin Jones and Elizabeth Bennett re Complaint     =     |         | >        | 0:32 |  1600 | > | DONE [#A] Motion for Appointment of Private Process Server      Â=  Â Â Â Â  |         | >        | 1:24 |  4200 | > | DONE [#A] File Affidavit of Service with Court            Â=  Â Â Â Â Â Â Â Â Â Â  |         | >        | 0:25 |  1250 | > | [2010-07-27 Tue 11:16] Phone call from Mark Sheister         Â=  Â Â Â Â Â Â Â  |         | >        | 0:11 |   550 | > | Research regarding compulsory counterclaim, res judicata       Â=  Â Â Â Â Â  |         | >        | 1:23 |  4150 | > | Work on brief in opposition to motion to dismiss.           =           |         | >        | 3:03 |  9150 | > | Prepared for Hearing                         Â=  Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  |         | >        | 0:24 |  1200 | > | Hearing on Case Status (Div 25:7th Flr) <2010-10-19 Tue 09:00>    Â=  Â Â  |         | >        | 0:30 |  1500 | > | Hearing on Motion to Dismiss <2010-11-30 Tue 09:00>          =          |         | >        | 1:15 |  3750 | > | Hearing on Motion to Dismiss <2010-12-21 Tue 09:00>          =          |         | >        | 1:09 |  3450 | > | Status Hearing <2011-01-25 Tue 09:00>                 =                 |         | >        | 1:31 |  4550 | > | Status Hearing <2011-04-26 Tue 09:00>                 =                 |         | >        | 1:42 |  5100 | > | Called Kevin [[bbdb:Stacy]].  Left voicemail to call re settlement off= er. | >          |       | 0:04 |   200 | > | DONE Call [[bbdb:Sheister]] with counter offer.            =                | >          |       | 0:06 |   300 | > | [#B] Draft Interrogatories for Rose, Swords              =              |         | >        | 4:48 | 14400 | > | Argo Status Hearing <2011-06-28 Tue 09:00>              Â=  Â Â Â Â Â Â Â Â Â Â Â Â  |         | >        | 1:09 |  3450 | > | Letter of Discovery Deficiencies                   Â=  Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  |         | >        | 2:48 |  8400 | > #+TBLFM: $5=3D$4*50;Df2 >=20 > Not sure where the issue might be in your case, however the formula shoul= d behave > correctly. >=20 > Jonathan >=20 > On Thu, Jul 21, 2011 at 11:55, Daniel E. Doherty w= rote: >=20 > At Thu, 21 Jul 2011 15:37:55 +0200, > Giovanni Ridolfi wrote: > > > > Daniel E. Doherty writes: > > > > > That's certainly thinking outside the box, but I don't think it > > > works. > > > > Actually, Daniel you don't have to *think*, you've to demonstrate > > that it works or that it doesn't /tertium non datur/. > > > > > In your example, 1:09 represents 1/9th in calc's fraction mode, > > > not 1+9/60 which it would have to in order to compute with it. > > Not with GNU/Emacs 23.3 calc. > > > > If you bill 50 per 1 hour, you bill > > > > (/ 50 60.0 ) is 0.83 per minute. > =20 > Agreed. > =20 > > > > If you bill 1 hour + 9 minutes it is 69 minutes > > > > (* 0.83 69) 57.269999999999996  =3D 57.27 > > > > isn't it ? > > > =20 > It is. > =20 > > And the fifth column in my table (see below) does compute 57.27 or = not? > > > =20 > Not.  At least when I do it.  Here's what I get after recalcing you= r example. > =20 > | Argo Status Hearing <2011-06-28 Tue 09:00> |   |   | 1:09 | 0.09 | > | Letter of Discovery Deficiencies           |   |   | 2:48 | = 0.03 | > #+TBLFM: $5=3D$4*0.83;Df2 > =20 > Maybe I have a different mode setting or something.  You seem to have > the $4, or 1:09, being interpreted as 69, but I have it being > interpreted as a calc fraction, i.e., 1/9 =3D 0.11111111.  So 0.83 * > 0.111111 gives me 0.9259, which rounds to 0.9. > =20 > >    You may say: "Ah but this is only one example, you've been luc= ky!" > > > =20 > I would. > =20 > >  I reply, what about the second line? > > > > (* (+ 120 48) 0.83) =3D 139.44 > > > > Calc is *really* smart, isn't it? > =20 > Undoubtedly.  Apart from Org, my favorite features of Emacs.  I'm > waiting for vi to duplicate that functionality. > =20 > Thanks for taking the time to look at this. > =20 > > > > cheers, > > Giovanni > > > > > > > > Regards, > > > > > > At Thu, 21 Jul 2011 13:07:28 +0200, > > > Giovanni Ridolfi wrote: > > >> > > >> Daniel E. Doherty writes: > > >> > > >> > Hi all, > > >> > > > >> > I am trying to use orgmode to bill for time.  My idea is to a= dd a column > > >> > that multiplies the elapsed time column by an hourly rate. > > >> > > >> what about using a minute rate? > > >> > > >> (/ 50 60.0) 0.83 so: > > >> > > >> | Argo Status Hearing <2011-06-28 Tue 09:00> |   |   | 1:09 | =  57.27 | > > >> | Letter of Discovery Deficiencies           |   |   | 2:= 48 | 139.44 | > > >> #+TBLFM: $5=3D$4*0.83;Df2 > > >> > > >> >=20 >=20