Quote:
Originally Posted by Coxmeatsandwich
I've been looking through this for about 15 minutes, and I am having trouble making sense of it. So I have gathered that every cell under "sched gen_" is a game for that day, example "A6" is a game, and so on, but could you explain to me how exactly I know what team is which? I'm trying to tackle a 12 team, 90 game schedule with 42 divisional games.(3 Divisions with 4 teams each)
|
The grid is set up to use as the record needed to create the line in the lsdl file. Where the A6 under the A2 header represents team 6 in the first division plays at team 2, the black means that team is under a home team line and they are an away team, the gold meas it is a non division game, with a team number in it, it is the home team ( the B4 on your schedule in sched gen 1. ) I do this because when I create the schedule I fill it in with the games, then I move it to the work area and simply copy the col with the day numers and the first column. I put this to the right of the grid and sort by team, verify that the schedule has the correct number of games so I would have a 2 col (one with a day and then the other is the away team. I simply take the number off the top of the grid and paste that into col 3) This gives me the day, away, home fields. I delete the records with no away team in col 2 and cut and paste the lines into the ootp schedule worksheet. This automatically creates the line needed in the lsdl file. I delete the column that I just processed and then do the next record. First col would be the day because I copied and did not cut it earlier the New 2nd col would be the next home team. It is really simple.
Now that is the short of it, When I do move the sched gen to the work area I do give each team an actual number that is used in the ootp schedule. This is done randomly so A1 might be 4, A2 might be 7 and so on. When I get to group B then those numbers are 8-14 and so on. I do this for a few reasons. It allows me to create a schedule with different matchups and non div opponents. and it allows me to keep the same game matchups for each division. Even if they are played in different weeks on the schedule.
Your schedule was different and I spent a lot of time creating a different schedule for each year because of the non division matchups and how they change each season. That is why in the non div worksheet you see 6 different tables for the matchups.
BTw, when I create the sched gen worksheet I copy the sched template put it in the sheet, copy the 4 div game tables and the table from the non div wrksheet that is for your season schedule, in your case I needed 6 different tables.
For placement on the schedule, I simply eyeballed it and put the game line by line on the schedule for each team. In your case I put all the non div lines every 3rd series. This worked out good as you can see by your schedule you have a pretty balanced schedule.
Your schedule was different from any I had done in the past because of using only 2 divisions out of the 3 for non div games. Usually a schedule maker will make 1 schedule and then simply change the numbers to give you 6 schedules. I don't like doing it that way and give different schedules as you can see by your schedule.
For your schedule it is easy I would create a grid that has a schedule for 3 home/3 away for all teams in your league. This is 22 series.
I would not do this but it would work for you. I would simply create a table with all the combinations of the 6 league games for each series and then flip to get the h/a combinations. To make it easy for you I would take a bowling schedule for 12 teams and use just 1 set of matchups. I would do the first line which is basically 1-2, 3-4.5-6 etc. Then it has matchups after that. You could do the first week in any combo 1-2, 4-3,5-6,8-7 (mix them up a bit) Then when you do the second line get as many home teams that match the line above, in 6 games 4-5 matches would be excellent. You only need to do this for 2 or 3 lines then you can use whatever home teams come up in the schedule and then do 2-3 lines that match somewhat to the line above. Do this for all 11 lines and then just flip the games for the second grouping. This is needed so that you can have 2-4 series runs. You will have 22 series and then 6 series for the div only matchups. You are wondering why I did not have a 3 game and a 4 game series div only record and then a non div only matchup. I did it this way because every team plays each other 3h/3a with the exception of the div playing a 4 game series h/a over that. So why mess around with div games only with the 3 game series since all teams have to play each other anyway.
Then all you have to do is to create 1 4 team schedule that is simply all combinations:
Something like (well exactly like this)
1-2
1-3 1-4
4-3
2-4 3-2
2-1
3-1 4-1
3-4
4-2 2-3
That is your complete schedule for your div games. This will be your 4 game series. 6 weeks worth. This is used for all divisions. so you may copy this 2 time to have one table for each of the 3 divisions and change the numbers to A1-A4, B1-B4 and C1-C4 or change table 2 and three to be number 5-8 and9-12. This will give you the opportunity to use a different combination on your schedule with out having a set pattern.
This will give you a 14 1/2 week schedule (100 days) with a 3 game break halfway point.
Daamn I just designed the whole thing for you. Did not want to do that because I know you wanted to learn. But this may be good me showing you so that it is easier for you the next time you create one. This schedule should now only take you a couple of hours to create if you put it into the grid like my sched gen then it will be done quicker and you can use the generated schedule sheet to create the lsdl file like I described above.
I know it is hard to follow in text, so if you want I will take your sched gen worksheet put it into the work area and create a record for the lsdl file and send you the spreadsheet with the changes. It will demonstrate how to do the lsdl file with no work or typing. I will do one record with out deleting any of the processes and you will see how easy this is.