Guides

[quote name="Azurval" date="2024-07-20 18:02:14" ] @UhOhItsDorian Hey, um, I can't seem to write or use the calculator. I don't know if it's because of me or the spreadsheet [/quote] You just need to make a copy of the spreadsheet for yourself and then you can edit it.

@Ondine Oh, I see. Thank you very much!

@UhOhItsDorian
https://docs.google.com/spreadsheets/d/1FLnzHQ9QXuHb_jyEDI5PrFwJblCC5e5j2CoAaHgiPvI/edit?usp=sharing

Here's a link to my sheet. The problems I'm running into are,
1. It says none of my dragons are able to breed.
2. The dragon listed at the bottom of "males" will not show up in verdict even though it matches the project input.

[quote name="Ondine" date="2024-07-22 13:08:41" ] @UhOhItsDorian https://docs.google.com/spreadsheets/d/1FLnzHQ9QXuHb_jyEDI5PrFwJblCC5e5j2CoAaHgiPvI/edit?usp=sharing Here's a link to my sheet. The problems I'm running into are, 1. It says none of my dragons are able to breed. 2. The dragon listed at the bottom of "males" will not show up in verdict even though it matches the project input. [/quote] @Ondine ah, okay. First issue is that all the ancestor slots for the dragons that have [i]not[/i] been bred from two others already on the sheet need to be manually filled in (i.e., clear the formulae from columns S to AT on that dragon's row on the Males/Females sheet and enter the names/IDs of the ancestors as necessary. Even if both parents are marked as [NONE], that still needs to be in all the other boxes. The reason they're supposedly unable to breed is because the sheet thinks they all share an ancestor called "N/A". I'd recommend starting from a blank copy of the sheet again, but if you want to keep working on this one, the formula in cell [b]A3[/b] on the [b]Relatedness[/b] sheet needs to be [indent]=if(not(TARGET!D25="OFF"), arrayformula(SPLIT(FLATTEN(indirect("Lookup!N4:N"&Lookup!N3+3) & "|" & TRANSPOSE(indirect("Lookup!Q4:Q"&Lookup!Q3+3))), "|")), "OFF")[/indent] Try that and let me know if there are still issues (probably will be, I find new bugs in this thing every five minutes) I think an overhaul of the ancestry code is in order. From all the questions I've had about it it's evidently not very intuitive and I think it could be a lot smoother, so... coming soon, hopefully, no immediate promises

[quote name="Azleep" date="2024-07-22 06:17:57" ] Thank you for this! I've been playing around by putting a couple of dragons in and come across errors in the verdict tab: [quote]'Error Did not find value '[i][dragonname][/i]' in MATCH evaluation.'[/quote] I looked at the dragon in question and it doesn't seem like I've done anything wonky, so hope I could get some help? I can message the sheet link if necessary. [/quote] @Azleep I'd love to take a look at it!

@UhOhItsDorian

Thank you so much for your help! I tried inputting the new code as well as filling out a new spreadsheet minus the first gen dragons... Except for one, but I just filled in names for them. I'm still running into the same problem. Not sure what is going wrong here.

Here is the link to the new sheet

I can still compare the data myself, I'm not sure of all the calculations but its better info than looking at a rarity chart by miles.

[quote name="Ondine" date="2024-07-22 17:55:06" ] @UhOhItsDorian Thank you so much for your help! I tried inputting the new code as well as filling out a new spreadsheet minus the first gen dragons... Except for one, but I just filled in names for them. I'm still running into the same problem. Not sure what is going wrong here. Here is the link to the new sheet I can still compare the data myself, I'm not sure of all the calculations but its better info than looking at a rarity chart by miles. [/quote] @Ondine the ancestries are still missing - none of the slots can be #N/A. I've demonstrated with Lunaria and Balisier on [url=https://docs.google.com/spreadsheets/d/1L6vHzTIkvWZBKl2B9doNlAe6LIGHmN0xn9THCKRa9lE/edit?usp=sharing]this copy[/url] how the ancestries should look - you just have to trace these yourself, I've got no way to pull that information from the site and I think that would probably be against site policy anyway (I'm neither a programmer nor a lawyer) :'D But you can see from there that their descendants have their ancestries input automatically Does that help?

@UhOhItsDorian

Oh I see what you mean. I kind of thought that was the case. But I have no idea how spreadsheets work, and I felt like I would break the equation if I messed with it in the wrong way, so I was too apprehensive to fill that all out. The example clears it all up perfectly, thanks!

@Ondine don’t worry!!! I know when I said “delete the formulas” it’s like??? That feels wrong dbjrhufjfhfj
I’ll sort it out when I get the chance! :’D