From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id mHimL5Oyv2bAKwAAqHPOHw:P1 (envelope-from ) for ; Fri, 16 Aug 2024 20:12:03 +0000 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id mHimL5Oyv2bAKwAAqHPOHw (envelope-from ) for ; Fri, 16 Aug 2024 22:12:03 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=gnu.org ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1723839123; h=from:from:sender:sender:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post; bh=K5+laly8K2VHocD6kjrxc8M1c3zaDfSOQHXm1Ri3RMs=; b=HtJu5jVEyn1JVAsdZDOq1hhMxShX2Eunt/WK0CctPVXYO/uv7XEftBZtCuhB4I3b99Nxsh o9dw0NR8vk2Qkk0n5+sjz9JKeWFkIPkjZIsAxOniy4Y8JBxvW+eu5iazE5kK5pJsbFnmT3 XumWnmLKB5knRq9QetJuWaad+aKgucYrzPE1H94ivy7/ZBOj/BooYFzrD9i21vqdS/kKwj 4+WQkqpfHB2OLDtEYXtxo08T9gytWCThTiZRgKlfrG+vRv6DTWtDkrRgntf6Dl6n2Sl/ni pAduWIAVs4okZB0J0/8wg+280kfCVjfJxu4JubgnsnPUfbyYkIj8Ggwl0OOB8A== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=none) header.from=gnu.org ARC-Seal: i=1; s=key1; d=yhetil.org; t=1723839123; a=rsa-sha256; cv=none; b=qQ4XPrVuRUFrFvg3iNa/tLUJEzrkkCfLR8J06a6zhKibL11ossxooGqaa9UchUBfBsL7Bw zMptYSYWcU3kgcbmDIyCI4mvrJpCjtQdBsi0SCpajfOV1Xaq24UjU1nfR+lVlxI1B2WMWk cNgI7oSRZX0eKXit4MVc7yYjkhU6mgB6QTpRqsm71hoAmIbg+JO2ywZQHaVVcjYyIOYQMB NvcuVf6M449EQZIyy2nnoyNB/Xu0NsexdkTw3osx4luzq1EDaVM/I2NbhjY8b6NCDj2IPe 5V1RNWvyOC+eyCj6lNv15TQJeyi7KWyf9ODssTLfnLwrbhNInut/UGOwB4sI9A== Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 83AB26734C for ; Fri, 16 Aug 2024 22:12:03 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1sf3I1-0001DG-F0; Fri, 16 Aug 2024 16:11:13 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sf3Hy-0001AM-BE for emacs-orgmode@gnu.org; Fri, 16 Aug 2024 16:11:10 -0400 Received: from smtprelay04.ispgateway.de ([80.67.31.42]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sf3Hu-00072P-9Z for emacs-orgmode@gnu.org; Fri, 16 Aug 2024 16:11:09 -0400 Received: from [185.17.206.54] (helo=condition-alpha.com) by smtprelay04.ispgateway.de with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98) (envelope-from ) id 1sf3Hh-0000000014f-3vvG; Fri, 16 Aug 2024 22:10:54 +0200 Message-Id: <1183a28e8cff505c63c98878403e876d@condition-alpha.com> To: Ihor Radchenko Cc: emacs-orgmode@gnu.org, =?utf-8?Q?S=C5=82awomir?= Grochowski Subject: Re: Summation of effort estimates in columnview dblock In-Reply-To: <8734nc30dq.fsf@localhost> References: <87ikwcazd9.fsf@localhost> <6ce3ea5364e48afc79f8345c67111c63@condition-alpha.com> <8734nc30dq.fsf@localhost> Date: Fri, 16 Aug 2024 22:10:53 +0200 MIME-Version: 1.0 Content-Type: text/plain X-Df-Sender: YWxleGFuZGVyLmFkb2xmQGNvbmRpdGlvbi1hbHBoYS5jb20= Received-SPF: pass client-ip=80.67.31.42; envelope-from=alexander.adolf@condition-alpha.com; helo=smtprelay04.ispgateway.de X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-to: Alexander Adolf From: Alexander Adolf via "General discussions about Org-mode." Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN X-Migadu-Queue-Id: 83AB26734C X-Migadu-Scanner: mx13.migadu.com X-Migadu-Spam-Score: -6.97 X-Spam-Score: -6.97 X-TUID: wutVuvtFMpKf Ihor Radchenko writes: > Alexander Adolf writes: > [...] >> ---------------------------- Begin Quote ----------------------------- >> (54) >> If more than one summary type applies to the same property, the parent >> values are computed according to the first of them. >> ----------------------------- End Quote ------------------------------ >> >> At least for EFFORT, this seems ambiguous. I can have >> >> :format "%EFFORT %EFFORT{:}" >> >> and both columns are present, and computed differently, whereas the >> footnote can easily be read as hinting to the opposite. In fact, the >> footnote is correct for all time format properties _except_ EFFORT. > > Not sure here. %EFFORT should not count. I tried the following: > > #+COLUMNS: %EFFORT{mean} %EFFORT{+} > * Foo > :PROPERTIES: > :EFFORT: 15.0 <-- gets updated > :END: > ** Bar > :PROPERTIES: > :EFFORT: 20 > :END: > ** Baz > :PROPERTIES: > :EFFORT: 10 > :END: > [...] Consider this example: ---------------------------- Begin Quote ----------------------------- #+BEGIN: columnview :maxlevel 2 :indent t :format "%ITEM(Task) %EFFORT(Estimated) %EFFORT(Estimated Total){:} %Time_Estimate(TE) %Time_Estimate(TE 2){:} %CLOCKSUM(Clocked) %CLOCKSUM(Clocked Total){:}" :id global | Task | Estimated | Estimated Total | TE | TE 2 | Clocked | Clocked Total | |--------------+-----------+-----------------+----+---------+---------+---------------| | Task 1 | 2d | 7d 0:00 | 2d | 7d 0:00 | 9d 0:00 | 9d 0:00 | | \_ Task 1.1 | 3d | 3d | 3d | 3d | 3d 0:00 | 3d 0:00 | | \_ Task 1.2 | 4d | 4d | 4d | 4d | 4d 0:00 | 4d 0:00 | #+END: * Task 1 :PROPERTIES: :EFFORT: 2d :TIME_ESTIMATE: 2d :END: :LOGBOOK: CLOCK: => 16:00 :END: ** Task 1.1 :PROPERTIES: :EFFORT: 3d :Time_Estimate: 3d :END: :LOGBOOK: CLOCK: => 24:00 :END: ** Task 1.2 :PROPERTIES: :EFFORT: 4d :Time_Estimate: 4d :END: :LOGBOOK: CLOCK: => 32:00 :END: ----------------------------- End Quote ------------------------------ The EFFORT and TIME_ESTIMATE properties for "Task 1" will never get updated for as long as the column specification without summary comes first. Swap the order of columns for EFFORT, or TIME_ESTIMATE, and the respective property of "Task 1" will get updated. Thus, the computation of the parent values is done as expected. The only thing that seems determined by the first column specification for a property, is the updating of the parent property's value. In that light, I think it could seem helpful, in addition to the three other changes I had suggested, to update the wording of footnote 54, too. "Parent values" seems ambiguous, as it could be read as referring to the values in the table, whereas my experiments seem to hint to it rather referring to the value of the parent's property. Looking forward to your thoughts, --alexander