{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["model","output"],"not_rendered":{"charts":4,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"model","index":0,"n_rows":91,"n_cols":45,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Parameter description",null,"value","unit","symbol"]
["Simulation details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Deer density (km-2)","Deer Tb prev.","Possum density (km-2)","Possum Tb prev.","Prop. poss ctrl","Density dead Tb deer (km-2)",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Area of simulation",null,900,"km2","a",null,null,null,null,"Plot output?",0,null,null,null,null,null,null,null,null,0,{"$f":"C10","v":12},{"$f":"SUMPRODUCT(C13:Q14,C17:Q18)","v":0.35369999999999996},{"$f":"C19","v":650},{"$f":"C20","v":2.5000000000000001E-2},null,null,null,null,null,null,7.0967741935483872E-2,0.24166666666666667,0.38033635187580855,0.44867549668874174,0.47132616487455198,0.49793388429752067,0.39650872817955113,0.38753387533875339,0.32753623188405795,0.32283464566929132,0.34453781512605042,0.21138211382113822,0.27397260273972601,0.35483870967741937,0.39130434782608697]
["Deer carrying capacity",null,20,"km-2","Kd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7.8033333333333337,0.37790118183112631,32.553689072991375,2.4874917943034459E-2,0.95,0.88111111111111107,null,null,null,null,0.08,0.29566563467492263,0.45983935742971888,0.57181571815718157,0.58131487889273359,0.55384615384615388,0.46363636363636362,0.47668393782383417,0.36184210526315791,0.39455782312925169,0.30508474576271188,0.36170212765957449,0.4,0.25,0.41176470588235292]
["Possum carrying capacity",null,670,"km-2","Kp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,8.1788888888888884,0.2605624235837522,39.135065364737017,9.4700213886375374E-3,0,0.56333333333333335]
["Years to run for",null,20,"yr","Ymax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,8.4088888888888889,0.18657505285412262,47.511644875238893,3.7388612741200613E-3,0,0.36444444444444446]
["Number of replicates",null,20,"-","m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,8.6266666666666669,0.12841318907779495,57.889574552971034,1.5478818722197928E-3,0,0.3322222222222222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,8.9122222222222227,8.7021568382994643E-2,70.628690621083862,6.8574901697423705E-4,0,0.23555555555555555]
["Initial conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,9.1488888888888891,5.6958950692251639E-2,12.931272497693339,3.1941681219008081E-4,0.85,0.18555555555555556]
["Overall deer population density",null,12,"km-2","N0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,9.5044444444444451,3.7175590367079729E-2,15.791080164725276,1.0543503049700739E-4,0,0.11333333333333333]
["Initial age-sex distribution",null,"Age yrs>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,9.8555555555555561,2.1195039458850057E-2,19.285932917424137,0,0,0.11222222222222222]
[" of deer population","Sex↓",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+",null,null,9,10.205555555555556,1.1758301578660859E-2,23.55494151456508,0,0,7.7777777777777779E-2]
[null,"Females",0.1,0.06,0.05,0.05,0.05,0.05,0.05,0.03,0.03,0.03,0.02,0.02,0.01,0.01,0.01,null,null,10,10.504444444444445,6.6638459911148723E-3,28.769820504999057,0,0,4.2222222222222223E-2]
[null,"Males",0.1,0.06,0.05,0.05,0.04,0.04,0.03,0.03,0.02,0.01,0,0,0,0,0,{"$f":"SUM(C13:Q14)","v":1.0000000000000002},null,11,10.871111111111111,2.5551921504497139E-3,5.2708472531563801,0,0.85,3.5555555555555556E-2]
["Initial deer Tb prevalence ",null,"Age yrs>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,11.28888888888889,1.3779527559055118E-3,6.4378267459636005,0,0,8.8888888888888889E-3]
[null,"Sex↓",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+",null,null,13,11.442222222222222,5.8263740532142161E-4,7.8631779489250624,0,0,7.7777777777777776E-3]
[null,"Females",0.05,0.25,0.35,0.47,0.51,0.48,0.48,0.39,0.39,0.38,0.32,0.24,0.28999999999999998,0.3,0.23,null,null,14,11.767777777777777,2.8325937116419601E-4,9.6041041297554326,0,0,2.2222222222222222E-3]
[null,"Males",0.05,0.3,0.43,0.62,0.63,0.56000000000000005,0.49,0.49,0.43,0.39,0.28999999999999998,0.39,0.39,0.38,0.33,null,null,15,12.034444444444444,1.8465515649524513E-4,11.730472363521999,0,0,1.1111111111111111E-3]
["Initial possum density",null,650,"km-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,12.201111111111111,0,14.327615920392693,0,0,1.1111111111111111E-3]
["Initial possum Tb prevalence",null,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,12.307777777777778,0,17.499755376740584,0,0,1.1111111111111111E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,12.35,0,21.37417331293468,0,0,0]
["Deer transition probabilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,12.524444444444445,0,26.106304718031893,0,0,0]
["Sex ratio at birth (prop. female)",null,0.5,"-","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,12.495555555555555,0,31.885935325571371,0,0,0]
["Strength of density-dependence on juevniles      (0-1 years)",null,0.45,"-","dj"]
["Strength of density-dependence on adults         (≥2 years)",null,0.1,"-","da"]
["Maximum fecundity per female per annum",null,"var","yr-1","fage"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"fage",0,0.7,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.92,0.92,0.92,0.92,0.92,0.92]
["Maximum proportional survival from \"natural\" mortality events per annum"]
["Females",null,"var","yr-1","sF,age"]
[{"$f":"1/A32","v":4.3178575809441995},"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[{"$f":"-LN(PRODUCT(C32:R32))/16","v":0.23159633713100072},"sF,age",0.8,0.95,0.99,0.99,0.99,0.99,0.97,0.96,0.95,0.94,0.9,0.6,0.6,0.5,0.5,0.5]
["Males",null,"var","yr-1","sM,age"]
[{"$f":"1/A35","v":3.9531329437932992},"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[{"$f":"-LN(PRODUCT(C35:R35))/16","v":0.25296391854720479},"sM,age",0.8,0.85,0.89,0.95,0.97,0.97,0.96,0.95,0.94,0.93,0.9,0.6,0.6,0.5,0.5,0.5]
["Proportional survival of deer if infected with Tb per annum (same for all ages and sexes)",null,0.96,"yr-1","si"]
["Proportion deer resolving Tb per annum (same for all ages and sexes)",null,0.12,"yr-1","v"]
["Possum to deer Tb transmission rate per annum"]
["Females",null,"var","yr-1","iF,age"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"iF,age",5.0000000000000001E-3,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.0999999999999999E-2,5.0000000000000001E-3,5.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
["Males",null,"var","yr-1","iM,age"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"iM,age",5.0000000000000001E-3,1.7000000000000001E-2,2.3E-2,2.4E-2,1.7000000000000001E-2,5.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
[]
["Spill back risk"]
["Instantaneous encounter rate of deer carcass by possum",null,0.01,"yr-1","α"]
["Probability of possum becoming infected given encounter with infected deer carcass",null,0.25,"-","b"]
["Probability of possum ",null,0]
["infected from carcass re-establishing Tb in possum population",null,0.5,{"$f":"IF($C$49=0,\"not used\",\"-\")","v":"not used"},"w"]
[]
["Control variables"]
["Possum control"]
["Define possum control",null,0]
["Initial possum control year",null,1,{"$f":"IF($C$54=0,\"yr\",\"not used\")","v":"yr"}]
["Frequency of possum control",null,5,{"$f":"IF($C$54=0,\"yr\",\"not used\")","v":"yr"}]
["Final year of possum control",null,11,"yr"]
["Initial control efficacy (prop. killed)",null,0.95,{"$f":"IF($C$54=0,\"-\",\"not used\")","v":"-"},"pI"]
["Maintenance control efficacy",null,0.85,{"$f":"IF($C$54=0,\"-\",\"not used\")","v":"-"},"pM"]
["Non-target (deer) initial control efficacy",null,0.3,{"$f":"IF($C$54=0,\"-\",\"not used\")","v":"-"},"pID"]
["Non-target (deer) maint. control efficacy",null,0,{"$f":"IF($C$54=0,\"-\",\"not used\")","v":"-"},"pMD"]
["Possum initial control costs",null,3600,{"$f":"IF($C$54=2,\"not used\",\"$ yr-1,km-2\")","v":"$ yr-1,km-2"},"cPI"]
["Possum maintenance control costs",null,2000,{"$f":"IF($C$54=2,\"not used\",\"$ yr-1,km-2\")","v":"$ yr-1,km-2"},"cPM"]
["Deer control 1 - \"background\" control from ground hunting"]
["Proportional kill per annum"]
["Females",null,"var","yr-1","h1F,age"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"h1F,age",0.08,0.14399999999999999,7.1999999999999995E-2,6.4000000000000001E-2,5.6000000000000001E-2,4.8000000000000001E-2,0.04,3.2000000000000001E-2,2.4E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2]
["Males",null,"var","yr-1","h1M,age"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"h1M,age",0.08,0.22,0.18,0.128,0.112,7.1999999999999995E-2,0.05,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
["Proportion area controlled per operation",null,1,"-","pAD1"]
["Initial deer control year",null,1,"yr"]
["Frequency of deer control",null,1,"yr"]
["Final year of deer control",null,20,"yr"]
["Control costs",null,0,"$ yr-1 km-2","cD1"]
["Deer carcasses from control left in field?",null,1,"   -","z1"]
["Deer control 2 - \"targeted\" control"]
["Proportional kill per annum"]
["Females",null,"var","yr-1","h2F,age"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"h2F,age",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Males",null,"var","yr-1","h2M,age"]
[null,"Age yrs>",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,"15+"]
[null,"h2M,age",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Proportion area controlled per operation",null,1,"-","pAD2"]
["Initial deer control year",null,2,"yr"]
["Frequency of deer control",null,1,"yr"]
["Final year of deer control",null,6,"yr"]
["Control costs",null,700,"$ yr-1 km-2","cD2"]
["Deer carcasses from control left in field?",null,0,"   -","z2"]

{"sheet":"output","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Yrs to erad Tb from possums","No. possum ctrls","Cost possum controls ($)","Yrs to erad Tb from deer","No. deer controls","Cost deer controls ($)","No. spillback events post-initial possum control","No. spillback events post-Tb eradication from possums","Average deer density (km2)","Average possum density*  (km2)","* estimated post-initial possum control"]
["mean",{"$f":"AVERAGE(B$7:B$5006)","v":7},3,6840000,14.35,0,0,2.5,0.05,10.342688888888889,25.007843724199237]
["sd",{"$f":"IF(B4>1,STDEV(B$7:B$5006),\"\")","v":0},0,0,0.93330200448672973,0,0,1.3572417850765923,0.22360679774997896,9.001053725044858E-2,2.6602991791894803E-4]
["N",{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20},{"$f":"model!$C$7","v":20}]
["prop. reps Tb eradicated:",{"$f":"COUNTIF(B$7:B$5006,\"<=\"&model!$C$6)/B4","v":1},null,"prop. reps Tb eradicated:",{"$f":"COUNTIF(E$7:E$5006,\"<=\"&model!$C$6)/E4","v":1},null,null,"prop. reps spill-back occurred:",{"$f":"COUNTIF(I$7:I$5006,\">0\")/I4","v":0.05}]
["rep","Yrs to erad Tb from possums","No. possum ctrls","Cost possum controls ($)","Yrs to erad Tb from deer","No. deer controls","Cost deer controls ($)","No. spillback events post-initial possum control","No. spillback events post-Tb eradication from possums","Average deer density (km2)","Average possum density  (km2)"]
[1,7,3,6840000,14,0,0,0,0,10.422611111111109,25.008167006309172]
[2,7,3,6840000,16,0,0,3,0,10.458555555555556,25.007610947049777]
[3,7,3,6840000,14,0,0,4,0,10.341611111111114,25.008282717254822]
[4,7,3,6840000,13,0,0,1,0,10.395944444444446,25.00743722462202]
[5,7,3,6840000,14,0,0,2,0,10.248944444444446,25.007793307567301]
[6,7,3,6840000,13,0,0,3,0,10.491111111111111,25.008344330981096]
[7,7,3,6840000,13,0,0,2,0,10.334666666666667,25.008045266893099]
[8,7,3,6840000,14,0,0,2,1,10.411444444444445,25.007937401981799]
[9,7,3,6840000,16,0,0,2,0,10.333333333333332,25.007866550987732]
[10,7,3,6840000,15,0,0,3,0,10.316055555555554,25.007913398081939]
[11,7,3,6840000,14,0,0,3,0,10.227944444444443,25.007756060645583]
[12,7,3,6840000,16,0,0,1,0,10.303166666666666,25.007793793038147]
[13,7,3,6840000,14,0,0,2,0,10.312388888888888,25.007613208810618]
[14,7,3,6840000,15,0,0,2,0,10.42038888888889,25.008002331366431]
[15,7,3,6840000,14,0,0,3,0,10.272111111111112,25.007829722339558]
[16,7,3,6840000,14,0,0,4,0,10.256722222222225,25.007627542708811]
[17,7,3,6840000,14,0,0,6,0,10.317611111111111,25.008129036358657]
[18,7,3,6840000,14,0,0,4,0,10.280999999999997,25.007357102497004]
[19,7,3,6840000,15,0,0,2,0,10.186555555555554,25.007771275420037]
[20,7,3,6840000,15,0,0,1,0,10.52161111111111,25.007596259071139]