+ Reply to Thread
Results 1 to 6 of 6

Calculation of Peak license usage in a given interval

Hybrid View

  1. #1
    Registered User
    Join Date
    10-24-2018
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    3

    Calculation of Peak license usage in a given interval

    Hi Everyone,
    The query is two fold.
    1) To be able to plot the license usage in a given day
    2) To be able to get the peak of the license usage on the given day
    I have the following data available for five days
    1) Check out time of of the License- Format(10/19/2018 7:37:47 PM)
    2) Check in time of the License
    3) No. of ports checked out.

    With this, how will i be able to plot a graph which will show the overall license usage at any given time in those five days?
    If i am able to plot the above graph, i am sure i will be able to get the peak with in any given interval.

    Please help me.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Calculation of Peak license usage in a given interval

    Can you attach a sample workbook mocking up what you are trying to achieve.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Registered User
    Join Date
    10-24-2018
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    3

    Re: Calculation of Peak license usage in a given interval

    Attaching sample file with expected output
    Attached Files Attached Files

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Calculation of Peak license usage in a given interval

    Try in H2 and fill down.

    Formula: copy to clipboard
    =SUMIFS(C:C,A:A,"<="&G2,B:B,">="&G2)


    In the attached is an XY scatter chart. It's a bit w i d e due to the date / time formats of the X axis, but this should give you a start.

    Edited Forgot to attach workbook.
    Last edited by FlameRetired; 10-24-2018 at 11:37 PM.
    Dave

  5. #5
    Registered User
    Join Date
    10-24-2018
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    3

    Re: Calculation of Peak license usage in a given interval

    Thank you very much Dave. it just worked perfect!!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: Calculation of Peak license usage in a given interval

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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. Replies: 12
    Last Post: 06-14-2017, 10:35 AM
  2. The average peak usage time and day for customer's calls
    By OliverM23 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2015, 10:13 AM
  3. Replies: 6
    Last Post: 05-01-2015, 12:02 PM
  4. Replies: 5
    Last Post: 05-18-2013, 11:59 AM
  5. Finding peak usage times
    By afitzwater in forum Excel General
    Replies: 2
    Last Post: 01-04-2012, 05:19 PM
  6. Excel 2007 : Calculate Peak Usage of Vehicle
    By ttriola1 in forum Excel General
    Replies: 1
    Last Post: 02-04-2010, 08:57 PM
  7. Replies: 1
    Last Post: 03-13-2006, 07:27 PM

Tags for this Thread

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