Schedule conflicts for players/teams

[reeveta]

Here are the results for the Ducks, who, as I mentioned before, are one of the more different schedules.

Avalanche 41
Blackhawks 44
BlueJackets 41
Blues 38
Bruins 36
Canadiens 33
Canucks 39
Capitals 36
Coyotes 40
Devils 34
Ducks 82
Flames 36
Flyers 31
Hurricanes 41
Islanders 32
Kings 34
Lightning 30
MapleLeafs 30
Oilers 39
Panthers 35
Penguins 28
Predators 30
Rangers 35
RedWings 37
Sabres 38
Senators 38
Sharks 38
Stars 35
Thrashers 42
Wild 39

[Shoeless]

If it\'s a spread sheet, could you not just post it online in google docs and then post the link here??

[reeveta]

I have never used google docs, how does it work?

[Shoeless]

http://www.google.com/google-d-s/tour1.html

Basically you start a free account and upload your file which gives it a URL which you can post here. You can lock your spreadsheet and limit who sees it etc. All free.

Really just taking a file from your computer and making it accessible online.

[Miqualle]

[email protected]

Thanks Reeveta!!

[reeveta]

I checked out Google-Docs but in order to share the document I have to enter the email address of those who I want to allow to share it... basically the same amount of work as emailing it. Unless I am missing something.

[Shoeless]

Can\'t you share it with the world? Not have any requirement there? Like this one.

*edited

[reeveta]

Awww... got it! The command that I needed was ‘publish.’ Learn something new every day. Thanks Shoeless.

Here it is:
http://spreadsheets.google.com/pub?k...IPCKNMWwEf-lGQ

This is very exciting. Assuming this works out, you guys are in for some real treats. I look forward to sharing some of the 100 MB worth of hockey pool related spreadsheets I have developed over the years.

[duballstar014]

Thanks reeveta...curious though. How were these numbers calculated?

[Shoeless]

Thanks Reveeta - that is a pretty sweet piece to have.

[reeveta]

How the data was made:

I have a spreadsheet set up with the ‘date’ on the left column and all 30 teams along the top*. In each column there is a ‘1’ of that team plays on that day. To compare two teams simply multiply their two columns together. The excel commands were slightly more complicated than that but that is the theory of it.


*How the schedule data was created in the first place is a bit too difficult to explain here but it involves some cutting and pasting from the web, \'text to column commands\', \'vlookup\' commands and \'if\' statements). I did this last year and it took me a few days to come up with everything. However this year I had the data in and ready in a few hours.

[Shoeless]

I hope Dobber sees this and somehow finds a way to link to it on the left similar to the Lookj Ahead - very useful when considering drafts and trades.

[duballstar014]

Interesting. I love Excel and am always trying to learn new formulas or tricks. The vlookup is one of my favs. That thing can really make life easy.

[reeveta]

I am sure a bunch of the forum faithful will find the data here.

duballstar014: I am with you, the day I discovered vlookup was one of the happiest days of my life. I am that pathetic.

[tml4everpz]

thanks alot man. thats some good work right there.