{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Harvest models","Stochasticity"],"not_rendered":{"charts":9,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Harvest models","index":0,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,8]]}
["HARVEST MODELS -- FIXED QUOTA AND FIXED EFFORT",null,null,null,null,null,null,null,null,"Logistic growth model:",null,"MSY quota:","MSY effort:"]
[null,null,null,null,null,null,null,null,null,"Nt+1 = Nt + RNt * ((K - Nt) / K)",null,"ΔNt = (R * K) / 4","E = R / 2"]
["R =",0.5]
["K =",2000]
[null,"Unharvested",null,"Harvested"]
[null,null,null,"Fixed-quota","Q =",250,"Fixed-effort","E =",0.25]
[null,null,null,null,null,"Actual",null,null,"Actual"]
["Time","Nt","ΔNt","Nt","Quota","harvest","Nt","Effort line","harvest"]
[0,1,{"$f":"B10-B9","v":0.49975000000000014},{"$f":"$B$4","v":2000},{"$f":"$F$6","v":250},{"$f":"IF(D9>$F$6,$F$6,D9)","v":250},{"$f":"$B$4","v":2000},{"$f":"$I$6*B9","v":0.25},{"$f":"IF(G9>$I$6*G9,$I$6*G9,G9)","v":500}]
[1,{"$f":"B9+$B$3*B9*($B$4-B9)/$B$4","v":1.4997500000000001},{"$f":"B11-B10","v":0.74931268748437496}]
[2,{"$f":"B10+$B$3*B10*($B$4-B10)/$B$4","v":2.2490626874843751},1.1232667729991292]
[3,3.3723294604835043,1.6833215787442413]
[4,5.0556510392277456,2.5214356177562616]
[5,7.5770866569840072,3.7741902679401429]
[6,11.35127692492415,5.643425590505494]
[7,16.994702515429644,8.4251462793178362]
[8,25.41984879474748,12.548382219186784]
[9,37.968231013934265,18.623718865385264]
[10,56.591949879319529,27.495312741873917]
[11,84.087262621193446,40.275964376815324]
[12,124.36322699800877,58.315060441664826]
[13,182.6782874396736,82.996304544363824]
[14,265.67459198403742,115.19154878554752]
[15,380.86614076958494,154.16831608861321]
[16,535.03445685819815,195.95176092271231]
[17,730.98621778091047,231.90789624404511]
[18,962.89411402495557,249.65578830650179]
[19,1212.5499023314574,238.70563475472204]
[20,1451.2555370861794,199.09211006226587]
[21,1650.3476471484453,144.26198446212038]
[22,1794.6096316105657,92.148883337930329]
[23,1886.758514948496,53.414834041584527]
[24,1940.1733489900805,29.018518462194152]
[25,1969.1918674522747,15.166781016093182]
[26,1984.3586484683678,7.7595127963820687]
[27,1992.1181612647499,3.9253885221628479]
[28,1996.0435497869128,1.9743117319715111]
[29,1998.0178615188843,0.99008702231822099]
[30,1999.0079485412025,0.49577968787457394]
[31,1999.5037282290771,0.24807431404383351]
[32,1999.7518025431209,0.1240833279450726]
[33,1999.875885871066,6.2053213387798678E-2]
[34,1999.9379390844538,3.102949488379636E-2]
[35,1999.9689685793376,1.5515469593992748E-2]
[36,1999.9844840489316,7.7579153480655805E-3]
[37,1999.9922419642796,3.8790028133917076E-3]
[38,1999.996120967093,1.9395126917061134E-3]
[39,1999.9980604797847,9.6975916721930844E-4]
[40,1999.9990302389519,4.8488028892279544E-4]
[41,1999.9995151192409,2.4244032078968303E-4]
[42,1999.9997575595617,1.2122020439164771E-4]
[43,1999.999878779766,6.0610113223447115E-5]
[44,1999.9999393898793,3.0305059453894501E-5]
[45,1999.9999696949387,1.5152530295381439E-5]
[46,1999.999984847469,7.5762654887512326E-6]
[47,1999.9999924237345,3.7881327443756163E-6]
[48,1999.9999962118673,1.8940663721878082E-6]
[49,1999.9999981059336,{"$f":"B59-B58","v":9.4703318609390408E-7}]
[50,{"$f":"B58+$B$3*B58*($B$4-B58)/$B$4","v":1999.9999990529668},-1999.9999990529668]

{"sheet":"Stochasticity","index":1,"n_rows":110,"n_cols":52,"rows_kept":110,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,9]]}
["HARVEST MODELS -- INCORPORATING STOCHASTICITY"]
[]
[null,"Mean","SD"]
["R =",0.5,0.2]
["K =",2000]
[null,"Unharvested",null,"Harvested"]
[null,null,null,null,"Fixed-quota","Q =",250,"Fixed-effort","E =",0.25]
[null,null,null,null,null,null,"Actual",null,null,"Actual"]
["Time","Nt","ΔNt","Draw","Nt","Quota","harvest","Nt","Effort line","harvest"]
[0,1,{"$f":"B11-B10","v":0.49975000000000014},null,{"$f":"$B$5","v":2000},{"$f":"$G$7","v":250},{"$f":"IF(E10>$G$7,$G$7,E10)","v":250},{"$f":"$B$5","v":2000},{"$f":"$J$7*B10","v":0.25},{"$f":"IF(H10>$J$7*H10,$J$7*H10,H10)","v":500}]
[1,{"$f":"B10+$B$4*B10*($B$5-B10)/$B$5","v":1.4997500000000001},{"$f":"B12-B11","v":0.74931268748437496}]
[2,{"$f":"B11+$B$4*B11*($B$5-B11)/$B$5","v":2.2490626874843751},1.1232667729991292]
[3,3.3723294604835043,1.6833215787442413]
[4,5.0556510392277456,2.5214356177562616]
[5,7.5770866569840072,3.7741902679401429]
[6,11.35127692492415,5.643425590505494]
[7,16.994702515429644,8.4251462793178362]
[8,25.41984879474748,12.548382219186784]
[9,37.968231013934265,18.623718865385264]
[10,56.591949879319529,27.495312741873917]
[11,84.087262621193446,40.275964376815324]
[12,124.36322699800877,58.315060441664826]
[13,182.6782874396736,82.996304544363824]
[14,265.67459198403742,115.19154878554752]
[15,380.86614076958494,154.16831608861321]
[16,535.03445685819815,195.95176092271231]
[17,730.98621778091047,231.90789624404511]
[18,962.89411402495557,249.65578830650179]
[19,1212.5499023314574,238.70563475472204]
[20,1451.2555370861794,199.09211006226587]
[21,1650.3476471484453,144.26198446212038]
[22,1794.6096316105657,92.148883337930329]
[23,1886.758514948496,53.414834041584527]
[24,1940.1733489900805,29.018518462194152]
[25,1969.1918674522747,15.166781016093182]
[26,1984.3586484683678,7.7595127963820687]
[27,1992.1181612647499,3.9253885221628479]
[28,1996.0435497869128,1.9743117319715111]
[29,1998.0178615188843,0.99008702231822099]
[30,1999.0079485412025,0.49577968787457394]
[31,1999.5037282290771,0.24807431404383351]
[32,1999.7518025431209,0.1240833279450726]
[33,1999.875885871066,6.2053213387798678E-2]
[34,1999.9379390844538,3.102949488379636E-2]
[35,1999.9689685793376,1.5515469593992748E-2]
[36,1999.9844840489316,7.7579153480655805E-3]
[37,1999.9922419642796,3.8790028133917076E-3]
[38,1999.996120967093,1.9395126917061134E-3]
[39,1999.9980604797847,9.6975916721930844E-4]
[40,1999.9990302389519,4.8488028892279544E-4]
[41,1999.9995151192409,2.4244032078968303E-4]
[42,1999.9997575595617,1.2122020439164771E-4]
[43,1999.999878779766,6.0610113223447115E-5]
[44,1999.9999393898793,3.0305059453894501E-5]
[45,1999.9999696949387,1.5152530295381439E-5]
[46,1999.999984847469,7.5762654887512326E-6]
[47,1999.9999924237345,3.7881327443756163E-6]
[48,1999.9999962118673,1.8940663721878082E-6]
[49,1999.9999981059336,9.4703318609390408E-7]
[50,1999.9999990529668,-1999.9999990529668]
[]
["Quota","Time"]
["Trial",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
["Mean"]
["SD"]
[]
["Effort","Time"]
["Trial",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
["Mean"]
["SD"]