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-04-13 23:18:13 (ID: 35568) Report Abuse |
|
slider6 wrote:
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? have you downloaded the latest rev of the spreadsheet.. it inocorporates the latest roster allocations.. |
|
| Quote Reply Edit | |
|
slider6
|
posted: 2012-04-13 23:29:21 (ID: 35570) Report Abuse |
|
texat1suf wrote:
slider6 wrote:
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? have you downloaded the latest rev of the spreadsheet.. it inocorporates the latest roster allocations.. I'm pretty sure I have it. When is the last time you released a new revision? |
|
| Quote Reply Edit | |
|
phareux
|
posted: 2012-04-13 23:45:20 (ID: 35573) Report Abuse |
|
where exactly would you change that?
|
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-26 19:08:58 (ID: 37473) Report Abuse |
|
Is there a way to incorporate the skill marks into the page for ground zero core?
|
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-26 19:30:06 (ID: 37474) Report Abuse |
|
Another question as I'm not an excel wizard...
if I want to change what the primary or secondary skills are, is there a faster way than going to each cell and typing in the changes for each player? |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-04-26 22:01:40 (ID: 37513) Report Abuse |
|
sfniner08 wrote:
Is there a way to incorporate the skill marks into the page for ground zero core? Not sure I understand exactly what skill marks you are referring to... |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-04-26 22:04:32 (ID: 37514) Report Abuse |
|
sfniner08 wrote:
Another question as I'm not an excel wizard... if I want to change what the primary or secondary skills are, is there a faster way than going to each cell and typing in the changes for each player? once you have changed the formula for any block, you move to the lower right corner of the block and your cursor will change to a + mark... you may then drag the cursor up or down as necessary to fill all other blocks in that column... This also works left or right to fill in a row... but I'm thinking your just changing a column... |
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-26 22:06:43 (ID: 37515) Report Abuse |
|
texat1suf wrote:
sfniner08 wrote:
Is there a way to incorporate the skill marks into the page for ground zero core? Not sure I understand exactly what skill marks you are referring to... The cap exclamation points. Really what I'm trying to find out, is how can incorporate a way to show if a skill is capped when you look at the ground zero core page. Thanks for the info on the other question! |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-04-26 22:36:29 (ID: 37521) Report Abuse |
|
sfniner08 wrote:
texat1suf wrote:
sfniner08 wrote:
Is there a way to incorporate the skill marks into the page for ground zero core? Not sure I understand exactly what skill marks you are referring to... The cap exclamation points. Really what I'm trying to find out, is how can incorporate a way to show if a skill is capped when you look at the ground zero core page. Thanks for the info on the other question! Yes, most certainly... I'm going to just take speed for example, but this will apply to all skills which have a cap (which I assume means all do at some point)... To generate the column to put the data: Since we want to show the cap on the right side, scroll to the top of the page and click on the letter H... this will highlight the entire H column Right click and s e l e c t insert... this inserts a new column where H once was... To generate the data for these blocks: We'll use the trick you just learned above here... s e l e c t block G4... your QB speed block and move the cursor to the bottom right corner of the block click and drag to H4... Obviously it just copies the exact formula from G4... Now with that block selected (H4), change the 10 on both sides of the formula in that block to 11... Click the check mark or just click on any other block... Now the trick again is s e l e c t the block, move to the bottom right corner and drag that down to fill in for all QB's... Wash and repeat for RB's, FB's, and so on... Remember that you are asking for ground zero core, but this would also work for player table (such that you would be able to see when a player reaches a ca)... Your ground zero core only reflects those that had caps when you signed them... Also remember that you just changed the size of your table, and while excel is smart enough to recognize any changes on that sheet which will not or should not affect any other formulas on the sheet... If another sheet is looking for data from that sheet, it isn't smart enough to make that recognition, so you may have to evaluate any other sheets for impact and change those referenced blocks in their formula... Best wishes and hope it all works well for you... |
|
| Quote Reply Edit | |
|
sfniner08
|
posted: 2012-04-26 23:52:24 (ID: 37533) Report Abuse |
|
Dude, that is awesome! Love it. Thank you very much. When a team gets more advanced there are more caps popping up and this makes it easier to truly evaluate your team.
|
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< < 1 2 3 13 14 15 > >| | |
| Main / The Lounge - Smokers welcome / RZA Player Evaluation Spreadsheet... | |
