A Designer’s Spreadsheet-Reference-Cited by-同舟云学术

A Designer’s Spreadsheet

Published:1997-03-01 Issue:1 Volume:119 Page:48-56
ISSN:1050-0472
Container-title:Journal of Mechanical Design
language:en
Short-container-title:

Author:

Ramaswamy R.¹,Ulrich Karl²

Affiliation:

1. Hewlett Packard Espan˜ola, S.A., Barcelona, Spain

2. The Wharton School, University of Pennsylvania, Philadelphia, PA

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.

Publisher

ASME International

Subject

Computer Graphics and Computer-Aided Design,Computer Science Applications,Mechanical Engineering,Mechanics of Materials

Link

http://asmedigitalcollection.asme.org/mechanicaldesign/article-pdf/119/1/48/5527722/48_1.pdf

Reference17 articles.

1. Dobson, W. G., and Wolff, A. K., 1984, Engineering Problem Solving With Spreadsheet Programs, American Society for Metals.

2. Gleicher, M., and Witkin, A., “Differential Manipulation,” Graphics Interface ’91, June 1991.

3. Gonda, M., Fertig, K. W., and Teeter, R. J., “Aerospace Conceptual Design Using An Intelligent Design and Analysis Environment: Design Sheet,” AIAA 1992 Aircraft Design Systems Meeting, 1992.

4. Kral, I. H., The Excel Spreadsheet for Engineers and Scientists, Prentice Hall, 1992.

5. Lai, K-L., Malone, T., and Yu, K-C., “Object Lens: A Spreadsheet for Cooperative Work,” ACM Transactions on Office Information Systems, 1988.

Cited by 3 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Research Note—User Design of Customized Products;Marketing Science;2007-03

2. Decision-Based Conceptual Design: Modeling and Navigating Heterogeneous Design Spaces;Journal of Mechanical Design;2005-01-01

3. Using a neural network to determine fitness in genetic design;Inverse Problems in Science and Engineering;2004-12