Power Query - Example Spreadsheets (Indexed by Sport)

Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Power Query is a unique way of transforming data in Excel and requires no programming skills. It takes seconds to update information, all at the click of one button.

BA Support have agreed to have a one stop shop to house all the Power Query solutions that have been posted and the aim is to add more.

The list of examples thus far is as follows: -

General

Betfair Historic Data Downloaded
viewtopic.php?f=83&t=28303

Power Query List of PQ Solutions
viewtopic.php?f=83&t=28345


Horse Racing

Timeform Runners & BHB Ratings
viewtopic.php?f=31&t=22292

Jockey Stats
viewtopic.php?f=31&t=22291

Betfair Historic Results (Horses)
viewtopic.php?f=19&t=22451

Horse Racing - Daily Tips
viewtopic.php?f=19&t=22321

Horse Racing - Daily Tipster Naps Table
viewtopic.php?f=19&t=22315

Horse Racing - Daily Tips from Every UK/IRE Race
viewtopic.php?f=19&t=22310

BF Historic Horse Win Data in One Workbook
viewtopic.php?f=19&t=22451

Horse Racing - Steamers & Drifters
viewtopic.php?f=31&t=22496

Aus Racing - Horse Stall Draw Data
viewtopic.php?f=31&t=23114

Horse Racing - Daily Tipster Table
viewtopic.php?f=31&t=23178

Horse Racing - Predictor + History
viewtopic.php?f=31&t=23317

Horse Racing - Hugh Taylor Tips
viewtopic.php?f=31&t=23315

Horse Racing - In Running Rating
viewtopic.php?f=31&t=23942

Horse Racing - In-Running Stats
viewtopic.php?f=83&t=28180

Horse Racing - Combo's Last 14 Days Etc
viewtopic.php?f=83&t=28175

Horse Racing - Backed or Drifted
viewtopic.php?f=83&t=28174

Horse Racing - Hugh Taylor Results
viewtopic.php?f=83&t=28173


Football

Calculations to determine if Both Teams To Score (BTTS) Has Value Or Not
viewtopic.php?f=31&t=22275

Footy Stats Top 9 Leagues
viewtopic.php?f=31&t=22444

Premier League Top Strikers
viewtopic.php?f=31&t=22297

Results Downloader
viewtopic.php?f=83&t=28401



Other Sports

The Power of Power Query (Original Post)
viewtopic.php?f=31&t=22288

NFL Team Stats
viewtopic.php?f=19&t=22289

Greyhound Course Trap & Favourite Stats
viewtopic.php?f=31&t=22493

Snooker - All Time Stats
viewtopic.php?f=31&t=22580

Aus Greyhounds - Trap Stats
viewtopic.php?f=31&t=22583

Darts - Recent Results
viewtopic.php?f=31&t=22596

Golf - PGA Golf Stats
viewtopic.php?f=31&t=22645

Tennis - Serve Stats
viewtopic.php?f=31&t=22934

UK Lotto Draw Numbers
viewtopic.php?f=31&t=24498

Cricket - T20 Historical Results 2010-2023
viewtopic.php?f=83&t=28184

Count of Winning & Losing Streaks
viewtopic.php?f=83&t=28193

Greyhound A to Z and Tip's
viewtopic.php?f=83&t=28344
Last edited by paspuggie48 on Tue Dec 01, 2020 11:29 am, edited 2 times in total.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

cool
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

Brilliant timing... last two days have been a head F**K!

This will help!
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Realrocknrolla wrote:
Mon Nov 30, 2020 7:51 pm
Brilliant timing... last two days have been a head F**K!

This will help!
Get the basics of how PQ 'Gets & Transforms' data and it is relatively easy ...once I showed Memphis how it worked and after he watched a few videos himself he picked it up like a duck to water...all within the last month or so and he is now developing some really good data solutions.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

paspuggie48 wrote:
Mon Nov 30, 2020 8:03 pm
Realrocknrolla wrote:
Mon Nov 30, 2020 7:51 pm
Brilliant timing... last two days have been a head F**K!

This will help!
Get the basics of how PQ 'Gets & Transforms' data and it is relatively easy ...once I showed Memphis how it worked and after he watched a few videos himself he picked it up like a duck to water...all within the last month or so and he is now developing some really good data solutions.
Yeah mate, i've been reading his posts.... clever fella. I've been trying to telepathically receive his Greybot also but I'm still working on that one too. :D :D
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

He's clever but he has some way to go yet to better his mentor :lol:
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

paspuggie48 wrote:
Mon Nov 30, 2020 8:16 pm
He's clever but he has some way to go yet to better his mentor :lol:
:D :D :D :D :D :D :D :D :D :D :D :D :D :D :D
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

i feel some BRO-mances developing, lol
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

MemphisFlash wrote:
Mon Nov 30, 2020 8:56 pm
i feel some BRO-mances developing, lol
Haha, can either of you post some or DM me some youtube videos to learn from. All info welcome!
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

captainbang
Posts: 82
Joined: Tue May 01, 2018 1:33 pm

Great stuff on the thread, I only recently enrolled in a power query Udemy course so very interested in this thread
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

MemphisFlash wrote:
Mon Nov 30, 2020 10:07 pm
https://www.youtube.com/watch?v=BrLQmJ1Vqk4&t=32s

https://www.youtube.com/watch?v=6lBqYInBldk

https://www.youtube.com/watch?v=sLW3NbeGDy8

https://www.youtube.com/watch?v=2mR44X7PrRo

that should keep you occupied for a while. These were some of the ones i watched.
The two women are very good.
Legend... Will crack on with these today. Alexa has been blasting out the 50's for me this morning! Put me in a right good mood!
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

i have 83000 mp3s all 50's related stuff on my hard drive
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

MemphisFlash wrote:
Tue Dec 01, 2020 10:18 am
i have 83000 mp3s all 50's related stuff on my hard drive
I bet you have the titles in a spreadsheet too :D :D :D :D :D :D :D :D :D :D
Post Reply

Return to “Excel Power Query”