{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Len-24 Age -20","Len 6","Len-1","Age-12","Age -17","Age-17 improved"],"not_rendered":{"charts":7,"images":6,"macros":1,"external_links":1,"defined_names":31,"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":"Len-24 Age -20","index":0,"n_rows":152,"n_cols":35,"rows_kept":152,"cut":false,"hidden":false,"merged":[[5,10,5,15],[4,5,4,6]]}
["INPUT VALUES IN YELLOW"]
[]
[20]
[]
[null,null,null,null,null,"Parameter",null,null,0]
[null,"Name","Value","Type","Trans","min","max",null,"Input",null,"Use slider bars below to change the parameter values",null,null,null,null,null,"slider_value (0-1000)",null,"#LO","HI","INIT","PRIOR","PR_type","SD","PHASE","env-variable","use_dev","dev_minyr","dev_maxyr","dev_stddev","Block_Pattern","Block_Type"]
[null,"PEAK",{"$f":"$I$5*I7 + (1-$I$5)*(F7+Q7/1000*(G7-F7))","v":11.6226},"value",{"$f":"C7","v":11.6226},{"$f":"B20*1.01","v":0},{"$f":"B23*0.99","v":19.8},null,13.33,null,null,null,null,null,null,null,587,null,{"$f":"F7","v":0},19.8,{"$f":"C7","v":11.6226},{"$f":"U7","v":11.6226},1,0.05,2,0,0,0,0,0.5,0,0,"#","PEAK","value"]
[null,"TOP",0.69599999999999973,"logistic",{"$f":"E$7+C16+(0.99*$B$23-E$7-C16)/(1+EXP(-C8))","v":17.412081351413967},-5,3,null,0.704847,null,null,null,null,null,null,null,712,null,-5,3,0.69599999999999973,0.69599999999999973,1,0.05,3,0,0,0,0,0.5,0,0,"#","TOP","logistic"]
[null,"ASC-WIDTH",3.4400000000000004,"exp",{"$f":"EXP(C9)","v":31.186958168309474},-4,12,null,3.42,null,null,null,null,null,null,null,465,null,-4,12,3.4400000000000004,3.4400000000000004,1,0.05,3,0,0,0,0,0.5,0,0,"#","WIDTH","exp"]
[null,"DSC-WIDTH",0.20800000000000018,"exp",{"$f":"EXP(C10)","v":1.2312131695488679},-2,6,null,0.210282,null,null,null,null,null,null,null,276,null,-2,6,0.20800000000000018,0.20800000000000018,1,0.05,3,0,0,0,0,0.5,0,0,"#","WIDTH","exp"]
[null,"INIT",-8.9,"logistic",{"$f":"1/(1+EXP(-C11))","v":1.3637032707949703E-4},-15,5,null,-8.9,null,null,null,null,null,null,null,305,null,-15,5,-8.9,-8.9,1,0.05,2,0,0,0,0,0.5,0,0,"#","INIT","logistic"]
[null,"FINAL",0.15000000000000036,"logistic",{"$f":"1/(1+EXP(-C12))","v":0.53742984534374971},-5,5,null,0.14949999999999999,null,null,null,null,null,null,null,515,null,-5,5,0.15000000000000036,0.15000000000000036,1,0.05,2,0,0,0,0,0.5,0,0,"#","FINAL","logistic"]
[]
["BINS:","min",0]
[null,"max",20,null,null,null,null,{"$f":"IF(C11<-1000,-1000-C11,-1)","v":-1}]
[null,"BinWidth",1]
[null,"MidBin",{"$f":"IF(A3=20,0,IF(A3=24,0.5,\"WRONG\"))","v":0}]
[]
["some intermediate quantities"]
["min",{"$f":"C14+$C$16*$C$17","v":0},null,{"$f":"EXP(-(($B20-$E$7)^2/$E$9))","v":1.3148434315767309E-2}]
["Peak",{"$f":"E7","v":11.6226},null,1]
["Peak2",{"$f":"E8","v":17.412081351413967},null,null,null,null,1,null,null,"max_selex: "]
["max",{"$f":"C15+$C$16*$C$17","v":20},null,null,null,null,{"$f":"EXP(-(($B23-$E$8)^2/$E$10))","v":4.3411637907833688E-3},null,null,{"$f":"MAX(J26:J150)","v":0.99999978178171234}]
[null,null,null,null,null,null,null,20,20]
["Bin","Bin_Mid","asc","asc_scaled",null,"desc","desc_scaled","join1","join2","selex"]
[{"$f":"C14","v":0},{"$f":"A26+$C$16*$C$17","v":0},{"$f":"EXP(-(($B26-$E$7)^2/$E$9))","v":1.3148434315767309E-2},{"$f":"IF(C$11>-999,($E$11+(1-$E$11)*(C26-$D$20)/($D$21-$D$20)),C26)","v":1.3637032707949703E-4},null,{"$f":"EXP(-(($B26-$E$8)^2/$E$10))","v":1.1402036948225244E-107},{"$f":"IF(C$12>-999,(1+($E$12-1)*(F26-$G$22)/($G$23-$G$22)),F26)","v":0.53541299706895695},{"$f":"1/(1+EXP(-($H$24*($B26-$E$7)/(1+ABS($B26-$E$7)))))","v":1.0051535882333532E-8},{"$f":"1/(1+EXP(-($I$24*($B26-$E$8)/(1+ABS($B26-$E$8)))))","v":6.1074487357380518E-9},{"$f":"IF(A26>$H$15,(D26*(1-H26)+H26*(1*(1-I26)+G26*I26)),0.000001)","v":1.3638037724461959E-4}]
[{"$f":"IF(A26<$C$15-$C$16,A26+$C$16,$C$15)","v":1},1,2.683180737563861E-2,{"$f":"IF(C$11>-999,($E$11+(1-$E$11)*(C27-$D$20)/($D$21-$D$20)),C27)","v":1.4000164568846256E-2},null,9.7278592960235245E-96,{"$f":"IF(C$12>-999,(1+($E$12-1)*(F27-$G$22)/($G$23-$G$22)),F27)","v":0.53541299706895695},{"$f":"1/(1+EXP(-($H$24*($B27-$E$7)/(1+ABS($B27-$E$7)))))","v":1.1519614508085382E-8},{"$f":"1/(1+EXP(-($I$24*($B27-$E$8)/(1+ABS($B27-$E$8)))))","v":6.5005942153413998E-9},{"$f":"IF(A27>$H$15,(D27*(1-H27)+H27*(1*(1-I27)+G27*I27)),0.000001)","v":1.4000175927184231E-2}]
[{"$f":"IF(A27<$C$15-$C$16,A27+$C$16,$C$15)","v":2},2,5.1354059746450166E-2,3.8845753425195549E-2,null,1.6352269958255333E-84,0.53541299706895695,1.3545359968800584E-8,6.9718478965156603E-9,3.8845766444375762E-2]
[3,3,9.2182526043322721E-2,8.0212560678791955E-2,null,5.4158265597530492E-74,0.53541299706895695,1.6472727899238821E-8,7.5454828881415544E-9,8.0212575830200111E-2]
[4,4,0.15519273814978177,0.14405358963793702,null,3.5340881582657985E-64,0.53541299706895695,2.0962849882477741E-8,8.2564147245405937E-9,0.14405360758101304]
[5,5,0.24504348186923663,0.23508905420839254,null,4.5437658328014295E-55,0.53541299706895695,2.8418560563148419E-8,9.1564513058262923E-9,0.23508907594606046]
[6,6,0.36288070960971236,0.3544800166754738,null,1.1510135486589626E-46,0.53541299706895695,4.2234091197567787E-8,1.032531995052745E-8,0.35448004393842342]
[7,7,0.504003529343516,0.49746360172038789,null,5.744746399473684E-39,0.53541299706895695,7.2264934016208986E-8,1.189115107929698E-8,0.49746363803614713]
[8,8,0.65652647089922189,0.65199762411568263,null,5.6492034939753426E-32,0.53541299706895695,1.5599674537051544E-7,1.4070935534903978E-8,0.65199767840291956]
[9,9,0.80208403725754029,0.79947442983415629,null,1.0945346332632133E-25,0.53541299706895695,5.149974326757335E-7,1.7256593968372253E-8,0.79947453310430605]
[10,10,0.91904435824641528,0.91797692315549306,null,4.1782818142952702E-20,0.53541299706895695,4.227142830207725E-6,2.221568774436524E-8,0.91797726987871064]
[11,11,0.98764766585526931,0.9874847949961757,null,3.1426200780242353E-15,0.53541299706895829,4.6449122547397053E-4,3.0617239358082016E-8,0.9874906081924778]
[12,12,0.99544341537478687,0.99538333483909647,null,4.6570614086582293E-11,0.53541299709059298,0.99584752512679764,4.6636234704627402E-8,0.99998080783730292]
[13,13,0.9409793284171778,0.94020111537886886,null,1.3597465951477194E-7,0.53541306024101643,0.99999071822497254,8.2988471930195916E-8,0.99999940640520368]
[14,14,0.83424297027860828,0.83205739227244269,null,7.8222182101251231E-5,0.53544933807810202,0.99999923108533328,1.9176556895695153E-7,0.99999978178171234]
[15,15,0.69367173208128541,0.68963266160472536,null,8.8660016029607647E-3,0.5395320261816583,0.99999980122215804,7.2399904327073174E-7,0.99999960492754403]
[16,16,0.54095906918959402,0.5349064163157139,null,0.19799381124935989,0.62739834843619158,0.99999991500985674,8.224328401623784E-6,0.99999689607354469]
[17,17,0.39566149134739831,0.38769302717420367,null,0.87116688249747953,0.94014580806124115,0.99999995256596286,2.9105161838984556E-3,0.99982576436975956]
[18,18,0.27141392734744413,0.26180720539625729,null,0.75522616988786273,0.88628125987224982,0.99999996899191446,0.99939210258240685,0.88635036983481696]
[19,19,0.17461817429381363,0.16373515854489262,null,0.12899671045026653,0.59534319216500986,0.99999997756457082,0.99999531800605457,0.59534507708238016]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,{"$f":"A58+$C$16*$C$17","v":20},{"$f":"EXP(-(($B58-$E$7)^2/$E$9))","v":0.10536484321338371},9.3568692392499223E-2,null,{"$f":"EXP(-(($B58-$E$8)^2/$E$10))","v":4.3411637907833688E-3},0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,{"$f":"A90+$C$16*$C$17","v":20},{"$f":"EXP(-(($B90-$E$7)^2/$E$9))","v":0.10536484321338371},9.3568692392499223E-2,null,{"$f":"EXP(-(($B90-$E$8)^2/$E$10))","v":4.3411637907833688E-3},0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,{"$f":"IF(C$11>-999,($E$11+(1-$E$11)*(C91-$D$20)/($D$21-$D$20)),C91)","v":9.3568692392499223E-2},null,4.3411637907833688E-3,{"$f":"IF(C$12>-999,(1+($E$12-1)*(F91-$G$22)/($G$23-$G$22)),F91)","v":0.53742984534374971},{"$f":"1/(1+EXP(-($H$24*($B91-$E$7)/(1+ABS($B91-$E$7)))))","v":0.99999998260725509},{"$f":"1/(1+EXP(-($I$24*($B91-$E$8)/(1+ABS($B91-$E$8)))))","v":0.99999945677277813},{"$f":"IF(A91>$H$15,(D91*(1-H91)+H91*(1*(1-I91)+G91*I91)),0.000001)","v":0.53743008890448163}]
[{"$f":"IF(A91<$C$15-$C$16,A91+$C$16,$C$15)","v":20},20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,{"$f":"A122+$C$16*$C$17","v":20},{"$f":"EXP(-(($B122-$E$7)^2/$E$9))","v":0.10536484321338371},9.3568692392499223E-2,null,{"$f":"EXP(-(($B122-$E$8)^2/$E$10))","v":4.3411637907833688E-3},0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20,0.10536484321338371,9.3568692392499223E-2,null,4.3411637907833688E-3,0.53742984534374971,0.99999998260725509,0.99999945677277813,0.53743008890448163]
[20,20]
[20]

{"sheet":"Len 6","index":1,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Pattern #6; non-parametric selex based on set of linear segments"]
["note that values are the ln(selex) at length and are not a randwalk across lengths"]
[]
["This example has 7 waypoints specified by the value of \"special\""]
["#Pattern","Retention","Male","Special"]
[6,0,0,7]
["#Note the examples values are set to be dome-shaped with largest selectivity occurring at the 5th waypoint"]
[20,80,36,36,0,99,-3,0,0,0,0,0,0,0,null,"# P1; length below which ln(selex) ramps down to -10."]
[20,200,76,76,0,99,-3,0,0,0,0,0,0,0,null,"# P2; length above which selex is constant"]
[-5,9,-2,-2,0,99,2,0,0,0,0,0,0,0,null,"# ln selex at P1"]
[-5,9,0,0,0,99,2,0,0,0,0,0,0,0,null,"# ln selex at intermediate waypoint; N waypoints set in the Special element of selex set-up"]
[-5,9,1,0,0,99,2,0,0,0,0,0,0,0,null,"# ln selex at intermediate waypoint; N waypoints set in the Special element of selex set-up"]
[-5,9,2,7,0,99,2,0,0,0,0,0,0,0,null,"# ln selex at intermediate waypoint; N waypoints set in the Special element of selex set-up"]
[-5,9,3.3,7,0,2,2,0,0,0,0,0,0,0,null,"# ln selex at intermediate waypoint; N waypoints set in the Special element of selex set-up"]
[-5,9,3.2,7,0,2,2,0,0,0,0,0,0,0,null,"# ln selex at intermediate waypoint; N waypoints set in the Special element of selex set-up"]
[-5,9,3,7,0,2,2,0,0,0,0,0,0,0,null,"# ln selex at P2"]
[]
["Waypoints"]
[36,{"$f":"A19+($C$9-$C$8)/($D$6-1)","v":42.666666666666664},{"$f":"B19+($C$9-$C$8)/($D$6-1)","v":49.333333333333329},{"$f":"C19+($C$9-$C$8)/($D$6-1)","v":55.999999999999993},{"$f":"D19+($C$9-$C$8)/($D$6-1)","v":62.666666666666657},{"$f":"E19+($C$9-$C$8)/($D$6-1)","v":69.333333333333329},{"$f":"F19+($C$9-$C$8)/($D$6-1)","v":76}]
[{"$f":"C10","v":-2},{"$f":"C11","v":0},{"$f":"C12","v":1},{"$f":"C13","v":2},{"$f":"C14","v":3.3},{"$f":"C15","v":3.2},{"$f":"C16","v":3}]
["Hardwired calculations"]
[]
["Len_mid","tempvec_l",null,null,"tempvec-max",null,"sel"]
[10,{"$f":"-10","v":-10},"start",{"$f":"(B37-B24)/(A37-A24)","v":0.30769230769230771},{"$f":"B24-MAX($B$24:$B$68)","v":-13.3},null,{"$f":"EXP(E24)","v":1.674493209434266E-6}]
[{"$f":"A24+2","v":12},{"$f":"B24+(A25-A24)*D25","v":-9.384615384615385},"linear",{"$f":"D24","v":0.30769230769230771},{"$f":"B25-MAX($B$24:$B$68)","v":-12.684615384615384},null,{"$f":"EXP(E25)","v":3.098428890020581E-6}]
[{"$f":"A25+2","v":14},-8.7692307692307701,"linear",0.30769230769230771,-12.069230769230771,null,5.7332341107299093E-6]
[16,-8.1538461538461551,"linear",0.30769230769230771,-11.453846153846154,null,1.0608593753532537E-5]
[18,-7.5384615384615401,"linear",0.30769230769230771,-10.838461538461541,null,1.9629803921117255E-5]
[20,-6.9230769230769251,"linear",0.30769230769230771,-10.223076923076924,null,3.6322363824442011E-5]
[22,-6.3076923076923102,"linear",0.30769230769230771,-9.6076923076923109,null,6.7209744890821022E-5]
[24,-5.6923076923076952,"linear",0.30769230769230771,-8.9923076923076941,null,1.2436277082962269E-4]
[26,-5.0769230769230802,"linear",0.30769230769230771,-8.3769230769230809,null,2.3011690928964428E-4]
[28,-4.4615384615384652,"linear",0.30769230769230771,-7.7615384615384651,null,4.2580099806207558E-4]
[30,-3.8461538461538498,"linear",0.30769230769230771,-7.1461538461538492,null,7.8788860197340942E-4]
[32,-3.2307692307692344,"linear",0.30769230769230771,-6.5307692307692342,null,1.4578839691425851E-3]
[34,-2.615384615384619,"linear",0.30769230769230771,-5.9153846153846192,null,2.6976220523554032E-3]
[36,{"$f":"C10","v":-2},"setpoint",{"$f":"(B41-B37)/(A41-A37)","v":0.3000000000000001},-5.3,null,4.991593906910217E-3]
[38,{"$f":"B37+(A38-A37)*D38","v":-1.4},null,{"$f":"D37","v":0.3000000000000001},-4.6999999999999993,null,9.0952771016958242E-3]
[40,{"$f":"B38+(A39-A38)*D39","v":-0.79999999999999971},null,{"$f":"D38","v":0.3000000000000001},-4.0999999999999996,null,1.6572675401761255E-2]
[42,-0.19999999999999951,null,{"$f":"D39","v":0.3000000000000001},-3.4999999999999991,null,3.0197383422318529E-2]
[{"$f":"B19","v":42.666666666666664},{"$f":"C11","v":0},null,{"$f":"(B45-B41)/(A45-A41)","v":0.15000000000000005},-3.3,null,3.6883167401240015E-2]
[{"$f":"A40+2","v":44},{"$f":"B41+(A42-A41)*D42","v":0.20000000000000043},null,{"$f":"D41","v":0.15000000000000005},-3.0999999999999992,null,4.5049202393557843E-2]
[46,{"$f":"B42+(A43-A42)*D43","v":0.50000000000000056},null,0.15000000000000005,-2.7999999999999994,null,6.0810062625218E-2]
[48,0.80000000000000071,null,0.15000000000000005,-2.4999999999999991,null,8.2084998623898869E-2]
[{"$f":"C19","v":49.333333333333329},{"$f":"C12","v":1},null,{"$f":"(B50-B45)/(A50-A45)","v":0.15000000000000005},-2.2999999999999998,null,0.10025884372280375]
[{"$f":"A44+2","v":50},{"$f":"B45+(A46-A45)*D46","v":1.1000000000000008},null,0.15000000000000005,-2.1999999999999993,null,0.11080315836233397]
[52,{"$f":"B46+(A47-A46)*D47","v":1.4000000000000008},null,0.15000000000000005,-1.899999999999999,null,0.1495686192226352]
[54,1.7000000000000008,null,0.15000000000000005,-1.599999999999999,null,0.20189651799465561]
[56,2.0000000000000009,null,0.15000000000000005,-1.2999999999999989,null,0.27253179303401287]
[{"$f":"D19","v":55.999999999999993},{"$f":"C13","v":2},null,{"$f":"(B54-B50)/(A54-A50)","v":0.19500000000000003},-1.2999999999999998,null,0.27253179303401265]
[{"$f":"A49+2","v":58},2.3900000000000015,null,0.19500000000000003,-0.90999999999999837,null,0.40252422403363664]
[60,2.7800000000000016,null,0.19500000000000003,-0.51999999999999824,null,0.59452054797019538]
[62,3.1700000000000017,null,0.19500000000000003,-0.12999999999999812,null,0.87809543092056297]
[{"$f":"E19","v":62.666666666666657},{"$f":"C14","v":3.3},null,{"$f":"(B58-B54)/(A58-A54)","v":-1.4999999999999935E-2},0,null,1]
[{"$f":"A53+2","v":64},3.28,null,-1.4999999999999935E-2,-2.0000000000000018E-2,null,0.98019867330675525]
[66,3.25,null,-1.4999999999999935E-2,-4.9999999999999822E-2,null,0.95122942450071413]
[68,3.22,null,-1.4999999999999935E-2,-7.9999999999999627E-2,null,0.92311634638663609]
[{"$f":"F19","v":69.333333333333329},{"$f":"C15","v":3.2},null,{"$f":"(B63-B58)/(A63-A58)","v":-3.0000000000000006E-2},-9.9999999999999645E-2,null,0.90483741803595985]
[{"$f":"A57+2","v":70},3.18,null,-3.0000000000000006E-2,-0.11999999999999966,null,0.88692043671715781]
[72,3.12,null,-3.0000000000000006E-2,-0.17999999999999972,null,0.83527021141127222]
[74,3.06,null,-3.0000000000000006E-2,-0.23999999999999977,null,0.78662786106655358]
[76,3,null,-3.0000000000000006E-2,-0.29999999999999982,null,0.74081822068171799]
[{"$f":"G19","v":76},{"$f":"C16","v":3},"last point",null,-0.29999999999999982,null,0.74081822068171799]
[{"$f":"A62+2","v":78},{"$f":"B63","v":3},"constant",null,-0.29999999999999982,null,0.74081822068171799]
[80,{"$f":"B64","v":3},"constant",null,-0.29999999999999982,null,0.74081822068171799]
[82,3,"constant",null,-0.29999999999999982,null,0.74081822068171799]
[84,3,"constant",null,-0.29999999999999982,null,0.74081822068171799]
[86,3,"constant",null,-0.29999999999999982,null,0.74081822068171799]

{"sheet":"Len-1","index":2,"n_rows":141,"n_cols":8,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["Type 1: Logistic Length Selectivity",null,null,"RED = do not edit"]
[null,null,null,"YELLOW=enter values here"]
["L or A:","L"]
[]
["Name","Type","min","max","Value",null,"Transformed value for calculations"]
["Length at 50% selectivity","value",{"$f":"C9","v":0},{"$f":"0.99*C10","v":79.2},40,null,{"$f":"E6","v":40}]
["Difference between lengths at 95% and 50% selectivity","value",-5,30,10,null,{"$f":"E7","v":10},"range must be bounded to stay negative ro stay positive"]
[]
["BINS:","min",0,null,null,null,null,"For the Toolbox GUI, the bin values can be obtained from the bin setup and should not be independently generated here"]
[null,"max",80]
[null,"BinWidth",1]
[null,"MidBin",{"$f":"IF(B3=\"A\",0,IF(B3=\"L\",0.5,\"WRONG: use L or A in cell B3\"))","v":0.5}]
[null,null,"max_selex: "]
[null,null,{"$f":"MAX(C17:C141)","v":0.99999337714815506}]
[]
["Bin","Bin_Calc","selex"]
[{"$f":"C9","v":0},{"$f":"A17+$C$11*$C$12","v":0.5},{"$f":"1/(1+EXP(-LN(19)*(B17-$G$6)/$G$7))","v":8.8903613887799443E-6}]
[{"$f":"IF(A17<$C$10-$C$11,A17+$C$11,$C$10)","v":1},1.5,{"$f":"1/(1+EXP(-LN(19)*(B18-$G$6)/$G$7))","v":1.1934203891726817E-5}]
[{"$f":"IF(A18<$C$10-$C$11,A18+$C$11,$C$10)","v":2},2.5,1.6020166995826902E-5]
[3,3.5,2.15050282255806E-5]
[4,4.5,2.8867699733858926E-5]
[5,5.5,3.8751029688762125E-5]
[6,6.5,5.201790355715704E-5]
[7,7.5,6.982653161927E-5]
[8,8.5,9.3731474287412419E-5]
[9,9.5,1.2581918598030754E-4]
[10,10.5,1.6888983953606827E-4]
[11,11.5,2.2670117497800563E-4]
[12,12.5,3.0429542537716069E-4]
[13,13.5,4.0843743403218117E-4]
[14,14.5,5.4820143928154864E-4]
[15,15.5,7.3575636038830769E-4]
[16,16.5,9.8741562834931003E-4]
[17,17.5,1.3250386893592224E-3]
[18,18.5,1.7778984007725564E-3]
[19,19.5,2.3851627473903134E-3]
[20,20.5,3.1991813850315307E-3]
[21,21.5,4.2898172057643253E-3]
[{"$f":"IF(A38<$C$10-$C$11,A38+$C$11,$C$10)","v":22},22.5,5.7501178600824054E-3]
[23,23.5,7.7036748015770927E-3]
[24,24.5,1.0314052138263039E-2]
[25,25.5,1.3796653289994501E-2]
[26,26.5,1.8433273496656643E-2]
[27,27.5,2.4589264026618745E-2]
[28,28.5,3.2732556729938196E-2]
[29,29.5,4.3452547062813859E-2]
[30,30.5,5.7474747740164214E-2]
[31,31.5,7.566400165843791E-2]
[32,32.5,9.9005010697117077E-2]
[33,33.5,0.12854498369787984]
[34,34.5,0.16528191704798764]
[35,35.5,0.20998803456657261]
[36,36.5,0.26297678305924127]
[37,37.5,0.32385542054539385]
[38,38.5,0.39134410295349109]
[39,39.5,0.46326084676106677]
[40,40.5,0.53673915323893318]
[41,41.5,0.60865589704650891]
[42,42.5,0.67614457945460615]
[43,43.5,0.73702321694075879]
[44,44.5,0.79001196543342733]
[45,45.5,0.83471808295201244]
[46,46.5,0.87145501630212019]
[47,47.5,0.90099498930288291]
[48,48.5,0.9243359983415621]
[49,49.5,0.94252525225983574]
[50,50.5,0.95654745293718613]
[51,51.5,0.96726744327006176]
[52,52.5,0.97541073597338135]
[53,53.5,0.98156672650334342]
[54,54.5,0.98620334671000554]
[55,55.5,0.98968594786173691]
[56,56.5,0.99229632519842292]
[57,57.5,0.99424988213991772]
[58,58.5,0.99571018279423562]
[59,59.5,0.9968008186149685]
[60,60.5,0.9976148372526098]
[61,61.5,0.99822210159922742]
[62,62.5,0.99867496131064082]
[63,63.5,0.99901258437165064]
[64,{"$f":"A81+$C$11*$C$12","v":64.5},0.99926424363961175]
[65,65.5,{"$f":"1/(1+EXP(-LN(19)*(B82-$G$6)/$G$7))","v":0.99945179856071853}]
[{"$f":"IF(A82<$C$10-$C$11,A82+$C$11,$C$10)","v":66},66.5,0.99959156256596782]
[67,67.5,0.99969570457462276]
[68,68.5,0.99977329882502197]
[69,69.5,0.99983111016046389]
[70,70.5,0.99987418081401969]
[71,71.5,0.99990626852571263]
[72,72.5,0.99993017346838065]
[73,73.5,0.99994798209644287]
[74,74.5,0.99996124897031136]
[75,75.5,0.99997113230026613]
[76,76.5,0.99997849497177438]
[77,77.5,0.99998397983300413]
[78,78.5,0.99998806579610822]
[79,79.5,0.99999110963861115]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]
[80,80.5,0.99999337714815506]

{"sheet":"Age-12","index":3,"n_rows":141,"n_cols":6,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["Type 12: Logistic Age Selectivity"]
[]
["L or A:","A"]
[]
["Name","Value","Type","Trans","min","max"]
["Age at 50% selectivity",7,"value",{"$f":"B6","v":7},{"$f":"C9","v":0},{"$f":"0.99*C10","v":19.8}]
["Difference between ages at 95% and 50% selectivity",3,"value",{"$f":"B7","v":3},-5,3]
[]
["BINS:","min",0]
[null,"max",20]
[null,"BinWidth",1]
[null,"MidBin",{"$f":"IF(B3=\"A\",0,IF(B3=\"L\",0.5,\"WRONG: use L or A in cell B3\"))","v":0}]
[null,null,"max_selex: "]
[null,null,{"$f":"MAX(C17:C141)","v":0.99999712436906474}]
[]
["Bin","Bin_Mid","selex"]
[{"$f":"C9","v":0},{"$f":"A17+$C$11*$C$12","v":0},{"$f":"1/(1+EXP(-LN(19)*(B17-$D$6)/$D$7))","v":1.0370292068795897E-3}]
[{"$f":"IF(A17<$C$10-$C$11,A17+$C$11,$C$10)","v":1},1,{"$f":"1/(1+EXP(-LN(19)*(B18-$D$6)/$D$7))","v":2.7624309392265205E-3}]
[2,2,7.3374580706613958E-3]
[3,3,1.9342497699835048E-2]
[4,4,5.000000000000001E-2]
[5,5,0.12314713802987556]
[6,6,0.27259828550900245]
[7,7,0.5]
[8,8,0.72740171449099755]
[9,9,0.87685286197012446]
[10,10,0.95000000000000007]
[11,11,0.98065750230016491]
[12,12,0.99266254192933856]
[13,13,0.99723756906077354]
[14,14,0.99896297079312035]
[15,15,0.99961111474753284]
[16,16,0.99985422740524788]
[17,17,0.9999453658401668]
[18,18,0.99997952481171337]
[19,19,0.99999232669848537]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,{"$f":"A81+$C$11*$C$12","v":20},0.99999712436906474]
[{"$f":"IF(A81<$C$10-$C$11,A81+$C$11,$C$10)","v":20},20,{"$f":"1/(1+EXP(-LN(19)*(B82-$D$6)/$D$7))","v":0.99999712436906474}]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]
[20,20,0.99999712436906474]

{"sheet":"Age -17","index":4,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Max"]
[null,null,null,{"$f":"MAX(D9:D32)","v":2.2200000000000002}]
["Age","Parm","Use_Parm","Cum_Parm","Scaled_ Cum_Parm","Selex"]
[]
[0,-1000,{"$f":"IF(B9>-999,B9,C8)","v":0},{"$f":"C9","v":0},{"$f":"D9-$D$6","v":-2.2200000000000002},{"$f":"IF(B9=-1000,0,EXP(E9))","v":0}]
[1,-1000,{"$f":"IF(B10>-999,B10,C9)","v":0},{"$f":"D9+C10","v":0},-2.2200000000000002,{"$f":"IF(B10=-1000,0,EXP(E10))","v":0}]
[2,0,0,{"$f":"D10+C11","v":0},-2.2200000000000002,0.10860910882495796]
[3,0.5,0.5,0.5,-1.7200000000000002,0.1790661479114932]
[4,-999,0.5,1,-1.2200000000000002,0.29523016692401416]
[5,-999,0.5,1.5,-0.7200000000000002,0.48675225595997157]
[6,0.2,0.2,1.7,-0.52000000000000024,0.59452054797019416]
[7,0.2,0.2,1.9,-0.32000000000000028,0.72614903707369072]
[8,0.2,0.2,2.1,-0.12000000000000011,0.88692043671715737]
[9,0.1,0.1,2.2000000000000002,-2.0000000000000018E-2,0.98019867330675525]
[10,0.02,0.02,2.2200000000000002,0,1]
[11,0,0,2.2200000000000002,0,1]
[12,0,0,2.2200000000000002,0,1]
[13,0,0,2.2200000000000002,0,1]
[14,-0.1,-0.1,2.12,-0.10000000000000009,0.90483741803595952]
[15,-0.2,-0.2,1.9200000000000002,-0.30000000000000004,0.74081822068171788]
[16,-0.2,-0.2,1.7200000000000002,-0.5,0.60653065971263342,null,"NOTE:"]
[17,-0.2,-0.2,1.5200000000000002,-0.7,0.49658530379140953,null,"parm value = -1000 causes selex equal zero for youngest ages (until first value >-1000)"]
[18,-0.4,-0.4,1.1200000000000001,-1.1000000000000001,0.33287108369807955,null,"parm value = -999 carries forward previous parm value"]
[19,-999,-0.4,0.72000000000000008,-1.5,0.22313016014842982,null,"after any initial values of -1000, the first value should be >=0.0 and should not be estimated (so all other values are relative to this baseline)"]
[20,-999,-0.4,0.32000000000000006,-1.9000000000000001,0.14956861922263504]
[21,0,0,0.32000000000000006,-1.9000000000000001,0.14956861922263504]
[22,-999,0,0.32000000000000006,-1.9000000000000001,0.14956861922263504]
[23,-999,0,0.32000000000000006,-1.9000000000000001,0.14956861922263504]

{"sheet":"Age-17 improved","index":5,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"min age for selex=1.0",8]
[null,null,null,"max age for selex=1.0",12]
[]
[]
[null,null,null,"mean over selected age range",{"$f":"SUMPRODUCT(D9:D32,E9:E32)/SUM(E9:E32)","v":2.1920000000000006}]
["Age","Parm","Use_Parm","Cum_Parm","select_range","Scaled_ Cum_Parm","Selex"]
[]
[0,-1000,{"$f":"IF(B9>-999,B9,C8)","v":0},{"$f":"C9","v":0},{"$f":"IF(A9<$E$2,0,IF(A9>$E$3,0,1))","v":0},{"$f":"D9-$E$6","v":-2.1920000000000006},{"$f":"IF(B9=-1000,0,EXP(F9))","v":0}]
[1,-1000,{"$f":"IF(B10>-999,B10,C9)","v":0},{"$f":"D9+C10","v":0},{"$f":"IF(A10<$E$2,0,IF(A10>$E$3,0,1))","v":0},{"$f":"D10-$E$6","v":-2.1920000000000006},{"$f":"IF(B10=-1000,0,EXP(F10))","v":0}]
[2,0,0,{"$f":"D10+C11","v":0},{"$f":"IF(A11<$E$2,0,IF(A11>$E$3,0,1))","v":0},{"$f":"D11-$E$6","v":-2.1920000000000006},0.11169313880444363]
[3,0.5,0.5,0.5,{"$f":"IF(A12<$E$2,0,IF(A12>$E$3,0,1))","v":0},{"$f":"D12-$E$6","v":-1.6920000000000006},0.1841508537381481]
[4,-999,0.5,1,{"$f":"IF(A13<$E$2,0,IF(A13>$E$3,0,1))","v":0},{"$f":"D13-$E$6","v":-1.1920000000000006},0.30361342957567294]
[5,-999,0.5,1.5,{"$f":"IF(A14<$E$2,0,IF(A14>$E$3,0,1))","v":0},{"$f":"D14-$E$6","v":-0.69200000000000061},0.50057391941162743]
[6,0.2,0.2,1.7,{"$f":"IF(A15<$E$2,0,IF(A15>$E$3,0,1))","v":0},{"$f":"D15-$E$6","v":-0.49200000000000066},0.61140236583240826]
[7,0.2,0.2,1.9,{"$f":"IF(A16<$E$2,0,IF(A16>$E$3,0,1))","v":0},{"$f":"D16-$E$6","v":-0.2920000000000007},0.74676853597335657]
[8,0.2,0.2,2.1,{"$f":"IF(A17<$E$2,0,IF(A17>$E$3,0,1))","v":1},{"$f":"D17-$E$6","v":-9.2000000000000526E-2},0.91210514954508992]
[9,0.1,0.1,2.2000000000000002,{"$f":"IF(A18<$E$2,0,IF(A18>$E$3,0,1))","v":1},{"$f":"D18-$E$6","v":7.999999999999563E-3},1.008032085504273]
[10,0.02,0.02,2.2200000000000002,{"$f":"IF(A19<$E$2,0,IF(A19>$E$3,0,1))","v":1},{"$f":"D19-$E$6","v":2.7999999999999581E-2},1.0283956844214246]
[11,0,0,2.2200000000000002,{"$f":"IF(A20<$E$2,0,IF(A20>$E$3,0,1))","v":1},{"$f":"D20-$E$6","v":2.7999999999999581E-2},1.0283956844214246]
[12,0,0,2.2200000000000002,{"$f":"IF(A21<$E$2,0,IF(A21>$E$3,0,1))","v":1},{"$f":"D21-$E$6","v":2.7999999999999581E-2},1.0283956844214246]
[13,0,0,2.2200000000000002,{"$f":"IF(A22<$E$2,0,IF(A22>$E$3,0,1))","v":0},{"$f":"D22-$E$6","v":2.7999999999999581E-2},1.0283956844214246]
[14,-0.1,-0.1,2.12,{"$f":"IF(A23<$E$2,0,IF(A23>$E$3,0,1))","v":0},{"$f":"D23-$E$6","v":-7.2000000000000508E-2},0.93053089581120529]
[15,-0.2,-0.2,1.9200000000000002,{"$f":"IF(A24<$E$2,0,IF(A24>$E$3,0,1))","v":0},{"$f":"D24-$E$6","v":-0.27200000000000046},0.76185426108983723]
[16,-0.2,-0.2,1.7200000000000002,{"$f":"IF(A25<$E$2,0,IF(A25>$E$3,0,1))","v":0},{"$f":"D25-$E$6","v":-0.47200000000000042},0.62375351291775183,null,"NOTE:"]
[17,-0.2,-0.2,1.5200000000000002,{"$f":"IF(A26<$E$2,0,IF(A26>$E$3,0,1))","v":0},{"$f":"D26-$E$6","v":-0.67200000000000037},0.51068618336618765,null,"parm value = -1000 causes selex equal zero for youngest ages (until first value >-1000)"]
[18,-0.4,-0.4,1.1200000000000001,{"$f":"IF(A27<$E$2,0,IF(A27>$E$3,0,1))","v":0},{"$f":"D27-$E$6","v":-1.0720000000000005},0.3423231859437878,null,"parm value = -999 carries forward previous parm value"]
[19,-999,-0.4,0.72000000000000008,{"$f":"IF(A28<$E$2,0,IF(A28>$E$3,0,1))","v":0},{"$f":"D28-$E$6","v":-1.4720000000000004},0.22946609376090657,null,"after any initial values of -1000, the first value should be >=0.0 and should not be estimated (so all other values are relative to this baseline)"]
[20,-999,-0.4,0.32000000000000006,{"$f":"IF(A29<$E$2,0,IF(A29>$E$3,0,1))","v":0},{"$f":"D29-$E$6","v":-1.8720000000000006},0.15381572253342921]
[21,0,0,0.32000000000000006,{"$f":"IF(A30<$E$2,0,IF(A30>$E$3,0,1))","v":0},{"$f":"D30-$E$6","v":-1.8720000000000006},0.15381572253342921]
[22,-999,0,0.32000000000000006,{"$f":"IF(A31<$E$2,0,IF(A31>$E$3,0,1))","v":0},{"$f":"D31-$E$6","v":-1.8720000000000006},0.15381572253342921]
[23,-999,0,0.32000000000000006,{"$f":"IF(A32<$E$2,0,IF(A32>$E$3,0,1))","v":0},{"$f":"D32-$E$6","v":-1.8720000000000006},0.15381572253342921]