Develop a solution to automate the process of comparing hardware/software inventory with the product specific lifecycle dates. This comparison will provide information or output to easily determine when hardware or software components are going end of support or face a vulnerability.
The solution can be Excel based or custom programmed software. The Inventory Data Sources will come from an Excel file and the Product Lifecycle Data Source to be compared against will also be in an Excel format.
The output of generating the comparison will reflect any product match within 8 different groups. These groups will include:
1. Products that are currently end of sale
2. Products that are currently end of hardware support
3. Products that are currently end of software support
4. Products that are currently end of manufacturer support
5. Products that will be end of sale within 12 months
6. Products that will be end of hardware support within 12 months
7. Products that will be end of software support within 12 months
8. Products that will be end of manufacturer support within 12 months
Project will be awarded with two milestones. The first milestone will be after creation of the solution and a sample comparison has been generated. The second milestone will be awarded after a large inventory has been loaded with testing and acceptance.
29 freelancers estão ofertando em média $152 para esse trabalho
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
hi I'll use Google sheet with a dashboard to get all the update at a glance. and able to complete it less then a week. let's start. and send me a sample data sheet. Regards Atiar T.