New Version of Excel Stock Cut Optimizer 1DCutX Got Minimization of Cutting Layouts and VBA Automation

The new release of the linear material-cutting optimization add-in (1DCutX) for Excel from Optimalon Software got two major improvements. Users can now minimize the number of different cutting layouts generated by 1DCutX and perform the material cutting calculation in a highly customised way using VBA language in Microsoft Excel.

Denis Smirnov, from Optimalon explains: "When 1DCutX calculates how to cut linear stocks with minimal material waste, it generates a list of cutting layouts. Several stocks can be cut simultaneously instead of one by one. The fewer layouts produced during the calculation, the less time cutting operators spend loading stocks".

The new version of 1DCutX introduces the option " Minimize count of different layouts" that forces the optimization algorithm to produce as few layouts as possible. However, this option could reduce the total utilization rate because it could use more stocks than the regular calculation.

Automation has always been at the top of the list of client requests for 1DCutX, and this new version brings it to life.
Denis Smirnov continues: "Support of VBA automation provides a new way to perform optimization in 1DCutX. Instead of using standard dialog box invoked from the menu, users now can call the " Execute" method from VBA code and get the same results as before".

Users just need to create an instance of the linear cutting class, assign settings and specify the ranges of cells containing the stocks and parts information. The method "Execute" returns a text value that is empty if the calculation is done successfully; otherwise it returns an error message.

Automation allows users to tune-up the generated reports by including/excluding the graphical layouts, the part/stock matrix or the cutting instruction spreadsheets. The new version of 1DCutX comes with an automation guide that describes in detail how to create, set up and run the calculation using VBA. In addition, the installation provides a new example spreadsheet with simple VBA code that demonstrates automation in action.

With the initial investments of $97 users of 1DCutX reported monthly savings in materials alone range from $200 to $1500, which means the software pays for itself in less than a month.

Free trial version of 1DCutX is available on Optimalon's website: http://www.optimalon.com/length_cutting_excel.htm



Read the complete story ...


Review Article Be the first to review this article
HP

SolidCAM: Program your CNCs directly inside your existing CAD system.

Featured Video
Jobs
CAD Systems Administrator for KLA-Tencor at Milpitas, CA
Principal Research Mechatronics Engineer for Verb Surgical at Mountain View, CA
Senior Mechanical Engineer for Verb Surgical at Mountain View, CA
Industrial Designer Intern – Spring 2017 for Nvidia at Santa Clara, CA
Lead Geospatial Analyst for Alion at McLean, VA
Upcoming Events
SOLIDWORKS 2017 Launch Event – Walsall at Village Hotel Club, Walsall, WS2 8TJ Walsall United Kingdom - Mar 30, 2017
PI APPAREL Hong Kong 2017 at SHANGRI-LA KOWLOON 64 Mody Road Tsim Sha Tsui East Kowloon Hong Kong - Apr 5 - 6, 2017
SOLIDWORKS intro and hands on session – Slough at Baylis House, Slough, Berkshire, SL1 3PB Slough United Kingdom - Apr 7, 2017
Engineer 3D! Training + Technology Conference at Hyatt Regency Milwaukee 333 West Kilbourn Avenue Milwaukee WI - Apr 25 - 26, 2017
MasterCAM



Internet Business Systems © 2017 Internet Business Systems, Inc.
595 Millich Dr., Suite 216, Campbell, CA 95008
+1 (408)-337-6870 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation GISCafe - Geographical Information Services TechJobsCafe - Technical Jobs and Resumes ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy Policy Advertise