Alex Carrick’s Blog

I have a story from my workplace I think encapsulates an awful lot of what is so crazy about the modern business world.

It involves computers and automatic updating processes and the vast potential that exists for things to go sadly and sometimes hilariously wrong, despite our best intentions.

We are all so dependent on computers and our faith in their reliability and accuracy can sometimes be sorely tested. A prime example concerns the opening salutation in a standard business letter that reads “To Whom It May Concern.”

Keep this phrase in mind as you read what follows.  

The company I work for, Reed Construction Data-CanaData, calculates a construction cost index (CCI) each month. The CCI is similar to the Consumer Price Index (CPI), except it only applies for construction.

CanaData’s CCI is a means to monitor the percentage change in construction costs over time. One main use is in escalation contracts.

An escalation clause is an agreement between the two primary players in a construction project, the owner and the contractor, to adjust the price for work done based on an independent yardstick (e.g., the percentage change in the CCI) if there are extenuating circumstances, such as the work taking longer than expected.

The mathematical calculation is similar to COLA or cost of living adjustments in wage agreements.

Please bear with me here, there’s only a minor amount of technical detail.

The CCI is a composite index made up of labour and materials.

CanaData follows wage rate changes (both union and non-union) in major construction trades and surveys manufacturers about the prices they are charging for building materials.

This story concerns the materials side.

To obtain materials pricing, we send out a standard reporting form to respondents each month. This asks for the latest price for brick, lumber, steel, cement and concrete, according to certain dimensions.

In February, we are looking for January prices; in March, for February prices; and so on, rolling forward each month. There is a certain section of the survey letter that needs filling out and the whole process of updating the form is automatic.

The nature of computer systems is to simplify tedious and/or repetitive steps. For example, the word-processing program – often Microsoft’s “Word” – included with most operating systems has a search and replace function.

Therefore, in March, it is a simple matter of running “edit”, “find what” and “replace with” to change the response request  from January to February in the letter that goes out to respondents.

This works perfectly for every month of the year except in July when we are looking for June prices.

“Replace with” and “replace all”, if it is accidentally entered, can lead to problems in the seventh month of the year. The July update of the letter requires that the word May be replaced with June.

And that’s how it came about that we sent out hundreds of letters to manufacturers across the country addressed “To Whom It June Concern.”

****

When things really go south at the office, keep in mind The Timbit Affair and a List of Bogus Firings.

**

For my first book, “Two Scoops” Is Just Right, please click here for the paperback version and here for the Kindle e-book version.

For the sequel, “Three Scoops” Is A Blast! (with the award-winning “Size of the Skip”) click here for paperback and here for Kindle.

For “Four Scoops” Is Over The Top (containing Hemingway short-listed “Caboose Follies”) click here for paperback and here for Kindle.

And finally, for my latest book, “Five Scoops” Is An Addiction!, please click here for the paperback and here for the Kindle digital version.

Also, I would love it if you joined me on Twitter (Alex_Carrick), Facebook and/or LinkedIn.