Guides

[quote name="JustBlackTea" date="2025-01-09 07:44:19" ] 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! [/quote] @JustBlackTea do all the dragons have a project number? (And thank you!)

I've been looking for something exactly like this omg!! Was thinking of making an app for it since all I know is webdev but this saves me tooonnns of work. Thank you so much for making the tool available :D

@UhOhItsDorian, Uh yes. *Facepalms* You're right... I didn't even notice that little box there. Thanks so much for the help!

I do still have an error in the verdict section for the rows with one female? It says "Unknown range name, 'CUD'", and I tried re-entering the info. Still there... It's showing up in the column Total/7 and the fourth breed/gene column. It's not super important to me, so no worries if you don't know the fix, but I thought I'd ask. I might try entering the info again.

[quote name="JustBlackTea" date="2025-01-10 19:53:28" ] @UhOhItsDorian, Uh yes. *Facepalms* You're right... I didn't even notice that little box there. Thanks so much for the help! I do still have an error in the verdict section for the rows with one female? It says "Unknown range name, 'CUD'", and I tried re-entering the info. Still there... It's showing up in the column Total/7 and the fourth breed/gene column. It's not super important to me, so no worries if you don't know the fix, but I thought I'd ask. I might try entering the info again. [/quote] @JustBlackTea you’re not the first to have this issue, and I [i]think[/i] it’s a Google sheets bug. Which is very annoying, but does mean I’ve already solved it. In the formulas in the troublesome column (so the breed/gene drawback one), replace every instance of [quote]CUD[/quote] (NOT CUDprob, that’s different) with [quote]Lookup!$BW$3:$BW$27[/quote] You can just do it in the first row and copy those cells down the rest. Let me know if that helps! (Explanation: Google sheets just isn’t for some reason recognising the named range, despite having no issue doing it with the same range in other columns, so you just have to give the direct location of the exact same bunch of cells. CUD stands for Corresponding Unique Digit.)

This is so incredibly cool! It's gonna save me a *lot* of headache (I... have too many breeding projects going on at once)

Is there a pinglist to be alerted for future updates?

[quote name="clockworkworm" date="2025-02-04 19:10:34" ] This is so incredibly cool! It's gonna save me a *lot* of headache (I... have too many breeding projects going on at once) Is there a pinglist to be alerted for future updates? [/quote] @clockworkworm there isn't currently, I'm not sure how they work! I'm sure I could set one up though! I'm so glad you're enjoying it :D though watch out, the lair capacity can get nightmarish with multiple projects... (send help /silly)

@UhOhItsDorian, So sorry about the late response! I'm still having issues, as I don't see any occurrences of CUD in the formulas? I'm not incredibly familiar with sheets, so it could be that I'm missing something, but here's a screenshot of the formula I'm looking at. [img]https://i.ibb.co/4n1jTVMZ/Screenshot-2025-02-09-211321.png[/img] [img]https://i.ibb.co/spc9XnSL/Screenshot-2025-02-09-211606.png[/img] Let me know if that helps you see what my issue is? Thanks so much!

[quote name="JustBlackTea" date="2025-02-09 19:15:33" ] @UhOhItsDorian, So sorry about the late response! I'm still having issues, as I don't see any occurrences of CUD in the formulas? I'm not incredibly familiar with sheets, so it could be that I'm missing something, but here's a screenshot of the formula I'm looking at. [img]https://i.ibb.co/4n1jTVMZ/Screenshot-2025-02-09-211321.png[/img] [img]https://i.ibb.co/spc9XnSL/Screenshot-2025-02-09-211606.png[/img] Let me know if that helps you see what my issue is? Thanks so much! [/quote] @JustBlackTea thank you for your patience on my own response :’D send me a link and I’ll take a look!