Welcome to Kubiszyn.co.uk

This is my Portfolio of creative work for Excel. You can purchase any of these Products or read more information by clicking on the links below · follow the Geek on Facebook or Twitter
Most Popular: Holiday Planner · Pivot Notes · Treelist

CVC Generator Image 1000px x 654px
Generate Combinations of CVC's in Excel for APO · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

CVC Generator

#back to top

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

Rollover Sidebar Calendar Image 1000px x 654px
A Rollover Sidebar Calendar UI for Excel· 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Rollover Sidebar Calendar

#back to top

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 Image 1000px x 654px
Phase Integer Values across 12 Weeks using a Largest Remainder Method · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Phasing Templates

#back to top

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

Easing Functions Image 1000px x 654px
Easing Functions - Animations with Frame Timer · 2010, 2013 & 2016 (32bit or 64bit) · £2.99

Easing Functions

#back to top · #videos

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...