生产计划自动排程格式.xls

开始日期 2011 8 8 工作时间12121212129121259121299101010101099101010101010101010101010101010 剩余时间12121212129121259121299101010101099101010101010101010101010101010 备用行1 预计交期工单号码产品名称 实际开始 日期 产线编号小时产能计划数量 已完成 数量 合 计差异 8 88 98 10 8 11 8 12 8 13 8 14 8 15 8 16 8 17 8 18 8 19 8 20 8 21 8 22 8 23 8 24 8 25 8 26 8 27 8 28 8 29 8 308 31 9 1 9 2 9 3 9 4 9 5 9 6 9 7 9 8 9 9 9 109 119 12 一二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日一 2011 8 821082中性 8 10 MKL3001000 1000 0 1000 2011 8 821083JUF 型号8 10 MKL3001000 1000 0 1000 2011 8 821084中性 8 10 MKL3001000 1000 0 1000 2011 8 1021085中性 8 10 MKL3004800 4800 0 6003600600 2011 8 1121086 BL CHINA 6002 2RSLC3 8 10 MKL3006336 6336 0 30003336 2011 8 1121087UCR 型号8 10 WHJ300508850880 3600 1488 2011 8 1221088CK 型号8 10 WHJ3003840 3840 0 2112 1728 2011 8 1021089CK 型号8 10 LY3001200 1200 0 1200 2011 8 1021090CK 型号8 10 LY3001200 1200 0 1200 2011 8 1021091JUF 型号8 10 LY3001200 1200 0 1200 2011 8 1121092ACCOR 型号 两等分8 10 LY3001200 1200 0 01200 2011 8 1121093ACCOR 型号 两等分8 10 LY3001200 1200 0 1200 2011 8 1221094XRX 型号8 10 WHJ3001200 1200 0 001200 2011 8 1321095 光板 外圈印BL CHINA 6003 2RSLC3 8 10 WHJ3001200 1200 0 672 528 2011 8 1221096BL CHINA 6003 ZC38 10 MKL3001200 1200 0 0264 936 2011 8 1121097XRX 型号8 10 LY3001200 1200 0 01200 2011 8 1221098JUF 型号8 10 LY3001200 1200 0 01200 2011 8 1221099SF 型号 两等分8 10 LY3001200 1200 0 1200 2011 8 1221100XRX 型号8 10 LY3001200 1200 0 1200 2011 8 1421101ACCOR 型号 两等分8 10 WHJ3002400 2400 0 0002172228 2011 8 1421102JUF 型号8 10 WHJ3002400 2400 0 2400 2011 8 1221103中性 8 10 MKL30014401440000 1440 2011 8 1321104ACCOR 型号 两等分8 10 LY3001680 1680 0 0001680 2011 8 1421105中性 8 10 LY3002880 2880 0 1020 1860 2011 8 1521106ACCOR 型号 两等分8 10 LY3002880 2880 0 1740 1140 2011 8 1521107 BL CHINA 6004 2RSLC3 8 10 LY3002072 2072 0 2072 2011 8 1521108BL CHINA 6004 ZC38 10 WHJ3001480 1480 0 0000972 508 2011 8 1521109JUF 型号8 10 WHJ3002072 2072 0 2072 2011 8 1321110JUF 型号8 10 MKL3001480 1480 0 001224256 2011 8 1821111JUF 型号8 10 LY3006240 6240 0 000003881500 2700 1652 2011 8 2021112SF 型号 两等分8 10 LY3006240 6240 0 1948 3600692 2011 8 2221113UCR 型号8 10 LY3004800 4800 0 2008 270092 2011 8 2421114 外圈 ACCOR 型号 两等分 8 10 LY3007200 7200 0 2908 3000 1292 2011 8 1821115CK 型号8 10 WHJ3007200 7200 0 000001020 1500 2700 1980 2011 8 2021116光板8 10 WHJ3006240 6240 0 1620 3600 1020 2011 8 1521117 BL CHINA 6005 2RSLC3 8 10 MKL3006240 6240 0 0002444 3600196 2011 8 2621118BL CHINA 6005 ZC38 10 LY3006240 6240 0 000000000000001708 3000 1532 2011 8 2821119JUF 型号8 10 LY3006240 6240 0 1468 2700 2072 2011 8 3021120JUF 型号8 10 LY3006240 6240 0 6283000 2612 2011 9 121121JUF 型号8 10 LY3006240 6240 0 38830002852 2011 8 2321122JUF 型号8 10 WHJ3007920 7920 0 00000000001680 2700 3000540 2011 8 2521123 ABT CHINA 60062RSLC3 8 10 WHJ3007920 7920 0 2460 3000 2460 2011 8 1821124中性 8 10 MKL3007920 7920 0 000003404 1500 2700316 2011 9 421125中性 8 10 LY3007920 7920 0 0000000000000000000000148300030001772 2011 9 721126型号 P5 DDP8 10 LY3007920 7920 0 122830003000692 2011 9 921127型号 P5 DDP8 10 LY3005760 5760 0 23083000452 2011 9 1021128UCR 型号8 10 LY3003360 3360 0 2548812 2011 8 2621129JUF 型号8 10 WHJ3003360 3360 0 0000000000000005402820 2011 8 2821130JUF 型号8 10 WHJ3003360 3360 0 1802700480 2011 8 1921131UCR 型号 C38 10 MKL3004320 4320 0 000000003284 1036 2011 9 1121132JUF 型号8 10 LY3003360 3360 0 000000000000000000000000000000021881172 2011 9 1321133中性 8 10 LY3006240 6240 0 18283000 2011 9 1521134JUF 型号8 10 LY3006240 6240 0 2011 9 1721135中性 8 10 LY3006240 6240 0 2011 8 3021136中性 8 10 WHJ3006240 6240 0 0000000000000000002220 3000 1020 2011 9 121137 BL CHINA 6002 2RSLC3 8 10 WHJ3006240 6240 0 198030001260 2011 8 2021138UCR 型号8 10 MKL3004800 4800 0 0000000002564 2236 2011 9 1821139CK 型号8 10 LY3002880 2880 0 0000000000000000000000000000000000 2011 9 2021140CK 型号8 10 LY3004800 4800 0 2011 9 2021141CK 型号8 12 LY3001248 1248 0 2011 9 2121142JUF 型号8 12 LY3001248 1248 0 2011 9 121143ACCOR 型号 两等分8 12 WHJ3001248 1248 0 000000000000000000001248 2011 9 221144ACCOR 型号 两等分8 12 WHJ3001248 1248 0 492 756 2011 8 2121145XRX 型号8 12 MKL3001200 1200 0 00000000464 736 2011 9 2121146 光板 外圈印BL CHINA 6003 2RSLC3 8 12 LY3001200 1200 0 00000000000000000000000000000000 2011 9 2121147BL CHINA 6003 ZC38 12 LY3001200 1200 0 2011 9 2221148XRX 型号8 12 LY3001200 1200 0 2011 9 2221149JUF 型号8 12 LY3001200 1200 0 2011 9 221150SF 型号 两等分8 12 WHJ3001200 1200 0 0000000000000000000001200 2011 9 321151XRX 型号8 12 WHJ3001200 1200 0 1044156 2011 8 2121152ACCOR 型号 两等分8 12 MKL3001200 1200 0 0000000001200 2011 9 2321153JUF 型号8 12 LY3001200 1200 0 00000000000000000000000000000000 2011 9 2321154中性 8 12 LY3001248 1248 0 2011 9 2321155ACCOR 型号 两等分8 12 LY3001248 1248 0 2011 9 2521156中性 8 12 LY3006048 6048 0 2011 9 521157ACCOR 型号 两等分8 12 WHJ3006048604800000000000000000000000 28443000204 2011 9 521158 BL CHINA 6004 2RSLC3 8 12 WHJ3002400 2400 0 2400 2011 8 2321159BL CHINA 6004 ZC38 12 MKL3004992 4992 0 0000000007643000 1228 2011 9 2821160JUF 型号8 12 LY3007008 7008 0 00000000000000000000000000000000 2011 9 3021161JUF 型号8 12 LY3006048 6048 0 2011 10 321162JUF 型号8 12 LY30010080 10080 0 2011 10 621163SF 型号 两等分8 12 LY30010080 10080 0 2011 9 721164UCR 型号8 12 WHJ3003552 3552 0 0000000000000000000000003963000156 2011 9 821165 外圈 ACCOR 型号 两等分 8 12 WHJ3003072 3072 0 2844228 2011 8 2521166CK 型号8 12 MKL3006048 6048 0 000000000001772 3000 1276 2011 10 1021167光板8 12 LY30010080 10080 0 00000000000000000000000000000000 2011 10 1221168 BL CHINA 6005 2RSLC3 8 12 LY3007008 7008 0 2011 10 1321169BL CHINA 6005 ZC38 12 LY3001824 1824 0 2011 10 1321170JUF 型号8 12 LY3001824 1824 0 2011 9 821171JUF 型号8 12 WHJ3001824 1824 0 0000000000000000000000000001824 2011 9 921172JUF 型号8 12 WHJ3001824 1824 0 948 876 2011 8 2621173JUF 型号8 12 MKL3001824 1824 0 00000000000001724100 2011 10 1421174 ABT CHINA 60062RSLC3 8 12 LY3001824 1824 0 00000000000000000000000000000000 2011 10 1821175中性 8 12 LY30012000 12000 0 2011 10 2221176中性 8 12 LY30012000 12000 0 2011 10 2621177型号 P5 DDP8 12 LY30012000 12000 0 2011 9 921178型号 P5 DDP8 12 WHJ3001512 1512 0 00000000000000000000000000001512 2011 9 1021179UCR 型号8 12 WHJ3001512 1512 0 612 900 2011 8 2621180JUF 型号8 12 MKL3001512 1512 0 000000000000001512 2011 10 2721181JUF 型号8 12 LY3002640 2640 0 00000000000000000000000000000000 2011 10 2821182UCR 型号 C38 12 LY3002640 2640 0 2011 10 2921183JUF 型号8 12 LY3002640 2640 0 2011 10 2921184中性 8 12 LY3002640 2640 0 2011 9 1121185JUF 型号8 12 WHJ3002640 2640 0 000000000000000000000000000002100540 2011 9 1121186中性 8 12 WHJ3001608 1608 0 1608 2011 8 2721187中性 8 12 MKL3001608 1608 0 000000000000001388220 2011 10 3021188 BL CHINA 6002 2RSLC3 8 12 LY3001608 1608 0 00000000000000000000000000000000 2011 10 3121189UCR 型号8 12 LY3001608 1608 0 2011 10 3121190CK 型号8 12 LY3001824 1824 0 2011 11 121191CK 型号8 12 LY3001824 1824 0 2011 9 1221192CK 型号8 14 WHJ3003600 3600 0 00000000000000000000000000008522748 2011 9 1321193JUF 型号8 14 WHJ3002016 2016 0 252 2011 8 2821194ACCOR 型号 两等分8 14 MKL3003600 3600 0 00000000000002480 1120 2011 11 221195ACCOR 型号 两等分8 14 LY3003600 3600 0 000000000000000000000000000000 2011 11 321196XRX 型号8 14 LY3003600 3600 0 2011 11 421197 光板 外圈印BL CHINA 6003 2RSLC3 8 14 LY3002400 2400 0 2011 11 521198BL CHINA 6003 ZC38 14 LY3002016 2016 0 2011 9 1421199XRX 型号8 14 WHJ3002400 2400 0 000000000000000000000000000000 2011 9 1521200JUF 型号8 14 WHJ3003600 3600 0 2011 8 2921201SF 型号 两等分8 14 MKL3003600 3600 0 000000000000001580 2020 2011 11 621202XRX 型号8 14 LY3003600 3600 0 000000000000000000000000000000 2011 11 721203ACCOR 型号 两等分8 14 LY3003600 3600 0 2011 11 821204JUF 型号8 14 LY3003600 3600 0 2011 11 921205中性 8 14 LY3003600 3600 0 2011 9 1621206ACCOR 型号 两等分8 14 WHJ3003600 3600 0 000000000000000000000000000000 2011 9 1721207中性 8 14 WHJ3003600 3600 0 2011 8 3021208ACCOR 型号 两等分8 14 MKL3003600 3600 0 0000000000000009802620 2011 11 1121209 BL CHINA 6004 2RSLC3 8 14 LY3003600 3600 0 000000000000000000000000000000 2011 11 1221210BL CHINA 6004 ZC38 14 LY3003600 3600 0 2011 11 1321211JUF 型号8 14 LY3003600 3600 0 2011 11 1421212JUF 型号8 14 LY3002400 2400 0 2011 9 1821213JUF 型号8 14 WHJ3002400 2400 0 000000000000000000000000000000 2011 9 1921214SF 型号 两等分8 14 WHJ3003600 3600 0 2011 8 3121215UCR 型号8 14 MKL3002016 2016 0 00000000000000003801636 2011 11 1421216 外圈 ACCOR 型号 两等分 8 14 LY3001800 1800 0 000000000000000000000000000000 2011 11 1621217CK 型号8 14 LY3004800 4800 0 2011 11 1821218光板8 14 LY3006000 6000 0 2011 11 2021219 BL CHINA 6005 2RSLC3 8 14 LY3006000 6000 0 2011 9 2121220BL CHINA 6005 ZC38 14 WHJ3006000 6000 0 000000000000000000000000000000 2011 9 2121221JUF 型号8 14 WHJ300 2424 0 2011 8 3121222JUF 型号8 14 MKL300 2424 0 0000000000000000024 2011 11 2121223JUF 型号8 14 LY300 37203720 0 000000000000000000000000000000 2011 11 2221224JUF 型号8 14 LY300 32643264 0 2011 11 2221225 ABT CHINA 60062RSLC3 8 14 LY300 9696 0 2011 11 2221226中性 8 14 LY300 9696 0 2011 9 2221227中性 8 14 WHJ300 816816 0 000000000000000000000000000000 2011 9 2321228型号 P5 DDP8 14 WHJ300 25682568 0 2011 9 121229型号 P5 DDP8 14 MKL300 36483648 0 00000000000000000 13402308 2011 11 2321230UCR 型号8 14 LY300936 936 0 000000000000000000000000000000 2011 9 221229型号 P5 DDP8 14 MKL300 36483648 0 0000000000000000006922956 2011 11 2321230UCR 型号8 14 LY300936 936 0 000000000000000000000000000000 2011 11 2621231JUF 型号8 15 LY3009000 9000 0 2011 11 2721232JUF 型号8 15 LY3003600 3600 0 2011 11 2921233UCR 型号 C38 15 LY3005000 5000 0 2011 12 221231JUF 型号8 15 LY3009000 9000 0 2011 12 321232JUF 型号8 15 LY3003600 3600 0 2011 12 521233UCR 型号 C38 15 LY3005000 5000 0 2011 10 2421081JUF 型号8 8 MKL3001000 1000 0 合计567104056710403600 360010800 108008100 10800108004500 810010800108008100 8100 9000 9000 9000 9000 9000 8100 8100 9000 90009000900089566000600060006000600060006000600060006000 101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010 101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010101010 9 139 149 159 169 179 189 199 209 219 229 239 249 259 269 279 289 299 3010 110 210 310 410 510 610 710 810 910 10 10 11 10 12 10 13 10 14 10 15 10 16 10 17 10 18 10 19 10 20 10 21 10 22 10 23 10 24 10 25 10 26 10 27 10 28 10 29 10 30 10 3111 111 211 311 411 511 611 711 811 911 10 11 11 11 12 11 13 11 14 11 15 11 16 11 17 二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日一二三四 1412 158830001652 134830001892 000011081772 12283000572 1248 1180 68 00000000 1200 1200 532 668 1200 000000000 1132 68 1248 1248 43630002612 00000000000038830003000620 23803000668 2332300030001748 1252300030002828 00000000000000000000000172300030003000908 209230001916 1084740 1824 0000000000000000000000000000004361388 16123000300030001388 16123000300030001388 16123000300030001388 0000000000000000000000000000000000000000000 16121028 1972668 2332308 2640 000000000000000000000000000000000000000000 000052 1556 1444164 1824 1012812 1764 0000000000000000000000000000000000000000000000000 21881412 15882012 9881412 1588428 12361164 18361764 00000000000000000000000000