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
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:
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.
|
|
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 |
|
|
|
|
|
|
|
|
