[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Question Regarding Creating Workflow For Automatic Formulas For Fina
From: |
Eric S Fraga |
Subject: |
Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet |
Date: |
Sun, 16 Jan 2022 18:10:31 +0000 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
On Sunday, 16 Jan 2022 at 10:35, Samuel Banya wrote:
> How would you able to keep the running totals in Column E?
Using your initial example, adding a header line to give a starting
point, the following works:
| Date | Item | | Debit | |
|------------+-------------------------+---+----------+----------|
| 01/03/2022 | Example Rent Expense | | -1061.67 | -1061.67 |
| 01/04/2022 | Example Food Expense | | -1061.67 | -2123.34 |
|------------+-------------------------+---+----------+----------|
| 02/05/2022 | Example Utility Expense | | -2061.67 | -4185.01 |
| 02/06/2022 | Example Random Expense | | -2061.67 | -6246.68 |
|------------+-------------------------+---+----------+----------|
#+TBLFM: $5=@-1+$-1;NE
I've not included monthly sums as this would complicate things (although
should still be possible...) but retain a dividing line for clarity.
The top entry of the last column could have a starting balance, if you
wanted. At the moment, it's treated as a 0.00 value.
--
: Eric S Fraga, with org release_9.5.2-306-g9623da in Emacs 29.0.50
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, (continued)
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Neil Jerram, 2022/01/10
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Neil Jerram, 2022/01/19
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Quiliro Ordóñez, 2022/01/14
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Samuel Banya, 2022/01/16
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Samuel Banya, 2022/01/16
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Samuel Banya, 2022/01/16
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet,
Eric S Fraga <=
- Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, John Hendy, 2022/01/16
Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet, Eric S Fraga, 2022/01/10