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...
| Main Author: | |
|---|---|
| Format: | Undergraduates Project Papers |
| Language: | English |
| Published: |
2012
|
| Subjects: | |
| Online Access: | http://umpir.ump.edu.my/id/eprint/4497/1/37.A%20SIMPLIFICATION%20OF%20READING%20FLUID%20PROPERTIES%20USING%20MICROSOFT%20EXCEL.pdf |
| _version_ | 1825821513089024000 |
|---|---|
| author | Mohd Asri, Ibrahim |
| author_facet | Mohd Asri, Ibrahim |
| author_sort | Mohd Asri, Ibrahim |
| collection | UMP |
| 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. |
| first_indexed | 2024-03-06T11:42:40Z |
| format | Undergraduates Project Papers |
| id | UMPir4497 |
| institution | Universiti Malaysia Pahang |
| language | English |
| last_indexed | 2024-03-06T11:42:40Z |
| publishDate | 2012 |
| record_format | dspace |
| spelling | UMPir44972023-02-23T07:56:47Z 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 pdf en http://umpir.ump.edu.my/id/eprint/4497/1/37.A%20SIMPLIFICATION%20OF%20READING%20FLUID%20PROPERTIES%20USING%20MICROSOFT%20EXCEL.pdf Mohd Asri, Ibrahim (2012) A simplification of reading fluid properties using Microsoft Excel. Faculty of Mechanical Engineering, Universiti Malaysia Pahang. |
| spellingShingle | TJ Mechanical engineering and machinery Mohd Asri, Ibrahim A simplification of reading fluid properties using Microsoft Excel |
| title | 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_short | A simplification of reading fluid properties using Microsoft Excel |
| title_sort | simplification of reading fluid properties using microsoft excel |
| topic | TJ Mechanical engineering and machinery |
| url | http://umpir.ump.edu.my/id/eprint/4497/1/37.A%20SIMPLIFICATION%20OF%20READING%20FLUID%20PROPERTIES%20USING%20MICROSOFT%20EXCEL.pdf |
| work_keys_str_mv | AT mohdasriibrahim asimplificationofreadingfluidpropertiesusingmicrosoftexcel AT mohdasriibrahim simplificationofreadingfluidpropertiesusingmicrosoftexcel |