Go to Post Nonetheless, I would welcome it, as long as [The President] didn't restrict the number of discs that a Robot could hold. Oops, wait, too late, the GDC already did that. :-) - MooreteP [more]
Home
Go Back   Chief Delphi > FIRST > General Forum
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Spotlight this post!  
Unread 27-03-2009, 01:44
rsisk's Avatar
rsisk rsisk is offline
The GURU Channel
AKA: Richard Sisk
FRC #2493 (Robokong)
Team Role: Mentor
 
Join Date: Jan 2008
Rookie Year: 2007
Location: Riverside, CA
Posts: 2,748
rsisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond reputersisk has a reputation beyond repute
Send a message via MSN to rsisk
National Rankings

I have been gathering all of the Standings data in a database over the last few weeks of regionals and I would like to build a National Standings page, just like the regional standings page, but aggregating all the standings data together.

Some of the fields to include are pretty obvious, but I am having trouble figuring out how best to present some of the fields when teams play at more than one regional and I am hoping the statistics genius out there might lend a hand...

Rank -- Just like the regional, sort by QS, RS, then MP
Team -- Another no brainer, one entry per team
Wins -- Sum all wins
Losses -- Sum of all losses
Ties -- Sum of all ties
Played -- Sum of all matches played

Now here is where I get a bit lost...
QS -- Can't just do a sum because the more regionals, the higher this value would be. Maybe a weighted average? How best to calculate this?
RS -- Same thoughts as QS, maybe a weighted average?
MP -- I think this is easy, MAX(MP) from all regionals the team played

I would also add a new column...
Regionals -- Number of regionals where the team competed.


Any other data I should include?

Thanks in advance =
Reply With Quote
 


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
National Championship or National Chairman's Eric Bareiss General Forum 95 20-06-2005 22:07
National Rankings during the Season Andrew Scouting 13 12-02-2004 15:17
Rankings archiver 2001 3 24-06-2002 03:25
NATIONAL RANKINGS! archiver 2001 1 24-06-2002 03:18
NATIONAL RANKINGS... archiver 2001 0 24-06-2002 03:17


All times are GMT -5. The time now is 16:29.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi