A simplification of reading fluid properties using Microsoft Excel

This project deals with simplification reading fluid properties using Microsoft Excel. The objective of this project to develop an excel file to easily obtain fluid properties without manual reading from table. The types of fluid are saturated water, saturated refrigerant-134a, saturated ammonia, sa...

Full description

Bibliographic Details
Main Author:	Mohd Asri, Ibrahim
Format:	Undergraduates Project Papers
Language:	English
Published:	2012
Subjects:	TJ Mechanical engineering and machinery
Online Access:	http://umpir.ump.edu.my/id/eprint/4497/ http://umpir.ump.edu.my/id/eprint/4497/ http://umpir.ump.edu.my/id/eprint/4497/1/cd6926_102.pdf

id	ump-4497
recordtype	eprints
spelling	ump-44972015-03-03T09:19:22Z http://umpir.ump.edu.my/id/eprint/4497/ A simplification of reading fluid properties using Microsoft Excel Mohd Asri, Ibrahim TJ Mechanical engineering and machinery This project deals with simplification reading fluid properties using Microsoft Excel. The objective of this project to develop an excel file to easily obtain fluid properties without manual reading from table. The types of fluid are saturated water, saturated refrigerant-134a, saturated ammonia, saturated propane and air at 1 atm pressure while the fluid properties are density, dynamic viscosity, kinematic viscosity and friction factor. The formula in Microsoft Excel, INDEX, MATCH, INDIRECT, IF, AND, ISBLANK, NA and DROPDDOWLIST are used to build a combine formula that can obtain fluid properties from property tables. The combined formula was constructed step by step starting the listed value, followed by listed and unlisted value for SI units only and then the listed and unlisted value for SI units and English units in the property tables. Finally, one more combined formula was constructed to obtain friction factor based on Colebrook equation by using bisection method to solve that equation. Validation results were conducted where compared the results from manual reading and excel file. The error from both results was observed where all the error results are below 5 % and can be accepted. The different results from manual reading and excel file only occur for result in value decimal places. It can be comprehend that, to obtain fluid properties from property tables can be using Microsoft Excel by constructed a excel file. The developed excel file for future work is highly recommended for adding more properties, more type of fluid and using Visual Basic for Applications for advance editing. 2012-06 Undergraduates Project Papers NonPeerReviewed application/pdf en http://umpir.ump.edu.my/id/eprint/4497/1/cd6926_102.pdf Mohd Asri, Ibrahim (2012) A simplification of reading fluid properties using Microsoft Excel. Faculty of Mechanical Engineering, Universiti Malaysia Pahang. http://iportal.ump.edu.my/lib/item?id=chamo:72567&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 Mohd Asri, Ibrahim A simplification of reading fluid properties using Microsoft Excel
description	This project deals with simplification reading fluid properties using Microsoft Excel. The objective of this project to develop an excel file to easily obtain fluid properties without manual reading from table. The types of fluid are saturated water, saturated refrigerant-134a, saturated ammonia, saturated propane and air at 1 atm pressure while the fluid properties are density, dynamic viscosity, kinematic viscosity and friction factor. The formula in Microsoft Excel, INDEX, MATCH, INDIRECT, IF, AND, ISBLANK, NA and DROPDDOWLIST are used to build a combine formula that can obtain fluid properties from property tables. The combined formula was constructed step by step starting the listed value, followed by listed and unlisted value for SI units only and then the listed and unlisted value for SI units and English units in the property tables. Finally, one more combined formula was constructed to obtain friction factor based on Colebrook equation by using bisection method to solve that equation. Validation results were conducted where compared the results from manual reading and excel file. The error from both results was observed where all the error results are below 5 % and can be accepted. The different results from manual reading and excel file only occur for result in value decimal places. It can be comprehend that, to obtain fluid properties from property tables can be using Microsoft Excel by constructed a excel file. The developed excel file for future work is highly recommended for adding more properties, more type of fluid and using Visual Basic for Applications for advance editing.
format	Undergraduates Project Papers
author	Mohd Asri, Ibrahim
author_facet	Mohd Asri, Ibrahim
author_sort	Mohd Asri, Ibrahim
title	A simplification of reading fluid properties using Microsoft Excel
title_short	A simplification of reading fluid properties using Microsoft Excel
title_full	A simplification of reading fluid properties using Microsoft Excel
title_fullStr	A simplification of reading fluid properties using Microsoft Excel
title_full_unstemmed	A simplification of reading fluid properties using Microsoft Excel
title_sort	simplification of reading fluid properties using microsoft excel
publishDate	2012
url	http://umpir.ump.edu.my/id/eprint/4497/ http://umpir.ump.edu.my/id/eprint/4497/ http://umpir.ump.edu.my/id/eprint/4497/1/cd6926_102.pdf
first_indexed	2023-09-18T21:59:08Z
last_indexed	2023-09-18T21:59:08Z
_version_	1777414280537178112

A simplification of reading fluid properties using Microsoft Excel

Similar Items