Fundamentals of Distillation Technology / Design of Distillation Columns and Calculation Methods Using Excel
S20506
A thorough explanation of techniques to dramatically increase the efficiency of distillation technology calculations by understanding Excel's features!
**Lecture Summary** This lecture will explain the application of Excel in distillation technology calculations. By using Excel's Goal Seek, one can obtain solutions to equations without creating any programs. This will be utilized for boiling point calculations in vapor-liquid equilibrium calculations. It will also be used to solve state equations to determine the compressibility factor of real gases. In distillation technology calculations, many empirical formulas are used, and Excel provides functions for the least squares method, making it easy to determine these empirical formulas. Furthermore, by using matrix operation functions, it is possible to solve simultaneous equations, allowing for the determination of coefficients for empirical formulas of second degree or higher. Excel has a convenient feature called macro recording. By using this, one can record operations to obtain various solutions and create macros (VBA). By modifying these macros, the efficiency of distillation technology calculations can be dramatically increased. Knowing how to utilize Excel's features can make a significant difference.
Inquire About This Product
basic information
Venue Tokyo Metropolitan Chuo Ward Industrial Hall 4F, Meeting Room 3 [Tokyo, Chuo Ward] - Toei Asakusa Line, Higashi-Nihonbashi Station, 4 minutes from B3 exit towards Asakusabashi/ Oshiage - Toei Shinjuku Line, Bakuroyokoyama Station, 5 minutes via underground passage from B4 exit Date and Time May 30, 2012 (Wednesday) 13:30-16:30 Keywords 1. Distillation technology 2. Vapor pressure 3. Gas-liquid equilibrium 4. Distillation calculations 5. Design of trays for distillation columns 6. Design of packing for distillation columns 7. Pressure loss 8. Flooding 9. Theoretical stages 10. Excel 11. Goal seek 12. Excel macros
Price information
【Early Bird Discount Price】46,200 yen (including tax and text fees) for 2 participants from one company. After May 16, the 【Regular Price】 will be 49,350 yen (including tax and text fees) for 2 participants from one company.
Price range
P2
Delivery Time
P2
Applications/Examples of results
**Program** 1. Effective Excel functions for distillation technology calculations 2. Physical property calculations using Excel 2-1. Calculation of ideal gas density essential for distillation column design 2-2. Calculation of real gas density essential for distillation column design Soave-Redlich-Kwong equation 2-3. Determination of specific heat (heat capacity) calculation formula 2-4. Determination of latent heat of vaporization calculation formula 2-5. Determination of vapor pressure calculation formula 2-6. Antoine equation calculations 2-7. Method to estimate vapor pressure from boiling point data only 3. Vapor-liquid equilibrium calculations using Excel 3-1. Ideal solution - Raoult's law Simplified calculation method using relative volatility Boiling point calculation method, dew point calculation method 3-2. Non-ideal solution Calculations using the Wilson equation Vapor-liquid equilibrium calculations for completely insoluble systems Calculation of salt effects in vapor-liquid equilibrium 4. Distillation calculations using Excel 4-1. Number of theoretical stages in continuous distillation of a two-component system 4-2. Minimum reflux ratio for multi-component systems 4-3. Minimum number of theoretical stages for multi-component systems 4-4. Theoretical stages for multi-component systems 1 (Gilliand's correlation) 5. Design of distillation columns using Excel 5-1. Design method for tray columns 5-2. Design of packed columns **[Q&A, Business Card Exchange]**
News about this product（1）
Company information
Our company has developed its business from "seminar planning" to various forms such as "lecturer dispatch," "publishing planning," "technical consultant dispatch," "trend research," "business matching," and "business development consulting," in order to support clients in a wide range of fields including chemistry, electronics, automotive, energy, medical devices, food, and building materials. By doing so, we have advanced our company and opened up new markets. AndTech promises to continue listening to our clients' voices, entering the business areas and markets they desire, and to remain a company that is loved by our clients, as we share their challenges, think together, and forge new paths.