2429 scouting doc 2014
 

Here is my rough draft of our scouting spread sheet for this year. This one is currently set up for IE. Thoughts? If your looking for how I did the math it its at the bottom of the team sheets. Also since we don't have match schedules yet the match sheet isn't done

Re: 2429 scouting doc 2014
 

ill do my best to answer any questions ya'lls might have

Re: 2429 scouting doc 2014
 

updated paper accidentally forgot about the one pointers

also to be able to keep the shooting avg for the one pointer accurate you must input both made shots and missed shots as decimals into the main shooter tab

also id love some feed back on what y'all think and if your team is thinking about using the sheet or a modified version of the sheet

Re: 2429 scouting doc 2014
 

Wow. This is a lot of work. I congratulate you guys. Did you look at using Pivot Tables?

Re: 2429 scouting doc 2014
 

no I haven't looked into the pivot tables, though my team may be able to use them in later years. though my issue with what i've seen of pivot tables wouldn't allow me to do the compiling set up I currently have to only calculate per match entered

Re: 2429 scouting doc 2014
 

had a couple of errors in both Excel and some changes to be made in word so here they