A Fantasy Baseball Schedule Request

[Jakeydude18]

Hi Everyone,

This request is a little bit different in that it doesn't involve OOTP, but a fantasy baseball league that I am in. The commissioner asked me to help make a schedule and I'm not the best at it but I've seen what everyone here has done and I hope one can help me out.

The league format minics the MLB divisions (ie, there are 6 divisions of 5). The commissioner wants to plan for an 11 week season based on the following:
Play each team in your division once (4 games)
Play each team in the same division but opposite league once (5 games)
Play one team from the other two divisions based on last year's winning percentage (1st in ALE plays 1st in ALC/ALW etc) (2 games)

Total of 11 games with no bye weeks. A simple excel spreadsheet would be amazing and again thanks in advance!!!

[gmo]

The attached csv can be loaded into a spreadsheet. It lays out the matchup weeks, which can be reordered. There are:

• 3 weeks with 5 interdivision matchups between 2 divisions in each league, 2 intradivision matchups from the division not playing interdivision, and 1 interleague matchup for the remaining team in each subleague
• 4 weeks with 2 intradivision matchups in each division and 3 total interleague matchups
• 4 weeks with all interleague matchups

No way to balance home/away. I laid it out with the first subleague having 5/6 home/away and the second having 6/5 home away. Certain individual interleague matchups could be flipped to get more balance between the subleagues.

The team identifiers are:

• 1-5 : first subleague first division
• 6-10 : first subleague second division
• 11-15 : first subleague third division
• 16-20 : second subleague first division
• 21-25 : second subleague second division
• 26-30 : second subleague third division

[Jakeydude18]

Thank you thank you thank you so so much GMO!!! This is exactly what I needed!!