Concluído

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

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.

Habilidades: Excel, Excel Macros, Excel VBA, Python

Veja mais: network inventory advisor, it asset management software free, snipe-it, asset management software free download full version, simple asset management software, free fixed asset management software, it inventory management software free, manageengine assetexplorer, command line hardware software inventory, automate query software, officer hardware software support, command line installed software inventory, diploma hardware software institute bangladesh, program hardware store inventory, perform software inventory command, hardware store inventory, matlab hardware software interfacing, php mysql check check software inventory, project software analysis comparison writing, electronics hardware software design freelance projects philippines

Acerca do Empregador:
( 1 comentário ) Tega Cay, United States

ID do Projeto: #18726965

Concedido a:

urielbaray

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 Mais

$95 USD em 3 dias
(23 Comentários)
4.7

29 freelancers estão ofertando em média $152 para esse trabalho

bouslimi1979

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 Mais

$200 USD in 3 dias
(266 Comentários)
7.5
paris2785

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 Mais

$200 USD in 3 dias
(176 Comentários)
7.0
ksriniravi

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 Mais

$90 USD in 3 dias
(163 Comentários)
6.7
seoguru17

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 Mais

$111 USD in 3 dias
(73 Comentários)
6.3
macroPOL

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 Mais

$111 USD in 5 dias
(92 Comentários)
5.9
periyannas

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 in 3 dias
(92 Comentários)
6.1
sloker18

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 Mais

$150 USD in 3 dias
(72 Comentários)
5.5
aubrey03

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]

$60 USD in 2 dias
(89 Comentários)
5.5
lightingdavid

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 Mais

$140 USD em 1 dia
(48 Comentários)
5.7
Walshie1987

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 Mais

$150 USD in 3 dias
(10 Comentários)
4.7
antoinepal

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 Mais

$230 USD in 5 dias
(22 Comentários)
5.0
daniyal3214

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 Mais

$90 USD em 1 dia
(46 Comentários)
5.3
swajantalukdar

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 in 7 dias
(9 Comentários)
3.8
dungchan44

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 Mais

$30 USD em 1 dia
(13 Comentários)
3.7
SousaTranslation

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 Mais

$100 USD em 1 dia
(13 Comentários)
3.7
sumitfury

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 Mais

$140 USD in 4 dias
(7 Comentários)
3.4
gsanggara

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 Mais

$80 USD in 2 dias
(19 Comentários)
3.7
dionisiotumbaga

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 Mais

$120 USD in 5 dias
(4 Comentários)
3.1
Yashin1224

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

$133 USD em 1 dia
(2 Comentários)
2.1
mythtaker672

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. Mais

$133 USD in 5 dias
(2 Comentários)
2.2