View Full Version : why i dont get 100% correct results
saban
06-20-2006, 08:16 AM
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
lucas
06-20-2006, 08:27 AM
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.....
lenze
06-20-2006, 03:11 PM
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
saban
06-21-2006, 01:52 AM
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
lucas
06-21-2006, 06:25 AM
Please give an example of how we can duplicate the error on the sample you have provided......
saban
06-21-2006, 08:11 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.