Guides

[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 @@Astraela @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 @aredshroom @Drakaneal @jadeturtle13 @ShadowclawFC @lovebite @vanagandr @Alliance @Plagueheart @ShinyWoobat @MiniDrachin @halforq @ilimati @Meridok @TwilightStars @mothscale @windypenguin @Catnip397 @Rosecrimson @B1ue @Ravaarian @Krakatoaa @Chook @DalekTzet @Pufferheart @ctTup @Stormster [/size] [/quote] ----- [center][size=7]FAQ[/size][/center] ----- [b]New familiars are missing the dropdown list on my spreadsheet.[/b] Eventually, you will run out of pre-formatted spaces on your sheet. You can extend the drop-down list formatting by hovering over the bottom right corner of a properly formatted cell until your cursor turns into a +. Then, click and drag to extend this formatting into other cells. [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!

@Kimizi Glad someone else could make use of it! :)

@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 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!

@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.

Updated with today's new familiars! :)