Data Mining DNA
332 FOLLOWERS
This website is operated by M.C.O.B. Technology Ltd. Data Analysis and Genealogy Research on DNA Matches.
Data Mining DNA
2w ago
When you’re building your family tree, the rarer surnames are often the easiest to research. My grandmother was a Smith which makes that ancestral line a challenge to explore. My early research focused on marriages in the Smith line to people with less common last names. This tutorial shows you how to use a spreadsheet ... Read more ..read more
Data Mining DNA
2w ago
There are several different ways to get a list of names from your family tree. Some methods use desktop software or require a little technical knowledge. But if your tree is online on Ancestry, there is one simple way to get a list of people into a spreadsheet. It’s time-consuming with larger trees but it ... Read more ..read more
Data Mining DNA
1M ago
Have you got a long list of people’s names in Excel and you’re not sure how to sort or filter them by surname? The challenge occurs when the first and last name are in a single cell. You may also have middle names jammed in there. And worse, there may be a prefix (Mrs.) or ... Read more ..read more
Data Mining DNA
1y ago
A word cloud is a visual representation of text. The size of each word in the cloud is proportional to its frequency. When we use word clouds to represent our family tree, we are usually making one from either: In this tutorial, I show two ways to make a word cloud based on last names ... Read more ..read more
Data Mining DNA
1y ago
Do you want to convert a GEDCOM file into a spreadsheet with every person nicely formatted in rows? This tutorial walks through how to do this for free. You’ll be working with a script or piece of code, but don’t worry if you’re not familiar with programming. I’ll provide the script in a way that ... Read more ..read more
Data Mining DNA
1y ago
If you’ve copied your family tree between different genealogy sites and software, then you’ve probably dealt with a GEDCOM file. Have you ever wondered how the GEDCOM format came about? This article delves back into history to it origins. I also take a quick look at why the genealogical data standard seems stuck in time. ... Read more ..read more
Data Mining DNA
1y ago
A nine-generation tree goes all the way up to 256 great-great-great-great-great-great-grandparents. Our layout in Google Sheets prints across twelve portrait pages. They can be taped together as three pages wide and four pages deep. The 9-Generation Pedigree Tree Layout In Sheets The picture below shows what the top of the tree looks like (I’ve had ... Read more ..read more
Data Mining DNA
1y ago
A ten-generation family tree goes back to 512 great-great-great-great-great-great-great-grandparents. This tutorial shows you how to create this very large tree in Microsoft Excel. Our version prints across twenty-four portrait pages arranged as three pages wide and eight pages deep. The printed pages can be taped together to put up on a wall as a single ... Read more ..read more
Data Mining DNA
1y ago
An eight-generation family tree goes back to 128 great-great-great-great-great-grandparents. This tutorial shows you how to create one in Microsoft Excel that prints across four portrait pages. The printed pages can be easily taped together to put up on a wall as a single display. What An 8-Generation Pedigree Tree Looks Like The picture below is ... Read more ..read more
Data Mining DNA
1y ago
The Excel Family Tree Generator Template uses a format that won’t suit many hobby genealogists. It is designed to work downward from one pair of grandparents. The tree can include their children, grandchildren, and great-grandchildren. The default format has only enough room to display first names. I’ll show you how to make the display work ... Read more ..read more