excel生产计划表2--自动排程

当前日期：2011-1-27日期星期MO221475191.72310.004AX4SG-UL(E)50001/30200020001/27601/29计划MO221476291.72310.005AX5SG-UL(E)10002/160012001/29401/30计划MO221477391.72310.006AX6SG-UL(E)6002/260015001/30241/31计划MO221478491.72310.007AX7SG-UL(E)20002/2100010001/30482/1计划MO221479591.72310.008AX8SG-UL(E)30002/3200020002/1362/2计划MO221480691.72310.009AX9SG-UL(E)3002/42002002/3362/4计划线别1总负荷实际工时订单数量交期计划排产数量产能（天）开始日期计划工时结束日期订单号优先料号描述1/261/271/281/291/301/312/12/22/32/42/5周三周四周五周六周日周一周二周三周四周五周六20002000100060040060026710007335332000467153147111111110.7333当前日期：2011-1-27日期星期MO221475191.72310.004AX4SG-UL(E)50001/30200020001/27601/29计划MO221476291.72310.005AX5SG-UL(E)10002/1100012001/29241/30计划MO221477391.72310.006AX6SG-UL(E)6002/260015001/30241/31计划MO221478491.72310.007AX7SG-UL(E)20002/2100010001/30482/1计划MO221479591.72310.008AX8SG-UL(E)30002/3200020001/31362/1计划MO221480691.72310.009AX9SG-UL(E)3002/42002002/3362/4计划Line1CapacityBurdenActualtimeOrderQTYDeliveryDatePlanQty(D)Capicity(D)Line1totalcapacitystartplantimeSTOPOrderNO.priorityProductNO.Description1/261/271/281/291/301/312/12/22/32/42/5周三周四周五周六周日周一周二周三周四周五周六20002000100060040060026710007335332000467153147111111110.73