Operations

Low Tech SharePoint Hack: Project Status Indicator

I'm doing a little hacking in SharePoint that is pulling together a few ideas from the past: Keeping my tech skills sharp Knowing when to search for the answer (vs. stubbornly sticking with DIY) Communicating status tersely but effectively Apparently, I'm also trying to answer a question that is meaningful to many others, as it is used as an example in the Help files for Microsoft's online SharePoint guides, the add-on Web Parts we use here, and many other places.…

Read More ...

Is SharePoint WSS dangerous to SharePoint contractors?

Firing Up Internal Opportunity It was true last year, but even more so now; SharePoint is very important for corporate IT, both strategically (medium- and long-term) and tactically (short-term). Sure, it's a terrific way to iterate on collaboration, internal portals, document management, etc. - "enabling innovation" in every buzzword-compliant sense. But there is solid benefit for even short-sighted, plodding, tactical IT - and it's all about staff retention. SharePoint WSS represents a nice opportunity for folks in IT to get…

Read More ...

Hacking the Google Chart API from Excel

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…

Read More ...

Zodiac of Knowledge Capture

The start of a new year gives me a rare chance to measure my knowledge capture output over time. I maintain electronic journals for the various projects I am driving, business units and functional areas I support, and people I work with. This results in a hundred or so separate MS Word documents, with generally the same format - still, it would be quite tedious to take a word count each week to check my output. However, at the beginning…

Read More ...

Field Notes: Lean Times for IT Services

I know it's lean times in IT, and product / services vendors are all beating the bushes. Some interesting patterns have emerged over the last few months ... My Boss Is In Town: This is far and away the #1 meme / structure of incoming cold calls; I get a (very) brief synopsis of services/value add, the caller and pushes for some face time with "their manager". Did some newsletter or web site suggest this novel approach last summer? I…

Read More ...

I Think I’m Learning SAPanese …

Spent time at an industry conference last week (ain't Boston great!), and heard the term SAPanese - that special language SAP users learn when immersed in worlds of Walldorf and their ubiquitous software. It's not unique to SAP - lots of software companies develop their own vocabulary. Heck, IT "geeks" are famous for it - even the various functional units within the business develop their own shorthand, terms to help speed communication with "those in the know". Here are some…

Read More ...

The Power of Paper in Business Communications

Confucius was wrong - it is good to live in interesting times ... I'm deep-diving into a number of projects at work, while juggling a sudden surge in business travel (the majority of my tweets of late). All of the work involves significant change - different tools & process, or reworking process "traditions" that have ossified over multiple years and a succession of owners. I have developed a stack of notes on a range of topics - excellent blog fodder…

Read More ...

On the Road: Business Travel, Fall 2008

I don't travel a significant amount in my current position, but when I do, it seems to come in chunks. I'm about half way through a round of travel this fall - mostly business, but with some personal travel mixed in. Six cities, three countries in less than four months. Some observations at the halfway point ... @ the Data Center: The Surreal Life I'm finishing this entry around 4am - just off my second night in a row on…

Read More ...

Excel 2007 is a BOB system (Bag’O’Bugs)

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…

Read More ...

Best Practices for Process Documentation: Iterations (2 of 3)

Last time, I wrote about checklists, and showed the example of the B-17 preflight. Simple, fits on a single page, and hits all the critical steps, in just the right amount of detail. Plenty of processes in the IT department are made That Much Better if they are accompanied by detailed, effective Process Documentation. Of course, that's all motherhood and apple pie - everyone agrees that the existing checklists are great. But how do you get started? I mean, assuming…

Read More ...