Spreadsheet: 63477d1264410002-if-formula-for-duplicate-data-problem-4
Sheet: Racks

 |  | Rack Type | Rack Number | Slot Number |  | SAP Code | Product Stocked | Pack Qty | Slot Capacity | [NAME] | [NAME] | Closing Stock
 |  | Concertina | 1 | 28 | 1 | 2001362 | FOP 6.0 GN G 3210x2250 LS 18 | 18 | 36 | 0 | 1 | 20
 |  | Concertina | 1 | 27 | 1 | 2000974 | FOP 4.0 GN G 3210x2250 LS 28 | 28 | 56 | 0 | 12 | 46
 |  | Concertina | 1 | 26 | 1 | 2001469 | FOP10.0 GY G 3210x2250 LS 11 | 11 | 22 | 0 | 1 | 14
 |  | Concertina | 1 | 25 | 1 | 2002401 | FOP 6.0 GY G 3210x2250 LS 18 | 18 | 36 | 0 | 2 | 22
 |  | Concertina | 1 | 24 | 1 | 2001011 | FOP 4.0 GY G 3210x2250 LS 28 | 28 | 56 | 0 | 2 | 35
 |  | Concertina | 1 | 23 | 1 | 2057813 | FAB 4.0 AB G 3210x2250 LS 28 | 28 | 56 | 0 | 0 | 32
 |  | Concertina | 1 | 22 | 1 | 2057817 | FAB 6.0 AB G 3210x2250 LS 18 | 18 | 36 | 0 | 0 | 16
 |  | Concertina | 1 | 21 | 1 | 2001196 | FOP 6.0 BZ G 3210x2250 LS 18 | 18 | 36 | 0 | 3 | 14
 |  | Concertina | 1 | 20 | 1 | 2006567 | FOP10.0 BZ G 3210x2250 LS 15 | 15 | 30 | 0 | 3 | 16
 |  | Concertina | 1 | 19 | 1 | 2000622 | FOP 4.0 BZ G 3210x2250 LS 28 | 28 | 56 | 0 | 3 | 40
 |  | Concertina | 1 | 18 | 1 | 2002056 | RPS 7.0 CL G 3500x1985 SS 20 | 20 | 40 | 0 | 1 | 0
 |  | Concertina | 1 | 17 | 1 | 2002135 | RPT 7.0 CL G 3500x1985 SS 20 | 20 | 40 | 0 | 0 | 0
 |  | Concertina | 1 | 16 | 1 | 2056721 | 8.8mm [NAME] | 10 | 20 | 10 | 4 | 19
 |  | Concertina | 1 | 15 | 1 | 2056715 | 8.8mm [NAME] | 10 | 20 | 10 | 5 | 24
 |  | Concertina | 1 | 14 | 1 | 2057008 | 6.8mm [NAME] | 20 | 40 | 20 | 28 | 26
 |  | Concertina | 1 | 13 | 1 | 2051846 | SMP 6.0 GY   3210x2250 LS 25 | 25 | 50 | 0 | 1 | 6
 |  | Concertina | 1 | 12 | 1 | 2054920 | SMP 6.0 BZ   3210x2000 LS 20 | 20 | 40 | 20 | 8 | 18
 |  | Concertina | 1 | 11 | 1 | 2057004 | 6.4mm Optilam Grey A/S Stk - 3210x2250 | 20 | 40 | 0 | 1 | 13
 |  | Concertina | 1 | 10 | 1 | 2056724 | 6.4mm [NAME] 6028 - 3210x2550 | 20 | 40 | 0 | 4 | 12
 |  | Concertina | 1 | 9 | 1 | 2056681 | 6.4mm [NAME] | 20 | 40 | 80 | 83 | 24
 |  | Concertina | 1 | 8 | 1 | 2056711 | 6.4mm [NAME] 3065 Stk - 3210x2550 | 20 | 40 | 1 | 3 | 11
 |  | Concertina | 1 | 7 | 1 | 2056673 | 6.4mm [NAME] | 20 | 40 | 80 | 49 | 31
 |  | Concertina | 1 | 6 | 1 | 2056717 | 11.5mm [NAME] | 10 | 20 | 10 | 2 | 15
 |  | Concertina | 1 | 5 | 1 | 2056705 | 10.8mm [NAME] | 10 | 20 | 40 | 28 | 18
 |  | Concertina | 1 | 4 | 1 | 2056708 | 7.5mm [NAME] | 18 | 36 | 0 | 0 | 0
 |  | Concertina | 1 | 3 | 1 | 2056697 | 6.8mm [NAME] | 20 | 40 | 40 | 23 | 39
 |  | Concertina | 1 | 2 | 1 | 2001806 | RYF 6.0 CL G 3300x1985 LS 21 | 21 | 42 | 84 | 70 | 14
 |  | Concertina | 1 | 1 | 1 | 2001788 | RYC 6.0 CL G 3300x1985 LS 21 | 21 | 42 | 0 | 0 | 0
 |  |  |  |  | 28
 |  |  | Number of Rack Slots |  |  | 28
 |  |  | Number of Rack Slots @ Month End |  |  | 24
 |  |  | Number of Empty Racks |  |  | 4
 |  |  | Rack Utilisation |  |  | 0.8571428571428571
 |  |  | Total Sheets Capacity |  |  | 1070
 |  |  | Total Sheets @ Month End |  |  | 525
 |  |  | Stock Rack Used during Month (Sold) |  |  | 18
 |  |  | Stock Sold Utilisation |  |  | 0.6428571428571429
 |  | Rack Type | Rack Number | Slot Number |  | SAP Code | Product Stocked | Pack Qty | Slot Capacity | [NAME] | [NAME] | Closing Stock
 |  | Concertina | 2 | 1 | 1 | 2001435 | FOP10.0 CL G 3210x2250 LS 11 | 11 | 22 | 0 | 0 | 0
 |  | Concertina | 2 | 2 | 1 | 2001435 | FOP10.0 CL G 3210x2250 LS 11 | 11 | 22 | 0 | 0 | 0
 |  | Concertina | 2 | 3 | 1 | 2002405 | FOP 8.0 CL G 3210x2250 LS 14 | 14 | 28 | 0 | 0 | 0
 |  | Concertina | 2 | 4 | 1 | 2006185 | FOP 6.0 CL G 3210x2250 LS 23 | 23 | 46 | 133 | 161 | 4
 |  | Concertina | 2 | 5 | 1 | 2001079 | FOP 5.0 CL G 3210x2250 LS 22 | 22 | 44 | 0 | 2 | 34
 |  | Concertina | 2 | 6 | 1 | 2056874 | 6.4mm [NAME] | 20 | 40 | 0 | 5 | 0
 |  | Concertina | 2 | 7 | 1 | 2002665 | FWH10.0 WH G 3210x2250 LS 10 | 10 | 20 | 0 | 0 | 0
 |  | Concertina | 2 | 8 | 1 | 2000102 | BKG 6.0 CL G 3210x2250 LS 25   PKGL NE | 25 | 50 | 1 | 1 | 42
 |  | Concertina | 2 | 9 | 1 | 2056683 | 6.8mm [NAME] | 20 | 40 | 0 | 0 | 4
 |  | Concertina | 2 | 10 | 1 | 2062132 | [NAME] G 3210x2100 LS 29   ANSO XX46 | 29 | 58 | 29 | 24 | 37
 |  | Concertina | 2 | 11 | 1 | 2051674 | [NAME] 3210x2250 LS 26   ANSO XX | 26 | 52 | 0 | 9 | 26
 |  | Concertina | 2 | 12 | 1 | 2055045 | [NAME] 3210x2250 LS 28   ANSO XX | 28 | 56 | 0 | 25 | 17
 |  | Concertina | 2 | 13 | 1 | 2063579 | BKW 4.0 WH G 3210x2250 LS 36   PKGL NE | 36 | 72 | 108 | 119 | 0
 |  | Concertina | 2 | 14 | 1 | 2007965 | FWH 6.0 WH G 3210x2250 LS 26 | 26 | 52 | 72 | 104 | 3
 |  | Concertina | 2 | 15 | 1 | 2007715 | FWH 4.0 WH G 3210x2250 LS 28 | 28 | 56 | 36 | 36 | 0
 |  |  | Number of Rack Slots |  |  | 15
 |  |  | Number of Rack Slots @ Month End |  |  | 8
 |  |  | Number of Empty Racks |  |  | 7
 |  |  | Rack Utilisation |  |  | 0.5333333333333333
 |  |  | Total Sheets Capacity |  |  | 658
 |  |  | Total Sheets @ Month End |  |  | 167
 |  |  | Stock Rack Used during Month (Sold) |  |  | 9
 |  |  | Stock Sold Utilisation |  |  | 0.6