Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | [FEST] Glowing Ember Tracker Spreadsheet
1 2 3
[center][img]http://i.imgur.com/jvVsv9z.png[/img] [item=Glowing Ember][img]http://i.imgur.com/Tf46jnF.png[/img][item=Glowing Ember] [item=Furnace Queen Chest][item=Ignis Chest][item=Infernal Fur Chest] [item=Lava Eater Chest][item=Skogsbrand Chest][item=Spirit Ablaze Chest][/center] [rule] [center][size=5][url=http://www1.flightrising.com/forums/frd/1545886#13267199]Rules[/url] [url=http://www1.flightrising.com/forums/frd/1545886#13267208]Data Protection[/url] [url=http://www1.flightrising.com/forums/frd/1545886#13267211]FAQ[/url] [url=http://www1.flightrising.com/forums/frd/1545886#13267218]Links[/url] [url=http://www1.flightrising.com/forums/frd/1545886#13267223]Pinglist[/url] [url=http://www1.flightrising.com/forums/frd/1545886#13267225]Forum Signatures[/url][/size][/center] [rule] [center] [size=5]Click here to go to the Spreadsheet:[/size] [url=https://docs.google.com/spreadsheets/d/1P4597cSYGxYHrrVnyKGeVl1Sl_MYCBL_nl8VFEB4OoQ/edit#gid=0][img]http://i.imgur.com/8D4FeVI.png[/img][/url] [/center] [rule] Shareable spreadsheet link: [code] https://goo.gl/kv0tDb [/code] [rule] [center][size=6]Festival Status: [color=#FFCF21][b]Finished![/b][/color][/size] [size=5]Spreadsheet Status: [color=#FFCF21][s]Closed for the fest![/s] [b][u]REMAINING OPEN UNTIL 1-2AM FR TIME FOR DATA DUMPS[/u][/b][/color][/size] [size=4]Forum Thread Status: [color=#FFCF21][b]Taking Pinglist adds and post-Festival feedback[/b][/color][/size]
jvVsv9z.png

Glowing Ember Tf46jnF.png Glowing Ember
Furnace Queen Chest Ignis Chest Infernal Fur Chest
Lava Eater Chest Skogsbrand Chest Spirit Ablaze Chest



Click here to go to the Spreadsheet:

8D4FeVI.png



Shareable spreadsheet link:
Code:
https://******/kv0tDb



Festival Status: Finished!
Spreadsheet Status: Closed for the fest! REMAINING OPEN UNTIL 1-2AM FR TIME FOR DATA DUMPS
Forum Thread Status: Taking Pinglist adds and post-Festival feedback
rxT5Faj.png 41MZFGL.png rxT5Faj.png
[size=7][b]Rules of Recording[/b][/size] [rule] [list=1][*]Before adding data, please add your username to the "User Battle Stats" page in any free space. [*]To add data in a venue tab, please put your Username and Flight at the top of any free column [list][*]Please only take one set of columns per venue tab[/list] [*]Fill the number of Glowing Embers you receive after [b][u]every[/u][/b] battle, one battle per row. [list][*]If you receive 0 Embers for a battle, put a 0 [*]This includes battles where no Fire or Neutral creatures appear[/list] [*]Only fill in the chests column when a chest drops. Putting a 0 for no chests is unnecessary. [*]Rather than a number, please put in the appropriate abbreviation for the specific chest that dropped, as listed below. [list][*]On the incredibly rare chance that two chests drop in a single battle, fill the second chest in the following row in the chests column[/list][/list] These shouldn't really need to be said, but I will anyway. [list][*][b]Please record only accurate data. [*][b]Please do not vandalize or tamper with other users' data.[/list]
Rules of Recording

  1. Before adding data, please add your username to the "User Battle Stats" page in any free space.
  2. To add data in a venue tab, please put your Username and Flight at the top of any free column
    • Please only take one set of columns per venue tab
  3. Fill the number of Glowing Embers you receive after every battle, one battle per row.
    • If you receive 0 Embers for a battle, put a 0
    • This includes battles where no Fire or Neutral creatures appear
  4. Only fill in the chests column when a chest drops. Putting a 0 for no chests is unnecessary.
  5. Rather than a number, please put in the appropriate abbreviation for the specific chest that dropped, as listed below.
    • On the incredibly rare chance that two chests drop in a single battle, fill the second chest in the following row in the chests column

These shouldn't really need to be said, but I will anyway.

  • Please record only accurate data.
  • Please do not vandalize or tamper with other users' data.
rxT5Faj.png 41MZFGL.png rxT5Faj.png
Chest Abbreviations

The proper chest abbreviations to use in the "Chests" columns of the Spreadsheet.

Furnace Queen Chest:
Ignis Chest:
Infernal Fur Chest:
Lava Eater Chest:
Skogsbrand Chest:
Spirit Ablaze Chest:
Queen
Ignis
Fur
Lava
Skogs
Spirit
Chest Abbreviations

The proper chest abbreviations to use in the "Chests" columns of the Spreadsheet.

Furnace Queen Chest:
Ignis Chest:
Infernal Fur Chest:
Lava Eater Chest:
Skogsbrand Chest:
Spirit Ablaze Chest:
Queen
Ignis
Fur
Lava
Skogs
Spirit
rxT5Faj.png 41MZFGL.png rxT5Faj.png
Data Protection

Since the sheet is mostly open to the public for editing, and data vandalism is a thing, users with a sufficiently high amount of battles recorded may request that their data columns be protected, if they so choose.

Requirements

  1. Users requesting data protection must have at least 50 battles recorded in a single venue
  2. Users may also request data protection if they have at least 100 battles recorded across all venues, even if they do not have more than 50 in a single venue
  3. Users must feel comfortable sending their email address in a PM. This is optional, after all.



If you want your data to be Protected, and meet the above requirements, send a In-Game private message to @Compcalc with your email address, and include "Data Protection" in the title.
Data Protection

Since the sheet is mostly open to the public for editing, and data vandalism is a thing, users with a sufficiently high amount of battles recorded may request that their data columns be protected, if they so choose.

Requirements

  1. Users requesting data protection must have at least 50 battles recorded in a single venue
  2. Users may also request data protection if they have at least 100 battles recorded across all venues, even if they do not have more than 50 in a single venue
  3. Users must feel comfortable sending their email address in a PM. This is optional, after all.



If you want your data to be Protected, and meet the above requirements, send a In-Game private message to @Compcalc with your email address, and include "Data Protection" in the title.
rxT5Faj.png 41MZFGL.png rxT5Faj.png
[size=6][b]FAQ[/b][/size] [rule] [quote = Question]Will you include currency per time, in addition to/instead of per battle?[/quote] Short answer: No. [list][*]Different people have different times per battle in each venue, depending on team [s]among other factors[/s] [*]Recording time after each battle adds time overall [*]Since battles are often very short, it's difficult to keep sufficiently accurate time[/list] [quote = Question]Why doesn't Harpy's Roost have an apostrophe in multiple places?[/quote] Much like in Flight Rising and Forum code, apostrophes don't play nice with the spreadsheet code. [quote = Question]Do you need data in X venue/Where should I collect data?[/quote] Whichever venue has the lowest amount of data, as seen in the Venue Overview tab. [quote = Question]I lost a battle/fled a battle/my browser crashed/the Four Horsemen of the Apocalypse borrowed my router to watch online soap operas, and I needed to restart in a venue! Should I start a new column in the same venue tab?[/quote] No. [quote = Question]You said to add my name to the User Battle Stats tab, but the tab is protected! What gives?[/quote] Column A in the tab was left as an exception, and should be publicly editable, even though the sheet has the padlock icon. [quote = Question]What's the point of the Flight Overview tab?[/quote] Testing a theory. [quote = Question]There aren't enough rows/columns in a tab![/quote] Ping me and I'll add more as soon as I can. [quote = Question]How does Data Protection work/Why do we need to send you our email addresses?[/quote] Short version: I'll be making a portion of the sheet (your columns, basically) frozen and uneditable. If you still want to be able to edit your data column, I need your email address to add you to the permissions for that region. Side note: If your data is protected, you must be logged into that email address to edit or add to it. [quote = Question]I asked that my data be Protected. Which venues does that apply to?[/quote] All venues you have provided at least 1 battle of data for will be protected, as long as you fulfill the stated requirements. If you start recording data in a new venue, and want it protected as well, just ping me in the forum. [quote = Question]Wait, does that mean you'll be keeping our email addresses?[/quote] Yes, but only until the end of the Festival, for the sake of convenience. When the current holiday season is over, I delete all Data Protection messages and Email Addresses at the same time as I make the spreadsheet view only. If you are uncomfortable with that and would rather I delete your PM immediately after protecting your data, please specify that in the PM. You'll need to PM me again if you want more venues protected, instead of just pinging me. [quote = Question]How will I know if my data is Protected/where my data is Protected?[/quote] That box in the "User Battle Stats" tab will be a different color. [quote = Question]Is all of this a one time thing?[/quote] Nope! I'll be copying out a new spreadsheet every festival, and archiving the old ones.
FAQ

Question wrote:
Will you include currency per time, in addition to/instead of per battle?

Short answer: No.
  • Different people have different times per battle in each venue, depending on team among other factors
  • Recording time after each battle adds time overall
  • Since battles are often very short, it's difficult to keep sufficiently accurate time

Question wrote:
Why doesn't Harpy's Roost have an apostrophe in multiple places?

Much like in Flight Rising and Forum code, apostrophes don't play nice with the spreadsheet code.

Question wrote:
Do you need data in X venue/Where should I collect data?

Whichever venue has the lowest amount of data, as seen in the Venue Overview tab.

Question wrote:
I lost a battle/fled a battle/my browser crashed/the Four Horsemen of the Apocalypse borrowed my router to watch online soap operas, and I needed to restart in a venue! Should I start a new column in the same venue tab?

No.

Question wrote:
You said to add my name to the User Battle Stats tab, but the tab is protected! What gives?

Column A in the tab was left as an exception, and should be publicly editable, even though the sheet has the padlock icon.

Question wrote:
What's the point of the Flight Overview tab?

Testing a theory.

Question wrote:
There aren't enough rows/columns in a tab!

Ping me and I'll add more as soon as I can.

Question wrote:
How does Data Protection work/Why do we need to send you our email addresses?

Short version: I'll be making a portion of the sheet (your columns, basically) frozen and uneditable. If you still want to be able to edit your data column, I need your email address to add you to the permissions for that region. Side note: If your data is protected, you must be logged into that email address to edit or add to it.

Question wrote:
I asked that my data be Protected. Which venues does that apply to?

All venues you have provided at least 1 battle of data for will be protected, as long as you fulfill the stated requirements. If you start recording data in a new venue, and want it protected as well, just ping me in the forum.

Question wrote:
Wait, does that mean you'll be keeping our email addresses?

Yes, but only until the end of the Festival, for the sake of convenience. When the current holiday season is over, I delete all Data Protection messages and Email Addresses at the same time as I make the spreadsheet view only.

If you are uncomfortable with that and would rather I delete your PM immediately after protecting your data, please specify that in the PM. You'll need to PM me again if you want more venues protected, instead of just pinging me.

Question wrote:
How will I know if my data is Protected/where my data is Protected?

That box in the "User Battle Stats" tab will be a different color.

Question wrote:
Is all of this a one time thing?

Nope! I'll be copying out a new spreadsheet every festival, and archiving the old ones.
rxT5Faj.png 41MZFGL.png rxT5Faj.png
Important Links

General/Related Links

Average currency drop rates by enemy type
Enemy encounter rates
Festival Guide

Tracker History

Charged Sprocket Tracker / Currency Tracker Prototype
Forum thread for the above
Important Links

General/Related Links

Average currency drop rates by enemy type
Enemy encounter rates
Festival Guide

Tracker History

Charged Sprocket Tracker / Currency Tracker Prototype
Forum thread for the above
rxT5Faj.png 41MZFGL.png rxT5Faj.png
[size=6][b]Pinglist[/b][/size] [rule] Pretty self-explanatory. Ping or PM me to get added and specify which one you'd like to be on, you'll get pinged a few days before each festival, and the first day of the festival. [rule] [quote = Starfall Pinglist]no one yet[/quote] [quote = Monthly Pinglist]@actuallybarnes @iamtheeyesinside @ophia @DragonSanctuary @bmeduho[/quote]
Pinglist

Pretty self-explanatory. Ping or PM me to get added and specify which one you'd like to be on, you'll get pinged a few days before each festival, and the first day of the festival.



Starfall Pinglist wrote:
no one yet

rxT5Faj.png 41MZFGL.png rxT5Faj.png
[size=6][b]Forum Signatures[/b][/size] [rule] [url=http://www1.flightrising.com/forums/gde/1549408][img]http://i.imgur.com/Tf46jnF.png[/img][/url] [code] [url=http://www1.flightrising.com/forums/gde/1549408][img]http://i.imgur.com/Tf46jnF.png[/img][/url] [/code] [url=http://www1.flightrising.com/forums/gde/1549408][img]http://i.imgur.com/8D4FeVI.png[/img][/url] [code] [url=http://www1.flightrising.com/forums/gde/1549408][img]http://i.imgur.com/8D4FeVI.png[/img][/url] [/code]
Forum Signatures

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


8D4FeVI.png
Code:
[url=http://www1.flightrising.com/forums/gde/1549408][img]http://i.imgur.com/8D4FeVI.png[/img][/url]
rxT5Faj.png 41MZFGL.png rxT5Faj.png
*Reserved*
*Reserved*
rxT5Faj.png 41MZFGL.png rxT5Faj.png
Open for posting
Open for posting
rxT5Faj.png 41MZFGL.png rxT5Faj.png
1 2 3