1. #1
    Another excel sheet that might be of use to some one

    I'm starting to look at designing the Z axis for my machine so thought I'd knock up a quick spread sheet. 2 days later.........

    If Its of any use I plan to extend it to all all the axis and possibly make it in to some sort of basic machine design guide.

    Should be fairly easy to use as you just pick from the boxes and enter the required data in the boxes that appear. Ive also save it in two versions so should work in all versions of excel, any probs then let me know:whistling: wait for it.....
    Attached Files Attached Files

  2. #2
    Hi Ross,

    Looking good so far. The basic machine design guide - how much are you hoping to include on this?

    A short list might include:
    The tool deflection in Z due to gantry / gantry rails flex
    Tool deflection in the other axis when cutting
    Maximum jog speed due to ballscrew whip
    Motor power requirements

    I think this is a start because alot of people ask questions along the lines of - will this design be stiff enough? How fast can I go? What motors do I need?

    We and others, have posted spreadsheets with these sorts of things in, so time permitting it would be good to draw it all together. Well done for volunteering! The trouble is that there are so many design options, that it might become a pretty large task!

    It would be great to start with a few schematics of various machines, from which the user picks the closest to what they had in mind. Then key geometry, material, and support conditions are entered. Ultimately after asking enough questions, the spreadsheet would give all the outputs, such as deflection, max speed, etc. to which the user can then compare to their requirements. This loop is then repeated, altering certain parameters, until the requirements are met, or a compromise is made.

    If you can charge 50p a go, it might be quite a money spinner!

    But how far do you go? Include belt drive? What about R&P? etc.

    If I can help, and have the time, I'm here.
    Building a CNC machine to make a better one since 2010 . . .
    MK1 (1st photo), MK2, MK3, MK4

  3. #3
    Thanks Barry,

    A short list might include:
    The tool deflection in Z due to gantry / gantry rails flex
    Tool deflection in the other axis when cutting
    Maximum jog speed due to ballscrew whip
    Motor power requirements
    You are thinking along the exact same line as I am, A few Machine specs on one or two pages that then automatically enter on to the subsiquent calc sheets like your ganrty siffness one (no point in reinventing the wheel). Like you said its how far you go?? I had planned to just evolve it over time.

    If I can help, and have the time, I'm here.
    Perfect I was hoping you would say that, Thanks. Ive just about got my head around excel side on it now with the conditional formating. Its a pain to learn but quite a good program.

  4. We could write a book on the subject :)

  5. #5
    We could write a book on the subject :)
    Now to me that sounds like a bloody good idea,

    but I suspect you are just taking the P***:heehee:

  6. #6
    Go for it guys!!!
    Tim G-C

    I disapprove of what you say, but I will defend to the death your right to say it.

    (attrib. Voltaire but written by Evelyn Beatrice Hall "The Friends of Voltaire" 1906)

  7. Quote Originally Posted by Ross77 View Post
    Now to me that sounds like a bloody good idea,

    but I suspect you are just taking the P***:heehee:
    actually I was being semi-serious



    posted from my HTC

  8. #8
    actually I was being semi-serious
    Well I'm game if you are, would be good if all good info on here (and in your head) was compiled in 1 easy to find place.

Similar Threads

  1. cnc machine stiffness calculator
    By routercnc in forum Linear & Rotary Motion
    Replies: 7
    Last Post: 03-05-2015, 11:55 AM
  2. Simple O-ring calculator.
    By jcb121 in forum General Computing
    Replies: 4
    Last Post: 26-07-2013, 09:00 PM
  3. PCB Track Width Calculator
    By irving2008 in forum General Electronics
    Replies: 0
    Last Post: 10-05-2013, 02:34 PM
  4. Stepper - ballscrew loading
    By Ricardoco in forum Gantry/Router Machines & Building
    Replies: 5
    Last Post: 22-06-2012, 07:46 PM
  5. Resistor Calculator
    By Lee Roberts in forum General Electronics
    Replies: 2
    Last Post: 17-04-2012, 05:22 AM

Bookmarks

Posting Permissions

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