Hi All,
I'm measuring the amount of visits each employee visits one of our internal buildings. I'm attempting to do a fairly easy distinct count based on 3 criteria (date, building and staff ID). The powerpivot pivot table output shows the persons meta data (manager, org, assigned building) and in the values it show how many times they visited a given building by month(as you can see below). The values (visits) are taking up multiple columns, but I want to show only the average number of hits (average of each month) as 1 column. The average should check to see if the building they visited also matches the building they are assigned. Would also love a rolling 3 or 6 month average also.
I have the following tables in powerpivot
I've heard some forums mention a calendar table would be helpful, but I don't understand why?
Any help would be great!
Output desired (example only):
[TABLE="width: 2251"]
<colgroup><col><col><col><col span="2"><col><col><col span="23"></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Building (Assigned)[/TD]
[TD]Start Date[/TD]
[TD]Organization Leader[/TD]
[TD]Organization[/TD]
[TD]Average[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]1/5/2000[/TD]
[TD]Leader A[/TD]
[TD]TTBS[/TD]
[TD="align: right"]5.571429[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3916[/TD]
[TD]Dunker[/TD]
[TD]Jane[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]4/5/2012[/TD]
[TD]Leader AB[/TD]
[TD]TTBS[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3732[/TD]
[TD]Winters[/TD]
[TD]April[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]7/12/2015[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]13.85714[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9793[/TD]
[TD]Kim[/TD]
[TD]Tommy[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6429[/TD]
[TD]Lowman[/TD]
[TD]Susan[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/13/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7963[/TD]
[TD]Robinson[/TD]
[TD]Fred[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/14/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4323[/TD]
[TD]Smith[/TD]
[TD]Lars[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/15/2018[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]11.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4736[/TD]
[TD]Ryan[/TD]
[TD]Steve[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/16/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1279[/TD]
[TD]Austin[/TD]
[TD]Chris[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/17/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]3.333333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7884[/TD]
[TD]Styles[/TD]
[TD]Michelle[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/18/2018[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]6.25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2936[/TD]
[TD][/TD]
[TD]Dave[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/19/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]14.83333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6077[/TD]
[TD][/TD]
[TD]John[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/20/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7949[/TD]
[TD][/TD]
[TD]Tommy[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/21/2018[/TD]
[TD][/TD]
[TD]TTBS[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9191[/TD]
[TD][/TD]
[TD]Roy[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/22/2018[/TD]
[TD][/TD]
[TD]TTBS[/TD]
[TD="align: right"]5.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9139[/TD]
[TD][/TD]
[TD]Leon[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/23/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3035[/TD]
[TD][/TD]
[TD]John[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/24/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]13.33333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8154[/TD]
[TD][/TD]
[TD]David[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/25/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]7.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6434[/TD]
[TD][/TD]
[TD]Gregory[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/26/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Underlying data:
[TABLE="width: 734"]
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Building (Assigned)[/TD]
[TD]Building Visited[/TD]
[TD]Date visited[/TD]
[TD]Concatenate (for unique count)[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD]2150Building143105[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD]2150Building143105[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/6/2018[/TD]
[TD]2150Building143106[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/7/2018[/TD]
[TD]2150Building143107[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/8/2018[/TD]
[TD]2150Building143108[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/8/2018[/TD]
[TD]2150Building143108[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/9/2018[/TD]
[TD]2150Building143109[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD]2150Building243105[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/10/2018[/TD]
[TD]2150Building243110[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/15/2018[/TD]
[TD]2150Building243115[/TD]
[/TR]
[TR]
[TD="align: right"]2151[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding2[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/20/2018[/TD]
[TD]2151Building243120[/TD]
[/TR]
[TR]
[TD="align: right"]2152[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding3[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/30/2018[/TD]
[TD]2152Building243130[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/5/2018[/TD]
[TD]2150Building143256[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/6/2018[/TD]
[TD]2150Building143257[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD]2150Building143258[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/8/2018[/TD]
[TD]2150Building143259[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/8/2018[/TD]
[TD]2150Building143259[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/9/2018[/TD]
[TD]2150Building143260[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/10/2018[/TD]
[TD]2150Building143261[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/11/2018[/TD]
[TD]2150Building243262[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD]2150Building243263[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD]2150Building243263[/TD]
[/TR]
[TR]
[TD="align: right"]2151[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding2[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/9/2018[/TD]
[TD]2151Building243260[/TD]
[/TR]
[TR]
[TD="align: right"]2152[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding3[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/10/2018[/TD]
[TD]2152Building243261[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/11/2018[/TD]
[TD]2150Building143262[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD]2150Building143263[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/13/2018[/TD]
[TD]2150Building143264[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/14/2018[/TD]
[TD]2150Building143265[/TD]
[/TR]
</tbody>[/TABLE]
I'm measuring the amount of visits each employee visits one of our internal buildings. I'm attempting to do a fairly easy distinct count based on 3 criteria (date, building and staff ID). The powerpivot pivot table output shows the persons meta data (manager, org, assigned building) and in the values it show how many times they visited a given building by month(as you can see below). The values (visits) are taking up multiple columns, but I want to show only the average number of hits (average of each month) as 1 column. The average should check to see if the building they visited also matches the building they are assigned. Would also love a rolling 3 or 6 month average also.
I have the following tables in powerpivot
- Building Visited table (including date, Staff ID, building info) - obviously they can hit a building multiple times in one day...but I only want to count one time.
- Meta data (Staff ID, Name, manager, org info, assigned building, etc)
- Cleanup tables (taking building info and cleaning up the nomenclature; cleaning up staff ID)
I've heard some forums mention a calendar table would be helpful, but I don't understand why?
Any help would be great!
Output desired (example only):
[TABLE="width: 2251"]
<colgroup><col><col><col><col span="2"><col><col><col span="23"></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Building (Assigned)[/TD]
[TD]Start Date[/TD]
[TD]Organization Leader[/TD]
[TD]Organization[/TD]
[TD]Average[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]1/5/2000[/TD]
[TD]Leader A[/TD]
[TD]TTBS[/TD]
[TD="align: right"]5.571429[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3916[/TD]
[TD]Dunker[/TD]
[TD]Jane[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]4/5/2012[/TD]
[TD]Leader AB[/TD]
[TD]TTBS[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3732[/TD]
[TD]Winters[/TD]
[TD]April[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]7/12/2015[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]13.85714[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9793[/TD]
[TD]Kim[/TD]
[TD]Tommy[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6429[/TD]
[TD]Lowman[/TD]
[TD]Susan[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/13/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7963[/TD]
[TD]Robinson[/TD]
[TD]Fred[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/14/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4323[/TD]
[TD]Smith[/TD]
[TD]Lars[/TD]
[TD]Buiding1[/TD]
[TD="align: right"]6/15/2018[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]11.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4736[/TD]
[TD]Ryan[/TD]
[TD]Steve[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/16/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1279[/TD]
[TD]Austin[/TD]
[TD]Chris[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/17/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]3.333333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7884[/TD]
[TD]Styles[/TD]
[TD]Michelle[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/18/2018[/TD]
[TD][/TD]
[TD]CTWR[/TD]
[TD="align: right"]6.25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2936[/TD]
[TD][/TD]
[TD]Dave[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/19/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]14.83333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6077[/TD]
[TD][/TD]
[TD]John[/TD]
[TD]Building 2[/TD]
[TD="align: right"]6/20/2018[/TD]
[TD][/TD]
[TD]PPWX[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7949[/TD]
[TD][/TD]
[TD]Tommy[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/21/2018[/TD]
[TD][/TD]
[TD]TTBS[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9191[/TD]
[TD][/TD]
[TD]Roy[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/22/2018[/TD]
[TD][/TD]
[TD]TTBS[/TD]
[TD="align: right"]5.5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9139[/TD]
[TD][/TD]
[TD]Leon[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/23/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3035[/TD]
[TD][/TD]
[TD]John[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/24/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]13.33333[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8154[/TD]
[TD][/TD]
[TD]David[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/25/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]7.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6434[/TD]
[TD][/TD]
[TD]Gregory[/TD]
[TD]Building 3[/TD]
[TD="align: right"]6/26/2018[/TD]
[TD][/TD]
[TD]SRS[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Underlying data:
[TABLE="width: 734"]
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Building (Assigned)[/TD]
[TD]Building Visited[/TD]
[TD]Date visited[/TD]
[TD]Concatenate (for unique count)[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD]2150Building143105[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD]2150Building143105[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/6/2018[/TD]
[TD]2150Building143106[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/7/2018[/TD]
[TD]2150Building143107[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/8/2018[/TD]
[TD]2150Building143108[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/8/2018[/TD]
[TD]2150Building143108[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]1/9/2018[/TD]
[TD]2150Building143109[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD]2150Building243105[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/10/2018[/TD]
[TD]2150Building243110[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/15/2018[/TD]
[TD]2150Building243115[/TD]
[/TR]
[TR]
[TD="align: right"]2151[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding2[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/20/2018[/TD]
[TD]2151Building243120[/TD]
[/TR]
[TR]
[TD="align: right"]2152[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding3[/TD]
[TD]Building2[/TD]
[TD="align: right"]1/30/2018[/TD]
[TD]2152Building243130[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/5/2018[/TD]
[TD]2150Building143256[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/6/2018[/TD]
[TD]2150Building143257[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD]2150Building143258[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/8/2018[/TD]
[TD]2150Building143259[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/8/2018[/TD]
[TD]2150Building143259[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/9/2018[/TD]
[TD]2150Building143260[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/10/2018[/TD]
[TD]2150Building143261[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/11/2018[/TD]
[TD]2150Building243262[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD]2150Building243263[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD]2150Building243263[/TD]
[/TR]
[TR]
[TD="align: right"]2151[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding2[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/9/2018[/TD]
[TD]2151Building243260[/TD]
[/TR]
[TR]
[TD="align: right"]2152[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding3[/TD]
[TD]Building2[/TD]
[TD="align: right"]6/10/2018[/TD]
[TD]2152Building243261[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/11/2018[/TD]
[TD]2150Building143262[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/12/2018[/TD]
[TD]2150Building143263[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/13/2018[/TD]
[TD]2150Building143264[/TD]
[/TR]
[TR]
[TD="align: right"]2150[/TD]
[TD]Adams[/TD]
[TD]Bob[/TD]
[TD]Buiding1[/TD]
[TD]Building1[/TD]
[TD="align: right"]6/14/2018[/TD]
[TD]2150Building143265[/TD]
[/TR]
</tbody>[/TABLE]