Excel自动生产排程

(2020-6-16)11/1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111/111/211/311/411/511/611/711/811/911/1011/1111/12日一二三四五六日一二三四11WO001FG001600011/1595%1002200631663.16220011/111/6100%1100110011001100110081612WO002FG00215008/1599%501100151630.321100#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!13WO003FG00316008/1550099%1002200111211.121112#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!14WO004FG00420008/2090%501100222344.461100#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!15WO005FG0058008/2099%12026408096.74809#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!21WO006FG00650008/1590%1002200555655.56220011/111/6100%110011001100110011005622WO007FG00720008/1590%1002200222322.232200#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!23WO008FG00810008/1590%1002200111211.121112#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!24WO009FG00910018/2090%200440011135.571113#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!25WO010FG01040008/2090%801760444555.561760#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!31WO011FG01120008/1590%901980222324.70198011/111/3100%99099024332WO012FG01215008/1590%1002200166716.671667#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!33WO013FG01340008/1590%1002200444544.452200#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!34WO014FG01455008/2090%1002200611261.122200#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!35#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!100%100%100%100%100%74%100%100%100%100%100%5%100%100%25%100%100%75%67%67%26%日计划排产量可投放日期开始日期结束日期排产库存数量良率小时产能日产能需生产数量生产工时负荷率Line-1负荷率Line-2负荷率Line-3总负荷率Line优先顺序订单号料号数量交期生产计划排程表首次任务开始日期：每日计划工时:Line-1Line-2Line-3111111111111111111/1311/1411/15五六日#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!