Formula needed for chart scaling

pagrender

Well-known Member
Joined
Sep 3, 2008
Messages
652
Hello all,

Recently, I have posted a question to find how to link a chart's scaling to a cell. I was able to find my answers with this post: http://www.mrexcel.com/forum/showthread.php?t=497507 I consider that part of this process complete as the VB code works.

I have a new issue I was hoping I could get some help with. Cells F2, F3, and F4 are used for the scaling of the chart. I would like to come up with a logical way to make the calculation for the tick mark based on the maximum and minimum values of the chart. I hastily created a VLOOKUP formula and table for a short term solution based on the difference of the Max and Min values, but it does not work every time.

Here is an example of when it does not work: In the example below, my chart minimum is 1,500, max of 3,000, and the tick marks come in at every increment of 200. If I put tick marks at every 200 increment, my last tick mark will be at 2,900. Since I have data that exceeds this value (2,999 from the year 2006 is one example), my line chart looks strange as data exceeds the greatest "scaled" value.

Is there a better formula I can use? We can change my lookup table or replace the formula with one that works or both - just let me know.

Thanks,
Pete

Sheet1<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<TABLE class=MsoNormalTable style="BACKGROUND: white; mso-cellspacing: 0in; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 2.0pt 0in 2.0pt" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
A<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
B<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
C<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
D<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
E<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8">
F<o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
1<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">Actual Value<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">For Chart<o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
2<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1500<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">Max<o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2999<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
3000<o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
3<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
100<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
25<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">Min<o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1526<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1500<o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
4<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
25<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">Tick<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>

</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 5"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
5<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
300<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
25<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 6"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
6<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
400<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
25<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
Year<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
Amount<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 7"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
7<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
500<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
100<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2000<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2877<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 8"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
8<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
600<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
100<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2001<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2981<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 9"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
9<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
700<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
100<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2002<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2549<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 10"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
10<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
800<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
100<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2003<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2843<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 11"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
11<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
900<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
100<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2004<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2919<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 12"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
12<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1000<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2005<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2169<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 13"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
13<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1100<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2006<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2999<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 14"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
14<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1200<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2007<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1817<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 15"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
15<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1300<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2008<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2615<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 16"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
16<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1400<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2009<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1526<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 17"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
17<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1500<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2010<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2889<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 18"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
18<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1600<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 19"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
19<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1700<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 20"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
20<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1800<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 21"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
21<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
1900<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>
</TD></TR><TR style="HEIGHT: 13.5pt; mso-yfti-irow: 22; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt">
22<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
2000<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent">
200<o:p></o:p>


</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 2pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 2pt; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent"><o:p></o:p>

</TD></TR></TBODY></TABLE>​
<o:p></o:p>
<TABLE class=MsoNormalTable style="BORDER-RIGHT: lime 3pt groove; BORDER-TOP: lime 3pt groove; BACKGROUND: #fffcf9; BORDER-LEFT: lime 3pt groove; BORDER-BOTTOM: lime 3pt groove; mso-cellspacing: 1.5pt; mso-yfti-tbllook: 1184; mso-border-alt: three-d-engrave lime 3.0pt" cellPadding=0 border=1><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: lime; PADDING-RIGHT: 0.75pt; BORDER-TOP: lime; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: lime; PADDING-TOP: 0.75pt; BORDER-BOTTOM: lime; BACKGROUND-COLOR: transparent">Spreadsheet Formulas<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 1; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: lime; PADDING-RIGHT: 0.75pt; BORDER-TOP: lime; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; BORDER-LEFT: lime; PADDING-TOP: 0.75pt; BORDER-BOTTOM: lime; BACKGROUND-COLOR: transparent"><TABLE class=MsoNormalTable style="mso-cellspacing: 0in; mso-yfti-tbllook: 1184; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff">Cell<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; BACKGROUND: #cacaca; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff">Formula<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 1"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">A2<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">=F2-F3<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 2"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">E2<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">=MAX(E7:E17)<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 3"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">F2<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">=ROUNDUP(E2,-2)<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 4"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">E3<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">=MIN(E7:E17)<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 5"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">F3<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">=ROUNDDOWN(E3,-2)<o:p></o:p>

</TD></TR><TR style="mso-yfti-irow: 6; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">F4<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ffffff; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ffffff; PADDING-LEFT: 1.5pt; PADDING-BOTTOM: 1.5pt; BORDER-LEFT: #ffffff; PADDING-TOP: 1.5pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent">=VLOOKUP(A2,A3:B22,2,FALSE)<o:p></o:p>

</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Here is the VB code to adjust the scaling (this works fine, I just included it if someone want to reference it):
Sub ChangeAxisScales()
With ActiveSheet.ChartObjects("Chart 1").Chart

' Value (Y) Axis
With .Axes(xlValue)
.MaximumScale = ActiveSheet.Range("$F$2").Value
.MinimumScale = ActiveSheet.Range("$F$3").Value
.MajorUnit = ActiveSheet.Range("$F$4").Value
End With
End With
End Sub
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
I think the problem is that the Max and Min values for the chart don't take into account what the increment in F4 is.

In this example, the MIN value is not a multiple of the increment.
Here's one way to force it to be a multiple.
There may be better ways.
Code:
=rounddown(e2/f4,0)*f4
You would need to do something similar (but roundUP) for the Max value.
 
Upvote 0
Thanks Gerald. I ran into a circular reference, but changed some things (using your logic) to get around it and I think it works now.

I now use data in column G to go to the chart instead of column F.

In G2, I have =F2
In G3, I have =IF(MOD(A2,F4)=0,F3,F3-MOD(A2,F4))
In G4, I have =F4

While testing it, it seems to work. I hope subtracting the remainder from cell F3 will work out - it has so far!

Thanks for your suggestion.

Pete
 
Last edited:
Upvote 0
Gerald,

I was playing with your solution and got it to work. I like your solution better than mine so I'll go with yours.

Thanks again,
Pete
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

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