emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Spreadsheet formula evaluation without using tables?
@ 2014-01-16 21:47 Asif
  2014-01-17  8:59 ` Bastien
  0 siblings, 1 reply; 2+ messages in thread
From: Asif @ 2014-01-16 21:47 UTC (permalink / raw)
  To: emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 524 bytes --]

Is it possible to have a list of tasks each with a formula to track
progress in percentage based on other subtasks? The result will look like
this:

* [ 30%] Project Name
** [ 50%] Task A
** [ 10%] Task B

This is what my formula in lisp will look like:

** [**(format "%3d" (+ (* TASKA 0.5) (* TASKB 0.5) ))**%] Project Name*
*** [**(format "%3d" *(setq TASKA 50)
*%] Task A*
*** [**(format "%3d" *(setq TASKA 10)


*%] Task B*
All I need to do is evaluate the code in org-mode to get the result.
Is this possible?

_
Asif

[-- Attachment #2: Type: text/html, Size: 2566 bytes --]

^ permalink raw reply	[flat|nested] 2+ messages in thread

* Re: Spreadsheet formula evaluation without using tables?
  2014-01-16 21:47 Spreadsheet formula evaluation without using tables? Asif
@ 2014-01-17  8:59 ` Bastien
  0 siblings, 0 replies; 2+ messages in thread
From: Bastien @ 2014-01-17  8:59 UTC (permalink / raw)
  To: Asif; +Cc: emacs-orgmode

Hi Asif,

Asif <asif.haswarey@gmail.com> writes:

> Is it possible to have a list of tasks each with a formula to track
> progress in percentage based on other subtasks? The result will look
> like this:
>
> * [ 30%] Project Name
> ** [ 50%] Task A
> ** [ 10%] Task B

You cannot do this with Org percentage cookies, but you can do it
by using a dedicated property.  The property for each entry would
contain a percentage value, then the column sum can display a formula
of your own.

See the manual and this turorial
http://orgmode.org/worg/org-tutorials/org-column-view-tutorial.html
for a start.

-- 
 Bastien

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2014-01-17  9:00 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2014-01-16 21:47 Spreadsheet formula evaluation without using tables? Asif
2014-01-17  8:59 ` Bastien

Code repositories for project(s) associated with this inbox:

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).