{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Fig.7-4"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":4,"defined_names":50,"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":"Fig.7-4","index":0,"n_rows":85,"n_cols":18,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Bban",null,"Blimit",null,"Indicators","Minimum stock","Minimum catch","# fishing ban ","N<Nlimit",null,"Catch (long term)"]
["ｒ","K","σｒ","ρ autocorelation","σe measurement errors",null,"σc process errors",200,{"$f":"H2","v":200},700,2000,null,{"$f":"MIN(B6:B101)","v":370.96243697049567},{"$f":"MIN(E6:E101)","v":36.73455825358846},{"$f":"COUNTIF(E6:E106,0)","v":0},{"$f":"COUNTIF(D6:D71,\"<\"&J3)","v":50},"Cave",{"$f":"AVERAGE(E6:E75)","v":155.23077852332395}]
[0.5,1000,1,0.7,0.3,0.1,"Flimit",0,{"$f":"J3*I2/J2","v":0.1},0.35,{"$f":"J3","v":0.35},null,300,20,0,null,"Csd",{"$f":"STDEV(E6:E75)","v":69.37568371328193}]
[null,null,null,null,null,null,"Ftarget",{"$f":"H3*0.8","v":0},{"$f":"I3*0.8","v":8.0000000000000016E-2},{"$f":"J3*0.8","v":0.27999999999999997},{"$f":"K3*0.8","v":0.27999999999999997},"Risk that indicators does not satiffy the target",8,30,1,100,"# trials",100]
["ｔ","N Stock abundance","Ñ Estimated stock abundance","F fishing coefficient","C catch amount",null,null,{"$f":"A3/B3","v":5.0000000000000001E-4}]
[0,500,{"$f":"B6*(1-E$3+2*RAND()*E$3)","v":421.29116791355159},{"$f":"IF(C6<H$2,0,IF(C6<J$2,(J$3*(C6-H$2)/(J$2-H$2)),J$3))","v":0.15490381753948612},{"$f":"B6*D6*(1-F$3+2*RAND()*F$3)","v":74.398093234369838},{"$f":"(A$3*(1-C$3+2*RAND()*C$3))","v":0.96879849202427792}]
[{"$f":"A6+1","v":1},{"$f":"(B6-E6)*EXP(F7-(B6-E6)*H$5)","v":700.02346263129664},853.82672079109784,0.35,221.86795516632122,{"$f":"D$3*F6+(1-D$3)*(A$3*(1-C$3+2*RAND()*C$3))","v":0.71041038770941178}]
[{"$f":"A7+1","v":2},824.94747553636648,657.84593103810914,0.32049215172667633,288.87089932783488,0.78446146301592812]
[3,818.10308448901787,638.65752365970047,0.30706026656179031,254.59229677781011,0.69074961999775186]
[4,693.6128343018928,706.00588540134947,0.35,233.86005877142114,0.48948284563035055]
[5,573.32922479230353,683.00709163551824,0.33810496414486274,205.92539277631067,0.45064760230990875]
[6,535.0069886035543,680.81210707384378,0.33656847495169062,166.56476288037462,0.55952012280991203]
[7,577.90005743738868,451.16327175005176,0.17581429022503622,98.448192109638413,0.63433813853541521]
[8,723.29852251859347,731.57526928245238,0.35,257.91994343322051,0.65090445967233546]
[9,625.75663056346718,778.7561960750287,0.35,231.88518733525459,0.52879959306567881]
[10,491.19341970939598,604.5152879092916,0.28316070153650413,139.01336781592465,0.41774913216802256]
[11,396.63553238715946,450.7924142165769,0.17555468995160381,63.722648133906368,0.29496527464154038]
[12,380.17339123367418,386.34725808493101,0.1304430806594517,52.181914465951145,0.29920303659159653]
[13,402.53837600232407,501.58813500851318,0.21111169450595921,80.241955239561818,0.36879855222041563]
[14,370.96243697049567,380.47451898976323,0.12633216329283425,48.791128892587878,0.30177733634224002]
[15,384.10732831411008,374.5368177627451,0.12217577243392157,42.686764597349054,0.33692425165144502]
[16,433.77872117186843,362.20559662683479,0.11354391763878435,45.41522696617028,0.41012978483949913]
[17,495.68353354107199,517.58894023472658,0.22231225816430858,106.72927764069713,0.43817769118161737]
[18,505.876566127616,413.02087839551177,0.14911461487685823,73.012458249271944,0.45730808440280302]
[19,558.21438030153104,609.40910891619569,0.28658637624133693,167.10227455567633,0.47075129649889558]
[20,533.04509353050628,630.20699345154412,0.30114489541608086,157.19577010694812,0.50516784235396095]
[21,489.98089203207871,399.27680629426845,0.13949376440598793,69.559015984878116,0.45310272870489976]
[22,504.98722708910668,590.33071057008578,0.27323149739906,130.8816516223788,0.39348540016895772]
[23,416.22197480369516,433.08151987040441,0.16315706390928306,67.061468506749662,0.29373345403932055]
[24,440.80622830526744,387.78217104446725,0.13144751973112706,56.687962920166093,0.40765392052760918]
[25,497.02627513458714,564.15346996241499,0.25490742897369051,134.14807874513446,0.44975153692129283,null,null,null,null,null,null,null,null,"Sub TAC()"]
[26,554.42985132142917,419.23440414763689,0.15346408290334582,89.881590816496399,0.60531215817591599,null,null,null,null,null,null,null,null,"'"]
[27,668.74715051547685,639.2860816120741,0.30750025712845186,189.86414041663539,0.59661471693514834,null,null,null,null,null,null,null,null,"' TAC Macro"]
[28,640.01039198541594,599.92437665796137,0.27994706366057293,170.94551353247567,0.52946958895799034,null,null,null,null,null,null,null,null,"' マクロ記録日 : 2004/3/10  ユーザー名 : matsuda"]
[29,626.62742262715847,687.52551337850207,0.34126785936495146,192.75328231513626,0.52414348848669423,null,null,null,null,null,null,null,null,"'"]
[30,660.49696679499721,795.44624922982302,0.35,212.24278050648144,0.63717510906026842,null,null,null,null,null,null,null,null,"Dim i, a(3), b(3), c(3), d(3), n As Integer"]
[31,749.13511288164136,835.98081286572494,0.35,265.2963740316809,0.73768599979915717,null,null,null,null,null,null,null,null,"ActiveSheet.EnableCalculation = False"]
[32,674.1776648621709,{"$f":"B38*(1-E$3+2*RAND()*E$3)","v":548.28652930052738},{"$f":"IF(C38<H$2,0,IF(C38<J$2,(J$3*(C38-H$2)/(J$2-H$2)),J$3))","v":0.24380057051036913},{"$f":"B38*D38*(1-F$3+2*RAND()*F$3)","v":149.83873027108172},0.5736613763157179,null,null,null,null,null,null,null,null,"Keisan"]
[33,{"$f":"(B38-E38)*EXP(F39-(B38-E38)*H$5)","v":612.56446034438397},602.98035346377708,0.28208624742464394,173.33747528184907,{"$f":"D$3*F38+(1-D$3)*(A$3*(1-C$3+2*RAND()*C$3))","v":0.41768534859478457},null,null,null,null,null,null,null,null,"For i = 1 To 3"]
[34,532.73274295719796,374.8601876429268,0.12240213135004875,60.899117920886368,0.41261704089383522,null,null,null,null,null,null,null,null,"    a(i) = ActiveSheet.Cells(i + 1, 13).Value"]
[35,646.3056168996593,491.96313190145383,0.20437419233101767,140.61667224215537,0.55056286148761235,null,null,null,null,null,null,null,null,"    b(i) = ActiveSheet.Cells(i + 1, 14).Value"]
[36,581.05594917097039,569.93429639010492,0.25895400747307346,153.86372860446096,0.39176977621837761,null,null,null,null,null,null,null,null,"    c(i) = ActiveSheet.Cells(i + 1, 15).Value"]
[37,588.70072843315018,734.15568032624049,0.35,219.61439919587067,0.53427998647975894,null,null,null,null,null,null,null,null,"    d(i) = ActiveSheet.Cells(i + 1, 16).Value"]
[38,513.56900172139092,578.18998509347955,0.26473298956543567,129.84843961480524,0.51489698901912972,null,null,null,null,null,null,null,null,"Next i"]
[39,610.20283768408001,526.11471131676376,0.22828029792173463,126.66083870260464,0.65573711890538255,null,null,null,null,null,null,null,null,"    n = ActiveSheet.Cells(4, 18).Value"]
[40,709.63994160414677,900.0647618599163,0.35,268.64142577659868,0.6253905407817707,null,null,null,null,null,null,null,null,"'"]
[41,686.82904707129671,568.64932964726552,0.25805453075308582,180.41522388906893,0.66354316941982616,null,null,null,null,null,null,null,null,"    If a(1) < a(2) Then a(3) = a(3) + 1"]
[42,709.72161346575751,922.63581672508815,0.35,258.61889325879304,0.59072554360670038,null,null,null,null,null,null,null,null,"    If b(1) < b(2) Then b(3) = b(3) + 1"]
[43,581.99690257758812,709.6233134813167,0.35,183.50611581042114,0.48032141122898897,null,null,null,null,null,null,null,null,"    If c(1) > c(2) Then c(3) = c(3) + 1"]
[44,558.60058046611596,660.24212942343854,0.32216949059640693,172.45201075354109,0.53699570785687567,null,null,null,null,null,null,null,null,"    If d(1) > d(2) Then d(3) = d(3) + 1"]
[45,550.6119479289199,450.51959705270235,0.17536371793689165,102.71279570075748,0.54788238612399465]
[46,696.28914046687737,887.15725228459848,0.35,222.90227750381754,0.66514648144480715,null,null,null,null,null,null,null,null,"    ActiveSheet.Cells(4, 13).Value = a(3)"]
[47,765.85404286813855,664.04351748388638,0.32483046223872042,245.93111249116015,0.71777209220768867,null,null,null,null,null,null,null,null,"    ActiveSheet.Cells(4, 14).Value = b(3)"]
[48,813.4542140076594,1014.1404689842192,0.35,269.64002632917624,0.70757051776645419,null,null,null,null,null,null,null,null,"    ActiveSheet.Cells(4, 15).Value = c(3)"]
[49,703.72445058108315,554.5243843663726,0.2481670690564608,170.84111267899485,0.52968634621235611,null,null,null,null,null,null,null,null,"    ActiveSheet.Cells(4, 16).Value = d(3)"]
[50,666.03775209820378,473.39483941419195,0.19137638758993436,134.97294632213692,0.4894855007410181,null,null,null,null,null,null,null,null,"    ActiveSheet.Cells(4, 18).Value = n + 1"]
[51,644.44369681980436,585.33508547387362,0.26973455983171152,189.12523295752911,0.45903580340735023,null,null,null,null,null,null,null,null,"ActiveSheet.EnableCalculation = True"]
[52,572.76637168865261,561.16044035910954,0.25281230825137668,154.61107898194325,0.45714004251283424,null,null,null,null,null,null,null,null,"End Sub"]
[53,513.3185331540609,546.60885158282724,0.24262619610797903,121.82304814402276,0.41412134397615874,null,null,null,null,null,null,null,null,"Sub TAC100()"]
[54,547.44713618163485,412.32961214608611,0.14863072850226028,88.869026208713152,0.53103966179161233,null,null,null,null,null,null,null,null,"'"]
[55,669.8780017662267,781.36606464005433,0.35,221.47216348278749,0.60825402687854291,null,null,null,null,null,null,null,null,"' TAC初期化 Macro"]
[56,707.60367619655551,865.54559534483712,0.35,239.20292568052065,0.68038836534638114,null,null,null,null,null,null,null,null,"' マクロ記録日 : 2004/3/12  ユーザー名 : matsuda"]
[57,600.65986302994418,667.40244471717415,0.32718171130202189,209.26813424940164,0.48290496386531329,null,null,null,null,null,null,null,null,"'"]
[58,583.00541360983152,445.80020411692925,0.17206014288185045,90.968387252169606,0.59418341413426368,null,null,null,null,null,null,null,null,"    Dim j, n9 As Integer"]
[59,604.47116044456914,444.0225389425305,0.17081577725977135,106.72875112055686,0.45181850349558172,null,null,null,null,null,null,null,null,"    n9 = ActiveSheet.Cells(4, 18).Value"]
[60,571.72860087435527,515.79059772647827,0.22105341840853479,113.80136295878235,0.3874529165963651,null,null,null,null,null,null,null,null,"    Range(\"r4\").Select"]
[61,557.43605283147224,631.79546232045925,0.30225682362432144,184.10264262819294,0.42560110995864386,null,null,null,null,null,null,null,null,"    ActiveCell.FormulaR1C1 = \"0\""]
[62,518.8859758424054,482.19088951678219,0.19753362266174754,99.909699426744595,0.51587898288174205,null,null,null,null,null,null,null,null,"    Range(\"r4\").Select"]
[63,637.9017980137088,806.38273046261395,0.35,233.81826382521652,0.62985818931070459,null,null,null,null,null,null,null,null,"    Selection.Copy"]
[64,685.5509193133438,{"$f":"B70*(1-E$3+2*RAND()*E$3)","v":522.36283967118425},{"$f":"IF(C70<H$2,0,IF(C70<J$2,(J$3*(C70-H$2)/(J$2-H$2)),J$3))","v":0.22565398776982895},{"$f":"B70*D70*(1-F$3+2*RAND()*F$3)","v":145.77733917455046},0.73064291950164817,null,null,null,null,null,null,null,null,"    Range(\"m4:p4\").Select"]
[65,727.34696878463978,701.21306370654236,0.35,276.52051620363937,0.56814065921197354,null,null,null,null,null,null,null,null,"    Range(\"o4\").Activate"]
[{"$f":"A71+1","v":66},573.32420784848966,691.35918459931429,0.34395142921951999,210.72546618091229,0.46578213112105737,null,null,null,null,null,null,null,null,"    ActiveSheet.Paste"]
[{"$f":"A72+1","v":67},481.99829584414857,463.36442128690635,0.18435509490083443,81.256472962909385,0.46594312127488696,null,null,null,null,null,null,null,null,"    "]
[{"$f":"A73+1","v":68},461.82182616359671,404.59796335013311,0.14321857434509316,72.746344714684895,0.34223268373967286,null,null,null,null,null,null,null,null,"    For j = 1 To n9"]
[{"$f":"A74+1","v":69},492.53692360753337,396.73401561564322,0.13771381093095025,70.366870256403473,0.43033380580869901,null,null,null,null,null,null,null,null,"      Application.Run \"TAC\""]
[{"$f":"A75+1","v":70},{"$f":"(B75-E75)*EXP(F76-(B75-E75)*H$5)","v":522.41147585730437},{"$f":"B76*(1-E$3+2*RAND()*E$3)","v":524.29372776988293},{"$f":"IF(C76<H$2,0,IF(C76<J$2,(J$3*(C76-H$2)/(J$2-H$2)),J$3))","v":0.22700560943891804},{"$f":"B76*D76*(1-F$3+2*RAND()*F$3)","v":121.0673131926596},{"$f":"D$3*F75+(1-D$3)*(A$3*(1-C$3+2*RAND()*C$3))","v":0.42413236907231344},null,null,null,null,null,null,null,null,"    Next j"]
[71,447.86315624198772,320.21590755516598,8.4151135288616188E-2,36.73455825358846,0.31034049204921299,null,null,null,null,null,null,null,null,"End Sub"]
[72,521.4459803490364,422.17585569708649,0.15552309898796055,86.887245393038967,0.44326392688990673,null,null,null,null,null,null,null,null,"Sub Keisan()"]
[73,625.91924137450303,734.67078729822038,0.35,208.18824093978239,0.58216960903260073,null,null,null,null,null,null,null,null,"ActiveSheet.EnableCalculation = True"]
[74,593.83448086510589,738.91025670232386,0.35,204.14836877747416,0.56062844327275729,null,null,null,null,null,null,null,null,"ActiveSheet.EnableCalculation = False"]
[75,639.19296896928881,597.97654150776452,0.27858357905543518,187.44698849639926,0.68970787643572629,null,null,null,null,null,null,null,null,"End Sub"]
[76,772.92841045751629,706.31897807652535,0.35,256.9760517104404,0.76293939017920709]
[77,694.96663643858778,563.58816772490627,0.25451171740743433,161.69672140872623,0.5558255854521863]
[78,780.10823566076158,640.23463926133934,0.30816424748293753,226.00948174639308,0.64703992806894428]
[79,666.64749351943294,816.48727097068024,0.35,239.26979334528295,0.46196786067207601]