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 Calendar for Excel™ from the Excel menu. The program can generate the following spreadsheets:

• Calendars
• Weekly Planer
• Daily Planer
• Please review Advanced Calendar for Excel for additional Database to Calendar option

Calendar

Using the calendar option you can generate monthly, yearly and 24 week calendars with your choice of direction, type and number of lines per box

You can generate a single month calendar.

Or generate a 12 months per page.

 

The monthly overview:

Entering the appointment data in the weekly planner will be duplicated to the monthly planner automatically.

     

Clicking on the Monthly Planner will move the page to the correct appointment entry.

---

Daily Planner

Using the Daily Planner option, you can generate a well-integrated daily planner with the monthly overview and with each week's activities. The built-in buttons make navigation an easy task.

 

Entering the appointment data in the Daily planner will be duplicated to the Monthly planner automatically.

Clicking on the Monthly Planner will move the page to the correct appointment entry.

---

How to Use The Goal Worksheet

Please do the following Steps:

A- Define a Project as show below.

Project	Phase	Owner	Priority	Description	Start	Final
P1		John	H	Develop Product	1-Feb-03	1-Aug-03

---

B- Define the 1st Phase.
 

Phase	Owner	Priority	Description
	John	H	Develop Product
Develop Product	Jim	H	Design

---

C- Enter the Tasks.

Priority	Description	Start	Final	Weight	Percent
H	Develop Product	1-Feb-03	1-Aug-03
H	Design	1-Feb-03	6-May-03	Total	0%
M	Product design	1-Feb-03	23-Feb-03	1.0	0%
H	Market research	23-Feb-03	7-Mar-03	1.0	0%
H	Production analysis	7-Mar-03	19-Mar-03	1.0	0%
M	Product model	19-Mar-03	31-Mar-03	1.0	0%
H	Sales brochure	31-Mar-03	12-Apr-03	1.0	0%
H	Cost analysis	12-Apr-03	24-Apr-03	1.0	0%
H	Product testing	24-Apr-03	6-May-03	1.0	0%

Note 1: You can enter data in the colored cells only.

Note 2: Use the "Weight" factor of 1.0 if all tasks requires similar effort, you can enter a correct "Weight" if it is known.

---

D- Review the Charts

---

E- Once you have started to do the tasks, enter the "Percent Done" data.

Priority	Description	Start	Final	Weight	Percent
H	Develop Product	1-Feb-03	1-Aug-03
H	Design	1-Feb-03	6-May-03	Total	40%
M	Product design	1-Feb-03	23-Feb-03	1.0	100%
H	Market research	23-Feb-03	7-Mar-03	1.0	90%
H	Production analysis	7-Mar-03	19-Mar-03	1.0	50%
M	Product model	19-Mar-03	31-Mar-03	1.0	40%
H	Sales brochure	31-Mar-03	12-Apr-03	1.0	0%
H	Cost analysis	12-Apr-03	24-Apr-03	1.0	0