05_房型价差与价格体系.xlsx

05 · 房型价差与价格体系｜使用说明
价格体系不是一张价目表，是一把梯子：每一档都要踩得上去，也踩得出差别。
一、用途
对应《法典》表 F（房型价差阶梯表）与课程 M06《价格体系设计：BAR 与价差阶梯》。
「房型清单」页固化 SPEC 2.1 的 10 个房型，自动校验总房量 = 320 间。
「价格阶梯」页只输入一个基准 BAR（高级房），全房型价格与所有附加项自动算出。
「全年价格日历」页 365 天，逐日给出需求等级、价格系数、BAR 与 10 个房型的价格，是价格日历（Rate Grid）落位的底稿。
「价差校验」页自动执行表 F 的三条校验规则并标红报警。
—	—	—	—	—
二、填色规则
—	输入区	浅黄底 + 边框	由学员填写，例如日期、房晚、价格
—	公式区	白底 + 边框	已预置 Excel 公式，改动会导致结果错误，请勿手改
—	参考区	灰底 + 斜体	SPEC 固定参数/判定表，一般不需要改动
—	标题行	深蓝底白字	字段名，冻结在首行
—	—	—	—	—
三、字段字典
列	字段名称	类型	口径 / 预置公式	说明
B4(阶梯)	基准 BAR	输入	默认 680	SPEC 2.1 高级房平峰 BAR
价格阶梯 6-11 行	附加项参数	输入	5% / 10% / ¥68 / ¥180 / ¥50 / ¥10	SPEC 2.1 附加价格规则 + 表 F 附加项
D(阶梯)	基础 BAR	公式	=ROUND(基准×系数÷100÷圆整步长,0)×圆整步长	表 F 价差系数
E-F(阶梯)	高楼层 / 江景	公式	=ROUND(基础价×(1+比例)÷10,0)×10	—
G-H(阶梯)	含早 1 人 / 2 人	公式	=基础价+68 ； =基础价+136	¥68/人 × 人数
J(阶梯)	最高组合价	公式	=ROUND(基础价×1.05×1.10÷10,0)×10+136	高楼层+江景+双早
C(日历)	需求等级	输入	D1/D2/D3/D4	已按 2027 日历预填 SPEC 2.5 默认值
D(日历)	价格系数	输入	已按等级分档预填	D1 150–200%、D2 120–150%、D3 95–110%、D4 70–85%
E-G(日历)	系数下限/上限/合规	公式	由等级自动带出并校验	超范围标红
H-R(日历)	BAR + 10 房型价	公式	=ROUND(基准×系数÷10,0)×10	—
F-G(校验)	价差% / 判定	公式	相邻档位价差与表 F 三档规则	过小/过大标红
—	—	—	—	—
四、使用步骤
1	在「房型清单」页确认 10 个房型的间数与平峰 BAR（默认 SPEC 2.1），看合计行是否显示「✓ 合计 320 间」。
2	在「价格阶梯」页确认基准 BAR 与 6 个附加项参数；下方 10 个房型的基础价、附加价、差价自动生成。
3	在「全年价格日历」页逐日核对需求等级（C 列），必要时改价格系数（D 列）——超出该等级区间会标红。
4	打印「价差校验」页，红色行即为本周须处理的价差问题；动作写入 04 号《调价台账》，触发表选「表F」以外的实动作表。
5	每周一按《法典》表 N 重复执行一次。
—	—	—	—	—
五、关联《收益管理操作法典》
表 F · 房型价差阶梯表 —— 三条校验规则已用公式实现，并内嵌原文作参考。
表 A · 每日价格调整判定表 —— 系数调整属于调价动作，须满足「单次≥3%、单日同方向≤20%、24h 内≤2 次」。
表 J · 免费升级规则表 —— 相邻档位价差过小时，升级路径会失真，须先修价差。
表 N · 每周一执行房型价差校验。
—	—	—	—	—
杭州滨江云璟酒店 · 320 间房 · 中高端全服务｜酒店收益管理学院 HRMA ｜口径以 SPEC.md 为准

房型清单 · 杭州滨江云璟酒店（SPEC 2.1）
灰底为 SPEC 2.1 固定参数；白底为公式。合计行自动校验总房量是否为 320 间。
房型代码	房型名称	间数	面积(㎡)	床型	平峰 BAR	价差系数	间数占比	房型组	加权 BAR 贡献	备注
STD-K	标准大床房	70	32	1.8m 大床	580	85	0.21875	STD	126.875	无障碍连通房共 12 间，分布在 STD/SUP
STD-T	标准双床房	50	32	1.2m×2	580	85	0.15625	STD	90.625	—
SUP-K	高级大床房	60	38	1.8m 大床	680	100	0.1875	SUP	127.5	无障碍连通房共 12 间，分布在 STD/SUP
SUP-T	高级双床房	40	38	1.2m×2	680	100	0.125	SUP	85	—
DLX-K	豪华大床房	45	45	2.0m 大床	820	120	0.140625	DLX	115.3125	—
DLX-V	豪华江景房	15	48	2.0m 大床	960	140	0.046875	DLX	45	—
EXE-K	行政大床房	25	45	2.0m 大床	990	145	0.078125	EXE	77.34375	—
EXE-T	行政双床房	5	45	1.2m×2	990	145	0.015625	EXE	15.46875	—
STE-B	商务套房	8	65	2.0m 大床	1280	180	0.025	STE	32	—
STE-E	行政套房	2	88	2.0m 大床	1880	265	0.00625	STE	11.75	—
合计	10 个房型	320	—	—	726.875	—	1	—	—	✓ 合计 320 间，与 SPEC 2.1 一致（含 12 间无障碍连通房）
—	—	—	—	—	—	—	—	—	—	—
注：加权 BAR 贡献合计 ¥726.9 元为「全部房型按平峰 BAR 售罄」的理论值，高于实际 ADR ¥618，差额来自客源折扣与房型销售结构（升级/免费房）。

价格阶梯 · 由基准 BAR 自动生成全房型价格（SPEC 表 F）
只改 B4 基准 BAR（高级房）与附加项参数，下方全部价格自动重算。附加项口径见 SPEC 2.1 / 表 F。
—	—	—	—	—	—	—	—	—	—	—	—	—
基准 BAR（高级房 SUP，系数 100）	680	元	SPEC 2.1：高级房平峰 BAR ¥680；SPEC 2.4：竞争组合加权均价 ¥680
—	—	—	—	—	—	—	—	—	—	—	—	—
附加项参数（黄底可改）
附加项	数值	单位	说明	—	—	—	—	—	—	—	—	—
高楼层	5.0%	比例	同楼层、同朝向的高低层差价 +5%	—	—	—	—	—	—	—	—	—
江景 / 特色景观	10.0%	比例	江景 vs 城景 +10%	—	—	—	—	—	—	—	—	—
含早（元/人）	68	元	自助早餐门市价 ¥128/人，打包价 +¥68/人	—	—	—	—	—	—	—	—	—
加床（元/晚）	180	元	含早	—	—	—	—	—	—	—	—	—
连通房（元/间）	50	元	表 F 附加项	—	—	—	—	—	—	—	—	—
价格圆整到（元）	10	元	所有价格按此步长取整	—	—	—	—	—	—	—	—	—
—	—	—	—	—	—	—	—	—	—	—	—	—
价格阶梯表（白底公式，勿改）
房型代码	房型名称	价差系数	基础 BAR	高楼层 +5%	江景 +10%	含早 1 人	含早 2 人	加床 +180	最高组合价	相对高级房差价	差价%	备注
STD-K	标准大床房	85	580	610	640	648	716	760	806	-100	-0.14705882352941177	—
STD-T	标准双床房	85	580	610	640	648	716	760	806	-100	-0.14705882352941177	—
SUP-K	高级大床房	100	680	710	750	748	816	860	926	0	0	← 表 F 基准（系数 100）
SUP-T	高级双床房	100	680	710	750	748	816	860	926	0	0	—
DLX-K	豪华大床房	120	820	860	900	888	956	1000	1086	140	0.20588235294117646	仅 DLX-V 等江景房实际适用
DLX-V	豪华江景房	140	950	1000	1050	1018	1086	1130	1236	270	0.39705882352941174	—
EXE-K	行政大床房	145	990	1040	1090	1058	1126	1170	1276	310	0.45588235294117646	—
EXE-T	行政双床房	145	990	1040	1090	1058	1126	1170	1276	310	0.45588235294117646	—
STE-B	商务套房	180	1220	1280	1340	1288	1356	1400	1546	540	0.7941176470588235	—
STE-E	行政套房	265	1800	1890	1980	1868	1936	1980	2216	1120	1.6470588235294117	高楼层 + 江景 + 双早

全年价格日历 2027 · 365 天（需求等级 → 系数 → BAR → 各房型价）
输入：C 列需求等级、D 列价格系数（已按 SPEC 2.5 分档预填默认值）。其余全部为公式。
日期	星期	需求等级	价格系数	系数下限	系数上限	系数合规	BAR	STD-K	STD-T	SUP-K	SUP-T	DLX-K	DLX-V	EXE-K	EXE-T	STE-B	STE-E
2027-01-01 00:00:00	=IF($A4="","",CHOOSE(WEEKDAY(A4,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46389	=IF($A5="","",CHOOSE(WEEKDAY(A5,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46390	=IF($A6="","",CHOOSE(WEEKDAY(A6,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46391	=IF($A7="","",CHOOSE(WEEKDAY(A7,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46392	=IF($A8="","",CHOOSE(WEEKDAY(A8,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46393	=IF($A9="","",CHOOSE(WEEKDAY(A9,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46394	=IF($A10="","",CHOOSE(WEEKDAY(A10,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46395	=IF($A11="","",CHOOSE(WEEKDAY(A11,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46396	=IF($A12="","",CHOOSE(WEEKDAY(A12,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46397	=IF($A13="","",CHOOSE(WEEKDAY(A13,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46398	=IF($A14="","",CHOOSE(WEEKDAY(A14,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46399	=IF($A15="","",CHOOSE(WEEKDAY(A15,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46400	=IF($A16="","",CHOOSE(WEEKDAY(A16,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46401	=IF($A17="","",CHOOSE(WEEKDAY(A17,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46402	=IF($A18="","",CHOOSE(WEEKDAY(A18,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46403	=IF($A19="","",CHOOSE(WEEKDAY(A19,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46404	=IF($A20="","",CHOOSE(WEEKDAY(A20,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46405	=IF($A21="","",CHOOSE(WEEKDAY(A21,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46406	=IF($A22="","",CHOOSE(WEEKDAY(A22,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46407	=IF($A23="","",CHOOSE(WEEKDAY(A23,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46408	=IF($A24="","",CHOOSE(WEEKDAY(A24,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46409	=IF($A25="","",CHOOSE(WEEKDAY(A25,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46410	=IF($A26="","",CHOOSE(WEEKDAY(A26,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46411	=IF($A27="","",CHOOSE(WEEKDAY(A27,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46412	=IF($A28="","",CHOOSE(WEEKDAY(A28,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46413	=IF($A29="","",CHOOSE(WEEKDAY(A29,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46414	=IF($A30="","",CHOOSE(WEEKDAY(A30,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46415	=IF($A31="","",CHOOSE(WEEKDAY(A31,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46416	=IF($A32="","",CHOOSE(WEEKDAY(A32,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46417	=IF($A33="","",CHOOSE(WEEKDAY(A33,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46418	=IF($A34="","",CHOOSE(WEEKDAY(A34,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46419	=IF($A35="","",CHOOSE(WEEKDAY(A35,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46420	=IF($A36="","",CHOOSE(WEEKDAY(A36,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46421	=IF($A37="","",CHOOSE(WEEKDAY(A37,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46422	=IF($A38="","",CHOOSE(WEEKDAY(A38,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46423	=IF($A39="","",CHOOSE(WEEKDAY(A39,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46424	=IF($A40="","",CHOOSE(WEEKDAY(A40,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46425	=IF($A41="","",CHOOSE(WEEKDAY(A41,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46426	=IF($A42="","",CHOOSE(WEEKDAY(A42,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	171.4%	1.5	2	合规	1170	990	990	1170	1170	1400	1640	1700	1700	2110	3100
46427	=IF($A43="","",CHOOSE(WEEKDAY(A43,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	172.6%	1.5	2	合规	1170	990	990	1170	1170	1400	1640	1700	1700	2110	3100
46428	=IF($A44="","",CHOOSE(WEEKDAY(A44,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	173.8%	1.5	2	合规	1180	1000	1000	1180	1180	1420	1650	1710	1710	2120	3130
46429	=IF($A45="","",CHOOSE(WEEKDAY(A45,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	175.0%	1.5	2	合规	1190	1010	1010	1190	1190	1430	1670	1730	1730	2140	3150
46430	=IF($A46="","",CHOOSE(WEEKDAY(A46,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	79.2%	0.7	0.85	合规	540	460	460	540	540	650	760	780	780	970	1430
46431	=IF($A47="","",CHOOSE(WEEKDAY(A47,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	80.4%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46432	=IF($A48="","",CHOOSE(WEEKDAY(A48,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46433	=IF($A49="","",CHOOSE(WEEKDAY(A49,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46434	=IF($A50="","",CHOOSE(WEEKDAY(A50,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46435	=IF($A51="","",CHOOSE(WEEKDAY(A51,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46436	=IF($A52="","",CHOOSE(WEEKDAY(A52,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46437	=IF($A53="","",CHOOSE(WEEKDAY(A53,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46438	=IF($A54="","",CHOOSE(WEEKDAY(A54,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46439	=IF($A55="","",CHOOSE(WEEKDAY(A55,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46440	=IF($A56="","",CHOOSE(WEEKDAY(A56,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46441	=IF($A57="","",CHOOSE(WEEKDAY(A57,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46442	=IF($A58="","",CHOOSE(WEEKDAY(A58,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46443	=IF($A59="","",CHOOSE(WEEKDAY(A59,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46444	=IF($A60="","",CHOOSE(WEEKDAY(A60,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46445	=IF($A61="","",CHOOSE(WEEKDAY(A61,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46446	=IF($A62="","",CHOOSE(WEEKDAY(A62,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46447	=IF($A63="","",CHOOSE(WEEKDAY(A63,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46448	=IF($A64="","",CHOOSE(WEEKDAY(A64,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46449	=IF($A65="","",CHOOSE(WEEKDAY(A65,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46450	=IF($A66="","",CHOOSE(WEEKDAY(A66,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46451	=IF($A67="","",CHOOSE(WEEKDAY(A67,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46452	=IF($A68="","",CHOOSE(WEEKDAY(A68,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46453	=IF($A69="","",CHOOSE(WEEKDAY(A69,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46454	=IF($A70="","",CHOOSE(WEEKDAY(A70,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46455	=IF($A71="","",CHOOSE(WEEKDAY(A71,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46456	=IF($A72="","",CHOOSE(WEEKDAY(A72,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46457	=IF($A73="","",CHOOSE(WEEKDAY(A73,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46458	=IF($A74="","",CHOOSE(WEEKDAY(A74,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46459	=IF($A75="","",CHOOSE(WEEKDAY(A75,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46460	=IF($A76="","",CHOOSE(WEEKDAY(A76,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46461	=IF($A77="","",CHOOSE(WEEKDAY(A77,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46462	=IF($A78="","",CHOOSE(WEEKDAY(A78,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46463	=IF($A79="","",CHOOSE(WEEKDAY(A79,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46464	=IF($A80="","",CHOOSE(WEEKDAY(A80,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	163.0%	1.5	2	合规	1110	940	940	1110	1110	1330	1550	1610	1610	2000	2940
46465	=IF($A81="","",CHOOSE(WEEKDAY(A81,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	164.2%	1.5	2	合规	1120	950	950	1120	1120	1340	1570	1620	1620	2020	2970
46466	=IF($A82="","",CHOOSE(WEEKDAY(A82,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46467	=IF($A83="","",CHOOSE(WEEKDAY(A83,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46468	=IF($A84="","",CHOOSE(WEEKDAY(A84,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46469	=IF($A85="","",CHOOSE(WEEKDAY(A85,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46470	=IF($A86="","",CHOOSE(WEEKDAY(A86,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46471	=IF($A87="","",CHOOSE(WEEKDAY(A87,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46472	=IF($A88="","",CHOOSE(WEEKDAY(A88,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46473	=IF($A89="","",CHOOSE(WEEKDAY(A89,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46474	=IF($A90="","",CHOOSE(WEEKDAY(A90,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46475	=IF($A91="","",CHOOSE(WEEKDAY(A91,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46476	=IF($A92="","",CHOOSE(WEEKDAY(A92,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46477	=IF($A93="","",CHOOSE(WEEKDAY(A93,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46478	=IF($A94="","",CHOOSE(WEEKDAY(A94,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46479	=IF($A95="","",CHOOSE(WEEKDAY(A95,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46480	=IF($A96="","",CHOOSE(WEEKDAY(A96,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46481	=IF($A97="","",CHOOSE(WEEKDAY(A97,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46482	=IF($A98="","",CHOOSE(WEEKDAY(A98,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46483	=IF($A99="","",CHOOSE(WEEKDAY(A99,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46484	=IF($A100="","",CHOOSE(WEEKDAY(A100,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46485	=IF($A101="","",CHOOSE(WEEKDAY(A101,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46486	=IF($A102="","",CHOOSE(WEEKDAY(A102,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46487	=IF($A103="","",CHOOSE(WEEKDAY(A103,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46488	=IF($A104="","",CHOOSE(WEEKDAY(A104,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46489	=IF($A105="","",CHOOSE(WEEKDAY(A105,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46490	=IF($A106="","",CHOOSE(WEEKDAY(A106,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46491	=IF($A107="","",CHOOSE(WEEKDAY(A107,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46492	=IF($A108="","",CHOOSE(WEEKDAY(A108,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46493	=IF($A109="","",CHOOSE(WEEKDAY(A109,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46494	=IF($A110="","",CHOOSE(WEEKDAY(A110,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46495	=IF($A111="","",CHOOSE(WEEKDAY(A111,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46496	=IF($A112="","",CHOOSE(WEEKDAY(A112,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46497	=IF($A113="","",CHOOSE(WEEKDAY(A113,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46498	=IF($A114="","",CHOOSE(WEEKDAY(A114,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46499	=IF($A115="","",CHOOSE(WEEKDAY(A115,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46500	=IF($A116="","",CHOOSE(WEEKDAY(A116,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46501	=IF($A117="","",CHOOSE(WEEKDAY(A117,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46502	=IF($A118="","",CHOOSE(WEEKDAY(A118,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46503	=IF($A119="","",CHOOSE(WEEKDAY(A119,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46504	=IF($A120="","",CHOOSE(WEEKDAY(A120,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46505	=IF($A121="","",CHOOSE(WEEKDAY(A121,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46506	=IF($A122="","",CHOOSE(WEEKDAY(A122,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	175.0%	1.5	2	合规	1190	1010	1010	1190	1190	1430	1670	1730	1730	2140	3150
46507	=IF($A123="","",CHOOSE(WEEKDAY(A123,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	176.2%	1.5	2	合规	1200	1020	1020	1200	1200	1440	1680	1740	1740	2160	3180
46508	=IF($A124="","",CHOOSE(WEEKDAY(A124,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	177.4%	1.5	2	合规	1210	1030	1030	1210	1210	1450	1690	1750	1750	2180	3210
46509	=IF($A125="","",CHOOSE(WEEKDAY(A125,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	178.6%	1.5	2	合规	1210	1030	1030	1210	1210	1450	1690	1750	1750	2180	3210
46510	=IF($A126="","",CHOOSE(WEEKDAY(A126,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	171.4%	1.5	2	合规	1170	990	990	1170	1170	1400	1640	1700	1700	2110	3100
46511	=IF($A127="","",CHOOSE(WEEKDAY(A127,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46512	=IF($A128="","",CHOOSE(WEEKDAY(A128,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46513	=IF($A129="","",CHOOSE(WEEKDAY(A129,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46514	=IF($A130="","",CHOOSE(WEEKDAY(A130,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	79.2%	0.7	0.85	合规	540	460	460	540	540	650	760	780	780	970	1430
46515	=IF($A131="","",CHOOSE(WEEKDAY(A131,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	80.4%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46516	=IF($A132="","",CHOOSE(WEEKDAY(A132,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46517	=IF($A133="","",CHOOSE(WEEKDAY(A133,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46518	=IF($A134="","",CHOOSE(WEEKDAY(A134,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46519	=IF($A135="","",CHOOSE(WEEKDAY(A135,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46520	=IF($A136="","",CHOOSE(WEEKDAY(A136,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46521	=IF($A137="","",CHOOSE(WEEKDAY(A137,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46522	=IF($A138="","",CHOOSE(WEEKDAY(A138,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46523	=IF($A139="","",CHOOSE(WEEKDAY(A139,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46524	=IF($A140="","",CHOOSE(WEEKDAY(A140,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46525	=IF($A141="","",CHOOSE(WEEKDAY(A141,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46526	=IF($A142="","",CHOOSE(WEEKDAY(A142,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46527	=IF($A143="","",CHOOSE(WEEKDAY(A143,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46528	=IF($A144="","",CHOOSE(WEEKDAY(A144,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46529	=IF($A145="","",CHOOSE(WEEKDAY(A145,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46530	=IF($A146="","",CHOOSE(WEEKDAY(A146,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46531	=IF($A147="","",CHOOSE(WEEKDAY(A147,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46532	=IF($A148="","",CHOOSE(WEEKDAY(A148,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46533	=IF($A149="","",CHOOSE(WEEKDAY(A149,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46534	=IF($A150="","",CHOOSE(WEEKDAY(A150,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46535	=IF($A151="","",CHOOSE(WEEKDAY(A151,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46536	=IF($A152="","",CHOOSE(WEEKDAY(A152,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46537	=IF($A153="","",CHOOSE(WEEKDAY(A153,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46538	=IF($A154="","",CHOOSE(WEEKDAY(A154,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46539	=IF($A155="","",CHOOSE(WEEKDAY(A155,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46540	=IF($A156="","",CHOOSE(WEEKDAY(A156,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46541	=IF($A157="","",CHOOSE(WEEKDAY(A157,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46542	=IF($A158="","",CHOOSE(WEEKDAY(A158,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46543	=IF($A159="","",CHOOSE(WEEKDAY(A159,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46544	=IF($A160="","",CHOOSE(WEEKDAY(A160,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46545	=IF($A161="","",CHOOSE(WEEKDAY(A161,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46546	=IF($A162="","",CHOOSE(WEEKDAY(A162,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46547	=IF($A163="","",CHOOSE(WEEKDAY(A163,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46548	=IF($A164="","",CHOOSE(WEEKDAY(A164,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46549	=IF($A165="","",CHOOSE(WEEKDAY(A165,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46550	=IF($A166="","",CHOOSE(WEEKDAY(A166,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46551	=IF($A167="","",CHOOSE(WEEKDAY(A167,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46552	=IF($A168="","",CHOOSE(WEEKDAY(A168,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46553	=IF($A169="","",CHOOSE(WEEKDAY(A169,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46554	=IF($A170="","",CHOOSE(WEEKDAY(A170,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46555	=IF($A171="","",CHOOSE(WEEKDAY(A171,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46556	=IF($A172="","",CHOOSE(WEEKDAY(A172,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46557	=IF($A173="","",CHOOSE(WEEKDAY(A173,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46558	=IF($A174="","",CHOOSE(WEEKDAY(A174,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46559	=IF($A175="","",CHOOSE(WEEKDAY(A175,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46560	=IF($A176="","",CHOOSE(WEEKDAY(A176,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46561	=IF($A177="","",CHOOSE(WEEKDAY(A177,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46562	=IF($A178="","",CHOOSE(WEEKDAY(A178,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46563	=IF($A179="","",CHOOSE(WEEKDAY(A179,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46564	=IF($A180="","",CHOOSE(WEEKDAY(A180,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46565	=IF($A181="","",CHOOSE(WEEKDAY(A181,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46566	=IF($A182="","",CHOOSE(WEEKDAY(A182,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46567	=IF($A183="","",CHOOSE(WEEKDAY(A183,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46568	=IF($A184="","",CHOOSE(WEEKDAY(A184,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46569	=IF($A185="","",CHOOSE(WEEKDAY(A185,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46570	=IF($A186="","",CHOOSE(WEEKDAY(A186,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46571	=IF($A187="","",CHOOSE(WEEKDAY(A187,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46572	=IF($A188="","",CHOOSE(WEEKDAY(A188,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46573	=IF($A189="","",CHOOSE(WEEKDAY(A189,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46574	=IF($A190="","",CHOOSE(WEEKDAY(A190,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46575	=IF($A191="","",CHOOSE(WEEKDAY(A191,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46576	=IF($A192="","",CHOOSE(WEEKDAY(A192,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46577	=IF($A193="","",CHOOSE(WEEKDAY(A193,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46578	=IF($A194="","",CHOOSE(WEEKDAY(A194,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46579	=IF($A195="","",CHOOSE(WEEKDAY(A195,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46580	=IF($A196="","",CHOOSE(WEEKDAY(A196,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46581	=IF($A197="","",CHOOSE(WEEKDAY(A197,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46582	=IF($A198="","",CHOOSE(WEEKDAY(A198,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46583	=IF($A199="","",CHOOSE(WEEKDAY(A199,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46584	=IF($A200="","",CHOOSE(WEEKDAY(A200,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46585	=IF($A201="","",CHOOSE(WEEKDAY(A201,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46586	=IF($A202="","",CHOOSE(WEEKDAY(A202,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46587	=IF($A203="","",CHOOSE(WEEKDAY(A203,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46588	=IF($A204="","",CHOOSE(WEEKDAY(A204,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46589	=IF($A205="","",CHOOSE(WEEKDAY(A205,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46590	=IF($A206="","",CHOOSE(WEEKDAY(A206,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46591	=IF($A207="","",CHOOSE(WEEKDAY(A207,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46592	=IF($A208="","",CHOOSE(WEEKDAY(A208,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46593	=IF($A209="","",CHOOSE(WEEKDAY(A209,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46594	=IF($A210="","",CHOOSE(WEEKDAY(A210,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46595	=IF($A211="","",CHOOSE(WEEKDAY(A211,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46596	=IF($A212="","",CHOOSE(WEEKDAY(A212,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46597	=IF($A213="","",CHOOSE(WEEKDAY(A213,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46598	=IF($A214="","",CHOOSE(WEEKDAY(A214,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46599	=IF($A215="","",CHOOSE(WEEKDAY(A215,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46600	=IF($A216="","",CHOOSE(WEEKDAY(A216,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46601	=IF($A217="","",CHOOSE(WEEKDAY(A217,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46602	=IF($A218="","",CHOOSE(WEEKDAY(A218,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46603	=IF($A219="","",CHOOSE(WEEKDAY(A219,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46604	=IF($A220="","",CHOOSE(WEEKDAY(A220,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46605	=IF($A221="","",CHOOSE(WEEKDAY(A221,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46606	=IF($A222="","",CHOOSE(WEEKDAY(A222,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46607	=IF($A223="","",CHOOSE(WEEKDAY(A223,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46608	=IF($A224="","",CHOOSE(WEEKDAY(A224,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46609	=IF($A225="","",CHOOSE(WEEKDAY(A225,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46610	=IF($A226="","",CHOOSE(WEEKDAY(A226,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46611	=IF($A227="","",CHOOSE(WEEKDAY(A227,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46612	=IF($A228="","",CHOOSE(WEEKDAY(A228,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46613	=IF($A229="","",CHOOSE(WEEKDAY(A229,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46614	=IF($A230="","",CHOOSE(WEEKDAY(A230,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46615	=IF($A231="","",CHOOSE(WEEKDAY(A231,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46616	=IF($A232="","",CHOOSE(WEEKDAY(A232,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46617	=IF($A233="","",CHOOSE(WEEKDAY(A233,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46618	=IF($A234="","",CHOOSE(WEEKDAY(A234,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46619	=IF($A235="","",CHOOSE(WEEKDAY(A235,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46620	=IF($A236="","",CHOOSE(WEEKDAY(A236,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46621	=IF($A237="","",CHOOSE(WEEKDAY(A237,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46622	=IF($A238="","",CHOOSE(WEEKDAY(A238,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46623	=IF($A239="","",CHOOSE(WEEKDAY(A239,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46624	=IF($A240="","",CHOOSE(WEEKDAY(A240,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46625	=IF($A241="","",CHOOSE(WEEKDAY(A241,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46626	=IF($A242="","",CHOOSE(WEEKDAY(A242,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46627	=IF($A243="","",CHOOSE(WEEKDAY(A243,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46628	=IF($A244="","",CHOOSE(WEEKDAY(A244,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46629	=IF($A245="","",CHOOSE(WEEKDAY(A245,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46630	=IF($A246="","",CHOOSE(WEEKDAY(A246,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46631	=IF($A247="","",CHOOSE(WEEKDAY(A247,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46632	=IF($A248="","",CHOOSE(WEEKDAY(A248,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46633	=IF($A249="","",CHOOSE(WEEKDAY(A249,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46634	=IF($A250="","",CHOOSE(WEEKDAY(A250,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46635	=IF($A251="","",CHOOSE(WEEKDAY(A251,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46636	=IF($A252="","",CHOOSE(WEEKDAY(A252,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46637	=IF($A253="","",CHOOSE(WEEKDAY(A253,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46638	=IF($A254="","",CHOOSE(WEEKDAY(A254,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46639	=IF($A255="","",CHOOSE(WEEKDAY(A255,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46640	=IF($A256="","",CHOOSE(WEEKDAY(A256,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46641	=IF($A257="","",CHOOSE(WEEKDAY(A257,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46642	=IF($A258="","",CHOOSE(WEEKDAY(A258,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46643	=IF($A259="","",CHOOSE(WEEKDAY(A259,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46644	=IF($A260="","",CHOOSE(WEEKDAY(A260,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46645	=IF($A261="","",CHOOSE(WEEKDAY(A261,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46646	=IF($A262="","",CHOOSE(WEEKDAY(A262,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46647	=IF($A263="","",CHOOSE(WEEKDAY(A263,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46648	=IF($A264="","",CHOOSE(WEEKDAY(A264,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46649	=IF($A265="","",CHOOSE(WEEKDAY(A265,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46650	=IF($A266="","",CHOOSE(WEEKDAY(A266,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46651	=IF($A267="","",CHOOSE(WEEKDAY(A267,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46652	=IF($A268="","",CHOOSE(WEEKDAY(A268,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46653	=IF($A269="","",CHOOSE(WEEKDAY(A269,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	163.0%	1.5	2	合规	1110	940	940	1110	1110	1330	1550	1610	1610	2000	2940
46654	=IF($A270="","",CHOOSE(WEEKDAY(A270,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	164.2%	1.5	2	合规	1120	950	950	1120	1120	1340	1570	1620	1620	2020	2970
46655	=IF($A271="","",CHOOSE(WEEKDAY(A271,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46656	=IF($A272="","",CHOOSE(WEEKDAY(A272,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46657	=IF($A273="","",CHOOSE(WEEKDAY(A273,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46658	=IF($A274="","",CHOOSE(WEEKDAY(A274,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46659	=IF($A275="","",CHOOSE(WEEKDAY(A275,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46660	=IF($A276="","",CHOOSE(WEEKDAY(A276,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46661	=IF($A277="","",CHOOSE(WEEKDAY(A277,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	176.2%	1.5	2	合规	1200	1020	1020	1200	1200	1440	1680	1740	1740	2160	3180
46662	=IF($A278="","",CHOOSE(WEEKDAY(A278,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	177.4%	1.5	2	合规	1210	1030	1030	1210	1210	1450	1690	1750	1750	2180	3210
46663	=IF($A279="","",CHOOSE(WEEKDAY(A279,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	178.6%	1.5	2	合规	1210	1030	1030	1210	1210	1450	1690	1750	1750	2180	3210
46664	=IF($A280="","",CHOOSE(WEEKDAY(A280,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	171.4%	1.5	2	合规	1170	990	990	1170	1170	1400	1640	1700	1700	2110	3100
46665	=IF($A281="","",CHOOSE(WEEKDAY(A281,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	172.6%	1.5	2	合规	1170	990	990	1170	1170	1400	1640	1700	1700	2110	3100
46666	=IF($A282="","",CHOOSE(WEEKDAY(A282,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46667	=IF($A283="","",CHOOSE(WEEKDAY(A283,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46668	=IF($A284="","",CHOOSE(WEEKDAY(A284,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	79.2%	0.7	0.85	合规	540	460	460	540	540	650	760	780	780	970	1430
46669	=IF($A285="","",CHOOSE(WEEKDAY(A285,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	80.4%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46670	=IF($A286="","",CHOOSE(WEEKDAY(A286,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46671	=IF($A287="","",CHOOSE(WEEKDAY(A287,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46672	=IF($A288="","",CHOOSE(WEEKDAY(A288,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46673	=IF($A289="","",CHOOSE(WEEKDAY(A289,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46674	=IF($A290="","",CHOOSE(WEEKDAY(A290,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46675	=IF($A291="","",CHOOSE(WEEKDAY(A291,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46676	=IF($A292="","",CHOOSE(WEEKDAY(A292,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46677	=IF($A293="","",CHOOSE(WEEKDAY(A293,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46678	=IF($A294="","",CHOOSE(WEEKDAY(A294,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46679	=IF($A295="","",CHOOSE(WEEKDAY(A295,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46680	=IF($A296="","",CHOOSE(WEEKDAY(A296,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	173.8%	1.5	2	合规	1180	1000	1000	1180	1180	1420	1650	1710	1710	2120	3130
46681	=IF($A297="","",CHOOSE(WEEKDAY(A297,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	175.0%	1.5	2	合规	1190	1010	1010	1190	1190	1430	1670	1730	1730	2140	3150
46682	=IF($A298="","",CHOOSE(WEEKDAY(A298,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	176.2%	1.5	2	合规	1200	1020	1020	1200	1200	1440	1680	1740	1740	2160	3180
46683	=IF($A299="","",CHOOSE(WEEKDAY(A299,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46684	=IF($A300="","",CHOOSE(WEEKDAY(A300,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46685	=IF($A301="","",CHOOSE(WEEKDAY(A301,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46686	=IF($A302="","",CHOOSE(WEEKDAY(A302,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46687	=IF($A303="","",CHOOSE(WEEKDAY(A303,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46688	=IF($A304="","",CHOOSE(WEEKDAY(A304,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46689	=IF($A305="","",CHOOSE(WEEKDAY(A305,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	136.2%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46690	=IF($A306="","",CHOOSE(WEEKDAY(A306,2),"周一","周二","周三","周四","周五","周六","周日"))	D2	137.4%	1.2	1.5	合规	930	790	790	930	930	1120	1300	1350	1350	1670	2460
46691	=IF($A307="","",CHOOSE(WEEKDAY(A307,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46692	=IF($A308="","",CHOOSE(WEEKDAY(A308,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46693	=IF($A309="","",CHOOSE(WEEKDAY(A309,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46694	=IF($A310="","",CHOOSE(WEEKDAY(A310,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46695	=IF($A311="","",CHOOSE(WEEKDAY(A311,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46696	=IF($A312="","",CHOOSE(WEEKDAY(A312,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46697	=IF($A313="","",CHOOSE(WEEKDAY(A313,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	177.4%	1.5	2	合规	1210	1030	1030	1210	1210	1450	1690	1750	1750	2180	3210
46698	=IF($A314="","",CHOOSE(WEEKDAY(A314,2),"周一","周二","周三","周四","周五","周六","周日"))	D1	178.6%	1.5	2	合规	1210	1030	1030	1210	1210	1450	1690	1750	1750	2180	3210
46699	=IF($A315="","",CHOOSE(WEEKDAY(A315,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46700	=IF($A316="","",CHOOSE(WEEKDAY(A316,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46701	=IF($A317="","",CHOOSE(WEEKDAY(A317,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46702	=IF($A318="","",CHOOSE(WEEKDAY(A318,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46703	=IF($A319="","",CHOOSE(WEEKDAY(A319,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46704	=IF($A320="","",CHOOSE(WEEKDAY(A320,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46705	=IF($A321="","",CHOOSE(WEEKDAY(A321,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46706	=IF($A322="","",CHOOSE(WEEKDAY(A322,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46707	=IF($A323="","",CHOOSE(WEEKDAY(A323,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46708	=IF($A324="","",CHOOSE(WEEKDAY(A324,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46709	=IF($A325="","",CHOOSE(WEEKDAY(A325,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46710	=IF($A326="","",CHOOSE(WEEKDAY(A326,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46711	=IF($A327="","",CHOOSE(WEEKDAY(A327,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46712	=IF($A328="","",CHOOSE(WEEKDAY(A328,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46713	=IF($A329="","",CHOOSE(WEEKDAY(A329,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46714	=IF($A330="","",CHOOSE(WEEKDAY(A330,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46715	=IF($A331="","",CHOOSE(WEEKDAY(A331,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46716	=IF($A332="","",CHOOSE(WEEKDAY(A332,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46717	=IF($A333="","",CHOOSE(WEEKDAY(A333,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46718	=IF($A334="","",CHOOSE(WEEKDAY(A334,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46719	=IF($A335="","",CHOOSE(WEEKDAY(A335,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46720	=IF($A336="","",CHOOSE(WEEKDAY(A336,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46721	=IF($A337="","",CHOOSE(WEEKDAY(A337,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46722	=IF($A338="","",CHOOSE(WEEKDAY(A338,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46723	=IF($A339="","",CHOOSE(WEEKDAY(A339,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46724	=IF($A340="","",CHOOSE(WEEKDAY(A340,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46725	=IF($A341="","",CHOOSE(WEEKDAY(A341,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46726	=IF($A342="","",CHOOSE(WEEKDAY(A342,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46727	=IF($A343="","",CHOOSE(WEEKDAY(A343,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46728	=IF($A344="","",CHOOSE(WEEKDAY(A344,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46729	=IF($A345="","",CHOOSE(WEEKDAY(A345,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46730	=IF($A346="","",CHOOSE(WEEKDAY(A346,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46731	=IF($A347="","",CHOOSE(WEEKDAY(A347,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46732	=IF($A348="","",CHOOSE(WEEKDAY(A348,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46733	=IF($A349="","",CHOOSE(WEEKDAY(A349,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46734	=IF($A350="","",CHOOSE(WEEKDAY(A350,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	98.4%	0.95	1.1	合规	670	570	570	670	670	800	940	970	970	1210	1780
46735	=IF($A351="","",CHOOSE(WEEKDAY(A351,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	99.6%	0.95	1.1	合规	680	580	580	680	680	820	950	990	990	1220	1800
46736	=IF($A352="","",CHOOSE(WEEKDAY(A352,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	100.8%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46737	=IF($A353="","",CHOOSE(WEEKDAY(A353,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	102.0%	0.95	1.1	合规	690	590	590	690	690	830	970	1000	1000	1240	1830
46738	=IF($A354="","",CHOOSE(WEEKDAY(A354,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46739	=IF($A355="","",CHOOSE(WEEKDAY(A355,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46740	=IF($A356="","",CHOOSE(WEEKDAY(A356,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	105.6%	0.95	1.1	合规	720	610	610	720	720	860	1010	1040	1040	1300	1910
46741	=IF($A357="","",CHOOSE(WEEKDAY(A357,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46742	=IF($A358="","",CHOOSE(WEEKDAY(A358,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46743	=IF($A359="","",CHOOSE(WEEKDAY(A359,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46744	=IF($A360="","",CHOOSE(WEEKDAY(A360,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46745	=IF($A361="","",CHOOSE(WEEKDAY(A361,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860
46746	=IF($A362="","",CHOOSE(WEEKDAY(A362,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	104.4%	0.95	1.1	合规	710	600	600	710	710	850	990	1030	1030	1280	1880
46747	=IF($A363="","",CHOOSE(WEEKDAY(A363,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	81.6%	0.7	0.85	合规	550	470	470	550	550	660	770	800	800	990	1460
46748	=IF($A364="","",CHOOSE(WEEKDAY(A364,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	74.4%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46749	=IF($A365="","",CHOOSE(WEEKDAY(A365,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	75.6%	0.7	0.85	合规	510	430	430	510	510	610	710	740	740	920	1350
46750	=IF($A366="","",CHOOSE(WEEKDAY(A366,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	76.8%	0.7	0.85	合规	520	440	440	520	520	620	730	750	750	940	1380
46751	=IF($A367="","",CHOOSE(WEEKDAY(A367,2),"周一","周二","周三","周四","周五","周六","周日"))	D4	78.0%	0.7	0.85	合规	530	450	450	530	530	640	740	770	770	950	1400
46752	=IF($A368="","",CHOOSE(WEEKDAY(A368,2),"周一","周二","周三","周四","周五","周六","周日"))	D3	103.2%	0.95	1.1	合规	700	600	600	700	700	840	980	1020	1020	1260	1860

价差校验 ·《法典》表 F（每周一执行）
全部为公式，数据源＝「价格阶梯」页基础价列。改动基准 BAR 或系数后，本页结论自动更新。
—	—	—	—	—	—	—	—	—
一、相邻房型价差校验（<8% 拉开价差，>35% 收敛价差）
序号	下档房型	下档价	上档房型	上档价	价差%	判定	建议动作	备注
1	STD-K 标准大床房	580	SUP-K 高级大床房	680	0.1724137931034483	健康	维持	—
2	SUP-K 高级大床房	680	SUP-T 高级双床房	680	0	价差过小	拉开价差（降下一档或提上一档）	—
3	SUP-T 高级双床房	680	DLX-K 豪华大床房	820	0.20588235294117646	健康	维持	—
4	DLX-K 豪华大床房	820	EXE-K 行政大床房	990	0.2073170731707317	健康	维持	SPEC 表 F 中 DLX-V(140) 与 EXE(145) 仅差 3.6%，<8% → 判定为「价差过小」，须拉开
5	EXE-K 行政大床房	990	STE-B 商务套房	1220	0.23232323232323232	健康	维持	商务套房相对行政房 +24.1%，处于 8%–35% 健康区间
6	STE-B 商务套房	1220	STE-E 行政套房	1800	0.47540983606557374	价差过大	收敛价差（提下一档）	SPEC 表 F 中 STE-B(180) 与 STE-E(265) 差 47.2%，>35% → 判定为「价差过大」，须收敛
—	—	—	—	—	—	—	—	—
二、套房与最高房型价差校验（<60% 提套房价）
序号	套房	套房价	最高非套房房型	该房型价	价差%	判定	建议动作	备注
1	STE-B 商务套房	1220	EXE-K 行政大床房（非套房最高档）	990	0.23232323232323232	价差不足	提套房价	按 SPEC 表 F 阶梯，STE-B(180) 相对 EXE(145) 仅 +24.1%，会持续报「价差不足」；教学时说明：表 F 该条主要针对顶级套房（STE-E 265，+82.8% 达标），商务套房须结合升级路径与行政楼层权益综合判断，不宜机械执行。
2	STE-E 行政套房	1800	EXE-K 行政大床房（非套房最高档）	990	0.8181818181818182	达标	维持	STE-E(265) 相对 EXE(145) +82.8%，≥60%，达标。
—	—	—	—	—	—	—	—	—
三、《法典》表 F 校验规则（原文）
相邻房型价差 <8% → 拉开价差（降下一档或提上一档）
相邻房型价差 >35% → 收敛价差（提下一档）
套房与最高房型价差 <60% → 提套房价
附加项：高楼层 +5%；江景/特色景观 +10%；含早 +¥68/人；连通房 +¥50；加床 +¥180
执行频率：每周一（《法典》表 N）；结果写入 04 号《调价台账》