+ Reply to Thread
Results 1 to 11 of 11

Calculating Percentages for an Annual Report

  1. #1
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Post Calculating Percentages for an Annual Report

    good morning, i am trying to calculate percentages in excel, i am working on an annual report where the original report is generated for me with the proper percent. I have to remove numbers from the original and create a new percent, i am having trouble creating a new percent.i found that the percentage calculator is accurate but it takes to long with as many number as i have. below are some of the numbers so you can see what i am trying to accomplish. TIA

    With the percentage calculator i use the ____ is what percent of ____?
    SO in my report i have the numbers everything is based off of (below)

    Total Events- 8,597
    Events w RR Response- 5,209
    Total Arrivals- 5,389
    Total Activities- 12.878

    and the percentages i am trying to find for these numbers,


    Road Ranger Assisted Events BY Notifier

    CCTV - 2,365
    Road Ranger - 254
    Local PD - 54
    Fire - 12
    EMS - 68
    Local SO - 32

    I need to find the percent of Notifier events, in the percentage calculator i use

    Notifier is what percent of Events with Road Ranger Response
    Example - 2,365 is what % of 5,209? = 45.22%

    I would like to be able to input these numbers and use a formula to calculate the percentages fast than one at a time in the percentage calculator.

    Thank you so much, i hope this explains what i am trying to do.
    Attached Files Attached Files
    Last edited by tasha2515; 01-03-2018 at 02:05 PM. Reason: Had to

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,430

    Re: Percentages

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    • Use concise, accurate thread titles.
    • Your post title should describe your problem, not your anticipated solution.
    • Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    • Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Percentages

    Changed the title

  4. #4
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    19,970

    Re: Calculating Percentages for an Annual Report

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  5. #5
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Calculating Percentages for an Annual Report

    i will do that right now, thank you.

  6. #6
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Calculating Percentages for an Annual Report

    I have attached an example

  7. #7
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Calculating Percentages for an Annual Report

    I have also attached a photo of what the report looks like when it generates for me, before i have to recalculate after subtracting numbers.

  8. #8
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,093

    Re: Calculating Percentages for an Annual Report

    This is so basic, that I am not sure I understand exactly what the question is.

    1) Since understanding the math is critical to understanding the solution, I would suggest you start here http://www.purplemath.com/modules/percntof.htm with a basic tutorial of how to solve "per cent of" problems.
    2) Since "a is what per cent of b" boils down to a simple division (percent=a/b), enter that division in Excel. In your first attachment, I put =C15/$D$4 into a cell in row 15 and copied/filled down. One could also use C15/$C$32, if desired.

    I am not sure what help you need in going from the report (picture) in the second attachment to the first attachment.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  9. #9
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Calculating Percentages for an Annual Report

    i just needed a formula.

  10. #10
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Calculating Percentages for an Annual Report

    i have to pull two separate report like in the picture of the second attachment and subtract those numbers from each other. SO i will be needing a new percentage with the new numbers.

  11. #11
    Registered User
    Join Date
    08-02-2017
    Location
    milton, fl
    MS-Off Ver
    10
    Posts
    12

    Re: Calculating Percentages for an Annual Report

    thank you that works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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