Guides
Community created guides, helpful strategies, and more.
TOPIC | [TOOL] Auto Dragon Price Calc - Lep/Clou
1 2 3 4 5 6 7 8 9 10
[center][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] 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! [size=1] 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
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.

Version 6 is LIVE!
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:
  • 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!



Click here for the spreadsheet!

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.



Previews of the spreadsheet:

2sHGEH5.png


GjdQQQm.png


And finally a big thank you to sciencings for allowing me to continue this tool, and for making the original spreadsheet! =)



Updates

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
CD2CEpm.pnggqwsxF6.pngk0JOwC9.pngqAuxDkF.pngTjkcuwH.png
Pinglist for updates ::: [code] @Huntess @moonrose50 @xdorKusmaxIMusx @mzvalkyrie @Shleedelie @Stormster @HeadlessKing @WishesGranted @Bearinator @Raksha18 @StarPig @DragonSanctuary @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]
Pinglist for updates :::


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]
CD2CEpm.pnggqwsxF6.pngk0JOwC9.pngqAuxDkF.pngTjkcuwH.png
Update V2 09/06/2017
Added a new Gen 1 column for those wanting to value them, plus a cell to change the price bonus for gen 1's under the price page (current placeholder +20kt). Fixed unfinished Final Treasure Price cells, they now calculate right!
Update V2 09/06/2017
Added a new Gen 1 column for those wanting to value them, plus a cell to change the price bonus for gen 1's under the price page (current placeholder +20kt). Fixed unfinished Final Treasure Price cells, they now calculate right!
CD2CEpm.pnggqwsxF6.pngk0JOwC9.pngqAuxDkF.pngTjkcuwH.png
@IvyKirax This is So useful! Please Can you Ping me For Updates? <3
@IvyKirax This is So useful! Please Can you Ping me For Updates? <3
small_by_huntesscrimsonsong-dcsgm4o.gif Huntess
- SubSpecies
- Wishlist
- Clan Lore
- Dream Dragons
XXX XXX XXX XXX XXX XXX XXX
XXX
XXX
XXX
small_2_by_huntesscrimsonsong-dcsgm3z.gif
definitely gonna check this out, i was looking for something like this! : )
definitely gonna check this out, i was looking for something like this! : )
27HH2Wo.png
What is "CD" category, and what's RTB? Ready to Breed? And how to you value that?
What is "CD" category, and what's RTB? Ready to Breed? And how to you value that?
SIdwfny.png
@Huntess I can definitely do that ^^
@Huntess I can definitely do that ^^
CD2CEpm.pnggqwsxF6.pngk0JOwC9.pngqAuxDkF.pngTjkcuwH.png
@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 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.
CD2CEpm.pnggqwsxF6.pngk0JOwC9.pngqAuxDkF.pngTjkcuwH.png
[url=https://imgur.com/KnFmx2W][img]http://i.imgur.com/KnFmx2W.png[/img][/url] @IvyKirax It's under the letter M~
KnFmx2W.png

@IvyKirax It's under the letter M~
SIdwfny.png
@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]
@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

da630dd66876f3de89c231c7fad3cd3a.png

9be05cbd4783a46a0027a51ad9af0791.png

cf60fa954eb49c3a22616f3a97d63003.png
CD2CEpm.pnggqwsxF6.pngk0JOwC9.pngqAuxDkF.pngTjkcuwH.png
1 2 3 4 5 6 7 8 9 10