|(click to enlarge)|
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.
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.