no content
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 |
|
texat1suf
|
posted: 2012-02-06 22:46:44 (ID: 27275) Report Abuse |
|
It is now up to date guys and you can get it right here...!!!
RZA Player Evaluation Spreadsheet - Latest Version Let me know if it suits your needs... Thanks and best of luck... Last edited on 2012-02-10 15:24:43 by texat1suf |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-02-06 22:54:46 (ID: 27277) Report Abuse |
|
phareux wrote:
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. The answer is yes, but you will have to copy the player and list him twice on your roster sheet, and simply change the pasted one's position block to gunner (in this particular case)... Problem is, you will have to do this with every download, as your team will only list him once in his assigned position... This could be accomplished using a macro I'm sure, but since I'm not even close to smart enough to know how to write it, and it makes no sense to me that you wouldn't have a gunner on your team, it will be up to you guys trying to outwit the system to figure this one out... |
|
| Quote Reply Edit | |
|
phareux
|
posted: 2012-02-06 23:27:58 (ID: 27278) Report Abuse |
|
OK thanks,
mike |
|
| Quote Reply Edit | |
|
sh8888
|
posted: 2012-02-07 11:49:57 (ID: 27301) Report Abuse |
|
texat1suf wrote:
It is now up to date guys and you can get it right here...!!! Let me know if it suits your needs... Yeah, just downloaded it and used it, seems great to me. Thanks for your efforts  |
|
| Quote Reply Edit | |
|
looser
|
posted: 2012-02-08 22:19:57 (ID: 27574) Report Abuse |
|
what are my doing wrong i got my YP and when i load my CSV file i copy line 73 (where he is) and paste it in the bottom line in ground Zero (line 80) then i copy all the CSV file and paste the file in roster then i get error in Career Ratings Progress (only for him) age #N/A INITIAL empty NOW looks okey INCR empty INITIAL 0,00 NOW 13,82 INCR 13,82 and in AttImprv his position age and talent look okey all other have this #VALUE! and ground Zero Core pos, age, talent looks okay other are empty except core 0.00 pri ##### sri ##### comp ##### rank 8?
|
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-02-09 01:00:41 (ID: 27594) Report Abuse |
|
looser wrote:
what are my doing wrong i got my YP and when i load my CSV file i copy line 73 (where he is) and paste it in the bottom line in ground Zero (line 80) then i copy all the CSV file and paste the file in roster then i get error in Career Ratings Progress (only for him) age #N/A INITIAL empty NOW looks okey INCR empty INITIAL 0,00 NOW 13,82 INCR 13,82 and in AttImprv his position age and talent look okey all other have this #VALUE! and ground Zero Core pos, age, talent looks okay other are empty except core 0.00 pri ##### sri ##### comp ##### rank 8? simple enough I hope.... I set the tables up knowing that the maximum allowable roster was 70 players... I gave the proverbial 10% overage in setting up the name files... In other words, the tables only recognize data through 78 lines... So really you should have 2 guys that don't work... And the fix is this... open formulas tab click name manager scroll down to locate "table 2" and click it... you should see this - =GroundZero!$B$1:$BA$78 you simply change the 78 to 90 if you like to allow for other growth... or you can begin to delete some guys you've sold or fired... once changed, you click the check mark to accept... If this isn't your issue, you are welcome to PM me and we'll get you fixed up... |
|
| Quote Reply Edit | |
|
looser
|
posted: 2012-02-09 18:16:00 (ID: 27659) Report Abuse |
|
texat1suf wrote:
looser wrote:
what are my doing wrong i got my YP and when i load my CSV file i copy line 73 (where he is) and paste it in the bottom line in ground Zero (line 80) then i copy all the CSV file and paste the file in roster then i get error in Career Ratings Progress (only for him) age #N/A INITIAL empty NOW looks okey INCR empty INITIAL 0,00 NOW 13,82 INCR 13,82 and in AttImprv his position age and talent look okey all other have this #VALUE! and ground Zero Core pos, age, talent looks okay other are empty except core 0.00 pri ##### sri ##### comp ##### rank 8? simple enough I hope.... I set the tables up knowing that the maximum allowable roster was 70 players... I gave the proverbial 10% overage in setting up the name files... In other words, the tables only recognize data through 78 lines... So really you should have 2 guys that don't work... And the fix is this... open formulas tab click name manager scroll down to locate "table 2" and click it... you should see this - =GroundZero!$B$1:$BA$78 you simply change the 78 to 90 if you like to allow for other growth... or you can begin to delete some guys you've sold or fired... once changed, you click the check mark to accept... If this isn't your issue, you are welcome to PM me and we'll get you fixed up... i have 61 player in my roster and 18 YP thats make 79 player that´s maybe the reason only one player are fu** up!!! |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-02-10 15:32:02 (ID: 27713) Report Abuse |
|
looser wrote:
i have 61 player in my roster and 18 YP thats make 79 player that´s maybe the reason only one player are fu** up!!! Not sure if you got yourself fixed, but I have again updated the spreadsheet at the top of page 7 to accomodate up to and including all possible YA players, since I wasn't smart enough to account for them in the first place... Good catch... |
|
| Quote Reply Edit | |
|
phareux
|
posted: 2012-02-10 23:08:41 (ID: 27728) Report Abuse |
|
can you save the atty improvement from the current version to the new version?
|
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-02-11 01:07:47 (ID: 27735) Report Abuse |
|
phareux wrote:
can you save the atty improvement from the current version to the new version? there is no magic involved... everything on your current spreadsheet will be there just as you see it on your new spreadsheet... you simply copy your old ground zero and you current roster, and it will register your att improvement just as it is now... remember it is simply a comparison from your original roster stats to your new roster stats... |
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< < 1 2 3 13 14 15 > >| | |
| Main / The Lounge - Smokers welcome / RZA Player Evaluation Spreadsheet... | |
