At the DNA Sig meeting in May 2019, I showed an Excel file containing my MyHeritage Raw Data file with a table of quantities of SNPs per Chromosome. Some people wanted to know how to do the same for their data. I am finally getting around to telling how.
To do this requires a few steps.
- Download your data file from your provider.
- Uncompress the ZIP file. Usually the raw file is a CSV file.
- Import the CSV file into Excel
- Delete the first few descriptor lines.
- Put column headings into the file.
- Save the file as an Excel file
- Create a NAME Range over the Chromosome column. In the snapshot below, I created a NAME called ALLDATA which covered all of my data. Do whatever is easier for you.
- Manually create column F, called CHROM below, which contains just a number for each Chromosome. You will need 1-22.
- In column G, called COUNT below,, use the COUNTIF function over the NAME Range (ALLDATA) to count the associated value in column F. Copy that formula down through the 22 rows.
- Add a SUM at the bottom of column G to verify totals
It is harder to write this how-to post than it is to do the actual tally. If you have a spreadsheet program with a COUNTIF function, go ahead, do it for your data. If you have tested at multiple companies, you could compare totals for each! Enjoy…
This little how-to item shows formulas in Excel for calculating a birthdate range given a date and age. The formula for F7 and G7 are shown above. After setting it up, plug in a date (B7) and age (D7).
Ancestry DNA for someone else, like child, parent, etc. who doesn’t want to be bothered with an account:
- You can create an e-mail account in their name, although you will control it. Any of the free email providers will do.
- You do not need to purchase Ancestry subscriptions for them, particularly if you already have one for yourself. When you activate the DNA kit, that will create an Ancestry account, but without a subscription. You can then – acting as the third party – grant yourself permission to manage their account.
AncestryDNA has 7 different groups for predicted relationships:
- Immediate Family (full siblings)
- Close Family (half siblings, grandparent/grandchild, aunt/uncle/niece/nephew)
- 1st cousin
- 2nd cousin
- 3rd cousin
- 4th cousin
- Distant Cousin.
Here are some helpful sites explaining some of this DNA stuff. Not in any special order.
Understanding Your AncestryDNA Matches – LegacyTree
Understanding Your Relationship to DNA Matches After Autosomal Testing– Colleen in YouTube (a college assignment!)
First Steps When Your DNA Results are Ready – DNAeXplained
ThruLines Tidbits by Jim Bartlett at Segment-ology
The other day I tried to share my tree in Ancestry.com with another Ancestry member. I used the Ancestry user name during the Share steps and it did not work. I have shared my tree successfully in the past and so was confused about what was wrong. I sent a note to Customer Services and received a reply within a couple of hours. I decided to share the answer here in case this has stumped others in the past..
Ancestry has both usernames and display names. Some people choose to show their display name in place of a username which appears to be the case here.
In order to share your tree, you’ll need either the username or email address which she can find when she click’s her display name in upper left corner while she’s signed in and share either of those with you so that you can send the invitation.
” Someone’s sitting in the shade today because someone planted a tree a long time ago.” – Warren Buffet
“Now I’ve heard everything!”. The older one gets, the more often one might say that. Yet the world keeps surprising. This morning I discovered that someone sells gravestone cleaning solution kits!
Don’t get me wrong, I think it is a great idea. They say that solving puzzles causes a dopamine rush which in turn causes addictive behavior. Which, they go on to say, is how genealogy can become addictive! Let me warn you, finding “lost” tombstones can also become addictive.
This picture is known as “The Genealogist Adventure Park.”. A copy of it is hanging in the Monterey Family History Center in Seaside.
This picture is of a genealogist getting a dopamine rush!
And this picture is of a tombstone cleaning kit which is available to buy at Billiongraves.com. Next time you go sleuthing for someone’s grave site and you know it is going to be an old one, perhaps you should carry a bottle of D/2 Biological Solution. Just to honor your ancestor, of course.
40% off Sale Price
How To Clean
What makes this especially rewarding is that just last night at the MoCoGenSo Board meeting, we discussed creating a “tour a graveyard” excursion for locals in the Monterey County area. If you are interested, contact any Board member. See Board of Directors
“You know you’re a genealogist if you’ve ever had your photo taken in front of a tombstone and you were actually smiling!” — my Quote excel file
A few years ago I taught a class here about using Google for searching, genealogically speaking. The other days, I ran into a pile of handouts that I had prepared for that class that were not given away. I will drop them off at the FHC for people who are not familiar with Google search syntax items. The syntax has not changed over the years.
I am also including a PDF of that handout here: GOOGLE SYNTAX.
I recently opened a Pro account at Geni.com and was reminded that anyone can search specifically in Geni’s One World Tree using Google for free! Using syntax described in the above file, just do a search that looks like this. The plus sign restricts it to Geni only.
+site:geni.com “andrew robeson” OR “andy robeson”
“Study predicts more dead Facebook users than living by 2070.” – Oxford Internet Users
Follow-up to our DNA SIG meeting yesterday:
We discussed the Cookie problem when using ThruLines in AncestryDNA. It has been posted in the web that clearing cookies before going into Ancestry will solve the disappearing Thrulines problem. But many people do not know how to clear their cookies! We know AncestryDNA is working on the issue, but they can’t rush a fix since this is their bread-n-butter system.
Suggestions have been made as a workaround that should help those who don’t know how to clear their cookies. In Chrome simply open an Incognito window by clicking on the 3 dots in upper right corner and then click the menu item before going into Ancestry. In Firefox, open a Private window via similar right click menu. This should work in all OS types, Windows, Apple, Linux.
See Kitty Cooper’s blog for more information about ThruLines in general and the note about the work around.
“The infantry is always ahead of headquarters.” – James Barksdale