### Title

workload estimation

### Post

Fairly new to FM so I would appreciate some help with how to estimate workload in my dept.

I have projects that come in on a daily basis and I have managed to find a way to calculate the time needed to complete these projects based on their complexity. Now I need to estimate finish date based on the number of people avialable to me and the time needed for the all projects in the dept.

A better way of explaining my problem would be:

If a new project came in today I would like to estimate the finish date based on the time actual time needed for the job, workload I already have and the people available to do it (fixed value).

Thanks in advance.

Obviously this requires a calculation (I do believe).

One of the things I learned early on in FileMaker is to say out loud what I want the calculation to do -- kind of like you would talk to yourself if you were figuring it out on a calculator.

I'm assuming you can create a calculation that way that would figure out the total number of workdays it would take to complete the job.

There are sample calculations that will show you how to add and subtract dates -- with and without weekends. I haven't looked them up in a while (a long while), but I think they are in the Filemaker Help section of your software.

Hopefully this has been a bit helpful.

Good luck,

V.