Завершено

Pinewood Derby Matrix Maker

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. [url removed, login to view] 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.

Квалификация: Электронные формы, Excel, Математика

Показать больше tcw, html spread sheet, html maker, matrix, diversity, create excel worksheet, car racing, worksheet html, workbook html, create user forms excel, spread chart, html worksheet, excel inputs, genral, name lettering, create workbook, net html excel, generate document excel sheet, excel input sheet, spreadsheet forms

О работодателе:
( 58 отзыв(-а, -ов) ) Minneapolis, United States

ID проекта: #4657783

Поручен:

hegemon88

Please see my earlier Fixtures Generator project - I know what needs done for yours :-)

$136 USD за 7 дней(-я)
(3 отзывов(-а))
3.6