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
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
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
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
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
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
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