A\1 | B | C | D | E | F | G | H | I | J | K | L | M |
2 | Mice | Hawks | Key | |||||||||
3 | Starting # | =PredPreydata!B2 | =PredPreydata!C2 | Yellow values are given | ||||||||
4 | Birth Rate | =PredPreydata!B3 | =PredPreydata!C3 | Blue values are calculated | ||||||||
5 | Death Rate | =PredPreydata!B4 | =PredPreydata!C4 | Red values can be manipulated. | ||||||||
6 | Diet | 0.5 | =PredPreydata!C5 | Green Values are totals. | ||||||||
7 | Safe Mice | 0.6 | ||||||||||
8 | Land | 50000 | ||||||||||
9 | MaxMice | =Land/MiceDiet | ||||||||||
10 | ||||||||||||
11 | Mice Population | Mice Born | Mice Die | Mice Starve | Mice Ava. | Mice to Hawk | Hawk Pop | Hawk Born | Hawk Die | Hawk Food | Mice Needed | Hawk Starve |
12 | =MiceStart | =B12*MiceBirth | =B12*MiceDeath | =IF((B12+C12)>MaxMiceFood,(B12+C12)-MaxMiceFood,0) | =(B12+C12)*(1-$C$7) | =IF(F12>L12,L12,F12) | =Hawkstart | =HawkBirth*H12 | =H12*HawkDeath | =F12/HawkDiet | =(H12+I12)*HawkDiet | =IF((H12+I12)>K12,(H12+I12)-K12,0) |
13 | =B12+C12-D12-E12-G12 | =B13*MiceBirth | =B13*MiceDeath | =IF((B13+C13)>MaxMiceFood,(B13+C13)-MaxMiceFood,0) | =(B13+C13)*(1-$C$7) | =IF(F13>L13,L13,F13) | =H12+I12-J12-M12 | =IF(H13>1,HawkBirth*H13,0) | =H13*HawkDeath | =F13/HawkDiet | =(H13+I13)*HawkDiet | =IF((H13+I13)>K13,(H13+I13)-K13,0) |
14 | =B13+C13-D13-E13-G13 | =B14*MiceBirth | =B14*MiceDeath | =IF((B14+C14)>MaxMiceFood,(B14+C14)-MaxMiceFood,0) | =(B14+C14)*(1-$C$7) | =IF(F14>L14,L14,F14) | =H13+I13-J13-M13 | =IF(H14>1,HawkBirth*H14,0) | =H14*HawkDeath | =F14/HawkDiet | =(H14+I14)*HawkDiet | =IF((H14+I14)>K14,(H14+I14)-K14,0) |
15 | =B14+C14-D14-E14-G14 | =B15*MiceBirth | =B15*MiceDeath | =IF((B15+C15)>MaxMiceFood,(B15+C15)-MaxMiceFood,0) | =(B15+C15)*(1-$C$7) | =IF(F15>L15,L15,F15) | =H14+I14-J14-M14 | =IF(H15>1,HawkBirth*H15,0) | =H15*HawkDeath | =F15/HawkDiet | =(H15+I15)*HawkDiet | =IF((H15+I15)>K15,(H15+I15)-K15,0) |
16 | =B15+C15-D15-E15-G15 | =B16*MiceBirth | =B16*MiceDeath | =IF((B16+C16)>MaxMiceFood,(B16+C16)-MaxMiceFood,0) | =(B16+C16)*(1-$C$7) | =IF(F16>L16,L16,F16) | =H15+I15-J15-M15 | =IF(H16>1,HawkBirth*H16,0) | =H16*HawkDeath | =F16/HawkDiet | =(H16+I16)*HawkDiet | =IF((H16+I16)>K16,(H16+I16)-K16,0) |
This table was created by a free Excel macro written by Charles Balch.
Here's the code. It is care ware - it's yours for free if do something nice for anyone (anyone includes you).