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
GI Tools - Template Spreadsheets
 
Fredpy
Posts: 43
Posted on 2015-06-05 22:59:02
Moran20 wrote:

Not bad , coudn't hurt small changes



I'll be glad to hear them
  
campuscodi
Posts: 1513
Joined: 2014-02-01
I.1
Offline
Posted on 2015-08-26 20:46:23
I needed a depth chart in the spreadsheet tools. The default template didn't contain one, so I created it.

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

Feel free to add it to the default template (whoever is managing it).
  
Moran20
Posts: 1268
Posted on 2015-08-26 20:49:13
campuscodi wrote:

I needed a depth chart in the spreadsheet tools. The default template didn't contain one, so I created it.

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

Feel free to add it to the default template (whoever is managing it).




Nice idea.I will used it.Thank you
  
Gatr22GI Supporter
Posts: 14464
Joined: 2009-09-29
I.1
Offline
Posted on 2015-08-26 21:00:21
Captain Jack wrote:

Phiba wrote:

Do you mean how do you download the spreadsheet of player skills from your club's list of players? If so unfortunately you can't.



Thanks, that's exactly what I meant. I've been looking for some way to export as csv or other format but couldnt find one. It's strange that there is no such facility.



There used to be a way to do this with monkey scripts. I used to download it every week. Unfortunately this type of programming is over my head. Perhaps someone here can do something like that for the community
  

Owner of the Orlando Gators FC
Member GIAC
League 383-173 (TD Champs S17,S21,S22)
Regional Cup 223-25 (Cup Champs S14,S15,S17,S19,S20,S21)
AFLC 45-14 (Iron Bowl Champs S18,S22,S23)

It's Great To Be A Florida Gator

campuscodi
Posts: 1513
Joined: 2014-02-01
I.1
Offline
Posted on 2015-12-26 11:13:20
Gatr22 wrote:

Captain Jack wrote:

Phiba wrote:

Do you mean how do you download the spreadsheet of player skills from your club's list of players? If so unfortunately you can't.



Thanks, that's exactly what I meant. I've been looking for some way to export as csv or other format but couldnt find one. It's strange that there is no such facility.



There used to be a way to do this with monkey scripts. I used to download it every week. Unfortunately this type of programming is over my head. Perhaps someone here can do something like that for the community



They're called userscripts and run via the Greasemonkey extension for Firefox, Chrome, Opera, and Vivaldi. They're a pain in the a$$ to code, and extremely hard to implement for the type of coding used on this site.

Something tells me the "revamped" interface which made it harder to use userscripts was done on purpose to kill the first wave of userscripts that worked on the first versions of the site. My employer does the same thing. Every 2-3 months changes the site's layout to prevent scraping and userscripts.
  
Fosterr337
Posts: 0
Posted on 2016-03-23 4:12:39
Will I be able to use these spreadsheets effectively to track my players stats even if I'm not supporter?
  
Phiba
Posts: 4441
Posted on 2016-03-24 17:42:42
Fosterr337 wrote:

Will I be able to use these spreadsheets effectively to track my players stats even if I'm not supporter?



Hi,

Yes you can still use these spreadsheets as a non supporter but you might want to modify the Team Tracker spreadsheet slightly to effectively track your player's speed and strength.

One of the most useful features of a supporter account is that you receive a weekly training report which details which players have increased in which skill. As a non-supporter it's relatively easy (although a bit time consuming) to look at each player's page to see if they have increase in any skill.

However it is a bit more tricky with regard to a player's physicals as speed and strength have hidden caps (maximum value) which are different for every player. The only way you can effectively track whether a player has capped in either speed or strength is by working out how many training points they get each week and monitoring whether their speed/strength increases or not within a given timescale e.g.

It takes 100 training points in a particular skill for a player to increase that skill by 1 point. Players receive between 8-12 training as standard each week (the actual amount each week is random) plus they get their teamwork divided by 2. Players can also get additional training points from coaches and facilities but as you're a new user you shouldn't have any yet so we'll ignore these for the purpose of this example.

Player A has teamwork 20, his speed is 8 and his strength is 10.

In order to track the physicals we have to assume that they start at 8.00 and 10.00 (supporter accounts also show the decimal places of skills).

Player A will gain 18-22 training points per week.

If Player A is trained in fitness/speed (this is known as focused training) then 75% of his training points will go towards speed. This means the minimum amount of training points that go towards speed per week are 13.5(14 if training points are actually rounded up each week). This tells us that it will take a maximum of 8 weeks to increase 1 skill point in speed.

Therefore if after 8 weeks the player's speed has not increased then the assumption would be that he has capped in this skill.

This is why you might want to modify the spreadsheet slightly to enable you to track these weeks.

Long answer but hopefully that helps
  
Jadax
Posts: 17
Posted on 2017-04-04 8:37:39
Thanks to all the creators - this is actually quite helpful for newbies like me.
  
tonimaltrasteGI Supporter
Posts: 4
Joined: 2022-02-14
IV.13
Offline
Posted on 2022-09-23 22:44:08
BrotherWolf wrote:

I started GI just over a month ago and did a spreadsheet to work out the cost and revenue for stadium construction. This spreadsheet is probably of more use to new players as once you get to 13,500 then all you do is add seats and it then becomes a simple progression. It also gives new players an easy look at just how much more money a modest stadium will generate.

I hope this spreadsheet is accurate, any constructive comments are welcome. As I've worked on it it's all obvious to me. Not sure if it is so obvious to someone else.

Stadium Construction
https://docs.google.com/spreadsheets/d/1JNgILwE3E6y19IUVvTq-x03FWzVU13HXqfELvzdSW_M/edit#gid=0



PITY!
deleted file