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.

entering all items; category will not select

in Support
by sally martin • | | 2 comments
Hi there! Thanks for this app. I am trying to enter items for Live Auction. The drop down menu doesn't have any selections, so I have manually entered Live Auction. The program isn't accepting this option so I cannot enter items. What am I doing wrong, or what do I need to do differently? Thanks...read more
by Ann • | | 3 comments
Hi, I just came across your software and we are so excited that our school will be using this. The one thing that we would require is to add the donations that were given by each attendee needs to be added to the checkout. Thanks for this awesome software.

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
12345678 ... 13
New Post
feeds Feeds
Andrew Wilcox Jeffp769 bmasella tj_wolf2
TERESF ski_mom Cherry07 skyzhang
jasm580 tlillys alliot486 Smallworld