I’ve downloaded the latest bus fleet data, dated 30 September 2017, file fleet-online-operational-vehicle-data.xlsx, from https://tfl.gov.uk/corporate/publications-and-reports/bus-fleet-data-and-audits
Using the arrival predictions API I use the reg number of the bus to look up the fleet data to find out if it is a single or double decker. The route from the spreadsheet doesn’t match the API though. For example LX09AZC due to arrive at 490007016S is route 200 but the fleet data says route 163.
How can I be confident the rest of the data is valid?