Käyttäjän työkalut

Sivuston työkalut


Erot

Tämä näyttää erot valitun ja nykyisen version kesken tästä sivusta.

Linkki vertailunäkymään

2014:mmkouluanalyysi [2016/07/25 19:42]
2014:mmkouluanalyysi [2016/07/25 19:42] (nykyinen)
Rivi 1: Rivi 1:
 +====== Analyysia 2014 MM-kisojen koulupisteistä ======
 +
 +Turhan tiedon yhdistyksestä analyysia koulukokeen pisteistä. Oikeassa reunassa erilaisilla vähennyksillä. Kokonaispisteet - pienin jaettu, sitten vähennettynä maximipisteet sekä lopuksi molemmat vähennettynä. Perässä jokaisen laskelman mukainen sijoitus. Viimeisenä oikealla ero sijoituksessa jaettuihin ja ääripisteiden leikkauseen. {{:2014:mmkouluanalyysi.xls|Sama excel muodossa}}
 +
 +^  ^^^158,99^^161,01^^159,89^^175,77^^167,55^^^^^^^^^^^^^^^^
 +^CLT^COMPETITOR^CTRY^C:Cazas^^R:Brownlie^^S:Wannenwetsch^^V:Borka^^P:Mullins^^PEN^TOTAL^^^^^^^^^^^^^
 +^  ^^^PNTS^CLT^PNTS^CLT^PNTS^CLT^PNTS^CLT^PNTS^CLT^^+^-^CLT^PTOT^MAX^MIN^-MAX^CLT^-MIN^CLT^-MAX&MIN^CLT^DIFF^
 +|1|*VAN DEN BROEK Wilbrord|NED|172|13|195,5|1|183|4|200|1|191|2|0|120,51|39,49|1|941,5|200|172|41,36|1|36,88|1|38,51|1|0|
 +|2|*VINCK Renaud|FRA|183,5|2|193|3|176,5|13|191|9|183,5|5|0|118,72|41,28|2|927,5|193|176,5|42,48|2|39,84|2|40,96|2|0|
 +|3|PIRHOFER Rudolf|AUT|167,5|24|178|10|181,5|8|193|5|195|1|0|117,12|42,88|3|915|195|167,5|44,8|4|40,4|3|42,13|3|0|
 +|4|*KWIATEK Bartlomiej|POL|180,5|3|173,5|16|183|4|197|2|177,5|16|0|116,67|43,33|4|911,5|197|173,5|45,68|7|41,92|5|44,59|8|-4|
 +|5|*CIVIDINI Cristiano|ITA|180|5|181|8|178|11|190|11|181,5|7|0|116,54|43,46|5|910,5|190|178|44,72|3|42,8|8|44,27|6|-1|
 +|6|*FAISST Philipp|GER|169,5|18|194,5|2|190|1|180|33|175,5|21|0|116,42|43,58|6|909,5|194,5|169,5|45,6|6|41,6|4|43,63|5|1|
 +|7|*FALLAK Marlen|GER|171,5|15|186|5|181|9|190|11|179|14|0|116,16|43,84|7|907,5|190|171,5|45,2|5|42,24|6|43,52|4|3|
 +|8|*VIGNAUD Marion|FRA|187,5|1|191|4|174,5|17|169|57|180|10|0|115,46|44,54|8|902|191|169|46,24|8|42,72|7|44,37|7|1|
 +|9|FABIAN Laszlo|HUN|170|17|168|28|182|6|193|5|179,5|11|0|114,24|45,76|9|892,5|193|168|48,08|12|44,08|10|46,61|13|-4|
 +|10|LAUTERBACH Claudia|GER|162,5|32|173,5|16|180,5|10|189|13|183|6|0|113,73|46,27|10|888,5|189|162,5|48,08|12|43,84|9|45,44|9|1|
 +|10|*KWIATEK Weronika|POL|176|9|164|31|170|23|193|5|185,5|3|0|113,73|46,27|10|888,5|193|164|48,72|15|44,08|10|46,61|13|-3|
 +|12|*BERNDL Leslie|USA|165,5|26|186|5|182|6|183|26|171,5|27|0|113,66|46,34|12|888|186|165,5|47,68|10|44,4|12|45,55|10|2|
 +|13|*LEITNER Markus|AUT|175,5|10|167,5|29|177|12|186|16|181|8|0|113,54|46,46|13|887|186|167,5|47,84|11|44,88|13|46,19|11|2|
 +|14|PESTMAN Rudolf|NED|178|7|176,5|13|176|15|172|47|179,5|11|0|112,9|47,1|14|882|179,5|172|47,6|9|46,4|17|46,83|15|-1|
 +|15|*HEIKINEHEIMO Jounie|FIN|180|5|163,5|32|176,5|13|184|23|177|17|0|112,77|47,23|15|881|184|163,5|48,48|14|45,2|14|46,19|11|4|
 +|16|*BARBEY Michael|SUI|178|7|171|23|183,5|3|178|38|168,5|38|0|112,51|47,49|16|879|183,5|168,5|48,72|15|46,32|16|47,57|18|-2|
 +|17|NYUL Katalin|HUN|171,5|15|177,5|11|169|25|192|8|166,5|44|0|112,19|47,81|17|876,5|192|166,5|50,48|20|46,4|17|49,49|22|-5|
 +|17|*BLOMBERG Anneli|SWE|166,5|25|186|5|167,5|28|180|33|176,5|19|0|112,19|47,81|17|876,5|186|166,5|49,52|17|46,4|17|48,21|19|-2|
 +|19|SCHILTZ Franz|LUX|161,5|36|173,5|16|185|2|184|23|171,5|27|0|112,06|47,94|19|875,5|185|161,5|49,52|17|45,76|15|47,15|17|2|
 +|20|GASPAR Szilvia|HUN|180,5|3|159,5|38|174|18|175|40|180,5|9|0|111,3|48,7|20|869,5|180,5|159,5|49,76|19|46,4|17|47,04|16|4|
 +|21|*RISCH Leonhard|SUI|162|34|178,5|9|171|21|184|23|172|25|0|111,04|48,96|21|867,5|184|162|50,64|21|47,12|21|48,75|20|1|
 +|22|*HOPER Henrik|DEN|163,5|29|171|23|175,5|16|169|57|184,5|4|0|110,53|49,47|22|863,5|184,5|163,5|51,36|23|48|24|50,03|24|-2|
 +|23|*STOKKEN NIELSEN Linn|NOR|163|31|169,5|27|169,5|24|180|33|179,5|11|0|110,27|49,73|23|861,5|180|163|50,96|22|48,24|26|49,39|21|2|
 +|24|*LAUTERBACH Dieter|GER|154|45|173,5|16|166,5|30|191|9|174,5|24|0|110,02|49,98|24|859,5|191|154|53,04|28|47,12|21|50,24|25|-1|
 +|24|WERE Matt|IRL|169,5|18|172,5|20|160,5|38|185|20|172|25|0|110,02|49,98|24|859,5|185|160,5|52,08|26|48,16|25|50,35|26|-2|
 +|26|*MIKKELSEN Oivind|NOR|169,5|18|177|12|166,5|30|179|36|165,5|46|0|109,76|50,24|26|857,5|179|165,5|51,44|24|49,28|30|50,56|28|-2|
 +|27|*HODI Karoly|HUN|169,5|18|170|26|172,5|19|181|30|163,5|50|0|109,63|50,37|27|856,5|181|163,5|51,92|25|49,12|29|50,77|29|-2|
 +|28|*LAWRENCE Elizabeth|AUS|161|37|158,5|42|172,5|19|185|20|177|17|0|109,31|50,69|28|854|185|158,5|52,96|27|48,72|27|51,09|30|-2|
 +|29|*BRISOU Anne Violaine|FRA|172,5|12|176|14|151|52|187|15|165,5|46|0|109,06|50,94|29|852|187|151|53,6|30|47,84|23|50,35|26|3|
 +|30|*ROSSLER Gerald|AUT|160,5|38|159,5|38|170,5|22|189|13|170|30|0|108,74|51,26|30|849,5|189|159,5|54,32|33|49,6|31|53,12|34|-4|
 +|31|*CASSOTTANA Luca|ITA|172|13|172,5|20|151|52|173|43|178|15|0|108,35|51,65|31|846,5|178|151|53,04|28|48,72|27|49,60|23|8|
 +|32|*LANTOS Gabor|HUN|169|22|158,5|42|160|39|186|16|170,5|29|0|108,03|51,97|32|844|186|158,5|54,72|34|50,32|32|53,44|35|-3|
 +|33|*WEBER Isidor|AUT|163,5|29|160|37|167|29|173|43|176,5|19|0|107,52|52,48|33|840|176,5|160|53,84|31|51,2|34|52,59|31|2|
 +|34|BALLESTER MALLOLS Francis|ESP|174|11|172,5|20|160|39|159|69|169,5|31|0|106,88|53,12|34|835|174|159|54,24|32|51,84|36|52,91|32|2|
 +|35|MUSY COMUNE Lucie|SUI|150|55|160,5|36|162|34|186|16|175,5|21|0|106,75|53,25|35|834|186|150|56,32|35|50,56|33|53,76|36|-1|
 +|36|*MOONEN Jan|NED|152,5|49|152|53|160|39|195|3|162,5|53|0|105,22|54,78|36|822|195|152|59,68|46|52,8|38|58,67|51|-15|
 +|37|*RENAUD Eric|SUI|157|44|158,5|42|168|27|185|20|153|69|0|105,15|54,85|37|821,5|185|153|58,16|39|53,04|41|56,85|42|-5|
 +|38|RONDZIK Gabor|HUN|157,5|43|171|23|161,5|35|173|43|158|60|0|105,09|54,91|38|821|173|157,5|56,32|35|53,84|43|55,36|37|1|
 +|39|*HAKALA Saana|FIN|158|42|149|60|161|37|183|26|167,5|42|0|104,77|55,23|39|818,5|183|149|58,32|40|52,88|39|56,21|39|0|
 +|39|QVARNSTROM Cecilia|SWE|141|70|158|45|156|44|195|3|168,5|38|0|104,77|55,23|39|818,5|195|141|60,24|49|51,6|35|57,07|45|-6|
 +|39|*ARNOLD Jacob|USA|146|66|163|33|169|25|171|51|169,5|31|0|104,77|55,23|39|818,5|171|146|56,4|37|52,4|37|53,01|33|6|
 +|42|*PIMBBLET Nicola|GBR|150,5|53|174,5|15|152,5|50|183|26|156|63|0|104,51|55,49|42|816,5|183|150,5|58,64|41|53,44|42|56,96|44|-2|
 +|43|*MARSHALL Janelle|AUS|147,5|62|157,5|46|164|33|172|47|169|35|0|103,68|56,32|43|810|172|147,5|57,92|38|54|44|55,36|37|6|
 +|44|WYNANTS Andre|BEL|165,5|26|151,5|54|136,5|70|186|16|166,5|44|0|103,17|56,83|44|806|186|136,5|60,8|53|52,88|39|56,85|42|2|
 +|45|*SARNAHARJU Marko|FIN|147,5|62|153,5|52|164,5|32|171|51|168|41|0|102,98|57,02|45|804,5|171|147,5|58,64|41|54,88|46|56,32|40|5|
 +|45|*JOHANNESEN Wenche|NOR|160|39|159,5|38|150|56|174|41|161|56|0|102,98|57,02|45|804,5|174|150|59,12|45|55,28|47|57,49|46|-1|
 +|47|*PERINOTTO Marco|ITA|152|51|157|47|154,5|46|172|47|168,5|38|0|102,91|57,09|47|804|172|152|58,88|44|55,68|51|57,60|47|0|
 +|48|DAVIK Eivind|NOR|153|47|155,5|48|144|64|181|30|169,5|31|0|102,78|57,22|48|803|181|144|60,48|50|54,56|45|58,03|49|-1|
 +|49|*LITTLECHILD Ellen|GBR|150,5|53|151,5|54|155|45|182|29|163,5|50|0|102,72|57,28|49|802,5|182|150,5|60,72|52|55,68|51|59,73|56|-7|
 +|49|*LIND Camilla|SWE|148,5|59|159|41|156,5|43|169|57|169,5|31|0|102,72|57,28|49|802,5|169,5|148,5|58,72|43|55,36|49|56,64|41|8|
 +|49|*CROOKSTON Donna|USA|148|61|151,5|54|161,5|35|181|30|160,5|58|0|102,72|57,28|49|802,5|181|148|60,56|51|55,28|47|58,99|54|-5|
 +|52|*APOLINARIO Filipa|POR|158,5|41|154|50|146,5|61|172|47|167|43|0|102,14|57,86|52|798|172|146,5|59,84|47|55,76|53|57,71|48|4|
 +|53|*SIMMONS Sara|GBR|159,5|40|163|33|151|52|170|53|152,5|70|0|101,89|58,11|53|796|170|151|59,84|47|56,8|55|58,67|51|2|
 +|54|*HERNER Johan|SWE|150|55|154|50|149|59|179|36|163|52|0|101,76|58,24|54|795|179|149|61,44|56|56,64|54|60,37|60|-6|
 +|55|*BUCHWALD Udo|DEN|151,5|52|150,5|59|150,5|55|163|64|175|23|0|101,18|58,82|55|790,5|175|150,5|61,52|57|57,6|57|60,80|61|-6|
 +|56|CHODKIEWICZ Alicja|POL|148,5|59|151|57|150|56|170|53|169|35|0|100,93|59,07|56|788,5|170|148,5|61,04|55|57,6|57|59,73|56|0|
 +|57|KUN Andrea|HUN|162,5|32|151|57|132,5|75|177|39|162|54|0|100,48|59,52|57|785|177|132,5|62,72|61|55,6|50|58,56|50|7|
 +|58|*JAMBOR Vilmos|HUN|168|23|161,5|35|145,5|62|140|77|169|35|0|100,35|59,65|58|784|169|140|61,6|58|56,96|56|58,67|51|7|
 +|58|*KOSTRZEWA Adrian|POL|153,5|46|149|60|154,5|46|163|64|164|49|0|100,35|59,65|58|784|164|149|60,8|53|58,4|61|59,52|55|3|
 +|60|LUNARDON Flavio|ITA|149,5|58|147|64|157,5|42|174|41|155|66|0|100,22|59,78|60|783|174|147|62,56|60|58,24|59|61,44|62|-2|
 +|61|*VALENTE Antonio|POR|162|34|154,5|49|144,5|63|168|60|151,5|71|0|99,9|60,1|61|780,5|168|144,5|62|59|58,24|59|60,16|59|2|
 +|62|*VAN HEESCH Saskia|NED|164,5|28|138|71|149,5|58|164|63|155,5|64|0|98,75|61,25|62|771,5|164,5|138|62,88|62|58,64|62|59,95|58|4|
 +|63|*BARTAK Tomas|CZE|146|66|144|66|153,5|48|165|62|161|56|0|98,5|61,5|63|769,5|165|144|63,28|64|59,92|65|61,76|64|-1|
 +|63|*BAIXO Jorge|POR|152,5|49|164,5|30|152,5|50|143|76|157|62|0|98,5|61,5|63|769,5|164,5|143|63,2|63|59,76|64|61,44|62|1|
 +|65|HOUTAPPELS BRUDER Kelly|CAN|145,5|68|149|60|135|72|173|43|165|48|0|98,24|61,76|65|767,5|173|135|64,88|66|58,8|63|61,97|65|0|
 +|66|*CAIRNS Lorraine|AUS|146,5|64|146,5|65|153,5|48|170|53|148,5|74|0|97,92|62,08|66|765|170|146,5|64,8|65|61,04|66|64,32|67|-1|
 +|67|GASPAR Zoltan|HUN|146,5|64|139,5|68|144|64|170|53|158|60|0|97,02|62,98|67|758|170|139,5|65,92|67|61,04|66|64,32|67|0|
 +|68|ATKINSON Patricia|GBR|150|55|138|71|149|59|156|71|150|72|0|95,1|64,9|68|743|156|138|66,08|68|63,2|69|64,21|66|2|
 +|69|*GUTIERREZ Jorge|CHI|153|47|136|73|143,5|66|163|64|145,5|75|0|94,85|65,15|69|741|163|136|67,52|71|63,2|69|65,71|70|-1|
 +|70|ROOSILEHT Pille-Riin|EST|140,5|71|148,5|63|143|67|159|69|149,5|73|0|94,78|65,22|70|740,5|159|140,5|66,96|69|64|71|65,92|71|-1|
 +|71|*MASSMANN Ricardo|CHI|145,5|68|138,5|70|135|72|162|68|154|68|0|94,08|65,92|71|735|162|135|68,32|72|64|71|66,56|72|-1|
 +|72|*PETREK Jaroslav|CZE|139|72|130,5|76|142,5|68|156|71|161,5|55|0|93,38|66,62|72|729,5|161,5|130,5|69,12|73|64,16|73|66,67|73|-1|
 +|73|*KRIZ Jiri|CZE|133,5|76|139|69|130|76|163|64|155,5|64|0|92,29|67,71|73|721|163|130|70,72|74|65,44|74|68,69|74|-1|
 +|74|KOUX Peter|DEN|136,5|74|135,5|74|135,5|71|147|74|154,5|67|0|90,75|69,25|74|709|154,5|135,5|71,28|75|68,24|75|70,61|75|-1|
 +|75|*WIEDER Ane|DEN|135|75|142,5|67|141,5|69|167|61|160,5|58|5|90,55|69,45|75|746,5|167|135|67,28|70|62,16|68|65,17|69|6|
 +|76|CHEREL Yannick|FRA|138|73|135|75|133|74|156|71|143,5|77|0|90,3|69,7|76|705,5|156|133|72,08|76|68,4|76|71,15|76|0|
 +|77|JELINKOVA Marketa|CZE|120|77|126|77|128|77|145|75|145,5|75|15|70,06|89,94|77|664,5|145,5|120|76,96|77|72,88|77|74,88|77|0|
  
2014/mmkouluanalyysi.txt · Viimeksi muutettu: 2016/07/25 19:42 (ulkoinen muokkaus)