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.

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

Overview

in Tutorials
by Andrew Wilcox • | | 0 comments

Getting Started

in Tutorials
by Andrew Wilcox • | | 0 comments

Managing Attendees

in Tutorials
by Andrew Wilcox • | | 0 comments

Managing Vendors

in Tutorials
by Andrew Wilcox • | | 0 comments

Managing Donated Items

in Tutorials
by Andrew Wilcox • | | 0 comments
1 ... 78910111213
New Post
feeds Feeds
Andrew Wilcox Jeffp769 bmasella tj_wolf2
TERESF ski_mom Cherry07 skyzhang
jasm580 tlillys alliot486 Smallworld