no content
AdBlocker active?
It seems you are using software to block advertisements. You could help us if you could switch it off when visiting redzoneaction.org.
The reason is very simple: Advertisements help us running the site, to offer you the game in a good quality for free. So if you like the game, please support us by purchasing a Supporter Account or disabling the AdBlocker on this site.
Thank you very much!
| Main / Rookie Area / RZA Game Analyser v2 Search Forum | |
| Navigation: |< < 1 2 3 4 6 7 > >| | |
| Poster | Message |
|
Cheesehead
|
posted: 2017-12-18 10:24:15 (ID: 100120837) Report Abuse |
|
Phareux wrote:
I have no idea how that works  Have a look at this example. I also added a QB selection box so you can investigate per team / qb. pivot example sheet I would just google pivot table to get some quick explanation on it, it's looks daunting but is quite easy to use  |
|
| Quote Reply Edit | |
|
Phareux
|
posted: 2017-12-19 14:59:27 (ID: 100120879) Report Abuse |
|
i'll look on youtube and give it a try.
thanks, mike |
|
| Quote Reply Edit | |
|
Phareux
|
posted: 2017-12-19 16:52:06 (ID: 100120885) Report Abuse |
|
THANKS, that was exactly what I was looking for to help with the game analyzer
|
|
| Quote Reply Edit | |
|
marinarul10
|
posted: 2017-12-19 17:19:43 (ID: 100120891) Report Abuse |
|
Awesome job with this Analyser , thanks a lot
 |
|
| Quote Reply Edit | |
|
Phareux
|
posted: 2017-12-21 00:06:55 (ID: 100120938) Report Abuse |
|
Cheesehead wrote:
Phareux wrote:
I have no idea how that works Have a look at this example. I also added a QB selection box so you can investigate per team / qb. pivot example sheet I would just google pivot table to get some quick explanation on it, it's looks daunting but is quite easy to use Ok got it working, but how do set it up to auto refresh the data when I add to it? I tried the refresh buttons under "Analyze" but that doesn't seem to work. mike |
|
| Quote Reply Edit | |
|
Cheesehead
|
posted: 2017-12-21 10:15:37 (ID: 100120951) Report Abuse |
|
Assuming fields remain the same you can right click pivot table and s e l e c t Refresh.
I just make a new pivot table for every analysis. If you click on the table and look at the right hand side of screen you can see fields selected. To start the pivot just open a sheet, click Insert and then Pivot Table and click OK on the pop-up (leaving everything default). |
|
| Quote Reply Edit | |
|
Cheesehead
|
posted: 2018-09-07 07:03:17 (ID: 100132479) Report Abuse |
|
I am starting to think / plan for version 3 of this tool. Does anyone:
1. have any features that are currently missing 2. see plays that are always shown wrong |
|
| Quote Reply Edit | |
| posted: 2018-09-08 11:20:15 (ID: 100132501) Edits found: 1 Report Abuse | |
|
Maybe we could make it easier to add the playbyplay out of RZA into that tool? I was retrying it right now, and not able to complete the job...shame on me: I put the playbyplay in column B...
Last edited on 2018-09-08 11:24:48 by pete |
|
| Quote Reply Edit | |
|
Cheesehead
|
posted: 2018-09-11 10:49:29 (ID: 100132548) Report Abuse |
|
The full play by play should be in the last column (AB) called GameText.
An example using my last game can be found here. Any suggestions once you reviewed that would be greatly appreciated! |
|
| Quote Reply Edit | |
| posted: 2018-09-11 17:39:03 (ID: 100132564) Report Abuse | |
|
I was talking about the upload, where you create a new sheet, enter GAME into A1, and copy the playbyplay into A2...
|
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< < 1 2 3 4 6 7 > >| | |
| Main / Rookie Area / RZA Game Analyser v2 | |
