Guides

[quote name="Sternenstaub12" date="2024-10-30 11:37:53" ] I really love your sheet. I started using it and i really love it. Thank you! [/quote] @Sternenstaub12 I'm so glad!!! :D

[quote name="Horsedog3799" date="2024-10-30 12:45:59" ] [quote name="Horsedog3799" date="2024-10-27 16:29:05" ] @UhOhItsDorian Hi there! I'm loving the sheet so far. I have so many projects that I had to put on hold because I was confused about tracking the colors/relationships. I do have one problem with the sheet though. For whatever reason, on the verdict tab, as soon as I try to enter a dragon name some of the cells give the error message "Did not find value 'dragon name' in MATCH evaluation". I'm not sure what the issue is, I can link my sheet if you need to take a look. Thank you! [emoji=familiar heart size=1] [/quote] Actually, through my own tinkering, I think I fixed the problem! I still love the sheet though! [emoji=familiar heart size=1] [/quote] @Horsedog3799 Ah, well done!!! I'm glad it worked out! Sometimes it'll say that and the sheet only needs refreshing, that's an issue I've had in the past :'D

[quote name="rusalkii" date="2024-11-12 01:32:50" ] Actually, no, I think I figured it out (of course two minutes after I post here). The page going blank is the hundreds of blank rows being sorted to the top, and everything else is just ordinary lag. Sorry! [/quote] @rusalkii no worries!!! XD I'm glad you figured it out! I'm sure you know this but you can filter the blank ones out to make things easier fdhjdfshsfgjkhsdjkfh

Hi! I'm really impressed with this sheet :0 I can't fathom how long it must've taken to make it all, but I'm so grateful it exists! I'm too much of an organization lover to not have smth like this lol Though, I'm currently running into some problems:

I've put in my dragons and their lineages and when I use the family tree part, they all show up fine. I've filled in all the gen1 dragons with NONEX where it's needed. However, the dragons that are related seem to show up as "Data missing". It doesn't feel intentional so I'm not sure if it is or not, but the ones that aren't related show up as can breed so

Secondly, when I put my dragons' names in the verdict slots, nothing happens. I've quite a small number of dragons so I don't think it's about processing? I'm not sure if I'm doing something wrong or if theres an issue but I can't seem to figure it out :sob: If you need to see my copy of the sheet to figure it out, I'd be happy to send it to you!

[quote name="Whaliegamer" date="2024-12-17 23:32:27" ] Hi! I'm really impressed with this sheet :0 I can't fathom how long it must've taken to make it all, but I'm so grateful it exists! I'm too much of an organization lover to not have smth like this lol Though, I'm currently running into some problems: I've put in my dragons and their lineages and when I use the family tree part, they all show up fine. I've filled in all the gen1 dragons with NONEX where it's needed. However, the dragons that are related seem to show up as "Data missing". It doesn't feel intentional so I'm not sure if it is or not, but the ones that aren't related show up as can breed so Secondly, when I put my dragons' names in the verdict slots, nothing happens. I've quite a small number of dragons so I don't think it's about processing? I'm not sure if I'm doing something wrong or if theres an issue but I can't seem to figure it out :sob: If you need to see my copy of the sheet to figure it out, I'd be happy to send it to you! [/quote] @Whaliegamer I'm really glad you're emjoying it! It''s taken a lot of work but I'm honestly really proud of myself, both in the result and the commitment taken to get even halfway to it (I'm not known for reaching any sort of finish line on the many, many projects I start). And I intend to keep learning and improving it as both the game and my knowledge update! The text that needs to be in the Gen1 ancestry is [quote][NONE][/quote] I did have to overhaul some stuff on the Family Tree sheet recently though, so there is a high likelihood I missed a bug with it (or introduced a new one...) Edit: I think I fixed it! The sheet was misunderstanding merged blank cells. Thanks for letting me know! (You can copy the new result cells from that sheet back to the copy you've got if that's easier than filling out a whole new one!) And you don't input anything onto the verdict sheet! It's entirely automated. It might be empty because of the lineage calculation error, or, if the first line reads "OFF", you need to turn it on from the Target sheet where there's a dropdown to do so! (It's off by default to save on processing power!) I hope that helps! If you're still having issues or run into any down the line don't hesitate to ask or DM me!

I'm glad I could be of help! I made a copy of the latest version and copied the dragon info cells from the old one to the new one (i hope that didn't affect anything? I'm not too sure, I'm very bad at excel), updated the gen1 ancestry, and the family tree is working now!

...except for at the very bottom with the [PAIR1] X [PAIR2] thing. For some reason despite all 4 dragons in the 2 pairs being separate and both pairs coming up as can breed, the bottom pair where it combines the offspring is coming up as too closely related? As far as my eyes are concerned, neither pair have any shared ancestors with the other? and if I swap them around the initial pairs don't come up as being too closely related either, so I'm not sure if my eyesight is just failing me and I missed a same-name ancestor somewhere, or if that's an issue.

As for the relatedness+verdict sheets, I previously hadn't realised I needed to turn them on, but now that I have, it's showing up as #N/A instead in the first male slot. When I hover over it, it says "Error: No matches are found in FILTER evaluation.", which I am far too unqualified to begin to comprehend lmao this shows up in both the relatedness and the verdict sheet when both are on, so I'm not sure what's happening there :')

[quote name="Whaliegamer" date="2024-12-19 03:31:49" ] I'm glad I could be of help! I made a copy of the latest version and copied the dragon info cells from the old one to the new one (i hope that didn't affect anything? I'm not too sure, I'm very bad at excel), updated the gen1 ancestry, and the family tree is working now! ...except for at the very bottom with the [PAIR1] X [PAIR2] thing. For some reason despite all 4 dragons in the 2 pairs being separate and both pairs coming up as can breed, the bottom pair where it combines the offspring is coming up as too closely related? As far as my eyes are concerned, neither pair have any shared ancestors with the other? and if I swap them around the initial pairs don't come up as being too closely related either, so I'm not sure if my eyesight is just failing me and I missed a same-name ancestor somewhere, or if that's an issue. As for the relatedness+verdict sheets, I previously hadn't realised I needed to turn them on, but now that I have, it's showing up as #N/A instead in the first male slot. When I hover over it, it says "Error: No matches are found in FILTER evaluation.", which I am far too unqualified to begin to comprehend lmao this shows up in both the relatedness and the verdict sheet when both are on, so I'm not sure what's happening there :') [/quote] @Whaliegamer DM me a link to your sheet and I'll have a look!

Hi! I've really been enjoying your sheet so far, I think it's so cool! (And I have no idea how to go about coding a google sheet...)

I am having the same problem it seems other users have been having... when I go into Verdict, all of the pairs have errors that say, "Did not find value 'Male' in MATCH evaluation" and I'm not sure what to do. I've tried refreshing, but that didn't seem to help. Would you know a fix?

Thanks so much, and I really appreciate all of the work you've done!