CAJ | 학술논문

灰色预测是环境污染预测应用相当广泛的方法。根据文献报道，基于Matlab和Excel实现灰色预测中存在着占用内存、单元格填埋计算公式等等的不足，因此提出了一种基于VBA在Excel下编写宏程序轻松实现灰色预测的方法，并将其运用到北海市地表水污染物预测。结果表明，本程序简短，操作方便，计算结果准确可靠，彻底把用户从繁琐的手工操作中解放出来。
회색예측시배경오염예측응용상당엄범적방법。근거문헌보도，기우Matlab화Excel실현회색예측중존재착점용내존、단원격전매계산공식등등적불족，인차제출료일충기우VBA재Excel하편사굉정서경송실현회색예측적방법，병장기운용도북해시지표수오염물예측。결과표명，본정서간단，조작방편，계산결과준학가고，철저파용호종번쇄적수공조작중해방출래。
Grey Prediction model is widely used for environmental pollution forecast. According to current reports, the Grey Prediction model based on Matlab and Excel exists the shortcomings such as taking lot of memory and leaving off the formula in the cell. In this paper, the macro-program based on VBA in Excel was built to achieve the Grey Prediction model easily, and it was used to forecast the contaminants in surface water in BeiHai. It showed that the program was short and easy to operate, and the calculation results were accurate and reliable. The program would relieve the users from their tedious manual operation.