|
||||
|
05-10-2004, 04:29 PM | #1 |
Hall Of Famer
Join Date: Feb 2002
Location: Up There
Posts: 15,374
|
Getting OOTP's calendar to have the correct dates for the day of the week
I posted this in the OOTP6 discussion forum, but thought it ought to go here as well.
Because OOTP does not recognize leap years, there are times where the date for a given month will not line up to the correct day of the week. This can impact on the schedules, as off days might slide to weekends for example, or other similar types of annoyances. Therefore, to get the correct day of the week for each date, the proper "Year Starts On" day value needs to be entered on the "Edit Schedule" screen. Below is a little chart I put together which will show you the correct "Year Starts On" day value to use for a given year. If you set it as indicated, all of the days of the week will fall on the correct dates for that year from Mar. 1st onwards. Those wishing to use the real MLB schedule for a given year should definitely use this chart, otherwise the games may not be falling on the right day of the week. For fictional leagues, it's probably not as much of a concern, unless you're a stickler for detail and don't like the fact that the date for a given day of the week is not the proper one. In that case, this chart is for you too. Note that a * beside the year indicates that year is a leap year. The chart covers all of the years from 1871-2080. Code:
Year Starts On Year Starts On Year Starts On 1871 Sunday 1881 Saturday 1891 Thursday 1872* Tuesday 1882 Sunday 1892* Saturday 1873 Wednesday 1883 Monday 1893 Sunday 1874 Thursday 1884* Wednesday 1894 Monday 1875 Friday 1885 Thursday 1895 Tuesday 1876* Sunday 1886 Friday 1896* Thursday 1877 Monday 1887 Saturday 1897 Friday 1878 Tuesday 1888* Monday 1898 Saturday 1879 Wednesday 1889 Tuesday 1899 Sunday 1880* Friday 1890 Wednesday 1900 Monday 1901 Tuesday 1911 Sunday 1921 Saturday 1902 Wednesday 1912* Tuesday 1922 Sunday 1903 Thursday 1913 Wednesday 1923 Monday 1904* Saturday 1914 Thursday 1924* Wednesday 1905 Sunday 1915 Friday 1925 Thursday 1906 Monday 1916* Sunday 1926 Friday 1907 Tuesday 1917 Monday 1927 Saturday 1908* Thursday 1918 Tuesday 1928* Monday 1909 Friday 1919 Wednesday 1929 Tuesday 1910 Saturday 1920* Friday 1930 Wednesday 1931 Thursday 1941 Wednesday 1951 Monday 1932* Saturday 1942 Thursday 1952* Wednesday 1933 Sunday 1943 Friday 1953 Thursday 1934 Monday 1944* Sunday 1954 Friday 1935 Tuesday 1945 Monday 1955 Saturday 1936* Thursday 1946 Tuesday 1956* Monday 1937 Friday 1947 Wednesday 1957 Tuesday 1938 Saturday 1948* Friday 1958 Wednesday 1939 Sunday 1949 Saturday 1959 Thursday 1940* Tuesday 1950 Sunday 1960* Saturday 1961 Sunday 1971 Friday 1981 Thursday 1962 Monday 1972* Sunday 1982 Friday 1963 Tuesday 1973 Monday 1983 Saturday 1964* Thursday 1974 Tuesday 1984* Monday 1965 Friday 1975 Wednesday 1985 Tuesday 1966 Saturday 1976* Friday 1986 Wednesday 1967 Sunday 1977 Saturday 1987 Thursday 1968* Tuesday 1978 Sunday 1988* Saturday 1969 Wednesday 1979 Monday 1989 Sunday 1970 Thursday 1980* Wednesday 1990 Monday 1991 Tuesday 2001 Monday 2011 Saturday 1992* Thursday 2002 Tuesday 2012* Monday 1993 Friday 2003 Wednesday 2013 Tuesday 1994 Saturday 2004* Friday 2014 Wednesday 1995 Sunday 2005 Saturday 2015 Thursday 1996* Tuesday 2006 Sunday 2016* Saturday 1997 Wednesday 2007 Monday 2017 Sunday 1998 Thursday 2008* Wednesday 2018 Monday 1999 Friday 2009 Thursday 2019 Tuesday 2000* Sunday 2010 Friday 2020* Thursday 2021 Friday 2031 Wednesday 2041 Tuesday 2022 Saturday 2032* Friday 2042 Wednesday 2023 Sunday 2033 Saturday 2043 Thursday 2024* Tuesday 2034 Sunday 2044* Saturday 2025 Wednesday 2035 Monday 2045 Sunday 2026 Thursday 2036* Wednesday 2046 Monday 2027 Friday 2037 Thursday 2047 Tuesday 2028* Sunday 2038 Friday 2048* Thursday 2029 Monday 2039 Saturday 2049 Friday 2030 Tuesday 2040* Monday 2050 Saturday 2051 Sunday 2061 Saturday 2071 Thursday 2052* Tuesday 2062 Sunday 2072* Saturday 2053 Wednesday 2063 Monday 2073 Sunday 2054 Thursday 2064* Wednesday 2074 Monday 2055 Friday 2065 Thursday 2075 Tuesday 2056* Sunday 2066 Friday 2076* Thursday 2057 Monday 2067 Saturday 2077 Friday 2058 Tuesday 2068* Monday 2078 Saturday 2059 Wednesday 2069 Tuesday 2079 Sunday 2060* Friday 2070 Wednesday 2080* Tuesday |
05-10-2004, 08:09 PM | #2 |
Hall Of Famer
Join Date: May 2002
Location: Longmont, CO
Posts: 3,145
|
This is a little more advanced csv schedule making/using, but I liked the table above and decided to add something to it...
Say you import a csv format schedule for 2004 for a new career league and that schedule has its first games on Monday April 5, 2004. The "Year starts on" is set to Friday, and that gives you the calendar dates falling on the correct days of the week. When 2005 rolls around, you have a choice. If you do not touch the schedule, it will start again on Monday April 5. However that does not really exist as the first Monday in April 2005 is on the 4th. Changing the "Year starts on" to Saturday as shown by LGO's chart will put the calendar dates on the correct days of the week, but the schedule remains locked to the same dates. Everything would be shifted by a day of the week - the first games would then be on Tuesday April 5, 2005, series that had been Fri-Sun would then be Sat-Mon, etc. The easiest thing is to not do anything at all and just ignore the days of the week not matching the real calendar. But if you really care you can use the table above to change the weekdays and alter the csv file to make the game dates match up with the newly fixed calendar dates. What you need to do is change the first column of numbers in the OOTP csv format schedule file, which are the day numbers. If you are like me and always want your schedules to begin the first Monday of April, the first games are then on a day number between 91-97. Thus to be precise I need 7 different "versions" of each schedule to get everything correct. For 2004, that first day with games is 95, but for 2004 it needs to be 94. To make the one schedule version into the other you need to in this case subtract 1 from every number in that first column. If you know your way around a spreadsheet, this is pretty easy as you make a new column with the day numbers minus one then replace the old column. However, if there are comment lines (those starting with "#") in the csv file this process may not necessarily be so simple, though it is still doable just with more work. Also remember that each time you reimport a schedule you should just to be sure again set the All-Star Game date, as even if the date still shows up the game may not actually be on the schedule. If you make adjustments to the date of the first game with one one the csv schedule files, you should make the same adjustment to the All-Star Game date. For example, if the first games are moved from 4/5 to 4/3, you should move the All-Star Game forward 2 days also, say if it was on 7/13, move it to 7/11. So if you care enough to change schedules like this, or if you are making a schedule in the csv format you may want to use the additions to LGO's table I added below - info on the first Mondays of April. To make the first games of the season for a year on the first Monday of April, make sure the first games in the csv file are on the day number for that year shown in the table. It is simple arithmetic to key on a different day, e.g., subtract 7 from the day number to get the last Monday of March or add 4 to the day number to get the first Friday of April. This table is also available as a download at the bottom. Code:
For each year, three other things are shown: (1) YSO (Year starts on) - what to set the OOTP button to (2) FMA (first Monday of April) - date of that for the year (3) D# (day number) - the day number of that FMA for a csv schedule Remember the dates are all Monday and do not match the YSO days. Year YSO | FMA D# Year YSO | FMA D# Year YSO | FMA D# 1871 Sun | 4/3 93 1881 Sat | 4/4 94 1891 Thu | 4/6 96 1872* Tue | 4/1 91 1882 Sun | 4/3 93 1892* Sat | 4/4 94 1873 Wed | 4/7 97 1883 Mon | 4/2 92 1893 Sun | 4/3 93 1874 Thu | 4/6 96 1884* Wed | 4/7 97 1894 Mon | 4/2 92 1875 Fri | 4/5 95 1885 Thu | 4/6 96 1895 Tue | 4/1 91 1876* Sun | 4/3 93 1886 Fri | 4/5 95 1896* Thu | 4/6 96 1877 Mon | 4/2 92 1887 Sat | 4/4 94 1897 Fri | 4/5 95 1878 Tue | 4/1 91 1888* Mon | 4/2 92 1898 Sat | 4/4 94 1879 Wed | 4/7 97 1889 Tue | 4/1 91 1899 Sun | 4/3 93 1880* Fri | 4/5 95 1890 Wed | 4/7 97 1900 Mon | 4/2 92 1901 Tue | 4/1 91 1911 Sun | 4/3 93 1921 Sat | 4/4 94 1902 Wed | 4/7 97 1912* Tue | 4/1 91 1922 Sun | 4/3 93 1903 Thu | 4/6 96 1913 Wed | 4/7 97 1923 Mon | 4/2 92 1904* Sat | 4/4 94 1914 Thu | 4/6 96 1924* Wed | 4/7 97 1905 Sun | 4/3 93 1915 Fri | 4/5 95 1925 Thu | 4/6 96 1906 Mon | 4/2 92 1916* Sun | 4/3 93 1926 Fri | 4/5 95 1907 Tue | 4/1 91 1917 Mon | 4/2 92 1927 Sat | 4/4 94 1908* Thu | 4/6 96 1918 Tue | 4/1 91 1928* Mon | 4/2 92 1909 Fri | 4/5 95 1919 Wed | 4/7 97 1929 Tue | 4/1 91 1910 Sat | 4/4 94 1920* Fri | 4/5 95 1930 Wed | 4/7 97 1931 Thu | 4/6 96 1941 Wed | 4/7 97 1951 Mon | 4/2 92 1932* Sat | 4/4 94 1942 Thu | 4/6 96 1952* Wed | 4/7 97 1933 Sun | 4/3 93 1943 Fri | 4/5 95 1953 Thu | 4/6 96 1934 Mon | 4/2 92 1944* Sun | 4/3 93 1954 Fri | 4/5 95 1935 Tue | 4/1 91 1945 Mon | 4/2 92 1955 Sat | 4/4 94 1936* Thu | 4/6 96 1946 Tue | 4/1 91 1956* Mon | 4/2 92 1937 Fri | 4/5 95 1947 Wed | 4/7 97 1957 Tue | 4/1 91 1938 Sat | 4/4 94 1948* Fri | 4/5 95 1958 Wed | 4/7 97 1939 Sun | 4/3 93 1949 Sat | 4/4 94 1959 Thu | 4/6 96 1940* Tue | 4/1 91 1950 Sun | 4/3 93 1960* Sat | 4/4 94 1961 Sun | 4/3 93 1971 Fri | 4/5 95 1981 Thu | 4/6 96 1962 Mon | 4/2 92 1972* Sun | 4/3 93 1982 Fri | 4/5 95 1963 Tue | 4/1 91 1973 Mon | 4/2 92 1983 Sat | 4/4 94 1964* Thu | 4/6 96 1974 Tue | 4/1 91 1984* Mon | 4/2 92 1965 Fri | 4/5 95 1975 Wed | 4/7 97 1985 Tue | 4/1 91 1966 Sat | 4/4 94 1976* Fri | 4/5 95 1986 Wed | 4/7 97 1967 Sun | 4/3 93 1977 Sat | 4/4 94 1987 Thu | 4/6 96 1968* Tue | 4/1 91 1978 Sun | 4/3 93 1988* Sat | 4/4 94 1969 Wed | 4/7 97 1979 Mon | 4/2 92 1989 Sun | 4/3 93 1970 Thu | 4/6 96 1980* Wed | 4/7 97 1990 Mon | 4/2 92 1991 Tue | 4/1 91 2001 Mon | 4/2 92 2011 Sat | 4/4 94 1992* Thu | 4/6 96 2002 Tue | 4/1 91 2012* Mon | 4/2 92 1993 Fri | 4/5 95 2003 Wed | 4/7 97 2013 Tue | 4/1 91 1994 Sat | 4/4 94 2004* Fri | 4/5 95 2014 Wed | 4/7 97 1995 Sun | 4/3 93 2005 Sat | 4/4 94 2015 Thu | 4/6 96 1996* Tue | 4/1 91 2006 Sun | 4/3 93 2016* Sat | 4/4 94 1997 Wed | 4/7 97 2007 Mon | 4/2 92 2017 Sun | 4/3 93 1998 Thu | 4/6 96 2008* Wed | 4/7 97 2018 Mon | 4/2 92 1999 Fri | 4/5 95 2009 Thu | 4/6 96 2019 Tue | 4/1 91 2000* Sun | 4/3 93 2010 Fri | 4/5 95 2020* Thu | 4/6 96 2021 Fri | 4/5 95 2031 Wed | 4/7 97 2041 Tue | 4/1 91 2022 Sat | 4/4 94 2032* Fri | 4/5 95 2042 Wed | 4/7 97 2023 Sun | 4/3 93 2033 Sat | 4/4 94 2043 Thu | 4/6 96 2024* Tue | 4/1 91 2034 Sun | 4/3 93 2044* Sat | 4/4 94 2025 Wed | 4/7 97 2035 Mon | 4/2 92 2045 Sun | 4/3 93 2026 Thu | 4/6 96 2036* Wed | 4/7 97 2046 Mon | 4/2 92 2027 Fri | 4/5 95 2037 Thu | 4/6 96 2047 Tue | 4/1 91 2028* Sun | 4/3 93 2038 Fri | 4/5 95 2048* Thu | 4/6 96 2029 Mon | 4/2 92 2039 Sat | 4/4 94 2049 Fri | 4/5 95 2030 Tue | 4/1 91 2040* Mon | 4/2 92 2050 Sat | 4/4 94 2051 Sun | 4/3 93 2061 Sat | 4/4 94 2071 Thu | 4/6 96 2052* Tue | 4/1 91 2062 Sun | 4/3 93 2072* Sat | 4/4 94 2053 Wed | 4/7 97 2063 Mon | 4/2 92 2073 Sun | 4/3 93 2054 Thu | 4/6 96 2064* Wed | 4/7 97 2074 Mon | 4/2 92 2055 Fri | 4/5 95 2065 Thu | 4/6 96 2075 Tue | 4/1 91 2056* Sun | 4/3 93 2066 Fri | 4/5 95 2076* Thu | 4/6 96 2057 Mon | 4/2 92 2067 Sat | 4/4 94 2077 Fri | 4/5 95 2058 Tue | 4/1 91 2068* Mon | 4/2 92 2078 Sat | 4/4 94 2059 Wed | 4/7 97 2069 Tue | 4/1 91 2079 Sun | 4/3 93 2060* Fri | 4/5 95 2070 Wed | 4/7 97 2080* Tue | 4/1 91 Last edited by gmo; 05-14-2004 at 03:21 PM. |
05-11-2004, 12:25 AM | #3 |
Hall Of Famer
Join Date: Feb 2002
Location: Up There
Posts: 15,374
|
Good stuff gmo.
I had thought changing the Season Starts On date value would shift the schedule's dates, but I just tested that and it won't change the actual playing dates, but merely change the date considered the opening date of the season. So your chart is an excellent addition. Now it's time for me to download it... |
11-17-2005, 06:31 PM | #5 | |
Hall Of Famer
Join Date: Jul 2003
Location: College Park, Md.
Posts: 5,024
|
Quote:
|
|
11-22-2005, 11:23 PM | #6 |
Hall Of Famer
Join Date: Jul 2004
Location: The big smoke
Posts: 15,628
|
Thanks GMO. I was changing your schedules on my own but I'm glad you quantified it. I use the tab feature in Excel to store the column with the changed "day numbers" under the "year starts" day. So for a year starting on Monday I just copy and paste the column from the tab called Monday and rename the file. I don't know if this is the best way but it works for me.
Edit: Sorry tabs don't work in csv format. My bad. Just put the column with the revised "day numbers" off to the right and copy and paste.
__________________
Cheers RichW #stopthestupid “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit Last edited by RchW; 11-23-2005 at 01:33 AM. |
11-25-2005, 01:03 PM | #7 |
Hall Of Famer
Join Date: Nov 2004
Posts: 6,066
|
Excellent info, guys!!
This should help many to avoid a few problems I've had. Definitely helps me.
__________________
Fidel Montoya Asahi2 Baseball ex-Commissioner(Historical League Since 2004) www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!) Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required) |
11-26-2005, 02:16 PM | #8 |
Bat Boy
Join Date: Nov 2005
Location: Pennsylvania
Posts: 15
|
Being a 'newbie' here, this will definetly help me. Thanks.
__________________
I dream in black and white I dream 'cause I'm alive |
Bookmarks |
Thread Tools | |
|
|