How do I access the tool?
Log in a www.worldfamilies.net
using your project admin’s username and password, then go to your project’s Results Page. Click the link “Y-DNA Results Tool” at the top of the page.
What if I have more than one project at WFN—how do I update specific results?
If you are authorized to run the Tool on more than one project, you can change your selection in the surname box.
What if the Tool does not pull the information from my existing yResults page uploaded spreadsheet?
Make sure that your Kit number column has “Kit” as the label
If you use Project numbers, make sure the column has “ID” as the label
If you are not using kit numbers, they must be added in a “Kit” column and your spreadsheet then re-uploaded for the WFN Results Tool to scrape your existing data at WorldFamilies
If you have extra programming in your spreadsheet, you may need to remove it, then upload the spreadsheet again.
If you have trouble getting your existing data to scrape, ask us for help – or you can manually add any data not coming from the FTDNA data feed to complete your new results table
Why are there 3 rows in the first view I see of my project’s results when I use the tool?
The first row comes from the FTDNA website and includes the Most Distant Ancestor that the project member entered on his personal page.
The second row is the information pulled from the World Families project website’s Results Page
The third row is a merge of the information based on WFN’s rule. You can change this choice.
I don’t see 3 rows on the first page—there is no WFN data and every row is green. What do I do?
Stop and contact WFN for help—the tool is not pulling in all the data.
back to top
What does a row with a green background mean?
Green denotes that these are the results for a new project member.
What does a row with a yellow background mean?
Yellow denotes that these results exist at either WFN or FTDNA, but not both.
How can there be results at only WFN or only FTDNA, but not both?
Sometimes WFN Results Pages have results from another company that were added by the Project Admin.
Sometimes WFN Results Pages have results for project members who have since left the project.
New results added to the project at FTDNA since we last updated the Results Page do not yet appear on the WFN site.
Why do some results have only the last markers results marked in yellow?
The yellow marker results are those that are additional results added for that kit since the last update.
back to top
How can I add an ID number, a Haplogroup, an Earliest Known Ancestor, or a missing marker value to a kit?
You can add the information on the “merged”screen. After adding the information, click the tab “Save and Recalculate”. (You can also add the information of the first screen in the third “Merged” line.)
How do I remember which kits have new results so I can send a bulk email listing them?
Make a note of the kits with new information (the green and yellow markers) before you hit the “Merge Data” tab.
What happens when I click the “Merge Data” tab?
The merged date view resembles the finished table, but you have the ability to change information and regroup the results as you wish on this screen.
Why are the Haplogroups given different colors?
Markers matching the WF Haplogroup Profile show in the base color for the Haplogroup (there is no particular meaning for this color – it is a background and simply identifies the most common value for the marker in that Haplogroup)
back to top
Why do some kits have no markers colorized?
Kits without a Haplogroup Assignment will not have markers colorized.
What is the Haplogroup Profile shown across the top of each Haplogroup?
The Haplogroup Profile was created as a reference by WorldFamilies for each haplogroup. Generally, it is the most common value in that particular Haplogroup for each marker.
Why are the variations for the Haplogroup Profile shown in different colors?
We use a color code to mark variations from the Haplogroup Profile as an easy way to spot kits that have the same differences from the Haplogroup Profile (they “match” and become a Lineage.) For example, markers that are 1 more than the profile are colored blue, while those that are 1 less than the profile are colored peach.
back to top
How is a lineage determined?
The tool uses WFN guidelines: the results must match at 23/25, 33/37, 61/67 or better to be assigned to a lineage.
What is the Apparent Ancestral Profile?
The marker values shown in the row with the Lineage name are the probable marker values for the Most Recent Common Ancestor of the Lineage.
How do you create the Apparent Ancestral Profile?
For a two-man lineage, the comparison is head-to-head, so that the common marker numbers become the number for the Apparent Ancestral Profile. When the two men have different values at a specific marker, the tool puts a question mark in the row for the Apparent Ancestral Profile. As more results are added to the Lineage, the most common marker value can be established and will be placed in the row for the Apparent Ancestral Profile.
back to top
Why are some results put in the “Possible Lineage” category?
Project members with only 12 markers who match the Lineage Profile by 11/12 are identified as “possible” as 12 markers is considered too few to confirm a lineage. Project members who have differences slightly outside of the Matching Guidelines may also be placed in the “Possible Lineage” category.
What do the tabs across the top of the Merged Data page mean?
Detect New Lineages
Show Deleted (Hidden)Kits
—Kits not displayed on the Results Page, but still in the project.
Right click on the kit number of the hidden kit to assign the kit to a lineage or undelete (hide) the kit.
Show you the lineages within the project and allows you to rename them or to delete a lineage
no longer in use by right-clicking on the lineage name.
Add New Kit—
allows you to manually enter a new kit’s results.
Important—always click this tab after you have made any changes to the page.
Preview (Does not Publish)
—Click this tab when you think you have everything right—you will still have another chance to inspect the page and make changes.
How do I change the Lineage assignments?
Place the cursor on the kit number or earliest ancestor of the kit and right click. You will be given choices to assign to a lineage or a possible lineage, auto assign to a lineage, use as a lineage, or un-assign to a lineage.
How do I delete a kit from the results page?
Place the cursor on the kit number or earliest ancestor of the kit and right click. Among your choices are “Delete Kit” (hides kit so it is not displayed on the Results Page) or “Permanently Delete Kit” (use if kit has been removed at FTDNA).
back to top
What if I don’t like the table as it appears on the “Preview” page?
Click the “Back” tab at the top of the screen, and you will be able to further edit the table.
What happens when I click the “Publish” tab?
You will be asked if you are sure you want to make this the public version of your results page. Click OK and the Results Table you have created using the WFN Results Tool will appear on the Results Page of the project’s website.
What happens if I find a mistake after I’ve published the table to the Results Page?
Just click the “Y-DNA Results Tool” tab again and go through the steps to correct any errors. Then publish the page again.
I'd like to use the WFN Results Tool on my project's Y-DNA Results page and still display my old-style results spreadsheet on the project's website because it contains extra information and/or the project members are used to finding their results there. How do I do that?
You can change the designation of one of the other pages of the website that you seldom or never use (mtDNA, Discussion, Join) and use it to display your old-style spreadsheet. Here's how to do it"
Log in at your project's website as Project Admin.
Click on the page you have decided to use to display the old-style spreadsheet.
In the box for "Page Title", type the new name for the page.
In "Edit Choices" choose "Your custom text."
Scroll to the bottom of the page and click "Save"
Use the "Upload" tool to upload the saved spreadsheet, which you saved as an .htm or .mht file.
If you would like to change the url of the page to match its new name, send firstname.lastname@example.org
an email to make the change for you.