I need an Excel spread sheet that can help manage Pinewood Derby races. I need it to be in Excel for portability and genral ease of use for even novice users.
The spreadsheet must be able to do a multitude of things with minimal input from the end user.
Essentially I need the following chart generation method incorporated into a workbook. [login to view URL] noting the combinations that can not be mathematically accomplished if the user inputs that combination. Furthermore I need the spreadsheet to go beyond the ability of this allowing for up to 4 rounds and calcualting the differences accordingly to maintain diversity so that racers do not end up racing against the same racers again in additional rounds.
One other enhancement. For this pinewood Derby spreadsheet I need not only to generate and over all group race matrix but sub group race matrixes as well. Each racer should have individual fields attached to their record. First Name, Last Name, Car Name, Car Number, and Class. The Class field should serve as a sub group identifier. So if just a class race is desired a matrix can be generated for only a sepcific class.
Ideally each race generation would create a new worksheet with those that are racing.
Each individual Heat should have it's own worksheet for display during the race. This way it can be projected during the race in big lettering for audience to see
Finally a worksheet schedule of races needs to be generated so that a schedule for viewers can easily be printed out.
I have a spreadsheet that has a lot of this in it already except for the autmomatic generation of worksheets and the matrix generation. I will provide winning bidder with this document for review.