Construction cost assessment device, construction cost assessment method, and construction cost assessment program
Patent Information
- Application Number
- JP2021209279
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-12-23
- Publication Date
- 2025-04-25
- Estimated Expiration
- 2041-12-23
AI Technical Summary
Existing systems struggle to accurately assess the appropriateness of construction estimate amounts due to the complexity and variability of items in quotations, requiring understanding of multiple content items in the estimate data.
A construction cost assessment device and method that utilizes a storage unit for reference prices, identifies specific columns and rows in an estimate, associates item contents with standard price information, and estimates values based on commission and rates to determine the appropriateness of estimate amounts.
Enables accurate assessment of construction estimate amounts by matching item contents with standard prices, allowing for appropriate determination of material, labor, and non-construction costs, thereby improving the accuracy of construction cost estimation.
Smart Images
Figure 00000014_0000 
Figure 00000016_0000 
Figure 00000017_0000
Abstract
Description
Technical Field
[0001] The present disclosure relates to a construction cost appraisal device, a construction cost appraisal method, and a construction cost appraisal program.
Background Art
[0002] Conventionally, estimates may be issued in various transactions. The system described in Patent Document 1 compares estimate data related to an estimate with judgment criterion data serving as a judgment criterion for the estimate when creating an estimate, and determines whether the data content of the estimate is appropriate. In this case, the system determines whether each item such as a product code, unit, and unit price is appropriate.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] There are various items in an estimate. For example, regarding the estimate of construction work, there are items such as the cost of materials and work. There are various formats for estimates, and in order to obtain the data of an estimate and determine whether the estimated amount is appropriate by computer processing, it was necessary to grasp the content for each of the multiple items of the estimate.
[0005] The present disclosure provides a construction cost appraisal device, a construction cost appraisal method, and a construction cost appraisal program capable of appraising the amount described in an estimate.
Means for Solving the Problems
[0006] One embodiment of a construction cost assessment device includes: a storage unit that stores standard price information relating to the standard price of the content of construction work; a recognition unit that recognizes rows and columns of estimate contents recorded in estimate information relating to the construction estimate; a first identification unit that identifies a first column in which an estimate is written among the columns recognized by the recognition unit; a second identification unit that identifies a second row in which the amount of a specific item is written among the rows recognized by the recognition unit; a mapping unit that associates the item contents written in the columns of the first column identified by the first identification unit, excluding the second row identified by the second identification unit, with the contents recorded in the standard price information stored in the storage unit; an estimation unit that estimates the assessed amount of the item contents based on the result of mapping the item contents with the contents by the mapping unit, the standard price of the standard price information stored in the storage unit, and the work rate and multiplier set in advance according to the content of construction work; and an output control unit that controls the output of each assessed amount estimated by the estimation unit. [Effects of the Invention]
[0007] According to one embodiment, the first column in which the estimate is recorded is identified from the rows and columns of the estimate information recorded in the estimate information for construction work, the second row in which the amount of a specific item is recorded is identified from the aforementioned rows, and the assessed value of the item can be estimated based on the result of associating the item contents recorded in the first column (excluding the second row) with the contents recorded in the standard price information, the standard price in the standard price information, and the work rate and multiplier set in advance according to the content of the construction work. [Brief explanation of the drawing]
[0008] [Figure 1] This is a diagram illustrating an information processing system according to one embodiment. [Figure 2] This is a diagram illustrating an example of a quotation. [Figure 3] This is a block diagram illustrating an information processing device according to one embodiment. [Figure 4] This is a flowchart illustrating an information processing method according to one embodiment. [Modes for carrying out the invention]
[0009] One embodiment will be described below.
[0010] [Overview of Information Processing System 1] Figure 1 is a diagram illustrating an information processing system 1 according to one embodiment. Figure 2 is a diagram illustrating an example of a quotation.
[0011] The information processing system 1 may be configured, for example, as a construction cost assessment system that assesses the estimated cost of construction work. The information processing device 100 that constitutes the information processing system 1 may be configured, for example, as a construction cost assessment device, similar to the system described above.
[0012] As shown in Figure 1 as an example, the information processing system 1 includes, for example, a vendor terminal 200 and an information processing device 100.
[0013] The contractor terminal 200 may be, for example, a terminal used by an employee of a contractor (construction company) performing construction work. The contractor terminal 200 may, for example, create a construction estimate based on the operations of the employee.
[0014] The information processing device 100 is used, for example, by a user who places an order for construction work. The information processing device 100 may be a computer such as a server, desktop, laptop, or tablet.
[0015] When the information processing device 100 receives a quotation (see Figure 2) sent from the vendor terminal 200, it assesses the contents of the quotation (e.g., the estimated amount). First, the information processing device 100 recognizes the rows and columns of the quotation contents recorded in the quotation information related to the construction estimate. Here, the quotation contains various items such as material costs, labor costs, and miscellaneous expenses, and the unit price, quantity, and amount are listed according to each item. Here, for example, we will explain an example in which material costs, labor costs, and miscellaneous expenses are listed in each row of the quotation, and the unit price, quantity, and amount are listed in each column of the quotation (see Figure 2). However, even if the opposite is true, such as when material costs, labor costs, and miscellaneous expenses are listed in each column of the quotation, and the unit price, quantity, and amount are listed in each row of the quotation, this can also be included as one embodiment of this disclosure.
[0016] The information processing device 100 identifies the first column 11 in which the estimate is written, from among the multiple columns written in the estimate. Here, an example of the first column 11 may be unit price, quantity, and amount. The information processing device 100 also identifies the second row 12 in which the amount of a specific item is written, from among the multiple rows written in the estimate. Here, an example of a specific item may be the "subtotal" item. The information processing device 100 associates the item contents written in the columns of the first column 11 identified above, excluding the second row 12 identified above, with the contents recorded in the standard price information. That is, as an example, the information processing device 100 excludes the subtotal row from the rows in which various items such as material costs, labor costs, and miscellaneous expenses are written, and associates the item contents such as material costs, labor costs, and miscellaneous expenses with the contents recorded in the standard price information. The standard price information may be, for example, information that records standard prices for multiple materials, various tasks, and various labor services. As a specific example, the information processing device 100 associates material A listed in the quotation with material A recorded in the standard price information. Similarly, the information processing device 100 may associate, for example, material B, labor costs, and miscellaneous expenses with items in the quotation and items recorded in the standard price information. The information processing device 100 estimates the appraised amounts of a plurality of item contents such as material A, material B, labor costs, and miscellaneous expenses based on, for example, the result of the above-mentioned association, the reference price of the reference price information, and the rates and percentages set in advance according to the content of the construction work.
[0017] [Details of Information Processing Device 100] Next, the details of the information processing device 100 according to an embodiment will be described. FIG. 3 is a block diagram for explaining the information processing device 100 according to an embodiment.
[0018] The information processing device 100 includes, for example, a communication unit 121, a storage unit 122, a display unit 123, and a control unit 111. The communication unit 121, the storage unit 122, and the display unit 123 may be an embodiment of an output unit. The control unit 111 includes, for example, a recognition unit 112, a first specifying unit 113, a second specifying unit 114, an associating unit 115, an estimating unit 116 (a first estimating unit 1161 and a second estimating unit 1162), and an output control unit 117. The control unit 111 may be configured by, for example, an arithmetic processing unit of the information processing device 100. The control unit 111 (for example, an arithmetic processing unit) realizes the functions of each unit (for example, the recognition unit 112, the first specifying unit 113, the second specifying unit 114, the associating unit 115, the estimating unit 116 (the first estimating unit 1161 and the second estimating unit 1162), and the output control unit 117) by appropriately reading and executing various programs stored in the storage unit 122 and the like.
[0019] The communication unit 121 can transmit and receive various information to and from, for example, a device (external device) outside the information processing device 100.
[0020] The storage unit 122 may store, for example, various information and programs. An example of the storage unit 122 may be a memory, a solid state drive, a hard disk drive, or the like. In addition, the storage unit 122 stores reference price information. The reference price information may be, for example, information on reference prices for various aspects related to construction work. The reference prices for various aspects may be, for example, reference prices such as material costs, labor costs, and miscellaneous expenses. As a specific example, the storage unit 122 may store reference price information regarding construction materials, the reference prices of those materials, miscellaneous materials used in the construction work, the reference miscellaneous material costs of those miscellaneous materials, the reference labor costs related to the labor when performing the construction work, and the reference non-construction costs related to non-construction aspects. The reference prices of the materials and the reference miscellaneous material costs may be, for example, the wholesale prices or selling prices of the materials and miscellaneous materials, etc. The reference prices of the materials and the reference miscellaneous material costs may be, for example, the prices obtained by averaging a plurality of selling prices of the materials and miscellaneous materials. The reference labor costs may be, for example, preset costs considered reasonable for labor, or may be costs obtained by averaging a plurality of costs related to labor. Note that the reference price information may be information recording at least one aspect selected from the group of the plurality of aspects described above, or may be information recording various other aspects (other reference prices, etc.) in addition to the aspects described above.
[0021] The display unit 123 can display, for example, various characters, symbols, images, etc.
[0022] First, the recognition unit 112 acquires a construction estimate in various data formats. Here, as an example, when the user receives a paper estimate, the recognition unit 112 may acquire various types of information generated by imaging the estimate using a multifunction device, a camera, etc. The various types of information may be, for example, various types of information including image information, spreadsheet information in a format used in spreadsheet software, text information in a format used in text creation software, and slide information in a format used in slide creation software for presentations, etc. When the recognition unit 112 acquires estimate information regarding an estimate recorded in various data formats as described above, the recognition unit 112 recognizes the estimated content described in the estimate information.
[0023] In other words, the recognition unit 112 may recognize, for example, the rows and columns of the estimate details recorded in the estimate information related to the construction estimate. The recognition unit 112 recognizes the rows and columns of the items described in the estimate. The recognition unit 112 may recognize, for example, the items (estimate details) described in the estimate, row by row and column by column. The recognition unit 112 may recognize, for example, the rows and columns in which the estimate details such as material costs, labor costs and miscellaneous expenses, unit prices, quantities, and amounts are described.
[0024] Here, the recognition unit 112 may, for example, when it acquires image information of a construction estimate (estimate image information relating to an image of a construction estimate), estimate the rows and columns of the estimate based on the trained model and the estimate image information. The trained model may be, for example, a model generated by learning whether each pixel is near a character, a horizontal line, or a vertical line. When the recognition unit 112 estimates the rows and columns based on the image information (estimate image information), it may output the estimated results as information in sheet format. The information in sheet format may be various types of information, including spreadsheet information in a format used by spreadsheet software, document information in a format used by word processing software, and slide information in a format used by presentation slide creation software.
[0025] In other words, the recognition unit 112 may, for example, ask a question to each pixel of the estimated image information based on an OCR semantic table that records whether each pixel is near a character, a horizontal line, or a vertical line, and have the trained model answer. The aforementioned "near a character" is defined in the OCR semantic table. As a more specific example, the recognition unit 112 may treat adjacent locations near a character and the location of the answer as a single character. Here, the recognition unit 112 may not consider locations where "right" and "left" are adjacent to each other horizontally, nor may it consider locations where "down" and "up" are adjacent to each other vertically. As a more specific example, the recognition unit 112 may perform Hough conversion on horizontal lines and areas with answers and treat them as horizontal lines. Similarly, the recognition unit 112 may perform Hough conversion on vertical lines and areas with answers and treat them as vertical lines. The recognition unit 112 may connect characters that are not separated by horizontal and vertical lines to form cells. The recognition unit 112 may, for example, consider characters to be separated even if they are not separated by horizontal lines, if the distance along the vertical axis is constant. Similarly, the recognition unit 112 may consider characters to be separated even if they are not separated by vertical lines, if the distance along the horizontal axis is constant. The recognition unit 112 may, for example, allocate columns based on vertical lines and allocate rows based on horizontal lines.
[0026] The first identification unit 113 identifies a first column 11 from among the columns recognized by the recognition unit 112, in which at least one of the estimated unit price, estimated quantity, and estimated amount is recorded. The first column 11 may also be called the "identified column." That is, the first identification unit 113 identifies a column (the first column 11) from among the multiple columns recognized by the recognition unit 112, in which at least one selected from the group of estimated unit price, estimated quantity, and estimated amount is recorded. As an example, the first identification unit 113 examines multiple possible patterns for the items that the numerical values in each column can take (for example, estimated unit price, estimated quantity, and estimated amount) in the multiple columns recognized by the recognition unit 112, and estimates the most likely ones as the columns for estimated unit price, estimated quantity, and estimated amount by comparing the numerical values in the columns. In this case, the first identification unit 113 may identify the first column 11 by, for example, processing all combinations of the most likely values for the estimated unit price, estimated quantity, and estimated amount, i.e., the columns for the estimated unit price, estimated quantity, and estimated amount, and voting for the most likely values. The first identification unit 113 may, for example, vote for the column candidates that satisfy the amount condition for the unit price and quantity. Similarly, the first identification unit 113 may, for example, vote for the column candidates that satisfy the amount condition for the unit price. The first identification unit 113 may, for example, aggregate the results for each column and treat the consecutive intervals with the most votes as at least one column selected from the group of estimated unit price, estimated quantity, and estimated amount. In other words, the first identification unit 113 may obtain multiple combination patterns of unit price, quantity, and amount based on the numerical values entered in all columns, and then identify the column in which at least the amount is entered among the unit price, quantity, and amount based on the pattern with the highest probability among the multiple combination patterns.
[0027] The second identification unit 114 may, for example, process multiple rows recognized by the recognition unit 112 and convert each row into sheet-formatted information. In this case, the second identification unit 114 identifies a second row 12 from among the rows recognized by the recognition unit 112 in which the amount of a specific item is recorded. That is, the second identification unit 114 identifies a second row 12 in order to exclude rows such as "Subtotal".
[0028] The second specific unit 114 calculates the cumulative value of amounts for each set of parts when all multiple rows are considered as a whole, and determines and adopts the one that seems most likely to be the total estimated amount. Here, a candidate for the total estimated amount is assumed to exist separately in another part of the form. The second identification unit 114 may calculate the cumulative value of the amounts listed in the column identified by the first identification unit 113, obtain multiple combination patterns of cumulative amounts, and identify the rows containing the estimate details (item details) from among the multiple patterns, excluding the second row 12 in which the "subtotal" item is listed. In this case, the second identification unit 114 may, for example, flag each row belonging to the most likely subset from among the candidates for each item of the estimate (materials, miscellaneous expenses, labor, and non-construction details). "Most likely" may be primarily based on the number of rows that make up the subset. Alternatively, the second identification unit 114 may identify a second row 12 in which the amount of the specified item is recorded in the column with the highest probability among the multiple pattern columns identified by the first identification unit 113. In this case, the second identification unit 114 may, for example, flag each row belonging to the most likely subset from among the candidates for the second row 12. "Most likely" may be primarily based on the criterion of having as few rows as possible. That is, for example, if the column in which the amount is recorded is identified as the column with the highest probability pattern, the second identification unit 114 may identify a second row 12 in which the amount of the specified item is recorded in that identified column.
[0029] The mapping unit 115 associates the item content identified by the second identification unit 114 from the first column 11 identified by the first identification unit 113 with one of the materials, miscellaneous materials, labor, and non-construction items in the standard price information stored in the storage unit 122. Alternatively, the mapping unit 115 associates the item content described in the columns of the first column 11 identified by the first identification unit 113, excluding the second row 12 identified by the second identification unit 114, with one of the materials, miscellaneous materials, labor, and non-construction items in the standard price information stored in the storage unit 122. In other words, the mapping unit 115 associates the item content described in the rows of multiple rows recognized by the recognition unit 112, excluding the row identified by the second identification unit 114, with one of the materials, miscellaneous materials, labor, and non-construction items in the standard price information stored in the storage unit 122. As a specific example, the mapping unit 115 maps the item content (material) described in a row to the content (material) in the standard price information if the model number of a material described in any of the rows matches (or nearly matches) the model number of a material in the standard price information. In this case, the mapping unit 115 may calculate a score according to the degree of match between the item content described in the row and the content recorded in the standard price information (for example, the length of the model number and the degree of variation in wording), and extract candidates for mapping. If, for example, there is at least one candidate extracted as described above, the mapping unit 115 may confirm the candidate with the highest score.
[0030] The mapping unit 115 may associate the matching item content with one of the materials, miscellaneous materials, labor, and non-construction items in the standard price information if at least a part of the item content matches one of the materials, miscellaneous materials, labor, and non-construction items. Here, the mapping unit 115 may have, for example, a model number dictionary in which model numbers of materials, etc. are registered. The mapping unit 115 may also have, for example, a spare model number dictionary in which strings obtained by removing at least one character from the model number of materials, etc. are registered. Furthermore, the model number dictionary and the spare model number dictionary may be included in the standard price information, for example. The mapping unit 115 may, for example, refer to the model number dictionary and the spare model number dictionary and associate the string described in the item content with one of the materials, miscellaneous materials, labor, and non-construction items. The mapping unit 115 may, by referring to the model number dictionary and the spare model number dictionary, associate the string obtained by removing at least one character from the string of the item content described in the quotation with the materials, miscellaneous materials, labor, and non-construction items in the standard price information.
[0031] The mapping unit 115 may associate the matching item content with multiple words if at least a portion of the item content matches multiple words that are combinations of any of the words from the reference price information, such as materials, miscellaneous materials, labor, and non-construction items. Here, the mapping unit 115 may have a keyword group that registers, for example, variable strings (variation keywords) that are expected in the item content and strings such as model numbers. The keyword group may, for example, be included in the reference price information. The mapping unit 115 may, for example, refer to the keyword group and check for the presence or absence of keywords in the item content (string) of multiple rows, and associate it with any of the materials, miscellaneous materials, labor, and non-construction items for which the logical operation result of AND and OR is true.
[0032] The first estimation unit 1161 estimates the assessed value of an item and the associated labor costs based on the results of associating item contents with materials and miscellaneous materials by the matching unit 115, the standard price of materials and standard miscellaneous material costs of miscellaneous materials stored in the standard price information in the storage unit 122, and the work rate and markup rate (pre-set values) that are set in advance according to the materials and miscellaneous materials. As a specific example, if material Z is identified by the item contents described in the estimate, the first estimation unit 1161 estimates the assessed value of material Z and the associated labor costs based on the standard price of material Z recorded in the standard price information, and the work rate and markup rate for material Z. That is, for example, the first estimation unit 1161 estimates the assessed value of material Z by multiplying the standard price of material Z by the markup rate. The first estimation unit 1161 estimates the assessed value of each material and each miscellaneous material, for example, in the same manner as described above. The unit cost and markup rate may be set at values that are estimated to be reasonable as an amount that a contractor should add to the price. The estimated reasonable value may be a value that is set appropriately considering various factors such as the purchase, storage and transportation of materials, as well as the labor, time and management of the construction work (for example, the amount obtained as profit).
[0033] The second estimation unit 1162 estimates the assessed value of the item content based on the results of associating the item content with labor and non-construction content by the matching unit 115, the standard labor content and standard non-construction costs of the standard price information stored in the storage unit 122, and the work rate and markup rate (pre-set values) that are set in advance according to the labor and non-construction content. The work rate and markup rate may be set to values that are estimated to be reasonable as an amount that a contractor adds to the price, for example. The values estimated to be reasonable may be values that are set appropriately considering various factors such as the purchase, storage and transportation of materials, as well as the labor, time and management of the construction (for example, the amount obtained as profit). The second estimation unit 1162 may, for example, estimate the assessed value of each labor and non-construction content by multiplying the standard price of each labor and non-construction content by the cumulative amount of work rates linked to the materials in the same estimate, similar to the first estimation unit 1161 described above.
[0034] The first estimation unit 1161 and the second estimation unit 1162 described above may, for example, be combined to form a single functional block called "estimation unit 116".
[0035] The output control unit 117 controls the output unit to output each of the estimated assessment amounts calculated by the first estimation unit 1161 and the second estimation unit 1162. The output unit may be, for example, a communication unit 121, a storage unit 122, and a display unit 123. In other words, the output control unit 117 may control the communication unit 121 to transmit information regarding each assessed value estimated by the first estimation unit 1161 and the second estimation unit 1162 to an external device. The external device may be, for example, a terminal used by the user (for example, a desktop, laptop, tablet, and smartphone, etc.) (not shown), or a server (not shown). Furthermore, the output control unit 117 may control the storage unit 122 to store information regarding each assessed value estimated by the first estimation unit 1161 and the second estimation unit 1162, for example. Furthermore, the output control unit 117 may control the display unit 123 to display information regarding each assessed value estimated by the first estimation unit 1161 and the second estimation unit 1162, for example.
[0036] [Information Processing Methods] Figure 4 is a flowchart illustrating an information processing method according to one embodiment.
[0037] In step ST101, when the recognition unit 112 acquires estimate information for a construction estimate, it recognizes the rows and columns of the estimate content recorded in that estimate information. For example, if the recognition unit 112 acquires image information of a construction estimate (estimate image information related to an image of a construction estimate), it may estimate the rows and columns of the estimate content based on the trained model and the estimate image information. The trained model may be, for example, a model generated by learning whether each pixel is near a character, what character it is, whether it is a horizontal line or a vertical line.
[0038] In step ST102, the first identification unit 113 identifies a first column 11 from among the columns recognized in step ST101, in which at least one of the estimated unit price, estimated quantity, and estimated amount is recorded. In this case, the first identification unit 113 may, for example, obtain multiple combination patterns of unit price, quantity, and amount based on the numerical values recorded in all columns, and then identify a column in which at least the amount is recorded based on the pattern with the highest probability among the multiple combination patterns.
[0039] In step ST103, the second identification unit 114 identifies a second row 12 from among the rows recognized in step ST101 in which the amount of the specified item is recorded. The second identification unit 114 may also identify a second row 12 from among the columns of multiple patterns identified in step ST101 in which the amount of the specified item is recorded, based on the column of the pattern with the highest probability.
[0040] In step ST104, the mapping unit 115 associates the item contents described in the columns of the first column 11 identified in step ST102, excluding the second row 12 identified in step ST103, with one of the materials, miscellaneous materials, labor, and non-construction items in the reference price information stored in the storage unit 122. In this case, the mapping unit 115 may, for example, associate the matching item contents with one of the materials, miscellaneous materials, labor, and non-construction items in the reference price information if at least a part of the item contents matches one of the materials, miscellaneous materials, labor, and non-construction items in the reference price information. Alternatively, the mapping unit 115 may, for example, associate the matching item contents with multiple words that are combinations of any of the materials, miscellaneous materials, labor, and non-construction items in the reference price information if at least a part of the item contents matches multiple words.
[0041] In step ST105, the first estimation unit 1161 estimates the assessed value of the item content based on the results of associating the item content with materials and miscellaneous materials in step ST104, the standard price of materials and standard miscellaneous material costs of miscellaneous materials stored in the memory unit 122, and the work rate and markup rate set in advance according to the materials and miscellaneous materials. Furthermore, the second estimation unit 1162 estimates the assessed value of the item content based on the results of associating the item content with labor and non-construction content in step ST104, the standard labor content and standard non-construction costs of the standard price information stored in the storage unit 122, and the unit cost and multiplier set in advance according to the labor and non-construction content.
[0042] In step ST106, the output control unit 117 controls the output unit to output each of the estimated assessment amounts in step ST105. Here, the output unit may be, for example, a communication unit 121, a storage unit 122, and a display unit 123.
[0043] Each part of the information processing device 100 described above may be implemented as a function of a computer's arithmetic processing unit or the like. That is, the recognition unit 112, first identification unit 113, second identification unit 114, correspondence unit 115, estimation unit 116 (first estimation unit 1161 and second estimation unit 1162), and output control unit 117 (control unit 111) of the information processing device 100 may be implemented as a recognition function, first identification function, second identification function, correspondence function, estimation function (first estimation function and second estimation function), and output control function (control function), respectively, by a computer's arithmetic processing unit or the like. Information processing programs can enable computers to implement the functions described above. These information processing programs may be recorded on non-temporary recording media that are readable by a computer, such as memory, solid-state drives, hard disk drives, or optical discs. Furthermore, as described above, each part of the information processing device 100 may be implemented as a computer's arithmetic processing unit or the like. This arithmetic processing unit or the like is composed of, for example, an integrated circuit. For this reason, each part of the information processing device 100 may be implemented as a circuit that constitutes the arithmetic processing unit or the like. That is, the recognition unit 112, the first identification unit 113, the second identification unit 114, the correspondence unit 115, the estimation unit 116 (first estimation unit 1161 and second estimation unit 1162), and the output control unit 117 (control unit 111) of the information processing device 100 may be implemented as a recognition circuit, a first identification circuit, a second identification circuit, a correspondence circuit, an estimation circuit (first estimation circuit and second estimation circuit), and an output control circuit (control circuit) that constitute the computer's arithmetic processing unit or the like. Furthermore, the communication unit 121, storage unit 122, and display unit 123 (output unit) of the information processing device 100 may be implemented as a communication function, storage function, and display function (output function) that includes the functions of an arithmetic processing unit, for example. Also, the communication unit 121, storage unit 122, and display unit 123 (output unit) of the information processing device 100 may be implemented as a communication circuit, storage circuit, and display circuit (output circuit) by being composed of an integrated circuit, for example. Furthermore, the communication unit 121, storage unit 122, and display unit 123 (output unit) of the information processing device 100 may be configured as a communication device, storage device, and display device (output device) by being composed of a plurality of devices, for example.
[0044] The information processing device 100 can be configured to combine one or any multiple of the above-described parts. In this disclosure, the term "information" is used, but the term "information" can be replaced with "data," and the term "data" can be replaced with "information."
[0045] [Aspects and Effects of This Embodiment] Next, one aspect of this embodiment and the effects achieved by each aspect will be described. Note that this embodiment is not limited to the aspects described below, and may be realized by appropriately combining the parts described above. Furthermore, the effects described below are examples, and the effects achieved by each aspect are not limited to those described below.
[0046] (Aspect 1) One embodiment of an information processing device (for example, a construction cost assessment device) includes a storage unit that stores standard price information relating to construction materials, standard prices of those materials, miscellaneous materials used in construction, standard miscellaneous material costs, standard labor costs relating to labor performed during construction, and standard non-construction costs relating to non-construction work; a recognition unit that recognizes rows and columns of estimate details recorded in estimate information relating to construction estimates; a first identification unit that identifies a first column among the columns recognized by the recognition unit in which at least one of the estimated unit price, estimated quantity, and estimated amount is recorded; a second identification unit that identifies a second row among the rows recognized by the recognition unit in which the amount of a specific item is recorded; and a function that records the item details in the columns of the first column identified by the first identification unit, excluding the second row identified by the second identification unit. The system includes: an association unit that associates the standard price information stored in the memory unit with materials, miscellaneous materials, labor, and non-construction work; a first estimation unit that estimates the assessed value of the item content based on the result of the association of the item content with materials and miscellaneous materials by the association unit, the standard price of materials and standard miscellaneous material costs of miscellaneous materials stored in the memory unit, and the work rate and multiplier set in advance according to the materials and miscellaneous materials; a second estimation unit that estimates the assessed value of the item content based on the result of the association of the item content with labor and non-construction work by the association unit, the standard labor content and standard non-construction costs of the standard price information stored in the memory unit, and the work rate and multiplier set in advance according to the labor and non-construction work; and an output control unit that controls the system to output each assessed value estimated by the first estimation unit and the second estimation unit. This allows the construction cost assessment device to assess the estimate for each of the multiple items listed in the estimate. In other words, the construction cost assessment device can assess the amounts listed in the estimate. The construction cost assessment device can provide the user with information on whether the amounts for each item listed in the estimate are reasonable or not.
[0047] (Aspect 2) In one embodiment of an information processing device (for example, a construction cost assessment device), when the recognition unit acquires estimate image information relating to an image of a construction estimate, it may estimate the rows and columns of the estimate based on a trained model that has learned whether each pixel is near a character, a horizontal line, or a vertical line, and the estimate image information. This allows the construction cost assessment device to properly recognize the estimate.
[0048] (Aspect 3) In one embodiment of an information processing device (for example, a construction cost assessment device), the first identification unit may acquire multiple combination patterns of unit price, quantity, and amount based on the numerical values entered in all columns, and then identify the column in which at least the amount is entered among the unit price, quantity, and amount based on the pattern with the highest probability among the multiple combination patterns. This allows the construction cost assessment device to identify the columns in the estimate that contain unit price, quantity, and total amount.
[0049] (Aspect 4) In one embodiment of an information processing device (for example, a construction cost assessment device), the second identification unit may identify a second row in the column identified by the first identification unit, in which the amount of the specified item is recorded. This allows the construction cost assessment device to identify items that are unlikely to be necessary for assessing an estimate, such as "subtotal," and then perform the estimate assessment while excluding those identified items.
[0050] (Appendix 5) In one embodiment of an information processing device (for example, a construction cost assessment device), the matching unit may, if at least a part of the item content matches any of the standard price information items for materials, miscellaneous materials, labor, and non-construction work, match the matching item content with any of the materials, miscellaneous materials, labor, and non-construction work. As a result, the construction cost assessment device can associate the items listed in the estimate (e.g., strings) with the items recorded in the standard price information, even if the items listed in the estimate do not perfectly match the items recorded in the standard price information.
[0051] (Aspect 6) In one embodiment of an information processing device (for example, a construction cost assessment device), the matching unit may associate the matching item content with the multiple words if at least a part of the item content matches a multiple word that is a combination of any multiple words from the standard price information, such as materials, miscellaneous materials, labor, and non-construction content. As a result, the construction cost assessment device can associate the items listed in the estimate (e.g., strings) with the items recorded in the standard price information, even if the items listed in the estimate do not perfectly match the items recorded in the standard price information.
[0052] (Aspect 7) One embodiment of an information processing device (for example, a construction cost assessment device) includes: a storage unit that stores standard price information relating to the standard price of the content of construction work; a recognition unit that recognizes rows and columns of estimate information recorded in estimate information relating to the estimate of construction work; a first identification unit that identifies a first column in which an estimate is written among the columns recognized by the recognition unit; a second identification unit that identifies a second row in which the amount of a specific item is written among the rows recognized by the recognition unit; a mapping unit that associates the item contents written in the columns of the first column identified by the first identification unit, excluding the second row identified by the second identification unit, with the contents recorded in the standard price information stored in the storage unit; an estimation unit that estimates the assessed amount of the item contents based on the result of mapping the item contents with the contents by the mapping unit, the standard price of the standard price information stored in the storage unit, and the work rate and multiplier set in advance according to the content of construction work; and an output control unit that controls the output of each assessed amount estimated by the estimation unit. As a result, the construction cost assessment device can achieve the same effect as the construction cost assessment device of the above-described embodiment.
[0053] (Pattern 8) One embodiment of an information processing device (for example, a construction cost assessment device) includes a storage unit that stores standard price information relating to construction materials, standard prices of those materials, miscellaneous materials used in construction, standard miscellaneous material costs, standard labor costs relating to labor performed during construction, and standard non-construction costs relating to non-construction work; a recognition unit that recognizes rows and columns of estimate details recorded in estimate information relating to construction estimates; a first identification unit that identifies a first column among the columns recognized by the recognition unit in which at least one of the estimated unit price, estimated quantity, and estimated amount is recorded; a second identification unit that identifies a row among the rows recognized by the recognition unit in which the amount of the item details that constitute the estimate is recorded; and a storage unit that stores the item details recorded in the row identified by the second identification unit among the first columns identified by the first identification unit. The system includes: an association unit that associates the item content with one of the following: materials, miscellaneous materials, labor, and non-construction work content stored in the standard price information; a first estimation unit that estimates the assessed amount of the item content based on the result of the association unit associating the item content with materials and miscellaneous materials, the standard price of materials and standard miscellaneous material costs of miscellaneous materials stored in the standard price information, and the work rate and markup rate set in advance according to the materials and miscellaneous materials; a second estimation unit that estimates the assessed amount of the item content based on the result of the association unit associating the item content with labor and non-construction work content, the standard labor content and standard non-construction cost of the standard price information stored in the standard price information, and the work rate and markup rate set in advance according to the labor and non-construction work content; and an output control unit that controls the system to output each assessed amount estimated by the first estimation unit and the second estimation unit. As a result, the construction cost assessment device can achieve the same effect as the construction cost assessment device of the above-described embodiment.
[0054] (Aspect 9) In one embodiment of an information processing method (for example, a construction cost assessment method), a computer equipped with a storage unit that stores standard price information relating to the standard price of the construction work performs the following steps: a recognition step of recognizing rows and columns of estimate information recorded in estimate information relating to the construction estimate; a first identification step of identifying a first column in which the estimate is written from among the columns recognized by the recognition step; a second identification step of identifying a second row in which the amount of a specific item is written from among the rows recognized by the recognition step; a mapping step of associating the item contents written in the columns of the first column identified by the first identification step, excluding the second row identified by the second identification step, with the contents recorded in the standard price information stored in the storage unit; an estimation step of estimating the assessed amount of the item contents based on the result of associating the item contents with the contents in the mapping step, the standard price of the standard price information stored in the storage unit, and the work rate and multiplier set in advance according to the construction work; and an output control step of controlling to output each assessed amount estimated by the estimation step. As a result, the construction cost assessment method can achieve the same effect as the construction cost assessment device of the above-described embodiment.
[0055] (Aspect 10) One embodiment of an information processing program (for example, a construction cost assessment program) implements the following functions in a computer: a storage function for storing standard price information relating to the standard price of the construction work; a recognition function for recognizing rows and columns of estimate information recorded in estimate information relating to the construction estimate; a first identification function for identifying a first column in which an estimate is written among the columns recognized by the recognition function; a second identification function for identifying a second row in which the amount of a specific item is written among the rows recognized by the recognition function; a mapping function for associating the item contents written in the columns of the first column identified by the first identification function, excluding the second row identified by the second identification function, with the contents recorded in the standard price information stored in the storage function; an estimation function for estimating the assessed amount of an item based on the result of mapping the item contents by the mapping function, the standard price of the standard price information stored in the storage function, and the work rate and multiplier set in advance according to the construction work; and an output control function for controlling the output of each assessed amount estimated by the estimation function. As a result, the construction cost assessment program can achieve the same effect as the construction cost assessment device of the aforementioned embodiment. [Explanation of symbols]
[0056] 1. Information Processing System 100 Information Processing Equipment (Construction Cost Assessment Equipment) 111 Control Unit 112 Recognition part 113 1st Specific Part 114 Second Specific Part 115 Correspondence section 116 Estimation Department 1161 1st Estimation Department 1162 Second Estimation Department 117 Output Control Unit 121 Communications Department 122 Storage section 123 Display section
Claims
1. A storage unit that stores standard price information related to construction materials, standard prices of the materials, miscellaneous materials used in the construction, standard miscellaneous material costs of the miscellaneous materials, standard labor costs related to labor when performing the construction, and standard non-construction costs related to non-construction content; a recognition unit that recognizes rows and columns of estimate contents recorded in estimate information relating to construction estimates; a first identification unit that identifies a first column in which at least one of a unit price of an estimate, a quantity of an estimate, and a price of an estimate is written, from among the columns recognized by the recognition unit; a second identification unit that identifies a second line in which an amount of a specific item is written among the lines recognized by the recognition unit; a correspondence unit that corresponds the item contents described in the columns, excluding the second row specified by the second specification unit, of the first column specified by the first specification unit to any of materials, miscellaneous materials, labor, and non-construction contents of the reference price information stored in the storage unit; a first estimation unit that estimates an assessed value of the item content based on the result of associating the item content with the materials and miscellaneous materials by the association unit, the standard price of the material and the standard miscellaneous material cost of the miscellaneous materials in the standard price information stored in the storage unit, and the work rate and rate that are preset according to the material and miscellaneous material; a second estimation unit that estimates the assessed value of the item content based on the result of associating the item content with the labor and non-construction content by the association unit, the standard labor content and standard non-construction cost of the standard price information stored in the storage unit, and the unit rate and rate that are preset according to the labor and non-construction content; an output control unit that controls the first estimation unit and the second estimation unit to output the appraisal amounts estimated by the first estimation unit and the second estimation unit; A construction cost assessment device comprising:
2. When the recognition unit acquires estimate image information relating to an image of a construction estimate, the recognition unit estimates the rows and columns of the estimate content based on a trained model that has learned whether each pixel is near a character, a horizontal ruled line, or a vertical ruled line, and the estimate image information. The construction cost assessment device according to claim 1.
3. The first identification unit acquires a plurality of combination patterns that the numerical values can take as combination patterns of unit price, quantity, and amount based on the numerical values written in all columns, and identifies a column in which at least the amount of the unit price, quantity, and amount is written based on the most likely pattern among the plurality of combination patterns.
3. The construction cost assessment device according to claim 1 or 2.
4. The second specifying unit specifies a second row in which the amount of a specific item is written in the column specified by the first specifying unit. The construction cost assessment device according to claim 3.
5. When at least a part of the item content matches any of the materials, miscellaneous materials, labor, and non-construction content of the reference price information, the association unit associates the matching item content with any of the materials, miscellaneous materials, labor, and non-construction content. The construction cost assessment device according to any one of claims 1 to 4.
6. When at least a part of the item content matches a plurality of words that are a combination of any of a plurality of words of materials, miscellaneous materials, labor, and non-construction content of the reference price information, the associating unit associates the matching item content with the plurality of words. The construction cost assessment device according to any one of claims 1 to 5.
7. a storage unit that stores reference price information regarding the reference price of the content of the construction work; a recognition unit that recognizes rows and columns of estimate contents recorded in estimate information relating to construction estimates; a first identification unit that identifies a first column in which an estimate is written, from among the columns recognized by the recognition unit; a second identification unit that identifies a second line in which an amount of a specific item is written among the lines recognized by the recognition unit; a correspondence unit that associates the item contents described in the columns, excluding the second row specified by the second specification unit, of the first column specified by the first specification unit with the contents recorded in the base price information stored in the storage unit; an estimation unit that estimates the assessed value of the item content based on the result of the association between the item content and the content by the association unit, the reference price of the reference price information stored in the storage unit, and the work rate and rate that are preset according to the content of the construction work; an output control unit that controls the output of each appraisal value estimated by the estimation unit; A construction cost assessment device comprising:
8. A storage unit that stores standard price information related to construction materials, standard prices of the materials, miscellaneous materials used in the construction, standard miscellaneous material costs of the miscellaneous materials, standard labor costs related to labor when performing the construction, and standard non-construction costs related to non-construction content; a recognition unit that recognizes rows and columns of estimate contents recorded in estimate information relating to construction estimates; a first identification unit that identifies a first column in which at least one of a unit price of an estimate, a quantity of an estimate, and a price of an estimate is written, from among the columns recognized by the recognition unit; a second identification unit that identifies a line in which an amount of an item content that is a quotation content is written among the lines recognized by the recognition unit; a correspondence unit that corresponds the item content described in the row identified by the second identification unit among the first column identified by the first identification unit to any of materials, miscellaneous materials, labor, and non-construction content of the reference price information stored in the storage unit; a first estimation unit that estimates an assessed value of the item content based on the result of associating the item content with the materials and miscellaneous materials by the association unit, the standard price of the material and the standard miscellaneous material cost of the miscellaneous materials in the standard price information stored in the storage unit, and the work rate and rate that are preset according to the material and miscellaneous material; a second estimation unit that estimates the assessed value of the item content based on the result of associating the item content with the labor and non-construction content by the association unit, the standard labor content and standard non-construction cost of the standard price information stored in the storage unit, and the unit rate and rate that are preset according to the labor and non-construction content; an output control unit that controls the first estimation unit and the second estimation unit to output the appraisal amounts estimated by the first estimation unit and the second estimation unit; A construction cost assessment device comprising:
9. A computer having a storage unit that stores reference price information regarding the reference price of the content of the construction work, a recognition step of recognizing rows and columns of estimate contents recorded in estimate information relating to the estimate of the construction work; a first identifying step of identifying a first column in which an estimate is written, from among the columns recognized by the recognizing step; a second identifying step of identifying a second line in which the amount of a specific item is written among the lines recognized by the recognizing step; a correlating step of correlating the item contents written in the first column identified by the first identifying step, excluding the second row identified by the second identifying step, with the contents recorded in the base price information stored in the storage unit; an estimation step of estimating an assessed value of the item content based on the result of associating the item content with the content in the association step, the reference price of the reference price information stored in the storage unit, and the work rate and rate that are preset according to the content of the construction work; an output control step of controlling to output each appraisal value estimated by the estimation step; A construction cost assessment method that implements the above.
10. On the computer, A storage function for storing reference price information regarding the reference price of the content of the construction work; A recognition function that recognizes rows and columns of estimate contents recorded in estimate information regarding construction estimates; a first identifying function that identifies a first column in which an estimate is written among columns recognized by the recognition function; a second identification function that identifies a second line in which the amount of a specific item is written among the lines recognized by the recognition function; a correspondence function that associates the item contents written in the first column specified by the first specification function, excluding the second row specified by the second specification function, with the contents recorded in the base price information stored in the storage function; an estimation function for estimating the assessed value of the item contents based on the result of associating the item contents with the contents by the association function, the reference price of the reference price information stored in the storage function, and the work rate and rate that are preset according to the contents of the construction work; an output control function that controls to output each appraisal value estimated by the estimation function; A construction cost assessment program that makes this possible.