JP3433839B2 - Estimation accumulator - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a quote accumulating device for accumulating and estimating material costs and construction costs of the above-mentioned members when the members to be used for the above-mentioned products are decided in designing the products. In particular, the present invention relates to a quotation accumulating device that can easily cope with production stoppages or updates of used members.

[0002]

2. Description of the Related Art In recent years, so-called CAD (computer aided) is used in the design of houses in order to save labor in design work.
design) system is being used. In a conventional house CAD system, the structure of a house is determined based on various data stored in advance by the support of an operator, and the structure of the house is output as drawings such as floor plans, perspective views, and design drawings. It is supposed to be done. Further, depending on the CAD system, the exterior or interior is determined by selecting colors or members of the exterior or interior stored in advance. Further, some of the CAD systems require a simple estimate based on the determined structure, interior, and exterior of the house.

[0003]

By the way, since buildings such as houses are individually designed and constructed based on the intention of the orderer, the respective buildings are basically different from each other. In addition, in addition to members such as columns, beams, walls, and floors that make up the body of a building, there are many members used for exteriors and interiors.

Therefore, in order to obtain the most accurate estimate by the CAD system, it is necessary to have a database that stores the product numbers and unit prices of many members. Then, in order to obtain an estimate, not only the unit price of each member but also the construction cost required for mounting the member is required. In other words, if you want to find out the cost to build a house based on the materials used in the house, you need a database that stores at least the unit price of each material and the construction cost of each material. Becomes

However, as described above, there are various types of the above-mentioned members, and since the manufacturers of these members are developing products respectively, a certain period of time has passed since they were produced. For parts, new products corresponding to the parts were developed, the production line was switched from the old product to the new product, the old product was discontinued, and competitors released new inexpensive products. Is being done. In addition, depending on the member, production may be stopped due to a decrease in consumption amount or a rise in raw material price.

Therefore, if the database in which the unit price and construction cost of each member once constructed is registered is used as it is, even if the member whose production has been already stopped is used, it is used for the estimation as it is, and it is ordered and after the order is placed. There was a possibility that it was necessary to change the member because it was found that the member did not exist.

That is, when a product is designed, and an estimate and an order are placed based on the design by the conventional CAD system, the design and the estimate and the order are made based on the members whose production has been discontinued. There has been a possibility that a complicated work of changing the design including the change of the members must be performed later. And if you estimate using the materials that have already been discontinued, and change the discontinued materials at the stage of building a house, the budget set according to the above estimate will change, The cost of building a home can vary significantly.

In order to prevent the above-mentioned problems, the database in which the unit price and construction cost of each member is registered is constantly maintained, and the discontinued member is deleted and a new member is added. The complicated work of registering the database is required, and there is a problem that the management cost of the database is increased.

Further, even if the above-mentioned maintenance of the database is simply carried out at all times, if the discontinued members are allocated at the time of design, the data of the members deleted from the database at the time of estimation. You will have to search for and cannot make an accurate quote or place an order.

The present invention has been made in view of the above circumstances, and when designing a product, even if a discontinued member is assigned to the product, there is a member that can be used as the discontinued member. In this case, it is an object of the present invention to provide an estimate accumulating device capable of changing the allocation of members so as to use usable members.

[0011]

As shown in FIG. 1, an estimate accumulating apparatus according to the present invention is for accumulating costs required for constructing a product constructed from various members. Yes, a member code indicating each member, cost data required to estimate the unit price of each member, time limit data indicating the usable period range of each member, and a substitute that can be used in place of each member A storage means a that stores a member code indicating a member in association with each other, and a deadline data search means b that searches the deadline data stored in the storage means a corresponding to the member that is determined to be used in the product. And a deadline determining means c for comparing the deadline data retrieved by the deadline data searching means b with an arbitrary date to determine whether the arbitrary date is within or out of the deadline data, and the deadline determining means. by c And cost data retrieval means d whose serial any date searches for the cost data corresponding to the member code of a member is determined to be within the scope of the term data,
An expiry means e for accumulating the cost data searched by the cost data searching means d to obtain an estimate, and the deadline data searching means b is the deadline judging means c.
In place of the member determined to have the arbitrary date outside the range of the time limit data by the above, searching for the time limit data stored in the storage means a corresponding to the member code indicating the substitute member is performed. It was used as a solution to the problem.

In addition to the above structure, in the estimate integrating device of the present invention as set forth in claim 2, the storage means a stores data of a member having a corresponding substitute member and a member having no corresponding substitute member. If the data is stored and the arbitrary date is not included in the range of the deadline data of the member having no corresponding substitute member by the deadline determination means c, there is no usable member. Having the message output means f for outputting the indicated message was taken as means for solving the above problems.

In addition to the above configuration, in the quotation accumulating apparatus according to the third aspect, the storage means a stores an operation code indicating whether or not each member can be used, and replaces the deadline data searching means b. The operation code search means g for searching the operation code stored in the storage means corresponding to the member determined to be used in the product, and the operation code search means g in place of the deadline determination means c. The operation code determining means h for determining whether the member corresponding to the operation code is usable or not based on the operation code, and the message output means f determines whether the operation code is the operation code. When the means h determines that it cannot be used, it outputs a message indicating that there is no usable member, and the cost data search means d causes the operation to be performed. Searching the cost data stored in the storage means a on the basis of the member code of the member determined to be usable by the operation code determination means h is a means for solving the above problems. .

In addition to the above-mentioned structure, in the quotation accumulating apparatus according to the present invention as set forth in claim 4, the operation code indicates that an operation code indicating that the member is currently in operation and a substitute member are present. A parallel operation code and an abolition code indicating that the operation code has already been abolished and cannot be used are set, and the operation code determination means h determines whether the operation code is an operating code, a parallel operation code, or an abolition code. If the operation code is judged to be an abolished code by the operation code judging means h, the message output means f outputs a message indicating that the member cannot be used, and the cost code search is performed. The means g searches for the cost code of the corresponding member when the operation code is judged to be the operating code by the operation code judging means, and the operation code searching device g is to retrieve the operation code from the storage means a based on the member code of the substitute member of the corresponding member when the operation code is judged to be the parallel operation code by the operation code judging means h. It was used as a solution to the problem.

Further, in addition to the above-mentioned structure, the estimate integrating device of the present invention according to claim 5 is based on the correspondence relation between the member code of the member, the deadline data and the member code of the substitute member stored in the storage means a. Corresponding to the above material code, if the range indicated by the deadline data includes the current date, the operation code is set to the operating code, and if the range of the deadline data is before the current date, the operation code is abolished. Set in code,
The above-mentioned problem was solved by having the operation code setting means i for setting the operation code to the parallel operation code when the member code of the substitute member corresponding to the member code exists.

In addition to the above configuration, the estimate accumulating apparatus of the present invention according to claim 6 is newly started in addition to the operation code, the in-operation code, the parallel operation code, and the abolition scheduled code. New code to indicate that
A decommissioning code indicating that there is a plan to be abolished is set, and the operation code determination means h is stored in the storage means a.
It is determined whether the operation code stored in the operation code is the in-operation code, the parallel operation code, the abolished code, the new code, or the abolished code, and the deadline data search means together with the operation code search means g. have b,
The deadline data search means b, when the operation code is judged to be a new code by the operation code judgment means h,
The operation start date of the range of the deadline data corresponding to the operation code is searched, and the deadline data searching means b is
When the operation code is judged as the decommissioning code by the operation code judging means h, the operation end date in the range of the deadline data corresponding to the operation code is searched, and the message output means f determines that the operation code is the above-mentioned. When the operation code judging means h judges that the new code is used, the deadline data searching means b outputs a message indicating that the member can be used after the searched date, and the deadline data searching means b When the code is judged to be the decommissioning code by the operation code judging means h, a message indicating that the member cannot be used after the searched date is outputted to the deadline data searching means b. And

In addition to the above configuration, in the quotation accumulating apparatus according to the seventh aspect, the operation code setting means I retrieves the deadline data corresponding to each member, and the operation start date of the deadline data and the current date. If the operation end date is later, set the operation code to a new code, register the operation end date in the above deadline data, and compare the operation end date with the current date. However, when the end date of operation is later, the operation code is set to the deprecated code as the means for solving the above problem.

In addition to the above configuration, in the estimate accumulating apparatus according to claim 8, the accumulating means e is a cost data searching means d.
The means for solving the above-mentioned problems is to use the cost data retrieved in step 1 to perform an integration process for creating a purchase order for a member corresponding to the cost data.

[0019]

According to the structure described in claim 1, the storage means a
, The above member code, cost data, deadline data,
The member code indicating the substitute member is stored. Then, the deadline data search means b searches the deadline data stored in the storage means a on the basis of the member code of the member used for the product to be estimated. Then, the deadline determination means c compares the retrieved deadline data with an arbitrary date (for example, the planned construction date of the product) to determine whether the arbitrary date is within or outside the range indicated by the deadline data.

The cost data searching means d searches the cost data by the deadline judging means c based on the member code of the member having the deadline data including an arbitrary date. Then, the accumulating means e obtains an estimate by accumulating the expense data searched by the expense data searching means d.

Further, when the deadline judging means c judges that the arbitrary date is out of the range, that is, the deadline data does not include the arbitrary date, the deadline data searching means b makes the deadline judgment. The member code of the substitute member is obtained as the data of the member having the deadline data determined not to include the arbitrary date by the means c, and the deadline data is searched again based on the member code.

Therefore, the time limit data of the substitute member is continuously judged by the time limit judging means c, and it is judged whether the arbitrary date is within the range of the time limit data of the substitute member or outside the range, and it is judged that it is within the range. Then, the cost data of the substitute member is searched by the cost data search means d, and the substitute member of the member is estimated in place of the member having the deadline data not including the arbitrary date.

That is, according to this quotation integrating device, a member having deadline data not including an arbitrary date, for example, a member whose production is decided to be discontinued before the arbitrary date is allocated at the design stage. In this case, instead of the member, a substitute member of the member is selected, an estimate is made using the substitute member, and the substitute member is automatically adopted instead of the member whose production is discontinued. It becomes possible.

Further, in this case, according to the structure of claim 2, the deadline determination means c can be used for the member corresponding to the deadline data determined not to include the arbitrary date. If there is no such member, the message output means f outputs a message indicating that there is no usable member. Therefore, at this point, even if a member to be discontinued is assigned during designing, It is possible to deal with the situation by making a design change including a change in the order, and it is possible to process quickly compared to the case where the order of the material is made and it is known that the production of the material is discontinued. In addition, it is possible to prevent the estimation from being inaccurate by performing the estimation with the discontinued members.

In this case, according to the third aspect of the present invention, since the operation code indicating whether or not each member can be used is stored in the storage means a, the operation is performed without using the time limit data. The code is searched by the operation code searching means g, and the operation code determining means h can determine whether the member whose operation code corresponds to the operation code can be used or not. Therefore, it is possible to determine whether the member can be used or not by a simple process without the need for a calculation process using the deadline data.

Further, in this case, according to the configuration of the above-mentioned claim 4, as the operation code, the operation code indicating that the operation is possible, the abolition code indicating that the production is stopped and cannot be used, and the substitute member. Is set and the parallel operation code indicating that exists. Therefore, the operation code determination means h
Determines whether the operation code is the operation code, the abolished code, or the parallel operation code.

When the operation code is the in-use code, the cost data search means d searches the cost data, and when the operation code is the abolished code, the message output means f displays a message indicating that there is no usable member. When the operation code is the parallel operation code, there is a substitute member, so the operation code search means g searches the operation code of the substitute member, and the operation code determination means h determines the operation code of the substitute member. Is the operating code, it is determined whether or not the substitute member can be used, and if the substitute member can be used, the cost data of the substitute member is searched by the cost data search means d. Therefore, only by determining the operation code, it is possible to determine whether the member can be used and whether there is a substitute member, and the processing can be simplified.

Further, in this case, according to the configuration of claim 5, the operation code includes the present date based on the expiration data corresponding to each member by the operation code setting means i. In this case, the operation code is the in-use code, and when the deadline data does not include the current date, the operation code is the abolished code.

Further, the operation code setting means i changes the operation code from the code set as described above to the parallel operation code when the code of the substitute member corresponding to the member is registered for each member. It is supposed to change.

Therefore, as the maintenance of the data stored in the storage means a, for the members whose production is to be discontinued, the operation discontinuation date is automatically registered by registering the date when the production is discontinued as deadline data. The abolition code will be set as the operation code in
In addition, if there is a new member corresponding to the member to be discontinued, the member code of the new member should be newly set and the cost data etc. should be registered in correspondence with the member code of the new member. Thus, the operation code setting means i automatically sets a parallel operation code as an operation code, and the operation code searching means g retrieves the operation code of the new member and the operation code of the new member is the in-use code. If so, the cost data of the new material will be used for the estimation in place of the discontinued material.

Further, in this case, according to the configuration of claim 6, when the new code and the decommissioned code are added to the operation code, and the operation code judging means h judges the operation code as the new code. , The deadline data search means b
The operation start date indicating the operation start side limit of the range of the deadline data is searched, and the message output means f outputs a message indicating that the member cannot be used until the operation start date.

When the operation code judging means h judges that the operation code is the decommissioning code, the deadline data searching means b searches the operation end date indicating the operation end side limit of the range of the deadline data. Then, the message output means f
After the date of the above operation end, a message indicating that the member cannot be used is output.

Further, in this case, according to the configuration of claim 7, the operation code setting means i compares the operation start date of the deadline data of each member with the current date, and the operation start is started. If the date is later, the operation code is set to a new code, the operation end date of the above deadline data is registered, and the operation end date is compared with the current date. In the later case, the operation code is set to the deprecated code.

Further, in this case, according to the configuration of the above-mentioned claim 8, not only an estimate can be made using the cost data searched by the cost data searching means d, but also an order can be placed. Although the present invention has been described with reference numerals shown in FIG. 1 in the above-mentioned “means for solving problems” and “action”, the present invention is not limited to the configuration shown in FIG. Is.

[0035]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An estimate accumulating apparatus according to an embodiment of the present invention will be described below with reference to the drawings. The quotation accumulating device of this embodiment is an application of the quotation accumulating device of the present invention to a CAD system constituted by a computer system. In this embodiment, the quotation accumulating device is a part of the CAD system. It is supposed to work. And
The quotation accumulator which is a part of the CAD system is the above CA.
A house is designed by the D system, and after allocating each member (member) to each part of the designed house, the unit price of each member from the member code of the allocated member and the necessary processing cost to install each member (construction Cost), and the unit price and the processing cost are added up based on the amount of the member used for the house to obtain an estimate.

Further, in the quotation accumulating apparatus of this embodiment, when searching for the unit price and the processing cost, whether or not the production of the above-mentioned member has already been discontinued or is planned to be discontinued, and the substitution of the above-mentioned member is performed. It is for searching whether there is a member that can be used as.

The above CAD system is basically
When constructing a house, not in the field framework,
It is used for designing a panel type prefabricated house in which floors, walls, roofs, etc. are constructed by assembling floor panels, wall panels, and roof panels produced in factories at a construction site.

Next, the estimate accumulating device will be described with reference to the basic configuration of the CAD system including the estimate accumulating device shown in FIG. As is well known, the CAD system having the above-mentioned estimated unit price shown in FIG. 2 includes an arithmetic processing unit (so-called computer) 1 having a central processing unit and memories such as RAM and ROM serving as internal storage devices, a hard disk, An auxiliary storage device 2 including a magneto-optical disk,
The basic configuration is a display device 3 including a color display, an input device 4 including a keyboard, a pointing device such as a mouse, a tablet, and a digitizer, and an output device 5 including a printer and a plotter.

The auxiliary storage device 2 has two databases, a supply material database 2a and a locally procured material database 2b, registered therein. The supply material database 2a is, for example, a database of data of materials that are decided to be supplied by a home maker, and the locally procured material database 2b is, for example, of materials prepared by each sales company. It is a database of data.

That is, the supplied material database 2a is the one in which the data already prepared on the system side is registered, and the locally procured material database 2b is provided for the user to register the data. And
The database in which the user registers the data is a separate file as the locally procured material database 2b, so that when the user registers or deletes the data, there will be no problem with the data registered in advance on the system side. This is to prevent the processing from being delayed when the user registers data in the supply material database 2a having a large amount of data from the beginning.

Then, these two databases 2a,
At least the member information master file 2c is registered in 2b. The member information master file 2c of each of the databases 2a and 2b is linked to the processing cost master file 2d as described later. The member information master file 2c corresponds to each member code of each member, and shows the member name (A), configuration classification (B), standard size (C), unit price information (D), and previous shown in FIG. The data of nine items of member code (E), operation code (F), rear member code (G), operation start date (H), and operation end date (I) are registered as a data table.

3 to 5 show the items of the above-mentioned data table. Then, the member information master file 2c can call the data of the nine items corresponding to the member code of each member as described above. Further, in the CAD system, each member is processed by the member code, and the allocation of members and the like are also performed by the member code.
Therefore, if the data of each member can be called by the member code, all the processes on the CAD system can be performed.

The member name (A) is an item in which the product name of the member is registered. The above configuration category (B)
Occurs due to the method of registering member data in the member information master file 2c described later. That is, when registering member data in the member information master file 2c, it is possible to register in a set composed of a plurality of members such as a system kitchen set, and at the same time, register each member constituting the system kitchen set. You can register separately. Then, the components that are collectively registered in the set and those that individually register the members that make up the set are divided by the configuration divisions. For example, the members that make up the set are individually registered. In this case, the code of the composition section is set to 1, and when the members are collectively registered in the set, the code of the composition section is set to 2.

The standard size (C) of the member is an item in which the size of the member is registered. The unit price information (D) is an item for registering cost data such as the unit price of the member, and the cost data is further subdivided and registered as described later.

The front member code (E) is a member substantially equivalent to the above member, and when there is a member (front member) used before or in parallel with the above member, the member code of this front member is registered. It is an item for doing. For example, if the above front parts are in stock, this front part code (E)
By specifying, the data of the front member can be searched and the member can be reallocated to the front member.

The operation code is, for example, a code represented by a single digit, and each numeral has the following meaning. 0: In operation 1: Scheduled to be abolished 2: New 3: Scheduled for change 4: In parallel operation 9: Abolished

The above operation (code 0) indicates a member currently in operation, which is not scheduled to be abolished in particular, and a member for which the above operation end date (I) is not registered. is there. The above-mentioned abolition plan (code 1) indicates a member which has been decided to be abolished in the future and whose operation end date (I) has been registered.

The new item (code 2) indicates a member newly registered in the database. The member having a new operation code (code 2) is to be operated from now on, and the operation start date (H) is after the current date. Scheduled change above (code 3)
Is not used in this embodiment and is treated in the same manner as in the above operation (code 0).

The change schedule (code 3) is the above CA.
The code used in the D system, and the member whose operation code is scheduled to be changed (code 3) in the future is a member that is scheduled to be changed, but the structure currently designed and constructed is as described above. It is constructed with members. Therefore, the change schedule (code 3) is ignored by the quotation accumulating device of this embodiment, and is treated in the same manner as during operation (code 0).

The above-mentioned parallel operation (code 4) shows a member having a substitutable member. That is, for the members whose operation code is in parallel operation (code 4),
It is shown that there is a substitute member that can be used instead of the member.

The members indicated by the above-mentioned parallel operation (code 4) basically indicate the members whose production is discontinued after the replacement with the new product is decided, and the operation end date (I ), The date is registered, and the member code of the new product is registered in the rear member code (G).

Therefore, the member in parallel operation (code 4) is a member to be transferred to the substitute member, and the member in parallel operation (code 4) is used in the estimation stage by the estimation and integration device of this embodiment. In that case, it can be replaced with a substitute member.

Even if the operation end date (I) is not determined as described above, if there are two or more members that can be used in substantially the same manner, the operation code of the most preferable member is being operated. By setting the code to 0 and setting the operation codes of the other members to parallel operation (code 4), the most preferable member can be selected in the operation code determination process described later.

The abolished code (code 9) is a member whose date is registered in the item of operation end date (I) and whose date of registration in the item of operation end date (I) is before the current date. Is shown. That is, the members whose operation code has been abolished (code 9) have already been discontinued. As will be described later, when a member whose operation code has been abolished (code 9) is used at the stage of designing by the CAD system, a member that cannot be used by the operator is used in the estimation and integration device. A warning is given to prompt the change, and the automatic change to another member is not made.

That is, regarding the members that have substitute members without any particular problem and are to be abolished, the operation code is adapted to the above-mentioned parallel operation code, and the operation code is abolished (code 9). There is no substitute member, or even if there is a substitute member, the design etc. is different, it is difficult to change the member without the consent of the owner, so select a new member again Is what you need.

For example, if a member that has been discontinued without replacement with a new product or the new product has a different appearance from the old product and is mechanically changed, it is likely that there will be a complaint from the customer. The abolition (code 9) above applies to members.

Similarly, the abolition plan (code 1) is an operation code applied to a member having no substitute member, that is, no rear member code is registered, and the rear member code is registered. In this case, the operation code is not in abolition (code 1) but is in parallel operation (code 4).

The rear member code (G) is registered for a member changed to another member or a member to be changed, and the member corresponding to the rear member code (G) is registered. The member code of the substitute member to be substituted is registered. That is, the member to which the rear member code (G) is registered is a member that can be switched to another member for reasons such as production discontinuation as described above.

The member having the rear member code (G) registered therein is automatically converted into a member corresponding to the member code registered in the rear member code (G) in the estimation integrating means of this embodiment, as will be described later. The quotation has been changed. The operation start date (H) is an item for registering the date when the corresponding member can be used as described above. The operation end date (I) is an item for registering the date of discontinuation in the member whose use is decided to be discontinued due to the production discontinuation as described above.

The items of the unit price information (D) are further finely divided as shown in FIG. In addition,
FIG. 4 shows items further provided in the unit price information (D) of the data table. First, the item of unit price information (D) is divided into four items of unit classification (J), material construction classification (K), construction cost (L) and material unit price (M). And the unit classification (J) is
Some parts are ordered in length (m units), some are ordered in area (m × m units), one set is ordered, and other units are ordered. This is an item for which a unit for ordering is registered.

The material class (K) is generated by the method of registering member data in the member information master file 2c described later. That is, for example, when ordering an interior cloth, for a member constituting a house, a cloth of a predetermined width is ordered by a length, and when a work of pasting the cloth is ordered, an area of the inner surface of the wall is ordered. In such a case, since the unit classification (J) is different for one member, it is possible to register both the unit price of the member and the construction cost of the member corresponding to one member code. In some cases, it may be difficult, and in such a case, the member unit price (M) and the member construction cost (L) can be registered in the member information master file 2c by different member codes.

Therefore, in the member information master file 2c, as described above, for one member, only the member is registered, only the construction of the member is registered, and both the member and the construction are registered. Therefore, it is possible to distinguish these differences by the above-mentioned material work section (K). In the above-mentioned material work section (K),
"Material", which registers only members (excluding construction cost data), "labor", which registers only construction of members (excludes material unit price data of members), and both components and construction A code indicating the category of "material work" is registered.

The construction cost (L) is divided into three construction man-hour divisions (La, Lb, Lc), and each construction man-hour division is a construction division (L1) and processing time (L).
2), processing unit price (L3). The above three construction man-hour categories (La, Lb, Lc) are
When a plurality of processes having different construction divisions (L1) to be described later are required to attach one member, the construction division (L1), processing time (L2),
The item of processing unit price (L3) is provided so that a plurality of items can be registered for each process having a different construction category.

Therefore, if there is a process of different work divisions in the work of mounting one member, the items of machining time (L2) and machining unit price (L3) can be registered for each construction division (L1). ing. Then, the construction category (L
In 1), for example, the foundation construction is performed by a concrete-related contractor such as formwork or reinforcing bar work, the air-conditioning-related member installation work is performed by an air-conditioning-related contractor, and the water supply-related members are related to water supply-related. The work done by the contractor and the work related to the installation of the members such as electric wiring is done by the contractor related to electricity. It is a classification provided for each type.

The work classification (L1) includes, for example, foundation work, air conditioning work, plumbing work, electrical work, miscellaneous work (particularly work not required by a predetermined contractor).
Also, the construction classification (L1) of the member information master file 2c
Is the work classification (L
It corresponds to 1).

The processing time (L2) (shown in FIG. 4) is
This is the total work time required to attach each member. That is, the processing time (L2) indicates the working time × the number of workers, and the processing cost master file 2d.
Is a numerical value for obtaining a processing unit price (L3) by multiplying an estimated unit price (N1) per unit time (illustrated in FIG. 5) described later.

The processing unit price (L3) is a blank data item in the member information master file 2c, and the processing unit 1 processes the processing cost (L) of the member information master file 2c. Time (L2),
It is obtained by multiplying the estimated unit price per unit time (N1) of the processing cost master file 2d, and the estimated unit price per unit time (N1) of the processing cost master file 2d (illustrated in FIG. 4). It is an item linked to.

When the estimated unit price (N1) per unit time of the processing cost master file 2b is updated, the item of the processing unit price (L3) of the member information master file 2c is updated. . The processing unit price (L
3) may be updated each time the item of the processing unit price (L3) is called, and the estimated unit price (N) may be updated.
The item of processing unit price (L3) may be updated when the item of 1) is updated.

The item of member unit price (M) is divided into three generations (Ma, Mb, Mc). These three generations are for showing the unit price of each member in the past, present and future. The price of the member registered in the member information master file 2c is to be completely revised every half year, for example, based on the contract with the supplier of the member. (Mb) is for indicating the unit price of the member at the time of the nearest whole price revision.

The past generation (Ma) indicates the unit price of the member determined at the time of the total price revision immediately before the total price revision of the current generation (Mb). The future generation (Mc) is used to indicate the expected unit price of each member when the full price revision in the next period is performed. And each generation (Ma, Mb, Mc) is also effective start date (M1), material unit price (M2), construction cost ratio (M
3), sales expense ratio (M4), unit price for ordering (M5), and unit price for ordering (M5) is classified as Category 1 (M5)
Items are divided into 1) to 5 (M55).

The effective start date (M1) indicates the date when the operation of the revised price is started in the overall price revision. Also, if there is an individual price revision instead of the full price revision, the effective start date (M1) above
It is possible to deal with this by registering the date when the price starts operating and updating the following items such as material unit price (M2).

The material unit price (M2) is a value representative of each section (M51 to M55) of the order unit price (M5) described later, and basically shows the unit price of each member used for estimation. . The construction expense ratio (M3) is a ratio of the construction worker's margin to the sum of the value shown in the material unit price (M2) and the processing unit price (L3) obtained as described above, as the construction worker's expense. In the estimation, the margin of the builder is added to the sum of the material unit price (M2) and the processing unit price (L3).

The sales expense ratio (M4) indicates the ratio of the seller's margin to the sum of the value of the material unit price (M2) and the value of the processing unit price (L3) as the expense of the house seller. Yes, the above unit price (M
The margin of the seller is added to the sum of the value of 2) and the value of the processing unit price (L3).

The above-mentioned ordering unit price (M5) is the price when actually ordering parts, and the same parts may differ depending on the supplier and the transportation cost due to the positional relationship between the supplier and the recipient. The price may be different depending on factors such as the difference in price, and different prices are classified from Category 1 (M51) to Category 5 (M5
You can register up to 5 items in 5). The material unit price (M2) is determined according to the ordering unit price (M5) and is mainly used when requesting an estimate. The value of does not change.

Further, each ordering unit price (M5) is classified (M5
1 to M55) are used to output a purchase order, and are classified (M51 to M) in the above-mentioned ordering unit price (M5).
The ordering party can be specified by 55). In outputting the quotation, it is not always necessary to use the material unit price (M2), and the value registered in the order unit price (M5) category (M51 to M55) closer to the actual cost is used. Is also good.

The processing cost master file 2d is shown in FIG.
As shown in (2), there are two items: a construction category (L1) and a construction cost (N) indicating a unit price per unit time corresponding to each construction category. 5 is a diagram showing items of data stored as a data table in the processing cost master file 2d.

The items of the construction category (L1) are as follows:
It corresponds to the construction category (L1) of the construction cost (L) of the member information master file 2c, and the actual processing unit price (L)
When calculating 3), the construction cost (N) per unit time of the construction category (L1) of the machining cost master file 2d corresponding to the construction category (L1) retrieved corresponding to the member code of the member is calculated. The processing unit price is referred to by multiplying the processing time (L2) of the construction cost (L) of the member information master file 2a and the construction cost (N) per unit time corresponding to the construction category (L1) as described above. It is supposed to be calculated.

The construction cost per unit time (N)
Indicates that there are three generations (Na, Nb, Nc) corresponding to the three generations (Ma, Mb, Mc) in the item of unit price (M) of the member information master file 2c, and each generation (Na, Nb, Nc) is the estimated unit price (N
1) and a unit price for ordering (N2). Further, the unit price for ordering (N2) includes categories 1 (N21) to 5 (N2).
There is item 5).

Category 1 (N21) of the above order unit price (N2)
From Category 5 (N25) is Category 1 of ordering unit price (M5) of the unit price (M) of the member information master file 2c.
Similar to (M51) to Category 5 (M55), it is used to register a different work cost due to a difference in ordering party or the like.

The estimated unit price (N1) is the material unit price (M) of the member unit price (M) in the member information master file 2c.
Similar to 2), it is a value provided to unify the values of category 1 (N21) to category 5 (N25) of the order unit price (N2), and the estimated unit price (N1) is It is used, and when ordering, it is classified as Category 1 (N
Any one of the values from 21) to 5 (N25) is used. As in the case of the member information master file 2c, it is not always necessary to refer to the estimated unit price (N1) when outputting the estimate, and any one of the order unit prices (N2) (N21 to N25)
May be specified.

In the auxiliary storage device 2, the CA is stored.
The member code of each member allocated to the house designed by the D system and the usage amount of each member (amount in units of the above unit division) are stored as the allocated member code file 2e. Further, in the auxiliary storage device 2, an integrated data file 2f constructed by processing the data of the allocation member code file 2e on the basis of the operation code determination processing described later is registered by the estimate integrating device of this embodiment. It is supposed to be done.

Further, the auxiliary storage device 2 is selected by the arithmetic processing device 1 as described later, and the message displayed on the display device 3 is stored as an error message file 2g. The message stored in the error message file 2g is as follows corresponding to the operation code. In the following message, the data retrieved from the member information master file 2c is inserted in "".

A1: Supply material "member code, name" is "
The operation will start from the "operation start date". [New plan] A2: Locally procured materials "Part code, name" will start operation from the "Operation start date". [New plan] B1: Supply material Code, name "is" operation end date "
It will be abolished. [Planned to be abolished] B2: Locally procured materials "Part code, name" are scheduled to be abolished at "Operation end date". [Abolition]

C1: Supply material "member code, name" is "
It was abolished on the operation end date. [Obsolete] C2: Locally procured material "part code, name" was abolished on the "operation end date". [Abolished] D1: Supply material "part code," Changed "Name" to "Substitute Material", "Part Code, Name". [Parallel Operation] d: Changed locally sourced material "Part Code, Name" to "Substitute Material" Part Code, Name. "[Parallel Operation]

E1: The supplied material "member code, name" is used as it is. (Since the substitute material "part code, name" is not registered) [Parallel operation] E2: Locally procured material "material code, name" will be used as it is. (Because the substitute material "part code, name" is not registered) [Parallel operation] C1: Supply material "material code, name" is used as it is. (Because the substitute material "part code, name" is scheduled to start (operation is scheduled to start from "operation start date")) [Parallel operation] C2: Locally procured material "part code, name" will be used as it is. (Because the substitute material "part code, name" will be newly scheduled (operation will start from "operation start date")) [Parallel operation]

G 1: Use the supplied material "member code, name" as it is. (Because the substitute material "part code, name" will be decommissioned (decommissioned on "operation end date")) [Parallel operation] K2: Locally procured material "part code, name" will be used as it is. (Because the substitute material "part code, name" will be abolished (will be abolished on "operation end date")) [Parallel operation] C1: Supply material "material code, name" will be used as it is. (Because the substitute material "part code, name" will be abolished (discontinued on "operation end date")) [Parallel operation] Q2: Locally procured material "part code, name" will be used as it is. (Because the substitute material "part code, name" is scheduled to be abolished (discontinued on "operation end date")) [Parallel operation]

K1: The material corresponding to the supplied material "material code" is not registered in the database. [Unregistered] Ke 2: The material corresponding to the locally procured material "material code" is not registered in the database. [Unregistered]

The arithmetic processing unit 1 basically has a function as a well-known residential CAD system. Further, the arithmetic processing device 1 is used for a function of allocating the various panels used as a structure of a house to a wall, a floor, a roof, etc., a function of allocating members other than the panel in the same manner, and an interior or exterior of a house. It has a function of allocating members.

Further, the arithmetic processing device 1 has the following functions as the functions of the estimate integrating device. First,
The arithmetic processing unit 1 uses the member information file 2c of the supplied material database 2a and the locally procured material database 2b.
With reference to, it has a function of setting an operation code to a member corresponding to each member code.

Further, the arithmetic processing unit 1 searches the operation code based on the member code of each member assigned to the house to be constructed by the CAD system, and corresponds to the above member code based on the operation code. It is determined whether or not the member to be used can be used as it is, and if there is a substitutable member, the member code of the substitute member that can be used as a substitute is searched to determine whether or not the member can be used. It has a function of changing the corresponding member into a substitute member. Further, the arithmetic processing device 1 has a function of selecting a message prepared in advance based on the result of determination of the operation code and outputting it to the display device 3.

The arithmetic processing unit 1 has a function of inspecting the data of unit price information of usable members and substitute members, and creating a purchase order or an estimate. A method of estimating the construction cost of a house to be constructed by using the CAD system for a house having the above-described estimation and accumulating device will be described with reference to the flowchart of FIG. Also,
In the CAD system provided with the above-mentioned estimation and accumulating device, the supply material database 2a and the locally procured material database 2b are constructed.

That is, the data of each item of the member information master file 2c and the processing cost master file 2d is registered in the supply material database 2a and the locally procured material database 2b. As described above, the supply material database 2a is a database in which the side providing the CAD system registers and maintains the data, and the higher locally procured material database 2b is a database in which the user registers and maintains the data. .

The operation code is set by the arithmetic processing unit 1 instead of inputting data from outside the CAD system. Also,
The operation code is not set only when the first data is registered, but is updated when the data of the current date is updated or the data is changed by the maintenance of the database.

The operation code is set by the arithmetic processing unit 1 as follows. First, in the above-mentioned data item corresponding to each member code, all the operation codes of the members in which the rear member code (G) is registered are set to be in parallel operation (code 4). Next, for the remaining members, the members whose operation end date (I) is not registered and whose operation start date (H) is before the current date are:
During operation (code 0) is set.

As to the member for which the change schedule (code 3) is designated in advance as described above, the change schedule (code 3) is set instead of the operation (code 0). If the operation start date (H) is earlier than the current date in the remaining members, new (code 2) is set.

Further, the operation end date (I) is registered in the remaining members, and when the operation end date (I) is earlier than the current date, the abolition schedule (code 1) is set.
When the operation end date (I) is registered in the remaining members and the operation end date (I) is earlier than the current date, the abolition (code 9) is set.

As described above, the supply material database 2
The data registration of a and the locally procured material database 2b is completed. Next, the house is designed in the CAD system, and each member is assigned to each part of the house. A member code indicating the member and the amount of the allocated member are stored in the auxiliary storage device 2 as an allocated member code file 2e.

Therefore, when the calculation of the estimate is instructed from the input device 4, the member code of the member used in the house of the allocated member code file 2e stored in the auxiliary storage device 2 is stored in the main memory (shown in the figure) of the arithmetic processing unit 1. Are sequentially input (step S1).

The arithmetic processing unit 1 retrieves the operation code corresponding to the member code by searching the member information master file 2c of the supply material database 2a or the locally procured material database 2b (step S2). In addition,
At this time, the data corresponding to the input material code has not been registered in either the supplied material database or the locally procured material database due to error in the material code data due to noise or input error. In this case, the message 1 or 2 is displayed on the display device 3 from the error message file 2g,
It is designed to alert the operator.

If the operation code is in operation (code 0) or scheduled to be changed (code 3) (step S
3) The member code of the allocated member code file 2e is fixed as it is and registered in the integrated data file 2f (step S4). When the operation code is in parallel operation (code 4) (step S5), the supply material database 2a or the locally procured material database 2 is used.
The item of the rear member code (G) corresponding to the above member code of the member information master file 2c of b is searched (step S6).

Here, in the case where the operation code is in parallel operation (code 4), as will be described later,
The case of other operation codes will be continuously described. When the operation code is new (code 2) (step S7), the error message file 2g is searched for in the above item A1 or A2 (A1 when the supply material database is searched, and the locally procured material database). In case of A2, the material code can be used to distinguish between the supplied material and locally procured material) and the message is displayed on the display device 3 (step S
8) The operator is warned that the member cannot be used until the operation start date (H) is reached.

Then, the arithmetic processing unit 1 does not change the member code of the member whose operation code is new (code 2) and directly registers it in the integrated data file 2f (step S4). At this time, the operator compares the actual construction start date and the operation start date (H) with each other,
If there is no particular problem, continue the operation.

If there seems to be a problem, consider changing the member, continue the operation for the time being if it seems necessary for the owner's consent, etc., and if it is possible to change it on the spot, add the integrated data file. The member code registered in 2f is changed to a member code of another member. If the operation code is scheduled to be abolished (code 1) (step S9), the date of the item of operation end date (I) corresponding to the member code is read.

Then, the date of the operation end date (I) and the current date are compared and calculated, and it is determined whether or not it is within a predetermined period, here, for example, within one month (step S10). Then, if it is within one month, the message 1 or 2 is read from the error message file 2g, the message is displayed on the display device 3 (step S11), and the operator abolishes the member. Warn that the due date will be near.

Further, the arithmetic processing unit 1 directly registers the member code of the member whose operation code is to be abolished (code 1) in the integrated data file 2f without changing it (step S4). Also, the operator compares the operation end date included in the message with the start date, etc. based on the warning,
Consider changing the material. In addition, since the owner's consent may be required when changing the member, basically, the integrated data file 2f is left as it is.

When the member can be changed on the spot, the operator changes the member code in the estimated member code file 2f to the member code of another member. Also, if the date of the operation end date (I) and the current date are not within one month, there is still a period until the abolition of the members,
No message is output and the integrated data file 2f
The member code of the member whose operation code is scheduled to be abolished (code 1) is registered as it is (step S4).

When the operation code is abolished (code 9) (step S12), the message c1 or c2 is selected from the error message file 2g and the message is displayed on the display device 3. By (step S13), the operator is warned that a member that has already been abolished and cannot be used is used in the design.

Then, in this case, the member code is not confirmed, the member code is not registered in the ordering and integrated data file 2f, and the process proceeds to the determination processing of the operation code of the next member. Further, the operator considers a substitute member because the member whose operation code is abolished (code 9) is not written in the integrated data file 2g.

In this case, the operator may specify another member code on the spot for the easily changeable one as described above, or the one for the owner who needs the consent of the owner. After receiving the approval, another member code may be designated. Next, a case where the operation code is in parallel operation (code 4) in step S5 will be described.

First, the member code of the item of the rear member code (G) corresponding to the member whose operation code is in parallel operation (code 4) is searched (step S6). Then, the operation code corresponding to the member code of the item of rear member code (G) is searched from the supply material database 2a or the locally procured material database 2b (step S14).

At this time, if the operation code corresponding to the member code in the item of the rear member code (G) cannot be retrieved, the error message file 2g
Or, the message of No. 2 is selected, the message is displayed on the display device 3 (step S15), and the item of the rear member code (G) that substitutes the member whose operation code is in parallel operation (code 4). The operator is warned that the data of the substitute member whose member code is registered in is not registered in the supplied material database and the locally procured material database. And the original operation code is in parallel operation (code 4)
The member code of the determined member is registered in the ordering and estimating database (step S4).

Next, substantially the same processing as the above-mentioned first operation code determination processing is performed based on the above operation code.
When the operation code is in operation (code 0) or is scheduled to be changed (code 3) (step S16), the message 1 or 2 is selected from the error message file 2g, and this is displayed on the display device 3 (Step S17), the original member code registered in the allocated member code file 2e is registered in the estimated member code file 2f instead of the member code registered in the item of the rear member code (G). (Step S4).

When the operation code is in parallel operation (code 4) (step S18), the step S6 is executed again so that the rear part code (G) of the member corresponding to the operation code is retrieved and read. Return. If the operation code is new (code 2) (step S19), the message 1 or 2 is read from the error message file 2g and the message is displayed on the display device 3 (step S20). The member code of the member in parallel operation with the original operation code is registered in the integrated data file without changing to the member code of the substitute member whose operation code is new (code 2) (step S4).

If the operation code is scheduled to be abolished (code 1) (step S21), then the operation end date (I) corresponding to the member code registered in the item of the rear member code (G) is set. It is determined whether or not the date between the operation end date (I) and the current date is within one month after being searched (step S22). Then, if the date between the operation end date (I) and the current date is within one month, the message of key 1 or key 2 is selected from the error message file 2g and displayed on the display device 3. (Step S20), the operator is warned that the substitute member of the member whose operation code is in parallel operation (code 4) is scheduled to be abolished and cannot be used.

Then, without changing the member code of the member whose operation code is in parallel operation (code 4) to the member code registered in the rear member code (G), it is directly registered in the integrated data file 2f (step S4). If the date between the operation end date (I) and the current date is one month or more, the error message file 2g
Alternatively, by selecting the message 2) and displaying the message on the display device (step S17), the operator is warned that the member has been replaced with a substitute member for the member. Then, the member code is changed to the member code registered in the rear member code (G) of the member code and registered in the integrated data file 2f (step S4).

The above operation code is abolished (code 9).
In the case of (step S23), the message 1 or 2 is selected from the error message file 2g, and the message is displayed on the display device 3 (step S23).
20), since the substitute member of the member whose operation code is in parallel operation (code 4) has already been abolished, it is the operator to use the member whose original operation code is in parallel operation (code 4). To warn.

Then, the member code of the member whose original operation code is in parallel operation (code 4) is directly registered in the estimated member code file 2f (step S4).
Then, the above processing is sequentially performed by the allocation member code file 2
This is performed for all member codes registered in e.

Next, an estimate or a purchase order is created based on the member code determined as described above. First,
The arithmetic processing unit 1 searches the member information master file 2c based on the member code of the integrated data file 2f stored in the auxiliary storage unit 2. Then, the arithmetic processing device 1 reads the data of the member unit price (M) and the construction cost (L) item of the unit price information (D) item corresponding to each member code from the member information master file 2c.

At this time, regarding the unit price (M) of the member, the material unit price (M2) of the current generation (Mb) is set as the initial setting,
The construction expense ratio (M3) and the sales expense ratio (M4) are called in. As above, the current generation (Mb)
By calling in the data of the above, it is possible to calculate an estimate at the current transaction price of materials.

On the other hand, by designating the past generation (Ma), an estimate can be calculated at the current previous transaction price. This is used in the following cases. is there. For example, by constructing a house several months later, the house is designed, and the price is determined by using the estimate accumulating device of this embodiment based on the price of the material at that time to determine the price and the owner and the contractor. Suppose you have made a contract with and then before building a house,
The unit price (M) of the member information master file 2c is completely revised.

When a part of the design is changed after the full revision and before the housing is constructed, and the estimate is made again, the price after the full revision is used. In that case, the price increase of all the components used in the house will be calculated as a newly added estimate, which will be different from the price at the time of contract. Therefore, by using the material price (M2) of the past generation (Ma), it is possible to re-estimate the house including the design change portion without causing a difference from the price at the time of contract. Become.

When the effective start date of the current generation (Mb) is after the current date, the data of the past generation (Ma) is used for the member. In addition, the data of the future generation (Mc) is
For example, if it is known that the construction of a house will take place from half a year to a year later, by making an estimate using the data of the future generation (Mc), the estimated price and the actual year after a half year will be reached. This is to prevent a large discrepancy from the price when a house is built later, and is particularly effective data when making a temporary estimate.

As described above, since three generations are prepared for the material unit price (M), the past generation or the future generation can be designated by specifying the past generation or the future generation except when the current generation is used. You can make such an estimate. Then, in each member code, the processor 1 uses the data of the designated generation of the member unit price (M) for the material unit price (M2), the construction expense ratio (M3), and the sales expense ratio (M) as described above.
Read 4).

As mentioned above, the unit price (M) of the member is
In addition to material unit price (M2), multiple categories (G51 to G55)
The unit price for ordering (M5), which is divided into, is registered. The ordering unit price (M5) is the material unit price actually paid to the ordering party and may vary depending on the ordering party etc. as described above. However, use this instead of the material unit price (M2). Is also good. When the unit price for ordering (M5) is used instead of the unit price for material (M2), the division (M51 to M55) of the unit price for ordering (M5) is designated in correspondence with the supplier.

Next, the arithmetic processing unit 1 retrieves and calls the processing unit price (L3) of the construction cost (L) of the member information master file 2c based on the above member code. At this time, since the item of the processing unit price (L3) of the processing cost (L) is linked to the data of the processing cost master file 2d, first, the work classification (L) of the member information master file 2c is described.
Search 1) corresponding to the member code.

Next, the construction cost (N) in the machining cost master file 2d is searched based on the construction category (L1). At this time, the data of the construction cost (N) of the processing cost master file 2d is also the member unit price (M) of the member information master file 2c.
Since it has three generations (Na, Nb, Nc) as in item (1), one generation (Na, Nb, Nc) is selected as in the case of the unit price (M) of the member.

Further, in the data of each generation (Na, Nb, Nc), in addition to the estimated unit price (N1), the ordering unit price (N1) as in the item of the material unit price (M) generation of the member information master file 2c is set. N2) is divided into five categories (N21 to N25) and registered, and the unit price for ordering (N2) is used instead of the estimated unit price (N1) as in the case of searching the member information master file 2c. be able to.

The estimated unit price (N1) retrieved from the processing cost master file 2d corresponding to the construction category (L1)
Alternatively, the machining time (L) searched based on the unit price for ordering (N2) and the member code in the member information master file 2c
2) can be multiplied to obtain the processing unit price (L3) of the construction cost (L) of the member information master file 2c.

In the member information master file 2c, when data is registered in a plurality of construction man-hour categories (La, Lb, Lc) of the item of construction cost (L) corresponding to the member code, Construction man-hour classification (La, Lb, L
The above processing is performed for each c), and the above processing unit price is obtained for each construction man-hour category.

The value of the item of processing unit price (L3) of the member information master file 2a is obtained from the data of the item of construction cost (N) of the processing cost master file 2d based on the member code by the arithmetic processing unit 1. It is not necessary to search for the machining unit price (L3), and for example, when the data of the machining cost master file 2d is updated, the items of the machining unit price (L3) corresponding to all the member codes are obtained as described above. It may be registered as an update.

Next, the unit price (M2) (or ordering unit price (M5)) corresponding to the member codes of all the members allocated to the designed house by the arithmetic processing unit 1 as described above, and the construction cost. Rate (M3), sales expense ratio (M
4) Calculate the processing unit price (L3), multiply the sum of each material unit price (M2) and the processing unit price (L3) by the construction expense ratio (M3) and the sales expense ratio (M4), and then calculate the result. M2) and the processing unit price (L3) are added to determine the price of each member.

Then, the price of each member allocated to the designed house is added up in accordance with the usage amount of each member to calculate an estimate of the designed house.
Further, by using the item of ordering unit price (M5) in the item of material unit price (M) of the unit price information (D), the ordering price can be calculated and the purchase order can be prepared.

As described above, according to the quotation accumulating device of this embodiment, the operation start date (H) together with the data of the cost of each component such as the unit price (M) of the component necessary for preliminarily estimating and ordering. And the data of the deadline such as the operation end date (I) and the member code (subsequent member code (G)) of the substitutable member when there is a substitutable member are registered as a searchable database by one member code. Therefore, when accumulating actual estimates, it is possible to easily judge whether the components before the operation start date and after the operation end date are not used at the stage of designing the house and allocating the components. When there is a substitutable member, the member code of the substitutable member can be easily searched and the member can be automatically switched.

Further, by setting the operation code corresponding to each member in advance based on the data of the operation start date (H) and the operation end date (I), the process before the actual estimation is performed. As a result, the process of deciding whether or not each member can be used can be extremely simplified, and even if a large number of members have to be processed due to the large number of members being allocated, as in a house, it can be done quickly. Processing can be performed.

Since the data of the members that can be allocated at the stage of designing the house and allocating the members are likely to be updated in an arbitrary period, it is possible to use the discontinued members at the actual estimation stage. The property is not so high, basically, most of the allocated members can be used at the stage of housing design and member allocation, and all the members can be searched for a few unusable members. It is extremely inefficient to search the operation end date (I) of the above and perform the date comparison process for the member for which the operation end date (I) is registered. In the quotation accumulator, by setting the operation code in advance, it is possible to judge whether or not the material can be used only by looking at the above operation code that can be searched with one material code together with the cost data. It can be.

That is, since the above operation code is in operation (code 0) in most of the allocated members, the processing of whether or not the member can be used is simply the operation code (the operation code retrieved by the member code). This is a process of only confirming that the numerical value of F) is 0, and it is possible to significantly reduce the processing amount as compared with the case of performing the date calculation.

Then, only when the operation end date (I) is set and the operation code is scheduled to be abolished (code 1), the date is calculated. Further, when the substitute member is determined, the rear member code (G) is registered as the data that can be searched by the member code as described above, and
Since the operation code is set to parallel operation (code 4), the substitute member will be searched only when the operation code is parallel operation (code 4), and the search will simply be the rear material code (G). This can be done simply by reading the member code registered in the item.

Therefore, according to the quotation accumulating apparatus of this embodiment, the period in which the member can be operated by one member code, the operation code indicating the operating method of the member based on the period, and the cost data of the member. Can be read, and whether the member can be used with the above operation code,
In addition, since it is possible to determine whether there are substitute members, it is possible to reduce the total mistakes that would result in an estimate of a member that cannot be used or a member that will be obsolete immediately. If there is a possible member, it can be converted into an appropriate member and integrated.

Further, in the above embodiment, when the operation code of the member is in parallel operation (code 4), the member code of the substitute member is registered in the item of the rear member code (G) as described above. However, as for the member code registered in the member code (G), the operation code corresponding to the member code is also determined. Therefore, as described above, in some cases, the member code is not the substitute member but the original member code. The member of is selected, and the appropriate member with the least risk is selected.

In the operation code determination, if the assigned members are not used for the estimation as they are,
As described above, the message is selected and displayed from the error message file 2g, so that the operator can know the determination of the estimation and integration device, reflect the operator's intention based on the determination, and perform the subsequent processing. You can get a machine to consider.

In this embodiment, the quotation accumulating device of the present invention is applied to a CAD system for a house, but the product is often composed of many members and parts, and the members and parts used are often different. It is possible to use the quotation accumulating device of the present invention as a device for obtaining a quotation, and the method of using the quotation accumulating device of the present invention is not limited to the estimation of a house.

The number of items in the data table of the member information master file 2c and the processing cost master file 2d is not necessarily limited to those shown in FIGS. Further, although the database is divided into the supply material database 2a and the locally procured material database 2b, it is not always necessary to divide it into two, and it is possible to unify them into one database or configure them with three or more databases. May be.

[0143]

As described above in detail, according to the structure of claim 1 of the present invention, a member having deadline data that does not include an arbitrary date, for example, production stop before the arbitrary date. When a member that has been decided to be assigned is assigned at the design stage, a substitute member for the member is selected instead of the member, and the substitute member is used for the estimation. It becomes possible to use a substitute member instead of the member whose production has been discontinued.

Therefore, by updating the data stored in the above-mentioned storage means used for estimation, even if the data of the member on the member allocation side is a little old, the production was discontinued at the time of the estimation. It is possible to sort unusable members such as members and usable members, and if there are members that can be substituted for unusable members, replace them with unusable members. Can be used.

That is, by maintaining the data on the side of the estimating and accumulating device of the present invention, it is possible to always deal with a new member even if the maintenance interval of the data when allocating the member is lengthened. It is possible to simplify maintenance, save labor, and reduce the maintenance cost of the database. Further, it is possible to obtain a more accurate estimate without estimating the unusable member as it is.

According to the above-mentioned structure of claim 2,
In the deadline determination means, when there is no usable member for the member corresponding to the deadline data determined not to include the arbitrary date, the message output means,
Since a message indicating that there are no usable members is output, even if you assign a discontinued member at the time of design, you can still respond by changing the design, including changing the member. It is possible to place an order for a material that cannot be used, and perform a quicker process compared to designing and allocating the material after the contractor has notified that the material has been discontinued. At the same time, it is possible to prevent damage that may occur due to an incorrect estimation by integrating the cost data of unusable members at the time of estimation.

According to the third aspect of the present invention, since the operation code indicating whether or not each member can be used is stored in the storage means a, the operation code is operated without using the time limit data. The code search means can be searched, and the operation code determination means can determine whether or not the member corresponding to the operation code can be used. Therefore, it is not necessary to calculate the date using the deadline data, and the processing for determining whether or not the member can be used by the calculation processing device at the time of estimation is greatly simplified, and a product that uses many members such as a house In the above, it is possible to shorten the time required for the process of determining whether a member can be used, and by performing the process of whether the member assigned as described above is available, the time required for the estimation process. Can be prevented from increasing.

According to the above-mentioned structure of claim 4,
As the operation code, the operation code that indicates that it is available and the abolition code that indicates that production is stopped and cannot be used,
A parallel operation code indicating that a substitute member exists is set. Therefore, the operation code determination means h determines whether the operation code is the in-operation code, the abolished code, or the parallel operation code.

Then, when the operation code is the in-use code, the cost data searching means searches the cost data, and when the operation code is the abolished code, the message output means outputs a message indicating that there is no usable member. However, if the operation code is the parallel operation code, there is a substitute member, so the operation code search means searches the operation code of the substitute member, and the operation code determination means determines that the operation code of the substitute member is the operating code. It is determined whether or not the substitute member is usable, and if the substitute member is usable, the cost data of the substitute member is searched by the cost data search means. Therefore, just by judging the operation code,
It is possible to determine whether the member can be used and whether there is a substitute member, and it is possible to further simplify the process.

According to the fifth aspect of the present invention, the operation code is set by the operation code setting means based on the time limit data corresponding to each member when the time limit data includes the current date. Is the operating code, and when the deadline data does not include the current date, the operating code is the abolished code.

Further, the operation code setting means changes the operation code from the code set as described above to the parallel operation code when the code of the substitute member corresponding to the member is registered for each member. It is supposed to do.

Therefore, as the maintenance of the data stored in the storage means, for the member whose production is to be discontinued, the date when the production is discontinued is registered as the deadline data so that the operation code setting means automatically operates. When the abolition code is set as the code, and if there is a new member corresponding to the member whose production is discontinued, the member code of the new member is newly set and the member code of the new member is supported. Then, by registering the expense data and the like, the operation code setting means automatically sets the parallel operation code as the operation code, and the operation code searching means searches for the operation code of the new member. If the operation code of the new component is the in-use code, the cost data of the new component will be used for the estimation instead of the discontinued component. Is will be.

Further, in this case, according to the configuration of claim 6, when the new code and the abolition scheduled code are added to the operation code and the operation code judging means judges the operation code as the new code, The deadline data retrieval means retrieves the operation start date indicating the operation start side limit of the range of the deadline data, and the message output means outputs a message indicating that the member cannot be used until the operation start date. Become.

When the operation code determining means determines that the operation code is the decommissioning code, the deadline data searching means searches for the operation end date indicating the limit on the operation end side of the range of the deadline data, The message output means outputs a message indicating that the member cannot be used after the date when the operation ends.

According to the configuration of claim 7, the operation code setting means compares the operation start date of the time limit data of each member with the current date, and the operation start date is later. If the operation code is set to a new code, the operation end date of the deadline data above is registered, and the operation end date is compared with the current date, and the operation end date is later In addition, the operation code is set to the deprecated code. Therefore, by registering the operation start date and the operation end date in the storage means, the operation code including the new code and the decommissioning code can be automatically set.

Further, according to the configuration of claim 8,
It is possible to place an order as well as an estimate using the cost data retrieved by the cost data retrieval means.

[Brief description of drawings]

FIG. 1 is a block diagram showing a basic configuration of an estimate integrating device of the present invention.

FIG. 2 is a C to which an estimate integrating device according to an embodiment of the present invention is applied.
It is a block diagram showing the basic composition of an AD system.

FIG. 3 is a drawing for explaining each item of a data table used in the estimate integrating device of the above embodiment.

FIG. 4 is a drawing for explaining each item of a data table used in the estimate integrating device of the above embodiment.

FIG. 5 is a drawing for explaining each item of the data table used in the estimate integrating device of the above-described embodiment.

FIG. 6 is a flow chart showing a method of determining an operation code of a member by the estimate integrating device of the above embodiment.

[Explanation of symbols]

1 arithmetic processing device (deadline data search means b, deadline determination means c, cost data search means d, integration means e, operational code search means g, operational code determination means h, message output means f, operational code setting means i) 2 Auxiliary storage device (storage means a)

Claims (8)

(57) [Claims] 1. An estimate accumulating device for accumulating costs required for constructing a product constructed from various members, which is necessary for estimating a member code indicating each member and a unit price of each member. Cost data, deadline data indicating the range of usable period of each member, and member code indicating a substitute member that can be used in place of each member are stored in association with each other. The expiration date data retrieval means for retrieving the expiration date data stored in the storage means corresponding to the member determined to be operated is compared with the expiration date data retrieved by the expiration date data retrieval means, and any date A deadline determining means for determining whether a date is within the range of the deadline data, and a member of a member for which the arbitrary date is determined by the deadline determining means to be within the range of the deadline data. The cost data searching means for searching the cost data corresponding to the cost data, and the integrating means for accumulating the cost data searched by the cost data searching means to obtain an estimate. In place of the member determined by the deadline determination means that the arbitrary date is outside the range of the deadline data, the deadline data stored in the storage means corresponding to the member code indicating the substitute member is searched. A quotation integrating device characterized by: 2. The storage means stores data of a member having a corresponding substitute member and data of a member having no corresponding substitute member, and the arbitrary date corresponds to the deadline determining means. The quotation according to claim 1, further comprising message output means for outputting a message indicating that there is no usable member when it is determined that the member does not have a substitute member and is not included in the range of the deadline data of the member. Accumulator. 3. The operation code indicating whether or not each member can be used is stored in the storage means, and the storage corresponding to the member determined to be used in the product instead of the deadline data search means. Whether the member corresponding to the operation code can be used based on the operation code searching means for searching the operation code stored in the means and the operation code searched by the operation code searching means instead of the time limit judging means. There is an operation code judging means for judging whether or not it is possible, and the message output means has no usable member when the operation code is judged by the operation code judging means to be unusable. Indicating that the operation code is judged to be usable by the operation code judging means by the cost data searching means. Based on the member code estimated accumulation apparatus according to claim 2, wherein the search for cost data stored in the storage means. 4. The operation code includes an in-operation code indicating that a member is currently in operation, a parallel operation code indicating that a substitute member exists, and an operation code that has already been abolished and cannot be used. The operation code determining means determines whether the operation code is an in-operation code, a parallel operation code, or an abolition code, and the message output means determines that the operation code is the operation code. If it is judged as an abolished code by the judgment means,
A message indicating that the member is unusable is output, and when the operation code determination unit determines that the operation code is an operating code, the cost code search unit searches for the cost code of the corresponding member. However, the operation code search means, when the operation code is determined to be a parallel operation code by the operation code determination means, based on the member code of the substitute member of the corresponding member,
The quotation accumulating device according to claim 3, wherein the operation code is retrieved from the storage means. 5. The range indicated by the deadline data corresponding to the member code includes the current date based on the correspondence relationship between the member code of the member, the deadline data, and the member code of the substitute member stored in the storage means. In this case, if the operation code is set to the in-use code and the range of deadline data is before the current date, the operation code is set to the abolition code and the member code of the substitute member corresponding to the member code exists. The estimate accumulating device according to claim 3 or 4, further comprising operation code setting means for setting the operation code to the parallel operation code. 6. The operation code indicates that, in addition to the in-operation code, the parallel operation code, and the deprecated code, a new code indicating that a new operation is started and that there is a plan to be abolished. The decommissioned code is set, and the operation code determination means determines whether the operation code stored in the storage means is the operation code, the parallel operation code, the abolished code, the new code, or the deprecated code. If the operation code is determined to be a new code by the operation code determination means, the operation code determination means determines whether the operation code is a new code. The operation start date of the range of the corresponding deadline data is searched, and the operation code of the deadline data searching means is abolished by the operation code determining means. When it is determined that the operation code is the scheduled stop code, the operation end date in the range of the deadline data corresponding to the operation code is searched, and the operation code determination unit determines that the operation code is a new code. In this case, the deadline data searching means outputs a message indicating that the material can be used after the searched date, and the deadline data searching means determines that the operation code is the decommissioning code by the operation code judging means. The quotation accumulating device according to claim 4 or 5, wherein, in the case of the above, the deadline data searching means outputs a message indicating that the member cannot be used after the searched date. 7. The operation code setting means retrieves time limit data corresponding to each member, compares the operation start date of the time limit data with the current date, and when the operation start date is later If the operation code is set to a new code, the operation end date is registered in the deadline data, and the operation end date is compared with the current date, the operation end date is later 7. The estimate accumulating device according to claim 4, wherein the code is set to the abolition code. 8. The integrating means uses the expense data searched by the expense data searching means to perform an integrating process for creating a purchase order for a member corresponding to the expense data. The estimate integration device according to any one of 1 to 7.