I'm working on a spreadsheet to track how many delivery vans I've loaded each day.
The loading sheets have barcodes at the bottom which I scan into my table. They're in the format T<trip><date_as_yyyymmdd>V<van_number>, i.e. T001A20221024V101.
At work the people on the desk have a spreadsheet...