02511ntm a2200241 a 4500 vtls000072567 KUKTEM 20251114204536.0 130620t2012 my da f m 000 0 eng d THE0006426(Local) 201905131518 amirul 201306201720 huda 201306201720 huda UMP TJ853 .A87 2012 rs Bc. Mohd Asri Ibrahim A simplification of reading fluid properties using microsoft excel / Mohd Asri Ibrahim Kuantan, Pahang : UMP, 2012 xviii, 84 p. : ill. (some col.) : 30 cm. + 1 CD-ROM Project paper (Bachelor of Mechanical Engineering) -- Universiti Malaysia Pahang - 2012 Bibliography : p. 82 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. Fluidic devices 0 0 0 1 20000 20000 2019-09-04 0 TJ853 .A87 2012 rs Bc. 0000072797 2019-09-04 00:00:00 1 2019-09-04 PSM 0 0 0 1 20000 20000 2019-09-04 0 CD 6926 | TJ853 .A87 2012 rs Bc. 0000072798 2019-09-04 00:00:00 1 2019-09-04 PSM VIRTUA40 3840 3846 VTLSSORT0080*0200*0400*0900*1000*2450*2600*3000*5020*5040*5200*6500*9992