智能排程工具Excel表.xls

备备注注: :各各款款的的生生产产天天数数已已除除去去每每月月4 4天天休休息息, ,及及每每周周2 2个个晚晚上上休休息息. . 车间组 别客户 业务 组 team 系列 prog 离开 hk最 后客期 生 产 月 份 产 品 类 型 款 号 件 数 日产 量 计划 排 序 计 划 生 产 天 数 1组xxxa1order6/285f1032437816301.0128 1组xxxa2order6/276g30 5131234201.0212 1组xxxa3sample6/307fsag-305619101.032 1组xxxb1sample7/307w198243 13151.041 1组xxxb1sample7/307w19824513151.051 1组xxxb1sample7/307p062 1组xxxb1sample7/307w19824713151.071 1组xxxb1sample7/307p082 1组xxxb1sample7/307w208256 10151.091 1组xxxb1sample7/307w198246 13151.101 1组xxxb1sample7/307p111 1组xxxb1sample7/307w208257 10151.121 1组xxxb1sample7/307w19824413151.131 1组xxxb1sample7/307w198248 10151.141 1组xxxb1sample7/307n288238 7151.151 1组xxxb1sample7/307w 1906776151.161 1组xxxb1sample7/307w198243 13151.171 1组xxxb1sample7/307p181 1组xxxb1sample7/307w 1908857151.191 1组xxxb1sample7/307w1905306151.201 1组xxxb1sample7/307w 1908839151.211 1组xxxb1sample7/307w 1908849151.221 1组xxxa1order8/257gl21001 645251.2326 4组xxxb1sample7/308 p1308759104.021 2组xxxa1order6/285f1032436500302.0117 2组xxxa3order6/276n30 410201126302.025 2组xxxa2order6/296n20-517501340352.0310 2组xxxb1sample7/306w2082524102.041 2组xxxb1sample7/307w2082534102.051 2组xxxb1sample7/307w208251 10102.061 2组xxx331order7/157g32391200252.078 2组xxxb1sample7/307w208249 19102.082 2组xxxb1sample7/307w20825010102.091 2组xxxb1sample7/307w20825510102.101 2组xxxb1sample7/307w208254 4102.111 2组xxxb1sample7/307w2006874152.121 2组xxxb1sample7/307w2006849152.131 2组xxxb1sample7/307w2008947152.141 2组xxxb1sample7/307w2006824152.151 2组xxxb1sample7/307w2008957152.161 2组xxxb1sample7/307w2006975152.171 2组xxxb1sample7/307w2008979152.181 2组xxxb1sample7/307w2008979152.031 2组xxxb1sample7/307w2008967152.021 2组xxxb1sample7/307w2008437152.031 2组xxxb1sample7/307w2006864152.011 3组xxxa2sample5/315g01771183203.015 3组xxxa3order5/316pae8b184253.028 3组xxxa3order6/286pae8b571253.0323 3组xxxb1sample7/307 p1306527103.041 3组xxxb1sample7/307 p1308789103.051 3组xxxb1sample7/307 p130880753.032 3组xxxa1order8/257gl11060362253.1115 3组xxxb1sample7/307 p1308777103.021 3组xxxb1sample7/307 p1407823103.041 3组xxxb1sample7/307 p1407833103.051 3组xxxb1sample7/307 p130794753.022 4组xxxa2sample5/255g30 213142154.013 4组xxxa1sample5/125p3322845154.023 4组xxxa1sample5/125g3322934154.033 4组xxx317order6/275g30 4102126204.047 4组xxxa2order6/276g30-2179471204.0524 4组xxxa2order7/106g60-3178242254.0610 4组xxxb1sample7/307p071 4组xxxb1sample7/307pu1382357104.081 4组xxxb1sample7/307091 4组xxxb1sample7/307f3108819104.101 4组xxxb1sample7/307n2906673104.011 4组xxxb1sample7/307n2906683104.021 4组xxxb1sample7/307f3108157104.031 4组xxxb1sample7/307n2908872104.011 4组xxxb1sample7/307f3108825104.011 4组xxxb1sample7/307 p1308739104.011 4组xxxb1sample7/308 p1308739104.011 5组xxxa2sample5/255f20 618934155.013 5组xxxa3sample5/265nsscm8111255.025 5组xxxa2sample5/255g60 512441105.035 5组xxxa3sample5/265nssem5121255.045 5组xxx316order6/275n30 513101234255.0510 5组xxxa3sample5/126nsag-128937155.063 5组xxxa2order6/296g20-5175340305.0712 6组xxxa2sample5/255g20 4151 56156.014 6组xxxa2sample5/315g01769141106.025 6组xxxa2sample5/315g01770242106.035 6组xxxa2order6/275g30-5153a1256.04# 6组xxxa3sample7/37naf2a203306.057 6组xxxa3sample7/107naf3h203306.067 6组xxxb1sample7/307 p1306547106.021 6组xxxb1sample7/307 p1408743106.041 7组xxxa2order6/296g20-2175387257.0116 7组xxxa2sample5/255n20 618734157.023 7组xxxa1order6/285f1032433 600307.0320 1组xxxa2order6/276g30-5153420257.0417 7组xxxa1 办6/306dl11083117.051 7组xxxa1 办6/306nl11087417.064 7组xxxa1 办6/307nl12081-l117.071 7组xxxa1 办6/307nl12101117.081 7组xxxa3sample7/146dal4l171207.099 7组xxxa3sample7/147dal4m 203257.109 7组xxxb1sample7/307w288239 7107.111 7组xxxb1sample7/307w2882407107.121 7组xxxb1sample7/307w2006894107.131 7组xxxb1sample7/307w2006795107.141 7组xxxb1sample7/307w2006959107.151 7组xxxb1sample7/307w2008987107.161 7组xxxb1sample7/307w2006812107.171 7组xxxb1sample7/307 p1306507107.181 7组xxxb1sample7/307 g11086910107.191 7组xxxa1order8/258nl12081-l300357.059 7组xxxb1sample7/308 p1308767107.021 调 整 参 数 周 日 调 整 计 划 开 裁 计 划 出 成 品 计 划 完 成 计 划 出 货 空 挡 检 查 面面料料 齐齐备备 估估计计 车车缝缝 辅辅料料 齐齐备备 估估计计 包包装装 辅辅料料 齐齐备备 估估计计 平均 产量 实际 实际 生产 天数 面料 齐备 实际 445/75/105/306/128 225/236/16/156/1711 106/207/37/67/9(8) 106/267/67/67/822 106/277/67/77/921 106/247/77/87/1020 106/277/87/97/1119 106/257/137/147/1614 106/257/147/147/1614 106/277/127/127/1416 106/227/127/137/1515 106/267/197/197/219 106/267/177/177/1912 106/277/187/187/2010 106/257/217/217/237 107/57/217/217/237 106/267/187/187/2010 106/227/197/197/219 107/47/207/207/228 107/67/217/217/237 107/47/217/227/247 107/47/217/217/237 447/87/188/168/187 107/58/168/178/19(20) 335/175/206/96/1118 105/186/136/176/198 225/206/196/307/2(3) 106/236/307/17/327 106/237/17/17/327 106/227/17/27/426 226/197/17/137/151 106/227/137/147/1614 106/227/137/147/1615 106/247/147/157/1714 106/237/177/177/1911 107/37/177/177/1911 106/307/187/187/2010 106/307/207/207/228 107/37/207/207/228 107/37/207/217/237 106/307/247/247/264 107/57/247/247/264 10 7/5 7/247/257/273 107/57/287/287/300 107/57/297/297/31(1) 107/37/287/287/300 105/115/175/295/311 225/166/16/126/15(14) 备备注注: :各各款款的的生生产产天天数数已已除除去去每每月月4 4天天休休息息, ,及及每每周周2 2个个晚晚上上休休息息. . 446/106/137/107/10(11) 107/77/107/107/1218 107/57/217/217/237 107/77/217/237/255 337/87/238/98/1114 107/57/297/297/31(1) 107/57/297/308/1(1) 107/77/307/308/1(2) 107/77/318/18/3(4) 104/245/45/65/817 105/95/195/275/29(16) 105/35/135/295/31(18) 105/185/306/86/1018 445/316/66/276/29(1) 226/156/277/107/12(1) 106/247/107/117/1318 106/247/117/117/1317 106/227/127/137/1516 107/37/137/137/1515 106/307/137/137/1515 106/307/137/137/1515 107/37/137/147/1614 107/77/147/147/1614 107/87/207/207/228 106/307/267/267/282 106/308/18/18/3(4) 104/245/45/65/817 105/105/65/105/1214 104/245/45/85/1015 105/105/296/16/3(7) 225/175/266/96/1117 106/56/136/156/28(46) 226/86/187/17/3(3) 104/305/105/135/1510 105/115/225/265/311 105/115/165/206/2(1) #value! #value!5/285/316/196/217 106/167/17/57/7(3) 106/167/37/107/101 106/307/107/107/1218 106/307/107/117/1318 335/316/66/277/3(3) 105/75/105/235/251 335/125/156/86/1019 335/246/157/57/5(7) 106/156/206/256/301 106/146/206/256/301 106/177/17/17/10 106/177/17/17/10 226/166/277/77/95 226/177/77/137/150 106/267/177/177/1911 106/267/177/177/1911 107/57/177/187/2010 107/67/187/187/2010 107/67/217/217/237 107/67/217/227/246 107/67/257/257/273 107/57/317/318/2(3) 107/77/318/18/3(4) 227/308/18/48/620 107/98/48/48/6(7) 车缝 辅料 齐备 实际 包装 辅料 齐备 实际 制单 实际 pp 办 资料 实际 pp 办 完成 收回 pp 办 齐码 纸样 实际 裁 齐 日 上 车 位 实 际 实 际 完 成产品名称 4/264/265/31女装抓毛裤(包边） 5/245/196/15男装2lgtx压胶夹克 6/206/247/5女裝非压胶長褸 6/256/297/5男装洗水短袖衬衫 6/246/267/9男装洗水短袖衬衫 6/256/307/8男装压胶夹克(短) 6/256/297/10男装洗水短袖衬衫 6/256/307/11男装压胶夹克(短) 6/226/297/12男装洗水长裤 6/256/297/15男装洗水短袖衬衫 6/217/37/13男装压胶夹克 6/226/297/12男装洗水长裤 6/256/267/5男装洗水短袖衬衫 6/256/297/17男装洗水长袖衬衫 6/247/107/17男装非压胶风衣 7/87/107/17女装普洗短袖衬衫 6/256/297/18男装洗水短袖衬衫 6/217/37/14男装压胶夹克 7/77/107/19男装普洗短袖衬衫 7/107/107/207/20女装普洗长袖衬衫 7/97/107/20男装普洗短袖衬衫 7/97/107/20男装普洗短袖衬衫 7/77/67/29男装3l gore压胶裤, 13mm 7/87/147/147/297/29男装专业短压胶衣 5/135/116/11女装抓毛夹克 5/306/16/16女装间棉茄克 6/116/86/86/306/30内胆 6/256/287/3男装洗水长裤 6/256/287/1男装洗水长裤 6/286/307/6男装洗水长裤 6/206/207/12bivi bag 睡袋 6/286/307/13男装洗水中裤 6/286/307/15男装洗水长裤 6/247/67/14男装洗水长裤 6/286/307/17男装洗水长裤 7/107/117/19男装弹力长裤 7/77/117/18男装洗水长裤 7/77/117/20男装洗水短裤 7/77/87/207/20男装洗水长裤 7/97/117/21男装洗水长裤 7/97/117/247/24男装洗水长裤 7/87/117/247/24女装弹性裤 7/87/117/26女装弹性裤 7/87/117/27男装弹力长裤 7/87/117/27女装弹性长城裤 7/87/118/28/2男装弹力短裤 5/105/125/29男装goretex三层压胶长裤 5/165/166/12两层夹棉压胶夹克 6/266/57/11两层夹棉压胶夹克 7/87/107/20女装专业压胶夹克 7/77/77/24男装普通压胶短夹克 7/37/147/24女装甩抓毛压胶夹克 7/117/77/27男装2l gore压胶夹克 7/37/137/27男装普通压胶长夹克 7/87/147/147/317/31男装压胶雨裤 7/87/147/147/317/31女装压胶雨裤 7/147/147/147/31男装甩抓毛压胶短夹克 5/45/45/24女装gtx2l压胶茄克 5/125/125/26男装夾棉茄克 5/135/155/27女装夹棉夹克 5/235/176/7女装2l压胶茄克gtx 5/315/276/27女装2l压胶茄克gtx 6/156/156/157/87/8女装2l gore压胶夹克 6/217/37/10男装压胶夹克(长) 6/217/37/11男装压胶夹克(长) 6/247/57/12男装非压胶风衣 7/67/77/137/13男装抓毛衣 7/17/57/57/157/15女装弹性夹克 7/17/57/57/157/15女装弹性背心 7/17/67/157/15男装445gm抓毛夹克 7/57/147/197/19男装弹性夹克 7/77/147/257/25男装抓毛衣 7/97/147/147/297/29男装专业长压胶衣 7/97/147/317/31男装专业长压胶衣 5/45/45/24男装茄克（不压胶无里） 5/105/125/29男裝尼龍短褲 5/35/45/25男装gtx2l压胶茄克 5/105/175/30男裝尼龍短褲 5/265/256/11男装夹棉夹克 6/56/56/15男裝短褲 6/86/76/306/30男装2层gtx压胶夹克 5/95/105/24女装gtx2l压胶茄克 5/115/125/26女装goretex三层压胶夹克 5/115/165/30男装goretex三层压胶夹克 5/255/236/20男装2lgtx压胶夹克 6/176/197/6男裝非壓膠夾克 6/196/287/11女裝非壓膠夾克 7/97/117/118/28/2男装二层半压胶衣 7/57/58/28/2男装压胶裤 5/316/26/26/276/27女装2l gore压胶夹克 5/35/35/12男装背心（不压胶无里） 5/84/286/5男装抓毛夹克 6/85/237/3男装2lgtx压胶夹克 6/156/166/26男装夹棉夹克 6/146/166/26男装羽绒背心 6/177/17/1女装夹棉夹克(l12081款内胆) 6/177/17/1女装夹棉夹克 6/176/207/7男裝羽絨背心 6/196/227/14女裝羽絨背心 6/287/37/15男装洗水夹克(长) 6/287/37/17男装洗水夹克(短) 7/97/97/157/197/19男装普洗长裤 7/77/157/207/20女装洗水长裤 7/17/67/247/24男装洗水长裤 7/87/157/157/247/24男装洗水长裤 7/17/68/28/2女装洗水长裤 7/87/147/148/18/1男装专业压胶夹克 7/177/187/188/18/1男装gore普通压胶夹克 7/267/77/31女装夹棉夹克(l12081款内胆) 7/97/277/278/38/3女装专业压胶夹克 上 料 期 更 改 上 料 期 更 改 货 期 离 开 h k 计 划 回 复 交 期 4/116/286/146/28 4/286/276/27xxxxxxa11组3 4/286/307/10xxxxxxa12组 绣花3天 6/207/307/30xxxxxxa13组g 6/207/307/30xxxxxxa14组p 6/207/307/30xxxxxxa15组n 6/207/307/30xxxxxxa16组f 6/207/307/30xxxxxxa27组d 6/207/307/30xxxxxxa28组w 6/207/307/30xxxxxxa29组k 6/207/307/30xxxxxxa210组com 6/207/307/30xxxxxxa111组for 6/207/307/30xxxxxxa212组bf 6/207/307/30xxxxxxa313组头办 6/207/307/30xxxxxx33114组复办 6/307/307/30xxxxxxb1 15组影相办 6/207/307/30xxxxxxa316组齐码办 6/207/307/30xxxxxxa31a组颜色办 6/307/307/30xxxxxxa11b组 测试办 6/307/307/30xxxxxxa12a组 特殊办 6/307/307/30xxxxxxa32b组 小样 6/307/307/30xxxxxxa23a组 pp办 6/258/259/15xxxxxxa33b组 6/307/307/30xxxxxxa34组 4/116/286/146/28xxxxxxb1小办房 4/286/276/27xxxxxxlw5组 5/106/296/29xxxxxxa16组 6/207/307/30xxxxxxa17组 6/207/307/30xxxxxxa39组 6/207/307/30xxxxxxa110组 5/16/157/157/20xxxxxxa311组 6/207/307/30xxxxxxa2 6/207/307/30xxxxxx313 6/207/307/30xxxxxx313 6/207/307/30xxxxxxa3 6/307/307/30xxxxxxa3 6/307