SigmaNEST logo for printing

October 2011

SigmaNEST Feature: Automation

Automation Green Light

These days it's not unusual for customers to place small orders with short lead times and expect low prices. Fabricators are now forced to adjust their processes to accommodate customers while remaining competitive. While operators are busy processing orders, the machine cut time to on time ratio is estimated to between 40-65 percent on a non-automated system.

Adding a second machine may be seen as the most logical way to improve efficiencies and produce double the amount of parts, but the cost of the machine isn't the only added expense. For example there are costs associated with a new machine operator, more floor space and a raise in your operating overhead. With a non-automated machine, the bottle neck isn't how fast a new machine can cut parts, it's how fast an operator can load and unload. In fact, with newer machines achieving even better cut times, it becomes even more challenging for an operator to keep up with the work load.

Another approach offering a solution to the problem of efficiency and productivity time would be adding the right type of automation and proper training. Often this approach can increase the aforementioned percentage to between 80 and 90 percent, simply by adding systems such as load/unload.

Maximizing the amount of time the machine can cut parts in relation to the overall time can reduce manual labor and help meet shorter lead times.

To learn more about how your company can use automation to maximize efficiency call 513-674-0005.

Tech Tip: SQL Studio for Database Back-up

Die ManagementHas your computer station ever crashed or your database ever been corrupted? Do you have a back-up database or have you had to recreate and try to manually recover your database? Did you know that you can have an automatic back-up of your database occur every night?

The first step in setting up an automatic database back-up is to obtain Microsoft SQL Server Management Studio Express which is now included on the SigmaNEST Version 9.1 DVD or it can be downloaded from the Microsoft website for free. After installing, follow the steps below:

  1. Create a script using a text editor and store the file in a logical location
  2. FileName:

    SNSQLBackup.sql 

    Text for Back-up Script:

    BACKUP DATABASE databasename
      TO DISK = 'fullpathtobackup.bak'
      WITH FORMAT;
    GO
  3. Open the Task Scheduler and setup a basic Task
  4. Create a name for the task. (Example: SigmaNEST Database Backup)
  5. Select how often to run this task by selecting the Trigger tab (Example: Daily)
  6. Select when to run the task (Example 8:00:00 pm)
  7. Select the action "start a program"
  8. Select the Program Script (Example "C:\Program Files\Microsoft SQLServer\90\Tools\Binn\SQLCMD.EXE" or C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE)
  9. Add arguments: -S LOCALHOST\SQLEXPRESS -i "FullPathToScript.sql" Example -S LOCALHOST\SigmaNEST -i "c:\Databasebackups\SNSQLBackup.sql"

Run the task to test!

 

Subscribe to the e-mail edition of SigmaNEWS