Given a sample mass and TLC data, a spreadsheet has been developed that provides information on the amount of silica gel needed, the optimal fraction size, and the degree of separation to be expected before flash chromatography is attempted. The spreadsheet is the first utility of its kind to accurately estimate the retention volume and band volume of analytes, as well as the fraction numbers expected to contain each analyte, and the resolution between adjacent peaks. This information allows users to select optimal parameters for preparative-scale separations before the flash column itself is attempted; ensuring a successful first separation.