Found a minor bug in the excel formula DATAS sheet, cell Z2.
=IF(Y2=1,1,IF(Y2=2,2,IF(Y2<7,3,IF(Y2<12,4,IF(Y2<15,5,IF(Y2>15,6))))))
I changed to
=IF(Y2=1,1,IF(Y2=2,2,IF(Y2<7,3,IF(Y2<12,4,IF(Y2<15,5,IF(Y2=15,6,6))))))
Basically in your code if you hit exactly 15 critters it returns 1 for coefficient.
May want to add another row to the indexed table (DATAS!U1:W6) , say row 7, and have those coefficient be either 6,4,5 or something crazy like 10,6,8.
=IF(Y2=1,1,IF(Y2=2,2,IF(Y2<7,3,IF(Y2<12,4,IF(Y2<15,5,IF(Y2>15,6))))))
I changed to
=IF(Y2=1,1,IF(Y2=2,2,IF(Y2<7,3,IF(Y2<12,4,IF(Y2<15,5,IF(Y2=15,6,6))))))
Basically in your code if you hit exactly 15 critters it returns 1 for coefficient.
May want to add another row to the indexed table (DATAS!U1:W6) , say row 7, and have those coefficient be either 6,4,5 or something crazy like 10,6,8.
