Game contests

Blackshirt

Blackshirt

Team HuskerBoard
Hey, if anyone has about 30 mins of free time today, I was wondering if you could update the score prediction contest & start one for ISU. I have about 300 more emails to go through, and have already found about 15 that need a response related to the board, so it looks to be a busy few days getting back on track.

Here are the keys:

-Review the pitt thread to determine the winners for score & yards.

-Post a note in the contest & football forum listing the winners & linking to the old & new contest threads (dont forget to re-lock the Pitt thread)

-Pin the post in the football forum

-Start a new contest for the ISU game - you can just 'edit' the Pitt thread & copy the verbiage

-Make a post in the "total member points" thread with a list of the weekly winners

Let me know if anyone has questions about this. And if you guys are busy too I completely understand - I realize Im not the only one with limited time, so dont worry about it - the ISU game isnt for 2 wks, so I can get to it later this week if needed.

Thanks-

Chad

 
What do we do about ties? First one in get's it? I thinks that's how we've handled it in the past, just making sure.

edit: nevermind. I am dumb. reading the rules would help ;)

 
Last edited by a moderator:
Completed.

FYI- I made up a spreadsheet to use to help manage all the yardage and scores. I uploaded it to the FTP. Score.xls is the base file. Score-Pitt.xls is what I used to find the winners for this week.

I wanted to make the sheet more intelligent as to finding the winners for me, but didn't have much luck. The lookup function doesn't want to work for me (finding the min difference, then finding who had that min difference). Seems pretty simple, but I couldn't get it to work. I could probably write a macro or two that would do it.

The highlighting isn't automatic.

Speaking of macros, the file contains one macro. One that will Paste text from the clipboard as plain text. It's shortcut key is CNTL-A and it should be stored in the workbook.

Anyway, Chad, I would be happy to take over those weekly contests if you want me too. It won't be as much work now with the xls sheet. Let me know

Dave.

 
Last edited by a moderator:
Thanks a bunch Dave, good work. Great idea with the SS, b/c it will be getting increasingly more time consuming - Ruff would be proud. :)

Sure, that would actually be great if you could do it each week - very much appreciated. And if you get buried and just dont have time, dont feel like youre stuck with it.

 
Sure, that would actually be great if you could do it each week - very much appreciated. And if you get buried and just dont have time, dont feel like youre stuck with it.
Click to expand...
Cool. I will see if I can figure out why it wasn't working like I wanted it too. Maybe Ruff could help? I know Excel pretty well, but I am not strong in all the built-in functions.

 
Also, I've updated the hyperlink on the Schedule page to link to the ISU prediction thread. Also, Chad, hope you don't mind, but I modified the banner at the top of the page so that it wasn't tiling - meansing, the red bar that has the white text on it.

 
Update: I added some conditional formatting to the difference cells for the score and the yards differences that should help point out the minimum's for the winners.

(Basically, the conditional formatting says if a given's member's difference is equal to the minimum of all differences, the cell get's highlighted).

 
Nah, what I am doing for the scoring is taking the absolute value of the difference in their husker score and opponent score and adding them up. Then I use the MIN function to determine the minimum number from those numbers. The person with the minimum difference is the winner. It is the same for rushing and passing.

I wanted to the look up that number in the difference column and find the corresponding person's name (Differences are in column C, names in column A). LOOKUP says it will do this, but all I get is #N/A in the cell. I was using a formula like =LOOKUP(F3,A3:A200,D3:D200) where A is the column with the names and D is the column with the differences in score, F3 contained the minimum number in column D.

This doesn't account for ties, though. Ideally I would have a macro (as I don't think it's possible to find multiple matches with built in functions) that would find all the potential winners and concatenate their names in one or multiple fields. That wouldn't be difficult.

 
Where's the file located?

How 'bout using a "DMIN" or "DMAX" to list the smallest difference and then comparing this to the individual prediction difference and using the Conditional Formatting to highlight the cell if individual's difference is equal to the DMIN?

 
Where's the file located?
How 'bout using a "DMIN" or "DMAX" to list the smallest difference and then comparing this to the individual prediction difference and using the Conditional Formatting to highlight the cell if individual's difference is equal to the DMIN?
Click to expand...
Yea, that's basically what I am doing right now, but in a round about way I guess you could say. I'll look up DMIN. The most updated file (I am still messing with it) is here: http://www.huskerboard.com/mods/Excel/score.xls

 
Last edited by a moderator:
Nah, what I am doing for the scoring is taking the absolute value of the difference in their husker score and opponent score and adding them up. Then I use the MIN function to determine the minimum number from those numbers. The person with the minimum difference is the winner. It is the same for rushing and passing.
I wanted to the look up that number in the difference column and find the corresponding person's name (Differences are in column C, names in column A). LOOKUP says it will do this, but all I get is #N/A in the cell. I was using a formula like =LOOKUP(F3,A3:A200,D3:D200) where A is the column with the names and D is the column with the differences in score, F3 contained the minimum number in column D.

This doesn't account for ties, though. Ideally I would have a macro (as I don't think it's possible to find multiple matches with built in functions) that would find all the potential winners and concatenate their names in one or multiple fields. That wouldn't be difficult.
Click to expand...
I'm not sure we can use absolutes either. If I predicted NU 10 and Pitt 7 my difference would be 3 .... if the actual score was NU 7 and Pitt 10 the difference should be a negative 3 and thus only people who predicted Pitt to win would have a chance at winning . ...... or are we not doing it this way???

Also, if a lookup function isn't working then I'd check the formatting of the cells to make sure their the same (one cell isn't text vs. a cell that's a number format). I've also had problems when the cells look identical but one of the cells had a bunch of spaces on the end of it - in this instance just TRIM (I like that word :) ) the cell with the spaces.

Let me know if I can help or offer another set of eyes :thumbs

 
MAN - how do you save a file on here like that?

I added a column to the far left, inserted a formula referencing the difference column (+E3) and copied it all the way down the column and then did a vlookup back using the new column and name to retireve the name of the person that equals the MIN difference. One problem I see is when there's a tie. I don't think you can do a LOOKUP from right to left, it's gotta be left to right. The new column I added can be hid once the formulas are updated.

What about using a Pivot Table to sort the results, then you could copy & paste the all winners names that had the correct difference?

I'll try to look at it a lil' more later tonight.

 
Back
Top