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

 | LES | Material Number | Sheets per E/C | ALCIB Mat# | ALCIB Var# | Mat Group | Opening Stock | Receipt Qty | Issued Qty | Closing Stock | MtrSq | AUn | Open Stk (m2) | Receipts (m2) | Issued (m2) | [NAME] (m2) | Value of valuated stock | LES Error | Rack Number | Slot Number | Rack Type
 | BKG 6.0 CL G 3210x2250 LS 25   PKGL NE | 2000102 | 25 | 106306 | 561 | 415 | 42 | 1 | 1 | 42 | 7.22 | M2 | 303.24 | 7.22 | 7.22 | 303.24 | 1683.17
 | FOP 4.0 BZ G 3210x2250 LS 28 | 2000622 | 28 | 100304 | 561 | 409 | 43 | 0 | 3 | 40 | 7.22 | M2 | 310.46 | 0 | 21.66 | 288.8 | 1666.1
 | FOP 4.0 CL G 3210x2250 LS 22 | 2000780 | 22 | 100004 | 561 | 409 | 289 | 1442 | 1533 | 198 | 7.22 | M2 | 2086.58 | 10411.24 | 11068.26 | 1429.56 | 2837.84
 | FOP 4.0 GN G 3210x2250 LS 28 | 2000974 | 28 | 100904 | 561 | 409 | 58 | 0 | 12 | 46 | 7.22 | M2 | 418.76 | 0 | 86.64 | 332.12 | 1074.69
 | FOP 4.0 GY G 3210x2250 LS 28 | 2001011 | 28 | 100604 | 561 | 409 | 37 | 0 | 2 | 35 | 7.22 | M2 | 267.14 | 0 | 14.44 | 252.7 | 840.8
 | FOP 5.0 CL G 3210x2250 LS 22 | 2001079 | 22 | 100005 | 561 | 409 | 36 | 0 | 2 | 34 | 7.22 | M2 | 259.92 | 0 | 14.44 | 245.48 | 619.09
 | FOP 6.0 BZ G 3210x2250 LS 18 | 2001196 | 18 | 100306 | 561 | 409 | 17 | 0 | 3 | 14 | 7.22 | M2 | 122.74 | 0 | 21.66 | 101.08 | 508.25
 | FOP 6.0 CL G 2540x1600 LS 26 | 2001247 | 26 | 100006 | 384 | 409 | 35 | 0 | 9 | 26 | 4.06 | M2 | 142.1 | 0 | 36.54 | 105.56 | 325.99 | Error
 | FOP 6.0 CL G 2540x1830 LS 26 E | 2001251 | 26 | 100006 | 385 | 409 | 52 | 78 | 78 | 52 | 4.65 | M2 | 241.8 | 362.7 | 362.7 | 241.8 | 727.82
 | FOP 6.0 GN G 3210x2250 LS 18 | 2001362 | 18 | 100906 | 561 | 409 | 21 | 0 | 1 | 20 | 7.22 | M2 | 151.62 | 0 | 7.22 | 144.4 | 725.79
 | FOP10.0 CL G 3210x2250 LS 11 | 2001435 | 11 | 100010 | 561 | 409 | 31 | 154 | 159 | 26 | 7.22 | M2 | 223.82 | 1111.88 | 1147.98 | 187.72 | 984.66
 | FOP10.0 GY G 3210x2250 LS 11 | 2001469 | 11 | 100610 | 561 | 409 | 15 | 0 | 1 | 14 | 7.22 | M2 | 108.3 | 0 | 7.22 | 101.08 | 910.2
 | RYF 6.0 CL G 3300x1985 LS 21 | 2001806 | 21 | 106516 | 471 | 410 | 0 | 84 | 70 | 14 | 6.55 | M2 | 0 | 550.2 | 458.5 | 91.7 | 2084.25
 | FOP 6.0 GY G 3210x2250 LS 18 | 2002401 | 18 | 100606 | 561 | 409 | 24 | 0 | 2 | 22 | 7.22 | M2 | 173.28 | 0 | 14.44 | 158.84 | 830.19
 | FOP 8.0 BZ G 3210x2250 LS 14 | 2002402 | 14 | 100308 | 561 | 409 | 0 | 14 | 13 | 1 | 7.22 | M2 | 0 | 101.08 | 93.86 | 7.22 | 50.54
 | SMP 6.0 CL   2540x1830 LS 26 | 2002933 | 26 | 105206 | 385 | 412 | 86 | 78 | 104 | 60 | 4.65 | M2 | 399.9 | 362.7 | 483.6 | 279 | 889.09
 | SMP 6.0 CL   3210x2250 LS 25 | 2002942 | 25 | 105206 | 561 | 412 | 85 | 120 | 150 | 55 | 7.22 | M2 | 613.7 | 866.4 | 1083 | 397.1 | 2317.66
 | SMP 6.0 CL   3210x2550 LS 20 | 2002943 | 20 | 105206 | 458 | 412 | 40 | 0 | 20 | 20 | 8.19 | M2 | 327.6 | 0 | 163.8 | 163.8 | 956.59
 | FOP 6.0 CL G 3210x2250 LS 23 | 2006185 | 23 | 100006 | 561 | 409 | 32 | 133 | 161 | 4 | 7.22 | M2 | 231.04 | 960.26 | 1162.42 | 28.88 | 85.4
 | FOP10.0 BZ G 3210x2250 LS 15 | 2006567 | 15 | 100310 | 561 | 409 | 19 | 0 | 3 | 16 | 7.22 | M2 | 137.18 | 0 | 21.66 | 115.52 | 1047.8
 | FWH 6.0 WH G 3210x2250 LS 26 | 2007965 | 26 | 109176 | 561 | 409 | 35 | 72 | 104 | 3 | 7.22 | M2 | 252.7 | 519.84 | 750.88 | 21.66 | 148.36
 | [NAME] 3210x2250 LS 26   ANSO XX | 2051674 | 26 | 106806 | 561 | 418 | 35 | 0 | 9 | 26 | 7.22 | M2 | 252.7 | 0 | 64.98 | 187.72 | 2145.88
 | SMP 6.0 GY   3210x2250 LS 25 | 2051846 | 25 | 106086 | 561 | 412 | 7 | 0 | 1 | 6 | 7.22 | M2 | 50.54 | 0 | 7.22 | 43.32 | 607.13
 | BKG 4.0 CL G 3210x2400 LS 26 U PKGL NE | 2052109 | 26 | 106304 | 455 | 415 | 35 | 104 | 95 | 44 | 7.7 | M2 | 269.5 | 800.8 | 731.5 | 338.8 | 1336.74
 | FWH10.0 WH L 3210x2550 LS  9 | 2052802 | 9 | 109180 | 458 | 409 | 10 | 36 | 30 | 16 | 8.19 | M2 | 81.9 | 294.84 | 245.7 | 131.04 | 1518.26
 | SMP 6.0 BZ   3210x2000 LS 20 | 2054920 | 20 | 106066 | 452 | 412 | 6 | 20 | 8 | 18 | 6.42 | M2 | 38.52 | 128.4 | 51.36 | 115.56 | 1068.57
 | [NAME] 3210x2250 LS 28   ANSO XX | 2055045 | 28 | 106804 | 561 | 418 | 42 | 0 | 25 | 17 | 7.22 | M2 | 303.24 | 0 | 180.5 | 122.74 | 1045.2
 | BKG 4.0 CL G 3210x2250 LS 22 U PKGL NE | 2056014 | 22 | 106304 | 561 | 415 | 301 | 452 | 599 | 154 | 7.22 | M2 | 2173.22 | 3263.44 | 4324.78 | 1111.88 | 4353.76
 | LKG 6.4 CL C 3210x2250 LS 20 3A3 PKGL | 2056669 | 20 | 406364 | 561 | 402 | 2 | 0 | 0 | 2 | 7.22 | M2 | 14.44 | 0 | 0 | 14.44 | 166.5
 | 6.4mm [NAME] | 2056673 | 20 | 400064 | 561 | 402 | 0 | 80 | 49 | 31 | 7.22 | M2 | 0 | 577.6 | 353.78 | 223.82 | 1394.4
 | LKG 6.4 CL C 3210x2550 LS 20 3A3 PKGL | 2056675 | 20 | 406364 | 458 | 402 | 20 | 0 | 16 | 4 | 8.19 | M2 | 163.8 | 0 | 131.04 | 32.76 | 400.79
 | 12.8mm [NAME] | 2056677 | 7 | 400128 | 457 | 402 | 0 | 0 | -1 | 1 | 8.03 | M2 | 0 | 0 | -8.03 | 8.03 | 147.69
 | 6.4mm [NAME] | 2056681 | 20 | 400064 | 458 | 402 | 27 | 80 | 83 | 24 | 8.19 | M2 | 221.13 | 655.2 | 679.77 | 196.56 | 1224.57
 | 6.8mm [NAME] | 2056683 | 20 | 401210 | 458 | 402 | 4 | 0 | 0 | 4 | 8.19 | M2 | 32.76 | 0 | 0 | 32.76 | 564.44
 | 6.8mm [NAME] | 2056697 | 20 | 400068 | 458 | 402 | 22 | 40 | 23 | 39 | 8.19 | M2 | 180.18 | 327.6 | 188.37 | 319.41 | 2663.87
 | 10.8mm [NAME] | 2056705 | 10 | 400108 | 457 | 402 | 6 | 40 | 28 | 18 | 8.02 | M2 | 48.12 | 320.8 | 224.56 | 144.36 | 1889.68
 | 6.4mm [NAME] 3065 Stk - 3210x2550 | 2056711 | 20 | 400565 | 458 | 402 | 13 | 1 | 3 | 11 | 8.19 | M2 | 106.47 | 8.19 | 24.57 | 90.09 | 1060.35
 | 8.8mm [NAME] | 2056715 | 10 | 400088 | 457 | 402 | 19 | 10 | 5 | 24 | 8.03 | M2 | 152.57 | 80.3 | 40.15 | 192.72 | 2233.16
 | 11.5mm [NAME] | 2056717 | 10 | 400115 | 457 | 402 | 7 | 10 | 2 | 15 | 8.02 | M2 | 56.14 | 80.2 | 16.04 | 120.3 | 2140.98
 | 6.4mm Optilam Grey 5042 Stk - 3210x2550 | 2056719 | 20 | 400764 | 458 | 402 | 29 | 1 | 0 | 30 | 8.19 | M2 | 237.51 | 8.19 | 0 | 245.7 | 2986.44
 | 8.8mm [NAME] | 2056721 | 10 | 400088 | 490 | 402 | 13 | 10 | 4 | 19 | 9.15 | M2 | 118.95 | 91.5 | 36.6 | 173.85 | 1924.26
 | 6.4mm [NAME] 6028 - 3210x2550 | 2056724 | 20 | 400863 | 458 | 402 | 16 | 0 | 4 | 12 | 8.19 | M2 | 131.04 | 0 | 32.76 | 98.28 | 1055.76
 | 6.8mm [NAME] | 2056732 | 20 | 401210 | 561 | 402 | 16 | 0 | 0 | 16 | 7.22 | M2 | 115.52 | 0 | 0 | 115.52 | 725.79
 | 6.4MM OPTILAM GREY A/S STK - 3210x2550 | 2056827 | 20 | 400664 | 458 | 402 | 3 | 0 | 0 | 3 | 8.19 | M2 | 24.57 | 0 | 0 | 24.57 | 283.03
 | 6.4mm Optilam Grey A/S Stk - 3210x2250 | 2057004 | 20 | 400664 | 561 | 402 | 14 | 0 | 1 | 13 | 7.22 | M2 | 101.08 | 0 | 7.22 | 93.86 | 1047.38
 | 6.8mm [NAME] | 2057008 | 20 | 401906 | 458 | 402 | 34 | 20 | 28 | 26 | 8.19 | M2 | 278.46 | 163.8 | 229.32 | 212.94 | 3530.04
 | 10.8mm [NAME] | 2057009 | 10 | 401910 | 457 | 402 | 1 | 0 | 0 | 1 | 8.03 | M2 | 8.03 | 0 | 0 | 8.03 | 185.17
 | 8.8mm [NAME] PVB 3210x2500 | 2057036 | 10 | 401908 | 457 | 402 | 35 | 0 | 20 | 15 | 8.03 | M2 | 281.05 | 0 | 160.6 | 120.45 | 2360.82
 | FAB 4.0 AB G 3210x2250 LS 28 | 2057813 | 28 | 106604 | 561 | 409 | 32 | 0 | 0 | 32 | 7.22 | M2 | 231.04 | 0 | 0 | 231.04 | 1156.87
 | FAB 6.0 AB G 3210x2250 LS 18 | 2057817 | 18 | 106606 | 561 | 409 | 16 | 0 | 0 | 16 | 7.22 | M2 | 115.52 | 0 | 0 | 115.52 | 871.87
 | FAB10.0 AB G 3210x2250 LS 11 | 2057821 | 11 | 106610 | 561 | 417 | 3 | 0 | 0 | 3 | 7.22 | M2 | 21.66 | 0 | 0 | 21.66 | 293.48
 | BAE 4.0 AB G 3300x2440 LS 29   ECAD SI | 2060579 | 29 | 105664 | 472 | 417 | 8 | 0 | -1 | 9 | 8.05 | M2 | 64.4 | 0 | -8.05 | 72.45 | 904.07
 | [NAME] G 3210x2100 LS 29   ANSO XX46 | 2062132 | 29 | 106834 | 453 | 418 | 32 | 29 | 24 | 37 | 6.74 | M2 | 215.68 | 195.46 | 161.76 | 249.38 | 2647.66
 | BKG 4.0 MI G 3210x2250 LS 36   PKGL NE | 2063192 | 36 | 0 | 0 | 415 | 9 | 0 | 0 | 9 | 7.22 | M2 | 64.98 | 0 | 0 | 64.98 | 276.39
 | BKW 4.0 WH G 3210x2250 LS 36 U PKGL NE | 2063581 | 36 | 0 | 0 | 415 | 0 | 0 | -53 | 53 | 7.22 | M2 | 0 | 0 | -382.66 | 382.66 | 1866.01
 | FWH 4.0 WE G 3210x2250 LS 36 | 2063715 | 36 | 109144 | 561 | 409 | 0 | 323 | 292 | 31 | 7.22 | M2 | 0 | 2332.06 | 2108.24 | 223.82 | 568.84
 | RPO 7.0 CL G 3353x1829 LS 22 C | 2064012 | 22 | 106587 | 476 | 410 | 0 | 176 | 171 | 5 | 6.13 | M2 | 0 | 1078.88 | 1048.23 | 30.65 | 292.71