Go to Post Achieving a goal by merely finishing, or reaching mediocrity is not acceptable; Excellence is the only satisfactory result. - AdamHeard [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

 
Reply
Thread Tools Rate Thread Display Modes
  #1   Spotlight this post!  
Unread 17-10-2009, 09:47
Andy Baker's Avatar Woodie Flowers Award
Andy Baker Andy Baker is offline
President, AndyMark, Inc.
FRC #3940 (CyberTooth)
Team Role: Engineer
 
Join Date: May 2001
Rookie Year: 1998
Location: Kokomo, Indiana
Posts: 3,412
Andy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond reputeAndy Baker has a reputation beyond repute
Send a message via AIM to Andy Baker
HOT ITEM: Qualifications Ranking program needed for FMS Lite

All,

We are currently getting started at the CAGE Match here in Indianapolis. We have the full field electronics system, but it is not working (and we have Mark Koors, FTA, debugging it currently). We will shortly switch over to FMS Lite.

The one thing we need for FMS Lite is an Excel file that gives us an output of final qualification rankings once the qualification matches are finished. We will be able to run matches, but just not quickly figure out the rankings at the end of quals. So... instead of re-inventing the wheel (re-creating the ranking software), we are ASKING IF ANYONE HAS THIS PROGRAM.

So... is anyone on here who can provide an Excel file to help us with this ranking issue?

If so... please email me (and post here) at this address.

Sincerely,
Andy Baker
Reply With Quote
  #2   Spotlight this post!  
Unread 17-10-2009, 10:10
Ken Leung's Avatar Unsung FIRST Hero
Ken Leung Ken Leung is offline
Dare to Live!
FRC #0115 (Monta Vista Robotics Team)
Team Role: Mentor
 
Join Date: May 2001
Rookie Year: 1999
Location: Palo Alto, California
Posts: 2,390
Ken Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond reputeKen Leung has a reputation beyond repute
Send a message via AIM to Ken Leung
Re: HOT ITEM: Qualifications Ranking program needed for FMS Lite

Hi Andy,

It might be a little outdated but it's better than nothing:

http://www.chiefdelphi.com/forums/sh...1&postcount=38

A spreadsheet that was used to calculate ranking for the 2008 game developed by mlombardo from 79. I am unfamiliar with the differences between 2008 and 2009's ranking system, if there are any, but at least you have something better than hand calculations.

Make sure you rename the file from .doc to .xls to make it work.

Good luck finding better ranking software this morning!
__________________
Hardware Test Engineer supporting RE<C, Google.

1999-2001: Team 192 Gunn Robotics Team
2001-2002: Team 100, 192, 258, 419
2002-2004: Western Region Robotics Forum, Score Keeper @ Sac, Az, SVR, SC, CE, IRI, CalGames
2003-2004, 2006-2007: California Robot Games Manager
2008: MC in training @ Sac, CalGames
2009: Master of Ceremony @ Sac, CalGames
2010: GA in training @ SVR, Sac.
2010-2011: Mechanical Mentor, Team 115 MVRT
Reply With Quote
  #3   Spotlight this post!  
Unread 17-10-2009, 12:54
gblake's Avatar
gblake gblake is offline
6th Gear Developer; Mentor
AKA: Blake Ross
no team (6th Gear)
Team Role: Mentor
 
Join Date: May 2006
Rookie Year: 2006
Location: Virginia
Posts: 1,934
gblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond reputegblake has a reputation beyond repute
Re: HOT ITEM: Qualifications Ranking program needed for FMS Lite

Probably too late, but... (I was delayed a bit by a power outage (how often does that happen))

See Attached

QP = 2, 1, or 0 = Win, Tie, Loss
RP = Lower Score of the two alliances

No QP or RP for any single team if that Team is disqualified

Add 1000xQP to RP to get Combined Points

Sort by Combined Points to arrange teams into a 1..N ranking

Use Find (See Cell A50) to highlight any team in the schedule.
Attached Files
File Type: xls FRC Ranking for AndyB.xls (51.0 KB, 24 views)
__________________
Blake Ross, For emailing me, in the verizon.net domain, I am blake
VRC Team Mentor, FTC volunteer, 5th Gear Developer, Husband, Father, Triangle Fraternity Alumnus (ky 76), U Ky BSEE, Tau Beta Pi, Eta Kappa Nu, Kentucky Colonel
Words/phrases I avoid: basis, mitigate, leveraging, transitioning, impact (instead of affect/effect), facilitate, programmatic, problematic, issue (instead of problem), latency (instead of delay), dependency (instead of prerequisite), connectivity, usage & utilize (instead of use), downed, functionality, functional, power on, descore, alumni (instead of alumnus/alumna), the enterprise, methodology, nomenclature, form factor (instead of size or shape), competency, modality, provided(with), provision(ing), irregardless/irrespective, signage, colorized, pulsating, ideate
Reply With Quote
Reply


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
Finding FMS Lite Jon236 Off-Season Events 5 29-09-2009 13:44
Kit item request for 2006 Swampdude Technical Discussion 16 13-11-2005 15:28
robot program state lite still stays yellow mgs Programming 2 28-01-2005 19:44
Suggestions for Qualifications Chris Hibner General Forum 16 28-09-2001 14:14


All times are GMT -5. The time now is 13:49.

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