中彩网|首页|官网电脑版

                                VBA and Macros

                                Long Lead-time Shipping Transport Supply Chain

                                How To Plan for Long Lead-Time Materials

                                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.

                                Seven Habits for Highly Effective Excel Planning

                                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.

                                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

                                Run Macros with Excel 2007/2010

                                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

                                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

                                Scroll to Top

                                                              education

                                                              Second-hand housing

                                                              Super League

                                                              car

                                                              Variety show

                                                              Variety show

                                                              car

                                                              Buy a car

                                                              entertainment