Spreadsheet: 754956d1636591795-applying-data-validation-to-check-box-activity-or-alternative-solution-multi-run-length-calculator-11-07-21-b
Sheet: Product Info

 |  |  |  | Add a "De-Rated" yes/no checkbox (and be able to adjust the de-rating percentage)
 |  |  |  | Add a "Actual" and "Listed" Cut Length switch button
 |  |  |  |  |  |  |  | A | A | A | A | B | B | C | C | C | C | C | C | C | C | D | D | D | D | C | E | F | F | F | F | F | F | F | F | F | F | F | G
 |  |  |  |  |  |  |  | Types of Lead Wires & End Caps Used Per Product
List of Products | [NAME] | Listed Cut Increment | Actual Cut Increment | Wattage (Per Inch) |  |  |  | V4 Nude Bright | V4 Nude Super Bright | V4 NanoSKN Bright | V4 NanoSKN Super Bright | V4 Nude RGB | V4 NanoSKN RGB | [NAME] | [NAME] Bright | [NAME] Super Bright | V5 SPEC 1.5 | V5 SPEC 2.8 | V5 SPEC 5.0 | V5 SPEC 7.5 | Inspire Warm Dim | Inspire Tunable White | Inspire RGB 4.0 | Inspire RGB 6.0 | Inspire RGBW | Inspire LightLine COB | Neon Flex 0103 - Side Bend (SC) | Neon Flex 0404 - Side Bend (SC) | Neon Flex 0404 - Top Bend (SC) | Neon Flex 0408 - Side Bend (SC) | Neon Flex 0408 - Side Bend (RGB) | Neon Flex 0408 - Side Bend (RGBW) | Neon Flex 0411 - Side Bend (SC) | Neon Flex 0411 - Side Bend (RGB) | Neon Flex 0411 - Side Bend (RGBW) | Neon Flex 0606 - Top Bend (SC) | Neon Flex 0606 - Top Bend (RGB) | Neon Flex 0606 - Top Bend (RGBW) | V4 Outdoor Standard Bright | V4 Outdoor RGB
V4 Nude Bright |  | 4 |  |  |  |  |  | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None
V4 Nude Super Bright |  | 4 |  |  |  |  |  | w/ [NAME] Connector | w/ [NAME] Connector | w/ [NAME] Connector | w/ [NAME] Connector | w/ [NAME] (RGB) | w/ [NAME] (RGB) | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ [NAME] HD Connector | w/ Soldered Specialty Lead Wire | w/ Soldered Specialty Lead Wire | w/ Soldered Specialty Lead Wire | w/ Soldered Specialty Lead Wire | w/ [NAME] HD Connector | w/ End Cap + Connector (End) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ End Cap + Connector (Back/Side) | w/ Inspire V4 Outdoor Connector | w/ Inspire V4 Outdoor Connector
V4 NanoSKN Bright |  | 4 |  |  |  |  |  | w/ Channel & Zeus Connector (Inside) | w/ Channel & Zeus Connector (Inside) | w/ Channel & Zeus Connector (Inside) | w/ Channel & Zeus Connector (Inside) | w/ Channel & Zeus Connector (Inside) | w/ Channel & Zeus Connector (Inside) | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Soldered Lead Wire |  | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End) | w/ End Cap + Connector (End)
V4 NanoSKN Super Bright |  | 4 |  |  |  |  |  | w/ Channel & Zeus Connector (Outside) | w/ Channel & Zeus Connector (Outside) | w/ Channel & Zeus Connector (Outside) | w/ Channel & Zeus Connector (Outside) | w/ Channel & Zeus Connector (Outside) | w/ Channel & Zeus Connector (Outside) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) | w/ Soldered Lead Wire (18 AWG) |  |  |  |  | w/ Soldered Lead Wire (18 AWG)
V4 Nude RGB |  | 4 |  |  |  |  |  |  |  |  |  |  |  | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector | w/ Channel & Zeus HD Connector |  |  |  |  | w/ Channel & Zeus HD Connector
V4 NanoSKN RGB |  | 4 |  |  |  |  |  |  |  |  |  |  |  | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire | w/ Channel & Soldered Lead Wire |  |  |  |  | w/ Channel & Soldered Lead Wire
[NAME] |  | 6 | 5.999
[NAME] Bright |  | 4
[NAME] Super Bright |  | 4 | 3.99435
V5 SPEC 1.5 |  | 1.75 | 1.711875
V5 SPEC 2.8 |  | 1.75 | 1.711875
V5 SPEC 5.0 |  | 1.5 | 1.499525
V5 SPEC 7.5
Inspire lightLine COB |  | 2 |  |  |  |  |  | Types of Leads | Lengths Required |  | Specialty Lead Selections | Lengths Required | [NAME] |  | LIST A | LIST B | LIST C | LIST D | LIST E | LIST F | LIST G
Inspire Warm Dim |  | 2.4 | 2.398 |  |  |  |  | None | 0 |  | Inspire Tunable White | 0.6824999999999997 | (RGB 6.0 20AWG 4C) |  | V4 Nude Bright | V4 Nude RGB | [NAME] | Inspire Tunable White | Neon Flex 0103 - Side Bend (SC) | Neon Flex 0404 - Side Bend (SC) | V4 Outdoor Standard Bright
Inspire Tunable White |  | 2.44 | 2.39640625 |  |  |  |  | w/ [NAME] Connector | 1.014 |  | Inspire RGB 4.0 | 0.7259999999999995 | (RGB 4.0 20AWG 4C) |  | V4 Nude Super Bright | V4 NanoSKN RGB | [NAME] Bright | Inspire RGB 4.0 |  | Neon Flex 0404 - Top Bend (SC) | V4 Outdoor RGB
Inspire RGB 4.0 |  | 4 | 3.9749 |  |  |  |  | w/ [NAME] (RGB) | 1.241 |  | Inspire RGB 6.0 | 0.8295999999999999 | (RGBW 20AWG 5C) |  | V4 NanoSKN Bright |  | [NAME] Super Bright | Inspire RGB 6.0 |  | Neon Flex 0408 - Side Bend (SC)
Inspire RGB 6.0 |  | 1.5 |  |  |  |  |  | w/ [NAME] HD Connector | 1.5165 |  | Inspire RGBW | 0.863 | (TUNW 20AWG 3C) |  | V4 NanoSKN Super Bright |  | V5 SPEC 1.5 | Inspire RGBW |  | Neon Flex 0408 - Side Bend (RGB)
Inspire RGBW |  | 3 | 3 |  |  |  |  | w/ Soldered Lead Wire | 0.4815 |  |  |  |  |  |  |  | V5 SPEC 2.8 |  |  | Neon Flex 0408 - Side Bend (RGBW)
V4 Outdoor Standard Bright |  | 4 | 3.9975 |  |  |  |  | w/ Soldered Lead Wire (18 AWG) | 0.6879999999999997 |  |  |  |  |  |  |  | V5 SPEC 5.0 |  |  | Neon Flex 0411 - Side Bend (SC)
V4 Outdoor RGB |  | 4 | 4.007090909090909 |  |  |  |  | w/ Soldered Specialty Lead Wire |  |  |  |  |  |  |  |  | V5 SPEC 7.5 |  |  | Neon Flex 0411 - Side Bend (RGB)
Neon Flex 0103 - Side Bend (SC) |  |  | 1.94725 |  |  |  |  | w/ Channel & Zeus Connector (Inside) | 1.148819518 |  |  |  |  |  |  |  | Inspire Warm Dim |  |  | Neon Flex 0411 - Side Bend (RGBW)
Neon Flex 0404 - Side Bend (SC) |  |  | 3.918475 |  |  |  |  | w/ Channel & Zeus Connector (Outside) | 0.833858718 |  |  |  |  |  |  |  | Inspire LightLine COB |  |  | Neon Flex 0606 - Top Bend (SC)
Neon Flex 0404 - Top Bend (SC) |  |  | 3.93805 |  |  |  |  | w/ Channel & Zeus HD Connector | 0.479527818 |  |  |  |  |  |  |  |  |  |  | Neon Flex 0606 - Top Bend (RGB)
Neon Flex 0408 - Side Bend (SC) |  |  | 3.00495 |  |  |  |  | w/ Channel & Soldered Lead Wire | 0.203937118 |  |  |  |  |  |  |  |  |  |  | Neon Flex 0606 - Top Bend (RGBW)
Neon Flex 0408 - Side Bend (RGB) |  |  | 2.998625 |  |  |  |  | w/ End Cap + Connector (Back/Side) |  |  | Neon Flex Connector (Back/Side) Selections | Lengths Required | [NAME] |  | Neon Flex Connector (End) Selections | Lengths Required | [NAME]
Neon Flex 0408 - Side Bend (RGBW) |  |  | 3.020225 |  |  |  |  | w/ End Cap + Connector (End) |  |  | Neon Flex 0404 - Side Bend (SC) | 0.1905 |  |  | Neon Flex 0103 - Side Bend (SC) | 0.442
Neon Flex 0411 - Side Bend (SC) |  |  | 2.8795 |  |  |  |  | w/ Inspire V4 Outdoor Connector | 2.041833333333333 |  | Neon Flex 0404 - Top Bend (SC) | 0.1905 |  |  | Neon Flex 0404 - Side Bend (SC) | 1.0405
Neon Flex 0411 - Side Bend (RGB) |  |  | 3.055 |  |  |  |  |  |  |  | Neon Flex 0408 - Side Bend (SC) | 0.7949999999999996 |  |  | Neon Flex 0404 - Top Bend (SC) | 1.054
Neon Flex 0411 - Side Bend (RGBW) |  |  | 3.023 |  |  |  |  |  |  |  | Neon Flex 0408 - Side Bend (RGB) | 0.8014999999999997 |  |  | Neon Flex 0408 - Side Bend (SC) | 1.498
Neon Flex 0606 - Top Bend (SC) |  |  | 2.00875 |  |  |  |  |  |  |  | Neon Flex 0408 - Side Bend (RGBW) | 0.6709999999999996 |  |  | Neon Flex 0408 - Side Bend (RGB) | 1.498
Neon Flex 0606 - Top Bend (RGB) |  |  | 2.00875 |  |  |  |  |  |  |  | Neon Flex 0411 - Side Bend (SC) | 0.9043000000000001 |  |  | Neon Flex 0408 - Side Bend (RGBW) | 1.498
Neon Flex 0606 - Top Bend (RGBW) |  | 3 | 3.011 |  |  |  |  |  |  |  | Neon Flex 0411 - Side Bend (RGB) | 0.4994999999999998 |  |  | Neon Flex 0411 - Side Bend (SC) | 1.3325
 |  |  |  |  |  |  |  |  |  |  | Neon Flex 0411 - Side Bend (RGBW) | 0.4644999999999999 |  |  | Neon Flex 0411 - Side Bend (RGB) | 1.3325
 |  |  |  |  |  |  |  |  |  |  | Neon Flex 0606 - Top Bend (SC) | 0.6154999999999999 |  |  | Neon Flex 0411 - Side Bend (RGBW) | 1.3325
 |  |  |  |  |  |  |  |  |  |  | Neon Flex 0606 - Top Bend (RGB) | 0.3445 |  |  | Neon Flex 0606 - Top Bend (SC) | 1.1605
 |  |  |  |  |  |  |  |  |  |  | Neon Flex 0606 - Top Bend (RGBW) | 0.3445 |  |  | Neon Flex 0606 - Top Bend (RGB) | 1.1605
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Neon Flex 0606 - Top Bend (RGBW) | 1.1605