Abstract: In order to prevent "overload bulge" or "outage" in each downloading tankfarm of the long-distance products pipeline, EXCEL and VBA software are used to intelligently compute the real-time inventory of such tankfarms during the process of transportation. With the "separation and combination" method, a large amount of multiple loop statements are adopted to deal with the data at each stage of operation scheme to calculate the inventory and vacant capacity of each downloading tankfarm at any time, so as to guide the managers to optimize the operation scheme, improve working efficiency and avoid accidents effectively. In this system, users can calculate the dynamic changes of inventory at each oil tankfarm during the operation process at any time before and after the staring of transportation according to their own needs, and the general schedule of transportation at pump stations can be automatically generated. Taking the SN-13-G93-034, SN-13-G97-035 and SN-13-G00-036 batches of South Jiangsu Pipeline in Huadong Pipeline Network as examples, this paper describes the data processing methods and compares the calculation results to the actual pipeline transportation, for purpose of judging the accuracy of this inventory prediction system. The result shows that this system can help with the establishment and refining of the operation scheme for products pipeline, reduce the workload of scheme preparation and increase its accuracy.