Open Auction


The open source solution to help you manage your Auction.

The Open Auction is an excel spreadsheet, specifically designed to help you plan and execute your auction. It has been created with non-profit organizations in mind. Its only requirement is MS Excel.

The Open Auction consists of several worksheets; each one designed to manage a different part of the auction process. The system helps with the following areas:

  • Manage vendors and their donations.
  • Manages attendees and paddle numbers.
  • Records bids on live auction items.
  • Records bids on silent auction items.
  • Manages raffle items, 50/50 draws, and cash donations.
  • Generates invoices for checkout.
  • Controls Expenses.
  • Generates auction items lists and silent auction bid forms.
  • Generates thank you letters with results from the auction.

Item groups, how to add

in User Questions
by S Combs • | | 1 comment
On the All Items tab is the field Part of Group. How does one enter group names to be selected?

bid sheet modification

in User Questions
by S Combs • | | 1 comment
Is there a way to modify the bid sheet to show Minimum bid and Incremental bid? I do know some Visual Basic.

customization

in User Questions
by Olivier • | | 1 comment
Dear Andrew, First many thanks for sharing your work. I really appreciate. The theopenauction spreadsheet is almost perfect for me. However, I would like to make couple of minor changes. 1.- The currency. I would like to change the currency form $ to EUR for instance. 2.- How can I tra...read more
by Karen • | | 5 comments
When I opened the file to use it, I received this error in a message box: Compile error: Can't find project or library Then another box was open with the Project list and the SystemUtils was open. Then another box was open with some code referring to the SystemUtils. Do you think th...read more

Category - Dropdown options

in Support
by Deirdre • | | 3 comments
Hi Andy, I just downloaded this and am really excited to use it but I can't get the category field to work properly. The dropdown menu is blank and when I type in the category (e.g., Silent Auction), the system won't let me save it. What can I do to fix this? Thank you, Deirdre

Any way to enter winning bidders by name?

in User Questions
by Danny • | | 1 comment
At my event we don't allow people to have a bidder number unless they have a credit card backing it up, we do however let people bid in the Auctions by name. (it is a closed event so we have all of their info in attendees) The only reason we don't just give people bidders numbers is because we s...read more

Thank You Letter Template

in User Questions
by Sam R • | | 1 comment
I am running Office 2010 on a Win 7 machine. When I go to generate the Vendor Thank You Letters, I keep getting error messages that the template must be located in the same directory. The template is in the directory and is "Unblocked." I thought maybe it was a versioning thing and ...read more

Home Button

in Feature Requests
by Sam R • | | 0 comments
Since the spreadsheet seems to work best when you are using the "Main Menu" to go between all of the different sheets, it would be nice to have a "Main Menu" button on each sheet. I dont have a problem navigating the different sheets but I know some of my users would definit...read more
by Lana • | | 1 comment
Is it possible to show the vendor on the auctioneer items report? We are having a charity auction and would like the auctioneer to announce who donated the item to the auction. The auctioneer items report would be perfect if it had that information. Thank you.
by bmasella • | | 6 comments
Is there a way to summarize from checkout ALL items purchased via Bid Number... Raffle, 50/50, Auction, etc... and do printed AND emailed receipts?
1234567 ... 12
New Post
feeds Feeds
Andrew Wilcox Jeffp769 tj_wolf2 bmasella
ski_mom jasm580 Today jayjoe1010
Destro Smallworld sakthisam tmitchell012