Spreadsheet: 599517d1543157763-ifs-formula-not-opening-in-eariler-version-need-to-amend-formula-help-test-7-
Sheet: New Workings

 |  |  |  |  |  |  |  |  |  |  |  | TERRESTRIAL
 | Lizards |  |  |  | Arboreal Lizards |  |  |  | Your vivarium area is |  | % away from target | THRESHOLD |  |  | Messages
 |  |  |  |  |  |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Lizard.
 | SVL |  |  |  | SVL |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | QTY |  |  |  | QTY |  |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | Density Cage Size Multiple |  |  |  | Density Cage Size Multiple
 |  |  |  |  |  |  |  |  |  |  |  | ARBOREAL
 | Length Multiple |  | 4 |  | Height Multiple |  | 4 |  | Your vivarium area is |  | % away from target | THRESHOLD |  |  | Messages
 | Depth Multiple |  | 2.5 |  | Depth Multiple |  | 2.5 |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Lizard.
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | No | Your wall surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Calculated Length |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | Calculated Width |  |  |  | Calculcated Height
 |  |  |  |  | Calculated Depth |  |  |  | Minimum
 | Area Square CM |  |  |  | Calculted Width |  |  |  | Height | 80
 |  |  |  |  |  |  |  |  | [NAME] | 27
 |  |  |  |  | Back wall cm2
 | Snakes |  |  |  | Arboreal Snakes
 | STL |  |  |  | STL |  |  |  |  |  |  | TERRESTRIAL
 | QTY |  |  |  | QTY |  |  |  | Your vivarium area is |  | % away from target | THRESHOLD |  |  | Messages
 | Density Cage Size Multiple |  |  |  | Density Cage Size Multiple |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Snake.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Length Multiple |  | 0.6666666 |  | Height Multiple |  | 0.666666 |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | [NAME] |  | 0.3333333 |  | Depth Multiple |  | 0.333333
 |  |  |  |  | [NAME] |  |  |  |  |  |  | TERRESTRIAL
 | Calculated Length |  |  |  |  |  |  |  | Your vivarium area is |  | % away from target | THRESHOLD |  |  | Messages
 | Calculated Width |  |  |  | Calculcated Height |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Snake.
 |  |  |  |  | Calculated Depth |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Area Square CM |  |  |  | Calculted Width |  |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 |  |  |  |  | Back wall cm2
 | Frogs & Toads
 | SVL
 | QTY
 | Density Cage Size Multiple
 | Stocking Density |  | 4
 | Square CM per Max Density per Frog |  |  |  |  |  |  |  |  |  |  | TERRESTRIAL
 | Water depth multiple |  | 2 |  |  |  |  |  | Your vivarium area is |  | % away from target | THRESHOLD |  |  | Messages
 | Length Multiple |  | 3 |  |  |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Frog or [NAME].
 | [NAME] |  | 3 |  |  |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Height Multiple |  | 3 |  |  |  |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | Calculated Length
 | Calculated Width
 | Calculated Height
 | Minimum Square cm |  | 900
 | Area Square CM
 | Used Square CM
 | Minimum Length |  | 30
 | Minimum Width |  | 30
 | Minimum Height |  | 30
 | Newts & Salamanders
 | SVL
 | QTY |  |  |  |  |  |  |  |  |  |  | TERRESTRIAL
 | Density Cage Size Multiple |  |  |  |  |  |  |  | Your vivarium area is |  | % away from target | THRESHOLD |  |  | Messages
 | Stocking Density |  | 4 |  |  |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your [NAME] or Salamander.
 | Square CM per Max Density per Newt |  |  |  |  |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Water depth multiple |  | 2 |  |  |  |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | Length Multiple |  | 3
 | [NAME] |  | 2
 | Height Multiple |  | 3
 | Calculated Length
 | Calculated Width
 | Calculated Height
 | Minimum Square cm |  | 900
 | Area Square CM
 | Used Square CM
 | Minimum Length |  | 30
 | Minimum Width |  | 30
 | Minimum Height |  | 30
 | Aquatic Turtles
 | SCL
 | [NAME]
 | QTY
 | Density Cage Size Multiple
 | Stocking Density |  | 4
 | Water depth multiple |  | 2
 | Length Multiple |  | 5
 | [NAME] |  | 3
 | Water Height Multiple |  | 4
 | Calculated Length
 | Calculated Width |  |  |  | Mininum width based on 1 tortoise |  |  |  | Calculated width as minimum based on 1 turtle, or 0 if trips over to area
 | Calculated Water Height
 |  |  |  |  | Your vivarium area is |  | % away from target |  | THRESHOLD |  |  | Messages
 | Area Square CM |  |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Aquatic Turtle.
 |  |  |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Minimum Length |  | 90 |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | Tortoises
 | SCL
 | QTY
 | Density Cage Size Multiple
 | Stocking Density |  | 4 |  | Your vivarium area is |  | % away from target |  | THRESHOLD |  |  | Messages
 |  |  |  |  |  |  |  |  | -0.15 |  | Close | Your terrarium is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Tortoise.
 |  |  |  |  |  |  |  |  |  |  | No | Your surface area is not large enough to comply with AAL Guidelines, please increase your terrarium size.
 | Length Multiple |  | 5 |  |  |  |  |  |  |  | Yes | Good news, your terrarium is suitable!
 | [NAME] |  | 5
 | Calculated Length
 | Calculated Width |  |  |  | Mininum width based on 1 tortoise |  |  |  | Calculated width as minimum based on 1 tortoise, or 0 if trips over to area
 | Area Square CM
 | Minimum Length |  | 90
 | Crocodilians
 | SVL
 | QTY
 | Density Cage Size Multiple |  |  |  | Land area |  | % away from target |  | THRESHOLD |  |  | Messages
 | Stocking Density |  | 4 |  |  |  |  |  | -0.15 |  | Close | Your land area is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Crocodilian.
 |  |  |  |  |  |  |  |  |  |  | No | Your land area is not large enough to comply with AAL Guidelines, please increase your land area size.
 | Water depth multiple |  | 0.3 |  |  |  |  |  |  |  | Yes | Good news, your land area is suitable!
 | Land Length Multiple |  | 2
 | Water Length Multiple |  | 2.5 |  | Water area |  | % away from target |  | THRESHOLD |  |  | Messages
 | Land Width Multiple |  | 1.5 |  |  |  |  |  | -0.15 |  | Close | Your water area is slightly smaller than the recommended minimum enclosure size. This should not affect the welfare of your Crocodilian.
 | Water Width Multiple |  | 2 |  |  |  |  |  |  |  | No | Your water area is not large enough to comply with AAL Guidelines, please increase your water area size.
 |  |  |  |  |  |  |  |  |  |  | Yes | Good news, your water area is suitable!
 | Calculated Water depth
 | Calculated Land Length
 | Calculated Water Length
 | Calculated Land Width
 | Calculated Water Width
 | Land Area Square CM
 | Water Area Square CM