Excel Fixture List and League Table Creator

hey man thanks so much me and my friends at university we created a league and I was so happy to see this thank you

This is brilliant!!!! Works really well, must of taken ages to create at first. Really good stuff

This is great, thanks. However, I have the issue where 2 teams play from the same venue so cannot be at home on the same day. Is there any way the fixtures functionality can be updated?

Thank you very much for this little program. Works great.

Wow!

Great program. But i have some problem with the league table. How do i have a league table without home-away? I would like to combine the home-away table into only one table.

I like your program.
I have a problem with league results table, it was working well up until I entered the results from my fourth fixture. the first thing was I had duplicate teams on results table and as there was only space for 20 teams the duplicates would replace existing teams. my second problem occurred after I continued to entering fixture results, my results table now showed N/A in all my league results table cells.

How can I fix this?

It lags everytime I select a box. I have a fully capable pc. I don`t understand it.

when i put the fixtures it doesnt auto updates

I have 9 teams but only 18 fixtures come out when each team plays each other twice is should be more

Is there a way to make teams face one another more than twice?

Hi there I have just purchased your programme on football fixtures and as other purchasers have said the fixture list you created was OK but for one thing. That is that some teams played many more home games than away games. I have created a fixture list of 20 teams with each team playing the other 19 teams on a home and away bases. In this fixture list I have allowed that teams like Everton and Liverpool will not play their home games on the same day, neither will any other teams that come from the same city. The majority of the fixtures are based on the teams playing at home one week and then away the next. The first 19 fixtures that Arsenal will play will be against the other 19 teams then the fixture will be reversed for the return matches.
I have downloaded the fixture list onto a CD together with a fixture list for 24 teams. If any of this information could be of any use to you in then will be only to glad to help you. Thankyou from Peter Gowing.

Hello
Can you upload this file for 32 team table? Table work only with 29 teams.

Hi

Great just what I needed but alas it doesn't work when you reduce it to 6 teams and 1 time play...click create and it just gives me an error mismatch of 13 and says debug but then the debug just freezes over.

Any ideas please?

Thanks,

Richard

hi alan
can you help me i have gamecenter and i need this excel fixture but i have 40 team for league and this excel just work for 29 team can you give me excel file have 40 team? i need this very much if you can help me plz

Thank you for creating and sharing this spreadsheet, its awesome!

Is there anyway of increasing the number of times each team plays each other?

I downloaded this spreadsheet for 20 teams home and away, had an issue in calculations tab where formula only went to the 19th team so table errored but after fixing that I noticed in the fixtures it’s not equal for home and away. I.e. one team has 36 home games and 2 away games

Table is brilliant, but unfortunately it won`t calculate the table after the second set of results are entered, also this couldn`t be used as a scheduler as one team, plays all its games at home, then all of them away.

if only there is a download

In the fixtures shown Liverpool were at home in weeks 30 - 38 but a good spreadsheet none the less 👍🏻

Is there a way you can do this in access too?

There is no app!?

Great Program, thanks. I'm going to use this for a darts league & was wondering how to change the win points from 3 to 2??

Hi Alan, is it possible to add more rounds from 2 to 4 as the maximum as we only have 4 to 6 teams & normally play 3 to 4 rounds depending on the number of teams??

While its creating the correct amount of fixtures, its not sharing the correct amount of home and away games. i,e some teams are playing the sdame opponent at home twice but not away

Downloaded today and it works really well with minimal effort, thank so much!

HI, Im loving the sheet but having issues after I enter the scores for week 1. For some reason some of the teams are showing up twice in the league table once I enter the scores? It does it on the original sheet I downloaded also even before I made my amendments. Thanks

can you do this on google sheets

Can you reupload the files? THe link is broken. thank you

Does it only work on Excell or can I use it for WPS office or even open office?

How do I download this please

Thanks it is what have been looking for thumbsup

Love the Table. but how do i get rid of home and away stats. and just have win/loss and goal difference? Many thanks in advance

You didnt show how to make it update the league table.

This is great! just a quick question is it possible to edit the value of the W -D -L. I was looking to edit it to W - 3, D -2, L-1.

IF IWANT TO CHANGE TEAM NAME WHY ITS NOT APPLY IN FIXTURE SHEET

Is there a way for penalty point system?

Good template - thought doesn't balance home vs away games. Did a 10 team league with each team playing each other once, and the first team had 1 home game and 8 away games.

Thank you for the worksheet. Great Job.

Hi I like fixture maker can you show me how to make a boxing one.

I am getting a type mismatch error 13 message when trying to run fixtures. Any guidance?

Everton and Liverpool can’t play at home the same time

Hi When i input results the table produced duplicates and omitted some teams. Any help greatly appreciated

Hi, great spreadsheet, i have two queries i would really appreciate some help on.
1. When i change to 30 teams, it lets me input all names, but only shows 29 teams in the league table.
2. If i want the win/draw points to be whatever the score is e.g Team A 2 v 1 Team B - I would like it 2 points to A and 1 to Team B.

Thanks

Thank you so much for this excel sheet. It helped a lot.

I know this was 12 years ago but thank you so so much for making this free. You have saved me about 5 hours. Hope you're still doing well :) Have a great day!

12 years ago? wow thanks

Does not work!! I don't have Excel I have LibreOffice and their calc spreadsheet. Can generate the fixtures but when I put in the results the league table does not update.