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

 | AVG AMOUNT WON (CUSTOMERS)
 | OVERALL TOTALS | 3081.806349206349 | 3208.120307692308 | 3367.095544554456 | 3507.53202970297 | 3361.548829268293 | 3297.212966507177 | 3314.720328638498 | 3481.052242990655 | 3465.608909090909 | 3450.687633928571 | 3381.434224137931 | 3343.235652173913 | 3358.897685589519 | 3464.136186440678 | 3593.129382716049 | 3455.272406639004 | 3363.794345991561 | 3349.709385245902
 | 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 | 4225.445 | 4225.445 | 4225.445 | 4225.445 | 4225.445 | 8087.89 | 8087.89 | 8087.89 | 8087.89 | 6057.715 | 6057.715 | 6057.715 | 6057.715 | 6057.715 | 6057.715 | 6057.715 | 6057.715 | 6057.715
 | 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 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999 | 916.4649999999999
 | Bell & McCoy Austin | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1586.028 | 1580.8174 | 1646.91675 | 1713.125 | 1713.125 | 1597.5 | 1542.5 | 1542.5 | 1542.5
 | Bell & McCoy Farmers Branch | 2266.77125 | 2410.625714285714 | 2319.375714285714 | 2319.375714285714 | 2666.826666666666 | 2666.826666666666 | 2666.826666666666 | 2664.7295 | 2690.7754 | 2690.7754 | 2529.396166666667 | 2037.8754 | 2037.8754 | 1840.396166666667 | 1840.396166666667 | 1053.9034 | 988.7700000000001 | 988.7700000000001
 | Bell & McCoy Houston | 2432.487916666667 | 2432.487916666667 | 2439.477916666667 | 2597.579545454545 | 2343.814090909091 | 2160.458076923077 | 2477.9615 | 2290.188636363636 | 2853.75625 | 2853.75625 | 2969.172916666666 | 2730.162499999999 | 2778.535769230769 | 3628.731 | 3127.096277777778 | 3216.6395625 | 3070.89605882353 | 3070.89605882353
 | 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 | 9825.22 | 9825.22 | 6724.776666666668 | 5571.2075 | 5571.2075 | 5571.2075
 | Bell & McCoy Louisiana | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 469.84 | 469.84 | 469.84 | 469.84 | 469.84 | 39518.42 | 39518.42 | 39518.42 | 39518.42
 | Bell & McCoy Mississippi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bell & McCoy Oklahoma | 7812.585833333334 | 9475.386923076921 | 9475.386923076921 | 9065.716428571428 | 9065.716428571428 | 9065.716428571428 | 9065.716428571428 | 10303.18714285714 | 9954.374666666667 | 9954.374666666667 | 9563.543125 | 9239.812666666667 | 9700.637692307691 | 10994.05142857143 | 10377.97133333333 | 10089.725 | 10272.67733333333 | 9420.742941176472
 | Bell & McCoy San Antonio | 0 | 0 | 15580.45 | 15580.45 | 9398.725 | 7809.316666666667 | 7809.316666666667 | 7809.316666666667 | 6515.1575 | 6740.0325 | 6740.0325 | 6740.0325 | 6740.0325 | 6740.0325 | 6740.0325 | 6740.0325 | 7443.21 | 7443.21
 | 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] | 219.495 | 195.5 | 195.5 | 195.5 |  | 0 | 3593.5 | 3593.5 | 3593.5 | 3593.5 | 3593.5 | 3593.5 | 2446.75 | 2474.333333333333 | 2426.833333333333 | 2426.833333333333 | 2426.833333333333 | 2426.833333333333
 | [NAME] : Bliss Lighting | 1096.15 | 568.99 | 568.99 | 504.6583333333333 | 504.6583333333333 | 504.6583333333333 | 601.9928571428571 | 601.9928571428571 | 601.9928571428571 | 601.9928571428571 | 619.80625 | 619.80625 | 619.80625 | 619.80625 | 617.7071428571428 | 617.7071428571428 | 617.7071428571428 | 630.9083333333333
 | California Electric Supply |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | California Lighting Sales | 1882.0658 | 1973.051214285714 | 2002.1355 | 2002.1355 | 2219.2598 | 2371.4623125 | 2416.2065 | 2197.944277777777 | 2188.347055555555 | 2226.455705882353 | 2065.552210526316 | 2033.717473684211 | 1738.436421052632 | 1640.442476190476 | 1631.263272727272 | 1563.273565217391 | 1601.823095238095 | 1613.869090909091
 | 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 | 682.8199999999999 | 682.8199999999999 | 682.8199999999999 | 682.8199999999999 | 682.8199999999999
 | 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 | 3643.833333333333 | 3643.833333333333 | 3643.833333333333 | 3643.833333333333 | 3218.7 | 3155.5 | 2669.932 | 2191.165 | 2191.165 | 2191.165 | 3994.782 | 3584.985 | 3584.985 | 3584.985 | 3584.985 | 3584.985 | 3584.985 | 3584.985
 | 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 | 1830.1375 | 1830.1375 | 1830.1375 | 1830.1375 | 1830.1375 | 1830.1375 | 1830.1375 | 1830.1375 | 1830.1375 | 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 | 1932.48 | 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 | 1158.71 | 1158.71 | 1158.71 | 1158.71 | 1158.71 | 1158.71 | 1337.613333333333 | 1337.613333333333 | 1337.613333333333 | 1337.613333333333 | 1763.92 | 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 | 11833.5 | 8092.083333333333 | 6301.5625 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 6284.875 | 7705.333333333333 | 6910.175
 | 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 | 4520.53875 | 4520.53875 | 4283.47625 | 4283.47625 | 4283.47625 | 4283.47625 | 3129.284999999999 | 3429.902857142857 | 3531.117142857142 | 3233.84125 | 3010.081111111111 | 3010.081111111111 | 3766.517777777777 | 3766.517777777777 | 3766.517777777777 | 3766.517777777777 | 2250.08375 | 2096.685555555555
 | Interiors by [NAME] (Space by Rbi) | 1043.666666666667 | 566.25 | 566.25 | 566.25 | 566.25 | 566.25 | 566.25 | 378 | 378 | 378 | 378
 | Jackson Lighting Supply | 0 | 0 | 0 | 0 | 0
 | [NAME] | 419.77 | 419.77 | 419.77 | 0 | 331.5 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75 | 1831.75
 | [NAME] | 1991 | 1795.955 | 1795.955 | 1795.955 | 1795.955 | 1795.955 | 1795.955 | 1795.955 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1678.303333333333 | 1516.6975
 | Just Led + Lights | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | JW Sales | 8078.215 | 8078.215 | 8078.215 | 8078.215 | 8078.215 | 8078.215 | 6520.572 | 7185.66 | 7185.66 | 7185.66 | 7185.66 | 7185.66 | 6363.769999999999 | 6363.769999999999 | 6363.769999999999 | 6363.769999999999 | 6363.769999999999 | 6363.769999999999
 | 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 | 5766.25 | 5766.25 | 5766.25 | 5766.25 | 5766.25 | 5766.25 | 5766.25 | 5766.25 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5 | 2500.5
 | Langlais Group | 1675.333333333333 | 1517.875 | 1248.7 | 1248.7 | 1248.7 | 1248.7 | 1248.7 | 1272 | 1272 | 1261.5 | 1261.5 | 1261.5 | 1261.5 | 1261.5 | 1077.575 | 953.89 | 648.7375 | 648.7375
 | LEDI Internal Use Only |  |  |  |  | 483.23 | 1073.42 | 1073.42 | 958.7025 | 958.7025 | 958.7025 | 958.7025 | 958.7025 | 958.7025 | 958.7025 | 958.7025 | 958.7025 | 816.0083333333333 | 816.0083333333333
 | Legend Lighting | 2073.8 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 2014.333333333333 | 1809.8 | 3211.916666666667 | 3211.916666666667 | 3721.7 | 4601.5 | 4059.666666666667 | 4059.666666666667 | 4059.666666666667
 | Lido Lighting - Hauppauge, NY | 0
 | LIGHT Company - Houston, TX | 3344.445 | 3140.87 | 3140.87 | 3140.87 | 3727.055 | 3727.055 | 3069.263333333334 | 7114.3125 | 5871.71 | 5871.71 | 5871.71 | 5871.71 | 5871.71 | 5871.71 | 5243.416666666667 | 5243.416666666667 | 5243.416666666667 | 5243.416666666667
 | 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 | 1779.32 | 1779.32 | 1779.32
 | 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 | 4776.295 | 4776.295
 | 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 | 768.6199999999999 | 768.6199999999999 | 768.6199999999999
 | 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 | 3340.12 | 3340.12 | 2619.31 | 2619.31 | 2619.31 | 2281.372 | 2281.372 | 2281.372 | 2281.372 | 2709.84 | 3025.18875 | 1036.551666666667 | 1036.551666666667 | 1036.551666666667 | 1036.551666666667 | 1036.551666666667 | 1036.551666666667 | 1036.551666666667
 | Lux Lighting Design - Belmont, MA | 403.2333333333333 | 403.2333333333333 | 748.54 | 788.375 | 788.375 | 788.375 | 788.375 | 788.375 | 980.25 | 980.25 | 980.25 | 980.25 | 980.25 | 852 | 838.4 | 838.4 | 838.4 | 1007.625
 | M&M - IUO | 277.65 | 277.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0
 | M&M - IUO : M&M Lighting - Direct | 4315.185 | 4315.185 | 4315.185 | 4315.185 | 4315.185 | 4315.185 | 4315.185 | 4315.185 | 3633.516000000001 | 3633.516000000001 | 3633.516000000001 | 3633.516000000001 | 3633.516000000001 | 3633.516000000001 | 3080 | 706.664 | 706.664 | 706.664
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc- TX | 3202.446666666667 | 2634.69 | 2634.69 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 2661.004 | 1498.67 | 1695.226666666667 | 1695.226666666667
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc. CT ([NAME]) | 612.7085714285714 | 612.7085714285714 | 612.7085714285714 | 612.7085714285714 | 612.7085714285714 | 612.7085714285714 | 605.3755555555556 | 407.3266666666667 | 407.3266666666667 | 467.792 | 467.792 | 439.8275 | 439.8275 | 524.9366666666666 | 456.155 | 456.155 | 456.155 | 456.155
 | Marsh Sales | 4658.905 | 4658.905 | 4658.905 | 4658.905 | 4658.905 | 4658.905 | 4658.905 | 4658.905 | 4658.905 | 7422.67 | 4873.335 | 4873.335 | 4873.335 | 4873.335 | 4873.335 | 4873.335 | 7648.393333333333 | 8093.693333333334
 | Mayer Electric Supply - Charlotte, NC | 977.78 | 977.78 | 1110.64 | 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 | 614.75 | 614.75 | 614.75 | 614.75 | 614.75 | 614.75 | 614.75 | 491.6666666666667 | 491.6666666666667 | 491.6666666666667 | 491.6666666666667
 | 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 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001 | 4845.860000000001
 | PDI Plumbing Distributors Inc | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 3039.223333333333 | 1172.39 | 693.75 | 693.75 | 693.75 | 693.75 | 693.75 | 693.75 | 693.75 | 693.75
 | 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 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 1195.165 | 615.3333333333334 | 615.3333333333334 | 615.3333333333334 | 615.3333333333334 | 689.5 | 689.5
 | 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] | 2946.145454545455 | 2946.145454545455 | 2723.008333333334 | 2723.008333333334 | 2723.008333333334 | 2723.008333333334 | 3093.180466666667 | 3032.202666666667 | 3032.202666666667 | 2860.8775 | 3043.296470588235 | 3208.8775 | 3414.602666666667 | 4048.2582 | 4333.455214285715 | 5193.039416666667 | 4151.979363636364 | 4151.979363636364
 | [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 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99 | 1659.99
 | Springfield Electric - IUO : Springfield Electric - Springfield, IL |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 807.395 | 807.395 | 807.395 | 807.395 | 807.395 | 807.395 | 807.395 | 807.395 | 807.395 | 807.395
 | 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 | 805.25 | 805.25 | 805.25 | 805.25 | 654 | 654 | 622.5 | 622.5 | 622.5 | 622.5 | 432.8333333333333 | 432.8333333333333 | 432.8333333333333 | 432.8333333333333 | 432.8333333333333 | 432.8333333333333 | 432.8333333333333
 | Villa Lighting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1561.733333333334 | 1539.65 | 1539.65 | 1406.266666666667 | 1296.228571428571 | 1296.228571428571 | 1200.45 | 1200.45 | 1215.82 | 1152.953846153846 | 1163.35
 | 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 | 1906.15 | 1906.15 | 650.99 | 650.99 | 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