+ Reply to Thread
Results 1 to 2 of 2

Percentage of Amount completed Daily per month.

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Tampa, Fl
    MS-Off Ver
    Excel 2010
    Posts
    8

    Percentage of Amount completed Daily per month.

    Hello all,
    This one might be a tough one. Here is my scenario. We do 'X' amount of "Jobs" a Month. They vary from month to month. My boss wants to know the percentage of jobs done to date each month. The twist is he wants them based out of 100% daily. Meaning if we are on the 10th day and there are 20 work days, and 50 "Jobs", if we've competed 25 "Jobs" it should reflect 100% compliance.12 jobs completed would show %50 etc. It's hard for me to explain. But I will try my best to answer any and all questions.

    Our issue is that we are going through the "jobs" too quickly and during the later days of the month are being with less to do. We are hoping this will help us "budget" our time and "jobs."

    -We always know how many "Jobs" are going to be in the Month
    -The amount of "Jobs" are Different Monthly
    -We only perform "Jobs" m-f (5days)


    Danny
    Last edited by Danib1227; 10-21-2013 at 09:34 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Percentage of Amount completed Daily per month.

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. 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

+ 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. Help with finding the percent completed daily
    By Tanith71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2013, 12:34 PM
  2. Percentage Completed Reference...
    By DMA-Pacific in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-21-2011, 04:27 AM
  3. Percentage Completed with Checkboxes....
    By DMA-Pacific in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2011, 10:41 AM
  4. Percentage of entries completed
    By lfb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2011, 04:34 AM
  5. Calculating the Percentage Completed
    By KyrithAZ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-13-2006, 03:40 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