Pages

Wednesday, February 5, 2014

Event Calendar Maker v2 - Excel Template

The Event Calendar Maker is an Excel workbook (.xlsx) that you can use to create your own personalized event calendar. 

v2 released in Nov 2014

REQUIREMENTS

You need a copy of Microsoft Excel to open this file. Event Calendar Maker has been tested in 
  • Microsoft Excel 2007, 2010 and 2013 for Windows 
  • Microsoft Excel 2011 for Mac

Excel Calendar Template - indzara Event Calendar Maker

FEATURES
  • Calendar Creation
    • Creates 12-Month calendars instantly with your own events
    • Works with any year after 1900
    • Start your calendar with any month; Start the week with any day;
    • Displays up to 300 of your active events
    • Can handle various event frequencies (One-time, Daily, Every Nth day, Weekly, Monthly, Nth Weekday of Month, Last Weekday of Month)
    • 1200 active event instances can be tracked (e.g., event which lasts 5 days has 5 instances)
    • Categorize your events in up to 12 different event types
    • Customize weekends: chose weekdays that are non-working days or weekends. 
  • Calendar Designs
    • 6 Calendar designs (2 Yearly, 2 Monthly, Weekly and Daily calendars)
    • Event dates are highlighted on the calendars. In 4 designs, event names are also displayed
    • Each event type can be highlighted with different color (from 15 colors)
    • Weekends are highlighted with red font on the calendars
    • Control which events you would like to display by deactivating events
    • Control the order of priority of events (when more than one event is on a day)
    • Readily printable
    • No Macros; completely built with formulas and conditional formatting

BUY

You can purchase the template by using the 'Add to Cart' button below and then choosing Checkout. You will be redirected by ejunkie.com to PayPal where you can use your credit card or PayPal account to purchase. You can download the file instantly after payment. An e-mail will also be sent to your e-mail address with a link that you can use to download later. You will also receive all future upgrades of this product to your e-mail for free. If there are any questions about the purchase process, please e-mail me at indzara at gmail.

US $15

Add to Cart
View Cart


PRODUCT TOUR


HOW TO USE THE TEMPLATE

The template has 8 worksheets and you can just click on the worksheet name (tab) and go to a specific sheet. In the Home worksheet, you will get started with entering some basic information about the Calendar.


STEP 1A: BASIC SETTINGS
Excel Calendar Template - indzara Event Calendar Maker
  • Enter the year 
  • Enter the Month
    • Your calendar will have 12 months beginning with the month in that year 
  • Enter the day you would like the week to begin with. You can choose from (MON, TUE, WED, THU, FRI, SAT, SUN)
  • Enter a name for your calendar. This will be displayed on the calendar.

STEP 1B: SET YOUR WEEKENDS
Excel Calendar Template - indzara Event Calendar Maker

This option allows you to customize the weekends according to your needs. Choose 'WKD' if you would like a specific Nth weekday of a month to be considered as weekend day. For example, in the image above, all Sundays and all second Saturdays are considered as weekends. They will be highlighted with red font on the calendar. If you would like to change, you can delete ‘WKD’ or select ‘NO’. Blanks are also considered as ‘NO’. 

STEP 1C: SET UP TO 12 EVENT TYPES WITH COLOURS

Excel Calendar Template - indzara Event Calendar Maker

You can enter your own (up to 300) events that will be displayed on the calendar. You can also categorize them under (up to) 12 event types. First, you will enter the names for the Event Type. You can choose a colour for each event type from the list of 15 pre-chosen colours. The color next to the Event type will be used to highlight the corresponding dates on the calendar. 
Here is an example of some event types and colours.


Excel Calendar Template - indzara Event Calendar Maker





STEP 2: ENTER EVENTS

In the ‘Events’ worksheet, you will enter your events. You can enter up to 300 active events and these events will be highlighted on the calendar. 


Excel Calendar Template - indzara Event Calendar Maker



2A. Enter the Event Name,  Event Type, Event Start Date and Event End Date
  • By choosing the event type, the dates will be color-coded on the calendar according to what you chose in Step 1C. 
  • If the Event Type is blank or not one of the Event Types listed in the 1C, the event will not be highlighted with colour on the calendars.
  • If you have multiple events on the same day, you will enter them separately. 
  • You can enter events in any order. They do not have to be in chronological order.
  • Leave the Event End Date blank if it’s a One-time event. 
2B. Choose Frequency Type from the seven options
Excel Calendar Template - indzara Event Calendar Maker
    2C. Choose the Weekdays you would like to allow for each event. Enter 1 in the MO column, if you would like the event to happen on Mondays. These fields are not applicable for One-time and Every Nth day events. 

    Excel Calendar Template - indzara Event Calendar Maker

    2D. Enter N; This is not applicable for  One-time, Daily and Last Wkday of Mth events. 
    Examples: 
    • Every Nth day - Enter 2 as N to create events every 2 days
    • Weekly - Enter 2 to create events every 2 weeks
    • Monthly - Enter 2 to create events every 2 months
    • Nth Wkday of Mth - Enter 2 to create events every 2nd Weekday of Month (Weekday will be chosen in the previous step)

    Excel Calendar Template - indzara Event Calendar Maker

    2E. Enter N in ACTIVE? column if you would like the event to be not displayed on calendar.

    2F. Enter Priority. When more than one event happens on a day, Higher Priority event's color will be chosen for calendar display. Lower Number means higher priority. 
    • If you don't enter any priority, it is equivalent to zero (Zero has higher priority than any positive number).
    • If two events have the same priority, then the events will be prioritized based on the order in which you entered them in the Events table. 
    2G. There are optional columns for Event Description and Start Time. There are also two custom columns that you can rename and use. These four columns will only appear in Daily calendar. 

    Excel Calendar Template - indzara Event Calendar Maker


    2H. Check the Validation column. 
    Events with errors are shown with a red border in the table. 

    Validation field will display 'Error' for following reasons  
    • Event Start Date is blank
    • Event End Date is before the Event Start Date
    • Frequency Type is blank
    Validation field will show 'Not Displayed' for following reasons
    • Event End Date is before the Calendar Start Date
    • Event Start Date is after the Calendar End Date (12 months from Start Date)

    STEP3: CHOOSE CALENDAR DESIGN




    There are 6 calendar designs to choose from. All the 6 calendars are automatically generated based on your inputs in STEP 1 and STEP 2. In all the 6 calendars, event dates are highlighted with colours. 


    • Yearly: 12 Months in one page, event names are not displayed
      Excel Calendar Template - indzara Event Calendar Maker
    • Yearly with Events:  12 Months in one page, event names are displayed
      • You can also choose from Events or Instances to display. Up to 150 events or first 150 event instances will be displayed. 
    • Monthly: 12 pages (1 Month in each page), event names are not displayed
    Excel Calendar Template - indzara Event Calendar Maker


    • Monthly with Events: 12 pages (1 Month in each page), up to 5 event names per day are displayed
    Excel Calendar Template - indzara Event Calendar Maker


      • Weekly with Events: Choose any day and you can see the week's events. Up to 20 events are displayed with name and color.
      Excel Calendar Template - indzara Event Calendar Maker

      • Daily with Events: Choose any day and you can see the day's events. Up to 20 events are displayed with name and color. Start Time and Event Description are displayed. You can also enable custom columns to be displayed.
      Excel Calendar Template - indzara Event Calendar Maker


      STEP 4: PRINT OR EXPORT

      You can print the calendars easily as they are already set up to be printed. You can also export calendars to PDF documents for sharing.


      ---------------------------------------------------------------------------------------------------------------

      Please note that only the features that are mentioned here are possible in this template. The objective of this template is to provide a simple solution to a very specific need (to create event calendars quickly). Here are some examples of what the template does not do.
      • The template doesn't create any reminders for events. 
      • The template is not integrated with any other software. It's a stand-alone Excel workbook file.
      • There is no data back-up system. It is recommended to save the file and make back-up copies as necessary in your computer.