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

Excel Facts

shift-del

Well-known Member

motilulla

Well-known Member

Domenic

MrExcel MVP

motilulla

Well-known Member

Similar threads

Forum statistics

Share this page

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

motilulla

Well-known Member

Excel Facts

shift-del

Well-known Member

motilulla

Well-known Member

Domenic

MrExcel MVP

motilulla

Well-known Member

Similar threads

Forum statistics

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