Re: The best elegant solution to override 65k rows limit in a ***

aaron.kempf@xxxxxxxxx wrote...
....
>and then you can centralize your logic in one place; and when you need
>to change your calculation; you can do it all in one place.. instead of
>wading through 1000 different XLS formulas.. I mean..

You don't get it. Either the formulas and workbook templates don't
change, only the data entered changes (and IMO manual data entry is
slightly easier in Excel than Access, though there's something to be
said for input masks in Access; copy & paste entry from non-XLS,
non-tabular files is much easier in Excel than Access), in which case
don't-reinvent-the-wheel is operative; or the formulas aren't the same,
in which case saved previous business logic isn't useful.

>aren't you tired of having numbers that dont match?

And you've never come across situations in which two derived dbms
tables that should be showing the same results differ in some records?

Reconcilliation nightmares don't entirely disappear when one uses
dbms's.

>the root of the problem with Excel is that you have different formulas
>in each cell-- in Access you have a different formula for each COLUMN
>(or field.. whatever nomenclature you choose)

As I mentioned before, there have been lots of software products that
provided multidimensional database-like functionality, starting with
Lotus Improv (actually starting with the spread*** VP-Planner, but
its multidimensional database was rather limited). All were going to
kill spreadsheets as we know them. Most are not extinct and the
spread*** lives on & on. Rats outlived dinosaurs, and cockroaches
will likely outlive rats. Feel free to consider spreadsheets the
cockroaches of the software world.

There's a perception that the flexibility provided by spreadsheets,
with a single formula per cell, is worth it. Having a rough idea what
it took to tweak individual 'cell' results in Improv (it required
creating another dimension for exceptions, then incorporating the
exception dimension into the formulas), I can understand why such
programs have never sold well for general use.

>I just know that there is a better way for all you guys to spend your
>workdays.
....

You have no idea how we spend our workdays. You believe we spend our
time in the same report creation cesspool you do. Ain't so.

.

Loading