Today's Greyhounds

[MemphisFlash]

Working on a new sheet,
combining info from AtTheRaces, Timeform, Sporting Life and Racing Post.

Capture.JPG

[jamesg46]

Working on a new sheet,
combining info from AtTheRaces, Timeform, Sporting Life and Racing Post.

Capture.JPG

Question I've been meaning to ask. Can historical lists be exported (not that part) & the data be transformed in power query into a pivot table or dashboard & refreshed after each race to give a better view of focus day to day, market to market?

[MemphisFlash]

Didn't take long to finailse

Capture.JPG

[The Silk Run]

MEMF. Bet Angel's Greyhound Tsar. I miss the PnL's, NEED some inspiration

[MemphisFlash]

11.51 Pelaw Grange, a 7 year old Dog is running in trap 1.
Looks a Good Lay to me.
He is up against 5 bitches
Must be the Oldest Racing Greyhound Alive.

Capture.JPG

[ODPaul82]

Might be there for some dating rather than racing with all those bitches about

[MemphisFlash]

Might be there for some dating rather than racing with all those bitches about

is he on Tinder, Lol

[The Silk Run]

11.51 Pelaw Grange, a 7 year old Dog is running in trap 1.
Looks a Good Lay to me.
He is up against 5 bitches
Must be the Oldest Racing Greyhound Alive.

Capture.JPG

Good morning MEMF. Do you include any track bias variables in your selection process.

[MemphisFlash]

sometimes. i have so many variables that i use,
and with this new sheet i now have a few more, lol

[The Silk Run]

sometimes. i have so many variables that i use,
and with this new sheet i now have a few more, lol

Yes, I know. I have been following your creative work. I have three instances in operation today on this market, and about to launch a fourth.

Have a good day
Minnie LAI

[MemphisFlash]

1 out 1 on my tips.

Just out of interest does anyone know how to turn this one string of text, so that it alligns on the left and on the right so the percetantages line up as well as the trainer

Capture.JPG

[ODPaul82]

Is it double spaces between the trainer name and the percentage number

[MemphisFlash]

no just normal pulled from the website

[ODPaul82]

In Excel you can't have the string aling left & right into one individual cell, you'd either have to split it or use a function that would pad on a load of white space after the trainer name. Would be quite a fiddly formula

[firlandsfarm]

1 out 1 on my tips.

Just out of interest does anyone know how to turn this one string of text, so that it aligns on the left and on the right so the percetantages line up as well as the trainer


Capture.JPG

Splitting would seem to be easiest ... split on occurrence of "(" and "trim" leading and trailing spaces out.

=Trim(left([cell ref],find("(",[cell ref]-1)))
and ...
=Right([cell ref],len([cell ref])-(find("(",[cell ref])-1))

How bad would it look if you just tried centring the text?