En cours

Automate repetitive task Horse Racing

Hello, I need someone to collaborate with to develop an automated spreadsheet:

I’m a retired horse racing enthusiast with some coding experience (very limited) and reasonable excel skills and want to automate a daily task.

1. Project to automate excel spreadsheet initially using Visual Basic and excel macros to

• Scrape list from first horse racing web site for first column of workbook

• Insert additional columns in spreadsheet to accommodate second list of saved horse names and other information

• Insert second list of horse names from a saved file

• Sort alphabetically

• Use conditional formatting to show duplicate entries

• Combine individual duplicate entries

• Delete all other entries

• Import into list from second racing web site race times (xml data)

• Sort list numerically and format for further manual data entry

2. Create a plan to further automate the entry of this manual data entry from additional sources (pdf table to excel) (extract data from email). This planning and development to be ongoing.

Website [login to view URL]

1 Select date required (usually next day or following day)(please note the list is only available on a short term future basis only depending on the sites database updates)

2 Select runner list

3 With cursor, select

Horse Race Tab WT BP

(Only this information)

4 Scroll down to capture entire list

5 Ctrl C to copy

6 Open new excel workbook

7 Paste list data to first 5 columns

8 Select entire list and cancel formatting and hyperlinks

9 Insert 2 columns to left of Race column

10 Scroll to bottom of list

11 At bottom of list copy and paste second list from local drive(example attached separately)

12 Sort list alphabetically

13 Apply conditional formatting for duplicate entries

14 Combine duplicate entries to one line for each entry (note: on some days an individual horse may appear for 2 or sometimes even 3 separate races (different races or locations))

15 Delete balance of non-required list

16 Insert column to left of date column

17 Cut and paste TAB no’s. to this new column

18 Use the empty column for each entered horse’s race times from the following web site

19 Extract data for race times from

[login to view URL]

(done manually at present)

20 Sort into race time numerically

21 Format for further analysis

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic, Web Scraping

en voir plus : https://www.freelancer.com/contest/Wood-Theme-Business-Card-only-side-needed-943257-byentry-12272451.html, Hello. We are looking to have a website designed for www.poochiespetspa.com. It will be attached to our current website (which w, Hello. We are looking to have a website designed for www.poochiespetspa.com., data entry, data processing, excel, visual basic, web scraping, www freelancer com 2fprojects 2farticles 2farticles writing task 2f 3futm_campaign 3dlatest_project_contest 26utm_medium 3demail, www aehelp com writing task 2, http www ieltsbuddy com ielts writing task 1 html, automate some task 2, automate some task -- 2, automate repetitive, repetitive task openerp, writing task repost future, repetitive task assistant, complete short form task, software automate repetitive tasks, simple repetitive task

Concernant l'employeur :
( 0 commentaires ) Manunda, Australia

Nº du projet : #17251455

Décerné à:

$12 AUD / heure
(0 Commentaires)
0.0

14 freelance font une offre moyenne de $12/heure pour ce travail

bestit4u

Hi I am very,very interested in your project My name is Shan Bin and I'm a Chinese developer. I have 6 years of web scraper development experience such this projects. And I have good skills with this program languag Plus

$12 AUD / heure
(56 Commentaires)
6.5
$12 AUD / heure
(61 Commentaires)
6.3
yongjin818

Dear I am an expert in web scraping. In before, I developed many spiders using scrapy, php, nodejs. For example, I scraped data for CEOs(ebay, welivv, [login to view URL], [login to view URL] and so on). Thanks.

$12 AUD / heure
(38 Commentaires)
5.2
sourabhg98

Hello This is Sourabh Gupta from New Delhi. I am advanced Excel VBA programmer and specialize in creating customized workbooks for businesses and people to meet all their needs efficiently and effectively. Currently Plus

$12 AUD / heure
(59 Commentaires)
4.9
vw2107604vw

I am an experienced software engineer, and I have plenty of experience automating Excel. Please message me so we can discuss the details. Thanks, Gabriel

$12 AUD / heure
(12 Commentaires)
4.0
sysdesigner13

Hi, bro. Nice to meet you. I have read your request. I have a full of experiences with data processing using macro in excel. I have finished many projects like this. I am confident in your project and I can fin Plus

$12 AUD / heure
(6 Commentaires)
3.5
$13 AUD / heure
(0 Commentaires)
0.0
ilaravel

✅ 100% Job Success Score , ✅ 5* Ratings & Feedback, ✅ 100% Client’s Recommendation My Featured Project, I bet if you see this, you’ll fall in love. [login to view URL] I offer high quality enterprise web develo Plus

$12 AUD / heure
(0 Commentaires)
0.0
EnriqueBet

Hi! My name is Enrique. I am a python developer with wide experience in automation. To be honest, I have no experience scrapping with VB, But I do in Python. The approach that you require will be the same, for Excel ma Plus

$8 AUD / heure
(0 Commentaires)
0.0
Aishoo15

Dear Hiring Manager I know what it takes to be an efficient employee for a busy and successful organization. In my past experience, as an Administrative Coordinator, I helped maintain very important aspects of many Plus

$10 AUD / heure
(0 Commentaires)
0.0
ksd711

Hi. I have 7+ years of experience in Mobile (iOS/Android) app development and 6+ year Exp in Web development(PHP,Mageto .NET, Firebase,JAVA,HTML5). I can use Native/Xamarin/Ionic/PhoneGap for mobile development. Can Plus

$12 AUD / heure
(0 Commentaires)
0.0
lydiaaleswead

I have a certified diploma in Analyzing and Visualizing Data with Excel by Microsoft. I am passionate and I have plenty of free time.

$12 AUD / heure
(0 Commentaires)
0.0
shathyaa

It's a Msgvfrom automation team.. Call on 9790703170

$12 AUD / heure
(0 Commentaires)
0.0