Working on a new sheet,
combining info from AtTheRaces, Timeform, Sporting Life and Racing Post.
Today's Greyhounds
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
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 wrote: ↑Fri Apr 23, 2021 10:35 pmWorking on a new sheet,
combining info from AtTheRaces, Timeform, Sporting Life and Racing Post.
Capture.JPG
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Didn't take long to finailse
You do not have the required permissions to view the files attached to this post.
- The Silk Run
- Posts: 924
- Joined: Mon May 14, 2018 12:53 am
- Location: United Kingdom
MEMF. Bet Angel's Greyhound Tsar. I miss the PnL's, NEED some inspiration
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
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.
Looks a Good Lay to me.
He is up against 5 bitches
Must be the Oldest Racing Greyhound Alive.
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
- The Silk Run
- Posts: 924
- Joined: Mon May 14, 2018 12:53 am
- Location: United Kingdom
Good morning MEMF. Do you include any track bias variables in your selection process.MemphisFlash wrote: ↑Sun Apr 25, 2021 10:31 am11.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
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
sometimes. i have so many variables that i use,
and with this new sheet i now have a few more, lol
and with this new sheet i now have a few more, lol
- The Silk Run
- Posts: 924
- Joined: Mon May 14, 2018 12:53 am
- Location: United Kingdom
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.MemphisFlash wrote: ↑Sun Apr 25, 2021 11:04 amsometimes. i have so many variables that i use,
and with this new sheet i now have a few more, lol
Have a good day
Minnie LAI
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
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
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
You do not have the required permissions to view the files attached to this post.
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
no just normal pulled from the website
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
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Splitting would seem to be easiest ... split on occurrence of "(" and "trim" leading and trailing spaces out.MemphisFlash wrote: ↑Sun Apr 25, 2021 11:55 am1 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
=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?