View Single Post
  #13   Spotlight this post!  
Unread 03-03-2009, 10:23
billbo911's Avatar
billbo911 billbo911 is offline
I prefer you give a perfect effort.
AKA: That's "Mr. Bill"
FRC #2073 (EagleForce)
Team Role: Mentor
 
Join Date: Mar 2005
Rookie Year: 2005
Location: Elk Grove, Ca.
Posts: 2,350
billbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond reputebillbo911 has a reputation beyond repute
Re: Easy to use Offensive Power Rankings (OPR) program for mid-regional scouting

Quote:
Originally Posted by Bongle View Post
In a command line:
Code:
oprnet (regional code) (year) (stat) > blah.csv
This uses the DOS redirect operator to send it to a text file. The stats are are tab-seperated so that you should be able to copy/paste it into excel and have all the cells line up properly.
I just tested this method with v.5. I needed to save it as a .txt file for Excel to open it correctly. No big deal.
I also noted that Excel sorted it backward. In other words, the highest ranked team was listed last.Again, this is no big deal and can easily be dealt with.
I'll test more to see if I can get Excel to import it in reverse sort order.
__________________
CalGames 2009 Autonomous Champion Award winner
Sacramento 2010 Creativity in Design winner, Sacramento 2010 Quarter finalist
2011 Sacramento Finalist, 2011 Madtown Engineering Inspiration Award.
2012 Sacramento Semi-Finals, 2012 Sacramento Innovation in Control Award, 2012 SVR Judges Award.
2012 CalGames Autonomous Challenge Award winner ($$$).
2014 2X Rockwell Automation: Innovation in Control Award (CVR and SAC). Curie Division Gracious Professionalism Award.
2014 Capital City Classic Winner AND Runner Up. Madtown Throwdown: Runner up.
2015 Innovation in Control Award, Sacramento.
2016 Chezy Champs Finalist, 2016 MTTD Finalist
Reply With Quote