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 Delbert Jepson • | | 4 comments
on the attendees I took the paddle # away from one attendee and it went to a debug thing ,I realized I screwed up but I had already saved it, how can I fix without losing all the attendees I've entered. When I click on debug I don't understand none of it HELP Thank You so much Delbert Jepson

column width

in Tutorials
by Delbert Jepson • | | 1 comment
I need to make columns wider in silent action sheet has to be easy but has me stumped. Also an earlier question I had on when I entered items in all items and selected live auction it would not transfer ,but got it to work by going into live action sheet and selected save & next and it all more

Live Auction missing from Category drop down menu

in Support
by Jeffp769 • | | 2 comments
- deleted -
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 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 more
12345 ... 12
New Post
feeds Feeds
Andrew Wilcox Jeffp769 tj_wolf2 bmasella
ski_mom jasm580 Today jayjoe1010
Destro Smallworld sakthisam tmitchell012