| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 |
- # 数据契约 — 未知OEM 1.5MW级 (太阳山风电场, 大唐·宁夏)
- # schema: docs/OEM_KB §3. oem-onboard 2026-07-09 (换现场·首个 xlsx 格式场, 解位置读列).
- # OEM 未知(索引"—"; 英文码 WNAC_/WROT_/WTRM_/WGEN_ = IEC 61400-25 风格, 型号待说明书).
- meta:
- oem: 未知 (英文码 IEC 61400-25 风格; 大唐宁夏太阳山3期)
- model: 未知 1.5MW级 (rated 实测 max≈1520 / 风>12 p95≈1338)
- topology: DFIG_geared # 发电机转速独立 + 齿轮箱油/低速轴/高速轴温 → 齿轮箱双馈
- rated_kw: 1500
- source_farm: 太阳山风电场 (宁夏, 大唐, 3期 W067-W099? 33台)
- turbine_count: 33 # 33 xlsx (DTNXJK-TYSFC-Q3-Wnnn.xlsx); ★台号来自文件名(数据无名称列)
- data_layers:
- agg_10min: "收资数据/min/太阳山风场3期数据导出.zip (33 xlsx, 双表头[行0英文码/行1中文名], 18列, 600s). 窗2024-06~2025-07"
- sec: "收资数据/sec/output.zip (秒级, 未onboard)"
- sampling: {agg_10min_s: 600, verified: "样本W067 时间diff中位=600s"}
- provenance: "oem-onboard 2026-07-09; ★xlsx双表头 → src/sop/xlsx_read.read_scada_xlsx name-based(解串列); G-OEM 样本W067 52761行"
- turbine:
- required: [有功功率, 风速]
- columns:
- 有功功率: {canonical_id: WAPC_active_power, unit: kW, valid_range: [-200, 1700]} # max1520≈额定1500
- 发电机转速: {canonical_id: WGEN_speed, unit: rpm, valid_range: [-100, 2200]}
- 风速: {canonical_id: WMET_wind_speed_nacelle, unit: m/s, valid_range: [0, 45], self_ref_risk: true}
- 对风角度:
- canonical_id: WYAW_yaw_error
- frame: nacelle_relative # ✅ ±180 med0.5 = 真对风失配(异盂县/平阴0-360) → 偏航可真分析
- valid_range: [-180, 180]
- note: "range[-180,174] med0.5 对风良好; 真失配角(非0-360) → yaw_usability 可跑出真结论"
- 绝对风向: {canonical_id: WMET_wind_direction_geo, frame: geographic, valid_range: [0, 360]}
- 桨距角1: {canonical_id: WROT_pitch_angle_1, unit: deg, valid_range: [-5, 95]}
- 桨距角2: {canonical_id: WROT_pitch_angle_2, unit: deg, valid_range: [-5, 95]}
- 桨距角3: {canonical_id: WROT_pitch_angle_3, unit: deg, valid_range: [-5, 95]}
- 齿轮箱油温: {canonical_id: WTRM_gbx_oil_temp, unit: degC, valid_range: [1, 120]} # ⚠min0=零膨胀/停机, 下界1剔exact0
- 齿轮箱低速轴轴承温度: {canonical_id: WTRM_gbx_lss_brg_temp, unit: degC, valid_range: [1, 120]}
- 齿轮箱高速轴轴承温度: {canonical_id: WTRM_gbx_hss_brg_temp, unit: degC, valid_range: [1, 130]}
- 发电机驱动端轴承温度: {canonical_id: WGEN_de_bearing_temp, unit: degC, valid_range: [1, 150]}
- 发电机非驱动端轴承温度: {canonical_id: WGEN_nde_bearing_temp, unit: degC, valid_range: [1, 150]}
- 发电机绕组温度: {canonical_id: WGEN_winding_temp, unit: degC, valid_range: [1, 200]}
- 机舱外温度: {canonical_id: WMET_ambient_temp, unit: degC, valid_range: [-45, 55]} # NBM共模基线 med13
- 舱内温度: {canonical_id: WNAC_nacelle_temp, unit: degC, valid_range: [-45, 80]}
- cleaning:
- physical:
- - "温度类 <= 0 → NaN (exact-0 零膨胀=停机/坏值; temp-nbm 物理门 §4.6, 防假 z)"
- - "风速 > 45 → 尖峰剔"
- semantic:
- - "★数据无名称列 → 台号来自文件名 DTNXJK-TYSFC-Q3-Wnnn (runner 注入 名称 列)"
- - "★无电网频率 → 物理态派生只 P+风 (发电=P>50 / 有风停=|P|≤50&风≥3 / 低风待机=|P|≤50&风<3)"
- traps:
- - "★★ xlsx 双表头(行0英文码 ActPWR/行1中文名 有功功率) → 位置读列必串; 用 xlsx_read.read_scada_xlsx(header_row=None 自动定位中文名行 + 必需列guard)"
- - "★ 台号在文件名非数据列 → runner 从 basename 抽 Wnnn 注入; 漏注入=全台混一"
- - "★ 温度 exact-0 零膨胀(齿箱油/DE min=0) → valid_range 下界1 剔; 否则 NBM 假 z (temp-nbm 铁律)"
- - "★ 对风角度=真±180失配(med0.5) → 偏航可真分析(异盂县平阴0-360 INSUFFICIENT); 但绝对零位仍须独立量"
|
