import X,Y data table from Excel

Use this forum to ask questions about how to do things in QCAD version 3

Moderator: andrew

import X,Y data table from Excel

Postby J-J » Tue Feb 05, 2013 7:37 am

Good morning,
I tried the import point function but nothing happens when I select the xls file in the dialog box.
I wanted to import a gear tooth profile calculated in excel.
Thanks for any hint. (win7-64)
User avatar
J-J
Moderator
 
Posts: 173
Joined: Tue Mar 24, 2009 9:48 pm

Re: import X,Y data table from Excel

Postby Husky » Tue Feb 05, 2013 9:28 am

Hi J-J,
J-J wrote:Thanks for any hint. (win7-64)

You are more looking to figure out how the excel import works or do you just in need of a gear in QCAD?
I can't help you with the Excel file but if you just need a dxf gear what you can use in QCad - I have a simple gear program for a task like that .... 8)
User avatar
Husky
Moderator
 
Posts: 642
Joined: Wed May 11, 2011 9:25 am
Location: USA

Re: import X,Y data table from Excel

Postby J-J » Tue Feb 05, 2013 7:39 pm

Hi Husky,
Ok, I'm always willing to learn other techniques, I'll be happy to try your program. I guess one can do many smart things with QCAD scripting, but I have no experience with it.
Thanks
User avatar
J-J
Moderator
 
Posts: 173
Joined: Tue Mar 24, 2009 9:48 pm

Re: import X,Y data table from Excel

Postby Husky » Tue Feb 05, 2013 9:25 pm

Hi,
Just to be clear - I'm not trying to sell a program (it is not mine - just a program what I use) but I'm offering to design the gear for you with this program and send you the dxf :wink:

You are looking for something like this?
J-J gear.dxf
(97.69 KiB) Downloaded 180 times


PM is OK!
User avatar
Husky
Moderator
 
Posts: 642
Joined: Wed May 11, 2011 9:25 am
Location: USA

Re: import X,Y data table from Excel

Postby J-J » Tue Feb 05, 2013 11:00 pm

Hi,
In fact, I need to cut 3 wheels that will match the worm screw on my lathe. The way I figured it initially was to calculate the involute curve by small increments and then feed the x,y points in QCAD. So it is not a standard situation in which you'd have a given ratio and center distance...The pitch of the screw is 3mm and the 3 wheels are 28, 30 and 32 tooth gears.
here's my attempt:
pignons Z28-30-32-&assy.dxf
(198.29 KiB) Downloaded 161 times
User avatar
J-J
Moderator
 
Posts: 173
Joined: Tue Mar 24, 2009 9:48 pm

Re: import X,Y data table from Excel

Postby Husky » Wed Feb 06, 2013 9:57 am

First try - close enough? :wink:

Tooth spacing (Center tooth along Pitch diameter): 3 mm
Contact angle (pressure angle): 20°
Addendum: 0.250 mm
Slop: 0

Check it out and give me a hint what has to be changed.
pignons Z28-30-32-&assy.dxf
(341.04 KiB) Downloaded 168 times
User avatar
Husky
Moderator
 
Posts: 642
Joined: Wed May 11, 2011 9:25 am
Location: USA

Re: import X,Y data table from Excel

Postby J-J » Wed Feb 06, 2013 11:14 pm

Hi Husky,
Thanks for your efforts. Quite close indeed. Major difference is mostly on tooth height and depth, probably because I used different formulas for OD and foot diameter. The profile you propose is certainly stronger, but no power is transmitted in this case...
User avatar
J-J
Moderator
 
Posts: 173
Joined: Tue Mar 24, 2009 9:48 pm

Re: import X,Y data table from Excel

Postby Husky » Thu Feb 07, 2013 10:14 am

Hi J-J,

Ok, last try :lol:
pignons Z28-30-32-&assy-new.dxf
(792.16 KiB) Downloaded 161 times
User avatar
Husky
Moderator
 
Posts: 642
Joined: Wed May 11, 2011 9:25 am
Location: USA

Re: import X,Y data table from Excel

Postby J-J » Thu Feb 07, 2013 8:06 pm

Hi Husky,
This looks perfect to me, thank you very much for your time.
User avatar
J-J
Moderator
 
Posts: 173
Joined: Tue Mar 24, 2009 9:48 pm

Re: import X,Y data table from Excel

Postby Husky » Thu Feb 07, 2013 8:16 pm

You are welcome! :wink:
User avatar
Husky
Moderator
 
Posts: 642
Joined: Wed May 11, 2011 9:25 am
Location: USA


Return to QCAD 3 'How Do I' Questions

Who is online

Users browsing this forum: No registered users and 11 guests