Thread: Scouting using Excel, please help
View Single Post
  #13   Spotlight this post!  
Unread 21-01-2017, 17:12
Captain_Kirch Captain_Kirch is offline
Alumni
AKA: Aaron Kirch
FRC #1625 (Winnovation)
Team Role: Alumni
  
Join Date: Jan 2015
Rookie Year: 2013
Location: Pecatonica Il
Posts: 51
Captain_Kirch is a jewel in the roughCaptain_Kirch is a jewel in the roughCaptain_Kirch is a jewel in the roughCaptain_Kirch is a jewel in the rough
Re: Scouting using Excel, please help
Sumif
Sumifs
Vlookup
Averageif
Averageifs
Sumproduct

These functions were my bread and butter for spreadsheet design. Excel is a great tool for data input, sorting, computation, and visualization. I would recomend tableau for visualization though.

You dont need macros, vba's or anything else fancy to harness the power of excel. Just get in there and make something.
__________________
The manual may not hold all the answers, but I always check there first.
Reply With Quote