Closed

Microsoft ecxel Macro assigment

Fluid properties calculator

Objectives:

1. Implement root finding method to determine the dew point pressure for the given fluid mixture

phase behavior

2. Implement bilinear interpolation method to determine the fluid mixture density at the thermodynamic conditions for which the tabulated data is not listed. Data: An Excel spreadsheet is provided on the course Moodle page under Project 1. It contains the tabulated entries of liquid fraction and mixture density as a function of temperature and pressure.

Programming Requirements:

1. Implemented VBA Macros must read/write/search/sort a variety of data/messages based upon the

calculations performed for dew point pressure calculations and fluid mixture densities.

2. Root finding problem could use bisection method. Appearance of liquid fraction (i.e. gas fraction less than 1.0) at a given temperature indicates that fluid mixture pressure is above dew point. Assume that the dew point pressure can be evaluated as the linearly interpolated pressure at liquid fraction value of 0.01 for any given temperature in the two-phase region range.

3. Implement VBA macro to locate the nearest tabulated entries of mixture densities for different temperature and pressure. Apply bilinear interpolation method to calculate the fluid mixture density at the desired thermodynamic state. Display the results as a message box.

Skills: Excel, Microsoft, Microsoft Access, Moodle, Visual Basic

See more: microsoft excel macro report generator, microsoft word macro pay, microsoft powerpoint macro, microsoft word macro xml, microsoft excel macro, microsoft word macro find replace excel, microsoft word macro find replace, microsoft excel macro paste cell details single cell seperated colon, microsoft excel macro jobs, microsoft excel macro data internet explorer, formatting tables microsoft word macro, microsoft word macro, microsoft drop macro, microsoft excel macro print invoice, microsoft word macro tick

About the Employer:
( 0 reviews ) United States

Project ID: #15342400

12 freelancers are bidding on average $29 for this job

abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$55 USD in 2 days
(51 Reviews)
5.4
mantumalakar10

Hello, You can check my profile I have done soo many project on past for VBA, and VB mode app. so this looks easy to me. feel fee to contact in details. Relevant Skills and Experience vba, vb.net Proposed Milestone More

$25 USD in 1 day
(24 Reviews)
4.9
webanis

Hi , I am interested by your offer: Excel VBA code. Let me know more details of this work. I will start working immediately :) Br; Relevant Skills and Experience Excel VBA code Proposed Milestones $25 USD - 11

$25 USD in 1 day
(16 Reviews)
4.0
frankrui

Please PM me your data/specification and I'll work and send you a sample. I've created a similar excel macro couple months ago. I am new to freelancer platform, but have severed many international cooperatives also s More

$30 USD in 3 days
(3 Reviews)
1.6
ketnn

Quality and timely work. Relevant Skills and Experience I am coding in VB since 2000 Proposed Milestones $30 USD - Can be done as directed.

$30 USD in 1 day
(0 Reviews)
0.0
vijaydas07

EARLY THEN EARLIEST CAN BE DONE YOU PROJECT Relevant Skills and Experience DATA ENTRY IN MS EXCEL, MS WORD HINDI TYPING ENGLISH TYPING RTO WORKS EPF WORKS Proposed Milestones $17 USD - AS YOUR TIME VALUABLE AS OUR.. More

$17 USD in 1 day
(0 Reviews)
0.0
aasry

ms exsell

$25 USD in 3 days
(0 Reviews)
0.0
ksnreddy2012

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
Deepak3103

I have a great team to complete this job

$30 USD in 3 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
abdallahsonic

You will need a userform, with drop down boxes and the results will be displayed either as a message box, but better to have this on the form itself displayed... Relevant Skills and Experience VBA EXCEL Proposed Mile More

$26 USD in 2 days
(0 Reviews)
0.0
clarkmu9

This is an interesting project, I would like to divide your task into UI and the calculation parts. I may need your help about formula. Then I will take care of the rest 相关技能及经验 I was major in Mechanical Engineering, More

$35 USD in 5 days
(0 Reviews)
0.0