National Medal Count Sheets

Locked
User avatar
Deeisenberg
Exalted Member
Exalted Member
Posts: 237
Joined: April 29th, 2007, 7:23 pm
Division: Grad
State: PA
Has thanked: 0
Been thanked: 2 times

National Medal Count Sheets

Post by Deeisenberg »

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
Events: Herpetology, Fossils, Entomology, Rocks & Minerals, Ornithology, Ecology
Nationals 2008: 1st in Herpetology
Nationals 2009: 1st in Herpetology, 2nd in Fossils

Harriton Class of 2010
User avatar
haven chuck
Exalted Member
Exalted Member
Posts: 343
Joined: April 28th, 2007, 2:35 pm
Division: C
State: PA
Has thanked: 0
Been thanked: 0

Re: National Medal Count Sheets

Post by haven chuck »

I just noticed that the B sheet has the C division trial events listed.It also doesn't count 6th place medals.
2010 Can't Judge a Powder- NATIONAL CHAMPIONS
2010 Science Crimebusters- 3rd in the NATION
User avatar
Deeisenberg
Exalted Member
Exalted Member
Posts: 237
Joined: April 29th, 2007, 7:23 pm
Division: Grad
State: PA
Has thanked: 0
Been thanked: 2 times

Re: National Medal Count Sheets

Post by Deeisenberg »

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.
Events: Herpetology, Fossils, Entomology, Rocks & Minerals, Ornithology, Ecology
Nationals 2008: 1st in Herpetology
Nationals 2009: 1st in Herpetology, 2nd in Fossils

Harriton Class of 2010
User avatar
Deeisenberg
Exalted Member
Exalted Member
Posts: 237
Joined: April 29th, 2007, 7:23 pm
Division: Grad
State: PA
Has thanked: 0
Been thanked: 2 times

Re: National Medal Count Sheets

Post by Deeisenberg »

Events: Herpetology, Fossils, Entomology, Rocks & Minerals, Ornithology, Ecology
Nationals 2008: 1st in Herpetology
Nationals 2009: 1st in Herpetology, 2nd in Fossils

Harriton Class of 2010
Locked

Return to “2010 Nationals”

Who is online

Users browsing this forum: No registered users and 3 guests