{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pivot Cat Logic","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"Pivot Cat Logic","index":0,"n_rows":17,"n_cols":35,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,25,12,26],[12,33,12,34],[13,33,13,34],[13,29,13,30],[13,11,13,12],[13,13,13,14],[13,15,13,16],[13,19,13,20],[2,8,5,12],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[16,3,16,13],[2,0,2,2],[16,0,16,1],[12,29,12,30],[12,11,12,12],[12,13,12,14],[12,15,12,16],[12,19,12,20],[12,23,12,24],[13,23,13,24],[13,25,13,26],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10]]}
["CR2 CONFIG TOOL"]
["Body",null,null,null,null,null,null,null,"Instructions:"]
[{"$f":"A13&B13&D13&F13&H13&J13&L13&N13&P13","v":""},null,null,null,null,null,null,null,"Allow Macros for full functionality. Select options from drop down menus going from left to right. If a cell is RED there is an incorrect option selected. Cells turn white when allowable selections are made. For configuration rules see product spec sheet."]
["Optic"]
[{"$f":"S13&T13","v":""}]
["Bezel"]
[{"$f":"W13&X13&Z13","v":""}]
["Optical Effect 1"]
[{"$f":"AC13&AD13","v":""}]
["Optical Effect 2"]
[{"$f":"AG13&AH13","v":""}]
[]
[]
["Series","CRI & CCT",null,"Lumens",null,"Voltage",null,"Dimming",null,"Mounting Type",null,"Body Finish",null,"EM Options",null,"Mounting Options",null,null,"Series","Optics",null,null,"Series","Bezel Style",null,"Bezel Finish",null,null,"Series","Optical Effects",null,null,"Series","Optical Effects"]
["CR2","\n822\n827\n830\n835\n840\n\n927\n930\n935\n940\n9DW","80 CRI\n2200K\n2700K\n3000K\n3500K\n4000K\n90 CRI\n2700K\n3000K\n3500K\n4000K\n3000-1600 Dim to Warm","05\n10\n15\n20","500\n1000\n1500\n2000","X\n\n3","Universal\n\n347V","D5\nL2\nA2","1%, 0-10V, ELV, & TRIAC\n.1% Lutron Hi-lume EcoSystem\n.1%, eldoLED\n\n","CD36\nCD72\nCD144\n\nCM36\nCM72\nCM144\n\nHM24\nHM36\nHM72\n\nPM24\nPM36\nPM72\n\nSM\nWM\n","Cord & Cable Mount 36\"\nCord & Cable Mount 72\"\nCord & Cable Mount 144\"\n\nCord Only 36\"\nCord Only 72\"\nCord Only 144\"\n\nHang Straight Stem 24\"\nHang Straight Stem 36\"\nHang Straight Stem 72\"\n\nRigid Stem 24\"\nRigid Stem 36\"\nRigid Stem 72\"\n\nSurface Mount\nWall Mount","TW\nTB\nMT\nBZ\nCC","Textured White\nTextured Black\nTextured Silver\nBronze\nCustom Color","EM","Emergency Battery Pack","RRM\n\nSRM\n\nCK1\nCK2\nCK3\nCK4\nCK5\n\n","Recessed Remote Driver Box\n\nSurface Remote Driver Box\n\n1x Conduit Feed\n2x Conduit Feed, Straight\n2x Conduit Feed, 90° Corner\n3x Conduit Feed, T Pattern\n4x Conduit Feed, X Pattern",null,"RD2","XS\nSP\nFL\nXF\nWW","Extra Narrow Spot\nSpot\nFlood\nExtra Wide Flood\nWall Wash",null,"RB2","BS\nBK\nBB\nBD\nBW\n\nBSA1\nBSA2\nBSA3\nBSA4\nBKA1\nBKA2\nBKA3\nBKA4","Standard Bezel\nBezel w/ Knurl\nBias\nSnoot / Deep Cutoff\nBias Wall Wash\n\nAcrylic .5\"\nAcrylic 2\"\nAcrylic 6\"\nAcrylic 12\"\nAcrylic .5\" w/ Knurl\nAcrylic 2\" w/ Knurl\nAcrylic 6\" w/ Knurl\nAcrylic 12\" w/ Knurl","ASG\nARG\nABK\nAGD\nTW\nTB\nMT\nBZ\nCC","Soft Glow, Anodized\nRose Gold, Anodized\nBlack, Anodized\nGold, Anodized\nTextured White\nTextured Black\nTextured Silver\nBronze\nCustom Color",null,"RA2","HL\nLS\nLL\nLC","Hexcel\nDiffusing Lens\nLinear Spread Lens\nClear Lens",null,"RA2","HL\nLS\nLL\nLC","Hexcel\nDiffusing Lens\nLinear Spread Lens\nClear Lens"]
[]
["Rev A 12/21",null,null,"PROPRIETARY AND CONFIDENTIAL - THE INFORMATION CONTAINED IN THIS DOCUMENT IS THE SOLE PROPERTY OF SPECTRUM LIGHTING INC. ANY REPRODUCTION IN PART OR AS A WHOLE WITHOUT THE WRITTEN PERMISSION OF SPECTRUM LIGHTING IS PROHIBITED."]

{"sheet":"Data","index":1,"n_rows":68,"n_cols":30,"rows_kept":68,"cut":false,"hidden":false,"merged":[[21,0,21,1],[42,0,42,1],[49,0,49,1],[55,0,55,1],[62,0,62,1]]}
[{"$f":"'Pivot Cat Logic'!A13","v":0},{"$f":"'Pivot Cat Logic'!B13","v":0},null,{"$f":"'Pivot Cat Logic'!D13","v":0},null,{"$f":"'Pivot Cat Logic'!F13","v":0},null,{"$f":"'Pivot Cat Logic'!H13","v":0},null,{"$f":"'Pivot Cat Logic'!J13","v":0},null,{"$f":"'Pivot Cat Logic'!L13","v":0},null,{"$f":"'Pivot Cat Logic'!$N$13","v":0}]
["Series","CRI & CCT",null,"Lumens",null,"Voltage",null,"120/277V Dimming",null,"Mounting Type",null,"Body Finish",null,"EM Options",null,"Integral Mounting Options",null,null,"Series","Blank",null,null,"Series","Standard",null,"Bezel Finish",null,null,"Series","Optical Effects"]
["CR2","822",null,"05",null,"X",null,"D5",null,"CD36",null,"TW",null,"EM",null,null,null,null,"RD2","XS",null,null,"RB2","BS",null,"ASG",null,null,"RA2","HL"]
[null,"827",null,"10",null,"3",null,"L2",null,"CD72",null,"TB",null,null,null,"CK1",null,null,null,"SP",null,null,null,"BK",null,"ARG",null,null,null,"LS"]
[null,"830",null,"15",null,null,null,"A2",null,"CD144",null,"MT",null,"347V EM Options",null,"CK2",null,null,null,"FL",null,null,null,"BB",null,"ABK",null,null,null,"LL"]
[null,"835",null,"20",null,"500lm Voltage",null,null,null,"CM36",null,"BZ",null,null,null,"CK3",null,null,null,"XF",null,null,null,"BD",null,"AGD",null,null,null,"LC"]
[null,"840",null,null,null,"X",null,"347V Dimming",null,"CM72",null,"CC",null,null,null,"CK4",null,null,null,"WW",null,null,null,"BSA1",null,"TW"]
[null,"927",null,"D2W Lumens",null,null,null,"D5",null,"CM144",null,null,null,null,null,"CK5",null,null,null,null,null,null,null,"BSA2",null,"TB"]
[null,"930",null,"10",null,null,null,null,null,"HM24",null,null,null,null,null,null,null,null,null,"Wall Wash",null,null,null,"BSA3",null,"MT"]
[null,"935",null,null,null,null,null,null,null,"HM36",null,null,null,null,null,"Remote Mounting Options",null,null,null,"WW",null,null,null,"BSA4",null,"BZ"]
[null,"940",null,null,null,null,null,null,null,"HM72",null,null,null,null,null,"RRM",null,null,null,null,null,null,null,"BKA1",null,"CC"]
[null,"9DW",null,null,null,null,null,null,null,"PM24",null,null,null,null,null,"SRM",null,null,null,"Standard",null,null,null,"BKA2"]
[null,null,null,null,null,null,null,null,null,"PM36",null,null,null,null,null,"CK1",null,null,null,"XS",null,null,null,"BKA3"]
[null,null,null,null,null,null,null,null,null,"PM72",null,null,null,null,null,"CK2",null,null,null,"SP",null,null,null,"BKA4"]
[null,null,null,null,null,null,null,null,null,"SM",null,null,null,null,null,"CK3",null,null,null,"FL"]
[null,null,null,null,null,null,null,null,null,"WM",null,null,null,null,null,"CK4",null,null,null,"XF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CK5",null,null,null,null,null,null,null,"Wall Wash"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Mount Options"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank"]
["Body SKU Formatting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EM Mount Options",null,null,null,null,null,null,null,"BS"]
["Series",{"$f":"IF(NOT('Pivot Cat Logic'!$A$13=Data!$A$3),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"RRM",null,null,null,null,null,null,null,"BK"]
["CRI&CCT",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$B$13=Data!B3,'Pivot Cat Logic'!$B$13=Data!B4,'Pivot Cat Logic'!$B$13=Data!B5,'Pivot Cat Logic'!$B$13=Data!B6,'Pivot Cat Logic'!$B$13=Data!B7,'Pivot Cat Logic'!$B$13=Data!B8,'Pivot Cat Logic'!$B$13=Data!B9,'Pivot Cat Logic'!$B$13=Data!B10,'Pivot Cat Logic'!$B$13=Data!B11,'Pivot Cat Logic'!$B$13=Data!B12)),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"SRM",null,null,null,null,null,null,null,"BB"]
["Lumens",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$D$13=Data!D3,'Pivot Cat Logic'!$D$13=Data!D4,'Pivot Cat Logic'!$D$13=Data!D5,'Pivot Cat Logic'!$D$13=Data!D6)),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW"]
["Lumens/D2W",{"$f":"IF(AND('Pivot Cat Logic'!$B$13=Data!$B$12,OR('Pivot Cat Logic'!$D$13=Data!$D$3,'Pivot Cat Logic'!$D$13=Data!$D$5,'Pivot Cat Logic'!$D$13=Data!$D$6)),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Mount Integral",null,null,null,null,null,null,null,"BD"]
["Voltage",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$F$13=Data!F3,'Pivot Cat Logic'!$F$13=Data!F4)),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSA1"]
["Voltage/Lumens",{"$f":"IF(AND('Pivot Cat Logic'!$D$13=Data!$D$3,'Pivot Cat Logic'!$F$13=Data!$F$4),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSA2"]
["Dimming",{"$f":"IF(NOT(OR(H1=H3,H1=H4,H1=H5)),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"Mounting Type Formula","X",null,null,null,null,null,null,"BSA3"]
["Dimming/Voltage",{"$f":"IF(AND(F1=Data!$F$4,OR(H1=Data!$H$4,H1=Data!$H$5)),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Integral",{"$f":"IF(AND('Pivot Cat Logic'!$J$13=Data!$J$16,NOT(OR('Pivot Cat Logic'!$D$13=Data!$D$6,'Pivot Cat Logic'!$F$13=Data!$F$4,'Pivot Cat Logic'!$H$13=Data!$H$4,'Pivot Cat Logic'!$H$13=Data!$H$5))),Data!$Q$29)","v":false},null,null,null,null,null,null,"BSA4"]
["Mounting Type",{"$f":"IF(NOT(OR(J1=J3,J1=J4,J1=J5,J1=J6,J1=J7,J1=J8,J1=J9,J1=J10,J1=J11,J1=J12,J1=J13,J1=J14,J1=J15,J1=J16)),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Remote",{"$f":"IF(AND('Pivot Cat Logic'!$J$13=Data!$J$16,OR('Pivot Cat Logic'!$D$13=Data!$D$6,'Pivot Cat Logic'!$F$13=Data!$F$4,'Pivot Cat Logic'!$H$13=Data!$H$4,'Pivot Cat Logic'!$H$13=Data!$H$5)),Data!$Q$29)","v":false},null,null,null,null,null,null,"BKA1"]
["Body Finish",{"$f":"IF(NOT(OR(L1=L3,L1=L4,L1=L5,L1=L6,L1=L7)),1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"EM",{"$f":"IF('Pivot Cat Logic'!$N$13=Data!$N$3,Data!$Q$29)","v":false},null,null,null,null,null,null,"BKA2"]
["EM",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$N$13=Data!N3,'Pivot Cat Logic'!$N$13=Data!N4)),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Remote",{"$f":"IF(AND(NOT('Pivot Cat Logic'!$N$13=Data!$N$3),NOT('Pivot Cat Logic'!$J$13=Data!$J$16),OR('Pivot Cat Logic'!$D$13=Data!$D$6,'Pivot Cat Logic'!$F$13=Data!$F$4,'Pivot Cat Logic'!$H$13=Data!$H$4,'Pivot Cat Logic'!$H$13=Data!$H$5)),Data!$Q$29)","v":false},null,null,null,null,null,null,"BKA3"]
["EM/347V",{"$f":"IF(AND('Pivot Cat Logic'!$F$13=Data!$F$4,'Pivot Cat Logic'!$N$13=Data!$N$3),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Integral",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$D$13=Data!D6,'Pivot Cat Logic'!$F$13=Data!F4,'Pivot Cat Logic'!$H$13=Data!H4,'Pivot Cat Logic'!$H$13=Data!H5,'Pivot Cat Logic'!$J$13=Data!J16,'Pivot Cat Logic'!$N$13=Data!N3)),Data!$Q$29)","v":"X"},null,null,null,null,null,null,"BKA4"]
["EM/Wall",{"$f":"IF(AND('Pivot Cat Logic'!$J$13=Data!$J$16,'Pivot Cat Logic'!$N$13=Data!$N$3),1,0)","v":0}]
["Mounting Options",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$P$13=Data!P3,'Pivot Cat Logic'!$P$13=Data!P4,'Pivot Cat Logic'!$P$13=Data!P5,'Pivot Cat Logic'!$P$13=Data!P6,'Pivot Cat Logic'!$P$13=Data!P7,'Pivot Cat Logic'!$P$13=Data!P8,'Pivot Cat Logic'!$P$13=Data!P11,'Pivot Cat Logic'!$P$13=Data!P12)),1,0)","v":0}]
["Integral Mounting Options",{"$f":"IF(AND(OR('Pivot Cat Logic'!$P$13=Data!$P$23,'Pivot Cat Logic'!$P$13=Data!$P$24),NOT(OR('Pivot Cat Logic'!$D$13=Data!$D$6,'Pivot Cat Logic'!$F$13=Data!$F$4,'Pivot Cat Logic'!$H$13=Data!$H$4,'Pivot Cat Logic'!$H$13=Data!$H$5,'Pivot Cat Logic'!$N$13=Data!$N$3))),1,0)","v":0}]
["Remote Mounting Options",{"$f":"IF(AND(NOT(OR('Pivot Cat Logic'!$P$13=$P$11,'Pivot Cat Logic'!$P$13=$P$12,'Pivot Cat Logic'!$P$13=$P$13,'Pivot Cat Logic'!$P$13=$P$14,'Pivot Cat Logic'!$P$13=$P$15,'Pivot Cat Logic'!$P$13=$P$16,'Pivot Cat Logic'!$P$13=$P$17)),OR('Pivot Cat Logic'!$D$13=$D$6,'Pivot Cat Logic'!$F$13=$F$4,'Pivot Cat Logic'!$H$13=$H$4,'Pivot Cat Logic'!$H$13=$H$5,'Pivot Cat Logic'!$N$13=$N$3)),1,0)","v":0}]
["Wall Mount Options Remote",{"$f":"IF(AND('Pivot Cat Logic'!$J$13=Data!$J$16,OR('Pivot Cat Logic'!$P$13=Data!$P$11,'Pivot Cat Logic'!$P$13=Data!$P$13,'Pivot Cat Logic'!$P$13=Data!$P$14,'Pivot Cat Logic'!$P$13=Data!$P$15,'Pivot Cat Logic'!$P$13=Data!$P$16,'Pivot Cat Logic'!$P$13=Data!$P$17)),1,0)","v":0}]
["EM Mount Options",{"$f":"IF(AND('Pivot Cat Logic'!$N$13=Data!$N$3,OR('Pivot Cat Logic'!$P$13=Data!$P$4,'Pivot Cat Logic'!$P$13=Data!$P$5,'Pivot Cat Logic'!$P$13=Data!$P$6,'Pivot Cat Logic'!$P$13=Data!$P$7,'Pivot Cat Logic'!$P$13=Data!$P$8)),1,0)","v":0}]
["Total",{"$f":"SUM(B23:B40)","v":7}]
[]
["Optic SKU Formatting"]
["Series",{"$f":"IF(NOT('Pivot Cat Logic'!S13=Data!S3),1,0)","v":1}]
["Optics",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$T$13=Data!T3,'Pivot Cat Logic'!$T$13=Data!T4,'Pivot Cat Logic'!$T$13=Data!T5,'Pivot Cat Logic'!$T$13=Data!T6,'Pivot Cat Logic'!$T$13=Data!T7)),1,0)","v":1}]
["WW",{"$f":"IF(AND('Pivot Cat Logic'!$T$13=Data!$T$10,NOT(OR('Pivot Cat Logic'!$X$13=Data!$X$18,'Pivot Cat Logic'!$X$13=Data!$X$19))),1,0)","v":0}]
["BW",{"$f":"IF(AND(NOT(OR('Pivot Cat Logic'!$T$13=Data!T10,'Pivot Cat Logic'!$T$13=Data!T11)),'Pivot Cat Logic'!$X$13=Data!X18),1,0)","v":0}]
["Total",{"$f":"SUM(B44:B47)","v":2}]
[]
["Bezel SKU Formatting"]
["Series",{"$f":"IF(NOT('Pivot Cat Logic'!$W$13=Data!W3),1,0)","v":1}]
["Bezel Style",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$X$13=Data!X22,'Pivot Cat Logic'!$X$13=Data!X23,'Pivot Cat Logic'!$X$13=Data!X24,'Pivot Cat Logic'!$X$13=Data!X25,'Pivot Cat Logic'!$X$13=Data!X26,'Pivot Cat Logic'!$X$13=Data!X27,'Pivot Cat Logic'!$X$13=Data!X28,'Pivot Cat Logic'!$X$13=Data!X29,'Pivot Cat Logic'!$X$13=Data!X30,'Pivot Cat Logic'!$X$13=Data!X31,'Pivot Cat Logic'!$X$13=Data!X32,'Pivot Cat Logic'!$X$13=Data!X33,'Pivot Cat Logic'!$X$13=Data!X34)),1,0)","v":1}]
["Bezel Finish",{"$f":"IF(NOT(OR('Pivot Cat Logic'!$Z$13=Data!Z3,'Pivot Cat Logic'!$Z$13=Data!Z4,'Pivot Cat Logic'!$Z$13=Data!Z5,'Pivot Cat Logic'!$Z$13=Data!Z6,'Pivot Cat Logic'!$Z$13=Data!Z7,'Pivot Cat Logic'!$Z$13=Data!Z8,'Pivot Cat Logic'!$Z$13=Data!Z9,'Pivot Cat Logic'!$Z$13=Data!Z10,'Pivot Cat Logic'!$Z$13=Data!Z11)),1,0)","v":1}]
["Total",{"$f":"SUM(B51:B53)","v":3}]
[]
["Optical Effect 1 SKU Formatting"]
["Series",{"$f":"IF(AND(NOT('Pivot Cat Logic'!$AC$13=Data!$AC$3),NOT('Pivot Cat Logic'!$AD$13=Data!$AD$7)),1,0)","v":0}]
["Series/BW",{"$f":"IF(AND('Pivot Cat Logic'!$X$13=Data!$X$18,NOT('Pivot Cat Logic'!$AC$13=Data!$AD$7)),1,0)","v":0}]
["Optical Effect",{"$f":"IF(AND('Pivot Cat Logic'!$AC$13=Data!$AC$3,NOT(OR('Pivot Cat Logic'!$AD$13=Data!$AD$3,'Pivot Cat Logic'!$AD$13=Data!$AD$4,'Pivot Cat Logic'!$AD$13=Data!$AD$5,'Pivot Cat Logic'!$AD$13=Data!$AD$6))),1,0)","v":0}]
["Optical Effect/BW",{"$f":"IF(AND('Pivot Cat Logic'!$X$13=Data!$X$18,NOT('Pivot Cat Logic'!$AD$13=Data!$AD$7)),1,0)","v":0}]
["Total",{"$f":"SUM(B57:B60)","v":0}]
[]
["Optical Effect 2 SKU Formatting"]
["Series",{"$f":"IF(AND(NOT('Pivot Cat Logic'!$AG$13=Data!$AC$3),NOT('Pivot Cat Logic'!$AH$13=Data!$AD$7)),1,0)","v":0}]
["Series/BW",{"$f":"IF(AND('Pivot Cat Logic'!$X$13=Data!$X$18,NOT('Pivot Cat Logic'!$AG$13=Data!$AD$7)),1,0)","v":0}]
["Optical Effect",{"$f":"IF(AND('Pivot Cat Logic'!$AG$13=Data!$AC$3,NOT(OR('Pivot Cat Logic'!$AH$13=Data!$AD$3,'Pivot Cat Logic'!$AH$13=Data!$AD$4,'Pivot Cat Logic'!$AH$13=Data!$AD$5,'Pivot Cat Logic'!$AH$13=Data!$AD$6))),1,0)","v":0}]
["Optical Effect/BW",{"$f":"IF(AND('Pivot Cat Logic'!$X$13=Data!$X$18,NOT('Pivot Cat Logic'!$AH$13=Data!$AD$7)),1,0)","v":0}]
["Total",{"$f":"SUM(B64:B67)","v":0}]