If anyone has any ideas I'd be thrilled to hear them. This is the one issue I'm yet to iron out with the process. It may play 3 times in 20 games but on an isolated level, considering each team fixture list individually you can treat fixture 1 as game week 1 and so on. So each team won't play once every 16 games. The nearest I have managed to get is simply randomising the 256 fixtures and then running a countif to arrange each teams fixtures randomly in an order that runs 16 weeks and then a random bye week slotted in the middle. But I can't get excel to arrange these into game weeks where each team only plays once. Every team plays 16 matches in the correct format. That is, I can't arrange the games into game weeks. The one thing I can't do is correctly schedule the fixtures. To top it all of and because I don't like leaving jobs half baked, the sheet will also table these for you and correctly schedule playoffs for the pre 2020 playoff format. That is, it will correctly fixture 6 division games, 4 intra conference and 4 inter conference games and then the two remaining matches against intra conference opponents from the So I have managed to make an excel spreadsheet which will correctly fixture matches for the 8 NFL divisons in two conferences. I reasoned therefore that nobody has had a real stab at it outside Madden and god help all of us if that's the place we need to go for this. If you've found one, I'd be fascinated to see it. So your question prompted me to have a look online and there does not appear to be any resource to do this. I havent really tried any American sports before so this was a fun little challenge. And I might have a solution for your problem. The two teams square off Saturday night at Molson Stadium before. Toronto (10-6) concludes its regular campaign with a home-and-home series versus the Montreal Alouettes (8-8). I have this weird interest in using excel to simulate things. Theyve endured a sometimes quirky 2022 schedule but it has also delivered head coach Ryan Dinwiddie and the Toronto Argonauts to a very simple and emphatic completion. This may or may not be a bit late for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |