Route Optimizer · version 2.1.0 · Android

Plan the day's stops with no signal.

Load a spreadsheet of stops, get the best order to visit them, and go. Everything runs on the phone. There is no account and no server, and your spreadsheet never leaves the device.

Passed airplane-mode test in emulator · beta

The browser version is the same app. Your file is read in your browser and nothing is uploaded. Routes you save stay in this browser. Need a file to try? Download sample-stops.csv

// How it works

Four steps, all on the device

These are real screens from version 2.1.0, captured from the app's browser build with networking turned off.

Import screen showing a spreadsheet read on the device, with 7 locations found and the detected columns listed.
1. Import your stopsPick a CSV or Excel file. The app finds the latitude and longitude columns and reads the file on the phone.
Map screen showing 8 numbered stops joined by a route line on a plain grid, with a note that says no signal, street map unavailable, route still shown.
2. OptimizeOne tap puts the stops in an efficient order. With no signal, the route draws on a grid and the app tells you why.
Stop list showing each stop in order with the distance and time from the previous stop and running totals.
3. Check and reorderSee the distance and time for each leg. Drag stops into a different order and the totals update.
Share dialog offering PDF, CSV and Route File, with a note that it shares a file so no internet is needed.
4. Save and shareSave the route on the phone. Send it as a PDF, a CSV, or a route file another phone can import.
// The offline list

What works with no signal

● Works offline● Needs a connection

FeatureOfflineNotes
Import stops from CSV or Excel● YesReads .csv, .xlsx and .xls on the phone. The file is never uploaded.
Optimize the route● YesRuns on the device. Distances are straight-line estimates.
Drag to reorder stops● YesDistance and time totals update as you go.
Set your start from GPS● YesGPS works without mobile data. A first fix can take a minute under open sky.
Fuel cost estimate● YesFrom your vehicle's MPG and the price per gallon.
Spoken stop announcements● YesUses the phone's built-in voice.
Save and reload routes● YesStored on the device only.
Share as PDF, CSV or route file● YesThrough the share sheet: email, Bluetooth, nearby sharing or a cable.
Import a shared route file● YesThe file is checked and its totals are recalculated on your phone.
Map with stops and route line● YesDraws on a plain grid when there is no signal.
Street-map background● SignalMap images are downloaded from OpenStreetMap or CARTO as you view them.
Turn-by-turn navigation● SignalHands off to Google Maps, which has its own offline maps.
// Your spreadsheet

What the file needs

One row per stop, with a latitude column and a longitude column. Headers such as Lat, Latitude, Lon, Lng and Longitude are found automatically.

Required

Latitude and longitude, as decimal numbers. Rows with missing or invalid coordinates are skipped, and the app tells you how many.

Optional

A name column and an address column. Any other columns are kept with each stop.

Try the sample

Seven made-up stops in the right format. Download sample-stops.csv

// How we checked it

What has been tested, and what hasn't

  1. 23 automated tests passThey cover the route math, spreadsheet reading, saved-route storage and shared route files.
  2. An independent automated code reviewIt found four problems, including one that could have erased saved routes. All four were fixed before it passed the build.
  3. A full run with networking turned offImport, optimize, map, save, share and re-import all worked in the app's browser build. The only thing it reached for was the street-map background.
  4. The Android build, in airplane modeRun in an Android emulator with airplane mode on: CSV and Excel import, GPS start, optimize, map, save, restart, share and route-file import all passed. That run first caught three problems the browser could not show, including sharing that failed and a location request that needed the network. All three were fixed.
  5. Still to do: a physical phoneThe same run has not yet been done on a real handset. Dragging to reorder and spoken announcements were not part of the emulator run.

Good to know: distances are shown in miles and are straight-line, so real driving distance will be longer. Times use an average speed you can change in Settings.

// Help test it

Want to try it on your routes?

We are looking for a few people who drive multi-stop days in low-signal areas.

✉ jbg@jbgbotology.com