Guides

[center][size=4][font=cambria][color=#052a4d]Hi folks! Here's my contribution to the Hibernal Den Item Turn-In Task tracking extravaganza:[/size] [emoji=lightning rune] [emoji=old parchment] [size=6][b][font=cambria][color=#052a4d][url=https://docs.google.com/spreadsheets/d/1tOvN6O144779KhHgtN4_Tqbu-LjPFr3fyR48AWJ8E68/edit?usp=sharing]Original Spreadsheet Link[/url][/b][/size] [emoji=lightning rune] [emoji=old parchment] [emoji=shockswitch blue size=1] [url=https://www1.flightrising.com/forums/gde/2635549/6#post_47513349]updated spreadsheet from midnightmage[/url] [emoji=shockswitch blue size=1] [emoji=shockswitch yellow size=1] [url=https://www1.flightrising.com/forums/gde/2635549/7#post_48296198]sheet with hoard search links from VolatileMatter[/url] [emoji=shockswitch yellow size=1] [emoji=shockswitch green size=1] [url=https://www1.flightrising.com/forums/gde/2635549/7#post_48602887]update from lizwyrm[/url] // [url=https://www1.flightrising.com/forums/link?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1NtJpZjDaRdhqBlO1jUVkYh1HQisyPy8sYBbxQSGtGsA%2F]update from Gryphonlady[/url] // [url=https://www1.flightrising.com/forums/gde/2635549/8#post_54839721]update from NightFlame22[/url] [emoji=shockswitch green size=1] [size=4][font=cambria][color=#052a4d]This sheet will [b]track your remaining number of trades[/b], show the [b]items (and their icons)[/b] that you need for each trade and how many, and automatically update [b]how many of each item you still need for future trades[/b] or if you won't need any more of that item. You can also enter in [b]how many of an item you have in your horde[/b] and it will change color when you have enough for the trade! It also includes a little snippet about [b]where the item is found[/b] (ex. Coliseum: Harpy's Roost, Gathering 14+ (Fire)). You can filter this list to [b]find all the items you still need from a certain venue[/b]! I tried to keep it pretty streamlined and just show the information you'd need to keep track of your completed and upcoming trades and prepare accordingly to buy/grind for items. Big thanks to wildewinged and CorpseCopse for helping me find all the item locations! [emoji=left wing] Please [b][u]do not ping[/b][/u], I am subscribed! [emoji=right wing] [size=4][font=cambria][color=#052a4d][b]Update Pinglist:[/b][/size] @/aiwowie @/Juxta13 @/bakurabox @/pondweed @/wildewinged @/BottledLightning @/Rebekah @/dancingcrane @/Sarluna @/Marmotin @/Dathomir @/StarN1ght

[center][font=cambria][color=#052a4d][b][size=5][emoji=ping] Tips and Tricks! [emoji=ping][/b][/size] [emoji=blue star] Please let me know if you would like more guides/explanations and I will do what I can to add them! [emoji=blue star] [size=4][u]Items in Hoard:[/u] You can keep track of the number of items you have in the Items Needed tab, and when you have enough the "Still Needed" cell will turn blue! [img]https://i.imgur.com/gjVavnC.png[/img] [u]Trade Counter:[/u] Gives a count of the trades that are still remaining, and automatically updates how many of the item in the trade are still needed. If no more are needed, the line for that item turns black. [img]https://i.imgur.com/hdjurMj.png[/img] [img]https://i.imgur.com/fKoIn9Y.png[/img] [img]https://i.imgur.com/bB5gqYG.png[/img] [img]https://i.imgur.com/YtXdlUn.png[/img] [u]AH Links:[/u] Hover over the "X" to have a hyperlink appear. This will take you directly to the Auction House for that item and the specified currency! Please note that for items like "Clay", the proper item [i]may not be the first result[/i] because there are other items with "clay" in the name. [img]https://i.imgur.com/PlSsU6l.png[/img] [u]Item Location Filtering:[/u] To find out what items are in each location, you can create a filter by clicking the "create a filter" button. You will get a warning about making edits, but you want to make the edit of a filter so it's okay! [img]https://i.imgur.com/4d7GcHO.png[/img] Click the little triangle up at the edge of the "Location" column to get your filtering options. You can then hit "clear" to unselect all the options, and then click the location you want to see (ex. Baldwin). [img]https://i.imgur.com/H7EVdo7.png[/img] [img]https://i.imgur.com/cfFbgHy.png[/img] For a Coliseum venue, hit "clear" to unselect all options, then type in the venue name. Then, hit "Select all" to select all the items with that venue in their location list. This will ensure that all items that appear in that venue are selected, not just ones that drop [i]only[/i] in that venue. [img]https://i.imgur.com/MvcDtrM.png[/img] You can filter any of the other columns, too! You could filter by item type, only ones with more than zero in their "Still Needed" cell, and even filter out the trades you have completed in the Trade tab! When you are done filtering, you can either select the "create a filter" button again, or hit "select all" within the filter to bring all the items back.

[center][font=cambria][color=#052a4d][b][size=5]Planned Future Updates:[/size][/b][size=4] [emoji=blue star] Put items in order of first trade they appear in [/size] [b][size=5]Update Log:[/size][/b][size=4] [emoji=gold star] AH link to item (3/2/19) [emoji=gold star] Corrected minor trade name errors (3/8/19) [emoji=gold star] Trades in the spreadsheet are now in the order listed on the FR Den Slot Tasks (All) page (3/11/19) [emoji=gold star] Tools of the Trade added (there was a duplicate Chimera trade instead of this one!) (3/11/19) [emoji=gold star] Fixed two images and changed "Material" labels to "Materials" (3/19/19) [emoji=gold star] Corrected some locations (4/24/19) [/size] [b][size=5]Errors/Suggestions:[/size][/b] Feel free to let me know about any errors in text (locations, trade names, etc) and I'll make those corrections! Please [b][u]do not ping[/b][/u], I am subscribed![size=4] [emoji=red star] None yet!

@nirnrootnoises BLESS, thank you! Please add me to the pinglist~!

@aiwowie you are very welcome, i hope the sheet works well for you!! also added you to the update pinglist [emoji=coatl laughing]

@nirnrootnoises
Pinglist please. Thank you so much for putting this together!!

@Juxta13 it's my pleasure, making spreadsheets is so fun! [emoji=guardian star] i hope it helps you!

@NirnrootNoises
Just knowing where to find everything is a HUGE help. I never figured I would find something this helpful!

Could I be added to the pinglist? Thanks.

got you added @bakurabox! i hope the sheet is helpful to you [emoji=ridgeback laughing]