|
In order to determine an appropriate gear ratio to successfully
climb the ramp, we wrote an excel spreadsheet that allowed us to
input geometry, mass position, motor specifications, ramp slope, and
other important variables. It output for us the percentage of the
maximum power used, whether the wheels would slip or if the cart
would tip over, and the amount of time it takes for the transporter
to reach the top of the ramp.
Some screen shots of the spreadsheet (Click to enlarge):
We used the program throughout the design process to help us check
to see whether our design would work successfully. After we
finished building, we input the final geometry values and then
tried to optimize the percentage of the maximum motor power used
and climb time by adjusting the gear ratio. Our design of a gear
box connected to two outer gears allowed 18 different gear ratios.
According to the program, only 3 of these would provide enough
torque to carry the transporter up the ramp. We graphed these
three combinations to visualize the optimal solution.
Graph of the maximum motor power used and time for the transporter
to climb the ramp versus the three gear ratio possibilites (Click
to enlarge):
The obvious optimal solution was a gear ratio of 162.8. It was the
most efficient use of the power provided by the motor and it made
the transporter climb the ramp in the least amount of time. We
used this as our gear ratio in one of our earlier models, but it
just did not provide enough torque to climb the ramp. Our final
version uses a gear ratio of 366.2, which was the least optimal of
all the solutions, but turned out to be the only one that worked.
Our program either simplified the problem to an extent of being of
inaccurate, or our transporter was much more inefficient than we
expected it be.

|