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)
<colgroup><col span="3"><col><col span="2"><col><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>
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).CopyRange("a1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("p1
" & lnglastrow).CopyRange("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)
| PRI_INDEX | EMP_SK | EMP_ID | EMP_LAST_NAME | EMP_FIRST_NAME | EMP_SORT_NAME | EMP_SHORT_NAME | EMP_SENIORITY | EMP_EFF_HIRE_DATE | NOM_DATE | START_DATE | SEG_CODE | START_MOMENT | STOP_MOMENT | DURATION | MEMO | RANK | EMP_CLASS_1 | EMP_CLASS_1_DESCR |
| 433 | -9.9E+11 | 1 | DOE1 | JOE | DOE1,JOE | DOE1, JOE | 20060619 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 437 | -9.9E+11 | 2 | DOE2 | JOE | DOE2,JOE | DOE2, JOE | 20080107 | 1/7/2008 | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 253 | -9.9E+11 | 3 | DOE3 | JOE | DOE3,JOE | DOE3, JOE | 20170313 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 439 | -9.9E+11 | 4 | DOE4 | JOE | DOE4,JOE | DOE4, JOE | 20090622 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 166 | -9.6E+11 | 5 | DOE5 | JOE | DOE5,JOE | DOE5, JOE | 20130930 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | KNX CUST SERV | KNX CUST SERV |
| 443 | -9.6E+11 | 6 | DOE6 | JOE | DOE6,JOE | DOE6, JOE | 20140310 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL TELESALES | TUL TELESALES |
| 446 | -9.6E+11 | 7 | DOE7 | JOE | DOE7,JOE | DOE7, JOE | 20160815 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL TELESALES | TUL TELESALES |
| 466 | -9.6E+11 | 8 | DOE8 | JOE | DOE8,JOE | DOE8, JOE | 20140707 | 7/7/2014 | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUSTSERV MULTI | WAU CUSTSERV MULTI |
| 447 | -9.6E+11 | 9 | DOE9 | JOE | DOE9,JOE | DOE9, JOE | 20140915 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 374 | -9.6E+11 | 10 | DOE10 | JOE | DOE10,JOE | DOE10, JOE | 20140915 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUST SERV | WAU CUST SERV |
| 468 | -9.6E+11 | 11 | DOE11 | JOE | DOE11,JOE | DOE11, JOE | 20141124 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUSTSERV MULTI | WAU CUSTSERV MULTI |
| 470 | -9.6E+11 | 12 | DOE12 | JOE | DOE12,JOE | DOE12, JOE | 20150112 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUSTSERV MULTI | WAU CUSTSERV MULTI |
| 450 | -9.6E+11 | 13 | DOE13 | JOE | DOE13,JOE | DOE13, JOE | 20160815 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL TELESALES | TUL TELESALES |
| 452 | -9.6E+11 | 14 | DOE14 | JOE | DOE14,JOE | DOE14, JOE | 20151005 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL TELESALES | TUL TELESALES |
| 454 | -9.6E+11 | 15 | DOE15 | JOE | DOE15,JOE | DOE15, JOE | 20121217 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 456 | -9.6E+11 | 16 | DOE16 | JOE | DOE16,JOE | DOE16, JOE | 20160523 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 290 | -9.6E+11 | 17 | DOE17 | JOE | DOE17,JOE | DOE17, JOE | 20160718 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 458 | -9.6E+11 | 18 | DOE18 | JOE | DOE18,JOE | DOE18, JOE | 20160815 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 460 | -9.6E+11 | 19 | DOE19 | JOE | DOE19,JOE | DOE19, JOE | 20160815 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 463 | -9.6E+11 | 20 | DOE20 | JOE | DOE20,JOE | DOE20, JOE | 20160815 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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.” | 54 | TUL TELESALES | TUL TELESALES |
| 471 | -9.6E+11 | 21 | DOE21 | JOE | DOE21,JOE | DOE21, JOE | 20160912 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUSTSERV MULTI | WAU CUSTSERV MULTI |
| 176 | -9.6E+11 | 22 | DOE22 | JOE | DOE22,JOE | DOE22, JOE | 20161031 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | KNX CUST SERV | KNX CUST SERV |
| 293 | -9.6E+11 | 23 | DOE23 | JOE | DOE23,JOE | DOE23, JOE | 20160926 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 295 | -9.6E+11 | 24 | DOE24 | JOE | DOE24,JOE | DOE24, JOE | 20160926 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 296 | -9.6E+11 | 25 | DOE25 | JOE | DOE25,JOE | DOE25, JOE | 20160926 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 177 | -9.6E+11 | 26 | DOE26 | JOE | DOE26,JOE | DOE26, JOE | 20161031 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | KNX CUST SERV | KNX CUST SERV |
| 308 | -9.6E+11 | 27 | DOE27 | JOE | DOE27,JOE | DOE27, JOE | 20161205 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 313 | -9.6E+11 | 28 | DOE28 | JOE | DOE28,JOE | DOE28, JOE | 20170116 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 316 | -9.6E+11 | 29 | DOE29 | JOE | DOE29,JOE | DOE29, JOE | 20170116 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 321 | -9.6E+11 | 30 | DOE30 | JOE | DOE30,JOE | DOE30, JOE | 20170313 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 328 | -9.6E+11 | 31 | DOE31 | JOE | DOE31,JOE | DOE31, JOE | 20170313 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 332 | -9.6E+11 | 32 | DOE32 | JOE | DOE32,JOE | DOE32, JOE | 20170313 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | TUL CUST SERV | TUL CUST SERV |
| 180 | -9.6E+11 | 33 | DOE33 | JOE | DOE33,JOE | DOE33, JOE | 20161107 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | KNX CUST SERV | KNX CUST SERV |
| 181 | -9.6E+11 | 34 | DOE34 | JOE | DOE34,JOE | DOE34, JOE | 20170424 | ######## | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | KNX CUST SERV | KNX CUST SERV |
| 413 | -9.6E+11 | 35 | DOE35 | JOE | DOE35,JOE | DOE35, JOE | 20170508 | 5/8/2017 | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUST SERV | WAU CUST SERV |
| 419 | -9.6E+11 | 36 | DOE36 | JOE | DOE36,JOE | DOE36, JOE | 20170508 | 5/8/2017 | 8/2/2017 | 8/2/2017 | CBT | ######## | ######## | 10 | 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. | 54 | WAU CUST SERV | WAU CUST SERV |
<colgroup><col span="3"><col><col span="2"><col><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>
