Maximum Number of Sheets

[Jay Petrulis]

ok so show me people that don't have the last name Johnson or Jones.

2 clicks in Access.

Right-click EXCLUDE followed by Right-click EXCLUDE

Autofilter>Custom>DoesNotEqual (Johnson) AND DoesNotEqual (Jones)>OK.
Again, not as easy as in Access, but not too terribly difficult,
either. Additional exclusions would require another approach (advanced
Filter, VBA)

How about this one for you...multiply two matrices together.

 

[Harlan Grove]

(e-mail address removed) wrote...

ok so show me people that don't have the last name Johnson or Jones.

2 clicks in Access.

Right-click EXCLUDE followed by Right-click EXCLUDE

FTHOI, how would you EXCLUDE all names containing Smith, so not only
Smith itself, but also Smithson, Barry-Smith, Blacksmith (case
insensitive, too)? In Excel, choose Custom from the autofilter
dropdown, select 'does not contain' and enter Smith (or smith). How
would you manage that in Access without a query or having to locate all
matching names manually in order to exclude them?

 

[dbahooker]

how about this one:

a) have one matrix.
b) keep it secure

Excel is inherently an insecure solution.

Idiots like you is why Identity Thieves have a heyday-- because idiots
like you keep hundreds of copies of the same data lying around.

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

how about this one:

a) have one matrix.
b) keep it secure

....

And if you're so incompetent you can't figure out how to do anything
with that matrix, then it's even more secure still.

So much for your definition of 'security'.

Problem is that matrices like representations of stress tensors are
varying continuously. There's no ONE matrix. In realistic simulations,
there could be several BILLION different matrices. When they need to be
transformed by multiplying against possibly several billion other
matrices, would you be trying to cache the several quadrillion possible
results in a database?

You have no clue how anyone would use a matrix, do you?

 

[aaron.kempf]

its' multidimensional data.

big friggin deal.

i can generate matrices with cartesianing.. any day i want

 

[Jay Petrulis]

its' multidimensional data.

big friggin deal.

i can generate matrices with cartesianing.. any day i want

So "want" to do it today with a small matrix.

Unskilled, Unaware, Incompetent...Lemon Juice!

 

[Harlan Grove]

(e-mail address removed) wrote...

its' multidimensional data. ....
i can generate matrices with cartesianing.. any day i want

Possibly, but can you perform any matrix arithmetic operations with
them?

Lets assume you have 2 matrices in normalized form,

Matrix A
Row__Col__Val
_1_____1___1
_1_____2__ -2
_1_____3___3
_2_____1__ -4
_2_____2___5
_2_____3__ -6

Matrix B
Row__Col_____Val
_1_____1_______1
_1_____2______20
_1_____3_____300
_1_____4____4000
_2_____1_______5
_2_____2______60
_2_____3_____700
_2_____4____8000
_3_____1___10000
_3_____2____2000
_3_____3_____300
_3_____4______40

Then produce matrix C = A * B (note that matrix multiplication isn't
commutative).

Matrix C
Row____Col____Val
_1_______1__29991
_1_______2___5900
_1_______3___ -470
_1_______4_ -11880
_2_______1_ -59979
_2_______2_ -11780
_2_______3___1580
_2_______4__23760

You have to ensure that matrices A and B are matrices, i.e., there are
the same number of Col values for each Row value and vice versa, and
both Row and Col values are sequential integers beginning with 1. Next
you have to ensure that they conform, meansing the number of columns in
A must equal the number of rows in B. Finally you have to calculate the
values in C. For example, C's Row 1 Col 1 Val is given by

1 * 1 + -2 * 5 + 3 * 10000

That should be enough for you to write an inner join query involving
SUM(A.Val * B.Val). You may even be able to write one query that could
handle any pair of conforming matrices. Checking whether arbitrary
tables were matrices, and whether two matrices in specified order
conform would be a bit harder. And even when you've done this, all
you'd have is several queries that perform the same task as a SINGLE
Excel function call.

Databases are simpler for this?

 

[Jay Petrulis]

(e-mail address removed) wrote...

Possibly, but can you perform any matrix arithmetic operations with
them?

Lets assume you have 2 matrices in normalized form,

Matrix A
Row__Col__Val
_1_____1___1
_1_____2__ -2
_1_____3___3
_2_____1__ -4
_2_____2___5
_2_____3__ -6

Matrix B
Row__Col_____Val
_1_____1_______1
_1_____2______20
_1_____3_____300
_1_____4____4000
_2_____1_______5
_2_____2______60
_2_____3_____700
_2_____4____8000
_3_____1___10000
_3_____2____2000
_3_____3_____300
_3_____4______40

Then produce matrix C = A * B (note that matrix multiplication isn't
commutative).

Matrix C
Row____Col____Val
_1_______1__29991
_1_______2___5900
_1_______3___ -470
_1_______4_ -11880
_2_______1_ -59979
_2_______2_ -11780
_2_______3___1580
_2_______4__23760

Databases are simpler for this?

Harlan, have you not followed the "conversations" in various Aaron
Kempf threads today? From the sorting thread, you should know that
basically all the data points should be in a single column/field.
Sheesh, putting a matrix in a matrix! What crazy talk.

Databases are simpler for everything. Do you discount what Aaron says?

 

[aaron.kempf]

seriously Jay

how do you enforce datatypes in Excel?

so that disabling macros and copy / paste still follows these rules??

please tell me buddy; I'm dying to here.

In access / SQL; it's SIMPLE. Just choose a datatype. DATE for
example.

you broken idiot monkeys keep on using Excel for data entry
you get stuck with mountains of unclean data.. and then you have to
bring in a real programmer to sort it out.

Why dont you kids NEED real dataType validation?

I mean I know you guys use Excel for data entry..

you keep your little checklists and to-do lists and all that crap it
just makes me sick

-Aaron

 

[Jay Petrulis]

seriously Jay

how do you enforce datatypes in Excel?

so that disabling macros and copy / paste still follows these rules??

please tell me buddy; I'm dying to here.

Harlan has offered workarounds for after-the-fact data validation.
Nobody disagrees with you that databases do this much better than
spreadsheets.

seriously Aaron

How do you invert a matrix in a database? Multiply two matrices?
How do you create a loan amortization schedule?

Please tell me.

In access / SQL; it's SIMPLE. Just choose a datatype. DATE for
example.

In Excel, I would use the native MMULT function to multiply the
matrices, nesting a TRANSPOSE call if one needed to be reshaped (not
sure that reshaped is the proper term, but you don't have a clue what I
am saying, anyway).

It's SIMPLE. Just select the two matrices as arguments to the
function.

you broken idiot monkeys keep on using Excel for data entry
you get stuck with mountains of unclean data.. and then you have to
bring in a real programmer to sort it out.

You live in a castle in the sky, don't you? Define "mountains of
unclean data." How much is truly unworkable? Do you consider yourself
a real programmer (hint: think lemon juice).

Why dont you kids NEED real dataType validation?

I mean I know you guys use Excel for data entry..

you keep your little checklists and to-do lists and all that crap it
just makes me sick

-Aaron

Why do you care so much about what spreadsheet users do? In my case, I
will never need to hire you to come in and clean up, so you can take
your crusade elsewhere if you think your newsgroup terrorism will
impact what I do. This back and forth is fun, but it's getting boring
because you don't troll very creatively.

I cannot imagine a single sane person, no matter how bad their data is,
who will hire you. I cannot fathom that it will ever get that bad.
You *have* to be a last resort.

 

[aaron.kempf]

Macros?

Macros are a security risk in Excel.. but not in ACCESS asshole

For starters, you can't email Access Apps around.

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

Macros?

Macros are a security risk in Excel.. but not in ACCESS asshole

For starters, you can't email Access Apps around.

ADPs and MDBs can't contain VBA modules?

MDBs (and even ADB files as interfaces to database servers) can't be
attached to e-mails?

Do you ever understand what you're talking about?

 

[aaron.kempf]

ADP and MDB support VBA modules.
BUT THEY'RE NOT AS DANGEROUS AS EXCEL VBA.

I've posted several articles in the past few months that state WHY this
is true. Effectively, Excel and Word are designed to keep most of the
macros in a common file-- like normal.dot for example. Access is more
secure because it doesn't do this. Library databases are a similiar
discussion.. and of course you can use multiple library databases... or
a DLL.

But the bottom line is that if I want to share business logic between
multiple apps? I keep it in a database.

And for the record?? the docmd object is why -- single handedly that
Access is 100 times more powerful than Excel.

in most popular email systems; MDB and ADP are prohibited extensions.
It _SHOULD_ be the same way with XLS and all other XLHELL extensions.
Even though ADP are tiny ass files-- there is no point in emailing them
around.

Do I understand what I'm talking about?? YES I DO.

 

[Harlan Grove]

(e-mail address removed) wrote...

ADP and MDB support VBA modules.
BUT THEY'RE NOT AS DANGEROUS AS EXCEL VBA.

I've posted several articles in the past few months that state WHY this
is true. Effectively, Excel and Word are designed to keep most of the
macros in a common file-- like normal.dot for example. Access is more
secure because it doesn't do this. Library databases are a similiar
discussion.. and of course you can use multiple library databases... or
a DLL.

In other words, there's no Access equivalent to Word's Normal.dot or
Excel's Personal.xls. OK, that may be true. It's also the case that
Access has no Open event similar to that of Excel. That would reduce
the frequency of running malicious code. However, once running, Access
VBA could do all the nasty things Excel VBA could.

in most popular email systems; MDB and ADP are prohibited extensions.

....

Name 'em and provide links to substantiate this claim. And do these
e-mail systems sniff into .zip or other compressed archive files to
check if they contain MDB or ADP files?

Lotus Notes is the #2 e-mail server in use, and it sends MDB files
without complaining.

Do I understand what I'm talking about?? YES I DO.

Perhaps, but you seem unable to provide any substantiation. Read that
this way: no, I won't just take your word for it. You have no
credibility.

 

[aaron.kempf]

yes.. almost every program in the world specifically pulls MDB and ADP
files from zipped files.

and yes.. Access does have an 'open event'

it's called an autoexec macro. It's just that this is based on the
APPLICATION c:\AaronLoves.ADP

instead of being based on the program MSACCESS.exe

lotus notes isn't even #2 from what I read

you mean in the enterprise? I was thinking.. sendmail; etc

ok maybe i'll give you a #2 on that..

yeah I bitched up a storm to Microsoft about how it was being blocked..
but when all is said and done? Im glad that they're secure.. hotmail
and exchange do strip these files for the most part.. Frequently when I
_MUST_ email one.. I send it to 2 or 3 different webmails and one of
them lets it through

I think that hotmail is CONSIDERABLY more popular than this silly lotus
notes.. right?

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

yes.. almost every program in the world specifically pulls MDB and ADP
files from zipped files.

Provide substantiation. That's certainly NOT the case for Lotus Notes
or, FWLIW, AOL.

and yes.. Access does have an 'open event'

....

If so, then there's the same security hole in Access that's in Excel.

yeah I bitched up a storm to Microsoft about how it was being blocked..
but when all is said and done? Im glad that they're secure.. hotmail
and exchange do strip these files for the most part.. Frequently when I
_MUST_ email one.. I send it to 2 or 3 different webmails and one of
them lets it through

All you'd need to do is change the extension to something else and zip
it. Or zip it, change the extension on that zip file then zip the
renamed zip file.

I think that hotmail is CONSIDERABLY more popular than this silly lotus
notes.. right?

For businesses? What medium to large company uses hotmail for corporate
e-mail?

 

[aaron.kempf]

nope i can't change the extension to get past it in hotmail and
exchange.. it doesn't work.

i can't zip.. change the extension.. none of the above.

it's not my fault that IBM and AOL don't follow Microsoft's best
practices for security.

I'd love to be able to email ADP files-- MDB files i dont give a rats'
ass about.

I am pretty darn sure that Microsoft screens stuff based on the
MimeType of the document.. and changing the extension doesn't change
the mimetype.

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

nope i can't change the extension to get past it in hotmail and
exchange.. it doesn't work.

Changing the extension alone was a long shot.

i can't zip.. change the extension.. none of the above.

....

Likely you could uuencode, pass the result through binhex, and then
zip.

it's not my fault that IBM and AOL don't follow Microsoft's best
practices for security.

....

Security? Provided by either Exchange or Hotmail? Do you believe none
of the worms, trojans, visuses and other asorted malware that have
spread from Windows machine to Windows machine ever passed through
Exchange servers, and none has ever been sent from a Hotmail account?
Seriously?

I am pretty darn sure that Microsoft screens stuff based on the
MimeType of the document.. and changing the extension doesn't change
the mimetype.

It may check the file's magic number before attaching it.

 

[dbahooker]

yeah.. i think that hotmail and exchange do a WONDERFUL job at securing
their email.

I think that Microsoft has done a terrific job these past 5 years in
cracking down.

-Aaron

 

[Harlan Grove]

(e-mail address removed) wrote...

yeah.. i think that hotmail and exchange do a WONDERFUL job at securing
their email.

I think that Microsoft has done a terrific job these past 5 years in
cracking down.

....

So all the reports of Windows malware infestation and propagation via
e-mail over the last 5 years was faked?

And I thought you could diminish your credibility any further. Silly me!