Next Article in Journal
Bifurcation and Chaos in Real Dynamics of a Two-Parameter Family Arising from Generating Function of Generalized Apostol-Type Polynomials
Next Article in Special Issue
Optimal Control Analysis of a Mathematical Model for Breast Cancer
Previous Article in Journal / Special Issue
Solution of Fuzzy Differential Equations Using Fuzzy Sumudu Transforms
Article

Novel Spreadsheet Direct Method for Optimal Control Problems

ExcelWorks LLC, Sharon, MA 02067, USA
Math. Comput. Appl. 2018, 23(1), 6; https://doi.org/10.3390/mca23010006
Received: 26 December 2017 / Revised: 22 January 2018 / Accepted: 23 January 2018 / Published: 25 January 2018
(This article belongs to the Special Issue Optimization in Control Applications)
We 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
Keywords: optimal control; dynamical optimization; parameter estimation; differential equations; spreadsheet; Excel Solver optimal control; dynamical optimization; parameter estimation; differential equations; spreadsheet; Excel Solver
Show Figures

Figure 1

MDPI and ACS Style

Ghaddar, C.K. Novel Spreadsheet Direct Method for Optimal Control Problems. Math. Comput. Appl. 2018, 23, 6. https://doi.org/10.3390/mca23010006

AMA Style

Ghaddar CK. Novel Spreadsheet Direct Method for Optimal Control Problems. Mathematical and Computational Applications. 2018; 23(1):6. https://doi.org/10.3390/mca23010006

Chicago/Turabian Style

Ghaddar, Chahid K. 2018. "Novel Spreadsheet Direct Method for Optimal Control Problems" Mathematical and Computational Applications 23, no. 1: 6. https://doi.org/10.3390/mca23010006

Find Other Styles
Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Article Access Map by Country/Region

1
Back to TopTop