{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Part Matrix","Master","Configurator","BOM_Summary"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Part Matrix","index":0,"n_rows":44,"n_cols":45,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Plug","Receptacle","Connector","Inlet","AWG","Phase","Voltage","Amperage","Wires","Poles","Conductors","Conduit Trade Size","TradeSize2","WIRE","Wire1","Wire2","Wire3","Wire4","Wire5","Config","P&S Labor","Combo1","HBL Plug","HBL Recptacle","HBL Connector","Non-Metallic Back Box","Back Box Hub Size","Back Box Angle","Cast-Metal Back Box","Cable",null,"Select Conduit Color","Select Conduit Type",null,"Select Insulation Type",null,"Non-Metallic Back Box",null,"Adapter Fitting",null,"Connection Device",null,"AWG","Wires","Conduit Trade Size"]
["None","None","None","None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00",null,null,null,null,null,null,null,null,null,null,null,"Blue","LFMC",null,"THHN / THWN / THWN-2",null,"None",null,"None",null,"None",{"$f":"AQ2&AR2","v":"33"},3,3,"1\""]
["320P4W","320R4W","320C4W","320B4W",12,"Single","125V",20,3,2,3,"1/2\"","1/2\"",{"$f":"\"THHN-\"&E3&\"\"","v":"THHN-12"},"Black","White","Green","N/A","N/A","01",10,{"$f":"L3&E3","v":"1/2\"12"},{"$f":"\"HBL\"&B3","v":"HBL320R4W"},{"$f":"\"HBL\"&C3","v":"HBL320C4W"},"HBL320B4W","2030N","1\" NPT","15°","BB301W (Aluminum)",{"$f":"N3&\"-\"&I3","v":"THHN-12-3"},null,"Gray","FMC",null,null,null,"2030N",null,"Straight",null,"Near End",{"$f":"AQ3&AR3","v":"34"},3,4,"1-1/4\""]
["320P6W","320R6W","320C6W","320B6W",12,"Single","250V",20,3,2,3,"1/2\"","1/2\"",{"$f":"\"THHN-\"&E4&\"\"","v":"THHN-12"},"Black","Red","Green",null,null,"02",10,{"$f":"L4&E4","v":"1/2\"12"},{"$f":"\"HBL\"&B4","v":"HBL320R6W"},{"$f":"\"HBL\"&C4","v":"HBL320C6W"},{"$f":"\"HBL\"&D4","v":"HBL320B6W"},"2030N","1\" NPT","15°","BB301W (Aluminum)",{"$f":"N4&\"-\"&I4","v":"THHN-12-3"},null,"Red",null,null,null,null,"60N",null,"90 Degrees",null,"Far End","35",3,5,"1-1/4\""]
["320P7W","320R7W","320C7W","320B7W",12,"Single","480V",20,3,2,3,"1/2\"","1/2\"","THHN-12","Brown","Orange","Green",null,null,"03",10,"1/2\"12","HBL320R7W","HBL320C7W","HBL320B7W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-3",null,"Black",null,null,null,null,"100N",null,"45 Degrees",null,null,"63",6,3,"1\""]
["420P12W","420R12W","420C12W","420B12W",12,"Single","125/250V",20,4,3,3,"1/2\"","1/2\"","THHN-12","Black","Red","White","Green",null,"04",10,"1/2\"12","HBL420R12W","HBL420C12W","HBL420B12W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-4",null,"Custom",null,null,null,null,null,null,null,null,null,"64",6,4,"1\""]
["420P9W","420R9W","420C9W","420B9W",12,"Three","250V",20,4,3,3,"1/2\"","1/2\"","THHN-12","Black","Red","Blue","Green",null,"05",10,"1/2\"12","HBL420R9W","HBL420C9W","HBL420B9W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-4",null,null,null,null,null,null,null,null,null,null,null,"65",6,5,"1-1/4\""]
["420P7W","420R7W","420C7W","420B7W",12,"Three","480V",20,4,3,3,"1/2\"","1/2\"","THHN-12","Brown","Orange","Yellow","Green",null,"06",10,"1/2\"12","HBL420R7W","HBL420C7W","HBL420B7W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-4",null,null,null,null,null,null,null,null,null,null,null,"103",10,3,"1/2\""]
["420P5W","420R5W","420C5W","420B5W",12,"Three","600V",20,4,3,3,"1/2\"","1/2\"","THHN-12","Brown","Orange","Yellow","Green",null,"07",10,"1/2\"12","HBL420R5W","HBL420C5W","HBL420B5W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-4",null,null,null,null,null,null,null,null,null,null,null,"104",10,4,"0.75\""]
["520P9W","520R9W","520C9W","520B9W",12,"Three","120/208V",20,5,4,3,"1/2\"","1/2\"","THHN-12","Black","Red","Blue","White","Green","08",10,"1/2\"12","HBL520R9W","HBL520C9W","HBL520B9W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-5",null,null,null,null,null,null,null,null,null,null,null,"105",10,5,"0.75\""]
["520P7W","520R7W","520C7W","520B7W",12,"Three","277/480V",20,5,4,3,"1/2\"","1/2\"","THHN-12","Brown","Orange","Yellow","Gray","Green","09",10,"1/2\"12","HBL520R7W","HBL520C7W","HBL520B7W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-5",null,null,null,null,null,null,null,null,null,null,null,"123",12,3,"1/2\""]
["520P5W","520R5W","520C5W","520B5W",12,"Three","347/600V",20,5,4,3,"1/2\"","1/2\"","THHN-12","Brown","Orange","Yellow","Gray","Green","10",10,"1/2\"12","HBL520R5W","HBL520C5W","HBL520B5W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-12-5",null,null,null,null,null,null,null,null,null,null,null,"124",12,4,"1/2\""]
["330P4W","330R4W","330C4W","330B4W",10,"Single","125V",30,3,2,3,"1/2\"","1/2\"","THHN-10","Black","White","Green",null,null,"11",15,"1/2\"10","HBL330R4W","HBL330C4W","HBL330B4W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-3",null,null,null,null,null,null,null,null,null,null,null,"125",12,5,"1/2\""]
["330P6W","330R6W","330C6W","330B6W",10,"Single","250V",30,3,2,3,"1/2\"","1/2\"","THHN-10","Black","White","Green",null,null,"12",15,"1/2\"10","HBL330R6W","HBL330C6W","HBL330B6W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-3"]
["330P7W","330R7W","330C7W","330B7W",10,"Single","480V",30,3,2,3,"1/2\"","1/2\"","THHN-10","Brown","Orange","Green",null,null,"13",15,"1/2\"10","HBL330R7W","HBL330C7W","HBL330B7W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-3"]
["430P12W","430R12W","430C12W","430B12W",10,"Single","125/250V",30,4,3,3,"0.75\"","1/2\"","THHN-10","Black","Red","White","Green",null,"14",15,"0.75\"10","HBL430R12W","HBL430C12W","HBL430B12W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-4"]
["430P9W","430R9W","430C9W","430B9W",10,"Three","250V",30,4,3,3,"0.75\"","1/2\"","THHN-10","Black","Red","Blue","Green",null,"15",15,"0.75\"10","HBL430R9W","HBL430C9W","HBL430B9W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-4"]
["430P7W","430R7W","430C7W","430B7W",10,"Three","480V",30,4,3,3,"0.75\"","1/2\"","THHN-10","Brown","Orange","Yellow","Grey",null,"16",15,"0.75\"10","HBL430R7W","HBL430C7W","HBL430B7W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-4"]
["430P5W","430R5W","430C5W","430B5W",10,"Three","600V",30,4,3,3,"0.75\"","1/2\"","THHN-10","Brown","Orange","Yellow","Green",null,"17",15,"0.75\"10","HBL430R5W","HBL430C5W","HBL430B5W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-4"]
["530P9W","530R9W","530C9W","530B9W",10,"Three","120/208V",30,5,4,3,"0.75\"","0.75\"","THHN-10","Black","Red","Blue","White","Green","18",15,"0.75\"10","HBL530R9W","HBL530C9W","HBL530B9W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-5"]
["530P7W","530R7W","530C7W","530B7W",10,"Three","277/480V",30,5,4,3,"0.75\"","0.75\"","THHN-10","Brown","Orange","Yellow","Gray","Green","19",15,"0.75\"10","HBL530R7W","HBL530C7W","HBL530B7W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-5"]
["530P6W","530R6W","530C6W","530B6W",10,"Three","220/380V-240/415V","30/32A",5,4,3,"0.75\"","0.75\"","THHN-10","Brown","Orange","Yellow","Gray","Green","20",15,"0.75\"10","HBL530R6W","HBL530C6W","HBL530B6W","20230N","1\" NPT","15°","BB301W (Aluminum)",{"$f":"N22&\"-\"&I22","v":"THHN-10-5"}]
["530P5W","530R5W","530C5W","530B5W",10,"Three","347/600V",30,5,4,3,"0.75\"","0.75\"","THHN-10","Brown","Orange","Yellow","Gray","Green","21",15,"0.75\"10","HBL530R5W","HBL530C5W","HBL530B5W","2030N","1\" NPT","15°","BB301W (Aluminum)","THHN-10-5"]
["360P4W","360R4W","360C4W","360B4W",6,"Single","125V",60,3,2,3,"1\"","3/4\"","THHN-6","Black","White","Green",null,null,"22",20,"1\"6","HBL360R4W","HBL360C4W","HBL360B4W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-3"]
["360P6W","360R6W","360C6W","360B6W",6,"Single","250V",60,3,2,3,"1\"","3/4\"","THHN-6","Black","Red","Green",null,null,"23",20,"1\"6","HBL360R6W","HBL360C6W","HBL360B6W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-3"]
["360P7W","360R7W","360C7W","360B7W",6,"Single","480V",60,3,2,3,"1\"","3/4\"","THHN-6","Brown","Orange","Green",null,null,"24",20,"1\"6","HBL360R7W","HBL360C7W","HBL360B7W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-3"]
["460P12W","460R12W","460C12W","460B12W",6,"Single","125/250V",60,4,3,3,"1\"","3/4\"","THHN-6","Black","Red","White","Green",null,"25",20,"1\"6","HBL460R12W","HBL460C12W","HBL460B12W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-4"]
["460P9W","460R9W","460C9W","460B9W",6,"Three","250V",60,4,3,3,"1\"","3/4\"","THHN-6","Black","Red","Blue","Green",null,"26",20,"1\"6","HBL460R9W","HBL460C9W","HBL460B9W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-4"]
["460P7W","460R7W","460C7W","460B7W",6,"Three","480V",60,4,3,3,"1\"","3/4\"","THHN-6","Brown","Orange","Yellow","Green",null,"27",20,"1\"6","HBL460R7W","HBL460C7W","HBL460B7W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-4"]
["460P5W","460R5W","460C5W","460B5W",6,"Three","600V",60,4,3,3,"1\"","3/4\"","THHN-6","Brown","Orange","Yellow","Green",null,"28",20,"1\"6","HBL460R5W","HBL460C5W","HBL460B5W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-4"]
["560P9W","560R9W","560C9W","560B9W",6,"Three","120/208V",60,5,4,3,"1-1/4\"","1\"","THHN-6","Black","Red","Blue","White","Green","29",20,"1-1/4\"6","HBL560R9W","HBL560C9W","HBL560B9W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-5"]
["560P7W","560R7W","560C7W","560B7W",6,"Three","277/480V",60,5,4,3,"1-1/4\"","1\"","THHN-6","Brown","Orange","Yellow","Gray","Green","30",20,"1-1/4\"6","HBL560R7W","HBL560C7W","HBL560B7W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-5"]
["560P6W","560R6W","560C6W","560B6W",6,"Three","200/346V-240/415V","60/63",5,4,3,"1-1/4\"","1\"","THHN-6","Brown","Orange","Yellow","Gray","Green","31",20,"1-1/4\"6","HBL560R6W","HBL560C6W","HBL560B6W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-5"]
["560P5W","560R5W","560C5W","560B5W",6,"Three","347/600V",60,5,4,3,"1-1/4\"","1\"","THHN-6","Brown","Orange","Yellow","Gray","Green","32",20,"1-1/4\"6","HBL560R5W","HBL560C5W","HBL560B5W","60N","1-1/4\" NPT","15°","BB601WSS (Stainless Steel)","THHN-6-5"]
["3100P4W","3100R4W","3100C4W","3100B4W",3,"Single","125V",100,3,2,3,"1\"",null,"THHN-3","Black","White","Green",null,null,"33",25,"1\"3","HBL3100R4W","HBL3100C4W","HBL3100B4W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-3"]
["3100P6W","3100R6W","3100C6W","3100B6W",3,"Single","250V",100,3,2,3,"1\"",null,"THHN-3","Black","Red","Green",null,null,"34",25,"1\"3","HBL3100R6W","HBL3100C6W","HBL3100B6W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-3"]
["3100P7W","3100R7W","3100C7W","3100B7W",3,"Single","480V",100,3,2,3,"1\"",null,"THHN-3","Brown","Orange","Green",null,null,"35",25,"1\"3","HBL3100R7W","HBL3100C7W","HBL3100B7W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-3"]
["4100P12W","4100R12W","4100C12W","4100B12W",3,"Single","125/250V",100,4,3,3,"1-1/4\"",null,"THHN-3","Black","Red","White","Green",null,"36",25,"1-1/4\"3","HBL4100R12W","HBL4100C12W","HBL4100B12W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-4"]
["4100P9W","4100R9W","4100C9W","4100B9W",3,"Three","250V",100,4,3,3,"1-1/4\"",null,"THHN-3","Black","Red","Blue","Green",null,"37",25,"1-1/4\"3","HBL4100R9W","HBL4100C9W","HBL4100B9W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-4"]
["4100P7W","4100R7W","4100C7W","4100B7W",3,"Three","480V",100,4,3,3,"1-1/4\"",null,"THHN-3","Brown","Orange","Yellow","Green",null,"38",25,"1-1/4\"3","HBL4100R7W","HBL4100C7W","HBL4100B7W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-4"]
["4100P5W","4100R5W","4100C5W","4100B5W",3,"Three","600V",100,4,3,3,"1-1/4\"",null,"THHN-3","Brown","Orange","Yellow","Green",null,"39",25,"1-1/4\"3","HBL4100R5W","HBL4100C5W","HBL4100B5W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-4"]
["5100P9W","5100R9W","5100C9W","5100B9W",3,"Three","120/208V",100,5,4,3,"1-1/4\"",null,"THHN-3","Black","Red","Blue","White","Green","40",25,"1-1/4\"3","HBL5100R9W","HBL5100C9W","HBL5100B9W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-5"]
["5100P7W","5100R7W","5100C7W","5100B7W",3,"Three","277/480V",100,5,4,3,"1-1/4\"",null,"THHN-3","Brown","Orange","Yellow","Gray","Green","41",25,"1-1/4\"3","HBL5100R7W","HBL5100C7W","HBL5100B7W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-5"]
["5100P5W","5100R5W","5100C5W","5100B5W",3,"Three","347/600V",100,5,4,3,"1-1/4\"",null,"THHN-3","Brown","Orange","Yellow","Gray","Green","42",25,"1-1/4\"3","HBL5100R5W","HBL5100C5W","HBL5100B5W","100N","1-1/2\" NPT","15°","BB1001W (Aluminum)","THHN-3-5"]

{"sheet":"Master","index":1,"n_rows":8,"n_cols":44,"rows_kept":8,"cut":false,"hidden":true,"merged":[[4,34,4,36],[4,0,4,6],[4,7,4,18],[4,19,4,22],[4,23,4,29],[4,30,4,33]]}
[]
[]
[]
[]
["GENERAL INFORMATION",null,null,null,null,null,null,"CONNECTION DEVICE",null,null,null,null,null,null,null,null,null,null,null,"ELECTRICAL SPECS",null,null,null,"CABLE DETAILS",null,null,null,null,null,null,"CONDUIT DETAILS",null,null,null,"CONNECTOR",null,null,"OTHER"]
["LINE","PROJECT NAME","LOCATION","WHIP QTY","CONFIG","CONFIG ##","CONFIG DESC","GCG PART NBR","PLUG","QTY","SELECT END","GCG PART NBR","RECEPTACLE","QTY","SELECT END","GCG PART NBR","Connector","QTY","SELECT END","VOLTAGE","AMPERAGE","PHASE","POLES","GCG PART NBR","WIRE INSULATION TYPE","LENGTH (FT)","MIN. CONDUCTOR SIZE (AWG) - CONFIRM","# WIRES","GCG PART NBR","# FERRULES","GCG PART NBR","LENGTH (FT)","COLOR","TRADE SIZE - CONFIRM","GCG PART NBR","TYPE","QTY","LABELS","QTY","LABEL INSTRUCTIONS (IF APPLCABLE)","BACK BOX","RECOMMENDED ","QTY","OTHER INSTRUCTIONS"]
["001","XahdKLaNDLKAMD;AMD;LAMD;MD;LMD;LKAJD;LKAJ;D;LMJA;LDM","LSIFHJPKSJF;SAMLF'ASLF,",10,{"$f":"IF(ISERROR(RIGHT(IF(H7<>\"none\",H7,IF(L7<>\"none\",L7,IF(P7<>\"none\",P7,\"none\"))),2)),\"\",(RIGHT(IF(H7<>\"none\",H7,IF(L7<>\"none\",L7,IF(P7<>\"none\",P7,\"none\"))),2)))","v":"01"},{"$f":"IF(AND(I7=\"None\",M7=\"None\",Q7=\"None\"),\"\",_xlfn.CONCAT(IF(I7<>\"None\",\"P\",\"\"),IF(M7<>\"None\",\"R\",\"\"),IF(Q7<>\"None\",\"C\",\"\"),SUBSTITUTE(SUBSTITUTE(T7,\"/\",\"\"),\"V\",\"\"),IF(U7<>\"\",U7,\"\"),IF(V7<>\"\",IF(V7=\"Three\",\"3\",\"S\"),\"\"),IF(W7<>\"\",W7&\"_\",\"_\"),IF(Z7<>\"\",Z7,\"\"),IF(AA7<>\"\",AA7,\"\"),IF(AB7<>\"\",AB7&\"_\",\"_\"),IF(AF7<>\"\",AF7,\"\"),IF(AG7<>\"\",LEFT(AG7,1)&\"_\",\"_\"),IF(AK7<>\"\",\"LT\",\"\"),IF(AK7<>\"\",UPPER(LEFT(AJ7,2)),\"\"),\"\"))","v":"P12520S2_50123_50B_LTAN"},{"$f":"IF(F7=\"\",\"\",IF(E7 = \"\",\"\",Z7&\"ft, \"&T7&\", \"&U7&\"A\"&\",\"&V7&\" Phase \"&W7&\"P, \"&AF7&\"ft \"&\"Conduit,\"&AG7&\" \"&AH7))","v":"50ft, 125V, 20A,Single Phase 2P, 50ft Conduit,Blue 1/2\""},{"$f":"I7&\"-\"&VLOOKUP(Master!I7,'Part Matrix'!$A:$T,20,0)","v":"320P4W-01"},"320P4W",1,"Near End",{"$f":"M7&\"-\"&VLOOKUP(Master!M7,'Part Matrix'!$B:$T,19,0)","v":"None-00"},"None",0,"Select End",{"$f":"Q7&\"-\"&VLOOKUP(Master!Q7,'Part Matrix'!$C:$T,18,0)","v":"None-00"},"None",0,"Select End",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$7, 'Part Matrix'!$T:$T, 0))))","v":"125V"},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$7, 'Part Matrix'!$T:$T, 0))))","v":20},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$7, 'Part Matrix'!$T:$T, 0))))","v":"Single"},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$7, 'Part Matrix'!$T:$T, 0))))","v":2},{"$f":"LEFT(Y7,4)&\"-\"&AA7&\"-\"&AB7","v":"THHN-12-3"},"THHN / THWN / THWN-2",50,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$7, 'Part Matrix'!$T:$T, 0)))","v":12},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$7, 'Part Matrix'!$T:$T, 0))))","v":3},{"$f":"\"FER-\"&AA7","v":"FER-12"},3,{"$f":"\"CON-\"&AG7&\"-\"&AH7","v":"CON-Blue-1/2\""},50,"Blue",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$L:$L, MATCH(E$7, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$L:$L, MATCH(E$7, 'Part Matrix'!$T:$T, 0))))","v":"1/2\""},{"$f":"\"CON-\"&LEFT(AJ7,3)&\"-\"&AH7","v":"CON-Ang-1/2\""},"Angled",1,{"$f":"\"LABEL-\"&AH7","v":"LABEL-1/2\""},2,"A;FA;FMA;FM;AFM'A;FA;FLM","BB2030N",{"$f":"INDEX('Part Matrix'!$Z:$Z,MATCH(Master!E7,'Part Matrix'!$T:$T))","v":"2030N"},1,"f.smf;lsm;lfms;gm;slgf"]
["002","XahdKLaNDLKAMD;AMD;LAMD;MD;LMD;LKAJD;LKAJ;D;LMJA;LDM","LSIFHJPKSJF;SAMLF'ASLF,",1,{"$f":"IF(ISERROR(RIGHT(IF(H8<>\"none\",H8,IF(L8<>\"none\",L8,IF(P8<>\"none\",P8,\"none\"))),2)),\"\",(RIGHT(IF(H8<>\"none\",H8,IF(L8<>\"none\",L8,IF(P8<>\"none\",P8,\"none\"))),2)))","v":"21"},{"$f":"IF(AND(I8=\"None\",M8=\"None\",Q8=\"None\"),\"\",_xlfn.CONCAT(IF(I8<>\"None\",\"P\",\"\"),IF(M8<>\"None\",\"R\",\"\"),IF(Q8<>\"None\",\"C\",\"\"),SUBSTITUTE(SUBSTITUTE(T8,\"/\",\"\"),\"V\",\"\"),IF(U8<>\"\",U8,\"\"),IF(V8<>\"\",IF(V8=\"Three\",\"3\",\"S\"),\"\"),IF(W8<>\"\",W8&\"_\",\"_\"),IF(Z8<>\"\",Z8,\"\"),IF(AA8<>\"\",AA8,\"\"),IF(AB8<>\"\",AB8&\"_\",\"_\"),IF(AF8<>\"\",AF8,\"\"),IF(AG8<>\"\",LEFT(AG8,1)&\"_\",\"_\"),IF(AK8<>\"\",\"LT\",\"\"),IF(AK8<>\"\",UPPER(LEFT(AJ8,2)),\"\"),\"\"))","v":"PR3476003034_50105_50B_LTST"},{"$f":"IF(F8=\"\",\"\",IF(E8 = \"\",\"\",Z8&\"ft, \"&T8&\", \"&U8&\"A\"&\",\"&V8&\" Phase \"&W8&\"P, \"&AF8&\"ft \"&\"Conduit,\"&AG8&\" \"&AH8))","v":"50ft, 347/600V, 30A,Three Phase 4P, 50ft Conduit,Blue 0.75\""},{"$f":"I8&\"-\"&VLOOKUP(Master!I8,'Part Matrix'!$A:$T,20,0)","v":"530P5W-21"},"530P5W",1,"Near End",{"$f":"M8&\"-\"&VLOOKUP(Master!M8,'Part Matrix'!$B:$T,19,0)","v":"520R9W-08"},"520R9W",1,"Select End",{"$f":"Q8&\"-\"&VLOOKUP(Master!Q8,'Part Matrix'!$C:$T,18,0)","v":"None-00"},"None",0,"Select End",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":"347/600V"},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":30},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":"Three"},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":4},{"$f":"LEFT(Y8,4)&\"-\"&AA8&\"-\"&AB8","v":"THHN-10-5"},"THHN / THWN / THWN-2",50,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$8, 'Part Matrix'!$T:$T, 0)))","v":10},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":5},{"$f":"\"FER-\"&AA8","v":"FER-10"},3,{"$f":"\"CON-\"&AG8&\"-\"&AH8","v":"CON-Blue-0.75\""},50,"Blue",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$L:$L, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$L:$L, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":"0.75\""},{"$f":"\"CON-\"&LEFT(AJ8,3)&\"-\"&AH8","v":"CON-Str-0.75\""},"Straight",1,{"$f":"\"LABEL-\"&AH8","v":"LABEL-0.75\""},2,"A;FA;FMA;FM;AFM'A;FA;FLM","BB2030N",{"$f":"INDEX('Part Matrix'!$Z:$Z,MATCH(Master!E8,'Part Matrix'!$T:$T))","v":"2030N"},1,"f.smf;lsm;lfms;gm;slgf"]

{"sheet":"Configurator","index":2,"n_rows":32,"n_cols":54,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,0,4,6],[4,7,4,22],[4,23,4,26],[4,27,4,31],[4,32,4,37],[5,8,5,10],[5,12,5,14],[5,16,5,18],[5,20,5,22],[4,41,4,47],[4,38,4,40],[5,44,5,46]]}
[]
[null,null,null,null,null,"Click Icon to Submit Request via Email"]
[null,null,null,null,null,{"$f":"IF(AD8>150,\"Please confirm the conductor size in column AE\",\"\")","v":""}]
[]
["GENERAL INFORMATION",null,null,null,null,null,null,"CONNECTION DEVICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELECTRICAL SPECS",null,null,null,"CABLE DETAILS",null,null,null,null,"CONDUIT DETAILS",null,null,null,null,null,"ADAPTERS",null,null,"OTHER"]
[null,null,null,null,null,null,null,null,"PLUG (Male)",null,null,null,"CONNECTOR (Female)",null,null,null,"RECEPTACLE (Female)",null,null,null,"INLET (Male)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back Box"]
["Line","Project Name","Location","Whip Qty","CONFIG","Whip Part Number","Whip Description","GCG PART NBR","Part","Qty","Select End","GCG PART NBR","Part","Qty","Select End","GCG PART NBR","Part","Qty","Select End","GCG PART NBR","Part","Qty","Select End","Voltage","Amperage","Phase","Poles","GCG PART NBR","Wire Insulation Type","Qty (FT)","Min. Conductor Size (AWG)","# Wires","GCG PART NBR","Type","Qty (FT)","Color","Custom Color Comments","Trade Size","GCG PART NBR","Type","Qty","LABELS","QTY","Label Instructions","Recommended Back Box","Part","Qty","Additional Needs i.e. Mounting Hardware, Circuit Breakers.  Please specify."]
["001","Example","Test",1,{"$f":"RIGHT(IF(I8<>\"none\",H8,IF(Q8<>\"none\",P8,IF(M8<>\"none\",L8,IF(U8<>\"none\",T8,IF(H8<>\"\",H8,IF(P8<>\"\",P8,IF(L8<>\"\",T8,IF(T8<>\"\",T8,)))))))),2)","v":"02"},{"$f":"IF(E8=\"\",\"\",IF(AND(I8=\"None\",M8=\"None\",Q8=\"None\",U8=\"None\"),\"\",_xlfn.CONCAT(IF(I8<>\"None\",\"P\",\"\"),IF(Q8<>\"None\",\"R\",\"\"),IF(U8<>\"None\",\"I\",\"\"),IF(M8<>\"None\",\"C\",\"\"),SUBSTITUTE(SUBSTITUTE(X8,\"/\",\"\"),\"V\",\"\"),IF(Y8<>\"\",Y8,\"\"),IF(Z8<>\"\",IF(Z8=\"Three\",\"3\",\"S\"),\"\"),IF(AA8<>\"\",AA8&\"-\",\"-\"),IF(AD8<>\"\",AD8,\"\"),IF(AE8<>\"\",AE8,\"\"),IF(AF8<>\"\",AF8&\"-\",\"-\"),IF(AI8<>\"\",AI8,\"\"),IF(AJ8<>\"\",LEFT(AJ8,1)&\"-\",\"-\"),IF(AO8<>\"\",\"LT\",\"\"),IF(AO8<>\"\",UPPER(LEFT(AN8,2)),\"\"),\"\")))","v":"PC25020S2-20123-20G-LTST"},{"$f":"IF(F8=\"\",\"\",IF(E8 = \"\",\"\",AD8&\"ft, \"&X8&\", \"&Y8&\"A\"&\",\"&Z8&\" Phase \"&AA8&\"P, \"&AI8&\"ft \"&\"Conduit,\"&AJ8&\" \"&AL8))","v":"20ft, 250V, 20A,Single Phase 2P, 20ft Conduit,Gray 1/2\""},{"$f":"IF(I8=\"\",\"\",I8&\"-\"&VLOOKUP(Configurator!I8,'Part Matrix'!$A:$T,20,0))","v":"320P6W-02"},"320P6W",1,"Near End",{"$f":"IF(M8=\"\",\"\",M8&\"-\"&VLOOKUP(Configurator!M8,'Part Matrix'!$C:$T,18,0))","v":"320C6W-02"},"320C6W",1,"Far End",{"$f":"IF(Q8=\"\",\"\",Q8&\"-\"&VLOOKUP(Configurator!Q8,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U8=\"\",\"\",U8&\"-\"&VLOOKUP(Configurator!U8,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":"250V"},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":20},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":"Single"},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":2},{"$f":"IF(AC8=\"\",\"\",LEFT(AC8,4)&\"-\"&AE8&\"-\"&AF8)","v":"Sele-12-3"},"Select Insulation Type",20,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$8, 'Part Matrix'!$T:$T, 0)))","v":12},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$8, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$8, 'Part Matrix'!$T:$T, 0))))","v":3},{"$f":"IF(AH8=\"Select Conduit Type\",\"\",AH8&\"-\"&AL8&\"-\"&IF(AJ8=\"Blue\",\"BLU\",IF(AJ8=\"Red\",\"RED\",IF(AJ8=\"GRAY\",\"GRY\",IF(AJ8=\"BLACK\",\"BLK\",\"CUSTOM\")))))","v":""},"Select Conduit Type",20,"Gray",null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE8:AF8),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE8:AF8),'Part Matrix'!$AP:$AS,4,0)))","v":"1/2\""},{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AF8:AG8),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AF8:AG8),'Part Matrix'!$AP:$AS,4,0)))","v":0},"Straight",1,{"$f":"IF(D8=\"\",\"\",IF(AQ8=\"\",\"\",\"LBL-\"&AL8))","v":"LBL-1/2\""},{"$f":"IF(D8=\"\",\"\",2)","v":2},null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E8,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E8,'Part Matrix'!$T:$T))))","v":"2030N"},null,null,null,{"$f":"RIGHT(H8,2)","v":"02"},{"$f":"RIGHT(L8,2)","v":"02"},{"$f":"RIGHT(P8,2)","v":"00"},{"$f":"RIGHT(T8,2)","v":"00"},{"$f":"IF(COUNTIF(AW8:AZ8,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW8:AZ8,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW8:AZ8<>\"00\")*(AW8:AZ8<>INDEX(AW8:AZ8,MATCH(TRUE,AW8:AZ8<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":"Equal"},{"$f":"COUNTIF(I8, \"<>None\") + COUNTIF(M8, \"<>None\") + COUNTIF(Q8, \"<>None\") + COUNTIF(U8, \"<>None\")","v":2}]
["002",null,null,null,{"$f":"RIGHT(IF(I9<>\"none\",H9,IF(Q9<>\"none\",P9,IF(M9<>\"none\",L9,IF(U9<>\"none\",T9,IF(H9<>\"\",H9,IF(P9<>\"\",P9,IF(L9<>\"\",T9,IF(T9<>\"\",T9,)))))))),2)","v":"00"},{"$f":"IF(E9=\"\",\"\",IF(AND(I9=\"None\",M9=\"None\",Q9=\"None\",U9=\"None\"),\"\",_xlfn.CONCAT(IF(I9<>\"None\",\"P\",\"\"),IF(Q9<>\"None\",\"R\",\"\"),IF(U9<>\"None\",\"I\",\"\"),IF(M9<>\"None\",\"C\",\"\"),SUBSTITUTE(SUBSTITUTE(X9,\"/\",\"\"),\"V\",\"\"),IF(Y9<>\"\",Y9,\"\"),IF(Z9<>\"\",IF(Z9=\"Three\",\"3\",\"S\"),\"\"),IF(AA9<>\"\",AA9&\"-\",\"-\"),IF(AD9<>\"\",AD9,\"\"),IF(AE9<>\"\",AE9,\"\"),IF(AF9<>\"\",AF9&\"-\",\"-\"),IF(AI9<>\"\",AI9,\"\"),IF(AJ9<>\"\",LEFT(AJ9,1)&\"-\",\"-\"),IF(AO9<>\"\",\"LT\",\"\"),IF(AO9<>\"\",UPPER(LEFT(AN9,2)),\"\"),\"\")))","v":""},"",{"$f":"IF(I9=\"\",\"\",I9&\"-\"&VLOOKUP(Configurator!I9,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M9=\"\",\"\",M9&\"-\"&VLOOKUP(Configurator!M9,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q9=\"\",\"\",Q9&\"-\"&VLOOKUP(Configurator!Q9,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U9=\"\",\"\",U9&\"-\"&VLOOKUP(Configurator!U9,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$9, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$9, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$9, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$9, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$9, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$9, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$9, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$9, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(AC9=\"\",\"\",LEFT(AC9,4)&\"-\"&AE9&\"-\"&AF9)","v":"Sele-0-0"},"Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$9, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$9, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$9, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$9, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(AH9=\"Select Conduit Type\",\"\",AH9&\"-\"&AL9&\"-\"&IF(AJ9=\"Blue\",\"BLU\",IF(AJ9=\"Red\",\"RED\",IF(AJ9=\"GRAY\",\"GRY\",IF(AJ9=\"BLACK\",\"BLK\",\"CUSTOM\")))))","v":""},"Select Conduit Type",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE9:AF9),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE9:AF9),'Part Matrix'!$AP:$AS,4,0)))","v":0},{"$f":"IF(AN9=\"None\",\"\",IF(AN9=\"\",\"\",AH9&\"-\"&\"FITTING-\"&TRIM(LEFT(AN9,3))&\"-\"&AL9))","v":""},null,null,{"$f":"IF(D9=\"\",\"\",IF(AQ9=\"\",\"\",\"LBL-\"&AL9))","v":""},{"$f":"IF(D9=\"\",\"\",2)","v":""},null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E9,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E9,'Part Matrix'!$T:$T))))","v":0},null,null,null,{"$f":"RIGHT(H9,2)","v":"00"},{"$f":"RIGHT(L9,2)","v":"00"},{"$f":"RIGHT(P9,2)","v":"00"},{"$f":"RIGHT(T9,2)","v":"00"},{"$f":"IF(COUNTIF(AW9:AZ9,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW9:AZ9,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW9:AZ9<>\"00\")*(AW9:AZ9<>INDEX(AW9:AZ9,MATCH(TRUE,AW9:AZ9<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(I9, \"<>None\") + COUNTIF(M9, \"<>None\") + COUNTIF(Q9, \"<>None\") + COUNTIF(U9, \"<>None\")","v":0}]
["003",null,null,null,"00",{"$f":"IF(E10=\"\",\"\",IF(AND(I10=\"None\",M10=\"None\",Q10=\"None\",U10=\"None\"),\"\",_xlfn.CONCAT(IF(I10<>\"None\",\"P\",\"\"),IF(Q10<>\"None\",\"R\",\"\"),IF(U10<>\"None\",\"I\",\"\"),IF(M10<>\"None\",\"C\",\"\"),SUBSTITUTE(SUBSTITUTE(X10,\"/\",\"\"),\"V\",\"\"),IF(Y10<>\"\",Y10,\"\"),IF(Z10<>\"\",IF(Z10=\"Three\",\"3\",\"S\"),\"\"),IF(AA10<>\"\",AA10&\"-\",\"-\"),IF(AD10<>\"\",AD10,\"\"),IF(AE10<>\"\",AE10,\"\"),IF(AF10<>\"\",AF10&\"-\",\"-\"),IF(AI10<>\"\",AI10,\"\"),IF(AJ10<>\"\",LEFT(AJ10,1)&\"-\",\"-\"),IF(AO10<>\"\",\"LT\",\"\"),IF(AO10<>\"\",UPPER(LEFT(AN10,2)),\"\"),\"\")))","v":""},"",{"$f":"IF(I10=\"\",\"\",I10&\"-\"&VLOOKUP(Configurator!I10,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M10=\"\",\"\",M10&\"-\"&VLOOKUP(Configurator!M10,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q10=\"\",\"\",Q10&\"-\"&VLOOKUP(Configurator!Q10,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U10=\"\",\"\",U10&\"-\"&VLOOKUP(Configurator!U10,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$10, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$10, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$10, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$10, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$10, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$10, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$10, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$10, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$10, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$10, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$10, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$10, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE10:AF10),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE10:AF10),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,{"$f":"IF(D10=\"\",\"\",IF(AQ10=\"\",\"\",\"LBL-\"&AL10))","v":""},"",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E10,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E10,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW10:AZ10,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW10:AZ10,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW10:AZ10<>\"00\")*(AW10:AZ10<>INDEX(AW10:AZ10,MATCH(TRUE,AW10:AZ10<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["004",null,null,null,"00","","",{"$f":"IF(I11=\"\",\"\",I11&\"-\"&VLOOKUP(Configurator!I11,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M11=\"\",\"\",M11&\"-\"&VLOOKUP(Configurator!M11,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q11=\"\",\"\",Q11&\"-\"&VLOOKUP(Configurator!Q11,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U11=\"\",\"\",U11&\"-\"&VLOOKUP(Configurator!U11,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$11, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$11, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$11, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$11, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$11, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$11, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$11, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$11, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$11, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$11, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$11, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$11, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE11:AF11),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE11:AF11),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E11,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E11,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW11:AZ11,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW11:AZ11,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW11:AZ11<>\"00\")*(AW11:AZ11<>INDEX(AW11:AZ11,MATCH(TRUE,AW11:AZ11<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["005",null,null,null,"00","","",{"$f":"IF(I12=\"\",\"\",I12&\"-\"&VLOOKUP(Configurator!I12,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M12=\"\",\"\",M12&\"-\"&VLOOKUP(Configurator!M12,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,null,{"$f":"IF(Q12=\"\",\"\",Q12&\"-\"&VLOOKUP(Configurator!Q12,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U12=\"\",\"\",U12&\"-\"&VLOOKUP(Configurator!U12,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$12, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$12, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$12, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$12, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$12, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$12, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$12, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$12, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$12, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$12, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$12, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$12, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE12:AF12),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE12:AF12),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E12,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E12,'Part Matrix'!$T:$T))))","v":0},null,null,null,{"$f":"RIGHT(H12,2)","v":"00"},{"$f":"RIGHT(L12,2)","v":"00"},{"$f":"RIGHT(P12,2)","v":"00"},{"$f":"RIGHT(T12,2)","v":"00"},{"$f":"IF(COUNTIF(AW12:AZ12,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW12:AZ12,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW12:AZ12<>\"00\")*(AW12:AZ12<>INDEX(AW12:AZ12,MATCH(TRUE,AW12:AZ12<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["006",null,null,null,"00","","",{"$f":"IF(I13=\"\",\"\",I13&\"-\"&VLOOKUP(Configurator!I13,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M13=\"\",\"\",M13&\"-\"&VLOOKUP(Configurator!M13,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q13=\"\",\"\",Q13&\"-\"&VLOOKUP(Configurator!Q13,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U13=\"\",\"\",U13&\"-\"&VLOOKUP(Configurator!U13,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$13, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$13, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$13, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$13, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$13, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$13, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$13, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$13, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$13, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$13, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$13, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$13, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE13:AF13),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE13:AF13),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E13,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E13,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW13:AZ13,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW13:AZ13,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW13:AZ13<>\"00\")*(AW13:AZ13<>INDEX(AW13:AZ13,MATCH(TRUE,AW13:AZ13<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["007",null,null,null,"00","","",{"$f":"IF(I14=\"\",\"\",I14&\"-\"&VLOOKUP(Configurator!I14,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M14=\"\",\"\",M14&\"-\"&VLOOKUP(Configurator!M14,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q14=\"\",\"\",Q14&\"-\"&VLOOKUP(Configurator!Q14,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U14=\"\",\"\",U14&\"-\"&VLOOKUP(Configurator!U14,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$14, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$14, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$14, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$14, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$14, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$14, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$14, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$14, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$14, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$14, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$14, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$14, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE14:AF14),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE14:AF14),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E14,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E14,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW14:AZ14,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW14:AZ14,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW14:AZ14<>\"00\")*(AW14:AZ14<>INDEX(AW14:AZ14,MATCH(TRUE,AW14:AZ14<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["008",null,null,null,"00","","",{"$f":"IF(I15=\"\",\"\",I15&\"-\"&VLOOKUP(Configurator!I15,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M15=\"\",\"\",M15&\"-\"&VLOOKUP(Configurator!M15,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q15=\"\",\"\",Q15&\"-\"&VLOOKUP(Configurator!Q15,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U15=\"\",\"\",U15&\"-\"&VLOOKUP(Configurator!U15,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$15, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$15, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$15, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$15, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$15, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$15, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$15, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$15, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$15, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$15, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$15, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$15, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,{"$f":"IF(AJ15=\"Custom\",\"Specify Color\",\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE15:AF15),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE15:AF15),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E15,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E15,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW15:AZ15,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW15:AZ15,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW15:AZ15<>\"00\")*(AW15:AZ15<>INDEX(AW15:AZ15,MATCH(TRUE,AW15:AZ15<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["009",null,null,null,"00","","",{"$f":"IF(I16=\"\",\"\",I16&\"-\"&VLOOKUP(Configurator!I16,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M16=\"\",\"\",M16&\"-\"&VLOOKUP(Configurator!M16,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q16=\"\",\"\",Q16&\"-\"&VLOOKUP(Configurator!Q16,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U16=\"\",\"\",U16&\"-\"&VLOOKUP(Configurator!U16,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$16, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$16, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$16, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$16, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$16, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$16, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$16, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$16, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$16, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$16, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$16, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$16, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE16:AF16),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE16:AF16),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E16,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E16,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW16:AZ16,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW16:AZ16,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW16:AZ16<>\"00\")*(AW16:AZ16<>INDEX(AW16:AZ16,MATCH(TRUE,AW16:AZ16<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["010",null,null,null,"00","","",{"$f":"IF(I17=\"\",\"\",I17&\"-\"&VLOOKUP(Configurator!I17,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M17=\"\",\"\",M17&\"-\"&VLOOKUP(Configurator!M17,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q17=\"\",\"\",Q17&\"-\"&VLOOKUP(Configurator!Q17,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U17=\"\",\"\",U17&\"-\"&VLOOKUP(Configurator!U17,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$17, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$17, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$17, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$17, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$17, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$17, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$17, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$17, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$17, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$17, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$17, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$17, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE17:AF17),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE17:AF17),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E17,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E17,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW17:AZ17,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW17:AZ17,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW17:AZ17<>\"00\")*(AW17:AZ17<>INDEX(AW17:AZ17,MATCH(TRUE,AW17:AZ17<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["011",null,null,null,"00","","",{"$f":"IF(I18=\"\",\"\",I18&\"-\"&VLOOKUP(Configurator!I18,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M18=\"\",\"\",M18&\"-\"&VLOOKUP(Configurator!M18,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q18=\"\",\"\",Q18&\"-\"&VLOOKUP(Configurator!Q18,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U18=\"\",\"\",U18&\"-\"&VLOOKUP(Configurator!U18,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$18, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$18, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$18, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$18, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$18, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$18, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$18, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$18, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$18, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$18, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$18, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$18, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE18:AF18),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE18:AF18),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E18,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E18,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW18:AZ18,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW18:AZ18,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW18:AZ18<>\"00\")*(AW18:AZ18<>INDEX(AW18:AZ18,MATCH(TRUE,AW18:AZ18<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["012",null,null,null,"00","","",{"$f":"IF(I19=\"\",\"\",I19&\"-\"&VLOOKUP(Configurator!I19,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M19=\"\",\"\",M19&\"-\"&VLOOKUP(Configurator!M19,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q19=\"\",\"\",Q19&\"-\"&VLOOKUP(Configurator!Q19,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U19=\"\",\"\",U19&\"-\"&VLOOKUP(Configurator!U19,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$19, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$19, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$19, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$19, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$19, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$19, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$19, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$19, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$19, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$19, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$19, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$19, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE19:AF19),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE19:AF19),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E19,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E19,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW19:AZ19,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW19:AZ19,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW19:AZ19<>\"00\")*(AW19:AZ19<>INDEX(AW19:AZ19,MATCH(TRUE,AW19:AZ19<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["013",null,null,null,"00","","",{"$f":"IF(I20=\"\",\"\",I20&\"-\"&VLOOKUP(Configurator!I20,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M20=\"\",\"\",M20&\"-\"&VLOOKUP(Configurator!M20,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q20=\"\",\"\",Q20&\"-\"&VLOOKUP(Configurator!Q20,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U20=\"\",\"\",U20&\"-\"&VLOOKUP(Configurator!U20,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$20, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$20, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$20, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$20, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$20, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$20, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$20, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$20, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$20, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$20, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$20, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$20, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE20:AF20),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE20:AF20),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E20,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E20,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW20:AZ20,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW20:AZ20,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW20:AZ20<>\"00\")*(AW20:AZ20<>INDEX(AW20:AZ20,MATCH(TRUE,AW20:AZ20<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["014",null,null,null,"00","","",{"$f":"IF(I21=\"\",\"\",I21&\"-\"&VLOOKUP(Configurator!I21,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M21=\"\",\"\",M21&\"-\"&VLOOKUP(Configurator!M21,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q21=\"\",\"\",Q21&\"-\"&VLOOKUP(Configurator!Q21,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U21=\"\",\"\",U21&\"-\"&VLOOKUP(Configurator!U21,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$21, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$21, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$21, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$21, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$21, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$21, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$21, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$21, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$21, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$21, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$21, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$21, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE21:AF21),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE21:AF21),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E21,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E21,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW21:AZ21,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW21:AZ21,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW21:AZ21<>\"00\")*(AW21:AZ21<>INDEX(AW21:AZ21,MATCH(TRUE,AW21:AZ21<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["015",null,null,null,"00","","",{"$f":"IF(I22=\"\",\"\",I22&\"-\"&VLOOKUP(Configurator!I22,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M22=\"\",\"\",M22&\"-\"&VLOOKUP(Configurator!M22,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q22=\"\",\"\",Q22&\"-\"&VLOOKUP(Configurator!Q22,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U22=\"\",\"\",U22&\"-\"&VLOOKUP(Configurator!U22,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$22, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$22, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$22, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$22, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$22, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$22, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$22, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$22, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$22, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$22, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$22, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$22, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE22:AF22),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE22:AF22),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E22,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E22,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW22:AZ22,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW22:AZ22,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW22:AZ22<>\"00\")*(AW22:AZ22<>INDEX(AW22:AZ22,MATCH(TRUE,AW22:AZ22<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["016",null,null,null,"00","","",{"$f":"IF(I23=\"\",\"\",I23&\"-\"&VLOOKUP(Configurator!I23,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M23=\"\",\"\",M23&\"-\"&VLOOKUP(Configurator!M23,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q23=\"\",\"\",Q23&\"-\"&VLOOKUP(Configurator!Q23,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U23=\"\",\"\",U23&\"-\"&VLOOKUP(Configurator!U23,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$23, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$23, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$23, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$23, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$23, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$23, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$23, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$23, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$23, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$23, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$23, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$23, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE23:AF23),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE23:AF23),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E23,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E23,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW23:AZ23,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW23:AZ23,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW23:AZ23<>\"00\")*(AW23:AZ23<>INDEX(AW23:AZ23,MATCH(TRUE,AW23:AZ23<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["017",null,null,null,"00","","",{"$f":"IF(I24=\"\",\"\",I24&\"-\"&VLOOKUP(Configurator!I24,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M24=\"\",\"\",M24&\"-\"&VLOOKUP(Configurator!M24,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q24=\"\",\"\",Q24&\"-\"&VLOOKUP(Configurator!Q24,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U24=\"\",\"\",U24&\"-\"&VLOOKUP(Configurator!U24,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$24, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$24, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$24, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$24, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$24, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$24, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$24, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$24, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$24, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$24, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$24, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$24, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE24:AF24),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE24:AF24),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E24,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E24,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW24:AZ24,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW24:AZ24,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW24:AZ24<>\"00\")*(AW24:AZ24<>INDEX(AW24:AZ24,MATCH(TRUE,AW24:AZ24<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["018",null,null,null,"00","","",{"$f":"IF(I25=\"\",\"\",I25&\"-\"&VLOOKUP(Configurator!I25,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M25=\"\",\"\",M25&\"-\"&VLOOKUP(Configurator!M25,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q25=\"\",\"\",Q25&\"-\"&VLOOKUP(Configurator!Q25,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U25=\"\",\"\",U25&\"-\"&VLOOKUP(Configurator!U25,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$25, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$25, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$25, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$25, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$25, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$25, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$25, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$25, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$25, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$25, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$25, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$25, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE25:AF25),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE25:AF25),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E25,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E25,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW25:AZ25,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW25:AZ25,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW25:AZ25<>\"00\")*(AW25:AZ25<>INDEX(AW25:AZ25,MATCH(TRUE,AW25:AZ25<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["019",null,null,null,"00","","",{"$f":"IF(I26=\"\",\"\",I26&\"-\"&VLOOKUP(Configurator!I26,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M26=\"\",\"\",M26&\"-\"&VLOOKUP(Configurator!M26,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q26=\"\",\"\",Q26&\"-\"&VLOOKUP(Configurator!Q26,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U26=\"\",\"\",U26&\"-\"&VLOOKUP(Configurator!U26,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$26, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$26, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$26, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$26, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$26, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$26, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$26, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$26, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$26, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$26, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$26, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$26, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE26:AF26),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE26:AF26),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E26,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E26,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW26:AZ26,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW26:AZ26,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW26:AZ26<>\"00\")*(AW26:AZ26<>INDEX(AW26:AZ26,MATCH(TRUE,AW26:AZ26<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["020",null,null,null,"00","","",{"$f":"IF(I27=\"\",\"\",I27&\"-\"&VLOOKUP(Configurator!I27,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M27=\"\",\"\",M27&\"-\"&VLOOKUP(Configurator!M27,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q27=\"\",\"\",Q27&\"-\"&VLOOKUP(Configurator!Q27,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U27=\"\",\"\",U27&\"-\"&VLOOKUP(Configurator!U27,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$27, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$27, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$27, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$27, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$27, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$27, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$27, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$27, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$27, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$27, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$27, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$27, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE27:AF27),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE27:AF27),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E27,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E27,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW27:AZ27,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW27:AZ27,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW27:AZ27<>\"00\")*(AW27:AZ27<>INDEX(AW27:AZ27,MATCH(TRUE,AW27:AZ27<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["021",null,null,null,"00","","",{"$f":"IF(I28=\"\",\"\",I28&\"-\"&VLOOKUP(Configurator!I28,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M28=\"\",\"\",M28&\"-\"&VLOOKUP(Configurator!M28,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q28=\"\",\"\",Q28&\"-\"&VLOOKUP(Configurator!Q28,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U28=\"\",\"\",U28&\"-\"&VLOOKUP(Configurator!U28,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$28, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$28, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$28, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$28, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$28, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$28, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$28, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$28, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$28, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$28, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$28, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$28, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE28:AF28),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE28:AF28),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E28,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E28,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW28:AZ28,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW28:AZ28,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW28:AZ28<>\"00\")*(AW28:AZ28<>INDEX(AW28:AZ28,MATCH(TRUE,AW28:AZ28<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["022",null,null,null,"00","","",{"$f":"IF(I29=\"\",\"\",I29&\"-\"&VLOOKUP(Configurator!I29,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M29=\"\",\"\",M29&\"-\"&VLOOKUP(Configurator!M29,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q29=\"\",\"\",Q29&\"-\"&VLOOKUP(Configurator!Q29,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U29=\"\",\"\",U29&\"-\"&VLOOKUP(Configurator!U29,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$29, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$29, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$29, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$29, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$29, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$29, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$29, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$29, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$29, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$29, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$29, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$29, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE29:AF29),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE29:AF29),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E29,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E29,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW29:AZ29,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW29:AZ29,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW29:AZ29<>\"00\")*(AW29:AZ29<>INDEX(AW29:AZ29,MATCH(TRUE,AW29:AZ29<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["023",null,null,null,"00","","",{"$f":"IF(I30=\"\",\"\",I30&\"-\"&VLOOKUP(Configurator!I30,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M30=\"\",\"\",M30&\"-\"&VLOOKUP(Configurator!M30,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q30=\"\",\"\",Q30&\"-\"&VLOOKUP(Configurator!Q30,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U30=\"\",\"\",U30&\"-\"&VLOOKUP(Configurator!U30,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$30, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$30, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$30, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$30, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$30, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$30, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$30, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$30, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$30, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$30, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$30, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$30, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE30:AF30),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE30:AF30),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E30,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E30,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW30:AZ30,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW30:AZ30,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW30:AZ30<>\"00\")*(AW30:AZ30<>INDEX(AW30:AZ30,MATCH(TRUE,AW30:AZ30<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["024",null,null,null,"00","","",{"$f":"IF(I31=\"\",\"\",I31&\"-\"&VLOOKUP(Configurator!I31,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M31=\"\",\"\",M31&\"-\"&VLOOKUP(Configurator!M31,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q31=\"\",\"\",Q31&\"-\"&VLOOKUP(Configurator!Q31,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U31=\"\",\"\",U31&\"-\"&VLOOKUP(Configurator!U31,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$31, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$31, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$31, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$31, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$31, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$31, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$31, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$31, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$31, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$31, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$31, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$31, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE31:AF31),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE31:AF31),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E31,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E31,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW31:AZ31,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW31:AZ31,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW31:AZ31<>\"00\")*(AW31:AZ31<>INDEX(AW31:AZ31,MATCH(TRUE,AW31:AZ31<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]
["025",null,null,null,"00","","",{"$f":"IF(I32=\"\",\"\",I32&\"-\"&VLOOKUP(Configurator!I32,'Part Matrix'!$A:$T,20,0))","v":"None-00"},"None",null,"None",{"$f":"IF(M32=\"\",\"\",M32&\"-\"&VLOOKUP(Configurator!M32,'Part Matrix'!$C:$T,18,0))","v":"None-00"},"None",null,"None",{"$f":"IF(Q32=\"\",\"\",Q32&\"-\"&VLOOKUP(Configurator!Q32,'Part Matrix'!$B:$T,19,0))","v":"None-00"},"None",null,"None",{"$f":"IF(U32=\"\",\"\",U32&\"-\"&VLOOKUP(Configurator!U32,'Part Matrix'!$D:$T,17,0))","v":"None-00"},"None",null,"None",{"$f":"IF(ISERROR(INDEX('Part Matrix'!$G:$G, MATCH(E$32, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$G:$G, MATCH(E$32, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$H:$H, MATCH(E$32, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$H:$H, MATCH(E$32, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$F:$F, MATCH(E$32, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$F:$F, MATCH(E$32, 'Part Matrix'!$T:$T, 0))))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$J:$J, MATCH(E$32, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$J:$J, MATCH(E$32, 'Part Matrix'!$T:$T, 0))))","v":0},"Sele-0-0","Select Insulation Type",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$E:$E, MATCH(E$32, 'Part Matrix'!$T:$T, 0))),\"\",INDEX('Part Matrix'!$E:$E, MATCH(E$32, 'Part Matrix'!$T:$T, 0)))","v":0},{"$f":"IF(ISERROR(INDEX('Part Matrix'!$I:$I, MATCH(E$32, 'Part Matrix'!$T:$T, 0))),\"\",(INDEX('Part Matrix'!$I:$I, MATCH(E$32, 'Part Matrix'!$T:$T, 0))))","v":0},"","Select Conduit Type",null,null,"",{"$f":"IF(ISERROR(VLOOKUP(_xlfn.CONCAT(AE32:AF32),'Part Matrix'!$AP:$AS,4,0)),0,(VLOOKUP(_xlfn.CONCAT(AE32:AF32),'Part Matrix'!$AP:$AS,4,0)))","v":0},"",null,null,"","",null,{"$f":"IF(ISERROR(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E32,'Part Matrix'!$T:$T))),\"\",(INDEX('Part Matrix'!$Z:$Z,MATCH(Configurator!E32,'Part Matrix'!$T:$T))))","v":0},null,null,null,"00","00","00","00",{"$f":"IF(COUNTIF(AW32:AZ32,\"<>00\")=0,\"Equal\",IF(COUNTIF(AW32:AZ32,\"<>00\")<2,\"All Ignored\",IF(SUMPRODUCT((AW32:AZ32<>\"00\")*(AW32:AZ32<>INDEX(AW32:AZ32,MATCH(TRUE,AW32:AZ32<>\"00\",0))))=0,\"Equal\",\"Connection Device Not Compatible\")))","v":{"$error":"#N/A"}},0]

{"sheet":"BOM_Summary","index":3,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Line","Config#","Description","Part","Qty","Total Qty","Config",null,null,null,null,null,null,null,"Row Labels","Sum of Total Qty"]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","320P7W",1,1,"03",null,null,null,null,null,null,null,"LBL-1/2\"",2,null,"Run Report"]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","320C7W",1,1,"03",null,null,null,null,null,null,null,"2030N",1]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","THHNBC-12AWG-0",40,40,"03",null,null,null,null,null,null,null,"320P7W",1]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","THHNBC-12AWG-9",40,40,"03",null,null,null,null,null,null,null,"320C7W",1]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","THHNBC-12AWG-5",40,40,"03",null,null,null,null,null,null,null,"LFMC-1/2\"-GRY",40]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","LFMC-1/2\"-GRY",40,40,"03",null,null,null,null,null,null,null,"LFMC-FITTING-Str-1/2\"",40]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","LFMC-FITTING-Str-1/2\"",40,40,"03",null,null,null,null,null,null,null,"THHNBC-12AWG-0",40]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","LBL-1/2\"",2,2,"03",null,null,null,null,null,null,null,"THHNBC-12AWG-9",40]
[1,"PC48020S2-40123-40G-LTST","40ft, 480V, 20A,Single Phase 2P, 40ft Conduit,Gray 1/2\"","2030N",1,1,"03",null,null,null,null,null,null,null,"THHNBC-12AWG-5",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",205]