Guides

@Enkil an example sheet would be great! By hand should be working, it's weird that it is not

@ChibiFluffy
Another spreadsheet for me to obsessively fill out? Count me in! I'd like to be added to the pinglist.

@Luaii Happy to enable you :D

You've been added to the pinglist :)

New genes drop! Ill be updating the spreadsheet this week to add them :D

I seem to be having some trouble with the auto-filler and the pairings tab.

I'm using google chrome for these. I have left them both for at least 10 minutes, but nothing is happening.

The autofiller stays blank, and the pairing just give the #N/A. For the autofiller, I have done it from bottom up, from the biography to the user >> lair >> dragon. As for the pairings, I have put in my dragons data up to the RTB updated, plus the hatchday.

There also seems to be a problem with the dragons tab, the RTB and hibernal has a #VALUE! and missing data options.

Link to my sheets: https://docs.google.com/spreadsheets/d/150XQke1o_HEwcMqa5aVrDQW9GEhE85GitTEKL8Hfcx0/edit?usp=sharing
Pairings ss: https://imgur.com/ILeh0dp
Auto-filler ss: https://imgur.com/S8Ilhvc
Dragons ss: https://imgur.com/rSaISg6

@moonwhiskers hey!

The autofiller does not fill in the green parts, those are for you to edit :D
The bottom part (white) is what is being filled by the autofiller, and it seems fine.

The only thing I can see is that the dates in the dragons tab added for RTB are not formatted as dates.

You can check the note on the header for the RTB tab for how to change the format.
I'm pretty sure that should take care of it

@ChibiFluffy

Thank you, i have fixed it and it seems to be working now. Do you know how to fix the #N/A in the pairings tab that has this error message "Did not find value '29372707' in VLOOKUP evaluation." ?

@moonwhiskers Probably the same thing but for the ID column in the data's tab :D
The ID has to be changed to a text format to work !

My mistake it's the data tab and not the dragon tab that has the headers with the info on what format the columns should be *oops*

[center][img]http://puu.sh/s3htt/394c19cfe8.png[/img] [size=5][b]Super Lair Update - v.5.3[/b][/size] New genes!! To add the news genes to your own sheet, you have 3 options : 1) Add them to the "Primary Genes" and "Secondary Gene" columns in the hidden sheet "ref_info" Same thing for the "Census" tab. Everything else should update on its own! 2) If you don't want to add them manually you can also copy the tabs from the new spreadsheet to your own, delete the old one and rename the new one. 3) copy the data info to the new spreadsheet [size=5][url=https://docs.google.com/spreadsheets/d/12l-MG6VCHaxxeffio5BgzzeK431in1X_ZWU7xfMnXLA/edit?usp=sharing]Super Lair in action[/url] [url=https://docs.google.com/spreadsheets/d/1JpUX_VMtWHg_tSlQbuFL4LaJ-4jDlC2R2eb5CG0quHw/edit?usp=sharing]Blank version[/url][/size] Updates : [LIST] [*] add Tide (Primary, 114, Limited, Modern, Arlo) and Foam (Secondary, 113, Limited, Modern, Arlo) to ref_info and census tabs [/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 @bubbaberriboo @Luaii [/size] [img]http://puu.sh/s3huw/7d48e82a1a.png[/img][/center]

Thanks so much for your work on this, ChibiFluffy. Also, saying how to add the new genes was also super helpful. I wasn't looking forward to copying everything to a new sheet again. lol