Brain Freeze - What is the formula and whats the best way you would do it

Eisasuarez

Well-known Member
Joined
Mar 23, 2012
Messages
653
Hello ALL

I am trying to give my manager a true reflection of the percentage resolved vs the percentage incoming to show if we are being productive or not . Whats the best way you would do it and what formula would you use based on the scenario below.

Yesterdays Work Total: 100
Resolved Yesterday

Todays Work Total

Now based on the above there are 10 more pieces of work than yesterday

What percentage of work has been resolved and whats the percentage of work that has come in and how many.

This can then be used to compare if the percentage resolved is better than the percentage incoming however my mind has gone blank to how to get this result

Can someone be kind enough to help me

Thank You
 
Hi

Thats what i got and i was wondering if that was the correct formula to get the incoming volume?

in regards to incoming percentage, what formula can be used to get thatfigure and what formula do i need to get percentage resolved?
 
Upvote 0

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,215,063
Messages
6,122,930
Members
449,094
Latest member
teemeren

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top