The question you are trying to answer is: In what future month will a new breed of rabbits to exceed the human population 2:1? There are a few moving pieces:
1) We will start with 1 female and 1 male rabbit born today (0 months old)
2) Each month, each female produces a litter of 4 bunnies: 1 male and 3 females
3) A female cannot start to reproduce until she has matured to 4 months of age
4) All rabbits live only to 24 months in age. (Alive months 0-23, die on the start of the 24th month)
Don't forget human population grows too! Assume a 0.058% month over month human population growth!
1
1
0
2018-07-02
326766748
D:\Alteryx Temp Dir\Engine\Engine_35084_a8e4c6a7e66f408d8ad8fc635705ba6c_\Engine_25448_dc98c395c26d491e8bbb2190219ebf85_.yxdb
Single
Profile
D:\Alteryx Temp Dir\Engine\Engine_35084_a8e4c6a7e66f408d8ad8fc635705ba6c_\Engine_25448_7b239baa052c4194a5263f0037f00c03_.yxdb
Single
Profile
2022-08-02
785219160
336183889
Date
RowCount
Int32
4
[Date]
[Date] <= '2023-12-31'
DateTimeAdd([Date],1,'month')
D:\Alteryx Temp Dir\Engine\Engine_35084_a8e4c6a7e66f408d8ad8fc635705ba6c_\Engine_25448_b7bbf0d499a94cb3a544f3d9783acf27_.yxdb
Single
Profile
Human Pop
Human Pop Growth
Int32
4
Empty
If [date]='2018-07-02' then [Human Pop] else [Row-1:Human Pop Growth]*1.00058 endif
If [date]='2018-07-02' then [Human Pop] else [Row-1:Human Pop...
MalePop
FemGrow
Int64
8
Empty
If [date]='2018-07-02' then 1 else
(([Row-5:FemGrow])-([Row-24:FemGrow]))*3+
([Row-1:FemGrow]-[Row-24:FemGrow]) endif
If [date]='2018-07-02' then 1 else
(([Row-5:FemGrow])-([Row-...
MalePop
MalGrow
FixedDecimal
50.1
Empty
If [date]='2018-07-02' then 1 else
(([Row-5:FemGrow])-([Row-24:FemGrow]))*1+
([Row-1:MalGrow]-[Row-24:MalGrow]) endif
If [date]='2018-07-02' then 1 else
(([Row-5:FemGrow])-([Row-...
Rabbits = [FemGrow]+[MalGrow]
Rabbit Earth = if [Rabbits]>2*[Human Pop Growth] t...
Horizontal
challenge_123_MT_Solution