/y/R/X/J/?w/J/?J/J/?J /J /?J /?J /?J///4/4/4/4/4/4 /4!/4"/4#/4$/4%/4&/4'/4(/4)/4*/4+/4,/4-/4./4//40/41/42/43/44/45/46/47/48/49/4:/4;/4</4=/4>/4?/4@/4A/4B/4C/4D/4E/4F/4G/4H/4I/4J/4K/4L/4M/4N/4O/4P/4Q/4R/4S/4T/4U/4V/4W/4X/4Y/4Z/4[/4\/4]/4^/4_/4`/4a/4b/4c/4d/4e/4f/4g/4/9/!//////2/// 3/ (u PVVlVVJJ J J  J  J CALCcN[^ CLEARcN[y MNCLEARN17 PVSTARN RVSTARN SSTARNTW USTARNTW G9ARN G:ARN G?ARN GFARN GGARN GRARN G[ARN G9ARN   G:ARN   G?ARN   GRARN   G[ARN  G9ARN G:ARN G?ARN GRARN   G[ARN G9ARN G:ARN G?ARN GRARN G[ARN G9ARN G:ARN G?ARN GRARN G[ARN G9ARN G:ARN G?ARN GRARN G[ARN G9ARN G:ARN   G?ARN GRARN G[ARN   G9ARN##  G:ARN$$  G?ARN""  GRARN!!  G[ARN"$  G9ARN''  G:ARN((  G?ARN&&  GRARN%%  G[ARN&( CBCOPYNyy GC0PYN  RN0PYNCALC!  vstar ? @VLBLBq+q+q+CHART 1bq+q+q+CHART 2bq+q+q+CHART 3bq+q+q+CHART 4bq+q+q+CHART 5bq+q+q+CHART 6bq+q+q+CHART 7bq+q+q+ CHART 8bq+q+q+ CHART 9bq+q+q+ 6poolcalc 6poolplot6reach mean6instructions Arial" Arial# Arial$ Arial% Arial& Arial'  Arial' _$9%_'(_*"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefinedq0*q0*+K<&~p!1* 3*#1*DD 3*#(4*"########"""$"###h5*q0*(CP7 Ku !1* 3*#1*DD 3*#(4*"########"""$"###h5*q0*p#>3.kA|p`1* 3*#1*DD 3*#(4*"########"""$"###h5*q0*$N`5ަ@ͮ`~c@ !1* 3*#1*DD 3*#(4*"########"""$$###h5*q0*p!P5nyr!1* 3*#1*DD 3*#(4*"########"""$"###h5*q0* @4^Ót!1* 3*#1*DD 3*#(4*"########"""$$###h5*q0*P$.B; hyv~!1* 3*#1*DD 3*#(4*"########"""$"###h5*q0* +\.(Хkp!1*  3* #1* DD 3* #(4* "########"""$"###h5* q0*  .G\!1*  3* #1* DD 3* #(4* "########"""%%###h5*  @ 1@@@@@@@@@@@@@@@@ @@@@  @  @ @ @        !" #"$#%!&$'&(')%*(+*,+-).,/.0/1-2032 4@ 565768798:9 ST UVWXW YZY[\][^\_]`_ abacbdcedfegfhgihjikjlkmlnmonpoqprqsrtsutvuwvxwyxzy{z|{}|~}~` ` ' ' @             !585l``````` ` ` ` ` `` ' @` ''pool no.'tot. water'tot. fines'V* 'status 'sealedMM$ 'Creek 'Pool 'rcd (m)'length(m)  '# xsecs 'Creek'transect 1 'xsec 1 4'xsec 1 N'xsec 1' dist on tran 'dist !"# $ % & ' ()*+,-./0123 4'dist56789 :! ;"!<#"=$#>%$?&%@'&A('B)(C*)D+*E,+F-,G.-H/.I0/J10K21L32M43 N'dist#O 5 ;#P 6 ;#Q 7 ;#R 8 ;#S 9 ;#T : ;#U ; ;#V  < ;#W  = ;#X  > ;#Y  ? ;#Z  @ ;#[ A ;#\ B ;#] C ;#^ D ;#_ E ;#` F ;#a G ;#b H ;#c I ;#d J ;#e K ;#f L ;g 'water d 'wat. d.*  ;*  ;*  ;*  ;*  ;*   ;*!  ;*"  ;*#    ;*$    ;*%    ;*&    ;*'    ;*(  ;*)  ;**  ;*+  ;*,  ;*-  ;*.  ;*/  ;*0  ;*1  ;*2  ;*3  ; 4'wat. d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'wat. d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'fines d.'fines d.- ;- ;- ;- ;- ;-    ;-!! !;-"" ";-## #  ;-$$ $  ;-%% %  ;-&& &  ;-'' '  ;-(( (;-)) );-** *;-++ +;-,, ,;--- -;-.. .;-// /;-00 0;-11 1;-22 2;-33 3;4'fines d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34N'fines d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ; 'trans 2 'xsec 2 4'xsec 2 N'xsec 2 ' dist 'dist             !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4'dist 5   6   7   8   9   : !  ; " ! < # " = $ # > % $ ? & % @ ' & A ( ' B ) ( C * ) D + * E , + F - , G . - H / . I 0 / J 1 0 K 2 1 L 3 2 M 4 3 N'dist# O   5 ;# P   6 ;# Q   7 ;# R   8 ;# S   9 ;# T   : ;# U   ; ;# V   < ;# W   = ;# X   > ;# Y   ? ;# Z   @ ;# [   A ;# \   B ;# ]   C ;# ^   D ;# _   E ;# `   F ;# a   G ;# b   H ;# c   I ;# d   J ;# e   K ;# f   L ; g 'water d 'w.d.*     ;*     ;*     ;*     ;*     ;*     ;* !    ;* "    ;* #    ;* $    ;* %    ;* &    ;* '    ;* (    ;* )    ;* *    ;* +    ;* ,    ;* -    ;* .    ;* /    ;* 0    ;* 1    ;* 2    ;* 3    ; 4'w.d.! 5  ! 6  ! 7  ! 8  ! 9  ! :  !! ; ! "! < " #! = # $! > $ %! ? % &! @ & '! A ' (! B ( )! C ) *! D * +! E + ,! F , -! G - .! H . /! I / 0! J 0 1! K 1 2! L 2 3! M 3 4 N'w.d.* O 5  5 O ;* P 6  6 P ;* Q 7  7 Q ;* R 8  8 R ;* S 9  9 S ;* T :  : T ;* U ;  ; U ;* V <  < V ;* W =  = W ;* X >  > X ;* Y ?  ? Y ;* Z @  @ Z ;* [ A  A [ ;* \ B  B \ ;* ] C  C ] ;* ^ D  D ^ ;* _ E  E _ ;* ` F  F ` ;* a G  G a ;* b H  H b ;* c I  I c ;* d J  J d ;* e K  K e ;* f L  L f ;* g M  M g ; 'fines d. 'f.d.-      ;-      ;-      ;-      ;-      ;-      ;- ! !  !  ;- " "  "  ;- # #  #  ;- $ $  $  ;- % %  %  ;- & &  &  ;- ' '  '  ;- ( (  (  ;- ) )  )  ;- * *  *  ;- + +  +  ;- , ,  ,  ;- - -  -  ;- . .  .  ;- / /  /  ;- 0 0  0  ;- 1 1  1  ;- 2 2  2  ;- 3 3  3  ; 4'f.d.! 5  ! 6  ! 7  ! 8  ! 9  ! :  !! ; ! "! < " #! = # $! > $ %! ? % &! @ & '! A ' (! B ( )! C ) *! D * +! E + ,! F , -! G - .! H . /! I / 0! J 0 1! K 1 2! L 2 3! M 3 4 N'f.d.* O 5  5 O ;* P 6  6 P ;* Q 7  7 Q ;* R 8  8 R ;* S 9  9 S ;* T :  : T ;* U ;  ; U ;* V <  < V ;* W =  = W ;* X >  > X ;* Y ?  ? Y ;* Z @  @ Z ;* [ A  A [ ;* \ B  B \ ;* ] C  C ] ;* ^ D  D ^ ;* _ E  E _ ;* ` F  F ` ;* a G  G a ;* b H  H b ;* c I  I c ;* d J  J d ;* e K  K e ;* f L  L f ;* g M  M g ; 'trans 3 'xsec 3 4'xsec 3 N'xsec 3 'xs dist 'dist !"# $ % & ' ()*+,-./0123 4'dist56789 :! ;"!<#"=$#>%$?&%@'&A('B)(C*)D+*E,+F-,G.-H/.I0/J10K21L32M43 N'dist#O 5 ;#P 6 ;#Q 7 ;#R 8 ;#S 9 ;#T : ;#U ; ;#V  < ;#W  = ;#X  > ;#Y  ? ;#Z  @ ;#[ A ;#\ B ;#] C ;#^ D ;#_ E ;#` F ;#a G ;#b H ;#c I ;#d J ;#e K ;#f L ;g 'water d 'w.d.*  ;*  ;*  ;*  ;*  ;*   ;*!  ;*"  ;*#    ;*$    ;*%    ;*&    ;*'    ;*(  ;*)  ;**  ;*+  ;*,  ;*-  ;*.  ;*/  ;*0  ;*1  ;*2  ;*3  ; 4'w.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'w.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'fines d. 'f.d.- ;- ;- ;- ;- ;-    ;-!! !;-"" ";-## #  ;-$$ $  ;-%% %  ;-&& &  ;-'' '  ;-(( (;-)) );-** *;-++ +;-,, ,;--- -;-.. .;-// /;-00 0;-11 1;-22 2;-33 3; 4'f.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'f.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'trans 4'xsec 44'xsec 4N'xsec 4 'xs dist 'dist !"# $ % & ' ()*+,-./0123 4'dist56789 :! ;"!<#"=$#>%$?&%@'&A('B)(C*)D+*E,+F-,G.-H/.I0/J10K21L32M43 N'dist#O 5 ;#P 6 ;#Q 7 ;#R 8 ;#S 9 ;#T : ;#U ; ;#V  < ;#W  = ;#X  > ;#Y  ? ;#Z  @ ;#[ A ;#\ B ;#] C ;#^ D ;#_ E ;#` F ;#a G ;#b H ;#c I ;#d J ;#e K ;#f L ;g 'water d 'w.d.*  ;*  ;*  ;*  ;*  ;*   ;*!  ;*"  ;*#    ;*$    ;*%    ;*&    ;*'    ;*(  ;*)  ;**  ;*+  ;*,  ;*-  ;*.  ;*/  ;*0  ;*1  ;*2  ;*3  ; 4'w.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'w.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'fines d. 'f.d.- ;- ;- ;- ;- ;-    ;-!! !;-"" ";-## #  ;-$$ $  ;-%% %  ;-&& &  ;-'' '  ;-(( (;-)) );-** *;-++ +;-,, ,;--- -;-.. .;-// /;-00 0;-11 1;-22 2;-33 3; 4'f.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'f.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'trans 5'xsec 54'xsec 5N'xsec 5 'xs dist 'dist !"# $ % & ' ()*+,-./0123 4'dist56789 :! ;"!<#"=$#>%$?&%@'&A('B)(C*)D+*E,+F-,G.-H/.I0/J10K21L32M43 N'dist#O 5 ;#P 6 ;#Q 7 ;#R 8 ;#S 9 ;#T : ;#U ; ;#V  < ;#W  = ;#X  > ;#Y  ? ;#Z  @ ;#[ A ;#\ B ;#] C ;#^ D ;#_ E ;#` F ;#a G ;#b H ;#c I ;#d J ;#e K ;#f L ;g 'water d 'w.d.*  ;*  ;*  ;*  ;*  ;*   ;*!  ;*"  ;*#    ;*$    ;*%    ;*&    ;*'    ;*(  ;*)  ;**  ;*+  ;*,  ;*-  ;*.  ;*/  ;*0  ;*1  ;*2  ;*3  ; 4'w.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'w.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'fines d. 'f.d.- ;- ;- ;- ;- ;-    ;-!! !;-"" ";-## #  ;-$$ $  ;-%% %  ;-&& &  ;-'' '  ;-(( (;-)) );-** *;-++ +;-,, ,;--- -;-.. .;-// /;-00 0;-11 1;-22 2;-33 3; 4'f.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'f.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'trans 6'xsec 64'xsec 6N'xsec 6 'dist 'dist !"# $ % & ' ()*+,-./0123 4'dist56789 :! ;"!<#"=$#>%$?&%@'&A('B)(C*)D+*E,+F-,G.-H/.I0/J10K21L32M43 N'dist#O 5 ;#P 6 ;#Q 7 ;#R 8 ;#S 9 ;#T : ;#U ; ;#V  < ;#W  = ;#X  > ;#Y  ? ;#Z  @ ;#[ A ;#\ B ;#] C ;#^ D ;#_ E ;#` F ;#a G ;#b H ;#c I ;#d J ;#e K ;#f L ;g 'w.d. 'w.d.*  ;*  ;*  ;*  ;*  ;*   ;*!  ;*"  ;*#    ;*$    ;*%    ;*&    ;*'    ;*(  ;*)  ;**  ;*+  ;*,  ;*-  ;*.  ;*/  ;*0  ;*1  ;*2  ;*3  ; 4'w.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'w.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ; 'f.d. 'f.d.- ;- ;- ;- ;- ;-    ;-!! !;-"" ";-## #  ;-$$ $  ;-%% %  ;-&& &  ;-'' '  ;-(( (;-)) );-** *;-++ +;-,, ,;--- -;-.. .;-// /;-00 0;-11 1;-22 2;-33 3; 4'f.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'f.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ;'trans 7'xsec 74'xsec 7N'xsec 7 'dist 'dist !"# $ % & ' ()*+,-./0123 4'dist56789 :! ;"!<#"=$#>%$?&%@'&A('B)(C*)D+*E,+F-,G.-H/.I0/J10K21L32M43 N'dist#O 5 ;#P 6 ;#Q 7 ;#R 8 ;#S 9 ;#T : ;#U ; ;#V  < ;#W  = ;#X  > ;#Y  ? ;#Z  @ ;#[ A ;#\ B ;#] C ;#^ D ;#_ E ;#` F ;#a G ;#b H ;#c I ;#d J ;#e K ;#f L ;g 'w.d. 'w.d.*  ;*  ;*  ;*  ;*  ;*   ;*!  ;*"  ;*#    ;*$    ;*%    ;*&    ;*'    ;*(  ;*)  ;**  ;*+  ;*,  ;*-  ;*.  ;*/  ;*0  ;*1  ;*2  ;*3  ; 4'w.d.!5!6!7!8!9 !: !!;!"!<"#!=#$!>$%!?%&!@&'!A'(!B()!C)*!D*+!E+,!F,-!G-.!H./!I/0!J01!K12!L23!M34 N'w.d.*O5 5O ;*P6 6P ;*Q7 7Q ;*R8 8R ;*S9 9S ;*T: :T ;*U; ;U ;*V< <V ;*W= =W ;*X> >X ;*Y? ?Y ;*Z@ @Z ;*[A A[ ;*\B B\ ;*]C C] ;*^D D^ ;*_E E_ ;*`F F` ;*aG Ga ;*bH Hb ;*cI Ic ;*dJ Jd ;*eK Ke ;*fL Lf ;*gM Mg ; 'f.d. 'f.d.-    ;-    ;-    ;-    ;-    ;-      ;- !! !  ;- "" "  ;- ## #  ;- $$ $  ;- %% %  ;- && &  ;- '' '  ;- (( (  ;- )) )  ;- ** *  ;- ++ +  ;- ,, ,  ;- -- -  ;- .. .  ;- // /  ;- 00 0  ;- 11 1  ;- 22 2  ;- 33 3  ; 4'f.d.! 5  ! 6  ! 7  ! 8  ! 9  ! :  !! ; ! "! < " #! = # $! > $ %! ? % &! @ & '! A ' (! B ( )! C ) *! D * +! E + ,! F , -! G - .! H . /! I / 0! J 0 1! K 1 2! L 2 3! M 3 4 N'f.d.* O 5  5O ;* P 6  6P ;* Q 7  7Q ;* R 8  8R ;* S 9  9S ;* T :  :T ;* U ;  ;U ;* V <  <V ;* W =  =W ;* X >  >X ;* Y ?  ?Y ;* Z @  @Z ;* [ A  A[ ;* \ B  B\ ;* ] C  C] ;* ^ D  D^ ;* _ E  E_ ;* ` F  F` ;* a G  Ga ;* b H  Hb ;* c I  Ic ;* d J  Jd ;* e K  Ke ;* f L  Lf ;* g M  Mg ;!'trans 8!'xsec 8!4'xsec 8!N'xsec 8 "'dist "'dist""""""""""" ""!"""""#" "$" "%" "&" "'" "("")""*""+"",""-"".""/""0""1""2""3" "4'dist"5"""6"""7"""8"""9" "":"!" ";"""!"<"#"""="$"#">"%"$"?"&"%"@"'"&"A"("'"B")"("C"*")"D"+"*"E","+"F"-","G"."-"H"/"."I"0"/"J"1"0"K"2"1"L"3"2"M"4"3 "N'dist#"O" "5 ;#"P" "6 ;#"Q" "7 ;#"R" "8 ;#"S" "9 ;#"T" ": ;#"U" "; ;#"V"  "< ;#"W"  "= ;#"X"  "> ;#"Y"  "? ;#"Z"  "@ ;#"[" "A ;#"\" "B ;#"]" "C ;#"^" "D ;#"_" "E ;#"`" "F ;#"a" "G ;#"b" "H ;#"c" "I ;#"d" "J ;#"e" "K ;#"f" "L ;"g #'w.d. #'w.d.*#" # ;*#" # ;*#" # ;*#" # ;*#" # ;*# " # ;*#!" # ;*#"" # ;*##"  #  ;*#$"  #  ;*#%"  #  ;*#&"  #  ;*#'"  #  ;*#(" # ;*#)" # ;*#*" # ;*#+" # ;*#," # ;*#-" # ;*#." # ;*#/" # ;*#0" # ;*#1" # ;*#2" # ;*#3" # ; #4'w.d.!#5##!#6##!#7##!#8##!#9## !#:# #!!#;#!#"!#<#"##!#=###$!#>#$#%!#?#%#&!#@#&#'!#A#'#(!#B#(#)!#C#)#*!#D#*#+!#E#+#,!#F#,#-!#G#-#.!#H#.#/!#I#/#0!#J#0#1!#K#1#2!#L#2#3!#M#3#4 #N'w.d.*#O#5 #5"O ;*#P#6 #6"P ;*#Q#7 #7"Q ;*#R#8 #8"R ;*#S#9 #9"S ;*#T#: #:"T ;*#U#; #;"U ;*#V#< #<"V ;*#W#= #="W ;*#X#> #>"X ;*#Y#? #?"Y ;*#Z#@ #@"Z ;*#[#A #A"[ ;*#\#B #B"\ ;*#]#C #C"] ;*#^#D #D"^ ;*#_#E #E"_ ;*#`#F #F"` ;*#a#G #G"a ;*#b#H #H"b ;*#c#I #I"c ;*#d#J #J"d ;*#e#K #K"e ;*#f#L #L"f ;*#g#M #M"g ; $'f.d. $'f.d.-$# $#$;-$# #$$;-$# #$$;-$# #$$;-$# #$$;-$ #  # $$;-$!#! #!$$;-$"#" #"$$;-$### ##$ $ ;-$$#$ #$$ $ ;-$%#% #%$ $ ;-$&#& #&$ $ ;-$'#' #'$ $ ;-$(#( #($$;-$)#) #)$$;-$*#* #*$$;-$+#+ #+$$;-$,#, #,$$;-$-#- #-$$;-$.#. #.$$;-$/#/ #/$$;-$0#0 #0$$;-$1#1 #1$$;-$2#2 #2$$;-$3#3 #3$$; $4'f.d.!$5$$!$6$$!$7$$!$8$$!$9$$ !$:$ $!!$;$!$"!$<$"$#!$=$#$$!$>$$$%!$?$%$&!$@$&$'!$A$'$(!$B$($)!$C$)$*!$D$*$+!$E$+$,!$F$,$-!$G$-$.!$H$.$/!$I$/$0!$J$0$1!$K$1$2!$L$2$3!$M$3$4 $N'f.d.*$O$5 $5"O ;*$P$6 $6"P ;*$Q$7 $7"Q ;*$R$8 $8"R ;*$S$9 $9"S ;*$T$: $:"T ;*$U$; $;"U ;*$V$< $<"V ;*$W$= $="W ;*$X$> $>"X ;*$Y$? $?"Y ;*$Z$@ $@"Z ;*$[$A $A"[ ;*$\$B $B"\ ;*$]$C $C"] ;*$^$D $D"^ ;*$_$E $E"_ ;*$`$F $F"` ;*$a$G $G"a ;*$b$H $H"b ;*$c$I $I"c ;*$d$J $J"d ;*$e$K $K"e ;*$f$L $L"f ;*$g$M $M"g ;%'trans 9%'xsec 9%4'xsec 9%N'xsec 9 &'dist &'dist&&&&&&&&&&& &&!&&"&&#& &$& &%& &&& &'& &(&&)&&*&&+&&,&&-&&.&&/&&0&&1&&2&&3& &4'dist&5&&&6&&&7&&&8&&&9& &&:&!& &;&"&!&<&#&"&=&$&#&>&%&$&?&&&%&@&'&&&A&(&'&B&)&(&C&*&)&D&+&*&E&,&+&F&-&,&G&.&-&H&/&.&I&0&/&J&1&0&K&2&1&L&3&2&M&4&3 &N'dist#&O& &5 ;#&P& &6 ;#&Q& &7 ;#&R& &8 ;#&S& &9 ;#&T& &: ;#&U& &; ;#&V&  &< ;#&W&  &= ;#&X&  &> ;#&Y&  &? ;#&Z&  &@ ;#&[& &A ;#&\& &B ;#&]& &C ;#&^& &D ;#&_& &E ;#&`& &F ;#&a& &G ;#&b& &H ;#&c& &I ;#&d& &J ;#&e& &K ;#&f& &L ;&g ''w.d. ''w.d.*'& ' ;*'& ' ;*'& ' ;*'& ' ;*'& ' ;*' & ' ;*'!& ' ;*'"& ' ;*'#&  '  ;*'$&  '  ;*'%&  '  ;*'&&  '  ;*''&  '  ;*'(& ' ;*')& ' ;*'*& ' ;*'+& ' ;*',& ' ;*'-& ' ;*'.& ' ;*'/& ' ;*'0& ' ;*'1& ' ;*'2& ' ;*'3& ' ; '4'w.d.!'5''!'6''!'7''!'8''!'9'' !':' '!!';'!'"!'<'"'#!'='#'$!'>'$'%!'?'%'&!'@'&''!'A'''(!'B'(')!'C')'*!'D'*'+!'E'+',!'F','-!'G'-'.!'H'.'/!'I'/'0!'J'0'1!'K'1'2!'L'2'3!'M'3'4 'N'w.d.*'O'5 '5&O ;*'P'6 '6&P ;*'Q'7 '7&Q ;*'R'8 '8&R ;*'S'9 '9&S ;*'T': ':&T ;*'U'; ';&U ;*'V'< '<&V ;*'W'= '=&W ;*'X'> '>&X ;*'Y'? '?&Y ;*'Z'@ '@&Z ;*'['A 'A&[ ;*'\'B 'B&\ ;*']'C 'C&] ;*'^'D 'D&^ ;*'_'E 'E&_ ;*'`'F 'F&` ;*'a'G 'G&a ;*'b'H 'H&b ;*'c'I 'I&c ;*'d'J 'J&d ;*'e'K 'K&e ;*'f'L 'L&f ;*'g'M 'M&g ; ('f.d. ('f.d.-(' ('(;-(' '((;-(' '((;-(' '((;-(' '((;-( '  ' ((;-(!'! '!((;-("'" '"((;-(#'# '#( ( ;-($'$ '$( ( ;-(%'% '%( ( ;-(&'& '&( ( ;-(''' ''( ( ;-(('( '(((;-()') ')((;-(*'* '*((;-(+'+ '+((;-(,', ',((;-(-'- '-((;-(.'. '.((;-(/'/ '/((;-(0'0 '0((;-(1'1 '1((;-(2'2 '2((;-(3'3 '3((; (4'f.d.!(5((!(6((!(7((!(8((!(9(( !(:( (!!(;(!("!(<("(#!(=(#($!(>($(%!(?(%(&!(@(&('!(A('((!(B((()!(C()(*!(D(*(+!(E(+(,!(F(,(-!(G(-(.!(H(.(/!(I(/(0!(J(0(1!(K(1(2!(L(2(3!(M(3(4 (N'f.d.*(O(5 (5&O ;*(P(6 (6&P ;*(Q(7 (7&Q ;*(R(8 (8&R ;*(S(9 (9&S ;*(T(: (:&T ;*(U(; (;&U ;*(V(< (<&V ;*(W(= (=&W ;*(X(> (>&X ;*(Y(? (?&Y ;*(Z(@ (@&Z ;*([(A (A&[ ;*(\(B (B&\ ;*(](C (C&] ;*(^(D (D&^ ;*(_(E (E&_ ;*(`(F (F&` ;*(a(G (G&a ;*(b(H (H&b ;*(c(I (I&c ;*(d(J (J&d ;*(e(K (K&e ;*(f(L (L&f ;*(g(M (M&g ;)'trans 10)'xsec 10)4'xsec 10)N'xsec 10 *'dist *'dist*********** **!**"**#* *$* *%* *&* *'* *(**)*****+**,**-**.**/**0**1**2**3* *4'dist*5***6***7***8***9* **:*!* *;*"*!*<*#*"*=*$*#*>*%*$*?*&*%*@*'*&*A*(*'*B*)*(*C***)*D*+***E*,*+*F*-*,*G*.*-*H*/*.*I*0*/*J*1*0*K*2*1*L*3*2*M*4*3 *N'dist#*O* *5 ;#*P* *6 ;#*Q* *7 ;#*R* *8 ;#*S* *9 ;#*T* *: ;#*U* *; ;#*V*  *< ;#*W*  *= ;#*X*  *> ;#*Y*  *? ;#*Z*  *@ ;#*[* *A ;#*\* *B ;#*]* *C ;#*^* *D ;#*_* *E ;#*`* *F ;#*a* *G ;#*b* *H ;#*c* *I ;#*d* *J ;#*e* *K ;#*f* *L ;*g +'w.d. +'w.d.*+* + ;*+* + ;*+* + ;*+* + ;*+* + ;*+ * + ;*+!* + ;*+"* + ;*+#*  +  ;*+$*  +  ;*+%*  +  ;*+&*  +  ;*+'*  +  ;*+(* + ;*+)* + ;*+** + ;*++* + ;*+,* + ;*+-* + ;*+.* + ;*+/* + ;*+0* + ;*+1* + ;*+2* + ;*+3* + ; +4'w.d.!+5++!+6++!+7++!+8++!+9++ !+:+ +!!+;+!+"!+<+"+#!+=+#+$!+>+$+%!+?+%+&!+@+&+'!+A+'+(!+B+(+)!+C+)+*!+D+*++!+E+++,!+F+,+-!+G+-+.!+H+.+/!+I+/+0!+J+0+1!+K+1+2!+L+2+3!+M+3+4 +N'w.d.*+O+5 +5*O ;*+P+6 +6*P ;*+Q+7 +7*Q ;*+R+8 +8*R ;*+S+9 +9*S ;*+T+: +:*T ;*+U+; +;*U ;*+V+< +<*V ;*+W+= +=*W ;*+X+> +>*X ;*+Y+? +?*Y ;*+Z+@ +@*Z ;*+[+A +A*[ ;*+\+B +B*\ ;*+]+C +C*] ;*+^+D +D*^ ;*+_+E +E*_ ;*+`+F +F*` ;*+a+G +G*a ;*+b+H +H*b ;*+c+I +I*c ;*+d+J +J*d ;*+e+K +K*e ;*+f+L +L*f ;*+g+M +M*g ; ,'f.d. ,'f.d.-,+ ,+,;-,+ +,,;-,+ +,,;-,+ +,,;-,+ +,,;-, +  + ,,;-,!+! +!,,;-,"+" +",,;-,#+# +#, , ;-,$+$ +$, , ;-,%+% +%, , ;-,&+& +&, , ;-,'+' +', , ;-,(+( +(,,;-,)+) +),,;-,*+* +*,,;-,+++ ++,,;-,,+, +,,,;-,-+- +-,,;-,.+. +.,,;-,/+/ +/,,;-,0+0 +0,,;-,1+1 +1,,;-,2+2 +2,,;-,3+3 +3,,; ,4'f.d.!,5,,!,6,,!,7,,!,8,,!,9,, !,:, ,!!,;,!,"!,<,",#!,=,#,$!,>,$,%!,?,%,&!,@,&,'!,A,',(!,B,(,)!,C,),*!,D,*,+!,E,+,,!,F,,,-!,G,-,.!,H,.,/!,I,/,0!,J,0,1!,K,1,2!,L,2,3!,M,3,4 ,N'f.d.*,O,5 ,5*O ;*,P,6 ,6*P ;*,Q,7 ,7*Q ;*,R,8 ,8*R ;*,S,9 ,9*S ;*,T,: ,:*T ;*,U,; ,;*U ;*,V,< ,<*V ;*,W,= ,=*W ;*,X,> ,>*X ;*,Y,? ,?*Y ;*,Z,@ ,@*Z ;*,[,A ,A*[ ;*,\,B ,B*\ ;*,],C ,C*] ;*,^,D ,D*^ ;*,_,E ,E*_ ;*,`,F ,F*` ;*,a,G ,G*a ;*,b,H ,H*b ;*,c,I ,I*c ;*,d,J ,J*d ;*,e,K ,K*e ;*,f,L ,L*f ;*,g,M ,M*g ;-'trans 11-'xsec 11-4'xsec 11-N'xsec 11 .'dist .'dist........... ..!.."..#. .$. .%. .&. .'. .(..)..*..+..,..-...../..0..1..2..3. .4'dist.5...6...7...8...9. ..:.!. .;.".!.<.#.".=.$.#.>.%.$.?.&.%.@.'.&.A.(.'.B.).(.C.*.).D.+.*.E.,.+.F.-.,.G...-.H./...I.0./.J.1.0.K.2.1.L.3.2.M.4.3 .N'dist#.O. .5 ;#.P. .6 ;#.Q. .7 ;#.R. .8 ;#.S. .9 ;#.T. .: ;#.U. .; ;#.V.  .< ;#.W.  .= ;#.X.  .> ;#.Y.  .? ;#.Z.  .@ ;#.[. .A ;#.\. .B ;#.]. .C ;#.^. .D ;#._. .E ;#.`. .F ;#.a. .G ;#.b. .H ;#.c. .I ;#.d. .J ;#.e. .K ;#.f. .L ;.g /'w.d. /'w.d.*/. / ;*/. / ;*/. / ;*/. / ;*/. / ;*/ . / ;*/!. / ;*/". / ;*/#.  /  ;*/$.  /  ;*/%.  /  ;*/&.  /  ;*/'.  /  ;*/(. / ;*/). / ;*/*. / ;*/+. / ;*/,. / ;*/-. / ;*/.. / ;*//. / ;*/0. / ;*/1. / ;*/2. / ;*/3. / ; /4'w.d.!/5//!/6//!/7//!/8//!/9// !/:/ /!!/;/!/"!/</"/#!/=/#/$!/>/$/%!/?/%/&!/@/&/'!/A/'/(!/B/(/)!/C/)/*!/D/*/+!/E/+/,!/F/,/-!/G/-/.!/H/.//!/I///0!/J/0/1!/K/1/2!/L/2/3!/M/3/4 /N'w.d.*/O/5 /5.O ;*/P/6 /6.P ;*/Q/7 /7.Q ;*/R/8 /8.R ;*/S/9 /9.S ;*/T/: /:.T ;*/U/; /;.U ;*/V/< /<.V ;*/W/= /=.W ;*/X/> />.X ;*/Y/? /?.Y ;*/Z/@ /@.Z ;*/[/A /A.[ ;*/\/B /B.\ ;*/]/C /C.] ;*/^/D /D.^ ;*/_/E /E._ ;*/`/F /F.` ;*/a/G /G.a ;*/b/H /H.b ;*/c/I /I.c ;*/d/J /J.d ;*/e/K /K.e ;*/f/L /L.f ;*/g/M /M.g ; 0'f.d. 0'f.d.-0/ 0/0;-0/ /00;-0/ /00;-0/ /00;-0/ /00;-0 /  / 00;-0!/! /!00;-0"/" /"00;-0#/# /#0 0 ;-0$/$ /$0 0 ;-0%/% /%0 0 ;-0&/& /&0 0 ;-0'/' /'0 0 ;-0(/( /(00;-0)/) /)00;-0*/* /*00;-0+/+ /+00;-0,/, /,00;-0-/- /-00;-0./. /.00;-0/// //00;-00/0 /000;-01/1 /100;-02/2 /200;-03/3 /300; 04'f.d.!0500!0600!0700!0800!0900 !0:0 0!!0;0!0"!0<0"0#!0=0#0$!0>0$0%!0?0%0&!0@0&0'!0A0'0(!0B0(0)!0C0)0*!0D0*0+!0E0+0,!0F0,0-!0G0-0.!0H0.0/!0I0/00!0J0001!0K0102!0L0203!0M0304 0N'f.d.*0O05 05.O ;*0P06 06.P ;*0Q07 07.Q ;*0R08 08.R ;*0S09 09.S ;*0T0: 0:.T ;*0U0; 0;.U ;*0V0< 0<.V ;*0W0= 0=.W ;*0X0> 0>.X ;*0Y0? 0?.Y ;*0Z0@ 0@.Z ;*0[0A 0A.[ ;*0\0B 0B.\ ;*0]0C 0C.] ;*0^0D 0D.^ ;*0_0E 0E._ ;*0`0F 0F.` ;*0a0G 0G.a ;*0b0H 0H.b ;*0c0I 0I.c ;*0d0J 0J.d ;*0e0K 0K.e ;*0f0L 0L.f ;*0g0M 0M.g ;1'trans 121'xsec 1214'xsec 121N'xsec 12 2'dist 2'dist22222222222 22!22"22#2 2$2 2%2 2&2 2'2 2(22)22*22+22,22-22.22/2202212222232 24'dist2522262227222822292 22:2!2 2;2"2!2<2#2"2=2$2#2>2%2$2?2&2%2@2'2&2A2(2'2B2)2(2C2*2)2D2+2*2E2,2+2F2-2,2G2.2-2H2/2.2I202/2J21202K22212L23222M2423 2N'dist#2O2 25 ;#2P2 26 ;#2Q2 27 ;#2R2 28 ;#2S2 29 ;#2T2 2: ;#2U2 2; ;#2V2  2< ;#2W2  2= ;#2X2  2> ;#2Y2  2? ;#2Z2  2@ ;#2[2 2A ;#2\2 2B ;#2]2 2C ;#2^2 2D ;#2_2 2E ;#2`2 2F ;#2a2 2G ;#2b2 2H ;#2c2 2I ;#2d2 2J ;#2e2 2K ;#2f2 2L ;2g 3'w.d. 3'w.d.*32 3 ;*32 3 ;*32 3 ;*32 3 ;*32 3 ;*3 2 3 ;*3!2 3 ;*3"2 3 ;*3#2  3  ;*3$2  3  ;*3%2  3  ;*3&2  3  ;*3'2  3  ;*3(2 3 ;*3)2 3 ;*3*2 3 ;*3+2 3 ;*3,2 3 ;*3-2 3 ;*3.2 3 ;*3/2 3 ;*302 3 ;*312 3 ;*322 3 ;*332 3 ; 34'w.d.!3533!3633!3733!3833!3933 !3:3 3!!3;3!3"!3<3"3#!3=3#3$!3>3$3%!3?3%3&!3@3&3'!3A3'3(!3B3(3)!3C3)3*!3D3*3+!3E3+3,!3F3,3-!3G3-3.!3H3.3/!3I3/30!3J3031!3K3132!3L3233!3M3334 3N'w.d.*3O35 352O ;*3P36 362P ;*3Q37 372Q ;*3R38 382R ;*3S39 392S ;*3T3: 3:2T ;*3U3; 3;2U ;*3V3< 3<2V ;*3W3= 3=2W ;*3X3> 3>2X ;*3Y3? 3?2Y ;*3Z3@ 3@2Z ;*3[3A 3A2[ ;*3\3B 3B2\ ;*3]3C 3C2] ;*3^3D 3D2^ ;*3_3E 3E2_ ;*3`3F 3F2` ;*3a3G 3G2a ;*3b3H 3H2b ;*3c3I 3I2c ;*3d3J 3J2d ;*3e3K 3K2e ;*3f3L 3L2f ;*3g3M 3M2g ; 4'f.d. 4'f.d.-43 434;-43 344;-43 344;-43 344;-43 344;-4 3  3 44;-4!3! 3!44;-4"3" 3"44;-4#3# 3#4 4 ;-4$3$ 3$4 4 ;-4%3% 3%4 4 ;-4&3& 3&4 4 ;-4'3' 3'4 4 ;-4(3( 3(44;-4)3) 3)44;-4*3* 3*44;-4+3+ 3+44;-4,3, 3,44;-4-3- 3-44;-4.3. 3.44;-4/3/ 3/44;-4030 3044;-4131 3144;-4232 3244;-4333 3344; 44'f.d.!4544!4644!4744!4844!4944 !4:4 4!!4;4!4"!4<4"4#!4=4#4$!4>4$4%!4?4%4&!4@4&4'!4A4'4(!4B4(4)!4C4)4*!4D4*4+!4E4+4,!4F4,4-!4G4-4.!4H4.4/!4I4/40!4J4041!4K4142!4L4243!4M4344 4N'f.d.*4O45 452O ;*4P46 462P ;*4Q47 472Q ;*4R48 482R ;*4S49 492S ;*4T4: 4:2T ;*4U4; 4;2U ;*4V4< 4<2V ;*4W4= 4=2W ;*4X4> 4>2X ;*4Y4? 4?2Y ;*4Z4@ 4@2Z ;*4[4A 4A2[ ;*4\4B 4B2\ ;*4]4C 4C2] ;*4^4D 4D2^ ;*4_4E 4E2_ ;*4`4F 4F2` ;*4a4G 4G2a ;*4b4H 4H2b ;*4c4I 4I2c ;*4d4J 4J2d ;*4e4K 4K2e ;*4f4L 4L2f ;*4g4M 4M2g ; >'xsec?????? ? ??? ? ? ? @@@ @ @@@@@!@ %@ )@ -@ 1AAOfPA O fPAOfPAOfPAOfPAOfPAOfPA#O#fPA 'O'fPA +O+fPA /O/fPA 3O3fPBBOfPB O fPBOfPBOfPBOfPBOfPB O fPB$O$fPB (O(fPB ,O,fPB 0O0fPB 4O4fP C'av.areaDDDDD D DDDD D D D *E@ @@ ;*E@ @@ ;*E@ @@ ;*E@ @@ ;*E@ @@ ;*E@ @@ ;*E@ @@ ;*E@ @@ ;*E@  @ @ ;*E @  @ @  ;*E @  @ @  ;*E @  @ @  ;*E A  @  ;!FAA!FAA!FAA!FAA!FAA!FAA!FAA!FAA!FAA !F A A !F A A !F A A !F A A !GBB!GBB!GBB!GBB!GBB!GBB!GBB!GBB!GBB !G B B !G B B !G B B !G B B H'cell vol.IFEIFEIFEIFEIFEIFEIFEIFEIFEI F E I F E I F E I F E JGEJGEJGEJGEJGEJGEJGEJGEJGEJ G E J G E J G E J G E  L'T wat VL'T fine VL'V*MII PMJJ P$MMMMR'dist bet xsR T'{FILE-UNSEAL vstar}T'{EDIT-GOTO u1}U'{EDIT-GOTO u1}U'{CELL-ENTER "sealed"}V'{CELL-ENTER "unseal"}V'{UNPROTECT A:B4..A:Z53}W'{SCROLL-TO-CELL A:a1}W'{FILE-SEAL vstar}X'{SCROLL-TO-CELL A:a1}Y'{EDIT-GOTO b:a1}Z'{['{SELECT A:C6..A:Z53;A:C6} ['{CALC}\'{EDIT-CLEAR ;"CONTENTS"}\'{EDIT-GOTO b:a1}]'{SELECT A:B7..A:B9;A:B7}*]'{ALERT are the plots OK?;1;;;600;20}^'{EDIT-CLEAR}^'{EDIT-GOTO a:a1}!_'{SELECT A:B11..A:B13;A:B11}`'{EDIT-CLEAR}!a'{SELECT A:B15..A:B17;A:B15}b'{EDIT-CLEAR}!c'{SELECT A:B19..A:B21;A:B19}d'{EDIT-CLEAR}!e'{SELECT A:B23..A:B25;A:B23}f'{EDIT-CLEAR}!g'{SELECT A:B27..A:B29;A:B27}h'{EDIT-CLEAR}!i'{SELECT A:B31..A:B33;A:B31}j'{EDIT-CLEAR}!k'{SELECT A:B35..A:B37;A:B35}l'{EDIT-CLEAR}!m'{SELECT A:B39..A:B41;A:B39}n'{EDIT-CLEAR}!o'{SELECT A:B43..A:B45;A:B43}p'{EDIT-CLEAR}!q'{SELECT A:B47..A:B49;A:B47}r'{EDIT-CLEAR}!s'{SELECT A:B51..A:B53;A:B51}t'{EDIT-CLEAR}u'{FILE-UNSEAL vstar}u'{FILE-UNSEAL [vstar]}v'{APPENDBELOW rvst;pvst}w'{FILE-SEAL vstar}w'{FILE-SEAL [vstar]}x'{SELECT A:B4}y'{SCROLL-TO-CELL A:a1} 'Creek 'npoolsR 'pool 'wat.vol 'fines v'V*'w2'f2 'f*w$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$    0     ;/     ;;      ;$    0     ;/     ;;      ;$    0     ;/     ;;      ;$    0     ;/     ;;      ;$    0     ;/     ;;      ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ;$0  ;/  ;;  ; 'sumPPPPP 'mean 'var w! 'var f! 'cov f,w! 'mean V*$ 'var V*l  !'se V*! #1'{SELECT c:a3..c:c24;c:a3}2'{EDIT-CLEAR ;"CONTENTS"}3'{SELECT C:B1}4'{EDIT-CLEAR}5'{FILE-UNSEAL vstar} 6'{RANGE-NAME-DELETE "RVST"})7'{RANGE-NAME-CREATE rvst;c:a2..C:c2}8'{FILE-SEAL vstar}9'{EDIT-GOTO c:a1}'poolcalc'This spreadsheet takes measured data for a pool and caculates the water volume, fine sediment volume, and V* for the poolF'1. measure the pool--see Hilton and Lisle 1993 for instructions'2. enter the creek, pool number, riffle crest depth, pool length, and number of cross-sections in cells B4,D4,E4,F4 and G4.'3. enter the measured data for the pool:z 'a. enter the distance from the upstream end of the pool to the first transect in C6--location of the first transect 'b. starting at the left side of the pool looking downstream, enter the distance along the cross (transect) tape at your first measurement point, the water depth at that point,  ' A 'and the fine sediment depth at that point in B7, B8, and B9 'c. enter the distance along the cross tape at your next measurement point and the corresponding water and fine sediment depths in C7, C8, and C9U 'd. continue until you have entered all the measurements for the first transect.' P'the first distance doesn't have to be 0 but it should be a positive number['e. enter the distance from the upstream end of the pool to the second transect in C10'f. enter distance along that transect, water depth, and fines depth for all measurement points on that transect starting in B11, B12, and B13 |'g. enter the distance downstream to your 3rd transect in C14 and enter the data stating in B15, 16, and 17, as above. 0'h. continue through all measured transects|'4. enter the total length of the pool as the transect location for the transect after the last transect you measured,i'i,e,. if you measured 3 transects and the pool was 10 meters long the location of transect 4 is 10 _'this transect doesn't need any data, but you can put some 0's in just to show you saw it.l'5. click on the "calc" button to calculate water volume, fines volume, and V*, and to check the plots'6. look at the plots of water depth and fines depth--they're kind of upside-down pictures of a cross section of the pool. You may have to move the button out of the way.'The most common error we see is water depths or fines depths entered in centimeters, ie fines depth 2 for 2 cm. (which should be .02 m)|' this will usually be pretty obvious on the plot--there will be one point that's much higher than the others around it$'Other errors to watch for are:'distance along the transect tape entered wrong--if the data is out of order it will produce a very odd-looking plot, with lines going backwards'wrong or no riffle crest depth entered --this won't show up on the plot, but it can give you a very small pool volume. Check the data sheet before you save it'transect location entered wrong or in the wrong order--again, it won't show up on the plots except that each transect shows it's distanceu'7. Hit the Ok button to get back to the data sheet. If there were problems, fix them and press calculate again'8. Once you're happy with your plots, I recommend SAVING THE DATA--just select all the cells with data in them, use File--->New to make a new file and paste the data there.t '9. Click on the "save" button to save the pool number, water volume, and fines volume on the reach mean page. e!' You might want to go look at the reach mean sheet to make sure it's working right (see #10). ^"'10. Enter and save the data for the rest of the pools in the reach as in steps 1-9 above#'check the reach mean sheet periodically to see that your data is collecting properly--the pools don't have to be in order and there can be blank lines 9$' but they all have to be there with no duplicates%'if you have problems, you might have to either start over or unseal the workbook so you can change the values in the reach mean sheetr&' to unseal the workbook, go to File----->Protect, and clear the 'Seal file' box. The password is vstar. L'' after fixing the problems, RESEAL the file or the Macros WON"T WORK)'reach meani*'the reach mean worksheet collects the data from the poolcalc sheet and calculates the reach mean V*,'11. When you've entered and saved the water & fines values for all the pools in a reach, HIT F9 to calculate the reach mean V*. J-'Reach total and mean water and fines are in B25, B26, C25 and C26. Y.'Weighted mean V* is in B32, and the standard error of the estimate of V* is in B34.a/'12. Copy the reach mean sheet onto the file where you saved the pool data and you're done.x1'You're welcome to change anything, just reseal the file if you unseal it. Call or email me if you have questions:2' 2'Sue Hilton (707) 825-29273'shilton/psw_rsl@fs.fed.us-M_ ArialArialArialTimes New RomanTimes New RomanTimes New RomanTimes New RomanSymbol    O4!*x5 yT0 &saveCLEAR05 yT0 &calcCALC05 ^GyQd2&sealSG%5 yQ* &unsealU* 3 ȕy02hCHART 1CHART 1ddDF|2b"DF|2bh@A( n3 Zy@DhCHART 2CHART 2ddDF|2b"DF|2bh@A( 4l3 ZyP~hCHART 3CHART 3ddDF|2b"DF|2bh@A(p~3 QAyPrhCHART 4CHART 4ddDF|2b"DF|2bh@A(jRo3 #yPhCHART 5CHART 5ddDF|2b"DF|2bh@A(} #  3 Lz\yPmhCHART 6CHART 6ddDF|2b"DF|2bh@A( w3 y0UhhCHART 7CHART 7ddDF|2b"DF|2bh@A(>  Wjh3 (y09ihCHART 8CHART 8ddDF|2b"DF|2bh@A(}  jg3 FRBy<[hCHART 9CHART 9ddDF|2b"DF|2bh@A($ M\5 p=y<d2& rch clear MNCLEAR+Y9 W wshed3shilton  , 96 &Doc Info AuthorDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info Last RevisorDoc Info ObjectDoc Info PropertyDoc Info Revisions CountFM3FM3 PropertyWK3WK3 Property  0(( !( ((  (  #'  -'  8' F' T'\''' b' ' r' ' ''CMHdr0((