DNA Handout #3 from June WCGS meeting - Things you can do with your autosomal DNA results

 This handout was curated and created by Cini Gage. She wanted to share some of the many tools that we have been working with over the last couple of years. Please click on the images to view a larger version. This was formatted as a landscape spreadsheet and requires screenshots to get it to fit blog format.

Things you can do with your autosomal DNA results

click to see larger size

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).

DNA Handout #1 from June 2019 WCGS Meeting - Evaluating your atDNA Matches

Presented and prepared by Sallie Szymczyk

Evaluating Your atDNA Matches

WCGS

June 25,2019

Use a unique username

Open a new e-mail account

Provide at least a skeleton tree

Start with your closest matches to determine which side of your family they are on

Look at available trees for hints

Look for common surnames and locations

Check to see if your match has posted to a message board

Use the “Shared Matches” tool on Ancestry, the “In Common With” tool on FTDNA or “shared DNA Matches” on My Heritage

Determine Paternal or Maternal match

Make a spread sheet to keep track of your findings

Contact your matches with an “informed” e-mail – Do your home workReturn to the WakeCoGen Website