D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Spreadsheets

 

On Mon, Jun 15, 2015 at 08:17:10AM +0100, Richard Brown wrote:
>    Hi
>    I am trying to create a family budget on a spreadsheet. However, I want to
>    record transactions as they happen on a four weekly and monthly basis.
>    This is for our main bills account. I don't want to track every expense
>    just so's and dd's etc...
>    Is it possible to do this in LibreOffice please?
Yes for example

Set up a series of columns. Filter or Auto filter will allow you to see 
specific sets
-   Date
-   Week number: =weeknum(Date,Mode)
-   Month: =month(Date)
-   Amount
-   Account
-   What was the reason for the bill

Then use a pivot table to examine how much you are spending on what

Others may have better designs, there are spreadsheets available

https://www.google.co.uk/search?client=firefox&q=libreoffice+budget+planner


-- 
Henry
Communication not signed with an original manual signature or an appropriately 
verified digital signature is not binding.
Mon 15 Jun 08:52:24 BST 2015

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq