Project Administrator Guide
 

See also our Administrator Information page for more resources on project administration.

Note: This guide has been written for Surname Project Administrators who are managing a Family Tree DNA project on free websites provided by WorldFamilies.net.  However, any Administrator may use this information to help them run their project on any website - at any testing company.  If you are project admin and need a website for your project, let us know. 
(Contact Terry Barton for more information.)

You can choose to do all of these tasks right away, or start by doing some of them and adding more as you can confidence.  It takes all of these functions to successfully manage your project, which may lead you to recruit a co-administrator to share the tasks. We give you detailed instructions about posting on the website, sending welcome letters, and answering questions, and we will be available to assist when you need help
 

We have provided tools to help you manage your project:

1        Steps to Managing A Successful Surname Project                                

2        Questions Frequently Asked of Project Admin.

3        Editing your website with SiteBuilder   (Problems logging in?)

4        Posting pedigrees    (Problems posting?)

5        Posting the results     (Problems posting?)

First, an explanation of the policies of Worldfamilies.net: 

We provide this site as a service to you, the Surname DNA Project and to the whole Genetic Genealogy community.  We expect it to be used only to support the project and any group(s) that are engaged in supporting the project.  You may list books or other articles for sale that relate directly to this Surname Project and solicit donations to support this Surname Project.  No other commercial activity is allowed without prior written permission.  We ask that you be responsible and honest in all your postings and that you respect the expectations of privacy of your project members, or specifically obtain their okay to divulge their personal information.  As a reference, FTDNA lists kit number, last name and marker results in their public site.  We consider it okay to post that information without approval.  World Families Network has a business arrangement with Family Tree DNA and we request that you respect both WFN and FTDNA in whatever you post.  It is perfectly ok to post results of men tested at other testing companies.  We ask that you not place links to other testing companies.  Please let us know if you reach the point where you will no longer be involved, so we can find a replacement.

We reserve the right to edit offending material and/or to suspend or terminate your use of this site for failing to honor these expectations. 

We hope that leading your surname dna project will be personally rewarding for you and that it will further research and cooperation within your surname families.  And – we hope that all of the participants in your project make new friends and learn more about their ancestry.

[back to top]

Steps to Managing a Successful Surname DNA Project

 ·         Send a welcome message (email) to each new participant. (Sent to you as a separate .doc)

When a new member joins a project, Worldfamilies.net sends him or her a “Welcome Letter” email to explain our website and its resources and to assign that member a code identity to be used on the website. 

As an administrator, that is a function that you can easily assume and will probably want to do as a way of making contact with your project members.  We have a standard form that we use, which we are sending to you as a separate attachment.  You should feel free to change it or to create your own welcome letter.  Once you are listed as an administrator at Family Tree DNA, you will be receiving notices from them anytime a new member joins your project. 
 

Follow up with participants or interested family members. 

o        Encourage anyone who has posted a pedigree to get a family member tested.

o        Encourage anyone who has been tested to post the family pedigree on the Pedigree Forum.

o        Encourage members to upgrade their tests as needed to understand their matches and potential matches.

Recruit new members for your project.

o        Post awareness messages on family forums and boards (avoid mentioning cost and testing company)

o        Recruit representatives of specific families that are important to your family project

o        Recruit the key researchers who have their own network of contacts and may become line leaders

o        Bring in family associations and societies and get them involved (i.e. sponsorships, links & info on their websites, etc.)

o        Recruit a co-administrator – ideally, someone with different contacts and skills who is easy to work with.  This will make your job so much easier!

Respond to queries from project members or potential project members.

(Questions frequently asked of administrators, pages 3-5)

We have included “Frequently Asked Questions” to assist you in answering the most repetitive questions.

Advise project members of project's progress when something significant occurs

o        Email members to let them know you have posted new test results

o        Explain individual results

o        Email members when you post new pedigrees.

Correlating the test results to the pedigrees

o        As you post pedigrees, check the Family Tree DNA GAP Member's page to see if that person has been tested.

o        If the pedigree correlates to a test, post the Project number of the test in red at the bottom of the pedigree on the Patriarch page.

o        If the pedigree family is not represented by a dna test, encourage them to locate a male family member and have him yDNA tested.

 [back to top]

Questions Frequently Asked of the Project Administrator

You can always direct your participant to our homepage (http://www.worldfamilies.net/), where there is a wealth of information down the left side of the page.  Here are some answers that we usually give to these commonly asked questions.

1. What is a Surname DNA project?

A surname DNA project is a focused effort within a surname and its spelling variations, which works to find how families are (and are not) genetically connected.  The test uses DNA from a man's y-chromosome to identify genetic markers, which have been passed from Father to Son. Most of the time, an exact copy of the father's yDNA used for Surname testing is passed to the son, but mutations sometimes occur, giving us the ability to use this science in genealogy. Based on the matches and differences in these markers that occur between individuals, probabilities of relationship to a common male ancestor can be made and genetic families can be identified. Since the focus of Surname DNA testing is on the common early ancestors, most Surname Projects identify test participants by their earliest known ancestor of that surname. 

 2. Why should I join a Family Surname Project?

A surname yDNA test is useful in determining if you share your surname male ancestry with another man (men) who has been tested.  By comparing your paper trails, you can learn more about your ancestry.  Working within the surname group assures that you are comparing yourself with other men of your surname (and its variations).  Another advantage is that by joining such a group, you qualify for a reduced testing fee.

 3.  How do I join the project?

You join the project by ordering a dna test at FTDNA through the project, by posting your family pedigree on the www.WFNForum.net  Pedigree Forum, or by transferring your result into the surname project at Family Tree DNA. 

4.  I was tested in the National Geographic Genographic Project.  How do I join the surname project?

You can transfer yourself, your results and your retained sample to Family Tree DNA.  Go to your NGGP page and look towards the bottom for a small link called "Learn More".  Click through the links and eventually you'll join Family Tree DNA.  Once you have done that, you'll be able to join the project, which includes all various spellings. 

5.  I've already been tested at FTDNA.  How do I join the project?

In your FTDNA page is a blue button labeled "join".  Click on that button, then select the surname, then select a second gray join button, which is lower on the page.  Or, you can call or email FTDNA and ask them to transfer you into the project. 

6.  I was tested at another company.  Can I join your project?

We will post your results if you submit them in the table we provide.  We require that you provide your earliest known ancestor and pedigree.

The basic $99 test tells you your deep ancestry (called Haplogroup - think 1,000s and 10,000s of years).  The haplogroup will give you an idea of the migrations of your ancestral family from earliest times and can confirm Native American, African or Jewish ancestry.

In addition, you can identify families that do not share a recent common ancestor with you and can usually confirm clear paper trails.  It will also provide an indication of the families who may share a recent common ancestor with you.

A 12 marker test is insufficient for broad genealogical purposes, for confirming relationship to families where there is no connecting paper trail, or confirming relations with different surnames.  These goals require more markers. 

8.  How many markers should I use?

Use as many markers as you can comfortably afford.  Generally, we recommend starting with either 25 or 37 markers as a trade-off between cost and information.  (If cost is a major issue, you can start with 12 markers and upgrade in steps.)  If you know the surname you should match, you can probably get by with 25 markers. If you are trying to match to a different surname without a paper trail – you will need 37 markers.   Most researchers who are serious about their genealogy have ended up with at least 37 markers – and many are now increasing to 67 markers.

9.  My ancestors are all long dead.  How do I get their DNA?

You don't!  DNA tests are taken from the living, who represent their direct ancestors.   To find the yDNA of a male ancestor, you test a man whose father's father's … father is the ancestor of your interest.  To find the mtDNA of a female ancestor, you test a person whose mother's mother's … mother is the ancestor of your interest.

10.  I'm a female.  Can I be tested?

Yes.  Mitochondrial DNA (mtDNA) looks at the DNA that both women and men inherit from their mother's side.  A mother passes her mtDNA to her children, but only females can pass it on.  This represents the mother's mother's…mother's maternal line.  Your mtDNA result can be compared with another person's mtDNA to see if you share a common female ancestor.  Anyone can take this test. 

mtDNA tests the deep maternal ancestry (think 1000s of years)  As mtDNA mutates very slowly, it becomes a link to your distant past - giving you the mtDNA of your mother's mother's ... mother's line.  By testing, you learn your haplogroup – which tells you which "branch of woman" you descend from on your maternal side.   In addition to learning your Haplogroup, you'll be told of the mutations that are present.  These allow you the possibility of locating those with whom you share a maternal heritage.  Often, this is too far in the past to be able to link paper trails, but a number of folks have started mtDNA projects to increase the learning.  I have a lot of hope for the potential.  Sites with info about mtDNA:

http://www.familytreedna.com/cj.asp?ftdna_ref=118&html=description.html#mtDNA  
http://worldfamilies.net/mtDNA.htm  
http://worldfamilies.net/understand_mtdna.htm

Additionally, you can sponsor a male from your surname family of interest.  This allows you to participate in your ancestral surname DNA project.  Surname DNA (yDNA) looks at the DNA that a man inherits from his father's (paternal) side.  This represents his father's father's … father's line.  The y-chromosome (yDNA) results are compared with two or more men to see if they share a common male ancestor. 

11.  How much does it cost?

Testing cost varies.  If you know the surname you should match, you can probably get by with 25 markers.  We have noticed that most folks who are serious about their genealogy will end up with at least 37 markers and possibly 67.  If you are trying to match to a different surname without a paper trail – you will need at least 37 markers and will likely benefit from 67.  One approach is to start with as many markers as you can comfortably afford and then upgrade later, as the need arises.   You also have the possibility of going in steps, upgrading a bit at a time.  Prices:

Upgrades from one test to the next are $49.  (37 to 67 is a two step increase and is $99) 

12.  What kind of tests are available?

Surname DNA (yDNA) looks at the DNA that a man inherits from his father's (paternal) side.  This represents his father's father's … father's line.  The y-chromosome (yDNA) results are compared with two or more men to see if they share a common male ancestor. 

Mitochondrial DNA (mtDNA) looks at the DNA that either a man or woman inherits from the mother's side.  This represents the mother's mother's…mother's line.  The mitochondria result is compared to see if they share a common female ancestor.

13.  When should I expect my results back?

Figure on 2-3 months from the time you order your kit and you will be prepared for the wait.  It takes about 6 weeks after FTDNA receives the completed sample in Houston.  You can often order and have a kit returned in just over a week, but often kits sit for days or weeks at the participant's house before being returned. 

14.  How do I upgrade?

You can order an upgrade to your yDNA or mtDNA test by:

1. Going into your FTDNA Personal page
2. Looking toward the top right and locating “Order Tests” (and click on it)
3. Select “Standard Orders”
4. At the bottom of the page, click on the tab in the box called “Type of Test” to see the range of upgrade choices
5. Select the one you want, confirm your personal info and select method of payment
6. Click “Continue” and complete your order

You now have the option of ordering more than 67 yDNA markers, autosomal markers and X-str markers.  Click on “Advanced Order” instead of “Standard Order” for this option.

The Deep SNP test can be ordered by:

1. Go into your FTDNA Personal page
2. Open "Haplogroup"
3. Click on "Order your Y-DNA SNP test for Deep Sub-clades"
4. The cost for most folks is $79.  Depending on haplogroup, there may be small price differences)

15.  Which upgrade should I choose?

A part of the answer is “what can you afford”?  You can upgrade in small increments or do it at one time.  Who you match and what you know about them also affects the number of markers needed. 

• If you have a paper trail connecting you and another person and you match 24/25 or 25/25 - you can be relatively confident that you share that paper trail common ancestor.  This is true whether the man you match has your surname or not - as long as you can connect paper trails.  However, if your match is 23/25, you are in a gray zone and should consider upgrading to 37.
   
• If you have a match to a person of a different surname, you'll need to compare at 37 markers - using the 25 marker matches only as an indication of who is of potential interest.
   
• If you match at least 34/37, you can be reasonably confident that you share a common ancestor.  With a lesser match, you'll then want to compare at 67 markers.  That doesn't happen too often, but it can happen - particularly when comparing across surnames.
   
• If you are in a project and are in a group that matches and shares a common ancestor (we call this a “Lineage”), you'll want to upgrade to the same number of markers as the other men in the group, as you'll be looking to see if you can find closer kin within your Lineage.
   
• 67 markers are nice to have, and you can go straight there (saves a few dollars and some time over getting there in steps) and you'll be ready to do any comparison that comes along.  But it's ok to reach 67 in steps.  

16.  How do I upload my results to Y-Search from FTDNA?

Go into your personal page at FTDNA and click on “Y-DNA matches”, then look in the middle of the page - at the bottom of the box called "Additional possibilities for searching matches".  There is a link to "Click here to upload to www.Ysearch.org

17.  How do I fill out the order form?

The order form is in two parts that you can think of as pages.

• In the first page:
   
  • You list the name of the person being tested.  This is also the name that will be on the Certificate.
     
    • If you want the kit sent directly to the person being tested, list their address.
       
    • If you want the kit sent to you, list their name and then put c/o (your name) in the first address box and your regular mailing address in the second address box.)
       
  • Put your email address in the first position, as this is how you know what is happening.  (Be sure the person you sponsor includes your email address if they place the order themselves) 
     
    • You can list the test taker's email address as the additional address
       
  • If you want the kit sent to the person being tested, but the certificate sent to you, use this two step method
     
    • Set up the order with their name and mailing address
       
    • After the sample is returned and you are given the password to access their personal page at FTDNA, leave their name, but change the mailing address to c/o you and your address. 
       
• In the second page, you choose to pay by credit card or invoice.
   
  • If you pay by credit card - you're all done.
     
  • If you want to pay by check, you list your address in the second page so they can send you the invoice

18.  How do I test for Native American ancestry?

In order to test for Native American ancestry, you will need to have just the right connection between the ancestor you believe was Native American and the person being tested.

For a female Native American ancestor, you will use the mtDNA test.  You will need to locate a person whose mother's mother's ... mother is the targeted Native American.  If there is any male in the direct line between the person being tested and this ancestor, you will be testing some other ancestor's mtDNA and will not get what you seek.  mtDNA is passed from a mother to her children.  Men carry their mother's mtDNA, but cannot pass it on.

For a male Native American ancestor, you will use the yDNA test.  You will need to locate a man whose father's father's ... father is the targeted Native American.  If there is any female in the direct line between the man being tested and this ancestor, you will be testing some other ancestor's yDNA and will not get what you seek.  yDNA is passed from a father to his sons. Women do not carry yDNA at all.

19.  How do I test to prove my Jewish heritage?

In order to test for Jewish ancestry, you will need to have just the right connection between the ancestor you believe was Jewish and the person being tested.  As the Jewish tradition is handed down through the mother, you would first consider the mtDNA test, which tests your mother's mother's ... mother's maternal ancestry. 

For a male Jewish ancestor, you will use the yDNA test.  If there is any female in the direct line between the man being tested and this Jewish ancestor, you will be testing some other ancestor's yDNA and will not get what you seek.  yDNA is passed from a father to his sons. 

Here is a link to FTDNA's page on Jewish ancestry:

http://www.familytreedna.com/cj.asp?ftdna_ref=118&html=jgene.html

Here is what FTDNA has to say:

"Jewish ancestry is not an exact result.  By way of comparison we can see whether or not the direct line being tested is likely to be Jewish in origin.  We have the largest Jewish ancestry database of this kind.  This comparison is included on the recent ancestral origins page. 

There are 4 scenarios for individuals who think there may be Jewish origins: mainly matches who have listed Jewish origins (indicates probably of Jewish origins), some matches who have listed Jewish ancestry and some who have not (tougher to call, Bennett can help answer some of these questions), has matches, but not of Jewish origin (probably not Jewish in origin), or no matches at all.  The last case, means you're not matching anyone of Jewish origins when compared against the database, but you are also not matching anyone of non-Jewish origins.  This is a "wait and see" situation in most cases.

There is a Cohen Modal Haplotype that we automatically compare everyone against.  It is a 12 marker set of results.  If you match this haplotype we put a CMH badge on your personal page which is linked to information on what that means."

You can test through your surname project and then join the Jewish Heritage project after your results are returned.

[back to top] 

As Project Administrator of your surname DNA project, you can use the 6-page website to support and enhance your surname project.  By using SiteBuilder, you can add links to the Home Page, use the Discussion Page for information and discussion about the test results and the DNA project, use the Recruitment Page as a tool to get more people into your project, and use the Miscellaneous Page for announcements or anything else you can imagine that will help your project.  And of course, you will want to post pedigrees on the Patriarch Page and to post test results on the Results Page.

1. To log in as an editor on SiteBuilder, go to (our website is listed in the email)
2. Type or “copy and paste” your ID and password into the spaces provided there. (These were sent to you in the welcome email.)
3. As soon as you log in, you will be given the name of your project.  Click on that and you will be given a choice of “Contact Settings” (information about you – and where you change your email address) or “File Manager”.
4. Clicking on “File Manager” allows you to choose which page of your website you would like to edit. 
5. After selecting the web page you want, click on “Edit with Web Editor”.

·       Common problems with logging into SiteBuilder:

1. AOL users may be blocked from accessing SiteBuilder, as the site can't recognize the ID and password.  If this happens, try accessing our site through Internet Explorer or Mozilla's Firefox.  Firefox is free and can be downloaded at: http://www.mozilla.org/products/firefox/
2. If you can't get into SiteBuilder and are typing the password - try copying and pasting it.  It must be exact and is case sensitive.
3. MAC users sometimes report that they are unable to successfully use SiteBuilder to post their Results. We have learned that MAC users can access Sitebuilder using the Appleworks server Safari.  See if this works for you.  If you still have a problem, possibly you can use another computer or recruit a co-admin who can do the editing work.  Or – maybe we will have to do the posting and editing while you focus on managing the project.

 [back to top]  

Posting Pedigrees

 ·         Before you begin:

• To post pedigrees on the Patriarch Page of your website, make sure you have logged into SiteBuilder and have chosen the “File Manager”, then selected “pats.html” and clicked on “Edit with Web Editor”.
   
• Edit the pedigree as you post it, so that there are only four bits of information on each line, as we have realized that this approach allows clear identification of a family.  Additional details can be provided elsewhere  (If you are missing one or more of these, choose an important alternate fact to include).
   
  • Full name (or as much as you have)
     
  • Birth Date
     
  • Birth Place
     
  • Wife's name
  
   
• Do not post any names of persons whose birthdates are after 1910, as we try to protect the privacy of any living individuals
   
• This is the format we use for Worldfamilies.net, but you can choose any format and color scheme you wish. 
   

·         To Post the Pedigree:

• Go to your surname's Pedigree Forum to find the recent posting(s) that has not been posted to the Patriarch page.  Copy (control C) the posting from the Pedigree Forum, and then paste (control V) it onto the “pats.html” page in SiteBuilder.  (Try to keep all postings on the Patriarch Page in chronological order, based on the earliest ancestor of each family.  Watch for families who share an ancestor so that you can link pedigrees when appropriate)
   
• “Select” the entire posting by highlighting it by holding down the button on your mouse while you scroll over the material. While the material is highlighted:
   
  • Change the color of the text to teal by clicking on the “T” on the toolbar across the top of the page and selecting teal.
     
  • Change the type size to “x-small”.
     
  • Change the font to “Arial”
     
  • Choose the symbol for a “Insert/Remove Bulleted List” from the tool bar (just to the right of center on the tool bar: three lines with dark squares to the left of each).  This should give you a bullet symbol (a diamond) at the beginning of the first line.
     
• To indent each line after the first line;
   
  • Place your cursor at the end of the first line
     
  • Hit enter.  This will give you a second diamond just under the first.
     
  • Click on the symbol  “Increase Indent” (about a third of the way from the right on the toolbar: symbol is horizontal lines with an arrow pointing to right).
     
  • The curser on the screen will indent and a second bullet (a circle) will appear.  Cut and paste your second line to the right of this bullet.
     
  • Place your curser at the end of the second line.
     
  • Hit enter
     
  • This will give you a second circle just under the first circle
     
  • Click on the symbol “increase indentation”
     
  • The curser on the screen will indent and third bullet (a square) will appear.
     
  • Cut and paste the third line of your pedigree here.
     
  • Continue through the generations of the pedigree, stopping at a birthdate of no later than 1910.
     
  • Note:  if you have a pedigree with siblings listed, you will not “increase indent” with each one, as they are of the same generation and will have the same symbol.
     
  • As you post the pedigree, you may need to post an earlier generation after you have posted later generations:  To do this, do exactly the same steps, except instead of “Increase Indent” you will click on “Decrease Indent” (the symbol to the left of “Increase Indent” with arrow pointing left).
     
  • Go back to end of the first line, change the color of the text to black, type a dash, then type or paste the name and email address of the person who provided the pedigree. (The email address can be found by clicking on the envelope under the person's name.)  Change the @ to AT to help prevent spammers from “harvesting” email addresses from the site.)

Linking the Patriarch page to the Pedigree Forum. (Often there is more information given on the Pedigree Forum than can be posted on the Patriarch page.  It is helpful to provide a link from the posting on the Patriarch Page to the complete posting on the Pedigree Forum.)

• Go back to the Pedigree Forum Page, and copy (control C) the url (address) for the page.
   
• Return to the “pats.html” page in SiteBuilder, highlight the name of the earliest ancestor
   
• click on the globe symbol (Insert/Edit link) on the tool bar.
   
• Paste (Control V) the url from the Pedigree Forum page in the blank for url and click OK.
   
• Highlight the name again, click on the T symbol on the toolbar, change the color to dark gold (sometimes called “olive”), then bold it.

If you know the code identity of the member who is posting the pedigree, you can put it after the last line of the pedigree on the Patriarch page in bold red.  (If you learn it later, you'll want to add it, as it is the correlation of dna results to pedigrees is really important)

You can let your project member know his pedigree has been posted by clicking on “reply” at the bottom of his posting on the Pedigree Forum Page and posting a note to him, or sending him a personal email by clicking on the envelope symbol under his name.

Common Problems with Posting Pedigrees:

1. I can't find the symbol I'm looking for on the toolbar.

If you can't find the symbol on the toolbar for SiteBuilder that you are looking for, hold your curser on each symbol and words will appear to tell you what that symbol represents. (For example, holding your curser on the symbol that shows lines with an arrow pointing right will show you the words “Increase Indent”—a tool you will use on the Patriarch page.)

2. I made a mistake and I want to “undo” it.

If you haven't hit the “Submit Changes” button at the bottom of the page in SiteBuilder, just go up to the tool bar and click on the curved arrow pointing to the left. This will “undo” your last action.  You can click on the “undo” arrow as many times as you want to get back to the right page.

3. The pedigree posting on the Pedigree Forum is too long and has a different format than the Patriarch Page allows.

You can paste the entire posting from the Pedigree Forum onto the bottom of the page in SiteBuilder, and then cut and paste the parts you want into the correct format.  (Be sure to delete the information at the bottom of the page before you “submit changes”.)  To shorten postings, use standard abbreviations:  m (married) d (died) c (circa) and use state 2-letter abbreviations (GA, KY, etc).  You can also send the poster an email asking them to resubmit the pedigree is a more usable form.

  [back to top]

Posting Results

 General Recommendations:

Don't try to edit your results table in SiteBuilder at all, but delete the old table you have in SiteBuilder and replace it with a new table each time.   (from your Excel spreadsheet)

• Start with the Excel spreadsheet that I am providing you as an attachment, adding additional information and adjusting as you get more results.  In general, group together the men who share a match or a near match.  Color their results cells in a common color, and color each mutation with a contrasting color
   
• We recommend that you maintain an excel spreadsheet for your results - and that you save a copy on your computer. Each time you have an update, make all of your adjustments and corrections in it and when you have it "just right", save it.
   
• One of the standard problems with SiteBuilder is that it won't maintain the centering of marker numbers and scores.  You can select the cells in SiteBuilder that you want centered and then select the text center command and re-center them
   
• Once there are two men matching at the 25 or more level, WorldFamilies.net declares a “Lineage”. (You can see an example of a family with two Lineages, including a man who may be a part of one of the Lineages and men who don't yet have a match at the Wisinger project: www.worldfamilies.net/surnames/w/weisinger/results.html

Steps for Posting Results

• Posting Results requires that you work from three places:
   
  • The FTDNA Group Admin page (GAP), where you will get the results
     
  • The SiteBuilder page, (select “results.html” on the File Manager page)
     
  • Your own project results Excel Spreadsheet – which can be the one we just provided or one you have updated from prior times.
     
• To collect the new results, go to your FamilyTreeDNA group administrator page and select  “Generate Y-DNA Results (Classic Chart)”
   
• Then, select  “Copy & Paste”
   
• Each result will be entered on a single row.  (You can use the command “Insert” “Row” to create a new row where you need it)
   
• Copy and paste only the new information from the FTDNA results into the Excel spreadsheet.
   
• Once you have all of the results in your Excel spreadsheet, do a “back” command with your browser, which will leave you in a slightly different Group Admin page.  You can't successfully copy and paste results from this page into your excel spreadsheet, but you can check to see if any of your participants have listed an earliest known ancestor (EKA).  If they have, this will be listed in parentheses after the participant's name.  Select only the info inside the parenthesis, then copy it, select the cell to paste the info, and then paste it into the edit box.  (Note  - when you try to paste it directly into the cell, you may find it carries some disruptive formatting – but when you paste it into the box where you edit text, it works well.  (When there is no EKA, we shorten the listing to initials and surname.  Some admins will remove the participant's name entirely and put “EKA not provided” or a similar statement.)
   
• If you have completed all the edits and are satisfied with your Results table, this is a good time to save it.
   
• Select the entire table from your Excel spreadsheet, and copy it.
   
• Open your SiteBuilder “results.html” page, and paste the excel table over the old table that you see through SiteBuilder. (or you can delete the entire old table and then paste the new table in its place.)  Click on “Submit Changes”.
   
• Be sure to save your excel spreadsheet in the "Save as type" selection right below the "File name:" into 97-2000 & 5.0/95 Workbook.
   

Common Problems with Posting Results:

1.  It's hard to avoid mistakes when posting the test results to the website.

When posting Results into SiteBuilder, it works best to paste the results from the FTDNA GAP page into an Excel spreadsheet each time, and then copy and paste the Excel spreadsheet onto the Results page - completely replacing the prior results posting.   By saving the Excel spreadsheet into the 97-200 & 5.0/95 version, you will have a version that SiteBuilder will allow to hold formatting.   (If you try to copy and paste for an Excel 2000, 2002 or 2003 version, the formatting will not hold and you will have a mess)

2.  I'm not happy with the way my table looks when I open my Results page at my WorldFamilies.net site.

If you cannot find a way to post it to your satisfaction, you may save the excel spreadsheet and send it to me for pasting in place.

3.  I have some results from another company with a different number of markers, or I have test results for the 67 marker test. 

Let us know if you need a frame for 67 markers and we'll send it to you.  Or – let us know if you need a 48 or 76 marker frame, so that you can also show results tested by other companies. 

4.  I would like to post the results in my own style.

No problem.  Feel free to customize your frame to meet your project needs.  (We discourage putting the marker labels “horizontal” – as that really widens your table – disrupting viewing.)

5.  When I try to paste the “Earliest Known Ancestor” from the Family Tree page directly into the cell on the Excel Spreadsheet, it carries some disruptive formatting

If you will paste it into the box where you “edit text” near the top, it works well. 

6.  What do I do when there is no EKA (Earliest Known Ancestor)?

When there is no EKA, I shorten the listing to initials and surname.  (Some admins will remove the participant's name entirely and put “EKA not provided” or a similar statement.)  Also, note that my Wisinger frame is slightly different from the frame I provided you – leaving more space for info about the EKA (Earliest Known Ancestor).  

[back to top] 

(Contact Terry Barton for more information.)