According to the change of the operation conditions of a plant, operators must to adjust the operating conditions to meet product specifications, however, the wasting of energy could due to inappropriate operations. There force, a good navigation system could reduce the energy consumption. The objective of this study is to develop an equilibrium model of the distillation column on Excel-VBA platform with tray efficiency. The model can be used as the basis of a navigation system, the model was coded for the multi-component column containing components such as Dimethylacetamide, Acetic acid, 3-Methylpyridine, Glycerin, Water and Nitrogen.