Re: why>?

when you use formulas to validate entries; what are you comparing
against..
A DATABASE?

grow some balls and start using LOGICAL SIMPLE STRUCTURES instead of
dozens and dozens of spaghetti code spreadsheeets.

can you leverage 10,000 spreadsheets into something valuable?

NOT IF YOUR LIFE DEPENDED ON IT.

simple transformations?

I can transform in a Select query-- so that i dont even need to make a
duplicate copy of the data.

the way that you transform is that you copy and paste the data and then
manually copy and paste some changes.

it's a SHITTY way to work Harlan.

you CAN'T AUTOMATE excel like i can automate SQL. I mean--- don't you
even fucking try to compare the 2.

for starters, MSDE comes with a full job scheduler.

Windows-- your desktop-- the basic task scheduler is a piece of ***;
and it doesn't work for half of the things that you need it to do.

real quick.

have a spread*** open up and refresh a couple of named ranges... and
SEND AN EMAIL IF IT FAILS.

you couldn't do that if your life depended on it.

have a spread*** open up and refresh a couple of named ranges... and
SEND AN NET SEND IF IT FAILS.

you couldn't do that if your life depended on it.

take a backup of a spread*** WHILE the spread*** is being changed.

you couldn't do that if your life depended on it.


make a copy of a spread*** 'without any data in it'

you couldn't do that if your life depended on it.


SORT A SPREAD*** BASED ON VARAIABLES AND CALCULATIONS
you have to go through and make a new column; add the formula and then
sort the whole work***.

this can frequently break other worksheets; so be careful lol

I can throw a different ORDER BY clause into a sql statement; and it
doesn't take DOUBLE the storage requirements.

if you want to sort worksheets in 2 different ways-- you need 2 copies
of the data.

that is the most laughable thing i've ever heard in my life.

Excel is for babies you kids are all drunken fools.

and you can all eat my dust.

One of these days; I'll build a time machine and go back to the 18th
century to see how you dipshits work.

copy and paste is the same as PEN AND PAPER

grow some balls kids and stop ripping on me for questioning-- get
this-- your abuse of your companies-- by spinning your wheels; jerking
off while you copy and paste the same data and formulas over and over.

you kids should be homeless; drunk on the side of the road 'oh why
didnt i learn a real reporting application'?

YOU HAVE BEEN OFFICIALLY WARNED.



Harlan Grove wrote:
aaron.kempf@xxxxxxxxx wrote...
you couldn't physically use formulas to VALIDATE other formulas if your
life depended on it.
...

Read carefully. I didn't mention formulas to validate formulas. It's
formulas to validate entries. Whether those entries are constants of
formulas is immaterial. Only their values matter. And, yes, formulas in
spreadsheets can be used to validate entries, both by ensuring proper
data types and reasonable ranges of values.

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.
...

Kinda pointless to use udfs for simple expression transformations,
e.g., bump up values by 5%, but that's inventory cost in one table,
sales price in another, and projected revenues in a third.

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

Neither do I. The beauty of [Ctrl]+[Enter].

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?

Now you're changing the specs, but still simple enough.

=SUMPRODUCT(COUNTIF("Rng",{"*","<=0"}))=0

you can't REACT to changes in data.
...

You may not be able to outside databases. Doesn't mean no one else
does.

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.
...

E-mail being pointless if input is manual, as it often is in
spreadsheets. Simpler to use formulas to display warning and error
messages telling the user what's wrong and how to correct the invalid
entries.

you have to sit around and wait for the data.. . . .
...

True, if you mean wait for the user to enter something. That's just how
spreadsheets work. But simple enough to react immediately after entry.

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

Big deal. So can I. So can anyone who knows how to automate the
software they use.

i can schedule my jobs.. can you?

Manual data entry, no. Complex simulation modeling, yes, even including
pulling data from electronic sources (even databases) during execution.

.