Telah Dianugerahkan

MRacing - HTML Excel Concatenation / Transposition Project

Please note I am yet to award this project however you have made the shortlist of candidates.

Ultimately I require a solution / process / engine / workaround that will enable me to pull data from the public website

[url removed, login to view]

Specifically the [url removed, login to view] page

Each race meeting has its own page with HTML script

eg [url removed, login to view]

This changes several times a week, therefore the URL will be different each time.

The solution for transposing the data will require at least the entry of the URL each time. For this reason I want a process in place.

Transposition of the data into the required excel format is the majority of the project.

Demonstrating that you understand how to create a process so that this data can continually be transposed into the desired excel format is how the project will be awarded.

To accomplish this task, are you able to create a VBA Macro?

Can the macro be run to pull data directly from the webpage source data?

Or does the data need to be converted to excel first?

Have all the fields been sorted into filterable columns as per the example?

Can we set up an engine that will pull this data and forward the excel sheet automatically to an email inbox?

What scope is there to make changes to the data or validate the data against other sources of updated data?

driver changes, scratchings, weather changes

Are you prepared to work on a quoted job basis to complete further work on this project?

I have reattached the workbook example here to clarify understanding of the format I want the data to be transposed to.

Please confirm that your quoted rate can achieve this solution and the total time taken for the process to be carried out from start to finish.

Please answer all questions contained in this email in your reply.

Thanks and Regards

Brett Saunders

Manager Reporting and Analysis

MRacing Pty Ltd

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Microsoft, Visual Basic

Lihat lebih lanjut: sorted data set, script to pull data from a website, pull data from website to excel vba, pull data from website into excel, project manager scope, mc driver, macro to pull data from website, how to create your own webpage, how to create website html, how to create webpage, how to create data entry form in excel, how to create a webpage, how to create a data entry form in excel, how to create a data entry form, how to be a project manager, excel out source, excel macro pull data from website, excel macro how to, data entry job scope, data entry candidates email, create excel form for data entry, create data entry form in excel, what is vba in excel, what is macro in excel, how to pull data from a website

Tentang Majikan:
( 0 ulasan ) WERRIBEE, Australia

ID Projek: #7308763

1 freelancer is bidding on average $250 for this job

zExcel

Hired by the Employer

$250 USD dalam 7 hari
(164 Ulasan)
6.9