Evolutionary Spreadsheet Solver in Optimal Engineering Design

被引:1
|
作者
Gajewski, Ryszard Robert [1 ]
机构
[1] Warsaw Univ Technol, Fac Civil Engn, Warsaw, Poland
关键词
OPTIMIZATION; DISCRETE;
D O I
10.1051/matecconf/201819601047
中图分类号
TU [建筑科学];
学科分类号
0813 ;
摘要
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.
引用
收藏
页数:6
相关论文
共 50 条
  • [1] New solver and optimal anticipation strategies design based on evolutionary computation for the game of MasterMind
    Maestro-Montojo, J.
    Salcedo-Sanz, S.
    Merelo, J. J.
    [J]. EVOLUTIONARY INTELLIGENCE, 2014, 6 (04) : 219 - 228
  • [2] Colonial competitive evolutionary Rao algorithm for optimal engineering design
    Band, Shahab S.
    Ardabili, Sina
    Danesh, Amir Seyed
    Mansor, Zulkefli
    AlShourbaji, Ibrahim
    Mosavi, Amir
    [J]. ALEXANDRIA ENGINEERING JOURNAL, 2022, 61 (12) : 11537 - 11563
  • [3] Design of integral spreadsheet calculator for engineering applications
    Dinckal, Cigdem
    [J]. COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2018, 26 (05) : 1159 - 1172
  • [4] Hybridizing the harmony search algorithm with a spreadsheet 'Solver' for solving continuous engineering optimization problems
    Ayvaz, M. Tamer
    Kayhan, Ali Haydar
    Ceylan, Huseyin
    Gurarslan, Gurhan
    [J]. ENGINEERING OPTIMIZATION, 2009, 41 (12) : 1119 - 1144
  • [5] Evolutionary Design in Engineering
    Deb, Kalyanmoy
    [J]. DESIGN BY EVOLUTION: ADVANCES IN EVOLUTIONARY DESIGN, 2008, : 267 - 271
  • [6] Spreadsheet Engineering
    Cunha, Jacome
    Fernandes, Joao Paulo
    Mendes, Jorge
    Saraiva, Joao
    [J]. CENTRAL EUROPEAN FUNCTIONAL PROGRAMMING SCHOOL, CEFP 2013, 2015, 8606 : 246 - 299
  • [7] Optimal Lightweight Engineering Design via a Three-Block Solver Scheme for Mechanical Analysis
    Wehrle, Erich
    [J]. OPTIMAL DESIGN AND CONTROL OF MULTIBODY SYSTEMS, IUTAM 2022, 2024, 42 : 16 - 29
  • [8] The Plymouth Engineering Design Centre: evolutionary engineering design
    Parmee, IC
    [J]. ENGINEERING DESIGN CONFERENCE '98: DESIGN REUSE, 1998, : 123 - 132
  • [9] Evolutionary Design of Engineering Constructions
    Muc, Aleksander
    [J]. LATIN AMERICAN JOURNAL OF SOLIDS AND STRUCTURES, 2018, 15 (04):
  • [10] ENGINEERING CALCULATIONS ON A SPREADSHEET
    SOWA, CJ
    [J]. CHEMICAL ENGINEERING, 1987, 94 (03) : 61 - 63