Hi, I'm fairly new to the game and don't totally understand dominant and recessive traits.

I'm making an Excel document for pets and breeding.


_{Image of the breeding page}

Sheet 1 is a list of all pets and their traits, and whether the trait is Carried or Visible (denoted by one x or two x's).

Sheet 2 is the bulk of the project. In it, I'm setting it up so a user can type in the pet ID for the two parents (yellow part), and then output all permutations of carrying and visible traits. Plus, when the IDs are in, then you can type in what trait or traits you want in the offspring (blue part) and it will give you the odds of getting that particular trait and the odds of all traits you are wanting.

But here's the snag: Before I do the odds set up, I need to have an equation to figure out which trait the child will get.



Carried is easy. When one is empty, use the non empty trait in the Carry slot. And obvious Visible ones are easy, too. When Parent 1 = Parent 2, put the Trait in Visible.

But when the parents both give a unique trait, how can I do this in Excel? I was told by the friend who let me use her Luporas for gene testing in the doc that the trait on top of the trait dropdown in the pet generator is the one that's more dominant. Can anyone confirm that's how it's picked, and if so, can anyone with Excel knowledge give me ideas for how to pull this off?

I'm thinking a Sheet 3 with a list of species and their traits, assign each a number, lookup the numbers for the Parent 1 and Parent 2 traits, then if Parent 1 trait > Parent 2 trait (higher up on the dropdown), that's visible, otherwise the Parent 2 trait is visible.

Hmmm I just figured out the whole AC, CN, etc etc stuff, so actually this project is still very doable.

Just going to need more lookups! :D

Your friend is correct. For any trait, A will "Mask" B if the pet has both an A and a B in the same slot, A will also Mask C and any later letters, B will Mask C and any later letters, etc.

If a pet has two different letters in the same slot, there's a 50/50 chance of an offspring getting either one. This can lead to some surprises if both parents have a Masked gene in the exact same slot. An offspring could inherit both Masked genes and have a Visible trait that neither parent has!

Are you familiar with Punnett Squares? They work for both real genetics and Sylesti genetics. The Wikipedia explanation of Punnett Squares is actually fairly good.

Yeah, I have been using the squares as the basis for the logic behind my functions. It took until I tried searching for pets on sale to realize that the game actually has masked traits, not just visible or carried. ABs and the like are going to be complex since I'll probably need a list of every trait for every species to use in a lookup function... and there are a lot of traits ;.;

You should try lunemara as a sample species, they have some of the least traits compared to other pets o:

I'm very interested in how you'll get the excel spreadsheet to work :) I wish I was that good at excel aha

I'll be sure to post an update once I have it working! :D I have a math degree, so Excel is second nature at this point haha

And thanks for the tip on the species, I'll look into them. I started alphabetically and... yeah... so many letters on Gene 2 of the Aeridini.