Guides

[center][img]http://puu.sh/s3htt/394c19cfe8.png[/img] [size=5][b]Super Lair Update - v.6.0[/b][/size][/center] [b]New version! [/b] The biggest update : This one has a separate reference sheet. You can leave it where it is and it'll be updated (by me) without you having to make changes every time there's a new gene or bred! If you prefer to keep your own, just copy / paste the data from the reference sheet to the ref_info tab as value only. While I was at it I also made some corrections and optimizations to the project, selling, pairings and Census tabs. Hopefully makes it easier to update and more automatic :) No changes to the data tab, so you can copy paste your version 5 data without a problem !! If you have suggestions of things to add or remove, please send them to me ! I do try to figure out how to make this better for you, but without input I'm just updating what I can see. [b]There's also a new pinglist system! [/b] I am moving out the previous sheet to that new system. Since I am solo on here it seems to be a good system :D I'll give it an update or two before deleting the manual pinglist, get yourself on the new list if you want to be kept up to date! [center][size=5][url=https://docs.google.com/spreadsheets/d/1PQ1NP4dFuk4G4J0tC9QhnqY6z92OIT1P24L9Iwz374g/edit?usp=sharing]Super Lair in action[/url] [url=https://docs.google.com/spreadsheets/d/1M6AZmHqCdBqSuOIXp2WfEprh5TJHptQpVV64CNdcqEc/edit?usp=sharing]Blank version[/url][/size][/center] [u][url=https://docs.google.com/spreadsheets/d/19-m6Y5NqC8e2EFZT1HHpe_DB5fNFYrsLIzEXYhgOC98/edit?usp=sharing]Reference sheet[/url] [/u] : you do not need a copy if you don't want to manually update it. [u][b]Updates : [/b][/u] [LIST] [*] Formula optimization in the Project, Selling and Pairing tabs [*] Corrected error in project tab when selecting Aether breed [*] Mini revamp of the Pairings tab, makes it easier to copy/paste from old sheet [*] Optimized Census page for future breed and gene additions. Not automatic, but makes it easier to edit [/LIST] [center][img]http://puu.sh/s3hWm/c0591abcfc.png[/img] [pinglist=2306] [size=1] @Absol1234 @absolmon @AetherDragon @Alphazi @Angii @ArcticFire @AristaHolmes @AteanaLenn @Atrodei @atrolock @Auresse @B1ue @Beezadrella @Bledout @BonBonMaster @bonibaru @BottledLightning @Brea @bubbaberriboo @Bubonica @BurittoKimasan @caddyshack @catslash @Catsy01 @Cautionary @CaveJohnson @Chadtronic @CheshireCatUk1 @ChibiFluffy @chronicDreamer @CiciOrcody @Cinderfire @cinderrain @CobaltMoon @Cog @CrankyCrew @cut73ry @Cyranelle @Daroga @Demetre @Divinia @Doodeedoodah @DragonSanctuary @dragonspit999 @Drakaneal @EldritchEscher @EnderPandas @Enkil @Enterea @eridenthe @EternalLife @Ethuiliel @Evilie @Evlon @Fauviein @FOXHOUND @FredTheCloud @GalaxyFlare @GalenLeBeux @GarnetRose @Gr12zly @Gwinna @HardcoreUvula @hat17 @Hawkgirl6511 @heartcrusher1 @Honorat @HummingbirdColor @Ichored @Illyrael @InkTheatre @IntelligentWolf @Jamethyst @Jetfeather @jibori @JoyLayne @Juneside @Juneun @Kabu @Kaibaman @KairinRose @Kallifrey @KallyPaige @Kavrrin @Kelaku @kickthebeat @kipinae @KitKaze @KittyAoba @knightmage @ladymcjingles @LadyMora @LadyNycto @LancelotOfTheSky @Lanikot @leaofthewolves @lieb @LillySunset @littletoes101 @LordAlois @Loyalties @Luaii @LunarLunacy @LynterriaHatake @MarvinPA @mauvehouseplant @MayWhitestar @Meereswind @meowfish @Merrysaurus @MintTangle @Mnkn10 @MoonBiter @MoonCatcher333 @Moondragon007 @MusicalMaladies @naranciag @Naufragate @nielybh @NightOrchiid @Nirnasha17 @Noddddd @nottwosmallcacti @OkiDokiLoki @Ozpin @Pachirisu @Panther202 @PersimmonBird @PetitMoutonNoir @Phaedra @Pinguin @Plaguebringer21 @Plancake @PrimeNumbersCas @Prinxee @proserpinaseeds @PsycheFennecat @purplejabberwock @QueenAlchemy @Quetzalzotz @Rainbeetle @Raineski @Elevation @RaveLegend @RealityMask @Reddhed @Restless @retrace @Risuna @Rosecrimson @Rosekitten @RosyWindFox @Runarite @sadri22 @Sanguiem @sarzi @Scripps @SeaCrest @securitr0n @Servalan @Shaddeh @Shapes05 @Sickened @Siennia @Silexiunno @SimFeetUnder @Siscily @Sky93 @SkyJumper @SkylarDN9 @sleepyboi @SmolWolfieBean @SomehowStillSane @SoulOfChaos @soulykins @spicecake @SpringsSong @Stargirl8686 @starlightdreams @Starrydance @StarsOfFate @Steffon @StormyDragon @succulentclub @Sunnymatsu @Sylvidoptera @Taskuhecate @TeenyTK @Tephis @TheTokenBrit @Tinble @TornadoTorrie @toxipraline @Trixy @tsubakistar @Twinkletoe @TwoMagpies @Vaixation @Vetycin @WannabeAlien @wingedRenegade @y2kbugs @YouThereYeaYou @kyeran @Zombrigit @veilmochi @ittybittycat [/size] [img]http://puu.sh/s3huw/7d48e82a1a.png[/img][/center]

@ChibiFluffy so for the reference sheet, do we make a copy if we want it to update when you make edits to it when there is a new breed/gene? sorry, i just have a hard time reading things sometimes ^^;

(Also when i try to change the link in the Updates header, like the instructions say, it says I dont have access to that spreadsheet, and it pops up as an error)

@veilmochi hey! if you want it to be updated when I update it, you should leave it has is
you don't need a copy of the reference sheet if you want me to update it

if you prefer to update it yourself then you would make a copy and change the link in the ref_info sheet to the new copy's link

Should I add a ping for reference sheet updates ? Added Wish! [code]213 Wish Rare Modern 1,200 G[/code]

Latest addition : Chrysocolla/Malachite [code]195 Chrysocolla Limited Sandsurge G&G 195 Malachite Limited Sandsurge G&G 237 Chrysocolla Limited Modern Arlo 237 Malachite Limited Modern Arlo [/code]

New breed!! [i]I am going insane, I want a all snake lair and this is gonna be expennssiivveee[/i] Ref sheet updated with Auraboa and all the genes :D [code]24 Auraboa Common Ancient 275,000 T[/code] [code]238 Bar Uncommon Auraboa 125,000 T 239 Boa Uncommon Auraboa 85,000 T 240 Boulder Limited Auraboa G&G 241 Caterpillar Uncommon Auraboa 105,000 T 242 Fade Common Auraboa 62,500 T 243 Falcon Common Auraboa 85,000 T 244 Fern Limited Auraboa G&G 245 Flaunt Uncommon Auraboa 100,000 T 246 Giraffe Uncommon Auraboa 112,500 T 247 Harlequin Rare Auraboa 750 G 248 Jaguar Uncommon Auraboa 70,000 T 249 Laced Common Auraboa 70,000 T 250 Metallic Rare Auraboa 750 G 251 Mochlus Uncommon Auraboa 117,500 T 252 Mosaic Uncommon Auraboa 300,000 T 253 Orb Limited Auraboa Baldwin 254 Piebald Common Auraboa 117,500 T 255 Python Limited Auraboa G&G 256 Rattlesnake Uncommon Auraboa 120,000 T 257 Ripple Uncommon Auraboa 125,000 T 258 Tapir Common Auraboa 92,500 T 259 Tiger Common Auraboa 67,500 T 260 Vipera Uncommon Auraboa 117,500 T 261 Varnish Uncommon Auraboa 100,000 T 262 Wicker Rare Auraboa 750 G 263 Starmap Rare Auraboa 750 G[/code] [code]238 Daub Uncommon Auraboa 82,500 T 239 Saddle Uncommon Auraboa 75,000 T 240 Myrid Limited Auraboa G&G 241 Larvae Uncommon Auraboa 90,000 T 242 Blend Common Auraboa 50,000 T 243 Peregrine Common Auraboa 70,000 T 244 Paisley Limited Auraboa G&G 245 Flair Uncommon Auraboa 82,500 T 246 Hex Uncommon Auraboa 80,000 T 247 Jester Rare Auraboa 600 G 248 Rosette Uncommon Auraboa 50,000 T 249 Edged Common Auraboa 60,000 T 250 Alloy Rare Auraboa 600 G 251 Riopa Uncommon Auraboa 92,500 T 252 Breakup Uncommon Auraboa 100,000 T 253 Weaver Limited Auraboa Baldwin 254 Paint Common Auraboa 82,500 T 255 Morph Limited Auraboa G&G 256 Diamondback Uncommon Auraboa 95,000 T 257 Current Uncommon Auraboa 82,500 T 258 Striation Common Auraboa 60,000 T 259 Stripes Common Auraboa 45,000 T 260 Hypnotic Uncommon Auraboa 92,500 T 261 Lacquer Uncommon Auraboa 85,000 T 262 Woven Rare Auraboa 600 G 263 Constellation Rare Auraboa 750 G[/code] [code]Batty Limited Auraboa Coliseum Crest Uncommon Auraboa 95,000 T Fishbone Uncommon Auraboa 95,000 T Branches Limited Auraboa Swipp Medusa Rare Auraboa 500 G Paradise Uncommon Auraboa 95,000 T Plumage Rare Auraboa 500 G Porcupine Limited Auraboa Baldwin Sailfin Rare Auraboa 500 G Scuttle Limited Auraboa Baldwin Stinger Uncommon Auraboa 110,000 T Terracotta Uncommon Auraboa 90,000 T Thorns Uncommon Auraboa 90,000 T Willow Uncommon Auraboa 92,500 T Underbelly Common Auraboa 75,000 T Capsule Limited Auraboa G&G Contour Common Auraboa 75,000 T Crackle Uncommon Auraboa 95,000 T Firefly Limited Auraboa G&G Firebreather Limited Auraboa G&G Keel Limited Auraboa G&G Koi Rare Auraboa 500 G Opal Rare Auraboa 500 G Peacock Common Auraboa 75,000 T Polkadot Limited Auraboa Coliseum Scales Limited Auraboa G&G Smoke Uncommon Auraboa 95,000 T Spines Uncommon Auraboa 95,000 T Stained Rare Auraboa 500 G Topcoat Uncommon Auraboa 82,500 T[/code] Unknown genes have been set to "uncommon" until proven otherwise~

@ChibiFluffy

I was having trouble with my Pairings tab, which I followed through to the ref_pairing_1 tab, which was coming up with a heap of errors. Upon investigation, it wasn't finding the ID using the ID's you had in column O, but I had a play and found the following formula extracted that in a way that works:

=ARRAYFORMULA(if(($O$2:$O$1501=""),"",VALUE(REGEXREPLACE(O2:O,"[^[:digit:]]", ""))))

Just thought I'd let you know :)

Oh, and thank you for the great tool, and for updating it so quickly!!

@Goldia hey! Can you send me a copy of your sheet ?
Using your formula breaks my sheet and I want to figure out what's different !

@ChibiFluffy ooh interesting.... will PM you