Spreadsheet: 679822d1590650069-calculate-cubic-inches-of-a-product-and-match-a-box-for-shipping-example4
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | No | 0 | 1 | 1 | 1 | 200 | 6 | 5.5 | 250 | 202
Number of Product Boxes |  |  | 200 |  |  |  |  |  |  |  |  | No | 0 | 2 | 1 | 2 | 100 | 6 | 11 | 125 | 103
Size of each Product Box in (Inches) |  |  |  |  |  |  |  |  |  |  |  | No | 0 | 4 | 1 | 4 | 50 | 6 | 22 | 62.5 | 55
Length | [NAME] | Height |  |  |  |  |  |  |  |  |  | No | 0 | 5 | 1 | 5 | 40 | 6 | 27.5 | 50 | 46
6 | 5.5 | 1.25 |  |  |  |  |  |  |  |  |  | No | 0 | 8 | 1 | 8 | 25 | 6 | 44 | 31.25 | 34
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 | 10 | 1 | 10 | 20 | 6 | 55 | 25 | 31
[NAME] |  |  | Packing Configuration |  |  |  |  |  |  |  |  | No | 0 | 20 | 1 | 20 | 10 | 6 | 110 | 12.5 | 31
Length | [NAME] | Height | Length | [NAME] | Height |  |  |  |  |  |  | No | 0 | 25 | 1 | 25 | 8 | 6 | 137.5 | 10 | 34
24 | 27.5 | 12.5 | 4 | 5 | 10 |  |  |  |  | Yes1 |  | No | 0 | 40 | 1 | 40 | 5 | 6 | 220 | 6.25 | 46
30 | 27.5 | 10 | 5 | 5 | 8 |  |  |  |  | Yes2 |  | No | 0 | 50 | 1 | 50 | 4 | 6 | 275 | 5 | 55
 |  |  |  |  |  |  |  |  |  | Yes3 |  | No | 0 | 100 | 1 | 100 | 2 | 6 | 550 | 2.5 | 103
 |  |  |  |  |  |  |  |  |  | Yes4 |  | No | 0 | 200 | 1 | 200 | 1 | 6 | 1100 | 1.25 | 202
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 1 | 100 | 12 | 5.5 | 125 | 103
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 2 | 50 | 12 | 11 | 62.5 | 54
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 4 | 25 | 12 | 22 | 31.25 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 5 | 20 | 12 | 27.5 | 25 | 27
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 10 | 10 | 12 | 55 | 12.5 | 22
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 20 | 5 | 12 | 110 | 6.25 | 27
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 25 | 4 | 12 | 137.5 | 5 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 50 | 2 | 12 | 275 | 2.5 | 54
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 2 | 100 | 1 | 12 | 550 | 1.25 | 103
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 4 | 1 | 50 | 24 | 5.5 | 62.5 | 55
 |  |  |  |  |  |  |  |  |  |  |  | No | 0 |  | 4 | 2 | 25 | 24 | 11 | 31.25 | 31
 |  |  |  |  |  |  |  |  |  |  | Yes1 | Yes | 1 |  | 4 | 5 | 10 | 24 | 27.5 | 12.5 | 19
 |  |  |  |  |  |  |  |  |  |  |  | No | 1 |  | 4 | 10 | 5 | 24 | 55 | 6.25 | 19
 |  |  |  |  |  |  |  |  |  |  |  | No | 1 |  | 4 | 25 | 2 | 24 | 137.5 | 2.5 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 1 |  | 4 | 50 | 1 | 24 | 275 | 1.25 | 55
 |  |  |  |  |  |  |  |  |  |  |  | No | 1 |  | 5 | 1 | 40 | 30 | 5.5 | 50 | 46
 |  |  |  |  |  |  |  |  |  |  |  | No | 1 |  | 5 | 2 | 20 | 30 | 11 | 25 | 27
 |  |  |  |  |  |  |  |  |  |  |  | No | 1 |  | 5 | 4 | 10 | 30 | 22 | 12.5 | 19
 |  |  |  |  |  |  |  |  |  |  | Yes2 | Yes | 2 |  | 5 | 5 | 8 | 30 | 27.5 | 10 | 18
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 5 | 8 | 5 | 30 | 44 | 6.25 | 18
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 5 | 10 | 4 | 30 | 55 | 5 | 19
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 5 | 20 | 2 | 30 | 110 | 2.5 | 27
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 5 | 40 | 1 | 30 | 220 | 1.25 | 46
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 8 | 1 | 25 | 48 | 5.5 | 31.25 | 34
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 8 | 5 | 5 | 48 | 27.5 | 6.25 | 18
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 8 | 25 | 1 | 48 | 137.5 | 1.25 | 34
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 10 | 1 | 20 | 60 | 5.5 | 25 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 10 | 2 | 10 | 60 | 11 | 12.5 | 22
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 10 | 4 | 5 | 60 | 22 | 6.25 | 19
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 10 | 5 | 4 | 60 | 27.5 | 5 | 19
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 10 | 10 | 2 | 60 | 55 | 2.5 | 22
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 10 | 20 | 1 | 60 | 110 | 1.25 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 20 | 1 | 10 | 120 | 5.5 | 12.5 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 20 | 2 | 5 | 120 | 11 | 6.25 | 27
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 20 | 5 | 2 | 120 | 27.5 | 2.5 | 27
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 20 | 10 | 1 | 120 | 55 | 1.25 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 25 | 1 | 8 | 150 | 5.5 | 10 | 34
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 25 | 2 | 4 | 150 | 11 | 5 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 25 | 4 | 2 | 150 | 22 | 2.5 | 31
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 25 | 8 | 1 | 150 | 44 | 1.25 | 34
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 40 | 1 | 5 | 240 | 5.5 | 6.25 | 46
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 40 | 5 | 1 | 240 | 27.5 | 1.25 | 46
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 50 | 1 | 4 | 300 | 5.5 | 5 | 55
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 50 | 2 | 2 | 300 | 11 | 2.5 | 54
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 50 | 4 | 1 | 300 | 22 | 1.25 | 55
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 100 | 1 | 2 | 600 | 5.5 | 2.5 | 103
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 100 | 2 | 1 | 600 | 11 | 1.25 | 103
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  | 200 | 1 | 1 | 1200 | 5.5 | 1.25 | 202
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | No | 2 |  |  |  |  |  |  |  | 0