I am just old enough to remember a real spreadsheet. It was an A0 piece of paper printed with boxes and you filled it in in pencil, doing the calculations manually as you went. Then someone else would check all the calculations.
I'm surprised by the number of my colleagues still doing completion statements with Word and a calculator. A little bit of practice and Excel will do all the sums for you and more and you don't have to retype the whole thing if you change one figure.
Worth knowing that computers use floating point approximations in some places so if you've double and triple checked that a calculation should be right but it still isn't you can think to yourself "I wonder if this is a floating point error" and google appropriately.
0
0
The only thing worse than Excel is no Excel.
I am just old enough to remember a real spreadsheet. It was an A0 piece of paper printed with boxes and you filled it in in pencil, doing the calculations manually as you went. Then someone else would check all the calculations.
It was a lot of work and very slow.
0
0
but therapeutic!
anyway, after yonks, I worked out how to do it.
0
0
I'm surprised by the number of my colleagues still doing completion statements with Word and a calculator. A little bit of practice and Excel will do all the sums for you and more and you don't have to retype the whole thing if you change one figure.
0
0
when I did costs budgets etc, it was way easier to use word and a calculator
I have found Excel making mistakes in adding up
0
0
I always find it surprising that lawyers complain about Excel when they spend so much time using Word.
0
0
Heh @ Excel making mistakes when adding up.
0
0
Laugh away, Kaulers, but I have found that it is not to be trusted!!!
0
0
Heh @ Excel making mistakes when adding up.
Microsoft agrees with Judy:
https://support.microsoft.com/en-gb/help/78113/floating-point-arithmeti…
Took me a while to realise quite what the problem was when I hit it at work once.
0
0
Judy earlier today
http://t.co/xLz6zS7QHv
0
0
What is a floating point number?
0
0
Basically an approximation of a number Sails.
Worth knowing that computers use floating point approximations in some places so if you've double and triple checked that a calculation should be right but it still isn't you can think to yourself "I wonder if this is a floating point error" and google appropriately.
0
0
*chortles at the idea a completion statement might require arithmetic sufficiently large to bust the floaty point stuff on Excel*
*potters off to make tea, knowing that chortling is wrong*
0
0
Almost as exasperating are Excel files where every number is hardwired in, so it's really no different from a table in Word.
0
0
Always a tell tale sign that a lawyer has bravely had a go at doing some numbers.
0
0
Excel for Mac is dreadful. Microsoft has been really passive aggressive with the way they’ve written it.
0
0
I'm not doing anything complex in Excel for Mac but find it fine by and large.
What I object to is having to have a Microsoft account to get it so someone can then hack my account buy andX Box subscription.
Join the discussion