Drop Excel files here
Delivery (…KUL3392004), AWB Status, or Station Monitoring files. Tap to choose. You can drop several at once (pt1 + pt2 are combined).
Every file you drop also updates the internal parcel database, so Scan and Parcels can use it.
Scan log
Save a day from a Delivery file
Drop the delivery (database_…KUL3392004) file on the Reports tab first.
Database till today
One station history
One-time closures (holiday, renovation…)
Stations in route order
Order, driver, station code, address matching and opening hours all live here. Reports and the schedule read from this list.
Daily "Not yet Inbound" file (due 12PM)
Upload the Not-yet-Inbound file here every day. It is also added to the parcel database, and each day is saved so you can compare days.
Saved days
Google Sheet link
Two-way sync with your own Google Sheet: parcels, scan log, not-yet-inbound days, #replit days, report texts, stations and the batch list. One tab per data type (NotYetInbound, NYI Summary, Replit, Reports, Parcels, Log, State); rows grouped by day, every other day shaded. Rows older than 90 days are removed there too. Your uploaded Excel files themselves are not stored; their parcels are.
Setup in 4 steps and the script (paste the NEW script and redeploy if you set it up before)
- Open your Google Sheet, then Extensions > Apps Script.
- Delete what is there, paste the script below, and change the SECRET line to a password of your own.
- Deploy > New deployment > Web app. Execute as: Me. Who has access: Anyone. Deploy and allow access.
- Copy the Web app URL and the secret into the boxes above, then press Test connection.
Report history
Every #reform, #recalc, #reduct and #arrival text you run is kept here (and synced).
Storage
Parcels, saved #replit days, Not-yet-Inbound days and the scan log older than this are deleted automatically when the app opens. "Database till today" only covers the days kept.
Backup and restore
Everything is stored on this device only. Make a backup now and then, and before clearing the browser or changing phone.
Notes
Camera scanning needs a secure page (https) or an installed app. If the camera is blocked, use "Scan a photo", or type / use a USB or Bluetooth scanner in the box.