2006 Schedule Spreadsheet

Jimmy Medalions · Post by **Jimmy Medalions** » 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

Cicero · Post by **Cicero** » Thu Jul 27, 2006 3:45 pm

Thanks jimmah.

indyfrisco · Post by **indyfrisco** » Thu Jul 27, 2006 3:57 pm

Pretty sweet.

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

PSUFAN · Post by **PSUFAN** » Thu Jul 27, 2006 4:56 pm

:rts:

...rts, lil' help?

orcinus · Post by **orcinus** » 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

PSUFAN · Post by **PSUFAN** » 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

MgoBlue-LightSpecial · Thu Jul 27, 2006 5:26 pm

Excellent.

Sin,

File, Save As...

indyfrisco · Post by **indyfrisco** » Thu Jul 27, 2006 5:38 pm

PSUFAN wrote::rts:

...rts, lil' help?

No prob, Rog. Just click this:

Sky · Post by **Sky** » 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.

Shoalzie · Post by **Shoalzie** » Thu Jul 27, 2006 7:26 pm

That is pretty kick ass...thanks Rog!

L45B · Post by **L45B** » 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)

indyfrisco · Post by **indyfrisco** » Thu Jul 27, 2006 9:24 pm

I get it.

quacker backer · Post by **quacker backer** » Thu Jul 27, 2006 10:45 pm

what is up with the rice helmet???

Jimmy Medalions · Post by **Jimmy Medalions** » 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

buckeye_in_sc · Post by **buckeye_in_sc** » Fri Jul 28, 2006 12:47 am

^^^^^^

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

L45B · Post by **L45B** » 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.

Jimmy Medalions · Post by **Jimmy Medalions** » Fri Jul 28, 2006 1:01 am

Road wins outside the south for SEC teams? Huh?

sin,
#DIV/O!

buckeye_in_sc · Post by **buckeye_in_sc** » Fri Jul 28, 2006 9:58 am

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

Rack the Excel humor...

OUMO · Post by **OUMO** » Fri Jul 28, 2006 1:08 pm

MgoBlue-LightSpecial wrote:Excellent.

Sin,

File, Save As...

ditto

Shoalzie · Post by **Shoalzie** » 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.

indyfrisco · Post by **indyfrisco** » 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))

Frank Beamer's growth · Fri Jul 28, 2006 6:34 pm

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

GreginPG · Post by **GreginPG** » 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.

L45B · Post by **L45B** » 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 ()...

indyfrisco · Post by **indyfrisco** » Fri Jul 28, 2006 8:23 pm

Rack this thread....

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

- Ducksdale

Jimmy Medalions · Post by **Jimmy Medalions** » 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

Laxplayer · Post by **Laxplayer** » 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.

Jimmy Medalions · Post by **Jimmy Medalions** » Fri Jul 28, 2006 9:39 pm

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

buckeye_in_sc · Post by **buckeye_in_sc** » 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...

Nolesy · Post by **Nolesy** » Sat Jul 29, 2006 12:30 am

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

buckeye_in_sc · Post by **buckeye_in_sc** » Mon Jul 31, 2006 9:56 am

archive???

Left Seater · Post by **Left Seater** » 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.

indyfrisco · Post by **indyfrisco** » 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.

Jimmy Medalions · Post by **Jimmy Medalions** » Mon Jul 31, 2006 5:16 pm

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

Yup. Knowledge.

L45B · Post by **L45B** » 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