Slashdot Mirror
The Subtle Tyranny Of Spreadsheets
pipingguy writes "I found this link on a CAD-related mailing list which questioned the current state of spreadsheet usage. Since using spreadsheets is often only one step away from PowerPoint mastery, I thought it worthy of submission." An excerpt:
"The second distortion caused by conventional spreadsheets is more subtle. It's described in a 1980s paper, written by university researcher Jeffrey Kottemann and others concerning what they called 'Performance, Beliefs, and the Illusion of Control.' The paper described an experiment in which subjects were asked to perform a planning task using different tools, some of them with elaborate what-if capability and others without it." Yup, it's a ZD/Yahoo link, but it raises good questions."
back in 1997 when I was a physics exchange student in Glasgow, they made me solve a *quantum machanics* problem using excel! it was ridiculous. I kept the spreadsheet just for its absurdity (it's the only .xls file on my entire harddrive)
A manager at a company I worked for was presenting figures for the last year. He showed the financial breakdown for each division, with the profit being calculated as a percentage for each division. At the bottom, there was a summary line showing the total figures for the company and including the "average profit" for the company.
Which he had calculated by summing the profit column and dividing by the number of divisions.
I mentioned that this was producing a somewhat unrealistic figure, with a couple of small divisions showing very good profit margins and the largest department showing a slight loss. "No, that's the mathematical definition of 'median'," he answered.
Ceci n'est pas une signature
I've ranted about something similar to this before, but occasionally in the print business I worked at we would get Excel documents to print.
No, they didn't want printed spreadsheets - people would lay out flyers, leaflets, posters and small booklets in Excel.
I can only guess their creative genius had to be instantly addressed and they picked the first app they could think of to lay it out on, and excel was just sitting there loaded at the time.
What's so strange about that? Both are highly unpredictable, so it should work pretty well.
I'd say that the answer is maybe. For example, I have absolutely no idea how a standard deviation is actually calculated, but I know what one is and I know how to make Matlab do one.
Only in a Slashdot fantasy can a Slackware install turn into several hours of sex . . . . .
Excel as a database.
Signatures are for stupids.
* Clutches Matlab and mumbles. *
I didn't waste my time taking stats. I Didn't waste my time taking stats. I didn't . . . . . . .
Only in a Slashdot fantasy can a Slackware install turn into several hours of sex . . . . .
Don't knock the monkeys. I read somewhere that they actually wrote Shakespeare's plays.
And same goes for graphics. Never ever use MS Word drawing functions for, well, for anything really. You can never be quite sure what happens if you for example resize the image... Or type more text into a textbox... Or breathe...
Always insert Powerpoint slide into the document. Unless you really need something Powerpoint can't do of course, in which case you should use whatever actual drawing program you need to.
Not that I condone using Excel
But do you excel at using condoms?
main(char O){O++&&(((O-291)*O+27788)*O-868020?1:putchar(O++
Haven't you received 2-m long posters made on powerpoint? I've had! (to review, not to print...)
---
All my submissions to Slashdot rejected... and proud of it!
if you think that's perverse
That man tried to kill mah Daddy
So even they didn't believe in using Outlook for storing contacts and phone numbers?
One line blog. I hear that they're called Twitters now.
I like it when the dude celebrates "processing an impossible amount of data" using Excel and other Microsoft products and the two fat chicks come out and dump the whole water cooler tank of water on him.
Um, why do you want to fit it on a single sheet of paper? It's like saying "I tried to fit the book on a single sheet of paper and it's unreadable".
Trust the Computer. The Computer is your friend.
Why don't people just use Emacs.
There's a special place in hell reserved for the people who use Excel spreadsheets as mockups for HTML pages, considering that there are numerous HTML WYSIWYG editors available.
These are the same people who complain when the final HTML page does not look EXACTLY like the Excel version.
Explaining to them the impedance mismatch between Excel and HTML is a pointless endeavor. Banging my head over and over against a doorknob is more enjoyable.
One time when I was working at the computer lab help desk in college, I had a guy who was writing a paper in Excel, one word per cell! He'd just type a word, hit Tab, type the next one, and so on. The question he had was "How do I doublespace my paper?" I was dumbstruck.