Scioly.org

I have created two medals count sheets for use at nationals. Medal placings (1-6) are input in the respective column for the event and row for the school. This is counted automatically and various statistics such as medal counts for each individual type of medal, as well as total medal count, weighted medal count, gold medal ranks, total medal ranks, and weighted medal ranks. Also if schools competed last year various information of their performance is presented. In C division the results will also be shown (in italics) if the school competed in 08 but not 09. For C division teams having placed top 10 in 2009 or 2008 are bolded. All features should really be self explanitory. These can be downloaded at the links below in either .xlsx format (What I used to create them) or .xls format.
.xls files
http://scioly.org/w/images/6/6c/2010NatMedalCountB.xls
http://scioly.org/w/images/2/24/2010NatMedalCountC.xls
.xlsx files
http://scioly.org/w/images/4/4a/2010NatMedalCountB.xlsx
http://scioly.org/w/images/5/50/2010NatMedalCountC.xlsx

I just noticed that the B sheet has the C division trial events listed.It also doesn't count 6th place medals.

Bwah, I'll fix it in a bit. I am really not that surprised, I honestly didn't put that much effort into the B sheet.

Okay, here are the links for the fixed B.
.XLS
http://scioly.org/wiki/File:2010NatMedalCountB_(1).xls
.XLSX
http://scioly.org/wiki/File:2010NatMedalCountB_(1).xlsx