• Medientyp: E-Artikel
  • Titel: Spreadsheet Aided System Engineering and Optimization
  • Beteiligte: Mincer, Tom R.; Hooper, David M.
  • Erschienen: Wiley, 1997
  • Erschienen in: INCOSE International Symposium
  • Sprache: Englisch
  • DOI: 10.1002/j.2334-5837.1997.tb02171.x
  • ISSN: 2334-5837
  • Schlagwörter: General Earth and Planetary Sciences ; General Environmental Science
  • Entstehung:
  • Anmerkungen:
  • Beschreibung: <jats:title>ABSTRACT</jats:title><jats:p>The Excel™ spreadsheet has become a valuable, powerful engineering tool that now provides strategic capabilities to:</jats:p><jats:p><jats:list list-type="bullet"> <jats:list-item><jats:p>create graphical user interfaces (GUIs)</jats:p></jats:list-item> <jats:list-item><jats:p>command other languages like FORTRAN and C through Dynamic Link Libraries (DLLs)</jats:p></jats:list-item> <jats:list-item><jats:p>control an integrated object oriented programming language called Visual Basic Applications (VBA)</jats:p></jats:list-item> <jats:list-item><jats:p>command databases</jats:p></jats:list-item></jats:list></jats:p><jats:p>The GUI capability of Excel allows the system engineer to create windows like applications (icon driven) with minimum effort. This GUI capability enhances system information presentation and provides the means to manage system information flow efficiently. Excel allows a design team to redefine the “back of the envelope calculation.” This is accomplished by interfacing with other languages such as FORTRAN and C, its own programming language VBA, and an optimization tool called Solver. With the modular, platform nature of Excel, engineers can now apply the system engineering process and develop unique applications devoted to their project team needs.</jats:p>