Find Jobs
Hire Freelancers

Sophisticated Excel Scraper (Visual Basic) for Electronic Components

$750-1500 USD

Færdiggjort
Slået op cirka 9 år siden

$750-1500 USD

Betales ved levering
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.
Projekt-ID: 7041203

Om projektet

20 forslag
Projekt på afstand
Aktiv 9 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
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 på 10 dage
5,0 (607 anmeldelser)
8,3
8,3
20 freelancere byder i gennemsnit $1.143 USD på dette job
Brug Avatar.
A proposal has not yet been provided
$1.473 USD på 12 dage
4,9 (339 anmeldelser)
7,7
7,7
Brug Avatar.
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 på 45 dage
4,9 (65 anmeldelser)
7,1
7,1
Brug Avatar.
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 på 30 dage
4,9 (140 anmeldelser)
6,4
6,4
Brug Avatar.
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 på 25 dage
5,0 (5 anmeldelser)
6,2
6,2
Brug Avatar.
please send me password of sheet thank you
$1.056 USD på 12 dage
5,0 (63 anmeldelser)
6,0
6,0
Brug Avatar.
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 på 7 dage
5,0 (13 anmeldelser)
5,6
5,6
Brug Avatar.
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 på 20 dage
4,7 (72 anmeldelser)
6,0
6,0
Brug Avatar.
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 på 20 dage
4,9 (63 anmeldelser)
5,5
5,5
Brug Avatar.
Hello There, Waiting for the Password to take a deep look and give you prices and time. Thanks .
$1.250 USD på 20 dage
5,0 (37 anmeldelser)
5,0
5,0
Brug Avatar.
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 på 12 dage
4,7 (28 anmeldelser)
4,9
4,9
Brug Avatar.
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 på 20 dage
5,0 (13 anmeldelser)
4,8
4,8
Brug Avatar.
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 på 20 dage
4,9 (14 anmeldelser)
4,2
4,2
Brug Avatar.
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 på 10 dage
4,9 (10 anmeldelser)
3,7
3,7
Brug Avatar.
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 på 20 dage
5,0 (2 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 20 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 14 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 20 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for GERMANY
Hahnenbach, Germany
5,0
28
Betalingsmetode verificeret
Medlem siden jul. 21, 2011

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.