Compare rankings

From the CRASH-B's to an online challenge, discuss the competitive side of erging here.
Slothful1
6k Poster
Posts: 664
Joined: March 18th, 2006, 5:52 pm
Location: Cape Town, South Africa
Contact:

Re: Compare rankings

Post by Slothful1 » February 9th, 2021, 2:07 am

sjors wrote:
February 8th, 2021, 9:31 am
Thanks Freddie, thats great to read.

And about your tip, I wil think about it. The hard part is to do it automatically without getting duplications.(no reference exits to the logbook-workout and only the name is tricky) Maybe it will a manual job, I very much dislike :twisted: :D
And if I look at your performances , I suppose you like the extremes. Rower short distances, and SkiErg 100k. I fully understand.
Maybe it could be shown as a separate table at the top of the screen, so not merged into the main data feed? The world records seem to be accessible from the C2 site through variables in the URL, so could be retrieved on a regular basis automatically and then displayed above your current data table. Not sure how you have been grabbing the ranking data off the C2 site, but presumably a similar approach could be used.

(Don't you just love clueless laymen, who think anything is possible even if they couldn't do it themselves :)?)

Dave

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 9th, 2021, 3:32 am

Slothful1 wrote:
February 9th, 2021, 2:07 am

Maybe it could be shown as a separate table at the top of the screen, so not merged into the main data feed? The world records seem to be accessible from the C2 site through variables in the URL, so could be retrieved on a regular basis automatically and then displayed above your current data table. Not sure how you have been grabbing the ranking data off the C2 site, but presumably a similar approach could be used.

(Don't you just love clueless laymen, who think anything is possible even if they couldn't do it themselves :)?)

Dave
It's correct that I could reed the data via a similar approach. Your idea is interesting.
Maybe I will make them recognizable via a color and just leave them both searchable.

In the moment the site seems to have a problem at restart. I have to solve that first
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 9th, 2021, 3:50 am

sjors wrote:
February 9th, 2021, 3:32 am
In the moment the site seems to have a problem at restart. I have to solve that first
I hope I fixed it.
If any of you sees wrong pages, give me a message.
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

ukaserex
1k Poster
Posts: 194
Joined: November 3rd, 2018, 12:37 pm

Re: Compare rankings

Post by ukaserex » February 10th, 2021, 1:52 am

So..I looked up my race result in February of 2019. It says "normal", but it was a race, and the time says 6:37, but it was 6:38.4

Certainly not a big deal, and I can't imagine the tedium of logging all those numbers. Just thought you might want to know, in case the result was for someone else and the query had some logic error.
100M - 16.1 1 Min - 370 500M - 1:25.1 1k - 3:10.2 4:00 - 1216 2k 6:37.0 5k 17:58.8 6k - 21:54.1 30 Min. - 8130 10k - 37:49.7 60:00 - 15604
1/2 Marathon 1:28:44.3 Marathon 2:59:36

5'10"
215 lbs
53 years old

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 10th, 2021, 3:15 am

ukaserex wrote:
February 10th, 2021, 1:52 am
So..I looked up my race result in February of 2019. It says "normal", but it was a race, and the time says 6:37, but it was 6:38.4

Certainly not a big deal, and I can't imagine the tedium of logging all those numbers. Just thought you might want to know, in case the result was for someone else and the query had some logic error.
I would like to solve your inconsistency. But therefore it would be helpful if I knew your name under which I can find the result. Maybe leave me a private message?
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 12th, 2021, 3:30 pm

I had some issues with the search engine that I use to find you results as fast as possible.
I think I solved it.
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 15th, 2021, 12:42 pm

faach1 wrote:
February 8th, 2021, 8:17 am
Hi Siebe,

Fantastic website, I’ve directed it to my friends and not a single one has given any negative feedback to me.

I was looking at the Static Indoor Rower Lightweight Verified times for 1k (both “yes” and “race” separately) and I noticed that Max Röger’s WR of 2:53.4 isn’t listed. Therefore would you add all world (and eventually national records) that have not been ranked through C2 logbook to your fantastic website?

Freddie
Hi Freddie,

I just finished the implementation of the WR-records on https://www.concept2.co.uk/indoor-rower ... ords/world.
The code tries to find matching records that were found on https://log.concept2.com/rankings, based on name, season, age and speed.
So if one these properties differs it creates a new record.
WR-records are in orange.
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

faach1
SpamTeam
Posts: 426
Joined: April 25th, 2020, 6:40 am
Location: United Kingdom
Contact:

Re: Compare rankings

Post by faach1 » February 15th, 2021, 12:47 pm

sjors wrote:
February 15th, 2021, 12:42 pm
faach1 wrote:
February 8th, 2021, 8:17 am
Hi Siebe,

Fantastic website, I’ve directed it to my friends and not a single one has given any negative feedback to me.

I was looking at the Static Indoor Rower Lightweight Verified times for 1k (both “yes” and “race” separately) and I noticed that Max Röger’s WR of 2:53.4 isn’t listed. Therefore would you add all world (and eventually national records) that have not been ranked through C2 logbook to your fantastic website?

Freddie
Hi Freddie,

I just finished the implementation of the WR-records on https://www.concept2.co.uk/indoor-rower ... ords/world.
The code tries to find matching records that were found on https://log.concept2.com/rankings, based on name, season, age and speed.
So if one these properties differs it creates a new record.
WR-records are in orange.
Hi Siebe,

This is excellent! Are you going to do national records (eg British, Irish, American etc.) in the fullness of time? (In deifferent colours I guess) :wink:
Freddie Hancock

MAD Team IRC

2k: 6:22.6 (Somerset VIRC)

faach1
SpamTeam
Posts: 426
Joined: April 25th, 2020, 6:40 am
Location: United Kingdom
Contact:

Re: Compare rankings

Post by faach1 » February 15th, 2021, 12:50 pm

faach1 wrote:
February 15th, 2021, 12:47 pm
sjors wrote:
February 15th, 2021, 12:42 pm
faach1 wrote:
February 8th, 2021, 8:17 am
Hi Siebe,

Fantastic website, I’ve directed it to my friends and not a single one has given any negative feedback to me.

I was looking at the Static Indoor Rower Lightweight Verified times for 1k (both “yes” and “race” separately) and I noticed that Max Röger’s WR of 2:53.4 isn’t listed. Therefore would you add all world (and eventually national records) that have not been ranked through C2 logbook to your fantastic website?

Freddie
Hi Freddie,

I just finished the implementation of the WR-records on https://www.concept2.co.uk/indoor-rower ... ords/world.
The code tries to find matching records that were found on https://log.concept2.com/rankings, based on name, season, age and speed.
So if one these properties differs it creates a new record.
WR-records are in orange.
Hi Siebe,

This is excellent! Are you going to do national records (eg British, Irish, American etc.) in the fullness of time? (In deifferent colours I guess) :wink:
I just saw Siebe sorry, that whilst you change is great, it only works for RANKED world records. My original example is about a world record that is UNRANKED. Is this possible to rank on your site?

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 15th, 2021, 3:51 pm

faach1 wrote:
February 15th, 2021, 12:50 pm
faach1 wrote:
February 15th, 2021, 12:47 pm
sjors wrote:
February 15th, 2021, 12:42 pm


Hi Freddie,

I just finished the implementation of the WR-records on https://www.concept2.co.uk/indoor-rower ... ords/world.
The code tries to find matching records that were found on https://log.concept2.com/rankings, based on name, season, age and speed.
So if one these properties differs it creates a new record.
WR-records are in orange.
Hi Siebe,

This is excellent! Are you going to do national records (eg British, Irish, American etc.) in the fullness of time? (In deifferent colours I guess) :wink:
I just saw Siebe sorry, that whilst you change is great, it only works for RANKED world records. My original example is about a world record that is UNRANKED. Is this possible to rank on your site?
Hi Freddie,
Do you have a url and and maybe screenshot to what yo want to index?

Regards Siebe
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

faach1
SpamTeam
Posts: 426
Joined: April 25th, 2020, 6:40 am
Location: United Kingdom
Contact:

Re: Compare rankings

Post by faach1 » February 15th, 2021, 4:06 pm

sjors wrote:
February 15th, 2021, 3:51 pm
faach1 wrote:
February 15th, 2021, 12:50 pm
faach1 wrote:
February 15th, 2021, 12:47 pm


Hi Siebe,

This is excellent! Are you going to do national records (eg British, Irish, American etc.) in the fullness of time? (In deifferent colours I guess) :wink:
I just saw Siebe sorry, that whilst you change is great, it only works for RANKED world records. My original example is about a world record that is UNRANKED. Is this possible to rank on your site?
Hi Freddie,
Do you have a url and and maybe screenshot to what yo want to index?

Regards Siebe
Sorry Siebe, my unreserved apologies, I see what I am saying has been indexed. I had the verified settings on “yes” rather than “race”. Are Race and yes not technically the same thing since they are both verified?

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 15th, 2021, 5:20 pm

faach1 wrote:
February 15th, 2021, 4:06 pm

Sorry Siebe, my unreserved apologies, I see what I am saying has been indexed. I had the verified settings on “yes” rather than “race”. Are Race and yes not technically the same thing since they are both verified?
Hi Freddie,

Verified=Yes and Verified=Race are almost the same.
Concept2 makes 1 exception, in that a 2k race only can be a WR if it's during a Race.
Since Concept2(log.concept2.com/rankings) is using 3 options for Verified, https://www.rankedworkouts.com/ is doing the same.
But with a nice extra in that you can search on any combination of the 3, like all other filters.
so if you want to find both Race and Yes, just select them both. :idea: :D
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

faach1
SpamTeam
Posts: 426
Joined: April 25th, 2020, 6:40 am
Location: United Kingdom
Contact:

Re: Compare rankings

Post by faach1 » February 16th, 2021, 6:12 am

sjors wrote:
February 15th, 2021, 5:20 pm
faach1 wrote:
February 15th, 2021, 4:06 pm

Sorry Siebe, my unreserved apologies, I see what I am saying has been indexed. I had the verified settings on “yes” rather than “race”. Are Race and yes not technically the same thing since they are both verified?
Hi Freddie,

Verified=Yes and Verified=Race are almost the same.
Concept2 makes 1 exception, in that a 2k race only can be a WR if it's during a Race.
Since Concept2(log.concept2.com/rankings) is using 3 options for Verified, https://www.rankedworkouts.com/ is doing the same.
But with a nice extra in that you can search on any combination of the 3, like all other filters.
so if you want to find both Race and Yes, just select them both. :idea: :D
Thank you for the info Siebe :mrgreen: :mrgreen:
Freddie Hancock

MAD Team IRC

2k: 6:22.6 (Somerset VIRC)

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » February 18th, 2021, 6:28 am

For anybody who is interested in age-related decline in the normal rowing machine, I have created a daily cronjob that exports csv's into a zip.
For every distance/time, weight-class and gender a csv-file is generated.
In each csv-file there are rows for the best performance per age as long as there are more than 3 performances for that age.
You can download it from here: https://www.rankedworkouts.com/docroot/ ... mances.zip
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

User avatar
sjors
2k Poster
Posts: 325
Joined: July 3rd, 2016, 3:50 am
Location: Netherlands
Contact:

Re: Compare rankings

Post by sjors » March 6th, 2021, 11:28 am

Solved issues:
  • Lately there were some issues with the search engine. It sometimes stopped working.
  • You could search for virtual things that were not really searchable like Wattage and Km/h.
  • You could search for alphabetical data in numeric-fields
  • And search for time-data went wrong because time-data is stored in milliseconds in the db.
Siebe Jongebloed
57/M/1,92/98 kg (getting back into shape again)
Image

Smart rankings: https://www.rankedworkouts.com/

Post Reply