This CVC Generator allows you to generate Combinations of CVC's (3 levels of different data) in Excel for APO Demand Planning. It takes 6 Columns of data and generates any of the Cells that are highlighted in the Odd Columns and then builds an output File from these selections (it can include the Descriptions too if you want). The Workbook allows you to create your own Table of data and format the output by sorting the Columns, sorting the final output, adding in Blank Columns, inserting new Columns with auto-populated Text Fields, renaming the Headers for the Columns and repeating Columns
A Rollover Sidebar Calendar for Excel that can be used to pick a Date and Capture the Date by a Defined Name or by VBA. You can advance the Month using a Drop-down Combo Box or back & forth using tiny arrows. You can set the Calendar to the current Date by pressing the 'Today' Button. As you roll across the Calendar the Cells are highlighted Red and the Selected Day is highlighted Black
Phasing Template will phase Integer values using Formula across 12 Weeks and prevent loss of Integers by implementing a Largest Remainder method. You can Copy & Paste the data into a Table which will dynamically expand all of the Formula. You can Phase each Week by a Fraction ie. 23.7% and omit Weeks if you want. The Formula will then calculate the results ensuring that only whole Integer values are returned. The results can be copied out directly from the template with the option to copy zero or blank Cells. This template can be useful when Phasing Promotional Volumes. An additional Phasing Worksheet is included with the download File that includes the Formula but doesn't use a Table
Here are some easing Functions put together with a Frame Timer to allow you to create some nice effects for animation in Excel. I have added a small green square, a Frame Timer and a Chart that plots the values from the easing Functions. Version 1.2 includes some lovely Shape animations using the Bounce easing Function...