(e-mail address removed) wrote...
So much easier than figuring out how to deal with my challenge.
you make the same friggin spreadsheet week in and week out
No, you only claim I do. You know nothing about what I do, and I know
you do nothing useful. But you do seem to claim a lot!
sure you change some numbers
You. That's what templates are for. Perform the same calculations on
different sets of numbers. You may finally be beginning to figure out
what spreadsheets can do. Progress, unless of course you fail to grasp
that this is what spreadsheets do well.
it just would be much mroe efficient to automate it with a real program
So entering a few hundred strings and numbers in a database form rather
than into a worksheet form? Hard to see much of a difference there. You
probably need to be reminded that most of the data I work with comes
from customers, so I get it from e-mail. It's not in any of my
company's databases, so no matter how powerful their query facilities,
if the data ain't there, they ain't gonna fetch it.
And *AS* I'm entering the data in a worksheet, some of the calculations
update in real time. And I don't have to run anything when I've
completed data entry. the calculations are already done. I'd have to
click a button or run a menu command in a database form to indicate
that I'd completed data entry, and then it'd make me wait as it churned
through the calculations.
fine.. screw microsoft; use crystal reports and mysql for all i care.
Still inappropriate tools for what I do. Again, I DON'T PRODUCE
REPORTS. It must be sad having to work with reports all the time, but
maybe you don't mind drudgery.
all i know is that you sit there and make the same-- or similiar
spreadsheets all the time.
I perform similar calculations most days. That's the nature of most
jobs: doing the same thing repeatedly. In my case, the bulk of my job
could be described as forecasting. Given the nature of my company's
products (financial services), there's a fairly narrow set of
calculations that are pertinent (though there's ongoing research into
refinement and alternative approaches). So, yes, highly repetitive. So
is econometric forecasting. Or tax accounting.
As for making spreadsheets, I use canned templates. Yes, that means I
save many different workbooks that share the same formulas. I also
share many of those workbooks with different coworkers in my own and
other field offices, and none of those coworkers has Access (or an
account on any of the company's RDBMSs). Mind telling me how they'd get
anything useful if they have no database front-end to use?
and it would be in YOUR best interests to start doing things with VALUE
instead of throwing time and money at copy and pastedom
....
An opinion founded on militant ignorance. If copy & paste is the most
efficient form of data entry, it's be foolish not to use it. If you
mean creating new workbook models, then it's still a rather efficient
way to deal with propagating similar calculations. As I've mentioned
before, formula copy & paste is the spreadsheet form of iteration.
Millions of databases are created in Excel spreadsheets each year, but
only a tiny percentage "graduate" to the next level: Access.
....
So you believe all spreadsheet models are just database applications?
More evidence that your perspective is extremely limited, and that
you're so ignorant you can't realize how little you know.
I don't dispute that Excel is often misused as a database. I do dispute
that I misuse it so, and you can keep on claiming I do, but that won't
make it so.
And until you *PROVE* otherwise, there's considerable and mounting
evidence that you can't figure out how to program elementary matrix
operations, thus disproving your claim that *YOU* can do anything in
Access that I can do in Excel. [Yes, I do, implicitly, invert matrices
several times a day as part of LINEST and LOGEST function calls.]
You might want to reconsider your relative priorities between
frequently responding with your normal vacuous rants and spending some
time figuring out my challenge. Throw a challenge at me if you want.
Even something involving more than 65536 rows. I may need to use
multiple worksheets, but I'll come up with an answer for you a lot
quicker than you've managed to answer me - still waiting after 5 days.
