Results 1 to 7 of 7

Percentage Not Calculating Correctly

This is a discussion on Percentage Not Calculating Correctly within the Excel Questions forums, part of the Question Forums category; I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is ...

  1. #1
    New Member
    Join Date
    May 2008
    Posts
    5

    Default Percentage Not Calculating Correctly

    I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is taking four different data inputs and adding them up to figure out what percentage of that work type as it relates to the average processing times. This is the formula that I am using for 510K the bottom

    =((AK11/(AK14/'Workload Distribution'!F13))*(AK9)/(SUM(AK9:AN9)))

    F13 being the average processing time of 5 hours.

    What I don't understand is the second field for Internal Requests is:

    =((AK11/(AL14/'Workload Distribution'!G13))*((AL9)/(SUM(AK9:AN9))))

    The percentage that is coming out seems to be problem because when I manually put the percentage in it calculates fine. If I do not the values come out the same even though they are not. Can someone explain to me what I am doing wrong. Thank you very much.

    May
    510kInternal RequestsEIRPMA
    18300
    Required Monthly Hours
    146
    Hours Logged by Work Type
    510kInternal RequestsEIRPMA
    90900
    Actions Needed by Work Type
    510kInternal RequestsEIRPMA
    1146494
    Break Down Total
    PagesBoxesAvg Page TotalAvg Box Total
    302093020162
    Hourly Breakdown by Work Type
    510kInternal RequestsEIRPMA
    6.946.94
    Last edited by TRAQ; May 29th, 2008 at 09:08 AM.

  2. #2
    New Member
    Join Date
    May 2008
    Posts
    5

    Default Re: Percentage Not Calculating Correctly

    I am using Excel 2003. Thanks for the help.

  3. #3
    New Member
    Join Date
    May 2008
    Posts
    5

    Default Re: Percentage Not Calculating Correctly

    Quote Originally Posted by TRAQ View Post
    I am having the hardest time understanding what is going on with my spreadsheet. I have a spreadsheet that is taking four different data inputs and adding them up to figure out what percentage of that work type as it relates to the average processing times. This is the formula that I am using for 510K the bottom

    =((AK11/(AK14/'Workload Distribution'!F13))*(AK9)/(SUM(AK9:AN9)))

    F13 being the average processing time of 5 hours.

    What I don't understand is the second field for Internal Requests is:

    =((AK11/(AL14/'Workload Distribution'!G13))*((AL9)/(SUM(AK9:AN9))))

    The percentage that is coming out seems to be problem because when I manually put the percentage in it calculates fine. If I do not the values come out the same even though they are not. Can someone explain to me what I am doing wrong. Thank you very much.

    May
    510kInternal RequestsEIRPMA
    18300
    Required Monthly Hours
    146
    Hours Logged by Work Type
    510kInternal RequestsEIRPMA
    90900
    Actions Needed by Work Type
    510kInternal RequestsEIRPMA
    1146494
    Break Down Total
    PagesBoxesAvg Page TotalAvg Box Total
    302093020162
    Hourly Breakdown by Work Type
    510kInternal RequestsEIRPMA
    6.946.94

  4. #4
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    10,725

    Default Re: Percentage Not Calculating Correctly

    Nice image. How does one connect the various pieces of what I assume are worksheet ranges to the formula you posted?

  5. #5
    New Member
    Join Date
    May 2008
    Posts
    5

    Default Re: Percentage Not Calculating Correctly

    Sorry about that. The horizontal axis columns are AK, AL, AM, AN and the vertical axis rows begin at 7 (MAY) and end at 23 (6.94). Hope this clarifies it for you. Thanks for the help.

  6. #6
    Board Regular
    Join Date
    Dec 2006
    Posts
    201

    Default Re: Percentage Not Calculating Correctly

    What is G13??? In your second equation???

  7. #7
    New Member
    Join Date
    May 2008
    Posts
    5

    Default Re: Percentage Not Calculating Correctly

    G13 is the number 3 which indicates the time it takes to complete one internal request action.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com