Phân tích động học cơ cấu tay quay con trượt bằng phần mềm Excel

NGHIEN CUfU - TRAO BOI

PHAN TICH DONG HOC CO CAU TAY QUAY CON TRU'OT

BANG PHAN MEM EXCEL

KINEMATIC ANALYSIS OF A SLIDER-CRANK MECHANISM

BY USING MICROSOFT OFFICE EXCEL

Hoang \if Ph^m Minh Tudn

TrUdng Dai hpc Ky thuat Cdng nghiep, Dai hpc Thai Nguyen.

TOMTAT

Bdi bdo gidi thiiu ve dng dung phdn mim Excel diphdn tich ddng hgc vd ddng lUc hgc eg cdu tay

quay con trUOt Trong hdi bdo ndy, cdc bdi todn ddng hgc nhU xdc dinh chuyin vi, xdc dinh van tdc, gia

tic c^a cdc diim trin cd cdu dd dUdc gidi quyit mdt cdch nhanh chong vd tien ldi nhd phdn mem dd niu.

Tdt cd cdc bdi todn niu trin dd dUdc tinh todn tU dgng. Kit qud ciia cdc bdi todn ndy cho dUdi dgng bdng

vd d6 thi nin rdt thudn tiin cho ngUdi diing.

ABSTRAST

This paper presents a rearch on using Microsoft Office Excel for kinematic analysis of a slider -crank

mechanism. In this paper, kinematic problems as the displacement ofthe slider, the velocity and the accel￾eration ofthe conecting rod were solved by using the sofware. AU above problems are solved automatic.

The results of the problems are very easy to use because all they are in table and graph forms.

I.GIOITHI$U

Cd cdu tay quay con trUpt Id cP cdu ddng

dl biln chuyen dpng quay thdnh chuyin dpng

tinh tiln. Co cdu ndy dUpc dung rat phd biln

trong cdng nghi|p nhU trong mdy bdo, trong

cdc ddng cd ddt trong ... Chinh vi v^y, vi|c gidi

cdc bdi todn dpng hpc (bao gdm cac bdi toan

chuyin vj, v$n tdc vd gia tdc cda cdc diem tren

cd cdu) dd vd dang dUpc quan tdm nhilu.

Phdn tich ddng hpc cG cau phang todn

khdp thdp ndi chung hay cd cau tay quay con

trUpt ndi riing thpc chdt Id gidi bdi todn chuyin

vj, v^n tdc, gia tdc khi bilt cdc thdng sd kich

thudc cda cdc khdu, v\ tri, v^n tdc khdu ddn. Dl

giai bai toan dpng hpc cd thi dung hai phUdng

phdp la phUdng phap hpa dd vd phUdng phdp

gidi tich. PhUdng phdp hpa do la phUdng phap

trong dd sd dyng cdc phep di^ng hinh dl xac

dinh cac gid tri chuyin vi, v|n tdc va gia tdc

cua bai todn ddng hpc. Ddy la phUdng phap

rat quen thudc ddi vdi sinh viin cac ngdnh cd

khi. Tuy nhiln, phUdng phap nay cho dp chinh

xac khdng cao vd radt nhilu thdi gian de gidi.

PhUdng phap gidi tich (dUpc trinh bay kha ky

trong [1]) cd nhieu Uu diera hdn bin phUdng

phdp hpa do nhu cho dp chinh xdc cao, de dang

ldp trinh bang rady tinh vd tU ddng hda tfnh

todn. Nhd cac Uu dilm nay ma phUdng phdp

nay dd va dang dUpc sd dung rdt rdng rdi de

phdn tich dpng hpc cP cdu. '^

T^P CHf CO KHf VI£T NAM • S6 6 (Thdng 6 ndm 2013)