bobbysmith
New Member
- Joined
- Jan 24, 2015
- Messages
- 29
I have a Excel Template, the workbook has sheets named "Data " and "Pivot". The data I pull comes from a CSV file which i open as excel file which i copy and paste to the "DATA" sheet Column N. When i execute the macro it formats it the way i want it and dumps the pivottable to the "Pivot" sheet. Recently the macro formats it the way i want it BUT...it is not creating the Pivot table. I tried testing with the data i pulled from the past weeks and it works but it is not working for current week. I think it has to do with data in the CSV file. Below is the Code and Data. Any insight would be greatly appreciated.
Code:
Sub FormatData()
'Offline Activities Report
Dim lnglastrow As Long
Application.ScreenUpdating = False
lnglastrow = ThisWorkbook.Worksheets("Data").Range("n" & Rows.Count).End(xlUp).Row
Range("o1" & lnglastrow).Copy
Range("a1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("p1" & lnglastrow).Copy
Range("b1").PasteSpecial xlPasteValues
Range("s1:s" & lnglastrow).Copy
Range("c1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("w1:w" & lnglastrow).Copy
Range("d1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("d2:d" & lnglastrow).NumberFormat = "m/d/yyyy"
Range("y1:ac" & lnglastrow).Copy
Range("e1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("ae1:af" & lnglastrow).Copy
Range("j1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("l1").Select
Range("f2:g" & lnglastrow).NumberFormat = "h:mm"
Range("j1").Value = "Dept"
Range("k1").Value = "Site/Dept"
Range("a1:k1").HorizontalAlignment = xlCenter
Range("a1:a" & lnglastrow).RowHeight = 15
Range("a1:k1").Font.Bold = True
With ThisWorkbook.Worksheets("Data").Range("j1:j" & lnglastrow)
.Replace what:="WAU", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="CED", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="TUL", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="KNX", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
End With
Range("a1:k1").AutoFilter
Range("a:k").Sort key1:=Range("f1"), order1:=xlAscending, Header:=xlYes
Range("a:h").EntireColumn.AutoFit
Range("j:k").EntireColumn.AutoFit
Range("a2").Select
ActiveWindow.FreezePanes = True
Range("N:AL").EntireColumn.ClearContents
Range("n1").Select
Sheets("Data").Buttons("button 1").Visible = False
Sheets("Data").Buttons("button 2").Visible = False
Range("n1").Select
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("n1").ClearComments
Range("l1").Select
Range("m1").Value = "Team meeting Ct"
Range("f2:f" & lnglastrow).Copy
Range("m2").PasteSpecial xlPasteAll
Application.CutCopyMode = False
Range("m1").Font.Bold = True
Dim lnglastrow2 As Long
lnglastrow2 = ThisWorkbook.Worksheets("Data").Range("m" & Rows.Count).End(xlUp).Row
Range("m1:m" & lnglastrow2).RemoveDuplicates Columns:=Array(1), Header:=xlYes
Dim lnglastrow3 As Long
lnglastrow3 = ThisWorkbook.Worksheets("Data").Range("m" & Rows.Count).End(xlUp).Row
Range("n1").Value = " BUS SUPPT"
Range("o1").Value = " CUST SERV"
Range("p1").Value = " CUSTSERV HELP QUEUE"
Range("q1").Value = " CUSTSERV MULTI"
Range("r1").Value = " SOLUTIONS CONSULTANTS"
Range("s1").Value = " TECH SUPPT"
Range("t1").Value = " TELESALES"
Range("u1").Value = " WNP"
Range("n1:u1").Font.Bold = True
Range("n2").Formula = "=countifs($e:$e,""Team"",$j:$j,n$1,$f:$f,$m2)"
Range("n2").AutoFill Range("n2:u2"), xlFillDefault
Range("n2:u2").AutoFill Range("n2:u" & lnglastrow3), xlFillDefault
Range("n2:u" & lnglastrow3).Copy
Range("n2").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("l1").Select
Range("n2:u" & lnglastrow3).FormatConditions.Add xlCellValue, xlGreater, "=0"
Range("n2:u" & lnglastrow3).FormatConditions(Range("n2:u" & lnglastrow3).FormatConditions.Count). _
SetFirstPriority
With Range("n2:u" & lnglastrow3).FormatConditions(1).Font
.Bold = True
.Color = vbRed
.TintAndShade = 0
End With
Range("m:u").EntireColumn.AutoFit
Range("n2:u" & lnglastrow3).HorizontalAlignment = xlCenter
Range("l1").Select
Dim pvtC As PivotCache
Dim pvt As PivotTable
Dim pvtF As PivotField
On Error Resume Next
ThisWorkbook.Worksheets("Pivot").Select
ActiveSheet.PivotTables("pivottable1").TableRange2.Clear
ThisWorkbook.Worksheets("Data").Select
Set pvtC = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("a1:k" & lnglastrow))
Sheets("Pivot").Select
Set pvt = ActiveSheet.PivotTables.Add(pvtC, Range("a1"), "pivottable1")
With pvt
.PivotFields("Start_Date").Orientation = xlPageField
.PivotFields("Nom_Date").Orientation = xlPageField
.PivotFields("Dept").Orientation = xlRowField
.PivotFields("Seg_Code").Orientation = xlColumnField
.PivotFields("Emp_Sk").Orientation = xlDataField
.PivotFields("Sum of Emp_Sk").Function = xlCount
.DataBodyRange.NumberFormat = "#,0"
.ColumnGrand = False
.RowGrand = False
.CompactLayoutColumnHeader = "Offline"
.CompactLayoutRowHeader = "Offline Activities by Dept"
.ShowTableStyleRowStripes = True
.TableStyle2 = "pivotstylelight22"
.PivotFields("Offline Activities by Dept").AutoSort Order:=xlAscending
End With
Range("a3").EntireRow.Hidden = True
ActiveWorkbook.ShowPivotTableFieldList = False
Application.ScreenUpdating = True
End Sub
DATA: Columns (A:S)
[TABLE="width: 1634"]
<colgroup><col span="3"><col><col span="2"><col><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>[TR]
[TD]PRI_INDEX[/TD]
[TD]EMP_SK[/TD]
[TD]EMP_ID[/TD]
[TD]EMP_LAST_NAME[/TD]
[TD]EMP_FIRST_NAME[/TD]
[TD]EMP_SORT_NAME[/TD]
[TD]EMP_SHORT_NAME[/TD]
[TD]EMP_SENIORITY[/TD]
[TD]EMP_EFF_HIRE_DATE[/TD]
[TD]NOM_DATE[/TD]
[TD]START_DATE[/TD]
[TD]SEG_CODE[/TD]
[TD]START_MOMENT[/TD]
[TD]STOP_MOMENT[/TD]
[TD]DURATION[/TD]
[TD]MEMO[/TD]
[TD]RANK[/TD]
[TD]EMP_CLASS_1[/TD]
[TD]EMP_CLASS_1_DESCR[/TD]
[/TR]
[TR]
[TD="align: right"]433[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]1[/TD]
[TD]DOE1[/TD]
[TD]JOE[/TD]
[TD]DOE1,JOE[/TD]
[TD]DOE1, JOE[/TD]
[TD="align: right"]20060619[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]437[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]2[/TD]
[TD]DOE2[/TD]
[TD]JOE[/TD]
[TD]DOE2,JOE[/TD]
[TD]DOE2, JOE[/TD]
[TD="align: right"]20080107[/TD]
[TD="align: right"]1/7/2008[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]253[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]3[/TD]
[TD]DOE3[/TD]
[TD]JOE[/TD]
[TD]DOE3,JOE[/TD]
[TD]DOE3, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]439[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]4[/TD]
[TD]DOE4[/TD]
[TD]JOE[/TD]
[TD]DOE4,JOE[/TD]
[TD]DOE4, JOE[/TD]
[TD="align: right"]20090622[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]166[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]5[/TD]
[TD]DOE5[/TD]
[TD]JOE[/TD]
[TD]DOE5,JOE[/TD]
[TD]DOE5, JOE[/TD]
[TD="align: right"]20130930[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]443[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]6[/TD]
[TD]DOE6[/TD]
[TD]JOE[/TD]
[TD]DOE6,JOE[/TD]
[TD]DOE6, JOE[/TD]
[TD="align: right"]20140310[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]446[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]7[/TD]
[TD]DOE7[/TD]
[TD]JOE[/TD]
[TD]DOE7,JOE[/TD]
[TD]DOE7, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]466[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]8[/TD]
[TD]DOE8[/TD]
[TD]JOE[/TD]
[TD]DOE8,JOE[/TD]
[TD]DOE8, JOE[/TD]
[TD="align: right"]20140707[/TD]
[TD="align: right"]7/7/2014[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]447[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]9[/TD]
[TD]DOE9[/TD]
[TD]JOE[/TD]
[TD]DOE9,JOE[/TD]
[TD]DOE9, JOE[/TD]
[TD="align: right"]20140915[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]374[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]10[/TD]
[TD]DOE10[/TD]
[TD]JOE[/TD]
[TD]DOE10,JOE[/TD]
[TD]DOE10, JOE[/TD]
[TD="align: right"]20140915[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]468[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]11[/TD]
[TD]DOE11[/TD]
[TD]JOE[/TD]
[TD]DOE11,JOE[/TD]
[TD]DOE11, JOE[/TD]
[TD="align: right"]20141124[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]470[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]12[/TD]
[TD]DOE12[/TD]
[TD]JOE[/TD]
[TD]DOE12,JOE[/TD]
[TD]DOE12, JOE[/TD]
[TD="align: right"]20150112[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]450[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]13[/TD]
[TD]DOE13[/TD]
[TD]JOE[/TD]
[TD]DOE13,JOE[/TD]
[TD]DOE13, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]452[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]14[/TD]
[TD]DOE14[/TD]
[TD]JOE[/TD]
[TD]DOE14,JOE[/TD]
[TD]DOE14, JOE[/TD]
[TD="align: right"]20151005[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]454[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]15[/TD]
[TD]DOE15[/TD]
[TD]JOE[/TD]
[TD]DOE15,JOE[/TD]
[TD]DOE15, JOE[/TD]
[TD="align: right"]20121217[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]456[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]16[/TD]
[TD]DOE16[/TD]
[TD]JOE[/TD]
[TD]DOE16,JOE[/TD]
[TD]DOE16, JOE[/TD]
[TD="align: right"]20160523[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]290[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]17[/TD]
[TD]DOE17[/TD]
[TD]JOE[/TD]
[TD]DOE17,JOE[/TD]
[TD]DOE17, JOE[/TD]
[TD="align: right"]20160718[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]458[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]18[/TD]
[TD]DOE18[/TD]
[TD]JOE[/TD]
[TD]DOE18,JOE[/TD]
[TD]DOE18, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]460[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]19[/TD]
[TD]DOE19[/TD]
[TD]JOE[/TD]
[TD]DOE19,JOE[/TD]
[TD]DOE19, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]463[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]20[/TD]
[TD]DOE20[/TD]
[TD]JOE[/TD]
[TD]DOE20,JOE[/TD]
[TD]DOE20, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]471[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]21[/TD]
[TD]DOE21[/TD]
[TD]JOE[/TD]
[TD]DOE21,JOE[/TD]
[TD]DOE21, JOE[/TD]
[TD="align: right"]20160912[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]176[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]22[/TD]
[TD]DOE22[/TD]
[TD]JOE[/TD]
[TD]DOE22,JOE[/TD]
[TD]DOE22, JOE[/TD]
[TD="align: right"]20161031[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]293[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]23[/TD]
[TD]DOE23[/TD]
[TD]JOE[/TD]
[TD]DOE23,JOE[/TD]
[TD]DOE23, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]295[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]24[/TD]
[TD]DOE24[/TD]
[TD]JOE[/TD]
[TD]DOE24,JOE[/TD]
[TD]DOE24, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]296[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]25[/TD]
[TD]DOE25[/TD]
[TD]JOE[/TD]
[TD]DOE25,JOE[/TD]
[TD]DOE25, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]177[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]26[/TD]
[TD]DOE26[/TD]
[TD]JOE[/TD]
[TD]DOE26,JOE[/TD]
[TD]DOE26, JOE[/TD]
[TD="align: right"]20161031[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]308[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]27[/TD]
[TD]DOE27[/TD]
[TD]JOE[/TD]
[TD]DOE27,JOE[/TD]
[TD]DOE27, JOE[/TD]
[TD="align: right"]20161205[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]313[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]28[/TD]
[TD]DOE28[/TD]
[TD]JOE[/TD]
[TD]DOE28,JOE[/TD]
[TD]DOE28, JOE[/TD]
[TD="align: right"]20170116[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]316[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]29[/TD]
[TD]DOE29[/TD]
[TD]JOE[/TD]
[TD]DOE29,JOE[/TD]
[TD]DOE29, JOE[/TD]
[TD="align: right"]20170116[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]321[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]30[/TD]
[TD]DOE30[/TD]
[TD]JOE[/TD]
[TD]DOE30,JOE[/TD]
[TD]DOE30, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]328[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]31[/TD]
[TD]DOE31[/TD]
[TD]JOE[/TD]
[TD]DOE31,JOE[/TD]
[TD]DOE31, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]332[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]32[/TD]
[TD]DOE32[/TD]
[TD]JOE[/TD]
[TD]DOE32,JOE[/TD]
[TD]DOE32, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]180[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]33[/TD]
[TD]DOE33[/TD]
[TD]JOE[/TD]
[TD]DOE33,JOE[/TD]
[TD]DOE33, JOE[/TD]
[TD="align: right"]20161107[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]181[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]34[/TD]
[TD]DOE34[/TD]
[TD]JOE[/TD]
[TD]DOE34,JOE[/TD]
[TD]DOE34, JOE[/TD]
[TD="align: right"]20170424[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]413[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]35[/TD]
[TD]DOE35[/TD]
[TD]JOE[/TD]
[TD]DOE35,JOE[/TD]
[TD]DOE35, JOE[/TD]
[TD="align: right"]20170508[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]419[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]36[/TD]
[TD]DOE36[/TD]
[TD]JOE[/TD]
[TD]DOE36,JOE[/TD]
[TD]DOE36, JOE[/TD]
[TD="align: right"]20170508[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
</tbody>[/TABLE]
Code:
Sub FormatData()
'Offline Activities Report
Dim lnglastrow As Long
Application.ScreenUpdating = False
lnglastrow = ThisWorkbook.Worksheets("Data").Range("n" & Rows.Count).End(xlUp).Row
Range("o1" & lnglastrow).Copy
Range("a1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("p1" & lnglastrow).Copy
Range("b1").PasteSpecial xlPasteValues
Range("s1:s" & lnglastrow).Copy
Range("c1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("w1:w" & lnglastrow).Copy
Range("d1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("d2:d" & lnglastrow).NumberFormat = "m/d/yyyy"
Range("y1:ac" & lnglastrow).Copy
Range("e1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("ae1:af" & lnglastrow).Copy
Range("j1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("l1").Select
Range("f2:g" & lnglastrow).NumberFormat = "h:mm"
Range("j1").Value = "Dept"
Range("k1").Value = "Site/Dept"
Range("a1:k1").HorizontalAlignment = xlCenter
Range("a1:a" & lnglastrow).RowHeight = 15
Range("a1:k1").Font.Bold = True
With ThisWorkbook.Worksheets("Data").Range("j1:j" & lnglastrow)
.Replace what:="WAU", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="CED", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="TUL", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="KNX", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
End With
Range("a1:k1").AutoFilter
Range("a:k").Sort key1:=Range("f1"), order1:=xlAscending, Header:=xlYes
Range("a:h").EntireColumn.AutoFit
Range("j:k").EntireColumn.AutoFit
Range("a2").Select
ActiveWindow.FreezePanes = True
Range("N:AL").EntireColumn.ClearContents
Range("n1").Select
Sheets("Data").Buttons("button 1").Visible = False
Sheets("Data").Buttons("button 2").Visible = False
Range("n1").Select
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("n1").ClearComments
Range("l1").Select
Range("m1").Value = "Team meeting Ct"
Range("f2:f" & lnglastrow).Copy
Range("m2").PasteSpecial xlPasteAll
Application.CutCopyMode = False
Range("m1").Font.Bold = True
Dim lnglastrow2 As Long
lnglastrow2 = ThisWorkbook.Worksheets("Data").Range("m" & Rows.Count).End(xlUp).Row
Range("m1:m" & lnglastrow2).RemoveDuplicates Columns:=Array(1), Header:=xlYes
Dim lnglastrow3 As Long
lnglastrow3 = ThisWorkbook.Worksheets("Data").Range("m" & Rows.Count).End(xlUp).Row
Range("n1").Value = " BUS SUPPT"
Range("o1").Value = " CUST SERV"
Range("p1").Value = " CUSTSERV HELP QUEUE"
Range("q1").Value = " CUSTSERV MULTI"
Range("r1").Value = " SOLUTIONS CONSULTANTS"
Range("s1").Value = " TECH SUPPT"
Range("t1").Value = " TELESALES"
Range("u1").Value = " WNP"
Range("n1:u1").Font.Bold = True
Range("n2").Formula = "=countifs($e:$e,""Team"",$j:$j,n$1,$f:$f,$m2)"
Range("n2").AutoFill Range("n2:u2"), xlFillDefault
Range("n2:u2").AutoFill Range("n2:u" & lnglastrow3), xlFillDefault
Range("n2:u" & lnglastrow3).Copy
Range("n2").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("l1").Select
Range("n2:u" & lnglastrow3).FormatConditions.Add xlCellValue, xlGreater, "=0"
Range("n2:u" & lnglastrow3).FormatConditions(Range("n2:u" & lnglastrow3).FormatConditions.Count). _
SetFirstPriority
With Range("n2:u" & lnglastrow3).FormatConditions(1).Font
.Bold = True
.Color = vbRed
.TintAndShade = 0
End With
Range("m:u").EntireColumn.AutoFit
Range("n2:u" & lnglastrow3).HorizontalAlignment = xlCenter
Range("l1").Select
Dim pvtC As PivotCache
Dim pvt As PivotTable
Dim pvtF As PivotField
On Error Resume Next
ThisWorkbook.Worksheets("Pivot").Select
ActiveSheet.PivotTables("pivottable1").TableRange2.Clear
ThisWorkbook.Worksheets("Data").Select
Set pvtC = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("a1:k" & lnglastrow))
Sheets("Pivot").Select
Set pvt = ActiveSheet.PivotTables.Add(pvtC, Range("a1"), "pivottable1")
With pvt
.PivotFields("Start_Date").Orientation = xlPageField
.PivotFields("Nom_Date").Orientation = xlPageField
.PivotFields("Dept").Orientation = xlRowField
.PivotFields("Seg_Code").Orientation = xlColumnField
.PivotFields("Emp_Sk").Orientation = xlDataField
.PivotFields("Sum of Emp_Sk").Function = xlCount
.DataBodyRange.NumberFormat = "#,0"
.ColumnGrand = False
.RowGrand = False
.CompactLayoutColumnHeader = "Offline"
.CompactLayoutRowHeader = "Offline Activities by Dept"
.ShowTableStyleRowStripes = True
.TableStyle2 = "pivotstylelight22"
.PivotFields("Offline Activities by Dept").AutoSort Order:=xlAscending
End With
Range("a3").EntireRow.Hidden = True
ActiveWorkbook.ShowPivotTableFieldList = False
Application.ScreenUpdating = True
End Sub
DATA: Columns (A:S)
[TABLE="width: 1634"]
<colgroup><col span="3"><col><col span="2"><col><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>[TR]
[TD]PRI_INDEX[/TD]
[TD]EMP_SK[/TD]
[TD]EMP_ID[/TD]
[TD]EMP_LAST_NAME[/TD]
[TD]EMP_FIRST_NAME[/TD]
[TD]EMP_SORT_NAME[/TD]
[TD]EMP_SHORT_NAME[/TD]
[TD]EMP_SENIORITY[/TD]
[TD]EMP_EFF_HIRE_DATE[/TD]
[TD]NOM_DATE[/TD]
[TD]START_DATE[/TD]
[TD]SEG_CODE[/TD]
[TD]START_MOMENT[/TD]
[TD]STOP_MOMENT[/TD]
[TD]DURATION[/TD]
[TD]MEMO[/TD]
[TD]RANK[/TD]
[TD]EMP_CLASS_1[/TD]
[TD]EMP_CLASS_1_DESCR[/TD]
[/TR]
[TR]
[TD="align: right"]433[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]1[/TD]
[TD]DOE1[/TD]
[TD]JOE[/TD]
[TD]DOE1,JOE[/TD]
[TD]DOE1, JOE[/TD]
[TD="align: right"]20060619[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]437[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]2[/TD]
[TD]DOE2[/TD]
[TD]JOE[/TD]
[TD]DOE2,JOE[/TD]
[TD]DOE2, JOE[/TD]
[TD="align: right"]20080107[/TD]
[TD="align: right"]1/7/2008[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]253[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]3[/TD]
[TD]DOE3[/TD]
[TD]JOE[/TD]
[TD]DOE3,JOE[/TD]
[TD]DOE3, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]439[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]4[/TD]
[TD]DOE4[/TD]
[TD]JOE[/TD]
[TD]DOE4,JOE[/TD]
[TD]DOE4, JOE[/TD]
[TD="align: right"]20090622[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]166[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]5[/TD]
[TD]DOE5[/TD]
[TD]JOE[/TD]
[TD]DOE5,JOE[/TD]
[TD]DOE5, JOE[/TD]
[TD="align: right"]20130930[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]443[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]6[/TD]
[TD]DOE6[/TD]
[TD]JOE[/TD]
[TD]DOE6,JOE[/TD]
[TD]DOE6, JOE[/TD]
[TD="align: right"]20140310[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]446[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]7[/TD]
[TD]DOE7[/TD]
[TD]JOE[/TD]
[TD]DOE7,JOE[/TD]
[TD]DOE7, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]466[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]8[/TD]
[TD]DOE8[/TD]
[TD]JOE[/TD]
[TD]DOE8,JOE[/TD]
[TD]DOE8, JOE[/TD]
[TD="align: right"]20140707[/TD]
[TD="align: right"]7/7/2014[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]447[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]9[/TD]
[TD]DOE9[/TD]
[TD]JOE[/TD]
[TD]DOE9,JOE[/TD]
[TD]DOE9, JOE[/TD]
[TD="align: right"]20140915[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]374[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]10[/TD]
[TD]DOE10[/TD]
[TD]JOE[/TD]
[TD]DOE10,JOE[/TD]
[TD]DOE10, JOE[/TD]
[TD="align: right"]20140915[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]468[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]11[/TD]
[TD]DOE11[/TD]
[TD]JOE[/TD]
[TD]DOE11,JOE[/TD]
[TD]DOE11, JOE[/TD]
[TD="align: right"]20141124[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]470[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]12[/TD]
[TD]DOE12[/TD]
[TD]JOE[/TD]
[TD]DOE12,JOE[/TD]
[TD]DOE12, JOE[/TD]
[TD="align: right"]20150112[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]450[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]13[/TD]
[TD]DOE13[/TD]
[TD]JOE[/TD]
[TD]DOE13,JOE[/TD]
[TD]DOE13, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]452[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]14[/TD]
[TD]DOE14[/TD]
[TD]JOE[/TD]
[TD]DOE14,JOE[/TD]
[TD]DOE14, JOE[/TD]
[TD="align: right"]20151005[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]454[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]15[/TD]
[TD]DOE15[/TD]
[TD]JOE[/TD]
[TD]DOE15,JOE[/TD]
[TD]DOE15, JOE[/TD]
[TD="align: right"]20121217[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]456[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]16[/TD]
[TD]DOE16[/TD]
[TD]JOE[/TD]
[TD]DOE16,JOE[/TD]
[TD]DOE16, JOE[/TD]
[TD="align: right"]20160523[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]290[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]17[/TD]
[TD]DOE17[/TD]
[TD]JOE[/TD]
[TD]DOE17,JOE[/TD]
[TD]DOE17, JOE[/TD]
[TD="align: right"]20160718[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]458[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]18[/TD]
[TD]DOE18[/TD]
[TD]JOE[/TD]
[TD]DOE18,JOE[/TD]
[TD]DOE18, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]460[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]19[/TD]
[TD]DOE19[/TD]
[TD]JOE[/TD]
[TD]DOE19,JOE[/TD]
[TD]DOE19, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]463[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]20[/TD]
[TD]DOE20[/TD]
[TD]JOE[/TD]
[TD]DOE20,JOE[/TD]
[TD]DOE20, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21
Steps to Complete Training
1. Go to Academy Point and click on the Register button in the top-right corner.
2. Enter the requested information and the User Registration Code “USCellular1031”
3. Complete the modules listed under “My Training Plan.”
[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]471[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]21[/TD]
[TD]DOE21[/TD]
[TD]JOE[/TD]
[TD]DOE21,JOE[/TD]
[TD]DOE21, JOE[/TD]
[TD="align: right"]20160912[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]176[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]22[/TD]
[TD]DOE22[/TD]
[TD]JOE[/TD]
[TD]DOE22,JOE[/TD]
[TD]DOE22, JOE[/TD]
[TD="align: right"]20161031[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]293[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]23[/TD]
[TD]DOE23[/TD]
[TD]JOE[/TD]
[TD]DOE23,JOE[/TD]
[TD]DOE23, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]295[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]24[/TD]
[TD]DOE24[/TD]
[TD]JOE[/TD]
[TD]DOE24,JOE[/TD]
[TD]DOE24, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]296[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]25[/TD]
[TD]DOE25[/TD]
[TD]JOE[/TD]
[TD]DOE25,JOE[/TD]
[TD]DOE25, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]177[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]26[/TD]
[TD]DOE26[/TD]
[TD]JOE[/TD]
[TD]DOE26,JOE[/TD]
[TD]DOE26, JOE[/TD]
[TD="align: right"]20161031[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]308[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]27[/TD]
[TD]DOE27[/TD]
[TD]JOE[/TD]
[TD]DOE27,JOE[/TD]
[TD]DOE27, JOE[/TD]
[TD="align: right"]20161205[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]313[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]28[/TD]
[TD]DOE28[/TD]
[TD]JOE[/TD]
[TD]DOE28,JOE[/TD]
[TD]DOE28, JOE[/TD]
[TD="align: right"]20170116[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]316[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]29[/TD]
[TD]DOE29[/TD]
[TD]JOE[/TD]
[TD]DOE29,JOE[/TD]
[TD]DOE29, JOE[/TD]
[TD="align: right"]20170116[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]321[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]30[/TD]
[TD]DOE30[/TD]
[TD]JOE[/TD]
[TD]DOE30,JOE[/TD]
[TD]DOE30, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]328[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]31[/TD]
[TD]DOE31[/TD]
[TD]JOE[/TD]
[TD]DOE31,JOE[/TD]
[TD]DOE31, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]332[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]32[/TD]
[TD]DOE32[/TD]
[TD]JOE[/TD]
[TD]DOE32,JOE[/TD]
[TD]DOE32, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]180[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]33[/TD]
[TD]DOE33[/TD]
[TD]JOE[/TD]
[TD]DOE33,JOE[/TD]
[TD]DOE33, JOE[/TD]
[TD="align: right"]20161107[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]181[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]34[/TD]
[TD]DOE34[/TD]
[TD]JOE[/TD]
[TD]DOE34,JOE[/TD]
[TD]DOE34, JOE[/TD]
[TD="align: right"]20170424[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]413[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]35[/TD]
[TD]DOE35[/TD]
[TD]JOE[/TD]
[TD]DOE35,JOE[/TD]
[TD]DOE35, JOE[/TD]
[TD="align: right"]20170508[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]419[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]36[/TD]
[TD]DOE36[/TD]
[TD]JOE[/TD]
[TD]DOE36,JOE[/TD]
[TD]DOE36, JOE[/TD]
[TD="align: right"]20170508[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
</tbody>[/TABLE]