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: 658
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: 4111
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: 1604
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 / XXV

Hard-core fan (ultimate supporter owner)AsgardGI Supporter
Posts: 1352
Joined: 2008-12-05
I.1
Offline
Hard-core fan (ultimate supporter owner)
Posted on 2019-05-23 1:01:03
Just finding this! Totally awesome!
  

Owner of the Valhalla Vikings.

 
Last posts
2019-08-22 23:35
Championnat saison 7
Author:zone rouge
2019-08-22 23:04
Typer Liga U-21 VI
Author:Jondrus
2019-08-22 22:32
Typer Liga U-21 VI
Author:Jondrus
2019-08-22 21:17
Maverick's CUP 5
Author:dggh12
2019-08-22 20:42
Grid-Iron League Records
Author:linkleo911
2019-08-22 17:19
Championnat saison 7
Author:Le_Dabe
2019-08-22 15:25
Championnat saison 7
Author:K3nShir0