Weighted Average Help!

K

kface

New Member
Joined
Oct 2, 2011
Messages
8
<TABLE style="WIDTH: 392pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=525><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=7 width=75><TBODY><TR style="HEIGHT: 22.5pt" height=30><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 168pt; HEIGHT: 22.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl63 height=30 width=225 colSpan=3>Chemistry 303</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=75></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl64 height=20 colSpan=2>First Semester Scores</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" height=20 colSpan=2>Posted: December 20th</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #daeef3; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=20>Students</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #c4d79b; HEIGHT: 90pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl80 height=120 rowSpan=6>Class Summary</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dce6f1; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69>Exam</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dce6f1; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70>Weight</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dce6f1; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70>Median</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dce6f1; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70>Maximum</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dce6f1; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70>Minimum</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #dce6f1; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70>Range</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl71 height=20>Exam 1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl72 align=right>20%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl71 height=20>Exam 2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl72 align=right>20%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl71 height=20>Exam 3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl72 align=right>20%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl71 height=20>Final Exam</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl72 align=right>40%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl75></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl73 height=20>Overall</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl74 align=right>100%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl76></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl76></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl76></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl76></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl64 height=20 colSpan=2>Student Scores</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc7ce; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81 colSpan=2>Top Ten Overall Scores</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #daeef3; HEIGHT: 15pt; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl67 height=20>Student ID</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl78>Exam 1</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl78>Exam 2</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl78>Exam 3</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl79>Final Exam</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #daeef3; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl79>Overall</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-120-2</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>100.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>83.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>79.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>72.0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-267-4</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>84.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>80.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-299-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>55.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>56.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>47.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>65.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-354-3</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>95.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>93.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-423-5</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>83.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>76.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>77.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-433-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>52.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>66.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>61.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>53.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-452-0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>85.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-485-7</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>89.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>78.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>80.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-648-6</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>92.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>89.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>97.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>390-699-6</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>74.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>75.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>47.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>64.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-260-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>96.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>96.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-273-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>69.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>74.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>81.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>74.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-315-1</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>89.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>70.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-373-1</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>100.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>86.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>93.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-383-6</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>93.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>90.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>95.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>80.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-500-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>78.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>89.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>81.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>88.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-642-7</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>74.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>81.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>83.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>86.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-865-0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>88.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>71.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>84.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>81.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-926-7</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>90.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>97.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>97.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>391-928-5</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>83.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>71.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>62.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-248-7</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>72.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>70.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>88.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>77.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-302-1</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>83.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>76.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>81.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>80.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-363-7</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>89.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>72.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>77.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>73.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-475-2</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>100.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>96.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>90.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>99.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-539-3</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>95.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>96.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>85.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-709-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>72.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>49.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>60.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>51.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-798-4</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>61.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>70.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>61.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>392-834-1</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>71.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>64.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>70.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-181-6</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>76.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>69.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>58.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>70.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-254-4</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>90.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>76.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>71.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-287-6</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>84.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>85.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>66.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>74.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-332-3</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>96.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>88.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>93.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-411-8</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>80.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>74.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>75.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-440-4</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>86.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>85.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>85.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>82.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-552-0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>100.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>96.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #ebf1de; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl68 height=20>393-792-5</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>78.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>60.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 align=right>70.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR></TBODY></TABLE>

I am trying to get the weighted average but having alot of trouble. I need to do it for the first student then auto fill the rest
 
Last edited:

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Ooops i need to find the weighted average for the first student then auto fill the rest i have having much trouble thanks!
 
Upvote 0
Code: 
      --A--- --B-- --C-- --D-- --E-- ---F--- ---------------G---------------
  1   Weight   20%   20%   20%   40%                                        
  2          Exam1 Exam2 Exam3 Final Average                                
  3   Alan     100    83    79    72    81.2 F3: =SUMPRODUCT(B$1:E$1, B3:E3)
  4   Barb      84    91    94    80    85.8
 
Upvote 0
If you lay out the weights in an horizontal manner (so 4 cells next to each other in 1 row), you could use for instance (depends on the cells you use):

=SUMPRODUCT(A5:D5,$A$1:$D$1)

A5:D5 stands for the points of student 1, the other range is the weights.
 
Upvote 0
Ok so C8 - C11 is the weights and B17 - E17 are the exam scores in the sheet i posted
 
Upvote 0
kface said:
Ok so C8 - C11 is the weights
Click to expand...

If you understood correctly what I and Stephen were saying, you should use a horizontal range of cells for the weights? That would make your life easier since you can use just 1 formula.

You could also opt for the same layout of cells, but then the formula is more advanced.
 
Upvote 0
Given that the ranges should not be changed, and given that this is your assignment rather than the assignment for the board: use the SUMPRODUCT formula as explained above, combined with the TRANSPOSE formula. It will then be an array function so you need to confirm it with Ctrl-Shift-Enter and not just Enter.
 
Upvote 0
Well this is what I came up with. =SUMPRODUCT(TRANSPOSE(C8:C11),(B17:E17)) with ctrl shift ent, and it does the first students average right. But now I can't seem to auto fill the rest of the students.
 
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
328
VBAEXCELNew
V
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
849
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
E
  • Question
VBA for Web Scraping help
Replies
0
Views
602
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,215,375
Messages
6,124,589
Members
449,174
Latest member
chandan4057

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top