Spreadsheet distillation curves

Section 1.4 presents a hands-on workshop for applying our spreadsheet to extrapolate an incomplete distillation curve. We note that the density distribution along with boiling point should be used (in step 3) whenever it is available because the assumption of constant Watson K factor always fails in low and high boiling-point ranges. 

There are two situations we may encounter when the distillation curve available is not a TBP curve and needs to be converted - (1) It is another ASTM type and (2) It is ASTM D1160 at vacuum pressure. The spreadsheet we have developed is able to solve these two cases. The following steps demonstrate how to convert an ASTM D1160 (at 10 mmHg) curve into a TBP curve. 

Aspen HYSYS Petroleum Refining includes a method to convert limited feed information (distillation curve, density, viscosity, refractive index, etc.) into kinetic lumps for use in the unit-level FCC model. In this section, we present an alternative method based on data and methods available in the public literature. We extend the work by Bollas et al. [52] to infer the kinetic lump composition from limited process data. This method uses techniques to normalize the distillation curve, cut the distillation curve into boiling-point lumps, and infer the composition of the each of these boiling-point lumps. We have developed all of these techniques into spreadsheets using Microsoft Excel. These spreadsheets are available in the DVD accompanying this text... 

Spreadsheet to convert distillation curves from ASTM type to another... 

We develop a spreadsheet to enable the conversion from different A STM distillation types to the TBP curve based the correlations from [35] (see Figure 6.19 and Section 1.3). 

Spreadsheet to fit distillation and density/specific gravity curves to beta distributions... 

---