Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | Misc. Spreadsheets
I enjoy making sheets and I want to post them, but I feel like some of them don't deserve separate posts. so I'll put them here ^^ [quote=index] [LIST] [*][url=https://www1.flightrising.com/forums/gde/2547269#post_41281687]complex baldwin brew[/url] [*][url=https://www1.flightrising.com/forums/gde/2547269#post_41281946]fr project manager[/url] [*][url=https://www1.flightrising.com/forums/gde/2547269#post_41282036]outfit bbcode + outfit lister[/url] [*][url=https://www1.flightrising.com/forums/gde/2547269/1#post_41579605]find avatar dragon[/url] [/LIST] [/quote]
I enjoy making sheets and I want to post them, but I feel like some of them don't deserve separate posts.
so I'll put them here ^^
timezone: FR+11
[quote=Baldwin Recipe Breakdown] link: [url=https://docs.google.com/spreadsheets/d/1j1z9KMVzmqE8CQKAF36ApedWa53pbkCuLE_W7wK-Dbk/edit?usp=sharing][u]complex baldwin brew[/u][/url][/quote] it breaks down complex baldwin recipes into stages. 1st stage - as presented by baldwin. 2nd stage - for example, if recipe has Glass Beaker, I replace it (Glass Beaker) with ingredients for Glass Beaker and I break it down until only simple ingredients are left. it is useful if you want to do the melting first. how to actually use this sheet: [LIST] [*]go to "recipe breakdown" tab [*]choose an item you want to make [*]choose a stage, and you can see what you need to get. [/LIST] other tabs are not meant to be edited, but you can use them if you want to add a new recipe. "basic mats" - list of items that are used to make another items "brewed items" - items that you can brew, but their only function is to be used in creation of other items "recipes" - broken down recipes
Baldwin Recipe Breakdown wrote:

it breaks down complex baldwin recipes into stages.

1st stage - as presented by baldwin.
2nd stage - for example, if recipe has Glass Beaker, I replace it (Glass Beaker) with ingredients for Glass Beaker

and I break it down until only simple ingredients are left.

it is useful if you want to do the melting first.

how to actually use this sheet:
  • go to "recipe breakdown" tab
  • choose an item you want to make
  • choose a stage, and you can see what you need to get.

other tabs are not meant to be edited, but you can use them if you want to add a new recipe.

"basic mats" - list of items that are used to make another items
"brewed items" - items that you can brew, but their only function is to be used in creation of other items
"recipes" - broken down recipes
timezone: FR+11
[quote=FR Project Manager]link: [url=https://docs.google.com/spreadsheets/d/1TKyxCzeZU7rE8OQG4TFK1zZU3ttXYipssY3EerMYzaY/edit?usp=sharing][u]fr project manager[/u][/url] [/quote] complimentary sheet for [url=https://www1.flightrising.com/forums/gde/2377475][u]Dream Dragons Sheet[/u][/url]. I use it to keep track of dragons that I buy for breeding projects. it generates the difference in colors between a dragon you want to buy and your dream dragon. how to use: you need to have your own copy of [url=https://www1.flightrising.com/forums/gde/2377475][u]Dream Dragons Sheet[/u][/url], it needs Dream Dragons sheet id to function. how to get sheet id: click File>Share, copy the link, and [b]only keep the red part[/b]: [quote=example link] https://docs.google.com/spreadsheets/d/[color=red]1TKyxCzeZFK1zZy3ttXYipss43EerMYzaY[/color]/edit?usp=sharing [/quote] paste it in "dream dergs import" tab. "gen candidates/gen bought": you need a scry link and dragon's id. price and rtb are optional. then you can copy the info from =fast copy= into a text file.
FR Project Manager wrote:

complimentary sheet for Dream Dragons Sheet.

I use it to keep track of dragons that I buy for breeding projects.
it generates the difference in colors between a dragon you want to buy and your dream dragon.

how to use: you need to have your own copy of Dream Dragons Sheet, it needs Dream Dragons sheet id to function.

how to get sheet id: click File>Share, copy the link, and only keep the red part:
example link wrote:
https://docs.google.com/spreadsheets/d/1TKyxCzeZFK1zZy3ttXYipss43EerMYzaY/edit?usp=sharing
paste it in "dream dergs import" tab.

"gen candidates/gen bought": you need a scry link and dragon's id. price and rtb are optional. then you can copy the info from =fast copy= into a text file.
timezone: FR+11
[quote=Lazy Outfit BBcode]link: [url=https://docs.google.com/spreadsheets/d/11jUltPFC-WlTArQqPS425tkkZQ2FZ7hzuuhSrcr4j6I/edit?usp=sharing][u]outfit bbcode + outfit lister[/u][/url] [/quote] it speeds up the process of making outfit bbcode like this: [columns] [img]https://www1.flightrising.com/dgen/dressing-room/dragon?did=42373087&skin=30225&apparel=28999,2503,1792,10713,10734,10727,24718&xt=dressing.png[/img][nextcol] [outfit=830276] [/columns] and also if you want to make a list of apparel you need to buy, it can sort the list alphabetically and include apparel names near [item.=] code [item=Frosted Woodguard] Frosted Woodguard [item=Moondust Starsilk Earrings] Moondust Starsilk Earrings [item=Moondust Starsilk Wingdrapes] Moondust Starsilk Wingdrapes ...I guess I just dislike writing BBcode myself
Lazy Outfit BBcode wrote:

it speeds up the process of making outfit bbcode like this:
dragon?did=42373087&skin=30225&apparel=28999,2503,1792,10713,10734,10727,24718&xt=dressing.png
Not Found

and also if you want to make a list of apparel you need to buy, it can sort the list alphabetically and include apparel names near [item.=] code

Frosted Woodguard Frosted Woodguard
Moondust Starsilk Earrings Moondust Starsilk Earrings
Moondust Starsilk Wingdrapes Moondust Starsilk Wingdrapes

...I guess I just dislike writing BBcode myself
timezone: FR+11
[quote=Find Avatar Dragon] link: [url=https://docs.google.com/spreadsheets/d/1tQTaiX_Qiv-WmPt_105lk_xb6aBDScKz5O8uV1dFvSg/edit?usp=sharing][u]find avatar dragon[/u][/url] [/quote] [img]https://i.imgur.com/Bh68dNJ.png[/img] it can give you a link to a dragon that is displayed as user's avatar. (this sheet if public, so you don't need to make another copy)
Find Avatar Dragon wrote:

Bh68dNJ.png

it can give you a link to a dragon that is displayed as user's avatar.
(this sheet if public, so you don't need to make another copy)
timezone: FR+11