Spreadsheet: 861218d1709149571-looking-for-matching-numbers-and-reporting-difference-between-two-associated-columns-cutoff-tracker-analysis
Sheet: Sheet3

TAG NUMBER | MATERIAL SIZE |  | SQR FOOTAGE |  |  | CARD # | Item Number | Unit of Measure | [NAME] | Length | On Hand
 | WIDTH | LENGTH
3198 | 11 | 232 |  |  |  | 3198 | I-TFE-1407 (TFE 1407  ) |  | 11 | 232.5 | 17.76041666666667
3199 |  |  |  | True |  | 3199 | I-TFE-1407 (TFE 1407  ) |  | 61 | 130 | 55.06944444444444 |  | 55.06944444444444
3251 |  |  |  | True |  | 3251 | I-TFE-1407 (TFE 1407  ) |  | 20 | 137 | 19.02777777777778 |  | 19.02777777777778
3252 |  |  |  | True |  | 3252 | I-TFE-1407 (TFE 1407  ) |  | 45 | 196 | 61.25 |  | 61.25
3253 |  |  |  | True |  | 3253 | I-TFE-1407 (TFE 1407  ) |  | 23.25 | 269 | 43.43229166666666 |  | 43.43229166666666
3254 | 32 | 192 |  | True |  | 3254 | I-TFE-1407 (TFE 1407  ) |  | 32.125 | 192 | 42.83333333333334 |  | 0.1666666666666714
3255 | 49 | 206 |  | True |  | 3255 | I-TFE-1407 (TFE 1407  ) |  | 49 | 206.875 | 70.39496527777777 |  | 0.2977430555555429
3256 | 13 | 131 |  | True |  | 3256 | I-TFE-1407 (TFE 1407  ) |  | 13.25 | 131.5 | 12.09982638888889 |  | 0.2734375000000018
3257 | 19 | 105 |  | True |  | 3257 | I-TFE-1407 (TFE 1407  ) |  | 19.625 | 105.875 | 14.42914496527778 |  | 0.5749782986111125
3258 | 16 | 152 |  | True |  | 3258 | I-TFE-1407 (TFE 1407  ) |  | 16.75 | 152 | 17.68055555555556 |  | 0.7916666666666714
3259 | 22 | 60 |  | True |  | 3259 | I-TFE-1407 (TFE 1407  ) |  | 22 | 60 | 9.166666666666666 |  | 0
3260 | 17 | 122 |  | True |  | 3260 | I-TFE-1407 (TFE 1407  ) |  | 17 | 122.5 | 14.46180555555556 |  | 0.05902777777777679
3265 |  |  |  | True |  | 3265 | I-TFE-1407 (TFE 1407  ) |  | 29.625 | 305 | 62.74739583333334 |  | 62.74739583333334
3266 |  |  |  | True |  | 3266 | I-TFE-1407 (TFE 1407  ) |  | 61.75 | 942.5 | 404.1623263888889 |  | 404.1623263888889
3323 | 30 | 94 |  | True |  | 3323 | I-TFE-1407 (TFE 1407  ) |  | 30 | 94 | 19.58333333333333 |  | 0
3324 | 13 | 267 |  | True |  | 3324 | I-TFE-1407 (TFE 1407  ) |  | 13 | 267.5 | 24.14930555555556 |  | 0.04513888888889284
3325 | 21 | 108 |  | True |  | 3325 | I-TFE-1407 (TFE 1407  ) |  | 21 | 108.5 | 15.82291666666667 |  | 0.07291666666666607
3326 | 18 | 74 |  | True |  | 3326 | I-TFE-1407 (TFE 1407  ) |  | 18 | 74 | 9.25 |  | 0
3327 | 30 | 103 |  | True |  | 3327 | I-TFE-1407 (TFE 1407  ) |  | 30.5 | 103.5 | 21.921875 |  | 0.4635416666666643
3328 | 29 | 94 |  | True |  | 3328 | I-TFE-1407 (TFE 1407  ) |  | 29.75 | 94 | 19.42013888888889 |  | 0.4895833333333357
3329 | 9 | 330 |  | False |  | 3331 | I-TFE-1407 (TFE 1407  ) |  | 11.375 | 338 | 26.69965277777778 |  | 6.074652777777779
3330 | 32 | 97 |  | False |  | 3335 | I-TFE-1407 (TFE 1407  ) |  | 13.75 | 434 | 41.44097222222222 |  | 19.88541666666666
3331 | 11 | 338 |  | False |  | 3406 | I-TFE-1407 (TFE 1407  ) |  | 10.25 | 301.625 | 21.46983506944444 |  | -4.349609375
3335 | 13 |  |  | False |  | 3428 | I-TFE-1407 (TFE 1407  ) |  |  |  | 31.31 |  | 24.90027777777778
3406 | 10 |  |  | False |  | 3429 | I-TFE-1407 (TFE 1407  ) |  |  |  | 22.05 |  | 16.70277777777778
3428 | 13 | 333 |  | False |  | 3430 | I-TFE-1407 (TFE 1407  ) |  |  |  | 33.75 |  | 3.687500000000004
3429 | 13 | 231 |  | False |  | 3431 | I-TFE-1407 (TFE 1407  ) |  |  |  | 28.85 |  | 7.995833333333337
3430 |  |  |  | False |  | 3432 | I-TFE-1407 (TFE 1407  ) |  |  |  | 86.96 |  | 86.96
3431 | 15 | 276 |  | False |  | 3433 | I-TFE-1407 (TFE 1407  ) |  |  |  | 25.62 |  | -3.129999999999999
3432 | 15 | 828 |  | False |  | 3434 | I-TFE-1407 (TFE 1407  ) |  |  |  | 29.06 |  | -57.19
3433 | 20 | 179 |  | False |  | 3435 | I-TFE-1407 (TFE 1407  ) |  |  |  | 7 |  | -17.86111111111111
3434 | 15 | 267 |  | False |  | 3436 | I-TFE-1407 (TFE 1407  ) | BII WH xfer | 12 | 600 | 50 |  | 22.1875
3435 | 14 | 72 |  | False |  | 3437 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 50.55 |  | 43.55
3436 |  |  |  | False |  | 3438 | I-TFE-1407 (TFE 1407  ) | BII WH xfer | 12 | 600 | 50 |  | 50
3437 | 12 | 606 |  | False |  | 3439 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 49.74 |  | -0.759999999999998
3438 | 12 | 600 |  | False |  | 3440 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 43.91 |  | -6.090000000000003
3439 |  |  |  | False |  | 3441 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 30.625 |  | 30.625
3440 | 15 | 408 |  | False |  | 3442 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 14.73 |  | -27.77
3441 | 17 | 252 |  | False |  | 3443 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 33.33 |  | 3.579999999999998
3442 |  |  |  | False |  | 3444 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 68.06 |  | 68.06
3443 |  |  |  | False |  | 3445 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 90.84 |  | 90.84
3444 |  |  |  | False |  | 3446 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 14.18 |  | 14.18
3445 | 15 |  |  | False |  | 3447 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 41 |  | 3.8125
3446 | 11 | 214 |  | False |  | 3448 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 44.28 |  | 27.93277777777778
3447 | 41 | 144 |  | False |  | 3449 | I-TFE-1407 (TFE 1407  ) | BII WH xfer | 10.5 | 534 | 38.9375 |  | -2.0625
3448 |  |  |  | False |  | 3450 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 13.25 |  | 13.25
3449 | 10 | 534 |  | False |  | 3451 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 9.33 |  | -27.75333333333334
3450 | 26 | 70 |  | False |  | 3452 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 8.12 |  | -4.518888888888888
3451 | 14 | 96 |  | False |  | 3453 | I-TFE-1407 (TFE 1407  ) | BII WH xfer |  |  | 14.62 |  | 5.286666666666665
3452 | 16 | 72 |  | False
3453 | 9 | 234 |  | False