Home

Posting Results on Your Project's Results Page

The Results Page is the most-viewed page on any project website. 

Getting the resultsi posted, displaying and organizing them to give as much information as possible, and notifying the project members of new developments is a very important part of the Project Administrator's job.

Worldfamilies.net will help you as much as you need until you feel ready to take over this task, but the new Upload HTML File makes it so much easier, that you may want to take on this task yourself. 

Here are some tips that will help you deal with the results for your project.: 

  • FTDNAi will send you a notice whenever new results are available for your project.
  • You (or Worldfamilies) will then post the results on the Results Page. (Worldfamilies will post the results until you are ready.  When you take it over, we will assist you in any way you need. )
  • To collect the new results
    • Go the the FamilyTreeDNA GAPi (group administrator's page) and click on "Members Reports and Information" Page to find the Project members code identity numberi.  Find the kit number, then hover over the member's name to see his code identity number.  Make a note of the number, so you can remember it when you post the results to your Excel table.
    • Go back to your FamilyTreeDNA group administrator page and select “Generate Y-DNA Results (Classic Chart)” 
    • Then, select “Copy & Paste”
    • A Results Table will display on your screen
    • If the new results are for a new member whose results have not been posted on the Results Page, copy his entire line of results on the FTDNA Copy & Paste page. 
    • If the new results are more markers for a project member whose previous results are already posted on the Results Page, you will want to simply add the new results to his already on the Results Page.
  • Here's how to prepare your project's Results Page: 
    • Start with the Excel spreadsheet that we will provide you as an attachment when we set you up as project administrator
    • We recommend that you maintain this 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 as an html file. 
    • Add additional information and adjust groupings 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 mutationi with a contrasting color 
    • 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 "copy and paste" page into the Excel spreadsheet.
    • Each time you post results, evaluate the page again to see if a Lineage has developed, and if so, indicate that in the way you post the results.
    • Add the code identity number for any new results you have entered.
    • Change the last update date at the top of the page.
  • Once you have all of the results in your Excel spreadsheet, you can organize the table and add information as needed.  
    • Earliest Known Ancestor (EKA)--
      • Do a “back” command with your browser at the FTDNA Results page, 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)
      • If the EKA is not listed there, you can sometimes find his pedigree on the Patriarchs Page by comparing email addresses.  If you can't find it, email the participant to ask him to send it to you and to post his pedigree on the Pedigree Forum.
      • 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.
    • Haplogroups--
      • Pay attention to the haplogroups shown and post them in the correct column.
      • FTDNA has a color code for those whose haplogroup is estimated (red) and those who have been SNP tested to determine the exact haplogroup (green).
    • Lineage--
      • Each time you post results, evaluate the page again to see if a Lineage has developed.
      • A lineage is declared whenever two project members match at 23/25 or better.
      • Indicate the lineage in the way you post the results, placing the results together, coloring them the same, showing mutations in a different color, and heading the group with the ancestral haplotypeii
    • Preparing your spreadsheet for uploading to the Results Page
      • After you have completed all the edits and are satisfied with your Results table, save it as an html file
      • Click on "File" then “Save As", give the file a name, then select "Web Page (*htm; *html) in the "Save as type" box.   Make sure you save it in the directory you want.
      • Do not click on File and then "Save as Webpage", as this will save it literally as a webpage, not a document
    • Uploading your spreadsheet at your projects Results Page
      • Log in at the Worldfamilies.net site, using the username and password you were given to use on the forum when you were set up as a Project Administrator.
      • Go to your project Results page.
      • Click on Upload HTML File. 
      • Click the Browse button to locate and select your file, then click Save and Publish. 
      • The new updated spreadsheet will appear on your project's Results Page.
  • Tips for your Results Page:  
    • 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 as an html file.
      Alternately, you can prepare your file with any software—the important thing is that it is an html file.  
    • All of your results presentation should be prepared and saved in the Excel spreadsheet.
    • If you simply need to correct a spelling, change a haplogroup result, or add an earliest known ancestor, you may choose to simply edit the existing table.  If so, log in as administrator, click on Edit this page, make the changes, then click on Save and Publish.
    • If you are making many changes to the results table, however, we recommend that you completely replace the table by uploading an updated html file to the Results Page.
    • Be sure that the Results table you save as an html file and upload to the page contains only information you want displayed, as everything on the page will be displayed on the project Results Page. 
    • You may want to keep two spreadsheets. 
      • Prepare the first spreadsheet with all the information that you need for your project, including kit numbers or other identifying information in columns at the beginning or end of the table. 
      • Save it to your computer. 
      • Then copy only the part you want to display on the Results Page into another Excel spreadsheet, which you then save as an html file and upload to the project Results Page. 
  • Common Problems with Posting Results:
    • When I upload my file, the Results Page comes up blank. 
      • When you saved the Excel Spreadsheet, you clicked on File, then Save as Webpage, which literally saves it as a web page, not a document.
      • You need to re-save your table, by 
        • Go to File
        • Click on Save As
        • Change the name of the file, to something like Barton Results Revised )as long as it's different from the other name)
        • In the "Save As File" box under the file name, select "Web page (*htm, *html)
          Be sure you have saved the file in the directory you want it in.
        • Now you should be able to upload it to the Results Page. 
    • 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. 
      • Click on the box where you want to place the information.
      • Go up to the line near the top of the Excel page to a box that is preceded by =
      • Paste the information into that box
      • The information will appear in the correct space on your table.
    • There is no Earliest Known Ancestor for some of the project members. 
      • 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.)
      • You can also look on the pedigree forum or Patriarchs page to see if you can correlate pedigrees with the test results. You can sometimes deduce the test results that go with a pedigree by looking to see if the email address given matches that of a project member.
      • Email the project member to ask him to submit his EKA and to post a pedigree on the forum.
    • The table header I have is not adequate for my project.
      • Let us know if you need a frame for 67 markers and we'll send it to you.
      • Let us know if you need a 48 or 76 marker frame to show the results for those tested at other companies.
      • Feel free to customize your frame to meed your project needs.  (We discourage putting the marker lables "horizontal"- as that really widens your table, disruping viewing.
  • See also our Project Administrator's Guide,  Editing your Project's Website, and Tips for Project Administrators pages 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.