Naps for the day

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Enclosed a spreadsheet with the naps of the day in power query format.
slicers are also used to group together selections and can be searched by time or track.

Daily Napster table.JPG

Daily Tipster Naps.xlsx

to update just press refresh all
refresh all.JPG

enjoy and hope it's useful
You do not have the required permissions to view the files attached to this post.
Last edited by MemphisFlash on Wed Mar 30, 2022 10:54 am, edited 1 time in total.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

example of a race

example.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

For those who are unsure about the refresh, if you open "Queries And Connections" before you hit refresh
you will see the panel on the right hand side. When you hit refresh you will see a spinning wheel where the table icon is.
When that stops spinning everything has been updated.

Queries and connections.JPG

If you click on the icon next to horses name you get additional info.

tipster.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
goat68
Posts: 2019
Joined: Tue Jun 30, 2020 3:53 pm
Location: Hampshire, UK

I always like a good nap, mid afternoon is best time for me..
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

goat68 wrote:
Wed Mar 30, 2022 12:35 pm
I always like a good nap, mid afternoon is best time for me..
Ba -doom-ching, lol (drum roll)
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Great work, love the design. :)
User avatar
bigpapaperry
Posts: 18
Joined: Sat Feb 13, 2021 1:18 pm

Excellent bit of kit thank you, now to spend my weekend trying to work out how you did it. :) :) :)
i do love a bit of Excel

It wont update or refresh as my version of Excel is older than yours :cry: :cry: :cry:
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

updated sheet as error in slicers not working dynamically on original


Daily Tipster Naps.xlsx
Capture.JPG
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”