Guidance in creating automated reports Access or Excel?

[psbrown]

Hi
I have been asked to develop an automated method of creating forecast reports for projects that we are going to get in the office so we can assess mannning levels.

There are three fields per project we are interested in: Start Date, hours and periods. Sart Date not being important at this stage.

The hours per project are to be split between the number of periods but not evenly as it takes time for project to wind up and wind down.

So I started off doing this in excel and wrote a vba script to distribute the hours amongst the periods and write the results to a range of cells. This has to be done for each project and the cells added togeather and a graph created.

somthing like below

proj hours periods
1 10 5
2 15 7

Split Hours
0 1 2 3 3 1 0 - Project 1
0 1 2 3 3 3 3 1 0 - Project 2
Then Total these hours and create a graph

0 2 4 6 6 4 3 1 0 - Total hours per period


Am I better continuing to look at this in Excel or start looking at Access and in which case what method do I use to split the hours amongst periods, a temporary table?

Any Guidance appreciated.

Paul

 

[Crowley16]

if you're not really storing lots of data then I don't see any need to create an entire access database for it...

--------------------
Procrastinate Now!