Welcome to Our Community

Unlock hidden features. Sign Up for Free Today!

OXcalculator - Bill of Material and Cost calculator v1b006 (xls + ods)

OXcalculator - Your computer figures out the parts you need to build your OX by giving it X, Y & Z

  1. Serge E.
    I was making my BoM, way after having started myOX, and figured I could go the extra mile (or is it just a kilometre ?) by making this calculator so all can get a fairly good estimate of parts and cost for their OX build.

    Since it simply can't (for now at least) take into account all of the possible mutations of an OX, I had to settle on a reference OX : rOX. It is very close to most OXen (?) found around here as most stay within certain bounds, at least for their first OX. Even myOX is taken into account with the calculator (obviously).

    The key difference of rOX and other typical OXen is how the working surface is attached. I came up with a simple mounting scheme. The board can either be beneath the rOX or on top. It is held in place with simple flat plates : one screw into the board and a couple with T-nuts into the outside of the base X. There is no blind aligning of T-nuts.

    You, of course, are free to make your own mutation of the original OX, or the calculator's very similar rOX.

    To use, you can start by giving only three basic numbers !

    Specify the target X, Y and Z dimensions of the OX you want to build. All of the other parameters are optional, the defaults being ... average OX things.

    Adjust the respective offset (varies with router, mounting bracket and typical tool length) for a proper estimate of the working area dimensions. The "Max Z travel" is typically fixed (mostly depends on height of the Y gantry plates) : it is the distance between the tool tip and the table surface when the Z axis is in its fully raised position. Standard OX configurations have Y gantry plates which leaves only about 120 mm of travel regardless of your Z axis length ... Where the myOX variation, with a bottomless (maybe topless, sounds sexier eh ?) work table, can maximize the use of your Z configuration by dropping way BELOW the table surface ! Of course, the precision will depend on the rigidity of your Z and the tool used.

    That's it !

    the OXCalculator now breaks down most of the sub assemblies so it tells you how many of each items your configuration needs AND how many packs for each needs to be ordered. Of course, you can specify the pack size along with the cost and get a fairly good shopping list (I hope).

    There will be a few more tweaks and organizing of the various items within the version 1 builds of the OXCalculator. This includes detailing the Tools. These updates should follow over the next little while.

    Then, with release 2.000, I'll introduce a Pick "n Build feature: certain sub-assemblies will be or have "menu" type choices for you to start customizing your OX build.

    Version 3.000 should introduce a clean print out of the shopping list.

    Version 4.000 should then introduce images : the exploded views of sub-assemblies would be great !

    Version 5.000 could become a build guide, complete with videos !

    Have I missed anything so far ?

    Maybe you can give each build a try, even if you already have your OX. Let me know how well (or bad) it does compared to your manually made BoM, costing, etc.

Recent Reviews

  1. D Stevens
    D Stevens
    5/5,
    Version: v1b006 (xls + ods)
    Outstanding, well done!
  2. timonjkl
    timonjkl
    4/5,
    Version: v1b006 (xls + ods)
    love everything about this very informative
  3. Kevin Perkins
    Kevin Perkins
    5/5,
    Version: v1b006 (xls + ods)
    This is very well done, I'm completely new to this so I'm looking forward to version 5 000 of the resource Calculator
  4. Mark Carew
    Mark Carew
    5/5,
    Version: v1b006 (xls + ods)
    This has been such a great resource for so many Builders wanting to build their OX machines, thank you for making this!
  5. Marc-Olivier Blanc
    Marc-Olivier Blanc
    5/5,
    Version: v1b006 (xls + ods)
    Excellent file. neatly done and definitely uefull.

    One imporvment suggestion though, on the cells that are not locked, provide the possibility to add hyperlinks as well. as it is I put Hyperlinks in the cell but have to copy paste in my browser. That would help. Also, if hyperlinks are possible, then you can give a shorter description other than the link itself and we all know those can be quite verbose !! :)

    thanks again.
    1. Serge E.
      Author's Response
      Merci.

      I'll look at the restrictions ... as you say, unlocked cells should let one use links for a quick click on a shorter text representation of the actual potentially long link.
  6. SteveJ
    SteveJ
    1/5,
    Version: v1b005 (xls + ods)
    Not usefull for anything as it is.
  7. rn2it
    rn2it
    5/5,
    Version: v1b004 (xlx+ods)
    Thanks for the great spread sheet.
  8. Tom Long II
    Tom Long II
    5/5,
    Version: v1b004 (xlx+ods)
    Thanks! I'm just looking into building my first CNC & this tool is a big time saver, excellent job.
  9. Tiger74
    Tiger74
    5/5,
    Version: v1b004 (xlx+ods)
    Huge Help ! Thanks. Looking forward to the other versions.
  10. Jim Fancher
    Jim Fancher
    5/5,
    Version: v1b004 (xlx+ods)
    This is a big help for a newb like me.
  • About Us

    The OpenBuilds Team is dedicated helping you to Dream it - Build it - Share it! Collaborate on our forums and be sure to visit the Part Store for all your Building needs!
  • Like us on Facebook

  • Support Open Source FairShare Program!

    OpenBuilds FairShare Give Back Program provide resources to Open Source projects, developers and schools around the world. Invest in your future by helping others develop theirs!

    Donate to FairShare!