Guides

[center][b]Updated April 21, 2024 [emoji=water rune size=1]Wavecrest Saturnalia April 21-28 ----- [b] I'd like some feedback on the Swipp/Baldwin tracker, specifically. Are there any changes y'all would like? Is there some other way it could be helpful? LMK All new updates are sorted to the top of the spreadsheet and the cells are [color=cyan]BLUE[/color].[/b][/center] [b][SIZE=4]Welcome![/SIZE][/b] Skrymer, the FR Player formerly known as Phasma, developed these sheets (The Bestiary, HibDen, & Swipp/Baldwin trackers) and gave Reddhed permission to update them. Reddhed stopped making any updates as of Rockbreaker’s Ceremony 2020. I came across these sheets in late 2021 and started cleaning them up and updating them for my own personal use, but kept posting updated links in Redd’s original post. After a year of no contact, and now that the links for those sheets are defunct, I’ve started this thread to kind of start over. **I am still subscribed to the old thread, so if you find yourself there, I’ll still get the notification. *Reddhed’s opinion on Skrymer/Phasma’s set-up, which I also share* [center]I think these are the best database sheet sets I have found. For example, the Familiar sheet has a main tab with all the familiars listed, which you can sort and filter. It also has the general locations of where to obtain the familiars, marketplace prices, rarity, etc. There are also Coli and Gathering tabs, which help you select where you will gather or battle to obtain your familiars. The other sheets are set up with similar features that are incredibly helpful.[/center] * [s]A note on the marketplace columns on the main tab of the Bestiary tracker, I have not gone back and verified older prices or checked for any price changes. [/s] These prices have been corrected/updated. [s]I have also noticed some of the formulae used don't quite function as expected, but I don't use all of the functions in all of the sheets, so I may not have caught the errors yet.[/s] I think we've caught all the formula bugs. If you find something that is out-of-date, incorrect, or broken, please ping me and I’ll get it fixed. [center][url=https://docs.google.com/spreadsheets/d/1jZCqCE4XaddcGUIX53dF5TdEHCdLT3_I2LAJDqImcGg/edit?usp=sharing][img]https://i.imgur.com/rsLEfve.png[/img][/url] [url=https://docs.google.com/spreadsheets/d/1pmck4j7Cn4jHZ-ypi9FmJqn-mU0kvR6wjnuTlI9R1Ik/edit?usp=sharing][img]https://i.imgur.com/TWg6kQt.png[/img][/url] [url=https://docs.google.com/spreadsheets/d/1OP4pTNwP6c0OcEtnywzWJ6mhNNQ_BJqV577R6U1qhNY/edit?usp=sharing][img]https://i.imgur.com/8r9hZVR.png[/img][/url] [url=https://docs.google.com/spreadsheets/d/1jeu8xNC_PDH1RifOiDodJwvxOusHsHki9DrM5_RzTCg/edit?usp=sharing][img]https://i.imgur.com/kKxozf7.png[/img][/url][/center] [center][b]How to use the spreadsheets:[/b] [url=https://www1.flightrising.com/forums/gde/3195988/1#post_53011826]Bestiary[/url] | [url=https://www1.flightrising.com/forums/gde/3195988/1#post_53011828]Swipp & Baldwin[/url] | [url=https://www1.flightrising.com/forums/gde/3195988/1#post_53011830]Hibernal Den[/url] | [url=https://www1.flightrising.com/forums/gde/3195988#post_53011833][s]Holidays Guide[/s][/url] | [url=https://www1.flightrising.com/forums/gde/3195988/5#post_53631130]Elim + Rally Guide[/url][/center] [center][url=https://www1.flightrising.com/forums/gde/2864012#post_2864012]Original Thread by Reddhed[/url] (note that the spreadsheet links in this thread no longer work) Credit to Reddhed for the How-To instructions below for the three original trackers. [url=https://www1.flightrising.com/forums/gde/3082341/1#post_3082341]Swipp Swap Pinglist[/url] [url=https://www1.flightrising.com/forums/gde/2988821/1#post_2988821]Marketplace Flash Sale Pinglist[/url][/center] *I am subscribed to this thread, but I don't mind pings either. Feel free to add yourself to the pinglists for any or all updates! [url=https://www1.flightrising.com/forums/gde/3195988/1#post_53011836]PINGLISTS[/url]

How to use the Bestiary spreadsheet:

Make a copy of the file, (File -> Make a copy) (or I can send you the original .xlsx, just ask!).
Write "Y" in the Owned/Awakened columns in Main if you have the familiar and if it is awakened.
Write "Y" in the Bonding column in Main if you have a familiar attached to a dragon.

How to use the Swipp & Baldwin spreadsheet:

First, you should make a copy of this file for yourself (File -> Make a copy). If you don't want (or can't) use Google Sheets, you can also download the file (or I can send you the original .xlsx, just ask!).
In the Main sheet, you should correct the Interest column according to your needs/tastes. Simply: if you want the item in Trade, let the cell value at '1'. If you don't want the item, write '0'. If you want this item more than the other items, write '2' (or more).
In the Main sheet, you can also write down how many items you have for the trade in the Owned column. This makes it easier to track your progress.
In Hunting, Fishing, Insect, Foraging, Digging, and Scavenging, write down your respective gathering level in the red cell (and keep it up to date). With this, you know if you can gather the needed items.
And that's it, you're set! Now each sheet will tell you which is the best zone/venue to farm for your items, based on your level and interests. Just gather/grind in the zone/venue with the highest/greenest number at the top of the table.



Additional information:

In every sheet, the ID column is used to sort items in the same order that they appear in your hoard. You can then choose to sort the tables by ID, or by name.
In every gathering sheet, the Level column shows the minimum level to get a given item.
In every gathering sheet, I have also added the Familiars you can only get from gathering (like the Beetles). If/once you already have them, you can manually change the value of Interest to '0'.
In Gathering and Coliseum, the name of the items you want (and can have) will be in bold (once you input your gathering levels). This makes it easier visually to check if you should keep or toss something.
In Main, once you have enough items to make a trade, the item name in Trade will be bolded. You should then write '0' in Interest, since you have enough.



Tip: if an item can be obtained from gathering and the Coliseum, you are more likely to get it by gathering. It's probably a rare drop in the Coliseum anyway.

How to use the Hibernal Den tasks spreadsheet:

First, you should make a copy of this file for yourself (File -> Make a copy).
In the Main sheet, you should correct the "Unlocked" column according to you have already completed.
In the Main sheet, you can also write down how many items you have for the trade in the "Owned" column. This makes it easier to track your progress.
In "Hunting", "Fishing", "Insect Catching", "Foraging", "Digging", and "Scavenging", write down your respective gathering level in the red cell (and keep it up to date). With this, you know if you can gather the needed items.
Also in "Trading Post" tab, be sure to keep your Baldwin and Arlo levels up to date in the same red cell.
And that's it, you're set! Now each sheet will tell you which is the best zone/venue to farm for your items, based on your level and progress. Just gather/grind in the zone/venue with the highest/greenest number at the top of the table.


Additional information:

In every sheet, the "ID" column is used to sort items in the same order that they appear in your hoard. You can then choose to sort the tables by ID, or by name.
In every gathering sheet, the "Level" column shows the minimum level to get a given item.
In the gathering and coliseum sheets, the name of the items you want will be bolded (once you input your gathering levels). This makes it easier visually to check if you should keep or toss something.
Please note that in the Marketplace ("Purchases") tab and the "Trading Post" tab, there are multiple tables side-by-side, so sorting the entire sheet could break the other tables.
In the Main sheet, once you have enough items to complete a quest, the quest name will be highlighted. If you can actually complete that quest (based on the four you have available), the quest name will be even more highlighted. Once you have finished that quest, click on "Unlocked" for each items, and the lines will be greyed-out.



Tip: if an item can be obtained from gathering AND the Coliseum, you are more likely to get it by gathering. It's probably a rare drop in the Coliseum anyway.

[b]How to update your trackers[/b] [list] [*]Manually add the same number of new, empty rows [*]Copy & paste the new information into your current spreadsheet. -I try to keep all the updated rows sorted to the top and highlighted in [color=cyan]BLUE[/color]. [/list] For the HibDen specifically, because the tasks are numbered, and new ones are added throughout instead of just tacked onto the end, you also have to add the new task & ID to the Task Order tab. [url=https://www1.flightrising.com/forums/gde/3195988/6#post_53924398]This post[/url] and the one right after it explain the details better. [list] [*] Go to the Task Order tab -These are not sorted with the new ones at the top. The [color=cyan]blue[/color] highlight is the empty cells to the left instead [*] Add new, empty rows for each new task ID [*] [u]Only type in the NAME of the new task [/u] [*] Highlight several cells (at least 3) above the new empty ID# cells, and drag the cell selection down through the last empty cell. The whole column should update accordingly. [img]https://i.imgur.com/vvlGQG6.png[/img] [*] [b]THEN[/b] go to the main tab and enter your new, blank rows. [*] Paste in the new information [*]If your text is coming in misaligned, just correct it from the tools at the top of the sheet: [img]https://i.imgur.com/CwQw3jJ.png[/img] -Sheets doesn't like to carry over formatting when you Copy & Paste. [*]When you go to add a new venue column and associated items to the Coliseum tab, add a blank column [b]FIRST[/b] [*]THEN add new blank ROWS and copy your new loot drop rows [*]THEN copy & paste the venue column [/list] Feel free to ping me or message me if you're having any issues with updating your sheets. Thanks to @Kianast for writing it out longhand to begin with, and @rockss for reminding me to put this somewhere folx can find it regularly.

**Shiny new pinglists have been added. Please add yourself!** I'll put out a general ping from the longform list for anyone who hasn't subbed to a pinglist once they announce when they're sunsetting the ping feature. [pinglist=3133] [pinglist=3135] [pinglist=3136] [quote name="Pinglists"] [emoji=subscription update size=1]All updates: @Rockss @Bantymom @Thechillymittens @TinyLizardsDen @ArcticTale @oncomingbeige @Toastedpencils @Princen @Feilimi @Agberts @sleepytiefling @gnderneutralnoun [emoji=bestiary size=1]Bestiary updates only: @AvianAnalyst @FloralFawn [emoji=crescent moon 2 size=1]HibDen updates only: @Firebee @Nightsmaiden @Livthraser @Theorys @MadameNova @SkyeWyven @Neutron @Finchsplash @LynxLPF @Kianast [emoji=cauldron size=1]Swipp/Baldwin updates only: @AvianAnalyst [emoji=nocturne confused size=1]Please confirm which pinglists you would like to be on: @Omosky [/quote]

[emoji=raven size=1]Familiars - Wary to Awakened Wary - 15t - 4 days Tolerant - 20t - 8 days - rusted Relaxed - 25t - 11 days - rusted Inquisitive - 30t - 18 days - rusted Companion - 35t - 22 days - iron Loyal - 45t - 25 days - iron Awakened - 50t - gilded Totals = 89 days - 2980t - 6 chests I found this thread by [url=https://www1.flightrising.com/forums/gde/987700#post_987700] Hydrargyrum80[/url] very helpful when I was new to FR and full of questions. Also, [url=https://www1.flightrising.com/forums/gde/1727925#post_1727925]Efficient Familiar Bonding[/url] by CrimsonCatalyst is great too!

@AvianAnalyst Absolutely!

All of the NotN and the new Harpy familiars are in green at the top of the list. If you don't see them, try sorting the Name column by cell color.