Lair Tracker 3.2 [ NEW THREAD ] | Guides

@Coolkid @NoAkei @raanve @cassolotl @AshtaraSilunar @Flameswind @LuthienTinuviel @Xenobiological @sharikak @MacGreine @Guenhwyvar @rachools @squidragon @Hidd3nstare @Pandonkey @Silvanuyx @Soloontherocks @GoddessLoki @daenae @unityManipulator @CynicalKat @xXBlaydedXx @Desiderii @BottledGrace @Lyani @RavynStarfall @awerebear @Chrizesu @shinykari @Archfiend @AlexRider @Shockbunny @pandlewords @kariann02 @thedragonwithin @Northernly @TeenyMallow @Lapillus @Heatherly @Mole @Melodious @OrchestralAscent @obscuresoul @Crowleyisking @zephryi @Arithelia @KittersKamala @Feyna @PopcornFireworks @armychick337 @Ravenmoon @Kajira @Lapillus @ravenclawgirl @Mags @Nymphalidae @Xphyra @sadri22 @stacheldrahtzaun @MLein @Makiling @Malis @Faunus @Pasafatu @Fluffloid @KaidaHime @Coolkid @Corporal @Heatherly @Sica @InkstainedGwyn @katoptron @ScrivenerLielac @Wintyr @EsdeeAr @logomachy @Cassolotl @Geronima @Dragondrop @Ithiltari @destopianfuture @rhubarbcobbler @eonpixi @EvilBlackSheep @demonoflight @Modiste @SierraKomodo @bonsaiRocket @Paleh @Mojave @YukiDaviji @Loxi @Alternatewarning @Spatial @Aeice @Dragonsteps8472 @Rubaiyate @Moongrave @mayorpunk @Kitsara @squidmagician @Glowria @DeepflowManah @KittyAoba @kopitar @Charl1e @meiloslyther @BunnySox @jennysyc @Kintsy @Pachirisu @Eloritia @Tindi11 @Itazu @NataliaKills @houseburning @Lanikot @Trixillia @Prinxee @LocketShoru @Cousin @whoiseliza @aenaithia

Added Stained to the list. At least it helped me catch a backwards ratio on Glimmer and Okapi, I guess.

Remember -- please make sure you are using a copy of the User Copy which automatically updates itself from the Master Copy when you open it. If you are, your sheet should be properly updated by the time you get this ping!

As usual, if something goes wrong or you notice a problem, please ping me, @Alestrius, here in the thread with a link to your spreadsheet (you'll have to enable sharing) and a description of your problem, and I'll get on it as fast as I can. :)

Alestrius

165

126

137

9569

February 01, 2016 01:29:13

@Coolkid @NoAkei @raanve @cassolotl @AshtaraSilunar @Flameswind @LuthienTinuviel @Xenobiological @sharikak @MacGreine @Guenhwyvar @rachools @squidragon @Hidd3nstare @Pandonkey @Silvanuyx @Soloontherocks @GoddessLoki @daenae @unityManipulator @CynicalKat @xXBlaydedXx @Desiderii @BottledGrace @Lyani @RavynStarfall @awerebear @Chrizesu @shinykari @Archfiend @AlexRider @Shockbunny @pandlewords @kariann02 @thedragonwithin @Northernly @TeenyMallow @Lapillus @Heatherly @Mole @Melodious @OrchestralAscent @obscuresoul @Crowleyisking @zephryi @Arithelia @KittersKamala @Feyna @PopcornFireworks @armychick337 @Ravenmoon @Kajira @Lapillus @ravenclawgirl @Mags @Nymphalidae @Xphyra @sadri22 @stacheldrahtzaun @MLein @Makiling @Malis @Faunus @Pasafatu @Fluffloid @KaidaHime @Coolkid @Corporal @Heatherly @Sica @InkstainedGwyn @katoptron @ScrivenerLielac @Wintyr @EsdeeAr @logomachy @Cassolotl @Geronima @Dragondrop @Ithiltari @destopianfuture @rhubarbcobbler @eonpixi @EvilBlackSheep @demonoflight @Modiste @SierraKomodo @bonsaiRocket @Paleh @Mojave @YukiDaviji @Loxi @Alternatewarning @Spatial @Aeice @Dragonsteps8472 @Rubaiyate @Moongrave @mayorpunk @Kitsara @squidmagician @Glowria @DeepflowManah @KittyAoba @kopitar @Charl1e @meiloslyther @BunnySox @jennysyc @Kintsy @Pachirisu @Eloritia @Tindi11 @Itazu @NataliaKills @houseburning @Lanikot @Trixillia @Prinxee @LocketShoru @Cousin @whoiseliza @aenaithia

Added Stained to the list. At least it helped me catch a backwards ratio on Glimmer and Okapi, I guess.

Remember -- please make sure you are using a copy of the User Copy which automatically updates itself from the Master Copy when you open it. If you are, your sheet should be properly updated by the time you get this ping!

As usual, if something goes wrong or you notice a problem, please ping me, @Alestrius, here in the thread with a link to your spreadsheet (you'll have to enable sharing) and a description of your problem, and I'll get on it as fast as I can. :)

Occasionally on unannounced/unplanned hiatus. See profile for Discord to contact off-site if needed for art reasons.

@alestrius you've misspelt "mossy cerdae" as "mossy cerda"

Pachirisu

582

371

1071

9594

February 01, 2016 11:46:55

@alestrius you've misspelt "mossy cerdae" as "mossy cerda"

I LOVE this!! Thank you to all who have worked on it and maintained it! May I be added to the ping list, please? @Alestrius
Thank you! :D

Kaletah

0

194

584

538

February 12, 2016 19:44:49

I LOVE this!! Thank you to all who have worked on it and maintained it! May I be added to the ping list, please? @Alestrius
Thank you! :D

This is fabulous! Can you please add me to the ping list? Thank you for all your hard work!

Suzarisk

467

408

771

734

February 13, 2016 22:25:45

This is fabulous! Can you please add me to the ping list? Thank you for all your hard work!

@Alestrius I'd love to be added to the ping list. Also, how could I rearrange and delete dragons w/o messing up the H-Lists

Coyoteclaw11

2

66

522

1076

February 18, 2016 09:45:29

@Alestrius I'd love to be added to the ping list. Also, how could I rearrange and delete dragons w/o messing up the H-Lists

Threads:

Shops
Adopt
Pixel Adopt
Art
-
-

Challenges
Xtreme Patience
Terra Incognita
Long Drop
All Familiar Challenge
-

@Alestrius I don't think anyone has asked this and I'm sure you've probably been trying to figure it out, but how do you plan to work everything out for the color wheel expansion? From my (and a few friends') experience, Google docs will only recognize 100 conditional formatting rules. Unless this has changed in the last couple months. Is there a workaround for this? Just curious.

meiloslyther

731

452

1152

181

February 25, 2016 17:27:23

@Alestrius I don't think anyone has asked this and I'm sure you've probably been trying to figure it out, but how do you plan to work everything out for the color wheel expansion? From my (and a few friends') experience, Google docs will only recognize 100 conditional formatting rules. Unless this has changed in the last couple months. Is there a workaround for this? Just curious.

@meiloslyther That's an excellent question. @Alestrius got in touch with me last night to point it out. I had some thoughts but decided to sit down and see what could be done in terms of expanding the conditional formatting rules. I know the old version of Google Spreadsheet (the original, before they introduced Sheets in 2014) was limited to 10 Conditional Formatting rules. They seem to have lifted that limitation entirely in Sheets. Just testing to see how many I could add, I got it up to 200 individual rules without an error.

It seems then that the ultimate answer is going to be "just add 100+ new rules to handle the new colors."

Xenoviel

0

80

852

186

February 26, 2016 17:30:48

@meiloslyther That's an excellent question. @Alestrius got in touch with me last night to point it out. I had some thoughts but decided to sit down and see what could be done in terms of expanding the conditional formatting rules. I know the old version of Google Spreadsheet (the original, before they introduced Sheets in 2014) was limited to 10 Conditional Formatting rules. They seem to have lifted that limitation entirely in Sheets. Just testing to see how many I could add, I got it up to 200 individual rules without an error.

It seems then that the ultimate answer is going to be "just add 100+ new rules to handle the new colors."

@Xenoviel Thanks! I just tested it myself (because if I remember correctly, the issue happened when the spreadsheet was copied or when using the format painter) and it seems to be working fine for me as well. Either our previous problems were a glitch or they've lifted/expanded the limits since. (This was early fall-ish last year? So it's entirely possible.)

Either way, I'm confident the integrity and usefulness of this spreadsheet is in good hands with you two, haha. (...Even if I frequently Frankenstein the crap out of it to make it do what I want.)

meiloslyther

731

452

1152

181

February 26, 2016 20:42:14

@Xenoviel Thanks! I just tested it myself (because if I remember correctly, the issue happened when the spreadsheet was copied or when using the format painter) and it seems to be working fine for me as well. Either our previous problems were a glitch or they've lifted/expanded the limits since. (This was early fall-ish last year? So it's entirely possible.)

Either way, I'm confident the integrity and usefulness of this spreadsheet is in good hands with you two, haha. (...Even if I frequently Frankenstein the crap out of it to make it do what I want.)

@Alestrius When you get a chance I'd love to be on this pinglist too