06_年度预算与月度分解.xlsx
06 · 年度预算与月度分解 ｜ 使用说明
预算不是拍脑袋的数字，是 365 天每天该怎么卖的作战计划。
一、用途
对应课程 M11《年度预算与滚动预测》与《法典》表 N「每年 9 月下年度预算编制」。
「年度假设」页是唯一参数入口：房量、年度、SPEC 2.3 基线、餐饮/其他收入系数、校准开关。
「月度预算」页按 SPEC 2.5 的月度 OCC/ADR 自动算 RevPAR、房晚、客房收入、餐饮、其他、总营收、GOP、GOPPAR。
「分日预算」页按星期权重把月度 OCC 拆到 365 天，并保证月内加权平均回到月度目标。
「滚动预测」页与「差异分析」页分别用于每月 1 日的滚动更新与量价分解复盘。
—————
二、填色规则
—输入区浅黄底 + 边框由学员填写，例如日期、房晚、价格
—公式区白底 + 边框已预置 Excel 公式，改动会导致结果错误，请勿手改
—参考区灰底 + 斜体SPEC 固定参数/判定表，一般不需要改动
—标题行深蓝底白字字段名，冻结在首行
—————
三、字段字典
列字段名称类型口径 / 预置公式说明
年度假设 B7总房量输入320SPEC 2.1
年度假设 B16-B25SPEC 2.3 基线输入OCC 72% / ADR 618 / 客房 51,977,328 / 餐饮 28,600,000 / 其他 4,100,000 / GOP 率 32%校准目标
年度假设 B29/B30餐饮/其他收入系数公式= 目标餐饮 ÷ 目标客房 ； = 目标其他 ÷ 目标客房≈0.5502 / ≈0.0789
年度假设 B31校准开关输入启用 / 不启用默认启用＝对齐 SPEC 2.3 基线
年度假设 B32校准系数公式#NAME?≈0.9472
月度预算 B/E/F起始日 / OCC / ADR输入SPEC 2.512 个月
月度预算 C天数公式#NAME?自动取 2027 实际天数（28/30/31）
月度预算 G-R收入与利润公式见各列表头含校准后 ADR/RevPAR
分日预算 Q4:Q10星期权重输入默认 0.88/0.93/0.96/1.00/1.12/1.22/1.04可按需调整
分日预算 G日 OCC公式#NAME?保证月内平均回到月度目标
分日预算 Y-AA月度校验公式分日加权 OCC vs 月度 OCC差异 <0.01pp 显示青绿
差异分析 H/I量差 / 价差公式=(实际房晚−预算房晚)×预算ADR ； =(实际ADR−预算ADR)×实际房晚—
—————
四、使用步骤
1在「年度假设」页填总房量、预算年度与年度开始日，确认 SPEC 2.3 基线数值（默认已填好）。
2打开「月度预算」页，核对 12 个月的 OCC/ADR 是否与本店判断一致（默认 SPEC 2.5）。
3看「年度假设」页第四节的双轨校验：偏差% 列应接近 0；如需保留自下而上口径，把 B31 改为「不启用」。
4在「分日预算」页调整右侧星期权重，观察日 OCC 曲线；看 X:AA 的月度校验是否全部青绿。
5每月 1 日：在「滚动预测」页更新已过月份的实际值与未来月份的预测值；在「差异分析」页填实际房晚与实际 ADR，读量差/价差结论。
—————
五、关联《收益管理操作法典》
表 N · 每年 9 月下年度预算编制；每月 1 日上月复盘与滚动预测更新。
《法典》全文未单独设置「预算判定表」，预算偏差的处理走表 A（价格）与表 D（份额）。
表 O · 决策优先级 —— 预算达成率只是诊断信号，动作仍须回到表 A–表 H。
—————
杭州滨江云璟酒店 · 320 间房 · 中高端全服务 ｜ 酒店收益管理学院 HRMA ｜ 口径以 SPEC.md 为准
年度假设 · 预算模型的唯一参数入口
黄底=输入，白底=公式。改这里，月度/分日/滚动/差异四张表全部联动。校准开关说明见第三节。
————
一、基本信息
项目数值单位说明
酒店名称杭州滨江云璟酒店—SPEC 2.1 虚构原型
总房量（间）320—SPEC 2.1：320 间，含 12 间无障碍连通房
预算年度2,027—2027 年为平年，共 365 天
年度开始日2027-01-01 00:00:00—分日预算的首日
年度结束日46752—自动
年天数365—2027 年 = 365 天
年可售房晚116800—320 × 365 = 116,800（与 SPEC 2.3 一致）
————
二、SPEC 2.3 经营基线（校准目标）
指标数值单位来源 / 口径
目标 OCC72.0%—SPEC 2.3：年平均出租率 72.0%
目标 ADR（元）618—SPEC 2.3：年平均房价 ¥618
目标 RevPAR（元）444.96—#NAME?
客房收入目标（元）51977328—SPEC 2.3：¥51,977,328
餐饮收入目标（元）28600000—SPEC 2.3：¥28,600,000
其他收入目标（元）4100000—SPEC 2.3：¥4,100,000
总营收目标（元）84677328—SPEC 2.3 载 ¥84,677,328
GOP 率32.0%—SPEC 2.3：GOP 率 32.0%
GOP 目标（元）27096744.96—SPEC 2.3 载 ¥27,098,741（按 32% 算得 27,096,745，差 0.007%）
GOPPAR 目标（元）231.9926794520548—SPEC 2.3 载 ¥232
————
三、派生系数与校准开关
系数数值单位口径 / 说明
餐饮收入系数0.5502399045984049—#NAME?
其他收入系数0.078880545764107—#NAME?
校准开关启用—启用＝把自下而上结果按校准系数缩放到 SPEC 2.3 基线；不启用＝直接用月度 OCC/ADR 乘算结果
校准系数——#NAME?
自下而上原始客房收入——由 SPEC 2.5 月度 OCC/ADR 直接乘算
自下而上原始 OCC73274405.00493908—约 74.9%
自下而上原始 ADR——约 ¥622
自下而上原始 RevPAR——约 ¥469.7
————
四、双轨校验（自下而上 vs SPEC 2.3 基线）
指标SPEC 2.3 基线模型输出（校准后）偏差%
OCC0.7273274405.00493908101770005.95130429
ADR（元）618——
RevPAR（元）444.96——
客房收入（元）51977328#VALUE!—
餐饮收入（元）28600000#VALUE!—
其他收入（元）4100000#VALUE!—
总营收（元）84677328#VALUE!—
GOP（元）27096744.96——
GOPPAR（元）231.9926794520548——
年可售房晚1168000.7488493150684932-0.9999935886188779
————
⚠ 口径说明：SPEC 2.5 的月度 OCC/ADR 是「目标/预算」口径，加权后 OCC≈74.9%、ADR≈¥622、客房收入≈¥54,871,488，比 SPEC 2.3 的实绩基线（OCC 72.0%、ADR ¥618、客房收入 ¥51,977,328）高约 5.6%。本模型用「校准开关」处理这一差异：启用＝对齐 SPEC 2.3 基线（默认），不启用＝保留自下而上结果。
月度预算 · 2027（SPEC 2.5 月度 OCC / ADR）
输入：B 列起始日、E 列 OCC、F 列 ADR。其余全部为公式。合计行自动汇总并与 SPEC 2.3 对齐。
月份月份起始日天数可售房晚目标 OCC目标 ADRRevPAR (原始)已售房晚客房收入 (原始)校准系数客房收入 (校准后)餐饮收入其他收入总营收GOPGOPPAR校准后 ADR校准后 RevPAR
12027-01-01 00:00:0031992058.0%540313.25753.5999999999993106943.9999999995—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
22027-02-01 00:00:0028896062.0%560347.25555.23110912—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
32027-03-01 00:00:0031992074.0%6004447340.84404480—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
42027-04-01 00:00:0030960082.0%660541.19999999999997871.9999999999995195519.999999999—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
52027-05-01 00:00:0031992084.0%690579.68332.85749631.999999999—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
62027-06-01 00:00:0030960076.0%620471.272964523520—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
72027-07-01 00:00:0031992070.0%58040669444027520—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
82027-08-01 00:00:0031992078.0%630491.400000000000037737.64874688—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
92027-09-01 00:00:0030960083.0%670556.179685338560—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
102027-10-01 00:00:0031992085.0%70059584325902400—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
112027-11-01 00:00:0030960078.0%640499.2000000000000574884792320—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
122027-12-01 00:00:0031992068.0%570387.66745.63844992—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
合计—3651168000.7488493150684932——87465.654871488—#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!———
分日预算 · 365 天（按星期权重把月度 OCC 拆到日）—————————————
输入：右侧「星期权重」参数（黄底）。日 OCC = 月 OCC × 当日权重 × 月天数 ÷ 月权重和，保证月内加权平均回月度目标。—————————————
日期星期星期权重月度目标 OCC月度 天数月度 权重和日 OCC可售房晚已售房晚月度目标 ADR日 ADR客房收入 (原始)校准系数客房收入 (校准后)—星期权重说明—月份天数权重和—月份分日加权 OCC月度预算 OCC差异(pp)
2027-01-01 00:00:00=IF($A4="","",CHOOSE(WEEKDAY(A4,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A4,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A4)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A4)),"")=IFERROR($D4*$C4*$E4/$F4,"")=年度假设!$B$7=$H4*$G4=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A4)),"")=$J4=$I4*$K4=年度假设!$B$32=$L4*$M4—周一0.88商务日，需求偏低—1=SUMPRODUCT((MONTH($A$4:$A$368)=$T4)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T4)*$C$4:$C$368)—1=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X4)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X4)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X4),"")=IFERROR(($Y4-$Z4)*100,"")
46389=IF($A5="","",CHOOSE(WEEKDAY(A5,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A5,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A5)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A5)),"")=IFERROR($D5*$C5*$E5/$F5,"")320=$H5*$G5=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A5)),"")=$J5=$I5*$K5=年度假设!$B$32=$L5*$M5—周二0.93商务日—2=SUMPRODUCT((MONTH($A$4:$A$368)=$T5)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T5)*$C$4:$C$368)—2=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X5)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X5)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X5),"")=IFERROR(($Y5-$Z5)*100,"")
46390=IF($A6="","",CHOOSE(WEEKDAY(A6,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A6,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A6)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A6)),"")=IFERROR($D6*$C6*$E6/$F6,"")320=$H6*$G6=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A6)),"")=$J6=$I6*$K6=年度假设!$B$32=$L6*$M6—周三0.96商务日—3=SUMPRODUCT((MONTH($A$4:$A$368)=$T6)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T6)*$C$4:$C$368)—3=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X6)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X6)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X6),"")=IFERROR(($Y6-$Z6)*100,"")
46391=IF($A7="","",CHOOSE(WEEKDAY(A7,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A7,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A7)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A7)),"")=IFERROR($D7*$C7*$E7/$F7,"")320=$H7*$G7=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A7)),"")=$J7=$I7*$K7=年度假设!$B$32=$L7*$M7—周四1商务日—4=SUMPRODUCT((MONTH($A$4:$A$368)=$T7)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T7)*$C$4:$C$368)—4=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X7)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X7)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X7),"")=IFERROR(($Y7-$Z7)*100,"")
46392=IF($A8="","",CHOOSE(WEEKDAY(A8,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A8,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A8)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A8)),"")=IFERROR($D8*$C8*$E8/$F8,"")320=$H8*$G8=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A8)),"")=$J8=$I8*$K8=年度假设!$B$32=$L8*$M8—周五1.12周末前夜，需求抬升—5=SUMPRODUCT((MONTH($A$4:$A$368)=$T8)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T8)*$C$4:$C$368)—5=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X8)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X8)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X8),"")=IFERROR(($Y8-$Z8)*100,"")
46393=IF($A9="","",CHOOSE(WEEKDAY(A9,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A9,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A9)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A9)),"")=IFERROR($D9*$C9*$E9/$F9,"")320=$H9*$G9=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A9)),"")=$J9=$I9*$K9=年度假设!$B$32=$L9*$M9—周六1.22周末峰值—6=SUMPRODUCT((MONTH($A$4:$A$368)=$T9)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T9)*$C$4:$C$368)—6=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X9)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X9)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X9),"")=IFERROR(($Y9-$Z9)*100,"")
46394=IF($A10="","",CHOOSE(WEEKDAY(A10,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A10,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A10)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A10)),"")=IFERROR($D10*$C10*$E10/$F10,"")320=$H10*$G10=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A10)),"")=$J10=$I10*$K10=年度假设!$B$32=$L10*$M10—周日1.04返程日，高于平日—7=SUMPRODUCT((MONTH($A$4:$A$368)=$T10)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T10)*$C$4:$C$368)—7=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X10)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X10)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X10),"")=IFERROR(($Y10-$Z10)*100,"")
46395=IF($A11="","",CHOOSE(WEEKDAY(A11,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A11,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A11)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A11)),"")=IFERROR($D11*$C11*$E11/$F11,"")320=$H11*$G11=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A11)),"")=$J11=$I11*$K11=年度假设!$B$32=$L11*$M11—————8=SUMPRODUCT((MONTH($A$4:$A$368)=$T11)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T11)*$C$4:$C$368)—8=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X11)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X11)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X11),"")=IFERROR(($Y11-$Z11)*100,"")
46396=IF($A12="","",CHOOSE(WEEKDAY(A12,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A12,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A12)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A12)),"")=IFERROR($D12*$C12*$E12/$F12,"")320=$H12*$G12=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A12)),"")=$J12=$I12*$K12=年度假设!$B$32=$L12*$M12—————9=SUMPRODUCT((MONTH($A$4:$A$368)=$T12)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T12)*$C$4:$C$368)—9=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X12)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X12)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X12),"")=IFERROR(($Y12-$Z12)*100,"")
46397=IF($A13="","",CHOOSE(WEEKDAY(A13,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A13,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A13)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A13)),"")=IFERROR($D13*$C13*$E13/$F13,"")320=$H13*$G13=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A13)),"")=$J13=$I13*$K13=年度假设!$B$32=$L13*$M13—————10=SUMPRODUCT((MONTH($A$4:$A$368)=$T13)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T13)*$C$4:$C$368)—10=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X13)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X13)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X13),"")=IFERROR(($Y13-$Z13)*100,"")
46398=IF($A14="","",CHOOSE(WEEKDAY(A14,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A14,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A14)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A14)),"")=IFERROR($D14*$C14*$E14/$F14,"")320=$H14*$G14=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A14)),"")=$J14=$I14*$K14=年度假设!$B$32=$L14*$M14—————11=SUMPRODUCT((MONTH($A$4:$A$368)=$T14)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T14)*$C$4:$C$368)—11=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X14)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X14)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X14),"")=IFERROR(($Y14-$Z14)*100,"")
46399=IF($A15="","",CHOOSE(WEEKDAY(A15,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A15,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A15)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A15)),"")=IFERROR($D15*$C15*$E15/$F15,"")320=$H15*$G15=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A15)),"")=$J15=$I15*$K15=年度假设!$B$32=$L15*$M15—————12=SUMPRODUCT((MONTH($A$4:$A$368)=$T15)*1)=SUMPRODUCT((MONTH($A$4:$A$368)=$T15)*$C$4:$C$368)—12=IFERROR(SUMPRODUCT((MONTH($A$4:$A$368)=$X15)*$I$4:$I$368)/SUMPRODUCT((MONTH($A$4:$A$368)=$X15)*$H$4:$H$368),"")=IFERROR(INDEX(月度预算!$E$4:$E$15,$X15),"")=IFERROR(($Y15-$Z15)*100,"")
46400=IF($A16="","",CHOOSE(WEEKDAY(A16,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A16,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A16)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A16)),"")=IFERROR($D16*$C16*$E16/$F16,"")320=$H16*$G16=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A16)),"")=$J16=$I16*$K16=年度假设!$B$32=$L16*$M16—————————————
46401=IF($A17="","",CHOOSE(WEEKDAY(A17,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A17,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A17)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A17)),"")=IFERROR($D17*$C17*$E17/$F17,"")320=$H17*$G17=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A17)),"")=$J17=$I17*$K17=年度假设!$B$32=$L17*$M17—————————————
46402=IF($A18="","",CHOOSE(WEEKDAY(A18,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A18,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A18)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A18)),"")=IFERROR($D18*$C18*$E18/$F18,"")320=$H18*$G18=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A18)),"")=$J18=$I18*$K18=年度假设!$B$32=$L18*$M18—————————————
46403=IF($A19="","",CHOOSE(WEEKDAY(A19,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A19,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A19)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A19)),"")=IFERROR($D19*$C19*$E19/$F19,"")320=$H19*$G19=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A19)),"")=$J19=$I19*$K19=年度假设!$B$32=$L19*$M19—————————————
46404=IF($A20="","",CHOOSE(WEEKDAY(A20,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A20,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A20)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A20)),"")=IFERROR($D20*$C20*$E20/$F20,"")320=$H20*$G20=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A20)),"")=$J20=$I20*$K20=年度假设!$B$32=$L20*$M20—————————————
46405=IF($A21="","",CHOOSE(WEEKDAY(A21,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A21,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A21)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A21)),"")=IFERROR($D21*$C21*$E21/$F21,"")320=$H21*$G21=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A21)),"")=$J21=$I21*$K21=年度假设!$B$32=$L21*$M21—————————————
46406=IF($A22="","",CHOOSE(WEEKDAY(A22,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A22,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A22)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A22)),"")=IFERROR($D22*$C22*$E22/$F22,"")320=$H22*$G22=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A22)),"")=$J22=$I22*$K22=年度假设!$B$32=$L22*$M22—————————————
46407=IF($A23="","",CHOOSE(WEEKDAY(A23,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A23,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A23)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A23)),"")=IFERROR($D23*$C23*$E23/$F23,"")320=$H23*$G23=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A23)),"")=$J23=$I23*$K23=年度假设!$B$32=$L23*$M23—————————————
46408=IF($A24="","",CHOOSE(WEEKDAY(A24,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A24,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A24)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A24)),"")=IFERROR($D24*$C24*$E24/$F24,"")320=$H24*$G24=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A24)),"")=$J24=$I24*$K24=年度假设!$B$32=$L24*$M24—————————————
46409=IF($A25="","",CHOOSE(WEEKDAY(A25,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A25,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A25)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A25)),"")=IFERROR($D25*$C25*$E25/$F25,"")320=$H25*$G25=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A25)),"")=$J25=$I25*$K25=年度假设!$B$32=$L25*$M25—————————————
46410=IF($A26="","",CHOOSE(WEEKDAY(A26,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A26,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A26)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A26)),"")=IFERROR($D26*$C26*$E26/$F26,"")320=$H26*$G26=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A26)),"")=$J26=$I26*$K26=年度假设!$B$32=$L26*$M26—————————————
46411=IF($A27="","",CHOOSE(WEEKDAY(A27,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A27,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A27)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A27)),"")=IFERROR($D27*$C27*$E27/$F27,"")320=$H27*$G27=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A27)),"")=$J27=$I27*$K27=年度假设!$B$32=$L27*$M27—————————————
46412=IF($A28="","",CHOOSE(WEEKDAY(A28,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A28,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A28)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A28)),"")=IFERROR($D28*$C28*$E28/$F28,"")320=$H28*$G28=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A28)),"")=$J28=$I28*$K28=年度假设!$B$32=$L28*$M28—————————————
46413=IF($A29="","",CHOOSE(WEEKDAY(A29,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A29,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A29)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A29)),"")=IFERROR($D29*$C29*$E29/$F29,"")320=$H29*$G29=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A29)),"")=$J29=$I29*$K29=年度假设!$B$32=$L29*$M29—————————————
46414=IF($A30="","",CHOOSE(WEEKDAY(A30,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A30,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A30)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A30)),"")=IFERROR($D30*$C30*$E30/$F30,"")320=$H30*$G30=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A30)),"")=$J30=$I30*$K30=年度假设!$B$32=$L30*$M30—————————————
46415=IF($A31="","",CHOOSE(WEEKDAY(A31,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A31,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A31)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A31)),"")=IFERROR($D31*$C31*$E31/$F31,"")320=$H31*$G31=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A31)),"")=$J31=$I31*$K31=年度假设!$B$32=$L31*$M31—————————————
46416=IF($A32="","",CHOOSE(WEEKDAY(A32,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A32,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A32)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A32)),"")=IFERROR($D32*$C32*$E32/$F32,"")320=$H32*$G32=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A32)),"")=$J32=$I32*$K32=年度假设!$B$32=$L32*$M32—————————————
46417=IF($A33="","",CHOOSE(WEEKDAY(A33,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A33,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A33)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A33)),"")=IFERROR($D33*$C33*$E33/$F33,"")320=$H33*$G33=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A33)),"")=$J33=$I33*$K33=年度假设!$B$32=$L33*$M33—————————————
46418=IF($A34="","",CHOOSE(WEEKDAY(A34,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A34,2)),"")0.58=IFERROR(INDEX($U$4:$U$15,MONTH($A34)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A34)),"")=IFERROR($D34*$C34*$E34/$F34,"")320=$H34*$G34=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A34)),"")=$J34=$I34*$K34=年度假设!$B$32=$L34*$M34—————————————
46419=IF($A35="","",CHOOSE(WEEKDAY(A35,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A35,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A35)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A35)),"")=IFERROR($D35*$C35*$E35/$F35,"")320=$H35*$G35=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A35)),"")=$J35=$I35*$K35=年度假设!$B$32=$L35*$M35—————————————
46420=IF($A36="","",CHOOSE(WEEKDAY(A36,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A36,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A36)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A36)),"")=IFERROR($D36*$C36*$E36/$F36,"")320=$H36*$G36=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A36)),"")=$J36=$I36*$K36=年度假设!$B$32=$L36*$M36—————————————
46421=IF($A37="","",CHOOSE(WEEKDAY(A37,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A37,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A37)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A37)),"")=IFERROR($D37*$C37*$E37/$F37,"")320=$H37*$G37=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A37)),"")=$J37=$I37*$K37=年度假设!$B$32=$L37*$M37—————————————
46422=IF($A38="","",CHOOSE(WEEKDAY(A38,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A38,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A38)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A38)),"")=IFERROR($D38*$C38*$E38/$F38,"")320=$H38*$G38=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A38)),"")=$J38=$I38*$K38=年度假设!$B$32=$L38*$M38—————————————
46423=IF($A39="","",CHOOSE(WEEKDAY(A39,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A39,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A39)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A39)),"")=IFERROR($D39*$C39*$E39/$F39,"")320=$H39*$G39=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A39)),"")=$J39=$I39*$K39=年度假设!$B$32=$L39*$M39—————————————
46424=IF($A40="","",CHOOSE(WEEKDAY(A40,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A40,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A40)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A40)),"")=IFERROR($D40*$C40*$E40/$F40,"")320=$H40*$G40=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A40)),"")=$J40=$I40*$K40=年度假设!$B$32=$L40*$M40—————————————
46425=IF($A41="","",CHOOSE(WEEKDAY(A41,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A41,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A41)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A41)),"")=IFERROR($D41*$C41*$E41/$F41,"")320=$H41*$G41=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A41)),"")=$J41=$I41*$K41=年度假设!$B$32=$L41*$M41—————————————
46426=IF($A42="","",CHOOSE(WEEKDAY(A42,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A42,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A42)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A42)),"")=IFERROR($D42*$C42*$E42/$F42,"")320=$H42*$G42=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A42)),"")=$J42=$I42*$K42=年度假设!$B$32=$L42*$M42—————————————
46427=IF($A43="","",CHOOSE(WEEKDAY(A43,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A43,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A43)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A43)),"")=IFERROR($D43*$C43*$E43/$F43,"")320=$H43*$G43=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A43)),"")=$J43=$I43*$K43=年度假设!$B$32=$L43*$M43—————————————
46428=IF($A44="","",CHOOSE(WEEKDAY(A44,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A44,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A44)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A44)),"")=IFERROR($D44*$C44*$E44/$F44,"")320=$H44*$G44=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A44)),"")=$J44=$I44*$K44=年度假设!$B$32=$L44*$M44—————————————
46429=IF($A45="","",CHOOSE(WEEKDAY(A45,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A45,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A45)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A45)),"")=IFERROR($D45*$C45*$E45/$F45,"")320=$H45*$G45=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A45)),"")=$J45=$I45*$K45=年度假设!$B$32=$L45*$M45—————————————
46430=IF($A46="","",CHOOSE(WEEKDAY(A46,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A46,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A46)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A46)),"")=IFERROR($D46*$C46*$E46/$F46,"")320=$H46*$G46=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A46)),"")=$J46=$I46*$K46=年度假设!$B$32=$L46*$M46—————————————
46431=IF($A47="","",CHOOSE(WEEKDAY(A47,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A47,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A47)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A47)),"")=IFERROR($D47*$C47*$E47/$F47,"")320=$H47*$G47=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A47)),"")=$J47=$I47*$K47=年度假设!$B$32=$L47*$M47—————————————
46432=IF($A48="","",CHOOSE(WEEKDAY(A48,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A48,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A48)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A48)),"")=IFERROR($D48*$C48*$E48/$F48,"")320=$H48*$G48=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A48)),"")=$J48=$I48*$K48=年度假设!$B$32=$L48*$M48—————————————
46433=IF($A49="","",CHOOSE(WEEKDAY(A49,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A49,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A49)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A49)),"")=IFERROR($D49*$C49*$E49/$F49,"")320=$H49*$G49=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A49)),"")=$J49=$I49*$K49=年度假设!$B$32=$L49*$M49—————————————
46434=IF($A50="","",CHOOSE(WEEKDAY(A50,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A50,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A50)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A50)),"")=IFERROR($D50*$C50*$E50/$F50,"")320=$H50*$G50=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A50)),"")=$J50=$I50*$K50=年度假设!$B$32=$L50*$M50—————————————
46435=IF($A51="","",CHOOSE(WEEKDAY(A51,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A51,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A51)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A51)),"")=IFERROR($D51*$C51*$E51/$F51,"")320=$H51*$G51=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A51)),"")=$J51=$I51*$K51=年度假设!$B$32=$L51*$M51—————————————
46436=IF($A52="","",CHOOSE(WEEKDAY(A52,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A52,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A52)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A52)),"")=IFERROR($D52*$C52*$E52/$F52,"")320=$H52*$G52=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A52)),"")=$J52=$I52*$K52=年度假设!$B$32=$L52*$M52—————————————
46437=IF($A53="","",CHOOSE(WEEKDAY(A53,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A53,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A53)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A53)),"")=IFERROR($D53*$C53*$E53/$F53,"")320=$H53*$G53=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A53)),"")=$J53=$I53*$K53=年度假设!$B$32=$L53*$M53—————————————
46438=IF($A54="","",CHOOSE(WEEKDAY(A54,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A54,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A54)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A54)),"")=IFERROR($D54*$C54*$E54/$F54,"")320=$H54*$G54=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A54)),"")=$J54=$I54*$K54=年度假设!$B$32=$L54*$M54—————————————
46439=IF($A55="","",CHOOSE(WEEKDAY(A55,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A55,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A55)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A55)),"")=IFERROR($D55*$C55*$E55/$F55,"")320=$H55*$G55=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A55)),"")=$J55=$I55*$K55=年度假设!$B$32=$L55*$M55—————————————
46440=IF($A56="","",CHOOSE(WEEKDAY(A56,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A56,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A56)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A56)),"")=IFERROR($D56*$C56*$E56/$F56,"")320=$H56*$G56=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A56)),"")=$J56=$I56*$K56=年度假设!$B$32=$L56*$M56—————————————
46441=IF($A57="","",CHOOSE(WEEKDAY(A57,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A57,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A57)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A57)),"")=IFERROR($D57*$C57*$E57/$F57,"")320=$H57*$G57=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A57)),"")=$J57=$I57*$K57=年度假设!$B$32=$L57*$M57—————————————
46442=IF($A58="","",CHOOSE(WEEKDAY(A58,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A58,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A58)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A58)),"")=IFERROR($D58*$C58*$E58/$F58,"")320=$H58*$G58=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A58)),"")=$J58=$I58*$K58=年度假设!$B$32=$L58*$M58—————————————
46443=IF($A59="","",CHOOSE(WEEKDAY(A59,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A59,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A59)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A59)),"")=IFERROR($D59*$C59*$E59/$F59,"")320=$H59*$G59=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A59)),"")=$J59=$I59*$K59=年度假设!$B$32=$L59*$M59—————————————
46444=IF($A60="","",CHOOSE(WEEKDAY(A60,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A60,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A60)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A60)),"")=IFERROR($D60*$C60*$E60/$F60,"")320=$H60*$G60=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A60)),"")=$J60=$I60*$K60=年度假设!$B$32=$L60*$M60—————————————
46445=IF($A61="","",CHOOSE(WEEKDAY(A61,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A61,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A61)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A61)),"")=IFERROR($D61*$C61*$E61/$F61,"")320=$H61*$G61=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A61)),"")=$J61=$I61*$K61=年度假设!$B$32=$L61*$M61—————————————
46446=IF($A62="","",CHOOSE(WEEKDAY(A62,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A62,2)),"")0.62=IFERROR(INDEX($U$4:$U$15,MONTH($A62)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A62)),"")=IFERROR($D62*$C62*$E62/$F62,"")320=$H62*$G62=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A62)),"")=$J62=$I62*$K62=年度假设!$B$32=$L62*$M62—————————————
46447=IF($A63="","",CHOOSE(WEEKDAY(A63,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A63,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A63)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A63)),"")=IFERROR($D63*$C63*$E63/$F63,"")320=$H63*$G63=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A63)),"")=$J63=$I63*$K63=年度假设!$B$32=$L63*$M63—————————————
46448=IF($A64="","",CHOOSE(WEEKDAY(A64,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A64,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A64)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A64)),"")=IFERROR($D64*$C64*$E64/$F64,"")320=$H64*$G64=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A64)),"")=$J64=$I64*$K64=年度假设!$B$32=$L64*$M64—————————————
46449=IF($A65="","",CHOOSE(WEEKDAY(A65,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A65,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A65)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A65)),"")=IFERROR($D65*$C65*$E65/$F65,"")320=$H65*$G65=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A65)),"")=$J65=$I65*$K65=年度假设!$B$32=$L65*$M65—————————————
46450=IF($A66="","",CHOOSE(WEEKDAY(A66,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A66,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A66)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A66)),"")=IFERROR($D66*$C66*$E66/$F66,"")320=$H66*$G66=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A66)),"")=$J66=$I66*$K66=年度假设!$B$32=$L66*$M66—————————————
46451=IF($A67="","",CHOOSE(WEEKDAY(A67,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A67,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A67)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A67)),"")=IFERROR($D67*$C67*$E67/$F67,"")320=$H67*$G67=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A67)),"")=$J67=$I67*$K67=年度假设!$B$32=$L67*$M67—————————————
46452=IF($A68="","",CHOOSE(WEEKDAY(A68,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A68,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A68)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A68)),"")=IFERROR($D68*$C68*$E68/$F68,"")320=$H68*$G68=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A68)),"")=$J68=$I68*$K68=年度假设!$B$32=$L68*$M68—————————————
46453=IF($A69="","",CHOOSE(WEEKDAY(A69,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A69,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A69)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A69)),"")=IFERROR($D69*$C69*$E69/$F69,"")320=$H69*$G69=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A69)),"")=$J69=$I69*$K69=年度假设!$B$32=$L69*$M69—————————————
46454=IF($A70="","",CHOOSE(WEEKDAY(A70,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A70,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A70)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A70)),"")=IFERROR($D70*$C70*$E70/$F70,"")320=$H70*$G70=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A70)),"")=$J70=$I70*$K70=年度假设!$B$32=$L70*$M70—————————————
46455=IF($A71="","",CHOOSE(WEEKDAY(A71,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A71,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A71)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A71)),"")=IFERROR($D71*$C71*$E71/$F71,"")320=$H71*$G71=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A71)),"")=$J71=$I71*$K71=年度假设!$B$32=$L71*$M71—————————————
46456=IF($A72="","",CHOOSE(WEEKDAY(A72,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A72,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A72)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A72)),"")=IFERROR($D72*$C72*$E72/$F72,"")320=$H72*$G72=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A72)),"")=$J72=$I72*$K72=年度假设!$B$32=$L72*$M72—————————————
46457=IF($A73="","",CHOOSE(WEEKDAY(A73,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A73,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A73)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A73)),"")=IFERROR($D73*$C73*$E73/$F73,"")320=$H73*$G73=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A73)),"")=$J73=$I73*$K73=年度假设!$B$32=$L73*$M73—————————————
46458=IF($A74="","",CHOOSE(WEEKDAY(A74,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A74,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A74)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A74)),"")=IFERROR($D74*$C74*$E74/$F74,"")320=$H74*$G74=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A74)),"")=$J74=$I74*$K74=年度假设!$B$32=$L74*$M74—————————————
46459=IF($A75="","",CHOOSE(WEEKDAY(A75,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A75,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A75)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A75)),"")=IFERROR($D75*$C75*$E75/$F75,"")320=$H75*$G75=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A75)),"")=$J75=$I75*$K75=年度假设!$B$32=$L75*$M75—————————————
46460=IF($A76="","",CHOOSE(WEEKDAY(A76,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A76,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A76)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A76)),"")=IFERROR($D76*$C76*$E76/$F76,"")320=$H76*$G76=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A76)),"")=$J76=$I76*$K76=年度假设!$B$32=$L76*$M76—————————————
46461=IF($A77="","",CHOOSE(WEEKDAY(A77,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A77,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A77)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A77)),"")=IFERROR($D77*$C77*$E77/$F77,"")320=$H77*$G77=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A77)),"")=$J77=$I77*$K77=年度假设!$B$32=$L77*$M77—————————————
46462=IF($A78="","",CHOOSE(WEEKDAY(A78,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A78,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A78)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A78)),"")=IFERROR($D78*$C78*$E78/$F78,"")320=$H78*$G78=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A78)),"")=$J78=$I78*$K78=年度假设!$B$32=$L78*$M78—————————————
46463=IF($A79="","",CHOOSE(WEEKDAY(A79,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A79,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A79)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A79)),"")=IFERROR($D79*$C79*$E79/$F79,"")320=$H79*$G79=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A79)),"")=$J79=$I79*$K79=年度假设!$B$32=$L79*$M79—————————————
46464=IF($A80="","",CHOOSE(WEEKDAY(A80,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A80,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A80)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A80)),"")=IFERROR($D80*$C80*$E80/$F80,"")320=$H80*$G80=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A80)),"")=$J80=$I80*$K80=年度假设!$B$32=$L80*$M80—————————————
46465=IF($A81="","",CHOOSE(WEEKDAY(A81,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A81,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A81)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A81)),"")=IFERROR($D81*$C81*$E81/$F81,"")320=$H81*$G81=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A81)),"")=$J81=$I81*$K81=年度假设!$B$32=$L81*$M81—————————————
46466=IF($A82="","",CHOOSE(WEEKDAY(A82,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A82,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A82)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A82)),"")=IFERROR($D82*$C82*$E82/$F82,"")320=$H82*$G82=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A82)),"")=$J82=$I82*$K82=年度假设!$B$32=$L82*$M82—————————————
46467=IF($A83="","",CHOOSE(WEEKDAY(A83,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A83,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A83)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A83)),"")=IFERROR($D83*$C83*$E83/$F83,"")320=$H83*$G83=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A83)),"")=$J83=$I83*$K83=年度假设!$B$32=$L83*$M83—————————————
46468=IF($A84="","",CHOOSE(WEEKDAY(A84,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A84,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A84)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A84)),"")=IFERROR($D84*$C84*$E84/$F84,"")320=$H84*$G84=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A84)),"")=$J84=$I84*$K84=年度假设!$B$32=$L84*$M84—————————————
46469=IF($A85="","",CHOOSE(WEEKDAY(A85,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A85,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A85)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A85)),"")=IFERROR($D85*$C85*$E85/$F85,"")320=$H85*$G85=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A85)),"")=$J85=$I85*$K85=年度假设!$B$32=$L85*$M85—————————————
46470=IF($A86="","",CHOOSE(WEEKDAY(A86,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A86,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A86)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A86)),"")=IFERROR($D86*$C86*$E86/$F86,"")320=$H86*$G86=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A86)),"")=$J86=$I86*$K86=年度假设!$B$32=$L86*$M86—————————————
46471=IF($A87="","",CHOOSE(WEEKDAY(A87,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A87,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A87)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A87)),"")=IFERROR($D87*$C87*$E87/$F87,"")320=$H87*$G87=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A87)),"")=$J87=$I87*$K87=年度假设!$B$32=$L87*$M87—————————————
46472=IF($A88="","",CHOOSE(WEEKDAY(A88,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A88,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A88)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A88)),"")=IFERROR($D88*$C88*$E88/$F88,"")320=$H88*$G88=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A88)),"")=$J88=$I88*$K88=年度假设!$B$32=$L88*$M88—————————————
46473=IF($A89="","",CHOOSE(WEEKDAY(A89,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A89,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A89)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A89)),"")=IFERROR($D89*$C89*$E89/$F89,"")320=$H89*$G89=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A89)),"")=$J89=$I89*$K89=年度假设!$B$32=$L89*$M89—————————————
46474=IF($A90="","",CHOOSE(WEEKDAY(A90,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A90,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A90)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A90)),"")=IFERROR($D90*$C90*$E90/$F90,"")320=$H90*$G90=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A90)),"")=$J90=$I90*$K90=年度假设!$B$32=$L90*$M90—————————————
46475=IF($A91="","",CHOOSE(WEEKDAY(A91,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A91,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A91)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A91)),"")=IFERROR($D91*$C91*$E91/$F91,"")320=$H91*$G91=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A91)),"")=$J91=$I91*$K91=年度假设!$B$32=$L91*$M91—————————————
46476=IF($A92="","",CHOOSE(WEEKDAY(A92,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A92,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A92)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A92)),"")=IFERROR($D92*$C92*$E92/$F92,"")320=$H92*$G92=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A92)),"")=$J92=$I92*$K92=年度假设!$B$32=$L92*$M92—————————————
46477=IF($A93="","",CHOOSE(WEEKDAY(A93,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A93,2)),"")0.74=IFERROR(INDEX($U$4:$U$15,MONTH($A93)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A93)),"")=IFERROR($D93*$C93*$E93/$F93,"")320=$H93*$G93=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A93)),"")=$J93=$I93*$K93=年度假设!$B$32=$L93*$M93—————————————
46478=IF($A94="","",CHOOSE(WEEKDAY(A94,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A94,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A94)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A94)),"")=IFERROR($D94*$C94*$E94/$F94,"")320=$H94*$G94=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A94)),"")=$J94=$I94*$K94=年度假设!$B$32=$L94*$M94—————————————
46479=IF($A95="","",CHOOSE(WEEKDAY(A95,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A95,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A95)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A95)),"")=IFERROR($D95*$C95*$E95/$F95,"")320=$H95*$G95=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A95)),"")=$J95=$I95*$K95=年度假设!$B$32=$L95*$M95—————————————
46480=IF($A96="","",CHOOSE(WEEKDAY(A96,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A96,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A96)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A96)),"")=IFERROR($D96*$C96*$E96/$F96,"")320=$H96*$G96=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A96)),"")=$J96=$I96*$K96=年度假设!$B$32=$L96*$M96—————————————
46481=IF($A97="","",CHOOSE(WEEKDAY(A97,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A97,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A97)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A97)),"")=IFERROR($D97*$C97*$E97/$F97,"")320=$H97*$G97=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A97)),"")=$J97=$I97*$K97=年度假设!$B$32=$L97*$M97—————————————
46482=IF($A98="","",CHOOSE(WEEKDAY(A98,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A98,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A98)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A98)),"")=IFERROR($D98*$C98*$E98/$F98,"")320=$H98*$G98=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A98)),"")=$J98=$I98*$K98=年度假设!$B$32=$L98*$M98—————————————
46483=IF($A99="","",CHOOSE(WEEKDAY(A99,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A99,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A99)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A99)),"")=IFERROR($D99*$C99*$E99/$F99,"")320=$H99*$G99=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A99)),"")=$J99=$I99*$K99=年度假设!$B$32=$L99*$M99—————————————
46484=IF($A100="","",CHOOSE(WEEKDAY(A100,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A100,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A100)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A100)),"")=IFERROR($D100*$C100*$E100/$F100,"")320=$H100*$G100=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A100)),"")=$J100=$I100*$K100=年度假设!$B$32=$L100*$M100—————————————
46485=IF($A101="","",CHOOSE(WEEKDAY(A101,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A101,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A101)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A101)),"")=IFERROR($D101*$C101*$E101/$F101,"")320=$H101*$G101=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A101)),"")=$J101=$I101*$K101=年度假设!$B$32=$L101*$M101—————————————
46486=IF($A102="","",CHOOSE(WEEKDAY(A102,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A102,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A102)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A102)),"")=IFERROR($D102*$C102*$E102/$F102,"")320=$H102*$G102=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A102)),"")=$J102=$I102*$K102=年度假设!$B$32=$L102*$M102—————————————
46487=IF($A103="","",CHOOSE(WEEKDAY(A103,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A103,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A103)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A103)),"")=IFERROR($D103*$C103*$E103/$F103,"")320=$H103*$G103=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A103)),"")=$J103=$I103*$K103=年度假设!$B$32=$L103*$M103—————————————
46488=IF($A104="","",CHOOSE(WEEKDAY(A104,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A104,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A104)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A104)),"")=IFERROR($D104*$C104*$E104/$F104,"")320=$H104*$G104=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A104)),"")=$J104=$I104*$K104=年度假设!$B$32=$L104*$M104—————————————
46489=IF($A105="","",CHOOSE(WEEKDAY(A105,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A105,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A105)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A105)),"")=IFERROR($D105*$C105*$E105/$F105,"")320=$H105*$G105=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A105)),"")=$J105=$I105*$K105=年度假设!$B$32=$L105*$M105—————————————
46490=IF($A106="","",CHOOSE(WEEKDAY(A106,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A106,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A106)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A106)),"")=IFERROR($D106*$C106*$E106/$F106,"")320=$H106*$G106=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A106)),"")=$J106=$I106*$K106=年度假设!$B$32=$L106*$M106—————————————
46491=IF($A107="","",CHOOSE(WEEKDAY(A107,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A107,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A107)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A107)),"")=IFERROR($D107*$C107*$E107/$F107,"")320=$H107*$G107=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A107)),"")=$J107=$I107*$K107=年度假设!$B$32=$L107*$M107—————————————
46492=IF($A108="","",CHOOSE(WEEKDAY(A108,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A108,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A108)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A108)),"")=IFERROR($D108*$C108*$E108/$F108,"")320=$H108*$G108=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A108)),"")=$J108=$I108*$K108=年度假设!$B$32=$L108*$M108—————————————
46493=IF($A109="","",CHOOSE(WEEKDAY(A109,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A109,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A109)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A109)),"")=IFERROR($D109*$C109*$E109/$F109,"")320=$H109*$G109=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A109)),"")=$J109=$I109*$K109=年度假设!$B$32=$L109*$M109—————————————
46494=IF($A110="","",CHOOSE(WEEKDAY(A110,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A110,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A110)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A110)),"")=IFERROR($D110*$C110*$E110/$F110,"")320=$H110*$G110=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A110)),"")=$J110=$I110*$K110=年度假设!$B$32=$L110*$M110—————————————
46495=IF($A111="","",CHOOSE(WEEKDAY(A111,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A111,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A111)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A111)),"")=IFERROR($D111*$C111*$E111/$F111,"")320=$H111*$G111=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A111)),"")=$J111=$I111*$K111=年度假设!$B$32=$L111*$M111—————————————
46496=IF($A112="","",CHOOSE(WEEKDAY(A112,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A112,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A112)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A112)),"")=IFERROR($D112*$C112*$E112/$F112,"")320=$H112*$G112=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A112)),"")=$J112=$I112*$K112=年度假设!$B$32=$L112*$M112—————————————
46497=IF($A113="","",CHOOSE(WEEKDAY(A113,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A113,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A113)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A113)),"")=IFERROR($D113*$C113*$E113/$F113,"")320=$H113*$G113=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A113)),"")=$J113=$I113*$K113=年度假设!$B$32=$L113*$M113—————————————
46498=IF($A114="","",CHOOSE(WEEKDAY(A114,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A114,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A114)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A114)),"")=IFERROR($D114*$C114*$E114/$F114,"")320=$H114*$G114=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A114)),"")=$J114=$I114*$K114=年度假设!$B$32=$L114*$M114—————————————
46499=IF($A115="","",CHOOSE(WEEKDAY(A115,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A115,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A115)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A115)),"")=IFERROR($D115*$C115*$E115/$F115,"")320=$H115*$G115=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A115)),"")=$J115=$I115*$K115=年度假设!$B$32=$L115*$M115—————————————
46500=IF($A116="","",CHOOSE(WEEKDAY(A116,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A116,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A116)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A116)),"")=IFERROR($D116*$C116*$E116/$F116,"")320=$H116*$G116=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A116)),"")=$J116=$I116*$K116=年度假设!$B$32=$L116*$M116—————————————
46501=IF($A117="","",CHOOSE(WEEKDAY(A117,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A117,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A117)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A117)),"")=IFERROR($D117*$C117*$E117/$F117,"")320=$H117*$G117=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A117)),"")=$J117=$I117*$K117=年度假设!$B$32=$L117*$M117—————————————
46502=IF($A118="","",CHOOSE(WEEKDAY(A118,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A118,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A118)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A118)),"")=IFERROR($D118*$C118*$E118/$F118,"")320=$H118*$G118=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A118)),"")=$J118=$I118*$K118=年度假设!$B$32=$L118*$M118—————————————
46503=IF($A119="","",CHOOSE(WEEKDAY(A119,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A119,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A119)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A119)),"")=IFERROR($D119*$C119*$E119/$F119,"")320=$H119*$G119=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A119)),"")=$J119=$I119*$K119=年度假设!$B$32=$L119*$M119—————————————
46504=IF($A120="","",CHOOSE(WEEKDAY(A120,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A120,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A120)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A120)),"")=IFERROR($D120*$C120*$E120/$F120,"")320=$H120*$G120=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A120)),"")=$J120=$I120*$K120=年度假设!$B$32=$L120*$M120—————————————
46505=IF($A121="","",CHOOSE(WEEKDAY(A121,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A121,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A121)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A121)),"")=IFERROR($D121*$C121*$E121/$F121,"")320=$H121*$G121=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A121)),"")=$J121=$I121*$K121=年度假设!$B$32=$L121*$M121—————————————
46506=IF($A122="","",CHOOSE(WEEKDAY(A122,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A122,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A122)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A122)),"")=IFERROR($D122*$C122*$E122/$F122,"")320=$H122*$G122=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A122)),"")=$J122=$I122*$K122=年度假设!$B$32=$L122*$M122—————————————
46507=IF($A123="","",CHOOSE(WEEKDAY(A123,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A123,2)),"")0.82=IFERROR(INDEX($U$4:$U$15,MONTH($A123)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A123)),"")=IFERROR($D123*$C123*$E123/$F123,"")320=$H123*$G123=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A123)),"")=$J123=$I123*$K123=年度假设!$B$32=$L123*$M123—————————————
46508=IF($A124="","",CHOOSE(WEEKDAY(A124,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A124,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A124)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A124)),"")=IFERROR($D124*$C124*$E124/$F124,"")320=$H124*$G124=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A124)),"")=$J124=$I124*$K124=年度假设!$B$32=$L124*$M124—————————————
46509=IF($A125="","",CHOOSE(WEEKDAY(A125,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A125,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A125)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A125)),"")=IFERROR($D125*$C125*$E125/$F125,"")320=$H125*$G125=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A125)),"")=$J125=$I125*$K125=年度假设!$B$32=$L125*$M125—————————————
46510=IF($A126="","",CHOOSE(WEEKDAY(A126,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A126,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A126)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A126)),"")=IFERROR($D126*$C126*$E126/$F126,"")320=$H126*$G126=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A126)),"")=$J126=$I126*$K126=年度假设!$B$32=$L126*$M126—————————————
46511=IF($A127="","",CHOOSE(WEEKDAY(A127,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A127,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A127)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A127)),"")=IFERROR($D127*$C127*$E127/$F127,"")320=$H127*$G127=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A127)),"")=$J127=$I127*$K127=年度假设!$B$32=$L127*$M127—————————————
46512=IF($A128="","",CHOOSE(WEEKDAY(A128,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A128,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A128)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A128)),"")=IFERROR($D128*$C128*$E128/$F128,"")320=$H128*$G128=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A128)),"")=$J128=$I128*$K128=年度假设!$B$32=$L128*$M128—————————————
46513=IF($A129="","",CHOOSE(WEEKDAY(A129,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A129,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A129)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A129)),"")=IFERROR($D129*$C129*$E129/$F129,"")320=$H129*$G129=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A129)),"")=$J129=$I129*$K129=年度假设!$B$32=$L129*$M129—————————————
46514=IF($A130="","",CHOOSE(WEEKDAY(A130,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A130,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A130)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A130)),"")=IFERROR($D130*$C130*$E130/$F130,"")320=$H130*$G130=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A130)),"")=$J130=$I130*$K130=年度假设!$B$32=$L130*$M130—————————————
46515=IF($A131="","",CHOOSE(WEEKDAY(A131,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A131,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A131)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A131)),"")=IFERROR($D131*$C131*$E131/$F131,"")320=$H131*$G131=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A131)),"")=$J131=$I131*$K131=年度假设!$B$32=$L131*$M131—————————————
46516=IF($A132="","",CHOOSE(WEEKDAY(A132,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A132,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A132)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A132)),"")=IFERROR($D132*$C132*$E132/$F132,"")320=$H132*$G132=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A132)),"")=$J132=$I132*$K132=年度假设!$B$32=$L132*$M132—————————————
46517=IF($A133="","",CHOOSE(WEEKDAY(A133,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A133,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A133)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A133)),"")=IFERROR($D133*$C133*$E133/$F133,"")320=$H133*$G133=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A133)),"")=$J133=$I133*$K133=年度假设!$B$32=$L133*$M133—————————————
46518=IF($A134="","",CHOOSE(WEEKDAY(A134,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A134,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A134)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A134)),"")=IFERROR($D134*$C134*$E134/$F134,"")320=$H134*$G134=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A134)),"")=$J134=$I134*$K134=年度假设!$B$32=$L134*$M134—————————————
46519=IF($A135="","",CHOOSE(WEEKDAY(A135,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A135,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A135)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A135)),"")=IFERROR($D135*$C135*$E135/$F135,"")320=$H135*$G135=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A135)),"")=$J135=$I135*$K135=年度假设!$B$32=$L135*$M135—————————————
46520=IF($A136="","",CHOOSE(WEEKDAY(A136,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A136,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A136)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A136)),"")=IFERROR($D136*$C136*$E136/$F136,"")320=$H136*$G136=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A136)),"")=$J136=$I136*$K136=年度假设!$B$32=$L136*$M136—————————————
46521=IF($A137="","",CHOOSE(WEEKDAY(A137,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A137,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A137)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A137)),"")=IFERROR($D137*$C137*$E137/$F137,"")320=$H137*$G137=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A137)),"")=$J137=$I137*$K137=年度假设!$B$32=$L137*$M137—————————————
46522=IF($A138="","",CHOOSE(WEEKDAY(A138,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A138,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A138)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A138)),"")=IFERROR($D138*$C138*$E138/$F138,"")320=$H138*$G138=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A138)),"")=$J138=$I138*$K138=年度假设!$B$32=$L138*$M138—————————————
46523=IF($A139="","",CHOOSE(WEEKDAY(A139,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A139,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A139)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A139)),"")=IFERROR($D139*$C139*$E139/$F139,"")320=$H139*$G139=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A139)),"")=$J139=$I139*$K139=年度假设!$B$32=$L139*$M139—————————————
46524=IF($A140="","",CHOOSE(WEEKDAY(A140,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A140,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A140)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A140)),"")=IFERROR($D140*$C140*$E140/$F140,"")320=$H140*$G140=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A140)),"")=$J140=$I140*$K140=年度假设!$B$32=$L140*$M140—————————————
46525=IF($A141="","",CHOOSE(WEEKDAY(A141,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A141,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A141)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A141)),"")=IFERROR($D141*$C141*$E141/$F141,"")320=$H141*$G141=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A141)),"")=$J141=$I141*$K141=年度假设!$B$32=$L141*$M141—————————————
46526=IF($A142="","",CHOOSE(WEEKDAY(A142,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A142,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A142)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A142)),"")=IFERROR($D142*$C142*$E142/$F142,"")320=$H142*$G142=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A142)),"")=$J142=$I142*$K142=年度假设!$B$32=$L142*$M142—————————————
46527=IF($A143="","",CHOOSE(WEEKDAY(A143,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A143,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A143)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A143)),"")=IFERROR($D143*$C143*$E143/$F143,"")320=$H143*$G143=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A143)),"")=$J143=$I143*$K143=年度假设!$B$32=$L143*$M143—————————————
46528=IF($A144="","",CHOOSE(WEEKDAY(A144,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A144,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A144)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A144)),"")=IFERROR($D144*$C144*$E144/$F144,"")320=$H144*$G144=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A144)),"")=$J144=$I144*$K144=年度假设!$B$32=$L144*$M144—————————————
46529=IF($A145="","",CHOOSE(WEEKDAY(A145,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A145,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A145)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A145)),"")=IFERROR($D145*$C145*$E145/$F145,"")320=$H145*$G145=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A145)),"")=$J145=$I145*$K145=年度假设!$B$32=$L145*$M145—————————————
46530=IF($A146="","",CHOOSE(WEEKDAY(A146,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A146,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A146)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A146)),"")=IFERROR($D146*$C146*$E146/$F146,"")320=$H146*$G146=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A146)),"")=$J146=$I146*$K146=年度假设!$B$32=$L146*$M146—————————————
46531=IF($A147="","",CHOOSE(WEEKDAY(A147,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A147,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A147)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A147)),"")=IFERROR($D147*$C147*$E147/$F147,"")320=$H147*$G147=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A147)),"")=$J147=$I147*$K147=年度假设!$B$32=$L147*$M147—————————————
46532=IF($A148="","",CHOOSE(WEEKDAY(A148,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A148,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A148)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A148)),"")=IFERROR($D148*$C148*$E148/$F148,"")320=$H148*$G148=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A148)),"")=$J148=$I148*$K148=年度假设!$B$32=$L148*$M148—————————————
46533=IF($A149="","",CHOOSE(WEEKDAY(A149,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A149,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A149)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A149)),"")=IFERROR($D149*$C149*$E149/$F149,"")320=$H149*$G149=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A149)),"")=$J149=$I149*$K149=年度假设!$B$32=$L149*$M149—————————————
46534=IF($A150="","",CHOOSE(WEEKDAY(A150,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A150,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A150)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A150)),"")=IFERROR($D150*$C150*$E150/$F150,"")320=$H150*$G150=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A150)),"")=$J150=$I150*$K150=年度假设!$B$32=$L150*$M150—————————————
46535=IF($A151="","",CHOOSE(WEEKDAY(A151,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A151,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A151)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A151)),"")=IFERROR($D151*$C151*$E151/$F151,"")320=$H151*$G151=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A151)),"")=$J151=$I151*$K151=年度假设!$B$32=$L151*$M151—————————————
46536=IF($A152="","",CHOOSE(WEEKDAY(A152,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A152,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A152)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A152)),"")=IFERROR($D152*$C152*$E152/$F152,"")320=$H152*$G152=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A152)),"")=$J152=$I152*$K152=年度假设!$B$32=$L152*$M152—————————————
46537=IF($A153="","",CHOOSE(WEEKDAY(A153,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A153,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A153)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A153)),"")=IFERROR($D153*$C153*$E153/$F153,"")320=$H153*$G153=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A153)),"")=$J153=$I153*$K153=年度假设!$B$32=$L153*$M153—————————————
46538=IF($A154="","",CHOOSE(WEEKDAY(A154,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A154,2)),"")0.84=IFERROR(INDEX($U$4:$U$15,MONTH($A154)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A154)),"")=IFERROR($D154*$C154*$E154/$F154,"")320=$H154*$G154=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A154)),"")=$J154=$I154*$K154=年度假设!$B$32=$L154*$M154—————————————
46539=IF($A155="","",CHOOSE(WEEKDAY(A155,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A155,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A155)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A155)),"")=IFERROR($D155*$C155*$E155/$F155,"")320=$H155*$G155=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A155)),"")=$J155=$I155*$K155=年度假设!$B$32=$L155*$M155—————————————
46540=IF($A156="","",CHOOSE(WEEKDAY(A156,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A156,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A156)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A156)),"")=IFERROR($D156*$C156*$E156/$F156,"")320=$H156*$G156=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A156)),"")=$J156=$I156*$K156=年度假设!$B$32=$L156*$M156—————————————
46541=IF($A157="","",CHOOSE(WEEKDAY(A157,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A157,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A157)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A157)),"")=IFERROR($D157*$C157*$E157/$F157,"")320=$H157*$G157=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A157)),"")=$J157=$I157*$K157=年度假设!$B$32=$L157*$M157—————————————
46542=IF($A158="","",CHOOSE(WEEKDAY(A158,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A158,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A158)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A158)),"")=IFERROR($D158*$C158*$E158/$F158,"")320=$H158*$G158=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A158)),"")=$J158=$I158*$K158=年度假设!$B$32=$L158*$M158—————————————
46543=IF($A159="","",CHOOSE(WEEKDAY(A159,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A159,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A159)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A159)),"")=IFERROR($D159*$C159*$E159/$F159,"")320=$H159*$G159=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A159)),"")=$J159=$I159*$K159=年度假设!$B$32=$L159*$M159—————————————
46544=IF($A160="","",CHOOSE(WEEKDAY(A160,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A160,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A160)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A160)),"")=IFERROR($D160*$C160*$E160/$F160,"")320=$H160*$G160=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A160)),"")=$J160=$I160*$K160=年度假设!$B$32=$L160*$M160—————————————
46545=IF($A161="","",CHOOSE(WEEKDAY(A161,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A161,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A161)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A161)),"")=IFERROR($D161*$C161*$E161/$F161,"")320=$H161*$G161=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A161)),"")=$J161=$I161*$K161=年度假设!$B$32=$L161*$M161—————————————
46546=IF($A162="","",CHOOSE(WEEKDAY(A162,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A162,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A162)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A162)),"")=IFERROR($D162*$C162*$E162/$F162,"")320=$H162*$G162=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A162)),"")=$J162=$I162*$K162=年度假设!$B$32=$L162*$M162—————————————
46547=IF($A163="","",CHOOSE(WEEKDAY(A163,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A163,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A163)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A163)),"")=IFERROR($D163*$C163*$E163/$F163,"")320=$H163*$G163=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A163)),"")=$J163=$I163*$K163=年度假设!$B$32=$L163*$M163—————————————
46548=IF($A164="","",CHOOSE(WEEKDAY(A164,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A164,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A164)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A164)),"")=IFERROR($D164*$C164*$E164/$F164,"")320=$H164*$G164=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A164)),"")=$J164=$I164*$K164=年度假设!$B$32=$L164*$M164—————————————
46549=IF($A165="","",CHOOSE(WEEKDAY(A165,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A165,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A165)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A165)),"")=IFERROR($D165*$C165*$E165/$F165,"")320=$H165*$G165=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A165)),"")=$J165=$I165*$K165=年度假设!$B$32=$L165*$M165—————————————
46550=IF($A166="","",CHOOSE(WEEKDAY(A166,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A166,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A166)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A166)),"")=IFERROR($D166*$C166*$E166/$F166,"")320=$H166*$G166=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A166)),"")=$J166=$I166*$K166=年度假设!$B$32=$L166*$M166—————————————
46551=IF($A167="","",CHOOSE(WEEKDAY(A167,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A167,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A167)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A167)),"")=IFERROR($D167*$C167*$E167/$F167,"")320=$H167*$G167=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A167)),"")=$J167=$I167*$K167=年度假设!$B$32=$L167*$M167—————————————
46552=IF($A168="","",CHOOSE(WEEKDAY(A168,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A168,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A168)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A168)),"")=IFERROR($D168*$C168*$E168/$F168,"")320=$H168*$G168=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A168)),"")=$J168=$I168*$K168=年度假设!$B$32=$L168*$M168—————————————
46553=IF($A169="","",CHOOSE(WEEKDAY(A169,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A169,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A169)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A169)),"")=IFERROR($D169*$C169*$E169/$F169,"")320=$H169*$G169=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A169)),"")=$J169=$I169*$K169=年度假设!$B$32=$L169*$M169—————————————
46554=IF($A170="","",CHOOSE(WEEKDAY(A170,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A170,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A170)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A170)),"")=IFERROR($D170*$C170*$E170/$F170,"")320=$H170*$G170=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A170)),"")=$J170=$I170*$K170=年度假设!$B$32=$L170*$M170—————————————
46555=IF($A171="","",CHOOSE(WEEKDAY(A171,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A171,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A171)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A171)),"")=IFERROR($D171*$C171*$E171/$F171,"")320=$H171*$G171=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A171)),"")=$J171=$I171*$K171=年度假设!$B$32=$L171*$M171—————————————
46556=IF($A172="","",CHOOSE(WEEKDAY(A172,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A172,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A172)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A172)),"")=IFERROR($D172*$C172*$E172/$F172,"")320=$H172*$G172=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A172)),"")=$J172=$I172*$K172=年度假设!$B$32=$L172*$M172—————————————
46557=IF($A173="","",CHOOSE(WEEKDAY(A173,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A173,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A173)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A173)),"")=IFERROR($D173*$C173*$E173/$F173,"")320=$H173*$G173=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A173)),"")=$J173=$I173*$K173=年度假设!$B$32=$L173*$M173—————————————
46558=IF($A174="","",CHOOSE(WEEKDAY(A174,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A174,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A174)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A174)),"")=IFERROR($D174*$C174*$E174/$F174,"")320=$H174*$G174=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A174)),"")=$J174=$I174*$K174=年度假设!$B$32=$L174*$M174—————————————
46559=IF($A175="","",CHOOSE(WEEKDAY(A175,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A175,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A175)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A175)),"")=IFERROR($D175*$C175*$E175/$F175,"")320=$H175*$G175=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A175)),"")=$J175=$I175*$K175=年度假设!$B$32=$L175*$M175—————————————
46560=IF($A176="","",CHOOSE(WEEKDAY(A176,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A176,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A176)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A176)),"")=IFERROR($D176*$C176*$E176/$F176,"")320=$H176*$G176=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A176)),"")=$J176=$I176*$K176=年度假设!$B$32=$L176*$M176—————————————
46561=IF($A177="","",CHOOSE(WEEKDAY(A177,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A177,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A177)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A177)),"")=IFERROR($D177*$C177*$E177/$F177,"")320=$H177*$G177=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A177)),"")=$J177=$I177*$K177=年度假设!$B$32=$L177*$M177—————————————
46562=IF($A178="","",CHOOSE(WEEKDAY(A178,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A178,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A178)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A178)),"")=IFERROR($D178*$C178*$E178/$F178,"")320=$H178*$G178=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A178)),"")=$J178=$I178*$K178=年度假设!$B$32=$L178*$M178—————————————
46563=IF($A179="","",CHOOSE(WEEKDAY(A179,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A179,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A179)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A179)),"")=IFERROR($D179*$C179*$E179/$F179,"")320=$H179*$G179=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A179)),"")=$J179=$I179*$K179=年度假设!$B$32=$L179*$M179—————————————
46564=IF($A180="","",CHOOSE(WEEKDAY(A180,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A180,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A180)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A180)),"")=IFERROR($D180*$C180*$E180/$F180,"")320=$H180*$G180=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A180)),"")=$J180=$I180*$K180=年度假设!$B$32=$L180*$M180—————————————
46565=IF($A181="","",CHOOSE(WEEKDAY(A181,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A181,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A181)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A181)),"")=IFERROR($D181*$C181*$E181/$F181,"")320=$H181*$G181=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A181)),"")=$J181=$I181*$K181=年度假设!$B$32=$L181*$M181—————————————
46566=IF($A182="","",CHOOSE(WEEKDAY(A182,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A182,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A182)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A182)),"")=IFERROR($D182*$C182*$E182/$F182,"")320=$H182*$G182=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A182)),"")=$J182=$I182*$K182=年度假设!$B$32=$L182*$M182—————————————
46567=IF($A183="","",CHOOSE(WEEKDAY(A183,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A183,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A183)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A183)),"")=IFERROR($D183*$C183*$E183/$F183,"")320=$H183*$G183=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A183)),"")=$J183=$I183*$K183=年度假设!$B$32=$L183*$M183—————————————
46568=IF($A184="","",CHOOSE(WEEKDAY(A184,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A184,2)),"")0.76=IFERROR(INDEX($U$4:$U$15,MONTH($A184)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A184)),"")=IFERROR($D184*$C184*$E184/$F184,"")320=$H184*$G184=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A184)),"")=$J184=$I184*$K184=年度假设!$B$32=$L184*$M184—————————————
46569=IF($A185="","",CHOOSE(WEEKDAY(A185,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A185,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A185)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A185)),"")=IFERROR($D185*$C185*$E185/$F185,"")320=$H185*$G185=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A185)),"")=$J185=$I185*$K185=年度假设!$B$32=$L185*$M185—————————————
46570=IF($A186="","",CHOOSE(WEEKDAY(A186,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A186,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A186)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A186)),"")=IFERROR($D186*$C186*$E186/$F186,"")320=$H186*$G186=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A186)),"")=$J186=$I186*$K186=年度假设!$B$32=$L186*$M186—————————————
46571=IF($A187="","",CHOOSE(WEEKDAY(A187,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A187,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A187)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A187)),"")=IFERROR($D187*$C187*$E187/$F187,"")320=$H187*$G187=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A187)),"")=$J187=$I187*$K187=年度假设!$B$32=$L187*$M187—————————————
46572=IF($A188="","",CHOOSE(WEEKDAY(A188,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A188,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A188)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A188)),"")=IFERROR($D188*$C188*$E188/$F188,"")320=$H188*$G188=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A188)),"")=$J188=$I188*$K188=年度假设!$B$32=$L188*$M188—————————————
46573=IF($A189="","",CHOOSE(WEEKDAY(A189,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A189,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A189)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A189)),"")=IFERROR($D189*$C189*$E189/$F189,"")320=$H189*$G189=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A189)),"")=$J189=$I189*$K189=年度假设!$B$32=$L189*$M189—————————————
46574=IF($A190="","",CHOOSE(WEEKDAY(A190,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A190,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A190)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A190)),"")=IFERROR($D190*$C190*$E190/$F190,"")320=$H190*$G190=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A190)),"")=$J190=$I190*$K190=年度假设!$B$32=$L190*$M190—————————————
46575=IF($A191="","",CHOOSE(WEEKDAY(A191,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A191,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A191)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A191)),"")=IFERROR($D191*$C191*$E191/$F191,"")320=$H191*$G191=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A191)),"")=$J191=$I191*$K191=年度假设!$B$32=$L191*$M191—————————————
46576=IF($A192="","",CHOOSE(WEEKDAY(A192,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A192,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A192)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A192)),"")=IFERROR($D192*$C192*$E192/$F192,"")320=$H192*$G192=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A192)),"")=$J192=$I192*$K192=年度假设!$B$32=$L192*$M192—————————————
46577=IF($A193="","",CHOOSE(WEEKDAY(A193,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A193,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A193)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A193)),"")=IFERROR($D193*$C193*$E193/$F193,"")320=$H193*$G193=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A193)),"")=$J193=$I193*$K193=年度假设!$B$32=$L193*$M193—————————————
46578=IF($A194="","",CHOOSE(WEEKDAY(A194,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A194,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A194)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A194)),"")=IFERROR($D194*$C194*$E194/$F194,"")320=$H194*$G194=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A194)),"")=$J194=$I194*$K194=年度假设!$B$32=$L194*$M194—————————————
46579=IF($A195="","",CHOOSE(WEEKDAY(A195,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A195,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A195)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A195)),"")=IFERROR($D195*$C195*$E195/$F195,"")320=$H195*$G195=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A195)),"")=$J195=$I195*$K195=年度假设!$B$32=$L195*$M195—————————————
46580=IF($A196="","",CHOOSE(WEEKDAY(A196,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A196,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A196)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A196)),"")=IFERROR($D196*$C196*$E196/$F196,"")320=$H196*$G196=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A196)),"")=$J196=$I196*$K196=年度假设!$B$32=$L196*$M196—————————————
46581=IF($A197="","",CHOOSE(WEEKDAY(A197,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A197,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A197)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A197)),"")=IFERROR($D197*$C197*$E197/$F197,"")320=$H197*$G197=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A197)),"")=$J197=$I197*$K197=年度假设!$B$32=$L197*$M197—————————————
46582=IF($A198="","",CHOOSE(WEEKDAY(A198,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A198,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A198)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A198)),"")=IFERROR($D198*$C198*$E198/$F198,"")320=$H198*$G198=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A198)),"")=$J198=$I198*$K198=年度假设!$B$32=$L198*$M198—————————————
46583=IF($A199="","",CHOOSE(WEEKDAY(A199,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A199,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A199)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A199)),"")=IFERROR($D199*$C199*$E199/$F199,"")320=$H199*$G199=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A199)),"")=$J199=$I199*$K199=年度假设!$B$32=$L199*$M199—————————————
46584=IF($A200="","",CHOOSE(WEEKDAY(A200,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A200,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A200)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A200)),"")=IFERROR($D200*$C200*$E200/$F200,"")320=$H200*$G200=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A200)),"")=$J200=$I200*$K200=年度假设!$B$32=$L200*$M200—————————————
46585=IF($A201="","",CHOOSE(WEEKDAY(A201,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A201,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A201)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A201)),"")=IFERROR($D201*$C201*$E201/$F201,"")320=$H201*$G201=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A201)),"")=$J201=$I201*$K201=年度假设!$B$32=$L201*$M201—————————————
46586=IF($A202="","",CHOOSE(WEEKDAY(A202,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A202,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A202)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A202)),"")=IFERROR($D202*$C202*$E202/$F202,"")320=$H202*$G202=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A202)),"")=$J202=$I202*$K202=年度假设!$B$32=$L202*$M202—————————————
46587=IF($A203="","",CHOOSE(WEEKDAY(A203,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A203,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A203)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A203)),"")=IFERROR($D203*$C203*$E203/$F203,"")320=$H203*$G203=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A203)),"")=$J203=$I203*$K203=年度假设!$B$32=$L203*$M203—————————————
46588=IF($A204="","",CHOOSE(WEEKDAY(A204,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A204,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A204)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A204)),"")=IFERROR($D204*$C204*$E204/$F204,"")320=$H204*$G204=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A204)),"")=$J204=$I204*$K204=年度假设!$B$32=$L204*$M204—————————————
46589=IF($A205="","",CHOOSE(WEEKDAY(A205,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A205,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A205)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A205)),"")=IFERROR($D205*$C205*$E205/$F205,"")320=$H205*$G205=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A205)),"")=$J205=$I205*$K205=年度假设!$B$32=$L205*$M205—————————————
46590=IF($A206="","",CHOOSE(WEEKDAY(A206,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A206,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A206)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A206)),"")=IFERROR($D206*$C206*$E206/$F206,"")320=$H206*$G206=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A206)),"")=$J206=$I206*$K206=年度假设!$B$32=$L206*$M206—————————————
46591=IF($A207="","",CHOOSE(WEEKDAY(A207,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A207,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A207)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A207)),"")=IFERROR($D207*$C207*$E207/$F207,"")320=$H207*$G207=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A207)),"")=$J207=$I207*$K207=年度假设!$B$32=$L207*$M207—————————————
46592=IF($A208="","",CHOOSE(WEEKDAY(A208,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A208,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A208)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A208)),"")=IFERROR($D208*$C208*$E208/$F208,"")320=$H208*$G208=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A208)),"")=$J208=$I208*$K208=年度假设!$B$32=$L208*$M208—————————————
46593=IF($A209="","",CHOOSE(WEEKDAY(A209,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A209,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A209)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A209)),"")=IFERROR($D209*$C209*$E209/$F209,"")320=$H209*$G209=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A209)),"")=$J209=$I209*$K209=年度假设!$B$32=$L209*$M209—————————————
46594=IF($A210="","",CHOOSE(WEEKDAY(A210,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A210,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A210)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A210)),"")=IFERROR($D210*$C210*$E210/$F210,"")320=$H210*$G210=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A210)),"")=$J210=$I210*$K210=年度假设!$B$32=$L210*$M210—————————————
46595=IF($A211="","",CHOOSE(WEEKDAY(A211,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A211,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A211)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A211)),"")=IFERROR($D211*$C211*$E211/$F211,"")320=$H211*$G211=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A211)),"")=$J211=$I211*$K211=年度假设!$B$32=$L211*$M211—————————————
46596=IF($A212="","",CHOOSE(WEEKDAY(A212,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A212,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A212)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A212)),"")=IFERROR($D212*$C212*$E212/$F212,"")320=$H212*$G212=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A212)),"")=$J212=$I212*$K212=年度假设!$B$32=$L212*$M212—————————————
46597=IF($A213="","",CHOOSE(WEEKDAY(A213,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A213,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A213)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A213)),"")=IFERROR($D213*$C213*$E213/$F213,"")320=$H213*$G213=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A213)),"")=$J213=$I213*$K213=年度假设!$B$32=$L213*$M213—————————————
46598=IF($A214="","",CHOOSE(WEEKDAY(A214,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A214,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A214)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A214)),"")=IFERROR($D214*$C214*$E214/$F214,"")320=$H214*$G214=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A214)),"")=$J214=$I214*$K214=年度假设!$B$32=$L214*$M214—————————————
46599=IF($A215="","",CHOOSE(WEEKDAY(A215,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A215,2)),"")0.7=IFERROR(INDEX($U$4:$U$15,MONTH($A215)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A215)),"")=IFERROR($D215*$C215*$E215/$F215,"")320=$H215*$G215=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A215)),"")=$J215=$I215*$K215=年度假设!$B$32=$L215*$M215—————————————
46600=IF($A216="","",CHOOSE(WEEKDAY(A216,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A216,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A216)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A216)),"")=IFERROR($D216*$C216*$E216/$F216,"")320=$H216*$G216=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A216)),"")=$J216=$I216*$K216=年度假设!$B$32=$L216*$M216—————————————
46601=IF($A217="","",CHOOSE(WEEKDAY(A217,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A217,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A217)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A217)),"")=IFERROR($D217*$C217*$E217/$F217,"")320=$H217*$G217=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A217)),"")=$J217=$I217*$K217=年度假设!$B$32=$L217*$M217—————————————
46602=IF($A218="","",CHOOSE(WEEKDAY(A218,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A218,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A218)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A218)),"")=IFERROR($D218*$C218*$E218/$F218,"")320=$H218*$G218=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A218)),"")=$J218=$I218*$K218=年度假设!$B$32=$L218*$M218—————————————
46603=IF($A219="","",CHOOSE(WEEKDAY(A219,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A219,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A219)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A219)),"")=IFERROR($D219*$C219*$E219/$F219,"")320=$H219*$G219=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A219)),"")=$J219=$I219*$K219=年度假设!$B$32=$L219*$M219—————————————
46604=IF($A220="","",CHOOSE(WEEKDAY(A220,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A220,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A220)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A220)),"")=IFERROR($D220*$C220*$E220/$F220,"")320=$H220*$G220=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A220)),"")=$J220=$I220*$K220=年度假设!$B$32=$L220*$M220—————————————
46605=IF($A221="","",CHOOSE(WEEKDAY(A221,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A221,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A221)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A221)),"")=IFERROR($D221*$C221*$E221/$F221,"")320=$H221*$G221=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A221)),"")=$J221=$I221*$K221=年度假设!$B$32=$L221*$M221—————————————
46606=IF($A222="","",CHOOSE(WEEKDAY(A222,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A222,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A222)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A222)),"")=IFERROR($D222*$C222*$E222/$F222,"")320=$H222*$G222=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A222)),"")=$J222=$I222*$K222=年度假设!$B$32=$L222*$M222—————————————
46607=IF($A223="","",CHOOSE(WEEKDAY(A223,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A223,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A223)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A223)),"")=IFERROR($D223*$C223*$E223/$F223,"")320=$H223*$G223=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A223)),"")=$J223=$I223*$K223=年度假设!$B$32=$L223*$M223—————————————
46608=IF($A224="","",CHOOSE(WEEKDAY(A224,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A224,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A224)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A224)),"")=IFERROR($D224*$C224*$E224/$F224,"")320=$H224*$G224=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A224)),"")=$J224=$I224*$K224=年度假设!$B$32=$L224*$M224—————————————
46609=IF($A225="","",CHOOSE(WEEKDAY(A225,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A225,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A225)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A225)),"")=IFERROR($D225*$C225*$E225/$F225,"")320=$H225*$G225=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A225)),"")=$J225=$I225*$K225=年度假设!$B$32=$L225*$M225—————————————
46610=IF($A226="","",CHOOSE(WEEKDAY(A226,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A226,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A226)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A226)),"")=IFERROR($D226*$C226*$E226/$F226,"")320=$H226*$G226=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A226)),"")=$J226=$I226*$K226=年度假设!$B$32=$L226*$M226—————————————
46611=IF($A227="","",CHOOSE(WEEKDAY(A227,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A227,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A227)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A227)),"")=IFERROR($D227*$C227*$E227/$F227,"")320=$H227*$G227=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A227)),"")=$J227=$I227*$K227=年度假设!$B$32=$L227*$M227—————————————
46612=IF($A228="","",CHOOSE(WEEKDAY(A228,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A228,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A228)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A228)),"")=IFERROR($D228*$C228*$E228/$F228,"")320=$H228*$G228=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A228)),"")=$J228=$I228*$K228=年度假设!$B$32=$L228*$M228—————————————
46613=IF($A229="","",CHOOSE(WEEKDAY(A229,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A229,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A229)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A229)),"")=IFERROR($D229*$C229*$E229/$F229,"")320=$H229*$G229=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A229)),"")=$J229=$I229*$K229=年度假设!$B$32=$L229*$M229—————————————
46614=IF($A230="","",CHOOSE(WEEKDAY(A230,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A230,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A230)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A230)),"")=IFERROR($D230*$C230*$E230/$F230,"")320=$H230*$G230=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A230)),"")=$J230=$I230*$K230=年度假设!$B$32=$L230*$M230—————————————
46615=IF($A231="","",CHOOSE(WEEKDAY(A231,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A231,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A231)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A231)),"")=IFERROR($D231*$C231*$E231/$F231,"")320=$H231*$G231=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A231)),"")=$J231=$I231*$K231=年度假设!$B$32=$L231*$M231—————————————
46616=IF($A232="","",CHOOSE(WEEKDAY(A232,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A232,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A232)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A232)),"")=IFERROR($D232*$C232*$E232/$F232,"")320=$H232*$G232=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A232)),"")=$J232=$I232*$K232=年度假设!$B$32=$L232*$M232—————————————
46617=IF($A233="","",CHOOSE(WEEKDAY(A233,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A233,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A233)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A233)),"")=IFERROR($D233*$C233*$E233/$F233,"")320=$H233*$G233=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A233)),"")=$J233=$I233*$K233=年度假设!$B$32=$L233*$M233—————————————
46618=IF($A234="","",CHOOSE(WEEKDAY(A234,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A234,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A234)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A234)),"")=IFERROR($D234*$C234*$E234/$F234,"")320=$H234*$G234=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A234)),"")=$J234=$I234*$K234=年度假设!$B$32=$L234*$M234—————————————
46619=IF($A235="","",CHOOSE(WEEKDAY(A235,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A235,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A235)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A235)),"")=IFERROR($D235*$C235*$E235/$F235,"")320=$H235*$G235=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A235)),"")=$J235=$I235*$K235=年度假设!$B$32=$L235*$M235—————————————
46620=IF($A236="","",CHOOSE(WEEKDAY(A236,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A236,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A236)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A236)),"")=IFERROR($D236*$C236*$E236/$F236,"")320=$H236*$G236=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A236)),"")=$J236=$I236*$K236=年度假设!$B$32=$L236*$M236—————————————
46621=IF($A237="","",CHOOSE(WEEKDAY(A237,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A237,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A237)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A237)),"")=IFERROR($D237*$C237*$E237/$F237,"")320=$H237*$G237=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A237)),"")=$J237=$I237*$K237=年度假设!$B$32=$L237*$M237—————————————
46622=IF($A238="","",CHOOSE(WEEKDAY(A238,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A238,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A238)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A238)),"")=IFERROR($D238*$C238*$E238/$F238,"")320=$H238*$G238=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A238)),"")=$J238=$I238*$K238=年度假设!$B$32=$L238*$M238—————————————
46623=IF($A239="","",CHOOSE(WEEKDAY(A239,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A239,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A239)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A239)),"")=IFERROR($D239*$C239*$E239/$F239,"")320=$H239*$G239=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A239)),"")=$J239=$I239*$K239=年度假设!$B$32=$L239*$M239—————————————
46624=IF($A240="","",CHOOSE(WEEKDAY(A240,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A240,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A240)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A240)),"")=IFERROR($D240*$C240*$E240/$F240,"")320=$H240*$G240=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A240)),"")=$J240=$I240*$K240=年度假设!$B$32=$L240*$M240—————————————
46625=IF($A241="","",CHOOSE(WEEKDAY(A241,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A241,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A241)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A241)),"")=IFERROR($D241*$C241*$E241/$F241,"")320=$H241*$G241=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A241)),"")=$J241=$I241*$K241=年度假设!$B$32=$L241*$M241—————————————
46626=IF($A242="","",CHOOSE(WEEKDAY(A242,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A242,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A242)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A242)),"")=IFERROR($D242*$C242*$E242/$F242,"")320=$H242*$G242=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A242)),"")=$J242=$I242*$K242=年度假设!$B$32=$L242*$M242—————————————
46627=IF($A243="","",CHOOSE(WEEKDAY(A243,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A243,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A243)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A243)),"")=IFERROR($D243*$C243*$E243/$F243,"")320=$H243*$G243=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A243)),"")=$J243=$I243*$K243=年度假设!$B$32=$L243*$M243—————————————
46628=IF($A244="","",CHOOSE(WEEKDAY(A244,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A244,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A244)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A244)),"")=IFERROR($D244*$C244*$E244/$F244,"")320=$H244*$G244=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A244)),"")=$J244=$I244*$K244=年度假设!$B$32=$L244*$M244—————————————
46629=IF($A245="","",CHOOSE(WEEKDAY(A245,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A245,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A245)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A245)),"")=IFERROR($D245*$C245*$E245/$F245,"")320=$H245*$G245=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A245)),"")=$J245=$I245*$K245=年度假设!$B$32=$L245*$M245—————————————
46630=IF($A246="","",CHOOSE(WEEKDAY(A246,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A246,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A246)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A246)),"")=IFERROR($D246*$C246*$E246/$F246,"")320=$H246*$G246=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A246)),"")=$J246=$I246*$K246=年度假设!$B$32=$L246*$M246—————————————
46631=IF($A247="","",CHOOSE(WEEKDAY(A247,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A247,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A247)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A247)),"")=IFERROR($D247*$C247*$E247/$F247,"")320=$H247*$G247=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A247)),"")=$J247=$I247*$K247=年度假设!$B$32=$L247*$M247—————————————
46632=IF($A248="","",CHOOSE(WEEKDAY(A248,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A248,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A248)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A248)),"")=IFERROR($D248*$C248*$E248/$F248,"")320=$H248*$G248=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A248)),"")=$J248=$I248*$K248=年度假设!$B$32=$L248*$M248—————————————
46633=IF($A249="","",CHOOSE(WEEKDAY(A249,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A249,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A249)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A249)),"")=IFERROR($D249*$C249*$E249/$F249,"")320=$H249*$G249=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A249)),"")=$J249=$I249*$K249=年度假设!$B$32=$L249*$M249—————————————
46634=IF($A250="","",CHOOSE(WEEKDAY(A250,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A250,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A250)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A250)),"")=IFERROR($D250*$C250*$E250/$F250,"")320=$H250*$G250=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A250)),"")=$J250=$I250*$K250=年度假设!$B$32=$L250*$M250—————————————
46635=IF($A251="","",CHOOSE(WEEKDAY(A251,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A251,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A251)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A251)),"")=IFERROR($D251*$C251*$E251/$F251,"")320=$H251*$G251=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A251)),"")=$J251=$I251*$K251=年度假设!$B$32=$L251*$M251—————————————
46636=IF($A252="","",CHOOSE(WEEKDAY(A252,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A252,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A252)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A252)),"")=IFERROR($D252*$C252*$E252/$F252,"")320=$H252*$G252=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A252)),"")=$J252=$I252*$K252=年度假设!$B$32=$L252*$M252—————————————
46637=IF($A253="","",CHOOSE(WEEKDAY(A253,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A253,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A253)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A253)),"")=IFERROR($D253*$C253*$E253/$F253,"")320=$H253*$G253=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A253)),"")=$J253=$I253*$K253=年度假设!$B$32=$L253*$M253—————————————
46638=IF($A254="","",CHOOSE(WEEKDAY(A254,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A254,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A254)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A254)),"")=IFERROR($D254*$C254*$E254/$F254,"")320=$H254*$G254=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A254)),"")=$J254=$I254*$K254=年度假设!$B$32=$L254*$M254—————————————
46639=IF($A255="","",CHOOSE(WEEKDAY(A255,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A255,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A255)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A255)),"")=IFERROR($D255*$C255*$E255/$F255,"")320=$H255*$G255=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A255)),"")=$J255=$I255*$K255=年度假设!$B$32=$L255*$M255—————————————
46640=IF($A256="","",CHOOSE(WEEKDAY(A256,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A256,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A256)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A256)),"")=IFERROR($D256*$C256*$E256/$F256,"")320=$H256*$G256=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A256)),"")=$J256=$I256*$K256=年度假设!$B$32=$L256*$M256—————————————
46641=IF($A257="","",CHOOSE(WEEKDAY(A257,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A257,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A257)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A257)),"")=IFERROR($D257*$C257*$E257/$F257,"")320=$H257*$G257=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A257)),"")=$J257=$I257*$K257=年度假设!$B$32=$L257*$M257—————————————
46642=IF($A258="","",CHOOSE(WEEKDAY(A258,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A258,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A258)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A258)),"")=IFERROR($D258*$C258*$E258/$F258,"")320=$H258*$G258=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A258)),"")=$J258=$I258*$K258=年度假设!$B$32=$L258*$M258—————————————
46643=IF($A259="","",CHOOSE(WEEKDAY(A259,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A259,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A259)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A259)),"")=IFERROR($D259*$C259*$E259/$F259,"")320=$H259*$G259=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A259)),"")=$J259=$I259*$K259=年度假设!$B$32=$L259*$M259—————————————
46644=IF($A260="","",CHOOSE(WEEKDAY(A260,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A260,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A260)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A260)),"")=IFERROR($D260*$C260*$E260/$F260,"")320=$H260*$G260=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A260)),"")=$J260=$I260*$K260=年度假设!$B$32=$L260*$M260—————————————
46645=IF($A261="","",CHOOSE(WEEKDAY(A261,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A261,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A261)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A261)),"")=IFERROR($D261*$C261*$E261/$F261,"")320=$H261*$G261=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A261)),"")=$J261=$I261*$K261=年度假设!$B$32=$L261*$M261—————————————
46646=IF($A262="","",CHOOSE(WEEKDAY(A262,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A262,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A262)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A262)),"")=IFERROR($D262*$C262*$E262/$F262,"")320=$H262*$G262=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A262)),"")=$J262=$I262*$K262=年度假设!$B$32=$L262*$M262—————————————
46647=IF($A263="","",CHOOSE(WEEKDAY(A263,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A263,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A263)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A263)),"")=IFERROR($D263*$C263*$E263/$F263,"")320=$H263*$G263=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A263)),"")=$J263=$I263*$K263=年度假设!$B$32=$L263*$M263—————————————
46648=IF($A264="","",CHOOSE(WEEKDAY(A264,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A264,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A264)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A264)),"")=IFERROR($D264*$C264*$E264/$F264,"")320=$H264*$G264=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A264)),"")=$J264=$I264*$K264=年度假设!$B$32=$L264*$M264—————————————
46649=IF($A265="","",CHOOSE(WEEKDAY(A265,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A265,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A265)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A265)),"")=IFERROR($D265*$C265*$E265/$F265,"")320=$H265*$G265=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A265)),"")=$J265=$I265*$K265=年度假设!$B$32=$L265*$M265—————————————
46650=IF($A266="","",CHOOSE(WEEKDAY(A266,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A266,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A266)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A266)),"")=IFERROR($D266*$C266*$E266/$F266,"")320=$H266*$G266=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A266)),"")=$J266=$I266*$K266=年度假设!$B$32=$L266*$M266—————————————
46651=IF($A267="","",CHOOSE(WEEKDAY(A267,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A267,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A267)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A267)),"")=IFERROR($D267*$C267*$E267/$F267,"")320=$H267*$G267=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A267)),"")=$J267=$I267*$K267=年度假设!$B$32=$L267*$M267—————————————
46652=IF($A268="","",CHOOSE(WEEKDAY(A268,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A268,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A268)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A268)),"")=IFERROR($D268*$C268*$E268/$F268,"")320=$H268*$G268=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A268)),"")=$J268=$I268*$K268=年度假设!$B$32=$L268*$M268—————————————
46653=IF($A269="","",CHOOSE(WEEKDAY(A269,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A269,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A269)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A269)),"")=IFERROR($D269*$C269*$E269/$F269,"")320=$H269*$G269=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A269)),"")=$J269=$I269*$K269=年度假设!$B$32=$L269*$M269—————————————
46654=IF($A270="","",CHOOSE(WEEKDAY(A270,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A270,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A270)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A270)),"")=IFERROR($D270*$C270*$E270/$F270,"")320=$H270*$G270=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A270)),"")=$J270=$I270*$K270=年度假设!$B$32=$L270*$M270—————————————
46655=IF($A271="","",CHOOSE(WEEKDAY(A271,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A271,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A271)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A271)),"")=IFERROR($D271*$C271*$E271/$F271,"")320=$H271*$G271=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A271)),"")=$J271=$I271*$K271=年度假设!$B$32=$L271*$M271—————————————
46656=IF($A272="","",CHOOSE(WEEKDAY(A272,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A272,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A272)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A272)),"")=IFERROR($D272*$C272*$E272/$F272,"")320=$H272*$G272=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A272)),"")=$J272=$I272*$K272=年度假设!$B$32=$L272*$M272—————————————
46657=IF($A273="","",CHOOSE(WEEKDAY(A273,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A273,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A273)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A273)),"")=IFERROR($D273*$C273*$E273/$F273,"")320=$H273*$G273=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A273)),"")=$J273=$I273*$K273=年度假设!$B$32=$L273*$M273—————————————
46658=IF($A274="","",CHOOSE(WEEKDAY(A274,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A274,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A274)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A274)),"")=IFERROR($D274*$C274*$E274/$F274,"")320=$H274*$G274=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A274)),"")=$J274=$I274*$K274=年度假设!$B$32=$L274*$M274—————————————
46659=IF($A275="","",CHOOSE(WEEKDAY(A275,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A275,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A275)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A275)),"")=IFERROR($D275*$C275*$E275/$F275,"")320=$H275*$G275=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A275)),"")=$J275=$I275*$K275=年度假设!$B$32=$L275*$M275—————————————
46660=IF($A276="","",CHOOSE(WEEKDAY(A276,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A276,2)),"")0.83=IFERROR(INDEX($U$4:$U$15,MONTH($A276)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A276)),"")=IFERROR($D276*$C276*$E276/$F276,"")320=$H276*$G276=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A276)),"")=$J276=$I276*$K276=年度假设!$B$32=$L276*$M276—————————————
46661=IF($A277="","",CHOOSE(WEEKDAY(A277,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A277,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A277)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A277)),"")=IFERROR($D277*$C277*$E277/$F277,"")320=$H277*$G277=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A277)),"")=$J277=$I277*$K277=年度假设!$B$32=$L277*$M277—————————————
46662=IF($A278="","",CHOOSE(WEEKDAY(A278,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A278,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A278)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A278)),"")=IFERROR($D278*$C278*$E278/$F278,"")320=$H278*$G278=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A278)),"")=$J278=$I278*$K278=年度假设!$B$32=$L278*$M278—————————————
46663=IF($A279="","",CHOOSE(WEEKDAY(A279,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A279,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A279)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A279)),"")=IFERROR($D279*$C279*$E279/$F279,"")320=$H279*$G279=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A279)),"")=$J279=$I279*$K279=年度假设!$B$32=$L279*$M279—————————————
46664=IF($A280="","",CHOOSE(WEEKDAY(A280,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A280,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A280)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A280)),"")=IFERROR($D280*$C280*$E280/$F280,"")320=$H280*$G280=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A280)),"")=$J280=$I280*$K280=年度假设!$B$32=$L280*$M280—————————————
46665=IF($A281="","",CHOOSE(WEEKDAY(A281,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A281,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A281)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A281)),"")=IFERROR($D281*$C281*$E281/$F281,"")320=$H281*$G281=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A281)),"")=$J281=$I281*$K281=年度假设!$B$32=$L281*$M281—————————————
46666=IF($A282="","",CHOOSE(WEEKDAY(A282,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A282,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A282)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A282)),"")=IFERROR($D282*$C282*$E282/$F282,"")320=$H282*$G282=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A282)),"")=$J282=$I282*$K282=年度假设!$B$32=$L282*$M282—————————————
46667=IF($A283="","",CHOOSE(WEEKDAY(A283,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A283,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A283)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A283)),"")=IFERROR($D283*$C283*$E283/$F283,"")320=$H283*$G283=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A283)),"")=$J283=$I283*$K283=年度假设!$B$32=$L283*$M283—————————————
46668=IF($A284="","",CHOOSE(WEEKDAY(A284,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A284,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A284)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A284)),"")=IFERROR($D284*$C284*$E284/$F284,"")320=$H284*$G284=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A284)),"")=$J284=$I284*$K284=年度假设!$B$32=$L284*$M284—————————————
46669=IF($A285="","",CHOOSE(WEEKDAY(A285,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A285,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A285)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A285)),"")=IFERROR($D285*$C285*$E285/$F285,"")320=$H285*$G285=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A285)),"")=$J285=$I285*$K285=年度假设!$B$32=$L285*$M285—————————————
46670=IF($A286="","",CHOOSE(WEEKDAY(A286,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A286,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A286)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A286)),"")=IFERROR($D286*$C286*$E286/$F286,"")320=$H286*$G286=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A286)),"")=$J286=$I286*$K286=年度假设!$B$32=$L286*$M286—————————————
46671=IF($A287="","",CHOOSE(WEEKDAY(A287,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A287,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A287)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A287)),"")=IFERROR($D287*$C287*$E287/$F287,"")320=$H287*$G287=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A287)),"")=$J287=$I287*$K287=年度假设!$B$32=$L287*$M287—————————————
46672=IF($A288="","",CHOOSE(WEEKDAY(A288,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A288,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A288)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A288)),"")=IFERROR($D288*$C288*$E288/$F288,"")320=$H288*$G288=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A288)),"")=$J288=$I288*$K288=年度假设!$B$32=$L288*$M288—————————————
46673=IF($A289="","",CHOOSE(WEEKDAY(A289,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A289,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A289)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A289)),"")=IFERROR($D289*$C289*$E289/$F289,"")320=$H289*$G289=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A289)),"")=$J289=$I289*$K289=年度假设!$B$32=$L289*$M289—————————————
46674=IF($A290="","",CHOOSE(WEEKDAY(A290,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A290,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A290)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A290)),"")=IFERROR($D290*$C290*$E290/$F290,"")320=$H290*$G290=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A290)),"")=$J290=$I290*$K290=年度假设!$B$32=$L290*$M290—————————————
46675=IF($A291="","",CHOOSE(WEEKDAY(A291,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A291,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A291)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A291)),"")=IFERROR($D291*$C291*$E291/$F291,"")320=$H291*$G291=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A291)),"")=$J291=$I291*$K291=年度假设!$B$32=$L291*$M291—————————————
46676=IF($A292="","",CHOOSE(WEEKDAY(A292,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A292,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A292)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A292)),"")=IFERROR($D292*$C292*$E292/$F292,"")320=$H292*$G292=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A292)),"")=$J292=$I292*$K292=年度假设!$B$32=$L292*$M292—————————————
46677=IF($A293="","",CHOOSE(WEEKDAY(A293,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A293,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A293)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A293)),"")=IFERROR($D293*$C293*$E293/$F293,"")320=$H293*$G293=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A293)),"")=$J293=$I293*$K293=年度假设!$B$32=$L293*$M293—————————————
46678=IF($A294="","",CHOOSE(WEEKDAY(A294,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A294,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A294)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A294)),"")=IFERROR($D294*$C294*$E294/$F294,"")320=$H294*$G294=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A294)),"")=$J294=$I294*$K294=年度假设!$B$32=$L294*$M294—————————————
46679=IF($A295="","",CHOOSE(WEEKDAY(A295,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A295,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A295)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A295)),"")=IFERROR($D295*$C295*$E295/$F295,"")320=$H295*$G295=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A295)),"")=$J295=$I295*$K295=年度假设!$B$32=$L295*$M295—————————————
46680=IF($A296="","",CHOOSE(WEEKDAY(A296,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A296,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A296)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A296)),"")=IFERROR($D296*$C296*$E296/$F296,"")320=$H296*$G296=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A296)),"")=$J296=$I296*$K296=年度假设!$B$32=$L296*$M296—————————————
46681=IF($A297="","",CHOOSE(WEEKDAY(A297,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A297,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A297)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A297)),"")=IFERROR($D297*$C297*$E297/$F297,"")320=$H297*$G297=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A297)),"")=$J297=$I297*$K297=年度假设!$B$32=$L297*$M297—————————————
46682=IF($A298="","",CHOOSE(WEEKDAY(A298,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A298,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A298)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A298)),"")=IFERROR($D298*$C298*$E298/$F298,"")320=$H298*$G298=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A298)),"")=$J298=$I298*$K298=年度假设!$B$32=$L298*$M298—————————————
46683=IF($A299="","",CHOOSE(WEEKDAY(A299,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A299,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A299)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A299)),"")=IFERROR($D299*$C299*$E299/$F299,"")320=$H299*$G299=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A299)),"")=$J299=$I299*$K299=年度假设!$B$32=$L299*$M299—————————————
46684=IF($A300="","",CHOOSE(WEEKDAY(A300,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A300,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A300)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A300)),"")=IFERROR($D300*$C300*$E300/$F300,"")320=$H300*$G300=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A300)),"")=$J300=$I300*$K300=年度假设!$B$32=$L300*$M300—————————————
46685=IF($A301="","",CHOOSE(WEEKDAY(A301,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A301,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A301)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A301)),"")=IFERROR($D301*$C301*$E301/$F301,"")320=$H301*$G301=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A301)),"")=$J301=$I301*$K301=年度假设!$B$32=$L301*$M301—————————————
46686=IF($A302="","",CHOOSE(WEEKDAY(A302,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A302,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A302)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A302)),"")=IFERROR($D302*$C302*$E302/$F302,"")320=$H302*$G302=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A302)),"")=$J302=$I302*$K302=年度假设!$B$32=$L302*$M302—————————————
46687=IF($A303="","",CHOOSE(WEEKDAY(A303,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A303,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A303)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A303)),"")=IFERROR($D303*$C303*$E303/$F303,"")320=$H303*$G303=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A303)),"")=$J303=$I303*$K303=年度假设!$B$32=$L303*$M303—————————————
46688=IF($A304="","",CHOOSE(WEEKDAY(A304,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A304,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A304)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A304)),"")=IFERROR($D304*$C304*$E304/$F304,"")320=$H304*$G304=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A304)),"")=$J304=$I304*$K304=年度假设!$B$32=$L304*$M304—————————————
46689=IF($A305="","",CHOOSE(WEEKDAY(A305,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A305,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A305)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A305)),"")=IFERROR($D305*$C305*$E305/$F305,"")320=$H305*$G305=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A305)),"")=$J305=$I305*$K305=年度假设!$B$32=$L305*$M305—————————————
46690=IF($A306="","",CHOOSE(WEEKDAY(A306,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A306,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A306)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A306)),"")=IFERROR($D306*$C306*$E306/$F306,"")320=$H306*$G306=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A306)),"")=$J306=$I306*$K306=年度假设!$B$32=$L306*$M306—————————————
46691=IF($A307="","",CHOOSE(WEEKDAY(A307,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A307,2)),"")0.85=IFERROR(INDEX($U$4:$U$15,MONTH($A307)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A307)),"")=IFERROR($D307*$C307*$E307/$F307,"")320=$H307*$G307=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A307)),"")=$J307=$I307*$K307=年度假设!$B$32=$L307*$M307—————————————
46692=IF($A308="","",CHOOSE(WEEKDAY(A308,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A308,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A308)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A308)),"")=IFERROR($D308*$C308*$E308/$F308,"")320=$H308*$G308=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A308)),"")=$J308=$I308*$K308=年度假设!$B$32=$L308*$M308—————————————
46693=IF($A309="","",CHOOSE(WEEKDAY(A309,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A309,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A309)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A309)),"")=IFERROR($D309*$C309*$E309/$F309,"")320=$H309*$G309=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A309)),"")=$J309=$I309*$K309=年度假设!$B$32=$L309*$M309—————————————
46694=IF($A310="","",CHOOSE(WEEKDAY(A310,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A310,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A310)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A310)),"")=IFERROR($D310*$C310*$E310/$F310,"")320=$H310*$G310=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A310)),"")=$J310=$I310*$K310=年度假设!$B$32=$L310*$M310—————————————
46695=IF($A311="","",CHOOSE(WEEKDAY(A311,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A311,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A311)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A311)),"")=IFERROR($D311*$C311*$E311/$F311,"")320=$H311*$G311=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A311)),"")=$J311=$I311*$K311=年度假设!$B$32=$L311*$M311—————————————
46696=IF($A312="","",CHOOSE(WEEKDAY(A312,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A312,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A312)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A312)),"")=IFERROR($D312*$C312*$E312/$F312,"")320=$H312*$G312=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A312)),"")=$J312=$I312*$K312=年度假设!$B$32=$L312*$M312—————————————
46697=IF($A313="","",CHOOSE(WEEKDAY(A313,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A313,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A313)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A313)),"")=IFERROR($D313*$C313*$E313/$F313,"")320=$H313*$G313=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A313)),"")=$J313=$I313*$K313=年度假设!$B$32=$L313*$M313—————————————
46698=IF($A314="","",CHOOSE(WEEKDAY(A314,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A314,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A314)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A314)),"")=IFERROR($D314*$C314*$E314/$F314,"")320=$H314*$G314=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A314)),"")=$J314=$I314*$K314=年度假设!$B$32=$L314*$M314—————————————
46699=IF($A315="","",CHOOSE(WEEKDAY(A315,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A315,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A315)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A315)),"")=IFERROR($D315*$C315*$E315/$F315,"")320=$H315*$G315=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A315)),"")=$J315=$I315*$K315=年度假设!$B$32=$L315*$M315—————————————
46700=IF($A316="","",CHOOSE(WEEKDAY(A316,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A316,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A316)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A316)),"")=IFERROR($D316*$C316*$E316/$F316,"")320=$H316*$G316=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A316)),"")=$J316=$I316*$K316=年度假设!$B$32=$L316*$M316—————————————
46701=IF($A317="","",CHOOSE(WEEKDAY(A317,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A317,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A317)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A317)),"")=IFERROR($D317*$C317*$E317/$F317,"")320=$H317*$G317=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A317)),"")=$J317=$I317*$K317=年度假设!$B$32=$L317*$M317—————————————
46702=IF($A318="","",CHOOSE(WEEKDAY(A318,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A318,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A318)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A318)),"")=IFERROR($D318*$C318*$E318/$F318,"")320=$H318*$G318=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A318)),"")=$J318=$I318*$K318=年度假设!$B$32=$L318*$M318—————————————
46703=IF($A319="","",CHOOSE(WEEKDAY(A319,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A319,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A319)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A319)),"")=IFERROR($D319*$C319*$E319/$F319,"")320=$H319*$G319=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A319)),"")=$J319=$I319*$K319=年度假设!$B$32=$L319*$M319—————————————
46704=IF($A320="","",CHOOSE(WEEKDAY(A320,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A320,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A320)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A320)),"")=IFERROR($D320*$C320*$E320/$F320,"")320=$H320*$G320=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A320)),"")=$J320=$I320*$K320=年度假设!$B$32=$L320*$M320—————————————
46705=IF($A321="","",CHOOSE(WEEKDAY(A321,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A321,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A321)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A321)),"")=IFERROR($D321*$C321*$E321/$F321,"")320=$H321*$G321=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A321)),"")=$J321=$I321*$K321=年度假设!$B$32=$L321*$M321—————————————
46706=IF($A322="","",CHOOSE(WEEKDAY(A322,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A322,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A322)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A322)),"")=IFERROR($D322*$C322*$E322/$F322,"")320=$H322*$G322=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A322)),"")=$J322=$I322*$K322=年度假设!$B$32=$L322*$M322—————————————
46707=IF($A323="","",CHOOSE(WEEKDAY(A323,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A323,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A323)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A323)),"")=IFERROR($D323*$C323*$E323/$F323,"")320=$H323*$G323=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A323)),"")=$J323=$I323*$K323=年度假设!$B$32=$L323*$M323—————————————
46708=IF($A324="","",CHOOSE(WEEKDAY(A324,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A324,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A324)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A324)),"")=IFERROR($D324*$C324*$E324/$F324,"")320=$H324*$G324=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A324)),"")=$J324=$I324*$K324=年度假设!$B$32=$L324*$M324—————————————
46709=IF($A325="","",CHOOSE(WEEKDAY(A325,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A325,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A325)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A325)),"")=IFERROR($D325*$C325*$E325/$F325,"")320=$H325*$G325=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A325)),"")=$J325=$I325*$K325=年度假设!$B$32=$L325*$M325—————————————
46710=IF($A326="","",CHOOSE(WEEKDAY(A326,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A326,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A326)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A326)),"")=IFERROR($D326*$C326*$E326/$F326,"")320=$H326*$G326=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A326)),"")=$J326=$I326*$K326=年度假设!$B$32=$L326*$M326—————————————
46711=IF($A327="","",CHOOSE(WEEKDAY(A327,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A327,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A327)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A327)),"")=IFERROR($D327*$C327*$E327/$F327,"")320=$H327*$G327=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A327)),"")=$J327=$I327*$K327=年度假设!$B$32=$L327*$M327—————————————
46712=IF($A328="","",CHOOSE(WEEKDAY(A328,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A328,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A328)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A328)),"")=IFERROR($D328*$C328*$E328/$F328,"")320=$H328*$G328=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A328)),"")=$J328=$I328*$K328=年度假设!$B$32=$L328*$M328—————————————
46713=IF($A329="","",CHOOSE(WEEKDAY(A329,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A329,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A329)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A329)),"")=IFERROR($D329*$C329*$E329/$F329,"")320=$H329*$G329=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A329)),"")=$J329=$I329*$K329=年度假设!$B$32=$L329*$M329—————————————
46714=IF($A330="","",CHOOSE(WEEKDAY(A330,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A330,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A330)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A330)),"")=IFERROR($D330*$C330*$E330/$F330,"")320=$H330*$G330=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A330)),"")=$J330=$I330*$K330=年度假设!$B$32=$L330*$M330—————————————
46715=IF($A331="","",CHOOSE(WEEKDAY(A331,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A331,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A331)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A331)),"")=IFERROR($D331*$C331*$E331/$F331,"")320=$H331*$G331=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A331)),"")=$J331=$I331*$K331=年度假设!$B$32=$L331*$M331—————————————
46716=IF($A332="","",CHOOSE(WEEKDAY(A332,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A332,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A332)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A332)),"")=IFERROR($D332*$C332*$E332/$F332,"")320=$H332*$G332=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A332)),"")=$J332=$I332*$K332=年度假设!$B$32=$L332*$M332—————————————
46717=IF($A333="","",CHOOSE(WEEKDAY(A333,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A333,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A333)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A333)),"")=IFERROR($D333*$C333*$E333/$F333,"")320=$H333*$G333=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A333)),"")=$J333=$I333*$K333=年度假设!$B$32=$L333*$M333—————————————
46718=IF($A334="","",CHOOSE(WEEKDAY(A334,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A334,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A334)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A334)),"")=IFERROR($D334*$C334*$E334/$F334,"")320=$H334*$G334=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A334)),"")=$J334=$I334*$K334=年度假设!$B$32=$L334*$M334—————————————
46719=IF($A335="","",CHOOSE(WEEKDAY(A335,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A335,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A335)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A335)),"")=IFERROR($D335*$C335*$E335/$F335,"")320=$H335*$G335=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A335)),"")=$J335=$I335*$K335=年度假设!$B$32=$L335*$M335—————————————
46720=IF($A336="","",CHOOSE(WEEKDAY(A336,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A336,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A336)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A336)),"")=IFERROR($D336*$C336*$E336/$F336,"")320=$H336*$G336=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A336)),"")=$J336=$I336*$K336=年度假设!$B$32=$L336*$M336—————————————
46721=IF($A337="","",CHOOSE(WEEKDAY(A337,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A337,2)),"")0.78=IFERROR(INDEX($U$4:$U$15,MONTH($A337)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A337)),"")=IFERROR($D337*$C337*$E337/$F337,"")320=$H337*$G337=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A337)),"")=$J337=$I337*$K337=年度假设!$B$32=$L337*$M337—————————————
46722=IF($A338="","",CHOOSE(WEEKDAY(A338,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A338,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A338)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A338)),"")=IFERROR($D338*$C338*$E338/$F338,"")320=$H338*$G338=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A338)),"")=$J338=$I338*$K338=年度假设!$B$32=$L338*$M338—————————————
46723=IF($A339="","",CHOOSE(WEEKDAY(A339,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A339,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A339)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A339)),"")=IFERROR($D339*$C339*$E339/$F339,"")320=$H339*$G339=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A339)),"")=$J339=$I339*$K339=年度假设!$B$32=$L339*$M339—————————————
46724=IF($A340="","",CHOOSE(WEEKDAY(A340,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A340,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A340)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A340)),"")=IFERROR($D340*$C340*$E340/$F340,"")320=$H340*$G340=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A340)),"")=$J340=$I340*$K340=年度假设!$B$32=$L340*$M340—————————————
46725=IF($A341="","",CHOOSE(WEEKDAY(A341,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A341,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A341)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A341)),"")=IFERROR($D341*$C341*$E341/$F341,"")320=$H341*$G341=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A341)),"")=$J341=$I341*$K341=年度假设!$B$32=$L341*$M341—————————————
46726=IF($A342="","",CHOOSE(WEEKDAY(A342,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A342,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A342)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A342)),"")=IFERROR($D342*$C342*$E342/$F342,"")320=$H342*$G342=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A342)),"")=$J342=$I342*$K342=年度假设!$B$32=$L342*$M342—————————————
46727=IF($A343="","",CHOOSE(WEEKDAY(A343,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A343,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A343)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A343)),"")=IFERROR($D343*$C343*$E343/$F343,"")320=$H343*$G343=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A343)),"")=$J343=$I343*$K343=年度假设!$B$32=$L343*$M343—————————————
46728=IF($A344="","",CHOOSE(WEEKDAY(A344,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A344,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A344)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A344)),"")=IFERROR($D344*$C344*$E344/$F344,"")320=$H344*$G344=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A344)),"")=$J344=$I344*$K344=年度假设!$B$32=$L344*$M344—————————————
46729=IF($A345="","",CHOOSE(WEEKDAY(A345,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A345,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A345)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A345)),"")=IFERROR($D345*$C345*$E345/$F345,"")320=$H345*$G345=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A345)),"")=$J345=$I345*$K345=年度假设!$B$32=$L345*$M345—————————————
46730=IF($A346="","",CHOOSE(WEEKDAY(A346,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A346,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A346)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A346)),"")=IFERROR($D346*$C346*$E346/$F346,"")320=$H346*$G346=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A346)),"")=$J346=$I346*$K346=年度假设!$B$32=$L346*$M346—————————————
46731=IF($A347="","",CHOOSE(WEEKDAY(A347,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A347,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A347)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A347)),"")=IFERROR($D347*$C347*$E347/$F347,"")320=$H347*$G347=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A347)),"")=$J347=$I347*$K347=年度假设!$B$32=$L347*$M347—————————————
46732=IF($A348="","",CHOOSE(WEEKDAY(A348,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A348,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A348)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A348)),"")=IFERROR($D348*$C348*$E348/$F348,"")320=$H348*$G348=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A348)),"")=$J348=$I348*$K348=年度假设!$B$32=$L348*$M348—————————————
46733=IF($A349="","",CHOOSE(WEEKDAY(A349,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A349,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A349)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A349)),"")=IFERROR($D349*$C349*$E349/$F349,"")320=$H349*$G349=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A349)),"")=$J349=$I349*$K349=年度假设!$B$32=$L349*$M349—————————————
46734=IF($A350="","",CHOOSE(WEEKDAY(A350,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A350,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A350)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A350)),"")=IFERROR($D350*$C350*$E350/$F350,"")320=$H350*$G350=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A350)),"")=$J350=$I350*$K350=年度假设!$B$32=$L350*$M350—————————————
46735=IF($A351="","",CHOOSE(WEEKDAY(A351,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A351,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A351)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A351)),"")=IFERROR($D351*$C351*$E351/$F351,"")320=$H351*$G351=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A351)),"")=$J351=$I351*$K351=年度假设!$B$32=$L351*$M351—————————————
46736=IF($A352="","",CHOOSE(WEEKDAY(A352,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A352,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A352)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A352)),"")=IFERROR($D352*$C352*$E352/$F352,"")320=$H352*$G352=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A352)),"")=$J352=$I352*$K352=年度假设!$B$32=$L352*$M352—————————————
46737=IF($A353="","",CHOOSE(WEEKDAY(A353,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A353,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A353)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A353)),"")=IFERROR($D353*$C353*$E353/$F353,"")320=$H353*$G353=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A353)),"")=$J353=$I353*$K353=年度假设!$B$32=$L353*$M353—————————————
46738=IF($A354="","",CHOOSE(WEEKDAY(A354,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A354,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A354)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A354)),"")=IFERROR($D354*$C354*$E354/$F354,"")320=$H354*$G354=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A354)),"")=$J354=$I354*$K354=年度假设!$B$32=$L354*$M354—————————————
46739=IF($A355="","",CHOOSE(WEEKDAY(A355,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A355,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A355)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A355)),"")=IFERROR($D355*$C355*$E355/$F355,"")320=$H355*$G355=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A355)),"")=$J355=$I355*$K355=年度假设!$B$32=$L355*$M355—————————————
46740=IF($A356="","",CHOOSE(WEEKDAY(A356,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A356,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A356)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A356)),"")=IFERROR($D356*$C356*$E356/$F356,"")320=$H356*$G356=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A356)),"")=$J356=$I356*$K356=年度假设!$B$32=$L356*$M356—————————————
46741=IF($A357="","",CHOOSE(WEEKDAY(A357,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A357,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A357)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A357)),"")=IFERROR($D357*$C357*$E357/$F357,"")320=$H357*$G357=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A357)),"")=$J357=$I357*$K357=年度假设!$B$32=$L357*$M357—————————————
46742=IF($A358="","",CHOOSE(WEEKDAY(A358,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A358,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A358)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A358)),"")=IFERROR($D358*$C358*$E358/$F358,"")320=$H358*$G358=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A358)),"")=$J358=$I358*$K358=年度假设!$B$32=$L358*$M358—————————————
46743=IF($A359="","",CHOOSE(WEEKDAY(A359,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A359,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A359)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A359)),"")=IFERROR($D359*$C359*$E359/$F359,"")320=$H359*$G359=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A359)),"")=$J359=$I359*$K359=年度假设!$B$32=$L359*$M359—————————————
46744=IF($A360="","",CHOOSE(WEEKDAY(A360,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A360,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A360)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A360)),"")=IFERROR($D360*$C360*$E360/$F360,"")320=$H360*$G360=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A360)),"")=$J360=$I360*$K360=年度假设!$B$32=$L360*$M360—————————————
46745=IF($A361="","",CHOOSE(WEEKDAY(A361,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A361,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A361)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A361)),"")=IFERROR($D361*$C361*$E361/$F361,"")320=$H361*$G361=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A361)),"")=$J361=$I361*$K361=年度假设!$B$32=$L361*$M361—————————————
46746=IF($A362="","",CHOOSE(WEEKDAY(A362,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A362,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A362)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A362)),"")=IFERROR($D362*$C362*$E362/$F362,"")320=$H362*$G362=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A362)),"")=$J362=$I362*$K362=年度假设!$B$32=$L362*$M362—————————————
46747=IF($A363="","",CHOOSE(WEEKDAY(A363,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A363,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A363)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A363)),"")=IFERROR($D363*$C363*$E363/$F363,"")320=$H363*$G363=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A363)),"")=$J363=$I363*$K363=年度假设!$B$32=$L363*$M363—————————————
46748=IF($A364="","",CHOOSE(WEEKDAY(A364,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A364,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A364)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A364)),"")=IFERROR($D364*$C364*$E364/$F364,"")320=$H364*$G364=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A364)),"")=$J364=$I364*$K364=年度假设!$B$32=$L364*$M364—————————————
46749=IF($A365="","",CHOOSE(WEEKDAY(A365,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A365,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A365)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A365)),"")=IFERROR($D365*$C365*$E365/$F365,"")320=$H365*$G365=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A365)),"")=$J365=$I365*$K365=年度假设!$B$32=$L365*$M365—————————————
46750=IF($A366="","",CHOOSE(WEEKDAY(A366,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A366,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A366)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A366)),"")=IFERROR($D366*$C366*$E366/$F366,"")320=$H366*$G366=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A366)),"")=$J366=$I366*$K366=年度假设!$B$32=$L366*$M366—————————————
46751=IF($A367="","",CHOOSE(WEEKDAY(A367,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A367,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A367)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A367)),"")=IFERROR($D367*$C367*$E367/$F367,"")320=$H367*$G367=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A367)),"")=$J367=$I367*$K367=年度假设!$B$32=$L367*$M367—————————————
46752=IF($A368="","",CHOOSE(WEEKDAY(A368,2),"周一","周二","周三","周四","周五","周六","周日"))=IFERROR(INDEX($Q$4:$Q$10,WEEKDAY($A368,2)),"")0.68=IFERROR(INDEX($U$4:$U$15,MONTH($A368)),"")=IFERROR(INDEX($V$4:$V$15,MONTH($A368)),"")=IFERROR($D368*$C368*$E368/$F368,"")320=$H368*$G368=IFERROR(INDEX(月度预算!$F$4:$F$15,MONTH($A368)),"")=$J368=$I368*$K368=年度假设!$B$32=$L368*$M368—————————————
滚动预测 · 未来 12 个月
输入：起始月份、每月状态与 OCC/ADR（已过月份填实际，未来月份填预测）。其余全部为公式。
————————————
滚动起始月份2027-01-01 00:00:00未来 12 个月的第一天；改这里整表重排
未来 12 个月滚动预测
月份月份起始日状态OCC 实际/预测ADR 实际/预测RevPAR天数可售房晚已售房晚客房收入餐饮收入总营收
1=$B$4已过65.8%541=$D7*$E7=EOMONTH($B7,0)-$B7+1=$G7*年度假设!$B$7=$H7*$D7=$I7*$E7=$J7*年度假设!$B$29=$J7+$K7+$J7*年度假设!$B$30
2=EOMONTH($B7,0)+1已过67.0%573=$D8*$E8=EOMONTH($B8,0)-$B8+1=$G8*年度假设!$B$7=$H8*$D8=$I8*$E8=$J8*年度假设!$B$29=$J8+$K8+$J8*年度假设!$B$30
3=EOMONTH($B8,0)+1已过68.5%626=$D9*$E9=EOMONTH($B9,0)-$B9+1=$G9*年度假设!$B$7=$H9*$D9=$I9*$E9=$J9*年度假设!$B$29=$J9+$K9+$J9*年度假设!$B$30
4=EOMONTH($B9,0)+1预测71.6%669=$D10*$E10=EOMONTH($B10,0)-$B10+1=$G10*年度假设!$B$7=$H10*$D10=$I10*$E10=$J10*年度假设!$B$29=$J10+$K10+$J10*年度假设!$B$30
5=EOMONTH($B10,0)+1预测76.8%552=$D11*$E11=EOMONTH($B11,0)-$B11+1=$G11*年度假设!$B$7=$H11*$D11=$I11*$E11=$J11*年度假设!$B$29=$J11+$K11+$J11*年度假设!$B$30
6=EOMONTH($B11,0)+1预测66.0%565=$D12*$E12=EOMONTH($B12,0)-$B12+1=$G12*年度假设!$B$7=$H12*$D12=$I12*$E12=$J12*年度假设!$B$29=$J12+$K12+$J12*年度假设!$B$30
7=EOMONTH($B12,0)+1预测65.8%614=$D13*$E13=EOMONTH($B13,0)-$B13+1=$G13*年度假设!$B$7=$H13*$D13=$I13*$E13=$J13*年度假设!$B$29=$J13+$K13+$J13*年度假设!$B$30
8=EOMONTH($B13,0)+1预测70.0%655=$D14*$E14=EOMONTH($B14,0)-$B14+1=$G14*年度假设!$B$7=$H14*$D14=$I14*$E14=$J14*年度假设!$B$29=$J14+$K14+$J14*年度假设!$B$30
9=EOMONTH($B14,0)+1预测74.8%536=$D15*$E15=EOMONTH($B15,0)-$B15+1=$G15*年度假设!$B$7=$H15*$D15=$I15*$E15=$J15*年度假设!$B$29=$J15+$K15+$J15*年度假设!$B$30
10=EOMONTH($B15,0)+1预测77.2%569=$D16*$E16=EOMONTH($B16,0)-$B16+1=$G16*年度假设!$B$7=$H16*$D16=$I16*$E16=$J16*年度假设!$B$29=$J16+$K16+$J16*年度假设!$B$30
11=EOMONTH($B16,0)+1预测63.3%624=$D17*$E17=EOMONTH($B17,0)-$B17+1=$G17*年度假设!$B$7=$H17*$D17=$I17*$E17=$J17*年度假设!$B$29=$J17+$K17+$J17*年度假设!$B$30
12=EOMONTH($B17,0)+1预测68.3%672=$D18*$E18=EOMONTH($B18,0)-$B18+1=$G18*年度假设!$B$7=$H18*$D18=$I18*$E18=$J18*年度假设!$B$29=$J18+$K18+$J18*年度假设!$B$30
滚动 12 个月合计——=IFERROR($I$19/$H$19,"")=IFERROR($J$19/$I$19,"")=IFERROR($J$19/$H$19,"")=SUM($G$7:$G$18)11680081316.4800000000148716185.6=SUM($K$7:$K$18)=SUM($L$7:$L$18)
差异分析 · 量差 / 价差分解
量差 =（实际房晚 − 预算房晚）× 预算 ADR；价差 =（实际 ADR − 预算 ADR）× 实际房晚。输入实际值即可。
——————————————
月度差异分解
月份预算房晚实际房晚房晚差异预算 ADR实际 ADRADR 差异量差(元)价差(元)总差异(元)预算客房收入实际客房收入校验差异(元)结论
1=IFERROR(INDEX(月度预算!$H$4:$H$15,$A6),"")—=IFERROR($C6-$B6,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A6),"")—=IFERROR($F6-$E6,"")=IFERROR(($C6-$B6)*$E6,"")=IFERROR(($F6-$E6)*$C6,"")=IFERROR($H6+$I6,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A6),"")=IFERROR($C6*$F6,"")=IFERROR($L6-$K6-$J6,"")=IF(OR($C6="",$F6=""),"待填实际值",IF(ABS($M6)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M6,"#,##0")&" 元，检查输入"))
2=IFERROR(INDEX(月度预算!$H$4:$H$15,$A7),"")—=IFERROR($C7-$B7,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A7),"")—=IFERROR($F7-$E7,"")=IFERROR(($C7-$B7)*$E7,"")=IFERROR(($F7-$E7)*$C7,"")=IFERROR($H7+$I7,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A7),"")=IFERROR($C7*$F7,"")=IFERROR($L7-$K7-$J7,"")=IF(OR($C7="",$F7=""),"待填实际值",IF(ABS($M7)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M7,"#,##0")&" 元，检查输入"))
3=IFERROR(INDEX(月度预算!$H$4:$H$15,$A8),"")—=IFERROR($C8-$B8,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A8),"")—=IFERROR($F8-$E8,"")=IFERROR(($C8-$B8)*$E8,"")=IFERROR(($F8-$E8)*$C8,"")=IFERROR($H8+$I8,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A8),"")=IFERROR($C8*$F8,"")=IFERROR($L8-$K8-$J8,"")=IF(OR($C8="",$F8=""),"待填实际值",IF(ABS($M8)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M8,"#,##0")&" 元，检查输入"))
4=IFERROR(INDEX(月度预算!$H$4:$H$15,$A9),"")—=IFERROR($C9-$B9,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A9),"")—=IFERROR($F9-$E9,"")=IFERROR(($C9-$B9)*$E9,"")=IFERROR(($F9-$E9)*$C9,"")=IFERROR($H9+$I9,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A9),"")=IFERROR($C9*$F9,"")=IFERROR($L9-$K9-$J9,"")=IF(OR($C9="",$F9=""),"待填实际值",IF(ABS($M9)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M9,"#,##0")&" 元，检查输入"))
5=IFERROR(INDEX(月度预算!$H$4:$H$15,$A10),"")—=IFERROR($C10-$B10,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A10),"")—=IFERROR($F10-$E10,"")=IFERROR(($C10-$B10)*$E10,"")=IFERROR(($F10-$E10)*$C10,"")=IFERROR($H10+$I10,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A10),"")=IFERROR($C10*$F10,"")=IFERROR($L10-$K10-$J10,"")=IF(OR($C10="",$F10=""),"待填实际值",IF(ABS($M10)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M10,"#,##0")&" 元，检查输入"))
6=IFERROR(INDEX(月度预算!$H$4:$H$15,$A11),"")—=IFERROR($C11-$B11,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A11),"")—=IFERROR($F11-$E11,"")=IFERROR(($C11-$B11)*$E11,"")=IFERROR(($F11-$E11)*$C11,"")=IFERROR($H11+$I11,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A11),"")=IFERROR($C11*$F11,"")=IFERROR($L11-$K11-$J11,"")=IF(OR($C11="",$F11=""),"待填实际值",IF(ABS($M11)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M11,"#,##0")&" 元，检查输入"))
7=IFERROR(INDEX(月度预算!$H$4:$H$15,$A12),"")—=IFERROR($C12-$B12,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A12),"")—=IFERROR($F12-$E12,"")=IFERROR(($C12-$B12)*$E12,"")=IFERROR(($F12-$E12)*$C12,"")=IFERROR($H12+$I12,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A12),"")=IFERROR($C12*$F12,"")=IFERROR($L12-$K12-$J12,"")=IF(OR($C12="",$F12=""),"待填实际值",IF(ABS($M12)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M12,"#,##0")&" 元，检查输入"))
8=IFERROR(INDEX(月度预算!$H$4:$H$15,$A13),"")—=IFERROR($C13-$B13,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A13),"")—=IFERROR($F13-$E13,"")=IFERROR(($C13-$B13)*$E13,"")=IFERROR(($F13-$E13)*$C13,"")=IFERROR($H13+$I13,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A13),"")=IFERROR($C13*$F13,"")=IFERROR($L13-$K13-$J13,"")=IF(OR($C13="",$F13=""),"待填实际值",IF(ABS($M13)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M13,"#,##0")&" 元，检查输入"))
9=IFERROR(INDEX(月度预算!$H$4:$H$15,$A14),"")—=IFERROR($C14-$B14,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A14),"")—=IFERROR($F14-$E14,"")=IFERROR(($C14-$B14)*$E14,"")=IFERROR(($F14-$E14)*$C14,"")=IFERROR($H14+$I14,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A14),"")=IFERROR($C14*$F14,"")=IFERROR($L14-$K14-$J14,"")=IF(OR($C14="",$F14=""),"待填实际值",IF(ABS($M14)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M14,"#,##0")&" 元，检查输入"))
10=IFERROR(INDEX(月度预算!$H$4:$H$15,$A15),"")—=IFERROR($C15-$B15,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A15),"")—=IFERROR($F15-$E15,"")=IFERROR(($C15-$B15)*$E15,"")=IFERROR(($F15-$E15)*$C15,"")=IFERROR($H15+$I15,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A15),"")=IFERROR($C15*$F15,"")=IFERROR($L15-$K15-$J15,"")=IF(OR($C15="",$F15=""),"待填实际值",IF(ABS($M15)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M15,"#,##0")&" 元，检查输入"))
11=IFERROR(INDEX(月度预算!$H$4:$H$15,$A16),"")—=IFERROR($C16-$B16,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A16),"")—=IFERROR($F16-$E16,"")=IFERROR(($C16-$B16)*$E16,"")=IFERROR(($F16-$E16)*$C16,"")=IFERROR($H16+$I16,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A16),"")=IFERROR($C16*$F16,"")=IFERROR($L16-$K16-$J16,"")=IF(OR($C16="",$F16=""),"待填实际值",IF(ABS($M16)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M16,"#,##0")&" 元，检查输入"))
12=IFERROR(INDEX(月度预算!$H$4:$H$15,$A17),"")—=IFERROR($C17-$B17,"")=IFERROR(INDEX(月度预算!$F$4:$F$15,$A17),"")—=IFERROR($F17-$E17,"")=IFERROR(($C17-$B17)*$E17,"")=IFERROR(($F17-$E17)*$C17,"")=IFERROR($H17+$I17,"")=IFERROR(INDEX(月度预算!$K$4:$K$15,$A17),"")=IFERROR($C17*$F17,"")=IFERROR($L17-$K17-$J17,"")=IF(OR($C17="",$F17=""),"待填实际值",IF(ABS($M17)<1,"✓ 量差+价差 与 收入差 一致","✗ 差异 "&TEXT($M17,"#,##0")&" 元，检查输入"))
合计=SUM($B$6:$B$17)=SUM($C$6:$C$17)=SUM($D$6:$D$17)———=SUM($H$6:$H$17)=SUM($I$6:$I$17)=SUM($J$6:$J$17)=SUM($K$6:$K$17)=SUM($L$6:$L$17)=SUM($M$6:$M$17)—
——————————————
分解口径
量差（Volume Variance）=（实际房晚 − 预算房晚）× 预算 ADR —— 卖多卖少带来的差异
价差（Rate Variance）=（实际 ADR − 预算 ADR）× 实际房晚 —— 卖贵卖便宜带来的差异
总差异 = 量差 + 价差，应等于「实际客房收入 − 预算客房收入」（M 列校验，绝对值 <1 元即通过）
若量差为正、价差为负：说明靠降价换量，须判断 NRevPAR 是否同步改善
若量差为负、价差为正：说明提价成功但丢量，须结合 MPI 判断是否份额流失
Excel 模板预览（公式计算值，输入格为示例/空） · 在线预览，可直接查看；如需编辑请用“下载”按钮获取原文件。