The PC HelpSite
www.officehelp.biz
Office Tutorials & Software Solutions
Specializing in Advanced Spreadsheet & Office Macro Solutions.
Calendar Plan Generator - ADVANCED Edition

Application Microsoft Excel Version 4.00
Author OfficeHelp
Tested on 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

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.

Contact Us for Support Help Information FREE DEMO

Fancy that Project Style calendars but don't have a project management software? 

If you have Microsoft Excel, you can now 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.

Really easy to use, just fill in the values in the Input Cells and press the "Run" button to create several different styles of Calendar Plans.

Calendar Plan Generator Input File Screen Shot

PIC. 1 - Screen Shot from the Microsoft Excel Macro File (Click to Enlarge)

The system will generate a new workbook with the resulting Calendar (PICs. 2, 3, 4 and 5). This new workbook HAS NO MACROS on it, just the resulting calendar. Change, save and email it as any other regular Microsoft Excel file.

EXCEL ONLY - No installation or setup required. Just open in Excel and run!

FOUR types of calendar plan from the SAME task list!

Generate daily, weekly, monthly, yearly or ALL (make them all at once) calendar plans from the same task list and parameters:

  • 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;
      
  • 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.
     
  • Monthly Calendar Plans are calendar plans with a column for each separated month in the calendar main interval. This gives still less detail but produces very compact calendars for larger periods. Better for larger periods (1 year and above). Very good for 1 year calendar plans with an overview of the main tasks.
     
  • Yearly Events Calendars are a completely different concept: There is no task bars, just a 1 year grid (per year) and tasks attributed to each day. Better for important but short events like meeting and holiday calendars.

Calendar Plan Generator Result File (DAILY)  Screen Shot

PIC. 2 - Screen Shot from the resulting DAILY Microsoft Excel File (Click to Enlarge)

Calendar Plan Generator Result File (WEEKLY) Screen Shot

PIC. 3 - Screen Shot from the resulting WEEKLY Microsoft Excel File (Click to Enlarge)

Calendar Plan Generator Result File (MONTHLY) Screen Shot

PIC. 4 - Screen Shot from the resulting MONTHLY Microsoft Excel File (Click to Enlarge)

Calendar Plan Generator Result File (YEARLY) Screen Shot

PIC. 5 - Screen Shot from the resulting YEARLY Microsoft Excel File (Click to Enlarge)
 


Spending full days manually making calendars or GANTT Charts? Spending hundreds on specialized software you don't know how to use?

This easy to use macro for Microsoft Excel will generate pretty calendar plans in minutes. No need to learn new software skills. Get your Plan Generator now by using one of the BUY NOW buttons on this page.

 

 

Download FREE Demo

Based only on EXCEL

  • No software instalation or Setup Required!
  • Standard Excel output - Anyone can edit the output, there is no macros on them!
  • Standard Excel input . All input is taken from standard Excel cells
    • All Excel features like formulas or links to existing files can be used to input data!

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (CalendarPlan4Advanced.xls). Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file). Microsoft Windows XP will let you do it directly, presenting the file as folder. On older versions of Microsoft Windows, you will need an extra application like the popular WinZip. Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. The DEMO version of other products can be also included for evaluation purposes.
 


Get THIS and ALL other Excel CALENDARS in a SINGLE download! Click HERE!

Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


FULLY CUSTOMIZABLE - Make them look the way YOU want

There are now 4 customization categories and you can customize all aesthetical features of the plan just by supplying samples of YOUR intended format. To supply them samples, just format (using Excel regular tools) the source cell!

  • Month Names are supplied as full names in English. You can use short names, numbers or a different language;
      
  • Header Column Widths (like the task names column!) can now be defined in advance so that you don't have to adjust each calendar output later.
     
  • Background Colors and Fonts for all Plan Cells - Format the Font and Background Color of the sample cell for Headings, Task NamesOptional Fields, Calendar Area, Weekend Days and Deadline Markers. The macro will copy their format to all related plan cells!
      
  • Global Formatting options like the use of Gridlines on the Output Calendar Plan or the insertion of the beginning and end dates on task bars (Weekly and Monthly Plans only).
  Customization Sheet

PIC. 6 - Screen Shot from the Customization Sheet (Click to Enlarge)

BETTER CALENDAR PLANS WITH LESS EFFORT

Optional Fields

You can include/exclude up to 3 optional fields that are added as columns between the Task Names and the Calendar Plan (PIC 7). They are defined by default as % Done, Resource and Category, but can be used for any other purpose. Just change their name!

Optional Fields in Plan

PIC. 7 - Optional Fields in Plan (Click to Enlarge)

Detail Management

Plans don't all need the same amount of detail (or sub-tasks). Long-term plans like monthly plans may include only the main tasks (Level 0 or Level 0 and 1) but Short-Term plans like Daily or Weekly may include all sub-tasks (PIC 8). Selection is made on the Include Levels option field near the Run button.

Detail Management - Level 0 Tasks only on Monthly Plan

PIC. 8 - Detail Management - Level 0 Tasks only on Monthly Plan

Detail Management - All Levels on Weekly Plan

PIC. 9 - Detail Management - All Levels on Weekly Plan

Improved Readability

Each Task Start and End dates can now be included on the Plan types where they were not immediately visible on the Plan itself (Weekly and Monthly):

Start and End dates on Task Bars (Click to Enlarge)

PIC. 10 - Start and End dates on Task Bars (Click to Enlarge)

Automatically split long calendars

Force calendar plans to be automatically split every N (3, 6, ...) months to produce readable and easy to print plans. Create each split plan on the same sheet or on different workbooks at choice. No additional effort, just make your choices and press run!

Non-split calendar (Click to enlarge)

PIC. 11 - Non-split Calendar (Click to Enlarge)

Split Calendar (Click to Enlarge)

PIC. 12 - Split Calendar (Click to Enlarge)


Spending full days manually making calendars or GANTT Charts? Spending hundreds on specialized software you don't know how to use?

This easy to use macro for Microsoft Excel will generate pretty calendar plans in minutes. No need to learn new software skills. Get your Plan Generator now by using one of the BUY NOW buttons on this page.

 

 

Download FREE Demo

Based only on EXCEL

  • No software instalation or Setup Required!
  • Standard Excel output - Anyone can edit the output, there is no macros on them!
  • Standard Excel input . All input is taken from standard Excel cells
    • All Excel features like formulas or links to existing files can be used to input data!

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (CalendarPlan4Advanced.xls). Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file). Microsoft Windows XP will let you do it directly, presenting the file as folder. On older versions of Microsoft Windows, you will need an extra application like the popular WinZip. Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. The DEMO version of other products can be also included for evaluation purposes.
 


Get THIS and ALL other Excel CALENDARS in a SINGLE download! Click HERE!

OUTLOOK INTEGRATION

Most Excel users are also Microsoft Outlook users and already have events like Meetings, Holidays and other tasks on Outlook  So why write them again for a Calendar Plan?

Import Tasks or Calendar Events from Microsoft Outlook

Importing from Outlook is as easy as defining the desired source (Outlook Calendar or Task list) and Color, Deadline Marker and Task Level for the imported tasks. Press the Import from Outlook button and select the first row for the imported tasks (no overwriting of manually entered tasks). Relax and see your tasks being automatically added for you!

Import from Outlook interface

PIC. 13 - Import from Outlook interface

WARNING: To be able to import Shared Calendars or Calendars/ Task List sub-folders, you need the more advanced CUSTOM Edition (click here).

You can define Advanced settings for special cases on the macro CONFIG sheet. Check the Help Information for details.

Import from Outlook Advanced Options

PIC. 14 - Import from Outlook Advanced Options

It can also be used to print Outlook Calendars or Task lists - Just import them, apply custom formats, create the calendar and print it.

OTHER FEATURES

Is Help available?

Yes. There are two sheets on the Microsoft Excel Workbook (PIC. 15). The first one is the Input sheet, the second is the Help one. There is also an Online Help Page for this product (see bottom of page for all related links).

Excel Sheets within the Macro

PIC. 15 - Input and Help Sheets

Can the resulting Calendar Plans be customized?

Yes, before and after generation. The month names, supplied in English, can be changed to match any other language. The task bars on the calendar can have selected colors and optional deadline terminator.

After generation, the file can be manually changed as any other regular Microsoft Excel file. There are no special features to the Calendar file, it is a regular Excel file with painted cells.

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

It's a regular Microsoft Excel file. There are NO MACROS on the resulting plan, only on the generator file. It can be freely copied and manipulated.


Spending full days manually making calendars or GANTT Charts? Spending hundreds on specialized software you don't know how to use?

This easy to use macro for Microsoft Excel will generate pretty calendar plans in minutes. No need to learn new software skills. Get your Plan Generator now by using one of the BUY NOW buttons on this page.

 

 

Download FREE Demo

Based only on EXCEL

  • No software instalation or Setup Required!
  • Standard Excel output - Anyone can edit the output, there is no macros on them!
  • Standard Excel input . All input is taken from standard Excel cells
    • All Excel features like formulas or links to existing files can be used to input data!

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (CalendarPlan4Advanced.xls). Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file). Microsoft Windows XP will let you do it directly, presenting the file as folder. On older versions of Microsoft Windows, you will need an extra application like the popular WinZip. Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. The DEMO version of other products can be also included for evaluation purposes.
 


Get THIS and ALL other Excel CALENDARS in a SINGLE download! Click HERE!

Need more CALENDAR OPTIONS?

Consultant? Developer? Corporate IT? Make your own BRANDED version!!!

Rebrand messages and interface with YOUR logos and trademarks! Add missing features or adjust existing ones to your clients special needs. Supply it as your own product:

  • Link to the CUSTOM Edition - No coding, just enter YOUR own messages to replace our own branded messages and learn how to replace the logo, lock your changes (make them permanent) and distribute YOUR own BRANDED version of our macro! No coding! Check the licensing terms.
  • Link to the Source Code Edition - Add missing features or adjust existing ones to your clients special needs. Supply it as your own product. Full access to the Macro source code. If you know Excel VBA you should have no problems understanding this macro. Check the licensing terms.

Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


Contact Us for Support Help Information FREE DEMO


Get FREE PC TIPS every month:

 

www.OfficeHelp.Biz

(c) 2004 - 2017 OfficeHelp.Biz