R
Richard
Hi,
My hobby is punting. I wager relatively small amounts
usually spread over 2 to 4 runners. I use an Excel
spreadsheet to manipulate form data from which I make my
selections and record my bets. I use a regular internet
betting agency to place my bets. My problem is that
because I wager only small amounts, I cannot place the
bets in sufficient time to capture the latest dividends
and this usually results in a loss.
Is there a way that I can copy my data to another section
of my spreadsheet and then parse it in some way so that I
can then, by one click, copy and paste the selections as a
block directly to the input section of the betting agency
site.
Their input box appears to be just formatted text with one
entry per line parsed in the format of:-
RR-04-WP-00005.0-00000.0/02/ which is, in order:-
RaceVenue-No-WinPlace-WinAmt-PlaceAmt/RunnerNo/
The fields are separated by dashes except for the last two
which have forward slashes. I don't know what this means
but the above format is how it appears in their input box
when the data is entered manually.
Could anyone help with this please?
Regards,
Richard
My hobby is punting. I wager relatively small amounts
usually spread over 2 to 4 runners. I use an Excel
spreadsheet to manipulate form data from which I make my
selections and record my bets. I use a regular internet
betting agency to place my bets. My problem is that
because I wager only small amounts, I cannot place the
bets in sufficient time to capture the latest dividends
and this usually results in a loss.
Is there a way that I can copy my data to another section
of my spreadsheet and then parse it in some way so that I
can then, by one click, copy and paste the selections as a
block directly to the input section of the betting agency
site.
Their input box appears to be just formatted text with one
entry per line parsed in the format of:-
RR-04-WP-00005.0-00000.0/02/ which is, in order:-
RaceVenue-No-WinPlace-WinAmt-PlaceAmt/RunnerNo/
The fields are separated by dashes except for the last two
which have forward slashes. I don't know what this means
but the above format is how it appears in their input box
when the data is entered manually.
Could anyone help with this please?
Regards,
Richard