Guides
Community created guides, helpful strategies, and more.
TOPIC | DRAGONOMICS: crowdsourced economy charts
1 2 3 4 5 6 7 ... 41 42
[center][b]>> [url=https://docs.google.com/forms/d/e/1FAIpQLScrml87q7STzZUecj6p_XwPvuhHClzXRNgzcLy3mAcbj7Q2VQ/viewform?c=0&w=1]FORM[/url] // [url=https://docs.google.com/spreadsheets/d/1tEmCh_Vm36Tupm0qQCD1Cc9GBdOyxpkTS5sVwmGDYS0/edit?usp=sharing]SPREADSHEET[/url] // [url=https://docs.google.com/spreadsheets/d/1M7o3oyc12gSGAHQ-02q_SkH6GFc_Qf_6QSlQ7JHIAu0/edit?usp=sharing]NEWS PINGLISTS[/url] <<[/b][/center] [br] [center][size=7]DRAGONOMICS[/size][/center] [br] Dragonomics is a spreadsheet that shows recent dragon fodder price data, based on player-entered statistics. It updates itself whenever someone fills in the Google Form with current Auction House data, and requires no maintenance or input from me; as long as players are filling in the form, it will show useful graphs and data. We are reliant on crowdsourced data entered by players, so submitting [url=https://docs.google.com/forms/d/e/1FAIpQLScrml87q7STzZUecj6p_XwPvuhHClzXRNgzcLy3mAcbj7Q2VQ/viewform]the very easy form[/url] occasionally, having [url=http://www1.flightrising.com/forums/gde/2237277#post_28406045]a button in your signature[/url], and commenting on this post are all super-useful ways to help! [br] [center][img]http://i.imgur.com/vUNNANE.png[/img][/center] [br] [center][b]CONTENTS[/b][/center] [LIST] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406044]1. HOW TO TAKE PART[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406045]2. UPDATES[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406048]3. THE DRAGONOMICS TIME-SENSITIVE REMINDER PINGLISTS[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406049]4. FOOD PRICES[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406052]5. SUMMARY OF LINKS[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406053]Post 6[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406054]Post 7[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406055]8. BUTTONS[/url] [*][url=http://www1.flightrising.com/forums/gde/2237277#post_28406058]9. CREDITS[/url] [/LIST]



DRAGONOMICS




Dragonomics is a spreadsheet that shows recent dragon fodder price data, based on player-entered statistics.

It updates itself whenever someone fills in the Google Form with current Auction House data, and requires no maintenance or input from me; as long as players are filling in the form, it will show useful graphs and data.

We are reliant on crowdsourced data entered by players, so submitting the very easy form occasionally, having a button in your signature, and commenting on this post are all super-useful ways to help!



vUNNANE.png



CONTENTS
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
[right][url=http://www1.flightrising.com/forums/gde/2237277#post_2237277]Back to top[/url][/right] [center][b]1. HOW TO TAKE PART[/b][/center] [br] [b]VIEW THE FODDER SPREADSHEETS[/b] If you ever want to see what dragon prices are doing these days, [url=https://docs.google.com/spreadsheets/d/1tEmCh_Vm36Tupm0qQCD1Cc9GBdOyxpkTS5sVwmGDYS0/edit]click here to view the treasure fodder spreadsheet[/url] and [url=https://docs.google.com/spreadsheets/d/1KRvOyfdeyg9xU0LFLfOG43EhnvVPpJNrL1p6je6h-hw/edit]click here to view the gem fodder spreadsheet[/url]. It'll show you recent dragon price trends, when is the best time of day and day of the week to sell, and whether you should buy or sell right now. Here you can see the way the price of adult fodder gradually climbed to nearly 20,000 T over a one-week period during two competing pushes for flight dominance, thanks to kind players filling in the form every now and again during the push: [br] [center][img]http://i.imgur.com/dc5dYuX.png[/img][/center] Towards the top left of the sheet is a box of meta-info. [img]http://i.imgur.com/zgsSHwK.png[/img] In the [b]NOW[/b] box, it'll tell you whether more information is needed. In this example screenshot it's yellow. [LIST] [*]If the form has been submitted within the last 15 minutes, it'll be white - no urgency at all. [*]If the form has not been submitted for this hour in the day within the last two days it'll be red, indicating URGENT NEED FOR FORM-FILLING-IN! [*]If the form has been submitted for this hour in the day within the last two days, but NOT within the last 15 minutes, it'll be yellow - indicating that filling in the form right now is helpful, but not super urgent. [/LIST] [br] [center]~*~[/center] [br] [b]SUBMIT DATA FOR THE SHEETS[/b] The business end of the forms look a bit like this: [img]http://i.imgur.com/Ksj6ILf.png[/img] It gives you three Auction House links to open, and tells you which numbers to type in. It takes only a few seconds to do. These are the numbers you're collecting: [LIST=1] [*]The total number of dragons in the Auction House [*]The price in treasure of the cheapest adult dragon [*]The price in treasure of the cheapest hatchling dragon [/LIST] Those numbers are then added to the spreadsheet, automagically updating all the graphs with your new information. You can also sign up for reminder pinglists (only when you're playing, and only when the sheets need more data) and get some forum code to copy-paste to ping volunteers [url=https://docs.google.com/spreadsheets/d/1k7B3BGvG5hX-y2NDUYLdLdzgmL1hk2VwcwTSedbaGxE/edit?usp=sharing]here[b]. [br] [center]~*~[/center] [br] The spreadsheet will continue to work without my intervention. So if you want the graphs to be helpful, fill in the form every once in a while, and others will do the same, gradually building up a helpful picture of Auction House activity over time. If you post in the forums occasionally and you want the graphs to be helpful at all hours of the day and night, please consider [url=http://www1.flightrising.com/forums/gde/2237277#post_28406045]adding a button to your signature[/url]. Hopefully people will see it and take part all day round, making the graphs full and useful!
1. HOW TO TAKE PART




VIEW THE FODDER SPREADSHEETS

If you ever want to see what dragon prices are doing these days, click here to view the treasure fodder spreadsheet and click here to view the gem fodder spreadsheet.

It'll show you recent dragon price trends, when is the best time of day and day of the week to sell, and whether you should buy or sell right now.

Here you can see the way the price of adult fodder gradually climbed to nearly 20,000 T over a one-week period during two competing pushes for flight dominance, thanks to kind players filling in the form every now and again during the push:


dc5dYuX.png

Towards the top left of the sheet is a box of meta-info.

zgsSHwK.png

In the NOW box, it'll tell you whether more information is needed. In this example screenshot it's yellow.
  • If the form has been submitted within the last 15 minutes, it'll be white - no urgency at all.
  • If the form has not been submitted for this hour in the day within the last two days it'll be red, indicating URGENT NEED FOR FORM-FILLING-IN!
  • If the form has been submitted for this hour in the day within the last two days, but NOT within the last 15 minutes, it'll be yellow - indicating that filling in the form right now is helpful, but not super urgent.


~*~



SUBMIT DATA FOR THE SHEETS

The business end of the forms look a bit like this:

Ksj6ILf.png

It gives you three Auction House links to open, and tells you which numbers to type in. It takes only a few seconds to do. These are the numbers you're collecting:
  1. The total number of dragons in the Auction House
  2. The price in treasure of the cheapest adult dragon
  3. The price in treasure of the cheapest hatchling dragon

Those numbers are then added to the spreadsheet, automagically updating all the graphs with your new information.

You can also sign up for reminder pinglists (only when you're playing, and only when the sheets need more data) and get some forum code to copy-paste to ping volunteers here.



~*~



The spreadsheet will continue to work without my intervention. So if you want the graphs to be helpful, fill in the form every once in a while, and others will do the same, gradually building up a helpful picture of Auction House activity over time.

If you post in the forums occasionally and you want the graphs to be helpful at all hours of the day and night, please consider adding a button to your signature. Hopefully people will see it and take part all day round, making the graphs full and useful!
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
2. UPDATES




Date: Saturday 15th December 2018

UPDATE

I just added the Time-Sensitive Reminder Pinglists!
2. UPDATES




Date: Saturday 15th December 2018

UPDATE

I just added the Time-Sensitive Reminder Pinglists!
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
[right][url=http://www1.flightrising.com/forums/gde/2237277#post_2237277]Back to top[/url][/right] [center][b]3. THE DRAGONOMICS TIME-SENSITIVE REMINDER PINGLISTS[/b][/center] [br] [center][ [url=https://docs.google.com/spreadsheets/d/1k7B3BGvG5hX-y2NDUYLdLdzgmL1hk2VwcwTSedbaGxE/edit?usp=sharing]click here[/url] ][/center] [b]PING VOLUNTEERS[/b] Just head to the sheet and copy the contents of the green cell, and then paste it as a reply to this forum topic. It will only ping people who have volunteered for the [i]next[/i] three hours (not the current hour), and only when the sheets are short of data. This is good if you want to help out and you notice the graphs are looking threadbare, but you are about to leave the house or go to sleep or something. [img]https://i.imgur.com/rYFhlT5.png[/img] [center]~*~[/center] [b]BE A VOLUNTEER, GET PINGED[/b] There are three tabs you can add yourself to: treasure fodder, gem fodder, and exchange rate. If you're up for filling in the form for any of those, click to the appropriate tab along the bottom, and then add your username to the hours of the day (Flight Rising server time!) that you are usually online. Now people can copy and paste the contents of the green cell into this forum thread, and you'll be pinged and directed to the sheets. You will only be pinged if you're likely to be online and if the spreadsheets are short of data - but of course, filling in the form is always helpful whether you've been pinged or not! [center]~*~[/center] [b]STOP PINGING ME DAMNIT[/b] Just go back to the tabs and remove your username! Ctrl+F can help you to find yourself. [center]~*~[/center] [b]EMBED COPY-PASTE CODE INTO ANOTHER SPREADSHEET[/b] If, like me, you have a spreadsheet to keep track of all your FR junk, you can paste the following into a Google Sheet cell and it will gather the code from the Reminder Pinglist sheet. [code]=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1k7B3BGvG5hX-y2NDUYLdLdzgmL1hk2VwcwTSedbaGxE","INTRO!F12")[/code] It might take a few moments! [b]Important:[/b] If your Google Sheet has default settings, it will only update that cell automatically when you edit something elsewhere on the sheet ("on change"). So go to [i]File > Spreadsheet settings... > Calculation > Recalculation[/i] and choose "On change and every minute". That'll ensure that the contents of your IMPORTRANGE are always up-to-date. If it ever breaks, it's probably because I have moved the copy-paste from INTRO!F12, so you might need to go to the original sheet and see where I've moved it to and then update your formula's INTRO!F12 part accordingly. Ping me here if you need help troubleshooting!
3. THE DRAGONOMICS TIME-SENSITIVE REMINDER PINGLISTS




PING VOLUNTEERS

Just head to the sheet and copy the contents of the green cell, and then paste it as a reply to this forum topic. It will only ping people who have volunteered for the next three hours (not the current hour), and only when the sheets are short of data.

This is good if you want to help out and you notice the graphs are looking threadbare, but you are about to leave the house or go to sleep or something.

rYFhlT5.png
~*~

BE A VOLUNTEER, GET PINGED

There are three tabs you can add yourself to: treasure fodder, gem fodder, and exchange rate.

If you're up for filling in the form for any of those, click to the appropriate tab along the bottom, and then add your username to the hours of the day (Flight Rising server time!) that you are usually online.

Now people can copy and paste the contents of the green cell into this forum thread, and you'll be pinged and directed to the sheets.

You will only be pinged if you're likely to be online and if the spreadsheets are short of data - but of course, filling in the form is always helpful whether you've been pinged or not!
~*~

STOP PINGING ME DAMNIT

Just go back to the tabs and remove your username! Ctrl+F can help you to find yourself.
~*~

EMBED COPY-PASTE CODE INTO ANOTHER SPREADSHEET

If, like me, you have a spreadsheet to keep track of all your FR junk, you can paste the following into a Google Sheet cell and it will gather the code from the Reminder Pinglist sheet.
Code:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1k7B3BGvG5hX-y2NDUYLdLdzgmL1hk2VwcwTSedbaGxE","INTRO!F12")

It might take a few moments!

Important: If your Google Sheet has default settings, it will only update that cell automatically when you edit something elsewhere on the sheet ("on change"). So go to File > Spreadsheet settings... > Calculation > Recalculation and choose "On change and every minute". That'll ensure that the contents of your IMPORTRANGE are always up-to-date.

If it ever breaks, it's probably because I have moved the copy-paste from INTRO!F12, so you might need to go to the original sheet and see where I've moved it to and then update your formula's INTRO!F12 part accordingly. Ping me here if you need help troubleshooting!
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
[right][url=http://www1.flightrising.com/forums/gde/2237277#post_2237277]Back to top[/url][/right] [center][b]4. FOOD PRICES[/b][/center] [br] This is a very similar set-up to the dragon prices spreadsheet, but it's smaller and simpler. It's just designed to work out what the cheapest food to buy is, taking into account [b]food points[/b] - the Auction House currently only takes into account unit price. The form is a little more long-winded, but still fairly easy to fill in, I think! [br] [center]~*~[/center] [br] [center][url=https://docs.google.com/spreadsheets/d/1r10QUofY0Q2AyOkBjtJKx05OZ5-pk4TvO4sNW7XNa0Q/edit?usp=sharing]The spreadsheet[/url] ~*~ [url=https://goo.gl/forms/8Dw3zsRXWVoXlOO52]The form[/url] [img]https://i.imgur.com/FxSCnmT.png[/img][/center] [br] [center]~*~[/center] [br] [b]What it can tell you:[/b] [LIST] [*]Treasure per food point for all food and per food type [*]How much it costs to feed one dragon for a day and for a week [/LIST] It also gives you a link to the Auction House to buy the most cost-effective food [b]per food point[/b]. [img]https://i.imgur.com/HyvATWw.png[/img] [br] [center]~*~[/center] [br]
4. FOOD PRICES




This is a very similar set-up to the dragon prices spreadsheet, but it's smaller and simpler. It's just designed to work out what the cheapest food to buy is, taking into account food points - the Auction House currently only takes into account unit price.

The form is a little more long-winded, but still fairly easy to fill in, I think!


~*~




~*~



What it can tell you:
  • Treasure per food point for all food and per food type
  • How much it costs to feed one dragon for a day and for a week

It also gives you a link to the Auction House to buy the most cost-effective food per food point.

HyvATWw.png


~*~

dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
5. SUMMARY OF LINKS




Treasure fodder prices - spreadsheet / form
Three questions. For tracking the prices of adult and hatchling fodder.

Gem fodder prices - spreadsheet / form
Three questions. For tracking the prices of adult and hatchling fodder.

Exchange rate - spreadsheet / form
One question, but you might have to fill in the treasure and gem fodder forms first. For tracking the exchange rate between treasure and gems, calculated from fodder prices.

Food point prices - spreadsheet / form
4 x 4 questions. Crowdsources average food point prices for each type and generates links for easy purchasing of the cheapest food in the auction house.

General pinglist
For those who want to be pinged about new features or gossip relating to this project.

Time-specific reminder pinglist
Pinglists that can remind people to fill in the forms, only during times that they're usually online and only if the spreadsheets don't have up-to-date info. Here's where you add or remove yourself. You can also go here to get the code to copy and paste into this forum thread to ping reminders out to volunteers for the next few hours.

Report a problem
If there is a bug or some kind of problem with any of the spreadsheets, you can tell me using this form and I'll be notified by email even if I haven't logged into FR for a while. Nine times out of ten it's just "someone entered a really high number into a price box and it's throwing everything off", but sometimes it's more complicated. Please do use this as the first resort, because I check my email more often than I check FR sometimes!
5. SUMMARY OF LINKS




Treasure fodder prices - spreadsheet / form
Three questions. For tracking the prices of adult and hatchling fodder.

Gem fodder prices - spreadsheet / form
Three questions. For tracking the prices of adult and hatchling fodder.

Exchange rate - spreadsheet / form
One question, but you might have to fill in the treasure and gem fodder forms first. For tracking the exchange rate between treasure and gems, calculated from fodder prices.

Food point prices - spreadsheet / form
4 x 4 questions. Crowdsources average food point prices for each type and generates links for easy purchasing of the cheapest food in the auction house.

General pinglist
For those who want to be pinged about new features or gossip relating to this project.

Time-specific reminder pinglist
Pinglists that can remind people to fill in the forms, only during times that they're usually online and only if the spreadsheets don't have up-to-date info. Here's where you add or remove yourself. You can also go here to get the code to copy and paste into this forum thread to ping reminders out to volunteers for the next few hours.

Report a problem
If there is a bug or some kind of problem with any of the spreadsheets, you can tell me using this form and I'll be notified by email even if I haven't logged into FR for a while. Nine times out of ten it's just "someone entered a really high number into a price box and it's throwing everything off", but sometimes it's more complicated. Please do use this as the first resort, because I check my email more often than I check FR sometimes!
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
Post 6
Post 6
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
Post 7
Post 7
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
[right][url=http://www1.flightrising.com/forums/gde/2237277#post_2237277]Back to top[/url][/right] [center][b]8. BUTTONS[/b][/center] [br] [b]How to add something to your forum signature[/b] [LIST=1] [*]Click the tiny arrow next to your username in the top right corner of the site. [*]Click "[url=http://flightrising.com/main.php?p=settings]Account Settings[/url]". [*]Next to "Forum Signature", click the "Edit" button. [*]Enter the code into the box that appears, and click "Save". [/LIST] [br] [center]~*~[/center] [br] [b]100x97[/b] [url=http://www1.flightrising.com/forums/gde/2237277] [img]http://i.imgur.com/dNCLmdm.png[/img][/url] [code][url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/dNCLmdm.png[/img][/url][/code] [br] [center]~*~[/center] [br] [b]85x85[/b] [url=http://www1.flightrising.com/forums/gde/2237277] [img]http://i.imgur.com/PaI4dmB.png[/img][/url] [code][url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/PaI4dmB.png[/img][/url][/code] [br] [center]~*~[/center] [br] [b]100x47[/b] [url=http://www1.flightrising.com/forums/gde/2237277] [img]http://i.imgur.com/HW4lpxl.png[/img][/url] [code][url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/HW4lpxl.png[/img][/url][/code] [br] [center]~*~[/center] [br] [b]200x100[/b] [url=http://www1.flightrising.com/forums/gde/2237277] [img]http://i.imgur.com/Gc8XK3m.png[/img][/url] [code][url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/Gc8XK3m.png[/img][/url][/code] [br] [center]~*~[/center] [br] [b]200x80[/b] [url=http://www1.flightrising.com/forums/gde/2237277] [img]http://i.imgur.com/cSckuMi.png[/img][/url] [code][url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/cSckuMi.png[/img][/url][/code] [br] [center]~*~[/center] [br] [b]Credits:[/b] Big thank you to @afire and @glarthir for making these fabulous buttons for me! If you have a button you'd like to add to this list, reply to this thread and I'll add it and credit you. :)
8. BUTTONS




How to add something to your forum signature
  1. Click the tiny arrow next to your username in the top right corner of the site.
  2. Click "Account Settings".
  3. Next to "Forum Signature", click the "Edit" button.
  4. Enter the code into the box that appears, and click "Save".


~*~



100x97

dNCLmdm.png
Code:
[url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/dNCLmdm.png[/img][/url]


~*~



85x85

PaI4dmB.png
Code:
[url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/PaI4dmB.png[/img][/url]


~*~



100x47

HW4lpxl.png
Code:
[url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/HW4lpxl.png[/img][/url]


~*~



200x100

Gc8XK3m.png
Code:
[url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/Gc8XK3m.png[/img][/url]


~*~



200x80

cSckuMi.png
Code:
[url=http://www1.flightrising.com/forums/gde/2237277][img]http://i.imgur.com/cSckuMi.png[/img][/url]


~*~



Credits: Big thank you to @afire and @glarthir for making these fabulous buttons for me! If you have a button you'd like to add to this list, reply to this thread and I'll add it and credit you. :)
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
9. CREDITS



@afire and @glarthir, for making the buttons.



The previous forum post, for posterity.
9. CREDITS



@afire and @glarthir, for making the buttons.



The previous forum post, for posterity.
dNCLmdm.png
UK; sleeping 4pm-2am FRT // Pronouns: they/them // Feedback
~
Signature generator // Calendar of flight festivals until Sept 2019
1 2 3 4 5 6 7 ... 41 42