|
|
Post by tripsclosed on Dec 21, 2021 19:24:06 GMT -6
Besides the standard fare, what are some types of reports/queries you like to run in Excel/Access that you dont see many people mention, are kind of off the beaten path, unique, etc?
|
|
|
|
Post by chi5hi on Dec 21, 2021 21:29:13 GMT -6
Occasionally, (whenever visible on opponent's game film), I will watch the opposition staff reactions to critical plays.
Some coaches are calm, others are quite vehement over a bad play, missed tackle, penalty etc. IDK, might be able to get under their skin...
I tell our videographer to try and get some sideline reactions on film.
|
|
|
|
Post by tripsclosed on Dec 22, 2021 5:24:14 GMT -6
Occasionally, (whenever visible on opponent's game film), I will watch the opposition staff reactions to critical plays. Some coaches are calm, others are quite vehement over a bad play, missed tackle, penalty etc. IDK, might be able to get under their skin... I tell our videographer to try and get some sideline reactions on film. Yup! |
|
|
|
Post by bluboy on Dec 22, 2021 8:00:04 GMT -6
Posted this on General Defense Board:
Recently heard a coach on a podcast discuss how he uses this method to break down an offense.
It focuses on 2nd down based on what occurred on first down (such as 2/10 after 1st down incomplete, 2/L after 1st down run, 2/S after 1st down run, 2/XL after negative play etc.).
Also discusses 1st down of series, 1st down in drive, 1st down after a 3rd-4th down conversion, 1st down after explosive play, and 1st down after turnover.
I use EXCEL for my reports. So if any of you are EXCEL gurus, how do you get EXCEL to show this so that you don't have to "tag" it? I know I could set up columns and tag on HUDL, but I'm looking for a way to enter less and get more (have EXCEL do the heavy lifting). Maybe I'm looking for a unicorn.....
|
|
|
|
Post by tripsclosed on Dec 22, 2021 8:08:53 GMT -6
Posted this on General Defense Board: Recently heard a coach on a podcast discuss how he uses this method to break down an offense. It focuses on 2nd down based on what occurred on first down (such as 2/10 after 1st down incomplete, 2/L after 1st down run, 2/S after 1st down run, 2/XL after negative play etc.). Also discusses 1st down of series, 1st down in drive, 1st down after a 3rd-4th down conversion, 1st down after explosive play, and 1st down after turnover. I use EXCEL for my reports. So if any of you are EXCEL gurus, how do you get EXCEL to show this so that you don't have to "tag" it? I know I could set up columns and tag on HUDL, but I'm looking for a way to enter less and get more (have EXCEL do the heavy lifting). Maybe I'm looking for a unicorn..... Yessir, saw your thread. I was thinking on the same thing last night, i.e. if you can run a report on that without having to tag it. If it cant be done with PivotTable, there's probably a way to do it with macros... |
|
