Match Schedule
Match 1 2 " ( # 6 5 8 9 10 11 12 1" 1( 1# 16 15 18 19 20 21 22 2" 2( 2# 26 25 28 29 "0 "1 "2 "" "( "# "6 "5 "8 "9 (0 (1 (2 (" (( (# (6 (5 (8 (9 #0 #1 #2 #" #( ## #6 #5 #8 #9 60 61 62 6" 6(
Kick Off 9 Jun 06 18:00 9 Jun 06 21:00 10 Jun 06 1#:00 10 Jun 06 18:00 10 Jun 06 21:00 11 Jun 06 1#:00 11 Jun 06 18:00 11 Jun 06 21:00 12 Jun 06 21:00 12 Jun 06 18:00 12 Jun 06 1#:00 1" Jun 06 21:00 1" Jun 06 18:00 1" Jun 06 1#:00 1( Jun 06 1#:00 1( Jun 06 18:00 1( Jun 06 21:00 1# Jun 06 1#:00 1# Jun 06 18:00 1# Jun 06 21:00 16 Jun 06 1#:00 16 Jun 06 18:00 16 Jun 06 21:00 15 Jun 06 1#:00 15 Jun 06 21:00 15 Jun 06 18:00 18 Jun 06 18:00 18 Jun 06 1#:00 18 Jun 06 21:00 19 Jun 06 1#:00 19 Jun 06 21:00 19 Jun 06 18:00 20 Jun 06 16:00 20 Jun 06 16:00 20 Jun 06 21:00 20 Jun 06 21:00 21 Jun 06 21:00 21 Jun 06 21:00 21 Jun 06 16:00 21 Jun 06 16:00 22 Jun 06 16:00 22 Jun 06 16:00 22 Jun 06 21:00 22 Jun 06 21:00 2" Jun 06 21:00 2" Jun 06 21:00 2" Jun 06 16:00 2" Jun 06 16:00 2( Jun 06 15:00 2( Jun 06 21:00 2# Jun 06 15:00 2# Jun 06 21:00 26 Jun 06 15:00 26 Jun 06 21:00 25 Jun 06 15:00 25 Jun 06 21:00 "0 Jun 06 15:00 "0 Jun 06 21:00 1 Jul 06 15:00 1 Jul 06 21:00 ( Jul 06 21:00 # Jul 06 21:00 8 Jul 06 21:00 9 Jul 06 20:00
Venue Munich Gelsenkirchen $rank%urt )ortmund +am,ur' 1ei23i' 4urem,er' Colo'ne +anno0er Gelsenkirchen &erlin 9aiserslautern Stutt'art $rank%urt 1ei23i' Munich )ortmund +am,ur' 4urem,er' &erlin Gelsenkirchen Stutt'art +anno0er $rank%urt 9aiserslautern Colo'ne Munich 4urem,er' 1ei23i' )ortmund Stutt'art +am,ur' &erlin +anno0er Colo'ne 9aiserslautern $rank%urt Munich Gelsenkirchen 1ei23i' +am,ur' 4urem,er' )ortmund Stutt'art Colo'ne +anno0er 9aiserslautern &erlin Munich 1ei23i' Stutt'art 4urem,er' 9aiserslautern Colo'ne )ortmund +anno0er &erlin +am,ur' Gelsenkirchen $rank%urt )ortmund Munich Stutt'art &erlin
Group A A & & C C ) ) ! ! $ $ G G + + A A & & C C ) ) ! ! $ $ G G + + A A & & C C ) ) ! ! $ $ G G + + R16 R16 R16 R16 R16 R16 R16 R16 =$ =$ =$ =$ S$ S$ "rd $inal Germany oland !n'land Trinidad and Tobago Ar'entina Ser,ia and Montene'ro Me6ico An'ola /taly 78S8A8 Australia &ra3il $rance 9orea Re2u,lic S2ain :unisia Germany !cuador !n'land S*eden Ar'entina 4etherlands Me6ico ortu'al /taly C3ech Re2u,lic &ra3il Ja2an $rance :o'o S2ain Saudi Ara,ia !cuador Costa Rica S*eden ara'uay 4etherlands C-te d./0oire ortu'al /ran C3ech Re2u,lic Ghana Ja2an Croatia :o'o S*it3erland Saudi Ara,ia 7kraine ;inner Grou2 A ;inner Grou2 C ;inner Grou2 & ;inner Grou2 ) ;inner Grou2 ! ;inner Grou2 G ;inner Grou2 $ ;inner Grou2 + ;inner Match (9 ;inner Match #" ;inner Match #1 ;inner Match ## ;inner Match #5 ;inner Match #9 1oser Match 61 ;inner Match 61 WINNER Costa Rica !cuador ara'uay S*eden C-te d./0oire 4etherlands /ran ortu'al Ghana C3ech Re2u,lic Ja2an Croatia S*it3erland :o'o 7kraine Saudi Ara,ia oland Costa Rica Trinidad and Tobago ara'uay Ser,ia and Montene'ro C-te d./0oire An'ola /ran 78S8A8 Ghana Australia Croatia 9orea Re2u,lic S*it3erland :unisia 7kraine Germany oland !n'land Trinidad and Tobago Ar'entina Ser,ia and Montene'ro Me6ico An'ola /taly 78S8A8 &ra3il Australia $rance 9orea Re2u,lic S2ain :unisia Runner<72 Grou2 & Runner<72 Grou2 ) Runner<72 Grou2 A Runner<72 Grou2 C Runner<72 Grou2 $ Runner<72 Grou2 + Runner<72 Grou2 ! Runner<72 Grou2 G ;inner Match #0 ;inner Match #( ;inner Match #2 ;inner Match #6 ;inner Match #8 ;inner Match 60 1oser Match 62 ;inner Match 62
Pens
Grou2s Group A P W % % % % % % % % Group $ P W % % % % % % % % Group E P W % % % % % % % % Group G P W % % % % % % % % ! % % % % " % % % % # &&& &&& &&& &&& A &&& &&& &&& &&& G! Pts &&& % &&& % &&& % &&& % Group P W % % % % % % % % ! % % % % " % % % % # &&& &&& &&& &&& A &&& &&& &&& &&& G! Pts &&& % &&& % &&& % &&& %
$osta Rica Ecuador Po'and Ger*an+
Eng'and Trinidad and Tobago ()eden Paragua+
Argentina (erbia and Montenegro Nether'ands $-te d.I/oire
! % % % %
" % % % %
# &&& &&& &&& &&&
A &&& &&& &&& &&&
G! Pts &&& % &&& % &&& % &&& %
Me,ico Ango'a Portuga' Iran
Group ! P W ! % % % % % % % % % % % % Group # P W ! % % % % % % % % % % % % Group 4 P W ! % % % % % % % % % % % %
" % % % %
# &&& &&& &&& &&&
A &&& &&& &&& &&&
G! Pts &&& % &&& % &&& % &&& %
Ita'+ 12(2A2 $0ech Repub'ic Ghana
! % % % %
" % % % %
# &&& &&& &&& &&&
A &&& &&& &&& &&&
G! Pts &&& % &&& % &&& % &&& %
ra0i' Austra'ia 3apan $roatia
" % % % %
# &&& &&& &&& &&&
A &&& &&& &&& &&&
G! Pts &&& % &&& % &&& % &&& %
#rance Korea Repub'ic Togo ()it0er'and
! % % % %
" % % % %
# &&& &&& &&& &&&
A &&& &&& &&& &&&
G! Pts &&& % &&& % &&& % &&& %
(pain Tunisia (audi Arabia 1kraine
" % % % %
# &&& &&& &&& &&&
A &&& &&& &&& &&&
G! Pts &&& % &&& % &&& % &&& %
A%or the >>> :he t*o teams comin' %irst and second in each 'rou2 ?uali%y second round8 !ra) "ots & >>> Rankin' in each 'rou2 shall ,e determined as %ollo*s: and :o,a'o C >>> @aA:rinidad 'reater num,er o% 2oints o,tained in all the 'rou2 matchesB ) >>> /% t*o or more teams are e?ual on the ,asis o% the a,o0e criterionC their rankin' shall ,e determined as %ollo*s: ! >>> @,A 'reater num,er o% 2oints o,tained in the 'rou2 matches ,et*een $ >>>the teams concernedB @cA 'oal di%%erence resultin' %rom the 'rou2 matches ,et*een the >>> teams concernedB G @dA 'reater num,er o% 'oals scored in the 'rou2 matches ,et*een the teams concernedB + >>> @eA 'oal di%%erence in all the 'rou2 matchesB @%A 'reater num,er o% 'oals scored in all the 'rou2 matchesB @'A dra*in' lots ,y the Dr'anisin' Committee %or the $/$A ;orld Cu28 $'ick the !ra) "ots button to dra) 'ots )hen re5uired2
Rules obtained from [Link]
:E Schedule
Match 1 2 " 8 # 6 5 8 11 10 9 1( 1" 12 1# 16 15 18 9> 20 21 22 2" 2( 26 2# 28 25 29 "0 "2 "1 "" "( "# @: "9 (0 "5 "8 (1 (2 (" (( (5 (8 (# (6 (9 #0 #1 #2 #" #( ## #6 #5 #8 #9 60 61 62 6" 6( Ger*an Ti*e 9 Jun 06 18:00 9 Jun 06 21:00 10 Jun 06 1#:00 9% 3un %: 9;<%% 10 Jun 06 21:00 11 Jun 06 1#:00 11 Jun 06 18:00 11 Jun 06 21:00 12 Jun 06 1#:00 12 Jun 06 18:00 12 Jun 06 21:00 1" Jun 06 1#:00 1" Jun 06 18:00 1" Jun 06 21:00 1( Jun 06 1#:00 1( Jun 06 18:00 1( Jun 06 21:00 1# Jun 06 1#:00 9? 3un %: 9;<%% 1# Jun 06 21:00 16 Jun 06 1#:00 16 Jun 06 18:00 16 Jun 06 21:00 15 Jun 06 1#:00 15 Jun 06 18:00 15 Jun 06 21:00 18 Jun 06 1#:00 18 Jun 06 18:00 18 Jun 06 21:00 19 Jun 06 1#:00 19 Jun 06 18:00 19 Jun 06 21:00 20 Jun 06 16:00 20 Jun 06 16:00 20 Jun 06 21:00 =% 3un %: =9<%% 21 Jun 06 16:00 21 Jun 06 16:00 21 Jun 06 21:00 21 Jun 06 21:00 22 Jun 06 16:00 22 Jun 06 16:00 22 Jun 06 21:00 22 Jun 06 21:00 2" Jun 06 16:00 2" Jun 06 16:00 2" Jun 06 21:00 2" Jun 06 21:00 2( Jun 06 15:00 2( Jun 06 21:00 2# Jun 06 15:00 2# Jun 06 21:00 26 Jun 06 15:00 26 Jun 06 21:00 25 Jun 06 15:00 25 Jun 06 21:00 "0 Jun 06 15:00 "0 Jun 06 21:00 1 Jul 06 15:00 1 Jul 06 21:00 ( Jul 06 21:00 # Jul 06 21:00 8 Jul 06 21:00 9 Jul 06 20:00 1(A 6E(T7 9 Jun 06 12:00 9 Jun 06 1#:00 10 Jun 06 09:00 9% 3un %: 9=<%% 10 Jun 06 1#:00 11 Jun 06 09:00 11 Jun 06 12:00 11 Jun 06 1#:00 12 Jun 06 09:00 12 Jun 06 12:00 12 Jun 06 1#:00 1" Jun 06 09:00 1" Jun 06 12:00 1" Jun 06 1#:00 1( Jun 06 09:00 1( Jun 06 12:00 1( Jun 06 1#:00 1# Jun 06 09:00 9? 3un %: 9=<%% 1# Jun 06 1#:00 16 Jun 06 09:00 16 Jun 06 12:00 16 Jun 06 1#:00 15 Jun 06 09:00 15 Jun 06 12:00 15 Jun 06 1#:00 18 Jun 06 09:00 18 Jun 06 12:00 18 Jun 06 1#:00 19 Jun 06 09:00 19 Jun 06 12:00 19 Jun 06 1#:00 20 Jun 06 10:00 20 Jun 06 10:00 20 Jun 06 1#:00 =% 3un %: 9?<%% 21 Jun 06 10:00 21 Jun 06 10:00 21 Jun 06 1#:00 21 Jun 06 1#:00 22 Jun 06 10:00 22 Jun 06 10:00 22 Jun 06 1#:00 22 Jun 06 1#:00 2" Jun 06 10:00 2" Jun 06 10:00 2" Jun 06 1#:00 2" Jun 06 1#:00 2( Jun 06 11:00 2( Jun 06 1#:00 2# Jun 06 11:00 2# Jun 06 1#:00 26 Jun 06 11:00 26 Jun 06 1#:00 25 Jun 06 11:00 25 Jun 06 1#:00 "0 Jun 06 11:00 "0 Jun 06 1#:00 1 Jul 06 11:00 1 Jul 06 1#:00 ( Jul 06 1#:00 # Jul 06 1#:00 8 Jul 06 1#:00 9 Jul 06 1(:00 Venue Munich Gelsenkirchen $rank%urt !ort*und +am,ur' 1ei23i' 4urem,er' Colo'ne &erlin Gelsenkirchen +anno0er $rank%urt Stutt'art 9aiserslautern 1ei23i' Munich )ortmund +am,ur' Nure*berg &erlin Gelsenkirchen Stutt'art +anno0er $rank%urt Colo'ne 9aiserslautern 4urem,er' Munich 1ei23i' )ortmund +am,ur' Stutt'art &erlin +anno0er Colo'ne Kaisers'autern Gelsenkirchen 1ei23i' $rank%urt Munich +am,ur' 4urem,er' )ortmund Stutt'art 9aiserslautern &erlin Colo'ne +anno0er Munich 1ei23i' Stutt'art 4urem,er' 9aiserslautern Colo'ne )ortmund +anno0er &erlin +am,ur' Gelsenkirchen $rank%urt )ortmund Munich Stutt'art &erlin ) ) C C ! ! $ $ + + G G R16 R16 R16 R16 R16 R16 R16 R16 =$ =$ =$ =$ S$ S$ "rd $inal & C C ) ) ! ! $ $ G G + + A A & C C ) ) $ ! ! G G $ + + A A Group A A & Germany oland !n'land Trinidad and Tobago Ar'entina Ser,ia and Montene'ro Me6ico An'ola Australia 78S8A8 /taly 9orea Re2u,lic $rance &ra3il S2ain :unisia Germany !cuador Eng'and S*eden Ar'entina 4etherlands Me6ico ortu'al C3ech Re2u,lic /taly Ja2an &ra3il $rance :o'o Saudi Ara,ia S2ain !cuador Costa Rica S*eden Paragua+ ortu'al /ran 4etherlands C-te d./0oire C3ech Re2u,lic Ghana Ja2an Croatia Saudi Ara,ia 7kraine :o'o S*it3erland ;inner Grou2 A ;inner Grou2 C ;inner Grou2 & ;inner Grou2 ) ;inner Grou2 ! ;inner Grou2 G ;inner Grou2 $ ;inner Grou2 + ;inner Match (9 ;inner Match #" ;inner Match #1 ;inner Match ## ;inner Match #5 ;inner Match #9 1oser Match 61 ;inner Match 61 Costa Rica !cuador ara'uay ()eden C-te d./0oire 4etherlands /ran ortu'al Ja2an C3ech Re2u,lic Ghana :o'o S*it3erland Croatia 7kraine Saudi Ara,ia oland Costa Rica Trinidad and Tobago ara'uay Ser,ia and Montene'ro C-te d./0oire An'ola /ran Ghana 78S8A8 Croatia Australia 9orea Re2u,lic S*it3erland 7kraine :unisia Germany oland !n'land Trinidad and Tobago Me6ico An'ola Ar'entina Ser,ia and Montene'ro /taly 78S8A8 &ra3il Australia S2ain :unisia $rance 9orea Re2u,lic Runner<72 Grou2 & Runner<72 Grou2 ) Runner<72 Grou2 A Runner<72 Grou2 C Runner<72 Grou2 $ Runner<72 Grou2 + Runner<72 Grou2 ! Runner<72 Grou2 G ;inner Match #0 ;inner Match #( ;inner Match #2 ;inner Match #6 ;inner Match #8 ;inner Match 60 1oser Match 62 ;inner Match 62
:his *ork,ook is %ree and may not ,e co2ied or sold *ithout the e62ress *ritten 2ermission o% Graham aramore8 / lease ad0ise any ,u's or comments to 2arryishereGyahoo8com8au8 4ote that this *ork,ook re?uires macros to ,e see any sheets e6ce2t this one then select :ools H Macro H Security and select the Medium o2tion8 Close !6cel then click the !na,le Macros ,utton at the 2rom2t8 !nFoy :<A
#eatures I ;hen you select a cell the ro* *ill ,e shaded 'reen8 :he corres2ondin' 0enue %or this match *ill ,e coloured in I I I I I I I I
Clickin' on a %la' *ill 2lay the national anthem and dis2lay a ,o6 containin' the lyrics o% the national anthem8 :h *e, site and some lyrics may not ,e dis2layed8 Re?uires /nternet !62lorer to ,e your de%ault ,ro*ser and an /nt
:he Match Schedule sheet is in Match )ay order8 Jou may notice that some matches are not in time order @e' m it.s Fust the *ay $/$A ha0e done thin's8 Clickin' on a city in the ma2 o% Germany *ill dis2lay a 2icture o% the stadium %or t*o seconds8
:o kee2 the ma2 0isi,le %or the lo*er hal% o% the Match Schedule sheetC the sheet *ill scroll u2 %rom match day 1 *ith the ma2 mo0in' accordin'ly8
:he Round o% 16 matches @i8e8 match (9<#6A *ill ,e u2dated *ith the Grou2 *inners and runners<u2 only a%ter a
Jou can choose your %a0ourite team in the ,o6 located in the to2 ri'ht hand side o% the Match Schedule sheet8 J in all sheets8 :he de%ault team is the 4etherlandsC my %a0ourite team8
/% you enter a tied result in a knockout match @i8e8 match (9<62A you *ill ,e 2rom2ted to enter the result o% the 2e then ,e dis2layed in the ens column @to the ri'ht o% the second scoreA
Grou2s *ill ,e sorted accordin' to the o%%icial $/$A rules as indicated in the Grou2s sheet8 /% teams cannot ,e se dra*in' o% lots is re?uired to se2arate the teams8 Dnce all 'ames %or a 'rou2 ha0e ,een 2layed you *ill ,e auto is re?uired8 Merely rank the teams %rom to2 to ,ottom ,y mo0in' the team names a,out8 4ote that only those tea listed8 /% you do not kno* the result o% the dra*in' o% lots you may 2ress Cancel and enter the result later ,y clic in the Grou2s sheet8
I I
:he ;allchart sheet dis2lays a *allchart 0ie* o% the knockout 'ames8 :he round o% 16 teams are ,ased u2on th so as more 'ames are 2layed the names o% the teams *ill chan'e accordin'ly8
:he :E schedule sheet lists e0ery match in strict )ateK:ime order8 Select your country %rom the dro2 do*n ,o6 a accordin'ly8 :he :E schedule is linked to the Match Schedule sheet so the knockout team names *ill ,e dis2lay ;ill ,e handy to 2rint and kee2 ne6t to the remote8 Jou can also %ormat the matches to 0ie* in addition to 'ame ,y clickin' the .$ormat Games :o ;atch. ,utton8
ermission o% Graham aramore8 /.m Fust a %oot,all %an like you :<A is *ork,ook re?uires macros to ,e ena,led8 /% you cannot Medium o2tion8 Close !6cel then reo2en this *ork,ook and
e %or this match *ill ,e coloured in the ma2 o% Germany8
e lyrics o% the national anthem8 :his is linked to a German ,e your de%ault ,ro*ser and an /nternet connection8
matches are not in time order @e' match 9<11A8 :his is not a mistakeC
or t*o seconds8
eet *ill scroll u2 %rom match day 1<"2 and do*n %rom match ""<6(
inners and runners<u2 only a%ter all 6 'ames in the 'rou2 ha0e ,een 2layed8
de o% the Match Schedule sheet8 Jour selected team *ill ,e hi'hli'hted
m2ted to enter the result o% the 2enalty shootout8 :he score *ill
ou2s sheet8 /% teams cannot ,e se2arated ,y rules a<% then the ha0e ,een 2layed you *ill ,e automatically 2rom2ted i% dra*in' lots mes a,out8 4ote that only those teams that re?uire se2aration are el and enter the result later ,y clickin' the )ra* 1ots ,utton
nd o% 16 teams are ,ased u2on the to2 t*o teams in each 'rou2
country %rom the dro2 do*n ,o6 and the local times *ill chan'e ockout team names *ill ,e dis2layed as they are determined8 atches to 0ie* in addition to 'ames in0ol0in' your %a0ourite team
