Find Jobs
Hire Freelancers

Automate hardware and software inventory comparison with product lifecycle dates in Excel

$30-250 USD

Terminado
Publicado hace alrededor de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 18726965

Información sobre el proyecto

26 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 samples for you there. Please send me a message so we can discuss further details of your project
$95 USD en 3 días
5,0 (51 comentarios)
5,9
5,9
26 freelancers están ofertando un promedio de $155 USD por este trabajo
Avatar del usuario
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 sheet. Ready to start. Thanks
$200 USD en 3 días
4,9 (280 comentarios)
7,7
7,7
Avatar del usuario
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 reports in Excel (a separate Excel file) and in a pdf format respectively. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident to complete your project as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $200 and can deliver within three days (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$200 USD en 3 días
4,9 (235 comentarios)
7,5
7,5
Avatar del usuario
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 of format being as expected), the macro would then process the information and generate 8 different Worksheets pertaining to 8 different groups listed in Project Description. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the Inventory Data Source and Product Lifecycle Data Source files - I would come up with the solution as required. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
$90 USD en 3 días
5,0 (194 comentarios)
6,9
6,9
Avatar del usuario
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 you will inserts data and receive in a dashboard or pivot the information you want. Please check my portfolio to see my work. Thanks!
$230 USD en 5 días
4,9 (42 comentarios)
6,4
6,4
Avatar del usuario
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.
$155 USD en 3 días
5,0 (115 comentarios)
6,4
6,4
Avatar del usuario
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 checkout my reviews and project completion rate to have some idea about the quality of my previous works, Would be great if you can provide a sample of your workbook for more context. Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to chat further and work on your project.
$150 USD en 3 días
5,0 (106 comentarios)
6,3
6,3
Avatar del usuario
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 than 7 years experience in "Excel, Excel Macros, Excel VBA, Python". I will make sure the best quality service. Let us work together. Best regards, Yang L.
$140 USD en 1 día
4,8 (118 comentarios)
6,1
6,1
Avatar del usuario
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 message on chat.
$111 USD en 3 días
4,7 (81 comentarios)
6,3
6,3
Avatar del usuario
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 100% completion rate and 5-star feedback on over 80 projects. Jan
$111 USD en 5 días
5,0 (96 comentarios)
6,0
6,0
Avatar del usuario
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 engineering etc. I will be happy to discuss in detail how I am highly suitable for this project.
$90 USD en 1 día
4,7 (56 comentarios)
5,5
5,5
Avatar del usuario
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 would be best is to take your input data and have a tab for each of the areas below, we can make this update every time the file is opened to make sure you always have the latest info available. Another options would be to create a filter page which updates the results based on the criteria that you selected below. I'm fully on board with your two milestone setup too, that works well for me. If you have any more questions please get it touch and we can discuss (no pressure to award if we chat - I can just give my advice). Thanks in advance, Chris
$150 USD en 3 días
5,0 (10 comentarios)
4,8
4,8
Avatar del usuario
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 your requirement. Regards.
$120 USD en 5 días
5,0 (5 comentarios)
4,1
4,1
Avatar del usuario
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 program will be provided with import raw data & generate report button to execute the task. for your reference on my excel ability & Client Review please refer to below link: https://www.freelancer.com/u/gsanggara Please ping me to discuss further. I am available & ready start work immediately. thanks. Best Regards, GS Anggara *** Customer Satisfaction is My "FIRST PRIORITY" ***
$80 USD en 2 días
4,9 (26 comentarios)
4,2
4,2
Avatar del usuario
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 have the name of the product and maybe its index to facilitate finding it within the product database, or a message box with lists within or other buttons that allowed to browse through the lists that had the 8 groups. However another probably simpler option would be to just create a new tab that updated automatically and only showed those that were within the groups identifying them as such. Of course within the database a color coding or a good filtering system would be able to do the same. It would all depend on what would be easier for you or the people under you that would be using it. Hope to hear from you soon.
$100 USD en 1 día
5,0 (13 comentarios)
3,8
3,8
Avatar del usuario
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.
$250 USD en 7 días
5,0 (9 comentarios)
3,8
3,8
Avatar del usuario
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 comparison of excel data and expected output if values for any of the columns does not match. Will be glad to work with you, kindly let me know for more information.
$140 USD en 4 días
5,0 (7 comentarios)
3,4
3,4
Avatar del usuario
Hey, there At first, I thought to create a system off excel but then the other system will have to be connected to excel and probably an intermediary database would have to be used for that which is just over complication for now. Unless you want to access the reports remotely or use some pretty graphic to visualize the data. I can create a VB script in your excel file to generate this reports section. I`ll complete the task in 3 days and agree to the payment terms of two milestones of $125 each Best, Mike
$277 USD en 3 días
4,8 (1 comentario)
2,0
2,0
Avatar del usuario
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. Relatively new to Freelancer to please consider giving me a chance
$133 USD en 5 días
4,1 (3 comentarios)
2,3
2,3
Avatar del usuario
hi, base on the description, all the 8 output will be matched with the DATE that been input by the user please check our youtube channel "EXCEL DAHSYAT" for our previous project thank you
$133 USD en 3 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
I can get this done for you, I can do it in R or python , don't worry the output will be in excel file format if you insist I can also get it done in excel
$250 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Tega Cay, United States
5,0
3
Forma de pago verificada
Miembro desde may 13, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.