Guides

[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] // [url=https://docs.google.com/forms/d/e/1FAIpQLSd_vURYXzJ0qG4WwvChE-iIJBtr-J5LQK2_Dp0Ie8xUH_wSfA/viewform]REPORT PROBLEM[/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]

[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]https://i.imgur.com/3b1ceLh.png[/img] The wide cell in the middle will tell you whether help is urgently needed, welcome, or not needed, and if help is wanted/needed it'll become a link to the form. [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 green - 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!

Date: Saturday 15th December 2018

UPDATE

I just added the Time-Sensitive Reminder Pinglists!

[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!

[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://docs.google.com/forms/d/e/1FAIpQLScX2Cha35hRLreNAZR9IPqGoelQjkLTnI-_A78sigYnklBZgQ/viewform]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]

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!

Post 6

Post 7

[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. :)