HELP...

The Cu CMC is calculated by using this equation ...=EXP(((0.9422)*(LN(H8))-1.7))*0.96, which is placed in column S.

Column T, which is the Cu HQ CMC is nothing more than the division of M*/S*.

Can someone help me with the the column S and T of this spreadsheet?

The original question was : "The aquatic ecosystem criterion maximum concentration (CMC) [acute surface-water toxicity limit] for copper at surface water site EB-1 ismicrograms per liter (ug/L). Provide your answer to one decimal place (X.X)." (EB-1 thru OR-3)

I need the columns filled out. I have all the correct other columns in there that I worked since the beginning. Maybe someone can figure this out. I am not good at this kind of equation.

Sample number Date collected Sample type Area Sampling Location Description EM-1 10/08/02 surface upper Northernmost upper waste pile at west end of upper composite waste piles waste area. Area measures about 14.6 m (48 ft) (E-W) of soil by 38.4 m (126 ft) (N-S); includes small pile at 24.4 m (80 ft) east of A1 beyond stand of trees. A1-A6-E1-E6 defines roughly rectangular area; A7 is location of small pile 24.4 m (80 ft) E of A1. EM-2 10/08/02 surface upper Southwestern upper waste pile below road. Samples 10 Locally at west end area includes dump area below composite waste piles across x 3 high. At center line, area is about 43 m (140 ft) timber loading platform(?), wet areas, clayey at of soil across by 15 m (50 ft) wide. depth, white salts around base of rocks and on soil. EM-3 10/08/02 surface upper Boulder slope below road above flat top of area 02Ely2. composite waste piles Traversed across length and height of pile. of soil Average boulder size 30 cm by 5 cm. Black, schistose ore with red oxidized surfaces and rustycolored lichen coatings. EM-4 10/08/02 surface upper South-central part of upper waste dumps. Stonewall composite waste piles gully is the east end (break between waste rock on area of soil 4 and more ore on area 5). Traversed 10 rows across ~EW (43 m) and 3 rows high (~NS). Top 2 rows on bench, 3rd row on accessible parts of slope. Trees at base of slope. Mine waste pile with abundant waste rock and little ore. Parts of slope covered with boulders; other parts are bare soil. EM-5 10/08/02 surface upper South-east corner of upper waste pile. Sampled 5 across Waste pile with ore, decomposed ore forms local composite waste piles (23 m across EW) x 6 vertical (49 m NS). black soil . Note salts forming on soil surface at of soil east end (Relative Humidity 27%, Temperature ~17C (63 F) EM-6 10/08/02 surface upper Irregular, diamond-shaped area above the seeps. See composite waste piles air photo for extent. Sampled 6 x 5 stations. of soil EM-7 10/08/02 surface lower Lower waste piles above the road sampled 10 stations composite waste piles parallel to the road by 3 stations perpendicular to the of soil road. Sample 02Ely9 is a replicate sample of the same area. EM-8 10/08/02 grab sample EM-9 10/08/02 surface lower Replicate of 02Ely7A composite waste piles of soil EM-10 10/08/02 surface roast beds Partially roasted ore sampled 10 stations long by 3 composite stations wide (long = parallel to the road. Note that the of soil old road runs through this area. EM-11 10/09/02 surface smelter composite site of soil EM-12 10/09/02 EM-13 10/08/02 surface slag pile Composite of small pieces of slag at base of the pile. composite grab soil soil around Soil in wooded area at the top of the smoke flue. sample top of smoke flue EM-14 06/27/00 surface lower Lowest mine dump directly along Ely Brook on both sides composite waste piles of the road. Replicate sample of 98JH-Ely-EB sample of soil area. EM-15 06/27/00 surface lower Flotation mill area. composite waste piles of soil lower Flotation mill tailings at north end of lower waste piles waste piles and east of mine access road intersection, downhill from cement foundation. Area of tailings appears to extend over a distance of about 25 m E-W along the mine access road and about 4 m in a N-S direction across the road to the stream edge. Sampled 10 stations (parallel to the road) x 3 stations perpendicular to the road. Sampled in clearing between the stone wall and the road. Surface is littered with fist- to boulder-size oxidized ore and waste rock (subequal amounts). Country rock is shaley, greenish schist that forms smaller particles. Heterogeneous area, local trees and roots, bare slope with ore, gray areas, yellow areas. Oxidized surface material. Mostly red surface are. Locally, especially at the north end, very bright red. Copper Concentrations of Mine Waste Samples Sample Cu Cu mg/kg HQ resid. PRG-residential mg/kg 3100 3100 PRG-industrial mg/kg 41000 1.19 EM-1 3,680 0.75 EM-2 2,320 1.83 EM-3 5,660 0.66 EM-4 2,050 1.05 EM-5 3,250 1.36 EM-6 4,220 2.26 EM-7 7,020 0.72 EM-8 2,240 2.24 EM-9 6,940 0.66 EM-10 2,040 0.9 EM-11 2,780 2.22 EM-12 6,880 0.01 EM-13 45 1.65 EM-14 5,100 2,400 0.77 EM-15 Copper concentrations of stream sediment samples Sample Name Stream Date PEC EB1 EB2 EB3 EB4 SB1 SB2 SB3 SB4 SB5 OR1 OR3 Ely Brook (reference) Ely Brook Ely Brook Ely Brook Schoolhouse Brook (reference) Schoolhouse Brook Schoolhouse Brook Schoolhouse Brook Schoolhouse Brook Ompompanoosuc River (reference) Ompompanoosuc River ICP-AES Cu mg/kg 149 8/23/2006 8/23/2006 8/23/2006 8/23/2006 8/22/2006 8/23/2006 8/22/2006 8/23/2006 8/22/2006 8/22/2006 8/22/2006 75.4 1160 2730 5950 10.4 1390 167 198 243 4.5 76.7 Cu HQ 149 0.51 7.79 18.32 39.93 0.07 9.33 1.12 1.33 1.63 0.03 0.51 Chemistry of surface water samples Sample Name Stream Date pH Specific Conductance S/cm MCL CMC CCC EB1 EB2 EB3 EB4 SB1 SB2 SB3 SB4 SB5 OR1 OR2 OR3 Drinking Water Standard Acute Aquatic Toxicity Chronic Aquatic Toxicity Ely Brook (reference) Ely Brook Ely Brook Ely Brook Schoolhouse Brook (reference) Schoolhouse Brook Schoolhouse Brook Schoolhouse Brook Schoolhouse Brook Ompompanoosuc River (reference) Ompompanoosuc River Ompompanoosuc River Dissolved Organic Carbon Alkalinity mg/L mg/L CaCO3 Hardness Cl SO4 Al Ca Cu Fe K Mg Na Cu Cu mg/L CaCO3 mg/L mg/L 250 ug/L 200 mg/L ug/L 1300 ug/L 300 mg/L mg/L mg/L HQ MCL 1300 CMC 0 0.64 0.3 1.2 0 0.3 0.02 0.02 0.02 0 0 0 8/23/2006 8/23/2006 8/23/2006 8/23/2006 8/22/2006 8/22/2006 8/22/2006 8/23/2006 8/21/2006 8/21/2006 8/21/2006 8/21/2006 7.2 6.3 7.0 3.2 8.2 7.8 8.3 7.9 8.2 8.0 8.0 8.1 87 149 123 447 212 215 210 203 186 196 198 196 1.9 0.8 0.9 1.6 1.2 1.3 1.2 1.5 2 2.5 2.6 2.6 41 11 16 0 99 89 89 86 80 88 87 85 38.34 56.1 47.9 75.5 96.2 95.8 97.8 92.4 84.2 85.9 88.5 88 1.4 1.4 1.5 2.6 4.2 4.6 5 4.6 4 5.7 6 5.4 4.3 52 143 2000 13 16 14 13 7.2 8 8 8 3.4 25.1 484 4190 12.8 124 128 84.4 93.5 13.4 23.3 44.6 13.4 17.2 15.1 21.1 35.7 35.1 35.8 33.8 30.7 32 32.9 32.6 1.3 837 385 1560