Spool drawing material take off / construction quantity calculation / list creation system

Abstract

Provided is a spool drawing material take off / construction quantity calculation / list creation system capable of shortening an input time of component take off and reducing input error, and capable of shortening the estimation and ordering time at the time of estimation and order of plant piping.　The present invention comprises: a drawing break-down means (11) that breaks down spool drawings in a drawing matrix arrangement into one file per drawing, on the basis of a plurality of pieces of spool drawing data respectively including component table data of piping used in a plant; a specification allocating means (12) that extracts the component table data, collates the extracted component table data with specifications of specification table data prepared in advance, allocates a material and remarks to a blank, and returns updated component table data to the plurality of spool drawings; a material aggregating means (13) that aggregates the plurality of pieces of component data to create component aggregation data; and a drawing managing means (14) that automatically creates a drawing management list.

Description

Spool Drawing Material Take-off, Construction Quantity Calculation, and List Creation System

[0001] The present invention relates to a spool drawing Material Take Off, construction quantity calculation, and list creation system for supporting part aggregation from bill of material data extracted from a plurality of spool drawing data created by CAD software and drawing management list creation when estimating and ordering plant piping.

[0002] In various plants, piping for petroleum, chemistry, gas, steel manufacturing, pharmaceutical, water supply, electricity, communication and the like is used as needed. When estimating and ordering such piping, work is performed by manually extracting data required for estimation and ordering from spool drawings created by CAD software, and preparing estimates and purchase orders.

[0003] In such piping design, as disclosed in, for example, Patent Document 1, spool drawing data is first created by CAD software, and a spool drawing is created based on this data.

[0004] This spool drawing shows various parts (materials) constituting the piping. When managing these parts, it is necessary to create a parts list including each part name, the number of parts and the like. Generally, CAD software has a function of creating bill of material data in which part names, the number of parts and the like are organized in a table format based on the created spool drawing data.

[0005] Japanese Unexamined Patent Publication No. 2000-76322

[0006] Piping Technology, December 2020 Issue, "Explanation: Improving Efficiency of Plant Piping Material Aggregation <Improving Complicated Work at Construction Sites and Aiming for Ideal Work Style Reform>", pp. 15-22

[0007] Incidentally, in plant construction, design work is often divided among multiple contractors, and these contractors generally use different, incompatible CAD software (for example, AutoCAD®, EYECAD®, ISOGEN®). Therefore, traditionally, workers would extract parts and their quantities from numerous spool drawings created with these different CAD software programs, and then manually enter the extracted information into spreadsheet software to create summary tables. As a result, this work by workers was complicated and time-consuming, and errors occurred due to individual input habits, which prevented accurate summaries.

[0008] To address the above-mentioned problems, the inventors developed a material aggregation system capable of streamlining plant piping material aggregation, as shown in Non-Patent Document 1. By automating material aggregation from spool diagrams using this developed material aggregation system, a certain level of efficiency in plant piping material aggregation was achieved. However, it was found that there is room for improvement when reviewing the overall processing flow during the estimation and ordering of plant piping.

[0009] This invention has been made in view of the above problems, and aims to provide a spool diagram material take-off, construction volume calculation, and list creation system that, when estimating and ordering plant piping based on multiple spool diagrams, can shorten the input time for parts aggregation from bills of materials assigned to each spool diagram, standardize aggregation work, output reports, reduce input errors, and shorten the estimation and ordering time.

[0010] The first invention's spool diagram material aggregation (Material Take Off), construction volume calculation, and list creation system is characterized by comprising: a drawing decomposition means that decomposes spool diagram data arranged in a drawing matrix into one drawing file based on multiple spool diagram data created by CAD software, each containing bill of materials data for piping used in a plant; a specification assignment means that extracts bill of materials data with the material column and remarks column left blank from the multiple spool diagram data decomposed by the drawing decomposition means, compares the extracted bill of materials data with the specifications of pre-prepared specification table data, assigns the material and remarks to the blanks, and returns the updated bill of materials data to the multiple spool diagrams; a material aggregation means that aggregates multiple parts data contained in each bill of materials data extracted from the multiple spool diagram data including the bill of materials data updated by the specification assignment means and generates a bill of parts aggregation data; and a drawing management means that automatically creates a drawing management list from the multiple spool diagram data.

[0011] The spool diagram material take-off, construction volume calculation, and list creation system of the second invention is characterized in that, in the first invention, the material take-off means includes: an extraction program that extracts each bill of materials data from each spool diagram data created by CAD software in DXF file format; a check program that checks each of the multiple parts data included in each bill of materials data extracted by the extraction program; a BM / DB calculation program that calculates the welding volume for each part data by calculating inch meters from the diameter and length of the piping used in the plant and diamond inches from the diameter of the piping used in the plant and the number of weld locations; an aggregation program that aggregates each part data, including the inch meter data and diamond inch data obtained by the BM / DB calculation program, for each specification of the piping to create the parts aggregate data; and a reporting program that reports the parts aggregate data created by the aggregation program.

[0012] The third invention's spool drawing material aggregation (Material Take Off), construction volume calculation, and list creation system is characterized in that, in the second invention, each spool drawing data includes drawing frame data and drawing number / revision number data in each spool drawing data, and the coordinates and text color layer data of each part data in each parts list data, and the check program checks the part name, numerical value, position of piping specifications, text color layer, and blank cells related to each parts list, as well as the positional deviation of the drawing frame, revision number, and DXF file version related to each spool drawing data.

[0013] The fourth invention's spool diagram material aggregation (Material Take Off), construction volume calculation, and list creation system is characterized in that, in the second invention, each component data includes additional component data from an out-of-frame table added outside the drawing frame of the corresponding spool diagram data, and the extraction program also extracts the additional component data.

[0014] The fifth invention's spool diagram material aggregation (Material Take Off), construction volume calculation, and list creation system is characterized in that, in the second invention, the spool diagram data to be extracted by the extraction program is obtained by first converting the multiple spool diagram data, which are incompatible file formats, into the DXF file format.

[0015] The type of plant is arbitrary. For example, it can be petroleum, chemical, gas, steel, pharmaceutical, water, electricity, telecommunications, etc. The type of piping can be process piping, utility piping, gas piping, water piping, electrical piping, telecommunications piping, etc. The material, size, shape, and number of pipes used are arbitrary. Of course, pipes will be welded to each other, or to pipe fittings, as necessary.

[0016] Spool diagram material aggregation software is a program that assists in aggregating component data extracted from the bills of materials of multiple spool diagrams created using CAD software during the production (including modifications and changes) of plant piping. Examples of CAD software that can be used include AutoCAD®, EYECAD®, and ISOGEN®. The CAD software can be either 2D or 3D.

[0017] Compatible file formats include, for example, the DXF® file format. Incompatible file formats include, for example, the DWG® file format. The items in the bill of materials are arbitrary. For example, items such as No. (number of parts rows in one spool diagram), file name (file name of the spool diagram), regulations / procurement (certified valve, supplied parts, supplier, etc.), part name (product name), size (large and small sizes, branch size, bolt length, etc.), material (pipe material), quantity (pipe (M), bolt and nut (S), etc.), unit (may be automatically split using a numerical or string splitting function), remarks (schedule, connection type, flange type, special notes, etc.), specifications (pipe specifications), area / drawing number, spare, etc. may be used.

[0018] Spool diagram data refers to the various electronic data that make up a spool diagram. Spool diagram data includes graphic data and non-graphic data (such as bill of materials data and parts data: data consisting of characters, numbers, etc. that are not graphic). The extraction program is the logic that extracts bill of materials data (including parts data) and, if necessary, extra-frame data (including additional parts data) added outside the diagram frame from each spool diagram data. Part data (character data) in DXF file format is data in TEXT® file format that can also be used with EXCEL®.

[0019] This extraction program may be equipped with PDF (registered trademark) or OCR (Optical Character Recognition) functionality to extract manually entered characters and numbers. The number of spool diagrams extracted by the extraction program is arbitrary; for example, it could be several hundred or several thousand. The data check by the check program includes data checks performed before the extraction program extracts the spool diagram data. For example, this includes checking the positional misalignment of the spool diagram frame, the file format, the position of the piping specifications in the bill of materials, and the text color layer in the bill of materials. Examples of checks here include, for example, checking the part names, numerical values, position of piping specifications, text color layer, and blank cells associated with each item in the bill of materials, as well as checking the positional misalignment of the spool diagram frame, the revision number of the drawing, and the version of the DXF file.

[0020] The BM / DB calculation program is a logic that calculates the inch-meter (B / M) value by multiplying the pipe diameter (AB designation) by its length (M), and the diamond-inch (D / B) value, which is the welding amount when welding pipes together or pipes to joints. The aggregation program is a logic that aggregates the component data, including each inch-meter and diamond-inch data, entered in the parts list, for each pipe specification.

[0021] A report program is the logic for generating reports from parts summary data in Excel file format. The material summary software may also have an output program for outputting (printing out, displaying on a screen) the parts summary data after file conversion. In addition, this material summary software may include, for example, an automatic left / right splitting program that automatically divides pipe sizes such as 1 1 / 2B x 3 / 4B into (left) 1 1 / 2B and (right) 3 / 4B, and an automatic numerical-string splitting program that automatically splits numerical columns into strings (e.g., 10m, 5s).

[0022] According to the spool diagram material aggregation (Material Take Off), construction volume calculation, and list creation system of the present invention, when estimating and ordering piping for a plant, material aggregation software is used to extract and aggregate multiple component data from multiple spool diagram data created in DXF file format by CAD software. Specifically, an extraction program extracts each component bill data from multiple spool diagram data, and then a check program checks the multiple component data contained in each extracted component bill data. Next, for each component data deemed appropriate in this check, a BM / DB calculation program calculates inch meters from the pipe diameter and length, while also calculating diamond inches from the pipe diameter and the number of welds.

[0023] Next, the obtained inch-meter data and diamond-inch data for each component are aggregated by a compilation program according to the piping specifications to create component compilation data. Subsequently, a reporting program generates a report from this component compilation data. Based on the component compilation data (spool diagram data) thus obtained, the time required for piping estimation and order creation can be shortened. As a result, when estimating and ordering plant piping based on multiple spool diagram data, it is possible to shorten the input time for component aggregation from each bill of materials associated with each spool diagram, standardize the aggregation work, output reports, and reduce input errors.

[0024] In particular, according to the third invention, since each spool drawing data includes drawing frame data, drawing number / revision number data, piping specification position data, and text color layer data, when checking with a check program, in addition to the part data related to each bill of materials, such as part name, numerical value, piping specification position, text color layer, and blank cells, checks can be made for each spool drawing, such as the positional misalignment of the drawing frame, revision number, and DXF file version.

[0025] Furthermore, according to the fourth invention, each component data includes multiple additional component data from an out-of-frame table displayed outside the frame of the target spool diagram. Therefore, when the extraction program extracts the data, each additional component data is also extracted. This makes it possible to aggregate not only the component data from the parts lists assigned to each of the multiple spool diagrams, but also the additional component data from the newly created out-of-frame table, for each piping specification.

[0026] Furthermore, according to the fifth invention, even if the spool diagram data extracted by the extraction program is created by multiple CAD software programs using incompatible file formats, these incompatible spool diagram data can be converted to a compatible DXF file format prior to the extraction.

[0027] The drawings illustrate specific embodiments of the present invention as disclosed herein, including not only essential components of the invention but also selective and preferred embodiments. Figure 1 is a schematic functional block diagram of the spool diagram material take-off, construction volume calculation, and list creation system of the present invention. Figures 2(a) to 2(d) are image diagrams of the entire processing flow for material take-off and list creation from the spool diagram. Figure 3 is a processing flowchart that implements the functions of Figure 1 in software. Figure 4 is a pre-processing flowchart. Figure 5 is a diagram showing an example of computer hardware configuration. Figure 6 is a diagram showing an example program of the spool diagram material take-off software. Figure 7 is a flowchart of the spool diagram piping material take-off software implemented on the hardware of Figure 6. Figure 8 is a diagram showing the spool diagram frame (template) outer table and notes on take-off. Figure 9(a) is a diagram showing the main area of ​​the piping material table, and Figure 9(b) is a diagram showing the reserve area of ​​the piping material table. Figure 10 is a diagram showing the relationship between the spool diagram, drawing information extraction, parts list item names, and extracted coordinate values. Figures 11(a), (b), and (c) show templates for other bills of materials. Figure 12 shows an example of the startup screen of the spool diagram material aggregation system of the present invention. Figure 13 shows an example of the selection operation of the DXF file reference tab. Figure 14 shows the bill of materials extraction results. Figure 15 shows an example of the execution of the fully automatic button. Figure 16 shows the result of automatic copying of specifications. Figure 17 shows the automatic calculation results of "B x M" and "D x B". Figure 18 shows the result of automatic aggregation table creation. Figure 19 shows a quantity table. Figure 20 shows an example of file input / output tab selection. Figure 21(a) shows input of a file output file, and (b) shows completion of file output. Figure 22 shows an example of definition settings (definition sheet). Figure 23 shows an example of a partial excerpt of a pipe size table (designation A, B). Figure 24 shows an example of a partial excerpt of items and sort no. Figure 25 shows an example of the number of welding locations. Figure 26 shows an example of calculating diamond inches and inch meters in manual mode. Figure 27 shows an example of automatically creating a summary sheet. Figure 28 shows an example of tool and extraction settings. Figure 29 is a diagram to explain other functions. Figure 30 is a diagram to explain the extracted data quality check function. Figure 31 shows an example of report output for the piping material list.Figure 32 shows an image of the parts list extraction from a DWG (DXF) spool diagram, with (a) showing an example of multiple files (matrix) and (b) showing a composite type. Figure 33 shows an example of a spool diagram frame (template). Figure 34 shows an example of the properties of the string to be extracted. Figures 35(a) and (b) show the relationship between parts list item names and extracted coordinate values. Figure 36 shows an example of a drawing layout configuration. Figure 37 shows an example of a note on the string of the specification name. Figure 38 shows an example of a drawing layout image. Figure 39 shows an example of a fully automatic mode. Figure 40 shows an example of DXF file reference selection. Figure 41 shows the automatic calculation results of "B×M" and "D×B". Figure 42 shows an example of fully automatic & file output selection. Figure 43 shows the automatic creation results of the summary table and piping material table. Figure 44 shows the piping material table. Figure 45 shows an example of definition settings (definition sheet). Figure 46 shows automatic deletion of class names in manual mode. Figure 47 shows confirmation of class deletion during automatic aggregation and file output. Figure 48 shows an example of operation during extraction check. Figure 49 shows the parts list extraction result. Figure 50 shows the execution result when formatting 1 is selected. Figure 51 shows the output result of file input / output. Figures 52(a) and (b) show examples of file name input. Figure 53 shows an example of report output for the piping materials list.

[0028] The embodiments illustrated below, applying the present invention, will be described with reference to the drawings.

[0029] <Embodiment> <Embodiment 1 Overview> Figure 1 is a schematic functional block diagram of a spool diagram material take-off, construction volume calculation, and list creation system showing an embodiment of the present invention, and Figure 2 is a diagram to explain the overall image of the entire processing flow from spool diagram to material take-off and list creation. The outline of this embodiment will be explained below using Figures 1 and 2.

[0030] As shown in Figure 1, the spool drawing material aggregation and list creation system 1 of this embodiment includes a drawing breakdown means 11, a specification assignment means 12, a material aggregation means 13, and a drawing management means 14.

[0031] As shown in Figure 2(a), the drawing decomposition means 11 decomposes a spool diagram arranged in a drawing matrix into one drawing file, based on multiple spool diagram data created by CAD software, each containing bill of materials data for piping used in the plant. When creating spool diagrams with 2D CAD, if multiple diagrams are created in one file, the spool diagram is decomposed into one diagram, one file. This type of drawing matrix arrangement is often used. If the spool diagram arrangement is one diagram per file, drawing decomposition is not performed.

[0032] As shown in Figure 2(b), the specification assignment means 12 extracts bill of materials data with the material and remarks columns left blank from the multiple spool drawings separated by the drawing separation means 11, compares the extracted bill of materials data with the specifications in the pre-prepared specification table data, assigns the material and remarks to the blanks, and returns the updated bill of materials data to the multiple spool drawings. Conventionally, when drawing with 2D CAD, inputting the material and remarks columns had to be done manually, which was time-consuming. In this embodiment, it is possible to automatically assign them from the specification table, thus reducing working time.

[0033] As shown in Figure 2(c), the material aggregation means 13 aggregates multiple part data contained in each parts list data extracted from multiple spool drawing data, including parts list data updated by the specification assignment means 12, and outputs the parts aggregation data as a report. The material aggregation means 13 mainly creates a piping material aggregation table and calculates the amount of work (BM, DB). The detailed processing of the material aggregation means 13 can also be performed using known methods disclosed in Non-Patent Literature 1. The 2D CAD version (AUTOCAD) is mainly applied to small-scale, scheduled maintenance, and modification work. Conventionally, when drawing with 2D CAD without attribute information, manual input was required for the parts list column. Furthermore, when aggregating materials, it was necessary to manually input or copy and paste each sheet into a spreadsheet program. In addition, when there were dozens or hundreds of drawings, it was not only time-consuming but also prone to input errors. In this embodiment, piping material aggregation is automated, and the creation of a piping material aggregation table and calculation of the amount of work (BM, DB) can be performed in a short time. When spool output is performed automatically using 3D CAD (EYECAD®, ISOGEN®), material calculations are usually possible using the 3D functions. However, if there are drawing modifications on-site, the 3D CAD cannot keep up with the changes. Therefore, when modifications are made using 2D CAD, the system of this embodiment is useful. In order to automate the process, it is necessary to prepare separate systems tailored to each 3D CAD software. Specifically, it is necessary to prepare a system for extracting bills of materials and calculating materials from spool drawings output by EYECAD®, a system for extracting bills of materials and calculating materials from spool drawings output by ISOGEN®, and a system for assigning specifications and calculating materials from bills of materials output by PlantStream®.

[0034] As shown in Figure 2(d), the drawing management means 14 automatically creates a drawing management list from multiple spool drawing data. In addition to automatically creating a drawing management list from spool drawings, the drawing management means 14 also has a function to compare and update old and new lists.

[0035] The drawing breakdown means 11, specification assignment means 12, material aggregation means 13, and drawing management means 14 described above can be implemented using computer hardware or software. Figure 3 shows a processing flowchart when each means 11 to 14 is implemented using software. The drawing breakdown means 11 corresponds to the drawing breakdown processing step 101 of the drawing matrix arrangement. Details of the drawing breakdown processing step 101 have been described above, so the explanation will be omitted. The specification assignment means 12 corresponds to the two-dimensional spool diagram specification assignment processing step 102. Details of the specification assignment processing step 102 have been described above, so the explanation will be omitted. The material aggregation means 13 corresponds to the spool diagram piping material aggregation processing step 103, and a characteristic processing of the present invention is that it has a piping material aggregation table creation processing step 104 and a construction volume calculation (BM, DB) processing step 105. The drawing management means 14 corresponds to the spool drawing management list creation processing step 106. Details of the spool drawing management list creation processing step 106 have been described above, so the explanation will be omitted.

[0036] Figure 4 shows the pre-processing flowchart. As shown in Figure 4, preliminary preparation is performed from customer materials according to the pre-processing flowchart (step 201), a spool diagram is created using the 2D function of AutoCAD (step 202), then the DWG file is converted to a DXF file (for example, DXF2004 format), and then purged in advance.

[0037] As shown in Figure 5, the computer 20 is a workstation or high-performance personal computer on which CAD software and various other software are installed, and which is used to utilize the CAD software and the spool drawing material aggregation and list creation system. The spool drawing material aggregation and list creation system may be implemented using a general-purpose cloud service. In this embodiment, the spool drawing material aggregation and list creation system 1 is implemented separately as a spool drawing material aggregation system and a drawing management list creation system. The spool drawing material aggregation system (hereinafter also referred to as the spool drawing material aggregation software) will be described below.

[0038] The computer 20 has a control unit 21 that incorporates a CPU, which is a central processing unit. Its input ports are connected to an information acquisition unit 24 that acquires various data from spool diagram material aggregation software 22 and DXF files 23, a keyboard 25, and a storage unit 26 such as ROM, RAM, and HDD. On the other hand, a display 27 and a printer 28 are connected to the output ports of the control unit 21.

[0039] As shown in Figure 6, the spool drawing material aggregation software 22 includes an extraction program 29 that extracts each bill of materials data from a large number of spool drawing data (1,000 in this case) created using 2D CAD software in DXF file format provided by engineering companies and design companies; a check program 30 that checks each of the numerous parts data included in each bill of materials data extracted by the extraction program 29; a BM / DB calculation program 31 that calculates the welding amount by calculating inch meters from the pipe diameter and length, and by calculating diamond inches from the pipe diameter and the number of weld locations for each part data; an aggregation program 32 that aggregates each part data, including the inch meter data and diamond inch data obtained by the BM / DB calculation program 31, according to the pipe specifications to create parts aggregation data; and a reporting program 33 that reports the parts aggregation data.

[0040] The following describes the method for automatically calculating the piping material using the spool diagram material calculation software 22 with respect to the flowchart in Figure 7. Next, in step 301, the spool diagram material calculation software 22 is started. Specifically, the spool diagram (DXF) material calculation program (coordinate extraction) is started.

[0041] Next, in step 302, multiple spool drawing data (DXF files 23) created by the provided 2D CAD software in DXF file format are loaded. Here, additional part data from the out-of-frame table added outside the drawing frame of the corresponding spool drawing is also loaded as spool drawing data (see Figure 8).

[0042] Compared with the A3 standard drawing frame (with origin alignment at the lower left corner), the character position of the bill of materials can be adapted to both left-alignment and center-alignment. In addition, for cases other than A3 standard drawing frames, coordinate values shall be checked via 2D CAD software and input into this table.

[0043] As shown in FIG. 10, each item name (displayed in a thick frame) and each coordinate value (displayed in a dotted thick frame) can be changed by the user. In addition, if "Specification / Arrangement" is unnecessary, input the same coordinate value as that for "Item Name". Furthermore, "Y-axis upper left" is normally set to "-" (extracted when the bill of materials exists beyond the upper paper frame).

[0044] Each read spool drawing data is stored in the storage unit 26. Hereinafter, these data are displayed on the display 27 of the computer 20 as needed, and the operator performs processing such as correction using the keyboard 25.

[0045] Thereafter, in step 303, the extraction program 29 is activated to extract each bill of material data (including additional component data) in TEXT file format from a plurality of pieces of spool drawing data respectively.

[0046] As shown in FIG. 14 described later, for each item: "No." indicates the number of component rows in one spool drawing; "File Name" indicates the file name of the spool drawing; "Specification / Arrangement" indicates approved valves, supplied goods, arrangement destinations, etc.; "Item Name" indicates the ITEM name; "Size" indicates mother pipe size, branch size, bolt size, bolt length; "Material" indicates piping material; "Quantity" indicates pipes (M), bolts and nuts (S), others (pieces); "Unit" is automatically split by the numerical value and character string splitting function (default: automatic splitting); "Remarks" includes schedule, connection type, flange type and other special notes; "Spec" indicates piping specifications; "Area, Drawing No." shall be input with area and drawing number if required; "Spare 1" is spare 1 (for heat insulation, etc.); "Spare 2" is spare 2; "Spare 3" is spare 3. These spares 1 to 3 can be changed (for floor, weight, painting, etc.) as needed.

[0047] In step 304, the check program 30 is activated to individually check a large number of piece of component data included in each bill of material data extracted by the extraction program 29. Specifically, a bill of materials for each file (color-coded for each file) is extracted on the Excel bill of materials, and the number of extracted files is also displayed. Here, it is checked whether there are any omissions or garbled characters in the extracted data. In addition, automatic copying of specifications (including areas and drawing numbers) is performed, and the specification names on the Excel bill of materials are copied downward. Here, it is checked whether the specifications are allocated without any problem.

[0048] In step 305, the BM / DB calculation program 31 is activated. For each piece of component data, inch-meter is calculated from the diameter and length of the pipe, and diamond-inch is calculated from the pipe diameter and the number of welding locations to obtain the welding amount. Specifically, the calculations of "B×M" and "D×B" and the addition of item names are automatically performed, and the resulting values are placed.

[0049] In step 306, the aggregation program 32 is activated, and each piece of component data including inch-meter data and diamond-inch data obtained by the BM / DB calculation program 31 is aggregated for each pipe specification to create component aggregated data.

[0050] In step 307, the form program 33 is activated to form the aggregated component data. Specifically, sheets for each specification are automatically created, and "material aggregation", "D×B" and "D×I" for each specification are automatically aggregated. The display order of [product name] is determined by the sort No., and if there is no sort No., it is displayed at the end. When aggregating only materials, unchecking [BM], [DB], [Area / Drawing No.], [Spare 1], [Spare 2], [Spare 3] results in aggregation of only each material.

[0051] In step 308, the aggregated component data formed by the form program 33 is printed by the printer 28 as a "piping material list", or output as electronic data in Excel file format, and submitted to the submitting company (see FIGS. 9(a) and (b)). This program ends here.

[0052] Thus, according to Embodiment 1, when estimating and ordering piping for a plant, the spool drawing material aggregation software 22 is used to extract and aggregate multiple component data from multiple spool drawing data (DXF files 23) created in DXF file format by 2D CAD software.

[0053] Specifically, the extraction program 29 extracts each bill of materials data from multiple spool diagram data, and then the check program 30 checks the multiple parts data contained in each extracted bill of materials data. Next, for each part data deemed appropriate in this check, the BM / DB calculation program 31 calculates inch meters from the pipe diameter and length, while also calculating diamond inches from the pipe diameter and the number of welds.

[0054] Next, the obtained inch-meter data and diamond-inch data for each component are aggregated by the aggregation program 32 according to the specifications of the piping to create component aggregation data. Then, the reporting program 33 generates a report of the component aggregation data. Based on the component aggregation data thus obtained, estimates and purchase orders for plant piping are created and the estimates and orders are placed. As a result, when estimating and ordering plant piping based on multiple spool diagram data, it is possible to shorten the input time for component aggregation from each parts list associated with each spool diagram, standardize the aggregation work, and reduce input errors.

[0055] Furthermore, since each spool drawing data includes drawing frame data, drawing number / revision number data, piping specification position data, and text color layer data, when checking with the check program 30, in addition to the part data associated with each bill of materials, such as part name, numerical value, piping specification position, text color layer, and blank cells, at least one of the following checks can be performed for each spool drawing: the positional misalignment of the drawing frame, the revision number, and the version of the DXF file 23.

[0056] Furthermore, each component data includes multiple additional component data from an out-of-frame table displayed outside the drawing frame of the target spool diagram. Therefore, when the extraction program 29 performs the extraction, each additional component data is also extracted. This allows for the aggregation of component data not only from the parts lists assigned to each of the multiple spool diagrams, but also by adding the additional component data from the newly created out-of-frame table, and then aggregating the data for each piping specification.

[0057] Furthermore, if the spool diagram data extracted by the extraction program 29 were created by multiple 2D CAD software programs using incompatible file formats, these incompatible spool diagram data are converted to a compatible DXF file format prior to extraction. This allows the spool diagram material aggregation software 22 to be used without problems.

[0058] <Embodiment 2: Spool Diagram Material Aggregation System> The spool diagram material aggregation system of Embodiment 2 is a fully automated support system that enables piping material aggregation with the aim of shortening the input time, standardizing aggregation work, and reducing input errors when aggregating materials from spool diagrams (DXF). Conventional input was done manually for each spool diagram, which was time-consuming and prone to input errors. Furthermore, the coefficients and calculation formulas for diamond inches and inch meters had to be entered and corrected for each job each time, making the operation complicated and difficult. By extracting bills of materials from multiple drawings, aggregating them, and outputting reports, while simultaneously performing a quality check of the bill of materials data, the system can be performed in an error-free manner. From the moment the program starts, it can be easily operated and processed automatically at high speed.

[0059] The main functions of this system include automatic extraction of spool drawing bills of materials created in AutoCAD (DXF) (multiple files can be extracted), material aggregation function by specification, DB (diameter inch) aggregation function, BM (inch meter) aggregation function, automatic left / right splitting of sizes such as 1 1 / 2B x 3 / 4B (e.g., 1 1 / 2B and 3 / 4B), automatic splitting of numerical strings (10m, 5s), output of aggregation result (report) files, data check before extraction (DXF version check, drawing frame misalignment, text color check, numerical check), data check function after extraction (missing specifications, missing part names), and automatic conversion of character code corruption. In addition, by inputting auxiliary (1-3) items on the user side, it is possible to aggregate materials by area, floor, fluid, material, etc.

[0060] The advantages of this program include: no manual input required for the bill of materials, eliminating input errors; automatic checking of extracted data allows for quick identification of errors in the bill of materials; and the extracted data is easy to read, making checking easier (automatic sorting function by designation A and B). Furthermore, it offers high-speed processing (if converted to DXF), completing the aggregation of 1000 spool diagrams in approximately 5 minutes (without processing); and eliminating the need for primary and secondary aggregation. Even if the spool diagrams are modified, aggregation is instantaneous. Because calculation formulas are not manually entered, the file size of the bill of materials and reports is small. The spool diagram paper frame can be standardized and used as a common drawing frame for collaborating vendors.

[0061] The DWG (DXF) bill of materials extraction image for spool diagrams can be either one spool diagram per file or multiple spool diagrams per file (arranged in a single column upwards).

[0062] <Bill of Materials Item Names and Extracted Coordinate Values> An example of bill of materials item names and extracted coordinate values ​​is shown in Figure 10. The bill of materials text position can be left-aligned or centered, based on the standard A3 drawing frame of the bill of materials (aligned to the origin in the lower left). If the bill of materials is not in the standard A3 drawing frame, the coordinate values ​​should be looked up from CAD and entered into this table. In principle, there should be one string of text per box in the bill of materials. The font size can be changed as long as it fits within the box. If there are many characters in the box, enter them using AutoCAD's multiline text and make it two lines of text (see Figure 8). The system also supports cases where the drawing frame is scaled, but this is not the case for all cases.

[0063] The item names (thick border) can be changed by the user (but not in order). The coordinate values ​​(thick dotted border) can be changed by the user. If "Regulations / Arrangement" is not required, enter the same coordinate values ​​as "Item Name". "Y-axis top left" is usually "-" (extracts if a parts list exists beyond the upper paper frame). If you enter coordinate values ​​in "Y-axis top left", it will only extract up to the upper coordinate value (upper limit). If you enter coordinate values ​​in "X-axis right side", it will only extract up to the right coordinate value (upper limit).

[0064] <Other Bill of Materials Templates> Examples of other bill of materials templates are shown in Figures 11(a), (b), and (c). For EYECAD®, only extraction is permitted. For ISOGEN®, only extraction is permitted, although the customer may have customized the bill of materials frame.

[0065] Figure 14 shows an example of a parts list automatically extracted by the spool diagram material aggregation system. The following explains each item in Figure 14. <Explanation of each item> No.: Number of parts rows in 1 spool diagram (automatically added) File name: File name of the spool diagram (automatically added) Regulations / procurement: Enter if there are certified valves, supplied items, suppliers, etc. Item name: ITEM name Size: Main pipe size, branch size, bolt size, bolt length Material: Piping material (required in principle) Quantity: Pipe (M), bolts and nuts (S), others (pieces) Unit: Numerical value, automatically split using the string splitting function (default: automatic splitting) Remarks: Schedule, connection type, flange type, etc., special notes Specifications: Piping specifications (required in principle) Area, drawing number: Enter area and drawing number if necessary Spare 1: Spare 1 (insulation, etc.) Spare 2: Spare 2 Spare 3: Spare 3 Here, spares 1 to 3 can be changed as needed (floor, weight, paint, etc.). Item names can be changed by the user.

[0066] <Fully Automatic Mode> The following describes the process in fully automatic mode. Start the Spool Diagram (DXF) Material Summary Program Ver 8.0.EXE. An example of the startup screen is shown in Figure 12. Copy it to the JOB folder beforehand. Starting it on the server may not work depending on the security settings of each company; in that case, use it locally.

[0067] First, select the [Browse DXF File] tab shown in Figure 12. That is, select the desired DXF file(s) (multiple selections are possible) and then select [Open] (see Figure 13).

[0068] When you make the above selection, the parts lists for each file (color-coded by file) will be extracted into the "Parts List" in Excel (see Figure 14). The number of extracted files will also be displayed, and you can check for any missing or garbled characters in the extracted data. A warning will be displayed if there are any errors. Error detection is performed based on factors such as the DXF version, text color, missing specifications, misaligned rows (judged by the part name), and insufficient number of columns.

[0069] After the bill of materials is extracted, select [Fully Automatic] (see Figure 15). Automatic copying of specifications (including area and drawing number) will be performed. The specification names on the "Bill of Materials" will be copied downwards (see Figure 16). At this point, verify that the assignments have been made correctly.

[0070] After confirming that the assignment is correct, pressing the [OK] button will automatically calculate "B x M" and "D x B," automatically add item names, and place the resulting values ​​(see Figure 17). The definition sheets for "B x M" and "D x B" will be described later.

[0071] <Automatic Summary Table Creation> When you press the [OK] button on the screen shown in Figure 17, a "Summary Table" is automatically created, and the "Material Summary," "B x M," and "D x B" for each specification are automatically calculated. Furthermore, the report is divided into sheets for each "Specification." Here, the display order of the [Product Name] is determined by the sort number, and if there is no sort number, it will be displayed last (see Figure 18).

[0072] <Outside Print Range> [BM], [DB], [Area / Drawing Number], [Reserve 1], [Reserve 2], [Reserve 3], etc. will also be printed outside the print range, so you can use them as needed.

[0073] <Quantity List> Selecting [Quantity List] from the screen menu in Figure 12 or Figure 15 will output BM, DB, PIPE length, and AVB for each SPEC. An example of this output is shown in Figure 19. File Output The extracted sheet "Bill of Materials" and the summarized sheet "Summary Table" etc. will be output as files, and this program will be disconnected.

[0074] <File Input / Output> Select the [File Input / Output] tab (see Figure 20). Select the desired sheet. [Extract Sheet Output]: Outputs the extracted data (necessary as a backup just in case) [Summary Sheet Output]: Outputs the summary sheet (mainly used for checking) [Piping Material List Output]: Outputs the final report to be submitted [Definition Sheet Output]: Outputs the environment setting file (product name, DB coefficients, etc.) (necessary as a backup just in case)

[0075] Enter the file name (see Figures 21(a) and (b)). After entering the file name, the file will be output. After the file is output, format it as needed. This completes the series of tasks for material aggregation.

[0076] <Definition Settings (Definition Sheet)> Define the size, product name, sort number, and number of welds. An example of a definition sheet is shown in Figure 22. A partial excerpt of pipe sizes ((A, B) designations) is shown in Figure 23. Here, either A or B designations are supported, sizes 1B and below are set to "1" by default (changeable), several fractional notations are provided, and users can change or add if they differ, and missing sizes, Φ display, etc. can be added. The [Size] section in Figure 23 will be the coefficient of DI.

[0077] <Items and Sort No. (Partial Excerpt)> Figure 24 shows an example of a partial excerpt of items and sort numbers. Several [ITEMs] are pre-configured, and if there are any items that are not registered, the user should register them and enter the sort number (duplicates are allowed, decimal points are allowed). However, to distinguish between flange type and SW, valves must be numbered 901 or higher.

[0078] <Number of Welds> An example of the number of welds is shown in Figure 25. (1) Size coefficient 1: (Enter the part size in inches) Confirm the size coefficient for 3 / 4B or less, enter "1" or "real number". For fractional sizes, enter the fraction as is (3 / 4B, 1 1 / 2B). (2) Size coefficient 2: (Enter the branch size in inches) (3) Number of welds 1: (Enter the number of welds for the 1st size) (4) Number of welds 2: (Enter the number of welds for the 2nd size) (5) D x B: Calculation formula: (Pipe length (m) x size coefficient) (6) DM: Calculation formula: ((Size coefficient 1 x Number of welds 1) + (Size coefficient 2 x Number of welds 2) x quantity) Here, the number of welds is required only for valve SW type. The description "SW" is required in the remarks column or specification column. The number of welds cannot be "0". Because information cannot be obtained from the parts list, butt joints (BW) between pipes are not supported. Because information cannot be obtained from the parts list, direct connections between piping components are not supported.

[0079] <Manual Mode> An example of manual mode is shown in Figures 26 to 28. This mode is used to change the extraction settings while checking the movement of each function and data.

[0080] <Calculation of Diameter Inches (DB) & Inch Meters (BM)> As shown in Figure 26, this is used to cancel DB and BM which have been automatically added to the "Bill of Materials".

[0081] <Summary> As shown in Figure 27, a summary table is created from the [parts list] calculated in diamond inches and inch meters, and the summary sheet is automatically generated.

[0082] <Tool & Extraction Settings> Select the Tool & Extraction Settings shown in Figure 28 and set the extraction settings for cell width, AutoCAD color specification, numerical division, and up or down copy. [Cell Width] sets the spacing between characters on the top, bottom, left, and right of the character position (AutoCAD geometry: X, Y coordinates). Use the default setting (4 mm). [AutoCAD Color Setting] specifies the text color of the parts list to be extracted from the CAD drawing. Standard: No. 40 (other colors are also possible), change the color of characters that are not to be extracted. [Numerical Division] is a function that divides the length and quantity of items, such as pipe length (6.4M) or bolt set (6s), into left and right sections and stores them in separate cells, and specifies the column position. Enter the pipe length together with the length and unit, such as 6.4M. [Up or Down Copy] is a function that copies the contents of a cell, such as specifications and area, downwards, and specifies the column position.

[0083] <Other Functions> (1) [Automatic Quantity Text Splitting]: Automatic splitting function for text and units (2) [Small Diameter Actual Number]: Used when calculating DB and BM of small diameters as actual numbers (3) [Filter ON / OFF]: Used to narrow down extracted data. (4) [Clear Cell Color]: Clears the color of extracted data that has been color-coded for each file. (5) [Clear All Worksheet]: Deletes all data in the "Bill of Materials" and "Summary Table". (6) [Delete Piping Material List and Summary Table]: Deletes data other than the bill of materials. (7) [Exit Program (EXCEL)]: Exits after file output.

[0084] <Extracted Data Quality Check Function> This function automatically checks the extracted bill of materials data and displays a warning if there are any "errors" to help improve quality (see Figure 30). (1) DXF version check: Confirmation of DXF2004 format (2) Drawing frame misalignment: Prevention of misalignment of text coordinates (3) Text color layer: Whether the text to be extracted is specified (4) Numeric string identification: Checking for misalignment of text and whether it is a number (5) Blocks without names: Because there is a possibility that there are characters in the string of a composite shape (6) Missing specification name: Checking whether the specification name is present at the beginning and end of each file (7) Input error check for part name, material, etc.: Checking by sorting when outputting the report (8) Detection of extracted bill of materials string in the drawing (left side): Check when the bill of materials is separated (9) When there are few or no items: Automatically corrects coordinates and aligns the bill of materials (10) Automatic conversion of character code corruption: AutoCAD specific character codes: %%c %%D "×" etc.

[0085] Blocks without names may contain text strings within composite shapes, so an error message is displayed. Check the drawing and if there are no problems, it is considered OK.

[0086] <Rules for extracting bill of materials> (1) Do not shift the drawing frame (2) Do not use UCS (3) Do not use paper space (4) Always change the color of text that does not need to be extracted (5) Do not put two texts in one cell (6) Text should be left-aligned as a rule (7) At a minimum, the item name, size, quantity (length), and specifications are required (8) Delete unnecessary drawings (9) Always PUREGE beforehand (10) Check the position of the specification name when deleting unnecessary rows

[0087] <Forms> Figure 31 shows the final completed piping material list form. Using this form can shorten the ordering process.

[0088] <Embodiment 3: Spool Diagram (Matrix) Material Aggregation System> The spool diagram material aggregation system of Embodiment 3 is a fully automated support system that enables piping material aggregation with the aim of shortening the input time for material aggregation, standardizing aggregation work, and reducing input errors when aggregating materials from spool diagrams (DXF). Conventional input was done manually for each spool diagram, which was time-consuming and prone to input errors. Furthermore, the operation was complicated and difficult when it came to inputting and correcting coefficients and calculation formulas for diamond inches and inch meters for each job. By extracting bills of materials from multiple drawings, aggregating them, and outputting reports, while simultaneously performing a quality check of the bill of materials data, the system can be performed in an error-free manner. From the moment the program starts, it can be easily operated and processed automatically at high speed. The spool diagram material aggregation system of Embodiment 3 differs from the spool diagram material aggregation system of Embodiment 2 in that it does not use DB (diameter inch) aggregation function or BM (inch meter) aggregation function, and enables the extraction of multiple drawings and multiple files in a matrix drawing arrangement. Regarding the spool diagram material aggregation system of Embodiment 3 described below, the parts common to Embodiment 2 will be omitted from the explanation, and the differences will be explained in detail.

[0089] The main functions of this system are the same as those of the spool drawing material aggregation system of Embodiment 2, except that it does not use DB (diameter-inch) aggregation functions or BM (inch-meter) aggregation functions, and allows for the extraction of multiple files from a single file containing multiple drawings in the automatic extraction of spool drawing bills of materials created in AutoCAD (DXF). Therefore, a detailed explanation will be omitted. The advantages of this program are basically the same as those of the spool drawing material aggregation system of Embodiment 2.

[0090] Figures 32(a) and (b) show the image of extracting the bill of materials from a DWG (DXF) spool diagram. Figure 32(a) shows the case of one file with multiple drawings (normal), and Figure 32(b) shows the composite type (compatible with various drawing types in one operation). Figure 32(a) shows the matrix arrangement of the spool diagram. Figure 32(b) shows a composite type of tensor type for one file with one spool diagram (multiple files) and one file with multiple (matrix) spool diagrams (multiple files).

[0091] Figure 33 shows the spool drawing frame (template). In Figure 33, (1) one string per cell (excluding multi-line rows), (2) character coordinates (X coordinate within 323.8), (3) changed color for filled-in strings, (4) shifted filled-in strings horizontally and changed color, (5) changed the color of the numerical value of the Rev mark, (6) changed the lower reference point for adjusting the position of the product name, clarified each delimiter position and registered it in the drawing frame, and (7) changed the alignment of the drawing number from center (M) to left-center (ML) (X coordinate: 324).

[0092] <Bill of Materials Item Names and Extracted Coordinate Values> The properties of the string to be extracted are shown in Figure 34. An example of bill of materials item names and extracted coordinate values ​​is shown in Figures 35(a) and (b). The color of the properties of the string to be extracted is set to color number 40 (can be changed as needed), as shown in Figure 34. The line type, scale, and line thickness are left at their default values. The placement position of each drawing frame is not shifted. The extracted text is not made into a composite shape. Here, color number 40 means that the number of colors in the palette displayed when selecting the text color is 40. The item names are fixed (the order cannot be changed). "Y-axis bottom left" is normally 30, which is the lower limit of the drawing. "Y-axis top left" is normally "-" (extracted when multiple bills of materials exist in the upward direction). "Horizontal pitch" is set to a pitch of 500 (distance between left and right drawings).

[0093] <Explanation of each item> No.: Number of parts rows in spool diagram (automatically added) Item name: ITEM name Specification: Material DWG number: Drawing number Size: Main pipe size, branch size, bolt size, bolt length Class: Specification (if necessary) Rev: Revision (if necessary) Quantity: Pipe (M), bolt and nut (S), others (pieces) Unit: Numerical value, automatically split using string splitting function (default: automatic splitting) Remarks: Schedule, connection type, flange type, etc., special notes File name: File name of spool diagram (automatically added) Spare 1: Unused Here, the user cannot change the item name (fixed).

[0094] <Drawing Layout Configuration> The number of horizontal drawing columns is limited to a maximum of 10, while the number of vertical drawing columns is unlimited (depending on memory) (see Figure 36). Figure 37 shows important notes regarding the string format of specification names. Figure 37 shows characters that cannot be used in sheet names. For example, colons (:), yen symbols (¥), question marks (?), etc.

[0095] <Drawing Layout Image> Figure 38 shows an example of drawing layout. In the example in Figure 38, a maximum of 10 drawings are shown horizontally and there is no limit to the number of vertical columns. In reality, up to 200 vertical columns are displayed in Figure 38. A 10x10 = 100-drawing matrix layout is easy to view. Drawings do not necessarily have to be placed close together.

[0096] <Fully Automatic Mode> The following describes the process in fully automatic mode. Start the Spool Diagram (DXF) Material Summary Program Ver 9.2. EXE. An example of the startup screen is shown in Figure 39. Copy it to the JOB folder beforehand. Starting it on the server may not work depending on the security settings of each company; in that case, use it locally.

[0097] Next, select the [Browse DXF File] tab. An example of this selection screen is shown in Figure 40. Select the desired DXF file(s) (multiple selections are possible) and select [Open] (see Figure 40). The parts list for each file (color-coded by file) will be extracted and placed on the "Parts List" in Excel. The number of extracted files will also be displayed, allowing you to check for any missing or garbled characters in the extracted data. A warning will be displayed if there are any errors. Error detection criteria include: DXF version, text color, unnamed composite shapes, left-hand parts list, etc.

[0098] The data is processed by separating text and numbers, dividing by pipe size, etc., and "B x M" and "D x B" are calculated. Item names are automatically added, and the resulting values ​​are placed. An example of this placement is shown in Figure 41. The definition sheets for "B x M" and "D x B" are omitted as they are not used.

[0099] Next, select the "Fully Automatic & File Output" tab on the startup menu screen shown in Figure 42. The "Summary Table" and "Piping Material Table" will be automatically created all at once. An example of this is shown in Figure 43. Confirm that the "Summary Table" and "Material Material Table" have "B x M" and "D x B" automatically calculated (see Figure 44), and that the reports are further divided into sheets by "Material". The display order of the [Product Name] is determined by the sort number, and if there is no sort number, it will be displayed at the end.

[0100] The extracted "Parts List" sheet and the summarized "Piping Materials List" sheet are output as files, and this program is then disconnected. This completes the series of material summaries. Confirm that three files (Parts List, Piping Materials List, and Definition Sheet) have been output. The files are output to the same folder as when the drawings were imported.

[0101] <Definition Setting (Definition Sheet)> Define the size, product name, sort number, and number of welds. An example of a definition sheet is shown in Figure 45. Some excerpts of the pipe sizes (A, B) and nominal names are the same as in Embodiment 2, so the explanation is omitted and refer to the explanation in Embodiment 2 (Figure 23).

[0102] <Items and Sort No. (Partial Excerpt)> The items and sort no. (partial excerpt) are the same as in Embodiment 2, so the explanation is omitted and refer to the explanation in Embodiment 2 (Figure 24).

[0103] <Number of Welds> The input for the number of welds is the same as in Embodiment 2, so the explanation is omitted and refer to the explanation in Embodiment 2 (Figure 25).

[0104] <Manual Mode> An example of manual mode is shown in Figures 46 to 53. This is used when changing extraction settings while checking the movement of each function and data. Figure 46 shows an example of automatic deletion of class names. If there are class names in the "Bill of Materials," they will be automatically deleted when the bill of materials is extracted. In Figure 47, confirm that the class part of the bill of materials is deleted when "Automatic Aggregation & File Output" is performed. As shown in Figure 48, if "Extraction Check" is enabled, the bill of materials will be read as is without formatting adjustments. Figure 49 shows the results of the bill of materials extraction. In Figure 49, the bill of materials is extracted in its state before automatic formatting adjustments (as is from the CAD bill of materials). Confirm that there are no blank spaces in the items, multi-line text, and quantities are not split. If you select the "Format Adjustment 1" tab shown in Figure 46, unnecessary rows will be deleted and multi-line text will be converted to a single line, as shown in Figure 50. As shown in Figure 51, if you select the "File Input / Output" tab, the [Bill of Materials Output] tab (output of extracted data (necessary as a backup just in case)) and the [Piping Material List Output] tab (output of the final report to be submitted) will be displayed. Additionally, the [Definition Sheet Output] tab requires the output of an environment configuration file (product name, DB coefficients, etc.) as a backup, just in case. As shown in Figure 52, the file will be output when a file name is entered.

[0105] <Forms> The final completed piping material list is shown in Figure 53. Using this form can shorten the ordering process.

[0106] 1 Spool drawing material aggregation and list creation system 11 Drawing breakdown means 12 Spec assignment means 13 Material aggregation means 14 Drawing management means 20 Computer 21 Control unit (CPU) 22 Spool drawing material aggregation software 23 DXF file 24 Information acquisition unit 25 Keyboard 26 Storage unit 27 Display 28 Printer 29 Extraction program 30 Check program 31 BM / DB calculation program 32 Aggregation program 33 Report program 101 Drawing breakdown processing step for drawing matrix arrangement 102 2D (two-dimensional) spool drawing spec assignment processing step 103 Spool drawing piping material aggregation processing step 104 Piping material aggregation table creation processing step 105 Construction volume calculation (BM, DB) processing step 106 Spool drawing management list creation processing step 201 Pre-preparation from customer materials 202 Spool drawing creation 203 DWG to DXF Conversion 301 Spool Diagram Material Summary Software 302 Reading Multiple DXF Files 303 Extracting DXF Files 304 Checking Extracted Data 305 Calculating BM / DB 306 Calculating Summary Results (by Spec) 307 Creating Reports 308 File Output

Claims

1. A spool drawing material aggregation (Material Take Off), construction volume calculation, and list creation system characterized by comprising: a drawing decomposition means that decomposes spool drawing data arranged in a drawing matrix into one drawing file based on multiple spool drawing data created by CAD software, each containing bill of materials data for piping used in a plant; a specification assignment means that extracts bill of materials data with the material and remarks columns left blank from the multiple spool drawing data decomposed by the drawing decomposition means, compares the extracted bill of materials data with the specifications of pre-prepared specification table data, assigns the material and remarks to the blanks, and returns the updated bill of materials data to the multiple spool drawing data; a material aggregation means that aggregates multiple part data contained in the bill of materials data extracted from the multiple spool drawing data including the bill of materials data updated by the specification assignment means and generates a report of part aggregation data; and a drawing management means that automatically creates a drawing management list from the multiple spool drawing data.

2. The material aggregation means comprises: an extraction program that extracts each bill of materials data from each spool drawing data created by the CAD software in DXF file format; a check program that checks each of the multiple parts data included in each bill of materials data extracted by the extraction program; a BM / DB calculation program that calculates the welding amount for each part data by calculating inch meters from the diameter and length of the piping used in the plant and calculating diamond inches from the diameter of the piping used in the plant and the number of weld locations; an aggregation program that aggregates each part data, including the inch meter data and diamond inch data obtained by the BM / DB calculation program, for each specification of the piping to create the parts aggregation data; and a reporting program that reports the parts aggregation data created by the aggregation program.

3. The spool diagram data includes drawing frame data and drawing number / revision number data for each spool diagram data, and coordinates and text color layer data for each part data in each parts list data, and the check program checks the positional misalignment of the drawing frame data, revision number, and DXF file version for each spool diagram data, in addition to checking the part name, numerical value, position of piping specifications, text color layer, and blank cells associated with each parts list data, as described in paragraph 2.

4. The spool drawing material aggregation (Material Take Off), construction volume calculation, and list creation system according to claim 2, characterized in that each component data includes additional component data from an out-of-frame table added outside the drawing frame of the corresponding spool drawing data, and the extraction program also extracts the additional component data.

5. The spool diagram material aggregation (Material Take Off), construction volume calculation, and list creation system according to claim 2, characterized in that each of the spool diagram data targeted for extraction by the extraction program is obtained by first converting the multiple spool diagram data in incompatible file formats into the DXF file format.

Images