Logarithmic trendline values

AlisaA

Board Regular
Joined
Mar 17, 2010
Messages
193
I have created a chart in excel in which I have created a logarithmic trendline. I am wanting to find out what the Y values of the trendline are. In other words, I have my current Y values that generated the trendline, but I want to know what the Y values of the actual trendline are. If I was using a linear trendline, it would be very simple, but I am drawing a blank with the logarithmic trendline formula.

When I use the equations from:

http://spreadsheetpage.com/index.php...line_formulas/

This just gives me the Y values I already have for the X values I have. I want to know what those values SHOULD have been, if the data was plotted along the trendline. In other words, some of my points are above, some below, some right on. I'd like to know what the actual line values are themselves.

The trendline equation is Y = -8735ln(x) + 64086. Is there a way I can put that into an excel formula using the X values I have to generate the proper Y values?

I've searched many threads & sites for this, and I am stumped!! Thank you so much for your help!!
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Hi,

Is this what your looking for:
Excel Workbook
AB
1X ValuesY values
2164086
3258031.36
4354489.62
Sheet1
Excel 2010
Cell Formulas
RangeFormula
B2=(-8735*LN(A2))+64086
 
Upvote 0
Unfortunately, no. The numbers I get using the formula that way do not come close to what would appear to be the trendline values.
 
Upvote 0
Are you sure that is the correct trendline equation? Perhaps post your data and a sample of what you get and what your expecting?
 
Upvote 0
Yes, that is the exact formula that shows up in the graph:

y = -8735ln(x) + 60486

These are the values I am plotting:

Code:
<TABLE style="WIDTH: 190pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=253><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" span=2 width=89><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #fcd5b4; WIDTH: 56pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl154 height=17 width=75>[B][FONT=Arial][SIZE=2]Unit[/SIZE][/FONT][/B]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fcd5b4; WIDTH: 67pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl155 width=89>[B][FONT=Arial][SIZE=2]Sales[/SIZE][/FONT][/B]</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fcd5b4; WIDTH: 67pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl155 width=89>[B][FONT=Arial][SIZE=2]Hours[/SIZE][/FONT][/B]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 1[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$7,273,825 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]62,595 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 2[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$6,656,787 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]52,163 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 3[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$5,337,316 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]43,794 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 4[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$5,087,128 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]42,321 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 5[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$5,055,680 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]45,891 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 6[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$4,959,810 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]41,475 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 7[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$4,806,729 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]45,610 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 8[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$4,790,981 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]53,546 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 9[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$4,203,503 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]33,526 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 10[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,999,399 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]47,299 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 11[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,938,750 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]43,598 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 12[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,719,832 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]39,017 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 13[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,650,970 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]33,660 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 14[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,647,815 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]38,741 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 15[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,521,094 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]38,562 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 16[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,436,058 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]33,772 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 17[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,430,253 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]36,632 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 18[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,365,253 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]40,297 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 19[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,342,017 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]39,469 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 20[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,255,440 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]37,853 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 21[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,174,408 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,262 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 22[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,170,647 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,016 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 23[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,137,885 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,985 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 24[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,134,615 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]40,542 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 25[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,048,040 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]33,816 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 26[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$3,042,310 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]32,653 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 27[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,982,921 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]34,631 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 28[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,885,253 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]28,956 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 29[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,855,548 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]37,132 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 30[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,852,670 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,872 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 31[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,852,665 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]31,933 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 32[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,822,937 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,391 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 33[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,799,093 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]31,107 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 34[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,756,278 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]31,500 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 35[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,711,666 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,301 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 36[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,705,832 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]27,339 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 37[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,661,113 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]33,249 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 38[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,658,855 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]30,126 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 39[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,626,082 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]28,691 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 40[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,622,317 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]25,882 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 41[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,616,668 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]25,007 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 42[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,613,555 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]29,933 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 43[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,542,314 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]24,872 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 44[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,541,608 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]27,193 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 45[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,518,123 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]27,097 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 46[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,412,946 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]22,439 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 47[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,380,007 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]23,755 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 48[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,378,590 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]21,496 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 49[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,359,895 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]26,005 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 50[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,347,241 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]25,080 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 51[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,343,366 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]23,945 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 52[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,294,063 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]21,970 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 53[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,261,273 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]24,914 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 54[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,257,064 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]18,539 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 55[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,244,677 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]24,403 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 56[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,241,971 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]32,976 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 57[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,234,725 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]22,255 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 58[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,227,275 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]31,213 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 59[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,227,240 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]22,430 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 60[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,223,533 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]26,444 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 61[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,177,745 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]21,999 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 62[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,114,622 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]24,874 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 63[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,035,390 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]21,930 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 64[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,027,466 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]28,188 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 65[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,025,927 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]25,330 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 66[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$2,006,806 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]26,491 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 67[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,992,605 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]23,432 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 68[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,954,544 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]23,568 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 69[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,937,080 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]26,307 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 70[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,927,276 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]22,325 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 71[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,878,988 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]26,972 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 72[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,679,232 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]20,238 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 73[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,609,944 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]17,302 [/SIZE][/FONT]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #95b3d7 0.5pt solid; BORDER-LEFT: #95b3d7 0.5pt solid; BACKGROUND-COLOR: #dce6f1; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #95b3d7 0.5pt solid" class=xl153 height=17>[FONT=Arial][SIZE=2]Unit 74[/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl151 align=right>[FONT=Arial][SIZE=2]$1,478,986 [/SIZE][/FONT]</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl152 align=right>[FONT=Arial][SIZE=2]22,392 [/SIZE][/FONT]</TD></TR></TBODY></TABLE>

As an example, according to the trendline in the chart, the line height at Unit 5 appears to be 45,900, Unit 12 appears to be 39,000, Unit 74 appears to be 22,400. If I use the trendline formula as-is, with each of the Sales values as my X, I get negative numbers that are all -60000 to -74000. I know I must be doing something wrong, but I can't figure out what it must be! Thanks a ton for your help!!
 
Last edited:
Upvote 0
Hi again,

You need to ensure your sales numbers are actual numbers - remove the dollar signs and re-plot. Add the logarithmic trendline and you should get something like:

y = 24865ln(x) - 337875

and the formula

=(24865*LN(A2))-337875

where A2 is hours should give you the values you expect.
 
Upvote 0

Forum statistics

Threads
1,216,146
Messages
6,129,125
Members
449,488
Latest member
qh017

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