Consulting

Results 1 to 6 of 6

Thread: why i dont get 100% correct results

  1. #1
    VBAX Mentor
    Joined
    Jan 2006
    Posts
    348
    Location

    why i dont get 100% correct results

    Can someone plizz look at this example and maybe figure out why it is not working right

    I will explain details later as I dont have time right now

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    You should really take the time to explain to us what the problem is. No one is going to sift through a file like this looking for problems when you already know where it is.....
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    VBAX Regular
    Joined
    Mar 2005
    Location
    Helena, MT
    Posts
    90
    Location
    Without looking at your file, it sounds like you are talking about rounding errors and percision problems. Perhaps this will help
    http://www.cpearson.com/excel/rounding.htm

    It's an old article, but still applies.

    lenze

  4. #4
    VBAX Mentor
    Joined
    Jan 2006
    Posts
    348
    Location
    Well it is like this:

    There is a group of 8 translators and each translator can translate 6 pages/day
    I assign document to the group filling the cells with nr of pages date that document was assigned and deadline till when document must be finished
    In column J I get result "Zaseden" - this means the group is occupied and if result is "Prost" - means group is free

    but for some instances I dont get right results ex:
    SKUPINA 4 96 6 BUDG 19/06/2006 26/06/2006
    SKUPINA 4 48 6 BUDG 20/06/2006 26/06/2006
    SKUPINA 4 144 6 BUDG 19/06/2006 27/06/2006

    Tell me if you need to know something more
    thnx

  5. #5
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Please give an example of how we can duplicate the error on the sample you have provided......
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  6. #6
    VBAX Mentor
    Joined
    Jan 2006
    Posts
    348
    Location
    type in the entries as folows
    SKUPINA 4 96 6 BUDG 19/06/2006 26/06/2006
    SKUPINA 4 48 6 BUDG 20/06/2006 26/06/2006
    SKUPINA 4 144 6 BUDG 19/06/2006 27/06/2006

    Starting below headers
    put :
    Skupina 4 in A5 then nr of pages in B5 (96) type capcity per head in C5
    you can omit "BUDG" and then Date and deadline

    Just type data as above starting in A5 and you will see that group of 8 translators can translate those 3 documents but i get value "Zaseden" in J which means occupied so group is not able to translate those 3 documents but it should if groups capacity is 48 pages/day

    Is that what you wanted to know or did I misunderstood you

    thnx
    saban

Posting Permissions

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