Spreadsheets in Business

DDMRP Stock Distribution

Demand-Driven MRP in an Excel Planning System. See a demo system and get a free, fully-functional copy of the DDMRP planning system in Excel.

{ 10 comments }

Continue Reading
Module Cubes

How Excel-based modules can combine for a flexible planning system.

{ 7 comments }

Continue Reading
Webinar Spheres

We are launching webinars to help you with planning and scheduling in Excel.

Here is how you can watch us build, set up and use these free downloadable tools.

Pre-register for our first webinar coming up soon!

{ 22 comments }

Continue Reading
Demand Planning Sales Forecasting

Here are five things you need to know about forecasting.

This is a statistics-free zone. Five forecasting principles for demand planning.

{ 15 comments }

Continue Reading
Excel Planning Rating

How does your Excel planning measure up?

Are you getting the best results or are you suffering from Excel hell?

Here is a simple measurement and a download tool that can give you an instant rating on your planning tools built with spreadsheets.

{ 4 comments }

Continue Reading
Exploding Tables in Excel Planning

This is a core method to apply the Fast Excel Development Method in building a planning and scheduling system in Excel.

Convert forecasts, explode demand and generate work orders — this method is something that every planner should know.

{ 13 comments }

Continue Reading
View on scheduling

Is the purpose of production scheduling to feed MRP and execution?
If you’re satisfied with this answer, then you’re missing something. A small, two-letter word will change the way you look at scheduling.

{ 6 comments }

Continue Reading
Index Excel Formula for Software built by Spreadsheets

I would like to introduce the most useful function that Excel has to offer.

This is the most widely used Excel function in the Fast Excel Method. When building planning systems, I find myself typing this in formulas more than any other function.

The function can transform Excel spreadsheets into a fully-blown business software platform. We use it to retrieve data, perform calculations and present them in a report.

{ 21 comments }

Continue Reading
Manufacturing Reality and Master Data

Represent your manufacturing business using master data. Link the planning and scheduling system to the real world.

Excel-based planning systems give you more flexibility. Flexibility within the realms of the possible. Here are the essentials of master data and how they map onto your business.

{ 12 comments }

Continue Reading
Excel Software Secret Trick

ERP often fails to give you the flexibility and visibility that you need.

Excel use has its own problems with spreadmarts and spreadsheet sin.

Apply this technique and take control over your planning and reporting. Getting Excel to perform like a business system.

{ 7 comments }

Continue Reading
Predictive operations planning

Predictive planning provides a way to manage uncertainty. Planning can resolve the dilemma between schedule-push and demand-pull.

How an Excel-based predictive planning tool can work alongside the business transaction system.

{ 26 comments }

Continue Reading
Calendar Capacity Planning Scheduling in Excel

This is a guide to help you use calendars in planning and scheduling.

Production capacity starts with calendars – here’s how to make a calendar and calculate in Excel.

{ 16 comments }

Continue Reading
Calendar Capacity Planning

Capacity planning compares minutes of production with days of resources. Here is an easy way to convert minutes to days over any working calendar.

This technique also helps to simplify many Excel date calculations for working days and times.

{ 10 comments }

Continue Reading
Excel Planning Habits

Happy new year! A time for planning and new year resolutions.

Ouch. The word “Resolutions” doesn’t give you good feelings, does it?

I prefer habits -form them and it takes effort to break them. Here are seven good habits for using Excel for planning.

{ 113 comments }

Continue Reading
Post image for 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:..

{ 36 comments }

Continue Reading
Post image for Build a Material Planning Tool in 10 Minutes

I have demand, on-hand inventory and open purchase orders.  What orders can I cover with materials and which orders are going to be short? This is a simple question in material planning.  We frequently get asked by clients to build spreadsheet tools that can provide an answer.  You can download

{ 23 comments }

Continue Reading
Excel 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:

{ 20 comments }

Continue Reading

Many of the tools, templates and systems that we build use macros in Excel.  Some of you will be quite capable and experienced with Excel macros and VBA.  Others could be coming across Excel macros for the first time. Excel 2007 upwards has some additional security for running macros.  If

{ 13 comments }

Continue Reading
Post image for 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

{ 9 comments }

Continue Reading