include that weekends are free

  • Re: include that weekends are free


    Just one more question
    how is it done that from lets say from current date till latest deadline in table
    I'd like to know how many pages can translator translate(from current date till latest deadline or maybe till each deadline would be even better)

  • Re: include that weekends are free


    for instance in collumn R enter
    =NETWORKDAYS(TODAY();F2)*6


    where today() is today (or replace by any given date)
    F2 is the deadline
    6 is the number of pages per day


    if you are going to insert a collumn for this more to the left you might need to adjust the sorting macros!

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  • Re: include that weekends are free


    Ok with tis I get how many pages can he translate from today till deadline for each document but this doesnt include that other document are in process so I guess i should decrease the capcity of =NETWORKDAYS(TODAY();F2)*6 with =NETWORKDAYS(TODAY();F3)*6 to give me right result or something like that


    thnx

  • Re: include that weekends are free


    Ok with tis I get how many pages can he translate from today till deadline for each document but this doesnt include that other document are in process so I guess i should decrease the capcity of =NETWORKDAYS(TODAY();F2)*6 with =NETWORKDAYS(TODAY();F3)*6 to give me right result or something like that


    thnx

  • Re: include that weekends are free


    try deducting collumn Q from collumn F. that should give you the remaining capacity

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  • Re: include that weekends are free


    the attached version will show you free / busy time in a chart

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  • Re: include that weekends are free


    how do i deduct column G from column Q (there are dates in this columns)
    and when i write =Q2-F2 or F2-Q2 i get an error


    thnx

  • Re: include that weekends are free


    I am sure you are getting ################ which is not an error. It is just so that the result cannot be displayed in the given format. Change the number format from Date to something else.

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  • Re: include that weekends are free


    a negativ value shows how many days ahead of scedule (deadline) a job will be completed. Apositiv how long the delay would be.

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  • Re: include that weekends are free


    this formula in line 6 will give you the number off pages that could still be assigned till the start of the next task (the one on line 7 in this case). If you copy this accross all lines the calculated figures will correspond with the gaps in the chart i have put up for you.
    if you enter a task with zero pages starting today with any deadline you will get the remaining capacity of that agent.


    =IF(B7=B6;(O7-Q6)/(1/6);(M6-Q6)/(1/6))

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  • Re: include that weekends are free


    yes, you will. the sorting not only looks at the translators but also at the dates. The date part of the sort is still needed. the name part will just not have any effect.

    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

Participate now!

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