MANIPAL UNIVERSITY JAIPUR
DEPARTMENT OF BIOTECHNOLOGY AND CHEMICAL
ENGINEERING
SIMULATION LAB-1(BIT2130 & CHE2131)
YEAR-II, 3RD SEMESTER, 2024
EXPERIMENT #4
Process Calculations in excel
Instructor: Dr. Satya Prakash
Submitted by: Charulata Choudhary
Experiment carried on: 25/09/24
Report submitted on: 16/10/24
EXECUTIVE SUMMARY (10) _______
INTRODUCTION/OBJECTIVES/SCOPE/PROCEDURE (30) _______
RESULTS & DISCUSSION (30) _______
CONCLUSIONS (5) _______
REFERENCES (5) _______
APPENDIX
a) Original data/Sample calculations/other information (5) _______
GENERAL COMPLETENESS
a) Conciseness and neatness _______
(5) Submission on due date (10) _______
Total(100) _______
1
Table of Contents
EXECUTIVE SUMMARY 3
OBJECTIVE 4
METHODOLOGY 4-7
RESULTS & DISCUSSIONS 7
REFERENCES 7
2
EXECUTIVE SUMMARY
We used solver and goal seek tools in Microsoft Excel to solve
complex equations and to find unknows values. Goal seek uses a
trial and error approach to find specific value by adjusting
dependant values.
Solver is a more advanced tool that determines the values
needed in multiple input cells to achieve a desired result
3
4.1.1 Objective
To efficiently use excel for various process calculations that
involves using solver and goal seek
4.1.2 Methodology
Data fitting using least square method
Microsoft Excel proved to be very effective in curve fitting, but it
does so for five forms of equations which were mentioned
previously. If the equation that you need to fit your data to is not
one of these five forms, then Microsoft Excel will not be able to fit
your data automatically using the Trendline option.
4
This tool can change the value of multiple cells to set the value of
ONLY ONE cell to a maximum, minimum or a specific value. And
we need now to change the value of the three cells (a, b and c) to
set the values of 13 cells to zero, which is not available using this
tool. A trick can be done to avoid this problem. If the sum of the
differences is calculated and then is set to the value of zero then
consequently the values of all the 13 cells will be minimized, so a
cell for the sum values in the last column is set and calculated.
And is now the cell that will be set to zero. But remains a small
5
problem, you may notice that some of the values in the last
column are positive and some are negative, so the summation
may be zero but the entire cells in the column may not be zeros.
So a new column is added where the SQUARES of the values of
the difference column are calculated, so all the values will be
positive and this problem is no longer present. And why this
method is called Least Square Method. Finally the table will have
the form: Now
6
4.1.3 RESULT AND DISCUSSION
Using the solver and goal seek tool, we can solve complex
process calculation problems in Microsoft Excel.
Solver is used to find optimal solutions for decision problems.
Goal seek helps us to find the value needed to achieve a specific
goal in a formula. It is used to mainly to solve equations.
4.1.4 REFERENCES
Online tutorials from websites like Coursera, edX, and Khan
Academy.
Microsoft Office Excel Documentation - Microsoft Office Support
7
8
