Recently, I have been working very hard on some exciting behind-the-scenes upgrades for the blog. For example, I’ve been designing a number of web-mining processes to beef up my football and basketball databases, which should lead to more robust content in the future. I’ve also been working on an a much easier way to make interactive posts (without having to hard-code them or use plug-ins). My thinking is, if I lower the difficulty of creating interactive calculators and graph generators enough, then a collection of fun/interesting/useful resources should practically build itself.
To that end, I believe I have found the right tools to make moderately complex interactive charts and data out of spreadsheets, and I have been getting better and better at the process. As a test-run, however, let’s start with something simpler: A calculator for the much-maligned and nigh-impenetrable QB Ratings systems of the NFL and NCAA:
If all is working properly, the rating should re-calculate automatically whenever you change the data (i.e., no need to push a button), provided you have valid numbers in all 5 boxes. Please let me know if you have any difficulty viewing or using it.
From an analytical standpoint, there’s obviously not much to see here — though for certain values I am mildly surprised by the extreme disparity between the NFL and NCAA flavors.