Create a angular application with below data
where
I need filters from "AMS Status": "Not Tracked" or Tracked, Not used machine ignore
Show dashboard to support data from 2021 to 2025 each year cost break down and total of all assets
{
"Assets": [
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "CA-2022/2822",
"Category Major": "COMPUTER",
"Category Minor": "COMPUTERS",
"Serial Number": "5CG15009KG",
"Model": "500P0PA/HP ZBOOK FIREFLY 15GB MOBILEWORK",
"Asset Description": "Purchase of HP ZBook Firefly 15 G8 Mobile Workstation (10 Nos) and HP 4y NBD Ons",
"Period Year": "Jul-22",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2022/06/30",
"Warranty expiration": "2026/06/29",
"Install Status": "In Use",
"Remarks": "RITM0791427",
"Sub Status": "SCCM Active",
"Date Placed in Service": "1-Jul-22",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "95950",
"Depreciation Reserve": "78224.06",
"YTD Depreciation": "1439.66",
"Depreciation Method Code": "DV45.07P4",
"Units": "1",
"Net Book Value": "17725.94",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.PTS.NSTPI",
"Cost Center": "9796",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "Vertex Techno Solutions (Bangalore) Pvt Ltd.",
"Invoice Number": "2260624",
"Asset Assigned to Person ID": "11044590",
"Asset Assigned to Person Name": "Ninad Alurkar"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2024/3432",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "FYKWT34",
"Model": "5540 XCTO",
"Asset Description": "Dell latitude 5440 XCTO base laptop",
"Period Year": "Jun-24",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2024/05/22",
"Warranty expiration": "2027/05/29",
"Install Status": "In Use",
"Remarks": "In stock info got after audit",
"Sub Status": "SCCM Active",
"Date Placed in Service": "1-Jun-24",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Reserve": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "2410672500",
"Asset Assigned to Person ID": "11036860",
"Asset Assigned to Person Name": "Kumar,Saravana"
},
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "CA-2025/3686",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "3XS8D74",
"Model": "Precision 3591",
"Asset Description": "Dell Precision 3591",
"Period Year": "Jan-25",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2025/01/06",
"Warranty expiration": "2028/01/17",
"Install Status": "In Use",
"Remarks": "In stock info got after audit",
"Sub Status": "SCCM Active",
"Date Placed in Service": "18-Jan-25",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "158740",
"Depreciation Reserve": "28455.5",
"YTD Depreciation": "10581.38",
"Depreciation Method Code": "DV45.07P10",
"Units": "1",
"Net Book Value": "130284.5",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.PTS.NSTPI",
"Cost Center": "9706",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "2410785321"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2022/2705",
"Category Major": "COMPUTER",
"Category Minor": "SERVER",
"Serial Number": " Q3AC-X7X6-V3DA",
"Model": "CISCO ACCESS POINT 802.1 and accessories",
"Asset Description": "Purchase of IT network item - CISCO MERAKI MR46 RADIO ACCESS POINT 802.1, CISCO",
"Period Year": "Jan-22",
"AMS Status": "Not Tracked",
"Warranty Start Date": "No Warranty",
"Warranty expiration": "No Warranty",
"Install Status": "Not Tracked ",
"Remarks": "No Remarks",
"Sub Status": "No Sub Status",
"Date Placed in Service": "1-Jan-22",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "CDW INDIA IT SOLUTIONS PRIVATE LIMITED",
"Invoice Number": "ID-PSIN000384"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "OE-2024/395",
"Category Major": "OFFICEEQUIP",
"Category Minor": "OFFICEEQUIP",
"Serial Number": "-",
"Model": "-",
"Asset Description": "Water Dispenser",
"Period Year": "Nov-24",
"data": "Peripherals",
"AMS Status": "Not Tracked",
"Warranty Start Date": "No Warranty",
"Warranty expiration": "No Warranty",
"Install Status": "Not Tracked ",
"Remarks": "No Remarks",
"Sub Status": "No Sub Status",
"Date Placed in Service": "1-Nov-24",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Reserve": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Citibank Commercial Cards",
"Invoice Number": "71DD5938D6DD4329A0DB"
},
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "LAB PM-2021/067",
"Category Major": "PLANTMCHNR",
"Category Minor": "PLANTMCHNR",
"Serial Number": "-",
"Model": "Standard Probe HC 2A-s",
"Asset Description": "Purchase of Rotroninc instruments",
"Period Year": "Feb-21",
"data": "Peripherals",
"AMS Status": "Not Tracked",
"Warranty Start Date": "No Warranty",
"Warranty expiration": "No Warranty",
"Install Status": "Not Tracked ",
"Remarks": "No Remarks",
"Sub Status": "No Sub Status",
"Date Placed in Service": "1-Feb-21",
"Asset Life": "180",
"Active Asset": "YES",
"Cost": "65600",
"Depreciation Reserve": "37837.17",
"YTD Depreciation": "863.56",
"Depreciation Method Code": "DV18.1P11",
"Units": "1",
"Net Book Value": "27762.83",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.LRL.NSTPI",
"Cost Center": "9749",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "Swan Biotec Pvt. Ltd",
"Invoice Number": "511/20-21"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2022/27789",
"Category Major": "COMPUTER",
"Category Minor": "COMPUTERS",
"Serial Number": "147XYP3",
"Model": "DELL LATITUDE 5420 CTO BASE",
"Asset Description": "Purchase of Dell Dell Latitude 5420 (32 GB) XCTO laptops (5 Nos)",
"Period Year": "May-22",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2022/05/22",
"Warranty expiration": "2025/06/15",
"Install Status": "In Use",
"Remarks": "In stock info got after audit",
"Sub Status": "SCCM Active",
"Date Placed in Service": "31-May-22",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "2110642047",
"Asset Assigned to Person ID": "10084148",
"Asset Assigned to Person Name": "Shashank Kumar"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2025/3816",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "7GW1P24",
"Model": "3680 CTO",
"Asset Description": "Precision 3680 Tower CTO Base - 210-BLLP",
"Period Year": "Apr-25",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2025/03/20",
"Warranty expiration": "2028/03/28",
"Install Status": "In Use",
"Remarks": "",
"Sub Status": "SCCM Active",
"Date Placed in Service": "1-Apr-25",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Reserve": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "2110840378"
},
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "CA-2024/3436",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "CT1VT34",
"Model": "5440XCTO",
"Asset Description": "Dell latitude 5440 XCTO base laptop",
"Period Year": "Jun-24",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2024/05/21",
"Warranty expiration": "2027/05/29",
"Install Status": "In Stock",
"Remarks": "SCTASK1471747-OFF-Ritwik Karan",
"Sub Status": "Available",
"Date Placed in Service": "1-Jun-24",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "83781.67",
"Depreciation Reserve": "35390.23",
"YTD Depreciation": "3930.22",
"Depreciation Method Code": "DV45.07P3",
"Units": "1",
"Net Book Value": "48391.44",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.LRL.NSTPI",
"Cost Center": "9742",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "2410672499",
"Asset Assigned to Person ID": "11053027",
"Asset Assigned to Person Name": "Ritwik Karan"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2021/2364",
"Category Major": "COMPUTER",
"Category Minor": "COMPUTERS",
"Serial Number": "DR8MYD3",
"Model": "DELL MOBILE PRECISION WS 5550 CTO",
"Asset Description": "Purchase of Dell Precision Workstation laptops 4 Nos",
"Period Year": "Jun-21",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2021/06/09",
"Warranty expiration": "2024/06/11",
"Install Status": "In Use",
"Remarks": "RITM0646362-Computer Owner Validation",
"Sub Status": "SCCM Active",
"Date Placed in Service": "11-Jun-21",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "1410671642",
"Asset Assigned to Person ID": "11048076",
"Asset Assigned to Person Name": "Mohamed Haris"
},
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "CA-2022/2795",
"Category Major": "COMPUTER",
"Category Minor": "SERVER",
"Serial Number": "-",
"Model": "MA-INJ-6-Meraki mGig 802.3bt PoE",
"Asset Description": "Purchase of Miraki MR42E Indoor AP with External Antenna Connectors and injector",
"Period Year": "Jun-22",
"data": "Peripherals",
"AMS Status": "Not Tracked",
"Warranty Start Date": "No Warranty",
"Warranty expiration": "No Warranty",
"Install Status": "Not Tracked ",
"Remarks": "No Remarks",
"Sub Status": "No Sub Status",
"Date Placed in Service": "1-Jun-22",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "20164.87",
"Depreciation Reserve": "16650.6",
"YTD Depreciation": "285.42",
"Depreciation Method Code": "DV45.07P3",
"Units": "1",
"Net Book Value": "3514.27",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.LRL.NSTPI",
"Cost Center": "9706",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "Velocis Systems (P) Ltd",
"Invoice Number": "KA/2023/P-000082"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2021/2442",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "4SW8ZD3",
"Model": "DELL MOBILE PRECISION WS 5550 CTO",
"Asset Description": "Purchase of Dell precision laptops 5 Nos",
"Period Year": "Jul-21",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2021/07/09",
"Warranty expiration": "2024/07/11",
"Install Status": "In Use",
"Remarks": "assigned to Contractor",
"Sub Status": "SCCM Active",
"Date Placed in Service": "12-Jul-21",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "1410683987"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2022/2886",
"Category Major": "COMPUTER",
"Category Minor": "COMPUTERS",
"Serial Number": "5CG2256JSF",
"Model": "HP ZFfly15G8 i7-1165G7 15.6 16GB/1T PC",
"Asset Description": "Purchase of HP ZFfly15G8 i7-1165G7 15.6 16GB/1T Laptops (23 Nos)",
"Period Year": "Jul-22",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2022/07/08",
"Warranty expiration": "2026/07/07",
"Install Status": "In Use",
"Remarks": "Asset info. got from DSS-Kushal",
"Sub Status": "SCCM Active",
"Date Placed in Service": "13-Jul-22",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "HP India Sales Pvt. Ltd",
"Invoice Number": "MHI2293301090",
"Asset Assigned to Person ID": "11043700",
"Asset Assigned to Person Name": "Vidyanand Kesti"
},
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "CA-2023/3142",
"Category Major": "COMPUTER",
"Category Minor": "COMPUTERS",
"Serial Number": "CW76H4TTB00542",
"Model": "24 LS24R650FDWXXL\"",
"Asset Description": "Purchase of standard IT accessories,H390 Logitech Headset,Logitech MK235 keyboar",
"Period Year": "Feb-23",
"data": "Peripherals",
"AMS Status": "Not Tracked",
"Warranty Start Date": "No Warranty",
"Warranty expiration": "No Warranty",
"Install Status": "Not Tracked ",
"Remarks": "No Remarks",
"Sub Status": "No Sub Status",
"Date Placed in Service": "1-Feb-23",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "12300",
"Depreciation Reserve": "9125.26",
"YTD Depreciation": "257.84",
"Depreciation Method Code": "DV45.07P11",
"Units": "1",
"Net Book Value": "3174.74",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.PTS.NSTPI",
"Cost Center": "9793",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "RAKESH TRADING COMPANY",
"Invoice Number": "RTC2223G17420",
"Asset Assigned to Person ID": "11048410",
"Asset Assigned to Person Name": "SIDDHARTH SHRIWASTAV"
},
{
"Book Type Code": "DIC IND CORP",
"Asset Number": "CA-2024/3359",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "DM00S14",
"Model": "5440 XCTO",
"Asset Description": "Dell Latitude 5440 XCTO",
"Period Year": "Feb-24",
"data": "Destaco offboarded from dover and Buybac",
"AMS Status": "Not used machine",
"Warranty Start Date": "No Warranty",
"Warranty expiration": "No Warranty",
"Install Status": "Not Tracked ",
"Remarks": "No Remarks",
"Sub Status": "No Sub Status",
"Date Placed in Service": "17-Feb-24",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "84174",
"Depreciation Reserve": "44621.91",
"YTD Depreciation": "3212.32",
"Depreciation Method Code": "DV45.07P11",
"Units": "1",
"Net Book Value": "39552.09",
"Location": "IN.KARNATAKA.NA.BANGALORE.BANGALORE.PTS.NSTPI",
"Cost Center": "9731",
"Entity": "1310",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "1411045245"
},
{
"Book Type Code": "DIC IND USGAAP",
"Asset Number": "CA-2021/2544",
"Category Major": "COMPUTER",
"Category Minor": "LAPTOP",
"Serial Number": "5TT71F3",
"Model": "DELL LATITUDE 5420 CTO BASE",
"Asset Description": "Purchase of Dell Latitude 5420 (32GB) (32 Nos)",
"Period Year": "Aug-21",
"data": "Laptop/Desktop Avaiable in AMDB",
"AMS Status": "Tracked",
"Warranty Start Date": "2021/08/05",
"Warranty expiration": "2024/08/07",
"Install Status": "In Use",
"Remarks": "In stock info got after audit",
"Sub Status": "SCCM Active",
"Date Placed in Service": "7-Aug-21",
"Asset Life": "60",
"Active Asset": "YES",
"Cost": "0",
"Depreciation Method Code": "STL",
"Units": "1",
"Net Book Value": "0",
"PO Number": "NULL",
"Vendor Name": "Dell International Services India Private Limited",
"Invoice Number": "1410694755",
"Asset Assigned to Person ID": "11048974",
"Asset Assigned to Person Name": "SHRUTHI D"
}
]
}