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 |
|
phareux
|
posted: 2012-03-25 13:10:25 (ID: 33663) Report Abuse |
|
Ok, I just downloaded the latest player file for this training period and EVERY one of my players went negative atttribute improvement. And i did not change anything.
correction i changed the name on file and then i had "enable edit" Last edited on 2012-03-25 13:20:03 by phareux |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-03-25 16:57:57 (ID: 33676) Report Abuse |
|
phareux wrote:
Ok, I just downloaded the latest player file for this training period and EVERY one of my players went negative atttribute improvement. And i did not change anything.
correction i changed the name on file and then i had "enable edit" Very simply put, you have copied your new roster into the ground zero page vs the roster page... it is the only possible explanation, as att imprv is the difference between roster and ground zero... placing the new roster on the ground zero page is the only way to make these attributes greater than the roster, and provide a negative number... If this is not the case, please PM with your details... |
|
| Quote Reply Edit | |
|
phareux
|
posted: 2012-03-25 17:05:04 (ID: 33677) Report Abuse |
|
Oh, well i will see what happens next download and see what happens
ok i downloaded an old player download, then used the latest player download after this download and everything is cool. thanks for the quick reply  Last edited on 2012-03-25 17:11:18 by phareux |
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-13 18:22:15 (ID: 35527) Report Abuse |
|
Dude, do you realize how useful this tool is for organizing the draft board?
|
|
| Quote Reply Edit | |
|
slider6
|
posted: 2012-04-13 18:55:45 (ID: 35535) Report Abuse |
|
sfniner08 wrote:
Dude, do you realize how useful this tool is for organizing the draft board? That's a good idea. It will be interesting to see how close my ordering was to what this spreadsheet thinks it should be. |
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-13 18:59:10 (ID: 35536) Report Abuse |
|
Not just that, but remember you can change what the skill weights are and what is included in the primary and secondary skills. I found I changed a lot as positioning wasn't in many of the positions on the spreadsheet. If what you value is there then inputing the draftees will allow you to order them. In addition, like you said, it will be interesting to see what the draftees skills are in the areas you think are important and not important. It will take some time transferring the data to a spreadsheet, a drawback.
|
|
| Quote Reply Edit | |
|
slider6
|
posted: 2012-04-13 19:44:05 (ID: 35544) Report Abuse |
|
Yeah, I just went through and edited all the of skill weights and primary/secondary totals. Looking at the draftees, I was surprised at some of the weights I came up with as compared to how I had thought of them. I'm sure this editing will continue next season when I look at the draftees again.
Now my problem is going to be expanding the Player Table to accommodate the 96 man "roster" as well as the extra players in each position. Does anyone have a tip on doing that quickly and easily? |
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-13 19:47:09 (ID: 35545) Report Abuse |
|
Tex posted on this thread somewhere how to do that.
|
|
| Quote Reply Edit | |
|
slider6
|
posted: 2012-04-13 19:50:40 (ID: 35547) Report Abuse |
|
texat1suf wrote:
panoramix wrote:
texat1suf wrote:Simple...
Click on the number 71 (this highlights the entire row) right click and s e l e c t insert (this adds a row above the highlighted row, and again for as many rows as you need) now on the first row above the added rows, click on column a and drag mouse to far right block of the row... when all rows are selected at bottom right corner of last block your cursor should change to a + sign, when that happens, click and drag down for the amount of blocks added (this drags down the formulas to the added blocks)... At this point go back to column B and change OL10 to OL11 in the formula bar, and do this for all rows added Hope that is simple enough... Also this will apply to Depth Chart, CarreerRating, Att Impr sheets, as well as your groundzero sheet... Don't work... 
I've expanded the sections: on my "player table" I see all the players, but the players 11-16 don't have a rank (only a ###)... Check column Y and make sure your formula looks similar to this... =IF($B61="","",RANK($U61,$U$61:$U$70)) What you will be making sure is that the last value $U$70 actually incorporates you total lines... Maybe it should be U74 or 75 or 76 in your case... The dollar sign keeps the value from changing, and you may have to manually change this in your ranking column... Hit me with an private mail if this doesn't fix it... texat1suf wrote:
Ah yes... You've changed the # of OL and this applies to any other position... Now we have to change the Name OLS so depth chart recognizes all of the new guys... Click on Formulas tab at top... Now click on Name Manager... Click on OLS At the bottom of block there is a line that says where the name "REFERS TO" with a data line... Simply change that line also from AA70 to AA76 or wherever your new last OL entry is and click the check mark to accept... Please mail me with the particulars for your ### entries... I suspect you're talking about the team averages blocks but not exactly sure... texat1suf wrote:
phareux wrote:
Interesting, some of my players had a negative one the core value monitor. it is typical if you changed any of your "attribute emphasis" on your player page as this will impact core values, but did not do it on the ground zero core page... Also occurs when Pete makes an in game adjustment which has happened in the past, but was announced... texat1suf wrote:
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... Just putting it here so people don't have to go digging for it if they want it. Last edited on 2012-04-13 19:56:46 by slider6 |
|
| Quote Reply Edit | |
|
slider6
|
posted: 2012-04-13 21:38:37 (ID: 35554) Report Abuse |
|
texat1suf wrote:
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... OK, I've expanded all of the positions in the PlayerTable and GroundZero Core to 10-20 depending on the position. My problem is that only the players through row 78 in the Roster are showing in the PlayerTable. I've followed the instructions above and changed the formula to 98 rows, but it didn't seem to help. My team spreadsheet only has to row 71, so I don't know if its happening there as well or not. Any ideas? |
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< < 1 2 3 13 14 15 > >| | |
| Main / The Lounge - Smokers welcome / RZA Player Evaluation Spreadsheet... | |
