Browse by Editorial Category
Browse by Edition Date

March 2017

Skip Navigation Links.
Expand Additive ManufacturingAdditive Manufacturing
Expand Applying TechnologyApplying Technology
Expand Education-TrainingEducation-Training
Collapse General EditorialsGeneral Editorials
Tongtai and You Ji Machines Win 2017 Taiwan Excellence Awards
Automate 2017 Conference and Expo Comes to Chicago April 3-6
Boston Centerless Receives Nadcap Accreditation
Camfil APC Expands Laboratory for New ANSI/ASHRAE Dust Collection Standard Testing
CIMTEC Automation Selected as Universal Robots Distribution Partner for Southeast
CNH Industrial Honored as Green Master for Third Year in a Row
C.R. Onsrud Expanding Manufacturing Facility
Dallas Industries Delivers Two Complete Feed Lines to Adient
Emuge Introduces Tool Reconditioning in U.S. Facility
New Gosiger West Headquarters Provides Expanded Services
Greenville Technical College's CMI and Director Play Leading Role in Robotics Collaborative
500 DegreeF Vertical Airflow Cabinet Oven
Trident Expands into Gulf Coast States of Louisiana and Mississippi
Geoteck Machine Tool Solutions Named Hyundai WIA's Exclusive Dealer for Michigan
Matrix Coatings Corp. Now Licensed Industrial Applicator of Teflon
Renfroe Grows Manufacturing Capabilities
Web-Based Access to Assemblies and Documents
Okuma America Corporation Names Koma Precision Partner of the Year
Mazak Optonics Expands Partnership with Modern Machinery Company
Mazak to Host Special San Francisco Event for Silicon Valley Shops
Methods Machine Tools to Exhibit at Automate 2017
The MFG Meeting 2017 to be Held March 22-25
Machine Vision Software for Smart Cameras
Investments in Fiber Laser Technology Boost Productivity
Combined Grand Opening/Open House at Morris Florida and HFO/Florida
Morris Madness Event March 14-15
Morris South Open House and Technology Show April 4-5
Team Penske and Nikon Metrology Announce Technical Alliance
O'Neal Industries Forms Integrated High Performance Metals Company
Quality Show Registration Now Open
Renishaw Moves into New Facility
Expanded Website Features "Easy Access" Program
Robinson Metal Enhances Laser Cutting Capabilities
ROHM to Showcase Gripping Technologies at Automate 2017
A.J. Sackett and Sons and Waconia Manufacturing Join Forces
Top Five Reasons Spreadsheets Are Dead Weight
Sigma Labs Wins Phase III DARPA Contract with Honeywell
SLM Solutions Breaks Ground on Global Production Facility, Expands North American Office
SmartCAMcnc Announces Licensing Agreement for ModuleWorks Cut Simulation Technology
Shop Floor Interface for Multi-DNC Software and Operator Feedback
High Precision Jig Grinding Machines
U.S. Department of Labor Issues Final Rule to Lower Beryllium Levels
Ed Carpenter Racing Partners with Surfcam and Online Resources
Walter-Comara Venture Provides Advanced Connectivity for Smart Manufacturing
Prize Turns a Profit for Waterjet Winner
F. Zimmermann Opens Subsidiary in the U.S.
Expand Material HandlingMaterial Handling
Expand People In The NewsPeople In The News
Expand Quality ControlQuality Control

show all editions →

Click here to watch Tutorial Videos >

Top Five Reasons Spreadsheets Are Dead Weight



"Spreadsheets are still fairly prevalent on shop floors, and it is understandable," said a Shop Floor Automations (SFA) spokesperson. "They have been a long-standing part of manufacturing operations and offices in the manufacturing industry. However, sticking to this enduring method could be costing productivity."

SFA offers five reasons why a shop floor should make the change from spreadsheets to a real-time graphical job scheduler.

  • Reason One: No ROI for time spent on spreadsheets. Personnel is spending time manually noting information on a spreadsheet plus doing related administrative work, such as filing and searching for work order data info. If a company has more than a couple of machines and more than a handful of employees, this is time wasted. The company could instead have software with real-time insight from its production schedule that shows capacity usage and keeps jobs running on time.
  • Reason Two: Data entry errors require revisiting. This means more time, resources and money spent on fixing human errors. Instead, there is software that can help with data entry - for example, no duplication errors from entering work times. Users will also have day-to-day planning data based on real-time capacity versus guesswork based on previous spreadsheets.
  • Reason Three: Control-F is not the answer. When looking for specific info in a spreadsheet, it is likely that personnel will have to rely on memory of data from a certain tab, search tab to tab or use the Control-F command to search by keyword (Control-F cannot be used, however, if spreadsheets are printed and filed away). Instead of sifting through information, software programs are available that can access work orders and look at job statuses immediately.
  • Reason Four: Dreading growth because it means more paperwork. A spreadsheet is not able to adjust itself when new jobs come in or when a job is canceled. A spreadsheet is not able to tell when machine issues are causing a bottleneck. Job tracking, planning and scheduling, all combined into one simple interface, will help production run more efficiently.
  • Reason Five: Machinists are not office clerks. There is a sizable skills gap in manufacturing that will be filled slowly over the next few years, and asking a qualified machinist to spend time helping with redundant paperwork that automated software could be doing is not in a company's best interest. User-friendly software only requires a few button pushes for operators to provide immediate feedback on current job statuses.

"The bottom line is that job scheduling software is crucial for knowing if deliveries will be on time," said the spokesperson. "The software takes into account current jobs along with machine capacity, and allows personnel to see where the jobs are and when they are going to be completed. Unexpected downtime on machines will be accounted for and re-scheduling based on new machine capacity can occur.

"With a reliable, real-time scheduling system in place, companies will be better equipped to update valued customers on delivery dates and identify late jobs before they happen so there is time to prepare or fix the issue. Displays of pre-order and estimated costs, as well as actual costs incurred during manufacturing, are shown as they occur, which is of added value."

JobPack real-time scheduler software, available from SFA, is designed to provide seamless production operations to help shops operate at full capacity.

Co-Authored by Amanda Rosenblatt and Amy Gates, Shop Floor Automations

For more information contact:

Greg Mercurio, President

Shop Floor Automations, Inc.

5360 Jackson Drive, Suite #202

La Mesa, CA 91942

877-611-5825 / 619-461-4000

sales@shopfloorautomations.com

www.shopfloorautomations.com

< back

Email   email