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]
[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
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.
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:
"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
it speeds up the process of making outfit bbcode like this:
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
Apparel
A brace of wood and feathers for a woodland dragon.
1400
Frosted Woodguard
Moondust Starsilk Earrings
Apparel
A dangling star-shaped earring of polished metal. The surface catches the light and reflects back a galactic spectrum of colors.
1000
Moondust Starsilk Earrings
Moondust Starsilk Wingdrapes
Apparel
A collection of radiating silk bands, held together on the wearer's wings by star and moon clasps.
1625
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)