Automatic Genotype Database Add-On (AGDA)

V1

Setup and Use

Download

HERE

**If AGDA V1 is not functioning for a particular horse I can almost guarantee that it is a problem with how the genotype is written for that horse. Please check it against the genotype reference sheet before writing a comment about it!**

Setup

  1. Copy the code in the white cells of row 3 found in the spreadsheet above.
  2. Open your own copy of Elsie’s Manager Sheets (found here if you don’t have them yet) and navigate to the GenotypeDatabase tab.
  3. Locate cell C3 and click it.
  4. In the top left of google sheets. go to Edit>Paste Special and select “Paste Formula Only”
  5. With cell C3 still selected, hold shift and click cell AH3, this will select that cell along with all cells between C3 and AH3
  6. In the bottom right corner of  cell AH3 you should now see a little blue square, when you hover over it your cursor will turn into a crosshair
  7. Press and hold the left mouse button when your cursor turns into the crosshair and drag your cursor down. This will produce a dotted line forming a rectangle showing how far the formula is being copied.
  8. Release the left mouse button when you have reached the bottom of your sheet
  9. You’re Done!

Genotype Reference

        Due to the way that this code works, the genotype for each horse needs to have its alleles written in a certain way. Please refer to the link below when writing your horse’s genes to make sure that each is written correctly. *Note, you may use any divider between genes that you please (example: EE/AA and EE | AA both work perfectly)

GENOTYPE REFERENCE LINK

V2

Setup and Use

Download

HERE

Setup

  1. Open your own copy of Elsie’s Manager Sheets (found here if you don’t have them yet) and navigate to the GenotypeDatabase tab.
  2. Delete all the letters in C4 to AH4 and below.
  3. Select all the white cells of row 3 found in the download spreadsheet above (they all say #REF) by clicking C3 then holding shift and clicking AH3. Afterwards do ctrl+c.
  4. Go back to the your Manager Sheet’s GenotypeDatabase
  5. Locate cell C3 and click it.
  6. In the top left of google sheets. go to Edit>Paste Special and select “Paste Formula Only”.
  7. Check to make sure cells C3 to AH3 contain code, if they do not, copy and paste it individually from the download spreadsheet into your copy of the stable management sheets.
  8. You’re Done!

Genotype Reference

        No longer needed for V2! Want to write eE instead Ee? aA instead of Aa? Go ahead!