tag:blogger.com,1999:blog-4726802159327032874.post7174606102665750227..comments2024-02-21T05:48:18.552+11:00Comments on Twigs of Yore: Visualising Ancestry DNA matches–Part 1–Getting readyShelley Crawfordhttp://www.blogger.com/profile/15008715347583341427noreply@blogger.comBlogger65125tag:blogger.com,1999:blog-4726802159327032874.post-25478450230500980052018-07-21T16:36:15.951+10:002018-07-21T16:36:15.951+10:00Not if you don't want to :-)Not if you don't want to :-)Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-49766957715539465482018-07-17T06:15:06.587+10:002018-07-17T06:15:06.587+10:00Once I have downloaded everything per above, do I ...Once I have downloaded everything per above, do I need to continue my monthly subscription to DNAGedcom?Anonymoushttps://www.blogger.com/profile/07664225448370802918noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-20295167573601657252018-07-17T06:14:04.884+10:002018-07-17T06:14:04.884+10:00Once I have downloaded everything per above, do I ...Once I have downloaded everything per above, do I need to keep my monthly subscription to DNAGedcom?Anonymoushttps://www.blogger.com/profile/07664225448370802918noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-74347820296406321832018-01-24T14:51:43.746+11:002018-01-24T14:51:43.746+11:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/00965826982921416294noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-80731235095315707802018-01-24T14:50:27.937+11:002018-01-24T14:50:27.937+11:00I have this problem too. I don't have a Faceb...I have this problem too. I don't have a Facebook account. How can I resolve the problemAnonymoushttps://www.blogger.com/profile/00965826982921416294noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-27114436721717879262017-11-30T21:43:46.434+11:002017-11-30T21:43:46.434+11:00Hi Anonymous, I'd suggest contacting DNAGedcom...Hi Anonymous, I'd suggest contacting DNAGedcom about that. One way to do so is through the user group on Facebook: https://www.facebook.com/groups/DNAGedcomUserGroupShelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-6836406146122838902017-11-30T08:45:47.204+11:002017-11-30T08:45:47.204+11:00Thank you for this information! I am stuck gather...Thank you for this information! I am stuck gathering the matches on dnagedcom. I downloaded the client and I begin the process of gathering the matches and after about 2% have loaded, I receive the following message: "object reference not set to an instance of an object". I have basic computer skills and I have no idea why I am getting this message. My match gathering then ends after I click OK. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-83210713692204390212017-11-21T22:02:09.755+11:002017-11-21T22:02:09.755+11:00You're very welcome :-) I'll just mention ...You're very welcome :-) I'll just mention that the tool isn't mine, only these instructions. I'm very pleased that so many people have been able to take the step into something they didn't realise they could do.Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-42693043260514639172017-11-19T15:48:32.588+11:002017-11-19T15:48:32.588+11:00I have just completed the construction of the Exce...I have just completed the construction of the Excel Spreadsheets and have imported my ancestry.com DNA data - my advice is to do it very slowly and follow the instructions Step by Step - one step at a time - if you rush it you will not succeed. When you succeed you will be rewarded with an outstanding representation of your DNA data. Thank you so much Shelly - very impressive. Well done.Anonymoushttps://www.blogger.com/profile/03257463157906695135noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-63112090054836169922017-11-18T20:19:20.678+11:002017-11-18T20:19:20.678+11:00I have just accessed this page for the first time ...I have just accessed this page for the first time and wanted to say you are amazing. I have a very good working knowledge of Excel and to be able to combine my love for genealogy, DNA, computers AND Excel is a dream come true. Thank you so much for making this available.Anonymoushttps://www.blogger.com/profile/03257463157906695135noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-15225514628109380502017-11-18T00:06:23.639+11:002017-11-18T00:06:23.639+11:00I'd love to be able to try this, another Mac u...I'd love to be able to try this, another Mac user though :(. I will say the Matches and ICWs downloaded from Ancestry lickety-split with DNAGedcom. Now I'm off in search of a tool, will take a look at Gephi.<br />Andrew McKnighthttps://www.blogger.com/profile/17629786233848002649noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-21060219029842494162017-10-22T08:25:18.404+11:002017-10-22T08:25:18.404+11:00Not for the purposes of making the chart. Not for the purposes of making the chart. Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-51076854760605502382017-10-22T08:15:51.575+11:002017-10-22T08:15:51.575+11:00Is there any reason to also process the tree file?...Is there any reason to also process the tree file? --Ken WatersAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-58909772572652278452017-09-06T06:36:47.023+10:002017-09-06T06:36:47.023+10:00NodeXL is Windows only, unfortunately. I've he...NodeXL is Windows only, unfortunately. I've heard that it works on a Mac under Parallels. Alternatively there are a number free programs specifically for network graphs that do run on a Mac. Gephi seems to be popular. It can do most of the things I cover in these posts. Some it does better, some with more data wrangling before loading, but some not at all. I hope you find a solution!Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-19929725861824760262017-09-06T02:43:00.900+10:002017-09-06T02:43:00.900+10:00I'm having this same problem trying to use the...I'm having this same problem trying to use the Basic Excel template but owning a Mac. Did you ever find a solution?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-86239813159861750492017-09-01T12:09:07.059+10:002017-09-01T12:09:07.059+10:00Deleting the small match records won't help, a...Deleting the small match records won't help, as they'll still be in the ICW file and show up as edges. You can use the dynamic filter option to temporarily hide them, or 'skip' them to hide them completely. Also try using different clustering algorithms. The Wakita-Tsurumi clustering algorithm usually break it up the most. Have a look at the part 5 and 6 posts for more options that may help.Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-82487213876068857242017-08-30T02:35:29.500+10:002017-08-30T02:35:29.500+10:00Thanks, yes I found it no problem now, but a coupl...Thanks, yes I found it no problem now, but a couple of questions.<br />1. When I downloaded the ancestry data I downloaded everything. Took days. Can I just delete lines from the csv below 10 cm ( or higher) to cut down the number of points. First time through it was just a blob.<br /><br />2. I am not an excel illiterate, but is there a clean way to clear the spreadsheet out and start over?Anonymoushttps://www.blogger.com/profile/12156022498345051187noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-78806911268302939422017-08-27T10:27:41.902+10:002017-08-27T10:27:41.902+10:00Hi Gene, it should work. See my reply to another c...Hi Gene, it should work. See my reply to another comment:<br /><br />http://twigsofyore.blogspot.com.au/2017/07/visualising-ancestry-dna-matchesindex.html?showComment=1501805817748#c561069917028592215Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-91265977378083443582017-08-27T10:07:44.943+10:002017-08-27T10:07:44.943+10:00Shelley, should this nodexl work on excell 2013? I...Shelley, should this nodexl work on excell 2013? I downloaded the basic program, but can't find the template anywhere. Any suggestions?<br /><br />GeneAnonymoushttps://www.blogger.com/profile/12156022498345051187noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-40423510070034875592017-08-08T03:15:30.340+10:002017-08-08T03:15:30.340+10:00I administer my sister and 2 of my children's ...I administer my sister and 2 of my children's DNA tests at Ancestry. Do I download the DNAGedcom files for all of them or just mine to XLNode? Thank you sooo much for sharing this system! I am really looking forward to exploring it. :)Brenda Romannoreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-1544192704462386712017-08-05T05:12:04.005+10:002017-08-05T05:12:04.005+10:00This just took me to the usual DNAGedcom connectio...This just took me to the usual DNAGedcom connection client page. I'm wondering if there is a mac version of the Excel Template, ie to use on Numbers?Genemonkeyhttps://www.blogger.com/profile/01115284860845570147noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-77035121260158076942017-08-04T12:56:25.318+10:002017-08-04T12:56:25.318+10:00Hi Sarah, sorry I missed this comment earlier. It ...Hi Sarah, sorry I missed this comment earlier. It won't work on the Mac version of Excel as I understand, but some people have said that they have been able to use it with Excel running under Parallels.Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-76863147327908863292017-08-04T11:55:54.078+10:002017-08-04T11:55:54.078+10:00I'm using it in Excel 2016 without issue.I'm using it in Excel 2016 without issue.Renehttps://www.blogger.com/profile/06394075773510554202noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-62343902432130376942017-07-30T15:47:11.889+10:002017-07-30T15:47:11.889+10:00Is there any way to get this to work using Excel o...Is there any way to get this to work using Excel on an iMac?ArgyllLasshttps://www.blogger.com/profile/17886253347274814201noreply@blogger.comtag:blogger.com,1999:blog-4726802159327032874.post-18159997667243316962017-07-21T10:45:35.948+10:002017-07-21T10:45:35.948+10:00It's supposed to work with Excel 2016. Try run...It's supposed to work with Excel 2016. Try running it as admin? And check the information on the NodeXL home page about adding it to trusted sites, or any other help that page can offer. I hope it will work for you. Good luck! Shelley Crawfordhttps://www.blogger.com/profile/15008715347583341427noreply@blogger.com