Apolyton NFL Regular Season Divisional Predictions!

[Donegeal]

Originally posted by flash9286
how come I have 0 pts?

Because you don't have any teams in their proper place.

Quick! Go change your picks so that the way things stand after one week is the way you think they will end up!

[flash9286]

Originally posted by Donegeal


Because you don't have any teams in their proper place.

Quick! Go change your picks so that the way things stand after one week is the way you think they will end up!

You gave other people that had Phi 2nd in NFC East points but not me. Same with Pit, Mia, Gb, etc.

[Donegeal]

Hold on.. let me go check the formulas...

[Donegeal]

Ok, here you go. I must have missed your colum when I did my formula adjustments. Sorry. Here is the corrected version.

[snoopy369]

Donegeal, check this sheet out ... the column adjustments should not be necessary, if you use fixed reference structure. I used the old sheet you uploaded, so if you've made changes it doesn't reflect that, but otherwise it should be correct in all cells ...

[Donegeal]

AAAAAHHHHHH! So the $ is like a lock for a cell/row/column so it doesn't get changed when you copy/paste!

OMG, you just made me 10x as efficent!

[snoopy369]

If I have time I'll work out the formula for ranking that takes into account ties, also ... it's complicated, but it is possible.

[Donegeal]

Don't I know it! I'm trying to put together a way to do tie breakers for my Fantasy Football spreadsheet (I spreadsheet I am very proud of... its to big to post on this forum). Breakdown is susposed to go record, head-to-head, div record, tot points scored, tot points allowed, coin toss, fist fight. It's a challenge, but it's fun trying.

[Berzerker]

AFC east

NE 10-6
NYJ 9-7
Buffalo 7-9
Miami 3-13

AFC north

Pitt 12-4
Cle 9-7
Balt 8-8
Cinc 5-11

AFC south

Indy 11-5
Tenn 10-6
Hou 7-9
Jax 6-10

AFC west

Den 11-5
SD 9-7
KC 6-10
Oak 5-11

--------------------

NFC east

Dall 13-3
Philly 10-6
NYG 9-7
Wash 6-10

NFC north

GB 9-7
Chi 8-8
Det 5-11
Minn 5-11

NFC south

NO 11-5
Car 9-7
TB 7-9
Atl 6-10

NFC west

Az 9-7
Sea 9-7
SF 6-10
Stl 6-10

[-Jrabbit]

Rabbit Turds

I'm curious -- How are ties resolved? Say, if St. Louis and San Francisco tie for 3rd/4th in the NFC West... How would that be scored? Obviously, whatever Dongeal says, goes.

Anyway, here are my picks...

AFC East
Buffalo
New England
N.Y. Jets
Miami

AFC North
Pittsburgh
Cleveland
Baltimore
Cincinnati

AFC South
Indianapolis
Jacksonville
Tennessee
Houston

AFC West
San Diego
Denver
Kansas City
Oakland

NFC East
Dallas
Philadelphia
N.Y. Giants
Washington

NFC North
Green Bay
Minnesota
Chicago
Detroit

NFC South
New Orleans
Carolina
Tampa Bay
Atlanta

NFC West
Arizona
San Francisco
Seattle
St. Louis

[Donegeal]

It goes by what ever order/tie breakers the NFL uses. We are going to be going off the Standings by Division page (http://www.nfl.com/standings ). Only occasionally do things get so tied up in the NFL that they need to flip a coin to determine what place a team came in.

I'll update the spreadsheet and repost it hopefully by Wednesday.

[-Jrabbit]

Really? So when two teams tie for 3nd at 6-10, the NFL declares one of them 3rd place and the other 4th?

Didn't know that...

[SlowwHand]

He's not going to get into all the statistical tie-breaker crap for this that the NFL does, I wouldn't think.

Just call them losers and move on.

[Donegeal]

Yeah... the NFL determines everybodies place. They have to for draft purposes. Can't have two teams drafting in the same spot (exception for Minnesota, who can't get their pick in on time).

[Will9]

My changes:

AFC East:
New England
Buffalo
New York Jets
Miami

AFC North:
Pittsburgh
Cleveland
Baltimore
Cincinnati

AFC South:
Tennessee
Indianapolis
Jacksonville
Houston

AFC West:
San Diego
Denver
Kansas City
Oakland

NFC East:
Dallas
Philadelphia
New York Giants
Washington

NFC North:
Green Bay
Minnesota
Chicago
Detroit

NFC South:
New Orleans
Carolina
Tampa Bay
Atlanta

NFC West:
Seattle
Arizona
San Fransisco
St. Louis