The columns are as follows: Match date, Opponents' FIFA trigramme, FIFA match points for Malaysia.
October 2008
"0.2 time frame"
13-Oct-2004 | HKG | 0 |
17-Nov-2004 | KUW | 0 |
10-Dec-2004 | PHI | 127.5 |
12-Dec-2004 | MYA | 0 |
14-Dec-2004 | THA | 326.4 |
28-Dec-2004 | IDN | 277.95 |
3-Jan-2005 | IDN | 0 |
15-Jan-2005 | MYA | 142.8 |
4-Jun-2005 | SIN | 0 |
8-Jun-2005 | SIN | 0 |
"0.3 time frame"
19-Feb-2006 | NZL | 0 |
23-Feb-2006 | NZL | 0 |
31-May-2006 | SIN | 91.8 |
3-Jun-2006 | SIN | 91.8 |
23-Aug-2006 | IDN | 45.9 |
27-Aug-2006 | MYA | 0 |
"0.5 time frame"
12-Jan-2007 | PHI | 127.5 |
14-Jan-2007 | MYA | 42.5 |
16-Jan-2007 | THA | 0 |
23-Jan-2007 | SIN | 62.9 |
27-Jan-2007 | SIN | 62.9 |
24-Mar-2007 | SRI | 135.15 |
26-Mar-2007 | SRI | 0 |
18-Jun-2007 | CAM | 127.5 |
21-Jun-2007 | UAE | 0 |
28-Jun-2007 | JAM | 0 |
10-Jul-2007 | CHN | 0 |
14-Jul-2007 | UZB | 0 |
18-Jul-2007 | IRN | 0 |
"1.0 time frame"
21-Oct-2007 | BHR | 0 |
28-Oct-2007 | BHR | 221 |
6-Jun-2008 | IDN | 60.35 |
22-Jul-2008 | IND | 42.5 |
Adding it up:
Year - Points - Matches - Multiplier - Total
-4 | 874.65 | 10 | 0.2 | 17.493 |
-3 | 229.5 | 6 | 0.3 | 11.475 |
-2 | 558.45 | 13 | 0.5 | 21.47885 |
-1 | 323.85 | 5 | 1 | 64.77 |
For the last 12-month time frame, Malaysia only have 4 matches, but FIFA requires a minimum of 5, so the total is divided by 5 instead of 4.
My total: 115.2168462. FIFA has 109. However, my software makes adjustments based on previous month differences and Malaysia had 109 in my final October 2008 FIFA ranking preview.
November 2008
"0.2 time frame"
17-Nov-2004 | KUW | 0 |
10-Dec-2004 | PHI | 127.5 |
12-Dec-2004 | MYA | 0 |
14-Dec-2004 | THA | 326.4 |
28-Dec-2004 | IDN | 277.95 |
3-Jan-2005 | IDN | 0 |
15-Jan-2005 | MYA | 142.8 |
4-Jun-2005 | SIN | 0 |
8-Jun-2005 | SIN | 0 |
"0.3 time frame"
19-Feb-2006 | NZL | 0 |
23-Feb-2006 | NZL | 0 |
31-May-2006 | SIN | 91.8 |
3-Jun-2006 | SIN | 91.8 |
23-Aug-2006 | IDN | 45.9 |
27-Aug-2006 | MYA | 0 |
"0.5 time frame"
12-Jan-2007 | PHI | 127.5 |
14-Jan-2007 | MYA | 42.5 |
16-Jan-2007 | THA | 0 |
23-Jan-2007 | SIN | 62.9 |
27-Jan-2007 | SIN | 62.9 |
24-Mar-2007 | SRI | 135.15 |
26-Mar-2007 | SRI | 0 |
18-Jun-2007 | CAM | 127.5 |
21-Jun-2007 | UAE | 0 |
28-Jun-2007 | JAM | 0 |
10-Jul-2007 | CHN | 0 |
14-Jul-2007 | UZB | 0 |
18-Jul-2007 | IRN | 0 |
21-Oct-2007 | BHR | 0 |
28-Oct-2007 | BHR | 221 |
"1.0 time frame"
6-Jun-2008 | IDN | 60.35 |
22-Jul-2008 | IND | 42.5 |
10-Oct-2008 | PAK | 127.5 |
15-Oct-2008 | NEP | 127.5 |
20-Oct-2008 | AFG | 127.5 |
23-Oct-2008 | MYA | 127.5 |
Adding it up:
Year - Points - Matches - Multiplier - Total
-4 | 874.65 | 9 | 0.2 | 19.43667 |
-3 | 229.5 | 6 | 0.3 | 11.475 |
-2 | 779.45 | 15 | 0.5 | 25.98167 |
-1 | 612.85 | 6 | 1 | 102.1417 |
My total: 159.035. FIFA has 152. The adjusted value computed by my software was 153 as you can see in the November 2008 FIFA ranking preview.
Malaysia total rised because:
You dropped the defeat against Hong Kong (13 Oct 2004), so the average of the "0.2 time frame" increased.
Two matches against Bahrain (21 and 28 Oct 2007) dropped from 1.0 to 0.5 increasing the average of the 0.5 time frame.
You won 4 friendlies so the average of the last 12 months increased.
No comments:
Post a Comment