| General |
| gantt_chart.xls |
Gantt chart for use in scheduling design development. |
| coupling_low_cost.xls |
Designs a shaft coupling for cheaply connecting the motor to the output shaft without requiring precisely positioned shafts. |
| Kinematic_Coupling_3Groove_Design.xls |
Error motions and hertz stresses for kinematic couplings. |
| Bolts_preload.xls |
Determines to preload in a bolted joint. |
| Error_Budget.xls |
Calculate the combined errors for a structural loop. |
| Hertz_contact_line.xls |
Hertzian contact calculations for line contacts. |
| Hertz_contact_point.xls |
Hertzian contact calculations for point contacts. |
| Plate_Circular_Central.xls |
Determines the deflection of a centrally loaded circular plate. |
| Plate_Circular_Uniform.xls |
Determine the deflection of a round plate. |
| Plate_Rectangular.xls |
Determine the deflection of a simply supported rectangular plate. |
| Projectile_motion.xls |
Predicts projectile motion based on simple physics. |
| Section_Angle.xls |
Section properties of an angle bracket. |
| Section_Channel.xls |
Section properties of a channel. |
| Section_I.xls |
Section properties of an I-beam. |
| Section_Round_Rectangle.xls |
Section properties of a round or rectangular cross section. |
| velocity_profile_study.xls |
Illustrates the difference between different velocity profiles. |
| wire_resistivity.xls |
Estimates the resistance in a length of wire. |
| Actuator Related |
| driving_over_step.xls |
Determines the ability of a wheeled vehicle to climb obstacles. |
| driving_up_slope.xls |
Determines the ability of a wheeled vehicle to drive up a slope. |
| electrostatic_force.xls |
Calculate the amount of electrostatic force available from a simple system. |
| gearmotor_move.xls |
Estimates inertia of a geared motor and find the system's optimal transmission ratio. |
| Gearmotor_size_estimator.xls |
Estimate the physical size of a motor given a desired torque. |
| Lifting_electromagnet.xls |
Determines the required properties of an electromagnet to lift a load. |
| Lifting_permanentmagnet.xls |
Determines the required properties of an permanent magnet to lift a load. |
| motor_leadscrew_size_estimator.xls |
Estimate the size of a motor to drive a lead screw. |
| motor_power.xls |
Determine motor power as a function of speed and torque. |
| power_budget_estimate.xls |
Assist in budgeting power and energy in a system. |
| pneumatic_cylinder.xls |
Calculate forces and energy in a pneumatic cylinder (piston). |
| pneumatic_pressurized_cylinder.xls |
Determine energy storage in a pressurized cylinder. |
| solenoid_force.xls |
Estimates pulling force of a solenoid. |
| winchboom.xls |
Calculate torques and speeds for different winch geometries. |
| winchcable.xls |
Calculate cable forces for a winch. |
| Manufacturing Tools |
| Joint_press_fit.xls |
Clearance and pressure in press fit bodies. |
| Laminate.xls |
Spreadsheet to help design laminate structures. |
| Tolerance_bow.xls |
Determines the non-flatness of a bowed surface. |
| Linkage Design |
| Linkage_4_bar_analysis.xls |
Plots the motion of a four bar linkage. |
| Linkage_4_bar_locking.xls |
Designs a four bar linkage that will lock in position. |
| Linkage_4_bar_piston.xls |
Designs a four bar linkage using a piston as an actuator. |
| Linkage_5_bar.xls |
Designs a five bar bolt-cutter style linkage. |
| Linkage_6_bar.xls |
Design a six bar, piston actuated linkage. |
| Linkage_Lazy_Tongs.xls |
How to design the infamous Lazy Tongs Linkage! |
| Springs, Beams, and Flexures |
| beam_cantilever.xls |
Beam calculations for the fixed-free boundary condition. |
| Beam_curved.xls |
Beam calculations for fixed-free boundary conditions with the geometry initially curved. |
| Beam_curved_spring.xls |
Calculations for a curved spring. |
| Beam_Fixed_Simply_Supported.xls |
Beam calculations for a fixed - simply supported beam. |
| Beam_simply_supported.xls |
Beam calculations for a simply supported beam. |
| Beam_Tapered_Thickness.xls or tapered_thickness_leaf_spring.xls |
Determines stress, deflection, and spring constant of a tapered-thickness constant-width beam. |
| Beam_Tapered_Width.xls or tapered_width_leaf_spring.xls |
Determines stress, deflection, and spring constant of a constant-thickness tapered-width beam. |
| Flexture_4_bar.xls |
Designs 4-bar parallelogram flexures (more than 2 blades can be used). |
| Flextures_hourglass_pivot.xls |
Design hourglass shaped flexures. |
| linkage_HourglassFlex.xls |
Design hourglass shaped flexures. |
| Linkage_taperedbeam.xls |
Determines stress, deflection, and spring constant of a constant or variable thickness and width beam. |
| torsion_rod_spring.xls |
Calculations to use a rod as a torsion spring. |
| Bearings |
| Bearing_linear_stiffness_alignment.xls |
To estimate bearing stiffness and loads caused by misalignment. |
| Bearing_shaft_allowable_misalign.xls |
To determine bearing clearance when shaft is angled. |
| Bearings_linear_forces.xls |
To determine forces on each of 4 learn bearing carriages. |
| Bearings_linear_spacing.xls |
To study effect of bearing spacing. |
| bearings_rotary_spacing.xls |
To design shaft supported by bearings. |
| bearings_rotary_spacing_axle_support.xls |
To determine bearing clearance changes caused by load. Example: two sprockets or pulleys on either end of a shaft (wheels would not be mounted to a solid axle) |
| Bearings_simply_supported_shaft.xls |
To determine deflection of a bearing supported beam. |
| Bearings_Sliding_Pitch_PV.xls |
To determine bearing contact pressure in a slider loaded by a moment. |
| linkage_telescoping_bearing.xls |
To study forces on bearings as a function of spacing. |
| Sliding_Contact_Rotary.xls |
To aid in the design of sliding contact rotary bearings. |
| Shaft Design |
| shaft_torsion.xls |
Helps in the design of shafts that are to undergo torsion. |
| shaft_bending.xls |
Helps in the design of shafts that are to undergo bending. |
| shaft_axial.xls |
Helps in the design of shafts that are to undergo axial loads. |
| shaft_stability.xls |
Helps in the design of shafts for critical stability speed. |
| friction_torque.xls |
Friction torque on a radial shaft. |
| Critical_Shaft_Speed.xls |
Calculates the critical shaft speed for a variety of support conditions. |
| Transmissions |
| bandstress.xls |
Stress in a flat belt wrapped around a pulley. |
| Capstan.xls |
Designs a capstan-based brake. |
| differential_screw.xls |
Determines the effective lead of differential screws. |
| leadscrew_design.xls |
Design of a leadscrew system. |
| Planetary.xls |
Compares planetary gear trains. |
| Pulley_Center_Distance.xls |
Calculates the center distance between two pulleys. |
| pulley_on_shaft_efficiency.xls |
Determines the efficiency for sliding contact bearing supported pulley. |
| Screwforce.xls |
Determine lifting force from a screw. |
| Spur_Gears.xls |
Spreadsheet to estimate gear tooth strength for a spur gear (FEA or more detailed analysis required to do a complete design). |
| Bevel_Gears.xls |
Spreadsheet to estimate bevel gear tooth strength (FEA or more detailed analysis required to do a complete design). |
| Worm_Gear.xls |
To estimate gear tooth strength for a worm gear (FEA or more detailed analysis required to do a complete design). |
| Rack_Pinion.xls |
To estimate rack and pinion gear tooth strength (FEA or more detailed analysis required to do a complete design). |