This would have taken an enormous amount of work. Well done.
It's interesting to compare to equivalent projects in the US: see, eg,
Reasonable Redemption Values (RRVs).
It's striking that, as you note, this chart doesn't include Qantas' upcoming devaluation, which will drop their value. With that next drop, Qantas points will start to get very close to Classic Plus (1.5c/pt in premium cabins). As I've mentioned elsewhere, it means Qantas has solved the award availability problem — by devaluing points so much that Classic Plus basically reflects what they're worth!