dwagner13

Has Compiler been tested with Excel 2007 now that it has been released?

I did that to make it work. I just wasn't sure if there was an easy way to extend the WR_2_detail column easily. This also affects the "Who Won" tab that I created (following a previous poster) =IF(V45="","",VLOOKUP(V45,INDIRECT(CONCATENATE($B45,"_Detail")),4,0)) returns #N/A. If I change it to =IF(V45="","",VLOOKUP(V45,INDIRECT(CONCATENATE($B44,"_Detail")),4,0)) it calculates the correct projected points. Just thought you might want to know that as well. Doug

My league combines WR and TE. In doing so, when I used DB and selected TE for position for Tony Gonzalez, there were no player names listed, no big deal, I just changed the position to WR and there they were. The problem is that when Gonzalez is selected, his team and bye columns show #N/A. The formula is looking for him in the WR_2_detail column, but he is not there due to the fact that he is in the TE_2_detail column. If we set it up to combine WR/TE shouldn't he be imported to the WR column and not the TE column? Any easy way to fix this? Thanks, Doug

Thanks, Ryan. This helped with my multiple leagues

Not sure if this is already in the projections, but how about the idea of factoring in a players' "Strength of Schedule" when ranking them?

Thanks, Mike!

Could you possibly change it back to the correct spelling so that when we update projections, our Site B and/or C does not return #N/A due to the misspelling?

Mike, I know why it didn't work. I had protected the worksheet and when I ran the macro it just copied the value from the first cell to the rest. When I unprotected the worksheet and ran the macro, it worked just fine. Thanks for your help. Doug

Excel 2003. It puts the formula in the first cell and then must be copying the value to the rest of the cells.

I just checked and it is a problem with the Macro to Compile Cheatsheets. There is only a formula in "Cheatsheets" tab cell G8 =IF(ISNA(VLOOKUP(C8,ADP_10team_lookup,3,0))=TRUE,"",VLOOKUP(C8,ADP_10team_lookup,3,0)) This formula is not located in the rest of the cells, only the value of cell G8. I copied the formula to the other cells and it generated the correct values; however, when I compiled the cheatsheets again with the macro, the ADP reverted to the formula in G8 and the value of G8 in the other cells. Hope that helps you Mike.

Just thought you might want to know that Patten is listed as PatteRn in the 8/19 update.

It is in both the Compiler and DB. In Compiler, it is the Cheatsheet Tab and in DB it is the Offense tab.

My understanding is that it is an easy way to change the rankings to your liking without having to change the projections. For example, if Moss is listed as #1 and Holt is #2 and you think that Holt will perform better than Moss, you change the yellow box beside Moss to 2 and Holt to 1 then click re-sort and "voila" the ranking has changed right before your eyes Mike, correct me if I'm wrong.

Is there a reason why the ADP for everyone (and I mean EVERYONE) is appearing as 2.05?

Does anyone know of a way to copy the information from Site B & C in Compiler 1.0 to Compiler 2.0 without having to enter the formulas again and without having the link to Compiler 1.0?