On 12/07/2014 08:12 AM, Wiebe van der Worp wrote:
First post, not sure it is the right place, hi there!
For 2015 I would like to keep a shadow bookkeeping in Calc in order to
check our bookkeeping program for a while.
Input: In order to keep things simple: three columns with Description,
Amount and a LedgerCode.
Output: Sums per LedgerCode
Several solutions are thinkable of, such as conditional testing and
lookups. However, if the list grows and contains thousands of lines it
will influence performance.
The question: What is the most efficient approach in order to keep the
sheet alive after adding record 2384?
Example:
LedgerCode: 1, 2, 3
-------------------
1 € 100,00
2 € 65,00
3 € 22,00
-------------------
Description Amount LedgerCode
booking 1 € 100,00 1
booking 2 € 50,00 2
booking 3 € 20,00 3
booking 4 € 10,00 2
booking 5 € 5,00 2
booking 6 € 2,00 3
Rather than use Calc, I recommend using Base with a simple database.
You will need one table (table1) containing four fields: Description,
Amount, LedgerCode, and PK (primary key)
Then you will need a query to obtain your results. the SQL for the
query is
Select SUM("Amount"), "LedgerCode" FROM table1 GROUP BY "LedgerCode"
ORDER BY "LedgerCode"
I could create this and send it to you off list if you want.
Dan
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
