Spreadsheet-based interactive design and analysis of mechanisms using Excel and Ch

Kabileshkumar G. Cheetancheri, Harry H. ChengAdvances 2008 · DOI

TL;DR

This paper introduces a novel system that leverages the user-friendly interface of Microsoft Excel and the powerful C/C++ interpreter, Ch, to enable interactive design and analysis of planar mechanisms. By integrating these tools, the system simplifies complex kinematic and dynamic analyses, making them accessible without extensive programming knowledge, thus accelerating the design and educational process for engineers.

What Problem Does This Paper Address?

Designing and analyzing mechanical mechanisms, especially complex ones, traditionally requires specialized software with steep learning curves or significant programming effort. While general-purpose tools like ADAMS and DADS are powerful, they demand deep subject knowledge. Existing specialized software, though easier to use, can still be limiting. The authors aim to bridge this gap by creating a system that combines the intuitive nature of spreadsheets with robust computational capabilities, making mechanism analysis and design more accessible for both educational and rapid prototyping purposes. They specifically address the challenge of providing a seamless interface for users to input mechanism parameters, perform analyses (kinematic, dynamic, graphical plotting, animation), and visualize results without needing to write complex code.

Methods

The core of the proposed system is the integration of Microsoft Excel with the Ch programming language and its associated Ch Mechanism Toolkit, facilitated by an Excel add-in called ChExcel.

  • Excel as the Front-End: Excel spreadsheets serve as the user interface. Users input mechanism parameters (link lengths, angles, etc.) directly into designated cells.
  • Ch as the Back-End Engine: Ch, an embeddable C/C++ interpreter, handles the heavy computational lifting. It conforms to ISO C standards and includes features for numerical computing and graphical plotting, similar to MATLAB.
  • ChExcel Integration: This add-in acts as the bridge between Excel and Ch. It allows Excel to call Ch functions and scripts, and for Ch to access data from Excel cells. This is achieved through simple ChExcel functions like ChPutMatrix (to send data from Excel to Ch) and ChGetMatrix (to retrieve results from Ch back to Excel).
  • Ch Mechanism Toolkit: This toolkit provides pre-built C/C++ classes and functions for various mechanism analyses (kinematic and dynamic), graphical plotting, and animation. This means users don't need to implement these algorithms from scratch.
  • Script-Based Analysis: Specific C/C++ script files (e.g., fb_pos_initialization.ch, fb_angularpos.ch) are associated with different analysis tasks. These scripts are executed via ChExcel functions within the spreadsheet.
  • Open Architecture: The system is designed to be extensible. Users can examine the provided source code and extend the toolkit to analyze other types of mechanisms or add new functionalities.

Datasets

Not discussed in the paper. The paper focuses on demonstrating the system's capabilities with example mechanisms, particularly a four-bar linkage, using user-defined input parameters rather than pre-existing datasets.

Key Insights and Ideas

  • Democratizing Mechanism Analysis: The most significant insight is the successful fusion of a widely accessible tool (Excel) with a powerful computational language (C/C++ via Ch) to significantly lower the barrier to entry for complex engineering analysis.
  • Interactive Design Loop: The spreadsheet interface allows for rapid iteration. Users can quickly change parameters and immediately see the impact on the mechanism's behavior, fostering an interactive design process.
  • Leveraging Existing Tools: The paper highlights the power of building upon established software (Excel) and integrating it with specialized libraries (Ch Mechanism Toolkit) rather than reinventing the wheel.
  • Educational Value: The system is presented as an excellent educational tool, allowing students to understand mechanism analysis algorithms and their implementation without getting bogged down in low-level programming. The ability to examine source code further enhances learning.
  • Flexibility through Open Architecture: The emphasis on an open architecture means the system isn't a closed black box. Researchers and students can adapt and expand it, promoting further development and customization.

Key Results

The paper demonstrates the system's effectiveness through a detailed example of a four-bar linkage analysis.

  • Position Analysis: The system successfully calculates angular positions of links for a given input angle, handling multiple solution branches (circuits) for mechanisms like crank-rockers.
  • Coupler Curve Generation: The system can generate and display coupler curves, providing a visual representation of a specific point's path on the mechanism.
  • Animation: The system provides animation capabilities, allowing users to visualize the entire range of motion of the mechanism for a selected circuit.
  • Ease of Use: The examples showcase how users can input parameters and trigger analyses and animations with minimal effort, primarily by executing ChExcel functions within spreadsheet cells.

Limitations and Future Work

  • Focus on Planar Mechanisms: While the paper mentions the potential for extension, the presented examples and toolkit primarily focus on planar mechanisms. Extending to spatial mechanisms would be a natural next step.
  • Dynamic Analysis: While kinematic and graphical analysis are thoroughly demonstrated, the paper mentions dynamic analysis as a capability of the Ch Mechanism Toolkit, but the detailed examples focus on kinematic aspects. Further exploration of dynamic analysis through the spreadsheet interface could be beneficial.
  • User Interface Refinement: Although Excel is user-friendly, further enhancements to the spreadsheet layout and user guidance could improve the overall experience.
  • Broader Mechanism Types: The paper lists several types of mechanisms supported (four-bar, crank-slider, five-bar, six-bar) and suggests extensibility. Future work could involve developing and showcasing more complex multi-loop mechanisms or specialized linkages.
  • Integration with Other Tools: Exploring integration with other design or simulation tools could further enhance the system's utility.

Summary updated

BibTeX
@inproceedings{cheetancheri2008spreadsheet,
  author = {Kabileshkumar G. Cheetancheri and Harry H. Cheng},
  title = {{Spreadsheet-based interactive design and analysis of mechanisms using Excel and Ch}},
  booktitle = {Advances},
  year = {2008},
  doi = {10.1016/j.advengsoft.2007.08.003},
}
Figure