Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | [TOOL] Blue's Tools
[quote name="@BlueLatios" date="2023-09-26 12:05:03" ] Made a new tool to sort columns in sheets! Link in the first page as usual. @/ThistleProse I assume you mean to input data into the Dragons tab of the Mega Project Tool sheet. If so, the order of the columns from my tool (individual dragons) to that one would be: [size=4][font=Courier New]C E H I J K L M N G O W _ _ D Q _ R S T[/font][/size] (And yes, the tool supports multiple rows of sheets data, as usual) Edit: [quote]But honestly, whatever is the easiest for you to put together!! I will appreciate it either way, if it means I don't have to manually type out all the information lmao /lazy [/quote] You'd think I'd have this idea long before I type in every single dragon detail one year ago, all 300 dragons... my brain's slow to understand there's an easier way and am now one year late ^^' [/quote] /bows before your amzingness you are my saviour XD \o/ Now to figure out why the damned Project sheet is glitching :rolling eyes:
@BlueLatios wrote on 2023-09-26 12:05:03:
Made a new tool to sort columns in sheets! Link in the first page as usual.

@/ThistleProse
I assume you mean to input data into the Dragons tab of the Mega Project Tool sheet.

If so, the order of the columns from my tool (individual dragons) to that one would be:

C E H I J K L M N G O W _ _ D Q _ R S T

(And yes, the tool supports multiple rows of sheets data, as usual)

Edit:
Quote:
But honestly, whatever is the easiest for you to put together!! I will appreciate it either way, if it means I don't have to manually type out all the information lmao /lazy

You'd think I'd have this idea long before I type in every single dragon detail one year ago, all 300 dragons... my brain's slow to understand there's an easier way and am now one year late ^^'

/bows before your amzingness you are my saviour XD \o/

Now to figure out why the damned Project sheet is glitching :rolling eyes:
_____________________
ThistleProse
Aussie | she/her
Looking For:
Skin: TheSeaClouds #57908 by Bluedragon

@ThistleProse I have an unusual idea. What if I take a look at your Project sheet and I figure out what's going on wrong? (If you tell me what's wrong there.) The tool you're using, the owner/founder seems to not have updated it in a while.
@ThistleProse I have an unusual idea. What if I take a look at your Project sheet and I figure out what's going on wrong? (If you tell me what's wrong there.) The tool you're using, the owner/founder seems to not have updated it in a while.
OoOooOo! Spooky text~
[quote name="BlueLatios" date="2023-09-27 03:38:01" ] @ThistleProse I have an unusual idea. What if I take a look at your Project sheet and I figure out what's going on wrong? (If you tell me what's wrong there.) The tool you're using, the owner/founder seems to not have updated it in a while. [/quote] Honestly, I would appreciate it! It looks like hte original author has had some IRL stuff keeping them occupied, which I don't begrudge them! I'm just useless with spreadsheets lmao. I made a more detailed post on their thread [url=https://www1.flightrising.com/forums/gde/2786335/8#post_55154242]here[/url]. I've been playing around iwth it for hte last few hours lol.
BlueLatios wrote on 2023-09-27 03:38:01:
@ThistleProse I have an unusual idea. What if I take a look at your Project sheet and I figure out what's going on wrong? (If you tell me what's wrong there.) The tool you're using, the owner/founder seems to not have updated it in a while.

Honestly, I would appreciate it! It looks like hte original author has had some IRL stuff keeping them occupied, which I don't begrudge them! I'm just useless with spreadsheets lmao.

I made a more detailed post on their thread here. I've been playing around iwth it for hte last few hours lol.
_____________________
ThistleProse
Aussie | she/her
Looking For:
Skin: TheSeaClouds #57908 by Bluedragon

@ThistleProse Ah, the formula on your screenshot there have been mashed all into a single line... That's usually my weakness, I try to usually break down things into multiple steps to reach the end result :'v
@ThistleProse Ah, the formula on your screenshot there have been mashed all into a single line... That's usually my weakness, I try to usually break down things into multiple steps to reach the end result :'v
OoOooOo! Spooky text~
Update! It's been a while, but I decided to make a new tool, and give attention to some other tools:


Predict Morphology Lite tool

This is the new tool I worked on, I would like feedback if this could somehow be a much useful tool for planning gene projects, as not all dragons have all parallel genes as of now.

Link to Recent History to Sheets tool

A tool that I regularly use to help manage the fun, slightly chaotic nature of the market in Auction House. Maybe it could help others.

Link to Wishlist Generator tool
Simple wishlist maker tool that I made a long time ago, did not see much light.
Update! It's been a while, but I decided to make a new tool, and give attention to some other tools:


Predict Morphology Lite tool

This is the new tool I worked on, I would like feedback if this could somehow be a much useful tool for planning gene projects, as not all dragons have all parallel genes as of now.

Link to Recent History to Sheets tool

A tool that I regularly use to help manage the fun, slightly chaotic nature of the market in Auction House. Maybe it could help others.

Link to Wishlist Generator tool
Simple wishlist maker tool that I made a long time ago, did not see much light.
OoOooOo! Spooky text~
[emoji=guardian star size=4]
ogoOZZn.png D1BNR47.png Greyhound in a cozy Ice parka
This is truly amazing!
This is truly amazing!
gRzB0Di.pngmx2DApb.pnghFZSb6U.pngPWAbOMs.png FRT +9
Bumping because everyone needs this
Bumping because everyone needs this
gRzB0Di.pngmx2DApb.pnghFZSb6U.pngPWAbOMs.png FRT +9
Predict Lite Tool got an update: [list] [*]Eye Spots and Dark Sclera and Dark eye types are now properly shown. Bug fix. [*]Now, if there are disabled breeds, you are not allowed to select that gene. No more checking which dragons have which genes when deciding on genes first! [*]Instead of just seeing which breeds are disabled, you can limit the gene pool by breed selection. [*](The randomizing part is also limited to the available/selected breeds). [*]You can now paste FR scry links to the tool as well! [/list] Lair to Sheets tool update: [list] [*]Clarified that you can also use a tab's Edit page to get the entire tab instead of getting dragon data page by page. [*]Added clarification that most mobile phones are unable to use this tool because of copy character limits. [/list]
Predict Lite Tool got an update:
  • Eye Spots and Dark Sclera and Dark eye types are now properly shown. Bug fix.
  • Now, if there are disabled breeds, you are not allowed to select that gene. No more checking which dragons have which genes when deciding on genes first!
  • Instead of just seeing which breeds are disabled, you can limit the gene pool by breed selection.
  • (The randomizing part is also limited to the available/selected breeds).
  • You can now paste FR scry links to the tool as well!

Lair to Sheets tool update:
  • Clarified that you can also use a tab's Edit page to get the entire tab instead of getting dragon data page by page.
  • Added clarification that most mobile phones are unable to use this tool because of copy character limits.
OoOooOo! Spooky text~
Changed the thread title, since I want to share my most recent tool to FR. Also, I will have to update the tool every month to add the new ancient fest genes. If I haven't updated the tool, it's likely that I forget, feel free to ping or message to remind me!

As of now, the tool has included the Brightshine option for Banescale and Dusthide!
Changed the thread title, since I want to share my most recent tool to FR. Also, I will have to update the tool every month to add the new ancient fest genes. If I haven't updated the tool, it's likely that I forget, feel free to ping or message to remind me!

As of now, the tool has included the Brightshine option for Banescale and Dusthide!
OoOooOo! Spooky text~