Spreadsheet: 770799d1646256949-conditional-formatting-triggered-when-another-conditional-formatting-is-triggered-pcr-tester
Sheet: Pkging

Dims | Off-Road | Off-Road Cost | Cost | Notes |  | Store | Cost | # of Boxes | Tape/ [NAME] - $0.10/box | 10% [NAME] | TOTAL PCR COST
0x0x0 | 0 |  | 0.11 | Polymailers |  | Off-Road
0x0x2 | 0 |  | 0.11 | Polymailers
0x4x4 | 0 |  | 0.45 | 6x4x4 per Deena
0x8x6 | 0 |  | 0.78 | 8x8x6 per Deena |  |  | Variations on a theme
10x10x10 | 2 |  | 1.5 |  |  |  | =IF(FILTER(Off_Road,(Off_Road<>0)*(ISERROR(Off_Road_Cost))),1,0)
10x8x8 | 0 |  | 0.97 | Kitting box [NAME] |  |  | =COUNT(FILTER(Off_Road,(Off_Road<>0)*(ISERROR(Off_Road_Cost))))
11x11x11 | 0 |  | 1.5 | 10x10x10 per Deena |  |  | =SUMPRODUCT((Off_Road>0)*(ISERROR(Off_Road_Cost)))
11x3x3 | 0 |  | 0.88 | 12x4x4 |  |  | =SUMPRODUCT((Off_Road>0)*(ISTEXT(Cost)))
11x8x3 | 0 |  | 1.04 | 12x9x4
12x12x3 | 0 |  | 1.04 | 12x9x4 per Deena |  |  | Type | Name | [NAME]
12x12x4 | 0 |  | 0.88 | Probably 12x4x4, guess per JLR |  |  | NR | Cost | =Table3[Cost]
12x12x6 | 0 |  | 1.6 | 12x12x7 |  |  | NR | Off_Road | =Table3[Off-Road]
12x12x7 | 0 |  | 1.6 |  |  |  | NR | Off_Road_Cost | =Table3[Off-Road Cost]
12x14x0 | 0 |  | 0.11 | [NAME], guess per JLR
12x16x10 | 0 |  | 2.45 | 16x12x10 |  |  | CF Formula | (for cell L2) | =COUNT(FILTER(Off_Road,(Off_Road<>0)*(ISERROR(Off_Road_Cost))))
12x16x12 | 1 |  | x
12x4x0 | 0 |  | 0.11 | [NAME]
12x4x4 | 0 |  | 0.88
12x5x5 | 0 |  | 0.88 | 12x4x4
12x8x3 | 0 |  | 1.04 | 12x9x4 guess per JLR
12x9x10 | 0 |  | 1.04 | 12x9x4
12x9x4 | 0 |  | 1.04
12x9x5 | 0 |  | 1.04 | 12x9x4
12x9x7 | 0 |  | 1.04 | 12x9x4, guess per JLR
13x10x5 | 0 |  | 1.04 | 12x9x4
13x11x-1 | 0 |  | 0.11
13x11x11 | 0 |  | 3.15 | 14x12x12
13x11x7 | 0 |  | 0 | Product box
13x12x12 | 0 |  | 3.15 | 14x12x12, guess per JLR
13x13x17 | 0 |  | 0 | Product box per Deena
13x5x5 | 0 |  | 0.88 | 12x4x4
13x6x6 | 0 |  | 1.68 | 14x7x7
13x7x7 | 0 |  | 1.68 | 14x7x7
13x9x4 | 0 |  | 1.04 | 12x9x4
14x11x0 | 0 |  | 0.11 | [NAME], guess per JLR
14x12x0 | 0 |  | 0.11
14x12x-1 | 0 |  | 0.11
14x12x12 | 32 |  | 3.15
14x12x2 | 0 |  | 0.11 | Polybags per Deena
14x12x4 | 0 |  | 0.11 | Polybags per Deena
14x1x0 | 0 |  | 0.11 | [NAME], guess per JLR
14x21x0 | 0 |  | 0.11 | Probably 14x12x0 guess per JLR
14x4x4 | 0 |  | 0.88 | 12x4x4 per Deena
14x4x42 | 0 |  | 0 | Product box per Deena
14x6x6 | 1 |  | 1.68 | 14x7x7 guess per JLR
14x7x7 | 0 |  | 1.68
14x9x3 | 0 |  | 1.04 | 12x9x4 per Deena
15x11x9 | 0 |  | 2.45 | 16x12x10
15x12x10 | 0 |  | 2.45 | 16x12x10
15x12x20 | 0 |  | 3.15 | 14x12x12 per Deena
15x12x3 | 0 |  | 0 | Product box per Deena
15x13x13 | 0 |  | 3.15 | 14x12x12, guess per JLR
15x15x15 | 0 |  | 2.66 | 16x16x16
15x8x8 | 0 |  | 1.68 | 14x7x7
16x11x9 | 0 |  | 2.45 | 16x12x10
16x12x10 | 29 |  | 2.45
16x12x20 | 0 |  | 4.83 | 24x16x12 per Deena
16x12x21 | 0 |  | 4.83 | 24x16x12 per Deena
16x12x4 | 0 |  | 2.45 | 16x12x10 per Deena
16x12x6 | 0 |  | 2.45 | 16x12x10 per Deena
16x16x16 | 0 |  | 2.66
16x-1x20 | 0 |  | 2.45 | 16x12x10 per Deena
17x13x11 | 0 |  | 2.45 | 16x12x10, guess per JLR
17x13x4 | 0 |  | 2.07 | 17x13x5
17x13x5 | 0 |  | 2.07
17x6x7 | 0 |  | 0 | Product box per Deena
18x14x12 | 1 |  | 0 | Product box per Deena
19x15x3 | 0 |  | 3.34 | 20x16x4
19x17x12 | 0 |  | 0 | Product box per Deena
1x1x1 | 0 |  | 0.11 | Polybags per Deena
-1x-1x-1 | 3 |  | 0.11 | Polymailers UPS
20x16x4 | 0 |  | 3.34
20x16x5 | 0 |  | 0 | Product box
20x16x6 | 0 |  | x | Actual, we just don't have many of them per Deena
20x17x14 | 0 |  | 0 | Product box per Deena
21x11x15 | 0 |  | 4.83 | 24x16x12 per Deena
21x14x10 | 0 |  | 4.83 | 24x16x12 per Deena
21x15x10 | 2 |  | 4.83 | 24x16x12 per Deena
21x15x11 | 0 |  | 0 | Product box per Deena
21x16x10 | 1 |  | 0 | Product box per Deena
21x16x11 | 1 |  | 4.83 | 24x16x12 per Deena
21x22x37 | 1 |  | 0 | Product box per Deena
22x11x15 | 0 |  | 4.83 | 24x16x12 per Deena
22x14x10 | 0 |  | 0 | Product box per Deena
22x15x10 | 1 |  | 0 | Product box per Deena
22x15x11 | 1 |  | 0 | Product box per Deena
22x16x11 | 1 |  | 4.83 | 24x16x12 per Deena
22x16x16 | 0 |  | 0 | Product box, guess per JLR
22x18x18 | 0 |  | 0 | Product box per Deena
22x21x28 | 0 |  | 0 | Product box per Deena
22x21x37 | 1 |  | 0 | Product box per Deena
22x21x38 | 1 |  | 0 | Product box per Deena
23x15x11 | 0 |  | 4.83 | 24x16x12
23x15x8 | 0 |  | 4.83 | 24x16x12
23x15x9 | 0 |  | 4.83 | 24x16x12, guess per JLR
23x16x12 | 0 |  | 4.83 | 24x16x12
23x16x18 | 0 |  | 0 | Product box, JLR's guess
23x16x9 | 0 |  | 4.83 | 24x16x12
24x16x11 | 1 |  | 4.83 | 24x16x12
24x16x12 | 8 |  | 4.83
24x16x13 | 0 |  | 4.83 | 24x16x12, guess per JLR
24x16x4 | 0 |  | 2.7
24x16x6 | 0 |  | 3.36
24x16x8 | 2 |  | 4.83 | 24x16x12
24x16x9 | 4 |  | 4.83 | 24x16x12
24x17x13 | 0 |  | 4.83 | 24x16x12, guess per JLR
24x17x9 | 0 |  | 4.83 | 24x16x12 per Deena
24x18x1 | 0 |  | 4.18 | 24x18x2 Poster boxes
24x18x18 | 0 |  | 0 | Product box per Deena
24x18x2 | 0 |  | 4.18 | Poster box
24x5x6 | 0 |  | 4.83 | 24x16x12 per Deena
25x14x4 | 0 |  | 0 | Product box per Deena
25x17x13 | 0 |  | 4.83 | 24x16x12
25x19x1 | 0 |  | 4.18 | 24x18x2 poster boxes
25x19x3 | 0 |  | 4.18 | 24x18x2 poster boxes per Deena
25x20x3 | 0 |  | 4.18 | 24x18x2 poster boxes per Deena
26x17x12 | 0 |  | 0 | Product box per Deena
28x15x15 | 0 |  | 0 | Product box per Deena
28x16x12 | 1 |  | 4.83 | 24x16x12 per Deena
28x6x6 | 0 |  | 1.92
29x14x19 | 0 |  | 0 | Product box per Deena
29x15x18 | 0 |  | 0 | Product box per Deena
29x3x3 | 0 |  | x | Poster box per Deena (30x4x4?)
2x0x0 | 0 |  | 0.11 | Polybags per Deena
2x2x2 | 0 |  | 0.11 | Polybags per Deena
2x8x3 | 0 |  | 1.04 | 12x9x4 per Deena
30x14x17 | 2
30x20x11 | 0 |  | 0 | Product box per Deena
30x30x8 | 0 |  | 9.35 | Old Kitting Box $9.35
30x4x4 | 0 |  | 0 | Product box per Deena
30x5x5 | 0 |  | 0 | Product box per Deena
31x14x16 | 0 |  | 0 | Product box per Deena
31x14x17 | 0 |  | 0 | Product box per Deena
31x17x11 | 0 |  | 0 | Product box per Deena
31x5x5 | 0 |  | 0 | Product box per Deena
34x13x22 | 1
34x13x23 | 0 |  | 0 | Product box per Deena
34x14x23 | 0 |  | x
37x2x2 | 0 |  | x | Poster box per Deena
40x12x8 | 0 |  | 0 | Product box per Deena
40x18x8 | 0 |  | 6.5 | Actual box ($6.50) but Deena said it's a product box
41x10x4 | 0 |  | 0 | Product box per Deena
41x10x5 | 0 |  | 0 | Product box per Deena
41x27x3 | 0 |  | 0 | Product box, JLR's guess
42x34x4 | 0 |  | 0 | Product box per Deena
42x4x4 | 0 |  | 0 | Product box per Deena
42x6x6 | 0 |  | 3.67 | 6x6x42 Umbrella box
43x27x2 | 0 |  | 0 | Product box, JLR's guess
44x14x4 | 0 |  | 0 | Product box per Deena
44x18x9 | 0 |  | 0 | Product box per Deena
4x2x2 | 0 |  | 0.55 | 6x6x6 per Deena (should be 6x4x4?)
4x4x30 | 0 |  | 0 | Product box per Deena
4x6x5 | 0 |  | 0.45 | 6x4x4
4x6x6 | 0 |  | 0.45 | 6x4x4
50x-1x-1 | 0 |  | 0 | Product box per Deena
5x3x3 | 1 |  | 0.45 | 6x4x4
5x4x4 | 0 |  | 0.45 | 6x4x4
5x5x5 | 0 |  | 0.55 | 6x6x6
6x4x0 | 0 |  | 0.45 | 6x4x4 per Deena
6x4x3 | 0 |  | 0.45 | 6x4x4
6x4x4 | 0 |  | 0.45
6x6x0 | 0 |  | 0.55 | 6x6x6
6x6x4 | 0 |  | 0.45 | 6x4x4 per Deena
6x6x42 | 0 |  | 3.67 | Umbrella box
6x6x6 | 0 |  | 0.55
6x8x0 | 0 |  | 0.54 | Stayflat envelope per Deena
7x5x5 | 0 |  | x | 6x4x4 or 8x6x6?
7x7x5 | 0 |  | 0.78 | 8x8x6
7x7x7 | 0 |  | x | 6x6x6 or 8x8x8?
7x9x0 | 0 |  | 0.66 | Stayflat envelope per Deena
8x5x5 | 0 |  | 0.78 | 8x8x6
8x6x0 | 0 |  | 0.78 | 8x8x6, guess per JLR
8x6x6 | 0 |  | 0.78 | 8x8x6 per Deena
8x7x8 | 0 |  | 0.78 | 8x8x6 per Deena
8x8x6 | 0 |  | 0.78
8x8x8 | 2 |  | 0.84
9x14x3 | 0 |  | 1.68 | 14x7x7 per Deena
9x14x9 | 0 |  | 0.88 | 12x9x4 per Deena
9x15x11 | 0 |  | 0 | Product box per Deena
9x4x4 | 0 |  | 0.45 | 6x4x4 per Deena
9x8x6 | 0 |  | 0.78 | 8x8x6 per Deena
9x9x7 | 0 |  | 0.78 | 8x8x6 per Deena
9x9x9 | 0 |  | 1.5 | 10x10x10
APC | 0