Top ADP Players & Top Ranked Players

[quetzal 0]

Mike,

 

Thanks for your work with the compiler. I had a question that hopefully you could answer. One of the changes that was made from last year's compiler to this year was that in the summary tab, there is now only one list for ranking players.

 

Would it be possible for me to modify the summary tab to have the similar setup as last year? My rankings are usually different than the top ADP players. Last year I could keep track of the top ADP players available at the same time as the Top Ranked Players, while i was picking, thereby predicting which player was going next.

 

I tried to copy+paste the cells of W2 - AC17 into W52-AC69 (and changing the formulas to reflect new cells), but it looks like there is something linking to the hidden cells (AK -AM)? So if i were to do that I'd have to also remake that to another area? I basically just want to be able to have another table that is independent of the first.

 

-Quetzal

[Mike MacGregor 20]

Do you have a widescreen? I do, and an extra same size box will fit nicely to the right of the existing Top Ranked Players box. I've been playing around with this. I think you need to duplicate pretty much everything, including the hidden formulas I have in cells AK4 to AM19. Let's try this:

 

1. Highlight everything from cell W2 to AC19. Copy and paste in cell AD2.

 

2. Unhide the columns to the right of the new box.

 

3. Highlight cells AK4 to AM19. Copy and paste in cell AN4.

 

4. HIghlight cells AO4 to AP19 and use Find-Replace. Find: "$AB$2" and Replace: "$AI$2". Replace All.

 

5. HIghlight cells AD4 to AD19 and use Find-Replace. Find: "AS" and Replace: "AO". Replace All.

 

6. HIghlight cells AD4 to AD19 and use Find-Replace. Find: "AT" and Replace: "AP". Replace All.

 

At this point I think I'm getting everything to work except ADP Overall in the new box. No idea why. Try it from there and see if you can see what is going on.

[quetzal 0]

Mike, I tried this already, and also had a problem with ADP Overall. I made my box below starting from W53 as copied the hidden formulas to AK53. I just changed out the cells to your suggestion (I too have wide screen). I think the issue has to do with the named formulas, specifically ADP_Lookup. I think i'll make a new name ADP_Lookup2 and see if that helps. As soon as AB2 changes to "ADP Overall" it over-rides the hidden formulas (so that's why I think I need to add another name formula).

 

-Quetzal

[quetzal 0]

Well that didn't help, and am unsure I can fix. But thanks for the help, it works. Only thing I've done is to switch the two boxes. So now I have ADP overall on the left box, and use Overall on the right box. As long as I don't mix the two up... But to fix the issue it is definitely has to do with a named formula that uses either ADP Overall or Overall.

 

Select Overall on the left box, and none of the ADP_xxx work on the right box, if you select ADP overall on the rihgt box, none of the xxx work on the right box. I'll keep playing with the names to find where they are used and referenced, to see if I can locate, but it works ok, for me. I can work with what I have now.

 

-Quetzal

[Mike MacGregor 20]

I spent a lot of time looking at this and just couldn't figure it out. From what I can see with the formulas, the left box and the right box (and associated formulas) are not connected at all. They should each be able to pull data from the same named range, and in the same way. Ah... I just had an idea. Let me check.

[Mike MacGregor 20]

A-ha! One change required on the ADP tab. Do the same steps I did before, but then add this:

 

7. Go to the ADP tab, and unhide the columns to the right of the table. In cell AB9, change the reference "summary!$AB$2" to "summary!$AI$2". Now the boxes should work (reversed). You'll have your rankings in the left box and ADP in the right box.

[quetzal 0]

Mike, kick ass! Thanks again. Seriously you guys rock with the development of the cheatsheet compiler tool. Yes it looked like the changes were coming from somewhere that the cell was being referenced. Thanks mate. Now time to go win my leagues!!

 

 

 

-Quetzal