Novel Spreadsheet Direct Method for Optimal Control Problems
AbstractWe devise a simple yet highly effective technique for solving general optimal control problems in Excel spreadsheets. The technique exploits Excel’s native nonlinear programming (NLP) Solver Command, in conjunction with two calculus worksheet functions, namely, an initial value problem solver and a discrete data integrator, in a direct solution paradigm adapted to the spreadsheet. The technique is tested on several highly nonlinear constrained multivariable control problems with remarkable results in terms of reliability, consistency with pseudo-spectral reported answers, and computing times in the order of seconds. The technique requires no more than defining a few analogous formulas to the problem mathematical equations using basic spreadsheet operations, and no programming skills are needed. It introduces an alternative, simpler tool for solving optimal control problems in social and natural science disciplines. View Full-Text
- Supplementary File 1:
Supplementary (ZIP, 231 KB)
A printed edition of this Special Issue is available here.
Share & Cite This Article
Ghaddar, C.K. Novel Spreadsheet Direct Method for Optimal Control Problems. Math. Comput. Appl. 2018, 23, 6.
Ghaddar CK. Novel Spreadsheet Direct Method for Optimal Control Problems. Mathematical and Computational Applications. 2018; 23(1):6.Chicago/Turabian Style
Ghaddar, Chahid K. 2018. "Novel Spreadsheet Direct Method for Optimal Control Problems." Math. Comput. Appl. 23, no. 1: 6.
Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.