Pressure Swing Adsorption in Microsoft Excel – Basic Version (v1.0) - A learning tool for Chemical Engineering students

This Excel workbook was developed as part of the final year design project at the University of Surrey and is intended as an educational and illustrative tool for simulating Pressure Swing Adsorption (PSA) processes. The spreadsheets are self-explanatory and demonstrate how breakthrough curves and multi-cycle PSA simulations can be generated using fundamental mass transfer equations.

Please note that the data used in this tool are not experimentally obtained. Instead, key process parameters—including bed and adsorbent properties, flow rate, and isotherm characteristics—are assumed values, selected to illustrate the application of the method of lines for solving the mass balance equations commonly embedded in commercial simulation tools such as Aspen Adsorption.

For simplicity, the model assumes:

Axial dispersion

Linear adsorption isotherms

Plug flow dynamics

If users input the appropriate bed properties, adsorbent parameters, flow rate, and adsorption isotherm, the Excel tool will generate breakthrough profiles and simulate performance across multiple PSA cycles. This can help researchers and students in the adsorption community understand the internal workings of commercial simulators and the role of numerical methods in process modelling.

If you use or adapt this Excel tool in your own work, please cite this dataset accordingly.

本Excel工作簿系萨里大学毕业年级设计项目的成果，旨在作为一款用于模拟变压吸附（Pressure Swing Adsorption，PSA）过程的教学演示工具。本电子表格无需额外阐释即可自行理解，演示了如何通过基础传质方程生成穿透曲线与多周期变压吸附模拟结果。

请注意，本工具所使用的数据并非实验实测所得。取而代之的是，各类关键工艺参数——包括床层与吸附剂特性、流速以及等温线特征——均为预设假设值，选取这些参数旨在演示线法在求解通常内嵌于Aspen Adsorption等商业模拟软件中的物料衡算方程时的应用。

为简化模型，本工具做如下假设：
轴向弥散
线性吸附等温线
平推流动力学

若用户输入合适的床层特性、吸附剂参数、流速与吸附等温线，本Excel工具将生成穿透曲线剖面，并模拟多周期变压吸附过程的运行性能。这可帮助吸附领域的研究者与学生理解商业模拟软件的内部运行机制，以及数值方法在过程建模中的作用。

若您在自身工作中使用或改编本Excel工具，请相应引用本数据集。