586,366 active members*
3,306 visitors online*
Register for free
Login
IndustryArena Forum > Machine Controllers Software and Solutions > G-Code Programing > Can someone make a excel spreadsheet for OD Chamfers
Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2008
    Posts
    21

    Can someone make a excel spreadsheet for OD Chamfers

    I can do minor programming editing, but really have a hard time with od 45deg. chamfers, sometime we are .100 infront of the part when we put them on and sometimes we are on the face.

    Can someone create an excel file that I can type in my x and z locations and chamfer size and it will give me my x and z's.

    Example

    od of dim. = .500
    size of chamfer = .025
    z location before chamfer .100

    =X

    or something close to this thank you for any help and or advice you may have for me, i also will be using cutter comp.

  2. #2
    Join Date
    Apr 2006
    Posts
    822
    I guess every one has to learn some time or other, but you are kidding aren't you?
    45° tapers are the easiest ones to calculate out.
    The distance you move on Z is the same for X (on radius).
    so... if your diameter is 0.500" and your size of chamfer is 0.025" and you are starting 0.100" away from the face your X point would be 0.100" in front of your Z face and your X value would be calculated from 0.500-(2x0.025)-(2x0.100) = 0.250"
    Do you know how to use Trigonometry at all? as in Sin Cos and Tan?
    Hope you can follow this... once you understand how to calculate the points, machining chamfers other than 45° becomes rather straight forward.
    Regards
    Brian.

  3. #3
    Join Date
    Dec 2004
    Posts
    150
    Quote Originally Posted by broby View Post
    I guess every one has to learn some time or other, but you are kidding aren't you?
    45° tapers are the easiest ones to calculate out.
    The distance you move on Z is the same for X (on radius).
    so... if your diameter is 0.500" and your size of chamfer is 0.025" and you are starting 0.100" away from the face your X point would be 0.100" in front of your Z face and your X value would be calculated from 0.500-(2x0.025)-(2x0.100) = 0.250"
    Do you know how to use Trigonometry at all? as in Sin Cos and Tan?
    Hope you can follow this... once you understand how to calculate the points, machining chamfers other than 45° becomes rather straight forward.
    Regards
    Brian.
    BIG LOL
    I asked my 12 year old kid, and got the answer with no calculator in 3 seconds. Do you want to subcontract for pocket money lol.

  4. #4
    Join Date
    Feb 2006
    Posts
    992
    LOL calculate 45 deg? it's same distant adject side.
    The best way to learn is trial error.

  5. #5
    Join Date
    Jun 2008
    Posts
    1511
    Sorry Swiss20 but you have to expect a bit of ballbusting with that question. I am a firm believer in there are no bad questions but you’re walking the line.

    Roll with the punches my friend. If you stay here long enough you can find a way to poke just about everyone here.

    I guess my question to you would be “what are you having a hard time with on doing OD chamfers?”

    Stevo

Similar Threads

  1. Cutting chamfers and fillets?
    By prestondocks in forum Mastercam
    Replies: 13
    Last Post: 12-22-2015, 04:21 PM
  2. Mastermcam x4 and chamfers
    By musicmaneman1 in forum Mastercam
    Replies: 2
    Last Post: 06-14-2011, 01:22 PM
  3. Replies: 3
    Last Post: 02-18-2010, 02:58 PM
  4. Make setup sheets directly from your CNC programs and print them in Excel
    By ZedB in forum CNC (Mill / Lathe) Control Software (NC)
    Replies: 7
    Last Post: 04-08-2009, 11:21 PM
  5. Metric Change Gear Combinations by J.W. Early Excel Spreadsheet
    By cncadmin in forum DNC Problems and Solutions
    Replies: 0
    Last Post: 05-26-2003, 09:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •