Quote:
Originally Posted by DiapDealer
The only "power-using" of Excel (or any spreadsheet software) I've ever done was to massage the data from people's personal, pet-monstrosities into something that could be imported into a database where it belonged all along. 
|
Now, now, Diap, don't be cranky. ;-)
Not everything in a spreadsheet belongs in a db, you know that. Hell, for the typical spreadsheet user, it would be an egregious waste of time to manipulate a database just to add up a column of figures, or even create a pivot table.
A long time ago and far far away, I had a world in which spreadsheets were a relatively new thing. I had this massive project underway, a RE Development deal, and it had iterating mathemathical needs, based on a series of "what ifs." I can't tell you how laborious this was, before the advent of spreadsheet "computing," for lack of a better word, but once I could do it with 123, life was dramatically easier--and my biggest issue became printing out sheets on dot-matrix printers and figuring out how to tape them together in such a way as to be usable and presentable in a boardroom, to explain internal rates of return, etc., along with various other things, to brain-dead accountants who would fight me for every penny expended, on a project running hundreds of millions of dollars. ;-) Lotus 123 was my FRIEND, lol!
Hitch