cantona_lives
New member
- Joined
- Nov 27, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi,
Hopefully someone can help me with a formula.
Basically I am looking to calculate how many of a certain type of resource I require on any given week.
A9 contains the role.
B9 the amount of effort
C9 –to- F9 the skill required
H9 is their effectiveness
G9 then calculates the actual resource number – i.e 2 resources at 50% effectiveness would equate to 1 resource.
I9 is the start date for the resource(s) to start
J9 is the calculated finish date
And K9 is the elapsed time
Using row 9 as an example I would like the cells under the dates from L9 onwards to be populated with the number of Actual resources required.
I could populate with ‘true or false based on an ‘AND’ formula. But is there a formula where I can populate between the two dates, with the number present in the Actual resource column?
I attach the spreadsheet for reference.
Any help and advice much appreciated. Hope this makes sense??
-CL
Hopefully someone can help me with a formula.
Basically I am looking to calculate how many of a certain type of resource I require on any given week.
A9 contains the role.
B9 the amount of effort
C9 –to- F9 the skill required
H9 is their effectiveness
G9 then calculates the actual resource number – i.e 2 resources at 50% effectiveness would equate to 1 resource.
I9 is the start date for the resource(s) to start
J9 is the calculated finish date
And K9 is the elapsed time
Using row 9 as an example I would like the cells under the dates from L9 onwards to be populated with the number of Actual resources required.
I could populate with ‘true or false based on an ‘AND’ formula. But is there a formula where I can populate between the two dates, with the number present in the Actual resource column?
I attach the spreadsheet for reference.
Any help and advice much appreciated. Hope this makes sense??
-CL