JP2006276954A - Construction estimation system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a construction estimation system facilitating changes of quantity calculation sources, quantity calculating equations, and integrated data generation contents. <P>SOLUTION: The construction estimation system calculating a construction quantity including a plurality of construction components is provided with a quantity calculation reference database 213 storing quantity calculation reference data corresponding to the construction components in an XML language form, a quantity calculating equation database 214 storing the calculating equations of quantity calculation in the XML language form, a design sheet generating definition database 215 storing generating definition information of a design sheet in the XML language form, and an XML parser 216 analyzing XML language stored in each database. The XML parser 216 analyzes the data in the XML language form stored in each database, and a quantity input image plane is displayed including a construction type data tree structure display part displaying the construction components in a hierarchized tree structure. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  TECHNICAL FIELD The present invention relates to a construction estimation system that performs a cumulative estimation required for construction based on construction quantity data such as construction range and material quantity in civil engineering work, and in particular, a construction totalization system that is quantitative data calculation by a definition method and subsequent work. It is related with the construction estimation system which can perform the accumulation | aggregation data generation | occurrence | production and re-generation used as input.

  In recent years, for example, the amount of excavated soil required for civil works for laying sewer pipes on roads, pavement road cutting length, and pavement slab destruction area are calculated as construction quantity data, and construction cost estimates are automatically based on the calculated data. A construction quantity calculation system that calculates automatically is desired, and this technique is described in, for example, the following patent documents.

  For example, Patent Literature 1 below proposes a system that automatically performs construction quantity calculation to construction integration by inputting construction data to a computer, and Patent Literature 2 provides a drawing image file of construction-related drawings. Referring to this drawing image file, the type of CAD system for creating construction-related drawings can be calculated by inputting the arrangement of the installation elements of the construction and the attributes of the installation elements and calculating the construction based on the input data. Regardless of the type of existing CAD system, a construction integration system that can be additionally introduced has been proposed.

  In addition, the applicant of the present application may use a client / server type construction quantity calculation system, a construction estimation system, a construction quantity calculation system for a construction department of a public organization (country / prefecture / local government) and a construction estimation system as a company product. A web application type work accumulation system is provided, and the work quantity calculation system and the work accumulation system execute a dedicated work processing program installed on each of the server and the client, thereby performing the work quantity calculation work and the work accumulation system. It provides various processing functions for business.

  In this client / server type construction quantity calculation system, the construction quantity calculation data input processing program and the construction quantity calculation output process program edited with the quantity calculation result are registered in the client, and the server inputs the quantity calculation processing program / accumulation input. An automatic data generation program / a database that records the quantity data necessary for each calculation process is registered. For example, in the case of sewer pipe installation work, the work quantity calculation work and the work accumulation work are executed according to the processing procedure shown in FIG. It is configured to do.

  These processing procedures will be described with reference to FIG. 5. For example, the quantity calculation data used in the construction of sewage sewers and manholes on the road includes construction extension value / excavation width / excavation depth / pavement surface layer thickness such as asphalt. When there is a / 菅 type (菅 diameter is defined by the type of mane) / manhole type (hole diameter-excavation amount is defined by the manhole type), this processing is performed as processing 51 when the client inputs the numerical calculation data. The server that received this data calculates the amount of excavated soil from the "construction extension value / excavation width / excavation depth" / calculates the pavement cutting length from the construction extension value / calculates the crushing area of the pavement plate from the construction extension and excavation width The processing 53 for performing the above, the processing 52 of the quantity calculation output for printing each item of the excavated soil amount / pave cutting length / pavement crushing area calculated by the processing 53, and the calculated excavated soil amount And it executes a process 54 for storing the numerical values in the integration by calculating the accumulated data by referring to the unit price and standards correspondence table based on the estimate of the underlying data database sequence.

  In the calculation process in the process 53, a database for storing quantity calculation data and a database for storing quantity calculation result data as calculation results are used, and each process can also be expressed as a program. The construction extension is 20 m / excavation width 1.1 m / excavation depth 1.5 m, and the server's quantity calculation program (processing 53) is the amount of excavated soil (m3) = construction extension (m) × excavation width (m) × The excavation depth (m) is calculated.

  The processing 54 corresponds to an integrated data automatic generation processing program, and from the quantity calculation result (in this example, the amount of excavated soil), the amount of work / transport cost / excavation machine loss / rent, etc. required for excavation is calculated. Information for calculation by the integration system is automatically generated. Specifically, from the correspondence table database of the codes of the construction standard data prepared for calculating these amounts, the quantity calculated by the construction quantity calculation system ( In this example, the accumulated data is generated with the amount of soil) as the quantity. This data is used when calculating the planned (estimated) amount of the construction by the construction accumulation system used in the construction accumulation work of the subsequent work.

  The processing 54 corresponds to a quantity calculation document output program, and the quantity of construction work is edited and printed out from a quantity calculation result data into a list form form. It can be used when purchasing materials during construction, or it can be used as the basis for the total amount of construction work.

  In this way, the client-server type construction quantity calculation system according to the prior art is capable of accumulating the estimated amount of construction based on the quantity calculation data such as construction extension, but in the actual construction quantity calculation processing, The minimum unit (span) of work for one work ranged from several tens to several hundreds, and it was necessary to accumulate several hundred to several thousand data for the data registered in the database.

In addition, as a document in which the technique regarding the said construction quantity calculation system was described, the following patent document is mentioned, for example.
JP-A-11-141115 JP 2003-64873 A JP 2003-19512 A JP 2000-32354 A JP 2000-357199 A

  The construction quantity calculation system according to the prior art described above is input to the construction standard data that is revised several times every year for the construction quantity calculation method that depends on the construction standard data used in the subsequent work construction system. It is necessary to modify the screen processing program / quantity calculation processing program / quantity calculation form output program, and it is necessary to implement the modification in a short period of time. There was a problem that it was difficult to maintain the quality. In addition, if the system users (providing organizations) are different, this method cannot be applied unless most of the system is remodeled, resulting in an increase in introduction cost.

  Furthermore, the construction quantity calculation system according to the prior art requires that the construction is patterned in order to automatically continue the data from the construction quantity computation work to the construction totalization work. There is also a problem that it can only be applied to sewerage works and waterworks works that have been patterned. Furthermore, in the conventional technology, there is no calculation method that is the standard for supervising ministries like the construction quantity calculation work, so the calculation method differs depending on the system user's organization or individual, Because the work processing program dedicated to the construction quantity calculation business is installed and executed on each server / client, the modified business processing program and the server are all updated every time the business processing program is modified (version up). There is also a problem that the installation work on the client of the client and the operation man-hours and costs for maintaining and managing the system become enormous.

  In this specification, the construction quantity calculation system described above, a quantity calculation definition system for registering definition information for calculating an estimate based on the quantity calculated by the construction quantity calculation system, and the quantity calculation A construction estimation system that calculates a construction estimate based on the definition system and the quantity calculation definition system is collectively referred to as a construction estimation system.

  The purpose of the present invention is to eliminate the above-mentioned problems caused by the prior art, and it is possible to realize the work efficiency with sufficient functions and operability necessary for the construction quantity calculation and construction work for the public sector. It is another object of the present invention to provide a construction estimation system capable of drastically reducing the cost of introducing the system and reducing the operation man-hours for maintenance.

  Furthermore, another object of the present invention is to provide a construction estimation system that makes it possible to clearly specify the basis for quantity calculation, and to change the quantity calculation formula and accumulated data generation content on the user side.

  In order to achieve the above object, the present invention provides a construction estimation system including a quantity calculation system for calculating a quantity of construction including a plurality of construction components, wherein the quantity calculation system is a quantity corresponding to the plurality of construction components. Quantity calculation reference database that stores calculation reference data in XML language format, Quantity calculation expression database that stores calculation formulas for quantity calculation in XML language format, and design document generation that stores generation definition information of design documents in XML language format A tree comprising a definition database and an XML parser for analyzing the XML language stored in each database, wherein the XML parser analyzes the XML language format data stored in each database, and the construction components are hierarchized. Work type data tree structure display section to be displayed in structure, construction conditions and materials and construction basic quantity for construction components And tablespaces input unit for force, the first display means displays the number input screen including a graphic display unit for displaying a figure for performing implications and validation of the input data visually.

  In the construction estimation system, the present invention provides a graphic information definition unit that stores graphic information, a quantity calculation tree editing unit that outputs the definition result of the work data tree structure display unit of the quantity calculation input system in an XML language format, Associate the definition of the table area input part of the quantity calculation input system with the work type data tree structure, enter the table definition part that outputs the definition result by XML editing, and multiple items that constitute the table area input part, and the definition An item definition unit for editing and outputting the result in XML, a calculation formula for deriving the calculation result, and a calculation formula defining unit for editing and outputting the definition result are provided. The graphic information definition unit and the quantity A second feature is that a quantity calculation definition system is provided for inputting data in XML language format from the calculation tree editing section, table definition section, item definition section, and formula definition section to the quantity calculation system. To.

  Furthermore, in the construction estimation system, the present invention provides a construction unit price database for storing a unit price for each construction component of construction, a unit price database for storing unit prices of parts, and the construction unit price database and unit price database according to arbitrary conditions. A third feature is that a construction integration system including an integration unit that calculates a unit price for each searched construction component and calculates a construction estimated price obtained by totaling the calculated unit prices for each construction component is provided.

  Further, the present invention relates to a construction estimation system including a client PC used by an end user, a Web server that receives a request from the client PC and returns a result of the request, and a database server that stores various data. The client PC includes a screen processing program for controlling screen display, a form printing program, and a database access program, and the Web server represents graphic information of a work type data tree structure display unit corresponding to a plurality of construction components. Related to figure data, quantity calculation tree information that represents work type data tree structure display definition corresponding to multiple construction components in XML language format, and table area input part definition corresponding to multiple construction components related to work data tree structure Calculation definition information that stores table definition information that represents the attached definition results in an XML language format A database and a print image creation program for converting the data into PDF print image data, wherein the database server performs quantity calculation reference data corresponding to a plurality of construction components, and quantity calculation corresponding to a plurality of construction components. A quantity calculation result database that stores quantity calculation formula data of calculation formulas and generation definition information of a design document corresponding to a plurality of construction components is provided, and a Web server receives a request from the client PC and the quantity calculation definition information database Referring to the graphic information, quantity calculation tree information, and table definition information defined in the above, the database server's quantity calculation result database is accessed, and the retrieved data is converted to PDF print image data by the print image creation program. To return to the client PC And butterflies.

  As described above, the construction estimation system according to the present invention stores various data of the quantity calculation system for calculating the quantity of construction including a plurality of construction components necessary for construction estimation as an XML language data format corresponding to the plurality of construction components. By displaying and displaying, it can be realized in a Web system in a so-called open platform environment that does not depend on the model of the client computer used by the user for the construction quantity calculation work and the prerequisite software (OS or the like).

  Hereinafter, a construction estimation system including a construction quantity calculation system and a quantity calculation definition system according to an embodiment of the present invention will be described in detail with reference to the drawings. FIG. 1 is a configuration diagram of a construction estimation system including a construction quantity calculation system and a quantity calculation definition system according to the present embodiment and a work accumulation system for subsequent operations. FIG. 2 is a system configuration diagram of a Web type construction estimation system according to the present embodiment. 3 is a display example of the quantity input screen according to the present embodiment, FIG. 4 is a display example diagram of the quantity calculation definition screen according to the present embodiment, FIG. 5 is an explanatory diagram of the processing outline of the construction quantity calculation system, and FIG. FIG. 7 is an explanatory diagram of a quantity calculation definition file, FIG. 8 is an explanatory diagram of automatic generation of integrated data, FIG. 9 is an explanatory diagram of a database access method, FIG. 10 is an explanatory diagram of a form edit output process, and FIG. 11 is a quantity calculation form output example diagram, and FIG. 12 is a quantity calculation basis output example diagram.

As shown in FIG. 1, the overall concept of the construction estimation system that is the object of the present embodiment is a construction quantity calculation system for inputting quantity calculation data such as the construction extension value described above using a quantity calculation input screen 201; A quantity calculation definition system for registering definition information for calculating an estimate based on the quantity input by the construction quantity calculation system, and a work for calculating a construction estimate based on the quantity calculation definition system and the quantity calculation definition system Consists of an integration system.
<Quantity calculation system>

  The quantity calculation system is for inputting the quantity of elements (persons, objects) constituting the construction to be input to the subsequent construction integration system, and the quantity calculation input screen 201 for entering quantity data is quantity calculated. Various types of data are input while being displayed on the input unit 11, and a quantity calculation reference database 213 for storing quantity calculation reference data corresponding to a plurality of construction components in an XML language format, and a calculation formula for quantity calculation in XML Quantity calculation formula database 214 stored in language format, design document generation definition database 215 for storing design document generation definition information in XML language format, and quantity calculation form for storing quantity calculation book definition information in XML language format XML database that is a program for analyzing and evaluating the XML language stored in the definition database 216 and the database 213 212, a quantity calculation input database 202 for storing various types of quantity calculation input data input using the screen 201, a quantity calculation unit 12 for performing quantity calculation using the various input quantity calculation input data, A quantity calculation result database 209 for storing quantity calculation result data calculated by the quantity calculation unit 12, and an output for printing out the quantity calculation sheet 120 and the like based on the calculation result data and input data stored in the database 209 and the database 202. Section 13, database 207 for storing the model work tree structure (model data tree structure) of the model, database 208 for storing correspondence table information of unit prices and reference codes, and calculation results stored in the database 202/209/207/208 / Estimate work based on various data such as input data / design document / model / unit price A design document generation unit 203 that generates a design document that is important data, and an XML (eXtensible Markup Language) format that is advantageous for holding structured data from the design document data generated by the design document generation unit 203, for example And a database 206 that stores the description of the quantity calculation definition file as shown in FIG.

  As shown in detail in FIG. 3, the quantity calculation input screen 201 displays a tree structure 01 in accordance with the construction system on the left side, and inputs from the whole construction to the details using this column. The item 02 for inputting individual detailed information in the table area (usually, one row of this table is a unit of a section with construction), and the item 02 for inputting the detailed information is an item of the left tree structure 01 is associated with the tree type, and this detailed information is defined in the quantity calculation reference data.

  In particular, the quantity input screen shown in FIG. 3 refers to the quantity calculation input tree 01, making it possible to easily input a large amount of data sequentially while taking into account hierarchized construction elements. In addition, in the table input part 0, basic quantity data for each division of the minimum unit of construction, construction conditions (construction place is urban area, mountainous area; construction is daytime, nighttime; soil is soft soil, hard soil) and materials ( (Diameter of 200mm, 250mm) can be input by real number input or list selection method. At this time, by displaying a graphic corresponding to this table input unit on the graphic display unit 03 in FIG. By confirming the depth, the covering length on the pipe, and the like, and drawing the figure based on the input value, it is possible to easily confirm an input error visually.

The quantity calculation unit 12 performs quantity calculation based on the quantity calculation data input via the quantity calculation input unit 11 and the quantity calculation formula definition defined in the quantity calculation definition system described later, and stores the quantity calculation result in the database. The quantity calculation document output unit 13 retrieves the quantity calculation input data and quantity calculation result data from the database, and based on the information in the quantity calculation form definition file defined in the quantity calculation definition system described later, the quantity calculation form output data is shown in FIG. Output of the quantity calculation form including various condition value data at the time of pipe installation, and the form calculation output of the quantity calculation basis form including the basis values such as the pipe installation extension distance as the basis for pipe installation as shown in FIG. In this way, a file in PDF format is generated so that it can be transferred to the Web browser and printing tool of the client PC for printing.
<Quantity calculation definition system>

  The quantity calculation definition system is a system for creating definition data such as a screen / form / database / calculation formula / automatic generation for operating the construction quantity calculation system, and a definition quantity calculation definition screen 15 for executing quantity calculation. A graphic information definition unit 16 that defines (associates) the display of the graphic display area of the quantity calculation input system, converts graphic information drawn by CAD or the like into a SVC file (format that can be displayed on the Web screen), and stores the graphic information , Input the definition of the tree display part of the quantity calculation input and edit the definition result in XML, and output the result by editing the XML, and associate the definition of the table area of the quantity calculation input system with the quantity calculation tree. The table definition unit 18 that edits and outputs the XML, and the items constituting the table area (input attribute, display attribute, database storage location, input check) An attribute definition, an SQI or a definition name for editing a selection input list at the time of input), an item definition unit 19 for outputting the definition result by XML editing, and for deriving a calculation result from the input item A calculation formula is defined (control structure normally used in a programming language [IF statement, etc.], the calculation formula describes a calculation formula corresponding to four arithmetic operations), and the definition result 20 is output by editing the XML. Form definition unit 21 for defining items (information for enabling form editing by associating with a table definition, item definition, and calculation formula definition) to be output to the quantity calculation sheet and the quantity calculation basis sheet, and a design document Information required for generation (unit price handled in construction integration and integration standard [construction unit price] are attached with a code. By specifying this code, information such as name, unit / unit price / amount can be specified. Co Define the input data entered in the input and quantity calculation input, the information that associates the calculation result calculated in the quantity calculation and its code), and the generated information definition section 22 that performs XML editing output of the definition result, and the file output in XML format Since most of the input data in the quantity calculation standard output unit 23 for outputting the definition contents to be defined as the quantity calculation standard document 221 and the above-mentioned quantity calculation definition is link information between the definitions, It includes a definition relation check unit 24 that performs an association check upon deletion or copying and outputs an error check list 222, and a database 220 for storing XML information from the parts 16-22.

  The definition quantity calculation definition screen 15 is a display example of a quantity calculation definition screen for defining various types of data as shown in detail in FIG. A tree display expressed using the descriptiveness of the XML language showing a data (definition) file with a structure such as the middle and leftmost hierarchies, a tree display in which the central definition item is hierarchized, and the rightmost items It includes a display unit for inputting definition information, and displays a dedicated definition screen 06 for facilitating operations such as linking and assembling calculation formulas by referring to contents defined elsewhere.

The contents defined by the system are stored in the database 220 in an XML format advantageous for holding structured data. This data format is described in, for example, the XML language shown in FIG. For example, as shown in FIG. 6, the definition contents stored in the database 216 include a tree 61, a common selection list 62, a common selection formula 63, and a common constant table 64 as shown in the structure explanatory diagram of the quantity calculation definition in FIG. Each of the definition structure areas of the input table consisting of a table attribute 65, a selection list 66, a calculation formula 67, a constant table 68, and diagram information 69. 1 corresponds to the graphic information definition unit 16 to the generation information definition unit 22 in FIG.
<Construction construction system>

The construction totalization system displays the totalization tree and detailed information of the schedule automatically generated by the quantity calculation on the screen, and allows additional input of unstructured construction elements that could not be entered for quantity calculation / deletion of excess data. The construction unit cost program 25 to be executed, the construction unit price database 216 for storing the unit price for each construction work, the unit price database 217 for storing the unit price of parts, etc. The database 216 and the unit price database 217 are searched to calculate a unit price / amount based on the input conditions, total the details, and an integration unit 26 that calculates the construction price. This accumulating unit 26 calculates indirect costs (site management costs, general management costs), etc., calculates the expected price for public construction bidding, and works that include quantity and amount information in each element (detail) of the construction The integrated design document can be edited and output.
<Web system configuration>

  The overall concept of the construction estimation system according to the present embodiment is as described above. A system configuration when the construction estimation system is a Web service type construction estimation system will be described with reference to FIG.

  This Web service-type construction estimation system has the features of a Web browser that is good at homepage browsing (easily introduced and features openness) and high operability that makes data entry / editing of basic systems and office systems convenient. It is possible to take advantage of both of the realized (C / S type) GUI and to eliminate both disadvantages as much as possible, roughly divided into a plurality of client PCs 30 used by end users and the client It consists of a Web server 31 that is a server computer that receives a request from the PC 30 and returns the result, and a DB server 32 that is a computer that stores data used in the present system.

  The client PC 30 includes a SWING 33 which is a middle software for performing GUI (rich client method) display suitable for data input / editing and the like realized in a C / S (client / server type) system, and a program of this system. A version management program (JWS) 34, which is middle software that performs an automatic download by making an inquiry to the program library 39 of the web server 31 when newly activated or updated, and the SWING 33 and the JWS 34 are activated from a Web browser. A screen processing program 35 for controlling the corresponding screen display, a database access interface program 36 for causing HTTP (communication protocol) called HTTP tunneling to exchange all data, a Web server A form printing program 37 for converting a form image edited on the side of the server 31 into the most common PDF format as a web-related form output and enabling reference (preview) and printing on the client PC 30; Java [registered trademark] virtual machine (JAVA [registered trademark] VM) 38 which is a program created so that the same program can operate without depending on the environment such as model / OS / related software type / version Prepare.

  The Web server 31 receives a processing request notified to the Web server 31 in response to an instruction from the client PC 30 and a program library 39 for storing data and programs for automatic download by the JWS 34 described above. The quantity calculation processing program 40 that reads various definition information of access and quantity calculation, edits the data displayed on the screen, returns the data to the client PC 30 / processes the quantity calculation, and writes the result into the database. Web server 31 communicates with client PC 31 in accordance with the HTTP protocol, receives transmission from the requesting client, and receives the transmission from the requesting client. No APATCH (or IIS) TOMCAT42, which is middle software that performs processing such as starting a program and returning the output result of the server-side program to the requesting client, definition data for outputting the form, and the quantities described in FIG. A form format / DB access information database 43 for storing data defined by the calculation definition system, and a form editing program 44 for converting a form image into a PDF format are provided.

  Further, the database (DB) server 32 stores a batch program for generating quantity calculation input data / quantity calculation result data / design document generation, and controls the scheduler 46 that starts the batch program in response to a request from the Web server 31. A control database (DB) 45 that stores information, a scheduler 46 that starts a design document generation program in response to a request from the Web server 31, and a quantity calculation that stores input data and calculation results of a quantity calculation input system Results database (DB) 47, integrated data automatic generation unit 48 for executing a design document generation program, integrated database (DB) for storing design document / unit price / integration standard (construction unit price), etc., which are input to the construction integration system 49.

The construction estimation system configured in this way is a version management program (JWS: Java [registered trademark] WebStart) 34 and a Java [registered trademark] virtual machine (Java [registered trademark] VM) as a web service type construction quantity calculation system. By using 38, it is possible to realize centralized management of the program on the WEB server at the time of program change / modification / automatic update of the program to the client PC 30, and the client PC 30 can be used in an open platform environment. In addition, since this system uses the SWING 33 that performs GUI display, it is possible to realize a complicated screen display and operability improvement that cannot be realized by a system using a conventional general-purpose browser. Therefore, this system can significantly reduce the operation cost required for system maintenance management (installation, version upgrade, conflict confirmation between software, etc.) of the client PC 30.
<Automatic data generation>

  Now, an automatic generation method of integrated data by the construction estimation system according to the present embodiment will be described with reference to FIG.

The automatic generation of integrated data according to the present embodiment is performed by the following steps (a) to (o). In addition, the code | symbol ao in a figure respond | corresponds with the following.
(A) First, the system reads the quantity calculation tree definition (XML data) defined by the quantity calculation definition system described above, and displays the quantity calculation tree section 301.
(B) Next, the graphic file converted into the screen display format (SVG) is read, and the graphic display unit 302 for quantity calculation is displayed. This display figure can designate a figure to be displayed in table units / table rows by setting the quantity calculation definition system.

(C) Based on XML (definition information) defined by the quantity calculation definition system, a plurality of items are arranged, a table input unit 303 which is a quantity calculation table area is displayed, and the screens indicated by the reference numerals 301 and 302 are displayed. It is displayed as an included quantity calculation input screen 201. The table input unit 303 can change the figure by changing the numerical value (the SVG file value of the graphic drawing file) input to the item. These screen definitions describe the SQL language for reading from the database, and correction / update is performed by reading from the database. In addition, when a user inputs an item for which a selection list is prepared, selection display and selection input can be performed, and the input numerical value is checked according to the definition contents, such as range / minority presence / absence.
(D) In the figure display section 302, as shown by the symbol d, in the case of sewer quantity calculation, a vertical section representing the depth of pipe embedment from the ground is displayed in span (between manholes) units. Each row of the display / input unit 303 is information in units of spans, and a figure d is displayed for each span. Further, the spreadsheet tree unit 301 displays a member structure / vinyl chloride member / resin member / secondary pipe / saddle / mounting pipe as a tree structure as a member necessary for the construction work, for example, a member required for the hole entry work. To do.

(E) Similarly, the graphic display unit 302 displays a cross-sectional composition diagram of each layer of the road including a road excavation diagram and a restoration diagram at the time of construction as indicated by a symbol e. This figure is necessary to calculate the material and volume of each layer when pavement is restored.
(F) The pipe diameter in the figure can be changed by selecting and inputting the inner diameter of the display unit 303 from the pipe diameter list 306. The tube diameter list 306 is created in advance using a quantity calculation definition system, or is created by defining a search SQL of a database stored in a selection list.

(G) The present system selects or inputs the mathematical expression “soil volume on pipe = extension × overburden / 100H01 (pipe type)” indicated by the symbol g based on the pipe length (referred to as extension) / pipe diameter, etc. Is used to calculate the soil volume g on the pipe as an intermediate value. The calculation formula is defined as a skeleton by the quantity calculation definition system, and depending on the value of the input item value / selection input of the construction conditions, a table format called a probation table 305 depending on the value as shown in H01 (tube type) The data is referred to obtain a value, which is used for calculation.
(H) Next, in the example of the sewer quantity calculation, for example, each line of the table input unit 303 is input in units of spans, so that this system calculates the total number of pipes / the amount of excavated soil. The amount of soil g is totaled to calculate the amount of soil h on the Σ (total) pipe. This mathematical expression can also describe programmatic control such as an IF statement. Furthermore, since a plurality of lines can be described, a calculation expression can be evaluated using a conditional expression.

(I) The symbol i in the figure indicates determination of the condition for counting the amount of soil on the pipe, and is set as, for example, “intermediate value> AND”.
(J to k) Next, in this system, it is necessary for the system to count the same conditions in the construction quantity calculation. A classification (counting) key for that purpose is set, and the rounding processing condition k of the calculation result is set. Is specified.
(L) This system generates integrated design document data based on the aforementioned quantity calculation input data (DB 202) and quantity calculation result data (DB 209). This integrated design document data is displayed at the left end of the integration screen 25 and is composed of the breakdown header and breakdown details in the table 311, and displays the integration breakdown details on the right side of the integration screen 25. The construction conditions for the calculation are the construction conditions such as quantity / unit price / money in the construction unit cost integration shown diagonally to the lower right of the integration screen 25, and this quantity calculation system also provides the condition values for these construction conditions. Generate.

(M) The system embeds the construction elements calculated / aggregated in the above-described quantity calculation in this integrated work type tree template (skeleton), and generates an integrated work type tree 309 completed as integrated design document data.
(N) In the definition in this quantity calculation definition system, the tree code 310 for linking the information on where to generate on the integrated design document tree with the integrated work tree 309 is specified.
(O) In the quantity calculation definition system according to the present embodiment, if the generation destination is the same and the code and the condition are the same, the quantities are added and collected in one line.

As described above, the construction estimation system according to the present embodiment according to the present embodiment includes a numerical calculation input screen including a specific graphic display unit 302 and a table input unit 303 based on the construction execution conditions input or selected using the screen 25. By displaying 201 and inputting various conditions that need to be changed using the table input unit 303, the integrated design document data can be automatically generated. In particular, in the present embodiment, by displaying a tree structure representing the relationship between necessary members and the like corresponding to the construction work displayed on the screens 25 and 201, the operator can visually check the relationship with the necessary members and the like. Can be easily understood, and errors such as member leakage at the time of creating the integrated design document data can be reduced.
<Client side access procedure>

  Next, a procedure for accessing the quantity calculation result database 47 from the client side via the WEB server side in the Web service type construction quantity calculation system (FIG. 2) according to the present embodiment will be described with reference to FIG.

  In this procedure, first, the screen processing program 35 of the client 30 calls the database access interface program 36, and this database access interface program 36 sends to the TOMCAT APATCH (or IIS) 42 of the WEB server 31. The HTTP request carrying the database access request is made, and the TOMCAT APATCH (or IIS) 42 receiving the request notifies the control program 95 of the request.

  Upon receiving this request, the control program 95 notifies the database access program 50 of a database access request from the client side, and then the program 50 sends a database access request from the client 30 side to the database server 32. To start access to the quantity calculation result database 47.

  Result data (or read data) that is a response to the quantity calculation result database 47 is converted into the XML format with reference to the quantity calculation definition information XML database 41, and the database access interface program 36 on the client PC 30 side. Is sent back to the screen processing program 35 as an HTTP response.

  Therefore, the Web service type construction quantity calculation system according to the present embodiment converts the response to the request to the quantity calculation result database 47 from the screen processing program 35 into the XML format using the quantity calculation definition information XML database 41 and performs screen processing. By providing it to the program 35, it is possible to provide information that allows the operator to visually confirm the tree structure. An “HTTP request” is a request from a client to a WEB server using HTTP (Hyper Text Transfer Protocol), which is a standard communication protocol when using the Web, and an “HTTP response” is also an HTTP ( This is return information for an HTTP request returned from the server to the client by Hyper Text Transfer Protocol).

In addition, since the construction estimation system according to the present embodiment is linked with a construction accumulation system that handles amount information related to public works bidding, it is necessary to prevent information leakage to the inside and outside of the organization that uses this system. By configuring the database access from the client PC 30 on the HTTP, HTTPS (Hypertext Transfer Protocol Security) (tunneling) and relaying it to the database server 32 via the WEB server 31, Security can also be ensured.
<Form edit output process>

  Next, the form edit output process in the construction estimation system (FIG. 2) will be described with reference to FIG. In this construction estimation system, as shown in FIG. 10, when the form printing program 37 of the client PC 30 transmits an HTTP request as a print request to the Web server 31, the APATCH or IIS 42 of the Web server 31 receives the request, and The editing program 44 is activated, and the form editing program 44 reads the form format information and database search information (XML) from the database 41, and sends the read form format information / data to the quantity calculation result database 47 on the database server 32. The search is executed using the SQL (machine) language assembled based on the database search information (XML).

  Next, in this system, the print image creation program 102 creates a print image (PDF) based on the data retrieved from the quantity calculation result database 47 and sends it back to the APATCH or IIS 42. As a response, the print image is returned from the form printing program of the client PC 30 and the quantity calculation sheet (FIG. 11) and the quantity calculation basis sheet (FIG. 12) are printed.

As described above, the construction estimation system according to the present embodiment converts the print data obtained from the database server 32 by the form editing program 44 of the Web server 31 into the PFD print format using the print image creation program 102 and returns it to the client PC 30. Therefore, the quantity calculation sheet and the quantity calculation basis sheet can be printed using a generally distributed PDF reader program without preparing a special printing program on the client PC 30 side. The quantity calculation sheet converted into the PFD printing format can be displayed on the screen on the Web server 31 and the client PC 30 by the PDF reader program.
<Overall description>

  As described above, the construction estimation system according to the present embodiment outputs the contents defined in the system by the quantity calculation standard document output unit 23 as a quantity calculation standard document, so that the calculation contents can be changed / inspected. The definition-related check unit 24 checks the consistency of the link information of the contents defined in this system and outputs a check result list form, so that the definition contents can be updated when the definition is initially created / revised / changed. It can be used as material for validity confirmation, and the design document (integrated) data generated by the design document generation unit 14 is displayed without conversion, and construction elements that were not generated by the work quantity calculation system are added. By having an input function, the data generated by the construction quantity calculation system can be changed, and the integration unit 26 calculates the construction unit price data / unit price for calculating the amount. Labor / material costs, including the minimum unit of work from over data and design specifications data, by performing up expenses calculation of administrative costs, etc., can be carried out up to the calculation of the total planned construction price from the calculation of the detailed specification.

  Therefore, the construction estimation system according to the present embodiment is a feature of the construction quantity calculation system, which is a large number of input data / calculation processing ranging from hundreds to thousands of frequent database / Improve processing performance (calculation, form editing / output) by accessing and appropriately sharing processing of large output forms of tens to hundreds of pages with client PC 30, WEB server 31, and database server 32 can do.

  In particular, the construction estimation system according to the present embodiment uses the XML data having a hierarchical structure to create a construction quantity calculation document and construction integration data, which are the product of the construction quantity calculation system, on the construction quantity calculation input screen 201. As the most suitable input means, tree structure (tree) display showing the hierarchical structure of quantity data, basic quantity data input in tabular format, construction condition selection input, confirmation of the meaning of input values and input items and input data By simultaneously displaying the three graphic display screens that can be visually checked for validity, it is possible to input quantity data efficiently, and work while sequentially inputting data using a tree structure (tree) display and checking the graphic display. Can create quantity calculation and generate total data.

1 is an overall configuration diagram of a construction estimation system according to an embodiment of the present invention. The system block diagram of the web type | mold construction estimation system by this embodiment. The figure which shows the example of a display of the quantity input screen by this embodiment. The figure which shows the example of a display of the quantity calculation definition screen by this embodiment. Processing outline explanatory drawing of the construction quantity calculation system by this embodiment. Structure explanatory diagram of this quantity calculation definition. The figure which shows the example of a description of this quantity calculation definition file. Explanatory drawing of the integration data automatic generation by this embodiment. Explanatory drawing of the access method to the database by this embodiment. Explanatory drawing of the form edit output process by this embodiment. The quantity calculation form form output example figure by this embodiment. FIG. 6 is a diagram illustrating an example of a quantity calculation basis document output according to the present embodiment.

Explanation of symbols

  11: Quantity calculation input unit, 12: Quantity calculation unit, 13: Quantity calculation document output unit, 14: Design document generation unit, 15: Definition quantity calculation definition screen, 17: Quantity calculation tree editing unit, 18: Table definition unit, 19: Item definition unit, 20: Calculation formula definition unit, 21: Form definition unit, 22: Generation information definition unit, 23: Quantity calculation standard output unit, 24: Definition related check unit, 25: Construction integration program, 26: Integration unit, 30: client PC, 31: Web server, 32: database server, 35: screen processing program, 36 database access interface program, 37: form printing program, 39: program library, 40: quantity calculation processing program , 41: form format information database, 43: access information database, 44: form editing program, 46: schedule Jura, 47: Quantity calculation result database, 48: Integrated data automatic generation unit, 102: Print image creation program.

Claims (4)

A construction estimation system including a quantity calculation system for calculating a construction quantity including a plurality of construction components, wherein the quantity calculation system stores quantity calculation reference data corresponding to the plurality of construction components in an XML language format. Quantitative calculation base database, quantity calculation formula database for storing quantity calculation formulas in XML language format, design document generation definition database for storing generation definition information of design documents in XML language format, and each database An XML parser that analyzes the XML language, and the XML parser analyzes the data in the XML language format stored in each database, and displays the construction component data tree structure display in a hierarchical tree structure Part, table area input part for entering construction conditions, materials and construction basic quantity for construction components, and input data Construction estimate system and displaying the quantity input screen including a graphic display unit for displaying a figure for performing implications and validity checked visually. 2. The construction estimation system according to claim 1, wherein a graphic information defining unit for storing graphic information, a quantity calculation tree editing unit for outputting a definition result of the work data tree structure display unit of the quantity calculation input system in an XML language format, and a quantity Associating the definition of the table area input part of the calculation input system with the work data tree structure, inputting a plurality of items constituting the table area input part, a table definition part for outputting the definition result by XML editing, and the definition result An item definition part that edits and outputs XML and a calculation formula for deriving a calculation result and a calculation formula definition part that outputs the definition result by XML editing are provided. The graphic information definition part and the quantity calculation A quantity calculation definition system is provided for inputting XML language format data from a tree editing section, a table definition section, an item definition section, and a calculation formula definition section to the quantity calculation system. Quotation system. The construction estimation system according to claim 2, wherein a construction unit price database for storing a unit price for each construction component of construction, a unit price database for storing unit prices of parts, etc., and the construction unit price database and unit price database are subject to arbitrary conditions A construction estimation system comprising: a construction integration system including an integration unit that calculates a unit price for each construction component searched by the above and calculates a construction estimated price obtained by totaling the calculated unit prices for each construction component. A construction estimation system comprising a client PC used by an end user, a Web server that receives a request from the client PC and returns a result of the request, and a database server that stores various data.
The client PC includes a screen processing program for controlling screen display, a form printing program, and a database access program.
Quantitative calculation in which the Web server expresses graphic information representing the graphic information of the work type data tree structure display unit corresponding to a plurality of construction components and the work data tree structure display definition corresponding to the plurality of construction components in an XML language format A quantity calculation definition information database that stores tree information, table definition information that associates a table area input section definition corresponding to a plurality of construction components with a work type data tree structure, and that represents table definition information in an XML language format, and data A print image creation program for converting to PDF print image data,
The database server includes quantity calculation reference data corresponding to a plurality of construction components, quantity calculation formula data of a quantity calculation formula corresponding to a plurality of construction components, and a design document corresponding to a plurality of construction components. It has a quantity calculation result database that stores generation definition information.
In response to a request from the client PC, the Web server refers to the graphic information defined in the quantity calculation definition information database, the quantity calculation tree information, and the table definition information, and accesses and searches the quantity calculation result database of the database server. A construction estimation system characterized in that converted data is converted into PDF print image data by a print image creation program and returned to a client PC.

Images