Forms

Forms - utilities that add worksheets for schedules, calendars, SAPs, etc....

Add Month Calendar: Inserts a new Sheet with an editable Calendar based on user input.

Add Problem Tracking Sheet: Inserts a new Sheet formatted as a basic Problem Tracking sheet. There are associated PowerPoint functions to create a Problem Tracking chart. The column headings are set up as named ranges allowing the text to be modified and the columns rearranged while maintaining the PowerPoint output to remain the same.

Add SAP: Inserts a new Sheet with an editable SAP based on user input. The user selects the Start and End dates and can choose between Daily and Weekly SAPs. For Weekly SAPS, weeks start on Mondays and the first week contains the user selected Start date. The default Start Date is the current date. The default End Date is 31 days later.

Feature updated to allow Daily or Weekly SAPs to be collapsed to display by month.

Feature updated to include Start and End Dates that drive Taskbars.

Feature updated to allow users to change the Taskbar colours by changing the interior fill colour of 2 cells and clicking an update button.

Feature updated to allow users to include or exclude Sat Sun & Holidays in Days calculation.