Начало Каталог Помощ
Регистрация Вход
zhouyang.xie
/
guanlan-src
1
0
Разклонения 0
Файлове Задачи 0 Заявки за сливане 0 Уики
ИН на ревизия: ff17c6d6ba
Клонове Маркери
guanlan-src
/
app_ETL
/
configs
/
contracts
/
unknown_2p0mw_shangdu.yaml

unknown_2p0mw_shangdu.yaml 23 KB
История Директен файл

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 
  1. # 数据契约 — 商都风电场 (内蒙古, 国网) — OEM未定 2.0MW级 齿驱DFIG, 13台(1-11,13,19号)
    2. 

  2. # OEM=未定 (禁猜): 控制器标签 C11_5, 通道命名指纹 (C11_5/.Glo.Con.Cab[].GscIgbTemMax / LscIgbTemMax /
    3. 

  3. #   WatCooPlaTem / .Glo.Gen.Wnd001/002TemU/V/W (双三相绕组) / .Glo.Gea.RotBeaTemMax / GscEncMnt) 混
    4. 

  4. #   GBK中文列 (风速/风向/桨叶角度/齿轮箱油温...) → 未匹配库内任一已知OEM指纹。onboard推断勿当定谳,
    5. 

  5. #   出实名报告前须业主铭牌确认 (memory oem-id-channel-naming-fingerprint)。
    6. 

  6. # rated=2000kW data-first: 电网有功功率 T1全年 p99=2000.1 / plateau ~2000 / max2050-2211=瞬时boost(+5~10%);
    7. 

  7. #   10分钟发电量 max342kWh ≈ 2050×(1/6)h 自洽; 齿比≈102 (发电机速度p99≈1600rpm / 转速p99≈15.7rpm) → geared DFIG。
    8. 

  8. # G-OEM 实证 (2026-07-17, scratchpad/{shangdu_loader,assemble,colstats}; 13台×364日转置xlsx全跑):
    9. 

  9. #   格式=TRANSPOSED (行=信号120, 列=144个10-min时段, 末列Source name=信号源路径非台号); 装配须转置。
    10. 

  10. #   真采样率=600s (每列=10-min时段, 转置后 t.diff=600 by construction + 各文件本地锚一致; 禁全局median)。
    11. 

  11. #   时间: 本地(UTC+8) = UTC列+8h; 装配用 登录时间(当地) 锚定日期 + 时段起始 → time_local (区间起)。
    12. 

  12. #   台号: zip/文件夹号 (内部无台名列, 仅Source name=信号路径) → id=zip号 (1-11,13,19; 缺12,14-18)。
    13. 

  13. #   哨兵: -9999 (发电机轴承DE/NDE) + -274.15 (abs-zero style, 绕组/冷却水/齿箱油温族/机舱柜/加热器等温度族);
    14. 

  14. #          机舱位置负值(-700)=真累积编码器非哨兵 → 无温度哨兵。
    15. 

  15. #   self_ref: 风速=机舱风速计 → 绝对功率曲线/Cp/达成率 INSUFFICIENT (无测风塔)。
    16. 

  16. #   风向名实: 风向=机舱相对对风误差(±180); 风向/北≡wrap(机舱位置+风向) 94.5%<0.5° = 派生地理非独立传感器
    17. 

  17. #          (memory pseudo-geo-wind-direction-identity-test)。
    18. 

  18. schema_version: 2
    19. 

  19. meta:
    20. 

  20.   oem: "未定 (控制器标签 C11_5; 通道指纹不匹配库内已知场; 待铭牌/业主确认)"
    21. 

  21.   model: "未定 2.0MW级 (齿驱DFIG; 双三相绕组 Wnd001/002; GSC/LSC变频器; 齿比≈102)"
    22. 

  22.   rated_kw: 2000
    23. 

  23.   rated_note: "data-first: 有功p99=2000/plateau2000/max2211瞬时boost; 发电量max342≈2050×1/6自洽; 铭牌型号未交付 UNVERIFIED"
    24. 

  24.   n_turbines: 13
    25. 

  25.   n_with_data: 13
    26. 

  26.   farm: shangdu
    27. 

  27.   site: 内蒙古 商都 (国网)
    28. 

  28.   topology: geared_DFIG
    29. 

  29.   owner: UNVERIFIED (国网; 铭牌未交付)
    30. 

  30.   self_ref_risk: true
    31. 

  31.   windows:
    32. 

  32.     turbine_10min: "2023-01-01~2023-12-31 (全年10-min; T1 364日52074行; 全台306-365日; T8含1日2024-02-23 spillover)"
    33. 

  33. 

  34. turbine_10min:
    35. 

  35.   sampling_s: 600
    36. 

  36.   machine_col: turbine_id
    37. 

  37.   required: ["电网有功功率 - 平均值 [千瓦]", "风速 - 平均值 [米/秒]"]
    38. 

  38.   columns:
    39. 

  39.     time_local: {role: timestamp, canonical_id: TIME_local, note: "本地时(UTC+8)区间起; 装配自 登录时间(当地)锚+时段起始"}
    40. 

  40.     "10分钟发电量 - 总计 [千瓦时]": {valid_range: [-20, 400], observed_range: [-1.5, 342.24], sentinel: [], canonical_id: WAPC_energy_10min, note: "区间量(kWh/10min), data-first: E×6/P=1.0000精确 → =有功平均×1/6h, 非累计counter"}
    41. 

  41.     "10分钟消耗电量 - 总计 [千瓦时]": {valid_range: [0, 60], observed_range: [0.19, 7.7], sentinel: [], canonical_id: WAPC_energy_consumed_10min, note: "区间自耗电量"}
    42. 

  42.     "C11_5/.Glo.CabCon.Cab[2].CabTem001 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [6.0, 59.31], sentinel: [], canonical_id: WCNV_cabinet_temp_1}
    43. 

  43.     "C11_5/.Glo.CabCon.Cab[2].CabTem002 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [5.11, 55.0], sentinel: [], canonical_id: WCNV_cabinet_temp_2}
    44. 

  44.     "C11_5/.Glo.Con.Cab[1].GscIgbTemMax - 平均值 [摄氏度]": {valid_range: [-45, 180], observed_range: [0.0, 167.0], sentinel: [], canonical_id: WCNV_gsc_igbt_temp_1, note: "网侧变频器IGBT温 ⑦轴 (Cab1); 变频器internal analog"}
    45. 

  45.     "C11_5/.Glo.Con.Cab[1].LscIgbTemMax - 平均值 [摄氏度]": {valid_range: [-45, 180], observed_range: [0.0, 167.0], sentinel: [], canonical_id: WCNV_lsc_igbt_temp_1, note: "机侧/线侧变频器IGBT温 (Cab1)"}
    46. 

  46.     "C11_5/.Glo.Con.Cab[1].WatCooPlaTem - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [0.0, 53.74], sentinel: [], canonical_id: WCNV_water_plate_temp_1, note: "变频器水冷板温 (Cab1)"}
    47. 

  47.     "C11_5/.Glo.Con.Cab[2].GscIgbTemMax - 平均值 [摄氏度]": {valid_range: [-45, 180], observed_range: [14.18, 153.44], sentinel: [], canonical_id: WCNV_gsc_igbt_temp_2, note: "网侧IGBT (Cab2)"}
    48. 

  48.     "C11_5/.Glo.Con.Cab[2].LscIgbTemMax - 平均值 [摄氏度]": {valid_range: [-45, 180], observed_range: [14.32, 167.0], sentinel: [], canonical_id: WCNV_lsc_igbt_temp_2, note: "机侧IGBT (Cab2)"}
    49. 

  49.     "C11_5/.Glo.Con.Cab[2].WatCooPlaTem - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [10.0, 54.01], sentinel: [], canonical_id: WCNV_water_plate_temp_2}
    50. 

  50.     "C11_5/.Glo.Gen.Wnd001TemU00Max - 平均值 [摄氏度]": {valid_range: [-45, 200], observed_range: [11.69, 394.09], sentinel: [-274.15], canonical_id: WGEN_winding1_u, note: "双三相绕组1 U相; F级155℃阈; max394=spike已界外NaN"}
    51. 

  51.     "C11_5/.Glo.Gen.Wnd001TemV00Max - 平均值 [摄氏度]": {valid_range: [-45, 200], observed_range: [10.57, 129.15], sentinel: [-274.15], canonical_id: WGEN_winding1_v}
    52. 

  52.     "C11_5/.Glo.Gen.Wnd001TemW00Max - 平均值 [摄氏度]": {valid_range: [-45, 200], observed_range: [11.76, 143.34], sentinel: [-274.15], canonical_id: WGEN_winding1_w}
    53. 

  53.     "C11_5/.Glo.Gen.Wnd002TemU00Max - 平均值 [摄氏度]": {valid_range: [-45, 200], observed_range: [11.15, 134.5], sentinel: [-274.15], canonical_id: WGEN_winding2_u, note: "双三相绕组2 U相"}
    54. 

  54.     "C11_5/.Glo.Gen.Wnd002TemV00Max - 平均值 [摄氏度]": {valid_range: [-45, 200], observed_range: [10.02, 132.44], sentinel: [-274.15], canonical_id: WGEN_winding2_v}
    55. 

  55.     "C11_5/.Glo.Gen.Wnd002TemW00Max - 平均值 [摄氏度]": {valid_range: [-45, 200], observed_range: [10.81, 145.06], sentinel: [-274.15], canonical_id: WGEN_winding2_w}
    56. 

  56.     "PLC之前慢速状态 - 最大": {role: status, observed_range: [0.0, 15.0], sentinel: [], canonical_id: WSHD_PLC之前慢速状态}
    57. 

  57.     "PLC之前慢速状态 - 最小": {role: status, observed_range: [0.0, 13.0], sentinel: [], canonical_id: WSHD_PLC之前慢速状态}
    58. 

  58.     "PLC状态 - 最大": {role: status, observed_range: [0.0, 15.0], sentinel: [], canonical_id: WSHD_PLC状态}
    59. 

  59.     "PLC状态 - 最小": {role: status, observed_range: [0.0, 13.0], sentinel: [], canonical_id: WSHD_PLC状态}
    60. 

  60.     "偏航变频器功率 - 平均值 [千瓦]": {valid_range: [-1, 40], observed_range: [0.0, 12.61], sentinel: [], canonical_id: WYAW_converter_power}
    61. 

  61.     "偏航变频器功率 - 最大 [千瓦]": {valid_range: [-1, 40], observed_range: [0.0, 18.5], sentinel: [], canonical_id: WYAW_converter_power_max}
    62. 

  62.     "功率曲线有效性 - 最大": {role: status, observed_range: [0.0, 3.0], sentinel: [], canonical_id: WSHD_功率曲线有效性}
    63. 

  63.     "功率曲线有效性 - 最小": {role: status, observed_range: [0.0, 3.0], sentinel: [], canonical_id: WSHD_功率曲线有效性}
    64. 

  64.     "动态安全链状态 - 最大": {role: status, observed_range: [1.0, 14.0], sentinel: [], canonical_id: WSHD_动态安全链状态}
    65. 

  65.     "动态安全链状态 - 最小": {role: status, observed_range: [1.0, 14.0], sentinel: [], canonical_id: WSHD_动态安全链状态}
    66. 

  66.     "发电机冷却水入口温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-10.61, 59.05], sentinel: [-274.15], canonical_id: WGEN_coolant_inlet_temp, note: "发电机冷却水入口=发电机轴承热汇"}
    67. 

  67.     "发电机冷却水入口温度 - 最大 [摄氏度]": {valid_range: [-45, 120], observed_range: [-10.27, 365.61], sentinel: [-274.15], canonical_id: WGEN_coolant_inlet_temp_max}
    68. 

  68.     "发电机扼流圈温度 - 平均值 [摄氏度]": {valid_range: [-45, 180], observed_range: [0.0, 126.23], sentinel: [], canonical_id: WGEN_choke_temp_1, note: "发电机扼流圈(重名双通道之1)"}
    69. 

  69.     "发电机扼流圈温度 - 平均值 [摄氏度]#dup1": {valid_range: [-45, 180], observed_range: [0.0, 140.42], sentinel: [], canonical_id: WGEN_choke_temp_2, note: "重名双通道之2 (装配去重加#dup1)"}
    70. 

  70.     "发电机轴承非驱动端温度 - 平均值 [摄氏度]": {valid_range: [-45, 150], observed_range: [7.91, 94.8], sentinel: [-9999], canonical_id: WGEN_brg_nde_temp, note: "fleet基线 NDE>DE (p99 78 vs 55); 反对称必过 swap-test (memory scada-residual-claim-discipline)"}
    71. 

  71.     "发电机轴承驱动端温度 - 平均值 [摄氏度]": {valid_range: [-45, 150], observed_range: [5.87, 92.05], sentinel: [-9999], canonical_id: WGEN_brg_de_temp, note: "热汇=发电机冷却系统; 冷浸参照勿配; NBM"}
    72. 

  72.     "发电机速度 - 平均值 [转/分]": {valid_range: [-100, 2000], observed_range: [-1.28, 1601.28], sentinel: [-274.15], canonical_id: WGEN_speed, note: "DFIG齿驱; p99≈1600rpm; 齿比≈102 vs 转速"}
    73. 

  73.     "发电机速度 - 最大 [转/分]": {valid_range: [-100, 2000], observed_range: [0.0, 1798.5], sentinel: [], canonical_id: WGEN_speed_max}
    74. 

  74.     "发电机速度 - 最小 [转/分]": {valid_range: [-100, 2000], observed_range: [-28.0, 1597.5], sentinel: [], canonical_id: WGEN_speed_min}
    75. 

  75.     "变频器状态 - 最大": {role: status, observed_range: [1.0, 500.0], sentinel: [], canonical_id: WSHD_变频器状态}
    76. 

  76.     "变频器状态 - 最小": {role: status, observed_range: [1.0, 20.0], sentinel: [], canonical_id: WSHD_变频器状态}
    77. 

  77.     "叶片1变频器内部温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-2.82, 72.99], sentinel: [], canonical_id: WROT_blade_converter_temp_1, note: "真3叶执行器热(每叶独立变频器)"}
    78. 

  78.     "叶片2变频器内部温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-2.59, 72.42], sentinel: [], canonical_id: WROT_blade_converter_temp_2}
    79. 

  79.     "叶片3变频器内部温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-2.11, 71.35], sentinel: [], canonical_id: WROT_blade_converter_temp_3}
    80. 

  80.     "塔筒温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-6.94, 40.24], sentinel: [], canonical_id: WTWR_tower_temp}
    81. 

  81.     "安全链状态 - 最大": {role: status, observed_range: [1.0, 14.0], sentinel: [], canonical_id: WSHD_安全链状态}
    82. 

  82.     "安全链状态 - 最小": {role: status, observed_range: [1.0, 14.0], sentinel: [], canonical_id: WSHD_安全链状态}
    83. 

  83.     "机舱位置 - 平均值": {frame: accumulated_encoder, valid_range: [-720, 720], observed_range: [156.73, 700.51], sentinel: [], canonical_id: WYAW_nacelle_position_accum, note: "累积偏航编码器(±700, 非地理0-360方位); 解缆量, 勿当bearing算对中; 无温度哨兵(负值真)"}
    84. 

  84.     "机舱位置偏差 - 平均值 [度]": {frame: nacelle_relative, valid_range: [-180, 180], observed_range: [-118.98, 177.04], sentinel: [], canonical_id: WYAW_position_deviation, note: "对风误差(±180); ≈风向 corr0.99"}
    85. 

  85.     "机舱柜1温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-1.1, 45.06], sentinel: [-274.15], canonical_id: WNAC_cabinet1_temp, note: "机舱柜2温度 fleet全死(未映射)"}
    86. 

  86.     "机舱温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-2.66, 46.71], sentinel: [-274.15], canonical_id: WNAC_temp}
    87. 

  87.     "桨叶1角度 - 平均值 [度]": {valid_range: [-15, 95], observed_range: [-0.01, 91.5], sentinel: [], canonical_id: WROT_pitch_angle_1, note: "3叶片传感器但集距控制(collective): below-rated发电态3叶极差p95=0.04°<1° → 非IPC; 每叶独立变频器温=3物理驱动"}
    88. 

  88.     "桨叶1角度 - 最小 [度]": {valid_range: [-15, 95], observed_range: [-0.02, 91.44], sentinel: [], canonical_id: WROT_pitch_min_1}
    89. 

  89.     "桨叶2角度 - 平均值 [度]": {valid_range: [-15, 95], observed_range: [-0.01, 91.1], sentinel: [], canonical_id: WROT_pitch_angle_2}
    90. 

  90.     "桨叶2角度 - 最小 [度]": {valid_range: [-15, 95], observed_range: [-0.02, 91.1], sentinel: [], canonical_id: WROT_pitch_min_2}
    91. 

  91.     "桨叶3角度 - 平均值 [度]": {valid_range: [-15, 95], observed_range: [-0.01, 91.55], sentinel: [], canonical_id: WROT_pitch_angle_3}
    92. 

  92.     "桨叶3角度 - 最小 [度]": {valid_range: [-15, 95], observed_range: [-0.02, 91.55], sentinel: [], canonical_id: WROT_pitch_min_3}
    93. 

  93.     "油泵压力 - 平均值 [巴]": {valid_range: [-8, 16], observed_range: [0.14, 13.41], sentinel: [], canonical_id: WPMP_oil_pressure, note: "-6.25=传感器噪声地板, 界宽保留"}
    94. 

  94.     "环境温度 - 平均值 [摄氏度]": {valid_range: [-50, 55], observed_range: [-24.44, 46.5], sentinel: [], canonical_id: WMET_ambient_temp, note: "反-环温调节故障判据用 (fleet-median环温轴, SOP §4.6c)"}
    95. 

  95.     "电池1状态 - 最大": {role: status, observed_range: [4.0, 4.0], sentinel: [], canonical_id: WSHD_电池1状态}
    96. 

  96.     "电池1状态 - 最小": {role: status, observed_range: [1.0, 4.0], sentinel: [], canonical_id: WSHD_电池1状态}
    97. 

  97.     "电池1电压 - 平均值 [伏]": {valid_range: [0, 450], observed_range: [389.36, 418.81], sentinel: [], canonical_id: WELE_battery_voltage_1, note: "0=系统off读数"}
    98. 

  98.     "电池2状态 - 最大": {role: status, observed_range: [4.0, 4.0], sentinel: [], canonical_id: WSHD_电池2状态}
    99. 

  99.     "电池2状态 - 最小": {role: status, observed_range: [1.0, 4.0], sentinel: [], canonical_id: WSHD_电池2状态}
    100. 

  100.     "电池2电压 - 平均值 [伏]": {valid_range: [0, 450], observed_range: [389.39, 422.41], sentinel: [], canonical_id: WELE_battery_voltage_2}
    101. 

  101.     "电池3状态 - 最大": {role: status, observed_range: [4.0, 4.0], sentinel: [], canonical_id: WSHD_电池3状态}
    102. 

  102.     "电池3状态 - 最小": {role: status, observed_range: [1.0, 4.0], sentinel: [], canonical_id: WSHD_电池3状态}
    103. 

  103.     "电池3电压 - 平均值 [伏]": {valid_range: [0, 450], observed_range: [388.13, 421.06], sentinel: [], canonical_id: WELE_battery_voltage_3}
    104. 

  104.     "电网无功功率 - 平均值 [千乏]": {valid_range: [-700, 2300], observed_range: [-8.88, 964.75], sentinel: [], canonical_id: WGRID_reactive_power, note: "园区AVC调度量; fleet-relative离群封顶【参考】 (memory reactive-attribution)"}
    105. 

  105.     "电网无功功率 - 最大 [千乏]": {valid_range: [-700, 2300], observed_range: [0.0, 2088.28], sentinel: [], canonical_id: WGRID_reactive_power_max}
    106. 

  106.     "电网无功功率 - 最小 [千乏]": {valid_range: [-700, 2300], observed_range: [-34.94, 925.27], sentinel: [], canonical_id: WGRID_reactive_power_min}
    107. 

  107.     "电网有功功率 - 平均值 [千瓦]": {valid_range: [-200, 2400], observed_range: [-9.02, 2051.69], sentinel: [], canonical_id: WAPC_active_power, note: "rated源: p99=2033/plateau2000/max2211瞬时boost; 负值=idle自耗真值"}
    108. 

  108.     "电网有功功率 - 最大 [千瓦]": {valid_range: [-200, 2400], observed_range: [0.0, 2211.55], sentinel: [], canonical_id: WAPC_active_power_max}
    109. 

  109.     "电网有功功率 - 最小 [千瓦]": {valid_range: [-600, 2400], observed_range: [-38.89, 2038.4], sentinel: [], canonical_id: WAPC_active_power_min, note: "min列-1447=10min内瞬时电动/坏点, 界宽松"}
    110. 

  110.     "网侧扼流圈温度 - 平均值 [摄氏度]": {valid_range: [-45, 180], observed_range: [0.0, 103.56], sentinel: [], canonical_id: WGRID_choke_temp_1, note: "网侧扼流圈(重名双通道之1)"}
    111. 

  111.     "网侧扼流圈温度 - 平均值 [摄氏度]#dup1": {valid_range: [-45, 180], observed_range: [4.0, 145.0], sentinel: [], canonical_id: WGRID_choke_temp_2, note: "重名双通道之2"}
    112. 

  112.     "转速 - 平均值 [转/分]": {valid_range: [-15, 25], observed_range: [-0.0, 15.72], sentinel: [], canonical_id: WROT_rotor_speed, note: "低速轴转子rpm; p99≈15.7"}
    113. 

  113.     "转速 - 最大 [转/分]": {valid_range: [-15, 25], observed_range: [0.0, 17.59], sentinel: [], canonical_id: WROT_rotor_speed_max}
    114. 

  114.     "转速 - 最小 [转/分]": {valid_range: [-15, 25], observed_range: [-0.09, 15.67], sentinel: [], canonical_id: WROT_rotor_speed_min}
    115. 

  115.     "轮毂柜1温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-9.36, 148.04], sentinel: [], canonical_id: WHUB_cabinet_temp_1, note: "max148 outlier已界外NaN"}
    116. 

  116.     "轮毂柜2温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-9.73, 55.39], sentinel: [], canonical_id: WHUB_cabinet_temp_2}
    117. 

  117.     "轮毂柜3温度 - 平均值 [摄氏度]": {valid_range: [-45, 120], observed_range: [-8.06, 43.23], sentinel: [], canonical_id: WHUB_cabinet_temp_3}
    118. 

  118.     "非驱动方向（P2P） - 平均值 [米/秒²]": {valid_range: [0, 60], observed_range: [0.01, 1.9], sentinel: [], canonical_id: WNAC_vib_nondrive_p2p}
    119. 

  119.     "非驱动方向（P2P） - 最大 [米/秒²]": {valid_range: [0, 60], observed_range: [0.01, 33.35], sentinel: [], canonical_id: WNAC_vib_nondrive_p2p_max}
    120. 

  120.     "非驱动方向（P2P） - 最小 [米/秒²]": {valid_range: [0, 60], observed_range: [0.0, 0.41], sentinel: [], canonical_id: WNAC_vib_nondrive_p2p_min}
    121. 

  121.     "风向 - 平均值 [度]": {frame: nacelle_relative, valid_range: [-180, 180], observed_range: [-119.98, 177.44], sentinel: [], canonical_id: WYAW_yaw_error, note: "机舱相对对风误差(±180, 0=对风); 发电态中位≈0; corr0.99 vs 机舱位置偏差"}
    122. 

  122.     "风向/北 - 平均值 [度]": {frame: geographic_derived, valid_range: [0, 360], observed_range: [15.64, 358.03], sentinel: [], self_ref_risk: true, canonical_id: WMET_wind_dir_geo_derived, note: "恒等式 风向/北≡wrap(机舱位置+vane风向) 94.5%<0.5°/median|resid|0.004° → 派生非独立地理传感器; 作绝对锚对yaw编码器循环 (memory pseudo-geo-wind-direction-identity-test)"}
    123. 

  123.     "风测量有效性 - 最大": {role: status, observed_range: [1.0, 1.0], sentinel: [], canonical_id: WSHD_风测量有效性}
    124. 

  124.     "风测量有效性 - 最小": {role: status, observed_range: [1.0, 1.0], sentinel: [], canonical_id: WSHD_风测量有效性}
    125. 

  125.     "风速 - 平均值 [米/秒]": {valid_range: [0, 60], observed_range: [0.64, 28.44], sentinel: [], self_ref_risk: true, canonical_id: WMET_wind_speed_nacelle, note: "机舱风速计 self_ref; 绝对功率曲线/Cp/达成率 INSUFFICIENT (无测风塔)"}
    126. 

  126.     "风速 - 最大 [米/秒]": {valid_range: [0, 60], observed_range: [1.23, 36.1], sentinel: [], canonical_id: WMET_wind_speed_max}
    127. 

  127.     "风速 - 最小 [米/秒]": {valid_range: [0, 60], observed_range: [0.04, 21.22], sentinel: [], canonical_id: WMET_wind_speed_min}
    128. 

  128.     "风速湍流 - 平均值 [米/秒]": {valid_range: [0, 20], observed_range: [0.14, 13.65], sentinel: [], canonical_id: WMET_wind_ti, note: "湍流强度代理"}
    129. 

  129.     "驱动方向（P2P） - 平均值 [米/秒²]": {valid_range: [0, 60], observed_range: [0.01, 1.62], sentinel: [], canonical_id: WNAC_vib_drive_p2p, note: "振动统计用median非mean(单corrupt块污染)"}
    130. 

  130.     "驱动方向（P2P） - 最大 [米/秒²]": {valid_range: [0, 60], observed_range: [0.01, 30.98], sentinel: [], canonical_id: WNAC_vib_drive_p2p_max}
    131. 

  131.     "驱动方向（P2P） - 最小 [米/秒²]": {valid_range: [0, 60], observed_range: [0.0, 0.4], sentinel: [], canonical_id: WNAC_vib_drive_p2p_min}
    132. 

  132.     "齿轮油加热器温度 - 平均值 [摄氏度]": {valid_range: [-45, 150], observed_range: [-16.68, 96.66], sentinel: [-274.15], canonical_id: WGBX_oil_heater_temp, note: "齿箱油加热器→温控卡死判据(加热器卡ON=反环温, memory thermal-regulation-stuck-family)"}
    133. 

  133.     "齿轮油加热器温度 - 最大 [摄氏度]": {valid_range: [-45, 150], observed_range: [-16.65, 97.99], sentinel: [-274.15], canonical_id: WGBX_oil_heater_temp_max}
    134. 

  134.     "齿轮箱入口油压 - 平均值 [巴]": {valid_range: [-8, 16], observed_range: [-0.19, 5.53], sentinel: [], canonical_id: WGBX_oil_inlet_pressure, note: "-4=噪声地板"}
    135. 

  135.     "齿轮箱入口油温 - 平均值 [摄氏度]": {valid_range: [-45, 150], observed_range: [14.64, 300.08], sentinel: [-274.15], canonical_id: WGBX_oil_inlet_temp}
    136. 

  136.     "齿轮箱入口油温 - 最大 [摄氏度]": {valid_range: [-45, 150], observed_range: [15.21, 393.99], sentinel: [-274.15], canonical_id: WGBX_oil_inlet_temp_max}
    137. 

  137.     "齿轮箱油温 - 平均值 [摄氏度]": {valid_range: [-45, 150], observed_range: [13.3, 72.82], sentinel: [-274.15], canonical_id: WGBX_oil_temp, note: "齿箱油温; 冷浸参照候选(comp=齿箱轴承温时, cold_soak_ref_col)"}
    138. 

  138.     "齿轮箱油温 - 最大 [摄氏度]": {valid_range: [-45, 150], observed_range: [13.66, 73.08], sentinel: [-274.15], canonical_id: WGBX_oil_temp_max}
    139. 

  139.     "齿轮箱轴承温度3 - 平均值 [摄氏度]": {valid_range: [-45, 150], observed_range: [13.15, 82.53], sentinel: [-274.15], canonical_id: WGBX_bearing_temp3, note: "RotBeaTemMax齿箱转子轴承已fleet全死(未映射); 本列=齿箱轴承温3"}
    140. 

  140.     "齿轮箱轴承温度3 - 最大 [摄氏度]": {valid_range: [-45, 150], observed_range: [13.41, 82.58], sentinel: [-274.15], canonical_id: WGBX_bearing_temp3_max}
    141. 

  141. 

  142. cleaning:
    143. 

  143.   physical: "valid_range 界外→NaN (apply_contract_gate, 非clamp); 哨兵 -9999(发电机轴承DE/NDE) + -274.15(abs-zero温度族)→NaN; 机舱位置累积编码器界宽±720勿误NaN(负值真非哨兵)"
    144. 

  144.   semantic: "对风误差=风向(机舱相对±180)直读; 风向/北=派生地理(≡机舱位置+风向)勿当独立锚; 状态列(PLC/安全链/变频器/电池/有效性)=离散枚举 role:status 数值勿平均, 事件解码表未交付; 10分钟发电量=区间量非累计counter; 振动P2P统计用median非mean"
    145. 

  145.   per_turbine_liveness: "分析前必per台liveness闸 (表头有列≠有活信号, memory channel-header-not-liveness); fleet全死未映射列见traps; 部分列idle零(桨叶/振动/无功) nz<100%非死"
    146. 

  146. traps:
    147. 

  147.   - "OEM未定: 控制器C11_5指纹不匹配库内任一已知场; 勿据onboard推断当定谳; 实名报告前须业主铭牌确认 (rated2000/owner国网 亦 UNVERIFIED)"
    148. 

  148.   - "TRANSPOSED格式: 源xlsx 行=信号列=10min时段(末列Source name=信号路径非台号); 装配转置见 scratchpad/shangdu_loader.py; 内部无台名列→id=zip号"
    149. 

  149.   - "派生地理列陷阱: 风向/北 ≡ wrap(机舱位置+风向) 94.5%<0.5°/median0.004° → 非独立地理传感器, 作扇区/风玫瑰/绝对偏航锚对yaw编码器循环; 对风用 风向(机舱相对) 或 机舱位置偏差(corr0.99)"
    150. 

  150.   - "机舱位置=累积偏航编码器(±700, 非地理0-360方位); 解缆量勿当bearing算对中; 不套温度哨兵"
    151. 

  151.   - "重名双通道(装配去重#dup1): 发电机扼流圈温度×2 / 网侧扼流圈温度×2 → 两物理通道非别名, 但用前比值核独立性 (memory near_equal_columns)"
    152. 

  152.   - "变桨=集距控制(collective)非IPC: below-rated发电态 桨叶1/2/3极差p95=0.04°<1° (3叶片传感器齐动); 每叶独立变频器内部温=3物理驱动但集距同步; 勿据3列当独立三叶不平衡分析(华创同型戒)"
    153. 

  153.   - "哨兵双制: 温度族 -274.15(abs-zero) + 发电机轴承 -9999; 各138行级(约1日outage); 混用勿只扫其一"
    154. 

  154.   - "fleet全死未映射列(gate透传): C11_5/.Glo.Gea.RotBeaTemMax(齿箱转子轴承全0) / 机舱柜2温度(全0) / 叶片顺桨位置开关(全0) / PLC之前快速状态 / GscEncMnt.ErrCnt·ErrPerCnt_1m·LscDbrEneCsm(编码器错误/制动能耗计数器, 非模拟量)"
    155. 

  155.   - "无三相电流/电压通道(仅电池电压) → CL-3 三相语义门 SKIP (note非静默干净)"
    156. 

  156.   - "无测风塔: 风速=机舱风速计 self_ref → 绝对功率曲线/Cp/达成率 INSUFFICIENT; 用担保曲线+相对机群 (power-curve-ntf)"
    157. 

  157.   - "IGBT/冷却水/绕组/齿箱油温 raw max有spike(167/365/394/393)已 valid_range 界外NaN; observed_range记raw观测(含spike)供反验"
    158. 

  158.   - "T8含1日 2024-02-23 (90行, 0.18%) spillback超'2023'窗名 = folder窗名可能错(枫香先例); window从数据实测填, 保留数据"
    159.