Lexicographic number.

serge

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,446
Office Version
  1. 2007
Platform
  1. Windows
Hi Everyone.

I'm looking for a formula that would give me the combination of 5 numbers according of the Lexicographic number ? The game is 5/56.

I have it the other way around, I type the combination from A1:E1 and it give the Lexico number in G1.

In the example below in G4, I put the Lexicographic number and I need in A4:E4 the combinaison corresponding to that number.

Excel Workbook
ABCDEFGH
1123451
252535455563819816
3
43819816
5
Sheet1


I already have the macro that do the job but I need a formula, Thank you.
Serge.
 
Last edited:
Sort by date Sort by votes
I have no further suggestion.

Good luck.
 
Upvote 0

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Hi shg,

After checking your formula, I find out, that it works only for the first and second combination, after that the formula is off !!!

1-2-3-4-5 is equal to Lexicographic number : 1
1-2-3-4-6 is equal to Lexicographic number : 2
1-2-3-4-7 is equal to Lexicographic number : 3 but here your formula return 7 ?
1-2-3-4-8 is equal to Lexicographic number : 4 but here your formula return 22 ?
Etc...

Unless I'm doing something wrong ?
Can you please help me correct it, Thank you.
Serge.
 
Upvote 0
My lexical order starts with 1-2-3-4-56 (well, sort of; it's actually 4-3-2-1-0).

So the order is:

All combinations of 5 choose 5 (that's one)

All combinations of 6 choose 5 (that's 5 more)

All combinations of 7 choose 5 (that's 15 more)

That's not lexical order for you, viewed in reverse, but there are good reasons that it is the way it is (it's easy to generate combinations for combination numbers and vice versa).
 
Upvote 0
I think I understand better what you mean, is that for example with 7 numbers you can generate 15 combinations of 5 numbers each.

But what I have in mind as a Lexicographic number, is that every single combination are in numerical order starting from :

1-2-3-4-5 wich is Lexico number : 1
1-2-3-4-6 wich is Lexico number : 2
1-2-3-4-7 wich is Lexico number : 3
1-2-3-4-8 wich is Lexico number : 4

etc... to the last one wich is

52-53-54-55-56 and the Lexico number : 3819816

Here was the confusion I think, or I'm still lost ?

Anyway I still want to say Thank you for your time spend.

Serge.
 
Upvote 0
Here are my first 56 combinations in lexical order, from http://www.box.net/shared/nqljsd3nlu

<TABLE style="WIDTH: 115pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=155 x:str><COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1426" span=5 width=31><TBODY><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffff99; WIDTH: 23pt; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 height=16 width=31 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffff99; WIDTH: 23pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 width=31 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffff99; WIDTH: 23pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 width=31 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffff99; WIDTH: 23pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 width=31 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #ffff99; WIDTH: 23pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl27 width=31 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="0">0 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="1">1 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="2">2 </TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; HEIGHT: 12pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 height=16 align=right x:num="7">7 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="6">6 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="5">5 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="4">4 </TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #f3f3f3; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl28 align=right x:num="3">3 </TD></TR></TBODY></TABLE>
 
Upvote 0
Hi serge,<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Casualty I am looking also same if I insert Lexicographic number and must get corresponding combination for that sequence.<o:p></o:p>
Surfing through net I find code, which do the job but could not make it loop so that can work cells through 1 to 100<o:p></o:p>
<o:p></o:p>
Link of my post is here where you will see the code: LexToNumbers<o:p></o:p>
http://www.mrexcel.com/forum/excel-questions/661142-line-index-index-line.html<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
And also here is the link where in post #6 you will find function UDF Code: for Lex_2_Num <o:p></o:p>
http://www.lottoforums.com/lottery/questions-answers/12740-lexicographic-index-numbers-combination-sequence.html<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Hope if you have not resolved yet may this can help you.<o:p></o:p>
<o:p></o:p>
And my request if you can help to make a loop for the code, which is in my post<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
Thanks and Regards,<o:p></o:p>
Kishan<o:p></o:p>
 
Upvote 0
Hi Kishan,

Thanks, I've got the same code than the " Lotto Forum " site but don't know how to duplicate it so I just go one by one it would be nice to have it.

Regards,
Serge.
 
Upvote 0
Hi serge,<o:p></o:p>
<o:p></o:p>
I find one more link I think will be use full for you. Where you will find useful UDF for you.<o:p></o:p>
<o:p></o:p>
http://www.mrexcel.com/forum/excel-questions/287099-lexigraphic-lottery-values.html#post1410474<o:p></o:p>
<o:p></o:p>
With this Function you be able to adapt them to different pool number like you say for 5/56 other are at 5/36 or 5/39 or 6/49 etc. only changing the value in cells in my example D and E. with out modifying the UDF for any lottery.<o:p></o:p>
<o:p></o:p>
<o:p></o:p>​
A<o:p></o:p>​
B<o:p></o:p>​
C<o:p></o:p>​
D<o:p></o:p>​
E<o:p></o:p>​
1<o:p></o:p>​
5<o:p></o:p>​
56<o:p></o:p>​
2<o:p></o:p>​
3<o:p></o:p>​
4<o:p></o:p>​
5<o:p></o:p>​

<TBODY> [TD="bgcolor: transparent"]
1<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"]
1,2,3,4,5<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"]
16<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"]
1,2,3,4,20<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"]
27<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"]
1,2,3,4,31<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"]
23504<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"]
1,2,36,38,49<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"]
3.819.812<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"]
51,52,53,54,56<o:p></o:p>​
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] <o:p></o:p>
[/TD]

</TBODY>
<o:p></o:p>

<TBODY>
[TD="bgcolor: transparent"] Spreadsheet Formulas <o:p></o:p>
[/TD]

[TD="bgcolor: transparent"]
Cell<o:p></o:p>
Formula<o:p></o:p>

<TBODY>
[TD="bgcolor: transparent"] B1<o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] =DeriveCombo($E$1;$D$1;A1)<o:p></o:p>
[/TD]

[TD="bgcolor: transparent"] B2<o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] =DeriveCombo($E$1;$D$1;A2)<o:p></o:p>
[/TD]

[TD="bgcolor: transparent"] B3<o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] =DeriveCombo($E$1;$D$1;A3)<o:p></o:p>
[/TD]

[TD="bgcolor: transparent"] B4<o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] =DeriveCombo($E$1;$D$1;A4)<o:p></o:p>
[/TD]

[TD="bgcolor: transparent"] B5<o:p></o:p>
[/TD]
[TD="bgcolor: transparent"] =DeriveCombo($E$1;$D$1;A5)<o:p></o:p>
[/TD]

</TBODY>
<o:p></o:p>
[/TD]

</TBODY>
<o:p></o:p>
<o:p></o:p>
Hope this will help you,<o:p></o:p>
<o:p></o:p>
Regards,<o:p></o:p>
Kishan<o:p></o:p>
 
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Solved
VBA to increase numbers by 1
Replies
8
Views
115
Fluff
Fluff
A
  • Solved
Conditional Formatting - apply rules to multiple rows based on specific cells (drop down menus)
Replies
4
Views
680
AndyB86
A
K
  • Question Question
Modify COUNTIF Formula to count inside parenthesis
Replies
7
Views
224
Fluff
Fluff
S
  • Question Question
SUM and CHOOSE formula question
Replies
7
Views
251
Fluff
Fluff
K
  • Question Question
Find index or lexicographic order numbers + combinations and sum of that.
Replies
7
Views
873
Kishan
K

Forum statistics

Threads
1,224,522
Messages
6,179,297
Members
452,903
Latest member
Knuddeluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top