Henri-Paul Indiogine writes:
> Dear Orgmoders:
>
> I would like to use org-mode spreadsheet for my small business. I would
> like to have some type of ledger with running balance.
>
> I have done this sort of calculation with many spreadsheets
> e.g. OpenOffice Calc, but I am not able to do so w
Dear Orgmoders:
I would like to use org-mode spreadsheet for my small business. I would
like to have some type of ledger with running balance.
I have done this sort of calculation with many spreadsheets
e.g. OpenOffice Calc, but I am not able to do so with org-mode.
This is what I would like to
On Thu, Dec 2, 2010 at 11:29, Antony wrote:
> I have table like
>
> | foo | amount |
> |---+|
> | | <5> |
> | hello | 100 |
> | again | 200 |
> | once more | 300 |
> | | |
> | | |
>
> I need to be able sum those
Hi
I have a simple need (from a requirement description point).
I have table like
| foo | amount |
|---+|
| |<5> |
| hello |100 |
| again |200 |
| once more |300 |
| ||
| ||
I need to be able sum those
Carsten Dominik wrote:
> Hi Nick, these are useful functions, thanks! Maybe add the to org-hacks?
You mean here?
http://orgmode.org/worg/org-hacks.php
I didn't know about that, thanks. My initial question is "how?" but I see
there is some information here:
http://orgmode.org/worg/worg-abou
Hi Nick, what is the purpose of resending this message?
- Carsten
On May 14, 2010, at 4:44 PM, Nick Stokoe wrote:
Earlier I wrote:
There seem to be two problems;
c) Summing HH:MM values (which org-table-sum seems to manage -
although oddly
without including the minutes - but not vsum)
Earlier I wrote:
> There seem to be two problems;
>
> c) Summing HH:MM values (which org-table-sum seems to manage - although oddly
> without including the minutes - but not vsum)
Excuse me answering my own question, but time is money, and so I've hastily
written my own elisp functions to d
Hi Nick, these are useful functions, thanks! Maybe add the to org-
hacks?
Also, I could think of generalizations:
Allow 94h and 94:16h and 94:16:22h.
I would, in fact, strip the "h" and just use 94:16
- Carsten
On May 14, 2010, at 4:49 PM, Nick wrote:
Earlier I wrote:
There seem to be tw
On May 14, 2010, at 11:59 PM, Stephan Schmitt wrote:
Hi Nick,
are you aware of the table editor? Type C-c ' (single quote) when
the point is somewhere in the table.
And, if you have a longish elisp formula, press TAB in the first line
of the formula to get the formula spread over multip
Stephan Schmitt wrote:
> are you aware of the table editor? Type C-c ' (single quote) when the
> point is somewhere in the table.
Thanks - I did use it once or twice, and indeed it does makes it easier to edit
the formulae, but doesn't seem to prevent the resulting +TBLFM line from
disappearing o
Hi Nick,
are you aware of the table editor? Type C-c ' (single quote) when the
point is somewhere in the table.
Greetings,
Stephan
Also sprach Nick:
ps I wonder if a long set of formulae like this could be split over several
+TBLFM lines? The answer seems to be no.
__
Earlier I wrote:
> There seem to be two problems;
>
> c) Summing HH:MM values (which org-table-sum seems to manage - although oddly
> without including the minutes - but not vsum)
Excuse me answering my own question, but time is money, and so I've hastily
written my own elisp functions to d
Hi,
Having used orgmode to track my TODO list and related working hours, I have been
trying to use it to work out my invoices.
Although the spreadsheet is quite neat, I have been having trouble getting it to
do some things. In particular, after reading the manual I initially thought I
could, but
On Sun, 4 Apr 2010 15:19:06 -0500, Russell Adams wrote:
> On Sun, Apr 04, 2010 at 12:46:28PM -0400, Xiao-Yong Jin wrote:
>> I have an idea. We can leave the original table intact,
>> while making a new dynamically generated table derived from
>> the original one.
> The org-babel idea was the do
On Sun, Apr 04, 2010 at 12:46:28PM -0400, Xiao-Yong Jin wrote:
> I have an idea. We can leave the original table intact,
> while making a new dynamically generated table derived from
> the original one.
The org-babel idea was the do similar, but again you will not have the
ability to edit the dat
On Sun, 4 Apr 2010 09:01:30 +0200, Carsten Dominik wrote:
> On Apr 2, 2010, at 10:16 AM, Russell Adams wrote:
>> On Fri, Apr 02, 2010 at 09:49:46AM +0200, Carsten Dominik wrote:
>>>
Would it be feasible to "narrow" a table by criteria on a specific
field in between separators? Ie: only
On Apr 2, 2010, at 10:16 AM, Russell Adams wrote:
On Fri, Apr 02, 2010 at 09:49:46AM +0200, Carsten Dominik wrote:
Would it be feasible to "narrow" a table by criteria on a specific
field in between separators? Ie: only display those cells in field A
if they are > 2, or if field B matches "P
On Fri, Apr 02, 2010 at 09:55:16AM -0500, Russell Adams wrote:
> > As you can see I got rid of a few horizontal separator lines, and we
> > don't currently have totals. I'll suggest fixes for that below, but my
> > main point is that although it may make sense to extend org-mode, it's
> > already e
On Fri, Apr 02, 2010 at 10:44:23AM -0400, Dan Davison wrote:
> How about keeping a master table containing all the information, and
> then generating narrowed views as separate tables? The babel way to do
> this would be to have a block function "filter-table" (provided below)
> and then call it wh
Hi Russell,
Carsten Dominik writes:
> On Apr 1, 2010, at 11:46 PM, Russell Adams wrote:
>
>> Fellow Org'ers,
>>
>> I adore the text spreadsheet, however there's one feature Excel
>> provides which I don't have in org.
>>
>> I often use Excel for "lists", where I can sort or narrow the data by
>>
How can you expand/narrow the disabled lines if you want to show/hide them?
This will probably interfere with normal TAB use inside a table.
I think that the ability to "disable" some lines based on data in a column,
such as in your example, can be very useful. But maybe we don't need to
really c
On Fri, Apr 02, 2010 at 09:49:46AM +0200, Carsten Dominik wrote:
>
>> Would it be feasible to "narrow" a table by criteria on a specific
>> field in between separators? Ie: only display those cells in field A
>> if they are > 2, or if field B matches "Pick Me!".
>
> This one might be possible - but
On Apr 1, 2010, at 11:46 PM, Russell Adams wrote:
Fellow Org'ers,
I adore the text spreadsheet, however there's one feature Excel
provides which I don't have in org.
I often use Excel for "lists", where I can sort or narrow the data by
specific criteria from a larger list.
Would it be feasib
Fellow Org'ers,
I adore the text spreadsheet, however there's one feature Excel
provides which I don't have in org.
I often use Excel for "lists", where I can sort or narrow the data by
specific criteria from a larger list.
Would it be feasible to "narrow" a table by criteria on a specific
field
On Mar 27, 2010, at 7:05 PM, Samuel Wales wrote:
Hi Michael,
Org tables already use up horizontal space with the | syntax. Some
people use large fonts or small displays.
Whatever solution is chosen, making it easy to make tables narrow will
be important.
I think the new implementation (<>
Hi Michael,
Org tables already use up horizontal space with the | syntax. Some
people use large fonts or small displays.
Whatever solution is chosen, making it easy to make tables narrow will
be important.
Samuel
On 2010-03-25, Michael Brand wrote:
> Hi Carsten, hi all
>
> Are there reasons t
On Mar 27, 2010, at 6:15 PM, Michael Brand wrote:
Yes, thinking more about it, I do agree that a fixed width makes a
lot of sense as the application of . It does now work like this.
Thank you for changing. And if someone wants `maximum width' I hope
that it will be implemented with the s
Yes, thinking more about it, I do agree that a fixed width makes a lot
of sense as the application of . It does now work like this.
Thank you for changing. And if someone wants `maximum width' I hope that it
will be implemented with the syntax <..N> as a _variant_ _additional_ to the
existin
On Mar 27, 2010, at 2:11 PM, Michael Brand wrote:
Are there reasons to only narrow but not to widen columns?
I think this is really the only thing that makes sense. Why would
you want it any wider, given the limited amount of screen real
estate we have here? I don't think it would be difficu
Are there reasons to only narrow but not to widen columns?
I think this is really the only thing that makes sense. Why would
you want it any wider, given the limited amount of screen real
estate we have here? I don't think it would be difficult to make
it behave the way you request, but I don'
On Mar 25, 2010, at 8:53 PM, Michael Brand wrote:
Hi Carsten, hi all
Are there reasons to only narrow but not to widen columns?
I think this is really the only thing that makes sense. Why would
you want it any wider, given the limited amount of screen real
estate we have here? I don't thin
Hi Carsten, hi all
Are there reasons to only narrow but not to widen columns?
I would like the behavior `fixed width' like
| year | boss | facility management assistant |
| | <30> | <30> |
|--+
Hi Tassilo,
one solution would be:
| Datum| Anzahlung | Sonderzahlung | Monatsrate | Restbetrag |
|--+---+---++|
| | | || 79000 |
|--+---+-
Hi all,
I have a table like this:
| Datum| Anzahlung | Sonderzahlung | Monatsrate | Restbetrag |
|--+---+---++|
| | | || 79000 |
|--+---+--
On Jul 24, 2009, at 11:20 AM, Stephan Schmitt wrote:
Andreas Burtzlaff wrote:
On Thu, 23 Jul 2009 02:29:30 +0200 meingbg wrote:
| a | b | c |
|---++---|
| a | 2 | 2 |
| b | 3 | 7 |
| c | -3 | 4 |
| d | 5 | 9 |
#+TBLFM: $3=...@-1::@2$3=$2
If @2$3 is manually set to 2 in the table
> I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
> If you clear column c completely, what is the output of the evaluation then?
The same. And so now I can't reproduce my original problem... that's
good, I guess.
> A good solution is to use
> $3=vsum(@-I$-1..$-1)
That works. T
Andreas Burtzlaff wrote:
> On Thu, 23 Jul 2009 02:29:30 +0200 meingbg wrote:
>> > | a | b | c |
>> > |---++---|
>> > | a | 2 | 2 |
>> > | b | 3 | 7 |
>> > | c | -3 | 4 |
>> > | d | 5 | 9 |
>> > #+TBLFM: $3=...@-1::@2$3=$2
>
> If @2$3 is manually set to 2 in the table, then the formulas p
On Thu, 23 Jul 2009 12:17:03 +0200
meingbg wrote:
> > Nevertheless:
> >
> > If @2$3 is manually set to 2 in the table, then the formulas produce
> > the expected outcome. So, the problem seems to be the order of
> > execution. If column c is cleared and the formulas are executed, @2$3
> > is read
> A good solution is to use
> $3=vsum(@-I$-1..$-1)
> as proposed in this thread:
> http://thread.gmane.org/gmane.emacs.orgmode/1940/focus=1941
That works for me, thanks!
>
> Nevertheless:
>
> If @2$3 is manually set to 2 in the table, then the formulas produce
> the expected outcome. So, the pr
On Thu, 23 Jul 2009 02:29:30 +0200
meingbg wrote:
> | a | b | c |
> |---++---|
> | a | 2 | 2 |
> | b | 3 | 7 |
> | c | -3 | 4 |
> | d | 5 | 9 |
> #+TBLFM: $3=...@-1::@2$3=$2
A good solution is to use
$3=vsum(@-I$-1..$-1)
as proposed in this thread:
http://thread.gmane.org/gmane.emacs.or
I have a table like this one:
| a | b | c |
|---++---|
| a | 2 | 2 |
| b | 3 | 7 |
| c | -3 | 4 |
| d | 5 | 9 |
#+TBLFM: $3=...@-1::@2$3=$2
Now, I want the value in column c in every row to be the sum of column b so
far. I try to achieve this by writing a column formula for column $3 and
No, $LR1 inserts the *value* of that field.
You can do this:
| 1 | 6 |
| 2 | |
| 3 | |
#+TBLFM: @1$2=vsum(@1$...@i-1$1)
Org imagines a hline at the end of a table, in your
case this would be the first hline in the table, so
@I-1 refers to the last row.
HTH
- Carsten
On Mar 13, 2009,
Dear All,
A quick spreadsheet question. I just wanted the compute the sum of an
entire column by using
| 1 | |
| 2 | |
| 3 | |
#+TBLFM: @1$2=vsum(@1$1..$LR1)
It doesn't do the trick (neither in v6.24a nor in v6.24c): the value of
@1$2 is 3, 12, 29, 120, etc., after multiple application of
Actually, thinking more about this, I think that Tassilo is right.
Therefore, from now on, this condition will throw an error.
I would like to make this #ERROR in the table cell, but
this is not easy, so for the time being, it really stops
the evaluation with an error message.
Thanks, Tassilo, f
Hi Tassilo,
I can see that this could be confusing, and maybe it should throw an
error.
The use-ase fo this are running means as column formulas
that would be undefined for he first few rows in. Consider
the following table:
| i | nn | mean of last 3 |
|---++|
| 1 | 4
Carsten Dominik <[EMAIL PROTECTED]> writes:
Hi Carsten,
> @-1 references the row above the current. If that is a hline, if
> actually references the current line.
Yes, I see that, but I wonder if that's actually the right thing to do.
IMO defaulting to some cell/row/column which is not referenc
Hi Tassilo,
@-1 references the row above the current. If that is a hline, if
actually
references the current line.
So you are asking Org-mode to sum lines 2 - 6, which includes the
result line. So each time the calculation is done, it add the two
ones to the result from the previous cal
Hi all,
I have this table:
| header |
||
| 1 |
| 1 |
||
| 0 |
#+TBLFM: @4$1=vsum(@[EMAIL PROTECTED])
The cell containing 0 should sum up all values of the column's rows
above. But C-u C-c C-c gives 2, then 4, then 6, then 8...
Reading the docs I found out that @-
Hello,
Carsten Dominik <[EMAIL PROTECTED]> writes:
> (defun my-wmean (values weights)
> (let ((vsum 0) (wsum 0))
>(while (and values weights)
> (setq v (pop values) w (pop weights))
> (unless (equal "" v)
> (setq vsum (+ vsum (* (string-to-number w) (string-to-number
> v)))
>
Hi Nicolas,
On Oct 1, 2008, at 6:46 PM, Nicolas Goaziou wrote:
Carsten Dominik <[EMAIL PROTECTED]> writes:
Hello,
Hi Nicolas, there s no builtin way to deal with this, in particular
with the fact that you want to treat empty fields as non-existing,
and
therefore also to ignore the corresp
Carsten Dominik <[EMAIL PROTECTED]> writes:
Hello,
> Hi Nicolas, there s no builtin way to deal with this, in particular
> with the fact that you want to treat empty fields as non-existing, and
> therefore also to ignore the corresponding weight.
>
> You cou write a Lisp function to do this, thou
On Sep 20, 2008, at 9:00 AM, Nicolas Goaziou wrote:
Hello,
I stumbled upon this problem : I'd like to compute the weighted mean
of
some values, even though cells might be empty. In fact, I'm aiming at
something like this :
| | Coeff. |0.2 |0.5 | 1 |
|---+
On Sep 29, 2008, at 10:43 AM, Carsten Dominik wrote:
On Sep 20, 2008, at 9:00 AM, Nicolas Goaziou wrote:
Hello,
I stumbled upon this problem : I'd like to compute the weighted
mean of
some values, even though cells might be empty. In fact, I'm aiming at
something like this :
|
Hello,
I stumbled upon this problem : I'd like to compute the weighted mean of
some values, even though cells might be empty. In fact, I'm aiming at
something like this :
| | Coeff. |0.2 |0.5 | 1 |
|---++++|
| Name | Mean | Tes
Here is a straightforward spreadsheet:
* Test org-mode spreadsheet for cash books
| | Name | Cash |
|---+--+|
| _ | |cashforward |
| | | 68000 |
| _ | | cashtake |
|
Thanks to you and Dr. Raman for answering my questions. I decided to
sort of roll my own solution, building on org mode spreadsheet tables.
Basically, it just inserts the grid, puts in the formulae, replaces
the date placeholder with the current date and time unless it gets a
numeric arg. If any
On Sep 11, 2007, at 4:06, Robert D. Crawford wrote:
I am a new user to org-mode and picked it up mainly for the spreadsheet
functionality. I have a few questions that I cannot seem to get an
answer to from reading the info manual.
I am using the spreadsheet to keep track of my blood glucose l
For easy insertion of templates as you make entries on a
daily/hourly basis, look at the org -> remember integration ---
the easiest way to do this would be to
A) install remember
B) Create an appropriate entry in the org-remember-templates,
C) Just hit remember and jot down what you are enteri
I am a new user to org-mode and picked it up mainly for the spreadsheet
functionality. I have a few questions that I cannot seem to get an
answer to from reading the info manual.
I am using the spreadsheet to keep track of my blood glucose levels,
correctional boluses, carb intake, meal boluses,
59 matches
Mail list logo
