Generating Workbooks - Decision Models

Generated Workbooks.

Dynamically generating the formulae in workbooks from database tables can produce workbooks that calculate extremely fast, because it is often possible to avoid using many time-expensive Excel features.

Build Time versus Run-Time:

Many workbooks contain a significant number of formulae and lookups that are concerned with getting the input data into the right shape for the calculations, or are being used as defensive measures against changes in the size or shape of the data.
These things do not change often, so can either be put in a separate spreadsheet that does not need to be recalculated, or you can use copy paste special values to eliminate the formulae.

These things do not change often, so can either be put in a separate spreadsheet that does not need to be recalculated, or you can use copy paste special values to eliminate the formulae.
FastExcel allows you to use extended calculation modes so that you can have some worksheets in manual calculation mode, and some worksheets in automatic calculation mode.

With FastExcel you can also make Excel only calculate the active workbook when multiple workbooks are open.

© 2001-2020 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster