Data Integration

How to Build A Business Grade Planning System with Spreadsheets with ZERO Coding and ZERO Cost for Software Licenses- Fast Excel Development Template 4.0

The pandemic economy is shrinking software budgets. You can build your business grade distributed system based on Excel with ZERO coding and ZERO software budget. Learn how our Fast Excel Development Template 4.0 make it possible.

How to Build A Business Grade Planning System with Spreadsheets with ZERO Coding and ZERO Cost for Software Licenses- Fast Excel Development Template 4.0 Read More »

The Biggest Production Planning Mistake with Excel

Excel is the most widely used software for production planning. Production planning is one of the most common applications for Excel in manufacturing. Yet, there is one common mistake that people make when production planning in Excel. Avoid doing this one thing and you will save yourself hundreds of hours of unnecessary and repetitive work with production planning data. The mistake:..

The Biggest Production Planning Mistake with Excel Read More »

The Seven Deadly Spreadsheet Sins

Business has a love-hate relationship with spreadsheets. Widely used, accessible and essential to running the business. They are also unsecure, error-prone and scatter silos of data across the enterprise.

Depending on your point of view, spreadsheet use can be a users’ paradise or a necessary evil. Excel is the daily work-horse to over 500 million users, yet many IT departments seem hell-bent on stamping out spreadsheets and migrating everyone to business intelligence, budgeting and ERP applications.

Here at Production-Scheduling.com, we are in the business of taming spreadsheets. You might suspect that we always come down in favour of using spreadsheets for business applications. The truth is that there is only ever one answer to the question:

Should we be using Excel to ………….. (insert your business function here)

The answer is:

The Seven Deadly Spreadsheet Sins Read More »

Using Text Files to Connect Excel with Systems Data

Excel-based planning and scheduling systems need data.   Best practices in developing Excel systems say:  “Separate data storage, calculation and reporting.” A database the best place to store data.  Our Excel tool needs to bring it in, perform calculations and then send it back out.  The output tables can then feed reporting and, perhaps, update the

Using Text Files to Connect Excel with Systems Data Read More »

Scroll to Top