Guides

[indent][font=Century Gothic][size=5][b]Update[/b][/size][/font][/indent] Been a while and although new genes were added (also to the sheet) I somehow forgot to post it here :'D New genes are, as usual, automatically added to your sheet so no input needed. Also a small correction which sometimes cause an error in the hidden coding part of the Match Checker. [quote name=D17] =IF(C8="", "", INDEX(REF!$B$7:$B, MATCH(INDEX(SPLIT(RIGHT(C8, LEN(C8)-FIND("tert=", C8)-LEN("tert=")+1), "&"), 1, 1), REF!$A$7:$A, 0))) [/quote] [quote name=D18] =IF(F8="", "", INDEX(REF!$B$7:$B, MATCH(INDEX(SPLIT(RIGHT(F8, LEN(F8)-FIND("tert=", F8)-LEN("tert=")+1), "&"), 1, 1), REF!$A$7:$A, 0))) [/quote] [center][size=3]@ShadowFlamel[/size][/center]

@Pinguin I put in my dragon scry img link but it all just says '#Ref'? It also says some Basics for my dragon (she has no basics) and for the mate it says a random element and a few '#Value's? Please help, thanks! I don't know what I did wrong, I didn't change the code or anything.

@CrystalDragon14
I've tested it with several different scries, from modern to ancients, old genes and new ones (cause I noticed I forgot to add Mosaic and Breakup :'D ). It does show some #Value errors with the missing genes, but not Basic genes. Also no #Ref errors.

Either describe more detailed what happened, where it happened and how you made the error appear or share your sheet with me with the error "active" please :D

@Pinguin Sorry for the long wait, the internet went down in my area! [img]https://i.imgur.com/oKMnXZw.png[/img] Also, for some reason my mouse doesn't want to work... I'll figure that out. Edit: Sorry if the image is a little blurry!

@CrystalDragon14
That picture doesn't help me much.
What does the #REF! error say? how does your REF tab look like? The tab is hidden, you need to unhide it at the striped square symbol at the bottom left.

Alternatively you could try making a new copy. I just did that with another Google account and can't find any errors.

@Pinguin Not sure what happened, but the copy worked... yeah probably something with my ref sheet. Thanks for your time.

New genes got added but updating for that seemed kinda unnecessary. They get added automatically without any manual input from anyone else but me ~

So this is a function update :D
A new addon was ... added. An offspring previewer displaying up to 90 kids with set conditions. They are not randomised as the three kid-scrys in the other tabs! The tool is aimed to have a controlled preview.