+ Reply to Thread
Results 1 to 9 of 9

Raw Material tracking

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Post Raw Material tracking

    I am running a business which has raw material. It is consumed at a certain rate.
    I need help in making a small program in excel which answers how much raw material is available till what time, and how much is required till monday for example...................really appreciate any help
    God Bless
    Sajeel

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Raw Material tracking

    I think you might need to give us a bit more to work with...
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Raw Material tracking

    ok.................what I am looking for in excel is it should tell me the date and time till I have my raw material.

    for instance the raw material is sufficient for tomorrow @ 1400hrs as of today, how many kilos I need more to jump 3 days and 6 hrs.

    per hour consumption 429 KG.

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Raw Material tracking

    Please Login or Register  to view this content.
    ?

  5. #5
    Registered User
    Join Date
    07-06-2010
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Raw Material tracking

    Quote Originally Posted by Cheeky Charlie View Post
    Please Login or Register  to view this content.
    ?
    What I am doing is this

    16 8-Jul Thursday 36
    33 9-Jul Friday 45
    33 10-Jul Saturday 59
    11-Jul Sunday 35
    33 12-Jul Monday 64
    13-Jul Tuesday 40
    14-Jul Wednesday 16

    A = Time in Hours
    B = IF(D3>24,B3+1," ")
    C = day
    D = (IF(D3>24,D3-24,0))+A4



    I need help with this working

  6. #6
    Registered User
    Join Date
    07-06-2010
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Raw Material tracking

    Quote Originally Posted by sajeelqaiservohra View Post
    What I am doing is this

    16 8-Jul Thursday 36
    33 9-Jul Friday 45
    33 10-Jul Saturday 59
    11-Jul Sunday 35
    33 12-Jul Monday 64
    13-Jul Tuesday 40
    14-Jul Wednesday 16

    A = Time in Hours
    B = IF(D3>24,B3+1," ")
    C = day
    D = (IF(D3>24,D3-24,0))+A4



    I need help with this working












    33 8-Jul Thursday 53
    9-Jul Friday 29
    10-Jul Saturday 5
    33 Sunday 33
    #VALUE! Monday 9
    Tuesday 0
    44 Wednesday 44
    #VALUE! Thursday 20


    I get these errors in this model

    I am looking for a model that uses Time and Date or other commands for time tracking of raw material rather than "IF" commands
    awaiting response
    Regards
    Sajeel

  7. #7
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Raw Material tracking

    What are the meanings of each column?
    It would be better if you could upload an example
    Please don't quote entire messages in replies, just use reply. It would be good if you could remove all the quotes and spaces from the above posts.

  8. #8
    Registered User
    Join Date
    07-06-2010
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Raw Material tracking

    Quote Originally Posted by Cheeky Charlie View Post
    What are the meanings of each column?
    It would be better if you could upload an example
    Please don't quote entire messages in replies, just use reply. It would be good if you could remove all the quotes and spaces from the above posts.
    Column A = hours of raw material
    Column B = Date
    Column C = Day
    Column D = Time till the raw material is available

  9. #9
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Raw Material tracking

    Upload an example,
    Show what you have to start with
    Explain what you are trying to calculate and how
    Demonstrate with examples you have worked out manually

    Then I can help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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