prso1000 533 Posted February 13, 2021 #11 Share Posted February 13, 2021 I did it in 2018, but gave up after a while after it was clear Crnkovic is out if I recall correctly the best 3 results count or? But what period? Link to comment Share on other sites More sharing options...
Vojthas 947 Posted February 13, 2021 #12 Share Posted February 13, 2021 3 hours ago, heywoodu said: unless you're a real Excel magician. Here I am. What do you need, you humble mortal? Link to comment Share on other sites More sharing options...
heywoodu 13,504 Posted February 13, 2021 #13 Share Posted February 13, 2021 16 minutes ago, Vojthas said: Here I am. What do you need, you humble mortal? A ranking with the following input: - Every single IBU Qualifying points result (for the qualifying period, which I don't know in my mind what exactly it is) for all sprints and individuals in the World Cup, IBU Cup and their respective championships, like this document: https://ibu.blob.core.windows.net/docs/2021/BT/SWRL/CH__/SMSP/C74Q_v1.pdf And the following output: - A ranking (with athletes, not nations) with I believe the average of each athlete's five best results. It could also be the average of the three best results, I'd have to check. If you'd like to help our fellow Totallympics member Bruna Moura get to the 2026 Winter Olympics, after her car crash on the way to the 2022 Olympics, every tiny bit of help would be greatly appreciated! Full story and how to help can be found here! Link to comment Share on other sites More sharing options...
Vojthas 947 Posted February 13, 2021 #14 Share Posted February 13, 2021 6 hours ago, heywoodu said: A ranking with the following input: - Every single IBU Qualifying points result (for the qualifying period, which I don't know in my mind what exactly it is) for all sprints and individuals in the World Cup, IBU Cup and their respective championships, like this document: https://ibu.blob.core.windows.net/docs/2021/BT/SWRL/CH__/SMSP/C74Q_v1.pdf And the following output: - A ranking (with athletes, not nations) with I believe the average of each athlete's five best results. It could also be the average of the three best results, I'd have to check. EASYYYY: =AVERAGE(LARGE(table of results;1);LARGE(table of results;2);LARGE(table of results;3);LARGE(table of results;4);LARGE(table of results;5)) "Table of results" is of course all the range of the results you need to pick 5 out of. Link to comment Share on other sites More sharing options...
prso1000 533 Posted February 14, 2021 #15 Share Posted February 14, 2021 11 hours ago, Vojthas said: EASYYYY: =AVERAGE(LARGE(table of results;1);LARGE(table of results;2);LARGE(table of results;3);LARGE(table of results;4);LARGE(table of results;5)) "Table of results" is of course all the range of the results you need to pick 5 out of. Yes that is the easy part, but first you need to get the data from pdf to excel and sort it by athlete from many different events. No idea how and then you can easily do the part you describe. Link to comment Share on other sites More sharing options...
Vojthas 947 Posted February 14, 2021 #16 Share Posted February 14, 2021 13 minutes ago, prso1000 said: Yes that is the easy part, but first you need to get the data from pdf to excel and sort it by athlete from many different events. No idea how and then you can easily do the part you describe. I'm afraid there is no way to do that the other way than simply typing one by one. Or to type the results of each single competition, which is much easier and faster, and then ask Excel to search the name from the classification in the results list and give back their result. It's the function VLOOKUP. That's what I use for the prediction contests I manage. Maybe converting pdf to doc and trying to change it to table (ctrl+h and changing spaces to tabs mightbe helfpul) and then put it to excel would be another way 'round. Link to comment Share on other sites More sharing options...
heywoodu 13,504 Posted February 14, 2021 #17 Share Posted February 14, 2021 2 hours ago, Vojthas said: I'm afraid there is no way to do that the other way than simply typing one by one. Or to type the results of each single competition, which is much easier and faster, and then ask Excel to search the name from the classification in the results list and give back their result. It's the function VLOOKUP. That's what I use for the prediction contests I manage. Maybe converting pdf to doc and trying to change it to table (ctrl+h and changing spaces to tabs mightbe helfpul) and then put it to excel would be another way 'round. Yeah, importing the points (not the finish results) seemed to be the biggest issue. It's alright for one or two races, but typing that in manually for dozens of races throughout the season...there's just a major lack of time. I've tried converting their PDF's with the points, but it always ends up being skewed one way or another. If you'd like to help our fellow Totallympics member Bruna Moura get to the 2026 Winter Olympics, after her car crash on the way to the 2022 Olympics, every tiny bit of help would be greatly appreciated! Full story and how to help can be found here! Link to comment Share on other sites More sharing options...
Vojthas 947 Posted February 14, 2021 #18 Share Posted February 14, 2021 2 hours ago, heywoodu said: Yeah, importing the points (not the finish results) seemed to be the biggest issue. It's alright for one or two races, but typing that in manually for dozens of races throughout the season...there's just a major lack of time. I've tried converting their PDF's with the points, but it always ends up being skewed one way or another. As I said - pdf to doc, then the table to excel biathlon.xlsx Link to comment Share on other sites More sharing options...
RobtheAggie 337 Posted August 15, 2021 #19 Share Posted August 15, 2021 So much excel talent around here. My simpleton skills simply do not match up. Thanks for the work. Link to comment Share on other sites More sharing options...
George_D 862 Posted August 15, 2021 #20 Share Posted August 15, 2021 QUALIFICATION SYSTEM FOR XXIV OLYMPIC WINTER GAMES, BEIJING 2022 RobtheAggie 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now