Excel macro for post-processing of Thermoptim files

An Excel spreadsheet with two macros, called MacroPostTraitementRef.xls, was developed to allow a relatively easy post-processing of a set of project files relating to the same model and therefore of the same structure.

These macros allow one to load project file into the spreadsheets, then extract the values chosen by the user from the cells of the different files. These can be simple values or “identifier=value” pairs. Their use is explained in the document below.

This spreadsheet is particularly interesting for processing simulations of off-design system operation.

Two versions are offered: the oldest is compatible with Excel versions through 2003, and the second with Excel 2007.