Season Predictions Contest Discussion

[dlrob315]

It is setup automatically to pull from the NHL website and into an Excel spreadsheet which is then using conditional formating for all of the pretty colors and fonts....but I can look at adding numbers. Maybe the top 3. Just would need to think about the display format for those without making it seem too crowded. Hmmm

Hey Biscuit, since you will be exploring more options, can you see if you can do a projection on the points for the standings.

 

[Ton]

It is setup automatically to pull from the NHL website and into an Excel spreadsheet which is then using conditional formating for all of the pretty colors and fonts....but I can look at adding numbers. Maybe the top 3. Just would need to think about the display format for those without making it seem too crowded. Hmmm

Can you PM me with some details on how you do that?

 

[BiscuitintheBasket]

Wow, that's pretty cool that you can get excel to do that, I know it has all sorts of fun functions like that but never bothered. It's not a big deal, seems like it might be a pain in the ass to do it, I just thought if you were doing the dirty work automatically anyway, that it might not be that much more work to ad some details... As you can see it doesn't matter as I'm still in tied for the lead, and will win by the end of the year. Do we have a tiebreaker? I can't remember, did we say it was the point total?

Actually I use XML as the conduit into Excel since XML is a tad easier to extract data from HTML pages. The import into Excel is via a VB script.





The tie breaker is the hawks point total.

 

[BiscuitintheBasket]

Can you PM me with some details on how you do that?

The actual code is proprietary and not owned by me. But I think this web page might give a hint of a possible method: http://blog.outwit.com/?p=54. Just keep in mind that to automate you will need to script the data into some format. I use XML as I mentioned above. Then an additional script to covert to excel in the format you want. An important thing to figure out is the data layout from the source...just isolate the web page to the data you want and pay attention to the URL format, then the location in the source to were the tags for the wanted data are.

 

[MassHavoc]

You are working way beyond my pay grade, haha.

 

[BiscuitintheBasket]

You are working way beyond my pay grade, haha.

You are still working on 5 for a look and 10 for you to jack off, eh?

 

[MassHavoc]

You are still working on 5 for a look and 10 for you to jack off, eh?

Jesus, if only.

 

[BiscuitintheBasket]

Results through the end of Dec 2011:

Mass, I got your add. ASN, maybe for Jan

 

[MassHavoc]

awesome, that is great exactly what I was thinking. Who is 's' under points? Kane?

 

[BiscuitintheBasket]

awesome, that is great exactly what I was thinking. Who is 's' under points? Kane?

That is on a need to know basis

I'll update as soon as I get the chance....and it is Sharp.

 

[MassHavoc]

ah yes. Guess that makes sense. Should have figured.

 

[BiscuitintheBasket]

Whoops, I forgot to post the results after the end of January and the team is on a slide for the month so far.



Results as of last night:

 

[Chief Walking Stick]

Masshavoc has as many points as I do and I didn't even enter the contest.

 

[MassHavoc]

Look at the top of the list there buddy.

 

[MassHavoc]

I love the Carcillo is still leading in penalty minutes.

 

[PatrickSharpRules]

Hahah I was pretty off, but Mass, you having zero is fucking hilarious

 

[MassHavoc]

How are people so dumb that they are not seeing this?

 

[BiscuitintheBasket]

How are people so dumb that they are not seeing this?

Donno, but it gives me a chuckle.

 

[Chief Walking Stick]

Well when I look at any pool I just look straight to the bottom to find Mass' score.



Good job on being in a 3 way tie for 1st... for now.

 

[BiscuitintheBasket]

As of the end of February: