[center][img]http://puu.sh/s3htt/394c19cfe8.png[/img]
[size=5][b]Super Lair Update - v.4.1[/b][/size]
Hello all!
I've been working non stop to bring you a Super update!
[size=5][url=https://docs.google.com/spreadsheets/d/1hGyPPOdWV-bhQbWGJQzlUpTiS4uzjzURndhk7ockFFM/edit?usp=sharing]Super Lair in action[/url]
[url=https://docs.google.com/spreadsheets/d/1sDV7ekeoG0xOrT4Pugq3Uwj9r5OhtworFxmZq_u1MrA/edit?usp=sharing]Blank version[/url][/size]
[color=red][u]If you decide to keep your own spreadsheet, you'll need to :[/u][/color]
Replace tabs "Projects" and "Refs"
Copy over tabs "RPP", "RPS" and "RPT"
You can go [url=https://www1.flightrising.com/forums/gde/3128487/1#post_51016579]HERE[/url] to get a how-to
[i]DO NOT copy the cells from the new spreadsheet, copy the whole tab. [/i]
[/center]
[b]List of updates[/b]
[LIST]
[*]Major changes to Refs and Projects tabs
[*]Minor changes to Welcome, Lair and Data tabs
[*]Added tabs RPP, RPS and RPT tabs (references for Projects tab)
[*]Added all missing genes in refs tab
[*]Added all missing breeds in refs tab
[*]Thank to @hat17 for their copy of the spreadsheet with an updated list of genes and prices!
[*]Updated all prices and rarity of genes
[*]Thanks to @DarkPuffin for their [url=https://www1.flightrising.com/forums/gde/3109561]Breeding Rarity[/url] thread!
[*]Moved gene/breed prices from projects tab to refs tab
[*]Fixed ancient vs modern genes in projects tab
[*]Made gene dropdowns that change depending on selected breed in projects tab
[*]Added eye type changes to projects tab
[*]Added missing breed colors in Lair tab
[/LIST]
[center][img]http://puu.sh/s3hWm/c0591abcfc.png[/img]
[size=1]@Alexstrasza @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 @ilimati @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 @Mollusc @Kelaku @Tephis @eridenthe @caddyshack @Plaguebringer21 @Atrodei[/size]
[img]http://puu.sh/s3huw/7d48e82a1a.png[/img][/center]
Super Lair Update - v.4.1
Hello all!
I've been working non stop to bring you a Super update!
Super Lair in action
Blank version
If you decide to keep your own spreadsheet, you'll need to :
Replace tabs "Projects" and "Refs"
Copy over tabs "RPP", "RPS" and "RPT"
You can go
HERE to get a how-to
DO NOT copy the cells from the new spreadsheet, copy the whole tab.
List of updates
- Major changes to Refs and Projects tabs
- Minor changes to Welcome, Lair and Data tabs
- Added tabs RPP, RPS and RPT tabs (references for Projects tab)
- Added all missing genes in refs tab
- Added all missing breeds in refs tab
- Thank to @hat17 for their copy of the spreadsheet with an updated list of genes and prices!
- Updated all prices and rarity of genes
- Thanks to @DarkPuffin for their Breeding Rarity thread!
- Moved gene/breed prices from projects tab to refs tab
- Fixed ancient vs modern genes in projects tab
- Made gene dropdowns that change depending on selected breed in projects tab
- Added eye type changes to projects tab
- Added missing breed colors in Lair tab
@ChibiFluffy oh!! so before you took over, on my personal sheet i edited how the average size stuff was done on the lair census page in order to make it easier when new ones were added![quote name="Pachirisu" date="2021-06-17 18:10:41" ]
i've updated my 3.91 version, and am moving to a copy of the 4.0 but keeping some of the changes i've made
the lair census tab in 4.0 hasn't been updated for veilspun, and my personal copy has a slightly easier way to update the size section when adding in new dragons
basically i just replaced the [code]=AVERAGEIFS('Lair Misc'!K:K, Lair!F:F, "Obelisk")[/code] to be [code]=AVERAGEIFS('Lair Misc'!K:K, Lair!F:F, M47)[/code] where "M47" is just the name of the little section, so i can copy and paste the new one in and just change the title and that automatically fixes the formulas
i did the same under "breed" in that section, so i can just drag the formula down when adding a new breed, the eye types, and all three genes sections.
those aren't necessary changes, of course, but i found them invaluable when needing to add new things to that tab.
ETA: looking at the food tab (which i never look at lol), you could do the same there in the breeds section as well!
[/quote]
it looks like the breed/eyes/genes bit was changed already, too, which is nice!
ETA: i also added a chart for eye types! (and pharaoh, sarcophagus, and koi aren't on the 4.1 sheet lair census tab, idk if there are more or not, i have fairly limited genes in my lair lol)
@
ChibiFluffy oh!! so before you took over, on my personal sheet i edited how the average size stuff was done on the lair census page in order to make it easier when new ones were added!
Pachirisu wrote on 2021-06-17 18:10:41:
i've updated my 3.91 version, and am moving to a copy of the 4.0 but keeping some of the changes i've made
the lair census tab in 4.0 hasn't been updated for veilspun, and my personal copy has a slightly easier way to update the size section when adding in new dragons
basically i just replaced the
Code:
=AVERAGEIFS('Lair Misc'!K:K, Lair!F:F, "Obelisk")
to be
Code:
=AVERAGEIFS('Lair Misc'!K:K, Lair!F:F, M47)
where "M47" is just the name of the little section, so i can copy and paste the new one in and just change the title and that automatically fixes the formulas
i did the same under "breed" in that section, so i can just drag the formula down when adding a new breed, the eye types, and all three genes sections.
those aren't necessary changes, of course, but i found them invaluable when needing to add new things to that tab.
ETA: looking at the food tab (which i never look at lol), you could do the same there in the breeds section as well!
it looks like the breed/eyes/genes bit was changed already, too, which is nice!
ETA: i also added a chart for eye types! (and pharaoh, sarcophagus, and koi aren't on the 4.1 sheet lair census tab, idk if there are more or not, i have fairly limited genes in my lair lol)
@
Pachirisu
Oooh thanks for the feedback!!
I tried to update the formulas as I was going but at some point I just add to at least have something up with most of it working and then fix whatever was left later.
I didn't even notice it didn't update the census or food chart, I forgot to add ancients to my testing dragons ;;
I'll have a fix later today :)
It'll make it a lot easier if I update it now, instead of waiting and forgetting about it ;)
Work hard now to work less later!
Would you share your additionnal charts ?
I have yet to check how those work, didn't really think about adding more...
(a lot of genes will be missing, at least 10 per gene pool, I'll have to figure that out)
@
Pachirisu
Oooh thanks for the feedback!!
I tried to update the formulas as I was going but at some point I just add to at least have something up with most of it working and then fix whatever was left later.
I didn't even notice it didn't update the census or food chart, I forgot to add ancients to my testing dragons ;;
I'll have a fix later today :)
It'll make it a lot easier if I update it now, instead of waiting and forgetting about it ;)
Work hard now to work less later!
Would you share your additionnal charts ?
I have yet to check how those work, didn't really think about adding more...
(a lot of genes will be missing, at least 10 per gene pool, I'll have to figure that out)
I'm ttrying to figure out the food calculator....
It's so complicated and everything is hardcoded when there should be a way to calculate everything automatically *thinking cap on*
I'm ttrying to figure out the food calculator....
It's so complicated and everything is hardcoded when there should be a way to calculate everything automatically *thinking cap on*
@
Alexstrasza Thanks for the heads-up! I made the corrections, you won't be pingned after this one :D
@
Alexstrasza Thanks for the heads-up! I made the corrections, you won't be pingned after this one :D
Thank you! Have fun managing this project, it looks like a great community resource.
Thank you! Have fun managing this project, it looks like a great community resource.
@
ChibiFluffy oh sure! i will DM you the link to my sheet, with temporary edit access
@
ChibiFluffy oh sure! i will DM you the link to my sheet, with temporary edit access
If anyone's interested, here's a preview of v5 of the Spreadsheet :
Semi-Automatic data filler
@ChibiFluffy
Could I be put on the pinglist please? :)
A few things I noticed ::
[list]The data table seems to be labeling pastel eyes as 'bright' when generating info from the scry image link.
The Lair Census sheet also seems to be dropping dragons from the total dragon count/breed rarity reports. (ex: reporting only 23 dragons total when 25 have been entered) The breed numbers and G1/nonG1 counts are tallying correctly though. [/list]
Thank you SO so much for taking this on - I'm so excited to see it being updated!
@
ChibiFluffy
Could I be put on the pinglist please? :)
A few things I noticed ::
The data table seems to be labeling pastel eyes as 'bright' when generating info from the scry image link.
The Lair Census sheet also seems to be dropping dragons from the total dragon count/breed rarity reports. (ex: reporting only 23 dragons total when 25 have been entered) The breed numbers and G1/nonG1 counts are tallying correctly though.
Thank you SO so much for taking this on - I'm so excited to see it being updated!