Skip to main content

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. 

 

 

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) nselect: Year-1]
  4. Opening balance (Lamb) = Closing balancenselect: Year-1]

 

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

Best,
Benoit


Reply