Aside from dealing with organizations that oftentimes must use Excel as workarounds due to limitations of legacy software systems, I was reminded of the ubiquity of Excel in a recent article by my colleague Dave Gordon at AITS on the use and misuse of RAID (Risk Assumptions, Issues, and Decisions). His overall assessment of the weakness of how RAID can be applied is quite valid. But the literature on risk is quite extensive. The article “Risk Management Is How Adults Manage Projects” at Glen Alleman’s Herding Cats blog is just one quick overview of a very mature process that has a large amount of academic, statistical, mathematical, and methodological grounding.
(more…)Excel
More on Excel…the contributing factor of poor Project Management apps
Some early comments via e-mails on my post on why Excel is not a PM tool raised the issue that I was being way too hard on IT shops and letting application providers off the hook. The asymmetry was certainly not the intention (at least not consciously).
When approaching an organization seeking process and technology improvement, oftentimes the condition of using Excel is what we in the technology/PM industry conveniently call “workarounds.” Ostensibly these workarounds are temporary measures to address a strategic or intrinsic organizational need that will eventually be addressed by a more cohesive software solution. In all too many cases, however, the workaround turns out to be semi-permanent.
A case in point in basic project management concerns Work Authorizations Documents (WADs) and Baseline Change Requests (BCRs).
(more…)Doctor My Eyes — Excel is Not a Project Management Tool (and neither is PowerPoint)
This is not to disparage the utility of a good spreadsheet to take care of those transient requirements to take a bit of data from the reporting systems and to run some custom algorithms or trends to perform what-if or other one-off analysis. Probably most of us do this occasionally.
What I am referring to is the condition in many organizations in which data that consists of information essential to business operations is kept and analyzed using spreadsheets or other flat delimited storage or text methods. The issue here is the optimum use of information, which the use of Excel and PowerPoint does not achieve. Before anyone thinks that this is a contrarian’s post that is critical of Microsoft products, one need only read the technical advantages of true relational database management systems that are managed by specialized language like MS SQL. Each of these applications and products has their proper place.
(more…)
Life, Project Management, and Everything 