Construction cost assessment device, construction cost assessment method, and construction cost assessment program

Abstract

To provide a construction cost assessment device, a construction cost assessment method, and a construction cost assessment program that can carry out an assessment on the amount of money written on an estimate.SOLUTION: A construction cost assessment device comprises: a recognition unit that recognizes rows and columns in the details of estimation recorded in estimation information related to estimation of construction; a first identification unit that identifies, of the columns recognized by the recognition unit, a first column on which the estimation is written; a second identification unit that identifies, of the rows recognized by the recognition unit, a second row on which the amount of money for a specific item is written; an association unit that associates the details of an item written on a column excluding the second row identified by the second identification unit, in the first column identified by the first identification unit, with the details recorded in standard price information; and an estimation unit that estimates the assessed amount of the details of the item on the basis of the result of the association of the details of the item and the details performed by the association unit, the standard price in the standard price information, and the production rate and the markup set in advance according to the details of the construction.SELECTED DRAWING: Figure 1

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. When creating an estimate, the system described in Patent Document 1 compares estimate data related to the estimate with judgment criterion data serving as a judgment criterion for the 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] An estimate has various items. For example, regarding an 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 the estimate and determine whether the estimated amount is appropriate by computer processing, it is necessary to grasp the content of 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] The construction cost appraisal device according to one aspect includes a storage unit that stores reference price information regarding the reference price of the content of the construction work, a recognition unit that recognizes the rows and columns of the estimated content recorded in the estimate information regarding the estimate of the construction work, and among the columns recognized by the recognition unit, a first identification unit that identifies the first column in which the estimate is described, and among the rows recognized by the recognition unit, a second identification unit that identifies the second row in which the amount of the specific item is described, a correspondence unit that associates the item content described in the columns excluding the second row from among the first columns identified by the first identification unit with the content recorded in the reference price information stored in the storage unit, an estimation unit that estimates the appraisal amount of the item content based on the result of associating the item content with the content by the correspondence unit, the reference price of the reference price information stored in the storage unit, and the rate and multiplier set in advance according to the content of the construction work, and an output control unit that controls to output each appraisal amount estimated by the estimation unit.

Effect of the Invention

[0007] According to one aspect, among the columns in the rows and columns of the estimated content recorded in the estimate information regarding the estimate of the construction work, the first column in which the estimate is described is identified, among the above-described rows, the second row in which the amount of the specific item is described is identified, and based on the result of associating the item content described in the columns excluding the second row from among the first columns with the content recorded in the reference price information, the reference price of the reference price information, and the rate and multiplier set in advance according to the content of the construction work, the appraisal amount of the item content can be estimated.

Brief Description of the Drawings

[0008]

Figure 1

Figure 2

Figure 3

Figure 4

Best Mode for Carrying Out the Invention

[0009] Hereinafter, an embodiment will be described.

[0010] [Overview of Information Processing System 1] FIG. 1 is a diagram for explaining an information processing system 1 according to an embodiment. FIG. 2 is a diagram for explaining an example of an estimate.

[0011] The information processing system 1 may be configured, for example, as a construction cost appraisal system that appraises the estimate of construction work. The information processing apparatus 100 constituting the information processing system 1 may be configured as a construction cost appraisal apparatus, for example, in the same manner as the above-described system.

[0012] As shown in an example in FIG. 1, the information processing system 1 includes, for example, a contractor terminal 200 and an information processing apparatus 100.

[0013] The contractor terminal 200 may be a terminal used by an employee of a contractor (construction company) that performs construction work, for example. The contractor terminal 200 creates an estimate of construction work, for example, based on the operations of employees.

[0014] The information processing apparatus 100 is used by a user who orders construction work, for example. The information processing apparatus 100 may be a computer such as a server, desktop, laptop, and tablet, for example.

[0015] When the information processing apparatus 100 receives a quotation (see FIG. 2) sent from the contractor terminal 200, it appraises the content described in the quotation (for example, the quoted amount, etc.). First, the information processing apparatus 100 recognizes the rows and columns of the quotation content recorded in the quotation information regarding the construction estimate. Here, various items such as material costs, labor costs, and miscellaneous expenses are described in the quotation, and unit prices, quantities, amounts, etc. are described according to each item. Here, for example, an example will be described in which each of material costs, labor costs, and miscellaneous expenses is described in each row of the quotation, and each of unit price, quantity, amount, etc. is described in each column of the quotation (see FIG. 2). Note that, conversely to this example, even if each of material costs, labor costs, and miscellaneous expenses is described in each column of the quotation, and each of unit price, quantity, amount, etc. is described in each row of the quotation, it can be included in an embodiment of the present disclosure.

[0016] The information processing apparatus 100 identifies the first column 11 in which the estimate is described among the plurality of columns described in the quotation. Here, an example of the first column 11 may be unit price, quantity, amount, etc. Further, the information processing apparatus 100 identifies the second row 12 in which the amount of a specific item is described among the plurality of rows described in the quotation. Here, an example of the specific item may be an item of "subtotal". The information processing apparatus 100 associates the item content described in the columns excluding the second row 12 identified above in the first column 11 identified above with the content recorded in the reference price information. That is, as an example, the information processing apparatus 100 excludes the subtotal row from the rows in which various items such as material costs, labor costs, and miscellaneous expenses are described, and associates the item content of material costs, labor costs, and miscellaneous expenses with the content recorded in the reference price information. The reference price information may be, for example, information recording reference prices for a plurality of materials, various operations, various labor services, etc. As a specific example, the information processing apparatus 100 associates the material A described in the quotation with the material A recorded in the reference price information. Similarly, the information processing apparatus 100 may associate, for example, each of material B, labor cost, and miscellaneous expense with the item recorded in the reference price information for the item in the quotation. The information processing apparatus 100 estimates the estimated amounts of multiple item contents such as material A, material B, labor costs, and miscellaneous expenses based on, for example, the result of the association described above, the reference price of the reference price information, and the rate and percentage set in advance according to the content of the construction work.

[0017] [Details of Information Processing Apparatus 100] Next, the details of the information processing apparatus 100 according to an embodiment will be described. FIG. 3 is a block diagram for explaining the information processing apparatus 100 according to an embodiment.

[0018] The information processing apparatus 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 the output unit. The control unit 111 includes, for example, a recognition unit 112, a first specifying unit 113, a second specifying unit 114, an association unit 115, an estimation unit 116 (a first estimation unit 1161 and a second estimation 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 apparatus 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 association unit 115, the estimation unit 116 (the first estimation unit 1161 and the second estimation 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 apparatus 100.

[0020] The storage unit 122 may store 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, the reference miscellaneous material costs of those miscellaneous materials, reference labor costs related to the labor when performing the construction, and reference non-construction costs related to non-construction work. The reference prices of 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 materials and the reference miscellaneous material costs may be, for example, prices obtained by averaging multiple 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 multiple costs related to labor. Note that the reference price information may be information recording at least one content selected from a group of the above-described multiple contents, or may be information recording various other contents (other reference prices, etc.) in addition to the above-described contents.

[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 forms of information generated by imaging the estimate using a multifunction device, a camera, etc. The various forms of information may be, for example, various 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 estimate content described in the estimate information.

[0023] That is, the recognition unit 112 may recognize, for example, the rows and columns of the estimated content recorded in the estimate information regarding 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 (estimated content) described in the estimate for each row and each column. The recognition unit 112 may recognize, for example, the rows and columns in which item contents such as material costs, labor costs, and miscellaneous expenses, unit prices, quantities, and estimated contents such as amounts are described.

[0024] Here, when the recognition unit 112 acquires, for example, the image information of the construction estimate (estimate image information regarding the image of the construction estimate), the recognition unit 112 may estimate the rows and columns of the estimated content based on the learned model and the estimate image information. The learned model may be, for example, a model generated by learning whether it is near a character, a horizontal grid line, or a vertical grid line for each pixel. When the recognition unit 112 estimates the rows and columns based on the image information (estimate image information), the recognition unit 112 may output the estimated result as sheet-form information. The sheet-form information may be various types of information including 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.

[0025] That is, the recognition unit 112 may ask questions of each pixel of the estimate image information based on, for example, an OCR semantic table in which whether it is near a character, a horizontal grid line, or a vertical grid line is recorded for each pixel, and let the learned model answer. The above-mentioned "near a character" is defined in the OCR semantic table. As a more specific example, the recognition unit 112 may connect the locations with an answer near a character adjacent to each other and treat them as one character. Here, the recognition unit 112 may not consider, for example, locations arranged horizontally as "right" and "left" adjacent to each other, and may not consider locations arranged vertically as "down" and "up" adjacent to each other. Also, as a more specific example, the recognition unit 112 may perform a Hough transform on the horizontal grid line and the location with an answer and treat it as a horizontal grid line. As a similar example, the recognition unit 112 may perform a Hough transform on the vertical grid line and the location with an answer and treat it as a vertical grid line. The recognition unit 112 may connect characters that are not separated by horizontal and vertical ruled lines to form cells. Note that the recognition unit 112 may, for example, consider that it is separated even if it is not separated by a horizontal ruled line when the distance on the vertical axis opens by a certain amount. Similarly, the recognition unit 112 may consider that it is separated even if it is not separated by a vertical ruled line when the distance on the horizontal axis opens by a certain amount. The recognition unit 112 may, for example, allocate columns based on vertical ruled lines and allocate rows based on horizontal ruled lines.

[0026] The first specific part 113 identifies a first column 11 in which at least one of the estimated unit price, estimated quantity, and estimated amount among the columns recognized by the recognition part 112 is described. The first column 11 may be referred to as the "specific column". That is, the first specific part 113 identifies a column (first column 11) in which at least one selected from the group of the estimated unit price, estimated quantity, and estimated amount is described among the plurality of columns recognized by the recognition part 112. As an example, the first specific part 113 examines a plurality of possible patterns as items for which the numerical values described in each column can be (for example, the estimated unit price, estimated quantity, and estimated amount) among the plurality of columns recognized by the recognition part 112, and estimates the most likely one as the column for each of the estimated unit price, estimated quantity, and estimated amount by comparing the numerical values described in the columns. In this case, the first specific part 113 may identify the first column 11, for example, by processing all combinations of the most likely ones as the estimated unit price, estimated quantity, and estimated amount, that is, the column of the estimated unit price, the column of the estimated quantity, and the column of the estimated amount, and voting for the likely ones. The first specific part 113 may vote for column candidates that satisfy the amount condition, for example, for the unit price and quantity. Similarly, the first specific part 113 may vote for column candidates that satisfy the amount condition, for example, for the unit price. The first specific part 113 may, for example, perform aggregation for each column and treat a continuous section with a large number of votes as at least one column selected from the group of the estimated unit price, estimated quantity, and estimated amount. In other words, the first specific part 113 obtains a plurality of combination patterns that the numerical values can take as combination patterns of the unit price, quantity, and amount based on the numerical values described in all columns, and may identify a column in which at least the amount among the unit price, quantity, and amount is described based on the pattern with the highest accuracy among the plurality of combination patterns.

[0027] The second specifying unit 114 may process a plurality of lines recognized by the recognition unit 112, for example, and convert them into sheet-form information for each line. In this case, the second specifying unit 114 specifies a second line 12 in which the amount of a specific item is described among the lines recognized by the recognition unit 112. That is, the second specifying unit 114 specifies the second line 12, for example, to exclude lines such as "subtotal".

[0028] The second specifying unit 114, for example, obtains the cumulative value of the amounts for each subset of the plurality of lines considered as an entire aggregate, determines the one that most resembles the total estimated amount, and adopts it. Here, as a candidate for the total estimated amount, for example, it is assumed that the total estimated amount exists alone in other parts of the form. The second specifying unit 114 may calculate the cumulative value of the amounts described in the columns specified by the first specifying unit 113, obtain a plurality of combination patterns of the cumulative amounts, and specify the line in which the estimated content (item content) excluding the second line 12 in which the item "subtotal" is described is described among the plurality of patterns. In this case, the second specifying unit 114 may flag each row belonging to the most likely subset, for example, from among the candidates for each item (materials, miscellaneous expenses, labor, and non-construction content) of the estimate. "Most likely" may be based mainly on, for example, consisting of as many rows as possible. Alternatively, the second specifying unit 114 may specify the second line 12 in which the amount of the specific item is described in the column with the highest accuracy among the columns of the plurality of patterns specified by the first specifying unit 113. In this case, the second specifying unit 114 may flag each row belonging to the most likely subset, for example, from among the candidates for the second line 12. "Most likely" may be based mainly on, for example, consisting of as few rows as possible. That is, the second specifying unit 114 may specify the second line 12 in which the amount of the specific item is described among the specified columns, for example, when the column in which the amount is described is specified as the column with the highest accuracy pattern.

[0029] The association unit 115 associates the item content specified by the second specifying unit 114 among the first columns 11 specified by the first specifying unit 113 with any one of the materials, sundries, labor, and non-construction contents of the reference price information stored in the storage unit 122. Or, the association unit 115 associates the item content described in the column excluding the second row 12 specified by the second specifying unit 114 among the first columns 11 specified by the first specifying unit 113 with any one of the materials, sundries, labor, and non-construction contents of the reference price information stored in the storage unit 122. That is, the association unit 115 associates the item content described in the rows excluding the row specified by the second specifying unit 114 among the plurality of rows recognized by the recognition unit 112 with any one of the materials, sundries, labor, and non-construction contents of the reference price information stored in the storage unit 122. As a specific example, when the material model number described in any of the plurality of rows matches (substantially matches) the material model number of the reference price information, the association unit 115 associates the item content (material) described in the row with the content (material) of the reference price information. In this case, the association unit 115 may calculate a score according to, for example, the degree of match (as an example, the length of the model number and the degree of fluctuation of the text, etc.) between the item content described in the row and the content recorded in the reference price information, and extract it as a candidate for association. The association unit 115 may, for example, determine with the candidate having the highest score when there is even one candidate extracted as described above.

[0030] When at least a part of the item content matches any one of the materials, sundries, labor, and non-construction content of the reference price information, the matching item content may be associated with any one of the materials, sundries, labor, and non-construction content. Here, the association unit 115 may have, for example, a model number dictionary in which the model numbers of materials and the like are registered. Also, the association unit 115 may have, for example, a preliminary model number dictionary in which a character string obtained by removing at least one character from the model number of materials and the like is registered. Further, the model number dictionary and the preliminary model number dictionary may be included in the reference price information, for example. The association unit 115 may, for example, refer to the model number dictionary and the preliminary model number dictionary and associate the character string described in the item content with any one of the materials, sundries, labor, and non-construction content. The association unit 115 may associate a character string obtained by removing at least one character from the character string of the item content described in the estimate with the materials, sundries, labor, and non-construction content of the reference price information by referring to the model number dictionary and the preliminary model number dictionary.

[0031] When at least a part of the item content matches a plurality of words combined from any of the materials, sundries, labor, and non-construction content of the reference price information, the matching item content may be associated with the plurality of words. Here, the association unit 115 may have, for example, a keyword group in which strings with assumed fluctuations (fluctuation keywords) such as item content and model numbers are registered. The keyword group may be included in the reference price information, for example. The association unit 115 may, for example, refer to the keyword group, check the presence or absence of keywords for the item content (character strings) in a plurality of lines, and associate with any one of the materials, sundries, labor, and non-construction content for which the logical operation results of AND and OR are true.

[0032] The first estimation unit 1161 estimates the appraised amount of the item content and the labor cost related thereto based on the result of associating the item content with materials and sundries by the association unit 115, the reference price of the materials and the reference sundry cost of the reference price information stored in the storage unit 122, and the rate of markup and the markup rate (predetermined values) set in advance according to the materials and sundries. As a specific example, when the first estimation unit 1161 identifies material Z based on the item content described in the estimate, it estimates the appraised amount of material Z and the labor cost related thereto based on the reference price of material Z recorded in the reference price information and the rate of markup and the markup rate for that material Z. That is, the first estimation unit 1161 multiplies, for example, the reference price of material Z by the markup rate to estimate the appraised amount of material Z. The first estimation unit 1161 estimates the appraised amount for each material and each sundry in the same manner as described above, for example. The rate of markup and the markup rate may be set to values that are presumably reasonable as the amount by which the merchant marks up the price. The presumably reasonable value may be a value appropriately set in consideration of various factors such as the purchase, storage, and transportation of materials, and the labor, time, and construction management of the construction work (for example, the amount obtained as profit), for example.

[0033] The second estimation unit 1162 estimates the appraised amount of the item content based on the result of associating the item content with labor and non-construction content by the association unit 115, the reference labor content and the reference non-construction cost of the reference price information stored in the storage unit 122, and the rate of markup and the markup rate (predetermined values) set in advance according to the labor and non-construction content. The rate of markup and the markup rate may be set to values that are presumably reasonable as the amount by which the merchant marks up the price. The presumably reasonable value may be a value appropriately set in consideration of various factors such as the purchase, storage, and transportation of materials, and the labor, time, and construction management of the construction work (for example, the amount obtained as profit), for example. The second estimation unit 1162 may estimate the appraised amount for each of the labor and non-construction content by multiplying the cumulative markup rate associated with the materials in the same estimate by the reference price of each of the labor and non-construction content in the same manner as the first estimation unit 1161 described above, for example.

[0034] Incidentally, the above-described first estimation unit 1161 and second estimation unit 1162 may be configured as one functional block, collectively referred to as the "estimation unit 116", for example.

[0035] The output control unit 117 controls the output unit to output each appraisal amount estimated by the first estimation unit 1161 and the second estimation unit 1162. The output unit may be, for example, the communication unit 121, the storage unit 122, the display unit 123, etc. That is, the output control unit 117 may control the communication unit 121 to transmit information regarding each appraisal amount estimated by the first estimation unit 1161 and the second estimation unit 1162 to the outside (external device). The external device may be, for example, a terminal used by the user (as an example, a desktop, a laptop, a tablet, a smartphone, etc.) (not shown), or a server (not shown). Also, the output control unit 117 may control the storage unit 122 to store information regarding each appraisal amount estimated by the first estimation unit 1161 and the second estimation unit 1162. Also, the output control unit 117 may control the display unit 123 to display information regarding each appraisal amount estimated by the first estimation unit 1161 and the second estimation unit 1162.

[0036] [Information Processing Method] FIG. 4 is a flowchart for explaining an information processing method according to an embodiment.

[0037] In step ST101, when the recognition unit 112 acquires estimation information about the construction estimate, it recognizes the rows and columns of the estimated content recorded in the estimation information. For example, when the recognition unit 112 acquires image information of the construction estimate (estimate image information regarding the image of the construction estimate), it may estimate the rows and columns of the estimated content based on the learned model and the estimate image information. The learned model may be, for example, a model generated by learning, for each pixel, whether it is near a character, which character it is, whether it is a horizontal grid line, or a vertical grid line.

[0038] In step ST102, the first specifying unit 113 specifies a first column 11 in which at least one of the estimated unit price, estimated quantity, and estimated amount is described, among the columns recognized in step ST101. In this case, for example, based on the numerical values described in all columns, the first specifying unit 113 acquires a plurality of combination patterns that the numerical values can take as combination patterns of unit price, quantity, and amount, and based on the pattern with the highest accuracy among the plurality of combination patterns, may specify a column in which at least the amount among the unit price, quantity, and amount is described.

[0039] In step ST103, the second specifying unit 114 specifies a second row 12 in which the amount of the specific item is described, among the rows recognized in step ST101. The second specifying unit 114 may specify the second row 12 in which the amount of the specific item is described, among the columns of the pattern with the highest accuracy among the plurality of patterns specified in step ST101.

[0040] In step ST104, the associating unit 115 associates the item content described in the column obtained by excluding the second row 12 specified in step ST103 from the first column 11 specified in step ST102, with any one of the materials, sundries, labor, and non-construction contents of the reference price information stored in the storage unit 122. In this case, for example, when at least a part of the item content matches any one of the materials, sundries, labor, and non-construction contents of the reference price information, the associating unit 115 may associate the matching item content with any one of the materials, sundries, labor, and non-construction contents. Further, for example, when at least a part of the item content matches a plurality of words formed by combining any plurality of words among the materials, sundries, labor, and non-construction contents of the reference price information, the associating unit 115 may associate the matching item content with the plurality of words.

[0041] In step ST105, the first estimating unit 1161 estimates the appraisal amount of the item content, based on the result of associating the item content with the materials and sundries in step ST104, the reference price of the materials and the reference sundry cost of the reference price information stored in the storage unit 122, and the rates and multipliers preset according to the materials and sundries. Further, the second estimation unit 1162 estimates the appraisal amount of the item content based on the result of associating the item content with the labor and non-construction content in step ST104, the standard labor content and the standard non-construction cost of the standard price information stored in the storage unit 122, and the rates and multipliers preset according to the labor and non-construction content.

[0042] In step ST106, the output control unit 117 controls the output unit to output each appraisal amount estimated in step ST105. Here, the output unit may be, for example, the communication unit 121, the storage unit 122, the display unit 123, or the like.

[0043] Each part of the information processing apparatus 100 described above may be realized as a function of a computer's arithmetic processing unit or the like. That is, the recognition unit 112, the first specifying unit 113, the second specifying unit 114, the association unit 115, the estimation unit 116 (the first estimation unit 1161 and the second estimation unit 1162), and the output control unit 117 (the control unit 111) of the information processing apparatus 100 may be realized as a recognition function, a first specifying function, a second specifying function, an association function, an estimation function (the first estimation function and the second estimation function), and an output control function (control function) by a computer's arithmetic processing unit or the like, respectively. The information processing program can cause a computer to realize each of the above-described functions. The information processing program may be recorded on a non-transitory computer-readable recording medium such as a memory, a solid state drive, a hard disk drive, or an optical disk. Also, as described above, each part of the information processing apparatus 100 may be realized by a computing processing unit of a computer or the like. Such a computing processing unit is configured by, for example, an integrated circuit or the like. Therefore, each part of the information processing apparatus 100 may be realized as a circuit constituting the computing processing unit or the like. That is, 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 (control unit 111) of the information processing apparatus 100 may be realized as a recognition circuit, a first specifying circuit, a second specifying circuit, an associating circuit, an estimating circuit (the first estimating circuit and the second estimating circuit), and an output control circuit (control circuit) constituting the computing processing unit of a computer or the like. Also, the communication unit 121, the storage unit 122, and the display unit 123 (output unit) of the information processing apparatus 100 may be realized as a communication function, a storage function, and a display function (output function) including functions of a computing processing unit or the like, for example. Also, the communication unit 121, the storage unit 122, and the display unit 123 (output unit) of the information processing apparatus 100 may be realized as a communication circuit, a storage circuit, and a display circuit (output circuit) by being configured by, for example, an integrated circuit or the like. Also, the communication unit 121, the storage unit 122, and the display unit 123 (output unit) of the information processing apparatus 100 may be configured as a communication device, a storage device, and a display device (output device) by being configured by, for example, a plurality of devices.

[0044] The information processing apparatus 100 can combine one or any plurality of the above-described plurality of parts. In the present disclosure, the term "information" is used, but the term "information" can be replaced with the term "data", and the term "data" can be replaced with the term "information".

[0045] [Aspects and Effects of the Present Embodiment] Next, one aspect of the present embodiment and the effects exhibited by each aspect will be described. Note that the present embodiment is not limited to each aspect described below, and may be realized by appropriately combining the above-described respective parts. Also, the effects described below are examples, and the effects exhibited by each aspect are not limited to those described below.

[0046] (Aspect 1) An information processing apparatus (for example, a construction cost appraisal apparatus, etc.) according to one aspect stores reference price information on construction materials, the reference prices of those materials, sundries used in the construction, the reference sundry material costs of those sundries, reference labor costs related to labor when performing the construction, and reference non-construction costs related to non-construction content in a storage unit, a recognition unit that recognizes rows and columns of the estimated content recorded in the estimated information regarding the construction estimate, among the columns recognized by the recognition unit, a first specifying unit that specifies a first column in which at least one of the unit price of the estimate, the quantity of the estimate, and the amount of the estimate is described, among the rows recognized by the recognition unit, a second specifying unit that specifies a second row in which the amount of a specific item is described, a correspondence unit that associates the item content described in the column excluding the second row specified by the second specifying unit among the first columns specified by the first specifying unit with any one of the materials, sundries, labor, and non-construction content of the reference price information stored in the storage unit, a first estimating unit that estimates the appraisal amount of the item content based on the result of associating the item content with the materials and sundries by the correspondence unit, the reference price of the materials and the reference sundry material costs of the sundries of the reference price information stored in the storage unit, and the rates and multipliers preset according to the materials and sundries, a second estimating unit that estimates the appraisal amount of the item content based on the result of associating the item content with the labor and non-construction content by the correspondence unit, the reference labor content and the reference non-construction costs of the reference price information stored in the storage unit, and the rates and multipliers preset according to the labor and non-construction content, and an output control unit that controls to output each appraisal amount estimated by the first estimating unit and the second estimating unit. Thereby, the construction cost appraisal apparatus can perform an appraisal of the estimate for each of a plurality of items described in the estimate. That is, the construction cost appraisal apparatus can appraise the amount described in the estimate. The construction cost appraisal apparatus can provide the user with whether the amount of each item described in the estimate is reasonable.

[0047] (Aspect 2) In an information processing apparatus according to one aspect (for example, an engineering cost estimation apparatus, etc.), when the recognition unit acquires estimate image information regarding an estimate image of a construction project, it may estimate the rows and columns of the estimate content based on a learned model that has learned whether it is near text, a horizontal ruled line, or a vertical ruled line for each pixel, and the estimate image information. As a result, the engineering cost estimation apparatus can appropriately recognize the estimate.

[0048] (Aspect 3) In an information processing apparatus according to one aspect (for example, an engineering cost estimation apparatus, etc.), the first specifying 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 described in all columns, and based on the pattern with the highest accuracy among the plurality of combination patterns, it may specify the column in which at least the amount among the unit price, quantity, and amount is described. As a result, the engineering cost estimation apparatus can specify the columns in which the unit price, quantity, and amount are described in the estimate.

[0049] (Aspect 4) In an information processing apparatus according to one aspect (for example, an engineering cost estimation apparatus, etc.), the second specifying unit may specify the second row in which the amount of the specific item is described in the column specified by the first specifying unit. As a result, the engineering cost estimation apparatus can specify items that are less likely to be required for the estimation of the estimate, that is, for example, items such as "subtotal", and perform the estimation of the estimate excluding the specified items.

[0050] (Aspect 5) In an information processing apparatus according to one aspect (for example, an engineering cost estimation apparatus, etc.), when at least a part of the item content matches any one of the materials, sundries, labor, and non-construction content of the reference price information, the association unit may associate the matching item content with any one of the materials, sundries, labor, and non-construction content. As a result, even if the item content (e.g., character string) described in the estimate does not exactly match the content recorded in the reference price information, the construction cost estimation device can associate the item content (e.g., character string) described in the estimate with the content recorded in the reference price information.

[0051] (Aspect 6) In an information processing device (e.g., a construction cost estimation device, etc.) according to one aspect, when at least a part of the item content matches a plurality of words formed by combining any plurality of words among the materials, sundries, labor, and non-construction contents of the reference price information, the association unit may associate the matching item content with the plurality of words. As a result, even if the item content (e.g., character string) described in the estimate does not exactly match the content recorded in the reference price information, the construction cost estimation device can associate the item content (e.g., character string) described in the estimate with the content recorded in the reference price information.

[0052] (Aspect 7) An information processing device (e.g., a construction cost estimation device, etc.) according to one aspect includes a storage unit that stores reference price information regarding the reference price of the construction content, a recognition unit that recognizes the rows and columns of the estimate content recorded in the estimate information regarding the construction estimate, a first specifying unit that specifies a first column in which the estimate is described among the columns recognized by the recognition unit, a second specifying unit that specifies a second row in which the amount of a specific item is described among the rows recognized by the recognition unit, an association unit that associates the item content described in the columns excluding the second row specified by the second specifying unit among the first columns specified by the first specifying unit with the content recorded in the reference price information stored in the storage unit, an estimation unit that estimates the appraisal amount of the item content based on the result of associating the item content with the content by the association unit, the reference price of the reference price information stored in the storage unit, and the rate and multiplier preset according to the construction content, and an output control unit that controls to output each appraisal amount estimated by the estimation unit. As a result, the construction cost estimation device can achieve the same effects as the construction cost estimation device of the above-described one aspect.

[0053] (Aspect 8) An information processing apparatus (for example, a construction cost estimation apparatus, etc.) according to one aspect stores reference price information on construction materials, the reference prices of those materials, miscellaneous materials used in the construction, the reference miscellaneous material costs of those miscellaneous materials, reference labor costs related to labor when performing the construction, and reference non-construction costs related to non-construction content in a storage unit, a recognition unit that recognizes rows and columns of the estimated content recorded in the estimated information regarding the construction estimate, a first identification unit that identifies a first column in which at least one of the unit price of the estimate, the quantity of the estimate, and the amount of the estimate is described among the columns recognized by the recognition unit, a second identification unit that identifies a row in which the amount of the item content that becomes the estimated content is described among the rows recognized by the recognition unit, a matching unit that associates the item content described in the row identified by the second identification unit among the first columns identified by the first identification unit with any one of the materials, miscellaneous materials, labor, and non-construction content of the reference price information stored in the storage unit, a first estimation unit that estimates the appraisal amount of the item content based on the result of associating the item content with the materials and miscellaneous materials by the matching unit, the reference price of the materials and the reference miscellaneous material cost of the reference price information stored in the storage unit, and the rates and multipliers preset according to the materials and miscellaneous materials, a second estimation unit that estimates the appraisal amount of the item content based on the result of associating the item content with the labor and non-construction content by the matching unit, the reference labor content and the reference non-construction cost of the reference price information stored in the storage unit, and the rates and multipliers preset according to the labor and non-construction content, and an output control unit that controls to output each appraisal amount estimated by the first estimation unit and the second estimation unit. Thereby, the construction cost estimation apparatus can achieve the same effects as the construction cost estimation apparatus of the above-described one aspect.

[0054] (Aspect 9) In a method of information processing according to one aspect (e.g., a construction cost estimation method, etc.), a computer including a storage unit that stores reference price information regarding the reference price of the content of the construction work performs a recognition step of recognizing the rows and columns of the estimated content recorded in the estimate information regarding the construction work, a first specifying step of specifying a first column in which the estimate is described among the columns recognized in the recognition step, a second specifying step of specifying a second row in which the amount of a specific item is described among the rows recognized in the recognition step, a matching step of associating the item content described in the columns excluding the second row specified in the second specifying step among the first columns specified in the first specifying step with the content recorded in the reference price information stored in the storage unit, an estimating step of estimating the estimated amount of the item content based on the result of associating the item content with the content in the matching step, the reference price of the reference price information stored in the storage unit, and the rate and multiplier preset according to the content of the construction work, and an output control step of controlling to output each estimated amount estimated in the estimating step. Thereby, the construction cost estimation method can achieve the same effect as the construction cost estimation device according to the above-described one aspect.

[0055] (Aspect 10) An information processing program of one aspect (for example, a construction cost estimation program, etc.) causes a computer to have a storage function for storing reference price information regarding the reference price of the content of the construction work, a recognition function for recognizing the rows and columns of the estimated content recorded in the estimate information regarding the estimate of the construction work, a first specifying function for specifying a first column in which the estimate is described among the columns recognized by the recognition function, a second specifying function for specifying a second row in which the amount of a specific item is described among the rows recognized by the recognition function, a correlation function for correlating the item content described in the columns excluding the second row specified by the second specifying function from the first column specified by the first specifying function with the content recorded in the reference price information stored in the storage function, an estimation function for estimating the estimated amount of the item content based on the result of correlating the item content with the content by the correlation function, the reference price of the reference price information stored in the storage function, and the rates and multipliers preset according to the content of the construction work, and an output control function for controlling to output each estimated amount estimated by the estimation function. Thereby, the construction cost estimation program can achieve the same effects as the construction cost estimation device of the above-described one aspect.

Explanation of Signs

[0056] 1 Information processing system 100 Information processing device (construction cost estimation device) 111 Control unit 112 Recognition unit 113 First specifying unit 114 Second specifying unit 115 Correlation unit 116 Estimation unit 1161 First estimation unit 1162 Second estimation unit 117 Output control unit 121 Communication unit 122 Storage unit 123 Display unit

Claims

1. A storage unit that stores standard price information related to materials for construction work, standard prices of the materials, miscellaneous materials used in the construction work, standard miscellaneous material costs of the miscellaneous materials, standard labor costs related to labor during the construction work, 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 related to an estimate for a construction project; 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 an amount 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 matching unit that matches the item contents described in the columns, excluding the second row specified by the second specifying unit, of the first column specified by the first specifying unit with 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 appraisal value of the item contents based on a result of the association between the item contents and the materials and miscellaneous materials by the association unit, the standard prices of the materials and the standard miscellaneous materials costs of the miscellaneous materials in the standard price information stored in the storage unit, and the labor rate and rate that are preset according to the materials and miscellaneous materials; a second estimation unit that estimates an appraisal value of the item content based on the result of the association between the item content and 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 to output each of 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 an estimate for construction work, the recognition unit estimates rows and columns of the estimate contents 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. The construction cost assessment device according to claim 1.

3. The first identification unit obtains 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 is written among the unit price, quantity, and amount 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 specification unit specifies a second row in which an amount of a specific item is written in the column specified by the first specification unit. The construction cost assessment device according to claim 3.

5. When at least a part of the item content matches any one 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 one 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 association 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 related to an estimate for a construction project; a first identification unit that identifies a first column in which an estimate is written, among 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 item contents described in columns, excluding a second row specified by the second specification unit, of a first column specified by the first specification unit to contents recorded in base price information stored in the storage unit; an estimation unit that estimates an appraisal 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 labor rate and the rate that are preset according to the content of the construction work; an output control unit that controls to output 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 materials for construction work, standard prices of the materials, miscellaneous materials used in the construction work, standard miscellaneous material costs of the miscellaneous materials, standard labor costs related to labor during the construction work, 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 related to an estimate for a construction project; 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 an amount 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 described among the lines recognized by the recognition unit; a correspondence unit that corresponds the item contents described in the row identified by the second identification unit among the first column identified by the first identification unit to any one 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 appraisal value of the item contents based on a result of the association between the item contents and the materials and miscellaneous materials by the association unit, the standard prices of the materials and the standard miscellaneous materials costs of the miscellaneous materials in the standard price information stored in the storage unit, and the labor rate and rate that are preset according to the materials and miscellaneous materials; a second estimation unit that estimates an appraisal value of the item content based on the result of the association between the item content and 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 to output each of 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 for storing reference price information relating to a reference price of a construction content, A recognition step of recognizing rows and columns of estimate contents recorded in estimate information relating to an estimate for a construction project; a first identification step of identifying a first column in which an estimate is written, among columns recognized by the recognition step; a second identification step of identifying a second line in which an amount of a specific item is written among the lines recognized by the recognition step; a matching step of matching item contents described in columns, excluding the second row specified by the second specifying step, among the first column specified by the first specifying step with contents recorded in the base price information stored in the storage unit; an estimation step of estimating an appraisal value of the item contents based on the result of the association between the item contents and the contents in the association step, the reference price of the reference price information stored in the storage unit, and the unit rate and rate that are preset according to the contents 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 to carry out the above.

10. On the computer, A storage function for storing reference price information regarding the reference price of the contents of the construction work; A recognition function for recognizing rows and columns of the estimate contents recorded in the estimate information regarding the estimate for the construction work; A first identification 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 an amount of a specific item is written among the lines recognized by the recognition function; a matching function for matching item contents described in a first column specified by the first specifying function, excluding a second row specified by the second specifying function, with contents recorded in the reference price information stored in the storage function; an estimation function for estimating an appraisal value of the item contents based on the result of matching the item contents and contents by the matching function, the reference price of the reference price information stored in the storage function, and the unit rate and rate that are preset according to the content of the construction work; an output control function for controlling to output each appraisal value estimated by the estimation function; A construction cost assessment program that makes this possible.

Images