Guides

[center][img]http://puu.sh/s3htt/394c19cfe8.png[/img] [size=5][b]Super Lair Update - v.5.0[/b][/size] New Version 5 is live ! Everything updated to hopefully make it even more complete! [size=5][url=https://docs.google.com/spreadsheets/d/1zjM58DgTNZF6tJ4n7OrNbgT1Mw81bb7z6N00IvOhRzM/edit?usp=sharing]Super Lair in action[/url] [url=https://docs.google.com/spreadsheets/d/1YH_ZmQ_9_W3PEmMe6bi-9YIchUQlB9nW470hGjqu-fY/edit?usp=sharing]Blank version[/url][/size] A complete list of all updates is not really possible, but here are the grand lines : [LIST] [*]new dashboard with links [*]complete data revamp, new columns and more info available [*]Changing dragon selection from "name" to "name (id)" (in case of more then 1 dragon with same name) [*]new auto filler and converter from old versions [*] There is a "clear all" script for the Auto-Filler, it only clears editable cells from the autofiller [*]complete lair revamp -> now dragons and sold [*]Lair census merged with part of color charts -> now census [*]Charts and color charts merged -> now charts [*]Adding a sold / selling tab [*]Massive Breeding lab revamp [*]Create more bbcode templates [*]Updated code when possible to make spreadsheet faster (it is so massive I can't do much) [*]All ref sheets are hidden for protection and making it less cluttered [/LIST] [b]Credit :[/b] Bright Diamond Hatchery => was my principal reference for the selling and pairings tab @Poisonedpaper (again) for updates to the color prediction in the pairings tab @DilsDragons for the updated version of the bbcode maker in the pairings tab [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]

holy cow this looks AMAZING!! great work!!

Looks very nice, glad to see all the little improvements from the beta and the pairings tab is awesome!!

@ChibiFluffy It seems that weight, wingspan, and length are broken. The sheet doesn't seem to like the decimal points. Is there an easy fix for that? O_O

EDIT: The census also doesn't appear to be reading the hatch dates of my dragons, either. O_O

@Plaguebringer21 I do not understand what you mean ? @KittyAoba Sadly some things I cannot fix... you'll have to select the columns containing weight, wingspan, length and change their format to "Number" The same will have to be done with dates this will also fix the census that probably can't find the numbers it needs to work For some reason the sheet doesn't seem to remember what numbers and dates are [emoji=fae confused size=1]

@Plaguebringer21 that would be the date you updated the offspring of that dragon :)

@ChibiFluffy ...nothing I do seems to be working. Can I hire you to take a look for me? Because I seem to be sheets illiterate and can't figure this out. Also worried about adding more lines for the rest of my lair, because... I have several hundred dragons at this point (303 with space for 341 at this moment) and I don't want to break anything. lmao