Hi NN.
Thank you for showing interest in working with me on this project. To find the data that I want from Patterform, this is where you go to find it:
And this is what the page looks like:
I’m interested in the data inside the tables and the blue text above each table. And this is how I want the result on my computer:
The columns are as follows:
A - ID-Numb
The cell contains a code that identifies the row in order to merge it with information from other data. I have colour-coded row 2 so you can see what cells make up the code.
Red is the content of the Date column, 10 positions.
Blue is the content of the SWTime column, 5 positions.
Brown is the content of the first five positions of the Track column, 5 positions. If the track is shorter then 5 positions, like for instance the track Ayr, the empty space should be filled up with "x", like so: Ayrxx.
Green is the content of the first 10 positions of the Name column, 10 positions. If the name of the horse is shorter then 10 positions, like for instance line 3, the horse Iniesta, the empty space should be filled up with "x", like so: Iniestaxxx.
An empty space in the horse name, like for instance line 6, the horse The Lady Rules, the empty space should be filled up with an under score "_", like so: The_Lady_R.
If the horse has an apostrophe in the name, like for instance line 12, the horse L'Attesa, the apostrophe should be taken out and not counted as a position, like so: LAttesaxxx.
Between the contents in the code, there should be "-"
B - Date
The date of the races formatted like: YYYY-MM-DD
C - Day
This is also a date field, but formatted in Excel like: DDDD
D - Time
The time the race is scheduled to start Greenwich Mean Time, taken from Patternform.
E - SWTime
The time the race is scheduled to start Greenwich Mean Time +1. This field shoul be calculated in Excel.
F - Track
The name of the track.
G - Rank
Patternform ranking of the horse.
H - Name
The name of the horse.
I through AB
These columns represents the rest of the table. One column in Patterform correspond to two columns in the Excel sheet like this:
In the first column in Excel, the equation in Patterform is executed like so:
14/30 = 47%
8/31 = 26%
18/33 = 55%
9/20 = 45%
5/18 = 28%
In the second column in Excel contains the amount of the total races the equation is based on.
I would like a solution where I can download the required tables from Patternform just by adding a date to a form on my computer, something like this:
The files on Patterform are stored inside folders with ths syntax:
Sometimes the files are named wrong, or put in the wrong place. That’s why it is nessecery to have an option where I can submit an URL instead of just the date.
I would like all races from the same date to reside in the same table one after the other.
I would like to know your price and proximate days it will take you to do this. Your'e wellcome with questions.
Thank you.
About log-in. I will not share my log-in. You can create a log-in for free. You will have to follow the instructions you see on the screen, and when they ask for your favourite horse – just pick one from the names in the different pictures you see above in this chat.
I do not have a budget set for this. You have to tell me how much you want for doing this job.