Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an interpolation excel formula for a complete table of values for a compressed liquid for any input pressure between 5 MPa and 1 5

Create an interpolation excel formula for a complete table of values for a compressed liquid for any input pressure between 5 MPa and 15 MPa with Temperature as the x values and Specific Volume as the y values. The interpolation is done between multiple tables. For example if 6 MPa is the pressure input, the interpolation would be done between 5 MPa and 10 MPa tables to create a complete table for 6 MPa. If 11 MPa is the input for example, the interpolation is done between 10 MPa and 12 MPa. There is only one pressure input that creates its own table for the specific initial pressure providing Temperatures 0C to 30C with 5 degree Celsius increments and respective specific volumes.
(Table 5 MPa)
T=0C, v=0.00099768 m3/kg
T=5C, v=0.00099764 m3/kg
T=10C, v=0.00099797 m3/kg
T=15C, v=0.00099862 m3/kg
T=20C, v=0.00099956 m3/kg
T=25C, v=0.00100075 m3/kg
T=30C, v=0.00100218 m3/kg
(Table 10 MPa)
T=0C, v=0.00099520 m3/kg
T=5C, v=0.00099524 m3/kg
T=10C, v=0.00099564 m3/kg
T=15C, v=0.00099634 m3/kg
T=20C, v=0.00099731 m3/kg
T=25C, v=0.00099854 m3/kg
T=30C, v=0.00099998 m3/kg
(Table for 12 MPa)
T=0C, v=0.00099422 m3/kg
T=5C,0.00099429 m3/kg
T=10C, v=0.00099429 m3/kg
T=15C, v=0.00099543 m3/kg
T=20C, v=0.00099642 m3/kg
T=25C, v=0.00099766 m3/kg
T=30C, v=0.00099911 me/kg
(Table for 15 MPa)
T=0C, v=0.00099276 m3/kg
T=5C, v=0.00099288 m3/kg
T=10C, v=0.00099334 m3/kg
T=15C, v=0.00099409 m3/kg
T=20C, v=0.00099510 m3/kg
T=25C, v=0.00099635 m3/kg
T=30C, v=0.00099782 m3/kg

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Chemical Engineering questions