How to workout sales min and max period of the sold product

motilulla · Oct 3, 2010

Hi everybody,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
<o

></o

>
I have 100 of product. I want to work out there sales evolution period by Row or by sales date.<o

></o

>
<o

></o

>
Sheet1 Example sale sheet <o

></o

>
<TABLE style="WIDTH: 265pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm" border=0 cellSpacing=0 cellPadding=0 width=353><TBODY><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 28pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=37 noWrap>

*<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 83pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=111 noWrap>

A<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 154pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=205 noWrap>

C<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

Date of Sale<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

Sold Set Reference <o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

01/01/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

48<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

01/01/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

29<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

4<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

07/01/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

29<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

5<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

09/01/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

56<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

6<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

17/01/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

320<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

7<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

12/02/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1252<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

8<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

12/02/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2639<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

9<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

17/04/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

48<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

10<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

25/04/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1252<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

11<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

27/04/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1869<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

12<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

16/08/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

29<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

13<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

17/08/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2688<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

14<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

19/08/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

919<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

15<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

22/08/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1738<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

16<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

27/09/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

29<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

17<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

30/09/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3585<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

18<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

01/10/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1199<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

19<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

02/10/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1252<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

20<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

02/10/2010<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

48<o></o>

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

Sheet2 Reference table of the sets Expected result option-1 (Sale period result by row)<o

></o

>
<TABLE style="WIDTH: 458pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm" border=0 cellSpacing=0 cellPadding=0 width=611><TBODY><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 28pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=37 noWrap>

*<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 119pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=159 noWrap>

A<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 154pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=205 noWrap>

C<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 157pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=209 noWrap>

D<o></o>

</TD></TR><TR style="HEIGHT: 30.75pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 119pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" width=159>

Reference Table Of the sets<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 154pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" width=205>

Minimum time period to sold by Row<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 157pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" width=209>

Maximum time period to sold by Row<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

110<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

29<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

8<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

4<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

320<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

5<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

48<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

7<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

11<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

6<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

56<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

7<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

622<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

8<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

753<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

9<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

919<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

10<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1011<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

11<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1115<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

12<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1199<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

13<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1252<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

9<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

14<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1738<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

15<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1832<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

16<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1869<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

17<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2458<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

18<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2639<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

19<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2688<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

20<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3585<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

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

></o

>
Sheet3 Reference table of the sets Expected result option-2 (Sale Period result by date)<o

></o

>
<TABLE style="WIDTH: 458pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm" border=0 cellSpacing=0 cellPadding=0 width=611><TBODY><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 28pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=37 noWrap>

*<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 119pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=159 noWrap>

A<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 154pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=205 noWrap>

C<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 157pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom width=209 noWrap>

D<o></o>

</TD></TR><TR style="HEIGHT: 30.75pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 119pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" width=159>

Reference Table Of the sets<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 154pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" width=205>

Minimum time period to sold by Date (Days)<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; WIDTH: 157pt; PADDING-RIGHT: 0.75pt; BACKGROUND: yellow; HEIGHT: 30.75pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" width=209>

Maximum time period to sold by Date (Days)<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

110<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

29<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

6<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: navy; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

221<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

4<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

320<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

5<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

48<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

106<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: red; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

168<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

6<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

56<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

7<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

622<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

8<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

753<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

9<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

919<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

10<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1011<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

11<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1115<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

12<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1199<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

13<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1252<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

72<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: green; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

160<o></o>

</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

14<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1738<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

15<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1832<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

16<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

1869<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

17<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2458<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

18<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2639<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

19<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

2688<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD></TR><TR style="HEIGHT: 15pt"><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; BACKGROUND: silver; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

20<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap>

3585<o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

>
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #d4d0c8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt" vAlign=bottom noWrap> <o

></o

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

></o

>
<o

></o

>
Sheet1 is the sale sheet <o

></o

>
Sheet2 is Reference table of the sets with Expected result option-1 (Sale period result by row)<o

></o

>
Sheet3 is Reference table of the sets with Expected result option-2 (Sale Period result by date)<o

></o

>
<o

></o

>
Please help if it is possible to get result with both options. If not then any of 1-option will be fine.<o

></o

>
<o

></o

>
Thanks And Regards<o

></o

>
Moti<o

></o

>

shift-del · Oct 3, 2010

Hello Moti

The formula is quite long, but it works.

<table valign="middle" colspan="7" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: bold; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="90pt"><col width="120pt"><col width="60pt"><col width="135pt"><col width="214,5pt"><col width="216pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="7" align="middle">Arbeitsblatt mit dem Namen 'Tabelle2'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td><td align="middle">C</td><td align="middle">D</td><td align="middle">E</td><td align="middle">F</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td style="background-color: rgb(255, 255, 0);" align="left">Date of Sale</td><td style="background-color: rgb(255, 255, 0);" align="left">Sold Set Reference</td><td align="right">
</td><td align="left">Reference Table Of the sets</td><td align="left">Minimum time period to sold by Date (Days)</td><td align="left">Maximum time period to sold by Date (Days)</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td style="color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);" align="right">01.01.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);" align="right">48</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">29</td><td style="font-weight: normal;" align="right">6</td><td style="font-weight: normal;" align="right">221</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">01.01.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">29</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">48</td><td style="font-weight: normal;" align="right">106</td><td style="font-weight: normal;" align="right">168</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">07.01.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">29</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">56</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td align="right">09.01.2010</td><td align="right">56</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">110</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">6</td><td align="right">17.01.2010</td><td align="right">320</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">320</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">7</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 128, 0);" align="right">12.02.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 128, 0);" align="right">1252</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">622</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">8</td><td align="right">12.02.2010</td><td align="right">2639</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">753</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">9</td><td style="color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);" align="right">17.04.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);" align="right">48</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">919</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">10</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 128, 0);" align="right">25.04.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 128, 0);" align="right">1252</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1011</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">11</td><td align="right">27.04.2010</td><td align="right">1869</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1115</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">12</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">16.08.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">29</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1199</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">13</td><td align="right">17.08.2010</td><td align="right">2688</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1252</td><td style="font-weight: normal;" align="right">72</td><td style="font-weight: normal;" align="right">160</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">14</td><td align="right">19.08.2010</td><td align="right">919</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1738</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">15</td><td align="right">22.08.2010</td><td align="right">1738</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1832</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">16</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">27.09.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 0, 128);" align="right">29</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">1869</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">17</td><td align="right">30.09.2010</td><td align="right">3585</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">2458</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">18</td><td align="right">01.10.2010</td><td align="right">1199</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">2639</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">19</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 128, 0);" align="right">02.10.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(0, 128, 0);" align="right">1252</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">2688</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">20</td><td style="color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);" align="right">02.10.2010</td><td style="color: rgb(255, 255, 255); background-color: rgb(255, 0, 0);" align="right">48</td><td style="font-weight: normal;" align="right">
</td><td style="font-weight: normal;" align="right">3585</td><td style="font-weight: normal;" align="left">
</td><td style="font-weight: normal;" align="left">
</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout: fixed; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40pt"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Zelle</td><td>Formel</td></tr><tr><td>E2</td><td>{=IF(COUNTIF($B$2:$B$20,D2)<2,"",MIN(SMALL(IF(LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,-9^9),ROW($B$2:$B$19)-ROW($B$2)+1)-LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,0),ROW($B$3:$B$20)-ROW($B$3)+2)>0,LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,-9^9),ROW($B$2:$B$19)-ROW($B$2)+1)-LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,0),ROW($B$3:$B$20)-ROW($B$3)+2)),ROW(INDIRECT("E1:E"&COUNTIF($B$2:$B$20,D2)-1)))))}</td></tr><tr><td>F2</td><td>{=IF(COUNTIF($B$2:$B$20,D2)<2,"",MAX(SMALL(IF(LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,-9^9),ROW($B$2:$B$19)-ROW($B$2)+1)-LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,0),ROW($B$3:$B$20)-ROW($B$3)+2)>0,LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,-9^9),ROW($B$2:$B$19)-ROW($B$2)+1)-LARGE(IF($B$2:$B$20=D2,$A$2:$A$20,0),ROW($B$3:$B$20)-ROW($B$3)+2)),ROW(INDIRECT("E1:E"&COUNTIF($B$2:$B$20,D2)-1)))))}</td></tr></tbody></table><table style="font-family: Arial; font-size: 8pt; background-color: rgb(255, 255, 255);"><tbody><tr><td style="font-weight: bold;">Contains array formula!</td></tr><tr><td>Do not enter the curly brackets {}.</td></tr><tr><td>Enter the formula with CTRL-SHIFT-ENTER instead of just ENTER.
</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Created and displayed with Tab2HTML (v2.4.1). ©Gerd alias Bamberg</td></tr></tbody></table>

motilulla · Oct 3, 2010

Hi shift-del<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
<o

></o

>
I am very great full to you, for looking my request and really very Impressed that you have written a so long formula. I have tried with sample data option-2 and it is working perfect. Later I will try with my original long data sheet. <o

></o

>
<o

></o

>
Mean time I will wait for some one might suggest a formula for option-1, and may improve your formula in short form. Many thanks for your efforts.<o

></o

>
<o

></o

>
Thanks And Regards,<o

></o

>
Moti<o

></o

>

Domenic · Oct 4, 2010

For simplicity, let's assume the following...

1) A2:B20 contains the sales data.

2) D2:F20 contains the sales period result by row.

3) H2:J20 contains the sales period result by date.

Try...

E2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(COUNTIF($B$2:$B$20,D2)>1,MIN(MMULT(SMALL(IF($B$2:$B$20=D2,ROW($B$2:$B$20)),ROW(INDIRECT("2:"&COUNTIF($B$2:$B$20,D2)))-{0,1}),{1;-1})),"")

F2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(COUNTIF($B$2:$B$20,D2)>1,MAX(MMULT(SMALL(IF($B$2:$B$20=D2,ROW($B$2:$B$20)),ROW(INDIRECT("2:"&COUNTIF($B$2:$B$20,D2)))-{0,1}),{1;-1})),"")

I2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(COUNTIF($B$2:$B$20,H2)>1,MIN(MMULT(SMALL(IF($B$2:$B$20=H2,$A$2:$A$20),ROW(INDIRECT("2:"&COUNTIF($B$2:$B$20,H2)))-{0,1}),{1;-1})),"")

J2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(COUNTIF($B$2:$B$20,H2)>1,MAX(MMULT(SMALL(IF($B$2:$B$20=H2,$A$2:$A$20),ROW(INDIRECT("2:"&COUNTIF($B$2:$B$20,H2)))-{0,1}),{1;-1})),"")

motilulla · Oct 4, 2010

Hi Domenic, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
<o

></o

>
You are a brain<o

></o

>
<o

></o

>
I am extremely satisfied to obtain such a marvels solution for both option by you. And I have no word to say any thing about your fantastic solution. I have tried with my original data sheet and it is working just wonderful. <o

></o

>
<o

></o

>
Thanks And Regards,<o

></o

>
Moti<o

></o

>

How to workout sales min and max period of the sold product

motilulla

Well-known Member

shift-del

Well-known Member

motilulla

Well-known Member

Domenic

MrExcel MVP

motilulla

Well-known Member

Similar threads

Share this page

How to workout sales min and max period of the sold product

motilulla

Well-known Member

shift-del

Well-known Member

motilulla

Well-known Member

Domenic

MrExcel MVP

motilulla

Well-known Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock