+ Reply to Thread
Results 1 to 7 of 7

Bucket filling based on range of values

  1. 06-08-2012, 02:51 PM #1
    rushabh21
    rushabh21 is offline
    Registered User
    Join Date
    06-08-2012
    Location
    DC area, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Bucket filling based on range of values

    Hi, I have a complex problem.
    There are range of values

    Range Min Max
    A 0 5000
    B 5000 10,000
    C 10,000 10,000,000


    There are loan number sorted in certain way with their AMOUNT
    L1 = 1000
    L2 = 5000
    L3 = 6000


    Problem:
    Find the Range value for each loan. and its overflow..

    In case of loan 2...I need to find out how much of L2 can fit in range A before it remaining moves to Range B.
    So in above case, I should get
    L1 is Range A
    L2 is Range A for 4000
    L2 is Range B for 1000
    L3 is Range B for 4000
    L3 is Range C for 2000

    Based on Range value, there are other columns which are suppose to be used in calculation appropriately.
    Last edited by rushabh21; 06-08-2012 at 03:14 PM.
    Reply With QuoteRegister To Reply
  2. 06-08-2012, 02:55 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Bucket filling based on range of values

    You get better help if you post your exel example (without confidential information).

    Why is L2 Rang B 1000? (I shoud say 5.000)
    Reply With QuoteRegister To Reply
  3. 06-08-2012, 03:07 PM #3
    rushabh21
    rushabh21 is offline
    Registered User
    Join Date
    06-08-2012
    Location
    DC area, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Bucket filling based on range of values

    Assume the Ranges are buckets... You pour the loan amount in a sequence L1, L2 and L3...
    I can fit L1 100% in Range A
    L2 fits 4000 in Range A and the bucket of Range A is full
    L2 remaining $1000 then fill Range B...
    and so on..

    Thus L2 has hit 2 ranges and I need to know which 2 ranges and how much $$ in each range..

    As for Excel Spreadsheet...let me see if I could upload..
    Reply With QuoteRegister To Reply
  4. 06-08-2012, 04:28 PM #4
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Bucket filling based on range of values

    Your given data seems to be contradictory ...

    See if this workbook helps.

    Put your "Bucket Sizes" in H1:J1 in descending order, and some values in Column F.
    Attached Files Attached Files
    Last edited by Marcol; 06-08-2012 at 04:38 PM.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
    Reply With QuoteRegister To Reply
  5. 06-26-2012, 03:17 PM #5
    rushabh21
    rushabh21 is offline
    Registered User
    Join Date
    06-08-2012
    Location
    DC area, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Bucket filling based on range of values

    Hi Marcol,
    I think what you put in the spreadsheet is right. But could you automatically print the rows A8 to A12.
    How to spit-out one loan into 2 rows is very challenging to me.


    I also have my spreadsheet if you prefer following that one
    See attached.
    Thanks a lot for helping. I think you we are closer

    Also NOTE: this formula will then apply for 40k loans in my application.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 06-27-2012, 11:12 AM #6
    rushabh21
    rushabh21 is offline
    Registered User
    Join Date
    06-08-2012
    Location
    DC area, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Bucket filling based on range of values

    Anyone else ...please help
    Reply With QuoteRegister To Reply
  7. 07-02-2012, 10:11 AM #7
    rushabh21
    rushabh21 is offline
    Registered User
    Join Date
    06-08-2012
    Location
    DC area, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Bucket filling based on range of values

    Please help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1