[Date Prev][Date Next][Thread Prev][Thread Next][Author Index][Date Index][Thread Index]

Re: [zzdev] Re: [zzdev] Re: [zzdev] Freshmeat

On Fri, Sep 04, 1998 at 12:08:28PM +1000, Gossamer wrote:
> I have somethinng I'm sure -should- go great into ZigZag but I can't
> figure out how.  Spending list I have.  For each item there's the
> date, amount, description (freeform), and it also fits into one of
> a fixed set of about 6 categories (medical, food, school, etc.).  
> If I was doing it on a spreadsheet I'd have the dates along the left,
> then the descriptnions, then a bunch of columns for categories and
> put the amount into the appropriate category column ... but how would
> I do it in ZigZag?

Well, there are of course lots of ways you could do this, but how's this
for one way:

+--> d.1
v d.2

Date --- Cat1 --- Cat2 --- Cat3 --- Cat4 --- Cat5 --- Cat6 --- Desc
  |                 |        |        |                          |
<date1> --------- <amt1> ------------------------------------- <desc1>
  |                          |        |                          |
<date2> --------------------------- <amt2> ------------------- <desc2>
  |                          |                                   |
<date3> ------------------ <amt3> ---------------------------- <desc3>


Now you will be able to see all the amounts for any given category together,
or go through the complete list by date or description.  And when viewing
by row, you'll just see it as the three fields for any given item.

Share and enjoy,
		*** Xanni ***
mailto:xanni@xxxxxxxxxx                         Andrew Pam
http://www.xanadu.net/xanadu/                   Technical VP, Xanadu
http://www.glasswings.com.au/                   Technical Editor, Glass Wings
http://www.sericyb.com.au/sc/                   Manager, Serious Cybernetics
P.O. Box 26, East Melbourne VIC 8002 Australia  Phone +61 3 96511511