+ Reply to Thread
Results 1 to 7 of 7

create SLA's in Excel

  1. #1
    Registered User
    Join Date
    11-14-2019
    Location
    South Africa
    MS-Off Ver
    MS Office 2016
    Posts
    2

    create SLA's in Excel

    Hi All l need to create SLA's in Excel, can anyone help me please.
    Last edited by Pepe Le Mokko; 11-16-2019 at 03:27 AM. Reason: Removed unnecessary title part

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,945

    Re: Hi All l need to create SLA's in Excel, can anyone help me please.

    Please read the banner at the top of this screen. Then provide needed information.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Hi All l need to create SLA's in Excel, can anyone help me please.

    In addition to what Alan mentioned. You'll need to provide bit of context.

    SLA I assume is Service Level Agreement, but that's industry specific and how to calculate/build SLA will depend largely on type of service provided
    Ex: Inbound Call Centre SLA will differ significantly from ISP SLA
    Even within inbound call centre, it can differ significantly between Sales, Data Entry, Helpdesk etc.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    11-14-2019
    Location
    South Africa
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Re: Hi All l need to create SLA's in Excel, can anyone help me please.

    Hi Alan

    not sure which banner you talking about

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Hi All l need to create SLA's in Excel, can anyone help me please.

    The yellow one.

  6. #6
    Registered User
    Join Date
    11-11-2019
    Location
    London
    MS-Off Ver
    microsoft pc
    Posts
    6

    Re: Hi All l need to create SLA's in Excel, can anyone help me please.

    SLA is service level agreement its use for calculating in large quantuiy

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,913

    Re: Hi All l need to create SLA's in Excel, can anyone help me please.

    SLA isn't really calculated. It's an agreement between service provider and client, on what service the provider will furnish and it defines standard of service provider is obligated to provide.

    Service Level is part of SLA and is calculated.

    But how will depend on type of service rendered.

    Ex:
    Inbound Call Centre - Sales with competitor
    SL = (Calls Answered Within threshold)/(Calls Answered + Calls Abandoned)
    This is often called exclusive SL, and considers all unanswered calls and calls answered after the threshold against SL.

    Inbound Call Centre - Helpdesk (considers short abandon as customer not requiring immediate assistance)
    SL = ((Calls Answered + Calls Abandoned)-(Calls Answered after Threshold + Calls Abandoned after Threshold))/(Calls Answered + Calls Abandoned)
    This is often called inclusive SL, and considers only calls that went beyond threshold as counting against SL.

    ISP - Percentage of time that network is up and meeting required speed etc.
    So if network is up 100% of the time, but network quality was below threshold 20% of the time. SL is considered at 80%. Though interpretation can vary.

    On top of SL, SLA will consider quality requirement, 1st contact resolution rate, interval SL (1 hour interval, daily, weekly, monthly etc) among other things.

+ 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. Create a function to create a new excel file
    By srbelle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2015, 07:04 AM
  2. Replies: 7
    Last Post: 09-29-2014, 09:24 AM
  3. Replies: 4
    Last Post: 12-28-2012, 03:11 AM
  4. Replies: 3
    Last Post: 06-27-2012, 02:25 PM
  5. Replies: 3
    Last Post: 09-30-2011, 04:35 AM
  6. Replies: 1
    Last Post: 07-16-2009, 09:14 PM
  7. Replies: 2
    Last Post: 08-18-2006, 07:20 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