SP 预警状态设置

来源：互联网发布：淘宝怎么改登录名编辑：程序博客网时间：2024/04/28 02:35

任务工期预警

IIf([基线工期] = 0 And [工期差异] / 480 <= 0, "无基线", IIf([工期差异] / [基线工期] <= 0.05, "正常", IIf([工期差异] / [基线工期] >= 0.2, "严重延迟", "延迟")))

Task Duration Alert

IIf([Baseline Finish] = 0 And [Duration Variance] / 480 <= 0, "N/A", IIf([Duration Variance] / [cBaseline Finish] <= 0.05, "Normal", IIf([Duration Variance] / [Baseline Finish] >= 0.2, "Serious Postpone", "Postpone")))

-----------

任务进度预警

IIf([状态] = 0, "已完成", IIf([状态] = 1, "正常", IIf([状态] = 2, "延迟", "任务还未开始")))

Task Finish Alert

IIf([Start] = 0, "Finished", IIf([Start] = 1, "Normal", IIf([Start] = 2, "Delay", "Not Finish")))

-----------

项目工期预警

IIf(ProjDateValue([基线完成时间]) = 4294967295, "无基准!", IIf([完成时间差异] / 480 > 10, "严重延迟", IIf([完成时间差异] / 480 < 5, "项目正常", "完成延迟")))

Finish Alert

IIf(ProjDateValue([Baseline Finish]) = 4294967295, "N/A", IIf([Duration Variance] / 480 > 10, "Serious Delay", IIf([Duration Variance] / 480 < 5, "Normal", "Finish Delay")))

-----------

项目成本预警

IIf([成本差异] <= 10000, "正常", IIf([成本差异] >= 20000, "严重超支", "超支"))

Duration Alert

IIf([Cost Variance] <= 10000, "Normal", IIf([Cost Variance] >= 20000, "Serious Overrun", "Overrun"))

0 0