I am having trouble with this dependent drop down. My Wattage sheet is my master table. My ADD sheet is where I want to add the information. I would like to be able to have only the items listed in the other categories be available in my drop down on the ADD sheet. For example, if I choose CFL Fixture then I only want the the three types of subcategories to show.
Even better would be where I could choose the lamp wattage in column E then only those type of fixtures would be available to choose in the Column B, C, and D and vice versa. Is this possible?
Here is a link to the file: http://s000.tinyupload.com/index.php?file_id=23805702498562756109
Master Table
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Order[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]162[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF26/6-L[/TD]
[TD="align: center"]CF26W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 26W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]162[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]228[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF32/6-L[/TD]
[TD="align: center"]CF32W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 32W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]228[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF42/6-L[/TD]
[TD="align: center"]CF42W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 42W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"]57[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFQ26/6-L[/TD]
[TD="align: center"]CFQ26W[/TD]
[TD="align: center"]Compact Fluorescent, quad, (6) 26W lamp, BF=0.95[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]82[/TD]
[TD="align: center"]81[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT32/6-L[/TD]
[TD="align: center"]CFM32W[/TD]
[TD="align: center"]Compact Fluorescent, twin or multi, (6) 32W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]84[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]212[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-BX[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 36W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]212[/TD]
[TD="align: center"]86[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-L[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 36W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]86[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-LH[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 36W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"]104[/TD]
[TD="align: center"]103[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]204[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-BX[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 40W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]204[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]104[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-L[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 40W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"]106[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]233[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-LH[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 40W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]233[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"]118[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]324[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT50/6-BX[/TD]
[TD="align: center"]CFT50W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 50W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]324[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]127[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]336[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-BX[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 55W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]336[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]352[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-L[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 55W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]352[/TD]
[TD="align: center"]130[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]373[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-LH[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 55W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]373[/TD]
[TD="align: center"]259[/TD]
[TD="align: center"]265[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F26SE[/TD]
[TD="align: center"]F20T12[/TD]
[TD="align: center"]Fluorescent, (6) 24", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"]260[/TD]
[TD="align: center"]266[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]168[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F26SS[/TD]
[TD="align: center"]F20T12[/TD]
[TD="align: center"]Fluorescent, (6) 24", STD lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]168[/TD]
[TD="align: center"]327[/TD]
[TD="align: center"]333[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36EE[/TD]
[TD="align: center"]F30T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 36", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]334[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]134[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36ILL-R[/TD]
[TD="align: center"]F25T8[/TD]
[TD="align: center"]Fluorescent, (6) 36", T-8 lamp, Instant Start Ballast, RLO (BF<.85)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]134[/TD]
[TD="align: center"]329[/TD]
[TD="align: center"]335[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]238[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36SE[/TD]
[TD="align: center"]F30T12[/TD]
[TD="align: center"]Fluorescent, (6) 36", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]238[/TD]
[TD="align: center"]331[/TD]
[TD="align: center"]514[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T5HO Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]351[/TD]
[TD="align: center"]T5[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46GHL[/TD]
[TD="align: center"]F48T5/HO[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD HO T5 lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]351[/TD]
[TD="align: center"]406[/TD]
[TD="align: center"]656[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T5HO Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]364[/TD]
[TD="align: center"]T5[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46GHL-H[/TD]
[TD="align: center"]F54T5/HO[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD HO T5 lamp HLO (BF: .96-1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]364[/TD]
[TD="align: center"]501[/TD]
[TD="align: center"]507[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EE[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"]502[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EL[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"]503[/TD]
[TD="align: center"]509[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]236[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ES[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]236[/TD]
[TD="align: center"]505[/TD]
[TD="align: center"]511[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]506[/TD]
[TD="align: center"]512[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]156[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-R[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, RLO (BF< .85)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]156[/TD]
[TD="align: center"]507[/TD]
[TD="align: center"]513[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]182[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46LL[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]182[/TD]
[TD="align: center"]509[/TD]
[TD="align: center"]515[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SE[/TD]
[TD="align: center"]F40T12[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"]510[/TD]
[TD="align: center"]516[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SS[/TD]
[TD="align: center"]F40T12[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"]554[/TD]
[TD="align: center"]510[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown HO[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]405[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EHS[/TD]
[TD="align: center"]F48T12/HO/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES HO lamp (3.5' lamp)[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]405[/TD]
[TD="align: center"]635[/TD]
[TD="align: center"]644[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86ILL[/TD]
[TD="align: center"]F96T8[/TD]
[TD="align: center"]Fluorescent, (6) 96", T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]636[/TD]
[TD="align: center"]645[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]369[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EE[/TD]
[TD="align: center"]F96T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]369[/TD]
[TD="align: center"]637[/TD]
[TD="align: center"]646[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]330[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EL[/TD]
[TD="align: center"]F96T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]330[/TD]
[TD="align: center"]639[/TD]
[TD="align: center"]648[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]222[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-H[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, HLO (BF: .96-1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]222[/TD]
[TD="align: center"]640[/TD]
[TD="align: center"]649[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]255[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-V[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, VLO (BF: >1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]255[/TD]
[TD="align: center"]641[/TD]
[TD="align: center"]650[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]158[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SIL[/TD]
[TD="align: center"]F30T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", 30W T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]158[/TD]
[TD="align: center"]642[/TD]
[TD="align: center"]651[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SSIL[/TD]
[TD="align: center"]F28T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", 28W T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]674[/TD]
[TD="align: center"]643[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown HO[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]721[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EHS[/TD]
[TD="align: center"]F96T12/HO/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES HO lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]721[/TD]
</tbody>
Sheet to add the information
<tbody>
[TD="align: center"]6[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"][/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
</tbody>
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Workbook Defined Names[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Name[/TH]
[TH="align: left"]Refers To[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Type[/TH]
[TD="align: left"]=OFFSET(CODES!$V:$V, 0, 0, COUNTA(CODES!$V:$V))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
</tbody>
[TABLE="width: 85%"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I tried making dependent drop downs the traditional way but I would need so many. For instance, for a metal halide fixture only these wattages are available.
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Order[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"]759[/TD]
[TD="align: center"]862[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH32/1[/TD]
[TD="align: center"]MH32[/TD]
[TD="align: center"]Metal Halide, (1) 32W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"]760[/TD]
[TD="align: center"]870[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH35/1[/TD]
[TD="align: center"]MH35[/TD]
[TD="align: center"]Metal Halide, (1) 35W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]761[/TD]
[TD="align: center"]871[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH50/1[/TD]
[TD="align: center"]MH50[/TD]
[TD="align: center"]Metal Halide, (1) 50W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]762[/TD]
[TD="align: center"]872[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH70/1[/TD]
[TD="align: center"]MH70[/TD]
[TD="align: center"]Metal Halide, (1) 70W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]763[/TD]
[TD="align: center"]854[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH100/1[/TD]
[TD="align: center"]MH100[/TD]
[TD="align: center"]Metal Halide, (1) 100W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]764[/TD]
[TD="align: center"]856[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH150/1[/TD]
[TD="align: center"]MH150[/TD]
[TD="align: center"]Metal Halide, (1) 150W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"]765[/TD]
[TD="align: center"]858[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]215[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH175/1[/TD]
[TD="align: center"]MH175[/TD]
[TD="align: center"]Metal Halide, (1) 175W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]215[/TD]
[TD="align: center"]766[/TD]
[TD="align: center"]860[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]232[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH200/1[/TD]
[TD="align: center"]MH200[/TD]
[TD="align: center"]Metal Halide, (1) 200W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]232[/TD]
[TD="align: center"]767[/TD]
[TD="align: center"]861[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]295[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH250/1[/TD]
[TD="align: center"]MH250[/TD]
[TD="align: center"]Metal Halide, (1) 250W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]295[/TD]
[TD="align: center"]768[/TD]
[TD="align: center"]863[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]342[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH300/1[/TD]
[TD="align: center"]MH300[/TD]
[TD="align: center"]Metal Halide, (1) 300W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]342[/TD]
[TD="align: center"]769[/TD]
[TD="align: center"]864[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]320[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH320/1[/TD]
[TD="align: center"]MH320[/TD]
[TD="align: center"]Metal Halide, (1) 320W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]320[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"]770[/TD]
[TD="align: center"]865[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]350[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH350/1[/TD]
[TD="align: center"]MH350[/TD]
[TD="align: center"]Metal Halide, (1) 350W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]350[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]771[/TD]
[TD="align: center"]866[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]360[/TD]
[TD="align: center"]430[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH360/1[/TD]
[TD="align: center"]MH360[/TD]
[TD="align: center"]Metal Halide, (1) 360W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]360[/TD]
[TD="align: center"]430[/TD]
[TD="align: center"]772[/TD]
[TD="align: center"]867[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]458[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH400/1[/TD]
[TD="align: center"]MH400[/TD]
[TD="align: center"]Metal Halide, (1) 400W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]458[/TD]
[TD="align: center"]773[/TD]
[TD="align: center"]869[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH450/1[/TD]
[TD="align: center"]MH450[/TD]
[TD="align: center"]Metal Halide, (1) 450W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"]774[/TD]
[TD="align: center"]873[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]850[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH750/1[/TD]
[TD="align: center"]MH750[/TD]
[TD="align: center"]Metal Halide, (1) 750W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]850[/TD]
[TD="align: center"]775[/TD]
[TD="align: center"]868[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]916[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH400/2[/TD]
[TD="align: center"]MH400[/TD]
[TD="align: center"]Metal Halide, (2) 400W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]916[/TD]
[TD="align: center"]776[/TD]
[TD="align: center"]855[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]1080[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1000/1[/TD]
[TD="align: center"]MH1000[/TD]
[TD="align: center"]Metal Halide, (1) 1000W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]1080[/TD]
[TD="align: center"]777[/TD]
[TD="align: center"]857[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]1610[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1500/1[/TD]
[TD="align: center"]MH1500[/TD]
[TD="align: center"]Metal Halide, (1) 1500W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]1610[/TD]
[TD="align: center"]778[/TD]
[TD="align: center"]859[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1800[/TD]
[TD="align: center"]1875[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1800/1[/TD]
[TD="align: center"]MH1800[/TD]
[TD="align: center"]Metal Halide, (1) 1800W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1800[/TD]
[TD="align: center"]1875[/TD]
</tbody>
This is how I was doing it before I gave up:
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Lamps per Fixture List[/TD]
[TD="align: right"][/TD]
[TD="align: center"]_0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]_1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_0[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]_0.5[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_1[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_1.5[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_2[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_2[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_3[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_3[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_4[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_4[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_5[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_5[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_6[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_6[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_8[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_7[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_9[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_7.5[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_10[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_8[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_12[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_9[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_10[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_10.5[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_11[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_12[/TD]
</tbody>
Is there an easier solution? Thank you in advance. I apologize if I did not post the pictures correctly.
Even better would be where I could choose the lamp wattage in column E then only those type of fixtures would be available to choose in the Column B, C, and D and vice versa. Is this possible?
Here is a link to the file: http://s000.tinyupload.com/index.php?file_id=23805702498562756109
Master Table
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Order[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]162[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF26/6-L[/TD]
[TD="align: center"]CF26W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 26W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]162[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]228[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF32/6-L[/TD]
[TD="align: center"]CF32W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 32W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]228[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CF42/6-L[/TD]
[TD="align: center"]CF42W[/TD]
[TD="align: center"]Compact Fluorescent, (6) 42W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"]57[/TD]
[TD="align: center"]56[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFQ26/6-L[/TD]
[TD="align: center"]CFQ26W[/TD]
[TD="align: center"]Compact Fluorescent, quad, (6) 26W lamp, BF=0.95[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]82[/TD]
[TD="align: center"]81[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT32/6-L[/TD]
[TD="align: center"]CFM32W[/TD]
[TD="align: center"]Compact Fluorescent, twin or multi, (6) 32W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]84[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]212[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-BX[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 36W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]212[/TD]
[TD="align: center"]86[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-L[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 36W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]86[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT36/6-LH[/TD]
[TD="align: center"]CFT36W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 36W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"]104[/TD]
[TD="align: center"]103[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]204[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-BX[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 40W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]204[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]104[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-L[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 40W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]220[/TD]
[TD="align: center"]106[/TD]
[TD="align: center"]105[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]233[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT40/6-LH[/TD]
[TD="align: center"]CFT40W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 40W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]233[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"]118[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]324[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT50/6-BX[/TD]
[TD="align: center"]CFT50W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 50W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]324[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]127[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]336[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-BX[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, Biax, (6) 55W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]336[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]352[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-L[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 55W lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]352[/TD]
[TD="align: center"]130[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]CFL[/TD]
[TD="align: center"]CFL Fixture[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]373[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Compact Fluorescent Light Fixtures[/TD]
[TD="align: center"]CFT55/6-LH[/TD]
[TD="align: center"]CFT55W[/TD]
[TD="align: center"]Compact Fluorescent, long Twin, (6) 55W lamp/ High Ballast Factor[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]373[/TD]
[TD="align: center"]259[/TD]
[TD="align: center"]265[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F26SE[/TD]
[TD="align: center"]F20T12[/TD]
[TD="align: center"]Fluorescent, (6) 24", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"]260[/TD]
[TD="align: center"]266[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]168[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F26SS[/TD]
[TD="align: center"]F20T12[/TD]
[TD="align: center"]Fluorescent, (6) 24", STD lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]168[/TD]
[TD="align: center"]327[/TD]
[TD="align: center"]333[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36EE[/TD]
[TD="align: center"]F30T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 36", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]198[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]334[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]134[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36ILL-R[/TD]
[TD="align: center"]F25T8[/TD]
[TD="align: center"]Fluorescent, (6) 36", T-8 lamp, Instant Start Ballast, RLO (BF<.85)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]134[/TD]
[TD="align: center"]329[/TD]
[TD="align: center"]335[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]238[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F36SE[/TD]
[TD="align: center"]F30T12[/TD]
[TD="align: center"]Fluorescent, (6) 36", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]238[/TD]
[TD="align: center"]331[/TD]
[TD="align: center"]514[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T5HO Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]351[/TD]
[TD="align: center"]T5[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46GHL[/TD]
[TD="align: center"]F48T5/HO[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD HO T5 lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]351[/TD]
[TD="align: center"]406[/TD]
[TD="align: center"]656[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T5HO Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]364[/TD]
[TD="align: center"]T5[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46GHL-H[/TD]
[TD="align: center"]F54T5/HO[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD HO T5 lamp HLO (BF: .96-1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]364[/TD]
[TD="align: center"]501[/TD]
[TD="align: center"]507[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EE[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"]502[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EL[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]186[/TD]
[TD="align: center"]503[/TD]
[TD="align: center"]509[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]236[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ES[/TD]
[TD="align: center"]F40T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]236[/TD]
[TD="align: center"]505[/TD]
[TD="align: center"]511[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]506[/TD]
[TD="align: center"]512[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]156[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-R[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, RLO (BF< .85)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]156[/TD]
[TD="align: center"]507[/TD]
[TD="align: center"]513[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]182[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46LL[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]182[/TD]
[TD="align: center"]509[/TD]
[TD="align: center"]515[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SE[/TD]
[TD="align: center"]F40T12[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"]510[/TD]
[TD="align: center"]516[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SS[/TD]
[TD="align: center"]F40T12[/TD]
[TD="align: center"]Fluorescent, (6) 48", STD lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]282[/TD]
[TD="align: center"]554[/TD]
[TD="align: center"]510[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown HO[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]405[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46EHS[/TD]
[TD="align: center"]F48T12/HO/ES[/TD]
[TD="align: center"]Fluorescent, (6) 48", ES HO lamp (3.5' lamp)[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]405[/TD]
[TD="align: center"]635[/TD]
[TD="align: center"]644[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86ILL[/TD]
[TD="align: center"]F96T8[/TD]
[TD="align: center"]Fluorescent, (6) 96", T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]59[/TD]
[TD="align: center"]328[/TD]
[TD="align: center"]636[/TD]
[TD="align: center"]645[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]369[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EE[/TD]
[TD="align: center"]F96T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES lamp[/TD]
[TD="align: center"]Mag-ES[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]369[/TD]
[TD="align: center"]637[/TD]
[TD="align: center"]646[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]330[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EL[/TD]
[TD="align: center"]F96T12/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES lamp[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]330[/TD]
[TD="align: center"]639[/TD]
[TD="align: center"]648[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]222[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-H[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, HLO (BF: .96-1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]222[/TD]
[TD="align: center"]640[/TD]
[TD="align: center"]649[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]255[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46ILL-V[/TD]
[TD="align: center"]F32T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", T-8 lamp, Instant Start Ballast, VLO (BF: >1.2)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]255[/TD]
[TD="align: center"]641[/TD]
[TD="align: center"]650[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]158[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SIL[/TD]
[TD="align: center"]F30T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", 30W T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]158[/TD]
[TD="align: center"]642[/TD]
[TD="align: center"]651[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]T8 Linear Fluorescent[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]T8[/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F46SSIL[/TD]
[TD="align: center"]F28T8[/TD]
[TD="align: center"]Fluorescent, (6) 48", 28W T-8 lamp, Instant Start Ballast, NLO (BF: .85-.95)[/TD]
[TD="align: center"]Electronic[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"]674[/TD]
[TD="align: center"]643[/TD]
[TD="align: center"]Linear Fluorescent[/TD]
[TD="align: center"]Unknown HO[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]721[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Linear Fluorescent Fixtures[/TD]
[TD="align: center"]F86EHS[/TD]
[TD="align: center"]F96T12/HO/ES[/TD]
[TD="align: center"]Fluorescent, (6) 96", ES HO lamp[/TD]
[TD="align: center"]Mag-STD[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]721[/TD]
</tbody>
Wattage
Sheet to add the information
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
<tbody>
[TD="align: center"]6[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"][/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
</tbody>
ADD
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Workbook Defined Names[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Name[/TH]
[TH="align: left"]Refers To[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Type[/TH]
[TD="align: left"]=OFFSET(CODES!$V:$V, 0, 0, COUNTA(CODES!$V:$V))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
V | |
---|---|
Lighting Category | |
CFL | |
Circular Fluorescent | |
Exit Sign | |
LED | |
Incandescent | |
Linear Fluorescent | |
High Intensity Discharge | |
Induction Fluorescent | |
U_Tube Fluorescent |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
</tbody>
CODES
[TABLE="width: 85%"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I tried making dependent drop downs the traditional way but I would need so many. For instance, for a metal halide fixture only these wattages are available.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Order[/TD]
[TD="align: center"]Lighting Category[/TD]
[TD="align: center"]Lighting Subcategory[/TD]
[TD="align: center"]# of Lamps per Fixture[/TD]
[TD="align: center"]Lamp Wattage[/TD]
[TD="align: center"]Fixture Wattage[/TD]
[TD="align: center"]Lamp Type[/TD]
[TD="align: center"]FIXTURE Type[/TD]
[TD="align: center"]FIXTURE CODE[/TD]
[TD="align: center"]LAMP CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"]BALLAST[/TD]
[TD="align: center"]LAMP / FIXT[/TD]
[TD="align: center"]WATT / LAMP[/TD]
[TD="align: center"]WATT / FIXT[/TD]
[TD="align: center"]759[/TD]
[TD="align: center"]862[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH32/1[/TD]
[TD="align: center"]MH32[/TD]
[TD="align: center"]Metal Halide, (1) 32W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"]760[/TD]
[TD="align: center"]870[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH35/1[/TD]
[TD="align: center"]MH35[/TD]
[TD="align: center"]Metal Halide, (1) 35W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]761[/TD]
[TD="align: center"]871[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH50/1[/TD]
[TD="align: center"]MH50[/TD]
[TD="align: center"]Metal Halide, (1) 50W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]762[/TD]
[TD="align: center"]872[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH70/1[/TD]
[TD="align: center"]MH70[/TD]
[TD="align: center"]Metal Halide, (1) 70W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]763[/TD]
[TD="align: center"]854[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH100/1[/TD]
[TD="align: center"]MH100[/TD]
[TD="align: center"]Metal Halide, (1) 100W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]128[/TD]
[TD="align: center"]764[/TD]
[TD="align: center"]856[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH150/1[/TD]
[TD="align: center"]MH150[/TD]
[TD="align: center"]Metal Halide, (1) 150W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"]765[/TD]
[TD="align: center"]858[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]215[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH175/1[/TD]
[TD="align: center"]MH175[/TD]
[TD="align: center"]Metal Halide, (1) 175W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]175[/TD]
[TD="align: center"]215[/TD]
[TD="align: center"]766[/TD]
[TD="align: center"]860[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]232[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH200/1[/TD]
[TD="align: center"]MH200[/TD]
[TD="align: center"]Metal Halide, (1) 200W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]232[/TD]
[TD="align: center"]767[/TD]
[TD="align: center"]861[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]295[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH250/1[/TD]
[TD="align: center"]MH250[/TD]
[TD="align: center"]Metal Halide, (1) 250W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]250[/TD]
[TD="align: center"]295[/TD]
[TD="align: center"]768[/TD]
[TD="align: center"]863[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]342[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH300/1[/TD]
[TD="align: center"]MH300[/TD]
[TD="align: center"]Metal Halide, (1) 300W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]342[/TD]
[TD="align: center"]769[/TD]
[TD="align: center"]864[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]320[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH320/1[/TD]
[TD="align: center"]MH320[/TD]
[TD="align: center"]Metal Halide, (1) 320W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]320[/TD]
[TD="align: center"]365[/TD]
[TD="align: center"]770[/TD]
[TD="align: center"]865[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]350[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH350/1[/TD]
[TD="align: center"]MH350[/TD]
[TD="align: center"]Metal Halide, (1) 350W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]350[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]771[/TD]
[TD="align: center"]866[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]360[/TD]
[TD="align: center"]430[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH360/1[/TD]
[TD="align: center"]MH360[/TD]
[TD="align: center"]Metal Halide, (1) 360W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]360[/TD]
[TD="align: center"]430[/TD]
[TD="align: center"]772[/TD]
[TD="align: center"]867[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]458[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH400/1[/TD]
[TD="align: center"]MH400[/TD]
[TD="align: center"]Metal Halide, (1) 400W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]458[/TD]
[TD="align: center"]773[/TD]
[TD="align: center"]869[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH450/1[/TD]
[TD="align: center"]MH450[/TD]
[TD="align: center"]Metal Halide, (1) 450W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]450[/TD]
[TD="align: center"]508[/TD]
[TD="align: center"]774[/TD]
[TD="align: center"]873[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]850[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH750/1[/TD]
[TD="align: center"]MH750[/TD]
[TD="align: center"]Metal Halide, (1) 750W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]850[/TD]
[TD="align: center"]775[/TD]
[TD="align: center"]868[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]916[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH400/2[/TD]
[TD="align: center"]MH400[/TD]
[TD="align: center"]Metal Halide, (2) 400W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]400[/TD]
[TD="align: center"]916[/TD]
[TD="align: center"]776[/TD]
[TD="align: center"]855[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]1080[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1000/1[/TD]
[TD="align: center"]MH1000[/TD]
[TD="align: center"]Metal Halide, (1) 1000W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]1080[/TD]
[TD="align: center"]777[/TD]
[TD="align: center"]857[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]1610[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1500/1[/TD]
[TD="align: center"]MH1500[/TD]
[TD="align: center"]Metal Halide, (1) 1500W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]1610[/TD]
[TD="align: center"]778[/TD]
[TD="align: center"]859[/TD]
[TD="align: center"]High Intensity Discharge[/TD]
[TD="align: center"]Metal Halide[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1800[/TD]
[TD="align: center"]1875[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Metal Halide Fixtures[/TD]
[TD="align: center"]MH1800/1[/TD]
[TD="align: center"]MH1800[/TD]
[TD="align: center"]Metal Halide, (1) 1800W lamp[/TD]
[TD="align: center"]CWA[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1800[/TD]
[TD="align: center"]1875[/TD]
</tbody>
Wattage
This is how I was doing it before I gave up:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Lighting Category List | CFL List | Circular Fluorescent List | Delamp List | Exit Sign List | High Intensity Discharge List | Incandescent List | Induction Fluorescent List | LED List | Linear Fluorescent List | None List | U-Tube Fluorescent List | ||||||||||||||||||
CFL | CFL Fixture | Circular Fluorescent | Delamp | Exit Sign | High Pressure Sodium | Halogen Incandescent | Induction Fluorescent | LED Fixture | T5 Linear Fluorescent | DND | U-Tube Fluorescent | ||||||||||||||||||
Circular Fluorescent | CFL Screw-In | Exit Sign LED | Mercury Vapor | Standard Incandescent | LED Screw-In | T5HO Linear Fluorescent | N/A | ||||||||||||||||||||||
Delamp | CFL Screw-In LED | Metal Halide | LED Exit Sign | T8 Linear Fluorescent | |||||||||||||||||||||||||
Exit Sign | Cold Cathode CFL | Pulse Start Metal Halide | CFL Screw-In LED | T8HO Linear Fluorescent | |||||||||||||||||||||||||
High Intensity Discharge | T10 Linear Fluorescent | ||||||||||||||||||||||||||||
Incandescent | T12 Linear Fluorescent | ||||||||||||||||||||||||||||
Induction Fluorescent | Unknown | ||||||||||||||||||||||||||||
LED | Unknown HO | ||||||||||||||||||||||||||||
Linear Fluorescent | |||||||||||||||||||||||||||||
U_Tube Fluorescent | |||||||||||||||||||||||||||||
None | |||||||||||||||||||||||||||||
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Lamps per Fixture List[/TD]
[TD="align: right"][/TD]
[TD="align: center"]_0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]_1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_0[/TD]
[TD="align: right"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]_0.5[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_1[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_1.5[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_2[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_2[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_3[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_3[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_4[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_4[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_5[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_5[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_6[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_6[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_8[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_7[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_9[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_7.5[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_10[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_8[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]_12[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_9[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_10[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_10.5[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_11[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]_12[/TD]
</tbody>
Wattage Table Codes
Is there an easier solution? Thank you in advance. I apologize if I did not post the pictures correctly.