+ Reply to Thread
Results 1 to 3 of 3

Calculate number required depending on previous months' results

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    48

    Calculate number required depending on previous months' results

    Hi
    Hope someone can help?

    I need to write a formula that will solve the following problem, but so far I'm not having much luck.

    I work in a call centre and my job is to assess the staff's calls.

    Each month they have 7 calls listened to. If they score above 96% they stay on 7 calls the next month. If the score <96% they need 12. If those 12 score below 96% they would need 17, but if they reach 96% they go back to 7 the following month. 17 is the maximum, so when on 17, they will either stay at 17 (if they score <96%) or drop to 12 and then to 7 etc.

    Hope this makes sense? I want this calculation (I.e 'how many calls does John need listening to in September?) to be automated, depending on his scores for the previous months!

    I might be wanting too much, but if anyone can suggest a way forward, I'd very much appreciate it.

    Hope my explanation of the scenario is clear!

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,491

    Re: Calculate number required depending on previous months' results

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calculate number required depending on previous months' results

    Hi and welcome to the forum.

    Be sure that best way to describe your problem is to upload a sample workbook.

    Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.

    To attach a small sample workbook.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    04-19-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    48

    Re: Calculate number required depending on previous months' results

    I've created a 'mock up' of what a three month 'summary' would look like, but it's hard to describe (hopefully it makes a little more sense).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculate Number of Months
    By xybadog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2013, 05:55 AM
  2. Calculate number of months in year
    By littlelax in forum Excel General
    Replies: 9
    Last Post: 02-02-2012, 09:01 AM
  3. Formula required to calculate points for football results prediction
    By Jen1979 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-15-2009, 11:46 AM
  4. chart - calculate the number of months
    By svx123 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-31-2007, 07:13 AM
  5. Calculate number of months between 2 dates
    By john liem in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-01-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1