{"id":2452,"date":"2020-08-07T15:43:41","date_gmt":"2020-08-07T19:43:41","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/chbe220\/?post_type=back-matter&p=2452"},"modified":"2020-08-07T15:43:41","modified_gmt":"2020-08-07T19:43:41","slug":"appendix-excel-solver-guide","status":"publish","type":"back-matter","link":"https:\/\/pressbooks.bccampus.ca\/chbe220\/back-matter\/appendix-excel-solver-guide\/","title":{"raw":"Appendix: Excel Solver Guide","rendered":"Appendix: Excel Solver Guide"},"content":{"raw":"

How to load \"Solver Add-in\" in Excel:<\/strong><\/h2>\r\n Step 1: <\/strong> Click \"file\" in the header and open the \"Options\" menu:\r\n\r\n\"\"\r\n\r\n Step 2: <\/strong> In the Excel Options menu, select \"Solver Add-in\" in the \"Add-ins\" section, then click \"OK\".\r\n\r\n\"\"\r\n\r\n Step 3: <\/strong> Then you can find the \"Solver\" in the \"Analyze\" section under the \"Data\" menu.\r\n\r\n\"\"\r\n

<\/h2>\r\n
\r\n

Sample Question<\/p>\r\n\r\n<\/header>\r\n

\r\n\r\nA heat exchanger uses superheated steam to heat up a stream of pure acetic acid.\r\n\r\n\"\"\r\n\r\nThe following data can be used for calculating the enthalpy change of the acetic acid stream:\r\n\r\n$$C_{p}=A+BT+CT^2+DT^3$$\r\n\r\nwhere T is in K and [latex]C_{p}[\/latex] is given in J\/mol K.\r\n\r\n\r\n\r\n\r\n
<\/td>\r\nA<\/td>\r\nB<\/td>\r\nC<\/td>\r\nD<\/td>\r\n<\/tr>\r\n
acetic acid<\/td>\r\n[latex]4.84[\/latex]<\/td>\r\n[latex]0.2549[\/latex]<\/td>\r\n[latex]-1.753E-4[\/latex]<\/td>\r\n[latex]4.949E-8[\/latex]<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nThe enthalpy change for superheated steam can be found using data from the steam table:\r\n\r\n\r\n\r\n\r\n
<\/td>\r\n300\u00b0C, 1 MPa<\/td>\r\n250\u00b0C, 1 MPa<\/td>\r\n<\/tr>\r\n
[latex]\\hat{H}[\/latex] (J\/mol)<\/td>\r\n54990<\/td>\r\n53035<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nThe boiling point for acetic acid at 1 atm is 117.9\u00b0C. Does the acetic acid boil in the heat exchanger? If not, calculate the final temperature of the acetic acid stream. Assume there is no energy loss due to heat transfer.\r\n\r\n<\/div>\r\n<\/div>\r\n \r\n

Solution<\/h2>\r\nBecause there are no other forms of energy transfer other than THE heat transfer between the streams, the energy balance simplifies to:\r\n\r\n$$\\Delta\\dot{H}_{water}+\\Delta\\dot{H}_{acetic \\;acid}=0$$\r\n\r\nBased on the type of data given to calculate enthalpy change, the [latex]\\Delta\\dot{H}[\/latex] term in the energy balance can be expanded to:\r\n\r\n$$\\Delta\\dot{H}_{water}=\\dot{H}_f-\\dot{H}_i$$\r\n\r\n\\begin{align*}\r\n\\Delta\\dot{H}_{acetic \\;acid}&=\\int_{T_i}^{T_f}C_pdT\\\\\r\n&=\\int_{T_i}^{T_f}A+BT+CT^2+DT^3 dT\\\\\r\n&=AT+\\frac{1}{2}BT^2+\\frac{1}{3}CT^3+\\frac{1}{4}DT^4\\;\\Bigg|_{T_i}^{T_f}\\\\\r\n&= A(T_f-T_i)+\\frac{1}{2}B(T_f-T_i)^2+\\frac{1}{3}C(T_f-T_i)^3+\\frac{1}{4}D(T_f-T_i)^4\r\n\\end{align*}\r\n\r\nStep 1: <\/strong>Input given information that will be used in the calculation. This includes the given data to calculate enthalpy change, the molar flow rate of both substances, and the initial temperature of acetic acid.\r\n\r\n\"\"\r\n\r\nStep 2:\u00a0<\/strong>Calculate the molar enthalpy change. For water, this is calculated by subtracting the molar enthalpy values given at the final and initial temperatures. For acetic acid, we need to provide a guess of the final temperature to substitute into the equation.\r\n\r\n\"\"\r\n\r\n\"\"\r\n\r\nStep 3:<\/strong> Calculate the total enthalpy change for both substances by multiplying the molar flow rate by the molar enthalpy change.\r\n\r\n\"\"\r\n\r\nou\r\n\r\nStep 4:\u00a0<\/strong>Use a cell to represent the sum of enthalpy change. If we have guessed the correct final temperature, the value of this cell should be 0. We will use solver to let excel perform the guess-and-check process for us.\r\n\r\n\"\"\r\n\r\nStep 5:\u00a0<\/strong>Select \"Solver\" from the \"Data\" menu in the header, and indicate that we want to solve for the final temperature of acetic acid that makes our [latex]\\text{sum of} \\delta H=0[\/latex]:\r\n
    \r\n \t
  • Set objective to be the cell containing [latex]\\text{sum of} \\delta H[\/latex]<\/li>\r\n \t
  • To be: value of 0<\/li>\r\n \t
  • By changing variable cells containing the final temperature of acetic acid<\/li>\r\n \t
  • Click \"Solve\"<\/li>\r\n<\/ul>\r\n\"\"\r\n\r\nStep 6:<\/strong> Click \"OK\" if solver finds a solution. If the solver cannot find a solution, it is maybe because our initial guess is too far away from the actual final temperature, if so, we can change the temperature and try to solve it again.\r\n\r\n\"\"\r\n\r\nStep 7:\u00a0<\/strong>After the window closes, the value of the final temperature of acetic acid and all cells affected by temperature are changed to the corresponding values calculated with the actual final temperature.\r\n\r\n\"\"\r\n\r\nTherefore, the final temperature of the acetic acid stream is [latex]364.7K[\/latex], which is equal to [latex]94.5\u00b0C[\/latex]. This temperature is lower than the boiling temperature of acetic acid at 1 atm, so the stream will not start to boil.","rendered":"

    How to load “Solver Add-in” in Excel:<\/strong><\/h2>\n

    Step 1: <\/strong> Click “file” in the header and open the “Options” menu:<\/p>\n

    \"\"<\/p>\n

    Step 2: <\/strong> In the Excel Options menu, select “Solver Add-in” in the “Add-ins” section, then click “OK”.<\/p>\n

    \"\"<\/p>\n

    Step 3: <\/strong> Then you can find the “Solver” in the “Analyze” section under the “Data” menu.<\/p>\n

    \"\"<\/p>\n

    <\/h2>\n
    \n
    \n

    Sample Question<\/p>\n<\/header>\n

    \n

    A heat exchanger uses superheated steam to heat up a stream of pure acetic acid.<\/p>\n

    \"\"<\/p>\n

    The following data can be used for calculating the enthalpy change of the acetic acid stream:<\/p>\n

    $$C_{p}=A+BT+CT^2+DT^3$$<\/p>\n

    where T is in K and [latex]C_{p}[\/latex] is given in J\/mol K.<\/p>\n\n\n\n\n
    <\/td>\nA<\/td>\nB<\/td>\nC<\/td>\nD<\/td>\n<\/tr>\n
    acetic acid<\/td>\n[latex]4.84[\/latex]<\/td>\n[latex]0.2549[\/latex]<\/td>\n[latex]-1.753E-4[\/latex]<\/td>\n[latex]4.949E-8[\/latex]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    The enthalpy change for superheated steam can be found using data from the steam table:<\/p>\n\n\n\n\n
    <\/td>\n300\u00b0C, 1 MPa<\/td>\n250\u00b0C, 1 MPa<\/td>\n<\/tr>\n
    [latex]\\hat{H}[\/latex] (J\/mol)<\/td>\n54990<\/td>\n53035<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    The boiling point for acetic acid at 1 atm is 117.9\u00b0C. Does the acetic acid boil in the heat exchanger? If not, calculate the final temperature of the acetic acid stream. Assume there is no energy loss due to heat transfer.<\/p>\n<\/div>\n<\/div>\n

     <\/p>\n

    Solution<\/h2>\n

    Because there are no other forms of energy transfer other than THE heat transfer between the streams, the energy balance simplifies to:<\/p>\n

    $$\\Delta\\dot{H}_{water}+\\Delta\\dot{H}_{acetic \\;acid}=0$$<\/p>\n

    Based on the type of data given to calculate enthalpy change, the [latex]\\Delta\\dot{H}[\/latex] term in the energy balance can be expanded to:<\/p>\n

    $$\\Delta\\dot{H}_{water}=\\dot{H}_f-\\dot{H}_i$$<\/p>\n

    \\begin{align*}
    \n\\Delta\\dot{H}_{acetic \\;acid}&=\\int_{T_i}^{T_f}C_pdT\\\\
    \n&=\\int_{T_i}^{T_f}A+BT+CT^2+DT^3 dT\\\\
    \n&=AT+\\frac{1}{2}BT^2+\\frac{1}{3}CT^3+\\frac{1}{4}DT^4\\;\\Bigg|_{T_i}^{T_f}\\\\
    \n&= A(T_f-T_i)+\\frac{1}{2}B(T_f-T_i)^2+\\frac{1}{3}C(T_f-T_i)^3+\\frac{1}{4}D(T_f-T_i)^4
    \n\\end{align*}<\/p>\n

    Step 1: <\/strong>Input given information that will be used in the calculation. This includes the given data to calculate enthalpy change, the molar flow rate of both substances, and the initial temperature of acetic acid.<\/p>\n

    \"\"<\/p>\n

    Step 2:\u00a0<\/strong>Calculate the molar enthalpy change. For water, this is calculated by subtracting the molar enthalpy values given at the final and initial temperatures. For acetic acid, we need to provide a guess of the final temperature to substitute into the equation.<\/p>\n

    \"\"<\/p>\n

    \"\"<\/p>\n

    Step 3:<\/strong> Calculate the total enthalpy change for both substances by multiplying the molar flow rate by the molar enthalpy change.<\/p>\n

    \"\"<\/p>\n

    ou<\/p>\n

    Step 4:\u00a0<\/strong>Use a cell to represent the sum of enthalpy change. If we have guessed the correct final temperature, the value of this cell should be 0. We will use solver to let excel perform the guess-and-check process for us.<\/p>\n

    \"\"<\/p>\n

    Step 5:\u00a0<\/strong>Select “Solver” from the “Data” menu in the header, and indicate that we want to solve for the final temperature of acetic acid that makes our [latex]\\text{sum of} \\delta H=0[\/latex]:<\/p>\n

      \n
    • Set objective to be the cell containing [latex]\\text{sum of} \\delta H[\/latex]<\/li>\n
    • To be: value of 0<\/li>\n
    • By changing variable cells containing the final temperature of acetic acid<\/li>\n
    • Click “Solve”<\/li>\n<\/ul>\n

      \"\"<\/p>\n

      Step 6:<\/strong> Click “OK” if solver finds a solution. If the solver cannot find a solution, it is maybe because our initial guess is too far away from the actual final temperature, if so, we can change the temperature and try to solve it again.<\/p>\n

      \"\"<\/p>\n

      Step 7:\u00a0<\/strong>After the window closes, the value of the final temperature of acetic acid and all cells affected by temperature are changed to the corresponding values calculated with the actual final temperature.<\/p>\n

      \"\"<\/p>\n

      Therefore, the final temperature of the acetic acid stream is [latex]364.7K[\/latex], which is equal to [latex]94.5\u00b0C[\/latex]. This temperature is lower than the boiling temperature of acetic acid at 1 atm, so the stream will not start to boil.<\/p>\n","protected":false},"author":949,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"back-matter-type":[],"contributor":[],"license":[],"class_list":["post-2452","back-matter","type-back-matter","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter"}],"about":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/types\/back-matter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/users\/949"}],"replies":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/comments?post=2452"}],"version-history":[{"count":1,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2452\/revisions"}],"predecessor-version":[{"id":2453,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2452\/revisions\/2453"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2452\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/media?parent=2452"}],"wp:term":[{"taxonomy":"back-matter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter-type?post=2452"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/contributor?post=2452"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/license?post=2452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}