LumberJocks

How to EXCEL your Segmented Lathe Project Dimensions

  • Advertise with us

« back to Woodworking Skill Share forum

Forum topic by poopiekat posted 04-07-2011 03:47 PM 2028 views 2 times favorited 4 replies Add to Favorites Watch
View poopiekat's profile

poopiekat

4225 posts in 3197 days


04-07-2011 03:47 PM

Topic tags/keywords: resource segmented lathe excel spreadsheet

How many of us scramble for a calculator when cutting those bits and pieces for segmented lathe projects? I made this simple spreadsheet thing so that I can accurately determine the length of each component. All you gotta do is refer to the planned diameter, then look under the appropriate ‘Number of Segments’ to determine the length of each piece. By length, I’m referring to the outside length dimension of your mitered segments as shown by the calipers below.

Photobucket

Photobucket

Easy!

-- Einstein: "The intuitive mind is a sacred gift, and the rational mind is a faithful servant. We have created a society that honors the servant and has forgotten the gift." I'm Poopiekat!!


4 replies so far

View poopiekat's profile

poopiekat

4225 posts in 3197 days


#1 posted 04-07-2011 03:59 PM

You can expand on this to include other diameters and segments too. I prefer to stick with segment counts divisible by ‘2’ because I like to touch up the kiss cuts on my edge sander. As here: http://lumberjocks.com/topics/25334 Though a project with 5, 7, or 9 segments would be interesting too!

-- Einstein: "The intuitive mind is a sacred gift, and the rational mind is a faithful servant. We have created a society that honors the servant and has forgotten the gift." I'm Poopiekat!!

View lew's profile

lew

11339 posts in 3218 days


#2 posted 04-07-2011 06:20 PM

Thanks!!

Lew

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View poopiekat's profile

poopiekat

4225 posts in 3197 days


#3 posted 04-07-2011 07:25 PM

I should add, that if you want to make your own Excel spreadsheet, the formula I used is: =A3*3.141/$B$3 and so on. Real easy, but I have this chart pinned to the wall now, so I’ll never really have to stop and calculate the measurements any more. Perhaps I should have included an angle calculator, for the respective segments per ring, but so far I am still capable of doing this in my head. However, it would be 360/number of segments. Then you split that number in two if you want each mating face to bisect the angle equally. In the sample segment pictured above, it was cut for a ring of 12 segments, so it needs a 30-degree angle. Each side was cut at 15 degrees, and so at 24 joints, 24 X 15 = 360.

-- Einstein: "The intuitive mind is a sacred gift, and the rational mind is a faithful servant. We have created a society that honors the servant and has forgotten the gift." I'm Poopiekat!!

View poopiekat's profile

poopiekat

4225 posts in 3197 days


#4 posted 01-09-2013 11:49 PM

The ‘length’ refers to the outside length of your mitered cuts.
I’m now cutting some handles for socket chisels… stay tuned!

-- Einstein: "The intuitive mind is a sacred gift, and the rational mind is a faithful servant. We have created a society that honors the servant and has forgotten the gift." I'm Poopiekat!!

Have your say...

You must be signed in to reply.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com