Meet the Other Phone. Flexible and made to last.

Meet the Other Phone.
Flexible and made to last.

Buy now

Please or to access all these features

AIBU?

Share your dilemmas and get honest opinions from other Mumsnetters.

DH has been using a calculator to add things recorded in Excel

510 replies

RokaandRoll · 23/03/2024 10:44

AIBU to think this is absolutely astonishing?

I found out because we were doing a new budget spreadsheet and he read out what we spend on different things each month while I recorded each item in Excel. He then asked me to read the amounts back to him so he could add them up. I was like WHAT??? I'll just add a formula in Excel. He said "really, you can do that?" I asked him what he thought Excel was for, and he said he didn't know as no one had taught him.

Have you ever found out someone was doing something in a completely bizarre and illogical way on a similar level as this? DH is in his 50s and is a quite intelligent person (or so I thought). He has used Excel in his job although obviously not extensively. AIBU to be completely shocked?

OP posts:
Thread gallery
11
TwirlyWhirlie · 23/03/2024 17:57

I haven’t got a clue how to do a formula in excel. YABU. Just let him do his thing.

BlackForestCake · 23/03/2024 17:59

For a lot of people, Excel is just electronic squared paper and that is all they need it for or use it for.

infor · 23/03/2024 18:07

Topseyt123 · 23/03/2024 11:54

Excel actually is a massive calculator. Hope your revelation will now save DH loads of time.

I am in my late fifties and have used Excel a fair bit, though sporadically. It was part of my working life. I even still remember the pre-Excel days when it was all still Lotus 123!! That did work in a broadly similar way and when Excel first began to replace Lotus then most of the same formulae worked on both.

Spreadsheet software is designed for doing calculations and managing basic databases.

Excel is actually a bit rubbish with numbers IMVHO. It is better as a database but definitely wobbles when you ask too much of it.
In 30 years, I've used about 60 formulas (formulae for the pedants) which is a little over 10% of what's available, so it isn't unusual for anyone to see something for the first time.
The cleverest things I've learned are from watching folks get stuff wrong - knowing when to leave 'False' or '0' off a vlookup can turn an average user into a guru.

ThickAsTwoShortPlanks · 23/03/2024 18:13

The day I asked a relative if she'd watched a particularly interesting space documentary, she said "God no! why do you watch those boring space programmes? I mean, everyone knows the universe is just the sun, 9 planets and a moon. I mean, how many documentaries can they make about that?!"

I was like, whaaaaat? 🫨

Cue a long conversation about the vast vast expanse of the universe and the colossal amount of other sun's, planets, moons, comets, asteroids, solar systems, galaxies, black holes etc etc.

For all the years before this, she'd simply thought all that was made up for cinematic effect for the likes of Star Trek films and never imagined it was actually real.

Clearly never paid any attention in science lessons at school!

madeinmanc · 23/03/2024 18:17

ThickAsTwoShortPlanks · 23/03/2024 18:13

The day I asked a relative if she'd watched a particularly interesting space documentary, she said "God no! why do you watch those boring space programmes? I mean, everyone knows the universe is just the sun, 9 planets and a moon. I mean, how many documentaries can they make about that?!"

I was like, whaaaaat? 🫨

Cue a long conversation about the vast vast expanse of the universe and the colossal amount of other sun's, planets, moons, comets, asteroids, solar systems, galaxies, black holes etc etc.

For all the years before this, she'd simply thought all that was made up for cinematic effect for the likes of Star Trek films and never imagined it was actually real.

Clearly never paid any attention in science lessons at school!

And what about you, did you pay attention in English?

Zapss · 23/03/2024 18:22

Ok I went onto Youtube and apparently I tie my laces by the "strange" rabbit ears method.

So what's the other method?

DextrousCT · 23/03/2024 18:26

You can certainly sort tables in Word. The function is labeled AZ with a downward arrow, and is found in the ribbon to the left of the pilcrow (backward P) paragraph symbol.

mrsdineen2 · 23/03/2024 18:27

madeinmanc · 23/03/2024 18:17

And what about you, did you pay attention in English?

Given that it's a perfectly well formed and understandable piece of writing, with one small typo that I've only seen because your bitchy put down suggested there was something to be found, then I'd have to conclude that yes, she did pay attention in "English".

(I assume of course that you meant "English lessons", despite your own incomplete sentence.)

Onelifeonly · 23/03/2024 18:29

We use Excel, Word, PowerPoint etc regularly at work. No one ever taught us. I worked out most of it by trial and error, checking occasionally with IT guy, asking my DH and getting tips from co workers at random times. TBH I've probably given others more tips than they've ever given me, though I do now have a well informed colleague but even he is clueless re some of the features of Excel. We had a new central information system recently and we're told we don't need training as it's all intuitive - some of it is, most certainly isn't.

HideTheCroissants · 23/03/2024 18:30

BlueBadgeHolder · 23/03/2024 16:44

@HideTheCroissants your school was very much a trailblazer to offer an O level in computing in the mid eighties. That was unusual.

Sat the O Level in 1985. I have a feeling we were the first year to be offered it as an O Level subject. I remember the “computer lab” being opened with much fanfare (and enough BBC computers for a class to have a machine each) in around 1982 or 83.

madeinmanc · 23/03/2024 18:32

mrsdineen2 · 23/03/2024 18:27

Given that it's a perfectly well formed and understandable piece of writing, with one small typo that I've only seen because your bitchy put down suggested there was something to be found, then I'd have to conclude that yes, she did pay attention in "English".

(I assume of course that you meant "English lessons", despite your own incomplete sentence.)

So what I wrote constitutes a "bitchy put down" in your opinion, but lambasting a relative's lack of knowledge is perfectly nice and kind?

housethatbuiltme · 23/03/2024 18:34

Iamtheoneinten · 23/03/2024 17:31

It literally doesn’t.

It literally does though:

1640s, "one who calculates, a reckoner, one whose occupation is to make arithmetical calculations," agent noun from compute (v.).

Meaning "calculating machine" (of any type) is from 1897; in modern use, "programmable digital electronic device for performing mathematical or logical operations," 1945 under this name (the thing itself was described by 1937 in a theoretical sense as Turing machine). ENIAC (1946) usually is considered the first.

Computer literacy is recorded from 1970; an attempt to establish computerate (adjective, on model of literate) in this sense in the early 1980s didn't catch on. Computerese "the jargon of programmers" is from 1960, as are computerize and computerization.

WASHINGTON (AP) — A New York Congressman says the use of computers to record personal data on individuals, such as their credit background, "is just frightening to me." [news article, March 17, 1968]

Earlier words for "one who calculates" include computator (c. 1600), from Latin computator; computist (late 14c.) "one skilled in calendrical or chronological reckoning."also from 1640s

from:1640s | Search Online Etymology Dictionary

The online etymology dictionary (etymonline) is the internet's go-to source for quick and reliable accounts of the origin and history of English words, phrases, and idioms. It is professional enough to satisfy academic standards, but accessible enough...

https://www.etymonline.com/search?sort=a&q=from:1640s

housethatbuiltme · 23/03/2024 18:35

RampantIvy · 23/03/2024 17:25

Not for me. I'm an excel thinker. I think very logcally and rationally.

I guess it depends on the age of a person but I'm 35 and it was litrally a basic requirement of our mandatory GCSE's. My DH is nearly 40 and learned in school too.

What mandatory GCSE subjects did you sit? DD is 23 and they were never taught excel at school. But she didn't do computing at GCSE. I went to classes to learn all the Microsoft Office programmes when I was in my thirties - back in the 1990s because Im not a dinosaur stuck in the past.

There is a whole generation of young people who find it unthinkable that older people didn't grow up with mobile phones, computers and fax machines.

When I was doing O levels we didn't even have calculators.

Thank goodness for progress.

It was one of the 2 parts of the ICT GCSE which was mandatory. The first part was building a complete database using Excel, that made up 60% of the coursework.

Iamtheoneinten · 23/03/2024 18:35

Mumoftwo1312 · 23/03/2024 17:48

You're the second person who has argued with this... you can look it up? The etymology is from the Latin word for calculate/add up/reckon.

Edit - I guess you're quibbling with the Machine part?

So Adding Thing. Rather than Adding Machine?

Edited

I'm not arguing. I'm stating fact.
And there is more than one reason your original statement is wrong.
Usually I would happily explain to someone who didn't know something, or who thought they knew something, but got it wrong. With no judgement.
However, you came on a thread to castigate someone else's lack of knowledge, and, well, got it wrong. So I think it would be more useful for you to find out for yourself.

moderate · 23/03/2024 18:37

Mumoftwo1312 · 23/03/2024 17:48

You're the second person who has argued with this... you can look it up? The etymology is from the Latin word for calculate/add up/reckon.

Edit - I guess you're quibbling with the Machine part?

So Adding Thing. Rather than Adding Machine?

Edited

And yet, having been corrected twice, you still didn’t bother to look it up before you started pontificating again.

And then, having realised that maybe “machine” was wrong and edited your post, you still didn’t bother to look it up before doubling down on “adding”!

The mind boggles.

mrsdineen2 · 23/03/2024 18:39

madeinmanc · 23/03/2024 18:32

So what I wrote constitutes a "bitchy put down" in your opinion, but lambasting a relative's lack of knowledge is perfectly nice and kind?

If you think a single rogue apostrophe is to the understanding of English, as not knowing of the existence of anything whatsoever outside our immediate solar system is to the understanding of science, then I don't know what to say.

housethatbuiltme · 23/03/2024 18:39

Zapss · 23/03/2024 18:22

Ok I went onto Youtube and apparently I tie my laces by the "strange" rabbit ears method.

So what's the other method?

The rabbit ear method was used by occupational therapists for kids with learning difficulties as it far easier to learn.

I learned it that way due to my disability which effects my motor functions but everyone else I know learned the classic 'fox chasing the bunny' way.

Mumoftwo1312 · 23/03/2024 18:40

moderate · 23/03/2024 18:37

And yet, having been corrected twice, you still didn’t bother to look it up before you started pontificating again.

And then, having realised that maybe “machine” was wrong and edited your post, you still didn’t bother to look it up before doubling down on “adding”!

The mind boggles.

But... it does... I haven't been corrected?

The "er" suffix is the machine part.

I'm unsure what you think it means?

Grr edit for typo! Er not or obvs

DysmalRadius · 23/03/2024 18:40

Picklestop · 23/03/2024 12:15

I noticed my husband tying shoelaces very strangely a few years ago. He creates a loop with each end of the lace separately and then ties the two loops in a knot. Nobody had shown him to tie laces in a bow!

If he's the right age, King Rollo probably taught him. It's a far superior knot IMO.

The magic happens about 2 minutes in.

King Rollo and the New Shoes

https://youtu.be/9iuyuutEC8g?si=VUTg0BS6P10Du6f-

DontBeAPrickDarren · 23/03/2024 18:41

Awww I LOVED Rollo! Haven’t thought about that for years.

DysmalRadius · 23/03/2024 18:42

And I still remember the first time I saw someone concatenate columns in a spreadsheet - I could have cried for joy as I was just about to embark on an upsetting merging process that I knew was going to end in tears.

Another2Cats · 23/03/2024 18:42

Ifailed · 23/03/2024 11:43

I remember the day when someone showed me the 'hidden' flight simulator in excel!

P.S. I would happily use Lotus 1-2-3 if it was still available.

That's a real blast from the past. I remember using Lotus 123 when I first started work in the late 1980s.

moderate · 23/03/2024 18:42

housethatbuiltme · 23/03/2024 18:34

It literally does though:

1640s, "one who calculates, a reckoner, one whose occupation is to make arithmetical calculations," agent noun from compute (v.).

Meaning "calculating machine" (of any type) is from 1897; in modern use, "programmable digital electronic device for performing mathematical or logical operations," 1945 under this name (the thing itself was described by 1937 in a theoretical sense as Turing machine). ENIAC (1946) usually is considered the first.

Computer literacy is recorded from 1970; an attempt to establish computerate (adjective, on model of literate) in this sense in the early 1980s didn't catch on. Computerese "the jargon of programmers" is from 1960, as are computerize and computerization.

WASHINGTON (AP) — A New York Congressman says the use of computers to record personal data on individuals, such as their credit background, "is just frightening to me." [news article, March 17, 1968]

Earlier words for "one who calculates" include computator (c. 1600), from Latin computator; computist (late 14c.) "one skilled in calendrical or chronological reckoning."also from 1640s

Can you pick out the bit in what you quoted here that you think supports the claim “the word computer literally means adding machine”?

Mumoftwo1312 · 23/03/2024 18:43

moderate · 23/03/2024 18:42

Can you pick out the bit in what you quoted here that you think supports the claim “the word computer literally means adding machine”?

Ah I see the confusion. I think you don't accept that "reckoning" is a synonym for "adding". But it is the original meaning of the word reckoning

DysmalRadius · 23/03/2024 18:44

Anyone else use AmiPro? I have no idea how widespread it was!