Re: include that weekends are free
thank you very much for your patience and your time
Stay cool
Re: include that weekends are free
thank you very much for your patience and your time
Stay cool
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!
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
Re: include that weekends are free
the attached version will show you free / busy time in a chart
Re: include that weekends are free
thnx i will give it a try and let you know
stay cool
saban
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.
Re: include that weekends are free
ok thnx
Re: include that weekends are free
sorry for my stupidity but what exactly do i get if I deduct column F from column Q
Thnx
saban
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.
Re: include that weekends are free
aha thnx
Re: include that weekends are free
=C6/NETWORKDAYS(TODAY();F6;R6:S6)
Does this formula tells me how many pges can be done from today to deadline
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))
Re: include that weekends are free
thnx
Re: include that weekends are free
If I have separate sheet for each translator do i need that sort macro also?
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.
Re: include that weekends are free
ok thnx
stay cool
saban
Don’t have an account yet? Register yourself now and be a part of our community!