PENNY'S PRICKLY PIGS

  • Hoglets
    • Payment
  • Breeding Schedule
  • Waiting List
    • Adoption Application
  • Our Prickly Pigs
  • The Hedgehog Blog
    • Hedgehogs As Pets
  • Contact Us
    • FAQ
    • Facebook
    • Instagram
    • Pinterest
  • Hoglets
    • Payment
  • Breeding Schedule
  • Waiting List
    • Adoption Application
  • Our Prickly Pigs
  • The Hedgehog Blog
    • Hedgehogs As Pets
  • Contact Us
    • FAQ
    • Facebook
    • Instagram
    • Pinterest

The Hedgehog Blog

free pedigree generator & coefficient of inbreeding (coi) calculator

1/23/2022

2 Comments

 
Picture
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.
2 Comments
Veerle Dewit
5/20/2022 10:27:46 am

Hi, I would like to use this sheet for breeding dogs. Can I adjust it?

Best wishes,
Veerle

Reply
Penny's Prickly Pigs link
5/20/2022 12:04:26 pm

Veerle,

This sheet can definitely be adjusted to suit your needs. First, you will want to make a copy. Go to the sheet, under file, then click make a copy. From there you can edit anything as you see fit. If you have any questions, feel free to reach out to rachel@pricklypigs.com.

Rachel

Reply



Leave a Reply.

    Author

    Rachel, the owner of Penny's Prickly Pigs has been breeding hedgehogs since 2008, and owned hedgehogs off and on for 23+ years. We maintain a small herd to focus on quality and personality.  We track pedigrees on all of our hedgehogs. 

    You Might like

    Hedgehog Care: Everything you need to know

    How to prepare a hedgehog cage

    I'm on the waiting list, what next?
    Adoption Application

    Categories

    All
    About Hedgehogs
    Breeding
    Hedgehog Care
    Waiting List

    Archives

    February 2022
    January 2022
    December 2021

    RSS Feed

Hoglets

Hoglets
​Breeding Schedule
Pricing

Prickly Pigs

Our Hedgehogs
​The Hedgehog Blog
Contact
FAQ

associations

Hedgehog Breeders Alliance
Hedgehog Welfare Society
Hedgie List
NAHHI
© COPYRIGHT 2015. ALL RIGHTS RESERVED.