And WE will have a table at the celebration. Stop by and say Hello! And enjoy the good food while you are there. In Salinas!
Monterey County Historical Society is having a BBQ !!
Leave a reply
Counting SNPs in a raw data file with Excel
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…
Calculating birth dates for Census records and etc.
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). 
AncestryDNA and Other Goodies (a test covering this will be given at the DNA Sig)
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:
- Parent/Child
- 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
https://www.legacytree.com/blog/understanding-ancestrydna-matches
Understanding Your Relationship to DNA Matches After Autosomal Testing– Colleen in YouTube (a college assignment!)
https://www.youtube.com/watch?v=dZ6yme0t-ZA
First Steps When Your DNA Results are Ready – DNAeXplained
ThruLines Tidbits by Jim Bartlett at Segment-ology
https://segmentology.org/2019/08/01/how-does-thrulines-work/
https://segmentology.org/2019/07/29/a-few-thrulines-are-false-and-some-are-misleading/
https://segmentology.org/2019/07/29/thrulines-helps-with-y-dna-and-mtdna/
https://segmentology.org/2019/07/29/add-thrulines-info-into-match-notes/
https://segmentology.org/2019/07/29/thrulines-and-clusters-and-snowballs/
https://segmentology.org/2019/07/29/use-match-notes-from-thrulines-to-identify-clusters/
https://segmentology.org/2019/07/29/thrulines-has-x-ray-vision/
https://segmentology.org/2019/07/29/help-thrulines-by-adding-children-and-grandchildren/
https://segmentology.org/2019/07/29/thrulines-finds-your-common-ancestors/
DNA Sig Meeting August 10th at 10:00am
23AndMe recently released a trait report looks at a customer’s likelihood of having a fear of public speaking. While a fear of public speaking, also known as glossophobia, doesn’t present any serious health consequences, it can hamper career advancement or your speech at the next DNA Sig.
The issue was that my wife and I tested at 23AndMe way back in 2010 on their chip #2. The SNPs necessary to get new trait reports, including glossophobia, were not included on that model. 23AndMe is now using chip #5. We needed to upgrade.
June 24th, 23AndMe sent us an email saying we could purchase an Upgrade test using chip #5 for only $125. This would include, of course, both Health and Ancestry options. Needless to say, both Sandra and I purchased the upgrade. Our DNA extraction is in process, with expected due date being August 22.
I don’t need a DNA test to prove that I have glossophobia. No matter, I am still going to monitor our monthly DNA Sig this Saturday Aug 10 starting at 10:00 am.
Topics covered by me at the Sig will be:
• A case study in which I solved an adopted person’s quest to find her father (in my wife’s family)
• More about the 23AndMe upgrade option
• The new 23AndMe collaboration with FamilySearch which is in beta test now
• Some brief mentions for beginners in their genetic genealogy quest.
Since I am glossophobic, I will also bring a load of questions for the group to answer! And if you have questions about your recent DNA test, please bring them along. We are depending on you to cover for me…
“It is the ultimate luxury to combine passion and contribution. It’s also a very clear path to happiness.” – Sheryl Sandberg
Monthly Meeting – August 1, 2019 – “Brick Walls in My Genealogy? How Did They Get There?” by Shelley McFadden
At some point, every family historian encounters a barrier in their genealogy research. In genealogy, these barriers are known as “Brick Walls” and they can often appear impossible to work around. We must remember Genealogy is a research field concerned primarily with accurately reconstructing forgotten, unknown or hidden identities, relationships, activities of families, individuals, and more. It borrows from fields like anthropology, economics, genetics, history, law, mathematics, and sociology. Many pursue family history for pleasure and to learn more about their family ’s background, while most family historians, consider accurate results important. Genealogy is “Problem-Solving” – not a straightforward primary information with direct evidence. We will learn 16 reasons why we create brick walls in our Family Genealogy, and a disciplined approach to solving them.
Shelley McFadden holds a BFA in Fine Arts at the University of Hawaii and is a retired RN from CHOMP. She has worked for over 40 years on her family genealogy. Her focus Pennsylvania, Maryland, Delaware, North and South Carolina, New York, Ohio, and New England. She has served as a past President for Monterey County Genealogy Society, and is currently serving as 1st Vice President-Programs Chair. She is a member of Commodore Sloat Chapter, and associate member of Aloha Chapter of the DAR. A Charter member of the Colonial Dames in Hawaii. She specializes in Newspaper Research.
Doors open at 6:15 pm, the meeting starts at 7:00 pm. We’ll see you at the Family History Center, 1024 Noche Buena, Seaside, CA., left rear of building.
“For the oldest man in the world, everyone that existed on the entire planet when he was born are now dead.” – Reddit
