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

How to turn on \"Iterations\" in Excel<\/h2>\r\nStep 1:<\/strong> After you open a new notebook, click the \"File\" session in the header. Note that you will only be able to turn on iterations when there is a notebook open.\r\n\r\n\"\"\r\n\r\nStep 2:<\/strong> Select the \"Options\" appearing at the bottom of the menu.\r\n\r\n\"\"\r\n\r\nStep 3:\u00a0<\/strong>Check the \"Enable Iterative Calculations\" in the \"Formulas\" session and click \"OK\". This will allow excel to perform looped calculations when every variable is dependent on previous variables in the loop, for example, calculating flowrates when a recycle stream is present.\r\n\r\n\"\"\r\n
\r\n

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

\r\n\r\nGrain extract is produced by the process below. Ethanol is synthesized by yeast in the reactor. In this idealistic process, the yeast converts 2kg of grain into 1 kg of ethanol and 1 kg of water. A perfectly efficient yeast reactor (efficiency = 1) would convert all the grain entering the reactor. A reactor with efficiency =0.5 would convert half of the grain entering the reactor and so on. Below are some additional specifications:\r\n\r\n\u2022 The feed is 100 kg\/min, 20 wt% grain, 80 wt% water\r\n\u2022 The reactor efficiency is 0.25\r\n\u2022 The grain in the slurry retains 1kg of ethanol-water solution for every 10kg of grain\r\n\u2022 5 wt% of the slurry is purged.\r\n\u2022 The mass ratio of water and ethanol in the slurry is the same as in the reactor effluent\r\n\r\n\"\"\r\n\r\n<\/div>\r\n<\/div>\r\n

Solution<\/h2>\r\nStep 1:<\/strong> Set up the spreadsheet using the given process specifications and components in each stream as indicated in the question. \"\"\r\n\r\nStep 2: <\/strong>Express for the individual component flowrate and total flowrate in each stream. For feed:\r\n
    \r\n \t
  • total = 100 kg\/min (given)<\/li>\r\n \t
  • grain = 0.2*total<\/li>\r\n \t
  • water = total - grain<\/li>\r\n<\/ul>\r\n\"\"\r\n\r\nStep 3:\u00a0<\/strong>Reactor Feed:\r\n
      \r\n \t
    • grain = grain in feed + grain in recycle<\/li>\r\n \t
    • water = water in feed + water in recycle<\/li>\r\n \t
    • ethanol = ethanol in recycle<\/li>\r\n \t
    • total = grain + water + ethanol<\/li>\r\n<\/ul>\r\nNote: If we reference an empty cell (like the flowrates in the recycle stream), the value will be calculated as 0. This will be updated after we input the formulas for the flow rate in the recycle stream.\r\n\r\n\"\"\r\n\r\nStep 4:<\/strong> Reactor effluent:\r\n
        \r\n \t
      • grain = grain in reactor feed * (1-reactor efficiency)<\/li>\r\n \t
      • water = water in reactor feed + reactor efficiency * grain in reactor feed * 1\/2<\/li>\r\n \t
      • ethanol = ethanol in reactor feed + reactor efficiency * grain in reactor feed * 1\/2<\/li>\r\n \t
      • total = grain + water + ethanol<\/li>\r\n<\/ul>\r\nNote: The 1\/2 in the flowrate calculations for water and ethanol comes from the mass balance for the conversion of grain. 1\/2 is the ratio of [latex]\\frac{\\text{mass of water produced}}{\\text{mass of grain consumed}}[\/latex] and\u00a0 [latex]\\frac{\\text{mass of ethanol produced}}{\\text{mass of grain consumed}}[\/latex]\r\n\r\n\"\"\r\n\r\nStep 5:<\/strong> Slurry:\r\n
          \r\n \t
        • grain = grain in reactor effluent<\/li>\r\n \t
        • water = grain in slurry * solution\/grain ratio in slurry * [latex]\\frac{\\text{water in reactor effluent}}{\\text{water in reactor effluent+ethanol in reactor effluent}}[\/latex]<\/li>\r\n \t
        • ethanol =\u00a0grain in slurry * solution\/grain ratio in slurry * [latex]\\frac{\\text{ethanol in reactor effluent}}{\\text{water in reactor effluent+ethanol in reactor effluent}}[\/latex]<\/li>\r\n \t
        • total = grain + water + ethanol<\/li>\r\n<\/ul>\r\n\"\"\r\n\r\nStep 6:<\/strong> Grain extract:\r\n
            \r\n \t
          • water= water in reactor effluent - water in slurry<\/li>\r\n \t
          • ethanol = ethanol in reactor effluent\u00a0 - ethanol in slurry<\/li>\r\n \t
          • total = water + ethanol<\/li>\r\n<\/ul>\r\n\"\"\r\n\r\nStep 7:<\/strong> Purge:\r\n
              \r\n \t
            • grain = fraction of slurry purged * grain in slurry<\/li>\r\n \t
            • water = fraction of slurry purged * water in slurry<\/li>\r\n \t
            • ethanol = fraction of slurry purged * ethanol in slurry<\/li>\r\n \t
            • total = grain + water + ethanol<\/li>\r\n<\/ul>\r\n\"\"\r\n\r\nStep 8:<\/strong> Recycle:\r\n
                \r\n \t
              • grain = grain in slurry - grain in purge<\/li>\r\n \t
              • water = water in slurry - water in purge<\/li>\r\n \t
              • ethanol = ethanol in slurry - ethanol in purge<\/li>\r\n \t
              • total = grain + water + ethanol<\/li>\r\n<\/ul>\r\nBecause the recycle stream is the last step in the loop, we can see the other values being updated as we input the formulas for flow rates in the recycle stream.\r\n\r\n\"\"\r\n\r\nNow the flow rates of all streams and all components in each stream are fully solved.","rendered":"

                How to turn on “Iterations” in Excel<\/h2>\n

                Step 1:<\/strong> After you open a new notebook, click the “File” session in the header. Note that you will only be able to turn on iterations when there is a notebook open.<\/p>\n

                \"\"<\/p>\n

                Step 2:<\/strong> Select the “Options” appearing at the bottom of the menu.<\/p>\n

                \"\"<\/p>\n

                Step 3:\u00a0<\/strong>Check the “Enable Iterative Calculations” in the “Formulas” session and click “OK”. This will allow excel to perform looped calculations when every variable is dependent on previous variables in the loop, for example, calculating flowrates when a recycle stream is present.<\/p>\n

                \"\"<\/p>\n

                \n
                \n

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

                \n

                Grain extract is produced by the process below. Ethanol is synthesized by yeast in the reactor. In this idealistic process, the yeast converts 2kg of grain into 1 kg of ethanol and 1 kg of water. A perfectly efficient yeast reactor (efficiency = 1) would convert all the grain entering the reactor. A reactor with efficiency =0.5 would convert half of the grain entering the reactor and so on. Below are some additional specifications:<\/p>\n

                \u2022 The feed is 100 kg\/min, 20 wt% grain, 80 wt% water
                \n\u2022 The reactor efficiency is 0.25
                \n\u2022 The grain in the slurry retains 1kg of ethanol-water solution for every 10kg of grain
                \n\u2022 5 wt% of the slurry is purged.
                \n\u2022 The mass ratio of water and ethanol in the slurry is the same as in the reactor effluent<\/p>\n

                \"\"<\/p>\n<\/div>\n<\/div>\n

                Solution<\/h2>\n

                Step 1:<\/strong> Set up the spreadsheet using the given process specifications and components in each stream as indicated in the question. \"\"<\/p>\n

                Step 2: <\/strong>Express for the individual component flowrate and total flowrate in each stream. For feed:<\/p>\n

                  \n
                • total = 100 kg\/min (given)<\/li>\n
                • grain = 0.2*total<\/li>\n
                • water = total – grain<\/li>\n<\/ul>\n

                  \"\"<\/p>\n

                  Step 3:\u00a0<\/strong>Reactor Feed:<\/p>\n

                    \n
                  • grain = grain in feed + grain in recycle<\/li>\n
                  • water = water in feed + water in recycle<\/li>\n
                  • ethanol = ethanol in recycle<\/li>\n
                  • total = grain + water + ethanol<\/li>\n<\/ul>\n

                    Note: If we reference an empty cell (like the flowrates in the recycle stream), the value will be calculated as 0. This will be updated after we input the formulas for the flow rate in the recycle stream.<\/p>\n

                    \"\"<\/p>\n

                    Step 4:<\/strong> Reactor effluent:<\/p>\n

                      \n
                    • grain = grain in reactor feed * (1-reactor efficiency)<\/li>\n
                    • water = water in reactor feed + reactor efficiency * grain in reactor feed * 1\/2<\/li>\n
                    • ethanol = ethanol in reactor feed + reactor efficiency * grain in reactor feed * 1\/2<\/li>\n
                    • total = grain + water + ethanol<\/li>\n<\/ul>\n

                      Note: The 1\/2 in the flowrate calculations for water and ethanol comes from the mass balance for the conversion of grain. 1\/2 is the ratio of [latex]\\frac{\\text{mass of water produced}}{\\text{mass of grain consumed}}[\/latex] and\u00a0 [latex]\\frac{\\text{mass of ethanol produced}}{\\text{mass of grain consumed}}[\/latex]<\/p>\n

                      \"\"<\/p>\n

                      Step 5:<\/strong> Slurry:<\/p>\n

                        \n
                      • grain = grain in reactor effluent<\/li>\n
                      • water = grain in slurry * solution\/grain ratio in slurry * [latex]\\frac{\\text{water in reactor effluent}}{\\text{water in reactor effluent+ethanol in reactor effluent}}[\/latex]<\/li>\n
                      • ethanol =\u00a0grain in slurry * solution\/grain ratio in slurry * [latex]\\frac{\\text{ethanol in reactor effluent}}{\\text{water in reactor effluent+ethanol in reactor effluent}}[\/latex]<\/li>\n
                      • total = grain + water + ethanol<\/li>\n<\/ul>\n

                        \"\"<\/p>\n

                        Step 6:<\/strong> Grain extract:<\/p>\n

                          \n
                        • water= water in reactor effluent – water in slurry<\/li>\n
                        • ethanol = ethanol in reactor effluent\u00a0 – ethanol in slurry<\/li>\n
                        • total = water + ethanol<\/li>\n<\/ul>\n

                          \"\"<\/p>\n

                          Step 7:<\/strong> Purge:<\/p>\n

                            \n
                          • grain = fraction of slurry purged * grain in slurry<\/li>\n
                          • water = fraction of slurry purged * water in slurry<\/li>\n
                          • ethanol = fraction of slurry purged * ethanol in slurry<\/li>\n
                          • total = grain + water + ethanol<\/li>\n<\/ul>\n

                            \"\"<\/p>\n

                            Step 8:<\/strong> Recycle:<\/p>\n

                              \n
                            • grain = grain in slurry – grain in purge<\/li>\n
                            • water = water in slurry – water in purge<\/li>\n
                            • ethanol = ethanol in slurry – ethanol in purge<\/li>\n
                            • total = grain + water + ethanol<\/li>\n<\/ul>\n

                              Because the recycle stream is the last step in the loop, we can see the other values being updated as we input the formulas for flow rates in the recycle stream.<\/p>\n

                              \"\"<\/p>\n

                              Now the flow rates of all streams and all components in each stream are fully solved.<\/p>\n","protected":false},"author":949,"menu_order":5,"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-2454","back-matter","type-back-matter","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2454","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=2454"}],"version-history":[{"count":1,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2454\/revisions"}],"predecessor-version":[{"id":2455,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2454\/revisions\/2455"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter\/2454\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/media?parent=2454"}],"wp:term":[{"taxonomy":"back-matter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/pressbooks\/v2\/back-matter-type?post=2454"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/contributor?post=2454"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/chbe220\/wp-json\/wp\/v2\/license?post=2454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}