Self-adaptive Filter Prediction Model of Lianyungang Port Throughput and Realization with Excel Macro
Wang Chuan-bin · Logistics Sci-tech · 2010
By analyzing the modeling process of the self-adaptive filter prediction,the self-adaptive filter prediction model is introduced to predict the port throughput based on the data of Lianyungang port throughput from several earlier months in 2008.Programs are realized to the iterative function alternately according to the principle of the smallest variance of forecast error using excel macro and VBA codes.In the iterative procedure the weights are chose to take the best weight corresponding to a smallest issue among the smallest variance of forecast error will carry on the forecast,which results show that the method can effectively solve the port throughput prediction problem.