Solving dynamic optimization problems on a personal computer using an electronic spreadsheet
type: Item
instance of: scholarly article
title: Solving dynamic optimization problems on a personal computer using an electronic spreadsheet
zbMATH Open document ID: 0664.90091
DOI: 10.1016/0005-1098(89)90123-4
author: M. Parlar
published in: Automatica
publication date: 1989-01-01T00:00:00Z
review text: Powerful desk top computers of today combined with the easy to manipulate electronic spreadsheet programs (e.g. Lotus 1-2-3) are being used quite extensively in business applications such as planning, forecasting and accounting. Currently we are also witnessing a proliferation of optimization/operations research related software which can solve reasonable size nonlinear programs (e.g. Eureka: The Solver), linear and integer programming problems (e.g. LINDO), etc. on the IBM-PC microcomputer. Despite the availability of these packages, there seems to be a lack of software for solving dynamic optimization problems, i.e. dynamic programming (DP) and optimal control. The purpose of this paper is to show how easily the Lotus 1-2-3 electronic spreadsheet program can be used to solve discrete state and discrete stage dynamic programs, and discrete time linear quadratic tracking control problems on an IBM-PC.
Mathematics Subject Classification ID: 90C39
Mathematics Subject Classification ID: 65K05
Mathematics Subject Classification ID: 49L20
zbMATH DE Number: 4087456
zbMATH Keywords: software
zbMATH Keywords: dynamic optimization
zbMATH Keywords: optimal control
zbMATH Keywords: Lotus 1-2-3
describes a project that uses: Lotus 1-2-3
MaRDI profile type: Publication
full work available at URL: 0005-1098(89)90123-4
OpenAlex ID: W2077347134
cites work: Q5538306
cites work: Q4168359
cites work: Q4042790
cites work: Q5588251
description: scientific article; zbMATH DE number 4087456