03_竞争比价监测表.xlsx
03 · 竞争比价监测表 ｜ 使用说明
不知道竞对今天卖多少钱，就不知道自己该卖多少钱。
一、用途
用于《法典》表 M 08:10 节点「采集竞争组合 5 家价格」，以及表 C（ARI）、表 D（MPI）的每日诊断。
「每日比价」页按 STD / SUP / DLX 三个房型层级采集本店与 5 家竞对的 BAR，按房量加权算出竞争组合均价与 ARI。
「竞对档案」页是 5 家竞对的固定参数（SPEC 2.4），房量列作为加权权重被引用。
「ARI诊断」页输入 ARI / MPI / 预测 OCC，自动查表 C 输出判定、动作与调整幅度。
—————
二、填色规则
—输入区浅黄底 + 边框由学员填写，例如日期、房晚、价格
—公式区白底 + 边框已预置 Excel 公式，改动会导致结果错误，请勿手改
—参考区灰底 + 斜体SPEC 固定参数/判定表，一般不需要改动
—标题行深蓝底白字字段名，冻结在首行
—————
三、字段字典
列字段名称类型口径 / 预置公式说明
A-C日期 / 星期 / 需求等级输入—需求等级按 SPEC 2.5 判 D1–D4
D-F本店 STD/SUP/DLX BAR输入—公开可订的最优可用房价
G本店加权 BAR公式=AVERAGE(D:F)三房型层级等权平均
H-V5 家竞对 × 3 房型 BAR输入—每日 08:10 采集
W竞争组合加权均价公式=Σ(竞对三房型价之和 × 竞对房量) ÷ (3 × 房量合计)按房量加权，非简单平均
XARI（BAR 口径）公式#NAME?SPEC 3.1
YARI 环比公式#NAME?涨红跌绿
AAARI（实绩口径）公式#NAME?用实际 ADR，与日报一致
B-E(诊断页)ARI / MPI / 预测 OCC输入—三个输入驱动整行输出
F-H(诊断页)判定 / 动作 / 调整幅度公式嵌套 IF 实现表 C 七档幅度正=提价(红)，负=降价(绿)
—————
四、使用步骤
1在「竞对档案」页确认 5 家竞对的房量与平峰 BAR（默认取自 SPEC 2.4）。
2每日 08:10 采集 5 家竞对 STD / SUP / DLX 的 BAR，填入「每日比价」页黄底区。
3读 W 列组合加权均价与 X 列 ARI；把 ARI 抄到「ARI诊断」页 B 列，同时填 C 列 MPI 与 E 列预测 OCC。
4读「建议动作」列，按《法典》表 O 与表 A 冲突时取优先级：表 A > 表 C。
5动作写入 04 号《调价台账》，未执行的记入「观察清单」。
—————
五、关联《收益管理操作法典》
表 C · 价格指数（ARI）判定表 —— 已内嵌在「ARI诊断」页底部作参考，并用嵌套 IF 实现自动查表。
表 D · 市场渗透指数（MPI）判定表 —— MPI 列读出后查表 D（在 01 号日报套用）。
表 O · 决策优先级 —— 表 C 优先级 4，低于表 A（3）与表 B（2），不得与表 A 叠加执行。
表 M · 08:10 节点要求 20 分钟内完成比价采集。
—————
杭州滨江云璟酒店 · 320 间房 · 中高端全服务 ｜ 酒店收益管理学院 HRMA ｜ 口径以 SPEC.md 为准
每日竞争比价监测表 · 本店 vs 5 家竞对
黄底=输入（每日采集的 BAR）。白底=公式：组合加权均价按竞对房量加权，ARI = 本店加权 BAR ÷ 组合加权均价 × 100。
日期星期需求 等级本店 STD本店 SUP本店 DLX本店 加权BARA STDA SUPA DLXB STDB SUPB DLXC STDC SUPC DLXD STDD SUPD DLXE STDE SUPE DLX竞争组合 加权均价ARI (BAR口径)ARI 环比本店昨日 ADRARI (实绩口径)备注
2026-03-01 00:00:00=IF($A4="","",CHOOSE(WEEKDAY(A4,2),"周一","周二","周三","周四","周五","周六","周日"))D4457524662=IFERROR(AVERAGE($D4:$F4),"")450540650480560710400470560610710900430500610=IFERROR(((G4+H4+I4)*竞对档案!$D$4+(J4+K4+L4)*竞对档案!$D$5+(M4+N4+O4)*竞对档案!$D$6+(P4+Q4+R4)*竞对档案!$D$7+(S4+T4+U4)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J4/V4*100,"")—538=IFERROR(Z4/V4*100,"")—
2026-03-02 00:00:00=IF($A5="","",CHOOSE(WEEKDAY(A5,2),"周一","周二","周三","周四","周五","周六","周日"))D4446524652=IFERROR(AVERAGE($D5:$F5),"")460520650480570690390450570620730930440510600=IFERROR(((G5+H5+I5)*竞对档案!$D$4+(J5+K5+L5)*竞对档案!$D$5+(M5+N5+O5)*竞对档案!$D$6+(P5+Q5+R5)*竞对档案!$D$7+(S5+T5+U5)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J5/V5*100,"")=IFERROR(X5-X4,"")550=IFERROR(Z5/V5*100,"")—
2026-03-03 00:00:00=IF($A6="","",CHOOSE(WEEKDAY(A6,2),"周一","周二","周三","周四","周五","周六","周日"))D4454523646=IFERROR(AVERAGE($D6:$F6),"")460550660480550690390460560600740880440500620=IFERROR(((G6+H6+I6)*竞对档案!$D$4+(J6+K6+L6)*竞对档案!$D$5+(M6+N6+O6)*竞对档案!$D$6+(P6+Q6+R6)*竞对档案!$D$7+(S6+T6+U6)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J6/V6*100,"")=IFERROR(X6-X5,"")523=IFERROR(Z6/V6*100,"")—
2026-03-04 00:00:00=IF($A7="","",CHOOSE(WEEKDAY(A7,2),"周一","周二","周三","周四","周五","周六","周日"))D4446526649=IFERROR(AVERAGE($D7:$F7),"")470530660490580710400460570620740920450510620=IFERROR(((G7+H7+I7)*竞对档案!$D$4+(J7+K7+L7)*竞对档案!$D$5+(M7+N7+O7)*竞对档案!$D$6+(P7+Q7+R7)*竞对档案!$D$7+(S7+T7+U7)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J7/V7*100,"")=IFERROR(X7-X6,"")533=IFERROR(Z7/V7*100,"")—
2026-03-05 00:00:00=IF($A8="","",CHOOSE(WEEKDAY(A8,2),"周一","周二","周三","周四","周五","周六","周日"))D4456523641=IFERROR(AVERAGE($D8:$F8),"")470520670480570700390470570620710920450520620=IFERROR(((G8+H8+I8)*竞对档案!$D$4+(J8+K8+L8)*竞对档案!$D$5+(M8+N8+O8)*竞对档案!$D$6+(P8+Q8+R8)*竞对档案!$D$7+(S8+T8+U8)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J8/V8*100,"")=IFERROR(X8-X7,"")533=IFERROR(Z8/V8*100,"")—
2026-03-06 00:00:00=IF($A9="","",CHOOSE(WEEKDAY(A9,2),"周一","周二","周三","周四","周五","周六","周日"))D289610151228=IFERROR(AVERAGE($D9:$F9),"")64073092068079094056064081083010001310630700880=IFERROR(((G9+H9+I9)*竞对档案!$D$4+(J9+K9+L9)*竞对档案!$D$5+(M9+N9+O9)*竞对档案!$D$6+(P9+Q9+R9)*竞对档案!$D$7+(S9+T9+U9)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J9/V9*100,"")=IFERROR(X9-X8,"")1070=IFERROR(Z9/V9*100,"")—
2026-03-07 00:00:00=IF($A10="","",CHOOSE(WEEKDAY(A10,2),"周一","周二","周三","周四","周五","周六","周日"))D286310231250=IFERROR(AVERAGE($D10:$F10),"")64077089070082098054065082087010001240610700830=IFERROR(((G10+H10+I10)*竞对档案!$D$4+(J10+K10+L10)*竞对档案!$D$5+(M10+N10+O10)*竞对档案!$D$6+(P10+Q10+R10)*竞对档案!$D$7+(S10+T10+U10)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J10/V10*100,"")=IFERROR(X10-X9,"")994=IFERROR(Z10/V10*100,"")—
2026-03-08 00:00:00=IF($A11="","",CHOOSE(WEEKDAY(A11,2),"周一","周二","周三","周四","周五","周六","周日"))D3618740899=IFERROR(AVERAGE($D11:$F11),"")5606608005907008404705606907608701130550640730=IFERROR(((G11+H11+I11)*竞对档案!$D$4+(J11+K11+L11)*竞对档案!$D$5+(M11+N11+O11)*竞对档案!$D$6+(P11+Q11+R11)*竞对档案!$D$7+(S11+T11+U11)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J11/V11*100,"")=IFERROR(X11-X10,"")722=IFERROR(Z11/V11*100,"")—
2026-03-09 00:00:00=IF($A12="","",CHOOSE(WEEKDAY(A12,2),"周一","周二","周三","周四","周五","周六","周日"))D3621734907=IFERROR(AVERAGE($D12:$F12),"")5606608005906708304805706907208801080540620750=IFERROR(((G12+H12+I12)*竞对档案!$D$4+(J12+K12+L12)*竞对档案!$D$5+(M12+N12+O12)*竞对档案!$D$6+(P12+Q12+R12)*竞对档案!$D$7+(S12+T12+U12)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J12/V12*100,"")=IFERROR(X12-X11,"")687=IFERROR(Z12/V12*100,"")—
2026-03-10 00:00:00=IF($A13="","",CHOOSE(WEEKDAY(A13,2),"周一","周二","周三","周四","周五","周六","周日"))D3630726891=IFERROR(AVERAGE($D13:$F13),"")5606707805806808204805506907408501120550630750=IFERROR(((G13+H13+I13)*竞对档案!$D$4+(J13+K13+L13)*竞对档案!$D$5+(M13+N13+O13)*竞对档案!$D$6+(P13+Q13+R13)*竞对档案!$D$7+(S13+T13+U13)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J13/V13*100,"")=IFERROR(X13-X12,"")754=IFERROR(Z13/V13*100,"")—
2026-03-11 00:00:00=IF($A14="","",CHOOSE(WEEKDAY(A14,2),"周一","周二","周三","周四","周五","周六","周日"))D3627730880=IFERROR(AVERAGE($D14:$F14),"")5706408206006908404905706907508701090530630750=IFERROR(((G14+H14+I14)*竞对档案!$D$4+(J14+K14+L14)*竞对档案!$D$5+(M14+N14+O14)*竞对档案!$D$6+(P14+Q14+R14)*竞对档案!$D$7+(S14+T14+U14)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J14/V14*100,"")=IFERROR(X14-X13,"")761=IFERROR(Z14/V14*100,"")—
2026-03-12 00:00:00=IF($A15="","",CHOOSE(WEEKDAY(A15,2),"周一","周二","周三","周四","周五","周六","周日"))D3618727899=IFERROR(AVERAGE($D15:$F15),"")5506307905807008304905507107408801140550630750=IFERROR(((G15+H15+I15)*竞对档案!$D$4+(J15+K15+L15)*竞对档案!$D$5+(M15+N15+O15)*竞对档案!$D$6+(P15+Q15+R15)*竞对档案!$D$7+(S15+T15+U15)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J15/V15*100,"")=IFERROR(X15-X14,"")759=IFERROR(Z15/V15*100,"")—
2026-03-13 00:00:00=IF($A16="","",CHOOSE(WEEKDAY(A16,2),"周一","周二","周三","周四","周五","周六","周日"))D1120313581649=IFERROR(AVERAGE($D16:$F16),"")76090010808009301140630750940980121015207408501000=IFERROR(((G16+H16+I16)*竞对档案!$D$4+(J16+K16+L16)*竞对档案!$D$5+(M16+N16+O16)*竞对档案!$D$6+(P16+Q16+R16)*竞对档案!$D$7+(S16+T16+U16)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J16/V16*100,"")=IFERROR(X16-X15,"")1433=IFERROR(Z16/V16*100,"")—
2026-03-14 00:00:00=IF($A17="","",CHOOSE(WEEKDAY(A17,2),"周一","周二","周三","周四","周五","周六","周日"))D1119514071706=IFERROR(AVERAGE($D17:$F17),"")7308801050790920111063075093099012101530730840990=IFERROR(((G17+H17+I17)*竞对档案!$D$4+(J17+K17+L17)*竞对档案!$D$5+(M17+N17+O17)*竞对档案!$D$6+(P17+Q17+R17)*竞对档案!$D$7+(S17+T17+U17)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J17/V17*100,"")=IFERROR(X17-X16,"")1366=IFERROR(Z17/V17*100,"")—
2026-03-15 00:00:00=IF($A18="","",CHOOSE(WEEKDAY(A18,2),"周一","周二","周三","周四","周五","周六","周日"))D1116813811676=IFERROR(AVERAGE($D18:$F18),"")76089010708109401130650750940100011801450740830990=IFERROR(((G18+H18+I18)*竞对档案!$D$4+(J18+K18+L18)*竞对档案!$D$5+(M18+N18+O18)*竞对档案!$D$6+(P18+Q18+R18)*竞对档案!$D$7+(S18+T18+U18)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J18/V18*100,"")=IFERROR(X18-X17,"")1334=IFERROR(Z18/V18*100,"")—
2026-03-16 00:00:00=IF($A19="","",CHOOSE(WEEKDAY(A19,2),"周一","周二","周三","周四","周五","周六","周日"))D3612721880=IFERROR(AVERAGE($D19:$F19),"")5706707706007108504805506807409001090530630740=IFERROR(((G19+H19+I19)*竞对档案!$D$4+(J19+K19+L19)*竞对档案!$D$5+(M19+N19+O19)*竞对档案!$D$6+(P19+Q19+R19)*竞对档案!$D$7+(S19+T19+U19)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J19/V19*100,"")=IFERROR(X19-X18,"")705=IFERROR(Z19/V19*100,"")—
2026-03-17 00:00:00=IF($A20="","",CHOOSE(WEEKDAY(A20,2),"周一","周二","周三","周四","周五","周六","周日"))D3610737894=IFERROR(AVERAGE($D20:$F20),"")5506607806006808704805707107408801120550610740=IFERROR(((G20+H20+I20)*竞对档案!$D$4+(J20+K20+L20)*竞对档案!$D$5+(M20+N20+O20)*竞对档案!$D$6+(P20+Q20+R20)*竞对档案!$D$7+(S20+T20+U20)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J20/V20*100,"")=IFERROR(X20-X19,"")707=IFERROR(Z20/V20*100,"")—
2026-03-18 00:00:00=IF($A21="","",CHOOSE(WEEKDAY(A21,2),"周一","周二","周三","周四","周五","周六","周日"))D3623716900=IFERROR(AVERAGE($D21:$F21),"")5706507906107008604705707007508901090540640750=IFERROR(((G21+H21+I21)*竞对档案!$D$4+(J21+K21+L21)*竞对档案!$D$5+(M21+N21+O21)*竞对档案!$D$6+(P21+Q21+R21)*竞对档案!$D$7+(S21+T21+U21)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J21/V21*100,"")=IFERROR(X21-X20,"")730=IFERROR(Z21/V21*100,"")—
2026-03-19 00:00:00=IF($A22="","",CHOOSE(WEEKDAY(A22,2),"周一","周二","周三","周四","周五","周六","周日"))D3630743873=IFERROR(AVERAGE($D22:$F22),"")570650780590690860480570690430520650550630750=IFERROR(((G22+H22+I22)*竞对档案!$D$4+(J22+K22+L22)*竞对档案!$D$5+(M22+N22+O22)*竞对档案!$D$6+(P22+Q22+R22)*竞对档案!$D$7+(S22+T22+U22)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J22/V22*100,"")=IFERROR(X22-X21,"")731=IFERROR(Z22/V22*100,"")D 竞对 3/18–3/21 恶意降价（埋点）
2026-03-20 00:00:00=IF($A23="","",CHOOSE(WEEKDAY(A23,2),"周一","周二","周三","周四","周五","周六","周日"))D287610301259=IFERROR(AVERAGE($D23:$F23),"")630740890700810950560650810450530670610730850=IFERROR(((G23+H23+I23)*竞对档案!$D$4+(J23+K23+L23)*竞对档案!$D$5+(M23+N23+O23)*竞对档案!$D$6+(P23+Q23+R23)*竞对档案!$D$7+(S23+T23+U23)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J23/V23*100,"")=IFERROR(X23-X22,"")1011=IFERROR(Z23/V23*100,"")D 竞对 3/18–3/21 恶意降价（埋点）
2026-03-21 00:00:00=IF($A24="","",CHOOSE(WEEKDAY(A24,2),"周一","周二","周三","周四","周五","周六","周日"))D286510201246=IFERROR(AVERAGE($D24:$F24),"")630730930700780940550630810440540670610690880=IFERROR(((G24+H24+I24)*竞对档案!$D$4+(J24+K24+L24)*竞对档案!$D$5+(M24+N24+O24)*竞对档案!$D$6+(P24+Q24+R24)*竞对档案!$D$7+(S24+T24+U24)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J24/V24*100,"")=IFERROR(X24-X23,"")980=IFERROR(Z24/V24*100,"")D 竞对 3/18–3/21 恶意降价（埋点）
2026-03-22 00:00:00=IF($A25="","",CHOOSE(WEEKDAY(A25,2),"周一","周二","周三","周四","周五","周六","周日"))D3610724887=IFERROR(AVERAGE($D25:$F25),"")540640800600680830480570690440540670540600730=IFERROR(((G25+H25+I25)*竞对档案!$D$4+(J25+K25+L25)*竞对档案!$D$5+(M25+N25+O25)*竞对档案!$D$6+(P25+Q25+R25)*竞对档案!$D$7+(S25+T25+U25)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J25/V25*100,"")=IFERROR(X25-X24,"")767=IFERROR(Z25/V25*100,"")D 竞对 3/18–3/21 恶意降价（埋点）
2026-03-23 00:00:00=IF($A26="","",CHOOSE(WEEKDAY(A26,2),"周一","周二","周三","周四","周五","周六","周日"))D3625726888=IFERROR(AVERAGE($D26:$F26),"")5706507905806908204605607107208701110540620760=IFERROR(((G26+H26+I26)*竞对档案!$D$4+(J26+K26+L26)*竞对档案!$D$5+(M26+N26+O26)*竞对档案!$D$6+(P26+Q26+R26)*竞对档案!$D$7+(S26+T26+U26)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J26/V26*100,"")=IFERROR(X26-X25,"")724=IFERROR(Z26/V26*100,"")—
2026-03-24 00:00:00=IF($A27="","",CHOOSE(WEEKDAY(A27,2),"周一","周二","周三","周四","周五","周六","周日"))D3618741879=IFERROR(AVERAGE($D27:$F27),"")5706408106106908204905507007608901110550620740=IFERROR(((G27+H27+I27)*竞对档案!$D$4+(J27+K27+L27)*竞对档案!$D$5+(M27+N27+O27)*竞对档案!$D$6+(P27+Q27+R27)*竞对档案!$D$7+(S27+T27+U27)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J27/V27*100,"")=IFERROR(X27-X26,"")740=IFERROR(Z27/V27*100,"")—
2026-03-25 00:00:00=IF($A28="","",CHOOSE(WEEKDAY(A28,2),"周一","周二","周三","周四","周五","周六","周日"))D3611739892=IFERROR(AVERAGE($D28:$F28),"")5506607805906708504705607107408701110540630750=IFERROR(((G28+H28+I28)*竞对档案!$D$4+(J28+K28+L28)*竞对档案!$D$5+(M28+N28+O28)*竞对档案!$D$6+(P28+Q28+R28)*竞对档案!$D$7+(S28+T28+U28)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J28/V28*100,"")=IFERROR(X28-X27,"")689=IFERROR(Z28/V28*100,"")—
2026-03-26 00:00:00=IF($A29="","",CHOOSE(WEEKDAY(A29,2),"周一","周二","周三","周四","周五","周六","周日"))D3621722886=IFERROR(AVERAGE($D29:$F29),"")5706407705806708604705507107608901090530630740=IFERROR(((G29+H29+I29)*竞对档案!$D$4+(J29+K29+L29)*竞对档案!$D$5+(M29+N29+O29)*竞对档案!$D$6+(P29+Q29+R29)*竞对档案!$D$7+(S29+T29+U29)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J29/V29*100,"")=IFERROR(X29-X28,"")758=IFERROR(Z29/V29*100,"")—
2026-03-27 00:00:00=IF($A30="","",CHOOSE(WEEKDAY(A30,2),"周一","周二","周三","周四","周五","周六","周日"))D287410311273=IFERROR(AVERAGE($D30:$F30),"")64074090067080098055065082087010301270640730880=IFERROR(((G30+H30+I30)*竞对档案!$D$4+(J30+K30+L30)*竞对档案!$D$5+(M30+N30+O30)*竞对档案!$D$6+(P30+Q30+R30)*竞对档案!$D$7+(S30+T30+U30)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J30/V30*100,"")=IFERROR(X30-X29,"")1018=IFERROR(Z30/V30*100,"")—
2026-03-28 00:00:00=IF($A31="","",CHOOSE(WEEKDAY(A31,2),"周一","周二","周三","周四","周五","周六","周日"))D289010341245=IFERROR(AVERAGE($D31:$F31),"")65075091069078097054064082087010401250610700850=IFERROR(((G31+H31+I31)*竞对档案!$D$4+(J31+K31+L31)*竞对档案!$D$5+(M31+N31+O31)*竞对档案!$D$6+(P31+Q31+R31)*竞对档案!$D$7+(S31+T31+U31)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J31/V31*100,"")=IFERROR(X31-X30,"")1015=IFERROR(Z31/V31*100,"")—
2026-03-29 00:00:00=IF($A32="","",CHOOSE(WEEKDAY(A32,2),"周一","周二","周三","周四","周五","周六","周日"))D3618719889=IFERROR(AVERAGE($D32:$F32),"")5706608106006708404805607007309001090530610760=IFERROR(((G32+H32+I32)*竞对档案!$D$4+(J32+K32+L32)*竞对档案!$D$5+(M32+N32+O32)*竞对档案!$D$6+(P32+Q32+R32)*竞对档案!$D$7+(S32+T32+U32)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J32/V32*100,"")=IFERROR(X32-X31,"")689=IFERROR(Z32/V32*100,"")—
2026-03-30 00:00:00=IF($A33="","",CHOOSE(WEEKDAY(A33,2),"周一","周二","周三","周四","周五","周六","周日"))D3614718890=IFERROR(AVERAGE($D33:$F33),"")5506607906007008404905707107408701090540620750=IFERROR(((G33+H33+I33)*竞对档案!$D$4+(J33+K33+L33)*竞对档案!$D$5+(M33+N33+O33)*竞对档案!$D$6+(P33+Q33+R33)*竞对档案!$D$7+(S33+T33+U33)*竞对档案!$D$8)/(3*竞对档案!$D$9),"")=IFERROR(J33/V33*100,"")=IFERROR(X33-X32,"")766=IFERROR(Z33/V33*100,"")—
竞争组合（Comp Set）档案 · 5 家
SPEC 2.4。房量列会被「每日比价」页引用作为加权权重。灰底为 SPEC 固定参数。
代码竞对名称档次房量平峰 BAR距本店(km)房量权重备注
A江畔万枫酒店中高端2806501.2=IFERROR($D4/$D$9,"")平峰基准价
B滨江希尔顿花园中高端2406902.5=IFERROR($D5/$D$9,"")平峰基准价
C钱塘智选假日中端偏上3005603.1=IFERROR($D6/$D$9,"")平峰基准价
D星光开元名都高端3508804=IFERROR($D7/$D$9,"")平峰基准价
E云栖亚朵S中高端2006202=IFERROR($D8/$D$9,"")平峰基准价
合计5 家—1370=IFERROR(SUMPRODUCT($D$4:$D$8,$E$4:$E$8)/$D$9,"")—=SUM($G$4:$G$8)加权平峰 BAR
————————
校验SPEC 2.4 载明的竞争组合加权均价（平峰）680=IFERROR($F$9/$F11-1,"")按房量加权算得 ¥691.7，与 SPEC 载明的 ¥680 差 +1.7%（SPEC 内部取整差异），教学时以房量加权口径为准
ARI 诊断（《法典》表 C 自动查表）
只需输入 ARI、MPI、预测 OCC 三个数，判定 / 动作 / 调整幅度全部自动输出。白底为公式，勿改。
日期ARIMPIRGI预测 OCC判定 (表C)建议动作 (表C)调整幅度%是否执行备注
2026-03-01 00:00:00101.6110.1=IFERROR($B4*$C4/100,"")84.9%=IF($B4="","",IF($B4>120,"严重偏高",IF($B4>=110,"偏高",IF($B4>=103,"略高",IF($B4>=97,"健康",IF($B4>=90,"略低",IF($B4>=80,"偏低","严重偏低")))))))=IF($B4="","",IF($B4>120,IF($C4<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B4>=110,IF($D4<100,"降 5%（RGI<100）","维持"),IF($B4>=103,"维持，观察 Pickup",IF($B4>=97,"维持",IF($B4>=90,IF($E4>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B4>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B4="","",IF($B4>120,IF($C4<95,-0.08,0),IF($B4>=110,IF($D4<100,-0.05,0),IF($B4>=103,0,IF($B4>=97,0,IF($B4>=90,IF($E4>=0.8,0.03,0),IF($B4>=80,0.05,0.08)))))))——
2026-03-02 00:00:00100100.7=IFERROR($B5*$C5/100,"")78.1%=IF($B5="","",IF($B5>120,"严重偏高",IF($B5>=110,"偏高",IF($B5>=103,"略高",IF($B5>=97,"健康",IF($B5>=90,"略低",IF($B5>=80,"偏低","严重偏低")))))))=IF($B5="","",IF($B5>120,IF($C5<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B5>=110,IF($D5<100,"降 5%（RGI<100）","维持"),IF($B5>=103,"维持，观察 Pickup",IF($B5>=97,"维持",IF($B5>=90,IF($E5>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B5>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B5="","",IF($B5>120,IF($C5<95,-0.08,0),IF($B5>=110,IF($D5<100,-0.05,0),IF($B5>=103,0,IF($B5>=97,0,IF($B5>=90,IF($E5>=0.8,0.03,0),IF($B5>=80,0.05,0.08)))))))——
2026-03-03 00:00:0097.5112.7=IFERROR($B6*$C6/100,"")46.5%=IF($B6="","",IF($B6>120,"严重偏高",IF($B6>=110,"偏高",IF($B6>=103,"略高",IF($B6>=97,"健康",IF($B6>=90,"略低",IF($B6>=80,"偏低","严重偏低")))))))=IF($B6="","",IF($B6>120,IF($C6<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B6>=110,IF($D6<100,"降 5%（RGI<100）","维持"),IF($B6>=103,"维持，观察 Pickup",IF($B6>=97,"维持",IF($B6>=90,IF($E6>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B6>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B6="","",IF($B6>120,IF($C6<95,-0.08,0),IF($B6>=110,IF($D6<100,-0.05,0),IF($B6>=103,0,IF($B6>=97,0,IF($B6>=90,IF($E6>=0.8,0.03,0),IF($B6>=80,0.05,0.08)))))))——
2026-03-04 00:00:00107.1103.5=IFERROR($B7*$C7/100,"")95.2%=IF($B7="","",IF($B7>120,"严重偏高",IF($B7>=110,"偏高",IF($B7>=103,"略高",IF($B7>=97,"健康",IF($B7>=90,"略低",IF($B7>=80,"偏低","严重偏低")))))))=IF($B7="","",IF($B7>120,IF($C7<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B7>=110,IF($D7<100,"降 5%（RGI<100）","维持"),IF($B7>=103,"维持，观察 Pickup",IF($B7>=97,"维持",IF($B7>=90,IF($E7>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B7>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B7="","",IF($B7>120,IF($C7<95,-0.08,0),IF($B7>=110,IF($D7<100,-0.05,0),IF($B7>=103,0,IF($B7>=97,0,IF($B7>=90,IF($E7>=0.8,0.03,0),IF($B7>=80,0.05,0.08)))))))——
2026-03-05 00:00:00100.5110.6=IFERROR($B8*$C8/100,"")50.4%=IF($B8="","",IF($B8>120,"严重偏高",IF($B8>=110,"偏高",IF($B8>=103,"略高",IF($B8>=97,"健康",IF($B8>=90,"略低",IF($B8>=80,"偏低","严重偏低")))))))=IF($B8="","",IF($B8>120,IF($C8<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B8>=110,IF($D8<100,"降 5%（RGI<100）","维持"),IF($B8>=103,"维持，观察 Pickup",IF($B8>=97,"维持",IF($B8>=90,IF($E8>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B8>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B8="","",IF($B8>120,IF($C8<95,-0.08,0),IF($B8>=110,IF($D8<100,-0.05,0),IF($B8>=103,0,IF($B8>=97,0,IF($B8>=90,IF($E8>=0.8,0.03,0),IF($B8>=80,0.05,0.08)))))))——
2026-03-06 00:00:00109.998=IFERROR($B9*$C9/100,"")86.2%=IF($B9="","",IF($B9>120,"严重偏高",IF($B9>=110,"偏高",IF($B9>=103,"略高",IF($B9>=97,"健康",IF($B9>=90,"略低",IF($B9>=80,"偏低","严重偏低")))))))=IF($B9="","",IF($B9>120,IF($C9<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B9>=110,IF($D9<100,"降 5%（RGI<100）","维持"),IF($B9>=103,"维持，观察 Pickup",IF($B9>=97,"维持",IF($B9>=90,IF($E9>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B9>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B9="","",IF($B9>120,IF($C9<95,-0.08,0),IF($B9>=110,IF($D9<100,-0.05,0),IF($B9>=103,0,IF($B9>=97,0,IF($B9>=90,IF($E9>=0.8,0.03,0),IF($B9>=80,0.05,0.08)))))))——
2026-03-07 00:00:008296.4=IFERROR($B10*$C10/100,"")66.8%=IF($B10="","",IF($B10>120,"严重偏高",IF($B10>=110,"偏高",IF($B10>=103,"略高",IF($B10>=97,"健康",IF($B10>=90,"略低",IF($B10>=80,"偏低","严重偏低")))))))=IF($B10="","",IF($B10>120,IF($C10<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B10>=110,IF($D10<100,"降 5%（RGI<100）","维持"),IF($B10>=103,"维持，观察 Pickup",IF($B10>=97,"维持",IF($B10>=90,IF($E10>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B10>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B10="","",IF($B10>120,IF($C10<95,-0.08,0),IF($B10>=110,IF($D10<100,-0.05,0),IF($B10>=103,0,IF($B10>=97,0,IF($B10>=90,IF($E10>=0.8,0.03,0),IF($B10>=80,0.05,0.08)))))))——
2026-03-08 00:00:0085.5114.6=IFERROR($B11*$C11/100,"")79.9%=IF($B11="","",IF($B11>120,"严重偏高",IF($B11>=110,"偏高",IF($B11>=103,"略高",IF($B11>=97,"健康",IF($B11>=90,"略低",IF($B11>=80,"偏低","严重偏低")))))))=IF($B11="","",IF($B11>120,IF($C11<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B11>=110,IF($D11<100,"降 5%（RGI<100）","维持"),IF($B11>=103,"维持，观察 Pickup",IF($B11>=97,"维持",IF($B11>=90,IF($E11>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B11>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B11="","",IF($B11>120,IF($C11<95,-0.08,0),IF($B11>=110,IF($D11<100,-0.05,0),IF($B11>=103,0,IF($B11>=97,0,IF($B11>=90,IF($E11>=0.8,0.03,0),IF($B11>=80,0.05,0.08)))))))——
2026-03-09 00:00:0076.691.6=IFERROR($B12*$C12/100,"")80.1%=IF($B12="","",IF($B12>120,"严重偏高",IF($B12>=110,"偏高",IF($B12>=103,"略高",IF($B12>=97,"健康",IF($B12>=90,"略低",IF($B12>=80,"偏低","严重偏低")))))))=IF($B12="","",IF($B12>120,IF($C12<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B12>=110,IF($D12<100,"降 5%（RGI<100）","维持"),IF($B12>=103,"维持，观察 Pickup",IF($B12>=97,"维持",IF($B12>=90,IF($E12>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B12>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B12="","",IF($B12>120,IF($C12<95,-0.08,0),IF($B12>=110,IF($D12<100,-0.05,0),IF($B12>=103,0,IF($B12>=97,0,IF($B12>=90,IF($E12>=0.8,0.03,0),IF($B12>=80,0.05,0.08)))))))——
2026-03-10 00:00:0076.1112.8=IFERROR($B13*$C13/100,"")89.6%=IF($B13="","",IF($B13>120,"严重偏高",IF($B13>=110,"偏高",IF($B13>=103,"略高",IF($B13>=97,"健康",IF($B13>=90,"略低",IF($B13>=80,"偏低","严重偏低")))))))=IF($B13="","",IF($B13>120,IF($C13<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B13>=110,IF($D13<100,"降 5%（RGI<100）","维持"),IF($B13>=103,"维持，观察 Pickup",IF($B13>=97,"维持",IF($B13>=90,IF($E13>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B13>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B13="","",IF($B13>120,IF($C13<95,-0.08,0),IF($B13>=110,IF($D13<100,-0.05,0),IF($B13>=103,0,IF($B13>=97,0,IF($B13>=90,IF($E13>=0.8,0.03,0),IF($B13>=80,0.05,0.08)))))))——
2026-03-11 00:00:0094.799.8=IFERROR($B14*$C14/100,"")85.0%=IF($B14="","",IF($B14>120,"严重偏高",IF($B14>=110,"偏高",IF($B14>=103,"略高",IF($B14>=97,"健康",IF($B14>=90,"略低",IF($B14>=80,"偏低","严重偏低")))))))=IF($B14="","",IF($B14>120,IF($C14<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B14>=110,IF($D14<100,"降 5%（RGI<100）","维持"),IF($B14>=103,"维持，观察 Pickup",IF($B14>=97,"维持",IF($B14>=90,IF($E14>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B14>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B14="","",IF($B14>120,IF($C14<95,-0.08,0),IF($B14>=110,IF($D14<100,-0.05,0),IF($B14>=103,0,IF($B14>=97,0,IF($B14>=90,IF($E14>=0.8,0.03,0),IF($B14>=80,0.05,0.08)))))))——
2026-03-12 00:00:0096.4112.3=IFERROR($B15*$C15/100,"")49.3%=IF($B15="","",IF($B15>120,"严重偏高",IF($B15>=110,"偏高",IF($B15>=103,"略高",IF($B15>=97,"健康",IF($B15>=90,"略低",IF($B15>=80,"偏低","严重偏低")))))))=IF($B15="","",IF($B15>120,IF($C15<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B15>=110,IF($D15<100,"降 5%（RGI<100）","维持"),IF($B15>=103,"维持，观察 Pickup",IF($B15>=97,"维持",IF($B15>=90,IF($E15>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B15>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B15="","",IF($B15>120,IF($C15<95,-0.08,0),IF($B15>=110,IF($D15<100,-0.05,0),IF($B15>=103,0,IF($B15>=97,0,IF($B15>=90,IF($E15>=0.8,0.03,0),IF($B15>=80,0.05,0.08)))))))——
2026-03-13 00:00:0078.986=IFERROR($B16*$C16/100,"")44.6%=IF($B16="","",IF($B16>120,"严重偏高",IF($B16>=110,"偏高",IF($B16>=103,"略高",IF($B16>=97,"健康",IF($B16>=90,"略低",IF($B16>=80,"偏低","严重偏低")))))))=IF($B16="","",IF($B16>120,IF($C16<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B16>=110,IF($D16<100,"降 5%（RGI<100）","维持"),IF($B16>=103,"维持，观察 Pickup",IF($B16>=97,"维持",IF($B16>=90,IF($E16>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B16>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B16="","",IF($B16>120,IF($C16<95,-0.08,0),IF($B16>=110,IF($D16<100,-0.05,0),IF($B16>=103,0,IF($B16>=97,0,IF($B16>=90,IF($E16>=0.8,0.03,0),IF($B16>=80,0.05,0.08)))))))——
2026-03-14 00:00:0094.498=IFERROR($B17*$C17/100,"")78.5%=IF($B17="","",IF($B17>120,"严重偏高",IF($B17>=110,"偏高",IF($B17>=103,"略高",IF($B17>=97,"健康",IF($B17>=90,"略低",IF($B17>=80,"偏低","严重偏低")))))))=IF($B17="","",IF($B17>120,IF($C17<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B17>=110,IF($D17<100,"降 5%（RGI<100）","维持"),IF($B17>=103,"维持，观察 Pickup",IF($B17>=97,"维持",IF($B17>=90,IF($E17>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B17>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B17="","",IF($B17>120,IF($C17<95,-0.08,0),IF($B17>=110,IF($D17<100,-0.05,0),IF($B17>=103,0,IF($B17>=97,0,IF($B17>=90,IF($E17>=0.8,0.03,0),IF($B17>=80,0.05,0.08)))))))——
2026-03-15 00:00:008786=IFERROR($B18*$C18/100,"")89.4%=IF($B18="","",IF($B18>120,"严重偏高",IF($B18>=110,"偏高",IF($B18>=103,"略高",IF($B18>=97,"健康",IF($B18>=90,"略低",IF($B18>=80,"偏低","严重偏低")))))))=IF($B18="","",IF($B18>120,IF($C18<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B18>=110,IF($D18<100,"降 5%（RGI<100）","维持"),IF($B18>=103,"维持，观察 Pickup",IF($B18>=97,"维持",IF($B18>=90,IF($E18>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B18>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B18="","",IF($B18>120,IF($C18<95,-0.08,0),IF($B18>=110,IF($D18<100,-0.05,0),IF($B18>=103,0,IF($B18>=97,0,IF($B18>=90,IF($E18>=0.8,0.03,0),IF($B18>=80,0.05,0.08)))))))——
2026-03-16 00:00:0093.5103.8=IFERROR($B19*$C19/100,"")56.2%=IF($B19="","",IF($B19>120,"严重偏高",IF($B19>=110,"偏高",IF($B19>=103,"略高",IF($B19>=97,"健康",IF($B19>=90,"略低",IF($B19>=80,"偏低","严重偏低")))))))=IF($B19="","",IF($B19>120,IF($C19<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B19>=110,IF($D19<100,"降 5%（RGI<100）","维持"),IF($B19>=103,"维持，观察 Pickup",IF($B19>=97,"维持",IF($B19>=90,IF($E19>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B19>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B19="","",IF($B19>120,IF($C19<95,-0.08,0),IF($B19>=110,IF($D19<100,-0.05,0),IF($B19>=103,0,IF($B19>=97,0,IF($B19>=90,IF($E19>=0.8,0.03,0),IF($B19>=80,0.05,0.08)))))))——
2026-03-17 00:00:00112.9105.6=IFERROR($B20*$C20/100,"")58.7%=IF($B20="","",IF($B20>120,"严重偏高",IF($B20>=110,"偏高",IF($B20>=103,"略高",IF($B20>=97,"健康",IF($B20>=90,"略低",IF($B20>=80,"偏低","严重偏低")))))))=IF($B20="","",IF($B20>120,IF($C20<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B20>=110,IF($D20<100,"降 5%（RGI<100）","维持"),IF($B20>=103,"维持，观察 Pickup",IF($B20>=97,"维持",IF($B20>=90,IF($E20>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B20>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B20="","",IF($B20>120,IF($C20<95,-0.08,0),IF($B20>=110,IF($D20<100,-0.05,0),IF($B20>=103,0,IF($B20>=97,0,IF($B20>=90,IF($E20>=0.8,0.03,0),IF($B20>=80,0.05,0.08)))))))——
2026-03-18 00:00:0091.989.8=IFERROR($B21*$C21/100,"")83.1%=IF($B21="","",IF($B21>120,"严重偏高",IF($B21>=110,"偏高",IF($B21>=103,"略高",IF($B21>=97,"健康",IF($B21>=90,"略低",IF($B21>=80,"偏低","严重偏低")))))))=IF($B21="","",IF($B21>120,IF($C21<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B21>=110,IF($D21<100,"降 5%（RGI<100）","维持"),IF($B21>=103,"维持，观察 Pickup",IF($B21>=97,"维持",IF($B21>=90,IF($E21>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B21>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B21="","",IF($B21>120,IF($C21<95,-0.08,0),IF($B21>=110,IF($D21<100,-0.05,0),IF($B21>=103,0,IF($B21>=97,0,IF($B21>=90,IF($E21>=0.8,0.03,0),IF($B21>=80,0.05,0.08)))))))——
2026-03-19 00:00:0094.187.6=IFERROR($B22*$C22/100,"")71.8%=IF($B22="","",IF($B22>120,"严重偏高",IF($B22>=110,"偏高",IF($B22>=103,"略高",IF($B22>=97,"健康",IF($B22>=90,"略低",IF($B22>=80,"偏低","严重偏低")))))))=IF($B22="","",IF($B22>120,IF($C22<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B22>=110,IF($D22<100,"降 5%（RGI<100）","维持"),IF($B22>=103,"维持，观察 Pickup",IF($B22>=97,"维持",IF($B22>=90,IF($E22>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B22>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B22="","",IF($B22>120,IF($C22<95,-0.08,0),IF($B22>=110,IF($D22<100,-0.05,0),IF($B22>=103,0,IF($B22>=97,0,IF($B22>=90,IF($E22>=0.8,0.03,0),IF($B22>=80,0.05,0.08)))))))——
2026-03-20 00:00:00122.5115.1=IFERROR($B23*$C23/100,"")49.4%=IF($B23="","",IF($B23>120,"严重偏高",IF($B23>=110,"偏高",IF($B23>=103,"略高",IF($B23>=97,"健康",IF($B23>=90,"略低",IF($B23>=80,"偏低","严重偏低")))))))=IF($B23="","",IF($B23>120,IF($C23<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B23>=110,IF($D23<100,"降 5%（RGI<100）","维持"),IF($B23>=103,"维持，观察 Pickup",IF($B23>=97,"维持",IF($B23>=90,IF($E23>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B23>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B23="","",IF($B23>120,IF($C23<95,-0.08,0),IF($B23>=110,IF($D23<100,-0.05,0),IF($B23>=103,0,IF($B23>=97,0,IF($B23>=90,IF($E23>=0.8,0.03,0),IF($B23>=80,0.05,0.08)))))))——
2026-03-21 00:00:00118.490.5=IFERROR($B24*$C24/100,"")77.3%=IF($B24="","",IF($B24>120,"严重偏高",IF($B24>=110,"偏高",IF($B24>=103,"略高",IF($B24>=97,"健康",IF($B24>=90,"略低",IF($B24>=80,"偏低","严重偏低")))))))=IF($B24="","",IF($B24>120,IF($C24<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B24>=110,IF($D24<100,"降 5%（RGI<100）","维持"),IF($B24>=103,"维持，观察 Pickup",IF($B24>=97,"维持",IF($B24>=90,IF($E24>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B24>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B24="","",IF($B24>120,IF($C24<95,-0.08,0),IF($B24>=110,IF($D24<100,-0.05,0),IF($B24>=103,0,IF($B24>=97,0,IF($B24>=90,IF($E24>=0.8,0.03,0),IF($B24>=80,0.05,0.08)))))))——
2026-03-22 00:00:0099.889.8=IFERROR($B25*$C25/100,"")83.4%=IF($B25="","",IF($B25>120,"严重偏高",IF($B25>=110,"偏高",IF($B25>=103,"略高",IF($B25>=97,"健康",IF($B25>=90,"略低",IF($B25>=80,"偏低","严重偏低")))))))=IF($B25="","",IF($B25>120,IF($C25<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B25>=110,IF($D25<100,"降 5%（RGI<100）","维持"),IF($B25>=103,"维持，观察 Pickup",IF($B25>=97,"维持",IF($B25>=90,IF($E25>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B25>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B25="","",IF($B25>120,IF($C25<95,-0.08,0),IF($B25>=110,IF($D25<100,-0.05,0),IF($B25>=103,0,IF($B25>=97,0,IF($B25>=90,IF($E25>=0.8,0.03,0),IF($B25>=80,0.05,0.08)))))))——
2026-03-23 00:00:00115.891.7=IFERROR($B26*$C26/100,"")77.1%=IF($B26="","",IF($B26>120,"严重偏高",IF($B26>=110,"偏高",IF($B26>=103,"略高",IF($B26>=97,"健康",IF($B26>=90,"略低",IF($B26>=80,"偏低","严重偏低")))))))=IF($B26="","",IF($B26>120,IF($C26<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B26>=110,IF($D26<100,"降 5%（RGI<100）","维持"),IF($B26>=103,"维持，观察 Pickup",IF($B26>=97,"维持",IF($B26>=90,IF($E26>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B26>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B26="","",IF($B26>120,IF($C26<95,-0.08,0),IF($B26>=110,IF($D26<100,-0.05,0),IF($B26>=103,0,IF($B26>=97,0,IF($B26>=90,IF($E26>=0.8,0.03,0),IF($B26>=80,0.05,0.08)))))))——
2026-03-24 00:00:0094.198.4=IFERROR($B27*$C27/100,"")73.7%=IF($B27="","",IF($B27>120,"严重偏高",IF($B27>=110,"偏高",IF($B27>=103,"略高",IF($B27>=97,"健康",IF($B27>=90,"略低",IF($B27>=80,"偏低","严重偏低")))))))=IF($B27="","",IF($B27>120,IF($C27<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B27>=110,IF($D27<100,"降 5%（RGI<100）","维持"),IF($B27>=103,"维持，观察 Pickup",IF($B27>=97,"维持",IF($B27>=90,IF($E27>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B27>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B27="","",IF($B27>120,IF($C27<95,-0.08,0),IF($B27>=110,IF($D27<100,-0.05,0),IF($B27>=103,0,IF($B27>=97,0,IF($B27>=90,IF($E27>=0.8,0.03,0),IF($B27>=80,0.05,0.08)))))))——
2026-03-25 00:00:00110.4102.3=IFERROR($B28*$C28/100,"")94.9%=IF($B28="","",IF($B28>120,"严重偏高",IF($B28>=110,"偏高",IF($B28>=103,"略高",IF($B28>=97,"健康",IF($B28>=90,"略低",IF($B28>=80,"偏低","严重偏低")))))))=IF($B28="","",IF($B28>120,IF($C28<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B28>=110,IF($D28<100,"降 5%（RGI<100）","维持"),IF($B28>=103,"维持，观察 Pickup",IF($B28>=97,"维持",IF($B28>=90,IF($E28>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B28>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B28="","",IF($B28>120,IF($C28<95,-0.08,0),IF($B28>=110,IF($D28<100,-0.05,0),IF($B28>=103,0,IF($B28>=97,0,IF($B28>=90,IF($E28>=0.8,0.03,0),IF($B28>=80,0.05,0.08)))))))——
2026-03-26 00:00:00120.6109.1=IFERROR($B29*$C29/100,"")51.7%=IF($B29="","",IF($B29>120,"严重偏高",IF($B29>=110,"偏高",IF($B29>=103,"略高",IF($B29>=97,"健康",IF($B29>=90,"略低",IF($B29>=80,"偏低","严重偏低")))))))=IF($B29="","",IF($B29>120,IF($C29<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B29>=110,IF($D29<100,"降 5%（RGI<100）","维持"),IF($B29>=103,"维持，观察 Pickup",IF($B29>=97,"维持",IF($B29>=90,IF($E29>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B29>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B29="","",IF($B29>120,IF($C29<95,-0.08,0),IF($B29>=110,IF($D29<100,-0.05,0),IF($B29>=103,0,IF($B29>=97,0,IF($B29>=90,IF($E29>=0.8,0.03,0),IF($B29>=80,0.05,0.08)))))))——
2026-03-27 00:00:00116.8114.1=IFERROR($B30*$C30/100,"")86.5%=IF($B30="","",IF($B30>120,"严重偏高",IF($B30>=110,"偏高",IF($B30>=103,"略高",IF($B30>=97,"健康",IF($B30>=90,"略低",IF($B30>=80,"偏低","严重偏低")))))))=IF($B30="","",IF($B30>120,IF($C30<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B30>=110,IF($D30<100,"降 5%（RGI<100）","维持"),IF($B30>=103,"维持，观察 Pickup",IF($B30>=97,"维持",IF($B30>=90,IF($E30>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B30>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B30="","",IF($B30>120,IF($C30<95,-0.08,0),IF($B30>=110,IF($D30<100,-0.05,0),IF($B30>=103,0,IF($B30>=97,0,IF($B30>=90,IF($E30>=0.8,0.03,0),IF($B30>=80,0.05,0.08)))))))——
2026-03-28 00:00:00113.9100.6=IFERROR($B31*$C31/100,"")95.9%=IF($B31="","",IF($B31>120,"严重偏高",IF($B31>=110,"偏高",IF($B31>=103,"略高",IF($B31>=97,"健康",IF($B31>=90,"略低",IF($B31>=80,"偏低","严重偏低")))))))=IF($B31="","",IF($B31>120,IF($C31<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B31>=110,IF($D31<100,"降 5%（RGI<100）","维持"),IF($B31>=103,"维持，观察 Pickup",IF($B31>=97,"维持",IF($B31>=90,IF($E31>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B31>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B31="","",IF($B31>120,IF($C31<95,-0.08,0),IF($B31>=110,IF($D31<100,-0.05,0),IF($B31>=103,0,IF($B31>=97,0,IF($B31>=90,IF($E31>=0.8,0.03,0),IF($B31>=80,0.05,0.08)))))))——
2026-03-29 00:00:00110.688.9=IFERROR($B32*$C32/100,"")56.4%=IF($B32="","",IF($B32>120,"严重偏高",IF($B32>=110,"偏高",IF($B32>=103,"略高",IF($B32>=97,"健康",IF($B32>=90,"略低",IF($B32>=80,"偏低","严重偏低")))))))=IF($B32="","",IF($B32>120,IF($C32<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B32>=110,IF($D32<100,"降 5%（RGI<100）","维持"),IF($B32>=103,"维持，观察 Pickup",IF($B32>=97,"维持",IF($B32>=90,IF($E32>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B32>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B32="","",IF($B32>120,IF($C32<95,-0.08,0),IF($B32>=110,IF($D32<100,-0.05,0),IF($B32>=103,0,IF($B32>=97,0,IF($B32>=90,IF($E32>=0.8,0.03,0),IF($B32>=80,0.05,0.08)))))))——
2026-03-30 00:00:00106.4110=IFERROR($B33*$C33/100,"")94.5%=IF($B33="","",IF($B33>120,"严重偏高",IF($B33>=110,"偏高",IF($B33>=103,"略高",IF($B33>=97,"健康",IF($B33>=90,"略低",IF($B33>=80,"偏低","严重偏低")))))))=IF($B33="","",IF($B33>120,IF($C33<95,"降 8%（MPI<95）","维持并每日盯 Pickup"),IF($B33>=110,IF($D33<100,"降 5%（RGI<100）","维持"),IF($B33>=103,"维持，观察 Pickup",IF($B33>=97,"维持",IF($B33>=90,IF($E33>=0.8,"提 3%（预测 OCC≥80%）","维持"),IF($B33>=80,"提 5%","提 8%，并核查房型配置与含早策略")))))))=IF($B33="","",IF($B33>120,IF($C33<95,-0.08,0),IF($B33>=110,IF($D33<100,-0.05,0),IF($B33>=103,0,IF($B33>=97,0,IF($B33>=90,IF($E33>=0.8,0.03,0),IF($B33>=80,0.05,0.08)))))))——
——————————
——————————
《法典》表 C · 价格指数（ARI）判定表（参考区，勿改）—————————
ARI判定动作执行约束——————
>120严重偏高MPI<95 → 降 8%；MPI≥95 → 维持并每日盯 Pickup———————
110–120偏高RGI<100 → 降 5%；RGI≥100 → 维持———————
103–110略高维持，观察 Pickup———————
97–103健康维持———————
90–97略低预测 OCC≥80% → 提 3%；否则维持———————
80–90偏低提 5%———————
<80严重偏低提 8%，并核查房型配置与含早策略———————
执行约束① 每次调整不超过 8%，每周不超过 2 次② 不得与表 A 结论叠加执行；同日只执行优先级更高的一条（表 A > 表 C）③ 冲突时按《法典》表 O 仲裁——————
Excel 模板预览（公式计算值，输入格为示例/空） · 在线预览，可直接查看；如需编辑请用“下载”按钮获取原文件。