A simplification of reading fluid properties using microsoft excel / (Record no. 3840)

MARC details
000 -LEADER
fixed length control field 02511ntm a2200241 a 4500
001 - CONTROL NUMBER
control field vtls000072567
003 - CONTROL NUMBER IDENTIFIER
control field KUKTEM
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20251114204536.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 130620t2012 my da f m 000 0 eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number THE0006426(Local)
039 #9 - LEVEL OF BIBLIOGRAPHIC CONTROL AND CODING DETAIL [OBSOLETE]
Level of rules in bibliographic description 201905131518
Level of effort used to assign nonsubject heading access points amirul
Level of effort used to assign subject headings 201306201720
Level of effort used to assign classification huda
-- 201306201720
-- huda
040 ## - CATALOGING SOURCE
Original cataloging agency UMP
090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)
Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) TJ853 .A87 2012 rs Bc.
100 0# - MAIN ENTRY--PERSONAL NAME
Personal name Mohd Asri Ibrahim
245 12 - TITLE STATEMENT
Title A simplification of reading fluid properties using microsoft excel /
Statement of responsibility, etc. Mohd Asri Ibrahim
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. Kuantan, Pahang :
Name of publisher, distributor, etc. UMP,
Date of publication, distribution, etc. 2012
300 ## - PHYSICAL DESCRIPTION
Extent xviii, 84 p. :
Other physical details ill. (some col.) :
Dimensions 30 cm. +
Accompanying material 1 CD-ROM
502 ## - DISSERTATION NOTE
Dissertation note Project paper (Bachelor of Mechanical Engineering) -- Universiti Malaysia Pahang - 2012
504 ## - BIBLIOGRAPHY, ETC. NOTE
Bibliography, etc. note Bibliography : p. 82
520 3# - SUMMARY, ETC.
Summary, etc. 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.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Fluidic devices
Holdings
Withdrawn status Lost status Damaged status Not for loan Home library Current library Date acquired Total checkouts Full call number Barcode Date last seen Copy number Price effective from Koha item type
  Not lost   Not for loan UMPLIB PEKAN UMPLIB PEKAN 04/09/2019   TJ853 .A87 2012 rs Bc. 0000072797 04/09/2019 1 04/09/2019 Final Year Report
  Not lost   Not for loan UMPLIB PEKAN UMPLIB PEKAN 04/09/2019   CD 6926 | TJ853 .A87 2012 rs Bc. 0000072798 04/09/2019 1 04/09/2019 Final Year Report

Perpustakaan Universiti Malaysia Pahang Al-Sultan Abdullah
26600 Pekan, Pahang Darul Makmur
Phone: +609 431 5063 (Gambang) / +609 431 5035 (Pekan)
Email: umplibrary@umpsa.edu.my

Connect With Us