phreaks

chtrich - If you are still sending out the sheet can you send me a copy also: dhava@rics.bwh.harvard.edu. Thanks

Yahooo!!! Nice work Mike, got the new download and it works like a champ. i guess that i should have started the 1st email that i was on a Mac. I love the update, compiler and buddy. thanks for your help.

Right, but i think the real issue is that the VBD rankings that are on the overall cheatsheet on the cheatsheet page are not base on formulas, they are only manually entered values that will never change by changing the projections/stats. To me this seems that there is little value in entering new data if the rankings won't change subtly. I have played around with the different baselines and can get changes that way, but that still does not change the VBD values in the overall cheatsheet.

Mike, I have played around with things some more to try to figure things out. it seems that if i make a change in the compiler projections and then run the macro to compile the sheets, the changes in the projections i made are reflected in the positional rankings on the cheatsheet page, but not in the overall rankings on the same page. to me it seems that the changes that i make alter the FF points that Excel calculates and thus the change in ranking, but it does not alter the VBD points that are the basis for sorting the overall rankings. When i then go into the Buddy and run that macro, i again see changes in the positional rankings, but not the overall cheatsheet rankings from compiler. One example: If i change R Moss to 1000 yds and 2 TD in the FFtoday projections and go back and run the macro, he drops way down the WR list on the cheatsheet. On the overall cheatsheet based on VBD values, he remains the third overall player. how can this be? The positional sheets are great, but the overall comparison is crucial...

I first entered the league data on the parameters page. then went into the individual rankings pages and made some changes. when i go back and have it compile sheets, i see changes in the positional rankings on the cheatsheet page, but not in the overall rankings on the same page. for instance, if you change moss to 200 yds and 2 td's, he falls way down the wr list, but stays at #3 in the overall list. am i making any sense?

First off, the compiler/draft buddy combo is an unbelievable tool, it brings draft prep to a whole new level. one question about the VBD rankings that the cheatsheet displays in the final rankings. i have gone through and adjusted all of the specs for my league and played with adjusting the projections of different players to see where they fall. when i do this, the player rankings in the cheetsheet by position change, but the overall rankings stay the same. the overall rankings do not appear to draw on information from the rest of the spreadsheet, but rather from manually entered VBD values. is this the case? how then do you get an overall cheatsheet ranking? thanks for any help.