Spreadsheet: 856024d1705426456-excel-formula-help-advice-for-a-dummy-eaton-panel-builder
Sheet: PRL1A PRL2A PART NUMBER DATA 

PRL1A
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE | CIRCUITS | BUS MATERIAL | BOX | 3P 4W MLO INTERIORS | SURFACE TRIM | FLUSH TRIM | STOCKED? Y OR N | BRANCH BREAKER FRAME
NO | N/A | 3PH | 120/208V | 100A | 18CC | AL | [NAME] | P1AL4A118I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 100A | 24CC | AL | [NAME] | P1AL4A124I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 100A | 30CC | AL | [NAME] | P1AL4A130I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 100A | 42CC | AL | EZB2042RC | P1AL4A142I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 18CC | AL | [NAME] | P1AL4A218I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 24CC | AL | [NAME] | P1AL4A224I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 30CC | AL | [NAME] | P1AL4A230I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 42CC | AL | EZB2042RC | P1AL4A242I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 60CC | AL | EZB2054RC | P1AL4A260I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 72CC | AL | [NAME] | P1AL4A272I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 84CC | AL | EZB2072RC | P1AL4A284I | EZT2072S | EZT2072F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 24CC | AL | EZB2042RC | P1AL4A424I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 30CC | AL | EZB2048RC | P1AL4A430I | EZT2048S | [NAME] |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 42CC | AL | EZB2054RC | P1AL4A442I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 60CC | AL | [NAME] | P1AL4A460I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 72CC | AL | EZB2072RC | P1AL4A472I | EZT2072F | EZT2072F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 84CC | AL | EZB2072RC | P1AL4A484I | EZT2072F | EZT2072F |  | BAB
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE? | CIRCUITS | BUS MATERIAL | BOX | 3PH 4W MLO INTERIORS | SURFACE TRIM | FLUSH TRIM | STOCKED? Y OR N | BRANCH BREAKER FRAME
NO | N/A | 3PH | 120/208V | 100A | 18CC | CU | [NAME] | P1AL4C118I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 100A | 24CC | CU | [NAME] | P1AL4C124I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 100A | 30CC | CU | [NAME] | P1AL4C130I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 100A | 42CC | CU | EZB2042RC | P1AL4C142I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 18CC | CU | [NAME] | P1AL4C218I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 24CC | CU | [NAME] | P1AL4C224I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 30CC | CU | [NAME] | P1AL4C230I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 42CC | CU | EZB2042RC | P1AL4C242I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 60CC | CU | EZB2054RC | P1AL4C260I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 72CC | CU | [NAME] | P1AL4C272I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 3PH | 120/208V | 225A | 84CC | CU | EZB2072RC | P1AL4C284I | EZT2072S | EZT2072F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 24CC | CU | EZB2042RC | P1AL4C424I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 30CC | CU | EZB2048RC | P1AL4C430I | EZT2048S | [NAME] |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 42CC | CU | EZB2054RC | P1AL4C442I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 60CC | CU | [NAME] | P1AL4C460I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 72CC | CU | EZB2072RC | P1AL4C472I | EZT2072F | EZT2072F |  | BAB
NO | N/A | 3PH | 120/208V | 400A | 84CC | CU | EZB2072RC | P1AL4C484I | EZT2072F | EZT2072F |  | BAB
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE? | CIRCUITS | BUS MATERIAL | BOX | 1PH 3W MLO INTERIORS | SURFACE TRIM | FLUSH TRIM | STOCKED? Y OR N | BRANCH BREAKER FRAME
NO | N/A | 1PH | 120/240V | 100A | 18CC | AL | [NAME] | P1AL1A118I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 100A | 24CC | AL | [NAME] | P1AL1A124I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 100A | 30CC | AL | [NAME] | P1AL1A130I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 18CC | AL | [NAME] | P1AL1A218I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 24CC | AL | [NAME] | P1AL1A224I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 30CC | AL | [NAME] | P1AL1A230I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 42CC | AL | EZB2042RC | P1AL1A242I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 60CC | AL | EZB2054RC | P1AL1A260I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 72CC | AL | [NAME] | P1AL1A272I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 24CC | AL | EZB2042RC | P1AL1A424I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 30CC | AL | EZB2048RC | P1AL1A430I | EZT2048S | [NAME] |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 42CC | AL | EZB2054RC | P1AL1A442I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 60CC | AL | [NAME] | P1AL1A460I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 72CC | AL | EZB2072RC | P1AL1A472I | EZT2072S | EZT2072F |  | BAB
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE? | CIRCUITS | BUS MATERIAL | BOX | 1PH 3W MLO INTERIORS | SURFACE TRIM | FLUSH TRIM | STOCKED? Y OR N | BRANCH BREAKER FRAME
NO | N/A | 1PH | 120/240V | 100A | 18CC | CU | [NAME] | P1AL1C118I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 100A | 24CC | CU | [NAME] | P1AL1C124I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 100A | 30CC | CU | [NAME] | P1AL1C130I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 18CC | CU | [NAME] | P1AL1C218I | EZT2030S | EZT2030F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 24CC | CU | [NAME] | P1AL1C224I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 30CC | CU | [NAME] | P1AL1C230I | EZT2036S | EZT2036F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 42CC | CU | EZB2042RC | P1AL1C242I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 60CC | CU | EZB2054RC | P1AL1C260I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 1PH | 120/240V | 225A | 72CC | CU | [NAME] | P1AL1C272I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 24CC | CU | EZB2042RC | P1AL1C424I | EZT2042S | EZT2042F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 30CC | CU | EZB2048RC | P1AL1C430I | EZT2048S | [NAME] |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 42CC | CU | EZB2054RC | P1AL1C442I | EZT2054S | EZT2054F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 60CC | CU | [NAME] | P1AL1C460I | EZT2060S | EZT2060F |  | BAB
NO | N/A | 1PH | 120/240V | 400A | 72CC | CU | EZB2072RC | P1AL1C472I | EZT2072S | EZT2072F |  | BAB
PRL2A
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE? | CIRCUITS | BUS MATERIAL | BOX | 3PH 4W MLO INTERIORS | SURFACE TRIM | FLUSH TRIM | STOCKED? Y OR N | BRANCH BREAKER FRAME
NO | N/A | 3PH | 347V/600V | 100A | 18CC | AL | [NAME] | P2AL4A118I | EZT2030S | EZT2030F |  | GBH
NO | N/A | 3PH | 347V/600V | 100A | 24CC | AL | [NAME] | P2AL4A124I | EZT2030S | EZT2030F |  | GBH
NO | N/A | 3PH | 347V/600V | 100A | 30CC | AL | [NAME] | P2AL4A130I | EZT2030S | EZT2030F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 24CC | AL | [NAME] | P2AL4A224I | EZT2036S | EZT2036F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 30CC | AL | [NAME] | P2AL4A230I | EZT2036S | EZT2036F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 42CC | AL | EZB2042RC | P2AL4A242I | EZT2042S | EZT2042F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 60CC | AL | EZB2054RC | P2AL4A260I | EZT2054S | EZT2054F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 72CC | AL | [NAME] | P2AL4A272I | EZT2060S | EZT2060F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 24CC | AL | EZB2042RC | P2AL4A424I | EZT2042S | EZT2042F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 30CC | AL | EZB2048RC | P2AL4A430I | EZT2048S | [NAME] |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 42CC | AL | EZB2054RC | P2AL4A442I | EZT2054S | EZT2054F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 60CC | AL | [NAME] | P2AL4A460I | EZT2060S | EZT2060F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 72CC | AL | EZB2072RC | P2AL4A472I | EZT2072S | EZT2072F |  | GBH
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE? | CIRCUITS | BUS MATERIAL | BOX | 3PH 4W MLO INTERIORS | SURFACE TRIM | FLUSH TRIM | STOCKED? Y OR N | BRANCH BREAKER FRAME
NO | N/A | 3PH | 347V/600V | 100A | 18CC | CU | [NAME] | P2AL4C118I | EZT2030S | EZT2030F |  | GBH
NO | N/A | 3PH | 347V/600V | 100A | 24CC | CU | [NAME] | P2AL4C124I | EZT2030S | EZT2030F |  | GBH
NO | N/A | 3PH | 347V/600V | 100A | 30CC | CU | [NAME] | P2AL4C130I | EZT2030S | EZT2030F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 24CC | CU | [NAME] | P2AL4C224I | EZT2036S | EZT2036F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 30CC | CU | [NAME] | P2AL4C230I | EZT2036S | EZT2036F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 42CC | CU | EZB2042RC | P2AL4C242I | EZT2042S | EZT2042F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 60CC | CU | EZB2054RC | P2AL4C260I | EZT2054S | EZT2054F |  | GBH
NO | N/A | 3PH | 347V/600V | 225A | 72CC | CU | [NAME] | P2AL4C272I | EZT2060S | EZT2060F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 24CC | CU | EZB2042RC | P2AL4C424I | EZT2042S | EZT2042F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 30CC | CU | EZB2048RC | P2AL4C430I | EZT2048S | [NAME] |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 42CC | CU | EZB2054RC | P2AL4C442I | EZT2054S | EZT2054F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 60CC | CU | [NAME] | P2AL4C460I | EZT2060S | EZT2060F |  | GBH
NO | N/A | 3PH | 347V/600V | 400A | 72CC | CU | EZB2072RC | P2AL4C472I | EZT2072S | EZT2072F |  | GBH
MAIN BREAKER? | IF YES, AMPERAGE? | 1PH OR 3PH | VOLTAGE | BUS AMPERAGE? | CIRCUITS | BUS MATERIAL | BOX | 3P 4W MAIN BREAKER INTERIOR | SURFACE TRIM | FLUSH TRIM
YES | 200A | 3PH | 120/208V | 225A | 42CC | AL | EZB2048RC | P1AT4A242ED200I | EZT2048S | [NAME]