This content is not included in your SAE MOBILUS subscription, or you are not logged in.
Web-Based Vehicle Performance Simulations Using Microsoft Excel
ISSN: 0148-7191, e-ISSN: 2688-3627
Published March 05, 2001 by SAE International in United States
Annotation ability available
Event: SAE 2001 World Congress
Although computer models for vehicle and sub-system performance simulations have been developed and used extensively in the past several decades, there is currently a need to enhance the overall availability of these types of tools. Increasing demands on vehicle performance targets have intensified the need to obtain rapid feedback on the effects of vehicle modifications throughout the entire development cycle.
At the same time, evolution of the PC and development of Web-based applications have contributed to the availability, accessibility, and user-friendliness of sophisticated computer analysis.
Web engineering is an ideal approach in supporting globalization and is a cost-effective design-analysis integration business strategy. There is little doubt that this new approach will have positive impacts on product cost, quality, and development cycle time.
This paper will show how Microsoft Excel and the Web can be powerful and effective tools in the development process. To demonstrate the technique, a vehicle wide-open-throttle acceleration performance simulation example will be presented.
Basic equations and assumptions will be reviewed, followed by a discussion on the consideration of several special conditions. Applicable programming techniques will be presented. An example of Web-based execution is provided.
CitationFrank, D. and Shih, S., "Web-Based Vehicle Performance Simulations Using Microsoft Excel," SAE Technical Paper 2001-01-0335, 2001, https://doi.org/10.4271/2001-01-0335.
- Shih Shan “Automotive Powertrains II” The University of Michigan-Dearborn 2000
- Gillespie Thomas D. “Fundamentals of Vehicle Dynamics,” SAE 1992
- Dodge Mark Kinata Chris Stinson Craig “Running Microsoft Excel 97,” Microsoft Press 1997
- Jacobson Reed “Step by Step Microsoft Excel 97 Visual Basic,” Microsoft Press 1997
- Shammas Namir C. “Mathematical Algorithms in Visual Basic for Scientists and Engineers,” McGraw-Hill 1996
- “10 Best Engines 2000,” Ward's Auto World January 2000
- Swan Tony “Bending the Rules,” Car and Driver October 1999
- Swan Tony “Road Test: 2001 Chrysler PT Cruiser,” Car and Driver June 2000