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.

Will this work with a Mac?

in User Questions
by Amy • | | 3 comments
I have Excel 2004 for Mac. Will it work?

Add donors to the donations screen

in User Questions
by Mary McKeown • | | 5 comments
I have tried to add a donor name with an amount to the donations section of this application and keep getting an error message about de bugging. Am I doing something wrong. We are planning to use this application for the first time on Friday, May 15th and so far it looks like everything is wor...read more

bid sheet

in User Questions
by lsm • | | 1 comment
Hi! The bid sheet report stopped and gave me an error message that showed a line in Visual Basic: Set wrdApp = CreateObject("Word.Application") I have Word 2003. Thanks for any help here. It's a great spreadsheet. I'm anxious for it to work!! :-)

Excel version

in User Questions
by lsm • | | 3 comments
Does this require a certain version of Excel. I have 2003. The reason I am asking is in case this is the reason I"m having trouble - - The Reports are not generating. I don't get an error but nothing shows up on the spreadsheet after I select to Generate the Report. It moves the curso...read more

Multi-User Capabilities

in User Questions
by Patti Jones • | | 8 comments
Can this file be access by multiple users at once if it is shared on the network?

Checkout

in User Questions
by Brenda • | | 5 comments
Is the Generate Receipt button on the Check out tab supposed to automatically fill in the lines of those items purchased by the attendee? Or does it only put their name and the method of payment on the receipt? Thanks! Very nice interface. I think it is a great too.

Is this really free?

in FAQ's
by Andrew Wilcox • | | 0 comments
Yes, it is 100% free. You may download, redistribute, and/or modify the code under the terms of the GNU General Public License.

Why can't I modify any values directly in the spreadsheet?

in FAQ's
by Andrew Wilcox • | | 0 comments
We have protected the spreadsheet data so that is can not be modified directly. Beneath the surface of the app, is a complex network of related tables that are used to associate data between worksheets, and store hidden data. The forms provided must be used in order to maintain these linkages....read more

What happened to my tool bars and number column?

in FAQ's
by Andrew Wilcox • | | 0 comments
We have coded the spreadsheet to hide unnecessary toolbars and the numbers column. You will not need them to use the application, and there is more screen space without them. As well, the numbers column adds confusion, as the row numbers do not match with the items numbers in the app.

Why do I get a security warning when I try to open up the file?

in FAQ's
by Andrew Wilcox • | | 1 comment
The security warning is how Microsoft lets you know that the file you are about to open contains macros. Macros are bits of code developed in Visual Basic to perform the tasks of managing your data. We have used this code to develop Open Auction. We have added a level of protection for you ...read more
1 ... 567891011
New Post
feeds Feeds
Andrew Wilcox Jeffp769 tj_wolf2 bmasella
ski_mom jasm580 Today tlillys
tmitchell012 Smallworld sakthisam Destro