What's new
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

Hockey East Pick 'em: Week 1

Re: Hockey East Pick 'em: Week 1

Fivehole...do me a favor, wuddya? Go to this link and use your nstar email address to input your last weeks picks. I put mine in, we'll see if this works

Hold on....technical difficulties :)

Nevah mind...needs more time to work out kinks....dont have time right now..off to lunch then off to Massachoosetts. Lemme ask, does everbuddy here have a google account? Its free, if not, get one. :)

try this fivehole if you have a google account:

https://spreadsheets.google.com/ccc?key=0ArStdzaOtL6vdFU4bUVobk01enRXbjdzNnJ3LVZ6Z1E&hl=en
 
Last edited:
Re: Hockey East Pick 'em: Week 1

Fivehole...do me a favor, wuddya? Go to this link and use your nstar email address to input your last weeks picks. I put mine in, we'll see if this works

Hold on....technical difficulties :)

Nevah mind...needs more time to work out kinks....dont have time right now..off to lunch then off to Massachoosetts. Lemme ask, does everbuddy here have a google account? Its free, if not, get one. :)

try this fivehole if you have a google account:

https://spreadsheets.google.com/ccc?key=0ArStdzaOtL6vdFU4bUVobk01enRXbjdzNnJ3LVZ6Z1E&hl=en
Just saw this post. I added my picks and I think I shared it with you. :confused:
Anyway... I got 10 points, 2 more than you. :p
 
Re: Hockey East Pick 'em: Week 1

Just saw this post. I added my picks and I think I shared it with you. :confused:
Anyway... I got 10 points, 2 more than you. :p

Nicely done fivehole. That was pretty simple, huh? Now if we could get everyone else to enter their own picks each week, it would save someone the labor of all the entry.

So....on that thought, if anyone wants to participate, get yourself a google account, its free, and send your email address to me so I can get you in. For now, just enter your picks for week 1, I'll take care of week 2 manually, and we'll go live with a live spreadsheet for week 3. Hows that sound?

And yeah fiver, you got lucky on week 1. :)
 
Re: Hockey East Pick 'em: Week 1

I'll put up the week 2 spreadsheet tonight, after I get back to hotel. Busy closing out a bid this morning and the ss is on my other laptop. So I encourage everyone to get that google account asap and email, through uscho, your email address to me so I can get you in.
 
Re: Hockey East Pick 'em: Week 1

moorso needs to "log-out" so someone else can enter data (Last updated 13 hours ago!)
 
Re: Hockey East Pick 'em: Week 1

Sorry...I just gave access to a bunch of others. Go ahead in and enter your picks from last week. As I said, I'll get the week sheet up later tonight.
 
Re: Hockey East Pick 'em: Week 1

Yeah, I see the spreadsheet, formulas, list of who's in, but can't enter any data.
 
Re: Hockey East Pick 'em: Week 1

I was able to copy the sheet, - can anyone edit the one I copied?

H

Works for me. The first sheet was locked / protected. One question, though, I don't see any spot in the formula where it allows for the "bonus point" for correctly guessing the score.

And, as a side note, some extra explanation of the teams playing (dates, or full names) would be awesome. I got held up on MC vs. N for a little while, and I had to double-check all of my "paired" games (DU-UVM and UMass-UMinn).
 
Re: Hockey East Pick 'em: Week 1

Don't worry about first week. I'll put up second week tonite. Then you have two days to make picks. I'k have to enter first week manually.
 
Re: Hockey East Pick 'em: Week 1

1 point for winner, 2 for correct score or calling a tie, right? Did we have 3 points for calling correct score of a tie?
 
Re: Hockey East Pick 'em: Week 1

1 point for winner, 2 for correct score or calling a tie, right? Did we have 3 points for calling correct score of a tie?

Doesn't matter, the formula is still incorrect. If you input 2-8 for the UML-Maine game, you get 1 point. That's because the formula is currently 2 for a tie and 1 for a win with no consideration of score. A simple fix would be to append "+ IF(AND(E$2 = E3, F$2 = F3), 1, 0)" to all of the formulas.
 
Re: Hockey East Pick 'em: Week 1

I think I may have missed something along the way ... are we doing all picks and results via an outside source? Google docs? Not pasting code like last year?
 
Back
Top