Sussex wrote:
Got to love this spreadsheet.
Shows that Wolverhampton have 47 PH vehicles for every 1000 people in their licensing district.
https://assets.publishing.service.gov.u ... xi0105.odsDon't know if these are new figures the DfT are producing, but if they were meaningless enough before then the cross-border thing maybe makes you wonder why they're producing them at all, unless they're simply trying to highlight the absurdity of it all.
Anyway, I've been looking at a slightly older spreadsheet with slightly different numbers on it for a couple of years now, just for looking up the odd figure that might be of interest.
But one annoying thing was that when you scroll down the columns, the headings disappear, so when you're near the bottom it's often not easy working out what each number is all about.
Which I thought was odd, because you can freeze the column headings so they don't disappear as you scroll down the spreadsheet. Couldn't be bothered looking up how to do it until now, but for anyone who doesn't know, it's really quite easy. If you're using OpenOffice, just click on the number 8 on the left of the spreadsheet. That should highlight the whole of row 8.
Then go to the Window menu, then select freeze. That should mean the column titles will stay at the top as you scroll down the spreadsheet, so it's easier to work out which number is which
Only thing is, you can't save it that way, so every time you open the spreadsheet you have to freeze the titles again. Which is presumably why the DfT haven't frozen them permanently.
(When I used Excel years and years ago, I think you could freeze the titles then save it that way, so the titles would still be frozen when you reopened it, but that doesn't seem to be an option with OpenOffice. Although it might be to do with the fact that the spreadsheet is read-only, so maybe you can freeze the titles, but you can't save it
)