Mass Balancing using Excel Solver
Learn Excel Solver for nonlinear optimization. Apply it to a real-world mineral processing mass balance problem. Practical skills!
Course Content
Mass Balancing using Excel Solver is an intermediate-level Udemy course taught by Stephen Rayward. It runs 1h 49m, is taught in English, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 31 reviews, with 213 students enrolled. It is a paid course, first published March 2023.
Unlock Mineral Processing Optimization with Excel Solver: A Comprehensive Guide
Course Overview
This course provides a practical introduction to using Excel Solver for solving mass balance problems – a fundamental challenge in mineral processing and chemical engineering. Learn how to optimize processes by minimizing the difference between measured and estimated values while adhering to crucial mass conservation constraints. While Excel Solver has limitations, it's an invaluable tool for tackling simple optimization challenges. This course focuses on the core concepts and practical application of mass balancing using Excel Solver, equipping you with skills applicable to a range of mineral processing scenarios.
Section 1: Introduction to Mass Balancing
This section lays the groundwork for understanding mass balance problems and the role of least squares minimization.
- 1.1 Lecture 1: Course & Mass Balancing Overview
- Learn: The core concepts covered in the course: mass balancing and Excel Solver.
- Discover: How mass balancing reconciles plant data for consistency in mineral processing.
- Understand: The role of least squares minimization in solving mass balance problems.
- 1.2 Lecture 2: Understanding Mass Balance Problems
- Learn: The fundamental principle of mass conservation ("what goes in equals what comes out").
- Explore: Common mass balance problems in mineral processing, focusing on ore property measurements.
- Understand: How to address measurement errors and ensure consistent ore flow estimations.
- 1.3 Lecture 3: Least Squares Minimization
- Learn: The principles of least squares minimization and its connection to maximum likelihood theory and regression.
- Explore: Non-weighted and weighted least squares minimization techniques.
- Understand: How least squares minimization is applied to optimize mass balance problems.
Section 2: Mastering Excel Solver for Mass Balance
This section provides hands-on training in using Excel Solver to solve mass balance problems.
- 2.1 Lecture 4: Excel Solver: Advantages & Disadvantages
- Learn: The benefits of using Excel Solver for optimization problems.
- Understand: The limitations of Excel Solver and when alternative methods might be necessary.
- 2.2 Lecture 5: Accessing & Setting Up Excel Solver
- Learn: How to access Excel Solver within Microsoft Excel.
- Understand: The initial steps required to configure Excel Solver for a mass balance problem.
- 2.3 Lecture 6: Applying Excel Solver to Simple Problems
- Learn: How to define an objective function, variables, and constraints within Excel Solver.
- Apply: Excel Solver to solve a basic mass balance problem.
- 2.4 Lecture 7: Two Products Exercise
- Apply: Excel Solver to a more complex mass balance problem involving two products.
- Learn: How to minimize the least squares error in multi-product scenarios.
- 2.5 Lecture 8: Incorporating Water & Solid Flow
- Learn: How to model both water flow and solid flow in mass balance problems.
- Understand: The importance of water flow data for improving solid flow estimations.
- 2.6 Lecture 9: Optimizing Solver Performance
- Learn: Techniques for reducing the number of constraining equations and variables in Excel Solver.
- Understand: How simplifying the problem can improve the convergence of Excel Solver.
Section 3: Advanced Mass Balancing Extensions
This section expands your skills to tackle more complex mass balance problems.
- 3.1 Lecture 10: 1D Mass Balance Problems
- Learn: How to apply mass balance principles to one-dimensional data, such as size distributions and assays.
- Understand: The dimensionality considerations in mass balance modeling.
- 3.2 Lecture 11: 2D Mass Balance Problems
- Learn: Extend mass balance to two-dimensional data (assays within size classes).
- Understand: The increased complexity of mass balance modeling with two dimensions.
- 3.3 Lecture 12: Estimating Solid Flows from Assays
- Learn: Utilize mass balance to estimate unmeasured solid flow values.
- Apply: Mass balance to infer missing variables based on assay data.
- **3.4 Lecture
Want AI in your product? Hire the team behind TutorialSearch.io
LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.