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....

Full description

Bibliographic Details
Main Author: Nur Diyana Wahida , Adam
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/
http://umpir.ump.edu.my/id/eprint/6531/1/CD6911.pdf
id ump-6531
recordtype eprints
spelling ump-65312015-03-03T09:30:55Z 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 application/pdf en http://umpir.ump.edu.my/id/eprint/6531/1/CD6911.pdf Nur Diyana Wahida , Adam (2012) A simplification of reading thermodynamic properties using microsoft excel. Faculty of Mechanical Engineering , Universiti Malaysia Pahang. http://iportal.ump.edu.my/lib/item?id=chamo:77862&theme=UMP2
repository_type Digital Repository
institution_category Local University
institution Universiti Malaysia Pahang
building UMP Institutional Repository
collection Online Access
language English
topic TJ Mechanical engineering and machinery
spellingShingle TJ Mechanical engineering and machinery
Nur Diyana Wahida , Adam
A simplification of reading thermodynamic properties using microsoft excel
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.
format Undergraduates Project Papers
author Nur Diyana Wahida , Adam
author_facet Nur Diyana Wahida , Adam
author_sort Nur Diyana Wahida , Adam
title A simplification of reading thermodynamic properties using microsoft excel
title_short 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_sort simplification of reading thermodynamic properties using microsoft excel
publishDate 2012
url http://umpir.ump.edu.my/id/eprint/6531/
http://umpir.ump.edu.my/id/eprint/6531/
http://umpir.ump.edu.my/id/eprint/6531/1/CD6911.pdf
first_indexed 2023-09-18T22:02:22Z
last_indexed 2023-09-18T22:02:22Z
_version_ 1777414483484868608