Hi guys! @heliel here with a pretty simple tracker! Not a lot of fancy graphics or coding here, and I know Ravenmoon has a tracker (which is fantastic, btw!), but I wanted to go ahead and share mine. If you're looking for a tracker with a lot of very nice bells and whistles (equipped lists, full lists of retired/otherwise unavailable familiars, non-interactive coliseum list, even a bonding level list and a lot more!), I highly recommend Ravenmoon's tracker over mine.
Right now, it's really barebones - everything is text and it has a lot of simple formulas (I can't pretend I'm that much of a coder, honestly). I'm in the process ofmaking an image-heavy version, as well as looking into other methods to display things on the list page. I've added a link to the image-style sheet! It features the same basic options as the imageless tracker, but has an updated, easier-to-read Venue page. Feel free to let me know if you have any suggestions!
Right now, it's really barebones - everything is text and it has a lot of simple formulas (I can't pretend I'm that much of a coder, honestly). I'm in the process of
Imageless Tracker v0.3
Image-style Tracker v0.3
Quote:
Image-style Tracker v0.3
Some notes:
- There's an introductory instruction page, which gives a handful of quick notes on how to use the guide.
- You shouldn't have to adjust the Familiar List page at all - everything on that page is controlled by formulas
- The Value page lists all of the familiars on the list, but any familiar you can get in the Coliseum, in any venue, has a formula to display it. Originally, it was even more barebones in that it didn't have a venue page at all - and for me, I can remember what was available in venues.
- If this is confusing, please let me know! I can adjust the Value page so it no longer shows the familiars from the Coliseum.
- You are, of course, also free to just delete the formula in the Value page - it won't hurt any other formulas, but you'll also have to scroll through the entire list every time you want to update (which, when you're grinding the coliseum for hours, can be tedious and annoying, imo).
- The Venue page has an alphabetical list of all the familiars available in the Coliseum, organised by what venue they're available in. Familiars available in multiple venues are only listed once, in the first venue in which they appear. ALL familiars on this list should be recorded on this page, regardless of where you got them (marketplace, chest, coliseum, etc.).
- Adding familiars to the list is a little bit tedious - you have to show the hidden sheet, first of all. You do this by clicking the little icon next to the + on the bottom left and selecting the hidden H-N sheet:
Then you add the data, add cells and data to the values page, potentially make a formula to link to the venue page, and add venue page data as needed. You'll also have to add cells to the familiar list page.
Then, you'll need to select the last pair of cells (name and xtra) with data on the Familiar List, and use the arrow in the right corner to drag them down and insert all the proper coding to display everything properly.
Finally, you'll probably want to select the entire sheet (for both the hidden sheet and the Values list) and click data->sort range, check the "data has header row" box, ensure the dropdown for sort by is on "Name", and click sort. After all of that, you can hide the list
Quote:
Changelog
- Added new familiars: Melprin, Roundhorn Melprin, Polarfreeze Defender
- Adjusted cells to properly fit Yellow-Throated Sparrowmouse - whoops!
- Changed display style for bonding on Familiar List (Icon version only)
- For now, if the Values sheet's bonding level is changed, it will reflect on the Familiar List's background. Looking for a workaround without creating extra conditional rules. (Icon version only)
- Centre aligned the "Xtra" display for neatness