JP2005050325A - Method for extracting character data on drawing, method for forming quantity account, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a method for extracting character data on a drawing, which can efficiently and precisely perform a work for extracting character data necessary for a quantity account from the drawing to form the quantity account. <P>SOLUTION: An original drawing file 30, a definition forming drawing file 31, and an attribute forming drawing file 32 are read, a definition file 31 recording the line number of character data to be extracted is formed from the definition forming drawing file 31, and an attribute file 32 recording the order of character data to be extracted is formed from the attribute forming drawing file 32. On the basis of the data of the definition file 33, character data to be extracted are extracted from the original drawing file 30 and recorded to form a quantity data TXT file 35. The character data recorded in the quantity data TXT file 35 are sorted on the basis of the attribute value recorded in the attribute file 32 to form a quantity data CSV file 36 in which the character data recorded in the original drawing file 30 are extracted/classified. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention extracts a necessary character data on a drawing from a drawing file and creates a quantity calculation document, a character data extraction method on a drawing, a quantity calculation preparation method, and these methods executed on a computer. It is related to the program to make it.

  It is necessary to create a design drawing when performing civil engineering work or construction work. On the other hand, character data such as length, area, quantity, etc. of various materials necessary for civil engineering work, etc. is extracted from the created design drawings. It was also necessary to prepare a quantity calculation sheet that summarizes the types, quantities, and expenses of materials as a list. Here, usually, the quantity calculation sheet is created by a design consultant contracted by a design consultant, and the design drawing is created using a CAD application or the like. At the same time, the quantity calculation sheet is created using the design drawing. Delivered to the orderer with design drawings.

  By the way, the operation of creating a quantity calculation sheet from a drawing described on a paper medium has been performed manually. In other words, character data related to the type and quantity of materials required for construction is extracted from the various character data described on the drawing, and the extracted character data is sorted by type of material and then directly into paper. Or by inputting the extracted character data into a spreadsheet software on a computer and rearranging the data according to the type of the material by the sort function.

However, as described above, the method of manually extracting, classifying, and rearranging the data necessary for the quantity calculation sheet to create the quantity calculation sheet is very complicated, and the extraction process of the necessary character data is very complicated. It took a great deal of time and effort to create. In addition, omission of character data, miscalculation, omission of transcription, and error in writing were likely to occur.
In addition, if a minor correction / change occurs in the text data on the drawing after the quantity calculation sheet has been created, the quantity calculation sheet must be re-created according to the correction / change. To correct the book, work such as rearranging materials again by type is necessary, and this work is also complicated.

  The present invention has been made in view of the above-described problems, and its purpose is to efficiently and accurately perform the work of extracting the character data necessary for the quantity calculation sheet from the drawing and creating the quantity calculation sheet. Provides a text data extraction method, quantity calculation creation method and program that can be easily performed, and even if the text data on the drawing is subsequently modified or changed There is to do.

  In order to solve the above problems, the present invention is a character data extraction method for drawings, comprising: a first file in which drawing data including character data is recorded; and a character data recorded in the first file. Of these, the second file in which the character data to be extracted is replaced with a character string that can be distinguished from other character data and drawing data, and the character data to be extracted from the character data recorded in the first file are extracted. A step of reading a third file replaced with a character string representing the order in the character data to be read into a computer, and drawing data including the character data recorded in the second file in a source text list format By searching an identifiable character string replacing the character data to be extracted from the representation, a source text list of the character data to be extracted is retrieved. A step of creating a fourth file in which line numbers are extracted and recorded, and drawing data including character data recorded in the third file in a source text list format. Creating a fifth file in which the character string representing the sequence specified by the extracted line number is extracted and recorded; and drawing data including the character data recorded in the first file in a source text list format A step of creating a sixth file in which character data specified by a line number extracted in the fourth file is extracted from the representation, and recording the character data recorded in the sixth file; Step for creating a seventh file that is sorted and recorded using the information of the character strings representing the order recorded in the fifth file. When, characterized by comprising the step of outputting at least the seventh file from the computer, the.

“Character data” here refers to characters on the drawing that indicate the names of buildings, constructions, places, etc., characters that indicate the names and shapes of various materials, and the length, area, quantity, etc. of various materials. It is a concept that includes data such as numerical values to be expressed and units associated therewith.
“Drawing data including character data” is a concept indicating drawing data in which character data such as names of various materials are described on a diagram represented by a diagram.
The “source text list” is a concept indicating a list format in which character data, diagram data, and the like on the drawing are expressed in source text and line numbers giving position information are added.

  The present invention also relates to a method for creating a quantity calculation document, wherein a first file in which drawing data including character data is recorded, and character data to be extracted from the character data recorded in the first file are different. Of the character data to be extracted and the character data to be extracted among the character data recorded in the first file. A step of reading a third file replaced with a character string representing an order into a computer, and extracting drawing data including character data recorded in the second file from a source text list format; By searching for an identifiable character string replacing the character data to be extracted, the line number in the source text list of the character data to be extracted is extracted. Specify the line number extracted in the fourth file from the step of creating the recorded fourth file and the drawing data including the character data recorded in the third file in the source text list format. A step of creating a fifth file in which the character string representing the order is extracted and recorded, and drawing data including character data recorded in the first file in a source text list format, Creating a sixth file in which character data specified by the line number extracted in the fourth file is extracted and recording the character data recorded in the sixth file in the fifth file; Creating a seventh file that has been sorted and recorded using the information of the character strings representing the order in which they are recorded, and recorded in the seventh file. The recorded character data is recorded in the quantity calculation file based on the link information of the quantity calculation file in which link information with the character data previously recorded in the seventh file is recorded. The method includes the steps of creating a quantity calculation form from which character data on the drawing of the file is extracted, and outputting at least the quantity calculation form from a computer.

  The present invention also relates to a method for creating a quantity calculation document, which includes a step of reading a drawing file in which drawing data including character data is recorded into a computer, and a classification type name for classifying the character data read into the computer in advance. A step of calling at least one set of classification type list, character data to be extracted selected from the character data, and a classification type name selected from the classification type list, and a set of data rows A plurality of sets of data rows, creating a data list in which the plurality of sets of data rows are put together as a data column, and character data to be extracted included in the data list The quantity calculation file is based on the link information of the quantity calculation file in which the link information based on the classification type name is recorded in advance. And a step of generating a quantity calculation form in which character data on the drawing of the drawing file is extracted by recording in a predetermined location of the drawing file, and a step of outputting at least the quantity calculation form from a computer. To do.

  In addition, the present invention is a program for causing a computer to execute the character data extraction method or the quantity calculation document creation method on the above drawings.

  According to the first aspect of the present invention, the first file in which the drawing data including the character data is recorded is read into the computer, the character data on the drawing is extracted, and the seventh file is created. The operation of extracting the character data on the drawing can be performed efficiently and accurately, and there is an effect that there is no possibility that an extraction omission or a sorting error occurs in the extraction / sorting process.

  According to the second aspect of the present invention, since the character data recorded in the seventh file is recorded in the link destination of the quantity calculation document file in which the link information is recorded in advance, the character data in the drawing file is minimal. When the correction occurs, there is an effect that a quantity calculation sheet reflecting the correction of the character data can be easily created.

  According to the third aspect of the present invention, the character data to be extracted selected from the character data and the classification type name selected from the classification type list are associated with each other and based on the classification type name in advance. Since the link information of the quantity calculation file with the link information recorded is recorded at a predetermined location in the quantity calculation file, the character data to be extracted from the character data on the drawing is accurately and reliably determined in a simple procedure. It can be reprinted at a predetermined place on the calculation form. Therefore, there is an effect that it is possible to create a quantity calculation sheet free from omissions and errors in a simple procedure.

  Hereinafter, practical examples of the present invention will be described in detail with reference to the drawings.

  FIG. 1 shows a configuration example of hardware for executing a character data extraction method and a quantity calculation document creation method on a drawing according to the present invention. As shown in the figure, this computer system (hereinafter referred to as “quantity calculation document creation system”) 1 is a main control unit (hereinafter referred to as “CPU”) that controls and controls the entire quantity calculation document generation system 1. 10 is connected to the storage device 20. The storage device 20 includes an OS (Operating System) 21, a CAD (Computer Aided Design) application 23, a quantity calculation document creation program 24 according to an embodiment of the present invention, and various programs 22 such as a spreadsheet program 25, A file 26 that can be processed by the program 22 is stored. Further, the CPU 10 displays a memory 12 used as a work area, an input device 11 composed of a pointing device such as a keyboard and a mouse, a monitor that displays the contents of the file 26 processed by the program 22, the execution status of the processing, and the like. An apparatus 13 and an output apparatus 14 for outputting a file 26 created by the program 22 are connected.

  In the above quantity calculation document creation system 1, the CPU 10 calls a control program such as the OS 21 stored in the storage device 20 and various programs 22 such as the quantity statement creation program 24 based on a command input from the input device 11. And execute. Then, the file 26 is created / edited while the execution status is displayed on the display device 13, and is output to the outside from the output device 14 or stored in the storage device 20 according to the command.

  FIG. 2 shows a schematic flow of a procedure for creating a quantity calculation document (Example 1) according to an embodiment of the present invention. Also, a detailed procedure flow for each step of FIG. 2 is shown in FIGS. FIG. 4 shows files that are sequentially created by executing this procedure. Hereafter, the flow of the quantity calculation document preparation procedure shown in FIGS. 2 and 3 will be described in detail for each step.

[STEP1]
As shown in FIG. 5A, the CPU 10 executes the quantity calculation document creation program 24 and serves as a base diagram for creating the quantity calculation document provided from the orderer (requester) of the quantity calculation document creation. The original drawing file 30 (first file) in which the numerical data representing the name of the construction site, the names of various materials, the lengths of the various materials, etc., and the accompanying data, etc., is written on the drawing. Read into the creation system 1 (ST1-1). Here, a drawing file created using the CAD application 23 will be described as an example of the original drawing file 30 provided from the orderer. As an example of the file created by the CAD application 23, there is a DXF (Data exchange Format) format file that is a data file format used in Autodesk's AutoCAD (trademark).

  Next, the definition creation drawing file 31 (second file) shown in FIG. 5B is read into the quantity calculation document creation system 1 (ST1-2). The definition creation drawing file 31 is created in advance by copying the original drawing file 30 to create the same file separately, and processing it by the CAD application 23. That is, among the character data on the original drawing displayed by the CAD application 23, the character data that the operator determines to be necessary in the quantity calculation document is selected, and the selected character data can be distinguished from other data. This is a process of replacing with a column. Here, an example in which character data to be extracted is replaced with a character string ZZZ as shown in FIG. The character string to be replaced is a character string that can be distinguished from the character strings of other lines when drawing data including character data recorded in a DXF format file is displayed in the source text list format as described below. Any character string can be used.

  Further, the attribute creation drawing file 32 (third file) shown in FIG. 5C is read into the quantity calculation document creation system 1 (ST1-3). The attribute creation drawing file 32 creates a copy of the original drawing file 30 and creates another one of the same files. The character data (in the quantity calculation sheet selected by the operator from the character data on the drawing) ( A number indicating the order (attribute) in which the necessary character data is recorded in the quantity data CSV file 36 described below and / or the same character data selected by the operator in the definition creation drawing file 31) It is created by replacing with a symbol or the like (in this embodiment, only a number). That is, in FIG. 5C, a number string such as 1, 2, 3, etc. is a symbol representing the order (attribute) after replacement with the character string to be extracted. In this embodiment, as described above, necessary character data is replaced by only numbers, but it may be replaced not only by numbers but also by a combination of numbers and characters (example: A-001). For example, if there are terrestrial blocks and fences at a plurality of locations in the original drawing, for example, the terrestrial blocks are replaced with A-001, A-002,... And the fences are replaced with B-001, B-002,. To do. By replacing in this way, in the following quantity data CSV file 36, it is possible to display in alphabetical order at positions where ground blocks and fences related to each other are grouped together.

  As described above, the original drawing file 30, the definition creation drawing file 31, and the attribute creation drawing file 32 are read and stored in a state that can be processed by the quantity calculation document creation program 24.

[STEP2]
Next, a definition file 33 (fourth file) and an attribute file 34 (fifth file) are created from the definition creation drawing file 31 and the attribute creation drawing file 32 read in STEP 1. More specifically, first, drawing data including character data recorded in the definition creation drawing file 31 is expressed in a source text list format as shown in FIG. A file created by retrieving a line containing a character string of ZZZ from the text list (line marked in the figure), extracting the line number, and recording it is defined as shown in FIG. Let it be a file 33 (ST2-1). Here, the source text list is a list format in which the diagram data (line thickness, length information, etc.) and character data on the drawing are replaced with text data, and line numbers are assigned to the text data. FIG. 6B shows a part of the source text list.

  Subsequently, the CPU 10 extracts the character string of the line number specified by the line number extracted by the definition file 33 from the attribute creation drawing file 32 expressed in the source text list format (FIG. 6C). An attribute file 34 in which the contents are recorded is created (ST2-2). An example of the created attribute file 34 is shown in FIG. In this case, the order (attributes) is assigned numerically to the data extracted by the definition file 33 after replacing with the character string ZZZ. That is, according to the attribute file 34, the order (attribute) in which the character data extracted by the definition file 33 is to be displayed can be known. The definition file 33 and the attribute file 34 are both TXT format files.

[STEP3]
Next, the CPU 10 reads the quantity calculation form template file 37 created in advance into the quantity calculation form creation system 1 so that it can be processed by the quantity calculation form creation program 24, and registers the file name. As the quantity calculation template file 37 read in STEP 3, as shown in FIG. 8, a file created by a form processing application (spreadsheet program) is used. As an example of this file, there is an XML format file that is a data format used in Microsoft Excel (trademark). The quantity calculation form template file 37 describes items necessary for the quantity calculation form in advance, and the character data extracted from the design drawing can be pasted to a predetermined location suitable for the item to which the character data belongs. It is a file created as follows. That is, in STEP 3, the quantity calculation form template file 37 is read into the quantity calculation form creation system 1 (ST3-1) and registered with a file name so that it can be called and edited by the quantity calculation form creation program 24 (ST3-2). . This file name is preferably registered with a construction name so that it can be called in association with the original drawing file 30 and the definition file 33 and attribute file 34 created from the original drawing file 30.

[STEP4]
Subsequently, the CPU 10 executes the quantity calculation document creation program 24, and the source of the original drawing file 30 based on the line number information specified in the definition file 33 shown in FIG. Character data to be extracted is extracted from the text list (FIG. 6A), and a quantity data TXT file 35 (sixth file) as shown in FIG. ST4-1). Next, the information on the attribute values recorded in the attribute file 34 shown in FIG. 7 (b) that has been created and read in the character data of the created quantity data TXT file 35 (in the case of FIG. 7 (b)). Are sorted according to the order of each data). As a result, the order of the lines of the character data recorded in the quantity data TXT file 35 is changed to the item order for each related one, and the quantity data CSV file 36 (seventh file) shown in FIG. 7D is created. (ST4-3). At this time, in the quantity data CSV file 36, as shown in FIG. 7 (d), the characters, numbers, and symbols described in each line replaced in the order of items are divided and separated by commas on the same line. It is written together. That is, first, the character portion and the mathematical expression portion are divided, and further, numbers and symbols are divided and separated by commas, are written together on the same line, and stored as a part of the quantity data CSV file 36. As a result, the quantity data CSV file 36 becomes a CSV (Comma Separated Value) format file, and when read by a spreadsheet program such as Excel, the character / number strings in the data list separated by commas are independent of each other. Will be read to fit in the selected cell.

  Subsequently, the quantity calculation template file 37 registered in advance in STEP 3 is read by designating the file name of the quantity calculation template file 37 and displayed on the display device 13 (ST4-4). The quantity calculation template file 37 read on the display device 13 is displayed as a worksheet having cells, which is the display format of the spreadsheet program 25, as shown in FIG. The previously stored quantity data CSV file 36 is similarly read out and displayed side by side with the worksheet of the quantity calculation template file 37 on the display device 13 as shown in FIG. 8 (ST4-5). The quantity data CSV file 36 is also displayed on a worksheet in which the recorded data is written in each cell.

  An operator who viewed the data recorded in the quantity data CSV file 36 and the quantity calculation template file 37 displayed side by side on the display device 13 as described above receives the input device 11 in the quantity calculation document creation system 1. The command for pasting the character data of the quantity calculation form CSV file 36 by designating a predetermined cell of the quantity calculation form file 37 is input. In response to this input command, the CPU 10 pastes the data in the quantity data CSV file 36 with link information attached to the designated cell in the quantity calculation template file 37 (ST4-6). At this time, a common color is given to the predetermined data cells of the two files so that the burden of the work of designating the cell to which the data is pasted by the operator is reduced, or it becomes a mark. It is desirable to add a function such as adding a symbol to the quantity calculation document creating program 24. As described above, the quantity calculation file 38 as shown in FIG. 9 with the link of the character data of the quantity data CSV file 36 is created. Then, the quantity calculation file 38 is stored in the storage device 20, or is output from the output device 14 as necessary (ST4-7). Through the above steps, a quantity calculation file 38 created by extracting necessary character data from the original drawing file 30 is completed.

  After creating the quantity calculation file 38 according to the above procedure, create a quantity calculation file 38 that reflects the correction data when minor corrections / changes occur in the text data on the original drawing file 30. A method of redoing will be described. That is, in this case, an original drawing file 30 ′ in which the character data on the drawing is corrected, a definition file 33 created earlier, and an attribute file 34 are prepared, and these three files are prepared by the quantity calculation document creation program 24. The processing of STEP 4 that has been read and executed in the previous procedure for creating the quantity calculation sheet may be executed again. At this time, since the data recorded in the quantity calculation file 38 is linked with the data in the quantity data CSV file 36 by the processing of ST4-6 performed earlier, the modified original drawing file 30 ' When the quantity data CSV file 36 is created, the corrected data is automatically placed at the position where the corresponding data of the original drawing file 30 before correction of the quantity calculation file 38 linked with the CSV file 36 is pasted. To create a new quantity calculation file 38 '. As a result, in this case, the quantity calculation file 38 'reflecting the correction data on the drawing is automatically created without having to receive the pasting instruction from the operator of ST4-6.

  Next, a procedure for creating a quantity calculation document according to another embodiment of the present invention (Example 2) will be described. In the present embodiment, the configuration of the quantity calculation document creation system 1 that executes the quantity calculation document creation method and the role of each component are the same as those in the first embodiment, and thus the description thereof is omitted. FIG. 10 is a diagram illustrating a schematic flow of a procedure for creating a quantity calculation document according to the present embodiment. Hereinafter, the flow of the procedure for creating the quantity calculation sheet will be described in detail for each step.

[STEP 11]
The CPU 10 reads the original drawing file 40 shown in FIG. 11, which is the original drawing for creating the quantity calculation document, into the quantity calculation document creation system 1. The original drawing file 40 is a drawing file created using the CAD application 23 in the same manner as the original drawing file 30 read in the quantity calculation document creation procedure of the first embodiment, and the name of the construction place and the names of various materials on the drawing. , And numerical values representing dimensions and quantities of various materials and character data such as units accompanying the numerical values. The original drawing file 40 read into the quantity calculation document creating system 1 is called by the CAD application 23 and displayed on the screen of the display device 13 as shown in FIG. For the sake of illustration, only a part of the original drawing file 40 is shown in FIG.

[STEP 12]
Subsequently, the quantity calculation document creation program 24 is activated with the original drawing file 40 displayed. FIG. 12 shows a display window 41 when the quantity calculation document creation program 24 is activated. The display window 41 can be displayed on the screen simultaneously with the original drawing file 40 displayed by the CAD application 23. Here, in the quantity calculation document creation program 24, the construction method name list in which construction method names actually performed at the construction site such as “opening” and “assembly” are listed in advance, and the materials used in each of these construction methods are listed. A classification name list in which classification names such as “pipe number” and “section extension”, such as names and dimensions thereof, are read and registered. As shown in the figure, a display window 41 that appears when the quantity calculation document creation program 24 is started is provided with a plurality of construction method name tabs 42 for displaying construction methods based on the construction method name list. Further, the type name is displayed as a type list 43 belonging to the method name tab 42 when any one of the method name tabs 42 is selected. Reference numeral 44 denotes a color change command for changing the color of the character data already acquired from the original drawing file 40. The character data on the drawing already acquired is made different from the color of other unacquired character data. It makes it in an identifiable state.

  Next, when the operator selects character data to be extracted into the quantity calculation sheet from the character data on the original drawing file 40, the quantity calculation document creating program 24 causes the character data and the related drawing data to be extracted. Character data properties such as coordinate position information and color information are acquired. Here, it is set so that the character data is selected and acquired by clicking the character data displayed on the drawing. FIG. 13 is an enlarged view of portion A of the original drawing file 40 shown in FIG. Now, a case where “90.00 m” character data surrounded by a dotted line in FIG. 13 is selected will be described. When the character data is selected, the character data is transferred to the attribute value column 45 of the display window 41. The character data properties acquired at the same time are stored in association with the character data without being displayed.

  Subsequently, when the method name tab 42 to which the character data described in the attribute value column 45 belongs is clicked and selected from the method name tabs 42 displayed in the display window 41, the method belongs to the selected method. A type list 43 is displayed. In FIG. 12, the method name tab 42 of the excavation DIS method is selected, and the type list is displayed. Then, by selecting “section extension” that is the type name corresponding to the character data in the attribute value column 45 from the type list 43, the previously selected attribute value “90.00 m” and the construction method are selected. The name “cutting DIS” and the type name “section extension” are associated with each other and are listed in the data list display column 47 as a set of data rows 46. In this way, the character data on the drawing, the construction method name and the classification name into which the character data is classified are associated with each other and registered as a set of data rows.

  For other unacquired character data on the drawing, by repeating the above step 12, the character data, the method name, and the type name are associated with each other to form a set of data lines, and a data list display field 47. In this way, it belongs to the same construction span (here, one section that divides a specific portion on the drawing, for example, between adjacent manholes is called a “span”, and each span is numbered to be distinguished). All the character data to be extracted in the quantity calculation sheet among the character data is selected in order, so that a data list 48 in which these data rows 46 are listed as a list in the data list display column 47 as shown in FIG. Is created. When acquiring a plurality of character data on the drawing, the acquisition order is not particularly limited as long as it is acquired within the same construction span, and any order may be used. Further, by operating the span switching button 51, the data list 48 can be created separately for each construction span.

[STEP 13]
On the other hand, a quantity calculation template file 55 as shown in FIG. 15 created in advance by the spreadsheet program 25 is registered in the quantity calculation preparation program 24. As with the quantity calculation template file 37 of the first embodiment, the quantity calculation template file 55 describes items necessary for the quantity calculation in advance, and sets character data extracted from the original drawing as items to which the character data belongs. It is a file created so that it can be pasted to a predetermined location that matches. That is, in STEP 13, the quantity calculation form template file 55 is read into the quantity calculation form creation system 1 and registered with a file name so that it can be called and edited by the quantity calculation form creation program 24. It is desirable to register the file name with a construction subject.

[STEP14]
Next, when the quantity calculation creation button 49 is pressed in the display window 41 of FIG. 14 with the data list 48 being posted in the data list display field 47, the quantity calculation creation program 24 starts up the spreadsheet program 25. Then, the creation of the quantity statement is executed. The procedure will be described in detail below. First, character data is extracted from the previously created data list 48 belonging to each construction span and sorted based on the association with the type name, so that the character data belonging to the same construction span is arranged horizontally. It is converted to the character data line described in the state. The result of the sorting process is output as a quantity data CSV file 57 shown in FIG. This figure shows the quantity data CSV file 57 displayed in the display format of the spreadsheet program 25. In the quantity data CSV file 57, the type name is described in the first line, the character data belonging to one span is arranged in the second line in a position corresponding to the type name in the first line, and the third line. The character data belonging to two spans are listed and arranged at positions corresponding to the type names on the first line. Hereinafter, when there is another construction span, the character data belonging to the construction span is listed and listed for each type name. This quantity data CSV file 57 is created individually for each construction method.

  After creating the quantity data CSV file 57, the quantity calculation document creation program 24 calls the previously registered quantity calculation template file 55. Linkage information with a predetermined cell in which the character data of the quantity data CSV file 57 is written in advance in a predetermined cell among the cells 56 of the quantity calculation template file 55, and the quantity data CSV The character data described in the file 57 is created so as to be described in a predetermined cell of the quantity calculation template file 55. Based on this linking information, the character data of the quantity data CSV file 57 is reprinted in a predetermined cell 56 of the quantity calculation template file 55. As described above, the quantity calculation file 58 as shown in FIG. 17 to which the character data of the quantity data CSV file 57 is pasted by link is created. The quantity calculation document file 58 is stored in the storage device 20 or output from the output device 14 as necessary. Through the above steps, a quantity calculation file 58 created by extracting necessary character data from the original drawing file 40 is completed.

  In other words, in this procedure, the extracted character data is transferred to the quantity data CSV file 57 by link information based on the association with the construction method name and the type name, and further attached based on the association between the character data and the construction method name and the type name. The character data of the quantity data CSV file 57 is transferred to the quantity calculation template file 55 based on the linked cell information. In this way, a desired quantity calculation document 58 from which character data on the drawing is extracted is created.

  In the above description, the method for creating the quantity calculation file 58 by transferring the character data posted in the data list 48 to the quantity calculation template file 55 via the quantity data CSV file 57 has been described. The quantity calculation file 58 can be created without creating the file 57. In that case, link information with the character data listed in the data list 48 is added to a predetermined cell 56 of the quantity calculation template file 55 in advance based on the association with the construction method name and the type name. When the quantity calculation document creation button 49 is pressed, text data may be linked and pasted directly from the data list 48 to a predetermined cell 56 of the quantity calculation template file 55.

  After the quantity calculation file 58 is created according to the above procedure, when a minor correction / change occurs in the character data on the drawing of the original drawing file 40, the quantity calculation file 58 reflecting the correction data is created. A method of repairing will be described. First, an original drawing file 40 ′ (not shown) whose character data has been corrected / changed is read into the quantity calculation document creation system 1 and displayed on the CAD application 23. In this state, when the quantity calculation document creation program 24 is started, the character data on the original drawing file 40 that has already been captured in the previously executed quantity calculation document creation procedure, the properties related to the character data, and the newly read data A comparison operation is performed on the character data on the original drawing file 40 'and the properties of the character data. As a result, if there is a change in the character data that has already been acquired, the character data after the change is newly acquired, and the procedure of STEP 12 described above is executed again, as shown in FIG. A data row 46 ′ in which the character data is associated with the construction method name and type name is displayed in the data list display field 47. At this time, an identification symbol (indicated by “*” in the drawing) is added to the data row 46 ′ after the change so that the data row 46 can be distinguished from the data row 46 before the change. In this way, a data list 48 'reflecting the correction data of the original drawing is created.

  If the quantity calculation creation button 49 is pressed in this state, the above steps 13 and 14 are executed again based on the data list 48 ', and the quantity calculation file that reflects the correction / change data of the original drawing file 40' is reflected. (Not shown) is created.

  It is desirable that the drawing file used for the above-mentioned quantity calculation document creation method, the created quantity calculation file, and the like are exchanged between the orderer and the quantity calculation document creator via a communication means such as the Internet. Hereinafter, the procedure will be described with reference to FIG. First, the original drawing file 30 created by the orderer using the CAD application and the quantity calculation form template file 37 created using the spreadsheet program are attached from the orderer side terminal 61 to the quantity calculation form creator side terminal 62 by e-mail or the like. Then, it is sent via the Internet 65 (ST5-1). The quantity calculation document creator side terminal 62 receives the original drawing file 30 and the quantity calculation template file 37 (ST5-2), reads these files into the quantity calculation document generation system 1, and receives the quantity calculation document generation program 24. The above-described processing from STEP1 to STEP4 is executed (ST5-3). As a result, the quantity calculation file 38 is completed. The quantity calculation document creation company side terminal 62 attaches the created definition file 33, attribute file 34 and quantity calculation form file 38 to an e-mail or the like and sends it to the orderer side terminal (ST5-4). 61 receives those files (ST5-5).

  The orderer side terminal 61 can output and use the quantity calculation file 38 by reading it into its own computer system 64 having the same configuration as the quantity calculation creation system 1 shown in FIG. 1 (ST5-). 6). In addition, when minor correction / change occurs in the character data on the drawing of the original drawing file 30, it is not necessary to transfer the file again with the quantity calculation maker terminal 62 by the method described below. The computer system 64 can create the quantity calculation file 38 reflecting the correction.

  That is, first, a quantity calculation document creation side terminal 62 distributes a simplified version of the quantity calculation document creation program (hereinafter referred to as a “simplified version program”) 24 ′ in which the function of the quantity calculation document creation program 24 is limited (ST5). -7) The orderer side terminal 61 obtains this simplified version program (ST5-8). The simplified version program 24 ′ is placed on a server or the like on the Internet 65 via the quantity calculation document creator side terminal 62, and is acquired by the orderer terminal 61 downloading it. It should be noted that what is recorded on a medium such as a CD-ROM may be distributed and read directly into the computer system 64 without going through a terminal. This simple version program 24 ′ may be any program having at least a function capable of executing the processing of STEP 4 in the above-described quantity calculation document creating method. Next, the simplified version program 24 'is read into the computer system 64 on the orderer side (ST5-9). Then, the simplified version program 24 ′ is executed by the computer system 64 to read the original drawing file 30 ′ in which the character data on the drawing is corrected, the definition file 33 and the attribute file 34 received earlier, and the processing of STEP 4 (above (Procedure for creating a quantity calculation sheet reflecting the corrected data) (ST5-10). As a result, it is possible to create a quantity calculation file 38 'reflecting the character data corrected by the computer system 64 on the orderer side.

  Here, as an example of exchanging files via communication means such as the Internet, the method for creating the quantity calculation sheet according to the first embodiment has been described as an example, but the procedure for creating the quantity calculation sheet according to the second embodiment is similarly applied. It can be executed via communication means.

  In the above embodiment, a file created by a CAD application is described as an example of a drawing file. However, the drawing file used in the present invention is not limited to this, character data is described on the drawing, and As long as the source text list of drawing data including character data can be referred to, the file may be created by another application.

  Although the embodiments of the present invention have been described above, the present invention is not limited to the above-described embodiments, and various modifications can be made within the scope of the technical idea described in the claims and the specification and drawings. Is possible.

It is a figure which shows one structural example of the quantity calculation document creation system 1 which implements the character data extraction method on a drawing concerning this invention, and a quantity calculation document creation method. It is a figure which shows the general | schematic flow of the character data extraction method on the drawing concerning this invention, and a quantity calculation document preparation method (Example 1). It is a flowchart which shows the detailed procedure of STEP1. It is a flowchart which shows the detailed procedure of STEP2. It is a flowchart which shows the detailed procedure of STEP3. It is a flowchart which shows the detailed procedure of STEP4. It is a figure which shows the file produced by the character data extraction method on the drawing concerning this invention, and a quantity calculation document creation method. It is a figure which shows the original drawing file. It is a figure which shows the drawing file 31 for definition creation. It is a figure which shows the drawing file 32 for attribute creation. FIGS. 6A, 6B, and 6C are diagrams showing a part of the data of the original drawing file 30, the definition file 31, and the attribute file 32 displayed in the source text list. It is a figure which shows the data of the definition file. It is a figure which shows the data of the attribute file. It is a figure which shows the data of the quantity data TXT file. It is a figure which shows the data of the quantity data CSV file. It is a figure which shows an example which displayed the content of the quantity data CSV file 36 and the quantity calculation form template file 37 on the display apparatus 13. FIG. It is a figure which shows an example of the quantity calculation document. It is a figure which shows the general | schematic flow of the quantity calculation document preparation method (Example 2) concerning this invention. It is a figure which shows the original drawing file. It is a figure which shows the display window 41 of the quantity calculation document preparation program 24. FIG. It is A partial enlarged view of FIG. It is a figure which shows the display window 41 of the quantity calculation document preparation program 24. FIG. It is a figure which shows an example of the quantity calculation form template file 55. FIG. It is a figure which shows an example of the quantity data CSV file. It is a figure which shows an example of the quantity calculation document file. It is a figure which shows the display window 41 of the quantity calculation document preparation program 24. FIG. It is a figure which shows an example of the procedure which exchanges a file via the internet and produces a quantity calculation document by the quantity calculation document preparation method concerning this invention.

Explanation of symbols

1 Quantity calculation creation system 10 Controller (CPU)
11 Input device 12 Memory 13 Display device 14 Output device 20 Storage device 22 Program 23 CAD application 24 Quantity calculation creation program 24 'Simplified version program 25 Spreadsheet program 26 File 30 Original drawing file 31 Definition creation drawing file 32 For attribute creation Drawing file 33 Definition file 34 Attribute file 35 Quantity data TXT file 36 Quantity data CSV file 37 Quantity calculation template file 38 Quantity calculation file 40 Original drawing file 41 Display window 42 Method name tab 43 Type list 44 Color change command 45 Attributes Value column 46 Data row 47 Data list display column 48 Data list 49 Quantity calculation creation button 51 Span switching button 55 Quantity calculation template file 56 Cell 57 Quantity data CSV file 58 Quantity Statements of files 61 ordering party terminal 62 Quantity Statements of creating trader side terminal 64 ordering party computer system 65 Internet

Claims (4)

A first file in which drawing data including character data is recorded, and character data to be extracted from the character data recorded in the first file are replaced with other character data and a character string that can be distinguished from drawing data. A second file, and a third file in which character data to be extracted among character data recorded in the first file is replaced with a character string representing an order in the character data to be extracted; The steps to load
The drawing data including the character data recorded in the second file is represented in the source text list format, and the character string to be extracted is searched for the identifiable character string replaced with the character data to be extracted. Creating a fourth file in which line numbers in the source text list of character data are extracted and recorded;
Extracting and recording the character string representing the order specified by the line number extracted in the fourth file from the drawing data including character data recorded in the third file in the source text list format. Creating a fifth file,
A sixth example in which character data specified by a line number extracted in the fourth file is extracted and recorded from drawing data including character data recorded in the first file in a source text list format. Creating a file;
Creating a seventh file in which the character data recorded in the sixth file is sorted and recorded using information of a character string representing the order recorded in the fifth file;
Outputting at least the seventh file from a computer;
A method of extracting character data on a drawing. A first file in which drawing data including character data is recorded, and character data to be extracted from the character data recorded in the first file are replaced with other character data and a character string that can be distinguished from drawing data. A second file, and a third file in which character data to be extracted among character data recorded in the first file is replaced with a character string representing an order in the character data to be extracted; The steps to load
The drawing data including the character data recorded in the second file is represented in the source text list format, and the character string to be extracted is searched for the identifiable character string replaced with the character data to be extracted. Creating a fourth file in which line numbers in the source text list of character data are extracted and recorded;
Extracting and recording the character string representing the order specified by the line number extracted in the fourth file from the drawing data including character data recorded in the third file in the source text list format. Creating a fifth file,
A sixth example in which character data specified by a line number extracted in the fourth file is extracted and recorded from drawing data including character data recorded in the first file in a source text list format. Creating a file;
Creating a seventh file in which the character data recorded in the sixth file is sorted and recorded using information of a character string representing the order recorded in the fifth file;
The character data recorded in the seventh file is recorded in the quantity calculation file based on the link information of the quantity calculation file in which link information with the character data previously recorded in the seventh file is recorded. A step of creating a quantity calculation document in which character data on the drawing of the first file is extracted;
Outputting at least the quantity statement from a computer;
A method for preparing a quantity statement, comprising: Reading a drawing file containing drawing data including character data into a computer;
Invoking at least one set of classification type list in which a classification type name for classifying the character data previously read into the computer is posted;
The character data to be extracted selected from the character data and the category type name selected from the category type list are associated with each other to create a set of data rows, and the set of data rows Creating a data list in which a plurality of sets of data rows and a plurality of sets of data rows are put together as a data column;
By recording the character data to be extracted included in the data list in a predetermined part of the quantity calculation file by the link information of the quantity calculation file in which link information based on the classification type name is recorded in advance, Creating a quantity calculation document in which character data on the drawing of the drawing file is extracted;
Outputting at least the quantity statement from a computer;
A method for preparing a quantity statement, comprising: A program for causing a computer to execute the character data extraction method on a drawing according to claim 1 or the quantity calculation document creation method according to claim 2 or 3.

Images