ࡱ> A@ @\pDudley R. Hartel Ba==xx;T$8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1Arial1Arial"$"#,##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.000                + ) , *  "x@ @ +  `@ @ +  h@ @ +  `@ @   d@ @  *x@ @ +  d@ @ +  l@ @ +  h@ @ +       x@ @ +  p@ @ +  x@@ *  p@ *  p @ *   x@@    x@    x @  x@ @ + p@ @ + x@ @ + p@ @ +  x@ @ *  p@ @ * "x@ @ + "x@ @ +      x@ @ +   x@ @  (p@ @   l@ @ + ` blank sheet)do nothing example$Dwatershed protection example`ii$Zoning Category Open Space Agriculture ImperviousForestSubtotal$Future Land Cover (Undeveloped Land) InstitutionalLight Industrial CommercialTransportation+Estimating Future Land Cover in a WatershedRemoval of impervious cover Step 2. Undeveloped Land (acres)Step 3. Protected Land (acres)Step 3. Buildable Land (acres)Step 4. Land Cover Coefficients!Step 4. Future Land Cover (acres)Multifamily Residential(Medium Density Residential (1/4 ac lots)Other Pervious#Low Density Residential (1 ac lots)=Step 5. Future Land Cover (Developed Land and Protected Land)1Watershed Protection Assumptions (Developed Land)'Step 6. Total Future Land Cover (acres)4Step 1. Identify developed and undeveloped parcelsIStep 2. Calculate the area of each zoning category for undeveloped land]Step 3. Identify and subtract protected land from undeveloped land for each zoning categorytStep 4. Multiply the remaining buildable land in each zoning category by the corresponding land cover coefficientsZStep 5. Calculate the area of each land cover type for developed land and protected landJStep 6. Sum future land cover on buildable, developed and protected landTo evaluate the effect of different watershed protection scenarios, repeat Steps 1-6, and adjust protected land, land cover coefficients, and/orfuture land cover on developed land to reflect watershed protection measures such as active reforestation of public turf, natural regenerationLincentives for tree planting on private land, or removal of impervious cover#Active reforestation of public turfTree planting on private land* &  b ) @ !7/'\(  dMbP?_*+%MCanon iR C2000 _ odXLetterCanon   Canon iR C2000 series PCL5ctdddd     ddd@@d     dd d     d d"  edddd     d!d     ddA     A8o @@/ o @@/ ddCONFIDENTIALCONFIDENTIALHArial AXX\CANSRGBA.ICC\CANSRGBA.ICC\CANSRGBA.ICCDefault Settings"_XX??U} } } $}  }  }  } $ }  } m !  ;             I@              @ @ @ 0 111111111            ! 2 !!!!!!!!! * ( ( ( . // . // +)))          LL  LL LL   LL                                      # %# %# % #  %#  %#  %  ,------ "########$ 3333333 %&&&&&' 3333333 @P D* *pf**   !!!!!!7 !DDDDD7 !DDDDD7 !D D D D D >@  r    7 @  2C  dMbP?_*+%MCanon iR C2000 _ odXLetterCanon   Canon iR C2000 series PCL5ctdddd     ddd@@d     dd d     d d"  edddd     d!d     ddA     A8o @@/ o @@/ ddCONFIDENTIALCONFIDENTIALHArial AXX\CANSRGBA.ICC\CANSRGBA.ICC\CANSRGBA.ICCDefault Settings"_XX??U} } } $}  }  }  } $ }  } m   ;             I@             @ @ @  0 111111111            ! 2 !!!!!!!!! * ( ( ( . // . // +)))        p@@\@@  LL~jt?/$?%jt?DDR-@ LLq= ף`@ LL (\o@  LL Y@I@I@ jt?M?jt?LL333333@,@ hfffff?@ 4@Y@@ M?%C?x&?$C+Z@v_m@ ʡx@ 4@^@(@ n?X9v?tV?Rif@Qc@ Gzs@ o@A@k@ "~j?Cl?e;O?QkX@GzTF@  ףp=jS@ f@W@V@ jt?x&?NbX9?ʡE>@0$'@ +F@ i@4@ g@ J +?bX9ȶ?T㥛 ?(\X@ףp= w0@ HzoQ@  `c@9@@`@ v?x&?6^I ?ףp= wW@Qk!@ Gzn;@  >@>@ ~ V@+?I +?;@Q@ Q?  #@ %#h@ %#:@ % #MbS@ %#nm@ %# On@ %  ,------@@@ "########$ 3"333333 %#&&&&&' 3 333333  !!!!!!75jt@!DDDDD75L7Aಓ@!DDDDD7 5KE@!D D D D D @D* *pfQ@*@@@>@r   7 @  M]  dMbP?_*+%MCanon iR C2000 _ odXLetterCanon   Canon iR C2000 series PCL5ctdddd     ddd@@d     dd d     d d"  edddd     d!d     ddA     A8o @@/ o @@/ ddCONFIDENTIALCONFIDENTIALHArial AXX\CANSRGBA.ICC\CANSRGBA.ICC\CANSRGBA.ICCDefault Settings"_XX??U} } } $}  }  }  } $ }  } m   ;             I@             @ @ @  0 111111111            ! 2 !!!!!!!!! * ( ( ( . // . // +)))        p@e@0@  LL~jt?/$?jt? LL{G*@ LLR]@ LL p= @  LL Y@I@I@ jt?M?jt?333333@,@ hfffff?@ 4@`h@@ M?~ D@rh|??V@o@ 9v1r@ 4@@e@@ n?~ ?h|?5?Qd@b@ = ףpq@ o@A@k@ "~j?~ ?0$?QkX@K@ GzP@ f@W@V@ jt?~ .@x&1?ʡE>@ffffff*@ $CF@ i@Q@`@ J +?~ .@MbX9?(\R@@4@ GzTE@  `c@9@@`@ v?~ .@Mb?ףp= wW@3@ p= ף0@  >@>@ ~ V@+?I +?;@Q@ Q?  #@ %#8@ %#F@ % #C@ %#(\;@ %# 5^I!@ %  ,------@@@ "########$ 3"333333i@i %#&&&&&'B@B 3 333333??  !!!!!!75B`b@!DDDDD75Hzӗ@!DDDDD7 5/$Ƴ@!D D D D D @D* *pfd@*@@@> @r   7 Oh+'0HPp Microsoft CorporationKarenofMicrosoft Excel@xeBX@(@Y՜.+,0 PXd lt| s  blank sheetdo nothing examplewatershed protection example  Worksheets  !"#$%&'()*+,-./12345679:;<=>?Root Entry F`q%Workbook^SummaryInformation(0DocumentSummaryInformation88