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

 | TOTAL ESTIMATES (CUSTOMERS)
 | OVERALL TOTALS | 708 | 692 | 708 | 713 | 718 | 728 | 740 | 741 | 751 | 751 | 762 | 774 | 790 | 809 | 802 | 803 | 826 | 857
 | 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 | 7 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Advance Electrical - Chicago IL |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | All Metro Electrical Distributors | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Anixter Power Solutions - Charlotte, NC | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Atlanta Electrical Distributors | 1
 | BC Lighting Group | 6 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | Bell & McCoy Alabama | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Bell & McCoy Austin | 28 | 29 | 33 | 32 | 34 | 35 | 35 | 34 | 38 | 40 | 40 | 39 | 42 | 44 | 45 | 46 | 49 | 52
 | Bell & McCoy Farmers Branch | 31 | 29 | 30 | 26 | 28 | 28 | 29 | 30 | 30 | 31 | 34 | 37 | 35 | 35 | 35 | 32 | 32 | 35
 | Bell & McCoy Houston | 50 | 49 | 51 | 52 | 55 | 56 | 55 | 54 | 55 | 57 | 59 | 64 | 64 | 67 | 69 | 71 | 75 | 78
 | Bell & McCoy Little Rock, AR | 10 | 9 | 9 | 9 | 10 | 10 | 10 | 13 | 14 | 16 | 17 | 19 | 19 | 21 | 20 | 21 | 24 | 25
 | Bell & McCoy Louisiana | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 8 | 9 | 9 | 9 | 10 | 11
 | Bell & McCoy Mississippi | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Bell & McCoy Oklahoma | 36 | 36 | 38 | 37 | 37 | 38 | 40 | 43 | 45 | 46 | 45 | 45 | 45 | 45 | 46 | 47 | 50 | 50
 | Bell & McCoy San Antonio | 18 | 17 | 18 | 20 | 22 | 21 | 22 | 22 | 25 | 25 | 27 | 26 | 26 | 26 | 26 | 25 | 26 | 25
 | Border States Industries - IUO |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 | Border States Industries - IUO : Border States Industries - Charlotte, NC | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | 2 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 4 | 4 | 4 | 4 | 4
 | [NAME] : Bliss Lighting | 6 | 5 | 5 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 6
 | California Electric Supply |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | California Lighting Sales | 56 | 56 | 56 | 57 | 58 | 58 | 59 | 59 | 55 | 55 | 57 | 57 | 55 | 55 | 56 | 57 | 59 | 60
 | California Lighting Sales : Commerce Lighting Supply, Inc |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 6
 | Cantlon Lighting | 1
 | Capital Electric - Charlotte, NC | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Carols Lighting | 5 | 5 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1
 | Carr-Trumbull Lumber | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | CBMC Lighting Solutions | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : 3E - Lincoln, NE |  |  |  | 1
 | CED - IUO : All Phase Electric - Glenwood Springs CO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | CED - IUO : All-Phase Electric - Oxnard, CA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Corpus Christi | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Dallas, TX | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Erlanger, KY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | CED - IUO : CED - Euless, TX | 1
 | CED - IUO : CED - Fort Worth, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Houston, TX Greens Pkwy |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 2 | 2 | 3 | 3 | 3 | 3
 | CED - IUO : CED - Orange, CA | 1 | 1
 | CED - IUO : CED - Pflugerville 0234, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Salt Lake City, UT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CED - IUO : CED - Wilson, NC | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | City Electric Supply - IUO : CES - Nashville, TN North | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | City Electric Supply - IUO : City Electric Supply - Brenham, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Coastal Lighting and Supply | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Colonial Electric Supply Co. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Complete Electrical Installations, Inc. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Cooper Electric Supply | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Courtesy Electric Wholesale |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
 | CR Lighting | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Crawford Electric - Houston, TX | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Crawford Electric - Irving, TX | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 2 | 2 | 1
 | Crescent Lighting Solutions |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Crest Lighting Co. |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] #1021 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Dealers Electrical - IUO : Dealers Electrical - Houston, TX | 2 | 2 | 1 | 1 | 1 | 1 | 1
 | Decker Electric | 1 | 1 | 1 | 1
 | Distinctive Solutions, Inc | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
 | Doeren Sales and Associates | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6
 | Dominion Electric Supply |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | E2I Solutions | 1
 | Eckart LLC |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Edges Electrical Group, LLC - San Leandro, CA | 1 | 1 | 1 | 1
 | Electric Supply Center |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Electric Supply Inc |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | Electrical Supply of Milford | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
 | Electrical [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Electrical Wholesalers - Newington, NH | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Electrical Wholesalers - Woonsocket, RI | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Ellen Lighting & Hardware | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3
 | Elliott Electric - IUO : Elliott Electric - Conway, AR | 1 | 1 | 1 | 1 | 1
 | Elliott Electric - IUO : [NAME], TX #49 (RDC) |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 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 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Expressive Lighting |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | Facility Solutions Group - IUO : FSG - MDC South Irving, TX |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Facility Solutions Group - IUO : FSG - NY, NY | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Facility Solutions Group - IUO : FSG - Shawnee, KS | 2 | 2 | 2 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Facility Solutions Group - IUO : FSG - Steadmont Houston, TX | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 3 | 3 | 2 | 2 | 2 | 2 | 2
 | Facility Solutions Group - IUO : FSG - Walnut Hill Dallas, TX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
 | Fadecci Architectural Lighting |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Family (Ship to TX) | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Federated Lighting of Virginia | 13 | 12 | 12 | 12 | 13 | 12 | 12 | 12 | 12 | 12 | 14 | 14 | 15 | 16 | 16 | 18 | 19 | 19
 | Feldman Brothers | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Ferguson - IUO : Ferguson - Ashville, NC | 1
 | Ferguson - IUO : Ferguson - Austin, TX | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2
 | Ferguson - IUO : Ferguson - Charlotte, NC #34 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 1 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1
 | Ferguson - IUO : Ferguson - Ft Lauderdale, FL | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Ferguson - IUO : Ferguson - Greensboro, NC | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Ferguson - IUO : Ferguson - Houston, TX Richmond Ave | 7 | 7 | 7 | 7 | 5 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 6 | 6 | 6 | 5 | 5 | 5
 | 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 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Ferguson - IUO : Ferguson - Sacramento, CA |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | First Source Electrical | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1
 | Fixtur-World, Inc | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Form Lighting and Controls | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Fort Worth Lighting | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 3 | 3 | 5 | 5
 | Friends (Ship to TX) |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Gemini Cut Glass Company Inc |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO : Graybar - Charlotte, NC | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO : Graybar - Edison, NJ | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO : Graybar - Fort Worth, Dallas, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO : Graybar - Houston, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO : Graybar - Naples, FL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Graybar - IUO : Graybar - Pome Portland, ME | 3 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 6
 | Graybar - IUO : Graybar - Portland, OR |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | Green Electrical Solutions | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 6 | 5 | 4 | 4 | 4 | 4 | 4 | 3 | 3
 | Hays Electrical Services Inc. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Hermitage Electric Supply | 4 | 4 | 4 | 4 | 4 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2
 | High Tech Applications | 14 | 14 | 15 | 16 | 17 | 16 | 17 | 16 | 17 | 17 | 16 | 17 | 18 | 19 | 18 | 17 | 20 | 20
 | Hill Country Electric - Austin, TX |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Home Makeover Expo - Katy, TX | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Illumination Systems | 26 | 24 | 28 | 29 | 29 | 28 | 27 | 26 | 27 | 26 | 26 | 27 | 27 | 28 | 29 | 31 | 32 | 37
 | Interiors by [NAME] (Space by Rbi) | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1
 | Jackson Lighting Supply | 1 | 1 | 1 | 1 | 1
 | [NAME] | 5 | 5 | 5 | 6 | 6 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 7
 | [NAME] | 11 | 12 | 12 | 13 | 12 | 12 | 14 | 15 | 15 | 14 | 16 | 15 | 15 | 17 | 17 | 18 | 19 | 19
 | Just Led + Lights | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | JW Sales | 4 | 4 | 5 | 6 | 6 | 6 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
 | Kenclaire West Electrical |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Kendall Electric - IUO : Kendall Electric - Wabash, IN |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Kendall/Heaton Associates Inc. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Kirby Risk Electrical Supply |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | KTR Associates | 6 | 7 | 7 | 7 | 7 | 8 | 7 | 8 | 7 | 7 | 6 | 5 | 5 | 5 | 5 | 7 | 6 | 6
 | Langlais Group | 13 | 12 | 11 | 11 | 11 | 13 | 13 | 12 | 12 | 13 | 13 | 14 | 15 | 17 | 16 | 17 | 16 | 18
 | LEDI Internal Use Only |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5
 | Legend Lighting | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 10 | 10 | 9 | 10 | 10 | 9 | 8 | 7 | 7 | 7
 | Lido Lighting - Hauppauge, NY | 1
 | LIGHT Company - Houston, TX | 2 | 3 | 4 | 4 | 4 | 5 | 6 | 6 | 6 | 7 | 7 | 8 | 9 | 10 | 10 | 11 | 11 | 11
 | 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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Lights Fantastic Fleco - IUO | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Lights Fantastic Fleco - IUO : [NAME], TX | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 4 | 4 | 4 | 3 | 4 | 4
 | Lights Fantastic Fleco - IUO : [NAME] (TX Fluor) |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Lights Fantastic Fleco - IUO : [NAME], TX | 7 | 7 | 7 | 7 | 7 | 7 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Houston, TX | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Lewisville, TX |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3
 | Lights Fantastic Pro - Dallas, TX | 5 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2
 | Locke Supply Co - Oklahoma City, OK | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Locke Supply Co., - Richmond, VA | 1 | 1 | 1 | 1
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Austin | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Dallas, TX |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Houston | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Luminous Trends | 10 | 10 | 11 | 12 | 13 | 13 | 14 | 14 | 14 | 13 | 13 | 12 | 12 | 12 | 11 | 11 | 11 | 12
 | Lux Lighting Design - Belmont, MA | 5 | 6 | 6 | 5 | 5 | 5 | 4 | 5 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 4
 | M&M - IUO | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1
 | M&M - IUO : M&M Lighting - Direct | 12 | 12 | 12 | 12 | 12 | 13 | 14 | 13 | 15 | 14 | 13 | 13 | 13 | 13 | 14 | 13 | 15 | 15
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc- TX | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 4 | 3 | 3
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc. CT ([NAME]) | 11 | 11 | 11 | 11 | 9 | 9 | 10 | 7 | 7 | 6 | 6 | 5 | 5 | 5 | 6 | 6 | 6 | 6
 | Marsh Sales | 15 | 15 | 16 | 16 | 17 | 17 | 18 | 18 | 18 | 19 | 18 | 20 | 20 | 21 | 22 | 21 | 21 | 23
 | Mayer Electric Supply - Charlotte, NC | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1
 | Meletio Lighting - Dolan Northwest - Resi | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Metro Electric Supply | 6 | 5 | 5 | 6 | 6 | 8 | 8 | 7 | 7 | 7 | 7 | 8 | 7 | 8 | 8 | 8 | 8 | 8
 | Mike's Lighting & Cabinet Center | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1
 | MSRP | 4 | 4 | 4 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | No Limit Lighting Sales | 9 | 9 | 9 | 9 | 8 | 8 | 8 | 8 | 9 | 7 | 7 | 7 | 9 | 9 | 9 | 10 | 12 | 12
 | North Coast Electric - IUO : North Coast Electric - Bellevue, WA | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 2
 | Omega Construction & Wine Rooms |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | ParamontEO | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | PDI Plumbing Distributors Inc | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | Platt Electric Supply | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Premier Technology Group | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] |  |  |  |  | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
 | Resource Lighting & Controls | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4
 | 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 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Rexel - IUO : [NAME], TX | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 2 | 2 | 2 | 2
 | Rexel - IUO : [NAME], WY | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Rexel - IUO : Rexel - Sacramento, CA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Reynolds Company - Houston, TX | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | 53 | 53 | 52 | 49 | 50 | 50 | 51 | 50 | 49 | 49 | 51 | 55 | 56 | 57 | 54 | 49 | 47 | 48
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3
 | Rockingham Electrical Supply - IUO : Rockingham Electrical Supply - Newington | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME], LLC |  |  |  | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | South Dade Lighting | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Southeast Florida Lighting | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 3 | 3
 | Springfield Electric - IUO : Springfield Electric - Springfield, IL |  |  | 1 | 1 | 1 | 1 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | State Electric Supply - IUO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | 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 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2 | 2
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1
 | 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 | 4 | 2 | 2 | 2 | 1 | 1
 | [NAME] |  | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Turtle & Hughes - IUO |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 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 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 6 | 6 | 6 | 8 | 9 | 10 | 10 | 10 | 14 | 15 | 19
 | Walters Wholesale Electric | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Walters Wholesale Electric - Costa Mesa, CA | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | WESCO  Distribution - Kingsport, TN | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | WESCO Distribution - CO |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | WESCO Distribution - IL |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | WESCO Distribution - TN |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Wholesale Electric Supply Co. of Houston Inc. - IUO : Wholesale Electric - Houston, TX | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1
 | [NAME] | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2
 | Wilson Lighting - IUO : Wilson Lighting - Naples, FL | 4 | 4 | 3 | 3 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Wilson Lighting - IUO : WIlson Lighting-Clayton | 1 | 1 | 1 | 1 | 1
 | [NAME] : Broken Arrow Electric | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | World Electric Supply | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1