Quality detection laboratory abnormal data automatic identification method based on EXCEL

The invention discloses a quality detection laboratory abnormal data automatic identification method based on EXCEL. The method comprises the following steps: acquiring MES quality management system data as a judgment basis for realizing abnormal data in a database; and summarizing and calculating upper and lower limits of characteristic requirements of different steel types according to the screened mean values and standard deviations of the different steel types, comparing test data required to be checked every day with the upper and lower limits, finding out abnormal data exceeding the range, marking and summarizing the abnormal data into a report. According to the invention, upper and lower limit range deviations are automatically screened and generated; whether the test data is abnormal is automatically checked according to a formula; the exceptional data report is automatically generated, the complex work difficulty of checking and confirming normal data every day is greatly reduced; a manager can check