Guides

@SeasonalHobbit sorry for late reply, but this has been corrected! Thanks for letting me know!

@SuperSchwiizer Hiya! Would you mind DMing me with the link to your sheet? I did recently add the Eclipse genes into the sheet and everything LOOKS to be functioning on my Master sheets, but who knows. Could've missed something!

@BassetBites
Hi! I don't know what happened, but my spreadsheet gives me #N/A in everything, I didn't even touch anything that I shouldn't, so I'm confused.

Thanks! I love using your spreadsheet!

@MossAndBones Hiya, I'd be happy to help! Would you mind DMing me the link to your spreadsheet so I can poke around a bit and see what's up?

@BassetBites
Hi! I found some small errors. The price for the Wasp(Aether) gene is listed as 1500g instead of 750g. The other error is that, if a dragon has the primary color fern, on the dragon project list, the availability notes will be about the gene fern, despite the dragon not having that gene.

Also thank you for the sheet!

@raytries Thanks for catching that! The price for the Aether Wasp has been adjusted and should now read 750g. No need to adjust anything on your end, it should update automatically! As for the Fern issue, alas! Problems of some genes sharing the same name as some colors I guess.... Anyways! I rewrote the code responsible for the [b]Availability Notes[/b] column of the [b]Dragon Project List tab[/b]. This should hopefully fix the issue, but let me know if there are any errors! Warning: the formula is BEEFY! [code]=iferror(MAP(AO6:AO,AN6:AN,AU6:AU,AT6:AT,AQ6:AQ,LAMBDA(BREED,PRIM,SEC,TERT,EYE,if(BREED="breed=8"," Imperial Scrolls are retired.","")&if(BREED="breed=11"," Nocturne Scrolls are found in Strange Chests during Night of the Nocturne.","")&if(vlookup(PRIM,INDEX!AF4:AH,3,FALSE)="Fern"," Fern is found in Strange Chests during Night of the Nocturne.","")&if(vlookup(PRIM,INDEX!AF4:AH,3,FALSE)="Love"," Love is sold by Susie during the Love is in the Air event.","")&if(vlookup(SEC,INDEX!AR4:AT,3,FALSE)="Paisley"," Paisley is found in Strange Chests during Night of the Nocturne.","")&if(vlookup(SEC,INDEX!AR4:AT,3,FALSE)="Affection"," Affection is sold by Susie during the Love is in the Air event.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Smirch"," Smirch is found in Strange Chests during Night of the Nocturne.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Warrior"," Warrior is sold by Arvelle during the Warrior's Way event.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Brightshine"," Brightshine is sold by Joxar during Brightshine Jubilee.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Thundercrack"," Thundercrack is sold by Joxar during Thundercrack Carnivale.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Flameforger"," Flameforger is sold by Joxar during Flameforger's Festival.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Starfall"," Starfall is sold by Joxar during Starfall Celebration.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Riot"," Riot is sold by Joxar during Riot of Rot.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Rockbreaker"," Rockbreaker is sold by Joxar during Rockbreaker's Ceremony.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Crystalline"," Crystalline is sold by Joxar during Crystalline Gala.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Trickmurk"," Trickmurk is sold by Joxar during Trickmurk Circus.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Mistral"," Mistral is sold by Joxar during Mistral Jamboree.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Wavecrest"," Wavecrest is sold by Joxar during Wavecrest Saturnalia.","")&if(vlookup(TERT,INDEX!BD4:BF,3,FALSE)="Greenskeeper"," Greenskeeper is sold by Joxar during Greenskeeper Gathering.","")&if(EYE="eyetype=14"," Button Eye Vials are sold by Marva during April Fool's.",""))),"")[/code] ^^^ Copy all this text and paste it into [b]Cell AC6 of the Dragon Project List sheet[/b] (should be the little white bar just under the red cell reading "Availability Notes." Moving on! Happy Trickmurk Circus everyone! The newest additions to the Trickmurk gene have been added to the sheet! [center][item=tertiary Banescale Gene: Trickmurk][item=Tertiary Undertide Gene: Trickmurk][/center] Please reach out if you have any questions or errors to report! @pinglist-38550

First of all, this sheet is absolutely amazing; you've went above and beyond (and atop [i]that[/i]) on both functionality and aesthetic, and I am very grateful to have such a useful tool at my super unorganized butt's disposal. But I was wondering something... [quote name="BassetBites" date="2024-05-09 07:47:51" ] [center]The goal of this sheet is to [b]automate as much as possible[/b] so you don't have to do any heavy lifting. Why input each dragon's colors and genes by hand when the scrying workshop link has ALL that information already? [/center] [/quote] Is there a reason that we can't seem to use the scrying workshop links to input dragons' current states as well? That way, if we already have parts of a project complete, there's no need to overwrite those fields with N/A? Sorry if I'm being dumb! ^^;

@BassetBites
Hello! This sheet is super helpful, thanks a bunch for making it! I am encountering an error, though: when I try setting "Dragon Genes Forum Type Color" to "Color-Coordinated", the forum code section becomes #N/A.

Mousing over the forum code box, it gives this error:
"Error
Did not find value 'body=21' in VLOOKUP evaluation."

@BassetBites

Hello! The sheet is amazing! I really like generators, it's easy to use and I like how it looks.

I am encountering an error in the Breeding Pair Generator. The Primary genes are Aberration Stitched and Vipera and it says #N/A and

Sorry for the late response on all these!!

@Tesnivy This error has now been fixed! Accidentally had that piece of code searching the wrong part of the index :)

@MangleSchmidt This error is now fixed! The issue was a typo in the index: some Limited Genes were marked as "Limited " with a space at the end, and the VLOOKUP formula didn't know what to do with that extra space since it was looking for an exact match!

For the both of you, you'll need to copy and replace the problem tabs in your sheet with the new ones in the Master Sheet in order to receive these updates!

---

@Scarfsickle I think I know what you're asking, but correct me if I'm wrong! The reason I don't let you "mark" currently completed parts of project dragons is simply because there would be too many moving parts, and I'm trying to keep things as slim as possible while still keeping things functional. I do try to account for in-progress projects; the Project Cost Calculator tab and the Dragon Project List tab both have little checkboxes next to breeds, genes, etc. that allow you to mark off aspects of a project that have been fulfilled. Those checkboxes also function in a "this cost is not needed" fashion, and checking off boxes will subtract the item cost (say, a gene scroll or an eye vial) from the total calculated cost.

Does that explain it well enough? Or was I off the mark in answering your question?

[center][b][size=5][emoji=subscription update size=1] Updates Made! [emoji=subscription update size=1][/b] Hey now, I've released v2 of this sheet! Neato! [size=5][b][emoji=rainbow star 2 size=1] [url=https://docs.google.com/spreadsheets/d/19jIQo42uDn3lOx5CRklToeCdzSwX8Hl7NHfV4zOCYbE/edit?usp=sharing]BassetBites' Flight Rising Toolkit[/url] [emoji=rainbow star 2 size=1][/b][/size] [size=2][i]This link will replace the current one on the first forum post![/i][/size] Let's go over the changes, shall we? ----- [emoji=rainbow star 2] [size=5][b]New Tabs[/b][/size] [emoji=rainbow star 2] [size=4][b]APPAREL PROJECT LIST[/b][/size] [i]Will keep record of your planned outfits and their cost for your dragons. Also generates BBCode showcasing your goal outfit and what items you have and still need![/i] Who doesn't love dressing up dragons? No one, that's who. We all play [i]Pretty Pretty Dragon PNG Dress-Up Game[/i] for a reason. With this new tab, you can now keep track of your various dragon outfits, as well as how much treasure and gems you'll need to dump into your wallet-eating projects! Even better: [b]you can generate BBCode for your projects[/b]! Makes for easy copy-pasting into your dragon's bio! To use, simply copy the link of the image of your dragon and their outfit in the dressing room, then paste into the designated gold box in the sheet. The apparel information should pop up in the appropriate apparel slot cells! Check off each piece of apparel as you obtain it! If you'd like to see the BBCode of multiple outfit plans, [b][url=https://www1.flightrising.com/dragon/91814784]check out my [s]dragon[/s] potted plant Charley[/b][/url]! [i]Final outcome example below. Fonts can be customized. [b]NOTE:[/b] Works ideally with outfits on saved scries. Outfits saved on dummies kind of work??? But the apparel slot boxes in the sheet don't fill up properly, and the BBCode won't generate either. Working on a fix.[/i][/center] [center][img]https://www1.flightrising.com/dgen/dressing-room/scry?sdid=5313334&skin=0&apparel=30036,749,1753,4320,32280,10731,34171,35205,24058,34154,1098,33699,472,27988&xt=dressing.png[/img][/center] [font=Book Antiqua][size=5]Klavier Gavin[/size]‎[color=transparent]......[/color][/font] ----- [columns][emoji=treasure] [font=Book Antiqua]65,900t [emoji=gem] 590g[/font] [color=transparent]xxxxxx[/color] [nextcol][b][size=4][font=Book Antiqua]APPAREL NEEDED[/font][/size][/b] ----- [gamedb item=30036] [gamedb item=1753] [gamedb item=4320] [gamedb item=32280] [gamedb item=10731] [gamedb item=34171] [gamedb item=24058] [gamedb item=34154] [gamedb item=1098] [gamedb item=472] [gamedb item=27988] [nextcol][b][size=4][font=Book Antiqua]OWNED APPAREL[/font][/size][/b] ----- [gamedb item=749] [gamedb item=35205] [gamedb item=33699] [/columns] [center][size=2]Look at my blorbo fandragon. Look how much currency he's going to eat. He doesn't even exist yet and he's already vaporizing my wallet. Unbelievable.[/size] [emoji=rainbow star 2] [size=4][b]BULK DRAGON LISTING[/b][/size] [i]Generates clickable mini-widgets from pasted dragon URLs. Ideal for selling dragons during lair purges![/i] Easy enough to explain! Paste all your dragons' URLs into the designated boxes, then copy the generated BBCode at the top of the page. Boom! Mini dragons! Great for when you need to purge your lair of all the Nocturnes you hatched on an impulse and now have no room for! [url=https://www1.flightrising.com/dragon/99990636][img]https://flightrising.com/rendern/avatars/999907/99990636.png[/img][/url][url=https://www1.flightrising.com/dragon/99990741][img]https://flightrising.com/rendern/avatars/999908/99990741.png[/img][/url][url=https://www1.flightrising.com/dragon/99991143][img]https://flightrising.com/rendern/avatars/999912/99991143.png[/img][/url][url=https://www1.flightrising.com/dragon/99992539][img]https://flightrising.com/rendern/avatars/999926/99992539.png[/img][/url][url=https://www1.flightrising.com/dragon/99993147][img]https://flightrising.com/rendern/avatars/999932/99993147.png[/img][/url][url=https://www1.flightrising.com/dragon/99997048][img]https://flightrising.com/rendern/avatars/999971/99997048.png[/img][/url][url=https://www1.flightrising.com/dragon/99997053][img]https://flightrising.com/rendern/avatars/999971/99997053.png[/img][/url][url=https://www1.flightrising.com/dragon/99997054][img]https://flightrising.com/rendern/avatars/999971/99997054.png[/img][/url][url=https://www1.flightrising.com/dragon/99997065][img]https://flightrising.com/rendern/avatars/999971/99997065.png[/img][/url][url=https://www1.flightrising.com/dragon/99997068][img]https://flightrising.com/rendern/avatars/999971/99997068.png[/img][/url] [emoji=rainbow star 2] [size=4][b]FORUM NAVIGATOR[/b][/size] [i]Generates those handy little navigators for multi-post forum threads.[/i] Do you have a forum thread that takes up multiple posts? Use this handy little feature to generate BBCode that you can paste at the top of each post! Paste your forum links (or offsite website links, if need be), give each link a proper title, and copy-paste the generated BBCode at the top! ----- [emoji=rainbow star 2] [size=5][b]Changes to Existing Tabs[/b][/size] [emoji=rainbow star 2] [size=4][b]ALL TABS[/b][/size] [i]Cells that record and tally currency (gems, treasure) will now list units with commas. (30000t and 4500g will now display 30,000t and 4,500g respectively). Thank heavens for that.[/i] [emoji=rainbow star 2] [size=4][b]Project Tally/Wishlist[/b][/size] [i]A new cell at the top of the page now generated "Wishlist by Dragon" forum code.[/i] Whereas the other box posts a bulk consolidation of ALL genes and vials you'll need for your project, this one divides all that based on the dragon the item is needed for! If you'd like to see the BBCode in action, [b][url=https://www1.flightrising.com/dragon/91137271]check out my dragon Feyre's bio[/url][/b]![/center] [size=5]Taste of a Galaxy[/size]‎[color=transparent]......[/color]#96984030 ----- [columns] [url=https://www1.flightrising.com/dragon/96984030][img]https://flightrising.com/rendern/portraits/969841/96984030p.png[/img][/url] ----- [emoji=treasure]‎ 180,000t [emoji=gem]‎ ‎ 2,100g [color=transparent]__________[/color][nextcol][gamedb item=36572] ----- [gamedb item=36612] ----- [gamedb item=36591] ----- [gamedb item=47282] ----- [gamedb item=39296] [color=transparent]___________________________________[/color][nextcol]1,000g ----- 105,000t ----- 600g ----- 500g ----- 75,000t [/columns] [center][emoji=rainbow star 2] [size=4][b]Project Tally/Wishlist[/b][/size] [i]Three checkboxes columns have been added to the tab to account for the three exalt bonuses (breed, gene, color). Easy enough.[/i] ----- [emoji=spiral scared] [size=5][b]Notice any errors?[/b][/size] Please let me know! I fiddle with this sheet a LOT, and I still miss a lot of things! Seriously, this thing has friend my eyes more times than I can count. And if you'd like to be notified whenever I made edits to the sheet, join the pinglist! [pinglist=38550] @pinglist-38550