Super Lair Update - v.5.4
Undertide is here!
New breeds are a pain to add, here is all you have to do to make it work ~
REF_INFO TAB (hidden)
Add to "Breed" : 21 Undertide Common Ancient Arlo
Add to Primary genes :
0 Basic Plentiful Undertide 10,000 T
113 Tide Limited Undertide Baldwin
114 Tide Limited Modern Arlo
115 Fade Common Undertide 62,500 T
116 Wolf Uncommon Undertide 80,000 T
117 Bar Uncommon Undertide 125,000 T
118 Crystal Rare Undertide 750 G
119 Cherub Uncommon Undertide 92,500 T
120 Pharaoh Rare Undertide 750 G
121 Pinstripe Limited Undertide Baldwin
122 Falcon Common Undertide 85,000 T
123 Giraffe Uncommon Undertide 112,500 T
124 Ribbon Uncommon Undertide 95,000 T
125 Wasp Rare Undertide 750 G
126 Lionfish Uncommon Undertide 125,000 T
127 Checkers Common Undertide 80,000 T
128 Boa Uncommon Undertide 85,000 T
129 Savannah Common Undertide 70,000 T
130 Ripple Uncommon Undertide 125,000 T
131 Poison Limited Undertide Baldwin
132 Speckle Common Undertide 62,500 T
133 Octopus Limited Undertide Baldwin
134 Swirl Common Undertide 75,000 T
135 Boulder Limited Undertide Baldwin
Add to Secondary genes :
0 Basic Plentiful Undertide 10,000 T
114 Foam Limited Undertide Baldwin
115 Blend Common Undertide 50,000 T
116 Pack Uncommon Undertide 70,000 T
117 Daub Common Undertide 82,500 T
118 Facet Rare Undertide 600 G
119 Seraph Uncommon Undertide 62,500 T
120 Sarcophagus Rare Undertide 600 G
121 Trail Limited Undertide Baldwin
122 Peregrine Common Undertide 70,000 T
123 Hex Uncommon Undertide 80,000 T
124 Eel Uncommon Undertide 77,500 T
125 Bee Rare Undertide 600 G
126 Noxtide Uncommon Undertide 85,000 T
127 Chess Common Undertide 80,000 T
128 Saddle Uncommon Undertide 75,000 T
129 Safari Common Undertide 49,000 T
130 Current Uncommon Undertide 82,500 T
131 Toxin Limited Undertide Baldwin
132 Freckle Common Undertide 45,000 T
133 Rings Limited Undertide Baldwin
Add to Tertiary genes :
0 Basic Plentiful Undertide 10,000 T
109 Underbelly Common Undertide 75,000 T
110 Stained Rare Undertide 500 G
111 Capsule Limited Undertide Baldwin
112 Flecks Uncommon Undertide Coliseum
113 Veined Limited Undertide Baldwin
114 Runes Limited Undertide 95,000 T
115 Crackle Uncommon Undertide 95,000 T
116 Filigree Rare Undertide 500 G
117 Circuit Rare Undertide 600 G
118 Featherbeard Limited Undertide Coli
119 Remora Rare Undertide 500 G
120 Ringlets Uncommon Undertide 77,500 T
121 Ghost Uncommon Undertide 80,000 T
122 Sparkle Uncommon Undertide 75,000 T
123 Gembond Limited Undertide 100,000 T
124 Soap Rare Undertide 600 G
125 Tentacles Rare Undertide 500 G
126 Nudibranch Limited Undertide Baldwin
127 Pufferfish Uncommon Undertide 80,000 T
128 Plating Uncommon Undertide 90,000 T
129 Okapi Uncommon Undertide 95,000 T
130 Sailfin Rare Undertide 500 G
Add to "Rarity Checker"
Add a new line for each Ancient for the new breed with "Cannot Breed 0 0"
Add new breed with a line for each Ancient with "Cannot Breed" and itself for 50%
Add to "Gene Lists"
Make new sections for "Primary Ancient Breed", "Secondary Ancient Breed" and "Tertiary Ancient Breed"
Change the formula to have the right breed name at the end :
Primary
Code:
=join(",",SORT(Filter(ref_info!$W$2:$W,ref_info!$Y$2:$Y="Undertide")))
Secondary
Code:
=join(",",SORT(Filter(ref_info!$AC$2:$AC,ref_info!$AE$2:$AE="Undertide")))
Tertiary
Code:
=join(",",SORT(Filter(ref_info!$AI$2:$AI,ref_info!$AK$2:$AK="Undertide")))
PROJECT TAB
Add to Breed dropdown : Select O:O column, unselect first 2 cells (CTRL+click), right-click > view more cell actions > Data Validation, Change Criteria to
Replace formulas (edit > find and replace > select "also search within formulas")
replace
Code:
H1501="Aberration")>0,ref_info!$AN27,""
by
Code:
H1501="Aberration")>0,ref_info!$AN27,if((Projects!$C$3:$C1501="Ancient")*(Projects!$H$3:$H1501="Undertide")>0,ref_info!$AN33,"")
replace
Code:
O1501="Aberration")>0,ref_info!$AN27,""
by
Code:
O1501="Aberration")>0,ref_info!$AN27,if((Projects!$D$3:$D1501="Ancient")*(Projects!$O$3:$O1501="Undertide")>0,ref_info!$AN33,"")
replace
Code:
H1501="Aberration")>0,ref_info!$AN29,""
by
Code:
H1501="Aberration")>0,ref_info!$AN29,if((Projects!$C$3:$C1501="Ancient")*(Projects!$H$3:$H1501="Undertide")>0,ref_info!$AN35,"")
replace
Code:
O1501="Aberration")>0,ref_info!$AN29,""
by
Code:
O1501="Aberration")>0,ref_info!$AN29,if((Projects!$C$3:$C1501="Ancient")*(Projects!$O$3:$O1501="Undertide")>0,ref_info!$AN35,"")
replace
Code:
H1501="Aberration")>0,ref_info!$AN31,""
by
Code:
H1501="Aberration")>0,ref_info!$AN31,if((Projects!$C$3:$C1501="Ancient")*(Projects!$H$3:$H1501="Undertide")>0,ref_info!$AN37,"")
replace
Code:
O1501="Aberration")>0,ref_info!$AN31,""
by
Code:
O1501="Aberration")>0,ref_info!$AN31,if((Projects!$C$3:$C1501="Ancient")*(Projects!$O$3:$O1501="Undertide")>0,ref_info!$AN37,"")
Replace the 3 formulas uinder "[...] Gene Cost Full Price", see thje white cell under the header for formula (it's too big for the post)
OTHER TABS
Add to census "Breed" statistics
Add to Food Calculator "Feeding Order" (and change "total" formula "=SUM(N3:N22)" )
Undertide food order is only as we wait for info. Seafood/Plants 10, that changes Imperial's Seafood/Plants order to 11
*Everything else should automatically follow*
Super Lair in action
Blank version
Updates :
- add Undertide breed and genes to Everything
- Corrected a lot of formulas so that next time a new Ancient breed comes up it doesn't take so much updating :D
- Correction to Pairings tab : Unmerged some cells to make it easier to copy/paste