National Medal Count Sheets
- Deeisenberg
- 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
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
.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
Nationals 2008: 1st in Herpetology
Nationals 2009: 1st in Herpetology, 2nd in Fossils
Harriton Class of 2010
- haven chuck
- 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
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
2010 Science Crimebusters- 3rd in the NATION
- Deeisenberg
- 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
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
Nationals 2008: 1st in Herpetology
Nationals 2009: 1st in Herpetology, 2nd in Fossils
Harriton Class of 2010
- Deeisenberg
- 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
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
.XLS
http://scioly.org/wiki/File:2010NatMedalCountB_(1).xls
.XLSX
http://scioly.org/wiki/File:2010NatMedalCountB_(1).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
Nationals 2008: 1st in Herpetology
Nationals 2009: 1st in Herpetology, 2nd in Fossils
Harriton Class of 2010
Who is online
Users browsing this forum: No registered users and 3 guests