We have a new version of the Fast Excel Development Template. These are improvements arising from our team using this template to build dozens of planning tools and systems. It has been 15 months since the last update and we have a lot of things to share. Much of this work has been done with […]
Fast Excel Development Template v4.4 Read More »
“If this is a template, why are most of the sheets blank?”
“What is a modular system? How will this help my planning?”
We will answer these questions, and more.
NEW RELEASE – Fast Excel Development Template v4.2.0 – Now Supporting Modular Systems Read More »
How to build a complete material and capacity planning tool, with finite production scheduling and purchased materials constraints by Excel and the Fast Excel Development Template.
An update to Excel 365 in January 2020 means INDEX might work more slowly. Here is how to fix it so it works faster than ever.
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.
Get an Instant Rating for your Excel Planning Read More »
The biggest headache in material planning is long lead-time materials.
Here is a simple tool that gives visibility between a buyer and a factory separated by a lot of water.
Also see an easy trick to connect multiple Excel users on different continents with free data integration over the cloud.
How To Plan for Long Lead-Time Materials Read More »
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.
Seven Habits for Highly Effective Excel Planning Read More »
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 a simple example of such
Build a Material Planning Tool in 10 Minutes Read More »
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 you have run macros before
Run Macros with Excel 2007 and above Read More »
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 »
