Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | [Tool] Simple Familiar Tracker-outdated
1 2 ... 4 5 6 7 8 ... 18 19
@AisDareth @Pashinko @Noddddd @Rabigrace @yellowstarfish @Lucks
@Trilonyte @Ziraous @Rosebrush
new sphinx familiar is added ^^
@AisDareth @Pashinko @Noddddd @Rabigrace @yellowstarfish @Lucks
@Trilonyte @Ziraous @Rosebrush
new sphinx familiar is added ^^
timezone: FR+11
@AisDareth @Pashinko @Noddddd @Rabigrace @yellowstarfish @Lucks
@Trilonyte @Ziraous @Rosebrush

new familiar added (Flameforger's Festival)
@AisDareth @Pashinko @Noddddd @Rabigrace @yellowstarfish @Lucks
@Trilonyte @Ziraous @Rosebrush

new familiar added (Flameforger's Festival)
timezone: FR+11
Could I be added to the pinglist? This is super helpful!
Could I be added to the pinglist? This is super helpful!
make_mother_proud_by_duinimrais-d85f1js.gif
@jodran
sure ^^
@jodran
sure ^^
timezone: FR+11
Thanks for this! (please add me to the pinglist)
Thanks for this! (please add me to the pinglist)
sQ35KLV.png
31QI5kR.pngRVCJPrX.png FR+9 Hours
@Neflo oooh, I was curious about using a familiar tracker because bestiary browsing is a pain, gonna try out these sheets to help keep track of my familiars!

I'd love to be added to the pinglist please! c:
@Neflo oooh, I was curious about using a familiar tracker because bestiary browsing is a pain, gonna try out these sheets to help keep track of my familiars!

I'd love to be added to the pinglist please! c:
3u37mIB.png
@Unelore @shoujo
thank you both for using my sheet! ovo
added you to the pinglist.
@Unelore @shoujo
thank you both for using my sheet! ovo
added you to the pinglist.
timezone: FR+11
@AisDareth @Pashinko @Noddddd @Rabigrace @yellowstarfish @Lucks
@Trilonyte @Ziraous @Rosebrush @jodran @Unelore @shoujo

today is a big update! please make a new copy, the old one will stop working soon.

spreadsheet (v1) - only supports lair order
spreadsheet (v2) - supports lair order and order by name

what changed: I rewrote some formulas, sheet should load faster. changed formatting, now v1 looks similar to v2. added new tabs, baldwin and swipp. they are similar to "sort/by status" tab, and show familiar recipes

V V please follow instructions in "sep.20.19." tab. V V
if you have trouble, send me your old copy and I'll help you.

how to move your data to another copy

new familiar is also added (Autumn Sphinx)
@AisDareth @Pashinko @Noddddd @Rabigrace @yellowstarfish @Lucks
@Trilonyte @Ziraous @Rosebrush @jodran @Unelore @shoujo

today is a big update! please make a new copy, the old one will stop working soon.

spreadsheet (v1) - only supports lair order
spreadsheet (v2) - supports lair order and order by name

what changed: I rewrote some formulas, sheet should load faster. changed formatting, now v1 looks similar to v2. added new tabs, baldwin and swipp. they are similar to "sort/by status" tab, and show familiar recipes

V V please follow instructions in "sep.20.19." tab. V V
if you have trouble, send me your old copy and I'll help you.

how to move your data to another copy

new familiar is also added (Autumn Sphinx)
timezone: FR+11
hi, i love your sheet and i've been using it for ages, could you add me to the ping list please?

also, i seem to be having issues getting the swipp filters working, the entire table is blank whenever i select locked/unlocked/awakened familiars? i use v2 and the lair order tab
hi, i love your sheet and i've been using it for ages, could you add me to the ping list please?

also, i seem to be having issues getting the swipp filters working, the entire table is blank whenever i select locked/unlocked/awakened familiars? i use v2 and the lair order tab
_ _ _ _ xWsqmwJ.png
_hedj_
gdblirs.png
_ _she/they/he
_ _gmt+0/fr+8
_ _
lNYuJMt.png
@hedjeroo
sure, no problem!

about the swipp tab: oops, I messed up with the formula and didn't notice. how to fix:
click on H8 cell in "swipp" tab
erase the formula
paste this

=IFNA(IF(I5="all familiars",sort(B8:E,if(I4="by lair order",4,1),true), sort(FILTER(B8:F,D8:D=SWITCH($I5,"locked familiars","locked","unlocked familiars","unlocked","awakened familiars","awakened")),IF($I4="by lair order",4,1),true)),)
@hedjeroo
sure, no problem!

about the swipp tab: oops, I messed up with the formula and didn't notice. how to fix:
click on H8 cell in "swipp" tab
erase the formula
paste this

=IFNA(IF(I5="all familiars",sort(B8:E,if(I4="by lair order",4,1),true), sort(FILTER(B8:F,D8:D=SWITCH($I5,"locked familiars","locked","unlocked familiars","unlocked","awakened familiars","awakened")),IF($I4="by lair order",4,1),true)),)
timezone: FR+11
1 2 ... 4 5 6 7 8 ... 18 19