WindterOlympics.xlsxWinterOlympics Pivot Table.pdfDATA
MEN/WOMEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
Distance
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
10000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
Rank
1
2
3
4
5
6
7
8
9
10
11
12
13
14
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Athlete
Jorrit BERGSMA
Sven KRAMER
Bob DE JONG
Seung Hoon LEE
Bart SWINGS
Patrick BECKERT
Shane DOBBIN
Moritz GEISREITER
Yevgeny SERYAYEV
Emery LEHMAN
Patrick MEEK
Dmitry BABENKO
Alexej BAUMGAERTNER
Sebastian DRUSZKIEWICZ
Stefan GROOTHUIS
Denny MORRISON
Michel MULDER
Nico IHLE
Samuel SCHWARZ
Koen VERWEIJ
Denis KUZIN
Shani DAVIS
Brian HANSEN
Mark TUITERT
Havard LORENTZEN
Tae Bum MO
Roman KRECH
Zbigniew BRODKA
Joey MANTIA
Konrad NIEDZWIEDZKI
Denis YUSKOV
Aleksey YESIN
Håvard BØKKO
Vincent DE HAITRE
Kyou-Hyuk LEE
Daniel GREIG
Bart SWINGS
Haralds SILOVS
Mirko NINZI
William DUTTON
Dmitry LOBKOV
Jonathan GARCIA
Benjamin MACE
Taeyun KIM
Espen HVAMMEN
Page 1
DATA
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
1000
1000
1000
1000
1000
1000
1000
1000
1000
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
32
33
34
35
36
37
38
39
40
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Muncef OUARDI
Fyodor MEZENTSEV
Guojun TIAN
Taro KONDO
Daichi YAMANAKA
Tommi PULLI
David ANDERSSON
Igor BOGOLYUBSKY
Ching-Yang SUNG
Zbigniew BRODKA
Koen VERWEIJ
Denny MORRISON
Denis YUSKOV
Mark TUITERT
Håvard BØKKO
Brian HANSEN
Sverre Lunde PEDERSEN
Denis KUZIN
Bart SWINGS
Shani DAVIS
Stefan GROOTHUIS
Jan BLOKHUIJSEN
Haralds SILOVS
Jan SZYMANSKI
Havard LORENTZEN
Mirko NINZI
Ivan SKOBREV
Mathieu GIROUX
Konrad NIEDZWIEDZKI
Guojun TIAN
Joey MANTIA
Patrick BECKERT
Aleksey YESIN
Aleksey SUVOROV
Konrad NAGY
Robert LEHMANN
Lucas MAKOWSKY
Hyong Jun JOO
Dmitry BABENKO
Taro KONDO
Benjamin MACE
Vincent DE HAITRE
Aleksandr ZHIGIN
Fyodor MEZENTSEV
Simen SPIELER NILSEN
Jonathan KUCK
Page 2
DATA
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
1500
1500
1500
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
38
39
40
David ANDERSSON
Matteo ANESI
Ewen FERNANDEZ
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Sven KRAMER
Jan BLOKHUIJSEN
Jorrit BERGSMA
Bart SWINGS
Sverre Lunde PEDERSEN
Denis YUSKOV
Ivan SKOBREV
Patrick BECKERT
Håvard BØKKO
Moritz GEISREITER
Aleksandr RUMYANTSEV
Seung Hoon LEE
Jan SZYMANSKI
Shane DOBBIN
Dmitry BABENKO
Emery LEHMAN
Andrea GIOVANNINI
Ewen FERNANDEZ
Jonathan KUCK
Patrick MEEK
Alexej BAUMGAERTNER
Mathieu GIROUX
Sebastian DRUSZKIEWICZ
Cheol Min KIM
Simen SPIELER NILSEN
Shane WILLIAMSON
Hong ZHANG
Ireen WÜST
Margot BOER
Olga FATKULINA
Lotte van BEEK
Marrit LEENSTRA
Heather RICHARDSON
Brittany BOWE
Christine NESBITT
Karolina ERBANOVA
Judith HESSE
Sang Hwa LEE
Nao KODAIRA
Beixing WANG
Yekaterina SHIKHOVA
Page 3
DATA
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1000
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Yuliya SKOKOVA
Ida NJAATUN
Kaylin IRVINE
Yekaterina AYDOVA
Yekaterina LOBYSHEVA
Kali CHRIST
Miyako SUMIYOSHI
Natalia CZERWONKA
Vanessa BITTNER
Jenny WOLF
Gabriele HIRSCHBICHLER
Maki TSUJI
Hyun Yung KIM
Luiza ZLOTKOWSKA
Brittany SCHUSSLER
Seung Ju PARK
Sugar TODD
Kelly GUNTHER
Dan LI
Bo Ra LEE
Jorien TER MORS
Ireen WÜST
Lotte van BEEK
Marrit LEENSTRA
Yuliya SKOKOVA
Katarzyna BACHLEDA-CURUS
Heather RICHARDSON
Yekaterina LOBYSHEVA
Olga FATKULINA
Yekaterina SHIKHOVA
Luiza ZLOTKOWSKA
Ida NJAATUN
Karolina ERBANOVA
Brittany BOWE
Natalia CZERWONKA
Kali CHRIST
Christine NESBITT
Jilleanne ROOKARD
Claudia PECHSTEIN
Jelena PEETERS
Bo Reum KIM
Misaki OSHIGIRI
Xin ZHAO
Monique ANGERMUELLER
Page 4
DATA
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
1500
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
5000
5000
5000
5000
5000
25
26
27
28
29
30
31
32
33
34
35
36
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
1
2
3
4
5
Maki TABATA
Brittany SCHUSSLER
Qishi LI
Yekaterina AYDOVA
Seon Yeong NOH
Gabriele HIRSCHBICHLER
Ayaka KIKUCHI
Nana TAKAGI
Hege BOKKO
Vanessa BITTNER
Brianne TUTT
Shin Young YANG
Ireen WÜST
Martina SABLIKOVA
Olga GRAF
Claudia PECHSTEIN
Annouk VAN DER WEIJDEN
Ida NJAATUN
Antoinette DE JONG
Yuliya SKOKOVA
Shiho ISHIZAWA
Jilleanne ROOKARD
Bente KRAUS
Jelena PEETERS
Bo Reum KIM
Mari HEMMER
Shoko FUJIMURA
Natalia CZERWONKA
Stephanie BECKERT
Luiza ZLOTKOWSKA
Brittany SCHUSSLER
Yekaterina SHIKHOVA
Masako HOZUMI
Anna Natalia ROKITA
Francesca LOLLOBRIGIDA
Ivanie BLONDIN
Seon Yeong NOH
Anna RINGSRED
Shin Young YANG
Martina SABLIKOVA
Ireen WÜST
Carien KLEIBEUKER
Olga GRAF
Claudia PECHSTEIN
Page 5
DATA
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
WOMEN
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
5000
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
6
7
8
9
10
11
12
13
14
15
16
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Yvonne NAUTA
Mari HEMMER
Stephanie BECKERT
Anna CHERNOVA
Shoko FUJIMURA
Bente KRAUS
Shiho ISHIZAWA
Masako HOZUMI
Ivanie BLONDIN
Katarzyna WOZNIAK
Maria LAMB
Sang Hwa LEE
Olga FATKULINA
Margot BOER
Hong ZHANG
Nao KODAIRA
Jenny WOLF
Beixing WANG
Heather RICHARDSON
Maki TSUJI
Karolina ERBANOVA
Laurine VAN RIESSEN
Christine NESBITT
Brittany BOWE
Miyako SUMIYOSHI
Lauren CHOLEWINSKI
Lotte van BEEK
Yekaterina MALYSHEVA
Angelina GOLIKOVA
Marrit LEENSTRA
Bo Ra LEE
Denise ROTH
Yekaterina AYDOVA
Shuai QI
Hyun Yung KIM
Yekaterina LOBYSHEVA
Seung Ju PARK
Vanessa BITTNER
Anastasia BUCSIS
Sugar TODD
Yvonne DALDOSSI
Shuang ZHANG
Marsha HUDEY
Danielle WOTHERSPOON
Page 6
DATA
WOMEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
MEN
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
2×500
34
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Gabriele HIRSCHBICHLER
Michel MULDER
Jan SMEEKENS
Ronald MULDER
Tae Bum MO
Joji KATO
Keiichiro NAGASHIMA
Roman KRECH
Nico IHLE
Artur WAS
Gilmore JUNIO
Jamie GREGG
Espen HVAMMEN
Denis KOVAL
William DUTTON
Yuya OIKAWA
Aleksey YESIN
Pekka KOSKELA
Kyou-Hyuk LEE
Artyom KUZNETCOV
Yuji KAMIJO
Junho KIM
Kang Seok LEE
Dmitry LOBKOV
Shani DAVIS
Muncef OUARDI
Tucker FREDRICKS
Mitchell WHITMORE
Mirko NINZI
Mika POUTALA
Zhongsheng MU
David BOSA
Havard LORENTZEN
Ching-Yang SUNG
Samuel SCHWARZ
Qiuming BAI
Artur NOGAL
Haralds SILOVS
Stefan GROOTHUIS
Daniel GREIG
Page 7
DATA
Country
NED
NED
NED
KOR
BEL
GER
NZL
GER
RUS
USA
USA
KAZ
GER
POL
NED
CAN
NED
GER
GER
NED
KAZ
USA
USA
NED
NOR
KOR
KAZ
POL
USA
POL
RUS
RUS
NOR
CAN
KOR
AUS
BEL
LAT
ITA
CAN
RUS
USA
FRA
KOR
NOR
Continent
EU
EU
EU
AS
EU
EU
OC
EU
EU
NA
NA
AS
EU
EU
EU
NA
EU
EU
EU
EU
AS
NA
NA
EU
EU
AS
AS
EU
NA
EU
EU
EU
EU
NA
AS
OC
EU
EU
EU
NA
EU
NA
EU
AS
EU
Result
12:44.45
12:49.02
13:07.19
13:11.68
13:13.99
13:14.26
13:16.42
13:20.26
13:28.61
13:28.67
13:28.72
13:33.18
13:44.39
13:45.31
1:08.39
1:08.43
1:08.74
1:08.86
1:08.89
1:09.09
1:09.10
1:09.12
1:09.21
1:09.29
1:09.33
1:09.37
1:09.63
1:09.66
1:09.72
1:09.76
1:09.81
1:09.93
1:09.98
1:10.04
1:10.05
1:10.13
1:10.14
1:10.29
1:10.32
1:10.61
1:10.65
1:10.74
1:10.80
1:10.81
1:11.01
Date
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/18/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
Page 8
DATA
CAN
KAZ
CHN
JPN
JPN
FIN
SWE
RUS
TPE
POL
NED
CAN
RUS
NED
NOR
USA
NOR
KAZ
BEL
USA
NED
NED
LAT
POL
NOR
ITA
RUS
CAN
POL
CHN
USA
GER
RUS
RUS
HUN
GER
CAN
KOR
KAZ
JPN
FRA
CAN
KAZ
KAZ
NOR
USA
NA
AS
AS
AS
AS
EU
EU
EU
AS
EU
EU
NA
EU
EU
EU
NA
EU
AS
EU
NA
EU
EU
EU
EU
EU
EU
EU
NA
EU
AS
NA
EU
EU
EU
EU
EU
NA
AS
AS
AS
EU
NA
AS
AS
EU
NA
1:11.07
1:11.08
1:11.17
1:11.44
1:11.93
1:12.16
1:12.40
1:12.85
1:13.79
1:45.01
1:45.01
1:45.22
1:45.37
1:45.42
1:45.48
1:45.59
1:45.66
1:45.69
1:45.95
1:45.98
1:46.08
1:46.50
1:46.79
1:46.86
1:47.27
1:47.48
1:47.62
1:47.65
1:47.77
1:47.95
1:48.01
1:48.08
1:48.10
1:48.11
1:48.12
1:48.24
1:48.51
1:48.59
1:48.67
1:49.31
1:49.34
1:49.42
1:49.48
1:49.70
1:49.88
1:50.19
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/12/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
2/15/2014
Page 9
DATA
SWE
ITA
FRA
NED
NED
NED
BEL
NOR
RUS
RUS
GER
NOR
GER
RUS
KOR
POL
NZL
KAZ
USA
ITA
FRA
USA
USA
GER
CAN
POL
KOR
NOR
JPN
CHN
NED
NED
RUS
NED
NED
USA
USA
CAN
CZE
GER
KOR
JPN
CHN
RUS
EU
EU
EU
EU
EU
EU
EU
EU
EU
EU
EU
EU
EU
EU
AS
EU
OC
AS
NA
EU
EU
NA
NA
EU
NA
EU
AS
EU
AS
AS
EU
EU
EU
EU
EU
NA
NA
NA
EU
EU
AS
AS
AS
EU
1:50.29 2/15/2014
1:50.59 2/15/2014
1:52.70 2/15/2014
6:10.76 2/8/2014
6:15.71 2/8/2014
6:16.66 2/8/2014
6:17.79 2/8/2014
6:18.84 2/8/2014
6:19.51 2/8/2014
6:19.83 2/8/2014
6:21.18 2/8/2014
6:22.83 2/8/2014
6:24.79 2/8/2014
6:24.93 2/8/2014
6:25.61 2/8/2014
6:26.35 2/8/2014
6:26.90 2/8/2014
6:28.26 2/8/2014
6:29.94 2/8/2014
6:30.84 2/8/2014
6:31.08 2/8/2014
6:31.53 2/8/2014
6:32.94 2/8/2014
6:34.34 2/8/2014
6:35.77 2/8/2014
6:37.16 2/8/2014
6:37.28 2/8/2014
6:42.47 2/8/2014
6:42.88 2/8/2014
1:14.02 2/13/2014
1:14.69 2/13/2014
1:14.90 2/13/2014
1:15.08 2/13/2014
1:15.10 2/13/2014
1:15.15 2/13/2014
1:15.23 2/13/2014
1:15.47 2/13/2014
1:15.62 2/13/2014
1:15.74 2/13/2014
1:15.84 2/13/2014
1:15.94 2/13/2014
1:16.45 2/13/2014
1:16.59 2/13/2014
1:17.01 2/13/2014
Page 10
DATA
RUS
NOR
CAN
KAZ
RUS
CAN
JPN
POL
AUT
GER
GER
JPN
KOR
POL
CAN
KOR
USA
USA
CHN
KOR
NED
NED
NED
NED
RUS
POL
USA
RUS
RUS
RUS
POL
NOR
CZE
USA
POL
CAN
CAN
USA
GER
BEL
KOR
JPN
CHN
GER
EU
EU
NA
AS
EU
NA
AS
EU
EU
EU
EU
AS
AS
EU
NA
AS
NA
NA
AS
AS
EU
EU
EU
EU
EU
EU
NA
EU
EU
EU
EU
EU
EU
NA
EU
NA
NA
NA
EU
EU
AS
AS
AS
EU
1:17.02
1:17.15
1:17.24
1:17.25
1:17.31
1:17.41
1:17.68
1:17.93
1:17.94
1:17.99
1:18.00
1:18.07
1:18.10
1:18.38
1:18.53
1:18.94
1:19.13
1:19.43
1:20.20
1:57.49
1:53.51
1:54.09
1:54.54
1:56.40
1:56.45
1:57.18
1:57.60
1:57.70
1:57.88
1:58.09
1:58.18
1:58.21
1:58.23
1:58.31
1:58.46
1:58.63
1:58.67
1:59.15
1:59.47
1:59.73
1:59.78
2:00.03
2:00.27
2:00.32
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/13/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
Page 11
DATA
JPN
CAN
CHN
KAZ
KOR
GER
JPN
JPN
NOR
AUT
CAN
KOR
NED
CZE
RUS
GER
NED
NOR
NED
RUS
JPN
USA
GER
BEL
KOR
NOR
JPN
POL
GER
POL
CAN
RUS
JPN
AUT
ITA
CAN
KOR
USA
KOR
CZE
NED
NED
RUS
GER
AS
NA
AS
AS
AS
EU
AS
AS
EU
EU
NA
AS
EU
EU
EU
EU
EU
EU
EU
EU
AS
NA
EU
EU
AS
EU
AS
EU
EU
EU
NA
EU
AS
EU
EU
NA
AS
NA
AS
EU
EU
EU
EU
EU
2:00.64
2:00.65
2:00.89
2:00.93
2:01.07
2:01.18
2:01.29
2:02.16
2:02.53
2:02.84
2:03.69
2:04.13
4:00.34
4:01.95
4:03.47
4:05.26
4:05.75
4:06.73
4:06.77
4:09.36
4:09.39
4:10.02
4:10.17
4:10.87
4:12.08
4:12.21
4:12.71
4:13.26
4:13.55
4:14.19
4:14.65
4:14.97
4:15.52
4:16.43
4:16.52
4:18.70
4:19.02
4:21.51
4:23.67
6:51.54
6:54.28
6:55.66
6:55.77
6:58.39
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/16/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/9/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
Page 12
DATA
NED
NOR
GER
RUS
JPN
GER
JPN
JPN
CAN
POL
USA
KOR
RUS
NED
CHN
JPN
GER
CHN
USA
JPN
CZE
NED
CAN
USA
JPN
USA
NED
RUS
RUS
NED
KOR
GER
KAZ
CHN
KOR
RUS
KOR
AUT
CAN
USA
ITA
CHN
CAN
CAN
EU
EU
EU
EU
AS
EU
AS
AS
NA
EU
NA
AS
EU
EU
AS
AS
EU
AS
NA
AS
EU
EU
NA
NA
AS
NA
EU
EU
EU
EU
AS
EU
AS
AS
AS
EU
AS
EU
NA
NA
EU
AS
NA
NA
7:01.76
7:04.45
7:07.79
7:08.71
7:09.65
7:10.65
7:11.54
7:12.42
7:20.10
7:28.53
7:29.64
1:14.70
1:15.06
1:15.48
1:15.58
1:15.61
1:15.67
1:15.68
1:15.75
1:16.84
1:16.86
1:16.99
1:17.15
1:17.19
1:17.26
1:17.35
1:17.40
1:17.55
1:17.68
1:17.74
1:17.75
1:17.78
1:17.85
1:17.89
1:18.23
1:18.24
1:18.31
1:18.50
1:18.52
1:18.53
1:18.64
1:18.65
1:19.22
1:19.32
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/19/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
2/11/2014
Page 13
DATA
GER
NED
NED
NED
KOR
JPN
JPN
KAZ
GER
POL
CAN
CAN
NOR
RUS
CAN
JPN
RUS
FIN
KOR
RUS
JPN
KOR
KOR
RUS
USA
CAN
USA
USA
ITA
FIN
CHN
ITA
NOR
TPE
GER
CHN
POL
LAT
NED
AUS
EU
EU
EU
EU
AS
AS
AS
AS
EU
EU
NA
NA
EU
EU
NA
AS
EU
EU
AS
EU
AS
AS
AS
EU
NA
NA
NA
NA
EU
EU
AS
EU
EU
AS
EU
AS
EU
EU
EU
OC
1:19.51
1:09.31
1:09.32
1:09.46
1:09.69
1:09.74
1:10.04
1:10.05
1:10.10
1:10.21
1:10.25
1:10.27
1:10.42
1:10.44
1:10.45
1:10.46
1:10.50
1:10.61
1:10.65
1:10.66
1:10.85
1:10.86
1:10.87
1:10.88
1:10.98
1:11.00
1:11.00
1:11.06
1:11.07
1:11.14
1:11.25
1:11.28
1:11.30
1:11.36
1:11.37
1:11.45
1:11.49
1:12.44
1:32.24
1:55.84
2/11/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
2/10/2014
Page 14
Excel Formula Exercises – LAB 3
Winter Olympics Data Analysis
In 2014 Sochi hosted the Winter Olympics where many countries to win some medals.
For this assignment, we provide you with data that lists all the achievements of the
different skating athletes. The spreadsheet can be found on blackboard. For each of the
following questions, you will create the needed Pivot Table.
Create Pivot Table/Chart
Step 1: Mark A1:H308
Step 2: Click on the Insert. Choose the PivotChart.
Step 3: Select Ok
Step 4: You will see the following screen.
Step 5: Drag and drop the PivotChartFields on the right side to Drag fields at the bottom.
Answer the following questions
1. Which man participated in the most events?
2. Which woman participated in the most events?
3. How many men participated for the host country Russia(RUS), including doubles (i.e., if
a certain person participated in two events, you should include him twice)?
4. Which countries scored at least one medal on any of the distances?
5. Which countries at least one top 10 classification on any of the distances?
6. Order the Top 5 countries below from best to worst based on the average rank. For
example, if a country has two athletes and one ranks 2nd and the other 4th, the country’s
average rank is 3. Please keep in mind that a rank 1 is better than rank 2!
Countries
AUS
BEL
Top 5 countries
CZE
1.
FIN
2.
GER
3.
ITA
4.
JPN
5.
LAT
NOR
NZL
POL
USA
7. We want to know which athletes did an exceptionally fine job. Select the athlete(s) that
won at least one gold and at least one silver medal.
a)
b)
c)
8. Save and submit your file as in IS3310In Class Lab3YourName.docx.
Submit the file on the blackboard.
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.