Sheet:DVD List DVD Collection Leanne Szela
NUM TITLE RELEASE STUDIO RANK RATING COST MIN Genre
7 Monsters, Inc. 2001 Pixar 4 G $ 19.99 92 Animation
21 Finding Nemo 2003 Pixar 5 G $ 19.99 100 Animation
4 Hairspray 2007 New Line Cinema 5 PG $ 13.99 117 Musical
6 Freaky Friday 2003 Disney 4 PG $ 19.99 97 Comedy
15 Shrek 2 2004 Dreamworks 3 PG $ 19.99 93 Animation
16 Shrek the Third 2007 Paramount 4 PG $ 19.99 93 Animation
19 National Treasure 2004 Disney 5 PG $ 25.00 131 Action
National Tresure: Book of
20 Secrets 2007 Disney 5 PG $ 19.99 124 Action
1 The Longest Yard 2005 Paramount 5 PG-13 $ 25.00 113 Comedy
2 The Bourne Identity 2002 Universal 4 PG-13 $ 10.00 119 Action
3 The Bourne Ultimatum 2007 Universal 5 PG-13 $ 25.00 115 Action
5 Live Free or Die Hard 2007 20th Century Fox 5 PG-13 $ 25.00 130 Action
8 The Benchwarmers 2006 Sony 5 PG-13 $ 19.99 80 Comedy
9 Batman Begins 2005 Warner Bros. 5 PG-13 $ 25.00 140 Action
10 Sydney White 2007 Universal 4 PG-13 $ 19.99 108 Comedy
11 White Chicks 2004 Sony 5 PG-13 $ 25.00 109 Comedy
12 School of Rock 2003 Paramount 4 PG-13 $ 19.99 108 Comedy
Pirates of the Carribean:
13 Curse of the Black Pearl 2003 Disney 5 PG-13 $ 25.00 143 Action
Pirates of the Carribean:
14 Dead Man's Chest 2006 Disney 4 PG-13 $ 25.00 150 Action
17 Just my Luck 2006 20th Century Fox 3 PG-13 $ 15.99 103 Comedy
18 I, Robot 2004 20th Century Fox 5 PG-13 $ 25.00 115 Action
22 John Tucker Must Die 2006 20th Century Fox 4 PG-13 $ 19.99 89 Comedy
Value of
DVDs $ 464.88
AVG
length of
movie 112.23
Min take
to watch
all 2469
Hrs take
to watch
all 41.15
Day take
to watch
all 1.71
File: 1195cd7e-221e-4a3c-8d50-71722447bd5f.xlsx Page: 1 of 11 Date printed: 11/2/2011
Sheet: Pivot Table Pivot Table Leanne Szela
Genre (All)
Sum of COST Column Labels
Row Labels G PG PG-13 Grand Total
Batman Begins 25 25
Finding Nemo 19.99 19.99
Freaky Friday 19.99 19.99
Hairspray 13.99 13.99
I, Robot 25 25
John Tucker Must Die 19.99 19.99
Just my Luck 15.99 15.99
Live Free or Die Hard 25 25
Monsters, Inc. 19.99 19.99
National Treasure 25 25
National Tresure: Book of Secrets 19.99 19.99
Pirates of the Carribean: Curse of the Black Pearl 25 25
Pirates of the Carribean: Dead Man's Chest 25 25
School of Rock 19.99 19.99
Shrek 2 19.99 19.99
Shrek the Third 19.99 19.99
Sydney White 19.99 19.99
The Benchwarmers 19.99 19.99
The Bourne Identity 10 10
The Bourne Ultimatum 25 25
The Longest Yard 25 25
White Chicks 25 25
Grand Total 39.98 118.95 305.95 464.88
P
File: 1195cd7e-221e-4a3c-8d50-71722447bd5f.xlsx age: 2 of 11 Date Printed: 11/2/2011
Sheet: Subtotal rating Subtotal Example Leanne Szela
NUM TITLE RELEASE STUDIO RANK RATING COST MIN
7 Monsters, Inc. 2001 Pixar 4G $ 19.99 92
21 Finding Nemo 2003 Pixar 5G $ 19.99 100
G Count 2
4 Hairspray 2007 New Line Cinema 5 PG $ 13.99 117
6 Freaky Friday 2003 Disney 4 PG $ 19.99 97
15 Shrek 2 2004 Dreamworks 3 PG $ 19.99 93
16 Shrek the Third 2007 Paramount 4 PG $ 19.99 93
19 National Treasure 2004 Disney 5 PG $ 25.00 131
National Tresure: Book of
20 Secrets 2007 Disney 5 PG $ 19.99 124
PG Count 6
1 The Longest Yard 2005 Paramount 5 PG-13 $ 25.00 113
2 The Bourne Identity 2002 Universal 4 PG-13 $ 10.00 119
3 The Bourne Ultimatum 2007 Universal 5 PG-13 $ 25.00 115
5 Live Free or Die Hard 2007 20th Century Fox 5 PG-13 $ 25.00 130
8 The Benchwarmers 2006 Sony 5 PG-13 $ 19.99 80
9 Batman Begins 2005 Warner Bros. 5 PG-13 $ 25.00 140
10 Sydney White 2007 Universal 4 PG-13 $ 19.99 108
11 White Chicks 2004 Sony 5 PG-13 $ 25.00 109
12 School of Rock 2003 Paramount 4 PG-13 $ 19.99 108
Pirates of the Carribean:
13 Curse of the Black Pearl 2003 Disney 5 PG-13 $ 25.00 143
Pirates of the Carribean:
14 Dead Man's Chest 2006 Disney 4 PG-13 $ 25.00 150
17 Just my Luck 2006 20th Century Fox 3 PG-13 $ 15.99 103
18 I, Robot 2004 20th Century Fox 5 PG-13 $ 25.00 115
22 John Tucker Must Die 2006 20th Century Fox 4 PG-13 $ 19.99 89
PG-13 Count 14
Grand Count 22
File: 1195cd7e-221e-4a3c-8d50-71722447bd5f.xlsx Page: 3 of 11 Date Printed: 11/2/2011
Sheet: Subtotal rating Subtotal Example Leanne Szela
Genre
Animation
Animation
Musical
Comedy
Animation
Animation
Action
Action
Comedy
Action
Action
Action
Comedy
Action
Comedy
Comedy
Comedy
Action
Action
Comedy
Action
Comedy
File: 1195cd7e-221e-4a3c-8d50-71722447bd5f.xlsx Page: 4 of 11 Date Printed: 11/2/2011
Rating
9%
27%
G Count
PG Count
PG-13 Count
64%
NUM TITLE RELEASE STUDIO RANK RATING COST
2 The Bourne Identity 2002 Universal 4 PG-13 $ 10.00
3 The Bourne Ultimatum 2007 Universal 5 PG-13 $ 25.00
5 Live Free or Die Hard 2007 20th Century Fox 5 PG-13 $ 25.00
9 Batman Begins 2005 Warner Bros. 5 PG-13 $ 25.00
Pirates of the Carribean:
13 Curse of the Black Pearl 2003 Disney 5 PG-13 $ 25.00
Pirates of the Carribean:
14 Dead Man's Chest 2006 Disney 4 PG-13 $ 25.00
18 I, Robot 2004 20th Century Fox 5 PG-13 $ 25.00
19 National Treasure 2004 Disney 5 PG $ 25.00
National Tresure: Book of
20 Secrets 2007 Disney 5 PG $ 19.99
7 Monsters, Inc. 2001 Pixar 4 G $ 19.99
15 Shrek 2 2004 Dreamworks 3 PG $ 19.99
16 Shrek the Third 2007 Paramount 4 PG $ 19.99
21 Finding Nemo 2003 Pixar 5 G $ 19.99
1 The Longest Yard 2005 Paramount 5 PG-13 $ 25.00
6 Freaky Friday 2003 Disney 4 PG $ 19.99
8 The Benchwarmers 2006 Sony 5 PG-13 $ 19.99
10 Sydney White 2007 Universal 4 PG-13 $ 19.99
11 White Chicks 2004 Sony 5 PG-13 $ 25.00
12 School of Rock 2003 Paramount 4 PG-13 $ 19.99
17 Just my Luck 2006 20th Century Fox 3 PG-13 $ 15.99
22 John Tucker Must Die 2006 20th Century Fox 4 PG-13 $ 19.99
4 Hairspray 2007 New Line Cinema 5 PG $ 13.99
MIN Genre
119 Action
115 Action
130 Action
140 Action
143 Action
150 Action
115 Action
131 Action
124 Action
Action Count 9
92 Animation
93 Animation
93 Animation
100 Animation
Animation Count 4
113 Comedy
97 Comedy
80 Comedy
108 Comedy
109 Comedy
108 Comedy
103 Comedy
89 Comedy
Comedy Count 8
117 Musical
Musical Count 1
Grand Count 22
Genre
5%
41%
36% Action Count
Animation Count
Comedy Count
Musical Count
18%
NUM TITLE RELEASE STUDIO RANK RATING COST
8 The Benchwarmers 2006 Sony 5 PG-13 $ 19.99
22 John Tucker Must Die 2006 20th Century Fox 4 PG-13 $ 19.99
7 Monsters, Inc. 2001 Pixar 4 G $ 19.99
15 Shrek 2 2004 Dreamworks 3 PG $ 19.99
16 Shrek the Third 2007 Paramount 4 PG $ 19.99
6 Freaky Friday 2003 Disney 4 PG $ 19.99
21 Finding Nemo 2003 Pixar 5 G $ 19.99
17 Just my Luck 2006 20th Century Fox 3 PG-13 $ 15.99
10 Sydney White 2007 Universal 4 PG-13 $ 19.99
12 School of Rock 2003 Paramount 4 PG-13 $ 19.99
11 White Chicks 2004 Sony 5 PG-13 $ 25.00
1 The Longest Yard 2005 Paramount 5 PG-13 $ 25.00
3 The Bourne Ultimatum 2007 Universal 5 PG-13 $ 25.00
18 I, Robot 2004 20th Century Fox 5 PG-13 $ 25.00
4 Hairspray 2007 New Line Cinema 5 PG $ 13.99
2 The Bourne Identity 2002 Universal 4 PG-13 $ 10.00
National Tresure: Book of
20 Secrets 2007 Disney 5 PG $ 19.99
5 Live Free or Die Hard 2007 20th Century Fox 5 PG-13 $ 25.00
19 National Treasure 2004 Disney 5 PG $ 25.00
9 Batman Begins 2005 Warner Bros. 5 PG-13 $ 25.00
Pirates of the Carribean:
13 Curse of the Black Pearl 2003 Disney 5 PG-13 $ 25.00
Pirates of the Carribean:
14 Dead Man's Chest 2006 Disney 4 PG-13 $ 25.00
or= 150min 1
MIN Genre
80 Comedy
89 Comedy
92 Animation
93 Animation
93 Animation
97 Comedy
100 Animation
103 Comedy
108 Comedy
108 Comedy
109 Comedy
113 Comedy
115 Action
115 Action
117 Musical
119 Action
124 Action
130 Action
131 Action
140 Action
143 Action
150 Action
Length of movie
4%
9%
23%
or= 150min
64%