Delau TE Rulet Formula Bar Keep Exit New Options Gridlines Headings Zoom 100 Normal Page Break Page Custom Preview Layout Views Workbook Views Sheet View Show Zo 02 X 8 1 Create Date Association Name 2 312712021 1234 Market Court 3 3/29/2021 1234 Market Court 4 4/8/2021 1234 Market Court 5 4118/2021 1234 Market Court 6 223/2021 1234 Market Court 7 2/23/2021 1234 Market Court 8 2127/2021 1234 Market Court 9 3/8/2021 1234 Market Court 10 W 2021 1234 Market Court 11 4/1/2021 417 Apple Court 12 4/5/2021 417 Apple Court 13 3/8/2021 417 Apple Court 14 3127/2021 417 Apple Court 15 4112021 Americana 15 462021 Americana 17 2/14/2021 Crescent Moons 18 2/182021 Crescent Moons 19 4/5/2021 Crescent Moons 20 417/2021 Marina Vilage 21 47712021 Marina Viage 22 4/10/2021 Marina Village 23 4/10/2021 Marina Village 24 4/10/2021 Marina Village 4/11/2021 Marina Viage 26 412021 Marina Village 27 4/18/2021 Marina Viage 28 4/19/2021 Marina Vitage 29 4/20/2021 Marina Vilage Requests G Cient Service Special Category Name Status Late or Okay Full Name Title IGeneral Open Rick Litchsher Landscape requests Maintenance Open Nancy Show Mulch on Kingsury Maintenance Open Joone Burnes Need copy of insuran Incidents Open Gene Simmons Roof inspection Neede Maintenance In Process Mike Dodson Power Wash Security In Process Mike Dodson entry system Maintenance In Process Mike Dodson Elevator Maintenance In Process Mike Doldson entry system General In Process Mike Doldson Trash Room Maintenance in Process Michael Boley Window leak in unkt 10 Maintenance In Process Maria Garza Leaf Blowing at 815am Maintenance Open Rta Chary Building Maintenance General Open Bruce Scatter Additional Solar Panel Maintenance In Process Khader Sahn Leaking Pipe Nores Maintenance Process Christopher Kinsington termit issue Maintenance Open Marsha Dotty Regulus Choparling Maintenance Open Tom Jonckles Lagoon mess General Open Preet Gomez Master hos policy copy Wantanance Open Test Tenant TEST Request from a Manesance Open Marko Watanam Garage Drywal Repair Maintenance Open Susan McDonald Removal of tree branch Maintenance Open Susan McDonald Repending of front door Maintenance Open Susan McDonald Touch up paint ont real Maintenance Open Thomas Chariot Lamp Postberg pushe General Open Marko Watanam Units Currently being R Maintenance Open Susan McDonald Broken Garage door General Open Mary Rodriguez TR THU Maintenance Open Robert Holmes Neighborhood Watch Client Service Specialists OST Tours EE Databse Grading Rubrics O Type here to search Share Comme Zoom 100% Zoom to Selection Split CL View Side by Side Hide DI Synchronous Scrolling New Arrange Freeze Switch Window All Panes Unhide to Reset Window Position Windows Macios Zoom Window Macros Instructions 11. In Column C Use a Vlookup to find the Client Service Specialist (using the table on the customer service reptab 2. In Column F-You will use a nested if to determine if the requests LATE Or OKAY Here are the parameters a. If the status is OPEN, it is late if the create date is more than 3 days from today b. If the status is IN PROCESS-it is late if the create date is more than 60 days from today 13. Format the information as a table - any color 4. Use the pivot table function to determine what type of requests there are and then create a pivot chartCategory Name) (Puttints own sheet and name the sheet with the pivot table and chart 04 Pivot Table sroom 9 Robris a Default ml Rul H Keep Exit New Options Normal Page Break Page Custom Preview Layout Views Gric Sheet View Workbook Views B2 X fax Sarah Parkinson D . 1 Client 1 Client Service Specialist M 2 1234 Market Court Sarah Parkinson 3 417 Apple Court Gwen Stark 4 Americana Chris Everett 5 Borondo Court Tiago Acuna 6 California Crest Mario Halverson 7 Crescent Moons Lenore Cates 8 Marina Village Rosario Leon 9 Orchid Park Phoebe Pratt 10 Ouail Ridge Kara Kent 11 San Jose Renaissance Lana Luthor 12 Seaside Court Pablo Jimenez 13 Sierra Commons Sofia Alcala 14 Siesta Lane Olivia Bernard 15 16 17 18 19 20 23 Requests Client Service Specialists OST Tours EE Databse Gradi Type here to search o Delau TE Rulet Formula Bar Keep Exit New Options Gridlines Headings Zoom 100 Normal Page Break Page Custom Preview Layout Views Workbook Views Sheet View Show Zo 02 X 8 1 Create Date Association Name 2 312712021 1234 Market Court 3 3/29/2021 1234 Market Court 4 4/8/2021 1234 Market Court 5 4118/2021 1234 Market Court 6 223/2021 1234 Market Court 7 2/23/2021 1234 Market Court 8 2127/2021 1234 Market Court 9 3/8/2021 1234 Market Court 10 W 2021 1234 Market Court 11 4/1/2021 417 Apple Court 12 4/5/2021 417 Apple Court 13 3/8/2021 417 Apple Court 14 3127/2021 417 Apple Court 15 4112021 Americana 15 462021 Americana 17 2/14/2021 Crescent Moons 18 2/182021 Crescent Moons 19 4/5/2021 Crescent Moons 20 417/2021 Marina Vilage 21 47712021 Marina Viage 22 4/10/2021 Marina Village 23 4/10/2021 Marina Village 24 4/10/2021 Marina Village 4/11/2021 Marina Viage 26 412021 Marina Village 27 4/18/2021 Marina Viage 28 4/19/2021 Marina Vitage 29 4/20/2021 Marina Vilage Requests G Cient Service Special Category Name Status Late or Okay Full Name Title IGeneral Open Rick Litchsher Landscape requests Maintenance Open Nancy Show Mulch on Kingsury Maintenance Open Joone Burnes Need copy of insuran Incidents Open Gene Simmons Roof inspection Neede Maintenance In Process Mike Dodson Power Wash Security In Process Mike Dodson entry system Maintenance In Process Mike Dodson Elevator Maintenance In Process Mike Doldson entry system General In Process Mike Doldson Trash Room Maintenance in Process Michael Boley Window leak in unkt 10 Maintenance In Process Maria Garza Leaf Blowing at 815am Maintenance Open Rta Chary Building Maintenance General Open Bruce Scatter Additional Solar Panel Maintenance In Process Khader Sahn Leaking Pipe Nores Maintenance Process Christopher Kinsington termit issue Maintenance Open Marsha Dotty Regulus Choparling Maintenance Open Tom Jonckles Lagoon mess General Open Preet Gomez Master hos policy copy Wantanance Open Test Tenant TEST Request from a Manesance Open Marko Watanam Garage Drywal Repair Maintenance Open Susan McDonald Removal of tree branch Maintenance Open Susan McDonald Repending of front door Maintenance Open Susan McDonald Touch up paint ont real Maintenance Open Thomas Chariot Lamp Postberg pushe General Open Marko Watanam Units Currently being R Maintenance Open Susan McDonald Broken Garage door General Open Mary Rodriguez TR THU Maintenance Open Robert Holmes Neighborhood Watch Client Service Specialists OST Tours EE Databse Grading Rubrics O Type here to search Share Comme Zoom 100% Zoom to Selection Split CL View Side by Side Hide DI Synchronous Scrolling New Arrange Freeze Switch Window All Panes Unhide to Reset Window Position Windows Macios Zoom Window Macros Instructions 11. In Column C Use a Vlookup to find the Client Service Specialist (using the table on the customer service reptab 2. In Column F-You will use a nested if to determine if the requests LATE Or OKAY Here are the parameters a. If the status is OPEN, it is late if the create date is more than 3 days from today b. If the status is IN PROCESS-it is late if the create date is more than 60 days from today 13. Format the information as a table - any color 4. Use the pivot table function to determine what type of requests there are and then create a pivot chartCategory Name) (Puttints own sheet and name the sheet with the pivot table and chart 04 Pivot Table sroom 9 Robris a Default ml Rul H Keep Exit New Options Normal Page Break Page Custom Preview Layout Views Gric Sheet View Workbook Views B2 X fax Sarah Parkinson D . 1 Client 1 Client Service Specialist M 2 1234 Market Court Sarah Parkinson 3 417 Apple Court Gwen Stark 4 Americana Chris Everett 5 Borondo Court Tiago Acuna 6 California Crest Mario Halverson 7 Crescent Moons Lenore Cates 8 Marina Village Rosario Leon 9 Orchid Park Phoebe Pratt 10 Ouail Ridge Kara Kent 11 San Jose Renaissance Lana Luthor 12 Seaside Court Pablo Jimenez 13 Sierra Commons Sofia Alcala 14 Siesta Lane Olivia Bernard 15 16 17 18 19 20 23 Requests Client Service Specialists OST Tours EE Databse Gradi Type here to search o