![]() The strategy for solving such calculations is to specify a starting value and then “recycle” the value calculated later until the loop converges. In such a situation, a value is needed to continue the calculation, but that value is calculated later in the scheme. In a more general sense, many process calculations, when laid out in logical sequence, involve circular calculations. A process with a recycle stream involves a circular calculation that cannot proceed automatically because of its iterative nature. One of the main reasons chemical engineers became attracted to spreadsheets was for their ability to carry out flowsheet calculations. ![]() ![]() Share your tips, on Engage! Do you have some tips of your own about spreadsheets? If you're a member, I'd love you to share them on. As soon as you check the box 'Enable Iterative calculation', Excel will do a calculation of your model. It is up to you to decide how many iterations you want Excel to do before it stops, or what precision you need before Excel stops (whichever comes first).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |