Combining simulation to nonlinear fitting for the determination of rate constants of elementary reactions by using Excel spreadsheets
Aldawsari, Ammar M. Tighezza* , Daifallah M. Aldhayan and Nouir A. . 2012
A common problem in chemistry is to determine parameters (constants) in an equation used to represent experimental data. Examples are fitting a set of data to a model equation (straight line or curve) to obtain unknown parameters. In chemical kinetics, a set of data is usually a number of concentrations versus time, but the model equation is not well defined! Instead of a well defined model equation we have a set of coupled ODE’s (ordinary differential equations) which represent rate equations for reactants and products. The analytical integration of these ODE’s is rarely possible. The numerical integration is the alternative. In this work are combined the simulation of chemical reactions, by using numerical integration, and nonlinear regression (curve fitting) by using “Solver add-in” of Microsoft Excel to find rate constants of elementary reactions from experimental data. This method is illustrated on three complex mechanisms. The simulation of chemical reactions in Excel spreadsheets is illustrated with/without VBA programming. The automation (automatic obtaining of rate equations from mechanism: no need of chemical kinetics knowledge from the end user!) of mechanism simulation is demonstrated on many example.
We investigate the structural, optoelectronic, and thermoelectric properties of halide double perovskite X2GeSnI6 (X = Rb, Cs) compounds employing the full potential linearized augmented plane…
The research was done on the creation and use of bi-metal sulfide thin film, Nd2S3:Ni9S8. 41 nm-sized crystallites with 80% crystallinity were found in the material. The evaluated optical…
Perovskite solar cell (PSC) technology is extensively used in commercial sectors, but concerns about the use of lead and degradable components in cells are increasing.