16 columns, 54 rows, one page, 63 manual inputs per page, 8 separate data sources, 5 cross-checks back to those sources, 11 additional formulas inside the page that display, another 12 that do not display - SIXTEEN TIMES. A historical accounting and explanation of the future projections encompassing a total of $132M.
Over 1,000 numbers I manually typed, and I erred on 15 total. That's less than 1.5% error. Two transposed numbers and 12 left over from an earlier version with a different methodology.
On all but 3 out of the 16, the calculations are within $1. The outliers have an additional component with a margin of error still at or below 1% ($200 - $15k).
Not too bad for a wordsmith, eh? And yet, to quote, "no one cares. Just fix it and send it, now." In essence, no one cares how much I did RIGHT. It only matters that it's not perfect. In this environment, I am destined to fail.
Kiss my ass. That's <1.5%.
Update: One of the "margins of error" was actually an incorrect calculation. Surprise, surprise. Failing to net out a couple of large amounts throws off part of the calculation. So yeah, still within a margin of error, as long as it's attributed to the right part of the calculation. When it SHOULD say ~9.7% and it actually says ~17%...others can look at it and know it's wrong somewhere. I, on the other hand, was looking at the totals, not the things that auto-calculate. Damnit. I can't win for trying.
No comments:
Post a Comment