Anyone want a schedule for season 20?

[FrogMan]

I've been playing with the schedule for season 19, and I came up with a pattern. My assumption is that HT follows the same pattern for every league in every season... With that in mind, I've figured the schedule for my new league and even more than thaty, I've made an excel spreadsheet (what else?) that you can use to figure out who you'll be playing, at least for the first few weeks of the season...

The pattern I came up with will follow, if anybody wants to check it with their own league, that'd be good. The file is attached to this post, in there, fill in the light green space with team names in the order they finished in season 19 and the appropriate replacements in spots 1, 7, and 8. The NSI column is optional.

Here's the pattern, have fun!

FM


HOME AWAY
week_1
03-07-27 Team1 Team2
_ Team3 Team4
_ Team5 Team6
_ Team7 Team8
week_2
03-08-03 Team6 Team1
_ Team8 Team3
_ Team2 Team7
_ Team4 Team5
week_3
03-08-10 Team3 Team2
_ Team5 Team8
_ Team6 Team4
_ Team7 Team1
week_4
03-08-17 Team1 Team4
_ Team8 Team6
_ Team2 Team5
_ Team7 Team3
week_5
03-08-24 Team3 Team1
_ Team5 Team7
_ Team6 Team2
_ Team4 Team8
week_6
03-08-31 Team1 Team8
_ Team3 Team5
_ Team2 Team4
_ Team7 Team6
week_7
03-09-07 Team5 Team1
_ Team6 Team3
_ Team8 Team2
_ Team4 Team7
week_8
03-09-14 Team7 Team4
_ Team2 Team8
_ Team3 Team6
_ Team1 Team5
week_9
03-09-21 Team6 Team7
_ Team4 Team2
_ Team5 Team3
_ Team8 Team1
week_10
03-09-28 Team8 Team4
_ Team2 Team6
_ Team7 Team5
_ Team1 Team3
week_11
03-10-05 Team3 Team7
_ Team5 Team2
_ Team6 Team8
_ Team4 Team1
week_12
03-10-12 Team1 Team7
_ Team4 Team6
_ Team8 Team5
_ Team2 Team3
week_13
03-10-19 Team5 Team4
_ Team7 Team2
_ Team3 Team8
_ Team1 Team6
week_14
03-10-26 Team8 Team7
_ Team6 Team5
_ Team4 Team3
_ Team2 Team1

[Poli]

Mercy!

[FrogMan]

Ardent, your lack of practice in the French language is showing ;)

I assume you wanted to say "merci" as in thank you... But that's cool, I appreciate the effort :)

FM

[Poli]

Oh my bad and je ne sais pas.

Or something.
:)

[FrogMan]

:D :D

[FrogMan]

I'm a big goof. I just realized I never attached the file :D

There ya go!

FM

[MylesKnight]

Thank You FrogMan...

You certainly are living up to your billing as the Mr. Gadget of FOFC-Hattrick, my friend. :)

[MacroGuru]

Anyone know how to find out who from VI USA will be coming into VI.189 Next season to take over #7 and #8?

[FrogMan]

I don't know of any way. I guess you'll have to call them "D VI #1" and "D VI #2" :)

FM

[MacroGuru]

Bleh

I want to know who I get to stomp on right off the bat!

[FrogMan]

Dennis, what position did you finish your season in? I'd assume 5th or 6th, since I remember reading you had a qualifier. If you win it, you'll be playing the winner of the other qualifier in week 1. Check the current matches of the other team that plays a qulifier in your league...

Hope this helps...

FM

[MacroGuru]

I am 6th, the 5th place team has been playing to, we both play bot teams, so we should stay around.

As far as who replaces #7 and #8 is where my curiousity is.

[Alf]

Thanks Frogman.

Une question : comment fais-tu pour créer les colonnes dépliables (+ -) en haut. J'essaie et je ne trouve pas... Merci d'avance.

[thesloppy]

Ugggh, as a team in major debt it looks like fourth place was just where I DIDN'T want to end up, as 3 out of the first 4 games are played away.

[FrogMan]

Originally posted by Alf
Thanks Frogman.

Une question : comment fais-tu pour créer les colonnes dépliables (+ -) en haut. J'essaie et je ne trouve pas... Merci d'avance.

Alf, I'd assume you are working with the French version of excel, right. If so I'll have to wait until I'm at work. I have the English version here at home and the French at work...

Anyway, in English, you select the columns you wanna see grouped, then you go in the "Data" menu, the "Group and Outline", then "Group"...

Je crois qu'en français c'est dans le menu "Données", puis "Grouper" ou quelque chose du genre...

FM

[Alf]

Originally posted by FrogMan
Alf, I'd assume you are working with the French version of excel, right. If so I'll have to wait until I'm at work. I have the English version here at home and the French at work...

Anyway, in English, you select the columns you wanna see grouped, then you go in the "Data" menu, the "Group and Outline", then "Group"...

Je crois qu'en français c'est dans le menu "Données", puis "Grouper" ou quelque chose du genre...

FM

Ben en fait je suis encore en version "French" mais plus pour longtemps, je viens davoir un nouveau PC avec Win2000 au boulot, et c'est en anglais.

pour le français : c'est "Selectionner les colonnes ou lignes" + "Données" + "Grouper et créer un plan" + "Grouper"


MERCI !!!

C'est pour ma feuille de suivi de finances

A+

[FrogMan]

I knew that as soon as I'd give some sort of path, even in English, you'd figure it out in French :)

Glad to be of help. I learned that nifty little trick a little while ago and now I use it about everywhere...

FM

[DataKing]

I took French so long ago, all I can remember how to say is "Where is the bathroom?" and "Would you like to touch my little soldier?"

[TargetPractice6]

I like to go around the neighborhood and yell "When is your birthday?!?" at the little kids in German.

[FrogMan]

FYI, I just checked this schedule with the real thing and it fits. Just so you know when we get to week 14 of this season and everyone will be anxious to get their schedule for season 21...

FM