6 posts
re Re: Raw meal to clinker ratio
Dear Sir
How to Do Raw mix design/calculation for more than 3 and more components in excel
Know the answer to this question? Join the community and register for a free guest account to post a reply.
537 posts
re Re: Raw meal to clinker ratio
Hello Ravi,
There are two ways to do this;-
1. Using simultaneous equations.
or
2. Using the Solver function in Excel
Using the Solver function in excel is the easiest. (See the attached simple solver spreadsheet).
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.
Hope this helps,
Regards,
Ted.