I've spent the past several hours creating this rather intricate MLS table on an Excel workbook. The tables for each conference are on the first two worksheets and each team has its own worksheet. When match results are entered into teams' worksheets, the conference tables automatically sort with tiebreakers and all (couldn't figure out how to get head-to-head to sort, so the tiebreaker just skips that one and goes straight to GD). All that is nothing fancy, but here's the cool part. The cells at the top left of the table worksheets marked "Game #" and "Date" allow you to enter X number of games or any given date and the table will automatically change and sort to how the table looked after each team played X number of games or how the the table looked on any given date. Call me crazy, but I think that's pretty neat. Let me know if I made any mistakes in entering the teams' schedules or anything. Enjoy! http://dl.dropbox.com/u/278788/ultra_mls_table_2012.xlsx
Lol, I thought someone might ask that. I guess there's not really any way to prove its safety. I can tell you that I don't even know how I'd go about making something malicious out of an Excel file, I'm not that smart
I was puzzled for a second when I saw this, but I just realized what happened here. This spreadsheet uses cells that aren't available in Excel 2003 and earlier. So it'll only work in Excel 2007 or newer. That was an oversight on my part. I can go in and fix it if you want me to.