Guides

What the title says. Anyway, [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365055192485970/updivider.png[/img] [center][b][size=6]Dragon Data to Sheets[/size][/b][/center] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054819172352/downdivider.png[/img] [center][size=5][url=https://blue-latios.github.io/FRStuff/dragon-to-sheets/]Click here to go to Individual Dragon Tool webpage[/url][/size][/center] > [url=https://docs.google.com/spreadsheets/d/1C_Bsog-brvpPR1ANAhLgegZdtorwwtCUcswm40W7cCc]Click here for Dragon Spreadsheet template to make your own copy.[/url] What it basically does is turn something like this: [img]https://cdn.discordapp.com/attachments/719770841117622322/1147845741713297558/image.png[/img] Into something like this: [img]https://cdn.discordapp.com/attachments/719770841117622322/1147845834206085150/image.png[/img] How I use it: [list=1] [*]Copy all of the dragon page. On mobile, I hold press any text, then Select All, then Copy. On PC (Ubuntu, Firefox), I press Ctrl+A to Select All and Ctrl+C to Copy. [*]Paste (Ctrl+V) into the tool's textbox that says "Copy Paste here". [*]Click the Copy button on the tool. [*]Paste it in the first column of a row in the template Sheet. [/list] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365055192485970/updivider.png[/img] [center][b][size=6]Lair Data to Sheets[/size][/b][/center] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054819172352/downdivider.png[/img] [center][size=6][url=https://blue-latios.github.io/FRStuff/lair-to-sheets/]Click here to go to Lair Tool webpage[/url][/size][/center] > [url= https://docs.google.com/spreadsheets/d/1PwXIpCnLr10SYvqNkqX5B2DW9P-QlvUXQ9qA8o5AjY8]Click here for Lair Spreadsheet template to make your own copy.[/url] What it basically does is on a page like this: [img]https://cdn.discordapp.com/attachments/719770841117622322/1151165471022923836/image.png[/img] You go to its [u]Page Source[/u]. If you see something like this, you're on the right track: [img]https://cdn.discordapp.com/attachments/719770841117622322/1151165772488511528/image.png[/img] Finally, copy all the text, use the tool, and you'll end up with something like this: [img]https://cdn.discordapp.com/attachments/719770841117622322/1151217055018786868/image.png[/img] How I use it: [list=1] [*]Go to a lair/den page. [*]Go to its [u]Page Source[/u] by adding [b]view-source:[/b] in front of the page's URL link. (Example: view-source:https://www1.flightrising.com/lair/565671) [*]Copy all the text by Select All (Ctrl+A) and Copy (Ctrl+C). [*]Paste (Ctrl+V) into the tool's textbox that says "Copy Paste here". [*]Click the Copy button on the tool. [*]Paste it in the first column of a row in the template Sheet. [/list] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054349418547/divider.png[/img] [center][size=4]Difference in data between the two tools[/size][/center] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054349418547/divider.png[/img] Individual Dragon Tool have: [list] [*]Birth Date [*]isBred [*]Length [*]Wingspan [*]Weight [/list] Lair Tool have: [list] [*]Level [/list] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054349418547/divider.png[/img] [center][size=4][b]Extension Tools[/b][/size][/center] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054349418547/divider.png[/img] [list] [*][size=4][url=https://blue-latios.github.io/FRStuff/color-range-finder/]Link to Color Range Finder tool[/url]. [/size]For finding which pairs of dragons can produce target colors or color ranges. [*][size=4][url=https://blue-latios.github.io/FRStuff/sheets-columns-sorter/]Link to Sheets Columns Sorter tool[/url]. [/size]Rearrange your columns in your Sheets with this tool. (Can be used on any spreadsheet, not limited to the templates above.) [/list] [img]https://cdn.discordapp.com/attachments/719770841117622322/1012365054349418547/divider.png[/img] Feel free to leave feedback and comments! I hope this tools prove to be useful, one way or another ^^

This thing is absolutely amazing, I've been wanting to do something like it for a looong time but could never work up the motivation to individually put every piece of it into each little cell, but it's so easy and doable with this, it took like fifteen minutes. And the charts are just the cherry on top, omg

*sobs*

I love you. I love you so much.

Will you marry me?

so much love for your right now..

THANK YOU FOR THIS GODSEND <3

Oh! FYI -- your forgot 'Pearl' in the conditional formatting for the colours! I added a second tab, for the Hibernal Den, and then combined the charts, but it might be worth adding as an option for other people? I'm not the best at playing with Sheets, lol. I'm also thinking about adding a chart for a combination of *all* the genes, to show which one is most popular as a whole in my lair and den, but I'm not sure I'll figure it out ahaha. I still have 126 dragons to add, but omg, this has made it SO much easier!! [img]https://cdn.discordapp.com/attachments/1092095981295767662/1148629877474476103/image.png[/img]

@ThistleProse Thank you! I must've somehow removed the last color while checking things are okay. Spreadsheet's been fixed and updated! (Pinging @HalfPintVerdance as well just in case)

For those who have already copied the template and added many dragons in:

1. Select the Primary, Secondary, and Tertiary color columns
2. Right click, go to Conditional Formatting
3. Click Add Another Rule
4. On "Format Cells If" dropdown, select "Text is Exactly", and enter "Pearl" in the value box below it
5. Change the fill option (the bucket icon), scroll down to a + symbol to add a custom color, and paste #fbedfa hex code (if you want to use that color!)

And for the other feedback:
I figured that you could either duplicate the sheet to make a seperate tab, or copy a new spreadsheet template if people want to differentiate Lair and Hibden dragons :o

I could maybe help you with that if you want a chart for "All" genes? (Though idk exactly what "All" would mean)

---

Charts is optional, but there were issues with Permabab and Silhouette pie charts that I fixed, and I added table charts to show dragon sizes (length, wingspan, weight) in order. They're optional and I assume people could make their own charts, but if people have previously used the template before the update and would like an update on the charts, do let me know!

Also I have not been ignoring the posts, I've been silently appreciating them very much but don't know what to post in response

Had to test this tool for personal use as well [emoji=bogsneak laughing size=1] With some breaks, it took about 1 hour and 15 minutes to add 522 dragons' data to Google Sheets. I should've thought of making a tool like this years ago XD Update: For some reason the Element coloring was missing on row 4. That's been fixed now!

Update: I now have added a tool but instead of individual dragons, you can record an entire page of dragons! (at the cost of not being able to check some attributes)

Also, froze the first column of the template sheets so you can keep track by name which dragon has what attribute.

To unfreeze a column, select (right-click) a column, go to View more column actions, and Unfreeze column.

@BlueLatios

Is there a way I can use this to help with pairs for projects? Cause this is amazing o-o

or are you planning any updates for extra features like that? >w<

@Rosekitten atm what I can add to the webpage tools are those on respective pages that I decided to not add (like parents names and offspring names for individual dragon tools) so it's a bit limited on what extra features I could add.

As for the spreadsheet templates, I guess maybe some extra things can be added depending on what it is in Charts sheet (such as the number of Unnamed dragons).

That said, do you have an idea in mind how you expect the tools could help with pairs of projects? :o

@BlueLatios

oo yeah that's all French to me, the fact this is so easy compared to old methods I have used to input data is just bonkers :'D

mainly just a color estimate, like scan over input data and determine x dragon and y dragon could get the range or within range of what you are looking for. I think there are other sheets out there for that as well. This one is just so simple and clean T_T haha.