@Apocracy Ah! I didn't know that! I've been using excel for years and years and so I'm still learning things that google sheets makes much much easier

this sheet is fantastic! alas, i have bugs? to report. i was fiddling around with the relationship log (not gonna chart everything since it's still wip, but just getting a handle on what it's doing), and i have two pieces of behaviour i wanted to report (but if they're already fixed in the full version, apologies!):

• i have two litters born on the same date that the relationship log seems to be parsing as one litter, with no apparent way to mark them as separate
  
• is there to be a way to add extra "child" slots? two litters of four would be enough to run out of space
  

EDIT: this one isn't in the relationships chart, but i'm cross-referencing the gene sequencing with this guide.

and for dilute testing, the sheet says "not grey (tan)" and "not cream (beige)".

the guide and sheet agree that Tan is a Black-Full-1 colour (being possible to confuse with Silver), but the guide says Apricot is the Orange-Full-1 (and therefore not the dilute we're looking for), and Beige is the Orange-Dilute-1

i have no idea if the typo is on your sheet, or the guide i'm reading, or i'm just having a colossal brainfart, but i figured i'd add it since it stumped me regardless!

Regarding the Dilute test:
The image is correct, showing an Apricot (Orange-Full-1) but the text is wrong, as it should in fact be Apricot rather than Beige named there.

New small issue I found: If White Type is N/A (due to being untestable, as a Null cat with no white), it 1.) complains about N/A not being acceptable on the dropdown, which I was able to fix by editing the dropdown, and 2.) it prints N/A in the genetic string where the white type goes, which seems like a complicated code thing?

Is there supposed to be no Y option in the unknown (???) sections or is this just a thing that hasn’t been added to the sheet yet?

@Lykos
Those genes don't impact Not-Cats, and they haven't been fully incorporated into the site details - we don't have a comprehensive list of potential values or how they will behave. coding around them right now doesn't make much sense, especially since the only way to see them is with a Family Tree item.

@Gryphonlady

Was asking because it's just not in the list. The option to add them in the genetic strings is available whether it's viewable genetically or not. If Apocracy wants to add it as a side thing to the list of possibilities in the meantime, I figured I'd give the information since I hadn't seen a Y in that string yet myself (at least until I revealed that specific cat). I am aware it's not visible yet and that it doesn't matter but, given the string addition is in the sheet, I think that doesn't really matter anyway because the list is already there. Like I say, it's up to them. I'm simply providing the information that another option exists.

I wasn't asking to add coding around it but, all things considered, there already is some coding around it given that it has a list you can choose from and shows in the full string display. I'm not asking for anything new or complicated or, really, in general. I just was wondering if it was known and purposely left out for a reason I'm unaware of (such as it being something people have only seen in, for example, custom cats), or if it just wasn't discovered prior.

Uh hello, I seem to have done a whoopsy and backspaced the "Looking for" result box in Recessive testing (sheet 3 coordinate H12:I12) Would there be any way for me to paste the code back in or should I redownload the entire sheet?

@Briggsnotmyers

Paste this into the cell:


That will restore the cleared code and everything should work again :)

That's done it you absolute wizard!!!!