Satellite power channel distribution method based on cable network digital design system
By adding an active equipment list and a power channel allocation table to the power distribution equipment interface data sheet, and combining Excel conditional formatting to implement power balance verification and automatically allocate satellite power channels, the time-consuming and difficult verification problems of traditional methods are solved, and efficient and accurate power channel design is achieved.
Patent Information
- Application Number
- CN202510626584.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-05-15
- Publication Date
- 2025-09-23
AI Technical Summary
Traditional satellite power channel allocation methods are labor-intensive and time-consuming, and inconsistent signal names make verification difficult, making it difficult to efficiently achieve automated interface connections in cable network digital design systems.
Add an active equipment list, power channel allocation table, and allocation file to the distribution equipment interface data sheet, implement power balance and primary/standby balance verification through Excel conditional formatting, automatically allocate load equipment to power channels, and convert the results into a cable network digital design system interface.
It improves the efficiency of satellite power channel allocation, reduces manual operations, increases design efficiency by more than 85%, and achieves 100% design accuracy.
Smart Images
Figure CN120688180A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to a satellite power channel distribution method based on a cable network digital design system, belonging to the field of satellite communications. Background Art
[0002] The low-frequency cable network is the channel for transmitting power, telemetry, remote control, and other signals within the spacecraft, connecting all active equipment within the spacecraft. Satellite low-frequency cable network design generally uses a digital design system, which automatically searches for two contacts with the same signal name in different devices. If so, the two contacts are connected together to form a signal transmission channel. If not, it is necessary to manually search for the contacts that should be connected, and force the connection of two contacts with inconsistent signal names. Therefore, the prerequisite for the efficient application of the cable network digital design system is that the signal names of each contact in the equipment interface data sheet must be accurate and compatible.
[0003] Satellite power distribution equipment (distribution equipment) is mostly commercialized. Its input is for high-power, limited-number energy input; its output is for low-power, limited-number energy output, powering the active loads onboard. The technical status of the distribution equipment is fixed, and the signal names in the device interface datasheet are fixed, commercialized names. However, the loads connected to the outputs are not fixed. Power channel allocation for these loads is based on the satellite's equipment configuration, layout, and primary / standby redundancy. Consequently, the signal names on the distribution equipment and connected loads may not be consistent.
[0004] Traditional power cable design methods manually allocate power channels based on constraints such as equipment layout, load primary and backup redundancy, and power balance among modules and connectors within the distribution equipment. This generates a power channel allocation file, which is then manually searched for connected load device contacts within the cable network digital design system. The connected contacts are then forcibly connected to the distribution equipment and the load devices. Single-star distribution systems can contain thousands of contacts, making traditional design methods labor-intensive and time-consuming. Furthermore, the signal names of the two forced connections are inconsistent, making verification difficult. Summary of the Invention
[0005] The technical problem solved by the present invention is: to overcome the shortcomings of the existing technology and propose a satellite power channel allocation method based on the cable network digital design system. The method improves the efficiency of satellite power channel allocation, opens up the transmission interface between power channel allocation and the cable network digital design system, reduces manual operations, and improves the design efficiency and accuracy of distribution power cables.
[0006] The technical solution of the present invention is: a satellite power channel allocation method based on a cable network digital design system, comprising:
[0007] Add three blank pages to the power distribution equipment interface data sheet, named Active Equipment List, Power Channel Allocation Table, and Power Channel Allocation File respectively;
[0008] Create a device table in the active device list, including the load device name, primary and backup, layout location, and power;
[0009] Establish channel allocation area and balance verification function area in the power channel allocation table;
[0010] Associate the active equipment list with the power channel allocation table, the power channel allocation table with the power channel allocation file, and the power channel allocation table with the distribution equipment interface data sheet:
[0011] Fill in the load equipment table in the active equipment list according to the model mission characteristics;
[0012] In accordance with the principles of power balance and active / standby balance, fill in the load device names in the active device list one by one in the load device name column in the power channel allocation table;
[0013] Check whether a warning color appears in the balance check function area of the power channel allocation table. If a warning color appears, adjust the power channel position where the load device name is located until the warning color disappears. At the same time, the design of the power channel allocation table and the distribution equipment interface data sheet is completed synchronously.
[0014] The power distribution equipment includes multiple modules with the same configuration, each module includes multiple electrical connectors, and the contact name in the power distribution equipment interface data sheet includes the module number and the channel number.
[0015] A channel allocation area is established in the power channel allocation table, including: extracting the module number, electrical connector code, electrical connector model, and power channel number from the distribution equipment interface data sheet; and setting up a blank table for filling in the load equipment name, primary and backup, power, and layout position corresponding to each power channel number.
[0016] A balance verification functional area is established in the power channel allocation table, including: aggregating the power of each power channel in the channel allocation area into the power of each module and each electrical connector, and establishing the balance verification functional area according to the rules that the main and backup power of each electrical connector is balanced and the load power of each module is lower than the distribution capacity.
[0017] According to the rule that the main and backup power of each electrical connector is balanced and the load power of each module is lower than the distribution capacity, a balance verification functional area is established, including: the main and backup power of each electrical connector and each module in the balance verification functional area, and the total power derived from the load device power of each electrical connector in the channel distribution area, and the judgment logic is established using the Excel conditional format function, specifically:
[0018] If the difference between the main power of the electrical connector and the main power of other electrical connectors is greater than the preset power, the background color of the power bar will turn orange.
[0019] If the backup power corresponding to the electrical connector differs from the backup power of other electrical connectors by more than the preset power, the background color of the power bar turns yellow;
[0020] When the load device power of each module of the power distribution equipment is greater than the rated power of the module, the background color of the power bar of the module turns red.
[0021] The active device list and the power channel allocation table are associated, including: the power channel allocation table retrieves the primary and backup, power, and layout positions corresponding to the same load device name in the active device list according to the principle of the same load device name.
[0022] The power channel allocation table and the power channel allocation file are associated, including: the power channel allocation file retrieves the load device name and load power corresponding to the same power channel number from the power channel allocation table according to the principle of the same power channel number.
[0023] Establish an association between the power channel allocation table and the distribution equipment interface data sheet, including: extracting the power channel number from the signal name of the distribution equipment interface data sheet, calling the load equipment name in the power channel allocation table according to the principle of consistency of the power channel number, and then replacing the power channel number in the signal name of each contact in the distribution equipment interface data sheet with the load equipment name in the power channel allocation table.
[0024] According to the principle of power balance and active / standby balance, the load device names in the device table in the active device list are filled in the load device name column in the power channel allocation table one by one, including:
[0025] Sort the load devices to be allocated according to the main power from large to small and the backup power from large to small;
[0026] For high-power load devices with a main power greater than or equal to 200W, fill the load device name in the load device name column of the power channel allocation table according to the principle of assigning one load device to each electrical connector;
[0027] For high-power load devices with a backup power of 200W or more, fill them in the load device name column of the electrical connector with the smallest load power. In each round, only one load device is assigned to an electrical connector of the power distribution device. If there are load devices left after a round of allocation, multiple rounds of allocation can be repeated to avoid assigning the same type of primary and backup devices to the same electrical connector of the power distribution device.
[0028] For low-power load devices with a power of less than 200W, the allocation is completed after the allocation of high-power load devices is completed using the same allocation method as that of high-power load devices.
[0029] Checking whether the balance check function area of the power channel allocation table has an orange, yellow or red warning color. If a warning color appears, adjust the power channel position where the load device name is located until the warning color disappears, including:
[0030] If an orange alarm appears, adjust the main load on the electrical connector with the largest main power to the electrical connector with the smallest main power, and repeat the above operation until the warning color disappears;
[0031] If a yellow alarm appears, adjust the backup load on the electrical connector with the largest backup power to the electrical connector with the smallest backup power, and repeat the above operation until the warning color disappears;
[0032] If a red alarm appears, adjust one of the load devices of the module to the minimum power module and repeat the above operation until the warning color disappears.
[0033] The advantages of the present invention compared with the prior art are:
[0034] The present invention applies a power distribution scheme that distributes load devices to power channels of power distribution equipment, which plays a role in simply and intuitively distributing power channels;
[0035] The present invention applies a real-time verification scheme for primary, backup and power balance, which plays a role in quickly, intuitively and evenly distributing the load power of the electrical connector / module of the power distribution equipment and the primary and backup load power;
[0036] The present invention applies a multi-page series connection scheme, which automatically converts the power channel allocation results into contact allocation and directly interfaces with the cable network digital design system, greatly improving design efficiency.
[0037] The present invention applies a multi-page serial connection solution to automatically convert the power channel allocation result into a traditional power channel allocation file, thereby achieving the effect of quickly generating a highly readable file.
[0038] The satellite power channel allocation method based on the cable network digital design system of the present invention has been applied to the development of multiple models. The results show that this method reduces a large amount of manual intervention in the design process, improves the design efficiency by more than 85%, and has a design accuracy rate of 100%. BRIEF DESCRIPTION OF THE DRAWINGS
[0039] Figure 1 Flowchart for building a power channel assignment tool.
[0040] Figure 2This is a flowchart for using the tool to perform power channel allocation. DETAILED DESCRIPTION
[0041] The present invention decomposes the purpose of power channel allocation into:
[0042] 1. Simply and intuitively assign active load devices to the power channels of the distribution equipment;
[0043] 2. Quickly respond to the load power of each electrical connector / module of the power distribution equipment and the balance status of the load power on each electrical connector;
[0044] 3. The power channel allocation results are automatically converted into contact allocation and directly interfaced with the cable network digital design system;
[0045] 4. The power channel allocation results are automatically converted into traditional power channel allocation files, which are easy for designers to read.
[0046] According to the above analysis, the data required for power channel allocation are: load device information (device name, primary / backup, layout location, power), power distribution device electrical interface information (module, electrical connector, channel, contact, etc.). The above purpose is achieved by using Excel multi-page data association operation. First, a power channel allocation tool needs to be built, such as Figure 1 As shown, the tool is then used to allocate power channels, as shown Figure 2 The specific implementation is as follows:
[0047] Step 1: Prepare the power distribution equipment interface data sheet. This sheet will be stored in an Excel file, with each electrical connector on a separate sheet. Name it "Power Channel Allocation Tool for a Certain Power Distribution Equipment." Create three blank sheets within the Excel file and place them before the power distribution equipment interface data sheet. The power distribution equipment interface data sheet will occupy sheets 4 to 9 (the number of sheets may vary depending on the specific power distribution equipment).
[0048] Step 2: Name sheet 1 "Active Device List". This list is a form for creating a dictionary of load device information. The format is shown in Table 1. Table 1 provides callable load device information for power channel allocation.
[0049] Table 1 Active equipment list
[0050] Load device name Primary Backup Layout Position Power / W
[0051] Step 3: Name sheet 2 "Power Channel Allocation Table" and fill in the module number, electrical connector code, power channel number, electrical connector model, and other contents from the power distribution equipment interface data sheet according to the format of Table 2. This sheet is the power channel allocation area.
[0052] Table 2 Power channel allocation area
[0053]
[0054] Step 4: In the blank area of Sheet 2, create a balance check function area according to the format of Table 3. The primary and backup power and total power of each module / connector in the table are derived from the power statistics column corresponding to each module / connector in the power channel allocation area of Table 2. Establish judgment logic that changes the background color of the power value to orange if the difference between the primary and backup power of each connector and the power of other connectors is greater than a predetermined power (e.g., 100W). To do this, use Conditional Formatting → Highlight Cells → Other Rules → Use the formula to determine the cells to be formatted. Enter =sumproduct(--(ABS(V***-$V$23:$V$30)>100)), where *** is the row number of the connector code and the formatting is orange. Similarly, establish judgment logic that changes the background color to yellow if the difference between the backup power of each connector exceeds a predetermined power (e.g., 200W). The module power overload judgment logic uses Conditional Formatting → Highlight Cells → Greater than Rated Power (e.g., 800W) and a red fill color.
[0055] Table 3 Balance check function area
[0056]
[0057] Step 5: Name sheet 3 "Power Channel Allocation File" and fill in the connector code, positive and negative contacts, and power channel number from the power distribution equipment interface data sheet into the sheet according to the format of Table 4;
[0058] Table 4 Power channel allocation file
[0059]
[0060] Step 6: Associate the active device list in Table 1 with the channel allocation area of the power channel allocation table in Table 2 based on the device name: For the load device name column corresponding to each power channel number in the power channel allocation area in Table 2, use a function to automatically call the primary / backup, power, and location information in the active device list in Table 1 based on the principle of consistency of the load device name;
[0061] Step 7: Associate the power channel allocation area in Table 2 with the power channel allocation file in Table 3 according to the power channel number: Based on the power channel number in the power channel allocation file in Table 3 and the principle of consistent power channel numbers, use the function to automatically call the load device name, power, and primary / backup in the power channel allocation area in Table 2;
[0062] Step 8. Associate the power channel allocation area in Table 2 with the power distribution equipment interface data sheet (sheet 4 to sheet 9) according to the power channel number. The format of the power distribution equipment interface data sheet is shown in Table 5. In the power distribution equipment interface data sheet, according to the signal name of each electrical connector contact, use the split and replace functions to extract the power channel information corresponding to the contact from the signal name. For example, for a primary bus output 1A and a primary bus output 1A return line, first replace "return line" with a blank, and split the signal name according to "out", and extract the power channel number: 1A; use the Vlookup function to search for the same power channel number in Table 2 for the power channel number of each contact, and retrieve the load device name corresponding to the power channel number in Table 2. The load device name + the original contact name (without the channel number) is the actual signal name of the contact, thereby achieving the effect of simultaneous implementation of contact allocation and power channel allocation.
[0063] Table 5 Distribution equipment interface data sheet
[0064] Electrical connector code X01-X03 Electrical connector model J6-50D01J Contact number Signal name Voltage Current 1 Primary bus output 1A 50 5 2 Primary bus output 1A loop 0 5 3 Primary bus output 2A 50 5 4 Primary bus output 2A return line 0 5 5 Primary bus output 3A 50 5 6 Primary bus output 3A return line 0 5
[0065] Step 9: Satellite power channel allocation. Taking a satellite designed and developed using this method as an example, the workflow is as follows: Figure 2 As shown, the specific implementation is as follows:
[0066] Step 9.1: Establish an active equipment list, collect and summarize the active load equipment information of the entire satellite, and form an active equipment list, as shown in Table 6.
[0067] Table 6 List of active equipment of a certain satellite
[0068] Device Name Primary Backup Layout Position Power / W Device 1 host north 200 Device 2 Preparation north 50 Device 3 host north 200 Device 4 host north 50 Device 5 host north 200 Device 6 Preparation South 50 Device 7 host South 200 Device 8 Preparation South 50
[0069] Step 9.2: Power channel allocation. Based on the principles of close distance between load equipment and distribution equipment, power balance, and primary and backup balance, the load equipment names in Table 6 are allocated one by one to the power channel allocation table of the north distribution equipment. The allocation method is: fill the load equipment name into the load equipment name column of the power channel allocation table. The primary and backup power and the layout position of the load equipment are automatically filled in according to the "Active Equipment List". As shown in Table 7, the layout position of channel 22A in the figure is red, indicating that the position of the load in this channel is different from that of the distribution equipment. The correctness of the power channel allocation should be checked.
[0070] Table 7 Power channel allocation table of a satellite
[0071]
[0072] In step 9.3, check the active / standby power balance. Check the balance check area of the power channel assignment table for a warning color. For example, the balance check area after the power channel assignment is shown in Table 8. If the difference between the active / standby power of X03 and X09 in Table 8 is greater than 100W, the active / standby power of both connectors will be displayed in orange. Adjust the load device assignment to the power channel until the warning color disappears, completing the power channel assignment.
[0073] Table 8 Balance check area of a satellite
[0074]
[0075] Power channel allocation files and distribution equipment interface data sheets are automatically generated in real time based on the power channel allocation results, and are directly interfaced with the satellite file management system and cable network digital design system to achieve intelligent power channel allocation.
[0076] Although the present invention has been disclosed above in terms of preferred embodiments, it is not intended to limit the present invention. Any person skilled in the art may make possible changes and modifications to the technical solutions of the present invention using the technical contents disclosed above without departing from the spirit and scope of the present invention. Therefore, any simple modifications, equivalent changes, and modifications made to the above embodiments based on the technical essence of the present invention without departing from the content of the technical solutions of the present invention shall fall within the scope of protection of the technical solutions of the present invention.
Claims
1. A satellite power channel allocation method based on a cable network digital design system, characterized in that: include: The power distribution equipment includes multiple modules with the same configuration, each module includes multiple electrical connectors, and the contact name in the power distribution equipment interface data sheet includes the module number and the channel number; Add three blank pages to the power distribution equipment interface data sheet, named Active Equipment List, Power Channel Allocation Table, and Power Channel Allocation File respectively; Create a load device table in the active device list, including the load device name, primary and backup, layout location, and power; Establish channel allocation area and balance verification function area in the power channel allocation table; Establish associations between the active equipment list and the power channel allocation table, the power channel allocation table and the power channel allocation file, and the power channel allocation table and the distribution equipment interface data sheet; Fill in the load equipment table in the active equipment list according to the model mission characteristics; In accordance with the principles of power balance and active / standby balance, fill in the load device names in the active device list one by one in the load device name column in the power channel allocation table; Check whether there is an alarm in the balance check function area of the power channel allocation table. If an alarm occurs, adjust the power channel position where the load device name is located until the alarm is eliminated. The design of the power channel allocation table and the distribution equipment interface data sheet is completed synchronously.
2. The satellite power channel allocation method based on the cable network digital design system according to claim 1, characterized in that: A channel allocation area is established in the power channel allocation table, including: extracting the module number, electrical connector code, electrical connector model, and power channel number from the distribution equipment interface data sheet; and setting up a blank table for filling in the load equipment name, primary and backup, power, and layout position corresponding to each power channel number.
3. The satellite power channel allocation method based on the cable network digital design system according to claim 1, characterized in that: A balance verification functional area is established in the power channel allocation table, including: aggregating the power of each power channel in the channel allocation area into the power of each module and each electrical connector, and establishing the balance verification functional area according to the rules that the main and backup power of each electrical connector is balanced and the load power of each module is lower than the distribution capacity.
4. The satellite power channel allocation method based on the cable network digital design system according to claim 3 is characterized in that: According to the rule that the main and backup power of each electrical connector is balanced and the load power of each module is lower than the distribution capacity, a balance verification functional area is established, including: the main and backup power of each electrical connector and each module in the balance verification functional area and the total power are derived from the load device power included in each electrical connector in the channel distribution area. The Excel conditional format function is used to establish the judgment logic, specifically: If the difference between the main power of the electrical connector and the main power of other electrical connectors is greater than the preset power, the background color of the power bar will turn orange. If the backup power corresponding to the electrical connector differs from the backup power of other electrical connectors by more than the preset power, the background color of the power bar turns yellow; When the load power of a module in the power distribution equipment is greater than the rated power of the module, the power bar of the module turns red.
5. The satellite power channel allocation method based on the cable network digital design system according to claim 1, characterized in that: The active device list and the power channel allocation table are associated, including: the power channel allocation table retrieves the primary and backup, power, and layout positions corresponding to the same load device name in the active device list according to the principle of the same load device name.
6. The satellite power channel allocation method based on the cable network digital design system according to claim 1, characterized in that: The power channel allocation table and the power channel allocation file are associated, including: the power channel allocation file retrieves the load device name and load power corresponding to the same channel number from the power channel allocation table according to the principle of the same power channel number.
7. The satellite power channel allocation method based on the cable network digital design system according to claim 1, characterized in that: Establish an association between the power channel allocation table and the distribution equipment interface data sheet, including: extracting the power channel number from the signal name of the distribution equipment interface data sheet, calling the load equipment name in the power channel allocation table according to the principle of consistency of the power channel number, and then replacing the power channel number in the signal name of each contact in the distribution equipment interface data sheet with the load equipment name in the power channel allocation table.
8. The satellite power channel allocation method based on the cable network digital design system according to claim 4 is characterized in that: According to the principle of power balance and active / standby balance, the load device names in the device table in the active device list are filled in the load device name column in the power channel allocation table one by one, including: Sort the load devices to be allocated according to the main power from large to small and the backup power from large to small; For high-power load devices with a primary power of 200W or greater, the load device name is assigned to each electrical connector according to the principle of assigning one load device to each connector. For high-power load devices with a backup power of 200W or greater, it is assigned to the load device name column of the electrical connector with the smallest load power. Only one load device is assigned to one electrical connector of the power distribution device in each round. If there are any load devices left after a round of allocation, multiple rounds of allocation can be repeated to avoid assigning the same type of primary and backup devices to the same electrical connector of the power distribution device. For low-power load devices with a power of less than 200W, the allocation is completed after the allocation of high-power load devices is completed using the same allocation method as that of high-power load devices.
9. The satellite power channel allocation method based on the cable network digital design system according to claim 8, characterized in that: Check whether there is an orange, yellow or red alarm in the balance check function area of the power channel allocation table. If an alarm occurs, adjust the power channel position where the load device name is located until the alarm is eliminated, including: If an orange alarm appears, adjust the main load on the electrical connector with the largest main power to the electrical connector with the smallest main power, and repeat the above operation until the warning color disappears; If a yellow alarm appears, adjust the backup load on the electrical connector with the largest backup power to the electrical connector with the smallest backup power, and repeat the above operation until the warning color disappears; If a red alarm appears, adjust one of the load devices of the module to the module with the smallest load power, and repeat the above operation until the warning color disappears.