DNA spreadsheet models and what they show

[dtcoulson]

(Delete if not suitable for this topic page)

Last year I became interested in certain questions to do with DNA inheritance and realised that a good way to solve those problems was to set up my own mathematical model in a spreadsheet. This led to more questions and eventually I had three kinds of spreadsheet model addressing different questions in inheritance. I thought this would be worth sharing so I fleshed it out into a full tutorial on DNA matching and what to expect when you look at the centimorgan values associated with distant cousins.

Take a look if you are interested.

https://docs.google.com/presentation/d/1u3PkMVIF19BjXmGxi2tWL7TiPK0JU4pG/edit?usp=sharing&ouid=103690850444052751162&rtpof=true&sd=true

-DC

[Ruskie]

I’ve only had a quick look so far, but you’ve certainly put a lot of work into this and it looks very professional. I’m sure it will be useful for many. Well done, and thanks for sharing. 

[scotmum]

I applaud the work that has obviously gone into this.

I think your statement:

I am a hobbyist who finds it difficult to let go once my curiosity is aroused

could equally apply to a great many of us Rootschat members.

 

[pandacub]

Thanks for sharing this.  You have clearly put a lot of work into it and it looks very useful. 

[julianb]

I thought this would be worth sharing so I fleshed it out into a full tutorial on DNA matching and what to expect when you look at the centimorgan values associated with distant cousins.

Still working through it between Sunday morning chores 

I've tried to explain the source of an individual's DNA by comparing it to lottery balls, but I think your deck of cards is much better!  Thank you for that 

[Biggles50]

Most Excellent.

[KitCarson]

Hi DC,  Thanks for sharing.

Kit

[SouthseaSteel]

Most excellent. thank you for sharing.  In a world awash with expertise, its good to see some wisdom and common sense too.

[julianb]

Still working through it between Sunday morning chores 

I've tried to explain the source of an individual's DNA by comparing it to lottery balls, but I think your deck of cards is much better!  Thank you for that 

Chores done!

It's interesting to see a theoretical breakdown on how DNA might pass through the generations, because the data drawn from test results on eg Ancestry is distorted by being dominated by people who volunteered to take part!

I've set up matches spreadsheets (relationship matrix) for certain family groups so I think I'm going to explore rearranging these in the way you have done. Thank you for that practical tool

It did strike me that your endogamy calculations might be impacted by higher levels of infant mortality and life expectancy in victorian times and earlier, thus reducing the overall numbers passing DNA on.  To a degree is that probably academic because it's value is as an illustration of scale rather than an underlying rule of DNA?

And finally the cake cutting model, and it's cupcake enhancement, is again a very good explanation to kick my lottery balls even further into touch.  Great work, sir