Grid-Iron american football game language selector
Language
ČeštinaDanskDeutsch
EnglishEspañolEspañol (Latinoamérica)
FrançaisItalianoMagyar
NederlandsPolskiPortuguês (Brasil)
RomânăSlovenčinaSlovenščina
SrpskiSuomiБългарски
РусскийУкраїнська 
Register
Login
NA TD Stats - Seasons 20-29
 
Shankster
Posts: 665
Posted on 2019-05-13 5:12:18
Here is the URL to the Google sheet where I have a rather large number of stats from seasons 20-29 in North America Top Division.

https://docs.google.com/spreadsheets/d/1DLRS5SLEBB646qvTGQ00_q-TwB08lwOhGK1XGJ3c41I/edit?usp=sharing

I wanted to do a typical report, but I feel too many players would have been left out and allowing access for others to filter through the data is a better option.

The sheets have been protected except for the top row on most to allow filtering for now. Though I'm unsure if using the filter is considered altering the rows below by the filter user, and thus the action will be denied, if it does so let me know.

GWRS - Stands for Game With Recorded Stats. If a player played a match but had no tackles, passes, etc. or anything that has a stat line in the game, their involvement is not counted (Just how the program works). Due to this, some stat lines like sacks/game are not calculated, as they could be highly inaccurate.

For each of the seasons tab, I had tried creating legends on the simple graphs but it was not intuitive to me so I left them be. Simply put Blue is for Home games, Red is for Away.

I know providing editing access to all has risks, so for now I have a copy of this if anyone tries to mess with the sheet, and shall see how it fairs.
  
SrednaDGI Supporter
Posts: 4558
Joined: 2010-11-02
I.1
Offline
Posted on 2019-05-13 8:40:47
Shankster wrote:

Here is the URL to the Google sheet where I have a rather large number of stats from seasons 20-29 in North America Top Division.

https://docs.google.com/spreadsheets/d/1DLRS5SLEBB646qvTGQ00_q-TwB08lwOhGK1XGJ3c41I/edit?usp=sharing

I wanted to do a typical report, but I feel too many players would have been left out and allowing access for others to filter through the data is a better option.

The sheets have been protected except for the top row on most to allow filtering for now. Though I'm unsure if using the filter is considered altering the rows below by the filter user, and thus the action will be denied, if it does so let me know.

GWRS - Stands for Game With Recorded Stats. If a player played a match but had no tackles, passes, etc. or anything that has a stat line in the game, their involvement is not counted (Just how the program works). Due to this, some stat lines like sacks/game are not calculated, as they could be highly inaccurate.

For each of the seasons tab, I had tried creating legends on the simple graphs but it was not intuitive to me so I left them be. Simply put Blue is for Home games, Red is for Away.

I know providing editing access to all has risks, so for now I have a copy of this if anyone tries to mess with the sheet, and shall see how it fairs.



Awesome work!!!
  

"Quarterbacks should wear a dress." - Jack Lambert

If you are ever feeling down, just know that neither of Dorfenschmirtz's parents showed up to his birth.

linkleo911
Posts: 1831
Posted on 2019-05-13 13:37:07


I like stats a lot! But that is a hardcore stats fan work!

  
Asgard
Posts: 1352
Posted on 2019-05-23 1:01:03
Just finding this! Totally awesome!