|
![]() |
#46 |
NFL's #1 Ermines Fan
Join Date: Jul 2001
Location: My house
Casino cash: $2008491
![]() |
Here's an overlay of the two.
__________________
Active fan of the greatest team in NFL history. |
Posts: 142,442
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#47 |
Diablo Negro
Join Date: Sep 2003
Casino cash: $1882662
|
Awesome stuff RM but are you going to feel responsible for the sudden drop in CP membership activity after the depression sets in?
|
Posts: 71,231
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#48 |
Diablo Negro
Join Date: Sep 2003
Casino cash: $1882662
|
This just proves that this place is a living proof that misery loves company.
|
Posts: 71,231
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#49 |
Veteran
Join Date: Feb 2001
Location: floating in a tin can
Casino cash: $605199
|
I am compelled to emerge from my hiding place to commend you, Rainman, on this fine piece of work. A stunning visual depiction of our collective ennui.
![]() ![]() ![]() now, back behind the drapes, no one look at my shoes.
__________________
What am I even doing here? |
Posts: 3,834
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#50 |
Champion Golfer Of The Year
Join Date: Aug 2001
Casino cash: $4800607
|
|
Posts: 35,132
![]() |
![]() |
![]() |
#51 | |
The 23rd Pillar
Join Date: Sep 2002
Casino cash: $10019237
|
Quote:
Great work, Rain Man. Can you do all 32 franchises now so we have something to compare to? ![]()
__________________
![]() “Boy, you all want power. God, I hope you never get it.” - Lindsay Graham |
|
Posts: 110,871
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#52 |
The 23rd Pillar
Join Date: Sep 2002
Casino cash: $10019237
|
Ouch. It looks like the Chiefs are the Raiders without their glory years. I didn't need to see that.
__________________
![]() “Boy, you all want power. God, I hope you never get it.” - Lindsay Graham |
Posts: 110,871
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#53 |
NFL's #1 Ermines Fan
Join Date: Jul 2001
Location: My house
Casino cash: $2008491
![]() |
As an update, our stock index now stands at -21.43, which is the second-lowest season-ending stock index in Chiefs history. (The low season-ending point was -23.35 as we ended the 1988 season.) Interestingly, if we had lost the final game against the Broncos, our index would have been -23.43.
As noted before, the low point of all time was Week 4 of 1989 when our index dropped to -24.41 following a 1-3 start. If we lose our first four games next year we'll drop below this mark. I looked at another variable that I'll call hope. That variable is the change registered over the course of one season. Whereas the index captures total happiness, the Hope variable covers the change in happiness over the course of a year. Not surprisingly, the best years are the championship years. The Hope variable was a +13.99 in 1969, indicating a very bullish outlook. The next two hope jumps were in 1962 (+11.66) and 1993 (+9.84). On the contrary, the years when hope dropped most dramatically were 2008 (-11.39), 1977 (-10.87), and 2007 (-9.30). This year was a -4.83, which is bad but not as bad as other years. I think based on this we should call the Herm era the Era of Lost Hope.
__________________
Active fan of the greatest team in NFL history. |
Posts: 142,442
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#54 |
One with the Force
Join Date: Jan 2010
Casino cash: $10004900
|
This chart made me orgasm like Peter North after a week long hiatus from porn. Its a buttfucking work of art and you should be praised endlessly.
|
Posts: 879
![]() ![]() |
![]() |
![]() |
#55 | |
The Master
Join Date: Sep 2002
Location: Marion, IA
Casino cash: $10004925
|
So you're saying we should have sold out stock high in 1971?
__________________
-Watching Eddie Podolak Quote:
|
|
Posts: 23,101
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#56 |
Supporter
Join Date: Dec 2004
Location: Ozarks
Casino cash: $2000564
|
Missed this thread the first time Kevin, very nicely done. Well that is an understatement, my vocabulary will not do it justice.
It has been a long road. |
Posts: 33,896
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#57 |
#triggering
Join Date: Aug 2000
Location: Tejas
Casino cash: $2797229
|
Amazing work... would be cool to see the Broncos and Chargers... even the Seahawks for old time sake as an overall comparison. I'm not sure if you used the data from profootballreference.com or not, but if I could get you the data... just tell me how you did it.
__________________
![]() |
Posts: 30,486
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#58 |
Most Valuable Poster
Join Date: Oct 2003
Casino cash: $9360002
|
That's why you don't buy stock in the Chiefs... or bet on them.
Sell MORTIMER!!! SEEEEEEEeeeeeeeeeLLLLLLLLLLLLLL |
Posts: 36,698
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#59 |
Supporter
Join Date: Oct 2000
Location: In a shotgun shack
Casino cash: $9955202
|
I think I'll keep throwing good money after bad until the day I die.
*Sigh*......I'll never be able to retire at this rate. |
Posts: 14,932
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
#60 | |
NFL's #1 Ermines Fan
Join Date: Jul 2001
Location: My house
Casino cash: $2008491
![]() |
Quote:
Just take the enclosed spreadsheet and do the following: Go into pro-football-reference, and year by year grab the schedule/record. It's the page that looks like this: http://www.pro-football-reference.co...s/crd/2009.htm You can select the whole thing with a careful click and drag, and then copy the whole thing into cells G through AA. This is the only time consuming part because you have to copy and paste each year individually. However, there's a linky thing at the top that will let you go directly to the next year's table. It's very important to start with the first year of the franchise at the top of the spreadsheet and work your way down, with the most recent year last. For AFL legacy teams, that means you start with 1960. For other teams, you might be starting in 1920 or 1950 or 1976 or whenever the team was founded. You then have to do the following: 1. Delete the bye weeks. 2. Cell F is nothing but a count, so it means nothing. 3. In Cell E, insert a 0 (zero) for non-playoff games, and a 3 for any playoff games. 4. Cell D is the number of years since a playoff appearance, but I ended up never using that, so you can ignore it. 5. Cell C is the main formula, so leave it alone. 6. Cell B is the Year. Just a bookkeeping thing. 7. Cell A is some random calculations. The ones at the end of each year are the Hope Calculations, which merely compare the stock index at the end of one year to the next year. There are some other random calculations in there that you can ignore. All of this is optional. 8. You'll need to define the data set to update the graph, or otherwise it might not include the whole time period. That function depends on the version of Excel you have. If you don't know how to do that, just upload the file to me and I'll update the graph. If your team had more or fewer playoff appearances, you may need more or fewer rows. You can just copy the formula into any new rows you need. If you have an old version of Excel the file may not open. Let me know.
__________________
Active fan of the greatest team in NFL history. Last edited by Rain Man; 01-07-2010 at 10:04 AM.. |
|
Posts: 142,442
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() ![]() |
|
|