EXCEL VBA-based change list generation system
By using an EXCEL VBA-based change order generation system, the creation of change orders and the query of borrowed parts have been automated, solving the quality and inefficiency problems that exist in manual creation, and improving the standardization and creation efficiency of change orders.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- HANGZHOU EBOYLAMP ELECTRONICS CO LTD
- Filing Date
- 2025-12-30
- Publication Date
- 2026-05-08
AI Technical Summary
In the existing technology, the preparation of change orders requires manual input, which results in problems such as non-compliance with standard requirements, poor writing quality, high rejection rate, and time-consuming and laborious process of checking the borrowing status of the changed drawing number in other projects, thus affecting the progress of the change.
An EXCEL VBA-based change order generation system is adopted, which includes modules for highlighting and editing, adding new items, modifying changed content, deleting changed content, and generating change orders. Through interface display, rule prompts, and automated operations, change orders that meet the standards are generated, and borrowing change notices are prepared by querying the borrowing status of drawings.
It improved the efficiency and standardization of change order preparation, reduced the rollback rate, decreased workload, and ensured the accuracy and consistency of change orders.
Smart Images
Figure CN121997902A_ABST
Abstract
Description
Technical Field
[0001] This invention belongs to the field of document generation technology, specifically relating to a change order generation system based on EXCEL VBA. Background Technology
[0002] For changes in technical status, the contractor should prepare a technical status change notification document. Currently, the technical status change notification document within the company is in the form of a change order.
[0003] Currently, the preparation of change orders requires manual input, which leads to problems such as non-compliance with standard requirements, poor writing quality, and high rejection rates. In addition, manually filling in and checking the borrowing status of the changed drawing number in other projects to prepare the borrowed part change notification is time-consuming and laborious, which affects the progress of the change to a certain extent. Summary of the Invention
[0004] The purpose of this invention is to address the problems mentioned in the background art by proposing an EXCEL VBA-based change order generation system.
[0005] To achieve the above objectives, the technical solution adopted by the present invention is as follows:
[0006] This invention proposes an Excel VBA-based change order generation system for standardizing change orders during the change order preparation process to obtain compliant change orders. The Excel VBA-based change order generation system includes:
[0007] The highlight editing module is used to highlight the cells to be filled in on the editing page, receive the user's first filling operation on the highlighted cells, and provide the user with rules and instructions on the content to be filled in;
[0008] The new module is used to generate a preset number of new entries in the "Changes" section of the editing page based on user actions.
[0009] The "Modify Content" module is used to modify newly added content based on user actions.
[0010] The "Delete / Change Content" module is used to delete newly added content based on user actions.
[0011] The Change Order Generation module is used to generate change orders that meet the requirements.
[0012] Preferably, the types of newly added content include three categories: newly added document changes, newly added pattern changes, and batch addition / cancellation.
[0013] The new module includes a first new module and a second new module. The first new module includes a "New / Change Content" button, and the second new module includes a "New / Change Content" button above a specified location. When new content is generated, the first new module or the second receiving module receives a user's first click operation on the "New / Change Content" button or the "New / Change Content" button above the specified location. In response to the first click operation, a first form with selectability is generated, which includes new document changes, new pattern changes, and batch addition / cancellation. The first new module or the second receiving module receives a user's selection operation on one type of new content in the first form. In response to the selection operation, a second form corresponding to the new content type is generated. The first new module or the second receiving module receives a user's second filling operation on the second form. In response to the second filling operation, new content corresponding to the content filled in the second form is generated in the "Change Content" column of the editing page.
[0014] Preferably, the second form corresponding to the new document change or new pattern change includes text boxes for document or pattern identifier, document or pattern name, first change type, and change content. The second form corresponding to the batch add / cancel includes text boxes for second change type, pattern identifier, and pattern name. The first change type for new document changes includes overall replacement, overall addition, overall cancellation, partial page replacement, partial page replacement with simultaneous partial page addition, and partial page replacement with simultaneous partial page cancellation. The first change type for new pattern changes includes pattern addition, pattern cancellation, pattern replacement, pattern import, and pattern export. The second change type includes pattern addition and pattern cancellation.
[0015] Preferably, the modified content module includes a modified content button. When modifying newly added content, the modified content module receives a first selection operation from the user on the newly added content and a second click operation from the user on the modified content button. In response to the first selection operation and the second click operation, a second window corresponding to the current newly added content pops up, and the module receives the user's modification operation on the content in the second window, thereby realizing the modification of the newly added content.
[0016] Preferably, the delete / modify content module includes a delete / modify content button. When deleting newly added content, the delete / modify content module receives a second selection operation from the user on the newly added content and a third click operation from the user on the delete / modify content button. In response to the second selection operation and the third click operation, a second window corresponding to the current newly added content pops up, and the module receives the user's delete operation on the content in the second window, thereby deleting the newly added content.
[0017] Preferably, the change order generation module further includes a change order generation button, and the change order generation module receives a third click operation from the user on the change order generation button, and in response to the third click operation, first checks whether the cells to be filled in on the editing page are filled in completely;
[0018] The change order module also formats the edit page after it has been filled out: it compares the number of rows occupied by all the new content in the change content column of the edit page with the preset value. If it is greater than the preset value, it will be paginated; otherwise, it will not be paginated, and all content belonging to the same new content will be kept on the same page.
[0019] After typesetting, a change order that meets the requirements was obtained;
[0020] The change order generation module also adds work protection to change orders that meet the requirements;
[0021] The change order generation module also determines whether to display a prompt to the user and whether to generate a borrowing change notification.
[0022] Preferably, when the change order generation module determines whether to display a prompt to the user, it operates as follows:
[0023] The Change Order module queries the new content of each new drawing change. If the current new drawing change type is "Drawing Addition" and it is found that the drawing identifier in the new drawing change is borrowed from other projects, a prompt that the drawing cannot be added will be generated.
[0024] If the change type of the newly added drawing is drawing replacement, obsolescence, move in, or move out, and no drawing identifier in the newly added drawing change is found to be borrowed by other projects, the change order module will generate a prompt that drawing replacement, obsolescence, move in, or move out cannot be performed.
[0025] If the change type of the newly added drawing is drawing obsolescence, and it is found that the drawing identifier in the newly added drawing change is borrowed by other projects, the change order module will generate a prompt that if drawing obsolescence is required, please initiate the process in sync with other project changes.
[0026] The change order generation module receives user input to select whether to modify the generated change order that meets the requirements, based on prompts.
[0027] Preferably, when the change order generation module determines whether to generate a borrowing change notification, it operates as follows:
[0028] If the usage column of the qualified change order shows "None", and the change order generation module finds that the new drawing change does not exist in other projects, then no borrowing change notification form will be generated.
[0029] If the usage column of the qualified change order shows "None", and the change order generation module finds that the new drawing change is borrowed in other projects, then a borrowed part change notification form will be generated.
[0030] If the usage column of the change order meets the requirements and shows "See Borrowed Parts Change Notice", and the change order generation module finds that the new drawing change does not exist in other projects, then a blank Borrowed Parts Change Notice will be generated.
[0031] If the usage column of the change order meets the requirements and shows "See Borrowed Parts Change Notice", and the change order generation module finds that the new drawing change is borrowed in other projects, then a Borrowed Parts Change Notice will be generated.
[0032] If the usage column of a qualified change order shows "None" or "Usability not checked," then it will not check whether the newly added drawing change is borrowed in other projects, and a borrowing change notification will not be generated.
[0033] Preferably, the EXCEL VBA-based change order generation system further includes a change order modification module, used to return to the editing page based on user operations, and to delete generated change orders and borrowing change notifications that meet the requirements.
[0034] Preferably, the EXCEL VBA-based change order generation system further includes a display interface module, which displays the editing page and the generated change order that meets the requirements. The interface also has a toolbar, and buttons for adding change content, adding change content above a specified position, modifying change content, deleting change content, generating change order, and modifying change order are integrated in the toolbar.
[0035] Compared with the prior art, the beneficial effects of the present invention are as follows:
[0036] This EXCEL VBA-based change order generation system, through its interface display module, highlight editing module, add module, modify change content module, delete change content module, and generate change order module, enables the generation of change orders that meet standard requirements, improving compilation efficiency, standardization of change orders, and reducing rollback rate. The change order generation module queries the borrowing status of the corresponding drawings in other projects to generate borrowing change notifications, reducing workload. Attached Figure Description
[0037] Figure 1 This is the display interface in the EXCEL VBA-based change order generation system of the present invention;
[0038] Figure 2This is a schematic diagram illustrating the rules in the editing page of this invention;
[0039] Figure 3 This is a schematic diagram illustrating the changes made to the second window when adding a new document in this invention.
[0040] Figure 4 This is a schematic diagram of the second window corresponding to the addition and modification of the pattern in this invention.
[0041] Figure 5 This is a schematic diagram of the second window corresponding to the batch addition / cancellation of the present invention;
[0042] Figure 6 This is a schematic diagram of a modification order conforming to the requirements of this invention;
[0043] Figure 7 This is a schematic diagram of the borrowing change notification form of the present invention. Detailed Implementation
[0044] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0045] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to limit the invention.
[0046] like Figures 1-7 As shown, an EXCEL VBA-based change order generation system is provided.
[0047] The EXCELVBA-based change order generation system is used to standardize change orders during the change order preparation process to obtain compliant change orders. It includes: a display interface module, a highlighting editing module, an add module, a modify change content module, a delete change content module, a generate change order module, and a modify change order module.
[0048] In one embodiment, a display interface module is provided, which displays the editing page and the generated change order that meets the requirements. The interface also has a toolbar, and buttons for adding change content, adding change content above a specified position, modifying change content, deleting change content, generating change order, and modifying change order are integrated in the toolbar.
[0049] like Figure 1 The image shows the display interface, with the toolbar at the top and the editing page and generated, compliant change units displayed below the toolbar.
[0050] In one embodiment, the highlighting editing module is used to highlight the cells to be filled in on the editing page, receive the user's first filling operation on the highlighted cells, and provide the user with rules regarding the content to be filled in.
[0051] Among them, such as Figure 1 As shown, the green area represents the highlighted cells. The red triangle in the upper right corner of the cell indicates the rules for entering the content. The highlighting editing module receives the user's hover action over the red triangle and, in response, displays a prompt explaining the rules for entering the content of the corresponding cell (e.g., ...). Figure 2 As shown, the specific details of the rules can be set randomly. Figure 1 The design file change notification form in the document is the editing page. Figure 6 The design document change notification form in the document is a change form that meets the requirements.
[0052] In one embodiment, a new module is added to generate a preset number of new content entries in the changed content section of the editing page based on the user's actions.
[0053] The types of new content include three categories: new document changes, new pattern changes, and batch addition / cancellation.
[0054] The new module includes a first new unit and a second new unit. The first new unit includes a "New / Change Content" button, and the second new unit includes a "New / Change Content" button above a specified location. When new content is generated, the first new unit or the second receiving unit receives a user's first click operation on the "New / Change Content" button or the "New / Change Content" button above the specified location. In response to the first click operation, it generates a first form containing options for adding document changes, adding pattern changes, and batch adding / canceling, with selectability. The first new unit or the second receiving unit receives a user's selection operation for one type of new content in the first form, and in response to the selection operation, it generates the corresponding... A second form with newly added content is created. The first adding unit or the second receiving unit receives the user's second input operation on the second form. In response to the second input operation, it generates new content corresponding to the content entered in the edit page's edit content pane. (The difference between the "Add / Change Content" button and the "Add / Change Content Above a Specified Position" button is that the new content generated by the "Add / Change Content" button in the edit page starts from the first row of blank cells below "Reason for Change" and displays sequentially downwards, while the new content generated by the "Add / Change Content Above a Specified Position" button is inserted above the specified row.) Figure 1 As shown, the newly added content generated in the Changes section is displayed in the blank cell below "Reason for Change". The specific format in which the newly added content is displayed in the Changes section can be set according to actual needs and there are no restrictions.
[0055] like Figure 3-5 As shown in Figure 3, the second form corresponding to adding and modifying a new document is displayed. Figure 4 This displays the second window corresponding to the changes made to the newly added pattern. Figure 5 The second form displayed is for batch addition / cancellation. The second form for adding document changes or adding drawing changes includes the document or drawing identifier. Figure 3 The file identifier is displayed. Figure 4 The drawing number displayed in the document or drawing name. Figure 3 The file name is displayed. Figure 4 The form displays the drawing name, the first change type, and the change content (the text box for the first change type is selectable). The second form corresponding to batch add / cancel includes text boxes for the second change type, drawing identifier, and drawing name (i.e.,...). Figure 5 The drawing number and drawing name are displayed in the text box, where the second change type text box is selectable. The first change type for newly added documents includes overall replacement, overall addition, overall obsolescence, and partial page replacement (i.e., ...). Figure 3 Replace XX pages in the middle), and simultaneously replace some pages and add new pages in the same area (i.e., replace XX pages in the middle). Figure 3 Replace XX pages and add XX pages), and replace some pages while invalidating the corresponding pages (i.e., replace XX pages and add XX pages). Figure 3 Replace XX pages, invalidate XX pages), the first change type for newly added drawings includes adding drawings (i.e., adding drawings). Figure 4 New drawings with the total number XX in the new base map), and drawings that are invalid (i.e., Figure 4 The process includes invalidating drawings with the base drawing number XX and replacing drawings (i.e., ...). Figure 4 In this process, drawing number XX is discarded and replaced with drawing number XX; drawings are moved in (i.e.,...). Figure 4 The process of moving drawings with the base map number XX from the XX project to this project and moving drawings out (i.e.,...) Figure 4 The first type of change involves moving the drawing with the base drawing number XX from this project to another project. The second type of change includes adding drawings and invalidating drawings (i.e., adding drawings). Figure 5 The following drawings are added and the following drawings are discarded. The second form corresponding to the changes to the new drawings also includes the old drawing stage marker and the new drawing stage marker.
[0056] In one embodiment, the content modification module is used to modify newly added content based on user actions;
[0057] The Modify Content module includes a Modify Content button. When modifying newly added content, the Modify Content module receives the user's first selection operation on the newly added content and the user's second click operation on the Modify Content button. In response to the first selection operation and the second click operation, a second window corresponding to the current newly added content pops up, and the module receives the user's modification operation on the content in the second window, thereby realizing the modification of the newly added content.
[0058] In one embodiment, the delete / modify content module is used to delete newly added content based on user actions;
[0059] The delete / modify content module includes a delete / modify content button. When deleting newly added content, the delete / modify content module receives the user's second selection operation on the newly added content and the user's third click operation on the delete / modify content button. In response to the second selection operation and the third click operation, a second window corresponding to the current newly added content pops up, and the module receives the user's delete operation on the content in the second window, thereby deleting the newly added content.
[0060] In one embodiment, a change order generation module is used to generate a change order that meets the requirements;
[0061] The "Generate Change Order" module also includes a "Generate Change Order" button. The "Generate Change Order" module receives a third click from the user on the "Generate Change Order" button and, in response to the third click, first checks whether the cells to be filled in on the editing page are completely filled.
[0062] The change order module also formats the edit page after it has been filled out: it compares the number of rows occupied by all the new content in the changed content column of the edit page with the preset value. If it is greater than the preset value, it will paginate; otherwise, it will not paginate. All content belonging to the same new content will remain on the same page. It also modifies the page number column in the edit page.
[0063] After typesetting, a change order that meets the requirements was obtained;
[0064] The Change Order generation module also adds work protection (hiding the contents of cells) to eligible change orders;
[0065] The change order generation module also determines whether to display a prompt to the user and whether to generate a borrowing change notification.
[0066] When determining whether to display a prompt to the user in the "Generate Change Order" module, the following steps should be taken:
[0067] The Change Order module queries the new content of each new drawing change. If the current new drawing change type is "Drawing Addition" and it is found that the drawing identifier in the new drawing change is borrowed from other projects, a prompt that the drawing cannot be added will be generated.
[0068] If the change type of the newly added drawing is drawing replacement, obsolescence, move in, or move out, and no drawing identifier in the newly added drawing change is found to be borrowed by other projects, the change order module will generate a prompt that drawing replacement, obsolescence, move in, or move out cannot be performed.
[0069] If the change type of the newly added drawing is drawing obsolescence, and it is found that the drawing identifier in the newly added drawing change is borrowed by other projects, the change order module will generate a prompt that if drawing obsolescence is required, please initiate the process in sync with other project changes.
[0070] The Change Order generation module receives user input prompts to indicate whether they wish to modify the generated Change Order to meet the requirements.
[0071] When determining whether to generate a borrowing change notification form in the change order generation module, the following steps are taken:
[0072] If the usage column of the eligible change order shows "None", and the change order generation module finds that the new drawing change is not borrowed in other projects (the query is performed by querying the database, which stores information about all projects of the enterprise), then no borrowing change notification will be generated.
[0073] If the usage column of the qualified change order shows "None", and the change order generation module finds that the new drawing change is borrowed in other projects, then a borrowed part change notification form will be generated.
[0074] If the usage column of the change order meets the requirements and shows "See Borrowed Parts Change Notice", and the change order generation module finds that the new drawing change does not exist in other projects, then a blank Borrowed Parts Change Notice will be generated.
[0075] If the usage column of the change order meets the requirements and shows "See Borrowed Parts Change Notice", and the change order generation module finds that the new drawing change is borrowed in other projects, then a Borrowed Parts Change Notice will be generated.
[0076] If the usage column of a qualified change order shows "None" or "Usability not checked," then it will not check whether the newly added drawing change is borrowed in other projects, and a borrowing change notification will not be generated.
[0077] If the comments in the "Comments" section of a compliant change order exceed the preset character limit, an attachment for the comments will be automatically generated, and the "Comments" section will display "See Comments." Additionally, a supplementary section will be added to the compliant change order (containing the "Borrowed Item Change Notification Form," which is shown below). Figure 7 (As shown).
[0078] In one embodiment, the EXCEL VBA-based change order generation system further includes a change order modification module, used to return to the editing page based on user actions, and to delete generated, compliant change orders, loan item change notices, and processing comments attachments. If a loan item change notice exists, the user can choose whether to retain it. If the user chooses to retain it, a prompt will appear stating that if retention is required, the user should check / add / delete the usability of the corresponding changes themselves.
[0079] This EXCEL VBA-based change order generation system, through its interface display module, highlight editing module, add module, modify change content module, delete change content module, and generate change order module, enables the generation of change orders that meet standard requirements, improving compilation efficiency, standardization of change orders, and reducing rollback rate. The change order generation module queries the borrowing status of the corresponding drawings in other projects to generate borrowing change notifications, reducing workload.
[0080] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0081] The embodiments described above are merely illustrative of several implementations of the present invention, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of the invention. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of the present invention, and these modifications and improvements all fall within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the appended claims.
Claims
1. A change order generation system based on Excel VBA, characterized in that: The EXCEL VBA-based change order generation system is used to standardize change orders during the change order preparation process to obtain compliant change orders. The EXCEL VBA-based change order generation system includes: The highlight editing module is used to highlight the cells to be filled in on the editing page, receive the user's first filling operation on the highlighted cells, and provide the user with rules and instructions on the content to be filled in; The new module is used to generate a preset number of new entries in the "Changes" section of the editing page based on user actions. The "Modify Content" module is used to modify newly added content based on user actions. The "Delete / Change Content" module is used to delete newly added content based on user actions. The Change Order Generation module is used to generate change orders that meet the requirements.
2. The EXCEL VBA-based change order generation system as described in claim 1, characterized in that: The types of newly added content include three categories: new document changes, new pattern changes, and batch addition / cancellation. The new module includes a first new module and a second new module. The first new module includes a "New / Change Content" button, and the second new module includes a "New / Change Content" button above a specified location. When new content is generated, the first new module or the second receiving module receives a user's first click operation on the "New / Change Content" button or the "New / Change Content" button above the specified location. In response to the first click operation, a first form with selectability is generated, which includes new document changes, new pattern changes, and batch addition / cancellation. The first new module or the second receiving module receives a user's selection operation on one type of new content in the first form. In response to the selection operation, a second form corresponding to the new content type is generated. The first new module or the second receiving module receives a user's second filling operation on the second form. In response to the second filling operation, new content corresponding to the content filled in the second form is generated in the "Change Content" column of the editing page.
3. The EXCEL VBA-based change order generation system as described in claim 2, characterized in that: The second form corresponding to the newly added document change or newly added drawing change includes text boxes for document or drawing identifier, document or drawing name, first change type, and change content. The second form corresponding to the batch add / cancel includes text boxes for second change type, drawing identifier, and drawing name. The first change type for newly added document changes includes overall replacement, overall addition, overall cancellation, partial page replacement, partial page replacement and partial page addition, and partial page replacement and partial page cancellation. The first change type for newly added drawing changes includes drawing addition, drawing cancellation, drawing replacement, drawing import, and drawing export. The second change type includes drawing addition and drawing cancellation.
4. The EXCEL VBA-based change order generation system as described in claim 2, characterized in that: The modified content module includes a modified content button. When modifying newly added content, the modified content module receives the user's first selection operation on the newly added content and the user's second click operation on the modified content button. In response to the first selection operation and the second click operation, a second window corresponding to the current newly added content pops up, and the module receives the user's modification operation on the content in the second window, thereby realizing the modification of the newly added content.
5. The EXCEL VBA-based change order generation system as described in claim 2, characterized in that: The delete / modify content module includes a delete / modify content button. When deleting newly added content, the delete / modify content module receives a second selection operation from the user on the newly added content and a third click operation from the user on the delete / modify content button. In response to the second selection operation and the third click operation, a second window corresponding to the current newly added content pops up, and the module receives the user's delete operation on the content in the second window, thereby deleting the newly added content.
6. The EXCEL VBA-based change order generation system as described in claim 1, characterized in that: The change order generation module also includes a change order generation button, and the change order generation module receives a third click operation from the user on the change order generation button, and in response to the third click operation, first checks whether the cells to be filled in on the editing page are filled in completely. The change order module also formats the edit page after it has been filled out: it compares the number of rows occupied by all the new content in the change content column of the edit page with the preset value. If it is greater than the preset value, it will be paginated; otherwise, it will not be paginated, and all content belonging to the same new content will be kept on the same page. After typesetting, a change order that meets the requirements was obtained; The change order generation module also adds work protection to change orders that meet the requirements; The change order generation module also determines whether to display a prompt to the user and whether to generate a borrowing change notification.
7. The EXCEL VBA-based change order generation system as described in claim 6, characterized in that: When the module that generates the change order determines whether to display a prompt to the user, it operates as follows: The Change Order module queries the new content of each new drawing change. If the current new drawing change type is "Drawing Addition" and it is found that the drawing identifier in the new drawing change is borrowed from other projects, a prompt that the drawing cannot be added will be generated. If the change type of the newly added drawing is drawing replacement, obsolescence, move in, or move out, and no drawing identifier in the newly added drawing change is found to be borrowed by other projects, the change order module will generate a prompt that drawing replacement, obsolescence, move in, or move out cannot be performed. If the change type of the newly added drawing is drawing obsolescence, and it is found that the drawing identifier in the newly added drawing change is borrowed by other projects, the change order module will generate a prompt that if drawing obsolescence is required, please initiate the process in sync with other project changes. The change order generation module receives user input to select whether to modify the generated change order that meets the requirements, based on prompts.
8. The EXCEL VBA-based change order generation system as described in claim 6, characterized in that: When the module for generating change orders determines whether to generate a borrowing change notification, it operates as follows: If the usage column of the qualified change order shows "None", and the change order generation module finds that the new drawing change does not exist in other projects, then no borrowing change notification form will be generated. If the usage column of the qualified change order shows "None", and the change order generation module finds that the new drawing change is borrowed in other projects, then a borrowed part change notification form will be generated. If the usage column of the change order meets the requirements and shows "See Borrowed Parts Change Notice", and the change order generation module finds that the new drawing change does not exist in other projects, then a blank Borrowed Parts Change Notice will be generated. If the usage column of the change order meets the requirements and shows "See Borrowed Parts Change Notice", and the change order generation module finds that the new drawing change is borrowed in other projects, then a Borrowed Parts Change Notice will be generated. If the usage column of a qualified change order shows "None" or "Usability not checked," then it will not check whether the newly added drawing change is borrowed in other projects, and a borrowing change notification will not be generated.
9. The EXCEL VBA-based change order generation system as described in claim 2, characterized in that: The EXCEL VBA-based change order generation system also includes a change order modification module, which is used to return to the editing page based on user operations, and to delete generated change orders and borrowing change notifications that meet the requirements.
10. The EXCEL VBA-based change order generation system as described in claim 1, characterized in that: The EXCEL VBA-based change order generation system also includes a display interface module, which displays the editing page and the generated change order that meets the requirements. The interface also has a toolbar, and buttons for adding change content, adding change content above a specified position, modifying change content, deleting change content, generating change order, and modifying change order are integrated in the toolbar.