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

aaron.kempf@xxxxxxxxx wrote...
>ALL MATH IS A SIMPLE ADD AND SUBTRACT

So needless to say you have no clue what EXP, LN and IRR functions do,
just to name 3 that do a bit more than add and subtract.

All math may reduce to arithmetic when calculating cardinal and ordinal
results, but the magic is in the algorithms, data structures and
referencing mechanisms. In databases, there's only one data structure:
tables; and there are only two referencing mechanisms: SELECT queries
with and without joins.

>get off your high horse; your math isn't 'TOO HARD' for a database and
>you will be roadkill if you dont expand your horizons

The calculations take place in the same CPU for Excel and Access, so
they shouldn't differ in 'hardness'.

The problem with databases is the relative inflexibility of tables as
data structures and the awkwardness of queries as the only referencing
mechanism (unless you assume the existence of tons of additional
software to which few if any non-IT business users have access).

We've already seen that you can't come up with anything better for
simple amortization tables than the queries *I* proposed in

http://groups-beta.google.com/group/microsoft.public.excel/msg/ee7524741faf6518?dmode=source&hl=en

which proves nothing more than you're clueless about how to make
amortization tables. The necessary queries are a joke compared to the
simplicity of how to do this in Excel *FROM* *SCRATCH*, to wit,

1. Define R with the periodic interest rate, N as the number of periods
over which loan payments would be made, A as the initial loan amount,
and P as =PMT(R,N,-A). Since you'd also need to specify these in a
database approach, same data entry requirements so far in Excel and
Access.

2. Enter the following column labels in A1:E1.

A1: Month Number
B1: Prior Balance
C1: Interest
D1: Principal
E1: Current Balance

3. Fill in the first record in A2:E2.

A2: 0
B2: 0
C2: 0
D2: 0
E2: =A

4. Fill in the template formulas for the second record in A3:E3.

A3: =A2+1
B3: =E2
C3: =R*B3
D3: =P-C3
E3: =B3-D3

5. Complete the table by selecting A3:E3 and filling down into A4:E362.

Real hard. Oh so much more difficult than 5 obscure SQL queries,
especially since calculating interest portions directly in Excel (prior
balance times periodic rate) is so much more difficult than calculating
the principal portion directly in Access (periodic payment divided by
one plus periodic interest rate raised to N less current month number
plus 1).

You are so clueless.

Then, just speaking for myself, since I'm having to spoon-feed you the
queries needed to perform the tasks *YOU* say are so easy to do in
databases but *YOU* have proven to be incapable of providing, looks
like I have nothing to fear from you if every company I could work for
were to ban Excel tomorrow and mandate Access use only. The difference
between us is that I know how to use the tools you claim are the only
ones anyone needs to use while you can't figure out the other tools I
use.

Who's roadkill?

Well, neither of us. I'll have a job because I'm so clever, and you'll
have a job because database grunts, like septic tank cleaners, will
always be in some demand.

.