Spreadsheet: 785444d1656422913-have-cell-change-values-from-same-cell-different-sheet-based-on-drop-down-selection-weekly-report-trend-chart-example-
Sheet: CONVERTED ESTIMATES (CUSTOMER)

 | CONVERSTED ESTIMATES (CUSTOMERS)
 | OVERALL TOTALS | 189 | 195 | 202 | 202 | 205 | 209 | 213 | 214 | 220 | 224 | 232 | 230 | 229 | 236 | 243 | 241 | 237 | 244
 | NAME | 2022-02-24 00:00:00 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | 2022-03-17 00:00:00 | 2022-03-24 00:00:00 | 2022-03-31 00:00:00 | 2022-04-07 00:00:00 | 2022-04-14 00:00:00 | 2022-04-21 00:00:00 | 2022-04-28 00:00:00 | 2022-05-05 00:00:00 | 2022-05-12 00:00:00 | 2022-05-19 00:00:00 | 2022-05-26 00:00:00 | 2022-06-02 00:00:00 | 2022-06-09 00:00:00 | 2022-06-16 00:00:00 | 2022-06-23 00:00:00 | 2022-06-30 00:00:00
 | Accent Lighting, Inc | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Advance Electrical - Chicago IL |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | All Metro Electrical Distributors | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Anixter Power Solutions - Charlotte, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Atlanta Electrical Distributors | 0
 | BC Lighting Group | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bell & McCoy Alabama | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Bell & McCoy Austin | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 5 | 4 | 4 | 4
 | Bell & McCoy Farmers Branch | 8 | 7 | 7 | 7 | 6 | 6 | 6 | 6 | 5 | 5 | 6 | 5 | 5 | 6 | 6 | 5 | 5 | 5
 | Bell & McCoy Houston | 12 | 12 | 12 | 11 | 11 | 13 | 10 | 11 | 12 | 12 | 12 | 14 | 13 | 15 | 18 | 16 | 17 | 17
 | Bell & McCoy Little Rock, AR | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 3 | 4 | 4 | 4
 | Bell & McCoy Louisiana | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2
 | Bell & McCoy Mississippi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bell & McCoy Oklahoma | 12 | 13 | 13 | 14 | 14 | 14 | 14 | 14 | 15 | 15 | 16 | 15 | 13 | 14 | 15 | 14 | 15 | 17
 | Bell & McCoy San Antonio | 0 | 0 | 1 | 1 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3
 | Border States Industries - IUO |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Border States Industries - IUO : Border States Industries - Charlotte, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 2 | 1 | 1 | 1 |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 3 | 3 | 3
 | [NAME] : Bliss Lighting | 6 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 6
 | California Electric Supply |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | California Lighting Sales | 15 | 14 | 14 | 14 | 15 | 16 | 18 | 18 | 18 | 17 | 19 | 19 | 19 | 21 | 22 | 23 | 21 | 22
 | California Lighting Sales : Commerce Lighting Supply, Inc |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Cantlon Lighting | 0
 | Capital Electric - Charlotte, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Carols Lighting | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Carr-Trumbull Lumber | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CBMC Lighting Solutions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : 3E - Lincoln, NE |  |  |  | 0
 | CED - IUO : All Phase Electric - Glenwood Springs CO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | CED - IUO : All-Phase Electric - Oxnard, CA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Corpus Christi | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Dallas, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Erlanger, KY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CED - IUO : CED - Euless, TX | 0
 | CED - IUO : CED - Fort Worth, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Houston, TX Greens Pkwy |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Orange, CA | 0 | 0
 | CED - IUO : CED - Pflugerville 0234, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Salt Lake City, UT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Wilson, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : Electrical Engineering & Equipment - IUO | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Champions Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | City Electric Supply - IUO : CES - Nashville, TN North | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | City Electric Supply - IUO : City Electric Supply - Brenham, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Coastal Lighting and Supply | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Colonial Electric Supply Co. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Complete Electrical Installations, Inc. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cooper Electric Supply | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Courtesy Electric Wholesale |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CR Lighting | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Crawford Electric - Houston, TX | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Crawford Electric - Irving, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Crescent Lighting Solutions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Crest Lighting Co. |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] #1021 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dealers Electrical - IUO : Dealers Electrical - Houston, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Decker Electric | 0 | 0 | 0 | 0
 | Distinctive Solutions, Inc | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Doeren Sales and Associates | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Dominion Electric Supply |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | E2I Solutions | 0
 | Eckart LLC |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Edges Electrical Group, LLC - San Leandro, CA | 0 | 0 | 0 | 0
 | Electric Supply Center |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Electric Supply Inc |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Electrical Supply of Milford | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
 | Electrical [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Electrical Wholesalers - Newington, NH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Electrical Wholesalers - Woonsocket, RI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ellen Lighting & Hardware | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Elliott Electric - IUO : Elliott Electric - Conway, AR | 1 | 1 | 1 | 1 | 1
 | Elliott Electric - IUO : [NAME], TX #49 (RDC) |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EMSCO Electric Supply - Oklahoma City, OK | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Exclusive Energy & Electric |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Expressive Lighting |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Facility Solutions Group - IUO : FSG - MDC South Irving, TX |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Facility Solutions Group - IUO : FSG - NY, NY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Facility Solutions Group - IUO : FSG - Shawnee, KS | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Facility Solutions Group - IUO : FSG - Steadmont Houston, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1
 | Facility Solutions Group - IUO : FSG - Walnut Hill Dallas, TX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Fadecci Architectural Lighting |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Family (Ship to TX) | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Federated Lighting of Virginia | 3 | 3 | 3 | 3 | 5 | 4 | 5 | 4 | 4 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | Feldman Brothers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Ashville, NC | 1
 | Ferguson - IUO : Ferguson - Austin, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Charlotte, NC #34 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Ft Lauderdale, FL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Greensboro, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Houston, TX Richmond Ave | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Ferguson - IUO : Ferguson - Jacksonville, FL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Ferguson - IUO : Ferguson - Nashville, TN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Sacramento, CA |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | First Source Electrical | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1
 | Fixtur-World, Inc | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Form Lighting and Controls | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Fort Worth Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1
 | Friends (Ship to TX) |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Gemini Cut Glass Company Inc |  |  |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Charlotte, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Edison, NJ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Fort Worth, Dallas, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Houston, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Naples, FL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Pome Portland, ME | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Graybar - IUO : Graybar - Portland, OR |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 1 | 1
 | Green Electrical Solutions | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Hays Electrical Services Inc. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
 | Hermitage Electric Supply | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | High Tech Applications | 1 | 1 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4
 | Hill Country Electric - Austin, TX |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Home Makeover Expo - Katy, TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Illumination Systems | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 8 | 9 | 9 | 9 | 9 | 9 | 9 | 8 | 9
 | Interiors by [NAME] (Space by Rbi) | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1
 | Jackson Lighting Supply | 0 | 0 | 0 | 0 | 0
 | [NAME] | 1 | 1 | 1 | 0 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | [NAME] | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4
 | Just Led + Lights | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | JW Sales | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7
 | Kenclaire West Electrical |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Kendall Electric - IUO : Kendall Electric - Wabash, IN |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Kendall/Heaton Associates Inc. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Kirby Risk Electrical Supply |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | KTR Associates | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Langlais Group | 3 | 4 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 6 | 5 | 4 | 4
 | LEDI Internal Use Only |  |  |  |  | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3
 | Legend Lighting | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 5 | 4 | 3 | 3 | 3
 | Lido Lighting - Hauppauge, NY | 0
 | LIGHT Company - Houston, TX | 2 | 3 | 3 | 3 | 2 | 2 | 3 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6
 | Lighting Concepts | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Lighting Inc - IUO- Inactive  -CONTACT REP : Lighting Inc - Houston, TX Gulf Fwy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lights Fantastic Fleco - IUO | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lights Fantastic Fleco - IUO : [NAME], TX | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
 | Lights Fantastic Fleco - IUO : [NAME] (TX Fluor) |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lights Fantastic Fleco - IUO : [NAME], TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Houston, TX | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Lewisville, TX |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
 | Lights Fantastic Pro - Dallas, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Locke Supply Co - Oklahoma City, OK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Locke Supply Co., - Richmond, VA | 1 | 1 | 1 | 1
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Austin | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Dallas, TX |  |  |  |  |  |  |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Houston | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Luminous Trends | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Lux Lighting Design - Belmont, MA | 3 | 3 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 4
 | M&M - IUO | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0
 | M&M - IUO : M&M Lighting - Direct | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 5 | 5 | 5
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc- TX | 3 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 3 | 3
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc. CT ([NAME]) | 7 | 7 | 7 | 7 | 7 | 7 | 9 | 6 | 6 | 5 | 5 | 4 | 4 | 3 | 4 | 4 | 4 | 4
 | Marsh Sales | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3
 | Mayer Electric Supply - Charlotte, NC | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Meletio Lighting - Dolan Northwest - Resi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Metro Electric Supply | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Mike's Lighting & Cabinet Center | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | MSRP | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | No Limit Lighting Sales | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3
 | North Coast Electric - IUO : North Coast Electric - Bellevue, WA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | North Coast Electric - IUO : North Coast Electric - Kent, WA |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | North Coast Electric - IUO : North Coast Electric - Seattle, WA |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Omega Construction & Wine Rooms |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | ParamontEO | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | PDI Plumbing Distributors Inc | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Platt Electric Supply | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Premier Technology Group | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
 | Resource Lighting & Controls | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rexel - IUO : Rexel - Asheville, NC | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 2 | 2
 | Rexel - IUO : [NAME], TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rexel - IUO : [NAME], TX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rexel - IUO : [NAME], WY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rexel - IUO : Rexel - Sacramento, CA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Reynolds Company - Houston, TX | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 11 | 11 | 12 | 12 | 12 | 12 | 15 | 15 | 15 | 16 | 17 | 16 | 15 | 15 | 14 | 12 | 11 | 11
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | Rockingham Electrical Supply - IUO : Rockingham Electrical Supply - Newington | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME], LLC |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | South Dade Lighting | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Southeast Florida Lighting | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Springfield Electric - IUO : Springfield Electric - Springfield, IL |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | State Electric Supply - IUO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | State Electric Supply - IUO : State Electric Supply Company - Huntington, WV | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | State Electric Supply - IUO : State Electric Supply Company - Raleigh, NC | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Summit Electric Supply - Irving, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | The Armored Frog | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | The Light House Gallery | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Turtle & Hughes - IUO |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | United Electric Supply - Langhorne, PA | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Villa Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 4 | 6 | 7 | 7 | 8 | 8 | 10 | 13 | 16
 | Walters Wholesale Electric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Walters Wholesale Electric - Costa Mesa, CA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | WESCO  Distribution - Kingsport, TN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | WESCO Distribution - CO |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | WESCO Distribution - IL |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | WESCO Distribution - TN |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Wholesale Electric Supply Co. of Houston Inc. - IUO : Wholesale Electric - Houston, TX | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Wilson Lighting - IUO : Wilson Lighting - Naples, FL | 3 | 3 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Wilson Lighting - IUO : WIlson Lighting-Clayton | 1 | 1 | 1 | 1 | 1
 | [NAME] : Broken Arrow Electric | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | World Electric Supply | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0