Last Name Year of Gender Salary Age Department Supervisor Education Rating

Hire

Abbar 1985 F $ 91,000 46.2 4302 Marsh 4 B

Abercrombie 1985 F $ 50,000 53.9 5894 Lindsay 4 B
Ackerman 1989 F $ 31,000 58.2 5894 Yang 5 C
Adell 1981 F $ 48,000 44.0 4308 Kwatra 2 E
Akers 1979 F $ 47,000 50.7 4303 Marsh 5 D
Akhtar 1989 F $ 90,000 38.6 5894 Lindsay 5 D
Alboucq 1992 F $ 100,000 44.5 4308 Yang 4 E
Alexander 2000 M $ 29,000 46.2 4308 Kwatra 5 A
Anderson 1992 F $ 59,000 36.1 4308 Marsh 2 A
Anderson 1986 M $ 48,000 32.5 4509 Marsh 4 E
Atkinson 1988 F $ 55,000 47.9 4372 Yang 5 A
Bacon Jr. 1974 M $ 62,000 59.6 4509 Kwatra 1 D
Baldwin 1975 F $ 100,000 31.0 4308 Lindsay 1 C
Barbariol 1996 F $ 92,000 44.6 4509 Yang 5 D
Barnhill 1977 M $ 83,000 54.2 4312 Lindsay 1 E
Barr 1993 M $ 66,000 49.7 4372 Yang 1 A
Barrett 1995 F $ 65,000 36.9 4302 Yang 5 A
Beck 1998 M $ 70,000 50.8 4312 Kwatra 5 A
Ben-Sachar 1993 F $ 77,000 52.4 4509 Lindsay 5 D
Benson 1977 M $ 97,000 33.3 4509 Lindsay 4 D
Berge 1997 F $ 45,000 43.8 4302 Marsh 1 E
Berglund 1988 M $ 93,000 54.1 4370 Lindsay 5 A
Bergman 1991 M $ 58,000 30.9 4302 Kwatra 4 A
Berry 2000 F $ 76,000 42.5 4302 Lindsay 3 E
Bockman 1998 F $ 43,000 57.1 4509 Yang 2 A
Bonifaz 1996 M $ 77,000 40.7 4365 Lindsay 1 D
Borm 1986 M $ 55,000 45.1 4370 Yang 1 C
Boseman 1976 M $ 74,000 37.7 6004 Yang 5 D
Bott 1986 M $ 82,000 55.3 4509 Kwatra 4 E
Bourne 1977 F $ 33,000 57.5 4308 Lindsay 5 D
Bowen 1986 F $ 65,000 36.9 5894 Lindsay 3 E
Boyle 1997 F $ 50,000 52.8 4308 Marsh 1 A
Bradley 1984 M $ 33,000 54.8 4308 Lindsay 5 A
Bready 1984 M $ 27,000 52.5 4365 Kwatra 3 E
Bremer 1989 M $ 99,000 49.7 4509 Kwatra 2 A
Brooke 1982 F $ 35,000 40.1 4305 Kwatra 3 D
Brown 1989 F $ 34,000 31.8 4372 Yang 1 C
Brown 1988 M $ 26,000 35.2 4308 Lindsay 3 D
Browne 1998 M $ 83,000 52.1 4372 Yang 2 E
Buhl 1983 M $ 83,000 31.6 4509 Yang 4 B
Campbell 1976 M $ 80,000 42.2 4372 Kwatra 1 B
Campbell 1989 M $ 61,000 32.3 4509 Lindsay 4 C
Carey 1976 M $ 82,000 43.1 5894 Lindsay 2 E
Carlson 1988 M $ 42,000 58.5 4308 Marsh 4 D
Caron 1997 M $ 85,000 50.7 5894 Lindsay 2 D
Castaneda 1991 F $ 25,000 39.6 4367 Kwatra 1 E
Chai 1977 M $ 86,000 42.7 4308 Lindsay 4 A
Chapman 1995 M $ 36,000 54.3 4372 Yang 4 A
Charney 1977 M $ 68,000 57.3 4303 Lindsay 5 E
Chen 1978 M $ 74,000 42.4 6004 Yang 3 A
Chor 1980 M $ 68,000 48.5 4305 Yang 2 D
Clayton 1988 F $ 46,000 53.8 4372 Marsh 2 C
Coake 1994 M $ 99,000 47.8 4509 Yang 2 D
Coleman 1985 F $ 81,000 30.4 4302 Lindsay 1 E
Con 1987 M $ 26,000 59.0 4370 Yang 2 A
Connelly 1974 M $ 42,000 48.6 4370 Kwatra 3 A
Conroy 1983 F $ 96,000 38.5 4305 Marsh 3 A
Cooper 1997 M $ 48,000 42.1 4302 Kwatra 1 D
Corets 1978 F $ 79,000 33.9 4302 Yang 3 D
Cornfield 1980 M $ 95,000 33.2 4366 Kwatra 5 E
Cox 1983 F $ 65,000 57.0 4371 Yang 2 A
Culbert 1983 F $ 71,000 45.4 4305 Lindsay 5 A
Culp 1992 M $ 38,000 58.0 4372 Yang 2 E
Dalal 1986 M $ 33,000 49.5 5894 Yang 2 A
Dale 1992 F $ 54,000 58.7 4302 Kwatra 4 D
Danseglio 1989 M $ 84,000 38.4 4509 Lindsay 5 C
Daum 1990 F $ 30,000 56.6 4312 Lindsay 5 D
DeBroux 1999 M $ 98,000 54.2 4372 Marsh 4 E
Delaney 1979 M $ 57,000 55.1 4302 Lindsay 1 D
Dickmann 1983 F $ 37,000 59.2 4509 Kwatra 3 E
Dirksen 1999 M $ 59,000 51.2 6004 Lindsay 1 A
Dixon 1984 M $ 37,000 36.4 4305 Yang 4 A
Dolliver 1980 F $ 52,000 39.6 4509 Lindsay 4 E
Dowler 1997 M $ 25,000 30.6 4308 Yang 2 A
Doyle 1996 F $ 30,000 54.2 6004 Yang 5 D
Dresen 1986 F $ 51,000 56.8 4305 Marsh 2 C
Dunn 1975 M $ 68,000 57.2 4370 Lindsay 4 D
Dunn 1999 M $ 79,000 53.4 4509 Yang 4 E
Durasoff 1975 F $ 77,000 41.3 5894 Kwatra 5 D
Durkin 1977 F $ 52,000 58.0 4370 Marsh 4 C
Egert 1994 F $ 72,000 40.9 5894 Lindsay 4 D
Emanuel 1980 M $ 39,000 36.9 4372 Yang 4 E
Esack 1993 F $ 83,000 57.0 4308 Kwatra 4 D
Fallon 1993 M $ 64,000 51.7 4509 Marsh 3 E
Fine 1982 F $ 37,000 40.5 6004 Marsh 3 A
Fitzgerald 1975 M $ 63,000 50.8 4305 Yang 2 A
Fleming 1997 M $ 53,000 33.5 4509 Kwatra 3 E
Flood 1992 F $ 32,000 43.7 4312 Lindsay 4 A
Fluegel 1979 M $ 35,000 44.1 6004 Yang 2 D
Focht 1992 F $ 86,000 32.7 4308 Lindsay 2 C
Fort 1994 M $ 36,000 30.8 4370 Yang 1 D
Fortune 1984 M $ 34,000 53.6 4305 Yang 4 E
Fredericksen 1995 M $ 58,000 59.3 4303 Kwatra 5 B
Frey 1982 M $ 39,000 44.0 4370 Lindsay 2 B
Fuller 1999 F $ 62,000 55.4 4302 Lindsay 2 C
Funk 1989 M $ 94,000 53.6 6004 Marsh 4 E
Galos 1989 M $ 30,000 57.3 4509 Lindsay 1 D
Gambardella 1984 M $ 27,000 35.9 4365 Kwatra 2 D
Ganio 1990 M $ 36,000 51.0 4509 Lindsay 1 E
Garmaise 1992 F $ 94,000 38.7 5894 Yang 1 A
Gavriluk 1981 M $ 45,000 50.2 4308 Lindsay 4 A
Gerend 1996 M $ 91,000 48.9 6004 Yang 1 E
Getzinger 1982 M $ 80,000 33.3 4308 Yang 4 A
Gillmann 1998 M $ 53,000 53.1 4302 Kwatra 2 A
Glynn 1997 M $ 61,000 38.6 6004 Lindsay 1 E
Gode 1986 M $ 28,000 54.1 4302 Lindsay 4 A
Gode 1985 M $ 74,000 44.4 4308 Marsh 5 D
Goldberg 1980 M $ 32,000 30.0 4302 Lindsay 2 C
Goodhand 1983 M $ 85,000 47.4 4509 Kwatra 4 D
Graff 1998 M $ 75,000 57.3 4308 Kwatra 1 E
Graham 2000 M $ 30,000 47.1 4313 Kwatra 3 D
Grande 1978 M $ 75,000 58.3 4509 Yang 5 E
Gray 1999 M $ 65,000 49.8 4302 Lindsay 5 A
Greenberg 1975 M $ 58,000 34.1 4509 Yang 1 A
Groncki 1986 M $ 70,000 46.4 5894 Yang 3 E
Guo 1988 M $ 42,000 34.5 4312 Kwatra 2 A
Hall 1999 M $ 75,000 46.8 5894 Lindsay 3 D
Hamilton 1977 M $ 43,000 34.3 4509 Lindsay 3 C
Hampton 1996 M $ 42,000 50.4 4509 Marsh 3 D
Hance 1975 M $ 57,000 30.9 4509 Lindsay 5 E
Hanson 1993 M $ 57,000 43.6 4302 Kwatra 2 D
Harris 1995 M $ 57,000 54.9 5894 Lindsay 4 C
Hart 1981 F $ 74,000 30.8 4302 Yang 5 D
Hartwig 1977 F $ 100,000 34.7 4509 Lindsay 3 E
Harui 1985 M $ 28,000 36.4 4308 Yang 2 D
Hassall 1995 M $ 44,000 56.1 4308 Yang 2 E
Hector 1981 F $ 97,000 57.7 4372 Marsh 2 A
Henningsen 1987 M $ 43,000 35.5 4370 Yang 5 A
Henshaw 1999 M $ 87,000 56.7 4509 Lindsay 4 E
Hensien 1992 F $ 39,000 58.0 5894 Yang 2 A
Hepp 1996 M $ 76,000 49.9 4365 Kwatra 5 D
Herlan 1995 M $ 50,000 42.5 4365 Marsh 1 B
Hightower 1990 F $ 94,000 41.1 4305 Kwatra 2 B
Hinsch 1979 F $ 38,000 55.9 4509 Yang 3 C
Hirsch 1987 F $ 41,000 52.5 4302 Kwatra 1 E
Hjellen 1999 F $ 62,000 47.7 5894 Yang 5 D
Hoeing 1979 F $ 34,000 53.1 4302 Lindsay 5 D
Hoffman 1995 F $ 100,000 38.5 5894 Yang 3 E
Hohman 1993 M $ 52,000 57.6 4308 Yang 4 A
Hollands 1985 M $ 55,000 54.2 4308 Kwatra 3 A
Holm 1980 M $ 65,000 40.1 4509 Lindsay 5 E
Hooper 1982 F $ 81,000 31.4 4302 Lindsay 1 A
Hornig 1984 M $ 44,000 50.8 4305 Marsh 5 D
Horton 1991 M $ 57,000 48.4 4308 Lindsay 1 C
Houston 1982 M $ 59,000 31.8 5894 Kwatra 1 D
Howard 1991 M $ 78,000 58.9 4365 Lindsay 5 E
Huff 1994 F $ 56,000 37.1 4372 Yang 5 A
I. Martinez 2000 F $ 89,000 37.3 4305 Lindsay 5 A
Inman 1975 F $ 63,000 45.2 4365 Yang 1 A
Iwema 1980 F $ 58,000 42.2 6004 Yang 1 D
J. Erickson 1986 M $ 93,000 56.2 4305 Marsh 3 D
Jackson 2000 F $ 71,000 49.0 4370 Lindsay 3 E
Jacobson 1988 F $ 76,000 52.7 4370 Yang 2 A
Jaffe 1976 M $ 57,000 51.4 4302 Kwatra 1 A
Jamison 1974 M $ 82,000 32.0 4303 Marsh 4 E
Jennings 1975 F $ 82,000 35.5 6004 Lindsay 4 A
Jensen 1989 M $ 71,000 49.8 4370 Yang 3 D
Johnson 1993 M $ 44,000 57.1 4370 Kwatra 1 C
Johnston 1976 M $ 49,000 35.9 4365 Marsh 5 D
Jones 1982 F $ 34,000 49.1 4509 Marsh 3 E
Jones 1986 F $ 43,000 49.9 4365 Yang 1 D
Jordan 1977 F $ 39,000 50.4 4305 Kwatra 4 E
Kaethler 1999 F $ 53,000 33.8 6004 Lindsay 4 A
Kahn 1988 F $ 42,000 46.3 4308 Yang 1 A
Kaplan 1980 M $ 78,000 52.5 4302 Lindsay 1 E
Kearney 1992 F $ 39,000 55.2 4302 Yang 3 A
Keil 1990 M $ 71,000 55.2 5894 Yang 3 D
Kelley 1994 F $ 34,000 33.9 5894 Kwatra 2 C
Kelly 1981 M $ 45,000 30.4 4509 Lindsay 5 D
Kelly 1999 M $ 86,000 43.7 4308 Lindsay 1 E
Kelly 1987 M $ 74,000 30.8 4509 Marsh 3 B
Kennedy 1997 M $ 84,000 34.1 4370 Lindsay 4 B
Khanna 1982 F $ 49,000 53.0 4370 Kwatra 3 C
Kilwine 1992 F $ 90,000 45.5 4372 Lindsay 1 E
Kim 1976 M $ 59,000 33.0 4302 Yang 3 D
Kirtland 1975 M $ 82,000 30.1 4302 Lindsay 3 D
Knorr 1995 M $ 27,000 31.1 6001 Yang 5 E
Kobara 1977 F $ 70,000 42.5 4370 Yang 2 A
Kobylka 1982 F $ 55,000 34.3 5894 Kwatra 3 A
Koch 1977 M $ 75,000 40.6 4308 Lindsay 2 E
Koduri 1982 F $ 39,000 49.8 5894 Lindsay 4 A
Krakowski 1985 M $ 53,000 35.9 6004 Marsh 5 D
Kress 1990 M $ 44,000 41.6 4370 Lindsay 2 C
Kunze 1997 F $ 72,000 35.7 4308 Kwatra 4 D
L. Paper 1998 F $ 82,000 44.3 4305 Kwatra 2 E
LaBrie 1999 M $ 94,000 59.0 4302 Kwatra 2 A
Lang 1986 M $ 42,000 38.7 4509 Yang 4 A
Larsen 1998 F $ 26,000 57.3 5894 Lindsay 2 A
Lawler 1987 M $ 84,000 48.9 4312 Yang 2 D
Lee 1978 M $ 32,000 53.0 5894 Yang 2 D
Lee 1989 M $ 84,000 51.0 4509 Kwatra 5 E
Lenehan 1990 F $ 100,000 47.2 4308 Lindsay 5 A
Leonetti 1977 F $ 26,000 31.4 4305 Lindsay 5 A
Leste 1976 F $ 94,000 47.5 4302 Marsh 5 E
Levy 1999 M $ 92,000 40.3 4372 Lindsay 5 A
Lew 2000 F $ 53,000 59.2 6004 Kwatra 2 D
Loudon 1991 M $ 83,000 59.2 5894 Lindsay 2 C
Luehmann 1975 F $ 100,000 31.5 4365 Yang 3 D
Lugo 1995 M $ 92,000 51.7 6004 Lindsay 1 E
Lum 1996 M $ 68,000 41.2 4509 Yang 4 D
Lyon 1977 M $ 43,000 55.5 4302 Yang 1 E
Lysaker 1985 F $ 85,000 55.4 4312 Marsh 3 A
Maffei 1995 M $ 45,000 58.3 4308 Yang 1 A
Mangione 1995 F $ 95,000 32.5 5894 Lindsay 5 E
Martin 1987 M $ 57,000 30.7 4370 Yang 3 A
Martin 1993 F $ 52,000 32.2 5894 Kwatra 5 D
Marton 1984 F $ 85,000 53.0 4370 Marsh 5 C
Masters 1977 M $ 39,000 48.3 4370 Kwatra 2 D
Matey 1991 M $ 99,000 44.4 4302 Yang 2 E
Matthews 1990 M $ 91,000 37.3 4305 Kwatra 2 D
McAskill-White 1999 F $ 46,000 43.5 6004 Yang 2 C
McCann 1989 M $ 47,000 59.7 4308 Lindsay 4 D
McCormick 1991 F $ 37,000 40.2 4509 Yang 1 E
McGinn 1990 F $ 56,000 33.5 4302 Yang 2 D
Mendlen 1979 M $ 27,000 36.2 4308 Kwatra 4 E
Meng 1996 M $ 68,000 39.5 4509 Lindsay 5 A
Meyer 1982 F $ 66,000 35.1 4509 Lindsay 2 A
Miksovsky 1988 F $ 94,000 37.1 4302 Marsh 3 E
Miller 1977 M $ 64,000 57.4 4509 Lindsay 2 A
Miller 1984 M $ 97,000 37.5 4305 Kwatra 2 D
Miller 1998 M $ 86,000 52.7 5894 Lindsay 2 C
Mintz 1996 F $ 50,000 38.3 4365 Yang 5 D
Mitchell 1992 F $ 79,000 41.9 4509 Lindsay 1 E
Mitchell 1999 F $ 62,000 45.3 4509 Yang 5 B
Mollerup 1990 M $ 69,000 46.5 4305 Yang 2 B
Morgan 1990 F $ 72,000 56.9 4509 Marsh 5 C
Moris 1979 F $ 56,000 48.7 4372 Lindsay 3 E
Morris 1987 M $ 74,000 33.4 4370 Yang 4 D
Moseley 1997 F $ 79,000 50.1 6004 Kwatra 3 D
Mughal 1990 M $ 64,000 33.6 4370 Marsh 3 E
Munson 1996 M $ 86,000 35.2 5894 Lindsay 5 A
Muth 1992 M $ 44,000 30.1 4308 Yang 3 A
Nagata 1993 F $ 94,000 32.0 4509 Kwatra 5 E
Nash 1974 M $ 100,000 59.2 4370 Marsh 4 A
Nay 1975 F $ 84,000 38.0 4308 Marsh 1 A
Nelson 1986 M $ 66,000 42.3 6004 Yang 4 E
Niikkonen 1988 F $ 47,000 30.0 4509 Kwatra 3 A
Nikore 1980 F $ 25,000 43.3 4370 Lindsay 3 D
Nixon 1985 M $ 62,000 35.6 4305 Yang 3 C
Norman 1981 F $ 37,000 57.9 4509 Lindsay 2 D
O’Brien 1985 M $ 66,000 55.3 4305 Yang 2 E
O’Hara 2000 M $ 26,000 53.8 4302 Yang 4 D
O’Melia 1994 F $ 78,000 55.6 6004 Kwatra 5 E
Oberg 1987 M $ 36,000 36.3 4302 Lindsay 4 A
Ogisu 1982 F $ 49,000 39.9 4370 Lindsay 1 A
Opdyche 1999 M $ 34,000 58.5 4509 Marsh 3 E
Orman 1978 M $ 68,000 35.3 6004 Lindsay 4 A
Ota Carpenter 1975 F $ 92,000 39.0 4365 Kwatra 2 D
Ota 1984 F $ 60,000 37.8 4509 Lindsay 1 C
Pak 1997 M $ 97,000 40.4 4312 Yang 5 D
Pardi 1981 M $ 41,000 57.4 4302 Lindsay 5 E
Parsons 1985 F $ 36,000 53.0 4509 Yang 2 D
Patten 1996 M $ 31,000 53.6 5894 Yang 3 C
Penn 1990 M $ 53,000 42.8 4302 Kwatra 2 D
Perera 1977 M $ 26,000 59.3 4370 Lindsay 3 E
Perry 1976 M $ 77,000 49.2 4302 Lindsay 1 D
Philips 2000 F $ 97,000 44.8 4302 Marsh 3 E
Phua 1987 F $ 42,000 55.5 4372 Lindsay 2 A
Piira 1998 M $ 86,000 43.8 4305 Kwatra 3 A
Poland 1976 F $ 45,000 34.5 4509 Kwatra 2 E
Porzuczek 1997 M $ 28,000 47.7 4305 Kwatra 5 A
Preston 2000 F $ 53,000 54.9 4305 Yang 5 D
Price 1992 M $ 89,000 31.3 4370 Lindsay 5 B
Purcell 1990 M $ 34,000 48.1 4370 Yang 4 B
Raddatz 2000 M $ 73,000 46.2 4302 Yang 2 C
Ralls 1977 F $ 52,000 43.4 4372 Kwatra 5 E
Ramirez 1980 M $ 32,000 42.5 5894 Lindsay 4 D
Randall 1977 F $ 42,000 48.0 4509 Lindsay 5 D
Randall 1986 M $ 43,000 53.1 4509 Marsh 2 E
Randall 1980 M $ 73,000 46.2 4372 Lindsay 5 A
Reid 1999 M $ 52,000 33.5 5894 Kwatra 5 A
Reiter 1984 M $ 63,000 36.5 4312 Lindsay 3 E
Richards 2000 M $ 88,000 39.5 4509 Yang 4 A
Richardson 1974 M $ 46,000 49.1 4370 Lindsay 5 D
Rodman 1999 M $ 29,000 33.9 5894 Yang 4 C
Romanowsky 1983 M $ 34,000 59.2 5894 Yang 4 D
Rothenberg 1982 M $ 74,000 34.7 4509 Marsh 1 E
Rounthwaite 1981 M $ 44,000 52.9 4365 Yang 2 A
Rudd 1983 F $ 72,000 40.4 4367 Lindsay 5 A
S. Kim 1989 M $ 30,000 41.2 4308 Yang 2 A
Sacksteder 1986 M $ 87,000 32.7 4312 Kwatra 1 D
Sam 2000 M $ 43,000 48.7 4367 Marsh 5 D
Samarawickram 1994 F $ 64,000 58.9 4305 Kwatra 1 E
Sandberg 1977 M $ 83,000 56.6 4302 Yang 3 A
Sax 1997 F $ 88,000 30.5 4365 Kwatra 1 A
Scannell 1998 M $ 69,000 50.1 5894 Yang 3 E
Schäfer 2000 F $ 56,000 57.6 4305 Lindsay 5 A
Schare 1974 M $ 96,000 46.0 4509 Yang 4 D
Schatz 1978 F $ 76,000 46.4 4303 Yang 3 C
Schleger 1986 F $ 29,000 45.0 4306 Kwatra 4 D
Schneider 1999 M $ 72,000 57.8 4305 Lindsay 4 E
Schuldt 1988 F $ 35,000 36.2 4302 Lindsay 2 D
Schulte 1998 M $ 57,000 49.8 4368 Marsh 4 E
Schumann 1996 M $ 73,000 50.4 4308 Lindsay 2 A
Seamans 1984 M $ 43,000 57.5 4303 Kwatra 1 A
Seeley 1999 F $ 86,000 30.2 6002 Lindsay 5 E
Seidenspinner 1986 M $ 36,000 40.6 4308 Yang 3 A
Seidl 1985 F $ 81,000 35.2 4509 Lindsay 2 D
Shapiro 1975 F $ 53,000 32.7 4304 Yang 5 C
Shaughnnessy 1985 M $ 58,000 53.2 4302 Yang 1 D
Shelly 1988 M $ 61,000 52.4 5894 Marsh 2 E
Sherman 1996 F $ 93,000 57.8 4308 Lindsay 4 B
Silverberg 1978 F $ 77,000 55.1 4305 Yang 1 B
Simon 1995 F $ 91,000 53.3 4302 Kwatra 4 C
Simpson 1978 M $ 80,000 48.9 4509 Marsh 5 E
Slichter 1991 M $ 77,000 57.1 4365 Lindsay 3 D
Small 1997 M $ 98,000 33.4 4509 Yang 5 D
Smith 1989 F $ 93,000 46.5 4370 Kwatra 4 E
Smith 1986 M $ 89,000 40.6 4372 Marsh 1 A
Smith 1991 M $ 31,000 32.7 4302 Marsh 2 A
Smith 1991 M $ 69,000 43.8 6004 Yang 1 E
Smith 1993 F $ 63,000 48.9 4370 Kwatra 5 A
Sornsin 2000 M $ 30,000 44.8 4509 Lindsay 3 D
Spencer 1985 M $ 34,000 37.1 4372 Yang 2 C
Stein 1975 M $ 51,000 50.6 5894 Lindsay 3 D
Steiner 1991 M $ 33,000 59.1 4302 Yang 1 E
Stenerson 1983 M $ 79,000 33.6 4302 Yang 2 A
Stewart 1975 M $ 70,000 48.0 4308 Kwatra 1 A
Sun 1992 M $ 54,000 56.1 6004 Lindsay 4 A
Sutton 1999 M $ 83,000 50.4 4308 Lindsay 3 D
Szymanski 1987 F $ 44,000 37.7 4302 Marsh 2 D
Theodore 1978 M $ 67,000 56.2 4308 Lindsay 5 E
Thomas 1991 M $ 57,000 49.7 4370 Kwatra 4 A
Thorson 1996 M $ 64,000 39.4 4302 Lindsay 5 A
Thurman 1999 F $ 34,000 33.9 4302 Yang 3 E
Tiano 1986 M $ 30,000 50.9 4302 Lindsay 5 A
Tibbott 1977 F $ 73,000 48.4 4367 Yang 4 D
Tiedt 1983 F $ 33,000 42.3 4302 Yang 2 C
Tippett 1992 M $ 67,000 49.6 4302 Kwatra 1 D
Tjarnberg 1980 F $ 48,000 56.6 5894 Lindsay 2 E
Tobey 1992 M $ 81,000 46.7 4370 Lindsay 4 D
Tratt 1987 M $ 89,000 57.2 4302 Marsh 1 E
Turner 1977 F $ 49,000 52.4 4305 Lindsay 2 A
Valentine 1989 M $ 74,000 41.6 4305 Kwatra 5 A
Van Dam 1992 F $ 42,000 54.8 5894 Kwatra 3 E
Vargas 1975 M $ 94,000 52.1 4308 Kwatra 4 A
Vasse 1979 F $ 52,000 58.0 4370 Yang 3 D
Verboort 1983 M $ 76,000 31.8 4308 Lindsay 5 C
Vernhes 1985 M $ 53,000 44.6 4308 Yang 1 D
Vong 1987 M $ 32,000 59.5 4372 Yang 3 E
Voss 1989 M $ 29,000 52.9 6004 Kwatra 1 D
Votava 1991 F $ 84,000 51.7 4308 Lindsay 5 C
Waite 1984 F $ 39,000 45.0 4308 Lindsay 1 D
Walton 1984 M $ 84,000 55.9 4509 Marsh 1 E
Washburn 1977 M $ 58,000 36.4 5894 Lindsay 4 D
Waxman 1974 M $ 26,000 32.6 6003 Kwatra 1 E
Weems 2000 M $ 39,000 57.8 6004 Lindsay 5 A
West 1993 M $ 68,000 37.7 4303 Yang 4 A
Wheeler 1984 F $ 45,000 51.3 4302 Lindsay 3 E
White 1987 F $ 53,000 36.7 4370 Yang 2 A
White 1977 F $ 45,000 47.1 4308 Yang 4 D
White 1985 F $ 85,000 32.8 4312 Marsh 5 C
Williams 1990 M $ 90,000 33.2 4308 Yang 3 D
Wilson 1977 M $ 89,000 32.9 4305 Lindsay 1 E
Wilson 1978 F $ 43,000 34.3 4308 Yang 2 B
Wolfe-Hellene 1988 F $ 39,000 40.8 4302 Kwatra 4 B
Wood 1984 M $ 57,000 31.1 4509 Marsh 4 C
Yim 1985 M $ 41,000 31.1 4302 Kwatra 5 E
Yoshida 1997 F $ 99,000 41.4 4302 Yang 2 D
Young 1988 M $ 84,000 50.0 4372 Kwatra 2 D
Young 1986 M $ 39,000 34.1 4509 Yang 4 E
Yukish 2000 M $ 46,000 36.8 4305 Lindsay 2 A
Zambroski 1994 M $ 56,000 31.5 4302 Yang 3 A
Zimprich 1982 F $ 32,000 35.8 4372 Yang 3 E
Zuvela 1992 M $ 73,000 46.7 4308 Kwatra 1 A
 Question 1 Question 2 Question 3 Question 4

YRS Vac DYS Units Units % Net Units Absent Days Meeting
Service Made Rejected Rejected Minutes

23.4 16 16,309 2,370 14.5% 13,939 1 697

23.7 16 19,089 2,815 14.7% 16,274 4 814
19.6 16 20,643 3,063 14.8% 17,580 1 879
27.8 16 15,523 2,244 14.5% 13,279 3 664
29.5 27 17,939 2,471 13.8% 15,468 0 773
19.1 16 13,602 1,937 14.2% 11,665 3 333
16.9 16 15,728 2,277 14.5% 13,451 4 673
8.4 22 16,309 2,290 14.0% 14,019 4 701
16.6 27 12,691 1,631 12.9% 11,060 4 316
22.5 27 11,382 1,422 12.5% 9,960 0 285
20.7 16 16,941 2,471 14.6% 14,470 4 724
34.5 16 21,144 3,144 14.9% 18,000 4 900
25.6 16 10,867 1,499 13.8% 9,368 3 268
12.8 27 15,767 2,123 13.5% 13,644 4 682
31.4 16 19,195 2,832 14.8% 16,363 4 818
15.4 16 17,579 2,573 14.6% 15,006 4 750
13.7 2 12,963 2,047 15.8% 10,916 2 312
9.9 16 18,000 2,640 14.7% 15,360 4 768
15.2 16 18,565 2,731 14.7% 15,834 4 792
31.0 16 11,670 1,628 14.0% 10,042 3 287
11.5 22 15,456 2,153 13.9% 13,303 1 665
20.7 27 19,186 2,670 13.9% 16,516 5 826
17.7 16 10,803 1,489 13.8% 9,314 3 266
8.2 22 14,991 2,079 13.9% 12,912 4 369
10.3 2 20,240 3,212 15.9% 17,028 3 851
12.5 16 14,340 2,055 14.3% 12,285 3 351
22.5 27 15,922 2,148 13.5% 13,774 0 689
32.1 36 13,262 1,642 12.4% 11,620 0 332
22.9 16 19,587 2,894 14.8% 16,693 0 835
31.7 32 20,404 2,785 13.6% 17,619 5 881
22.8 16 12,990 1,839 14.2% 11,151 3 319
11.2 16 18,702 2,753 14.7% 15,949 4 797
24.4 16 19,418 2,867 14.8% 16,551 4 828
24.0 32 18,596 2,496 13.4% 16,100 0 805
19.4 22 17,592 2,495 14.2% 15,097 4 755
26.9 22 14,147 1,944 13.7% 12,203 4 349
19.0 16 11,126 1,541 13.9% 9,585 3 274
20.2 16 12,355 1,737 14.1% 10,618 3 303
10.4 16 18,438 2,711 14.7% 15,727 4 786
25.4 27 11,079 1,373 12.4% 9,706 0 277
32.9 16 14,879 2,141 14.4% 12,738 3 364
19.5 27 11,316 1,411 12.5% 9,905 0 283
32.9 16 15,206 2,193 14.4% 13,013 0 651
20.1 32 20,762 2,842 13.7% 17,920 5 896
11.7 2 17,936 2,843 15.9% 15,093 3 755
17.9 22 13,943 1,911 13.7% 12,032 4 344
31.5 22 15,079 2,093 13.9% 12,986 4 649
13.3 16 19,246 2,840 14.8% 16,406 4 820
31.1 22 20,327 2,933 14.4% 17,394 0 870
30.1 14 14,959 2,186 14.6% 12,773 3 365
28.1 32 17,164 2,267 13.2% 14,897 5 745
20.7 16 19,061 2,810 14.7% 16,251 4 813
14.4 27 16,896 2,304 13.6% 14,592 4 730
23.9 16 10,628 1,461 13.7% 9,167 3 262
21.7 14 20,923 3,140 15.0% 17,783 1 889
34.1 16 17,193 2,511 14.6% 14,682 0 734
25.4 27 13,565 1,771 13.1% 11,794 4 337
11.1 16 14,834 2,134 14.4% 12,700 3 363
30.0 16 11,912 1,666 14.0% 10,246 3 293
28.6 27 11,650 1,464 12.6% 10,186 4 291
25.5 22 20,228 2,917 14.4% 17,311 4 866
25.7 16 16,028 2,325 14.5% 13,703 4 685
16.2 16 20,576 3,053 14.8% 17,523 4 876
22.0 16 17,515 2,563 14.6% 14,952 4 748
15.9 16 20,828 3,093 14.9% 17,735 1 887
19.3 2 13,516 2,136 15.8% 11,380 2 325
18.4 16 20,082 2,974 14.8% 17,108 4 855
9.4 16 19,217 2,835 14.8% 16,382 4 819
29.5 16 19,543 2,887 14.8% 16,656 4 833
25.5 2 21,015 3,336 15.9% 17,679 3 884
9.3 32 18,115 2,419 13.4% 15,696 5 785
24.3 27 12,816 1,651 12.9% 11,165 1 319
28.8 27 13,934 1,830 13.1% 12,104 4 346
11.4 27 10,695 1,312 12.3% 9,383 4 268
12.0 16 19,221 2,836 14.8% 16,385 0 819
22.8 16 20,156 2,985 14.8% 17,171 4 859
33.5 22 20,276 2,925 14.4% 17,351 1 868
 9.5 16 18,934 2,790 14.7% 16,144 0 807
33.3 16 14,550 2,088 14.4% 12,462 0 356
31.8 27 20,588 2,895 14.1% 17,693 1 885
14.8 27 14,432 1,910 13.2% 12,522 0 358
28.5 16 12,969 1,836 14.2% 11,133 3 318
15.7 16 20,201 2,993 14.8% 17,208 4 860
15.9 27 18,318 2,531 13.8% 15,787 4 789
26.6 27 14,279 1,885 13.2% 12,394 4 354
33.9 22 17,973 2,556 14.2% 15,417 4 771
11.4 32 11,745 1,400 11.9% 10,345 4 296
16.3 16 15,429 2,229 14.4% 13,200 3 660
29.4 27 15,573 2,092 13.4% 13,481 4 674
16.8 16 11,475 1,596 13.9% 9,879 3 282
14.9 2 10,797 1,701 15.8% 9,096 1 260
24.8 16 18,990 2,799 14.7% 16,191 4 810
13.2 27 21,036 2,966 14.1% 18,070 5 904
26.5 32 15,521 2,004 12.9% 13,517 0 676
9.8 2 19,625 3,113 15.9% 16,512 3 826
19.4 16 18,984 2,798 14.7% 16,186 4 809
19.9 16 20,322 3,012 14.8% 17,310 4 866
24.7 16 12,608 1,778 14.1% 10,830 3 309
18.2 16 18,058 2,650 14.7% 15,408 4 770
16.2 16 13,609 1,938 14.2% 11,671 3 333
27.7 16 17,755 2,601 14.6% 15,154 4 758
12.0 27 17,307 2,370 13.7% 14,937 4 747
26.2 22 11,672 1,548 13.3% 10,124 4 289
10.3 2 18,807 2,982 15.9% 15,825 3 791
11.4 27 13,602 1,777 13.1% 11,825 0 338
22.3 27 19,155 2,665 13.9% 16,490 0 825
23.2 16 15,667 2,267 14.5% 13,400 4 670
28.0 27 10,478 1,277 12.2% 9,201 4 263
25.0 16 16,758 2,442 14.6% 14,316 4 716
10.9 27 20,339 2,855 14.0% 17,484 5 874
8.6 16 16,646 2,424 14.6% 14,222 4 711
30.0 16 20,679 3,069 14.8% 17,610 1 881
9.1 2 17,633 2,795 15.9% 14,838 3 742
33.8 16 11,958 1,674 14.0% 10,284 3 294
22.4 16 16,408 2,386 14.5% 14,022 4 701
20.5 16 12,125 1,700 14.0% 10,425 3 298
9.5 16 16,551 2,409 14.6% 14,142 4 707
31.1 22 12,025 1,604 13.3% 10,421 4 298
12.4 22 17,852 2,537 14.2% 15,315 4 766
33.1 14 10,815 1,523 14.1% 9,292 3 265
15.0 16 15,397 2,224 14.4% 13,173 1 659
13.7 16 19,443 2,871 14.8% 16,572 4 829
27.4 22 10,781 1,405 13.0% 9,376 4 268
31.1 27 12,183 1,550 12.7% 10,633 4 304
23.8 22 12,784 1,726 13.5% 11,058 4 316
13.4 27 19,904 2,785 14.0% 17,119 5 856
27.7 16 20,451 3,033 14.8% 17,418 4 871
21.7 16 12,488 1,759 14.1% 10,729 3 307
9.1 16 20,097 2,976 14.8% 17,121 4 856
16.9 16 20,578 3,053 14.8% 17,525 1 876
12.9 16 17,648 2,584 14.6% 15,064 0 753
13.1 27 14,994 2,000 13.3% 12,994 4 371
18.6 16 14,486 2,078 14.3% 12,408 3 355
29.8 16 19,810 2,930 14.8% 16,880 4 844
21.2 16 18,610 2,738 14.7% 15,872 4 794
9.3 2 16,879 2,674 15.8% 14,205 3 710
29.1 27 18,814 2,611 13.9% 16,203 0 810
13.1 16 13,562 1,930 14.2% 11,632 3 332
15.5 16 20,415 3,027 14.8% 17,388 4 869
23.6 27 19,190 2,671 13.9% 16,519 5 826
28.3 16 14,136 2,022 14.3% 12,114 3 346
26.0 16 11,002 1,521 13.8% 9,481 3 271
24.5 22 17,966 2,555 14.2% 15,411 4 771
17.0 16 17,110 2,498 14.6% 14,612 4 731
26.3 14 11,138 1,575 14.1% 9,563 3 273
17.0 16 20,906 3,105 14.9% 17,801 4 890
14.7 16 13,057 1,850 14.2% 11,207 3 320
8.2 27 13,140 1,703 13.0% 11,437 4 327
33.1 16 15,968 2,315 14.5% 13,653 0 683
28.7 27 14,895 1,984 13.3% 12,911 4 369
21.9 22 19,926 2,869 14.4% 17,057 4 853
8.5 27 17,334 2,374 13.7% 14,960 4 748
20.1 14 18,665 2,779 14.9% 15,886 4 794
32.5 16 18,212 2,674 14.7% 15,538 1 777
34.1 16 11,206 1,553 13.9% 9,653 3 276
33.6 27 12,459 1,594 12.8% 10,865 4 310
19.3 22 17,614 2,499 14.2% 15,115 4 756
15.1 2 20,266 3,216 15.9% 17,050 1 853
32.0 16 12,625 1,780 14.1% 10,845 3 310
26.9 22 17,365 2,459 14.2% 14,906 4 745
22.3 16 17,658 2,586 14.6% 15,072 0 754
31.2 22 17,838 2,535 14.2% 15,303 4 765
9.6 32 11,877 1,421 12.0% 10,456 4 299
20.2 16 16,362 2,378 14.5% 13,984 4 699
28.3 16 18,611 2,738 14.7% 15,873 4 794
16.6 16 19,565 2,891 14.8% 16,674 4 834
18.2 16 19,552 2,889 14.8% 16,663 1 833
14.7 16 11,905 1,665 14.0% 10,240 3 293
27.3 2 10,624 1,673 15.7% 8,951 2 256
9.6 16 15,440 2,231 14.4% 13,209 3 660
21.7 16 10,781 1,485 13.8% 9,296 3 266
11.5 32 11,963 1,435 12.0% 10,528 4 301
26.7 27 18,760 2,602 13.9% 16,158 5 808
16.4 16 16,066 2,331 14.5% 13,735 4 687
32.5 14 11,566 1,643 14.2% 9,923 3 284
33.8 22 10,548 1,368 13.0% 9,180 3 262
13.6 2 10,883 1,715 15.8% 9,168 2 262
31.3 2 14,992 2,372 15.8% 12,620 2 361
26.7 16 12,032 1,686 14.0% 10,346 3 296
31.0 16 14,294 2,048 14.3% 12,246 3 350
26.0 16 17,615 2,579 14.6% 15,036 4 752
23.4 27 12,624 1,620 12.8% 11,004 0 314
18.3 27 14,659 1,946 13.3% 12,713 0 363
11.8 16 12,546 1,768 14.1% 10,778 3 308
10.5 27 15,647 2,104 13.4% 13,543 4 677
9.7 16 20,952 3,113 14.9% 17,839 4 892
22.6 32 13,621 1,700 12.5% 11,921 4 341
10.1 16 20,324 3,012 14.8% 17,312 1 866
21.9 16 17,313 2,531 14.6% 14,782 4 739
30.6 16 18,782 2,766 14.7% 16,016 4 801
19.1 22 18,062 2,570 14.2% 15,492 4 775
18.3 16 16,696 2,432 14.6% 14,264 4 713
31.6 16 11,003 1,521 13.8% 9,482 3 271
32.2 16 16,780 2,445 14.6% 14,335 4 717
9.3 16 14,210 2,034 14.3% 12,176 3 348
8.9 32 21,020 2,884 13.7% 18,136 0 907
17.9 16 21,017 3,123 14.9% 17,894 4 895
33.4 16 11,026 1,525 13.8% 9,501 3 271
13.8 27 18,303 2,529 13.8% 15,774 4 789
12.6 16 14,518 2,083 14.3% 12,435 3 355
31.3 16 19,671 2,908 14.8% 16,763 4 838
23.8 16 19,632 2,902 14.8% 16,730 4 837
13.8 16 20,685 3,070 14.8% 17,615 4 881
13.6 32 11,395 1,344 11.8% 10,051 4 287
21.3 27 10,737 1,318 12.3% 9,419 1 269
15.8 22 11,292 1,487 13.2% 9,805 4 280
24.1 14 18,790 2,799 14.9% 15,991 4 800
31.2 16 17,075 2,492 14.6% 14,583 0 729
17.7 16 15,675 2,268 14.5% 13,407 1 670
18.0 16 13,113 1,859 14.2% 11,254 1 322
9.8 22 15,345 2,136 13.9% 13,209 4 660
19.1 16 21,198 3,152 14.9% 18,046 4 902
17.0 22 14,168 1,947 13.7% 12,221 4 349
18.4 16 11,750 1,640 14.0% 10,110 3 289
29.9 16 12,742 1,799 14.1% 10,943 3 313
12.9 16 13,910 1,986 14.3% 11,924 3 341
26.2 16 12,313 1,731 14.1% 10,582 1 302
20.4 16 13,062 1,850 14.2% 11,212 0 320
31.1 32 20,357 2,778 13.6% 17,579 1 879
24.6 16 13,191 1,871 14.2% 11,320 1 323
10.6 27 18,667 2,587 13.9% 16,080 5 804
12.6 16 13,498 1,920 14.2% 11,578 3 331
16.8 32 14,783 1,886 12.8% 12,897 5 368
9.5 22 16,016 2,243 14.0% 13,773 4 689
18.4 27 16,435 2,230 13.6% 14,205 4 710
18.8 32 20,184 2,750 13.6% 17,434 1 872
29.1 16 17,215 2,515 14.6% 14,700 4 735
21.3 27 11,716 1,475 12.6% 10,241 4 293
11.8 32 17,738 2,359 13.3% 15,379 5 769
18.2 27 11,774 1,484 12.6% 10,290 4 294
12.0 16 12,369 1,740 14.1% 10,629 3 304
16.2 16 10,530 1,445 13.7% 9,085 3 260
15.9 2 11,218 1,768 15.8% 9,450 2 270
34.0 2 20,991 3,332 15.9% 17,659 1 883
33.3 16 13,379 1,901 14.2% 11,478 3 328
22.0 14 14,929 2,181 14.6% 12,748 3 364
20.3 16 10,503 1,441 13.7% 9,062 3 259
28.8 2 15,291 2,420 15.8% 12,871 0 644
23.7 16 12,524 1,764 14.1% 10,760 1 307
27.4 27 20,551 2,889 14.1% 17,662 1 883
23.7 27 19,589 2,735 14.0% 16,854 5 843
 8.4 22 19,080 2,733 14.3% 16,347 0 817
14.8 27 19,709 2,754 14.0% 16,955 0 848
21.9 16 12,772 1,804 14.1% 10,968 3 313
26.0 27 14,052 1,849 13.2% 12,203 4 349
9.0 16 20,744 3,080 14.8% 17,664 1 883
30.1 22 12,389 1,663 13.4% 10,726 4 306
33.3 27 13,740 1,799 13.1% 11,941 4 341
24.1 16 13,301 1,889 14.2% 11,412 3 326
11.7 16 14,236 2,038 14.3% 12,198 3 349
27.6 16 20,370 3,020 14.8% 17,350 1 868
23.9 27 18,772 2,604 13.9% 16,168 0 808
12.3 2 18,997 3,013 15.9% 15,984 3 799
18.0 16 15,106 2,177 14.4% 12,929 3 646
31.2 27 21,058 2,970 14.1% 18,088 1 904
32.5 16 17,402 2,545 14.6% 14,857 4 743
8.4 16 15,808 2,290 14.5% 13,518 1 676
21.0 16 19,685 2,910 14.8% 16,775 4 839
10.3 16 15,446 2,232 14.5% 13,214 3 661
32.7 27 12,104 1,537 12.7% 10,567 1 302
11.5 32 16,864 2,219 13.2% 14,645 5 732
8.6 16 19,469 2,876 14.8% 16,593 4 830
16.2 32 10,951 1,273 11.6% 9,678 1 277
18.5 2 17,012 2,695 15.8% 14,317 0 716
8.1 16 16,321 2,372 14.5% 13,949 4 697
31.7 16 15,314 2,211 14.4% 13,103 3 655
28.7 16 14,994 2,160 14.4% 12,834 0 367
31.5 22 16,989 2,399 14.1% 14,590 4 730
21.9 16 18,796 2,768 14.7% 16,028 4 801
28.7 16 16,324 2,372 14.5% 13,952 4 698
9.8 16 11,764 1,643 14.0% 10,121 3 289
24.6 16 12,838 1,815 14.1% 11,023 3 315
8.2 27 13,909 1,826 13.1% 12,083 4 345
34.3 32 17,374 2,300 13.2% 15,074 5 754
9.7 2 11,907 1,878 15.8% 10,029 2 287
25.6 16 21,003 3,121 14.9% 17,882 1 894
26.5 16 12,188 1,711 14.0% 10,477 1 299
27.2 16 18,749 2,760 14.7% 15,989 0 799
25.0 16 14,255 2,041 14.3% 12,214 3 349
19.2 27 14,516 1,923 13.2% 12,593 4 360
22.1 16 11,479 1,597 13.9% 9,882 3 282
8.9 16 17,244 2,520 14.6% 14,724 1 736
14.0 22 20,881 3,021 14.5% 17,860 4 893
31.3 16 20,067 2,971 14.8% 17,096 1 855
11.9 16 10,680 1,469 13.8% 9,211 3 263
10.5 16 17,740 2,599 14.7% 15,141 4 757
8.8 32 20,448 2,792 13.7% 17,656 5 883
34.5 14 16,266 2,395 14.7% 13,871 3 694
30.7 27 16,385 2,222 13.6% 14,163 0 708
22.4 16 15,901 2,305 14.5% 13,596 4 680
9.2 16 20,490 3,039 14.8% 17,451 4 873
20.3 32 12,744 1,560 12.2% 11,184 0 320
10.3 16 17,638 2,583 14.6% 15,055 1 753
12.0 22 17,845 2,536 14.2% 15,309 4 765
24.4 27 20,405 2,865 14.0% 17,540 0 877
9.9 22 10,567 1,371 13.0% 9,196 3 263
22.4 16 14,318 2,051 14.3% 12,267 3 350
23.5 27 12,384 1,582 12.8% 10,802 4 309
33.8 14 11,467 1,627 14.2% 9,840 3 281
23.0 16 18,836 2,774 14.7% 16,062 4 803
20.7 16 18,546 2,728 14.7% 15,818 4 791
12.0 16 20,508 3,042 14.8% 17,466 4 873
30.8 27 19,518 2,723 14.0% 16,795 5 840
13.8 16 18,880 2,781 14.7% 16,099 0 805
30.8 22 17,292 2,447 14.2% 14,845 4 742
17.5 16 20,233 2,998 14.8% 17,235 4 862
11.0 2 11,703 1,846 15.8% 9,857 0 282
19.7 14 16,442 2,423 14.7% 14,019 0 701
22.9 16 14,300 2,048 14.3% 12,252 3 350
17.2 16 11,474 1,596 13.9% 9,878 3 282
17.2 27 15,475 2,076 13.4% 13,399 4 670
15.2 22 17,292 2,447 14.2% 14,845 4 742
8.8 14 15,813 2,323 14.7% 13,490 3 675
23.3 16 13,039 1,847 14.2% 11,192 3 320
33.8 16 17,921 2,628 14.7% 15,293 4 765
17.4 16 20,976 3,117 14.9% 17,859 4 893
25.6 16 11,784 1,646 14.0% 10,138 3 290
33.0 16 16,959 2,474 14.6% 14,485 4 724
16.5 22 19,885 2,862 14.4% 17,023 0 851
9.0 16 17,835 2,614 14.7% 15,221 4 761
21.0 16 13,266 1,883 14.2% 11,383 0 325
30.4 16 19,921 2,948 14.8% 16,973 4 849
17.4 32 17,579 2,333 13.3% 15,246 5 762
12.6 16 13,866 1,979 14.3% 11,887 0 340
9.4 16 11,893 1,663 14.0% 10,230 3 292
22.5 2 18,022 2,857 15.9% 15,165 1 758
31.0 16 17,124 2,500 14.6% 14,624 4 731
25.5 2 14,937 2,363 15.8% 12,574 2 359
16.9 16 17,564 2,571 14.6% 14,993 1 750
28.3 2 20,059 3,183 15.9% 16,876 1 844
15.9 22 16,498 2,320 14.1% 14,178 0 709
20.9 16 20,292 3,007 14.8% 17,285 1 864
31.0 14 18,552 2,761 14.9% 15,791 4 790
19.3 27 14,671 1,948 13.3% 12,723 4 364
16.1 27 19,414 2,707 13.9% 16,707 1 835
33.9 16 18,464 2,715 14.7% 15,749 4 787
29.5 27 20,565 2,891 14.1% 17,674 1 884
25.9 27 11,136 1,382 12.4% 9,754 4 279
23.9 16 15,757 2,282 14.5% 13,475 4 674
21.7 16 21,132 3,142 14.9% 17,990 4 900
19.0 27 18,753 2,601 13.9% 16,152 5 808
17.0 16 18,315 2,691 14.7% 15,624 4 781
24.3 27 15,890 2,143 13.5% 13,747 4 687
24.7 14 19,832 2,966 15.0% 16,866 0 843
31.1 16 12,791 1,807 14.1% 10,984 3 314
34.0 27 11,422 1,428 12.5% 9,994 4 286
8.0 14 20,509 3,074 15.0% 17,435 0 872
15.9 32 13,263 1,643 12.4% 11,620 4 332
24.4 16 18,146 2,664 14.7% 15,482 1 774
21.9 22 12,908 1,746 13.5% 11,162 4 319
31.7 22 16,664 2,347 14.1% 14,317 4 716
23.5 16 11,487 1,598 13.9% 9,889 3 283
18.7 32 11,651 1,385 11.9% 10,266 4 293
31.4 14 11,540 1,639 14.2% 9,901 3 283
30.0 16 12,032 1,686 14.0% 10,346 3 296
20.6 16 14,369 2,060 14.3% 12,309 0 352
24.0 32 10,886 1,262 11.6% 9,624 0 275
23.8 16 10,875 1,500 13.8% 9,375 3 268
11.7 16 14,583 2,094 14.4% 12,489 0 357
20.7 22 17,707 2,514 14.2% 15,193 4 760
22.7 27 11,954 1,513 12.7% 10,441 4 298
8.1 22 12,948 1,752 13.5% 11,196 1 320
14.7 32 11,033 1,286 11.7% 9,747 4 278
26.0 22 12,567 1,691 13.5% 10,876 4 311
16.1 16 16,523 2,404 14.5% 14,119 4 706
Question 5 Question 6 Question 7 Question 8 Question 9
 Question 1

Data
Department Sum of Net Units Sum of Net Units2 Count of Last Name What is the Total Net Units by the D
4509 815,014 16.29% 61 Highlight the Dept with the highest
What % are the total net units of th
4302 765,866 15.31% 57 How many employees are in each D
4308 675,507 13.50% 49
5894 541,785 10.83% 39
4370 493,709 9.87% 35
4305 435,400 8.70% 31
6004 337,469 6.74% 24
4372 325,790 6.51% 23
4365 200,099 4.00% 15
4312 146,960 2.94% 11
4303 103,908 2.08% 7
4367 53,594 1.07% 4
4371 17,311 0.35% 1
4368 15,055 0.30% 1
4313 14,222 0.28% 1
4306 13,596 0.27% 1
4366 10,186 0.20% 1
6003 9,994 0.20% 1
4304 9,840 0.20% 1
6002 9,196 0.18% 1
6001 9,168 0.18% 1
Total Result 5,003,669 100.00% 365
 Question 1

e Total Net Units by the Departments?

he Dept with the highest.
e the total net units of the overall Grand Total?
employees are in each Dept?
 Question 2

Data
Supervisor Sum of Net Units Sum of Net Units2 Count of Last Name
Lindsay 1,646,177 32.90% 120
What is the Total Net Units by the Sup
Yang 1,581,107 31.60% 117 Highlight the Supervisor with the highe
Kwatra 1,087,394 21.73% 79 What % are the total net units of the o
Marsh 688,991 13.77% 49 How many employees does each Supe
Total Result 5,003,669 100.00% 365
 Question 2

otal Net Units by the Supervisors?

Supervisor with the highest.
he total net units of the overall Grand Total?
mployees does each Supervisor have?
 Question 3

Data
Education Sum of Net Units Sum of Net Units2 Count of Last Name
2 1,118,290 22.35% 80 What is the Total
5 1,089,250 21.77% 81 Highlight the Edu
What % are the to
4 994,245 19.87% 72 How many emplo
1 911,758 18.22% 66
3 890,126 17.79% 66
Total Result 5,003,669 100.00% 365
Question 3

What is the Total Net Units by the Education?

Highlight the Education with the highest.
What % are the total net units of the overall Grand Total?
How many employees are each Education group?
 Question 4

Data
Gender Sum of Net Units Sum of Net Units2 Count of Last Name
M 3,033,245 60.62% 220 What is the Total Net Units by
F 1,970,424 39.38% 145 Highlight the Gender with the
Total Result 5,003,669 100.00% 365 What % are the total net unit
How many Males and Female
Question 4

t is the Total Net Units by the Gender?

light the Gender with the highest.
t % are the total net units of the overall Grand Total?
many Males and Females employees are there?
 Question 5

Data
Year of Hire Sum of Net Units Sum of Net Units2
1977 340,221 What is the Total Net Units by the Ye
1999 295,614 -13.11% Highlight the Year with the highest.
What % are the total net units of the
1986 260,642 -23.39% What is the % difference between 19
1992 251,133 -26.19%
2000 232,677 -31.61%
1985 222,668 -34.55%
1989 212,848 -37.44% OPTION A
1984 209,253 -38.49%
1975 196,159 -42.34%
1996 194,842 -42.73%
1988 190,848 -43.90%
1990 189,369 -44.34%
1991 186,522 -45.18%
1997 183,683 -46.01%
1987 173,685 -48.95%
1995 172,416 -49.32%
1998 171,769 -49.51%
1982 167,866 -50.66%
1993 157,166 -53.80%
1980 154,952 -54.46%
1983 147,071 -56.77%
1978 140,493 -58.71%
1979 122,005 -64.14%
1981 115,179 -66.15%
1976 113,436 -66.66%
1994 102,219 -69.96%
1974 98,933 -70.92%
Total Result 5,003,669
 e Total Net Units by the Year of Hire?
he Year with the highest.
re the total net units of the overall Grand Total?
e % difference between 1985 and 2000?

OPTION B
 Question 6

Data
Age Sum of Net Units Sum of Net Units3 Sum of Net Units
30-35 667,660 13.34% 667,660
What is the Total Net Units by the
35-40 586,762 11.73% 586,762 Highlight the age category with th
40-45 693,739 13.86% 693,739 What was the average for each
45-50 838,803 16.76% 838,803 What % are the total net unit

50-55 1,000,254 19.99% 1,000,254

55-60 1,216,451 24.31% 1,216,451
Total Result 5,003,669 100.00% 5,003,669
1,839,057
 Question 6

What is the Total Net Units by the employees 50 or older?

Highlight the age category with the highest total (age category should start at 30-35, 35-40, etc...).
What was the average for each category?
What % are the total net units of the overall Grand Total?
 Question 7

Data
YRS Service Sum of Net Units Sum of Net Units3 Sum of Net Units
0-10 543,651 10.87% 543,651
10-20 1,806,607 36.11% 1,806,607
20-30 1,773,537 35.44% 1,773,537
30-40 879,874 17.58% 879,874
Total Result 5,003,669 100.00% 5,003,669
Question 7

What is the Total Net Units by the employees with 20 to 30

years of service?
Highlight the years of service category with the highest total.
What was the average for each category?
What % are the total net units of the overall Grand Total?
 Question 8

Data
Rating Sum of Net Units Sum of Net Units2 Count of Last Name
A 1,442,283 28.82% 106
D 1,441,361 28.81% 105 What is the Total Net Units by t
Highlight the Rating with the hi
E 1,357,220 27.12% 97 What % are the total net units o
C 524,446 10.48% 39 How many employees are in ea
B 238,359 4.76% 18
Total Result 5,003,669 100.00% 365
 Question 8

s the Total Net Units by the Ratings?

ht the Rating with the highest.
% are the total net units of the overall Grand Total?
many employees are in each Rating category?
 Question 9

Data
What is the Total Net Units by the e
Salary Sum of Net Units Sum of Net Units3 Sum of Net Units Highlight the Salary category with th
30000-34999 447,797 8.95% 447,797 What was the average for each cate
40000-44999 402,317 8.04% 402,317 What % are the total net units of th
35000-39999 380,408 7.60% 380,408
55000-59999 377,583 7.55% 377,583
80000-84999 374,840 7.49% 374,840
50000-54999 351,670 7.03% 351,670
70000-74999 349,186 6.98% 349,186
75000-79999 334,162 6.68% 334,162
90000-94999 319,338 6.38% 319,338
45000-49999 301,507 6.03% 301,507
65000-69999 292,578 5.85% 292,578
95000-100000 278,730 5.57% 278,730
25000-29999 276,940 5.53% 276,940
85000-89999 266,062 5.32% 266,062
60000-64999 250,551 5.01% 250,551
Total Result 5,003,669 100.00% 5,003,669
 Question 9

at is the Total Net Units by the employees with Salary starting in the 25000 to 30000 and categories with 5000 increments
light the Salary category with the highest total.
at was the average for each category?
at % are the total net units of the overall Grand Total?
0 increments
Operations Sales Data

Country Salesperson Order Date OrderID Sales Cost Quantity Days to Close
UK Buchanan 7/16/2003 10248 $440.00 $96.80 12 4
UK Suyama 7/10/2003 10249 $1,863.40 $409.95 10 8
USA Peacock 7/12/2003 10250 $1,552.60 $341.57 5 6
USA Leverling 7/15/2003 10251 $654.06 $143.89 40 3
USA Peacock 7/11/2003 10252 $3,597.90 $791.54 9 2
USA Leverling 7/16/2003 10253 $1,444.80 $317.86 35 2
UK Buchanan 7/23/2003 10254 $556.62 $122.46 10 5
UK Dodsworth 7/15/2003 10255 $2,490.50 $547.91 15 4
USA Leverling 7/17/2003 10256 $517.80 $113.92 20 6
USA Peacock 7/22/2003 10257 $1,119.90 $246.38 6 7
USA Davolio 7/23/2003 10258 $1,614.88 $355.27 15 8
USA Peacock 7/25/2003 10259 $100.80 $22.18 25 4
USA Peacock 7/29/2003 10260 $1,504.65 $331.02 40 5
USA Peacock 7/30/2003 10261 $448.00 $98.56 40 5
USA Callahan 7/25/2003 10262 $584.00 $87.60 40 5
UK Dodsworth 7/31/2003 10263 $1,873.80 $281.07 42 6
UK Suyama 8/23/2003 10264 $695.62 $104.34 20 4
USA Fuller 8/12/2003 10265 $1,176.00 $176.40 21 5
USA Leverling 7/31/2003 10266 $346.56 $51.98 21 3
USA Peacock 8/6/2003 10267 $3,536.60 $530.49 15 2
USA Callahan 8/2/2003 10268 $1,101.20 $165.18 25 3
UK Buchanan 8/9/2003 10269 $642.20 $96.33 30 4
USA Davolio 8/2/2003 10270 $1,376.00 $206.40 35 7
UK Suyama 8/30/2003 10271 $48.00 $10.56 20 6
UK Suyama 8/6/2003 10272 $1,456.00 $320.32 15 5
USA Leverling 8/12/2003 10273 $2,037.28 $448.20 12 4
UK Suyama 8/16/2003 10274 $538.60 $118.49 25 1
USA Davolio 8/9/2003 10275 $291.84 $64.20 6 1
USA Callahan 8/14/2003 10276 $420.00 $92.40 15 1
USA Fuller 8/13/2003 10277 $1,200.80 $264.18 50 1
USA Callahan 8/16/2003 10278 $1,488.80 $327.54 6 1
USA Callahan 8/16/2003 10279 $351.00 $77.22 65 3
USA Fuller 9/12/2003 10280 $613.20 $134.90 10 4
USA Peacock 8/21/2003 10281 $86.50 $19.03 1 6
USA Peacock 8/21/2003 10282 $155.40 $34.19 21 6
USA Leverling 8/23/2003 10283 $1,414.80 $311.26 50 12
USA Peacock 8/27/2003 10284 $1,170.37 $257.48 15 15
USA Davolio 8/26/2003 10285 $1,743.36 $383.54 16 18
USA Callahan 8/30/2003 10286 $3,016.00 $663.52 20 4
USA Callahan 8/28/2003 10287 $819.00 $180.18 20 7
USA Peacock 9/3/2003 10288 $80.10 $17.62 12 9
UK King 8/28/2003 10289 $479.40 $105.47 15 9
USA Callahan 9/3/2003 10290 $2,169.00 $477.18 2 8
UK Suyama 9/4/2003 10291 $497.52 $109.45 60 9
USA Davolio 9/2/2003 10292 $1,296.00 $285.12 60 10
USA Davolio 9/11/2003 10293 $848.70 $186.71 36 10
USA Peacock 9/5/2003 10294 $1,887.60 $415.27 28 4
USA Fuller 9/10/2003 10295 $121.60 $26.75 35 8
UK Suyama 9/11/2003 10296 $1,050.60 $231.13 25 6
UK Buchanan 9/10/2003 10297 $1,420.00 $312.40 30 3
UK Suyama 9/11/2003 10298 $2,645.00 $581.90 20 2
USA Peacock 9/13/2003 10299 $349.50 $52.43 12 2
USA Fuller 9/18/2003 10300 $608.00 $91.20 15 5
USA Callahan 9/17/2003 10301 $755.00 $113.25 50 4
USA Peacock 10/9/2003 10302 $2,708.80 $406.32 70 6
UK King 9/18/2003 10303 $1,117.80 $167.67 10 7
USA Davolio 9/17/2003 10304 $954.40 $143.16 4 8
USA Callahan 10/9/2003 10305 $3,741.30 $561.20 20 4
USA Davolio 9/23/2003 10306 $498.50 $74.78 60 5
USA Fuller 9/25/2003 10307 $424.00 $63.60 30 5
UK King 9/24/2003 10308 $88.80 $13.32 25 5
USA Leverling 10/23/2003 10309 $1,762.00 $387.64 24 6
USA Callahan 9/27/2003 10310 $336.00 $73.92 40 4
USA Davolio 9/26/2003 10311 $268.80 $59.14 24 5
USA Fuller 10/3/2003 10312 $1,614.80 $355.26 6 3
USA Fuller 10/4/2003 10313 $182.40 $40.13 20 2
USA Davolio 10/4/2003 10314 $2,094.30 $460.75 60 3
USA Peacock 10/3/2003 10315 $516.80 $113.70 24 4
USA Davolio 10/8/2003 10316 $2,835.00 $623.70 15 7
UK Suyama 10/10/2003 10317 $288.00 $63.36 33 6
USA Callahan 10/4/2003 10318 $240.40 $52.89 7 5
UK King 10/11/2003 10319 $1,191.20 $262.06 20 4
UK Buchanan 10/18/2003 10320 $516.00 $113.52 12 1
USA Leverling 10/11/2003 10321 $144.00 $31.68 6 1
UK King 10/23/2003 10322 $112.00 $24.64 15 1
USA Peacock 10/14/2003 10323 $164.40 $36.17 10 1
UK Dodsworth 10/10/2003 10324 $5,275.71 $1,160.66 20 1
USA Davolio 10/14/2003 10325 $1,497.00 $329.34 12 3
USA Peacock 10/14/2003 10326 $982.00 $216.04 16 4
USA Fuller 10/14/2003 10327 $1,810.00 $398.20 15 6
USA Peacock 10/17/2003 10328 $1,168.00 $256.96 8 6
USA Peacock 10/23/2003 10329 $4,578.43 $1,007.25 25 12
USA Leverling 10/28/2003 10330 $1,649.00 $362.78 15 15
UK Dodsworth 10/21/2003 10331 $88.50 $19.47 12 18
USA Leverling 10/21/2003 10332 $1,786.88 $393.11 30 4
UK Buchanan 10/25/2003 10333 $877.20 $192.98 20 7
USA Callahan 10/28/2003 10334 $144.80 $31.86 4 9
UK King 10/24/2003 10335 $2,036.16 $447.96 1 9
UK King 10/25/2003 10336 $285.12 $62.73 6 8
USA Peacock 10/29/2003 10337 $2,467.00 $542.74 6 9
USA Peacock 10/29/2003 10338 $934.50 $205.59 2 10
USA Fuller 11/4/2003 10339 $3,354.00 $737.88 18 10
USA Davolio 11/8/2003 10340 $2,436.18 $365.43 3 4
UK King 11/5/2003 10341 $352.60 $52.89 20 8
USA Peacock 11/4/2003 10342 $1,840.64 $276.10 35 6
USA Peacock 11/6/2003 10343 $1,584.00 $237.60 21 3
USA Peacock 11/5/2003 10344 $2,296.00 $344.40 15 2
USA Fuller 11/11/2003 10345 $2,924.80 $438.72 20 2
USA Leverling 11/8/2003 10346 $1,618.88 $242.83 5 5
USA Peacock 11/8/2003 10347 $814.42 $122.16 40 4
USA Peacock 11/15/2003 10348 $363.60 $54.54 45 6
UK King 11/15/2003 10349 $141.60 $31.15 36 7
UK Suyama 12/3/2003 10350 $642.06 $141.25 40 8
USA Davolio 11/20/2003 10351 $5,398.72 $1,187.72 100 4
USA Leverling 11/18/2003 10352 $136.30 $29.99 20 5
UK King 11/25/2003 10353 $8,593.28 $1,890.52 15 5
USA Callahan 11/20/2003 10354 $568.80 $125.14 40 5
UK Suyama 11/20/2003 10355 $480.00 $105.60 10 6
UK Suyama 11/27/2003 10356 $1,106.40 $243.41 3 4
USA Davolio 12/2/2003 10357 $1,167.68 $256.89 9 5
UK Buchanan 11/27/2003 10358 $429.40 $94.47 30 3
UK Buchanan 11/26/2003 10359 $3,471.68 $763.77 15 2
USA Peacock 12/2/2003 10360 $7,390.20 $1,625.84 20 3
USA Davolio 12/3/2003 10361 $2,046.24 $450.17 15 4
USA Leverling 11/28/2003 10362 $1,549.60 $340.91 10 7
USA Peacock 12/4/2003 10363 $447.20 $98.38 20 6
USA Davolio 12/4/2003 10364 $950.00 $209.00 2 5
USA Leverling 12/2/2003 10365 $403.20 $88.70 24 4
USA Callahan 12/30/2003 10366 $136.00 $29.92 20 1
UK King 12/2/2003 10367 $834.20 $183.52 5 1
USA Fuller 12/2/2003 10368 $1,689.78 $371.75 10 1
USA Callahan 12/9/2003 10369 $2,390.40 $525.89 6 1
UK Suyama 12/27/2003 10370 $1,117.60 $245.87 12 1
USA Davolio 12/24/2003 10371 $72.96 $16.05 15 3
UK Buchanan 12/9/2003 10372 $9,210.90 $2,026.40 6 4
USA Peacock 12/11/2003 10373 $1,366.40 $204.96 21 6
USA Davolio 12/9/2003 10374 $459.00 $68.85 15 6
USA Leverling 12/9/2003 10375 $338.00 $50.70 18 12
USA Davolio 12/13/2003 10376 $399.00 $59.85 4 15
USA Davolio 12/13/2003 10377 $863.60 $129.54 12 18
UK Buchanan 12/19/2003 10378 $103.20 $15.48 15 4
USA Fuller 12/13/2003 10379 $863.28 $129.49 30 7
USA Callahan 1/16/2004 10380 $1,313.82 $289.04 60 9
USA Leverling 12/13/2003 10381 $112.00 $24.64 20 9
USA Peacock 12/16/2003 10382 $2,900.00 $638.00 40 8
USA Callahan 12/18/2003 10383 $899.00 $197.78 15 9
USA Leverling 12/20/2003 10384 $2,222.40 $488.93 30 10
USA Davolio 12/23/2003 10385 $691.20 $152.06 40 10
UK Dodsworth 12/25/2003 10386 $166.00 $36.52 15 4
USA Davolio 12/20/2003 10387 $1,058.40 $232.85 20 8
USA Fuller 12/20/2003 10388 $1,228.80 $270.34 20 6
USA Peacock 12/24/2003 10389 $1,832.80 $403.22 30 3
UK Suyama 12/26/2003 10390 $2,090.88 $459.99 10 2
USA Leverling 12/31/2003 10391 $86.40 $19.01 20 2
USA Fuller 1/1/2004 10392 $1,440.00 $316.80 12 5
USA Davolio 1/3/2004 10393 $2,556.95 $562.53 40 4
USA Davolio 1/3/2004 10394 $442.00 $97.24 28 6
UK Suyama 1/3/2004 10395 $2,122.92 $467.04 30 7
USA Davolio 1/6/2004 10396 $1,903.80 $418.84 40 8
UK Buchanan 1/2/2004 10397 $716.72 $157.68 15 4
USA Fuller 1/9/2004 10398 $2,505.60 $551.23 30 5
USA Callahan 1/8/2004 10399 $1,765.60 $388.43 2 5
USA Davolio 1/16/2004 10400 $3,063.00 $673.86 10 5
USA Davolio 1/10/2004 10401 $3,868.60 $851.09 25 6
USA Callahan 1/10/2004 10402 $2,713.50 $596.97 30 4
USA Peacock 1/9/2004 10403 $855.01 $188.10 25 5
USA Fuller 1/8/2004 10404 $1,591.25 $350.08 10 3
USA Davolio 1/22/2004 10405 $400.00 $88.00 10 2
UK King 1/13/2004 10406 $1,830.78 $402.77 5 3
USA Fuller 1/30/2004 10407 $1,194.00 $262.68 10 4
USA Callahan 1/14/2004 10408 $1,622.40 $356.93 3 7
USA Leverling 1/14/2004 10409 $319.20 $70.22 5 6
USA Leverling 1/15/2004 10410 $802.00 $176.44 1 5
UK Dodsworth 1/21/2004 10411 $966.80 $212.70 20 4
USA Callahan 1/15/2004 10412 $334.80 $73.66 20 1
USA Leverling 1/16/2004 10413 $2,123.20 $467.10 3 1
USA Fuller 1/17/2004 10414 $224.83 $49.46 30 1
USA Leverling 1/24/2004 10415 $102.40 $22.53 2 1
USA Callahan 1/27/2004 10416 $720.00 $158.40 10 1
USA Peacock 1/28/2004 10417 $11,188.40 $2,461.45 5 3
USA Peacock 1/24/2004 10418 $1,814.80 $399.26 7 4
USA Peacock 1/30/2004 10419 $2,097.60 $314.64 6 6
USA Leverling 1/27/2004 10420 $1,707.84 $256.18 20 6
USA Callahan 1/27/2004 10421 $1,194.27 $179.14 24 12
USA Fuller 1/31/2004 10422 $49.80 $7.47 10 15
UK Suyama 2/24/2004 10423 $1,020.00 $153.00 4 18
UK King 1/27/2004 10424 $9,194.56 $1,379.18 12 4
UK Suyama 2/14/2004 10425 $360.00 $54.00 25 7
USA Peacock 2/6/2004 10426 $338.20 $50.73 40 9
USA Peacock 3/3/2004 10427 $651.00 $97.65 30 9
UK King 2/4/2004 10428 $192.00 $42.24 30 8
USA Leverling 2/7/2004 10429 $1,441.37 $317.10 14 9
USA Peacock 2/3/2004 10430 $4,899.20 $1,077.82 70 10
USA Peacock 2/7/2004 10431 $1,892.25 $416.30 10 10
USA Leverling 2/7/2004 10432 $485.00 $106.70 20 4
USA Leverling 3/4/2004 10433 $851.20 $187.26 6 8
USA Leverling 2/13/2004 10434 $321.12 $70.65 20 6
USA Callahan 2/7/2004 10435 $631.60 $138.95 14 3
USA Leverling 2/11/2004 10436 $1,994.52 $438.79 30 2
USA Callahan 2/12/2004 10437 $393.00 $86.46 8 2
USA Leverling 2/14/2004 10438 $454.00 $99.88 30 5
UK Suyama 2/10/2004 10439 $1,078.00 $237.16 10 4
USA Peacock 2/28/2004 10440 $4,924.13 $1,083.31 20 6
USA Leverling 3/14/2004 10441 $1,755.00 $386.10 4 7
USA Leverling 2/18/2004 10442 $1,792.00 $394.24 4 8
USA Callahan 2/14/2004 10443 $517.44 $113.84 5 4
USA Leverling 2/21/2004 10444 $1,031.70 $226.97 40 5
USA Leverling 2/20/2004 10445 $174.90 $38.48 70 5
UK Suyama 2/19/2004 10446 $246.24 $54.17 30 5
USA Peacock 3/7/2004 10447 $914.40 $201.17 21 6
USA Peacock 2/24/2004 10448 $443.40 $97.55 80 4
USA Leverling 2/27/2004 10449 $1,838.20 $404.40 4 5
USA Callahan 3/11/2004 10450 $425.12 $93.53 6 3
USA Peacock 3/12/2004 10451 $3,849.66 $577.45 40 2
USA Callahan 2/26/2004 10452 $2,018.50 $302.78 9 3
USA Davolio 2/26/2004 10453 $407.70 $61.16 12 4
USA Peacock 2/25/2004 10454 $331.20 $49.68 16 7
USA Callahan 3/3/2004 10455 $2,684.00 $402.60 50 6
USA Callahan 2/28/2004 10456 $557.60 $83.64 24 5
USA Fuller 3/3/2004 10457 $1,584.00 $237.60 35 4
UK King 3/4/2004 10458 $3,891.00 $583.65 30 1
USA Peacock 2/28/2004 10459 $1,659.20 $248.88 25 1
USA Callahan 3/3/2004 10460 $176.10 $26.42 50 1
USA Davolio 3/5/2004 10461 $1,538.70 $338.51 10 1
USA Fuller 3/18/2004 10462 $156.00 $34.32 9 1
UK Buchanan 3/6/2004 10463 $713.30 $156.93 40 3
USA Peacock 3/14/2004 10464 $1,609.28 $354.04 10 4
USA Davolio 3/14/2004 10465 $2,518.00 $553.96 8 6
USA Peacock 3/13/2004 10466 $216.00 $47.52 20 6
USA Callahan 3/11/2004 10467 $235.20 $51.74 12 12
USA Leverling 3/12/2004 10468 $717.60 $157.87 50 15
USA Davolio 3/14/2004 10469 $956.67 $210.47 25 18
USA Peacock 3/14/2004 10470 $1,820.80 $400.58 15 4
USA Fuller 3/18/2004 10471 $1,328.00 $292.16 16 7
USA Callahan 3/19/2004 10472 $1,036.80 $228.10 10 9
USA Davolio 3/21/2004 10473 $230.40 $50.69 40 9
UK Buchanan 3/21/2004 10474 $1,249.10 $274.80 10 8
UK Dodsworth 4/4/2004 10475 $1,505.18 $331.14 10 9
USA Callahan 3/24/2004 10476 $180.48 $39.71 40 10
UK Buchanan 3/25/2004 10477 $558.00 $122.76 10 10
USA Fuller 3/26/2004 10478 $471.20 $103.66 8 4
USA Leverling 3/21/2004 10479 $10,495.60 $1,574.34 6 8
UK Suyama 3/24/2004 10480 $756.00 $113.40 7 6
USA Callahan 3/25/2004 10481 $1,472.00 $220.80 48 3
USA Davolio 4/10/2004 10482 $147.00 $22.05 25 2
UK King 4/25/2004 10483 $668.80 $100.32 18 2
USA Leverling 4/1/2004 10484 $386.20 $57.93 28 5
USA Peacock 3/31/2004 10485 $1,584.00 $237.60 40 4
USA Davolio 4/2/2004 10486 $1,272.00 $190.80 20 6
USA Fuller 3/28/2004 10487 $889.70 $133.46 25 7
USA Callahan 4/2/2004 10488 $1,512.00 $226.80 24 8
UK Suyama 4/9/2004 10489 $439.20 $65.88 15 4
UK King 4/3/2004 10490 $3,163.20 $474.48 20 5
USA Callahan 4/8/2004 10491 $259.50 $38.93 10 5
USA Leverling 4/11/2004 10492 $851.20 $187.26 28 5
USA Peacock 4/10/2004 10493 $608.40 $133.85 70 6
USA Peacock 4/9/2004 10494 $912.00 $200.64 12 4
USA Leverling 4/11/2004 10495 $278.00 $61.16 20 5
UK King 4/7/2004 10496 $190.00 $41.80 40 3
UK King 4/7/2004 10497 $1,380.60 $303.73 8 2
USA Callahan 4/11/2004 10498 $575.00 $126.50 9 3
USA Peacock 4/16/2004 10499 $1,412.00 $310.64 56 4
UK Suyama 4/17/2004 10500 $523.26 $115.12 40 7
UK Dodsworth 4/16/2004 10501 $149.00 $32.78 24 6
USA Fuller 4/29/2004 10502 $816.30 $179.59 40 5
UK Suyama 4/16/2004 10503 $2,048.50 $450.67 50 4
USA Peacock 4/18/2004 10504 $1,388.50 $305.47 15 1
USA Leverling 4/21/2004 10505 $147.90 $32.54 4 1
UK Dodsworth 5/2/2004 10506 $415.80 $91.48 35 1
UK King 4/22/2004 10507 $749.06 $164.79 70 1
USA Davolio 5/13/2004 10508 $240.00 $52.80 9 1
USA Peacock 4/29/2004 10509 $136.80 $30.10 70 3
UK Suyama 4/28/2004 10510 $4,707.54 $1,035.66 80 4
USA Peacock 4/21/2004 10511 $2,550.00 $561.00 36 6
UK King 4/24/2004 10512 $525.30 $78.80 20 6
UK King 4/28/2004 10513 $1,942.00 $291.30 10 12
USA Leverling 5/16/2004 10514 $8,623.45 $1,293.52 6 15
USA Fuller 5/23/2004 10515 $9,921.30 $1,488.20 4 18
USA Fuller 5/1/2004 10516 $2,381.05 $357.16 50 4
USA Leverling 4/29/2004 10517 $352.00 $52.80 25 7
USA Peacock 5/5/2004 10518 $4,150.05 $622.51 15 9
UK Suyama 5/1/2004 10519 $2,314.20 $347.13 24 9
UK King 5/1/2004 10520 $200.00 $30.00 18 8
USA Callahan 5/2/2004 10521 $225.50 $33.83 15 9
USA Peacock 5/6/2004 10522 $2,318.24 $347.74 13 10
UK King 5/30/2004 10523 $2,444.31 $537.75 20 10
USA Davolio 5/7/2004 10524 $3,192.65 $702.38 77 4
USA Davolio 5/23/2004 10525 $818.40 $180.05 10 8
USA Peacock 5/15/2004 10526 $1,151.40 $253.31 20 6
UK King 5/7/2004 10527 $1,503.00 $330.66 10 3
UK Suyama 5/9/2004 10528 $392.20 $86.28 50 2
UK Buchanan 5/9/2004 10529 $946.00 $208.12 12 2
USA Leverling 5/12/2004 10530 $4,180.00 $919.60 12 5
UK King 5/19/2004 10531 $110.00 $24.20 4 4
UK King 5/12/2004 10532 $796.35 $175.20 25 6
USA Callahan 5/22/2004 10533 $2,222.20 $488.88 25 7
USA Callahan 5/14/2004 10534 $465.70 $102.45 30 8
USA Peacock 5/21/2004 10535 $1,940.85 $426.99 12 4
USA Leverling 6/6/2004 10536 $1,645.00 $361.90 20 5
USA Davolio 5/19/2004 10537 $1,823.80 $401.24 16 5
UK Dodsworth 5/16/2004 10538 $139.80 $30.76 30 5
UK Suyama 5/23/2004 10539 $355.50 $78.21 8 6
USA Leverling 6/13/2004 10540 $10,191.70 $2,242.17 20 4
USA Fuller 5/29/2004 10541 $1,946.52 $428.23 10 5
USA Davolio 5/26/2004 10542 $469.11 $103.20 10 3
USA Callahan 5/23/2004 10543 $1,504.50 $330.99 80 2
USA Peacock 5/30/2004 10544 $417.20 $62.58 56 3
USA Callahan 6/26/2004 10545 $210.00 $31.50 70 4
USA Davolio 5/27/2004 10546 $2,812.00 $421.80 28 7
USA Leverling 6/2/2004 10547 $1,792.80 $268.92 30 6
USA Leverling 6/2/2004 10548 $240.10 $36.02 10 5
UK Buchanan 5/30/2004 10549 $3,554.27 $533.14 35 4
UK King 6/6/2004 10550 $683.30 $102.50 35 1
USA Peacock 6/6/2004 10551 $1,677.30 $251.60 54 1
USA Fuller 6/5/2004 10552 $880.50 $132.08 55 1
USA Fuller 6/3/2004 10553 $1,546.30 $231.95 20 1
USA Peacock 6/5/2004 10554 $1,728.52 $259.28 50 1
UK Suyama 6/4/2004 10555 $2,944.40 $647.77 24 3
USA Fuller 6/13/2004 10556 $835.20 $183.74 20 4
UK Dodsworth 6/6/2004 10557 $1,152.50 $253.55 12 6
USA Davolio 6/10/2004 10558 $2,142.90 $471.44 12 6
UK Suyama 6/13/2004 10559 $520.41 $114.49 30 12
USA Callahan 6/9/2004 10560 $1,072.42 $235.93 5 15
USA Fuller 6/9/2004 10561 $2,844.50 $625.79 24 18
USA Davolio 6/12/2004 10562 $488.70 $107.51 5 4
USA Fuller 6/24/2004 10563 $965.00 $212.30 5 7
USA Peacock 6/16/2004 10564 $1,234.05 $271.49 36 9
USA Callahan 6/18/2004 10565 $639.90 $140.78 15 9
UK Dodsworth 6/18/2004 10566 $1,761.00 $387.42 18 8
USA Davolio 6/17/2004 10567 $2,519.00 $554.18 7 9
USA Leverling 7/9/2004 10568 $155.00 $34.10 35 10
UK Buchanan 7/11/2004 10569 $890.00 $133.50 5 10
USA Leverling 6/19/2004 10570 $2,465.25 $369.79 25 4
USA Callahan 7/4/2004 10571 $550.59 $82.59 13 8
USA Leverling 6/25/2004 10572 $1,501.08 $225.16 20 6
UK King 6/20/2004 10573 $2,082.00 $312.30 18 3
USA Peacock 6/30/2004 10574 $764.30 $114.65 15 2
UK Buchanan 6/30/2004 10575 $2,147.40 $322.11 30 2
USA Leverling 6/30/2004 10576 $838.45 $125.77 20 5
UK Dodsworth 6/30/2004 10577 $569.00 $85.35 6 4
USA Peacock 7/25/2004 10578 $477.00 $71.55 40 6
USA Davolio 7/4/2004 10579 $317.75 $47.66 70 7
USA Peacock 7/1/2004 10580 $1,013.74 $152.06 42 8
USA Leverling 7/2/2004 10581 $310.00 $46.50 12 4
USA Leverling 7/14/2004 10582 $330.00 $72.60 50 5
USA Fuller 7/4/2004 10583 $2,237.50 $492.25 80 5
USA Peacock 7/4/2004 10584 $593.75 $130.63 30 5
UK King 7/10/2004 10585 $142.50 $31.35 15 6
UK Dodsworth 7/9/2004 10586 $23.80 $5.24 10 4
USA Davolio 7/9/2004 10587 $807.38 $177.62 15 5
USA Fuller 7/10/2004 10588 $3,120.00 $686.40 42 3
USA Callahan 7/14/2004 10589 $72.00 $15.84 20 2
USA Peacock 7/14/2004 10590 $1,101.00 $242.22 20 3
USA Davolio 7/16/2004 10591 $812.50 $178.75 6 4
USA Leverling 7/16/2004 10592 $516.46 $113.62 20 7
UK King 8/13/2004 10593 $1,994.40 $438.77 16 6
USA Leverling 7/16/2004 10594 $565.50 $124.41 8 5
USA Fuller 7/14/2004 10595 $4,725.00 $1,039.50 6 4
USA Callahan 8/12/2004 10596 $1,180.88 $259.79 30 1
UK King 7/18/2004 10597 $718.08 $157.98 18 1
USA Davolio 7/18/2004 10598 $2,388.50 $358.28 20 1
UK Suyama 7/21/2004 10599 $493.00 $73.95 14 1
USA Peacock 7/21/2004 10600 $479.80 $71.97 50 1
UK King 7/22/2004 10601 $2,285.00 $342.75 9 3
USA Callahan 7/22/2004 10602 $48.75 $7.31 14 4
USA Callahan 8/8/2004 10603 $1,483.00 $222.45 60 6
USA Davolio 7/29/2004 10604 $230.85 $34.63 32 6
USA Davolio 7/29/2004 10605 $4,109.69 $616.45 20 12
USA Peacock 7/31/2004 10606 $1,130.40 $169.56 15 15
UK Buchanan 7/25/2004 10607 $6,475.40 $971.31 20 18
USA Peacock 8/1/2004 10608 $1,064.00 $159.60 15 4
UK King 7/30/2004 10609 $424.00 $63.60 28 7
USA Callahan 8/6/2004 10610 $299.25 $44.89 10 9
UK Suyama 8/1/2004 10611 $808.00 $121.20 8 9
USA Davolio 8/1/2004 10612 $6,375.00 $956.25 20 8
USA Peacock 8/1/2004 10613 $353.20 $77.70 10 9
USA Callahan 8/1/2004 10614 $464.00 $102.08 15 10
USA Fuller 8/6/2004 10615 $120.00 $26.40 15 10
USA Davolio 8/5/2004 10616 $4,806.99 $1,057.54 15 4
USA Peacock 8/4/2004 10617 $1,402.50 $308.55 12 8
USA Davolio 8/8/2004 10618 $2,697.50 $593.45 6 6
USA Leverling 8/7/2004 10619 $1,260.00 $277.20 20 3
USA Fuller 8/14/2004 10620 $57.50 $12.65 40 2
USA Peacock 8/11/2004 10621 $758.50 $166.87 15 2
USA Peacock 8/11/2004 10622 $560.00 $123.20 20 5
USA Callahan 8/12/2004 10623 $1,336.95 $294.13 30 4
USA Peacock 8/19/2004 10624 $1,393.24 $306.51 15 6
USA Leverling 8/14/2004 10625 $479.75 $105.55 16 7
USA Davolio 8/20/2004 10626 $1,503.60 $330.79 40 8
USA Callahan 8/21/2004 10627 $1,185.75 $177.86 45 4
USA Peacock 8/20/2004 10628 $450.00 $67.50 60 5
USA Peacock 8/20/2004 10629 $2,775.05 $416.26 24 5
USA Davolio 8/19/2004 10630 $903.60 $135.54 18 5
USA Callahan 8/15/2004 10631 $55.80 $8.37 50 6
USA Callahan 8/19/2004 10632 $589.00 $88.35 7 4
UK King 8/18/2004 10633 $5,510.59 $826.59 70 5
USA Peacock 8/21/2004 10634 $4,985.50 $747.83 25 3
USA Callahan 8/21/2004 10635 $1,326.22 $198.93 42 2
USA Peacock 8/26/2004 10636 $629.50 $94.43 32 3
UK Suyama 8/26/2004 10637 $2,761.94 $414.29 10 4
USA Leverling 9/1/2004 10638 $2,720.05 $408.01 10 7
UK King 8/27/2004 10639 $500.00 $75.00 8 6
USA Peacock 8/28/2004 10640 $708.75 $106.31 28 5
USA Peacock 8/26/2004 10641 $2,054.00 $308.10 70 4
UK King 9/5/2004 10642 $696.00 $153.12 60 1
UK Suyama 9/2/2004 10643 $814.50 $179.19 40 1
USA Leverling 9/1/2004 10644 $1,371.80 $301.80 21 1
USA Peacock 9/2/2004 10645 $1,535.00 $337.70 18 1
UK Dodsworth 9/3/2004 10646 $1,446.00 $318.12 10 1
USA Peacock 9/3/2004 10647 $636.00 $139.92 120 3
UK Buchanan 9/9/2004 10648 $372.37 $81.92 30 4
UK Buchanan 8/29/2004 10649 $1,434.00 $315.48 35 6
UK Buchanan 9/3/2004 10650 $1,779.20 $391.42 60 6
USA Callahan 9/11/2004 10651 $397.80 $87.52 30 12
USA Peacock 9/8/2004 10652 $318.84 $70.14 14 15
USA Davolio 9/19/2004 10653 $1,083.15 $238.29 35 18
UK Buchanan 9/11/2004 10654 $601.83 $132.40 30 4
USA Davolio 9/11/2004 10655 $154.40 $33.97 21 7
UK Suyama 9/10/2004 10656 $604.21 $90.63 18 9
USA Fuller 9/15/2004 10657 $4,371.60 $655.74 20 9
USA Peacock 9/8/2004 10658 $4,464.60 $669.69 70 8
UK King 9/10/2004 10659 $1,227.02 $184.05 60 9
USA Callahan 10/15/2004 10660 $1,701.00 $255.15 65 10
UK King 9/15/2004 10661 $562.60 $84.39 60 10
USA Leverling 9/18/2004 10662 $125.00 $18.75 70 4
USA Fuller 10/3/2004 10663 $1,930.40 $289.56 21 8
USA Davolio 9/19/2004 10664 $1,288.39 $193.26 40 6
USA Davolio 9/17/2004 10665 $1,295.00 $194.25 30 3
UK King 9/22/2004 10666 $4,666.94 $700.04 30 2
UK King 9/19/2004 10667 $1,536.80 $230.52 50 2
USA Davolio 9/23/2004 10668 $625.27 $93.79 30 5
USA Fuller 9/22/2004 10669 $570.00 $85.50 5 4
USA Peacock 9/18/2004 10670 $2,301.75 $345.26 10 6
USA Davolio 9/24/2004 10671 $920.10 $138.02 2 7
UK Dodsworth 9/26/2004 10672 $3,815.25 $839.36 42 8
USA Fuller 9/19/2004 10673 $412.35 $90.72 15 4
USA Peacock 9/30/2004 10674 $45.00 $9.90 15 5
UK Buchanan 9/23/2004 10675 $1,423.00 $313.06 30 5
USA Fuller 9/29/2004 10676 $534.85 $117.67 10 5
USA Davolio 9/26/2004 10677 $813.36 $178.94 6 6
UK King 10/16/2004 10678 $5,256.50 $1,156.43 35 4
USA Callahan 9/30/2004 10679 $660.00 $145.20 12 5
USA Davolio 9/26/2004 10680 $1,261.88 $277.61 12 3
USA Leverling 9/30/2004 10681 $1,287.40 $283.23 16 2
USA Leverling 10/1/2004 10682 $375.50 $82.61 49 3
USA Fuller 10/1/2004 10683 $63.00 $13.86 9 4
USA Leverling 9/30/2004 10684 $1,768.00 $388.96 25 7
USA Peacock 10/3/2004 10685 $801.10 $176.24 40 6
USA Fuller 10/8/2004 10686 $1,404.45 $210.67 20 5
UK Dodsworth 10/30/2004 10687 $4,960.90 $744.14 24 4
USA Peacock 10/7/2004 10688 $3,160.60 $474.09 40 1
USA Davolio 10/7/2004 10689 $472.50 $70.88 14 1
USA Davolio 10/3/2004 10690 $862.50 $129.38 18 1
USA Fuller 10/22/2004 10691 $10,164.80 $1,524.72 50 1
USA Peacock 10/13/2004 10692 $878.00 $131.70 2 1
USA Leverling 10/10/2004 10693 $2,071.20 $310.68 20 3
USA Callahan 10/9/2004 10694 $4,825.00 $723.75 20 4
UK King 10/14/2004 10695 $642.00 $96.30 10 6
USA Callahan 10/14/2004 10696 $996.00 $149.40 20 6
USA Leverling 10/14/2004 10697 $805.43 $120.81 35 12
USA Peacock 10/17/2004 10698 $3,436.45 $515.47 36 15
USA Leverling 10/13/2004 10699 $114.00 $17.10 50 18
USA Leverling 10/16/2004 10700 $1,638.40 $245.76 2 4
UK Suyama 10/15/2004 10701 $2,864.50 $630.19 15 7
USA Peacock 10/21/2004 10702 $330.00 $72.60 55 9
UK Suyama 10/20/2004 10703 $2,545.00 $559.90 60 9
UK Suyama 11/7/2004 10704 $595.50 $131.01 16 8
UK Dodsworth 11/18/2004 10705 $378.00 $83.16 60 9
USA Callahan 10/21/2004 10706 $1,893.00 $416.46 20 10
USA Peacock 10/23/2004 10707 $1,641.00 $361.02 20 10
UK Suyama 11/5/2004 10708 $180.40 $39.69 8 4
USA Davolio 11/20/2004 10709 $3,424.00 $753.28 20 8
USA Davolio 10/23/2004 10710 $93.50 $20.57 2 6
UK Buchanan 10/29/2004 10711 $4,451.70 $979.37 30 3
USA Leverling 10/31/2004 10712 $1,233.48 $271.37 15 2
USA Davolio 10/24/2004 10713 $2,827.90 $622.14 4 2
UK Buchanan 10/27/2004 10714 $2,205.75 $485.27 10 5
USA Leverling 10/29/2004 10715 $1,296.00 $285.12 2 4
USA Peacock 10/27/2004 10716 $706.00 $105.90 20 6
USA Davolio 10/29/2004 10717 $1,270.75 $190.61 14 7
USA Davolio 10/29/2004 10718 $3,463.00 $519.45 60 8
USA Callahan 11/5/2004 10719 $844.25 $126.64 30 4
USA Callahan 11/5/2004 10720 $550.00 $82.50 49 5
UK Buchanan 10/31/2004 10721 $923.87 $138.58 20 5
USA Callahan 11/4/2004 10722 $1,570.00 $235.50 10 5
USA Leverling 11/25/2004 10723 $468.45 $70.27 7 6
USA Callahan 11/5/2004 10724 $638.50 $95.78 5 4
USA Peacock 11/5/2004 10725 $287.80 $43.17 35 5
USA Peacock 12/5/2004 10726 $655.00 $98.25 20 3
USA Fuller 12/5/2004 10727 $1,624.50 $243.68 40 2
USA Peacock 11/11/2004 10728 $1,296.75 $194.51 35 3
USA Callahan 11/14/2004 10729 $1,850.00 $277.50 45 4
UK Buchanan 11/14/2004 10730 $484.25 $72.64 70 7
UK King 11/14/2004 10731 $1,890.50 $283.58 30 6
USA Leverling 11/7/2004 10732 $360.00 $79.20 50 5
USA Davolio 11/10/2004 10733 $1,459.00 $320.98 50 4
USA Fuller 11/12/2004 10734 $1,498.35 $329.64 50 1
UK Suyama 11/21/2004 10735 $536.40 $118.01 30 1
UK Dodsworth 11/21/2004 10736 $997.00 $219.34 40 1
USA Fuller 11/18/2004 10737 $139.80 $30.76 10 1
USA Fuller 11/18/2004 10738 $52.35 $11.52 28 1
USA Leverling 11/17/2004 10739 $240.00 $52.80 6 3
USA Peacock 11/25/2004 10740 $1,416.00 $311.52 18 4
USA Peacock 11/18/2004 10741 $228.00 $50.16 10 6
USA Leverling 11/18/2004 10742 $3,118.00 $685.96 10 6
USA Davolio 11/21/2004 10743 $319.20 $70.22 12 12
UK Suyama 11/24/2004 10744 $736.00 $161.92 5 15
UK Dodsworth 11/27/2004 10745 $4,529.80 $996.56 40 18
USA Davolio 11/21/2004 10746 $2,311.70 $346.76 24 4
UK Suyama 11/26/2004 10747 $1,912.85 $286.93 30 7
USA Leverling 11/28/2004 10748 $2,196.00 $329.40 15 9
USA Peacock 12/19/2004 10749 $1,080.00 $162.00 15 9
UK Dodsworth 11/24/2004 10750 $1,590.56 $238.58 20 8
USA Leverling 12/3/2004 10751 $1,631.48 $244.72 15 9
USA Fuller 11/28/2004 10752 $252.00 $37.80 15 10
USA Leverling 11/27/2004 10753 $88.00 $13.20 16 10
UK Suyama 11/27/2004 10754 $55.20 $8.28 6 4
USA Peacock 11/28/2004 10755 $1,948.50 $292.28 30 8
USA Callahan 12/2/2004 10756 $1,990.00 $298.50 49 6
UK Suyama 12/15/2004 10757 $3,082.00 $462.30 24 3
USA Leverling 12/4/2004 10758 $1,644.60 $246.69 45 2
USA Leverling 12/12/2004 10759 $320.00 $48.00 90 2
USA Peacock 12/10/2004 10760 $2,917.00 $641.74 50 5
UK Buchanan 12/8/2004 10761 $507.00 $111.54 80 4
USA Leverling 12/9/2004 10762 $4,337.00 $954.14 30 6
USA Leverling 12/8/2004 10763 $616.00 $135.52 60 7
UK Suyama 12/8/2004 10764 $2,286.00 $502.92 6 8
USA Leverling 12/9/2004 10765 $1,515.60 $333.43 12 4
USA Peacock 12/9/2004 10766 $2,310.00 $508.20 8 5
USA Peacock 12/15/2004 10767 $28.00 $6.16 30 5
USA Leverling 12/15/2004 10768 $1,477.00 $324.94 10 5
USA Leverling 12/12/2004 10769 $1,684.27 $370.54 15 6
USA Callahan 12/17/2004 10770 $236.25 $51.98 6 4
UK Dodsworth 1/2/2004 10771 $344.00 $75.68 15 5
USA Leverling 12/19/2004 10772 $3,603.22 $792.71 15 3
USA Davolio 12/16/2004 10773 $2,030.40 $446.69 12 2
USA Peacock 12/12/2004 10774 $868.75 $191.13 20 3
UK King 12/26/2004 10775 $228.00 $50.16 3 4
USA Davolio 12/18/2004 10776 $6,635.27 $995.29 40 7
UK King 1/21/2005 10777 $224.00 $33.60 35 6
USA Leverling 12/24/2004 10778 $96.50 $14.48 2 5
USA Leverling 1/14/2005 10779 $1,335.00 $200.25 20 4
USA Fuller 12/25/2004 10780 $720.00 $108.00 6 1
USA Fuller 12/19/2004 10781 $975.88 $146.38 35 1
UK Dodsworth 12/22/2004 10782 $12.50 $1.88 20 1
USA Peacock 12/19/2004 10783 $1,442.50 $216.38 14 1
USA Peacock 12/22/2004 10784 $1,488.00 $223.20 20 1
USA Davolio 12/24/2004 10785 $387.50 $58.13 6 3
USA Callahan 12/23/2004 10786 $1,531.08 $229.66 35 4
USA Fuller 12/26/2004 10787 $2,622.76 $393.41 28 6
USA Davolio 1/19/2005 10788 $731.50 $109.73 55 6
USA Davolio 12/31/2004 10789 $3,687.00 $553.05 120 12
UK Suyama 12/26/2004 10790 $722.50 $108.38 100 15
UK Suyama 1/1/2005 10791 $1,829.76 $402.55 15 18
USA Davolio 12/31/2004 10792 $399.85 $87.97 25 4
USA Leverling 1/8/2005 10793 $191.10 $42.04 15 7
UK Suyama 1/2/2005 10794 $314.76 $69.25 20 9
USA Callahan 1/20/2005 10795 $2,158.00 $474.76 20 9
USA Leverling 1/14/2005 10796 $2,341.36 $515.10 10 8
UK King 1/5/2005 10797 $420.00 $92.40 25 9
USA Fuller 1/5/2005 10798 $446.60 $98.25 20 10
UK Dodsworth 1/5/2005 10799 $1,553.50 $341.77 50 10
USA Davolio 1/5/2005 10800 $1,468.93 $323.16 30 4
USA Peacock 12/31/2004 10801 $3,026.85 $454.03 21 8
USA Peacock 1/2/2005 10802 $2,942.81 $441.42 40 6
USA Peacock 1/6/2005 10803 $1,193.01 $178.95 36 3
UK Suyama 1/7/2005 10804 $2,278.40 $341.76 30 2
USA Fuller 1/9/2005 10805 $2,775.00 $416.25 20 2
USA Leverling 1/5/2005 10806 $439.60 $65.94 50 5
USA Peacock 1/30/2005 10807 $18.40 $2.76 15 4
USA Fuller 1/9/2005 10808 $1,411.00 $211.65 30 6
UK King 1/7/2005 10809 $140.00 $21.00 16 7
USA Fuller 1/7/2005 10810 $187.00 $28.05 40 8
USA Callahan 1/8/2005 10811 $852.00 $127.80 20 4
UK Buchanan 1/12/2005 10812 $1,692.80 $253.92 21 5
USA Davolio 1/9/2005 10813 $602.40 $90.36 4 5
USA Leverling 1/14/2005 10814 $1,788.45 $268.27 40 5
USA Fuller 1/14/2005 10815 $40.00 $6.00 28 6
USA Peacock 2/4/2005 10816 $8,446.45 $1,266.97 60 4
USA Leverling 1/13/2005 10817 $10,952.84 $1,642.93 21 5
UK King 1/12/2005 10818 $833.00 $124.95 1 3
USA Fuller 1/16/2005 10819 $477.00 $104.94 21 2
USA Leverling 1/13/2005 10820 $1,140.00 $250.80 50 3
USA Davolio 1/15/2005 10821 $678.00 $149.16 3 4
UK Suyama 1/16/2005 10822 $237.90 $52.34 20 7
UK Buchanan 1/13/2005 10823 $2,826.00 $621.72 30 6
USA Callahan 1/30/2005 10824 $250.80 $55.18 16 5
USA Davolio 1/14/2005 10825 $1,030.76 $226.77 25 4
UK Suyama 2/6/2005 10826 $730.00 $160.60 25 1
USA Davolio 2/6/2005 10827 $843.00 $185.46 30 1
UK Dodsworth 2/4/2005 10828 $932.00 $205.04 18 1
UK Dodsworth 1/23/2005 10829 $1,764.00 $388.08 20 1
USA Peacock 1/21/2005 10830 $1,974.00 $434.28 10 1
USA Leverling 1/23/2005 10831 $2,684.40 $590.57 5 3
USA Fuller 1/19/2005 10832 $475.11 $71.27 12 4
UK Suyama 1/23/2005 10833 $906.93 $136.04 28 6
USA Davolio 1/19/2005 10834 $1,432.71 $214.91 15 6
USA Davolio 1/21/2005 10835 $845.80 $126.87 8 12
UK King 1/21/2005 10836 $4,705.50 $705.83 35 15
UK Dodsworth 1/23/2005 10837 $1,064.50 $159.68 2 18
USA Leverling 1/23/2005 10838 $1,938.38 $290.76 40 4
USA Leverling 1/22/2005 10839 $827.55 $124.13 8 7
USA Peacock 2/16/2005 10840 $211.20 $31.68 15 9
UK Buchanan 1/29/2005 10841 $4,581.00 $687.15 30 9
USA Davolio 1/29/2005 10842 $975.00 $146.25 30 8
USA Peacock 1/26/2005 10843 $159.00 $23.85 20 9
USA Callahan 1/26/2005 10844 $735.00 $110.25 18 10
USA Callahan 1/30/2005 10845 $3,812.70 $571.91 80 10
USA Fuller 1/23/2005 10846 $1,112.00 $166.80 12 4
USA Peacock 2/10/2005 10847 $4,931.92 $739.79 12 8
UK King 1/29/2005 10848 $931.50 $139.73 12 6
UK Dodsworth 1/30/2005 10849 $967.82 $145.17 21 3
USA Davolio 1/30/2005 10850 $629.00 $94.35 10 2
UK Buchanan 2/2/2005 10851 $2,603.00 $390.45 18 2
USA Callahan 1/30/2005 10852 $2,984.00 $447.60 42 5
UK Dodsworth 2/3/2005 10853 $625.00 $93.75 35 4
USA Leverling 2/5/2005 10854 $2,966.50 $444.98 60 6
USA Leverling 2/4/2005 10855 $2,227.89 $334.18 2 7
USA Leverling 2/10/2005 10856 $660.00 $145.20 12 8
USA Callahan 2/6/2005 10857 $2,048.22 $450.61 15 4
USA Fuller 2/3/2005 10858 $649.00 $142.78 20 5
USA Davolio 2/2/2005 10859 $1,078.69 $237.31 21 5
USA Leverling 2/4/2005 10860 $519.00 $114.18 20 5
USA Peacock 2/17/2005 10861 $3,523.40 $775.15 28 6
USA Callahan 2/2/2005 10862 $581.00 $127.82 30 4
USA Peacock 2/17/2005 10863 $441.15 $97.05 30 5
USA Peacock 2/9/2005 10864 $282.00 $62.04 60 3
USA Fuller 2/12/2005 10865 $16,387.50 $3,605.25 30 2
UK Buchanan 2/12/2005 10866 $1,096.20 $241.16 12 3
UK Suyama 2/11/2005 10867 $98.40 $21.65 40 4
UK King 2/23/2005 10868 $1,920.60 $422.53 24 7
UK Buchanan 2/9/2005 10869 $1,630.00 $358.60 10 6
UK Buchanan 2/13/2005 10870 $160.00 $35.20 30 5
UK Dodsworth 2/10/2005 10871 $1,979.23 $435.43 35 4
UK Buchanan 2/9/2005 10872 $2,058.46 $452.86 14 1
USA Peacock 2/9/2005 10873 $336.80 $74.10 10 1
UK Buchanan 2/11/2005 10874 $310.00 $68.20 3 1
USA Peacock 3/3/2005 10875 $709.55 $156.10 20 1
UK King 2/12/2005 10876 $917.00 $201.74 60 1
USA Davolio 2/19/2005 10877 $1,955.13 $430.13 30 3
USA Peacock 2/12/2005 10878 $1,539.00 $230.85 20 4
USA Leverling 2/12/2005 10879 $611.30 $91.70 5 6
UK King 2/18/2005 10880 $1,500.00 $225.00 16 6
USA Peacock 2/18/2005 10881 $150.00 $22.50 25 12
USA Peacock 2/20/2005 10882 $892.64 $133.90 30 15
USA Callahan 2/20/2005 10883 $36.00 $5.40 24 18
USA Peacock 2/13/2005 10884 $1,378.07 $206.71 5 4
UK Suyama 2/18/2005 10885 $1,209.00 $181.35 20 7
USA Davolio 3/2/2005 10886 $3,127.50 $469.13 30 9
USA Callahan 2/16/2005 10887 $70.00 $10.50 18 9
USA Davolio 2/23/2005 10888 $605.00 $90.75 15 8
UK Dodsworth 2/23/2005 10889 $11,380.00 $1,707.00 30 9
UK King 2/18/2005 10890 $860.10 $189.22 36 10
UK King 2/19/2005 10891 $368.93 $81.16 60 10
USA Peacock 2/19/2005 10892 $2,090.00 $459.80 7 4
UK Dodsworth 2/20/2005 10893 $5,502.11 $1,210.46 15 8
USA Davolio 2/20/2005 10894 $2,753.10 $605.68 60 6
USA Leverling 2/23/2005 10895 $6,379.40 $1,403.47 20 3
UK King 2/27/2005 10896 $750.50 $165.11 10 2
USA Leverling 2/25/2005 10897 $10,835.24 $2,383.75 10 2
USA Peacock 3/6/2005 10898 $30.00 $6.60 15 5
UK Buchanan 2/26/2005 10899 $122.40 $26.93 30 4
USA Davolio 3/4/2005 10900 $33.75 $7.43 5 6
USA Peacock 2/26/2005 10901 $934.50 $205.59 20 7
USA Davolio 3/3/2005 10902 $863.43 $189.95 10 8
USA Leverling 3/4/2005 10903 $932.05 $205.05 20 4
USA Leverling 2/27/2005 10904 $1,924.25 $288.64 14 5
UK Dodsworth 3/6/2005 10905 $342.00 $51.30 25 5
USA Peacock 3/3/2005 10906 $427.50 $64.13 25 5
UK Suyama 2/27/2005 10907 $108.50 $16.28 14 6
USA Peacock 3/6/2005 10908 $663.10 $99.47 5 4
USA Davolio 3/10/2005 10909 $670.00 $100.50 30 5
USA Davolio 3/4/2005 10910 $452.90 $67.94 20 3
USA Leverling 3/5/2005 10911 $858.00 $128.70 25 2
USA Fuller 3/18/2005 10912 $6,200.55 $930.08 12 3
USA Peacock 3/4/2005 10913 $768.75 $115.31 8 4
UK Suyama 3/2/2005 10914 $537.50 $80.63 20 7
USA Fuller 3/2/2005 10915 $539.50 $80.93 6 6
USA Davolio 3/9/2005 10916 $686.70 $103.01 21 5
USA Peacock 3/11/2005 10917 $365.89 $54.88 30 4
USA Leverling 3/11/2005 10918 $1,447.50 $318.45 20 1
USA Fuller 3/4/2005 10919 $1,122.80 $247.02 70 1
USA Peacock 3/9/2005 10920 $390.00 $85.80 10 1
USA Davolio 3/9/2005 10921 $1,936.00 $425.92 12 1
UK Buchanan 3/5/2005 10922 $742.50 $163.35 12 1
UK King 3/13/2005 10923 $748.80 $164.74 25 3
USA Leverling 4/8/2005 10924 $1,835.70 $403.85 3 4
USA Leverling 3/13/2005 10925 $475.15 $104.53 14 6
USA Peacock 3/11/2005 10926 $514.40 $113.17 18 6
USA Peacock 4/8/2005 10927 $800.00 $176.00 15 12
USA Davolio 3/18/2005 10928 $137.50 $30.25 15 15
UK Suyama 3/12/2005 10929 $1,174.75 $258.45 10 18
USA Peacock 3/18/2005 10930 $2,255.50 $496.21 10 4
USA Peacock 3/19/2005 10931 $799.20 $175.82 3 7
USA Callahan 3/24/2005 10932 $1,788.63 $268.29 36 9
UK Suyama 3/16/2005 10933 $920.60 $138.09 36 9
USA Leverling 3/12/2005 10934 $500.00 $75.00 50 8
USA Peacock 3/18/2005 10935 $619.50 $92.93 50 9
USA Leverling 3/18/2005 10936 $456.00 $68.40 10 10
UK King 3/13/2005 10937 $644.80 $96.72 6 10
USA Leverling 3/16/2005 10938 $2,731.87 $409.78 12 4
USA Fuller 3/13/2005 10939 $637.50 $95.63 9 8
USA Callahan 3/23/2005 10940 $360.00 $54.00 10 6
UK King 3/20/2005 10941 $4,011.75 $601.76 40 3
UK Dodsworth 3/18/2005 10942 $560.00 $84.00 15 2
USA Peacock 3/19/2005 10943 $711.00 $106.65 50 2
UK Suyama 3/13/2005 10944 $1,025.33 $153.80 70 5
USA Peacock 3/18/2005 10945 $245.00 $36.75 39 4
USA Davolio 3/19/2005 10946 $1,407.50 $309.65 35 6
USA Leverling 3/16/2005 10947 $220.00 $48.40 50 7
USA Leverling 3/19/2005 10948 $2,362.25 $519.70 39 8
USA Fuller 3/17/2005 10949 $4,422.00 $972.84 50 4
USA Davolio 3/23/2005 10950 $110.00 $24.20 16 5
UK Dodsworth 4/7/2005 10951 $458.74 $100.92 16 5
USA Davolio 3/24/2005 10952 $471.20 $103.66 84 5
UK Dodsworth 3/25/2005 10953 $4,441.25 $977.08 120 6
UK Buchanan 3/20/2005 10954 $1,659.53 $365.10 25 4
USA Callahan 3/20/2005 10955 $74.40 $16.37 20 5
UK Suyama 3/20/2005 10956 $677.00 $148.94 80 3
USA Callahan 3/27/2005 10957 $1,762.70 $387.79 6 2
UK King 3/27/2005 10958 $781.00 $171.82 4 3
UK Suyama 3/23/2005 10959 $131.75 $28.99 6 4
USA Leverling 4/8/2005 10960 $265.35 $58.38 5 7
USA Callahan 3/30/2005 10961 $1,119.90 $167.99 9 6
USA Callahan 3/23/2005 10962 $3,584.00 $537.60 15 5
UK Dodsworth 3/26/2005 10963 $57.80 $8.67 10 4
USA Leverling 3/24/2005 10964 $2,052.50 $307.88 16 1
UK Suyama 3/30/2005 10965 $848.00 $127.20 40 1
USA Peacock 4/8/2005 10966 $1,098.46 $164.77 5 1
USA Fuller 4/2/2005 10967 $910.40 $136.56 8 1
USA Davolio 4/1/2005 10968 $1,408.00 $211.20 6 1
USA Davolio 3/30/2005 10969 $108.00 $16.20 3 3
UK Dodsworth 4/24/2005 10970 $224.00 $33.60 10 4
USA Fuller 4/2/2005 10971 $1,733.06 $259.96 25 6
USA Peacock 3/26/2005 10972 $251.50 $55.33 20 6
UK Suyama 3/27/2005 10973 $291.55 $64.14 24 12
USA Leverling 4/3/2005 10974 $439.00 $96.58 40 15
USA Davolio 3/27/2005 10975 $717.50 $157.85 18 18
USA Davolio 4/3/2005 10976 $912.00 $200.64 25 4
USA Callahan 4/10/2005 10977 $2,233.00 $491.26 15 7
UK Dodsworth 4/23/2005 10978 $1,303.19 $286.70 6 9
USA Callahan 3/31/2005 10979 $4,813.50 $1,058.97 60 9
USA Peacock 4/17/2005 10980 $248.00 $54.56 10 8
USA Davolio 4/2/2005 10981 $15,810.00 $3,478.20 2 9
USA Fuller 4/8/2005 10982 $1,014.00 $223.08 15 10
USA Fuller 4/6/2005 10983 $720.90 $158.60 30 10
USA Davolio 4/3/2005 10984 $1,809.75 $398.15 15 4
USA Fuller 4/2/2005 10985 $2,023.38 $445.14 30 8
USA Callahan 4/21/2005 10986 $2,220.00 $488.40 10 6
USA Callahan 4/6/2005 10987 $2,772.00 $609.84 8 3
USA Leverling 4/10/2005 10988 $3,574.80 $786.46 50 2
USA Fuller 4/2/2005 10989 $1,353.60 $297.79 30 2
USA Fuller 4/7/2005 10990 $4,288.85 $943.55 3 5
USA Davolio 4/7/2005 10991 $2,296.00 $344.40 8 4
USA Davolio 4/3/2005 10992 $69.60 $10.44 9 6
UK King 4/10/2005 10993 $4,895.44 $734.32 14 7
USA Fuller 4/9/2005 10994 $940.50 $141.08 20 8
USA Davolio 4/6/2005 10995 $1,196.00 $179.40 10 4
USA Peacock 4/10/2005 10996 $560.00 $84.00 40 5
USA Callahan 4/13/2005 10997 $1,885.00 $282.75 20 5
USA Callahan 4/17/2005 10998 $686.00 $102.90 25 5
UK Suyama 4/10/2005 10999 $1,197.95 $179.69 50 6
USA Fuller 4/14/2005 11000 $903.75 $135.56 2 4
USA Fuller 4/14/2005 11001 $2,769.00 $415.35 24 5
USA Peacock 4/16/2005 11002 $1,811.10 $398.44 15 3
USA Leverling 4/8/2005 11003 $326.00 $71.72 50 2
USA Leverling 4/20/2005 11004 $295.38 $64.98 24 3
USA Fuller 4/10/2005 11005 $586.00 $128.92 24 4
USA Leverling 4/15/2005 11006 $329.69 $72.53 10 7
USA Callahan 4/13/2005 11007 $2,633.90 $579.46 10 6
USA Fuller 4/10/2005 11009 $616.50 $135.63 10 5
USA Fuller 4/21/2005 11010 $645.00 $141.90 50 4
USA Leverling 4/13/2005 11011 $933.50 $205.37 5 1
USA Davolio 4/17/2005 11012 $2,825.30 $423.80 15 1
USA Fuller 4/10/2005 11013 $361.00 $54.15 10 1
USA Fuller 4/15/2005 11014 $243.18 $36.48 15 1
USA Fuller 4/20/2005 11015 $622.35 $93.35 30 1
UK Dodsworth 4/13/2005 11016 $491.50 $73.73 35 3
UK Dodsworth 4/20/2005 11017 $6,750.00 $1,012.50 20 4
USA Peacock 4/16/2005 11018 $1,575.00 $236.25 20 6
USA Fuller 4/16/2005 11020 $632.40 $94.86 6 6
USA Leverling 4/21/2005 11021 $6,306.24 $945.94 21 12
USA Davolio 4/24/2005 11023 $1,500.00 $225.00 9 15
USA Peacock 4/20/2005 11024 $1,966.81 $295.02 30 18
UK Suyama 4/24/2005 11025 $270.00 $59.40 7 4
USA Peacock 4/28/2005 11026 $1,030.00 $226.60 1 7
USA Davolio 4/20/2005 11027 $877.72 $193.10 15 9
USA Fuller 4/22/2005 11028 $2,160.00 $475.20 8 9
USA Peacock 4/27/2005 11029 $1,286.80 $283.10 6 8
UK King 4/27/2005 11030 $12,615.05 $2,775.31 15 9
UK Suyama 4/24/2005 11031 $2,393.50 $526.57 60 10
USA Fuller 4/23/2005 11032 $8,902.50 $1,958.55 30 10
UK King 4/23/2005 11033 $3,232.80 $711.22 40 4
USA Callahan 4/27/2005 11034 $539.40 $118.67 35 8
USA Fuller 4/24/2005 11035 $1,754.50 $385.99 35 6
USA Callahan 4/22/2005 11036 $1,692.00 $372.24 36 3
UK King 4/27/2005 11037 $60.00 $13.20 9 2
USA Davolio 4/30/2005 11038 $732.60 $161.17 4 2
USA Leverling 4/28/2005 11041 $1,773.00 $265.95 15 5
USA Fuller 5/1/2005 11042 $405.75 $60.86 24 4
UK Buchanan 4/29/2005 11043 $210.00 $31.50 30 6
USA Peacock 5/1/2005 11044 $591.60 $88.74 70 7
USA Callahan 4/24/2005 11046 $1,485.80 $222.87 7 8
UK King 5/1/2005 11047 $817.87 $122.68 7 4
UK King 4/30/2005 11048 $525.00 $78.75 10 5
USA Leverling 5/1/2005 11052 $1,332.00 $199.80 30 5
USA Fuller 4/29/2005 11053 $3,055.00 $458.25 10 5
USA Callahan 5/1/2005 11056 $3,740.00 $561.00 40 6
USA Leverling 5/1/2005 11057 $45.00 $6.75 60 4
Question 1 A) How many Salespersons are listed
in all of the rows (including
duplicates)?

B) How many unique Salespersons

are listed?
Salesperson Count of Salesperson
Buchanan 42
Callahan 99
Davolio 117
Dodsworth 41
Fuller 92 This represents how many times each person's name is listed.
King 67
Leverling 125
Peacock 151
Suyama 65
Total Result 799
son's name is listed.
Row Labels Count of Salesperson Distinct Count of Salesperson2
Buchanan 42 1
Callahan 99 1
Davolio 117 1
Dodsworth 41 1
Fuller 92 1 This is a Distinct Count
King 67 1 (unique) of each person's
Leverling 125 1 names and removes
Peacock 151 1 duplicates
Suyama 65 1
Grand Total 799 9

This represents how many times each person's name is listed.

Distinct Count
of each person's
OrderID Product ID Customer ID Ship Via Units Ordered Order Date Ship Date
2 CRV365 10 United Parcel Service 4 2/15/2015 2/17/2015
3 CHQ232 8 Federal Express 16 2/17/2015 2/19/2015
4 CRS699 6 Airborne Express 10 2/19/2015 2/22/2015
6 CNT343 10 Airborne Express 4 2/21/2015 2/25/2015
7 FAB675 8 United Parcel Service 2 3/6/2015 3/9/2015
9 BUT654 3 Federal Express 6 3/19/2015 3/21/2015
11 CNT888 7 Airborne Express 4 3/31/2015 4/4/2015
13 UPH444 12 Federal Express 10 4/5/2015 4/6/2015
15 ARR798 5 Airborne Express 6 4/13/2015 4/15/2015
17 VNY377 20 United Parcel Service 4 4/21/2015 4/23/2015
18 BUT654 2 Federal Express 2 4/25/2015 4/29/2015
19 PER499 4 Airborne Express 6 4/30/2015 5/2/2015
20 CRV365 16 United Parcel Service 4 5/1/2015 5/3/2015
21 CRS699 6 United Parcel Service 2 5/3/2015 5/5/2015
22 ARW344 9 Federal Express 2 5/5/2015 5/7/2015
23 QNA555 7 United Parcel Service 4 5/7/2015 5/9/2015
24 PER499 5 Federal Express 8 5/7/2015 5/9/2015
25 DOW872 18 United Parcel Service 12 5/9/2015 5/11/2015
26 BUT654 2 Federal Express 2 5/31/2015 6/3/2015
27 SHT477 4 Airborne Express 4 6/2/2015 6/6/2015
28 CRV365 16 United Parcel Service 4 6/5/2015 6/9/2015
29 VNY377 1 United Parcel Service 4 6/9/2015 6/13/2015
30 LAD346 7 Federal Express 2 6/11/2015 6/15/2015
31 PER499 13 Federal Express 6 6/14/2015 6/19/2015
32 QNA555 20 Federal Express 2 6/17/2015 6/24/2015
33 DOW872 15 United Parcel Service 2 6/19/2015 6/21/2015
34 DOW872 15 United Parcel Service 2 6/23/2015 6/25/2015
35 UPH444 17 Federal Express 6 6/25/2015 6/29/2015
36 BUT654 1 Federal Express 4 6/27/2015 6/30/2015
37 CED678 12 Airborne Express 2 1/8/2015 1/12/2015
38 HBL657 8 Federal Express 1 1/8/2015 1/11/2015
39 CMB773 10 United Parcel Service 6 1/10/2015 1/14/2015
40 VFD743 11 United Parcel Service 8 1/12/2015 1/15/2015
41 DOC488 7 Federal Express 4 1/15/2015 1/19/2015
42 CEC467 6 Federal Express 4 1/19/2015 1/21/2015
43 LCW123 5 United Parcel Service 4 1/25/2015 1/29/2015
44 ARR798 11 Federal Express 6 1/6/2015 1/11/2015
45 CNT343 9 United Parcel Service 8 1/3/2015 1/6/2015
46 CCB543 3 Airborne Express 2 2/3/2015 2/9/2015
47 MFC490 2 United Parcel Service 8 2/1/2015 2/5/2015
48 MCA593 9 Federal Express 1 2/7/2015 2/13/2015
49 PCB103 15 United Parcel Service 2 2/9/2015 2/15/2015
50 PCA903 19 Federal Express 2 2/19/2015 2/23/2015
51 VFD743 18 United Parcel Service 6 2/21/2015 2/27/2015
52 CCD582 21 Federal Express 2 3/5/2015 3/9/2015
53 CED678 31 United Parcel Service 6 3/7/2015 3/11/2015
54 LOD288 23 Federal Express 4 3/11/2015 3/14/2015
55 CEC467 24 Federal Express 4 3/11/2015 3/15/2015
56 DOC488 25 Airborne Express 6 3/14/2015 3/19/2015
57 MBT657 22 Federal Express 6 3/16/2015 3/21/2015
58 LFD755 30 United Parcel Service 10 3/17/2015 3/22/2015
59 LFD755 28 Federal Express 8 3/18/2015 3/25/2015
60 OFC024 29 Federal Express 4 3/19/2015 3/21/2015
61 SWC998 12 United Parcel Service 4 3/21/2015 3/27/2015
62 CMB773 13 Airborne Express 6 3/25/2015 3/31/2015
63 CCC921 22 Federal Express 4 4/7/2015 4/11/2015
64 CCD582 31 Federal Express 2 4/9/2015 4/14/2015
65 CED678 15 United Parcel Service 3 4/11/2015 4/15/2015
66 LCW123 16 Airborne Express 4 4/12/2015 4/19/2015
67 PCC732 5 Federal Express 6 4/13/2015 4/19/2015
68 PCC903 6 Federal Express 4 4/14/2015 4/21/2015
69 MOC993 7 United Parcel Service 2 4/15/2015 4/21/2015
70 MCA593 8 Federal Express 2 4/16/2015 4/21/2015
71 TAA120 9 Airborne Express 4 4/17/2015 4/22/2015
72 CCD582 11 Federal Express 1 5/5/2015 5/11/2015
73 SOW664 23 Federal Express 1 5/9/2015 5/13/2015
74 TCL544 12 Federal Express 4 6/3/2015 6/9/2015
75 DOC488 28 United Parcel Service 2 6/5/2015 6/11/2015
76 SWC998 30 Federal Express 6 6/9/2015 6/13/2015
77 TCA621 29 Federal Express 8 6/11/2015 6/19/2015
78 LFD755 2 Federal Express 4 6/2/2015 6/7/2015
79 OFC024 26 Federal Express 6 6/4/2015 6/9/2015
80 MCA593 10 United Parcel Service 1 1/9/2015 1/14/2015
81 CCB543 20 Federal Express 1 1/9/2015 1/17/2015
82 CCC921 15 United Parcel Service 4 1/14/2015 1/19/2015
83 PCC732 24 Federal Express 4 2/9/2015 2/14/2015
84 CEC467 16 Federal Express 1 2/12/2015 2/19/2015
85 CED678 17 Airborne Express 2 2/14/2015 2/17/2015
86 CED678 19 Federal Express 1 2/19/2015 2/25/2015
87 LCW123 1 Federal Express 1 2/25/2015 3/1/2015
88 PCA903 18 Airborne Express 1 3/4/2015 3/9/2015
89 PCB103 12 Federal Express 2 3/6/2015 3/14/2015
90 PCB436 9 Federal Express 1 3/14/2015 3/21/2015
91 CCC921 31 Airborne Express 4 3/21/2015 3/27/2015
92 PCB103 5 Federal Express 1 4/16/2015 4/27/2015
93 MCA593 2 Federal Express 2 5/7/2015 5/14/2015
94 PCB103 3 Federal Express 2 5/17/2015 5/28/2015
95 PCB436 29 Airborne Express 1 5/4/2015 5/14/2015
96 CCC921 22 Airborne Express 2 5/6/2015 5/14/2015
 97 CEC467 11 Federal Express 1 5/17/2015 5/25/2015
98 CMB773 26 Federal Express 6 5/19/2015 5/25/2015
99 MCA593 25 Federal Express 2 5/31/2015 6/7/2015
100 CCB543 21 Federal Express 6 6/11/2015 6/20/2015
101 CCC921 28 Airborne Express 6 6/23/2015 6/23/2015
102 CED678 12 Airborne Express 1 6/27/2015 7/4/2015
103 LCW123 17 Federal Express 2 6/21/2015 6/27/2015
104 LFD755 17 Federal Express 4 4/12/2015 4/19/2015
105 VFD743 31 United Parcel Service 2 4/14/2015 4/19/2015
106 PFC326 18 Federal Express 2 5/9/2015 5/15/2015
107 OFC024 22 Federal Express 4 5/13/2015 5/21/2015
1 PER499 19 Federal Express 2 2/7/2015 2/11/2015
5 ARW344 9 United Parcel Service 2 2/20/2015 2/22/2015
8 DOW872 12 Federal Express 4 3/15/2015 3/19/2015
10 CHQ232 1 United Parcel Service 2 3/25/2015 3/27/2015
12 QNA555 14 United Parcel Service 4 3/31/2015 4/4/2015
14 LAD346 18 United Parcel Service 6 4/9/2015 4/11/2015
16 SHT477 13 Federal Express 4 4/19/2015 4/23/2015
 Customer Name Address City Phone Unit Cost
Franklins 257 Marshall Highway Mississauga 905- 555-4488 $ 36.40
Eastern Manufacturing 213 Singleton Dr. Scarborough 416- 555-3355 $ 48.12
Debois Manufacturing 622 Lindsey Rd. Mississauga 905- 555-4929 $ 52.95
Franklins 257 Marshall Highway Mississauga 905- 555-4488 $ 92.00
Eastern Manufacturing 213 Singleton Dr. Scarborough 416- 555-3355 $ 88.62
Consolidated 722 Blanchard Rd. Mississauga 905- 555-4378 $ 35.02
Emerson & Son 413 Massachusetts Ave. Scarborough 416- 555-3478 $ 39.09
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 48.45
Damon Family 753 Kenlawn Dr. Etobicoke 416- 555-3444 $ 32.76
Tormiga Inc. 47389 Cantos Ct. Scarborough 416- 555-5667 $ 50.88
Bon Vivant 86 Riverside Rd. Mississauga 905- 555-7755 $ 35.02
Corrugated 893 Taxon Rd. Toronto 416- 555-2233 $ 76.26
La Isla Trading 2567 Wellstone Dr. North York 416- 555-8899 $ 36.40
Debois Manufacturing 622 Lindsey Rd. Mississauga 905- 555-4929 $ 52.95
Folk Art Today 1567 Godfrey Dr. Etobicoke 416- 555-3377 $ 53.70
Emerson & Son 413 Massachusetts Ave. Scarborough 416- 555-3478 $ 84.48
Damon Family 753 Kenlawn Dr. Etobicoke 416- 555-3444 $ 76.26
Natalie's 4576 Fander Dr. Mississauga 905- 555-9104 $ 39.41
Bon Vivant 86 Riverside Rd. Mississauga 905- 555-7755 $ 35.02
Corrugated 893 Taxon Rd. Toronto 416- 555-2233 $ 59.38
La Isla Trading 2567 Wellstone Dr. North York 416- 555-8899 $ 36.40
Albert's Retail 564 Sigmund Highway Mississauga 905- 555-7733 $ 50.88
Emerson & Son 413 Massachusetts Ave. Scarborough 416- 555-3478 $ 39.72
Hillary's Hideout 34786 Richards Rd. Mississauga 905- 555-1093 $ 76.26
Tormiga Inc. 47389 Cantos Ct. Scarborough 416- 555-5667 $ 84.48
Johnston King 1667 Lansing Dr. Mississauga 905- 555-1093 $ 39.41
Johnston King 1667 Lansing Dr. Mississauga 905- 555-1093 $ 39.41
Marianne's 294 El Rancho Rd. Etobicoke 416- 555-0432 $ 48.45
Albert's Retail 564 Sigmund Highway Mississauga 905- 555-7733 $ 35.02
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 22.23
Eastern Manufacturing 213 Singleton Dr. Scarborough 416- 555-3355 $ 16.69
Franklins 257 Marshall Highway Mississauga 905- 555-4488 $ 71.97
Garbo's Goodies 6887 Grant Ave. Scarborough 416- 555-7532 $ 40.46
Emerson & Son 413 Massachusetts Ave. Scarborough 416- 555-3478 $ 39.50
Debois Manufacturing 622 Lindsey Rd. Mississauga 905- 555-4929 $ 3.57
Damon Family 753 Kenlawn Dr. Etobicoke 416- 555-3444 $ 91.25
Garbo's Goodies 6887 Grant Ave. Scarborough 416- 555-7532 $ 32.76
Folk Art Today 1567 Godfrey Dr. Etobicoke 416- 555-3377 $ 92.00
Consolidated 722 Blanchard Rd. Mississauga 905- 555-4378 $ 53.08
Bon Vivant 86 Riverside Rd. Mississauga 905- 555-7755 $ 31.43
Folk Art Today 1567 Godfrey Dr. Etobicoke 416- 555-3377 $ 79.51
Johnston King 1667 Lansing Dr. Mississauga 905- 555-1093 $ 67.21
Romeo and Juliet Inc. 74 Delilah Ave. Mississauga 905- 555-9054 $ 46.68
Natalie's 4576 Fander Dr. Mississauga 905- 555-9104 $ 40.46
Cimarron Gifts 477 Highway 78 Etobicoke 416- 555-8411 $ 31.66
Kimball's Office Supplies 786 Ferndale Dr. Mississauga 905- 555-7778 $ 22.23
Village Office Supplies 589 Paradise Dr. Toronto 416- 555-2134 $ 37.43
Copper Mountain Inn 999 Cerillos Dr. Mississauga 905- 555-4444 $ 3.57
Black Crystal Lodge 587 Otero Cir. Toronto 416- 555-6543 $ 39.50
Jicarilla Trading Post 56 Mecham Dr. Etobicoke 416- 555-9030 $ 69.03
Chiricahua Gallery 57893 Estes Park Dr. North York 416- 555-2333 $ 86.34
San Albino Office Supply 123 Freeway Rd. Scarborough 416- 555-3333 $ 86.34
Sunland Hot Springs Resort 34 Moraine Ave. Scarborough 416- 555-9990 $ 94.26
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 75.09
Hillary's Hideout 34786 Richards Rd. Mississauga 905- 555-1093 $ 71.97
Jicarilla Trading Post 56 Mecham Dr. Etobicoke 416- 555-9030 $ 81.38
Kimball's Office Supplies 786 Ferndale Dr. Mississauga 905- 555-7778 $ 31.66
Johnston King 1667 Lansing Dr. Mississauga 905- 555-1093 $ 22.23
La Isla Trading 2567 Wellstone Dr. North York 416- 555-8899 $ 91.25
Damon Family 753 Kenlawn Dr. Etobicoke 416- 555-3444 $ 80.68
Debois Manufacturing 622 Lindsey Rd. Mississauga 905- 555-4929 $ 88.13
Emerson & Son 413 Massachusetts Ave. Scarborough 416- 555-3478 $ 9.21
Eastern Manufacturing 213 Singleton Dr. Scarborough 416- 555-3355 $ 79.51
Folk Art Today 1567 Godfrey Dr. Etobicoke 416- 555-3377 $ 57.27
Garbo's Goodies 6887 Grant Ave. Scarborough 416- 555-7532 $ 31.66
Village Office Supplies 589 Paradise Dr. Toronto 416- 555-2134 $ 40.52
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 73.28
San Albino Office Supply 123 Freeway Rd. Scarborough 416- 555-3333 $ 39.50
Chiricahua Gallery 57893 Estes Park Dr. North York 416- 555-2333 $ 75.09
Sunland Hot Springs Resort 34 Moraine Ave. Scarborough 416- 555-9990 $ 10.55
Bon Vivant 86 Riverside Rd. Mississauga 905- 555-7755 $ 86.34
Rio Picacho Country Club 56 Canyon Rd. Etobicoke 416- 555-4599 $ 94.26
Franklins 257 Marshall Highway Mississauga 905- 555-4488 $ 79.51
Tormiga Inc. 47389 Cantos Ct. Scarborough 416- 555-5667 $ 53.08
Johnston King 1667 Lansing Dr. Mississauga 905- 555-1093 $ 81.38
Copper Mountain Inn 999 Cerillos Dr. Mississauga 905- 555-4444 $ 80.68
La Isla Trading 2567 Wellstone Dr. North York 416- 555-8899 $ 3.57
Marianne's 294 El Rancho Rd. Etobicoke 416- 555-0432 $ 22.23
Romeo and Juliet Inc. 74 Delilah Ave. Mississauga 905- 555-9054 $ 22.23
Albert's Retail 564 Sigmund Highway Mississauga 905- 555-7733 $ 91.25
Natalie's 4576 Fander Dr. Mississauga 905- 555-9104 $ 46.68
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 67.21
Folk Art Today 1567 Godfrey Dr. Etobicoke 416- 555-3377 $ 94.16
Kimball's Office Supplies 786 Ferndale Dr. Mississauga 905- 555-7778 $ 81.38
Damon Family 753 Kenlawn Dr. Etobicoke 416- 555-3444 $ 67.21
Bon Vivant 86 Riverside Rd. Mississauga 905- 555-7755 $ 79.51
Consolidated 722 Blanchard Rd. Mississauga 905- 555-4378 $ 67.21
Sunland Hot Springs Resort 34 Moraine Ave. Scarborough 416- 555-9990 $ 94.16
Jicarilla Trading Post 56 Mecham Dr. Etobicoke 416- 555-9030 $ 81.38
Garbo's Goodies 6887 Grant Ave. Scarborough 416- 555-7532 $ 3.57
Rio Picacho Country Club 56 Canyon Rd. Etobicoke 416- 555-4599 $ 71.97
Black Crystal Lodge 587 Otero Cir. Toronto 416- 555-6543 $ 79.51
Cimarron Gifts 477 Highway 78 Etobicoke 416- 555-8411 $ 53.08
San Albino Office Supply 123 Freeway Rd. Scarborough 416- 555-3333 $ 81.38
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 22.23
Marianne's 294 El Rancho Rd. Etobicoke 416- 555-0432 $ 91.25
Marianne's 294 El Rancho Rd. Etobicoke 416- 555-0432 $ 86.34
Kimball's Office Supplies 786 Ferndale Dr. Mississauga 905- 555-7778 $ 40.46
Natalie's 4576 Fander Dr. Mississauga 905- 555-9104 $ 10.98
Jicarilla Trading Post 56 Mecham Dr. Etobicoke 416- 555-9030 $ 94.26
Romeo and Juliet Inc. 74 Delilah Ave. Mississauga 905- 555-9054 $ 76.26
Folk Art Today 1567 Godfrey Dr. Etobicoke 416- 555-3377 $ 53.70
Great Falls Gifts 5110 Devon Drive North York 416- 555-6789 $ 39.41
Albert's Retail 564 Sigmund Highway Mississauga 905- 555-7733 $ 48.12
Inflections 294 Bradford Rd. Toronto 416- 555-2233 $ 84.48
Natalie's 4576 Fander Dr. Mississauga 905- 555-9104 $ 39.72
Hillary's Hideout 34786 Richards Rd. Mississauga 905- 555-1093 $ 59.38
 Unit Selling Price Sales Revenue
$ 56.99 $ 227.96
$ 59.39 $ 950.30
$ 85.06 $ 850.58
$ 93.18 $ 372.72 1
$ 105.15 $ 210.29
$ 62.66 $ 375.97
$ 60.05 $ 240.21
$ 76.78 $ 767.77 2
$ 42.41 $ 254.43
$ 61.71 $ 246.85
$ 62.66 $ 125.32
$ 127.19 $ 763.16
$ 56.99 $ 227.96
$ 85.06 $ 170.12
$ 102.97 $ 205.93
$ 116.51 $ 466.06
$ 127.19 $ 1,017.55
$ 49.58 $ 595.01
$ 62.66 $ 125.32
$ 71.55 $ 286.19
$ 56.99 $ 227.96
$ 61.71 $ 246.85
$ 58.49 $ 116.98
$ 127.19 $ 763.16
$ 116.51 $ 233.03
$ 49.58 $ 99.17
$ 49.58 $ 99.17
$ 76.78 $ 460.66
$ 62.66 $ 250.64
$ 39.48 $ 78.96
$ 26.68 $ 26.68
$ 80.74 $ 484.43
$ 74.37 $ 594.93
$ 75.76 $ 303.05
$ 3.59 $ 14.36
$ 131.69 $ 526.77
$ 42.41 $ 254.43
$ 93.18 $ 745.44
$ 97.70 $ 195.39
$ 56.46 $ 451.70
$ 121.34 $ 121.34
$ 101.76 $ 203.53
$ 84.11 $ 168.22
$ 74.37 $ 446.20
$ 34.32 $ 68.64
$ 39.48 $ 236.87
$ 67.16 $ 268.63
$ 3.59 $ 14.36
$ 75.76 $ 454.58
$ 115.94 $ 695.66
$ 112.24 $ 1,122.37
$ 112.24 $ 897.89
$ 154.95 $ 619.80
$ 101.74 $ 406.98
$ 80.74 $ 484.43
$ 142.35 $ 569.41
$ 34.32 $ 68.64
$ 39.48 $ 118.44
$ 131.69 $ 526.77
$ 103.59 $ 621.54
$ 155.77 $ 623.08
$ 15.18 $ 30.35
$ 121.34 $ 242.69
$ 101.87 $ 407.50
$ 34.32 $ 34.32
$ 49.48 $ 49.48
$ 136.40 $ 545.60
$ 75.76 $ 151.53
$ 101.74 $ 610.47
$ 15.94 $ 127.54
$ 112.24 $ 448.95
$ 154.95 $ 929.70
$ 121.34 $ 121.34
$ 97.70 $ 97.70
$ 142.35 $ 569.41
$ 103.59 $ 414.36
$ 3.59 $ 3.59
$ 39.48 $ 78.96
$ 39.48 $ 39.48
$ 131.69 $ 131.69
$ 84.11 $ 84.11
$ 101.76 $ 203.53
$ 126.19 $ 126.19
$ 142.35 $ 569.41
$ 101.76 $ 101.76
$ 121.34 $ 242.69
$ 101.76 $ 203.53
$ 126.19 $ 126.19
$ 142.35 $ 284.71
$ 3.59 $ 3.59
$ 80.74 $ 484.43
$ 121.34 $ 242.69
$ 97.70 $ 586.18
$ 142.35 $ 854.12
$ 39.48 $ 39.48
$ 131.69 $ 263.39
$ 112.24 $ 448.95
$ 74.37 $ 148.73
$ 11.58 $ 23.17
$ 154.95 $ 619.80
$ 127.19 $ 254.39
$ 102.97 $ 205.93
$ 49.58 $ 198.34
$ 59.39 $ 118.79
$ 116.51 $ 466.06
$ 58.49 $ 350.95
$ 71.55 $ 286.19
 Questions

Create a Pivot Table and Chart to display total Sales Revenue by Customer
Name.
Highlight the highest in both chart and table.
Calculate the % of grand total. Add Customer Name slicers.

Create a Pivot Table and Chart to calculate average Unit Cost by Product ID.
Which product has the highest average unit cost?

ANSWERS FOUND IN PTCS1 and PTCS2 worksheets

Row Labels Sum of Sales Revenue Sum of Sales Revenue2
Damon Family $ 2,522 7.01%
Great Falls Gifts $ 2,241 6.23%
This shape represents a
Jicarilla Trading Post $ 2,170 6.03% slicer. Slicers are supported
San Albino Office Supply $ 1,904 5.29% in Excel 2010 or later.
Folk Art Today $ 1,812 5.04%
Chiricahua Gallery $ 1,733 4.82% If the shape was modified in
an earlier version of Excel,
Debois Manufacturing $ 1,658 4.61% or if the workbook was saved
Hillary's Hideout $ 1,534 4.26% in Excel 2003 or earlier, the
Natalie's $ 1,499 4.17% slicer cannot be used.
Eastern Manufacturing $ 1,430 3.98%
Rio Picacho Country Club $ 1,414 3.93%
Bon Vivant $ 1,394 3.88%
Marianne's $ 1,252 3.48%
Franklins $ 1,206 3.35%
Emerson & Son $ 1,157 3.22%
Johnston King $ 1,090 3.03%
Corrugated $ 1,049 2.92%
Kimball's Office Supplies $ 1,024 2.85%
La Isla Trading $ 986 2.74%
Garbo's Goodies $ 887 2.47%
Sunland Hot Springs Resort $ 874 2.43%
Consolidated $ 775 2.15%
Albert's Retail $ 748 2.08%
Black Crystal Lodge $ 697 1.94%
Cimarron Gifts $ 655 1.82%
Tormiga Inc. $ 578 1.61%
Inflections $ 466 1.30%
Romeo and Juliet Inc. $ 462 1.28%
Copper Mountain Inn $ 429 1.19%
Village Office Supplies $ 318 0.88%
Grand Total $ 35,963 100.00%
 Create a Pivot Table and Chart to display total Sales Revenue by Customer Name.
Highlight the highest in both chart and table.
Calculate the % of grand total.
This shape represents a Add a Customer Name slicer.
slicer. Slicers are supported
in Excel 2010 or later.

If the shape was modified in

an earlier version of Excel,
or if the workbook was saved $40,000
in Excel 2003 or earlier, the
slicer cannot be used. $35,000

$30,000

$25,000

$20,000

$15,000

$10,000

$5,000

$-
ily st ay 's 's rt l ns
in
g
lie ub ne So
n ed ng so ai fts In
n t
m Po od ur a Cl n at di e et Gi tio n To
Fa i ng tr T ct a t try
ri a n
&
ru g
T ra R s R
on e c ta i d
on ad kA uf
a N un a so Co
r a gs rt' ar
r In
fl
ou
n an
m Tr ol an Co M er Is l p rin l be i m M Gr
a a F o m La A
D
ril
l sM ch E tS C er
iJ ca boi i ca Ho opp
De P d C
Ri
o an
unl
S
nue by Customer Name.

Sum of Sales Revenue

Sum of Sales Revenue2

rt l ns al
so ta
i fts In
n
ot
e Gi tio i n T
sR n
fle
c
nt
a nd
er
t' rro In ra
lb m
a ou G
Ci rM
p pe
Co
Row Labels Average of Unit Cost
OFC024 94.26
PCB436 94.16
CNT343 92
LCW123 91.25
FAB675 88.62
PCC903 88.13
LFD755 86.34
100
QNA555 84.48
CCC921 81.38
90
PCC732 80.68
MCA593 79.51
80
PER499 76.26
SWC998 75.09
70
TCL544 73.28
CMB773 71.97
60
MBT657 69.03
PCB103 67.21
SHT477 59.38 50

TAA120 57.27
ARW344 53.7 40

CCB543 53.08
CRS699 52.95 30
VNY377 50.88
UPH444 48.45 20
CHQ232 48.12
PCA903 46.68 10
SOW664 40.52
VFD743 40.46 0
LAD346 39.72 24 43 75 55 21 93 998
F C0 NT3 AB6 FD7 CC9 CA5 C
DOC488 39.5 O C F L C M SW
DOW872 39.41
CNT888 39.09
LOD288 37.43
CRV365 36.4
BUT654 35.02
ARR798 32.76
CCD582 31.66
MFC490 31.43
CED678 22.23
HBL657 16.69
PFC326 10.98
TCA621 10.55
MOC993 9.21
CEC467 3.57
Grand Total 56.1763551401869
 Create a Pivot Table and Chart to calculate average Unit Cost by Product ID.
Which product has the highest average unit cost?

Average Unit Cost

0

0 Average of Unit Cost

0
l
24 43 75 55 21 93 998 773 103 120 543 377 232 664 346 872 288 654 582 678 326 993 ota
C0 NT3 AB6 FD7 CC9 CA5 C B B A B Y Q W LA D W D T D D C C T
C F L C S W CM PC TA CC VN CH S O DO LO BU CC CE PF MO d
M an
Gr
 Average of Unit Cost

l
ta
To
d