Suljettu

TOOL TO AUTOMATE CLEAN UP AND FORMATTING OF EXCEL DATA - POSSIBLE WEB SCRAPING OPTION

Please carefully read the below description. The project is looking for bids to create the formatting tool or a combination of the scraping and formatting tool. I will not consider auto bids that do not demonstrate the bidder has looked at the project, data and specifications of work required and is able to produce a tool that I can use on an on-going basis. If the tool includes web scraping, then I would need to be able to specify tracks and dates.

I will wait for a couple of days before accepting the winning bid. To be successful bidder, please include small data sample of what the tool would be able to produce FROM THIS WEBSITE – please do not send me samples of other work from other sites – that is not relevant to see whether you can do this job. Please examine the attached workbook to see how the data is changed.

This is the process that I currently use.

Go to: [login to view URL]

Select meeting – for example - Richmond C – 24/4/2019

And click on the E in the red circle

Number of previous runs to display: ensure “CAREER” is selected

For each race (there is usually 1 -12) I use Firefox and the add-on “TABLE TO EXCEL”

I select all tables, copy selected and then paste into blank excel sheet. I do this for each race and just keep pasting into the same Excel sheet. Once all has been pasted in, then I need to clean up and sort the data – this is the process that required automation.

The tool I need created will allow me to apply it to each of these Excel sheets that I create by the above method. It will get rid of the data that I don’t need, format and arrange columns as per the example workbook I have attached. TAB 1 in the workbook is the data as it is copied from TABLE TO EXCEL. The 2nd TAB is what that data needs to finish up looking like, with the formatting and columns in that order. I have only done Races 1 & 2 for Richmond C on 24/4/2019 as an example.

DATA CLEAN UP

Insert new Column A

Copy each dog’s name and paste into Col A next to relevant data

Re-arrange columns

Format columns

Please ensure there are no leading or trailing spaces in dogs name when it is pasted into Col A

COLUMN FORMATTING

Each sheet should contain the header row as shown on TAB 2 (freeze top row)

Col A = Text

Col B = Text

Col C = Number no decimals (remove minus symbol, just numbers 1 - 8 with no brackets or -)

Col D = blank

Col E = Text

Col F = Number no decimals

Col G = Text

Col H = Date (1st format option in Excel)

Col I = Number 2 decimals

Col J = Number 2 decimals – if blank insert N/A

Col K = Number 2 decimals – if blank insert N/A

Col L to Col T = blank

Col U = text

Col V = Number 2 decimals

Col W = blank

Col X = Currency $ symbol 2 digits

Col Y = text

Col Z = Number 2 decimals

The tool I want created can apply all the above to any Excel sheet.

If it works better, I would be happy if the tool automatically scraped the data from the website to avoid this being done manually and having to use Firefox/Table to Excel to do the job.

Taidot: Excel, Tietojen kaavinta verkosta

Näytä lisää: clean up and alter an image, clean up and alter image, code to model the functionality and delay of the 32-bit rca, automated data scraping from websites into excel, octoparse, parsehub, scrapy, web scraper chrome, web scraper tool free download, web scraping service, scrape data from website to excel, code to model the functionality and delay of the 32bit rca, where to look for up and coming writers, use the web to research the development and use of rfid technology from your research list eight different industry sectors wher, write a modular programming to print names ages and address of person, freelance developer to assist with look and feel of website, Construction clean up and window cleaning lowness work, We need to update the look and feel of our 8.5X11 single page marketing sheet. The color look and feel needs to be updated to ma, We need to update the look and feel of our 8.5X11 single page marketing sheet. , We need to update the look and feel of our 8.5X11

Tietoa työnantajasta:
( 15 arvostelua ) Kings Meadows, Australia

Projektin tunnus: #19287349

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

Hello Sir, If you can please initiate a chat, I can send the sample as attachment. I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert Lisää

$222 AUD 3 päivässä
(682 arvostelua)
8.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Lisää

$250 AUD 4 päivässä
(298 arvostelua)
7.8
mhmhz

Hi I checked your file and can start the 1st phase (clean up process) I can work on a demo if you like. Thanks

$250 AUD 3 päivässä
(88 arvostelua)
7.4
zekovicm

Hi there,I am Web Scraping and Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it Lisää

$222 AUD 5 päivässä
(123 arvostelua)
7.3
adeelpirzada

Hi, Allow Me to Introduce Myself i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own tools based on Lisää

$125 AUD 7 päivässä
(24 arvostelua)
6.1
etuannv

Hi there, I am interested in your project. I would approach your project by using Python to scrape the data. I cant follow your guide steps because the website requires to login. I have 4+ years’ experience at Web Lisää

$197 AUD 3 päivässä
(53 arvostelua)
6.1
datakillers

HI I am expert in data scrapping, data mining and data hunting with great web search as well as having great research skills and tools. Data Entry is my passion and I am getting task as challenge and do my best effort Lisää

$133 AUD 2 päivässä
(130 arvostelua)
6.4
rinabuoy13

Hello, I am independent, experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$200 AUD 3 päivässä
(81 arvostelua)
5.7
developerphp2007

Hi, I read your project's description + web link very carefully, I am expert on web-scraping and auto BOT, I can complete your project 100% perfectly.. I can give you all data(which you explained) from website by m Lisää

$150 AUD 10 päivässä
(36 arvostelua)
5.6
vbexcel

Hi; I will provide you a small sample of the data you require on request before you award the project. As for my background I am a VBA coder with over twenty years experience in developing automated web data min Lisää

$150 AUD 2 päivässä
(35 arvostelua)
5.6
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lisää

$100 AUD 2 päivässä
(84 arvostelua)
5.5
yesikov1224

Hello,sir. Thanks for your job. I am expert web scraping. I can do your job with BS4 of python. I can do any project in your demand completely by my good experiences of last ago. I think this project is for me. I Lisää

$155 AUD 3 päivässä
(28 arvostelua)
5.5
smsaurabhv

Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHON Lisää

$111 AUD 3 päivässä
(42 arvostelua)
4.8
kkc1985612

Hi, I have a lot of experience in scraping data in websites using selenium, beautifulSoup, xlsxwriter in python. I can save the scrapped data in xlsx, csv, sql files and more database according to user's requirement. Lisää

$150 AUD 3 päivässä
(11 arvostelua)
4.3
shahinrahimi

I can help you with this. I visited the website, I believe the task that you want (Scrapping + Formatting), could be done by VBA Macro, and I can create you the most efficient one that you would perform all the tasks j Lisää

$200 AUD 2 päivässä
(16 arvostelua)
3.7
yuriyes43

Hi, there! I am very interested in your job. I have been working as a full stack web developer for over 5 years. I am highly skilled in PHP and Webscrapping so I feel confident that I can do your job without fail. Lisää

$200 AUD 2 päivässä
(3 arvostelua)
3.5
vw7324631vw

DONE!!! Nice and interesting project. I have done the program already and you can see it working here: [login to view URL] or here: [login to view URL] Lisää

$188 AUD 2 päivässä
(5 arvostelua)
2.9
IbexEnterprises

Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from cli Lisää

$125 AUD 1 päivässä
(7 arvostelua)
2.1
fasihero

I'm hardworking individual take a project very seriously

$88 AUD 3 päivässä
(0 arvostelua)
0.0
itshawk

Hi, Going through your requirement I propose to scrap the data from the website and write directly into excel file in the desired format(clean data). There is no need to format the data in excel file. I have done si Lisää

$150 AUD 2 päivässä
(0 arvostelua)
0.0