National Medal Count Sheets

National Medal Count Sheets

Postby Deeisenberg on Fri May 07, 2010 8: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
Deeisenberg
Exalted Member
Exalted Member
 
Posts: 237
Joined: Sun Apr 29, 2007 10:23 pm
Location: Stony Brook University
Division: Grad
State: PA

Re: National Medal Count Sheets

Postby haven chuck on Sat May 08, 2010 1:41 pm

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
haven chuck
Exalted Member
Exalted Member
 
Posts: 343
Joined: Sat Apr 28, 2007 5:35 pm
Location: Strath Haven
Division: C
State: PA

Re: National Medal Count Sheets

Postby Deeisenberg on Sat May 08, 2010 6: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: Sun Apr 29, 2007 10:23 pm
Location: Stony Brook University
Division: Grad
State: PA

Re: National Medal Count Sheets

Postby Deeisenberg on Wed May 19, 2010 7: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
User avatar
Deeisenberg
Exalted Member
Exalted Member
 
Posts: 237
Joined: Sun Apr 29, 2007 10:23 pm
Location: Stony Brook University
Division: Grad
State: PA


Return to 2010 Nationals

Who is online

Users browsing this forum: No registered users and 1 guest