Guides

@Hirunda No problem. Sharing that spreadsheet is amazing :)

@Hirunda
I have definitely been ballpark calculating this stuff myself (at least for reasonably close pairs), and this is so useful! Thank you!

Also, a question for you: the tool I've always used to just quickly visualize color ranges of a pair (the fr.fintastic.net one) just disappeared yesterday (or at least it won't load for me), and not knowing if it's ever going to come back I decided to just recreate its basic function myself. I'm not an expert at spreadsheets, but can muddle my way through moderately complex functions, especially given examples that work similarly to what I wish to do. Which is a very long-winded way to ask, in building (and potentially sharing, once it's polished up) this tool, may I copy your color list & hexcodes, and use one or two of your more simple equations? Credit would be given, of course

@Velifer

For sure! I just got the color list and hex codes from the wiki, but feel free to use some of my formulas.

@Hirunda
Thanks!

@Hirunda
Hi! First of all, I love the spreadsheet so much, it's a really useful tool.

I hate to be a bother, but I get an error when the tertiary colour range between the parents doesn't include the goal colour - at least, that's what I assume the cause is. Instead of getting a "0,0%" result, I get #VALUE, as seen here:
https://sta.sh/01imx0sf5622
The same error is in the hidden cells to the left:
https://sta.sh/018atr2kg7au

The error message itself says something about the value of Parameter 2 to the function DGET being Other when it should be COLOR. I'm sorry I can't copy the exact message, my google drive/Sheets isn't in english, but I did my best to translate ;^^

[quote name="RikVentures" date="2020-08-15 04:47:53" ] @Hirunda Hi! First of all, I love the spreadsheet so much, it's a really useful tool. I hate to be a bother, but I get an error when the tertiary colour range between the parents doesn't include the goal colour - at least, that's what I assume the cause is. Instead of getting a "0,0%" result, I get #VALUE, as seen here: https://sta.sh/01imx0sf5622 The same error is in the hidden cells to the left: https://sta.sh/018atr2kg7au The error message itself says something about the value of Parameter 2 to the function DGET being Other when it should be COLOR. I'm sorry I can't copy the exact message, my google drive/Sheets isn't in english, but I did my best to translate ;^^ [/quote] I'm having this problem too.

After a hiatus, this spreadsheet has been fixed and updated! All genes and rarities have been added, as well as the veilspun breed.

@Velifer I'm pinging you just in case you still use this spreadsheet.

hi there! not sure if it's just me being boggled by spreadsheets as per usual or if there is some sort of issue, but i don't see any ancient breeds (or their genes) included in any of the dropdown selections for their respective cells.

@nimravidaze
The ancient breeds and their genes are in different sheets (along the bottom) unless there is some other issue I don't know about. This sheet hasn't been updated in a second, so it's missing like 2 genes and the obelisk gene, but that will be fixed soon!