The columns are as follows: Match date, Opponents' FIFA trigramme, FIFA match points for Colombia.
"0.2 time frame"
15-Jan-2005 | KOR | 491.28 |
17-Jan-2005 | GUA | 120.615 |
23-Feb-2005 | MEX | 179.52 |
09-Mar-2005 | USA | 0 |
26-Mar-2005 | VEN | 334.125 |
30-Mar-2005 | ARG | 0 |
31-May-2005 | ENG | 0 |
04-Jun-2005 | PER | 1254.825 |
08-Jun-2005 | ECU | 1210.275 |
06-Jul-2005 | PAN | 0 |
10-Jul-2005 | HON | 0 |
12-Jul-2005 | TRI | 1194.93 |
17-Jul-2005 | MEX | 1590.435 |
21-Jul-2005 | PAN | 0 |
04-Sep-2005 | URU | 0 |
08-Oct-2005 | CHI | 306.9 |
12-Oct-2005 | PAR | 1232.55 |
"0.3 time frame"
01-Mar-2006 | VEN | 129.69 |
24-May-2006 | ECU | 159.39 |
27-May-2006 | ROU | 176.115 |
30-May-2006 | POL | 510.435 |
02-Jun-2006 | GER | 0 |
04-Jun-2006 | MAR | 452.64 |
16-Aug-2006 | CHI | 458.64 |
"0.5 time frame"
07-Feb-2007 | URU | 0 |
25-Mar-2007 | SUI | 543.51 |
28-Mar-2007 | PAR | 502.74 |
09-May-2007 | PAN | 395.28 |
03-Jun-2007 | MNE | 148.5 |
05-Jun-2007 | JPN | 142.74 |
23-Jun-2007 | ECU | 458.64 |
28-Jun-2007 | PAR | 0 |
02-Jul-2007 | ARG | 0 |
05-Jul-2007 | USA | 1515.24 |
22-Aug-2007 | MEX | 518.805 |
08-Sep-2007 | PER | 143.08 |
12-Sep-2007 | PAR | 496.86 |
14-Oct-2007 | BRA | 482.65 |
17-Oct-2007 | BOL | 269.5 |
17-Nov-2007 | VEN | 1058.4 |
20-Nov-2007 | ARG | 1470 |
"1.0 time frame"
06-Feb-2008 | URU | 168.56 |
26-Mar-2008 | HON | 0 |
30-Apr-2008 | VEN | 414.54 |
29-May-2008 | IRL | 0 |
03-Jun-2008 | FRA | 0 |
14-Jun-2008 | PER | 333.2 |
18-Jun-2008 | ECU | 345.45 |
20-Aug-2008 | ECU | 0 |
06-Sep-2008 | URU | 0 |
10-Sep-2008 | CHI | 0 |
11-Oct-2008 | PAR | 0 |
15-Oct-2008 | BRA | 480.2 |
19-Nov-2008 | NGA | 488.61 |
Adding it up:
Year - Points - Matches - Multiplier - Total
-4 | 7915.455 | 17 | 0.2 | 93.123 |
-3 | 1886.91 | 7 | 0.3 | 80.86757 |
-2 | 8145.945 | 17 | 0.5 | 239.5866 |
-1 | 2230.56 | 13 | 1 | 171.5815 |
My total: 585.1587275. FIFA has 597. However, my software makes adjustments based on previous month differences and Colombia had 601 in my final December 2008 FIFA ranking preview.
Look at the unweighted averages for each year:
-4 | 465.615 |
-3 | 269.5586 |
-2 | 479.1732 |
-1 | 171.5815 |
Colombia really lost it in the last 12 months. No wonder they plunged in the rankings.
Top 5 most valuable individual matches:
17-Jul-2005 Mexico - Colombia 1 - 2 (Gold Cup 2005) 1590.435
05-Jul-2007 Colombia - USA 1 - 0 (Copa America 2007) 1515.24
20-Nov-2007 Colombia - Argentina 2 - 1 (2010 FIFA World Cup Qualifier) 1470
04-Jun-2005 Colombia - Peru 5 - 0 (2006 FIFA World Cup Qualifier) 1254.825
12-Oct-2005 Paraguay - Colombia 0 - 1 (2006 FIFA World Cup Qualifier) 1232.55
Top 5 most valuable matches (actual averaged value):
05-Jul-2007 Colombia - USA 1 - 0 (Copa America 2007) 44.566
20-Nov-2007 Colombia - Argentina 2 - 1 (2010 FIFA World Cup Qualifier) 43.235
19-Nov-2008 Colombia - Nigeria 1 - 0 (Friendly) 37.585
15-Oct-2008 Brazil - Colombia 0 - 0 (2010 FIFA World Cup Qualifier) 36.938
30-Apr-2008 Colombia - Venezuela 5 - 2 (Friendly) 31.888
Colombia's two best results are from more than an year ago! Then they have 2 friendlies and a draw in a qualifier.
Colombia also dropped in the Elo ratings. In the last 12 months, they've lost 19 places and 90 ranking points.
Colombia will probably drop one spot in the January 2009 FIFA ranking, as Costa Rica are expected to climb.