Solved

EXCEL 2010:  Formula question

Posted on 2012-03-23
2
324 Views
Last Modified: 2012-06-21
Hello,

     I have a spreadsheet that I like to use to keep track of inbound calls received.  I'd like to track the Inbound "Total New Tickets" received and compare them with the "Total COMPLETED tickets" done for the day, this way we get an idea what our incoming ticket to completed ticket ratio or percentage is.  What would be the best way to capture this metric?  The actual spreadsheet that I used is attached.  

     For example:  

          If we received "53" tickets that day and completed "70" what would be the TOTAL NEW TICKET (inbound)  vs. COMPLETION ratio?  i.e. For every 10 tickets received we are completing 15 or something like that.  What would be the best formula approach for this? If you know a better way to do it, i'm all ears.  Any help you could provide is greatly appreciated
metrics.jpg
0
Comment
Question by:itsmevic
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 37759571
I would do the calculation as:
=TicketsCompleted / NewTickets        with result formatted as %

Ideally, you want a result around 100%. Less than 100% means that you are building a backlog--and may be understaffed. Greater than 100% means that you are shrinking the backlog, but may be overstaffed.
0
 

Author Closing Comment

by:itsmevic
ID: 37769455
Awesome! Thank you!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question