APLawrence.com -  Resources for Unix and Linux Systems, Bloggers and the self-employed

Windows inefficiency

A comment by Drag at The upgrade that wasn't got me thinking about how computers have changed our lives and how they have not.

Back in the fifties and sixties, an oft heard worry was that computers would displace people, that there would be massive layoffs as automation replaced humans. That doesn't seem to have happened. Computer adoption has caused shifts in wages but even when some blame is placed on computer adoption, studies seem quick to point out that other factors (like global outsourcing) are more significant.

There's another interesting effect: computer automation has allowed companies to improve products and that is seen as more important than producing more product at less employee cost. Adding features or improving reliability by computer assistance may be more important to some businesses than reducing employee count.

It's hard to say what computer adoption has done to economies overall, but the fear of wholesale layoffs seems to have disappeared from our consciousness.

But back to our title subject: it's my assertion that Microsoft Windows actually increases the number of humans required in a typical business by introducing gross inefficiencies. I don't necessarily mean that more people are required than if no computers were used at all (though sometimes that comes close to being true), but that the use of Microsoft products specifically is less efficient than ideal. Far less efficient.

Spreadsheets and Word Processors

The two biggest offenders are spreadsheets and word processors. I think "point and click" bears some responsibility here - see the post referenced in the first paragraph for more on that - but that could be overcome by good design (and sometimes is). But spreadsheets and word processing are surely the largest causes of business inefficiency.

I'll take word processing first because it's easier. The "secretarial pool" used to be a common department in business. These were the people (usually women) who typed up correspondence, kept calendars, made appointments - and oh yes, fetched coffee for their middle and upper management bosses. For the most part, that pool has disappeared. Managers have Microsoft Office on their computers and do almost all of that work themselves. How is that less efficient? Because they often spend inordinate amounts of time selecting fonts, fussing over paragraph spacing and the like: tasks that they really shouldn't be involved in at all.

Even if there is an assistant or if a secretarial pool still exists, they all use Microsoft Word and will also waste time formatting documents. None of that should be done by people: people should be typing plain text with markup (HTML markup would be quite suitable) and submitting that to a program that would apply company approved style sheets, analyze the text so that it can be properly indexed for later searching, store it in an appropriate location, pick an appropriate output method (which might be email, of course) and take it from there. That may be done in some companies, but it certainly isn't common, and notice that Microsoft Word or anything like it is completely unnecessary: an HTML input form would work quite well. The web has learned that content is separate from presentation, but word processing seems to lag (style sheets selected within word processing are NOT the same idea at all).

The ubiquitous spreadsheet is probably even worse at wasting time. Not only do people waste time in the same ways they do in word processing (futzing with fonts and other presentation concerns) but often the spreadsheet is misapplied to a business need that would be better met with a dedicated program (and again, an HTML form for input is a simple way to gather data). Not only would the dedicated program standardize the presentation details and give more control to storage, but it could eliminate the errors that are commonly found in spreadsheets due to their complexity and more easily allow the use of the data by other programs.

The misuse of spreadsheets is very common. For example, I have a number of customers who all happen to sell similar products and buy a lot of those products from the same large distributor. When prices change, that distributor publishes those changes in a spreadsheet accessible from the web. Amazing as it may seem, some customers work from that spreadsheet and retype changes into their inventory applications. Others are a bit more automated: they manually download the spreadsheet, open it in Excel, save it out as CSV and bring it into their software programmatically. However, in all cases a human is involved and so is Excel (or some open source equivalent).

Obviously this could be made much more efficient. The distributor could instead provide a CSV file - that wouldn't affect those that do this completely manually as a CSV can be loaded into any spreadsheet for those who want to download it or could be presented in HTML for those who will just read (or hopefully at least cut and paste). For those who have automated the process, the CSV eliminates at least one step. The distributor should also offer XML formats and should investigate delivering these changes completely electronically. This sort of foolishness is found across thousands of businesses and persists because Excel is so commonly used: because the managers responsible are unaware of the inefficiencies it introduces and don't know any better, they perpetuate the problem.

I've seen this very directly: I'll be asked if I can take some other programs data and convert it to a spreadsheet. Of course I can, but I've learned to ask why because often the answer is that the person asking intends to use the spreadsheet either as a conduit to some other program or simply to apply some computation that usually could be done more quickly and accurately some other way. The "when the only tool you have is a hammer, everything looks like a nail" really applies here.

IT needs to take a more aggressive role to both educate and to stand firm when technology is misapplied. Complacency causes a lot of this: IT needs to look behind what managers ask for and question why they are asking. A moments discussion could often point to far better ways to utilize the available computing infrastructure.



Got something to add? Send me email.





(OLDER)    <- More Stuff -> (NEWER)    (NEWEST)   

Printer Friendly Version

-> -> Microsoft Inefficiency requires more people


3 comments



Increase ad revenue 50-250% with Ezoic


More Articles by

Find me on Google+

© Anthony Lawrence







Fri Feb 1 16:49:36 2008: 3562   BigDumbDinosaur


Your comments about managers doing their own typing and such, and the effects on their (and the company's) efficiency are very good ones. A manager's role is to lead, set and/or enforce policy, conjure ways to help the company make more money, and so forth. S/he isn't there to type letters and fiddle with spreadsheets. Note that nothing was said about the creativity involved in managing. That's a whole separate issue unrelated to the mechanics of putting thoughts and ideas into a form that can be promulgated to the rest of the organization. The latter is what a good secretary or typist is all about.

At the level where guys like Tony and me operate, there's no question that we are going to be doing our own typing and "clerk and jerk work." I write a lot (as does Tony -- just look around here if you aren't convinced) and therefore I do spend some time in a word processor, although not nearly as much as one might think. To me, "writing" is really another way of saying "creating," and I simply use the tool best suited to what it is I am attempting to create. If it's a program, I'm in vi or a similar text editor, and will be bouncing back and forth between the editor and the compiler (here's where those console multiscreens come in handy). If it's a web page (I don't do a lot of those), it may also be vi, or if it has to be fancier than plain vanilla text with a few images, some sort of HTML editor to accelerate the process (although I may still hand-edit the page in vi to clean it up and shrink the file size). A letter to a client: that's when I will use a word processor -- and it won't be MS Word, you can bet on it.

The point Tony made so well is that too many Windows users are getting caught up in the nuts and bolts of what they are doing and are forgetting that the end result is what matters, not the way in which it was achieved. I blame a lot of that on simple "computer ignorance," a case of the user not knowing enough about the computing environment in which s/he is working to select the correct tool for the job. Case in point: the lamentably-common practice of using a spreadsheet as a Mickey Mouse database engine. I see that sort of crap all the time, usually produced by someone who doesn't know a database from a toilet seat.

Speaking of spreadsheets, I've yet to find any use for one. My HP scientific calculator works just fine for the sort of numeric stuff I do around here (I'm a computer jock, not an accountant). If I want to organize data, I certainly wouldn't use a spreadsheet for that purpose, as that would be like using a shotgun to perform a splenectomy. If the data to be organized is more than something I can simply list in a flat file, I've got everything from BASH to Perl to the Thoroughbred Dictionary-IV development environment at my disposal. Even the latter is overkill in most cases, sort of like dispatching a battleship to sink a rowboat.

As for Microsoft's PowerPoint, I can't recall ever needing any damned computer to make my point for me. Just ask my wife when it comes to politics. <Grin>



Sat Sep 18 13:03:54 2010: 8983   anonymous

gravatar


MICROSOFT has launched a war against efficiency a long time ago in order to sell more PCs (with bundled Windows licenses).

This is even more striking with Web application servers, see how IIS + C# is 5 MILLION TIMES slower than a (free) Linux Web app. server:

(link)






Sat Sep 18 13:18:56 2010: 8984   TonyLawrence

gravatar


Thanks for that link. I had forgotten about Microsoft's attempts to stop performance comparisons ( (link) )

------------------------
Kerio Samepage


Have you tried Searching this site?

Unix/Linux/Mac OS X support by phone, email or on-site: Support Rates

This is a Unix/Linux resource website. It contains technical articles about Unix, Linux and general computing related subjects, opinion, news, help files, how-to's, tutorials and more.

Contact us





If we define Futurism as an exploration beyond accepted limits, then the nature of limiting systems becomes the first object of exploration. (Frank Herbert)

The successful construction of all machinery depends on the perfection of the tools employed; and whoever is a master in the arts of tool-making possesses the key to the construction of all machines... The contrivance and construction of tools must therefore ever stand at the head of the industrial arts. (Charles Babbage)












This post tagged: