Know your Lair' colors at a GLANCE! | Guides

[center][b][size=6]Color Coded, Responsive Excel Sheet[/size] So you can see all your dragons' colors at once![/b][/center] [emoji=spiral star size=1] Hello all! I had way too much free time on my hands at work, and created a useful tool to know ALL of your clan's gene colors at a glance. [img]https://i.imgur.com/6ZQaPui.png[/img] We all know about the wonderful [url=http://fr.fintastic.net/]Flight Rising Color Predictor tool[/url] (or maybe you didn't, in which case, you're welcome!), problem is, if you have covered your dragons head to toe in accents, skins and apparel, then you may not be able to keep track of their colors anymore. It's also annoying to navigate your lair when you just wanted to double check whether two dragons would be compatible or not. I am tired of clicking and browsing through all my tabs to find close color ranges, and then copy their IDs, to then put it in the Predict Morphology to see if it the offspring would even look good. So you'll be glad to hear I've painstakingly coded an excel sheet that can help you out! [center][emoji=scroll size=1][color=orange][b][size=6]>>> [url=https://docs.google.com/spreadsheets/d/1O30WpBkVRBVgD949ZgoMGZc-FkTDVaHM0mZeqxB8IDM/edit?usp=sharing]EXCEL SHEET[/url] <<<[/size][/b][/color][emoji=scroll size=1] https://docs.google.com/spreadsheets/d/1O30WpBkVRBVgD949ZgoMGZc-FkTDVaHM0mZeqxB8IDM/edit?usp=sharing [size=5][b]How to use[/b][/size][/center] This original sheet is in view only mode. Make a copy of the excel sheet to your own google drive (I did a brief test on Microsoft Excel and it does seem to work as well). [img]https://i.imgur.com/5URYZbY.png[/img] Then, you can see you are on the first tab of the sheet, the [color=red][b]template[/b][/color]. [img]https://i.imgur.com/doS21N1.png[/img] This is where you can modify things to suit your own lair. [LIST] [*]To add more dragons rows, you can [i]right click + make new rows [/i]. [*]You can always [i]right click + hide[/i] and [i]right click + unhide[/i] to compare different tabs and such. [*]You can scroll horizontally to add more pages in the same tab. Frankly, I tried to investigate the page limit on each tab and I believe there doesn't seem to be one. So if you have more than 7 pages in the same tab, you'll have to do some sleuthing to make it suit your needs. If you know the basics of excel, it should be pretty self explanatory. [/LIST] [size=5][b]IMPORTANT NOTE:[/b] When you fill in your dragons' colors, make sure that the spelling is correct, or the background will not fill appropriately.[/size] As an example, the second sheet on the excel is [b]my lair's [/b]dragons, their gender, colors and ID, so you know what it'll look like when populated. [img]https://i.imgur.com/ImBwWkD.png[/img] [b]NOTE:[/b] If you'd like to make new SHEET tabs with the same color-formatting, you'll have to COPY one of the existing sheets. Otherwise, the formatting will not transfer. Uhh, that should be it! I know the terminology can be a bit confusing, so let me know of any questions or issues you encounter. [emoji=spiral tongue size=1]

PequeneNinho

780

608

1134

543

May 18, 2022 11:45:48

Color Coded, Responsive Excel Sheet
So you can see all your dragons' colors at once!

Hello all! I had way too much free time on my hands at work, and created a useful tool to know ALL of your clan's gene colors at a glance.

We all know about the wonderful Flight Rising Color Predictor tool (or maybe you didn't, in which case, you're welcome!), problem is, if you have covered your dragons head to toe in accents, skins and apparel, then you may not be able to keep track of their colors anymore. It's also annoying to navigate your lair when you just wanted to double check whether two dragons would be compatible or not.
I am tired of clicking and browsing through all my tabs to find close color ranges, and then copy their IDs, to then put it in the Predict Morphology to see if it the offspring would even look good.

So you'll be glad to hear I've painstakingly coded an excel sheet that can help you out!

>>> EXCEL SHEET <<<

https://docs.google.com/spreadsheets/d/1O30WpBkVRBVgD949ZgoMGZc-FkTDVaHM0mZeqxB8IDM/edit?usp=sharing

How to use

This original sheet is in view only mode. Make a copy of the excel sheet to your own google drive (I did a brief test on Microsoft Excel and it does seem to work as well).

Then, you can see you are on the first tab of the sheet, the template.

This is where you can modify things to suit your own lair.

To add more dragons rows, you can right click + make new rows .
You can always right click + hide and right click + unhide to compare different tabs and such.
You can scroll horizontally to add more pages in the same tab. Frankly, I tried to investigate the page limit on each tab and I believe there doesn't seem to be one. So if you have more than 7 pages in the same tab, you'll have to do some sleuthing to make it suit your needs. If you know the basics of excel, it should be pretty self explanatory.

IMPORTANT NOTE: When you fill in your dragons' colors, make sure that the spelling is correct, or the background will not fill appropriately.

As an example, the second sheet on the excel is my lair's dragons, their gender, colors and ID, so you know what it'll look like when populated.

NOTE: If you'd like to make new SHEET tabs with the same color-formatting, you'll have to COPY one of the existing sheets. Otherwise, the formatting will not transfer.

Uhh, that should be it! I know the terminology can be a bit confusing, so let me know of any questions or issues you encounter.