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 13 14 15 > >| | |
| Poster | Message |
|
texat1suf
|
posted: 2012-01-03 01:33:38 (ID: 21882) Report Abuse |
|
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... |
|
| Quote Reply Edit | |
|
panoramix
|
posted: 2012-01-03 02:28:19 (ID: 21896) Report Abuse |
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-01-03 02:50:42 (ID: 21897) Report Abuse |
|
panoramix wrote:
Thank you, now it works better. I have some players missing on the deep chart and some ### on the ST AVG.  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... |
|
| Quote Reply Edit | |
|
panoramix
|
posted: 2012-01-03 13:45:25 (ID: 21985) Report Abuse |
|
Sorry, but I can not understand (formulas tab for which cell?).
If you pm me your mail address, I will send you the file. Thanks in advance, Luigi |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-01-03 14:00:03 (ID: 21990) Report Abuse |
|
panoramix wrote:
Sorry, but I can not understand (formulas tab for which cell?). If you pm me your mail address, I will send you the file. Thanks in advance, Luigi this is not for a cell but for the whole workbook at the very top of the sheet... |
|
| Quote Reply Edit | |
|
panoramix
|
posted: 2012-01-03 14:06:13 (ID: 21992) Report Abuse |
 |
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-01-03 14:21:44 (ID: 21995) Report Abuse |
|
panoramix wrote:
at the very top of the sheet, you should see your HOME tab, and INSERT tab, Page Layout tab, and voila FORMULAS this is the tab you need to click... If we still aren't together on this when I get home, maybe I post the pics on the google docs... Maybe... |
|
| Quote Reply Edit | |
|
panoramix
|
posted: 2012-01-03 14:38:23 (ID: 21997) Report Abuse |
 Source: http://img815.imageshack.us/img815/3974/schermatapw.png
|
|
| Quote Reply Edit | |
|
texat1suf
|
posted: 2012-01-03 16:15:33 (ID: 22007) Report Abuse |
|
Hahahahhah...
Knew there was some kind of disconnect... I'll shoot you a message later when I get home... |
|
| Quote Reply Edit | |
|
panoramix
|
posted: 2012-01-06 01:41:29 (ID: 22449) Report Abuse |
|
texat1suf wrote:
Hahahahhah... Knew there was some kind of disconnect... I'll shoot you a message later when I get home... Solved, Steve is a wizard! |
|
| Quote Reply Edit | |
| reply Mark this thread unread | |
| Navigation: |< < 1 2 13 14 15 > >| | |
| Main / The Lounge - Smokers welcome / RZA Player Evaluation Spreadsheet... | |
