Code error ‘1004’ at 3^11

K

Kishan

Well-known Member
Joined
Mar 15, 2011
Messages
1,648
Office Version
  1. 2010
Platform
  1. Windows
Hi, it is strange that if I use equation in a single cell A1 and run the code below =3^10 to create all sets the code works perfectly fine.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
Equation 3^10<o:p></o:p>
Rich (BB code): 
<TABLE style="WIDTH: 605pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=806 x:str><COLGROUP><COL style="WIDTH: 605pt; mso-width-source: userset; mso-width-alt: 29476" width=806><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 605pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=806>A1+A2+A3,B1+B2+B3,C1+C2+C3,D1+D2+D3,E1+E2+E3,F1+F2+F3,G1+G2+G3,H1+H2+H3,I1+I2+I3,J1+J2+J3</TD></TR></TBODY></TABLE>
<o:p></o:p>

But if I use the equation with 3^11 or 3^12 then the code gives an error of ‘1004’<o:p></o:p>
<o:p></o:p>
Equation 3^11<o:p></o:p>
Rich (BB code): 
<TABLE style="WIDTH: 605pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=806 x:str><COLGROUP><COL style="WIDTH: 605pt; mso-width-source: userset; mso-width-alt: 29476" width=806><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 605pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=806>A1+A2+A3,B1+B2+B3,C1+C2+C3,D1+D2+D3,E1+E2+E3,F1+F2+F3,G1+G2+G3,H1+H2+H3,I1+I2+I3,J1+J2+J3,K1+K2+K3</TD></TR></TBODY></TABLE>
<o:p></o:p>
<o:p></o:p>
Equation 3^12<o:p></o:p>
Rich (BB code): 
<TABLE style="WIDTH: 605pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=806 x:str><COLGROUP><COL style="WIDTH: 605pt; mso-width-source: userset; mso-width-alt: 29476" width=806><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 605pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=17 width=806>A1+A2+A3,B1+B2+B3,C1+C2+C3,D1+D2+D3,E1+E2+E3,F1+F2+F3,G1+G2+G3,H1+H2+H3,I1+I2+I3,J1+J2+J3,K1+K2+K3,L1+L2+L3</TD></TR></TBODY></TABLE>
<o:p></o:p>
<o:p></o:p>
Here is the code: <o:p></o:p>
Rich (BB code): 
Option Explicit
Rich (BB code):
Rich (BB code): 
 <o:p></o:p>
Sub Create_abc_Sets() <o:p></o:p>
 <o:p></o:p>
Dim Ans As Boolean, Col As Collection, i As Long<o:p></o:p>
Set Col = New Collection<o:p></o:p>
Ans = BuildLoops(Range("A1").Value, ",", Col)<o:p></o:p>
If Ans Then<o:p></o:p>
For i = 1 To Col.Count<o:p></o:p>
Cells(i + 2, 1).Value = Col(i) <o:p></o:p>
Next i<o:p></o:p>
Else<o:p></o:p>
MsgBox "Error !", vbCritical<o:p></o:p>
End If<o:p></o:p>
End Sub<o:p></o:p>
 <o:p></o:p>
Function BuildLoops(ByVal St As String, Sep As String, ByRef Col As Collection) As Boolean<o:p></o:p>
Dim Ar As Variant, Ar2 As Variant, ArMain As Variant<o:p></o:p>
Dim i As Long, j As Long, Ctr As Long, TempSt As String<o:p></o:p>
St = Application.Substitute(St, " ", "")<o:p></o:p>
Ar = Split(St, Sep)<o:p></o:p>
If Not IsArray(Ar) Then Exit Function<o:p></o:p>
ReDim ArMain(1 To UBound(Ar) - LBound(Ar) + 1)<o:p></o:p>
For i = LBound(Ar) To UBound(Ar)<o:p></o:p>
Ar2 = Split(Ar(i), "+")<o:p></o:p>
Ctr = Ctr + 1<o:p></o:p>
ArMain(Ctr) = Ar2<o:p></o:p>
Next i<o:p></o:p>
For j = LBound(ArMain(1)) To UBound(ArMain(1))<o:p></o:p>
TempSt = ArMain(1)(j)<o:p></o:p>
BuildString 1, ArMain, Col, TempSt<o:p></o:p>
Next j<o:p></o:p>
BuildLoops = True<o:p></o:p>
End Function<o:p></o:p>
 <o:p></o:p>
Private Function BuildString(ByRef i As Long, ByRef ArMain As Variant, ByRef Col As Collection, ByRef TempSt As String)<o:p></o:p>
Dim j As Long, St As String<o:p></o:p>
St = TempSt<o:p></o:p>
If i < UBound(ArMain) Then<o:p></o:p>
For j = LBound(ArMain(i + 1)) To UBound(ArMain(i + 1))<o:p></o:p>
TempSt = St & "," & ArMain(i + 1)(j)<o:p></o:p>
BuildString i + 1, ArMain, Col, TempSt<o:p></o:p>
Next j<o:p></o:p>
Else<o:p></o:p>
Col.Add UCase(TempSt)<o:p></o:p>
End If<o:p></o:p>
End Function
<o:p></o:p>
<o:p></o:p>
I’m using excel 2000. Is it the cause or I’m doing something wrong that’s why the code is producing an error? <o:p></o:p>
<o:p></o:p>
Please, can someone explain this?<o:p></o:p>
<o:p></o:p>
Thank in advance,<o:p></o:p>
Kishan<o:p></o:p>
 
Sort by date Sort by votes
Sorry, I don't understand what this "football question" is. Can you try explaining again?
 
Upvote 0

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
How about a UDF, and you can arrange your data however you like?

Code: 
Function Kishan(ByVal d As Double, _
                iLen As Long) As String
    Dim asOut()     As String
    Dim i           As Long
 
    ReDim asOut(1 To iLen)
 
    For i = iLen To 1 Step -1
        asOut(i) = Choose(d - Int(d / 3#) * 3# + 1#, "1", "X", "2")
        d = Int(d / 3#)
    Next i
 
    Kishan = Join(asOut, ",")
End Function

E.g.,

<TABLE style="WIDTH: 158pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=210 x:str><COLGROUP><COL style="WIDTH: 37pt" width=49><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 7350" width=161><TBODY><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 37pt; HEIGHT: 12pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 width=49 x:num="0">0 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; WIDTH: 121pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 width=161>1,1,1,1,1,1,1,1,1,1,1</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="1">1 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>1,1,1,1,1,1,1,1,1,1,X</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="2">2 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>1,1,1,1,1,1,1,1,1,1,2</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="3">3 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>1,1,1,1,1,1,1,1,1,X,1</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:str="'…">…</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30></TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="1000">1,000 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>1,1,1,1,X,X,1,X,1,1,X</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:str="'…">…</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30></TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="10000">10,000 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>1,1,X,X,X,2,1,X,X,1,X</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:str="'…">…</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30></TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="100000">100,000 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>X,2,1,1,2,1,X,X,2,1,X</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:str="'…">…</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30></TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=16 x:num="177146" x:fmla="=3^11-1">177,146 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #e7e7e7; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30>2,2,2,2,2,2,2,2,2,2,2</TD></TR></TBODY></TABLE>

The formula in B1 and down is

=Kishan(A1,11)
 
Upvote 0
xenou, definitely the table below shows 14 match will be played between 28 teams, which are in Column B and in Column C, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Suppose match 1 result is 3-1 that mean Column B team is winner result =1 <o:p></o:p>
If match 1 result is 1-3 that mean Column C team is winner result =2<o:p></o:p>
And if match 1 result is 1-1 that mean both teams are equal result =X<o:p></o:p>
<o:p></o:p>
Teams table:<o:p></o:p>
<TABLE style="WIDTH: 408pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm" cellSpacing=0 cellPadding=0 width=544 border=0><TBODY><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=31>
*<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 32pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=43>
A<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 107pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=143>
B<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 75pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=100>
C<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 64pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=85>
D<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 43pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=57>
E<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; WIDTH: 64pt; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap width=85>
F<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap> <o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap> <o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap> <o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>If Team A win<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
withdraw<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>If Team B win<o:p></o:p>
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0cm; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
2<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0cm; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>Game<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>Team-A<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>Team-B<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
X<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
2<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
3<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>RECREATIVO<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>GRANADA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
4<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
2<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>BETIS<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>VILLARREAL B<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
X<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
5<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
3<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>VALLADOLID<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>ALCORCON<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
X<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
6<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
4<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>ALBACETE<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>HUESCA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
2<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
7<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
5<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>PONFERRADINA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>GIMNASTIC<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
8<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
6<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>GIRONACORDOBA1<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>CÓRDOBA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
9<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
7<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>SALAMANCA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>NUMANCIA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
10<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
8<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>RAYO VALLECANO<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>BARCELONA B<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
2<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
11<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
9<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>CELTA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>CARTAGENA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
2<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
12<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
10<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>ELCHE<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>XEREZ<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
X<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
13<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
11<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>GRECIA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>MALTA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
X<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
14<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
12<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>INGLATERRA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>SUIZA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
15<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
13<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>PORTUGAL<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>NORUEGA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
16<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
14<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 9pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>ISLANDIA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>DINAMARCA<o:p></o:p>
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
1<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0.75pt; BORDER-TOP: #d4d0c8; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #d4d0c8; PADDING-TOP: 0.75pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>
<o:p></o:p>​
</TD></TR></TBODY></TABLE>
<o:p></o:p>
If you see each Match has 3 possibility’s and there are 14 teams that mean possible combination will be 3^14 = 4.782.969.<o:p></o:p>
<o:p></o:p>
Result in the team table above is follow: 1-X-X-2-1-1-1-2-2-X-X-1-1-1 <o:p></o:p>
In this result 1 is =7 times, X is = 4 times and 2 is =3 times. Every time result will be different, times with 1, X and 2.<o:p></o:p>
<o:p></o:p>
So I have to reply that how many combination will be produced for example,<o:p></o:p>
With 1 if it is used 1 time<o:p></o:p>
1 if it is used 2 times<o:p></o:p>
1 if it is used 3 times<o:p></o:p>
1 if it is used 4 time out of total combination 4.782.969<o:p></o:p>
<o:p></o:p>
For that reason I wanted to generate all combination. I hope I have cleared my question if not please let me know I will try again.<o:p></o:p>
<o:p></o:p>
Thanks,<o:p></o:p>
Kishan <o:p></o:p>
<o:p></o:p>
 
Upvote 0
shg, I am very much pleased with this excellent UDF solution, with this I can generate all possible combination, which is 4.782.969 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
I am very grateful and thankful to you for giving a lovely solution.<o:p></o:p>
<o:p></o:p>
Now just last question I want to know for my knowledge, do any VBA can continue writing in next columns or it is not possible at all. This is just next time I should not ask about this.<o:p></o:p>
<o:p></o:p>
Thanks,<o:p></o:p>
Kishan <o:p></o:p>
 
Upvote 0
Yes, VBA could do that, and someone may show you how. Then you would have a 128+ MB workbook before you add anything else.

I don't believe a 4M element list has any value that could not be better obtained analytically.
 
Upvote 0
shg, thanks once again for your kind reply. I agree with you and at same time I’m very happy with your ideal solution. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
Many thanks for your help.<o:p></o:p>
<o:p></o:p>
Kishan <o:p></o:p>
 
Upvote 0
A little simpler ...

Code: 
Function Kishan(ByVal d As Double, _
                iLen As Long) As String
    Dim i As Long
  
    For i = iLen To 1 Step -1
        Kishan = Choose(d - Int(d / 3#) * 3# + 1#, ",1", ",X", ",2") & Kishan
        d = Int(d / 3#)
    Next i
 
    Kishan = Mid(Kishan, 2)
End Function

Good luck.
 
Upvote 0
Solution
shg, i tried out the function and it worked fabulously.

Regards,
Kishan
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Generate 1X2 combinations by percentage.
Replies
9
Views
705
motilulla
M
M
  • Solved
Help with separating Text String from a Excel Col
Replies
3
Views
604
Peter_SSs
Peter_SSs
P
  • Question Question
The cell or chart you're trying to change is on a protected sheet. Error upon placing worksheet Change Selection Code
Replies
1
Views
5K
pingme89
P
K
  • Question Question
Highlight 3 way patterns in the 3 different colours.
Replies
3
Views
667
Peter_SSs
Peter_SSs
S
  • Question Question
Counting Unique Records and displaying in alternate cells
Replies
6
Views
677
Aladin Akyurek
Aladin Akyurek

Forum statistics

Threads
1,224,616
Messages
6,179,911
Members
452,949
Latest member
beartooth91

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