Disclosure of Invention
The application provides a method, a device and equipment for reversely generating WBS structure and summarizing engineering cost, so as to solve the problem of insufficient utilization of historical engineering data in the prior art.
The above object of the present application is achieved by the following technical solutions:
in a first aspect, an embodiment of the present application provides a method for reverse generating WBS structure and engineering cost summaries, including:
acquiring a history engineering file; wherein, the history engineering file comprises a cost list, and the data in the cost list comprises WBS codes;
sequentially selecting WBS codes from the cost list, and determining node codes of related levels corresponding to the selected WBS codes based on preset standard coding rules;
traversing a preset standard WBS structure library based on the determined node codes to obtain corresponding node information;
based on the obtained node information, reversely generating a WBS structure and establishing a corresponding relation with the cost list;
and summarizing the engineering cost according to the corresponding relation between the reverse generated WBS structure and the cost list.
Optionally, the preset standard coding rule includes WBS codes of different levels and corresponding names.
Optionally, the method for dividing the different layers includes: the division is performed by the number of coding bits or based on the delimiter.
Optionally, the sequentially selecting WBS codes from the cost list, and determining node codes of a relevant hierarchy corresponding to the selected WBS codes based on a preset standard coding rule, includes:
and sequentially selecting WBS codes of the bottom child nodes from the cost list, and determining the WBS codes of the father nodes corresponding to the WBS codes of the selected bottom child nodes step by step based on a preset standard coding rule.
Optionally, the obtained node information includes a name and a hierarchy to which the WBS code corresponds.
Optionally, the establishing a correspondence with the cost list includes:
and according to the name corresponding to the WBS code and the hierarchy, mounting the corresponding data in the cost list under the corresponding sub-nodes.
Optionally, the step of summarizing the engineering cost according to the correspondence between the reverse generated WBS structure and the cost list includes:
and according to the corresponding relation between the reverse generated WBS structure and the cost list, summarizing the construction cost, the equipment cost and the installation cost according to different hierarchical relations.
Optionally, the method further comprises:
and outputting a summary table according to the summary result of the engineering cost.
In a second aspect, embodiments of the present application further provide an apparatus for reverse generating a WBS structure and a summary of engineering costs, including:
the file acquisition module is used for acquiring a history engineering file; wherein, the history engineering file comprises a cost list, and the data in the cost list comprises WBS codes;
the determining module is used for sequentially selecting WBS codes from the cost list and determining node codes of related levels corresponding to the selected WBS codes based on a preset standard coding rule;
the information acquisition module is used for traversing a preset standard WBS structure library based on the determined node codes to acquire corresponding node information;
the generation module is used for reversely generating the WBS structure based on the acquired node information and establishing a corresponding relation with the cost list;
and the construction cost summarizing module is used for summarizing the construction cost according to the corresponding relation between the reverse generated WBS structure and the construction cost list.
In a third aspect, embodiments of the present application further provide an intelligent device, including:
a memory and a processor coupled to the memory;
the memory is used for storing a program, and the program is at least used for realizing the method according to any one of the first aspect;
the processor is used for calling and executing the program stored in the memory.
The technical scheme provided by the embodiment of the application can comprise the following beneficial effects:
in the technical scheme provided by the embodiment of the application, the WBS codes are sequentially selected from the manufacturing cost list by acquiring the historical engineering file, and node codes of relevant levels corresponding to the selected WBS codes are determined based on standard coding rules; and traversing a preset standard WBS structure library based on the determined node codes to obtain corresponding node information, further reversely generating the WBS structure, establishing a corresponding relation with the cost list, and finally summarizing the engineering cost according to the corresponding relation between the reversely generated WBS structure and the cost list. The method can reversely generate the WBS structure tree from the engineering cost list detail based on the standard WBS structure and the WBS code, and automatically collect the corresponding engineering cost list under the WBS nodes, thereby realizing forward summarization of various expenses of the WBS nodes, and greatly helping to guide the construction of new project engineering cost and the standard analysis of similar projects based on the WBS structure.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Detailed Description
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present application as detailed in the accompanying claims.
In order to solve the problem of insufficient utilization of historical engineering data in the prior art, the application provides a scheme for reversely generating a WBS structure and realizing engineering cost summarization based on historical engineering files, so that the method and the device provide help for guiding the construction cost of a new project and performing standard analysis on similar projects based on the WBS structure, and detailed description is given below through specific embodiments.
Examples
Referring to fig. 1, fig. 1 is a flow chart illustrating a method for reversely generating WBS structures and engineering cost summaries according to an embodiment of the present application. Wherein the method is performed by a smart device such as a PC.
As shown in fig. 1, the method at least comprises the following steps:
s101: acquiring a history engineering file; wherein, the history engineering file comprises a cost list, and the data in the cost list comprises WBS codes;
specifically, the cost list, i.e., the engineering quantity list, generally includes information such as list codes, engineering names, units, numbers, unit prices, and price, in addition to WBS codes, as shown in fig. 2.
The WBS (Work Breakdown Structure, work decomposition structure) codes are codes set for different projects (or project combinations) in the WBS tree structure constructed in the engineering design process and are used for distinguishing different projects. Table 1 below illustrates a WBS structure.
TABLE 1 WBS Structure
In addition, in a specific application, the history engineering file can be acquired by a file import mode.
S102: sequentially selecting WBS codes from the cost list, and determining node codes of related levels corresponding to the selected WBS codes based on preset standard coding rules;
specifically, the standard encoding rule is a WBS encoding method configured in advance according to actual needs, for example, WBS encoding of different levels and corresponding names can be included in the WBS encoding rule, that is, the WBS encoding can be divided into N levels, so that the level characteristics are reflected, and the WBS encoding method is convenient to view and understand. The method for dividing different levels comprises the following steps:
coding mode one: dividing according to the number of coding bits, such as shown in the following table 3, wherein the first two bits XX represent one stage, the third four bits represent one stage, and the last bit represents one stage;
alternatively, coding scheme two: the partitioning is based on separators, such as shown in table 3 below, with one separator "-" representing a level.
Table 3 two different coding schemes
Of course, other encoding methods may be included, as long as the hierarchical characteristics can be represented, and this is not limited.
After WBS codes are selected from the cost list, the belonging level can be determined according to the corresponding standard coding rules, and then the codes of other nodes of the related level can be determined.
Further, in the specific implementation, step S102: sequentially selecting WBS codes from the cost list, and determining node codes of related levels corresponding to the selected WBS codes based on a preset standard coding rule, wherein the method specifically comprises the following steps: and sequentially selecting WBS codes of the bottom child nodes from the cost list, and determining the WBS codes of the father nodes corresponding to the WBS codes of the selected bottom child nodes step by step based on a preset standard coding rule.
That is, when selecting one WBS code, the WBS code of the bottom child node may be preferentially selected, and then the node code of the higher level (i.e. the parent node code) is obtained step by step according to the WBS code of the bottom child node, for example, the following is illustrated in combination with table 1 and coding mode one: firstly selecting WBS codes of a bottom sub-node, and supposing to select XX063; according to the coding rule, the higher level node thereof, that is, XX060, can be obtained, and according to XX060, the higher level node thereof, that is, XX000, and the lower level nodes XX061, XX062, and the like can be obtained. The arrangement is more beneficial to ensuring that the problem of missing WBS codes in the selection process does not occur.
This step is ended when the sequentially selected WBS codes ensure that all WBS codes in the cost list are selected.
S103: traversing a preset standard WBS structure library based on the determined node codes to obtain corresponding node information;
specifically, a preset standard WBS structure library stores a plurality of standard WBS structures suitable for different projects, each standard WBS structure includes node information, and then the corresponding standard WBS structure and node information corresponding to each node code can be determined from the standard WBS structure library according to the node codes determined in the previous steps. The obtained node information may include, for example, a name and a hierarchy to which the WBS code corresponds.
S104: based on the obtained node information, reversely generating a WBS structure and establishing a corresponding relation with the cost list;
specifically, after node information corresponding to all WBS codes in the cost list is obtained, the WBS structure can be reversely constructed, that is, a tree structure similar to fig. 1 including WBS hierarchy, WBS codes and WBS names is generated, and then the corresponding relationship between the WBS structure and the cost list is built according to the WBS code information.
In some embodiments, the step of establishing a correspondence between WBS structures and cost listings specifically includes: and according to the name corresponding to the WBS code and the hierarchy, mounting the corresponding data in the cost list under the corresponding sub-nodes. Namely, corresponding list data is automatically collected under the WBS structure according to WBS codes in the cost list. Wherein, fig. 3 shows a schematic diagram of the correspondence between WBS structure and cost list. In fig. 3, the left data is a reverse generated WBS structure, and the right is a cost list downloaded by WBS nodes.
S105: and summarizing the engineering cost according to the corresponding relation between the reverse generated WBS structure and the cost list.
Specifically, according to the corresponding relation between the WBS structure and the cost list which are reversely generated in the steps, the engineering cost summarization can be realized, and specifically, the construction cost, the equipment cost and the installation cost are summarized according to different hierarchical relations according to the WBS structure which is reversely generated. The summary results are shown in FIG. 4. In addition, after the summarized results are obtained, the summarized table can be output according to the summarized results of the engineering cost for the user to check.
In the technical scheme provided by the embodiment of the application, the WBS codes are sequentially selected from the manufacturing cost list by acquiring the historical engineering file, and node codes of relevant levels corresponding to the selected WBS codes are determined based on standard coding rules; and traversing a preset standard WBS structure library based on the determined node codes to obtain corresponding node information, further reversely generating the WBS structure, establishing a corresponding relation with the cost list, and finally summarizing the engineering cost according to the corresponding relation between the reversely generated WBS structure and the cost list. The method can reversely generate the WBS structure tree from the engineering cost list detail based on the standard WBS structure and the WBS code, and automatically collect the corresponding engineering cost list under the WBS nodes, thereby realizing forward summarization of various expenses of the WBS nodes, and greatly helping to guide the construction of new project engineering cost and the standard analysis of similar projects based on the WBS structure.
In addition, based on the same inventive concept, the embodiment of the present application further provides a device for reversely generating the WBS structure and the engineering cost summary, corresponding to the method for reversely generating the WBS structure and the engineering cost summary provided in the above embodiment of the present application. The device is a collection of hardware and/or software based functional modules in the intelligent device for implementing the method.
Referring to fig. 5, fig. 5 is a schematic structural diagram of a device for reversely generating WBS structures and summarizing engineering costs according to an embodiment of the present application.
As shown in fig. 5, the device at least comprises the following structure:
a file acquisition module 51, configured to acquire a history engineering file; wherein, the history engineering file comprises a cost list, and the data in the cost list comprises WBS codes;
a determining module 52, configured to sequentially select WBS codes from the cost list, and determine node codes of a relevant hierarchy corresponding to the selected WBS codes based on a preset standard coding rule;
the information obtaining module 53 is configured to traverse a preset standard WBS structure library based on the determined node codes, and obtain corresponding node information;
the generating module 54 is configured to reversely generate the WBS structure and establish a correspondence with the cost list based on the obtained node information;
and the construction cost summarizing module 55 is used for summarizing the construction cost according to the corresponding relation between the reverse generated WBS structure and the construction cost list.
Optionally, the preset standard coding rule includes WBS codes of different levels and corresponding names.
Optionally, the method for dividing the different layers includes: the division is performed by the number of coding bits or based on the delimiter.
Optionally, the determining module 52 is specifically configured to, when sequentially selecting WBS codes from the cost list and determining node codes of a relevant hierarchy corresponding to the selected WBS codes based on a preset standard coding rule:
and sequentially selecting WBS codes of the bottom child nodes from the cost list, and determining the WBS codes of the father nodes corresponding to the WBS codes of the selected bottom child nodes step by step based on a preset standard coding rule.
Optionally, the obtained node information includes a name and a hierarchy to which the WBS code corresponds.
Optionally, the generating module 54 is specifically configured to, when establishing the correspondence with the cost list:
and according to the name corresponding to the WBS code and the hierarchy, mounting the corresponding data in the cost list under the corresponding sub-nodes.
Optionally, the cost summarizing module 55 is specifically configured to, when summarizing the construction cost according to the correspondence between the WBS structure and the cost list generated in the reverse direction:
and according to the corresponding relation between the reverse generated WBS structure and the cost list, summarizing the construction cost, the equipment cost and the installation cost according to different hierarchical relations.
Optionally, the cost summary module 55 is further configured to: and outputting a summary table according to the summary result of the engineering cost.
The specific implementation method of the steps executed by the above functional modules may refer to corresponding content in the foregoing method embodiments, which is not described herein again.
In addition, based on the same inventive concept, the embodiment of the application further provides an intelligent device corresponding to the method for reversely generating the WBS structure and the summary of the engineering cost provided by the embodiment of the application. The intelligent device is used for executing the method for reversely generating WBS structure and summarizing engineering cost.
Referring to fig. 6, fig. 6 is a schematic structural diagram of an intelligent device according to an embodiment of the present application. As shown in fig. 6, the smart device includes: a memory 61 and a processor 62 connected to the memory 61;
the memory 61 is used for storing a program for implementing at least the method of the foregoing method embodiment;
the processor 62 is used to call and execute the program stored in the memory 61.
The specific implementation method of each step executed by the above-mentioned program may refer to the corresponding content in the foregoing method embodiment, and will not be described herein again.
In addition, the embodiment of the application further provides a storage medium, on which a computer program is stored, which is used for implementing the method of the foregoing method embodiment after being called by a processor.
Through the scheme, based on the standard WBS structure and WBS codes, the WBS structure tree can be reversely generated from the engineering cost list detail, and the corresponding engineering cost list is automatically collected under the WBS nodes, so that various expenses of the WBS nodes can be summarized forward, and the method has great help in guiding the establishment of engineering cost of new projects and the standard analysis of similar projects based on the WBS structure.
It is to be understood that the same or similar parts in the above embodiments may be referred to each other, and that in some embodiments, the same or similar parts in other embodiments may be referred to.
It should be noted that in the description of the present application, the terms "first," "second," and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance. Furthermore, in the description of the present application, unless otherwise indicated, the meaning of "plurality" means at least two.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and further implementations are included within the scope of the preferred embodiment of the present application in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the embodiments of the present application.
It is to be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above-described embodiments, the various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, may be implemented using any one or combination of the following techniques, as is well known in the art: discrete logic circuits having logic gates for implementing logic functions on data signals, application specific integrated circuits having suitable combinational logic gates, programmable Gate Arrays (PGAs), field Programmable Gate Arrays (FPGAs), and the like.
Those of ordinary skill in the art will appreciate that all or a portion of the steps carried out in the method of the above-described embodiments may be implemented by a program to instruct related hardware, where the program may be stored in a computer readable storage medium, and where the program, when executed, includes one or a combination of the steps of the method embodiments.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing module, or each unit may exist alone physically, or two or more units may be integrated in one module. The integrated modules may be implemented in hardware or in software functional modules. The integrated modules may also be stored in a computer readable storage medium if implemented in the form of software functional modules and sold or used as a stand-alone product.
The above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, or the like.
In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
Although embodiments of the present application have been shown and described above, it will be understood that the above embodiments are illustrative and not to be construed as limiting the application, and that variations, modifications, alternatives, and variations may be made to the above embodiments by one of ordinary skill in the art within the scope of the application.