Model generation system for a machine

• US 9,984,182 B2
• Filed: 05/25/2016
• Issued: 05/29/2018
• Est. Priority Date: 05/25/2016
• Status: Active Grant

• Current Assignee: Caterpillar Incorporated
• Original Assignee: Caterpillar Incorporated
• Inventors: Wilson, Jeremy R., Stascavage, James F., Vergara, Melinda F., Mauntel, Jeffrey M., Dupont, Bradley
• Primary Examiner(s): Marc, McDieunel
• Application Number:
  US15/164,507
• Publication Number:
  US 20170344671A1
• Time in Patent Office: 734 Days
• Field of Search: 701 29, 701 291, 703 7
• CPC Class Codes: G05B 17/02 electric
• CPC Class Codes: G06F 30/17 Mechanical parametric or variational design
• CPC Class Codes: G06F 30/20 Design optimisation, verification or simulation optimisation, verification or simulation of circuit designs G06F30/30

Abstract

A model generation system for a machine having a database, a memory to store instructions, and a controller configured to execute the instructions to generate a plurality of interrelated data tables. The data tables may have a sensor table having a sensor row including sensor attributes, a calculation table having a calculation row including calculation attributes associated with a measurement from the sensor, and a fault indicator table including fault indicator attributes based on the measurement or the calculation. The controller may highlight the sensor row using a first color when the sensor table includes a tag identifier associated with the sensor, and highlight the sensor row using a second color when the sensor table does not include the tag identifier. The controller may display the highlighted sensor table on a display device and store the data tables in the database.

Claims

1. A model generation system for a machine, comprising:

a database;

a memory to store instructions; and

a controller configured to execute the instructions to;

generate a plurality of interrelated data tables, including;

a sensor table including a sensor row having sensor attributes associated with a sensor;

a calculation table including a calculation row having calculation attributes associated with a calculation based on a measurement from the sensor; and

a fault indicator table including a fault indicator row having fault indicator attributes associated with a fault indicator based on at least one of the measurement or a result from the calculation;

determine whether the sensor table includes a tag identifier associated with the sensor, the tag identifier representing an identifier of a component sensor located on a component of the machine;

highlight the sensor row in the sensor table using a first color when the sensor table includes the tag identifier;

highlight the sensor row using a second color when the sensor table does not include the tag identifier;

display the highlighted sensor table on a display device; and

store the data tables in the database.

2. The model generation system of claim 1, wherein the data tables are tabs of a spreadsheet.

3. The model generation system of claim 1, wherein the fault indicator is a first fault indicator, the fault indicator row is a first fault indicator row, the fault indicator table includes a second fault indicator row corresponding to a second fault indicator, and the controller is further configured to execute the instructions to generate a fault mode table including a fault mode row, having:

a fault mode name;

a fault mode logic defining a condition based on the first fault indicator and the second fault indicator; and

a list of child faults including the first fault indicator and the second fault indicator.

4. The model generation system of claim 3, wherein the controller is further configured to execute the instructions to generate a machine state table, including a machine state having:

a machine state name; and

a machine state definition including an operating condition of the component.

5. The model generation system of claim 4, wherein the controller is further configured to execute the instructions to:

determine whether the machine state has been assigned to the fault indicator table; and

when the machine state has not been assigned;

display the fault indicator table on the display device;

receive an input selecting at least one of the first fault indicator or the second fault indicator; and

associate the machine state with the selected one of the first fault indicator or the second fault indicator by entering the machine state name in the fault indicator table.

6. The model generation system of claim 3, wherein the controller is further configured to execute the instructions to:

determine sensors included in the first fault indicator and the second fault indicator;

determine whether the sensor table includes the determined sensors;

determine whether the sensor table includes an associated tag identifier for each of the determined sensors; and

highlight the fault mode row using a third color when the sensor table includes the associated tag identifier for each of the determined sensors.

7. The model generation system of claim 1, wherein the sensor attributes include:

a sensor name;

a first unit of measurement for the measurement from the sensor;

a first lower limit associated with the measurement; and

a first upper limit associated with the measurement.

8. The model generation system of claim 7, wherein the calculation attributes include:

a calculation name;

a second unit of measurement for the result of the calculation;

a second lower limit associated with the result;

a second upper limit associated with the result; and

a mathematical operation associated with the measurement.

9. The model generation system of claim 8, wherein the controller is further configured to execute the instructions to:

highlight the calculation row using the first color when the sensor table does not include the tag identifier; and

highlight the calculation row using the second color when the sensor table includes the tag identifier.

10. The model generation system of claim 1, wherein the sensor row is a first sensor row, the sensor is a first sensor, the fault indicator row is a first fault indicator row, the fault indicator is a first fault indicator, the sensor table includes a second sensor row having attributes associated with a second sensor, the fault indicator table includes a second fault indicator row having attributes associated with a second fault indicator, and the controller is further configured to execute the instructions to:

generate a gap sensor-FI table, including;

a title row;

a first gap sensor-FI row including the first sensor listed in a first column;

a second gap sensor-FI row including the second sensor listed in the first column;

a second column listing a first fault indicator name in the title row; and

a third column listing a second fault indicator name in the title row;

determine whether the first fault indicator includes the first sensor; and

insert a label in the second column of the first gap sensor-FI row when the first fault indicator includes the first sensor.

11. The model generation system of claim 10, wherein the controller is further configured to execute the instructions to:

determine whether the sensor table includes the first sensor;

determine whether the sensor table includes a first tag identifier associated with the first sensor; and

highlight the second column of the title row using a third color when the sensor table includes the first tag identifier.

12. A method of generating a model for a machine, comprising:

generating, using a controller, a plurality of interrelated data tables, including;

a sensor table including a sensor row having sensor attributes associated with a sensor;

a calculation table including a calculation row having calculation attributes associated with a calculation based on a measurement from the sensor; and

a fault indicator table including a fault indicator row having fault indicator attributes associated with a fault indicator based on at least one of the measurement or a result from the calculation;

determining whether the sensor table includes a tag identifier associated with the sensor, the tag identifier representing an identifier of a component sensor located on a component of the machine;

highlighting the sensor row in the sensor table using a first color when the sensor table includes the tag identifier;

highlighting the sensor row using a second color when the sensor table does not include the tag identifier;

displaying the highlighted sensor table on a display device; and

storing the data tables in a database.

13. The method of claim 12, wherein the fault indicator is a first fault indicator, the fault indicator row is a first fault indicator row, the fault indicator table includes a second fault indicator row corresponding to a second fault indicator, and the method further includes:

determining a fault mode logic defining a condition based on the first fault indicator and the second fault indicator; and

determining a list of child faults based on the fault mode logic.

14. The method of claim 13, further including generating a machine state table, including a machine state having:

a machine state name; and

a machine state definition including an operating condition of the component.

15. The method of claim 14, further including:

determining whether the machine state has been assigned to the fault indicator table; and

when the machine state has not been assigned;

displaying the fault indicator table on the display device;

receiving an input selecting at least one of the first fault indicator or the second fault indicator;

associating the at least one machine state with the selected one of the first fault indicator or the second fault indicator by entering the machine state name in the fault indicator table; and

storing the fault indicator table in the database.

16. The method of claim 13, further including:

determining sensors included in the first fault indicator and the second fault indicator;

determining whether the sensor table includes the determined sensors;

determining whether the sensor table includes an associated tag identifier for each of the determined sensors; and

highlighting a fault mode row using a third color when the sensor table includes the associated tag identifier for each of the determined sensors.

17. The method of claim 13, wherein the sensor attributes include:

a sensor name;

a first unit of measurement for the measurement from the sensor;

a first lower limit associated with the measurement; and

a first upper limit associated with the measurement.

18. The method of claim 17, wherein the calculation attributes include:

a calculation name;

a second unit of measurement for the result of the calculation;

a second lower limit associated with the result;

a second upper limit associated with the result; and

a mathematical operation associated with the measurement.

19. The method of claim 18, further including:

highlighting the calculation row using the first color when the sensor table does not include the tag identifier; and

highlighting the calculation row using the second color when the sensor table includes the tag identifier.

20. The method of claim 12, wherein the sensor row is a first sensor row, the sensor is a first sensor, the fault indicator row is a first fault indicator row, the fault indicator is a first fault indicator, the sensor table includes a second sensor row having attributes associated with a second sensor, the fault indicator table includes a second fault indicator row having attributes associated with a second fault indicator, and the method further includes:

generating a gap sensor-FI table, including;

a title row;

a first gap sensor-FI row including the first sensor listed in a first column;

a second gap sensor-FI row including the second sensor listed in the first column;

a second column listing a first fault indicator name in the title row; and

a third column listing a second fault indicator name in the title row;

determining whether the first fault indicator includes the first sensor;

inserting a label in the second column of the first gap sensor-FI row when the first fault indicator includes the first sensor;

determining whether the sensor table includes the first sensor and whether the sensor table includes a first tag identifier associated with the first sensor; and

highlighting the second column of the title row using a third color when the sensor table includes the first tag identifier.