Method and automation system for processing information extractable from an engineering drawing file using information modeling and correlations to generate output data

• US 9,459,600 B2
• Filed: 11/09/2012
• Issued: 10/04/2016
• Est. Priority Date: 11/10/2011
• Status: Expired due to Fees

• 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
• Primary Examiner(s): Schechtman, Sean
• Assistant Examiner(s): GARLAND, STEVEN R
• Application Number:
  US13/824,880
• Publication Number:
  US 20140297013A1
• Time in Patent Office: 1,425 Days
• Field of Search: None
• US Class Current: 1/1
• 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 comprising:

modeling 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;

providing a program sequence in an automation application to establish a correlation of the extractable information;

correlating the extractable information by executing the program sequence;

generating output data based on the established correlation of the extractable information; and

in response to the output data, controlling at least one of a display, printer, engraver, and connector processing equipment,

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

2. The method according to claim 1,

wherein the at least two objects comprise, respectively, a device and a connector, and

wherein the output data comprises a report and an equipment control file comprising control data configured to control an equipment, and

wherein the report is at least one of

(a) stored in a report file, and

(b) displayed on a display.

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

providing application process settings data,

providing a predefined equipment control file template,

adding attributes to the at least two entities, and

applying 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, thereby providing 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.

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

generating a connector tag printer control file to control a connector tag printer;

generating an engraver control file to control an engraver; and

generating a connector processing equipment control file to control a connector processing equipment.

5. The method according to claim 4, wherein the generating of the connector processing equipment control file comprises:

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

wherein the correlated extractable information comprises;

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

locations of terminations to which the connector is connected in the coordinate system of each of the framework devices,

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

locations of framework devices in the coordinate system of each framework.

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

extracting the extractable information;

correlating the extractable information;

calculating a total unadjusted connector length based on at least one of a plurality of connecting scenarios; and

adjusting the total unadjusted connector length,

wherein the extracting of the extractable information comprises;

retrieving information about the at least two entities,

retrieving at least a part of the support information, and

retrieving the application process settings data, and

wherein the plurality of connecting scenarios comprises;

routing the connector around devices located above or below each other and along a framework boundary;

routing the connector around devices located side-by-side;

routing the connector from a framework device to a selected termination interface;

routing the connector from a first termination interface to a second termination interface;

routing the connector from a first termination of a single device to a second termination of the single device;

directly routing the connector from a first device to a second device without routing the connector around the first device and the second device and without routing the connector along the framework boundary, wherein the first device is located above or below the second device; and

directly routing the connector from the first device to the second device without routing the connector around the first device and the second device and without routing the connector along the framework boundary, wherein the first device and the second device are located side-by-side.

7. The method according to claim 6, wherein the adjusting of the total unadjusted connector length comprises:

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

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

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

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

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

upon determining that the connector is a single connector on a same framework device and upon determining that a fixed connector length is used, retrieving a fixed connector length value 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 and upon determining that the fixed connector length is not used segmenting the connector into a plurality of connector segments, calculating a segment connector length for each of the plurality of connector segments, and calculating the total unadjusted connector length based on a summation of segment connector lengths of each of the plurality of connector segments.

9. The method according to claim 8, wherein the segmenting of the connector 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,

calculating a point of origin associated with the at least one device using a coordinate system associated with the at least one device;

calculating a jumper leave distance;

calculating a distance Δ

X between a first x-coordinate value of a first point of termination of the at least one device and a second x-coordinate value of a second point of termination of the at least one device based on the point of origin;

calculating a distance Δ

Y between a first y-coordinate value of the first point of termination of the at least one device and a second y-coordinate value of the second point of termination of the at least one device based on the point of origin,

wherein the jumper leave distance comprises a distance between the second point of termination on the at least one device and a point extending in a direction of termination.

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

upon determining that the connector extends between a first framework device and a second framework device, determining a location of the first framework device and the second framework device relative to each other.

11. The method according to claim 10, further comprising:

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

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, and calculating a total unadjusted connector length based on a summation of the segment connector lengths of each of the plurality of connector segments.

12. The method according to claim 11, wherein the segmenting of the connector 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 common point of origin for the first framework device and the second framework device using a coordinate system associated with the first and second framework devices,

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;

calculating a jumper leave distance;

calculating a distance Δ

X between a first x-coordinate value of a first point of termination of the first framework device and a second x-coordinate value of a second point of termination of the second framework device based on the common point of origin;

calculating a distance Δ

Y between a first y-coordinate value of the first point of termination of the first framework device and a second y-coordinate value of the second point of termination of the second framework device based on the common point of origin,

wherein the jumper leave distance comprises a distance between the second point of termination on the second framework device and a point extending in a direction of termination.

13. The method according to claim 10, further comprising:

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

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

14. The method according to claim 13, wherein the segmenting of the connector 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 common point of origin for the framework using a coordinate system associated with the framework,

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;

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

calculating a distance Δ

X between a first x-coordinate value of a first point of termination of the first framework device and a second x-coordinate value of a second point of termination of the second framework device based on the common point of origin for the framework,

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.

15. The method according to claim 10, further comprising:

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

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, and calculating a total unadjusted connector length based on a summation of the segment connector lengths of each of the plurality of connector segments.

16. The method according to claim 15, wherein the segmenting of the connector 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 common point of origin for the first framework device and the second framework device using a coordinate system associated with the first and second framework devices,

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,

calculating a distance Δ

X between a first x-coordinate value of a first point of termination of the first framework device and a second x-coordinate value of a second point of termination of the second framework device based on the common point of origin;

calculating a distance Δ

Y between a first y-coordinate value of the first point of termination of the first framework device and a second y-coordinate value of the second point of termination of the second framework device based on the common point of origin.

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

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

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

18. The method according to claim 17, wherein the segmenting of the connector 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,

calculating a vertical leave distance for each end of the connector;

calculating a distance to framework edge for each end of the connector;

calculating a distance to framework boundary for each end of the connector;

determining a framework device placement of the first framework device relative to the second framework device;

calculating a vertical distance between points along the framework where the connector is routed,

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

wherein the distance to framework boundary comprises a total distance from the point of termination to the framework edge 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.

19. The method according to claim 1, wherein, to prevent the extractable information from being correlated without the automation application being executed, the program sequence included in the automation application and the at least two objects are modeled in the engineering drawing file in the predefined format, and

wherein the correlation is accessible only by the automation application.

20. An automation system 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 at least one engineering drawing file at least two objects in a predefined format by adding at least two entities to the at least one engineering drawing file and by adding support information to the at least one engineering drawing file to provide 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;

a connector tag printer controlled by a connector tag printer controller based on at least one equipment control file and configured to print connector tags;

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

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

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

a communication controller to transmit the output data to the connector tag printer controller, the engraver controller, the file converter, and the connector processing equipment controller.

21. The automation system according to claim 20,

wherein the at least two objects comprise, respectively, at least one device and a connector,

wherein the output data comprises at least one of a report and an equipment control file comprising control data configured to control an equipment, and

wherein the report is at least one of

(a) stored in a report file, and

(b) displayed on a display.

22. The automation system according to claim 21,

wherein, after the main controller generates a connector processing equipment control file, the communication controller transmits the connector processing equipment control file to the file converter and the file converter converts an equipment control file format and equipment control file data of the connector processing equipment control file into an equipment control file format and equipment control file data of a converted connector processing equipment control file based on a predefined equipment control file template, to obtain a specific file and data format required by the connector processing equipment.

23. The automation system according to claim 21, wherein, when the main controller generates a connector tag printer control file, the main controller 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.

24. The automation system according to claim 21, further comprising:

a framework, and

a termination interface,

wherein the at least one 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 the 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 at least one engineering drawing file comprises at least one of;

an elevation diagram which defines a layout of at least one framework and a location of the at least one device on the at least one framework and

a connecting diagram which defines a method of physical connecting by illustrating the at least one device on the at least one framework, at least one beginning termination of at least one connector, and at least one end termination of the at least one connector.

25. The automation system according to claim 21, wherein, when the main controller 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 without generating a report file,

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, 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 a 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.

26. The automation system according to claim 20, wherein the automation system further comprises a design processor which displays a user interface on a display to model the at least two objects in the predefined format, and

wherein the output data comprises a compatibility report which lists entities and support information that do not correspond to the predefined format.

27. The automation system according to claim 20, wherein the connector processing equipment is configured to cut a connector to a length, to print information on the connector, and to prepare both ends of the connector for installation, and

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

28. 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 at least one engineering drawing file at least two objects in a predefined format by adding at least two entities to the at least one engineering drawing file and by adding support information to the at least one 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, and wherein at least one of a display, printer, engraver, and connector processing equipment is controlled in response to the output data.

29. The apparatus according to claim 28, 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.

30. The apparatus according to claim 29, 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.

31. The apparatus according to claim 28, 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.