JP2000155781A - Estimation sheet generation system for construction cost - Google Patents

Abstract

PROBLEM TO BE SOLVED: To speedily and accurately generate an estimation sheet for construction cost without generating a design drawing and to easily generates an estimation sheet again at the time of specification changes or the like of a building. SOLUTION: This estimation sheet generation system has a specification setting file to which data determining the specifications of a building are inputted, a material and parts data file containing the names of materials and parts fitted to respective rooms and construction quantities of construction for fitting the materials and parts, a construction unit-price file, and a special construction estimation sheet file. The data inputted to the specification setting file are stored as data determining the specifications of the building. According to the data determining the specifications, construction quantities by the special construction by the rooms are calculated. The calculated construction quantities are integrated by the special construction and the construction cost is calculated from the integrated construction quantities and the construction unit-price file and recorded in the special construction estimation sheet file.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for preparing a construction cost estimate, and more particularly to, for example, determining the specifications of each room such as a Japanese-style room, a Western-style room, and a corridor provided in a building structure and a building. The present invention relates to a construction cost estimate creation system capable of creating an estimate of a construction cost by going there.

[0002]

2. Description of the Related Art Conventionally, in order to create a building construction cost estimate, a building design drawing is created based on the contents interviewed by a customer, and then the quantities of materials and parts to be used are read from the design drawing. In addition, estimates were made by manually calculating the costs of materials and parts used and the costs of incidental works. Or, after creating a design drawing by CAD system, C
Using the estimate creation function incorporated in the AD system, an estimate of the construction cost was created.

[0003]

However, when the quantity of materials and parts to be used is read from a design drawing and an estimate is created by manual calculation, the work of creating the design drawing,
Work to read the quantity of materials and parts to be used from design drawings,
A lot of work had to be performed, such as searching for the unit price table from a large number of unit price tables and picking up the unit price, and estimating the cost of materials and parts and the cost of incidental work. for that reason,
It was very inefficient and was unable to generate a quote quickly. In addition, creating an estimate using this method requires considerable knowledge of architectural design and building equipment work and experience in estimating work. Was unable to prepare a quote. Furthermore, since all the work is performed by a person, there have been problems such as a difference in the estimated amount depending on a person who creates the estimate, and a mistake in the estimated amount due to a calculation error or the like.

[0004] In addition, when creating an estimate using the estimate creation function incorporated in the CAD system, it is necessary to first create a design drawing of the building. Could not. Naturally, in order to create a design drawing of a building, it was necessary to master the architectural design, so that a person who did not master the architectural design could not create a quote.

[0005] The above-described problem also occurs when a quote is created again due to a change in the specification of a building or the like. Therefore, when the case studies are repeated, it takes time to prepare an estimate, and in the worst case, problems such as delay of the construction start are caused.

Accordingly, it is an object of the present invention to quickly and accurately create an estimate of a building construction cost without preparing a design drawing, even for a person who is not familiar with architectural design and the like or who is unfamiliar with estimation work. It is an object of the present invention to provide a construction cost estimate creating system which can easily create an estimate even when a quote is created again due to a change in the specification of a building.

[0007]

According to a first aspect of the present invention, there is provided a building construction cost estimate creating system including a central processing unit, a storage device, and an input device, wherein the storage device includes a The specification setting file for inputting data that determines the specifications of the building structure and each room, the names of the materials and parts to be installed in each room, and at least the amount of various types of construction work required to install the materials and parts It has a material / parts data file stored in association with it, a construction unit price file that stores the unit price of each construction per unit construction volume, and a specialized construction estimate file group that has form data for each specialized construction category. The device displays the contents of the specification setting file on the display device, and stores in the specification setting file the data for determining the building structure of the building and the specifications of each room input by the input device. The first means, the second means for calculating the amount of work for each specialized work for each room based on the data for determining the building structure of the building and the specifications for each room, and the second means The construction cost calculated by summing up the work volume for each specialty work in each room for each specialty work, calculating the construction cost based on the totaled work volume and the unit price of the construction unit price file, and calculating the cost in the specialty work estimate file Is a building construction cost estimate creation system characterized by having a third means for storing According to the first aspect of the present invention, the amount of construction for each room is calculated, and the construction cost for each specialized construction is accurately calculated based on the calculated value.

According to a second aspect of the present invention, the third means includes:
Fourth means for calculating the total wall area of the room for each floor, fifth means for calculating the outer wall area for each floor, and total room area for each floor calculated by the fourth means and the fifth means By dividing the value obtained by adding the outer wall area and the outer wall area for each floor calculated by the integer 2 and subtracting the outer wall area for each floor calculated by the fifth means from the divided value, the partition amount for each floor is obtained. The building construction cost estimate creation system according to claim 1, comprising: a sixth means for calculating. According to the second aspect of the present invention, the partitioning amount for dividing the room can be accurately calculated by calculating the total wall area of the room for each floor and the outer wall area for each floor.

The above and other objects, features and advantages of the present invention will become more apparent from the following detailed description of embodiments of the present invention with reference to the accompanying drawings.

[0010]

FIG. 1 is a block diagram showing the configuration of an embodiment of a construction cost estimate creating system according to the present invention, and FIG. 2 is a diagram showing files stored in a storage device. FIG. The construction cost estimate creation system 10 includes a CPU 12 which is a central processing unit. C
A ROM 14 is connected to the PU 12. ROM1
Reference numeral 4 stores a control program for controlling the input and output of data of the construction work cost estimate creation system 10.

A RAM 16 is connected to the CPU 12. The RAM 16 is for temporarily storing programs and data required for the CPU 12 to execute various processes. Further, an I / O interface 18 is connected to the CPU 12. I
The / O interface 18 is an interface for inputting and outputting data between the CPU 12 and an external device, and has a plurality of terminals (not shown).

The I / O interface 18 has a CRT
A display device 20 such as an LCD or an LCD, an input device 22 such as a keyboard and a mouse for inputting various data, an output device 24 such as a printer, and a storage device 26 such as a hard disk are connected at terminals. Have been.

As shown in FIG. 2, a customer data file 28, a plane plan file 30, a building data file 32, a building specification file 34, an internal finishing specification file 36, a room specification file group 38, A part data file group 40, a construction unit price file 42, and a specialized construction estimate file group 44 are stored.

These files can be roughly classified into two types of files: a file having only form data in which a form and a figure to be displayed and printed are set on the display device 20 and the output device 24; It can be classified into a file storing various data such as a name and a unit price as a database, and a file storing processing functions and form data which function as processing means when executed by the CPU 12. . The contents and functions of each file will be described later in the description of the operation of the present embodiment.

Here, the processing function will be described. The processing function is an arithmetic expression or a function used in a spreadsheet application for an arithmetic operation in a worksheet, a macro program attached to the spreadsheet application, or a spreadsheet application. An add-in application that is incorporated into an application by an external program. The processing function can execute processing as various processing means by changing the content of an arithmetic expression, a function, and a program. In this embodiment, the processing function mainly performs processing based on data input to each file. This is used to create desired data or to automatically input data to another file when data is input to an arbitrary file. In the present embodiment, form data is created on a worksheet of a spreadsheet application for ease of creation of processing functions and form data, and as a processing function, an arithmetic expression or function used in the worksheet is used. used.

The operation of this embodiment will be described below with reference to FIG. In addition. FIG. 3 is a flowchart showing an operation flow of the construction cost estimate creation system according to the present invention.

First, a construction work cost estimate creation system 1
0 indicates that immediately after startup, in step S1, the control program stored in the ROM 14 is executed by the CPU 12, and settings relating to data input / output are performed.

In step S2, the customer data file 28, the plane plan file 30, the building data file 32, and the building specification file 3 are stored in the storage device 26.
4. Internal finish specification file 36, room specification file group 3
8. The material / part data file group 40, the construction unit price file 42, and the special construction estimate file group 44 are loaded into the RAM 16.

In step S3, settings relating to the structure of the building are made. As shown in FIG. 4, the setting in step S <b> 3 is performed by subdividing the setting of the size of the building and the setting of the structure of the building. In addition,
FIG. 4 is a flowchart illustrating a flow of setting related to the structure of the building.

First, in step S31, the customer data file 28 is displayed, and data is input.
As shown in FIG. 5, the customer data file 28 includes data on the building coverage, floor area ratio, and site area, which are restrictions when constructing a building, as well as appropriately assigned customer code, customer name, address, and building. This file is used to input data such as the purpose of use, telephone number, and family structure. Although the customer data file 28 is a file having only the form data, as shown in FIG. 5, after each data is input,
The data is stored in the RAM 16 together with the input data. FIG. 5 is an illustrative view showing a customer data file.

In step S32, the plane plan file 30 is displayed, and data is input. As shown in FIG. 6, the plane plan file 30 is a file for inputting data for setting the plane shape of each floor of the house. Like the customer data file 28, the plane plan file 30 is a file having only the form data. However, as shown in FIG. 6, after each data is input, the data is stored in the RAM 16 together with the input data. You. FIG. 6 is an illustrative view showing a plane plan file.

In step S33, the building data file 32 is displayed, and data is input. As shown in FIG. 7, the construction data file 32 includes the frontage and depth of a penthouse provided in a building, the area of a stairwell on each floor, the frontage and depth of a veranda provided on two or more floors, and the parking lot provided on the first floor. This is a file for inputting area data. As described above, the construction data file 32 includes, in addition to the data on the frontage and depth of the penthouse, the area of the stairwell on each floor, the frontage and depth of the veranda provided on the second floor or more, and the area of the parking space on the first floor, the site area, Items are provided in the form data so that the floor area, construction total floor area, internal available area, site area, and the like are input. However, other than the above-described items, no data is input. Data for items for which no input has been specified is stored in the building data file 32
Of the building data file 32, or input to another file such as the customer data file 28 or the plane plan file 30 by the processing function mounted in the form data. Entered by referring to the data.

For example, with respect to the data of the floor area, the processing function refers to the data input to the plane plan file 30 and the building data file 32, and
"Front of the first floor * Depth of the first floor + Frontage of the second floor * Depth of the second floor +
The CPU 12 executes an arithmetic expression expressed by "the frontage of the third floor * the depth of the third floor + the frontage of the penthouse * the depth of the penthouse-the area of the stairwell of each floor-the area of the first floor parking lot" by the CPU 12 to obtain the data of the floor area. It has been processed to be entered.

Also, since the data of the site area has already been entered in the customer data file 28,
The data is processed by a processing function so as to be input as the data of the site area of the building data file 32.

The customer data file 28 is shown in FIG.
As shown in (1), after data is input by a code input or a processing function, the data is stored in the RAM 16. In addition, FIG.
It is an illustrative view showing a building data file.

In step S34, the building specification file 34 is displayed, and data is input. As shown in FIG. 8, the building specification file 34 is a file used to input data on the structure of the building and the materials to be used. The input of data to the building specification file 34 is based on the number of columns on each floor and the height of the roof.
This is done by entering a numerical value. The other items are processed by the processing function so that the data of the database 34a stored in the building specification file 34 is input as the data of each item. FIG.
FIG. 3 is an illustrative view showing a form data of a building specification file;

As described above, in addition to the form data shown in FIG. 8, data for determining the structure of the building as shown in FIG. 9 is stored in the building specification file 34 as the database 34a. Then, by inputting a predefined code in the “input” field of the displayed form data, data to be input in the “shape” field is input with reference to the database 34a. More specifically, it is defined so that any one of the data arranged at the same line position as the form data line shown in FIG. 8 is input, and the column of the database 34a shown in FIG. Is input, the data of the selected column is input in the column of “shape”, and the structure of the building and the material data to be used are determined. The input data is stored in the RAM together with the form data of the building specification file 34.
16 is stored. FIG. 9 is an illustrative view showing a database recorded in the building specification file.

Subsequently, in step S4, specifications for each room such as an entrance, a Western-style room, a Japanese-style room, and a corridor in the building are set, and the amount of work for each specialized work item in each room is calculated. . Hereinafter, description will be made with reference to FIG. FIG. 10 is a flowchart showing an operation flow for calculating the amount of work.

First, in step S41, the internal finish specification file 26 is displayed, and data is input. As shown in FIG. 11, the internal finish specification file 26 is a file for determining specifications of floors, walls, ceilings, and the like in each room provided inside the building. Data is input to the internal finish specification file 26 using a code in an input field 27 provided in the form, as in the building specification file 34. Each code is associated with a database provided at the top of each column, or a database (not shown) stored in an invisible manner in the input field 27. Processing is performed by the processing function so that the determined data is input.
In addition, the interior finish specification file 26 includes the floor of each room,
In addition to the input of the material data determined for the walls and ceiling, etc., the form data is provided with items so that the data of the number of floors and the used space of each room is input. Data input by code input is not performed.
These items are input by a processing function when data is input to a room specification file group 38 described later. Then, the input data of each item is stored in the RAM 16 together with the form data of the internal finish specification file 26. FIG. 11 is an illustrative view showing an internal finish specification file.

Next, in step S42, the group of room specification files 38 is appropriately displayed, and after inputting data for each item, the amount of construction for each specialized construction in each room is calculated. As shown in FIG. 12, the room specification file group 38 includes a storage room specification file 38a, a staircase specification file 38b, a unit bath specification file 38c, a bathroom toilet specification file 38d, and a toilet, as shown in FIG. Specification file 38e, kitchen specification file 38f, Japanese-style specification file 38g, Western-style specification file 38h, entrance / porch specification file 38i, living specification file 3
8j, a corridor / hall specification file 38k. Although the data input in each of the configuration files 38a to 38k is different, the process of restricting the calculation conditions in order to calculate the amount of work required for providing each room is the same. This will be described by taking 38a as an example. FIG. 12 is an illustrative view showing a configuration of a room specification file group.

FIG. 13 is an illustrative view showing a part of a storage room specification file. The storage room specification file 38a includes the number of floors of the storage room provided in the building, the size of the storage room, the door opening specification,
That is, it is a file for inputting data for determining the specification of the door provided in the storage room and the specification of the external opening, that is, the specification of the window. The input of data to the storage room specification file 38a is performed using a code in an input column 39 provided in the form, similarly to the building specification file 34 and the like. Each code is stored in a database (not shown) provided in an invisible state in the input item, or a wooden fitting data file 40h and a metal fitting data file 40f which are constituent files of the material / part data file group 40. , And by inputting an appropriate code,
Data is entered in the input item. Note that, for other items, data input to the storage room file specification file 38a or data input to other files is appropriately used and input.

Here, the material / part data file group 40
The material / part data file group 40
Is a file that stores the names of materials and parts used in building construction, data on the unit price and size of the materials and parts, and the amount of work required to install the materials and parts, as a database. Yes, in addition to the wooden fitting data file 40h and the metal fitting data file 40f described above, as shown in FIG. 14, a lighting fixture data file 40a and a unit bus data file 40
b, vanity room data file 40c, toilet data file 40d, kitchen data file 40e, entrance door data file 40g, clog box data file 40
i, storage space data file 40j, floor space data file 40k, ready-mixed concrete data file 40l
It is composed of FIG. 14 is an illustrative view showing the configuration of a material / part data file group.

Next, the process of calculating the amount of work required to install a storage room will be described. First, based on the data of the number of floors of the storage room and the size of the storage room inputted to the storage room specification file 38a, FIG. As shown in FIG. 15, it is defined as a closed box-shaped unit having no windows and doors, having the floor height entered in the building specification file 34 and the size entered in the door specification file 38a, The amount of construction required to install a storage room is calculated for each specialized construction item by the processing function. In addition, as shown in FIG. 16, the processing functions are mounted as arithmetic expressions (not shown) in the storage unit file specification file 38a as shown in FIG. FIG. 16 is an illustrative view showing another portion of the storage room specification file.

When data is input for the doors and windows provided in the storage room, as shown in FIG. 17, the work required to install the storage room as a unit having the storage room doors and windows is performed. The amount is calculated. In this case, the amount of work is calculated by reducing the amount of work by installing doors and windows from the amount of work calculated as a unit without windows and doors, such as vinyl cloth or metal for interior work. For the construction of items such as plaster board pasting, the size of the door or window to be installed is acquired from the wooden fitting file 40h or the metal fitting data file 40f, and the construction amount is subtracted by the size. In addition, about the construction amount of the construction which decreases by installing a door or a window, you may make it calculate a construction amount suitably by a processing function from the size of a door or a window, or may use the wooden fitting file 40h or The construction amount calculated in advance in the metal fittings data file 40f may be stored as a database, and the value may be used.

In addition, for the work that occurs due to the installation of doors and windows, for example, the work such as metal opening reinforcement, caulking, and mortar filling work required for installing the window, the wooden fitting file 40h and the metal The amount of construction that occurs is acquired from the fittings data file 40f and added. FIG. 17 is an illustrative view showing a unit provided with a door and a window.

The above description has been given with reference to the storage room specification file 38a as an example. However, the same processing is performed by the processing function for other configuration files constituting the room specification file group 38. That is, the amount of work in each room is firstly calculated as a closed box-shaped unit having no functional units such as doors and windows by the processing functions of the room specification file group 38 for each item of specialized work. Is calculated. When various functions are provided in a room such as a door, a window, a storage, a closet, a floor, etc., by providing them, the amount of work to be reduced is reduced and the amount of work is reduced. The generated work is processed by the processing function of each file so that the work amount is acquired from the material / part data file group 40 and added, and the work amount for each room is calculated. The data input to the room specification file group 38 and the value of each construction amount calculated by the processing function are stored in the RAM 16 together with the form data of each configuration file.

In step S5, the construction cost is calculated, and an estimate for each specialized construction is created. For the calculation of the construction cost for each specialized construction, refer to the specialized construction estimate file group 44
Temporary construction file, which is a configuration file not shown
Foundation work file, Steel work file, Roof work file, Exterior work file, Waterproof work file, Tile work file, Wood work file, Storage work file, Metal work file, Plastering work file, Painting work file, Fireproof covering work file, Interior Performed by construction files and miscellaneous and equipment construction files. In each file, the amount of construction is integrated for each item of specialized construction calculated by the room specification file group 38, and the construction cost is calculated for each item of specialized construction based on the construction unit price obtained from the construction unit price file 42. Is being processed by the processing function. The construction unit price file 42 is a file having a construction unit price per unit quantity of each construction as a database.

In the case of integrating the amount of construction, for the construction in which the amount of construction is determined by the amount of the partition provided for partitioning the room, if the area of the wall of each room is simply integrated,
Since it is impossible to calculate an accurate partition amount, it is not possible to calculate an accurate construction amount. Therefore, in the present embodiment, an accurate partition amount is calculated by the following method to obtain a construction amount.

First, using the height of each floor input to the building specification file 34 and the data of the size of each room input to the room specification file group 38, the total wall area of each room on each floor is calculated by a processing function. calculate.

Then, the data relating to the plane shape of each floor input to the plane plan file 30 and the height of each floor input to the building specification file 34 are used. The outer wall area of each floor is calculated by the processing function.

Further, using the values of the total wall area of each room on each floor and the outer wall area of each floor obtained by the processing function, "partition amount = (total wall area of each room on each floor + outer wall area of the corresponding floor) / 2"
-The amount of work is calculated by calculating the partition amount using the processing function expressed by the operation formula "the outer wall area of the corresponding floor." This means that each room is treated as a unit and the amount of work is calculated for each room. It is also possible to accurately calculate the amount of work for each specialty work.These processing functions are used in the specialty estimate file group 44 to calculate the partition amount for calculating the work amount. It is installed as appropriate in the configuration file that contains the necessary work.

Then, in step S6, the specialized construction estimate file group 44 is output by the output device 24, and the estimate of the construction cost is printed.

Note that the construction work cost estimate creation system 10 of this embodiment is set so that every time the input data is modified, the entire function is recalculated by the processing function. I have. As a result, even when a partial value of the data is modified due to a specification change or the like, an accurate estimate of the construction work cost can be calculated.

In this embodiment, in order to determine the structure of the building and the specifications of each room, the customer data file 28, the plan plan file 30, the building data file 32, the building specification file 34, the internal finishing specification The data was input using the file 36, the room specification file group 38, and the file subdivided for each decision item. However, the data input required to create an estimate regarding the building structure of the building and the specifications of each room was performed. However, the present invention is not limited to this, and a configuration in which the files are further subdivided may be adopted, and conversely, the files may be combined into a single configuration or a file configuration having a smaller number of files than in the present embodiment.

Further, in this embodiment, the material / part data file group 40 is stored in the lighting fixture data file 4.
0a, unit bath data file 40b, washroom data file 40c, toilet data file 40d,
Kitchen data file 40e, metal fittings data file 40f, entrance door data file 40g, wooden fittings data file 40h, clog box data file 40i,
The storage space data file 40j, the floor space data file 40k, and the ready-mixed concrete data file 40l are divided into files for each material category, but the files are not limited to this, and the file may be further divided.
Conversely, files may be combined into a single file or a file configuration with fewer files than in the present embodiment.

[0046]

As described above, according to the building construction cost estimate creating system according to the present invention, a design drawing of a building is created, and materials used and the amount of required work are manually calculated. By simply determining the building structure of the building and the size and specification of the room provided in the building, an estimate of the building construction cost can be created quickly and accurately. Further, even when the specification is changed, an accurate quote can be easily created only by changing the value of the input data.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a configuration of an embodiment of a building construction cost estimate creation system according to the present invention.

FIG. 2 is an illustrative view showing a file stored in a storage device;

FIG. 3 is a flowchart showing an operation flow of the building work cost estimate creation system according to the present invention.

FIG. 4 is a flowchart illustrating a setting flow regarding a structure of a building.

FIG. 5 is an illustrative view showing a customer data file;

FIG. 6 is an illustrative view showing a plane plan file;

FIG. 7 is an illustrative view showing a building data file;

FIG. 8 is an illustrative view showing a form data of a building specification file;

FIG. 9 is an illustrative view showing a database recorded in a building specification file;

FIG. 10 is a flowchart showing an operation flow of calculating a construction amount.

FIG. 11 is an illustrative view showing an internal finish specification file;

FIG. 12 is an illustrative view showing a configuration of a room specification file group;

FIG. 13 is an illustrative view showing one portion of a storage room specification file;

FIG. 14 is an illustrative view showing a structure of a material / part data file group;

FIG. 15 is an illustrative view showing a unit;

FIG. 16 is an illustrative view showing another portion of the storage room specification file;

FIG. 17 is an illustrative view showing a unit provided with a door and a window.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Building construction cost estimate creation system 12 CPU 14 ROM 16 RAM 18 I / O interface 20 Display device 22 Input device 24 Output device 26 Storage device 28 Customer data file 30 Plan plan file 32 Building data file 34 Building specification file 36 Internal finishing Specification file 38 Room specification file group 40 Material / part data file group 42 Construction unit price file 44 Specialized construction estimate file group

Claims (2)

[Claims] 1. A building construction cost estimate creation system comprising a central processing unit, a storage device, and an input device, wherein the storage device stores data for determining a building structure of a building and specifications of each room. A specification setting file for input, a material / part data file stored in association with a name of the material / part to be attached to each room, and at least a construction amount of various constructions required to attach the material / part, The central processing unit has a construction unit price file storing unit prices of each construction per unit construction amount and a specialized construction estimate file group having form data for each specialized construction classification, and the central processing unit sets the specification on the display unit. Displays the contents of the file,
First means for storing, in the specification setting file, data for determining the building structure of the building and the specifications of each room input by the input device; and determining the building structure of the building and the specifications of each room. Based on the data, a second means for calculating the amount of work for each specialty work for each room, and the amount of work for each specialty work for each room calculated by the second means, tabulated for each specialty work, It has a third means for calculating a construction cost based on the totaled construction amount and a unit price of the construction unit price file, and storing the calculated construction cost in the specialized construction estimate file. , Construction cost estimate creation system. 2. The third means comprises: a fourth means for calculating a total wall area of a room for each floor; a fifth means for calculating an outer wall area for each floor; and a calculation by the fourth means. The value obtained by adding the total wall area of the room for each floor and the outer wall area for each floor calculated by the fifth means is divided by an integer 2 and calculated from the divided value by the fifth means. 6. A construction cost estimate creation system according to claim 1, further comprising: sixth means for calculating a partition amount for each floor by subtracting an outer wall area for each floor.