摘要: |
通过分析宏编程统计和数据透视统计两种下料统计方法,大型复杂航天器电缆网适用于使用数据透视方法统计导线下料信息。详细陈述了数据透视统计导线下料的操作方法,同时结合函数自动计算,实现了导线下料的自动统计,极大提高了大型复杂航天器电缆网导线下料统计的质量与效率。 |
关键词: 导线下料统计;宏编程;数据透视;函数计算 |
基金项目: |
|
Research on Statistical Method of Wire Cutting for Large and Complex Spacecraft Cable Network |
Zhang Qin Xu Yanming Shi Yingying Luo Xiaoyi Ji Sailiu Liu Shuangbao Su Xianfa
|
Shanghai Aerospace Equipment Manufactory Co., Ltd.
|
Abstract: |
Through the study of macro programming and Pivot Table two statistical methods, the cable network of large and complex spacecraft is suitable to use the Pivot Table to count the information of wires, and the operation method of the PivotTable to count the number of wires is described in detail. Combined with function operation, the automatic statistics of wire cutting is realized. It greatly improves the quality and efficiency of wire cutting statistics for large and complex spacecraft cable network. |
Key words: statistical method of wire cutting;macro programming;Pivot Table;function operation |