Method and system for synchronously updating P6 progress plan and BIM model

Abstract

The invention relates to the technical field of engineering management informatization, in particular to a method and system for synchronously updating a P6 progress plan and a BIM model. The method comprises the following steps that S1, an engineering project is decomposed according to levels, a project decomposition table is generated, and the project decomposition table comprises a plurality of tasks; allocating job codes to tasks in the project decomposition table according to coding rules of the job codes; s2, generating a P6 progress plan with job codes according to the project decomposition table; s3, inputting the job code into a BIM component primitive in the BIM model, and establishing an association relationship between the P6 progress plan and the BIM model; and S4, importing the progress information of the BIM model into the P6 progress plan according to the association relationship, so as to update the progress of the engineering project. According to the method disclosed by the invention, the uniqueness of the encoding of the primitive component of the BIM model is ensured, the encoding can be correspondingly associated with the operation task in the P6 construction plan, and the problem that the existing P6 construction plan cannot be synchronously updated according to the completion condition of the component in the BIM model is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering management informatization, and more specifically, to a method and system for synchronously updating a P6 schedule and a BIM model. Background Art

[0002] Primavera P6, full name Oracle Primavera P6 (hereinafter referred to as P6), is an enterprise-level project portfolio management software. By integrating the construction schedule management of P6 on BIM and utilizing the powerful schedule management function of P6 to formulate a reasonable schedule plan, through the data inter-access between BIM software and P6, the problem of difficult coordination of construction arrangements due to process intersections can be solved. At present, the P6 + BIM technology adopted in construction schedule control has been studied and applied to a certain extent in building construction projects and highway projects. Through the linkage between the BIM model and P6, the control of schedule management has been realized.

[0003] As a professional project management software, Primavera P6 is powerful and applicable to complex large-scale engineering projects. The software interface contains a large number of options and functional modules, such as Work Breakdown Structure (WBS), resource allocation, risk analysis, schedule management, etc. However, while the software is powerful, it also brings the problem of complex operation.

[0004] Currently, BIM and P6 usually perform data integration through third-party software (such as Navisworks, etc.). These platforms do not directly link the core databases of the two software of BIM and P6, resulting in the necessity of manually exporting or importing data during data exchange. At the same time, the data synchronization of the two software of BIM and P6 is not real-time and requires manual implementation of updates, increasing the workload. Especially when facing project changes, the process of updating the schedule is labor-intensive, time-consuming and error-prone. Project participants often need to spend a lot of time on manual data checking and modification. Summary of the Invention

[0005] In order to solve the problem that BIM and P6 cannot be directly and real-time linked, the present invention proposes a method and system for synchronously updating a P6 schedule and a BIM model, making the inter-access operation of data between the P6 software and the BIM model software in engineering applications simple, efficient and convenient.

[0006] In order to achieve the above-mentioned invention purpose, the present invention provides the following technical solutions:

[0007] A method for synchronously updating a P6 schedule and a BIM model includes the following steps:

[0008] S1, decomposing the engineering project hierarchically to generate a project decomposition table, where the project decomposition table includes several tasks; allocating operation codes to the tasks in the project decomposition table according to the coding rules of operation codes;

[0009] S2. Generate a P6 schedule with job codes according to the project breakdown table;

[0010] S3. Enter the job codes into the BIM component elements in the BIM model to establish the association between the P6 schedule and the BIM model;

[0011] S4. Import the schedule information of the BIM model into the P6 schedule according to the association relationship to update the progress of the engineering project.

[0012] Further, in step S3, the association relationship includes that one P6 job task in the schedule is associated with one or more BIM model components.

[0013] Further, the entering of the job codes into the BIM component elements includes adding a preset suffix after the job codes and binding the job codes with the added suffix to the corresponding BIM component elements, where

[0014] when one P6 job task is associated with one BIM model component, the suffix of the job code of the BIM component element is one; when one P6 job task is associated with multiple BIM model components, the multiple BIM model components have the same job code and different suffixes.

[0015] Further, the coding rule of the task job codes in step S2 includes that the job code is: the first letter of the pinyin of the first character of the project name + the level number of the work breakdown structure + the number; for each additional task, the corresponding number increases by N, where N is a natural number.

[0016] Further, there are multiple levels of work breakdown structures in the job codes, each level of work breakdown structure has a corresponding number, and the bottom level of the work breakdown structure corresponds to the pouring task of each bin of concrete.

[0017] Further, the content of the project breakdown table includes task job codes, task names, start times, completion times, and completion rates.

[0018] Further, step S4 specifically includes the following steps:

[0019] Export the resource allocation table of each job task from the P6 software, and the resource allocation table includes at least job codes, resource names, and budget quantities;

[0020] Export the BIM engineering quantity table from the BIM software, and the BIM engineering quantity table includes at least job codes, material names, and actual consumption quantities;

[0021] Merge the resource allocation table and the BIM engineering quantity table with a script file to obtain the merged table;

[0022] Re-import the merged table into the P6 software to update the number of resources attached to the tasks.

[0023] Based on the same concept, a P6 schedule and BIM model synchronous update system is also proposed, including:

[0024] A project decomposition module, which is used to decompose the engineering project hierarchically to generate a project decomposition table; the project decomposition module is also used to generate a P6 schedule with operation codes according to the project decomposition table;

[0025] A task assignment module, which is used to assign operation codes to the tasks in the project decomposition table according to the coding rules of the operation codes;

[0026] An operation code entry module, which is used to enter the operation codes into the BIM component elements in the BIM model to establish the association relationship between the P6 schedule and the BIM model;

[0027] A generation module, which is used to import the progress information of the BIM model into the P6 schedule according to the association relationship to update the progress of the engineering project.

[0028] Based on the same concept, a computer device is also proposed. The computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the method described in any one of the above is implemented.

[0029] Based on the same concept, a computer-readable storage medium is also proposed. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method described in any one of the above is implemented.

[0030] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0031] A method and system for synchronous update of the P6 schedule and the BIM model provided by the present invention can ensure the uniqueness of the coding of the BIM model element components and can be associated with the operation tasks in the P6 construction plan, solving the problem of the large workload of the P6 plan and model binding initialization in the prior art, and solving the problem that the existing P6 construction plan cannot be synchronously updated according to the completion status of the components in the BIM model. Description of the Drawings

[0032] Figure 1 is a flowchart of a method for synchronous update of a P6 schedule and a BIM model in Embodiment 1;

[0033] Figure 2 is an example of an operation code coding rule in Embodiment 1;

[0034] Figure 3 is the example table of operation tasks and operation codes in Embodiment 1;

[0035] Figure 4 is the first step of exporting the resource allocation table of P6 operation tasks in Embodiment 1;

[0036] Figure 5 is the second step of exporting the resource allocation table of P6 operation tasks in Embodiment 1;

[0037] Figure 6 is the third step of exporting the resource allocation table of P6 operation tasks in Embodiment 1;

[0038] Figure 7 is the fourth step of exporting the resource allocation table of P6 operation tasks in Embodiment 1;

[0039] Figure 8 is the resource allocation table of the left side wall of the 2# lock chamber exported in Embodiment 1;

[0040] Figure 9 is the first step of exporting the engineering quantity of the left side wall of the 2# lock chamber by Revit software in Embodiment 1;

[0041] Figure 10 is the second step of exporting the engineering quantity of the left side wall of the 2# lock chamber by Revit software in Embodiment 1;

[0042] Figure 11 is the detailed list of the engineering quantity of the left side wall of the 2# lock chamber defined by Revit software in Embodiment 1;

[0043] Figure 12 is the interface diagram of exporting the detailed list of the engineering quantity of the left side wall of the 2# lock chamber defined by Revit software in Embodiment 1;

[0044] Figure 13 is the engineering quantity calculation export table of the BIM model (left side wall of the 2# lock chamber) in Embodiment 1;

[0045] Figure 14 is the code schematic diagram of automatically processing and updating the resource allocation table exported by P6 in the python script in Embodiment 1;

[0046] Figure 15 is the interface schematic diagram of updating data by importing the resource allocation table in P6 in Embodiment 1;

[0047] Figure 16 is the structure diagram of a P6 schedule and BIM model synchronous update system in Embodiment 2. Specific implementation manners

[0048] The present invention will be further described in detail below in conjunction with embodiments and specific implementation manners. However, this should not be construed as limiting the scope of the above-mentioned subject matter of the present invention to the following embodiments. All technologies implemented based on the content of the present invention belong to the scope of the present invention.

[0049] Embodiment 1

[0050] A method for synchronously updating a P6 schedule and a BIM model, the flowchart is as Figure 1 shown, and includes the following steps:

[0051] S1. Decompose the engineering project hierarchically to generate a project decomposition table, and the project decomposition table includes several tasks; assign operation codes to the tasks in the project decomposition table according to the coding rules of the operation codes;

[0052] S2. Generate a P6 schedule with operation codes according to the project decomposition table;

[0053] S3. Enter the operation code into the BIM component primitive in the BIM model to establish the association relationship between the P6 schedule and the BIM model;

[0054] S4. Import the schedule information of the BIM model into the P6 schedule according to the association relationship to update the progress of the engineering project.

[0055] S1. Decompose the engineering project hierarchically to generate a project decomposition table

[0056] In project management, using P6 (Primavera P6) to prepare a schedule is a systematic and detailed process. First, define the project objectives and create a project work breakdown structure (WBS), decomposing the project into smaller and more manageable parts; clarify the ultimate goals of the project to ensure that all activities and resources are focused on achieving these goals. The project objectives should include the scope, schedule, quality requirements, and cost limitations of the project, and these objectives need to be agreed upon and supported by key stakeholders. Through the WBS, the project team can more clearly see the various components of the project and ensure that all necessary tasks are included in the plan. In P6, by creating WBS nodes, project activities can be decomposed step by step, and corresponding activity descriptions and codes can be assigned to each node. The P6 software automatically generates a unique WBS code, which is convenient for subsequent management and tracking. Table 1 gives an example of a project decomposition table.

[0057] Table 1 Example of a project decomposition table

[0058]

[0059]

[0060]

[0061] The project breakdown structure table includes task operation codes, task names, start times, completion times, and completion rates. Based on project implementation experience, specific activities and tasks are defined, and detailed information such as names, descriptions, durations, start dates, and completion dates are assigned to each task. Resources and costs can also be allocated to activities to ensure that each activity has a clear responsible person and budget.

[0062] S1. Assign operation codes to the tasks in the project breakdown structure table according to the coding rules of the operation codes

[0063] The coding rules for operation codes are: the first letter of the pinyin of the first character of the project name + the level number of the work breakdown structure (WBS) + the number; for each additional task, the corresponding number increases by N, where N is a natural number. The advantage of doing this is that when new operation tasks need to be added during the project progress, N - 1 new operation tasks and their operation codes can be inserted between two adjacent tasks.

[0064] Furthermore, there are multiple WBS levels in the operation code, each operation code has a corresponding serial number, and the bottom layer of the work breakdown structure level corresponds to the pouring task of each bin of concrete. In this embodiment, the operation tasks are refined to the pouring of each bin of concrete, which is beneficial to improving the calculation accuracy of the engineering quantity and the precise control of the cost.

[0065] As a preferred solution, the WBS level is two levels, and the specific coding rules for the task operation codes are: the first letter of the pinyin of the first character of the project name + the first - level WBS level number + the second - level WBS level number + the number. As a preferred solution, the starting number is 1000. An example of a coding rule for operation codes is as Figure 2 shown.

[0066] Furthermore, Figure 3 is an example table of operation tasks and operation codes. As Figure 3 shown, the operation code interval between every two operation tasks under the left - hand wall of the 2# lock chamber is 10. For operation tasks that require concrete pouring, generally, the completion date of this operation task can be regarded as the concrete pouring date. For example, the completion time of the operation task "C07011010L1 - 2# lock chamber - 15.7m~12.6m" is 2024 - 11 - 08, so it can be considered that this bin of concrete is poured on November 8, 2024. In this way, the plan is refined to the pouring of each bin of concrete, and the compilation of the construction plan is also simplified.

[0067] For each additional task, the job code is incremented by N. Preferably, N = 10, which facilitates the insertion of new job tasks during subsequent plan adjustments. After the project has been implemented for some time, it is necessary to promptly correct the progress plan and adjust and then track the P6 plan. For example, for some process improvement adjustments, the layer height of the concrete placement surface is adjusted from the original 4.5 m / layer to 3 m / layer, and at this time, the job tasks increase accordingly. Only need to add the corresponding job tasks behind it and modify the layer information and job coding again. Since the initial job coding has an interval of 10, 9 tasks can be added between every two job tasks, which greatly improves the fault tolerance rate of the construction plan coding. For the modified plan, for the update of the BIM model coding, only the corresponding local model needs to be changed, without re-coding, which greatly reduces the workload of coding after project changes and ensures the operation of the system.

[0068] S3. In the BIM model, enter the job code into the BIM component element to establish the association relationship between the P6 progress plan and the BIM model.

[0069] Use Revit software to create the BIM model of the project, and the division of the BIM model creation unit components is refined to each bin of concrete. BIM model component coding system: The instance parameters added in Revit software include WBS coding, job coding, Chinese coding, location, etc., and then fill in the corresponding parameters according to the prepared P6 construction progress plan. Since there may be a one-to-many relationship between a P6 job task and the BIM component model, when entering the job code into the BIM component element, in the case of a P6 job task being associated with one BIM model component, the suffix of the job code of the BIM component element is one; in the case of a P6 job task being associated with multiple BIM model components, the multiple BIM model components have the same job code and different suffixes. From another perspective, if a P6 job task has different suffixes corresponding to its job coding, then a P6 job task is associated with multiple BIM model components. Preferably, the examples of the suffixes added after the job code of the BIM component element include: ".001", ".002", etc. ".001", ".002"... represent the multiple BIM models associated with a P6 job task. In this way, it not only ensures the uniqueness of the BIM model element component coding but also can be corresponding and associated with the job tasks in the P6 construction plan.

[0070] S4. Import the completed information of the BIM model into the P6 progress plan according to the association relationship.

[0071] Export the model engineering quantities using the schedule in Revit software. At the same time, export the resource analysis table of the construction plan using Primavera P6 software. Through the keyword matching mapping relationship of the operation codes, update the engineering quantity data in the resource allocation table exported from P6 in Excel. Finally, update this table back into Primavera P6 software, and use functions such as the statistical report in the native system of Primavera P6 software to complete the statistics and analysis of the construction progress.

[0072] Step S4 specifically includes the following steps:

[0073] Export the resource allocation table for each operation task from Primavera P6 software. The resource allocation table includes at least operation code, resource name, and budget quantity.

[0074] Export the BIM engineering quantity table from the BIM software. The BIM engineering quantity table includes at least operation code, material name, and actual consumption.

[0075] Merge the resource allocation table and the BIM engineering quantity table using a script file to obtain a merged table.

[0076] Re-import the merged table into Primavera P6 software to update the quantity of resources attached to the tasks.

[0077] Taking the left wall of the 2# lock chamber of the project ship lock as an example, it further illustrates how to update the quantity of resources associated with the P6 plan through keyword matching. First, define and export the resource allocation table for each operation task in Primavera P6 software, that is, the resource usage associated with each operation task. The exported header fields must include at least three fields: operation code (task_id), resource name (rsrc__rsrc_name), and budget quantity (target_qty). You can also choose to export fields such as operation name, resource code, and operation name for backup in checking the table data. For the detailed operations in Primavera P6 software, see Figures 4 - 7 . Figure 8 is an example of exporting the resource allocation table in P6, which is the resource allocation table exported for the left wall of the 2# lock chamber.

[0078] Export of BIM engineering quantities: First, create a material extraction schedule in the Revit view. Select the generic model for the category (because all ship lock model components are created using the generic model family). Define the fields of the schedule and export it as a.txt file. The schedule fields mainly include "WBS code", "operation code", "Chinese code", "Material: Name", "Material: Volume", "Material: Note", etc. For the "Material: Volume" field, select "Calculate total" in the "Display conditional formatting on drawing (s)" format. For the detailed steps of exporting BIM engineering quantities using Revit software, see Figures 9 - 11 , and the exported detailed schedule of the BIM model engineering quantity calculation is as shown in Figure 12 as follows.Figure 13 The BIM model engineering quantity calculation form of the left side wall of the No. 2 lock chamber is given.

[0079] So far, two Excel tables of resource allocation and BIM engineering quantity exported by P6 have been obtained respectively. The two are combined into a file named "Resource Allocation for the Left Side Wall of the No. 2 Lock Chamber.elsx", and Python scripts are written to integrate and update the data and save the file. The schematic diagram of the code for automatically processing and updating the resource allocation table exported by P6 in the Python script is as Figure 14 shown. Finally, the excel file obtained by processing and saving with the Pyhton script is re-imported into the P6 software to update the quantity of resources attached to the job tasks. The schematic diagram of the interface for updating data by importing the resource allocation table in P6 is as Figure 15 shown.

[0080] Embodiment 2

[0081] A P6 schedule and BIM model synchronous update system, the schematic diagram of the system structure is as Figure 16 shown, including:

[0082] A project decomposition module, used to decompose the engineering project according to levels to generate a project decomposition table; the project decomposition module is also used to generate a P6 schedule with job codes according to the project decomposition table;

[0083] A task allocation module, used to allocate job codes to tasks in the project decomposition table according to the coding rules of job codes;

[0084] A job code entry module, used to enter job codes into BIM component graphics in the BIM model to establish the association between the P6 schedule and the BIM model;

[0085] A generation module, used to import the schedule information of the BIM model into the P6 schedule according to the association relationship to update the progress of the engineering project.

[0086] A computer device, the computer device includes a memory, a processor, and a computer program stored in the memory and operable on the processor. When the processor executes the computer program, it implements the method for synchronously updating a P6 schedule and a BIM model according to any one of Embodiment 1.

[0087] It should be understood that when each module of a P6 schedule and BIM model synchronous update system provided in the above embodiments performs data synchronous update, only the division of each functional module in the above description content is used as an example. In actual application, the above functions can be assigned to different functional modules according to needs, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above.

[0088] Each functional module in the above embodiments can be integrated in a processing unit, or each unit can exist physically alone, or two or more units can be integrated in one unit. The above integrated unit can be implemented in the form of hardware or in the form of a software functional unit. In addition, the specific names of each functional unit and module are only for the convenience of mutual distinction and do not limit the protection scope of the embodiments of the present application.

[0089] Based on the same inventive concept, the embodiments of the present application further provide a computer device, which may include a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the method for synchronously updating a P6 schedule and a BIM model as described in the above description content.

[0090] Based on the same inventive concept, the embodiments of the present application further provide a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the method for synchronously updating a P6 schedule and a BIM model as described in the above description content.

[0091] In summary, the solutions or descriptions presented in the specific embodiments and drawings of the present invention are not intended to limit the scope of the claims, but merely represent selected embodiments / cases to help those skilled in the art understand the related innovative solutions. Based on these embodiments, all other equivalent or parallel embodiments obtained by those skilled in the art without creative efforts fall within the scope of protection required by the present invention.

Claims

1. A method for synchronous update of P6 schedule and BIM model, characterized in that, It includes the following steps: S1. Decompose the engineering project hierarchically to generate a project decomposition table, where the project decomposition table includes several tasks; assign operation codes to the tasks in the project decomposition table according to the coding rules of the operation codes; S2. Generate a P6 schedule with operation codes according to the project decomposition table; S3. Enter the operation codes into the BIM component elements in the BIM model to establish the association between the P6 schedule and the BIM model; S4. Import the schedule information of the BIM model into the P6 schedule according to the association relationship to update the progress of the engineering project.

2. The method for synchronously updating a P6 schedule and a BIM model according to claim 1, characterized in that, In step S3, the association relationship includes that one P6 operation task in the schedule is associated with one or more BIM model components.

3. The method for synchronously updating a P6 schedule and a BIM model according to claim 2, wherein The entering of the operation codes into the BIM component elements includes adding a preset suffix after the operation codes and binding the operation codes with the added suffix to the corresponding BIM component elements, where when one P6 operation task is associated with one BIM model component, the suffix of the operation code of the BIM component element is one; when one P6 operation task is associated with multiple BIM model components, the multiple BIM model components have the same operation code and different suffixes.

4. A method for synchronously updating a P6 schedule and a BIM model according to claim 1, characterized in that The task operation code coding rules in step S2 include that the operation code is: the first letter of the pinyin of the first character of the project name + the level number of the work breakdown structure + the number; for each additional task, the corresponding number increases by N, where N is a natural number.

5. The method for synchronously updating the P6 schedule and the BIM model according to claim 4, wherein, There are multiple levels of the work breakdown structure in the operation code, each level of the work breakdown structure has a corresponding number, and the bottom level of the work breakdown structure corresponds to the pouring task of each bin of concrete.

6. The method for synchronously updating the P6 schedule and the BIM model according to claim 1, characterized in that, The content of the project decomposition table includes task operation codes, task names, start times, completion times, and completion rates.

7. A method for synchronously updating a P6 schedule and a BIM model according to claim 1, characterized in that, Step S4 specifically includes the following steps: Export the resource allocation table of each operation task from the P6 software, where the resource allocation table includes at least operation codes, resource names, and budget quantities; Export the BIM engineering quantity table from the BIM software, where the BIM engineering quantity table includes at least operation codes, material names, and actual consumption quantities; Merge the resource allocation table and the BIM engineering quantity table with a script file to obtain a merged table; Re-import the merged table into the P6 software to update the quantity of resources attached to the tasks.

8. A P6 schedule and BIM model synchronous update system, characterized in that, It includes: A project decomposition module for decomposing the engineering project hierarchically to generate a project decomposition table; The project decomposition module is also used to generate a P6 schedule with operation codes according to the project decomposition table; A task assignment module for assigning operation codes to the tasks in the project decomposition table according to the coding rules of the operation codes; An operation code entry module for entering the operation codes into the BIM component elements in the BIM model to establish the association between the P6 schedule and the BIM model; A generation module for importing the schedule information of the BIM model into the P6 schedule according to the association relationship to update the progress of the engineering project.

9. A computer device, characterized in that, The computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the method described in any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program. When the computer program is executed by a processor, the method described in any one of claims 1 to 7 is implemented.

Images