Templates

Lately, I have been using Excel to maintain chromosome maps for myself and my relatives. These chromosome maps identify which segments of DNA came from which ancestor.
(click to enlarge)
 See below for links to download these spreadsheets -- I have included my template and also my current paternal chromosome map as an example of how I use this tool.

How can you get started with your chromosome map?

1) The first step is to gather Family Inheritance Advanced data (use the table view) from your family members and confirmed connections in Relative Finder.

I've underlined the key information in red -- you need the chromosome where the segment is located, and the start and end points (leave off the six trailing zeros).

2) Input this data in the appropriate sheets of the Excel spreadsheet. 

The way my template is set up, the inputted data should go in the numbered sheets. The numbered sheets are the working sheets, whereas the sheets entitled "Parent," "Grandparent," and so forth, are where the assembled chromosomes go, so that you can easily see the current status of your chromosome map.

3) Use the Excel fill button to color in the shared segments. 



4) As you make updates to the working sheet, transfer these updates into the main sheet.

The working sheet contains the data that went into building your chromosome map. The main sheet contains only the compiled chromosomes, for easy viewing.

DOWNLOADS:

You can customize the template to suit your needs. For example, if you have your parents tested, the "Parent" chromosome map will likely not be very useful to you

These files were created using Excel 2013 and I have also tested them in Excel 2010.

Please contact me with any questions or comments.

Happy mapping!

25 comments:

  1. ClaireJune 1, 2013 at 7:55 PM

    This comment has been removed by the author.

    ReplyDelete
  2. ClaireJune 1, 2013 at 7:56 PM

    Really interesting. The second file isn't accessible btw.

    You can also do something similar to track connections to various people as a way of trying to discern you connections I assume.

    My grandparents have all passed away, so I don't think the pages for relatives far back could be used - I guess to do the multiple historic generations back you need to have a number of living generations that can be tested.

    ReplyDelete
  3. AndreaJune 1, 2013 at 9:15 PM

    Hi Claire, thanks for letting me know about the second link -- I fixed it.

    My grandparents are all deceased as well. I do have a number of my dad's cousins tested, and also my paternal half-sisters. You can also use your confirmed connections in Relative Finder to make these maps.

    ReplyDelete
  4. UnknownJune 3, 2013 at 9:25 AM

    Love this ability to take your Chromosomes and spin the data on your own.
    Could I use your two graphics and links for our next Seattle Genealogical Societies DNA Interest Group Presentation powerpoint on 29 June?
    Cary
    sgsdnasig "at" gmail.com

    ReplyDelete
  5. AnonymousJune 24, 2013 at 10:18 AM

    Andrea,
    This chromosomes mapping seems like a very complex thing to me. I would like to be able to see if there is any useful information for me, but I do not feel this is something I have the time to devote to learning. Is there anyone who offers this service that I might be able to hire to do mine. Please email me at carolpublic@earthlink.net.

    Thank you, Carol

    ReplyDelete
  6. AnonymousJune 30, 2013 at 1:18 PM

    Any chance you could export those .xlsx files so they can be read by earlier versions of Excel (e.g., Excel 2003 uses the .xls extension)? Thanks!

    ReplyDelete
  7. AnonymousJuly 15, 2013 at 8:07 PM

    I'll admit: I am stumped at the first step "The first step is to gather Family Inheritance Advanced data (use the table view) from your family members and confirmed connections in Relative Finder." Where is this table view?

    ReplyDelete
  8. joebissettMarch 12, 2017 at 6:08 AM

    Hi Andrea, neither of the links works for me. Have you changed the file locations?

    ReplyDelete
  9. freaksidegeekApril 2, 2017 at 11:53 AM

    I look forward to the day this is all built in to our genealogy software. It seems overdue.

    ReplyDelete
  10. UnknownSeptember 27, 2017 at 11:45 AM

    Hey there are using Wordpress for your blog platform? I'm new to the blog world but I'm trying to get started and set up my own. Do you need any coding expertise to make your own blog? Any help would be greatly appreciated! google mail sign in

    ReplyDelete
  11. UnknownMarch 15, 2018 at 4:35 PM

    Thanks Andrea

    ReplyDelete
  12. UnknownMarch 4, 2020 at 8:36 AM

    Hi Andrea. I'm looking for this very type of file but I recently purchased a new computer and loaded Office 365 on it. Apparently Excel requires Excel 365 in order to download it. Is there any chance of an upgraded copy anytime soon?

    ReplyDelete
    Replies
    1. CheriJune 24, 2020 at 10:07 PM

      Hi, try replacing https://www.box~ in the link with app.box~
      That's what worked for me. :)

      Delete
  13. TuijaAugust 31, 2020 at 12:42 AM

    This comment has been removed by the author.

    ReplyDelete
  14. YDNA ResearcherOctober 14, 2020 at 8:35 AM

    Box download is broken, shows dialog box that says download in progress but there is no download.

    ReplyDelete
  15. FrancesDecember 6, 2020 at 10:57 PM

    The government sets certain guidelines for mortgage lending in Canada. canadian mortgage calculator They can also assist you in getting the top home loan deals that fit the needs you have and capacity. canadian mortgage calculator

    ReplyDelete
  16. Lisa RussellMarch 14, 2021 at 10:59 AM

    This comment has been removed by the author.

    ReplyDelete
  17. Lisa RussellMarch 14, 2021 at 11:01 AM

    Since apparently the comments here aren't moderated I think I will say that I love genealogy and Anyone researching King, Kiochinsky, Lebeck, Markley, Garber, Brown, Daniels, or Shankster family, hit me up. LisaRussell.org I have a great database that I like to use to keep track of it all, fun to share:)

    ReplyDelete
  18. Charli jamesMay 7, 2021 at 9:02 AM

    Wow, cool post. I’d like to write like this too – taking time and real hard work to make a great article… but I put things off too much and never seem to get started. Thanks though. Gmail templates for business

    ReplyDelete
  19. AngieAugust 21, 2021 at 9:03 PM

    Hi Andrea,
    I have tried to download the templates but its not working.

    ReplyDelete
  20. BonnieNovember 13, 2021 at 11:44 AM

    My closet match is a 1st cousin on my mom's side. (Dad is unknown) Can this be used still as a tool for someone like me?

    Mom passed before I could test her

    ReplyDelete
  21. Turkey visa for IndiansDecember 5, 2021 at 12:08 PM

    Aw, this was a very nice post. Few minutes and real effort to make a really good article…Turkey visa for Indians. You can check all visa requirements in Turkey via the Turkish e-visa website. Travelers entering Turkey are required to apply for an e-visa. The process is very simple, all you have to do is fill our online application form.

    ReplyDelete
  22. Raza MeerOctober 21, 2022 at 9:39 AM

    Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. media kit samples Studies have shown that web templates can grab interest of the first time user in only 10 seconds.

    ReplyDelete
  23. Indian e visa for US citizensApril 9, 2024 at 11:50 PM

    Perusing your article stirred a sense reminiscent of journeying through the labyrinth of human contemplation. Every sentence led me deeper into the recesses of thought and sentiment. Your mastery at encapsulating the core of our internal landscape is genuinely captivating. It's almost as if you've skillfully plucked the whispers of our psyche and woven them into a tapestry of profound understanding. Gratitude for offering us this intellectually enriching expedition. I eagerly await additional enlightening odysseys through your writing.

    ReplyDelete

Subscribe to: Posts (Atom)