| 02 · Pickup 预订速度追踪表 ｜ 使用说明 | ||||
| Pickup 是唯一能提前看到未来的指标：今天的在手，就是 30 天后的结果。 | ||||
| 一、用途 | ||||
| 用于《法典》表 M 07:50 节点「抓取未来 30 天在手 + Pickup」，以及表 I 的窗口分档监控。 | ||||
| 「Pickup追踪」页是核心矩阵：行＝提前天数档，列＝目标入住日，格子里填累计在手房晚。 | ||||
| 「去年同期对照」页结构完全相同，填去年数据做基准（本模板留空，学员可用 data/03 数据集填写）。 | ||||
| 「预测计算」页把在手与去年对照代入公式，自动算 Pickup 偏差、预测 OCC，并按表 I 判窗口、比阈值、出动作。 | ||||
| — | — | — | — | — |
| 二、填色规则 | ||||
| — | 输入区 | 浅黄底 + 边框 | 由学员填写，例如日期、房晚、价格 | |
| — | 公式区 | 白底 + 边框 | 已预置 Excel 公式，改动会导致结果错误，请勿手改 | |
| — | 参考区 | 灰底 + 斜体 | SPEC 固定参数/判定表，一般不需要改动 | |
| — | 标题行 | 深蓝底白字 | 字段名，冻结在首行 | |
| — | — | — | — | — |
| 三、字段字典 | ||||
| 列 | 字段名称 | 类型 | 口径 / 预置公式 | 说明 |
| 第 3 行 | 目标入住日 | 输入 | — | 30 列，快照日之后的连续 30 天 |
| A 列 | 提前天数档 | 参考 | 60/45/30/21/14/7/3/1/0 | 行维度＝预订窗口 |
| C:AF | 累计在手房晚 | 输入 | — | 该档时点上，该目标日已收到的累计房晚 |
| 增量区 | 档间 Pickup 增量 | 公式 | =本档 − 上一档 | 负值＝净取消（绿色） |
| H | Pickup 偏差% | 公式 | #NAME? | 正值＝领先（红色） |
| I | 预测最终房晚 | 公式 | #NAME? | 本模板采用「同比增速外推法」 |
| K | 预测 OCC | 公式 | #NAME? | — |
| D | 窗口分档 | 公式 | 按提前天数嵌套 IF 判档 | 《法典》表 I 六档 |
| P | 落后幅度% | 公式 | #NAME? | 正值＝落后 |
| Q | 是否触发 | 公式 | 0-3 档看 OCC<70%，其余档比阈值数值 | — |
| R | 触发动作 | 公式 | VLOOKUP 表 I 第 4 列 | 触发即输出，未触发显示「—」 |
| — | — | — | — | — |
| 四、使用步骤 | ||||
| 1 | 在「Pickup追踪」页第 3 行填 30 个目标入住日（快照日之后连续 30 天）。 | |||
| 2 | 按当日实际，把每个目标日在各提前天数档上的累计在手房晚填入黄底格。 | |||
| 3 | 在「去年同期对照」页用同样的结构填入去年的对应数据（留空则预测计算会显示空白）。 | |||
| 4 | 打开「预测计算」页：目标日、当前在手会自动引用「Pickup追踪」页，无需手填。 | |||
| 5 | 读「是否触发」列：红色＝触发，须按「触发动作」列执行；执行后写入 04 号《调价台账》。 | |||
| — | — | — | — | — |
| 五、关联《收益管理操作法典》 | ||||
| 表 I · 预订窗口分档监控表 —— 已内嵌在「预测计算」页第 36–42 行作为查找表。 | ||||
| 表 A · 每日价格调整判定表 —— 预测 OCC 与 Pickup 偏差算出后，直接查表 A 得调价幅度。 | ||||
| 表 M · 07:50 节点要求 20 分钟内完成本表更新。 | ||||
| — | — | — | — | — |
| 杭州滨江云璟酒店 · 320 间房 · 中高端全服务 ｜ 酒店收益管理学院 HRMA ｜ 口径以 SPEC.md 为准 | ||||
| Pickup 预订速度追踪矩阵（本年） | |||||||||||||||||||||||||||||||
| 行＝提前天数档，列＝目标入住日，单元格＝该档时点的累计在手房晚。黄底为输入，白底为公式。 | |||||||||||||||||||||||||||||||
| 提前天数档 | 《法典》表 I 窗口 | 2026-03-01 00:00:00 | 2026-03-02 00:00:00 | 2026-03-03 00:00:00 | 2026-03-04 00:00:00 | 2026-03-05 00:00:00 | 2026-03-06 00:00:00 | 2026-03-07 00:00:00 | 2026-03-08 00:00:00 | 2026-03-09 00:00:00 | 2026-03-10 00:00:00 | 2026-03-11 00:00:00 | 2026-03-12 00:00:00 | 2026-03-13 00:00:00 | 2026-03-14 00:00:00 | 2026-03-15 00:00:00 | 2026-03-16 00:00:00 | 2026-03-17 00:00:00 | 2026-03-18 00:00:00 | 2026-03-19 00:00:00 | 2026-03-20 00:00:00 | 2026-03-21 00:00:00 | 2026-03-22 00:00:00 | 2026-03-23 00:00:00 | 2026-03-24 00:00:00 | 2026-03-25 00:00:00 | 2026-03-26 00:00:00 | 2026-03-27 00:00:00 | 2026-03-28 00:00:00 | 2026-03-29 00:00:00 | 2026-03-30 00:00:00 |
| 60 天档 | 31–60 天窗口 | 37 | 39 | 44 | 42 | 45 | 47 | 38 | 40 | 38 | 43 | 40 | 47 | 51 | 41 | 37 | 43 | 42 | 40 | 48 | 51 | 38 | 44 | 42 | 37 | 38 | 49 | 45 | 42 | 41 | 40 |
| 45 天档 | 31–60 天窗口 | 60 | 60 | 60 | 58 | 80 | 76 | 61 | 67 | 60 | 59 | 60 | 73 | 73 | 58 | 65 | 64 | 66 | 62 | 76 | 79 | 67 | 59 | 60 | 59 | 64 | 78 | 70 | 62 | 65 | 67 |
| 30 天档 | 15–30 天窗口 | 102 | 97 | 97 | 109 | 118 | 114 | 95 | 95 | 95 | 95 | 109 | 122 | 128 | 94 | 109 | 103 | 106 | 105 | 118 | 116 | 103 | 101 | 108 | 102 | 107 | 126 | 115 | 103 | 109 | 106 |
| 21 天档 | 15–30 天窗口 | 130 | 124 | 132 | 138 | 164 | 146 | 127 | 139 | 134 | 128 | 139 | 149 | 164 | 141 | 137 | 131 | 127 | 120 | 167 | 146 | 138 | 123 | 140 | 137 | 120 | 156 | 163 | 136 | 139 | 120 |
| 14 天档 | 8–14 天窗口 | 173 | 151 | 170 | 161 | 183 | 184 | 160 | 149 | 153 | 166 | 172 | 195 | 206 | 175 | 155 | 149 | 171 | 152 | 192 | 188 | 148 | 164 | 165 | 156 | 173 | 184 | 184 | 152 | 166 | 170 |
| 7 天档 | 4–7 天窗口 | 206 | 189 | 177 | 190 | 215 | 238 | 187 | 205 | 202 | 209 | 209 | 229 | 226 | 206 | 202 | 186 | 191 | 204 | 235 | 218 | 202 | 192 | 178 | 185 | 199 | 222 | 226 | 179 | 198 | 182 |
| 3 天档 | 0–3 天窗口 | 208 | 208 | 224 | 216 | 235 | 248 | 194 | 196 | 218 | 226 | 191 | 241 | 233 | 212 | 218 | 208 | 191 | 216 | 258 | 247 | 191 | 218 | 201 | 220 | 205 | 253 | 268 | 226 | 209 | 195 |
| 1 天档 | 0–3 天窗口 | 232 | 220 | 207 | 234 | 276 | 267 | 232 | 203 | 231 | 202 | 201 | 274 | 277 | 225 | 201 | 234 | 215 | 210 | 271 | 252 | 229 | 214 | 217 | 210 | 225 | 272 | 264 | 214 | 215 | 223 |
| 到达日 | 0–3 天窗口 | 233 | 212 | 217 | 216 | 275 | 285 | 206 | 216 | 236 | 231 | 212 | 274 | 259 | 243 | 221 | 207 | 241 | 225 | 272 | 278 | 226 | 232 | 211 | 239 | 214 | 269 | 278 | 239 | 219 | 227 |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 各档间 Pickup 增量（自动生成 · 白底勿改） | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |
| 60 天档 | 31–60 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 45 天档 | 31–60 天窗口 | 23 | 21 | 16 | 16 | 35 | 29 | 23 | 27 | 22 | 16 | 20 | 26 | 22 | 17 | 28 | 21 | 24 | 22 | 28 | 28 | 29 | 15 | 18 | 22 | 26 | 29 | 25 | 20 | 24 | 27 |
| 30 天档 | 15–30 天窗口 | 42 | 37 | 37 | 51 | 38 | 38 | 34 | 28 | 35 | 36 | 49 | 49 | 55 | 36 | 44 | 39 | 40 | 43 | 42 | 37 | 36 | 42 | 48 | 43 | 43 | 48 | 45 | 41 | 44 | 39 |
| 21 天档 | 15–30 天窗口 | 28 | 27 | 35 | 29 | 46 | 32 | 32 | 44 | 39 | 33 | 30 | 27 | 36 | 47 | 28 | 28 | 21 | 15 | 49 | 30 | 35 | 22 | 32 | 35 | 13 | 30 | 48 | 33 | 30 | 14 |
| 14 天档 | 8–14 天窗口 | 43 | 27 | 38 | 23 | 19 | 38 | 33 | 10 | 19 | 38 | 33 | 46 | 42 | 34 | 18 | 18 | 44 | 32 | 25 | 42 | 10 | 41 | 25 | 19 | 53 | 28 | 21 | 16 | 27 | 50 |
| 7 天档 | 4–7 天窗口 | 33 | 38 | 7 | 29 | 32 | 54 | 27 | 56 | 49 | 43 | 37 | 34 | 20 | 31 | 47 | 37 | 20 | 52 | 43 | 30 | 54 | 28 | 13 | 29 | 26 | 38 | 42 | 27 | 32 | 12 |
| 3 天档 | 0–3 天窗口 | 2 | 19 | 47 | 26 | 20 | 10 | 7 | -9 | 16 | 17 | -18 | 12 | 7 | 6 | 16 | 22 | 0 | 12 | 23 | 29 | -11 | 26 | 23 | 35 | 6 | 31 | 42 | 47 | 11 | 13 |
| 1 天档 | 0–3 天窗口 | 24 | 12 | -17 | 18 | 41 | 19 | 38 | 7 | 13 | -24 | 10 | 33 | 44 | 13 | -17 | 26 | 24 | -6 | 13 | 5 | 38 | -4 | 16 | -10 | 20 | 19 | -4 | -12 | 6 | 28 |
| 到达日 | 0–3 天窗口 | 1 | -8 | 10 | -18 | -1 | 18 | -26 | 13 | 5 | 29 | 11 | 0 | -18 | 18 | 20 | -27 | 26 | 15 | 1 | 26 | -3 | 18 | -6 | 29 | -11 | -3 | 14 | 25 | 4 | 4 |
| Pickup 预订速度追踪矩阵（去年同期 · 对照用） | |||||||||||||||||||||||||||||||
| 行＝提前天数档，列＝目标入住日，单元格＝该档时点的累计在手房晚。黄底为输入，白底为公式。 | |||||||||||||||||||||||||||||||
| 提前天数档 | 《法典》表 I 窗口 | 2026-03-01 00:00:00 | 2026-03-02 00:00:00 | 2026-03-03 00:00:00 | 2026-03-04 00:00:00 | 2026-03-05 00:00:00 | 2026-03-06 00:00:00 | 2026-03-07 00:00:00 | 2026-03-08 00:00:00 | 2026-03-09 00:00:00 | 2026-03-10 00:00:00 | 2026-03-11 00:00:00 | 2026-03-12 00:00:00 | 2026-03-13 00:00:00 | 2026-03-14 00:00:00 | 2026-03-15 00:00:00 | 2026-03-16 00:00:00 | 2026-03-17 00:00:00 | 2026-03-18 00:00:00 | 2026-03-19 00:00:00 | 2026-03-20 00:00:00 | 2026-03-21 00:00:00 | 2026-03-22 00:00:00 | 2026-03-23 00:00:00 | 2026-03-24 00:00:00 | 2026-03-25 00:00:00 | 2026-03-26 00:00:00 | 2026-03-27 00:00:00 | 2026-03-28 00:00:00 | 2026-03-29 00:00:00 | 2026-03-30 00:00:00 |
| 60 天档 | 31–60 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 45 天档 | 31–60 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 30 天档 | 15–30 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 21 天档 | 15–30 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 14 天档 | 8–14 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 7 天档 | 4–7 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 3 天档 | 0–3 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 1 天档 | 0–3 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 到达日 | 0–3 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 各档间 Pickup 增量（自动生成 · 白底勿改） | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |
| 60 天档 | 31–60 天窗口 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 45 天档 | 31–60 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 30 天档 | 15–30 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 21 天档 | 15–30 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 14 天档 | 8–14 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7 天档 | 4–7 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 天档 | 0–3 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 天档 | 0–3 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 到达日 | 0–3 天窗口 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Pickup 预测计算（目标日维度） | |||||||||||||||||
| 输入：当前在手、去年同窗口在手、去年同期最终房晚。输出：Pickup 偏差、预测 OCC，并按《法典》表 I 自动判窗口、比阈值、出动作。 | |||||||||||||||||
| 目标日 | 星期 | 提前 天数 | 窗口分档 (表I) | 当前在手 房晚 | 去年同窗口 在手 | 去年同期 最终房晚 | Pickup 偏差% | 预测最终 房晚 | 可售 房晚 | 预测 OCC | 目标 OCC | 差距 (pp) | 监控频率 | 落后触发 阈值 | 落后幅度 % | 是否触发 | 触发动作 |
| 46082 | =IF($A4="","",CHOOSE(WEEKDAY(A4,2),"周一","周二","周三","周四","周五","周六","周日")) | 89 | >60天 | 233 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46083 | =IF($A5="","",CHOOSE(WEEKDAY(A5,2),"周一","周二","周三","周四","周五","周六","周日")) | 88 | >60天 | 212 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46084 | =IF($A6="","",CHOOSE(WEEKDAY(A6,2),"周一","周二","周三","周四","周五","周六","周日")) | 87 | >60天 | 217 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46085 | =IF($A7="","",CHOOSE(WEEKDAY(A7,2),"周一","周二","周三","周四","周五","周六","周日")) | 86 | >60天 | 216 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46086 | =IF($A8="","",CHOOSE(WEEKDAY(A8,2),"周一","周二","周三","周四","周五","周六","周日")) | 85 | >60天 | 275 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46087 | =IF($A9="","",CHOOSE(WEEKDAY(A9,2),"周一","周二","周三","周四","周五","周六","周日")) | 84 | >60天 | 285 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46088 | =IF($A10="","",CHOOSE(WEEKDAY(A10,2),"周一","周二","周三","周四","周五","周六","周日")) | 83 | >60天 | 206 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46089 | =IF($A11="","",CHOOSE(WEEKDAY(A11,2),"周一","周二","周三","周四","周五","周六","周日")) | 82 | >60天 | 216 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46090 | =IF($A12="","",CHOOSE(WEEKDAY(A12,2),"周一","周二","周三","周四","周五","周六","周日")) | 81 | >60天 | 236 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46091 | =IF($A13="","",CHOOSE(WEEKDAY(A13,2),"周一","周二","周三","周四","周五","周六","周日")) | 80 | >60天 | 231 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46092 | =IF($A14="","",CHOOSE(WEEKDAY(A14,2),"周一","周二","周三","周四","周五","周六","周日")) | 79 | >60天 | 212 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46093 | =IF($A15="","",CHOOSE(WEEKDAY(A15,2),"周一","周二","周三","周四","周五","周六","周日")) | 78 | >60天 | 274 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46094 | =IF($A16="","",CHOOSE(WEEKDAY(A16,2),"周一","周二","周三","周四","周五","周六","周日")) | 77 | >60天 | 259 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46095 | =IF($A17="","",CHOOSE(WEEKDAY(A17,2),"周一","周二","周三","周四","周五","周六","周日")) | 76 | >60天 | 243 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46096 | =IF($A18="","",CHOOSE(WEEKDAY(A18,2),"周一","周二","周三","周四","周五","周六","周日")) | 75 | >60天 | 221 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46097 | =IF($A19="","",CHOOSE(WEEKDAY(A19,2),"周一","周二","周三","周四","周五","周六","周日")) | 74 | >60天 | 207 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46098 | =IF($A20="","",CHOOSE(WEEKDAY(A20,2),"周一","周二","周三","周四","周五","周六","周日")) | 73 | >60天 | 241 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46099 | =IF($A21="","",CHOOSE(WEEKDAY(A21,2),"周一","周二","周三","周四","周五","周六","周日")) | 72 | >60天 | 225 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46100 | =IF($A22="","",CHOOSE(WEEKDAY(A22,2),"周一","周二","周三","周四","周五","周六","周日")) | 71 | >60天 | 272 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46101 | =IF($A23="","",CHOOSE(WEEKDAY(A23,2),"周一","周二","周三","周四","周五","周六","周日")) | 70 | >60天 | 278 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46102 | =IF($A24="","",CHOOSE(WEEKDAY(A24,2),"周一","周二","周三","周四","周五","周六","周日")) | 69 | >60天 | 226 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46103 | =IF($A25="","",CHOOSE(WEEKDAY(A25,2),"周一","周二","周三","周四","周五","周六","周日")) | 68 | >60天 | 232 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46104 | =IF($A26="","",CHOOSE(WEEKDAY(A26,2),"周一","周二","周三","周四","周五","周六","周日")) | 67 | >60天 | 211 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46105 | =IF($A27="","",CHOOSE(WEEKDAY(A27,2),"周一","周二","周三","周四","周五","周六","周日")) | 66 | >60天 | 239 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46106 | =IF($A28="","",CHOOSE(WEEKDAY(A28,2),"周一","周二","周三","周四","周五","周六","周日")) | 65 | >60天 | 214 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46107 | =IF($A29="","",CHOOSE(WEEKDAY(A29,2),"周一","周二","周三","周四","周五","周六","周日")) | 64 | >60天 | 269 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46108 | =IF($A30="","",CHOOSE(WEEKDAY(A30,2),"周一","周二","周三","周四","周五","周六","周日")) | 63 | >60天 | 278 | 0 | 0 | — | — | 320 | — | 88.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46109 | =IF($A31="","",CHOOSE(WEEKDAY(A31,2),"周一","周二","周三","周四","周五","周六","周日")) | 62 | >60天 | 239 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46110 | =IF($A32="","",CHOOSE(WEEKDAY(A32,2),"周一","周二","周三","周四","周五","周六","周日")) | 61 | >60天 | 219 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每月1次 | 落后30% | — | 触发 | 上报L3，调整年度策略 |
| 46111 | =IF($A33="","",CHOOSE(WEEKDAY(A33,2),"周一","周二","周三","周四","周五","周六","周日")) | 60 | 31-60天 | 227 | 0 | 0 | — | — | 320 | — | 78.0% | — | 每周1次 | 落后25% | — | 触发 | 启动协议客户拜访计划 |
| — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 《法典》表 I · 预订窗口分档监控表（参考区，勿改） | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 窗口分档 | 监控频率 | 落后触发阈值 | 触发动作 | 阈值数值 | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 0-3天 | 每日2次(10:00/17:00) | OCC<70% | 上「今日特惠」尾房产品 | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 4-7天 | 每日1次 | 落后10% | 启动48h闪购 | 10.0% | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 8-14天 | 每日1次 | 落后15% | 执行表A调价 | 15.0% | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 15-30天 | 每周2次 | 落后20% | 策略复盘+销售动员 | 20.0% | — | — | — | — | — | — | — | — | — | — | — | — | — |
| 31-60天 | 每周1次 | 落后25% | 启动协议客户拜访计划 | 25.0% | — | — | — | — | — | — | — | — | — | — | — | — | — |
| >60天 | 每月1次 | 落后30% | 上报L3，调整年度策略 | 30.0% | — | — | — | — | — | — | — | — | — | — | — | — | — |