Excel加VBA在实验室内质量控制中的应用

针对《手册》各类质控图,应用Excel与VBA编制了一种科学严谨的人性化实验室质控图制作程序,通过程序创建和《手册》中的实例,向读者展示如何运用基于Excel内核的VBA编程方法来扩展Excel的功能,以实现质量控制中复杂的数据统计和图表的制作功能。     

标准曲线的斜率在环境监测分析质控中的应用

环境监测分析质量控制目前一般都采用制作质量控制图、标准曲线、平行22样、加标回收、标准参考物使用等方法进行.质量控制图的工作量太浩繁,同时由于在日常工作中所遇到的环境样品,其类型、含量和分析项目的经常变动,使质量控制图的适用性受到了限制;标准参考物由于目前限于样品的种类以及保存时间不同,不可能在日常的常规监测分析中都带上标准物进行质量控制.本文通过控制灵敏度范围等措施对大气SO_2、NO_x进行质控,取得较满意的效果.并认为把其运用到部分水质监测项目中.也能收到良好的质控效果.     

COD_(Cr)空白试验值控制图及其应用

本文建立了容量法中ＣＯＤＣｒ测定的空白试验值控制图,以及在日常监测中的应用,为ＣＯＤ质量控制提供了一种新方法。     

指数加权移动平均控制图在实验室中的应用及与其他质控图比较

阐述了指数加权移动平均(EWMA)控制图在环境分析实验室中的应用,并与休哈特控制图和Westgard多规则对于不同偏移量的ARL值作了比较.结果表明,EWMA控制图在检验不准确度,尤其在微小偏移上的优势值得推广.     

环境监测质控技术的探索与开发——通用选控图的绘制及其特性

本文就目前环境监测中各种常用质量控制技术的特点进行了分析。针对休哈特(Shewhart)质量控度图在环境监测质量控制应用中存在的问题,开发了新的质量控制图形——通用选控图。     

地表水中总磷监测的质量控制

分析了地表水中总磷监测过程中的质量控制方法，着重讨论了空白实验，检测限的计算校准曲线的回归与检验，标准品的测定，空白实验的质量控制图等。     

火焰原子吸收分光光度法测定总铬的研究

用火焰原子吸收分光光度法直接测定水和废水中的总铬.通过不同条件的实验,确定了最佳的分析条件;并通过标准样品和实际样品的分析,验证了方法的准确度和精密度.在大量实验基础上,建立空白实验、准确度质量控制图,以便定期对各种监测数据提供可行的质量保证措施.实验结果表明,该法快速方便,提高了分析效率,准确度高,精密度好,值得普及和推广.     

用天然水样制备NO_3~-—N、NH_3—N和NO_2~-—N分析质量控制样的探讨

本文介绍了用天然水样制备NO_3~-—N、NH_3—N和NO_2~-—N分析质量控制样的方法,试验了控制样的长期稳定性和实际应用效果.试验结果表明,NO_3~-—N、NO_2~-—N及NH_3—N控制样分别能够稳定8个月、1年和6个月,用于绘制控制图控制分析质量效果良好.     

MATLAB在QUAL ò水质模型计算中的应用

通过实例介绍了MATLAB计算机软件具有的运用计算机工具处理综合水质模型的各离散数据、绘出采样点位置，以及处理模型各变量关系图和检验采样数据精确性及计算准确性等功能。对QUAL-Ⅱ水质模型和计算机图形用户界面的设计及计算结果可视化做了介绍。指出运用MATLAB计算机软件既可以解决计算复杂且太过专业化的问题，又可以利用图像表达各量之间的关系。     

灵敏度在水质分析质量控制中的应用

水质分析的质量控制一般都采用制做质量控制图或用标准样品进行对照。质量控制图用起来较方便,但要制做一个好的质量控制图其工作量相当大;利用标准样品进行对照分析当然更好,但限于样品的种类和保存时间,不可能每次分析都能带上标样进行全程序质量控     

Topsoil and Housedust Metal Concentrations in the Vicinity of a Lead Battery Manufacturing Plant

The aim of the study was to determine the extent of heavy metal pollution in the vicinity of a lead battery manufacturing plant in the Czech Republic, both in the general environment and within homes. Topsoils (0–5 cm) were sampled from 100 sites along 4 transects which crossed the battery factory, the town centre and outlying rural areas. Housedust samples were collected from 15 plant-workers' homes and 15 non plant-workers' homes located at various distances from the factory. Samples were analysed for levels of Pb, Zn, Cd, Cu, As and Sb, using ICP-AES. Soil concentrations of Pb, Cd, As and Sb peaked at the perimeter fence of the battery factory with Pb levels of up to 12 650 g g> ^-1. Concentrations of these metals decreased exponentially within 500 m of the plant. Whilst the battery factory does appear to be a source of all the metals with the exception of Zn, emissions do not appear to be transported to any great extent over distances of more than 0.5 km. Topsoil and housedust concentrations of Pb, Zn, Cd, Cu, As and Sb in the general Mlada Boleslav area do not appear to be significantly different from those recorded in a large scale survey of urban soils in the United Kingdom. A comparison of housedust Pb concentrations in homes of plant workers and non-plant workers suggests that there may be a small input of Pb into the home environment by battery plant employees.     

微波消解-原子吸收光度法测定土壤中铜锌铅镉镍铬

用微波消解－原子吸收光度法测定土壤中铜，锌，铅，镉，镍和铬。通过硝酸－氢氟酸－过氧化氢体系消解液对土壤样品消解，选择出微波最佳消解条件。对硝酸－盐酸－过氧化氢体系消解液和硝酸－氢氟酸－过氧化氢体系消解液进行消解对比试验，发现前者不能将土壤样品完全消解，后者能将样品消解完全，但需将消解液中剩余的酸赶尽，否则测定结果将明显偏低。微波消解土壤与传统电热消解相比，操作简便快速，可提高工作效率。     

An Overview of Contaminant-Related Issues Identified by Monitoring in San Francisco Bay

The San Francisco Estuary Regional Monitoring Program for Trace Substances (RMP) began in 1993 and is sponsored by 74 local, state, and federal agencies and companies through their discharge or Bay use permits. The RMP monitors water, sediment, toxicity, and bivalve bioaccumulation at 25 sites in the Bay that are considered to represent "background" conditions. Several major environmental issues have been identified by the RMP. Polychlorinated biphenyls and mercury were often above water quality guidelines, and often occurred in fish tissues above U.S. Environmental Protection Agency (U.S. EPA) screening values. Concentrations do not appear to be decreasing, suggesting continuing inputs. Episodes of aquatic toxicity often occurred following runoff events that transport contaminants into the Bay from urbanized and agricultural portions of the watershed. Sediment toxicity occurred throughout the Bay, and has been correlated with concentrations of specific contaminants (chlordanes, polynuclear aromatic hydrocarbons) at some locations; mixtures of contaminants were probably also important. Since the RMP does not monitor all ecosystem components, assessments of the overall condition of the Bay cannot be made. However, in terms of contamination, the RMP samples suggest that the South Bay, and North Bay sites are moderately contaminated.     

Biomagnification factors (fish to Osprey eggs from Willamette River,Oregon, U.S.A.) for PCDDs,PCDFs, PCBs and OC pesticides

A migratory population of 78 pairs of Osprey (Pandion haliaetus) nesting along the Willamette River in westernOregon was studied in 1993. The study was designed to determinecontaminant concentrations in eggs, contaminant concentrationsin fish species predominant in the Ospreys diet, andBiomagnification Factors (BMFs) of contaminants from fish specieseaten to Osprey eggs. Ten Osprey eggs and 25 composite samplesof fish (3 species) were used to evaluate organochlorine (OC)pesticides, polychlorinated biphenyls (PCBs), polychlorinateddibenzo-p-dioxins (PCDDs), and polychlorinated dibenzofurans(PCDFs). Mercury was also analyzed in fish. Geometric meanresidues in Osprey eggs were judged low, e.g., DDE 2.3 g g^-1 wet weight (ww), PCBs 0.69 g g^-1, 2,3,7,8-TCDD 2.3 ng kg^-1, and generally well below known threshold values for adverse effects on productivity, and the population was increasing. Osprey egg residue data presentedby River Mile (RM) are discussed, e.g., higher PCDDs were generally found immediately downstream of paper mills and eggsfrom the Willamette River had significantly elevated PCBs and PCDDs compared to reference eggs collected nearby in the CascadeMountains. Prey remains at nest sites indicated that the Largescale Sucker (Catostomus macrocheilus) and NorthernPikeminnow (Ptychocheilus oregonensis) accounted for an estimated 90.1% of the biomass in the Osprey diet, and composite samples of these two species were collected from different sampling sites throughout the study area for contaminant analyses. With the large percentage of the fishbiomass in the Osprey diet sampled for contaminants (and fisheaten by Ospreys similar in size to those chemically analyzed),and fish contaminant concentrations weighted by biomass intake, a mean BMF was estimated from fish to Osprey eggs for the largeseries of contaminants. BMFs ranged from no biomagnification(0.42) for 2,3,7,8-TCDF to 174 for OCDD. Our findings for themigratory Osprey were compared to BMFs for the resident HerringGull (Larus argentatus), and differences are discussed. Webelieve a BMF approach provides some basic understanding ofrelationships between contaminant burdens in prey species offish-eating birds and contaminants incorporated into their eggs,and may prove useful in understanding sources of contaminants inmigratory species although additional studies are needed.     

The Draft of the New German Guideline VDI 3782/8 to Model Automobile Exhaust Dispersion

The draft of the German guideline to calculate automobile exhaust dispersion is explained. It contains a two-stage-system: For first quick estimates the guideline contains the simple models MLuS and STREET. In case these models are not applicable or their results shows concentration levels close to the air quality standards, the more complex models PROKAS_V and MISKAM are recommended. PROKAS_V is a Gaussian plume model, MISKAM is a 3-dimensional microscale non hydrostatic flow model for built-up areas with an Eulerian dispersion model. The guideline comprises cases in rural areas without or with few adjacent buildings as well as urban areas with buildings near the roads. The contribution gives information about the models, typical results and some of the problems showing up presently.     

Hydrocarbon Utilization in Yeast Isolates Found to Grow in Association with Petroleum in a Polluted Ultisol of Midwestern Nigeria

The population counts of hydrocarbon-utilising yeasts weremonitored at six sampling stations in the Benin City municipalarea over a four-week period. Although the population countswere relatively constant in each locality, the highest countsoccurred in areas heavily polluted by domestic and industrialeffluents. A total of thirty-five hydrocarbon-degrading yeastswere isolated from soil at the sampling stations usingn-hexadecane as sole carbon source. The isolates were identifiedas belonging to the genera Candida (27 strains), Endomycopsis (4 strains). All the organisms grew on long-chainn-alkane, kerosene, diesel oil and crude oil but failed to growon short-chain n-alkane, aromatic and alicyclic hydrocarbons.Measurement of growth attributes of the isolates usingn-hexadecane, diesel oil and crude oil as substrates showed thatthe Candida species were better utilizers of hydrocarbonsubstrates relative to Endomycopsis and Schizosaccharomyces species.     

Hydrologic–Economic Model for Managing Irrigation Intensity in Irrigation Areas under Watertable and Soil Salinity Targets

This paper gives mathematical details and sample applications of SWAGMAN Farm (SWAGMAN, Salt Water and Groundwater Management), a farm-scale hydrologic economic model that integrates agronomic, climatic, irrigation, hydrogeological and economic aspects of irrigated agriculture. The model is capable of determining optimum mix of land use to keep watertable and soil salinity within acceptable limits while maximising the economic returns. Alternatively, the model can simulate water and salt balance and economics of a given cropping preference. Web-based and Geographic Information Systems versions of the model are available for integration with the environmental reporting systems of the irrigation areas.     

火焰原子吸收光谱法测定苏州开发区26种蔬菜中铜锌铁锰镍

用火焰原子吸收光谱法测定了苏州开发区26种蔬菜中的铜、锌、铁、锰和镍的含量。蔬菜样品用硝酸高氯酸混合酸进行消解。4次测定值的相对标准差<5%,加标回收率在92%～107%之间。26种蔬菜中铜、锌、铁、锰、镍的含量基本均在世贸组织规定的范围内。     

Using Multiple Taxonomic Groups to Index the Ecological Condition of Lakes

Biological indicators of communitiestypically reflect a common environmental signalreflecting the general condition of the ecosystem, as well asindividual signals by indicators differentiallysensitive to particular environmental conditions. Wedescribe here a method of integrating and interpretingsuch indicators from 19 New England lakes for fivetaxonomic groups (diatoms, benthos, zooplankton, fish,and birds). Our approach provides a systematicstandardized way to integrate multiple metrics fromdifferent taxonomic groups by addressing four elementscrucial to analyzing data from multiple indicators: covariate control, re-scaling of data, standardizing the sign of responses, and dimensional reduction. We evaluated the biologicalmetrics against individual environmental stressors andagainst multivariate physicochemical metricscharacterizing general anthropogenic stress among thelakes. The method detected a response to variationin the gross environmental condition of the lakes thatwas correlated across taxa and metrics. In addition,a differential response to near shore conditions wasdemonstrated for fish. The success of the approach inthis study lends support to its general application toecological monitoring involving complex data sets.     

Concentrations of Cadmium, Mercury and Selenium in Blood, Liver and Kidney of Common Eider Ducks from the Canadian Arctic

We determined concentrations of selected trace elements inlivers, kidneys and blood samples from common eiders (Somateria mollissima borealis) from the eastern Canadianarctic during 1997 and 1998. Concentrations of totalmercury and organic mercury were generally low in the liversof these birds (less than 6 and 4 g g^–1 dry wt,respectively). Selenium ranged between 11–47 g g^–1 inlivers. Renal cadmium concentrations were among the highestever published for this species (range: 47–281 g g^–1). The regressions of log-transformed concentrations ofthese trace elements in blood samples on those in liver orkidney were significant (all P-values < 0.05) andpositive. However, except for organic mercury (RM ² = 0.83), the co-efficients of determination were low tomoderate (range of R ²: 0.26–0.52), suggesting poorto moderate predictive capability. Furthermore, therelationships between total mercury in blood and liverchanged between 1997 and 1998, suggesting that it would notbe possible to predict consistently, concentrations ofmercury in blood from those in liver based on samples takenin one year. Blood samples can be used to determineconcentrations of these trace elements in common eiders (andprobably other sea duck species as well). The use of bloodsamples is especially warranted when it is undesirable tokill the animal such as when working with rare or endangeredsea duck species or when the objective is to relate traceelement exposure to annual survival rates. However, thepredictive equations developed here should not be used topredict expected concentrations in one type of tissue fromthose in the other.