Predicting The Environmental Impact From Typical Pollution Sources To Groundwater With Analytical Solutionby Spreedsheets

With the rapid development of our country’s economy, environmental problems are becoming more and more serious.Especially in June 2011, In order to avoid industrial production growing environmental pollution, In September 2003 our country issued and implemented the 《China environmental impact assessment law》,it regulates that new or renewal project preparation of environmental impact assessment must be conducted. The law has played an important role in source control of construction projects that may cause environmental pollution. In June 2011, Ministry of Environmental Protection The People’s Republic of China issued 《 Environmental Impact Assessment Technical Guidelines — Groundwater Environment 》(HJ 610 — 2011). It has provided guidance and specifications in groundwater environmental assessment.In the application of 《Environmental Impact Assessment Technical Guidelines— Groundwater Environment 》, aimed at the problem of the groundwater environmental impact prediction model selection and application of inconsistencies, not standardized, the predicted results are difficult to verify, reaserching and developing the index and model for groundwater environmental impact prediction and groundwater environmental impact assessment regulations forecasting model platform is imperative to support groundwater environmental impact prediction assessment and management regulation.The Guidelines clearly required that secondary evaluation uses analytical method and numerical method. For numerical method, there are mature visualization software, such as GMS,Visual Modflow, Feflow and so on, but they are all business softwares and they are very expensive. In addition, establishing a numerical model needs a lot of data. The simulation must be through modeling construction, model identification, model validation three phases, long cycle and prone to errors.For the environmental assessment engineer who are not good at numerical simulation,it becomes more difficult. In order to solve this problem, this paper researches the change of the concentration of pollutions in the whole process from vadose zone to aquifer and implements the visualization programming interface of the corresponding analytical model with Excel VBA based on Excel. It finally serves for 《 Environmental Impact Assessment Technical Guidelines—Groundwater Environment》 and provides a simple way for groundwater assessment in the region with single hydrogeological conditions and stable water flow. It also provides some supports in the fields of the protection of drinking groundwater resources and the prevention and control planning for the pollution groundwater. Analytical solutions can also be used to verify the reliability of the numerical solution. In the complex hydrogeological system, the analytical solution is very useful for the hydrological geological workers. It can estimate the diffusion coefficient of the solute and has great significance for data collection and water quality monitoring.analytical model, analytical solution, groundwater, solute transport,...