Spreadsheet: 274007d1382980793-concatenate-help-please-help
Sheet: Floor Sales Chart

SUMIF('Excel Data Only'!B:B,'Casino Floor Sales Chart'!D7,'Excel Data Only'!F:F) | Cocktail Server Alcohol Sales Chart
 | Sales for Branfman, [NAME]) Total Sales | Sales Summary | Total Sales
 |  |  |  | Week of 9/30/13-10/6/13 |  |  |  |  |  |  | 2013-09-01 00:00:00 |  |  |  | 2013-10-01 00:00:00 |  |  |  | 2013-11-01 00:00:00 |  |  |  |  | 2013-12-01 00:00:00
 |  |  |  | DAY SHIFT
 | Team Member | EID | UID | Total Weekly Sales | # of Hours Worked | Average Sales Per Hour |  | October Average |  |  | WE 9/8 | WE 9/15 | WE 9/22 | WE 9/29 | WE 10/6 | WE 10/13 | WE 10/20 | WE 10/27 | WE 11/3 | WE 11/10 | WE 11/17 | WE 11/24 | WE 12/1 | WE 12/8 | WE 12/15 | WE 12/22 | WE 12/29
 | [NAME] |  |  |  | 31.75 |  |  |  |  |  | - | 9.32 | 15.88342857142857 | 14.65460869565218 | 16.69133858267717
 | [NAME] |  |  |  | 38.75 |  |  |  |  |  | 10.82311111111111 | 12.20754716981132 | 9.663404255319149 | 16.81 | 12.81522580645161
 | [NAME] |  |  |  | 23.75 |  |  |  |  |  | 16.52368421052632 | 12.24258064516129 | 16.43806451612903 | 15.80514285714286 | 12.58484210526316
 | [NAME] |  |  |  | 32.5 |  |  |  |  |  | - | 8.940437956204377 | 9.470645161290323 | 11.33066666666667 | 12.54584615384615
 | [NAME] |  |  |  | 27.75 |  |  |  |  |  | - | - | 16.7659842519685 | 11.73536 | 11.92972972972973
 | Blanca Rodriguez |  |  |  | 32.5 |  |  |  |  |  | 13.53565217391305 | 13.32952380952381 | 7.833459119496855 | 10.88984126984127 | 11.55661538461538
 | [NAME] |  |  |  | 23.5 |  |  |  |  |  | 10.94273381294964 | 7.600967741935484 | 24.89766666666667 | 9.72103896103896 | 9.953617021276594
 | [NAME] |  |  |  | 26 |  |  |  |  |  | 12.03320754716981 | 14.4263768115942 | 12.00441379310345 | 10.64061302681992 | 8.219230769230771
 | [NAME] |  |  |  | 34.5 |  |  |  |  |  | 8.512200000000002 | 8.807441860465117 | 8.250238095238094 | 8.092631578947367 | 8.174202898550725
 | [NAME] |  |  |  | 0 |  |  | 0 |  |  | 17.558125 | 17.6188679245283 | 14.16063492063492 | 8.415873015873014 | -
 | [NAME] |  |  |  | 0 |  |  | 0 |  |  | - | - | - | - | -
 |  |  |  | MID SHIFT
 | Team Member |  |  | Total Weekly Sales | # of Hours Worked | Average Sales Per Hour |  |  |  |  | WE 9/8 | WE 9/15 | WE 9/22 | WE 9/29 | WE 10/6 | WE 10/13 | WE 10/20 | WE 10/27 | WE 11/3 | WE 11/10 | WE 11/17 | WE 11/24 | WE 12/1 | WE 12/8 | WE 12/15 | WE 12/22 | WE 12/29
 | Christie Barbera |  |  |  | 15.5 |  |  |  |  |  | 18.99410526315789 | 22.27566265060241 | 26.47015384615385 | 23.42792452830189 | 24.44774193548387
 | [NAME] |  |  |  | 27.5 |  |  |  |  |  | 20.50875 | 19.36430107526882 | 23.03146666666667 | 22.16052631578947 | 23.36509090909091
 | Soraya DeRolon |  |  |  | 39.5 |  |  |  |  |  | 18.90980392156863 | 20.6620979020979 | 17.65723577235773 | 15.43076923076923 | 20.00278481012658
 | [NAME] |  |  |  | 38.5 |  |  |  |  |  | 15.29457142857143 | 14.05542483660131 | 22.55577235772358 | 16.7392700729927 | 18.28259740259741
 | [NAME] |  |  |  | 26.25 |  |  |  |  |  | 21.11478260869565 | 15.01076923076923 | 19.92745098039216 | 16.2925 | 18.28228571428572
 | [NAME] |  |  |  | 36.5 |  |  |  |  |  | 22.48888888888889 | 15.80645962732919 | 17.24186528497409 | 18.45066666666667 | 15.81890410958904
 | [NAME] |  |  |  |  |  |  |  |  |  | - | - | 22.97791044776119 | 10.10486486486487 | 13.67846153846154
 | [NAME] |  |  |  | 22.5 |  |  |  |  |  | - | - | 18.72 | 15.88748201438849 | 12.58044444444444
 | Genesis [NAME] |  |  |  | 23.5 |  |  | 0 |  |  | 26.91483870967742 | 15.07531914893617 | 20.09914893617021 | - | -
 |  |  |  | SWING SHIFT
 | Team Member |  |  | Total Weekly Sales | # of Hours Worked | Average Sales Per Hour |  |  |  |  | WE 9/8 | WE 9/15 | WE 9/22 | WE 9/29 | WE 10/6 | WE 10/13 | WE 10/20 | WE 10/27 | WE 11/3 | WE 11/10 | WE 11/17 | WE 11/24 | WE 12/1 | WE 12/8 | WE 12/15 | WE 12/22 | WE 12/29
 | [NAME] |  |  |  | 31.5 |  |  |  |  |  | 26.01482758620689 | 26.83367088607595 | 36.41443298969072 | 25.47962264150944 | 34.92476190476191
 | [NAME] |  |  |  | 30.25 |  |  |  |  |  | 20.8009756097561 | 14.60808510638298 | 21.96033333333333 | 20.39967741935483 | 26.00925619834711
 | [NAME] |  |  |  | 37.5 |  |  |  |  |  | 25.66569343065693 | 18.54285714285714 | 14.35130434782609 | 31.23911111111111 | 25.75093333333334
 | [NAME] |  |  |  | 25.25 |  |  |  |  |  | 32.60403361344538 | 19.59388535031847 | 28.2174358974359 | 23.07621621621621 | 25.21346534653465
 | Bianca [NAME] |  |  |  | 40 |  |  |  |  |  | 18.48066115702479 | 19.88639175257732 | 19.53272727272727 | 17.9118407960199 | 23.57575
 | [NAME] |  |  |  | 21.5 |  |  |  |  |  | 18.55085714285714 | 31.5131914893617 | 23.02434782608696 | 31.23483870967742 | 22.7046511627907
 | [NAME] |  |  |  | 32.25 |  |  |  |  |  | 20.30841121495327 | 26.6128 | 27.89557251908397 | 20.93882352941177 | 22.21798449612403
 | Sarat [NAME] |  |  |  | 38 |  |  |  |  |  | 23.66181818181818 | 28.12677595628416 | 23.55834482758621 | 22.46554838709678 | 21.22236842105263
 | [NAME] |  |  |  | 27.25 |  |  |  |  |  | 33.69244444444445 | 22.23032967032967 | 19.68744186046511 | 22.51180327868853 | 18.7456880733945
 | [NAME] |  |  |  | 38.25 |  |  |  |  |  | 18.99380952380952 | 14.78622950819672 | 15.83946308724832 | 15.23350649350649 | 17.00183006535947
 | [NAME] |  |  |  | 30.75 |  |  |  |  |  | - | 30.21753424657534 | 24.5229197080292 | 34.28088888888889 | 16.31544715447155
 |  |  |  | LATE SWING SHIFT
 | Team Member |  |  | Total Weekly Sales | # of Hours Worked | Average Sales Per Hour |  |  |  |  | WE 9/8 | WE 9/15 | WE 9/22 | WE 9/29 | WE 10/6 | WE 10/13 | WE 10/20 | WE 10/27 | WE 11/3 | WE 11/10 | WE 11/17 | WE 11/24 | WE 12/1 | WE 12/8 | WE 12/15 | WE 12/22 | WE 12/29
 | Christina Favata |  |  |  | 7 |  |  |  |  |  | 66.75111111111111 | 39.98 | 3.230769230769231 | 47.088 | 49.86571428571428
 | [NAME] |  |  |  | 23.5 |  |  |  |  |  | 25.14424242424243 | 38.74568421052632 | 16.05217391304348 | 40.26054054054055 | 40.75702127659574
 | [NAME] |  |  |  | 40.25 |  |  |  |  |  | 40.65223529411765 | 57.19624999999999 | 46.94491228070176 | 44.25189189189189 | 39.74956521739131
 | [NAME] |  |  |  | 23 |  |  |  |  |  | 23.68111111111111 | 27.96767676767677 | 23.92262295081967 | 21.31917808219178 | 33.87739130434783
 | [NAME] |  |  |  | 24 |  |  |  |  |  | 28.868 | 26.04288659793814 | 24.3812 | 29.72375000000001 | 30.33
 | [NAME] |  |  |  | 21 |  |  |  |  |  | 20.10021978021978 | 25.42196721311475 | 19.87888888888889 | 30.37213483146068 | 28.74095238095238
 | Lanai Barreto |  |  |  |  |  |  |  |  |  | 17.87580645161291 | 31.06849315068493 | 30.65209302325581 | 38.09951219512195 | 28.64848484848485
 | [NAME] |  |  |  | 18.75 |  |  |  |  |  | - | 24.8224 | 23.559 | 21.94285714285714 | 25.9472
 | [NAME] |  |  |  | 24.25 |  |  |  |  |  |  |  |  |  | 25.54226804123711
 | [NAME] |  |  |  | 33.25 |  |  |  |  |  | 16.452 | 25.77426086956522 | 19.54246153846154 | 14.17692307692308 | 21.06977443609023
 | [NAME] |  |  |  | 30.75 |  |  |  |  |  | 21.48830188679246 | 18.88217054263566 | 23.69051282051282 | 31.81777777777778 | 20.46861788617887
 | [NAME] |  |  |  | 19.25 |  |  |  |  |  | 19.07641791044776 | 19.48582524271844 | 21.59041666666667 | 23.48394366197183 | 19.84727272727272
 | Linette Rodriguez |  |  |  | 25.25 |  |  |  |  |  | 26.40785714285715 | 26.95922330097087 | 20.47309090909091 | 20.59702127659574 | 18.8170297029703
 | Elissa Hawley |  |  |  |  |  |  |  |  |  | 13.50255319148936 | 23.53255474452555 | 15.76535433070866 | 13.02644067796611 | 16.12125
 | Ebony [NAME] |  |  |  | 25 |  |  |  |  |  | 20.9130909090909 | 30.16378947368421 | 21.47827586206897 | 17.63047619047619 | 15.8508
 | [NAME] |  |  |  | 21.5 |  |  |  |  |  | - | - | - | - | 11.86976744186047
 | [NAME] |  |  |  | 0 |  |  | 0 |  |  | 25.49622641509434 | 27.22415841584159 | 17.69203883495146 | 25.53243697478991 | -
 |  |  |  | GRAVE SHIFT
 | Team Member |  |  | Total Weekly Sales | # of Hours Worked | Average Sales Per Hour |  |  |  |  | WE 9/8 | WE 9/15 | WE 9/22 | WE 9/29 | WE 10/6 | WE 10/13 | WE 10/20 | WE 10/27 | WE 11/3 | WE 11/10 | WE 11/17 | WE 11/24 | WE 12/1 | WE 12/8 | WE 12/15 | WE 12/22 | WE 12/29
 | [NAME] |  |  |  | 32 |  |  |  |  |  | 36.65896551724138 | 46.30117647058824 | 44.39086956521739 | 28.28072727272727 | 30.1496875
 | [NAME] |  |  |  | 46 |  |  |  |  |  | 22.98876712328767 | 15.70012903225807 | 18.03807692307692 | 22.81836477987421 | 23.0854347826087
 | [NAME] |  | Sales for Branfman, [NAME]) Total Sales |  | 30.5 |  |  |  |  |  | 21.10414414414414 | 78.185 | 23.44818897637795 | 22.2595918367347 | 19.38065573770491
 | [NAME] |  |  |  | 27.75 |  |  |  |  |  | 17.35286821705427 | 22.565625 | 21.73157024793388 | 24.12958333333333 | 19.16828828828829
 | [NAME] |  |  |  | 26.25 |  |  |  |  |  | 24.36094488188976 | 36.70148760330579 | 30.6921052631579 | 37.91101123595506 | 18.2392380952381
 | Tatiana Piazza |  |  |  | 24.5 |  |  |  |  |  | 14.28065573770492 | - | - | 14.88 | 17.22612244897959
 | [NAME] |  |  |  | 29.75 |  |  |  |  |  | 10.73875 | 20.50730158730159 | 21.94713043478261 | 17.338125 | 14.28773109243697
 | [NAME] |  |  |  | 30 |  |  |  |  |  | - | - | - | - | 12.827
 | [NAME] |  |  |  | 28.5 |  |  |  |  |  | 14.99052631578947 | 13.12910569105691 | 22.53016949152542 | 16.47596899224806 | 12.16561403508772
 |  |  |  | POKER SERVERS
 | Team Member |  |  | Total Weekly Sales | # of Hours Worked | Average Sales Per Hour |  |  |  |  | WE 9/8 | WE 9/15 | WE 9/22 | WE 9/29 | WE 10/6 | WE 10/13 | WE 10/20 | WE 10/27 | WE 11/3 | WE 11/10 | WE 11/17 | WE 11/24 | WE 12/1 | WE 12/8 | WE 12/15 | WE 12/22 | WE 12/29
 | [NAME] |  |  |  |  |  |  |  |  |  | 32.26322580645162 | 37.74967741935485 | 32.09677419354838 | 20.07384615384616 | 34.90819672131147
 | [NAME] |  |  |  |  |  |  |  |  |  | 14.76188235294117 | 20.05179487179487 | 33.95220779220779 | 29.10246575342466 | 30.14582278481013
 | [NAME] |  |  |  |  |  |  |  |  |  | 31.30702702702703 | 26.80956521739131 | 24.97705882352941 | 29.2332075471698 | 25.54
 | Tasheka Morgan |  |  |  |  |  |  |  |  |  | 18.08529411764706 | 15.71183673469388 | 13.49416666666667 | 13.53152542372881 | 22.849
 | [NAME] |  |  |  |  |  |  |  |  |  | 14.80433734939759 | 23.25393258426967 | 19.40578313253012 | 19.06232558139535 | 21.3663829787234
 | [NAME] |  |  |  |  |  |  |  |  |  | 4.666341463414636 | 11.64733333333333 | 12.86418604651163 | 15.24597014925373 | 17.39422680412371
 | [NAME] |  |  |  | 0 |  |  | 0 |  |  | 13.58563106796117 | 12.0663829787234 | 14.02814814814815 | 21.43711340206186 | -
 | Keep up the good work and remember [NAME], [NAME], [NAME]!!!!!