Find Jobs
Hire Freelancers

Sophisticated Excel Scraper (Visual Basic) for Electronic Components

$750-1500 USD

Selesai
Disiarkan sekitar 9 tahun yang lalu

$750-1500 USD

Dibayar semasa penghantaran
I need you to create an excel webscraper that scrapes 4 electronic component websites. I do have permission to scrape the sites, so this is not a terms of use violation. I have attached an excel sheet that I prepared in detail. Plese look at the sheet first before reading on. The sheet is password protected, please send me a private message so I can give you the password. The user only puts the information in Sheet "BOM" that is highlighted in blue font color. The other information is calculated at a later point that is self-explanatory. Step 1) User clicks "Map Manufacturers". This means based on the user manufacturer (e.g. "AD") we look up if we have a matching manufacturer (sheet "manufacturer") or a mapping (sheet "mappings") we will try to normalize the user input to something we belive makes sense. In this case "AD" will not hit a manufacturer directly but will match to "Analog Devices" through the mapping table. Unmapped cells are highlighted yellow. Cells without a manufacturer at all are highlighted grey. If a manufacturer is matched and we have a manufacturer article number the column scrape (H) is set to yes, otherwise no. 2) User hits "Scrape". There will have to be a different driver module for every website since the structure is slightly different. The scraper will log in the website with the given credentials. If there are no credentials there will be no login. You will have to handle the login process. When scraping the sheet "Results" is filled with the website results. I have actually put in all the data that are provided by the 3 webshops that I have set to active in the sheet "webshops login". In this case we searched for the term "OP484FS" and got the results: Shop 1: 5 results Shop 2: 3 results Shop 3: 12 results The results are color coded according to the commenting in the sheet. Attention! I think that in order to scrape the information you can not use the overview sites of the websites but you will have to go to every individual detail website. Please consider that you may be sent to the detail website directly if there is only 1 result bypassing the overview website. Based on the results the scraper automativally selects the "Match Best" and "Partial Best" as explained in sheet "Result" column L. 3) Finalize Result After selecting what price he wants the user clicks "finalize result" which will then add the total price at the bottom of the sheet. HOW LONG WILL THIS TAKE? Please give me an estimate of how much time you think this will take. I belive the following could be a guideline: Day 1: project clarification of questions and features Day 2: general framework and handling Day 3: scraper driver 1 Day 4: displaying scraped results in main sheet Day 5: presentation of working prototype and feature discussion Day 6: scraper driver 2 Day 7: scraper driver 3 Day 8: scraper driver 4 Day 9: final implementation Day 10: presentation and bugfixes Day 11: missing feature and missunderstanding implementation Day 12: buffer All in all I think this is half a month of work. PLEASE BE AWARE: I will completely ignore spam offers like "I know PHP, ASP, Photoshop ...". Please take this seriously. I will definitely award the project and the freelancer providing the best concept at a reasonable price point will win this.
ID Projek: 7041203

Tentang projek

20 cadangan
Projek jarak jauh
Aktif 9 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am the only bidders who has full 5 star rating, zero failed projects and 99% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Please provide me with the password for the excel file so that I can look into the details of the project. Thanks, Jay
$900 USD dalam 10 hari
5.0 (607 ulasan)
8.3
8.3
20 pekerja bebas membida secara purata $1,143 USD untuk pekerjaan ini
Avatar Pengguna
A proposal has not yet been provided
$1,473 USD dalam 12 hari
4.9 (339 ulasan)
7.7
7.7
Avatar Pengguna
I specialize in web scraping jobs like this one. You can see on my profile that I have completed many similar jobs. Don't make the mistake of hiring an amateur, who doesn't have the skill set to properly complete this task and will only waste your time. Hire me, a professional with a rock solid reputation and over 8 years of experience specifically in writing scraping code like this. I know what I can and cannot do, and I won't waste your time by saying I can do something that I can't. because I exclusively write scraping code I know what to expect and I will always live up to what I tell you, and will also deliver a higher quality final product than my competitors. This can be done in about a week
$3,157 USD dalam 45 hari
4.9 (65 ulasan)
7.1
7.1
Avatar Pengguna
Hi, I have more than 14 years of exp and I am expert in this kind of Excel Scrapping work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$900 USD dalam 30 hari
4.9 (140 ulasan)
6.4
6.4
Avatar Pengguna
Hi, Can you please the password for the excel fie, so that I can have a look at it? Also I will have a close look at the manufacturers website so that I can ascertain how difficult each website is. I will update my proposal after examining the excel sheet and the websites and give an overview of how I plan to accomplish this task along with the estimated time this project will take.
$999 USD dalam 25 hari
5.0 (5 ulasan)
6.2
6.2
Avatar Pengguna
please send me password of sheet thank you
$1,056 USD dalam 12 hari
5.0 (63 ulasan)
6.0
6.0
Avatar Pengguna
Hello. If you need an EXE tool for Windows, then I'm the perfect candidate for completing your project successful. I have long and strong experience with automation task, like creating bots, tools, automation programs. I'm not a time waster, you will not waste your time, to be sure like 101%, I need to discuss with you in instant messaging like skype, I have questions, many questions to address to you. to make sure I know for sure what you expect. skype - sergiu_s11
$999 USD dalam 7 hari
5.0 (13 ulasan)
5.6
5.6
Avatar Pengguna
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$1,250 USD dalam 20 hari
4.7 (72 ulasan)
6.0
6.0
Avatar Pengguna
Hello, I will take 7 days in total. 1 Day to analyze the websites. Rest 2 Days for Coding Next 1 day discussing the changes if required and the last day in fixing those changes. I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$772 USD dalam 20 hari
4.9 (63 ulasan)
5.5
5.5
Avatar Pengguna
Hello There, Waiting for the Password to take a deep look and give you prices and time. Thanks .
$1,250 USD dalam 20 hari
5.0 (37 ulasan)
5.0
5.0
Avatar Pengguna
Hello I will do this job perfectly assuring professional results as I have created many web scraper and bots, I will work as per your mentioned schedule Ready to start work immediately Regards
$833 USD dalam 12 hari
4.7 (28 ulasan)
4.9
4.9
Avatar Pengguna
Hi, I'm web scraper developer and understood your requirements scraper will log in to website as per credentials and search for right detail web page to scrap. Also, it will act as per condition and direction as per you decide Please share password and more details to start work on sample data before you award this project Thanks
$800 USD dalam 20 hari
5.0 (13 ulasan)
4.8
4.8
Avatar Pengguna
I have developed web scrappers similar to this for an e-commerce website - which needs to pull data from various sites to analyse their cost. I believe this project would take 15 to 20 days to complete and this will be done using Excel VBA. I have over 9 years of experience in Excel and Access VBA. I have developed several Tools, Automation, dashboard, Database CRM and Online Tools using VBA.
$750 USD dalam 20 hari
4.9 (14 ulasan)
4.2
4.2
Avatar Pengguna
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. what is the password for the excel sheet?
$750 USD dalam 10 hari
4.9 (10 ulasan)
3.7
3.7
Avatar Pengguna
Hi, I can scraper for these 4 website, as you have permissions. I have 12 year of experience in vb5/6/.net, and have many projects. I am ready to start now as per your shedule
$1,250 USD dalam 20 hari
5.0 (2 ulasan)
0.0
0.0
Avatar Pengguna
Hi, can you send me a password for your xls file ? And i need to know what sites need to be processed, can you provide me site names ?
$888 USD dalam 20 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I can help you to write this app. I know VB,VBA,C++,C#,PHP and I can do it perfectly and fast. I already wrote software like this and i have necessary skills to complete this project successfully. Contact with me via skype - bournwog. I'm waiting pass and other details
$1,666 USD dalam 14 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. If you like what you see and if our quote fits within your budget then please PM me your response and we will take it on from there. You can also have chat with us using skype with id "sflogics". We are pleased to discuss your requirements and can start it today. Thank you for your time.
$1,000 USD dalam 20 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera GERMANY
Hahnenbach, Germany
5.0
28
Kaedah pembayaran disahkan
Ahli sejak Jul 21, 2011

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.