Match Scheduler and Fixture Generator

  • Version
  • 1'000 Downloads
  • 48.9 Mb File Size
  • March 11, 2015 Updated
  • 0 Number of comments
  • Yes Free
  • Rating
table of content

Several months ago, there are several people asking for fixture generator and match scheduler that is designed specifically for sports other than soccer that played in number of sets and require 2 or 3 sets to decide the winner, where it is common in volleyball, tennis, table tennis and many more. Because these sports are usually played in single place, for example in one venue with several courts, there will be no need of home and away matches arrangement. Also, one team should play other team more than twice within one league period. This feature isn’t supported in my Soccer League Creator.

For the past 2 weeks, I tried to simulate this league and try to modify my League Creator, but it looks like this additional features require more excel and computer resources to process all needed calculation. So, I decided to drop almost all of scoresheet and standing features and focus on creating fixtures generator that generate matches between the same team more than twice and add more flexible matches arrangement in this new Sport League Fixtures Generator and Match Scheduler.

Volleyball Tennis Fixture Generator Match Scheduler Sample for ExcelBecause of tie-breaker rule nature between soccer and set matches, I created 2 models that you can use. One model is designed specifically for soccer matches, the other model is designed specifically for game-set-match type of sports.

The first model, which aim for soccer league, will allow you to create custom matchday and the same team could be set to meet until 8 times throughout the league. But, it doesn’t equipped with dashboard, last 5 matches, team info tables and other accessory features that you might have seen in Soccer League Creator since the intention of this template is to produce fixtures and matches only. You can compare them to see further about the difference. You will need this only if you plan to have same team meeting more than twice within one league period or if you need to have more flexible matches schedule (one day league, 1 – 7 matchday a week, etc). If you want to simulate European football or other league competition, this is not the correct one for you.

The second model, which aim to set-and-match sport types, will have features below :

  • Any team/players can meet until 8 times
  • It can accommodate until maximum 36 team/players
  • You can set different points for winning/losing in two, three, four and five sets
  • There are 2 tie breaker regulation (rule 1: 1,2,3,4 and rule 2: 1,2,3,4,5,6,7) that you can use where it will follow rule below :
    1. All Matches – Highest Point
    2. All Matches – Highest Matches Won
    3. All Matches – Highest Percentage of Sets Won
    4. All Matches – Highest Percentage of Games Won
    5. Player Concerned Matches – Highest Point
    6. Player Concerned Matches – Highest Percentage of Sets Won
    7. Player Concerned Matches – Highest Percentage of Games Won
  • You can organize daily, two times until 7 times matchday a week where each day could held several rounds. Also you can set time interval between each rounds and matches. Or, you can organize a league for one day only.

I created 4 samples of the implementation of my second model match scheduler and fixture generator that you can download it.

Features

Ξ Automatic Fixtures Generator
It will generate all fixtures automatically.

Ξ Up to 8 Same Player/Team Meeting
You can choose until 8 times, the match meeting between same player/team.

Ξ Accommodate until 36 Players/Teams
You can choose until 36 players/teams to participate in your league.

Ξ Feature-Rich Individual Player/Team Information
You can see your player/team schedule and result

  • See all player/team matches and results in table view
  • See all player/team matches in one year calendar in calendar view
  • See the result between the same opponent

Ξ Custom Season Calendar
Visualize all team matches in one year calendar, and add holidays consideration to re-arrange any generated schedule.

Ξ Custom Points
You can set different points awarded for winning/losing sets for each player

Ξ 2 Tie-Breaker Combination
There are 2 tie-breaker combination derived from 7 tie-breaker options

  1. All Matches – Highest Point
  2. All Matches – Highest Matches Won
  3. All Matches – Highest Percentage of Sets Won
  4. All Matches – Highest Percentage of Games Won
  5. Player/Team Concerned Matches – Highest Point
  6. Player/Team Concerned Matches – Highest Percentage of Sets Won
  7. Player/Team Concerned Matches – Highest Percentage of Games Won

And 2 Tie-breaker combination are:

  1. 1,2,3,4 (player/team position will follow rule number 1, then 2, then 3)
  2. 1,2,3,4,5,6,7

Ξ Custom Match Scheduler 
You can set :

  • Starting date/time of the first matches of each round
  • You can set type of competition (one day/weekly tournament)
  • You can set number of rounds played every day
  • You can set time interval between rounds and matches
  • You can choose days to be repeated weekly

Template Contents

  • Set and Match Fixtures Generator Lite
    • Set_and_Match_Fixtures_Generator_Lite_Best_of_Five_Tennis_Table_V37.xlsx
    • Set_and_Match_Fixtures_Generator_Lite_Best_of_Five_Volleyball_V37.xlsx
    • Set_and_Match_Fixtures_Generator_Lite_Best_of_Three_Badminton_V37.xlsx
    • Set_and_Match_Fixtures_Generator_Lite_Best_of_Three_Tennis_V371.xlsx
  • Set and Match Fixtures Generator Pro
    • Set_and_Match_Fixtures_Generator_Pro_Best_of_Five_V37.xlsx
    • Set_and_Match_Fixtures_Generator_Pro_Best_of_Three_V37.xlsx
  • Soccer_Fixtures_Generator_Pro_V28.xlsx
  • Soccer_Multi_Matches_Fixtures_Generator_V25.xlsx

How useful was this template?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry 🙁

Help us improve!

View Comments
There are currently no comments.