please write in excell form

Review Question 8 a. In column A and column B, use data validation to restrict the user from entering values outside the valid parameter ranges-pressure: 0-35 psi and porosity: 0- 100%. b. In column C, develop the equation for the line dividing the phases of Region E and Region C. c. In column D, write an expression to determine the phase of the material (phase A- phase E). d. In column E, write an expression to determine if the material is processible. e. When the conditions of phase E are met, the cell should be highlighted by conditional formatting f. Write an expression in column F to tell the user why the material was rejected. For example, under the conditions of pressure = 25 psi and porosity = 40%, the statement might say "Porosity too low." B D E F 1 2 3 4 Porosity Upper Limit [%] Porosity Lower Limit [%] Pressure Limit [psi] 85 15 15 5 6 7 8 9 10 11 12 Pressure (P) [psi] 50 Porosity (e) [%] 68 Porosity betweer oor tece C and E The value your Auser has restricted values that can be entered the Use the following phase diagram for questions 7 and 8. The following phase diagram for the processing of a polymer relates the applied pressure to the raw material porosity. Region A or B = porosity is too high or too low for the material to be usable. Region C = combinations in this region yield material with defects, such as cracking or flaking Region D = below a pressure of 15 pound-force per square inch [psi] the polymer cannot be processed. Region E = optimum region to operate. 1.0 0.9 Region A 0.85 Porosity 33 psi 0.8 0.7 0.6 0.5 Region D Region E Porosity () (-) 0.15 Porosity 15 psi Region C 0.4 0.3 0.2 0.1 0.0 Region B 0 5 10 25 30 35 15 20 Pressure (P) [psi] There are often multiple ways to solve the same problem; here we look at a few alternative ways to determine the phase of the material and the processability of the material. Review Question 8 a. In column A and column B, use data validation to restrict the user from entering values outside the valid parameter ranges-pressure: 0-35 psi and porosity: 0- 100%. b. In column C, develop the equation for the line dividing the phases of Region E and Region C. c. In column D, write an expression to determine the phase of the material (phase A- phase E). d. In column E, write an expression to determine if the material is processible. e. When the conditions of phase E are met, the cell should be highlighted by conditional formatting f. Write an expression in column F to tell the user why the material was rejected. For example, under the conditions of pressure = 25 psi and porosity = 40%, the statement might say "Porosity too low." B D E F 1 2 3 4 Porosity Upper Limit [%] Porosity Lower Limit [%] Pressure Limit [psi] 85 15 15 5 6 7 8 9 10 11 12 Pressure (P) [psi] 50 Porosity (e) [%] 68 Porosity betweer oor tece C and E The value your Auser has restricted values that can be entered the Use the following phase diagram for questions 7 and 8. The following phase diagram for the processing of a polymer relates the applied pressure to the raw material porosity. Region A or B = porosity is too high or too low for the material to be usable. Region C = combinations in this region yield material with defects, such as cracking or flaking Region D = below a pressure of 15 pound-force per square inch [psi] the polymer cannot be processed. Region E = optimum region to operate. 1.0 0.9 Region A 0.85 Porosity 33 psi 0.8 0.7 0.6 0.5 Region D Region E Porosity () (-) 0.15 Porosity 15 psi Region C 0.4 0.3 0.2 0.1 0.0 Region B 0 5 10 25 30 35 15 20 Pressure (P) [psi] There are often multiple ways to solve the same problem; here we look at a few alternative ways to determine the phase of the material and the processability of the material