Results 1 to 2 of 2

Thread: Division Function and/or QUOTIENT function in Excel with dynamic divisor (denominator

  1. #1
    Neophyte HansrajR's Avatar
    Join Date
    May 2021
    Posts
    1
    Articles
    0
    Excel Version
    365

    Division Function and/or QUOTIENT function in Excel with dynamic divisor (denominator



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am seeking to calculate Number of Processing Days based on a daily quota.

    As long as the daily quota is constant, the calculation is simple i.e. Tonnage divided by the daily quota (as in Figure 1) gives the Number of days required to process the batch.

    The result from the division above added to the Processing start date gives the processing End Date.

    The calculation becomes complex when the daily quota changes along the days and the Processing End Date is unknown.

    I am looking for a iterative formula to use in Excel to calculate the Number of Processing Days which accounts for changes in daily quota available in another table.

    Click image for larger version. 

Name:	Pmlw9.png 
Views:	14 
Size:	33.6 KB 
ID:	10506

    Figure 1

    A method of calculating Number of Days to process Batch A accurate to decimal places is preferred.


    In the example, the 4th day will not be used completely to finish processing Batch A.

    The implication of calculating number of processing days correct to decimal places is to determine the Processing Start Date of the next Batch B.

    On event, number of processing days of Batch A is an integer implying the whole day will be exhausted, and therefore the Processing date of the next Batch B will be Processing End Date of Batch A plus one day.

    Else, if number of processing days of Batch A has decimals, this will imply the last day will not be exhausted completely and Processing Start Date of Batch B will be on the same date as Processing End Date of Batch A as illustrated in Figure 2.

    Click image for larger version. 

Name:	Pmlw91.png 
Views:	15 
Size:	36.8 KB 
ID:	10507

    Figure 2




  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,123
    Articles
    0
    Excel Version
    365
    cross posted without links:
    Division Function and/or QUOTIENT function in Excel with dynamic divisor (denominator) from Table changing by Criteria | MrExcel Message Board
    https://www.mrexcel.com/board/thread...teria.1171350/
    (1) Division Function and/or QUOTIENT function in Excel with dynamic divisor (denominator) from Table changing by Criteria | Chandoo.org Excel Forums - Become Awesome in Excel
    https://chandoo.org/forum/threads/di...riteria.46312/

    HansrajR, (I realise you already know this from messages at the other sites but the guidelines are the same here) for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

    I see you are getting good help already at Chandoo…

Tags for this Thread

Posting Permissions

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