Day 2 of making screencast videos to show how to use the Cheatsheet Compiler & Draft Buddy, and I’ve already learned or improved a couple of things from the getting started video posted yesterday. First, I found some shorter topics, which I think is more engaging than watching a screen and listening to me for over 10 minutes. Second, I learned how to remove the “umm’s” and “aww’s” from the audio.

On the downside, I couldn’t figure out what the loud clacking sound is that occurs in the background on occasion, until I finally realized it was when I was hitting the keyboard. I’m not sure why that is so loud, but I’ll see what I can do to prevent it going forward.

As for the video production, I have two new ones today. One is on re-ranking players in Draft Buddy. This can be useful if you’ve already got your cheatsheets from the Compiler, into Buddy after running the Draft Buddy Setup, and you want to move a handful of players up or down your cheatsheets.

You can move players by editing their projections in the Compiler (yellow section on the hitters or pitchers tab), but if you are at a stage you don’t want to get into the detail of projections, try a simple re-rank in Buddy. If news breaks that a player will miss some time with injury, maybe he is the only guy worthy of a change, knocking him down a few spots. This video is ideal for that.

The second video is more of an Excel tutorial than specific to the CC/DB. Have you noticed those annoying green triangles in your copy of the Compiler, or Draft Buddy? Those are a Microsoft Excel feature called error checking. Excel is referencing various error checking rules to identify formulas which potentially have an error. Not that they have an error, just that Excel is telling the user it thinks the formula might have an error.

All in all, the error checking rules are too strict by default and finding all kinds of potential errors, creating lots of green triangles messing up the look of the Compiler and Draft Buddy. What we want to do is turn off a bunch of these error checking rules, to get rid of the triangles. The next video shows how to do that in older versions of Excel, and newer versions since Excel 2007.