A simplification of reading thermodynamic properties using microsoft excel
Thermodynamic properties calculator is an engineering tool built by MS Excel addin which is properties of water, air and superheated vapor. The main purpose of this project is to excel file that can simply obtain thermodynamic properties without manually reading from thermodynamic properties table....
| Main Author: | |
|---|---|
| Format: | Undergraduates Project Papers |
| Language: | English |
| Published: |
2012
|
| Subjects: | |
| Online Access: | http://umpir.ump.edu.my/id/eprint/6531/ http://umpir.ump.edu.my/id/eprint/6531/1/38.A%20simplification%20of%20reading%20thermodynamic%20properties%20using%20microsoft%20excel.pdf |
| _version_ | 1848817794232090624 |
|---|---|
| author | Nur Diyana Wahida, Adam |
| author_facet | Nur Diyana Wahida, Adam |
| author_sort | Nur Diyana Wahida, Adam |
| building | UMP Institutional Repository |
| collection | Online Access |
| description | Thermodynamic properties calculator is an engineering tool built by MS Excel addin which is properties of water, air and superheated vapor. The main purpose of this project is to excel file that can simply obtain thermodynamic properties without manually reading from thermodynamic properties table. The project scopes werefluids that will be used as a reference were water, superheated vapor and air, thermodynamic properties such as enthalpy, entropy, specific heat, thermal conductivity, specific volume, relative pressure ratio, specific volume ratio and internal energy were the main properties that need to be referred. All the properties were based on thermodynamic properties table and result validation. Formulas that suitable to the formula of interface created using excel file were identified and studied.All unknown for the common formula that used to do interpolation manually were listed out and identified its function. Then, formula for each unknown created using excel formula and lastly all the formulas created for each unknown were combined according to the common formula used for manual interpolation. The new formula created using excel formulas was tested and evaluated. The value of properties from the interface created was compared to the value of properties from manual interpolation using calculator in order to check the validation of the data. In the nutshell, interface of a simplest way to read thermodynamics properties table using excel software was successfully created and was checked by data validation. In order to improve this project, the function of changing the units of thermodynamics properties to other standard, for example into American Standard, should be developed and the software should also be able to run on other operating systems such as MAC for Apple and LINUX for Linus Torvalds so that people using other operating systems will have the benefits of using the software. |
| first_indexed | 2025-11-15T01:27:26Z |
| format | Undergraduates Project Papers |
| id | ump-6531 |
| institution | Universiti Malaysia Pahang |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T01:27:26Z |
| publishDate | 2012 |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | ump-65312023-02-23T07:57:26Z http://umpir.ump.edu.my/id/eprint/6531/ A simplification of reading thermodynamic properties using microsoft excel Nur Diyana Wahida, Adam TJ Mechanical engineering and machinery Thermodynamic properties calculator is an engineering tool built by MS Excel addin which is properties of water, air and superheated vapor. The main purpose of this project is to excel file that can simply obtain thermodynamic properties without manually reading from thermodynamic properties table. The project scopes werefluids that will be used as a reference were water, superheated vapor and air, thermodynamic properties such as enthalpy, entropy, specific heat, thermal conductivity, specific volume, relative pressure ratio, specific volume ratio and internal energy were the main properties that need to be referred. All the properties were based on thermodynamic properties table and result validation. Formulas that suitable to the formula of interface created using excel file were identified and studied.All unknown for the common formula that used to do interpolation manually were listed out and identified its function. Then, formula for each unknown created using excel formula and lastly all the formulas created for each unknown were combined according to the common formula used for manual interpolation. The new formula created using excel formulas was tested and evaluated. The value of properties from the interface created was compared to the value of properties from manual interpolation using calculator in order to check the validation of the data. In the nutshell, interface of a simplest way to read thermodynamics properties table using excel software was successfully created and was checked by data validation. In order to improve this project, the function of changing the units of thermodynamics properties to other standard, for example into American Standard, should be developed and the software should also be able to run on other operating systems such as MAC for Apple and LINUX for Linus Torvalds so that people using other operating systems will have the benefits of using the software. 2012-06 Undergraduates Project Papers NonPeerReviewed pdf en http://umpir.ump.edu.my/id/eprint/6531/1/38.A%20simplification%20of%20reading%20thermodynamic%20properties%20using%20microsoft%20excel.pdf Nur Diyana Wahida, Adam (2012) A simplification of reading thermodynamic properties using microsoft excel. Faculty of Mechanical Engineering, Universiti Malaysia Pahang. |
| spellingShingle | TJ Mechanical engineering and machinery Nur Diyana Wahida, Adam A simplification of reading thermodynamic properties using microsoft excel |
| title | A simplification of reading thermodynamic properties using microsoft excel |
| title_full | A simplification of reading thermodynamic properties using microsoft excel |
| title_fullStr | A simplification of reading thermodynamic properties using microsoft excel |
| title_full_unstemmed | A simplification of reading thermodynamic properties using microsoft excel |
| title_short | A simplification of reading thermodynamic properties using microsoft excel |
| title_sort | simplification of reading thermodynamic properties using microsoft excel |
| topic | TJ Mechanical engineering and machinery |
| url | http://umpir.ump.edu.my/id/eprint/6531/ http://umpir.ump.edu.my/id/eprint/6531/1/38.A%20simplification%20of%20reading%20thermodynamic%20properties%20using%20microsoft%20excel.pdf |