# Formula to calculate productivity

#### kizzie37

##### Well-known Member
Is there any way to calculate this with the informatio provided, I can figure out the formulas required to correctly calculate the remaining weeks based on the number of resources and the effort working on the tasks:

Excel 2010
BC
39Priojected Calendar Time for Remaining Tasks
41Projected Calendar Time Remaining for Tasks264
43Total Projected Calendar Weeks Remaining290
44
45Projected Time Remaining Calculator
46Number of Writers1.00
47Team Efficiency100%
48Percentage Work Time Spent on Project50%
49Projected Time Remaining
Sheet1

So if is 290 weeks remaining (each task takes 26 weeks), how do you accuarately create a formula that will calcualte the time remaining based on numbers changing ( i.e. increase in writers, increase in % work spent on project) and also the team efficiancy?

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
I think this formula for C49 would be correct:
=C43/(C46*C47*C48)

Replies
3
Views
631
Replies
2
Views
113
Replies
1
Views
143
Replies
1
Views
238
Replies
2
Views
156

1,196,047
Messages
6,013,085
Members
441,747
Latest member
darkman77

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back