COMP: Excel spreadsheet for summer auctions
- Subject: [iris] COMP: Excel spreadsheet for summer auctions
- From: &* <l*@adelphia.net>
- Date: Mon, 31 May 2004 08:29:52 -0700
- List-archive: <http://www.hort.net/lists/iris/> (Web Archive)
Summer is coming again, so I thought I'd mention again that my Excel auction
spreadsheet is available to any club or region who would like to have a
spreadsheet tool to track auction rhizome sales. A sample of what it looks
like is below. It allows you to enter sales as they are occuring, and
totals appear automatically to the right and on a 2nd sheet. Eliminates rush
and hassle at the end of the sale. Instructions included. Just send me an
email if you would like a copy.
Kitty Loberg
Region 14, Northern Calif.
AIS, TBIS, SJI, SSI
Computer Science Instructor
Mendocino College
Enter data in these four columns only,
!!
Auction Entry/Detail Worksheet
starting in row #8.
!!
Designed by K Loberg, Region 14
Based on Bidder #, amount will automatically
!!
Total for Bidder will appear on row #7.
extend to right portion of worksheet.
!!
(Sheet2=Summary, Sheet3-Instructions)
Selling
Quantity
!!
Total $
Bidder Numbers, through #70 ----->
Variety Name
Price
Sold
Bidder#
!!
(B * C)
1
2
3
4
Total Purchased--->
!!
61.75
29.75
12.00
10.00
0.00
Stairway to Heaven
12.00
1
2
!!
12.00
0.00
12.00
0.00
0.00
Skating Party
5.00
2
3
!!
10.00
0.00
0.00
10.00
0.00
Skating Party
4.75
1
1
!!
4.75
4.75
0.00
0.00
0.00
Skating Party
25.00
1
1
!!
25.00
25.00
0.00
0.00
0.00
Skating Party
10.00
1
12
!!
10.00
0.00
0.00
0.00
0.00
1
!!
0.00
0.00
0.00
0.00
0.00
1
!!
0.00
0.00
0.00
0.00
0.00
1
!!
0.00
0.00
0.00
0.00
0.00
---------------------------------------------------------------------
To sign-off this list, send email to majordomo@hort.net with the
message text UNSUBSCRIBE IRIS
Other Mailing lists |
Author Index |
Date Index |
Subject Index |
Thread Index
