|
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
|