I have recently been working on an Excel fixture list creator as it is something that I have received many requests for.

The spreadsheet can create any sports fixture list.

The spreadsheet can handle;

• A maximum 64 teams or people.
• The teams or people can play each other once or twice throughout the competition. A drop down list is provided to select the desired number.
• An odd or even number of teams can be used.
• The fixture list is random. Some of the fixtures lists I found on the web produced the same fixtures unless you put the teams in a different order. This fixture list creator will randomise the teams for you.

To use the spreadsheet simply enter the team or competitor’s names on the Teams tab, select whether they will play each other once or twice, and click the Create Fixtures button.

Download the Excel fixture list creator spreadsheet to create your fixtures now.

Need a league table generator too? Download my Excel league table generator to automatically update your teams league positions as you enter the results. Simply copy the fixtures generated into this spreadsheet and start entering the results. The spreadsheet does the rest.

Please comment with any ideas you have to enhance or improve the spreadsheet. Let me know your thoughts and share it with your friends.

[Read more…] about Excel Fixture List Creator

I am currently working on an Excel VBA project that requires me to check if the number obtained by Excel is an even number, or if it is an odd number.

I accomplished this using the Mod operator. The Mod (modulus) operator is the VBA equivalent to the MOD function in Excel. It’s purpose is to find the remainder after a number has been divided by a divisor.

The Mod operator is written as below where a and b  represent variables containing values;

a Mod b

If a stored the value 20 and b stored 6 then the result would be 2. And if a stored 20 and b stored 4 then the result would be 0.

To check if a value is an even or an odd number I used the Mod operator to divide the variable holding the number by 2. If the result returned 0 then it must be an even number. And if not then it must be an odd.

[Read more…] about Check if a Value is an Even Number