Power system secondary equipment schematic diagram auxiliary wiring and material list generation method

Abstract

The application discloses a kind of power system secondary equipment schematic diagram auxiliary wiring and material list generation method, it is related to drawing design method field.Secondary design needs to complete a large amount of schematic diagram design in electric power design, cable connection, cable material list statistics, design process is complex, tedious, workload is big, drawing and material list generation efficiency is low.The process of the present application includes: establishing basic graphic file;preprocessing basic graphic file;complete schematic diagram wiring, input relevant circuit number;Realize the same type terminal number batch automatic pickup, complete single cable terminal wiring array;Input cable related parameters and combine cable parameters+ wiring array data information;Call function to establish excel file and write cable parameters+ wiring array in turn, finally summarized into material list.This method can conveniently improve the generation efficiency of drawing and material list, data is automatically imported into excel and classified statistics to generate cable material list.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of drawing design method, and particularly relates to a power system secondary equipment schematic diagram auxiliary wiring and material list generation method. BACKGROUND

[0002] At present, the secondary design of the power system has developed from manual drawing to CAD design software drawing, but the standard process and procedure of the drawing have not changed. There are many suppliers of secondary equipment of the power system, and the equipment schematic diagrams provided by the suppliers are designed according to the characteristics of the respective equipment. When designing the secondary drawings in the power design institute, it is necessary to integrate the drawings of various suppliers and realize the design intention.

[0003] The secondary design of the power design includes the cooperation of the electrical secondary professional and the system relay protection to complete the sampling of the current and voltage, the protection remote control tripping and the signal circuit design; and the cooperation with the dispatching automation professional to complete the current, voltage and signal circuit design, complete the design schematic diagram, cable numbering and cable material list, and the loop numbering, cable numbering and material list in the drawing of the electrical secondary schematic diagram are not unified in the design process, and are counted separately, and need to be repeatedly checked. When the loop numbering is input, the text command needs to be repeatedly input on the keyboard, and each core loop numbering needs to be marked on the drawing, which is complicated and rigid. When the cable specification and model are selected, the cable specification needs to be repeatedly confirmed and checked whether there is a design selection error.

[0004] Therefore, the secondary design needs to complete a large amount of schematic diagram design, cable connection, cable material list statistics, and the design process is complex, tedious and has a large workload, and the drawing and material list generation efficiency is low. SUMMARY

[0005] The technical problem to be solved and the technical task proposed by the present application are to perfect and improve the prior art, provide a power system secondary equipment schematic diagram auxiliary wiring and material list generation method, and improve the drawing and material list generation efficiency. To this end, the present application adopts the following technical scheme.

[0006] The power system secondary equipment schematic diagram auxiliary wiring and material list generation method comprises the following steps:

[0007] 1) integrating the secondary equipment schematic diagrams of various equipment, including the internal schematic diagram text information and the related terminal information, and establishing a basic text file;

[0008] 2) preprocessing the basic text file, and isolating and protecting the drawings and texts of the basic file through CAD layers;

[0009] 3) auxiliary completion of the schematic diagram wiring by calling functions and CAD system commands, and input of the related loop numbering;

[0010] 4) By picking up the terminal number, automatically recording the corresponding position, realizing the same type terminal number batch automatic picking, and completing the single cable wiring terminal wiring array;

[0011] 5) Call the cable parameter input window, input the cable related parameters, and combine the data information of the cable parameters + wiring array;

[0012] 6) Call the function to establish an excel file and write the header information, call the excel writing function, write the cable parameters + wiring array in turn according to each cable, and finally summarize the material list. Compared with full manual drawing and material list filling, this method can conveniently improve the generation efficiency of drawing and material list. The final data is automatically imported into excel, and the cable material list is generated by classification and statistics in excel, which is convenient for cable material purchase and cable laying construction.

[0013] As a preferred technical means: step 3) specifically includes the following steps:

[0014] 301) Determine whether it needs to be transferred through the terminal box. If it needs, execute step S302), if not, execute step S303);

[0015] 302) Manually add terminal box terminal information according to the layout on the base map;

[0016] 303) Realize the design function, select the device combination connection, and connect the functional terminals of two devices;

[0017] 304) Automatically switch to the drawing layer to realize functional connection isolation;

[0018] 305) Call the system PL command, select two devices for connection under the command prompt;

[0019] 306) After completing the connection, automatically switch to the text layer to realize the isolation of the loop numbering layer; 307) Under the command prompt, input the loop number and mark the loop number above the terminal connection of the two devices. Effectively realize the schematic wiring and related loop number input.

[0020] As a preferred technical means: step 4) specifically includes the following steps:

[0021] 401) Select two device terminal text information according to the command prompt column prompt;

[0022] 402) Respectively store the relative path information of the selected two device terminal data in the selected path variable;

[0023] 403) judge whether the next set of device terminal selection path is consistent with the current set of device terminal, if consistent, execute step 404), if inconsistent, return to execute step 402);

[0024] 404) directly call the current set of saved relative path;

[0025] 405) judge whether all cables of the device are completed, if not, call the loop function and return to step 301), if yes, execute step 406)

[0026] 406) record the number of loops for checking the number of cable cores, and establish a sub-list according to the loop number and the information structure of two device terminals;

[0027] 407) establish a wiring terminal array, combine and store the single-core sub-list data in the drawing order, and complete the storage of the single cable loop-terminal information array. The establishment of the cable loop-terminal information array is a necessary condition for the development of the automatic wiring program of the secondary installation drawing, which lays the foundation for realizing the automatic wiring of the installation drawing by providing related data.

[0028] As a preferred technical means: step 5) specifically includes the following steps:

[0029] 501) call the cable information input window program, and fill in the cable related parameters in the corresponding text box according to the design target requirements;

[0030] 502) use the number of loops in step 501) to check whether the cable parameters are input incorrectly;

[0031] 503) after completing the input of the cable parameters, establish a cable parameter sub-list and store it in a variable;

[0032] 504) combine the cable parameter list and the terminal array to form complete cable parameter + terminal array data information. Realize the input of the cable parameter + terminal array data information, and establish data basis for importing excel table later.

[0033] As a preferred technical means: step 6) specifically includes the following steps:

[0034] 601) before starting excel, detect whether excel has been started and activated, if not, execute 602), if yes, execute step 603);

[0035] 602) call vlisp and ActiveX functions to create an excel file and write excel table headers for cable statistics in the excel table;

[0036] 603) call the excel writing program to traverse the cable parameter + terminal array, write cable parameter information and terminal information in units of rows according to the table headers;

[0037] 604) judge whether the drawing and the list are completed, if yes, execute the next step, if no, return to step 301);

[0038] 605) complete the secondary principle diagram wiring, and generate the cable material list simultaneously. The cable parameter + terminal array data information is automatically imported into the excel table, so as to facilitate the automatic classification and statistics in the excel table.

[0039] Beneficial effects: compared with the manual drawing and the filling of the material list, the method can conveniently improve the generation efficiency of the drawing and the material list, and finally the data is automatically imported into the excel, the classification and statistics are generated in the excel, the classification and statistics in the excel are facilitated, and the method is convenient for the purchase of the cable material and the cable laying construction. BRIEF DESCRIPTION OF DRAWINGS

[0040] Figure 1 is the main process schematic diagram of the embodiment of the present application.

[0041] Figure 2 is the detailed process schematic diagram of the embodiment of the present application. DETAILED DESCRIPTION

[0042] The technical scheme of the present application will be further described in detail in combination with the drawings of the specification.

[0043] As shown in Figure 1 , the power system secondary equipment principle diagram auxiliary wiring and material list generation method, the process comprises the following steps: 2 S1) integrate the secondary equipment principle diagrams of various devices, the principle diagram content includes device internal schematic diagram text information and related terminal information, and establish a basic graphic and text file;

[0044] S2) pretreat the basic graphic and text file, mainly through calling the layer command, the graphics and texts of the basic graphic and text are isolated and protected through the layer, and meanwhile, the design drawing layer and the text layer are established on the basic graphic and text file, so as to realize the isolation of the manufacturer graphic and text and the design drawing graphic and text, and ensure that each layer is independent and does not affect each other;

[0045] S3) realize the principle diagram wiring through calling the function and the CAD system command, and input the related circuit number, which comprises the following process:

[0046] S301) judge whether the terminal box transfer is needed, if yes, execute step S302), if no, execute step S303);

[0047] S302) manually add the terminal box terminal information on the basis of the layout;

[0048] S303) automatically add the terminal box terminal information according to the layout.

[0049] S303) Realize the design function, select the device combination connection, connect the function terminals of two devices;

[0050] S304) When the main program is started by the command line call, the main program automatically switches to the drawing layer by calling the function and layer parameters, and realizes the function connection isolation;

[0051] S305) Call the system PL command, prompt the designer to select two devices according to the design intention for connection, in this example, the two devices are named as device A and device B;

[0052] S306) After completing the connection of device A and device B, automatically switch to the text layer to realize the isolation of the circuit numbering layer;

[0053] S307) Under the command prompt, input the circuit number, and mark the circuit number above the terminal connection of the two devices;

[0054] S4) By picking up the terminal number, automatically record the relevant corresponding position, realize the batch automatic picking of the same type terminal number, and complete the single cable terminal connection array, which specifically includes the following processes:

[0055] S401) Perform the terminal text information operation of selecting device A and device B according to the command prompt column prompt;

[0056] S402) Respectively store the relative path information of the terminal data of selected device A and device B, and save in the selected path variable;

[0057] S403) Judge whether the next group of device terminal selection path is consistent with device A and device B as the current group, if yes, execute step S404), if not, return to step S402);

[0058] S404) Directly call the relative path saved in the current group;

[0059] S405) Judge whether all cables of the device are completed, if not, call the loop function and return to step S301), if yes, execute step S406)

[0060] S406) Record the loop number for checking the cable core number, and establish a sub-list according to the circuit number-device A terminal information-device B terminal information structure;

[0061] S407) Establish the connection terminal array, store the single-core sub-list data according to the drawing order, and complete the storage of the device all single cable circuit-terminal information array;

[0062] S5) Call the cable parameter input window, input the cable related parameters, and combine the data information of the cable parameters and the connection array, which specifically includes the following processes:

[0063] S501) Call the cable information input window program, and input prompts according to the "interval, cable number, starting point, location, end point, location, cable model, cable specification, cable length, spare core number, remarks" window. In the corresponding text box, fill in the cable related parameters according to the design target requirements;

[0064] S502) Check whether the cable parameters are input incorrectly by the number of cycles in step S501). The "spare core number" in the table is automatically calculated and checked by the program, and does not need to be input. In the special case of internal connection function in the device, only the "starting point" data in the table needs to be input;

[0065] S503) After completing the cable parameter input, establish a cable parameter sub-list and store it in a variable;

[0066] S504) After completing steps S301)-S503), combine the cable parameter list and the terminal array to form complete cable parameter + terminal array data information;

[0067] S6) Call the function to establish an excel file and write the header information. Call the excel write function, write the cable parameter + wiring array one by one according to each cable, and finally summarize the material list, which includes the following processes:

[0068] S601) Before starting excel, detect whether excel has been started and activated. If not, execute S602). If yes, execute step S603)

[0069] S602) Call the vlisp and ActiveX functions to create a new excel file and write the following table headers for cable statistics in sheet1 table;

[0070]

[0071] S603) Call the excel write program to traverse the cable parameter + terminal array, write the cable parameter information and terminal information in units of rows according to the table headers. The length of the cable parameter array is fixed, and the length of the terminal array is variable;

[0072] S604) Determine whether the drawing and list are complete. If yes, execute the next step. If not, return to step S301);

[0073] S605) Complete the secondary principle diagram wiring, generate the cable material list simultaneously, and end.

[0074] The above Figure 1 、 2The power system secondary equipment schematic diagram auxiliary wiring and material list generation method shown is a specific embodiment of the present application, has embodied the outstanding substantial characteristics and the significant progress of the present application, can be according to actual use needs, under the inspiration of the present application, equivalent modification to its shape, structure and the like, all in the protection scope of the present scheme.

Claims

1. A method for generating auxiliary wiring and material lists for secondary equipment schematic diagrams in power systems, characterized in that... Includes the following steps: 1) Integrate the schematic diagrams of the secondary equipment of each device, including the internal schematic diagram information and related wiring terminal information, and establish basic schematic files; 2) Preprocess the basic graphic files, and isolate and protect the graphics and text in the basic files through CAD layers; 3) Complete the schematic wiring by calling functions and using CAD system commands, and input the relevant circuit numbers; 4) By picking up the terminal numbers, the corresponding positions are automatically recorded, enabling batch automatic picking of terminal numbers of the same type and completing the wiring array of a single cable terminal block; specifically, this includes the following steps: 401) Follow the prompts in the command prompt bar to select two device terminal text information operations; 402) Store the relative path information of the selected two device terminal data respectively, and save it in the selected path variable; 403) Determine whether the selection path of the next group of device terminals is consistent with that of the current group of device terminals. If they are consistent, proceed to step 404. If they are inconsistent, return to step 402. 404) Directly call the relative path saved in this group; 405) Determine if all cables for the equipment have been installed. If not, call the loop function and return to step 3; if yes, proceed to step 406). 406) Record the number of cycles to verify the number of cable cores, and create a sub-list based on the circuit number and the information of the two equipment terminals; 407) Establish a terminal block array, and store the single-core sub-list data in the order of drawing to complete the storage of the single cable loop-terminal information array; 5) Open the cable parameter input window, input the relevant cable parameters, and combine the data information of the cable parameters and wiring array; 6) Call the function to create an Excel file and write the header information. Call the Excel write function to write the cable parameters and wiring arrays one line for each cable, and finally summarize them into a material list.

2. The method for generating auxiliary wiring and material list of secondary equipment schematic diagrams in a power system according to claim 1, characterized in that: Step 3) specifically includes the following steps: 301) Determine whether it is necessary to transfer via the terminal box. If so, proceed to step S302. If not, proceed to step S303. 302) Terminal box terminal information is manually added to the basic drawing based on the layout; 303) To implement the design function, select the equipment combination connection and connect the function terminals of the two devices; 304) Automatically switch to the drawing layer to isolate functional connections; 305) Invoke the system PL command, and select two devices to connect at the command prompt; 306) After the connection is completed, it automatically switches to a text layer to isolate the loop number layer; 307) At the command prompt, enter the circuit number and mark the circuit number above the terminal connection lines on both sides of the device.

3. The method for generating auxiliary wiring and material list of secondary equipment schematic diagrams in a power system according to claim 1, characterized in that: Step 5) specifically includes the following steps: 501) Call the cable information input window program, and fill in the relevant cable parameters in the corresponding text boxes according to the design target requirements; 502) Use the number of iterations in step 501) to check if the cable parameters are entered incorrectly; 503) After completing the cable parameter input, create a sublist of cable parameters and store it in variables; 504) Combine the cable parameter list and terminal array to form complete cable parameter + terminal array data information.

4. The method for generating auxiliary wiring and material list of secondary equipment schematic diagrams in a power system according to claim 1, characterized in that: Step 6) specifically includes the following steps: 601) Before starting Excel, check if Excel is already started and activated. If not, proceed to 602). If yes, proceed to step 603). 602) Call VLISP and ActiveX functions to create a new Excel file, and write the Excel header for cable statistics into the Excel sheet; 603) Call the Excel writing program, traverse the cable parameter + terminal array, and write the cable parameter information and terminal information numbers according to the table header, row by row; 604) Determine if the drawings and inventory list are complete. If yes, proceed to the next step; otherwise, return to step 3). 605) The secondary schematic routing was completed, and a cable material list was generated simultaneously.

Images