I am looking to calculate in Excel the amount of compressed ore needed to fulfill X minerals.

It can be either null or high sec materials.

I know there is a method using solver but it might be beyond my knowledge to make it work on this scale.

I also know there are websites that can calculate this but want to add it to my spreadsheet for manufacturing,

Can any one help with this one?