{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["常温测试","电压及电流","谐波抑制","杂波抑制","调制系数","功率及频率稳定度","噪声功率谱密度","相位噪声","功率(功率计)","测试信息"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"常温测试","index":0,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,1,1,18],[2,1,2,18],[3,11,3,12],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,6,4,6],[3,3,4,3],[3,4,4,4],[22,0,22,3],[22,4,22,5],[22,8,22,18],[3,5,4,5],[5,0,19,0],[21,1,21,18],[20,1,20,18],[3,2,4,2],[3,1,4,1],[3,0,4,0],[3,13,3,14],[3,8,4,8],[3,7,4,7],[3,9,3,10]]}
["(发射机)"]
["测试项目","常温测试"]
["技术要求","依据技术条件中表3的频率代码，逐一在信号源中输入，命令帧格式见技术条件中表2所示，其中的PL为一个字节的频率代码，启动发送后，应在频谱仪上看到与相应的设置理论中心频率对应的频谱，记录实际的中心频率，若|实际频率-理论频率|÷理论频率≤5 X 10-5，则中心频率满足指标要求。调制指数：0.7±0.1；功率：两路总和≥6W,功率不平度不大于1dB；杂波抑制：不小于50dB；谐波抑制：不小于50dB。"]
["产品编号","频率代码\nPL","设定频率\n（MHz）","发射机状态","供电电压\n（V）","消耗电流\n（A）","实际频率\n(MHz)","fH\n(MHz)","fL\n(MHz)","调制指数",null,"输出功率(W)",null,"输出功率(dBm)",null,"两路功率总和\n(W)","功率不平度\n(dB)","杂波抑制\n（dB）","谐波抑制\n(dB)"]
[{"$nulls":9},"ΩfH ","ΩfL",null,"XY1F","XY1E","XY1F"]
[{"$f":"'测试信息'!A2","v":1106},"01H",2238.5,"开启",{"$f":"'电压及电流'!Z2","v":27},{"$f":"'电压及电流'!AA2","v":0.76},{"$f":"'功率及频率稳定度'!Y2","v":0},null,null,null,{"$f":"'调制系数'!X2","v":0},{"$f":"'功率及频率稳定度'!D2","v":0},{"$f":"'功率及频率稳定度'!J2","v":0},{"$f":"'功率及频率稳定度'!F2","v":0},{"$f":"'功率及频率稳定度'!L2","v":0},{"$f":"'功率及频率稳定度'!Z2","v":0},{"$f":"'功率及频率稳定度'!AA2","v":{"$error":"#NUM!"}},{"$f":"'杂波抑制'!L2","v":0},{"$f":"'谐波抑制'!L2","v":0}]
[null,"02H",2220.5,"开启",{"$f":"'电压及电流'!Z3","v":0},{"$f":"'电压及电流'!AA3","v":0},{"$f":"'功率及频率稳定度'!Y3","v":0},null,null,null,{"$f":"'调制系数'!X3","v":0},{"$f":"'功率及频率稳定度'!D3","v":0},{"$f":"'功率及频率稳定度'!J3","v":0},{"$f":"'功率及频率稳定度'!F3","v":0},{"$f":"'功率及频率稳定度'!L3","v":0},{"$f":"'功率及频率稳定度'!Z3","v":0},{"$f":"'功率及频率稳定度'!AA3","v":{"$error":"#NUM!"}}]
[null,"03H",2226.5,"开启",{"$f":"'电压及电流'!Z4","v":0},{"$f":"'电压及电流'!AA4","v":0},{"$f":"'功率及频率稳定度'!Y4","v":0},null,null,null,{"$f":"'调制系数'!X4","v":0},{"$f":"'功率及频率稳定度'!D4","v":0},{"$f":"'功率及频率稳定度'!J4","v":0},{"$f":"'功率及频率稳定度'!F4","v":0},{"$f":"'功率及频率稳定度'!L4","v":0},{"$f":"'功率及频率稳定度'!Z4","v":0},{"$f":"'功率及频率稳定度'!AA4","v":{"$error":"#NUM!"}}]
[null,"04H",2286.5,"开启",{"$f":"'电压及电流'!Z5","v":0},{"$f":"'电压及电流'!AA5","v":0},{"$f":"'功率及频率稳定度'!Y5","v":0},null,null,null,{"$f":"'调制系数'!X5","v":0},{"$f":"'功率及频率稳定度'!D5","v":0},{"$f":"'功率及频率稳定度'!J5","v":0},{"$f":"'功率及频率稳定度'!F5","v":0},{"$f":"'功率及频率稳定度'!L5","v":0},{"$f":"'功率及频率稳定度'!Z5","v":0},{"$f":"'功率及频率稳定度'!AA5","v":{"$error":"#NUM!"}}]
[null,"05H",2250.5,"开启",{"$f":"'电压及电流'!Z6","v":0},{"$f":"'电压及电流'!AA6","v":0},{"$f":"'功率及频率稳定度'!Y6","v":0},null,null,null,{"$f":"'调制系数'!X6","v":0},{"$f":"'功率及频率稳定度'!D6","v":0},{"$f":"'功率及频率稳定度'!J6","v":0},{"$f":"'功率及频率稳定度'!F6","v":0},{"$f":"'功率及频率稳定度'!L6","v":0},{"$f":"'功率及频率稳定度'!Z6","v":0},{"$f":"'功率及频率稳定度'!AA6","v":{"$error":"#NUM!"}}]
[null,"06H",2280.5,"开启",{"$f":"'电压及电流'!Z7","v":0},{"$f":"'电压及电流'!AA7","v":0},{"$nulls":4},{"$f":"'调制系数'!X7","v":0},{"$f":"'功率及频率稳定度'!D7","v":0},{"$f":"'功率及频率稳定度'!J7","v":0},{"$f":"'功率及频率稳定度'!F7","v":0},{"$f":"'功率及频率稳定度'!L7","v":0},{"$f":"'功率及频率稳定度'!Z7","v":0},{"$f":"'功率及频率稳定度'!AA7","v":{"$error":"#NUM!"}}]
[null,"07H",2214.5,"开启",{"$f":"'电压及电流'!Z8","v":0},{"$f":"'电压及电流'!AA8","v":0},{"$f":"'功率及频率稳定度'!Y8","v":0},null,null,null,{"$f":"'调制系数'!X8","v":0},{"$f":"'功率及频率稳定度'!D8","v":0},{"$f":"'功率及频率稳定度'!J8","v":0},{"$f":"'功率及频率稳定度'!F8","v":0},{"$f":"'功率及频率稳定度'!L8","v":0},{"$f":"'功率及频率稳定度'!Z8","v":0},{"$f":"'功率及频率稳定度'!AA8","v":{"$error":"#NUM!"}}]
[null,"08H",2244.5,"开启",{"$f":"'电压及电流'!Z9","v":0},{"$f":"'电压及电流'!AA9","v":0},{"$f":"'功率及频率稳定度'!Y9","v":0},null,null,null,{"$f":"'调制系数'!X9","v":0},{"$f":"'功率及频率稳定度'!D9","v":0},{"$f":"'功率及频率稳定度'!J9","v":0},{"$f":"'功率及频率稳定度'!F9","v":0},{"$f":"'功率及频率稳定度'!L9","v":0},{"$f":"'功率及频率稳定度'!Z9","v":0},{"$f":"'功率及频率稳定度'!AA9","v":{"$error":"#NUM!"}}]
[null,"09H",2256.5,"开启",{"$f":"'电压及电流'!Z10","v":0},{"$f":"'电压及电流'!AA10","v":0},{"$f":"'功率及频率稳定度'!Y10","v":0},null,null,null,{"$f":"'调制系数'!X10","v":0},{"$f":"'功率及频率稳定度'!D10","v":0},{"$f":"'功率及频率稳定度'!J10","v":0},{"$f":"'功率及频率稳定度'!F10","v":0},{"$f":"'功率及频率稳定度'!L10","v":0},{"$f":"'功率及频率稳定度'!Z10","v":0},{"$f":"'功率及频率稳定度'!AA10","v":{"$error":"#NUM!"}}]
[null,"0AH",2262.5,"开启",{"$f":"'电压及电流'!Z11","v":0},{"$f":"'电压及电流'!AA11","v":0},{"$f":"'功率及频率稳定度'!Y11","v":0},null,null,null,{"$f":"'调制系数'!X11","v":0},{"$f":"'功率及频率稳定度'!D11","v":0},{"$f":"'功率及频率稳定度'!J11","v":0},{"$f":"'功率及频率稳定度'!F11","v":0},{"$f":"'功率及频率稳定度'!L11","v":0},{"$f":"'功率及频率稳定度'!Z11","v":0},{"$f":"'功率及频率稳定度'!AA11","v":{"$error":"#NUM!"}}]
[null,"0BH",2232.5,"开启",{"$f":"'电压及电流'!Z12","v":0},{"$f":"'电压及电流'!AA12","v":0},{"$f":"'功率及频率稳定度'!Y12","v":0},null,null,null,{"$f":"'调制系数'!X12","v":0},{"$f":"'功率及频率稳定度'!D12","v":0},{"$f":"'功率及频率稳定度'!J12","v":0},{"$f":"'功率及频率稳定度'!F12","v":0},{"$f":"'功率及频率稳定度'!L12","v":0},{"$f":"'功率及频率稳定度'!Z12","v":0},{"$f":"'功率及频率稳定度'!AA12","v":{"$error":"#NUM!"}}]
[null,"0CH",2274.5,"开启",{"$f":"'电压及电流'!Z13","v":0},{"$f":"'电压及电流'!AA13","v":0},{"$f":"'功率及频率稳定度'!Y13","v":0},null,null,null,{"$f":"'调制系数'!X13","v":0},{"$f":"'功率及频率稳定度'!D13","v":0},{"$f":"'功率及频率稳定度'!J13","v":0},{"$f":"'功率及频率稳定度'!F13","v":0},{"$f":"'功率及频率稳定度'!L13","v":0},{"$f":"'功率及频率稳定度'!Z13","v":0},{"$f":"'功率及频率稳定度'!AA13","v":{"$error":"#NUM!"}}]
[null,"0DH",2220.5,"开启",{"$f":"'电压及电流'!Z14","v":0},{"$f":"'电压及电流'!AA14","v":0},{"$f":"'功率及频率稳定度'!Y14","v":0},null,null,null,{"$f":"'调制系数'!X14","v":0},{"$f":"'功率及频率稳定度'!D14","v":0},{"$f":"'功率及频率稳定度'!J14","v":0},{"$f":"'功率及频率稳定度'!F14","v":0},{"$f":"'功率及频率稳定度'!L14","v":0},{"$f":"'功率及频率稳定度'!Z14","v":0},{"$f":"'功率及频率稳定度'!AA14","v":{"$error":"#NUM!"}}]
[null,"0EH",2208.5,"开启",{"$f":"'电压及电流'!Z15","v":0},{"$f":"'电压及电流'!AA15","v":0},{"$f":"'功率及频率稳定度'!Y15","v":0},null,null,null,{"$f":"'调制系数'!X15","v":0},{"$f":"'功率及频率稳定度'!D15","v":0},{"$f":"'功率及频率稳定度'!J15","v":0},{"$f":"'功率及频率稳定度'!F15","v":0},{"$f":"'功率及频率稳定度'!L15","v":0},{"$f":"'功率及频率稳定度'!Z15","v":0},{"$f":"'功率及频率稳定度'!AA15","v":{"$error":"#NUM!"}}]
[null,"0FH",2292.5,"开启",{"$f":"'电压及电流'!Z16","v":0},{"$f":"'电压及电流'!AA16","v":0},{"$f":"'功率及频率稳定度'!Y16","v":0},null,null,null,{"$f":"'调制系数'!X16","v":0},{"$f":"'功率及频率稳定度'!D16","v":0},{"$f":"'功率及频率稳定度'!J16","v":0},{"$f":"'功率及频率稳定度'!F16","v":0},{"$f":"'功率及频率稳定度'!L16","v":0},{"$f":"'功率及频率稳定度'!Z16","v":0},{"$f":"'功率及频率稳定度'!AA16","v":{"$error":"#NUM!"}}]
["备注"]
["结论","本页检验    台合格，    台不合格。"]
[{"$f":"\"检验员：\"&IF(LEN('测试信息'!B2)=3,'测试信息'!B2,'测试信息'!B2&\"  \")&\"               测试日期：\"","v":"检验员：李朵                 测试日期："},null,null,null,{"$f":"'测试信息'!C2","v":"2021-08-22"},null,null,null,{"$f":"\"温度：\"&'测试信息'!D2&\"                湿度：\"&MID('测试信息'!E2,1,2)&\"%\"","v":"温度：26℃                湿度：60%"}]
["检验员： ",{"$f":"'测试信息'!B2","v":"李朵"},"测试日期：",{"$f":"'测试信息'!C2","v":"2021-08-22"},"温度：",{"$f":"'测试信息'!D2","v":"26℃"},"湿度：",null,{"$f":"MID('测试信息'!E2,1,2)","v":"60"},null,"%"]

{"sheet":"电压及电流","index":1,"n_rows":79,"n_cols":27,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,null,"两通道电压最大值","两通道电流最大值"]
["通道1-电压测试-2238.5MHz",24,31,27,"是",{"$nulls":7},"通道1-电流测试-2238.5MHz",0.1,1.5,0.76,"是",{"$nulls":8},{"$f":"MAX(D2,J2)","v":27},{"$f":"MAX(P2,V2)","v":0.76}]
[{"$nulls":25},0,{"$f":"MAX(P3,V3)","v":0}]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},{"$f":"MAX(D34,J34)","v":0},0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},{"$f":"MAX(D66,J66)","v":0},0]
[{"$nulls":25},0,{"$f":"MAX(P67,V67)","v":0}]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]
[{"$nulls":25},0,0]

{"sheet":"谐波抑制","index":2,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过","2个通道15个频点最小值"]
[{"$nulls":11},{"$f":"MIN(D2:D16,J2:J16)","v":0}]

{"sheet":"杂波抑制","index":3,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过","2个通道15个频点最小值"]
[{"$nulls":11},{"$f":"MIN(D2:D16,J2:J16)","v":0}]

{"sheet":"调制系数","index":4,"n_rows":16,"n_cols":71,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过","返回偏离0.7最大的值","测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过"]
[{"$nulls":23},{"$f":"IF(ABS(D2-0.7)>ABS(J2-0.7),D2,J2)","v":0}]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]
[{"$nulls":23},0]

{"sheet":"功率及频率稳定度","index":5,"n_rows":32,"n_cols":27,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过","理论中心频率","偏离中心频率最大值","功率总和（W）","功率不平度(dB)"]
[{"$nulls":23},{"$f":"'常温测试'!C6","v":2238.5},{"$f":"IF(ABS(P2-X2)>ABS(V2-X2),P2,V2)","v":0},{"$f":"D2+J2","v":0},{"$f":"ROUND(ABS(10*LOG10(D2*1000)-10*LOG10(J2*1000)),2)","v":{"$error":"#NUM!"}}]
[{"$nulls":23},{"$f":"'常温测试'!C7","v":2220.5},{"$f":"IF(ABS(P3-X3)>ABS(V3-X3),P3,V3)","v":0},0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C8","v":2226.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C9","v":2286.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C10","v":2250.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C11","v":2280.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C12","v":2214.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C13","v":2244.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C14","v":2256.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C15","v":2262.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C16","v":2232.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C17","v":2274.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C18","v":2220.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C19","v":2208.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":23},{"$f":"'常温测试'!C20","v":2292.5},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},{"$f":"IF(ABS(P17-X17)>ABS(V17-X17),P17,V17)","v":0},0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":24},0,0,{"$error":"#NUM!"}]
[{"$nulls":25},0,{"$error":"#NUM!"}]
[{"$nulls":25},0,{"$error":"#NUM!"}]
[{"$nulls":25},0,{"$error":"#NUM!"}]

{"sheet":"噪声功率谱密度","index":6,"n_rows":1,"n_cols":23,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过"]

{"sheet":"相位噪声","index":7,"n_rows":1,"n_cols":23,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过"]

{"sheet":"功率(功率计)","index":8,"n_rows":2,"n_cols":23,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过",null,"测试名称","下限","上限","测试值","通过"]
["通道1-功率测试(功率计)(W)-2238.5MHz",3,999,0,"否"]

{"sheet":"测试信息","index":9,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["序列号","检验员","测试日期","温度","湿度"]
[1106,"李朵","2021-08-22","26℃","60%RH"]