Updating From A Prior Version: Tip 1

With each new update, the obvious question is, what is the best way to update my old inputs to the new versions of the Compiler and Draft Buddy?

Currently, each update to the Compiler results in a whole new download. This means the custom scoring input in your prior version needs to be input again in this version. However, you can easily copy the scoring from the old version to new in only a couple of steps. Try this:

Open the old Compiler version and click on the scoring tab. Hit CTRL-A to select all, hit CTRL-C to copy. Then switch over to the scoring tab in the new Compiler version, click the cell in the very top left corner and hit CTRL-V (paste).

Do NOT do this for the Compiler inputs or Draft Buddy setup tabs.

However, you can do the copying/pasting for many other sections rather than the whole tab. For example, the box in the Buddy setup tab where you input the team and owner names. Or, the players input in the Buddy keepers tab. Or, the Pick Traded To and Pos/Player columns in Buddy if you added a lot of trades and keepers (by-passing the keepers tab) in your old version.

I can pretty much guarantee I will develop a better solution for this, but it is unlikely to be available this year since we are already into August.

Updating From A Prior Version: Tip 2

One of the best features of the Compiler is the ability to add projections from other websites or magazine, to average them together or just check for comparison to the FF Today projections. For those who went through the task of doing this, as described here:

Q&A: Importing Other Projections

you’re probably wondering the best way to update this info from the old to new version of the Compiler. There are a couple options.

1. You could sort the player lists on the position tabs in each version. Since version 1.0, I don’t think any players were added except RB Tony Hollings (HOU), so they should all match up exactly except for him.

Start by selecting the cell in column A to the left of the first player on the position tab. Hit CTRL-SHIFT-END to highlight the whole area. While holding SHIFT, use the arrow keys to move the highlighted area to the last player line on the tab. Choose Data > Sort and sort by name (column C). Do the same for the other version. Then you can copy the projections you put in the last version, and paste them into the new version. Make sure to check they lineup with the player names properly.

2. You can use some VLOOKUP formulas to quickly reference the player name, and copy them over from one version to the other. This would be the same process as described in the above link, which many of you already have experience with.

Questions?