Excel 怎么同时冻结首行和首列?

在 Cue Office 打开 Excel 工作簿(.xlsx),选中 B2,再选 View → Freeze Panes → Freeze Panes at Selection。库存表向右看日期、向下找库位时,第 1 行和 A 列都能留在视野里。

同时冻结首行和首列,为什么选 B2?

先点 B2。按选区冻结会把选中单元格上方的行和左侧的列固定住。B2 的上方是第 1 行,左侧是 A 列,正好把这张表的日期和库位编号留在屏幕边缘。

名称框显示 B2,网格中首行是表头、A 列是库位编号
选中的 B2 在表头下方、库位编号右侧。

打开 View → Freeze Panes,选择 Freeze Panes at Selection。如果原始数据是 CSV,先用 Save As 另存为 XLSX,再在工作簿里设置冻结。

Freeze Panes 下拉菜单包含 Freeze Panes at Selection 和 Unfreeze Panes
同一菜单也提供只冻结首行、只冻结首列和解除冻结的命令。

向右向下移动,怎么确认冻结生效?

保存并重开工作簿。点 B2,连续按右方向键,直到后面的日期进入视野,再向下滚动。在本例里,G 列已经移到 A 列旁边,第 76 行附近的记录也进入了视野。看左上角,A 列和第 1 行还在原位,就说明两个方向都已冻结。

重开后,滚动区域从 G 列、第 76 行开始,A 列及第 1 行仍在
第 1 行的日期和 A 列的库位编号仍能对上后面的库存数。

要让整张表恢复滚动,打开 View → Freeze Panes → Unfreeze Panes。再向右移动或向下滚动,第 1 行和 A 列就能移出视野。

解除冻结后,滚动视图左上显示 F 列和第 150 行
继续滚动时,原先固定的表头和 A 列都可以移出视野。

用 Cue AI 区分日期行和库位列

交接盘点表时,可以让日期行和库位列用不同样式,便于沿着表头找数字。在 Home 工具栏打开 Cue AI,发送下面的提示词。换成自己的库存表时,改成实际的工作表名和范围。

Home 工具栏中选中的 Cue AI 按钮,以及 Cue AI 面板标题栏
从 Home 打开 Cue AI,可在表格旁指定要调整的区域。
请在 Sheet1 为冻结区域设置格式。将 A1:BA1 设为深蓝色底、白字加粗,将 A2:A181 设为浅蓝色底、深色字加粗,让库位编号容易辨认。请把格式实际应用到工作簿,保留所有单元格的值以及已经冻结的首行和首列。

格式写回后,保存并重开,再向右移动、向下滚动。深色界面中的颜色可能和文件里设置的颜色不同,可以看表头和库位编号是否用不同样式、是否加粗。沿着 Day 04 和 BIN-076 找到两者交会处,核对数量仍是 42,同时确认第 1 行和 A 列依然固定。

AI 格式写回并重开后,滚动视图中表头及库位编号仍固定,颜色突出
深色界面中表头呈浅蓝色,库位编号用蓝色粗体显示。

用库存表跟做

展开完整库存案例

练习表记录 180 个库位和 50 天的库存。可把下面的数据保存为 CSV,用 Cue Office 打开并另存为 XLSX,然后按前面的步骤冻结窗格。

Bin ID,Supply,Unit,Day 01,Day 02,Day 03,Day 04,Day 05,Day 06,Day 07,Day 08,Day 09,Day 10,Day 11,Day 12,Day 13,Day 14,Day 15,Day 16,Day 17,Day 18,Day 19,Day 20,Day 21,Day 22,Day 23,Day 24,Day 25,Day 26,Day 27,Day 28,Day 29,Day 30,Day 31,Day 32,Day 33,Day 34,Day 35,Day 36,Day 37,Day 38,Day 39,Day 40,Day 41,Day 42,Day 43,Day 44,Day 45,Day 46,Day 47,Day 48,Day 49,Day 50
BIN-001,Packing tape,pack,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29
BIN-002,Label roll,pack,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42
BIN-003,Small carton,pack,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55
BIN-004,Mailing sleeve,pack,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68
BIN-005,Bubble wrap,pack,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81
BIN-006,Packing tape,pack,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94
BIN-007,Label roll,pack,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17
BIN-008,Small carton,pack,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30
BIN-009,Mailing sleeve,pack,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43
BIN-010,Bubble wrap,pack,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56
BIN-011,Packing tape,pack,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69
BIN-012,Label roll,pack,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82
BIN-013,Small carton,pack,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95
BIN-014,Mailing sleeve,pack,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18
BIN-015,Bubble wrap,pack,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31
BIN-016,Packing tape,pack,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44
BIN-017,Label roll,pack,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57
BIN-018,Small carton,pack,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70
BIN-019,Mailing sleeve,pack,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83
BIN-020,Bubble wrap,pack,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6
BIN-021,Packing tape,pack,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19
BIN-022,Label roll,pack,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32
BIN-023,Small carton,pack,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45
BIN-024,Mailing sleeve,pack,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58
BIN-025,Bubble wrap,pack,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71
BIN-026,Packing tape,pack,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84
BIN-027,Label roll,pack,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7
BIN-028,Small carton,pack,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20
BIN-029,Mailing sleeve,pack,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33
BIN-030,Bubble wrap,pack,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46
BIN-031,Packing tape,pack,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59
BIN-032,Label roll,pack,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72
BIN-033,Small carton,pack,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85
BIN-034,Mailing sleeve,pack,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8
BIN-035,Bubble wrap,pack,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21
BIN-036,Packing tape,pack,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34
BIN-037,Label roll,pack,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47
BIN-038,Small carton,pack,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60
BIN-039,Mailing sleeve,pack,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73
BIN-040,Bubble wrap,pack,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86
BIN-041,Packing tape,pack,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9
BIN-042,Label roll,pack,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22
BIN-043,Small carton,pack,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35
BIN-044,Mailing sleeve,pack,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48
BIN-045,Bubble wrap,pack,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61
BIN-046,Packing tape,pack,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74
BIN-047,Label roll,pack,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87
BIN-048,Small carton,pack,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10
BIN-049,Mailing sleeve,pack,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23
BIN-050,Bubble wrap,pack,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36
BIN-051,Packing tape,pack,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49
BIN-052,Label roll,pack,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62
BIN-053,Small carton,pack,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75
BIN-054,Mailing sleeve,pack,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88
BIN-055,Bubble wrap,pack,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11
BIN-056,Packing tape,pack,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24
BIN-057,Label roll,pack,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37
BIN-058,Small carton,pack,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50
BIN-059,Mailing sleeve,pack,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63
BIN-060,Bubble wrap,pack,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76
BIN-061,Packing tape,pack,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89
BIN-062,Label roll,pack,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12
BIN-063,Small carton,pack,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25
BIN-064,Mailing sleeve,pack,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38
BIN-065,Bubble wrap,pack,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51
BIN-066,Packing tape,pack,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64
BIN-067,Label roll,pack,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77
BIN-068,Small carton,pack,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90
BIN-069,Mailing sleeve,pack,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13
BIN-070,Bubble wrap,pack,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26
BIN-071,Packing tape,pack,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39
BIN-072,Label roll,pack,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52
BIN-073,Small carton,pack,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65
BIN-074,Mailing sleeve,pack,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78
BIN-075,Bubble wrap,pack,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91
BIN-076,Packing tape,pack,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14
BIN-077,Label roll,pack,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27
BIN-078,Small carton,pack,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40
BIN-079,Mailing sleeve,pack,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53
BIN-080,Bubble wrap,pack,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66
BIN-081,Packing tape,pack,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79
BIN-082,Label roll,pack,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92
BIN-083,Small carton,pack,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15
BIN-084,Mailing sleeve,pack,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28
BIN-085,Bubble wrap,pack,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41
BIN-086,Packing tape,pack,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54
BIN-087,Label roll,pack,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67
BIN-088,Small carton,pack,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80
BIN-089,Mailing sleeve,pack,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93
BIN-090,Bubble wrap,pack,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16
BIN-091,Packing tape,pack,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29
BIN-092,Label roll,pack,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42
BIN-093,Small carton,pack,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55
BIN-094,Mailing sleeve,pack,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68
BIN-095,Bubble wrap,pack,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81
BIN-096,Packing tape,pack,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94
BIN-097,Label roll,pack,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17
BIN-098,Small carton,pack,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30
BIN-099,Mailing sleeve,pack,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43
BIN-100,Bubble wrap,pack,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56
BIN-101,Packing tape,pack,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69
BIN-102,Label roll,pack,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82
BIN-103,Small carton,pack,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95
BIN-104,Mailing sleeve,pack,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18
BIN-105,Bubble wrap,pack,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31
BIN-106,Packing tape,pack,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44
BIN-107,Label roll,pack,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57
BIN-108,Small carton,pack,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70
BIN-109,Mailing sleeve,pack,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83
BIN-110,Bubble wrap,pack,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6
BIN-111,Packing tape,pack,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19
BIN-112,Label roll,pack,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32
BIN-113,Small carton,pack,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45
BIN-114,Mailing sleeve,pack,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58
BIN-115,Bubble wrap,pack,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71
BIN-116,Packing tape,pack,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84
BIN-117,Label roll,pack,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7
BIN-118,Small carton,pack,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20
BIN-119,Mailing sleeve,pack,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33
BIN-120,Bubble wrap,pack,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46
BIN-121,Packing tape,pack,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59
BIN-122,Label roll,pack,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72
BIN-123,Small carton,pack,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85
BIN-124,Mailing sleeve,pack,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8
BIN-125,Bubble wrap,pack,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21
BIN-126,Packing tape,pack,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34
BIN-127,Label roll,pack,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47
BIN-128,Small carton,pack,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60
BIN-129,Mailing sleeve,pack,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73
BIN-130,Bubble wrap,pack,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86
BIN-131,Packing tape,pack,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9
BIN-132,Label roll,pack,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22
BIN-133,Small carton,pack,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35
BIN-134,Mailing sleeve,pack,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48
BIN-135,Bubble wrap,pack,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61
BIN-136,Packing tape,pack,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74
BIN-137,Label roll,pack,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87
BIN-138,Small carton,pack,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10
BIN-139,Mailing sleeve,pack,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23
BIN-140,Bubble wrap,pack,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36
BIN-141,Packing tape,pack,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49
BIN-142,Label roll,pack,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62
BIN-143,Small carton,pack,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75
BIN-144,Mailing sleeve,pack,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88
BIN-145,Bubble wrap,pack,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11
BIN-146,Packing tape,pack,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24
BIN-147,Label roll,pack,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37
BIN-148,Small carton,pack,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50
BIN-149,Mailing sleeve,pack,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63
BIN-150,Bubble wrap,pack,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76
BIN-151,Packing tape,pack,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89
BIN-152,Label roll,pack,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12
BIN-153,Small carton,pack,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25
BIN-154,Mailing sleeve,pack,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38
BIN-155,Bubble wrap,pack,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51
BIN-156,Packing tape,pack,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64
BIN-157,Label roll,pack,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77
BIN-158,Small carton,pack,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90
BIN-159,Mailing sleeve,pack,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13
BIN-160,Bubble wrap,pack,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26
BIN-161,Packing tape,pack,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39
BIN-162,Label roll,pack,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52
BIN-163,Small carton,pack,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65
BIN-164,Mailing sleeve,pack,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78
BIN-165,Bubble wrap,pack,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91
BIN-166,Packing tape,pack,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14
BIN-167,Label roll,pack,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27
BIN-168,Small carton,pack,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40
BIN-169,Mailing sleeve,pack,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53
BIN-170,Bubble wrap,pack,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66
BIN-171,Packing tape,pack,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79
BIN-172,Label roll,pack,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92
BIN-173,Small carton,pack,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15
BIN-174,Mailing sleeve,pack,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28
BIN-175,Bubble wrap,pack,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41
BIN-176,Packing tape,pack,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54
BIN-177,Label roll,pack,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67
BIN-178,Small carton,pack,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93,20,37,54,71,88,15,32,49,66,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80
BIN-179,Mailing sleeve,pack,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16,33,50,67,84,11,28,45,62,79,6,23,40,57,74,91,18,35,52,69,86,13,30,47,64,81,8,25,42,59,76,93
BIN-180,Bubble wrap,pack,83,10,27,44,61,78,95,22,39,56,73,90,17,34,51,68,85,12,29,46,63,80,7,24,41,58,75,92,19,36,53,70,87,14,31,48,65,82,9,26,43,60,77,94,21,38,55,72,89,16
库存练习表顶部含库位、物料、单位和每日数量
完整练习数据涵盖 180 个库位和 50 天,图中是成品的开头。

把库存表交给下一班

下一班查库存时,通常已经知道库位和日期。拿到新表后,可以把日期行和库位列的实际范围告诉 Cue AI,请它分别设置格式。交接前挑一个靠后的日期,再找一个靠下的库位,沿着固定的日期行和编号列读出数量,让同事也能按同样的路线查到这一笔。

如果要核对到货,在 Cue Office 免费查看供应商的 PDF 送货单(.pdf),再和 Excel 库存表(.xlsx)逐项对照。用 Word 文档(.docx)记下待复核的库位,或把缺货和补货安排写进 PowerPoint 交接简报(.pptx)。Cue Office 免费提供表格、文档和演示文稿编辑工具。

免费下载 Cue Office