A bit of spreadsheet fun - trying to ascertain which country is the bellwether for the WTS.
My methodology was as follows:
Take the individual AR's from 2010 - 2016 and calculate an accurate (.00) Ave Pub Increase/Decrease for each country. Sort the countries into descending order by this value with the Grand Total row included in the mix.
Assign the countries 5 places above and 5 places below the Grand Total 1 point. This is to reflect that these countries are very close to the Grand Total 'average' figure, but in reality are basically random small countries that will vary from year to year.
Look for 'large' countries eg more than 70k pubs within a range of about 0.7% of the Grand Total figure. Assign these countries a score of 3 points.
Maximum points for any country per year would be 4. Total possible points for the 6 years would be 24.
Total the points across the 6 AR's and the country with the highest points total is most like the global org. With me?
And the top 10 countries are: <drum roll pls>
Brazil 16
Chile 14
South Africa 14
Nigeria 13
Colombia 10
Peru 9
Zambia 8
Russia 7
Cuba 6
USA 6
So there you have it - if you want a quick clue on whats going on with the WTS keep your eye on Brazil, Chile and South Africa.