Harmon, M. (2013) Step-By-Step Optimization with Excel Solver—The Excel Statistical Master. Excel Master Series, Kindle Edition, Amazon Digital Services.

has been cited by the following article:

• TITLE: Model of Maintenance Planning Based on Trend of Machines Failures with Two Priorities

  AUTHORS: Erik Prada, Alena Pešková, Michael Valášek

  KEYWORDS: Microsoft Excel, Supplement Solver, Maintenance Planning, Priority and Non-Priority Failures, Linear Programming

  JOURNAL NAME: World Journal of Engineering and Technology, Vol.3 No.4, November 11, 2015

  ABSTRACT: In this article we are discussing the suggestion of planning maintenance in such situation that we have failures in database of failures and maintenance registered also according to type of failure— priority or non-priority. We are assuming that maintenance must be mainly oriented on avoiding major failures of machines. The effect of maintenance manifests with delay and is dependent on development of failures. We express this problem as linear programming task that is solvable with Solver-extension of application Excel. We demonstrate the suggested solution on example of failures of machines between years 2010 and 2012.