Community - American Football Management Simulator
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 / The Lounge - Smokers welcome / RZA Player Evaluation Spreadsheet... Search Forum
Navigation: |<   <   1  2  3  13  14  15  >   >|  
Poster Message
sh8888
posted: 2012-02-05 15:17:53 (ID: 27125) Report Abuse
texat1suf wrote:
And in case I forget, that monitor is also (hopefully) there to monitor when a player begins to decline... I just haven't witnessed this with an aging player yet, and you may be the first to do so... So if you did not change any attributes, it is possible you are confirming that this monitor is working...


I asked the question in the rookie forum (see link below) re a player declining with age, it appears that this doesn't happen .... yet

http://redzoneaction.org/football/index.php?page=community&subpage=thread&thread_id=1950

Forum Thread

btw, not meaning to disrespect your spreadsheet in any way, as I believe this spreadsheet is incredibly useful and informative in many ways, you've done a first-class job creating this.


Admin was here, made the link more nice

Last edited on 2012-02-05 15:37:16 by Admin

Quote   Reply   Edit  
texat1suf
posted: 2012-02-05 16:27:31 (ID: 27128) Report Abuse
thanks and yeah, I haven't seen it yet either , was just hoping for a new revelation... not quite yet..
Quote   Reply   Edit  
preachie
posted: 2012-02-05 19:49:19 (ID: 27157) Report Abuse
It looks like I'm too incompetent to get the sheet working properly in LibreOffice 3.3

After adding the player data to the GroundZero and Roster sheet I can see that the PlayerTable is populated. However most of the formulas are not working and showing either #DIV/0! or #VALUE! issues.

First I thought this is related to regional settings, but I changed the LibreOffice seetings to English(USA) already and still see the issue.

Does anybody of you have an idea what I'm doing wrong?
Any help is much appreciated - Thanks!
Quote   Reply   Edit  
phareux
posted: 2012-02-05 20:04:48 (ID: 27158) Report Abuse
ON mine i get that if i dont have at least one player in each catagory, but that is just in team averages.
Quote   Reply   Edit  
texat1suf
posted: 2012-02-05 20:27:19 (ID: 27159) Report Abuse
preachie wrote:
It looks like I'm too incompetent to get the sheet working properly in LibreOffice 3.3

After adding the player data to the GroundZero and Roster sheet I can see that the PlayerTable is populated. However most of the formulas are not working and showing either #DIV/0! or #VALUE! issues.

First I thought this is related to regional settings, but I changed the LibreOffice seetings to English(USA) already and still see the issue.

Does anybody of you have an idea what I'm doing wrong?
Any help is much appreciated - Thanks!


pm me with your issues, and we'll take a look..!!!
Quote   Reply   Edit  
sh8888
posted: 2012-02-06 13:31:54 (ID: 27223) Report Abuse
just one small issue, in the Depth Chart worksheet it lists all positions except kicker and punter. Would it be possible to include kickers and punters in the depth chart ?
I tried doing it myself on a copy but I can't get it to work as there seems to be no formula group (not sure what the correct name is) for kickers/punters similar to the "OLS" "RBS" etc.
Sorry, but I'm not too good at this spreadsheet thing
btw, I'm using OpenOffice , not sure if that will actually make a difference ......
Thanks.
Quote   Reply   Edit  
sh8888
posted: 2012-02-06 18:58:41 (ID: 27253) Report Abuse
sh8888 wrote:
just one small issue, in the Depth Chart worksheet it lists all positions except kicker and punter. Would it be possible to include kickers and punters in the depth chart ?
I tried doing it myself on a copy but I can't get it to work as there seems to be no formula group (not sure what the correct name is) for kickers/punters similar to the "OLS" "RBS" etc.
Sorry, but I'm not too good at this spreadsheet thing
btw, I'm using OpenOffice , not sure if that will actually make a difference ......
Thanks.


It's OK ...... I think that by accident/pure luck, I've managed to create 2 formula groups for punters and kickers, copy/amend the formulas from the other cells and it seems to work. I'll go away and test it a bit more just to be sure ........
Quote   Reply   Edit  
phareux
posted: 2012-02-06 21:24:29 (ID: 27267) Report Abuse
phareux wrote:
is there anyway to have a player on multiple positions?
i dont have anyone set as a gunner but it wont give me a team stat reading unless all positions are filled


I think this question got lost in the shuffle, but i was wondering about it still.
Quote   Reply   Edit  
phareux
posted: 2012-02-06 21:44:56 (ID: 27268) Report Abuse
What abbreviation do you use for the kickers and punters in that formula?
I copied the formulas but but i need KKS or whatever to make it

Last edited on 2012-02-06 21:51:38 by phareux

Quote   Reply   Edit  
texat1suf
posted: 2012-02-06 22:19:29 (ID: 27273) Report Abuse
I guess I was kind of selfish in regards to punters and kickers...

They are Punters and Kickers after all...

It was not even a thought that someone would actually carry more than one on a roster... Just my opinion that it would be a waste of a roster spot...

Since it appears several of you are interested in doing so, I will u p d a t e the spreadsheet to reflect up to 5 each and post here when the updated version is available...

Sorry for being so selfish fellas... I'll have it fixed tonight...
Quote   Reply   Edit  
reply   Mark this thread unread
Navigation: |<   <   1  2  3  13  14  15  >   >|  
Main / The Lounge - Smokers welcome / RZA Player Evaluation Spreadsheet...