[ExI] standard form for creating a test, was: RE: humanities plus schmooze

[Mike Dougherty]

On Sun, Dec 9, 2012 at 12:13 PM, spike <spike66 at att.net> wrote:
> Agreed that I am the poster child for Excel abuse.  What I was doing was a
> brute force Scrabble player.  I found a list of English words, eliminated
> all which have more than 15 letters, and found that with those gone, there
> are 354938 words left.  I got the code to work, but it was still a practical
> failure at Scrabble because that list contained too many words that would
> piss off one's opponent if you played them.  For instance, starting at the
> top:

You really should learn SQL.  This "set of all permutations of
letters" transformed with "set of all scrabble titles" is exactly
how/why SQL works.  Most people need to be taught to think in sets,
you're doing it natively and forcing Excel to keep up with you.

> But I agree this is a classic case of Excel abuse.

haha