Spreadsheet: 786644d1657317365-named-range-brings-an-error-when-used-in-a-chart-customer-trend-analysis-draft-3a-
Sheet: AMOUNT $ WON (CUSTOMER)

 | AMOUNT $ WON (CUSTOMERS)
 | OVERALL TOTALS | 582461.4 | 625583.46 | 680153.3 | 708521.47 | 689117.51 | 689117.51 | 706035.43 | 744945.18 | 762433.96 | 772954.03 | 784492.74 | 768944.2 | 769187.57 | 817536.14 | 873130.44 | 832720.65 | 797219.26 | 817329.09
 | 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
 | Accent Lighting, Inc | 8450.89 | 8450.89 | 8450.89 | 8450.89 | 8450.89 | 8087.89 | 8087.89 | 8087.89 | 8087.89 | 12115.43 | 12115.43 | 12115.43 | 12115.43 | 12115.43 | 12115.43 | 12115.43 | 12115.43 | 12115.43
 | Advance Electrical - Chicago IL |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | All Metro Electrical Distributors | 0 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896 | 4896
 | 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 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93 | 1832.93
 | Bell & McCoy Austin | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7930.139999999999 | 7904.087 | 6587.666999999999 | 6852.5 | 6852.5 | 7987.5 | 6170 | 6170 | 6170
 | Bell & McCoy Farmers Branch | 18134.17 | 16874.38 | 16235.63 | 16235.63 | 16000.96 | 16000.96 | 16000.96 | 15988.377 | 13453.877 | 13453.877 | 15176.377 | 10189.377 | 10189.377 | 11042.377 | 11042.377 | 5269.517 | 4943.85 | 4943.85
 | Bell & McCoy Houston | 29189.855 | 29189.855 | 29273.735 | 28573.375 | 25781.955 | 28085.955 | 24779.615 | 25192.075 | 34245.075 | 34245.075 | 35630.075 | 38222.27499999999 | 36120.965 | 54430.965 | 56287.733 | 51466.233 | 52205.233 | 52205.233
 | Bell & McCoy Little Rock, AR | 0 | 0 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 10524.3 | 19650.44 | 19650.44 | 20174.33 | 22284.83 | 22284.83 | 22284.83
 | Bell & McCoy Louisiana | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 469.84 | 469.84 | 469.84 | 469.84 | 469.84 | 79036.84 | 79036.84 | 79036.84 | 79036.84
 | Bell & McCoy Mississippi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bell & McCoy Oklahoma | 93751.03 | 123180.03 | 123180.03 | 126920.03 | 126920.03 | 126920.03 | 126920.03 | 144244.62 | 149315.62 | 149315.62 | 153016.69 | 138597.19 | 126108.29 | 153916.72 | 155669.57 | 141256.15 | 154090.16 | 160152.63
 | Bell & McCoy San Antonio | 0 | 0 | 15580.45 | 15580.45 | 18797.45 | 23427.95 | 23427.95 | 23427.95 | 26060.63 | 26960.13 | 26960.13 | 26960.13 | 26960.13 | 26960.13 | 26960.13 | 26960.13 | 22329.63 | 22329.63
 | 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] | 438.99 | 195.5 | 195.5 | 195.5 |  | 0 | 3593.5 | 3593.5 | 3593.5 | 3593.5 | 3593.5 | 3593.5 | 4893.5 | 7423 | 7280.5 | 7280.5 | 7280.5 | 7280.5
 | [NAME] : Bliss Lighting | 6576.9 | 2844.95 | 2844.95 | 3027.95 | 3027.95 | 3027.95 | 4213.95 | 4213.95 | 4213.95 | 4213.95 | 4958.45 | 4958.45 | 4958.45 | 4958.45 | 4323.95 | 4323.95 | 4323.95 | 3785.45
 | California Electric Supply |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | California Lighting Sales | 28230.987 | 27622.717 | 28029.897 | 28029.897 | 33288.897 | 37943.397 | 43491.717 | 39562.99699999999 | 39390.247 | 37849.747 | 39245.492 | 38640.632 | 33030.292 | 34449.29199999999 | 35887.79199999999 | 35955.29199999999 | 33638.285 | 35505.12
 | California Lighting Sales : Commerce Lighting Supply, Inc |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1121
 | Cantlon Lighting | 0
 | Capital Electric - Charlotte, NC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Carols Lighting | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25 | 264.25
 | Carr-Trumbull Lumber | 542 | 542 | 542 | 542 | 542 | 542 | 542
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1139.5 | 1139.5
 | CED - IUO : All-Phase Electric - Oxnard, CA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CED - IUO : CED - Corpus Christi | 13796.32 | 13796.32 | 13796.32 | 13796.32 | 13796.32 | 13796.32 | 13796.32 | 13796.32 | 13796.32
 | 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 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89 | 156.89
 | 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 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9 | 8827.9
 | Crawford Electric - Houston, TX | 0 | 0 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56 | 2005.56
 | 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 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68 | 1207.68
 | 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 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 683.89 | 1365.64 | 1365.64 | 1365.64 | 1365.64 | 1365.64
 | 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 | 13996 | 13996 | 13996 | 13996 | 13996 | 13996 | 13996 | 13996 | 13996
 | Elliott Electric - IUO : Elliott Electric - Conway, AR | 613.78 | 613.78 | 613.78 | 613.78 | 613.78
 | 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 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75 | 2916.75
 | 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 | 1816.74 | 1816.74 | 1816.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Facility Solutions Group - IUO : FSG - Steadmont Houston, TX | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 428.55 | 0 | 510.99 | 510.99 | 510.99 | 510.99 | 510.99 | 510.99
 | 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 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98 | 126.98
 | Federated Lighting of Virginia | 10931.5 | 10931.5 | 10931.5 | 10931.5 | 16093.5 | 12622 | 13349.66 | 8764.66 | 8764.66 | 8764.66 | 19973.91 | 21509.91 | 21509.91 | 21509.91 | 21509.91 | 21509.91 | 21509.91 | 21509.91
 | 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 | 1346.15
 | Ferguson - IUO : Ferguson - Austin, TX | 4709.68 | 4709.68 | 4709.68 | 4709.68 | 4709.68 | 4709.68 | 4709.68 | 4709.68 | 4709.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ferguson - IUO : Ferguson - Charlotte, NC #34 | 518.57 | 518.57 | 518.57 | 518.57 | 518.57 | 518.57 | 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 | 3660.275 | 3660.275 | 3660.275 | 3660.275 | 3660.275 | 3660.275 | 3660.275 | 3660.275 | 3660.275 | 2458.1 | 2458.1 | 2458.1 | 2458.1 | 2458.1 | 2458.1 | 2458.1 | 2458.1 | 2458.1
 | Ferguson - IUO : Ferguson - Jacksonville, FL | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12 | 975.12
 | 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 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 2326.2 | 3864.96 | 1538.76 | 1538.76
 | 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 | 679.24 | 679.24 | 679.24 | 679.24 | 679.24 | 679.24 | 679.24
 | Fort Worth Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4790.29 | 4790.29 | 4790.29 | 4790.29 | 4790.29
 | Friends (Ship to TX) |  |  |  |  |  |  |  |  |  |  | 458.21 | 458.21 | 458.21 | 458.21 | 458.21 | 458.21 | 458.21 | 458.21
 | Gemini Cut Glass Company Inc |  |  |  | 0 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824 | 4824
 | 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 | 1448.655 | 1503.59 | 1503.59 | 1503.59 | 1503.59
 | Green Electrical Solutions | 4634.84 | 4634.84 | 4634.84 | 4634.84 | 4634.84 | 4634.84 | 4012.84 | 4012.84 | 4012.84 | 4012.84 | 3527.84 | 1203.84 | 1203.84 | 1203.84 | 1203.84 | 1203.84 | 1203.84 | 1203.84
 | Hays Electrical Services Inc. | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 14979.09 | 9019.66 | 9019.66 | 9019.66 | 9019.66 | 0 | 0 | 0 | 0
 | Hermitage Electric Supply | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88 | 2212.88
 | High Tech Applications | 2023.5 | 2023.5 | 23667 | 24276.25 | 25206.25 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 25139.5 | 23116 | 27640.7
 | 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 | 36164.31 | 36164.31 | 34267.81 | 34267.81 | 34267.81 | 34267.81 | 25034.28 | 24009.32 | 24717.82 | 25870.73 | 27090.73 | 27090.73 | 33898.66 | 33898.66 | 33898.66 | 33898.66 | 18000.67 | 18870.17
 | Interiors by [NAME] (Space by Rbi) | 3131 | 1132.5 | 1132.5 | 1132.5 | 1132.5 | 1132.5 | 1132.5 | 378 | 378 | 378 | 378
 | Jackson Lighting Supply | 0 | 0 | 0 | 0 | 0
 | [NAME] | 419.77 | 419.77 | 419.77 | 0 | 331.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5 | 3663.5
 | [NAME] | 1991 | 3591.91 | 3591.91 | 3591.91 | 3591.91 | 3591.91 | 3591.91 | 3591.91 | 5034.91 | 5034.91 | 5034.91 | 5034.91 | 5034.91 | 5034.91 | 5034.91 | 5034.91 | 5034.91 | 6066.79
 | Just Led + Lights | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | JW Sales | 32312.86 | 32312.86 | 32312.86 | 32312.86 | 32312.86 | 32312.86 | 32602.86 | 43113.96 | 43113.96 | 43113.96 | 43113.96 | 43113.96 | 44546.38999999999 | 44546.38999999999 | 44546.38999999999 | 44546.38999999999 | 44546.38999999999 | 44546.38999999999
 | 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 | 9032 | 9032 | 11532.5 | 11532.5 | 11532.5 | 11532.5 | 11532.5 | 11532.5 | 11532.5 | 11532.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5
 | Langlais Group | 5026 | 6071.5 | 6243.5 | 6243.5 | 6243.5 | 6243.5 | 6243.5 | 5088 | 5088 | 6307.5 | 6307.5 | 6307.5 | 6307.5 | 6307.5 | 6465.45 | 4769.45 | 2594.95 | 2594.95
 | LEDI Internal Use Only |  |  |  |  | 483.23 | 2146.84 | 2146.84 | 1917.405 | 1917.405 | 1917.405 | 1917.405 | 1917.405 | 1917.405 | 1917.405 | 1917.405 | 1917.405 | 2448.025 | 2448.025
 | Legend Lighting | 10369 | 12086 | 12086 | 12086 | 12086 | 12086 | 12086 | 12086 | 12086 | 12086 | 9049 | 19271.5 | 19271.5 | 18608.5 | 18406 | 12179 | 12179 | 12179
 | Lido Lighting - Hauppauge, NY | 0
 | LIGHT Company - Houston, TX | 6688.89 | 9422.61 | 9422.61 | 9422.61 | 7454.110000000001 | 7454.110000000001 | 9207.79 | 28457.25 | 29358.55 | 29358.55 | 29358.55 | 29358.55 | 29358.55 | 29358.55 | 31460.5 | 31460.5 | 31460.5 | 31460.5
 | Lighting Concepts | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72 | 408.72
 | 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 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 2169.03 | 3558.64 | 3558.64 | 3558.64
 | 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 | 6868.23 | 6868.23 | 6868.23 | 6868.23 | 6868.23 | 6868.23 | 6868.23 | 9552.59 | 9552.59
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Houston, TX | 30885.7 | 30885.7 | 30885.7 | 30885.7 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Lewisville, TX |  |  |  |  | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 152.62 | 1537.24 | 1537.24 | 1537.24
 | Lights Fantastic Pro - Dallas, TX | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36 | 1816.36
 | 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 | 179.45 | 179.45 | 179.45 | 179.45
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Austin | 2303.04 | 2303.04 | 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 | 1096.3 | 1096.3 | 1096.3 | 1096.3 | 1096.3 | 1096.3 | 1096.3 | 1096.3 | 1096.3
 | 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 | 10020.36 | 10020.36 | 10477.24 | 10477.24 | 10477.24 | 11406.86 | 11406.86 | 11406.86 | 11406.86 | 10839.36 | 12100.755 | 3109.655 | 3109.655 | 3109.655 | 3109.655 | 3109.655 | 3109.655 | 3109.655
 | Lux Lighting Design - Belmont, MA | 1209.7 | 1209.7 | 3742.7 | 3153.5 | 3153.5 | 3153.5 | 3153.5 | 3153.5 | 3921 | 3921 | 3921 | 3921 | 3921 | 4260 | 4192 | 4192 | 4192 | 4030.5
 | M&M - IUO | 277.65 | 277.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0
 | M&M - IUO : M&M Lighting - Direct | 17260.74 | 17260.74 | 17260.74 | 17260.74 | 17260.74 | 17260.74 | 17260.74 | 17260.74 | 18167.58 | 18167.58 | 18167.58 | 18167.58 | 18167.58 | 18167.58 | 18480 | 3533.32 | 3533.32 | 3533.32
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc- TX | 9607.34 | 10538.76 | 10538.76 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 13305.02 | 5994.68 | 5085.68 | 5085.68
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc. CT ([NAME]) | 4288.96 | 4288.96 | 4288.96 | 4288.96 | 4288.96 | 4288.96 | 5448.38 | 2443.96 | 2443.96 | 2338.96 | 2338.96 | 1759.31 | 1759.31 | 1574.81 | 1824.62 | 1824.62 | 1824.62 | 1824.62
 | Marsh Sales | 9317.81 | 9317.81 | 9317.81 | 9317.81 | 9317.81 | 9317.81 | 9317.81 | 9317.81 | 9317.81 | 7422.67 | 9746.67 | 9746.67 | 9746.67 | 9746.67 | 9746.67 | 9746.67 | 22945.18 | 24281.08
 | Mayer Electric Supply - Charlotte, NC | 977.78 | 977.78 | 2221.28 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5 | 1243.5
 | 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 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685 | 685
 | MSRP | 4962.62 | 4962.62 | 4962.62 | 4962.62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | No Limit Lighting Sales | 284 | 284 | 284 | 284 | 284 | 284 | 284 | 1229.5 | 1229.5 | 1229.5 | 1229.5 | 1229.5 | 1229.5 | 1229.5 | 1475 | 1475 | 1475 | 1475
 | North Coast Electric - IUO : North Coast Electric - Bellevue, WA | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 1881.09 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | North Coast Electric - IUO : North Coast Electric - Kent, WA |  |  | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54 | 4852.54
 | North Coast Electric - IUO : North Coast Electric - Seattle, WA |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Omega Construction & Wine Rooms |  |  |  | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72 | 34242.72
 | ParamontEO | 0 | 7504.3 | 7504.3 | 7504.3 | 7504.3 | 7504.3 | 7504.3 | 7504.3 | 7504.3 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001 | 9691.720000000001
 | PDI Plumbing Distributors Inc | 9117.67 | 9117.67 | 9117.67 | 9117.67 | 9117.67 | 9117.67 | 9117.67 | 9117.67 | 9117.67 | 3517.17 | 1387.5 | 1387.5 | 1387.5 | 1387.5 | 1387.5 | 1387.5 | 1387.5 | 1387.5
 | Platt Electric Supply | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26 | 3019.26
 | Premier Technology Group | 2679.34 | 2679.34 | 2679.34 | 2679.34 | 2679.34 | 2679.34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 3954.5 | 3954.5 | 3954.5 | 3954.5 | 3954.5 | 3954.5
 | 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 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 4780.66 | 1846 | 1846 | 1846 | 1846 | 1379 | 1379
 | 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] | 32407.6 | 32407.6 | 32676.1 | 32676.1 | 32676.1 | 32676.1 | 46397.707 | 45483.04 | 45483.04 | 45774.04 | 51736.04 | 51342.04 | 51219.04 | 60723.873 | 60668.373 | 62316.473 | 45671.773 | 45671.773
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2967.79
 | 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 | 2755.75 | 2755.75 | 2755.75 | 2755.75 | 2755.75 | 2755.75 | 2755.75 | 2755.75
 | Southeast Florida Lighting | 2943.48 | 2943.48 | 2943.48 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98 | 3319.98
 | Springfield Electric - IUO : Springfield Electric - Springfield, IL |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1614.79 | 1614.79 | 1614.79 | 1614.79 | 1614.79 | 1614.79 | 1614.79 | 1614.79 | 1614.79 | 1614.79
 | State Electric Supply - IUO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | State Electric Supply - IUO : State Electric Supply Company - Huntington, WV | 5752 | 5752 | 5752 | 5752 | 5752 | 5752 | 5752 | 5752
 | State Electric Supply - IUO : State Electric Supply Company - Raleigh, NC | 2215.92 | 2215.92 | 2215.92 |  |  |  |  |  |  |  |  |  |  |  | 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 | 682.85 | 682.85 | 682.85 | 682.85 | 682.85 | 682.85 | 682.85 | 682.85 | 682.85
 | The Armored Frog | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23 | 3091.23
 | The Light House Gallery | 3365.77 | 3365.77 | 3365.77 | 3365.77 | 3365.77 | 3365.77
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1054.5 | 1054.5 | 1054.5 | 1054.5 | 1054.5 | 1054.5 | 1054.5 | 1054.5 | 1054.5 | 1054.5
 | Turtle & Hughes - IUO |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | United Electric Supply - Langhorne, PA | 1191.5 | 1610.5 | 1610.5 | 1610.5 | 1610.5 | 1962 | 1962 | 2490 | 2490 | 2490 | 2490 | 1298.5 | 1298.5 | 1298.5 | 1298.5 | 1298.5 | 1298.5 | 1298.5
 | Villa Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4685.200000000001 | 6158.6 | 6158.6 | 8437.6 | 9073.599999999999 | 9073.599999999999 | 9603.599999999999 | 9603.599999999999 | 12158.2 | 14988.4 | 18613.6
 | 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 | 1192.37 | 1192.37 | 1192.37 | 1192.37 | 1192.37 | 1192.37 | 1192.37 | 1192.37 | 1192.37
 | WESCO  Distribution - Kingsport, TN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2595.92 | 2595.92 | 2595.92 | 2595.92 | 2595.92 | 2595.92 | 2595.92
 | 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 | 370.79 | 370.79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 5956.02 | 5956.02 | 5956.02 | 0 | 0 | 0 | 0 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352
 | Wilson Lighting - IUO : Wilson Lighting - Naples, FL | 5718.450000000001 | 5718.450000000001 | 1301.98 | 1301.98 | 933 | 933 | 933 | 933 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Wilson Lighting - IUO : WIlson Lighting-Clayton | 266.5 | 266.5 | 266.5 | 266.5 | 266.5
 | [NAME] : Broken Arrow Electric | 0 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384 | 384
 | World Electric Supply | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0