Trying to build a reprocessing spreadsheet

My plan is to build a gdoc spreadsheet on which I input a combination of minerals, and that will output a combination of compressed ores to buy, aiming for an as low as possible cost to fullfill the mineral requirement. The ultimate goal of this is to be able to produce ships where I’m losing them to not spend godawful hours shipping them around.

I’m not going for anything fancy, it’s ok if it doesn’t find the most optimal solution, it just got to be close enough. I have a good idea of how I’ll do this but I’m lacking the required datas.

I need an exhaustive list of compressed ores along their typeIDs and what they reprocess into so I can fetch market prices and get my sheet to work, however I failed after trying for a few hours. I managed to scrap some of the compressed ores’ typeID from the invType.xls file found on Fuzzwork but it seems to be non-exhaustive as it lacks all X-grade variants.

I’ve also checked EVE’s SDE but the yaml and jsonl are alien to me, I’m not really tech savvy and only get the very basics of JS, and I don’t even know if everything’s in there.

I’ll appreciate any advice on that quest, as I said I’m not tech savvy but this is rather fun.