Re: FN-FORUM: basic spreadsheet

date posted 19th March 2008 18:41

And there it goes ... way over my head!
Pivot table?

But, in general, what you said ben, sounds right.

I have had something sent over which works perfect, thanks, but feel
free to better his work if you like.

:)

Why is it that I can read html like a songwriter reads sheet music but
when it comes to something like this my head starts to boil over?

Lee Rickler
Director - Point and Stare - pointandstare.com
Web Design and Development for over 11 years

Ben Johnson (Neogic) F wrote:
> Lee Rickler wrote:
>> Has anyone a very basic excel spreadsheet template for keeping track
>> 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 (= 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]
>
>
>
>