If I have a spreadsheet with a column of room numbers, say from values like D1, D2...D10, D11 etc, how can I sort the sheet in that order? In LibreOffice Calc I set "Enable natural sort" which does it, but I don't see similar for MS Excel. Word on the web looks like you have to get the numbers out with a formula and sort on that. Really? I don't have Excel to hand so if anyone does...
Barry Rowlingson
@geospacedman
- 987 Followers
- 213 Following
- 5.4K Posts
Maps, statistics, guitars, land rovers, photography.
Oh this looks like a fun bug. If I include certain rows the whole return from osrmTable changes. Oh look its the weekend.
Why does osrmRoute return km distances and osrmTable return metres? [slams head on table]
Kevin BeaumontKPMG issued a report citing all the transformational ways GenAI has transformed industry, it’s been widely cited.
One minor problem: it turns they used AI to write the report, and it made up all of the evidence.
KPMG have now withdrawn the report in full.
https://www.ft.com/content/b3828e92-4961-4b39-84f0-c42f33be3c3f
Some R/osrm CPU performance notes for doing all pairwise routes: naively looping over rows of two sf objects: R 70% CPU hogging, osrm server gets 30%; convert sf to lat-long coordinate matrix and do pairwise routing: R 30%, osrm 70%; use osrmTable to do 100x100 chunks: R: 1% osrm: 99%.
My Hobby/Academic Retirement Fund: Going through every hardback PhD thesis in the library harvesting the £5 from those smart alecs who put envelopes in them with "Here's £5 for being the first person to check out my thesis".
Sean Gillies
Yeah everything is there in the Peru extract from GeoFabrik but loads have gone when I cropped it to Lima. Used "osmium extract --strategy complete_ways --bbox $LIMA peru-latest.osm.pbf -o lima.osm.pbf" Was that strategy option wrong?
Maybe I've got an old extract. There's loads of features on the current OSM basemap that aren't in my PBF...
