Boys as we come to the end of our 2023 adventures, some of us look back at our annual spend, top 3 meets and want to forget the worst punt. The recent post be bluegene (
https://www.ukpunting.com/index.php?topic=392591.0) with all the stats got me looking at my punting history.
After a few days playing board games and watching boring (repeat) films, some of us want some ‘me time’ with UKP. Just for kicks, let us visualise who has ‘shagged the world’. No prizes for the overall winner, just bragging rights until they get knocked off.
T&Cs: To strike a country of the list, the WG has to be from that country or you shagged there! … no bullshit, if you’ve completed Antartica, we want stories to back it up!
Mile high and ships don't count.
I’ll start. 11 different countries, majority Romanians. Need to knock off Russia and Hungary at some point.
Hidden Image/Members OnlyCreating a world map in G00gle sheets. (Excel 2021 is similar to below. Unsure if app1e has a similar process.)
Step by step instructions how to create a world map in g00gle sheets.
1) Go to your g00gle drive. ‘+New’ > ‘g00gle sheet’.
2) In cell A1 input Country and cell B1 input Punt. These will be the column headings.
In the first column input the country name and second column input a ‘1’ to denote you completed or an integer to show the number of punts.
3) I’ve put an ‘underline in cells A25 and B25 so this will be our input range for the chart. If you will have more than 24 countries, you can extend the chart range later.
Next we add the World map to the spreadsheet:4) Insert > Chart. {use the following parameters}
Chart Type = Map
Data Range = A1:B25
Region = Country
Colour = Punt
Check ‘Use row 1 as headers’
5) To download the Map, click on the 3 dots on the top right of the highlighted map.
Hidden Image/Members OnlyHidden Image/Members Only