KR20210032068A - Method Of Estimation Of Construction Unit Price From Item Description, Specification And Unit In Bill Of Quantity - Google Patents

Abstract

The present invention relates to a system for estimating or confirming a unit price of a construction statement with three elements of a name, a specification, and a unit of a detailed construction type and posting an advertisement according to the name. The present invention includes: a pre-processing step including a leveling module of a level of the construction type of a detailed construction type name, a module for linking the same detailed construction type in the statement, and a subtotal generation module according to the detailed construction type name; a name, standard, and unit search step in which an actual user searches; a step in which the user selects/cancels the name, standard, and unit of each detailed work type to create a search word, transmits the search word to a server, and outputs a result; a step of selecting a default search term option; and a keyword search step using search terms extracted from the name of the detailed work type at the same time as the search, thereby providing an interface through which a user can derive a desired result.

Description

Processing method for unit price estimation and unit price review of construction work statement {Method Of Estimation Of Construction Unit Price From Item Description, Specification And Unit In Bill Of Quantity}

The present invention is for estimating and confirming the unit price of a construction work statement, and when a detailed work type with the name, standard, and unit of the statement is designated/changed in the process as shown in FIG. 10, data of a server similar or matching the same is displayed. Thus, it relates to a system that delivers the data selected by the user.

The present invention is a technology that simplifies the existing complex process of creating a unit price of a statement by generating the first cost and calculation basis of a construction work history program as shown in FIG. 1.

The object of the present invention is to deliver the design unit cost to the user based on three pieces of information of the name, standard, and unit of the construction construction statement selected by the user without the resource data required for the construction of the existing construction construction statement.

Another object of the present invention is to provide advertisements with information of a name, standard, and unit selected by the user.

Another object of the present invention is to provide a method of registering a statement selected by a user in a server and sharing the statement with other users.

In order to solve this problem, in step 1100 of FIG. 1, columns such as the name, standard, and unit of the Excel statement are designated as shown in FIGS. 2 to 3. By processing the characters of the designated name, the level of the name is leveled, and the detailed works of the same name are connected to make a subtotal according to each name as shown in FIG. 5. When the user selects the detailed construction type of the processed statement as shown in FIG. 4, the character information of the name, standard, and unit is sent to the server according to the options selected by the user of reference numerals 2030, 2050, and 2070 of FIG. 14 in the process of FIG. It can send and receive information that can be selected to the user in the form of FIG. 7 accordingly. In addition, as shown in FIGS. 11 to 13, all words of a name, standard, and unit may be selected/deselected or dragged and dropped respectively for search.

Here, a keyword is extracted from the name, and advertisements matching the keyword and the local information selected by the user, such as 2080 of FIG. 14, are displayed as 2090 to 2095 of FIG. 14. Advertisements are displayed in the form of a banner, and when the user cursor moves on the advertisement, the details of the advertisement are displayed. In addition, if the homepage is registered in the advertisement, when the mouse is clicked, the registered homepage is displayed on the user's Internet browser.

The use of the present invention has the following effects for the user.

First, the user searches for the design data of the detailed work type, and provides a list and graph of the total name, standard, unit, material cost, labor cost, expense, and unit price as shown at 2000 to 2010 in FIG. It is possible to easily check the appropriateness of or to reflect the unit price in Excel of FIG. 4 by selecting from the list of reference numerals 2000. Through this, it is possible to maximize work efficiency by determining the range of objective unit prices and reducing unnecessary time required for confirming and reflecting the appropriate unit price.

Second, by displaying the keyword of the searched detailed work type and advertisement classified by region as indicated by reference numerals 2080 to 2095 of FIG. 14, it is possible to easily connect with an advertisement company. Through this, it is possible to increase the work efficiency of requesting a quotation and selecting a subcontractor.

1 is a diagram of the main process of the present invention.
2 is a diagram of an Excel statement before processing the name of the detailed work type of the statement selected by the user.
3 is a diagram in which a user reads a statement for the first time and designates a column such as a name, standard, and unit of Excel.
4 is a diagram illustrating a process of a detailed work type name of an Excel statement designated by a user.
5 is a diagram illustrating a subtotal generation by grouping an Excel statement designated by a user by name of each detailed work type.
6 is a main screen of the present invention.
7 is a diagram showing the result of matching (Matching) with the detailed construction type (name, standard, unit) selected by the user on the screen
8 is a diagram showing detailed information of an advertisement according to a keyword search.
9 is a diagram illustrating that a user transmits a statement to a server to share a statement.
10 is a diagram illustrating a search result and advertisement display when a user changes a detailed construction type.
FIG. 11 is a diagram illustrating a process of deriving a search result while a user selects/deselects a word after the process of FIG. 10.
12 is a diagram showing a process of deriving a search result by deleting a word of a name by dragging and dropping a word by a user after the process of FIGS. 10 to 11.
13 is a diagram showing a process of deriving a search result by dragging a word of a name and dropping it into a standard.
14 is a diagram showing the entire user interface of the present invention.
15 is a diagram showing a search screen interface according to the present invention.

Hereinafter, the drawings will be described in detail. 1 is a basic process of the present invention, reading a user's Excel file, selecting an Excel sheet required for work as shown in FIG. 3, and selecting the code, name, standard, unit, quantity, material cost, labor cost, expense, and unit price of the sheet. Specify the total, material cost amount, labor cost amount, expense amount, remark, and output column. If the output column is designated here, the construction type level of each sub-construction name (example: “...b-1] reinforced concrete” of “...b-1]”) is deleted and the sub-construction name as shown in FIG. After processing to remain intact, a new excel sheet is created and the processed detailed work type names are grouped, and the detailed work type name processed statement and subtotal are created as shown in FIGS. 4 to 5. Upon completion of this operation, the main program of the present invention is executed as shown in FIG. 6 and a search result request is sent to the server according to the search conditions of 2020 to 2070 of FIG. 14. Here, a list and graph of the searched results are displayed as shown in FIG. 7. The server searches for a keyword condition according to the name, displays an advertisement corresponding to it on the user screen as shown in FIG. 8, and when the user wants to see the detailed result of the advertisement, when the user places the mouse cursor on the advertisement, the content is displayed and clicks the mouse. If so, the homepage is displayed on the screen.

1000: The process of this claim
1100: A module that selects an Excel statement selected by the user
1110: As shown in FIG. 3, a module in which a user selects an Excel sheet and designates a column of the statement by name, standard, unit, quantity, etc.
1120: A pre-processing module that deletes the construction type level of the detailed construction type name so that only the name can be searched completely
1130: A module for connecting the same unit price so that the same unit price is not searched again by grouping the name, standard, and unit of the detailed construction type as shown in FIG. 4
1140: A module that makes subtotals of the same types of work by grouping detailed work types according to the name and unit of the detailed work type as shown in FIG. 5
1210: User interface used for actual search as the main program
1220: A module that transmits the name, standard, and unit to be found to the server when the user selects the detailed construction type that the user wants to find in Excel or the main program.
1225: Module for sending detailed construction types that the user wants to find to the server and displaying search results
1230: Option to select/deselect search words in the main program to search in server data, select/deselect all words, ignore special characters, ignore numbers, ignore alphabets, ignore Korean characters, match unclear characters, exact characters A module that has a match and sends the changed search word to the server when the option is changed.
1240: Even in the description of symbol 1230, if there is no result of the search, click each word, select/release with a shortcut key, or drag and drop the word to change the position of the word, delete the word to search. Modules that produce results
1250: When there is an advertisement keyword in the name of the detailed construction selected by the user, a module that displays the advertisement
2000: Search result list display window
2010: A window showing the material cost, labor cost, expenses, and total of the search results
2020: Grid for selecting/deselecting words for detailed work types
2030: Option to select the word for the name of the detailed construction
2040: Grid for selecting/deselecting the word for detailed construction standards
2050: Detailed construction type standard word selection option
2060: Word selection/cancellation grid for detailed work type units
2070: Option to select a word for each detailed construction type, material cost, labor cost, whether or not there is an option, search database setting option
2080: ad area setting
2090: advertising area
2095: Ad details
3010: How to change Excel row position and search word by moving the mouse wheel up/down, and description of keyboard shortcuts
3020: How to select a list in the result window by moving the mouse wheel up/down

Claims (1)

In the processing method for unit price estimation and unit price review of a construction work statement, the statement processing method includes the steps of reading a user's statement of FIG. 1; Leveling the detailed work type level of the statement; Linking the same unit price of detailed construction types in the leveled statement; Dividing the subtotal by the name of the detailed work type; Retrieving the name, standard, and unit of the leveled detailed construction type from the server; Including, by the user selects/deselects words of the name, standard, and unit of the detailed work type by the search method of FIGS. 10 to 15, and searches the database of the server to provide the result and keyword advertisement corresponding thereto to the user. How to show in a list.

Images