Spreadsheet: 889615d1740492475-carton-box-calculation-for-dress-carton-box-requirement
Sheet: Sheet2

 | CARTON BOX REQUIREMENT |  |  |  |  |  |  |  |  |  |  |  | STYLE | 1
S NO | STYLE | COLOUR | SIZE |  |  |  |  |  |  |  | TOTAL |  | CARTON BOX SIZE | 60 X 40 X 40 |  | 60  X 40 X 30 |  | 60 X 40 X 20 |  | 60 X 40 X 10
 |  |  | S | M | L | XL | 2XL | 3XL | 4XL | 5XL |  |  | GARMENT SIZE | FROM | TO | FROM | TO | FROM | TO | FROM | TO |  | CARTON BOX SIZE | REQUIRED QTY
1 | 1 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | S | 92 |  |  |  |  |  | 1
2 | 2 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | M | 89 |  |  |  |  |  | 1 |  |  | 60 X 40 X 40 | "result"
3 | 3 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | L | 86 |  |  |  |  |  | 1 |  |  | 60  X 40 X 30 | "result"
4 | 4 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | XL | 81 | 100 | 51 | 80 | 21 | 50 | 1 | 20 |  | 60 X 40 X 20 | "result"
5 | 5 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 2XL | 77 |  |  |  |  |  | 1 |  |  | 60 X 40 X 10 | "result"
6 | 6 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 3XL | 75 |  |  |  |  |  | 1
7 | 7 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 4XL | 72 |  |  |  |  |  | 1
8 | 8 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 5XL | 70 |  |  |  |  |  | 1
9 | 9 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty
10 | 10 |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | STYLE | 2
11 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | CARTON BOX SIZE | 60 X 40 X 40 |  | 60  X 40 X 30 |  | 60 X 40 X 20 |  | 60 X 40 X 10
12 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | GARMENT SIZE | FROM | TO | FROM | TO | FROM | TO | FROM | TO |  | CARTON BOX SIZE | REQUIRED QTY
13 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | S | 92 |  |  |  |  |  | 1
14 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | M | 89 |  |  |  |  |  | 1 |  |  | 60 X 40 X 40 | "result"
15 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | L | 86 |  |  |  |  |  | 1 |  |  | 60  X 40 X 30 | "result"
16 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | XL | 81 | 100 | 51 | 80 | 21 | 50 | 1 | 20 |  | 60 X 40 X 20 | "result"
17 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 2XL | 77 |  |  |  |  |  | 1 |  |  | 60 X 40 X 10 | "result"
18 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 3XL | 75 |  |  |  |  |  | 1
19 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 4XL | 72 |  |  |  |  |  | 1
20 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 5XL | 70 |  |  |  |  |  | 1
21 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty
22 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | STYLE | 3
23 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | CARTON BOX SIZE | 60 X 40 X 40 |  | 60  X 40 X 30 |  | 60 X 40 X 20 |  | 60 X 40 X 10
24 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | GARMENT SIZE | FROM | TO | FROM | TO | FROM | TO | FROM | TO |  | CARTON BOX SIZE | REQUIRED QTY
25 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | S | 92 |  |  |  |  |  | 1
26 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | M | 89 |  |  |  |  |  | 1 |  |  | 60 X 40 X 40 | "result"
27 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | L | 86 |  |  |  |  |  | 1 |  |  | 60  X 40 X 30 | "result"
28 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | XL | 81 | 100 | 51 | 80 | 21 | 50 | 1 | 20 |  | 60 X 40 X 20 | "result"
29 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 2XL | 77 |  |  |  |  |  | 1 |  |  | 60 X 40 X 10 | "result"
30 |  |  | input qty | input qty | input qty | input qty | input qty | input qty | input qty | input qty |  |  | 3XL | 75 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 4XL | 72 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 5XL | 70 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | STYLE | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | CARTON BOX SIZE | 60 X 40 X 40 |  | 60  X 40 X 30 |  | 60 X 40 X 20 |  | 60 X 40 X 10
 |  |  |  |  |  |  |  |  |  |  |  |  | GARMENT SIZE | FROM | TO | FROM | TO | FROM | TO | FROM | TO |  | CARTON BOX SIZE | REQUIRED QTY
 |  |  |  |  |  |  |  |  |  |  |  |  | S | 92 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | M | 89 |  |  |  |  |  | 1 |  |  | 60 X 40 X 40 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | L | 86 |  |  |  |  |  | 1 |  |  | 60  X 40 X 30 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | XL | 81 | 100 | 51 | 80 | 21 | 50 | 1 | 20 |  | 60 X 40 X 20 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | 2XL | 77 |  |  |  |  |  | 1 |  |  | 60 X 40 X 10 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | 3XL | 75 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 4XL | 72 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 5XL | 70 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | STYLE | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | CARTON BOX SIZE | 60 X 40 X 40 |  | 60  X 40 X 30 |  | 60 X 40 X 20 |  | 60 X 40 X 10
 |  |  |  |  |  |  |  |  |  |  |  |  | GARMENT SIZE | FROM | TO | FROM | TO | FROM | TO | FROM | TO |  | CARTON BOX SIZE | REQUIRED QTY
 |  |  |  |  |  |  |  |  |  |  |  |  | S | 92 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | M | 89 |  |  |  |  |  | 1 |  |  | 60 X 40 X 40 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | L | 86 |  |  |  |  |  | 1 |  |  | 60  X 40 X 30 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | XL | 81 | 100 | 51 | 80 | 21 | 50 | 1 | 20 |  | 60 X 40 X 20 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | 2XL | 77 |  |  |  |  |  | 1 |  |  | 60 X 40 X 10 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | 3XL | 75 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 4XL | 72 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 5XL | 70 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | STYLE | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | CARTON BOX SIZE | 60 X 40 X 40 |  | 60  X 40 X 30 |  | 60 X 40 X 20 |  | 60 X 40 X 10
 |  |  |  |  |  |  |  |  |  |  |  |  | GARMENT SIZE | FROM | TO | FROM | TO | FROM | TO | FROM | TO |  | CARTON BOX SIZE | REQUIRED QTY
 |  |  |  |  |  |  |  |  |  |  |  |  | S | 92 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | M | 89 |  |  |  |  |  | 1 |  |  | 60 X 40 X 40 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | L | 86 |  |  |  |  |  | 1 |  |  | 60  X 40 X 30 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | XL | 81 | 100 | 51 | 80 | 21 | 50 | 1 | 20 |  | 60 X 40 X 20 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | 2XL | 77 |  |  |  |  |  | 1 |  |  | 60 X 40 X 10 | "result"
 |  |  |  |  |  |  |  |  |  |  |  |  | 3XL | 75 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 4XL | 72 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 5XL | 70 |  |  |  |  |  | 1