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.
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Mai multe
29 freelanceri licitează în medie 152$ pentru acest proiect
Hi, I ll provide an Excel app with macros. Whe re you will select the inventory file, and the file you want to compare with. Click a button and the report with the 8 groups you explained will be generated in a separate Mai multe
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel. I plan to use VBA code that will extract your eight rep Mai multe
Greetings! I can develop an Excel based solution for your requirement. At the click of a button, the user would be prompted to select the 2 input files. After ensuring that right files are selected by user (in terms Mai multe
I will automate hardware and software inventory. I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I might have a few question to discuss so I need you to send a Mai multe
Hello, I am Excel and VBA expert. Coulg ou provide the files: The Inventory Data Sources and the Product Lifecycle Data Source? If you have any questions, I will be happy to answer. Please note that I have 10 Mai multe
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 proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write the marco to compare lifecycle dates and generate report as requested. You’re welcome to chec Mai multe
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]
Hello. How are you? I am highly interested to work on the "Automate hardware and software inventory comparison with product lifecycle dates in Excel". I am a full stack Excel/VBA & Python developer. I have more tha Mai multe
Hi, I'm Chris from Sheffield in the UK and have over 10 years experience with Excel and VBA. I'd love to be able to help with your project and this is something that I've done many times before. What I think wo Mai multe
Hello, I can build the excel you want with the functionality you want using Power Query as i have advanced excel skills and over 8 years in the field. The solution will be a fully automated solution in excel where Mai multe
I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform process automation, dynamic analysis, financial modeling, data engineerin Mai multe
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.
Hello, Sir! I am very happy to put my bid on your project. I have read your requirement carefully. I can do your project by lowest price. So I'll guarantee the best quality and in time. I have full of experience Mai multe
I will have to take a look at your data formatting but overall I would approach this project on Excel with VBA by creating a button somewhere accessible that would output either a new tab with the 8 groups which would Mai multe
Have rich expertise in writing Automation Bots for different processes and Web applications build on JAVA and Python. Will be able to create the process, which will compare the values in Excel, kindly share the demo co Mai multe
Hi Fortalinx, I am excel freelancer, very interested to work on your project. I will create excel based program to compare hardware or software components against product lifetime as per your project desc, this progr Mai multe
Hi, I am interested. May I propose to create a user friendly MS Access database for the purpose. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about you Mai multe
Hi. I read your proposal. I have your project. I have rich experience for excel macro develop. You may have several sheets. I will do my best. thank
Computer Engineer with 5 years of professional Excel/Access VBA. I can determine if Excel or Access is appropriate based on the size of the files and number of entries. However, if you prefer Excel, I can also do that. Mai multe