Observations
-
I always use automatic calculation in my Excel spreadsheets. But I often cross check with paper and pencil.
-
Just out of interest, what exactly are you cross checking? Is it Excel's ability to perform calculations, or your ability to select the right data/functions?
-
Excel is OK for what it does, but they do insist on using spreadsheets for database functions shared over multiple users here and then complaining when it doesn't work properly. Typically the complaint is that somebody has the spreadsheet file open and somebody else can't add a new item.
Mark Parity wrote:
Typically the complaint is that somebody has the spreadsheet file open and somebody else can't add a new item.
Sounds like you need to designate a "spreadsheet administrator" role. That person should have sole responsibility for amending data, and everyone else just faxes over their change requests.
-
Mark Parity wrote:
Typically the complaint is that somebody has the spreadsheet file open and somebody else can't add a new item.
Sounds like you need to designate a "spreadsheet administrator" role. That person should have sole responsibility for amending data, and everyone else just faxes over their change requests.
-
I have this guy sitting next to me blabbering some stuff about Excel features when I have a perfectly functioning calculator.
"If we don't change direction, we'll end up where we're going"
[Problems!](https://xkcd.com/1906/)[^]
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
-
Just checking that the answer is what I expect. I often have to add items to list of figures and then (if I remember) do a copy down of the equation. So I like to know I have done all the steps necessary to get the right answer.
Ah, Test Driven Development, the old way. :) <edit>I don't intend to be snarky, I do it as well</edit>
Wrong is evil and must be defeated. - Jeff Ello
-
The bloke on the next desk to me uses a pocket calculator to add up lists of numbers that are contained in an Excel spreadsheet. I've tried telling him about the calculating abilities built into Excel but he won't listen and continues to use the pocket calculator (He says I've got this calculator I bought in 1990 so I'm going to continue to use it!). Now he's complaining that the batteries in the pocket calculator are running out... Oh well at least its Friday.
That's a pity, as some of us here must have known that Excel can do much more compared to pocket calculator in shorter amount of time. Hey, may be you could suggest to that bloke that abacus can sometimes do certain calculations much faster than pocket calculator and abacus doesn't need battery. :-D
-
That's a pity, as some of us here must have known that Excel can do much more compared to pocket calculator in shorter amount of time. Hey, may be you could suggest to that bloke that abacus can sometimes do certain calculations much faster than pocket calculator and abacus doesn't need battery. :-D
Ronny Japutra wrote:
Hey, may be you could suggest to that bloke that abacus can sometimes do certain calculations much faster than pocket calculator and abacus doesn't need battery
Wrong... it is the person using the abacus, who is faster, not the abacus.
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
The bloke on the next desk to me uses a pocket calculator to add up lists of numbers that are contained in an Excel spreadsheet. I've tried telling him about the calculating abilities built into Excel but he won't listen and continues to use the pocket calculator (He says I've got this calculator I bought in 1990 so I'm going to continue to use it!). Now he's complaining that the batteries in the pocket calculator are running out... Oh well at least its Friday.
The person sitting next to you sounds like an idiot. Have fun with that... :doh:
-
Ronny Japutra wrote:
Hey, may be you could suggest to that bloke that abacus can sometimes do certain calculations much faster than pocket calculator and abacus doesn't need battery
Wrong... it is the person using the abacus, who is faster, not the abacus.
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
Nelek wrote:
Wrong... it is the person using the abacus, who is faster, not the abacus.
M.D.V. ;)
That is correct.:thumbsup:
-
The bloke on the next desk to me uses a pocket calculator to add up lists of numbers that are contained in an Excel spreadsheet. I've tried telling him about the calculating abilities built into Excel but he won't listen and continues to use the pocket calculator (He says I've got this calculator I bought in 1990 so I'm going to continue to use it!). Now he's complaining that the batteries in the pocket calculator are running out... Oh well at least its Friday.
-
The bloke on the next desk to me uses a pocket calculator to add up lists of numbers that are contained in an Excel spreadsheet. I've tried telling him about the calculating abilities built into Excel but he won't listen and continues to use the pocket calculator (He says I've got this calculator I bought in 1990 so I'm going to continue to use it!). Now he's complaining that the batteries in the pocket calculator are running out... Oh well at least its Friday.
Mark Parity wrote:
Now he's complaining that the batteries in the pocket calculator are running out...
Suggest that he uses the calculator on his phone. :) But what I really wonder is, if you were to give him a VBA script that plugs into Excel that creates a calculator ([like this one](https://www.youtube.com/watch?v=jDxA34t4pr4)) would his brain short-circuit? :laugh:
Latest Article - A Concise Overview of Threads Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
-
The bloke on the next desk to me uses a pocket calculator to add up lists of numbers that are contained in an Excel spreadsheet. I've tried telling him about the calculating abilities built into Excel but he won't listen and continues to use the pocket calculator (He says I've got this calculator I bought in 1990 so I'm going to continue to use it!). Now he's complaining that the batteries in the pocket calculator are running out... Oh well at least its Friday.
I remember accountants using Excel as a word processor.
-
Mark Parity wrote:
Now he's complaining that the batteries in the pocket calculator are running out...
Suggest that he uses the calculator on his phone. :) But what I really wonder is, if you were to give him a VBA script that plugs into Excel that creates a calculator ([like this one](https://www.youtube.com/watch?v=jDxA34t4pr4)) would his brain short-circuit? :laugh:
Latest Article - A Concise Overview of Threads Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
-
[Problems!](https://xkcd.com/1906/)[^]
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
No sh*t. I work for a company where all of the technical managers are former mechanical engineers. Every document is an Excel spreadsheet, or a spreadsheet embedded in a PowerPoint presentation they pilfered from a marketing yabbo. It's spelled W-o-r-d you morons.
Software Zen:
delete this;
