Official Luthiers Forum!

Owned and operated by Lance Kragenbrink
It is currently Tue Nov 26, 2024 12:02 am


All times are UTC - 5 hours





Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Excel Gurus?
PostPosted: Sat Mar 24, 2012 9:07 pm 
Offline
Koa
Koa
User avatar

Joined: Sat Jan 08, 2005 4:19 am
Posts: 1534
Location: United States
First name: Nelson
Last Name: Palen
I would like to try reverse engineering some of my archtop plate profiles in Rhino.
I have the digitized point clouds in Excel which, with necessary header info, is what I use for machining the plates.
These are parallel tool paths with stepover with X running parallel with the centerline of the plate.
The main longitudinal arch would be easy to derive as it is the X coordinates along Y0.
The transverse arches would, however, be a bit tedious to extract and could use some help.
Is there a way to tell Excel to extract all the Y coordinates that form an "arch" at a given X coordinate?
P.S. I assume that Rhino has a curve offset function that would allow for the stylus/ball mill radius? I use the the same radius ball mill that I use for digitizing so they normally cancel each other.
Thanks
Nelson


Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Sun Mar 25, 2012 6:44 am 
Offline
Koa
Koa
User avatar

Joined: Fri Jun 22, 2007 11:14 am
Posts: 1028
Location: Newland, North Carolina
First name: Dave
Last Name: Ball
I wonder if the "pointcloudsection" command might give you what you're looking for. Here's a link to a description of the command and how to use it:

http://www.rhino3d.com/5/help/commands/pointcloudsection.htm

You'd have to import the pointcloud data into Rhino as an .stl file or something like that first, but it might be easier than trying to do it all out of Excel...

Dave


Last edited by ballbanjos on Sun Mar 25, 2012 9:39 am, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Sun Mar 25, 2012 7:52 am 
Offline
Contributing Member
Contributing Member

Joined: Mon Dec 27, 2004 11:25 pm
Posts: 7202
Location: United States
Nelson, if you have all the data points, you can use a pivot table to extract all the data you're looking for.
Don

_________________
"I want to know what kind of pickups Vince Gill uses in his Tele, because if I had those, as good of a player as I am, I'm sure I could make it sound like that.
Only badly."


Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Sun Mar 25, 2012 9:32 am 
Offline
Koa
Koa
User avatar

Joined: Sat Jan 08, 2005 4:19 am
Posts: 1534
Location: United States
First name: Nelson
Last Name: Palen
Dave, that's awesome and works great!
I'm sure some of you other Rhino guys are aware of that also.
Don, can you explain the "pivot table". That sounds interesting.
Thanks, guys.
Nelson


Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Sun Mar 25, 2012 11:47 am 
Offline
Koa
Koa
User avatar

Joined: Sat Jan 08, 2005 4:19 am
Posts: 1534
Location: United States
First name: Nelson
Last Name: Palen
Don, I did a search on "Pivot Table" in Excel and found the info.
Didn't know there was such a thing so will need to investigate further.
Thanks
Nelson


Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Thu Apr 12, 2012 11:14 am 
Offline
Koa
Koa
User avatar

Joined: Tue Nov 28, 2006 1:44 pm
Posts: 1105
Location: Crownsville, MD
First name: Trevor
Last Name: Lewis
City: Crownsville
State: MD
Zip/Postal Code: 21032
Country: USA
Focus: Build
Status: Semi-pro
Hi Nelson,

I think what you really need is to model your parts, based on the point clouds you have digitized(?).

If you haven't seen it already, here's a quick link showing how to compensate for the probe tip diameter:
http://www.emicroscribe.com/uploads/fil ... sation.pdf

If your current point cloud already represents the actual surface of the part, then you can use Analyze>Surface>Point Set Deviation to see a nice color coded plot showing where your surface deviates from the point cloud and by how much.

I hope this helps - the real challenge is doing the surfacing!

Trev

_________________
http://www.PeakeGuitars.com


Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Thu Apr 12, 2012 11:10 pm 
Offline
Koa
Koa
User avatar

Joined: Sat Jan 08, 2005 4:19 am
Posts: 1534
Location: United States
First name: Nelson
Last Name: Palen
Trev,
It sounds like a trial and error process to zero in on the best match of the developed surface to the point cloud.
You do this by tweaking the curves one or two at a time and then checking the resulting surface?


Top
 Profile  
 
 Post subject: Re: Excel Gurus?
PostPosted: Fri Apr 13, 2012 3:51 pm 
Offline
Koa
Koa
User avatar

Joined: Tue Nov 28, 2006 1:44 pm
Posts: 1105
Location: Crownsville, MD
First name: Trevor
Last Name: Lewis
City: Crownsville
State: MD
Zip/Postal Code: 21032
Country: USA
Focus: Build
Status: Semi-pro
Yep, that's the process. You get your framework setup and then begin the process of massaging the framework to get the surfaces to match the point cloud. This is something that is usually a little quicker to do in a parametric modeling app like SolidWorks, versus a tool like Rhino (at least until you get to the point where SW starts bogging down!).

There are two things that you have to keep in mind while doing all this:
1) the part that you digitized was probably not perfect
2) the digitizing process is probably not perfect.

You also have to ask yourself how critical it is that you match this surface exactly on a part that will ultimately be scraped, sanded, etc...!

Trev

_________________
http://www.PeakeGuitars.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group
phpBB customization services by 2by2host.com