RE: FN-FORUM: basic spreadsheet

date posted 19th March 2008 18:33

Lee Rickler wrote:
> Has anyone a very basic excel spreadsheet template for keeping track=20
> of monthly costs?

> Basic needs are, for example:
> 1 column for outgoing (number)
> 1 column for outgoing name (text)
> 1 column for incoming (number)
> 1 column for incoming name (text)
> Totals for each and an overall total.
> All magically calculated on the fly.


The Devil's in the details, as ever. By "Totals for each and an overall
total", do you mean:

1. Sub-totals for overall income and overall outgoings, then net =
balance
figure
2. Sub-totals for several types of outgoings/income (which will be =
grouped
in order), then a total figure at bottom
3. As per 2, but related "transactions" aren't grouped together (=3D =
you'd
probably need a PivotTable to get the numbers you want).


Regards, Ben

--
Ben Johnson, Neogic Web Solutions
// design . development . managed hosting

w | http://www.neogic.com
t | +44 (0)1242 808 262
e | [EMAIL REMOVED]