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
--
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
