National Medal Count Sheets

User avatar
Deeisenberg
Exalted Member
Exalted Member
Posts: 237
Joined: April 29th, 2007, 7:23 pm
Division: Grad
State: PA
Location: Stony Brook University

National Medal Count Sheets

Postby Deeisenberg » May 7th, 2010, 5:57 pm

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
Location: Strath Haven

Re: National Medal Count Sheets

Postby haven chuck » May 8th, 2010, 10:41 am

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
Location: Stony Brook University

Re: National Medal Count Sheets

Postby Deeisenberg » May 8th, 2010, 3:04 pm

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
Location: Stony Brook University

Re: National Medal Count Sheets

Postby Deeisenberg » May 19th, 2010, 4:27 pm

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


Return to “2010 Nationals”

Who is online

Users browsing this forum: No registered users and 1 guest