Guides
Community created guides, helpful strategies, and more.
TOPIC | Excel Familiar Tracker[Updated 5/17/18]
1 2 3 4 5 6 7 ... 65 66
[center][img]http://i.imgur.com/qq3oXHM.png[/img] [/center] [center]Hello everyone! I've used Ravenmoon's familiar tracker since I joined the site. I kept mine updated long after she moved on to other projects, and even made some changes of my own! I thought maybe others might like to continue using the sheet as well, so I've gotten permission to share this with all of you and publicly take over updating it![/center] [center][url=https://docs.google.com/spreadsheets/d/1Ne4OuQyIdFH8OQXFJkJmn232PNMZPbBwUpWowNP_qzw/edit?usp=sharing][img]http://i.imgur.com/kVZjRPV.png[/img][/url][/center] To get your own copy to use, go into "File --> Make a copy" and it will save on your own Google Drive. As new familiars come out, I will add them to the update sheet, from which you can copy as needed to add to your own sheet. Directions on how to add new familiars to your list are on the first page of your spreadsheet! Please note that holiday and other limited release familiars are on the second page of the update sheet. [center][url=https://docs.google.com/spreadsheets/d/1JDFnxnmfHrLnnxTt1543dIbhJy2KYKmwVZz8upJ46yY/edit?usp=sharing][img]http://i.imgur.com/YBaxSoC.png[/img][/url][/center] If you are interested in being added to (or removed from) the ping list, please ping me in this thread. If you do not ping me, I will likely not see your message! [quote="Ping List for Updates"] [size=2] @wannabequeen @Melodist @lucineblue @radpunkster @Crashkey @AbstractAlgebra @Asobi @sykotikkytten @Ramoth416 @redpanda110 @Flightyvandal @elerina @Slitt @Artimean @Scatterspark @TheMur @houseBurning @BluePhoenix @thequeenofhearts @Meymo @Jam @Kellendraysia @Eloritia @perytonfeathers @Sharkra @Caloprymnus @QueSeraAwesome @Prinxee @MystRunner @KorrianaVeil @Praxis @Duh @Ashbashin @MageMagpie @KottrTungl @fluffballofdoom @Aranelle @Valmue @Framherja @Allaur @Ethanaell @Katta @DragonsKnight @Erravit @Rennox @nijihitomi @Aloy @Kelaku @arlip @Eyry @Pseudoscience @Pripyat @RayFisch @internetWeasel @alqu @thequeenbeegeek @Lilykittens @Steel @SisterofWar @Ankhr @MagicianPokes @EonShinato @Korangar @StitchedinIce @raetonic @Kcdollar @AvalonDreams @ilimati @jibori @Osa @Rosolite @BarnacleGF @pbg146 @Kimizi @Emmie @Istoki @SpiritKin @Gathouria @absolmon @Aquazap222 @IgnotusSomnium @Trixy @Tserin @SSakuras @LunarConstruct @Nixifer @redpandaa @Fidgety @jibori @Yamielsun @silverdrake @scorchfrost @StarlitFire @Valikor @Avenegeus @HummingbirdColor @SPARKLENERD @absolmon @kriskrossness @Kangataroo @TipsyTech @Quinnigan @MelodiousPoet @cyleris @EnderNova @Buffykiev @Tidemaiden @Kairos @squidkid11 @ladra @Larphen @Erzdrache @NuclearWaffles @Nimitsu @Cinderfire @StarriannaFlare @GallantGoat @Fosterson @MadasaHatter @Alludra @Becky @Auzreyla @Eskarine @NotSoSimple @Siris @SaturnianWildcat @shizuyue @Natblida @Shougoney @NekoAika @Tyeth @bexinthesky @Ravenspinner @pudgeSnail @Sanguiem @spadey @ObsidianPunk @texaswatermelon @Ninive @ColoradoBlues @aformofmotion @RoseArtemis @Misoph @Macabre @Rulanir @Ethuiliel @MamaNeko0315 @musicfan4 @KiraLaManzana @slothqueenxx @Quidings @NovelLady @JadeJewels @fidothehoarder @Cardixa @WolfTrickster @DreamingFoxes @Ciaccona @Chardons @carcharleucas @Mellacherry @Espello @Doodeedoodah @Cardixa @VulpixSerpens @Xirei @Randeh @mercurialwings @VelvetCrawdad @PrinceRaven @wolfayal @frameofreality @Quetzalzotz @MythsFlight @AnkanV @deanbean @BlackJay @Geishacookie @Avifors @Erayidil @uhhjoyce27 @ItchyBuffalo @Iclil @AimzVador @MissMaira @Kisa96 @Sketchanie @Casanoble @nm8426 @SteampunkAndroid @Sakito @dreamsandbones @bakurabox @Pinguin @endlessangels @tsubakistar @Inukaya @gayfrogger @Carolynmbp @ChiefWhiz @SteelAndSparks @BrightHeaven @Badgerlock @Sili @YouJaneMeTarzan @Neflo @Sugnaronos @Sunbell @venassir @DragonsChilde @WolfeRising @Raewyn @Ikterrin @LadySchiavona @Alxamei @spectralcountry @Crysi102 @janetlin @Ototo @Ender080 @bumblebutt @10voids @Skoshek @Ffeion @LiNaan @ToxicNeonFish @NickNikki @Morvudd @sunnyVista @Sachqua @starlightvelaris @aredshroom @Drakaneal [/size] [/quote] ----- [center][size=7]FAQ[/size][/center] ----- [b]Something is wrong with my spreadsheet. Will you please help me fix it?[/b] Sure! But you should try a few things on your own, first. Have you tried recopying the affected sheet from the template? Have you tried googling the problem on your own, or checking the Google Sheets help forums? Most of the questions I get are not actually related to the familiar spreadsheet, but just to Google Sheets in general, and so there are many resources out there you could use to help debug the problem yourself. If you're still stumped, feel free to ping me on this thread and I'll see if I can help! [b]I found a bug in the template sheet![/b] Awesome! Please let me know so I can fix it! [b]A new familiar is out, please update the sheet![/b] If I have not updated the sheet yet, I have either not logged on, or important real-life issues have gotten in the way. Pinging or messaging me will never speed up the process, so please don't. I'm not trying to be mean, but getting many pings on the matter within hours of a familiar being released honestly only slows down the process for everyone! [b]I found a familiar that drops from a random chest, but it's not listed as dropping from that chest on the spreadsheet![/b] I do not track which familiars fall from random chests such as Rusted, Iron, and Gilded Chests. Any familiar listings that do have this data are left over from the previous custodian of this sheet. Keeping track of all of them nowadays would be quite a task, and if you're trying to collect certain familiars, opening chests is too random to be a viable option, anyways!
qq3oXHM.png

Hello everyone!

I've used Ravenmoon's familiar tracker since I joined the site. I kept mine updated long after she moved on to other projects, and even made some changes of my own! I thought maybe others might like to continue using the sheet as well, so I've gotten permission to share this with all of you and publicly take over updating it!

kVZjRPV.png


To get your own copy to use, go into "File --> Make a copy" and it will save on your own Google Drive.

As new familiars come out, I will add them to the update sheet, from which you can copy as needed to add to your own sheet. Directions on how to add new familiars to your list are on the first page of your spreadsheet! Please note that holiday and other limited release familiars are on the second page of the update sheet.

YBaxSoC.png


If you are interested in being added to (or removed from) the ping list, please ping me in this thread. If you do not ping me, I will likely not see your message!


Ping List for Updates wrote:


@wannabequeen @Melodist @lucineblue @radpunkster @Crashkey @AbstractAlgebra @Asobi @sykotikkytten @Ramoth416 @redpanda110 @Flightyvandal @elerina @Slitt @Artimean @Scatterspark @TheMur @houseBurning @BluePhoenix @thequeenofhearts @Meymo @Jam @Kellendraysia @Eloritia @perytonfeathers @Sharkra @Caloprymnus @QueSeraAwesome @Prinxee @MystRunner @KorrianaVeil @Praxis @Duh @Ashbashin @MageMagpie @KottrTungl @fluffballofdoom @Aranelle @Valmue @Framherja @Allaur @Ethanaell @Katta @DragonsKnight @Erravit @Rennox @nijihitomi @Aloy @Kelaku @arlip @Eyry @Pseudoscience @Pripyat @RayFisch @internetWeasel @alqu @thequeenbeegeek @Lilykittens @Steel @SisterofWar @Ankhr @MagicianPokes @EonShinato @Korangar @StitchedinIce @raetonic @Kcdollar @AvalonDreams @ilimati @jibori @Osa @Rosolite @BarnacleGF @pbg146 @Kimizi @Emmie @Istoki @SpiritKin @Gathouria @absolmon @Aquazap222 @IgnotusSomnium @Trixy @Tserin @SSakuras @LunarConstruct @Nixifer @redpandaa @Fidgety @jibori @Yamielsun @silverdrake @scorchfrost @StarlitFire @Valikor @Avenegeus @HummingbirdColor @SPARKLENERD @absolmon @kriskrossness @Kangataroo @TipsyTech @Quinnigan @MelodiousPoet @cyleris @EnderNova @Buffykiev @Tidemaiden @Kairos @squidkid11 @ladra @Larphen @Erzdrache @NuclearWaffles @Nimitsu @Cinderfire @StarriannaFlare @GallantGoat @Fosterson @MadasaHatter @Alludra @Becky @Auzreyla @Eskarine @NotSoSimple @Siris @SaturnianWildcat @shizuyue @Natblida @Shougoney @NekoAika @Tyeth @bexinthesky @Ravenspinner @pudgeSnail @Sanguiem @spadey @ObsidianPunk @texaswatermelon @Ninive @ColoradoBlues @aformofmotion @RoseArtemis @Misoph @Macabre @Rulanir @Ethuiliel @MamaNeko0315 @musicfan4 @KiraLaManzana @slothqueenxx @Quidings @NovelLady @JadeJewels @fidothehoarder @Cardixa @WolfTrickster @DreamingFoxes @Ciaccona @Chardons @carcharleucas @Mellacherry @Espello @Doodeedoodah @Cardixa @VulpixSerpens @Xirei @Randeh @mercurialwings @VelvetCrawdad @PrinceRaven @wolfayal @frameofreality @Quetzalzotz @MythsFlight @AnkanV @deanbean @BlackJay @Geishacookie @Avifors @Erayidil @uhhjoyce27 @ItchyBuffalo @Iclil @AimzVador @MissMaira @Kisa96 @Sketchanie @Casanoble @nm8426 @SteampunkAndroid @Sakito @dreamsandbones @bakurabox @Pinguin @endlessangels @tsubakistar @Inukaya @gayfrogger @Carolynmbp @ChiefWhiz @SteelAndSparks @BrightHeaven @Badgerlock @Sili @YouJaneMeTarzan @Neflo @Sugnaronos @Sunbell @venassir @DragonsChilde @WolfeRising @Raewyn @Ikterrin @LadySchiavona @Alxamei @spectralcountry @Crysi102 @janetlin @Ototo @Ender080 @bumblebutt @10voids @Skoshek @Ffeion @LiNaan @ToxicNeonFish @NickNikki @Morvudd @sunnyVista @Sachqua @starlightvelaris @aredshroom @Drakaneal






FAQ




Something is wrong with my spreadsheet. Will you please help me fix it?

Sure! But you should try a few things on your own, first. Have you tried recopying the affected sheet from the template? Have you tried googling the problem on your own, or checking the Google Sheets help forums? Most of the questions I get are not actually related to the familiar spreadsheet, but just to Google Sheets in general, and so there are many resources out there you could use to help debug the problem yourself.

If you're still stumped, feel free to ping me on this thread and I'll see if I can help!



I found a bug in the template sheet!

Awesome! Please let me know so I can fix it!



A new familiar is out, please update the sheet!

If I have not updated the sheet yet, I have either not logged on, or important real-life issues have gotten in the way. Pinging or messaging me will never speed up the process, so please don't. I'm not trying to be mean, but getting many pings on the matter within hours of a familiar being released honestly only slows down the process for everyone!



I found a familiar that drops from a random chest, but it's not listed as dropping from that chest on the spreadsheet!

I do not track which familiars fall from random chests such as Rusted, Iron, and Gilded Chests. Any familiar listings that do have this data are left over from the previous custodian of this sheet. Keeping track of all of them nowadays would be quite a task, and if you're trying to collect certain familiars, opening chests is too random to be a viable option, anyways!


hsHFijz.png
@Flurry

Thank you for posting this ! I was using a familiar tracker but they didnt have all the familiars like this one does :D thanks !
@Flurry

Thank you for posting this ! I was using a familiar tracker but they didnt have all the familiars like this one does :D thanks !
@Kimizi Glad someone else could make use of it! :)
@Kimizi Glad someone else could make use of it! :)
hsHFijz.png
@Flurry

Thank you for this. Will you be updating it further? I located an original link to the first thread it came from but it now leads to a 404.
@Flurry

Thank you for this. Will you be updating it further? I located an original link to the first thread it came from but it now leads to a 404.
y1hNecV.png
@JDBeckett Yes! Ravenmoon, the original creator, intends to revamp it eventually, but until she has time to do that I will be keeping this one completely updated! :)
@JDBeckett Yes! Ravenmoon, the original creator, intends to revamp it eventually, but until she has time to do that I will be keeping this one completely updated! :)
hsHFijz.png
@Flurry
Sounds like a plan. I've updated mine with the new one from this month for the sake that I had it and it's not too complex but I'll be happy to leave the rest of the updating for those who really know what they're doing. Thank you for linking to it though.
@Flurry
Sounds like a plan. I've updated mine with the new one from this month for the sake that I had it and it's not too complex but I'll be happy to leave the rest of the updating for those who really know what they're doing. Thank you for linking to it though.
y1hNecV.png
@JDBeckett Sorry about that! I'm at the beach on holiday so I haven't been spending too much time online, haha. I have updated it. Thanks for the reminder!
@JDBeckett Sorry about that! I'm at the beach on holiday so I haven't been spending too much time online, haha. I have updated it. Thanks for the reminder!
hsHFijz.png
@Flurry What happens when new familiars are added and I've made a copy of the spreadsheet? I assume changes made to the master copy will not reflect on the copy I've saved to my Drive?
@Flurry What happens when new familiars are added and I've made a copy of the spreadsheet? I assume changes made to the master copy will not reflect on the copy I've saved to my Drive?
@BluePhoenix No, they won't. I will update the template sheet, and then add a link to a plain sheet that is just the "new" familiars, the same way Ravenmoon did. You can copy those and paste them at the bottom of your own "Regular familiars" spreadsheet, then highlight all the rows of familiars and alphabetize by column C. This puts them back into alphabetical order with the new familiars.

I can do something similar for Holiday familiars, where you just have to copy and paste the one row.

I just haven't added the "Updates" sheet yet as the only new familiar since I released this has been the Nature Bear, and I've been on vacation. I will have it ready by the end of this weekend. Clearer instructions on how to do it were already written by Ravenmoon and are on the first page of your sheet.
@BluePhoenix No, they won't. I will update the template sheet, and then add a link to a plain sheet that is just the "new" familiars, the same way Ravenmoon did. You can copy those and paste them at the bottom of your own "Regular familiars" spreadsheet, then highlight all the rows of familiars and alphabetize by column C. This puts them back into alphabetical order with the new familiars.

I can do something similar for Holiday familiars, where you just have to copy and paste the one row.

I just haven't added the "Updates" sheet yet as the only new familiar since I released this has been the Nature Bear, and I've been on vacation. I will have it ready by the end of this weekend. Clearer instructions on how to do it were already written by Ravenmoon and are on the first page of your sheet.
hsHFijz.png
Updated with today's new familiars! :)
Updated with today's new familiars! :)
hsHFijz.png
1 2 3 4 5 6 7 ... 65 66