Posts by saban123

    Re: find anywhere in A and B anything from C


    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



    If I put documents in this order than it works OK (Says "free")-that is with your previous example because I cant download the new one it is still corrupted


    Any ideas why is that
    thanks

    Re: find anywhere in A and B anything from C


    SKUPINA 1 48 6 BUDG 20/06/2006 26/06/2006
    SKUPINA 1 96 6 BUDG 19/06/2006 26/06/2006
    SKUPINA 1 144 6 BUDG 19/06/2006 27/06/2006

    Something is wrong at the last document translator can translate 144 pages


    But I get result "Zaseden"


    Any ideas why
    thnx

    Re: find anywhere in A and B anything from C


    thnx will let you know how it worked but it seems that documents should be sorted by date not by deadline to get right results but I dont know why is not always like that is there any method of sorting to show results 100% right

    Re: find anywhere in A and B anything from C


    Brr Now i think I got it the right results are when it is sorted by date
    The dates that documents are assigned should be in ascending order
    I am testing it further and will let you know


    but i have a problem with this sort macro it does not sort the data according to date (and I think the best would be to sort just values from A to G)
    here is the macro

    Code
    1. Application.Calculation = xlCalculationManual
    2. r = Range("c65536").End(xlUp).Row
    3. Range("a5:G" & r).Select
    4. Selection.Sort Key1:=Range("F5"), Order1:=xlAscending, Key2:=Range("G5") _
    5. , Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlDescending, Header:= _
    6. xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    7. DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
    8. xlSortNormal
    9. Rows("4:" & r).Select


    Actually the problem is that it wont replace row 5 with row 6 if bigger date is in row 5
    and can it colour just cells from A to G and not whole row
    what do you think ?

    Re: find anywhere in A and B anything from C


    I think I have 2 options one to sort by date and one to sort by deadline or do I have some other sort option


    And do you have any good sorting macro cause the xisting one sometimes doesnt want to sort (do you maybe know why is that)


    About this graph I will let you know how it worked
    thnx and stay cool

    Re: find anywhere in A and B anything from C


    there is a little problem with
    =IF(C19=0;0;IF(C19=1;B19*C19-D19;B19)) i think so not sure
    but it says C19=1 but what if C19=2 which in most cases is when capacity is not at MAX


    Now it only shows capacity at 100% (when column is colored light blue) and it would be nice if it would show also half or third.. of it


    Is there a way to set this axis where 0,10,20...60 to 48 instead of 60 -but it is optional


    thnx man for all your help
    saban

    Re: find anywhere in A and B anything from C


    thnx man u rule


    There is just one more thing that I would like to ask u: What is with this sort buttons are they necessary or can use this without sort buttons


    thnx again and stay cool
    saban



    Could u upload file again I get this error that file is corupted
    thnx

    Re: find anywhere in A and B anything from C


    Can you plizz check this


    nr of pages: 40 date: 16/06/2006 deadline: 19/06/2006


    2nd document
    nr of pages: 200 date: 20/06/2006 deadline: 26/06/2006


    this should be maximum right


    I think something aint right I get "zaseden"


    thnx
    saban

    Re: find anywhere in A and B anything from C


    Tried this formula in Column R but I think i do not get the right result either
    for date
    nr of p pg/day date assigned deadline cap till rok
    40 6 16/06/2006 19/06/2006
    199 6 19/06/2006 25/06/2006 [COLOR="Red"]40[/COLOR]
    Instead of 41 it should said 1


    Cause if I write nr.of pages 201 i get zaseden so ther is no more than one more page that translator can get


    thnx

    Re: find anywhere in A and B anything from C


    I have dealt with #VALUE with conditonal formatin so now U can not see the error but it is still there but that will do.
    But it would be cool if I corrected that error I dont quite get which formulas should i correct to remove this #VALUE error(Maybe then it would also calculate faster cause now I have extended formulas to cell 2000 in each column and must say it works pretty slowly when it is calculating)


    Is this remainig capacity working ok even on long periods because if I write 22/06/2006 and dealine on 27/07/2006 I dont get right remainig capacity


    and thnx for everything

    Re: find anywhere in A and B anything from C


    This reall y works as I wanted reall ycool


    Only have 2 more questions and that is it


    Did you notice when you put record in and the number of pages is at maximum
    you get "prost"(free) at all the cells in column where availability is shown is that OK or not ( try it: insert date lets say 20/06/2006 and 21/06/2006 and nr of pages is 48(at group where size is 8 people) and you will see that all column is filled with "prost"(green color), but if nr of pages is not at max then U get an error #VALUE - normally because no data are in that row


    and other question is: How could I include some chart on separate sheets which shows me how much is one group busy in current week (in % maybe)
    Would that be useful to know what do you think


    thnx man for all your help
    stay cool and hope to hear from you soon
    saban