CROSS REFERENCE TO RELATED APPLICATION This application claims the benefit of U.S. Provisional Patent Application No. 60/464,461, filed Apr. 21, 2003.
BACKGROUND OF INVENTION Manufacturers have long sought tools to help gather, manipulate and analyze data from its manufacturing processes. Such data can be useful in preventing costly breakdowns of the manufacturing equipment and can help prevent faulty products from being produced. Further, in relation to manufactured products that have to meet certain specifications before they can be sold, it is imperative for manufacturers to continually monitor produced products and the manufacturing process to ensure that the specifications are actually being met. As one can imagine, if a faulty manufacturing process or a malfunctioning piece of equipment goes undetected, then the manufacturer will have products that fail to meet the required specifications. Thus, the longer a faulty process or equipment remains undetected, the more resources, time and money is being wasted.
To address this concern, certain monitoring equipment and systems have been developed to gather data that can be useful in preventing such malfunctions from occurring. For example, programmable logic controllers (“PLCs”) and human machine interfaces (HMIs) have been developed to monitor and control manufacturing equipment and processes. A PLC can be programmed to monitor and control a specific measure (i.e. flow rate) of a manufacturing process. For example, if a manufacturing process requires a flow rate of 5 gallons per minute of material, then the PLC can be programmed to continually monitor the flow rate of the process. In the event the flow rate ceases to be meet this 5 gallons per minute target, the PLC an be programmed to take adjustments to bring the process back into compliance. HMIs identify a computer system that enables a user to view the data collected by the PLC and enables the user to communicate with the PLC. Thus, in our example, if a user desires to decrease or increase the flow rate, the user can use the HMI to instruct the PLC to do so. This data collected by the PLCs and HMIs is usually automatically stored in a database for a certain duration of time.
Manually collected data is also collected by plant personnel. Plant personnel perform tests in labs and on plant floors to determine if the manufactured products meet the required specifications. The analysis of this data is also useful in determining if a manufacturing process is faulty and/or if manufacturing equipment is malfunctioning. Further, the analysis of this data can also help determine measures that can be taken to fix the process or equipment. This data is stored in a separate database from the PLC and HMI database.
If they have the proper tools, manufacturers realize that the data collected by the PLCs and HMIs can be analyzed in conjunction with the manually collected data from tests to determine if the products are meeting the desired specifications. Current methods use systems interfaces, redundant data entry and multiple user interfaces to analyze process, test and statistical data. Thus, vital information is not immediately accessible to the manufacturer's personnel in real time on the plant floor and cannot be used to immediately alert the plant personnel when the products do not meet the specifications. Thus, such a system and method are not useful in preventing the production of products not meeting the desired specification, because the system and method does not provide real time data to the plant personnel.
Thus, among other things, it is desired to have a system and method that generates real time views of information and eliminates the heavy reliance on information technology (“IT”) personnel to build customized system for each plant facility. It is further desired to have a system and method that eliminates the multiple data entry points (i.e. the entry of PLC and HMI collected data in one database and the entry of test data into a separate database) and that eliminates the use of multiple databases for the storing of manufacturing data (i.e., use of one database for the collection of PLC and HMI data, use of another database for test data entry, and the use of a third database for statistical processing). Moreover, it is desired to have a system and method that can easily and quickly be customized to any manufacturing plant and that enables plant personnel to configure customized views of the plant manufacturing process data It is also desired to have a system and method that can be tailored to focus on certain specifications of the product and that alerts the plant personnel in real time when manufacturing process is producing products that do not meet those specifications.
BRIEF INVENTION SUMMARY The present invention provides a method and system for managing and measuring the performance of any manufacturing plant or any set of manufacturing plants through the collection and analysis of manufacturing data. The method and system provides data in real time to an end user (i.e., plant personnel) and can be easily customized to any manufacturing plant and its products and processes. This system and method provides an end user with a means for creating customized reports and views of the data without relying on IT personnel. The system and method interfaces directly with a database in order to access the stored data and does not require multiple database, multiple points of data entry or the transfer of data.
An embodiment of the present invention comprises a method of and system for plant management. This embodiment collects and stores pieces of data from a manufacturing sub-process on a single database through a data collecting apparatus. This embodiment utilizes a key process indicator dashboard (“KPI dashboard”) with a statistical process control subsystem (“SPC subsystem”) to access the pieces of data stored on a single database. A user of the KPI dashboard can set a range of specifications (i.e., a range of values that the data needs to fall within) for each piece of data that is collected. The SPC subsystem will notify the user of the KPI platform in real time when the value of the piece of data falls outside the range of the specifications. The data collecting apparatus can comprise a PLC, a HMI and/or a quality data entry subsystem (QTDE subsystem). The QTDE subsystem can contain a plurality of data entry sheets that allow for the manual entry of test data directly into the single database. Thus, this embodiment eliminates the multiple data entry points through the collection of the PLC data, the HMI data and the data manually entered through the QTDE subsystem in the single database.
The KPI platform along with its corresponding Ad Hoc Reporting subsystem and SPC subsystem can generate customizable real time reports for users (i.e., plant personnel). The KPI platform can comprise a plurality of screens that allow the user to customize the platform to the specific plant, manufacturing process and the product produced. For example, it allows an end-user to set alarms and specification values for each product and measure through the Update Alarms and Specifications screen and allows an end-user to input information specific to the plant and the manufactured products through the Product and Information screen.
BRIEF DESCRIPTION OF THE DRAWINGSFIG. 1 shows a diagrammatic view of an exemplary embodiment of a plant management system that includes an ADC dashboard;
FIG. 2ashows a screen shot of the ADC dashboard dropdown menu positioned on a toolbar;
FIG. 2bshows a screen shot of this embodiment's main KPI dashboard that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby selecting the “Main Dashboard” tab;
FIG. 3 shows a screen shot of an Alarms Summary screen that can be accessed through the ADC dashboard's dropdown menu ofFIG. 2aby selecting the “Alarms Summary” tab;
FIG. 4ashows a screen shot of an Alarms and Specifications screen that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby selecting the “Update Alarms and Specs” tab;
FIG. 4bshows a screen shot of the View All Alarms and Specifications screen that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby selecting the “View all Alarms and Specs” tab;
FIG. 5 shows a screen shot of the Product and Plant Information screen that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby selecting the “Plant Information and Setup” tab;
FIG. 6 shows a screen shot of the Analysis Report that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby selecting the “Analysis” tab;
FIG. 7 shows a screen shot of the Three Tag Correlation Report that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby clicking on the “Three Tag Correlation Report” tab;
FIG. 8 shows a screen shot of the Workbench Report that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby clicking on the “Workbench” tab;
FIG. 9 shows a screen shot of a Board Profile screen that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby clicking on the “Board Profile” tab;
FIG. 10 shows a screen shot of the SPC module that can be accessed through the ADC dashboard dropdown menu ofFIG. 2aby clicking on the “Statistics” tab;
FIG. 11ashows a screen shot of a Reasons and Actions pop-up window that can be accessed through the SPC module ofFIG. 10 by clicking on an out-of-control button;
FIG. 11bshows the Reasons and Actions pop-up window ofFIG. 11awith inputted data in the window;
FIG. 12 shows a print-out of a sample Best Practices Guide that can be accessed through the Reasons and Actions pop-up window by clicking on the “Best Practices Guide” button;
FIG. 13 shows a log-in screen for the SPC Quality Reporting subsystem of the SPC module;
FIG. 14 shows a screen shot of the main menu for the SPC Quality Reporting subsystem;
FIG. 15 shows a sample Monthly Quality Report generated by the SPC Quality Reporting subsystem by clicking on the “Monthly Quality Report” button on the main menu shown inFIG. 14;
FIG. 16 shows a screen shot of a Monthly Board Weight Report generated by the SPC Quality Reporting subsystem by clicking on the “Monthly Board Weight Report” button on the main menu shown inFIG. 14;
FIG. 17 shows a screen shot of a Product Data screen generated by the SPC Quality Reporting subsystem by clicking on one of the “Set-Up” buttons on the main menu shown inFIG. 14;
FIG. 18ashows a screen shot of a Product Detail Report screen generated by the SPC Quality Reporting subsystem by clicking on one of the “Product Detail” buttons on the main menu shown inFIG. 14;
FIG. 18bshows a screen shot of the 3-month rolling average and 3-month period ending sections of the Product Detail Report screen ofFIG. 18a;
FIG. 18cshows a screen shot of the current year-to-date and monthly averages sections of the Product Detail Report screen ofFIG. 18a;
FIG. 19 shows a screen shot of the top level screen for the Ad Hoc Reporting subsystem;
FIG. 20ashows a screen shot of both the date and time dropdown menus of the top level screen ofFIG. 19;
FIG. 20bshows a screen shot of the plant dropdown menu of the top level screen ofFIG. 19;
FIG. 20cshows a screen shot of the select period/frequency dropdown menu of the top level screen ofFIG. 19;
FIG. 20dshows a screen shot of the server select dropdown menu of the top level screen ofFIG. 19;
FIG. 20eshows a screen shot of one of the measure dropdown menus of the top level screen ofFIG. 19;
FIG. 21 shows a screen shot of a Dry End Manual Data Entry screen of the QTDE subsystem that is a part of the plant management system ofFIG. 1;
FIG. 22 shows a screen shot of a Mill Manual Data Entry screen of the QTDE subsystem;
FIG. 23 shows a screen shot of a Wet End Manual Data Entry screen of the QTDE subsystem;
FIG. 24 shows a screen shot of a Knife Manual Data Entry screen of the QTDE subsystem; and
FIG. 25 shows a screen shot of a Lab Manual Data Entry screen of the QTDE subsystem.
DETAILED DESCRIPTION OF THE INVENTIONFIG. 1 shows a diagrammatic view of an exemplary embodiment of aplant management system10. In this embodiment,plant management system10 is utilized to manage and monitor several manufacturing sub-processes for the production of wallboard products. As shown inFIG. 1, thesystem10 hasmanufacturing equipment14 electronically and operatively connected to several programmable logic controllers (PLCs)12 by means well known in the art, (i.e., sensors and wires).PLCs12 can be programmed to measure and collect any type of data from themanufacturing equipment14 and the manufacturing sub-process being performed. For example, PLC's12 can be programmed to measure and collect line speeds, temperatures, feed rates, flow rates, pressure, density, moisture, machine speed, motor speed, weight, motor amps, viscosity, width, length, and caliper measurements.PLCs12 are electrically and operatively connected to a series of human machine interfaces (HMIs)16 and aplant database28 by means well known in the art (i.e. cables18).HMIs16 can comprise a series of computers connected to one another in a network. It will be appreciated that electrically and operatively connected includes any number of means of connecting electronics together known in the art including, but not limited to, a network or wireless communication. Further, it will be appreciated that plant database can comprise any type of database known in the art, including a relational database or customized high speed storage database. TheseHMIs16 allow users to monitor, control and collect data fromPLCs12. Each of thePLCs12 andHMIs16 monitor, measure and collect data relating to a specific and separate manufacturing sub-process that is being performed in the plant. The collected data is then transferred to and stored inplant database28. This stored data can then be used by users to relate an end-product to each stage of its manufacturing sub-process.
Still referring toFIG. 1,HMIs16 are connected to a processinformation isolation switch20 and aplant router22 that allows the plant to access both data local to the plant, as well as, data from other plants connected to the process information isolation switch.Plant router22 can be electronically connected by a hi-speed phone line25, or other like means known in the art, to anotherrouter24 that allows a central repository, such as adatabase26 at a corporate office, to store the data collected by all thePLCs12 and/orHMIs16 in several different plants. Both theplant database28 and thecorporate database26 are electronically connected to aplant ADC dashboard30 and acorporate ADC dashboard32, respectively. The ADC dashboard can reside on any type of computer or local file server and acts as an interface to the database. In one embodiment, the dashboard comprises a Microsoft Excel add-in that can be coded to act as the ADC dashboard. Theplant ADC dashboard30 provides a system that allows a user to view and analyze the data for the specific plant. Thecorporate ADC dashboard32 provides a system that allows a user to view and analyze data for a specific plant or for a consolidated corporate view of multiple manufacturing facilities. Whiledashboards30 and32 are located in different locations, they are virtually identical and are used primarily for the same purposes.
For ease of the reader, the detailed description of the ADC dashboard focuses on theplant ADC dashboard30. However, it will be appreciated that this discussion is equally applicable to thecorporate ADC dashboard32. Focusing on theplant ADC dashboard30, the dashboard provides access to a configurable key process indicator dashboard (“KPI”)40, a Ad Hoc Reporting subsystem, a statistical process control subsystem (“SPC subsystem”) with a statistical process control module (“SPC module”)36, and a SPC Quality Report subsystem. Further, theADC dashboard30 is connected to a network with theplant database28 and a quality test data entry subsystem (“QTDE subsystem”)38.
FIG. 2ashows this embodiment'stoolbar11 with the ADC dashboarddropdown menu48. As used herein, a “dropdown menu” is a menu that allows the user to highlight and select one of several defined choices. When a user clicks on thedropdown menu48, a list of all the screen tabs associated with the ADC dashboard will be displayed.Dropdown menu48 has a “Main Dashboard”tab39 that will take a user tomain KPI dashboard40.FIG. 2bshows a screen shot of this embodiment'smain KPI dashboard40. The KPI dashboard does not require a separate database structure or the creation of data transfer files to access the plant database.KPI dashboard40 allows the user ofplant management system10 to directly access theplant database28 and configure and manipulate the data stored therein. This data could be the data collected by thePLCs12 and/or HMIs16 (shown inFIG. 1) and could also include quality test data gathered from the physical testing of in-process and end-product attributes entered into the plant database through theQTDE Module38, as described below.
As shown inFIG. 2b,KPI dashboard40 comprises two date selection dropdown windows42 and a manufacturing sub-process selection field54. Field54 contains several manufacturingsub-process radio buttons55 that allow the user to select a specific manufacturing sub-process for which the user would like to see data. The user can change the title of the manufacturingsub-process radio button55 by typing over the current name. After selecting the desired manufacturingsub-process radio button55, a plurality ofindividual measures44 will appear in aperformance measure field45. Each of thesemeasures44 are associated with adropdown arrow57 and acorresponding measure button122. By clicking ondropdown arrows57, the user will be presented with all the measures being collected and will be able to select the desired measure by highlighting it. For example, in this embodiment, the user has selected the “kiln Temp/Moist” manufacturing sub-process in field54 and the user has selected seven correspondingmeasures44 in performance measure field45 (i.e.,zone #1 inlet stem temp.;zone #1 exit stem temp, etc.) utilizingdropdown arrows57. Of course, the user can change, delete or addmeasures44 at any time by clicking ondropdown arrows57.
In this embodiment, up to six manufacturingsub-process radio buttons55 are available from which to select in field54 and up to twelvemeasures44 are allowed to be defined for each manufacturing sub-process radio button. While this embodiment allows up to six manufacturingsub-process radio buttons55 to be defined in field54 and allows twelvedifferent measures44 to be defined for each sub-process, theKPI dashboard40 can be programmed to define any number of manufacturing sub-processes and measures associated with those sub-processes. Moreover, for larger more complex manufacturing sub-processes, multiple KPI dashboards may be used for a plant by an individual user of the system.
Date selection menus42 allow the user to select two days of interest at once for review by utilizing the correspondingdropdown arrow57. These two dates can be consecutive or non-consecutive days. While this embodiment provides two date selection menus42, theKPI dashboard40 can be configured to show any number of date selection menus. When the manufacturing sub-process and the dates are selected,KPI dashboard40 pulls all of the data from plant database28 (shown inFIG. 1) for the selectedmeasures44 for the selected dates. TheKPI dashboard40 then compares thosemeasures44 to a set of defined alarm or warning specifications.KPI dashboard40 then calculates and displays the total number of times that these measures of the selected manufacturing sub-process exceeded or did not reach the desired specifications (i.e. an alarm) for eachmeasure44. In this embodiment, theKPI dashboard40 displays the number of alarms for eachmeasure44 in threedifferent columns41.Columns41 refer to a specific manufacturing shift (i.e., first, second and third shifts). To view the details regarding the alarms, the user can click on thealarm buttons53 to receive more information about each alarm. This will transfer the user to an Alarms Summary screen.
Referring toFIG. 2a,a user can also access the Alarms Summary screen by selecting theAlarms Summary tab79 fromdropdown menu48.FIG. 3 shows a screen shot of anAlarms Summary screen80. TheAlarms Summary screen80 provides analysis for alarm conditions that occurred during the selected day. As shown inFIG. 3, the Alarms Summary page provides a radio button82 for each shift that allows a user to select a specific shift for which a user desires to see an alarm summary. If a user accessesscreen80 by clicking on one of thealarm buttons41, then a shift will automatically be selected. This shift can be changed by selecting a different radio button82. In this embodiment, theAlarms Summary screen80 displays a list84 of all the alarms. This list84 provides the date and time the alarm occurred, the value of the measure that caused the alarm, and the product code that identifies the product being analyzed. A user can use ascroll bar85 to scroll through the individual values of the list. TheAlarms Summary screen80 also shows a histogram86 that groups the values of the measures from the minimum values to the maximum values.
TheAlarms Summary screen80 also displays an alarms summary chart88 with the value of the selectedmeasure44 from theKPI dashboard40 on the y-axis and the time and date on the x-axis. The alarms summary chart88 has a line A that corresponds to the value of the low alarm setting and a line B that corresponds to the value of the high alarm setting. The values of the low and high alarm settings and the total number of alarms that occurred during this shift are displayed infield87. Anything that does not fall within this high and low alarm range is plotted as apoint83 on the chart88 to summarize the alarm. A user of this screen can use a hide/showproduct code button89 in order to display or hide the product code of the product being manufactured.
FIG. 4ashows a screen shot of an Alarms and Specifications screen46. As shown inFIG. 4a,Alarms and Specifications screen46 allows a user to define the range of the values for the alarms and specifications. As used herein, the term “specification” refers to the values of a measure of a product that must not be exceeded or that must be exceeded for the user to be able to sell the product (i.e. a regulatory specification or a customer specification). As used herein, the term “alarm” refers to the values of a measure of a product that are close to and fall within the range of the values of the specification, so that when the alarm values are reached, the user will be notified that the measure is close to the specifications. Referring toFIG. 2b,if specifications have not been set for aparticular measure44 on the KPI dashboard, asetup target button34 will appear on the KPI dashboard. In this embodiment, the Alarms and Specifications screen46 can be accessed by pressing thesetup target button34 on theKPI dashboard40 or if alarms and specifications have been set for each measure, by selecting the “Update Alarms and Specs”tab47 from the dropdown menu48 (shown inFIG. 2a).
Referring toFIG. 4a,likemain KPI dashboard40, the Alarms and Specifications screen46 has a manufacturing sub-process selection field54 that allows the user to select the specific manufacturing sub-process for which it desires to configure alarms and specifications. Further, the Alarms andSpecifications46 screen has ameasure menu50 with correspondingdropdown arrow57 that allows a user to select one of the twelvemeasures44 selected by the user on the KPI dashboard40 (show inFIG. 2b). Once a user selects one of the measures inmenu50, the user can configure alarms and specifications for that measure in adata entry area52. For example,FIG. 4ashows that the user has selected the Mill sub-process data tab from the field54 and has selected the “Calcine #6 Outlet Temp” measure from themenu50. After selecting these two items, the user is allowed to set a high and low alarms and an upper and lower specification limits for that component of the manufacturing sub-process. The user can update/store the alarm data by hittingupdate button435 or cancel and return toKPI dashboard40 by clicking cancelbutton436.
Referring back toFIG. 2a,dropdown menu48 also has a “View all Alarms and Specs”tab49 that provides access to a View All Alarms andSpecification screen58.FIG. 4bshows a screen shot of the View All Alarms andSpecification screen58. As shown inFIG. 4b,sheet58 displays the high and low alarms and the upper and lower specification limits that have been set by the user for each product. This screen allows the user to scroll up and down and side-to-side using twoscroll bars85, and allows the user to print thescreen58 by clicking on printer icon59.
Referring back toFIG. 2a,thedropdown menu48 also has a “Plant Information and Setup”tab56. Upon selectingtab56, a user is transferred to a Product andInformation screen60.FIG. 5 shows a screen shot of the Product andPlant Information screen60.Screen60 is used to define the key attributes needed to tailor the system to a specific plant's operation. As shown inFIG. 5, information regarding the products manufactured by the plant can be entered and displayed in aproduct information field62. In this embodiment,field62 can contain information for up to one hundred products. Such information is split into aproduct description column64, aproduct code column66, awidth column68 and aPLC value column70. Theproduct description column64 identifies the product being manufactured and theproduct code column66 lists the corresponding product/catalog code for that product. In this embodiment, thePLC value column70 identifies the specific PLC collecting data for the manufacturing sub-process that produces that product. Whilefield62 of this embodiment is programmed to provide a product description, a product code, a PLC value and the width for up to one hundred products,field62 can be programmed to provide any information desired by the user and can be programmed to store information for any number of products.
Still referring toFIG. 5, the Product andPlant Information screen60 also contains ashift information field72 that provides the start time and end time for each shift. Further,screen60 contains a line configuration field74 that indicates the appropriate line number for the products listed and whether or not the plant has dual lines.Screen60 also has aplant information field76 that allows the user to define the physical dimensions of the equipment that moves material between the manufacturing sub-processes. By providing these fields inscreen60, this embodiment allows theKPI dashboard40 to be configured for any plant and be used to correlate data from multiple manufacturing sub-processes at once. This capability allows a finished product to be time traced through every step of the manufacturing process.
Three distinct types of process run charts for the selected sub-process can be automatically generated for any selectedmeasure44 or set of measures44 (shown inFIG. 2b). Referring toFIG. 2a,dropdown menu48 allows a user to access one of these three run charts by selecting either the “Analysis”tab91, the “Three Tag Correlation”tab101, or the “Workbench” tab111.
FIG. 6 shows a screen shot of theAnalysis Report90. As shown inFIG. 6, theReport90 is a run chart for a single selected measure. Once the user has accessed theAnalysis Report90, the user can select a measure to be charted and a time frame to chart the selected measure. In this embodiment, by selecting one of theradio buttons92, the user can choose a two hour, four hour, eight hour, twelve hour or twenty-four hour view of a selected measure of interest. The user can also use the measure menu94 and correspondingdropdown arrow57 to select the desired measure to be charted. Menu94 lists all of the measures stored in the plant database. After selecting the measure from menu94 and theradio button92 associated with the desired time frame,Report90 will be generated. User can also use dropdown menus440 to select the date and end time for the report, as well as use, Hide/Show Product button89, to hide the product code.
Still referring toFIG. 6,Report90 generates achart98 on an x and y-axis. The x-axis displays the date and time and the y-axis displays the value of the measure.Chart98 also displays the high and low alarm settings in field99 and allows the user to move forward and backward in time by utilizing the time scroll buttons96. Ahistogram93 is also created that shows the value of the measure from the minimum to the maximum value.Report90 also generates ascrollable list95 that displays the date and time the measure was taken, the value of the measure, and the product code for the product measured.
FIG. 7 shows a screen shot of the ThreeTag Correlation Report100.Report100 allows a user to view the run charts for three related measures or allows a user to view the run charts for the same measure over three different time frames. Report100 also providesradio buttons92 that allow the user to select from a time period of two, four, eight, twelve, and twenty-four hours, hide/show product button89, and provides time scroll buttons96 that allow the user to move forward and backward in time.Report100 has a main measure field108 with adropdown measure menu102 and two secondary measure fields109 each with adropdown measure menu103.Menu102 allows the user to select a main measure that will be charted and compared to the two measures selected throughmenus103. Fields108 and109 each havetime stamp windows104. Thetime stamp windows104 of fields109 will automatically be synchronized with the time selected intime stamp windows104 in field108. However, the individualtime stamp windows104 will allow the user to override the automatic synchronization of the selected time frame so that each field can have a different selected time frame. Report100 also generates ascrollable list105 in fields108 and109 that displays the date and time the measure was taken, the value of the measure taken, and the product code of the product from which the measure was taken. Report100 also generates twocharts106 on an x and y-axis that compare the main measure of field108 individually with the other two selected measures of fields109. The x-axis lists the date and time and the y-axis lists the value of the measures.
FIG. 8 shows a screen shot of theWorkbench Report110.Workbench Report100 allows the user to select up to eight separate measures of interest fromdropdown menus450. If desired, the user can select the same measure, instead of different measures, inmenus450 for charting over four different time periods.Report110 provides eight separate time anddate stamps452 that allow the user to select the desired time and date for each measure. As shown inFIG. 8,Report110 also provides:buttons92 that allow the user to select from a time period of two, four, eight, twelve, and twenty-four hours; hide/show product button89; andscroll buttons112 that allow the user to scroll backwards and forwards through the data on all the produced charts. Fourdifferent charts113 are produced byReport110 infields116. Eachfield116 has twodropdown measure menus450 that allow the user to select two measures to be compared to one another or a single measure to be compared over two different time frames. Further, eachfield116 also has two end time stamp windows anddate stamp windows452 that allow the user to select the end time and date for each selected measure inmenu450 independently of the other measure. Eachchart113 has an x-axis that displays the date and time when the measure was taken and a y-axis that displays the value of the measures. Eachchart113 also has itsown scroll buttons115 that allow the user to move each chart separately backward and forward in time.
Plant management system10 also allows the user to generate custom reports.FIG. 19 shows a screen shot of thetop level screen250 for an AD Hoc Reporting subsystem ofplant management system10. The subsystem can be accessed by clicking on a shortcut that is located on a desktop or laptop computer. The subsystem allows the user to configure customized reports of the plant data and information stored in theplant database28 without having any knowledge of the underlying database design or programming skills. Such reports can replace manual logs or support process analysis.
Still referring toFIG. 19, after accessing the Ad Hoc Reporting subsystem, the user will be presented with several dropdown menu boxes that will allow the user to customize a data report. The user will be presented with a starting datedropdown menu252 and a starting timedropdown menu253.FIG. 20ashows a screen shot of both the date and timedropdown menus252 and253. As shown inFIG. 20a,once a user clicks on the datedropdown menu252, the user will be presented with a calendar to select a desired day of a desired month. The user can change the month that is being viewed by using scrolling buttons254. After selecting the date, the user can then select the desired start time by clicking on the timedropdown menu253. As shown inFIG. 20a,after clicking on the timedropdown menu253, the user will be presented with each hour for the selected day.
Referring back toFIG. 19,top level screen250 also has a plantdropdown menu255 that allows the user to select the desired plant to run the report from.FIG. 20bshows a screen shot of the plantdropdown menu255. As shown inFIG. 20b,the plantdropdown menu255 presents the user with all of the plants that are tied intoplant management system10. Further,top level screen250 also has a period/frequency dropdown menu256.FIG. 20cshows a screen shot of the period/frequency dropdown menu256 of thetop level screen250. As shown inFIG. 20c,period/frequency menu256 allows a user to view the data by different periods of time (i.e., a day, a week, a month, etc.) and that allows the user to select the frequency of the data that is seen during that time period (i.e., every 15 minutes, every hour, every 2 hours, etc.).Top level screen250 also has a serverdropdown menu257 that allows the user to select the desired server to run the report from.FIG. 20dshows a screen shot of the server selectdropdown menu257. As shown inFIG. 20d,the user can select the server (i.e., the plant server or corporate server) from which the data is retrieved.
Referring back toFIG. 19, thetop level screen250 also allows the user to select the measures of which he and/or she would like the report to contain. In this embodiment,top level screen250 has 25 measuredropdown menus258 that each correspond to an independent column.FIG. 20eshows a screen shot of one of the measuredropdown menus258. As shown inFIG. 20e,the user can click on the down arrow for each of thesedropdown menus258 to select the desired measures to be retrieved from the plant or corporate database. The user can select one measure for each of the twenty-five columns listed in the report. While this embodiment has twenty-five columns and measure dropdown menus, the Ad Hoc Reporting subsystem could be configured to contain any number of measure columns.
Referring back toFIG. 19, once the user has finished configuring thetop level screen250 of the Ad Hoc Reporting subsystem, the user can press the retrievedata button259 to populate the query. The subsystem will retrieve the values of the measures requested for the selected period of time and frequency, and will calculate the average and the standard deviation of the selected measures. Once the data is retrieved, the user can choose to save the report by clicking on the “save to file”button260. Scrollbuttons261 are also provided on the top level server to enable the user to scroll back and forth through the data.
Referring back toFIG. 2a,dropdown menu48 has a “Board Profile” tab171. By clicking on the Board Profile tab171, a user can access a screen that will enable the user to view product specific information. In this embodiment,plant management system10 is being used to monitor, collect and manipulate data from a wall board manufacturing plant. Thus, this embodiment provides a screen that will enable the user to view the actual profile for any of the produced wall boards.FIG. 9 shows a screen shot of aBoard Profile screen170. As shown inFIG. 9, a user can use dropdown product menu172 to select the product of which the user would like to view the profile. After selecting the product,Board Profile screen170 will plot the physical profile of the selected product on a knife caliper chart174 and a dryend caliper chart176. Each chart allows the user to select a “look before” date and time indropdown menus178. After selecting the “look before” date and time, the system will search the plant database for a sample taken on the chosen product prior to the specified date and time. Window180 will display the date and time for the first sample found in the plant database that meets the search criteria.
Still referring toFIG. 9,charts174 and176 plot the profile of the retrieved sample based on the caliper measures taken for that sample (the y-axis) for each inch of the width of the selected product (the x-axis). The plotted information for the knife caliper chart174 and dryend caliper chart176 are also displayed in knife caliper table182 and dry end caliper table184, respectively. The physical characteristics and properties of the particular sample are also shown on theBoard Profile screen170 in various property tables186. In this embodiment, such characteristic and physical properties include, but is not limited to, the width, weight and water loss of the selected board.Board Profile screen170 also hasscroll buttons188 that allow a user to scroll through all the samples in the plant database that were taken prior to the specified “look before” date.Board Profile screen170 also allows the user to display the board profiles from the code edge to the opposite edge of the board, or vice versa by selecting one ofradio buttons460.
Referring back toFIG. 2a,dropdown menu48 has a “Statistics” tab119. By clicking on Statistics tab119 or by clicking on themeasure buttons122 on the KPI dashboard40 (shown inFIG. 2b), a user can access the statistical process control subsystem (“SPC subsystem”) throughSPC module36. The SPC subsystem allows the user to produce control charting and reporting directly from the source plant database. No interfaces or intermediate file structures are needed to generate the desired statistical views of the data from theSPC module36.
FIG. 10 shows a screen shot of theSPC module36. As shown inFIG. 10,SPC module36 has acontrol toolbar120 with time and datedropdown menus121 that allow the user to select the desired date and time for the SPC module to search for a process change. Once the user defines the date and time for the process change,SPC module36 collects the historical data from the plant database28 (shown inFIG. 1) and calculates statistics for a specific measure and product to generate a series of points. Each generated point comprises a group of samples of the selected measure taken from the selected product during the manufacturing sub-process. In this embodiment,SPC module36 utilizes25 points to calculate the average upper control limit (“UCL”)123 for the values of the samples, the average lower control limit (“LCL”)124 for the values of the samples, the average value of these samples (“X2Bar”)125, theUCL127 of the range of differences between the sample values, theLCL126 of the range of differences between the sample values, and the average range (RBar)117 of differences between the sample values. Thecontrol data toolbar120 displays the number of points used to calculate these statistics and displays thestandard deviation128 for these points. These statistics can be saved for the chosen date and time by clicking on thesave button129 on thecontrol data toolbar120. Further, a user can select a different time and date, and cause theSPC module36 to recalculate these statistical values by clicking on the “ReCal”button130.
Still referring toFIG. 10,SPC module36 also flags and displays a running count of out-of-control conditions (i.e. points that exceed the UCL or do not reach the LCL) on the error condition display132. Display132 can identify the type of errors (i.e. range errors vs. average errors) by using a color to identify the range errors and another color to identify average errors. In this embodiment, average errors appear in blue and range errors appear in green.SPC module36 generates achart135 displaying the average values of the samples for each point over a specific period of time and a chart136 displaying the range values of the samples for each point over a specific period of time.
Still referring toFIG. 10,SPC module36 has achart parameters toolbar133 that allows the user to select the product code from dropdownproduct code menu141 and corresponding manufacturing sub-process measure fromdropdown measures menu137. Further, user can usedropdown menus138 to select the sample rates forcharts135 and136, and drop downmenu134 to select the date and end time. Further, the user can select month-to-date data or 3-month data throughdropdown menu145. In this embodiment, the sample rate gives the user the ability to display the system's automatically collected data every 1, 2 or 3 hours. After all these parameters are set, the user can then click on the “Go”button139 in order to causeSPC module36 to generatecharts135 and136. Once the charts are generated,parameters toolbar133 will display the number ofpoints142 displayed on each chart and the user can utilizescroll buttons143 to scroll through the data points. At any time the user wishes, the user can change any one of the parameters and generate a new set of charts by clicking onGo button139.
Chart135 displays the average values of the samples taken for each point on the y-axis and the corresponding point number on the x-axis. Chart136 displays the range value between the lowest sample and highest sample taken for each point on the y-axis and the corresponding point number on the x-axis. The average value and range value is listed for each point in table144. Table144 also lists the time/date for each sample that makes up the point, along with the value of each sample. In this embodiment, the samples that make up each point range from three to five. While this embodiment uses three samples to define a point, the system could be programmed to use any number of samples to define a point.
Chart135 will display theaverage UCL123, the average LCL124 and theX2Bar125 for the measure selected. Similarly, chart136 will display therange UCL127, therange LCL126 and theRBar117 for the measure selected.SPC module36 will plot all the number ofpoints142 listed in theparameters toolbar133. Any point that exceeds theaverage UCL123 and/or therange UCL127, or does not reach the average LCL124 and/or therange LCL126 will be flagged by out-of-control buttons148. The user can click on the out-of-control button148 to be taken to a Reasons and Actions pop-upwindow150.
FIG. 11ashows a screen shot of pop-upwindow150. As shown inwindow150, the window displays atime stamp column152 that shows the time and date for each sample that defines the out-of-control point, and avalue column154 that shows the value for each sample that defines the out-of-control point.Window150 has four dropdown menus for each sample displayed. The dropdownreason code menu156 and correspondingdropdown description menu158 allow the user to select from several pre-defined reasons for the point being out-of-control. If none of the pre-defined choices explain the reason for the out-of-control point, the user can select an “other code” that allows the user to enter another reason for the discrepancy indropdown description menu158. The user is also presented with a correctiveaction code menu160 and a corresponding descriptiondropdown menu162 that allows a user to select from various pre-defined corrective measures taken by the plant to prevent the out-of-control point from occurring again. As with thereason code menu156, the user can select an “other” code to provide a customized description of a corrective measure taken.
If the user needs assistance in determining what the problem may be and what corrective actions should be taken,window150 provides a “Best Practices Guide”button164 that allows the user to access a document that provides diagnostic and preventive guidance (“Best Practices Guide”).Best Practices Guide166 can also be accessed through dropdown menu48 (shown inFIG. 2a) by selecting the BestPractices Guide tab470.FIG. 12 shows a print-out of a sampleBest Practices Guide166. As shown inFIG. 12,Guide166 provides potential reasons and solutions for specific scenarios that may be encountered during the selected manufacturing process. This will help the user select the proper code and describe the reason for the out-of-control point and the proper code and description of the corrective measure taken. Once the user selects the proper code and description of the reason for the out-of-control point frommenus156 and158 and the proper code and description of the corrective action taken frommenus160 and162, the user can save this information in theplant database28 by clicking on savebutton167. If the user does not wish to save this information, the user can hit cancelbutton169. Once this information is saved, it can be used to analyze process upsets and effectiveness of corrective actions.
FIG. 11bshows a screen shot ofwindow150 when information has already been provided for a sample in the particular out-of-control point. As shown inFIG. 11b,window150 has acolumn168 devoted to previous reasons and actions entered into theSPC module36 by a user. A user can identify whether previous reasons were provided and remedial actions taken by seeing if any of the buttons incolumn168 state “view previous actions.” By clicking on a “view previous actions” button, a user can view a pop-upwindow475 that details the reason for this out-of-control point and the corrective action taken to ensure that it does not occur again. Referring back toFIG. 10, out-of-control buttons148 onSPC module36 can appear in one color to indicate that no reason has been provided as to why this point was outside the control limits, and can appear in another color to indicate that a note has been entered to explain the reason for this point appearing outside the control limits. For example, in this embodiment the out-of-control button148 appears in yellow if no note has been entered and appears in green if a note has been entered. If a reason has been provided, a user can click on the out-of-control button148 and be taken to the Reasons and Actions pop-upwindow150.
SPC module36 also provides the user with a SPC Quality Reporting subsystem for creating standard or customized quality reports. The subsystem allows a user to configure a statistical summary for key process measures and product tests. The subsystem can be accessed by opening the “quality report file” (not shown) through the toolbar's11 dropdown file menu191 (shown inFIG. 2a). Alternatively, the subsystem can be accessed through a shortcut link on a desktop or laptop computer. In this embodiment, the subsystem has alogin screen192.
FIG. 13 shows a screen shot oflogin screen192. As shown inFIG. 13,open file button194 allows a user to access the SPC Quality Reporting subsystem.Open file button194 is automatically enabled for users trying to access the subsystem at their own plant. However, if a user desires to enter this subsystem for a different plant or a user of corporate ADC dashboard32 (shown inFIG. 1) tries to access this subsystem, then open file button is not automatically enabled and requires the user to enter a valid password inlogin window189 to access the subsystem. Once thefile button194 is enabled, the user can click on the enabled open file button to access the subsystem.Login screen192 also shows the default server (corporate or plant) inwindow197 for the user and the default plant inwindow195. The user can change the server selected if he and/or she desires. Based on the server selected and the plant selected, the login screen will display the specific server identifier inwindow199.
FIG. 14 shows a screen shot of themain menu193 of the SPC Quality Report subsystem. The subsystem allows a user to configure a statistical summary for key manufacturing sub-process measures and product tests. Such a summary can be used to monitor the current manufacturing sub-process and to analyze the impact of any process changes. As shown inFIG. 14, the plant selected on the login screen is displayed inwindow195, the selected server is displayed inwindow197 and the specific server identifier is displayed inwindow199. A dropdown menu will be enabled for switching between plants and servers if the user was required to and actually had entered a valid password in thelogin screen192. The user can utilize dropdown menus196 to select the desired month and year for the report. In this embodiment, themain menu193 provides the user with five differentdropdown product menus187 to allow the user to select the desired products to be included in the report. Whilemain menu193 only allows the user to select up to five products to be included in the report, the main menu could be configured to include any number of products in the report.
Still referring toFIG. 14, once the user selects the plant, the date range and the products for the report, the user can click on retrieve data button198. The SPC Quality Report subsystem then accesses the plant or corporate database to create a variety of reports. For example, in this embodiment, the subsystem has the ability to produce a Product Detail Report by selecting one of the “Product Details”buttons210, a Monthly Quality Report by clicking on “Monthly Board Report”button201, a Monthly Board Weight Report by clicking on “Monthly Board Weight Report” button213 and a Monthly Mill Report by clicking on “Monthly Mill Report” button215. Further, a user can access a Product Data Screen by clicking on “Set-Up”button206.
FIG. 15 shows a sampleMonthly Quality Report200 generated by the SPC Quality Report subsystem for a specific plant when a user clicks the “Monthly Board Report”button201. As can be seen inFIG. 15, thisReport200 provides five tables for each of the selected products401 that addresses the selected measures. For thisreport200, the user selected the nail pull, core hardness, edge hardness-code, edge hardness-opposite code, and end hardness measures to view for the five selected products. For each selected measure and product, the report displays the test location402 (e.g., Lab), the number of samples tested, the manufacturing process limits, the 3 month rolling average, the standard deviation, the prior year-to-date average, the prior year average, the Cpk, the estimated defects per 1,000 units and the Cp. Whilereport200 shows only five products, only five measures, and the above-referenced data, the report can be customized to show any number of products, any number of measures or any number calculations and data. Once generated, these reports can be electronically saved by clicking on the “save as file” button (not pictured) or the user can choose to discard the report and return to themain menu193 of the subsystem by clicking on the “return” button (not pictured).
Referring back toFIG. 14, the user can generate a Monthly Board Weight Report by selecting Monthly Board Report Button213.FIG. 16 shows a screen shot of Monthly Board Weight Report214 that identifies the plant and month for which the report was generated. This report lists by month the total monthly average weight, the total standard deviation and the total number of samples taken for the five products selected onmain menu193 of the subsystem. The user can select to save this report by clicking on “save as”button430 or return tomain menu193 by clicking onreturn button431. While two types of reports generated by the SPC Quality Report subsystem are described herein, the subsystem can generate any number of desired reports from the data stored in theplant database28 and/orcorporate database26 that meets the specific needs of the plant utilizing the subsystem.
Referring back toFIG. 14, the user can also review and update information for all the products by clicking on the “Set-up”button206.FIG. 17 shows a screen shot of aProduct Data screen208 for all of the products. As shown inFIG. 17,Product Data screen208 allows the user to assign aPLC value405 to each of the products. In this embodiment, thePLC value405 ranges from 1-100 with each PLC value representing the PLC12 (shown inFIG. 1) that gathers data for a specific product produced by a manufacturing sub-process. The user can place adescription406 for each product next to the PLC value that is assigned to the product. For the wallboards of this embodiment, this product descriptions starts with the caliper measure and is followed by the board type. Theproduct code407 is then typed in for that product. In this embodiment, theproduct code407 is the catalog number assigned to each product. Further,screen208 specifies thewidth408 for each product. The rest of the columns of this chart correspond to the standard information409 (i.e., standard speed, standard dry weight, standard water loss) that may appear on Report200 (shown inFIG. 15). Once the user is done updating and/or reviewing this product information, the user can hit return button204 to return to themain menu193 of the subsystem.
Referring back toFIG. 14, after the SPC Quality Reporting subsystem has retrieved the requested data, the user can view detailed information regarding each of the selected products by clicking on the correspondingProduct Detail button210 to access aProduct Detail Report212.FIG. 18ashows a screen shot ofProduct Detail Report212. As shown inFIG. 18a,theProduct Detail Report212 displays all the detailed information for eachmeasure44 of the selected product that is used to create MonthlyBoard Quality Report200. In this embodiment, theProduct Detail Report212 provides monthly totals and averages, as well as, daily averages for every sample tested during the current month and each of the prior two months. A user can utilize scroll bars (not pictured) to scroll left and right to view all the measures that were recorded and to scroll up and down to view each month's data. The user can save the file by clicking on the “save as”button430 or can choose to return to themain menu193 of the subsystem by clicking on the “return”button431.
By scrolling far enough down the user can see further information regarding the product as well. For example,FIG. 18bshows a screen shot of the 3-month rollingaverage section420 of theProduct Details Report212.Section420 displays the average and number of samples for the rolling three month period. Further,FIG. 18bshows a 3-monthperiod ending section421 ofProduct Details Report212.Section421 displays the three month rolling average for each month of the year (i.e. January shows the average for November-January, February shows the average for December-February, etc.). Moreover,FIG. 18cshows a screen shot of the current year-to-date averages422 ofProduct Details Report212 andmonthly averages423 ofProduct Details Report212 for all samples tested. The SPC Quality Reporting subsystem obtains this information from the plant or corporate database and calculates the desired information using standard formulas. If for any reason the reported data is inaccurate, the user can overwrite the reported data insection424.
Referring back toFIG. 1, ADC dashboard is connected in a network to aQTDE subsystem38.QTDE subsystem38 allows plant floor operators and lab technicians to manually enter product test data/measures directly into theplant database28. The specific tests to be entered can be tailored to meet the manufacturer's requirements. By storing product test data on the plant database, the user can access the results of the product testing through the ADC dashboard and utilize the data for all the dashboards, reports, modules and subsystems described above. Further, the data collected by thePLCs12 can be directly linked with these tests of the finished product to support problem solving and continuous improvement effort.
FIGS. 21-25 shows sample data entry screens for theQTDE subsystem38. All of the QTDE subsystem's38 data entry screens have some common characteristics and features. For example, each data entry screen is identified by a title.FIG. 21 shows a screen shot of a Dry End ManualData Entry screen300.FIG. 22 shows a screen shot of a Mill ManualData Entry screen301.FIG. 23 shows a screen shot of a Wet End ManualData Entry screen302.FIG. 24 shows a screen shot of a Knife ManualData Entry screen303.FIG. 25 shows a screen shot of a Lab ManualData Entry Screen304
All of the data entry screens (shown inFIGS. 21-25) of this embodiment have common buttons and features. Except for Lab ManualData Entry Screen304, the data entry screens each have aminimization button305 that allows the user to minimize the screen to work on other applications. All the data entry screens300-304 have aSPC chart button306 that allows the user to access theSPC module36. The data entry screens also have aview data button307 that allows the user to access a view data screen with the same layout as the data entry screens. The view data screen allows the user to scroll through all the gathered data. Moreover, the data entry screens have a set upbutton308 that allows the user to access a file containing the product and plant information and an acceptbutton310 that becomes enabled once data has been entered. Once the user hits the acceptbutton310, the data is entered directly into theplant database28 and the data is then cleared from the data entry screen. The data entry screens ofFIGS. 21-25 also have date and timedropdown menus311 that allow the user to select the date and time for when the data was collected. For the Mill and Wet End Manual Data Entry screens301 and302, respectively, the selected date and time identifies when the sample was taken. In contrast, for the Dry End, Knife and Lab Manual Data Entry screens,300,303 and304, respectively, the date and time refers to the date and time coded on the board being tested.
All of the data entry screens, except for the Mill ManualData Entry screen301, also have a select productdropdown menu312 that allows the user to select the product being tested. Further, all of the data entry screens, except forscreen301, identify the product code, width and description of the selected product inwindows313. Moreover, these data entry screens also have aboard profile button314 that allows the user to accessboard profile70 for the selected product. All of the screens300-304 havefields315 that allow the user to enter in the desired test results into the data entry sheet.
In operation, the user performs the desired test and enters all the resulting data into the desiredfields315 of the screens300-304. As the data is entered into a manual data entry sheet, each field is validated with theQTDE subsystem38, to ensure that obvious data entry errors are prevented by making sure the data entered falls within a specific range. If the data is outside the validation range, a pop-up screen will be displayed asking if the information is indeed correct. Further, the data entered will also be validated by the SPC subsystem. Thus, when the accept button is pressed, each measure/piece of data will be checked against the UCLs and LCLs set for that data in the SPC module36 (shown inFIG. 10). If one or more of the manually entered measures/pieces of data fall outside the UCLs and LCLs, the user will automatically be transferred to the SPC subsystem and be prompted to fill out one of the Reasons and Actions pop-window150 in order to explain the cause of the out-of-control point and the corrective action taken. Once the data is entered into the desired fields, the accept button will be enabled and the user can hit the accept button to enter the data into theappropriate database26 and/or28.
Thus, among other things, the described embodiment of the present invention is a system and method that generates customizable, real time reports for plant personnel. It eliminates the multiple data entry points through the collection of the PLC data, the HMI data and the data entered through theQTDE subsystem38 in the plant and/or corporate database. Moreover, this embodiment allows plant personnel to easily and quickly configure the system to the plant by providing theKPI platform40.KPI platform40 allows an end-user to set alarms and specification values for each product through the Update Alarms and Specifications screen46 and allows an end-user to input information specific to the plant and the manufactured products through the Product andInformation screen60.
This embodiment allows an end-user to configure customized views of the plant manufacturing process data through the generation of reports through theKPI platform40, the Ad Hoc Reporting Subsystem, and theSPC module36. Further, it alerts a user (i.e., plant personnel) in real time throughSPC module36 when a manufacturing system is approaching the specification limit (i.e., an alarm) and when the manufacturing process has exceeded the specification. While this summarizes some of the benefits of this embodiment of the plant management system and method, the present invention has many more benefits that have been outlined herein.
While the present invention has been described in detail with reference to certain exemplary embodiments thereof, such description is offered by way of non-limiting example of the invention, as other versions are possible. It is anticipated that a variety of other modifications and changes will be apparent to those having ordinary skill in the art and that such modifications and changes are intended to be encompassed within the spirit and scope of the invention as defined by the following claims.