Guides

Aaaa I really hope Im not bothering you with all these reports adflghadfh
All the ancient gem secondaries seem to have the primary gene cost (750 G) instead of 600 G!

@Mid0riKage no PLEASE keep sending me errors, I wanna make sure everything is okay and up-to-date! Putting this together definitely fried my eyes a bit so I'm sure I missed over quite a few things.

Updated now! When I have a spare moment later today, I'll go through the index again and see if I can catch anything else

[center]Sheet has been expanded to include the new Firebreather genes! [item=Tertiary Veilspun Gene: Firebreather][item=Tertiary Banescale Gene: Firebreather][item=Tertiary Gaoler Gene: Firebreather][item=Tertiary Aether Gene: Firebreather][item=Tertiary Sandsurge Gene: Firebreather] [url=https://www1.flightrising.com/forums/ann/3338318/1][b]Announcement thread[/b][/url][/center]

I'm fairly new to using spreadsheet BBCode generators, so this might entirely be an error on my part: While using the Breeding Pair Generator, when I paste in my dragon's Morphology Image URL, the cells that auto-fill seem to be having an error. The cells under Breed, Primary Gene, Secondary Gene, etc all read as '#REF!' and the same thing generates in the cells for Breeding Probabilities. Hovering over the cells that read this shows an error message that says "Unresolved Sheet Name 'INDEX'." If I tried to continue filling the gold boxes as written, no Forum Code would automatically generate at the bottom.

Is there something in the steps I am missing? Have I entered something incorrectly? Thank you in advance-- these generators look amazing!

@SuperSchwiizer I'm having a bit of trouble replicating this error and it's working fine on my end, but let me double check and see if I can figure out what's going on!

This error basically means that the formula is looking for a tab in the sheet titled "INDEX" but is having trouble finding it, so it's returning an error.

If you check all your tabs in sheets, there should be a hidden sheet called INDEX (which I hid by default so others can't accidentally fiddle with it. If the INDEX breaks, the whole sheet breaks). Make sure that's there, and maybe unhide it? If INDEX isn't there, then that's your problem. Copy a new sheet from the master and hopefully that resolves the issue. If it IS there and unhiding it doesn't change the errors, I'll have to fiddle around more and see what's up

I realized my mistake and was able to fix it-- I had only created a copy of *just* the breeding pair generator page, and not the entire document with all of the additional tabs. My bad! And thank you for such a quick response. :)

@SuperSchwiizer not a problem! Glad everything worked out!

[center][b][size=5][emoji=subscription update size=1] Updates Made! [emoji=subscription update size=1][/b] If you're anything like me, you can remember WHAT genes you need for projects, but never HOW MANY COPIES you need. Ugh. Time to solve that issue! Sheet now includes a new tab: [b]Project Tally/Wishlist![/b] This tab will pull information from your [b]Project List[/b] tab and tally ALL the genes, vials, and scrolls you need for your project dragons! You can manually check off each gene by filling in the gold boxes with [b]how many copies of that gene you currently own[/b]. What's even nicer? The little [b]Forum Code[/b] box at the top of the page will generate a BBCode wishlist for you based on what genes you need! Great for posting into forums or your wishlist dragon's bio! [quote name=WISHLIST][center][b] [size=5][emoji=scroll size=1] Breed Change Scrolls [emoji=scroll size=1][/size] [item=Breed Change: Guardian] x2 [item=Breed Change: Ridgeback] x1 [item=Breed Change: Coatl] x3 [item=Breed Change: Veilspun] x2 [item=Breed Change: Aberration] x1 [/b] ----- [b] [size=5][emoji=primary gene size=1] Primary Gene Scrolls [emoji=primary gene size=1][/size] [item=Primary Gene: Boa] x1 [item=Primary Gene: Chrysocolla] x1 [item=Primary Gene: Harlequin] x2 [item=Primary Gene: Pinstripe] x1 [item=Primary Gene: Swirl] x1 [item=Primary Veilspun Gene: Arc] x1 [item=Primary Veilspun Gene: Shell] x1 [item=Primary Aberration Gene: Diamond] x1 [/b] ----- [b] [size=5][emoji=secondary gene size=1] Secondary Gene Scrolls [emoji=secondary gene size=1][/size] [item=Secondary Gene: Saddle] x1 [item=Secondary Gene: Blend] x1 [item=Secondary Gene: Paisley] x1 [item=Secondary Gene: Jester] x1 [item=Secondary Gene: Weaver] x1 [item=Secondary Gene: Bee] x1 [item=Secondary Veilspun Gene: Loop] x1 [item=Secondary Veilspun Gene: Web] x1 [item=Secondary Aberration Gene: Blend] x1 [/b] ----- [b] [size=5][emoji=tertiary gene size=1] Tertiary Gene Scrolls [emoji=tertiary gene size=1][/size] [item=Tertiary Gene: Filigree] x1 [item=Tertiary Gene: Opal] x3 [item=Tertiary Gene: Stained] x2 [item=Tertiary Veilspun Gene: Branches] x1 [item=Tertiary Aberration Gene: Koi] x1 [/b] ----- [b] [size=5][emoji=special eyes size=1] Eye Vials [emoji=special eyes size=1][/size] [item=Vial of Uncommon Sight] x1 [item=Vial of Fractal Sight] x2 [item=Vial of Disjointed Sight] x1 [item=Vial of Brilliant Sight] x1 [item=Vial of Faded Sight] x3 [item=Vial of Umbral Sight] x1 [/b] ----- [b] [size=5][emoji=eternal youth size=1] Specialty Scrolls [emoji=silhouette size=1][/size] [item=Scroll of Eternal Youth] x2 [item=Scroll of Maturity] x1 [item=Silhouette Scroll] x2 [/b][/center][/quote] [i][b]Note:[/b] You will need to download a new copy of this sheet in order to access the new tab! I had to make some modifications to the Project List tab in order to accommodate the new sheet, so you can't just copy the new tab into your existing sheet. Sorry![/i]

First of all thanks for making this tool, it's absolutely amazing!!! Thank you! I have to learn this sheets magic myself one day.

Secondly, question: is there a way to check off genes that have already been applied in the "Project List" tab so that they don't count towards the "Wishlist" tab - like the "Project Cost Calculator" tab does?