|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/collection-of-chemical-engineering-excel-workbooks-folders/
课程评论：没有评论
课程名称：化工工程Excel工作簿与文件集合 课程概述： 本课程将为学生提供一系列有价值的化工工程Excel工作簿，包括以下内容：流体流动Excel工作簿、化学工程师参考文件、阀门选型Excel工作簿、热交换器设计与计算Excel工作簿、离心压缩机性能与行为Excel工作簿、离心泵Excel工作簿。课程还包括快速教程视频，帮助学生学习如何使用这些工具，若有任何问题，可在问答区寻求帮助。 工作簿简介： 1. **流体流动Excel工作簿**：模拟小型管道系统在各种操作条件下运输液体和工业气体，依据行业认可的原则与标准，提供多种公式和数据，如流体的物理性质、压力损失计算、流量计算等。 2. **化学工程师参考文件**：包含324页的综合技术数据，提供90多个表格、120个图表和70个示意图，涵盖石油、天然气、石化和化学工业的重要工程领域，如物质的物理特性、流体动力学和热传导等。 3. **阀门选型Excel工作簿**：为阀门选型提供必需的技术数据，包括流量系数Cv、压力损失计算等，并支持液体和气体的选型。 4. **热交换器Excel工作簿**：为热交换器的设计、选型、操作和维护提供必要的数据和计算，包括常用流体的物理性质、传热系数、压力损失等信息。 5. **离心压缩机Excel工作簿**：提供离心压缩机的性能预测和计算，包括入口条件变化对压缩机性能的影响、系统阻力的影响等。 下载说明： 学生在注册后可在最后部分的“可下载资源”中找到Excel工作簿并进行下载。所有Excel工作簿均需在安装Microsoft Excel的计算机上使用，并需启用宏功能。 重要提示： 所有工作簿均按“原样”提供，不附带任何明示或暗示的担保，使用时请自行承担风险。
Dear students,This special course will give you access to a collection of valuable chemical engineering Excel workbooks:1. Flow of Fluids Excel Workbook2. The Chemical Engineer's Reference Folder3. Valve Sizing Excel Workbook4. Heat Exchanger Design & Calculation Excel Workbook5. Centrifugal Compressor Performance & Behavior Excel Workbook6. Centrifugal Pump Excel WorkbookThe video lectures included in this materiel are quick tutorials to show you how to use these valuable tools.Please watch these videos and follow the instructions provided.In case of any problem, feel free to ask us for help in the Q & A section.Enjoy these valuable tools.---------------1. FLOW OF FLUIDS EXCEL WORKBOOKFlow of Fluids Excel Workbook simulates the operation of small piping systems transporting liquids and industrial gases under a variety of operating conditions.Flow of Fluids Excel Workbook is based on industry recognized principles and standards from ASME, HI, IEC, AWWA, ISA, and ANSI...Flow of Fluids Excel Workbook is easy-to-use and has a highly intuitive user interface.Flow of Fluids Excel Workbook presents formulas and data for:1. Physical properties determination for a variety of fluids (specific gravity, viscosity, vapor pressure...)2. Pressure drop and head loss calculations through pipes, fittings and valves3. Flow calculations for incompressible and compressible fluids through pipes, fittings, valves and pumps4. Sizing piping systems for incompressible and compressible fluids5. Flow resistance coefficients calculations for pipes, fittings and valves6. Flow calculations for incompressible and compressible fluids through flow meters (Orifice Plates, Nozzles and Venturi meters)7. Centrifugal pump calculation (Pump head, NPSH, Specific speed, affinity laws…)8. Converting variables and process parameters to a numerious alternative units of measurement---------------2. THE CHEMICAL ENGINEER'S REFERENCE FOLDERThis unique folder provides well-organized technical data in form of comprehensive tables, charts and diagrams.324 pages including more than 90 tables, 120 charts and 70 diagrams which are essential to the Oil & Gas, Petrochemical and Chemical Industries.The preparation of this folder was a joint effort of WR training engineers who compiled data, charts and diagrams for which they were especially qualified and possess valuable experience.What topics are covered in this engineering folder:These comprehensive charts and diagrams cover many important engineering fields:- physical characteristics of pure substances- vapor pressure- physical properties of water and steam- specific heat- enthalpy- viscosity- thermal conductivity- density of liquids- behaviour of gases and compression- liquid - vapor equilibrium- combustion- fluid dynamics- centrifugal pumps- heat transfer and heat exchangers- compressors- properties relative to the petroleum cuts- distillation, absorption and stripping- safety- conversion tables---------------3. VALVE SIZING EXCEL WORKBOOKThe Valve Sizing Excel Spreadsheet provides well organized technical data in form of spreadsheet calculations indispensible for anyone involved in the sizing of valves. It presents formulae and data for:Valve flow coefficients CvFlow of fluids through valvesPressure drop through valves and attached fittingsValve Reynolds Number calculationsPredicting maximum flow through valves in choked conditionsRepresentative values of valve capacity factorsAnd more...The spreadsheet includes two worksheets:Sizing for liquids (incompressible fluids)Non vaporizing flow conditionsChoked flow conditionsSizing for vapors and gases (compressible fluids)---------------4. HEAT EXCHANGER EXCEL WORKBOOKThis Heat Exchanger Excel Workbook provides well organized technical data in form of spreadsheet calculations, tables, charts and diagrams, indispensible for anyone involved in the design, selection, operation, maintenance or inspection of heat exchangers.This Excel workbook presents formulae and data for:Physical properties of the most common fluids used in heat exchangers in Oil & Gas, Petroleum, Refining and Chemical processesHeat transfer coefficients "U" and "α"Pressure losses in shell and tube heat exchangers (tube + shell sides)Useful shell and tube geometrical calculationsGeometrical data of shell and tube heat exchangers according to DIN 28184 & 28191 and TEMA StandardsGuidelines for the selection of shell and tube heat exchangersThermal conductivity of the most common material of construction of shell and tube heat exchangersValuable heat exchanger charts, figures and diagramsNumerous conversion tablesAnd more...---------------5. CENTRIFUGAL COMPRESSOR EXCEL WORKBOOKThis workbook provides qualitative and quick comparisons and application notes for centrifugal compressors. It describes calculations and procedures to predict performance characteristics, especially head, discharge pressure and power.This valuable Excel workbook presents formulas and data for:General centrifugal compressor calculationsAssessing the effect of one inlet condition change on compressor performanceAssessing the effect of multiple inlet condition changes on compressor performanceAssessing the effect of system resistance on compressor performanceAdjusting centrifugal compressor rated performance curve to actual inlet conditionsUseful Fan-Law relationshipsValuable charts and diagrams for centrifugal compressorsConversion tables---------------DOWNLOAD INSTRUCTIONS1. Upon enrolling in, expand the last section "DOWNLOADABLE RESOURCES"2. Under the lecture "Download me", click on the folder "Resources" => A list of the Excel Workbooks will appear3. Click on any Workbook4. A download window will pop-up. Select the location where you want to save the file5. Once downloaded and saved on your computer, you can start using these valuable toolsIMPORTANT NOTES:We assume that Microsoft Excel is installed on your computer and that you have basic knowledge of using ExcelAll Excel Workbooks mentioned above include Visual Basic for Application function subroutines (VBA). Macros must be enabled for them to workDISCLAIMERAll Excel Workbooks mentioned above are provided by WR Training "as is" and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the Copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services, loss of use, data, or profits, or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this spreadsheet, even if advised of the possibility of such damage.
