Users

[diddi]

i have a project where several users enter info onto a form which ensures that each section is completed correctly, but the boss who has no IT idea demands a tool without validation for himself to be able to 'edit' the data. so when it falls over i check and find a date field with "not needed" in it or something equally dumb. needless to say the other users dont have any problems. lol

 

[Michael M]

Hmm, didn't know we had the same boss !!!
Nice and cool here P.....minus 5 this morning !!

 

[JamesW]

My personal favourites are:

I open a spreadsheet someone who is an "excel consultant" has created only to be greeted with a wall of bright red cells which cause my eyes to bleed.

Also, in said spreadsheet, there are 255 columns and 60k rows all with duplicate information and about 6 billion vlookups. This "Expert" is paid more per day than I get in a month... I managed to get the spreadsheet down to about 20 columns in the end.

Someone typing in numbers then getting out a calculator to sum them up.

People insisting on using +=A1+B1 on EVERYTHING (my Father is the major culprit).

Users asking why =A1+B1 won't work when one of the cell values is "TAX @ 20%"

Users creating a mammoth nested if/and/or formula when a simple SUMIF will suffice.

There's hundreds more..

 

[Ruddles]

My pet hate is probably that mahoosive long formula which the user ends up not being able to understand or even modify without causing a syntax error, because he insists on shoehorning it into a single cell when the sheet still has 16,370 empty columns to the left which he could use to break the formula down into three or four much simpler chunks.

 

[arkusM]

I open a spreadsheet someone who is an "excel consultant" has created only to be greeted with a wall of bright red cells which cause my eyes to bleed.

 

[RoryA]

The only thing worse than users is consultants.
I'm sure there are exceptions (e.g. all of you who do that consulting thing) , but every one that I have come across at work has been useless, or worse.

Actually, I take that back - trainers can be worse than both. (not Bill, obviously)

 

[arkusM]

Users; can't live with 'em, can't live without 'em

 

[RoryA]

I'm generally my only user, and I still get annoyed by the things I do.

 

[Ruddles]

Users; can't live with 'em, can't live without 'em

Can't live with 'em; can't bludgeon 'em to death, cut their bodies into small pieces and bury 'em under wasteland.

 

[texasalynn]

We had a consultant that named his files "Book1, Book2, Book3, etc"
Really??