Finalizat

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.

Aptitudini: Excel, Excel Macros, Excel VBA, Python

Vezi mai multe: 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

Despre angajator:
( 1 părere ) Tega Cay, United States

ID Proiect: #18726965

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 3 zile
(23 Recenzii)
4.7

29 freelanceri licitează în medie 152$ pentru acest proiect

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(266 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(176 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(163 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(73 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(92 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(92 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(72 recenzii)
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]

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(89 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(48 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(10 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(22 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(46 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(9 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(13 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(13 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(7 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(19 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(4 recenzii)
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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(2 recenzii)
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. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(2 recenzii)
2.2