The Development of Multivariate Statistical Process Monitoring (MSPM) Tools using Microsoft® Excel

• Main Author: Che Elliaziz, Mohd Syaufi
• Format: Final Year Project
• Language: English
• Published: Universiti Teknologi PETRONAS 2009
• Subjects: TP Chemical technology
• Online Access: http://utpedia.utp.edu.my/9164/1/2009%20-%20The%20Development%20of%20Multivariate%20Statistical%20Process%20Monitoring%28MSPM%29%20Tool%20using%20Microsoft%20.pdf; http://utpedia.utp.edu.my/9164/

Multivariate statistical process control methods have been proven in the process industries to be an effective tool for process monitoring, modelling and fault detection.This paper describes the approach used by the writer in the development of a Multivariate Statistical Process Monitoring (MSPM) tools using Microsoft Excel. This developed MSPM tools will act as a process monitoring tools in order to monitor the performance of any equipment or process. In addition, this project will be testing on actual plant data to see the performance of the project. The tool will be developed in Microsoft Excel and Matlab. Microsoft Excel is chosen because of it is easy to use and user-friendly. Furthermore, it has macro function and easier to use when the user wants to develop many tools to the Microsoft Excel. In multivariate statistical process monitoring, a process monitoring model must be developed firstly. The model must be free from any abnormality, fault or outliers. Then the model will be tested on the future data to detect any abnormality in the process by applying the appropriate Hmits. As a conclusion, the MSPM method can be develop in Microsoft Excel. This tool can help to detect the problem or abnormality of the process and help in diagnoss assignable cause for the process IV