Physics, 31.12.2019 02:31 samueladetoro54

Given the temperature and mass as input variables, construct a spreadsheet that uses linear interpolation to determine hv and the pressure and then calculate the required amount of heat to completely vaporize the water.

Answers: 2

Show answers

Answers

Answer from: maxB0846

Hi. I think that you must specify that both temperature and pressure are at saturation point. I'm attaching a document and I hope it provide enough information in order to understand clearly the explanation below

Explanation:

In order to give a solution to this problem you should take into account the following steps:

Type the following properties: Saturation temperature, saturation pressure, enthalpy of saturated liquid (hf) and enthalpy of saturated vapour (hg). I personally suggest the annexed properties tables of Yunes Cengel.Extract the necessary data in order to calculate the unknown properties (pressure and hv). This part is really important because we have to use specific commands in the spreadsheet; I'm going to explain it deeply below:First of all, we must provide a temperature and we have to extract from the properties table in the spreadsheet: the nearest lower temperature and the nearest higher temperatureTo do this, we must use the command lookup. The task of this command is search a value close to a value provided. The command lookup always extract the nearest lower value.

The command lookup is used like this:

=+lookup(Value provided by the user; list to compare the value provided; corresponding data list)

In this case, the value provided by the user is any temperature, the list to compare the value provided is the column of saturating temperature and the corresponding data list is the saturating pressure (or the enthalpy)

Now, we have to extract the nearest higher value. To do this, we must take into account that the nearest higher value correspond to the value located in the next row of the nearest lower valueIf we know the arrow where a value is located, we can use the command index and we can extract its value.

The comand index is used like this:

=index(data matrix, row, column)

In this case the data matrix is the properties table that you type in the spreadsheet, row is the row where is located the nearest lower value (since we are extracting the nearest higher value you must type row +1) and column is the column of interest data (in this case the pressure or the enthalpy).

Once you extract all the information that you need the following step is to interpolate with equation (1):

(1) $y=y_0+\frac{y_1-y_0}{x_1-x_0}*(x-x_0)$

Remember that y is the dependent variable (in this case, pressure or enthalpy) and x is the independent variable (in this case, temperature)

Finally, calculate the amount of heat to vaporize any quantity of water. To do this, you must multiply the interpolated value of vaporization enthalpy by the mass of water (in mass or moles according to the units). The equation is shown below:

(2) $Q=h_{vap}*Mass_{water}$

I know that understanding the commands is a bit complicated, for that reason I attached a spreadsheet with an example. I suggest to read the explanation and analyze carefully the commands.

Answer from: Quest

the temperature and the pressure affect solubility. temperature affects by changing the properties of the solvent. the increase in pressure increases solubility, the decrease in pressure decreases solubility.

Answer from: Quest

The car would move to the right with 150 n of force. the 150 n of force from friction and air resistance slows the car from moving to the right with 300 n of force.

Other questions on the subject: Physics

Physics, 21.06.2019 19:00, dasiaflowers85

When the velocity of an object is doubled, by what factor is its momentum changed? by what factor is its kinetic energy changed? a) the momentum is zero. b) the momentum is not zero. c) difficult to say.

Answers: 3

continue

Physics, 21.06.2019 23:00, wrightstephanie193

The key to stability is feedback between the reservoir and the fluxes into and/or out of the reservoir. assume that the rate of outflow from a reservoir depends on the size of the reservoir according to the following relationship: outflow rate= k x (size of reservoir), where k is a constant. a reservoir of water has a volume of 5000 liters, and the rate of outflow at steady state is 25 liters per minute. what is k? (give both the numerical value and its units.) what is the residence time? what is the relationship between k and the residence time?

Answers: 1

continue

Physics, 22.06.2019 05:10, delawdermia27

Which diagram correctly demonstrates the various forces acting on a ball moving horizontally with some speed?

Answers: 2

continue

Physics, 22.06.2019 08:20, Gtx014

The two required components for a generator

Answers: 2

continue

You know the right answer?

Given the temperature and mass as input variables, construct a spreadsheet that uses linear interpol...