View Single Post
  #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,935
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