T1B

Posted: **Thu Jul 27, 2006 3:39 pm**

This has been making the email rounds over the past week, not sure if you've all seen it. Good stuff.

2006 NCAA Schedules by Conference

Posted: **Thu Jul 27, 2006 3:45 pm**

Thanks jimmah.

Posted: **Thu Jul 27, 2006 3:57 pm**

Pretty sweet.

Someone had a LOT of time on their hands...

Posted: **Thu Jul 27, 2006 4:56 pm**

:rts:

...rts, lil' help?

Posted: **Thu Jul 27, 2006 4:58 pm**

I hope that someday soon you and your family won't have the freedom to post in a forum, Dave.

- Scott

Posted: **Thu Jul 27, 2006 5:02 pm**

So you're that Scott guy that I've been reading so much about? I don't remember banning you...unless, it was the ban that turned into a robot

Posted: **Thu Jul 27, 2006 5:26 pm**

Excellent.

Sin,

File, Save As...

Posted: **Thu Jul 27, 2006 5:38 pm**

PSUFAN wrote::rts:

...rts, lil' help?

No prob, Rog. Just click this:

Posted: **Thu Jul 27, 2006 6:13 pm**

Thanks Meds, that is sweet

My favorite part is on the CUSA page, look at Rice's helmet.

Posted: **Thu Jul 27, 2006 7:26 pm**

That is pretty kick ass...thanks Rog!

Posted: **Thu Jul 27, 2006 9:18 pm**

=IF('Big 10'!$C$11:$N$11="W","Goin To Glendale","Fuck!!!")

(Sorry, just a little spreadsheet humor)

Posted: **Thu Jul 27, 2006 9:24 pm**

I get it.

Posted: **Thu Jul 27, 2006 10:45 pm**

what is up with the rice helmet???

Posted: **Fri Jul 28, 2006 12:01 am**

L45B wrote:=IF('Big 10'!$C$11:$N$11="W","Goin To Pasadena","Fuck!!!")

(Sorry, just a little spreadsheet humor)

I tried to have the spreadsheet tell me how many national championships Kal has won in the past year and it told me I had a circular reference and needed to turn on Iteration. :?

ps ftfy

Posted: **Fri Jul 28, 2006 12:47 am**

^^^^^^

I thought it would just return #N/A...

Posted: **Fri Jul 28, 2006 12:53 am**

Jimmy--

You implying that an undefeated tOSU team doesn't get a shot at the BCS Championship Game?

By the way, if you click on the Pac10 tab & run a Goal Seek to see how many losses Kal could afford to make it to their third straight NC game, I believe Excel automatically pastes a picture of the Golden Gate Bridge.

Posted: **Fri Jul 28, 2006 1:01 am**

Road wins outside the south for SEC teams? Huh?

sin,
#DIV/O!

Posted: **Fri Jul 28, 2006 9:58 am**

^^^^^^^^^^^^^

Rack the Excel humor...

Posted: **Fri Jul 28, 2006 1:08 pm**

MgoBlue-LightSpecial wrote:Excellent.

Sin,

File, Save As...

ditto

Posted: **Fri Jul 28, 2006 6:15 pm**

L45B wrote:=IF('Big 10'!$C$11:$N$11="W","Goin To Glendale","Fuck!!!")

(Sorry, just a little spreadsheet humor)

RACK...I'm a huge fan of IF/THEN's...they are what makes running a picks pool on Excel so easy.

Posted: **Fri Jul 28, 2006 6:29 pm**

No shit. My spreadsheet for the pickem games is over 3MB because of all the forulas I have in that bad boy.

Here's a quick one off my sheet.

=IF(G4=G$95,1,IF(AND(G4>0, G$95=-1),0.5,0))

One of my faves:

=SQRT(('Weekly Matchups(1)'!$Q$2-'Weekly Input(1)'!C7)*('Weekly Matchups(1)'!$Q$2-'Weekly Input(1)'!C7))

Posted: **Fri Jul 28, 2006 6:34 pm**

That a sweet spread sheet, someone needs to find a woman.

Posted: **Fri Jul 28, 2006 7:08 pm**

RACK the spreadsheet.

RACK this vvvvvv

Jimmah wrote:Road wins outside the south for SEC teams? Huh?

sin,
#DIV/O!

And RACK THE hell out of this! vvvvv

L45B wrote:By the way, if you click on the Pac10 tab & run a Goal Seek to see how many losses Kal could afford to make it to their third straight NC game, I believe Excel automatically pastes a picture of the Golden Gate Bridge.

Posted: **Fri Jul 28, 2006 8:17 pm**

IndyFrisco wrote:No shit. My spreadsheet for the pickem games is over 3MB because of all the forulas I have in that bad boy.

Here's a quick one off my sheet.

=IF(G4=G$95,1,IF(AND(G4>0, G$95=-1),0.5,0))

One of my faves:

=SQRT(('Weekly Matchups(1)'!$Q$2-'Weekly Input(1)'!C7)*('Weekly Matchups(1)'!$Q$2-'Weekly Input(1)'!C7))

Aw shit, don't even make me bust out the VBA code that will force Ohio State to win all their games.

Sub ()...

Posted: **Fri Jul 28, 2006 8:23 pm**

Rack this thread....

For reminding me I have eternal BODE on all you fuckers!

- Ducksdale

Posted: **Fri Jul 28, 2006 8:43 pm**

Those functions only work in excel when you're using an intel computer that was built in the U&L.

sin,
Doltdale

Posted: **Fri Jul 28, 2006 9:20 pm**

Hold on.....
# of wins/ 4 losses= the amount of losses I had predicted on our way to the national championship.
sin,
M2
function that fuckers.

Posted: **Fri Jul 28, 2006 9:39 pm**

if($KAL="Sucks Balls", "National Champions", "National Champions")

Posted: **Fri Jul 28, 2006 9:54 pm**

Wait...

=if(#ofIowafirstroundpicks=85, "I will suck Kirk Ferentzs cock", "He can jam his man meat in my ass")

Sin,

Jon = Douche

ok so it wasn't that good...but hey i am trying...

Posted: **Sat Jul 29, 2006 12:30 am**

I find this thread a bit confusing.
Sincerely, ubb code scholar

Posted: **Mon Jul 31, 2006 9:56 am**

archive???

Posted: **Mon Jul 31, 2006 4:00 pm**

That RICE helmet should be used for Nebraska. White background Red logo, hell we all know what the N on their helmets stand for. Wouldn't this make more sense?

Dude must have linked the RICE helmet to the wrong place as every time RICE comes up in someone's schedule it shows our helmet.

Posted: **Mon Jul 31, 2006 4:18 pm**

Left Seater wrote: hell we all know what the N on their helmets stand for.

I didn't peg you for an mvscal hayta.

Posted: **Mon Jul 31, 2006 5:16 pm**

Left Seater wrote:we all know what the N on their helmets stand for.

Yup. Knowledge.

Posted: **Mon Jul 31, 2006 5:42 pm**

=if(#ofIowafirstroundpicks=85, "I will suck Kirk Ferentzs cock", "He can jam his man meat in my ass")

if($KAL="Sucks Balls", "National Champions", "National Champions")

rack

T1B

2006 Schedule Spreadsheet

2006 Schedule Spreadsheet