Any news on this Peter?
I'm wanting Greyhound racecards in Excel but finding it difficult due to not knowing any programming languages.
Hi PeterEuler wrote: ↑Fri Feb 25, 2022 6:41 pmYou can do it already, we updated a few versions back: -
https://youtu.be/q2rxyyDjRY0
Load into Guardian, right click, export.
Have you got a template copy of that spreasheet with the Power Queries. I have no idea how to write a power query. I would like to have the columns for the distance and race type hcp etcpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
Hello mate, hope this post helps.gstar1975 wrote: ↑Wed Jul 20, 2022 1:24 pmHave you got a template copy of that spreasheet with the Power Queries. I have no idea how to write a power query. I would like to have the columns for the distance and race type hcp etcpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
Have you produced a "Dynamic" PQ yet? Or are you still thinkingpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
Unfortunately not Gstar.gstar1975 wrote: ↑Sat Oct 14, 2023 6:29 pmHave you produced a "Dynamic" PQ yet? Or are you still thinkingpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
Can you use Guardian to export all races with all runners with all racecard data like form age etc?Euler wrote: ↑Fri Feb 25, 2022 6:41 pmYou can do it already, we updated a few versions back: -
https://youtu.be/q2rxyyDjRY0
Load into Guardian, right click, export.