Graphical display method and system for ship assembly site plan arrangement

Abstract

The invention provides a graphical display method and system for a ship total group site plan arrangement, and the method comprises the steps: building a new worksheet, obtaining the data of a ship total group site and a ship total group plan, and constructing a ship total group site model based on the data. Based on the Excel-VBA module, the actual layout and the model of the total ship group site are displayed in a unified mode, the plan arrangement of the total ship group site can be displayed to a user in a visual and vivid mode, the site utilization condition can be visually known, the site layout is optimized, and the site utilization efficiency and the operation efficiency are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of shipbuilding, and particularly to a graphical display method and system for the overall assembly site plan arrangement of ships. Background Art

[0002] In the process of shipbuilding, the arrangement of the overall assembly site is directly related to the shipbuilding plan, and may involve multiple ship types and multiple production lines. To achieve continuous, balanced and stable production and construction, it is necessary to make overall balance around production requirements and site resources, and according to the requirements of the production plan of the products under construction, make use of the limited overall assembly site to achieve lane separation in space and order in time. The plan arrangement of the overall assembly site is of great significance for improving production efficiency, ensuring ship quality and reducing costs. However, there are many deficiencies in the existing ship overall assembly site plan arrangement methods, such as low site utilization rate, unsmooth production process, unreasonable resource allocation, etc., resulting in an extended shipbuilding cycle and increased costs.

[0003] In the process of ship overall assembly, the rationality and visualization of the site plan arrangement are crucial for improving production efficiency, reducing costs and ensuring project progress. However, the traditional plan arrangement method relies on tables and text descriptions, lacks intuitive graphical display, has insufficient visibility, and is difficult to clearly present the spatial distribution and time arrangement of site resources; it is unable to flexibly adjust the position and time plan of the sub-assembly, has poor interactivity, and is difficult to real-time associate time and space information; in addition, the low site utilization rate and unreasonable resource allocation lead to an unsmooth production process and an extended manufacturing cycle. Summary of the Invention

[0004] In view of the problems existing in the site plan arrangement in the above-mentioned prior art, the present application provides a graphical display method for the overall assembly site plan arrangement of ships, specifically including:

[0005] Create a new worksheet, and the worksheet at least includes a site layout worksheet, a site plan worksheet and an overall assembly plan worksheet;

[0006] Obtain the overall assembly site data of the ship, and store the overall assembly site data of the ship in the site layout worksheet;

[0007] Merge all the cells in the site plan worksheet to form a canvas;

[0008] Based on the overall assembly site data of the ship, use the VBA module to construct an overall assembly site model of the ship in the canvas;

[0009] Obtain the overall assembly plan of the ship, and store the overall assembly plan of the ship in the overall assembly plan worksheet;

[0010] Add ship sub-assemblies to the overall assembly site model based on the overall assembly plan of the ship.

[0011] Optionally, it further includes dividing the general assembly site of the ship into areas.

[0012] Optionally, it further includes preprocessing the data of the general assembly site of the ship.

[0013] Optionally, constructing the general assembly site model of the ship includes: drawing a rectangular area representing the general assembly site of the ship; setting the relevant information of the general assembly site of the ship in the rectangular area.

[0014] Optionally, adding a ship sub-assembly to the general assembly site model includes: drawing a rectangular area representing the ship sub-assembly; setting the relevant information of the ship sub-assembly in the rectangular area.

[0015] Optionally, the general assembly site model of the ship at least includes: site initialization, stage date, addition and modification, movement, deletion and erection, and finding sub-assembly function buttons.

[0016] Optionally, the general assembly plan of the ship includes project number, sub-assembly number, general assembly start date, general assembly end date, and erection start date.

[0017] Optionally, it further includes managers inputting query conditions to view the general assembly site plan arrangement under the corresponding conditions.

[0018] On the other hand, the present invention provides a graphical display system for the general assembly site plan arrangement of a ship, including:

[0019] A data storage module for storing the data of the general assembly site of the ship and the general assembly plan of the ship;

[0020] A model construction module for constructing a general assembly site model of the ship according to the data of the general assembly site of the ship and the general assembly plan of the ship;

[0021] A user interaction module for providing a graphical operation interface and displaying the general assembly site model of the ship.

[0022] Optionally, the general assembly site model of the ship includes:

[0023] A sub-assembly addition module for generating a sub-assembly graph at a specified position based on user input;

[0024] A sub-assembly displacement module for moving the sub-assembly graph;

[0025] A screening module, including a sub-assembly finding module, a refresh date module, and a stage date module, for displaying the general assembly site model of the ship according to user screening conditions;

[0026] A region jump module provided with jump buttons to realize the switching of the display region.

[0027] As described above, the graphical display method and system for the ship erection site plan arrangement provided by the present invention have at least the following beneficial technical effects:

[0028] Based on the Excel-VBA module, the actual and model of the erection site are graphically unifiedly displayed, which can intuitively display the site utilization situation, enable the management personnel to quickly master the current situation of the site, and provide a basis for decision-making; secondly, the site layout is optimized, enabling the management personnel to directly adjust the site layout according to actual needs, realizing more reasonable space utilization and resource allocation, improving the site utilization efficiency, and avoiding resource idleness. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 It shows a flowchart of the graphical display method for the ship erection site plan arrangement provided in the first embodiment.

[0030] Figure 2 It shows a platform layout display diagram of the ship erection site provided in the first embodiment.

[0031] Figure 3 It shows a display diagram of adding a block based on the position.

[0032] Figure 4 It shows a display diagram of adding a block to the right based on the block.

[0033] Figure 5 It shows a display diagram of adding a block downward based on the block.

[0034] Figure 6 It shows a display diagram of moving a block based on the position.

[0035] Figure 7 It shows a display diagram of moving a block to the left.

[0036] Figure 8 It shows a display diagram of the function of searching for a block.

[0037] Figure 9 It shows a display diagram of the function of refreshing the date.

[0038] Figure 10 It shows a display diagram of the function of the stage date.

[0039] Figure 11 It shows a display diagram of the function of area jump. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0040] The following uses specific specific examples to illustrate the implementation manners of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific implementation manners. Various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention.

[0041] It should be noted that the illustrations provided in this embodiment only illustrate the basic concept of the present invention in a schematic manner. Although only the components related to the present invention are shown in the illustrations and are not drawn according to the number, shape, and size of the components in actual implementation, the forms, quantities, positional relationships, and proportions of the various components in actual implementation can be arbitrarily changed on the premise of implementing the technical solution of the present invention, and the component layout form may also be more complex. It should be noted that the names such as "site layout", "site plan", and "general assembly plan" in this embodiment can be changed according to actual needs and cannot be used to limit the scope of the present invention.

[0042] Embodiment 1

[0043] This embodiment provides a graphical display method for the ship general assembly site plan arrangement, as Figure 1 shown, which shows the flowchart of the graphical display method for the ship general assembly site plan arrangement provided by this embodiment; specifically includes the following steps:

[0044] S1: Create a new worksheet, and the worksheet at least includes a site layout worksheet, a site plan worksheet, and a general assembly plan worksheet;

[0045] S2: Obtain the ship general assembly site data and store the ship general assembly site data in the site layout worksheet;

[0046] S3: Merge all cells in the site plan worksheet to form a canvas;

[0047] S4: Based on the ship general assembly site data, use the VBA module to construct a ship general assembly site model in the canvas;

[0048] S5: Obtain the ship general assembly plan and store the ship general assembly plan in the general assembly plan worksheet;

[0049] S6: Add ship sections to the ship general assembly site model based on the ship general assembly plan.

[0050] Specifically, S1: Create a new worksheet, and the worksheet at least includes a site layout worksheet, a site plan worksheet, and a general assembly plan worksheet.

[0051] Specifically, create an Excel worksheet. In this embodiment, three worksheets are created, named the site layout worksheet, the site plan worksheet, and the general assembly plan worksheet respectively, for storing site data. Particularly, the number of worksheets and their names can be changed according to actual needs and cannot be used to limit the scope of the present invention.

[0052] S2: Obtain the ship general assembly site data and store the ship general assembly site data in the site layout worksheet.

[0053] Specifically, obtaining the actual general assembly site data includes methods such as on-site measurement, exporting historical site layout data from a database (enterprise production management database), and manual data entry. Optionally, the general assembly site can also be divided into regions to improve the utilization rate of the assembly site, optimize resource allocation, and production plans. Specifically, the ship general assembly site data includes: site data such as the ship general assembly site size, regional division size, and name. Optionally, preprocess the obtained general assembly site data, and the preprocessing content includes data cleaning (eliminating invalid or duplicate data), supplementation, and data standardization (unifying units), etc.

[0054] Convert the obtained general assembly site data into tabular data, specifically including: site graphic number (each area number, 6-1, 6-2), distance from the left (the distance between the left boundary of the graphic and the left side of the Excel canvas), distance from the top (the distance between the upper boundary of the graphic and the upper side of the Excel canvas), width, height, dimension annotation information, and store the ship general assembly site data in the site layout worksheet.

[0055] Specifically, in this embodiment, take the general assembly site plan arrangement of Platform 6 as an example. First, obtain the relevant data of the general assembly site of Platform 6 and store the relevant data of the general assembly site of Platform 6 in the site layout worksheet. As shown in Table 1-4 below, it shows part of the data of the general assembly site of Platform 6.

[0056] Table 1 Partial Data of the General Assembly Site of Platform 6

[0057]

[0058]

[0059] As shown in Table 1, it shows the ship general assembly site data provided by this embodiment; specifically, the ship general assembly site data includes boundary and platform passage position information, the left value represents the distance between the graphic and the left boundary of the screen, the top value is the distance from the upper boundary of the screen, the height value is the height of the graphic, and the width value represents the width of the graphic.

[0060] Specifically, in this embodiment, the boundary of the 6th platform's general assembly site is the 1st graphic, and the specific position is: the left value is 40000, the top value is 20000, the width value is 2000, and the height value is 54000; the 2nd graphic is the boundary, and the specific position is: the left value is 42000, the top value is 19900, the width value is 40000, and the height value is 100; the 3rd graphic is the boundary, and the specific position is: the left value is 42000, the top value is 74000, the width value is 4000, and the height value is 100; the 13th graphic is the platform passage, and the specific position is: the left value is 40000, the top value is 74000, the width value is 360000, and the height value is 12000; the 29th graphic is the vertical boundary, and the specific position is: the left value is 41900, the top value is 225000, the width value is 100, and the height value is 11000. Specifically, the position of the general assembly site provided in this embodiment is only an example, and the actual data needs to be adjusted according to actual needs.

[0061] Table 2 Partial area numbering data of the 6th platform's general assembly site

[0062] Area Number left top width heght 6-1 420 190 420 200 6-2 820 190 820 200 6-3 1220 190 1220 200 6-4 1620 190 1620 200 6-5 2020 190 2020 200 ……

[0063] Table 2 shows the undivided area division data of the 6th platform's general assembly site. Specifically, in this embodiment, the 6th platform site is divided into areas 6-1, 6-2, 6-3... The size of the area can be divided according to actual needs, and the data provided in this embodiment is only an example.

[0064] Optionally, it also includes marking the position of the platform's general assembly site to facilitate the subsequent addition of ship blocks. Specifically, the position marking interval can be adjusted according to actual needs. In this embodiment, on the horizontal (X-axis) of the site, the benchmark is 40m; on the vertical (Y-axis) of the site, the benchmark is 54m. Some specific position information data is shown in Table 3. The setting of specific data can be customized according to actual situations.

[0065] Table 3 Partial width marking data of the 6th platform's general assembly site

[0066] Area Number left top width heght 40m 55000 15000 15000 5000 40m 95000 15000 15000 5000 40m 135000 15000 15000 5000 40m 175000 15000 15000 5000 40m 215000 15000 15000 5000 ……

[0067] Optionally, for clear display, the platform's general site model can also be filled with colors. Table 4 shows part of the graphic color data provided in this embodiment.

[0068] Table 4 Partial graphic color data of the 6th platform's general assembly site

[0069]

[0070] Optionally, the above Tables 1-4 can be stored in a suitable manner according to the actual situation. In this embodiment, to avoid switching between multiple worksheets and improve efficiency, the above Tables 1-4 are stored in the same worksheet, namely the general group plan worksheet. If the amount of data in the table is large, the data can be classified and managed and stored in multiple worksheets. In short, the graphic numbers, dimensions (distance from the left, distance from the top, width, height) of the general group platform are clearly stored in the "site layout" worksheet, the areas are divided, and the colors of the areas in the site are set.

[0071] S3: Merge all the cells of the site plan worksheet to form a canvas.

[0072] Specifically, in the site plan worksheet, all the cells are merged to form a canvas. This is used to construct the overall ship model in this worksheet.

[0073] S4: Based on the overall ship assembly site data, through the VBA module, construct the overall ship assembly site model in the canvas.

[0074] Generally, constructing the overall ship assembly site model includes drawing a rectangular area representing the overall ship assembly site and setting the relevant information of the overall ship assembly site in the rectangular area, including the overall assembly site number, dimensions, and color represented by the rectangular area.

[0075] Optionally, in this embodiment, constructing the two-dimensional model of the overall ship assembly site includes adding function buttons such as "site initialization", "phase date", "refresh date", "combobox", "add / modify", "move / delete and load", "find block", "upper screen", "right screen", "left screen", and "lower screen". Specifically, the "combobox" includes date selection and, optionally, is combined with the refresh date function. Through the above function buttons, the addition, deletion, modification, and query of blocks can be realized.

[0076] Specifically, in this embodiment, taking Platform No. 6 as an example, the boundary, platform channels, numbers, and width information are converted into graphics or numbers and added to the "Site Plan" worksheet for 2D modeling. The method for adding graphics is the VBA code Shapes.AddShape(msoShapeRectangle, Left, Top, Width, Height), where the msoShapeRectangle parameter is a rectangle, and Left, Top, Width, and Height are the distances from the added rectangle to the left boundary of the screen, the distance to the upper boundary of the screen, the width, and the height, respectively. The method for filling the graphics is the VBA code shp.Fill.ForeColor.RGB = RGB(R, G, B), where R, G, and B are the numerical values of the three primary colors of Red, Green, and Blue light, respectively. The specific numerical values are exemplified by the data shown in Table 1-4.

[0077] As Figure 2 shown, it is a platform layout display diagram of the ship pre-assembly site provided by this embodiment; it can be Figure 2 seen that this platform includes functions such as "Site Initialization", "Phase Date", "Refresh Date", "Date Selection", "Add / Modify", "Move / Delete Lifting", and "Find Sub-assembly". Through the "Site Initialization" function, the site layout information in the "Site Layout" worksheet can be automatically mapped to the "Site Plan" worksheet.

[0078] S5: Obtain the ship pre-assembly plan and store the ship pre-assembly plan in the pre-assembly plan worksheet.

[0079] Specifically, obtain the pre-assembly site plan from the node plan (annual production and operation plan) and import it into the pre-assembly plan worksheet. Optionally, the pre-assembly plan table includes project number, sub-assembly, pre-assembly start, pre-assembly end, lifting start, and dimensions (length * width). Optionally, the ship pre-assembly plan can be manually input or copy the original plan to the plan worksheet. Specifically, as shown in Table 5, it shows a partial pre-assembly plan table provided by this embodiment;

[0080] Table 5 Partial Pre-assembly Plan Table

[0081] Project Number Total Section Total Group Start Total Group End Loading Start Dimensions (Length * Width) H2776 10A 2024 / 3 / 5 2024 / 3 / 21 2024 / 3 / 22 21m * 16.8m H2776 11A 2024 / 3 / 11 2024 / 4 / 6 2024 / 4 / 7 51m * 16.8m H2776 78B 2024 / 1 / 18 2024 / 2 / 29 2024 / 3 / 5 30m * 46m ……

[0082] As shown in Table 5, the general group plan table specifically includes six columns: project number, general section, general group start, general group end, outfitting start, and size (length * width). Among them, the project number and general section are attribute information of the general section name, the general group start, general group end, and outfitting start are time information of the general section, and the size (length * width) is the space information of the general section. The length is the length along the longitudinal direction of the shipyard in the site layout drawing. In this embodiment: the project number is H2776, and there are three general sections, namely 10A, 11A, and 78B. The general group start time of H2776-10A for general group on Platform 6 is 2024 / 3 / 5, the general group end time is 2024 / 3 / 21, and the outfitting time is 2024 / 3 / 22. The size of this general section is 21m * 16.8m; the general group start time of H2776-11A for general group on Platform 6 is 2024 / 3 / 11, the general group end time is 2024 / 4 / 6, and the outfitting time is 2024 / 4 / 7. The size of this general section is 51m * 16.8m; the general group start time of H2776-78B for general group on Platform 6 is 2024 / 1 / 18, the general group end time is 2024 / 2 / 29, and the outfitting time is 2024 / 3 / 5. The size of this general section is 30m * 46m.

[0083] S6: Add the ship general section in the 2D model of the ship general group site according to the ship general group plan.

[0084] Generally, adding a ship general section in the ship general group site model includes: drawing a rectangular area representing the ship general section; setting the relevant information of the ship general section in the rectangular area. Optionally, different colors are set for each general section for marking to facilitate users to view.

[0085] Specifically, use the "Add / Modify" function to add and modify the position information of the ship general section. The relevant information of the general section can be automatically retrieved from the "General Group Plan" worksheet according to the project number and general section number, and the general section is added and modified in the "Site Plan" worksheet and displayed as a rectangular frame. Specifically, it includes adding the "project number" of the general section, filling in the "general section number", and selecting the added platform. The "6th Platform", "5th Platform", and "Other Platforms" can be selected. The relevant information of the ship general section includes the information in the ship general group plan, including: project number, general section number, general group start time, general group end time, outfitting time, length * width, shortest distance, platform selection, alignment method, addition method, longitudinal distance, and lateral distance (the longitudinal distance is the longitudinal distance of the added graphic from the position number when adding based on the position, and the lateral distance is the distance from the boundary when adding based on the position).

[0086] As Figure 3As shown, it is a display diagram showing the addition of a total section based on location. In this example, "Platform 6" is taken as an example, and the total section H2776-11A is added. Specifically, H2776 is manually selected, 11A is manually filled in, and then "Add based on" is selected. By default, it is added based on location. When adding based on location, a location number needs to be added. For example, "6-2" means that the location with the number "6-2" on Platform 6 is the longitudinal starting position. It is also possible to select to add to the right, left, down, or up based on the selected total section graph. When selecting to add down or up, the default is "left alignment", which can also be modified to "right alignment". The "longitudinal distance" and "lateral distance" are defaulted to 0m. The start of the total group, the end of the total group, and the start of the erection, and the dimensions (length * width) are retrieved from the "Total Group Plan" worksheet. Inside Platform 6, the total section H2776-11A is displayed, and the rectangular frame shows H2776, 11A, PE Span: 3 / 11~4 / 6 in sequence, which represent the project number, the total section number, and the total group stage date respectively. Optionally, it is also possible to display, E Start: 2024 / 4 / 7, 51m * 16.8m, which represents the erection start date and the total section dimensions.

[0087] Specifically, in this embodiment, Platform 6 is separated into upper and lower half areas by a platform passage. The boundary of the upper half area is on the upper side, and the boundary of the lower half area is on the lower side. The "shortest distance" is defaulted to 3m, which is the distance between the total section and the adjacent total section, and this distance can be modified. In addition, the boundary of the added total section graph cannot be outside the platform or on the platform passage.

[0088] As Figure 4 shown, it is a display diagram showing the addition of a total section to the right based on the total section. Specifically, taking the addition of the total section H2785-20F to the right of the total section H2776-11A as an example. Based on the selected graph H2776-11A, the total section H2785-20F is added. H2785 is manually selected, 20F is manually filled in, and based on adding to the right, the default shortest distance is 3m, that is, the left boundary of H2785-20F is 3m to the right of the right boundary of H2776-11A. The location here is 6-3, the longitudinal distance is 14m, and the lateral distance is 0m. Other information is retrieved from the "Total Group Plan" worksheet and displayed in the added total section graph. The added graph is in the selected state, and its corresponding information is also synchronously recorded in the "Addition and Modification" worksheet.

[0089] As Figure 5As shown, it is a display diagram showing the addition of a general section downward based on the general section; specifically, taking the addition of the general section H2786-20F to the right of the general section H2776-11A as an example. Based on the selected graphic H2776-11A, the general section H2786-20F is added. H2786 is manually selected and 20F is manually filled. Based on the downward addition, right alignment is selected, and the default shortest distance is 3m, that is, the upper boundary of H2786-20F is 3m downward from the lower boundary of H2776-11A. The position here is 6-3, the longitudinal distance is -16.8m, and the lateral distance is 19.8m. Other information is retrieved from the "General Group Plan" worksheet and displayed in the added general section graphic. The added graphic is in the selected state, and its corresponding information is also synchronously recorded in the "Addition and Modification" worksheet.

[0090] Specifically, using the "Move, Delete, and Mount" function, the position of the general section can be moved. It is possible to move by selecting the position number in the platform area or based on a certain general section. If you want to move another general section, you need to select this general section and refresh the general section information. It is also possible to delete the graphic, restore the deletion, and mount the general section. The "Delete Graphic" function makes the operated general section disappear in the "Site Plan" worksheet, and at the same time deletes the corresponding information in the "Addition and Modification" worksheet. The information of the deleted graphic appears in the "Delete Graphic" worksheet, but only the most recently deleted graphic is retained. The "Restore Deletion" function can restore the most recently deleted graphic. The "Mount General Section" function is to perform the general section mounting in advance, making the operated general section disappear in the "Site Plan" worksheet. After this function is executed, the information of the mounted general section is cut from the "Addition and Modification" worksheet to the "Mount General Section" worksheet. In addition, the boundary of the moved general section graphic cannot be outside the platform or on the platform passage;

[0091] As Figure 6 shown, it is a display diagram showing the movement of the general section based on the position in this embodiment; first, select the general section graphic H2786-20F to be moved. Based on the movement, select the position, select the position number 6-5, and select the default values of 0mm for both the longitudinal distance and the lateral distance. Select the default value of 3m for the shortest distance, and then click the move command. After moving, the graphic position becomes the position of the selected parameter values, and its modified general section information is also synchronously recorded in the "Addition and Modification" worksheet.

[0092] As Figure 7 shown, it is a display diagram showing the movement of the general section to the left in this embodiment. First, select the general section graphic H2786-20F to be moved. Based on the movement, select to move to the left. Based on the general section project number, select H2776, fill in 11A for the general section number, select the default value of 0mm for the lateral distance, select the default value of 3m for the shortest distance, and then click the move command. After moving, the graphic position becomes the position of the selected parameter values, where the position number becomes 6-1 and the longitudinal distance becomes 9.2m. Its modified general section information is also synchronously recorded in the "Addition and Modification" worksheet.

[0093] Optionally, there is also a function to cancel the loading. After the overall section cancels the loading, the overall section graphic information and digital information are restored to the corresponding worksheet.

[0094] Specifically, the main code used for the overall section graphic space operation function is the Shapes.AddShape method. The command Shapes.AddShape(msoShapeRectangle, Left, Top, Width, Height) is mainly used to add a rectangular graphic. The command shp.Fill.ForeColor.RGB = RGB(R, G, B) is used to fill the graphic color, and the shp.Delete command is used to delete the graphic.

[0095] S7: The management personnel input the query conditions to view the overall group site plan arrangement under the corresponding conditions.

[0096] Generally, the management personnel can find the corresponding overall group site plan arrangement by inputting the overall section to be searched and the time and date range to be searched.

[0097] Optionally, use the "Search Overall Section" function to search for the overall group site plan arrangement of the specified overall section. Specifically, if the overall section to be searched is in the "Site Plan" worksheet, the position of the overall section to be searched will flash; if the overall section to be searched has not been added, a prompt will be given "The specified overall section was not found. Please verify again!"; if the overall section has been loaded, a prompt will be given "This overall section has been loaded. Please view it in the 'Loaded Overall Sections' table!". As Figure 8 shown, it is the display diagram of the "Search Overall Section" function; for example, when searching for H2776-11A, select the project number H2776 and fill in the overall section number 11A. The overall section to be searched flashes on platform No. 6, and the information such as the start of the overall group, the end of the overall group, the start of loading, length * width, etc. are obtained from the "Add / Modify" worksheet and filled in the corresponding positions.

[0098] Optionally, use the "Refresh Date" function to search for the overall group site plan arrangement at the specified time. Specifically, select the specified date and click the "Refresh Date" button. Only the overall sections that have been overall grouped but not loaded on the day of the refreshed date will be displayed within the overall group site. As Figure 9 shown, it is the display diagram of the "Refresh Date" function; for example, select the date 2024-6-5 and then click the "Refresh Date" command. Since H2776-11A and H2785-20F have been loaded, the above two overall sections are not displayed on platform No. 6. The overall group of H2785-20F starts on 2024-6-3 and the loading starts on 2024-6-29, so H2785-20F is displayed on platform No. 6. This function solves the problem of tire flipping display. Tire flipping refers to different overall sections being overall grouped in the same space at different times;

[0099] Optionally, use the "Phase Date" function to find the overall group site plan under the specified phase date. Specifically, select the start date and end date. Only the overall sections that have been grouped but not loaded within the time period from the start date to the end date of the phase date are displayed within the overall group site. As Figure 10 shown in the display diagram of the phase date function; for example, when the phase date is selected with the start date of 2024-4-1 and the end date of 2024-6-10, after the command is executed, Platform 6 displays H2776-11A, H2785-20F, H2786-20F. The above three overall sections have been grouped but not loaded within the above phase date. This function is to display the overall group site plan within the phase date, facilitating the statistics of the quantity of materials and the site utilization rate. In this case, the overall sections allowed for retreading are displayed overlappingly.

[0100] Optionally, use the "Area Jump" function to conveniently view the site plans of other areas. Generally, there may be multiple overall group areas in a "Site Plan" worksheet. Since the computer screen cannot display all the overall group areas at a certain display ratio, therefore, as Figure 11 shown, it is the display diagram of the area jump function; generally, the area jump function can be set with single or multiple jump buttons. Specifically, in this embodiment, there are buttons "Right Screen", "Left Screen", "Lower Screen", and "Upper Screen". By clicking the buttons, the area jump function can be realized, facilitating the quick viewing of the layout information of the overall sections in all areas. From Figure 11 it can be seen that the graphical display page of the ship overall group site plan provided in this embodiment includes multiple platforms, and each platform includes multiple ship sections. It can clearly display the relevant information of each ship section, the utilization situation of the platforms at the same time, and particularly, also display the position of the platform passages, facilitating the transportation of ship overall sections.

[0101] In summary, the graphical display solution of the ship overall group site plan provided in this embodiment realizes the unification of the actual and the model of the overall group site through a graphical interface, can display the ship overall group site plan to the user in an intuitive and vivid manner, allows for an intuitive understanding of the site utilization situation, optimizes the site layout, improves the site utilization efficiency and operation efficiency. The graphical display method enables managers to make decisions more quickly, reduces the barriers to information transmission, improves the efficiency of work collaboration, and timely adjusts the production plan to adapt to market changes.

[0102] Embodiment 2

[0103] This embodiment provides a graphical display system for the ship assembly site plan arrangement, including a data storage module, a model construction module, and a user interaction module; the data storage module is used to store the ship assembly site data and the ship assembly plan; the model construction module is used to construct a ship assembly site model according to the ship assembly site data and the ship assembly plan; the user interaction module is used to display the ship assembly site model.

[0104] Specifically, the data storage module stores the physical parameters of the ship assembly site and the assembly plan data, and provides data reading and writing interfaces. Optionally, data can be imported from Excel, CSV, or a database. It also includes a data verification function, including the detection of date formats and dimensional rationality.

[0105] Specifically, the model construction module converts the site data and the assembly plan into a two-dimensional graphical model and supports dynamic adjustment and interactive operations. Specifically, the model construction module constructing a ship assembly site model according to the ship assembly site data and the ship assembly plan includes multiple sub-module functions. Optionally, the ship assembly site model includes a sub-section addition module, a sub-section displacement module screening module, and a region jump module.

[0106] Specifically, after obtaining the project number and sub-section number from the data storage module or directly input by the user, the sub-section addition module calls the assembly plan data to generate a rectangular graph at the specified position; for the sub-section displacement module, the user adjusts the sub-section position by dragging or entering coordinates; the screening module includes: a sub-section search module, which locates the target and highlights it after inputting the project number / sub-section number; a refresh date module, which only displays the sub-sections that have been assembled but not loaded on the current day after selecting a date; a stage date module, which displays all sub-sections within the specified time period after inputting the time period; the region jump module is provided with "right screen", "left screen", "lower screen", and "upper screen" buttons, and the display area can be quickly switched by clicking the buttons. In addition, it also supports zooming in and out with the mouse wheel to view the whole field or local details.

[0107] Specifically, the user interaction module provides a graphical operation interface to support real-time interaction between the user and the model. The graphical operation interface includes a canvas area: displaying the two-dimensional model of the assembly site (boundary, channel, sub-section graph); function buttons: including "add / modify", "move / delete / load", "search for sub-sections", etc.; screening controls: a date selector, a platform number drop-down menu.

[0108] The graphical display system for the ship pre-assembly site plan arrangement provided in this embodiment is a ship pre-assembly site plan management tool developed based on Excel-VBA, which realizes the spatio-temporal integrated management of the pre-assembly site through a graphical interface. The system combines the physical layout of the ship pre-assembly site, the block plan and dynamic operation functions, supports core functions such as adding, deleting, modifying, querying blocks, time filtering, and area jumping, and improves the site utilization rate and production scheduling efficiency.

[0109] The above embodiments are only used to exemplarily illustrate the principles and effects of the present invention, rather than to limit the present invention. Any person familiar with this technology can modify or change the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or changes completed by those with ordinary knowledge in the technical field without departing from the spirit and technical ideas disclosed by the present invention should still be covered by the claims of the present invention.

Claims

1. A graphical display method for the overall assembly site plan arrangement of a ship, characterized in that, Including: Create new worksheets, which at least include a site layout worksheet, a site plan worksheet, and a general assembly plan worksheet; Obtain the ship general assembly site data and store the ship general assembly site data in the site layout worksheet; Merge all cells in the site plan worksheet to form a canvas; Based on the ship general assembly site data, use the VBA module to construct a ship general assembly site model in the canvas; Obtain the ship general assembly plan and store the ship general assembly plan in the general assembly plan worksheet; Add ship sub-assemblies to the ship general assembly site model based on the ship general assembly plan.

2. The graphical display method for the overall ship assembly site plan arrangement according to claim 1, characterized in that, It also includes dividing the ship general assembly site into regions.

3. The graphical display method for the ship outfitting yard plan arrangement according to claim 1, wherein It also includes preprocessing the ship general assembly site data.

4. The graphical display method for the ship assembly site plan arrangement according to claim 1, wherein Constructing the ship general assembly site model includes: Draw a rectangular area representing the ship general assembly site; Set the relevant information of the ship general assembly site in the rectangular area.

5. The graphical display method for the ship assembly site plan arrangement according to claim 1, wherein Adding ship sub-assemblies to the ship general assembly site model includes: Draw a rectangular area representing the ship sub-assembly; Set the relevant information of the ship sub-assembly in the rectangular area.

6. The graphical display method for the ship erection site plan arrangement according to claim 1, characterized in that The ship general assembly site model at least includes: function buttons for site initialization, stage date, addition and modification, movement, deletion and erection, and finding sub-assemblies.

7. The graphical display method for the overall assembly site plan arrangement of a ship according to claim 1, wherein The ship general assembly plan includes project number, sub-assembly number, general assembly start date, general assembly end date, and erection start date.

8. The graphical display method for the overall assembly site plan arrangement of a ship according to claim 1, characterized in that It also includes managers inputting query conditions to view the general assembly site plan arrangement under the corresponding conditions.

9. A graphical display system for the planning and arrangement of a ship assembly site, characterized in that, Including: A data storage module for storing ship general assembly site data and ship general assembly plans; A model construction module for constructing a ship general assembly site model according to the ship general assembly site data and ship general assembly plans; A user interaction module for providing a graphical operation interface and displaying the ship general assembly site model.

10. The graphical display system for the ship assembly site plan arrangement according to claim 9, characterized in that, The ship general assembly site model includes: A sub-assembly addition module for generating a sub-assembly graph at a specified position based on user input; A sub-assembly displacement module for moving the sub-assembly graph; A screening module, including a sub-assembly finding module, a date refreshing module, and a stage date module, which displays the ship general assembly site model according to user screening conditions; A region jump module provided with jump buttons to realize the switching of display regions.

Images