Abstract: Aiming at the problems in SP P&ID pipeline data sheet including information redundancy, inconsistent data and long proofreading man-hours, this paper develops the pipeline data sheet program by comprehensively applying SP P&ID Automation and Excel VBA based on the in-depth analysis of the object model and data model of SP P&ID. The application results show that the program is flexible and convenient, and the data processing is correct and efficient, laying a solid foundation for the 3D modeling with correlation to 2D and its intelligent application.

Key words: intelligent P&ID, SP P&ID, SP P&ID Automation, pipeline data sheet program