Abstract: In order to cover the deficiencies of the existing SCADA system in the Central China Control Center, and improve the safety of pipeline operation and the work efficiency of dispatchers, an assistant software for scheduling was developed using Excel VBA programming depending on the actual situations of the product pipeline network in central China. The software integrates multiple functions, including mixed oil interface tracking, voice warning, graphic animation displaying, and batch calculation. This paper presented the flow chart and algorithm, as well as main functional features of the software. Comparative analysis was made on effects of practical application and field data. It was indicated that the accuracy of interface tracking was mainly affected by temperature and pressure along the pipeline, and also by the receiving and blending of mixed oil. Accordingly, aspects and methods of improvement were proposed.