JP2002049657A - Building quantity survey device and computer readable recording medium storing building quantity survey program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To save labor of inputting. SOLUTION: This building quantity survey device includes the following: A. a quantity calculation file to which quantity names and quantities regarding basic building conditions are inputted; B. a conditional variable master to which names of conditional variable items regarding optional building conditions and variable values that define the building conditions are inputted; C. a quantity survey detail master to which (a: name of quantity survey item, quantity, quantity calculation formula, unit cost, amount and first amount calculation formula) and (b: name of building related calculation item, amount and a second amount calculation formula) are inputted; D. a quantity survey calculation file to which data of the master is inputted; E. a means for calculating each quantity by each quantity calculation formula to update quantity data for each file; and F. a means for updating each amount data for the quantity survey calculation file by each amount calculation formula. The quantity survey item includes an optional quantity survey item having a quantity calculation formula, which includes a calculation command that makes the quantity to be calculated when the building condition is matching and a deletion command that makes the optional quantity survey item to be deleted in the quantity survey calculation file when the building condition is not matching.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a building integration device and a computer-readable recording medium storing a building integration program.

[0002]

2. Description of the Related Art The building cost is calculated by calculating an execution unit price (cost) of a building and calculating a gross profit on a selling price.
Indispensable. However, conventionally,
The integration could not be easily performed even by using a computer or the like (the reason will be described later). For this reason, small and medium-sized construction firms, where it is not possible to take sufficient time to estimate the cost, actually ordered the necessary materials for construction each time. The execution budget was high, and it was not possible to confirm whether gross profits would be generated.

[0003]

By the way, as described above, the reason why the building integration could not be easily performed is as follows. In other words, in the estimation, since a very large number of members must be entered for each building,
It took a lot of trouble. In this case, when rebuilding the exact same property, the data of the previous processed property can be used as it is. However, in reality, there are few cases where the same building is used, and there are few cases where the building can be used as it is. When building a building, it is necessary to input or confirm the details of the details of the building items. was there. The reason is that, in general, the (master) data of the details of the basic integration item cannot be adapted to a situation where complicated building conditions are variously selected.

[0004] That is, in the conventional multiplication system, a type in which a member specification is simply added / deleted or a calculation formula can be set. It is not possible to enter a calculation formula involving complicated building conditions that are variously selected. In order to improve this, it has been proposed to embed complicated calculation formulas directly in the program by modifying the program itself, but it is not versatile, and in fact, complicated building conditions Inability to adequately cope with various choices.

[0005] In a general multiplying system, a totaling specification is input by picking up members from a drawing. Therefore, it takes a lot of time to input one building property. In fact, it was not available. In order to save the trouble of inputting in the above integration, an integration system integrated with a CAD device (hereinafter, sometimes abbreviated as CAD) has been proposed, but a specific CAD device is basically used. Due to the concept described above, there is a limit in versatility, and in this way, if the linkage with the CAD device is high, there is a problem that it takes time to unify the unit of the quantity input from the CAD device and correct the quantity. Newly occurred.

It is an object of the present invention to provide a building integration device and a computer-readable recording medium storing a building integration program which can solve the above-mentioned problems.

[0007]

In order to achieve the above-mentioned object, a feature of the building integration device of the present invention is that a building integration device for calculating a building-related amount by a programmed computer comprises: B. a quantity calculation file in which quantity names and quantities related to basic building conditions are input; C. a condition variable master to which the names of condition variable items relating to optional building conditions and variable values for determining said building conditions are input; I. The name, quantity, quantity calculation formula, unit price, amount, and first amount calculation formula of the totalization item; It is a master to which the name of the building-related calculation item, the amount of money and the second amount of money calculation formula are input, and the above-mentioned quantity calculation formula is
A formula for calculating the quantity based on the quantity of the quantity calculation file and / or the variable value of the condition variable master, and the first formula for calculating the amount of money is a formula for calculating the amount of each summation item based on the quantity and unit price of each summation item. An integration specification master, wherein the second amount calculation formula is an expression for calculating the amount of the building-related calculation item based on the amount of each integration item; A. The name, quantity, unit price, and amount of the integration item; E. an integration calculation file in which the stored data of the name and the amount of the building-related calculation item is input, and the stored data is displayed and / or output; Means for calculating the quantity according to the quantity calculation formula of the integration calculation file and inputting the quantity into the integration calculation file, thereby updating the quantity data of the integration calculation file; Means for calculating the amount of money according to the first amount of money calculation formula of the totalization specification master and inputting the amount into the totalization calculation file, thereby updating the amount data of each integration item of the totalization calculation file; A means for updating the amount data of each building-related calculation item in the integration calculation file by calculating the amount by the second calculation formula of the integration specification master and inputting the amount to the integration calculation file, The integration item is provided with an optional integration item having a plurality of options regarding building conditions, and the integration item has an optional quantity calculation formula. Only when the building conditions based on the quantity entered in the quantity calculation file and / or the variable value entered in the condition variable master correspond to the building condition of the optional multiplication item, the quantity based on the above input quantity and / or variable value A calculation command for executing the calculation; When the building condition based on the input quantity and / or the variable value does not correspond to the building condition of the optional integration item, a deletion command for executing the deletion of the optional integration item on the integration calculation file is provided.
A display and / or output unit for displaying and / or outputting the data stored in the integration calculation file may be provided. In addition, a quantity calculation formula is input to the quantity calculation file, and the quantity calculation formula is a formula for calculating the quantity of another quantity name based on the quantity of the quantity name, and the quantity is calculated according to the quantity calculation formula of the quantity calculation file. There is a case in which means for calculating the quantity and inputting it to the quantity calculation file to update the quantity data of the quantity calculation file is provided. Further, all or part of the input of the quantity of the integration item to the quantity calculation file may be performed by the quantity output file of the CAD device. In addition, the input of the calculation formula is performed by the pallet input, and the input screen of the calculation formula is a. Various quantity elements constituting the calculation formula; In some cases, an input palette that forms a calculation formula is arranged by pasting a quantity element by dragging with a mouse. Further, any one of the data input to the quantity calculation file, the data input to the condition variable master, the data input to the totalization specification master, and the display and output of the stored data of the totalization calculation file, or any two of them.
One or more combinations may be performed via an open network such as the Internet or a dedicated network. The feature of the computer-readable recording medium storing the building integration program for calculating the building-related amount by the computer of the present invention is that the computer functions as the above-mentioned file, master, means, and the like. .

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a building estimating apparatus (building estimating system, building execution budget estimating apparatus) according to the present invention will be described below with reference to the drawings. The integrating device of the present embodiment is constituted by a computer (personal computer, engineering workstation, (system) server, etc.) (system) and is also used as a CAD device.

FIG. 1 shows an integrating device, which comprises a computer body 1 and various input / output devices. The computer body 1 includes a CPU 2, a ROM 3, an RA
An M4 and an input / output port 5 to which input / output devices are connected are provided, and these are mutually connected via a system bus 6.

The input / output devices include a hard disk drive (HDD) 8 connected to the hard disk 7 for reading and writing programs and data stored in the hard disk 7, and a loaded floppy (registered trademark) disk 9. Floppy disk drive (FDD) for reading and writing programs and data
10, a drive (CDD) 12 for reading and writing programs and data on a loaded disk 11 such as a CD-ROM or a DVD, an image reader (IR) 13 for reading an image, a CRT, a liquid crystal, etc. Display (image display device) 14, keyboard 1
5, pointing devices such as a mouse, a digitizer or a tablet (hereinafter referred to as "mouse") 16,
A printing device 17 such as a printer or a plotter is provided. Note that the image reader 13, the keyboard 15, and the mouse 16 function as input means of the present invention. or,
The display 14 functions as a display unit, and the printing device 17 functions as an output unit (printing unit).
The hard disk 7 stores programs for the computer and the input / output device to execute CAD and integration processing described later.

The present invention realizes versatility and efficiency as an integrating system by unifying master data including calculation formulas in order to solve the conventional problems. That is, by introducing the “calculation by conditional quantity element” and the “computation of complex conditional expression” described below, it is possible to quickly calculate the execution budget by unifying the master data. First, the calculation formula of integration mainly focuses on quantity calculation based on picking up quantity. In this quantity calculation, in order to realize a general-purpose calculation function that can cope with various situations, when the quantity calculation formula is analyzed, the quantity calculation formula is divided into two types, a “standard form quantity element” and a “non-standard form quantity element”. It has three elements.

The fixed-form notation quantity element relates to basic (basic) building conditions, and is always fixed (in other words, “common to each building property”) in various situations of the quantity calculation formula. Notation with a quantity name or with a fixed formula pattern,
It has a general meaning and has "fixed quantity name" and "fixed form formula". The fixed-form notation quantity elements mainly include calculation of individual quantities and constant items, and include, for example, “ceiling height”, “total floor area (first floor area + second floor area)” and the like. The non-standard form quantity element is related to optional (optional) building conditions, and in various situations of quantity calculation formulas, it is a quantity calculation element that does not include the above-mentioned fixed notation but includes a formula for individual parts. It has a certain "irregular calculation formula" and a "condition element" for conditioning. The non-standard-form notation quantity element mainly focuses on the integration calculation item for the member, for example, “「 × 1.234 ”or“ IF ○ =
OO THEN "and the like. In addition, how to divide the various parts of the building property into fixed form notation and non-standard form
Judgment and separation are performed based on the operation of the integration formula and the degree of change in maintenance and the degree of prospect.

[0013] The above-mentioned calculation by conditional quantity element means that, in the multiplication system, the quantity elements set for the details of the individual multiplication members are aggregated into a fixed form notation and a non-standard form notation, and each formula is executed. By doing so, the setting and management of the quantity calculation formula are performed more efficiently. Furthermore,
By paying attention to this fixed notation, by hiding the quantity element, output data from various CAD devices can be linked. And, in the formula of this quantity element, by incorporating a complex conditional formula based on conditional variables into the formula of non-standard form, it is possible to describe the multiplication calculation that operates only when it corresponds to a specific building condition I have. In addition, by separating the quantity element into the fixed form notation and the non-standard form notation, the calculation formula can be shortened and the calculation formula can be set efficiently by pallet input.

Next, calculation by conditional quantity element (see FIG. 2)
Will be described together with the flow of the integration process (see FIG. 3). still,
2 and 3, various masters (files) storing various data, files, and the like are provided in predetermined storage areas of the hard disk 7, respectively. By the way, the basic calculation of conditional quantity elements is based on the creation of a calculation file and the execution of an interpreter for each of the fixed quantity elements and the non-fixed quantity elements.

As described above, by performing the quantity element calculation in the fixed form notation at the first stage and performing the quantity element calculation in the non-fixed form at the later stage, the complicated calculation is absorbed and the general-purpose quantity calculation is performed. It is possible. In addition, since a single binary program can be used for various companies' accumulation modes, there is no need for the software developer to modify the program for each customer, and the introduction of the system of the present invention takes much time and effort. And can be realized at low cost. Next, each process will be described.

(1) CAD quantity data reading / collating processing (or manual quantity reading) First, in order to process the fixed quantity notation, a quantity element related to basic building conditions is added to the quantity calculation file (ie,
(Quantity name and quantity) and calculation formulas are set. At this time, a CAD element called CAD quantity master is used to fetch the quantity element that is the basis of the integration from the CAD device and process it.
Prepare a file for reading D data. In the CAD quantity master, as shown in FIG. 4, a "system quantity name" field in which a quantity element name unique to the integration system is set in advance as a necessary quantity item name, and a quantity element name on the CAD side are set in advance. "CAD quantity name" column and "CA
It has a “D quantity” column and a “quantity calculation formula” column. The quantity calculation formula calculates the quantity of another quantity name using the quantity of the quantity name.

In taking in data from a CAD device,
As shown in FIG. 5, first, regarding the CAD quantity element item,
Referring to the data on the component configuration of the drawing of the building property output in the CAD quantity output text file, refer to “CA
The item set in the “D quantity name” column is searched, and the quantity of the corresponding item is transferred to the “CAD quantity” column and set. In the CAD quantity master, an arbitrary quantity element can be additionally set in order to cope with the fact that the content of the quantity element differs depending on the CAD device used. In the “calculation formula” column of the additional quantity element item, a calculation formula (for example, “A” in FIG. 5) created based on the quantity element imported from the CAD device is used.
+ C ”,“ F × 2 ”), it is possible to virtually set the quantity element. This makes it possible to read the data of the quantity output text file of various CAD devices without depending on a specific CAD device, thereby improving versatility and easily correcting the integrated contents.

Also, by using the "calculation formula" column,
Units can be easily unified and numerical values can be easily corrected for quantity elements taken in from a CAD device. Then, after completing the quantity setting to the CAD quantity master, the data entered and set in the fields of “system quantity name”, “CAD quantity”, and “quantity formula” are transferred to the quantity calculation file. or,
A start quantity master is created to enable the user who does not own the CAD apparatus to perform the integration process. As shown in FIG. 6, the starting quantity master includes, as shown in FIG. 6, a “system quantity name” field in which a quantity element name unique to the multiplication system is set in advance, an “input quantity” field in which quantities are manually input, and a CAD quantity. It has a “quantity formula” column having the same function as the “quantity formula” column of the master.

(2) Creation of a Quantity Calculation File A quantity calculation file is created as a work file for executing a calculation process for the fixed notation quantity.
The actual calculation process is performed on the file. As shown in FIG. 7, the quantity calculation file includes a “system quantity name” field, a “quantity” field,
It has a "quantity calculation formula" column. In the creation of the quantity calculation file in the case of reading the data of the quantity output text file of the CAD device, the CA in which the data of the CAD device is input is used.
From “D Quantity Master”, “System Quantity Name”, “CAD
It is created by transferring the data entered and set in the fields of “quantity” and “quantity calculation formula” to the quantity calculation file. Also, when creating a quantity calculation file from manual input, the data entered and set in the “System quantity name”, “input quantity”, and “quantity calculation formula” fields from the previously entered and set start quantity master Transferred to the quantity calculation file and created.

(3) Executing the Quantity Calculation Interpreter (Basic Quantity Calculation Processing) In the execution of the quantity calculation interpreter, which is the basic quantity calculation processing, the formulas entered and set in the quantity calculation file are as follows:
The quantity column of each quantity element itself is updated by being analyzed and executed as needed. In this calculation, versatility is given by using an interpreter. When this quantity calculation is completed, the quantity of the fixed form notation quantity element is determined.

(4) Condition setting In the condition setting, the condition contents of the property to be built are specified for the condition variable items set in advance and relating to optional building conditions. Condition variables are variables used for processing judgment and for specifying constants in the calculation formula for integration.
It is created arbitrarily and can be used. All of the setting contents of the condition variables are converted into numerical values and made into numerical variables, so that they can be used as a constant part of a quantity calculation formula other than the condition determination. The input value of the condition variable input here is stored in the condition variable master. As shown in FIG. 8, the condition variable master has a “condition variable name” column and a “condition variable value” column.

(5) Creation of an integration calculation file An integration specification master is created in advance. As shown in FIG. 9, the totalization detail master includes a “member name” column that is an integration item or a building-related calculation item, a “calculation quantity” column,
It has a “unit price” column and a “price” column, and data is previously set and stored in each of these columns. Note that the construction-related calculation items are subtotals, totals, total amounts, contract amounts, actual amounts, budget profit amounts, budget profit ratios, actual profit ratios, and the like, which are totals in the amount column of each integration item. In addition, the totalization detail master calculates a quantity using the quantity of the quantity calculation file and the variable value of the condition variable master, and a first formula for calculating the amount of each integration item from the quantity and unit price of each integration item. An amount calculation formula and a second amount calculation formula for calculating the amount of the building-related calculation item from the amount of each integration item are input and set in advance.
Then, an integrated calculation file is created as a calculation work file for executing calculation processing including calculation processing for non-standard-size quantity elements. The integration calculation file has the same columns as the integration specification master, and the actual calculation processing is executed on the file. Data such as the member name, quantity, unit price, amount of money, each formula, and the like set in the integration detail master are transferred to the integration calculation file.

(6) Execution of the integration calculation interpreter (integration totalization processing) In the execution of the integration calculation interpreter, which is the integration totalization processing, the quantity calculation formula transferred to the integration calculation file,
Analyze and execute the second amount calculation formula. At that time, when the system quantity is used in the quantity calculation formula, the quantity calculation file is referred to, and when the condition variable is used, the condition variable master is referred to reflect the calculation quantity in the calculation formula. Finally, since the number of parts is determined by this integration calculation, the calculation of the amount of parts in "quantity x unit price" by the first amount calculation formula, and the building-related calculation items by the second amount calculation formula The calculation of the amount is also performed. Also in this integration calculation interpreter, as in the case of quantity calculation, versatility is given by using an interpreter.

(7) Form output Based on the integrated calculation file after the calculation processing, an estimate
Edit and print the purchase order, execution budget, etc.

Next, the complex conditional expression will be described. When there are many building conditions in a calculation formula including building conditions, one condition formula and a calculation formula are generally set for one member. Usually, a plurality of building conditions are input. If necessary, use a multi-statement
It was necessary to include all the condition formulas in the formula items on one line, and in fact, it could not be described. Therefore,
In order to cope with the case where it is necessary to process many building conditions, as shown below, an optional totalizing item is set in the totalizing item of the totaling detail master, and each optional totalizing item is It has an optional quantity calculation formula.

Each optional quantity calculation formula is as follows. Building conditions based on the quantity entered in the quantity calculation file and / or the variable values entered in the condition variable master,
Only when the building conditions of the optional multiplication item are applicable,
A calculation command for executing the quantity calculation based on the input quantity and / or the variable value; When the building condition based on the input quantity and / or the variable value does not correspond to the building condition of the optional integration item, a deletion command for executing the deletion of the optional integration item on the integration calculation file is provided. I have. Specifically, by using a record of continuous members for the details of multiple integration items in the integration detail master, and by describing a complex conditional expression in the details of the above integration items over multiple lines, It is also possible to deal with it.

The setting and operation of the complex conditional expression are as follows. For example, in the case of a single-story building, a two-story building, and a three-story building, when the required quantity of the member, for example, the temporary scaffolding fee is different, it is described in the estimation statement master as follows. That is, as shown in FIG. 10, “temporary scaffolding loss (one-story building)” is set as the member name (optional summation item name) in the first record of the summation detail master, and the optional quantity calculation formula is used. , "If floor = 1 then quantity = total floor area elseDEL". In the second record, “temporary scaffolding fee (two-story)” is set as the component name, and “if floor = 2then quantity = total floor area * 1.2 else DEL” is set as the optional quantity calculation formula. Describe. Further, in the third record, “temporary scaffolding fee (three stories)” is set as the component name, and “if floor =
3 then Quantity = Total floor area * 1.4 else DEL ".

In each of the above formulas, as a calculation command,
"If the building is a one-story (one-story), two-story, or three-story building, the total floor area, total floor area x 1.2, or Area x 1.4 "
The calculation is sequentially performed from the top record on the integration calculation file in which each calculation formula is described and each calculation formula is transferred. At the end of the calculation formula, a record deletion command (DEL) is set, so that the integration items that do not satisfy the conditions (for example, if the building is a two-story building, a temporary scaffolding loss (one-story building), The temporary scaffold penalty (three-story building accumulated items) is deleted from the accumulated calculation file, and the forms such as an estimate, a purchase order, and an execution budget are prepared. As described above, by adopting the complex conditional expression, it is possible to perform the same condition determination as a multiple IF statement or a CASE statement in programming, so that it is possible to cope with complicated building conditions. Also, if OR (logical sum) or AND (logical product) is used in the comparison formula, or if the condition variables are used frequently, complicated building conditions can be simplified.

Next, pallet input will be described. As described above, by classifying the fixed-form notation quantity element and the non-fixed-form notation quantity element, in the input of each calculation formula, by adopting the pallet input formula by the input configuration for each quantity element,
Calculation formulas can be set easily, quickly and in a rational manner. Specifically, as shown below, on the calculation formula input screen, various quantity elements constituting the calculation formula are arranged as parts, and the mouse 16
Enter each quantity element by dragging it on the palette. As screen parts, "quantity name",
Various quantity elements such as “condition variables”, “integration details”, “four arithmetic operators”, and “functions” are arranged as options. In addition, as for the quantity element having a hierarchy level, selection and setting are performed from those displayed in a tree hierarchy as described below, thereby simplifying the input. You can often enter formulas.

The following is an example of the calculation formula setting.
is there. That is, the maintenance screen of the integration calculation master is started.
When the building is moved, for example,
Details are displayed as shown in FIG. Roof construction details
Is the (material) name, specification, unit, budget classification, budget 1,
There is a column for product coefficient and the like. And in the name column,
Thatch, pottery tile, etc.
In the column, m ^Two , Location, etc., in the budget classification column, 1, 2, etc.
However, the budget 1 column shows the amount, the estimation coefficient column shows the numerical value,
Each has been entered. In this specification,
With thatch, for the details of each multiplication item of two lines of gable and ridge
If you want to set the calculation formulas and use them properly,
Set the calculation formula as described above. First, FIG.
Click on the calculation formula registration button in the upper right corner to
Display the screen shown in Fig. 2 and enter the calculation formula. The above picture
In terms of terms, the left side is a fixed quantity element in a tree hierarchy format,
Selectable items for CAD quantity, condition variable and totalization calculation
Noh. In the screen, the condition variable is selected and the upper layer
The condition variable master is displayed as a file,
Files for building specifications, insulation materials, etc.
It is displayed and the building specification is selected.

Similarly, a desired quantity element can be selected by a hierarchical button (for example, from building specification to exterior wall specification) at the upper center of the screen. Also, the screen shows IF ~ OR
, A numeric setting button for a direct constant such as 0-9 (including “,”), a button for four arithmetic operations such as + to 、, and other buttons (Clear, Ente
r, (,), insertion, deletion, function, registration button) and the like, and an input pallet 20 for setting a calculation formula is also arranged at the bottom of the screen. Then, in accordance with the contents of the calculation formula, the corresponding quantity element is dragged with the mouse 16 and placed on the input palette 20. For example, in the case of roof construction, if the roof is a color vest roof and the roof shape is different from that of the gable and the ridge, the two columns of the description column of the integrated member are prepared and set under the following conditions, respectively. .

1. 1. Color vest roof When the roof shape is gable and the roof specification is color vest Roof area x unit price = price Color vest roofing (for a ridge) When the roof shape is a ridge and the roof specification is a color vest Roof area x unit price = price

When the above conditions are actually input as a calculation formula, they are arranged on the input pallet 20 as shown in FIG. 13 or FIG. 14, and the entire screen in FIG. 13 is shown in FIG. As shown. In the calculation formula in the case of FIG. 13, it is checked (determined and determined) whether or not the condition variable “roof shape” is an option “gable” under the conditions from IF to THEN. . In the case of gables, the condition variable “roof specification” follows AND.
Is "color best" which is a selection option. In the case of the color vest, the “roof area” which is the CAD quantity is input and set in the quantity column of the details of the integration item. As described above, if the color is not the best, the DEL command is executed, and the integration item itself is deleted from the integration calculation file. Also, the calculation formula in the case of FIG. 14 is executed in the same manner, and is executed under the condition of a ward instead of a gable.

Next, how the calculation formulas of FIGS. 13 and 14 are actually executed will be described. For example, when “gable” is set in the “roof shape” of the condition variable and “color vest” is set in the “roof specification” of the condition variable, in the quantity calculation formula of FIG. The roof area is set, and the member price is calculated according to the first price calculation formula, roof area × unit price = amount, input to the integration calculation file, and the member price data is updated. Although the calculation formula in FIG. 14 is also executed, the calculation formula in this case is DEL because the “roof shape” of the condition variable is not a building and does not satisfy the condition.
The command is executed, and the integrated item itself is deleted from the integrated calculation file. Therefore, on the integration calculation file, only the calculation formula of FIG. 14 remains as the detailed data of the integrated item, and the format is adjusted so that the detailed data of the unnecessary integrated item is not displayed.

The condition variables referred to here are preset in the property specification setting screen. That is, the procedure for inputting the condition variables is as follows. First, as shown in FIG. 16, for example, a property specification input / setting screen is displayed. On this screen, there are a building specification column and an item column. In the building specification column, a building specification, a heat insulating material, and the like are input, and in the item column, a Western-style rank 1, rock wool 50 thickness, and the like are input. On the setting screen, for example, “Roof shape” in the building specification column is selected. Then, "Roof shape"
Is displayed, and for example, gable is selected. After the selection, a numerical value representing a gable, which is an option, is stored in the “roof shape” of the condition variable internally. Next, “roof specification” in the building specification column is selected. Then, as shown in FIG. 17, a selection screen for "roof specification" is displayed, and a color vest is selected. After the selection, a numerical value representing the color vest is stored in the “roof specification” of the condition variable in the condition variable master. Note that a constant may be set as the condition variable instead of the selection format as described below.
That is, as shown in FIG. 18, the "number of gutter locations" in the building specification column
When is selected, the numerical value is set in the condition variable “number of gutter locations” by directly inputting the numerical value.

As described above, the amount of each integration item in the integration calculation file is calculated, and the sum of the amounts of each integration item is calculated by the second amount calculation formula.
The amount of architectural calculation items such as total and grand total are calculated,
The data is input to the integration calculation file, and the amount data of the building-related calculation item is updated. The stored data of the integration calculation file is edited, modified, etc. so as to be easily displayed and / or output, input to the integration totalization file, stored, and the like, and stored. The data is edited,
Print (or display) the quote used on the sales side, or print (or display) the purchase order used for the procurement of materials, or print (or print the execution budget) , Display).

By the way, as shown in FIGS. 19 to 23, the construction budget, which is an estimate, has a cover, a construction execution budget for each of large accumulation items, a construction execution budget for each medium accumulation item, and a small accumulation item. Consists of a separate work execution budget. As shown in FIG. 19, on the cover, the basic data of the building property input in advance by the input means such as the keyboard 15 is described. The basic data includes a creation date, a construction name, a site address, a customer, a person in charge, a designer, a construction supervisor, a total budget amount, and the like. As shown in FIG. 20, the construction execution budget for each of the large accumulation items includes a statement for each of the large accumulation items, such as the construction work of the building and the equipment work, and each line of the large accumulation item includes the specification, quantity, and unit. , Unit price, amount, and remarks.

As shown in FIG. 21, the construction execution budget for each middle accumulation item shows the details of the large accumulation items such as the construction work of the building itself. Only the construction execution budget for the main building construction is shown, and the construction execution budget for the equipment construction is omitted. The large-scale items for the construction of the main building consist of medium-size items such as temporary work and foundation work. Each line of each medium-size item includes columns for specification, quantity, unit, unit price, amount, and remarks. As shown in FIGS. 22 and 23, the construction execution budget for each small accumulation item shows details of medium accumulation items such as temporary construction and foundation work.
Only the work execution budget for temporary work and foundation work is shown as the work execution budget for each small accumulation item. The medium-summation items for temporary construction consist of small summation items such as watering method and ink marking, and the medium-summation items for foundation work consist of small summation items such as solid foundation. , Specifications, quantity,
There are columns for unit, unit price, amount, and remarks.

According to the above-described configuration example, as the totalization item of the totalization detail master, an optional totalization item having a plurality of options regarding the building conditions is set, and the optional totalization item has an optional quantity calculation formula. The formula for calculating the quantitative quantity is as follows: Building conditions based on the quantity entered in the quantity calculation file and / or the variable values entered in the condition variable master,
Only when the building conditions of the optional multiplication item are applicable,
A calculation command for executing the quantity calculation based on the input quantity and / or the variable value; When the building condition based on the input quantity and / or the variable value does not correspond to the building condition of the optional integration item, a deletion command for executing the deletion of the optional integration item on the integration calculation file is provided. , Α. A quantity calculation formula involving complicated building conditions that are variously selected can be input to the integration specification master, and it is possible to cope with a situation in which complicated building conditions are variously selected, thereby reducing the time and effort required for inputting. β. The versatility is high because complicated formulas are not embedded directly in the program. γ. Estimated items related to building conditions not selected are
Since it is deleted from the integration calculation file, there is no need to check one of the items of the integration item in the integration calculation file and delete unnecessary unnecessary integration items related to building conditions that have not been selected. And so on.

A quantity calculation formula is input to the quantity calculation file, and the quantity input formula is used as a formula for calculating the quantity of another quantity name based on the quantity of the quantity name. The data in the file is processed by the quantity input formula and can be input to the quantity calculation file. Therefore, without using the quantity calculation formula, the quantity to be input to the quantity calculation file can be converted to the quantity output text file of various CAD devices. If the data is "only common quantity", various CAD
In addition to being compatible with the apparatus, the versatility can be improved, and the unit of the quantity input from the quantity output text file of the CAD apparatus, the quantity correction, and the like can be easily performed.

FIG. 24 shows a second example of the embodiment of the present invention, in which an integrating device has a system server 31 corresponding to the computer body 1 of the first example, and an external terminal corresponding to the input / output means of the first example. 31 to 34 and the like. The external terminals 31 to 34 are composed of a computer such as a personal computer, and are provided with various input / output devices.
And an open network such as the Internet or a network (communication network) 36 such as a dedicated network.
, Through, connected. The external terminal 31 changes the data of the server 35 in real time at the head office (headquarters) or the like.
5 and display and / or output data from the server 35. The external terminal 33 is used by the sales person on the go, and the external terminal 34 is used by the client in the same manner as the external terminal 32.
That is, any one or two or more of data input to the quantity calculation file, data input to the condition variable master, data input to the totalization specification master, and display and output of storage data of the totalization calculation file The combination is performed via the network 36.

According to the second example configured as described above, it is possible to easily input various data from the outside and / or display and / or output a quote or the like from the outside.

Incidentally, only the system server 35 may be used as the building integration device of the present invention.

[0044]

As described in detail above, according to the present invention,
In the multiplication item of the multiplication detail master, an optional multiplication item that has multiple options for building conditions is set, the optional multiplication item has an optional quantity calculation formula,
The optional quantity calculation formula is as follows. Building conditions based on the quantity entered in the quantity calculation file and / or the variable values entered in the condition variable master,
Only when the building conditions of the optional multiplication item are applicable,
A calculation command for executing the quantity calculation based on the input quantity and / or the variable value; When the building condition based on the input quantity and / or the variable value does not correspond to the building condition of the optional integration item, a deletion command for executing the deletion of the optional integration item on the integration calculation file is provided. , Α. A quantity calculation formula involving complicated building conditions that are variously selected can be input to the integration specification master, and it is possible to cope with a situation in which complicated building conditions are variously selected, thereby reducing the time and effort required for inputting. β. The versatility is high because complicated formulas are not embedded directly in the program. γ. Estimated items related to building conditions not selected are
Since it is deleted from the integration calculation file, there is no need to check one of the items of the integration item in the integration calculation file and delete unnecessary unnecessary integration items related to building conditions that have not been selected. And so on.

According to the third aspect, the quantity calculation formula is input to the quantity calculation file, and the quantity input formula is a formula for calculating the quantity of another quantity name based on the quantity of the quantity name, and the CAD is used. Since the data of the text output file of the device can be processed by the quantity input formula and input to the quantity calculation file, the quantity to be input to the quantity calculation file without using the quantity calculation formula can be used for various CAD devices. If the data of the quantity output text file is "only the common quantity", it can be applied to various CAD devices, improving versatility, unifying the unit of quantity input from the quantity output text file of the CAD device, and correcting the quantity. Etc. can be easily performed.
According to the fourth aspect, it is possible to easily input the quantity of the integration item into the quantity calculation file. According to claim 5, it is possible to easily input a calculation formula. According to the sixth aspect, input of various data from the outside and / or external display and / or output of a quote or the like can be easily performed.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a first example of an embodiment of the present invention.

FIG. 2 is a block diagram showing an outline of a calculation for each conditional quantity element according to the first example of the embodiment of the present invention.

FIG. 3 is a block diagram illustrating an outline of an integration process according to a first example of the embodiment of the present invention;

FIG. 4 is a diagram showing an outline of a CAD quantity master shown in FIG. 3;

FIG. 5 is an explanatory diagram showing a relationship between a CAD quantity master and a CAD quantity output text file in FIG. 3;

FIG. 6 is a diagram showing an outline of a starting quantity master of FIG. 3;

FIG. 7 is a diagram showing an outline of a quantity calculation file of FIG. 3;

FIG. 8 is a diagram showing an outline of a condition variable master of FIG. 3;

FIG. 9 is a diagram showing an outline of an integration specification master of FIG. 3;

FIG. 10 is a diagram showing an outline of optional integration items of an integration detail master of FIG. 3;

FIG. 11 is a screen showing the details of the roofing work of the totalization master shown in FIG. 3;

FIG. 12 is a screen before input of a formula for calculating the amount of roof work of the condition variable master of FIG. 3;

FIG. 13 is an explanatory diagram showing a formula for calculating the quantity of roof work of the condition variable master in FIG. 3;

FIG. 14 is an explanatory diagram showing a formula for calculating the quantity of roof work of the condition variable master shown in FIG. 3;

FIG. 15 is a screen after inputting a formula for calculating the amount of roof work of the condition variable master of FIG. 3;

FIG. 16 is a setting screen of the roof work of the condition variable master of FIG. 3;

FIG. 17 is a setting screen of the roof work of the condition variable master of FIG. 3;

FIG. 18 is a setting screen of the roof work of the condition variable master of FIG. 3;

FIG. 19 is a cover of a construction budget document showing a first example of an embodiment of the present invention.

FIG. 20 is a construction execution budget for each large accumulation item, showing a first example of an embodiment of the present invention.

FIG. 21 is a construction execution budget for each medium accumulation item, showing a first example of an embodiment of the present invention.

FIG. 22 is a construction execution budget for each small accumulation item, showing a first example of an embodiment of the present invention.

FIG. 23 is a construction execution budget for each small accumulation item, showing a first example of an embodiment of the present invention.

FIG. 24 is a block diagram showing a second example of the embodiment of the present invention.

[Explanation of symbols]

 1 computer main body 16 mouse 20 pallet 31-34 external terminal 35 system server 36 network

Continuation of the front page (51) Int.Cl. ⁷ Identification symbol FI Theme coat II (reference) G06F 19/00 300 G06F 19/00 300N F term (reference) 5B046 AA03 CA04 GA01 KA03 5B049 BB05 CC11 CC21 DD01 EE01 FF02 FF03 FF04 GG04 GG07

Claims (8)

[Claims] Claims: 1. A computer programmed by:
In a building estimating device that calculates a building-related amount, B. A quantity name and a quantity calculation file in which quantities are input relating to basic building conditions; B. a name of a condition variable item relating to an optional building condition and a condition variable master to which a variable value for determining the building condition is input; I. (B) the name, quantity, quantity calculation formula, unit price, amount, and first amount calculation formula of the integration item; A master to which the name, amount, and second amount calculation formula of the building-related calculation item are input, and the above-mentioned quantity calculation formula is a formula for calculating the quantity based on the quantity of the quantity calculation file and / or the variable value of the condition variable master. The first amount calculation formula is an expression for calculating the amount of each integration item based on the quantity and unit price of each integration item, and the second amount calculation formula is a building-related calculation item based on the amount of each integration item. D. an integration statement master, which is a formula for calculating the amount of A. The name, quantity, unit price, and amount of the integration item; E. an integrated calculation file in which the stored data of the name and the amount of the building-related calculation item is input, and the stored data is displayed and / or output; Means for calculating the quantity according to the quantity calculation formula in the integration calculation file and updating the quantity data in the integration calculation file by inputting the quantity into the integration calculation file; Means for calculating the amount by the first amount calculation formula of the integration specification master and inputting the amount into the integration calculation file, thereby updating the amount data of each integration item in the integration calculation file; Means for updating the amount data of each building-related calculation item in the integration calculation file by calculating the amount by the second amount calculation formula of the integration specification master and inputting the amount to the integration calculation file; In the multiplication item, there is provided an optional multiplication item having a plurality of options regarding building conditions, the multiplication item has an optional quantity calculation formula, and the quantity calculation formula is as follows. Building conditions based on the quantity entered in the quantity calculation file and / or the variable values entered in the condition variable master,
Only when the building conditions of the optional multiplication item are applicable,
A calculation command for executing the quantity calculation based on the input quantity and / or the variable value; A building integration device having a deletion command for executing deletion of an optional integration item on an integration calculation file when the building condition based on the input quantity and / or the variable value does not correspond to the building condition of the optional integration item. 2. The building integration device according to claim 1, further comprising display and / or output means for displaying and / or outputting stored data of the integration calculation file. 3. A quantity calculation formula is input to the quantity calculation file, and the quantity calculation formula is a formula for calculating a quantity of another quantity name based on the quantity of the quantity name, and a quantity calculation formula of the quantity calculation file. Means for calculating the quantity and inputting the quantity into the quantity calculation file, thereby updating the quantity data in the quantity calculation file.
Or the building integration device according to 2. 4. The building integration device according to claim 1, wherein all or a part of the input of the number of the integration items to the number calculation file is performed by the number output file of the CAD device. 5. An input of a calculation formula is performed by a pallet input. Various quantity elements constituting the calculation formula; The building integration device according to any one of claims 1 to 4, wherein an input pallet for forming a calculation formula is arranged by pasting a quantity element by dragging with a mouse. 6. Data input to a quantity calculation file, data input to a condition variable master, data input to an integration specification master, display and output of storage data of an integration calculation file, or any two of them. The combination of one or more is performed via an open network such as the Internet or a dedicated network.
The building integration device according to any one of the above. 7. A computer-readable recording medium storing a building integration program for calculating a building-related amount by a computer, the computer comprising: A. B. A quantity name and a quantity calculation file in which quantities are input relating to basic building conditions; B. a name of a condition variable item relating to an optional building condition and a condition variable master to which a variable value for determining the building condition is input; I. (B) the name, quantity, quantity calculation formula, unit price, amount, and first amount calculation formula of the integration item; A master to which the name, amount, and second amount calculation formula of the building-related calculation item are input, and the above-mentioned quantity calculation formula is a formula for calculating the quantity based on the quantity of the quantity calculation file and / or the variable value of the condition variable master. The first amount calculation formula is an expression for calculating the amount of each integration item based on the quantity and unit price of each integration item, and the second amount calculation formula is a building-related calculation item based on the amount of each integration item. D. an integration statement master, which is a formula for calculating the amount of A. The name, quantity, unit price, and amount of the integration item; E. an integrated calculation file in which the stored data of the name and the amount of the building-related calculation item is input, and the stored data is displayed and / or output; Means for calculating the quantity according to the quantity calculation formula in the integration calculation file and updating the quantity data in the integration calculation file by inputting the quantity into the integration calculation file; Means for calculating the amount by the first amount calculation formula of the integration specification master and inputting the amount into the integration calculation file, thereby updating the amount data of each integration item in the integration calculation file; By calculating the amount according to the second amount calculation formula of the integration specification master and inputting the amount into the integration calculation file, the unit functions as means for updating the amount data of each building-related calculation item in the integration calculation file, In the multiplication item, an optional multiplication item having a plurality of options regarding the building conditions is set, and the multiplication item has an optional quantity calculation formula. Building conditions based on the quantity entered in the quantity calculation file and / or the variable values entered in the condition variable master,
Only when the building conditions of the optional multiplication item are applicable,
A calculation command for executing the quantity calculation based on the input quantity and / or the variable value; When the building condition based on the input quantity and / or the variable value does not correspond to the building condition of the optional integration item, a building integration program having a deletion command for executing the deletion of the optional integration item on the integration calculation file. A computer-readable recording medium stored. 8. A computer-readable storage medium storing a building integration program according to claim 7, wherein the computer is caused to function as display and / or output means for displaying and / or outputting stored data of the integration calculation file. recoding media.