Nationals Medalist Scoresheet

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

Nationals Medalist Scoresheet

Postby Deeisenberg » May 11th, 2009, 6:43 am

Hey, I just whipped this excel up, it has some programming so that you just put in numbers 1 through 6 representing 1st through 6th in each event under the school that got the medal at award ceremonies. It will count each schools total number of medals, as well as number of each individual medal. I have it made up for both divisions, B is sheet 2, and C is sheet 1. You will need a newer version of excel to open up the file, there is freeware that will open it, but you would have to redo the formatting. It also has trial events (not exploratory events, they won't be announced at ceremonies) for 1-3, these are separated from the rest, however there is another column that includes trial events in the medal count. This will also tell you what the minimum possible score that the team could be assuming they got all 7ths in the events they did not medal in. There is yet another bar that will tell you the same thing, but it will add in trial event scores, assuming that all trial events that didn't medal got a 4th. I also have columns that tell you the highest possible score assuming anything you didn't medal in got 62, which is a disqualification. There is another column that does the same, but once again factors in the worst possible score in trial events. You can download this now at http://www.2shared.com/file/5722343/4b3 ... sheet.html

Also, just so you know, if you downloaded this before Mon May 11, 2009 8:43 am, then it is not the final copy, the copy up here now has been improved.
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
croman74
Member
Member
Posts: 876
Joined: December 31st, 2008, 5:31 pm
Division: C
State: MI
Location: I was hoping you could tell me...
Contact:

Re: Nationals Medalist Scoresheet

Postby croman74 » May 11th, 2009, 2:13 pm

That's really cool. I'll mess around with that for a little bit.
My 2010 Events
Elevated Bridge-7th
Trajectory-1st
"Why does Sea World have a seafood restaurant?? I'm halfway through my fish burger and I realize, Oh man....I could be eating a slow learner." -Lyndon B. Johnson
Image

User avatar
sean9keenan
Member
Member
Posts: 107
Joined: May 10th, 2007, 3:31 pm
Division: Grad
State: PA
Location: Caltech
Contact:

Re: Nationals Medalist Scoresheet

Postby sean9keenan » May 12th, 2009, 4:42 am

That is a high quality spreadsheet. But we should probably be studying...

It would be pretty cool to see Augusta use this spreadsheet, haha.
SoCal Event Supervisor. H2S2O for ever. Competed in Builds & Physics events

robotman
Administrator
Administrator
Posts: 1447
Joined: June 29th, 2008, 7:37 pm
Division: Grad
State: TX
Location: 127.0.0.1
Contact:

Re: Nationals Medalist Scoresheet

Postby robotman » May 12th, 2009, 5:13 am

wow that is nice

GoldenKnight1
Coach
Coach
Posts: 169
Joined: May 2nd, 2009, 5:02 pm
Division: Grad
State: PA
Contact:

Re: Nationals Medalist Scoresheet

Postby GoldenKnight1 » May 12th, 2009, 6:27 am

Inuyashakusho, do you know Leo at Rustin?

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

Re: Nationals Medalist Scoresheet

Postby Deeisenberg » May 12th, 2009, 8:40 am

GoldenKnight1 wrote:Inuyashakusho, do you know Leo at Rustin?

I don't recognize the name.
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 “2009 Nationals”

Who is online

Users browsing this forum: No registered users and 1 guest