|
This is an easy fix.
Looking at this in excel I can fix this easily. The schedule I am looking at is probably the same schedule you are using. It will take time, but is really easy. This would give you 3 schedules.
Now I have a question. Are you comfortable with excel? I mean not really creating anything but simply entering a number into a table. I am asking because in each schedule teams only play 4 interleague opponents, but there are 5 or 6 in the other division. I could give you a spreadsheet to allow playing different teams each rotation. All you would have to do is enter on a table a new "result" number each time you use a schedule other than the first time. Example table will have numbers 1-32 in the left column.
All you do is to type a number in the right column (div 1 - 5 teams may be 1,2,3,4,5 originally) you would enter in the right any combination 1-5. This changes the matchups and since the subleagues play each other the same amount of time respective to their division, this would only alter matchups for the interleague. 1 may play 17,18,19,21 initially but by changing the order you may have playing 18,19,20,21 the second time through. This will always give you the opportunity to play every team eventually, even if it is not totally an even number through out your league history. Then the new results which are just 4 columns are pasted in the xml format page. Just past special, sort by date and home - copy the formatted data to your lsdl file.
This sounds complicated but it only takes about 1 minute to do - no entry on your part except for changing 32 values in a table. I will document this and after you do it once you will not need to have the documentation.
I will give you the initial 3 schedules already to go and I will upload the spreadsheet with simple 30 second instructions. If you don't want it maybe others may (probably even some of the fine schedule makers)
I am a data analyst not a schedule creator - but I like the idea of having only 1 schedule and having the ability to make unlimited number of schedule from it. Simple with the use of Excel.
I will have these done today some time.....
James
__________________
"It has been said that politics is the second oldest profession. I have learned that it bears a striking resemblance to the first." - Ronald Reagan
|