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.

by Jeffp769 • | | 2 comments
When I add a new vendor and enter a zip code that has a leading number 0,in the column marked Postal/Zip that leading 0 does not appear. It does appear in the window above with all the other vendor information
by Jeffp769 • | | 2 comments
Is there a way to mass import information from another excel spread sheet?I don't want to have to enter each in manually, would like to be able to copy and paste a range of cells from my spread sheet into lets say the VENDOR NAME column. Is this possible?/ Thank you

Can multiple people edit the spread sheet

in Support
by Jeffp769 • | | 3 comments
I am glad to see this product and have an auction in a month to set up. My question is can multiple people edit this? During check in I have 2 people who will be registering attendees and assigning bidder numbers. Throughout the auction we will have multiple people who will need to access and en...read more
by Melodi Ramquist • | | 1 comment
Hello, I downloaded the program, but the "Enable Editing" box does nothing. The form is basically frozen. I can click through the tabs, but the spreadsheet is stuck in the "Protected View". Any ideas how to enable the macros? I'm using Chrome. Thanks.
by Delbert Jepson • | | 1 comment
just downloaded your open action, we used it last year with great success. This time when I put an item in the all items and pick the category action item it doesn't transfer to live action if I pick any other category it works fine. please help Delbert

Excel for Mac

in User Questions
by Nathan • | | 1 comment
I try using this w/ Excel for my Mac and it says runtime error 438 everytime I try to add a vendor or an attendee. Is there something I can change to make this not happen and for the buttons to actually work or is the fact that I'm using a Excel on my Mac the problem??
by Jeanne • | | 0 comments
Our group has an auction every year. The attendees are roughly the same folks every year, but the vendors and the items change. Rather then entering the attendees (around 250) into a fresh download each year, is there an easy way to delete the vendors and items without deleting them entry by e...read more

All Item Input Views So Small

in User Questions
by Doug Parker • | | 1 comment
As I have entered items into the ALL ITEMS Input Fields, the Data Fields in the Input Area have gotten so small that I can not read them to edit them. I tried Zooming In and Opening/Closing but the Data Fields do not seem to resort back to original size. Appreciate some help ... some sort of...read more

Live Auction items not populating

in User Questions
by Matt • | | 1 comment
I am entering items into All items tab. When I click on the category drop down list it only has 4 options available. "Auction Item" "Silent Auction" "Raffle" and "Door Prize". Items that I set to Silent are showing up under silent auction tab, but items I...read more

All Item entered are not showing up in Live Auction

in User Questions
by Marilyn • | | 3 comments
I have entered 312 items into the All Items section and only 172 random ones show in the Live Auction. What am I missing? Marilyn
12345 ... 11
New Post
feeds Feeds
Andrew Wilcox Jeffp769 tj_wolf2 bmasella
ski_mom jasm580 Today tlillys
tmitchell012 Smallworld sakthisam Destro