Weighted Average Help!

[kface]

<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

 

[kface]

Ooops i need to find the weighted average for the first student then auto fill the rest i have having much trouble thanks!

 

[shg]

      --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

 

[wigi]

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.

 

[kface]

Ok so C8 - C11 is the weights and B17 - E17 are the exam scores in the sheet i posted

 

[wigi]

Ok so C8 - C11 is the weights

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.

 

[kface]

Yeah its an assignment I am working on so I can't change the layout

 

[wigi]

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.

 

[kface]

You're right it is my assignment to research how to complete thanks.

 

[kface]

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.