Progress analogue simulation method and device in BIM model

Abstract

The invention relates to the technical field of engineering management informatization, in particular to a progress simulation method and device in a BIM model. The method comprises the following steps of exporting construction progress plans of different version numbers through P6 software; converting the format of the exported construction progress plan and then importing the construction progress plan into UE; binding the construction progress plan imported into the UE with the BIM model; and carrying out construction progress simulation by calling the blueprint function library. According to the progress simulation method and device in the BIM model, a simulation model of the project progress is directly achieved in BIM software, the simulation efficiency is improved, verification can be conveniently conducted in advance, the project progress can be optimized in advance, and the cost is saved.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering management informatization, and in particular to a method and device for schedule simulation in a BIM model. Background Art

[0002] In the existing engineering informatization management process, the Primavera P6 (hereinafter referred to as P6) software is usually used to implement project schedule management. At the same time, the BIM model software is used for the integration and visualization management of project information.

[0003] In actual engineering applications, the project is not directly carried out according to the schedule plan of the P6 software. Instead, it is necessary to perform simulations on the BIM software platform according to the preset schedule plan to discover whether there are any problems during the simulation process, and then optimize and adjust the schedule plan.

[0004] In the prior art, the simulation according to the preset schedule plan cannot be achieved on the P6 software or the BIM software. Instead, it is necessary to export the data on the P6 software and the BIM software to a third-party software platform to achieve the simulation. The use of multiple software will bring higher costs to the project. The steps of importing and exporting data are cumbersome, and errors are likely to occur during the import and export process. The timeliness of the simulation will also be affected. Summary of the Invention

[0005] In order to solve the problem of cumbersome simulation process, on the basis of establishing the association between the BIM model and the P6 plan, a simulation function is built in, and a method and device for schedule simulation in the BIM model are proposed to directly implement the engineering schedule simulation model in the BIM software.

[0006] In order to achieve the above invention purpose, the present invention provides the following technical solutions: A method for schedule simulation in a BIM model, comprising the following steps: Export construction schedule plans with different version numbers through the P6 software; Convert the format of the exported construction schedule plan and then import it into the UE; Bind the construction schedule plan imported into the UE to the BIM model; Perform construction schedule simulation by calling the blueprint function library.

[0007] Further, the construction schedule is reflected by changing the color of the components in the model.

[0008] Further, the converted format of the exported construction schedule plan includes the xlsx format.

[0009] Further, binding the construction progress plan imported into the UE to the BIM model includes binding the construction progress plan to the components in the BIM model through job codes.

[0010] Further, specifically binding the construction progress plan imported into the UE to the BIM model includes: Correspondingly binding the WBS codes in the construction progress plan to the components in the project progress; In the BIM software, copy the WBS codes generated in the P6 software to the corresponding BIM model components to realize the corresponding association between the BIM model components and the job tasks in the P6 construction plan.

[0011] Further, the job code coding rule is: the first letter of the pinyin of the first character of the unit project + the WBS level serial number + the number; for each additional task, the number in the job code increases by N, where N is a natural number.

[0012] Further, converting the format of the exported construction progress plan and then importing it into the UE includes: converting the format of the construction progress plan and importing the data into the UE; the specific steps for converting the format of the construction progress plan include: installing the dependency library; parsing the structure of the XER file and extracting the key tables; extracting other tables; extracting the key fields; processing the date format.

[0013] Based on the same concept, a progress simulation system in a BIM model is also proposed, including a data collection module, a format conversion module, an association binding module, and a simulation module; The data collection module is used to receive the construction progress plans exported from the P6 software with different version numbers; The format conversion module is used to convert the format of the exported construction progress plan and then import it into the UE; The association binding module is used to bind the construction progress plan imported into the UE to the BIM model; The simulation module is used to call the blueprint function library for construction progress simulation.

[0014] 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, it implements the progress simulation method in the BIM model as described in any one of the above.

[0015] 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, it implements the progress simulation method in the BIM model as described in any one of the above.

[0016] Compared with the prior art, the beneficial effects of the present invention are as follows: Based on the establishment of the association between the BIM model and the P6 plan, the present invention adds a simulation function, and proposes a method and device for schedule simulation in the BIM model, improving the efficiency of simulation, facilitating pre-verification, optimizing the project schedule in advance, and saving costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 is a flowchart of the method for schedule simulation in the BIM model in Embodiment 1; Figure 2 is a schematic diagram of the script code for installing dependent libraries in Embodiment 1; Figure 3 is a schematic diagram of the script code for parsing its structure and extracting key tables in Embodiment 1; Figure 4 is a schematic diagram of the script code for extracting other tables in Embodiment 1; Figure 5 is a schematic diagram of the script code for screening key columns in Embodiment 1; Figure 6 is a schematic diagram of the script code for date conversion in Embodiment 1; Figure 7 is a schematic diagram of the conversion code for converting data in xlsx format to JSON format in Embodiment 1; Figure 8 is an example of a job code encoding in Embodiment 1; Figure 9 is a schematic diagram of the job encoding of the job task taking the left side wall under the 2# lock chamber as an example in Embodiment 1; Figure 10 is a flowchart of the construction schedule simulation by calling the blueprint function library in Embodiment 1; Figure 11 is a schematic diagram of the structure of a schedule simulation system in the BIM model in Embodiment 2. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0018] The present invention will be further described in detail below with reference to specific embodiments. 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.

[0019] Unless otherwise specified, in the description of specific embodiments of the present invention, expressions of terms indicating orientation or positional relationships such as "upper", "lower", "left", "right", "center", "inner", "outer", etc. are all based on the orientation or positional relationships shown in the drawings, or the orientation or positional relationships when the invention product / device / installation is commonly used. These terms of orientation or positional relationships are only for the convenience of describing the solution of the present invention or simplifying the description in specific embodiments, facilitating technicians to quickly understand the solution, rather than indicating or implying that a specific device / component / element must have a specific orientation or be constructed and operated in a specific positional relationship. Therefore, it should not be construed as a limitation to the present invention.

[0020] In addition, when expressions such as "first", "second", "third", etc. appear in the terms, they are only used to distinguish the descriptions of the same or similar components, and should not be construed as emphasizing or implying the relative importance of specific components.

[0021] In addition, in the description of embodiments of the present invention, "several", "multiple", "a number of" represent at least 2. It can be any situation such as 2, 3, 4, 5, 6, 7, 8, 9, etc., and even can be a situation exceeding 9.

[0022] In addition, in the description of the technical solution of the present invention, unless otherwise clearly specified / defined / restricted, when terms such as "set", "installed", "connected", "linked", "provided with", "laid", "arranged" appear, they should be understood in a broad sense. For example, it can be a fixed connection, a detachable connection, or an integral connection. It can be connection means commonly used in the art such as welding, riveting, bolting, threaded connection, etc. This kind of connection can be a mechanical connection, an electrical connection or a communication connection; it can be directly connected, or indirectly connected through an intermediate medium, and can be the communication inside two components.

[0023] Embodiment 1 The method for progress simulation in the BIM model, the flowchart is as Figure 1 shown, and includes the following steps: Export the construction progress plans with different version numbers through the P6 software; After converting the format of the exported construction progress plan, import it into UE; Bind the construction progress plan imported into UE with the BIM model; Conduct construction progress simulation by calling the blueprint function library.

[0024] Furthermore, in Primavera P6 Professional 6.0, exporting the construction progress plans with different version numbers (such as the baseline plan, updated version, etc.) can be achieved through the following steps: Method 1: Export through the "Export Project" function 1. Open the project. Enter P6 and open a project that contains multiple versions (such as containing the Baseline plan and the Current Plan).

[0025] 2. Navigate to the export function. Click on the top menu bar and select File→Export→Project (or select specific job data) in sequence.

[0026] 3. Select the export format. Supported formats include: XER (specific to P6), XML, Excel, etc. The XER format is recommended as it can preserve the complete project data (including the baseline plan).

[0027] 4. Version selection. In the export interface, check "Include all baselines" or manually select a specific version. If you need to export the current plan, simply export the project (without checking the baseline option). Save the file as different versions, and distinguish the different versions by naming, for example: ProjectName_Baseline_v1.xer, ProjectName_Current_20240328.xer.

[0028] Method 2: Export through the "Maintain Baselines" function 1. Set the baseline plan. In the project window, click Project→Maintain Baselines in sequence. Select the baseline version to be exported and click Export to directly save it as an XER file.

[0029] 2. Export the current plan. Directly export the current progress through File→Export→Project.

[0030] Method 3: Distinguish versions through reports 1. Generate a progress report. Select Reports→Reports in sequence and select or customize a progress plan report (such as a Gantt chart, job list). In the report settings, select a specific version through Filter: if it is the baseline plan, filter "Baseline Projects"; if it is the current plan, filter "Current Projects".

[0031] 2. Export the report. After generating the report, export it as PDF or Excel format, and indicate the version number in the file name (such as ScheduleReport_Baseline.pdf).

[0032] When exporting the progress plan, the following points need to be considered: 1. Clear version identification. When naming the baseline plan in P6, indicate the date or version number (such as Baseline_2024-01) to avoid confusion. 2. XER format compatibility. XER files can completely retain P6 data (including WBS, relationships, resources, etc.) and are suitable for cross-version migration. Excel / PDF is more suitable for viewing but may lose some data. 3. Low-version compatibility. XER files exported by P6 6.0 may not be directly imported into higher versions (such as P6 8.0+), and need to be tested and verified.

[0033] After converting the format of the exported construction progress plan, import it into UE, which includes two steps: converting the format of the construction progress plan and importing the data into UE.

[0034] For converting the format of the construction progress plan, it is because the final progress simulation needs to be rendered in the UE5 engine and displayed in the BIM software. Therefore, the format needs to match the requirements of UE5. Preferably, convert the exported progress plan to the xlsx format.

[0035] Specifically, converting the XER file of Primavera P6 to the Excel (.xlsx) format can be achieved through a script file: The first step is to install the dependency libraries. Ensure that pandas (data processing), openpyxl (generating Excel), and sqlite3 (XER is essentially an SQLite database) have been installed. The script code for installing the dependency libraries is shown as Figure 2 shown.

[0036] The second step is to parse the structure of the XER file and extract the key tables (such as TASK, PROJECT). The XER file is a text-format database dump file, and its structure needs to be parsed and the key tables need to be extracted. The script code is shown as Figure 3 shown.

[0037] The third step is to extract more tables (such as PROJECT, TASK, TASKPRED, etc.). The script code is shown as Figure 4 shown.

[0038] The fourth step is to extract the key fields. The task table in ER usually contains: task_id, task_name, start_date, end_date, status. The script code for filtering the key columns is shown as Figure 5 shown.

[0039] The fifth step is to process the date format. The XER date may be in numerical format (such as 2459204.5) and needs to be converted into a directly recognizable form. The script code for date conversion is shown as Figure 6as shown

[0040] Save the script file with the converted format, and then the format conversion can continue.

[0041] UE is Unreal Engine, which is mainly a game engine. Unreal Engine is also widely used in architectural visualization because of its powerful graphics rendering capabilities. It supports virtual reality (VR) and augmented reality (AR), and can create immersive experiences, which is suitable for high-quality architectural displays and client demonstrations. Unreal Engine supports multiple input methods, including mouse, keyboard, touch, and gamepad, etc., and can receive various operation instructions from users. Unreal Engine provides a variety of optimization tools and technologies, such as LOD (Level of Detail) and dynamic lighting adjustment, which can effectively reduce resource occupancy, thereby improving performance and adapting to different hardware configurations. Unreal Engine performs excellently in rendering quality, supports realistic light and shadow effects, high dynamic range (HDR), and physically based rendering (PBR), and can achieve very detailed and realistic model displays. It also supports dynamic detail levels, allowing the display details of the model to be adjusted according to the viewing distance and user needs. In the present invention, the UE5 game engine is used as a three-dimensional platform for convenient application research, and the interactive scene model is first rendered on the GPU cloud server in the form of pixel streaming to complete a realistic picture and then streamed to the client browser for access, greatly reducing the requirements for the performance of the visitor's computer device. The DataSmith workflow mode + Cesium plug-in are used to load the 3D Tile real scene model to jointly complete the construction of the scene. The revit BIM model is exported as a.udatasmith format file through the DataSmith plug-in and then converted and imported into UE5 for scene construction.

[0042] There are three methods to import the data in the xlsx format of the construction progress plan into UE5. The screenshot methods are shown in Table 1: Table 1 Three methods to import the data in the.xlsx format of the construction progress plan into UE5

[0043] Preferably, the third method is adopted in the present invention, that is, using the blueprint tool and the Unreal Engine plug-in. First, convert the data in the xlsx format into an intermediate file in the JSON format. The conversion code is as Figure 7As shown below. Secondly, UE5 is used to read the intermediate file in JSON format, specifically including: using the Json Utilities plugin to parse data, loading the JSON file and processing it in the blueprint. During the conversion process, it is necessary to ensure that the column names in the.Xlsx format data are consistent with the UE5 structure (USTRUCT). In addition, UE5 does not directly support Excel dates, which can be converted to strings or Unix timestamps. For large xlsx formats, it is recommended to import in chunks or use asynchronous loading.

[0044] Furthermore, bind the construction schedule imported into UE to the BIM model. This step includes binding the construction schedule to the components in the BIM model through job codes.

[0045] First, bind the WBS code in the construction schedule to the corresponding components in the project progress.

[0046] In project management, using P6 (Primavera P6) to prepare the schedule is a systematic and detailed process. First, define the project objectives and create a Work Breakdown Structure (WBS) for the project, breaking 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, the project activities can be broken down level by level, and corresponding activity descriptions and codes can be assigned to each node. The P6 software will automatically generate a unique WBS code.

[0047] Furthermore, the coding rule for job codes is: the first letter of the pinyin of the first character of the unit project + the WBS level number + the number; for each additional task, the number in the job code increases by N, where N is a natural number. The advantage of doing this is that when new job tasks need to be added during the project progress, N new job tasks and their job codes can be inserted between two adjacent tasks.

[0048] Furthermore, there are multiple WBS levels in the job code, each job code has a corresponding serial number, and the bottom WBS level is the pouring of each bin of concrete. In this embodiment, the job tasks are accurately defined to the pouring of each bin of concrete, which is beneficial to improving the calculation of the engineering quantity and the precise control of the cost.

[0049] As a preferred solution, the WBS hierarchy has two levels. The specific coding rule for task operation codes is as follows: the capitalized first letter of the pinyin of the first character of the unit project + the serial number of the first-level WBS hierarchy + the serial number of the second-level WBS hierarchy + the number. As a preferred solution, the starting number is 1000. An example of the coding of an operation code is as Figure 8 shown.

[0050] As Figure 9 shown, the operation code interval for every two operation tasks under the left wall of the 2# lock chamber is 10. For operation tasks that require concrete pouring, the completion date of this operation task can generally be regarded as the concrete pouring date. For example, the completion time of the operation task "C07011010 L1-2# lock chamber-15.7m~12.6m" is November 8, 2024. We can consider that this batch of concrete is poured on November 8, 2024. In this way, the plan is refined to the pouring of each batch of concrete, and the compilation of the construction plan is also simplified.

[0051] For each additional task, the operation code increases by N. Preferably, N = 10, which is convenient for inserting new operation tasks during subsequent plan adjustments. After the project has been implemented for some time, it is necessary to correct the progress plan in a timely manner and adjust and re-track the P6 plan. For example, for some adjustments in process improvement, the layered height of the concrete placement surface is adjusted from the original 4.5m / layer to 3m / layer, and the operation tasks will increase accordingly. Only need to add the corresponding operation tasks behind it and modify the layered information and operation codes again. Since the initial operation codes are all at an interval of 10, 9 tasks can be added between every two operation tasks, which greatly improves the error tolerance rate of the construction plan coding. For the modified plan, the update of the BIM model coding only needs to modify the corresponding local model, which greatly reduces the coding workload and ensures the operation of the system.

[0052] Secondly, in the BIM software, copy the WBS code generated in the P6 software to the corresponding BIM model components to realize the corresponding association between the BIM model components and the operation tasks in the P6 construction plan.

[0053] The Revit software is used to create a BIM model for the project, and the division of the unit components in the BIM model is refined to each bin of concrete. BIM model component coding system: The instance parameters added in the Revit software include WBS coding, operation coding, Chinese coding, location, etc., and then the corresponding parameters are filled in according to the prepared P6 construction schedule. Since there may be a one-to-many relationship between a P6 operation task and the BIM component model, when entering the operation code into the BIM component graphic element, a preset suffix is added after the operation coding. If there are different suffixes for the operation coding corresponding to a P6 operation task, then a P6 operation task is associated with multiple BIM model components. Preferably, the suffix added after the operation coding when entering the operation coding parameter of the BIM component graphic element is: ".001", ".002", etc., which represent multiple BIM models associated with a P6 operation task. In this way, the uniqueness of the BIM model graphic element component coding is ensured, and it can be corresponding and associated with the operation tasks in the P6 construction plan one by one.

[0054] Furthermore, the construction schedule simulation is carried out by calling the blueprint function library, and the flow chart is as Figure 10 shown: The first step is to export the construction plan by the P6 software; the second step is to import the construction plan in the xlsx format through the plug-in DirectExcel and save it in the UE; the third step is to bind each BIM model to the corresponding construction task by the mapping method in the UE and save it; the fourth step is to call different versions of the plan to carry out the construction schedule simulation.

[0055] Furthermore, the construction schedule is reflected by changing the color of the components in the model.

[0056] Embodiment 2 A progress simulation system 50 in a BIM model, and the structural schematic diagram of the system is as Figure 11 shown, including a data collection module, a format conversion module, an association binding module and a simulation module; The data collection module 51 is used to receive the construction schedule plans with different version numbers exported by the P6 software; The format conversion module 52 is used to convert the format of the exported construction schedule plan and then import it into the UE; The association binding module 53 is used to bind the construction schedule plan imported into the UE with the BIM model; The simulation module 54 is used to call the blueprint function library to carry out the construction schedule simulation.

[0057] A computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, it implements the progress simulation method in the BIM model according to any one of Embodiment 1.

[0058] It should be understood that when each module of the progress simulation system in the BIM model provided in the above embodiments performs data synchronization and update, only the division of each functional module in the above description content is used as an example. In actual applications, 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.

[0059] Each functional module in the above embodiments can be integrated into a processing unit, or each unit can exist physically alone, or two or more units can be integrated into 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.

[0060] Based on the same inventive concept, the embodiments of the present application also provide a computer-readable storage medium storing a computer program, and when the computer program is executed by a processor, it implements the progress simulation method in the BIM model as described in the above description content.

[0061] 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 claimed protection, but merely represent selected embodiments / cases to help those skilled in the art understand the relevant innovative solutions. Based on these embodiments, all other equivalent or parallel embodiments obtained by those skilled in the art without creative efforts belong to the scope of protection claimed by the present invention.

Claims

1. A progress simulation method in a BIM model, characterized in that, Including the following steps: Export the construction progress plans of different version numbers through P6 software; After converting the format of the exported construction progress plan, import it into UE; Bind the construction progress plan imported into UE to the BIM model; Conduct construction progress simulation by calling the blueprint function library.

2. The progress simulation method in the BIM model according to claim 1, characterized in that, Reflect the construction progress by changing the colors of the components in the model.

3. The progress simulation method in the BIM model according to claim 1, wherein The converted format of the exported construction progress plan includes the xlsx format.

4. The progress simulation method in the BIM model according to claim 1, wherein The binding of the construction progress plan imported into UE to the BIM model includes binding the construction progress plan to the components in the BIM model through job codes.

5. The progress simulation method in the BIM model according to claim 4, characterized in that, The specific process of binding the construction progress plan imported into UE to the BIM model includes: Correspondingly bind the WBS codes in the construction progress plan to the components in the project progress; In the BIM software, copy the WBS codes generated in the P6 software to the corresponding BIM model components to realize the corresponding association between the BIM model components and the job tasks in the P6 construction plan.

6. The progress simulation method in the BIM model according to claim 5, characterized in that, The coding rule of the job code is: the first letter of the pinyin of the first character of the unit project + the WBS level serial number + the number; for each additional task, the number in the job code increases by N, where N is a natural number.

7. The progress simulation method in the BIM model according to claim 1, characterized in that, The step of converting the format of the exported construction progress plan and then importing it into UE includes: converting the format of the construction progress plan and importing the data into UE; the specific steps of converting the format of the construction progress plan include: installing the dependency library; parsing the structure of the XER file and extracting the key tables; extracting other tables; extracting the key fields; processing the date format.

8. A progress simulation system in a BIM model, characterized in that, Including a data collection module, a format conversion module, an association binding module, and a simulation module; The data collection module is used to receive the construction progress plans of different version numbers exported by the P6 software; The format conversion module is used to convert the format of the exported construction progress plan and then import it into UE; The association binding module is used to bind the construction progress plan imported into UE to the BIM model; The simulation module is used to conduct construction progress simulation by calling the blueprint function library.

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, it implements the method for progress simulation in the BIM model as described in any one of claims 1 to 7.

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 the processor, it implements the method for progress simulation in the BIM model as described in any one of claims 1 to 7.

Images