Chapter 10, Problem 10RQ

Use the following phase diagram for questions 9 and 10.

The following phase diagram is for salt water. There are four possible phases, which depend on the temperature and the sodium chloride content (NaCl).

• Ice and SC = Mixed ice and salt crystals.
• Ice and SW = Ice and salt water.
• SW = Salt water.
• SW and SC = Salt water and salt crystals.

There are often multiple ways to solve the same problem; here we look at a few alternative ways to determine the phase of the mixture.

1. 10. a. In column A and column B, use data validation to restrict the user from entering values outside the valid parameter ranges: NaCl (%): 0–100%; Temp [°C]: –35°C to 35°C.
   1. b. In column C, develop the equation for the line dividing the phases of the ice–salt water mix and the salt water.
   2. c. In column D, develop the equation for the line dividing the phases of the salt water and the salt water–salt crystals mix.
   3. d. In column E, write an expression to determine the phase of the mixture.
   4. e. Use conditional formatting to highlight the various phases. Provide a color key.