ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
AMB Design Spreadsheet
3
Version 4.6
4
Made by Ari Meles-Braverman: Mentor, FRC 5987
5
Click "ADD" to insert an instance of that calculator to the spreadsheet
6
Key
7
X = Input Value
8
X = Calculated Value
9
X = Warning
10
X = Invalid Input
11
12
Mechanism Gear Ratio Calculator:
13
This sheet calculates the characteristics of a given mechanism, when the user defines one characteristic (e.g. gear ratio, loaded linear velocity, stall load, current per motor, etc). Use this sheet to determine the gear ratio and number and type of motors needed to give a mechanism certain characteristics.
14
15
Lead Screw Calculator:
16
This sheet calculates the relationship between the angular input and linear output of a lead screw. With a given lead screw, it can calculate whether or not it is backdrive-able, the linear force output given by a certain angular torque input, and the relationship between angluar and linear velocity. It also calculates an equivalent radius and load to use in the Mechanism Gear Ratio Calculator for a system with a lead screw as the final reduction stage.
17
18
Drivetrain Calculator:
19
This sheet calculates the final speed and current draw of a given drivetrain setup. Use this sheet to determine the necessary drivetrain setup that meets the characteristics that are desired. Also calculates the C-C distance for gear reductions. Suitable for 1-speed, 2-speed, different-radius wheels, and articulating drives.
20
21
Beam Bend Calculator:
22
This sheet calculates the deflection in a beam or axle under a given load. There are different formulas depending on whether the load is between two supports or cantileivered. It also calculated the maximum force that can be applied to a beam before it buckles, and the twist angle of an axle under torsion.
23
24
Projectile Trajectory Calculator
25
This sheet uses parabolic trajectory equations to help determine the path a shot object will follow. There are two calculation options. The Forward option allows you to select an initial velocity and angle, and tells you the target height and angle a certain distance away from the launch point. The Reverse option calculates the required launch velocity and angle for a projectile to land a certain height at a certain distance away, with a certain landing angle. Use this sheet to get baseline values for designing flywheels, catapults, or other types of shooting mechanisms.
26
27
Chain/Belt C-C Calculator:
28
This sheet calculates the closest exact C-C distance for given sprocket/pulley sizes and chain pitch. Use this sheet to find the correct C-C distance for using chain/belt without a tensioner. Choose rounding type and modulus number to force rounding up or down or rounding to a multiple of given number. This sheet also calculates the C-C distance for a given belt length and sprocket size, to find the proper spacing for COTS belts.
29
30
Gear Clearance Calculator:
31
This sheet calculates whether or not two sets of parallel gears will hit each other, and if not, how much clearance they will have. It also calculates whether or not the first gear will clear the second shaft with no gear on it.
32
33
Ratio & Distance Calculator:
34
This sheet calculates the gear pair that have a given reduction and C-C distance, and then calculates the pitch and clearance diameter for both gears.
35
36
Pneumatics Calculator:
37
This sheet calculates the total volume of air used throughout the match from all of the cylinders on the robot, as well as the total volume of air stored in tanks on the robot and the total volume compressed by the compressor during the match. It uses that data to determine whether or not the robot will run out of air before the match ends, and how long it will take to refill the tanks between matches. It also calculates the extension and retraction (pull and push) force for each piston.
38
39
Pneumatic Linkage Calculator:
40
This sheet calculates the angle of a linkage controlled by a certain pneumatic cylinder with its mount at a certain position relative to the mount of the linkage. It also does the reverse calculation, computing the relative position of the cylinder mount needed to give the given linkage the desired extended and retracted angles.
41
42
VersaPlanetary Configuration Calculator
43
This sheet helps visualize the data from the VersaPlanetary Load Ratings Guide, as well as showing the part numbers needed to order for that configuration, the price of the configuration, and the output speed and torque.
44
45
46
Sources:
47
JVN's Mechanical Design Calculator
48
Ether's Simple Motor Calculator
49
Clem1640's Chain/Belt Calculator
50
NickBrickMaster's Pneumatic System Simulator
51
Shigley's Mechanical Engineering Design
52
Andrew Schreiber's VersaPlanetary Configuration Tool
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100