Game contests

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
Click to expand...
Cool. Thanks for the help.

If you said it would be NU 10 and Pitt 7 and it was NU 7 and Pitt 10, you would have been off by 6. 3 on the Husker side and on the Pitt side. AFAIK we are looking for differences on each side, not necessarily related to each other.

Does everyone agree with this method? I looked over what we had done in the past and I thought I gathered that method?

I'll look at the lookup function again also. It's probably some dumb thing like you mentioned :)

 
MAN - how do you save a file on here like that?
Click to expand...
FTP :)

Get an FTP client (I recommend filezilla.sourceforge.net). The user name is mods and the password is huskerboard1. Then you can upload and download files.

yea, i am pretty sure I should just write a macro that examines all the differences looking for who has the same, then getting their name from the other column. That would account for ties. I should even then be able to examine their total yardage differences and break the tie that way.

For lookup, do the columns have to be continuous? I guess there is one way to find out :)

 
Last edited by a moderator:
apparently they don't because that didn't work either. After writing firmware for an x86 based system, this stuff makes me feel f'ing dumb :lol:

 
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.
Click to expand...
Frank,

Thanks for updating the link. No I dont mind about the tiling, but currently it looks off-center on both IE & FF -- does anyone else see this? http://www.huskerboard.com/mods/2005_Huske...er_schedule.htm

 
MAN - how do you save a file on here like that?
Click to expand...
FTP :)

Get an FTP client (I recommend filezilla.sourceforge.net). The user name is mods and the password is huskerboard1. Then you can upload and download files.

yea, i am pretty sure I should just write a macro that examines all the differences looking for who has the same, then getting their name from the other column. That would account for ties. I should even then be able to examine their total yardage differences and break the tie that way.

For lookup, do the columns have to be continuous? I guess there is one way to find out :)
Click to expand...
Thanks for the work on this guys - this should really help make this process easier in the future.

FYI Ruff, in case you didnt realize the ftp "address" is www.huskerboard.com -- Dave listed the username & pw and you can use "21" for the port. but just let me know if you need a hand with getting this set up.

 
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.
Click to expand...
Frank,

Thanks for updating the link. No I dont mind about the tiling, but currently it looks off-center on both IE & FF -- does anyone else see this? http://www.huskerboard.com/mods/2005_Huske...er_schedule.htm
Click to expand...
:wtf

It's back to the way it was - a tiling effect that has the full image with the letters on it, and the extreme left of the image being repeated. Odd. What I had done was elimanted the nested cell, then inserted a single row, single column table in the topmost cell. I then set the width to 90% and centered it. Inserted the image and replaced the text. That gave it a single image, centered, with the text centered on it.

Not sure why it has reverted to the older look...

EDIT: Okay, think I have it fixed. If someone could take a look and make sure the red boarder at the top of the page is centerd and not repeating - it's the one with the words "2005 Nebraska Cornhuskers Football Schedule" in white - and let me know, I'd appreciate it.

 
Last edited by a moderator:
In Firefox, if I have the window a certain size it looks centered. If I have it maximized, it isn't centered.

In IE, it's centered all the time however the ends get cut off if the window is too small.

This is all at 1400x1050.

 
In Firefox, if I have the window a certain size it looks centered. If I have it maximized, it isn't centered.
In IE, it's centered all the time however the ends get cut off if the window is too small.

This is all at 1400x1050.
Click to expand...
Okay - I expanded the nested table to 100% of the width, and tried to center all elements. That should take care of it, but can't be sure.

At the moment, I don't have FireFox available (I only run it under my Linux box, which is undergoing a major upgrade - new mobo and processor). Under Windows, I run at 1280 x 960 - "experienced" eyes make higher resolutions a bit more difficult...

 
Dave - in an effort to keep it simple, could you leave the file as you have it and just do a "filter" on the difference column? Then each week you could use the "drop down" and select the lowest difference and everyone that has the lowest difference would be listed. You can have mulitple "filters" on each page so you can do the same for the yardage contest.

 
How do you apply an autofilter to just a few columns that are not contiguous? I try to select the colums I want to autofilter and Excel tells me I can't do that. GAY

 
Last edited by a moderator:
CR@P!, as soon as I say something then it doesn't work. I just selected the entire range of data (A2..W200) and put the Auto Filter on, this provides a filter for every column but you'd only use the filter on the differnce column.

damn - this if tuff

 
Dave, Ruff had me upload his new creation to the server for you b/c he couldnt get it out on the interweb by himself. he can pivot a table like noones biznass but when it comes to 'pooterz he falls a little on the short end of the bus. oh well he's learnable.

http://www.huskerboard.com/mods/Excel/

Looks rockin to me, then again Im not very gud at pivit tables so it may very well suck.

 
Last edited by a moderator:
Back
Top