[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
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