A Designer’s Spreadsheet
- 1 March 1997
- journal article
- Published by ASME International in Journal of Mechanical Design
- Vol. 119 (1) , 48-56
- https://doi.org/10.1115/1.2828788
Abstract
We have observed that many designers use spreadsheet programs for preliminary parametric design calculations. The primary reason for this appears to be the flexibility and ease of use of spreadsheets as compared to more advanced analysis tools. However, current commercially available spreadsheets were originally designed for finance and accounting and do not naturally support the analytical techniques used in design and engineering. In this paper, we propose a fundamentally different kind of spreadsheet for use in preliminary parametric design. We describe the features of this spreadsheet that make it especially suitable for preliminary parametric design, discuss the theoretical basis for implementing it and present the results of preliminary user tests.Keywords
This publication has 6 references indexed in Scilit:
- Solving Parametric Design Problems Requiring Configuration ChoicesJournal of Mechanical Design, 1993
- The Excel Spreadsheet for Engineers and ScientistsComputers in Physics, 1993
- Interactive dynamicsACM SIGGRAPH Computer Graphics, 1990
- Constraint Management in Conceptual DesignPublished by Springer Nature ,1989
- Object lens: a “spreadsheet” for cooperative workPublished by Association for Computing Machinery (ACM) ,1988
- Linear Algebra and Its ApplicationsMathematics of Computation, 1976