Guides

@UhOhItsDorian Ya ha ha! I have returned, bearing additional spreadsheet performance improvements and potential features! Let me know what ya think! [center][emoji=bogsneak laughing size=2] [url=https://docs.google.com/spreadsheets/d/1n7MJ3fbzRev4jKubccEEofkwgP3opFsMX4qqPYZUS78/edit?usp=sharing][size=5]Spreedsheet Here!*[/size][/url] [emoji=bogsneak laughing size=2][/center] *Also I highlighted all the cells I changed to make it a bit easier to work through [b]1. Potential Fix?[/b] While I was running the newest version through its paces a bit I noticed that I was having some strange issues using the "[NONE]" tag on a dragons parents. I fixed it so that the entire ancestry of a dragon would auto fill with "[NONE]" if it a dragon's parents were listed as "[NONE]" and that fixed the problem. (Unless I misunderstood the feature and the user was meant to fill that in themselves... In which case everything worked as intended and I improved the user experience a bit!) [b]2. Pair Saver[/b] I remembered you mentioning wanting to be able to save dragon pairs in the sheet, and I've done it! It took a bit longer than I expected but it works! In the linked spreadsheet any two dragon listed on the FinalPairs sheet wont be included in the VerdictListing sheet so their excluded from the verdicts automatically. [b]3. Minor Efficiency Tweaks[/b] I made some minor tweaks to both the can breed column on the relatedness columns and to all the calculation cells in the Verdict sheet.

Gonna be using this soon! Thanks for making it!!

[quote name="Sonders" date="2024-10-19 17:37:25" ] I've had a project in mind for a month now but it intimidated me too much that I didn't even know where to start, and this actually helped me so much on getting started on it! :D Thank you so much for this! [/quote] @Sonders I’m so glad to hear it!!! Have fun!!!

[quote name="CyanMoo" date="2024-10-20 21:18:32" ] Gonna be using this soon! Thanks for making it!! [/quote] @CyanMoo you’re welcome!!! Have fun!!! :D

[quote name="AHumanBean" date="2024-10-20 12:52:55" ] @UhOhItsDorian Ya ha ha! I have returned, bearing additional spreadsheet performance improvements and potential features! Let me know what ya think! [center][emoji=bogsneak laughing size=2] [url=https://docs.google.com/spreadsheets/d/1n7MJ3fbzRev4jKubccEEofkwgP3opFsMX4qqPYZUS78/edit?usp=sharing][size=5]Spreedsheet Here!*[/size][/url] [emoji=bogsneak laughing size=2][/center] *Also I highlighted all the cells I changed to make it a bit easier to work through [b]1. Potential Fix?[/b] While I was running the newest version through its paces a bit I noticed that I was having some strange issues using the "[NONE]" tag on a dragons parents. I fixed it so that the entire ancestry of a dragon would auto fill with "[NONE]" if it a dragon's parents were listed as "[NONE]" and that fixed the problem. (Unless I misunderstood the feature and the user was meant to fill that in themselves... In which case everything worked as intended and I improved the user experience a bit!) [b]2. Pair Saver[/b] I remembered you mentioning wanting to be able to save dragon pairs in the sheet, and I've done it! It took a bit longer than I expected but it works! In the linked spreadsheet any two dragon listed on the FinalPairs sheet wont be included in the VerdictListing sheet so their excluded from the verdicts automatically. [b]3. Minor Efficiency Tweaks[/b] I made some minor tweaks to both the can breed column on the relatedness columns and to all the calculation cells in the Verdict sheet. [/quote] @AHumanBean oh you absolute legend!!! Thank you so much :D 1. I almost never start with or intentionally look for 1st gen dragons on a project, so more often than not if I get a [NONE], it’ll be a few generations back. Would it be horrendously inefficient to chain the [NONE] check for the grandparents to the parents, great grandparents to the grandparents, great great grandparents to the great grandparents, etc.? I know dependencies cause lag but I don’t know how much. Regarding “strange issues,” thank you for squashing bugs in my work XD 2. I have a pairs sheet I’m testing on my own current copy! It has a few more features but I don’t know if I’ve implemented it in a way that isn’t horrendous. I’d love if you’d take a look at my own copy, since that’s the one I use to experiment with. I’ll DM you a link. 3. Thank you! I’d love if you could explain the theory behind why it improves things; I want to learn and understand more about it all. In the meantime I’ll probably get started implementing some of these on the blank copy! Thank you genuinely so much!

[quote name="Mavelin" date="2024-10-25 13:03:52" ] Wow, this is super useful. I finished entering my breeding project dragons into the spreadsheet and it's so much clearer than trying to track the relationships and color combos on my own. Thank you very much for making it! [/quote] @Mavelin ah, you’re so welcome!!! :D

@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]

I really love your sheet. I started using it and i really love it.


Thank you!

[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]