"Mike Nolan" wrote in message
...
(Hal Terrie) writes:

There was a change made last summer to how the ratings field was
formatted,
but that affected the monthly updates as well as the Gold Master, since
the same program prepares both files.

Matt, have you updated your player database since August?

I've updated my system religiously since I purchased the WinTD program for
my laptop in December 2002.

I replaced my old TARATSUP.DBF (the Dec 2003 Golden database) with the Feb
2004 one, so I think I've erased all my other supplements as well, although
they're stored in a separate folder. Any suggestions on how I can fix this
after I download the WinTD patch from Estima?

Regards,

Matt

"Matt Nemmers" writes:

I replaced my old TARATSUP.DBF (the Dec 2003 Golden database) with the Feb
2004 one, so I think I've erased all my other supplements as well, although
they're stored in a separate folder. Any suggestions on how I can fix this
after I download the WinTD patch from Estima?

I've never used WinTD and don't even have a demo copy of it here. Tom
Doan posted a response, perhaps that will answer your question.
--
Mike Nolan

On 14 Mar 2004 16:39:26 GMT, (Mike Nolan) wrote:

I'd like to add two fields, the member's birthday (mm/dd only) and the
first 3 digits of the zip code. Adding those fields takes us from having
nearly 14,000 names that occur in our database more than once (FN+LN
matching exactly) to having around 600 where the name, birthday and
3 digit zip code all match.

Privacy concerns (eg, COPA) may keep us from providing either the full
birthdate or the membership type. Adding full birthdate and membership
type reduces the multiple record count to around 400, so it might not
add much value.
--
Mike Nolan

I believe that a lot of people are concerned with having their
birthdate made public.

However, if you just provided the month and the day but not the year,
I doubt there would be objection.

Perhaps better yet, if you just provided the day of the month but not
the month or the year that would be enough to find most duplicates.
So, since I was born on September 7, 1944 you would just say that I
was born on 7. It will be rare for two players to have the same name
and the same day of birth, and I think that nobody will object, not
even Jerry Bibuld or Arden Van Upp.

Sam Sloan

(Sam Sloan) writes:

However, if you just provided the month and the day but not the year,
I doubt there would be objection.

I've heard some.

Perhaps better yet, if you just provided the day of the month but not
the month or the year that would be enough to find most duplicates.

There were around 14,000 names that had multiple instances, though
that doesn't include 'similar' names. (Ie, 'John Jones' was considered
different than 'Johnny Jones').

Adding DD to the check for duplications drops that count to 3100, adding
MM/DD drops it to 2500.

Adding just the 1st three digits of the zip code takes the count to about
1275. Using the two letter state code instead of the 3 digit zip takes
the count to about 3000.

DD + 3 digit zip reduces the count to under 600, MM/DD + 3 digit zip
drops the count by only another dozen or so.

DD plus state gives around 950 instances, MM/DD plus state is around 900.

Based on that, it would seem that if there is significant objection to
providing mm/dd, providing just the day of the month would have almost
the same effect, especially if combined with the 1st three digits of
the zip code.
--
Mike Nolan

(Mike Nolan) writes:
Based on that, it would seem that if there is significant objection to
providing mm/dd, providing just the day of the month would have almost
the same effect, especially if combined with the 1st three digits of
the zip code.

How about the full zip code but no birthday?

I would like to see the membership type and perhaps city. Some people
have asked about zip, but as I rarely carry a zip code directory, having
the city available might do more to discriminate between the 22.7 John
Smiths in any given state.
Regards, Ernie

Mike Nolan wrote:


I'd like to add two fields, the member's birthday (mm/dd only) and the
first 3 digits of the zip code. Adding those fields takes us from having
nearly 14,000 names that occur in our database more than once (FN+LN
matching exactly) to having around 600 where the name, birthday and
3 digit zip code all match.

Privacy concerns (eg, COPA) may keep us from providing either the full
birthdate or the membership type. Adding full birthdate and membership
type reduces the multiple record count to around 400, so it might not
add much value.
--
Mike Nolan

Ernie Schlich writes:

I would like to see the membership type and perhaps city. Some people
have asked about zip, but as I rarely carry a zip code directory, having
the city available might do more to discriminate between the 22.7 John
Smiths in any given state.

The single most common name is actually Michael Smith, with 114 instances.

There are only 49 John Smiths, though that doesn't count variations on the
name like Jonathan (27), Jon(7), and Jack (10), nor does it count
variations on Michael like Mike (17). I also didn't try to extract any
middle names or consider first initials.

There are more Willian Smith's (66) and Robert Smith's (81) than
John Smith's, too. :-)

Providing the city could raise the same issue of too much specificity
as the five digit zip code, and it takes more space to store, thus it
makes for a larger file on the website to download and a larger file
on your computer.

I don't know if we can provide membership type because it identifies
members who are under 14, which raises issues of COPA compliance.

If I understand the language in COPA, we may be able to publish the
membership type or even the age in the rating supplement, we just can't
make that information available on our website. We may be uncomfortably
close to the line, if and when they get around to drawing one, by having
crosstables of scholastic events available on the website.
--
Mike Nolan

"Mike Nolan" wrote in message
...

The single most common name is actually Michael Smith, with 114 instances.

There are only 49 John Smiths, though that doesn't count variations on the
name like Jonathan (27), Jon(7), and Jack (10), nor does it count
variations on Michael like Mike (17). I also didn't try to extract any
middle names or consider first initials.

There are more Willian Smith's (66) and Robert Smith's (81) than
John Smith's, too. :-)

Did you ever run across a guy named Snuffy Smith?

StanB

"StanB" writes:

Did you ever run across a guy named Snuffy Smith?

No, I swerved and missed him. He was hit by the taxicab behind me.
--
Mike Nolan

"StanB" wrote
Did you ever run across a guy named Snuffy Smith?

Geez, talk about dating yourself! (Er, agewise, not Jane Addams/Tom Klem wise)