Teaching Mathematics and its Applications Advance Access originally published online on August 6, 2007
Teaching Mathematics and its Applications 2008 27(1):48-52; doi:10.1093/teamat/hrm013
| ||||||||||||||||||||||||||||||||||||||||||||||||
Getting the best out of Excel
Address for correspondence: Chris Heys, 13 Kingshaye Road, Telford, TF1 1RQ, UK. E-mail: christopher_heys{at}yahoo.co.uk
Submitted February 2006; accepted April 2007
Excel, Microsoft's spreadsheet program, offers several tools which have proven useful in solving some optimization problems that arise in operations research.
We will look at two such tools, the Excel modules called Solver and Goal Seek—this after deriving an equation, called the cash accumulation equation, to be used in conjunction with them.
Chris Heys A cartographic consultant and his principal use of Excel is in the preparation of statistical maps, depicting rates of unemployment for example. The work is mostly for public-sector bodies such as regional development agencies.