Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Keeping track of the order things are entering and exiting a

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would like to know if excel can help me?

    I have 4 bins. Entering the four bins are noodles from 8 kettles. Exiting the bins are noodles of different quantities in kg. I need to keep track of when a kettle ends in a bin and when the other begins. Eg.

    On Monday from Kettle 6, 2000kg of noodles enter Bin 1. On Monday 1000kg exit bin 1 so I have 1000kg left in bin1. On Tuesday 50kg enter bin 1 from kettle 7 but 1050kg exit bin 1 on Tueday. I need to keep track when kettle 6 finished by denoting zero and when kettle 7 began.


    This is a straight forward eg but it gets complicated by using different amounts. I know there can only be 5 different kettles entering on a week basis so my cells are limited and I need to track it for the year on a monthly basis.

    If anyone understands my problem can u please help

    Thanks

    Sky


  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Ponder:
    Sample data (table layout) and what formulas you are using with a clear description of what is the problem and why the formula you are using is not working will be big help!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

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
  •