A spreadsheet method for continuous-time model identification

This paper proposes a spreadsheet method for continuous-time model identification. More precisely, the method is based on the use of the Excel Solver program. First, implementation issues are highlighted. Afterwards, the identification method is illustrated through several examples, including a Monte Carlo simulation analysis to demonstrate the robustness of the tool against noise. The method is also applied to construct the model of two laboratory pilot-scale processes. The results show that process identification can be carried out satisfactorily using the Solver tool.

► How to use Excel Solver program for constructing dynamic continuous-time model.
► The method is illustrated through several examples.
► Robustness against noise is evaluated using a Monte Carlo simulation approach.
► The method is applied to construct models of two laboratory pilot-scale processes.
► How to automate the model construction using the VBA programming facility.