paspuggie48 wrote: ↑Sat May 01, 2021 9:16 pm
jamesg46 wrote: ↑Sat May 01, 2021 6:46 pm
paspuggie48 wrote: ↑Sat May 01, 2021 6:40 pm
Lovely stuff James
Newmarket & Goodwood look like they offered up the opportunity... I've never dutched before but hopefully this wil offer confidence in what I'm doing.
If anyone wpuld like to use it, I don't mind uploading the file. i'm sure paspuggie you have a neat Excel sheet that does the trick too.
I'm sure there will be a lot who would appreciate it, so by all means post it if you wish. Unfortunately I don't have a fandango spreadsheet to do that
While you're here I'd like to quiz you on power query. Is it possible to transform exported values and create a dashboard in excel that can be refreshed after each market.
For example, a version of the Switish spreadsheet that can be refreshed and monitored through out the day.
I know we can connect to a file with the saved csv files and power query can look at the data but cleaning it and getting it into a dashboard is where I'm lost.