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.


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


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.

Квалификация: Excel, Веб-скрейпинг

Показать больше 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

О работодателе:
( 15 отзыв(-а, -ов) ) Kings Meadows, Australia

ID проекта: #19287349

23 фрилансеров(-а) в среднем готовы выполнить эту работу за $167


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 Больше

$222 AUD за 3 дней(-я)
(682 отзывов(-а))

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. Больше

$250 AUD за 4 дней(-я)
(298 отзывов(-а))

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 дней(-я)
(88 отзывов(-а))

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 Больше

$222 AUD за 5 дней(-я)
(123 отзывов(-а))

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 Больше

$125 AUD за 7 дней(-я)
(24 отзывов(-а))

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 Больше

$197 AUD за 3 дней(-я)
(53 отзывов(-а))

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 Больше

$133 AUD за 2 дней(-я)
(130 отзывов(-а))

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 дней(-я)
(81 отзывов(-а))

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 Больше

$150 AUD за 10 дней(-я)
(36 отзывов(-а))

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 Больше

$150 AUD за 2 дней(-я)
(35 отзывов(-а))

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] Больше

$100 AUD за 2 дней(-я)
(84 отзывов(-а))

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 Больше

$155 AUD за 3 дней(-я)
(28 отзывов(-а))

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 Больше

$111 AUD за 3 дней(-я)
(42 отзывов(-а))

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. Больше

$150 AUD за 3 дней(-я)
(11 отзывов(-а))

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 Больше

$200 AUD за 2 дней(-я)
(16 отзывов(-а))

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. Больше

$200 AUD за 2 дней(-я)
(3 отзывов(-а))

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] Больше

$188 AUD за 2 дней(-я)
(5 отзывов(-а))

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 Больше

$125 AUD за 1 день
(7 отзывов(-а))

I'm hardworking individual take a project very seriously

$88 AUD за 3 дней(-я)
(0 отзывов(-а))

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 Больше

$150 AUD за 2 дней(-я)
(0 отзывов(-а))