An interesting and obvious little maths ditty ...

Cafe Society
1

This actually happened to me, in real life, today.

Boss gives you a long list of figures in a spreadsheet and asks you to total them - he still hasn’t found the auto sum button

So you sum them and send it back - the bottom of the sheet looks a bit like this (note this is just the bottom end shown here - the total includes a longer list of items):


...
sandwiches              120
beer                   1020
hotels                13390
clothing               2300
fuel                   5600
travel                  200
                     ======
                      53600

You sum the column as shown and send the totalled sheet back to the boss, but he replies saying “wait - that last item - ‘travel’ is a reimbursement - it needs to be subtracted instead”.

What’s the new total?

2

53,200? I don’t get it. :frowning:

3

53,200 if he’s paying it out or 53,400 if it’s simply being omitted.

I think he’s pointing out the fact that he could have done that in his head in like 2 seconds instead of sending it back.

4

Aren’t all of those items reimbursements? It looks like an expense account tally.

5

Oh. Got it. His boss must have a pointy head. :smiley:

6

53,200

woosh?

7

I don’t get it either. What’s the ditty?

8

I don’t know what ditty he’s talking about, but I thought his point was that a chopped off top of a 2 looks exactly like the chopped off top of a 3 in that font. That would make the subtraction ambiguous if he didn’t have the rest of the numbers in front of him. But he does.

Yep. I don’t get get it.

9

I believe he is trying to point out that “most” people will give the answer $53,400, because they will simply subtract the 200 from the current total.

10

Yeah, but a ditty is a poem or song, isn’t it?

11

Kinda like I did before my brain caught me? :slight_smile:

12

Perhaps I meant something else. Dalliance, diversion or something.

Anyway, what happened is this (this is all real, only the figures have been changed to the simplified versions above):

Boss gives PA a spreadsheet of values to total (because he doesn’t know how

PA doesn’t know either, so passes to employee X

X totals and passes back up the chain

Boss says “wait - that 200 is a credit - it needs to be subtracted instead” - passes spreadheet back to X (via PA) for correction.

X prefixes the number with a minus sign - the total recalculates itself, X passes it back up the chain.

Boss looks at total and notices it has gone down by 400 (not 200), declares “something is wrong with this”, and passes it to PA

PA examines it and declares “Yes, something is wrong - you were only meant to subtract 200, but the total has gone down 400 from 53600 to 53200”

X scratches head, receives splinters, calls IT support (me) and says “Excel isn’t totalling properly”

I Examine spreadsheet, cannot find anything amiss, demonstrate that inserting the minus sign does indeed result in the 200 being subtracted instead of added, cannot discern the problem.

X tries to explain - that’s when I realise what they’re all doing. I explain that 2+2+2=6, whereas 2+2-2=2 (not 4).

Disbelief, realisation, embarrassment. X passes spreadsheet back to PA, explaining: 2+2+2=6, whereas 2+2-2=2 (not 4).

Disbelief, realisation, embarrassment… Unfortunately, I didn’t get to witness the last part of the story, where it went back to the boss, but I think we can all probably imagine it.

These people run the company I work for.

13

Okay. Cool. But you did know this is CS, right? :slight_smile:

14

The link to my bunny keeps it safe. :wink:

15

Yeah, I meant to put it in MPSIMS, dunno what happened there.

16

No! Wait! It’s free verse!

Yeah, that’s what it is.