tag:blogger.com,1999:blog-6668477613613276565.post8878390022104854621..comments2021-11-22T15:14:23.502-08:00Comments on Analytic Genealogy: Genetic genealogy needs horizontal pedigree chartsUnknownnoreply@blogger.comBlogger25125tag:blogger.com,1999:blog-6668477613613276565.post-19232963008531452442016-02-09T19:31:35.806-08:002016-02-09T19:31:35.806-08:00This comment has been removed by the author.Rachel Ghttps://www.blogger.com/profile/02157795325312284563noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-91614037870525721602015-03-15T14:23:36.279-07:002015-03-15T14:23:36.279-07:00I wonder if you've seen the Condensed Pedigree...I wonder if you've seen the Condensed Pedigree Chart generated by Second Site. Here is mine, for example: http://doriswheeler.org/ui262.htm. I can add flags and accents at will, a feature I love. The only thing missing is the ability to show locations, and I've asked John Cardinal to add that in a future upgrade. <br />Faxhttps://www.blogger.com/profile/14160490778082617475noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-67132570781848385612015-02-10T22:14:27.070-08:002015-02-10T22:14:27.070-08:00hi, had to replace the file with a non-editable ve...hi, had to replace the file with a non-editable version as someone is editing it with their own info, this is viewable and, I hope, downloadable: https://onedrive.live.com/redir?resid=27E5620F4E143C7D!524&authkey=!ABc6bp6EP3leJM0&ithint=file%2cxlsxArtefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-66467282723047838892015-02-10T21:15:54.996-08:002015-02-10T21:15:54.996-08:00I have used text trees like that in the (extremely...I have used text trees like that in the (extremely character limited) text block on the 23andme profile page and they were not well understood by newbie genealogists. The goal is not to invent a new chart (which I don't think this really is, although I will say my dad finds the excel file print-outs very readable in his old age) -- there are plenty of great charts for different purposes -- but to optimize the (input and) tree display interface that will enable genetic matches to figure out MRCAs. I do think that the image above is basically the way the testing companies should go to help customers achieve that goal, which is part of the service they are selling that is not working as well as it could at the moment.Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-47382124514667744922015-02-10T21:15:33.914-08:002015-02-10T21:15:33.914-08:00This comment has been removed by the author.Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-49732189548079482042015-02-10T20:14:44.834-08:002015-02-10T20:14:44.834-08:00Text format, editable in any editor and also more ...Text format, editable in any editor and also more scalable (no need to expand the whole binary tree, even few paths/lines are sufficient):<br /><br />http://siberean.livejournal.com/14874.htmlAnonymoushttps://www.blogger.com/profile/10061132457481005233noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-50824771145143731632015-02-10T20:08:46.871-08:002015-02-10T20:08:46.871-08:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/13021023056247394884noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-60657740226193803992015-02-10T17:11:23.689-08:002015-02-10T17:11:23.689-08:00I have also used, and can recommend the TreeSeek f...I have also used, and can recommend the TreeSeek fans for those looking for a fan chart. Super easy to upload and generate a file and they print perfectly on 11 x 17 at a copy shop as well.Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-84741940214401281122015-02-10T16:41:12.455-08:002015-02-10T16:41:12.455-08:00I have been playing with treeseek.com it is setup ...I have been playing with treeseek.com it is setup for familysearch but will also let you upload a gedcom maybe someone like them could do something like this, I use the 9 generation fan... also great to see what I still need to fill in.denny647https://www.blogger.com/profile/17313163213711337006noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-82287962020534484872015-02-10T11:02:22.614-08:002015-02-10T11:02:22.614-08:00Unfortunately I am not a programmer and don't ...Unfortunately I am not a programmer and don't have an app for loading it from a gedcom -- I could visualize kicking data out in CSV format from a database into the column structure but not sure how it would handle all the merging, centering, etc. It could work if the gedcom had assigned ahnentafel numbers for each person relative to the base person and the sheet was programmed with fields. However, what we really, really, need is for all the genealogy and autosomal testing companies to place the chart structure on the user profile page and prompt testers to complete them...Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-14587057537590123472015-02-10T10:58:51.695-08:002015-02-10T10:58:51.695-08:00hi Sue, checked out your link and not surprised th...hi Sue, checked out your link and not surprised that you have also found this structure useful (I played around with several different versions and it really does reduce to a standard simply by what you can fit on a screen) and that you also used color coding. In the actual charts I've done (the pictures here are modifications I made to simplify and get it to show up as a good image on the blog) I coded by birth country for the same reason - to quickly communicate potential branch intersections. The other things I've done include adding color coded text for military activity and including haplotype information, which is what I am covering in the next blog and the whole reason I put this post up this week -- to introduce the 7-9 g horizontal pedigree structure. Best of luck to you!Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-89241328585833520862015-02-10T10:34:48.593-08:002015-02-10T10:34:48.593-08:00Is there a way to load a GEDcom into this or do we...Is there a way to load a GEDcom into this or do we need to enter it manually? Just trying to find a way to save some time. Thank you, this is an excellent tool!Unknownhttps://www.blogger.com/profile/02407368996192915069noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-10179747410741957012015-02-10T04:09:30.154-08:002015-02-10T04:09:30.154-08:00I created a similar color-coded chart as yours for...I created a similar color-coded chart as yours for ancestry composition, but instead for birth county, as most of the branches of my tree are from distinct geographical locations in the UK (see www.genealogyjunkie.net/pedigree-charts.html). Because of this, I find geographical location to be more productive than surnames when trying to make a genealogical connection with a DNA match, unless the name is more unusual. I can then give the URL to my matches, so they know which branches of my Ancestry tree to focus on when looking for common ancestors. But I wish my matches would provide me with a similar color-coded chart, as going through locations is slow and laborious when looking at a tree you have no familiarity with.<br /><br />But looking at my own tree now, I see I need to update it, as I made a few minor breakthroughs. And another idea came to mind is a separate color-coded chart for those ancestors who have been confirmed with DNA – like a visual "DNA score card".<br /><br />I had started to create an Excel spreadsheet similar to yours (the chart in the URL above is in Word), but having the cells in the pedigree chart sheet auto-populate from a list of names by Ahnentafel number on a separate sheet (and other columns could be added for locations) – but I got waylaid and it is now not near the top of my To Do list!Anonymoushttps://www.blogger.com/profile/01276270940572423898noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-37259544354606084332015-02-09T22:46:34.492-08:002015-02-09T22:46:34.492-08:00Okay I missed your spreadsheet. Thank you very mu...Okay I missed your spreadsheet. Thank you very much for that!!! Great tool! <br />Attica Musingshttps://www.blogger.com/profile/10407830645336766147noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-30559242742425909932015-02-09T19:52:08.363-08:002015-02-09T19:52:08.363-08:00Thanks for this! I think you were reading my mind!...Thanks for this! I think you were reading my mind! I just hadn't taken the time to sit down and set up the template. I used the template tonight to fill in my tree, and colorized the name lines, making it easier to follow back. I love the results! I think this will make my life a whole lot easier!Anonymoushttps://www.blogger.com/profile/08545385670219978922noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-22302198680020462812015-02-09T17:47:35.489-08:002015-02-09T17:47:35.489-08:00Fantastic. Thank you Fantastic. Thank you Julie Dixon Jacksonhttps://www.blogger.com/profile/00474148976654705613noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-39028317541400011572015-02-09T14:25:14.733-08:002015-02-09T14:25:14.733-08:00Thank you so very much!Thank you so very much!Chickadeehttps://www.blogger.com/profile/11195072440198601548noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-10977282104584789172015-02-09T11:20:10.987-08:002015-02-09T11:20:10.987-08:00Wow! Thank you so much. I laid my Dad out like th...Wow! Thank you so much. I laid my Dad out like this today. It is helping me focus into this project much easier. Yes, the computer programs do manage to do this somewhat, but this is very compact and usable. Thank you. Attica Musingshttps://www.blogger.com/profile/10407830645336766147noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-74332110267838303242015-02-09T10:23:37.506-08:002015-02-09T10:23:37.506-08:00should probably mention I am Canadian, so I can ac...should probably mention I am Canadian, so I can access Ancestry, but not AncestryDNAArtefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-68422462229483089532015-02-09T10:21:40.381-08:002015-02-09T10:21:40.381-08:00This comment has been removed by the author.Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-38497143973455988212015-02-09T10:21:21.002-08:002015-02-09T10:21:21.002-08:00This comment has been removed by the author.Artefactshttps://www.blogger.com/profile/10092103147065639552noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-86066784845982609602015-02-09T07:58:15.811-08:002015-02-09T07:58:15.811-08:00I'd love to get a chart like that. Where can i...I'd love to get a chart like that. Where can i get one?Anonymoushttps://www.blogger.com/profile/10382333381787277725noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-30318611195059278762015-02-09T05:47:00.063-08:002015-02-09T05:47:00.063-08:00AncestryDNA does display a seven-generation horizo...AncestryDNA does display a seven-generation horizontal tree, and you can switch to pedigree view in all trees. It's not nearly as compact as your example, but at least it allows vertical scrolling.<br /><br />Another thing I particularly like about your example is the intuitive way you can visualize the amount of each ancestor's DNA contribution (on the average, of course).DNACousinshttps://www.blogger.com/profile/16853537836104702338noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-64779259665014896042015-02-09T04:43:18.941-08:002015-02-09T04:43:18.941-08:00Excellent post. I've been utilizing charts in ...Excellent post. I've been utilizing charts in spreadsheets for some time trying to break down my brick walls.Denesehttps://www.blogger.com/profile/16724557656399049287noreply@blogger.comtag:blogger.com,1999:blog-6668477613613276565.post-21114640564505600872015-02-09T04:37:44.170-08:002015-02-09T04:37:44.170-08:00Brilliant!Brilliant!IsraelPhttps://www.blogger.com/profile/16748957039859625149noreply@blogger.com