Programming of Rank Analysis Method with Excel VBA
Hongyan Liu · Anhui nongye kexue · 2009
With Excel as the platform,a section of macro code was compiled with embedded VBA language.This program had the function of one-way anova and the grade value of average(H1),rank value(H2) and environmental index(YM) etc key parameters could be calculated with it.And the efficiency of data processing could be greatly improved.