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

I'll be a monkey's uncle !

I somehow had 'structure lock' on the Stepper+ worksheet. This basically freezes the page - unable to move, resize, ... !

It is back to normal with this update. You should be able to move about, resize, change tab/worksheet and all that fun stuff.

Not certain why I couldn't find this 'bug' earlier as it is locked/unlocked separately from the rest of protection scheme in Excel ...

This release has many unlocked cells (rows at bottom and columns at right), a note to remind to change the 'Std Measure' (select cells in column I) for the people wanting to use the OXcalculator for builds larger than 1500 x 1500, a theoretical limit of V-slot (for now).

I also integrated and tweaked the stepper calculator of SteelSpinning, most a presentation level thing, as a second page to the OXcalculator (with his prior ok - a while back). There will be some further tweaking in the...

Forgot to unlock K16/17, so just fixed it.

It looks like I forgot to unlock the cells in the tools and such section, among a few others. Although you could change the price and some of the descriptions, you could not specify any quantity. So it is corrected.

There are a few extra lines where you can add items you might want and I did not think of.

The "pick list" feature for aspects with several options is slowly approaching release. I am shooting for allowing you to add options, but not remove the ones I place....

A big thanks to Balu for taking the time to go through the OXcalculator in details and catching various aspects, including, yes, a couple of errors with labelling of items. He also pointed out the availability of 300 mm lengths ACME/lead screw. As the need for a box to put your notes, since I have the spreadsheet "locked" beyond the few open fields (yellow boxes).

You would think I would of caught the fact an 8 mm ACME screw would use a 5mm to 8 mm flexible coupler rather than a 5 x 6 !...

Well, it took me a while to figure it out

Instead of having two separate resources, one for the xlsx version and an other for the ods flavor, along with all of the bagage that comes with that dumb move on my part, I zip'ed both into a single file.

So we are back to a single resource for the OXcalculator. The file is a bit heavier on the wire, but we are not talking huge.

Hopefully everyone has what is needed to unzip the bundle. The file not needed can just be...

This update simply adds the version and build indicator right in the file, as part of the header. This way no one, including myself, can forget version in actual use.

So no changes as far as features. I'm actually working on version 2 : adding menu like feature where several options are possible.

This is the first cut of completed OXCalculator with full breakdown of all parts/items needed to build an rOX from scratch (tools are not listed just allowed for).

A few more tweaks are in the works, heading towards 2.000 which should allow for Pick 'N Build menu of certain items or aspects of configuration... 3.000 will then probably introduce a (nicely) formatted printed shopping list. 4.000 will then probably introduce images (close-ups of assemblies?)

Stay tuned and keep the comments...