View Single Post
  #8   Spotlight this post!  
Unread 18-01-2017, 10:56
Mullen's Avatar
Mullen Mullen is offline
Registered User
FRC #0573 (Mech Warriors)
Team Role: Mentor
 
Join Date: Feb 2002
Rookie Year: 2002
Location: Bloomfield
Posts: 138
Mullen is a glorious beacon of lightMullen is a glorious beacon of lightMullen is a glorious beacon of lightMullen is a glorious beacon of lightMullen is a glorious beacon of lightMullen is a glorious beacon of light
Re: Scouting using Excel, please help

I have used Excel for scouting from 2012-2016, with fairly good results (made me pick your team twice at worlds in that time frame). As Mike mentioned, VBAs/Macros can make life a lot easier, though there are ways around it.

I used Macro's for submitting the data, but pulling it all back up for a team summary, rankings, etc. can be done with vlookups.

I'm taking the year off, so I'm not making a file this year, but if you have any questions or want some advice send me a message.

-Pat
__________________
2002-2003 : 573 Mech Warriors: Student
2005-2007 : 1504 Desperate Penguins: Mentor
2012 - 2016 : 573 Mech Warriors: Mentor
Reply With Quote