Design Spreadsheets

 

Lectures (.pdf)	Design Spreadsheets (.xls)
Introduction 1 - Design is a Passionate Process 2 - Creating Ideas
3 - FUNdaMENTAL Principles	Power_to_Move Projectile_motion Table_rotate_dislodge_ball
4 - Linkages	Linkage_4_bar_analysis Linkage_4_bar_locking Linkage_4_bar_piston Linkage_5_bar Linkage_6_bar Linkage_HourglassFlex Linkage_Lazy_Tongs Linkage_taperedbeam Linkage_telescoping_bearing Trigger
5 - Power Transmission Elements I	bandstress Capstan and Band Brake Coupling_Hertz_contact_line coupling_low_cost coupling_low_cost_pin_stress gearmotor_move Joint_interference_fit Pulley_Center_Distance pulley_on_shaft_efficiency shaft frequency table shaft_axial shaft_bending shaft_stability shaft_torsion velocity_profile_study wheel_inertia WheelClimb winchboom winchcable
6 - Power Transmission Elements II	Bevel_Gears Critical_Shaft_Speed motor_leadscrew_size_estimator Planetary Rack_Pinion Screwforce shaft_stability Spur_Gears Spur_Gears_Metric Worm_Gear
7 - Power Systems	transmission ratio matlab.zip Coil_spring electrostatic_force energy benchmark friction_torque gearmotor_move Gearmotor_size_estimator GROpt Manual.ppt Lifting_electromagnet Lifting_permanentmagnet Motor_gearbox_leadscrew motor_power pneumatic_cylinder pneumatic_pressurized_cylinder power_budget_estimate solenoid_force tapered_thickness_leaf_spring tapered_width_leaf_spring Torsion_rod_spring wire_resistivity
8 - Structures	beam_cantilever Beam_curved Beam_curved_spring Beam_Fixed_Fixed Beam_Fixed_Simply_Supported Beam_frequency Beam_simply_supported Beam_Tapered_Thickness Beam_Tapered_Width Bearing_shaft_allowable_misalign circular plate centrally supported Driving_over_step Driving_up_slope Laminate Plate_Circular_Central Plate_Circular_Uniform Plate_Circular_Uniform_central_support Plate_Rectangular Section_Angle Section_Channel Section_I Section_Round_Rectangle Z drawings.vsd
9 - Structural Conn. & Interfaces	2007 Tamiya coupling Hertz_contact_line Bolted_Bracket_Design Bolts_preload Hertz_contact_line Hertz_contact_point FUNdaMENTALs Book pdf/FUNdaMENTALS Design Spreadsheets/Topic 9 Interfaces design Kinematic_Coupling_3Groove_Design_2016.06.03 Tolerance_bow
10 - Bearings	Axis_error_apportionment_estimator Bearing_life_Weibull Bearing_shaft_allowable_misalign Bearing_stiffness_alignment bearings_axledefl Bearings_cartwheel_flexure bearings_D1D2_beam Bearings_linear_carriages Bearings_linear_forces Bearings_linear_spacing bearings_rotary_spacing bearings_rotary_spacing_axle_support Bearings_shaft_allowable_misalign Bearings_simply_supported_shaft Bearings_Sliding_Pitch_PV Bearings_sliding_simply_supported_shaft Error_Budget ErrorGainSpreadsheet 2 axis example extending axes Flexture_4_bar Flextures_hourglass_pivot folded_flexure
Precision Design and Error Budgets	Error_budget_spreadsheet_2016.05.24.xlsx Error budget how to use spreadsheet.pdf Axis_error_apportionment_estimator_2013.03.14.xls Bi_material_beam_2016.10.20.xls Thermerr_gradient_2016.10.20.xls
E - Ethics Supplemental Material