Zeitpunkt Nutzer Delta Tröts TNR Titel Version maxTL Mi 24.07.2024 00:01:07 61.956 0 3.574.077 57,7 Fosstodon 4.2.10 500 Di 23.07.2024 00:00:03 61.956 -3 3.570.705 57,6 Fosstodon 4.2.10 500 Mo 22.07.2024 00:01:10 61.959 +1 3.567.825 57,6 Fosstodon 4.2.10 500 So 21.07.2024 00:01:07 61.958 +1 3.564.861 57,5 Fosstodon 4.2.10 500 Sa 20.07.2024 00:01:10 61.957 +1 3.561.604 57,5 Fosstodon 4.2.10 500 Fr 19.07.2024 13:57:34 61.956 -1 3.558.474 57,4 Fosstodon 4.2.10 500 Do 18.07.2024 00:00:27 61.957 +1 3.553.476 57,4 Fosstodon 4.2.10 500 Mi 17.07.2024 00:01:10 61.956 -1 3.550.157 57,3 Fosstodon 4.2.10 500 Di 16.07.2024 00:00:36 61.957 +6 3.547.999 57,3 Fosstodon 4.2.10 500 Mo 15.07.2024 00:00:01 61.951 0 3.544.794 57,2 Fosstodon 4.2.10 500
Jon R (@saibeaks) · 11/2022 · Tröts: 168 · Folger: 34
Mi 24.07.2024 21:33
Random mini challenge achieved today: given a list about 150 UK addresses, I obtained:
1) a Google map showing site distribution (mainly England, but also Scotland and Wales)
2) a sum of sites, broken down per region (e.g. 30 sites in Greater London, 8 in West Midlands, etc.)
Note: Now I can't seem to find again a simple and straightforward excel formula to obtain a district from a postcode.
#dataparsing #Automation
https://support.google.com/mymaps/answer/3024836?hl=en
https://www.robertsharp.co.uk/2017/08/09/a-table-that-shows-the-uk-region-for-all-postcode-districts/
https://www.mrexcel.com/board/threads/reference-uk-post-code-column-to-create-and-print-country-from-a-reference-table-if-formula-or-vlookup.1247251/
[Öffentlich] Antw.: 0 Wtrl.: 0 Fav.: 0 · via Tusky