ࡱ> VY  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUXR FWWorkbookSummaryInformation(DocumentSummaryInformation8 CC\ptemprt K Colwell Ba=  ThisWorkbook=p0\98X@"1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1He0}fԚ1 He0}fԚ1=He0}fԚ1He0}fԚ1HTimes New Roman1HTimes New Roman1 HTimes New Roman1HTimes New Roman1 HTimes New Roman1 HTimes New Roman1 HTimes New Roman"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.0050_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "US$"#,##0_);\("US$"#,##0\)% "US$"#,##0_);[Red]\("US$"#,##0\)&!"US$"#,##0.00_);\("US$"#,##0.00\)+&"US$"#,##0.00_);[Red]\("US$"#,##0.00\) 0.000_  0.00_  0.0_ 0_  0.0000_ 0.000_);[Red]\(0.000\)!0.000000_);[Red]\(0.000000\) 0.000000_                        " 1! " 1"  H+  H+ "\+   # #8 !@ @ * "@ @ * !  H/ !\/ ! ! ! ! 1!\/ !\/ !X ! "\+   !x@ @ * !X !X/ #X !<@ !< !< !x  8dq:F3ffff̙̙3f3fff3f3f33333f33333\`Abundance Data]Incidence Data߮H3 A@@  4&CNOTE:To run the case (g<1), you must first run the first part (g=1) 7s Data input  7s f1= 7sx min. in plot= 7s f2= 7sx max. in plot= 7sn= 7s h(x)=2f1(1+x) 7s v(x)=exp(x*2f2/f1)  7sx 7sh(x) 7sv(x) 7s f0= 7sq0=(1) First Part (g=1) 7s$Use Newton Method to solve h(x)=v(x) 7s initial x0=   7s Iteration 7sx* 7sx*= 7sm=nx*= 7s(2) Second Part (g<1) 7sg= 7s Data input: 7s T (optional) 7s Q1= 7 Q2= 7t= 7 mg=nx*= 7 Sobs= 7 Sest= 7 f0= 7 Sobs= 7 Sest= 7m=tx*= 7 mg=tx*= 7 h(x)=2*Q1(1+x)  7! v(x)=exp(x*2Q2/((1-1/t)Q1+2Q2/t))  7" tj:=Y3@b @XbX" e ~Ntan@ ˿@e*< ~Ntan@c TX^b Ub4bNOo п XyzOe枰 )ȞL z|X T>?^=nPUyOJȿ`4xpzUvH=nPpOJȿO`@.MP\_TX`ɥJdp{N}J@Pj.MP@_TPX`ɒ,N@pB `H {N~x ڿxPN0J@P|pj~Pt.MPOp,zH04LHP,zH~P~Oxx t.MPN\J@P|Hj~Xyzx{Ncc CC Dr3DF  dMbP?_*+%," dXX??U } } } } } U } *} D,,TTTTT T" T , , ,T,,,,,,,,,,,,,,,,,    ~ !@ ~ "?  ~ !@ ~ "@  ~ ! d@    ~ !"@     U4&@ ?D DD "(S_obs must be keyed in)B?D*.@DD.Ըd@ DDDA  5@vD FD DDDDD""(S_obs must be keyed in)B, }ylE? DDD; u_[4.@   C;DL 6U;@  " C;LDDA Q 6V ?;D DD(n must be keyed in)B 8؊?   C:LDD; <"h.@   6:9@   # }ylE?   _[4.@   &s(@   $ % pR?   }ylE.@   -- @   &  'u_[?   IݗV/@   IϐË @  ~ !@؊? <"h8/@ jē @   DpR? 3}yl/@ :qO!@ ~ ?A0@D ? DA lDDDDDDADDDDADD " Bc+? ؊/@ ]!@ ~ @8ށ@D ? DA lDDDDDDADDDDADD " B|ylEp? [4/@ YLK"@ ~ @O@D ? DA lDDDDDDADDDDADD " BN8'@  )pR? L<"1@ NI['@  *+hEpR? N<1@ #MK(@  ~ !W@N,?, , n"0 0 0( g must be greater than D :D ? DDB " B )BPO&0 0 0( g must be greater than 0.800 ) c+?   |ylEp1@   6 jk)@!  !!-q;?? DD tD XD ? 6DDD DDA$B " " B!Iݗ3@(7 7 :Ŗ_5@(8 8c+@8 8؊3@8 85@(9 9؊@9 9"h83@9 9w\6@(: : >tlEpR@> >W4}4@> > 4^ 9@? ?V 'u@(? ?AIݗ4@? ?p [ݛ9@@ Dlf]]]]]]]]]]]]]]]]]]]]]]]]]]]]@,A,B,C,@AIݗ@@ @pR4@(@ @;1:@(A A^+@A A4@A A,&:@B BAI@(B BApR4@(B B>7g;@C C@C C4@C C<@(C  <]]](  p  6NMM?"- ]`"a  CC" dXX??3h \ h \ h XPH 0(  V3d&>23 P P PWZZ.D^ TzC0G?@TNLȯ?@.QBH$zB]@AА Ռ?B]@D$ B/DDF,ݾ@DDАUDWduvUpl((v-v-^(Vel(D?FmnkrPstrkstrkl \ٙG@truefontАG@Y?/"@"B8P@HHgdta P(D|(pathcfmt(D|( B@"$V5VP(D(DH(v-(D0VV.8)!9@(DА@0@)!9@(D`v-v-^Xg|(*.88 "(Dv-(Dv-PH(v-(Dv-PH(P(Dv-(Dv-G@8АG@@?H(P 0X/"@"8PW0>P8CACACđ(A @0>А @[?@ 0/(-0/({m0t\?Yp.6Nb"֒?-Yp.6$v-8(Ypw)$8BB`Y/B "$8B 9@А 9@ 1@Sg`!:@PА`!:@?PK``Sp-Ǖ?@N0Æ=?(v-.! =`I.@NX;xx@As0@?.8?8?U8G@@?"АG@?@Q4pG@@@r@ĀАG@@@ fNeU??v-v-^[k`@@@R "(9@А9@)\?K @А89@/"@HBА9@ @Kp@""v-[/B "8 @P @( @*@jА[ >.8۝ @P8?ܿS$" B?'t @QDSo"\/B "8{B^8 P@!MP@P8 @.nO8(@)0`\ez\0>.8`@۝ @@PА@۝ @ $@=\)@A|MP'] qMPo@P@-@@"$v-88(N]/B@"$8또(|@@_qC@t]j.8 @N`N V(UTshmol(U""BP?=\) Nf?@oo@@oAS?`_P?@@۝ @v-v-^4k_ @@_qC@tC• @OА @@? @ @O0@zd]~[?O0@N6/?>?!-}?NL>?O(O(O(|@@۝ @?А@۝ @ @@ZOXW4shmolR R R RT TUU NMSS4 <<3Q1: h(x)Q ;CQ ;CQ3_  R R R RT TUU NM   dT TUUSS4ESS 4 <<3Q1: v(x)Q ;CQ ;CQ3_ !R R R RT TUU NM  ! dT TUUSS4ESS 4D$% M3O&Q4$% M3O&Q4FAm 3OY3 bM&43*N! R RR RT TUUSS4% `+xuM3O &Q x'4523 R RT TUU NMSS43" R RT TUUd3Ox% M3O&Q423 R R R RT TUU NMSS4SS 4SS4SS4SS 4<eee >@@7 Sheet1gg@ CC Dw^}   dMbP?_*+%," dXX??U } } }  }  }  } } D,@,,Ѝ,L/aBTcnBTT~T TO T܃ T , , ,T,,,,,,Ў E,|A,Ў4B,,,4-,,P|A,PB@,@4B,f, dgZFCNOTE:To run the case (g<1), you must first run the first part (g=1)./  ~ 0R@ ~ !@ ~ "$@ ~ !@ ~ "@ ~ !0@ $ %  ~ !4@     ![45@EDD DD "(S_obs must be keyed in)B?D*!@DDNG7? 8DDDDDDA   7?D D hD *DDDDD,DDDD" ""(S_obs must be keyed in)B i ?   ( LDD; ;M"@   C;DL (b?  B C;8LDDDDDA W 6qq?AD DD$Please key in T in cell B4B Y?H ?   'i"@   #VL?   1 x*?   oP%#@   V\?   $j Z (1) First Part (g=1) 2 AI?   ="h8#@    AM?   & o?   f -$@   K$?  ~ !?9=? Dg$@ qLF?   .& ?  4%@ d-@ ~ ?v1? D ? DA DDDDDDDDDADDDDDDDADDDDD " BK\? ҫ6׸%@ 7{@ ~ @(? D ? DA DDDDDDDDDADDDDDDDADDDDD " B"h8? N<&@ R5W@ ~ @lVKN? D ? DA DDDDDDDDDADDDDDDDADDDDD " Bńw? 1a&@  @ ~ @R9I? D ? DA DDDDDDDDDADDDDDDDADDDDD " BhJF9? ZQD'@ Ϋ{$@ ~ @Yc.I? D ? DA DDDDDDDDDADDDDDDDADDDDD " B !? 4v'@ Q@ ~ @.I? D ? DA DDDDDDDDDADDDDDDDADDDDD " BWmq? 6׸]L(@ Aȩ- @ ~ @.I? D ? DA DDDDDDDDDADDDDDDDADDDDD " B؊? }ylE(@ Pl- @ ~  @.I? D ? DA DDDDDDDDDADDDDDDDADDDDD " B7@Z?  -T)@ GjT@ ~ "@.I? D ? DA DDDDDDDDDADDDDDDDADDDDD " BM|)? & )@ KR@ ~ $@.I? D ? DA DDDDDDDDDADDDDDDDADDDDD " B? PS`[*@ o @  '.I?D ? gDA HDDAD-C6?  $Not converge!!" " B4vȿ? x;*@ l񵂃@  "(.I4@"D ? DA DDAD-C6? ID DD(Change initial and try again!!"(Change initial and try again!!" " BCIݗ? c+@ fT[@  )QDg? (G+@ x0e@  )ҫ6? oUk,@ ԑݕ@ *`1Z(2) Second Part (g<1)+9n?  ,@ ;c@  ~ !W@[z? F-js-@ hY~S@  Dl} 888F kkyy Zkk ,@!,"TЍ#,L/aB$,cnB%,&,~', (,O),܃*,+,,,-,.,/,0,1,2,3,4,Ў E5,|A6,Ў4B7,8,9,4-:,;,P|A<,PB@=,@4B>,f?,  ,`Xn 0 0 0( g must be greater than D :D ? DDB " B )BPO&0 0 0( g must be greater than 0.930 ) ݊?   nEpR-@   wDi@!  !3`!'d=J? JDD +D D"D "  B!/Ht?! !r$:{.@! !h @"  "#"(d=J@!DD D D ? |DDDDDDDDADDDDA$B " " B")C?" "!.@" " !@# #5n?# # /@# ##3V>W"@$ $bY??$ $ x0@$ $ *#@% %;؊?% %}ylE0@% %_?%@& &d?& &2NS`0@& &|Ks&@' '7@Z?' ' -T0@' 'η(@( (~ ?( ([?H 1@( (Q%*@) )ńw?)) )CLDD;)b;M1@) )pZ,@* * 'u_?*)*/1@* *D3cm#.@+ +1T(G?+)+d#1@+ +PC0@, ,Zk.&?,),5n2@, ,Oqd1@- - ?-)-BH U2@- -At3%3@. .)C-?.).!2@. .J3#4@/ /pR?/)/j82@/ /–.6@0 05?0)0[z3@0 0gM7@1 1'^?1)1K\3@1 1r<09@2 2PF9=?2)2(Ξ3@(2 21]O;@3 3yń?(3)3b3@3 3=@4 4}ylE?4)4Q<"4@(4 4pDSv@@5 5 -T?(5)5 d4@5 5*?A@6 6b;M?6)6z1a4@(6 640 B@7 7d#?(7)7U2ʑ4@7 71^1C@8 8FH U?8)8x*5@8 8wAE@9 9o8?(9)98}yl5@9 9o׶'G@: :K\?:):̿Wm5@(: :}YkH@; ;b?(;);`v1a5@; ;2ߔJ@< < d?<)<H U26@(< <{`L@= =U2ʑ?(=)=*Ht6@= =FG; O@> ><}yl?>)><6@(> >ujP@? ?ev1a?(?)?q06@? ?R@@ Dlf]]]]]]]]]]]]]]]]]]]]]]]]]]]]@,@A,B,ЍC,L/aB@*Ht?(@)@Gr$:7@@ @:ƟaS@(A Aq0?A)Aܸ]L|7@A AHP8CACACđ(A @0>А @[?@ 0/(-0/({m0t\?Yp.6Nb"֒?-Yp.6$v-8(Ypw)$8BB`Y/B "$8B 9@А 9@ 1@Sg`!:@PА`!:@?PK``Sp-Ǖ?@N0Æ=?(v-.! =`I.@NX;xx@As0@?.8?8?U8G@@?"АG@?@Q4pG@@@r@ĀАG@@@ fNeU??v-v-^[k`@@@R "(9@А9@)\?K @А89@/"@HBА9@ @Kp@""v-[/B "8 @P @( @*@jА[ >.8۝ @P8?ܿS$" B?'t @QDSo"\/B "8{B^8 P@!MP@P8 @.nO8(@)0`\ez\0>.8`@۝ @@PА@۝ @ $@=\)@A|MP'] qMPo@P@-@@"$v-88(N]/B@"$8또(|@@_qC@t]j.8 @N`N V(UTshmol(U""BP?=\) Nf?@oo@@oAS?`_P?@@۝ @v-v-^4k_ @@_qC@tC• @OА @@? @ @O0@zd]~[?O0@N6/?>?!-}?NL>?O(O(O(|@@۝ @?А@۝ @ @@ZOXW4shmolR R R RT TUU NMSS4 <<3Q1: h(x)Q ;CQ ;CQ3_  R R R RT TUU NM   dT TUUSS4ESS 4 <<3Q1: v(x)Q ;CQ ;CQ3_ !R R R RT TUU NM  ! dT TUUSS4ESS 4D$% M3O& Q4$% M3O& Q4FA0| 3OY3 bM& 43*N! R RR RT TUUSS4% S$w|M3O & Q x'4523 R RT TUU NMSS43" R RT TUUX3Oz% M3O&Q423 R R R RT TUU NMSS4SS 4SS4SS4SS 4<eee >@@7 Sheet3   Oh+'0HP\x 'Robert K ColwellMicrosoft Excel@hZL@Q@  ՜.+,0 PXd lt| ' Abundance DataIncidence Data  Worksheets FMicrosoft Excel Worksheet8FIBExcel.Sheet.8CompObj X