From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ken Mankoff Subject: Re: Preparing a cost estimate with Org Date: Thu, 24 Jan 2019 08:41:51 -0800 Message-ID: <87womugg8g.fsf@geus3064linuxwsm.geus.dk> References: <87sgxi2ghw.fsf@metapensiero.it> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([209.51.188.92]:55594) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gmiK2-0005gI-8N for emacs-orgmode@gnu.org; Thu, 24 Jan 2019 11:57:50 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gmi4g-00012w-HD for emacs-orgmode@gnu.org; Thu, 24 Jan 2019 11:41:55 -0500 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]:34207) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1gmi4g-00011d-Ae for emacs-orgmode@gnu.org; Thu, 24 Jan 2019 11:41:54 -0500 Received: by mail-pl1-x62d.google.com with SMTP id w4so3150661plz.1 for ; Thu, 24 Jan 2019 08:41:54 -0800 (PST) In-reply-to: <87sgxi2ghw.fsf@metapensiero.it> 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" To: Lele Gaifax Cc: emacs-orgmode@gnu.org Hi Lele, On 2019-01-24 at 07:59 -0800, Lele Gaifax wrote... > The only problem with this approach is that it requires a manual > intervention to build the "cost estimate" table: first I recompute the > "efforts" one with C-c C-c, then I copy its body to the other table, > delete the third column and eventually do a C-c C-c on its TBLFM to > recompute the costs. You could perhaps do this with code, so it is only one C-c C-c? Alternatively, is OrgAggregate useful? https://github.com/tbanel/orgaggregate > Is there a more efficient/automatic way to achieve a similar result? I > mean, is there a way to > > b) filter out entries with a particular tag/property, so that I can > keep the original estimate Here is a hack to filter clock entries by tag: https://lists.gnu.org/archive/html/emacs-orgmode//2009-09/msg00205.html Finally, the Clock Table documentation https://orgmode.org/manual/The-clock-table.html mentions ‘:match’ with link to https://orgmode.org/manual/Matching-tags-and-properties.html#Matching-tags-and-properties which lets you do negative matches in one of their examples. Can you include only relevant tags, or exclude the tags you want to exclude using that syntax? -k.