Question about Creating a Compatablity Sheet

[kayotica]

Hello.

My kids been playing a pet game where you can breed a boy and girl creatures to make unique baby creatures.

I am trying to create a spreadsheet in excel based off the data ive gathered about each of the creatures.

I need to know how to say if creature A is only compatable with creature b, e, & g based off of specific traits that make them breedable.

Also theres a stat they get that increeses as they are interacted with that increeses there chances of breeding more unique creatures, that i would like to beable to use as a ranking for who would have the best chances of creating a unique creature.

Plue theres a need for elimination, as you can not breed related creatures so that would need to be something to look at as well.

I know this sounds probably like alot of work for a kids game, but it will make the 15 min pause between the "mom what is compatable with this one again?" questions so much.. less.. fustrating.

Thankyou for everyones time,
Look forward to hearing any ideas or suggestions that come to mind

Kayotica

 

[GlennUK]

You haven't given enough information about what you are aiming for in Excel. You may get some replies if you give data and examples.