Guides

[center][img]https://i.imgur.com/4ABHC0C.png[/img] [img]https://i.imgur.com/3NiJzXO.png[/img][/center] [columns][img]https://i.imgur.com/k1zMuD3.png[/img][nextcol][indent][size=5][b]Hello and welcome to this familiar tracking guide![/size][/b] [size=4]Familiar tracking is a topic some of us enjoy. By using the provided flight-coordinated spreadsheets, easy access is yours when viewing specific missing familiars, their locations, and the grand total of familiars still slipping through your grasp.[/size][/indent][/columns] [img]https://i.imgur.com/3NiJzXO.png[/img] [columns][indent][img]https://i.imgur.com/BW6xQJM.png[/img] [img]https://i.imgur.com/BW6xQJM.png[/img] [img]https://i.imgur.com/BW6xQJM.png[/img][nextcol][indent][size=4]I maintain this thread whenever any new updates are rolled out, given my schedule at home provides time to do so. I may put it off for a little while if life is busy or if the updates with new familiars are small, but managing the spreadsheets on your own has mostly been streamlined at this point. When new familiars are released and added onsite, I will usually reply to this thread with an update including Familiar Names, Location (including new row number and location within Flight Rising, updated 6/16/2019), and leave the individual updating on personal sheets up to you. When new familiars are released, the sheets you make copies of will not update themselves. The last thing I'd want is to work on a testing copy and break someone else's spreadsheet.[/size][/indent][/columns] [img]https://i.imgur.com/3NiJzXO.png[/img] [img]https://i.imgur.com/sMCZHNy.gif[/img] [size=4][b][u][url=http://www1.flightrising.com/forums/gde/2440856#post_33257355]Table of Contents Quicklink[/url][/u][/b][/size]

[center][img]https://i.imgur.com/TyPIQ2Z.png[/img] [img]https://i.imgur.com/3NiJzXO.png[/img][/center] [columns][indent][indent][size=4][b] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_2440856][u]Introduction[/u][/url] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_33257355][u]Table of Contents[/u][/url] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_33258007][u]Spreadsheet Information[/u][/url] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_33258184][u]Frequently Asked Questions[/u][/url] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_33258245][u]Alternative Resources[/u][/url] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_33258652][u]Update Central[/u][/url] [img]https://i.imgur.com/sMCZHNy.gif[/img] [url=http://www1.flightrising.com/forums/gde/2440856#post_33382868][u]Acknowledgements[/u][/url] [/indent][/indent][nextcol][indent][img]https://i.imgur.com/9R1LrBP.png[/img][/indent][/columns]

[center][img]https://i.imgur.com/5vowlzi.png[/img] [img]https://i.imgur.com/3NiJzXO.png[/img][/center] [indent][indent][indent][img]https://i.imgur.com/BW6xQJM.png[/img][size=4] [url=https://docs.google.com/spreadsheets/d/1m2unb8mLRESRulfe80Gi1M2dl2w7r8-Lv1J1LgAx278/edit?usp=sharing][b][u]My Personal Copy[/url][/size] [img]https://i.imgur.com/BW6xQJM.png[/img][size=4] [url=https://docs.google.com/spreadsheets/d/1iI-pCzFgaU6usOq4-eHBRtUgscGAC8wvtN1xd5suc3E/edit?usp=sharing][b][u]Template Familiar Organizer[/url][/size][/indent][/indent][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [center][size=5][b]Obtaining Your Own Copy[/b][/size][/center] [indent][size=4][b]1)[/b] Open the [url=https://docs.google.com/spreadsheets/d/1iI-pCzFgaU6usOq4-eHBRtUgscGAC8wvtN1xd5suc3E/edit?usp=sharing][u][b]Template Spreadsheet Link[/b][/u][/url] on your device. [b]2)[/b] Go to File -> Make A Copy [img]https://i.imgur.com/vJTBxFo.png[/img] [b]3)[/b] Reference your bestiary; locate which familiars you have (based on what your bestiary displays) and fill in the corresponding cells. [/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [center][size=5][b]Column Meanings[/b][/size][/center] [indent][size=4]- [b]Familiar[/b]: Lists the name of each familiar in alphabetical order. - [b]Located[/b]: Displays where each familiar may be found. For micro holiday familiars, I list where they may be found as if the festival was already over. - [b]Obtained?[/b]: Enter "Yes" or "No". There's a formula that counts how many of each cells there are, and won't count correctly if something different is entered. - [b]Bonding Level[/b]: Features a dropdown list with a reliable way to pick the familiar's level! Includes every level from Wary to Awakened. - [b]Lv. #[/b]: Automatically updates to reflect which numeric level a particular familiar is bonded at. Wary is equivalent to Level One, and Awakened is Level Seven. - [b]Stored (H/D/V)[/b]: Hoard/Dragon/Vault; this keeps me centered on where the heck I put the familiar, but you're more than welcome to delete it on your version of the sheet if it's not needed. No formulas are tied to it, and they won't be in the future. - [b]Column I and Column J[/b]: Here's where the technical stuff is at, and I wouldn't recommend tampering with it. Column I sifts through the "Obtained?" column and looks for any cell filled with the word "No" (the color of the word doesn't matter). If the cell says no, then the formula will list the familiar name. Column H looks through the list Column I comes up with and filters out the text from blank spaces - shifting all needed familiars to the top of the spreadsheet, instead of just leaving them spaced around at random intervals.[/size][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [center][size=5][b]Some Notes;[/b][/size][/center] [indent][size=4]- The Acid-Tongue Serpenta is the only one that shows up in the "Missing" column in the blank sheet due to how it's marked, not because there's an error with the sheet. Until you put a "Yes" or "No" in the Obtained column, they won't show up on the list in column H. - Feel free to manipulate the sheet as you see fit. Add, remove, revise; if it's not helping you, this spreadsheet is yours to adapt and change up to best suit your needs. If you need assistance in such adaptations, send over a message and I may be able to help. - Additionally, if you yourself maintain a thread for familiar organizers and would like to have it linked here, I have a section dedicated to those who'd like the advertisement; just PM me.[/size][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [img]https://i.imgur.com/sMCZHNy.gif[/img] [size=4][b][u][url=http://www1.flightrising.com/forums/gde/2440856#post_33257355]Table of Contents Quicklink[/url][/u][/b][/size]

[center][img]https://i.imgur.com/qSynamD.png[/img][/center] [img]https://i.imgur.com/3NiJzXO.png[/img] [size=4][b]"New familiars came out; how can I update my sheet without filling out another blank one?"[/b][/size] [indent][size=4]When I post updates, I will include what the new row number should be per familiar. This solution will be based off of that information. [b]1)[/b] Locate a row right above or below where the new familiar should be. [b]2)[/b] Right click > Insert New Row [Above / Below] [b]3)[/b] In order for Excel to understand what pattern it needs to follow, highlight 3-5 cells from columns H to J above the new row, then click the small box on the right (seeing crosshairs) and drag over the newly added cell. [img]https://i.imgur.com/sSCUL9Y.png[/img] [center][size=2] { Click [url=https://imgur.com/a/kO5IgQ4][u]here[/u][/url] for high definition image. }[/size][/center] [/size][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [size=4][b]"I haven't updated my spreadsheet in a while. Is there a quicker way to update it?"[/b][/size] [indent][size=4]If you'd like to save as much time as possible after a fresh update is released for the Template, there is a simplistic method I use myself. Keep in mind, it only works if your spreadsheet is identical to the template or roughly about the same. [b]1)[/b] On your own spreadsheet, add a large number of new rows. While placement of the new cells doesn't particularly matter, you'll still mostly need to leave the top three familiar rows alone to prevent the code from breaking. [b]2)[/b] Open the [url=https://docs.google.com/spreadsheets/d/1iI-pCzFgaU6usOq4-eHBRtUgscGAC8wvtN1xd5suc3E/edit?usp=sharing][u][b]Template Spreadsheet Link[/b][/u][/url]. [b]3)[/b] Highlight columns B and C entirely, then copy. [i]3a)[/i] Alternatively, you can just highlight the sections containing the Familiar Name and their Location. [b]4)[/b] Navigate to your individual copy of the spreadsheet. Right click on the first cell you'd like affected by the changes, and use the key combination [u]Shift+Ctrl+v[/u] to paste text only without formatting. This does NOT carry over coding, only the raw text as seen. [b]5)[/b] Copy the code from cell F; and cells I, J, and K, then bring their original pieces of code from the top of the spreadsheet to the very bottom. Delete any repeating cells at the bottom of the spreadsheet, and you're done! [img]https://i.imgur.com/3NiJzXO.png[/img] [size=4][b]"When I update my spreadsheet, I see the same name listed twice under "Needed"[/b][/size] [indent][size=4]Highlight 2-3 cells from columns H to J above where you see that happen and drag the entire thing down to the bottom of the spreadsheet. This will resolve any inconsistencies and prevent anything further down the list from having the same thing happen.[/size][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [size=4][b]"I copied over from the Blank copy, but the 'Needed (Breakdown)' tab isn't working!"[/b][/size] [indent][i]This response has been edited in accordance to the 2018-12-16 update.[/i] [size=4]In order for the tab to display correctly, you'll need: - To know the name of your main tab (named as the corresponding Flights) - A mouse capable of right-clicking [b]1)[/b] Right click on any cell and find the "Define Named Range" option located close towards the bottom of the selection window. There should be only one named range available. [b]2)[/b] Edit "Query". Only change the code to reflect your current flight.[/size][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [size=4][b]"I thought I did it right, but I feel like I messed something up![/b][/size] [indent][size=4]No worries, just flag me down either through message or ping me here and I'll help as quick as I can.[/size][/indent] [img]https://i.imgur.com/3NiJzXO.png[/img] [img]https://i.imgur.com/sMCZHNy.gif[/img] [size=4][b][u][url=http://www1.flightrising.com/forums/gde/2440856#post_33257355]Table of Contents Quicklink[/url][/u][/b][/size]

[center][img]https://i.imgur.com/hXJsXWK.png[/img] [img]https://i.imgur.com/3NiJzXO.png[/img][/center] [size=4]Don't want to juggle all the extra things that come with complex familiar trackers? Well, good news! There's hope yet![/size] [center][size=6]- [b][u][url=http://www1.flightrising.com/forums/gde/2423295/1#post_2423295]Terpsi's Simple Familiar Tracker[/url][/u][/b]-[/size][/center] [size=4]Minimalistic and well-suited for the casual crowd; if Fate's Organizer is a touch too complex, try this variation out![/size] [img]https://i.imgur.com/3NiJzXO.png[/img] [img]https://i.imgur.com/sMCZHNy.gif[/img] [size=4][b][u][url=http://www1.flightrising.com/forums/gde/2440856#post_33257355]Table of Contents Quicklink[/url][/u][/b][/size]

[center][img]https://i.imgur.com/Xz0bpyi.png[/img] [img]https://i.imgur.com/3NiJzXO.png[/img][/center] [size=5][b]This section will reflect the latest three updates. Earlier additions to the spreadsheets may still be found through the posts in this forum.[/b][/size] [size=4][i][b]*2019-06-29:[/b][/i] The Sundial Gem Guardian has been added to the Template. [i][b]* 2019-06-16:[/b][/i] Several missing familiars have been added and updated with the finalization of the new thread format. + [i]View this update[/i] [url=http://www1.flightrising.com/forums/gde/2440856/5#post_39415983][i][b][u]here[/u][/b][/i][/url]. [i][b]* 2019-04-22:[/b][/i] The Fathomsearch Ambassador and Torrent Tricktail have been added to the Template. [i]A minor follow-up addition was added on 2018-12-24 thanks to SilMyst, who contributed a Coliseum Breakdown tab. Additional breakdowns may be viewed on her sheet [b][u][url=https://docs.google.com/spreadsheets/d/1zqdd9UK-ILxgGfRP8snPHdrJj3vJr6oiv_LNkAFjovQ/edit?usp=sharing/]here[/url][/u][/b]. [b]MAJOR EYESTRAIN TW FOR SHEET LINKED ABOVE.[/b][/i] [i]I've included a simplified breakdown of the Coliseum familiars in the Blank Template.[/i][/size] [img]https://i.imgur.com/3NiJzXO.png[/img] [img]https://i.imgur.com/sMCZHNy.gif[/img] [size=4][b][u][url=http://www1.flightrising.com/forums/gde/2440856#post_33257355]Table of Contents Quicklink[/url][/u][/b][/size]

[center][img]https://i.imgur.com/H2YfZGe.png[/img] [img]https://i.imgur.com/3NiJzXO.png[/img][/center] [size=4]@[url=http://flightrising.com/main.php?p=lair&tab=userpage&id=22448][u]SeaCrest[/u][/url], for creating and allowing public use of the original 'Needed - Breakdown' tab. @[url=http://flightrising.com/main.php?p=lair&tab=userpage&id=413570][u]SilMyst[/u][/url], for allowing public viewing and use of further breakdown tabs. @[url=https://perfect-pixels.tumblr.com/][u]perfect-pixels[/u][/url] on tumblr for the [url=https://perfect-pixels.tumblr.com/post/13217587888/pixel-dreams-pixel-land][u]red star gifs[/u][/url] used. @[url=http://flightrising.com/main.php?p=lair&tab=userpage&id=161169][u]002[/u][/url] for accepting a last-minute commission and diligently working on this threads' layout! @[url=http://flightrising.com/main.php?p=view&tab=userpage&id=89583]sky09[/url] for assistance in further revisions of this thread.[/size] [img]https://i.imgur.com/3NiJzXO.png[/img] [img]https://i.imgur.com/sMCZHNy.gif[/img] [size=4][b][u][url=http://www1.flightrising.com/forums/gde/2440856#post_33257355]Table of Contents Quicklink[/url][/u][/b][/size]

@Fate2726 Hi! I really like the way the spreadsheet is set up, however, I am not sure why but for some reason my missing column isn't entirely accurate? For example, it is all fine until I get to Arcane Sprite, if I list it as no, it updates the number of missing but does not list Arcane Sprite. If I then change it to yes, then it completely removes the next missing familiar underneath Arcane Sprite (in my case, Armored Greatowl). I am not sure what I could be doing wrong? The only thing I have changed is the yes or nos as I am going through my list. I also noticed that one of them gives a repeat, Ashen Bicorn Whale.

Here's my sheet so far, I unhid Column I so I could see which were listed as missing.

---

[center][color=#7730b5]@Wych Alright, looks like it's an easy enough fix luckily! I'm fairly sure the error was made on my part in the blank copy, and for that I'd like to apologize. The reason you're seeing duplicates is due to the formula being the same for more than one cell under column H. Most things in I are still correct, but it doesn't look to be that you copied over the formula into I561. No worries though! What I would do to avoid having to sift through each cell individually and change them as need be, I'd recommend the following steps: [/color][/center] [center]---[/center] 1: You'll need to highlight the top three cells in columns H and I by left clicking your mouse on cell H6 and drag it over to I8. 2: Click the small box that shows on the lower right corner of the cells you just highlighted. This will allow the Spreadsheet to recognize "Hey, there's a formula here!" and replicate it accurately - hence the three. 3: Hold and drag the selection until your mouse is hovering over cell I666 (what a number) and then let go. Give the spreadsheet a moment to think and presto, the problem should be resolved! I'll provide images below to help you out a bit more, just in case my wording's funny. [img]https://i.imgur.com/rhE7KSP.png[/img] [i]Steps 1 and 2 are displayed above.[/i] [br] [img]https://i.imgur.com/83E8tLk.png[/img] [i]Step 3, end result. I only traveled to cell I665 to display that, if done correctly, you should have a faint, dotted gray box to indicate the area of cells you're including. It's just harder to see when flush against the colored cells.[/i]