weelrdeelr
New Member
- Joined
- Nov 24, 2021
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hi guys! I had a pretty complicated problem that I couldn't quite figure out. Pretty much I need to choose the heaviest tube to package a poster in, and how much to cut down the tube by if needed. We are going to want to use the heaviest tube possible for each poster. If there is enough room to cut down the tube, we're going to want to do so. All the tubes are 25.25 inches long. The maximum weight the tube and poster can be together is 15.98 ounces. The maximum width the poster can be is 24 inches. If the poster is 24 inches, the tube cannot be cut. We're going to want to round the amount we need to cut up to the nearest quarter inch. Below are two examples with explanations showing these possibilities:
Example 1: With a poster weight of 4.3oz, T10 would need us to cut off 3.5 inches. ( 4.3 + 13.5 = 17.8 - 15.98 = 1.82 / 13.5 = 0.1349 * 25.25 = 3.4 = 3.5 ) This is impossible since the print is 22 inches wide. T8 would need us to cut off 2.75 inches which would work but T9 would need us to cut off 3 inches which would also work. We'd want to use T9 since it is the heaviest tube that would work.
Example 2: The easy case. With a poster width of 24 inches, we cannot cut any tube. (The tubes have usable space of 24 inches since they have endcaps). T7 would put us at 16.08 ounces which is over 15.98. T5 would put us at 15.68 ounces which would work but T6 would put us at 15.88 ounces. So we'd want to use T6 since it is the heaviest tube possible.
Thanks so much guys!
The Spreadsheet.xlsx | |||||||
---|---|---|---|---|---|---|---|
I | J | K | L | M | |||
1 | Example 1 (Should Be Cut) | Example 2 (Should Not Be Cut) | |||||
2 | Length of Tube (In) | 25.25 | Length of Tube | 25.25 | |||
3 | Width of Poster (In) | 22 | Width of Poster | 24 | |||
4 | Weight of Poster (Oz) | 4.3 | Weight of Poster | 3.28 | |||
5 | |||||||
6 | Tubes | Weight (Oz) | Tubes | Weight | |||
7 | T1 | 11.5 | T1 | 11.5 | |||
8 | T2 | 11.75 | T2 | 11.75 | |||
9 | T3 | 12 | T3 | 12 | |||
10 | T4 | 12.2 | T4 | 12.2 | |||
11 | T5 | 12.4 | T5 | 12.4 | |||
12 | T6 | 12.6 | T6 | 12.6 | |||
13 | T7 | 12.8 | T7 | 12.8 | |||
14 | T8 | 13 | T8 | 13 | |||
15 | T9 | 13.25 | T9 | 13.25 | |||
16 | T10 | 13.5 | T10 | 13.5 | |||
17 | |||||||
18 | Tube Needed | ??? | Tube Needed | ??? | |||
19 | Desired Tube | T9 | Desired Tube | T6 | |||
20 | |||||||
21 | How Much To Cut | ??? | How Much To Cut | ??? | |||
22 | Desired Amount | 3.00 | Desired Amount | 0 | |||
Packaging |
Example 1: With a poster weight of 4.3oz, T10 would need us to cut off 3.5 inches. ( 4.3 + 13.5 = 17.8 - 15.98 = 1.82 / 13.5 = 0.1349 * 25.25 = 3.4 = 3.5 ) This is impossible since the print is 22 inches wide. T8 would need us to cut off 2.75 inches which would work but T9 would need us to cut off 3 inches which would also work. We'd want to use T9 since it is the heaviest tube that would work.
Example 2: The easy case. With a poster width of 24 inches, we cannot cut any tube. (The tubes have usable space of 24 inches since they have endcaps). T7 would put us at 16.08 ounces which is over 15.98. T5 would put us at 15.68 ounces which would work but T6 would put us at 15.88 ounces. So we'd want to use T6 since it is the heaviest tube possible.
Thanks so much guys!