I'm guessing there will probably be around the same amount of people reading this thread as will delve into the nitty gritty of the DfT's various stats and spreadsheets. Thus very few people indeed
But here's my attempt to reconcile the new TP stats (TP = Taxi Plus or Taxi Point - take your pick) to the DfT's numbers for 'fuel class'. Which is obviously quite an important topic these days. And more difficult to provide figures than when cars in the trade were either petrol or diesel, and no real ambiguity between the two.
And it's maybe more a case of 'comparing' them rather than 'reconciling' them, because the TP and DfT stats are in completely different ball parks, as a quick glance at the TP tables above will demonstrate to the vast majority within the trade, even without looking at the DfT stats
First issue is that the DfT stats are as at 31 March 2024. I think TP's survey launched in mid-July and ran for ten weeks, but presumably most of the responses would have arrived early in the survey period.
Anyway, there's still a gap of several months between the two, and there's not a lot that can be done about that. Of course, the general trend in the trade is away from fossil fuels and towards hybrids and EVs etc, so to the extent that the TP survey numbers show more of the latter than the DfT's, then the few months' gap between the two might explain the difference. But only 'part' of the difference, surely, because the basic numbers are too far apart to be explained by a couple of months between the two sets of figures.
However, there are a couple of more important reasons it's difficult to compare the two.
First, TP uses three categories for 'fuel class', while the DfT uses seven
However, I think it's probably straightforward enough just to add the DfT's categories together and then compare them to TP's categories and numbers. But, for the avoidance of doubt, this is how I've compared the categories between the two surveys.
And here again are the graphics showing the TP categories, and the DfT categories (here for just HCs):


TP - 'Fossil fuel'
DfT - 'Petrol' and 'diesel' - not a lot of room for doubt there, surely?
TP - 'Hybrid'
DfT - Here I've added together the DfT's 'hybrid electric', 'plug-in hybrid electric' and 'range extended electric'. The latter seem to be the LEVCs mainly in London, and at a rough guess I'd have assumed they'd be the same as 'plug-in hybrid electric'. But clearly not, at least as far as the DfT are concerned. But they're surely not what TP calls 'full electric' either, so presumably TP would include them in their hybrid category. (But because London is something of an odball - as explained earlier - they're not included in the analysis below. And because 'range extended electric' are negligible outside of London, there's not really any potentially statistically significant issue with just adding them into the general 'hybrid' category for comparison purposes.) The DfT also has another column labelled 'other' not shown in the extract above, and that may be the gas, hydrogen fuels and suchlike. But the numbers are tiny, so I've just added them to the DfT's other hybrid and similar categories.
TP - 'Fully electric'
DfT - 'Battery electric'
I'm assuming those two are simply the same thing, and thus like the fossil fuels category it's pretty unambiguous. And elsewhere in the DfT's stuff they say: "battery electric: this includes fully electric vehicles only". So I think it's fair to assume that those figures are comparing the same thing in both the TP and DfT - what we'd maybe just call EVs.
So basically TP's categories of 'Fossil fuels' and 'Fully electric' are pretty easy to compare to the DfT stats. All the other DfT categories I've added together to compare to TP's 'Hybrid' column above. There may be some oddballs like hydrogen and gas, but the numbers don't really look significant (accept for maybe the West Midlands, which shows 2.6%/2.7% in the DfT's 'other' column for HCs and PHVs respectively. Could they be gas powered? Yorkshire and Humber also feature in that same category as over 1% for both HCs and PHVs, but apart from that the figures from all the other regions in that 'other' category are miniscule.
So, essentially, the first major issue when comparing TP to DfT is how they categorise the 'fuel type'. The second major problem is that the TP table above doesn't differentiate HC and PHV - it's presumably just an amalgam of the two codes in each region.
On the other hand, the DfT provides separate stats for HC and PH. And it's not simply a case of taking an average of the two - for example, if in region A HCs are 70% fossil fueled and PHVs 80% fossil fueled, you can't just say that for region A the average is 75% fossil fueled between the two codes. The reason why you can't do that should be obvious from the table below, which I've compiled using the DfT summary stats:

So the problem with simply averaging the two percentage figures for HCs and PHVs should be obvious - in each region HCs are always outnumbered by PHVs, and thus simply averaging the two figures would be misleading. This should be most obvious in the case of the obvious imbalance in the West Midlands - if, for example, HCs there were 80% fossil fueled, but PHVs were just 40% fossil fueled, it would be misleading to say that over the two codes the average was 60%, because the vast majority of cars are PHVs
So instead a
weighted average should be used to reflect the ratio of HC to PHVs. So suppose HCs are 80% fossil fueled and comprise 10% of the combined fleet. And PHVs are 40% fossil fueled and comprise 90% of the combined fleet. The average fossil fueled over the two codes
isn't 60%, and intuitively it looks like it might be a bit less than 45% or so. In actual fact, crunching the numbers provides the weighted average of bang on 44% - ((90% x 40%) + (10% x 80%))
But, basically, that's how the figures that will follow have been collated from the DfT's stats to compare them to the TP survey, and I'll post the actual figures over the weekend.
And, by the way, no prizes for guessing why the HCs in the West Midlands comprise only 8% of the combined licensed fleet - it's not so much that HC numbers are especially low, but because one particular council in that area licenses a huge shedload of PHVs
In fact, the HC proportion would probably be quite low anyway, because the West Midlands is a very urban/metropolis type of area, where HC numbers tend to be quite tightly controlled, and the market is served largely by PHVs (Birmingham, Coventry, Wolverhampton, Dudley, Solihull, Walsall, Sandwell, Stoke...), but you-know-where is certainly a further distorting factor.
Note that the next lowest ratio at 14% HCs is Yorkshire and the Humber - it's got similarly urban cities and metropolis-type areas like Leeds, Bradford, Hull, Sheffield, Wakefield, Kirklees (Huddersfield, mainly), Doncaster, Rotherham, Barnsley, Calderdale (Halifax, mainly), blah, blah.
(In fact if you drill down further, the proportion of HCs in some of those places is tiny - 4% or so in Bradford. Indeed it's likely to be even lower than that in reality in view of presumably a significant number of PHVs operating there but licensed you-know-where

)
The only other region with HCs below 20% of the total fleet is the North West - that's Merseyside, Greater Manc, Wigan, Warrington, Blackburn, blah, blah.