In trying to put together a new system I have been scrutinizing the HCL to try and reduce the chances that I buy something that wont work.
I doing so I was reminded that while the qubes-hcl-report seems to collect separate brand, model, CPU, chipset, graphics, many of those feilds are grouped together under “model”. I have no idea how the HCL is put together at the moment (I hope its at least somewhat automated) but I think it would really really really be helpful if some of the information could be placed in different fields - and a pivot table would be awesome especially as the list gets longer).
This is not to say its not appreciated, its most certainly is, but a few more fields and a pivot table option would be great.
The HCL gets automatically generated from YML files submitted by community members and stored in this GitHub repository. I am not familiar with the mechanism or web programming techniques. However a quick search shows there are plenty of tools to concert YML to CSV.
I suggest you get one of those tools, checkout the repository and generate a CSV file. It will contain all the fields of the YML file and you can then do spreadsheet magic until the cows come home.
Extra points: IF you do this successfully, please post a short howto.