Re: COMP: Excel spreadsheet for summer auctions

Kitty:

I would like a copy of our spread sheet.

I'm with the Mesilla Valley Iris Society in New Mexico, and we have rhizone
sales each year.

Thank you for offering this spreadsheet.


Jim Reilly
Las \Cruces, New Mexico
jpreilly@zianet.com
James P. Reilly
jpreilly@zianet.com
----- Original Message ----- 
From: "Lobergs" <loberg@adelphia.net>
To: <iris@hort.net>
Sent: Monday, May 31, 2004 9:29 AM
Subject: [iris] COMP: Excel spreadsheet for summer auctions


> 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

---------------------------------------------------------------------
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