Chapter 1 Running Case Portfolio

profiledanevia
SpreadsheetChapter1bethell_e01r1NCCTS.xlsx

Sheet1

Calls Closed During March
CallID Customer ID RepID CallTypeID Call Type Name Rate Hours Logged Opened Date Closed Date Days Open Amount Billed
049 PC041 4 3 Network Troubleshooting 40 12.5 3/3/21 3/13/21
064 PC041 1 4 Network Installation 45 2.5 3/13/21 3/17/21
048 PC041 1 6 Security Camera Maintenance 35 1.25 3/3/21 3/10/21
045 PC041 7 7 Virus Detection 35 2.5 2/27/21 3/4/21
047 PC048 2 1 Hardware Support 35 4.5 3/2/21 3/6/21
056 PC028 5 3 Network Troubleshooting 40 9.75 3/6/21 3/13/21
055 PC038 2 5 Training 55 9.25 3/6/21 3/8/21
061 PC038 2 8 Disaster Recovery 65 6.25 3/8/21 3/14/21
060 PC044 3 5 Training 55 2.25 3/8/21 3/11/21
068 PC044 1 5 Training 55 1.5 3/19/21 3/21/21
063 PC044 3 9 VoIP Service 50 1.5 3/12/21 3/15/21
069 PC044 6 10 Other 40 5.25 3/22/21 3/31/21
054 PC040 4 3 Network Troubleshooting 40 10.25 3/5/21 3/13/21
050 PC035 6 7 Virus Detection 35 12 3/4/21 3/12/21
039 PC035 1 10 Other 40 6.75 2/21/21 3/3/21
065 PC017 7 2 Software Support 30 10.75 3/13/21 3/21/21
053 PC017 4 4 Network Installation 45 9.5 3/5/21 3/13/21
046 PC012 2 5 Training 55 10 2/28/21 3/5/21
044 PC031 6 7 Virus Detection 35 12.5 2/25/21 3/1/21
051 PC029 6 7 Virus Detection 35 8 3/4/21 3/12/21
058 PC004 3 1 Hardware Support 35 1.75 3/8/21 3/10/21
067 PC007 3 1 Hardware Support 35 7.25 3/17/21 3/19/21
073 PC007 4 8 Disaster Recovery 65 5 3/26/21 3/31/21
052 PC001 7 2 Software Support 30 1.25 3/4/21 3/9/21
038 PC001 3 10 Other 40 3.75 2/19/21 3/2/21
057 PC018 6 1 Hardware Support 35 2 3/7/21 3/10/21
059 PC018 7 3 Network Troubleshooting 40 6.25 3/8/21 3/17/21
040 PC027 7 5 Training 55 10.75 2/22/21 3/3/21
066 PC027 7 6 Security Camera Maintenance 35 6 3/14/21 3/24/21
041 PC027 5 8 Disaster Recovery 65 5 2/23/21 3/6/21
077 PC027 3 8 Disaster Recovery 65 5 3/29/21 3/31/21
062 PC052 5 7 Virus Detection 35 10.75 3/12/21 3/14/21