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.

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

Managing Live Auctions

in Tutorials
by Andrew Wilcox • | | 6 comments

Managing Silent Auctions

in Tutorials
by Andrew Wilcox • | | 1 comment
1 ... 6789101112
New Post
feeds Feeds
Andrew Wilcox Jeffp769 tj_wolf2 bmasella
ski_mom jasm580 Today jayjoe1010
Destro Smallworld sakthisam tmitchell012