Calculate total numbers based on percentages

[FM1]

Hey everyone. I have a spreadsheet with the following information:

Column A - Name
Column B - Allocation
Column C - Start Date
Column D - End Date

I need to work out the total number FTE (full time equivalent) resources working every month and present it in a chart. Example - if John Smith has an allocation of 0.8 and is working from 01/01/09 to 01/02/09 and Tim Bob has an allocation of 0.2 and is working from 01/01/09 to 01/02/09 that will count has one full time equivalent resource for that period.

I have attached a sample spreadsheet. Thanks in advance.

[DonkeyOte]

are you weighting the allocation based on days worked ?
ie a 1 allocation for a head working for only 1/2 a month is weighted to 0.5 ?

Perhaps the attached may help, I don't know as you don't indicate expected/desired results.

EDIT: error in attachment, formula in G1 should read MAX(D:D).

[FM1]

No its not a weighted figure. For the example you gave, that just means the person is allocated to work 4 hours per day (standard day is 8 hours) over his contract period.

So to have wasted your time, but I have just realised that I am a complete idiot and also that I have all the necessary information to be able to calculate the FTE hours easily. In the same sheet I also have columns with week commencing date until end of 09 with the number of hours each person is forecasted to work. I just calculated the total number of forecasted hours per week and divided it by 40 hours (standard work week) which has given me the FTE equivalent.

So again, sorry to have wasted your time, but I have kept your formula on hand as I will definitely have a use for it. Thanks for your help.