Our DNA Color Cluster charts can be more powerful when they are organized. Here are seven organization tips. If you have any other suggestions, please let me know!
1. Sequence Numbers
When you first enter your list of 2nd & 3rd cousins using the Leeds Method, add a column for “sequence number” so you can always “unsort” your chart and get your matches back in their original order when needed.
2. Black vs Red Font (Known vs Unknown)
Name in BLACK font? These are the people whose relationship is known.
Name in RED font? These are the people with an unknown relationship.
3. Number of Centimorgans (cM)
Centimorgans, or cM, is how we measure how much DNA we share with our DNA relatives. You can put this number in a separate column, as in this example, or write the number on the colored cells.
4. Relationship
If the relationship is known, make sure the number of centimorgans makes sense. Then, write the relationship in shorthand: “C” for cousin; “R” for removed. If the relationship is unknown, use a question mark.
5. Hide Columns
If your chart gets too “busy” looking, hide any columns you do not currently need.
6. Name Your Columns
When working with 2nd and 3rd cousins, you can label your columns by both your “4 GRANDS” (4 grandparents) and “8 GREATS” (8 great grandparents).
7. Sort Your Chart Cells
First, you can put your color clusters in traditional order of a genealogy tree: dad’s dad, dad’s mom, mom’s dad, and mom’s mom. Then, use Excel’s “SORT” feature – located under the “Data” tab – to sort your chart by cell COLOR!!!
Click on “Data,” then “Sort.”
Sort by “Column” (the first column you have colored cells in), cell color, the color, and then “On Top.”
Select “Add Level,” then continue sorting by each column that has colored cells.
Click “OK” – and your chart is sorted!
This chart was created using Excel. If you are new to the Leeds Method, start with this post first: DNA Color Clustering: The Leeds Method for Easily Visualizing DNA Matches.
Special thanks to Janet Miller for suggesting the sequence numbers and black vs red font!
16 Comments
Leave your reply.