Quote:
Originally Posted by gehrig38
I understand GMO is on hiatus, hope all is well. I want to create and personalize my own schedule, do I have to work each individual day to do that? I seem to understand how the ILN_BGN_ yadda yadda lays out, but once I format the Excel spreadsheet, which I did, here it is btw,
ILN_BGN_G162_SL1_D1_T4_D2_T6_D3_T4_SL2_D1_T4_D2_T4 _D3_T4_C_
That's line one, upper left of the sheet. What do I do when I've made sure the entire 2K plus lines in that column a, all read identical? Is there something to that that I can magically push or click to make that, make me my new schedule?
I am guessing no, and that I'm going to need to make my own, but if there is I'd seriously appreciate help.
26 teams, 4/6/4 in SL1 4/4/4 in SL2, no interleague, in 1 its 24 div games for 4 team div 9 non div games for 10 opponents with an odd game h/a, for the 6 teamer div it's 18 vs 5, and 9 vs the other 8 with same odd h/a
In the 12 teamer it's 22 div games, and 12 non div games vs 8 that gets me 162. I want to get off days, a few odd DH's, but a more personal one in the end....
|
No magical button..You'll have to schedule the games one at a time in excel.
"ILN_BGN_G162_SL1_D1_T4_D2_T6_D3_T4_SL2_D1_T4_D2_T 4_D3_T4_C" This should be the name of the lsdl file really. Not the first line of the schedule although it's part of it.
Your first line/row should look like this:
<?xml version="1.0" encoding="ISO-8859-1"?>
Second row like this:
<SCHEDULE type="ILN_BGN_G162_SL1_D1_T4_D2_T6_D3_T4_SL2_D1_T4 _D2_T4_D3_T4_C_" inter_league="0" balanced_games="0" games_per_team="162" start_month="4" start_day="7" start_day_of_week="1" allstar_game_day="0">
If you want an all star game just change the zero to the season day you want it on.
Start_month is the months of the year of course.
Start_day is the day's date of the month.
Start_day_of_week is the day of the week you want to start your season.
Sunday=1, Monday=2, etc.
3rd row like this:
<GAMES>
That's your first 3 rows of the spreadsheet. Make sure they're in the first cell of each row.
Now starting with row 4
First column every cell all the way to the end is: <GAME
Second column is: day="1"
day= is the day of the season. 2nd day of season is day="2" and so on. If there aren't any games that day, you skip it. Use it in each cell under Column 2 for every game you schedule on that day.
Third column is: time="1905"
Time needs to be set to the home team's time according to it's time zone.
4th column is: away="team number". end result is away="1", etc.
Visiting team and the team number is determined by Alphabetical order starting with your teams in SL1 D1 (Teams 1-4), then SL1 D2 (Teams 5-10), SL1 D3 (Teams 11-14), SL2 D1 (Teams 15-18), SL2 D2 (Teams 19-22), and SL2 D3 (Teams 23-26). In your league It would be 1-26. In other words, in Subleague 1 are teams 1-14 & Subleague 2 are teams 15-26.
5th column is: home="team number"
Home team of course. Same numbering as Away.
6th Column is: />
This is the end tag for xml
Once your schedule is finished:
Column 1 Next to last row cell 1 has: </GAMES>
Column 1 Last row cell 1 Has: </SCHEDULE>
That's the basics of the schedule in a nutshell. Probably not the info you were looking for, but what the heck.
