PDA

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