OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Get all OfficeHelp.Biz TEMPLATES at once!

Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
Macro Microsoft Excel OfficeHelp 14.95 USD

Calendar Plan Generator - ADVANCED Edition - Version 4.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97

(How to Buy)

 
Generate project style calendar plans, from a task list and associated details. ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.


FAQ - Frequently Asked Questions

Why do I get a Macro security warning when opening the Plan Generator ? 

There are no security risks associated with this Macro! However, a generic warning message will be displayed on most systems, or Macros may be disabled. For a general overview of Macro security issues, read this article.

Macros are a very useful tool to automate tasks in Microsoft Office. Unfortunately, like another programming language, it can be misused. There are Macro Virus, so Microsoft Office can be configured to request permission to run macros. Only run macros from known sources. OfficeHelp.Biz macros are Virus Free and can be open with confidence. Microsoft Office XP/2003 Warning: Macros may need to be activated. Follow instructions on the message Microsoft Excel XP/2003 will show, if necessary. Read this article for additional information.

Help - The button doesn't work but there are no warnings 

If you can open the Microsoft Excel file (both the DEMO and/or the commercial version) and get no warnings but the button just won't work, you have Macro support disabled. Please refer (click here) to our article on Macro security issues for information on how to configure Microsoft Office Macro security settings.

How do I get Support ? 

Use the Support Contact Us page on this website. No registration is necessary. Clearly describe your problem and contact details. We will get in touch with you ASAP. Also, the generic Contact Us page is present at the top of EVERY page on this website . Click here to jump to it


HOW-TO Information

Can I stop the macro while it's running?

Yes. Press the ESC key and it will stop with a warning message that it was interrupted before finishing generating the calendar.

Can I import Tasks lists from Version 3.0 or below?

Yes. Just copy/paste the task list into version 4. The fixed columns are the same, so it will work. You CANNOT import the optional fields because they didn't exist on previous versions.

What are Daily Calendar Plans?

Daily Calendar Plans are calendar plans with a column for each separated day in the calendar main interval. This gives maximum detail but produces long calendars for large periods. Better for smaller periods, when details are important.

What are Weekly Calendar Plans?

Weekly Calendar Plans are calendar plans with a column for each separated week in the calendar main interval. This gives less detail but produces compact calendars for larger periods. Better for larger periods, when the "big picture" is important.

What are Monthly Calendar Plans?

Monthly Calendar Plans are calendar plans with a column for each separated month in the calendar main interval. This gives less detail but produces compact calendars for larger periods. Better for really large periods, when the "big picture" is important.

What are Yearly Calendar Plans?

A completely new style of calendars. They present full years on matrix of Months vs Days and therefore need no external legend for the tasks. But it is a very convenient format for year long events like meetings, holidays, vacations and long plans like software roll-outs.

Can I make all calendars at once?

Yes, of course. Just select "All" on the Plan Type box.

WARNING: On Free DEMO Editions, the All option disables the Split By (months) field. Instead, the optimum selection for the Plan Demos in each case is used. Split By (months) will work for individual plan types. .

How to use it?

1) Fill in the general (header) input fields (PIC. 1):

  1. The name of the calendar, that will be used to name the Microsoft Excel sheet on the calendar file;
  2. The start and end date for the calendar;
  3. The split options (see below for more information - leave them as default for the first tests);
  4. The output types (Daily or Weekly, can be both);

Header Input Fields

PIC. 1 - Header Input Fields

2) Fill the task details on the Tasks table (PIC. 2):

  • Level: Level of the task. Level 0 means a task group so no % is used and has a bold label. Labels are indented to their level;
  • Color: Color to use for the task bar. Just change the cell background color using the Microsoft Excel taskbar button for that;
  • Deadline: If it has a "Y" or "y", the task bar will end with a red "D" on the last day, the deadline;
  • StartDate: Date when the task bar should start. If before the Plan start date, the bar will start on the first day on the plan;
  • EndDate: Date when the task bar should end. If after the last day on the Plan, the bar will end on the Plan last date;
  • Name: Task name or label.

Tasks details table

PIC. 2 - Tasks details table

3) Press the Run button on the header to generate the calendar.

4) If not satisfied, close (dump it) the Calendar workbook generated by the macro, change the details you want and generate a new calendar with the corrected details!

5) When satisfied, save the calendar to the disk. You can now make manual changes, multiple copies and work with it as any other regular Microsoft Excel file!

What about the Optional Fields?

There are 3 optional fields that can be used or not. Their labels can also be changed:

  • % Done: % field for the % of task done. Usually 0% at start
  • Resource: For the task resource, usually the person name or code
  • Category: Task category, in case tasks can be categorized

It is possible to change both 3 labels by entering new labels into cells I35, J35 and K35. These columns are optional because they can be disabled by changing cells I34, J34 and K34.If they are set to "Exclude" then the column will not be used on the plan.

Optional Fields

PIC. 3 - Optional Fields

What are the customization options of the CONFIG sheet?

The CONFIG sheet allows for several customizations of the Calendar Plans generated by the macro:

  • Month names: Month names used on the calendars. Can be changed to personalize language or to shorten.
  • Column Widths: Change column widths for the columns, so that you don't have to manually adjust them.
  • Backgrounds and Fonts: Here you can decide how each area on your Calendar Plan can be colored.
  • Gridlines: If Yes, the resulting Plan will have gridlines. Default is No, with a blank background.
  • Deadline Start / End Dates: If Yes, the deadline maker for tasks on the Monthly and Weekly calendars will be its date like (dd).
  • Outlook: Check details on the title below.

    CONFIG Options (Click to Enlarge)

    PIC. 4 - CONFIG Options (Click to Enlarge)

How to Import OUTLOOK Calendar and Tasks

To import Outlook Calendar or Tasks, all you need to do is to run the macro on the PC where the Outlook you want to sync is installed, and with the same account. For most cases, all you need to do is select the source and press the "Import Outlook" button.

  • Import from this Outlook Folder: Select the source for import: Calendar (default) or Tasks
  • Task Color: Color to use for the task bar. All Outlook imported events will have this color after import. You can manually change it.
  • Task level: Level to use for ALL Outlook imported events. You can manually change it after import.
  • Deadline marker: Letter to use for ALL Outlook imported events. You can manually change it after import.

There are also some ADVANCED SETTINGS on the Config sheet:

  • Import Completed Tasks: For Tasks only, define if tasks already completed should be imported. Default is Yes.
  • Import Tasks without Start / Due dates: For Tasks only, define if tasks without a defined Start or End date should be imported.
  • Import Contact info (Protected by Outlook, user will need to grant permission): Define if the Contact info of the Calendar events or tasks should be imported. This will trigger an Outlook protection and will require the user to manually accept it.

Automatic Calendar Split

Excel has a built in limit of 256 columns. Since it uses a column for each day/week, and some columns are used for data and formatting, you cannot have calendars longer than 253 days/weeks. Very long calendars can also be impossible to read once printed. The Calendar Plan Generator macro will warn you if the calendar reach the limits and propose an automatic split of the calendar into several plans. For your convenience, each calendar will have the task headings and splits are automatically made at the last full month. No months will be split in the middle.

What is the "Split Every (months)" option?

Instead of having very long calendars, you can have them split for you, automatically, every N months. You have to select a value from the list supplied, other values will not work.

What is the "Split by" option?

If your calendar plan is split, you can opt for each calendar plan to be made on the same sheet (having them all together and pre-formatted for the printer) or separated on an Excel Workbook for each. Same sheet is the default option.

What is the "Include Levels" option?

If you have a Task list with several levels (0,1,2…), it will not make sense to use all tasks on all calendars. In a Monthly or Weekly calendar it may make sense to eliminate the details and use only top-level (0,1..) tasks. On a daily calendar, it makes sense to include all tasks. With this filter, YOU choose what level of detail to include.

What is the "Reset Tasks" button?

The Reset tasks button will delete ALL tasks on the task list. Therefore, you have to confirm TWICE the action. All existing Tasks will be PERMANENTLY ERASED.

Can I change the resulting plan ?

Of course. It's an Excel Sheet like any other. There is nothing special once it's generated, only colored cells and data.

Can I save the Plan Generator with the Plan Data ? Can I have several copies ?

Again, of course. It's a regular Excel file. There are NO MACROS on the resulting plan, only on the generator file.

Can I personalize the POP-UP messages?

Only on the future CUSTOM EDITION or SOURCE CODE EDITION. Changing the messages on the Config sheet will not work on this version.

Can I leave a Blank line between tasks?

Yes, just enter a level 0 blank task (no data or name). The supplied sample data has one (line 19).

How does the Plan Generator knows when the tasks end?

The macro will stop on the first task line with no data on the task level. So if you leave the task level empty on a line, it will stop there even if more tasks exist after that line.



Calendar Plan Generator - ADVANCED Edition - Version 4.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97

(How to Buy)

Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz