Guides

@KittyAoba I can totally look it up for you! My personal SS is at almost 400 dragons (I really have to split it just for speed's sake ;; )

The sheet should be ok for 900 dragons, probably more but that's as far as I have tested for now since clans should hopefully not be above 650.

If you already have a sheet setup share me the link by message!
If you have a discord it might make it easier (faster) to communicate too :)

Minor fix to the projects tab~
It wasn't populating dragons genes if no breed genes were done.

I'm making sure projects tab is all working before making actual fix announcement.

While I was working on that I figured I'd change how to "wipe" pages.
Took out the script I made to clear the auto-filler tab to instead move the formulas around so they would not be deleted when selecting cells to clear.

I've also revamped my pairings tab revamp to make it possible to do the same.
Probably going to do the same for Projects tab... will make it easier to move dragons around.

[center][img]http://puu.sh/s3htt/394c19cfe8.png[/img] [size=5][b]Super Lair Update - v.5.1[/b][/size] Revamped the revamp! AutoFiller, Pairings, Project and Selling tabs were revamped from the previous sheet. This will make it easier to makes changes or clear dragons on these lists. Topped the sheet at 1500 dragons. It is possible to add more but will need to change all formulas for it to work. At that point it would simply be best to make a second sheet ;) [size=5][url=https://docs.google.com/spreadsheets/d/1ApdBL5sDuelx07H8UjQyvebX5NcCqc1NFaW0ifJGCN8/edit?usp=sharing]Super Lair in action[/url] [url=https://docs.google.com/spreadsheets/d/1k90vpfCoacJ1TNeCistGBbIR-F8h4KcxaqwG_MuzY5A/edit?usp=sharing]Blank version[/url][/size] Updates : [LIST] [*]All pages with 1500 lines. [*]AutoFiller, Projects, Pairing and Selling tab easier to clear user info [*]Fixed gene propagation on pairings tab if no breed changes selected [*]Fixed Veined not existing for Modern breeds [/LIST] [center][img]http://puu.sh/s3hWm/c0591abcfc.png[/img] [size=1] @Bubonica @kipinae @Lanikot @Auresse @purplejabberwock @absolmon @cinderrain @toxipraline @LordAlois @MoonBiter @Gr12zly @KittyAoba @wingedRenegade @Jamethyst @KitKaze @YouThereYeaYou @Taskuhecate @LunarLunacy @jibori @Trixy @GalaxyFlare @HummingbirdColor @AetherDragon @Cinderfire @PrimeNumbersCas @SpringsSong @Sanguiem @Catsy01 @nielybh @SimFeetUnder @Sky93 @Starrydance @Kallifrey @Brea @IntelligentWolf @Twinkletoe @SoulOfChaos @Quetzalzotz @Beezadrella @Juneun @GarnetRose @AristaHolmes @mauvehouseplant @SkyJumper @Ichored @Prinxee @Fauviein @Chadtronic @Alphazi @Servalan @Naufragate @CaveJohnson @Jetfeather @StormyDragon @Raineski @Plancake @Evlon @JoyLayne @Risuna @Rosekitten @LancelotOfTheSky @Evilie @Siennia @LadyNycto @Enterea @Gwinna @kickthebeat @RaveLegend @KairinRose @Ethuiliel @Kabu @InkTheatre @spicecake @Drakaneal @Rainbeetle @Sickened @dragonspit999 @LillySunset @Meereswind @Moondragon007 @TornadoTorrie @PsycheFennecat @catslash @Kaibaman @Restless @Pinguin @ChibiFluffy @Divinia @Rosecrimson @Illyrael @Angii @bonibaru @B1ue @lieb @PersimmonBird @Doodeedoodah @Demetre @hat17 @Juneside @CheshireCatUk1 @Absol1234 @Ozpin @soulykins @MarvinPA @Cog @Honorat @LynterriaHatake @MusicalMaladies @Kavrrin @Stargirl8686 @chronicDreamer @heartcrusher1 @SomehowStillSane @DragonSanctuary @sadri22 @SeaCrest @ArcticFire @CrankyCrew @succulentclub @Hawkgirl6511 @Noddddd @LadyMora @leaofthewolves @Shapes05 @PetitMoutonNoir @HardcoreUvula @proserpinaseeds @CobaltMoon @Mnkn10 @ladymcjingles @Enkil @MoonCatcher333 @atrolock @MintTangle @Nirnasha17 @tsubakistar @Loyalties @BottledLightning @FredTheCloud @Runarite @TheTokenBrit @StarsOfFate @BonBonMaster @SkylarDN9 @Mnkn10 @Vetycin @FOXHOUND @retrace @AteanaLenn @Pachirisu @SmolWolfieBean @nottwosmallcacti @Sylvidoptera @Merrysaurus @GalenLeBeux @sarzi @MayWhitestar @Reddhed @sleepyboi @Phaedra @cut73ry @TeenyTK @Daroga @littletoes101 @Kallifrey @RealityMask @Sunnymatsu @Bledout @QueenAlchemy @OkiDokiLoki @naranciag @RosyWindFox @Cyranelle @starlightdreams @Siscily @EternalLife @Kelaku @Tephis @eridenthe @caddyshack @Plaguebringer21 @Atrodei @Tinble @NightOrchiid @Silexiunno @y2kbugs @CiciOrcody @TwoMagpies @WannabeAlien [/size] [img]http://puu.sh/s3huw/7d48e82a1a.png[/img][/center]

so i haven't made the switch yet, even though 5.0 is really amazing, because on top of having the art column i like to have a separate column for whether or not they have a Library shelf (ie, my signature). how difficult would it be for me to add that in? would i break things doing so?

@Pachirisu That is a very good question!!
I personally would include that in the art column and maybe add a note ?

Changing anything to the data tab will make changes to every other tabs for sure.... Except if you add them at the end (after Notes).
By adding them there it should not change anything else and you would then be able to add it to the Dragons tab by copying the "Notes" formula and adding that new column.

@ChibiFluffy the problem with just using the art column is that i'm also tracking their regular art, so i'd need to do like YN or NY and that'd get confusing for me so fast XD i could do after notes, i suppose... hmmmmm

@Pachirisu you can add them after the "Notes" in the data tab, then you can put them wherever you want in the Dragons tab, the Dragons tab columns can be moved around no problem

@ChibiFluffy I'm having trouble with the tertiary genes. In the Census page the only ones that show up are the basic genes. How do I fix this?

@Hiltain Oops! It's looking up the secondary genes instead of the tertiary.

If you want to make the fix on your side you can use "Find and Replace" under the EDIT menu.
Replace "$O" by "$Q" in the R column. You have to select "Also search within formulas" for it to work