GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2010-11 > 1289763229


From: Margaret Jordan <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 19:33:49 +0000
References: <AANLkTimj97iQ7=b8NwvaadBqfHQLdg3K8Nt32bXWr4JL@mail.gmail.com><545042.66236.qm@web53403.mail.re2.yahoo.com>
In-Reply-To: <545042.66236.qm@web53403.mail.re2.yahoo.com>


I manage a large project (nearly 4,000 members) and I found it very
convenient to be able to download the entire spreadsheet from FTDNA. Now
I cannot do that directly although FTDNA claims to offer "download
spreadsheet" as an option. What they are offering is in fact a download
to an XHML webpage which is cumbersome to open and it is not a
spreadsheet. I have found a work around (as have many of the posters
here) but that does not feel like progress. It is more work.

Secondly, the placing of multi-copy markers in one cell does not help
with analysing the data so this doesn't feel like progress either.

Regards,
Margaret Jordan

On 14/11/2010 19:12, Nancy Kiser wrote:
> I have been manually updating the Excel spreadsheets for my projects for years,
> and this includes my Phillips project that has almost 500 participants. I have
> been doing it manually because we also accept results from companies other than
> FTDNA and it was too much trouble to have to re-add the results of 30 or 40
> non-FTDNA tested participants every time we updated the spreadsheets downloaded
> from FTDNA. Manually adding the results of one or two participants every week
> or so is not that big of a deal. I am now really glad that I have updated
> spreadsheets on my computer that have separate columns for the multi-copy
> markers.
>
> Nancy
>
>
> ----- Original Message ----
> From: Mark Jost<>
> To:
> Sent: Sun, November 14, 2010 11:53:26 AM
> Subject: Re: [DNA] New FTDNA Project Format
>
> As the amateur I am, I have been playing around with a workaround method to
> assist converting Multi-Copy (MC) markers concatenated to decatenate
> spreadsheet columns that are displaying both actual hyphenated markers and
> when some of those same type MC markers that appear as real Calendar Dates
> for those who wish to copy and paste a public projects results into a Excel
> spreadsheet. If something does not work, maybe some Excel experts can help
> out.
>
> This sheet can be then be manually updated with new members as needed.
>
>
>
>
> -------------------------------
> To unsubscribe from the list, please send an email to with the word 'unsubscribe' without the quotes in the subject and the body of the message
>


This thread: