OK, I am really nervous about posting something that may be really amateurish but I have been using this spreadsheet for a while now and it works for me. I didn't search the whole thread so this may have been done already. Even if that is so, it was still fun.
In this
post GMO talks about re-arranging teams to keep the schedule fresh.
Below is a template for a given schedule (thanks GMO), where you can re-arrange the team orders easily and plug in the start day as it changes yearly. This file is set up for a 32 team 565 set up but I'm sure it can be re-jigged to fit any schedule you want. Just paste in a different schedule, then modify the references for a different number of teams and/or divisions.
My wife who is much better at Excel taught me the Vlookup formula that re-arranges the teams.
Please note the actual Vlookup references are at the bottom of the sheet. I put a dummy set in at the top so people would not have to scroll down.
Instructions are included. I apologize in advance for making it seem more difficult than it is.
I'm not very savvy on the right way to present these things so advice from anyone would be appreciated.
Download Here