Tag: fiscal

Schrödinger’s Excel

Or, how to be deadly and awesome at the same time Is Excel good or bad?  It is both.  Are you good at Excel or bad at it?  Probably both. Excel is extraordinary.  In the wrong hands it also can be a disaster,  Excel is just a tool, like a chisel.  It is inspiring in the hands of a skilled carpenter and murderous in

Read More

We Don’t Need No %@# Standards?*

Imagine comparing two school districts’ test scores, where each district uses different tests.  That would be meaningless, right? Yet, this situation exists on the business side of things. Legislation will require a calculation, but the implementation is unclear.  Subsequent guidelines and regulations (if any) sometimes just cite the statute verbatim. For example, prior to the new funding formula, conversion

Read More

Workarounds

Not too long ago I put this one word sign on my desk:  Workaround? The meaning being that I should constantly ask myself “Is this a workaround?”  If yes, fix the root cause.  Perhaps I am working around a person I don’t trust?  That has to be addressed too. Workarounds arise when you have to

Read More

Spreadsheet Best Practices

Many of us have worked with Excel spreadsheets for years and consider ourselves to be pretty good at them.  Then I ran across the website Best Practices Modeling website.  I learned a lot and I’ve been converting some of my more complicated models into the Best Practices system. My main takeaways are: Use separate, differently

Read More