三冷物料模版表公式 — 取值逻辑可视化 v1.1

每个单元格：数据源(APS表名) → 求和字段(列号+字段名+描述) → 筛选条件(列号+字段名+描述+运算符+值) — 基于公式逻辑详解交叉验证

CF1 三冷原料库 (BD_INVENTORY_CF1)
CF2 酸轧轧后库 (BD_INVENTORY_CF2)
热轧库 三冷流向 (BD_HR_INVENTORY)
北营热轧库 (BD_HR_INVENTORY_BY)
合同基表 (BD_CONTRACT)

数据源 → 接口 → APS表 映射

数据来源接口清单APS表名简称说明
本钢三级系统CF1库存BD_INVENTORY_CF1CF1三冷原料库，冷轧前的原料库存
本钢三级系统CF2库存BD_INVENTORY_CF2CF2酸轧轧后库，酸洗轧制后的成品/半成品库存
本钢四级系统中间库库存-热轧库(三冷流向)BD_HR_INVENTORY热轧库板材厂区热轧库中三冷流向的库存
本钢四级系统中间库库存-北营库BD_HR_INVENTORY_BY北营北营厂区热轧库中商品和酸轧用的库存
本钢四级系统中间库库存-合同基表BD_CONTRACT合同基表四级合同进度明细台帐，合同维度的欠量/在库量
区域1：三冷原料库 CF1 B2-C11 APS: BD_INVENTORY_CF1
统计CF1原料库中，按"后全程工序代码(下工序)"分类的在库材料重量。
统一公式：SUM(SUMIFS(CF1!$M:$M, CF1!$C:$C, {"22*","23*","24*"}, CF1!$L:$L, $B行, CF1!$J:$J, "QZA*"))

CF1 CF1 原料库在库量（按后工序分类）— 每行完整字段

▼
单元格产线/工序数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
C4EH:本钢板材三冷5#镀锌工序 CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
(钢种系列: 22=封锁品,23/24=合格品)
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = EH:本钢板材三冷5#镀锌工序
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C5K3:本钢板材三冷连退工序CF1M列 WEIGHED_WEIGHT
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = K3:本钢板材三冷连退工序
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C6EF:本钢浦项3#镀锌工序CF1M列 WEIGHED_WEIGHT
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = EF:本钢浦项3#镀锌工序
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C7K2:本钢浦项连退工序CF1M列 WEIGHED_WEIGHT
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = K2:本钢浦项连退工序
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C8EK:本钢板材电镀锌工序CF1M列 WEIGHED_WEIGHT
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = EK:本钢板材电镀锌工序
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C9S3:本钢板材硅钢可逆轧机工序CF1M列 WEIGHED_WEIGHT
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = S3:本钢板材硅钢可逆轧机工序
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C109A:合同准发CF1M列 WEIGHED_WEIGHT
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码 IN {22*,23*,24*}
L列 POST_FULL_PROCESS_NEXT_CODE 后全程工序代码(下工序) = 9A:合同准发
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C11总计=SUM(C4:C10) — 所有工序分类的原料重量加总

CF1 统一公式解析

参数值说明
求和列M列 WEIGHED_WEIGHT称重重量(t)
筛选1C列 FULL_PROCESS_ROUTE_CODE IN {"22*","23*","24*"}钢种系列：22=封锁品, 23/24=合格品
筛选2L列 POST_FULL_PROCESS_NEXT_CODE = 工序名后全程工序代码(下工序)匹配
筛选3J列 MATERIAL_STATUS LIKE "QZA*"准发A级品（材料状态/合同性质）
区域2：三冷轧后库 CF2 D2-E11 APS: BD_INVENTORY_CF2
统计CF2轧后库中，按"后全程工序代码"分类的在库材料重量。
统一公式：SUM(SUMIFS(CF2!$M:$M, CF2!$C:$C, {"22*","23*","24*"}, CF2!$F:$F, $B行, CF2!$D:$D, "*期货*"))

CF2 CF2 轧后库在库量（按后工序分类）— 每行完整字段

▼
单元格产线/工序数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
E4EH:5#镀锌CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {22*,23*,24*}
F列 UNIT_CODE 机组代码(下工序) = EH
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
E5K3:连退CF2 M列 MATERIAL_WEIGHT_T
C列 MATERIAL_STATUS_CODE IN {22*,23*,24*}
F列 UNIT_CODE = K3
D列 CONTRACT_NATURE_CODE LIKE *期货*
E6EF:浦项3#镀锌CF2 M列 MATERIAL_WEIGHT_T
C列 MATERIAL_STATUS_CODE IN {22*,23*,24*}
F列 UNIT_CODE = EF
D列 CONTRACT_NATURE_CODE LIKE *期货*
E7K2:浦项连退CF2 M列 MATERIAL_WEIGHT_T
C列 MATERIAL_STATUS_CODE IN {22*,23*,24*}
F列 UNIT_CODE = K2
D列 CONTRACT_NATURE_CODE LIKE *期货*
E8EK:电镀锌CF2 M列 MATERIAL_WEIGHT_T
C列 MATERIAL_STATUS_CODE IN {22*,23*,24*}
F列 UNIT_CODE = EK
D列 CONTRACT_NATURE_CODE LIKE *期货*
E9S4:硅钢连退CF2 M列 MATERIAL_WEIGHT_T
C列 MATERIAL_STATUS_CODE IN {22*,23*,24*}
F列 UNIT_CODE = S4
D列 CONTRACT_NATURE_CODE LIKE *期货*
E109A:合同准发CF2 M列 MATERIAL_WEIGHT_T
C列 MATERIAL_STATUS_CODE IN {22*,23*,24*}
F列 UNIT_CODE = 9A
D列 CONTRACT_NATURE_CODE LIKE *期货*
E11总计=SUM(E4:E10)

CF1 vs CF2 关键差异对照

对比项CF1 三冷原料库CF2 酸轧轧后库
含义冷轧前的原料库存（等待加工）酸洗轧制后的成品/半成品库存
求和字段M列 WEIGHED_WEIGHT 称重重量M列 MATERIAL_WEIGHT_T 材料重量
工序匹配字段L列 POST_FULL_PROCESS_NEXT_CODEF列 UNIT_CODE
合同性质字段J列 MATERIAL_STATUS LIKE "QZA*"D列 CONTRACT_NATURE_CODE LIKE "*期货*"
区域3：全流程汇总 F2-N11 最核心汇总区

板材热轧库 G列 — 板材热轧库(可过) 按产线汇总

▼
★ G4/H4、G5/H5、G6/H6 为合并单元格（G列+H列合并），合并值=Area4的G13+H13。此表仅显示G列部分。筛选条件4=产品类型筛选（H列PRODUCT_NAME_CODE前缀：EA*=镀锌, ED*=纵切, S4*=硅钢）
单元格产线数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
G4
↓
H4
合并		5#镀锌(EH)热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
G5
↓
H5
合并		K3连退热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE EA*
G6
↓
H6
合并		K3纵切热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE ED*
G7K3连退合计=SUM(G5:G6)
G8硅钢连退热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *S4*
G9全产线合计=G4+G7+G8
G10三冷封锁卷热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {22*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *
 —
G10
↓
G11
G列封闭		G10/G11为合并单元格：板材热轧库(可过)封闭合计 = K13+K16+K19(热轧库封闭22系列)

北营 H列 — 北营(可过) 按产线汇总

▼
★ G4/H4、G5/H5、G6/H6 为合并单元格（G列+H列合并），合并值=Area4的G13+H13。此表仅显示H列部分。筛选条件4=产品类型筛选（AK列PRODUCT_NAME_CODE前缀：EA*=镀锌, ED*=纵切, S4*=硅钢）
单元格产线数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
G4
↓
H4
合并		5#镀锌(EH)北营 BD_HR_INVENTORY_BY M列 WEIGHED_WEIGHT_T 称重重量(t)
T列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
D列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
AC列 RESOURCE_LINE 资源产线 LIKE *EH*
AK列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
G5
↓
H5
合并		K3连退北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE EA*
G6
↓
H6
合并		K3纵切北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE ED*
H7K3连退合计=SUM(H5:H6)
H8硅钢连退北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE *S4*
H9全产线合计=H4+H7+H8
H10三冷封锁卷北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
D列 PRODUCT_NAME_CODE 品名代码(钢种) IN {22*}
AC列 RESOURCE_LINE 资源产线 LIKE *
 —
H10
↓
H11
H列封闭		H10/H11为合并单元格：北营(可过)封闭合计 = L13+L16+L19(热轧库封闭22系列)

CF1 I列 — 原料库(可排) 按产线汇总

▼
★ 筛选条件4=产品类型筛选（U列INVENTORY_TIME/PRODUCT_NAME_CODE前缀：EA*=镀锌, ED*=纵切, S4*=硅钢）
单元格产线数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
I45#镀锌(EH)CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE EA*
I5K3连退CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
I6K3纵切CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
I7K3连退合计=SUM(I5:I6)
I8硅钢连退CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *S4*
I9全产线合计=I4+I7+I8
I10三冷封锁卷CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *
 —
I10
↓
I11
I列封闭		I10/I11为合并单元格：原料库(可排)封闭合计 = K23+L23+M23(各库存节点封闭22系列)

CF2 J列 — 轧后库(可排) 按产线汇总

▼
★ 筛选条件4=产品类型筛选（E列PRODUCT_LINE_CODE前缀：EA*=镀锌, ED*=纵切, S4*=硅钢）
单元格产线数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
J45#镀锌(EH)CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE EA*
J5K3连退CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE EA*
J6K3纵切CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE ED*
J7K3连退合计=SUM(J5:J6)
J8硅钢连退CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *S4*
J9全产线合计=J4+J7+J8
J10三冷封锁卷CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {22*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *
 —
J10
↓
J11
J列封闭		J10/J11为合并单元格：轧后库(可排)封闭合计 = K23+L23+M23(各库存节点封闭22系列)

全流程合计 K列 — 合计(各库存节点总量)

▼
★ K列为合计列：K列 = G列(板材热轧库可过) + H列(北营可过) + I列(原料库可排) + J列(轧后库可排)，即各库存节点总量
单元格产线合计公式说明
K45#镀锌(EH)=G4+H4+I4+J4板材热轧+北营+CF1原料+CF2轧后
K5K3连退=G5+H5+I5+J5板材热轧+北营+CF1原料+CF2轧后
K6K3纵切=G6+H6+I6+J6板材热轧+北营+CF1原料+CF2轧后
K7K3连退合计=SUM(K5:K6)连退合计
K8硅钢连退=G8+H8+I8+J8预留
K9全产线合计=K4+K7+K8所有产线合计
K10
↓
K11
三冷封锁		三冷封锁卷=G10+H10+I10+J1022系列钢种在各库存节点的总量

标准库存 L列 — 标准库存(目标值)

▼
★ L列为标准库存列：各产线的目标库存值（从数据字典取值），用于与实际库存对比计算超欠量
单元格产线标准库存值说明
L45#镀锌(EH)从数据字典取值5#镀锌目标库存
L5K3连退从数据字典取值连退目标库存
L6K3纵切从数据字典取值纵切目标库存
L7K3连退合计从数据字典取值=L5+L6
L8硅钢连退—预留
L9全产线合计从数据字典取值=L4+L7+L8
L10
↓
L11
封闭标准		三冷封锁卷从数据字典取值22系列钢种目标库存

超欠量 M列 — 超欠量(K-L=实际-标准)

▼
★ M列为超欠量列：M = K列(合计) - L列(标准库存)。正值=超产，负值=欠产
单元格产线计算公式说明
M45#镀锌(EH)=K4-L4实际库存-目标=超欠
M5K3连退=K5-L5实际库存-目标=超欠
M6K3纵切=K6-L6实际库存-目标=超欠
M7K3连退合计=K7-L7连退超欠合计
M8硅钢连退=K8-L8预留
M9全产线合计=K9-L9总超欠量
M10
↓
M11
封闭超欠		三冷封锁卷=K10-L1022系列钢种超欠量

CF1 N列 — CF1预合同(YZA) 按产线汇总（N列为独立列，无合并）

▼
★ N4/N5/N6为合并单元格（N4跨行合并至N6），N7为K3连退合计（独立行）
单元格产线数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
N4
↓
N6
合并		5#镀锌(EH)CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE YZA* (预合同A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE EA*
N4
↓
N6
合并		K3连退CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE YZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
N4
↓
N6
合并		K3纵切CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE YZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
N7K3连退合计=SUM(N4:N6)

全流程汇总 — 全部指标汇总视图

▼
★ G4/H4、G5/H5、G6/H6 为合并单元格（G列+H列合并为一个单元格）；N列(CF1预合同)为独立列，无合并
行号产线板材热轧库(可过)(G)北营(可过)(H)原料库(可排)(I)轧后库(可排)(J)合计(K)标准库存(L)超欠量(M)CF1预合同(N)
45#镀锌(EH) SUMIFS(热轧库!Q:G="QZA",E={23*,24*},F="*EH*",H="EA*") SUMIFS(北营!M:T="QZA",D={23*,24*},AC="*EH*",AK="EA*") SUMIFS(CF1!M:J="QZA*",C={23*,24*},BG="*EH*",U="EA*") SUMIFS(CF2!M:D="*期货*",C={23*,24*},BN="*EH*",E="EA*") =SUM(G:J) 从数据字典取值 =K列-L列 SUMIFS(CF1!M:J="YZA*",C={23*,24*},BG="*EH*",U="EA*")
5K3连退 SUMIFS(热轧库!Q:G="QZA",E={23*,24*},F="*K3*",H="EA*") SUMIFS(北营!M:T="QZA",D={23*,24*},AC="*K3*",AK="EA*") SUMIFS(CF1!M:J="QZA*",C={23*,24*},BG="*K3*",U="EA*") SUMIFS(CF2!M:D="*期货*",C={23*,24*},BN="*K3*",E="EA*") =SUM(G:J) 从数据字典取值 =K列-L列 SUMIFS(CF1!M:J="YZA*",C={23*,24*},BG="*K3*",U="EA*")
6K3纵切 SUMIFS(热轧库!Q:G="QZA",E={23*,24*},F="*K3*",H="ED*") SUMIFS(北营!M:T="QZA",D={23*,24*},AC="*K3*",AK="ED*") SUMIFS(CF1!M:J="QZA*",C={23*,24*},BG="*K3*",U="ED*") SUMIFS(CF2!M:D="*期货*",C={23*,24*},BN="*K3*",E="ED*") =SUM(G:J) 从数据字典取值 =K列-L列 SUMIFS(CF1!M:J="YZA*",C={23*,24*},BG="*K3*",U="ED*")
7K3连退合计=SUM(G5:G6)=SUM(H5:H6)=SUM(I5:I6)=SUM(J5:J6)=SUM(G7:J7)从数据字典取值=K7-L7=SUM(N4:N6)
8硅钢连退预留预留预留预留———预留
9全产线合计=G4+G7+G8=H4+H7+H8=I4+I7+I8=J4+J7+J8=SUM(G9:J9)从数据字典取值=K9-L9=N4+N7
10三冷封锁卷=K13+K16+K19=L13+L16+L19=L23=M23=SUM(G10:J10)从数据字典取值=K10-L10—
区域4：资源产线 B12-N23 最核心最复杂区域
按产线+供料来源（板材供HE/HG vs 北营供HJ）统计合同欠量及各库存节点数量。

合同基表 C列 — 准发欠量(ISSUED_SHORTAGE)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
C135#镀锌板材供(HE/HG)合同基表 BD_CONTRACT R列 ISSUED_SHORTAGE 准发欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
C145#镀锌北营供(HJ)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
C155#镀锌合计=SUM(C13:C14)
C16连退板材供(HE/HG)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
C17连退北营供(HJ)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
C18连退合计=SUM(C16:C17)
C19纵切板材供(HE/HG)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
C20纵切北营供(HJ)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
C21纵切合计=SUM(C19:C20)
C22连退总计=C18+C21
C23三冷总计=C15+C22

合同基表 D列 — 申请欠量(MATERIAL_APPLICATION_SHORTAGE)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
D135#镀锌板材供(HE/HG)合同基表 BD_CONTRACT U列 MATERIAL_APPLICATION_SHORTAGE 材料申请欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
D145#镀锌北营供(HJ)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
D155#镀锌合计=SUM(D13:D14)
D16连退板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D17连退北营供(HJ)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D18连退合计=SUM(D16:D17)
D19纵切板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D20纵切北营供(HJ)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D21纵切合计=SUM(D19:D20)
D22连退总计=D18+D21
D23三冷总计=D15+D22

合同基表 E列 — 炼钢欠量(STEELMAKING_SHORTAGE_T)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
E135#镀锌板材供(HE/HG)合同基表 BD_CONTRACT V列 STEELMAKING_SHORTAGE_T 炼钢欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
E145#镀锌北营供(HJ)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
E155#镀锌合计=SUM(E13:E14)
E16连退板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
E17连退北营供(HJ)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
E18连退合计=SUM(E16:E17)
E19纵切板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
E20纵切北营供(HJ)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
E21纵切合计=SUM(E19:E20)
E22连退总计=E18+E21
E23三冷总计=E15+E22

合同基表 F列 — 坯料量/热轧在库(HOT_ROLL_INVENTORY)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
F135#镀锌板材供(HE/HG)合同基表 BD_CONTRACT X列 HOT_ROLL_INVENTORY 热轧在库量/坯料量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
F145#镀锌北营供(HJ)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
F155#镀锌合计=SUM(F13:F14)
F16连退板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
F17连退北营供(HJ)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
F18连退合计=SUM(F16:F17)
F19纵切板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
F20纵切北营供(HJ)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
F21纵切合计=SUM(F19:F20)
F22连退总计=F18+F21
F23三冷总计=F15+F22

板材热轧库 G列 — 热轧库(可过) 按产线+供料

▼
★ G列与H列为独立列（非合并），G13/H16/H19为板材热轧(可过)，对应北营(可过)的H13/H16/H19。Area3的G4(合H4)=G13+H13
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
G135#镀锌板材供热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
G145#镀锌北营供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *EH*
H列 PRODUCT_NAME_CODE LIKE EA*
G155#镀锌合计=G13+G14 ★合并: G15=H15
G16连退板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE EA*
G17连退北营供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE EA*
G18连退合计=G16+G17 ★合并: G18=H18
G19纵切板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE ED*
G20纵切北营供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE ED*
G21纵切合计=G19+G20 ★合并: G21=H21
G22连退总计=G18+G21
G23三冷总计=G15+G22

北营 H列 — 北营(可过) 按产线+供料

▼
★ H列为北营(可过)独立列，H13/H16/H19与G列(G13/G16/G19)为对应关系，非合并。Area3的G4(合H4)=G13+H13
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
H135#镀锌板材供北营 BD_HR_INVENTORY_BY M列 WEIGHED_WEIGHT_T 称重重量(t)
T列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
D列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
AC列 RESOURCE_LINE 资源产线 LIKE *EH*
AK列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
H145#镀锌北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *EH*
AK列 PRODUCT_NAME_CODE LIKE EA*
H155#镀锌合计=H13+H14
H16连退板材供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE EA*
H17连退北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE EA*
H18连退合计=H16+H17
H19纵切板材供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE ED*
H20纵切北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE ED*
H21纵切合计=H19+H20
H22连退总计=H18+H21
H23三冷总计=H15+H22

CF1 I列 — 原料库(可排) 按产线+供料

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
I135#镀锌板材供CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE EA*
I145#镀锌北营供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *EH*
U列 INVENTORY_TIME LIKE EA*
I155#镀锌合计=I13+I14
I16连退板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
I17连退北营供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
I18连退合计=I16+I17
I19纵切板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
I20纵切北营供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
I21纵切合计=I19+I20
I22连退总计=I18+I21
I23三冷总计=I15+I22

CF2 J列 — 轧后库(可排) 按产线+供料

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
J135#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE EA*
J145#镀锌北营供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *EH*
E列 PRODUCT_LINE_CODE LIKE EA*
J155#镀锌合计=J13+J14
J16连退板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE EA*
J17连退北营供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE EA*
J18连退合计=J16+J17
J19纵切板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE ED*
J20纵切北营供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE ED*
J21纵切合计=J19+J20
J22连退总计=J18+J21
J23三冷总计=J15+J22

热轧库 K列 — 热轧库封闭(22系列)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
K135#镀锌板材供热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {22*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
K145#镀锌北营供热轧库Q列 WEIGHED_WEIGHT同上同上同上同上
K155#镀锌合计=K13+K14
K16连退板材供热轧库Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {22*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE EA*
K17连退北营供热轧库Q列 WEIGHED_WEIGHT同上同上同上同上
K18连退合计=K16+K17
K19纵切板材供热轧库Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {22*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE ED*
K20纵切北营供热轧库Q列 WEIGHED_WEIGHT同上同上同上同上
K21纵切合计=K19+K20
K22连退总计=K18+K21
K23三冷总计=K15+K22

CF1 L列 — 原料库封闭(22系列)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
L135#镀锌板材供CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE EA*
L145#镀锌北营供CF1M列 WEIGHED_WEIGHT同上同上同上同上
L155#镀锌合计=L13+L14
L16连退板材供CF1M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
L17连退北营供CF1M列 WEIGHED_WEIGHT同上同上同上同上
L18连退合计=L16+L17
L19纵切板材供CF1M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
L20纵切北营供CF1M列 WEIGHED_WEIGHT同上同上同上同上
L21纵切合计=L19+L20
L22连退总计=L18+L21
L23三冷总计=L15+L22

CF2 M列 — 轧后库封闭(22系列)

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
M135#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {22*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE EA*
M145#镀锌北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上同上
M155#镀锌合计=M13+M14
M16连退板材供CF2M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {22*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE EA*
M17连退北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上同上
M18连退合计=M16+M17
M19纵切板材供CF2M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {22*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE ED*
M20纵切北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上同上
M21纵切合计=M19+M20
M22连退总计=M18+M21
M23三冷总计=M15+M22

CF2 N列 — CF2预合同

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)
N135#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *预合同*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
N145#镀锌北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
N155#镀锌合计=N13+N14
N16连退板材供CF2M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *预合同*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
N17连退北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
N18连退合计=N16+N17
N19纵切板材供CF2M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *预合同*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
N20纵切北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
N21纵切合计=N19+N20
N22连退总计=N18+N21
N23三冷总计=N15+N22
区域5：资源产线(外板+主机) B24-N35
专门统计汽车外板和汽车主机高附加值产品欠量。特色：每个值由两个SUMIFS相加（汽车主机部分 + 外板非主机部分）。

资源产线(外板+主机) — 主汇总表（汽车外板+汽车主机高附加值产品）

▼
★ 每个值 = 汽车主机部分 SUMIFS + 外板非主机部分 SUMIFS（两个SUMIFS相加）
单元格产线0申请欠量炼钢欠量坯料量(热轧在库)和:热轧库冷轧前原料在库和:轧后库和:热轧库封闭冷轧前原料封闭和:轧后库封闭分选度
B255#镀锌(EH)0 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机
B26连退(K3)0 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机
B27纵切(K3)0 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机=主机+外板非主机=主机+外板非主机 =主机+外板非主机

合同基表 申请欠量(MATERIAL_APPLICATION_SHORTAGE) — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
D255#镀锌板材供(HE/HG)合同基表 BD_CONTRACT U列 MATERIAL_APPLICATION_SHORTAGE 材料申请欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
D列 PRODUCT_NAME 品名 LIKE *汽车主机*
D265#镀锌板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机
D27连退板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *汽车主机*
D28连退板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机
D29纵切板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D列 PRODUCT_NAME LIKE *汽车主机*
D30纵切板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机

合同基表 炼钢欠量(STEELMAKING_SHORTAGE_T) — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
E255#镀锌板材供(HE/HG)合同基表 BD_CONTRACT V列 STEELMAKING_SHORTAGE_T 炼钢欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
D列 PRODUCT_NAME 品名 LIKE *汽车主机*
E265#镀锌板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机
E27连退板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *汽车主机*
E28连退板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机
E29纵切板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D列 PRODUCT_NAME LIKE *汽车主机*
E30纵切板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机

合同基表 坯料量/热轧在库(HOT_ROLL_INVENTORY) — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
F255#镀锌板材供(HE/HG)合同基表 BD_CONTRACT X列 HOT_ROLL_INVENTORY 热轧在库量/坯料量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
D列 PRODUCT_NAME 品名 LIKE *汽车主机*
F265#镀锌板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机
F27连退板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *汽车主机*
F28连退板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机
F29纵切板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D列 PRODUCT_NAME LIKE *汽车主机*
F30纵切板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
D列 PRODUCT_NAME LIKE *外板* AND NOT 主机

板材热轧库 和:热轧库 — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
G255#镀锌板材供热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE *汽车主机*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE *外板* AND NOT 主机
G265#镀锌板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *EH*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
 —
G27连退板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *汽车主机*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
G28连退板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
 —
G29纵切板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *汽车主机*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
G30纵切板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
 —

CF1 冷轧前原料在库 — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
H255#镀锌板材供CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE *汽车主机*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE *外板* AND NOT 主机
H265#镀锌板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *EH*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
 —
H27连退板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *汽车主机*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
H28连退板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
 —
H29纵切板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *汽车主机*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
H30纵切板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
 —

CF2 和:轧后库 — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
J255#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE *汽车主机*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE *外板* AND NOT 主机
J265#镀锌板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *EH*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
 —
J27连退板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *汽车主机*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
J28连退板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
 —
J29纵切板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *汽车主机*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
J30纵切板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
 —

热轧库 和:热轧库封闭(22系列) — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
K255#镀锌板材供热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {22*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE *汽车主机*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE *外板* AND NOT 主机
K265#镀锌板材供热轧库Q列 WEIGHED_WEIGHT同上同上同上
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
—
K27连退板材供热轧库Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {22*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *汽车主机*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
K28连退板材供热轧库Q列 WEIGHED_WEIGHT同上同上同上
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
—
K29纵切板材供热轧库Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {22*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE *汽车主机*
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
K30纵切板材供热轧库Q列 WEIGHED_WEIGHT同上同上同上
H列 PRODUCT_NAME_CODE LIKE *外板* AND NOT 主机
—

CF1 冷轧前原料封闭(22系列) — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
L255#镀锌板材供CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE *汽车主机*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE *外板* AND NOT 主机
L265#镀锌板材供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
—
L27连退板材供CF1M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *汽车主机*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
L28连退板材供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
—
L29纵切板材供CF1M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *汽车主机*
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
L30纵切板材供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE *外板* AND NOT 主机
—

CF2 和:轧后库封闭(22系列) — 外板+主机

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
M255#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {22*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE *汽车主机*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE *外板* AND NOT 主机
M265#镀锌板材供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
—
M27连退板材供CF2M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {22*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *汽车主机*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
M28连退板材供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
—
M29纵切板材供CF2M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {22*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE *汽车主机*
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
M30纵切板材供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE *外板* AND NOT 主机
—

分选度 — 外板+主机

▼
单元格产线数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
O255#镀锌CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE *外板*
O26连退CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *外板*
O27纵切CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE *外板*
区域6：资源产线(出口) B36-N47
专门统计出口合同欠量。核心特征：增加 AB列 EXPORT_FLAG 出口标记 LIKE "1*"。

合同基表 C列 — 准发欠量(ISSUED_SHORTAGE) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
C375#镀锌板材供(HE/HG)合同基表 BD_CONTRACT R列 ISSUED_SHORTAGE 准发欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
AB列 EXPORT_FLAG 出口标记 LIKE 1*
C385#镀锌北营供(HJ)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
C395#镀锌合计=SUM(C37:C38)
C40连退板材供(HE/HG)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
C41连退北营供(HJ)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
C42连退合计=SUM(C40:C41)
C43纵切板材供(HE/HG)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
C44纵切北营供(HJ)合同基表 R列 ISSUED_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
C45纵切合计=SUM(C43:C44)
C46连退总计=C42+C45
C47三冷总计=C39+C46

合同基表 D列 — 申请欠量(MATERIAL_APPLICATION_SHORTAGE) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
D375#镀锌板材供(HE/HG)合同基表 BD_CONTRACT U列 MATERIAL_APPLICATION_SHORTAGE 材料申请欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
AB列 EXPORT_FLAG 出口标记 LIKE 1*
D385#镀锌北营供(HJ)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
D395#镀锌合计=SUM(D37:D38)
D40连退板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
D41连退北营供(HJ)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
D42连退合计=SUM(D40:D41)
D43纵切板材供(HE/HG)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
D44纵切北营供(HJ)合同基表 U列 MATERIAL_APPLICATION_SHORTAGE
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
D45纵切合计=SUM(D43:D44)
D46连退总计=D42+D45
D47三冷总计=D39+D46

合同基表 E列 — 炼钢欠量(STEELMAKING_SHORTAGE_T) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
E375#镀锌板材供(HE/HG)合同基表 BD_CONTRACT V列 STEELMAKING_SHORTAGE_T 炼钢欠量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
AB列 EXPORT_FLAG 出口标记 LIKE 1*
E385#镀锌北营供(HJ)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
E395#镀锌合计=SUM(E37:E38)
E40连退板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
E41连退北营供(HJ)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
E42连退合计=SUM(E40:E41)
E43纵切板材供(HE/HG)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
E44纵切北营供(HJ)合同基表 V列 STEELMAKING_SHORTAGE_T
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
E45纵切合计=SUM(E43:E44)
E46连退总计=E42+E45
E47三冷总计=E39+E46

合同基表 F列 — 坯料量/热轧在库(HOT_ROLL_INVENTORY) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)
F375#镀锌板材供(HE/HG)合同基表 BD_CONTRACT X列 HOT_ROLL_INVENTORY 热轧在库量/坯料量(t)
AK列 HOT_ROLL_PROCESS_CODE 供料基地 IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE 冷轧工序 = EH
C列 STATUS 合同状态 IN {"*有欠量","33*"}
AB列 EXPORT_FLAG 出口标记 LIKE 1*
F385#镀锌北营供(HJ)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = EH
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
F395#镀锌合计=SUM(F37:F38)
F40连退板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
F41连退北营供(HJ)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
AB列 EXPORT_FLAG LIKE 1*
F42连退合计=SUM(F40:F41)
F43纵切板材供(HE/HG)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HE,HG}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
F44纵切北营供(HJ)合同基表 X列 HOT_ROLL_INVENTORY
AK列 HOT_ROLL_PROCESS_CODE IN {HJ}
AL列 COLD_ROLL_PROCESS_CODE = K3
C列 STATUS IN {"*有欠量","33*"}
D=冷轧纵切卷
AB列 EXPORT_FLAG LIKE 1*
F45纵切合计=SUM(F43:F44)
F46连退总计=F42+F45
F47三冷总计=F39+F46

板材热轧库 G列 — 和:热轧库 — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
G375#镀锌板材供热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
G385#镀锌北营供北营 BD_HR_INVENTORY_BY M列 WEIGHED_WEIGHT_T 称重重量(t)
T列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
D列 PRODUCT_NAME_CODE 品名代码(钢种) IN {23*,24*}
AC列 RESOURCE_LINE 资源产线 LIKE *EH*
AK列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
G395#镀锌合计=G37+G38
G40连退板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
G41连退北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
G42连退合计=G40+G41
G43纵切板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {23*,24*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
G44纵切北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {23*,24*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
G45纵切合计=G43+G44

CF1 I列 — 冷轧前原料在库 — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
I375#镀锌板材供CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
I385#镀锌北营供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
I395#镀锌合计=I37+I38
I40连退板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
I41连退北营供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
I42连退合计=I40+I41
I43纵切板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {23*,24*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
I44纵切北营供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
I45纵切合计=I43+I44

CF2 J列 — 和:轧后库 — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
J375#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
J385#镀锌北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
J395#镀锌合计=J37+J38
J40连退板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
J41连退北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
J42连退合计=J40+J41
J43纵切板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {23*,24*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
J44纵切北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
J45纵切合计=J43+J44

热轧库 K列 — 和:热轧库封闭(22系列) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
K375#镀锌板材供热轧库 BD_HR_INVENTORY Q列 WEIGHED_WEIGHT 称重重量(t)
G列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
E列 PRODUCT_NAME_CODE 品名代码(钢种) IN {22*}
F列 POST_FULL_PROCESS_CODE 后全程工序代码(流向) LIKE *EH*
H列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
K385#镀锌北营供北营 BD_HR_INVENTORY_BY M列 WEIGHED_WEIGHT_T 称重重量(t)
T列 CONTRACT_NATURE_CODE 合同性质代码 = QZA
D列 PRODUCT_NAME_CODE 品名代码(钢种) IN {22*}
AC列 RESOURCE_LINE 资源产线 LIKE *EH*
AK列 PRODUCT_NAME_CODE 品名代码(产品类型) LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
K395#镀锌合计=K37+K38
K40连退板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {22*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
K41连退北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {22*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
K42连退合计=K40+K41
K43纵切板材供热轧库 Q列 WEIGHED_WEIGHT
G列 CONTRACT_NATURE_CODE = QZA
E列 PRODUCT_NAME_CODE IN {22*}
F列 POST_FULL_PROCESS_CODE LIKE *K3*
H列 PRODUCT_NAME_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
K44纵切北营供北营 M列 WEIGHED_WEIGHT_T
T列 CONTRACT_NATURE_CODE = QZA
D列 PRODUCT_NAME_CODE IN {22*}
AC列 RESOURCE_LINE LIKE *K3*
AK列 PRODUCT_NAME_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
K45纵切合计=K43+K44

CF1 L列 — 冷轧前原料封闭(22系列) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
L375#镀锌板材供CF1 BD_INVENTORY_CF1 M列 WEIGHED_WEIGHT 称重重量(t)
J列 MATERIAL_STATUS 材料状态/合同性质 LIKE QZA* (准发A级品)
C列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(钢种) IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE 全程工序途径码(资源产线流向) LIKE *EH*
U列 INVENTORY_TIME 入库时间/品名代码 LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
L385#镀锌北营供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
L395#镀锌合计=L37+L38
L40连退板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
L41连退北营供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
L42连退合计=L40+L41
L43纵切板材供CF1 M列 WEIGHED_WEIGHT
J列 MATERIAL_STATUS LIKE QZA*
C列 FULL_PROCESS_ROUTE_CODE IN {22*}
BG列 FULL_PROCESS_ROUTE_CODE LIKE *K3*
U列 INVENTORY_TIME LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
L44纵切北营供CF1M列 WEIGHED_WEIGHT同上同上同上
U列 INVENTORY_TIME LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
L45纵切合计=L43+L44

CF2 M列 — 和:轧后库封闭(22系列) — 出口

▼
单元格产线供料数据源(APS表)求和字段
(列号+字段名+描述)		筛选条件1
(列号+字段名+描述 → 值)		筛选条件2
(列号+字段名+描述 → 值)		筛选条件3
(列号+字段名+描述 → 值)		筛选条件4
(列号+字段名+描述 → 值)		筛选条件5
(列号+字段名+描述 → 值)
M375#镀锌板材供CF2 BD_INVENTORY_CF2 M列 MATERIAL_WEIGHT_T 材料重量(t)
D列 CONTRACT_NATURE_CODE 合同性质代码 LIKE *期货*
C列 MATERIAL_STATUS_CODE 材料状态码/钢种 IN {22*}
BN列 TRANSFER_PLAN_FLAG 转库计划标记(流向) LIKE *EH*
E列 PRODUCT_LINE_CODE 产线代码/品名代码 LIKE EA*
AB列 EXPORT_FLAG 出口标记 LIKE 1*
M385#镀锌北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
M395#镀锌合计=M37+M38
M40连退板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {22*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
M41连退北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE EA*
AB列 EXPORT_FLAG LIKE 1*
M42连退合计=M40+M41
M43纵切板材供CF2 M列 MATERIAL_WEIGHT_T
D列 CONTRACT_NATURE_CODE LIKE *期货*
C列 MATERIAL_STATUS_CODE IN {22*}
BN列 TRANSFER_PLAN_FLAG LIKE *K3*
E列 PRODUCT_LINE_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
M44纵切北营供CF2M列 MATERIAL_WEIGHT_T同上同上同上
E列 PRODUCT_LINE_CODE LIKE ED*
AB列 EXPORT_FLAG LIKE 1*
M45纵切合计=M43+M44
数据源字段总表 5个数据源: 列号+字段名+中文描述+公式用途
版本差异修正说明 所有错误已在本版本中修正