Excel Solver is a powerful tool for engineering optimization. This tutorial shows how to solve a simple benchmark problem with an objective function, inequality constraint, and an equality constraint.
Пікірлер: 15
@upasanapadhi84196 жыл бұрын
Thank you! Its very useful.
@CNCPRINTBLOGSPOT Жыл бұрын
very good!
@tyishayoung59537 жыл бұрын
love challenges classic problems.
@mkall5 жыл бұрын
very helpful
@bim_engineer_structural7 жыл бұрын
Good
@Modhumitamondal5 жыл бұрын
Nice info
@akshaysunil28524 жыл бұрын
can we use this solver tool for dynamic programming in excel'
@apm4 жыл бұрын
Yes, you could use it but only for simple cases such as this Excel example: apmonitor.com/pdc/index.php/Main/VehiclePredictiveControl This course teaches tools in Matlab and Python that are much more capable: apmonitor.com/do/
@dineshkumarsaw81434 жыл бұрын
can we solve 5 simultaneous linear equation with excel solver?
@apm4 жыл бұрын
Yes, linear equations are easy: apmonitor.com/che263/index.php/Main/ExcelSolveEquations
@dineshkumarsaw81434 жыл бұрын
@@apm ohh sorry sir its 5 simultaneous non linear equation with variable on both side of equality for example a=1/a+1.2/b+1/c +3/c +1/d+ 2/e b=1/a+1.2/b+ 1/c +3/c +1/d++ 2/e ................................... e=1/a+1.2/b+ 1/c +3/c +1/d++ 2/e can this type of equation can be solved using excle?
@donblackwell55646 жыл бұрын
Did not see the file for dowmloading
@donblackwell55646 жыл бұрын
Had to use the search bar
@apm6 жыл бұрын
I'm glad that you found it. You can also visit the page apmonitor.com/che263/index.php/Main/ExcelSolver