Raw mix design/calculation for more than 3 components in excel
To use the spreadsheet change the names and chemical analyses of the raw materials to whatever you want. Then enter whatever raw meal targets you want for LSF, SR and AR in column G, lines 15,16 & 17.
To solve the raw mix, click on the Data tab at the top of the excel screen and choose Solver (in the Analysis group). Then click the Solve button in the window that pops up, followed by the Okbutton in the Solver Results pop-up.