Stupid Customer Rant
A lot of my job is formalising peoples' work processes - generally taking their dodgy Excel spreadsheets that have been worked on by 20 people over 5 years, and turning them into a formalised database-based system - this gives them scalability, reliability etc. Along the way I come across some truly retarded Excel formulas.
So, a pop quiz. Find the two logical errors in this sequence, and state which values of y are achievable:
If x > -175 then
y = 0
else
if x <= -175 then
y = 1
else
if x < -250 then
y = 2
else
y = 3
end if
end if
end if
This isn't even close to the worst I've come across, but it's pissing me off right now - mainly because I know that if I ask the customer to explain it, he'll just get horribly confused because he doesn't understand his own processes.
This is also the guy who delivers reports to HIS customers based on calculations like the one above. We know (because they've told us) that those customers completely ignore all of his recommendations because it would put them out of business within one year.
*smacks head*
So, a pop quiz. Find the two logical errors in this sequence, and state which values of y are achievable:
If x > -175 then
y = 0
else
if x <= -175 then
y = 1
else
if x < -250 then
y = 2
else
y = 3
end if
end if
end if
This isn't even close to the worst I've come across, but it's pissing me off right now - mainly because I know that if I ask the customer to explain it, he'll just get horribly confused because he doesn't understand his own processes.
This is also the guy who delivers reports to HIS customers based on calculations like the one above. We know (because they've told us) that those customers completely ignore all of his recommendations because it would put them out of business within one year.
*smacks head*