METHOD AND AUTOMATION SYSTEM FOR PROCESSING INFORMATION EXTRACTABLE FROM AN ENGINEERING DRAWING FILE USING INFORMATION MODELING AND CORRELATIONS TO GENERATE OUTPUT DATA

• US 20140297013A1
• Filed: 11/09/2012
• Published: 10/02/2014
• Est. Priority Date: 11/10/2011
• Status: Active Grant

• Current Assignee: Tennessee Valley Authority (Government of the United States of America)
• Original Assignee: Tennessee Valley Authority (Government of the United States of America)
• Inventors: Huffine, Brian Jason
• Granted Patent: US 9,459,600 B2
• Time in Patent Office: Days
• US Class Current: 700/97
• CPC Class Codes: G05B 13/04 involving the use of models or simulators
• CPC Class Codes: G06F 30/20 Design optimisation, verification or simulation optimisation, verification or simulation of circuit designs G06F30/30

Abstract

A method and an automation system for processing information extractable from an engineering drawing file. The automation system includes a controller which models in the engineering drawing file (20) at least two objects (302, 304) in a predefined format by adding at least two entities (34) to the engineering drawing file (20) (S501) and by adding support information (35) to the engineering drawing file (20) (S502) to provide the extractable information (S401), provides a program sequence (80) in an automation application (50) to establish a correlation of the extractable information (S402), correlates the extractable information by executing the program sequence (80) (S403), and generates output data (12, 15) based on the established correlation of the extractable information (S404). The correlation of the extractable information is established only while the program sequence (80) of the automation application (50) is being executed.

Claims

1. A method for processing information extractable from an engineering drawing file (20) comprising:

modeling in the engineering drawing file (20) at least two objects (302, 304) in a predefined format by adding at least two entities (34) to the engineering drawing file (20) (S501) and by adding support information (35) to the engineering drawing file (20) (S502) to provide the extractable information (S401);

providing a program sequence (80) in an automation application (50) to establish a correlation of the extractable information (S402);

correlating the extractable information by executing the program sequence (80) (S403);

generating output data (12, 15, 64) based on the established correlation of the extractable information (S404),

wherein the correlation of the extractable information is established only while the program sequence (80) of the automation application (50) is executed.

2. The method according to claim 1,

wherein the at least two objects (302, 304) comprise, respectively, a device (302) and a connector (304), and

wherein the output data (12, 15, 64) comprises at least one of a report (12, 64) and an equipment control file (15) comprising control data configured to control an equipment (700, 800, 900), and

wherein the report is at least one of

(a) stored in a report file (12), and

(b) displayed on a display (70).

3. The method according to claim 2, wherein the modeling further comprises at least one of:

providing application process settings data (13) (S503),

providing a predefined equipment control file template (111) (S504),

adding attributes to the at least two entities (34) (S505), and

applying a predefined format to the at least two entities (34) (S506),

wherein the correlation comprises a temporary configuration of the automation application (50) that establishes a temporary relationship between the at least two entities (34), the support information (35) and the application process settings data (13), thereby providing additional information beyond the information about the at least two entities (34), the support information (35) and the application process settings data (13),

wherein the support information (35) comprises at least one of;

general settings information (31),

device specification information (32) comprising device descriptive characteristics, device structural characteristics, device-level connector routing characteristics, device-level process settings, device termination definitions comprising coordinates of the device terminations in a coordinate system calculated from a point of origin defined for each device, termination-level connector routing characteristics, termination data assignments, framework characteristics, and termination interface characteristics, and

connector specification information (33) comprising circuit type definitions, connector characteristics based on an applied circuit type, connector type symbol definitions, and characteristics of a connector end to adapt the connector end to a device termination to which the connector end is connected,

wherein the at least two entities (34) comprise at least one of a text string formatted according to the predefined format, layers, and blocks of grouped entities, and

wherein the application process settings data (13) comprises parameters for executing the automation application (50).

5. The method according to claim 1, wherein, to prevent the extractable information from being correlated without the automation application (50) being executed, the program sequence (80) is included in the automation application (50) and the at least two objects (302, 304) are modeled in the engineering drawing file (20) in the predefined format, and

wherein the correlation is accessible only by the automation application (50).

7. The method according to claim 3, wherein the generating of the equipment control file (15) comprises at least one of:

generating a connector tag printer control file (18) to control a connector tag printer (900);

generating an engraver control file (16) to control an engraver (800); and

generating a connector processing equipment control file (19) to control a connector processing equipment (700).

11. The method according to claim 7, wherein the generating of the connector processing equipment control file (19) comprises:

calculating an adjusted total connector length of a connector (304) based on the correlated extractable information,

wherein the correlated extractable information comprises;

information defining the topology of framework devices (302) based on a coordinate system of each framework device (302),

locations of terminations (310) to which the connector (304) is connected in the coordinate system of each of the framework devices (302),

information defining the topology of the framework (301) based on a coordinate system of each framework (301), and

locations of framework devices (302) in the coordinate system of each framework (301).

12. The method according to claim 11, wherein the calculating of the adjusted total connector length comprises:

extracting the extractable information (S507);

correlating the extractable information (S508);

calculating a total unadjusted connector length based on at least one of a plurality of connecting scenarios (A-G) (S509); and

adjusting the total unadjusted connector length (S510),

wherein the extracting of the extractable information (S507) comprises;

retrieving information about the at least two entities (34),

retrieving at least a part of the support information (35), and

retrieving the application process settings data (13), and

wherein the plurality of connecting scenarios (A-G) comprises;

routing the connector (304) around devices (302, 303) located above or below each other and along a framework boundary (A);

routing the connector (304) around devices (302, 303) located side-by-side (B);

routing the connector (304) from a framework device (302) to a selected termination interface (305) (C);

routing the connector (316, 317) from a first termination interface (305) to a second termination interface (306, 307) (D);

routing the connector (304) from a first termination (308) of a single device (302) to a second termination (309) of the single device (302) (E);

directly routing the connector (304) from a first device (302) to a second device (303) without routing the connector (304) around the first device (302) and the second device (303) and without routing the connector (304) along the framework boundary (312), wherein the first device (302) is located above or below the second device (303) (F); and

directly routing the connector (304) from the first device (302) to the second device (303) without routing the connector (304) around the first device (302) and the second device (303) and without routing the connector (304) along the framework boundary (312), wherein the first device (302) and the second device (303) are located side-by-side (G).

13. The method according to claim 12, wherein the adjusting of the total unadjusted connector length (S510) comprises:

calculating and adding a waterfall adjustment to the total unadjusted connector length (S614);

calculating and adding a net adjustment to the total unadjusted connector length modified by the waterfall adjustment (S616),

wherein the waterfall adjustment comprises a value to adjust the length of the connector (304) relative to lengths of a plurality of other connectors (304) to obtain a predefined shape of a bundle formed by the connector and a plurality of other connectors (S613), and

wherein the net adjustment comprises a net adjustment factor applied by adding or subtracting a fixed distance value (S618) or by applying a percent value (S617).

14. The method according to claim 12, wherein the calculating of the total unadjusted connector length (S509) comprises:

upon determining that the connector is a single connector (304) on a same framework device (302) (S601) and upon determining that a fixed connector length is used (S606), retrieving a fixed connector length value (S607) and setting the retrieved fixed connector length value as the total unadjusted connector length;

upon determining that the connector is a single connector on a same framework device (S601) and upon determining that the fixed connector length is not used (S606) segmenting the connector (304) into a plurality of connector segments, calculating a segment connector length for each of the plurality of connector segments (S608), and calculating the total unadjusted connector length based on a summation of segment connector lengths of each of the plurality of connector segments (S605).

15. The method according to claim 14, wherein the segmenting of the connector (304) into the plurality of connector segments and the calculating of the segment connector lengths for each of the plurality of connector segments comprises:

calculating a connector bend radius comprising a length of a bend of the connector and adjusting each segment connector length that contains at least one bend based on the connector bend radius (S625),

calculating a point of origin (325) associated with the at least one device (302) using a coordinate system associated with the at least one device (S626);

calculating a jumper leave distance (S627);

calculating a distance Δ

X between a first x-coordinate value of a first point of termination (308) of the at least one device and a second x-coordinate value of a second point of termination (309) of the at least one device based on the point of origin (325)(5628);

calculating a distance Δ

Y between a first y-coordinate value of the first point of termination (308) of the at least one device and a second y-coordinate value of the second point of termination (309) of the at least one device based on the point of origin (325) (S629),

wherein the jumper leave distance comprises a distance between the second point of termination (309) on the at least one device (302) and a point (324) extending in a direction of termination (326).

16. The method according to claim 12, wherein the calculating of the total unadjusted connector length comprises:

upon determining that the connector (304) extends between a first framework device (302) and a second framework device (303) (S601), determining a location of the first framework device (302) and the second framework device (303) relative to each other (S602).

17. The method according to claim 16, further comprising:

upon determining that the first and the second framework devices (302, 303) are located horizontally to each other, selecting a routing scenario (S609),

upon selecting the routing scenario to extend the connector in a direct manner, segmenting the connector into a plurality of connector segments, calculating a segment connector length for each of the plurality of connector segments (S610), and calculating a total unadjusted connector length based on a summation of the segment connector lengths of each of the plurality of connector segments (S605).

18. The method according to claim 17, wherein the segmenting of the connector (304) into the plurality of connector segments and the calculating of the segment connector lengths for each of the plurality of connector segments (S610) comprises:

calculating a common point of origin (327) for the first framework device (302) and the second framework device (303) using a coordinate system associated with the first and second framework devices (S630),

calculating a connector bend radius comprising a length of a bend of the connector (304) and adjusting each segment connector length that contains at least one bend based on the connector bend radius (S631);

calculating a jumper leave distance (S632);

calculating a distance Δ

X between a first x-coordinate value of a first point of termination (308) of the first framework device (302) and a second x-coordinate value of a second point of termination (309) of the second framework device (303) based on the common point of origin (327) (S633);

calculating a distance Δ

Y between a first y-coordinate value of the first point of termination (308) of the first framework device (302) and a second y-coordinate value of the second point of termination (309) of the second framework device (303) based on the common point of origin (327) (S634),

wherein the jumper leave distance comprises a distance between the second point of termination (309) on the second framework device (303) and a point (324) extending in a direction of termination (326).

19. The method according to claim 16, further comprising:

upon determining that the first and the second framework devices (302, 303) are located horizontally to each other, selecting a routing scenario (S609),

upon selecting the routing scenario to extend the connector around devices and along framework boundaries (312), segmenting the connector into a plurality of connector segments, calculating segment connector lengths for each of the plurality of connector segments (S611), and calculating a total unadjusted connector length based on a summation of the segment connector lengths of each of the plurality of connector segments (S605).

20. The method according to claim 19, wherein the segmenting of the connector (304) into the plurality of connector segments and the calculating of the segment connector lengths for each of the plurality of connector segments (S611) comprises:

calculating a common point of origin (328) for the framework (328) (301) using a coordinate system associated with the framework (S635),

calculating a connector bend radius comprising a length of a bend of the connector (304) and adjusting each segment connector length that contains at least one bend based on the connector bend radius (S636);

calculating a vertical leave distance for each of the connector ends (S637);

calculating a distance Δ

X between a first x-coordinate value of a first point of termination (308) of the first framework device (302) and a second x-coordinate value of a second point of termination (309) of the second framework device (303) based on the common point of origin (328) for the framework (328) (S638),

wherein the vertical leave distance comprises a distance between a point of termination (308, 309) on a framework device (302, 303) and a point above or below the framework device (329, 330).

21. The method according to claim 16, further comprising:

upon determining that the first and the second framework devices (302, 303) are located vertically to each other (S602), selecting a routing scenario (S603),

upon selecting the routing scenario to extend the connector in a direct manner, segmenting the connector into a plurality of connector segments, calculating segment connector lengths for each of the plurality of connector segments (S612), and calculating a total unadjusted connector length based on a summation of the segment connector lengths of each of the plurality of connector segments (S605).

22. The method according to claim 21, wherein the segmenting of the connector (304) into the plurality of connector segments and the calculating of the segment connector lengths for each of the plurality of connector segments (S612) comprises:

calculating a common point of origin (327) for the first framework device (302) and the second framework device (303) using a coordinate system associated with the first and second framework devices (S639),

calculating a connector bend radius comprising a length of a bend of the connector (304) and adjusting each segment connector length that contains at least one bend based on the connector bend radius (5640),

calculating a distance Δ

X between a first x-coordinate value of a first point of termination (308) of the first framework device (302) and a second x-coordinate value of a second point of termination (309) of the second framework device (303) based on the common point of origin (327) (S641);

calculating a distance Δ

Y between a first y-coordinate value of the first point of termination (308) of the first framework device 302) and a second y-coordinate value of the second point of termination (308) of the second framework device (303) based on the common point of origin (327) (S642).

23. The method according to claim 16, further comprising:

upon determining that the first and the second framework devices are located vertically to each other (S602), selecting a routing scenario (S603),

upon selecting the routing scenario to extend the connector (304) around devices and along framework boundaries (312), segmenting the connector into a plurality of connector segments, calculating segment connector lengths for each of the plurality of connector segments (S604), and calculating a total unadjusted connector length based on a summation of the segment connector lengths of each of the plurality of connector segments (S605).

24. The method according to claim 23, wherein the segmenting of the connector (304) into the plurality of connector segments and the calculating of the segment connector lengths for each of the plurality of connector segments (S604) comprises:

calculating a connector bend radius comprising a length of a bend of the connector (304) and adjusting each segment connector length that contains at least one bend based on the connector bend radius (S619),

calculating a vertical leave distance for each end of the connector (304) (S620);

calculating a distance to framework edge for each end of the connector (304) (S621);

calculating a distance to framework boundary for each end of the connector (304) (S622);

determining a framework device placement of the first framework device (302) relative to the second framework device (303) (S623);

calculating a vertical distance between points along the framework where the connector (304) is routed (S624),

wherein the distance to framework edge comprises a horizontal component distance from a point of termination (308) to a framework edge (331) in preparation of vertical routing,

wherein the distance to framework boundary comprises a total distance from the point of termination (308) to the framework edge (331) in preparation of vertical routing,

wherein the vertical leave distance comprises a distance between a point of termination on a framework device and a point above or below the framework device (332).

4. (canceled)

6. (canceled)

8-10. -10. (canceled)

25-29. -29. (canceled)

30. An automation system (1) comprising:

a non-transitory computer-readable medium (610) storing at least one engineering drawing file (20) and an automation application (50) comprising a program sequence (80); and

a main controller (600) configured to;

model in the engineering drawing file (20) at least two objects (302, 303) in a predefined format by adding at least two entities (34) to the engineering drawing file (34) and by adding support information (35) to the engineering drawing file (20) to provide the extractable information,

execute the program sequence (80) of the automation application (50) to establish a correlation of the extractable information, and

generate output data (12, 15) based on the established correlation of the extractable information;

a connector tag printer (900) controlled by a connector tag printer controller (500) based on the at least one equipment control file (15) and configured to print connector tags;

an engraver (800) controlled by an engraver controller (400) based on the at least one equipment control file (15) and configured to engrave nameplates; and

a connector processing equipment (700) controlled by a connector processing equipment controller (300) based on the at least one equipment control file (15) and configured to cut a connector (304) to a length, to print information on the connector (304), and to prepare both ends of the connector (304) for installation,

a file converter (200) configured to convert the at least one equipment control file (15) into a format specific to the connector processing equipment (700), wherein the correlation of the extractable information is established only while the program sequence (80) of the automation application (50) is executed, and

a communication controller (90) to transmit the output data (12, 15) to the connector tag printer controller (500), the engraver controller (400), the file converter (200), and the connector processing equipment controller (300).

31. The automation system according to claim 30,

wherein the at least two objects comprise, respectively, a device (302) and a connector (304),

wherein the output data (12, 15) comprises at least one of a report (12) and an equipment control file (15) comprising control data configured to control an equipment (700, 800, 900), and

wherein the report is at least one of

(a) stored in a report file (12), and

(b) displayed on a display (70).

35. The automation system according to claim 30, wherein the automation system (1) further comprises a design processor (40) which displays a user interface (60) on a display (70) to model the at least two objects (302, 304) in the predefined format, and

wherein the output data (12, 15) comprises a compatibility report which lists entities (34) and support information (35) that do not correspond to the predefined format.

38. The automation system according to claim 31, further comprising

a file converter (200),

wherein, after the main controller (600) generates a connector processing equipment control file (19), the communication controller (90) transmits the connector processing equipment control file (19) to the file converter (200) and the file converter (200) converts an equipment control file format and equipment control file data of the connector processing equipment control file (19) into an equipment control file format and equipment control file data of a converted connector processing equipment control file (17) based on a predefined equipment control file template (111) when the specific file and data format is required by the connector processing equipment (700).

39. The automation system according to claim 30, wherein the connector processing equipment (700) is configured to cut a connector (304) to a length, to print information on the connector (304), and to prepare both ends of the connector (304) for installation, and

wherein the information printed on the connector (304) comprises at least one of installation instructions, at least a part of the connector specification information (33), a connector tag, a destination, a source, and routing information.

54. The automation system according to claim 31, wherein, when the main controller (600) generates a connector tag printer control file, the main controller (600) sorts connector tag labels by a framework ID, a device ID, and a termination ID, and

wherein a connector tag identifies a node of a circuit between at least two terminations, and

wherein the connector tag is assigned to at least one of a plurality of connectors that connect the at least two terminations of a given node of the circuit.

55. The automation system according to claim 31, wherein the device comprises at least one of:

a control panel of an electrical substation, a modular or prefabricated home, an optical telecommunication rack, a control panel device, a plumbing unit, and an optical control device,

wherein a framework comprises at least one of;

the control panel, the modular or prefabricated home, and the optical telecommunication rack,

wherein the connector comprises at least one of;

a wire, a pipe, a conduit, and an optical fiber,

wherein the connector is configured to transport at least one of;

electrons, photons, gas, fluids and other matter,

wherein the termination interface comprises at least one of;

an electrical terminal block,

an interface at which at least two ends of two pipes or conduits are connected, and

an interface at which at least two optical fiber ends connected,

wherein the engineering drawing file (20) comprises at least one of;

an elevation diagram (21) which defines a layout of at least one framework (301) and a location of the at least one device (302, 303) on the at least one framework (301) and

a connecting diagram (22) which defines a method of physical connecting by illustrating the at least one device (302, 303) on the at least one framework (301), at least one beginning termination (310) of at least one connector (304), and at least one end termination (311) of the at least one connector (304).

58. The automation system according to claim 31, wherein, when the main controller (600) generates the report, the main controller generates at least one of:

a termination count report, a compatibility report, a summary connector report, a detailed connector report; and

a total number of terminations report,

wherein the total number of terminations report is only displayed on the display (70) without generating a report file (12),

wherein the termination count report comprises information indicating a number of terminations per framework for at least one of a field-side connection and a framework-side connection,

wherein the termination count report, when stored in the report file (12), comprises calculation equations built into the report file to allow a user to track performance of connector installation,

wherein the compatibility report comprises information indicating at least one of engineering drawing file errors and physical connecting errors,

wherein the summary connector report comprises information summarizing connector routing decisions made during the connector length calculation as a guide for personnel installing framework connections, and

wherein the detailed connector report comprises information regarding the connector routing decisions made during the connector length calculation as a guide for technical support personnel to assess accuracy of a given connector length calculation.

32-34. -34. (canceled)

36-37. -37. (canceled)

40-53. -53. (canceled)

56-57. -57. (canceled)

59. (canceled)

60. An apparatus comprising:

a non-transitory computer-readable medium storing at least one engineering drawing file and an automation application comprising a program sequence; and

a main controller configured to;

model in the engineering drawing file at least two objects in a predefined format by adding at least two entities to the engineering drawing file and by adding support information to the engineering drawing file to provide the extractable information,

execute the program sequence of the automation application to establish a correlation of the extractable information, and

generate output data based on the established correlation of the extractable information,

wherein the correlation of the extractable information is established only while the program sequence of the automation application is executed.

62. The apparatus according to claim 60, wherein the main controller is further configured to:

provide application process settings data and a predefined equipment control file template,

add attributes to the at least two entities, and

apply a predefined format to the at least two entities,

wherein the correlation comprises a temporary configuration of the automation application that establishes a temporary relationship between the at least two entities, the support information and the application process settings data, to provide additional information beyond the information about the at least two entities, the support information, and the application process settings data,

wherein the support information comprises at least one of

general settings information,

device specification information comprising device descriptive characteristics, device structural characteristics, device-level connector routing characteristics, device-level process settings, device termination definitions comprising coordinates of the device terminations in a coordinate system calculated from a point of origin defined for each device, termination-level connector routing characteristics, termination data assignments, framework characteristics, and termination interface characteristics, and

connector specification information comprising circuit type definitions, connector characteristics based on an applied circuit type, connector type symbol definitions, and characteristics of a connector end to adapt the connector end to a device termination to which the connector end is connected,

wherein the at least two entities comprise at least one of a text string formatted according to the predefined format, layers, and blocks of grouped entities, and

wherein the application process settings data comprises parameters for executing the automation application.

63. The apparatus according to claim 62, wherein the main controller is further configured to:

store the application process settings data in an application configuration file,

store at least a part of the support information in a relational database,

store the predefined equipment control file template in a predefined template file, and

wherein programmatic macros are embedded in the predefined template file which are executed to convert data provided in a predefined format to a control data file format compatible with and configured to control the connector processing equipment.

89. The apparatus according to claim 60, further comprising:

a display to display a graphical user interface including a main window, a process options selection dialog window, an advanced settings dialog window, and processed information comprising reports;

the main controller being further configured to control features of the graphical user interface and to control the display of the processed information comprising reports; and

a memory configured to store a relational database.

61. (canceled)

64-88. -88. (canceled)