ExcelBanter - View Single Post - PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic

Harlan Grove

wrote...
....
a) i can do any math you can but faster

First you'd need to translate that Pascal code for inverting matrices,
no? Then you'd have to figure out the table-to-matrix and
matrix-to-table interface. Then as soon as you come across a nasty
nonsingular matrix, you'll need to go find someone else's matrix
inversion code (which you also won't understand), translate it, ensure
your table to udf interface works, then finally be able to start
performing the calculations I would have finished days before.

b) im sick and tired of cutting and pasting the same formula 100 times per day

So sad.

c) it's less efficient to have 200 copies of the same formula
1) sheer storage
2) accuracy
3) development of these 'super-complex spreadsheets (gag)'
....

You have a point about #1, but it's a trade off with flexibility. There
are times people use computers standalone. That requires some
redundancy.

As for #2, if it's the *same* formula, how would accuracy differ? Or do
you mean the possibility that inconsistencies may arise in spreadsheet
formulas? That's a real problem, but there are tools available that
sensible Excel users or developers should use to detect and fix it.

And with respect to #3, you've demonstrated that you don't really
understand anything more complicated than counting and summing. I'll be
generous and stipulate that you do a minimally competent job of writing
code implementing procedures for which you're given detailed specs by
people who do know more than grade school math.