free pedigree generator & coefficient of inbreeding (coi) calculator

Free Pedigree Generator (Google Sheet)

It’s really important for anyone breeding animals to track pedigrees and be mindful of the coefficient of inbreeding. Too much inbreeding results in smaller litters, undesirable recessive genes and deleterious effects on the breed.

Generating pedigrees and tracking lineage, however, is much easier if you have the proper tools. That's why we want to share (for free) what we use to keep track of our herd, lineage, and generate professional pedigrees, and easily calculate the COI of litters.

When we resumed breeding, we wanted an easier way to generate pedigrees and calculate the coefficient of inbreeding. Previously, I had used an excel spreadsheet that required a bit of manual work. This time, I wanted something that I could access from anywhere (would not be lost entirely if something happened to my computer) and generated professional looking pedigrees. I also did not want a pricey website that I had to rely on to work.

Thankfully I found the Google spreadsheet by Wolvden #436, inspired by Kenosha Rabbits. I was able to expand this spreadsheet to suit up to 8 generations, tailor it to hedgehogs, and create a printer-friendly pedigree page. I was also able to elaborate on the code for pasting on the  NABSSAR COI calculator to include up to 8 generations as well.
​
The resulting Google sheet is tremendously helpful for our breeding program and I wanted to make it available, free, to any breeder looking for a similar resource. 

Free Pedigree Generator (Google Sheet)

You do not have to download a program or sign up with your email. Once you click on the link, you will be directed to the Google sheet. Click File > Make a Copy, then you will have your very own version to use as you please. If you share this Google spreadsheet, please be sure to give credit to those who helped make this possible - Wolvden #436, Kenosha Rabbits, and now Penny's Prickly Pigs.

Note: you will not be able to edit the Google sheet until you make a copy for yourself. 

There are a couple of example hedgehogs in the Breeding Registry as a sample, you might recognize them! I’ve included some how-tos and basic tips in the first sheet, but let me know if you run into any bugs or things you would like to see added.
​
Hopefully one day, I can get the Coefficient of Inbreeding (COI) computed automatically within the sheet. If you already have the formula for COI calculations, feel free to share.