Download or read book Numerical Calculations for Process Engineering Using Excel VBA written by Chi M. Phan and published by CRC Press. This book was released on 2023-12-01 with total page 159 pages. Available in PDF, EPUB and Kindle. Book excerpt: Numerical Calculations for Process Engineering Using Excel VBA provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets. The problems are solving material and energy balances, optimising reactors and modelling multiple-factor processes. The book includes both basic and advanced codes for numerical calculations. The basic methods are presented in different variations tailored to particular applications. Some macros are combined with each other to solve engineering problems. Examples include combining the bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler’s method to optimise a reactor and combining bisection code and Euler’s method to solve steady-state heat distribution. The text also includes nonconventional examples such as harmony search and network analysis. The examples include solutions to common engineering problems such as adiabatic flame temperature, plug flow reactor conversion, batch reactor, heat diffusion and pinch analysis of heat exchanger networks. The VBA code is presented with mathematical equations and flowcharts, enabling the audience to adopt the solutions to different problems. The book contains many demonstrations of numerical techniques to guide users. It also includes useful summaries of VBA commands/functions and Excel-predefined functions accessible in VBA. While the book is developed primarily for undergraduate students, the book is a helpful resource for postgraduate students and engineers.

Download or read book Numerical Methods for Chemical Engineers Using Excel VBA and MATLAB written by Victor J. Law and published by CRC Press. This book was released on 2013-03-05 with total page 249 pages. Available in PDF, EPUB and Kindle. Book excerpt: While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic for Applications (VBA). This led to six years of developing teaching notes that

Download or read book 32nd European Symposium on Computer Aided Process Engineering written by Ludovic Montastruc and published by Elsevier. This book was released on 2022-06-30 with total page 1760 pages. Available in PDF, EPUB and Kindle. Book excerpt: 32nd European Symposium on Computer Aided Process Engineering: ESCAPE-32 contains the papers presented at the 32nd European Symposium of Computer Aided Process Engineering (ESCAPE) event held in Toulouse, France. It is a valuable resource for chemical engineers, chemical process engineers, researchers in industry and academia, students and consultants for chemical industries who work in process development and design. - Presents findings and discussions from the 32nd European Symposium of Computer Aided Process Engineering (ESCAPE) event

Download or read book Excel for Scientists and Engineers written by E. Joseph Billo and published by John Wiley & Sons. This book was released on 2007-03-16 with total page 480 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Download or read book A Step by Step Approach to the Modeling of Chemical Engineering Processes written by Liliane Maria Ferrareso Lona and published by Springer. This book was released on 2017-12-15 with total page 183 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book treats modeling and simulation in a simple way, that builds on the existing knowledge and intuition of students. They will learn how to build a model and solve it using Excel. Most chemical engineering students feel a shiver down the spine when they see a set of complex mathematical equations generated from the modeling of a chemical engineering system. This is because they usually do not understand how to achieve this mathematical model, or they do not know how to solve the equations system without spending a lot of time and effort. Trying to understand how to generate a set of mathematical equations to represent a physical system (to model) and solve these equations (to simulate) is not a simple task. A model, most of the time, takes into account all phenomena studied during a Chemical Engineering course. In the same way, there is a multitude of numerical methods that can be used to solve the same set of equations generated from the modeling, and many different computational languages can be adopted to implement the numerical methods. As a consequence of this comprehensiveness and combinatorial explosion of possibilities, most books that deal with this subject are very extensive and embracing, making need for a lot of time and effort to go through this subject. It is expected that with this book the chemical engineering student and the future chemical engineer feel motivated to solve different practical problems involving chemical processes, knowing they can do that in an easy and fast way, with no need of expensive software.

Download or read book Separation Process Engineering written by Phillip C. Wankat and published by Pearson. This book was released on 2022-10-24 with total page 2107 pages. Available in PDF, EPUB and Kindle. Book excerpt: The Definitive, Learner-Friendly Guide to Chemical Engineering Separations--Extensively Updated, Including a New Chapter on Melt Crystallization Efficient separation processes are crucial to addressing many societal problems, from developing new medicines to improving energy efficiency and reducing emissions. Separation Process Engineering, Fifth Edition, is the most comprehensive, accessible guide to modern separation processes and the fundamentals of mass transfer. In this completely updated edition, Phillip C. Wankat teaches each key concept through detailed, realistic examples using actual data--with up-to-date simulation practice, spreadsheet-based exercises, and references. Wankat thoroughly covers each separation process, including flash, column, and batch distillation; exact calculations and shortcut methods for multicomponent distillation; staged and packed column design; absorption; stripping; and more. His extensive discussions of mass transfer and diffusion enable faculty to teach separations and mass transfer in a single course. And detailed material on liquid-liquid extraction, adsorption, chromatography, and ion exchange prepares students for advanced work. New and updated content includes melt crystallization, steam distillation, residue curve analysis, batch washing, the Shanks system for percolation leaching, eutectic systems, forward osmosis, microfiltration, and hybrid separations. A full chapter discusses economics and energy conservation, including updated equipment costs. Over 300 new and updated homework problems are presented, all extensively tested in undergraduate courses at Purdue University. New chapter on melt crystallization: solid-liquid phase equilibrium, suspension, static and falling film layer approaches, and 34 questions and problems New binary VLE equations and updated content on simultaneous solutions New coverage of safety and fire hazards New material on steam distillation, simple multi-component batch distillation, and residue curve analysis Expanded discussion of tray efficiencies, packed column design, and energy reduction in distillation New coverage of two hybrid extraction with distillation, and the Kremser equation in fractional extraction Added sections on deicing with eutectic systems, eutectic freeze concentration, and scale-up New sections on forward osmosis and microfiltration Expanded advanced content on adsorption and ion exchange including updated instructions for eight detailed Aspen Chromatography labs Discussion of membrane separations, including gas permeation, reverse osmosis, ultrafiltration, pervaporation, and applications Thirteen up-to-date Aspen Plus process simulation labs, adaptable to any simulator This guide reflects an up-to-date understanding of how modern students learn: designed, organized, and written to be exceptionally clear and easy to use. It presents detailed examples in a clear, standard format, using real data to solve actual engineering problems, preparing students for their future careers.

Download or read book Chemical Process Engineering Volume 2 written by A. Kayode Coker and published by John Wiley & Sons. This book was released on 2022-06-20 with total page 948 pages. Available in PDF, EPUB and Kindle. Book excerpt: CHEMICAL PROCESS ENGINEERING Written by one of the most prolific and respected chemical engineers in the world and his co-author, also a well-known and respected engineer, this two-volume set is the "new standard" in the industry, offering engineers and students alike the most up-do-date, comprehensive, and state-of-the-art coverage of processes and best practices in the field today. This new two-volume set explores and describes integrating new tools for engineering education and practice for better utilization of the existing knowledge on process design. Useful not only for students, university professors, and practitioners, especially process, chemical, mechanical and metallurgical engineers, it is also a valuable reference for other engineers, consultants, technicians and scientists concerned about various aspects of industrial design. The text can be considered as complementary to process design for senior and graduate students as well as a hands-on reference work or refresher for engineers at entry level. The contents of the book can also be taught in intensive workshops in the oil, gas, petrochemical, biochemical and process industries. The book provides a detailed description and hands-on experience on process design in chemical engineering, and it is an integrated text that focuses on practical design with new tools, such as Microsoft Excel spreadsheets and UniSim simulation software. Written by two of the industry's most trustworthy and well-known authors, this book is the new standard in chemical, biochemical, pharmaceutical, petrochemical and petroleum refining. Covering design, analysis, simulation, integration, and, perhaps most importantly, the practical application of Microsoft Excel-UniSim software, this is the most comprehensive and up-to-date coverage of all of the latest developments in the industry. It is a must-have for any engineer or student’s library.

Download or read book Ludwig s Applied Process Design for Chemical and Petrochemical Plants Incorporating Process Safety Incidents written by A. Kayode Coker and published by Elsevier. This book was released on 2024-06-08 with total page 1328 pages. Available in PDF, EPUB and Kindle. Book excerpt: Ludwig's Applied Process Design for Chemical and Petrochemical Plants Incorporating Process Safety Incidents, Fifth Edition, Volume One is ever evolving and provides improved techniques and fundamental design methodologies to guide the practicing engineer in designing process equipment and applying chemical processes to properly detailed hardware. Like its predecessor, this new edition continues to present updated information for achieving optimum operational and process conditions and avoiding problems caused by inadequate sizing and lack of internally detailed hardware. The volume provides both fundamental theories, where applicable, and direct application of these theories to applied equations essential in the design effort. This approach in presenting design information is essential for troubleshooting process equipment and in executing system performance analysis. Volume 1 covers process planning, flow-sheeting, scheduling, cost estimation, economic factors, physical properties of liquids and gases, fluid flow, mixing of liquids, mechanical separations, process safety, pressure-relieving devices, metallurgy and corrosion, and process optimization. The book builds upon Ludwig's classic text to further enhance its use as a chemical engineering process design manual of methods and proven fundamentals. This new edition includes new content on three-phase separation, ejectors and mechanical vacuum systems, process safety management, HAZOP and hazard analyses, and optimization of chemical process/blending. ? Provides improved design manual for methods and proven fundamentals of process design with related data and charts? Covers a complete range of basic day-to-day petrochemical operation topics. Extensively revised with new materials on Non-Newtonian fluids, homogeneous and heterogeneous flow, and pressure drop, ejectors, phase separation, metallurgy and corrosion and optimization of chemical process/blending? Presents many examples using Honeywell UniSim Design software, developed and executable computer programs, and Excel spreadsheet programs? Includes case studies of process safety incidents, guidance for troubleshooting, and checklists? Includes Software of Conversion Table and 40+ process data sheets in excel format

Download or read book Fourth International Conference on Foundations of Computer Aided Process Design written by Lorenz T. Biegler and published by . This book was released on 1995 with total page 392 pages. Available in PDF, EPUB and Kindle. Book excerpt: This work contains edited papers from the Fourth Conference on the Foundations of Computer-aided Process Design.

Download or read book Option Pricing Models and Volatility Using Excel VBA written by Fabrice D. Rouah and published by John Wiley & Sons. This book was released on 2012-06-15 with total page 456 pages. Available in PDF, EPUB and Kindle. Book excerpt: This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book. Praise for Option Pricing Models & Volatility Using Excel-VBA "Excel is already a great pedagogical tool for teaching option valuation and risk management. But the VBA routines in this book elevate Excel to an industrial-strength financial engineering toolbox. I have no doubt that it will become hugely successful as a reference for option traders and risk managers." —Peter Christoffersen, Associate Professor of Finance, Desautels Faculty of Management, McGill University "This book is filled with methodology and techniques on how to implement option pricing and volatility models in VBA. The book takes an in-depth look into how to implement the Heston and Heston and Nandi models and includes an entire chapter on parameter estimation, but this is just the tip of the iceberg. Everyone interested in derivatives should have this book in their personal library." —Espen Gaarder Haug, option trader, philosopher, and author of Derivatives Models on Models "I am impressed. This is an important book because it is the first book to cover the modern generation of option models, including stochastic volatility and GARCH." —Steven L. Heston, Assistant Professor of Finance, R.H. Smith School of Business, University of Maryland

Download or read book Process Systems and Materials for CO2 Capture written by Athanasios I. Papadopoulos and published by John Wiley & Sons. This book was released on 2017-03-28 with total page 690 pages. Available in PDF, EPUB and Kindle. Book excerpt: This comprehensive volume brings together an extensive collection of systematic computer-aided tools and methods developed in recent years for CO2 capture applications, and presents a structured and organized account of works from internationally acknowledged scientists and engineers, through: Modeling of materials and processes based on chemical and physical principles Design of materials and processes based on systematic optimization methods Utilization of advanced control and integration methods in process and plant-wide operations The tools and methods described are illustrated through case studies on materials such as solvents, adsorbents, and membranes, and on processes such as absorption / desorption, pressure and vacuum swing adsorption, membranes, oxycombustion, solid looping, etc. Process Systems and Materials for CO2 Capture: Modelling, Design, Control and Integration should become the essential introductory resource for researchers and industrial practitioners in the field of CO2 capture technology who wish to explore developments in computer-aided tools and methods. In addition, it aims to introduce CO2 capture technologies to process systems engineers working in the development of general computational tools and methods by highlighting opportunities for new developments to address the needs and challenges in CO2 capture technologies.

Download or read book AIChE Symposium Series written by American Institute of Chemical Engineers and published by . This book was released on 1972 with total page 392 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Download or read book An Introduction to Excel for Civil Engineers written by Gunthar Pangaribuan and published by Createspace Independent Publishing Platform. This book was released on 2016-08-16 with total page 386 pages. Available in PDF, EPUB and Kindle. Book excerpt: It's a Excel basics book that every civil engineer should have read by now. It addresses skills that may not be covered in most Excel for civil engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations (multiplication and inversion) using Excel-VBA, macro for creating an engineering chart, a brief and simple guide to become an instant Excel-VBA programmer, and more... Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user! With the ease of working with Excel, coupled with benefit of the given examples in this book, it is expected to increase the interest of the reader to create new original application programs. Thus, each model or even a specific calculation will be an exciting challenge for a programming job is already enjoyable. Happy Excel programming!

Download or read book Modeling Analysis and Optimization of Process and Energy Systems written by F. Carl Knopf and published by John Wiley & Sons. This book was released on 2011-12-14 with total page 798 pages. Available in PDF, EPUB and Kindle. Book excerpt: Energy costs impact the profitability of virtually all industrial processes. Stressing how plants use power, and how that power is actually generated, this book provides a clear and simple way to understand the energy usage in various processes, as well as methods for optimizing these processes using practical hands-on simulations and a unique approach that details solved problems utilizing actual plant data. Invaluable information offers a complete energy-saving approach essential for both the chemical and mechanical engineering curricula, as well as for practicing engineers.

Download or read book Advanced Modelling in Finance using Excel and VBA written by Mary Jackson and published by John Wiley & Sons. This book was released on 2006-08-30 with total page 278 pages. Available in PDF, EPUB and Kindle. Book excerpt: This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Download or read book Excel Scientific and Engineering Cookbook written by David M Bourg and published by "O'Reilly Media, Inc.". This book was released on 2006-01-17 with total page 445 pages. Available in PDF, EPUB and Kindle. Book excerpt: Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Download or read book Process Design Principles written by Warren D. Seider and published by John Wiley & Sons. This book was released on 1999 with total page 850 pages. Available in PDF, EPUB and Kindle. Book excerpt: Accompanied by CD-ROM: Simulation of process flowsheets.