Issue №1, 2017



Scheduling of equipment using MS Excel


N. V. Katargin, Financial University under the Government of the Russian Federation (Moscow, Russia)

Full article 

The technology for scheduling of the equipment utilization using  Evolutionary solver that is part of the Solver in MS Excel.

Keywords: Scheduling, sequence, MS Excel, genetic algorithm, VBA.


  1. GladkovL.A., KureichikV.V., Kureichik. M. Geneticheskie algoritmi [Genetic Algorithms]. – Moscow: Fizmatlit, 2006. 320 p.
  2. Emelyanov V.V., Kureichik V.V., Kureichik V.M. Teoriya i praktika evolyutsionnogo modelirovaniya [Theory and Practice of the Evolutionary Modelling]. - Moscow: Fizmatlit, 2003. 432 p.
  3. Akker J.M., Diepen G., Hoogeveen J.A. Minimizing total weighted tardiness on a single machine with release dates and equal-length jobs // Sched, 2010, no.13(6), pp. 561–576.
  4. Anderson E.J., Potts C.N. Online scheduling of a single machine to minimize total weighted completion time // Oper. Res. 2004, pp. 686–697.
  5. Batsyn M., Goldengorin B., Pardalos P., Sukhov P. Online heuristic for the preemptive single machine scheduling problem of minimizing the total weighted completion time // Optimization Methods & Software, 2014, Vol. 29, no.5, pp. 955–963. Available at: (accessed:17.01.2017).
  6. Belouadah H., Posner M.E., Potts C.N. Scheduling with release dates on a single machine to minimize total weighted completion time // Diskretnaja Prikladnaja Matematika, 1992, pp. 213–231.

For citation: Katargin N.V. Scheduling of equipment using MS Excel // Corporate governance and innovative economic development of the North: Bulletin of the Research Center of  Corporate Law, Management and Venture Capital of Syktyvkar State University. 2017. № 1. P. 158-163.