View Single Post
  #2   Spotlight this post!  
Unread 11-06-2013, 17:22
Adam.garcia Adam.garcia is offline
Design Mentor
FRC #0004 (Team 4 Element)
Team Role: Mentor
 
Join Date: Aug 2009
Rookie Year: 1997
Location: High Tech LA
Posts: 133
Adam.garcia is just really niceAdam.garcia is just really niceAdam.garcia is just really niceAdam.garcia is just really nice
Re: Making an Excel Scouting Database

If you have all the match data in another table, you can utilize the vlookup command to pull all the raw data into a separate table, where you can do further analysis.

To get you started, here is a nice worksheet that implements the VLOOKUP feature.

http://www.chiefdelphi.com/media/papers/2815

You can find it used on the third sheet in the free speed box, where he uses a dropdown box to have users be able to select from a predefined list.

Let me know if this works, and if it does help, feel free to post on this forum for additional answers.
__________________
“The object of education is to teach us to love what is beautiful.”

“Never discourage anyone who continually makes progress, no matter how slow.”
Reply With Quote