Excel 2D & 3D Robot Arms

This project features an interactive Excel workbook that effectively models 2D and 3D robot arms using fundamental spreadsheet formulas. The workbook serves as a practical tool for visualizing robotic movements and behaviors entirely within Microsoft Excel.

Key Features

• Downloadable Workbook: Access the workbook here.

• User-Friendly Interface: Control the 2D robot arm using three sliders or numerical inputs, allowing for intuitive manipulation of the robot's hand position relative to a target.

• Solver Integration: Utilize Excel's built-in Solver Add-in to automate the process of reaching targets.

Why Choose Excel?

Excel provides clarity and transparency in calculations. Each arm segment is defined in individual rows, with formulas explicitly showing the computation of the next position and orientation. This design avoids the complexities found in coding or graphics engines, thus fostering an understanding of the mechanics involved.

Components of the 2D Spreadsheet

• Model: Each segment of the robot arm is represented through rows utilizing common mathematical operations and functions.
• Control Mechanism: Adjustments can be made directly through control cells or sliders, allowing for real-time interaction.
• Target Positioning: The workbook calculates distances to a target that can be randomly set, facilitating hands-on learning and experimentation.
• Visualization: An x-y plot displays the current state of the robot arm and its relation to the target position.

Advancing to a 3D Robot Model

Transition to the 3D model by navigating to the second tab of the workbook, where a more complex Armatron model is implemented. This includes:

• Extended Model Structure: Each robot segment is now controlled by 3 axes of motion—yaw, pitch, and roll—captured in a 3x3 orientation matrix.
• Enhanced Control: Expanded control cells enable more sophisticated adjustments of the model’s position in three-dimensional space.
• Target Dynamics: The 3D model introduces height as an additional variable for the target position.
• Multi-view Visualization: View plots from three perspectives to gain insights into the model’s operation.

Background and Technical Insights

The project builds upon the concepts of turtle graphics, which involve relative movements and rotations. This approach simplifies the understanding of forward and inverse kinematics, essential concepts in robotics that describe arm movements in relation to a defined target.

It is worth noting that the spreadsheet allows for unique applications in both 2D and 3D turtle-style drawing right within Excel.

Related Work

This project is a culmination of previous explorations in Excel-based graphic simulation:

• Previous articles delve into understanding 3D graphics through Excel, offering practical examples and insights into robotic modeling.

For continued insights and future developments, subscribe to updates from the author on Medium, focusing on themes of scientific programming, machine learning, and statistical analysis.