Guides

[center]Do you know what I love? Google sheets! And do you know what I dislike? BBCode, especially if I have to write it from scratch! And also messy lairs! [s]Which is hypocritical, no one look at my lair.[/s] And trying to budget for dragon projects when I am so, so terrible at keeping record of how much money is going in and out of my hoard! So why not use Google sheets to rectify some of these problems? [size=5][b][emoji=rainbow star 2 size=1] [url=https://docs.google.com/spreadsheets/d/1XQlNtcHMDmvtygmAstUNVhYjdKf2DyMLtFlXIhzTgWM/edit?usp=sharing]BassetBites' Flight Rising Toolkit[/url] [emoji=rainbow star 2 size=1][/b][/size][/center] [quote name="HOW TO USE"] [center][b]HOW TO USE[/b][/center] [list=1] [*]Click File > Make a Copy to save your very own version of this document onto your own Drive! Give the Sheet permissions if it asks for them. [*]Start filling out the proper boxes! As a general rule of thumb, [b]only the gold boxes need any user input.[/b] Everything else should generate automatically based on what's in those gold boxes. [/list][/quote] [center]And that's it! It's really that simple! 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? If you wanna know more about what each part of the sheet does and how to use it, keep reading! [emoji=rainbow star 2 size=1] [size=4][b]WIDGET GENERATOR[b][/size] [i]Will generate your dragon's portrait, avatar, and Coliseum art.[/i] [columns][color=transparent].............[/color] [nextcol][center][url=https://www1.flightrising.com/dragon/30915158][img]https://flightrising.com/rendern/portraits/309152/30915158p.png[/img][/url] [b]PORTRAIT[/b][/center] [nextcol][list][/list] [nextcol][center][url=https://www1.flightrising.com/dragon/30915158][img]https://flightrising.com/rendern/avatars/309152/30915158.png[/img][/url] [b]AVATAR[/b][/center] [nextcol][list][/list] [nextcol][center][url=https://www1.flightrising.com/dragon/30915158][img]https://flightrising.com/rendern/coliseum/portraits/309152/30915158.png[/img][/url] [b]COLISEUM ART[/b][/center][/columns] Simply paste your dragon's URL into the gold box and let the sheet do the rest! No more remembering that pesky conversion trick to get your dragon's portraits! [emoji=rainbow star 2 size=1] [size=4][b]G1 WITH SCRY SALE POST[b][/size] [i]Will generate a sale post for G1s (or any dragon, really) with accompanying scries.[/i] Simply plop your dragon's URL and their scry image URL into the designated boxes, then fill in the rest! This sheet will automatically generate all the formatting for you! [i]Final outcome example below. Fonts and the names of the gene's colors can be customized.[/i] [columns][center][url=https://www1.flightrising.com/dragon/94604010][img]https://www1.flightrising.com/dgen/preview/dragon?age=1&body=15&bodygene=93&breed=20&element=4&eyetype=15&gender=1&tert=18&tertgene=203&winggene=91&wings=64&auth=98c2107198cd0327b7c2ec3d96cc73b03159dcb1&dummyext=prev.png[/img][/url][/center] [nextcol][center][url=https://www1.flightrising.com/dragon/94604010][img]https://flightrising.com/rendern/avatars/946041/94604010.png[/img][/url] [img]https://www1.flightrising.com/static/icons/water_rune.png[/img][img]https://www1.flightrising.com/static/layout/lair/icons/female.png[/img] [b]#94604010[/b] April 24, 2024 [emoji=crystal ball size=1] [url=https://www1.flightrising.com/scrying/predict?breed=20&gender=1&age=1&bodygene=93&body=15&winggene=91&wings=64&tertgene=203&tert=18&element=4&eyetype=15][b]Scrying Workshop[/b][/url] [emoji=primary gene size=1] [b]Lavender[/b] Basic [emoji=secondary gene size=1] [b]Coral[/b] Basic [emoji=tertiary gene size=1] [b]Royal[/b] Basic [emoji=normal eyes size=1] [b]Water[/b] Common [emoji=gem size=1] [b]50g[/b] [emoji=treasure size=1] [b]50kt[/b] [url=http://www1.flightrising.com/auction-house/buy-dragon/94604010][img]https://flightrising.com/images/layout/button_buyauction.png[/img][/center] [/columns] [emoji=rainbow star 2 size=1] [size=4][b]HATCHLING SALE POST[b][/size] [i]Will generate a sale post for hatchlings (or any gened dragon, really).[/i] Very similar to the last one, but this one's specifically tailed for baby dragons that already have pretty genes! [i]Final outcome example below. Fonts and the names of the gene's colors can be customized.[/i] [columns][center][url=https://www1.flightrising.com/dragon/93297868][img]https://www1.flightrising.com/rendern/350/932979/93297868_350.png[/img][/url][/center] [nextcol][center][size=5][b][i]Dune[/i][/b][/size] [b]#93297868[/b] [b]Desert Heat[/b] Mar 07, 2022 [img]https://www1.flightrising.com/static/icons/lightning_rune.png[/img][img]https://www1.flightrising.com/static/layout/lair/icons/female.png[/img] [emoji=DNA size=1] [b]XYZ[/b] [emoji=primary gene size=1] [b]Vermilion[/b] Mochlus [emoji=secondary gene size=1] [b]Stone[/b] Riopa [emoji=tertiary gene size=1] [b]Beige[/b] Paradise [emoji=normal eyes size=1] [b]Lightning[/b] Common [emoji=gem size=1] [b]20g[/b] [emoji=treasure size=1] [b]20kt[/b] [url=http://www1.flightrising.com/auction-house/buy-dragon/93297868][img]https://flightrising.com/images/layout/button_buyauction.png[/img][/center] [/columns] [emoji=rainbow star 2 size=1] [size=4][b]BREEDING PAIR GENERATOR[b][/size] [i]Will generate a breeding card showing the the potential offspring results (genes and colors) of two dragons.[/i] Need a quick breeding card that you wanna post directly to the forums? Not a problem! Upload your two dragons and their morphology URLs into the boxes and see how they'll pair up! [i]Final outcome example below. Fonts and the symbol used for the visual color spectrum can be customized.[/i] [center][url=https://www1.flightrising.com/dragon/79836911][img]https://flightrising.com/rendern/avatars/798370/79836911.png[/img][/url] [url=https://www1.flightrising.com/dragon/91316211][img]https://flightrising.com/rendern/avatars/913163/91316211.png[/img][/url] [size=4][b]Icarus x Leona[/b][/size] [b]Breed[/b] Guardian | Guardian [i]50%[/i] | [i]50%[/i] [b]Primary Genes[/b] Petals | Wasp [i]50%[/i] | [i]50%[/i] [color=#B4CD3D]•[/color][color=#9DA932]•[/color][color=#828335]•[/color][color=#697135]•[/color][color=#4B4521]•[/color][color=#7F7745]•[/color][color=#BEA55D]•[/color][color=#C18E1B]•[/color][color=#D1B300]•[/color] [size=2][i]Chartreuse, Spring, Crocodile, Olive, Murk, Moss, Goldenrod, Amber, Honey[i][/size] [b]Secondary Genes[/b] Butterfly | Bee [i]50%[/i] | [i]50%[/i] [color=#425035]•[/color][color=#51694D]•[/color][color=#97AF8B]•[/color][color=#687F67]•[/color][color=#567D34]•[/color][color=#629C3F]•[/color][color=#7FCE73]•[/color][color=#99FF9C]•[/color][color=#8ECD55]•[/color][color=#A5E32D]•[/color][color=#C6FF00]•[/color][color=#D0E673]•[/color][color=#E8FFB5]•[/color][color=#B4CD3D]•[/color] [size=2][i]Forest, Camo, Algae, Swamp, Avocado, Green, Fern, Mantis, Pear, Leaf, Radioactive, Honeydew, Peridot, Chartreuse[/i][/size] [b]Tertiary Genes[/b] Opal | Opal [i]50%[/i] | [i]50%[/i] [color=#B4CD3D]•[/color][color=#9DA932]•[/color][color=#828335]•[/color][color=#697135]•[/color][color=#4B4521]•[/color][color=#7F7745]•[/color][color=#BEA55D]•[/color] [size=2][i]Chartreuse, Spring, Crocodile, Olive, Murk, Moss, Goldenrod[/i][/size][/center] [emoji=rainbow star 2 size=1] [size=4][b]PROJECT COST CALCULATOR[b][/size] [i]Will generates BBCode for a dragon's goal morphology and the cost of genes. Paste it in their bio to show their goal scry and what genes they still need![/i] Need to keep track of that G1's end goal? Wanna know how much it'll cost, even with Dom discount or Auction House pricing? Here ya go, this tab will generate BBCode that does just that! [i]Final outcome example below. Fonts and the names of the gene's colors can be customized.[/i] [columns][center][url=https://www1.flightrising.com/scrying/predict?breed=19&gender=0&age=1&bodygene=71&body=41&winggene=71&wings=63&tertgene=63&tert=94&element=7&eyetype=16][img]https://www1.flightrising.com/dgen/preview/dragon?age=1&body=41&bodygene=71&breed=19&element=7&eyetype=16&gender=0&tert=94&tertgene=63&winggene=71&wings=63&auth=efc35dde0ce0e00864bf9bebf3e66f783ba48474&dummyext=prev.png[/img][/url][/center] [nextcol][center][size=5][b][i]Archer[/i][/b][/size] [b]#91594084[/b] [url=https://www1.flightrising.com/dragon/91594084][img]https://flightrising.com/rendern/avatars/915941/91594084.png[/img][/url] [img]https://www1.flightrising.com/static/icons/shadow_rune.png[/img][img]https://www1.flightrising.com/static/layout/lair/icons/male.png[/img] [emoji=primary gene size=1] [b]Goldenrod[/b] Shell [emoji=secondary gene size=1] [b]Carmine[/b] Web [emoji=tertiary gene size=1] [b]Copper[/b] Branches [emoji=special eyes size=1] [b]Shadow[/b] Dark [b][i]Project Cost Total:[/i] [emoji=treasure size=1] 345000t [emoji=gem size=1] 1000g[/b] [/center][/columns] [center][item=Breed Change: Veilspun][item=Primary Veilspun Gene: Shell][item=Secondary Veilspun Gene: Web][item=Tertiary Veilspun Gene: Branches][item=Vial of Umbral Sight][/center] [emoji=rainbow star 2 size=1] [size=4][b]DRAGON PROJECT LIST[b][/size] [i]Keeps a condensed record of all project dragons in your lair. [b]This tab does not generate BBCode.[/b][/i] If you have multiple working projects in your lair, use this tab! It'll keep track of your dragon's morphology, how much your project will cost, and how much you've spent already. It'll also tell you if any of the genes you've chosen have availability notes (example: Marva's Button Eye vials are only available during April Fools). [emoji=rainbow star 2 size=1] [size=4][b]PROJECT WISHLIST/TALLY[b][/size] [i]Counts how many copies of each gene you need for your projects in total. Generates a BBCode wishlist.[/b][/i] If you're anything like me, you can remember [b]which[/b] genes and vials you need for your projects, but never [b]how many copies[/b] you need. Ugh. No more of that! This tab will keep track of how many copies of each scroll, gene, and vial you need! What's even nicer? The little Forum Code 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! [url=https://www1.flightrising.com/forums/gde/3336780/2#post_56827845]See the Wishlist Example on this page right here![/url] [emoji=rainbow star 2 size=1] [size=4][b]LAIR LIST[b][/size] [i]Keeps a condensed record of all dragons in your lair. [b]This tab does not generate BBCode.[/b][/i] Do you have a lot of dragons in your lair that you wanna keep track of? Then this is the tab you'll wanna use! Simply input your dragon's info as needed(their name, URL, and morphology image URL), check the appropriate boxes, and see them in a nice, organized view! Use the filters at the top of the sheet to view certain dragons! And because I know how much Flight Rising users love data... [emoji=rainbow star 2 size=1] [size=4][b]LAIR CENSUS[b][/size] [i]Displays data about all the dragons in your lair. All information is pulled from dragons submitted to the Lair List tab. [b]This tab does not generate BBCode.[/b][/i] If you ever wanted to know what the most common gene or color in your lair is, all you have to do is submit your dragons' information into the Lair List tab and let the Lair Census tally that info for you! The Lair Census will automatically pull information from the Lair List, so you don't have to do anything special to this tab! [url=https://i.imgur.com/CZl8b7o.png][img]https://i.imgur.com/CZl8b7o.png[/img][/url] [emoji=rainbow star 2 size=1] [size=4][b]EXALT TRACKER[b][/size] [i]Keeps record of your exalted dragons and your exalting profits. [b]This tab does not generate BBCode.[/b][/i] This one's pretty self explanatory! If you like to track your exalts and how much money you make, this tab will do the tracking for you so long as you input all the right info! [emoji=rainbow star 2 size=1] And that's all! Please let me know if there are any errors I missed, my eyes are a bit fried from this so it's entirely possible something escaped me :) [/center]

[center][size=5][b][emoji=rainbow star 2 size=1] QUESTIONS [emoji=rainbow star 2 size=1][/b][/size][/center] [size=4][b]"Can this sheet generate my dragon's images off their URL?"[/b][/size] [indent] [b]No.[/b] This sheet cannot do that because, as per [url=https://flightrising.com/main.php?p=wiki&article=81]Flight Rising's terms of use[/url], [b]it cannot scrape data[/b] off the website. This includes images. If you'd like to fiddle around and paste your dragon's images into the sheet, be my guest, but by default this sheet CANNOT do that. The only reason you need your dragon's [b]morphology image URL[/b] is because the sheet relies on the type in that link (bodygene, winggene, tertgene, etc.). It picks everything apart and matches corresponding information to an Index tab (hidden by default) that I added manually into the sheet. If the index breaks, the whole thing breaks.[/indent] [size=4][b]"Do I have to input the Auction House prices manually if I wanna use them?"[/b][/size] [indent] [b]Yes.[/b] See above, same reasoning. This sheet doesn't data scrape.[/indent] [size=4][b]"I broke the sheet! What do I do?"[/b][/size] [indent] Don't panic! If the code in your sheet is malfunctioning: [list=1] [*]Undo your last action until it fixes itself. [*]If that doesn't work, check the master sheet (linked at the top of the forum thread). Copy the contents of the corresponding cell and paste it into your own sheet's broken cell. Either that or make a duplicate. [*]If you don't feel like doing that, reach out here and I'll see if I can give you a hand![/list] I'm not a master at coding or Google Sheets (if you couldn't tell from the messy code). This whole thing was kind of a project I took on as a learning experience. That said, I'll do what I can if something breaks![/indent] [size=4][b]"I noticed an error!"[/b][/size] [indent] Let me know and I'll have a look! It is VERY possible something slipped by me while making this. I'm willing to bet on it.[/indent] [size=4][b]"The sheet is running slow!"[/b][/size] [indent] This sheet is CHUNKY, there's a lot of moving parts. It's going to be a bit slower than you might expect, especially if it's trying to find info from your dragon's scry link (it has to look up a LOT of things). If the [b]Lair List[/b] or [b]Dragon Project List[/b] tabs are running particularly slow, I recommend deleting some empty rows. I give you A LOT by default because I know how some of us all like to hoard projects that [i]we're totally gonna get to, you have to believe me I promise[/i]. But if you don't need that many rows? Delete 'em! Should speed things up a bit.[/indent] [size=4][b]"Why did you make this sheet?"[/b][/size] [indent] Bored.[/indent]

[center][size=5][b][emoji=rainbow star 2 size=1] CHANGELOG [emoji=rainbow star 2 size=1][/b][/size][/center] [list] [*][b]31 May 2024[/b] - Tab update. [indent]- Updated Dragon Project List tab to include checkmarks to mark off genes/vials as they're acquired. Hooray! - Added check columns for Scrolls of Eternal Youth, Scrolls of Maturity, and Silhouette Scrolls in the Dragon Project List tab.[/indent] [*][b]20 May 2024[/b] - New tab update. [indent]- Added new sheet tab: Project Tally/Wishlist - Updated INTRO tab to include information on the new Project Tally/Wishlist tab[/indent] [*][b]16 May 2024[/b] - Gene expansion and error updates. [indent]- Added Tertiary Veilspun Gene: Firebreather, Tertiary Gaoler Gene: Firebreather, Tertiary Sandsurge Gene: Firebreather, Tertiary Banescale Gene: Firebreather, and Tertiary Aether Gene: Firebreather to gene list - Fixed error in the Project Cost Calculator tab that caused the price cell to remain empty if the gene was obtained from the Achievements Association[/indent] [*][b]13 May 2024[/b] - Error updates. [indent]- Fixed improper pricing on Gem Marketplace secondary ancient genes (were listed at 750g, now listed at 600g) - Fixed conditional formatting error on Project List and Lair List tabs (Cells in the secondary gene columns with "Teal" would not be colored teal, but white)[/indent] [*][b]12 May 2024[/b] - Error updates. [indent]- Fixed Secondary and Tertiary color columns saying "Pearl" instead of "Pear" - Fixed Secondary Aberration Gene: Current and Secondary Aberration Gene: Constellation having swapped ID numbers[/indent] [*][b]9 May 2024[/b] - Sheet released. [/list]

Hello! I was using this and one of my dragons with a pear tert got marked as pearl, it doesn't seem to be just a mispelling, as it's counted in the tally and all the other data as being pearl and not pear.

Just tought I'd let you know!

Edit: looked at the index and it looks like pear is written as pearl on both the secondary and tertiary columns!

@Mid0riKage thanks for catching that, should be fixed now! No need to download a new sheet!

Aaaah I was about to edit my post bc I caught another thing while messing with the project calculator! The current (aberration) gene shows up as constellation (aberration). Hope it helps!

@Mid0riKage thank you! Looks like I accidentally switched them when typing them into the Master Index so they got swapped with one another. Should be fixed! Shows how well I proofread everything lmao [emoji=guardian scared size=1]

This looks clean!!! Big fan of the formatting. I definitely see myself using this, and I'll let you know if I run into any mishaps!