The analytics of the World Cup in Excel with PowerPivot

Very impressive tracker for the World Cup and much better than the charts out of the middle of the national newspapers, (mine out of the Daily Mail is now falling to bits - a bit like the England squad!), but -

I have entered all of the results from the group stages and sorted the goal differences and points but the list for the last 16 will not put up England against Germany.

One could think of all sorts of jokey and sarcastic reasons why this is happening but at the end of the day "2C" could have represented any other team had the order of play been different.

Any chance of a fix for this?

There is a error because in Group C USA and England have a equal points and GD... USA on first place because have more goals...

Change formula in hidden column L on hidden (;) Sheet Group Standings like =[@Pts]+([@GD]/100)+([@GF]/1000)

This fix will work for current results (all matches done and only group C have a problem) but IF there equal GF this not work... I don't know how FIFA choice best team... Maybe roulette?! :):)

If the teams are equal you apply the same three rules (points, goal difference and goals for) but considering only the matches where the two or three teams that are equal have participated. If still there are teams equal, FIFA draws lots.

Excellent use of Excel features in creating this Tracker.

I tried to replicate/create step by step the same template but it's obvious that you've left out some details. For the benefit of myself and others like me, could you please direct us to where more details can be found? I'll give you an example below. It seems to me that there are some names defined here, but I could not emulate it. The other thing is the square parentheses '[' and ']'. Excuse my ignorance but no doubt I missed something along the way.

Thanks again for your excellent work!

Example from the template:

=IF(AND(NOT(ISBLANK([ScoreA])),[@ScoreA]=[@ScoreB]), [TeamA],"")

Here is the answer:

office.microsoft.com/.../using-structured-references-with-excel-tables-HA010155686.aspx

hi...

i want to diplays an images on C2,D2,E2 by typing images name on C1,D1,E2..

can u help me with....

This was first posted on January 8th, six viewers but no ideas.

I wonder if anyone has used something similar. I know you can do this in MS Access but I would like to try it in Excel.

I and am looking for a way to display an Icon wihich is linked to a particular value in Excel

Example, Country name and its flag.

Seeing the Worldchampionship soccer is on its way I have an excel sheet to keep the scores and want to display the round winners with their relative flag.

The flag is not saved as a bmp, ico or gif on disk but is on a separate sheet next to the cell with the country's code and name:

A1,A2,A3

"NED","Netherlands",flag (it's not in the cell but 'floating' there.

The idea is to have a empty sheet.

In the cells the reference to a cell, let's say: A1 = WA which staands for Winner A, in the results, the walue of WA may be CRC (Costa Rica)

So the value of reference WA = CRC. Elsewhere in another sheet there is a flag for Costa Rica, I would like to display the flag foor WA next to it and of course this is a variable since I do not know who will be WA.

I would like to know if somebody has a solution or a small example of code which could do this in VBA for Excel

Thanks

Dear Sam,

I have the solution. But, I don't know the analytics of the World Cup, coz I don't like football.

If you need my help, please tell me your email.

Thanks!

Andrew Man

From Hong Kong.