2429 scouting doc 2014

[IVAN]

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

[IVAN]

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

[IVAN]

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

[depth_Finder]

Originally Posted by IVAN

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

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

[IVAN]

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

[IVAN]

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