Re: why>?

you couldn't physically use formulas to VALIDATE other formulas if your
life depended on it.

i mean jesus harlan.

oh.. i can't prove that these 93,456 formulas are correct-- so let me
write another 245,234 formulas to test it

are you friggin kidding me?

i write a dozen formulas per query.
maybe even just 3 or 4 per query.

i never write the same formula twice-- if it's something i reuse i will
write it as a UDF and then i can use it all the time without breaking
my wrist in copying and pasting.
when i change the formula-- i only need to change it in one place.

what do you do.. email spreadsheets around?
with macros?

about the worst thing you could possibly do; from a performance
standpoint.

it's all about manageability.


I can audit my data with formulas; but i dont have to write a different
formula for each cell

i mean what a fucking waste of time kids

-Aaron


PS -- does this allow you to prevent numeric fields?
Which is why you should use validation formulas. If no cells in some
range (RNG, say) should contain strings, use a validation formula like
=COUNTIF(RNG,"*")=0.

Does this prevent you from putting a value in a cell that is negative?

you can't REACT to changes in data.

you can sit there and look for them; like a bunch of drunk retards
but you can't REACT to changes in data.

it is EASY for me to send an email when a record in a db changes.

it is EASY for me to send an email when data is missing.

you have to sit around and wait for the data.. and you sit there and
count your clock-- look for the data-- count the clock; check your
email; look for the data.

i can script through long-running jobs and preprocess numbers at night.

i produce more value to my company by 2am every day-- then you do in a
month.

i can schedule my jobs.. can you?

-Aaron

.