Demand Planning and Analytics in Excel: Fast Formulas Over 65K+ Rows
Original Source: Production Scheduling
"Analytics for demand planning in Excel usually involves big tables of data. To understand the demand for a product, you need to look into its history. Analytics with an order history over a year or more can have 100K+ records. Here is a technique to perform fast analytical formulas on many thousand rows.
The full content of this page is only available to SIG Members.
Original Source: Production Scheduling
"Analytics for demand planning in Excel usually involves big tables of data. To understand the demand for a product, you need to look into its history. Analytics with an order history over a year or more can have 100K+ records. Here is a technique to perform fast analytical formulas on many thousand rows.