A\1
A\1BCDEFGHIJKLM
2
MiceHawks





Key
3Starting #=PredPreydata!B2=PredPreydata!C2





Yellow values are given
4Birth Rate=PredPreydata!B3=PredPreydata!C3





Blue values are calculated
5Death Rate=PredPreydata!B4=PredPreydata!C4





Red values can be manipulated.
6Diet0.5=PredPreydata!C5





Green Values are totals.
7Safe Mice0.6









8Land50000









9MaxMice=Land/MiceDiet









10











11Mice PopulationMice BornMice DieMice StarveMice Ava.Mice to HawkHawk PopHawk BornHawk DieHawk FoodMice NeededHawk 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).