Analysis of this worksheet in 250 words!
- What insights do you have about the data presented in the spreadsheet? Are there any anomalies or interesting facts you see?
- What kinds of decisions can you make from the data, or what recommendations can you make to improve the business, process, etc. that is presented in the spreadsheet?
- What can be changed to improve the worksheet? Why would your recommendation be an improvement
Operator Summary RSR Computer Services Help Desk Status Report ID Calls Operators Last Name First Name 1 2 3 4 7 7 4 5 Total Time 10.75 6.5 3.5 6 Avg Time 1.54 0.93 0.88 1.20 7 16 Date 3/1/21 3/10/21 3/22/21 3/26/21 3/2/21 3/3/21 3/3/21 3/5/21 3/5/21 3/5/21 3/8/21 3/9/21 3/12/21 3/12/21 3/15/21 3/15/21 3/16/21 3/17/21 3/18/21 3/23/21 3/26/21 3/29/21 3/30/21 1 2 3 Santini Rubin Listowel Hector Jane Terri Ticket No. Priority Type of Call 14401 1 Hardware 14410 1 Hardware 14418 1 Hardware 14421 1 OS 14402 1 Password 14403 1 OS 14404 2 Email 14405 1 Password 14406 2 Hardware 14407 2 Email 14408 1 3 Internet 144091 3 Internet 14411 1 3 Email 14412 1 3 Email 14413 2 Internet 14414 2 Internet 14415 1 3 Password 14416 2 Email 14417 1 Email 14419 1 3 OS 14420 2 Hardware 14422 3 Internet 14423 1 Hardware Benton Jamie Operator ID File No. 1 14401-1-1 2 14410-1-2 1 14418-1-1 1 14421-1-1 2 14402-1-2 2 14403-1-2 1 14404-2-1 3 14405-1-3 4 14406-2-4 4 14407-2-4 4 14408-3-4 2 14409-3-2 1 14411-3-1 1 14412-3-1 3 14413-2-3 3 14414-2-3 2 14415-3-2 2 14416-2-2 1 14417-1-1 4 14419-3-4 3 14420-2-3 2 14422-3-2 4 14423-1-4 Number of Active calls: Number of Closed calls: Last Name First Name Santini Hector Rubin Jane Santini Hector Santini Hector Rubin Jane Rubin Jane Santini Hector Listowel Terri Benton Jamie Benton Jamie Benton Jamie Rubin Jane Santini Hector Santini Hector Listowel Terri Listowel Terri Rubin Jane Rubin Jane Santini Hector Benton Jamie Listowe Terri Rubin Jane Benton Jamie Time Spent Status 2.25 hrs Closed 3.25 hrs Closed 2.25 hrs Active 2.25 hrs Closed 0.25 hrs Closed 0.5 hrs Closed 1.25 hrs Closed 0.25 hrs Closed 1.75 hrs Active 1. hrs Closed 0.5 hrs Closed 0.5 hrs Closed 1. hrs Closed 0.5 hrs Closed 0.75 hrs Closed 1.25 hrs Closed 0.5 hrs Closed 0.75 hrs Active 1.25 hrs Active 1.75 hrs Active 1.25 hrs Closed 0.75 hrs Active 1. hrs Active {} Operator Summary RSR Computer Services Help Desk Status Report ID Calls Operators Last Name First Name 1 2 3 4 7 7 4 5 Total Time 10.75 6.5 3.5 6 Avg Time 1.54 0.93 0.88 1.20 7 16 Date 3/1/21 3/10/21 3/22/21 3/26/21 3/2/21 3/3/21 3/3/21 3/5/21 3/5/21 3/5/21 3/8/21 3/9/21 3/12/21 3/12/21 3/15/21 3/15/21 3/16/21 3/17/21 3/18/21 3/23/21 3/26/21 3/29/21 3/30/21 1 2 3 Santini Rubin Listowel Hector Jane Terri Ticket No. Priority Type of Call 14401 1 Hardware 14410 1 Hardware 14418 1 Hardware 14421 1 OS 14402 1 Password 14403 1 OS 14404 2 Email 14405 1 Password 14406 2 Hardware 14407 2 Email 14408 1 3 Internet 144091 3 Internet 14411 1 3 Email 14412 1 3 Email 14413 2 Internet 14414 2 Internet 14415 1 3 Password 14416 2 Email 14417 1 Email 14419 1 3 OS 14420 2 Hardware 14422 3 Internet 14423 1 Hardware Benton Jamie Operator ID File No. 1 14401-1-1 2 14410-1-2 1 14418-1-1 1 14421-1-1 2 14402-1-2 2 14403-1-2 1 14404-2-1 3 14405-1-3 4 14406-2-4 4 14407-2-4 4 14408-3-4 2 14409-3-2 1 14411-3-1 1 14412-3-1 3 14413-2-3 3 14414-2-3 2 14415-3-2 2 14416-2-2 1 14417-1-1 4 14419-3-4 3 14420-2-3 2 14422-3-2 4 14423-1-4 Number of Active calls: Number of Closed calls: Last Name First Name Santini Hector Rubin Jane Santini Hector Santini Hector Rubin Jane Rubin Jane Santini Hector Listowel Terri Benton Jamie Benton Jamie Benton Jamie Rubin Jane Santini Hector Santini Hector Listowel Terri Listowel Terri Rubin Jane Rubin Jane Santini Hector Benton Jamie Listowe Terri Rubin Jane Benton Jamie Time Spent Status 2.25 hrs Closed 3.25 hrs Closed 2.25 hrs Active 2.25 hrs Closed 0.25 hrs Closed 0.5 hrs Closed 1.25 hrs Closed 0.25 hrs Closed 1.75 hrs Active 1. hrs Closed 0.5 hrs Closed 0.5 hrs Closed 1. hrs Closed 0.5 hrs Closed 0.75 hrs Closed 1.25 hrs Closed 0.5 hrs Closed 0.75 hrs Active 1.25 hrs Active 1.75 hrs Active 1.25 hrs Closed 0.75 hrs Active 1. hrs Active {}