max Posted January 8, 2013 Share Posted January 8, 2013 How do I post spreadsheets?Indianapolis17 GP11 W6 L0 T366 PF411 PA-2.647058824 AVG DIFF/GAME ((PF-PA)/GP)-1.979022491 OPPONENTS' AVG DIFF/GAME-4.6261 AVG DIFF/GAME + OPPONENTS' AVG DIFF/GAME (add 2 to this number if the Colts are playing at home and subtract from visiting opponent's number to receive a spread.Example:Indianapolis Colts @ Arizona CardinalsCOLTS = -4.6261CARDS= -4.3256 (+2)Arizona (-2.3256) - Indianapolis (-4.6261) = 2.3004In Arizona, the Cardinals will beat the Colts by 2.I would love to give you all this spreadsheet, great for all sports. Link to comment Share on other sites More sharing options...
max Posted January 8, 2013 Share Posted January 8, 2013 Conference Semifinals Predictions:Broncos beat Ravens by 9Patriots beat Texans by 10 or 11Seahawks beat Falcons by 2 or 349ers beat Packers by 4*can't calculate the conference finals until the semis are over Link to comment Share on other sites More sharing options...
Still MIGHTY Posted January 8, 2013 Share Posted January 8, 2013 So that also adds in the extra playoff game the Colts lost by 15 points?Doesn't seem to take into account the whole 11-5 vs 5-11 thing either. Huh, funny, I though twins were important in the NFL. | ANA | LAA | LAR | LAL | ASU | CSULB | USMNT | USWNT | LAFC | OCSC | MAN UTD | Link to comment Share on other sites More sharing options...
ninersdd Posted January 8, 2013 Share Posted January 8, 2013 Wouldn't a QB on AZ give the Colts a couple of pick 6's though, and no way their offense could outscore Indy's? BEAR DOWN ARIZONA!2013/14 Tanks Picks Champion Link to comment Share on other sites More sharing options...
max Posted January 8, 2013 Share Posted January 8, 2013 So that also adds in the extra playoff game the Colts lost by 15 points?Yes. Link to comment Share on other sites More sharing options...
rams80 Posted January 8, 2013 Share Posted January 8, 2013 How do I post spreadsheets?Indianapolis17 GP11 W6 L0 T366 PF411 PA-2.647058824 AVG DIFF/GAME ((PF-PA)/GP)-1.979022491 OPPONENTS' AVG DIFF/GAME-4.6261 AVG DIFF/GAME + OPPONENTS' AVG DIFF/GAME (add 2 to this number if the Colts are playing at home and subtract from visiting opponent's number to receive a spread.Example:Indianapolis Colts @ Arizona CardinalsCOLTS = -4.6261CARDS= -4.3256 (+2)Arizona (-2.3256) - Indianapolis (-4.6261) = 2.3004In Arizona, the Cardinals will beat the Colts by 2.I would love to give you all this spreadsheet, great for all sports.Iä! Shub-Niggurath! The Black Goat of the Woods with a Thousand Young! On 8/1/2010 at 4:01 PM, winters in buffalo said: You manage to balance agitation with just enough salient points to keep things interesting. Kind of a low-rent DG_Now. On 1/2/2011 at 9:07 PM, Sodboy13 said: Today, we are all otaku. "The city of Peoria was once the site of the largest distillery in the world and later became the site for mass production of penicillin. So it is safe to assume that present-day Peorians are descended from syphilitic boozehounds."-Stephen Colbert POTD: February 15, 2010, June 20, 2010 The Glorious Bloom State Penguins (NCFAF) 2014: 2-9, 2015: 7-5 (L Pineapple Bowl), 2016: 1-0 (NCFAB) 2014-15: 10-8, 2015-16: 14-5 (SMC Champs, L 1st Round February Frenzy) Link to comment Share on other sites More sharing options...
IceCap Posted January 8, 2013 Share Posted January 8, 2013 In no way are the Arizona fricken' Cardinals better then the Indianapolis Colts. PotD 26/2/12 1/7/15 2020 BASS Spin the Wheel, Make the Deal Regular Season Champion 2021 BASS NFL Pick'em Regular Season Champion Link to comment Share on other sites More sharing options...
ninersdd Posted January 8, 2013 Share Posted January 8, 2013 Did the Colts overachieve this year? Probably. Dare I say that the Cards though, should've probably been a 2-3 winner instead of 5 this year. BEAR DOWN ARIZONA!2013/14 Tanks Picks Champion Link to comment Share on other sites More sharing options...
Funky Bunky Posted January 8, 2013 Share Posted January 8, 2013 So that also adds in the extra playoff game the Colts lost by 15 points?Yes.It's not a level comparison then, China boy. Link to comment Share on other sites More sharing options...
rainmaker17 Posted January 8, 2013 Share Posted January 8, 2013 STOP WRECKING THE NFL THREAD Link to comment Share on other sites More sharing options...
max Posted January 8, 2013 Share Posted January 8, 2013 No reason to go crazy, a team's strength of schedule is the sum of the average point differentials of their opponents. That's all I did, strength of schedule and point differential per game. Point differential per game to figure strength of schedule (R.P.I, basically). Arizona is better than Indianapolis, now, but if Indianapolis blew out Denver in Week 3, and Arizona got blown out by Denver in Week 13, and if Denver loses in a blowout to Baltimore in the playoffs, Denver's value goes down (point differential per game drops down more than their strength of schedule goes up), Arizona's would go down, and Indianapolis' would go up, making the Colts better than the Cardinals. We can use this idea to create league rankings based on only these two components, you just have to make the spreadsheet, figure out how to post it online, and explain it well enough. I think Funky Bunky is probably better at predicting the point spread than this model (gambling in China is illegal), so I think creating league-wide rankings is probably the model's best function.When are you ever going to find a level comparison, Funky Bunky? Link to comment Share on other sites More sharing options...
Kramerica Industries Posted January 8, 2013 Share Posted January 8, 2013 This kind of thinking with football doesn't work. Colts had some lucky W's, no doubt about it. But last I checked, quarterback's still have to play for every team in the NFL. And Arizona suffers from that. Link to comment Share on other sites More sharing options...
tBBP Posted January 8, 2013 Share Posted January 8, 2013 Can one of you smart guys tell me why we're arguing about the Colts and Cardinals here? One of them just got kicked out the tournament; the other was never even near it. *Disclaimer: I am not an authoritative expert on stuff...I just do a lot of reading and research and keep in close connect with a bunch of people who are authoritative experts on stuff. || dribbble || Behance || Link to comment Share on other sites More sharing options...
Seadragon76 Posted January 8, 2013 Share Posted January 8, 2013 Can one of you smart guys tell me why we're arguing about the Colts and Cardinals here? One of them just got kicked out the tournament; the other was never even near it.I'm a smart guy (more smart-assed then anything, though) and I even have issues with what this yutz is doing. He's saying that the Cardinals, who lost 11 out of their last 12 games, are better then the Colts.... and with that, the hamster in my head just had a heart attack. Link to comment Share on other sites More sharing options...
Gothamite Posted January 8, 2013 Share Posted January 8, 2013 The league really needs to get rid of natural grass fields. Roger Goodell can't keep talking about player safety without addressing the increased risk of injuries these fields cause.There's a huge difference between "natural grass fields" and "poorly maintained natural grass fields". The NFL should institute and monitor standards for its fields. The Green Bay Packers Uniform Database! Now in a handy blog. Link to comment Share on other sites More sharing options...
TFoA Posted January 8, 2013 Share Posted January 8, 2013 Can one of you smart guys tell me why we're arguing about the Colts and Cardinals here? One of them just got kicked out the tournament; the other was never even near it.There are many dark arts on the internet, one of which is the Art of Trolling. The man who started this fiery debate has apparently mastered it. Link to comment Share on other sites More sharing options...
HedleyLamarr Posted January 12, 2013 Share Posted January 12, 2013 So the high in Denver will be 18 on Saturday.....that could be interesting for Peyton..... Link to comment Share on other sites More sharing options...
Cujo Posted January 12, 2013 Share Posted January 12, 2013 Colin Kapernick starts against the Packers this weekend. So how does he show loyalty to his city? Dude breaks out his Milwaukee Brewers hat.Fcuking idiot. Link to comment Share on other sites More sharing options...
Gothamite Posted January 12, 2013 Share Posted January 12, 2013 In fairness, he was born in Milwaukee, wasn't he? Although I didn't think he was close to his birth mother. Probably just a fashion cap, without any thought to what it actually represents. The Green Bay Packers Uniform Database! Now in a handy blog. Link to comment Share on other sites More sharing options...
BlueSky Posted January 12, 2013 Author Share Posted January 12, 2013 Kaepernick looks like the frontman for a boy band. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.