变压器直流电阻、变压比Excel自己计算公式

3档高压位置123低压位置数值ABaoBCboCAco线差(%)#DIV/0!#DIV/0!#DIV/0!相差(%)#DIV/0!5档高压位置12345低压位置数值ABBCCA线差(%)#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!相差(%)#DIV/0!9档高压位置123456789低压位置数值ABaoBCboCAco线差(%)#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!相差(%)#DIV/0!3档高压位置123低压位置数值AB1.421.3441.2709ao0.0011624BC1.42241.34631.2732bo0.0011953CA1.4221.34591.2723co0.0011839线差(%)0.170.170.18相差(%)2.795档高压位置12345低压位置数值ABBCCA线差(%)#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!相差(%)#DIV/0!9档高压位置123456789低压位置数值ABaoBCboCAco线差(%)#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!相差(%)#DIV/0!高压（kV）低压（kV）100004003档(Uh±0.5kV)/Ul档位1档2档3档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值26.2526.2526.2525.0025.0025.0023.7523.7523.75变压比测量值比差%100.00100.00100.00100.00100.00100.00100.00100.00100.005档(Uh±0.25kV)/Ul档位1档2档3档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值26.2526.2526.2525.6325.6325.6325.0025.0025.00变压比测量值比差%100.00100.00100.00100.00100.00100.00100.00100.00100.00档位4档5档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值24.3824.3824.3823.7523.7523.75变压比测量值比差%100.00100.00100.00100.00100.00100.009档(Ug±0.25kV)/Ul档位1档2档3档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值27.5027.5027.5026.8826.8826.8826.2526.2526.25变压比测量值比差%100.00100.00100.00100.00100.00100.00100.00100.00100.00档位4档5档6档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值25.6325.6325.6325.0025.0025.0024.3824.3824.38变压比测量值比差%100.00100.00100.00100.00100.00100.00100.00100.00100.00档位7档8档9档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值23.7523.7523.7523.1323.1323.1322.5022.5022.50变压比测量值比差%100.00100.00100.00100.00100.00100.00100.00100.00100.00特殊变比值的计算请分别输入各个档位的电压比（Uh/Ul）1档2档3档4档5档高压（kV）低压（kV）高压（kV）低压（kV）高压（kV）低压（kV）高压（kV）低压（kV）高压（kV）低压（kV）6档7档8档9档高压（kV）低压（kV）高压（kV）低压（kV）高压（kV）低压（kV）高压（kV）低压（kV）3档档位1档2档3档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变压比测量值比差%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!5档档位1档2档3档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变压比测量值比差%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!档位4档5档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变压比测量值比差%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!9档档位1档2档3档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变压比测量值比差%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!档位4档5档6档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变压比测量值比差%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!档位7档8档9档测量位置AB/abBC/bcCA/caAB/abBC/bcCA/caAB/abBC/bcCA/ca变压比标准值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变压比测量值比差%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!