City totals after formula input.

After deciding on the final formula for determining pro sports success, the next step was to input all the data. Not exactly an easy task (ok, actually a monumental one), but with a few organized spreadsheets, we managed to input winning percentages and postseason results and output totals for all the sports franchises cities. Here's how the city totals stacked up (green is football, red is baseball, purple is basketball, blue is hockey):



And in case anyone is interested in seeing what the spreadsheets look like, here they are. Obviously, a database backend would have made this all much quicker, but unfortunately I have a background in design not programming. Still, a bit of elbow grease and Excel still does the trick. I'm thinking about making these databases available on Google docs eventually so you all can play with the numbers, but for now, here's a preview: