Spreadsheet: 165467d1341241468-formatting-changes-after-running-macro-wd-working2
Sheet: Data Working

Item | P Length | Cable Length | [NAME] | Weight | # of Probes | Total Weight |  | Transmitters | Qty. | Weight |  | P Length | Cable | Weight |  | Cable Length | Weight | Difference
1 | 36 | 15 | 41 | 5.1 | 2 | 10.2 |  |  |  |  |  | 6 | 10 | 2.5 |  | 10 | 0.65 | +0
2 | 26 | 10 | 31 | #N/A | 2 | #N/A |  |  |  |  |  | 8 | 10 | 2.6 |  | 15 | 0.95 | +0.3
3 | 14 | 10 | 19 | #N/A | 2 | #N/A |  | Total | 0 | 0 |  | 10 | 10 | 2.8 |  | 20 | 1.25 | +0.6
4 | 20 | 10 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 12 | 10 | 2.9 |  | 25 | 1.58 | +0.93
5 | 20 | 10 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 13 | 10 | 2.9 |  | 30 | 1.9 | +1.25
6 | 18 | 10 | 23 | #N/A | 2 | #N/A |  |  |  |  |  | 14 | 10 | 3.1 |  | 40 | 2.5 | +1.85
7 | 22 | 10 | 27 | #N/A | 2 | #N/A |  | Pallet Size | Qty | Weight |  | 16 | 10 | 3.2 |  | 50 | 3.1 | +2.45
8 | 16 | 10 | 21 | #N/A | 2 | #N/A |  |  |  |  |  | 17 | 10 | 3.3
9 | 16 | 10 | 21 | #N/A | 2 | #N/A |  |  |  |  |  | 18 | 10 | 3.7 |  | Transmitter Type | Weight
10 | 20 | 10 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 19 | 10 | 3.8 |  | GTx 116 | 2.55
11 | 20 | 10 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 20 | 10 | 3.9 |  | HTx 104 | 1.4
12 | 20 | 10 | 25 | #N/A | 2 | #N/A |  | Total | 0 | 0 |  | 22 | 10 | 4 |  | ST 102 | 1.4
13 | 20 | 10 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 24 | 10 | 4.1
14 | 20 | 15 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 25 | 10 | 4.1 |  | Pallet Size | Weight
15 | 20 | 10 | 25 | #N/A | 2 | #N/A |  |  |  |  |  | 26 | 10 | 4.2 |  | 144x48 | 126
16 | 16 | 10 | 21 | #N/A | 2 | #N/A |  | Totals |  |  |  | 27 | 10 | 4.3 |  | 120x48 | 113
17 | 20 | 10 | 25 | #N/A | 2 | #N/A |  | 34 | #N/A |  |  | 28 | 10 | 4.3 |  | 144x32 | 102
18 |  |  |  |  |  |  |  | 0 | 0 |  |  | 30 | 10 | 4.4 |  | 96x48 | 100
19 |  |  |  |  |  |  |  | 0 | 0 |  |  | 31 | 10 | 4.5 |  | 120x32 | 85
20 |  |  |  |  |  |  |  |  | #N/A |  |  | 32 | 10 | 4.6 |  | 72x48 | 83
21 |  |  |  |  |  |  |  |  |  |  |  | 35 | 10 | 4.8 |  | 96x32 | 78
22 |  |  |  |  |  |  |  |  |  |  |  | 36 | 10 | 4.8 |  | 84x48 | 75
23 |  |  |  |  |  |  |  |  |  |  |  | 38 | 10 | 4.9 |  | 72x32 | 50
24 |  |  |  |  |  |  |  |  |  |  |  | 40 | 10 | 5 |  | 40x48 | 41
25 |  |  |  |  |  |  |  |  |  |  |  | 41 | 10 | 5.1
26 |  |  |  |  |  |  |  |  |  |  |  | 42 | 10 | 5.2
27 |  |  |  |  |  |  |  |  |  |  |  | 44 | 10 | 5.3
28 |  |  |  |  |  |  |  |  |  |  |  | 45 | 10 | 5.4
29 |  |  |  |  |  |  |  |  |  |  |  | 46 | 10 | 5.5
30 |  |  |  |  |  |  |  |  |  |  |  | 48 | 10 | 5.7
31 |  |  |  |  |  |  |  |  |  |  |  | 50 | 10 | 5.8
32 |  |  |  |  |  |  |  |  |  |  |  | 52 | 10 | 5.9
33 |  |  |  |  |  |  |  |  |  |  |  | 54 | 10 | 6
34 |  |  |  |  |  |  |  |  |  |  |  | 55 | 10 | 6.1
35 |  |  |  |  |  |  |  |  |  |  |  | 56 | 10 | 6.1
36 |  |  |  |  |  |  |  |  |  |  |  | 57 | 10 | 6.2
37 |  |  |  |  |  |  |  |  |  |  |  | 58 | 10 | 6.3
38 |  |  |  |  |  |  |  |  |  |  |  | 60 | 10 | 6.4
39 |  |  |  |  |  |  |  |  |  |  |  | 62 | 10 | 6.5
40 |  |  |  |  |  |  |  |  |  |  |  | 63 | 10 | 6.5
41 |  |  |  |  |  |  |  |  |  |  |  | 64 | 10 | 6.6
42 |  |  |  |  |  |  |  |  |  |  |  | 67 | 10 | 6.8
43 |  |  |  |  |  |  |  |  |  |  |  | 72 | 10 | 6.75
44 |  |  |  |  |  |  |  |  |  |  |  | 74 | 10 | 7
45 |  |  |  |  |  |  |  |  |  |  |  | 77 | 10 | 7.3
Total |  |  |  |  | 34 | #N/A |  |  |  |  |  | 79 | 10 | 7.5
 |  |  |  |  |  |  |  |  |  |  |  | 80 | 10 | 7.6
 |  |  |  |  |  |  |  |  |  |  |  | 84 | 10 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 85 | 10 | 8.2
 |  |  |  |  |  |  |  |  |  |  |  | 90 | 10 | 8.5
 |  |  |  |  |  |  |  |  |  |  |  | 92 | 10 | 8.6
 |  |  |  |  |  |  |  |  |  |  |  | 95 | 10 | 8.7
 |  |  |  |  |  |  |  |  |  |  |  | 96 | 10 | 8.8
 |  |  |  |  |  |  |  |  |  |  |  | 100 | 10 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 108 | 10 | 9.6
 |  |  |  |  |  |  |  |  |  |  |  | 112 | 10 | 9.8
 |  |  |  |  |  |  |  |  |  |  |  | 120 | 10 | 11.1
 |  |  |  |  |  |  |  |  |  |  |  | 132 | 10 | 12.1