Stat Nerds

[redfox000]

I am wondering if there are any other stat nerds out there. I have tool I created that generates an excel spreadsheet that lists out the historic standings for a given league, putting each team on a single row with the column headers being the year. The record is shown, along with if the team won the division, made the wild card, or won or lost the super bowl.

For me it is more fun to look over that and see the history of the teams than the way FOF outputs it. I am planning on expanding this much more with the stat leaders and history, but putting it all into an excel file with tabs is more fun for me.

If anyone is interested I can provide a link to the utility. If not I'll just save it and use it for myself

[QuikSand]

Some interesting dataviz of this sort on the IHOF webpage, hats off to Ben E Lou who is also flattered by the content there.

http://www.fof-ihof.com/leaguehistory.php

It takes logo familiarity for full effect, and this is a league with fictional teams/logos so that's a thing if you're not... but the second section here is an awfully efficient way to show a lot of stuff, imo.

[redfox000]

If anyone is interested, this is what it looks like...so far:

FOFHistory.xlsx

[QuikSand]

Looks pretty clean.

Open question... we know each season has 16 games. Two ties is very unusual. Would there be much loss to merely showing a single value for each team cell? frex, 9 conveys the same information as 9-7-0 just more efficiently.

And as a side note, the one piece of information that seems useful for use of something like a "power rating" is whether the team earned a bye week. With that, any takeaway from the postseason results would have a more complete view.

[redfox000]

Yes those could be added. Still have a lot I want to add but I can put that on the list. For now one could determine who got the bye by looking at the playoff results since the division round home teams would have had the bye but I can add that as well.