Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down over several cells with vlookup and match but I still can't figure it out.
Excel2010 (Windows) 64 bit
<tbody>
</tbody>
Excel2010 (Windows) 64 bit
A | B | C | D | E | F | G | H | I | J |
Rows | | ||||||||
1 | | ||||||||
2 | | | Size of Bottom Bar 1st Matt | 6 | # | | |||
3 | | | Wt. Per Lf of Size of Bottom Bar 1st Matt | ? | LBS. | | |||
4 | | | Lapping Factor Bottom Bar 1st Matt | 40d | LF | | |||
5 | | | Length of Lap Required For Bottom Bar 1st Matt | ? | LF | | |||
6 | | ||||||||
7 | | | Size of Top Bar 1st Matt | 4 | # | | |||
8 | | | Wt. Per Lf of Size of Top Bar 1st Matt | ? | LBS. | | |||
9 | | | Lapping Factor Top Bar 1st Matt | 30d | LF | | |||
10 | | | Length of Lap Required For Top Bar 1st Matt | ? | LF | | |||
11 | | ||||||||
12 | | ||||||||
13 | | ||||||||
14 | Bar Size | Bar Diameter in (mm) | Bar Diameter in (inches) | Lbs. Per Lf. | 24d | 30d | 40d | 50d | 60d |
15 | 3 | 9.525 | 0.375 | 0.376 | 0.75 | 0.94 | 1.25 | 1.56 | 1.88 |
16 | 4 | 12.700 | 0.500 | 0.668 | 1.00 | 1.25 | 1.67 | 2.08 | 2.50 |
17 | 5 | 15.875 | 0.625 | 1.043 | 1.25 | 1.56 | 2.08 | 2.60 | 3.13 |
18 | 6 | 19.050 | 0.750 | 1.502 | 1.50 | 1.88 | 2.50 | 3.13 | 3.75 |
19 | 7 | 22.225 | 0.875 | 2.044 | 1.75 | 2.19 | 2.92 | 3.65 | 4.38 |
20 | 8 | 25.400 | 1.000 | 2.670 | 2.00 | 2.50 | 3.33 | 4.17 | 5.00 |
21 | 9 | 28.651 | 1.128 | 3.400 | 2.26 | 2.82 | 3.76 | 4.70 | 5.64 |
22 | 10 | 32.258 | 1.270 | 4.303 | 2.54 | 3.18 | 4.23 | 5.29 | 6.35 |
23 | 11 | 35.814 | 1.410 | 5.313 | 2.82 | 3.53 | 4.70 | 5.88 | 7.05 |
24 | 14 | 43.002 | 1.693 | 7.650 | N/A | N/A | N/A | N/A | N/A |
25 | 16 | 57.328 | 2.257 | 13.600 | N/A | N/A | N/A | N/A | N/A |
| | ||||||||
| Example | | |||||||
2 | Size of Bottom Bar 1st Matt | 6 | # | | |||||
3 | Wt. Per Lf of Size of Bottom Bar 1st Matt | 1.502 | LBS. | | |||||
4 | Lapping Factor Bottom Bar 1st Matt | 40d | LF | | |||||
5 | | | | Length of Lap Required For Bottom Bar 1st Matt | 2.50 | LF | | | |