Planning machines with dependencies- based on start date and duration

    Quote

    Quick question about Column J you say Hours-Minutes ... what about Rows 33 and 38 ... with 60.94 ???

    - It is 60 hours, yes, although I suspect production manager has exagerated excution time for that particular item...


    60 Hours OK ... but what about 94 MINUTES ... !!!!


    For sure SAP is NOT CAPABLE to convert MINUTES into HOURS ... !!! Che Casino ...!!!

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Carim, I have opened it, looked into it, saw the index/aggregate and row formula you used.

    It is more than I expected, realy.

    You took the time to help me, to guide me. LOL, it may have seemd I didn't wrote a formula in my life, but I was at lost, stuck in the "graph/Gantt have to do them".


    I highly appreciate your time spent to reply to me, look into my file, your input, and not lastly your help and final file.

    I only hope I can soon give something back to this forum :)


    BIG thank you!!!

    Thanks a lot for your very kind words ... for your Thanks AND for the Like 8)


    Glad to hear the latest version can help you out ... :)


    If you manage to better "decode" the Raw Data ... mainly Columns B and J ...

    we could even end up with a fully automated process which would go beyond the automatic sorting based on the Priorities ...


    Let me know if you feel like "digging further" ... ;)

    By the way ... if you ever need to Convert SAP Casino Decimal Time hh . mm into an Excel Actual Time hh : mm

    in sheet Raw Data, in cell K2, you can use following formula :

    Code
     =(INT(J2)/24)+ROUNDUP(J2-INT(J2),2)/14.4

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Edited once, last by Carim: Added time conversion formula ().

    Love 1
    Quote from Carim

    If you manage to better "decode" the Raw Data ... mainly Columns B and J ...

    we could even end up with a fully automated process which would go beyond the automatic sorting based on the Priorities ...


    Let me know if you feel like "digging further" ... ;)

    Of course I want to digg further. It is something I am passionate about, besides the need to have a good planning tool (which I already have :) )

    If we can improve and automate further and you are willing to help, I'm in! 8) :)

    By the way ... if you ever need to Convert SAP Casino Decimal Time hh . mm into an Excel Actual Time hh : mm

    in sheet Raw Data, in cell K2, you can use following formula :

    Code
     =(INT(J2)/24)+ROUNDUP(J2-INT(J2),2)/14.4


    1.Sooo I already adjusted excel hh:mm hours format in K2 thanks to your formula (which I have yet to fully understand)

    2. What do you mean exactly with adjusting column B? What would column B need as dates? As they are these are the dates I input order in the system. But please tell me what you need that date to be and I will give you the file with correct column B :)

    There it is :)

    we now have a K2 column namned Real duration (with correct format).

    Now the Duration in DATA sheet picks up duration automatically as other ocolumns do.

    I can work on column B if you give me suggestion about what you need column B to be ;)

    thank you

    You are digging SOO FAST ... :love:


    I can't keep up with your crazy rhythm !!! 8o


    The main issue, for you, is to make sure the ideal sequence is displayed as much as possible in sheet Raw Data ... since it feeds into Data and directly into Gantt ...


    Now if you do need to modify Priorities in sheet Data ... ( you have already noticed Sorting is performed as you go ...)

    hopefully you can easily ( if not automatically ...) adjust both Start and End Dates ... in order to achieve an error-free Gantt ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    Quote

    You are digging SOO FAST ... :love:


    I can't keep up with your crazy rhythm !!! 8o

    LOOOL, I know ahaha it is my day off soooo 8o 8) :S :)


    Well noted for what I have to work on.

    thank you Carim, will give you now a break untill..tomorrow ^^

    Quote from clairexcel

    LOOOL, I know ahaha it is my day off soooo 8o 8) :S :)


    Well noted for what I have to work on.


    thank you Carim, will give you now a break until...tomorrow ^^

    Too Kind of You !!! Have a Nice Evening :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi Carim , here I am after more than a month using your very helpful gantt.

    I do have a problem though with the file, and I really hope you can help me solve it.

    It works fine except for the sorting out priorities macro.

    CLAIRE EXCEL GANTT -PRIORITY NOT SORTING RAWS CORRECTLY.xlsmCLAIRE EXCEL GANTT -PRIORITY NOT SORTING RAWS CORRECTLY.xlsm

    I mean when I try to change the priority number the macro sorts out numbers in culmn A and N (the priority columns for both machines).

    BUt it does not sort out the adiacent items columns accordingly.

    For example ( attached file). If I want to put as priority n. 1 Item 13 (which is now n. 7 in column A) and want to put Item 1 as priority 7 instead, macro changes and sorts correctly priority numbers in column A, but Item 13 remains with priority number 7 (row 8) as it was...


    Can you please help me out?

    It is very important that I can change priorities, but it has to change all columns accordingly. Item 13 should now be priority n. 1.. Otherwise I have to cut and paste rows, and it is not manageable..

    thank you very much in advance!CLAIRE EXCEL GANTT -PRIORITY NOT SORTING RAWS CORRECTLY.xlsm

    I made various trials since yesterday. The reason macros do not sort all the columns in the defined range is because those columns , B to G, and I, take data from the RAW Data sheet.

    These columns have the following formula in the cells as they have to refer to data in RAW DATA sheet :

    =If. Error(@INDEX('Raw Data'!C:C;AGGREGATE(15;6;ROW('Raw Data'!$A$2:$A$100)/('Raw Data'!$A$2:$A$100=$B$2);ROWS(A$2:A2)));"")


    I tried one thing: I copied and then pasted only values (in sheet data) so there was no more formula in the DATA sheet; in this case the macros and change event worked fine, and automaticaly sorted all data according to the priority number I assing in column A.

    Question remains: How do I make change event/macros work with the formula in the cells though? Because sheet DATA has to "feed" form RAW DATA sheet..


    Any help or sugestions please? thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login