This paper introduces an iteration method of calculating trying difference in chemical engineering tube lines with Excel spreadsheet, which is easy to use without programming. The method can be applied in teaching and engineering calculating.

• 在化工管路的计算中；运用Excel电子表格进行试差迭代计算；无需编程；可直接准确、快速地得到计算结果；适用于教学与工程计算中.