What’s different?

Player’s Tournament© Introduction

 

Concept and design: George Silberzahn Application programming: Gary Yourman

 

Understanding the concept:

This is a tournament designed for the 80% of darts players who do not normally attend tournaments while it provides the other 20% a very challenging experience.

 

There are three parts to this tournament.

            1. Seeding qualification;    2. Finals qualification;   3 Finals

 

The number of entrants is limited by the number of dart boards available.

            The ideal minimum number of dart boards is six.

            The ideal maximum number of dart boards is 20.

            The minimum number of entrant positions is 20.

            The ideal maximum number of entrants is four times the number of dart boards.

The length of time the tournament will take (5 to 6 hours of competition) is jeopardized if the number of entrants is greater than the suggested four times the number of boards.

 

Overview        

           

* Positions in the tournament are available on a first come first served basis;

* Elite players are segregated from the non-elite (see Elite players);

* Competition is completed in one day (5 to 6 hours);

* Every entrant will play at least four rounds of competition;

* Entrants separate themselves into three groups (A, B, C) by shooting for score during a session called Seeding Qualification;

* Each group has its own prize structure.

In effect, there are three tournaments occurring at once with competition inter and intra Group.

 

Elite players     

An entrant is considered “Elite A” if any of the criterions listed below is met.

* Won 1st, or 2nd in Group A of a Player’s Tournament (within a three year period);

* Won Group B of a Player’s Tournament (within a three year period);

* Won a locale wide singles event (within a three year period);

* Ranked in the top twenty of any national darts association.

An entrant is considered “Elite B” (can not play in Group C) if they have won 1st in Group C of a Player’s Tournament.

 

Cost:

Entrance fee is usually $25. There are 50/50s held and sponsor money raised also.

 

Prize money

Each Group has its own prize structure.

The final four positions within each Group win portions of the available prize money.

 

Entrant segregation

Entrants are distributed by percentage: 25% A Group, 50% B Group and 25% C Group.         

 

Winning

Points are earned for each game and match win. Highest numbers of points compete in finals.

 

“Player’s Tournament” Excel program

The tedious work of entrant ranking, match pairing, point scoring, finalists’ calculations and other administrative work is all done by an Excel Book program: “Player’s Tournament”. 

These tedious functions of running the tournament are automatic. The Director only needs to be familiar with the basics of MS Excel. The program will do all the work of separating entrants into Groups, creating the match pairings, filling out the tally cards for each entrant, and totaling the results of the four rounds of competition. It will show the winners (and ties) for each Group.

There are eight tabs within the book:

Instructions: instructions about how to use the program, when and where to enter data;

            Setup: Input form for entry fee and cost per extra seeding try,

            Data form for the number of entrants, matches, Elite players;

              Buttons:  “Start Event” – processes entrant data into Groups and matches, etc.;

                            “Who’s winning” – sorts entrants into standings of the top four and ties;

                            “Clear all data” – deletes all data through out the book;

                            “Clear forms – leave players names” – does what the title says.

Players: before the tournament starts this is where an entrant’s name, elite status and fees paid are entered;

After the tournament is underway this is where the player’s Group, Num of P1 games, Num of P2 games, total games, total points won, win % is shown;

Matches: Col A shows the match number, Col B shows the number of matches in which the player is primary player, Col. C shows the number of matches in which the player is secondary player;

Finals: after the “Who’s winning” button is clicked this is where the top four places and ties for each group is shown;

 

Payouts; shows the standard payouts suggested by the program and where adjustments may be made if desired;

Elite notes: This is where data for who is an elite and why they are in that category is entered;

Tally cards: after  the “Start Event” button is clicked the program fills in the tally cards.

  The entrant’s name, seed score, Group, rank within the group, and start score;

  the opponent’s names, seed score, Group, start score, player num., point value for    each game win are all filled in on each tally card.

 

On tournament day the number of entrants must be even in order to start the event.

* Revenue:

  The “Player’s Tournament” Excel book provides the means of accounting for, and review of, financial data.

       

* Prize distribution

The “Player’s Tournament” Excel book provides the means for prize distribution review.

           

* Entrant distribution across the three Groups:

The “Player’s Tournament” Excel book program distributes entrants across the three Groups by Seeding Score and “Elite” status.

 

There are three files needed to run this tournament:

Introduction: a Word file;

Player’s Tournament: an excel work book file;

Entrant List-trial; an excel work book file.

 

Practicing with the “Player’s Tournament” work book

 

Using the “Entrant List-trial” files

 

            Open “Player’s Tournament” excel workbook.

 

            Save a backup copy of “Player’s Tournament.”

 

            Open “Entrant List-trial” spread sheet.

 

            This spread sheet has eighty names in (col. A), Elite status in (col. B) and seeding scores    in (col. C).    There are also more than eighty match results in cols. D and E.

 

Practice:

 Highlight and Copy as many names and seeding scores as you wish.

 * Minimize “Entrant List-trial.”

 * Maximize “Player’s Tournament” and select the “Players” tab.

     Paste names, elite status and seeding scores into cols. B, C and D.

  * Switch to the “Set up” tab and click the “Start Event” button;

      After the program has done its work review the tabs as you wish.

You may print the tally cards or review them on the “Tally Card” tab.

* Minimize “Player’s Tournament” and Maximize “Entrant List-trial.”

   Highlight and copy the match results in cols. D and E.

* Minimize “Entrant List-trial” and maximize “Player’s Tournament.”

   Select the “Matches” tab and paste the results into cols. H and I.

  Add or delete results to equal the number of matches.

 

  Select the “Set up” tab and click the “Who’s winning” button.

 

At this point you should be able to see all the functions of the program and review all the tabs and data and information.

 

* Select the “Set up” tab and click “Clear All Forms”.

 

For more information and/or to receive the needed files through email, please contact George Silberzahn

Leave a Reply