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
 
ShanksterGI Supporter
Posts: 626
Joined: 2013-12-16
I.1
Offline
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: 4092
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

“Bing bing, bong bong, bing bing bing” - Donald Trump @ “Lincoln Day” speech on political lobbying, 2015

linkleo911GI Supporter
Posts: 1553
Joined: 2014-10-28
I.1
Offline
Posted on 2019-05-13 13:37:07


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

  

Central & South America Top Division Champion - Season 26
Brazil NT Coach - WC XX / XXI / XXII / XXIV

 
Last posts
2019-05-22 11:44
NFL Fantasy
Author:Jean Vignoble
2019-05-22 11:43
Pokalthread
Author:Jean Vignoble
2019-05-22 10:50
Polish Cup XI
Author:ManowarPL
2019-05-22 10:46
Pokalthread
Author:Baphomet