Followup to Leeds Color Sorting DNA Matches presentation WCGS - June 25

Followup to last weeks Leeds presentation - 

In my effort to cover the topic in the time allowed, I was using a very simplified data set that was edited (think one of those home shows) for time. 

If you are trying to create your own spreadsheet from memory of my steps, take heart, Dana Leeds will walk you thru in her blog posts (Links in the handout and here). 

I wish you much fun and success. As always start small and give yourself permission to start over when you start to get the hang of it.

 https://www.danaleeds.com/leeds-method-dna/

I like this description too.

https://www.yourdnaguide.com/leeds-method

Good luck with your DNA Match sorting!

Cyndi Deal


PS - Also, keep watching the Summer of DNA link at the top of the blog home page. All handouts and links will be posted there for reference.

Return to the WakeCoGen Website

DNA Handout #2 from June WCGS meeting - Leeds Color Matching

Leeds Color Matching Sorting Method for atDNA Matches
Presenter: Cyndi Deal

DNA with DANA LEEDS - blog for Color Clustering Matches - https://dnawithdana.com

¡  1) DNA Color Clustering: The Leeds Method for Easily Visualizing Matches

¡  2) DNA Color Clustering: Identifying “In Common” Surnames

¡  3) DNA Color Clustering: Does it Work with 4th Cousins?

¡  4) DNA Color Clustering: Dealing with 3 Types of Overlap

¡  5) Check Your Work! (The “How”)

¡  6) 7 Organization Tips for Your DNA Color Cluster Chart

Dana Leeds’ Presentation at I4GG2018

¡  Creating and Analyzing Genetic Networks with a Spreadsheet - Dana Leeds ($)

http://i4gg.org/conference-videos/

Color and Tag with Ancestry’s new features –

·        Video from Blaine Bettinger - Sub-Clustering Your Shared Matches at AncestryDNA

https://www.youtube.com/watch?v=6ApidzEyA_k

Other Blogs and Work Groups

¡  Roberta Estes blog post,  The Leeds Method

https://dna-explained.com/2018/09/26/the-leeds-method/

¡  Roberta Estes blog post, Painting Leeds matches to DNAPAINTER (using matches with chromosome data)

https://dna-explained.com/2018/10/02/dnapainter-painting-leeds-method-matches

¡  Diahan Southard blog post, Organizing Matches with Leeds

https://www.yourdnaguide.com/leeds-method/

¡  Facebook Workgroup – Genetic Genealogy Tips and Techniques  >> search “Leeds” in box on left sidebar

https://www.facebook.com/groups/geneticgenealogytipsandtechniques

Preprinted worksheet for Leeds Method

¡  https://memoriesintime.co.nz/collections/family-history/products/dna-match-leeds-method-worksheet

DNA Match Manager

¡  https://heirloomsoftware.com/dna-match-manager/

Conditional Formatting “recipe”  -  Included in handout

Gather Matches for excel the Fast way

DNA Match Manager

•        https://heirloomsoftware.com/dna-match-manager/

•        Free, Fast

•        Works with all main test sites and GedMatch

•        Creates csv files that you can save in Excel

DNA Match Manager

Color match options – Easy vs. Power tools

Format Cell color

Right click on cell> choose fill tool (Paint bucket)> Choose color. This is simple and works, but you can’t sort it.

“Recipe” for Conditional Formatting in Excel

Home tab on Excel task Ribbon> Conditional Formatting dropdown> New Rule> 2^nd option: format only cells that contain> fill “cell value” and define a color.
Power Tool option: Allows you to sort columns into associated family lines when they become apparent.

My Latest leeds effort

Using Power Tools:

¡  Match Manager data

¡  Conditional Formatting

¡  Color Code the starting match

¡  Rearranging the Columns as family lines become apparent

This shows how my process has evolved since first Leeds chart example that I shared with you. You can see that I have been moving the columns around as their connections become obvious.

Final Step, transfer this valuable info to your AncestryDNA match Page. Color code and Tag your matches with Ancestry’s new features. See Blaine Bettinger video (link on Resource page).