GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2010-11 > 1289930035


From: Robert Stafford <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Tue, 16 Nov 2010 11:53:55 -0600
References: <BFECJOAEEPCFBFFLLBGPGEFJHJAA.dna@irishtype3dna.org><B0A97FB027D64C6AB00E3AEF55659BDF@julief20dec08><000e01cb83fd$2b6e3b00$824ab100$@dgmweb.net><13181D0609FD4C3C9A1BA249F93D0F45@julief20dec08><AANLkTim_iV6PBrGVfJbx3t0WbGQYXH41ufmiMFSV-at_@mail.gmail.com><6F0B68B380A8435A9590AD32DEA3D24C@julief20dec08>
In-Reply-To: <6F0B68B380A8435A9590AD32DEA3D24C@julief20dec08>


Once people have set up a formatted spreadsheet with the the multi-copy
markers in separate columns, the following method will save a few steps. It
will work for both public and GAP pages. It saves the formatting. This is
for Excel 2003 and later. All except step 2a should work on other
spreadsheets.

1. Open a copy of a formatted spreadsheet (multi-copy markers in separate
column). Save it under a different name, so as not to accidentally overwrite
the file. Delete all the data except the headings.

2a. Import the results chart from the public pages to another (blank)
worksheet [data, from web, options, select disable date recognition, OK,
select the pointer next to the chart, import]. Save the worksheet as a .csv
file. (This will change the default for the workbook, so do a save as Excel
workbook, if doing everything in one workbook.)
or
2b. From the GAP page, save the chart as a .csv file.

3. Import the .csv to another (blank) worksheet [data, from text,select
delimited, next, select delimiters "," and other "-" , next, select general,
finish.]

4.Copy the data rows and paste to the worksheet created in step 1.

People can compress the spreadsheet by making the heading row distributed
and setting the column width to put DYS on top and the number on bottom. If
small letters are not used for multi-copy markers, they can center the
heading over the copies.

Bob Stafford


This thread: