Solved

Inventory of animals - possible circular reference.

  • 17 August 2023
  • 1 reply
  • 66 views

Userlevel 1

I am modelling the flock of sheep over a period of time.

The logic: 2023 sheep * lambing percentage = 2023 Lambs born

After one year the lambs born are added to flock of sheep. 2023 sheep + 2023 lambs

This is then multiplied by you lambing percentage to get you current year lambs births. 

(2023 sheep + 2023 lambs)*lambing percentage = 2024 Lambs

And this repeats for the following years. 

 

 

icon

Best answer by Benoit 17 August 2023, 12:27

View original

1 reply

Userlevel 6
Badge +12

Hi Angus,

I believe you can reverse the logic by starting from your output, I’ve just answered a similar question here:

 

You can transpose these calculation steps:

  1. Source input = the amount to start with
  2. Closing balance (Sheep) = previous(Year) + Source input + previous(Year)*Lambing rate
  3. Amortisation  = (Closing balance * Lambing rate) [select: Year-1]
  4. Opening balance (Lamb) = Closing balance[select: Year-1]

 

Please let me know if that helps getting your Sheep on their feet. 🐑

Best,
Benoit

Reply