tag:blogger.com,1999:blog-4726802159327032874.post3710809084991838791..comments2024-02-21T05:48:18.552+11:00Comments on Twigs of Yore: Visualising Ancestry DNA matches-Part 9-Combining kitsShelley Crawfordhttp://www.blogger.com/profile/15008715347583341427noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4726802159327032874.post-14238464964264641502017-09-22T10:09:53.117+10:002017-09-22T10:09:53.117+10:00Whoops! That should have read 'testid'. I&...Whoops! That should have read 'testid'. I've corrected the post now.<br /><br />Have you tried loading the new records when you first open the file, before you click refresh graph?<br /><br />You could try combining the match and ICW files. Either cut and paste (which may be awkward with such large files) or explore Excel's query options on the data ribbon. <br /><br />There should be no issue in terms of importing with appending the ICW files one after the other. The only issue with the match file would be the treatment of columns where the data differs for each person. If you append the file without creating a new columns for sharedcM etc for the second person it will still import, but you will see a mixture of values some for the first person imported and some for the second without a way to tell which is which.Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-7693927118816318192017-09-20T14:46:15.924+10:002017-09-20T14:46:15.924+10:00I'll try that - thanks. I think it's just ...I'll try that - thanks. I think it's just the volume / memory issue for my far-from-new-laptop.Shelley Bankshttps://www.blogger.com/profile/04884586311645350859noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-2941421200967621562017-09-17T05:43:30.370+10:002017-09-17T05:43:30.370+10:00Thanks for all this wonderful help you have given....Thanks for all this wonderful help you have given. <br /><br />My computer grinds to a halt when I import a second match file - I have tests from five full siblings that I would like to combine. In your instructions above you say change the testid column to "zzz delete” and you show in the picture row 1 is left as "testid". later when you describe the import you say "Which edge column is Vertex 1: zzz delete" I dont see an option for zzz delete just testid - have I done something wrong here ou is this incorrect.<br />I have stopped auto recalc and copied formulas to values but it just grinds to a halt and I have to crash out of the Excel task.<br /><br />I was wondering could you combine the match and icw files of my siblings prior to importing by doing the merging in excel and how I might go about this if it is possible?<br /><br />Thanks again for these wonderful tutorial style instructions.<br /><br />Anonymoushttps://www.blogger.com/profile/17636518725165921265noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-323074816132370382017-09-06T22:21:49.799+10:002017-09-06T22:21:49.799+10:00There are various ways you could extract the new r...There are various ways you could extract the new records, but they're are a bit complex.<br />Do you have the problem when you load either file, or only when you load the match file? <br />I assume you've cleaned out extra lines and made sure that no formulas are calculating as you import. The other thing that may help is to load the new records first when you open the worksheet, before you refresh the graph. Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-42982803581834770202017-09-04T02:53:04.312+10:002017-09-04T02:53:04.312+10:00Thanks so much for these articles! Unfortunately, ...Thanks so much for these articles! Unfortunately, my laptop doesn't have enough processing power to deal with adding my sister's matches this way. What I've done instead is to treat mine as an update to hers -- so my info overrides hers, rather than the other way around. That works visually, but I lose the ability to see both of our match levels on the chart. <br /><br />My system also stalls if I try to update more than once, so when we have a number of new matches, I need to redo the whole chart! <br /><br />Is there a way to select only a few new matches and add them? That might not crash my Excel as abruptly. <br /><br />Thanks again! Shelley Bankshttps://www.blogger.com/profile/04884586311645350859noreply@blogger.com