DNA Matching reports -- Clustering Spreadsheet and Generational Alignment Worksheet
Posted: 27 Nov 2021 16:26
Literally, I am over my head in this discussion. I am currently pursuing a DNA course to get a better understanding on how to use the four genealogical DNA tests I have taken. I have THOUSANDS of potential matches - ranging for a sibling (YEAH) to who know what. Fortunately, maybe, these are all considered 'recent ancestor matches' but when there are enough to fill a football arena - there is trouble.
Completing this course should set me up to take the Introductory course at Boston University and then the certification course next year.
As far as I know, there is not a software program available today for recording matches in the manner for using the DNA results to complete a tree.
There are two -- maybe three -- reports that appear to be useful from this learning. The Leeds Clustering Spreadsheet where bring together matches to determine which grandparents the matches align with. The Generation Alignment Worksheet is used to look at matches (2nd & 3rd cousins) to align their tree with your tree for similarities that otherwise are not obvious. The third is the Personal Genetic genealogy worksheet that is create for each match that has a public tree for six generations. It is helpful when you complete your tree for six generations and you can use the same tool for matches to fill in gaps on their tree to identify the grandparents they align with.
Here is my question - having provided the background. I am using FH7 to input individual matches based on the company that produces the test. But some analysis tools would be help for generating reports based on the data that has been input.
Has anyone developed 'add-on' reports to assist with DNA matching? Has anyone developed guidelines for logging DNA matching results to help fill-in holes in the tree?
I can provide copies of the templates we are using if someone is interested in working towards simplifying the process.
Thank you, John
Completing this course should set me up to take the Introductory course at Boston University and then the certification course next year.
As far as I know, there is not a software program available today for recording matches in the manner for using the DNA results to complete a tree.
There are two -- maybe three -- reports that appear to be useful from this learning. The Leeds Clustering Spreadsheet where bring together matches to determine which grandparents the matches align with. The Generation Alignment Worksheet is used to look at matches (2nd & 3rd cousins) to align their tree with your tree for similarities that otherwise are not obvious. The third is the Personal Genetic genealogy worksheet that is create for each match that has a public tree for six generations. It is helpful when you complete your tree for six generations and you can use the same tool for matches to fill in gaps on their tree to identify the grandparents they align with.
Here is my question - having provided the background. I am using FH7 to input individual matches based on the company that produces the test. But some analysis tools would be help for generating reports based on the data that has been input.
Has anyone developed 'add-on' reports to assist with DNA matching? Has anyone developed guidelines for logging DNA matching results to help fill-in holes in the tree?
I can provide copies of the templates we are using if someone is interested in working towards simplifying the process.
Thank you, John