Solve Complex Differential Equations with Excel

Four differential equations and one algebraic equation are solved with Excel using Euler's method. Complex sets of differential equations often do not have an analytic (exact) solution but may need numerical methods to find an approximate solution. See apmonitor.com/che263 for additional course content.

[@rajeshkumarsharma5811]

great work. helped a lot.

[@guardiansps5775]

Thanks for sharing.

[@PrivateIsleProductions]

exactly what i wanted

[@franktoffel]

Selectivity is tricky to optimize since it doesn't care about the quantity being formed. Usually is better to set as objective function the yield ;)

[@apm]

+Franz Navarro, good point. The yield went to zero as the selectivity was optimized to one. The optimization solution surprised me the first time through, but it makes sense to limit the concentration of B so that very little D is produced.

[@user-xh2bl7vm8j]

Hey, Can you give me a example of delay differential equation's parameter estimation using Excel?? thanks!

[@apm]

Special problem #3 has an example Excel sheet that estimates dead time. apmonitor.com/che436/index.php/Main/CourseHomework