|
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.
|
|
|
|
|
We already have one of those, don't worry, the problems usually occur when the administrator is on holiday.
|
|
|
|
|
I always use automatic calculation in my Excel spreadsheets. But I often cross check with paper and pencil.
|
|
|
|
|
Paper and pencil, that's one step down from a calculator.
I suggest you invest in a slide rule. 
|
|
|
|
|
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?
|
|
|
|
|
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>
|
|
|
|
|
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. 
|
|
|
|
|
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.
|
|
|
|
|
Oh, I distrust Excel.
Excel, on the other hand, distrusts me much more.
|
|
|
|
|
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) would his brain short-circuit? 
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
|
|
|
|
|
Oh his (smart)phone is strictly for calling people. I once suggested there was an app for something or another, the reply was "I don't have any apps on my (smart)phone
|
|
|
|
|
I remember accountants using Excel as a word processor.
|
|
|
|
|
Does bad memory make you DIMM ?
"If we don't change direction, we'll end up where we're going"
modified 30-Nov-18 5:17am.
|
|
|
|
|
Not sure - I can't remember off hand.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I prefer mine static, no need to be chasing around after it.
Message Signature
(Click to edit ->)
|
|
|
|
|
Like this?[^] (youtube)
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
That doesn't register very high on the joke-o-meter.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I work on double data rate - when I get high and when I get low.
|
|
|
|
|
It's Friday, so a nice easy one to end the week:
The chaste man undid the cable tie(8)
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
When you say "a nice easy one" you do know how dumb that makes the rest of us feel? Or is it just me?
|
|
|
|
|
Hopefully, it's just you!
I've noticed that what is an "easy clue" for some is impossible for others, and vice versa - maybe I shouldn't have called it easy ...
Mind you, I thought yesterday's was fairly easy - did it make sense to you once you had the answer?
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: did it make sense to you once you had the answer?
Yes when you post the answer I usually know what the answer is.
How about next week you post the answer and we work out the question.
|
|
|
|
|
I guess it's a skill: improves with time and practice.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
