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
Manager Reporting and Analysis
MRacing Pty Ltd