filmov
tv
Excel for Chemical Engineers I 04 I Basics [doing iterations] (3/10)
Показать описание
This video shows how to use Microsoft Excel to do iterations using the "goal seek" and "solver" tools
*******************************************************
There is a mistake in the function written to calculate v in cell H11
---------------------------------------------------------------------------------------------------------
The equation should be:
(P+a/v^2)(v-b)=RT
which after expansion will be:
Pv^3-(Pb+RT)v^2+av-ab=0
So the right formula in H11 will be:
=H4*H9^3-(H4*I2+H5*H6)*H9^2+H2*H9-H2*I2
The right solution is 205.07344069258 mol/lit.
Sorry for that mistake!
*******************************************************
There is a mistake in the function written to calculate v in cell H11
---------------------------------------------------------------------------------------------------------
The equation should be:
(P+a/v^2)(v-b)=RT
which after expansion will be:
Pv^3-(Pb+RT)v^2+av-ab=0
So the right formula in H11 will be:
=H4*H9^3-(H4*I2+H5*H6)*H9^2+H2*H9-H2*I2
The right solution is 205.07344069258 mol/lit.
Sorry for that mistake!
0:23:33
Excel for Chemical Engineers | 80 | Optimum pipe diameter - 2 Using Ms Excel (1)
0:11:16
Excel for Chemical Engineers I 26 I Macros
0:09:10
Excel for Chemical Engineers | 71 | Microsoft Excel templates
0:14:59
Excel for Chemical Engineers I 31a I If conditional
0:03:50
Excel VBA for Chemical Engineers
0:08:23
Excel for Chemical Engineers l 01 l Intro (1/1)
0:20:04
Excel for Chemical Engineers | 86 | Absorption in packed columns 1
0:12:08
Excel for Chemical Engineers I 32 I Differential Equations (1/3)
0:31:19
VHP Sterilization Validation Procedure Webinar Secrets Revealed!
0:12:24
Excel for Chemical Engineers I 54 I Errors in Microsoft Excel
0:17:58
Microsoft Excel for Chemical Engineers 01 - Simple Calculations & Data Manipulations
0:16:25
Tutorial 1: How to Perform Material Balances in Microsoft Excel
0:09:25
Top 10 Software Used by Chemical Engineers
0:10:44
Excel for Chemical Engineers I 51 I Units conversion
0:07:23
Excel for Chemical Engineers I 55 I Printing tips in Excel
0:20:51
Excel for Chemical Engineers | 86 | Absorption in packed column - 1
0:10:31
Excel for Chemical Engineers I 09 I Basics [Matrices Operations] (8/10)
0:09:57
Excel for Chemical Engineers | 40 | Newton Raphson Method
0:08:53
Excel for Chemical Engineers | 70 | Using hyperlinks in Microsoft Excel
0:10:55
EXCEL VBA/ MACROS FOR CHEMICAL ENGINEERS#1
0:19:30
Excel for Chemical Engineers | 88 | Absorption in packed column - Solved example using Ms Excel 1
0:20:41
Excel for Chemical Engineers | 88 | Absorption in packed column - Solved example using Ms Excel 1
0:13:42
Excel for Chemical Engineers I 02 I Basics Getting to know Excel
0:11:04
Excel for Chemical Engineers I 50 I Merging and splitting cells
Комментарии