Knowledge Hub
Microsoft Excel
Practical Excel formulas, templates and dashboards for IE and production teams.
All204
Industrial Engineering27
Production Planning25
Lean & Six Sigma25
Microsoft Excel71
Quality12
Textile & Thread2
Sewing Machines19
Maintenance5
Utility5
Merchandising5
Store & Inventory5
Garments Industry3
Microsoft Excel
Production planning in Excel: Gantt chart, working calendar, job sequencing and set-up matrix
Build a real planning tool in Excel: a Gantt chart that flags late jobs, a Julian working calendar with breaks and shifts, cascading job times, re-sequencing, multiple work centres and a set-up matrix with INDIRECT.
Microsoft Excel
Excel date, time and text formulas for planners
TODAY, NOW, DAY, MONTH, YEAR, WEEKDAY, date differences, TEXT for time formats, CEILING for rounding to cartons or bundles, and LEN, SUBSTITUTE, FIND, LEFT and RIGHT for cleaning text.