Evolutionary Spreadsheet Solver in Optimal Engineering Design
Keyword(s):
Spreadsheet solver proved to be an excellent tool to solve operational research problems modelled as linear programming problems. Majority of engineering design problems are nonlinear in nature. The paper presents ability of spreadsheet solver to solve such problems as: four bar statically determinate truss, compound gear train problem and sequence determination problem by means of evolutionary engine.
2017 ◽
Vol 5
(1)
◽
pp. 104-119
◽
2016 ◽
Vol 2016
◽
pp. 1-22
◽