ࡱ> xLyzOh+'0|  , 8 D P\dltHello Steve, oell C ve,C Normal.dot, C t,16CMicrosoft Word 8.0@Ld:@Gme@"[@lev="Microsoft Office0TemplateH<@objective function   (or ) The basic procedure for using  Solver and applying this worksheet to your coverd codend data analysis is as follows: 1. Set up the worksheet with values and formulas. Enter (or cut and copy or paste) your data; length in the Hello Steve, The file that I sent was saved for MS-Excel 97. So, I send another Excel file solver-sel.xls formatted on MS-Excel v.5 and this short (maybe a little bit long) note for using Solver on this worksheet. This worksheet was set up for analyzing covered codend data, i.e. determining selectivity parameters. MS-Excel Solver gives you parameter estimates of logistic curve, Richard curve and logistic curve with encounter probability as selectivity curve on each worksheet in this file. An example of logistic curve with encounter probability, that is the encounter probability model was selectivity curve of girds for southern rough shrimp in Fig. 5 of TOKAI et al.(1996) Fish. Res., Vol. 27, pp. 51-60. If you need analyze paired gear data, I will send another file for the SELECT model,. I have published two papers about utilizing Solver on MS-Excel, but unfortunately both are written in Japanese. The one is "Tadashi TOKAI, 1997. Maximum likelihood parameter estimates of a mesh selectivity logistic model through SOLVER on MS-Excel. Bull. Jpn. Fish. Oceanogra. vol. 61, no.3, 288-298." for analyzing covered codend data. The other is "Tadashi TOKAI and Takahisa Mitsuhashi, 1998. SELECT model for estimating selectivity curve from comparative fishing experiments. Bull Jpn. Fish. Oceanogr., vol. 62, no. 3, 235-247." for Millar's SELECT model, an analysis method for paired gear test. Most of Japanese researchers and some foreign researcher, Korean, Chinese, Argentina, and Indonesian have started to apply my Excel worksheet with SOLVER for analyzing selectivity data, and they got some good results. Firstly, I would like to say about Solver briefly. Solver is a sort of goal-seeking software under some constraints. You can use Solver to adjust a group of cells (called changing cells) and produce the result that you want maximized, minimized or equal to same value in the target cell. Next I would like to explain how Solver move for the analysis, showing as an example the worksheet for logistic curve in the file. This worksheet has already set up to calculate with the data from Clark(1957) that was shown in Table 6.5.2a of ICES manual. (ICES manual; Wileman et al., 1996. Manual of methods of measuring the selectivity of towed fishing gears. Please put the ICES manual on the side of your PC, because the contents including some formulas on this worksheet will be explained later with this manual. In this worksheet, cells F4:F5 contains logistic parameters. Please try to enter (7, 0.2) and (-7.69, 0.219) in these cells F4:F5 as logistic parameters (a, b) , and observe cells F14:F51 showing selectivity of each fish length calculated from logistic parameters and Figure. You can find selectivity values and logistic curve change, and the log-likelihood in target cell H7 that should be maximized also varies. Before you start to use Solver, you may try your hand at maximizing the log-likelihood or likelihood manually by entering values in cells F4:F5, if you have lots of spare time. But probably it is almost impossible to get the solution manually. Solver requires initial values in changing cells, cells F4:F5. Initial values for logistic parameter as selectivity curve could be calculated from L50% and Selection range (see section 6.2.1.1 in left column of p.40, ICES manual). Values of L50% and Selection range could be approximated by eye from the plots of proportion retained in the Figure of this figure. When the approximates of L50% and Selection range is set in cells J4:J5, cells N4:N5 give initial values. Lets start Solver. Please select Tools and then Solver to start solver. Excel displays its Solver Parameters dialog box. When Excel displays its Solver Parameters dialog box, please skip this paragraph. If the Tools menu does not show a Solver command, you need to install the Solver before you can use it. Solver is an add-in, so its available only when the add-in is installed, and usually the standard install does not install Solver in Excel on your PC. Select Tools, Add-ins, and Excel displays its Add-ins dialog box. Scroll down the list of add-ins, and place a check mark next to the item named Solver Add-in. Click on OK, and Excel installs the add-in and makes the Solver command available. If Solver Add-in does not appear in the list, you need to run Excels Setup program (or the Setup program for MS Office). Use the Custom option, and specify that Solver be installed. ^_mn-.Z[bcapg j   4 5 A B D i k  . /   &*abhiABHI} ()/0ABGHRSYZPJo(PJ6o(o(`-. k l @A:PH$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx-. k l @AZABHIbcij~  12DEBC5 7:::??@?|GnIL.L2L@LDLLLLLnMzMMMMMUUU&X*X8X:XvXxXXXdYpYYYYYccdd(d*de 5PJo(5o(PJo(o(^55,5.57 784=6=??@BBBdCfCFFzG:PH$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx so happy if you could put my paper on the reference list of your paper when you utilize this method for selectivity data analysis. range A14:A**, catch number of codend and cover in the range B14:B** and C14:C**, respectively. The base line of the column D, E, F, H, and I must be adjusted to that of A, B and C with copy command if it is shorter or delete command if it is longer. EnsuzG|GGGGlInIJLLMM*P,PTTXTTTTU & F  & F:PH$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx1. objective function   (or )2. The basic procedure for using  Solver is as follows: Set up the worksheet with values and formulas. Enter (or cut and copy or paste) your data; length in the range A14:A**, catch number of codend and cover in the range B14:B** and C14:C**, respectively. And then the base line of the column D, E, F, H, and I must be adjusted to that of A, B and C with copy command if it is shorter or delete command if it is longer. Ensure that the range of the formula cover every value of log-likelihood The cell D14 calculates total catch number of the length by a formula C14+D14. The cells E14:E** contain proportion retained in the codend of each length only for plotting them in the figure, and have no relation with maximum likelihood calculation process. At the column F, values of retention probability of each length are estimated from the current values of logistic parameters cells F4:F5. The column H and I contains formulas of likelihood and log-likelihood of each length, respectively. Bring up the Solver dialog box. Specify the target cell. Specify the changing cells. Specify the constraints. Change the Solver options if necessary. Let Solver solve the problem. 4. re that the range of the formula cover every cell for log-likelihood of each length. Make a figure in which values of proportion retained in the codend are plotted against length. Estimate roughly L50 and selection length by eye from the figure, and enter has already beenother file for the SELECT modelisworksheet reference to orlogistic curve in the on this worksheet At the Solver Parameters dialog box, the target cell and the changing cells should be specified ( if necessary, constraints as well). On this worksheet, the target cell is H8, in which log-likelihood of each length in the range I14:I51 are summed up (see section 6.3.1 on pages 42 and 43 of ICES manual). (Although the equation (2) of p. 43 in ICES manual do not have Combination of nl+ and nl1, the log-likelihood of each length on this worksheet contains it because I would like to calculate the AIC values for selecting the appropriate model.) Enter (or point to ) cell H8 in the Set Target Cell field. Because the object is to maximize this cell, click on the Max option. Next, specify the changing cells, which are in the range F4:F5. If necessary, you can add constraints (e.g. F4<= 0, parameter  a of logistic equation must be negative) in the subject in the Constraints field. Let Solver solve the problem, Click on OK to return to the Solver Parameters dialog box. At this point, Solver knows everything about the problem. Click on the Solver button to start the solution process. You can watch the progress on-screen, and Excel soon announces that it has find a solution. The Solver Results dialog box is shown. At this point, click on OK, and the solver put in the changing cells the values that solver found out. You will find logistic curve fitted to the plots in the Figure of this worksheet, and values of logistic parameters very close to the results shown in Table 6.5.2b of the ICES manual. If you want to more precise solution, you can set Precision in the Solver Option dialog box which appear by click option button at the Solver Parameter dialog box. From the parameters estimates, L50 and Selection range are calculated in the cells F8:F9. I hope that you can understand the role of Solver for selectivity data analysis. solver You can spread freely the Excel worksheet and this note to anyone who want to use it. I would however be so happy if you could put my paper on the reference list of your paper when you utilize this method for selectivity data analysis. TFUUUUU:XX YBZx[*\\:^^dRddd & F & F8H$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx & F these values in the cells J4:J5 to obtain the initial values of logistic parameters a and b. Enter the initial values in the cells F4:F5. The cell D14 calculates total catch number of the length by a formula C14+D14. The cells E14:E** contain proportion retained in the codend of each length only for plotting them in the figure, and have no relation with maximum likelihood calculation process. At the column F, values of retention probability of each length are estimated from the current values of logistic parameters cells F4:F5. The column H and I contains formulas of likelihood and log-likelihood of each length, respectively. The cell H8 is the target cell which contains the objective function for maximum likelihood method, that is log-likelihood (sum of each length s log-likelihood values) which Solver make maximized And start  Solver as mentioned above; Bring up the Solver dialog box. Specify the target cell. Specify the changing cells. Specify the constraints. Change the Solver options if necessary. Let Solver solve the problem. J0]00O0C.C.selecto0q}00000s-plusn0 Ng0RD0f0J00(yo0sW0D0o0w0j0D0L0 Millarn0֊ej0i000h0) ]0S0g0o0GLML0(uD000f0D00S00k0[W0f0 S0n0exceln0worksheetk0J0D0f00000o0vck0$\^pe0g'Yk0Y00 Ype0c"}W0f0D00S0n0_00k0 ]00L0@\@bg0B00S'`L0B00S0n0_00k0 D0O0d0K0n0Rg$PK00n0{0Lc0f0 TX0$Pk0S_gY00K0xY00Y00_L0B00D0O0d0K0n0puj0c0_0S_g$P0__0j00p0 ]0n0F0a0g0[pe$\^L0g'Yn00n0 ~0_0o0AICL0g\n0S_g$P0c(uY00p00D0 S0n00000k0o0 3d0n0worksheetL0B00 ]00^00logitich0Richardh0encounter probability modelL0OH000W0_g0B00p0 ]00^00k0{W0f0 AIC0kW0f0g\h0j0c0_00000c(uY00p00D0 j0J0 S0n0worksheetg0o0 Bl0_000000n0c[$Pn0Rceo0+T~00f0D0j0D0_g0B00p0 fM0RH0_00n00\ObW0_0D0The SELECT model(un0worksheetg0o0 00000c[$Pn0]0{W0f0D00 PAGE 1 PAGE 4 Fw~wwx>x@xLzNzD{F{&|(|*|,|B|D|F|\|^|`|b|&`#$8H$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx & Fdd.eeeeee:j&kklmnhopqvvwFw & F8H$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx & F՜.+,D՜.+,P  hp  YwCmYw StI * Hello Steve, Title 6> _PID_GUIDAN{BE5700AE-C7D5-11D2-AF89-00C04FD59723}<@~ؘjlz|vx6|~6@ޞ4>@v8o( 0JmHnHPJo(PJ'b|d|Tڋ(d8H$7$8$ b @ @!%@)-04@8|@|B|F|H|T|V|X|Z|\|b|d|bj|~|~"$02^rjpRFHRT~ċ֋ڋ<>@BؐڐPJ 0JmHnH0J j0JU5o(o(PJo(Y@BBjOOO8H$7$8$ b @ @!%@)-04@8"""""g#m#z####!%$%,%5%f%l%%%%% & &&&(()))'@W]e k r u "nr *.UWcf.0Z^9!R!x"~"##$%,%6%7%;%&&E)J))))5#6#7#D#O#P#T#:B** and C14:C**, respectively. The base line of the column D, E, F, H, and I must be adjusted to that of A, B and C with copy command if it is shorter or delete command if it is longer. Ensure that the range of the formula cover every cell for log-likelihood of each length. Make a figure in which values of proportion retained in the codend are plotted against length. Estimate roughly L50 and selection length by eye from the figure, and enter these values in the cells J4:J5 to obtain the initial values of logistic parameters a and b. Enter the initial values in the cells F4:F5. The cell D14 calculates total catch number of the length by a formula C14+D14. The cells E14:E** contain proportion retained in the codend of each length only for plotting them in the figure, and have no relation with maximum likelihood calculation process. At the column F, values of retention probability of each length are estimated from the current values of logistic parameters cells F4:F5. The column H and I contains formulas of likelihood and log-likelihood of each length, respectively. The cell H8 is the target cell which contains the objective function for maximum likelihood method, that is log-likelihood (sum of each length s log-likelihood values) which Solver make maximized And start  Solver as mentioned above Bring up the Solver dialog box. Specify the target cell. Specify the changing cells. Specify the constraints. Change the Solver options if necessary. Let Solver solve the problem. qgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck2C:\WINDOWS\TEMP\Roxqo ^ How to use solver.asdqgwm ck2C:\WINDOWS\TEMP\Roxqo ^ How to use solver.asdqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck2C:\WINDOWS\TEMP\Roxqo ^ How to use solver.asdqgwm ck6C:\My Documents\Solver\English-v\How to use solver.docO :VO6 DaNuikbƤ#ggo(.=o()\o(.o() DaikbOO :@!!l+!!C$Eƀb'C$Eƀb' @BSVX[_bcgqr.23>NOS[_BC-67?@GHSTU^_`c;=>H`}Z \ ] c d 56DO[jn#16>DGHMYZeijkqrsx &5MNOXYZ\]^deqryz"01IQR`abcpuy"=@EFGMRSW\bcknotuvw"+,-./"#$%),13<>DUWYdef{| 5;<=DIZflmnty|  ,-=AFJTfgpq  )*.234:;?@`dijklpquyz~#024:`dkls'AESTUVeijklm !&GHefhilrs|}~Wpq|}!(.6789  4 ; D J i !!!9!C!s!{!!!!!!!!!!"1"^"s"x""#G#H#[#_#r#w#x#y#z######$$}&&&&&&&&&&&&&&''''0'C'^'_''''''' ( ( (((#($(%(C(`(c(t(y(~((((((((((((((((((((^)q)r)))))))))))))))))))))1011111@11@11@11@11@1111ؐ1ڐ1@1ܐ1 @1ސ1l @            @@@ Zed|4zGTdFwb|d|%+3?@Unknownqgwm ck !T!T"EHZ`ag SX6=   Q W  !!7#Q#T#|GM    x $(`dw{ Z[  ! " & ! !7#Q#T#qgwm ck%C:\My Documents\How to use solver.docqgwm ck%C:\My Documents\How to use solver.docqgwm ck2C:\WINDOWS\TEMP\Roxqo ^ How to use solver.asdqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docO :VO6 DaNuikbƤ#ggo(.=o()\o(.o() DaikbOO :@ )C$Eƀb'C$Eƀb'5:$-.67>?JKLUVWZz{+-.8Pmz#$3@GHIKL\]^_ux~)1PRVZm11 @11@1 @1 0 @11 @1@11818180 @0Z@1@1j1j1j1$j1@1&j1@1(j1*j1@1,j1.j10j1@16j0(@10@1b1j1l1j@1t1@1^81@1b81@1@1v80,@181 @1818181h@181t@1x1|1~110~ @081819191091N91V91|91~919191919191919191919191:1:1:1:1H:1N:1Z:1`:1b:1:1:1:1:1:1:1;1;1 ;1;1,;1.;1D;1L;1N;1P;1\;1^;1`;1j;1;1;1;1;1;1<1 <1<1<1<1<1=1=1=1*=1,=1.=02=04=16=1B=1D=1\=1^=1l=1n=18>1z>1|>1>1>1>1>1>1 ?1?1?1:?1?1@?1Z?1d?1l?1?1?1?1?0?0?1?1A1A1A10&B0@B1BB1ZB1jB1B1B1B1C1C1C1C1C1C1&C10C1C1NC1TC1VC1`C0bC0dC1fC1xC1C1C1C1C1D1D1ND1D1D1D1D1D1D1D1|E1~E1E1E1E1E1E1 F1 F1F0F0F08j1:j1vj1xj1j1j1j1j11j1j1<1j1j1j1j1k1k0$k1&k1*k1.k1Lk1Vk0k1k1k1k1k1>1k1k1k1k1k1l1l1l10l12l14l1^l1`l1nl1xl1zl1|l1l1l1l1l1l1l0l1l1l1H1l1l1l1l1l1l1l1m1m1m1m1&m1Fm1m1m1m1m1m1m1m0m1m1n1n1J1@n1b1Ln1Nn1Zn1dn1jn1n0n1n1n1n1n1n1n1n1n1n1n18o0fo1ho1jo1zo1o1o1o1o1o1o1o1o1p1p1>p1@p1Rp1Tp1zp0p1p1p1q1q0q1q1q1$q1&q1(q1*q1.q1@q1Bq1Pq1\q1jq1q1q1q1q1q1q1q1q1q1q1q1q1q1q12r1:r1Dr1Fr1Hr1Jr1Rr1Tr1\r1dr1fr1nr1vr1xr1r1r1s1s1s1 s1"s1$s1:s1s1Rs1|s1~s1s1s1s1s1s1s1s12t1:t1Ht1Jt1Xt1t1t1t1t1u1:u1u1@u1Bu1Du1Pu1Tu1Vu1Xu1u1u1u1v1v1v1v11@1B1D1v01ܟ1080R1\@1|G1@H1`H11H1H1H1H1H1H1H1H1I1@I1FI1HI1hI0 @11\@1G1@1̈1@11@1G1T@11G1G1G1G1G1G1G1H1:H11 111 1(1*1,1F1H1R1T1z1110011100100V1X0lI1,|16|1:|1<|1>|0@|0B|0D|1F|1P|1T|11X|0Z|0\|0^|00lIGTimes New Roman5Symbol3& Arial3 -3 fg75  -3 00007CenturyI FixedSys$*30000 qSh233f="I!3!%),.:;?]}  0 2 3 !000 0 0 00000000000 =]acde$([\{  0 0 0000;[b2d *f Hello Steve, qgwm ckqgwm ck1:1:1:1:1:1;1;1 ;1;1,;1.;1D;1L;1N;1P;1\;1^;1`;1j;1;1;1;1;1;1<1 <1<1<1<K PbjbjXXa2a2)]hiiiiii\p\p\p8p$pTi(:q:q(bqbqbqbqbqbqzzzzzzz$̞Xzb"ibqbqbqbqbqz.tiibqbqq".t.t.tbq6ibqibqziiiiiibqz.t.txr>zTiizbq q ;xevi\przRoot Entry 0eK FT[;xev|@1Tablec eK4WordDocumentQKmKfKeKvSummaryInformation (Y,@cK +00 :#" !,-$%&'()*+F./012348;A=P@>?}BCDEGQHJKMNOWaRSTUV5XYZ[\]^_`ibcdefghjklmnopqrstuw{~7<IDocumentSummaryInformationCU~1dK8U(CompObjA(T(&f0Table0Q%&9QKuDT(&H(  FMicrosoft Word MSWordDocWord.Document.89q՜.+,D՜.+,P  hp  YwCmYw StI * Hello Steve, Title 6> _PID them, I will re-arrange the worksheet. As I mentioned in the last e-mail, title who read my papers whom I told I also hope that many researchers utilize this  cheap method and develop their selectivity studies. 5 _GUIDAN{BE5700AE-C7D5-11D2-AF89-00C04FD59723}Oh+'0|  , 8 D P\dltHello Steve, oell C ve,C Normal.dot, C t,16CMicrosoft Word 8.0@Ld:@Gme@"[@lev="$([\{  0 0 0000;[b2dO% Hello Steve, qgwm ckqgwm ckokai@tokyo-u-fish.ac.jp TEL +81 3 5463 0474 FAX +81 3 5463 03991 ~ 0JmHnHPJo(PJ0XO8H$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx<G$H$7$8$ f8! @ @!%@)-04@8Q_p459?@AFHZ[\{| !()*./169<=BIJORSUX[\cdjkmorsvz| !"%.26=>EFOabefhknotxyz|}h!j!k!!!""F"G"H"I"J"L"_"`"a""""""""""""""##"###3#4#5#6#7#<#>#?#@#A#B#C#D#I#K#L#M#N#O#P#Q#R#S#0@1818180 @1 80R@1@1j1j1j1$j1@1&j1@1(j1*j1@1,j1.j10j1@16j0(@10@1^81@1b81@1@1v80,@181 @1818181h@180t@081819191091N91V91|91~919191919191919191919191:1:1:1:1H:1N:1Z:1`:1b:1:1:1:1:1:1:1;1;1 ;1;1,;1.;1D;1L;1N;1P;1\;1^;1`;1j;1;1;1;1;1;1<1 <1<1<1<1<1=1=1=1*=1,=1.=02=04=16=1B=1D=1\=1^=1l=1n=18>1z>1|>1>1>1>1>1>1 ?1?1?1:?1?1@?1Z?1d?1l?1?1?1?1?0?0?1?1A1A0A0@B1BB1ZB1jB1B1B1B1C1C1C1C1C1C1&C10C1C1NC1TC1VC1`C0bC0dC1fC1xC1C1C1C1C1D1D1ND1D1D1D1D1D1D1D1|E1~E1E1E1E1E1E1 F1 F1F0F0F08j1:j1vj1xj1j1j1j1j1j1j1j1k1k0$k1&k1*k1.k1Lk1Vk0k1k1k1k1k1k1k1k1k1l1l1l10l12l14l1^l1`l1nl1xl1zl1|l1l1l1l1l1l1l0l1l1l1l1l1l1l1l1l1m1m1m1m1&m1Fm1m1m1m1m1m1m1m1m0m1m1n1n1Nn1Zn1dn1jn1n0n1n1n1n1n1n1n1n1n1n1n18o0fo1ho1jo1zo1o1o1o1o1o1o1o1o1p1p1>p1@p1Rp1Tp1zp0p1p1p1q1q0q1q1q1$q1&q1(q1*q1.q1@q1Bq1Pq1\q1jq1q1q1q1q1q1q1q1q1q1q1q1q1q1q12r1:r1Dr1Fr1Hr1Jr1Rr1Tr1\r1dr1fr1nr1vr1xr1r1r1s1s1s1 s1"s1$s1:s1s1Rs1|s1~s1s1s1s1s1s1s1s12t1:t1Ht1Jt1Xt1t1t1t1t1u1:u1u1@u1Bu1Du1Pu1Tu1Vu1Xu1u1u1u1v1v1v1v1x1@x1Hx1Jx1Lx1Nx1Px1\x1^x1lx1nx1px1xx1zx1~x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1x1y1y1y1y1y1y1,y16y1@y1Fy1Ry1^y1fy1jy1ly1ry1~y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1y1z1z1z1$z1*z12z1:z0Hz0Lz1Nz1Rz1^z1`z1fz1xz1z1z1z1z1z1z1z1z1z1z1z1z1z1z1z1{1 {1{1{1{1{1{1*{12{1@{0B{0D{1F{1L{1P{1R{1X{1b{1f{1h{1n{1z{1{1{1{1{1{1{1{1{1{1{1{1{1{1{1|1|1|1"|0$|0&|0(|1\@1|G0G0 @1G1@1G1T@0G0G1G1G1G1G1G1G1G1H1:H1@H1PH1`H1H1H1H1H1H1H1H1H1I1@I1FI1HI1hI0jI0*|0lI1,|16|1:|1<|1>|0@|0B|0D|1F|1P|1T|1V|1X|0Z|0\|0^|0`|0lIGTimes New Roman5Symbol3& Arial3 -3 fg75  -3 00007CenturyI FixedSys$*30000 qSh22ƻ2 u!3!%),.:;?]}  0 2 3 !000 0 0 00000000000 =]a@@@@@@ Ze4JzGTdFwb|%+3?@GKUnknownqgwm DearMr Joel PradoI am not sure whether you remember selectivity-analysis tools that I talked in Thailand. MS-Excel with Solver, add-in soft is enough to analyze selectivity data. two ; and  SELECTmodel ,ainstuructione e  useSincerely, Tadashi TOKAI, PhD Associate Professor Tokyo University of Fisheries 4-5-7, Konan, Minato, Tokyo 108-8477, Japan tokai@tokyo-u-fish.ac.jp TEL +81 3 5463 0474 FAX +81 3 5463 03995 @B8H$7$8$ b  PP"%)P-148P<@CGPKORVPZ^aePimptPx<G$H$7$8$ f8! @ @!%@)-04@8BRovzE\]^fmnx ,1238;<=>@IJQW^loy5789:;FGHRghw{'6FGHIJKQSTU23KLefgh'(./0;EOP`bprstu   !#3HKNOWZ`oy   ? @ A B """""""""""####&#'#7#8#V#i#########0$2$3$4$6$I$J$K$i$$$$$$$$$$$$$$$$$$$$$$$$$%%%%%%%%%%%%%%%%%%%%%%%11 @10@1"1h11Њ1֊1>1B1d1@11@11@1j1@1r1@1t1~1111@11 @11l @11 @11@1 @1 0 @11 @1@11818180 @0Z@1@1j1j1j1$j1@1&j1@1(j1*j1@1,j1.j10j1@16j0(@10@1b1j1l1j@1t1@1^81@1b81@1@1v80,@181 @1818181h@181t@1x1|1~110~ @081819191091N91V91|91~919191919191919191919191:1:1:1:1H:1N:1Z:1`:1b:1:1:1:1:1:1:1;1;1 ;1;1,;1.;1D;1L;1N;1P;1\;1^;1`;1j;1;1;1;1;1;1<1 <1<1<1<1<1=1=1=1*=1,=1.=02=04=16=1B=1D=1\=1^=1l=1n=18>1z>1|>1>1>1>1>1>1 ?1?1?1:?1?1@?1Z?1d?1l?1?1?1?1?0?0?1?1A1A0A0@B1BB1ZB1jB1B1B1B1C1C1C1C1C1C1&C10C1C1NC1TC1VC1`C0bC0dC1fC1xC1C1C1C1C1D1D1ND1D1D1D1D1D1D1D1|E1~E1E1E1E1E1E1 F1 F1F0F0F08j1:j1vj1xj1j1j1j1j1j1<1j1j1j1j1k1k0$k1&k1*k1.k1Lk1Vk0k1k1k1k1k1>1k1k1k1k1k1l1l1l10l12l14l1^l1`l1nl1xl1zl1|l1l1l1l1l1l1l0l1l1l1H1l1l1l1l1l1l1l1m1m1m1m1&m1Fm1m1m1m1m1m1m1m0m1m1n1n1J1@n1b1Ln1Nn1Zn1dn1jn1n0n1n1n1n1n1n1n1n1n1n1n18o0fo1ho1jo1zo1o1o1o1o1o1o1o1o1p1p1>p1@p1Rp1Tp1zp0p1p1p1q1q0q1q1q1$q1&q1(q1*q1.q1@q1Bq1Pq1\q1jq1q1q1q1q1q1q1q1q1q1q1q1q1q1q12r1:r1Dr1Fr1Hr1Jr1Rr1Tr1\r1dr1fr1nr1vr1xr1r1r1s1s1s1 s1"s1$s1:s1s1Rs1|s1~s1s1s1s1s1s1s1s12t1:t1Ht1Jt1Xt1t1t1t1t1u1:u1u1@u1Bu1Du1Pu1Tu1Vu1Xu1u1u1u1v1v1v1v1|0@|0B|0D|1F|1P|1T|1<1X|0Z|0\|0^|0>0lIGTimes New Roman5Symbol3& Arial3 -3 fg75  -3 00007CenturyI FixedSys$*30000 qSh23f2sB!3!%),.:;?]}  0 2 3 !000 0 0 00000000000 =]acde$([\{  0 0 0000;[b2d%& Hello Steve, qgwm ckqgwm ckPQR S"W&[%^Q Q[`WW[TYST![&]%\%\)_S$Y'^$]#\#\(_*`P+d,cYXVY/kV Y PV =4*XK=fL:_P6^cDkhýͿϿϿK tPbjbjXXa2a2%]3444444:::8:;D4d;;(;;;;;;DDDDDDD$Jf>hXD4;;;;;D0>44;;b;"0>0>0>;4;4;D444444;D0>0> CrPDT44D;V; `ye4:<~DRoot Entry 0eK FT[`ye@1Tablec eKi[WordDocumentQKmKfKeKSummaryInformation (Y,@cK +00DocumentSummaryInformationCU~1dK8U(CompObjA(T(&f0Table0Q%&9hQKuDT(&H(  FMicrosoft Word MSWordDocWord.Document.89q՜.+,D՜.+,P  hp  YwCmYw StB%& Hello Steve, Title 6> _PID_GUIDAN{BE5700AE-C7D5-11D2-AF89-00C04FD59723}Oh+'0|  , 8 D P\dltHello Steve, oell C ve,C Normal.dot, C t,14CMicrosoft Word 8.0@78@j[@"[@Gmes :#" !,-$%&'()*+F./0123487=P>?}BCDEGQHIJKMNOWaRSTUV5XYZ[\]^_`~bcdefghjklmnopqrstuvwxyz{|A\How to use solver.docqgwm ck2C:\WINDOWS\TEMP\Roxqo ^ How to use solver.asdqgwm ck2C:\WINDOWS\TEMP\Roxqo ^ How to use solver.asdqgwm ck8C:\My Documents\Solver\ML-logistic\How to use solver.docO :VO6 DaNuikbƤ#ggo(.=o()\o(.o() DaikbOO :@ ) C$Eƀb'C$Eƀb' @BSVX[_bcgqr.23>NOS[_BC-67?@GHSTU^_`c;=>H`}Z \ ] c d 56DO[jn#16>DGHMYZeijkqrsx &5MNOXYZ\]^deqryz"01IQR`abcpuy!<?DEFLQRV[abjmnstuv !*+,-. !"#'*/1:<BSUWbcdyz 39:;BGXdjklrwz  *+;?DHRdeno '(,01289=>^bghijnoswx|!.028^bijq%?CQRSTcghijk$EFcdfgjpqz{|}~ Tmnyz %+3456?"A"I"o"u"""""""""""""""# #!#N#Z#j#m###########$"$%$6$;$@$A$E$F$G$T$U$Z$[$n$u$$$$$$$$$$ %3%4%G%H%M%O%P%Q%R%S%T%U%Z%\%]%^%_%`%a%b%c%d%0011111@11@11@11@11@1111ؐ1ڐ1@1ܐ1 @1ސ1l @11 @11@1 @1 0 @11 @1@11818180 @0Z@1@1j1j1j1$j1@1&j1@1(j1*j1@1,j1.j10j1@16j0(@10@1b1j1l1j@1t1@1^81@1b81@1@1v80,@181 @1818181h@181t@1x1|1~110~ @081819191091N91V91|91~919191919191919191919191:1:1:1:1H:1N:1Z:1`:1b:1:1:1:1:1:1:1;1;1 ;1;1,;1.;1D;1L;1N;1P;1\;1^;1`;1j;1;1;1;1;1;1<1 <1<1<1<1<1=1=1=1*=1,=1.=02=04=16=1B=1D=1\=1^=1l=1n=18>1z>1|>1>1>1>1>1>1 ?1?1?1:?1?1@?1Z?1d?1l?1?1?1?1?0?0?1?1A1A0A0@B1BB1ZB1jB1B1B1B1C1C1C1C1C1C1&C10C1C1NC1TC1VC1`C0bC0dC1fC1xC1C1C1C1C1D1D1ND1D1D1D1D1D1D1D1|E1~E1E1E1E1E1E1 F1 F1F0F0F08j1:j1vj1xj1j1j1j1j1j1<1j1j1j1j1k1k0$k1&k1*k1.k1Lk1Vk0k1k1k1k1k1>1k1k1k1k1k1l1l1l10l12l14l1^l1`l1nl1xl1zl1|l1l1l1l1l1l1l0l1l1l1H1l1l1l1l1l1l1l1m1m1m1m1&m1Fm1m1m1m1m1m1m1m0m1m1n1n1J1@n1b1Ln1Nn1Zn1dn1jn1n0n1n1n1n1n1n1n1n1n1n1n18o0fo1ho1jo1zo1o1o1o1o1o1o1o1o1p1p1>p1@p1Rp1Tp1zp0p1p1p1q1q0q1q1q1$q1&q1(q1*q1.q1@q1Bq1Pq1\q1jq1q1q1q1q1q1q1q1q1q1q1q1q1q1q12r1:r1Dr1Fr1Hr1Jr1Rr1Tr1\r1dr1fr1nr1vr1xr1r1r1s1s1s1 s1"s1$s1:s1s1Rs1|s1~s1s1s1s1s1s1s1s12t1:t1Ht1Jt1Xt1t1t1t1t1u1:u1u1@u1Bu1Du1Pu1Tu1Vu1Xu1u1u1u1v1v1v1v1|0@|0B|0D|1F|1P|1T|1~1X|0Z|0\|0^|00lIGTimes New Roman5Symbol3& Arial3 -3 fg75  -3 00007CenturyI FixedSys$*30000 1Sh23f3fdA!3!%),.:;?]}  0 2 3 !000 0 0 00000000000 =]acde$([\{  0 0 0000;[bd% Hello Steve, qgwm ckqgwm ck LUBLIVE  OUNTER KFOREVER M INDEX SEX  PHOTOSHOW  TORIES TEEN RAY XG NX  ZPOKX