Formula Change Impacting Batting Average in the Cheatsheet Compiler

While this issue has been gnawing at me for a little while now, it finally became crystal clear over the weekend what exactly was causing it, and how best to fix it. The issue: Batting Average (BA or AVG, as indicated in the Cheatsheet Compiler), is not being calculated properly on the hitters tab in the section “Compiler 2012 Projected Statistics”. Those are the projections, in the light blue section, that drive the cheatsheets.

To say the current formula for AVG is wrong is incorrect. It is dead accurate. What is really going on is Hits may or may not be correct, and if they are incorrect, then your AVG, on-base percentage (OBP), and related ratio projections are off.

In the default Cheatsheet Compiler download, Hits are correct. What happens however, is if and when you decide to import the Zeile Consensus Projections via Projection Pal, for example, then the Hits get wonky. When I originally put in the formula for Hits, I used Hits = Singles + Doubles + Triples + Home Runs. And why not? That is completely accurate, and we had projections or stats for all of those individual stat categories.

Import projections from somewhere else though, including Zeile, and you don’t have projections for Singles, Doubles and Triples. Only total Hits, and Home Runs. That means your Hits are off, in the light blue section (which is key), not the section where you imported the projections. You may not even notice this issue until you get to Draft Buddy and you start adding players and notice your team’s AVG or OBP is ridiculously low.

The issue originates in the Compiler, but since we have a Hits projection, we can fix this pretty easily and get everything back on track. Go to the hitters tab in the Compiler, cell V4. The formula is this:

=W4+X4+Y4+Z4

Change it to this:

=AX4*$AP4+BR4*$AQ4+CK4*$AR4+DD4*$AS4+DW4*$AT4+EO4*$AU4+FG4*$AV4

The easiest way to get this formula is by copying cell W4 (CTRL-C or command-C) and pasting it to V4 (CTRL-V or command-V).

Then copy cell V4 and paste it down for every hitter.

After that is done, hit Compile Cheatsheets again on the setup tab. It should alter your cheatsheets in the Compiler, pushing up players with a good AVG or OBP, and pushing down players with a poor AVG or OBP, assuming your league uses one of those categories in a roto scoring format. Was Mark Reynolds a little too high before? Thanks to CC/DB user jonny_utah who pointed that out, along with fellow user nutigergrad, which helped me realize the circumstances leading to this issue.

If you already have Draft Buddy set up for your league then you will want to hit Setup Draft Buddy again, to pull over the new data. If you’ve already input any picks or keepers in Buddy, uncheck the “Clear Keepers and Draft Picks” option on the setup tab in Buddy before hitting Setup Draft Buddy. Otherwise you will wipe out those picks and keepers.

I uploaded a new copy of the Cheatsheet Compiler this morning with this change.