Football World Cup score spreadsheet formula

**markauskas** · 06-06-2014, 05:41 AM

Hi. I do a football prediction competition with my friends and need help or the formula to calculate peoples scores.

The scoring works like this:
1. 25 points for correct prediction: win, draw or lose.
2. accuracy of prediction. Accuracy is calculated from the image below:
Screenshot_5.png

**nathansav** · 06-06-2014, 06:18 AM

There are loads of these already on there, i've done 3 this month, search football, i did one in the last few days :o)

You can do an INDEX & MATCH on your matrix to sort the accuracy, F1 the 2 in excel, they are self explanitary, match is what it says and index is like reading a train timetable, index(array, row, column)

World cup fever :o)

**Danna Breitbarth** · 06-12-2014, 04:04 AM

Hi,

Thanks for the post about World Cup. Just a tip about those who don't live in countries that stream world cup online. You can use UnoTelly to remove the geoblock and stream World Cup 2014 in your country free worldcup.unotelly.com