Re: why>?

I'm talking about bigints you fucktard
bigint Integer data from -2^63 through 2^63-1


bigint; close enough to a google that i'll never need to go that high..

damn spread*** kids probbaly don't even know why im talking about a
search engine when it comes to data types


'oh but i have to use 9 points of precision because we balance against
the euro market every night and i have to copy and paste all these
formulas around'

gag--

fucking idiots

get off your high horse kid learn some real tools


Re:
As for formulas, it takes work, but it involves writing cell formulas
to text files in R1C1 addressing syntax, grouping cells that should
contain the same formulas, and verifying that the formulas are in fact
identical. That just proves consistency. The next and final step is
checking that each distinct formula does what it should. That can be
tedious for very long formulas, but not impossible.


All i have to do is check the formula once per column.
you have to check it once per cell.

that is why you spend all your time jerking off; validating
spreadsheets.
and i spend my time kicking back on the beach and not stressing about
the 65,535 row limit


re
It takes VBA, specifically, [***]Change event handlers and validation

formulas. Neither prevent invalid entries up front, only catch them and

reverse them once made. Note that spreadsheets aren't unique in lacking

transaction capabilities that databases provide. That is a strength of
databases relative to spreadsheets. However, transactions don't prevent

all errors.

I'll just disable macros and you won't be able to do a damn thing about
it.

or if you use excels' data type validation i will just copy and paste
values to get around that.



piece of *** ass program kids


a) i take more source data
b) more variables
c) more dimensions
d) more measures
e) more output
f) more automated
g) easier

i can schedule a transfer of data from one db to another in about 2
lines of code... or in about 5 seconds with a wizard.

where do you want to go today?

.