Biathlon 2016 - 2017 Discussion Thread

[heywoodu 15,135]

3 minutes ago, ahjfcshfghb said:

Yeah. It's a shame they don't, but at least we can work them out?

It's better than guessing and checking like we did for the IBU Cup sprints  Not taking anything away from that, though, it turned out to all be pretty accurate!

 

Yes, working on the ranking is the hard part because of all the averages and importing the data and stuff. Last season it worked, but they have slightly changed the PDF format now and that's messing up the Excel sheet I had for it  

 

And the tables and stuff I made for calculating the points (I even wrote a little program in Python coding language  ) was mostly for me to know how the Brazilians are doing as soon as possible and especially when I'm at the competition and downloading the PDF's isn't the easiest way   (you know, so I can tell them their points and results long before their coach comes up with his tablet and tell them the results, like I did in Obertilliach last season  )

[ahjfcshfghb 287]

Just now, heywoodu said:

 

Yes, working on the ranking is the hard part because of all the averages and importing the data and stuff. Last season it worked, but they have slightly changed the PDF format now and that's messing up the Excel sheet I had for it  

 

And the tables and stuff I made for calculating the points (I even wrote a little program in Python coding language  ) was mostly for me to know how the Brazilians are doing as soon as possible and especially when I'm at the competition and downloading the PDF's isn't the easiest way   (you know, so I can tell them their points and results long before their coach comes up with his tablet and tell them the results, like I did in Obertilliach last season  )

Hahaha  

So it's simply the average of the best results of each of the last three trimesters?

[heywoodu 15,135]

11 minutes ago, ahjfcshfghb said:

Hahaha  

So it's simply the average of the best results of each of the last three trimesters?

 

Sort of

 

Edited December 9, 2016 by heywoodu

[ahjfcshfghb 287]

6 minutes ago, heywoodu said:

 

Sort of

 

Oh  Interesting.

[heywoodu 15,135]

Just now, ahjfcshfghb said:

Oh  Interesting.

The way someone made it for me then worked like that:

 

1. Dowload the "IBU Qualifying Points" PDF from IBU's website right after a competition 

2. Convert it to Excel

3. Import it in the calculating sheet

4. Click "Calculate"

5. Get the full updated IBU Qualifying Points List 

 

It was like 2 minutes of work per competition, but now it doesn't work anymore  

[ahjfcshfghb 287]

Hasilla of Slovakia shooting clear! 

[heywoodu 15,135]

JTB, impressive 

[Federer91 2,793]

Wow the norwegians are impeccable today  JT Boe surely wins now. 

[ahjfcshfghb 287]

I guess Fourcade's 'Pokljuka Curse' will last a bit longer.

[heywoodu 15,135]

Rösch flying over the finish  

 

Nice result