@pinglist-21518 Hi all! I've added the new breed to the sheet! You can download a new copy or just add the following to the correct columns in Background Info!
[center][img]https://i.imgur.com/9gggS9S.png[/img][/center]
If you then select columns Q,R, and S, you can click Data > Sort Range > Advanced range sorting options, and then sort by Column R, A to Z; this sorts the breeds in alphabetical order, which is not necessary for anything except the breed selection dropdowns, otherwise Fathom will just be on the bottom of the list ^^
@Color Calculator Updates Hi all! I've added the new breed to the sheet! You can download a new copy or just add the following to the correct columns in Background Info!
If you then select columns Q,R, and S, you can click Data > Sort Range > Advanced range sorting options, and then sort by Column R, A to Z; this sorts the breeds in alphabetical order, which is not necessary for anything except the breed selection dropdowns, otherwise Fathom will just be on the bottom of the list ^^
@pinglist-21518 Sorry for the late update! The sheet is now updated with the Petrified/Lode extending to Moderns! You can download another copy for yourself or add the values below in the correct cells in the tab Background Info!
[center][img]https://i.imgur.com/AmtHwtV.png[/img][/center]
@Color Calculator Updates Sorry for the late update! The sheet is now updated with the Petrified/Lode extending to Moderns! You can download another copy for yourself or add the values below in the correct cells in the tab Background Info!
@pinglist-21518 Hi everyone! I updated the calculator with the new Warrior gene, which I'm assuming is Limited rarity based on some forsee progeny rounds, but if this ends up being different, I will update it! I also added both the Brightshine and Thundercrack expansions I apparently missed! As usual, you can download a new copy or just enter the values below in the correct columns and rows!
[center][img]https://i.imgur.com/cUsLG3B.png[/img][/center]
@Color Calculator Updates Hi everyone! I updated the calculator with the new Warrior gene, which I'm assuming is Limited rarity based on some forsee progeny rounds, but if this ends up being different, I will update it! I also added both the Brightshine and Thundercrack expansions I apparently missed! As usual, you can download a new copy or just enter the values below in the correct columns and rows!
When Wildclaw is put in as a breed, it does not create a breed chance percentage and instead gives N/A. I sub coatl in anyways since they're the same rarity but I thought it should be mentioned anyways.
The notes triangle thingy says "Did not find value 'Wildclaw' in VLOOKUP evaluation." However looking at the background info doesn't show anything inherently wrong. I even downloaded the sheet again to make sure that I hadn't accidentally messed with it and forgot about it.
When Wildclaw is put in as a breed, it does not create a breed chance percentage and instead gives N/A. I sub coatl in anyways since they're the same rarity but I thought it should be mentioned anyways.
The notes triangle thingy says "Did not find value 'Wildclaw' in VLOOKUP evaluation." However looking at the background info doesn't show anything inherently wrong. I even downloaded the sheet again to make sure that I hadn't accidentally messed with it and forgot about it.
@
DiscoPolaris Thank you for letting me know! I fixed the issue (which was just me forgetting to change a range to be open ended instead of fixed) so downloading the new copy would solve it now!
Won't do a ping for everyone as I plan on adding the Aether genes tomorrow and I don't want to ping everyone twice in less than 24h, but thought I'd let you know! ^^
@
DiscoPolaris Thank you for letting me know! I fixed the issue (which was just me forgetting to change a range to be open ended instead of fixed) so downloading the new copy would solve it now!
Won't do a ping for everyone as I plan on adding the Aether genes tomorrow and I don't want to ping everyone twice in less than 24h, but thought I'd let you know! ^^
Awesome! I'm glad I learned about it on accident lol
Awesome! I'm glad I learned about it on accident lol
@Color Calculator Updates I FINALLY had time and energy to add all the genes that came out since August! It's a whole lot so definitely download a new copy!
I'll try to keep it up to date again and might also rework it so you don't need to download a new copy everytime but instead it pulls the genes from a seperate sheet, but I'd have to test that first ^^"
@Color Calculator Updates I FINALLY had time and energy to add all the genes that came out since August! It's a whole lot so definitely download a new copy!
I'll try to keep it up to date again and might also rework it so you don't need to download a new copy everytime but instead it pulls the genes from a seperate sheet, but I'd have to test that first ^^"
@Color Calculator Updates Eclipse update everyone! AND, I've updated the sheet to pull the genes and breeds from my own sheet, so this will be the last copy you'll need to download ever (unless I need to add something major hahaha)! I'll still ping the thread whenever I add new genes tho!
With this new update, it will throw a "Some formulas are trying to send and receive data from external parties" warning; just hit "allow access" and all is fine! It just does this because of the importrange formulas that pull the data from my personal sheet ^^
@Color Calculator Updates Eclipse update everyone! AND, I've updated the sheet to pull the genes and breeds from my own sheet, so this will be the last copy you'll need to download ever (unless I need to add something major hahaha)! I'll still ping the thread whenever I add new genes tho!
With this new update, it will throw a "Some formulas are trying to send and receive data from external parties" warning; just hit "allow access" and all is fine! It just does this because of the importrange formulas that pull the data from my personal sheet ^^
