Page 1 of 1

Excel leaderboard using API

Posted: February 4th, 2025, 10:25 am
by FSZ
Hi!

I am experimenting with setting up a leaderboard for me and a friend of mine, where i hope to use API from the Logbook to show for instance best time on 5k, longest row in 60min etc.

If i can just implement it into Excel i can filter out everything, but i cannot manage to get the data into my excel feel, and am wondering if anyone here has done something similar before?

//FSZ

Re: Excel leaderboard using API

Posted: February 4th, 2025, 12:41 pm
by Citroen
There was some code created in the UK that would get C2 data from your PM3 and give it back to VBA.
I've got that archived away in a Github repo at: https://github.com/DougieLawson/PMI

You may be able to hack that, but remember it's nearly 20 years old and I won't support it.

Re: Excel leaderboard using API

Posted: February 5th, 2025, 4:45 am
by iain
Its not excel, but the FreeSpirits site has a meterboard that pulls data from the logbook from all freespirits participants (see link to site in signature). Jon Taylor maintains this on our behalf and has upgraded this through various upgrades.