DWSIM - Open Source Process Simulator / Tickets (Inactive) / #285 Excel Add-in Units

#285 Excel Add-in Units

Milestone: 6.3

Status: open

Owner: Daniel Medeiros

Labels: Excel (3)

Operating System: Windows

Updated: 2021-02-20

Created: 2021-02-19

Creator: Casey Houston

Private: No

This is for v6.4.3...I hadn't tested in prior versions so am not sure if this is lingering or new. Also, I searched the tickets and didn't see if it was listed already.

See attached comments in the Add-in spreadsheet. Corresponding stream in DWSIM file format also attached for reference.

The density values generated in the Excel Add-in are incorrect. The units on both Molar and Mass basis are kg/m3 (would expect kmol/m3 or mol/m3 for the Molar basis).
The units on specific volume calculated on a Mass basis are incorrect. Should be m3/kg.
The values for internalEnergy, helmholtzEnergy, and gibbsEnergy are incorrect.

Comments in attached cells highlight my suspected issues in the unit conversion calculations.

Thanks!

2 Attachments

DWSIM Add-In Ethylene.xlsx

EthyleneSI.dwxmz

Discussion

Casey Houston - 2021-02-19

assigned_to: Daniel Medeiros
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Daniel Medeiros - 2021-02-20

Thanks for the report, Casey. All units are ok now:

https://github.com/DanWBR/dwsim6/commit/321643c016174bcf76d4859bb0f41300f7fd6f93

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Casey Houston - 2021-02-20

Thanks, Daniel. Looks great.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Excel Add-in Units

Simulate chemical processes using advanced thermodynamic models

Version

Searches

Help

#285 Excel Add-in Units

Discussion