For those of you who have missing GPS that RM can not “find”.
I had about 3% missing – so I figured out a way to utilize Excel/Power Query & Google.
This might looks scary to anyone who how not used Power Query in Excel. It also require a Google API Key and for the Google Console to by configured properly (this is the hardest part IMHO)
The script itself is not complicate but not day 1 level script. My Version uses a function call and combine a lookup table and combines to produce a results table.
You do have to be mindful that you are limited the of “free” calls you get per month so you would want to be careful not to make repeated calls on the same data/rows.
Example of the 369 – I looked up – all found results.
I might add I may not agree with how Google is determine the Standard Place Name but it seems to be finding a close GPS location
Might also be interesting one day to explore using the What 3 Words app that has the world mapped in 1m square boxes with a unique series of 3 words. E.G. the Payson Utah Temple is at terminally.rectangular.windows. App and site free to use and I found it great finding and navigating to the driveway of a distant cousin who lives semi-off grid in Canada. The emergency services in the UK use it and it is particularly useful when people get into difficulties in remote areas or on the seas.
I think the Excel system is way too complex for me!
Well Excel itself is fairly intuitive. Power Query might not be depending on use & application. Then there is VBA..,
that very interesting to check out
As far as Power Query you create steps to do thing – in many cases you do NOT need to know any M Code lang which is what runs behind the scenes. The Purpose of Power Query is to ETL – Extract Transform (and) Load. you can do that from almost any source / text, website, table, database or even a PDF.
1 Like
