﻿from fx import *
import time
expr = 'ISNUMBER([应完成场次]) & "|" & ([应完成场次] = 0) & "|" & ISNUMBER([已提报场次]) & "|" & ([已提报场次] >= [应完成场次]) & "|" & (TODAY() > [结束日]) & "|" & ISNUMBER([周任务汇总]) & "|" & ISNUMBER([要求场次]) & "|" & ISBLANK([要求场次]) & "|" & ([应完成场次] + 1) & "|" & ISNUMBER([开始周序]) & "|" & [结束日]'
fcreate("任务表", [{"type": "formula", "name": "调试", "expression": expr}])
time.sleep(4)
for r in records(B, T["任务表"], ["任务名称", "调试", "应完成场次"]):
    if r["任务名称"] in ("W45·资阳·合计", "W49·资阳·合计", "11月·资阳·合计", "11月·资阳·小区运营"): print(r)
