Game contests

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:
I was going to suggest a pivot table but didn't want to get my nose in where it didn't belong. I'll fill free to make suggestions anyway :) I have this bloated opinion that I'm quite the spreadsheet jockey myself.

Actually, I was thinking you could write a simple little VB program with excel .txt file as a data source and have it calculate the winners for ya, with the press of a button, but that would be getting a little out of hand. Making a mountain out of a mole hill.

 
Back
Top