How do I set up multi-layered calendars for comparing people/task

C

csspace(WNY)

I need to set up a system of multi-layered calendars to asssit in planning
people/ vacations/ and known tasks that are scheduled in the future to insure
no one is absent during critical time periods. I would like it to work
similarly to what you can do with multiple department budgeting, where you
can decide how to combine departments or groups of depts into combined
divisional budgets.

Not sure which product would be the best to use for such a system...Excel or
Outlook or Access
 
D

DatabaseBen

csspace(WNY) said:
I need to set up a system of multi-layered calendars to asssit in planning
people/ vacations/ and known tasks that are scheduled in the future to
insure
no one is absent during critical time periods. I would like it to work
similarly to what you can do with multiple department budgeting, where you
can decide how to combine departments or groups of depts into combined
divisional budgets.

Not sure which product would be the best to use for such a system...Excel
or
Outlook or Access
Click to expand...
 
D

DatabaseBen

excel would be a reasonable option
since it allows you to tabilize the listings of
names and dates. And the layers can
be segregated by the worksheet tabs.

With some trial and error, you can use formulas to link
the data throughout the tabs.

And with a little more work you can produce the data
as a table or html that can be accessed centrally on your
network, sent via email or printed on paper.

this would be the easiest, but can be improved with
some vb programming "or"
if you outgrow the excel method, those spreadsheet tables
can be imported into or linked by access.
 
D

DatabaseBen

it seems that my previous resposne was zap by this server.
--------------
in any case, the easiest way to start the project is to use
excel as it will provide the ability to tabilize names and dates.

the layering you are seeking can be provided via the worksheet
tabs.

with a little formulations and maybe some vb programming,
you will be able to produce the tables or reports via html for
sending via outlook, displaying as html on your network or
printing on paper.

if you find some limitations in excel, then those tables
will easily be imported into access or can be linked by access....
 
Top