Spreadsheet: 685078d1593705647-count-basis-date-computerreplacement
Sheet: Sheet1

 | active |  |  | 1 |  |  | 2.9 |  | < 3 years |  | # of desktops
 | new |  |  |  | icon symbol refers to computer status |  | 5 |  | > 3 years <= 4 years |  | # of laptops
 | replace |  |  |  |  |  | 6 |  | > 4 years
 | defect
 | inactive
 | decom
icon | Status | User name | type | OS | Brand | model |  | Date |  |  |  |  |  |  |  |  |  |  | CPU | RAM GB | HDD
 | active |  | desktop | 10 Pro | Lenovo | M720q |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8400T | 8 | 500
 | active |  | desktop | 10 Enterprise | HP | EliteDesk 800 G4 SFF |  | 2018-12-28 00:00:00
 | replace |  | laptop | 10 Enterprise | HP | ProBook 450 G1 |  | 2014-07-11 00:00:00
 | active |  | laptop | 10 Enterprise | HP | EliteBook 850 G4 |  | 2018-12-28 00:00:00
 | active |  | desktop | 10 Pro | HP | ProDesk 600 G3 SFF |  | 2017-08-11 00:00:00
 | replace |  | laptop | 10 Enterprise | Lenovo | 80MJ |  | 2016-02-06 00:00:00
 | active |  | desktop | 10 Pro | HP | EliteDesk 800 G3 SFF |  | 2018-01-26 00:00:00
 | replace |  | desktop | 10 Pro | HP | ProDesk 400 G4 MT |  | 2017-08-11 00:00:00
 | replace |  | desktop | 10 Pro | HP | ProDesk 400 G4 MT |  | 2017-08-11 00:00:00
 | active |  | desktop | 7 Pro | HP | compaq 6200 Pro MT |  | 2012-07-31 00:00:00
 | active |  | desktop | 10 Enterprise | HP | EliteDesk 800 G3 SFF |  | 2018-05-31 00:00:00
 | replace |  | laptop | 7 Pro | HP | ProBook 470 G3 |  | 2016-04-22 00:00:00
 | replace |  | desktop | 7 Pro | HP | Compaq Pro 6300 MT |  | 2013-12-20 00:00:00
 | active |  | desktop | 10 Enterprise | Lenovo | M720q |  | 2019-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8400T | 8 | 500
 | replace |  | desktop | 10 Enterprise | HP | ProDesk 400 G2 MT |  | 2016-02-01 00:00:00
 | replace |  | laptop | 7 Pro | Dell | Latitude E5530 |  | 2013-07-07 00:00:00
 | replace |  | desktop | 7 Pro | HP | Compaq Pro 6300 MT |  | 2013-01-14 00:00:00
 | active |  | desktop | 10 Enterprise | HP | EliteDesk 800 G3 SFF |  | 2018-05-31 00:00:00
 | active |  | desktop | 10 Enterprise | HP | EliteDesk 800 G3 SFF |  | 2018-05-31 00:00:00
 | replace |  | laptop | 7 Pro | HP | Elitebook 820 G2 |  | 2016-03-25 00:00:00
 | replace |  | desktop | 10 Pro | HP | EliteDesk 800 G3 SFF |  | 2018-01-26 00:00:00
 | replace |  | laptop | 10 Enterprise | Acer | Aspire ES 15 |  | 2017-11-22 00:00:00
 | new |  | laptop | 10 Enterprise | Lenovo | T490s |  | 2017-11-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5 | 16 | 1000
 | defect |  | desktop | 7 Pro | HP | ProDesk 400 G2 MT |  | 2015-11-17 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2013-11-08 00:00:00
 | replace |  | laptop | 7 Pro | HP | ProBook 450 G1 |  | 2014-07-11 00:00:00
 | replace |  | desktop | 7 Pro | HP | EliteDesk 800 G1 DM |  | 2014-11-21 00:00:00
 | active |  | desktop | 10 Pro | HP | EliteDesk 800 G3 SFF |  | 2018-05-31 00:00:00
 | replace |  | laptop | 10 Enterprise | HP | EliteBook 840 G5 |  | 2018-11-16 00:00:00
 | defect |  | desktop | 7 Pro | HP | compaq 6200 Pro MT |  | 2012-02-15 00:00:00
 | replace |  | desktop | 10 Enterprise | HP | EliteDesk 800 G4 SFF |  | 2018-12-28 00:00:00
 | replace |  | desktop | 10 Enterprise | HP | EliteDesk 800 G4 SFF |  | 2018-12-28 00:00:00
 | replace |  | desktop | 7 Pro | HP | Compaq Elite 8300 MT |  | 2013-04-12 00:00:00
 | replace |  | desktop | 10 Enterprise | HP | EliteDesk 800 G4 SFF |  | 2018-12-28 00:00:00
 | active |  | desktop | 10 Pro | HP | ProDesk 400 G4 MT |  | 2018-01-03 00:00:00
 | replace |  | laptop | 10 Enterprise | ASUS | D550CA - SX280H |  | 2014-05-15 00:00:00
 | replace |  | desktop | 7 Pro | HP | ProDesk 400 G2 MT |  | 2015-11-17 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2013-01-14 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2014-01-21 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2014-01-24 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2012-10-25 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2013-01-14 00:00:00
 | active |  | laptop | 10 Enterprise | HP | EliteBook 850 G4 |  | 2018-12-28 00:00:00
 | active |  | laptop | 10 Pro | Lenovo | T490s |  | 2020-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8265U | 16 | 1000
 | active |  | laptop | 7 Pro | HP | EliteBook 840 G3 |  | 2016-12-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8265U | 16 | 1TB
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2014-01-21 00:00:00
 | replace |  | laptop | 10 Enterprise | HP | EliteBook 840 G4 |  | 2018-02-16 00:00:00
 | replace |  | desktop | 7 Pro | HP | compaq 6300 Pro MT |  | 2012-11-09 00:00:00
 | active |  | laptop | 10 Pro | Lenovo | T490s |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8265U | 8 | 500
 | active |  | laptop | 10 Enterprise | HP | EliteBook 850 G4 |  | 2018-03-16 00:00:00
 | active |  | desktop | 10 Pro | HP | EliteDesk 800 G2 mini |  | 2016-08-05 00:00:00
 | replace |  | laptop | 10 Enterprise | Samsung | NP-R730 |  | 2011-07-01 00:00:00
 | new |  | laptop | 10 Pro | Lenovo | T490s |  | 2020-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 16 | 1000
 | active |  | desktop | 10 Pro | HP | EliteDesk 800 G3 SFF |  | 2018-05-31 00:00:00
 | active |  | laptop | 10 Enterprise | HP | EliteBook 850 G4 |  | 2018-12-28 00:00:00
 | replace |  | desktop | 10 Pro | HP | EliteDesk 800 G1 DM |  | 2015-01-12 00:00:00
 | replace |  | desktop | 10 Pro | HP | ProDesk 400 G3 MT |  | 2017-05-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-7500 | 8
 | active |  | laptop | 10 Enterprise | HP | 15-BW005NB |  | 2018-04-14 00:00:00
 | decom |  | desktop | 10 Pro | HP | ProDesk 400 G4 MT |  | 2018-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-7500 | 8 | 500
 | replace |  | desktop | 10 Enterprise | HP | EliteDesk 800 G3 SFF |  | 2018-01-26 00:00:00
 | replace |  | laptop | 7 Pro | HP | EliteBook 840 G1 |  | 2014-12-30 00:00:00
 | replace |  | laptop | 7 Pro | Dell | Latitude 6430u |  | 2014-05-26 00:00:00
 | replace |  | laptop | 10 Pro | HP | EliteBook 840 G3 |  | 2017-08-11 00:00:00
 | replace |  | laptop | 10 Pro | HP | EliteBook 840 G3 |  | 2017-04-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8500T | 16 | 1TB
 | new |  | desktop | 10 Enterprise | Lenovo | M720q |  | 2020-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | i5-8500T | 16 | 1000