Google
Search WWW Search us
  Home   Products   Order   Download   Links   Q & A  
  Concept                      Install   Step by Step   Advanced   Purchase  
 

Advanced Calendar for Excel™ is a Microsoft® Excel macro that creates a variety of calendars and planners. The spreadsheet environment is used to quickly generate daily and weekly planners including task lists with links to a monthly overview. Professional calendars are effortlessly produced in one month, six months and yearly formats.

The product runs on both IBM-compatible and Macintosh platforms and requires Microsoft® Excel. After installing the program, you can activate the Advanced Calendar for Excel™ from the Excel menu.

The Advanced Calendar for Excel™ contains all functionality of the Calendar for Excel™ .

The program can generate the following spreadsheets:

  • Calendars              (Please review this functionality in Calendar for Excel)
  • Weekly Planer       (Please review this functionality in Calendar for Excel)
  • Daily Planer           (Please review this functionality in Calendar for Excel)
  • Database to Calendar

The program works assuming that you have stored your data in the following format:

  • Column A contains the Date (MS Excel Date Format)
  • Column B contains the L1 (Line 1)
  • Column C contains the L2 (Line 2)

This formation is defined as Calendar DB. If you can generate the above format, the program automatically generate monthly calendars with line L1 and L2 in the correct day.

However if you have the data in MS Excel but not in the format show, Advanced Calendar for Excel program can automatically generate the Calendar DB format from verity of different forms. We highly recommend that you go thorough  the basic Calendar generation and the check all predefined cases.

If you think our program can not generate your case, please send us a sample MS Excel worksheet and make sure you specify Date Column, L1 and L2 column numbers.

The following cases are available in the ADVANCED section

  • Date, L1, L2 stored in different column
  • Date, L1, L12 , L2, L22 stored in different column (Note 4 Columns to be displayed as L1 and L2)
  • Date is a part of string and has a known FIXED start position
  • Date is a part of string and has a known FIXED start position and FIXED end position
  • Date is a part of string and has a known CHARACTER start position
  • Date is a part of string and has a known CHARACTER start position and known CHARACTER end end position.

How to Import a Simple Database to Calendar

Assume that you have the following database.

  • Date:                 The column A contains the MS Excel format Date
  • Line 1 (L1):       The column B contains the Name of activities or person
  • Line 2 (L2):       The column C contains the Role (This is optional)

The data is stored in DB_Case_01.XLS file.

1: Open the Database

Start Advanced Calendar for Excel program and select the Setup worksheet

Click the [3] outline button to open up the step by step instructions. If you don't see the outline symbols one two three, plus, and minus, click Options on the Tools menu, click the View tab, and then select the Outline symbols check box.

Click the "[2B] Browse and Open Calendar DB file" button and open the DB_Case_01.XLS file in the

C:\Program Files\BaRaN Systems LLC\Advanced Calendar for Excel folder.

The information in the program setup worksheet will change to:

Step 2:Run the Program

Make sure you enter the following data in Step 3 of the Setup Worksheet.

Click the "[3] Build a Calendar from Calendar DB file" button.

Click the OK button.

3: Review the Results

Review the results in MS Excel

or automatically generated web pages

If you are interested to review more functionality please check the advanced pages.

 
  Home | Products | Order | Download | Links  | Services    
 
  © 2003 BaRaN Systems LLC. All rights reserved.