Laserfiche WebLink
<br />R S T U V W X <br />72 <br />73 <br />74 <br />75 <br />76 <br />77 <br />78 <br />79 <br />80 <br />81 <br />82 <br />83 <br />84 <br />85 <br />86 <br />87 <br />88 <br />89 <br />90 <br />92 <br />93 <br />94 <br />95 <br />96 <br />97 <br />98 <br />99 <br />100 <br />101 <br />102 <br />103 <br />104 <br />105 <br />106 <br />107 <br />108 <br />109 <br />110 <br />111 <br />112 <br />113 <br />114 <br />115 <br />116 <br />117 <br />118 <br />119 <br />120 <br />121 <br />122 <br />123 <br />124 <br />125 <br />126 <br />127 <br />128 <br />129 <br />130 <br />131 <br />132 <br />133 <br />134 <br />135 <br />136 <br />137 <br />138 <br />139 <br />140 <br /> <br />Qwassa hill MNRAMa <br /> <br />Mn RAM_3.0_ Score_Sheet.xls <br /> <br />Y Z AAABAC AD AE AFAGAH <br />Vegetative formula <br />"=C4", the Weighted Average Option 4 from Veg. Worksheet <br /> <br />AI <br /> <br />AJ <br /> <br />AK <br /> <br />Characteristic Hydrology formula <br />"=(DI5+D16+D17+E22)/4" E22 is the reverse rating <br /> <br />00 ttenuabon ormu a rea out (not inked to D72) (E16 is reverse rated) <br />nla formula is: <br />none 0.73 (D14+(E 16+D21 )/2+(D17 +D20)/2+(D22+D23)/2+(E 18+D19+D24 )/3)/5 <br /> <br />flood outlet <br />F-T <br />both <br /> <br /> <br />G20- Water Quality Downstream Formula Breakout <br />o 0.46 "=(D16+D22+D20+(F25+F26+F32)/3+(E18+D19)/2+D35+D14 )17" <br />1 0.39 "=(D16+D22+D20+(F25+F26+F32)/3+(E18+D19)/2+ D35 )/6" <br />1.5 0.52 "=(D16+D22+D20+(F25+F26+F32)/3+ D35+D14)/6" <br />2.5 0.42 "=(D16+D22+D20+(F25+F26+F32)/3+ D35 )/5" <br /> <br /> <br />N/A <br />none <br />45 <br />46 <br />47 <br />45&46 <br />45&47 <br />46&47 <br />45&46&. <br /> <br />H38 Habitat formula breakouUlookup (E22 is RR) Special Features Bump is below. <br />o _ C4'2+D47+E45+E46+D48+D49+(D50+D52)/2+(H25+F26+F29)/3+D15+E22)/11 <br />1 _ C4'2+D47+ E46+ D48+D49+(D50+D52)/2+(H25+F26+F29)/3+D15+E22)/10 <br />1.5 _ C4'2+D47+ E45+ D48+D49+(D50+D52)/2+(H25+F26+F29)/3+ D15+E22)/10 <br />2 0.333 C4'2+ E45+E46+D48+D49+(D50+D52)/2+(H25+F26+F29)/3+D15+E22)/10 <br />2.5 _ C4'2+D47+ +D48+D49+(D50+D52)/2+(H25+F26+F29)/3+D15+E22)/9 <br />3 0.359 C4'2+ E46+D48+D49+(D50+D52)/2+H25+F26+F29+D15+E22)/11 <br />3.5 0.359 C4'2+ E45+ D48+D49+(D50+D52)/2+H25+F26+F29+D15+E22)/11 <br />4.5 0.391 C4'2+ D48+D49+ D50+D52 12+ H25+F26+F29 13+D15+E22 18 <br /> <br /> <br />Characteristic Fish Habitat formula <br />''=IF(D54=''N/ A", "N/A" ,IF(CJ7="Y" ,((D54'2+F26+D20+ <br />E22+DJ6+DJ9+DJ8+ 1- <br /> <br />Characteristic Amphibian Habitat formula (see Lookup breakout below) <br />VLOOKUP D50 86:R872 FALSE <br /> <br /> <br />D50 <br />o <br />1 <br /> <br />Aesthetics/ReelEd/Cultural formula <br />"IF(D56="Y", "2" ,IF(D61 ="L" ,(D58+D59+D60+2*D61 +D <br />62+D63+D64/8 D57+D58+D59+D60+D61+D62+D63+ <br /> <br />1"=065" Commercial use reflects just the rating for the question. <br /> <br />Special Features Bum -u reference table <br />a Fish Habitat=E <br />b Veg=E <br />c Aesthetics=E <br />d nAND #5=Y, then Wildlife=E <br />9 Wildlife/Fish=E <br />h Aesthetics=E <br />I Veg=E <br />j nAND #35 =Y, Wildlife=E <br />q :lcharg GW=recharge, GW=E <br />r :lcharg Y and GW=recharge, GW=E <br />u Aesthetics=E <br /> <br /> <br />4 <br /> <br />2/26/2007 <br />