a bit of code on a Saturday night ... I've written before about a simple way to measure and report IT value to the business - quantifying alignment with strategic initiatives project spend in context. It all culminated with a single, simple slide - numbers, with some Tufte-esque Sparklines thrown in. Well, technologies come and go, and without going into the boring details, I've had to come up with a new way to generate the mini-bar charts along the left…
I am getting seriously aggravated with the flighty behavior of Excel 2007. Yes, I acknowledge that the spreadsheets in question is quite complicated ... shared VBA modules in an XLA file database read/write using ADO array-manipulation for ranges of cells (see this post) lots of macro (VBA) logic to control look/feel of the tabs code to automatically insert formulae into cells ... and so on. However, some of the observed flightiness is specific to the UberSheet, while other weirdness happens…
I sat in on the report-out session from a kaizen event this week, and something occurred to me as I reviewed a ton of interesting findings in a very short time ... Best Practice Self-contained deliverables are the most powerful tools for knowledge knowledge transfer you can have in your organization. I'm talking about a document that stands on its own, and effectively communicates an idea without needing the author nearby to explain anything. The topic doesn't matter - conceptual…
For a simple, easily understood indication of project or task status, nothing beats the Traffic Light metaphor (Red / Yellow / Green). My IT organization is putting together standards for Project Status indicators in our PMO application; an interesting series of discussions and emails around the assignment of those Green / Yellow / Red (GYR) status lights ... Words: What do we display on the screen? Green / Yellow / Red means ... Good / Fair / Poor? Hmm, nobody…
In any organization - if you've been there for a while or are brand new - there aren't many ways you can get away with introducing some change, shaking things up a little, and get away with it. Here are some stealthy, subtle ways to bring in a little healthy anarchy (they get progressively riskier) ... For recurring meetings, make a point of sitting in a different chair every time. People like to maintain the status quo, which often manifests…