空气质量指数计算方法在Excel中VBA的实现简

空气质量指数计算方法是目前全国各城市空气质量重要信息发布的基础,广泛应用于城市空气自动监测的空气质量评价。依据《HJ 633-2012环境空气质量指数（AQI）技术规定（试行）》发布环境空气质量指数（AQI）计算方法,利用VBA在Excel下编写宏程序,可以轻松实现空气质量日报信息的发布,使用户从手工重复性的填充和插入函数操作方式中彻底解放出来。     

Bio-economic evaluation of implementing trawl fishing gear with different selectivity

The paper develops a biological-economic evaluation tool to analyse the consequences for trawl fishers of implementing more selective fishing technologies. This is done by merging a dynamic biological population model and an economic cost–benefit evaluation framework to describe the consequences for the fish stocks, fishermen and society. The bio-economic evaluation is applied to the case of the Danish trawl fishery in Kattegat and Skagerrak, which experiences a high level of discards and bycatches of several species. Four different kinds of selectivity scenarios are evaluated in comparison with a baseline. The results from the evaluation are indicators for the consequences on ecological and economic levels. The results show that implementation of different selective fishing gear in the Kattegat and Skagerrak mixed trawl fisheries generally implies a trade off over time between rebuilding the stocks and economic loss. Moreover, the analysis shows that implementation of more selective gear is not always beneficial.     

Decision Support for Road System Analysis and Modification on the Tahoe National Forest

The United States Forest Service is required to analyze road systems on each of the national forests for potential environmental impacts. We have developed a novel and inexpensive way to do this using the Ecosystem Management Decision Support program (EMDS). We used EMDS to integrate a user-developed fuzzy logic knowledge base with a grid-based geographic information system to evaluate the degree of truth for assertions about a roads environmental impact. Using spatial data for natural and human processes in the Tahoc National Forest (TNF, California, USA), we evaluated the assertion the road has a high potential for impacting the environment. We found a high level of agreement between the products of this evaluation and ground observations of a TNF transportation engineer, as well as occurrences of road failures. We used the modeled potential environmental impact to negatively weight roads for a least-cost path network analysis to 1573 points of interest in the forest. The network analysis showed that out of 8233 km of road analyzed in the forest, 3483 km (42%) must be kept in a modified road network to ensure access to these points. We found that the modified network had improved patch characteristics, such as significantly fewer cherry stem roads intruding into patches, an improved area-weighted mean shape index, and larger mean patch sizes, as compared to the original network. This analysis system could be used by any public agency to analyze infrastructure for environmental or other risk and included in other mandated analyses such as risks to watersheds.     

Cutting the cake: Supporting environmental fund allocation decisions

This paper describes a decision support model for allocating financial resources amongst multiple user groups in environmental management problems. The model is based on the multiple criteria analysis (MCA) method of compromise programming. It was used to inform the allocation of Natural Heritage Trust funds across 14 regions in Queensland, Australia. The model targets funding to those regions with greater natural resource management needs. Need is determined by 19 weighted criteria relating to natural resource assets and threats. The model was accepted by the Australian Government, Queensland Government and regional groups as an appropriate means for allocating program funds; first in 2005 and then again, with improvements, in 2007. This paper shows that an MCA model can improve the transparency, auditability and acceptance of allocation decisions which would otherwise be heavily politicised.     

新型动火安全防护盲板的研究与应用

介绍了新型石油石化生产动火作业配套工具动火安全防护盲板的结构、原理和使用方法 ,分析了它的特点和推广应用前景     

Real-time response system for the prediction of the atmospheric transport of hazardous materials

Human urge of exploiting earth resources has resulted into unprecedented industrial development in the last century resulting into production of large quantities of hazardous chemicals. Chemical, petrochemical, nuclear, biomedical and pharmaceutical industrial accidents release large quantities of hazardous chemicals into the atmosphere. The accidental discharge during production or storage or transportation have subjected the population to be exposed to exceptionally high concentration levels of hazardous chemicals, taking them by surprise, unprepared with fatal consequences. An emergency planning organization has to be trained to combat this situation in the shortest possible time to minimize the number of causalities. The present paper focuses on computation of dispersion model, using emission source, accident location and online metrological data near to the sources, to provide necessary and accurate results swiftly. The predicted ground level concentrations with the hazardous nature of the chemical, speed and direction of plume, the emergency team will be supplied with all the information in graphical easy to grasp form, superimposed over a GIS map or the latest satellite image of the area.

The emergency team has to be trained for all past scenarios and their preparedness, response and actions must be practiced regularly to be able to abate chemical releases accidentally or intentionally.

Accidental releases of chlorine and ammonia gases in residential and industrial areas are simulated. The predicted ground level concentrations in the effected areas are shown after different time intervals. For low vapor pressure chemical, the dispersion time is large and concentration levels are low but persist for prolonged time while for volatile chemical, the concentrations are high in short time and recovering to safe environment is quick.