I don’t think that the response above is hitting what the OP was asking for. I have a spreadsheet that utilizes a google sheet add-on called Linear Optimization. You tell the config sheet what you need and what each ore gives you it then can calculate the best way to get to the required materials. There is some tweaking you need to do in order to get the minimal waste product but I have been working on this sheet for a few days and I am happy with the outcome.
I will help you create your own sheet if this is what you are referring to in your post. I have it so you can choose a ship (Capital or T1) and that references my database on build materials, sums it all up after calculating the ME level on the BP’s and dumps the required totals of minerals. You then go to the calculations page (Linear Optimization) and it will then tell you how many units of compressed ores you need to reach your goal.
If this is something you are after I will help create it with you from the information I have forged together on my sheet. I would just give you mine but it is not the most user friendly and may layouts are often disliked 