Re: [libreoffice-users] calc and bookkeeping

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: users+unsubscribe@global.libreoffice.org
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