JP4351230B2 - Design document data generation system and design document data generation method - Google Patents

Description

  The present invention relates to a design document data generation system and a design document data generation method suitable for an integration system in construction design, and in particular, a design capable of automatically generating design document data using design document history information designed in the past. The present invention relates to a document data generation system and a design document data generation method.

  Generally, in a large-scale construction, it is necessary to generate an integrated design document for the entire construction, and as a technique for generating this integrated design document, the following patent documents can be cited.

  The following Patent Document 1 is a system that outputs an integrated design document based on the price of each level of a design system in which a plurality of construction items are arranged in a tree shape, specifically, a design system displayed on a screen. By designating construction items in, each designated construction item and each construction item located at a lower level of this construction item are separated from the design system as a divided design system, and each construction of each separated divided design system The process of performing various edits on items based on operation instructions and the division design system are connected to the specified position, and the integrated design document data is generated by obtaining the price of each construction item in the design system after merging A technique for efficiently generating design document data by executing a process is described.

  Patent Document 2 discloses an integration system and an integration program that perform integration processing using data that can easily grasp the relevance of each node constituting the integration system and that can easily redefine data. Specifically, the integration system data and design document in XML format that describes the operational relationship between the node values of each node by inserting an operator tag representing an operator with a tag name between each node constituting the integration system Data, and when a node to perform integration processing is specified, the node value and operator of the specified node are acquired, and a calculation formula is generated from the acquired data, and the integration processing is performed according to the calculation formula A technique for generating design document data by executing a process for executing is described.

Furthermore, Patent Document 3 is a system that can easily and quickly calculate and output a breakdown of construction costs, etc., according to the bidding / estimated amount using the apportionment function, and designates the construction price for which bidding / estimate submission etc. is desired. Calculate the target direct construction cost by calculating back from the designated construction cost based on the designated construction cost and the specified construction cost, and the direct construction cost according to the specifications and contents of the construction to be bid or estimated. A process to calculate by stacking up, a process to calculate the calculated direct construction cost by dividing it into a unit price corresponding to the target direct construction cost, and a price for each breakdown line corresponding to the target direct construction cost, and a breakdown or estimate The technology for generating the design document data by executing the process of outputting is described.
Japanese Patent Laid-Open No. 2002-63233 JP 2004-272388 A Utility Model Registration No. 3092185

  In the construction design estimation system based on the technology described in the above-mentioned patent document, when applying at the time of construction price estimation, the designer calculates the quantity of all materials required for construction based on an accurate design drawing, and uses these quantities. The designer inputs the construction details multiplied by the unit price considering the locality and calculates the construction price by classifying and recording the construction price by construction type. However, because it takes time for input work, it is necessary to reduce the improvement of technical skills that should be the original work, and because it takes time for input work, estimate design (authorization design) and quick integration results are obtained. There were a problem that it was not suitable for the disaster assessment design to be calculated and a problem that it was possible to determine the breakdown amount, but it was not possible to make a simple determination of the construction contents.

  Specifically, since the technique described in Patent Document 1 performs various edits based on operation instructions for each work item in each divided design system, the construction content is based on the operation instructions. Similarly, the technique described in Patent Document 2 is an integration system that performs integration processing using data that can easily grasp the relevance of each node constituting the integration system and can easily redefine data. Therefore, the content of the construction is edited based on the conventional operation instructions, and the technology described in Patent Document 3 calculates the price for each breakdown line that matches the target direct construction cost, and the breakdown or estimate However, it is not possible to determine the breakdown details, and it cannot be said that it is a simple work content determination. He said many It was those that lead to failure.

  An object of the present invention is to eliminate the above-described problems caused by the conventional technology, and to provide a design document data generation system and a design document data generation method that allow a designer to automatically generate design document data quickly from design document data. It is. Another object of the present invention is to provide a design document data generation system and design document data that can reduce the input work of the designer and can perform an estimate design according to site conditions even if the accumulated knowledge is insufficient. It is to provide a generation method.

In order to achieve the above object, according to the present invention, an automatic design document data generation unit of a server computer automatically generates design document data including a construction cost estimate according to a construction generation condition and a construction price condition input from a computer terminal device. A design document data generation system to generate,
The construction generation condition includes a plurality of integration standards according to a plurality of regulations, a work type classification obtained by subdividing the integration standard according to the work content, construction quantity information corresponding to the work type classification, an average value, a maximum value, or a minimum value. Including approximate generation conditions that specify values ,
The automatic design document data generation unit
A construction cost file storing a record including a first key composed of a combination of a design document number and a job type, and a first design document attribute item information including a construction type classification and a construction price corresponding to the first key ;
A record comprising the first key, a second key composed of a breakdown code and an item number, and second design document attribute item information including a quantity, a unit price and an amount corresponding to the combination of the first and second keys. And a breakdown file containing
It has a work construction cost file that stores data and a work breakdown file ,
A first step of extracting a record including the first design document attribute item information having the same job type input from the computer terminal device from the construction cost file and storing it in the first work construction cost file;
A second step of searching the first work construction cost file for a record including a design document number that matches the construction classification information input from the computer terminal device and storing the record in the second work construction cost file;
A third step of searching the second work construction cost file for a record including a design document number that matches the construction price condition input from the computer terminal device, and storing the record in the third work construction cost file;
A fourth step of extracting a record including the first key included in the record stored in the third work construction cost file from the breakdown file and storing it in the first work breakdown file;
A fifth step of determining whether the approximate generation condition input from the computer terminal device is an average value, a maximum value, or a minimum value;
When it is determined in the fifth step that the approximate generation condition is an average value, an average value of unit prices included in the plurality of records stored in the fourth step is calculated, and based on the calculated average unit price A sixth step of generating average breakdown information;
When it is determined in the fifth step that the approximate generation condition is the maximum value, the maximum unit price included in the plurality of records stored in the fourth step is extracted, and based on the extracted maximum unit price A seventh step of generating maximum value breakdown information;
When it is determined that the approximate generation condition is the minimum value in the fifth step, the minimum unit price included in the plurality of records stored in the fourth step is extracted and based on the extracted minimum unit price The first feature is to execute the eighth step of generating the minimum value breakdown information .

Further, the present invention provides a plurality of integration standards according to a plurality of regulations, a work type classification obtained by subdividing the integration standard according to the work content, construction quantity information corresponding to the work type classification, and an average value, maximum value, or minimum value. The condition generation conditions and construction price conditions including the approximate generation conditions to be specified are input from the computer terminal device, and the automatic design document data generation unit corresponds to the first key and the first key composed of the combination of the design document number and the job type. A construction cost file storing a record composed of first design document attribute item information including a work type classification and a construction price, a second key composed of the first key, translation code, and item number, and a first key and a second key A breakdown file storing a record composed of the second design document attribute item information including the quantity, unit price and amount corresponding to the combination of the above, a work construction cost file storing the data, and a work breakdown file Have yl, a design document data generation process according to the server computer for automatically generating a design document data including the cost estimates of construction based on the work product conditions and construction cost conditions,
In the server computer,
A first step of extracting a record including the first design document attribute item information having the same job type input from the computer terminal device from the construction cost file and storing it in the first work construction cost file;
A second step of searching the first work construction cost file for a record including a design document number that matches the construction classification information input from the computer terminal device and storing the record in the second work construction cost file;
A third step of searching the second work construction cost file for a record including a design document number that matches the construction price condition input from the computer terminal device, and storing the record in the third work construction cost file;
A fourth step of extracting a record including the first key included in the record stored in the third work construction cost file from the breakdown file and storing it in the first work breakdown file;
A fifth step of determining whether the approximate generation condition input from the computer terminal device is an average value, a maximum value, or a minimum value;
When it is determined in the fifth step that the approximate generation condition is an average value, an average value of unit prices included in the plurality of records stored in the fourth step is calculated, and based on the calculated average unit price A sixth step of generating average breakdown information;
When it is determined in the fifth step that the approximate generation condition is the maximum value, the maximum unit price included in the plurality of records stored in the fourth step is extracted, and based on the extracted maximum unit price A seventh step of generating maximum value breakdown information;
When it is determined in the fifth step that the approximate generation condition is the minimum value, the minimum unit price included in the plurality of records stored in the fourth step is extracted, and based on the extracted minimum unit price The second feature is that the eighth step of generating the minimum value breakdown information is executed .

  According to the present invention, design document data whose integration criteria and construction classification information match is extracted from design document data in construction examples such as past design data, and construction cost information required for this design document data is newly input. Since it is calculated by converting to the construction quantity information that was created, the designer can generate design document data with the approximate values intended by the designer based on the design drawing, reducing the man-hours of input work and designing A person can spend time for the work as an engineer who should be. In particular, when calculating the amount of restoration in the event of a disaster, it is possible to generate an estimate in a short time, which is effective for supporting restoration paperwork, and by identifying the relevant part of the history information, the construction cost based on the current unit price (Construction cost) can also be calculated quickly.

Hereinafter, an embodiment of a design document data generation system for executing a design document data generation method method according to the present invention will be described in detail with reference to the drawings.
<Description of configuration>

FIG. 1 is a diagram showing a computer system including a computer terminal device and an automatic design document data generation function unit constituting a design document data generation system according to the present embodiment, and FIG. 2 is a diagram showing a configuration of a construction cost file 121 according to the present embodiment. 3 is a diagram showing the configuration of the breakdown document file 122 according to the present embodiment, FIG. 4 is a diagram showing the configuration of the design document data file 123 according to the present embodiment, and FIG. 5 shows the configuration of the code file 124 according to the present embodiment. FIG. 6, FIG. 6 is a diagram showing the configuration of the estimate basic file 125 according to the present embodiment, FIG. 7 is a diagram showing a generation condition display / selection input screen example displayed on the computer terminal screen according to the present embodiment, and FIG. FIG. 9 is a diagram showing an example of a generation result display screen displayed on a computer terminal screen according to an example. FIG. 9 is a back calculation in the design document data generation system according to the present embodiment. FIG. 10 is a flowchart showing the processing operation of the accounting data generation function unit, FIG. 10 is a flowchart showing the input condition search processing in the reverse calculation design document data generation function unit in the design document data generation system according to this embodiment, and FIG. 11 shows the design according to this embodiment. 12A to 12C are flowcharts showing approximate value calculation processing according to the present embodiment, and FIG. 13 is a flowchart showing detail assignment processing according to the present embodiment. FIG. 14 is a flowchart showing a design document data generation process according to this embodiment, and FIG. 15 is a diagram for explaining the concept of each generation means according to this embodiment.
<Premise explanation>

  The basics of the construction (acquisition, modification, repair, removal, etc. of some facilities) in the design document data generation system that is the subject of the present invention should be able to meet the demand when the construction is completed. Make a specific plan, and then make a plan (referred to as “design”) that shows the actual completed state based on the basic plan in detail, and then follow the design. Estimate how much is required to construct the work (this is called "accumulation").

The orderer who generated the demand for construction first shows the above-mentioned design to multiple contractors, asks the contractor to estimate how much the contract will be undertaken for construction and delivery, and places an order on the one with the lowest estimate. . The contractor who receives the design and is asked for an estimate plans how to build and complete it safely, efficiently and economically, and what will it cost? Calculate and submit to the orderer. In this way, the person who submits the lowest price in the estimate submitted by the contractor becomes the contractor and makes a contract to construct the construction. The present invention relates to a design document data generation system in such construction.
<Description of overall configuration>

As shown in FIG. 1, the design document data generation system according to the present embodiment includes a computer terminal device 100 and an automatic design document data generation function unit 110. The computer terminal device 100 has a display device by a designer. A generation condition display / selection input unit 101 for inputting design condition data generation condition information using an input device while viewing, a storage unit for storing generation condition information and the like input by the input unit 101, and An information communication control unit for communicating information and the like stored in the storage unit with an automatic design document data generation function unit 110, which will be described later, and information or the like returned from the automatic design document data generation function unit 110 Generation result display / adjustment / form output unit 102. In addition, although the example of the computer terminal apparatus 100 shows one example in the illustrated example, a plurality of computer terminal apparatuses 100 may be provided.
<Automatic Design Document Data Generation Function Unit 110>

The automatic design document data generation function unit 110 includes an information communication control unit for transmitting and receiving information to and from the computer terminal device 100, and an arbitrary construction result example (for example, a past construction result example or an assumed virtual construction example). A design document history information storage unit 120 for storing information related to construction in the project; an input condition search unit 111 for retrieving an input condition for retrieving any construction information from the design document history information storage unit 120; An approximate value calculation unit 112 for calculating an approximate value of the condition between the construction information of the actual example and the input construction information, a construction detail assignment unit 113 that performs detailed assignment of construction details, and a design that generates design document data The document data generation unit 114, the code file 124 that stores the code information of the design document history information together with the name, and the material and other unit price information in each construction process are stored. That a quote base file 125, are connected by a network to each file (not shown). The design document history information storage unit 120 includes a construction cost file 121, a breakdown document file 122, and a design document data file 123.
<Construction cost file 121>

  The construction cost file 121 stores design document data corresponding to the input conditions from the designer. As shown in FIG. 2, the construction cost file 121 includes the key 1 including the number of changes / type of job for the design document number, and the design document. A table 131 including a design category attribute item including a work type category indicating a type of work corresponding to a number, a construction price, and a temporary cost indicating a temporary design price is provided. For example, the number of changes of the design document number “16350030” is “0”. , The job type is “C”, the work type classification is “01”, the published price is “61,193,673 yen”, and the temporary cost is “5958244 yen”.

The “number of changes” means the number of changes during the construction. For example, the initial estimate of the orderer is initially accumulated (number of changes = 00). In the case of a change, the contractor makes an estimate in the original design and presents cost information to the orderer, so that the change will result in a loss rather than profit, so the orderer will return to the original This is for performing change integration based on the integration (number of changes = 01) and calculating an appropriate price according to the change design. “Occupation” refers to the results of the survey and aggregation of the actual conditions of construction, procurement of materials and labor, actual conditions by management / accounting / costs, etc. Integration should be performed, but since it is difficult to work from the basic survey of the foundation, various integration standards are devised and generated as a solution to this problem. In this embodiment, , This cumulative standard is called job category, for example, "Civil Construction Accumulation Standard" generated by the Ministry of Land, Infrastructure, Transport and Tourism, "Port Construction Accumulation Standard" generated by the Ministry of Land, Infrastructure, Transport and Tourism, "Water Supply Construction Accumulation Standard" generated by the Ministry of Health, Labor and Welfare, generated by the Ministry of Agriculture, Forestry and Fisheries "Land improvement work accumulation standard" by the Ministry of Agriculture, Forestry and Fisheries. “Construction classification information” is a further subdivision of the above-mentioned standard of accumulation (type of job). For example, in the case of sewerage construction, “civil engineering work total standard” is “river work”, “road improvement work”, “paving”. It is subdivided into “construction”, “parking” and “sewerage”.
<Breakdown file 122>

  The breakdown file 122 stores various types of extraction information for extracting design information, and includes tables 132 and 133. The table 132 is an item of the key 1 similar to the construction cost file 121. In addition, it consists of a key 2 consisting of a breakdown code / item number assigned to each design document number and a design attribute item consisting of quantity information / unit price / amount of construction materials, etc. The table 133 contains the keys 1 and 2 In addition to the above, each item includes a detail code assigned for each design document number, and items of quantity information / condition code / unit price / amount. The breakdown file 122 includes, for example, a table 132 indicating that the design document number “16350030” is the breakdown code “A1102001” / item number “001” / quantity information “4200” / unit price “1672” / amount “70224 yen”. The specification code “P1010101” of the design document number “16350030” stores that the quantity information is divided into “3200” and “1000” as a further breakdown A.

  The table 132 stores production work types, and the table 133 stores detailed production quantity information and construction contents corresponding to the production work types. To explain this, in general, the integration work is the work of planning the cost of the item to be attached to the contract, and the composition of the construction price such as the cost is roughly divided into the construction cost, the general management cost and the profit. The construction costs are subdivided into direct construction costs and indirect construction costs. The direct construction cost is calculated by summing up the direct construction cost for each production work type calculated from the production quantity information and the unit price for each production work type. May also be referred to as information on various types of production works that are the source of direct construction costs and production quantity information that accompanies them.

In the present embodiment, production work types are stored in the table 132, and detailed production quantity information and construction contents corresponding to the production work types are stored in the table 133 as information. Specifically, for example, the table 132 stores production work type information related to “pipe excavation (construction)”, and the table 133 includes detailed production quantity information and construction details corresponding to the “pipe excavation (construction)”. (stores shown in FIG. 6, "mechanical drilling (c Bu Kkuhou 0.13 m ^3)" and "mechanical drilling (Ha Bu Kkuhou 0.28 m ³⁾ corresponding specification code [P1010101] condition code [01 or 02]." Further, the breakdown documents A to C in FIG. 3 store excavation quantity information and unit price for each excavation content as shown in FIG. 15 to be described later.
<Design document data file 123>

  As shown in FIG. 4, in addition to the key 1, the design document data file 123 includes processing steps and processing states that represent the progress of each step of the district / standard application year version / accumulation process for each design document number. It includes a table 134 including design document attribute items to be included, and generation condition items including generation code (representing manual “0” or automatic “1”) / construction price / inequality sign / work type classification. The design document data file 123 includes, for example, the construction of the design document number “16350030”, the construction / legal application version of the district “A” is “October 2017” / the construction process is “31”, The processing status code is “3”, the construction of the design document number “1633500032”, the construction / legal application version of the district “A” is “October 2017” / the construction process “31”, processing state code “3” / generated code “1” / construction price less than “50000000 yen” / construction type “01” are stored.

  In the above-described files 121 to 123, each information in the upper part indicates a history of construction results, and the lower part indicates a newly generated one by an operation described later. Key 1 of the design document data file is a work “Key 1” in the expense file is the same as “Key 1” in the breakdown file, and “Key 2” in the breakdown file (table 132) is the same as “Key 2” in the breakdown file (table 133) is there. The breakdown code is a code assigned to each production work type. In this embodiment, a code file 124 described below is prepared as a code definition, and is basically defined in the code file 124. Code that is not available is not available in other tables. The “applied year version” indicates a year in which the above-mentioned “civil engineering work accumulation standard” generated by the Ministry of Land, Infrastructure, Transport and Tourism is adopted.

The “processing step” is a step in the integration step, specifically, “determination of integration standard”-“determination of work type”-“generation of breakdown document”-“integration processing”-“form output etc.” Each process is represented by a numerical value, and the processing step and the processing status represent a numerical value indicating the current state of the corresponding design document. For example, in FIG. “31” and “processing status” of “3” indicate that the integration processing step is normally completed by the code file 124.
<Code file 124>

The code file 124 stores a plurality of codes corresponding to a code name (production type) of design document history information, a specific name corresponding to the plurality of codes, and the like as shown in FIG. A table 135 including items of a key 1 including a plurality of breakdown codes assigned to each name, a key 2 including a plurality of breakdown codes assigned to the respective code names, and an attribute item including a plurality of code names For example, it is set as follows.
[Specific example of breakdown code]
Pipe line
└Drilling: Breakdown code A1102001
└ Pipeline backfill: Breakdown code A1102002
└ Pipeline earth retaining work
Tsuboya Itado: Breakdown code A1102003
Spear sheet loss: Breakdown code A1102004
...
└Mounting pipe and 桝
└Drilling: Breakdown code A1202001
└ Pipeline backfill: Breakdown code A1202002
<Estimation basic file 125>

The estimate basic file 125 stores unit price information corresponding to the detail code. As shown in FIG. 6, the key 1 including the description code, the key 2 including the condition code, and the description name / condition For example, the condition code “01” is assigned to the specification code “P1010101”, and the specification name “machine excavation” / condition name “backhoe 0. 13m ³ ”/ unit price“ 1672 yen ”/ unit“ m ³ ”. In this estimate basic file 125, since the above-mentioned integration standard is registered and a plurality of items necessary for the above-mentioned breakdown are accumulated, attribute items corresponding to the negative key 1 and the condition code are registered, and FIG. In the example, “key 1” indicates an example in which each code is assigned to each integration criterion. The “condition code” is used as a key when there is a further classification for each integration criterion. In this example, even if the same machine excavation is used, the amount of money varies depending on the model used, so the model is classified as a condition. It is what.
<Explanation of operation screen>

  7 and 8 show display examples of the computer terminal device 100 in FIG. In the present embodiment, when the computer terminal device 100 is activated, the information transmitted from the information communication control unit of the automatic design document data generation function unit 110 is input to the generation condition display / selection input unit 101 that can be instructed at present. The selection screen 200 shown in FIG. 7 is displayed for the information.

  The selection screen 200 includes a screen 201 and a screen 202. The screen 201 is a generation means selection field for selecting a generation condition, and a work type that is a key for collecting information for automatically generating design document data. The construction type selection column for selecting a category, and the construction price input column for inputting construction price and selecting an inequality sign as a condition for collecting information, all of the above options being the code file 124 (FIG. 5) Are selected from those corresponding to the various codes stored in. In this screen 202, a list of integrated data input through the screen 201 is displayed, and these display items are extracted from the design document data file 123 and the construction cost file 121, and the items to be generated are checked. By removing, it can be set to be excluded from the automatic generation target of design document data to be performed.

  In this system 200, when the designer selects and inputs the desired generation means / work type classification / construction amount and clicks (sends) the automatic generation button, the automatic design document data generation function unit 110 is displayed. The information is transferred from the information communication control unit to the input condition search unit 111, and the design document data corresponding to the input condition is extracted from the construction cost file 121 of the design document history information storage unit 120. The extracted design document data is transmitted again from the information communication control unit of the automatic design document data generation function unit 110. When the extracted content is input to the generation condition display / selection input unit 101, the screen 200 shown in FIG. indicate. From this, the designer can extract the corresponding design document data, and by clicking (sending) the generation correction button, the extracted information is transferred from the information communication control unit of the automatic design document data generation function unit 110 to the approximate value calculation unit 112. The data corresponding to the extracted information is searched from the breakdown document file 122 of the design document history information storage unit 120 which is a design document data (history) database, the quantity information is calculated by the instructed generation means, and the construction contents To decide. After the approximate value calculation processing, the present system takes over the processing to the construction details allocating unit 113, generates the breakdown file 122 required for the design document data, and the design document data generation unit 114 uses the amount required for the design document data. Calculation is performed and a design document data file 123 is generated. The generated design document data information is transmitted from the information communication control unit of the automatic design document data generation function unit 110 and displayed on the generation result display / adjustment / form output unit 102.

FIG. 8 is a diagram illustrating an example of a generated result screen 300 to be displayed. This screen 300 displays a column 301 for displaying each work item of the breakdown file (table 132) in a tree structure as a result of automatic generation, and details of each work item of the breakdown file (table 133) as a result of automatic generation. It comprises a display field 302. The screen example shown in FIG. 8 displays the data of the design document number 1735030, and the breakdown code of the table 132 is displayed on the screen 301 after the name is acquired from the code file 124, and the detailed code of the table 133 is the basic estimate code. After the name is acquired from the file 125, it is displayed on the screen 302 together with the construction quantity information and the unit price information, and can be corrected as necessary.
<Description of operation>

Next, an operation of the design document data generation system configured as described above and a design document data generation method for performing the operation will be described.
First, the overall operation outline of the design document data generation system according to the present embodiment will be described with reference to FIG. 9. The computer of the automatic design document data generation function unit 110 has a permission design generated by the designer as shown in FIG. When design condition data based on the document data is input using the computer terminal device 100, a step 401 for receiving an instruction to automatically generate design document data, and the input design condition data and the construction cost file 121 in advance. Step 402 (refer to the description of the screen 200 described with reference to FIG. 7) for searching for generation conditions using the stored design document data (argument is approximated) of any stored construction example, and these inputs Further, the retrieved design document data and the breakdown and cost information stored in the breakdown file 122 and the construction cost file 121 are used as factors. A step 403 that performs a calculation process of generating dynamic design document data, and a process of displaying the contents of the design document data the generated display device.

  When the designer confirms the displayed design document data, approves or corrects the estimated content, and inputs the result using the computer terminal device 100, the computer of the automatic design document data generation function unit 110 A step 404 of outputting the approved design document data as a form, a step of instructing the display device 105 to output the display, and a process of storing the design document data in each file of the design document history information storage unit 120 are executed. .

  When the output design document data is authorized by a public organization or a licensee such as a customer, the computer of the automatic design document data generation apparatus 110 performs an instruction to generate the embodiment design document data, Step 405 for accumulating design data for each of a large number of constructions constituting the design document data, processing for storing the integration results in the construction cost file 121 and the design document history information storage unit 120, and the integration results on the display device 105 And a step of performing printing using the printing device.

  As described above, the automatic design document data generation function unit 110 of the design document data generation system according to the present embodiment is based on the design condition data inputted by the designer and the design document data (cost information / breakdown) of the construction result example. The design document data is newly generated using the design document data (cost information / breakdown) of the construction result example that approximates the newly input design condition. Details of each processing step will be described below.

<Input Condition Search Processing Step 402>
In this process, as shown in FIG. 10, when the designer performs the process for inputting the design document data generation conditions, the job type included in the design document data of the construction result example that matches the input job type is searched. Step 511 for extracting the design document number, construction category information, etc. of the retrieved job type from the construction cost file 121 and storing it in the work construction cost file 501, and the design document number etc. that matches the inputted construction category information Step 512 for extracting from the construction cost file 501 and storing it in the workpiece construction cost file 502; Step 513 for extracting the design document number etc. that matches the inputted construction price condition and storing it in the workpiece construction cost file 503; The step 514 for saving the job type / construction category information / construction price condition / key etc. to the work construction cost file 504 and the above-mentioned steps And a step of terminating the process.

  The work construction cost file 501 is obtained by extracting records from the construction cost file 121 (table 131) using the corresponding job type as a key and storing the extracted records (all items). A record is extracted from the construction cost file 501 using the type of work as a key, and the extracted records are stored (all items). The work construction cost file 503 is a record that matches the construction price extraction condition from the work construction cost file 502. Extracted and extracted records are stored (all items).

  The data stored in the work construction cost files 503 and 504 is used in step 403 of the calculation process described later. The generation conditions input to this calculation processing step 403 are the type of construction for generating design document data, for example, the type of work such as civil engineering, and the design document data when generating the design document data based on the construction result example (past data, etc.). Conditions, for example, generation means indicating whether to select average value, maximum value, minimum value, correction value, etc. of past data, construction classification, for example, construction classification information such as sewer construction, and upper limit of amount required for construction Enter the items of the construction price condition indicating the price of the construction, the district where the construction is to be performed, and the numerical condition of the construction, for example, the numerical conditions such as how many meters of pipes with a diameter of several millimeters are newly buried. . The “average value” is a process for obtaining an average value based on the production quantity information and unit price of the breakdown for automatic generation.

  As described above, the input condition search processing according to the present embodiment is performed by the design document number / construction of the design document data of the construction performance example that matches the job type / construction classification information / construction price condition among the design conditions input by the designer. It operates to retrieve / extract the classification information / construction price / temporary cost and other data from the construction cost file and store them in the work construction cost file 501/502/503/504.

<Calculation processing step 403>
In the calculation processing step 403, as shown in FIG. 11, the design document number / breakdown code / item number / unit price etc. including the key 1 that matches the key 1 stored in the work construction cost file 503 shown in FIG. Step 621 that is extracted from the table 132 of the document file 122 and stored in the work breakdown file 611, and the design document number / detail code / quantity information / including the key 1 that matches the key 1 stored in the work construction cost file 503 The condition / unit price and others are extracted from the table 133 of the breakdown file 122 and stored in the work breakdown file 612, and the design number / detail code / quantity information / condition / unit price stored in the work breakdown file 612. Step 601 for performing approximate value calculation processing based on others, and the design document number stored in the work breakdown file 611 Detailed assignment processing step 602 for assigning construction details based on / breakdown code / item number / unit price, etc., step 603 for generating design document data based on the values calculated in steps 601 and 602, and this generation Step 623 for transmitting the designed design data to the computer terminal device 100 is sequentially executed. The table structure of the work breakdown files 611 and 612 is the same as the table structure (tables 132 and 133) shown in FIG.

  The details of step 621 in this calculation process will be described. Since this process has items of “design document number”, “number of changes”, and “job type” that are “key 1” in the construction cost file 121, By extracting records having the same “key 1” from the table 132 (FIG. 3) of the breakdown file 122 and storing all items in the work breakdown file 611 (table structure similar to the table 132), This is a process for performing search extraction.

<Approximate value calculation process 601>
The approximate value calculation process 601 calculates an approximate value for each process of “average value”, “maximum value”, and “minimum value” specified as the generation condition, thereby generating the breakdown file 122 (tables 132 and 133 according to the generation condition). 12A to 12B, it is assigned to each design document data such as design document number / detail code / quantity information / condition / unit price stored in the work breakdown file 612. Step 711 for turning off all flags, a loop [1] for performing this flag off repeatedly for all data, and a design document data (referred to as data reading A) for the table 132 stored in the work breakdown file 612. Steps 713 to 715 for clearing the work 701 and turning on the above-mentioned flag, and repeating this step 715 to the end of the data. Return loop [2] Step 716, Step 717 for reading all design document data (referred to as data reading B) with the flag of the work breakdown file 612 turned off, and data reading A and B by the steps 713 and 717 Step 718 for determining whether or not the key 2 (breakdown code and item number) is the same, and in step 718, the design document data having the same key 2 is read from the work breakdown file 612, and the flag is turned on. In addition, the loop is written to the work 701 and this process is repeated until the end of the data [2] Step 721, and the design document data A (design document number / detail code / quantity information / condition / unit price) turned on in the step 714. Step 722 of storing the other) in the work 701 and executing the work breakdown file 1 The breakdown data that matches key 2 (breakdown code and item number) is extracted from the breakdown data of the design document data in which the key 1 stored in 2 matches the breakdown of the design document data in the construction results example, and stored in the work 701 Perform the process.

  Next, this approximate value calculation processing step 601 is followed by step 722, and the generating means (average value / maximum value / minimum value / correction value, etc .: saved in the work 504 generated in step 514 of FIG. 10 as shown in FIG. Step 723 proceeds to the step shown in FIG. 12C when it is determined whether or not “average value” is set to “average value” on the operation screen 200, and the step 723 causes “ When it is determined that the value is “average value”, a step 724 for clearing the work 702 for saving the unit price data, a loop [3] step 725 for repeating the step 724 to the end of the data, and the data C from the work 701 Steps 726 to 727 for reading and counting data, step 728 for adding numerical values of these data, and reading Step 729 for determining whether or not there is the same detail code condition as data C; step 730 for adding the detail code condition for data C when it is determined that there is no same detail code condition in step 729; After the step, a step 731 for calculating the unit price and a loop [3] step 732 for repeating the above process are sequentially executed.

  Next, in the approximate value calculation process 601, as shown in FIG. 12B, step 733 for obtaining calculated quantity information d by the formula of [total quantity information b ÷ data count a], and the formula of [total unit price c ÷ data count a]. Step 734 for obtaining the calculated unit price e by the above, a loop [4] step 735 for repeating the steps 733 and 734 to the end of the data, a step 736 for reading the unit price data D from the work 702, the calculated quantity obtained in the step 733, etc. Using the information d and the calculated unit price e, the absolute value f of the unit price is calculated by the formula [calculated unit price e−D unit price], and the absolute value g of the unit price is calculated from [unit price of the work 703−D unit price] 737 738, step 739 for determining whether or not the calculated absolute value f is smaller than the absolute value g, and step 739 When it is determined that the absolute value f is smaller than the absolute value g, a step 740 for comparing the D unit price with the work 703, a loop for repeating the steps 736 to 740 [4], step 741, and the calculated quantity obtained in the step 733 A step 742 for temporarily storing the information d in the work 3, a step 743 for setting the work generation condition 504 by setting “key 1” as a key of the work 703, and a breakdown in the table 133 of the breakdown file 122 Step 744 for registering the contents of file 2 and loop [1] step 760 for repeating the process are sequentially executed.

  That is, when it is determined that the generation condition set in step 723 is an average value, the system calculates average quantity information and unit price using steps 733 and 734, and unit price using steps 737 and 738. An absolute value is obtained, and an average unit price according to these generation conditions is temporarily stored in the work 703 and stored in the breakdown file 122, whereby a breakdown file with the average value can be generated.

  On the other hand, when it is determined in step 723 of FIG. 12A that the generation condition of the workpiece 504 is the maximum value, the system determines whether the generation means is the maximum value as shown in FIG. When the generation condition is determined to be the maximum value, a loop [3] that repeats the determination until the end of the data [3] Step 746, a step 747 for reading data C from the work 701, and whether the C unit price is larger than the unit price of the work 703 Step 748 for determining whether or not, Step 748 for saving the C unit price other than the quantity information to the work 703 when it is determined that the quantity is larger in Step 748, and the C quantity information is larger than the quantity information of the work 703 Step 750 for determining whether or not it is large, and in the step, when it is determined that the value is large, the C quantity information is set to the work 703. The maximum value breakdown file is executed by executing step 751 for storing as quantity information and loop [3] step 752 for obtaining the maximum value by repeating steps 747 to 751 and moving to step 743 of FIG. 12B. Can be generated.

  In the first determination step of FIG. 12C, when it is determined that the generation condition of the workpiece 504 is not the maximum value (when it is determined to be the minimum value), the system performs steps 753 to 759 similar to steps 746 to 752. By executing the above, it is possible to generate a breakdown file with the minimum value.

  As described above, the approximate value calculation process (step 601) according to the present embodiment determines the generation means from the work breakdown file 612 and the work generation condition 504, calculates the quantity information and determines the unit price, and registers the breakdown file. The construction details are determined, and the breakdown documents A, B, and C having the same breakdown code information are generated and extracted to the work 1701. The extracted breakdowns A, B, and C are determined by the generation means (minimum / average / maximum) based on the work generation condition 504, and the processing is distributed. In the present embodiment, for example, when the generation means is an average value, the breakdown amount A is 42 m3, B is 56 m3, and C is 73 m3. Therefore, 57 m3 of these average values is the construction quantity information. The details of construction are as follows: Breakdown A is machine excavation (backhoe 0.13m3) / unit price 1,672 yen, B is machine excavation (backhoe 0.28m3) / unit price 1,353 yen, C is manual drilling / unit price 5 Since the average unit price is 2,828 yen, machine excavation with the closest absolute value (back hoe 0.13 m3) / unit price 1,672 yen is adopted as the construction details. Similarly, when the generating means is the maximum value, the construction quantity information is 73 m3 of the breakdown document C, the construction details are manual excavation / unit price 5,460 yen of the breakdown statement C, and when the generating means is the minimum value, the construction quantity The information is 42 m3 of breakdown statement A, and the construction details are the machine excavation (backhoe 0.28 m3) of breakdown statement B / unit price 1,353 yen. Further, an approximate value calculation using a correction value can be considered as a generation unit. In this case, correction using a correction value can be further performed after the approximate value calculation. The adopted construction details and construction quantity information are given a new design document number, which is information from the work generation condition 504, by the work 703 and registered in the breakdown file 122.

<Details assignment processing step 602>
Next, details of the detail allocation processing step 602 will be described with reference to FIG. This processing is as shown in FIG. A step 811 for reading the data A of the breakdown file 122 from the work 611, a step 813 for setting “key 1” from the work 504 to the data A, and the same key 2 as the table 133 of the breakdown file 122 for the data A The above-described approximate value calculation processing is performed by repeatedly executing the step 814 for setting the quantity information on the data and the step 815 for adding the quantity information to the file 132 of the breakdown file 122 for all the data between the steps 811 and 816. The breakdown information based on the construction details generated inside is edited as a work breakdown file 611, a new design document number, which is information from the work generation condition 504, is assigned and registered in the breakdown file 122.

<Design document data generation processing step 603>
As shown in FIG. 14, the design document data generation processing step 603 includes a step 911 for securing the work area A, a step 912 for setting “key 1” of the work generation condition 504 in the secured work area A, and a work area. A step 913 for setting the work generation condition 5 in A, a step 914 for setting the processing process / processing state in the work area A, a step 915 for registering the work area A in the design document data file 123, and the registered work The design document data file 123 is edited and registered based on the work generation condition 504 by sequentially executing the step 405 of performing area data integration processing and registering it in the construction cost file 121, and then generating the newly generated new data. Perform construction processing on design document data (step 405) to calculate construction price , It is possible to generate the construction costs file. In addition, since there is an accumulation calculation method such as a work type classification by each ministry or agency for the integration process, detailed description thereof is omitted here.

  As described above, the design document data generation system according to the present embodiment confirms the content of the new design document estimate automatically generated by the designer on the computer terminal, and when performing further generation, performs reprocessing from the generation condition input, The designer can scrutinize and confirm the automatically generated design document estimate contents with a computer terminal and output a form necessary for the design document. The design document output here is used as the design document history information at the next automatic generation. In one example, the design document data that was output in the form is used as the approved design document data, and after the approval, the designer can reuse the automatically generated design document data as the implementation design document data and perform the integration process. The generated design document data can be utilized as the design document history information at the next automatic generation.

  Therefore, according to the present embodiment, the designer can generate a design document with an approximate value intended by the designer based on the design drawing. Therefore, the man-hour of input work can be reduced, and the designer should originally exist. You can spend your time as a technician. In particular, when calculating the amount of restoration in the event of a disaster, it is possible to generate an estimate in a short time, which is effective for supporting restoration paperwork. In addition, by specifying the corresponding part of the history information, the construction cost (construction cost) based on the current unit price can be calculated quickly.

  Further, according to the present embodiment, by reducing the input work man-hours, the construction design integrating system can also generate authorized design document data generation by a public institution, and even if the designer has little design experience, Accurate design data can be generated for generation from information.

  In addition, this embodiment can be used to determine the work contents of the breakdown, so that a detailed and detailed design document can be easily and accurately generated. Similarly, in the case of a disaster assessment design, it can be generated reversibly from the disaster site. It can be expected that the generated design document database can contribute to risk analysis such as safety of the structure at the disaster site because of the generation from the history information. In addition, since it is possible to determine the work contents of the breakdown document, it is possible to expect a simple and accurate generation of detailed and detailed design documents. The generated design document data can be effectively used as original design information when the actual design document data is generated, and as history statistical information when the next design document data is generated.

The present invention is used in design document data generation in a construction design integration system. It can also be used in the calculation of the breakdown amount when the unit price type integration method is performed.
In addition, it is used in the calculation of approximate restoration work costs and the generation of disaster assessment design document data when a disaster occurs in the work design estimation system. Since it is based on reversibly generated data, in the case of rebuilding a damaged structure or the like, it is expected to be examined as a data condition such as a safety measure for the structure.

1 is a diagram showing a computer system including a computer terminal device and an automatic design document data generation function unit that constitute a design document data generation system according to an embodiment of the present invention. The figure which shows the structure of the construction cost file 121 by this embodiment. The figure which shows the structure of the breakdown book file 122 by this embodiment. The figure which shows the structure of the design document data file 123 by this embodiment. The figure which shows the structure of the code file 124 by this embodiment. The figure which shows the structure of the estimate basic file 125 by this embodiment. The figure which shows the example of a production | generation condition display and selection input screen displayed on the computer terminal screen by this embodiment. The figure which shows the example of a production | generation result display screen displayed on this computer terminal screen. The figure which shows the processing operation of the back calculation design document data generation function by this embodiment. The flowchart which shows the input condition search process in the back calculation design document data generation function part by this embodiment. The flowchart which shows the calculation process in the back calculation design document data generation function part by this embodiment. The 1st flowchart which shows the approximate value calculation process by this embodiment. The 2nd flowchart which shows the approximate value calculation process by this embodiment. The 3rd flowchart which shows the approximate value calculation process by this embodiment. The flowchart which shows the detailed allocation process by this embodiment. The flowchart which shows the design document data generation process by this embodiment. The figure for demonstrating the concept for every production | generation means by this embodiment.

Explanation of symbols

100: Computer terminal device 101: Generation condition display / selection input unit 102: Generation result display / adjustment / form output unit 105: Display device 110: Automatic design document data generation function unit 111: Input condition search unit 112: Approximate value calculation unit, 113: Construction details allocation unit, 114: Design document data generation unit, 120: Design document history information storage unit, 121: Construction cost file, 122: Breakdown document file, 123: Design document data file, 124: Code file, 125: Estimated basic file, 131 to 136: Table, 200: Selection screen, 201: Condition selection, 202, 300: Screen, 502: Work construction cost file, 503: Work construction cost file, 504: Work Construction cost file.

Claims (2)

A design document data generation system in which an automatic design document data generation unit of a server computer automatically generates design document data including a construction cost estimate according to a construction generation condition and a construction price condition input from a computer terminal device,
The construction product conditions, a plurality of integrated value determined by multiple provisions minutes Engineering species ku subdivided in accordance with the integration reference to construction work, and the work quantity information corresponding to該工species Classification, the average value or the maximum value Or an approximate generation condition that specifies a minimum value , and
The automatic design document data generation unit
A construction cost file storing a record including a first key composed of a combination of a design document number and a job type, and a first design document attribute item information including a construction type classification and a construction price corresponding to the first key ;
A record comprising the first key, a second key composed of a breakdown code and an item number, and second design document attribute item information including a quantity, a unit price and an amount corresponding to the combination of the first and second keys. And a breakdown file containing
It has a work construction cost file that stores data and a work breakdown file ,
A first step of extracting a record including the first design document attribute item information having the same job type input from the computer terminal device from the construction cost file and storing it in the first work construction cost file;
A second step of searching the first work construction cost file for a record including a design document number that matches the construction classification information input from the computer terminal device and storing the record in the second work construction cost file;
A third step of searching the second work construction cost file for a record including a design document number that matches the construction price condition input from the computer terminal device and storing the record in the third work construction cost file;
A fourth step of extracting a record including the first key included in the record stored in the third work construction cost file from the breakdown file and storing it in the first work breakdown file;
A fifth step of determining whether the approximate generation condition input from the computer terminal device is an average value, a maximum value, or a minimum value;
When it is determined in the fifth step that the approximate generation condition is an average value, an average value of unit prices included in the plurality of records stored in the fifth step is calculated, and based on the calculated average unit price A sixth step of generating average breakdown information;
When it is determined in the fifth step that the approximate generation condition is the maximum value, the maximum unit price included in the plurality of records stored in the fifth step is extracted, and based on the extracted maximum unit price A seventh step of generating maximum value breakdown information;
When it is determined that the approximate generation condition is the minimum value in the fifth step, the minimum unit price included in the plurality of records stored in the fifth step is extracted and based on the extracted minimum unit price And an eighth step of generating minimum value breakdown information . A design document data generation system, comprising: Approximate generation conditions for specifying a plurality of integration criteria according to a plurality of regulations, a work type classification obtained by subdividing the integration standard according to the work content, construction quantity information corresponding to the work type division, and an average value, maximum value, or minimum value The generation conditions and construction price conditions including the above are input from the computer terminal device, and the automatic design document data generation unit includes the first key composed of the combination of the design document number and the job type, and the work type classification and the construction price corresponding to the first key. Doo and construction costs file containing records including the first design document attribute item information including, corresponding to a combination of the second key and the first and second keys comprising a first key and translation code and No. a quantity and unit price and the breakdown document file containing a record made of the second design document attribute item information including the amount, the work construction cost files and work breakdown file for storing data, A design document data generation method by the server computer to automatically generate design document data serial construction generating conditions and construction price conditions based on including a cost estimate of the construction work,
In the server computer,
A first step of extracting a record including the first design document attribute item information having the same job type input from the computer terminal device from the construction cost file and storing it in the first work construction cost file;
A second step of searching the first work construction cost file for a record including a design document number that matches the construction classification information input from the computer terminal device and storing the record in the second work construction cost file;
A third step of searching the second work construction cost file for a record including a design document number that matches the construction price condition input from the computer terminal device, and storing the record in the third work construction cost file;
A fourth step of extracting a record including the first key included in the record stored in the third work construction cost file from the breakdown file and storing it in the first work breakdown file;
A fifth step of determining whether the approximate generation condition input from the computer terminal device is an average value, a maximum value, or a minimum value;
When it is determined in the fifth step that the approximate generation condition is an average value, an average value of unit prices included in the plurality of records stored in the fourth step is calculated, and based on the calculated average unit price A sixth step of generating average breakdown information;
When it is determined in the fifth step that the approximate generation condition is the maximum value, the maximum unit price included in the plurality of records stored in the fourth step is extracted, and based on the extracted maximum unit price A seventh step of generating maximum value breakdown information;
When it is determined in the fifth step that the approximate generation condition is the minimum value, the minimum unit price included in the plurality of records stored in the fourth step is extracted, and based on the extracted minimum unit price A design document data generation method , comprising: performing an eighth step of generating minimum value breakdown information .

Images