Rant: USERS!

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
magicrobotmonkey
Forum Regular
Posts: 888
Joined: Sun Mar 21, 2004 1:09 pm
Location: Cambridge, MA

Rant: USERS!

Post by magicrobotmonkey »

We need a user rants section. Here's my problem.

I'm writing a report for a user which pulls data and displays it in a table, averaging each row in an Average column and then averaging that column in the final Total row. Each cell is also an average of of three or four records in the db. OBviously, I want the data to be accurate, and so the data in the Average column is not an average of the averages in its row, but rather an average of the actual individual rows that went into each cell. The same goes for the Total number, not an Averages of the averages column, but rather an average of the actual rows again. I mean, this is the right way to do it. The information is accurate.

So, I give it to the user who must have immediatlely whipped out the trusty calulator and takes some averages of the averages he sees on the screen and determines that my math is off. So now he's <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span> at me - "Why don't these numbers add up? How are we supposed to rely on this data, etc."

For two days now I have been trying to explain to him what the deal is. I mean I've tried everything to get him to understand it. I list the individual numbers in each cell rather than their average. He still doesn't get it and insists on the numbers on the screen matching up. So finally I give in and make the stupid thing show all these crappy averages of averages that aren't even accurate. Gah!

There, I feel better now.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

:lol:
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

You should show him how stupid he is being by wanting the numbers on the screen to match up by just making up all the data with rand().
User avatar
Bill H
DevNet Resident
Posts: 1136
Joined: Sat Jun 01, 2002 10:16 am
Location: San Diego CA
Contact:

Post by Bill H »

Sorry, but in my humble opinion, the numbers should be averaged in whatever manner the customer wants them done. I have been in similar situations more than once, and each time I ask before I do the job "How, precisely, do you want the averages calculated?" You can lose lots of customers by insisting that you are right and they are wrong. To quote an old driving adage:
He was right, dead right, as he sped along, but he's just as dead as if he'd been wrong.
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post by CoderGoblin »

In reality you are both correct but it is up to the display to show what is going on....
If you have a column of (Row Average) this should be the row average.
If you have the bottom row of this column it should display the average of the Row average column only.

If you also want to provide a true average you could place it in yet another row/column listing it as True Average of all information.

Sounds more of a display/labelling issue than anything else but when push comes to shove the old adage the
"The customer is always right..."
comes into play. In this instance however I would keep track of correspondace so if someone else from the client firm comes along and asks why the true average is not displayed you can state the reason it is perfomed that way and give details.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Reminds me of trying to explain to a client how to take a screenshot under Windows: "You press <Print Screen>", open a graphics program (e.g. MS Paint), save it and send it to me as an attachment.

Took about 15 emails and 6 hours. <shudder>
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

I've found that the simplest way to get around problems like this is to change what the user thinks they are seeing. If they see an entry under "Row Average" that isn't an average of what they see, change the entry to say "Database row average". It might take some fine-tuning, but I've found this solves quite a few problems.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply