Guides

[center][size=5][b]Due to just life in general, I'm not as active on Flight Rising. The Auto Dragon Price Calculator Spreadsheet will still be staying but I won't be updating it further myself, I've left instructions on the spreadsheet itself on how you can edit and modify your own copy of it. If you happen to still be in trouble with how to adjust the spreadsheet, feel free to send me a message and I'll get back to you when I can.[/b][/size] [size=4]A spreadsheet tool for those who breed and sell dragons, and wish to keep track of custom, consistent prices This is a revamped spreadsheet based on the original tool made by sciencings, including a whole new layout, dropdown cells, color coded cells based on rarity, and exposed formulas for easy copy/editing of the calculations page if necessary.[/size] [b]Version 6 is LIVE![/b] Unlike previous versions, this version now takes out a lot more of the manual editing of cells on the first page of the spreadsheet. This means it will be a quicker and easier way for new people to insert new data when there's new FR content. Apologies to those who took lessons on how to edit things manually, I hope you find this update to be Much easier to use and new user friendly! In Version 6: [LIST] [*]You only need to edit, insert or adjust the prices under the "Prices" page of the spreadsheet. [*]The Data Validation cells under the "Insert Stats Here" page does not need to be manually adjusted. [*]The Data Validation/Dropdown cells on the "Insert Stats Here" page will automatically correct to whatever is added or changed on the "Prices" page. [*]These convenience changes are thanks to changing columns "Breeds", "Primary/Secondary/Tertiary Genes", "Eyes", and "Level" data validation options reading from a "List of Items" to a "List Range" which is displayed on the price page. This is something I should have identified and implemented much sooner, apologies again! [/LIST] [size=6][url=https://docs.google.com/spreadsheets/d/1vnBccxrfA7BWUlqAlgRdUuBqgjMzkyu6l_6UEWeEi6k/edit?usp=sharing]Click here for the spreadsheet![/url][/size] [size=5][b]This spreadsheet is intended to be copied to your own google drive, and to edit your own prices! You can do so by logging in to google, go up to File on the spreadsheet, and Make A Copy. Please note that some browsers may not let you use or edit the spreadsheet properly, to fix this try another browser.[/b][/size] Previews of the spreadsheet: [img]https://i.imgur.com/2sHGEH5.png[/img] [img]https://i.imgur.com/GjdQQQm.png[/img] And finally a big thank you to sciencings for allowing me to continue this tool, and for making the original spreadsheet! =) [/center] --------- [size=3]Updates[/size] [size=2] 17/05/2020 V6.1 - Added Breeds: Banescale - Added Eye Types: Innocent - Added Genes: All genes for all breeds up to Glowtail Update - Rearranged some genes to reflect rarity changes [size=1] 14/09/2019 V6 BIG UPDATE - Added Breeds: Gaoler - Added Eye Types: Goat, Swirl - Added Genes: Laced, Edged, Gaoler Genes up to Blossom, Leopard, Clouded. Gaoler Genes May change name when more ancients get added and if there's any shared genes. - Rearranged Price page for future convenience - Adjusted some Data Validation cells for page “input stats here” so they read from a range, not a list, requiring less manual updating of “input stats here” page cells when new content needs to be added. The only page needing manual input is the “Prices” page. The “input stats here” page should automatically show newly added genes, breeds and eyes in the dropdown cells, from content added manually to the “Prices” page - Changed raw formula page to reflect edits to other pages. - Changed label names for color combinations - Changed a text box to display recently added content and changes. Weee! 04/03/2019 V5.2 - Added Constellation & Peacock 29/10/2018 V5.1 - Added Lionfish, Noxide & Dark Sclera. Condensed columns on first tab. Example images added to forum post 24/09/2018 V5 - Added Eye type column, Added Ringlets 11/08/2018 V4.4 - Added Starmap 28/07/2018 V4.3 - Added Python, Morph & Firefly Genes 15/04/2018 V4.2 - Added Filigree Gene 20/03/2018 V4.1 - Added Ghost Gene 23/01/2018 V4- Rewrite of Codes! It's now much simpler for breed, gene and level columns :) Added Wasp, Tapir, Bee, Striation, Smirch, Pinstripe, Trail Added new Level Price Calculation, for those interested in selling leveled dragons and need quick price calculations with customizable price range. Fixed Rune not calculating right, oops. Fixed Jaguar & Rosette not showing, double oops. 29/09/2017 V3 - Added Jaguar, Rosette and Capsule Genes + updated raw data accordingly for updating existing copies. 09/06/2017 V2 - Added Column for Gen One option + price cell for adjusting. Fixed unfinished final price cells. Version 1 - Initial release! Sav/Saf genes added

Pinglist for updates ::: [code] @Huntess @moonrose50 @xdorKusmaxIMusx @mzvalkyrie @Shleedelie @Stormster @HeadlessKing @Bearinator @Raksha18 @StarPig @MiniCrisps @PandaOverlord @minervamaga [/code] template for update post (just ease of access) [code] [center][b]Update # & Date[/b] Description [url=https://docs.google.com/spreadsheets/d/1vnBccxrfA7BWUlqAlgRdUuBqgjMzkyu6l_6UEWeEi6k/edit?usp=sharing]Click here for the spreadsheet![/url] [/center] [size=1] Pinglist [/size] [/code]

@IvyKirax This is So useful! Please Can you Ping me For Updates? <3

@Huntess I can definitely do that ^^

@MaximumSpyro I don't see a CD category could you please elaborate where you see that? and RTB is Ready to Breed =) Some people put a value on dragons that are ready to breed , If you're not too worried about that then can always leave it as no.

@MaximumSpyro I don't see that on any of the spreadsheet I made, plus that layout doesn't look like the one I did either [img]https://i.gyazo.com/da630dd66876f3de89c231c7fad3cd3a.png[/img] [img]https://i.gyazo.com/9be05cbd4783a46a0027a51ad9af0791.png[/img] [img]https://i.gyazo.com/cf60fa954eb49c3a22616f3a97d63003.png[/img]